Consumer Services Mediated Complaints

<b>NOTE:</b> This dataset reflects data as of 7/21/2023. The Department of Consumer and Worker Protection (DCWP) is working on an updated version of this dataset.

This dataset features consumer complaints against businesses that were mediated by the DCWP Consumer Services Division during the last and current calendar years. It excludes complaints that may have ongoing legal investigations.

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 \"cityofnewyork-us/consumer-services-mediated-complaints-nre2-6m2s\".\"consumer_services_mediated_complaints\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.