NYSgptData LibraryConnectPricing

Fatal crashes (FARS)

Crashes, vehicles, persons and events for every fatal crash, 1975 to 2024.

32.5MRecords
35Tables
1,481Fields
CurrentYears

Publisher: National Highway Traffic Safety Administration

Try it

This runs against the full table, free, with no key.

Tables
Fields in fars_person
FieldTypeExample
statestring1
statenamestring
st_casestring10001
veh_nostring1
per_nostring1
ve_formsstring2
countystring97
monthstring1
monthnamestring
daystring2
daynamestring
hourstring8
hournamestring
minutestring10
minutenamestring
harm_evstring12
harm_evnamestring
man_collstring2
man_collnamestring
sch_busstring0
sch_busnamestring
mod_yearstring74
mod_yearnamestring
vpicmakestring
vpicmakenamestring
vpicmodelstring
vpicmodelnamestring
vpicbodyclassstring
vpicbodyclassnamestring
makestring23
makenamestring
body_typstring51
body_typnamestring
icfinalbodystring
icfinalbodynamestring
gvwr_fromstring
gvwr_fromnamestring
gvwr_tostring
gvwr_tonamestring
tow_vehstring0
tow_vehnamestring
agestring54
agenamestring
sexstring1
sexnamestring
per_typstring1
per_typnamestring
inj_sevstring4
inj_sevnamestring
seat_posstring1
seat_posnamestring
rest_usestring
rest_usenamestring
rest_misstring
rest_misnamestring
helm_usestring
helm_usenamestring
helm_misstring
helm_misnamestring
air_bagstring
air_bagnamestring
ejectionstring0
ejectionnamestring
ej_pathstring
ej_pathnamestring
extricatstring0
extricatnamestring
drinkingstring0
drinkingnamestring
alc_detstring
alc_detnamestring
alc_statusstring
alc_statusnamestring
atst_typstring
atst_typnamestring
alc_resstring
alc_resnamestring
drugsstring
drugsnamestring
drug_detstring

108 more fields; select the table above to list them all.

Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Vehicle Safety