taxons
19 rows where taxon_schemes_count = 10
This data as json, CSV (advanced)
Suggested facets: parent_id, ancestry, taxon_changes_count, flag_counts, introduced, native, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1409 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 573, 1278, 1405, 1409] | 1 | Callipepla californica | 1405 | 48460/1/2/355675/3/573/1278/1405 | 0 | {"id": 252273183, "license_code": "cc-by-nc", "attribution": "(c) Christian Reynolds, some rights reserved (CC BY-NC), uploaded by Christian Reynolds", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/252273183/square.jpg", "original_dimensions": {"height": 1357, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/252273183/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/252273183/medium.jpg"} | 0 | 10 | 30241 | {"resolved": 0, "unresolved": 0} | 3949 | http://en.wikipedia.org/wiki/California_quail | Aves | California Quail | subspecies | ||||||||||||
3855 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3836, 3855] | 1 | Calidris mauri | 3836 | 48460/1/2/355675/3/67561/3835/3836 | 0 | {"id": 3256542, "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/3256542/square.jpg", "original_dimensions": {"height": 1333, "width": 2000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3256542/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3256542/medium.jpg"} | 0 | 10 | 13414 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Western_sandpiper | Aves | Western Sandpiper | subspecies | |||||||||||||
3857 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3836, 3857] | 1 | Calidris alpina | 3836 | 48460/1/2/355675/3/67561/3835/3836 | 0 | {"id": 65881975, "license_code": "cc-by-nc-sa", "attribution": "(c) Paul Reeves, some rights reserved (CC BY-NC-SA), uploaded by Paul Reeves", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65881975/square.jpg", "original_dimensions": {"height": 1200, "width": 1800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65881975/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65881975/medium.jpg"} | 0 | 10 | 29584 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Dunlin | Aves | Dunlin | subspecies | |||||||||||||
3865 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3836, 3865] | 1 | Calidris melanotos | 3836 | 48460/1/2/355675/3/67561/3835/3836 | 0 | {"id": 166627642, "license_code": "cc-by", "attribution": "(c) Andrew Cannizzaro, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/166627642/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/166627642/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/166627642/medium.jpg"} | 1 | 10 | 10441 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Pectoral_sandpiper | Aves | Pectoral Sandpiper | subspecies | |||||||||||||
3901 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3894, 3901] | 1 | Numenius phaeopus | 3894 | 48460/1/2/355675/3/67561/3835/3894 | 0 | {"id": 1940369, "license_code": "cc-by-nc", "attribution": "(c) Paul Cools, some rights reserved (CC BY-NC), uploaded by Paul Cools", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1940369/square.jpg", "original_dimensions": {"height": 588, "width": 900}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1940369/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1940369/medium.jpg"} | 0 | 10 | 30672 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Whimbrel | Aves | Whimbrel | subspecies | |||||||||||||
3959 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3957, 3959] | 1 | Phalaropus lobatus | 3957 | 48460/1/2/355675/3/67561/3835/3957 | 0 | {"id": 239811, "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/239811/square.jpg", "original_dimensions": {"height": 933, "width": 1400}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/239811/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/239811/medium.jpg"} | 0 | 10 | 9584 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Red-necked_phalarope | Aves | Red-necked Phalarope | subspecies | |||||||||||||
4353 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4342, 447155, 4343, 4353] | 1 | Larus heermanni | 4343 | 48460/1/2/355675/3/67561/4342/447155/4343 | 0 | {"id": 478385, "license_code": null, "attribution": "(c) BJ Stacey, all rights reserved", "url": "https://static.inaturalist.org/photos/478385/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/478385/square.jpg", "medium_url": "https://static.inaturalist.org/photos/478385/medium.jpg"} | 0 | 10 | 15425 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Heermann's_gull | Aves | Heermann's Gull | subspecies | {"id": 185934, "place_id": null, "source_id": null, "user_id": null, "authority": "IUCN Red List", "status": "nt", "status_name": "near threatened", "geoprivacy": "open", "iucn": 20} | ||||||||||||
4838 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 71325, 4837, 4838] | 1 | Haematopus bachmani | 4837 | 48460/1/2/355675/3/67561/71325/4837 | 0 | {"id": 2059, "license_code": "cc-by", "attribution": "(c) Mike Baird, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2059/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2059/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2059/medium.jpg"} | 1 | 10 | 12902 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Black_oystercatcher | Aves | Black Oystercatcher | subspecies | 48460,1,2,355675,3,67561,71325,4837,4838 | 0 | 4838 | 0 | 0 | 1 | 2008-03-13T02:46:32+00:00 | 0 | 12902 | ||||
4892 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4783, 4888, 4892] | 1 | Pluvialis squatarola | 4888 | 48460/1/2/355675/3/67561/4783/4888 | 0 | {"id": 10603462, "license_code": null, "attribution": "(c) TroyEcol, all rights reserved, uploaded by TroyEcol", "url": "https://static.inaturalist.org/photos/10603462/square.jpg", "original_dimensions": {"height": 683, "width": 1024}, "flags": [], "square_url": "https://static.inaturalist.org/photos/10603462/square.jpg", "medium_url": "https://static.inaturalist.org/photos/10603462/medium.jpg"} | 1 | 10 | 32224 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Grey_plover | Aves | Black-bellied Plover | subspecies | |||||||||||||
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 | 96076 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Black-crowned_night_heron | Aves | Black-crowned Night Heron | subspecies | |||||||||||||
5112 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 71261, 5067, 1541538, 5085, 5112] | 1 | Accipiter cooperii | 5085 | 48460/1/2/355675/3/71261/5067/1541538/5085 | 0 | {"id": 170370008, "license_code": "cc-by-nc", "attribution": "(c) Abby Sesselberg, some rights reserved (CC BY-NC), uploaded by Abby Sesselberg", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/170370008/square.jpg", "original_dimensions": {"height": 1828, "width": 2044}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/170370008/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/170370008/medium.jpg"} | 1 | 10 | 92896 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Cooper's_hawk | Aves | Cooper's Hawk | subspecies | |||||||||||||
5206 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 71261, 5067, 5179, 5206] | 1 | Buteo lineatus | 5179 | 48460/1/2/355675/3/71261/5067/5179 | 0 | {"id": 5600620, "license_code": "cc-by-nc", "attribution": "(c) Richard Wottrich, some rights reserved (CC BY-NC), uploaded by Richard Wottrich", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5600620/square.jpg", "original_dimensions": {"height": 751, "width": 1000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5600620/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5600620/medium.jpg"} | 0 | 10 | 102633 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Red-shouldered_hawk | Aves | Red-shouldered Hawk | subspecies | |||||||||||||
6930 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 6888, 6912, 6922, 6930] | 1 | Anas platyrhynchos | 6922 | 48460/1/2/355675/3/6888/6912/6922 | 0 | {"id": 95268822, "license_code": "cc-by-sa", "attribution": "(c) anonymous, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/95268822/square.jpg", "original_dimensions": {"height": 1256, "width": 2048}, "flags": [{"id": 582739, "flag": "spam", "comment": "not spam", "user_id": 5941059, "resolver_id": 340786, "resolved": true, "created_at": "2022-07-25T22:28:00.054Z", "updated_at": "2022-07-26T01:10:20.101Z"}], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/95268822/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/95268822/medium.jpg"} | 0 | 10 | 536495 | {"resolved": 12, "unresolved": 0} | http://en.wikipedia.org/wiki/Mallard | Aves | Mallard | subspecies | |||||||||||||
7089 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 6888, 6912, 7086, 7089] | 1 | Branta canadensis | 7086 | 48460/1/2/355675/3/6888/6912/7086 | 0 | {"id": 181719420, "license_code": null, "attribution": "(c) Dimitris Salas, all rights reserved, uploaded by Dimitris Salas", "url": "https://static.inaturalist.org/photos/181719420/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/181719420/square.jpg", "medium_url": "https://static.inaturalist.org/photos/181719420/medium.jpg"} | 0 | 10 | 286401 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Canada_goose | Aves | Canada Goose | subspecies | 48460,1,2,355675,3,6888,6912,7086,7089 | 0 | 7089 | 0 | 0 | 1 | 2008-03-13T02:53:16+00:00 | 0 | 286401 | ||||
14823 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 14799, 14800, 14823] | 1 | Sitta canadensis | 14800 | 48460/1/2/355675/3/7251/14799/14800 | 0 | {"id": 327483470, "license_code": null, "attribution": "(c) Draginous, all rights reserved, uploaded by Draginous", "url": "https://static.inaturalist.org/photos/327483470/square.png", "original_dimensions": {"height": 708, "width": 588}, "flags": [], "square_url": "https://static.inaturalist.org/photos/327483470/square.png", "medium_url": "https://static.inaturalist.org/photos/327483470/medium.png"} | 0 | 10 | 35307 | {"resolved": 2, "unresolved": 1} | http://en.wikipedia.org/wiki/Red-breasted_nuthatch | Aves | Red-breasted Nuthatch | subspecies | |||||||||||||
14850 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 14841, 14842, 14850] | 1 | Sturnus vulgaris | 14842 | 48460/1/2/355675/3/7251/14841/14842 | 0 | {"id": 32152001, "license_code": "cc-by-nc-nd", "attribution": "(c) Fran Wiesner, some rights reserved (CC BY-NC-ND), uploaded by Fran Wiesner", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32152001/square.jpg", "original_dimensions": {"height": 667, "width": 1000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32152001/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32152001/medium.jpg"} | 0 | 10 | 197288 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Common_starling | Aves | European Starling | subspecies | 48460,1,2,355675,3,7251,14841,14842,14850 | 0 | 14850 | 0 | 1 | 0 | 2008-03-13T03:23:08+00:00 | 0 | 197288 | ||||
14886 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 59911, 14877, 14886] | 1 | Mimus polyglottos | 14877 | 48460/1/2/355675/3/7251/59911/14877 | 0 | {"id": 101226350, "license_code": "cc-by-nc", "attribution": "(c) Ad Konings, some rights reserved (CC BY-NC), uploaded by Ad Konings", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101226350/square.jpg", "original_dimensions": {"height": 1270, "width": 2000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101226350/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101226350/medium.jpg"} | 1 | 10 | 148751 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Northern_mockingbird | Aves | Northern Mockingbird | 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 | 101754 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Northern_flicker | Aves | Northern Flicker | subspecies | |||||||||||||
73203 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3957, 73203] | 1 | Phalaropus fulicarius | 3957 | 48460/1/2/355675/3/67561/3835/3957 | 0 | {"id": 1940554, "license_code": "cc-by-nc", "attribution": "(c) Paul Cools, some rights reserved (CC BY-NC), uploaded by Paul Cools", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1940554/square.jpg", "original_dimensions": {"height": 597, "width": 900}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1940554/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1940554/medium.jpg"} | 0 | 10 | 2406 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Red_phalarope | Aves | Red Phalarope | 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);