Liquor Control Suspensions

Establishments that have been suspended by the Liquor Control Commission. The Liquor Control Commission may impose fines on permittees and suspend or revoke liquor permits in connection with violations of Connecticut liquor control statutes or regulations. The establishments in this dataset were suspended after either: (1) a formal hearing in which the Liquor Control Commission found a violation of state liquor laws, or (2) entering into a voluntary agreement to settle allegations without a finding of fault.

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 \"ct-gov/liquor-control-suspensions-i2yq-278d\".\"liquor_control_suspensions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.