taxons
17 rows where flag_counts = "{"resolved": 0, "unresolved": 1}"
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_changes_count, taxon_schemes_count, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47757 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 70233, 47759, 47758, 864989, 1023136, 47757] | 1 | Oxalis oregana | 1023136 | 48460/47126/211194/47125/47124/70233/47759/47758/864989/1023136 | 0 | {"id": 7609574, "license_code": "cc-by-nc", "attribution": "(c) Ed Miller, some rights reserved (CC BY-NC), uploaded by Ed Miller", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/7609574/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/7609574/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/7609574/medium.jpeg"} | 1 | 3 | 12735 | {"resolved": 0, "unresolved": 1} | 2146 | https://en.wikipedia.org/wiki/Oxalis_oregana | Plantae | redwood sorrel | |||||||||||||
47850 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47853, 47852, 47851, 861029, 861036, 1542658, 47850] | 1 | Quercus agrifolia | 1542658 | 48460/47126/211194/47125/47124/47853/47852/47851/861029/861036/1542658 | 0 | {"id": 18734105, "license_code": "cc-by-sa", "attribution": "(c) Franco Folini, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/18734105/square.jpg", "original_dimensions": {"height": 1356, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/18734105/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/18734105/medium.jpg"} | 0 | 5 | 42092 | {"resolved": 0, "unresolved": 1} | 141 | http://en.wikipedia.org/wiki/Quercus_agrifolia | Plantae | coast live oak | |||||||||||||
51655 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 71289, 48386, 1424203, 51656, 51655] | 1 | Tellima grandiflora | 51656 | 48460/47126/211194/47125/47124/71289/48386/1424203/51656 | 0 | {"id": 143999155, "license_code": "cc-by-nc", "attribution": "(c) Scott Ranger, some rights reserved (CC BY-NC), uploaded by Scott Ranger", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/143999155/square.jpg", "original_dimensions": {"height": 2000, "width": 1333}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/143999155/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/143999155/medium.jpg"} | 0 | 3 | 15475 | {"resolved": 0, "unresolved": 1} | 3404 | http://en.wikipedia.org/wiki/Tellima | Plantae | fringe cups | |||||||||||||
52681 | species | 10 | 47126 | [48460, 47126, 211194, 121943, 764796, 47754, 1224539, 52682, 52683, 52681] | 1 | Pteridium aquilinum | 52683 | 48460/47126/211194/121943/764796/47754/1224539/52682/52683 | 0 | {"id": 149174235, "license_code": "cc-by-nc", "attribution": "(c) Ken Potter, some rights reserved (CC BY-NC), uploaded by Ken Potter", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/149174235/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/149174235/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/149174235/medium.jpeg"} | 2 | 6 | 89375 | {"resolved": 0, "unresolved": 1} | http://en.wikipedia.org/wiki/Pteridium_aquilinum | Plantae | common bracken | ||||||||||||||
52994 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 71417, 52995, 779781, 52994] | 1 | Claytonia perfoliata | 779781 | 48460/47126/211194/47125/47124/47366/71417/52995/779781 | 0 | {"id": 182808852, "license_code": "cc-by-nc", "attribution": "(c) Lauren Glevanik, some rights reserved (CC BY-NC), uploaded by Lauren Glevanik", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/182808852/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/182808852/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/182808852/medium.jpeg"} | 1 | 5 | 33322 | {"resolved": 0, "unresolved": 1} | 1929 | https://en.wikipedia.org/wiki/Claytonia_perfoliata | Plantae | miner's lettuce | |||||||||||||
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 | |||||
57402 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 71275, 47204, 1473853, 1473859, 903171, 50630, 57402] | 1 | Erysimum franciscanum | 50630 | 48460/47126/211194/47125/47124/71275/47204/1473853/1473859/903171/50630 | 0 | {"id": 65046252, "license_code": "cc-by-nc", "attribution": "(c) carlfrederick, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65046252/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65046252/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65046252/medium.jpg"} | 1 | 3 | 1681 | {"resolved": 0, "unresolved": 1} | http://en.wikipedia.org/wiki/Erysimum_franciscanum | Plantae | San Francisco wallflower | {"id": 59790, "place_id": null, "source_id": null, "user_id": null, "authority": "NatureServe", "status": "g3", "status_name": "vulnerable", "geoprivacy": "obscured", "iucn": 30} | |||||||||||||
58812 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 632790, 373844, 900985, 53026, 1119580, 58812] | 1 | Cotula coronopifolia | 1119580 | 48460/47126/211194/47125/47124/47605/47604/632790/373844/900985/53026/1119580 | 0 | {"id": 115578937, "license_code": "cc-by-sa", "attribution": "(c) SABENCIA Guillermo César Ruiz, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/115578937/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/115578937/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/115578937/medium.jpg"} | 1 | 6 | 7569 | {"resolved": 0, "unresolved": 1} | http://en.wikipedia.org/wiki/Cotula_coronopifolia | Plantae | Brass Buttons | ||||||||||||||
58923 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 523723, 48150, 795678, 49347, 58923] | 1 | Phacelia malvifolia | 49347 | 48460/47126/211194/47125/47124/523723/48150/795678/49347 | 0 | {"id": 852283, "license_code": "cc-by-nc", "attribution": "(c) J. Maughn, some rights reserved (CC BY-NC), uploaded by J. Maughn", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/852283/square.jpg", "original_dimensions": {"height": 1643, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/852283/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/852283/medium.jpg"} | 0 | 3 | 1304 | {"resolved": 0, "unresolved": 1} | http://en.wikipedia.org/wiki/Phacelia_malvifolia | Plantae | stinging phacelia | ||||||||||||||
61018 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47123, 47122, 507502, 548591, 47121, 61018] | 1 | Lupinus variicolor | 47121 | 48460/47126/211194/47125/47124/47123/47122/507502/548591/47121 | 0 | {"id": 33634, "license_code": "cc-by-nc-nd", "attribution": "(c) David Hofmann, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/33634/square.jpg", "original_dimensions": {"height": 1220, "width": 1830}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/33634/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/33634/medium.jpg"} | 1 | 4 | 1992 | {"resolved": 0, "unresolved": 1} | 13897 | http://en.wikipedia.org/wiki/Lupinus_variicolor | Plantae | Varied Lupine | 48460,47126,211194,47125,47124,47123,47122,507502,548591,47121,61018 | 1 | 61018 | 0 | 0 | 1 | 2010-05-22T21:42:34+00:00 | 0 | 1992 | ||||
61992 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 632790, 461542, 972893, 55365, 61992] | 1 | Grindelia stricta | 55365 | 48460/47126/211194/47125/47124/47605/47604/632790/461542/972893/55365 | 0 | {"id": 151301892, "license_code": "cc-by-nc", "attribution": "(c) Darren and Claudia, some rights reserved (CC BY-NC), uploaded by Darren and Claudia", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/151301892/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/151301892/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/151301892/medium.jpg"} | 0 | 3 | 7593 | {"resolved": 0, "unresolved": 1} | 22878 | http://en.wikipedia.org/wiki/Grindelia_stricta | Plantae | Oregon Gumplant | |||||||||||||
64240 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 47162, 47434, 897782, 373845, 52715, 64240] | 1 | Cortaderia selloana | 52715 | 48460/47126/211194/47125/47163/47162/47434/897782/373845/52715 | 0 | {"id": 249034897, "license_code": "cc0", "attribution": "no rights reserved, uploaded by Alan Weakley", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/249034897/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/249034897/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/249034897/medium.jpg"} | 0 | 5 | 17213 | {"resolved": 0, "unresolved": 1} | http://en.wikipedia.org/wiki/Cortaderia_selloana | Plantae | Pampas Grass | ||||||||||||||
78450 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 48382, 922206, 922225, 922227, 61787, 78450] | 1 | Persicaria amphibia | 61787 | 48460/47126/211194/47125/47124/47366/48382/922206/922225/922227/61787 | 0 | {"id": 61212580, "license_code": "cc-by-nc", "attribution": "(c) erik_p, some rights reserved (CC BY-NC), uploaded by erik_p", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/61212580/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/61212580/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/61212580/medium.jpeg"} | 3 | 5 | 16316 | {"resolved": 0, "unresolved": 1} | http://en.wikipedia.org/wiki/Persicaria_amphibia | Plantae | water smartweed | ||||||||||||||
520456 | species | 10 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47157, 47224, 47923, 58558, 125833, 522678, 520397, 520456] | 1 | Icaricia acmon | 520397 | 48460/1/47120/372739/47158/184884/47157/47224/47923/58558/125833/522678/520397 | 0 | {"id": 147376944, "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/147376944/square.jpg", "original_dimensions": {"height": 1018, "width": 1225}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/147376944/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/147376944/medium.jpg"} | 3 | 0 | 11664 | {"resolved": 0, "unresolved": 1} | 13312 | http://en.wikipedia.org/wiki/Acmon_blue | Insecta | Acmon Blue | |||||||||||||
627381 | species | 10 | 47170 | [48460, 47170, 47169, 492000, 50814, 48341, 48340, 48339, 1167950, 1396270, 627381] | 1 | Russula rhodocephala | 1396270 | 48460/47170/47169/492000/50814/48341/48340/48339/1167950/1396270 | 0 | {"id": 14408480, "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/14408480/square.jpg", "original_dimensions": {"height": 1356, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/14408480/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/14408480/medium.jpg"} | 0 | 0 | 2683 | {"resolved": 0, "unresolved": 1} | https://en.wikipedia.org/wiki/Russula_rhodocephala | Fungi | Redhead Russula | ||||||||||||||
898651 | species | 10 | 1 | [48460, 1, 47534, 47533, 202756, 47797, 813978, 813994, 47796, 47795, 898651] | 1 | Urticina clandestina | 47795 | 48460/1/47534/47533/202756/47797/813978/813994/47796/47795 | 0 | {"id": 4084936, "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/4084936/square.jpg", "original_dimensions": {"height": 1863, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4084936/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/4084936/medium.jpg"} | 0 | 1 | 1856 | {"resolved": 0, "unresolved": 1} | Animalia | Pacific Stubby Rose Anemone | |||||||||||||||
1196784 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47163, 47218, 47599, 508839, 1196714, 1196784] | 1 | Dipterostemon capitatus | 1196714 | 48460/47126/211194/47125/47163/47218/47599/508839/1196714 | 0 | {"id": 2641, "license_code": "cc-by", "attribution": "(c) Tom Hilton, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2641/square.jpg", "original_dimensions": {"height": 1447, "width": 1929}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2641/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2641/medium.jpg"} | 2 | 1 | 38240 | {"resolved": 0, "unresolved": 1} | 30842 | https://en.wikipedia.org/wiki/Dichelostemma_capitatum | Plantae | Blue Dicks |
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);