observations
0 rows where annotations = "[{"uuid": "1a4cd2cc-378b-4807-9b75-4046c28b6295", "controlled_attribute_id": 1, "controlled_value_id": 2, "concatenated_attr_val": "1|2", "vote_score": 0, "user_id": 5983024, "votes": [], "user": {"id": 5983024, "login": "joesjoes20", "spam": false, "suspended": false, "created_at": "2022-08-02T03:29:53+00:00", "login_autocomplete": "joesjoes20", "login_exact": "joesjoes20", "name": "joesjoes20", "name_autocomplete": "joesjoes20", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/5983024/thumb.jpg?1673259462", "observations_count": 172, "identifications_count": 29963, "journal_posts_count": 1, "activity_count": 30136, "species_count": 81, "universal_search_rank": 172, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/5983024/medium.jpg?1673259462"}}, {"uuid": "10e8aa07-5b3f-4fc5-82a8-4c5223cf3d1a", "controlled_attribute_id": 17, "controlled_value_id": 18, "concatenated_attr_val": "17|18", "vote_score": 0, "user_id": 5983024, "votes": [], "user": {"id": 5983024, "login": "joesjoes20", "spam": false, "suspended": false, "created_at": "2022-08-02T03:29:53+00:00", "login_autocomplete": "joesjoes20", "login_exact": "joesjoes20", "name": "joesjoes20", "name_autocomplete": "joesjoes20", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/5983024/thumb.jpg?1673259462", "observations_count": 172, "identifications_count": 29963, "journal_posts_count": 1, "activity_count": 30136, "species_count": 81, "universal_search_rank": 172, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/5983024/medium.jpg?1673259462"}}, {"uuid": "c3382127-1d61-4d08-af82-3f6d39867b57", "controlled_attribute_id": 22, "controlled_value_id": 24, "concatenated_attr_val": "22|24", "vote_score": 0, "user_id": 5983024, "votes": [], "user": {"id": 5983024, "login": "joesjoes20", "spam": false, "suspended": false, "created_at": "2022-08-02T03:29:53+00:00", "login_autocomplete": "joesjoes20", "login_exact": "joesjoes20", "name": "joesjoes20", "name_autocomplete": "joesjoes20", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/5983024/thumb.jpg?1673259462", "observations_count": 172, "identifications_count": 29963, "journal_posts_count": 1, "activity_count": 30136, "species_count": 81, "universal_search_rank": 172, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/5983024/medium.jpg?1673259462"}}]"
This data as json
annotations 0 ✖
0 records
CREATE TABLE [observations] ( [place] TEXT REFERENCES [places]([slug]), [taxon] INTEGER REFERENCES [taxons]([id]), [quality_grade] TEXT, [time_observed_at] TEXT, [taxon_geoprivacy] TEXT, [annotations] TEXT, [uuid] TEXT, [observed_on_details] TEXT, [id] INTEGER PRIMARY KEY, [cached_votes_total] INTEGER, [identifications_most_agree] INTEGER, [created_at_details] TEXT, [species_guess] TEXT, [identifications_most_disagree] INTEGER, [tags] TEXT, [positional_accuracy] INTEGER, [comments_count] INTEGER, [site_id] INTEGER, [created_time_zone] TEXT, [license_code] TEXT, [observed_time_zone] TEXT, [quality_metrics] TEXT, [public_positional_accuracy] INTEGER, [reviewed_by] TEXT, [oauth_application_id] TEXT, [flags] TEXT, [created_at] TEXT, [description] TEXT, [time_zone_offset] TEXT, [project_ids_with_curator_id] TEXT, [observed_on] TEXT, [observed_on_string] TEXT, [updated_at] TEXT, [sounds] TEXT, [place_ids] TEXT, [captive] INTEGER, [ident_taxon_ids] TEXT, [outlinks] TEXT, [faves_count] INTEGER, [ofvs] TEXT, [num_identification_agreements] INTEGER, [preferences] TEXT, [comments] TEXT, [map_scale] TEXT, [uri] TEXT, [project_ids] TEXT, [community_taxon_id] INTEGER, [geojson] TEXT, [owners_identification_from_vision] INTEGER, [identifications_count] INTEGER, [obscured] INTEGER, [num_identification_disagreements] INTEGER, [geoprivacy] TEXT, [location] TEXT, [votes] TEXT, [spam] INTEGER, [user] TEXT, [mappable] INTEGER, [identifications_some_agree] INTEGER, [project_ids_without_curator_id] TEXT, [place_guess] TEXT, [identifications] TEXT, [project_observations] TEXT, [observation_photos] TEXT, [photos] TEXT, [faves] TEXT, [non_owner_ids] TEXT );