taxons
7 rows where flag_counts = "{"resolved": 2, "unresolved": 1}"
This data as json, CSV (advanced)
Suggested facets: rank, rank_level, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
41440 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 152870, 925158, 152871, 424322, 1317261, 41437, 41438, 41440] | 1 | Phocoena phocoena | 41438 | 48460/1/2/355675/40151/848317/848320/848324/152870/925158/152871/424322/1317261/41437/41438 | 0 | {"id": 11936582, "license_code": "cc-by-sa", "attribution": "(c) Ecomare/Salko de Wolf, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11936582/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11936582/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11936582/medium.jpg"} | 1 | 5 | 7995 | {"resolved": 2, "unresolved": 1} | http://en.wikipedia.org/wiki/Harbour_porpoise | Mammalia | Harbour Porpoise | ||||||||||||||
53052 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48700, 48699, 790553, 790576, 53053, 53052] | 1 | Foeniculum vulgare | 53053 | 48460/47126/211194/47125/47124/48700/48699/790553/790576/53053 | 0 | {"id": 50868492, "license_code": null, "attribution": "(c) Allie Schiltmeyer, all rights reserved, uploaded by Allie Schiltmeyer", "url": "https://static.inaturalist.org/photos/50868492/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://static.inaturalist.org/photos/50868492/square.jpg", "medium_url": "https://static.inaturalist.org/photos/50868492/medium.jpg"} | 2 | 7 | 33119 | {"resolved": 2, "unresolved": 1} | http://en.wikipedia.org/wiki/Fennel | Plantae | fennel | ||||||||||||||
57076 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47123, 47122, 507502, 512504, 51876, 960968, 57076] | 1 | Trifolium campestre | 960968 | 48460/47126/211194/47125/47124/47123/47122/507502/512504/51876/960968 | 0 | {"id": 73248929, "license_code": "cc-by", "attribution": "(c) Kevin Thiele, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/73248929/square.jpg", "original_dimensions": {"height": 1610, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/73248929/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/73248929/medium.jpg"} | 2 | 5 | 23224 | {"resolved": 2, "unresolved": 1} | https://en.wikipedia.org/wiki/Trifolium_campestre | Plantae | hop trefoil | ||||||||||||||
57283 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48526, 48527, 345609, 57286, 57283] | 1 | Centranthus ruber | 57286 | 48460/47126/211194/47125/47124/48526/48527/345609/57286 | 0 | {"id": 11861, "license_code": "cc-by-nd", "attribution": "(c) Katie Claypoole, some rights reserved (CC BY-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11861/square.jpg", "original_dimensions": {"height": 1371, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11861/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11861/medium.jpg"} | 1 | 4 | 28367 | {"resolved": 2, "unresolved": 1} | http://en.wikipedia.org/wiki/Centranthus_ruber | Plantae | Red Valerian | ||||||||||||||
558446 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 71261, 5067, 1541538, 5163, 558446] | 1 | Circus hudsonius | 5163 | 48460/1/2/355675/3/71261/5067/1541538/5163 | 0 | {"id": 114035783, "license_code": null, "attribution": "(c) krisscully, all rights reserved", "url": "https://static.inaturalist.org/photos/114035783/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/114035783/square.jpg", "medium_url": "https://static.inaturalist.org/photos/114035783/medium.jpg"} | 2 | 2 | 39727 | {"resolved": 2, "unresolved": 1} | 11419 | http://en.wikipedia.org/wiki/Northern_harrier | Aves | Northern Harrier | subspecies | ||||||||||||
995125 | subspecies | 5 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 47204, 1473853, 1473856, 574731, 55412, 55411, 995125] | 1 | Raphanus raphanistrum sativus | 55411 | 48460/47126/211194/47125/47124/71275/47204/1473853/1473856/574731/55412/55411 | 0 | {"id": 28387821, "license_code": "cc0", "attribution": "no rights reserved, uploaded by 葉子", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28387821/square.jpeg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28387821/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28387821/medium.jpeg"} | 3 | 1 | 25012 | {"resolved": 2, "unresolved": 1} | Plantae | wild and domestic radish | 48460,47126,211194,47125,47124,71275,47204,1473853,1473856,574731,55412,55411 | 0 | 55411 | 0 | 1 | 0 | 2020-01-09T02:49:58+00:00 | 0 | 25012 |
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);