Home-to-work flows and job counts by census block, 2002 to 2024.
Publisher: Census Bureau, Longitudinal Employer-Household Dynamics
Runs against the full table. Enter your key; plans are below.
| Field | Type | Example |
|---|---|---|
| state | string | ri |
| part | string | main |
| job_type | string | JT03 |
| year | int | 2019 |
| w_geocode | string | 440070185002001 |
| h_geocode | string | 440070103002002 |
| s000 | bigint | 1 |
| sa01 | bigint | 0 |
| sa02 | bigint | 1 |
| sa03 | bigint | 0 |
| se01 | bigint | 0 |
| se02 | bigint | 0 |
| se03 | bigint | 1 |
| si01 | bigint | 1 |
| si02 | bigint | 0 |
| si03 | bigint | 0 |
| createdate | string | 20230321 |
Settings, Connectors, Add custom connector. Paste this address with your key:
https://data.nysgpt.com/mcp?key=YOUR_KEY
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp --header "X-Api-Key: YOUR_KEY"
curl -s https://data.nysgpt.com/query -H "X-Api-Key: YOUR_KEY" -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). Every call needs a key; plans are below.
$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.