County presidential returns from 2000, House and Senate returns from 1976, and state legislative returns from 1967.
Publisher: MIT Election Data and Science Lab; Carl Klarner
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| caseid | string | 399102 |
| uncert | string | partytsource |
| year | string | 2020 |
| month | string | 11 |
| day | string | 3 |
| sid | string | 29 |
| sab | string | NH |
| sfips | string | 33 |
| sicpsr | string | 4 |
| cname | string | |
| cfips | string | |
| sen | string | 0 |
| ddez | string | Hillsborough 37 |
| dname | string | hillsborough |
| dno | string | 37 |
| geopost | string | |
| mmdpost | string | |
| specpost | string | |
| dtype | string | 3 |
| dseats | string | 11 |
| popnum | string | 11 |
| redist | string | 0 |
| redist1 | string | |
| redist2 | string | 92 |
| redist3 | string | |
| regime | string | 2012 |
| flot | string | 0 |
| flot1 | string | |
| flot2 | string | |
| flot3 | string | |
| nest | string | 0 |
| nest1 | string | |
| nest2 | string | 2 |
| nest3 | string | |
| etype | string | g |
| deter | string | 1 |
| eseats | string | 11 |
| term | string | 2 |
| termz | string | 2 |
| cando | string | |
| candformat | string | splitnames |
| cand | string | wyatt, timothy |
| candid | string | 399102 |
| partyo | string | d |
| party | string | workingfamilies |
| partyz | string | d |
| partyt | string | d |
| partytsource | string | |
| firstcase | string | 0 |
| prior1 | string | |
| prior2 | string | |
| exper | string | none |
| vote | string | 6236 |
| outcome | string | l |
| hold | string | 0 |
| hold1 | string | |
| hold2 | string | |
| tenure1 | string | 0 |
| tenure2 | string | 0 |
| limit | string | |
| last | string | wyatt |
| first | string | timothy |
| middle | string | s |
| middle2 | string | t |
| nick | string | winkie |
| suffix | string | jr |
| prefix | string | |
| namenum | string | 2 |
| last1 | string | brook |
| last2 | string | krasny |
| last3 | string | |
| last4 | string | |
| ltype1 | string | hyphenated part known |
| ltype2 | string | hyphenated part known |
| ltype3 | string | |
| ltype4 | string | |
| lastb | string | |
| firstb | string | |
| middleb | string | |
| middle2b | string |
27 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.