observations
0 rows where annotations = "[{"uuid": "f9197e5e-60db-4db5-8df4-cfd1a3b6e780", "controlled_attribute_id": 12, "controlled_value_id": 13, "concatenated_attr_val": "12|13", "vote_score": 0, "user_id": 521910, "votes": [], "user": {"id": 521910, "login": "adamschneider", "spam": false, "suspended": false, "created_at": "2017-07-01T17:43:41+00:00", "login_autocomplete": "adamschneider", "login_exact": "adamschneider", "name": "Adam Schneider", "name_autocomplete": "Adam Schneider", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/521910/thumb.jpg?1646029945", "observations_count": 4790, "identifications_count": 26805, "journal_posts_count": 0, "activity_count": 31595, "species_count": 1795, "universal_search_rank": 4790, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/521910/medium.jpg?1646029945"}}, {"uuid": "bdfbbb92-3043-4b9a-9562-dfaa3f34ae70", "controlled_attribute_id": 12, "controlled_value_id": 14, "concatenated_attr_val": "12|14", "vote_score": 0, "user_id": 521910, "votes": [], "user": {"id": 521910, "login": "adamschneider", "spam": false, "suspended": false, "created_at": "2017-07-01T17:43:41+00:00", "login_autocomplete": "adamschneider", "login_exact": "adamschneider", "name": "Adam Schneider", "name_autocomplete": "Adam Schneider", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/521910/thumb.jpg?1646029945", "observations_count": 4790, "identifications_count": 26805, "journal_posts_count": 0, "activity_count": 31595, "species_count": 1795, "universal_search_rank": 4790, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/521910/medium.jpg?1646029945"}}]"
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 );