taxons
18 rows where native = 0
This data as json, CSV (advanced)
Suggested facets: rank, rank_level, iconic_taxon_id, taxon_changes_count, taxon_schemes_count, flag_counts, iconic_taxon_name, introduced, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2969 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 2708, 2715, 2926, 2969] | 1 | Streptopelia decaocto | 2926 | 48460/1/2/355675/3/2708/2715/2926 | 0 | {"id": 61919353, "license_code": null, "attribution": "(c) Daniel, all rights reserved, uploaded by Daniel", "url": "https://static.inaturalist.org/photos/61919353/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/61919353/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/61919353/medium.jpeg"} | 1 | 9 | 95363 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Eurasian_collared_dove | Aves | Eurasian Collared-Dove | subspecies | 48460,1,2,355675,3,2708,2715,2926,2969 | 0 | 2969 | 0 | 1 | 0 | 2008-03-13T02:41:30+00:00 | 0 | 95363 | ||||
14850 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 14841, 14842, 14850] | 1 | Sturnus vulgaris | 14842 | 48460/1/2/355675/3/7251/14841/14842 | 0 | {"id": 32152001, "license_code": "cc-by-nc-nd", "attribution": "(c) Fran Wiesner, some rights reserved (CC BY-NC-ND), uploaded by Fran Wiesner", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32152001/square.jpg", "original_dimensions": {"height": 667, "width": 1000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32152001/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32152001/medium.jpg"} | 0 | 10 | 197288 | {"resolved": 3, "unresolved": 0} | http://en.wikipedia.org/wiki/Common_starling | Aves | European Starling | subspecies | 48460,1,2,355675,3,7251,14841,14842,14850 | 0 | 14850 | 0 | 1 | 0 | 2008-03-13T03:23:08+00:00 | 0 | 197288 | ||||
47219 | species | 10 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47201, 124417, 326777, 47222, 630955, 47221, 199939, 538904, 47220, 578086, 47219] | 1 | Apis mellifera | 578086 | 48460/1/47120/372739/47158/184884/47201/124417/326777/47222/630955/47221/199939/538904/47220/578086 | 0 | {"id": 2369526, "license_code": null, "attribution": "(c) Georges-Alexandre Cotnoir, all rights reserved, uploaded by Georges-Alexandre Cotnoir", "url": "https://static.inaturalist.org/photos/2369526/square.jpg", "original_dimensions": {"height": 1402, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/2369526/square.jpg", "medium_url": "https://static.inaturalist.org/photos/2369526/medium.jpg"} | 1 | 5 | 417154 | {"resolved": 8, "unresolved": 0} | 1233 | http://en.wikipedia.org/wiki/Western_honey_bee | Insecta | Western Honey Bee | 48460,1,47120,372739,47158,184884,47201,124417,326777,47222,630955,47221,199939,538904,47220,578086,47219 | 0 | 47219 | 0 | 1 | 0 | 2008-04-16T18:08:27+00:00 | 0 | 417154 | ||||
47676 | species | 10 | 47115 | [48460, 1, 47115, 47114, 47679, 551398, 47678, 47677, 47676] | 1 | Acmaea mitra | 47677 | 48460/1/47115/47114/47679/551398/47678/47677 | 0 | {"id": 5690447, "license_code": null, "attribution": "(c) Jay Keller, all rights reserved, uploaded by Jay Keller", "url": "https://static.inaturalist.org/photos/5690447/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/5690447/square.jpg", "medium_url": "https://static.inaturalist.org/photos/5690447/medium.jpg"} | 0 | 1 | 1363 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Acmaea_mitra | Mollusca | Whitecap Limpet | 48460,1,47115,47114,47679,551398,47678,47677,47676 | 0 | 47676 | 0 | 0 | 0 | 2008-06-12T10:31:29+00:00 | 0 | 1363 | |||||
48450 | species | 10 | 47115 | [48460, 1, 47115, 47114, 551391, 775797, 775799, 775801, 47113, 801476, 801480, 528872, 47507, 50104, 48450] | 1 | Peltodoris nobilis | 50104 | 48460/1/47115/47114/551391/775797/775799/775801/47113/801476/801480/528872/47507/50104 | 0 | {"id": 3897304, "license_code": "cc-by-nc", "attribution": "(c) Robin Agarwal (ANudibranchMom on iNaturalist), some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3897304/square.jpg", "original_dimensions": {"height": 936, "width": 967}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3897304/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/3897304/medium.jpg"} | 1 | 1 | 3886 | {"resolved": 0, "unresolved": 0} | 85132 | http://en.wikipedia.org/wiki/Peltodoris_nobilis | Mollusca | Noble Dorid | 48460,1,47115,47114,551391,775797,775799,775801,47113,801476,801480,528872,47507,50104,48450 | 0 | 48450 | 0 | 0 | 0 | 2008-09-25T16:37:49+00:00 | 0 | 3886 | ||||
48625 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47791, 47790, 48626, 914083, 48625] | 1 | Oenothera speciosa | 914083 | 48460/47126/211194/47125/47124/47791/47790/48626/914083 | 0 | {"id": 79516474, "license_code": null, "attribution": "(c) MaLisa Spring, all rights reserved, uploaded by MaLisa Spring", "url": "https://static.inaturalist.org/photos/79516474/square.jpg", "original_dimensions": {"height": 1858, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/79516474/square.jpg", "medium_url": "https://static.inaturalist.org/photos/79516474/medium.jpg"} | 0 | 5 | 41070 | {"resolved": 2, "unresolved": 0} | https://en.wikipedia.org/wiki/Oenothera_speciosa | Plantae | Pinkladies | 48460,47126,211194,47125,47124,47791,47790,48626,914083,48625 | 0 | 48625 | 0 | 1 | 0 | 2008-10-20T01:20:55+00:00 | 0 | 41070 | |||||
53271 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 47204, 1473853, 1473856, 574731, 53113, 1183876, 53271] | 1 | Brassica rapa | 1183876 | 48460/47126/211194/47125/47124/71275/47204/1473853/1473856/574731/53113/1183876 | 0 | {"id": 179299209, "license_code": null, "attribution": "(c) David Keil, all rights reserved, uploaded by David Keil", "url": "https://static.inaturalist.org/photos/179299209/square.jpeg", "original_dimensions": {"height": 2048, "width": 1365}, "flags": [], "square_url": "https://static.inaturalist.org/photos/179299209/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/179299209/medium.jpeg"} | 2 | 6 | 15132 | {"resolved": 0, "unresolved": 1} | https://en.wikipedia.org/wiki/Brassica_rapa | Plantae | field mustard | 48460,47126,211194,47125,47124,71275,47204,1473853,1473856,574731,53113,1183876,53271 | 0 | 53271 | 0 | 1 | 0 | 2009-09-20T04:23:25+00:00 | 0 | 15132 | |||||
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 | |||||
55626 | species | 10 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47157, 47224, 48508, 209720, 321384, 475032, 55690, 55626] | 1 | Pieris rapae | 55690 | 48460/1/47120/372739/47158/184884/47157/47224/48508/209720/321384/475032/55690 | 0 | {"id": 28420401, "license_code": "cc-by-nc", "attribution": "(c) Liu JimFood, some rights reserved (CC BY-NC), uploaded by Liu JimFood", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28420401/square.jpg", "original_dimensions": {"height": 1311, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28420401/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28420401/medium.jpg"} | 1 | 5 | 142356 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Pieris_rapae | Insecta | Small White | 48460,1,47120,372739,47158,184884,47157,47224,48508,209720,321384,475032,55690,55626 | 0 | 55626 | 0 | 1 | 0 | 2010-02-08T20:48:36+00:00 | 0 | 142356 | |||||
56083 | species | 10 | 1 | [48460, 1, 47120, 85493, 473790, 47187, 774775, 144114, 48147, 84718, 343783, 343798, 48296, 48295, 56083] | 1 | Armadillidium vulgare | 48295 | 48460/1/47120/85493/473790/47187/774775/144114/48147/84718/343783/343798/48296/48295 | 0 | {"id": 175293083, "license_code": "cc-by-nc", "attribution": "(c) Russell Pfau, some rights reserved (CC BY-NC), uploaded by Russell Pfau", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175293083/square.jpeg", "original_dimensions": {"height": 1869, "width": 1870}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175293083/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175293083/medium.jpeg"} | 0 | 4 | 82493 | {"resolved": 1, "unresolved": 0} | 28594 | http://en.wikipedia.org/wiki/Armadillidium_vulgare | Animalia | Common Pill Woodlouse | 48460,1,47120,85493,473790,47187,774775,144114,48147,84718,343783,343798,48296,48295,56083 | 0 | 56083 | 0 | 1 | 0 | 2010-02-17T06:00:59+00:00 | 0 | 82493 | ||||
57090 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47690, 47689, 47688, 57090] | 1 | Erodium botrys | 47688 | 48460/47126/211194/47125/47124/47690/47689/47688 | 0 | {"id": 16860963, "license_code": "cc0", "attribution": "no rights reserved, uploaded by Al Kordesch", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/16860963/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/16860963/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/16860963/medium.jpg"} | 0 | 5 | 10534 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Erodium_botrys | Plantae | Mediterranean Stork's-bill | 48460,47126,211194,47125,47124,47690,47689,47688,57090 | 0 | 57090 | 0 | 1 | 0 | 2010-03-13T00:41:24+00:00 | 0 | 10534 | |||||
79044 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 632790, 568270, 901794, 53207, 79044] | 1 | Senecio elegans | 53207 | 48460/47126/211194/47125/47124/47605/47604/632790/568270/901794/53207 | 0 | {"id": 97438945, "license_code": "cc0", "attribution": "no rights reserved, uploaded by Alex Heyman", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97438945/square.jpeg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97438945/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97438945/medium.jpeg"} | 0 | 4 | 3635 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Senecio_elegans | Plantae | Red-purple Ragwort | 48460,47126,211194,47125,47124,47605,47604,632790,568270,901794,53207,79044 | 0 | 79044 | 0 | 1 | 0 | 2011-05-13T21:46:16+00:00 | 0 | 3635 | |||||
79138 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48515, 48516, 634936, 634950, 50641, 79138] | 1 | Solanum furcatum | 50641 | 48460/47126/211194/47125/47124/48515/48516/634936/634950/50641 | 0 | {"id": 175860023, "license_code": "cc-by-nc", "attribution": "(c) Steve Kelley, some rights reserved (CC BY-NC), uploaded by Steve Kelley", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175860023/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175860023/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175860023/medium.jpg"} | 0 | 4 | 1819 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Solanum_furcatum | Plantae | forked nightshade | 48460,47126,211194,47125,47124,48515,48516,634936,634950,50641,79138 | 0 | 79138 | 0 | 1 | 0 | 2011-05-13T21:46:32+00:00 | 0 | 1819 | |||||
127555 | species | 10 | 1 | [48460, 1, 47120, 85493, 473790, 47187, 774775, 144113, 47186, 118451, 123825, 47398, 48174, 48173, 127555] | 1 | Pagurus granosimanus | 48173 | 48460/1/47120/85493/473790/47187/774775/144113/47186/118451/123825/47398/48174/48173 | 0 | {"id": 130420, "license_code": "cc-by-nc-nd", "attribution": "(c) Susannah Anderson, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/130420/square.jpg", "original_dimensions": {"height": 1535, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/130420/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/130420/medium.jpg"} | 0 | 2 | 2441 | {"resolved": 0, "unresolved": 0} | Animalia | Grainy Hermit Crab | 48460,1,47120,85493,473790,47187,774775,144113,47186,118451,123825,47398,48174,48173,127555 | 0 | 127555 | 0 | 0 | 0 | 2012-04-29T01:34:08+00:00 | 0 | 2441 | ||||||
254083 | species | 10 | 47115 | [48460, 1, 47115, 47114, 246139, 551422, 122558, 121656, 254083] | 1 | Janthina umbilicata | 121656 | 48460/1/47115/47114/246139/551422/122558/121656 | 0 | {"id": 30864934, "license_code": "cc-by-nc", "attribution": "(c) Andrew Spurgeon, some rights reserved (CC BY-NC), uploaded by Andrew Spurgeon", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30864934/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30864934/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/30864934/medium.jpg"} | 0 | 3 | 133 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Janthina_umbilicata | Mollusca | Elongated Violet Snail | 48460,1,47115,47114,246139,551422,122558,121656,254083 | 0 | 254083 | 0 | 0 | 0 | 2013-04-29T07:13:31+00:00 | 0 | 133 | |||||
479478 | species | 10 | 1 | [48460, 1, 48824, 57736, 551714, 551722, 62614, 131725, 479478] | 1 | Spheciospongia confoederata | 131725 | 48460/1/48824/57736/551714/551722/62614/131725 | 0 | {"id": 25141296, "license_code": "cc-by-nc", "attribution": "(c) Comunidad y Biodiversidad A. C., some rights reserved (CC BY-NC), uploaded by Comunidad y Biodiversidad A. C.", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/25141296/square.jpeg", "original_dimensions": {"height": 469, "width": 435}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/25141296/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/25141296/medium.jpeg"} | 0 | 1 | 221 | {"resolved": 0, "unresolved": 0} | Animalia | gray moon sponge | 48460,1,48824,57736,551714,551722,62614,131725,479478 | 0 | 479478 | 0 | 0 | 0 | 2015-10-28T05:48:57+00:00 | 0 | 221 | ||||||
480298 | species | 10 | 47115 | [48460, 1, 47115, 47114, 551391, 775797, 775800, 775812, 47485, 781349, 781352, 68625, 47484, 906896, 910289, 87634, 480298] | 1 | Cornu aspersum | 87634 | 48460/1/47115/47114/551391/775797/775800/775812/47485/781349/781352/68625/47484/906896/910289/87634 | 0 | {"id": 16302570, "license_code": "cc-by-nc-sa", "attribution": "(c) Ferran Turmo Gort, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/16302570/square.jpg", "original_dimensions": {"height": 1152, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/16302570/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/16302570/medium.jpg"} | 3 | 1 | 82007 | {"resolved": 2, "unresolved": 0} | 18249 | http://en.wikipedia.org/wiki/Cornu_aspersum | Mollusca | Garden Snail | 48460,1,47115,47114,551391,775797,775800,775812,47485,781349,781352,68625,47484,906896,910289,87634,480298 | 0 | 480298 | 0 | 1 | 0 | 2015-11-07T23:44:01+00:00 | 0 | 82007 | ||||
995125 | subspecies | 5 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 47204, 1473853, 1473856, 574731, 55412, 55411, 995125] | 1 | Raphanus raphanistrum sativus | 55411 | 48460/47126/211194/47125/47124/71275/47204/1473853/1473856/574731/55412/55411 | 0 | {"id": 28387821, "license_code": "cc0", "attribution": "no rights reserved, uploaded by 葉子", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28387821/square.jpeg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28387821/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/28387821/medium.jpeg"} | 3 | 1 | 25012 | {"resolved": 2, "unresolved": 1} | Plantae | wild and domestic radish | 48460,47126,211194,47125,47124,71275,47204,1473853,1473856,574731,55412,55411 | 0 | 55411 | 0 | 1 | 0 | 2020-01-09T02:49:58+00:00 | 0 | 25012 |
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);