taxons
16 rows where taxon_schemes_count = 8
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_changes_count, flag_counts, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3839 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3836, 3839] | 1 | Calidris ptilocnemis | 3836 | 48460/1/2/355675/3/67561/3835/3836 | 0 | {"id": 5333676, "license_code": "cc-by-nc", "attribution": "(c) Steven Mlodinow, some rights reserved (CC BY-NC), uploaded by Steven Mlodinow", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5333676/square.jpg", "original_dimensions": {"height": 1584, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5333676/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5333676/medium.jpg"} | 0 | 8 | 630 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Rock_sandpiper | Aves | Rock Sandpiper | subspecies | |||||||||||||
4519 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 71295, 4515, 4519] | 1 | Uria aalge | 4515 | 48460/1/2/355675/3/67561/71295/4515 | 0 | {"id": 96826556, "license_code": "cc-by-nc-nd", "attribution": "(c) Анна Голубева, some rights reserved (CC BY-NC-ND), uploaded by Анна Голубева", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96826556/square.jpg", "original_dimensions": {"height": 803, "width": 1200}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96826556/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96826556/medium.jpg"} | 0 | 8 | 12581 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Common_murre | Aves | Common Murre | subspecies | |||||||||||||
4557 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4342, 447155, 4556, 4557] | 1 | Rhodostethia rosea | 4556 | 48460/1/2/355675/3/67561/4342/447155/4556 | 0 | {"id": 195607089, "license_code": "cc-by-nc-nd", "attribution": "(c) Leon van der Noll, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/195607089/square.jpg", "original_dimensions": {"height": 1442, "width": 1923}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/195607089/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/195607089/medium.jpg"} | 0 | 8 | 204 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Ross's_gull | Aves | Ross's Gull | subspecies | |||||||||||||
4561 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 71295, 4558, 4561] | 1 | Synthliboramphus antiquus | 4558 | 48460/1/2/355675/3/67561/71295/4558 | 0 | {"id": 19719328, "license_code": "cc-by-nc", "attribution": "(c) guyincognito, some rights reserved (CC BY-NC), uploaded by guyincognito", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19719328/square.jpeg", "original_dimensions": {"height": 1286, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19719328/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19719328/medium.jpeg"} | 0 | 8 | 702 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Ancient_murrelet | Aves | Ancient Murrelet | subspecies | |||||||||||||
26823 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 26718, 26720, 26816, 26823] | 1 | Dicamptodon ensatus | 26816 | 48460/1/2/355675/20978/26718/26720/26816 | 0 | {"id": 202779, "license_code": "cc-by-nc", "attribution": "(c) J. Maughn, some rights reserved (CC BY-NC), uploaded by J. Maughn", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/202779/square.jpg", "original_dimensions": {"height": 1200, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/202779/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/202779/medium.jpg"} | 0 | 8 | 2347 | {"resolved": 0, "unresolved": 0} | 237 | http://en.wikipedia.org/wiki/California_giant_salamander | Amphibia | California Giant Salamander | {"id": 11571, "place_id": null, "source_id": 37, "user_id": null, "authority": "IUCN Red List", "status": "nt", "status_name": "near threatened", "geoprivacy": "obscured", "iucn": 20} | ||||||||||||
27459 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 26718, 26909, 787564, 27444, 27459] | 1 | Batrachoseps attenuatus | 27444 | 48460/1/2/355675/20978/26718/26909/787564/27444 | 0 | {"id": 1545, "license_code": "cc-by-nc-sa", "attribution": "(c) Steve Lew, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1545/square.jpg", "original_dimensions": {"height": 1050, "width": 1154}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1545/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1545/medium.jpg"} | 0 | 8 | 19443 | {"resolved": 0, "unresolved": 0} | 228 | http://en.wikipedia.org/wiki/California_slender_salamander | Amphibia | California Slender Salamander | |||||||||||||
27826 | species | 10 | 20978 | [48460, 1, 2, 355675, 20978, 26718, 27701, 787591, 27816, 27826] | 1 | Taricha granulosa | 27816 | 48460/1/2/355675/20978/26718/27701/787591/27816 | 0 | {"id": 27604, "license_code": "cc-by-nc-nd", "attribution": "(c) matt knoth, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27604/square.jpg", "original_dimensions": {"height": 1360, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27604/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27604/medium.jpg"} | 0 | 8 | 15803 | {"resolved": 0, "unresolved": 0} | 232 | http://en.wikipedia.org/wiki/Rough-skinned_newt | Amphibia | Rough-skinned Newt | |||||||||||||
41482 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 152870, 925158, 152871, 424322, 1317261, 41479, 1317267, 41480, 41482] | 1 | Tursiops truncatus | 41480 | 48460/1/2/355675/40151/848317/848320/848324/152870/925158/152871/424322/1317261/41479/1317267/41480 | 0 | {"id": 125992346, "license_code": "cc-by-nc-sa", "attribution": "(c) Juanma Carrillo, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/125992346/square.jpg", "original_dimensions": {"height": 1362, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/125992346/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/125992346/medium.jpg"} | 0 | 8 | 17758 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Common_bottlenose_dolphin | Mammalia | Common Bottlenose Dolphin | ||||||||||||||
41526 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 152870, 925158, 152871, 424322, 1317261, 41479, 1317267, 41524, 41526] | 1 | Delphinus delphis | 41524 | 48460/1/2/355675/40151/848317/848320/848324/152870/925158/152871/424322/1317261/41479/1317267/41524 | 0 | {"id": 5405850, "license_code": "cc-by-nc", "attribution": "(c) Claudia Komesu, some rights reserved (CC BY-NC), uploaded by Claudia Komesu", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5405850/square.jpeg", "original_dimensions": {"height": 1459, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5405850/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5405850/medium.jpeg"} | 2 | 8 | 6002 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Short-beaked_common_dolphin | Mammalia | Common Dolphin | ||||||||||||||
41566 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 152870, 925158, 152871, 424321, 41546, 41565, 41566] | 1 | Megaptera novaeangliae | 41565 | 48460/1/2/355675/40151/848317/848320/848324/152870/925158/152871/424321/41546/41565 | 0 | {"id": 257050260, "license_code": "cc-by-nc", "attribution": "(c) José Antonio Linage Espinosa, some rights reserved (CC BY-NC), uploaded by José Antonio Linage Espinosa", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/257050260/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/257050260/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/257050260/medium.jpg"} | 0 | 8 | 18617 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Humpback_whale | Mammalia | Humpback Whale | ||||||||||||||
51555 | species | 10 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47792, 47927, 1317176, 47819, 51556, 51555] | 1 | Sympetrum illotum | 51556 | 48460/1/47120/372739/47158/184884/47792/47927/1317176/47819/51556 | 0 | {"id": 173910444, "license_code": "cc-by-nc", "attribution": "(c) Cameron Eckert, some rights reserved (CC BY-NC), uploaded by Cameron Eckert", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/173910444/square.jpg", "original_dimensions": {"height": 1366, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/173910444/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/173910444/medium.jpg"} | 0 | 8 | 6202 | {"resolved": 0, "unresolved": 0} | Insecta | Cardinal Meadowhawk | |||||||||||||||
53421 | species | 10 | 47126 | [48460, 47126, 211194, 136329, 47375, 47562, 1456301, 47561, 790732, 790770, 53421] | 1 | Pinus radiata | 790770 | 48460/47126/211194/136329/47375/47562/1456301/47561/790732/790770 | 0 | {"id": 39486159, "license_code": null, "attribution": "(c) mazer, all rights reserved, uploaded by mazer", "url": "https://static.inaturalist.org/photos/39486159/square.jpeg", "original_dimensions": {"height": 2048, "width": 1365}, "flags": [], "square_url": "https://static.inaturalist.org/photos/39486159/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/39486159/medium.jpeg"} | 0 | 8 | 10689 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Pinus_radiata | Plantae | Monterey pine | ||||||||||||||
57197 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 47162, 47434, 514989, 552962, 1138128, 57200, 57197] | 1 | Polypogon monspeliensis | 57200 | 48460/47126/211194/47125/47163/47162/47434/514989/552962/1138128/57200 | 0 | {"id": 115909148, "license_code": "cc-by-nc", "attribution": "(c) Andrea Kreuzhage, some rights reserved (CC BY-NC), uploaded by Andrea Kreuzhage", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/115909148/square.jpeg", "original_dimensions": {"height": 1100, "width": 1650}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/115909148/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/115909148/medium.jpeg"} | 1 | 8 | 9417 | {"resolved": 1, "unresolved": 0} | 15881 | http://en.wikipedia.org/wiki/Polypogon_monspeliensis | Plantae | rabbitfoot grass | |||||||||||||
144502 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4342, 447155, 144320, 144502] | 1 | Chroicocephalus philadelphia | 144320 | 48460/1/2/355675/3/67561/4342/447155/144320 | 0 | {"id": 211016518, "license_code": "cc-by-nc", "attribution": "(c) Scott O'Donnell, some rights reserved (CC BY-NC), uploaded by Scott O'Donnell", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/211016518/square.jpg", "original_dimensions": {"height": 1190, "width": 1788}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/211016518/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/211016518/medium.jpg"} | 1 | 8 | 16551 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Bonaparte's_gull | Aves | Bonaparte's Gull | subspecies | |||||||||||||
144537 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4342, 373567, 144326, 144537] | 1 | Hydroprogne caspia | 144326 | 48460/1/2/355675/3/67561/4342/373567/144326 | 0 | {"id": 35795285, "license_code": "cc-by-nc", "attribution": "(c) Frans Vandewalle, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/35795285/square.jpg", "original_dimensions": {"height": 1370, "width": 1817}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/35795285/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/35795285/medium.jpg"} | 2 | 8 | 27508 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Caspian_tern | Aves | Caspian Tern | subspecies | |||||||||||||
199840 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 9079, 199910, 199840] | 1 | Haemorhous mexicanus | 199910 | 48460/1/2/355675/3/7251/9079/199910 | 0 | {"id": 178968933, "license_code": null, "attribution": "(c) Juan Miguel Artigas Azas, all rights reserved, uploaded by Juan Miguel Artigas Azas", "url": "https://static.inaturalist.org/photos/178968933/square.jpg", "original_dimensions": {"height": 800, "width": 1200}, "flags": [], "square_url": "https://static.inaturalist.org/photos/178968933/square.jpg", "medium_url": "https://static.inaturalist.org/photos/178968933/medium.jpg"} | 1 | 8 | 210494 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/House_finch | Aves | House Finch | subspecies |
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);