taxons
48 rows where taxon_schemes_count = 7
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_changes_count, flag_counts, iconic_taxon_name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 29020 | {"resolved": 0, "unresolved": 0} | 146 | http://en.wikipedia.org/wiki/Southern_alligator_lizard | Reptilia | Southern Alligator Lizard | subspecies | ||||||||||||
41478 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 152870, 925158, 152871, 424321, 41476, 41477, 41478] | 1 | Eschrichtius robustus | 41477 | 48460/1/2/355675/40151/848317/848320/848324/152870/925158/152871/424321/41476/41477 | 0 | {"id": 244724464, "license_code": "cc-by-nc", "attribution": "(c) Andrea Carpio, some rights reserved (CC BY-NC), uploaded by Andrea Carpio", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/244724464/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/244724464/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/244724464/medium.jpg"} | 0 | 7 | 3370 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Gray_whale | Mammalia | Grey Whale | ||||||||||||||
41728 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 41573, 372843, 41687, 41727, 41728] | 1 | Mirounga angustirostris | 41727 | 48460/1/2/355675/40151/848317/848320/848324/41573/372843/41687/41727 | 0 | {"id": 924, "license_code": "cc-by-nc-nd", "attribution": "(c) Yathin, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/924/square.jpg", "original_dimensions": {"height": 664, "width": 1000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/924/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/924/medium.jpg"} | 0 | 7 | 7512 | {"resolved": 1, "unresolved": 0} | 13060 | http://en.wikipedia.org/wiki/Northern_elephant_seal | Mammalia | Northern Elephant Seal | |||||||||||||
41740 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 41573, 372843, 41736, 41737, 41740] | 1 | Zalophus californianus | 41737 | 48460/1/2/355675/40151/848317/848320/848324/41573/372843/41736/41737 | 0 | {"id": 11888923, "license_code": null, "attribution": "(c) Jennifer Digdigan, all rights reserved, uploaded by Jennifer Digdigan", "url": "https://static.inaturalist.org/photos/11888923/square.png", "original_dimensions": {"height": 960, "width": 1280}, "flags": [], "square_url": "https://static.inaturalist.org/photos/11888923/square.png", "medium_url": "https://static.inaturalist.org/photos/11888923/medium.png"} | 0 | 7 | 24361 | {"resolved": 0, "unresolved": 0} | 13194 | http://en.wikipedia.org/wiki/California_sea_lion | Mammalia | California Sea Lion | |||||||||||||
44326 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848323, 43698, 870778, 488924, 55986, 179534, 846301, 44259, 1431446, 44326] | 1 | Microtus californicus | 1431446 | 48460/1/2/355675/40151/848317/848320/848323/43698/870778/488924/55986/179534/846301/44259/1431446 | 0 | {"id": 456939, "license_code": "cc-by-nc-nd", "attribution": "(c) Kim Cabrera, some rights reserved (CC BY-NC-ND), uploaded by Kim Cabrera", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/456939/square.jpg", "original_dimensions": {"height": 588, "width": 800}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/456939/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/456939/medium.jpg"} | 0 | 7 | 1746 | {"resolved": 0, "unresolved": 0} | 88 | http://en.wikipedia.org/wiki/California_vole | Mammalia | California Vole | |||||||||||||
46023 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848323, 43698, 129411, 45933, 332614, 339575, 45994, 1431498, 46023] | 1 | Sciurus griseus | 1431498 | 48460/1/2/355675/40151/848317/848320/848323/43698/129411/45933/332614/339575/45994/1431498 | 0 | {"id": 266432875, "license_code": "cc-by-nc-nd", "attribution": "(c) Kim Cabrera, some rights reserved (CC BY-NC-ND), uploaded by Kim Cabrera", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/266432875/square.jpg", "original_dimensions": {"height": 716, "width": 750}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/266432875/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/266432875/medium.jpg"} | 0 | 7 | 12985 | {"resolved": 0, "unresolved": 0} | 28 | http://en.wikipedia.org/wiki/Western_gray_squirrel | Mammalia | Western Gray Squirrel | |||||||||||||
46994 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 533971, 1474222, 46927, 846223, 846384, 46993, 46994] | 1 | Scapanus latimanus | 46993 | 48460/1/2/355675/40151/848317/848320/848324/533971/1474222/46927/846223/846384/46993 | 0 | {"id": 31968, "license_code": "cc-by", "attribution": "(c) Bob Dodge, some rights reserved (CC BY), uploaded by Bob Dodge", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/31968/square.JPG", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/31968/square.JPG", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/31968/medium.JPG"} | 0 | 7 | 1545 | {"resolved": 0, "unresolved": 0} | 75 | http://en.wikipedia.org/wiki/Broad-footed_mole | Mammalia | Broad-footed Mole | |||||||||||||
47372 | species | 10 | 47126 | [48460, 47126, 211194, 136329, 47375, 47374, 1150916, 47373, 47372] | 1 | Sequoia sempervirens | 47373 | 48460/47126/211194/136329/47375/47374/1150916/47373 | 0 | {"id": 61295436, "license_code": null, "attribution": "(c) kmvogelsang, all rights reserved, uploaded by kmvogelsang", "url": "https://static.inaturalist.org/photos/61295436/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/61295436/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/61295436/medium.jpeg"} | 0 | 7 | 26775 | {"resolved": 2, "unresolved": 0} | 3948 | http://en.wikipedia.org/wiki/Sequoia_sempervirens | Plantae | coast redwood | |||||||||||||
47687 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47690, 47689, 47688, 1438094, 47687] | 1 | Erodium cicutarium | 1438094 | 48460/47126/211194/47125/47124/47690/47689/47688/1438094 | 0 | {"id": 3044348, "license_code": "cc-by-nc", "attribution": "(c) Marilyn Smith, some rights reserved (CC BY-NC), uploaded by Marilyn Smith", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3044348/square.jpg", "original_dimensions": {"height": 2048, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3044348/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3044348/medium.jpg"} | 7 | 7 | 77067 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Erodium_cicutarium | Plantae | Redstem Stork's-bill | ||||||||||||||
48225 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48232, 47332, 889631, 1453810, 48226, 48225] | 1 | Eschscholzia californica | 48226 | 48460/47126/211194/47125/47124/48232/47332/889631/1453810/48226 | 0 | {"id": 1233073, "license_code": "cc-by", "attribution": "(c) John Barkla, some rights reserved (CC BY), uploaded by John Barkla", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1233073/square.", "original_dimensions": {"height": 1364, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1233073/square.", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1233073/medium."} | 0 | 7 | 68097 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Eschscholzia_californica | Plantae | California poppy | 48460,47126,211194,47125,47124,48232,47332,889631,1453810,48226,48225 | 0 | 48225 | 0 | 0 | 1 | 2008-08-28T22:25:52+00:00 | 0 | 68097 | |||||
48685 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 47162, 48694, 48686, 48685] | 1 | Typha latifolia | 48686 | 48460/47126/211194/47125/47163/47162/48694/48686 | 0 | {"id": 4280840, "license_code": "cc-by-nc", "attribution": "(c) cgbb2004, some rights reserved (CC BY-NC), uploaded by cgbb2004", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4280840/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4280840/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4280840/medium.jpeg"} | 0 | 7 | 46444 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Typha_latifolia | Plantae | broadleaf cattail | ||||||||||||||
48934 | species | 10 | 47126 | [48460, 47126, 211194, 136329, 47375, 47562, 1456301, 47561, 790732, 790770, 48934] | 1 | Pinus contorta | 790770 | 48460/47126/211194/136329/47375/47562/1456301/47561/790732/790770 | 0 | {"id": 45880976, "license_code": "cc-by", "attribution": "(c) Alison Northup, some rights reserved (CC BY), uploaded by Alison Northup", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/45880976/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/45880976/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/45880976/medium.jpeg"} | 0 | 7 | 22560 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Pinus_contorta | Plantae | lodgepole pine | ||||||||||||||
52614 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 48073, 52615, 52616, 52614] | 1 | Zostera marina | 52616 | 48460/47126/211194/47125/47163/48073/52615/52616 | 0 | {"id": 179257999, "license_code": "cc-by-nc", "attribution": "(c) Xavier Rufray, some rights reserved (CC BY-NC), uploaded by Xavier Rufray", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/179257999/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/179257999/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/179257999/medium.jpg"} | 1 | 7 | 5540 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Zostera_marina | Plantae | Eelgrass | ||||||||||||||
52764 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48151, 48623, 520502, 918917, 919181, 52765, 52764] | 1 | Prunella vulgaris | 52765 | 48460/47126/211194/47125/47124/48151/48623/520502/918917/919181/52765 | 0 | {"id": 65409387, "license_code": "cc-by", "attribution": "(c) fitomorfolog_t, some rights reserved (CC BY), uploaded by fitomorfolog_t", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65409387/square.jpg", "original_dimensions": {"height": 479, "width": 639}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65409387/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65409387/medium.jpg"} | 1 | 7 | 108874 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Prunella_vulgaris | Plantae | common selfheal | ||||||||||||||
52793 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 47162, 47434, 514989, 552962, 1138139, 52794, 52793] | 1 | Holcus lanatus | 52794 | 48460/47126/211194/47125/47163/47162/47434/514989/552962/1138139/52794 | 0 | {"id": 157538875, "license_code": "cc-by-nc", "attribution": "(c) Douglas Goldman, some rights reserved (CC BY-NC), uploaded by Douglas Goldman", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/157538875/square.jpg", "original_dimensions": {"height": 2048, "width": 1371}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/157538875/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/157538875/medium.jpg"} | 0 | 7 | 20877 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Holcus_lanatus | Plantae | Yorkshire fog | ||||||||||||||
52821 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 632790, 373844, 900988, 52818, 1105043, 52821] | 1 | Achillea millefolium | 1105043 | 48460/47126/211194/47125/47124/47605/47604/632790/373844/900988/52818/1105043 | 0 | {"id": 4902, "license_code": "cc-by-nc-nd", "attribution": "(c) Steve Guttman, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4902/square.jpg", "original_dimensions": {"height": 1431, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4902/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4902/medium.jpg"} | 3 | 7 | 196022 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Achillea_millefolium | Plantae | common yarrow | ||||||||||||||
53050 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47791, 47790, 52972, 53050] | 1 | Epilobium ciliatum | 52972 | 48460/47126/211194/47125/47124/47791/47790/52972 | 0 | {"id": 20242455, "license_code": null, "attribution": "(c) K D, all rights reserved, uploaded by K D", "url": "https://static.inaturalist.org/photos/20242455/square.jpeg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://static.inaturalist.org/photos/20242455/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/20242455/medium.jpeg"} | 1 | 7 | 20393 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Epilobium_ciliatum | Plantae | fringed willowherb | ||||||||||||||
53052 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48700, 48699, 790553, 790576, 53053, 53052] | 1 | Foeniculum vulgare | 53053 | 48460/47126/211194/47125/47124/48700/48699/790553/790576/53053 | 0 | {"id": 50868492, "license_code": null, "attribution": "(c) Allie Schiltmeyer, all rights reserved, uploaded by Allie Schiltmeyer", "url": "https://static.inaturalist.org/photos/50868492/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://static.inaturalist.org/photos/50868492/square.jpg", "medium_url": "https://static.inaturalist.org/photos/50868492/medium.jpg"} | 2 | 7 | 33119 | {"resolved": 2, "unresolved": 1} | http://en.wikipedia.org/wiki/Fennel | Plantae | fennel | ||||||||||||||
53103 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 447425, 359450, 558819, 51900, 53103] | 1 | Hypochaeris glabra | 51900 | 48460/47126/211194/47125/47124/47605/47604/447425/359450/558819/51900 | 0 | {"id": 1003756, "license_code": "cc-by-sa", "attribution": "(c) user:Curtis Clark, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1003756/square.jpg", "original_dimensions": {"height": 1336, "width": 1196}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1003756/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1003756/medium.jpg"} | 1 | 7 | 6427 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Hypochaeris_glabra | Plantae | Smooth Cat's Ear | ||||||||||||||
53178 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48151, 50638, 840983, 50636, 1045687, 1045692, 53178] | 1 | Plantago lanceolata | 1045692 | 48460/47126/211194/47125/47124/48151/50638/840983/50636/1045687/1045692 | 0 | {"id": 66892509, "license_code": "cc-by", "attribution": "(c) Robert Flogaus-Faust, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/66892509/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/66892509/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/66892509/medium.jpg"} | 2 | 7 | 107858 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Plantago_lanceolata | Plantae | ribwort plantain | ||||||||||||||
53195 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 48382, 922206, 922242, 53196, 53195] | 1 | Rumex acetosella | 53196 | 48460/47126/211194/47125/47124/47366/48382/922206/922242/53196 | 0 | {"id": 177768765, "license_code": "cc-by-sa", "attribution": "(c) Agnieszka Kwiecień, Nova, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177768765/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177768765/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/177768765/medium.jpg"} | 1 | 7 | 35513 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Rumex_acetosella | Plantae | Sheep's sorrel | ||||||||||||||
53212 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 48567, 791473, 791475, 52195, 1395930, 1395969, 53212] | 1 | Silene gallica | 1395969 | 48460/47126/211194/47125/47124/47366/48567/791473/791475/52195/1395930/1395969 | 0 | {"id": 25136155, "license_code": null, "attribution": "(c) mjcorreia, all rights reserved, uploaded by mjcorreia", "url": "https://static.inaturalist.org/photos/25136155/square.jpeg", "original_dimensions": {"height": 533, "width": 800}, "flags": [], "square_url": "https://static.inaturalist.org/photos/25136155/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/25136155/medium.jpeg"} | 1 | 7 | 12554 | {"resolved": 0, "unresolved": 0} | https://en.wikipedia.org/wiki/Silene_gallica | Plantae | Small-flowered Catchfly | ||||||||||||||
53269 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 447425, 359450, 632703, 53270, 53269] | 1 | Sonchus asper | 53270 | 48460/47126/211194/47125/47124/47605/47604/447425/359450/632703/53270 | 0 | {"id": 261760280, "license_code": "cc-by", "attribution": "(c) Michelle, some rights reserved (CC BY), uploaded by Michelle", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/261760280/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/261760280/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/261760280/medium.jpeg"} | 1 | 7 | 45697 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Sonchus_asper | Plantae | prickly sowthistle | ||||||||||||||
53294 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 447425, 359450, 632703, 53270, 53294] | 1 | Sonchus oleraceus | 53270 | 48460/47126/211194/47125/47124/47605/47604/447425/359450/632703/53270 | 0 | {"id": 28460419, "license_code": null, "attribution": "(c) ritafoo, all rights reserved, uploaded by ritafoo", "url": "https://static.inaturalist.org/photos/28460419/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/28460419/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/28460419/medium.jpeg"} | 0 | 7 | 60270 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/Sonchus_oleraceus | Plantae | Common Sow-thistle | ||||||||||||||
53298 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 48567, 791419, 49389, 1087592, 53298] | 1 | Stellaria media | 1087592 | 48460/47126/211194/47125/47124/47366/48567/791419/49389/1087592 | 0 | {"id": 183922286, "license_code": "cc-by-nc", "attribution": "(c) Jim Walker, some rights reserved (CC BY-NC), uploaded by Jim Walker", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/183922286/square.jpeg", "original_dimensions": {"height": 1030, "width": 1442}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/183922286/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/183922286/medium.jpeg"} | 3 | 7 | 65326 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Stellaria_media | Plantae | common chickweed | ||||||||||||||
54329 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 54330, 54331, 54329] | 1 | Tropaeolum majus | 54331 | 48460/47126/211194/47125/47124/71275/54330/54331 | 0 | {"id": 30477591, "license_code": null, "attribution": "(c) Andrew Laleian, all rights reserved, uploaded by Andrew Laleian", "url": "https://static.inaturalist.org/photos/30477591/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/30477591/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/30477591/medium.jpeg"} | 0 | 7 | 30057 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Tropaeolum_majus | Plantae | garden nasturtium | 48460,47126,211194,47125,47124,71275,54330,54331,54329 | 0 | 54329 | 0 | 1 | 0 | 2009-11-28T16:30:32+00:00 | 0 | 30057 | |||||
54605 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48151, 48623, 918903, 918909, 54604, 54605] | 1 | Marrubium vulgare | 54604 | 48460/47126/211194/47125/47124/48151/48623/918903/918909/54604 | 0 | {"id": 665395, "license_code": "cc-by-nc", "attribution": "(c) Richard Reynolds, some rights reserved (CC BY-NC), uploaded by Richard Reynolds", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/665395/square.jpg", "original_dimensions": {"height": 1800, "width": 1200}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/665395/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/665395/medium.jpg"} | 0 | 7 | 22318 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Marrubium_vulgare | Plantae | White Horehound | ||||||||||||||
55411 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 47204, 1473853, 1473856, 574731, 55412, 55411] | 1 | Raphanus raphanistrum | 55412 | 48460/47126/211194/47125/47124/71275/47204/1473853/1473856/574731/55412 | 0 | {"id": 157500643, "license_code": null, "attribution": "(c) Konstantinos Kalaentzis, all rights reserved, uploaded by Konstantinos Kalaentzis", "url": "https://static.inaturalist.org/photos/157500643/square.jpg", "original_dimensions": {"height": 1366, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/157500643/square.jpg", "medium_url": "https://static.inaturalist.org/photos/157500643/medium.jpg"} | 0 | 7 | 48199 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Raphanus_raphanistrum | Plantae | Jointed Charlock | ||||||||||||||
56006 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 48073, 48536, 467650, 1356029, 56009, 56006] | 1 | Zantedeschia aethiopica | 56009 | 48460/47126/211194/47125/47163/48073/48536/467650/1356029/56009 | 0 | {"id": 10183, "license_code": "cc-by-nc-sa", "attribution": "(c) flipsockgrrl, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10183/square.jpg", "original_dimensions": {"height": 750, "width": 1000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10183/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/10183/medium.jpg"} | 1 | 7 | 23706 | {"resolved": 8, "unresolved": 0} | http://en.wikipedia.org/wiki/Zantedeschia_aethiopica | Plantae | calla lily | ||||||||||||||
56992 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 47204, 1473853, 1473868, 902482, 56993, 56992] | 1 | Lobularia maritima | 56993 | 48460/47126/211194/47125/47124/71275/47204/1473853/1473868/902482/56993 | 0 | {"id": 178745376, "license_code": "cc-by-nc", "attribution": "(c) benjaminshmenjamin, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/178745376/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/178745376/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/178745376/medium.jpg"} | 4 | 7 | 23555 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Lobularia_maritima | Plantae | sweet alyssum | ||||||||||||||
57036 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 51820, 51821, 779191, 1244656, 1244731, 51822, 785083, 975169, 57036] | 1 | Euphorbia peplus | 975169 | 48460/47126/211194/47125/47124/51820/51821/779191/1244656/1244731/51822/785083/975169 | 0 | {"id": 51646215, "license_code": "cc-by-nc", "attribution": "(c) Sergey Mayorov, some rights reserved (CC BY-NC), uploaded by Sergey Mayorov", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/51646215/square.jpg", "original_dimensions": {"height": 836, "width": 1000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/51646215/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/51646215/medium.jpg"} | 0 | 7 | 22297 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Euphorbia_peplus | Plantae | Petty Spurge | ||||||||||||||
57056 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47123, 47122, 507502, 512504, 53152, 1092877, 1092918, 57056] | 1 | Medicago lupulina | 1092918 | 48460/47126/211194/47125/47124/47123/47122/507502/512504/53152/1092877/1092918 | 0 | {"id": 62641151, "license_code": "cc-by", "attribution": "(c) Sophia K, some rights reserved (CC BY), uploaded by Sophia K", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/62641151/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/62641151/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/62641151/medium.jpg"} | 0 | 7 | 51958 | {"resolved": 0, "unresolved": 0} | 16251 | https://en.wikipedia.org/wiki/Medicago_lupulina | Plantae | Black Medick | |||||||||||||
57065 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47123, 47122, 507502, 512504, 57067, 57065] | 1 | Melilotus indicus | 57067 | 48460/47126/211194/47125/47124/47123/47122/507502/512504/57067 | 0 | {"id": 33347414, "license_code": "cc0", "attribution": "no rights reserved, uploaded by 葉子", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/33347414/square.jpeg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/33347414/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/33347414/medium.jpeg"} | 1 | 7 | 15870 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Melilotus_indicus | Plantae | small melilot | ||||||||||||||
57162 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 47162, 47434, 514989, 552962, 1138133, 57160, 57162] | 1 | Briza minor | 57160 | 48460/47126/211194/47125/47163/47162/47434/514989/552962/1138133/57160 | 0 | {"id": 34264, "license_code": "cc-by", "attribution": "(c) Ken-ichi Ueda, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/34264/square.jpg", "original_dimensions": {"height": 2048, "width": 1365}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/34264/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/34264/medium.jpg"} | 0 | 7 | 5335 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Briza_minor | Plantae | Little quaking-grass | ||||||||||||||
58876 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 48567, 791433, 58875, 58876] | 1 | Polycarpon tetraphyllum | 58875 | 48460/47126/211194/47125/47124/47366/48567/791433/58875 | 0 | {"id": 39743410, "license_code": "cc-by-nc", "attribution": "(c) setaearmor, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/39743410/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/39743410/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/39743410/medium.jpg"} | 0 | 7 | 7113 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Polycarpon_tetraphyllum | Plantae | fourleaf manyseed | ||||||||||||||
58961 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48151, 50638, 840983, 50636, 1045683, 1421895, 58961] | 1 | Plantago major | 1421895 | 48460/47126/211194/47125/47124/48151/50638/840983/50636/1045683/1421895 | 0 | {"id": 85519437, "license_code": "cc-by", "attribution": "(c) lemonsnapp, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/85519437/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/85519437/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/85519437/medium.jpg"} | 1 | 7 | 73434 | {"resolved": 4, "unresolved": 0} | http://en.wikipedia.org/wiki/Plantago_major | Plantae | greater plantain | ||||||||||||||
75475 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 47162, 47434, 514989, 552962, 1138131, 71973, 75475] | 1 | Anthoxanthum odoratum | 71973 | 48460/47126/211194/47125/47163/47162/47434/514989/552962/1138131/71973 | 0 | {"id": 20694647, "license_code": "cc-by", "attribution": "(c) David McCorquodale, some rights reserved (CC BY), uploaded by David McCorquodale", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20694647/square.jpg", "original_dimensions": {"height": 2048, "width": 1365}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20694647/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/20694647/medium.jpg"} | 0 | 7 | 19924 | {"resolved": 2, "unresolved": 0} | 21067 | http://en.wikipedia.org/wiki/Anthoxanthum_odoratum | Plantae | sweet vernal grass | |||||||||||||
78174 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 47204, 1473853, 1473859, 902567, 54332, 78174] | 1 | Nasturtium officinale | 54332 | 48460/47126/211194/47125/47124/71275/47204/1473853/1473859/902567/54332 | 0 | {"id": 203236672, "license_code": "cc-by-nc", "attribution": "(c) Andrew Tree, some rights reserved (CC BY-NC), uploaded by Andrew Tree", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/203236672/square.jpeg", "original_dimensions": {"height": 2048, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/203236672/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/203236672/medium.jpeg"} | 1 | 7 | 20611 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Watercress | Plantae | watercress | ||||||||||||||
144455 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67566, 4929, 597395, 4950, 144455] | 1 | Ardea alba | 4950 | 48460/1/2/355675/3/67566/4929/597395/4950 | 0 | {"id": 56653891, "license_code": "cc-by-nc", "attribution": "(c) daverowe, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/56653891/square.jpg", "original_dimensions": {"height": 667, "width": 1000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/56653891/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/56653891/medium.jpg"} | 1 | 7 | 238632 | {"resolved": 7, "unresolved": 0} | http://en.wikipedia.org/wiki/Great_egret | Aves | Great Egret | subspecies | |||||||||||||
144479 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 4, 154, 979864, 144479] | 1 | Gallinula galeata | 979864 | 48460/1/2/355675/3/4/154/979864 | 0 | {"id": 30905992, "license_code": "cc-by-nc", "attribution": "(c) uzun, some rights reserved (CC BY-NC), uploaded by uzun", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30905992/square.jpg", "original_dimensions": {"height": 1636, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30905992/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30905992/medium.jpg"} | 1 | 7 | 45388 | {"resolved": 2, "unresolved": 0} | 16207 | http://en.wikipedia.org/wiki/Common_gallinule | Aves | Common Gallinule | subspecies | ||||||||||||
144491 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 3835, 3874, 144491] | 1 | Tringa semipalmata | 3874 | 48460/1/2/355675/3/67561/3835/3874 | 0 | {"id": 168931162, "license_code": "cc-by-nc", "attribution": "(c) Bridget Spencer, some rights reserved (CC BY-NC), uploaded by Bridget Spencer", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168931162/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168931162/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168931162/medium.jpeg"} | 1 | 7 | 49311 | {"resolved": 0, "unresolved": 0} | https://en.wikipedia.org/wiki/Willet | Aves | Willet | subspecies | |||||||||||||
144542 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4342, 373567, 144327, 144542] | 1 | Thalasseus elegans | 144327 | 48460/1/2/355675/3/67561/4342/373567/144327 | 0 | {"id": 184077990, "license_code": "cc-by-nc", "attribution": "(c) Ad Konings, some rights reserved (CC BY-NC), uploaded by Ad Konings", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/184077990/square.jpg", "original_dimensions": {"height": 1062, "width": 1759}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/184077990/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/184077990/medium.jpg"} | 1 | 7 | 5531 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Elegant_tern | Aves | Elegant Tern | subspecies | {"id": 45552, "place_id": null, "source_id": 18766, "user_id": null, "authority": "IUCN Red List", "status": "nt", "status_name": "near threatened", "geoprivacy": "open", "iucn": 20} | ||||||||||||
145245 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 71349, 10246, 145245] | 1 | Setophaga coronata | 10246 | 48460/1/2/355675/3/7251/71349/10246 | 0 | {"id": 128439522, "license_code": "cc-by-nc-nd", "attribution": "(c) Zane Shantz, some rights reserved (CC BY-NC-ND), uploaded by Zane Shantz", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/128439522/square.jpg", "original_dimensions": {"height": 1368, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/128439522/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/128439522/medium.jpg"} | 1 | 7 | 155717 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Yellow-rumped_warbler | Aves | Yellow-rumped Warbler | subspecies | |||||||||||||
145255 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 71349, 10246, 145255] | 1 | Setophaga townsendi | 10246 | 48460/1/2/355675/3/7251/71349/10246 | 0 | {"id": 171915136, "license_code": "cc-by-nc", "attribution": "(c) macrhybopsis, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/171915136/square.jpg", "original_dimensions": {"height": 1305, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/171915136/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/171915136/medium.jpg"} | 2 | 7 | 16642 | {"resolved": 0, "unresolved": 0} | 15685 | http://en.wikipedia.org/wiki/Townsend's_warbler | Aves | Townsend's Warbler | subspecies | ||||||||||||
145276 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 71349, 10117, 145276] | 1 | Cardellina pusilla | 10117 | 48460/1/2/355675/3/7251/71349/10117 | 0 | {"id": 19480310, "license_code": null, "attribution": "(c) isaacsanchez, all rights reserved", "url": "https://static.inaturalist.org/photos/19480310/square.jpg", "original_dimensions": {"height": 1159, "width": 1863}, "flags": [], "square_url": "https://static.inaturalist.org/photos/19480310/square.jpg", "medium_url": "https://static.inaturalist.org/photos/19480310/medium.jpg"} | 1 | 7 | 26155 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Wilson's_warbler | Aves | Wilson's Warbler | subspecies | |||||||||||||
145308 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 9079, 144410, 145308] | 1 | Spinus psaltria | 144410 | 48460/1/2/355675/3/7251/9079/144410 | 0 | {"id": 172905782, "license_code": "cc-by-nc", "attribution": "(c) Robert Shea, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172905782/square.jpg", "original_dimensions": {"height": 2048, "width": 1963}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172905782/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/172905782/medium.jpg"} | 1 | 7 | 71760 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Lesser_goldfinch | Aves | Lesser Goldfinch | subspecies | |||||||||||||
145310 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 9079, 144410, 145310] | 1 | Spinus tristis | 144410 | 48460/1/2/355675/3/7251/9079/144410 | 0 | {"id": 84579952, "license_code": "cc0", "attribution": "no rights reserved, uploaded by Glenn Berry", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/84579952/square.jpeg", "original_dimensions": {"height": 956, "width": 1119}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/84579952/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/84579952/medium.jpeg"} | 1 | 7 | 122233 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/American_goldfinch | Aves | American Goldfinch | subspecies | |||||||||||||
199841 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 9079, 199910, 199841] | 1 | Haemorhous purpureus | 199910 | 48460/1/2/355675/3/7251/9079/199910 | 0 | {"id": 249715786, "license_code": "cc-by-nc", "attribution": "(c) Tom Murray, some rights reserved (CC BY-NC), uploaded by Tom Murray", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/249715786/square.jpeg", "original_dimensions": {"height": 1200, "width": 1500}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/249715786/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/249715786/medium.jpeg"} | 1 | 7 | 25539 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Purple_finch | Aves | Purple Finch | 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);