taxons
7 rows where iconic_taxon_id = 47119
This data as json, CSV (advanced)
Suggested facets: taxon_changes_count, taxon_schemes_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47135 | species | 10 | 47119 | [48460, 1, 47120, 245097, 47119, 47118, 120474, 342614, 1529315, 1528047, 47134, 1465406, 47133, 47135] | 1 | Badumna longinqua | 47133 | 48460/1/47120/245097/47119/47118/120474/342614/1529315/1528047/47134/1465406/47133 | 0 | {"id": 10956151, "license_code": "cc-by-nc", "attribution": "(c) Tony Iwane, some rights reserved (CC BY-NC), uploaded by Tony Iwane", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10956151/square.jpg", "original_dimensions": {"height": 2048, "width": 1441}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10956151/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10956151/medium.jpg"} | 0 | 2 | 6411 | {"resolved": 0, "unresolved": 0} | 28724 | http://en.wikipedia.org/wiki/Badumna_longinqua | Arachnida | Grey House Spider | |||||||||||||
58421 | species | 10 | 47119 | [48460, 1, 47120, 245097, 47119, 47118, 120474, 342614, 367200, 48139, 606933, 712034, 1109044, 53810, 1362558, 58421] | 1 | Phidippus johnsoni | 1362558 | 48460/1/47120/245097/47119/47118/120474/342614/367200/48139/606933/712034/1109044/53810/1362558 | 0 | {"id": 302220, "license_code": "pd", "attribution": "Kaldari, no known copyright restrictions (public domain)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/302220/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/302220/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/302220/medium.jpg"} | 1 | 3 | 7849 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Phidippus_johnsoni | Arachnida | Johnson's Jumping Spider | ||||||||||||||
68912 | species | 10 | 47119 | [48460, 1, 47120, 245097, 47119, 47118, 120474, 367158, 1528408, 367170, 69200, 1544812, 69201, 1454862, 68912] | 1 | Dysdera crocata | 1454862 | 48460/1/47120/245097/47119/47118/120474/367158/1528408/367170/69200/1544812/69201/1454862 | 0 | {"id": 63487046, "license_code": null, "attribution": "(c) Graham Montgomery, all rights reserved, uploaded by Graham Montgomery", "url": "https://static.inaturalist.org/photos/63487046/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/63487046/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/63487046/medium.jpeg"} | 0 | 4 | 16750 | {"resolved": 1, "unresolved": 0} | 28751 | http://en.wikipedia.org/wiki/Woodlouse_spider | Arachnida | Woodlouse Spider | |||||||||||||
84644 | species | 10 | 47119 | [48460, 1, 47120, 245097, 47119, 47367, 372840, 61350, 57409, 429497, 61487, 84644] | 1 | Phalangium opilio | 61487 | 48460/1/47120/245097/47119/47367/372840/61350/57409/429497/61487 | 0 | {"id": 1219792, "license_code": "cc-by", "attribution": "(c) Steve Kerr, some rights reserved (CC BY), uploaded by Steve Kerr", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1219792/square.", "original_dimensions": {"height": 1592, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1219792/square.", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1219792/medium."} | 0 | 3 | 29065 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Phalangium_opilio | Arachnida | European Harvestman | ||||||||||||||
127112 | species | 10 | 47119 | [48460, 1, 47120, 245097, 47119, 47118, 120474, 342614, 1529315, 1529320, 367161, 127113, 127114, 127112] | 1 | Zoropsis spinimana | 127114 | 48460/1/47120/245097/47119/47118/120474/342614/1529315/1529320/367161/127113/127114 | 0 | {"id": 341950718, "license_code": null, "attribution": "(c) Tiago Carneiro, all rights reserved, uploaded by Tiago Carneiro", "url": "https://static.inaturalist.org/photos/341950718/square.jpeg", "original_dimensions": {"height": 2048, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/341950718/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/341950718/medium.jpeg"} | 0 | 1 | 13198 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Zoropsis_spinimana | Arachnida | Mediterranean Spiny False Wolf Spider | ||||||||||||||
210501 | species | 10 | 47119 | [48460, 1, 47120, 245097, 47119, 47118, 120474, 342614, 367200, 48139, 606933, 712034, 1109044, 172233, 210501] | 1 | Terralonus californicus | 172233 | 48460/1/47120/245097/47119/47118/120474/342614/367200/48139/606933/712034/1109044/172233 | 0 | {"id": 13725785, "license_code": null, "attribution": "(c) Alice Abela, all rights reserved", "url": "https://static.inaturalist.org/photos/13725785/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/13725785/square.jpg", "medium_url": "https://static.inaturalist.org/photos/13725785/medium.jpg"} | 0 | 3 | 454 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Terralonus_californicus | Arachnida | Intertidal Jumping Spider | ||||||||||||||
366894 | species | 10 | 47119 | [48460, 1, 47120, 245097, 47119, 47118, 120474, 342614, 319384, 47371, 1472111, 61998, 366894] | 1 | Steatoda nobilis | 61998 | 48460/1/47120/245097/47119/47118/120474/342614/319384/47371/1472111/61998 | 0 | {"id": 53352329, "license_code": "cc-by", "attribution": "(c) Martin Cooper, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/53352329/square.jpg", "original_dimensions": {"height": 1336, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/53352329/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/53352329/medium.jpg"} | 0 | 1 | 21467 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Steatoda_nobilis | Arachnida | Noble False Widow |
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);