Votes by precinct, office and candidate, 2016 to 2026.
Publisher: MIT Election Data and Science Lab; OpenElections; Voting and Election Science Team; local election offices
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| precinct | string | FP04 |
| office | string | SUPERINTENDENT OF PUBLIC INSTRUCTION |
| party_detailed | string | REPUBLICAN |
| party_simplified | string | REPUBLICAN |
| mode | string | ELECTION DAY - TRANSFER_5 |
| votes | bigint | 0 |
| county_name | string | NEW HANOVER |
| county_fips | string | 37129 |
| jurisdiction_name | string | NEW HANOVER |
| jurisdiction_fips | string | 37129 |
| candidate | string | UNDERVOTES |
| district | string | STATEWIDE |
| magnitude | string | 1 |
| dataverse | string | STATE |
| year | string | 2020 |
| stage | string | GEN |
| state | string | NORTH CAROLINA |
| special | string | FALSE |
| writein | string | FALSE |
| state_po | string | NC |
| state_fips | string | 37 |
| state_cen | string | 56 |
| state_ic | string | 47 |
| date | string | 2020-11-03 |
| readme_check | string | FALSE |
| source_file | string | 2020-nc-precinct-general-sorted.csv |
| dataset | string | NT66Z3 |
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.