home / data

Menu
  • GraphQL API

observations

Table actions
  • GraphQL API for observations

3 rows where taxon = 52564

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: num_identification_agreements, owners_identification_from_vision, identifications_count, time_observed_at (date), created_at (date), observed_on (date), observed_on_string (date), updated_at (date)

id ▼ place taxon quality_grade time_observed_at taxon_geoprivacy annotations uuid observed_on_details cached_votes_total identifications_most_agree created_at_details species_guess identifications_most_disagree tags positional_accuracy comments_count site_id created_time_zone license_code observed_time_zone quality_metrics public_positional_accuracy reviewed_by oauth_application_id flags created_at description time_zone_offset project_ids_with_curator_id observed_on observed_on_string updated_at sounds place_ids captive ident_taxon_ids outlinks faves_count ofvs num_identification_agreements preferences comments map_scale uri project_ids community_taxon_id geojson owners_identification_from_vision identifications_count obscured num_identification_disagreements geoprivacy location votes spam user mappable identifications_some_agree project_ids_without_curator_id place_guess identifications project_observations observation_photos photos faves non_owner_ids
218814990 China beach china-beach Anthopleura elegantissima 52564 research 2024-05-25T08:30:28-07:00   [] 8382f5ef-dba0-494d-9c5f-992bc23e3358 {"date": "2024-05-25", "day": 25, "month": 5, "year": 2024, "hour": 8, "week": 21} 0 1 {"date": "2024-05-27", "day": 27, "month": 5, "year": 2024, "hour": 20, "week": 22} Aggregating Anemone 0 [] 5 0 1 America/Los_Angeles cc-by-nc America/Los_Angeles [] 5 [217955, 2442028] 3 [] 2024-05-27T20:17:29-07:00   -08:00 [] 2024-05-25 2024-05-25 08:30:28-07:00 2024-05-27T20:24:02-07:00 [] [1, 14, 854, 9853, 9912, 50422, 54321, 59613, 62068, 62332, 62622, 63097, 63279, 65360, 66741, 80718, 90997, 92151, 92337, 94045, 95504, 96034, 96057, 96683, 96687, 97394, 112245, 118564, 119138, 129174, 133888, 134683, 140260, 144925] 0 [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052, 52564] [] 0 [] 1 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/218814990 [] 52564 {"type": "Point", "coordinates": [-122.4934083333, 37.78782]} 1 1 0 0   37.78782,-122.4934083333 [] 0 {"id": 2442028, "login": "olivia_v", "spam": false, "suspended": false, "created_at": "2019-11-15T18:21:30+00:00", "site_id": 1, "login_autocomplete": "olivia_v", "login_exact": "olivia_v", "name": "Olivia VanDamme", "name_autocomplete": "Olivia VanDamme", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2442028/thumb.jpeg?1673986379", "observations_count": 4300, "identifications_count": 431, "journal_posts_count": 0, "activity_count": 4731, "species_count": 1157, "annotated_observations_count": 16, "universal_search_rank": 4300, "roles": [], "icon_url": "https://static.inaturalist.org/attachments/users/icons/2442028/medium.jpeg?1673986379", "preferences": {}} 1 1 [] South Bay, San Francisco, CA, US [{"id": 493206978, "uuid": "fe968bcd-7201-404b-951c-907a45b0608a", "user": {"id": 2442028, "login": "olivia_v", "spam": false, "suspended": false, "created_at": "2019-11-15T18:21:30+00:00", "login_autocomplete": "olivia_v", "login_exact": "olivia_v", "name": "Olivia VanDamme", "name_autocomplete": "Olivia VanDamme", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2442028/thumb.jpeg?1673986379", "observations_count": 4300, "identifications_count": 431, "journal_posts_count": 0, "activity_count": 4731, "species_count": 1157, "annotated_observations_count": 16, "universal_search_rank": 4300, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/2442028/medium.jpeg?1673986379"}, "created_at": "2024-05-27T20:17:29-07:00", "created_at_details": {"date": "2024-05-27", "day": 27, "month": 5, "year": 2024, "hour": 20, "week": 22}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 52564, "spam": false, "taxon_id": 52564, "hidden": false, "moderator_actions": [], "taxon": {"id": 52564, "rank": "species", "rank_level": 10, "iconic_taxon_id": 1, "ancestor_ids": [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052], "is_active": true, "min_species_taxon_id": 52564, "name": "Anthopleura elegantissima", "parent_id": 49052, "ancestry": "48460/1/47534/47533/202756/47797/813978/813994/47796/49052", "min_species_ancestry": "48460,1,47534,47533,202756,47797,813978,813994,47796,49052,52564", "extinct": false, "created_at": "2009-08-08T16:20:18+00:00", "default_photo": {"id": 6948726, "license_code": "cc-by-nc", "attribution": "(c) C. Mallory, some rights reserved (CC BY-NC), uploaded by C. Mallory", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6948726/square.jpg", "original_dimensions": {"height": 600, "width": 800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos… [] [{"id": 360736317, "position": 0, "uuid": "8d72f27b-b5fe-4da0-beef-129b2089b448", "photo_id": 387245328, "photo": {"id": 387245328, "license_code": "cc-by-nc", "original_dimensions": {"width": 1536, "height": 2048}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/387245328/square.jpg", "attribution": "(c) Olivia VanDamme, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 387245328, "license_code": "cc-by-nc", "original_dimensions": {"width": 1536, "height": 2048}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/387245328/square.jpg", "attribution": "(c) Olivia VanDamme, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 493208890, "uuid": "5e96ffdf-eb47-494e-99fc-7ae07c549151", "user": {"id": 217955, "login": "phelsumas4life", "spam": false, "suspended": false, "created_at": "2016-04-16T04:12:27+00:00", "login_autocomplete": "phelsumas4life", "login_exact": "phelsumas4life", "name": "Sean Ono", "name_autocomplete": "Sean Ono", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/217955/thumb.jpeg?1609328758", "observations_count": 2155, "identifications_count": 235876, "journal_posts_count": 0, "activity_count": 238031, "species_count": 1047, "annotated_observations_count": 17, "universal_search_rank": 2155, "roles": ["curator"], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/217955/medium.jpeg?1609328758"}, "created_at": "2024-05-27T20:24:02-07:00", "created_at_details": {"date": "2024-05-27", "day": 27, "month": 5, "year": 2024, "hour": 20, "week": 22}, "body": null, "category": "supporting", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 52564, "spam": false, "taxon_id": 52564, "hidden": false, "moderator_actions": [], "taxon": {"id": 52564, "rank": "species", "rank_level": 10, "iconic_taxon_id": 1, "ancestor_ids": [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052], "is_active": true, "min_species_taxon_id": 52564, "name": "Anthopleura elegantissima", "parent_id": 49052, "ancestry": "48460/1/47534/47533/202756/47797/813978/813994/47796/49052", "min_species_ancestry": "48460,1,47534,47533,202756,47797,813978,813994,47796,49052,52564", "extinct": false, "created_at": "2009-08-08T16:20:18+00:00", "default_photo": {"id": 6948726, "license_code": "cc-by-nc", "attribution": "(c) C. Mallory, some rights reserved (CC BY-NC), uploaded by C. Mallory", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6948726/square.jpg", "original_dimensions": {"height": 600, "width": 800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.a…
227043941 Laguna Point  laguna-point Anthopleura elegantissima 52564 research 2024-07-03T17:26:18-07:00   [] 2d6c86d2-2074-4b3e-92fe-1712ea3ae38a {"date": "2024-07-03", "day": 3, "month": 7, "year": 2024, "hour": 17, "week": 27} 0 1 {"date": "2024-07-03", "day": 3, "month": 7, "year": 2024, "hour": 23, "week": 27} Aggregating Anemone 0 [] 4 0 1 America/Los_Angeles cc-by-nc America/Los_Angeles [] 4 [532567, 4556795] 3 [] 2024-07-03T23:10:01-07:00   -08:00 [] 2024-07-03 2024-07-03 17:26:18-07:00 2024-07-09T21:20:46-07:00 [] [1, 14, 436, 5845, 9853, 50422, 54030, 59613, 62068, 62332, 62622, 65360, 66741, 78829, 80718, 92151, 92337, 95504, 96034, 96683, 96687, 97394, 111699, 112245, 119138, 120970, 124258, 124300, 133888] 0 [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052, 52564] [] 0 [] 1 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/227043941 [] 52564 {"type": "Point", "coordinates": [-123.8023383333, 39.49008]} 0 1 0 0   39.49008,-123.8023383333 [] 0 {"id": 4556795, "login": "aptgrebe", "spam": false, "suspended": false, "created_at": "2021-06-09T05:54:20+00:00", "site_id": 1, "login_autocomplete": "aptgrebe", "login_exact": "aptgrebe", "name": null, "name_autocomplete": null, "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/4556795/thumb.jpg?1663698158", "observations_count": 2727, "identifications_count": 54, "journal_posts_count": 0, "activity_count": 2781, "species_count": 1600, "annotated_observations_count": 1, "universal_search_rank": 2727, "roles": [], "icon_url": "https://static.inaturalist.org/attachments/users/icons/4556795/medium.jpg?1663698158", "preferences": {}} 1 1 [] North Pacific Ocean, CA, US [{"id": 509728617, "uuid": "dd77b35b-a7f8-46c2-bb07-0ba124002147", "user": {"id": 4556795, "login": "aptgrebe", "spam": false, "suspended": false, "created_at": "2021-06-09T05:54:20+00:00", "login_autocomplete": "aptgrebe", "login_exact": "aptgrebe", "name": null, "name_autocomplete": null, "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/4556795/thumb.jpg?1663698158", "observations_count": 2727, "identifications_count": 54, "journal_posts_count": 0, "activity_count": 2781, "species_count": 1600, "annotated_observations_count": 1, "universal_search_rank": 2727, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/4556795/medium.jpg?1663698158"}, "created_at": "2024-07-04T06:10:01+00:00", "created_at_details": {"date": "2024-07-04", "day": 4, "month": 7, "year": 2024, "hour": 6, "week": 27}, "body": null, "category": "improving", "current": false, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 49052, "spam": false, "taxon_id": 49052, "hidden": false, "moderator_actions": [], "taxon": {"id": 49052, "rank": "genus", "rank_level": 20, "iconic_taxon_id": 1, "ancestor_ids": [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796], "is_active": true, "min_species_taxon_id": 49052, "name": "Anthopleura", "parent_id": 47796, "ancestry": "48460/1/47534/47533/202756/47797/813978/813994/47796", "min_species_ancestry": "48460,1,47534,47533,202756,47797,813978,813994,47796,49052", "extinct": false, "created_at": "2009-01-11T08:05:57+00:00", "default_photo": {"id": 2584237, "license_code": "cc-by", "attribution": "(c) Jerry Kirkhart, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2584237/square.jpg", "original_dimensions": {"height": 1404, "width": 1500}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2584237/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos… [] [{"id": 375132102, "position": 0, "uuid": "16478aa0-1316-4e65-abaf-efc8d4bb0391", "photo_id": 402738373, "photo": {"id": 402738373, "license_code": "cc-by-nc", "original_dimensions": {"width": 1536, "height": 2048}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/402738373/square.jpg", "attribution": "(c) aptgrebe, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 402738373, "license_code": "cc-by-nc", "original_dimensions": {"width": 1536, "height": 2048}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/402738373/square.jpg", "attribution": "(c) aptgrebe, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 512362838, "uuid": "10a42468-de19-4964-8e96-d386cf47f276", "user": {"id": 532567, "login": "anna-gardner", "spam": false, "suspended": false, "created_at": "2017-07-14T03:36:48+00:00", "login_autocomplete": "anna-gardner", "login_exact": "anna-gardner", "name": "Anna Gardner", "name_autocomplete": "Anna Gardner", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/532567/thumb.jpg?1718156091", "observations_count": 3381, "identifications_count": 367, "journal_posts_count": 0, "activity_count": 3748, "species_count": 1210, "annotated_observations_count": 0, "universal_search_rank": 3381, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/532567/medium.jpg?1718156091"}, "created_at": "2024-07-10T01:54:26+00:00", "created_at_details": {"date": "2024-07-10", "day": 10, "month": 7, "year": 2024, "hour": 1, "week": 28}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 49052, "spam": false, "taxon_id": 52564, "hidden": false, "moderator_actions": [], "taxon": {"id": 52564, "rank": "species", "rank_level": 10, "iconic_taxon_id": 1, "ancestor_ids": [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052], "is_active": true, "min_species_taxon_id": 52564, "name": "Anthopleura elegantissima", "parent_id": 49052, "ancestry": "48460/1/47534/47533/202756/47797/813978/813994/47796/49052", "min_species_ancestry": "48460,1,47534,47533,202756,47797,813978,813994,47796,49052,52564", "extinct": false, "created_at": "2009-08-08T16:20:18+00:00", "default_photo": {"id": 6948726, "license_code": "cc-by-nc", "attribution": "(c) C. Mallory, some rights reserved (CC BY-NC), uploaded by C. Mallory", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6948726/square.jpg", "original_dimensions": {"height": 600, "width": 800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/phot…
228728823 Shark Fin Cove shark-fin-cove Anthopleura elegantissima 52564 research 2024-07-11T16:39:48-07:00   [] 91f4eaa5-671b-45dc-98c1-558744f29a02 {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 16, "week": 28} 0 1 {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 16, "week": 28} Aggregating Anemone 0 [] 45 0 1 America/Los_Angeles cc-by-nc America/Los_Angeles [] 45 [78845, 217955, 2864338] 3 [] 2024-07-11T16:42:24-07:00   -08:00 [] 2024-07-11 2024-07-11 16:39:48-07:00 2024-07-11T18:29:17-07:00 [] [1, 14, 418, 3591, 9853, 50422, 51330, 54030, 59613, 62068, 62332, 62622, 63279, 65360, 66741, 72783, 92151, 92337, 93467, 94045, 95504, 96034, 96683, 96687, 97394, 112245, 118063, 118663, 119138, 120714, 124258, 128254, 128797, 133886, 150804] 0 [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052, 52564] [] 0 [] 2 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/228728823 [] 52564 {"type": "Point", "coordinates": [-122.1855100185, 37.0038719338]} 0 2 0 0   37.0038719338,-122.1855100185 [] 0 {"id": 2864338, "login": "polly_m", "spam": false, "suspended": false, "created_at": "2020-04-27T20:29:16+00:00", "site_id": 1, "login_autocomplete": "polly_m", "login_exact": "polly_m", "name": "", "name_autocomplete": "", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2864338/thumb.jpg?1705285237", "observations_count": 253, "identifications_count": 40, "journal_posts_count": 0, "activity_count": 293, "species_count": 196, "annotated_observations_count": 0, "universal_search_rank": 253, "roles": [], "icon_url": "https://static.inaturalist.org/attachments/users/icons/2864338/medium.jpg?1705285237", "preferences": {}} 1 1 [] Cotoni-Coast Dairies, Davenport, CA, US [{"id": 513160647, "uuid": "6b3f6724-98c7-4e79-902d-555b7ea8193f", "user": {"id": 2864338, "login": "polly_m", "spam": false, "suspended": false, "created_at": "2020-04-27T20:29:16+00:00", "login_autocomplete": "polly_m", "login_exact": "polly_m", "name": "", "name_autocomplete": "", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2864338/thumb.jpg?1705285237", "observations_count": 253, "identifications_count": 40, "journal_posts_count": 0, "activity_count": 293, "species_count": 196, "annotated_observations_count": 0, "universal_search_rank": 253, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/2864338/medium.jpg?1705285237"}, "created_at": "2024-07-11T16:42:24-07:00", "created_at_details": {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 16, "week": 28}, "body": null, "category": "improving", "current": false, "flags": [], "own_observation": true, "taxon_change": null, "vision": false, "disagreement": null, "previous_observation_taxon_id": 47797, "spam": false, "taxon_id": 47797, "hidden": false, "moderator_actions": [], "taxon": {"id": 47797, "rank": "order", "rank_level": 40, "iconic_taxon_id": 1, "ancestor_ids": [48460, 1, 47534, 47533, 202756], "is_active": true, "min_species_taxon_id": 47797, "name": "Actiniaria", "parent_id": 202756, "ancestry": "48460/1/47534/47533/202756", "min_species_ancestry": "48460,1,47534,47533,202756,47797", "extinct": false, "created_at": "2008-06-30T17:22:31+00:00", "default_photo": {"id": 48519610, "license_code": null, "attribution": "(c) Pat Webster @underwaterpat, all rights reserved, uploaded by Pat Webster @underwaterpat", "url": "https://static.inaturalist.org/photos/48519610/square.jpg", "original_dimensions": {"height": 1019, "width": 1200}, "flags": [], "square_url": "https://static.inaturalist.org/photos/48519610/square.jpg", "medium_url": "https://static.inaturalist.org/photos/48519610/medium.jpg"}, "taxon_changes_count": 0, "taxon_schemes_count": 2, "observations_count… [] [{"id": 378084474, "position": 0, "uuid": "9e2b2244-dded-4652-a525-5df79adc2e61", "photo_id": 405926039, "photo": {"id": 405926039, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1536}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/405926039/square.jpeg", "attribution": "(c) polly_m, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 405926039, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1536}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/405926039/square.jpeg", "attribution": "(c) polly_m, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 513171501, "uuid": "55fdfb5d-59b9-406d-8907-0bb3a5c80d36", "user": {"id": 78845, "login": "mazer", "spam": false, "suspended": false, "created_at": "2015-02-26T06:04:49+00:00", "login_autocomplete": "mazer", "login_exact": "mazer", "name": "", "name_autocomplete": "", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/78845/thumb.jpg?1475553530", "observations_count": 13209, "identifications_count": 34058, "journal_posts_count": 0, "activity_count": 47267, "species_count": 1982, "annotated_observations_count": 2, "universal_search_rank": 13209, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/78845/medium.jpg?1475553530"}, "created_at": "2024-07-11T17:22:35-07:00", "created_at_details": {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 17, "week": 28}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": true, "disagreement": false, "previous_observation_taxon_id": 47797, "spam": false, "taxon_id": 52564, "hidden": false, "moderator_actions": [], "taxon": {"id": 52564, "rank": "species", "rank_level": 10, "iconic_taxon_id": 1, "ancestor_ids": [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052], "is_active": true, "min_species_taxon_id": 52564, "name": "Anthopleura elegantissima", "parent_id": 49052, "ancestry": "48460/1/47534/47533/202756/47797/813978/813994/47796/49052", "min_species_ancestry": "48460,1,47534,47533,202756,47797,813978,813994,47796,49052,52564", "extinct": false, "created_at": "2009-08-08T16:20:18+00:00", "default_photo": {"id": 6948726, "license_code": "cc-by-nc", "attribution": "(c) C. Mallory, some rights reserved (CC BY-NC), uploaded by C. Mallory", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6948726/square.jpg", "original_dimensions": {"height": 600, "width": 800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6948726/square.jpg", "medium_url": "http…

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);
Powered by Datasette · Queries took 133.739ms