SQL Schema Explorer by Tim Abell

sqlite-chinook

Invoice Data Analysis

Limited to most common 100 values per table

InvoiceId CustomerId InvoiceDate BillingAddress BillingCity BillingState BillingCountry BillingPostalCode Total

InvoiceId

Value Count
1 1
2 1
3 1
4 1
5 1
6 1
7 1
8 1
9 1
10 1
11 1
12 1
13 1
14 1
15 1
16 1
17 1
18 1
19 1
20 1
21 1
22 1
23 1
24 1
25 1
26 1
27 1
28 1
29 1
30 1
31 1
32 1
33 1
34 1
35 1
36 1
37 1
38 1
39 1
40 1
41 1
42 1
43 1
44 1
45 1
46 1
47 1
48 1
49 1
50 1
51 1
52 1
53 1
54 1
55 1
56 1
57 1
58 1
59 1
60 1
61 1
62 1
63 1
64 1
65 1
66 1
67 1
68 1
69 1
70 1
71 1
72 1
73 1
74 1
75 1
76 1
77 1
78 1
79 1
80 1
81 1
82 1
83 1
84 1
85 1
86 1
87 1
88 1
89 1
90 1
91 1
92 1
93 1
94 1
95 1
96 1
97 1
98 1
99 1
100 1

CustomerId

Value Count
1 7
2 7
3 7
4 7
5 7
6 7
7 7
8 7
9 7
10 7
11 7
12 7
13 7
14 7
15 7
16 7
17 7
18 7
19 7
20 7
21 7
22 7
23 7
24 7
25 7
26 7
27 7
28 7
29 7
30 7
31 7
32 7
33 7
34 7
35 7
36 7
37 7
38 7
39 7
40 7
41 7
42 7
43 7
44 7
45 7
46 7
47 7
48 7
49 7
50 7
51 7
52 7
53 7
54 7
55 7
56 7
57 7
58 7
59 6

InvoiceDate

Value Count
2009-02-01 00:00:00 +0000 UTC 2
2009-03-04 00:00:00 +0000 UTC 2
2009-04-04 00:00:00 +0000 UTC 2
2009-05-05 00:00:00 +0000 UTC 2
2009-06-05 00:00:00 +0000 UTC 2
2009-07-06 00:00:00 +0000 UTC 2
2009-08-06 00:00:00 +0000 UTC 2
2009-09-06 00:00:00 +0000 UTC 2
2009-10-07 00:00:00 +0000 UTC 2
2009-11-07 00:00:00 +0000 UTC 2
2009-12-08 00:00:00 +0000 UTC 2
2010-01-08 00:00:00 +0000 UTC 2
2010-02-08 00:00:00 +0000 UTC 2
2010-03-11 00:00:00 +0000 UTC 2
2010-04-11 00:00:00 +0000 UTC 2
2010-05-12 00:00:00 +0000 UTC 2
2010-06-12 00:00:00 +0000 UTC 2
2010-07-13 00:00:00 +0000 UTC 2
2010-08-13 00:00:00 +0000 UTC 2
2010-09-13 00:00:00 +0000 UTC 2
2010-10-14 00:00:00 +0000 UTC 2
2010-11-14 00:00:00 +0000 UTC 2
2010-12-15 00:00:00 +0000 UTC 2
2011-01-15 00:00:00 +0000 UTC 2
2011-02-15 00:00:00 +0000 UTC 2
2011-03-18 00:00:00 +0000 UTC 2
2011-04-18 00:00:00 +0000 UTC 2
2011-05-19 00:00:00 +0000 UTC 2
2011-06-19 00:00:00 +0000 UTC 2
2011-07-20 00:00:00 +0000 UTC 2
2011-08-20 00:00:00 +0000 UTC 2
2011-09-20 00:00:00 +0000 UTC 2
2011-10-21 00:00:00 +0000 UTC 2
2011-11-21 00:00:00 +0000 UTC 2
2011-12-22 00:00:00 +0000 UTC 2
2012-01-22 00:00:00 +0000 UTC 2
2012-02-22 00:00:00 +0000 UTC 2
2012-03-24 00:00:00 +0000 UTC 2
2012-04-24 00:00:00 +0000 UTC 2
2012-05-25 00:00:00 +0000 UTC 2
2012-06-25 00:00:00 +0000 UTC 2
2012-07-26 00:00:00 +0000 UTC 2
2012-08-26 00:00:00 +0000 UTC 2
2012-09-26 00:00:00 +0000 UTC 2
2012-10-27 00:00:00 +0000 UTC 2
2012-11-27 00:00:00 +0000 UTC 2
2012-12-28 00:00:00 +0000 UTC 2
2013-01-28 00:00:00 +0000 UTC 2
2013-02-28 00:00:00 +0000 UTC 2
2013-03-31 00:00:00 +0000 UTC 2
2013-05-01 00:00:00 +0000 UTC 2
2013-06-01 00:00:00 +0000 UTC 2
2013-07-02 00:00:00 +0000 UTC 2
2013-08-02 00:00:00 +0000 UTC 2
2013-09-02 00:00:00 +0000 UTC 2
2013-10-03 00:00:00 +0000 UTC 2
2013-11-03 00:00:00 +0000 UTC 2
2013-12-04 00:00:00 +0000 UTC 2
2009-01-01 00:00:00 +0000 UTC 1
2009-01-02 00:00:00 +0000 UTC 1
2009-01-03 00:00:00 +0000 UTC 1
2009-01-06 00:00:00 +0000 UTC 1
2009-01-11 00:00:00 +0000 UTC 1
2009-01-19 00:00:00 +0000 UTC 1
2009-02-02 00:00:00 +0000 UTC 1
2009-02-03 00:00:00 +0000 UTC 1
2009-02-06 00:00:00 +0000 UTC 1
2009-02-11 00:00:00 +0000 UTC 1
2009-02-19 00:00:00 +0000 UTC 1
2009-03-05 00:00:00 +0000 UTC 1
2009-03-06 00:00:00 +0000 UTC 1
2009-03-09 00:00:00 +0000 UTC 1
2009-03-14 00:00:00 +0000 UTC 1
2009-03-22 00:00:00 +0000 UTC 1
2009-04-05 00:00:00 +0000 UTC 1
2009-04-06 00:00:00 +0000 UTC 1
2009-04-09 00:00:00 +0000 UTC 1
2009-04-14 00:00:00 +0000 UTC 1
2009-04-22 00:00:00 +0000 UTC 1
2009-05-06 00:00:00 +0000 UTC 1
2009-05-07 00:00:00 +0000 UTC 1
2009-05-10 00:00:00 +0000 UTC 1
2009-05-15 00:00:00 +0000 UTC 1
2009-05-23 00:00:00 +0000 UTC 1
2009-06-06 00:00:00 +0000 UTC 1
2009-06-07 00:00:00 +0000 UTC 1
2009-06-10 00:00:00 +0000 UTC 1
2009-06-15 00:00:00 +0000 UTC 1
2009-06-23 00:00:00 +0000 UTC 1
2009-07-07 00:00:00 +0000 UTC 1
2009-07-08 00:00:00 +0000 UTC 1
2009-07-11 00:00:00 +0000 UTC 1
2009-07-16 00:00:00 +0000 UTC 1
2009-07-24 00:00:00 +0000 UTC 1
2009-08-07 00:00:00 +0000 UTC 1
2009-08-08 00:00:00 +0000 UTC 1
2009-08-11 00:00:00 +0000 UTC 1
2009-08-16 00:00:00 +0000 UTC 1
2009-08-24 00:00:00 +0000 UTC 1
2009-09-07 00:00:00 +0000 UTC 1

BillingAddress

Value Count
1 Infinite Loop 7
1 Microsoft Way 7
1033 N Park Ave 7
11, Place Bellecour 7
110 Raeburn Pl 7
113 Lupus St 7
12,Community Centre 7
120 S Orange Ave 7
1498 rue Bélanger 7
1600 Amphitheatre Parkway 7
162 E Superior Street 7
194A Chain Lake Drive 7
202 Hoxton Street 7
2211 W Berry Street 7
230 Elgin Street 7
3 Chatham Street 7
302 S 700 E 7
307 Macacha Güemes 7
319 N. Frances Street 7
4, Rue Milton 7
421 Bourke Street 7
5112 48 Street 7
541 Del Medio Avenue 7
627 Broadway 7
68, Rue Jouvence 7
69 Salem Street 7
696 Osborne Street 7
700 W Pender Street 7
796 Dundas Street West 7
8, Rue Hanovre 7
801 W 4th Street 7
8210 111 ST NW 7
9, Place Louis Barthou 7
Av. Brigadeiro Faria Lima, 2170 7
Av. Paulista, 2022 7
Barbarossastraße 19 7
Berger Straße 10 7
C/ San Bernardo 85 7
Calle Lira, 198 7
Celsiusg. 9 7
Erzsébet krt. 58. 7
Grétrystraat 63 7
Klanova 9/506 7
Lijnbaansgracht 120bg 7
Ordynacka 10 7
Porthaninkatu 9 7
Praça Pio X, 119 7
Qe 7 Bloco G 7
Rilská 3174/6 7
Rotenturmstraße 4, 1010 Innere Stadt 7
Rua Dr. Falcão Filho, 155 7
Rua da Assunção 53 7
Rua dos Campeões Europeus de Viena, 4350 7
Sønder Boulevard 51 7
Tauentzienstraße 8 7
Theodor-Heuss-Straße 34 7
Ullevålsveien 14 7
Via Degli Scipioni, 43 7
3,Raj Bhavan Road 6

BillingCity

Value Count
Berlin 14
London 14
Mountain View 14
Paris 14
Prague 14
São Paulo 14
Amsterdam 7
Bordeaux 7
Boston 7
Brasília 7
Brussels 7
Budapest 7
Buenos Aires 7
Chicago 7
Copenhagen 7
Cupertino 7
Delhi 7
Dijon 7
Dublin 7
Edinburgh 7
Edmonton 7
Fort Worth 7
Frankfurt 7
Halifax 7
Helsinki 7
Lisbon 7
Lyon 7
Madison 7
Madrid 7
Montréal 7
New York 7
Orlando 7
Oslo 7
Ottawa 7
Porto 7
Redmond 7
Reno 7
Rio de Janeiro 7
Rome 7
Salt Lake City 7
Santiago 7
Sidney 7
Stockholm 7
Stuttgart 7
São José dos Campos 7
Toronto 7
Tucson 7
Vancouver 7
Vienne 7
Warsaw 7
Winnipeg 7
Yellowknife 7
Bangalore 6

BillingState

Value Count
[null] 202
CA 21
SP 21
ON 14
AB 7
AZ 7
BC 7
DF 7
Dublin 7
FL 7
IL 7
MA 7
MB 7
NS 7
NSW 7
NT 7
NV 7
NY 7
QC 7
RJ 7
RM 7
TX 7
UT 7
VV 7
WA 7
WI 7

BillingCountry

Value Count
USA 91
Canada 56
Brazil 35
France 35
Germany 28
United Kingdom 21
Czech Republic 14
Portugal 14
India 13
Argentina 7
Australia 7
Austria 7
Belgium 7
Chile 7
Denmark 7
Finland 7
Hungary 7
Ireland 7
Italy 7
Netherlands 7
Norway 7
Poland 7
Spain 7
Sweden 7

BillingPostalCode

Value Count
[null] 28
00-358 7
00192 7
00530 7
01007-010 7
01310-200 7
0171 7
1000 7
10012-2612 7
1010 7
1016 7
10779 7
10789 7
110017 7
1106 7
11230 7
12227-000 7
14300 7
14700 7
1720 7
20040-020 7
2010 7
21000 7
2113 7
28015 7
32801 7
33000 7
53703 7
60316 7
60611 7
69002 7
70174 7
71020-677 7
75002 7
75009 7
76110 7
84102 7
85719 7
89503 7
94040-111 7
94043-1351 7
95014 7
98052-8300 7
B3S 1C5 7
EH4 1HH 7
H-1073 7
H2G 1A7 7
K2P 1L7 7
M6J 1V1 7
N1 5LH 7
R3L 2B9 7
SW1V 3EN 7
T6G 2C7 7
V6C 1G8 7
X1A 1N6 7
560001 6

Total

Value Count
1.98 111
3.96 57
5.94 56
0.99 55
8.91 54
13.86 49
3.98 5
1.99 4
7.96 2
10.91 2
15.86 2
16.86 2
18.86 2
21.86 2
2.98 1
6.94 1
8.94 1
9.91 1
11.94 1
14.91 1
17.91 1
23.86 1
25.86 1
^ top