taxons
9 rows where "created_at" is on date 2008-03-13
This data as json, CSV (advanced)
Suggested facets: taxon_changes_count, taxon_schemes_count, flag_counts, introduced, native
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 | ||||
4234 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67563, 4203, 4233, 4234] | 1 | Aechmophorus clarkii | 4233 | 48460/1/2/355675/3/67563/4203/4233 | 0 | {"id": 1396951, "license_code": "cc-by-nc", "attribution": "(c) Greg Lasley, some rights reserved (CC BY-NC), uploaded by Greg Lasley", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1396951/square.jpg", "original_dimensions": {"height": 1062, "width": 1500}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1396951/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/1396951/medium.jpg"} | 0 | 9 | 5779 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Clark's_grebe | Aves | Clark's Grebe | subspecies | 48460,1,2,355675,3,67563,4203,4233,4234 | 0 | 4234 | 0 | 0 | 1 | 2008-03-13T02:44:46+00:00 | 0 | 5779 | ||||
4838 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67561, 71325, 4837, 4838] | 1 | Haematopus bachmani | 4837 | 48460/1/2/355675/3/67561/71325/4837 | 0 | {"id": 2059, "license_code": "cc-by", "attribution": "(c) Mike Baird, some rights reserved (CC BY)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2059/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2059/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2059/medium.jpg"} | 1 | 10 | 12902 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Black_oystercatcher | Aves | Black Oystercatcher | subspecies | 48460,1,2,355675,3,67561,71325,4837,4838 | 0 | 4838 | 0 | 0 | 1 | 2008-03-13T02:46:32+00:00 | 0 | 12902 | ||||
4956 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 67566, 4929, 597395, 4950, 4956] | 1 | Ardea herodias | 4950 | 48460/1/2/355675/3/67566/4929/597395/4950 | 0 | {"id": 65060931, "license_code": "cc-by-nc", "attribution": "(c) Dan Roach, some rights reserved (CC BY-NC), uploaded by Dan Roach", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65060931/square.jpg", "original_dimensions": {"height": 1463, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65060931/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65060931/medium.jpg"} | 0 | 9 | 274390 | {"resolved": 3, "unresolved": 0} | 3951 | http://en.wikipedia.org/wiki/Great_blue_heron | Aves | Great Blue Heron | subspecies | 48460,1,2,355675,3,67566,4929,597395,4950,4956 | 0 | 4956 | 0 | 0 | 1 | 2008-03-13T02:46:52+00:00 | 0 | 274390 | |||
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 | ||||
9100 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 559248, 9091, 9100] | 1 | Melospiza melodia | 9091 | 48460/1/2/355675/3/7251/559248/9091 | 0 | {"id": 168805729, "license_code": "cc-by-sa", "attribution": "(c) Cephas, some rights reserved (CC BY-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168805729/square.jpg", "original_dimensions": {"height": 1365, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168805729/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/168805729/medium.jpg"} | 0 | 9 | 168859 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Song_sparrow | Aves | Song Sparrow | subspecies | 48460,1,2,355675,3,7251,559248,9091,9100 | 0 | 9100 | 0 | 0 | 1 | 2008-03-13T03:00:04+00:00 | 0 | 168859 | ||||
9176 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 559248, 9175, 9176] | 1 | Zonotrichia leucophrys | 9175 | 48460/1/2/355675/3/7251/559248/9175 | 0 | {"id": 65971681, "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/65971681/square.jpg", "original_dimensions": {"height": 1678, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65971681/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/65971681/medium.jpg"} | 0 | 9 | 99585 | {"resolved": 2, "unresolved": 0} | http://en.wikipedia.org/wiki/White-crowned_sparrow | Aves | White-crowned Sparrow | subspecies | 48460,1,2,355675,3,7251,559248,9175,9176 | 0 | 9176 | 0 | 0 | 1 | 2008-03-13T03:00:20+00:00 | 0 | 99585 | ||||
9981 | species | 10 | 3 | [48460, 1, 2, 355675, 3, 7251, 559248, 9980, 9981] | 1 | Passerculus sandwichensis | 9980 | 48460/1/2/355675/3/7251/559248/9980 | 0 | {"id": 2466309, "license_code": "cc-by-nc", "attribution": "(c) roy pilcher, some rights reserved (CC BY-NC), uploaded by roy pilcher", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2466309/square.jpg", "original_dimensions": {"height": 615, "width": 820}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2466309/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/2466309/medium.jpg"} | 0 | 9 | 54463 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Savannah_sparrow | Aves | Savannah Sparrow | subspecies | 48460,1,2,355675,3,7251,559248,9980,9981 | 0 | 9981 | 0 | 0 | 1 | 2008-03-13T03:03:24+00:00 | 0 | 54463 | ||||
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 |
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);