observations
0 rows where comments = "[{"id": 14863735, "uuid": "868ebc67-2010-48c2-9267-7ad42ac7ade1", "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"}, "created_at": "2024-04-24T20:45:52+00:00", "created_at_details": {"date": "2024-04-24", "day": 24, "month": 4, "year": 2024, "hour": 20, "week": 17}, "body": "@aaronliston I saw a lot of milk-vetch with comically huge pods on the SLO County coast. How does one tell for sure whether you're looking at *A. nuttallii* or *A. curtipes*?", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 14866726, "uuid": "8d70f237-5092-45dc-bf4a-6b44348b6712", "user": {"id": 266181, "login": "aaronliston", "spam": false, "suspended": false, "created_at": "2016-06-29T13:05:22+00:00", "login_autocomplete": "aaronliston", "login_exact": "aaronliston", "name": "Aaron Liston", "name_autocomplete": "Aaron Liston", "orcid": "https://orcid.org/0000-0002-3020-6400", "icon": "https://static.inaturalist.org/attachments/users/icons/266181/thumb.jpg?1689433457", "observations_count": 3077, "identifications_count": 48617, "journal_posts_count": 1, "activity_count": 51695, "species_count": 1686, "universal_search_rank": 3077, "roles": ["curator"], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/266181/medium.jpg?1689433457"}, "created_at": "2024-04-25T04:44:15+00:00", "created_at_details": {"date": "2024-04-25", "day": 25, "month": 4, "year": 2024, "hour": 4, "week": 17}, "body": "The pods are sessile in *A. nuttallii* and elevated on a short gynophore in *A. curtipes.* The stems of *A. curtipes* are densely pubescent (canescent) on the mainland (but not the Channel Islands). Finally, *A. nuttallii* grows on the immediate coast, which *A. curtipes* avoids. ", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 14866909, "uuid": "f0cadfc4-8b7f-4887-8249-60737dc59267", "user": {"id": 266181, "login": "aaronliston", "spam": false, "suspended": false, "created_at": "2016-06-29T13:05:22+00:00", "login_autocomplete": "aaronliston", "login_exact": "aaronliston", "name": "Aaron Liston", "name_autocomplete": "Aaron Liston", "orcid": "https://orcid.org/0000-0002-3020-6400", "icon": "https://static.inaturalist.org/attachments/users/icons/266181/thumb.jpg?1689433457", "observations_count": 3077, "identifications_count": 48617, "journal_posts_count": 1, "activity_count": 51695, "species_count": 1686, "universal_search_rank": 3077, "roles": ["curator"], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/266181/medium.jpg?1689433457"}, "created_at": "2024-04-25T05:33:58+00:00", "created_at_details": {"date": "2024-04-25", "day": 25, "month": 4, "year": 2024, "hour": 5, "week": 17}, "body": "Montaña de Oro also has *A. pomonensis* ;-)", "flags": [], "moderator_actions": [], "hidden": false}]"
This data as json
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] INTEGER, [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 );
comments 0 ✖