Tables that support the application and fall outside the datasets above.
Publisher:
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| doctype_html | string | <html lang="en"> |
| column01 | string | charset=ISO-8859-1" /> |
| column02 | string | "></div> --> |
| column03 | string | "> |
| column04 | string | ?></span><button type="button" id="copyAzureCliBtn" class=" |
| column05 | string | " aria-label="Click to Copy AWS CLI" style="padding: 0px 5px |
| column06 | string | border-width: 0px |
| column07 | string | "><i class="fa fa-clone fa-rotate-270 me-2"></i></button> |
| column08 | string | at times that look reasonable and to " |
| column09 | string | 1" |
| column10 | string | at times that look obviously bad. Again, the data have not |
| column11 | string | br> |
| column12 | string | |
| column1 | string | |
| column2 | string | |
| column3 | string | |
| column4 | string | |
| column5 | string | |
| column6 | string | |
| column7 | string | |
| column8 | string | |
| column13 | string | |
| column14 | string | |
| column15 | string | |
| column16 | string | |
| column17 | string | |
| column18 | string | |
| column9 | string | |
| column19 | string | |
| column20 | string | |
| column21 | string | |
| column22 | string | |
| column23 | string | |
| column24 | string | |
| column25 | string | |
| column26 | string | |
| column27 | string | |
| column28 | string | |
| column29 | string | |
| column30 | string | |
| column31 | string | |
| column32 | string | |
| column33 | string | |
| column34 | string | |
| column35 | string | |
| column36 | string | |
| column37 | string | |
| column38 | string | |
| column39 | string | |
| column40 | string | |
| column41 | string | |
| column42 | string | |
| column43 | string | |
| column44 | string | |
| column45 | string | |
| column46 | string | |
| column47 | string | |
| column48 | string | |
| column49 | string | |
| column50 | string | |
| column51 | string | |
| column52 | string | |
| column53 | string | |
| column54 | string | |
| column55 | string | |
| column56 | string | |
| column57 | string | |
| column58 | string | |
| column59 | string | |
| column60 | string | |
| column61 | string | |
| column62 | string | |
| column63 | string | |
| column64 | string | |
| column65 | string | |
| column66 | string | |
| column67 | string | |
| column68 | string | |
| column69 | string | |
| column70 | string |
1,821 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.