taxons
5 rows where flag_counts = "{"resolved": 1, "unresolved": 1}"
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_changes_count, taxon_schemes_count, iconic_taxon_name
id ▼ | rank | rank_level | iconic_taxon_id | ancestor_ids | is_active | name | parent_id | ancestry | extinct | default_photo | taxon_changes_count | taxon_schemes_count | observations_count | flag_counts | current_synonymous_taxon_ids | atlas_id | complete_species_count | wikipedia_url | iconic_taxon_name | preferred_common_name | complete_rank | conservation_status | min_species_ancestry | endemic | min_species_taxon_id | threatened | introduced | native | created_at | photos_locked | universal_search_rank |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3938 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3937, 3938] | 1 | Arenaria interpres | 3937 | 48460/1/2/355675/3/67561/3835/3937 | 0 | {"id": 57282715, "license_code": "cc-by-nc", "attribution": "(c) John Clough, some rights reserved (CC BY-NC), uploaded by John Clough", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/57282715/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/57282715/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/57282715/medium.jpeg"} | 0 | 11 | 39482 | {"resolved": 1, "unresolved": 1} | http://en.wikipedia.org/wiki/Ruddy_turnstone | Aves | Ruddy Turnstone | subspecies | |||||||||||||
50892 | species | 10 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47157, 47224, 47922, 202067, 130316, 50896, 50892] | 1 | Euphydryas chalcedona | 50896 | 48460/1/47120/372739/47158/184884/47157/47224/47922/202067/130316/50896 | 0 | {"id": 45781313, "license_code": "cc-by-nc", "attribution": "(c) photojuls, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/45781313/square.jpeg", "original_dimensions": {"height": 1360, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/45781313/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/45781313/medium.jpeg"} | 0 | 3 | 14703 | {"resolved": 1, "unresolved": 1} | 2160 | http://en.wikipedia.org/wiki/Variable_checkerspot | Insecta | Variable Checkerspot | |||||||||||||
52833 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 632790, 324787, 1410494, 52834, 52833] | 1 | Anaphalis margaritacea | 52834 | 48460/47126/211194/47125/47124/47605/47604/632790/324787/1410494/52834 | 0 | {"id": 116351, "license_code": "cc-by-sa", "attribution": "(c) peupleloup, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/116351/square.jpg", "original_dimensions": {"height": 2048, "width": 1532}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/116351/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/116351/medium.jpg"} | 0 | 4 | 29810 | {"resolved": 1, "unresolved": 1} | 17285 | https://en.wikipedia.org/wiki/Anaphalis_margaritacea | Plantae | pearly everlasting | |||||||||||||
61317 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47132, 47148, 415343, 922171, 47544, 1360636, 1449268, 1449265, 1449266, 61317] | 1 | Rubus armeniacus | 1449266 | 48460/47126/211194/47125/47124/47132/47148/415343/922171/47544/1360636/1449268/1449265/1449266 | 0 | {"id": 26538109, "license_code": null, "attribution": "(c) akuauhtli, all rights reserved", "url": "https://static.inaturalist.org/photos/26538109/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://static.inaturalist.org/photos/26538109/square.jpg", "medium_url": "https://static.inaturalist.org/photos/26538109/medium.jpg"} | 1 | 3 | 20165 | {"resolved": 1, "unresolved": 1} | http://en.wikipedia.org/wiki/Rubus_armeniacus | Plantae | Armenian Blackberry | ||||||||||||||
63865 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47181, 133387, 571287, 47179, 63865] | 1 | Arctostaphylos imbricata | 47179 | 48460/47126/211194/47125/47124/47181/133387/571287/47179 | 0 | {"id": 114505477, "license_code": "cc-by-nc-nd", "attribution": "(c) David Greenberger, some rights reserved (CC BY-NC-ND), uploaded by David Greenberger", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/114505477/square.jpeg", "original_dimensions": {"height": 1695, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/114505477/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/114505477/medium.jpeg"} | 0 | 3 | 374 | {"resolved": 1, "unresolved": 1} | http://en.wikipedia.org/wiki/Arctostaphylos_imbricata | Plantae | San Bruno Mountain manzanita |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [taxons] ( [id] INTEGER PRIMARY KEY, [rank] TEXT, [rank_level] INTEGER, [iconic_taxon_id] INTEGER, [ancestor_ids] TEXT, [is_active] INTEGER, [name] TEXT, [parent_id] INTEGER, [ancestry] TEXT, [extinct] INTEGER, [default_photo] TEXT, [taxon_changes_count] INTEGER, [taxon_schemes_count] INTEGER, [observations_count] INTEGER, [flag_counts] TEXT, [current_synonymous_taxon_ids] TEXT, [atlas_id] INTEGER, [complete_species_count] TEXT, [wikipedia_url] TEXT, [iconic_taxon_name] TEXT, [preferred_common_name] TEXT , [complete_rank] TEXT, [conservation_status] TEXT, [min_species_ancestry] TEXT, [endemic] INTEGER, [min_species_taxon_id] INTEGER, [threatened] INTEGER, [introduced] INTEGER, [native] INTEGER, [created_at] TEXT, [photos_locked] INTEGER, [universal_search_rank] INTEGER);