Reviews of rules since 1981, the Unified Agenda since 1995, and information collection inventories.
Publisher: Office of Information and Regulatory Affairs
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| rin | string | 0503-AA54 |
| publication_id | string | 201704 |
| publication_title | string | Unified Agenda of Federal Regulatory and Deregulatory Action |
| code | string | 0503 | 0500 | 0500 |
| name | string | Office of the Secretary | Department of Agriculture | Depart |
| acronym | string | AgSEC | USDA | USDA |
| rule_title | string | National Appeals Division Procedural Rule |
| priority_category | string | Substantive, Nonsignificant |
| rin_status | string | Previously Published in The Unified Agenda |
| rule_stage | string | Completed Actions |
| cfr | string | 7 CFR part 11 |
| legal_authority | string | Pub. L. 103-354 |
| rplan_entry | string | No |
| ttbl_action | string | Withdrawn |
| ttbl_date | string | 06/28/2017 |
| rfa_required | string | No |
| small_entity | string | No |
| govt_level | string | None |
| print_paper | string | No |
| international_interest | string | No |
| rin_relation | string | Related to | Related to |
| first_name | string | Brenda |
| last_name | string | Seegars |
| title | string | Senior Policy Advisor |
| phone | string | 703 305-1164 |
| fax | string | 202 401-7752 | 202 401-7752 |
| string | margaret.ewell@nifa.usda.gov | |
| street_address | string | 3101 Park Center Drive, |
| city | string | Alexandria |
| state | string | VA |
| zip | string | 22302 |
| reinvent_govt | string | No |
| record_xml | string | <RIN_INFO> <RIN>0503-AA54</RIN> <PUBLICATION |
| source_file | string | lake/v1/executive/raw/oira-unified-agenda/2026-11-15/REGINFO |
| middle_name | string | L |
| fr_citation | string | 68 FR 23014 |
| procurement | string | Not Procurement Related |
| additional_info | string | International Impacts: This regulatory action will be likel |
| prefix | string | Dr. |
| dline_type | string | Statutory |
| dline_action_stage | string | Final |
| dline_date | string | 05/15/2011 |
| dline_desc | string | Anticipate a February publication. |
| sic_desc | string | |
| initial_public_cost | string | 0 |
| base_year | string | 2017 |
| recurring_public_cost | string | 2260000 |
| parent_rin | string | |
| suffix | string | II |
| phone_ext | string | VP |
| tdd_phone | string | 202 559-5088 |
| p | string | The National Institute of Food and Agriculture (NIFA) p |
| major | string | No |
| unfunded_mandate | string | No |
| eo_13771_designation | string | |
| federalism | string | No |
| legal_dline_overall_desc | string | Following a complaint from the Natural Resources Defense Cou |
| energy_affected | string | No |
| public_comment_url | string | www.regulations.gov |
| naics_cd | string | 11 |
| naics_desc | string | Agriculture, Forestry, Fishing and Hunting |
| further_info_url | string | www.fas.usda.gov |
| em | string | Physalis peruviana | Ceratitis capitata |
| strong | string | |
| agency_relation | string | Common |
| span | string | This rule codifies a provision of the Healthy, Hunger-Free K |
| div | string | |
| a | string | http://www.regulations.gov/#!docketDetail;D=DOD-2011-OS-0036 |
| li | string | |
| td | string | |
| sup | string | th |
| rfa_section_610_review | string | Section 610 Review |
| sub | string | |
| i | string | |
| h1 | string | |
| h2 | string | |
| pre | string | |
| s | string | |
| h3 | 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.