observations
0 rows where annotations = "[{"uuid": "a4c38753-d4d5-4f45-8a3e-1cf6a8a7e7b7", "controlled_attribute_id": 12, "controlled_value_id": 13, "concatenated_attr_val": "12|13", "vote_score": 0, "user_id": 781032, "votes": [], "user": {"id": 781032, "login": "morganstickrod", "spam": false, "suspended": false, "created_at": "2018-03-05T04:58:45+00:00", "login_autocomplete": "morganstickrod", "login_exact": "morganstickrod", "name": "Morgan Stickrod", "name_autocomplete": "Morgan Stickrod", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/781032/thumb.jpg?1611126889", "observations_count": 17082, "identifications_count": 167870, "journal_posts_count": 0, "activity_count": 184952, "species_count": 6815, "universal_search_rank": 17082, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/781032/medium.jpg?1611126889"}}]"
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 );