taxons
12 rows where iconic_taxon_name = "Reptilia"
This data as json, CSV (advanced)
Suggested facets: rank, rank_level, parent_id, ancestry, default_photo, taxon_changes_count, taxon_schemes_count, flag_counts, wikipedia_url, endemic, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
28398 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85553, 26504, 532896, 28339, 28398] | 1 | Thamnophis elegans | 28339 | 48460/1/2/355675/26036/26172/85553/26504/532896/28339 | 0 | {"id": 48379, "license_code": "cc0", "attribution": "no rights reserved", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/48379/square.jpg", "original_dimensions": {"height": 1200, "width": 1800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/48379/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/48379/medium.jpg"} | 1 | 6 | 20645 | {"resolved": 0, "unresolved": 0} | 224 | http://en.wikipedia.org/wiki/Western_terrestrial_garter_snake | Reptilia | Western Terrestrial Garter Snake | subspecies | ||||||||||||
28418 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85553, 26504, 532896, 28339, 28418] | 1 | Thamnophis atratus | 28339 | 48460/1/2/355675/26036/26172/85553/26504/532896/28339 | 0 | {"id": 4655, "license_code": "cc-by-nc-nd", "attribution": "(c) James Gaither, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4655/square.jpg", "original_dimensions": {"height": 1371, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4655/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4655/medium.jpg"} | 0 | 5 | 2640 | {"resolved": 0, "unresolved": 0} | 165 | http://en.wikipedia.org/wiki/Aquatic_garter_snake | Reptilia | Aquatic Garter Snake | subspecies | ||||||||||||
29044 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85553, 26504, 797520, 29033, 29044] | 1 | Pituophis catenifer | 29033 | 48460/1/2/355675/26036/26172/85553/26504/797520/29033 | 0 | {"id": 201400620, "license_code": null, "attribution": "(c) Hydrobates tethys, all rights reserved, uploaded by Hydrobates tethys", "url": "https://static.inaturalist.org/photos/201400620/square.jpg", "original_dimensions": {"height": 1245, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/201400620/square.jpg", "medium_url": "https://static.inaturalist.org/photos/201400620/medium.jpg"} | 2 | 6 | 50715 | {"resolved": 3, "unresolved": 0} | 143 | http://en.wikipedia.org/wiki/Pituophis_catenifer | Reptilia | Gopher Snake | subspecies | ||||||||||||
32055 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85552, 31888, 797512, 32049, 32055] | 1 | Elgaria multicarinata | 32049 | 48460/1/2/355675/26036/26172/85552/31888/797512/32049 | 0 | {"id": 17940973, "license_code": null, "attribution": "(c) Alice Abela, all rights reserved", "url": "https://static.inaturalist.org/photos/17940973/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/17940973/square.jpg", "medium_url": "https://static.inaturalist.org/photos/17940973/medium.jpg"} | 0 | 7 | 29015 | {"resolved": 0, "unresolved": 0} | 146 | http://en.wikipedia.org/wiki/Southern_alligator_lizard | Reptilia | Southern Alligator Lizard | subspecies | ||||||||||||
32064 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85552, 31888, 797512, 32049, 32064] | 1 | Elgaria coerulea | 32049 | 48460/1/2/355675/26036/26172/85552/31888/797512/32049 | 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 | 5 | 8294 | {"resolved": 1, "unresolved": 0} | 159 | http://en.wikipedia.org/wiki/Northern_alligator_lizard | Reptilia | Northern Alligator Lizard | subspecies | ||||||||||||
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 | ||||||
36094 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85552, 36074, 797562, 36090, 36094] | 1 | Uta stansburiana | 36090 | 48460/1/2/355675/26036/26172/85552/36074/797562/36090 | 0 | {"id": 6972589, "license_code": "cc-by-nc", "attribution": "(c) David Kaposi, some rights reserved (CC BY-NC), uploaded by David Kaposi", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6972589/square.jpg", "original_dimensions": {"height": 1331, "width": 1994}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6972589/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6972589/medium.jpg"} | 2 | 6 | 54528 | {"resolved": 0, "unresolved": 0} | 144 | http://en.wikipedia.org/wiki/Common_side-blotched_lizard | Reptilia | Common Side-blotched Lizard | subspecies | ||||||||||||
36204 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85552, 36074, 797562, 36141, 36204] | 1 | Sceloporus occidentalis | 36141 | 48460/1/2/355675/26036/26172/85552/36074/797562/36141 | 0 | {"id": 36416530, "license_code": "cc-by-nc", "attribution": "(c) Steven Kurniawidjaja, some rights reserved (CC BY-NC), uploaded by Steven Kurniawidjaja", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/36416530/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/36416530/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/36416530/medium.jpeg"} | 0 | 6 | 131324 | {"resolved": 2, "unresolved": 0} | 1 | http://en.wikipedia.org/wiki/Western_fence_lizard | Reptilia | Western Fence Lizard | subspecies | 48460,1,2,355675,26036,26172,85552,36074,797562,36141,36204 | 0 | 36204 | 0 | 0 | 1 | 2008-03-18T02:35:16+00:00 | 0 | 131324 | |||
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 | 8670 | {"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 | 8670 | |||||
48268 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85553, 30667, 797576, 30692, 48268] | 1 | Crotalus oreganus | 30692 | 48460/1/2/355675/26036/26172/85553/30667/797576/30692 | 0 | {"id": 14452020, "license_code": null, "attribution": "(c) Alice Abela, all rights reserved", "url": "https://static.inaturalist.org/photos/14452020/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/14452020/square.jpg", "medium_url": "https://static.inaturalist.org/photos/14452020/medium.jpg"} | 2 | 4 | 23691 | {"resolved": 2, "unresolved": 0} | 221 | http://en.wikipedia.org/wiki/Crotalus_oreganus | Reptilia | Western Rattlesnake | subspecies | ||||||||||||
243962 | species | 10 | 26036 | [48460, 1, 2, 355675, 26036, 26172, 85553, 32080, 797543, 32103, 243962] | 1 | Charina bottae | 32103 | 48460/1/2/355675/26036/26172/85553/32080/797543/32103 | 0 | {"id": 30904873, "license_code": "cc-by-nc", "attribution": "(c) spencer_riffle, some rights reserved (CC BY-NC), uploaded by spencer_riffle", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30904873/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30904873/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30904873/medium.jpg"} | 2 | 3 | 3453 | {"resolved": 1, "unresolved": 0} | 660 | http://en.wikipedia.org/wiki/Rubber_boa | Reptilia | Northern Rubber Boa | 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);