taxons
7 rows where taxon_changes_count = 4
This data as json, CSV (advanced)
Suggested facets: iconic_taxon_id, taxon_schemes_count, flag_counts, iconic_taxon_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48750 | species | 10 | 47115 | [48460, 1, 47115, 47114, 47679, 551398, 48751, 1067225, 1067558, 48752, 48750] | 1 | Lottia scabra | 48752 | 48460/1/47115/47114/47679/551398/48751/1067225/1067558/48752 | 0 | {"id": 12200448, "license_code": "cc-by-nc", "attribution": "(c) shannonlee, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/12200448/square.jpg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/12200448/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/12200448/medium.jpg"} | 4 | 1 | 3217 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Lottia_scabra | Mollusca | Rough Limpet | ||||||||||||||
52992 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 632790, 373844, 900988, 52845, 52992] | 1 | Matricaria discoidea | 52845 | 48460/47126/211194/47125/47124/47605/47604/632790/373844/900988/52845 | 0 | {"id": 63400708, "license_code": "cc-by-nc", "attribution": "(c) Andrea Kreuzhage, some rights reserved (CC BY-NC), uploaded by Andrea Kreuzhage", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/63400708/square.jpeg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/63400708/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/63400708/medium.jpeg"} | 4 | 5 | 34535 | {"resolved": 2, "unresolved": 0} | 53514 | http://en.wikipedia.org/wiki/Matricaria_discoidea | Plantae | pineapple-weed | |||||||||||||
53387 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47195, 47194, 47193, 1296983, 53387] | 1 | Cornus sericea | 1296983 | 48460/47126/211194/47125/47124/47195/47194/47193/1296983 | 0 | {"id": 16633753, "license_code": null, "attribution": "(c) adrianakolev, all rights reserved", "url": "https://static.inaturalist.org/photos/16633753/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://static.inaturalist.org/photos/16633753/square.jpg", "medium_url": "https://static.inaturalist.org/photos/16633753/medium.jpg"} | 4 | 3 | 50550 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Cornus_sericea | Plantae | red osier dogwood | ||||||||||||||
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 | 23533 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Lobularia_maritima | Plantae | sweet alyssum | ||||||||||||||
418653 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47366, 49320, 624227, 624230, 72392, 418653] | 1 | Tetragonia tetragonoides | 72392 | 48460/47126/211194/47125/47124/47366/49320/624227/624230/72392 | 0 | {"id": 32211332, "license_code": "cc-by-nc-sa", "attribution": "(c) Kuan-Chieh (Chuck) Hung, some rights reserved (CC BY-NC-SA), uploaded by Kuan-Chieh (Chuck) Hung", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32211332/square.jpeg", "original_dimensions": {"height": 1536, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32211332/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/32211332/medium.jpeg"} | 4 | 1 | 4947 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Tetragonia_tetragonioides | Plantae | New Zealand Spinach | ||||||||||||||
524900 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47132, 47148, 415343, 885411, 975960, 156879, 524900] | 1 | Argentina pacifica | 156879 | 48460/47126/211194/47125/47124/47132/47148/415343/885411/975960/156879 | 0 | {"id": 135888693, "license_code": "cc-by-nc", "attribution": "(c) ruram11, some rights reserved (CC BY-NC)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/135888693/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/135888693/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/135888693/medium.jpg"} | 4 | 1 | 3085 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Argentina_pacifica | Plantae | Pacific silverweed | ||||||||||||||
1021509 | species | 10 | 47158 | [48460, 1, 47120, 372739, 47158, 184884, 47157, 47224, 47922, 202067, 202224, 48506, 1021509] | 1 | Junonia grisea | 48506 | 48460/1/47120/372739/47158/184884/47157/47224/47922/202067/202224/48506 | 0 | {"id": 87669988, "license_code": "cc-by-nc", "attribution": "(c) cjackson, some rights reserved (CC BY-NC), uploaded by cjackson", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/87669988/square.jpg", "original_dimensions": {"height": 944, "width": 1255}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/87669988/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/87669988/medium.jpg"} | 4 | 0 | 17398 | {"resolved": 3, "unresolved": 0} | 26377 | https://en.wikipedia.org/wiki/Junonia_grisea | Insecta | Gray Buckeye |
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);