taxons
6 rows where taxon_schemes_count = 11
This data as json, CSV (advanced)
Suggested facets: taxon_changes_count, flag_counts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3017 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 2708, 2715, 3000, 3017] | 1 | Columba livia | 3000 | 48460/1/2/355675/3/2708/2715/3000 | 0 | {"id": 96934693, "license_code": "cc-by-nc", "attribution": "(c) Константин Самодуров, some rights reserved (CC BY-NC), uploaded by Константин Самодуров", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96934693/square.jpg", "original_dimensions": {"height": 800, "width": 1200}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96934693/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/96934693/medium.jpg"} | 0 | 11 | 245429 | {"resolved": 8, "unresolved": 0} | http://en.wikipedia.org/wiki/Rock_dove | Aves | Rock Pigeon | subspecies | |||||||||||||
3849 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3836, 3849] | 1 | Calidris alba | 3836 | 48460/1/2/355675/3/67561/3835/3836 | 0 | {"id": 55826082, "license_code": "cc-by-nc", "attribution": "(c) lemurtaquin, some rights reserved (CC BY-NC), uploaded by lemurtaquin", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/55826082/square.jpeg", "original_dimensions": {"height": 550, "width": 733}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/55826082/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/55826082/medium.jpeg"} | 2 | 11 | 50525 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Sanderling | Aves | Sanderling | subspecies | |||||||||||||
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 | |||||||||||||
4647 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67570, 4637, 4638, 4647] | 1 | Falco peregrinus | 4638 | 48460/1/2/355675/3/67570/4637/4638 | 0 | {"id": 3356824, "license_code": "cc-by-sa", "attribution": "(c) Carlos Delgado, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3356824/square.jpg", "original_dimensions": {"height": 1395, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3356824/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3356824/medium.jpg"} | 0 | 11 | 36278 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Peregrine_falcon | Aves | Peregrine Falcon | subspecies | |||||||||||||
4896 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4783, 4888, 4896] | 1 | Pluvialis fulva | 4888 | 48460/1/2/355675/3/67561/4783/4888 | 0 | {"id": 43835792, "license_code": "cc-by", "attribution": "(c) James M. Maley, some rights reserved (CC BY), uploaded by James M. Maley", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/43835792/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/43835792/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/43835792/medium.jpg"} | 0 | 11 | 9327 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Pacific_golden_plover | Aves | Pacific Golden Plover | subspecies | |||||||||||||
13858 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 13685, 13847, 13858] | 1 | Passer domesticus | 13847 | 48460/1/2/355675/3/7251/13685/13847 | 0 | {"id": 4608133, "license_code": "cc-by-nc-sa", "attribution": "(c) Ximo Galarza, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4608133/square.jpg", "original_dimensions": {"height": 1291, "width": 1936}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4608133/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4608133/medium.jpg"} | 0 | 11 | 315633 | {"resolved": 7, "unresolved": 0} | http://en.wikipedia.org/wiki/House_sparrow | Aves | House Sparrow | 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);