taxons
3 rows where "created_at" is on date 2011-08-16
This data as json, CSV (advanced)
Suggested facets: rank, rank_level, iconic_taxon_id, taxon_changes_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117674 | species | 10 | 1 | [48460, 1, 47120, 85493, 473790, 47187, 774775, 144114, 48147, 84718, 181176, 55357, 55358, 117674] | 1 | Ligia occidentalis | 55358 | 48460/1/47120/85493/473790/47187/774775/144114/48147/84718/181176/55357/55358 | 0 | {"id": 8629082, "license_code": "cc-by-nc", "attribution": "(c) JJ Johnson, some rights reserved (CC BY-NC), uploaded by JJ Johnson", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/8629082/square.jpeg", "original_dimensions": {"height": 1115, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/8629082/square.jpeg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/8629082/medium.jpeg"} | 0 | 2 | 3219 | {"resolved": 0, "unresolved": 0} | 1747 | http://en.wikipedia.org/wiki/Ligia_occidentalis | Animalia | Western Sea Slater | 48460,1,47120,85493,473790,47187,774775,144114,48147,84718,181176,55357,55358,117674 | 0 | 117674 | 0 | 0 | 1 | 2011-08-16T20:35:27+00:00 | 0 | 3219 | ||||
117695 | species | 10 | 1 | [48460, 1, 47549, 774753, 47720, 995100, 49482, 67558, 117700, 117695] | 1 | Cucumaria miniata | 117700 | 48460/1/47549/774753/47720/995100/49482/67558/117700 | 0 | {"id": 88878668, "license_code": null, "attribution": "(c) lexinecar, all rights reserved", "url": "https://static.inaturalist.org/photos/88878668/square.jpg", "original_dimensions": {"height": 2048, "width": 1536}, "flags": [], "square_url": "https://static.inaturalist.org/photos/88878668/square.jpg", "medium_url": "https://static.inaturalist.org/photos/88878668/medium.jpg"} | 0 | 1 | 4754 | {"resolved": 0, "unresolved": 0} | http://en.wikipedia.org/wiki/Cucumaria_miniata | Animalia | Orange Sea Cucumber | 48460,1,47549,774753,47720,995100,49482,67558,117700,117695 | 0 | 117695 | 0 | 0 | 1 | 2011-08-16T20:36:30+00:00 | 0 | 4754 | |||||
117766 | subspecies | 5 | 40151 | [48460, 1, 2, 355675, 40151, 848317, 848320, 848324, 41573, 372843, 41687, 41707, 41708, 117766] | 1 | Phoca vitulina richardii | 41708 | 48460/1/2/355675/40151/848317/848320/848324/41573/372843/41687/41707/41708 | 0 | {"id": 231409105, "license_code": "cc-by-nc", "attribution": "(c) Igor Derevskov, some rights reserved (CC BY-NC), uploaded by Igor Derevskov", "url": "https://inaturalist-open-data.s3.amazonaws.com/photos/231409105/square.jpg", "original_dimensions": {"height": 1465, "width": 2048}, "flags": [], "square_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/231409105/square.jpg", "medium_url": "https://inaturalist-open-data.s3.amazonaws.com/photos/231409105/medium.jpg"} | 3 | 3 | 14236 | {"resolved": 1, "unresolved": 0} | http://en.wikipedia.org/wiki/Harbor_seal | Mammalia | Pacific Harbor Seal | 48460,1,2,355675,40151,848317,848320,848324,41573,372843,41687,41707,41708 | 0 | 41708 | 0 | 0 | 1 | 2011-08-16T22:31:43+00:00 | 0 | 14236 |
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);