NYSgptData LibraryConnectPricing

Federal cases integrated database

One row per federal case from the Integrated Database.

10.3MRecords
1Tables
39Fields
CurrentYears

Publisher: Federal Judicial Center

Try it

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

Tables
Fields in fjc_integrated_database
FieldTypeExample
idstring22240610
date_createdstring2018-11-21 13:14:19.30163+00
date_modifiedstring2022-01-28 02:05:21.039623+00
dataset_sourcestring9
officestring3
docket_numberstring0802341
originstring1
date_filedstring2008-12-01
jurisdictionstring4
nature_of_suitstring365
titlestring15
sectionstring1332
subsectionstring
diversity_of_residencestring12
class_actionstringt
monetary_demandstring3400
county_of_residencestring72127
arbitration_at_filingstring
arbitration_at_terminationstring
multidistrict_litigation_docket_numberstring1842
plaintiffstringMARTELL-RAMOS, ET AL
defendantstringEVERLIGHT CHEMICAL INDU, ET AL
date_transferstring2017-06-05
transfer_officestring3
transfer_docket_numberstring1702426
transfer_originstring1
date_terminatedstring2010-01-15
termination_class_action_statusstring3
procedural_progressstring2
dispositionstring12
nature_of_judgementstring0
amount_receivedstring0
judgmentstring2
pro_sestring0
year_of_tapestring2010
nature_of_offensestring
versionstring
circuit_idstringca1
district_idstringprd
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 Courts