taxons
11 rows where flag_counts = "{"resolved": 5, "unresolved": 0}"
This data as json, CSV (advanced)
Suggested facets: rank, rank_level, iconic_taxon_id, taxon_changes_count, taxon_schemes_count, iconic_taxon_name, introduced, native, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4364 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 4342, 447155, 4343, 4364] | 1 | Larus delawarensis | 4343 | 48460/1/2/355675/3/67561/4342/447155/4343 | 0 | {"id": 117303151, "license_code": "cc-by-nc-nd", "attribution": "(c) Craig K. Hunt, some rights reserved (CC BY-NC-ND), uploaded by Craig K. Hunt", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/117303151/square.jpg", "original_dimensions": {"height": 1410, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/117303151/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/117303151/medium.jpg"} | 0 | 9 | 102075 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Ring-billed_gull | Aves | Ring-billed Gull | subspecies | |||||||||||||
4672 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67570, 4637, 4638, 4672] | 1 | Falco columbarius | 4638 | 48460/1/2/355675/3/67570/4637/4638 | 0 | {"id": 60548654, "license_code": null, "attribution": "(c) Daniel Garza Tobón, all rights reserved, uploaded by Daniel Garza Tobón", "url": "https://static.inaturalist.org/photos/60548654/square.png", "original_dimensions": {"height": 864, "width": 1208}, "flags": [], "square_url": "https://static.inaturalist.org/photos/60548654/square.png", "medium_url": "https://static.inaturalist.org/photos/60548654/medium.png"} | 0 | 9 | 24748 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Merlin_(bird) | Aves | Merlin | subspecies | |||||||||||||
4756 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 559244, 71306, 4755, 4756] | 1 | Cathartes aura | 4755 | 48460/1/2/355675/3/559244/71306/4755 | 0 | {"id": 52277010, "license_code": "cc-by-nc", "attribution": "(c) Seig, some rights reserved (CC BY-NC), uploaded by Seig", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/52277010/square.jpg", "original_dimensions": {"height": 1579, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/52277010/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/52277010/medium.jpg"} | 0 | 9 | 164176 | {"resolved": 5, "unresolved": 0} | 3950 | https://en.wikipedia.org/wiki/Turkey_vulture | Aves | Turkey Vulture | subspecies | ||||||||||||
6358 | genus | 20 | 3 | [48460, 1, 2, 355675, 3, 67573, 5562, 1542290, 1542294, 6358] | 1 | Selasphorus | 1542294 | 48460/1/2/355675/3/67573/5562/1542290/1542294 | 0 | {"id": 69311285, "license_code": null, "attribution": "(c) Roberto Carlos Martinez, all rights reserved, uploaded by Roberto Carlos Martinez", "url": "https://static.inaturalist.org/photos/69311285/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/69311285/square.jpg", "medium_url": "https://static.inaturalist.org/photos/69311285/medium.jpg"} | 1 | 1 | 50064 | {"resolved": 5, "unresolved": 0} | 9 | http://en.wikipedia.org/wiki/Selasphorus | Aves | Rufous, Allen's, and Allied Hummingbirds | subspecies | ||||||||||||
7089 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 6888, 6912, 7086, 7089] | 1 | Branta canadensis | 7086 | 48460/1/2/355675/3/6888/6912/7086 | 0 | {"id": 181719420, "license_code": null, "attribution": "(c) Dimitris Salas, all rights reserved, uploaded by Dimitris Salas", "url": "https://static.inaturalist.org/photos/181719420/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/181719420/square.jpg", "medium_url": "https://static.inaturalist.org/photos/181719420/medium.jpg"} | 0 | 10 | 286401 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Canada_goose | Aves | Canada Goose | subspecies | 48460,1,2,355675,3,6888,6912,7086,7089 | 0 | 7089 | 0 | 0 | 1 | 2008-03-13T02:53:16+00:00 | 0 | 286401 | ||||
41708 | species | 10 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 41573, 372843, 41687, 41707, 41708] | 1 | Phoca vitulina | 41707 | 48460/1/2/355675/40151/848317/848320/848324/41573/372843/41687/41707 | 0 | {"id": 190781322, "license_code": "cc-by-nc-nd", "attribution": "(c) Andrew Reding, some rights reserved (CC BY-NC-ND)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/190781322/square.jpg", "original_dimensions": {"height": 1000, "width": 1500}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/190781322/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/190781322/medium.jpg"} | 0 | 6 | 45082 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Harbor_seal | Mammalia | Harbor Seal | 48460,1,2,355675,40151,848317,848320,848324,41573,372843,41687,41707,41708 | 0 | 41708 | 0 | 0 | 1 | 2008-03-19T00:35:25+00:00 | 0 | 45082 | |||||
48715 | species | 10 | 47170 | [48460, 47170, 47169, 492000, 50814, 1094814, 47167, 785522, 118249, 1149497, 48419, 1142599, 954920, 1155969, 48715] | 1 | Amanita muscaria | 1155969 | 48460/47170/47169/492000/50814/1094814/47167/785522/118249/1149497/48419/1142599/954920/1155969 | 0 | {"id": 26555709, "license_code": null, "attribution": "(c) cactusdan, all rights reserved", "url": "https://static.inaturalist.org/photos/26555709/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/26555709/square.jpg", "medium_url": "https://static.inaturalist.org/photos/26555709/medium.jpg"} | 1 | 4 | 94633 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Amanita_muscaria | Fungi | Fly Agaric | ||||||||||||||
52989 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 201654, 632883, 632885, 48561, 52989] | 1 | Cirsium vulgare | 48561 | 48460/47126/211194/47125/47124/47605/47604/201654/632883/632885/48561 | 0 | {"id": 306770747, "license_code": "cc-by-nc", "attribution": "(c) bienchen, some rights reserved (CC BY-NC), uploaded by bienchen", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/306770747/square.jpeg", "original_dimensions": {"height": 1080, "width": 1620}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/306770747/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/306770747/medium.jpeg"} | 1 | 6 | 100125 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Cirsium_vulgare | Plantae | Bull Thistle | ||||||||||||||
53421 | species | 10 | 47126 | [48460, 47126, 211194, 136329, 47375, 47562, 1456301, 47561, 790732, 790770, 53421] | 1 | Pinus radiata | 790770 | 48460/47126/211194/136329/47375/47562/1456301/47561/790732/790770 | 0 | {"id": 39486159, "license_code": null, "attribution": "(c) mazer, all rights reserved, uploaded by mazer", "url": "https://static.inaturalist.org/photos/39486159/square.jpeg", "original_dimensions": {"height": 2048, "width": 1365}, "flags": [], "square_url": "https://static.inaturalist.org/photos/39486159/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/39486159/medium.jpeg"} | 0 | 8 | 10689 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Pinus_radiata | Plantae | Monterey pine | ||||||||||||||
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 | |||||
55978 | genus | 20 | 47126 | [48460, 47126, 211194, 47125, 47124, 48796, 48797, 860115, 860842, 55978] | 1 | Malva | 860842 | 48460/47126/211194/47125/47124/48796/48797/860115/860842 | 0 | {"id": 39050178, "license_code": null, "attribution": "(c) L, all rights reserved, uploaded by L", "url": "https://static.inaturalist.org/photos/39050178/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://static.inaturalist.org/photos/39050178/square.jpeg", "medium_url": "https://static.inaturalist.org/photos/39050178/medium.jpeg"} | 1 | 0 | 157709 | {"resolved": 5, "unresolved": 0} | http://en.wikipedia.org/wiki/Malva | Plantae | Mallows |
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);