-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstats.data
429 lines (429 loc) · 116 KB
/
stats.data
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
| cd_dep_employed_count | 1920800 | 7 | 0 | 0 | 6 | 7683200 |
| d_day_name | 73049 | 7 | 0 | Friday | Wednesday | 521779 |
| d_following_holiday | 73049 | 2 | 0 | N | Y | 73049 |
| d_same_day_ly | 73049 | 72450 | 0 | 2414657 | 2487705 | 292196 |
| w_city | 20 | 12 | 0 | Fairview | Shiloh | 183 |
| w_street_type | 20 | 14 | 0 | | Wy | 71 |
| cs_call_center_sk | 1439980416 | 42 | 7199711 | 1 | 42 | 11519843328 |
| cs_net_paid_inc_ship | 1439980416 | 2505826 | 0 | 0.00 | 43956.00 | 5759921664 |
| cs_sales_price | 1439980416 | 29306 | 7200276 | 0.00 | 300.00 | 5759921664 |
| cc_class | 42 | 3 | 0 | large | small | 226 |
| cc_country | 42 | 1 | 0 | United States | United States | 546 |
| cc_county | 42 | 16 | 0 | Barrow County | Williamson County | 627 |
| cc_mkt_class | 42 | 36 | 0 | A bit narrow forms matter animals. Consist | Yesterday new men can make moreov | 1465 |
| cc_sq_ft | 42 | 31 | 0 | -1890660328 | 2122480316 | 168 |
| cc_state | 42 | 14 | 0 | FL | WV | 84 |
| inv_warehouse_sk | 783000000 | 20 | 0 | 1 | 20 | 6264000000 |
| cr_refunded_addr_sk | 143996756 | 6015811 | 2881609 | 1 | 6000000 | 1151974048 |
| cr_refunded_cash | 143996756 | 1107525 | 2879192 | 0.00 | 26955.24 | 575987024 |
| cr_refunded_cdemo_sk | 143996756 | 1916366 | 2881314 | 1 | 1920800 | 1151974048 |
| cr_return_amt_inc_tax | 143996756 | 1544502 | 2881886 | 0.00 | 30418.06 | 575987024 |
| cr_returning_addr_sk | 143996756 | 6015811 | 2883215 | 1 | 6000000 | 1151974048 |
| hd_buy_potential | 7200 | 6 | 0 | 0-500 | Unknown | 54000 |
| ca_address_id | 6000000 | 5984931 | 0 | AAAAAAAAAAAAABAA | AAAAAAAAPPPPPEAA | 96000000 |
| ca_address_sk | 6000000 | 6015811 | 0 | 1 | 6000000 | 48000000 |
| ca_country | 6000000 | 2 | 0 | | United States | 75661794 |
| ca_location_type | 6000000 | 4 | 0 | | single family | 52372545 |
| ca_street_number | 6000000 | 1002 | 0 | | 999 | 16837336 |
| ca_suite_number | 6000000 | 76 | 0 | | Suite Y | 45911575 |
| cp_catalog_page_id | 30000 | 29953 | 0 | AAAAAAAAAAABAAAA | AAAAAAAAPPPGAAAA | 480000 |
| i_rec_end_date | 300000 | 3 | 150000 | 1999-10-27 | 2001-10-26 | 1200000 |
| wr_refunded_addr_sk | 71997522 | 6015811 | 3239971 | 1 | 6000000 | 575980176 |
| wr_reversed_charge | 71997522 | 692680 | 3239546 | 0.00 | 23194.77 | 287990088 |
| web_state | 54 | 18 | 0 | AL | WV | 108 |
| p_end_date_sk | 1500 | 683 | 18 | 2450113 | 2450967 | 12000 |
| ws_bill_hdemo_sk | 720000376 | 7251 | 180139 | 1 | 7200 | 5760003008 |
| ws_ext_ship_cost | 720000376 | 567477 | 180084 | 0.00 | 14950.00 | 2880001504 |
| ws_ship_addr_sk | 720000376 | 6015811 | 179848 | 1 | 6000000 | 5760003008 |
| ws_ship_mode_sk | 720000376 | 20 | 180017 | 1 | 20 | 5760003008 |
| ws_warehouse_sk | 720000376 | 20 | 180105 | 1 | 20 | 5760003008 |
| s_company_name | 1002 | 2 | 0 | | Unknown | 6965 |
| s_gmt_offset | 1002 | 4 | 6 | -8.00 | -5.00 | 4008 |
| s_manager | 1002 | 739 | 0 | | Zane Clifton | 12649 |
| s_street_number | 1002 | 521 | 0 | | 999 | 2874 |
| t_meal_time | 86400 | 4 | 0 | | lunch | 248400 |
| t_time | 86400 | 86684 | 0 | 0 | 86399 | 345600 |
| wp_creation_date_sk | 3000 | 199 | 33 | 2450604 | 2450815 | 24000 |
| wp_customer_sk | 3000 | 713 | 2147 | 9522 | 11995685 | 24000 |
| wp_max_ad_count | 3000 | 5 | 31 | 0 | 4 | 12000 |
| wp_url | 3000 | 2 | 0 | | http://www.foo.com | 53406 |
| sr_refunded_cash | 287999764 | 928470 | 10081294 | 0.00 | 18173.96 | 1151999056 |
| sr_return_tax | 287999764 | 117247 | 10081332 | 0.00 | 1682.04 | 1151999056 |
| ss_customer_sk | 2879987999 | 12157481 | 129590766 | 1 | 12000000 | 23039903992 |
| ss_hdemo_sk | 2879987999 | 7251 | 129594559 | 1 | 7200 | 23039903992 |
| ss_store_sk | 2879987999 | 499 | 129572050 | 1 | 1000 | 23039903992 |
| sm_ship_mode_id | 20 | 20 | 0 | AAAAAAAAABAAAAAA | AAAAAAAAPAAAAAAA | 320 |
| sm_ship_mode_sk | 20 | 20 | 0 | 1 | 20 | 160 |
| c_first_name | 12000000 | 5140 | 0 | | Zulma | 67593278 |
| c_first_sales_date_sk | 12000000 | 3644 | 419856 | 2448998 | 2452648 | 96000000 |
| c_first_shipto_date_sk | 12000000 | 3644 | 420769 | 2449028 | 2452678 | 96000000 |
| cd_dep_college_count | 1920800 | 7 | 0 | 0 | 6 | 7683200 |
| d_dow | 73049 | 7 | 0 | 0 | 6 | 292196 |
| d_fy_quarter_seq | 73049 | 801 | 0 | 1 | 801 | 292196 |
| d_qoy | 73049 | 4 | 0 | 1 | 4 | 292196 |
| d_quarter_seq | 73049 | 801 | 0 | 1 | 801 | 292196 |
| w_street_name | 20 | 20 | 0 | | Wilson Elm | 176 |
| w_suite_number | 20 | 18 | 0 | | Suite X | 150 |
| cs_bill_cdemo_sk | 1439980416 | 1916366 | 7202134 | 1 | 1920800 | 11519843328 |
| cs_bill_hdemo_sk | 1439980416 | 7251 | 7198837 | 1 | 7200 | 11519843328 |
| cs_ext_ship_cost | 1439980416 | 573238 | 7202537 | 0.00 | 14994.00 | 5759921664 |
| cc_name | 42 | 21 | 0 | California | Pacific Northwest_2 | 572 |
| cc_street_name | 42 | 21 | 0 | 1st | Willow | 356 |
| cc_zip | 42 | 19 | 0 | 18605 | 98048 | 210 |
| inv_quantity_on_hand | 783000000 | 1006 | 39153758 | 0 | 1000 | 3132000000 |
| cr_catalog_page_sk | 143996756 | 17005 | 2882502 | 1 | 25207 | 1151974048 |
| hd_income_band_sk | 7200 | 20 | 0 | 1 | 20 | 57600 |
| cp_description | 30000 | 30141 | 0 | | Youngsters worry both workers. Fascinating characters take cheap never alive studies. Direct, old | 2215634 |
| i_item_id | 300000 | 150851 | 0 | AAAAAAAAAAAABAAA | AAAAAAAAPPPPBAAA | 4800000 |
| wr_account_credit | 71997522 | 683955 | 3241972 | 0.00 | 23166.33 | 287990088 |
| wr_net_loss | 71997522 | 815608 | 3240573 | 0.50 | 15887.84 | 287990088 |
| wr_return_amt | 71997522 | 808311 | 3238405 | 0.00 | 29191.00 | 287990088 |
| wr_return_amt_inc_tax | 71997522 | 1359913 | 3239765 | 0.00 | 30393.01 | 287990088 |
| wr_return_quantity | 71997522 | 100 | 3238643 | 1 | 100 | 287990088 |
| wr_returning_addr_sk | 71997522 | 6015811 | 3239658 | 1 | 6000000 | 575980176 |
| wr_returning_customer_sk | 71997522 | 12119220 | 3237281 | 1 | 12000000 | 575980176 |
| web_mkt_desc | 54 | 38 | 0 | Acres see else children. Mutual too | Windows increase to a differences. Other parties might in | 3473 |
| web_mkt_id | 54 | 6 | 1 | 1 | 6 | 216 |
| web_rec_end_date | 54 | 3 | 27 | 1999-08-16 | 2001-08-15 | 216 |
| web_site_id | 54 | 27 | 0 | AAAAAAAAABAAAAAA | AAAAAAAAPBAAAAAA | 864 |
| web_street_type | 54 | 20 | 0 | Ave | Wy | 208 |
| p_channel_demo | 1500 | 2 | 0 | | N | 1479 |
| p_channel_details | 1500 | 1490 | 0 | | Young, valuable companies watch walls. Payments can flour | 59126 |
| p_channel_event | 1500 | 2 | 0 | | N | 1482 |
| p_discount_active | 1500 | 2 | 0 | | N | 1473 |
| p_promo_sk | 1500 | 1489 | 0 | 1 | 1500 | 12000 |
| p_purpose | 1500 | 2 | 0 | | Unknown | 10374 |
| ws_bill_cdemo_sk | 720000376 | 1916366 | 179788 | 1 | 1920800 | 5760003008 |
| ws_sold_date_sk | 720000376 | 1820 | 179921 | 2450816 | 2452642 | 5760003008 |
| ws_web_site_sk | 720000376 | 54 | 179930 | 1 | 54 | 5760003008 |
| s_city | 1002 | 55 | 0 | | Woodlawn | 9238 |
| s_company_id | 1002 | 1 | 7 | 1 | 1 | 4008 |
| s_county | 1002 | 28 | 0 | | Ziebach County | 14291 |
| s_geography_class | 1002 | 2 | 0 | | Unknown | 6972 |
| s_hours | 1002 | 4 | 0 | | 8AM-8AM | 7088 |
| s_store_id | 1002 | 501 | 0 | AAAAAAAAAABAAAAA | AAAAAAAAPPBAAAAA | 16032 |
| s_zip | 1002 | 354 | 0 | | 99454 | 4975 |
| t_am_pm | 86400 | 2 | 0 | AM | PM | 172800 |
| t_minute | 86400 | 60 | 0 | 0 | 59 | 345600 |
| wp_web_page_id | 3000 | 1501 | 0 | AAAAAAAAAABAAAAA | AAAAAAAAPPKAAAAA | 48000 |
| wp_web_page_sk | 3000 | 2984 | 0 | 1 | 3000 | 24000 |
| sr_return_amt | 287999764 | 671228 | 10080055 | 0.00 | 19434.00 | 1151999056 |
| sr_returned_date_sk | 287999764 | 2010 | 10079607 | 2450820 | 2452822 | 2303998112 |
| ss_ext_tax | 2879987999 | 149597 | 129588732 | 0.00 | 1797.48 | 11519951996 |
| c_current_cdemo_sk | 12000000 | 1913901 | 419895 | 1 | 1920800 | 96000000 |
| c_customer_id | 12000000 | 11921032 | 0 | AAAAAAAAAAAAABAA | AAAAAAAAPPPPPKAA | 192000000 |
| d_current_day | 73049 | 1 | 0 | N | N | 73049 |
| d_current_month | 73049 | 2 | 0 | N | Y | 73049 |
| d_date | 73049 | 73250 | 0 | 1900-01-02 | 2100-01-01 | 292196 |
| d_moy | 73049 | 12 | 0 | 1 | 12 | 292196 |
| w_gmt_offset | 20 | 3 | 1 | -7.00 | -5.00 | 80 |
| w_warehouse_sk | 20 | 20 | 0 | 1 | 20 | 160 |
| w_warehouse_sq_ft | 20 | 19 | 1 | 73065 | 977787 | 80 |
| cs_ext_sales_price | 1439980416 | 1100662 | 7199625 | 0.00 | 29943.00 | 5759921664 |
| cs_ext_wholesale_cost | 1439980416 | 393180 | 7199876 | 1.00 | 10000.00 | 5759921664 |
| cs_item_sk | 1439980416 | 295433 | 0 | 1 | 300000 | 11519843328 |
| cs_net_paid_inc_tax | 1439980416 | 2422238 | 7200702 | 0.00 | 32376.27 | 5759921664 |
| cs_ship_date_sk | 1439980416 | 1933 | 7200707 | 2450817 | 2452744 | 11519843328 |
| cs_warehouse_sk | 1439980416 | 20 | 7200688 | 1 | 20 | 11519843328 |
| cc_division | 42 | 6 | 0 | 1 | 6 | 168 |
| cc_division_name | 42 | 6 | 0 | able | pri | 164 |
| cc_manager | 42 | 28 | 0 | Alden Snyder | Wayne Ray | 519 |
| cc_rec_start_date | 42 | 4 | 0 | 1998-01-01 | 2002-01-01 | 168 |
| cr_call_center_sk | 143996756 | 42 | 2881668 | 1 | 42 | 1151974048 |
| cr_net_loss | 143996756 | 911034 | 2881704 | 0.50 | 16095.08 | 575987024 |
| cr_refunded_customer_sk | 143996756 | 12156363 | 2879017 | 1 | 12000000 | 1151974048 |
| cr_refunded_hdemo_sk | 143996756 | 7251 | 2882107 | 1 | 7200 | 1151974048 |
| cr_returning_customer_sk | 143996756 | 12157481 | 2879023 | 1 | 12000000 | 1151974048 |
| ca_gmt_offset | 6000000 | 6 | 180219 | -10.00 | -5.00 | 24000000 |
| i_color | 300000 | 93 | 0 | | yellow | 1610293 |
| i_manufact | 300000 | 1004 | 0 | | pripripri | 3379693 |
| i_product_name | 300000 | 294994 | 0 | | pripripripripriought | 6849199 |
| wr_returned_time_sk | 71997522 | 87677 | 3238574 | 0 | 86399 | 575980176 |
| web_manager | 54 | 40 | 0 | | William Young | 658 |
| web_mkt_class | 54 | 40 | 0 | | Written, political plans show to the models. T | 1822 |
| web_rec_start_date | 54 | 4 | 2 | 1997-08-16 | 2001-08-16 | 216 |
| web_street_number | 54 | 36 | 0 | | 983 | 154 |
| p_channel_catalog | 1500 | 2 | 0 | | N | 1482 |
| p_promo_id | 1500 | 1519 | 0 | AAAAAAAAAABAAAAA | AAAAAAAAPPEAAAAA | 24000 |
| ws_bill_customer_sk | 720000376 | 12103729 | 179817 | 1 | 12000000 | 5760003008 |
| ws_list_price | 720000376 | 29396 | 180053 | 1.00 | 300.00 | 2880001504 |
| ws_sales_price | 720000376 | 29288 | 180005 | 0.00 | 300.00 | 2880001504 |
| ws_ship_hdemo_sk | 720000376 | 7251 | 179824 | 1 | 7200 | 5760003008 |
| s_closed_date_sk | 1002 | 163 | 729 | 2450820 | 2451313 | 8016 |
| s_division_id | 1002 | 1 | 6 | 1 | 1 | 4008 |
| s_market_desc | 1002 | 765 | 0 | | Yesterday left factors handle continuing co | 57638 |
| s_market_id | 1002 | 10 | 8 | 1 | 10 | 4008 |
| s_state | 1002 | 22 | 0 | | WV | 1994 |
| s_store_sk | 1002 | 988 | 0 | 1 | 1002 | 8016 |
| s_street_name | 1002 | 549 | 0 | | Woodland Oak | 8580 |
| wp_access_date_sk | 3000 | 101 | 31 | 2452548 | 2452648 | 24000 |
| wp_char_count | 3000 | 1883 | 42 | 303 | 8523 | 12000 |
| sr_addr_sk | 287999764 | 6015811 | 10082311 | 1 | 6000000 | 2303998112 |
| sr_return_time_sk | 287999764 | 32660 | 10082805 | 28799 | 61199 | 2303998112 |
| sr_store_sk | 287999764 | 499 | 10081871 | 1 | 1000 | 2303998112 |
| ss_coupon_amt | 2879987999 | 1161208 | 129609101 | 0.00 | 19778.00 | 11519951996 |
| ss_sales_price | 2879987999 | 19780 | 129598061 | 0.00 | 200.00 | 11519951996 |
| c_birth_country | 12000000 | 211 | 0 | | ZIMBABWE | 100750845 |
| c_birth_month | 12000000 | 12 | 419629 | 1 | 12 | 48000000 |
| c_customer_sk | 12000000 | 12157481 | 0 | 1 | 12000000 | 96000000 |
| c_email_address | 12000000 | 11642077 | 0 | | [email protected] | 318077849 |
| c_last_review_date_sk | 12000000 | 366 | 419900 | 2452283 | 2452648 | 96000000 |
| c_preferred_cust_flag | 12000000 | 3 | 0 | | Y | 11580510 |
| dv_version | 1 | 1 | 0 | 3.2.0 | 3.2.0 | 5 |
| cd_purchase_estimate | 1920800 | 20 | 0 | 500 | 10000 | 7683200 |
| r_reason_id | 65 | 65 | 0 | AAAAAAAAABAAAAAA | AAAAAAAAPDAAAAAA | 1040 |
| r_reason_sk | 65 | 65 | 0 | 1 | 65 | 520 |
| d_current_week | 73049 | 1 | 0 | N | N | 73049 |
| d_first_dom | 73049 | 2410 | 0 | 2415021 | 2488070 | 292196 |
| d_fy_year | 73049 | 202 | 0 | 1900 | 2100 | 292196 |
| d_last_dom | 73049 | 2419 | 0 | 2415020 | 2488372 | 292196 |
| d_month_seq | 73049 | 2398 | 0 | 0 | 2400 | 292196 |
| d_quarter_name | 73049 | 799 | 0 | 1900Q1 | 2100Q1 | 438294 |
| w_county | 20 | 14 | 0 | Bronx County | Ziebach County | 291 |
| w_street_number | 20 | 19 | 0 | | 957 | 54 |
| w_warehouse_name | 20 | 20 | 0 | | Therefore urg | 307 |
| cs_ext_discount_amt | 1439980416 | 1100115 | 7201054 | 0.00 | 29982.00 | 5759921664 |
| cs_net_paid_inc_ship_tax | 1439980416 | 3312360 | 0 | 0.00 | 46593.36 | 5759921664 |
| cs_promo_sk | 1439980416 | 1489 | 7202844 | 1 | 1500 | 11519843328 |
| cc_call_center_id | 42 | 21 | 0 | AAAAAAAAABAAAAAA | AAAAAAAAPBAAAAAA | 672 |
| cc_employees | 42 | 30 | 0 | 69020 | 6879074 | 168 |
| cc_suite_number | 42 | 18 | 0 | Suite 0 | Suite W | 326 |
| cr_item_sk | 143996756 | 295433 | 0 | 1 | 300000 | 1151974048 |
| cr_reason_sk | 143996756 | 65 | 2881950 | 1 | 65 | 1151974048 |
| cr_return_ship_cost | 143996756 | 483467 | 2883436 | 0.00 | 14273.28 | 575987024 |
| cr_ship_mode_sk | 143996756 | 20 | 2879879 | 1 | 20 | 1151974048 |
| cr_store_credit | 143996756 | 802237 | 2880469 | 0.00 | 23215.15 | 575987024 |
| ca_city | 6000000 | 977 | 0 | | Zion | 52096290 |
| ca_state | 6000000 | 52 | 0 | | WY | 11640128 |
| ca_street_name | 6000000 | 8173 | 0 | | Woodland Woodland | 50697257 |
| ca_street_type | 6000000 | 21 | 0 | | Wy | 24441630 |
| cp_catalog_number | 30000 | 109 | 297 | 1 | 109 | 120000 |
| cp_catalog_page_number | 30000 | 279 | 294 | 1 | 277 | 120000 |
| cp_catalog_page_sk | 30000 | 30439 | 0 | 1 | 30000 | 240000 |
| cp_start_date_sk | 30000 | 91 | 286 | 2450815 | 2453005 | 120000 |
| i_rec_start_date | 300000 | 4 | 784 | 1997-10-27 | 2001-10-27 | 1200000 |
| i_units | 300000 | 22 | 0 | | Unknown | 1253652 |
| wr_refunded_hdemo_sk | 71997522 | 7251 | 3238545 | 1 | 7200 | 575980176 |
| wr_return_ship_cost | 71997522 | 451263 | 3239048 | 0.00 | 14352.10 | 287990088 |
| wr_returned_date_sk | 71997522 | 2188 | 3239259 | 2450819 | 2453002 | 575980176 |
| wr_returning_cdemo_sk | 71997522 | 1916366 | 3239192 | 1 | 1920800 | 575980176 |
| web_suite_number | 54 | 38 | 0 | Suite 100 | Suite Y | 430 |
| p_start_date_sk | 1500 | 685 | 23 | 2450096 | 2450915 | 12000 |
| ws_coupon_amt | 720000376 | 1505315 | 179933 | 0.00 | 28824.00 | 2880001504 |
| ws_ext_wholesale_cost | 720000376 | 393180 | 180060 | 1.00 | 10000.00 | 2880001504 |
| ws_net_paid_inc_ship | 720000376 | 2414838 | 0 | 0.00 | 44263.00 | 2880001504 |
| ws_ship_date_sk | 720000376 | 1952 | 180011 | 2450817 | 2452762 | 5760003008 |
| ws_web_page_sk | 720000376 | 2984 | 179732 | 1 | 3000 | 5760003008 |
| s_country | 1002 | 2 | 0 | | United States | 12961 |
| s_store_name | 1002 | 11 | 0 | | pri | 3916 |
| t_second | 86400 | 60 | 0 | 0 | 59 | 345600 |
| t_sub_shift | 86400 | 4 | 0 | afternoon | night | 597600 |
| wp_image_count | 3000 | 7 | 26 | 1 | 7 | 12000 |
| wp_type | 3000 | 8 | 0 | | welcome | 18867 |
| sr_customer_sk | 287999764 | 12157481 | 10081624 | 1 | 12000000 | 2303998112 |
| sr_hdemo_sk | 287999764 | 7251 | 10083275 | 1 | 7200 | 2303998112 |
| ss_addr_sk | 2879987999 | 6015811 | 129589799 | 1 | 6000000 | 23039903992 |
| ss_item_sk | 2879987999 | 295433 | 0 | 1 | 300000 | 23039903992 |
| ss_quantity | 2879987999 | 100 | 129584258 | 1 | 100 | 11519951996 |
| ss_ticket_number | 2879987999 | 238830448 | 0 | 1 | 240000000 | 23039903992 |
| ss_wholesale_cost | 2879987999 | 9905 | 129590273 | 1.00 | 100.00 | 11519951996 |
| sm_type | 20 | 6 | 0 | EXPRESS | TWO DAY | 150 |
| c_current_addr_sk | 12000000 | 5243359 | 0 | 3 | 6000000 | 96000000 |
| c_last_name | 12000000 | 4990 | 0 | | Zuniga | 70991730 |
| dv_cmdline_args | 1 | 1 | 0 | -SCALE 1000 -PARALLEL 64 -CHILD 1 -TERMINATE N -DIR /mnt/datadisk0/tpcds1t/tpcds-data | -SCALE 1000 -PARALLEL 64 -CHILD 1 -TERMINATE N -DIR /mnt/datadisk0/tpcds1t/tpcds-data | 86 |
| d_current_quarter | 73049 | 2 | 0 | N | Y | 73049 |
| d_date_sk | 73049 | 73042 | 0 | 2415022 | 2488070 | 584392 |
| d_holiday | 73049 | 2 | 0 | N | Y | 73049 |
| w_country | 20 | 1 | 0 | United States | United States | 260 |
| w_state | 20 | 13 | 0 | AL | TN | 40 |
| cs_bill_addr_sk | 1439980416 | 6015811 | 7199539 | 1 | 6000000 | 11519843328 |
| cs_bill_customer_sk | 1439980416 | 12157481 | 7201919 | 1 | 12000000 | 11519843328 |
| cs_net_paid | 1439980416 | 1809875 | 7197668 | 0.00 | 29943.00 | 5759921664 |
| cs_ship_addr_sk | 1439980416 | 6015811 | 7198232 | 1 | 6000000 | 11519843328 |
| cs_ship_mode_sk | 1439980416 | 20 | 7201083 | 1 | 20 | 11519843328 |
| cs_sold_date_sk | 1439980416 | 1835 | 7203326 | 2450815 | 2452654 | 11519843328 |
| cs_sold_time_sk | 1439980416 | 87677 | 7201329 | 0 | 86399 | 11519843328 |
| cs_wholesale_cost | 1439980416 | 9905 | 7201098 | 1.00 | 100.00 | 5759921664 |
| cc_company_name | 42 | 6 | 0 | able | pri | 160 |
| cc_market_manager | 42 | 35 | 0 | Cesar Allen | William Larsen | 524 |
| cc_mkt_id | 42 | 6 | 0 | 1 | 6 | 168 |
| cc_street_type | 42 | 11 | 0 | Avenue | Way | 184 |
| cr_return_tax | 143996756 | 149828 | 2881611 | 0.00 | 2511.58 | 575987024 |
| cr_returning_cdemo_sk | 143996756 | 1916366 | 2880543 | 1 | 1920800 | 1151974048 |
| cr_returning_hdemo_sk | 143996756 | 7251 | 2882692 | 1 | 7200 | 1151974048 |
| cr_reversed_charge | 143996756 | 802509 | 2881215 | 0.00 | 24033.84 | 575987024 |
| cr_warehouse_sk | 143996756 | 20 | 2882192 | 1 | 20 | 1151974048 |
| hd_demo_sk | 7200 | 7251 | 0 | 1 | 7200 | 57600 |
| hd_vehicle_count | 7200 | 6 | 0 | -1 | 4 | 28800 |
| ca_zip | 6000000 | 9253 | 0 | | 99981 | 29097610 |
| ib_income_band_sk | 20 | 20 | 0 | 1 | 20 | 160 |
| cp_type | 30000 | 4 | 0 | | quarterly | 227890 |
| i_brand | 300000 | 714 | 0 | | univunivamalg #9 | 4834917 |
| i_formulation | 300000 | 224757 | 0 | | yellow98911509228741 | 5984460 |
| i_item_desc | 300000 | 217721 | 0 | | Youngsters used to save quite colour | 30093342 |
| wr_fee | 71997522 | 9958 | 3238926 | 0.50 | 100.00 | 287990088 |
| wr_item_sk | 71997522 | 295433 | 0 | 1 | 300000 | 575980176 |
| wr_reason_sk | 71997522 | 65 | 3238897 | 1 | 65 | 575980176 |
| wr_refunded_customer_sk | 71997522 | 12117831 | 3242433 | 1 | 12000000 | 575980176 |
| web_city | 54 | 31 | 0 | | Woodlawn | 491 |
| web_close_date_sk | 54 | 18 | 10 | 2441265 | 2446218 | 432 |
| web_company_id | 54 | 6 | 0 | 1 | 6 | 216 |
| web_company_name | 54 | 7 | 0 | | pri | 203 |
| web_county | 54 | 25 | 0 | | Williamson County | 762 |
| web_name | 54 | 10 | 0 | | site_8 | 312 |
| web_open_date_sk | 54 | 27 | 1 | 2450373 | 2450807 | 432 |
| p_channel_dmail | 1500 | 3 | 0 | | Y | 1483 |
| p_channel_press | 1500 | 2 | 0 | | N | 1481 |
| p_channel_radio | 1500 | 2 | 0 | | N | 1479 |
| p_cost | 1500 | 1 | 18 | 1000.00 | 1000.00 | 12000 |
| ws_ext_tax | 720000376 | 211413 | 179695 | 0.00 | 2682.90 | 2880001504 |
| ws_item_sk | 720000376 | 295433 | 0 | 1 | 300000 | 5760003008 |
| ws_net_paid | 720000376 | 1749360 | 179970 | 0.00 | 29810.00 | 2880001504 |
| ws_net_paid_inc_ship_tax | 720000376 | 3224829 | 0 | 0.00 | 46004.19 | 2880001504 |
| ws_net_paid_inc_tax | 720000376 | 2354996 | 179972 | 0.00 | 32492.90 | 2880001504 |
| ws_order_number | 720000376 | 60401176 | 0 | 1 | 60000000 | 5760003008 |
| ws_quantity | 720000376 | 100 | 179781 | 1 | 100 | 2880001504 |
| ws_ship_cdemo_sk | 720000376 | 1916366 | 180290 | 1 | 1920800 | 5760003008 |
| ws_sold_time_sk | 720000376 | 87677 | 179980 | 0 | 86399 | 5760003008 |
| s_street_type | 1002 | 21 | 0 | | Wy | 4189 |
| wp_autogen_flag | 3000 | 3 | 0 | | Y | 2962 |
| wp_rec_start_date | 3000 | 4 | 29 | 1997-09-03 | 2001-09-03 | 12000 |
| sr_net_loss | 287999764 | 714210 | 10080716 | 0.50 | 10776.08 | 1151999056 |
| sr_return_amt_inc_tax | 287999764 | 1259368 | 10076879 | 0.00 | 20454.63 | 1151999056 |
| sr_return_quantity | 287999764 | 100 | 10082815 | 1 | 100 | 1151999056 |
| sr_return_ship_cost | 287999764 | 355844 | 10081927 | 0.00 | 9767.34 | 1151999056 |
| sr_reversed_charge | 287999764 | 700618 | 10085976 | 0.00 | 17339.42 | 1151999056 |
| ss_net_paid_inc_tax | 2879987999 | 1681767 | 129609050 | 0.00 | 21769.48 | 11519951996 |
| c_birth_day | 12000000 | 31 | 420361 | 1 | 31 | 48000000 |
| cd_credit_rating | 1920800 | 4 | 0 | Good | Unknown | 13445600 |
| cd_demo_sk | 1920800 | 1916366 | 0 | 1 | 1920800 | 15366400 |
| cd_dep_count | 1920800 | 7 | 0 | 0 | 6 | 7683200 |
| cd_education_status | 1920800 | 7 | 0 | 2 yr Degree | Unknown | 18384800 |
| cd_gender | 1920800 | 2 | 0 | F | M | 1920800 |
| cd_marital_status | 1920800 | 5 | 0 | D | W | 1920800 |
| d_date_id | 73049 | 72907 | 0 | AAAAAAAAAAAAFCAA | AAAAAAAAPPPPECAA | 1168784 |
| d_fy_week_seq | 73049 | 10448 | 0 | 1 | 10436 | 292196 |
| d_year | 73049 | 202 | 0 | 1900 | 2100 | 292196 |
| w_warehouse_id | 20 | 20 | 0 | AAAAAAAAABAAAAAA | AAAAAAAAPAAAAAAA | 320 |
| cs_ext_list_price | 1439980416 | 1160303 | 7199542 | 1.00 | 30000.00 | 5759921664 |
| cs_ext_tax | 1439980416 | 215267 | 7200412 | 0.00 | 2673.27 | 5759921664 |
| cs_quantity | 1439980416 | 100 | 7202885 | 1 | 100 | 5759921664 |
| cs_ship_cdemo_sk | 1439980416 | 1916366 | 7200151 | 1 | 1920800 | 11519843328 |
| cs_ship_customer_sk | 1439980416 | 12157481 | 7201507 | 1 | 12000000 | 11519843328 |
| cc_company | 42 | 6 | 0 | 1 | 6 | 168 |
| cc_mkt_desc | 42 | 33 | 0 | Arms increase controversial, present so | Young tests could buy comfortable, local users; o | 2419 |
| cc_open_date_sk | 42 | 21 | 0 | 2450794 | 2451146 | 168 |
| cc_rec_end_date | 42 | 3 | 21 | 2000-01-01 | 2001-12-31 | 168 |
| cr_order_number | 143996756 | 93476424 | 0 | 2 | 160000000 | 1151974048 |
| cr_return_amount | 143996756 | 882831 | 2880424 | 0.00 | 28805.04 | 575987024 |
| cr_returned_date_sk | 143996756 | 2108 | 0 | 2450821 | 2452924 | 1151974048 |
| ib_upper_bound | 20 | 20 | 0 | 10000 | 200000 | 80 |
| cp_department | 30000 | 2 | 0 | | DEPARTMENT | 297110 |
| cp_end_date_sk | 30000 | 97 | 302 | 2450844 | 2453186 | 120000 |
| i_brand_id | 300000 | 951 | 763 | 1001001 | 10016017 | 1200000 |
| i_category | 300000 | 11 | 0 | | Women | 1766742 |
| i_class_id | 300000 | 16 | 722 | 1 | 16 | 1200000 |
| i_item_sk | 300000 | 295433 | 0 | 1 | 300000 | 2400000 |
| i_manufact_id | 300000 | 1005 | 761 | 1 | 1000 | 1200000 |
| i_wholesale_cost | 300000 | 7243 | 740 | 0.02 | 89.49 | 1200000 |
| wr_refunded_cdemo_sk | 71997522 | 1916366 | 3240352 | 1 | 1920800 | 575980176 |
| wr_return_tax | 71997522 | 137392 | 3237729 | 0.00 | 2551.16 | 287990088 |
| wr_returning_hdemo_sk | 71997522 | 7251 | 3238239 | 1 | 7200 | 575980176 |
| wr_web_page_sk | 71997522 | 2984 | 3240387 | 1 | 3000 | 575980176 |
| web_class | 54 | 2 | 0 | | Unknown | 371 |
| web_zip | 54 | 32 | 0 | 14593 | 99431 | 270 |
| p_channel_email | 1500 | 2 | 0 | | N | 1480 |
| p_item_sk | 1500 | 1467 | 19 | 184 | 299990 | 12000 |
| p_promo_name | 1500 | 11 | 0 | | pri | 5896 |
| ws_ext_discount_amt | 720000376 | 1093513 | 179851 | 0.00 | 29982.00 | 2880001504 |
| ws_ext_list_price | 720000376 | 1160303 | 179866 | 1.00 | 30000.00 | 2880001504 |
| ws_wholesale_cost | 720000376 | 9905 | 179834 | 1.00 | 100.00 | 2880001504 |
| s_market_manager | 1002 | 732 | 0 | | Zane Perez | 12823 |
| s_number_employees | 1002 | 101 | 8 | 200 | 300 | 4008 |
| s_rec_end_date | 1002 | 3 | 501 | 1999-03-13 | 2001-03-12 | 4008 |
| s_rec_start_date | 1002 | 4 | 7 | 1997-03-13 | 2001-03-13 | 4008 |
| s_suite_number | 1002 | 76 | 0 | | Suite Y | 7866 |
| t_hour | 86400 | 24 | 0 | 0 | 23 | 345600 |
| t_shift | 86400 | 3 | 0 | first | third | 460800 |
| wp_link_count | 3000 | 24 | 27 | 2 | 25 | 12000 |
| wp_rec_end_date | 3000 | 3 | 1500 | 1999-09-03 | 2001-09-02 | 12000 |
| sr_cdemo_sk | 287999764 | 1916366 | 10076902 | 1 | 1920800 | 2303998112 |
| sr_item_sk | 287999764 | 295433 | 0 | 1 | 300000 | 2303998112 |
| ss_cdemo_sk | 2879987999 | 1916366 | 129602155 | 1 | 1920800 | 23039903992 |
| ss_ext_discount_amt | 2879987999 | 1161208 | 129609101 | 0.00 | 19778.00 | 11519951996 |
| ss_ext_wholesale_cost | 2879987999 | 393180 | 129595018 | 1.00 | 10000.00 | 11519951996 |
| ss_list_price | 2879987999 | 19640 | 129597020 | 1.00 | 200.00 | 11519951996 |
| ss_net_paid | 2879987999 | 1288646 | 129599407 | 0.00 | 19972.00 | 11519951996 |
| ss_sold_date_sk | 2879987999 | 1820 | 129600843 | 2450816 | 2452642 | 23039903992 |
| ss_sold_time_sk | 2879987999 | 47252 | 129593012 | 28800 | 75599 | 23039903992 |
| sm_carrier | 20 | 20 | 0 | AIRBORNE | ZOUROS | 133 |
| c_birth_year | 12000000 | 69 | 419584 | 1924 | 1992 | 48000000 |
| c_login | 12000000 | 1 | 0 | | | 0 |
| c_salutation | 12000000 | 7 | 0 | | Sir | 37544445 |
| r_reason_desc | 65 | 64 | 0 | Did not fit | unauthoized purchase | 848 |
| d_current_year | 73049 | 2 | 0 | N | Y | 73049 |
| d_dom | 73049 | 31 | 0 | 1 | 31 | 292196 |
| d_same_day_lq | 73049 | 72231 | 0 | 2414930 | 2487978 | 292196 |
| d_week_seq | 73049 | 10448 | 0 | 1 | 10436 | 292196 |
| d_weekend | 73049 | 2 | 0 | N | Y | 73049 |
| w_zip | 20 | 18 | 0 | 19231 | 89275 | 100 |
| cs_catalog_page_sk | 1439980416 | 17005 | 7199032 | 1 | 25207 | 11519843328 |
| cs_coupon_amt | 1439980416 | 1578778 | 7198116 | 0.00 | 28730.00 | 5759921664 |
| cs_list_price | 1439980416 | 29396 | 7201549 | 1.00 | 300.00 | 5759921664 |
| cs_net_profit | 1439980416 | 2058398 | 0 | -10000.00 | 19962.00 | 5759921664 |
| cs_order_number | 1439980416 | 159051824 | 0 | 1 | 160000000 | 11519843328 |
| cs_ship_hdemo_sk | 1439980416 | 7251 | 7201542 | 1 | 7200 | 11519843328 |
| cc_call_center_sk | 42 | 42 | 0 | 1 | 42 | 336 |
| cc_city | 42 | 17 | 0 | Antioch | Spring Hill | 386 |
| cc_closed_date_sk | 42 | 0 | 42 | NULL | NULL | 168 |
| cc_gmt_offset | 42 | 4 | 0 | -8.00 | -5.00 | 168 |
| cc_hours | 42 | 3 | 0 | 8AM-12AM | 8AM-8AM | 300 |
| cc_street_number | 42 | 21 | 0 | 38 | 999 | 120 |
| cc_tax_percentage | 42 | 12 | 0 | 0.00 | 0.12 | 168 |
| inv_date_sk | 783000000 | 261 | 0 | 2450815 | 2452635 | 6264000000 |
| inv_item_sk | 783000000 | 295433 | 0 | 1 | 300000 | 6264000000 |
| cr_fee | 143996756 | 9958 | 2882168 | 0.50 | 100.00 | 575987024 |
| cr_return_quantity | 143996756 | 100 | 2878774 | 1 | 100 | 575987024 |
| cr_returned_time_sk | 143996756 | 87677 | 0 | 0 | 86399 | 1151974048 |
| hd_dep_count | 7200 | 10 | 0 | 0 | 9 | 28800 |
| ca_county | 6000000 | 1825 | 0 | | Ziebach County | 81254984 |
| ib_lower_bound | 20 | 20 | 0 | 0 | 190001 | 80 |
| i_category_id | 300000 | 10 | 766 | 1 | 10 | 1200000 |
| i_class | 300000 | 100 | 0 | | womens watch | 2331199 |
| i_container | 300000 | 2 | 0 | | Unknown | 2094652 |
| i_current_price | 300000 | 9685 | 775 | 0.09 | 99.99 | 1200000 |
| i_manager_id | 300000 | 100 | 744 | 1 | 100 | 1200000 |
| i_size | 300000 | 8 | 0 | | small | 1296134 |
| wr_order_number | 71997522 | 42383708 | 0 | 1 | 60000000 | 575980176 |
| wr_refunded_cash | 71997522 | 955369 | 3240493 | 0.00 | 26992.92 | 287990088 |
| web_country | 54 | 2 | 0 | | United States | 689 |
| web_gmt_offset | 54 | 4 | 1 | -8.00 | -5.00 | 216 |
| web_market_manager | 54 | 46 | 0 | | Zachery Oneil | 691 |
| web_site_sk | 54 | 54 | 0 | 1 | 54 | 432 |
| web_street_name | 54 | 53 | 0 | | Wilson Ridge | 471 |
| web_tax_percentage | 54 | 13 | 1 | 0.00 | 0.12 | 216 |
| p_channel_tv | 1500 | 2 | 0 | | N | 1481 |
| p_response_targe | 1500 | 1 | 27 | 1 | 1 | 6000 |
| ws_bill_addr_sk | 720000376 | 6015742 | 179648 | 1 | 6000000 | 5760003008 |
| ws_ext_sales_price | 720000376 | 1091003 | 180023 | 0.00 | 29810.00 | 2880001504 |
| ws_net_profit | 720000376 | 2014057 | 0 | -10000.00 | 19840.00 | 2880001504 |
| ws_promo_sk | 720000376 | 1489 | 180016 | 1 | 1500 | 5760003008 |
| ws_ship_customer_sk | 720000376 | 12074547 | 179966 | 1 | 12000000 | 5760003008 |
| s_division_name | 1002 | 2 | 0 | | Unknown | 6965 |
| s_floor_space | 1002 | 752 | 6 | 5002549 | 9997773 | 4008 |
| s_tax_precentage | 1002 | 12 | 8 | 0.00 | 0.11 | 4008 |
| t_time_id | 86400 | 85663 | 0 | AAAAAAAAAAAABAAA | AAAAAAAAPPPPAAAA | 1382400 |
| t_time_sk | 86400 | 87677 | 0 | 0 | 86399 | 691200 |
| sr_fee | 287999764 | 9958 | 10081860 | 0.50 | 100.00 | 1151999056 |
| sr_reason_sk | 287999764 | 65 | 10087936 | 1 | 65 | 2303998112 |
| sr_store_credit | 287999764 | 698161 | 10077188 | 0.00 | 17792.48 | 1151999056 |
| sr_ticket_number | 287999764 | 168770768 | 0 | 1 | 240000000 | 2303998112 |
| ss_ext_list_price | 2879987999 | 770971 | 129593800 | 1.00 | 20000.00 | 11519951996 |
| ss_ext_sales_price | 2879987999 | 754248 | 129589177 | 0.00 | 19972.00 | 11519951996 |
| ss_net_profit | 2879987999 | 1497362 | 129572933 | -10000.00 | 9986.00 | 11519951996 |
| ss_promo_sk | 2879987999 | 1489 | 129597096 | 1 | 1500 | 23039903992 |
| sm_code | 20 | 4 | 0 | AIR | SURFACE | 87 |
| sm_contract | 20 | 20 | 0 | 2mM8l | yVfotg7Tio3MVhBg6Bkn | 252 |
| c_current_hdemo_sk | 12000000 | 7251 | 418736 | 1 | 7200 | 96000000 |
| dv_create_date | 1 | 1 | 0 | 2023-07-06 | 2023-07-06 | 4 |
| dv_create_time | 1 | 1 | 0 | 2017-05-13 00:00:00 | 2017-05-13 00:00:00 | 8 |