taxons
16 rows where flag_counts = "{"resolved": 4, "unresolved": 0}"
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_changes_count, taxon_schemes_count, iconic_taxon_name, created_at (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4981 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67566, 4929, 597395, 4979, 4981] | 1 | Nycticorax nycticorax | 4979 | 48460/1/2/355675/3/67566/4929/597395/4979 | 0 | {"id": 49357930, "license_code": "cc0", "attribution": "no rights reserved, uploaded by Kyle Nessen", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/49357930/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/49357930/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/49357930/medium.jpg"} | 0 | 10 | 96027 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Black-crowned_night_heron | Aves | Black-crowned Night Heron | subspecies | |||||||||||||
7087 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 6888, 6912, 7086, 7087] | 1 | Branta bernicla | 7086 | 48460/1/2/355675/3/6888/6912/7086 | 0 | {"id": 197982544, "license_code": null, "attribution": "(c) Dimitris Salas, all rights reserved, uploaded by Dimitris Salas", "url": "https://static.inaturalist.org/photos/197982544/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/197982544/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/197982544/medium.jpeg"} | 0 | 9 | 15376 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Brant_(goose) | Aves | Brant | subspecies | |||||||||||||
18236 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 17550, 17599, 18230, 18236] | 1 | Colaptes auratus | 18230 | 48460/1/2/355675/3/17550/17599/18230 | 0 | {"id": 123812445, "license_code": "cc-by-nc-nd", "attribution": "(c) Kala Murphy King, some rights reserved (CC BY-NC-ND), uploaded by Kala Murphy King", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/123812445/square.jpg", "original_dimensions": {"height": 1289, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/123812445/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/123812445/medium.jpg"} | 0 | 10 | 101720 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Northern_flicker | Aves | Northern Flicker | subspecies | |||||||||||||
19975 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 19350, 19728, 19974, 19975] | 1 | Athene cunicularia | 19974 | 48460/1/2/355675/3/19350/19728/19974 | 0 | {"id": 57747291, "license_code": null, "attribution": "(c) Jason Penney, all rights reserved", "url": "https://static.inaturalist.org/photos/57747291/square.jpg", "original_dimensions": {"height": 1314, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/57747291/square.jpg", "medium_url": "https://static.inaturalist.org/photos/57747291/medium.jpg"} | 0 | 9 | 25820 | {"resolved": 4, "unresolved": 0} | https://en.wikipedia.org/wiki/Burrowing_owl | Aves | Burrowing Owl | subspecies | |||||||||||||
20044 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 19350, 19728, 20034, 20044] | 1 | Bubo virginianus | 20034 | 48460/1/2/355675/3/19350/19728/20034 | 0 | {"id": 14549085, "license_code": "cc-by-nc-sa", "attribution": "(c) Paul G. Johnson, some rights reserved (CC BY-NC-SA), uploaded by Paul G. Johnson", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/14549085/square.jpg", "original_dimensions": {"height": 1225, "width": 876}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/14549085/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/14549085/medium.jpg"} | 1 | 9 | 53537 | {"resolved": 4, "unresolved": 0} | 83561 | http://en.wikipedia.org/wiki/Great_horned_owl | Aves | Great Horned Owl | subspecies | ||||||||||||
26575 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85553, 26504, 797518, 26574, 26575] | 1 | Diadophis punctatus | 26574 | 48460/1/2/355675/26036/26172/85553/26504/797518/26574 | 0 | {"id": 31369605, "license_code": null, "attribution": "(c) spencer_riffle, all rights reserved, uploaded by spencer_riffle", "url": "https://static.inaturalist.org/photos/31369605/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/31369605/square.jpg", "medium_url": "https://static.inaturalist.org/photos/31369605/medium.jpg"} | 0 | 6 | 29610 | {"resolved": 4, "unresolved": 0} | 217 | https://en.wikipedia.org/wiki/Ring-necked_snake | Reptilia | ring-necked snake | subspecies | ||||||||||||
42069 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 41573, 42043, 42054, 42069] | 1 | Vulpes vulpes | 42054 | 48460/1/2/355675/40151/848317/848320/848324/41573/42043/42054 | 0 | {"id": 265916780, "license_code": null, "attribution": "(c) Pierre Noel, all rights reserved, uploaded by Pierre Noel", "url": "https://static.inaturalist.org/photos/265916780/square.jpg", "original_dimensions": {"height": 1638, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/265916780/square.jpg", "medium_url": "https://static.inaturalist.org/photos/265916780/medium.jpg"} | 0 | 5 | 87046 | {"resolved": 4, "unresolved": 0} | 20 | http://en.wikipedia.org/wiki/Red_fox | Mammalia | Red Fox | |||||||||||||
42220 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 152870, 424850, 42158, 846185, 846324, 42219, 42220] | 1 | Odocoileus hemionus | 42219 | 48460/1/2/355675/40151/848317/848320/848324/152870/424850/42158/846185/846324/42219 | 0 | {"id": 42633041, "license_code": "cc-by-sa", "attribution": "(c) Oregon Department of Fish & Wildlife, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/42633041/square.jpg", "original_dimensions": {"height": 1463, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/42633041/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/42633041/medium.jpg"} | 1 | 6 | 117902 | {"resolved": 4, "unresolved": 0} | 6 | http://en.wikipedia.org/wiki/Mule_deer | Mammalia | Mule Deer | |||||||||||||
53195 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 48382, 922206, 922242, 53196, 53195] | 1 | Rumex acetosella | 53196 | 48460/47126/211194/47125/47124/47366/48382/922206/922242/53196 | 0 | {"id": 177768765, "license_code": "cc-by-sa", "attribution": "(c) Agnieszka Kwiecień, Nova, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177768765/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177768765/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177768765/medium.jpg"} | 1 | 7 | 35448 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Rumex_acetosella | Plantae | Sheep's sorrel | ||||||||||||||
53269 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 447425, 359450, 632703, 53270, 53269] | 1 | Sonchus asper | 53270 | 48460/47126/211194/47125/47124/47605/47604/447425/359450/632703/53270 | 0 | {"id": 261760280, "license_code": "cc-by", "attribution": "(c) Michelle, some rights reserved (CC BY), uploaded by Michelle", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/261760280/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/261760280/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/261760280/medium.jpeg"} | 1 | 7 | 45659 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Sonchus_asper | Plantae | prickly sowthistle | ||||||||||||||
58961 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48151, 50638, 840983, 50636, 1045683, 1421895, 58961] | 1 | Plantago major | 1421895 | 48460/47126/211194/47125/47124/48151/50638/840983/50636/1045683/1421895 | 0 | {"id": 85519437, "license_code": "cc-by", "attribution": "(c) lemonsnapp, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/85519437/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/85519437/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/85519437/medium.jpg"} | 1 | 7 | 73387 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Plantago_major | Plantae | greater plantain | ||||||||||||||
73044 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 559248, 9522, 73044] | 1 | Melozone crissalis | 9522 | 48460/1/2/355675/3/7251/559248/9522 | 0 | {"id": 1004, "license_code": "cc-by-nc", "attribution": "(c) Lucina M, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1004/square.jpg", "original_dimensions": {"height": 607, "width": 911}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1004/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1004/medium.jpg"} | 1 | 9 | 38299 | {"resolved": 4, "unresolved": 0} | 20536 | https://en.wikipedia.org/wiki/California_towhee | Aves | California Towhee | subspecies | ||||||||||||
116999 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 71261, 200958, 71725, 116999] | 1 | Pandion haliaetus | 71725 | 48460/1/2/355675/3/71261/200958/71725 | 0 | {"id": 6903515, "license_code": "cc-by-nc", "attribution": "(c) Greg Lasley, some rights reserved (CC BY-NC), uploaded by Greg Lasley", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6903515/square.jpg", "original_dimensions": {"height": 1366, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6903515/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6903515/medium.jpg"} | 0 | 9 | 122650 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Osprey | Aves | Osprey | subspecies | |||||||||||||
180007 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848323, 43698, 129411, 45933, 339572, 209650, 179939, 180007] | 1 | Otospermophilus beecheyi | 179939 | 48460/1/2/355675/40151/848317/848320/848323/43698/129411/45933/339572/209650/179939 | 0 | {"id": 1353651, "license_code": "cc-by-nc", "attribution": "(c) qli, some rights reserved (CC BY-NC), uploaded by qli", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1353651/square.jpg", "original_dimensions": {"height": 2048, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1353651/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1353651/medium.jpg"} | 3 | 3 | 41519 | {"resolved": 4, "unresolved": 0} | 12 | http://en.wikipedia.org/wiki/California_ground_squirrel | Mammalia | California Ground Squirrel | 48460,1,2,355675,40151,848317,848320,848323,43698,129411,45933,339572,209650,179939,180007 | 0 | 180007 | 0 | 0 | 1 | 2012-11-02T18:04:26+00:00 | 0 | 41519 | ||||
470643 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48151, 64552, 319976, 982854, 470643] | 1 | Erythranthe guttata | 982854 | 48460/47126/211194/47125/47124/48151/64552/319976/982854 | 0 | {"id": 1242791, "license_code": null, "attribution": "(c) Mark Crompton, all rights reserved, uploaded by Mark Crompton", "url": "https://static.inaturalist.org/photos/1242791/square.", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/1242791/square.", "medium_url": "https://static.inaturalist.org/photos/1242791/medium."} | 14 | 2 | 21473 | {"resolved": 4, "unresolved": 0} | 16923 | http://en.wikipedia.org/wiki/Erythranthe_guttata | Plantae | seep monkeyflower | |||||||||||||
558426 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 6888, 6912, 7006, 558426] | 1 | Anser caerulescens | 7006 | 48460/1/2/355675/3/6888/6912/7006 | 0 | {"id": 92749081, "license_code": null, "attribution": "(c) Don-Jean Leandri-Breton, all rights reserved, uploaded by Don-Jean Leandri-Breton", "url": "https://static.inaturalist.org/photos/92749081/square.jpg", "original_dimensions": {"height": 683, "width": 1024}, "flags": [], "square_url": "https://static.inaturalist.org/photos/92749081/square.jpg", "medium_url": "https://static.inaturalist.org/photos/92749081/medium.jpg"} | 1 | 2 | 25391 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Snow_goose | Aves | Snow Goose | 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);