Missouri Active Alcohol License Data

State of Missouri

@usgov.state_of_missouri_missouri_active_alcohol_license_data

Table List

1 table(1.38 MB)

Table 1

@usgov.state_of_missouri_missouri_active_alcohol_license_data.table_1

1.38 MB
18942 rows
20 columns

licensee LICENSEE	dbaname DBANAME	street_number STREET NUMBER	street STREET	city CITY	state STATE	zipcode ZIPCODE	phone_number PHONE NUMBER	primary_license PRIMARY LICENSE	secondary_license SECONDARY LICENSE	primary_type PRIMARY TYPE	secondary_type SECONDARY TYPE	county COUNTY	district DISTRICT	assoc Assoc	first_name First Name	last_name Last Name	phone Phone
DOUBLE WHISKEY CIGAR LOUNGE LLC	DOUBLE WHISKEY CIGAR LOUNGE	5024C	OSAGE BEACH PKWY	OSAGE BEACH	MO	65065	5732160350	303338	304954	RBD	SBD	CAMDEN	2	MGR	TIMOTHY	LISCHWE	5732160350
MSI ST LOUIS LLC	SOGILITY ST LOUIS	1735	S RIVER ROAD STE 170	SAINT CHARLES	MO	63303	6365799615	304948	304949	RBD	SBD	ST. CHARLES	3	MGR	KYLE	BURROWS	6365799615
DISTRICT WEST EVENTS, LLC	REVERIE, THE	17089	N OUTER 40 RD	CHESTERFIELD	MO	63005	3146647680	297350	297351	RBD	SBD	ST. LOUIS CO.	3	MGR	RICHARD	NIX	3149658222
AMULET ESTATE LLC	AMULET ESTATE AND WINES	230	N FORK CRYSTAL SPRINGS RD	SAINT HELENA	CA	94574	7072004410	297155		WDS		OUT OF STATE	7	MGR	NATHANIEL	DORN	8145981509
BOONE FOODS LLC	PARK RESTAURANT	4380	NOCONA PARKWAY	COLUMBIA	MO	65201	5735541955	258482	263225	RBD	RDC5	BOONE	2	MGR	BRUCE	ODLE	3143783770
NOBUS INC	NOBUS INC	6253	DELMAR BLVD	UNIVERSITY CITY	MO	63130	3145765391	287328		RBD		ST. LOUIS CO.	3	MGR	GEORGE	KIDERA	3143239147
NEXXT TIME CAFE LLC	NEXXT TIME CAFE	10466	W FLORISSANT AVE	DELLWOOD	MO	63136	3143952509	296662	296663	RBD	SBD	ST. LOUIS CO.	3	MGR	DON	FULTZ	3142392855
DRUNKEN FISH INC., THE	612 NORTH EVENTS SPACE AND CATERING	612	N 2ND ST, LOWER LEVEL	ST. LOUIS	MO	63102	3142413474	287326	287327	RBD	SBD	ST. LOUIS CITY	3	MGR	JUANITA	ACOSTA TAVERAS	3144405615
CLEVER BARN LLC, THE	CLEVER BARN, THE	3647	JASMINE RD.	CLEVER	MO	656316358	4173502343	257730	257731	5BDW	5SBD	CHRISTIAN	5	MGR	LAURA	WALDEN	4173502343
MICHEL VINEYARDS, LP	MICHEL-SCHLUMBERGER WINE ESTATE	4155	WINE CREEK RD	HEALDSBURG	CA	95448	7074337427	297126		WDS		OUT OF STATE	7	MGR	DAVID	SHULL	3038087228


CREATE TABLE table_1 (
  "licensee" VARCHAR,
  "dbaname" VARCHAR,
  "street_number" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "phone_number" BIGINT,
  "primary_license" BIGINT,
  "secondary_license" BIGINT,
  "primary_type" VARCHAR,
  "secondary_type" VARCHAR,
  "county" VARCHAR,
  "district" BIGINT,
  "subdist" BIGINT,
  "latlng" VARCHAR,
  "assoc" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "phone" BIGINT
);