One row per federal case from the Integrated Database.
Publisher: Federal Judicial Center
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| id | string | 22240610 |
| date_created | string | 2018-11-21 13:14:19.30163+00 |
| date_modified | string | 2022-01-28 02:05:21.039623+00 |
| dataset_source | string | 9 |
| office | string | 3 |
| docket_number | string | 0802341 |
| origin | string | 1 |
| date_filed | string | 2008-12-01 |
| jurisdiction | string | 4 |
| nature_of_suit | string | 365 |
| title | string | 15 |
| section | string | 1332 |
| subsection | string | |
| diversity_of_residence | string | 12 |
| class_action | string | t |
| monetary_demand | string | 3400 |
| county_of_residence | string | 72127 |
| arbitration_at_filing | string | |
| arbitration_at_termination | string | |
| multidistrict_litigation_docket_number | string | 1842 |
| plaintiff | string | MARTELL-RAMOS, ET AL |
| defendant | string | EVERLIGHT CHEMICAL INDU, ET AL |
| date_transfer | string | 2017-06-05 |
| transfer_office | string | 3 |
| transfer_docket_number | string | 1702426 |
| transfer_origin | string | 1 |
| date_terminated | string | 2010-01-15 |
| termination_class_action_status | string | 3 |
| procedural_progress | string | 2 |
| disposition | string | 12 |
| nature_of_judgement | string | 0 |
| amount_received | string | 0 |
| judgment | string | 2 |
| pro_se | string | 0 |
| year_of_tape | string | 2010 |
| nature_of_offense | string | |
| version | string | |
| circuit_id | string | ca1 |
| district_id | string | prd |
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.