| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Order ID | Order Date | Customer Name | City | Country | Region | Segment | Ship Date | Ship Mode | State | lon | lat |
2 | BN-2011-7407039 | 1/1/2011 | Ruby Patel | Stockholm | Sweden | North | Home Office | 1/5/2011 | Economy Plus | Stockholm | 18.0685808 | 59.3293235 |
3 | AZ-2011-9050313 | 1/3/2011 | Summer Hayward | Southport | United Kingdom | North | Consumer | 1/7/2011 | Economy | England | -3.010113 | 53.645708 |
4 | AZ-2011-6674300 | 1/4/2011 | Devin Huddleston | Valence | France | Central | Consumer | 1/8/2011 | Economy | Auvergne-Rhône-Alpes | 4.89236 | 44.933393 |
5 | BN-2011-2819714 | 1/4/2011 | Mary Parker | Birmingham | United Kingdom | North | Corporate | 1/9/2011 | Economy | England | -1.890401 | 52.486243 |
6 | AZ-2011-617423 | 1/5/2011 | Daniel Burke | Echirolles | France | Central | Home Office | 1/7/2011 | Priority | Auvergne-Rhône-Alpes | 5.718034 | 45.142151 |
7 | AZ-2011-2918397 | 1/7/2011 | Fredrick Beveridge | La Seyne-sur-Mer | France | Central | Corporate | 1/8/2011 | Priority | Provence-Alpes-Côte d'Azur | 5.878219 | 43.102976 |
8 | BN-2011-3248724 | 1/8/2011 | Archer Hort | Toulouse | France | Central | Consumer | 1/14/2011 | Economy | Languedoc-Roussillon-Midi-Pyrénées | 1.444209 | 43.604652 |
9 | AZ-2011-6712797 | 1/11/2011 | Evie Flockhart | Genoa | Italy | South | Consumer | 1/16/2011 | Economy | Liguria | 8.946256 | 44.4056499 |
10 | AZ-2011-4827146 | 1/11/2011 | Faith Greenwood | Vienna | Austria | Central | Consumer | 1/15/2011 | Economy | Vienna | 16.3738189 | 48.2081743 |
11 | AZ-2011-6439906 | 1/11/2011 | Summer Hayward | Murcia | Spain | South | Consumer | 1/15/2011 | Economy | Murcia | -1.1306544 | 37.9922399 |
12 | AZ-2011-7053593 | 1/11/2011 | Gracie Powell | Woking | United Kingdom | North | Consumer | 1/11/2011 | Immediate | England | -0.5600349 | 51.316774 |
13 | AZ-2011-5702370 | 1/12/2011 | Hershel Snyder | Lohne | Germany | Central | Corporate | 1/19/2011 | Economy | Lower Saxony | 8.7220862 | 52.1941419 |
14 | AZ-2011-9927716 | 1/12/2011 | Julia Martell | Leicester | United Kingdom | North | Home Office | 1/17/2011 | Economy | England | -1.1397592 | 52.6368778 |
15 | AZ-2011-2222024 | 1/12/2011 | Viola Watson | Sheffield | United Kingdom | North | Consumer | 1/15/2011 | Priority | England | -1.470085 | 53.381129 |
16 | BN-2011-4913858 | 1/13/2011 | Julian Dobie | Dordrecht | Netherlands | Central | Consumer | 1/19/2011 | Economy | South Holland | 4.6900929 | 51.8132979 |
17 | BN-2011-2807470 | 1/13/2011 | Rose Heap | Gothenburg | Sweden | North | Consumer | 1/20/2011 | Economy | Västra Götaland | 11.97456 | 57.70887 |
18 | AZ-2011-5960662 | 1/14/2011 | Ella Troy | Vienna | Austria | Central | Home Office | 1/19/2011 | Economy | Vienna | 16.3738189 | 48.2081743 |
19 | AZ-2011-7675351 | 1/15/2011 | Everett Dunbar | Langen | Germany | Central | Corporate | 1/20/2011 | Economy Plus | Lower Saxony | 8.6634007 | 49.9914663 |
20 | BN-2011-3770060 | 1/17/2011 | Georgia Bermingham | Copenhagen | Denmark | North | Home Office | 1/23/2011 | Economy | Hovedstaden | 12.5683371 | 55.6760968 |
21 | AZ-2011-7419210 | 1/18/2011 | Christopher Goold | Gandia | Spain | South | Corporate | 1/21/2011 | Priority | Valenciana | -0.1844671 | 38.968032 |
22 | AZ-2011-1816950 | 1/18/2011 | John Baca | Esbjerg | Denmark | North | Consumer | 1/23/2011 | Economy Plus | South Denmark | 8.459405 | 55.476466 |
23 | AZ-2011-3059419 | 1/19/2011 | Kai Leonard | Sesto San Giovanni | Italy | South | Corporate | 1/21/2011 | Priority | Lombardy | 9.2256875 | 45.5328245 |
24 | AZ-2011-5342265 | 1/19/2011 | Jennifer Mattingly | Trapani | Italy | South | Home Office | 1/20/2011 | Priority | Sicily | 12.537202 | 38.0176177 |
25 | AZ-2011-2002251 | 1/20/2011 | Nathan Iqbal | Villiers-sur-Marne | France | Central | Consumer | 1/25/2011 | Economy | Ile-de-France | 2.546798 | 48.825787 |
26 | AZ-2011-5357101 | 1/21/2011 | Noah Chamberlain | Bielefeld | Germany | Central | Consumer | 1/26/2011 | Economy | North Rhine-Westphalia | 8.5324708 | 52.0302285 |
27 | AZ-2011-2245674 | 1/22/2011 | Dylan Disney | Leuven | Belgium | Central | Home Office | 1/26/2011 | Economy | Flemish Brabant | 4.7005176 | 50.8798438 |
28 | AZ-2011-8034411 | 1/22/2011 | Melissa Bean | Prato | Italy | South | Home Office | 1/26/2011 | Economy | Tuscany | 11.102228 | 43.8777049 |
29 | AZ-2011-6684426 | 1/24/2011 | Vaughn Gibbs | Gela | Italy | South | Home Office | 1/26/2011 | Economy Plus | Sicily | 14.2403537 | 37.0741526 |
30 | BN-2011-7883641 | 1/24/2011 | William Horton | Bologna | Italy | South | Consumer | 1/26/2011 | Priority | Emilia-Romagna | 11.3426163 | 44.494887 |
31 | AZ-2011-4205736 | 1/25/2011 | David Harney | Menden | Germany | Central | Corporate | 2/1/2011 | Economy | North Rhine-Westphalia | 7.7953337 | 51.4377453 |
32 | AZ-2011-5010109 | 1/25/2011 | Walter Coley | Maisons-Alfort | France | Central | Consumer | 1/30/2011 | Economy | Ile-de-France | 2.429443 | 48.801148 |
33 | AZ-2011-201891 | 1/26/2011 | Lori Miller | Madrid | Spain | South | Consumer | 1/30/2011 | Economy | Madrid | -3.7037902 | 40.4167754 |
34 | AZ-2011-5708655 | 1/26/2011 | Hayley Baldwinson | Oslo | Norway | North | Consumer | 1/30/2011 | Economy | Oslo | 10.7522454 | 59.9138688 |
35 | BN-2011-6722454 | 1/26/2011 | Joseph Locke | Lisbon | Portugal | South | Corporate | 1/30/2011 | Economy | Lisboa | -9.1393366 | 38.7222524 |
36 | BN-2011-486854 | 1/28/2011 | Gracie Hicks | Draguignan | France | Central | Consumer | 2/3/2011 | Economy | Provence-Alpes-Côte d'Azur | 6.464993 | 43.5377269 |
37 | AZ-2011-2825684 | 2/1/2011 | Hollie Norris | Halle | Germany | Central | Consumer | 2/7/2011 | Economy | North Rhine-Westphalia | 11.9688029 | 51.4969802 |
38 | AZ-2011-494581 | 2/1/2011 | Kiara Allen | Parma | Italy | South | Consumer | 2/5/2011 | Economy | Emilia-Romagna | 10.3279036 | 44.801485 |
39 | AZ-2011-838467 | 2/2/2011 | Ronald Everson | Dresden | Germany | Central | Corporate | 2/5/2011 | Priority | Saxony | 13.7372621 | 51.0504088 |
40 | AZ-2011-4987681 | 2/2/2011 | Daryl Claypool | Seville | Spain | South | Corporate | 2/6/2011 | Economy Plus | Andalusía | -5.9844589 | 37.3890924 |
41 | AZ-2011-4614904 | 2/2/2011 | Caleb Kenyon | Torrevieja | Spain | South | Corporate | 2/4/2011 | Priority | Valenciana | -0.6808233 | 37.9847003 |
42 | AZ-2011-7043718 | 2/2/2011 | Winnie Moss | Barcelona | Spain | South | Consumer | 2/7/2011 | Economy Plus | Catalonia | 2.1734035 | 41.3850639 |
43 | AZ-2011-4696725 | 2/2/2011 | Courtney Hancock | London | United Kingdom | North | Consumer | 2/4/2011 | Priority | England | -0.1277583 | 51.5073509 |
44 | BN-2011-2468159 | 2/2/2011 | Brandon Preston | Reims | France | Central | Consumer | 2/6/2011 | Economy | Alsace-Champagne-Ardenne-Lorraine | 4.031696 | 49.258329 |
45 | BN-2011-9336144 | 2/2/2011 | Lara Stoate | Rosenheim | Germany | Central | Corporate | 2/2/2011 | Immediate | Bavaria | 12.1181047 | 47.8571272 |
46 | BN-2011-7087921 | 2/3/2011 | Max Ludwig | Uppsala | Sweden | North | Home Office | 2/5/2011 | Economy Plus | Uppsala | 17.6389267 | 59.8585638 |
47 | AZ-2011-6835828 | 2/4/2011 | Summer Hayward | Nice | France | Central | Consumer | 2/8/2011 | Economy | Provence-Alpes-Côte d'Azur | 7.2619532 | 43.7101728 |
48 | AZ-2011-2397035 | 2/7/2011 | Millie Newman | Boulogne-sur-Mer | France | Central | Consumer | 2/11/2011 | Economy | Nord-Pas-de-Calais-Picardie | 1.613334 | 50.725231 |
49 | AZ-2011-9421435 | 2/7/2011 | Larry Klaus | La Crau | France | Central | Corporate | 2/12/2011 | Economy | Provence-Alpes-Côte d'Azur | 6.073127 | 43.147764 |
50 | AZ-2011-2956456 | 2/8/2011 | Shelby Dunston | Siena | Italy | South | Consumer | 2/13/2011 | Economy | Tuscany | 11.3307574 | 43.318809 |
51 | AZ-2011-9107304 | 2/9/2011 | Erin Gill | Barcelona | Spain | South | Home Office | 2/14/2011 | Economy | Catalonia | 2.1734035 | 41.3850639 |
52 | AZ-2011-2606042 | 2/9/2011 | Piper Wilder-Neligan | Frankfurt | Germany | Central | Consumer | 2/9/2011 | Immediate | Hesse | 8.6821267 | 50.1109221 |
53 | AZ-2011-5195846 | 2/9/2011 | Patricia Lukes | Almelo | Netherlands | Central | Corporate | 2/13/2011 | Economy | Overijssel | 6.6684919 | 52.3670267 |
54 | AZ-2011-7255147 | 2/10/2011 | Lilian Macredie | Basel | Switzerland | Central | Corporate | 2/14/2011 | Economy | Basel-Stadt | 7.5885761 | 47.5595986 |
55 | AZ-2011-5676694 | 2/10/2011 | Jasmine Slater | Coslada | Spain | South | Corporate | 2/15/2011 | Economy | Madrid | -3.5651646 | 40.4260459 |
56 | AZ-2011-819110 | 2/10/2011 | Charlotte Taylor | Marseille | France | Central | Consumer | 2/14/2011 | Economy | Provence-Alpes-Côte d'Azur | 5.36978 | 43.296482 |
57 | BN-2011-3032749 | 2/10/2011 | Victoria Bell | Hanover | Germany | Central | Home Office | 2/10/2011 | Immediate | Lower Saxony | 9.7320104 | 52.3758916 |
58 | AZ-2011-6048331 | 2/14/2011 | Kayleigh Farmer | Elda | Spain | South | Consumer | 2/19/2011 | Economy Plus | Valenciana | -0.7964597 | 38.4765073 |
59 | BN-2011-493873 | 2/15/2011 | Tyson Ebden | Hardenberg | Netherlands | Central | Consumer | 2/20/2011 | Economy | Overijssel | 6.6166947 | 52.5754084 |
60 | BN-2011-408191 | 2/15/2011 | Sophie Franklin | Seville | Spain | South | Corporate | 2/21/2011 | Economy | Andalusía | -5.9844589 | 37.3890924 |
61 | BN-2011-307477 | 2/16/2011 | Maya O'Sullivan | Muret | France | Central | Corporate | 2/19/2011 | Economy Plus | Languedoc-Roussillon-Midi-Pyrénées | 1.33071 | 43.461574 |
62 | AZ-2011-8122214 | 2/18/2011 | Ronald Everson | Beaune | France | Central | Corporate | 2/24/2011 | Economy | Bourgogne-Franche-Comté | 4.840004 | 47.02603 |
63 | AZ-2011-9155070 | 2/18/2011 | Julian Mack | Paris | France | Central | Consumer | 2/23/2011 | Economy | Ile-de-France | 2.3522219 | 48.856614 |
64 | AZ-2011-2939440 | 2/18/2011 | Tegan Savage | Castrop-Rauxel | Germany | Central | Consumer | 2/22/2011 | Economy Plus | North Rhine-Westphalia | 7.3150145 | 51.5632625 |
65 | AZ-2011-2270958 | 2/21/2011 | Eva Hargraves | Milan | Italy | South | Consumer | 2/26/2011 | Economy | Lombardy | 9.1859243 | 45.4654219 |
66 | BN-2011-555099 | 2/21/2011 | Jonathan Summons | Zurich | Switzerland | Central | Consumer | 2/25/2011 | Economy | Zürich | 8.541694 | 47.3768866 |
67 | AZ-2011-8091357 | 2/22/2011 | Darcy Farnell | Grosseto | Italy | South | Consumer | 2/26/2011 | Economy | Tuscany | 11.1123634 | 42.7635254 |
68 | AZ-2011-6186921 | 2/22/2011 | Katherine Grant | Paris | France | Central | Consumer | 2/24/2011 | Economy Plus | Ile-de-France | 2.3522219 | 48.856614 |
69 | BN-2011-5307099 | 2/22/2011 | Jared Wurster | Dublin | Ireland | North | Consumer | 2/27/2011 | Economy | Dublin | -6.2603097 | 53.3498053 |
70 | BN-2011-8574171 | 2/23/2011 | Kayla Ronald | Rome | Italy | South | Corporate | 2/28/2011 | Economy | Lazio | 12.4963655 | 41.9027835 |
71 | AZ-2011-8279503 | 2/24/2011 | Angus Reading | Namur | Belgium | Central | Corporate | 2/28/2011 | Economy | Namur | 4.8719854 | 50.4673883 |
72 | BN-2011-3728079 | 2/26/2011 | Jodie Mellor | Zaanstad | Netherlands | Central | Consumer | 3/4/2011 | Economy | North Holland | 4.7510425 | 52.4579659 |
73 | AZ-2011-2777408 | 3/1/2011 | Maya Summers | Bochum | Germany | Central | Home Office | 3/4/2011 | Economy Plus | North Rhine-Westphalia | 7.2162363 | 51.4818445 |
74 | AZ-2011-4069925 | 3/1/2011 | Oscar Clayton | Colmar | France | Central | Consumer | 3/8/2011 | Economy | Alsace-Champagne-Ardenne-Lorraine | 7.358512 | 48.0793589 |
75 | AZ-2011-7903656 | 3/1/2011 | Angus De Groot | Farnborough | United Kingdom | North | Corporate | 3/6/2011 | Economy | England | -0.752615 | 51.2868939 |
76 | AZ-2011-8074602 | 3/1/2011 | Caleb Kenyon | Berlin | Germany | Central | Corporate | 3/5/2011 | Economy | Berlin | 13.404954 | 52.5200066 |
77 | AZ-2011-1410648 | 3/1/2011 | Carl Proctor | Rome | Italy | South | Consumer | 3/5/2011 | Economy | Lazio | 12.4963655 | 41.9027835 |
78 | AZ-2011-496083 | 3/1/2011 | Spencer Akhtar | Berlin | Germany | Central | Consumer | 3/5/2011 | Economy | Berlin | 13.404954 | 52.5200066 |
79 | AZ-2011-6969006 | 3/3/2011 | Lincoln Want | Rimini | Italy | South | Consumer | 3/9/2011 | Economy | Emilia-Romagna | 12.5695158 | 44.0678288 |
80 | AZ-2011-5822789 | 3/7/2011 | Niamh Mann | Paris | France | Central | Consumer | 3/8/2011 | Priority | Ile-de-France | 2.3522219 | 48.856614 |
81 | AZ-2011-7677596 | 3/8/2011 | Nicole Nash | Baden-Baden | Germany | Central | Consumer | 3/13/2011 | Economy | Baden-Württemberg | 8.2285242 | 48.76564 |
82 | AZ-2011-3190941 | 3/9/2011 | Joshua Romero | Madrid | Spain | South | Consumer | 3/12/2011 | Priority | Madrid | -3.7037902 | 40.4167754 |
83 | AZ-2011-5422408 | 3/10/2011 | John Kemp | Pforzheim | Germany | Central | Home Office | 3/10/2011 | Immediate | Baden-Württemberg | 8.6946286 | 48.8921862 |
84 | AZ-2011-9147715 | 3/10/2011 | Ryan Greenwood | Sheffield | United Kingdom | North | Consumer | 3/14/2011 | Economy | England | -1.470085 | 53.381129 |
85 | AZ-2011-1278696 | 3/10/2011 | Naomi Hancock | Coventry | United Kingdom | North | Corporate | 3/17/2011 | Economy | England | -1.519693 | 52.406822 |
86 | AZ-2011-8295770 | 3/11/2011 | Thomas Stephens | Berlin | Germany | Central | Corporate | 3/14/2011 | Priority | Berlin | 13.404954 | 52.5200066 |
87 | AZ-2011-3714764 | 3/11/2011 | Ashton Charles | Pessac | France | Central | Consumer | 3/15/2011 | Economy | Aquitaine-Limousin-Poitou-Charentes | -0.630386 | 44.80583 |
88 | AZ-2011-4612792 | 3/12/2011 | Shannon Howe | Helsinki | Finland | North | Consumer | 3/19/2011 | Economy | Uusimaa | 24.938379 | 60.1698557 |
89 | AZ-2011-7682838 | 3/12/2011 | Joseph Ford | Basel | Switzerland | Central | Corporate | 3/17/2011 | Economy | Basel-Stadt | 7.5885761 | 47.5595986 |
90 | AZ-2011-9700826 | 3/14/2011 | Alexander Bennett | Berlin | Germany | Central | Corporate | 3/18/2011 | Economy | Berlin | 13.404954 | 52.5200066 |
91 | AZ-2011-6222257 | 3/14/2011 | Koby Phillip | Bonn | Germany | Central | Consumer | 3/16/2011 | Priority | North Rhine-Westphalia | 7.0982068 | 50.73743 |
92 | AZ-2011-823697 | 3/14/2011 | Thomas McCallum | Leipzig | Germany | Central | Consumer | 3/17/2011 | Economy Plus | Saxony | 12.3730747 | 51.3396955 |
93 | AZ-2011-5265250 | 3/14/2011 | Donna Nash | Tourcoing | France | Central | Corporate | 3/19/2011 | Economy Plus | Nord-Pas-de-Calais-Picardie | 3.16207 | 50.724993 |
94 | BN-2011-1399750 | 3/15/2011 | Wanda Wingert | London | United Kingdom | North | Consumer | 3/15/2011 | Immediate | England | -0.1277583 | 51.5073509 |
95 | AZ-2011-254910 | 3/16/2011 | Scarlett Truchanas | Bari | Italy | South | Corporate | 3/21/2011 | Economy | Apulia | 16.8718715 | 41.1171432 |
96 | AZ-2011-8252363 | 3/17/2011 | Jessica Paramor | Magdeburg | Germany | Central | Corporate | 3/23/2011 | Economy | Saxony-Anhalt | 11.6276237 | 52.1205333 |
97 | AZ-2011-1584987 | 3/18/2011 | Charlie Brooks | Marseille | France | Central | Consumer | 3/22/2011 | Economy | Provence-Alpes-Côte d'Azur | 5.36978 | 43.296482 |
98 | AZ-2011-4707711 | 3/18/2011 | Sam Wood | Noisy-le-Sec | France | Central | Home Office | 3/20/2011 | Priority | Ile-de-France | 2.458625 | 48.892489 |
99 | AZ-2011-7499604 | 3/21/2011 | Gabriel Sanders | Stavanger | Norway | North | Consumer | 3/26/2011 | Economy | Rogaland | 5.7331073 | 58.9699756 |
100 | AZ-2011-1916360 | 3/21/2011 | Charles Builder | Cagliari | Italy | South | Consumer | 3/23/2011 | Economy Plus | Sardinia | 9.1216613 | 39.2238411 |