SQL Schema Explorer by Tim Abell

sqlite-chinook

Track Data Analysis

Limited to most common 100 values per table

TrackId Name AlbumId MediaTypeId GenreId Composer Milliseconds Bytes UnitPrice

TrackId

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

Name

Value Count
2 Minutes To Midnight 5
Hallowed Be Thy Name 5
Iron Maiden 5
The Number Of The Beast 5
The Trooper 5
Wrathchild 5
Fear Of The Dark 4
Running Free 4
Sanctuary 4
The Evil That Men Do 4
Afraid To Shoot Strangers 3
Be Quick Or Be Dead 3
Believe 3
Can I Play With Madness 3
Collision 3
From Here To Eternity 3
Heaven Can Wait 3
I Can't Quit You Baby 3
Intro 3
Midnight 3
Release 3
Revelations 3
Run To The Hills 3
Smoke On The Water 3
Snowblind 3
Stairway To Heaven 3
Tailgunner 3
The Clairvoyant 3
War Pigs 3
Wasting Love 3
Whole Lotta Love 3
A Cor Do Sol 2
A Estrada 2
A Paz 2
A Sombra Da Maldade 2
Acelerou 2
Aces High 2
All I Want Is You 2
All My Love 2
Ando Meio Desligado 2
Angel 2
Angel Of Harlem 2
Animal 2
Babylon 2
Banditismo Por Uma Questa 2
Before You Accuse Me 2
Beth 2
Black 2
Black Dog 2
Black Sabbath 2
Blood Brothers 2
Branch Closing 2
Brasil 2
Brave New World 2
Breakfast In Bed 2
Breed 2
Caleidoscópio 2
Carolina 2
Celebration Day 2
Changes 2
Come Back 2
Comin' Home 2
Communication Breakdown 2
Company Man 2
Coroné Antonio Bento 2
Crazy Train 2
Creeping Death 2
Daughter 2
Dazed And Confused 2
Dazed and Confused 2
Desire 2
Dezesseis 2
Die With Your Boots On 2
Do You Love Me 2
Don't Look Back 2
Drain You 2
Dream Of Mirrors 2
Drifter 2
Drão 2
Elderly Woman Behind The Counter In A Small Town 2
Enter Sandman 2
Eruption 2
Firmamento 2
Flying High Again 2
Garota De Ipanema 2
Ghost Of The Navigator 2
Gimme Some Truth 2
Go 2
Goin' Blind 2
Going To California 2
Gone 2
Good Golly Miss Molly 2
Gostava Tanto De Você 2
Gypsy 2
Harvester Of Sorrow 2
Heartbreaker 2
Helpless 2
Homecoming 2
How Many More Times 2
I Can't Explain 2

AlbumId

Value Count
141 57
23 34
73 30
229 26
230 25
251 25
83 24
231 24
253 24
24 23
228 23
255 23
51 22
224 22
250 22
39 21
167 21
37 20
54 20
55 20
115 20
221 20
227 19
248 19
258 19
21 18
72 18
102 18
145 18
146 18
202 18
211 18
213 18
18 17
26 17
33 17
34 17
36 17
120 17
162 17
163 17
185 17
193 17
203 17
237 17
243 17
259 17
261 17
67 16
84 16
91 16
125 16
140 16
149 16
169 16
178 16
184 16
190 16
194 16
201 16
225 16
5 15
52 15
56 15
57 15
76 15
86 15
126 15
139 15
160 15
165 15
180 15
195 15
218 15
219 15
222 15
223 15
234 15
247 15
8 14
10 14
27 14
29 14
30 14
32 14
41 14
42 14
45 14
47 14
53 14
71 14
75 14
78 14
85 14
92 14
122 14
124 14
142 14
143 14
151 14

MediaTypeId

Value Count
1 3034
2 237
3 214
5 11
4 7

GenreId

Value Count
1 1297
7 579
3 374
4 332
2 130
19 93
6 81
24 74
21 64
14 61
8 58
9 48
10 43
23 40
17 35
15 30
13 28
16 28
20 26
12 24
22 17
11 15
18 13
5 12
25 1

Composer

Value Count
[null] 978
Steve Harris 80
U2 44
Jagger/Richards 35
Billy Corgan 31
Kurt Cobain 26
Bill Berry-Peter Buck-Mike Mills-Michael Stipe 25
The Tea Party 24
Chico Science 23
Chris Cornell 23
Gilberto Gil 23
Miles Davis 23
Titãs 22
Billie Joe Armstrong -Words Green Day -Music 20
J.C. Fogerty 20
Renato Russo 20
Anthony Kiedis/Chad Smith/Flea/John Frusciante 19
Herbert Vianna 19
Chris Robinson/Rich Robinson 18
J. C. Fogerty 17
Vários 17
Anthony Kiedis, Flea, John Frusciante, and Chad Smith 16
Jimi Hendrix 16
R.E.M. 16
Jimmy Page, Robert Plant 15
Van Halen 15
Audioslave/Chris Cornell 14
Brian Eno, Bono, Adam Clayton, The Edge & Larry Mullen Jnr. 14
G M Sumner 14
Geddy Lee And Alex Lifeson/Geddy Lee And Neil Peart/Rush 14
João Suplicy 14
Alanis Morissette & Glenn Ballard 13
Clarke/Kilmister/Taylor 13
Pete Townshend 13
Robert Plant 13
Bono, The Edge, Adam Clayton, and Larry Mullen 12
Bono/Clayton, Adam/Mullen Jr., Larry/The Edge 12
Cornell, Commerford, Morello, Wilk 12
Dave Abbruzzese/Eddie Vedder/Jeff Ament/Mike McCready/Stone Gossard 12
Dave Kushner, Duff, Matt Sorum, Scott Weiland & Slash 12
Djavan 12
Eddie Vedder 12
Ian Gillan, Roger Glover, Jon Lord, Steve Morse, Ian Paice 12
Jimmy Page, Robert Plant, Charlie Jones, Michael Lee 12
Jimmy Page/Robert Plant 12
Mônica Marianno 12
Red Hot Chili Peppers 12
Adam Clayton, Bono, Larry Mullen & The Edge 11
Adam Clayton, Bono, Larry Mullen, The Edge 11
Bill Berry/Michael Stipe/Mike Mills/Peter Buck 11
Bob Rock/James Hetfield/Kirk Hammett/Lars Ulrich 11
Caetano Veloso e Gilberto Gil 11
Foo Fighters 11
James Hetfield, Lars Ulrich 11
Samuel Rosa 11
Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 11
Angus Young, Malcolm Young, Brian Johnson 10
Caetano Veloso 10
Dave Grohl, Taylor Hawkins, Nate Mendel, Chris Shiflett 10
Dave Grohl, Taylor Hawkins, Nate Mendel, Chris Shiflett/FOO FIGHTERS 10
Dave, Taylor, Nate, Chris 10
Faith No More 10
Kelly, Mosley, Rothery, Trewaves 10
Mercury, Freddie 10
Mike Bordin, Billy Gould, Mike Patton 10
Rodolfo 10
Sully Erna 10
Billy Duffy/Ian Astbury 9
Edward Van Halen, Alex Van Halen, Michael Anthony and David Lee Roth 9
Janick Gers/Steve Harris 9
Joe Strummer/Mick Jones 9
Lenny Kravitz 9
Milton Nascimento, Fernando Brant 9
O. Osbourne, R. Daisley, R. Rhoads 9
Queen 9
Robby Krieger, Ray Manzarek, John Densmore, Jim Morrison 9
Tim Maia 9
AC/DC 8
Adrian Smith/Bruce Dickinson/Steve Harris 8
Apocalyptica 8
Dado Villa-Lobos/Marcelo Bonfá 8
Metallica 8
Roy Z 8
Stone Gossard 8
U2; Bono 8
Willie Dixon 8
Alex Van Halen/David Lee Roth/Edward Van Halen/Michael Anthony 7
Billy Cobham 7
Blackmore, Gillan, Glover, Lord, Paice 7
David Murray/Steve Harris 7
Frank Zappa 7
Gene Simmons 7
Green Day 7
Harris 7
Ian Gillan/Ian Paice/Jon Lord/Ritchie Blckmore/Roger Glover 7
James Hetfield, Lars Ulrich, Kirk Hammett 7
Jeff Ament 7
Johann Sebastian Bach 7
Mick Hucknall 7
Ritchie Blackmore, Ian Gillan, Roger Glover, Jon Lord, Ian Paice 7

Milliseconds

Value Count
240091 4
158589 3
161253 3
180636 3
189675 3
192653 3
196702 3
200437 3
202213 3
203206 3
206994 3
210259 3
212062 3
213237 3
213289 3
219271 3
221387 3
221570 3
222406 3
226298 3
230191 3
232515 3
234605 3
235311 3
235833 3
251768 3
255477 3
261433 3
262791 3
264359 3
266893 3
267728 3
269557 3
272796 3
282174 3
282488 3
284447 3
285753 3
289750 3
321828 3
368770 3
116767 2
125152 2
126615 2
133093 2
135732 2
137482 2
143595 2
143830 2
149995 2
155428 2
157387 2
160235 2
161123 2
162429 2
163030 2
165067 2
165146 2
167392 2
169717 2
169900 2
169926 2
170187 2
170631 2
172068 2
172120 2
173008 2
175386 2
177606 2
180035 2
180950 2
182491 2
183066 2
184398 2
185103 2
185965 2
186044 2
186723 2
188212 2
188786 2
189257 2
190119 2
190354 2
191320 2
191503 2
192339 2
192496 2
193123 2
193149 2
193410 2
193750 2
194821 2
194873 2
196101 2
196231 2
196388 2
196466 2
197135 2
197276 2
197459 2

Bytes

Value Count
10323804 2
17760384 2
38747 1
161266 1
211997 1
224313 1
319888 1
387360 1
850698 1
967098 1
1039615 1
1095012 1
1103013 1
1124909 1
1154488 1
1189062 1
1208080 1
1220930 1
1249764 1
1287083 1
1299960 1
1351993 1
1385810 1
1439530 1
1454532 1
1549074 1
1618591 1
1688527 1
1704918 1
1707084 1
1731020 1
1805797 1
1824213 1
1851753 1
1862126 1
1944738 1
1973559 1
2056079 1
2081895 1
2099421 1
2111141 1
2189002 1
2190831 1
2193734 1
2206986 1
2229617 1
2247846 1
2256484 1
2276788 1
2283131 1
2301989 1
2304465 1
2306019 1
2315495 1
2365897 1
2365930 1
2371543 1
2382220 1
2408550 1
2439206 1
2447453 1
2449438 1
2452653 1
2509409 1
2543744 1
2550030 1
2558399 1
2582553 1
2612788 1
2616981 1
2630293 1
2649938 1
2650998 1
2660859 1
2666531 1
2702572 1
2752161 1
2754414 1
2764045 1
2767047 1
2773507 1
2775071 1
2812555 1
2839694 1
2849181 1
2861468 1
2901397 1
2920890 1
2922044 1
2930596 1
2950224 1
2968650 1
2978589 1
2996598 1
3035251 1
3037596 1
3060083 1
3067064 1
3071042 1
3098906 1

UnitPrice

Value Count
0.99 3290
1.99 213
^ top