taxons
4 rows where "created_at" is on date 2011-05-13
This data as json, CSV (advanced)
Suggested facets: taxon_changes_count, taxon_schemes_count, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
75668 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47123, 47122, 507502, 712370, 49370, 75668] | 1 | Astragalus nuttallii | 49370 | 48460/47126/211194/47125/47124/47123/47122/507502/712370/49370 | 0 | {"id": 27117590, "license_code": "cc0", "attribution": "no rights reserved, uploaded by Scott Yarger", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27117590/square.jpeg", "original_dimensions": {"height": 1440, "width": 1920}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27117590/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/27117590/medium.jpeg"} | 0 | 3 | 2148 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Astragalus_nuttallii | Plantae | Nuttall's Milkvetch | 48460,47126,211194,47125,47124,47123,47122,507502,712370,49370,75668 | 0 | 75668 | 0 | 0 | 1 | 2011-05-13T21:38:04+00:00 | 0 | 2148 | |||||
75976 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47791, 47790, 72029, 75976] | 1 | Camissoniopsis cheiranthifolia | 72029 | 48460/47126/211194/47125/47124/47791/47790/72029 | 0 | {"id": 11555, "license_code": "cc-by-nc-sa", "attribution": "(c) randomtruth, some rights reserved (CC BY-NC-SA)", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11555/square.jpg", "original_dimensions": {"height": 1500, "width": 2000}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11555/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/11555/medium.jpg"} | 1 | 2 | 8273 | {"resolved": 0, "unresolved": 0} | 3708 | http://en.wikipedia.org/wiki/Camissoniopsis_cheiranthifolia | Plantae | beach suncup | 48460,47126,211194,47125,47124,47791,47790,72029,75976 | 0 | 75976 | 0 | 0 | 1 | 2011-05-13T21:38:46+00:00 | 0 | 8273 | ||||
79044 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 47605, 47604, 632790, 568270, 901794, 53207, 79044] | 1 | Senecio elegans | 53207 | 48460/47126/211194/47125/47124/47605/47604/632790/568270/901794/53207 | 0 | {"id": 97438945, "license_code": "cc0", "attribution": "no rights reserved, uploaded by Alex Heyman", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97438945/square.jpeg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97438945/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/97438945/medium.jpeg"} | 0 | 4 | 3635 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Senecio_elegans | Plantae | Red-purple Ragwort | 48460,47126,211194,47125,47124,47605,47604,632790,568270,901794,53207,79044 | 0 | 79044 | 0 | 1 | 0 | 2011-05-13T21:46:16+00:00 | 0 | 3635 | |||||
79138 | species | 10 | 47126 | [48460, 47126, 211194, 47125, 47124, 48515, 48516, 634936, 634950, 50641, 79138] | 1 | Solanum furcatum | 50641 | 48460/47126/211194/47125/47124/48515/48516/634936/634950/50641 | 0 | {"id": 175860023, "license_code": "cc-by-nc", "attribution": "(c) Steve Kelley, some rights reserved (CC BY-NC), uploaded by Steve Kelley", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175860023/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175860023/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/175860023/medium.jpg"} | 0 | 4 | 1819 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Solanum_furcatum | Plantae | forked nightshade | 48460,47126,211194,47125,47124,48515,48516,634936,634950,50641,79138 | 0 | 79138 | 0 | 1 | 0 | 2011-05-13T21:46:32+00:00 | 0 | 1819 |
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);