taxons
49 rows where iconic_taxon_id = 47178
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47638 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 1363726, 47647, 47638] | 1 | Scorpaenichthys marmoratus | 47647 | 48460/1/2/355675/47178/47233/1303567/1363726/47647 | 0 | {"id": 112504004, "license_code": "cc-by-nc", "attribution": "(c) Sara Thiebaud, some rights reserved (CC BY-NC), uploaded by Sara Thiebaud", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/112504004/square.jpeg", "original_dimensions": {"height": 1741, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/112504004/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/112504004/medium.jpeg"} | 1 | 3 | 1327 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Cabezon_(fish) | Actinopterygii | Cabezon | ||||||||||||||
47760 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303568, 47285, 788495, 47762, 47760] | 1 | Sebastes melanops | 47762 | 48460/1/2/355675/47178/47233/1303568/47285/788495/47762 | 0 | {"id": 41836834, "license_code": null, "attribution": "(c) Jeff Stauffer, all rights reserved, uploaded by Jeff Stauffer", "url": "https://static.inaturalist.org/photos/41836834/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/41836834/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/41836834/medium.jpeg"} | 0 | 2 | 612 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Black_rockfish | Actinopterygii | Black rockfish | ||||||||||||||
49601 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47177, 1303584, 49607, 49604, 49601] | 1 | Mola mola | 49604 | 48460/1/2/355675/47178/47177/1303584/49607/49604 | 0 | {"id": 15722020, "license_code": "cc-by-nc", "attribution": "(c) tony rebelo, some rights reserved (CC BY-NC), uploaded by tony rebelo", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/15722020/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/15722020/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/15722020/medium.jpg"} | 0 | 4 | 2529 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Ocean_sunfish | Actinopterygii | Common Mola | {"id": 128197, "place_id": null, "source_id": null, "user_id": null, "authority": "IUCN Red List", "status": "vu", "status_name": "vulnerable", "geoprivacy": null, "iucn": 30} | |||||||||||||
52539 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 48454, 788593, 52540, 52539] | 1 | Ophiodon elongatus | 52540 | 48460/1/2/355675/47178/47233/1303567/48454/788593/52540 | 0 | {"id": 121620546, "license_code": null, "attribution": "(c) Pat Webster @underwaterpat, all rights reserved, uploaded by Pat Webster @underwaterpat", "url": "https://static.inaturalist.org/photos/121620546/square.jpg", "original_dimensions": {"height": 849, "width": 1200}, "flags": [], "square_url": "https://static.inaturalist.org/photos/121620546/square.jpg", "medium_url": "https://static.inaturalist.org/photos/121620546/medium.jpg"} | 0 | 4 | 2172 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Lingcod | Actinopterygii | Lingcod | ||||||||||||||
60635 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303564, 60633, 60634, 60635] | 1 | Anarrhichthys ocellatus | 60634 | 48460/1/2/355675/47178/47233/1303564/60633/60634 | 0 | {"id": 88468317, "license_code": "cc-by-nc", "attribution": "(c) Sara Thiebaud, some rights reserved (CC BY-NC), uploaded by Sara Thiebaud", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88468317/square.jpeg", "original_dimensions": {"height": 1455, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88468317/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88468317/medium.jpeg"} | 0 | 2 | 537 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Wolf_eel | Actinopterygii | Wolf Eel | ||||||||||||||
61376 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303564, 1303619, 61379, 61376] | 1 | Cebidichthys violaceus | 61379 | 48460/1/2/355675/47178/47233/1303564/1303619/61379 | 0 | {"id": 59532412, "license_code": "cc-by-nc", "attribution": "(c) Francis Joyce, some rights reserved (CC BY-NC), uploaded by Francis Joyce", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/59532412/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/59532412/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/59532412/medium.jpeg"} | 0 | 2 | 713 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Monkeyface_prickleback | Actinopterygii | Monkey-faced Prickleback | ||||||||||||||
63685 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303736, 63687, 63688, 63685] | 1 | Hyperprosopon argenteum | 63688 | 48460/1/2/355675/47178/1303736/63687/63688 | 0 | {"id": 151093733, "license_code": "cc-by-nc", "attribution": "(c) prickly_sculpin, some rights reserved (CC BY-NC), uploaded by prickly_sculpin", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/151093733/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/151093733/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/151093733/medium.jpg"} | 0 | 3 | 280 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Hyperprosopon_argenteum | Actinopterygii | Walleye Surfperch | ||||||||||||||
63770 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 49235, 1416129, 51911, 1416134, 51912, 63770] | 1 | Engraulis mordax | 51912 | 48460/1/2/355675/47178/49235/1416129/51911/1416134/51912 | 0 | {"id": 19101, "license_code": "cc-by-nc-sa", "attribution": "(c) Beth Hoffman, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19101/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19101/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/19101/medium.jpg"} | 0 | 5 | 761 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Californian_anchovy | Actinopterygii | Northern Anchovy | ||||||||||||||
64446 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303568, 47285, 788495, 47762, 64446] | 1 | Sebastes rastrelliger | 47762 | 48460/1/2/355675/47178/47233/1303568/47285/788495/47762 | 0 | {"id": 113936394, "license_code": "cc-by-nc", "attribution": "(c) prickly_sculpin, some rights reserved (CC BY-NC), uploaded by prickly_sculpin", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/113936394/square.jpg", "original_dimensions": {"height": 1229, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/113936394/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/113936394/medium.jpg"} | 0 | 2 | 335 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Sebastes_rastrelliger | Actinopterygii | Grass Rockfish | ||||||||||||||
64449 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303568, 47285, 788495, 47762, 64449] | 1 | Sebastes chrysomelas | 47762 | 48460/1/2/355675/47178/47233/1303568/47285/788495/47762 | 0 | {"id": 26537973, "license_code": null, "attribution": "(c) squadron633, all rights reserved", "url": "https://static.inaturalist.org/photos/26537973/square.jpg", "original_dimensions": {"height": 1337, "width": 2006}, "flags": [], "square_url": "https://static.inaturalist.org/photos/26537973/square.jpg", "medium_url": "https://static.inaturalist.org/photos/26537973/medium.jpg"} | 0 | 2 | 219 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Sebastes_chrysomelas | Actinopterygii | Black-and-Yellow Rockfish | ||||||||||||||
64471 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303568, 47285, 788495, 47762, 64471] | 1 | Sebastes mystinus | 47762 | 48460/1/2/355675/47178/47233/1303568/47285/788495/47762 | 0 | {"id": 26245, "license_code": "cc-by", "attribution": "(c) NOAA Photo Library, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/26245/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/26245/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/26245/medium.jpg"} | 0 | 3 | 448 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Blue_rockfish | Actinopterygii | Blue Rockfish | ||||||||||||||
64474 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303568, 47285, 788495, 47762, 64474] | 1 | Sebastes miniatus | 47762 | 48460/1/2/355675/47178/47233/1303568/47285/788495/47762 | 0 | {"id": 134209886, "license_code": "cc-by-nc", "attribution": "(c) canaryrockfish, some rights reserved (CC BY-NC), uploaded by canaryrockfish", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/134209886/square.jpeg", "original_dimensions": {"height": 709, "width": 1024}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/134209886/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/134209886/medium.jpeg"} | 0 | 3 | 537 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Sebastes_miniatus | Actinopterygii | Vermilion Rockfish | ||||||||||||||
67316 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303564, 61378, 788485, 67317, 67316] | 1 | Anoplarchus purpurescens | 67317 | 48460/1/2/355675/47178/47233/1303564/61378/788485/67317 | 0 | {"id": 8912488, "license_code": "cc-by-nc", "attribution": "(c) Karolle Wall, some rights reserved (CC BY-NC), uploaded by Karolle Wall", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/8912488/square.jpg", "original_dimensions": {"height": 942, "width": 1440}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/8912488/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/8912488/medium.jpg"} | 0 | 2 | 1273 | {"resolved": 0, "unresolved": 0} | Actinopterygii | High Cockscomb | |||||||||||||||
67360 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303564, 61378, 788485, 67361, 67360] | 1 | Xiphister atropurpureus | 67361 | 48460/1/2/355675/47178/47233/1303564/61378/788485/67361 | 0 | {"id": 20760, "license_code": "cc-by", "attribution": "(c) marlin harms, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20760/square.jpg", "original_dimensions": {"height": 800, "width": 1200}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20760/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20760/medium.jpg"} | 0 | 3 | 418 | {"resolved": 0, "unresolved": 0} | Actinopterygii | Black Prickleback | |||||||||||||||
67406 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303564, 62607, 1303672, 67407, 67406] | 1 | Apodichthys fucorum | 67407 | 48460/1/2/355675/47178/47233/1303564/62607/1303672/67407 | 0 | {"id": 1157041, "license_code": "cc-by", "attribution": "(c) jkirkhart35, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1157041/square.jpg", "original_dimensions": {"height": 1413, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1157041/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1157041/medium.jpg"} | 0 | 3 | 49 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Rockweed_gunnel | Actinopterygii | Rockweed gunnel | ||||||||||||||
67408 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303564, 62607, 1303672, 67407, 67408] | 1 | Apodichthys flavidus | 67407 | 48460/1/2/355675/47178/47233/1303564/62607/1303672/67407 | 0 | {"id": 20992, "license_code": "cc-by-nc-sa", "attribution": "(c) Dan Hershman, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20992/square.jpg", "original_dimensions": {"height": 1371, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20992/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20992/medium.jpg"} | 0 | 2 | 544 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Penpoint_gunnel | Actinopterygii | Penpoint Gunnel | ||||||||||||||
67409 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 67410, 67411, 788604, 67412, 67409] | 1 | Gobiesox maeandricus | 67412 | 48460/1/2/355675/47178/67410/67411/788604/67412 | 0 | {"id": 123538, "license_code": "cc-by", "attribution": "(c) Don Loarie, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/123538/square.jpg", "original_dimensions": {"height": 1356, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/123538/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/123538/medium.jpg"} | 1 | 3 | 1359 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Northern_clingfish | Actinopterygii | Northern Clingfish | ||||||||||||||
67629 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359810, 67630, 67629] | 1 | Oligocottus maculosus | 67630 | 48460/1/2/355675/47178/47233/1303567/86030/1359810/67630 | 0 | {"id": 240955373, "license_code": "cc-by-nc", "attribution": "(c) Alex Bairstow, some rights reserved (CC BY-NC), uploaded by Alex Bairstow", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/240955373/square.jpeg", "original_dimensions": {"height": 1369, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/240955373/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/240955373/medium.jpeg"} | 0 | 2 | 4581 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Tidepool_sculpin | Actinopterygii | Tidepool Sculpin | ||||||||||||||
68594 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 48454, 788594, 68595, 68594] | 1 | Hexagrammos lagocephalus | 68595 | 48460/1/2/355675/47178/47233/1303567/48454/788594/68595 | 0 | {"id": 121030022, "license_code": null, "attribution": "(c) Joe Tomoleoni, all rights reserved, uploaded by Joe Tomoleoni", "url": "https://static.inaturalist.org/photos/121030022/square.jpg", "original_dimensions": {"height": 526, "width": 802}, "flags": [], "square_url": "https://static.inaturalist.org/photos/121030022/square.jpg", "medium_url": "https://static.inaturalist.org/photos/121030022/medium.jpg"} | 0 | 2 | 114 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Rock_greenling | Actinopterygii | Rock greenling | ||||||||||||||
68596 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 48454, 788594, 68595, 68596] | 1 | Hexagrammos decagrammus | 68595 | 48460/1/2/355675/47178/47233/1303567/48454/788594/68595 | 0 | {"id": 88389194, "license_code": "cc-by-nc", "attribution": "(c) Sara Thiebaud, some rights reserved (CC BY-NC), uploaded by Sara Thiebaud", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88389194/square.jpeg", "original_dimensions": {"height": 1199, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88389194/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88389194/medium.jpeg"} | 0 | 3 | 1320 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Kelp_greenling | Actinopterygii | Kelp Greenling | ||||||||||||||
68618 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303568, 47285, 788495, 47762, 68618] | 1 | Sebastes nebulosus | 47762 | 48460/1/2/355675/47178/47233/1303568/47285/788495/47762 | 0 | {"id": 101087663, "license_code": "pd", "attribution": "\nJeanne Luce, no known copyright restrictions (public domain)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101087663/square.jpg", "original_dimensions": {"height": 1532, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101087663/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101087663/medium.jpg"} | 0 | 2 | 226 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/China_rockfish | Actinopterygii | China Rockfish | ||||||||||||||
93970 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303736, 63687, 86422, 93970] | 1 | Amphistichus koelzi | 86422 | 48460/1/2/355675/47178/1303736/63687/86422 | 0 | {"id": 4603204, "license_code": "cc-by-nc", "attribution": "(c) joe_cutler, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4603204/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4603204/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4603204/medium.jpg"} | 0 | 5 | 43 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Amphistichus_koelzi | Actinopterygii | Calico Surfperch | ||||||||||||||
94801 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 85506, 85612, 788679, 86718, 94801] | 1 | Atherinops affinis | 86718 | 48460/1/2/355675/47178/85506/85612/788679/86718 | 0 | {"id": 233981024, "license_code": null, "attribution": "(c) drainstamp, all rights reserved", "url": "https://static.inaturalist.org/photos/233981024/square.jpg", "original_dimensions": {"height": 1373, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/233981024/square.jpg", "medium_url": "https://static.inaturalist.org/photos/233981024/medium.jpg"} | 0 | 5 | 925 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Atherinops_affinis | Actinopterygii | Topsmelt Silverside | ||||||||||||||
94802 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 85506, 85612, 788679, 86719, 94802] | 1 | Atherinopsis californiensis | 86719 | 48460/1/2/355675/47178/85506/85612/788679/86719 | 0 | {"id": 21030924, "license_code": "cc-by-nc", "attribution": "(c) Christian Schwarz, some rights reserved (CC BY-NC), uploaded by Christian Schwarz", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/21030924/square.jpg", "original_dimensions": {"height": 1535, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/21030924/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/21030924/medium.jpg"} | 0 | 4 | 441 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Atherinopsis_californiensis | Actinopterygii | Jack Silverside | ||||||||||||||
97375 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47391, 85466, 788540, 87405, 97375] | 1 | Chilara taylori | 87405 | 48460/1/2/355675/47178/47391/85466/788540/87405 | 0 | {"id": 150349289, "license_code": "cc-by-sa", "attribution": "(c) Helge Weissig, some rights reserved (CC BY-SA), uploaded by Helge Weissig", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/150349289/square.jpg", "original_dimensions": {"height": 1333, "width": 2000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/150349289/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/150349289/medium.jpg"} | 0 | 5 | 77 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Chilara_taylori | Actinopterygii | Spotted Cusk-eel | ||||||||||||||
97984 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359810, 87526, 97984] | 1 | Clinocottus globiceps | 87526 | 48460/1/2/355675/47178/47233/1303567/86030/1359810/87526 | 0 | {"id": 80870527, "license_code": "cc-by-nc", "attribution": "(c) Thomas Shahan, some rights reserved (CC BY-NC), uploaded by Thomas Shahan", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/80870527/square.jpg", "original_dimensions": {"height": 1271, "width": 1920}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/80870527/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/80870527/medium.jpg"} | 0 | 4 | 503 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Clinocottus_globiceps | Actinopterygii | Mosshead Sculpin | ||||||||||||||
108561 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303727, 1303751, 48417, 53745, 108561] | 1 | Paralichthys californicus | 53745 | 48460/1/2/355675/47178/1303727/1303751/48417/53745 | 0 | {"id": 147660671, "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/147660671/square.jpg", "original_dimensions": {"height": 1080, "width": 1601}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/147660671/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/147660671/medium.jpg"} | 0 | 4 | 792 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/California_halibut | Actinopterygii | California Halibut | ||||||||||||||
117529 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359810, 86650, 117529] | 1 | Artedius lateralis | 86650 | 48460/1/2/355675/47178/47233/1303567/86030/1359810/86650 | 0 | {"id": 83907372, "license_code": null, "attribution": "(c) Kieran Cox, all rights reserved, uploaded by Kieran Cox", "url": "https://static.inaturalist.org/photos/83907372/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/83907372/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/83907372/medium.jpeg"} | 0 | 3 | 639 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Artedius_lateralis | Actinopterygii | Smoothhead Sculpin | ||||||||||||||
117531 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359814, 86656, 117531] | 1 | Ascelichthys rhodorus | 86656 | 48460/1/2/355675/47178/47233/1303567/86030/1359814/86656 | 0 | {"id": 128259014, "license_code": "cc-by-nc-nd", "attribution": "(c) Gregory C Jensen, some rights reserved (CC BY-NC-ND), uploaded by Gregory C Jensen", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/128259014/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/128259014/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/128259014/medium.jpeg"} | 0 | 2 | 214 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Ascelichthys_rhodorus | Actinopterygii | Rosylip Sculpin | ||||||||||||||
117533 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359810, 87526, 117533] | 1 | Clinocottus analis | 87526 | 48460/1/2/355675/47178/47233/1303567/86030/1359810/87526 | 0 | {"id": 113114220, "license_code": null, "attribution": "(c) Jeff Stauffer, all rights reserved, uploaded by Jeff Stauffer", "url": "https://static.inaturalist.org/photos/113114220/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/113114220/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/113114220/medium.jpeg"} | 0 | 2 | 3540 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Clinocottus_analis | Actinopterygii | Woolly Sculpin | ||||||||||||||
117534 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359810, 87526, 117534] | 1 | Clinocottus recalvus | 87526 | 48460/1/2/355675/47178/47233/1303567/86030/1359810/87526 | 0 | {"id": 12235550, "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/12235550/square.jpg", "original_dimensions": {"height": 1859, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/12235550/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/12235550/medium.jpg"} | 0 | 2 | 149 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Bald_sculpin | Actinopterygii | Bald Sculpin | ||||||||||||||
117536 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359813, 88175, 117536] | 1 | Enophrys bison | 88175 | 48460/1/2/355675/47178/47233/1303567/86030/1359813/88175 | 0 | {"id": 127281997, "license_code": "cc-by-nc", "attribution": "(c) hikeranddiver, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/127281997/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/127281997/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/127281997/medium.jpeg"} | 0 | 2 | 743 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Enophrys_bison | Actinopterygii | Buffalo Sculpin | ||||||||||||||
117538 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359810, 67630, 117538] | 1 | Oligocottus snyderi | 67630 | 48460/1/2/355675/47178/47233/1303567/86030/1359810/67630 | 0 | {"id": 176553827, "license_code": "cc-by-nc", "attribution": "(c) Christian Schwarz, some rights reserved (CC BY-NC), uploaded by Christian Schwarz", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/176553827/square.jpg", "original_dimensions": {"height": 1322, "width": 1763}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/176553827/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/176553827/medium.jpg"} | 0 | 3 | 645 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Fluffy_sculpin | Actinopterygii | Fluffy Sculpin | ||||||||||||||
117539 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 49032, 157721, 117539] | 1 | Liparis florae | 157721 | 48460/1/2/355675/47178/47233/1303567/49032/157721 | 0 | {"id": 147630003, "license_code": null, "attribution": "(c) Sheldon Schultz, all rights reserved, uploaded by Sheldon Schultz", "url": "https://static.inaturalist.org/photos/147630003/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/147630003/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/147630003/medium.jpeg"} | 0 | 2 | 325 | {"resolved": 0, "unresolved": 0} | Actinopterygii | Tidepool Snailfish | |||||||||||||||
117549 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303737, 85698, 88489, 117549] | 1 | Gibbonsia metzi | 88489 | 48460/1/2/355675/47178/1303737/85698/88489 | 0 | {"id": 97939269, "license_code": "cc-by", "attribution": "(c) Cricket Raspet, some rights reserved (CC BY), uploaded by Cricket Raspet", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97939269/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97939269/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97939269/medium.jpg"} | 0 | 4 | 304 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Gibbonsia_metzi | Actinopterygii | Striped Kelpfish | ||||||||||||||
117550 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303737, 85698, 88489, 117550] | 1 | Gibbonsia montereyensis | 88489 | 48460/1/2/355675/47178/1303737/85698/88489 | 0 | {"id": 38654970, "license_code": "cc-by-nc", "attribution": "(c) Stefanie, some rights reserved (CC BY-NC), uploaded by Stefanie", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/38654970/square.jpg", "original_dimensions": {"height": 960, "width": 1359}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/38654970/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/38654970/medium.jpg"} | 0 | 4 | 118 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Gibbonsia_montereyensis | Actinopterygii | Crevice Kelpfish | ||||||||||||||
117551 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303736, 63687, 86422, 117551] | 1 | Amphistichus argenteus | 86422 | 48460/1/2/355675/47178/1303736/63687/86422 | 0 | {"id": 120142001, "license_code": null, "attribution": "(c) Jeff Stauffer, all rights reserved, uploaded by Jeff Stauffer", "url": "https://static.inaturalist.org/photos/120142001/square.jpeg", "original_dimensions": {"height": 1420, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/120142001/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/120142001/medium.jpeg"} | 0 | 2 | 299 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Barred_surfperch | Actinopterygii | Barred Surfperch | ||||||||||||||
117555 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303736, 63687, 88143, 117555] | 1 | Embiotoca lateralis | 88143 | 48460/1/2/355675/47178/1303736/63687/88143 | 0 | {"id": 114604286, "license_code": "cc-by-nc", "attribution": "(c) KJ, some rights reserved (CC BY-NC), uploaded by KJ", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/114604286/square.jpg", "original_dimensions": {"height": 768, "width": 1024}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/114604286/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/114604286/medium.jpg"} | 0 | 3 | 758 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Embiotoca_lateralis | Actinopterygii | Striped surfperch | ||||||||||||||
117557 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303736, 63687, 63688, 117557] | 1 | Hyperprosopon ellipticum | 63688 | 48460/1/2/355675/47178/1303736/63687/63688 | 0 | {"id": 159140923, "license_code": "cc-by-nc", "attribution": "(c) prickly_sculpin, some rights reserved (CC BY-NC), uploaded by prickly_sculpin", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/159140923/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/159140923/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/159140923/medium.jpg"} | 0 | 3 | 98 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Silver_surfperch | Actinopterygii | Silver surfperch | ||||||||||||||
117560 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303736, 63687, 89934, 117560] | 1 | Micrometrus minimus | 89934 | 48460/1/2/355675/47178/1303736/63687/89934 | 0 | {"id": 146290976, "license_code": "cc-by-nc", "attribution": "(c) Sean Ono, some rights reserved (CC BY-NC), uploaded by Sean Ono", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/146290976/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/146290976/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/146290976/medium.jpg"} | 0 | 2 | 223 | {"resolved": 0, "unresolved": 0} | Actinopterygii | Dwarf Surfperch | |||||||||||||||
187316 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1543570, 49216, 1303592, 49609, 607661, 53912, 187316] | 1 | Cyprinus rubrofuscus | 53912 | 48460/1/2/355675/47178/1543570/49216/1303592/49609/607661/53912 | 0 | {"id": 88841047, "license_code": "cc-by-nc", "attribution": "(c) sbh2006, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88841047/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88841047/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/88841047/medium.jpeg"} | 1 | 3 | 12902 | {"resolved": 1, "unresolved": 0} | 30310 | http://en.wikipedia.org/wiki/Cyprinus_rubrofuscus | Actinopterygii | Amur Carp | |||||||||||||
201784 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1519465, 85574, 86396, 201784] | 1 | Ammodytes personatus | 86396 | 48460/1/2/355675/47178/47233/1519465/85574/86396 | 0 | {"id": 341996661, "license_code": "cc-by-nc", "attribution": "(c) kelpadelpian, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/341996661/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/341996661/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/341996661/medium.jpg"} | 1 | 1 | 878 | {"resolved": 0, "unresolved": 0} | Actinopterygii | Pacific Sand Lance | |||||||||||||||
222155 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303739, 1303745, 51416, 89063, 222155] | 1 | Icichthys lockingtoni | 89063 | 48460/1/2/355675/47178/1303739/1303745/51416/89063 | 0 | {"id": 66946233, "license_code": "cc-by-nc", "attribution": "(c) linddealy, some rights reserved (CC BY-NC), uploaded by linddealy", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/66946233/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/66946233/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/66946233/medium.jpeg"} | 0 | 3 | 4 | {"resolved": 0, "unresolved": 0} | Actinopterygii | Medusafish | |||||||||||||||
228393 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303727, 1303751, 47525, 1303675, 91175, 228393] | 1 | Pleuronichthys coenosus | 91175 | 48460/1/2/355675/47178/1303727/1303751/47525/1303675/91175 | 0 | {"id": 57807750, "license_code": "cc-by-nc", "attribution": "(c) Tom Turner, some rights reserved (CC BY-NC), uploaded by Tom Turner", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/57807750/square.jpg", "original_dimensions": {"height": 1578, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/57807750/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/57807750/medium.jpg"} | 0 | 3 | 171 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/C-O_sole | Actinopterygii | C-O Sole | ||||||||||||||
230183 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 67410, 67411, 788604, 91779, 230183] | 1 | Rimicola muscarum | 91779 | 48460/1/2/355675/47178/67410/67411/788604/91779 | 0 | {"id": 6066517, "license_code": "cc-by-nc", "attribution": "(c) Robin Gwen Agarwal, some rights reserved (CC BY-NC), uploaded by Robin Gwen Agarwal", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6066517/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6066517/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/6066517/medium.jpeg"} | 0 | 3 | 36 | {"resolved": 0, "unresolved": 0} | Actinopterygii | Kelp Clingfish | |||||||||||||||
230744 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303564, 86064, 91976, 230744] | 1 | Scytalina cerdale | 91976 | 48460/1/2/355675/47178/47233/1303564/86064/91976 | 0 | {"id": 101301728, "license_code": "cc-by-nc", "attribution": "(c) Michael Spencer, some rights reserved (CC BY-NC), uploaded by Michael Spencer", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101301728/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101301728/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/101301728/medium.jpg"} | 0 | 2 | 4 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Graveldiver | Actinopterygii | Graveldiver | ||||||||||||||
317255 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47233, 1303567, 86030, 1359810, 67630, 317255] | 1 | Oligocottus rubellio | 67630 | 48460/1/2/355675/47178/47233/1303567/86030/1359810/67630 | 0 | {"id": 177629970, "license_code": "cc-by-nc", "attribution": "(c) ravendavid, some rights reserved (CC BY-NC), uploaded by ravendavid", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177629970/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177629970/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177629970/medium.jpeg"} | 0 | 2 | 187 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Rosy_sculpin | Actinopterygii | Rosy Sculpin | ||||||||||||||
554753 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 47177, 1303584, 49607, 49604, 554753] | 1 | Mola tecta | 49604 | 48460/1/2/355675/47178/47177/1303584/49607/49604 | 0 | {"id": 48516637, "license_code": null, "attribution": "(c) Pat Webster @underwaterpat, all rights reserved, uploaded by Pat Webster @underwaterpat", "url": "https://static.inaturalist.org/photos/48516637/square.jpg", "original_dimensions": {"height": 1571, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/48516637/square.jpg", "medium_url": "https://static.inaturalist.org/photos/48516637/medium.jpg"} | 0 | 1 | 57 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Mola_tecta | Actinopterygii | Hoodwinker Mola | ||||||||||||||
1316647 | species | 10 | 47178 | [48460, 1, 2, 355675, 47178, 1303736, 63687, 1312978, 1316647] | 1 | Hypocritichthys analis | 1312978 | 48460/1/2/355675/47178/1303736/63687/1312978 | 0 | {"id": 168826799, "license_code": "cc-by-nc", "attribution": "(c) prickly_sculpin, some rights reserved (CC BY-NC), uploaded by prickly_sculpin", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168826799/square.jpg", "original_dimensions": {"height": 1347, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168826799/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168826799/medium.jpg"} | 1 | 0 | 28 | {"resolved": 0, "unresolved": 0} | Actinopterygii | Spotfin surfperch |
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);