# Datasette > A collection of public datasets, explorable with SQL. Datasette exposes this data over an HTTP API. Append `.json` or `.csv` to any table, database or SQL-query URL, or run SQL via `/.json?sql=`. To download a whole table cleanly, stream it as CSV with `?_stream=on` (no row limit). Per-database and per-table `llms.txt` files, with full-download instructions, are linked below. ## Databases - [earthquakes](/earthquakes/llms.txt): 11,808 earthquakes worldwide from 2020 to 2026, sourced from USGS. Includes magnitude, depth, location coordinates, and error estimates. - [everest](/everest/llms.txt): 45,000 individual Everest climbing attempts (1990–2026) with demographics, expedition logistics, oxygen use, weather conditions, and summit outcomes. - [sleep_and_gpa](/sleep_and_gpa/llms.txt): 634 students across 5 university cohorts with objectively-measured sleep data (wearables) linked to academic performance (term GPA). - [h3_units](/h3_units/llms.txt): Creatures, heroes, and artifacts from Heroes III including Restoration of Erathia, Armageddon's Blade, Horn of the Abyss (Cove, Factory), and the upcoming Bulwark faction. Each table includes icons rendered inline. - [aom_units](/aom_units/llms.txt): 277 units from Age of Mythology and every expansion (The Titans, Tale of the Dragon, Retold, Heavenly Spear, Immortal Pillars). Each unit has full stats, costs, bonus multipliers, and an icon. Covers Greeks, Egyptians, Norse, Atlanteans, Chinese, Aztecs, and Japanese. - [abc_news](/abc_news/llms.txt): 1.24 million headlines published by ABC News (Australia), spanning 2003 to present. Useful for NLP, topic modeling, and trend analysis. - [cnc_units](/cnc_units/llms.txt): 107 units from Command & Conquer (cnc), Red Alert (ra), and Dune 2000 (d2k) with name, category, faction, cost, and a thumbnail icon. ## Tables - [earthquakes/earthquakes](/earthquakes/earthquakes/llms.txt): 11808 rows; One row per seismic event. Includes time, coordinates, depth, magnitude, magnitude type, region, and review status. - [everest/summit_master](/everest/summit_master/llms.txt): 45000 rows; One row per climber-attempt. Includes climber age, sex, route, team size, sherpa ratio, oxygen usage, acclimatization days, weather score, jetstream risk, queue time, and whether the climber summited. - [everest/data_dictionary](/everest/data_dictionary/llms.txt): 25 rows; Column names, types, and descriptions for the summit_master table. - [sleep_and_gpa/students](/sleep_and_gpa/students/llms.txt): 634 rows; One row per student-semester. Includes average sleep duration, bedtime variability, daytime sleep, sleep midpoint, prior GPA, term GPA, and course load. - [sleep_and_gpa/cohort_reference](/sleep_and_gpa/cohort_reference/llms.txt): 5 rows; Lookup table mapping cohort codes to universities and semesters. - [h3_units/units](/h3_units/units/llms.txt): 190 rows; One row per creature. The icon column contains the creature's portrait (32x32) as a PNG blob, rendered inline by datasette-render-images. - [h3_units/heroes](/h3_units/heroes/llms.txt): 200 rows; One row per hero. The icon column contains the hero's portrait as a PNG blob, rendered inline by datasette-render-images. - [h3_units/artifacts](/h3_units/artifacts/llms.txt): 156 rows; One row per artifact. The icon column contains the artifact's icon as a PNG blob, rendered inline by datasette-render-images. - [h3_units/skills](/h3_units/skills/llms.txt): 30 rows; One row per secondary skill. The icon column contains the skill's expert-level icon as a PNG blob, rendered inline by datasette-render-images. - [h3_units/resources](/h3_units/resources/llms.txt): 7 rows; One row per resource. The icon column contains the resource's leather-style icon as a PNG blob, rendered inline by datasette-render-images. - [h3_units/battles_1v1](/h3_units/battles_1v1/llms.txt): 72 rows; Simulated 1-v-1 creature duels at equal gold budget. Each row pairs two creature types and records the winner, rounds to finish, and survivors remaining. - [h3_units/battles_army](/h3_units/battles_army/llms.txt): 72 rows; Simulated full-army battles between 7-creature stacks at equal gold budget. The left_army and right_army columns contain JSON arrays of the army composition (creature name, count, and survivors per slot). - [h3_units/towns](/h3_units/towns/llms.txt): 12 rows; One row per faction. The icon column contains the town's portrait as a PNG blob, rendered inline by datasette-render-images. - [aom_units/units](/aom_units/units/llms.txt): 277 rows; One row per unit. Includes faction, role (human/myth/hero), expansion, age, costs (food/wood/gold/favor/population), HP, armor, speed, attack (hack/pierce/crush, melee & ranged), range, train time, and icon (PNG blob). - [aom_units/sqlite_sequence](/aom_units/sqlite_sequence/llms.txt): 1 rows; columns: name, seq - [abc_news/headlines](/abc_news/headlines/llms.txt): 1244184 rows; One row per headline with publish date (YYYYMMDD integer) and the headline text. - [cnc_units/units](/cnc_units/units/llms.txt): 107 rows; One row per unit. The icon column contains the unit's sprite as a PNG blob, rendered inline by datasette-render-images. - [cnc_units/duels](/cnc_units/duels/llms.txt): 4510 rows; 1,156 simulated 1-v-1 unit duels. Each row is a battle between an attacker and defender unit type at a fixed budget, recording HP, cost, units remaining, winner, and elapsed time.