observations

Table actions

2 rows where taxon = 8010

✎ View and edit SQL

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
214626800 China beach china-beach Corvus corax 8010 research 2024-05-09T08:20:05-07:00 open [{"uuid": "235ff9c4-01dc-4de7-9110-91d2b0dda607", "controlled_attribute_id": 1, "controlled_value_id": 2, "concatenated_attr_val": "1|2", "vote_score": 0, "user_id": 668716, "votes": [], "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}}, {"uuid": "eddb4e70-282f-4be5-835f-14be28a66a77", "controlled_attribute_id": 17, "controlled_value_id": 18, "concatenated_attr_val": "17|18", "vote_score": 0, "user_id": 668716, "votes": [], "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}}, {"uuid": "024b48d0-b7ee-43c2-ab16-5e629022f9f9", "controlled_attribute_id": 22, "controlled_value_id": 24, "concatenated_attr_val": "22|24", "vote_score": 0, "user_id": 668716, "votes": [], "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "l… fa4a4484-8c7a-4ff1-9d9e-c88f9c2e29d8 {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 8, "week": 19} 0 1 {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 10, "week": 19} Common Raven 0 [] 3 0 1 America/Los_Angeles cc-by-nc America/Los_Angeles [] 3 [141551, 668716, 1490864, 2187314] 3 [] 2024-05-09T10:41:55-07:00   -08:00 [] 2024-05-09 2024-05-09 08:20:05-07:00 2024-05-09T22:20:31-07:00 [] [1, 14, 854, 5219, 9853, 9912, 50422, 54321, 59613, 62068, 62332, 62622, 63279, 65360, 66741, 92151, 92337, 93940, 94045, 95504, 96034, 96057, 96683, 96687, 97394, 97447, 112245, 118564, 119138, 129174, 133888, 134683, 140260, 144925, 157662] 0 [48460, 1, 2, 355675, 3, 7251, 7823, 7998, 8010] [{"source": "GBIF", "url": "http://www.gbif.org/occurrence/4863414083"}] 0 [] 2 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/214626800 [15765, 5531] 8010 {"type": "Point", "coordinates": [-122.485475, 37.7903583333]} 1 2 0 0   37.7903583333,-122.485475 [] 0 {"id": 2187314, "login": "carnivorous", "spam": false, "suspended": false, "created_at": "2019-08-29T03:48:18+00:00", "site_id": 1, "login_autocomplete": "carnivorous", "login_exact": "carnivorous", "name": "Ut T. Scott", "name_autocomplete": "Ut T. Scott", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2187314/thumb.jpg?1707199355", "observations_count": 1123, "identifications_count": 5102, "journal_posts_count": 0, "activity_count": 6225, "species_count": 740, "annotated_observations_count": 0, "universal_search_rank": 1123, "roles": [], "icon_url": "https://static.inaturalist.org/attachments/users/icons/2187314/medium.jpg?1707199355", "preferences": {}} 1 1 [15765, 5531] Baker Beach, San Francisco, CA, US [{"id": 484790438, "uuid": "99d829b4-c8f3-472f-94d3-55445cd1b6b0", "user": {"id": 2187314, "login": "carnivorous", "spam": false, "suspended": false, "created_at": "2019-08-29T03:48:18+00:00", "login_autocomplete": "carnivorous", "login_exact": "carnivorous", "name": "Ut T. Scott", "name_autocomplete": "Ut T. Scott", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2187314/thumb.jpg?1707199355", "observations_count": 1123, "identifications_count": 5102, "journal_posts_count": 0, "activity_count": 6225, "species_count": 740, "annotated_observations_count": 0, "universal_search_rank": 1123, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/2187314/medium.jpg?1707199355"}, "created_at": "2024-05-09T10:41:55-07:00", "created_at_details": {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 10, "week": 19}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 8010, "spam": false, "taxon_id": 8010, "hidden": false, "moderator_actions": [], "taxon": {"id": 8010, "rank": "species", "rank_level": 10, "iconic_taxon_id": 3, "ancestor_ids": [48460, 1, 2, 355675, 3, 7251, 7823, 7998], "is_active": true, "min_species_taxon_id": 8010, "name": "Corvus corax", "parent_id": 7998, "ancestry": "48460/1/2/355675/3/7251/7823/7998", "min_species_ancestry": "48460,1,2,355675,3,7251,7823,7998,8010", "extinct": false, "created_at": "2008-03-13T02:56:20+00:00", "default_photo": {"id": 119994010, "license_code": "cc-by-nc-sa", "attribution": "(c) arbyreed, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "original_dimensions": {"height": 1474, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/medium.jpg… [{"id": 95293271, "uuid": "e61e0f93-8613-41f6-b381-6e601f7be0fb", "project": {"id": 15765}, "user_id": 668716, "preferences": {"allows_curator_coordinate_access": false}, "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}}, {"id": 95315461, "uuid": "aae8a2cc-2e21-4e07-a0d9-b0a34b483a02", "project": {"id": 5531}, "user_id": null, "preferences": {"allows_curator_coordinate_access": false}}] [{"id": 353399419, "position": 0, "uuid": "c58c344d-0440-4831-9ea3-aeeec9c5ff91", "photo_id": 379380803, "photo": {"id": 379380803, "license_code": "cc-by-nc", "original_dimensions": {"width": 1959, "height": 1849}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379380803/square.jpg", "attribution": "(c) Ut T. Scott, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 379380803, "license_code": "cc-by-nc", "original_dimensions": {"width": 1959, "height": 1849}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379380803/square.jpg", "attribution": "(c) Ut T. Scott, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 484832824, "uuid": "26516c37-dc1b-40f7-abbd-ef4c2870ed57", "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}, "created_at": "2024-05-09T12:31:25-07:00", "created_at_details": {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 12, "week": 19}, "body": null, "category": "supporting", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 8010, "spam": false, "taxon_id": 8010, "hidden": false, "moderator_actions": [], "taxon": {"id": 8010, "rank": "species", "rank_level": 10, "iconic_taxon_id": 3, "ancestor_ids": [48460, 1, 2, 355675, 3, 7251, 7823, 7998], "is_active": true, "min_species_taxon_id": 8010, "name": "Corvus corax", "parent_id": 7998, "ancestry": "48460/1/2/355675/3/7251/7823/7998", "min_species_ancestry": "48460,1,2,355675,3,7251,7823,7998,8010", "extinct": false, "created_at": "2008-03-13T02:56:20+00:00", "default_photo": {"id": 119994010, "license_code": "cc-by-nc-sa", "attribution": "(c) arbyreed, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "original_dimensions": {"height": 1474, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/medium.jpg"}, "taxon_changes_count":…
214626913 China beach china-beach Corvus corax 8010 research 2024-05-09T08:20:37-07:00 open [{"uuid": "b4281744-6338-4828-8494-22a165da85c3", "controlled_attribute_id": 1, "controlled_value_id": 2, "concatenated_attr_val": "1|2", "vote_score": 0, "user_id": 668716, "votes": [], "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}}, {"uuid": "273c4f52-9809-4a69-84ee-98cb9260ba3f", "controlled_attribute_id": 17, "controlled_value_id": 18, "concatenated_attr_val": "17|18", "vote_score": 0, "user_id": 668716, "votes": [], "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}}, {"uuid": "585d5a7f-190d-4f20-8bc7-d355d2385210", "controlled_attribute_id": 22, "controlled_value_id": 24, "concatenated_attr_val": "22|24", "vote_score": 0, "user_id": 668716, "votes": [], "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "l… 04dba71d-71e6-4b34-9471-90795aef5cb0 {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 8, "week": 19} 0 1 {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 10, "week": 19} Common Raven 0 [] 4 0 1 America/Los_Angeles cc-by-nc America/Los_Angeles [] 4 [141551, 668716, 1490864, 2187314] 3 [] 2024-05-09T10:42:39-07:00   -08:00 [] 2024-05-09 2024-05-09 08:20:37-07:00 2024-05-09T22:20:24-07:00 [] [1, 14, 854, 5219, 9853, 9912, 50422, 54321, 59613, 62068, 62332, 62622, 63279, 65360, 66741, 92151, 92337, 94045, 95504, 96034, 96057, 96683, 96687, 97394, 97447, 112245, 118564, 119138, 129174, 133888, 134683, 140260, 144925, 157662] 0 [48460, 1, 2, 355675, 3, 7251, 7823, 7998, 8010] [{"source": "GBIF", "url": "http://www.gbif.org/occurrence/4863594255"}] 0 [] 2 {"prefers_community_taxon": null} []   https://www.inaturalist.org/observations/214626913 [15765, 38444, 5531] 8010 {"type": "Point", "coordinates": [-122.4854966667, 37.790425]} 1 2 0 0   37.790425,-122.4854966667 [] 0 {"id": 2187314, "login": "carnivorous", "spam": false, "suspended": false, "created_at": "2019-08-29T03:48:18+00:00", "site_id": 1, "login_autocomplete": "carnivorous", "login_exact": "carnivorous", "name": "Ut T. Scott", "name_autocomplete": "Ut T. Scott", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2187314/thumb.jpg?1707199355", "observations_count": 1123, "identifications_count": 5102, "journal_posts_count": 0, "activity_count": 6225, "species_count": 740, "annotated_observations_count": 0, "universal_search_rank": 1123, "roles": [], "icon_url": "https://static.inaturalist.org/attachments/users/icons/2187314/medium.jpg?1707199355", "preferences": {}} 1 1 [15765, 38444, 5531] Baker Beach, San Francisco, CA, US [{"id": 484790676, "uuid": "4a702a58-d467-4c32-bef5-5c6493356f2a", "user": {"id": 2187314, "login": "carnivorous", "spam": false, "suspended": false, "created_at": "2019-08-29T03:48:18+00:00", "login_autocomplete": "carnivorous", "login_exact": "carnivorous", "name": "Ut T. Scott", "name_autocomplete": "Ut T. Scott", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/2187314/thumb.jpg?1707199355", "observations_count": 1123, "identifications_count": 5102, "journal_posts_count": 0, "activity_count": 6225, "species_count": 740, "annotated_observations_count": 0, "universal_search_rank": 1123, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/2187314/medium.jpg?1707199355"}, "created_at": "2024-05-09T10:42:39-07:00", "created_at_details": {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 10, "week": 19}, "body": null, "category": "improving", "current": true, "flags": [], "own_observation": true, "taxon_change": null, "vision": true, "disagreement": null, "previous_observation_taxon_id": 8010, "spam": false, "taxon_id": 8010, "hidden": false, "moderator_actions": [], "taxon": {"id": 8010, "rank": "species", "rank_level": 10, "iconic_taxon_id": 3, "ancestor_ids": [48460, 1, 2, 355675, 3, 7251, 7823, 7998], "is_active": true, "min_species_taxon_id": 8010, "name": "Corvus corax", "parent_id": 7998, "ancestry": "48460/1/2/355675/3/7251/7823/7998", "min_species_ancestry": "48460,1,2,355675,3,7251,7823,7998,8010", "extinct": false, "created_at": "2008-03-13T02:56:20+00:00", "default_photo": {"id": 119994010, "license_code": "cc-by-nc-sa", "attribution": "(c) arbyreed, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "original_dimensions": {"height": 1474, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/medium.jpg… [{"id": 95292987, "uuid": "e99b40dc-70c0-44c4-8624-dab6d2fd4b0f", "project": {"id": 15765}, "user_id": 668716, "preferences": {"allows_curator_coordinate_access": false}, "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}}, {"id": 95292984, "uuid": "1c025c84-7ae1-404d-ae7d-cef81d6cd778", "project": {"id": 38444}, "user_id": 668716, "preferences": {"allows_curator_coordinate_access": false}, "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}}, {"id": 95315471, "uuid": "7166a083-64a6-417e-96d2-870f1365b940", "project": {"id": 5531}, "user_id": null, "preferences": {"allows_curator_coordinate_access": false}}] [{"id": 353399619, "position": 0, "uuid": "1a059cb1-d78e-41f4-a96e-59ebff196881", "photo_id": 379381064, "photo": {"id": 379381064, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1211}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379381064/square.jpg", "attribution": "(c) Ut T. Scott, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}}] [{"id": 379381064, "license_code": "cc-by-nc", "original_dimensions": {"width": 2048, "height": 1211}, "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/379381064/square.jpg", "attribution": "(c) Ut T. Scott, some rights reserved (CC BY-NC)", "flags": [], "moderator_actions": [], "hidden": false}] [] [{"id": 484825585, "uuid": "cdad1085-5f85-45b5-bc6d-31720c5ccc90", "user": {"id": 668716, "login": "luck", "spam": false, "suspended": false, "created_at": "2017-10-13T15:21:45+00:00", "login_autocomplete": "luck", "login_exact": "luck", "name": "lucky", "name_autocomplete": "lucky", "orcid": null, "icon": "https://static.inaturalist.org/attachments/users/icons/668716/thumb.jpg?1510550766", "observations_count": 2819, "identifications_count": 26212, "journal_posts_count": 0, "activity_count": 29031, "species_count": 472, "annotated_observations_count": 14617, "universal_search_rank": 2819, "roles": [], "site_id": 1, "icon_url": "https://static.inaturalist.org/attachments/users/icons/668716/medium.jpg?1510550766"}, "created_at": "2024-05-09T12:12:55-07:00", "created_at_details": {"date": "2024-05-09", "day": 9, "month": 5, "year": 2024, "hour": 12, "week": 19}, "body": null, "category": "supporting", "current": true, "flags": [], "own_observation": false, "taxon_change": null, "vision": false, "disagreement": false, "previous_observation_taxon_id": 8010, "spam": false, "taxon_id": 8010, "hidden": false, "moderator_actions": [], "taxon": {"id": 8010, "rank": "species", "rank_level": 10, "iconic_taxon_id": 3, "ancestor_ids": [48460, 1, 2, 355675, 3, 7251, 7823, 7998], "is_active": true, "min_species_taxon_id": 8010, "name": "Corvus corax", "parent_id": 7998, "ancestry": "48460/1/2/355675/3/7251/7823/7998", "min_species_ancestry": "48460,1,2,355675,3,7251,7823,7998,8010", "extinct": false, "created_at": "2008-03-13T02:56:20+00:00", "default_photo": {"id": 119994010, "license_code": "cc-by-nc-sa", "attribution": "(c) arbyreed, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "original_dimensions": {"height": 1474, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/119994010/medium.jpg"}, "taxon_changes_count":…

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
);