State of Connecticut

Close
Author
Open Data Hub
Description
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.
Category
Business
Tags
liquor control, suspensions, liquor control commission
Rating
Current value: 0 out of 5
Data Provided By
Department of Consumer Protection
Source Link
http://www.ct.gov/DCP/site/default.asp
License
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Click-to-view-placard
click_to_view_placard
Business
business
Credential
credential
Suspended-through-and-including
suspended_through_and_including
Start-date-of-suspension
start_date_of_suspension
Address
address
Town
town

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.