Courts, courthouses, appeal routes and oral argument recordings.
Publisher: Free Law Project
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| id | string | 103898 |
| date_created | string | 2026-03-28 00:31:09.793674+00 |
| date_modified | string | 2026-03-29 22:28:59.039923+00 |
| source | string | C |
| case_name_short | string | Ryan |
| case_name | string | Ryan v. Association of Apartment Owners of Waikiki Landmark |
| case_name_full | string | |
| judges | string | McKEOWN, FRIEDLAND, SUNG |
| sha1 | string | 84bdd1352f9b934ecb848d42f8aab42bbad682dd |
| download_url | string | https://www.ca9.uscourts.gov/datastore/media/2025/10/06/25-9 |
| local_path_mp3 | string | mp3/2025/10/06/ryan_v._association_of_apartment_owners_of_wa |
| local_path_original_file | string | mp3/2025/10/06/ryan_v._association_of_apartment_owners_of_wa |
| filepath_ia | string | https://archive.org/download/gov.uscourts.ca9.11-99006/gov.u |
| ia_upload_failure_count | string | 3 |
| duration | string | 1867 |
| processing_complete | string | t |
| date_blocked | string | 2016-06-29 |
| blocked | string | f |
| stt_status | string | 1 |
| stt_transcript | string | 25-9-2. Each side has 15 minutes. We don't want you to think |
| stt_source | string | 1 |
| docket_id | string | 71796406 |
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.