taxons
8 rows where rank = "genus"
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_changes_count, taxon_schemes_count, flag_counts, iconic_taxon_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6358 | genus | 20 | 3 | [48460, 1, 2, 355675, 3, 67573, 5562, 1542290, 1542294, 6358] | 1 | Selasphorus | 1542294 | 48460/1/2/355675/3/67573/5562/1542290/1542294 | 0 | {"id": 69311285, "license_code": null, "attribution": "(c) Roberto Carlos Martinez, all rights reserved, uploaded by Roberto Carlos Martinez", "url": "https://static.inaturalist.org/photos/69311285/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/69311285/square.jpg", "medium_url": "https://static.inaturalist.org/photos/69311285/medium.jpg"} | 1 | 1 | 50064 | {"resolved": 5, "unresolved": 0} | 9 | http://en.wikipedia.org/wiki/Selasphorus | Aves | Rufous, Allen's, and Allied Hummingbirds | subspecies | ||||||||||||
47603 | genus | 20 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 447425, 359450, 632701, 47603] | 1 | Taraxacum | 632701 | 48460/47126/211194/47125/47124/47605/47604/447425/359450/632701 | 0 | {"id": 106557104, "license_code": "cc-by-nc", "attribution": "(c) Masha, some rights reserved (CC BY-NC), uploaded by Masha", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/106557104/square.jpg", "original_dimensions": {"height": 768, "width": 1024}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/106557104/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/106557104/medium.jpg"} | 1 | 2 | 323938 | {"resolved": 10, "unresolved": 0} | https://en.wikipedia.org/wiki/Taraxacum | Plantae | dandelions | ||||||||||||||
47804 | genus | 20 | 1 | [48460, 1, 47120, 85493, 473790, 47187, 774775, 144113, 47186, 118451, 123825, 47806, 47805, 47804] | 1 | Petrolisthes | 47805 | 48460/1/47120/85493/473790/47187/774775/144113/47186/118451/123825/47806/47805 | 0 | {"id": 23214824, "license_code": "cc-by-nc", "attribution": "(c) Gaurav Patil, some rights reserved (CC BY-NC), uploaded by Gaurav Patil", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/23214824/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/23214824/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/23214824/medium.jpg"} | 0 | 2 | 5897 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Petrolisthes | Animalia | |||||||||||||||
51218 | genus | 20 | 1 | [48460, 1, 47534, 48921, 551473, 48925, 813997, 51219, 51218] | 1 | Aglaophenia | 51219 | 48460/1/47534/48921/551473/48925/813997/51219 | 0 | {"id": 208114380, "license_code": "cc-by-nc", "attribution": "(c) Julia Markey, some rights reserved (CC BY-NC), uploaded by Julia Markey", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/208114380/square.jpeg", "original_dimensions": {"height": 2048, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/208114380/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/208114380/medium.jpeg"} | 0 | 1 | 2393 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Aglaophenia | Animalia | Ostrich-Plume Hydroids | ||||||||||||||
55978 | genus | 20 | 47126 | [48460, 47126, 211194, 47125, 47124, 48796, 48797, 860115, 860842, 55978] | 1 | Malva | 860842 | 48460/47126/211194/47125/47124/48796/48797/860115/860842 | 0 | {"id": 39050178, "license_code": null, "attribution": "(c) L, all rights reserved, uploaded by L", "url": "https://static.inaturalist.org/photos/39050178/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/39050178/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/39050178/medium.jpeg"} | 1 | 0 | 157709 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Malva | Plantae | Mallows | ||||||||||||||
61356 | genus | 20 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47201, 124417, 326777, 48740, 52747, 84738, 61356] | 1 | Vespula | 84738 | 48460/1/47120/372739/47158/184884/47201/124417/326777/48740/52747/84738 | 0 | {"id": 56189528, "license_code": "cc-by-nc", "attribution": "(c) tex-anne, some rights reserved (CC BY-NC), uploaded by tex-anne", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/56189528/square.jpeg", "original_dimensions": {"height": 1532, "width": 1830}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/56189528/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/56189528/medium.jpeg"} | 1 | 2 | 113550 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Vespula | Insecta | Ground Yellowjackets | ||||||||||||||
117800 | genus | 20 | 47126 | [48460, 47126, 57774, 1360860, 57775, 1051024, 67673, 117782, 117800] | 1 | Farlowia | 117782 | 48460/47126/57774/1360860/57775/1051024/67673/117782 | 0 | {"id": 3768631, "license_code": "cc-by-nc-sa", "attribution": "(c) Gary W. Saunders, University of New Brunswick, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3768631/square.jpeg", "original_dimensions": {"height": 375, "width": 499}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3768631/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3768631/medium.jpeg"} | 0 | 1 | 206 | {"resolved": 0, "unresolved": 0} | Plantae | ||||||||||||||||
311431 | genus | 20 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47822, 48091, 372853, 414448, 49995, 186841, 121991, 311431] | 1 | Paragus | 121991 | 48460/1/47120/372739/47158/184884/47822/48091/372853/414448/49995/186841/121991 | 0 | {"id": 92560552, "license_code": "cc-by", "attribution": "(c) Katja Schulz, some rights reserved (CC BY), uploaded by Katja Schulz", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/92560552/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/92560552/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/92560552/medium.jpg"} | 0 | 1 | 6645 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Paragus | Insecta | Grass Skimmer Flies |
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);