NYSgptData LibraryConnectPricing

Income by county

Returns and amounts by county and income class.

1MRecords
9Tables
1,082Fields
CurrentYears

Publisher: Internal Revenue Service

Try it

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

Tables
Fields in soi_county_county
FieldTypeExample
statefipsstring01
statestringAL
countyfipsstring000
countynamestringAlabama
agi_stubstring1
n1string25120.0000
mars1string14000.0000
mars2string9140.0000
mars4string1110.0000
prepstring17260.0000
n2string38890.0000
numdepstring5970.0000
total_vitastring350.0000
vitastring210.0000
tcestring140.0000
a00100string-1652811.000
n02650string19010.0000
a02650string-1629814.000
n00200string5580.0000
a00200string174030.0000
n00300string7720.0000
a00300string34953.0000
n00600string4690.0000
a00600string37293.0000
n00650string4260.0000
a00650string24552.0000
n00700string830.0000
a00700string1812.0000
n00900string9800.0000
a00900string-120502.0000
n01000string6580.0000
a01000string77697.0000
n01400string2040.0000
a01400string26122.0000
n01700string3270.0000
a01700string41494.0000
schfstring2620.0000
n02300string210.0000
a02300string743.0000
n02500string50.0000
a02500string273.0000
n26270string4560.0000
a26270string-379629.0000
n02900string5570.0000
a02900string22997.0000
n03220string80.0000
a03220string21.0000
n03300string0.0000
a03300string0.0000
n03270string1610.0000
a03270string8312.0000
n03150string130.0000
a03150string659.0000
n03210string700.0000
a03210string779.0000
n03230string890.0000
a03230string3224.0000
n03240string0.0000
a03240string0.0000
n04470string0.0000
a04470string0.0000
a00101string0.0000
n18425string0.0000
a18425string0.0000
n18450string0.0000
a18450string0.0000
n18500string0.0000
a18500string0.0000
n18300string0.0000
a18300string0.0000
n19300string0.0000
a19300string0.0000
n19700string0.0000
a19700string0.0000
n04800string0.0000
a04800string0.0000
n05800string450.0000
a05800string371.0000
n09600string30.0000
a09600string274.0000

128 more fields; select the table above to list them all.

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 Tax Statistics