NYSgptData LibraryConnectPricing

Quarterly Census of Employment and Wages

Establishments, employment and wages by county, industry and ownership, quarterly and annual, 1990 to 2025.

502MRecords
7Tables
90Fields
CurrentYears

Publisher: Bureau of Labor Statistics

Try it

This runs against the full table, free, with no key.

Tables
Fields in qcew_quarterly
FieldTypeExample
area_fipsstring42049
own_codestring1
industry_codestring924
agglvl_codestring75
size_codestring0
yearstring1991
qtrstring3
disclosure_codestring-
qtrly_estabsstring3
month1_emplvlstring9
month2_emplvlstring9
month3_emplvlstring9
total_qtrly_wagesstring42081
taxable_qtrly_wagesstring0
qtrly_contributionsstring0
avg_wkly_wagestring360
lq_disclosure_codestringN
lq_qtrly_estabsstring0.50
lq_month1_emplvlstring0.06
lq_month2_emplvlstring0.06
lq_month3_emplvlstring0.06
lq_total_qtrly_wagesstring0.04
lq_taxable_qtrly_wagesstring0.00
lq_qtrly_contributionsstring0.00
lq_avg_wkly_wagestring0.70
oty_disclosure_codestringN
oty_qtrly_estabs_chgstring-1
oty_qtrly_estabs_pct_chgstring-25.0
oty_month1_emplvl_chgstring0
oty_month1_emplvl_pct_chgstring0.0
oty_month2_emplvl_chgstring0
oty_month2_emplvl_pct_chgstring0.0
oty_month3_emplvl_chgstring-1
oty_month3_emplvl_pct_chgstring-10.0
oty_total_qtrly_wages_chgstring1545
oty_total_qtrly_wages_pct_chgstring3.8
oty_taxable_qtrly_wages_chgstring0
oty_taxable_qtrly_wages_pct_chgstring0.0
oty_qtrly_contributions_chgstring0
oty_qtrly_contributions_pct_chgstring0.0
oty_avg_wkly_wage_chgstring26
oty_avg_wkly_wage_pct_chgstring7.8
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

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.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Labor