observations
1 row where taxon = 47219
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
214483492 | China beach china-beach | Apis mellifera 47219 | research | 2024-05-08T14:35:19-07:00 | [] | f6740a3f-aba4-4d7b-9764-cab511fe90d3 | {"date": "2024-05-08", "day": 8, "month": 5, "year": 2024, "hour": 14, "week": 19} | 0 | 1 | {"date": "2024-05-08", "day": 8, "month": 5, "year": 2024, "hour": 16, "week": 19} | Western Honey Bee | 0 | [] | 4 | 0 | 1 | America/Los_Angeles | cc0 | America/Los_Angeles | [] | 4 | [516849, 1935877] | 3 | [] | 2024-05-08T16:16:12-07:00 | -08:00 | [] | 2024-05-08 | 2024-05-08 14:35:19-07:00 | 2024-05-08T21:50:25-07:00 | [] | [1, 14, 854, 5219, 9853, 9912, 50422, 54321, 59613, 62068, 62332, 62622, 63279, 65360, 66741, 80718, 92151, 92337, 94045, 95504, 96034, 96057, 96683, 96687, 97394, 97447, 112245, 118564, 119138, 129174, 133888, 134683, 140260, 144925, 157662] | 0 | [48460, 1, 47120, 372739, 47158, 184884, 47201, 124417, 326777, 47222, 630955, 47221, 199939, 538904, 47220, 578086, 47219] | [] | 0 | [] | 1 | {"prefers_community_taxon": null} | [] | https://www.inaturalist.org/observations/214483492 | [] | 47219 | {"type": "Point", "coordinates": [-122.486, 37.7906133333]} | 0 | 1 | 0 | 0 | 37.7906133333,-122.486 | [] | 0 | {"id": 516849, "login": "al_kordesch", "spam": false, "suspended": false, "created_at": "2017-06-24T16:33:49+00:00", "site_id": 1, "login_autocomplete": "al_kordesch", "login_exact": "al_kordesch", "name": "Al Kordesch", "name_autocomplete": "Al Kordesch", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/516849/thumb.jpg?1498594055", "observations_count": 15613, "identifications_count": 3571, "journal_posts_count": 0, "activity_count": 19184, "species_count": 2172, "universal_search_rank": 15613, "roles": [], "icon_url": "https://static.inaturalist.org/attachments/users/icons/516849/medium.jpg?1498594055", "preferences": {}} | 1 | 1 | [] | South Bay, San Francisco, CA, US | [{"id": 484474942, "uuid": "817a461d-c7bd-4339-b68f-4d56aaaa4112", "user": {"id": 516849, "login": "al_kordesch", "spam": false, "suspended": false, "created_at": "2017-06-24T16:33:49+00:00", "login_autocomplete": "al_kordesch", "login_exact": "al_kordesch", "name": "Al Kordesch", "name_autocomplete": "Al Kordesch", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/516849/thumb.jpg?1498594055", "observations_count": 15613, "identifications_count": 3571, "journal_posts_count": 0, "activity_count": 19184, "species_count": 2172, "universal_search_rank": 15613, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/516849/medium.jpg?1498594055"}, "created_at": "2024-05-08T16:16:12-07:00", "created_at_details": {"date": "2024-05-08", "day": 8, "month": 5, "year": 2024, "hour": 16, "week": 19}, "body": null, "category": "improving", "current": false, "flags": [], "own_observation": true, "taxon_change": null, "vision": false, "disagreement": null, "previous_observation_taxon_id": 47201, "spam": false, "taxon_id": 47201, "hidden": false, "moderator_actions": [], "taxon": {"id": 47201, "rank": "order", "rank_level": 40, "iconic_taxon_id": 47158, "ancestor_ids": [48460, 1, 47120, 372739, 47158, 184884], "is_active": true, "min_species_taxon_id": 47201, "name": "Hymenoptera", "parent_id": 184884, "ancestry": "48460/1/47120/372739/47158/184884", "min_species_ancestry": "48460,1,47120,372739,47158,184884,47201", "extinct": false, "created_at": "2008-04-10T01:48:20+00:00", "default_photo": {"id": 301992102, "license_code": "cc-by-nc", "attribution": "(c) Riley Walsh, some rights reserved (CC BY-NC), uploaded by Riley Walsh", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/301992102/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/301992102/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/301992102/medium.jpeg"… | [] | [{"id": 353151403, "position": 0, "uuid": "e79e0553-e02b-493d-9f9e-cc554608c002", "photo_id": 379114658, "photo": {"id": 379114658, "license_code": "cc0", "original_dimensions": {"width": 1470, "height": 1960}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114658/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}, {"id": 353151425, "position": 1, "uuid": "9c8601f6-a8b4-4cf8-bbc6-bc7193ce6873", "photo_id": 379114684, "photo": {"id": 379114684, "license_code": "cc0", "original_dimensions": {"width": 1385, "height": 1846}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114684/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}, {"id": 353151443, "position": 2, "uuid": "2db926ce-5ebd-44e6-9bef-122fe68ce8e6", "photo_id": 379114705, "photo": {"id": 379114705, "license_code": "cc0", "original_dimensions": {"width": 1025, "height": 1367}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114705/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}, {"id": 353151464, "position": 3, "uuid": "4b81a82c-ec22-4b46-878c-d5f041f3804b", "photo_id": 379114730, "photo": {"id": 379114730, "license_code": "cc0", "original_dimensions": {"width": 1322, "height": 1763}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114730/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}, {"id": 353151478, "position": 4, "uuid": "2698f466-f7dd-4483-9a7c-7a82986b896f", "photo_id": 379114746, "photo": {"id": 379114746, "license_code": "cc0", "original_dimensions": {"width": 1264, "height": 1685}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114746/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}}] | [{"id": 379114658, "license_code": "cc0", "original_dimensions": {"width": 1470, "height": 1960}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114658/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 379114684, "license_code": "cc0", "original_dimensions": {"width": 1385, "height": 1846}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114684/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 379114705, "license_code": "cc0", "original_dimensions": {"width": 1025, "height": 1367}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114705/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 379114730, "license_code": "cc0", "original_dimensions": {"width": 1322, "height": 1763}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114730/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}, {"id": 379114746, "license_code": "cc0", "original_dimensions": {"width": 1264, "height": 1685}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379114746/square.jpg", "attribution": "no rights reserved", "flags": [], "moderator_actions": [], "hidden": false}] | [] | [{"id": 484540826, "uuid": "ad52bdf4-0419-4210-86ac-be8c0ffd4580", "user": {"id": 1935877, "login": "cecildomyiidae", "spam": false, "suspended": false, "created_at": "2019-07-02T00:32:46+00:00", "login_autocomplete": "cecildomyiidae", "login_exact": "cecildomyiidae", "name": "Cecil Smith", "name_autocomplete": "Cecil Smith", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/1935877/thumb.jpg?1707340974", "observations_count": 23052, "identifications_count": 33180, "journal_posts_count": 0, "activity_count": 56232, "species_count": 3861, "universal_search_rank": 23052, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/1935877/medium.jpg?1707340974"}, "created_at": "2024-05-08T19:45:03-07:00", "created_at_details": {"date": "2024-05-08", "day": 8, "month": 5, "year": 2024, "hour": 19, "week": 19}, "body": "", "category": "improving", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 47201, "spam": false, "taxon_id": 47219, "hidden": false, "moderator_actions": [], "taxon": {"id": 47219, "rank": "species", "rank_level": 10, "iconic_taxon_id": 47158, "ancestor_ids": [48460, 1, 47120, 372739, 47158, 184884, 47201, 124417, 326777, 47222, 630955, 47221, 199939, 538904, 47220, 578086], "is_active": true, "min_species_taxon_id": 47219, "name": "Apis mellifera", "parent_id": 578086, "ancestry": "48460/1/47120/372739/47158/184884/47201/124417/326777/47222/630955/47221/199939/538904/47220/578086", "min_species_ancestry": "48460,1,47120,372739,47158,184884,47201,124417,326777,47222,630955,47221,199939,538904,47220,578086,47219", "extinct": false, "created_at": "2008-04-16T18:08:27+00:00", "default_photo": {"id": 2369526, "license_code": null, "attribution": "(c) Georges-Alexandre Cotnoir, all rights reserved, uploaded by Georges-Alexandre Cotnoir", "url": "https://static.inaturalist.org/photos/2369526/square.jpg", "original_dimensions": {"height": 1402,… |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );