Judges, positions, education, affiliations, and their annual financial disclosures.
Publisher: Free Law Project
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| id | string | 4558608 |
| date_created | string | 2021-02-10 00:23:41.274143+00 |
| date_modified | string | 2021-02-10 00:23:41.274169+00 |
| page_number | string | 4 |
| description | string | Fidelity Cash Reserves |
| redacted | string | f |
| income_during_reporting_period_code | string | A |
| income_during_reporting_period_type | string | Int/Div |
| gross_value_code | string | K |
| gross_value_method | string | T |
| transaction_during_reporting_period | string | sell |
| transaction_date_raw | string | 12/7 |
| transaction_date | string | 2007-12-07 |
| transaction_value_code | string | J |
| transaction_gain_code | string | A |
| transaction_partner | string | name to Wyeth |
| has_inferred_values | string | f |
| financial_disclosure_id | string | 20670 |
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.