AdventureWorks2019
Sales.vStoreWithDemographics
//
Stores (including demographics) that sell Adventure Works Cycles products to consumers.
Created: Modified:
Columns
-
BusinessEntityID[int] NOT NULL
-
Name[Name] NOT NULL
-
AnnualSales[money] NULL
-
AnnualRevenue[money] NULL
-
BankName[nvarchar](50) NULL
-
BusinessType[nvarchar](5) NULL
-
YearOpened[int] NULL
-
Specialty[nvarchar](50) NULL
-
SquareFeet[int] NULL
-
Brands[nvarchar](30) NULL
-
Internet[nvarchar](30) NULL
-
NumberEmployees[int] NULL
Definition
Sample Data
BusinessEntityID
Name
AnnualSales
AnnualRevenue
BankName
BusinessType
YearOpened
Specialty
SquareFeet
Brands
Internet
NumberEmployees
292
Next-Door Bike Store
800000
80000
United Security
BM
1996
Mountain
21000
2
ISDN
13
294
Professional Sales and Service
800000
80000
International Bank
BM
1991
Touring
18000
4+
T1
14
296
Riders Company
800000
80000
Primary Bank & Reserve
BM
1999
Road
21000
2
DSL
15
298
The Bike Mechanics
800000
80000
International Security
BM
1994
Mountain
18000
2
DSL
16
300
Nationwide Supply
800000
80000
Guardian Bank
BM
1987
Touring
21000
4+
DSL
17
302
Area Bike Accessories
300000
30000
International Bank
BM
1982
Road
9000
AW
T2
8
304
Bicycle Accessories and Kits
300000
30000
Primary Bank & Reserve
BM
1990
Mountain
7000
AW
T1
9
306
Clamps & Brackets Co.
800000
80000
International Security
BM
1985
Mountain
17000
4+
DSL
10
308
Valley Bicycle Specialists
3000000
300000
Primary Bank & Reserve
OS
1979
Mountain
72000
4+
DSL
66
310
New Bikes Company
1500000
150000
International Security
OS
1974
Road
39000
4+
T1
40
312
Vinyl and Plastic Goods Corporation
1500000
150000
Primary Bank & Reserve
OS
1980
Mountain
41000
4+
DSL
43
314
Top of the Line Bikes
1500000
150000
International Bank
OS
1986
Touring
40000
4+
DSL
46
316
Fun Toys and Bikes
300000
30000
Primary Bank & Reserve
BM
1973
Touring
6000
2
DSL
2
318
Great Bikes
300000
30000
International Security
BM
1981
Mountain
10000
4+
T3
3
320
Metropolitan Sales and Rental
300000
30000
Guardian Bank
BM
1976
Road
6000
AW
T1
4
322
Irregulars Outlet
300000
30000
Primary International
BM
1984
Mountain
7000
AW
DSL
5
324
Valley Toy Store
300000
30000
Reserve Security
BM
1979
Mountain
9000
2
T1
6
326
Worthwhile Activity Store
300000
30000
United Security
BM
1987
Mountain
8000
2
DSL
7
328
Purchase Mart
1500000
150000
United Security
OS
1992
Touring
38000
3
ISDN
49
330
Major Sport Suppliers
3000000
300000
Reserve Security
OS
1998
Mountain
68000
3
DSL
52
332
Family's Favorite Bike Shop
800000
80000
Primary International
BM
1997
Mountain
21000
3
ISDN
18
334
Global Plaza
800000
80000
Reserve Security
BM
1975
Mountain
19000
3
DSL
19
336
Imported and Domestic Cycles
1000000
100000
United Security
BM
2000
Road
24000
2
T1
20
338
Systematic Sales
3000000
300000
Primary International
OS
1999
Touring
73000
4+
DSL
55
340
eCommerce Bikes
3000000
300000
Guardian Bank
OS
1999
Mountain
69000
2
DSL
58