Public Budget Database and Historical Tables, fiscal year 2027.
Publisher: Office of Management and Budget
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| agency_code | string | 001 |
| agency_name | string | Legislative Branch |
| bureau_code | string | 00 |
| bureau_name | string | Legislative Branch |
| account_code | string | 241400 |
| account_name | string | Receipts, Central fiscal operations |
| treasury_agency_code | string | 00 |
| cgac_agency_code | string | 000 |
| subfunction_code | string | 803 |
| subfunction_title | string | Central fiscal operations |
| bea_category | string | Mandatory |
| grantnongrant_split | string | Nongrant |
| on_or_off_budget | string | On-budget |
| _1962 | string | -628 |
| _1963 | string | -390 |
| _1964 | string | -469 |
| _1965 | string | -413 |
| _1966 | string | -410 |
| _1967 | string | -722 |
| _1968 | string | -464 |
| _1969 | string | -522 |
| _1970 | string | -439 |
| _1971 | string | -360 |
| _1972 | string | -343 |
| _1973 | string | -427 |
| _1974 | string | -539 |
| _1975 | string | -307 |
| _1976 | string | -287 |
| tq | string | -132 |
| _1977 | string | -429 |
| _1978 | string | -385 |
| _1979 | string | -726 |
| _1980 | string | 0 |
| _1981 | string | 0 |
| _1982 | string | 0 |
| _1983 | string | 0 |
| _1984 | string | 0 |
| _1985 | string | 0 |
| _1986 | string | 0 |
| _1987 | string | 0 |
| _1988 | string | 0 |
| _1989 | string | 0 |
| _1990 | string | 0 |
| _1991 | string | 0 |
| _1992 | string | 0 |
| _1993 | string | 0 |
| _1994 | string | 0 |
| _1995 | string | 0 |
| _1996 | string | 0 |
| _1997 | string | 0 |
| _1998 | string | 0 |
| _1999 | string | 0 |
| _2000 | string | 0 |
| _2001 | string | 0 |
| _2002 | string | 0 |
| _2003 | string | 0 |
| _2004 | string | 0 |
| _2005 | string | 0 |
| _2006 | string | 0 |
| _2007 | string | 0 |
| _2008 | string | 0 |
| _2009 | string | 0 |
| _2010 | string | 0 |
| _2011 | string | 0 |
| _2012 | string | 0 |
| _2013 | string | 0 |
| _2014 | string | 0 |
| _2015 | string | 0 |
| _2016 | string | 0 |
| _2017 | string | 0 |
| _2018 | string | 0 |
| _2019 | string | 0 |
| _2020 | string | 0 |
| _2021 | string | 0 |
| _2022 | string | 0 |
| _2023 | string | 0 |
| _2024 | string | 0 |
| _2025 | string | 0 |
| _2026 | string | 0 |
| _2027 | string | 0 |
5 more fields; select the table above to list them all.
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.