Skip to content

Commit 5bd48ba

Browse files
author
Harry Moreno
committed
Unzip adventureworks zip
* this database has been harder to maintain due to being a zipfile. Data is cheap, lets keep it unzipped.
1 parent e9f9909 commit 5bd48ba

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

73 files changed

+638414
-1
lines changed

‎adventureworks/README.md

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,6 @@
33
Commands:
44

55
```
6-
unzip data.zip -d data # this will unzip the data into the directory 'data'
76
psql -c "CREATE DATABASE \"Adventureworks\";"
87
psql -d Adventureworks < install.sql
98
```

‎adventureworks/data/AWBuildVersion.csv

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
1 12.0.1800 2014-02-20 04:26:00 2014-07-08 00:00:00

‎adventureworks/data/Address.csv

Lines changed: 19614 additions & 0 deletions
Large diffs are not rendered by default.

‎adventureworks/data/AddressType.csv

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
1 Billing {B84F78B1-4EFE-4A0E-8CB7-70E9F112F886} 2008-04-30 00:00:00
2+
2 Home {41BC2FF6-F0FC-475F-8EB9-CEC0805AA0F2} 2008-04-30 00:00:00
3+
3 Main Office {8EEEC28C-07A2-4FB9-AD0A-42D4A0BBC575} 2008-04-30 00:00:00
4+
4 Primary {24CB3088-4345-47C4-86C5-17B535133D1E} 2008-04-30 00:00:00
5+
5 Shipping {B29DA3F8-19A3-47DA-9DAA-15C84F4A83A5} 2008-04-30 00:00:00
6+
6 Archive {A67F238A-5BA2-444B-966C-0467ED9C427F} 2008-04-30 00:00:00

‎adventureworks/data/BillOfMaterials.csv

Lines changed: 2679 additions & 0 deletions
Large diffs are not rendered by default.

‎adventureworks/data/BusinessEntity.csv

Lines changed: 20777 additions & 0 deletions
Large diffs are not rendered by default.

‎adventureworks/data/BusinessEntityAddress.csv

Lines changed: 19614 additions & 0 deletions
Large diffs are not rendered by default.

‎adventureworks/data/BusinessEntityContact.csv

Lines changed: 909 additions & 0 deletions
Large diffs are not rendered by default.

‎adventureworks/data/ContactType.csv

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
1 Accounting Manager 2008-04-30 00:00:00
2+
2 Assistant Sales Agent 2008-04-30 00:00:00
3+
3 Assistant Sales Representative 2008-04-30 00:00:00
4+
4 Coordinator Foreign Markets 2008-04-30 00:00:00
5+
5 Export Administrator 2008-04-30 00:00:00
6+
6 International Marketing Manager 2008-04-30 00:00:00
7+
7 Marketing Assistant 2008-04-30 00:00:00
8+
8 Marketing Manager 2008-04-30 00:00:00
9+
9 Marketing Representative 2008-04-30 00:00:00
10+
10 Order Administrator 2008-04-30 00:00:00
11+
11 Owner 2008-04-30 00:00:00
12+
12 Owner/Marketing Assistant 2008-04-30 00:00:00
13+
13 Product Manager 2008-04-30 00:00:00
14+
14 Purchasing Agent 2008-04-30 00:00:00
15+
15 Purchasing Manager 2008-04-30 00:00:00
16+
16 Regional Account Representative 2008-04-30 00:00:00
17+
17 Sales Agent 2008-04-30 00:00:00
18+
18 Sales Associate 2008-04-30 00:00:00
19+
19 Sales Manager 2008-04-30 00:00:00
20+
20 Sales Representative 2008-04-30 00:00:00

‎adventureworks/data/CountryRegion.csv

Lines changed: 238 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,238 @@
1+
AD Andorra 2008-04-30 00:00:00
2+
AE United Arab Emirates 2008-04-30 00:00:00
3+
AF Afghanistan 2008-04-30 00:00:00
4+
AG Antigua and Barbuda 2008-04-30 00:00:00
5+
AI Anguilla 2008-04-30 00:00:00
6+
AL Albania 2008-04-30 00:00:00
7+
AM Armenia 2008-04-30 00:00:00
8+
AN Netherlands Antilles 2008-04-30 00:00:00
9+
AO Angola 2008-04-30 00:00:00
10+
AQ Antarctica 2008-04-30 00:00:00
11+
AR Argentina 2008-04-30 00:00:00
12+
AS American Samoa 2008-04-30 00:00:00
13+
AT Austria 2008-04-30 00:00:00
14+
AU Australia 2008-04-30 00:00:00
15+
AW Aruba 2008-04-30 00:00:00
16+
AZ Azerbaijan 2008-04-30 00:00:00
17+
BA Bosnia and Herzegovina 2008-04-30 00:00:00
18+
BB Barbados 2008-04-30 00:00:00
19+
BD Bangladesh 2008-04-30 00:00:00
20+
BE Belgium 2008-04-30 00:00:00
21+
BF Burkina Faso 2008-04-30 00:00:00
22+
BG Bulgaria 2008-04-30 00:00:00
23+
BH Bahrain 2008-04-30 00:00:00
24+
BI Burundi 2008-04-30 00:00:00
25+
BJ Benin 2008-04-30 00:00:00
26+
BM Bermuda 2008-04-30 00:00:00
27+
BN Brunei 2008-04-30 00:00:00
28+
BO Bolivia 2008-04-30 00:00:00
29+
BR Brazil 2008-04-30 00:00:00
30+
BS Bahamas, The 2008-04-30 00:00:00
31+
BT Bhutan 2008-04-30 00:00:00
32+
BV Bouvet Island 2008-04-30 00:00:00
33+
BW Botswana 2008-04-30 00:00:00
34+
BY Belarus 2008-04-30 00:00:00
35+
BZ Belize 2008-04-30 00:00:00
36+
CA Canada 2008-04-30 00:00:00
37+
CC Cocos (Keeling) Islands 2008-04-30 00:00:00
38+
CD Congo (DRC) 2008-04-30 00:00:00
39+
CF Central African Republic 2008-04-30 00:00:00
40+
CG Congo 2008-04-30 00:00:00
41+
CH Switzerland 2008-04-30 00:00:00
42+
CI Côte d'Ivoire 2008-04-30 00:00:00
43+
CK Cook Islands 2008-04-30 00:00:00
44+
CL Chile 2008-04-30 00:00:00
45+
CM Cameroon 2008-04-30 00:00:00
46+
CN China 2008-04-30 00:00:00
47+
CO Colombia 2008-04-30 00:00:00
48+
CR Costa Rica 2008-04-30 00:00:00
49+
CS Serbia and Montenegro 2008-04-30 00:00:00
50+
CU Cuba 2008-04-30 00:00:00
51+
CV Cape Verde 2008-04-30 00:00:00
52+
CX Christmas Island 2008-04-30 00:00:00
53+
CY Cyprus 2008-04-30 00:00:00
54+
CZ Czech Republic 2008-04-30 00:00:00
55+
DE Germany 2008-04-30 00:00:00
56+
DJ Djibouti 2008-04-30 00:00:00
57+
DK Denmark 2008-04-30 00:00:00
58+
DM Dominica 2008-04-30 00:00:00
59+
DO Dominican Republic 2008-04-30 00:00:00
60+
DZ Algeria 2008-04-30 00:00:00
61+
EC Ecuador 2008-04-30 00:00:00
62+
EE Estonia 2008-04-30 00:00:00
63+
EG Egypt 2008-04-30 00:00:00
64+
ER Eritrea 2008-04-30 00:00:00
65+
ES Spain 2008-04-30 00:00:00
66+
ET Ethiopia 2008-04-30 00:00:00
67+
FI Finland 2008-04-30 00:00:00
68+
FJ Fiji Islands 2008-04-30 00:00:00
69+
FK Falkland Islands (Islas Malvinas) 2008-04-30 00:00:00
70+
FM Micronesia 2008-04-30 00:00:00
71+
FO Faroe Islands 2008-04-30 00:00:00
72+
FR France 2008-04-30 00:00:00
73+
GA Gabon 2008-04-30 00:00:00
74+
GB United Kingdom 2008-04-30 00:00:00
75+
GD Grenada 2008-04-30 00:00:00
76+
GE Georgia 2008-04-30 00:00:00
77+
GF French Guiana 2008-04-30 00:00:00
78+
GH Ghana 2008-04-30 00:00:00
79+
GI Gibraltar 2008-04-30 00:00:00
80+
GL Greenland 2008-04-30 00:00:00
81+
GM Gambia, The 2008-04-30 00:00:00
82+
GN Guinea 2008-04-30 00:00:00
83+
GP Guadeloupe 2008-04-30 00:00:00
84+
GQ Equatorial Guinea 2008-04-30 00:00:00
85+
GR Greece 2008-04-30 00:00:00
86+
GS South Georgia and the South Sandwich Islands 2008-04-30 00:00:00
87+
GT Guatemala 2008-04-30 00:00:00
88+
GU Guam 2008-04-30 00:00:00
89+
GW Guinea-Bissau 2008-04-30 00:00:00
90+
GY Guyana 2008-04-30 00:00:00
91+
HK Hong Kong SAR 2008-04-30 00:00:00
92+
HM Heard Island and McDonald Islands 2008-04-30 00:00:00
93+
HN Honduras 2008-04-30 00:00:00
94+
HR Croatia 2008-04-30 00:00:00
95+
HT Haiti 2008-04-30 00:00:00
96+
HU Hungary 2008-04-30 00:00:00
97+
ID Indonesia 2008-04-30 00:00:00
98+
IE Ireland 2008-04-30 00:00:00
99+
IL Israel 2008-04-30 00:00:00
100+
IN India 2008-04-30 00:00:00
101+
IO British Indian Ocean Territory 2008-04-30 00:00:00
102+
IQ Iraq 2008-04-30 00:00:00
103+
IR Iran 2008-04-30 00:00:00
104+
IS Iceland 2008-04-30 00:00:00
105+
IT Italy 2008-04-30 00:00:00
106+
JM Jamaica 2008-04-30 00:00:00
107+
JO Jordan 2008-04-30 00:00:00
108+
JP Japan 2008-04-30 00:00:00
109+
KE Kenya 2008-04-30 00:00:00
110+
KG Kyrgyzstan 2008-04-30 00:00:00
111+
KH Cambodia 2008-04-30 00:00:00
112+
KI Kiribati 2008-04-30 00:00:00
113+
KM Comoros 2008-04-30 00:00:00
114+
KN Saint Kitts and Nevis 2008-04-30 00:00:00
115+
KP North Korea 2008-04-30 00:00:00
116+
KR Korea 2008-04-30 00:00:00
117+
KW Kuwait 2008-04-30 00:00:00
118+
KY Cayman Islands 2008-04-30 00:00:00
119+
KZ Kazakhstan 2008-04-30 00:00:00
120+
LA Laos 2008-04-30 00:00:00
121+
LB Lebanon 2008-04-30 00:00:00
122+
LC Saint Lucia 2008-04-30 00:00:00
123+
LI Liechtenstein 2008-04-30 00:00:00
124+
LK Sri Lanka 2008-04-30 00:00:00
125+
LR Liberia 2008-04-30 00:00:00
126+
LS Lesotho 2008-04-30 00:00:00
127+
LT Lithuania 2008-04-30 00:00:00
128+
LU Luxembourg 2008-04-30 00:00:00
129+
LV Latvia 2008-04-30 00:00:00
130+
LY Libya 2008-04-30 00:00:00
131+
MA Morocco 2008-04-30 00:00:00
132+
MC Monaco 2008-04-30 00:00:00
133+
MD Moldova 2008-04-30 00:00:00
134+
MG Madagascar 2008-04-30 00:00:00
135+
MH Marshall Islands 2008-04-30 00:00:00
136+
MK Macedonia, Former Yugoslav Republic of 2008-04-30 00:00:00
137+
ML Mali 2008-04-30 00:00:00
138+
MM Myanmar 2008-04-30 00:00:00
139+
MN Mongolia 2008-04-30 00:00:00
140+
MO Macao SAR 2008-04-30 00:00:00
141+
MP Northern Mariana Islands 2008-04-30 00:00:00
142+
MQ Martinique 2008-04-30 00:00:00
143+
MR Mauritania 2008-04-30 00:00:00
144+
MS Montserrat 2008-04-30 00:00:00
145+
MT Malta 2008-04-30 00:00:00
146+
MU Mauritius 2008-04-30 00:00:00
147+
MV Maldives 2008-04-30 00:00:00
148+
MW Malawi 2008-04-30 00:00:00
149+
MX Mexico 2008-04-30 00:00:00
150+
MY Malaysia 2008-04-30 00:00:00
151+
MZ Mozambique 2008-04-30 00:00:00
152+
NA Namibia 2008-04-30 00:00:00
153+
NC New Caledonia 2008-04-30 00:00:00
154+
NE Niger 2008-04-30 00:00:00
155+
NF Norfolk Island 2008-04-30 00:00:00
156+
NG Nigeria 2008-04-30 00:00:00
157+
NI Nicaragua 2008-04-30 00:00:00
158+
NL Netherlands 2008-04-30 00:00:00
159+
NO Norway 2008-04-30 00:00:00
160+
NP Nepal 2008-04-30 00:00:00
161+
NR Nauru 2008-04-30 00:00:00
162+
NU Niue 2008-04-30 00:00:00
163+
NZ New Zealand 2008-04-30 00:00:00
164+
OM Oman 2008-04-30 00:00:00
165+
PA Panama 2008-04-30 00:00:00
166+
PE Peru 2008-04-30 00:00:00
167+
PF French Polynesia 2008-04-30 00:00:00
168+
PG Papua New Guinea 2008-04-30 00:00:00
169+
PH Philippines 2008-04-30 00:00:00
170+
PK Pakistan 2008-04-30 00:00:00
171+
PL Poland 2008-04-30 00:00:00
172+
PM Saint Pierre and Miquelon 2008-04-30 00:00:00
173+
PN Pitcairn Islands 2008-04-30 00:00:00
174+
PR Puerto Rico 2008-04-30 00:00:00
175+
PS Palestinian Authority 2008-04-30 00:00:00
176+
PT Portugal 2008-04-30 00:00:00
177+
PW Palau 2008-04-30 00:00:00
178+
PY Paraguay 2008-04-30 00:00:00
179+
QA Qatar 2008-04-30 00:00:00
180+
RE Réunion 2008-04-30 00:00:00
181+
RO Romania 2008-04-30 00:00:00
182+
RU Russia 2008-04-30 00:00:00
183+
RW Rwanda 2008-04-30 00:00:00
184+
SA Saudi Arabia 2008-04-30 00:00:00
185+
SB Solomon Islands 2008-04-30 00:00:00
186+
SC Seychelles 2008-04-30 00:00:00
187+
SD Sudan 2008-04-30 00:00:00
188+
SE Sweden 2008-04-30 00:00:00
189+
SG Singapore 2008-04-30 00:00:00
190+
SH Saint Helena 2008-04-30 00:00:00
191+
SI Slovenia 2008-04-30 00:00:00
192+
SJ Svalbard and Jan Mayen 2008-04-30 00:00:00
193+
SK Slovakia 2008-04-30 00:00:00
194+
SL Sierra Leone 2008-04-30 00:00:00
195+
SM San Marino 2008-04-30 00:00:00
196+
SN Senegal 2008-04-30 00:00:00
197+
SO Somalia 2008-04-30 00:00:00
198+
SR Suriname 2008-04-30 00:00:00
199+
ST São Tomé and Príncipe 2008-04-30 00:00:00
200+
SV El Salvador 2008-04-30 00:00:00
201+
SY Syria 2008-04-30 00:00:00
202+
SZ Swaziland 2008-04-30 00:00:00
203+
TC Turks and Caicos Islands 2008-04-30 00:00:00
204+
TD Chad 2008-04-30 00:00:00
205+
TF French Southern and Antarctic Lands 2008-04-30 00:00:00
206+
TG Togo 2008-04-30 00:00:00
207+
TH Thailand 2008-04-30 00:00:00
208+
TJ Tajikistan 2008-04-30 00:00:00
209+
TK Tokelau 2008-04-30 00:00:00
210+
TL Timor-Leste 2008-04-30 00:00:00
211+
TM Turkmenistan 2008-04-30 00:00:00
212+
TN Tunisia 2008-04-30 00:00:00
213+
TO Tonga 2008-04-30 00:00:00
214+
TR Turkey 2008-04-30 00:00:00
215+
TT Trinidad and Tobago 2008-04-30 00:00:00
216+
TV Tuvalu 2008-04-30 00:00:00
217+
TW Taiwan 2008-04-30 00:00:00
218+
TZ Tanzania 2008-04-30 00:00:00
219+
UA Ukraine 2008-04-30 00:00:00
220+
UG Uganda 2008-04-30 00:00:00
221+
UM U.S. Minor Outlying Islands 2008-04-30 00:00:00
222+
US United States 2008-04-30 00:00:00
223+
UY Uruguay 2008-04-30 00:00:00
224+
UZ Uzbekistan 2008-04-30 00:00:00
225+
VA Vatican City 2008-04-30 00:00:00
226+
VC Saint Vincent and the Grenadine 2008-04-30 00:00:00
227+
VE Venezuela 2008-04-30 00:00:00
228+
VG Virgin Islands, British 2008-04-30 00:00:00
229+
VI Virgin Islands, U.S. 2008-04-30 00:00:00
230+
VN Vietnam 2008-04-30 00:00:00
231+
VU Vanuatu 2008-04-30 00:00:00
232+
WF Wallis and Futuna 2008-04-30 00:00:00
233+
WS Samoa 2008-04-30 00:00:00
234+
YE Yemen 2008-04-30 00:00:00
235+
YT Mayotte 2008-04-30 00:00:00
236+
ZA South Africa 2008-04-30 00:00:00
237+
ZM Zambia 2008-04-30 00:00:00
238+
ZW Zimbabwe 2008-04-30 00:00:00

0 commit comments

Comments
 (0)