taxons
21 rows where iconic_taxon_id = 48222
This data as json, CSV (advanced)
Suggested facets: parent_id, ancestry, taxon_changes_count, taxon_schemes_count, observations_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67419 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 67418, 67421, 67419] | 1 | Egregia menziesii | 67421 | 48460/48222/48221/48220/1267990/68789/67418/67421 | 0 | {"id": 55064789, "license_code": "cc-by-nc", "attribution": "(c) cnguon07, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/55064789/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/55064789/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/55064789/medium.jpg"} | 1 | 1 | 8802 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Egregia_menziesii | Chromista | Feather Boa Kelp | ||||||||||||||
69155 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 48219, 48218, 48217, 69155] | 1 | Fucus distichus | 48217 | 48460/48222/48221/48220/1267990/48219/48218/48217 | 0 | {"id": 172523522, "license_code": "cc-by-nc-sa", "attribution": "(c) Steve Sullivan, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172523522/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172523522/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172523522/medium.jpg"} | 0 | 1 | 13571 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Fucus_distichus | Chromista | Rockweed | ||||||||||||||
81896 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 67425, 67424, 81896] | 1 | Laminaria setchellii | 67424 | 48460/48222/48221/48220/1267990/68789/67425/67424 | 0 | {"id": 89473, "license_code": "cc-by-sa", "attribution": "(c) Bill Bouton, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/89473/square.jpg", "original_dimensions": {"height": 768, "width": 1024}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/89473/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/89473/medium.jpg"} | 0 | 1 | 907 | {"resolved": 0, "unresolved": 0} | Chromista | Southern stiff-stiped kelp | |||||||||||||||
117815 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 48219, 48218, 117830, 117815] | 1 | Silvetia compressa | 117830 | 48460/48222/48221/48220/1267990/48219/48218/117830 | 0 | {"id": 79622, "license_code": "cc-by-nc", "attribution": "(c) rebafay, some rights reserved (CC BY-NC), uploaded by rebafay", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/79622/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/79622/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/79622/medium.jpg"} | 1 | 1 | 2690 | {"resolved": 0, "unresolved": 0} | Chromista | golden rockweed | |||||||||||||||
120499 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 67425, 120502, 120499] | 1 | Nereocystis luetkeana | 120502 | 48460/48222/48221/48220/1267990/68789/67425/120502 | 0 | {"id": 4963877, "license_code": "cc-by-nc", "attribution": "(c) Kate Turner, some rights reserved (CC BY-NC), uploaded by Kate Turner", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4963877/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4963877/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4963877/medium.jpeg"} | 0 | 1 | 8941 | {"resolved": 0, "unresolved": 0} | https://en.wikipedia.org/wiki/Nereocystis | Chromista | Bull Kelp | ||||||||||||||
124146 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 123804, 124147, 124146] | 1 | Pterygophora californica | 124147 | 48460/48222/48221/48220/1267990/68789/123804/124147 | 0 | {"id": 5533339, "license_code": "cc-by", "attribution": "(c) Ken-ichi Ueda, some rights reserved (CC BY), uploaded by Ken-ichi Ueda", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5533339/square.jpeg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5533339/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/5533339/medium.jpeg"} | 0 | 1 | 881 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Pterygophora_californica | Chromista | stalked kelp | ||||||||||||||
124209 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 67425, 67424, 124209] | 1 | Laminaria sinclairii | 67424 | 48460/48222/48221/48220/1267990/68789/67425/67424 | 0 | {"id": 4215484, "license_code": "cc-by-nc", "attribution": "(c) Rebecca Johnson, some rights reserved (CC BY-NC), uploaded by Rebecca Johnson", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4215484/square.JPG", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4215484/square.JPG", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4215484/medium.JPG"} | 1 | 1 | 384 | {"resolved": 0, "unresolved": 0} | https://en.wikipedia.org/wiki/Laminaria_sinclairii | Chromista | dense-clumped kelp | ||||||||||||||
124748 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 67425, 124749, 124748] | 1 | Macrocystis pyrifera | 124749 | 48460/48222/48221/48220/1267990/68789/67425/124749 | 0 | {"id": 187358921, "license_code": null, "attribution": "(c) Pat Webster @underwaterpat, all rights reserved, uploaded by Pat Webster @underwaterpat", "url": "https://static.inaturalist.org/photos/187358921/square.jpg", "original_dimensions": {"height": 2000, "width": 1600}, "flags": [], "square_url": "https://static.inaturalist.org/photos/187358921/square.jpg", "medium_url": "https://static.inaturalist.org/photos/187358921/medium.jpg"} | 1 | 2 | 10705 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Macrocystis_pyrifera | Chromista | Giant Kelp | ||||||||||||||
124814 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 123804, 124813, 124814] | 1 | Alaria marginata | 124813 | 48460/48222/48221/48220/1267990/68789/123804/124813 | 0 | {"id": 29782357, "license_code": "cc-by-nc", "attribution": "(c) John D Reynolds, some rights reserved (CC BY-NC), uploaded by John D Reynolds", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/29782357/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/29782357/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/29782357/medium.jpg"} | 2 | 1 | 1278 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Alaria_marginata | Chromista | winged kelp | ||||||||||||||
125338 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 48219, 48218, 125339, 125338] | 1 | Pelvetiopsis limitata | 125339 | 48460/48222/48221/48220/1267990/48219/48218/125339 | 0 | {"id": 3879233, "license_code": null, "attribution": "(c) Pauline Seales, all rights reserved, uploaded by Pauline Seales", "url": "https://static.inaturalist.org/photos/3879233/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/3879233/square.jpg", "medium_url": "https://static.inaturalist.org/photos/3879233/medium.jpg"} | 0 | 1 | 1394 | {"resolved": 0, "unresolved": 0} | Chromista | Little Rockweed | |||||||||||||||
125877 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 500820, 125878, 125877] | 1 | Costaria costata | 125878 | 48460/48222/48221/48220/1267990/68789/500820/125878 | 0 | {"id": 3932195, "license_code": "cc-by-nc", "attribution": "(c) Rebecca Johnson, some rights reserved (CC BY-NC), uploaded by Rebecca Johnson", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3932195/square.JPG", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3932195/square.JPG", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3932195/medium.JPG"} | 0 | 1 | 1107 | {"resolved": 0, "unresolved": 0} | Chromista | seersucker kelp | |||||||||||||||
125881 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 500820, 125882, 125881] | 1 | Dictyoneurum californicum | 125882 | 48460/48222/48221/48220/1267990/68789/500820/125882 | 0 | {"id": 837705, "license_code": "cc-by-nc", "attribution": "(c) Gena Bentall, some rights reserved (CC BY-NC), uploaded by Gena Bentall", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/837705/square.jpg", "original_dimensions": {"height": 852, "width": 1136}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/837705/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/837705/medium.jpg"} | 0 | 1 | 169 | {"resolved": 0, "unresolved": 0} | Chromista | Net-of-Cords Kelp | |||||||||||||||
126126 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 48219, 126125, 126128, 126126] | 1 | Stephanocystis osmundacea | 126128 | 48460/48222/48221/48220/1267990/48219/126125/126128 | 0 | {"id": 9040251, "license_code": "cc-by", "attribution": "(c) Sam Kieschnick, some rights reserved (CC BY), uploaded by Sam Kieschnick", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/9040251/square.jpeg", "original_dimensions": {"height": 1200, "width": 1600}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/9040251/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/9040251/medium.jpeg"} | 1 | 1 | 1996 | {"resolved": 0, "unresolved": 0} | Chromista | chain bladder kelp | |||||||||||||||
130177 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 48219, 126125, 130178, 130177] | 1 | Sargassum muticum | 130178 | 48460/48222/48221/48220/1267990/48219/126125/130178 | 0 | {"id": 315008207, "license_code": "cc-by-nc", "attribution": "(c) Alexis, some rights reserved (CC BY-NC), uploaded by Alexis", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/315008207/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/315008207/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/315008207/medium.jpeg"} | 0 | 1 | 5076 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Sargassum_muticum | Chromista | Japanese Wireweed | ||||||||||||||
130230 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 706026, 117841, 129868, 130230] | 1 | Analipus japonicus | 129868 | 48460/48222/48221/48220/1267990/706026/117841/129868 | 0 | {"id": 1976667, "license_code": "cc-by-nc-sa", "attribution": "(c) Brenna Green, some rights reserved (CC BY-NC-SA), uploaded by Brenna Green", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1976667/square.JPG", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1976667/square.JPG", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1976667/medium.JPG"} | 1 | 1 | 226 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Analipus_japonicus | Chromista | Bottlebrush seaweed | ||||||||||||||
182932 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 117795, 117833, 182964, 182932] | 1 | Scytosiphon lomentaria | 182964 | 48460/48222/48221/48220/1267990/117795/117833/182964 | 0 | {"id": 172064108, "license_code": "cc-by-nc", "attribution": "(c) Frédéric ANDRE, some rights reserved (CC BY-NC), uploaded by Frédéric ANDRE", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172064108/square.jpg", "original_dimensions": {"height": 1500, "width": 2000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172064108/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172064108/medium.jpg"} | 1 | 1 | 891 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Scytosiphon_lomentaria | Chromista | Beanweed | ||||||||||||||
328357 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 152254, 153157, 153316, 328357] | 1 | Desmarestia ligulata | 153316 | 48460/48222/48221/48220/1267990/152254/153157/153316 | 0 | {"id": 753540, "license_code": "cc-by-nc-sa", "attribution": "(c) Brenna Green, some rights reserved (CC BY-NC-SA), uploaded by Brenna Green", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/753540/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/753540/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/753540/medium.jpg"} | 0 | 1 | 694 | {"resolved": 0, "unresolved": 0} | Chromista | flattened acid kelp | |||||||||||||||
465876 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 117795, 117796, 1240560, 465876] | 1 | Haplogloia andersonii | 1240560 | 48460/48222/48221/48220/1267990/117795/117796/1240560 | 0 | {"id": 1919481, "license_code": "cc-by-nc", "attribution": "(c) Rebecca Johnson, some rights reserved (CC BY-NC), uploaded by Rebecca Johnson", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1919481/square.JPG", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1919481/square.JPG", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1919481/medium.JPG"} | 0 | 1 | 70 | {"resolved": 0, "unresolved": 0} | Chromista | ||||||||||||||||
475636 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 117795, 1267520, 345164, 475636] | 1 | Petrospongium rugosum | 345164 | 48460/48222/48221/48220/1267990/117795/1267520/345164 | 0 | {"id": 2718965, "license_code": null, "attribution": "(c) BJ Stacey, all rights reserved", "url": "https://static.inaturalist.org/photos/2718965/square.jpg", "original_dimensions": {"height": 838, "width": 1260}, "flags": [], "square_url": "https://static.inaturalist.org/photos/2718965/square.jpg", "medium_url": "https://static.inaturalist.org/photos/2718965/medium.jpg"} | 1 | 1 | 222 | {"resolved": 0, "unresolved": 0} | Chromista | ||||||||||||||||
502380 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 117795, 117796, 182878, 502380] | 1 | Leathesia marina | 182878 | 48460/48222/48221/48220/1267990/117795/117796/182878 | 0 | {"id": 21462240, "license_code": null, "attribution": "(c) slgolden, all rights reserved", "url": "https://static.inaturalist.org/photos/21462240/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://static.inaturalist.org/photos/21462240/square.jpg", "medium_url": "https://static.inaturalist.org/photos/21462240/medium.jpg"} | 2 | 1 | 1996 | {"resolved": 0, "unresolved": 0} | Chromista | Sea Cauliflower | |||||||||||||||
1267793 | species | 10 | 48222 | [48460, 48222, 48221, 48220, 1267990, 68789, 67425, 67416, 1267793] | 1 | Postelsia palmiformis | 67416 | 48460/48222/48221/48220/1267990/68789/67425/67416 | 0 | {"id": 11250501, "license_code": "cc-by-nc-sa", "attribution": "(c) Jackson W.F. Chu, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11250501/square.jpg", "original_dimensions": {"height": 1432, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11250501/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11250501/medium.jpg"} | 1 | 0 | 2551 | {"resolved": 1, "unresolved": 0} | https://en.wikipedia.org/wiki/Postelsia | Chromista | Sea Palm |
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);