Nationally representative samples of police-reported crashes, 2015 to 2024.
Publisher: National Highway Traffic Safety Administration
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| casenum | string | |
| veh_no | string | |
| stratum | string | |
| stratumname | string | |
| region | string | |
| regionname | string | |
| psu | string | |
| pj | string | |
| psu_var | string | |
| urbanicity | string | |
| urbanicityname | string | |
| damage | string | |
| damagename | string | |
| psustrat | string | |
| weight | string | |
| _202102916823 | string | 202102916823 |
| _1 | string | 1 |
| _10 | string | 10 |
| stratum_10_other | string | Stratum 10 - Other |
| _3 | string | 3 |
| south_md_de_dc_wv_va_ky_tn_nc_sc_ga_fl_al_ms_la_ar_ok_tx | string | South (MD, DE, DC, WV, VA, KY, TN, NC, SC, GA, FL, AL, MS, L |
| _51 | string | 51 |
| _1079 | string | 1079 |
| _51_1 | string | 51 |
| _1_1 | string | 1 |
| urban_area | string | Urban Area |
| _7 | string | 8 |
| _7_clock_value | string | 8 Clock Value |
| _10_1 | string | 10 |
| _23646156452 | string | 236.46156452 |
| _202203729314 | string | |
| _5 | string | |
| stratum_5_nlmy_pv_serious_injury | string | |
| _75 | string | |
| _4144 | string | |
| _75_1 | string | |
| _2 | string | |
| rural_area | string | |
| _1_clock_value | string | |
| _19 | string | |
| _29239052618 | string | |
| _202405532075 | string | |
| _33 | string | |
| _33_1 | string | |
| _11 | string | |
| _1477 | string | |
| _22439422802 | string | |
| _6 | string | |
| _6_clock_value | string | |
| _201901174219 | string | |
| _3_1 | string | |
| _3_clock_value | string | |
| _20366511961 | string | |
| mdareas | string |
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.