observations
1 row where description = "Observed this Gull on the rocks near Half Moon Bay. Gull was spotted alongside many other Gulls that would occasionally fly off and land on nearby rocks. He was small, had white and grey feathers. I noticed he would remain on the rocks for a couple of seconds and then he would fly to another location on the rocks. It appeared to be that he was looking for something, maybe food. He was very observant to the people nearby, including myself. "
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)
description 1 ✖
- Observed this Gull on the rocks near Half Moon Bay. Gull was spotted alongside many other Gulls that would occasionally fly off and land on nearby rocks. He was small, had white and grey feathers. I noticed he would remain on the rocks for a couple of seconds and then he would fly to another location on the rocks. It appeared to be that he was looking for something, maybe food. He was very observant to the people nearby, including myself. · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193193716 | Redondo beach redondo-beach | Larus occidentalis 4345 | research | 2023-12-03T10:40:00-08:00 | open | [] | c4eb40af-fad0-48cc-a879-1599dabd9f3d | {"date": "2023-12-03", "day": 3, "month": 12, "year": 2023, "hour": 10, "week": 48} | 0 | 1 | {"date": "2023-12-05", "day": 5, "month": 12, "year": 2023, "hour": 23, "week": 49} | Western Gull | 0 | [] | 147 | 0 | 1 | America/Los_Angeles | cc-by-nc | America/Los_Angeles | [] | 147 | [141551, 459714, 6026558, 7438308] | 3 | [] | 2023-12-05T23:05:48-08:00 | Observed this Gull on the rocks near Half Moon Bay. Gull was spotted alongside many other Gulls that would occasionally fly off and land on nearby rocks. He was small, had white and grey feathers. I noticed he would remain on the rocks for a couple of seconds and then he would fly to another location on the rocks. It appeared to be that he was looking for something, maybe food. He was very observant to the people nearby, including myself. | -08:00 | [] | 2023-12-03 | 2023-12-03 10:40:00-08:00 | 2023-12-06T12:57:57-08: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, 2, 355675, 3, 67561, 4342, 447155, 4343, 4345] | [{"source": "GBIF", "url": "http://www.gbif.org/occurrence/4465451608"}] | 0 | [] | 2 | {"prefers_community_taxon": null} | [] | https://www.inaturalist.org/observations/193193716 | [10522, 5531] | 4345 | {"type": "Point", "coordinates": [-122.44419648, 37.4377860177]} | 1 | 2 | 0 | 0 | 37.4377860177,-122.44419648 | [] | 0 | {"id": 7438308, "login": "cassidyd393", "spam": false, "suspended": false, "created_at": "2023-09-22T19:36:57+00:00", "site_id": 1, "login_autocomplete": "cassidyd393", "login_exact": "cassidyd393", "name": null, "name_autocomplete": null, "orcid": null, "icon": null, "observations_count": 10, "identifications_count": 0, "journal_posts_count": 0, "activity_count": 10, "species_count": 10, "universal_search_rank": 10, "roles": [], "icon_url": null, "preferences": {}} | 1 | 1 | [10522, 5531] | Redondo Beach, Half Moon Bay, CA, US | [{"id": 432755145, "uuid": "1eff73f0-5340-445c-a7d6-2e063071a3eb", "user": {"id": 7438308, "login": "cassidyd393", "spam": false, "suspended": false, "created_at": "2023-09-22T19:36:57+00:00", "login_autocomplete": "cassidyd393", "login_exact": "cassidyd393", "name": null, "name_autocomplete": null, "orcid": null, "icon": null, "observations_count": 10, "identifications_count": 0, "journal_posts_count": 0, "activity_count": 10, "species_count": 10, "universal_search_rank": 10, "roles": [], "site_id": 1, "icon_url": null}, "created_at": "2023-12-05T23:05:48-08:00", "created_at_details": {"date": "2023-12-05", "day": 5, "month": 12, "year": 2023, "hour": 23, "week": 49}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 4343, "spam": false, "taxon_id": 4343, "hidden": false, "moderator_actions": [], "taxon": {"id": 4343, "rank": "genus", "rank_level": 20, "iconic_taxon_id": 3, "ancestor_ids": [48460, 1, 2, 355675, 3, 67561, 4342, 447155], "is_active": true, "min_species_taxon_id": 4343, "name": "Larus", "parent_id": 447155, "ancestry": "48460/1/2/355675/3/67561/4342/447155", "min_species_ancestry": "48460,1,2,355675,3,67561,4342,447155,4343", "extinct": false, "created_at": "2008-03-13T02:45:04+00:00", "default_photo": {"id": 3688643, "license_code": "cc-by-nc-nd", "attribution": "(c) Ján Svetlík, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3688643/square.jpg", "original_dimensions": {"height": 649, "width": 567}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3688643/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3688643/medium.jpg"}, "taxon_changes_count": 0, "taxon_schemes_count": 1, "observations_count": 538845, "photos_locked": false, "universal_search_rank": 538845, "flag_counts": {"resolved": 1, "unresolved": 0}, "current_synonymous_taxon_ids": null, … | [{"id": 88230550, "uuid": "9482050a-206c-4456-a53d-093fe90f7cba", "project": {"id": 10522}, "user_id": null, "preferences": {"allows_curator_coordinate_access": false}}, {"id": 88234276, "uuid": "14c687be-712e-4568-a45e-04001a7a35d2", "project": {"id": 5531}, "user_id": null, "preferences": {"allows_curator_coordinate_access": false}}] | [{"id": 316172046, "position": 0, "uuid": "6d2feb64-ec1d-4397-88f7-1a023d09f109", "photo_id": 339341890, "photo": {"id": 339341890, "license_code": "cc-by-nc", "original_dimensions": {"width": 1290, "height": 1671}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/339341890/square.jpg", "attribution": "(c) cassidyd393, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}] | [{"id": 339341890, "license_code": "cc-by-nc", "original_dimensions": {"width": 1290, "height": 1671}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/339341890/square.jpg", "attribution": "(c) cassidyd393, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}] | [] | [{"id": 432828535, "uuid": "3992af4f-f539-4a8e-a8a4-83b12e7fe2eb", "user": {"id": 459714, "login": "guyincognito", "spam": false, "suspended": false, "created_at": "2017-04-21T13:24:45+00:00", "login_autocomplete": "guyincognito", "login_exact": "guyincognito", "name": "", "name_autocomplete": "", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/459714/thumb.jpg?1572825030", "observations_count": 8761, "identifications_count": 89989, "journal_posts_count": 0, "activity_count": 98750, "species_count": 3721, "universal_search_rank": 8761, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/459714/medium.jpg?1572825030"}, "created_at": "2023-12-06T06:46:36-08:00", "created_at_details": {"date": "2023-12-06", "day": 6, "month": 12, "year": 2023, "hour": 6, "week": 49}, "body": "", "category": "improving", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 4343, "spam": false, "taxon_id": 4345, "hidden": false, "moderator_actions": [], "taxon": {"id": 4345, "rank": "species", "rank_level": 10, "iconic_taxon_id": 3, "ancestor_ids": [48460, 1, 2, 355675, 3, 67561, 4342, 447155, 4343], "is_active": true, "min_species_taxon_id": 4345, "name": "Larus occidentalis", "parent_id": 4343, "ancestry": "48460/1/2/355675/3/67561/4342/447155/4343", "min_species_ancestry": "48460,1,2,355675,3,67561,4342,447155,4343,4345", "extinct": false, "created_at": "2008-03-13T02:45:04+00:00", "default_photo": {"id": 1877, "license_code": "cc-by-nc", "attribution": "(c) Jamie Chavez, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1877/square.jpg", "original_dimensions": {"height": 533, "width": 800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1877/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1877/medium.jpg"}, "taxon_changes_count": 0, "taxon_schemes_c… |
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 );