Crashes, vehicles, persons and events for every fatal crash, 1975 to 2024.
Publisher: National Highway Traffic Safety Administration
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| state | string | 1 |
| statename | string | |
| st_case | string | 10001 |
| veh_no | string | 1 |
| per_no | string | 1 |
| ve_forms | string | 2 |
| county | string | 97 |
| month | string | 1 |
| monthname | string | |
| day | string | 2 |
| dayname | string | |
| hour | string | 8 |
| hourname | string | |
| minute | string | 10 |
| minutename | string | |
| harm_ev | string | 12 |
| harm_evname | string | |
| man_coll | string | 2 |
| man_collname | string | |
| sch_bus | string | 0 |
| sch_busname | string | |
| mod_year | string | 74 |
| mod_yearname | string | |
| vpicmake | string | |
| vpicmakename | string | |
| vpicmodel | string | |
| vpicmodelname | string | |
| vpicbodyclass | string | |
| vpicbodyclassname | string | |
| make | string | 23 |
| makename | string | |
| body_typ | string | 51 |
| body_typname | string | |
| icfinalbody | string | |
| icfinalbodyname | string | |
| gvwr_from | string | |
| gvwr_fromname | string | |
| gvwr_to | string | |
| gvwr_toname | string | |
| tow_veh | string | 0 |
| tow_vehname | string | |
| age | string | 54 |
| agename | string | |
| sex | string | 1 |
| sexname | string | |
| per_typ | string | 1 |
| per_typname | string | |
| inj_sev | string | 4 |
| inj_sevname | string | |
| seat_pos | string | 1 |
| seat_posname | string | |
| rest_use | string | |
| rest_usename | string | |
| rest_mis | string | |
| rest_misname | string | |
| helm_use | string | |
| helm_usename | string | |
| helm_mis | string | |
| helm_misname | string | |
| air_bag | string | |
| air_bagname | string | |
| ejection | string | 0 |
| ejectionname | string | |
| ej_path | string | |
| ej_pathname | string | |
| extricat | string | 0 |
| extricatname | string | |
| drinking | string | 0 |
| drinkingname | string | |
| alc_det | string | |
| alc_detname | string | |
| alc_status | string | |
| alc_statusname | string | |
| atst_typ | string | |
| atst_typname | string | |
| alc_res | string | |
| alc_resname | string | |
| drugs | string | |
| drugsname | string | |
| drug_det | string |
108 more fields; select the table above to list them all.
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.