Office of Hearings and Mediation Services (OHMS) Docket Management System: Beginning 2005

The docket management system is a database of cases that have been referred to OHMS for public hearings or other action by an administrative law judge and a decision by the Commissioner of the New York State Department of Environmental Conservation. The docket contains cases that were open on or after January 1, 2005.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ny-gov/office-of-hearings-and-mediation-services-ohms-2qhq-8f6k\".\"office_of_hearings_and_mediation_services_ohms\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.