Establishments, employment and wages by county, industry and ownership, quarterly and annual, 1990 to 2025.
Publisher: Bureau of Labor Statistics
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| area_fips | string | 42049 |
| own_code | string | 1 |
| industry_code | string | 924 |
| agglvl_code | string | 75 |
| size_code | string | 0 |
| year | string | 1991 |
| qtr | string | 3 |
| disclosure_code | string | - |
| qtrly_estabs | string | 3 |
| month1_emplvl | string | 9 |
| month2_emplvl | string | 9 |
| month3_emplvl | string | 9 |
| total_qtrly_wages | string | 42081 |
| taxable_qtrly_wages | string | 0 |
| qtrly_contributions | string | 0 |
| avg_wkly_wage | string | 360 |
| lq_disclosure_code | string | N |
| lq_qtrly_estabs | string | 0.50 |
| lq_month1_emplvl | string | 0.06 |
| lq_month2_emplvl | string | 0.06 |
| lq_month3_emplvl | string | 0.06 |
| lq_total_qtrly_wages | string | 0.04 |
| lq_taxable_qtrly_wages | string | 0.00 |
| lq_qtrly_contributions | string | 0.00 |
| lq_avg_wkly_wage | string | 0.70 |
| oty_disclosure_code | string | N |
| oty_qtrly_estabs_chg | string | -1 |
| oty_qtrly_estabs_pct_chg | string | -25.0 |
| oty_month1_emplvl_chg | string | 0 |
| oty_month1_emplvl_pct_chg | string | 0.0 |
| oty_month2_emplvl_chg | string | 0 |
| oty_month2_emplvl_pct_chg | string | 0.0 |
| oty_month3_emplvl_chg | string | -1 |
| oty_month3_emplvl_pct_chg | string | -10.0 |
| oty_total_qtrly_wages_chg | string | 1545 |
| oty_total_qtrly_wages_pct_chg | string | 3.8 |
| oty_taxable_qtrly_wages_chg | string | 0 |
| oty_taxable_qtrly_wages_pct_chg | string | 0.0 |
| oty_qtrly_contributions_chg | string | 0 |
| oty_qtrly_contributions_pct_chg | string | 0.0 |
| oty_avg_wkly_wage_chg | string | 26 |
| oty_avg_wkly_wage_pct_chg | string | 7.8 |
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.