home / data

Menu
  • GraphQL API

observations

Table actions
  • GraphQL API for observations

3 rows where taxon = 49051

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: place, observed_on, 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
223913813 Redondo beach redondo-beach Anthopleura sola 49051 research 2024-06-19T08:43:54-07:00   [] a603cb0f-4e22-491a-80d9-5dcdef417a89 {"date": "2024-06-19", "day": 19, "month": 6, "year": 2024, "hour": 8, "week": 25} 0 1 {"date": "2024-06-19", "day": 19, "month": 6, "year": 2024, "hour": 21, "week": 25} Sunburst Anemone 0 [] 30 0 1 America/Los_Angeles   America/Los_Angeles [] 30 [566836, 7620827] 3 [] 2024-06-19T21:36:39-07:00   -08:00 [] 2024-06-19 2024-06-19 08:43:54-07:00 2024-06-19T21:42:14-07:00 [] [1, 14, 1919, 9853, 50422, 51330, 54030, 54321, 59613, 62068, 62332, 62622, 63279, 65360, 66741, 80718, 92151, 92337, 94045, 95504, 96034, 96057, 96683, 96687, 97394, 112245, 118406, 118564, 119138, 120714, 128254, 128797, 133888, 140260, 154799] 0 [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052, 49051] [] 0 [] 1 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/223913813 [] 49051 {"type": "Point", "coordinates": [-122.444795, 37.437905]} 1 1 0 0   37.437905,-122.444795 [] 0 {"id": 566836, "login": "doctorjay", "spam": false, "suspended": false, "created_at": "2017-08-07T01:10:20+00:00", "site_id": 1, "login_autocomplete": "doctorjay", "login_exact": "doctorjay", "name": null, "name_autocomplete": null, "orcid": null, "icon": null, "observations_count": 376, "identifications_count": 0, "journal_posts_count": 0, "activity_count": 376, "species_count": 274, "annotated_observations_count": 0, "universal_search_rank": 376, "roles": [], "icon_url": null, "preferences": {}} 1 1 [] North Pacific Ocean, CA, US [{"id": 503350659, "uuid": "119f9a65-951a-4f06-9451-014543be8ccc", "user": {"id": 566836, "login": "doctorjay", "spam": false, "suspended": false, "created_at": "2017-08-07T01:10:20+00:00", "login_autocomplete": "doctorjay", "login_exact": "doctorjay", "name": null, "name_autocomplete": null, "orcid": null, "icon": null, "observations_count": 376, "identifications_count": 0, "journal_posts_count": 0, "activity_count": 376, "species_count": 274, "annotated_observations_count": 0, "universal_search_rank": 376, "roles": [], "site_id": 1, "icon_url": null}, "created_at": "2024-06-20T04:36:39+00:00", "created_at_details": {"date": "2024-06-20", "day": 20, "month": 6, "year": 2024, "hour": 4, "week": 25}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 49051, "spam": false, "taxon_id": 49051, "hidden": false, "moderator_actions": [], "taxon": {"id": 49051, "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": 49051, "name": "Anthopleura sola", "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,49051", "extinct": false, "created_at": "2009-01-11T08:05:56+00:00", "default_photo": {"id": 10551, "license_code": "cc-by", "attribution": "(c) Ed Bierman, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "original_dimensions": {"height": 1072, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/medium.jpg"}, "taxon_changes_count": 0, "taxon_schemes_count": 1, "observations_count": 21208, "photos_locked": false, "universal_search_rank":… [] [{"id": 369616419, "position": 0, "uuid": "05e10044-7541-4ed9-af12-da141d1ad60f", "photo_id": 396793624, "photo": {"id": 396793624, "license_code": null, "original_dimensions": {"width": 750, "height": 1334}, "url": "https://static.inaturalist.org/photos/396793624/square.jpg", "attribution": "(c) doctorjay, all rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}, {"id": 369616448, "position": 1, "uuid": "1adeb522-3e4b-42f2-81e2-38346d005dec", "photo_id": 396793670, "photo": {"id": 396793670, "license_code": null, "original_dimensions": {"width": 1536, "height": 2048}, "url": "https://static.inaturalist.org/photos/396793670/square.jpg", "attribution": "(c) doctorjay, all rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 396793624, "license_code": null, "original_dimensions": {"width": 750, "height": 1334}, "url": "https://static.inaturalist.org/photos/396793624/square.jpg", "attribution": "(c) doctorjay, all rights reserved", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 396793670, "license_code": null, "original_dimensions": {"width": 1536, "height": 2048}, "url": "https://static.inaturalist.org/photos/396793670/square.jpg", "attribution": "(c) doctorjay, all rights reserved", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 503352088, "uuid": "d669a948-c16a-44f1-b3b9-0f7174111be2", "user": {"id": 7620827, "login": "primno", "spam": false, "suspended": false, "created_at": "2023-11-19T18:38:14+00:00", "login_autocomplete": "primno", "login_exact": "primno", "name": null, "name_autocomplete": null, "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/7620827/thumb.jpg?1718732118", "observations_count": 717, "identifications_count": 1549, "journal_posts_count": 0, "activity_count": 2266, "species_count": 468, "annotated_observations_count": 128, "universal_search_rank": 717, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/7620827/medium.jpg?1718732118"}, "created_at": "2024-06-20T04:42:14+00:00", "created_at_details": {"date": "2024-06-20", "day": 20, "month": 6, "year": 2024, "hour": 4, "week": 25}, "body": null, "category": "supporting", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 49051, "spam": false, "taxon_id": 49051, "hidden": false, "moderator_actions": [], "taxon": {"id": 49051, "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": 49051, "name": "Anthopleura sola", "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,49051", "extinct": false, "created_at": "2009-01-11T08:05:56+00:00", "default_photo": {"id": 10551, "license_code": "cc-by", "attribution": "(c) Ed Bierman, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "original_dimensions": {"height": 1072, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazo…
224814092 Redondo beach redondo-beach Anthopleura sola 49051 research 2024-06-19T13:19:14-07:00   [] f6b1a047-05d1-4564-93fe-b12453120127 {"date": "2024-06-19", "day": 19, "month": 6, "year": 2024, "hour": 13, "week": 25} 0 1 {"date": "2024-06-23", "day": 23, "month": 6, "year": 2024, "hour": 21, "week": 25} Sunburst Anemone 0 [] 4 0 1 America/Los_Angeles   America/Los_Angeles [] 4 [2248610, 8195702] 3 [] 2024-06-23T21:30:56-07:00   -08:00 [] 2024-06-19 2024-06-19 13:19:14-07:00 2024-07-09T14:15:04-07:00 [] [1, 14, 1919, 9853, 50422, 51330, 54030, 54321, 59613, 62068, 62332, 62622, 63279, 65360, 66741, 80718, 92151, 92337, 94045, 95504, 96034, 96057, 96683, 96687, 97394, 112245, 118564, 119138, 120148, 120649, 120714, 128254, 128797, 133888, 140260, 154799] 0 [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 49052, 49051] [] 0 [] 1 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/224814092 [] 49051 {"type": "Point", "coordinates": [-122.4444116667, 37.43808]} 1 1 0 0   37.43808,-122.4444116667 [] 0 {"id": 8195702, "login": "crystalbutters", "spam": false, "suspended": false, "created_at": "2024-05-26T14:11:18+00:00", "site_id": null, "login_autocomplete": "crystalbutters", "login_exact": "crystalbutters", "name": "Crystal An", "name_autocomplete": "Crystal An", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/8195702/thumb.jpg?1718513863", "observations_count": 13, "identifications_count": 0, "journal_posts_count": 0, "activity_count": 13, "species_count": 10, "annotated_observations_count": 0, "universal_search_rank": 13, "roles": [], "icon_url": "https://static.inaturalist.org/attachments/users/icons/8195702/medium.jpg?1718513863", "preferences": {}} 1 1 [] North Pacific Ocean, Half Moon Bay, CA, US [{"id": 505237300, "uuid": "740710d2-fcfb-4dca-919b-7df7464dea88", "user": {"id": 8195702, "login": "crystalbutters", "spam": false, "suspended": false, "created_at": "2024-05-26T14:11:18+00:00", "login_autocomplete": "crystalbutters", "login_exact": "crystalbutters", "name": "Crystal An", "name_autocomplete": "Crystal An", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/8195702/thumb.jpg?1718513863", "observations_count": 13, "identifications_count": 0, "journal_posts_count": 0, "activity_count": 13, "species_count": 10, "annotated_observations_count": 0, "universal_search_rank": 13, "roles": [], "site_id": null, "icon_url": "https://static.inaturalist.org/attachments/users/icons/8195702/medium.jpg?1718513863"}, "created_at": "2024-06-23T21:30:56-07:00", "created_at_details": {"date": "2024-06-23", "day": 23, "month": 6, "year": 2024, "hour": 21, "week": 25}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 49051, "spam": false, "taxon_id": 49051, "hidden": false, "moderator_actions": [], "taxon": {"id": 49051, "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": 49051, "name": "Anthopleura sola", "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,49051", "extinct": false, "created_at": "2009-01-11T08:05:56+00:00", "default_photo": {"id": 10551, "license_code": "cc-by", "attribution": "(c) Ed Bierman, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "original_dimensions": {"height": 1072, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "medium_url": "https://… [] [{"id": 371205079, "position": 0, "uuid": "f73299e9-8158-4860-a534-5f0074f3b943", "photo_id": 398503981, "photo": {"id": 398503981, "license_code": null, "original_dimensions": {"width": 1152, "height": 2048}, "url": "https://static.inaturalist.org/photos/398503981/square.jpg", "attribution": "(c) Crystal An, all rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 398503981, "license_code": null, "original_dimensions": {"width": 1152, "height": 2048}, "url": "https://static.inaturalist.org/photos/398503981/square.jpg", "attribution": "(c) Crystal An, all rights reserved", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 512279202, "uuid": "112b54bb-56d2-43fc-820e-2139476143d7", "user": {"id": 2248610, "login": "sandor_in", "spam": false, "suspended": false, "created_at": "2019-09-13T01:07:24+00:00", "login_autocomplete": "sandor_in", "login_exact": "sandor_in", "name": null, "name_autocomplete": null, "orcid": null, "icon": null, "observations_count": 8214, "identifications_count": 38379, "journal_posts_count": 0, "activity_count": 46593, "species_count": 2438, "annotated_observations_count": 9771, "universal_search_rank": 8214, "roles": [], "site_id": 1, "icon_url": null}, "created_at": "2024-07-09T14:15:04-07:00", "created_at_details": {"date": "2024-07-09", "day": 9, "month": 7, "year": 2024, "hour": 14, "week": 28}, "body": null, "category": "supporting", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 49051, "spam": false, "taxon_id": 49051, "hidden": false, "moderator_actions": [], "taxon": {"id": 49051, "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": 49051, "name": "Anthopleura sola", "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,49051", "extinct": false, "created_at": "2009-01-11T08:05:56+00:00", "default_photo": {"id": 10551, "license_code": "cc-by", "attribution": "(c) Ed Bierman, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "original_dimensions": {"height": 1072, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/medium.jpg"}, "taxon_changes_count": 0, "taxon_schemes_count": 1, "observations_count": 21208, "photos_locked": false, "univer…
228741641 Shark Fin Cove shark-fin-cove Anthopleura sola 49051 research 2024-07-11T10:37:59-07:00   [] 79dc15ee-2278-4805-8aed-1a0c6eb3c9a1 {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 10, "week": 28} 0 1 {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 18, "week": 28} Sunburst Anemone 0 [] 207 0 1 America/Los_Angeles cc-by-nc America/Los_Angeles [] 207 [217955, 2864338] 3 [] 2024-07-11T18:19:46-07:00   -08:00 [] 2024-07-11 2024-07-11 09:37:59-08:00 2024-07-11T18:41:54-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, 49051] [] 0 [] 1 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/228741641 [] 49051 {"type": "Point", "coordinates": [-122.1853741596, 37.0037979631]} 1 1 0 0   37.0037979631,-122.1853741596 [] 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 [] North Pacific Ocean, Davenport, CA, US [{"id": 513187111, "uuid": "8e53ef28-cffd-4b47-88f6-8db866a3ca64", "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-11T18:19:46-07:00", "created_at_details": {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 18, "week": 28}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 49051, "spam": false, "taxon_id": 49051, "hidden": false, "moderator_actions": [], "taxon": {"id": 49051, "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": 49051, "name": "Anthopleura sola", "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,49051", "extinct": false, "created_at": "2009-01-11T08:05:56+00:00", "default_photo": {"id": 10551, "license_code": "cc-by", "attribution": "(c) Ed Bierman, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "original_dimensions": {"height": 1072, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/… [] [{"id": 378107836, "position": 0, "uuid": "b0ba0f5a-a490-4b9b-85ed-656ab8c1526a", "photo_id": 405951216, "photo": {"id": 405951216, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1536}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/405951216/square.jpeg", "attribution": "(c) polly_m, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}, {"id": 378107821, "position": 1, "uuid": "5878182b-1928-437d-a2e3-29447617c04e", "photo_id": 405951191, "photo": {"id": 405951191, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1536}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/405951191/square.jpeg", "attribution": "(c) polly_m, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 405951216, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1536}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/405951216/square.jpeg", "attribution": "(c) polly_m, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 405951191, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1536}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/405951191/square.jpeg", "attribution": "(c) polly_m, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 513192850, "uuid": "b68918e3-ea25-4ca2-86a8-35e026df6399", "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-07-11T18:41:53-07:00", "created_at_details": {"date": "2024-07-11", "day": 11, "month": 7, "year": 2024, "hour": 18, "week": 28}, "body": null, "category": "supporting", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 49051, "spam": false, "taxon_id": 49051, "hidden": false, "moderator_actions": [], "taxon": {"id": 49051, "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": 49051, "name": "Anthopleura sola", "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,49051", "extinct": false, "created_at": "2009-01-11T08:05:56+00:00", "default_photo": {"id": 10551, "license_code": "cc-by", "attribution": "(c) Ed Bierman, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "original_dimensions": {"height": 1072, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10551/square.jpg", "m…

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 158.84ms