Warehouse And Retail Sales

Montgomery County of Maryland

@usgov.montgomery_county_of_maryland_warehouse_and_retail_sales

Table List

1 table(4.15 MB)

Table 1

@usgov.montgomery_county_of_maryland_warehouse_and_retail_sales.table_1

4.15 MB
307645 rows
9 columns

year YEAR	month MONTH	supplier SUPPLIER	item_code ITEM CODE	item_description ITEM DESCRIPTION	item_type ITEM TYPE	retail_sales RETAIL SALES	retail_transfers RETAIL TRANSFERS	warehouse_sales WAREHOUSE SALES
2020	1	REPUBLIC NATIONAL DISTRIBUTING CO	100009	BOOTLEG RED - 750ML	WINE			2
2020	1	PWSWN INC	100024	MOMENT DE PLAISIR - 750ML	WINE		1	4
2020	1	RELIABLE CHURCHILL LLLP	1001	S SMITH ORGANIC PEAR CIDER - 18.7OZ	BEER			1
2020	1	LANTERNA DISTRIBUTORS INC	100145	SCHLINK HAUS KABINETT - 750ML	WINE			1
2020	1	DIONYSOS IMPORTS INC	100293	SANTORINI GAVALA WHITE - 750ML	WINE	0.82
2020	1	KYSELA PERE ET FILS LTD	100641	CORTENOVA VENETO P/GRIG - 750ML	WINE	2.76		6
2020	1	SANTA MARGHERITA USA INC	100749	SANTA MARGHERITA P/GRIG ALTO - 375ML	WINE	0.08	1	1
2020	1	BROWN-FORMAN BEVERAGES WORLDWIDE	1008	JACK DANIELS COUNTRY COCKTAIL SOUTHERN PEACH - 10.OZ-NR	BEER			2
2020	1	JIM BEAM BRANDS CO	10103	KNOB CREEK BOURBON 9YR - 100P - 375ML	LIQUOR	6.41	4
2020	1	INTERNATIONAL CELLARS LLC	101117	KSARA CAB - 750ML	WINE	0.33	1	2


CREATE TABLE table_1 (
  "year" BIGINT,
  "month" BIGINT,
  "supplier" VARCHAR,
  "item_code" VARCHAR,
  "item_description" VARCHAR,
  "item_type" VARCHAR,
  "retail_sales" DOUBLE,
  "retail_transfers" DOUBLE,
  "warehouse_sales" DOUBLE
);