%%capture
%load_ext sql
%sql sqlite:///chinook.db
'Connected: None@chinook.db'
%%%sql
SELECT
name,
type
FROM sqlite_master
WHERE type in ('table','view');
Done.
name | type |
---|---|
album | table |
artist | table |
customer | table |
employee | table |
genre | table |
invoice | table |
invoice_line | table |
media_type | table |
playlist | table |
playlist_track | table |
track | table |
%%%sql
SELECT * FROM genre;
Done.
genre_id | name |
---|---|
1 | Rock |
2 | Jazz |
3 | Metal |
4 | Alternative & Punk |
5 | Rock And Roll |
6 | Blues |
7 | Latin |
8 | Reggae |
9 | Pop |
10 | Soundtrack |
11 | Bossa Nova |
12 | Easy Listening |
13 | Heavy Metal |
14 | R&B/Soul |
15 | Electronica/Dance |
16 | World |
17 | Hip Hop/Rap |
18 | Science Fiction |
19 | TV Shows |
20 | Sci Fi & Fantasy |
21 | Drama |
22 | Comedy |
23 | Alternative |
24 | Classical |
25 | Opera |
%%%sql
SELECT * FROM invoice;
Done.
invoice_id | customer_id | invoice_date | billing_address | billing_city | billing_state | billing_country | billing_postal_code | total |
---|---|---|---|---|---|---|---|---|
1 | 18 | 2017-01-03 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 15.84 |
2 | 30 | 2017-01-03 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 9.9 |
3 | 40 | 2017-01-05 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 1.98 |
4 | 18 | 2017-01-06 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 7.92 |
5 | 27 | 2017-01-07 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 16.83 |
6 | 31 | 2017-01-10 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 1.98 |
7 | 49 | 2017-01-12 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 10.89 |
8 | 59 | 2017-01-13 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 9.9 |
9 | 18 | 2017-01-18 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 8.91 |
10 | 31 | 2017-01-18 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 1.98 |
11 | 38 | 2017-01-20 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 10.89 |
12 | 42 | 2017-01-21 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 3.96 |
13 | 35 | 2017-01-22 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 0.99 |
14 | 25 | 2017-01-23 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 0.99 |
15 | 44 | 2017-01-25 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 3.96 |
16 | 1 | 2017-01-26 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 8.91 |
17 | 20 | 2017-01-28 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 10.89 |
18 | 24 | 2017-02-02 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 4.95 |
19 | 10 | 2017-02-06 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 6.93 |
20 | 43 | 2017-02-06 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 9.9 |
21 | 9 | 2017-02-07 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 8.91 |
22 | 35 | 2017-02-08 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 1.98 |
23 | 53 | 2017-02-09 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 9.9 |
24 | 4 | 2017-02-10 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 11.879999999999999 |
25 | 39 | 2017-02-11 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 7.92 |
26 | 55 | 2017-02-15 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 1.98 |
27 | 35 | 2017-02-15 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 7.92 |
28 | 12 | 2017-02-17 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 2.9699999999999998 |
29 | 45 | 2017-02-17 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 5.9399999999999995 |
30 | 46 | 2017-02-18 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 10.89 |
31 | 3 | 2017-02-21 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 19.8 |
32 | 30 | 2017-02-21 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 12.87 |
33 | 58 | 2017-02-21 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 3.96 |
34 | 33 | 2017-02-23 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 0.99 |
35 | 34 | 2017-02-25 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 4.95 |
36 | 51 | 2017-02-27 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 6.93 |
37 | 59 | 2017-03-05 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 9.9 |
38 | 49 | 2017-03-05 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 6.93 |
39 | 39 | 2017-03-12 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 7.92 |
40 | 37 | 2017-03-13 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 9.9 |
41 | 50 | 2017-03-17 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 7.92 |
42 | 19 | 2017-03-18 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 8.91 |
43 | 22 | 2017-03-19 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 6.93 |
44 | 21 | 2017-03-20 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 11.879999999999999 |
45 | 36 | 2017-03-24 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 7.92 |
46 | 4 | 2017-03-24 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 10.89 |
47 | 57 | 2017-03-25 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 5.9399999999999995 |
48 | 44 | 2017-03-28 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 3.96 |
49 | 10 | 2017-03-30 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 4.95 |
50 | 18 | 2017-04-02 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 6.93 |
51 | 19 | 2017-04-03 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 7.92 |
52 | 19 | 2017-04-11 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 11.879999999999999 |
53 | 43 | 2017-04-12 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 2.9699999999999998 |
54 | 26 | 2017-04-13 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 17.82 |
55 | 33 | 2017-04-16 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 9.9 |
56 | 34 | 2017-04-22 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 16.83 |
57 | 19 | 2017-04-22 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 0.99 |
58 | 9 | 2017-04-23 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 5.9399999999999995 |
59 | 38 | 2017-04-24 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 10.89 |
60 | 15 | 2017-04-24 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 7.92 |
61 | 59 | 2017-04-24 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 11.879999999999999 |
62 | 9 | 2017-04-25 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 2.9699999999999998 |
63 | 31 | 2017-04-25 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 5.9399999999999995 |
64 | 52 | 2017-04-25 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 12.87 |
65 | 47 | 2017-04-26 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 1.98 |
66 | 16 | 2017-04-29 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 6.93 |
67 | 39 | 2017-05-01 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 10.89 |
68 | 57 | 2017-05-01 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 10.89 |
69 | 2 | 2017-05-09 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 13.86 |
70 | 31 | 2017-05-13 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 0.99 |
71 | 3 | 2017-05-17 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 16.83 |
72 | 47 | 2017-05-18 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 2.9699999999999998 |
73 | 13 | 2017-05-18 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 14.85 |
74 | 26 | 2017-05-18 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 1.98 |
75 | 16 | 2017-05-24 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 3.96 |
76 | 40 | 2017-05-26 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 12.87 |
77 | 1 | 2017-05-28 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 5.9399999999999995 |
78 | 5 | 2017-05-29 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 8.91 |
79 | 36 | 2017-06-08 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 13.86 |
80 | 13 | 2017-06-08 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 0.99 |
81 | 4 | 2017-06-12 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 5.9399999999999995 |
82 | 58 | 2017-06-13 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 6.93 |
83 | 22 | 2017-06-15 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 3.96 |
84 | 48 | 2017-06-15 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 11.879999999999999 |
85 | 33 | 2017-06-17 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 4.95 |
86 | 46 | 2017-06-18 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 0.99 |
87 | 30 | 2017-06-20 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 7.92 |
88 | 31 | 2017-06-21 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 4.95 |
89 | 21 | 2017-06-23 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 1.98 |
90 | 55 | 2017-06-28 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 10.89 |
91 | 36 | 2017-07-01 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 10.89 |
92 | 32 | 2017-07-02 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 19.8 |
93 | 42 | 2017-07-05 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 9.9 |
94 | 51 | 2017-07-08 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 7.92 |
95 | 45 | 2017-07-10 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 10.89 |
96 | 53 | 2017-07-17 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 5.9399999999999995 |
97 | 8 | 2017-07-22 00:00:00 | Grétrystraat 63 | Brussels | None | Belgium | 1000 | 5.9399999999999995 |
98 | 17 | 2017-07-23 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 9.9 |
99 | 55 | 2017-07-28 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 17.82 |
100 | 58 | 2017-07-31 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 5.9399999999999995 |
101 | 20 | 2017-07-31 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 3.96 |
102 | 8 | 2017-08-02 00:00:00 | Grétrystraat 63 | Brussels | None | Belgium | 1000 | 9.9 |
103 | 39 | 2017-08-03 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 5.9399999999999995 |
104 | 4 | 2017-08-06 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 1.98 |
105 | 31 | 2017-08-12 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 7.92 |
106 | 54 | 2017-08-19 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 7.92 |
107 | 32 | 2017-08-21 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 10.89 |
108 | 30 | 2017-08-27 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 4.95 |
109 | 22 | 2017-08-29 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 10.89 |
110 | 15 | 2017-08-29 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 5.9399999999999995 |
111 | 13 | 2017-08-30 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 4.95 |
112 | 6 | 2017-08-31 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 16.83 |
113 | 13 | 2017-09-01 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 9.9 |
114 | 12 | 2017-09-05 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 16.83 |
115 | 50 | 2017-09-08 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 8.91 |
116 | 6 | 2017-09-08 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 10.89 |
117 | 44 | 2017-09-10 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 10.89 |
118 | 28 | 2017-09-10 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 0.99 |
119 | 5 | 2017-09-12 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 1.98 |
120 | 29 | 2017-09-19 00:00:00 | 796 Dundas Street West | Toronto | ON | Canada | M6J 1V1 | 5.9399999999999995 |
121 | 59 | 2017-09-20 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 8.91 |
122 | 9 | 2017-09-21 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 4.95 |
123 | 7 | 2017-09-23 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 11.879999999999999 |
124 | 8 | 2017-09-25 00:00:00 | Grétrystraat 63 | Brussels | None | Belgium | 1000 | 5.9399999999999995 |
125 | 3 | 2017-09-29 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 9.9 |
126 | 32 | 2017-10-07 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 3.96 |
127 | 35 | 2017-10-08 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 10.89 |
128 | 17 | 2017-10-12 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 6.93 |
129 | 17 | 2017-10-16 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 10.89 |
130 | 13 | 2017-10-19 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 3.96 |
131 | 2 | 2017-10-21 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 2.9699999999999998 |
132 | 14 | 2017-10-22 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 1.98 |
133 | 35 | 2017-10-22 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 9.9 |
134 | 2 | 2017-10-23 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 7.92 |
135 | 11 | 2017-10-25 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 2.9699999999999998 |
136 | 33 | 2017-10-29 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 3.96 |
137 | 34 | 2017-10-29 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 1.98 |
138 | 33 | 2017-10-30 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 10.89 |
139 | 23 | 2017-11-03 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 4.95 |
140 | 58 | 2017-11-06 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 7.92 |
141 | 45 | 2017-11-07 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 17.82 |
142 | 15 | 2017-11-10 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 14.85 |
143 | 25 | 2017-11-10 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 4.95 |
144 | 33 | 2017-11-18 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 2.9699999999999998 |
145 | 28 | 2017-11-22 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 4.95 |
146 | 58 | 2017-11-22 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 12.87 |
147 | 19 | 2017-11-28 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 4.95 |
148 | 42 | 2017-11-30 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 8.91 |
149 | 1 | 2017-11-30 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 8.91 |
150 | 22 | 2017-12-01 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 2.9699999999999998 |
151 | 35 | 2017-12-06 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 2.9699999999999998 |
152 | 12 | 2017-12-12 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 5.9399999999999995 |
153 | 1 | 2017-12-14 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 13.86 |
154 | 39 | 2017-12-17 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 2.9699999999999998 |
155 | 59 | 2018-01-02 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 8.91 |
156 | 10 | 2018-01-03 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 10.89 |
157 | 57 | 2018-01-04 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 0.99 |
158 | 57 | 2018-01-07 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 5.9399999999999995 |
159 | 20 | 2018-01-08 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 5.9399999999999995 |
160 | 41 | 2018-01-09 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 8.91 |
161 | 24 | 2018-01-13 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 7.92 |
162 | 2 | 2018-01-15 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 8.91 |
163 | 6 | 2018-01-16 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 8.91 |
164 | 49 | 2018-01-20 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 3.96 |
165 | 41 | 2018-01-21 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 7.92 |
166 | 17 | 2018-01-21 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 9.9 |
167 | 21 | 2018-01-25 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 5.9399999999999995 |
168 | 47 | 2018-01-27 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 5.9399999999999995 |
169 | 21 | 2018-01-28 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 8.91 |
170 | 45 | 2018-01-28 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 9.9 |
171 | 53 | 2018-01-30 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 12.87 |
172 | 33 | 2018-01-31 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 7.92 |
173 | 5 | 2018-01-31 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 10.89 |
174 | 48 | 2018-01-31 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 6.93 |
175 | 39 | 2018-01-31 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 17.82 |
176 | 46 | 2018-01-31 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 6.93 |
177 | 47 | 2018-02-01 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 1.98 |
178 | 9 | 2018-02-02 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 2.9699999999999998 |
179 | 25 | 2018-02-03 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 9.9 |
180 | 46 | 2018-02-05 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 9.9 |
181 | 45 | 2018-02-06 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 6.93 |
182 | 1 | 2018-02-07 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 5.9399999999999995 |
183 | 42 | 2018-02-09 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 23.759999999999998 |
184 | 1 | 2018-02-09 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 0.99 |
185 | 21 | 2018-02-10 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 8.91 |
186 | 11 | 2018-02-10 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 2.9699999999999998 |
187 | 18 | 2018-02-18 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 6.93 |
188 | 13 | 2018-02-20 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 10.89 |
189 | 13 | 2018-02-21 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 3.96 |
190 | 51 | 2018-02-21 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 4.95 |
191 | 51 | 2018-02-22 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 3.96 |
192 | 28 | 2018-02-25 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 8.91 |
193 | 41 | 2018-02-26 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 1.98 |
194 | 34 | 2018-02-27 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 0.99 |
195 | 27 | 2018-03-02 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 10.89 |
196 | 37 | 2018-03-02 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 9.9 |
197 | 46 | 2018-03-05 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 10.89 |
198 | 13 | 2018-03-05 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 10.89 |
199 | 20 | 2018-03-08 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 2.9699999999999998 |
200 | 24 | 2018-03-08 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 7.92 |
201 | 39 | 2018-03-11 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 11.879999999999999 |
202 | 25 | 2018-03-13 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 1.98 |
203 | 38 | 2018-03-16 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 9.9 |
204 | 20 | 2018-03-17 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 10.89 |
205 | 4 | 2018-03-20 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 9.9 |
206 | 11 | 2018-03-21 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 4.95 |
207 | 17 | 2018-03-21 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 3.96 |
208 | 4 | 2018-03-22 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 5.9399999999999995 |
209 | 27 | 2018-03-25 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 3.96 |
210 | 2 | 2018-03-25 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 10.89 |
211 | 51 | 2018-03-26 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 8.91 |
212 | 45 | 2018-03-31 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 11.879999999999999 |
213 | 53 | 2018-04-01 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 10.89 |
214 | 57 | 2018-04-03 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 4.95 |
215 | 26 | 2018-04-04 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 1.98 |
216 | 49 | 2018-04-14 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 4.95 |
217 | 27 | 2018-04-17 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 9.9 |
218 | 56 | 2018-04-19 00:00:00 | 307 Macacha Güemes | Buenos Aires | None | Argentina | 1106 | 8.91 |
219 | 20 | 2018-04-21 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 2.9699999999999998 |
220 | 59 | 2018-04-25 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 8.91 |
221 | 35 | 2018-04-25 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 7.92 |
222 | 2 | 2018-04-29 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 1.98 |
223 | 1 | 2018-05-04 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 17.82 |
224 | 34 | 2018-05-06 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 9.9 |
225 | 7 | 2018-05-08 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 5.9399999999999995 |
226 | 42 | 2018-05-12 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 10.89 |
227 | 52 | 2018-05-16 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 9.9 |
228 | 57 | 2018-05-16 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 3.96 |
229 | 15 | 2018-05-19 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 2.9699999999999998 |
230 | 54 | 2018-05-21 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 7.92 |
231 | 19 | 2018-05-27 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 2.9699999999999998 |
232 | 57 | 2018-05-29 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 3.96 |
233 | 14 | 2018-06-01 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 5.9399999999999995 |
234 | 36 | 2018-06-01 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 0.99 |
235 | 5 | 2018-06-06 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 6.93 |
236 | 35 | 2018-06-08 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 2.9699999999999998 |
237 | 52 | 2018-06-13 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 15.84 |
238 | 46 | 2018-06-14 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 9.9 |
239 | 38 | 2018-06-16 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 15.84 |
240 | 10 | 2018-06-17 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 2.9699999999999998 |
241 | 45 | 2018-06-18 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 1.98 |
242 | 36 | 2018-06-18 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 9.9 |
243 | 6 | 2018-06-23 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 10.89 |
244 | 53 | 2018-06-23 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 4.95 |
245 | 20 | 2018-06-30 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 2.9699999999999998 |
246 | 58 | 2018-07-12 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 8.91 |
247 | 27 | 2018-07-12 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 10.89 |
248 | 3 | 2018-07-13 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 6.93 |
249 | 12 | 2018-07-14 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 1.98 |
250 | 23 | 2018-07-20 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 10.89 |
251 | 7 | 2018-07-20 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 6.93 |
252 | 44 | 2018-07-25 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 7.92 |
253 | 8 | 2018-07-29 00:00:00 | Grétrystraat 63 | Brussels | None | Belgium | 1000 | 11.879999999999999 |
254 | 57 | 2018-07-30 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 9.9 |
255 | 46 | 2018-07-31 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 3.96 |
256 | 13 | 2018-07-31 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 4.95 |
257 | 16 | 2018-08-01 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 10.89 |
258 | 48 | 2018-08-02 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 0.99 |
259 | 38 | 2018-08-03 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 6.93 |
260 | 10 | 2018-08-04 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 7.92 |
261 | 49 | 2018-08-06 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 8.91 |
262 | 3 | 2018-08-09 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 7.92 |
263 | 36 | 2018-08-13 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 4.95 |
264 | 38 | 2018-08-15 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 0.99 |
265 | 52 | 2018-08-18 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 6.93 |
266 | 44 | 2018-08-22 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 5.9399999999999995 |
267 | 9 | 2018-08-22 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 1.98 |
268 | 16 | 2018-08-23 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 10.89 |
269 | 43 | 2018-08-26 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 0.99 |
270 | 1 | 2018-08-27 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 10.89 |
271 | 47 | 2018-08-30 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 10.89 |
272 | 4 | 2018-08-30 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 8.91 |
273 | 37 | 2018-09-02 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 16.83 |
274 | 26 | 2018-09-04 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 4.95 |
275 | 6 | 2018-09-06 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 7.92 |
276 | 22 | 2018-09-07 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 18.81 |
277 | 53 | 2018-09-10 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 4.95 |
278 | 22 | 2018-09-23 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 2.9699999999999998 |
279 | 41 | 2018-10-01 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 4.95 |
280 | 6 | 2018-10-02 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 10.89 |
281 | 50 | 2018-10-06 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 13.86 |
282 | 20 | 2018-10-11 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 16.83 |
283 | 48 | 2018-10-13 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 8.91 |
284 | 49 | 2018-10-16 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 10.89 |
285 | 58 | 2018-10-25 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 9.9 |
286 | 27 | 2018-10-25 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 1.98 |
287 | 23 | 2018-11-04 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 1.98 |
288 | 17 | 2018-11-04 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 10.89 |
289 | 16 | 2018-11-06 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 6.93 |
290 | 17 | 2018-11-18 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 4.95 |
291 | 35 | 2018-11-19 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 2.9699999999999998 |
292 | 4 | 2018-11-21 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 9.9 |
293 | 14 | 2018-11-29 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 4.95 |
294 | 58 | 2018-12-02 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 10.89 |
295 | 33 | 2018-12-03 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 0.99 |
296 | 1 | 2018-12-10 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 12.87 |
297 | 22 | 2018-12-11 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 2.9699999999999998 |
298 | 12 | 2018-12-13 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 8.91 |
299 | 30 | 2018-12-14 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 5.9399999999999995 |
300 | 25 | 2018-12-15 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 11.879999999999999 |
301 | 34 | 2018-12-15 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 7.92 |
302 | 40 | 2018-12-18 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 3.96 |
303 | 28 | 2018-12-21 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 9.9 |
304 | 56 | 2018-12-23 00:00:00 | 307 Macacha Güemes | Buenos Aires | None | Argentina | 1106 | 6.93 |
305 | 40 | 2018-12-26 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 14.85 |
306 | 8 | 2019-01-01 00:00:00 | Grétrystraat 63 | Brussels | None | Belgium | 1000 | 10.89 |
307 | 26 | 2019-01-05 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 9.9 |
308 | 37 | 2019-01-06 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 10.89 |
309 | 36 | 2019-01-14 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 8.91 |
310 | 22 | 2019-01-16 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 8.91 |
311 | 8 | 2019-01-18 00:00:00 | Grétrystraat 63 | Brussels | None | Belgium | 1000 | 5.9399999999999995 |
312 | 42 | 2019-01-21 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 9.9 |
313 | 30 | 2019-01-24 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 4.95 |
314 | 43 | 2019-01-29 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 9.9 |
315 | 10 | 2019-01-30 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 4.95 |
316 | 11 | 2019-02-03 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 1.98 |
317 | 40 | 2019-02-14 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 11.879999999999999 |
318 | 43 | 2019-02-19 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 7.92 |
319 | 50 | 2019-02-20 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 9.9 |
320 | 58 | 2019-02-22 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 16.83 |
321 | 14 | 2019-02-23 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 0.99 |
322 | 21 | 2019-02-24 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 9.9 |
323 | 23 | 2019-03-03 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 7.92 |
324 | 57 | 2019-03-03 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 4.95 |
325 | 33 | 2019-03-04 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 9.9 |
326 | 52 | 2019-03-04 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 8.91 |
327 | 49 | 2019-03-05 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 8.91 |
328 | 10 | 2019-03-08 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 3.96 |
329 | 9 | 2019-03-09 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 0.99 |
330 | 22 | 2019-03-13 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 12.87 |
331 | 25 | 2019-03-15 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 5.9399999999999995 |
332 | 29 | 2019-03-15 00:00:00 | 796 Dundas Street West | Toronto | ON | Canada | M6J 1V1 | 9.9 |
333 | 12 | 2019-03-21 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 5.9399999999999995 |
334 | 53 | 2019-03-21 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 14.85 |
335 | 57 | 2019-03-23 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 14.85 |
336 | 6 | 2019-03-31 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 15.84 |
337 | 7 | 2019-04-03 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 9.9 |
338 | 58 | 2019-04-03 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 4.95 |
339 | 36 | 2019-04-07 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 7.92 |
340 | 48 | 2019-04-08 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 2.9699999999999998 |
341 | 5 | 2019-04-09 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 11.879999999999999 |
342 | 3 | 2019-04-13 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 2.9699999999999998 |
343 | 2 | 2019-04-13 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 5.9399999999999995 |
344 | 3 | 2019-04-15 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 16.83 |
345 | 50 | 2019-04-16 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 9.9 |
346 | 40 | 2019-04-17 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 5.9399999999999995 |
347 | 44 | 2019-04-17 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 3.96 |
348 | 35 | 2019-04-18 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 8.91 |
349 | 37 | 2019-04-21 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 0.99 |
350 | 44 | 2019-04-21 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 2.9699999999999998 |
351 | 57 | 2019-04-23 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 9.9 |
352 | 10 | 2019-04-23 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 0.99 |
353 | 28 | 2019-04-28 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 9.9 |
354 | 9 | 2019-05-02 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 4.95 |
355 | 43 | 2019-05-04 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 6.93 |
356 | 55 | 2019-05-04 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 6.93 |
357 | 13 | 2019-05-08 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 2.9699999999999998 |
358 | 19 | 2019-05-12 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 6.93 |
359 | 43 | 2019-05-12 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 8.91 |
360 | 45 | 2019-05-15 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 3.96 |
361 | 5 | 2019-05-18 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 1.98 |
362 | 29 | 2019-05-24 00:00:00 | 796 Dundas Street West | Toronto | ON | Canada | M6J 1V1 | 19.8 |
363 | 38 | 2019-05-24 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 2.9699999999999998 |
364 | 26 | 2019-05-26 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 5.9399999999999995 |
365 | 28 | 2019-05-27 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 3.96 |
366 | 26 | 2019-05-27 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 8.91 |
367 | 40 | 2019-05-29 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 7.92 |
368 | 35 | 2019-05-30 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 1.98 |
369 | 50 | 2019-05-31 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 9.9 |
370 | 14 | 2019-06-01 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 8.91 |
371 | 14 | 2019-06-01 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 0.99 |
372 | 18 | 2019-06-01 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 13.86 |
373 | 39 | 2019-06-01 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 3.96 |
374 | 43 | 2019-06-03 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 5.9399999999999995 |
375 | 35 | 2019-06-05 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 8.91 |
376 | 5 | 2019-06-06 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 3.96 |
377 | 28 | 2019-06-09 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 2.9699999999999998 |
378 | 48 | 2019-06-13 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 3.96 |
379 | 54 | 2019-06-13 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 11.879999999999999 |
380 | 56 | 2019-06-14 00:00:00 | 307 Macacha Güemes | Buenos Aires | None | Argentina | 1106 | 9.9 |
381 | 56 | 2019-06-21 00:00:00 | 307 Macacha Güemes | Buenos Aires | None | Argentina | 1106 | 12.87 |
382 | 48 | 2019-06-22 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 3.96 |
383 | 23 | 2019-07-03 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 9.9 |
384 | 50 | 2019-07-10 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 10.89 |
385 | 42 | 2019-07-11 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 6.93 |
386 | 26 | 2019-07-12 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 4.95 |
387 | 6 | 2019-07-15 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 5.9399999999999995 |
388 | 5 | 2019-07-16 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 9.9 |
389 | 16 | 2019-07-18 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 16.83 |
390 | 34 | 2019-07-19 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 2.9699999999999998 |
391 | 30 | 2019-07-20 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 3.96 |
392 | 11 | 2019-07-24 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 7.92 |
393 | 17 | 2019-07-25 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 10.89 |
394 | 31 | 2019-07-27 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 7.92 |
395 | 24 | 2019-07-28 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 9.9 |
396 | 42 | 2019-07-29 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 8.91 |
397 | 36 | 2019-07-31 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 6.93 |
398 | 51 | 2019-08-03 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 16.83 |
399 | 51 | 2019-08-03 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 11.879999999999999 |
400 | 36 | 2019-08-06 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 3.96 |
401 | 46 | 2019-08-06 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 9.9 |
402 | 54 | 2019-08-09 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 8.91 |
403 | 54 | 2019-08-10 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 8.91 |
404 | 31 | 2019-08-13 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 13.86 |
405 | 6 | 2019-08-14 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 7.92 |
406 | 10 | 2019-08-15 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 1.98 |
407 | 57 | 2019-08-19 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 9.9 |
408 | 34 | 2019-08-20 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 5.9399999999999995 |
409 | 48 | 2019-08-24 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 10.89 |
410 | 7 | 2019-08-27 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 3.96 |
411 | 9 | 2019-08-27 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 1.98 |
412 | 12 | 2019-08-28 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 7.92 |
413 | 47 | 2019-08-28 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 14.85 |
414 | 54 | 2019-08-30 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 9.9 |
415 | 54 | 2019-08-31 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 8.91 |
416 | 5 | 2019-08-31 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 0.99 |
417 | 24 | 2019-09-01 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 9.9 |
418 | 50 | 2019-09-01 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 0.99 |
419 | 3 | 2019-09-02 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 9.9 |
420 | 20 | 2019-09-05 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 9.9 |
421 | 48 | 2019-09-05 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 7.92 |
422 | 53 | 2019-09-07 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 6.93 |
423 | 21 | 2019-09-07 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 10.89 |
424 | 35 | 2019-09-09 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 1.98 |
425 | 14 | 2019-09-13 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 0.99 |
426 | 37 | 2019-09-14 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 4.95 |
427 | 55 | 2019-09-14 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 14.85 |
428 | 43 | 2019-09-17 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 3.96 |
429 | 5 | 2019-09-17 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 10.89 |
430 | 55 | 2019-09-20 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 1.98 |
431 | 8 | 2019-09-21 00:00:00 | Grétrystraat 63 | Brussels | None | Belgium | 1000 | 9.9 |
432 | 32 | 2019-09-23 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 1.98 |
433 | 33 | 2019-09-24 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 2.9699999999999998 |
434 | 26 | 2019-09-27 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 9.9 |
435 | 38 | 2019-09-28 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 5.9399999999999995 |
436 | 17 | 2019-10-02 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 5.9399999999999995 |
437 | 54 | 2019-10-02 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 9.9 |
438 | 23 | 2019-10-04 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 10.89 |
439 | 11 | 2019-10-08 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 6.93 |
440 | 45 | 2019-10-08 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 2.9699999999999998 |
441 | 44 | 2019-10-26 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 6.93 |
442 | 1 | 2019-11-05 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 3.96 |
443 | 20 | 2019-11-07 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 7.92 |
444 | 52 | 2019-11-08 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 8.91 |
445 | 40 | 2019-11-11 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 3.96 |
446 | 49 | 2019-11-19 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 8.91 |
447 | 12 | 2019-11-23 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 10.89 |
448 | 18 | 2019-11-27 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 9.9 |
449 | 34 | 2019-11-27 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 16.83 |
450 | 55 | 2019-12-04 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 6.93 |
451 | 46 | 2019-12-13 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 0.99 |
452 | 47 | 2019-12-18 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 7.92 |
453 | 31 | 2019-12-19 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 4.95 |
454 | 46 | 2019-12-21 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 14.85 |
455 | 28 | 2019-12-24 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 4.95 |
456 | 13 | 2019-12-24 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 9.9 |
457 | 37 | 2019-12-25 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 14.85 |
458 | 42 | 2019-12-26 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 0.99 |
459 | 50 | 2019-12-26 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 1.98 |
460 | 20 | 2019-12-28 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 10.89 |
461 | 11 | 2019-12-29 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 7.92 |
462 | 7 | 2019-12-29 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 8.91 |
463 | 34 | 2019-12-30 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 11.879999999999999 |
464 | 1 | 2019-12-31 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 3.96 |
465 | 21 | 2020-01-12 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 6.93 |
466 | 30 | 2020-01-19 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 3.96 |
467 | 5 | 2020-01-20 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 9.9 |
468 | 25 | 2020-01-22 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 15.84 |
469 | 14 | 2020-01-28 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 0.99 |
470 | 9 | 2020-01-29 00:00:00 | Sønder Boulevard 51 | Copenhagen | None | Denmark | 1720 | 1.98 |
471 | 35 | 2020-01-30 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 0.99 |
472 | 7 | 2020-01-31 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 2.9699999999999998 |
473 | 58 | 2020-02-02 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 3.96 |
474 | 4 | 2020-02-04 00:00:00 | Ullevålsveien 14 | Oslo | None | Norway | 0171 | 6.93 |
475 | 11 | 2020-02-06 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 7.92 |
476 | 6 | 2020-02-11 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 10.89 |
477 | 5 | 2020-02-15 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 6.93 |
478 | 28 | 2020-02-21 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 16.83 |
479 | 46 | 2020-02-21 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 16.83 |
480 | 44 | 2020-02-22 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 9.9 |
481 | 43 | 2020-02-25 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 3.96 |
482 | 10 | 2020-02-26 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 7.92 |
483 | 15 | 2020-02-29 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 4.95 |
484 | 47 | 2020-03-02 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 2.9699999999999998 |
485 | 37 | 2020-03-05 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 9.9 |
486 | 18 | 2020-03-05 00:00:00 | 627 Broadway | New York | NY | USA | 10012-2612 | 8.91 |
487 | 27 | 2020-03-11 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 9.9 |
488 | 7 | 2020-03-13 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 13.86 |
489 | 43 | 2020-03-14 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 2.9699999999999998 |
490 | 19 | 2020-03-14 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 8.91 |
491 | 51 | 2020-03-24 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 1.98 |
492 | 54 | 2020-03-25 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 4.95 |
493 | 41 | 2020-03-26 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 3.96 |
494 | 26 | 2020-03-31 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 9.9 |
495 | 10 | 2020-04-01 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 0.99 |
496 | 21 | 2020-04-01 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 7.92 |
497 | 34 | 2020-04-01 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 6.93 |
498 | 13 | 2020-04-02 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 3.96 |
499 | 17 | 2020-04-03 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 9.9 |
500 | 36 | 2020-04-07 00:00:00 | Tauentzienstraße 8 | Berlin | None | Germany | 10789 | 8.91 |
501 | 11 | 2020-04-09 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 12.87 |
502 | 53 | 2020-04-10 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 3.96 |
503 | 39 | 2020-04-11 00:00:00 | 4, Rue Milton | Paris | None | France | 75009 | 9.9 |
504 | 6 | 2020-04-12 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 10.89 |
505 | 19 | 2020-04-14 00:00:00 | 1 Infinite Loop | Cupertino | CA | USA | 95014 | 0.99 |
506 | 58 | 2020-04-14 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 15.84 |
507 | 2 | 2020-04-20 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 0.99 |
508 | 38 | 2020-04-22 00:00:00 | Barbarossastraße 19 | Berlin | None | Germany | 10779 | 8.91 |
509 | 48 | 2020-04-27 00:00:00 | Lijnbaansgracht 120bg | Amsterdam | VV | Netherlands | 1016 | 6.93 |
510 | 25 | 2020-04-28 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 9.9 |
511 | 24 | 2020-05-01 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 6.93 |
512 | 43 | 2020-05-02 00:00:00 | 68, Rue Jouvence | Dijon | None | France | 21000 | 8.91 |
513 | 41 | 2020-05-03 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 10.89 |
514 | 25 | 2020-05-14 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 2.9699999999999998 |
515 | 23 | 2020-05-15 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 2.9699999999999998 |
516 | 23 | 2020-05-16 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 1.98 |
517 | 3 | 2020-05-16 00:00:00 | 1498 rue Bélanger | Montréal | QC | Canada | H2G 1A7 | 8.91 |
518 | 22 | 2020-05-22 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 1.98 |
519 | 32 | 2020-05-22 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 6.93 |
520 | 5 | 2020-05-26 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 9.9 |
521 | 13 | 2020-05-27 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 3.96 |
522 | 22 | 2020-05-27 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 7.92 |
523 | 50 | 2020-05-29 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 7.92 |
524 | 41 | 2020-06-01 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 4.95 |
525 | 30 | 2020-06-02 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 9.9 |
526 | 5 | 2020-06-08 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 19.8 |
527 | 57 | 2020-06-09 00:00:00 | Calle Lira, 198 | Santiago | None | Chile | None | 10.89 |
528 | 50 | 2020-06-10 00:00:00 | C/ San Bernardo 85 | Madrid | None | Spain | 28015 | 15.84 |
529 | 24 | 2020-06-12 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 13.86 |
530 | 14 | 2020-06-22 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 0.99 |
531 | 44 | 2020-06-22 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 11.879999999999999 |
532 | 13 | 2020-06-23 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 13.86 |
533 | 11 | 2020-06-24 00:00:00 | Av. Paulista, 2022 | São Paulo | SP | Brazil | 01310-200 | 12.87 |
534 | 10 | 2020-06-25 00:00:00 | Rua Dr. Falcão Filho, 155 | São Paulo | SP | Brazil | 01007-010 | 5.9399999999999995 |
535 | 56 | 2020-07-05 00:00:00 | 307 Macacha Güemes | Buenos Aires | None | Argentina | 1106 | 0.99 |
536 | 1 | 2020-07-06 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 5.9399999999999995 |
537 | 12 | 2020-07-07 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 7.92 |
538 | 31 | 2020-07-10 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 8.91 |
539 | 46 | 2020-07-12 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 0.99 |
540 | 37 | 2020-07-12 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 10.89 |
541 | 58 | 2020-07-15 00:00:00 | 12,Community Centre | Delhi | None | India | 110017 | 2.9699999999999998 |
542 | 34 | 2020-07-18 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 10.89 |
543 | 17 | 2020-07-23 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 2.9699999999999998 |
544 | 1 | 2020-07-24 00:00:00 | Av. Brigadeiro Faria Lima, 2170 | São José dos Campos | SP | Brazil | 12227-000 | 8.91 |
545 | 33 | 2020-07-26 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 7.92 |
546 | 32 | 2020-07-30 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 6.93 |
547 | 41 | 2020-08-01 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 9.9 |
548 | 30 | 2020-08-02 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 10.89 |
549 | 2 | 2020-08-10 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 10.89 |
550 | 42 | 2020-08-12 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 9.9 |
551 | 16 | 2020-08-18 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 10.89 |
552 | 30 | 2020-08-19 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 5.9399999999999995 |
553 | 7 | 2020-08-26 00:00:00 | Rotenturmstraße 4, 1010 Innere Stadt | Vienne | None | Austria | 1010 | 4.95 |
554 | 30 | 2020-08-27 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 8.91 |
555 | 55 | 2020-09-04 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 1.98 |
556 | 21 | 2020-09-04 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 10.89 |
557 | 2 | 2020-09-08 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 9.9 |
558 | 17 | 2020-09-11 00:00:00 | 1 Microsoft Way | Redmond | WA | USA | 98052-8300 | 10.89 |
559 | 32 | 2020-09-11 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 5.9399999999999995 |
560 | 5 | 2020-09-11 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 8.91 |
561 | 23 | 2020-09-12 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 6.93 |
562 | 27 | 2020-09-17 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 8.91 |
563 | 5 | 2020-09-19 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 1.98 |
564 | 15 | 2020-09-20 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 5.9399999999999995 |
565 | 53 | 2020-09-23 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 9.9 |
566 | 37 | 2020-09-27 00:00:00 | Berger Straße 10 | Frankfurt | None | Germany | 60316 | 4.95 |
567 | 15 | 2020-09-27 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 7.92 |
568 | 35 | 2020-10-01 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 6.93 |
569 | 47 | 2020-10-06 00:00:00 | Via Degli Scipioni, 43 | Rome | RM | Italy | 00192 | 0.99 |
570 | 52 | 2020-10-07 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 2.9699999999999998 |
571 | 51 | 2020-10-09 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 2.9699999999999998 |
572 | 34 | 2020-10-13 00:00:00 | Rua da Assunção 53 | Lisbon | None | Portugal | None | 4.95 |
573 | 27 | 2020-10-16 00:00:00 | 1033 N Park Ave | Tucson | AZ | USA | 85719 | 10.89 |
574 | 49 | 2020-10-17 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 10.89 |
575 | 15 | 2020-10-19 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 3.96 |
576 | 45 | 2020-10-19 00:00:00 | Erzsébet krt. 58. | Budapest | None | Hungary | H-1073 | 5.9399999999999995 |
577 | 28 | 2020-10-20 00:00:00 | 302 S 700 E | Salt Lake City | UT | USA | 84102 | 8.91 |
578 | 25 | 2020-10-21 00:00:00 | 319 N. Frances Street | Madison | WI | USA | 53703 | 11.879999999999999 |
579 | 6 | 2020-10-23 00:00:00 | Rilská 3174/6 | Prague | None | Czech Republic | 14300 | 10.89 |
580 | 24 | 2020-10-25 00:00:00 | 162 E Superior Street | Chicago | IL | USA | 60611 | 9.9 |
581 | 32 | 2020-10-26 00:00:00 | 696 Osborne Street | Winnipeg | MB | Canada | R3L 2B9 | 13.86 |
582 | 5 | 2020-10-30 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 17.82 |
583 | 22 | 2020-10-30 00:00:00 | 120 S Orange Ave | Orlando | FL | USA | 32801 | 10.89 |
584 | 30 | 2020-10-31 00:00:00 | 230 Elgin Street | Ottawa | ON | Canada | K2P 1L7 | 0.99 |
585 | 40 | 2020-10-31 00:00:00 | 8, Rue Hanovre | Paris | None | France | 75002 | 8.91 |
586 | 55 | 2020-11-01 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 10.89 |
587 | 12 | 2020-11-07 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 1.98 |
588 | 5 | 2020-11-12 00:00:00 | Klanova 9/506 | Prague | None | Czech Republic | 14700 | 0.99 |
589 | 41 | 2020-11-12 00:00:00 | 11, Place Bellecour | Lyon | None | France | 69002 | 10.89 |
590 | 51 | 2020-11-17 00:00:00 | Celsiusg. 9 | Stockholm | None | Sweden | 11230 | 8.91 |
591 | 16 | 2020-11-20 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | CA | USA | 94043-1351 | 6.93 |
592 | 2 | 2020-11-21 00:00:00 | Theodor-Heuss-Straße 34 | Stuttgart | None | Germany | 70174 | 7.92 |
593 | 12 | 2020-11-23 00:00:00 | Praça Pio X, 119 | Rio de Janeiro | RJ | Brazil | 20040-020 | 10.89 |
594 | 31 | 2020-11-24 00:00:00 | 194A Chain Lake Drive | Halifax | NS | Canada | B3S 1C5 | 2.9699999999999998 |
595 | 23 | 2020-11-27 00:00:00 | 69 Salem Street | Boston | MA | USA | 2113 | 7.92 |
596 | 42 | 2020-11-27 00:00:00 | 9, Place Louis Barthou | Bordeaux | None | France | 33000 | 5.9399999999999995 |
597 | 13 | 2020-11-28 00:00:00 | Qe 7 Bloco G | Brasília | DF | Brazil | 71020-677 | 6.93 |
598 | 26 | 2020-12-04 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 4.95 |
599 | 59 | 2020-12-06 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 7.92 |
600 | 29 | 2020-12-08 00:00:00 | 796 Dundas Street West | Toronto | ON | Canada | M6J 1V1 | 4.95 |
601 | 44 | 2020-12-08 00:00:00 | Porthaninkatu 9 | Helsinki | None | Finland | 00530 | 10.89 |
602 | 21 | 2020-12-09 00:00:00 | 801 W 4th Street | Reno | NV | USA | 89503 | 6.93 |
603 | 26 | 2020-12-10 00:00:00 | 2211 W Berry Street | Fort Worth | TX | USA | 76110 | 4.95 |
604 | 46 | 2020-12-12 00:00:00 | 3 Chatham Street | Dublin | Dublin | Ireland | None | 17.82 |
605 | 35 | 2020-12-17 00:00:00 | Rua dos Campeões Europeus de Viena, 4350 | Porto | None | Portugal | None | 3.96 |
606 | 15 | 2020-12-18 00:00:00 | 700 W Pender Street | Vancouver | BC | Canada | V6C 1G8 | 11.879999999999999 |
607 | 59 | 2020-12-19 00:00:00 | 3,Raj Bhavan Road | Bangalore | None | India | 560001 | 4.95 |
608 | 49 | 2020-12-20 00:00:00 | Ordynacka 10 | Warsaw | None | Poland | 00-358 | 0.99 |
609 | 14 | 2020-12-20 00:00:00 | 8210 111 ST NW | Edmonton | AB | Canada | T6G 2C7 | 2.9699999999999998 |
610 | 55 | 2020-12-21 00:00:00 | 421 Bourke Street | Sidney | NSW | Australia | 2010 | 6.93 |
611 | 52 | 2020-12-27 00:00:00 | 202 Hoxton Street | London | None | United Kingdom | N1 5LH | 1.98 |
612 | 33 | 2020-12-27 00:00:00 | 5112 48 Street | Yellowknife | NT | Canada | X1A 1N6 | 11.879999999999999 |
613 | 20 | 2020-12-29 00:00:00 | 541 Del Medio Avenue | Mountain View | CA | USA | 94040-111 | 8.91 |
614 | 53 | 2020-12-30 00:00:00 | 113 Lupus St | London | None | United Kingdom | SW1V 3EN | 12.87 |
Our first task is to return each genre with the number of albums sold in the USA both as total value and as a percentage.
%%%sql
WITH usa_invoices AS
(
SELECT *
FROM invoice_line il
INNER JOIN invoice i ON i.invoice_id = il.invoice_id
INNER JOIN track t ON t.track_id = il.track_id
WHERE billing_country = "USA"
)
SELECT g.name genre,
count(ui.invoice_line_id) tracks_sold,
ROUND((cast(count(ui.invoice_line_id) AS FLOAT)/
(SELECT COUNT(*) FROM usa_invoices))*100, 2)|| "%" percentage_sold
FROM usa_invoices ui
INNER JOIN genre g ON g.genre_id = ui.genre_id
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10;
Done.
genre | tracks_sold | percentage_sold |
---|---|---|
Rock | 561 | 53.38% |
Alternative & Punk | 130 | 12.37% |
Metal | 124 | 11.8% |
R&B/Soul | 53 | 5.04% |
Blues | 36 | 3.43% |
Alternative | 35 | 3.33% |
Latin | 22 | 2.09% |
Pop | 22 | 2.09% |
Hip Hop/Rap | 20 | 1.9% |
Jazz | 14 | 1.33% |
What we end up seeing in our analysis is that more than half of the record sold are from the Rock genre, with Alternative & Punk coming a distant second at 12.4%, followed by Metal at 11.8%.
After that, every genre falls 5.1% of total tracks sold.
The recommendation for which albums we should purchase for the store are Red Tone and Slim Jim Bites. Additionally, our third purchase should be Meteor and the Girls, although it is only a marginal difference between this artist and Regal and could swap for each other, depending on the individual artist's popularity within their own genre.
Now, we will look into the sales reps and their total sales each in dollar amounts. We will also highlight their age and hire dates, to see if there is any analysis to be done in regards to the representatives themselves.
%%%sql
WITH sales_reps AS
(
SELECT *
FROM employee e
INNER JOIN customer c ON c.support_rep_id = e.employee_id
INNER JOIN invoice i ON c.customer_id = i.customer_id
INNER JOIN invoice_line il ON il.invoice_id = i.invoice_id
)
SELECT sr.first_name || " " || sr.last_name employee_name,
'$'||ROUND(SUM((sr.unit_price)*(sr.quantity)),2) total_sales,
sr.birthdate birth_date, sr.hire_date hire_date
FROM sales_reps sr
GROUP BY 1
ORDER BY 2 DESC;
Done.
employee_name | total_sales | birth_date | hire_date |
---|---|---|---|
Jane Peacock | $1731.51 | 1973-08-29 00:00:00 | 2017-04-01 00:00:00 |
Margaret Park | $1584.0 | 1947-09-19 00:00:00 | 2017-05-03 00:00:00 |
Steve Johnson | $1393.92 | 1965-03-03 00:00:00 | 2017-10-17 00:00:00 |
Our query found that Jane Peacock had the highest total sales at $1731.51, with Margaret Park and Steve Johnson both having less.
Jane also happens to be the youngest of the three sales reps, but has the most experience with the company as she was hired before Margaret and Steve.
Margaret had the second highest total, but is the oldest sales rep. She did, however, get hired before Steve, so it appears that sales totals directly correspond to experience at the company, with more experience leading to higher sales, while age does not play as significant of a factor.
%%%sql
WITH country_info AS
(
SELECT
CASE
WHEN (
SELECT count(*)
FROM customer
WHERE country = c.country
) = 1 THEN "Other"
ELSE c.country
END AS country,
c.customer_id,
il.*
FROM invoice_line il
INNER JOIN invoice i ON i.invoice_id = il.invoice_id
INNER JOIN customer c ON c.customer_id = i.customer_id
)
SELECT
country,
customers,
sales,
sales_per_customer,
average_order
FROM
(
SELECT country,
COUNT(DISTINCT customer_id) customers,
SUM(unit_price) sales,
SUM(unit_price)/COUNT(DISTINCT customer_id) sales_per_customer,
SUM(unit_price)/COUNT(DISTINCT invoice_id) average_order,
CASE
WHEN country = "Other" THEN 1
ELSE 0
END AS sort
FROM country_info
GROUP BY country
ORDER BY sort ASC, sales DESC);
Done.
country | customers | sales | sales_per_customer | average_order |
---|---|---|---|---|
USA | 13 | 1040.490000000008 | 80.03769230769292 | 7.942671755725252 |
Canada | 8 | 535.5900000000034 | 66.94875000000043 | 7.047236842105309 |
Brazil | 5 | 427.68000000000245 | 85.53600000000048 | 7.011147540983647 |
France | 5 | 389.0700000000021 | 77.81400000000042 | 7.781400000000042 |
Germany | 4 | 334.6200000000016 | 83.6550000000004 | 8.161463414634186 |
Czech Republic | 2 | 273.24000000000103 | 136.62000000000052 | 9.108000000000034 |
United Kingdom | 3 | 245.52000000000078 | 81.84000000000026 | 8.768571428571457 |
Portugal | 2 | 185.13000000000022 | 92.56500000000011 | 6.3837931034482835 |
India | 2 | 183.1500000000002 | 91.5750000000001 | 8.72142857142858 |
Other | 15 | 1094.9400000000085 | 72.99600000000056 | 7.448571428571486 |
Our query of the customers grouped into their countries shows us the following information:
%%%sql
WITH invoice_first AS
(
SELECT
il.invoice_id invoice_id,
MIN(il.track_id) first_track_id
FROM invoice_line il
GROUP BY 1
)
SELECT
album_purchase,
COUNT(invoice_id) invoices,
ROUND(100*CAST(count(invoice_id) AS FLOAT) /
(
SELECT COUNT(*) FROM invoice
), 2) percent
FROM
(
SELECT
ifs.*,
CASE
WHEN
(
SELECT t.track_id FROM track t
WHERE t.album_id = (
SELECT t2.album_id FROM track t2
WHERE t2.track_id = ifs.first_track_id
)
EXCEPT
SELECT il2.track_id FROM invoice_line il2
WHERE il2.invoice_id = ifs.invoice_id
) IS NULL
AND
(
SELECT il2.track_id
FROM invoice_line il2
WHERE il2.invoice_id = ifs.invoice_id
EXCEPT
SELECT t.track_id
FROM track t
WHERE t.album_id =
(
SELECT t2.album_id
FROM track t2
WHERE t2.track_id = ifs.first_track_id
)
) IS NULL
THEN "Yes"
ELSE "No"
END AS "album_purchase"
FROM invoice_first ifs
)
GROUP BY album_purchase;
Done.
album_purchase | invoices | percent |
---|---|---|
No | 500 | 81.43 |
Yes | 114 | 18.57 |
While a larger percentage of sales are from individual track sales, there are still over 18% of sales from full albums. That revenue would be decreased if Chinook stopped buying full albums, so my recommendation is to continue to buy albums.