observations
0 rows where annotations = "[{"uuid": "2d9ea822-59e7-45c7-bccb-cdae4a1168ef", "controlled_attribute_id": 12, "controlled_value_id": 13, "concatenated_attr_val": "12|13", "vote_score": 0, "user_id": 209572, "votes": [], "user": {"id": 209572, "login": "truthseqr", "spam": false, "suspended": false, "created_at": "2016-04-03T21:40:29+00:00", "login_autocomplete": "truthseqr", "login_exact": "truthseqr", "name": "Anne Parsons", "name_autocomplete": "Anne Parsons", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/209572/thumb.jpg?1491681286", "observations_count": 42875, "identifications_count": 104555, "journal_posts_count": 55, "activity_count": 147485, "species_count": 2042, "universal_search_rank": 42875, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/209572/medium.jpg?1491681286"}}, {"uuid": "d23a4134-e896-4d2e-a142-5333d1a642e3", "controlled_attribute_id": 12, "controlled_value_id": 15, "concatenated_attr_val": "12|15", "vote_score": 0, "user_id": 209572, "votes": [], "user": {"id": 209572, "login": "truthseqr", "spam": false, "suspended": false, "created_at": "2016-04-03T21:40:29+00:00", "login_autocomplete": "truthseqr", "login_exact": "truthseqr", "name": "Anne Parsons", "name_autocomplete": "Anne Parsons", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/209572/thumb.jpg?1491681286", "observations_count": 42875, "identifications_count": 104555, "journal_posts_count": 55, "activity_count": 147485, "species_count": 2042, "universal_search_rank": 42875, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/209572/medium.jpg?1491681286"}}]"
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 );