taxons
1 row where "created_at" is on date 2010-02-17
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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);