Employment and wages by occupation, area and industry.
Publisher: Bureau of Labor Statistics
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| area | string | 99 |
| area_title | string | U.S. |
| area_type | string | 1 |
| naics | string | 000000 |
| naics_title | string | Cross-industry |
| own_code | string | 1235 |
| occ_code | string | 00-0000 |
| occ_title | string | All Occupations |
| _group | string | |
| tot_emp | string | 139099570 |
| emp_prse | string | 0.1 |
| jobs_1000 | string | |
| loc_quotient | string | |
| pct_total | string | |
| h_mean | string | 27.07 |
| a_mean | string | 56310 |
| mean_prse | string | 0.1 |
| h_pct10 | string | 10.97 |
| h_pct25 | string | 13.95 |
| h_median | string | 20.17 |
| h_pct75 | string | 32.41 |
| h_pct90 | string | 50.99 |
| a_pct10 | string | 22810 |
| a_pct25 | string | 29020 |
| a_median | string | 41950 |
| a_pct75 | string | 67410 |
| a_pct90 | string | 106050 |
| annual | string | TRUE |
| hourly | string | TRUE |
| column29 | string | |
| prim_state | string | US |
| i_group | string | cross-industry |
| o_group | string | total |
| pct_rpt | string | |
| column30 | string | |
| jobs_1000_orig | string |
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.