taxons
4 rows where rank = "subspecies"
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_changes_count, taxon_schemes_count, flag_counts, iconic_taxon_name, endemic, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32068 | subspecies | 5 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85552, 31888, 797512, 32049, 32064, 32068] | 1 | Elgaria coerulea coerulea | 32064 | 48460/1/2/355675/26036/26172/85552/31888/797512/32049/32064 | 0 | {"id": 19546057, "license_code": "cc-by-nc", "attribution": "(c) Zach Lim, some rights reserved (CC BY-NC), uploaded by Zach Lim", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19546057/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19546057/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19546057/medium.jpg"} | 0 | 3 | 885 | {"resolved": 0, "unresolved": 0} | Reptilia | San Francisco Alligator Lizard | 48460,1,2,355675,26036,26172,85552,31888,797512,32049,32064 | 1 | 32064 | 0 | 0 | 1 | 2008-03-18T01:42:39+00:00 | 0 | 885 | ||||||
48267 | subspecies | 5 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85553, 30667, 797576, 30692, 48268, 48267] | 1 | Crotalus oreganus oreganus | 48268 | 48460/1/2/355675/26036/26172/85553/30667/797576/30692/48268 | 0 | {"id": 764916, "license_code": "cc-by-nc", "attribution": "(c) owenrtm77, some rights reserved (CC BY-NC), uploaded by owenrtm77", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/764916/square.jpg", "original_dimensions": {"height": 600, "width": 800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/764916/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/764916/medium.jpg"} | 0 | 3 | 8673 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Crotalus_oreganus | Reptilia | Northern Pacific Rattlesnake | 48460,1,2,355675,26036,26172,85553,30667,797576,30692,48268 | 0 | 48268 | 0 | 0 | 1 | 2008-09-01T06:53:56+00:00 | 0 | 8673 | |||||
117766 | subspecies | 5 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 41573, 372843, 41687, 41707, 41708, 117766] | 1 | Phoca vitulina richardii | 41708 | 48460/1/2/355675/40151/848317/848320/848324/41573/372843/41687/41707/41708 | 0 | {"id": 231409105, "license_code": "cc-by-nc", "attribution": "(c) Igor Derevskov, some rights reserved (CC BY-NC), uploaded by Igor Derevskov", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/231409105/square.jpg", "original_dimensions": {"height": 1465, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/231409105/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/231409105/medium.jpg"} | 3 | 3 | 14236 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Harbor_seal | Mammalia | Pacific Harbor Seal | 48460,1,2,355675,40151,848317,848320,848324,41573,372843,41687,41707,41708 | 0 | 41708 | 0 | 0 | 1 | 2011-08-16T22:31:43+00:00 | 0 | 14236 | |||||
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);