LINQ To DataSet Samples - LINQ over TypedDataSet |
Simple query using typed dataset.
Public Sub DataSetLinq109()
Dim taEmployees As New NorthwindDataSetTableAdapters.EmployeesTableAdapter
Dim employees = taEmployees.GetData()
Dim results = From e In employees _
Where e.HireDate.Year > 1993 _
Select e _
Order By e.LastName
For Each emp In results
Console.WriteLine("Id = {0}, Name = {1},{2}, Hire Date = {3}", emp.EmployeeID, emp.LastName, emp.FirstName, emp.HireDate)
Next
End Sub
Result:
Id = 8, Name = Callahan,Laura, Hire Date = 3/5/1994 12:00:00 AM
Id = 9, Name = Dodsworth,Anne, Hire Date = 11/15/1994 12:00:00 AM
Id = 7, Name = King,Robert, Hire Date = 1/2/1994 12:00:00 AM
Projection using typed dataset.
Public Sub DataSetLinq110()
Dim taEmployees As New NorthwindDataSetTableAdapters.EmployeesTableAdapter
Dim employees = taEmployees.GetData()
Dim results = From e In employees _
Where e.HireDate.Year > 1993 _
Select New With { _
e.EmployeeID, _
.Name = e.LastName & ", " & e.FirstName, _
e.HireDate}
For Each emp In results
Console.WriteLine("Id = {0}, Name = {1}, Hire Date = {2}", emp.EmployeeID, emp.Name, emp.HireDate)
Next
End Sub
Result:
Id = 7, Name = King, Robert, Hire Date = 1/2/1994 12:00:00 AM
Id = 8, Name = Callahan, Laura, Hire Date = 3/5/1994 12:00:00 AM
Id = 9, Name = Dodsworth, Anne, Hire Date = 11/15/1994 12:00:00 AM
Load a existing DataTable with results from a Linq query over Typed DataTable
Public Sub DataSetLinq111()
Dim taEmployees As New NorthwindDataSetTableAdapters.EmployeesTableAdapter
Dim employees = taEmployees.GetData()
Dim query = From e In employees _
Where e.HireDate.Year > 1993 _
Select e
Dim tableWithFilterResults = query.CopyToDataTable()
PrettyPrintDataTable(tableWithFilterResults)
End Sub
Result:
Table:
EmployeeID = 7 LastName = King FirstName = Robert Title = Sales Representative TitleOfCourtesy = Mr. BirthDate = 5/29/1960 12:00:00 AM HireDate = 1/2/1994 12:00:00 AM Address = Edgeham Hollow
Winchester Way City = London Region = nothing PostalCode = RG1 9SP Country = UK HomePhone = (71) 555-5598 Extension = 465 Photo = System.Byte[] Notes = Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled "Selling in Europe," he was transferred to the London office in March 1993. ReportsTo = 5 PhotoPath = http://accweb/emmployees/davolio.bmp
EmployeeID = 8 LastName = Callahan FirstName = Laura Title = Inside Sales Coordinator TitleOfCourtesy = Ms. BirthDate = 1/9/1958 12:00:00 AM HireDate = 3/5/1994 12:00:00 AM Address = 4726 - 11th Ave. N.E. City = Seattle Region = WA PostalCode = 98105 Country = USA HomePhone = (206) 555-1189 Extension = 2344 Photo = System.Byte[] Notes = Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French. ReportsTo = 2 PhotoPath = http://accweb/emmployees/davolio.bmp
EmployeeID = 9 LastName = Dodsworth FirstName = Anne Title = Sales Representative TitleOfCourtesy = Ms. BirthDate = 1/27/1966 12:00:00 AM HireDate = 11/15/1994 12:00:00 AM Address = 7 Houndstooth Rd. City = London Region = nothing PostalCode = WG2 7LT Country = UK HomePhone = (71) 555-4444 Extension = 452 Photo = System.Byte[] Notes = Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German. ReportsTo = 5 PhotoPath = http://accweb/emmployees/davolio.bmp
Check for null values before refercing nullable columns in Typed DataSet
Public Sub DataSetLinq112()
Dim taOrders As New NorthwindDataSetTableAdapters.OrdersTableAdapter
Dim orders = taOrders.GetData()
Dim query = From o In orders _
Where Not (o.IsShippedDateNull) AndAlso _
DateDiff(DateInterval.Day, o.OrderDate, o.ShippedDate) > 7 _
Select o
Dim tableWithFilterResults = query.CopyToDataTable()
PrettyPrintDataTable(tableWithFilterResults)
End Sub
Result:
Table:
OrderID = 10248 CustomerID = VINET EmployeeID = 5 OrderDate = 7/4/1996 12:00:00 AM RequiredDate = 8/1/1996 12:00:00 AM ShippedDate = 7/16/1996 12:00:00 AM ShipVia = 3 Freight = 32.3800 ShipName = Vins et alcools Chevalier ShipAddress = 59 rue de l'Abbaye ShipCity = Reims ShipRegion = nothing ShipPostalCode = 51100 ShipCountry = France
OrderID = 10254 CustomerID = CHOPS EmployeeID = 5 OrderDate = 7/11/1996 12:00:00 AM RequiredDate = 8/8/1996 12:00:00 AM ShippedDate = 7/23/1996 12:00:00 AM ShipVia = 2 Freight = 22.9800 ShipName = Chop-suey Chinese ShipAddress = Hauptstr. 31 ShipCity = Bern ShipRegion = nothing ShipPostalCode = 3012 ShipCountry = Switzerland
OrderID = 10260 CustomerID = OTTIK EmployeeID = 4 OrderDate = 7/19/1996 12:00:00 AM RequiredDate = 8/16/1996 12:00:00 AM ShippedDate = 7/29/1996 12:00:00 AM ShipVia = 1 Freight = 55.0900 ShipName = Ottilies Käseladen ShipAddress = Mehrheimerstr. 369 ShipCity = Köln ShipRegion = nothing ShipPostalCode = 50739 ShipCountry = Germany
OrderID = 10261 CustomerID = QUEDE EmployeeID = 4 OrderDate = 7/19/1996 12:00:00 AM RequiredDate = 8/16/1996 12:00:00 AM ShippedDate = 7/30/1996 12:00:00 AM ShipVia = 2 Freight = 3.0500 ShipName = Que Delícia ShipAddress = Rua da Panificadora, 12 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-673 ShipCountry = Brazil
OrderID = 10263 CustomerID = ERNSH EmployeeID = 9 OrderDate = 7/23/1996 12:00:00 AM RequiredDate = 8/20/1996 12:00:00 AM ShippedDate = 7/31/1996 12:00:00 AM ShipVia = 3 Freight = 146.0600 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10264 CustomerID = FOLKO EmployeeID = 6 OrderDate = 7/24/1996 12:00:00 AM RequiredDate = 8/21/1996 12:00:00 AM ShippedDate = 8/23/1996 12:00:00 AM ShipVia = 3 Freight = 3.6700 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10265 CustomerID = BLONP EmployeeID = 2 OrderDate = 7/25/1996 12:00:00 AM RequiredDate = 8/22/1996 12:00:00 AM ShippedDate = 8/12/1996 12:00:00 AM ShipVia = 1 Freight = 55.2800 ShipName = Blondel père et fils ShipAddress = 24, place Kléber ShipCity = Strasbourg ShipRegion = nothing ShipPostalCode = 67000 ShipCountry = France
OrderID = 10267 CustomerID = FRANK EmployeeID = 4 OrderDate = 7/29/1996 12:00:00 AM RequiredDate = 8/26/1996 12:00:00 AM ShippedDate = 8/6/1996 12:00:00 AM ShipVia = 1 Freight = 208.5800 ShipName = Frankenversand ShipAddress = Berliner Platz 43 ShipCity = München ShipRegion = nothing ShipPostalCode = 80805 ShipCountry = Germany
OrderID = 10269 CustomerID = WHITC EmployeeID = 5 OrderDate = 7/31/1996 12:00:00 AM RequiredDate = 8/14/1996 12:00:00 AM ShippedDate = 8/9/1996 12:00:00 AM ShipVia = 1 Freight = 4.5600 ShipName = White Clover Markets ShipAddress = 1029 - 12th Ave. S. ShipCity = Seattle ShipRegion = WA ShipPostalCode = 98124 ShipCountry = USA
OrderID = 10271 CustomerID = SPLIR EmployeeID = 6 OrderDate = 8/1/1996 12:00:00 AM RequiredDate = 8/29/1996 12:00:00 AM ShippedDate = 8/30/1996 12:00:00 AM ShipVia = 2 Freight = 4.5400 ShipName = Split Rail Beer & Ale ShipAddress = P.O. Box 555 ShipCity = Lander ShipRegion = WY ShipPostalCode = 82520 ShipCountry = USA
OrderID = 10274 CustomerID = VINET EmployeeID = 6 OrderDate = 8/6/1996 12:00:00 AM RequiredDate = 9/3/1996 12:00:00 AM ShippedDate = 8/16/1996 12:00:00 AM ShipVia = 1 Freight = 6.0100 ShipName = Vins et alcools Chevalier ShipAddress = 59 rue de l'Abbaye ShipCity = Reims ShipRegion = nothing ShipPostalCode = 51100 ShipCountry = France
OrderID = 10280 CustomerID = BERGS EmployeeID = 2 OrderDate = 8/14/1996 12:00:00 AM RequiredDate = 9/11/1996 12:00:00 AM ShippedDate = 9/12/1996 12:00:00 AM ShipVia = 1 Freight = 8.9800 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10284 CustomerID = LEHMS EmployeeID = 4 OrderDate = 8/19/1996 12:00:00 AM RequiredDate = 9/16/1996 12:00:00 AM ShippedDate = 8/27/1996 12:00:00 AM ShipVia = 1 Freight = 76.5600 ShipName = Lehmanns Marktstand ShipAddress = Magazinweg 7 ShipCity = Frankfurt a.M. ShipRegion = nothing ShipPostalCode = 60528 ShipCountry = Germany
OrderID = 10286 CustomerID = QUICK EmployeeID = 8 OrderDate = 8/21/1996 12:00:00 AM RequiredDate = 9/18/1996 12:00:00 AM ShippedDate = 8/30/1996 12:00:00 AM ShipVia = 3 Freight = 229.2400 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10288 CustomerID = REGGC EmployeeID = 4 OrderDate = 8/23/1996 12:00:00 AM RequiredDate = 9/20/1996 12:00:00 AM ShippedDate = 9/3/1996 12:00:00 AM ShipVia = 1 Freight = 7.4500 ShipName = Reggiani Caseifici ShipAddress = Strada Provinciale 124 ShipCity = Reggio Emilia ShipRegion = nothing ShipPostalCode = 42100 ShipCountry = Italy
OrderID = 10291 CustomerID = QUEDE EmployeeID = 6 OrderDate = 8/27/1996 12:00:00 AM RequiredDate = 9/24/1996 12:00:00 AM ShippedDate = 9/4/1996 12:00:00 AM ShipVia = 2 Freight = 6.4000 ShipName = Que Delícia ShipAddress = Rua da Panificadora, 12 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-673 ShipCountry = Brazil
OrderID = 10293 CustomerID = TORTU EmployeeID = 1 OrderDate = 8/29/1996 12:00:00 AM RequiredDate = 9/26/1996 12:00:00 AM ShippedDate = 9/11/1996 12:00:00 AM ShipVia = 3 Freight = 21.1800 ShipName = Tortuga Restaurante ShipAddress = Avda. Azteca 123 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05033 ShipCountry = Mexico
OrderID = 10295 CustomerID = VINET EmployeeID = 2 OrderDate = 9/2/1996 12:00:00 AM RequiredDate = 9/30/1996 12:00:00 AM ShippedDate = 9/10/1996 12:00:00 AM ShipVia = 2 Freight = 1.1500 ShipName = Vins et alcools Chevalier ShipAddress = 59 rue de l'Abbaye ShipCity = Reims ShipRegion = nothing ShipPostalCode = 51100 ShipCountry = France
OrderID = 10296 CustomerID = LILAS EmployeeID = 6 OrderDate = 9/3/1996 12:00:00 AM RequiredDate = 10/1/1996 12:00:00 AM ShippedDate = 9/11/1996 12:00:00 AM ShipVia = 1 Freight = 0.1200 ShipName = LILA-Supermercado ShipAddress = Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity = Barquisimeto ShipRegion = Lara ShipPostalCode = 3508 ShipCountry = Venezuela
OrderID = 10300 CustomerID = MAGAA EmployeeID = 2 OrderDate = 9/9/1996 12:00:00 AM RequiredDate = 10/7/1996 12:00:00 AM ShippedDate = 9/18/1996 12:00:00 AM ShipVia = 2 Freight = 17.6800 ShipName = Magazzini Alimentari Riuniti ShipAddress = Via Ludovico il Moro 22 ShipCity = Bergamo ShipRegion = nothing ShipPostalCode = 24100 ShipCountry = Italy
OrderID = 10301 CustomerID = WANDK EmployeeID = 8 OrderDate = 9/9/1996 12:00:00 AM RequiredDate = 10/7/1996 12:00:00 AM ShippedDate = 9/17/1996 12:00:00 AM ShipVia = 2 Freight = 45.0800 ShipName = Die Wandernde Kuh ShipAddress = Adenauerallee 900 ShipCity = Stuttgart ShipRegion = nothing ShipPostalCode = 70563 ShipCountry = Germany
OrderID = 10302 CustomerID = SUPRD EmployeeID = 4 OrderDate = 9/10/1996 12:00:00 AM RequiredDate = 10/8/1996 12:00:00 AM ShippedDate = 10/9/1996 12:00:00 AM ShipVia = 2 Freight = 6.2700 ShipName = Suprêmes délices ShipAddress = Boulevard Tirou, 255 ShipCity = Charleroi ShipRegion = nothing ShipPostalCode = B-6000 ShipCountry = Belgium
OrderID = 10305 CustomerID = OLDWO EmployeeID = 8 OrderDate = 9/13/1996 12:00:00 AM RequiredDate = 10/11/1996 12:00:00 AM ShippedDate = 10/9/1996 12:00:00 AM ShipVia = 3 Freight = 257.6200 ShipName = Old World Delicatessen ShipAddress = 2743 Bering St. ShipCity = Anchorage ShipRegion = AK ShipPostalCode = 99508 ShipCountry = USA
OrderID = 10307 CustomerID = LONEP EmployeeID = 2 OrderDate = 9/17/1996 12:00:00 AM RequiredDate = 10/15/1996 12:00:00 AM ShippedDate = 9/25/1996 12:00:00 AM ShipVia = 2 Freight = 0.5600 ShipName = Lonesome Pine Restaurant ShipAddress = 89 Chiaroscuro Rd. ShipCity = Portland ShipRegion = OR ShipPostalCode = 97219 ShipCountry = USA
OrderID = 10309 CustomerID = HUNGO EmployeeID = 3 OrderDate = 9/19/1996 12:00:00 AM RequiredDate = 10/17/1996 12:00:00 AM ShippedDate = 10/23/1996 12:00:00 AM ShipVia = 1 Freight = 47.3000 ShipName = Hungry Owl All-Night Grocers ShipAddress = 8 Johnstown Road ShipCity = Cork ShipRegion = Co. Cork ShipPostalCode = nothing ShipCountry = Ireland
OrderID = 10312 CustomerID = WANDK EmployeeID = 2 OrderDate = 9/23/1996 12:00:00 AM RequiredDate = 10/21/1996 12:00:00 AM ShippedDate = 10/3/1996 12:00:00 AM ShipVia = 2 Freight = 40.2600 ShipName = Die Wandernde Kuh ShipAddress = Adenauerallee 900 ShipCity = Stuttgart ShipRegion = nothing ShipPostalCode = 70563 ShipCountry = Germany
OrderID = 10313 CustomerID = QUICK EmployeeID = 2 OrderDate = 9/24/1996 12:00:00 AM RequiredDate = 10/22/1996 12:00:00 AM ShippedDate = 10/4/1996 12:00:00 AM ShipVia = 2 Freight = 1.9600 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10314 CustomerID = RATTC EmployeeID = 1 OrderDate = 9/25/1996 12:00:00 AM RequiredDate = 10/23/1996 12:00:00 AM ShippedDate = 10/4/1996 12:00:00 AM ShipVia = 2 Freight = 74.1600 ShipName = Rattlesnake Canyon Grocery ShipAddress = 2817 Milton Dr. ShipCity = Albuquerque ShipRegion = NM ShipPostalCode = 87110 ShipCountry = USA
OrderID = 10316 CustomerID = RATTC EmployeeID = 1 OrderDate = 9/27/1996 12:00:00 AM RequiredDate = 10/25/1996 12:00:00 AM ShippedDate = 10/8/1996 12:00:00 AM ShipVia = 3 Freight = 150.1500 ShipName = Rattlesnake Canyon Grocery ShipAddress = 2817 Milton Dr. ShipCity = Albuquerque ShipRegion = NM ShipPostalCode = 87110 ShipCountry = USA
OrderID = 10317 CustomerID = LONEP EmployeeID = 6 OrderDate = 9/30/1996 12:00:00 AM RequiredDate = 10/28/1996 12:00:00 AM ShippedDate = 10/10/1996 12:00:00 AM ShipVia = 1 Freight = 12.6900 ShipName = Lonesome Pine Restaurant ShipAddress = 89 Chiaroscuro Rd. ShipCity = Portland ShipRegion = OR ShipPostalCode = 97219 ShipCountry = USA
OrderID = 10319 CustomerID = TORTU EmployeeID = 7 OrderDate = 10/2/1996 12:00:00 AM RequiredDate = 10/30/1996 12:00:00 AM ShippedDate = 10/11/1996 12:00:00 AM ShipVia = 3 Freight = 64.5000 ShipName = Tortuga Restaurante ShipAddress = Avda. Azteca 123 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05033 ShipCountry = Mexico
OrderID = 10320 CustomerID = WARTH EmployeeID = 5 OrderDate = 10/3/1996 12:00:00 AM RequiredDate = 10/17/1996 12:00:00 AM ShippedDate = 10/18/1996 12:00:00 AM ShipVia = 3 Freight = 34.5700 ShipName = Wartian Herkku ShipAddress = Torikatu 38 ShipCity = Oulu ShipRegion = nothing ShipPostalCode = 90110 ShipCountry = Finland
OrderID = 10321 CustomerID = ISLAT EmployeeID = 3 OrderDate = 10/3/1996 12:00:00 AM RequiredDate = 10/31/1996 12:00:00 AM ShippedDate = 10/11/1996 12:00:00 AM ShipVia = 2 Freight = 3.4300 ShipName = Island Trading ShipAddress = Garden House Crowther Way ShipCity = Cowes ShipRegion = Isle of Wight ShipPostalCode = PO31 7PJ ShipCountry = UK
OrderID = 10322 CustomerID = PERIC EmployeeID = 7 OrderDate = 10/4/1996 12:00:00 AM RequiredDate = 11/1/1996 12:00:00 AM ShippedDate = 10/23/1996 12:00:00 AM ShipVia = 3 Freight = 0.4000 ShipName = Pericles Comidas clásicas ShipAddress = Calle Dr. Jorge Cash 321 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05033 ShipCountry = Mexico
OrderID = 10329 CustomerID = SPLIR EmployeeID = 4 OrderDate = 10/15/1996 12:00:00 AM RequiredDate = 11/26/1996 12:00:00 AM ShippedDate = 10/23/1996 12:00:00 AM ShipVia = 2 Freight = 191.6700 ShipName = Split Rail Beer & Ale ShipAddress = P.O. Box 555 ShipCity = Lander ShipRegion = WY ShipPostalCode = 82520 ShipCountry = USA
OrderID = 10330 CustomerID = LILAS EmployeeID = 3 OrderDate = 10/16/1996 12:00:00 AM RequiredDate = 11/13/1996 12:00:00 AM ShippedDate = 10/28/1996 12:00:00 AM ShipVia = 1 Freight = 12.7500 ShipName = LILA-Supermercado ShipAddress = Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity = Barquisimeto ShipRegion = Lara ShipPostalCode = 3508 ShipCountry = Venezuela
OrderID = 10340 CustomerID = BONAP EmployeeID = 1 OrderDate = 10/29/1996 12:00:00 AM RequiredDate = 11/26/1996 12:00:00 AM ShippedDate = 11/8/1996 12:00:00 AM ShipVia = 3 Freight = 166.3100 ShipName = Bon app' ShipAddress = 12, rue des Bouchers ShipCity = Marseille ShipRegion = nothing ShipPostalCode = 13008 ShipCountry = France
OrderID = 10348 CustomerID = WANDK EmployeeID = 4 OrderDate = 11/7/1996 12:00:00 AM RequiredDate = 12/5/1996 12:00:00 AM ShippedDate = 11/15/1996 12:00:00 AM ShipVia = 2 Freight = 0.7800 ShipName = Die Wandernde Kuh ShipAddress = Adenauerallee 900 ShipCity = Stuttgart ShipRegion = nothing ShipPostalCode = 70563 ShipCountry = Germany
OrderID = 10350 CustomerID = LAMAI EmployeeID = 6 OrderDate = 11/11/1996 12:00:00 AM RequiredDate = 12/9/1996 12:00:00 AM ShippedDate = 12/3/1996 12:00:00 AM ShipVia = 2 Freight = 64.1900 ShipName = La maison d'Asie ShipAddress = 1 rue Alsace-Lorraine ShipCity = Toulouse ShipRegion = nothing ShipPostalCode = 31000 ShipCountry = France
OrderID = 10351 CustomerID = ERNSH EmployeeID = 1 OrderDate = 11/11/1996 12:00:00 AM RequiredDate = 12/9/1996 12:00:00 AM ShippedDate = 11/20/1996 12:00:00 AM ShipVia = 1 Freight = 162.3300 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10353 CustomerID = PICCO EmployeeID = 7 OrderDate = 11/13/1996 12:00:00 AM RequiredDate = 12/11/1996 12:00:00 AM ShippedDate = 11/25/1996 12:00:00 AM ShipVia = 3 Freight = 360.6300 ShipName = Piccolo und mehr ShipAddress = Geislweg 14 ShipCity = Salzburg ShipRegion = nothing ShipPostalCode = 5020 ShipCountry = Austria
OrderID = 10356 CustomerID = WANDK EmployeeID = 6 OrderDate = 11/18/1996 12:00:00 AM RequiredDate = 12/16/1996 12:00:00 AM ShippedDate = 11/27/1996 12:00:00 AM ShipVia = 2 Freight = 36.7100 ShipName = Die Wandernde Kuh ShipAddress = Adenauerallee 900 ShipCity = Stuttgart ShipRegion = nothing ShipPostalCode = 70563 ShipCountry = Germany
OrderID = 10357 CustomerID = LILAS EmployeeID = 1 OrderDate = 11/19/1996 12:00:00 AM RequiredDate = 12/17/1996 12:00:00 AM ShippedDate = 12/2/1996 12:00:00 AM ShipVia = 3 Freight = 34.8800 ShipName = LILA-Supermercado ShipAddress = Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity = Barquisimeto ShipRegion = Lara ShipPostalCode = 3508 ShipCountry = Venezuela
OrderID = 10360 CustomerID = BLONP EmployeeID = 4 OrderDate = 11/22/1996 12:00:00 AM RequiredDate = 12/20/1996 12:00:00 AM ShippedDate = 12/2/1996 12:00:00 AM ShipVia = 3 Freight = 131.7000 ShipName = Blondel père et fils ShipAddress = 24, place Kléber ShipCity = Strasbourg ShipRegion = nothing ShipPostalCode = 67000 ShipCountry = France
OrderID = 10361 CustomerID = QUICK EmployeeID = 1 OrderDate = 11/22/1996 12:00:00 AM RequiredDate = 12/20/1996 12:00:00 AM ShippedDate = 12/3/1996 12:00:00 AM ShipVia = 2 Freight = 183.1700 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10363 CustomerID = DRACD EmployeeID = 4 OrderDate = 11/26/1996 12:00:00 AM RequiredDate = 12/24/1996 12:00:00 AM ShippedDate = 12/4/1996 12:00:00 AM ShipVia = 3 Freight = 30.5400 ShipName = Drachenblut Delikatessen ShipAddress = Walserweg 21 ShipCity = Aachen ShipRegion = nothing ShipPostalCode = 52066 ShipCountry = Germany
OrderID = 10364 CustomerID = EASTC EmployeeID = 1 OrderDate = 11/26/1996 12:00:00 AM RequiredDate = 1/7/1997 12:00:00 AM ShippedDate = 12/4/1996 12:00:00 AM ShipVia = 1 Freight = 71.9700 ShipName = Eastern Connection ShipAddress = 35 King George ShipCity = London ShipRegion = nothing ShipPostalCode = WX3 6FW ShipCountry = UK
OrderID = 10366 CustomerID = GALED EmployeeID = 8 OrderDate = 11/28/1996 12:00:00 AM RequiredDate = 1/9/1997 12:00:00 AM ShippedDate = 12/30/1996 12:00:00 AM ShipVia = 2 Freight = 10.1400 ShipName = Galería del gastronómo ShipAddress = Rambla de Cataluña, 23 ShipCity = Barcelona ShipRegion = nothing ShipPostalCode = 8022 ShipCountry = Spain
OrderID = 10370 CustomerID = CHOPS EmployeeID = 6 OrderDate = 12/3/1996 12:00:00 AM RequiredDate = 12/31/1996 12:00:00 AM ShippedDate = 12/27/1996 12:00:00 AM ShipVia = 2 Freight = 1.1700 ShipName = Chop-suey Chinese ShipAddress = Hauptstr. 31 ShipCity = Bern ShipRegion = nothing ShipPostalCode = 3012 ShipCountry = Switzerland
OrderID = 10371 CustomerID = LAMAI EmployeeID = 1 OrderDate = 12/3/1996 12:00:00 AM RequiredDate = 12/31/1996 12:00:00 AM ShippedDate = 12/24/1996 12:00:00 AM ShipVia = 1 Freight = 0.4500 ShipName = La maison d'Asie ShipAddress = 1 rue Alsace-Lorraine ShipCity = Toulouse ShipRegion = nothing ShipPostalCode = 31000 ShipCountry = France
OrderID = 10378 CustomerID = FOLKO EmployeeID = 5 OrderDate = 12/10/1996 12:00:00 AM RequiredDate = 1/7/1997 12:00:00 AM ShippedDate = 12/19/1996 12:00:00 AM ShipVia = 3 Freight = 5.4400 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10380 CustomerID = HUNGO EmployeeID = 8 OrderDate = 12/12/1996 12:00:00 AM RequiredDate = 1/9/1997 12:00:00 AM ShippedDate = 1/16/1997 12:00:00 AM ShipVia = 3 Freight = 35.0300 ShipName = Hungry Owl All-Night Grocers ShipAddress = 8 Johnstown Road ShipCity = Cork ShipRegion = Co. Cork ShipPostalCode = nothing ShipCountry = Ireland
OrderID = 10391 CustomerID = DRACD EmployeeID = 3 OrderDate = 12/23/1996 12:00:00 AM RequiredDate = 1/20/1997 12:00:00 AM ShippedDate = 12/31/1996 12:00:00 AM ShipVia = 3 Freight = 5.4500 ShipName = Drachenblut Delikatessen ShipAddress = Walserweg 21 ShipCity = Aachen ShipRegion = nothing ShipPostalCode = 52066 ShipCountry = Germany
OrderID = 10392 CustomerID = PICCO EmployeeID = 2 OrderDate = 12/24/1996 12:00:00 AM RequiredDate = 1/21/1997 12:00:00 AM ShippedDate = 1/1/1997 12:00:00 AM ShipVia = 3 Freight = 122.4600 ShipName = Piccolo und mehr ShipAddress = Geislweg 14 ShipCity = Salzburg ShipRegion = nothing ShipPostalCode = 5020 ShipCountry = Austria
OrderID = 10393 CustomerID = SAVEA EmployeeID = 1 OrderDate = 12/25/1996 12:00:00 AM RequiredDate = 1/22/1997 12:00:00 AM ShippedDate = 1/3/1997 12:00:00 AM ShipVia = 3 Freight = 126.5600 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10394 CustomerID = HUNGC EmployeeID = 1 OrderDate = 12/25/1996 12:00:00 AM RequiredDate = 1/22/1997 12:00:00 AM ShippedDate = 1/3/1997 12:00:00 AM ShipVia = 3 Freight = 30.3400 ShipName = Hungry Coyote Import Store ShipAddress = City Center Plaza 516 Main St. ShipCity = Elgin ShipRegion = OR ShipPostalCode = 97827 ShipCountry = USA
OrderID = 10395 CustomerID = HILAA EmployeeID = 6 OrderDate = 12/26/1996 12:00:00 AM RequiredDate = 1/23/1997 12:00:00 AM ShippedDate = 1/3/1997 12:00:00 AM ShipVia = 1 Freight = 184.4100 ShipName = HILARION-Abastos ShipAddress = Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity = San Cristóbal ShipRegion = Táchira ShipPostalCode = 5022 ShipCountry = Venezuela
OrderID = 10396 CustomerID = FRANK EmployeeID = 1 OrderDate = 12/27/1996 12:00:00 AM RequiredDate = 1/10/1997 12:00:00 AM ShippedDate = 1/6/1997 12:00:00 AM ShipVia = 3 Freight = 135.3500 ShipName = Frankenversand ShipAddress = Berliner Platz 43 ShipCity = München ShipRegion = nothing ShipPostalCode = 80805 ShipCountry = Germany
OrderID = 10398 CustomerID = SAVEA EmployeeID = 2 OrderDate = 12/30/1996 12:00:00 AM RequiredDate = 1/27/1997 12:00:00 AM ShippedDate = 1/9/1997 12:00:00 AM ShipVia = 3 Freight = 89.1600 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10399 CustomerID = VAFFE EmployeeID = 8 OrderDate = 12/31/1996 12:00:00 AM RequiredDate = 1/14/1997 12:00:00 AM ShippedDate = 1/8/1997 12:00:00 AM ShipVia = 3 Freight = 27.3600 ShipName = Vaffeljernet ShipAddress = Smagsloget 45 ShipCity = Århus ShipRegion = nothing ShipPostalCode = 8200 ShipCountry = Denmark
OrderID = 10400 CustomerID = EASTC EmployeeID = 1 OrderDate = 1/1/1997 12:00:00 AM RequiredDate = 1/29/1997 12:00:00 AM ShippedDate = 1/16/1997 12:00:00 AM ShipVia = 3 Freight = 83.9300 ShipName = Eastern Connection ShipAddress = 35 King George ShipCity = London ShipRegion = nothing ShipPostalCode = WX3 6FW ShipCountry = UK
OrderID = 10401 CustomerID = RATTC EmployeeID = 1 OrderDate = 1/1/1997 12:00:00 AM RequiredDate = 1/29/1997 12:00:00 AM ShippedDate = 1/10/1997 12:00:00 AM ShipVia = 1 Freight = 12.5100 ShipName = Rattlesnake Canyon Grocery ShipAddress = 2817 Milton Dr. ShipCity = Albuquerque ShipRegion = NM ShipPostalCode = 87110 ShipCountry = USA
OrderID = 10402 CustomerID = ERNSH EmployeeID = 8 OrderDate = 1/2/1997 12:00:00 AM RequiredDate = 2/13/1997 12:00:00 AM ShippedDate = 1/10/1997 12:00:00 AM ShipVia = 2 Freight = 67.8800 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10405 CustomerID = LINOD EmployeeID = 1 OrderDate = 1/6/1997 12:00:00 AM RequiredDate = 2/3/1997 12:00:00 AM ShippedDate = 1/22/1997 12:00:00 AM ShipVia = 1 Freight = 34.8200 ShipName = LINO-Delicateses ShipAddress = Ave. 5 de Mayo Porlamar ShipCity = I. de Margarita ShipRegion = Nueva Esparta ShipPostalCode = 4980 ShipCountry = Venezuela
OrderID = 10407 CustomerID = OTTIK EmployeeID = 2 OrderDate = 1/7/1997 12:00:00 AM RequiredDate = 2/4/1997 12:00:00 AM ShippedDate = 1/30/1997 12:00:00 AM ShipVia = 2 Freight = 91.4800 ShipName = Ottilies Käseladen ShipAddress = Mehrheimerstr. 369 ShipCity = Köln ShipRegion = nothing ShipPostalCode = 50739 ShipCountry = Germany
OrderID = 10411 CustomerID = BOTTM EmployeeID = 9 OrderDate = 1/10/1997 12:00:00 AM RequiredDate = 2/7/1997 12:00:00 AM ShippedDate = 1/21/1997 12:00:00 AM ShipVia = 3 Freight = 23.6500 ShipName = Bottom-Dollar Markets ShipAddress = 23 Tsawassen Blvd. ShipCity = Tsawassen ShipRegion = BC ShipPostalCode = T2F 8M4 ShipCountry = Canada
OrderID = 10415 CustomerID = HUNGC EmployeeID = 3 OrderDate = 1/15/1997 12:00:00 AM RequiredDate = 2/12/1997 12:00:00 AM ShippedDate = 1/24/1997 12:00:00 AM ShipVia = 1 Freight = 0.2000 ShipName = Hungry Coyote Import Store ShipAddress = City Center Plaza 516 Main St. ShipCity = Elgin ShipRegion = OR ShipPostalCode = 97827 ShipCountry = USA
OrderID = 10416 CustomerID = WARTH EmployeeID = 8 OrderDate = 1/16/1997 12:00:00 AM RequiredDate = 2/13/1997 12:00:00 AM ShippedDate = 1/27/1997 12:00:00 AM ShipVia = 3 Freight = 22.7200 ShipName = Wartian Herkku ShipAddress = Torikatu 38 ShipCity = Oulu ShipRegion = nothing ShipPostalCode = 90110 ShipCountry = Finland
OrderID = 10417 CustomerID = SIMOB EmployeeID = 4 OrderDate = 1/16/1997 12:00:00 AM RequiredDate = 2/13/1997 12:00:00 AM ShippedDate = 1/28/1997 12:00:00 AM ShipVia = 3 Freight = 70.2900 ShipName = Simons bistro ShipAddress = Vinbæltet 34 ShipCity = Kobenhavn ShipRegion = nothing ShipPostalCode = 1734 ShipCountry = Denmark
OrderID = 10419 CustomerID = RICSU EmployeeID = 4 OrderDate = 1/20/1997 12:00:00 AM RequiredDate = 2/17/1997 12:00:00 AM ShippedDate = 1/30/1997 12:00:00 AM ShipVia = 2 Freight = 137.3500 ShipName = Richter Supermarkt ShipAddress = Starenweg 5 ShipCity = Genève ShipRegion = nothing ShipPostalCode = 1204 ShipCountry = Switzerland
OrderID = 10422 CustomerID = FRANS EmployeeID = 2 OrderDate = 1/22/1997 12:00:00 AM RequiredDate = 2/19/1997 12:00:00 AM ShippedDate = 1/31/1997 12:00:00 AM ShipVia = 1 Freight = 3.0200 ShipName = Franchi S.p.A. ShipAddress = Via Monte Bianco 34 ShipCity = Torino ShipRegion = nothing ShipPostalCode = 10100 ShipCountry = Italy
OrderID = 10423 CustomerID = GOURL EmployeeID = 6 OrderDate = 1/23/1997 12:00:00 AM RequiredDate = 2/6/1997 12:00:00 AM ShippedDate = 2/24/1997 12:00:00 AM ShipVia = 3 Freight = 24.5000 ShipName = Gourmet Lanchonetes ShipAddress = Av. Brasil, 442 ShipCity = Campinas ShipRegion = SP ShipPostalCode = 04876-786 ShipCountry = Brazil
OrderID = 10425 CustomerID = LAMAI EmployeeID = 6 OrderDate = 1/24/1997 12:00:00 AM RequiredDate = 2/21/1997 12:00:00 AM ShippedDate = 2/14/1997 12:00:00 AM ShipVia = 2 Freight = 7.9300 ShipName = La maison d'Asie ShipAddress = 1 rue Alsace-Lorraine ShipCity = Toulouse ShipRegion = nothing ShipPostalCode = 31000 ShipCountry = France
OrderID = 10426 CustomerID = GALED EmployeeID = 4 OrderDate = 1/27/1997 12:00:00 AM RequiredDate = 2/24/1997 12:00:00 AM ShippedDate = 2/6/1997 12:00:00 AM ShipVia = 1 Freight = 18.6900 ShipName = Galería del gastronómo ShipAddress = Rambla de Cataluña, 23 ShipCity = Barcelona ShipRegion = nothing ShipPostalCode = 8022 ShipCountry = Spain
OrderID = 10427 CustomerID = PICCO EmployeeID = 4 OrderDate = 1/27/1997 12:00:00 AM RequiredDate = 2/24/1997 12:00:00 AM ShippedDate = 3/3/1997 12:00:00 AM ShipVia = 2 Freight = 31.2900 ShipName = Piccolo und mehr ShipAddress = Geislweg 14 ShipCity = Salzburg ShipRegion = nothing ShipPostalCode = 5020 ShipCountry = Austria
OrderID = 10429 CustomerID = HUNGO EmployeeID = 3 OrderDate = 1/29/1997 12:00:00 AM RequiredDate = 3/12/1997 12:00:00 AM ShippedDate = 2/7/1997 12:00:00 AM ShipVia = 2 Freight = 56.6300 ShipName = Hungry Owl All-Night Grocers ShipAddress = 8 Johnstown Road ShipCity = Cork ShipRegion = Co. Cork ShipPostalCode = nothing ShipCountry = Ireland
OrderID = 10431 CustomerID = BOTTM EmployeeID = 4 OrderDate = 1/30/1997 12:00:00 AM RequiredDate = 2/13/1997 12:00:00 AM ShippedDate = 2/7/1997 12:00:00 AM ShipVia = 2 Freight = 44.1700 ShipName = Bottom-Dollar Markets ShipAddress = 23 Tsawassen Blvd. ShipCity = Tsawassen ShipRegion = BC ShipPostalCode = T2F 8M4 ShipCountry = Canada
OrderID = 10433 CustomerID = PRINI EmployeeID = 3 OrderDate = 2/3/1997 12:00:00 AM RequiredDate = 3/3/1997 12:00:00 AM ShippedDate = 3/4/1997 12:00:00 AM ShipVia = 3 Freight = 73.8300 ShipName = Princesa Isabel Vinhos ShipAddress = Estrada da saúde n. 58 ShipCity = Lisboa ShipRegion = nothing ShipPostalCode = 1756 ShipCountry = Portugal
OrderID = 10434 CustomerID = FOLKO EmployeeID = 3 OrderDate = 2/3/1997 12:00:00 AM RequiredDate = 3/3/1997 12:00:00 AM ShippedDate = 2/13/1997 12:00:00 AM ShipVia = 2 Freight = 17.9200 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10438 CustomerID = TOMSP EmployeeID = 3 OrderDate = 2/6/1997 12:00:00 AM RequiredDate = 3/6/1997 12:00:00 AM ShippedDate = 2/14/1997 12:00:00 AM ShipVia = 2 Freight = 8.2400 ShipName = Toms Spezialitäten ShipAddress = Luisenstr. 48 ShipCity = Münster ShipRegion = nothing ShipPostalCode = 44087 ShipCountry = Germany
OrderID = 10440 CustomerID = SAVEA EmployeeID = 4 OrderDate = 2/10/1997 12:00:00 AM RequiredDate = 3/10/1997 12:00:00 AM ShippedDate = 2/28/1997 12:00:00 AM ShipVia = 2 Freight = 86.5300 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10441 CustomerID = OLDWO EmployeeID = 3 OrderDate = 2/10/1997 12:00:00 AM RequiredDate = 3/24/1997 12:00:00 AM ShippedDate = 3/14/1997 12:00:00 AM ShipVia = 2 Freight = 73.0200 ShipName = Old World Delicatessen ShipAddress = 2743 Bering St. ShipCity = Anchorage ShipRegion = AK ShipPostalCode = 99508 ShipCountry = USA
OrderID = 10444 CustomerID = BERGS EmployeeID = 3 OrderDate = 2/12/1997 12:00:00 AM RequiredDate = 3/12/1997 12:00:00 AM ShippedDate = 2/21/1997 12:00:00 AM ShipVia = 3 Freight = 3.5000 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10447 CustomerID = RICAR EmployeeID = 4 OrderDate = 2/14/1997 12:00:00 AM RequiredDate = 3/14/1997 12:00:00 AM ShippedDate = 3/7/1997 12:00:00 AM ShipVia = 2 Freight = 68.6600 ShipName = Ricardo Adocicados ShipAddress = Av. Copacabana, 267 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-890 ShipCountry = Brazil
OrderID = 10449 CustomerID = BLONP EmployeeID = 3 OrderDate = 2/18/1997 12:00:00 AM RequiredDate = 3/18/1997 12:00:00 AM ShippedDate = 2/27/1997 12:00:00 AM ShipVia = 2 Freight = 53.3000 ShipName = Blondel père et fils ShipAddress = 24, place Kléber ShipCity = Strasbourg ShipRegion = nothing ShipPostalCode = 67000 ShipCountry = France
OrderID = 10450 CustomerID = VICTE EmployeeID = 8 OrderDate = 2/19/1997 12:00:00 AM RequiredDate = 3/19/1997 12:00:00 AM ShippedDate = 3/11/1997 12:00:00 AM ShipVia = 2 Freight = 7.2300 ShipName = Victuailles en stock ShipAddress = 2, rue du Commerce ShipCity = Lyon ShipRegion = nothing ShipPostalCode = 69004 ShipCountry = France
OrderID = 10451 CustomerID = QUICK EmployeeID = 4 OrderDate = 2/19/1997 12:00:00 AM RequiredDate = 3/5/1997 12:00:00 AM ShippedDate = 3/12/1997 12:00:00 AM ShipVia = 3 Freight = 189.0900 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10462 CustomerID = CONSH EmployeeID = 2 OrderDate = 3/3/1997 12:00:00 AM RequiredDate = 3/31/1997 12:00:00 AM ShippedDate = 3/18/1997 12:00:00 AM ShipVia = 1 Freight = 6.1700 ShipName = Consolidated Holdings ShipAddress = Berkeley Gardens 12 Brewery ShipCity = London ShipRegion = nothing ShipPostalCode = WX1 6LT ShipCountry = UK
OrderID = 10464 CustomerID = FURIB EmployeeID = 4 OrderDate = 3/4/1997 12:00:00 AM RequiredDate = 4/1/1997 12:00:00 AM ShippedDate = 3/14/1997 12:00:00 AM ShipVia = 2 Freight = 89.0000 ShipName = Furia Bacalhau e Frutos do Mar ShipAddress = Jardim das rosas n. 32 ShipCity = Lisboa ShipRegion = nothing ShipPostalCode = 1675 ShipCountry = Portugal
OrderID = 10465 CustomerID = VAFFE EmployeeID = 1 OrderDate = 3/5/1997 12:00:00 AM RequiredDate = 4/2/1997 12:00:00 AM ShippedDate = 3/14/1997 12:00:00 AM ShipVia = 3 Freight = 145.0400 ShipName = Vaffeljernet ShipAddress = Smagsloget 45 ShipCity = Århus ShipRegion = nothing ShipPostalCode = 8200 ShipCountry = Denmark
OrderID = 10473 CustomerID = ISLAT EmployeeID = 1 OrderDate = 3/13/1997 12:00:00 AM RequiredDate = 3/27/1997 12:00:00 AM ShippedDate = 3/21/1997 12:00:00 AM ShipVia = 3 Freight = 16.3700 ShipName = Island Trading ShipAddress = Garden House Crowther Way ShipCity = Cowes ShipRegion = Isle of Wight ShipPostalCode = PO31 7PJ ShipCountry = UK
OrderID = 10474 CustomerID = PERIC EmployeeID = 5 OrderDate = 3/13/1997 12:00:00 AM RequiredDate = 4/10/1997 12:00:00 AM ShippedDate = 3/21/1997 12:00:00 AM ShipVia = 2 Freight = 83.4900 ShipName = Pericles Comidas clásicas ShipAddress = Calle Dr. Jorge Cash 321 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05033 ShipCountry = Mexico
OrderID = 10475 CustomerID = SUPRD EmployeeID = 9 OrderDate = 3/14/1997 12:00:00 AM RequiredDate = 4/11/1997 12:00:00 AM ShippedDate = 4/4/1997 12:00:00 AM ShipVia = 1 Freight = 68.5200 ShipName = Suprêmes délices ShipAddress = Boulevard Tirou, 255 ShipCity = Charleroi ShipRegion = nothing ShipPostalCode = B-6000 ShipCountry = Belgium
OrderID = 10477 CustomerID = PRINI EmployeeID = 5 OrderDate = 3/17/1997 12:00:00 AM RequiredDate = 4/14/1997 12:00:00 AM ShippedDate = 3/25/1997 12:00:00 AM ShipVia = 2 Freight = 13.0200 ShipName = Princesa Isabel Vinhos ShipAddress = Estrada da saúde n. 58 ShipCity = Lisboa ShipRegion = nothing ShipPostalCode = 1756 ShipCountry = Portugal
OrderID = 10478 CustomerID = VICTE EmployeeID = 2 OrderDate = 3/18/1997 12:00:00 AM RequiredDate = 4/1/1997 12:00:00 AM ShippedDate = 3/26/1997 12:00:00 AM ShipVia = 3 Freight = 4.8100 ShipName = Victuailles en stock ShipAddress = 2, rue du Commerce ShipCity = Lyon ShipRegion = nothing ShipPostalCode = 69004 ShipCountry = France
OrderID = 10482 CustomerID = LAZYK EmployeeID = 1 OrderDate = 3/21/1997 12:00:00 AM RequiredDate = 4/18/1997 12:00:00 AM ShippedDate = 4/10/1997 12:00:00 AM ShipVia = 3 Freight = 7.4800 ShipName = Lazy K Kountry Store ShipAddress = 12 Orchestra Terrace ShipCity = Walla Walla ShipRegion = WA ShipPostalCode = 99362 ShipCountry = USA
OrderID = 10483 CustomerID = WHITC EmployeeID = 7 OrderDate = 3/24/1997 12:00:00 AM RequiredDate = 4/21/1997 12:00:00 AM ShippedDate = 4/25/1997 12:00:00 AM ShipVia = 2 Freight = 15.2800 ShipName = White Clover Markets ShipAddress = 1029 - 12th Ave. S. ShipCity = Seattle ShipRegion = WA ShipPostalCode = 98124 ShipCountry = USA
OrderID = 10484 CustomerID = BSBEV EmployeeID = 3 OrderDate = 3/24/1997 12:00:00 AM RequiredDate = 4/21/1997 12:00:00 AM ShippedDate = 4/1/1997 12:00:00 AM ShipVia = 3 Freight = 6.8800 ShipName = B's Beverages ShipAddress = Fauntleroy Circus ShipCity = London ShipRegion = nothing ShipPostalCode = EC2 5NT ShipCountry = UK
OrderID = 10489 CustomerID = PICCO EmployeeID = 6 OrderDate = 3/28/1997 12:00:00 AM RequiredDate = 4/25/1997 12:00:00 AM ShippedDate = 4/9/1997 12:00:00 AM ShipVia = 2 Freight = 5.2900 ShipName = Piccolo und mehr ShipAddress = Geislweg 14 ShipCity = Salzburg ShipRegion = nothing ShipPostalCode = 5020 ShipCountry = Austria
OrderID = 10491 CustomerID = FURIB EmployeeID = 8 OrderDate = 3/31/1997 12:00:00 AM RequiredDate = 4/28/1997 12:00:00 AM ShippedDate = 4/8/1997 12:00:00 AM ShipVia = 3 Freight = 16.9600 ShipName = Furia Bacalhau e Frutos do Mar ShipAddress = Jardim das rosas n. 32 ShipCity = Lisboa ShipRegion = nothing ShipPostalCode = 1675 ShipCountry = Portugal
OrderID = 10492 CustomerID = BOTTM EmployeeID = 3 OrderDate = 4/1/1997 12:00:00 AM RequiredDate = 4/29/1997 12:00:00 AM ShippedDate = 4/11/1997 12:00:00 AM ShipVia = 1 Freight = 62.8900 ShipName = Bottom-Dollar Markets ShipAddress = 23 Tsawassen Blvd. ShipCity = Tsawassen ShipRegion = BC ShipPostalCode = T2F 8M4 ShipCountry = Canada
OrderID = 10493 CustomerID = LAMAI EmployeeID = 4 OrderDate = 4/2/1997 12:00:00 AM RequiredDate = 4/30/1997 12:00:00 AM ShippedDate = 4/10/1997 12:00:00 AM ShipVia = 3 Freight = 10.6400 ShipName = La maison d'Asie ShipAddress = 1 rue Alsace-Lorraine ShipCity = Toulouse ShipRegion = nothing ShipPostalCode = 31000 ShipCountry = France
OrderID = 10495 CustomerID = LAUGB EmployeeID = 3 OrderDate = 4/3/1997 12:00:00 AM RequiredDate = 5/1/1997 12:00:00 AM ShippedDate = 4/11/1997 12:00:00 AM ShipVia = 3 Freight = 4.6500 ShipName = Laughing Bacchus Wine Cellars ShipAddress = 2319 Elm St. ShipCity = Vancouver ShipRegion = BC ShipPostalCode = V3F 2K1 ShipCountry = Canada
OrderID = 10499 CustomerID = LILAS EmployeeID = 4 OrderDate = 4/8/1997 12:00:00 AM RequiredDate = 5/6/1997 12:00:00 AM ShippedDate = 4/16/1997 12:00:00 AM ShipVia = 2 Freight = 102.0200 ShipName = LILA-Supermercado ShipAddress = Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity = Barquisimeto ShipRegion = Lara ShipPostalCode = 3508 ShipCountry = Venezuela
OrderID = 10500 CustomerID = LAMAI EmployeeID = 6 OrderDate = 4/9/1997 12:00:00 AM RequiredDate = 5/7/1997 12:00:00 AM ShippedDate = 4/17/1997 12:00:00 AM ShipVia = 1 Freight = 42.6800 ShipName = La maison d'Asie ShipAddress = 1 rue Alsace-Lorraine ShipCity = Toulouse ShipRegion = nothing ShipPostalCode = 31000 ShipCountry = France
OrderID = 10502 CustomerID = PERIC EmployeeID = 2 OrderDate = 4/10/1997 12:00:00 AM RequiredDate = 5/8/1997 12:00:00 AM ShippedDate = 4/29/1997 12:00:00 AM ShipVia = 1 Freight = 69.3200 ShipName = Pericles Comidas clásicas ShipAddress = Calle Dr. Jorge Cash 321 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05033 ShipCountry = Mexico
OrderID = 10506 CustomerID = KOENE EmployeeID = 9 OrderDate = 4/15/1997 12:00:00 AM RequiredDate = 5/13/1997 12:00:00 AM ShippedDate = 5/2/1997 12:00:00 AM ShipVia = 2 Freight = 21.1900 ShipName = Königlich Essen ShipAddress = Maubelstr. 90 ShipCity = Brandenburg ShipRegion = nothing ShipPostalCode = 14776 ShipCountry = Germany
OrderID = 10508 CustomerID = OTTIK EmployeeID = 1 OrderDate = 4/16/1997 12:00:00 AM RequiredDate = 5/14/1997 12:00:00 AM ShippedDate = 5/13/1997 12:00:00 AM ShipVia = 2 Freight = 4.9900 ShipName = Ottilies Käseladen ShipAddress = Mehrheimerstr. 369 ShipCity = Köln ShipRegion = nothing ShipPostalCode = 50739 ShipCountry = Germany
OrderID = 10509 CustomerID = BLAUS EmployeeID = 4 OrderDate = 4/17/1997 12:00:00 AM RequiredDate = 5/15/1997 12:00:00 AM ShippedDate = 4/29/1997 12:00:00 AM ShipVia = 1 Freight = 0.1500 ShipName = Blauer See Delikatessen ShipAddress = Forsterstr. 57 ShipCity = Mannheim ShipRegion = nothing ShipPostalCode = 68306 ShipCountry = Germany
OrderID = 10510 CustomerID = SAVEA EmployeeID = 6 OrderDate = 4/18/1997 12:00:00 AM RequiredDate = 5/16/1997 12:00:00 AM ShippedDate = 4/28/1997 12:00:00 AM ShipVia = 3 Freight = 367.6300 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10514 CustomerID = ERNSH EmployeeID = 3 OrderDate = 4/22/1997 12:00:00 AM RequiredDate = 5/20/1997 12:00:00 AM ShippedDate = 5/16/1997 12:00:00 AM ShipVia = 2 Freight = 789.9500 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10515 CustomerID = QUICK EmployeeID = 2 OrderDate = 4/23/1997 12:00:00 AM RequiredDate = 5/7/1997 12:00:00 AM ShippedDate = 5/23/1997 12:00:00 AM ShipVia = 1 Freight = 204.4700 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10518 CustomerID = TORTU EmployeeID = 4 OrderDate = 4/25/1997 12:00:00 AM RequiredDate = 5/9/1997 12:00:00 AM ShippedDate = 5/5/1997 12:00:00 AM ShipVia = 2 Freight = 218.1500 ShipName = Tortuga Restaurante ShipAddress = Avda. Azteca 123 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05033 ShipCountry = Mexico
OrderID = 10523 CustomerID = SEVES EmployeeID = 7 OrderDate = 5/1/1997 12:00:00 AM RequiredDate = 5/29/1997 12:00:00 AM ShippedDate = 5/30/1997 12:00:00 AM ShipVia = 2 Freight = 77.6300 ShipName = Seven Seas Imports ShipAddress = 90 Wadhurst Rd. ShipCity = London ShipRegion = nothing ShipPostalCode = OX15 4NB ShipCountry = UK
OrderID = 10525 CustomerID = BONAP EmployeeID = 1 OrderDate = 5/2/1997 12:00:00 AM RequiredDate = 5/30/1997 12:00:00 AM ShippedDate = 5/23/1997 12:00:00 AM ShipVia = 2 Freight = 11.0600 ShipName = Bon app' ShipAddress = 12, rue des Bouchers ShipCity = Marseille ShipRegion = nothing ShipPostalCode = 13008 ShipCountry = France
OrderID = 10526 CustomerID = WARTH EmployeeID = 4 OrderDate = 5/5/1997 12:00:00 AM RequiredDate = 6/2/1997 12:00:00 AM ShippedDate = 5/15/1997 12:00:00 AM ShipVia = 2 Freight = 58.5900 ShipName = Wartian Herkku ShipAddress = Torikatu 38 ShipCity = Oulu ShipRegion = nothing ShipPostalCode = 90110 ShipCountry = Finland
OrderID = 10531 CustomerID = OCEAN EmployeeID = 7 OrderDate = 5/8/1997 12:00:00 AM RequiredDate = 6/5/1997 12:00:00 AM ShippedDate = 5/19/1997 12:00:00 AM ShipVia = 1 Freight = 8.1200 ShipName = Océano Atlántico Ltda. ShipAddress = Ing. Gustavo Moncada 8585 Piso 20-A ShipCity = Buenos Aires ShipRegion = nothing ShipPostalCode = 1010 ShipCountry = Argentina
OrderID = 10533 CustomerID = FOLKO EmployeeID = 8 OrderDate = 5/12/1997 12:00:00 AM RequiredDate = 6/9/1997 12:00:00 AM ShippedDate = 5/22/1997 12:00:00 AM ShipVia = 1 Freight = 188.0400 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10535 CustomerID = ANTON EmployeeID = 4 OrderDate = 5/13/1997 12:00:00 AM RequiredDate = 6/10/1997 12:00:00 AM ShippedDate = 5/21/1997 12:00:00 AM ShipVia = 1 Freight = 15.6400 ShipName = Antonio Moreno Taquería ShipAddress = Mataderos 2312 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05023 ShipCountry = Mexico
OrderID = 10536 CustomerID = LEHMS EmployeeID = 3 OrderDate = 5/14/1997 12:00:00 AM RequiredDate = 6/11/1997 12:00:00 AM ShippedDate = 6/6/1997 12:00:00 AM ShipVia = 2 Freight = 58.8800 ShipName = Lehmanns Marktstand ShipAddress = Magazinweg 7 ShipCity = Frankfurt a.M. ShipRegion = nothing ShipPostalCode = 60528 ShipCountry = Germany
OrderID = 10540 CustomerID = QUICK EmployeeID = 3 OrderDate = 5/19/1997 12:00:00 AM RequiredDate = 6/16/1997 12:00:00 AM ShippedDate = 6/13/1997 12:00:00 AM ShipVia = 3 Freight = 1007.6400 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10541 CustomerID = HANAR EmployeeID = 2 OrderDate = 5/19/1997 12:00:00 AM RequiredDate = 6/16/1997 12:00:00 AM ShippedDate = 5/29/1997 12:00:00 AM ShipVia = 1 Freight = 68.6500 ShipName = Hanari Carnes ShipAddress = Rua do Paço, 67 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 05454-876 ShipCountry = Brazil
OrderID = 10544 CustomerID = LONEP EmployeeID = 4 OrderDate = 5/21/1997 12:00:00 AM RequiredDate = 6/18/1997 12:00:00 AM ShippedDate = 5/30/1997 12:00:00 AM ShipVia = 1 Freight = 24.9100 ShipName = Lonesome Pine Restaurant ShipAddress = 89 Chiaroscuro Rd. ShipCity = Portland ShipRegion = OR ShipPostalCode = 97219 ShipCountry = USA
OrderID = 10545 CustomerID = LAZYK EmployeeID = 8 OrderDate = 5/22/1997 12:00:00 AM RequiredDate = 6/19/1997 12:00:00 AM ShippedDate = 6/26/1997 12:00:00 AM ShipVia = 2 Freight = 11.9200 ShipName = Lazy K Kountry Store ShipAddress = 12 Orchestra Terrace ShipCity = Walla Walla ShipRegion = WA ShipPostalCode = 99362 ShipCountry = USA
OrderID = 10547 CustomerID = SEVES EmployeeID = 3 OrderDate = 5/23/1997 12:00:00 AM RequiredDate = 6/20/1997 12:00:00 AM ShippedDate = 6/2/1997 12:00:00 AM ShipVia = 2 Freight = 178.4300 ShipName = Seven Seas Imports ShipAddress = 90 Wadhurst Rd. ShipCity = London ShipRegion = nothing ShipPostalCode = OX15 4NB ShipCountry = UK
OrderID = 10550 CustomerID = GODOS EmployeeID = 7 OrderDate = 5/28/1997 12:00:00 AM RequiredDate = 6/25/1997 12:00:00 AM ShippedDate = 6/6/1997 12:00:00 AM ShipVia = 3 Freight = 4.3200 ShipName = Godos Cocina Típica ShipAddress = C/ Romero, 33 ShipCity = Sevilla ShipRegion = nothing ShipPostalCode = 41101 ShipCountry = Spain
OrderID = 10551 CustomerID = FURIB EmployeeID = 4 OrderDate = 5/28/1997 12:00:00 AM RequiredDate = 7/9/1997 12:00:00 AM ShippedDate = 6/6/1997 12:00:00 AM ShipVia = 3 Freight = 72.9500 ShipName = Furia Bacalhau e Frutos do Mar ShipAddress = Jardim das rosas n. 32 ShipCity = Lisboa ShipRegion = nothing ShipPostalCode = 1675 ShipCountry = Portugal
OrderID = 10556 CustomerID = SIMOB EmployeeID = 2 OrderDate = 6/3/1997 12:00:00 AM RequiredDate = 7/15/1997 12:00:00 AM ShippedDate = 6/13/1997 12:00:00 AM ShipVia = 1 Freight = 9.8000 ShipName = Simons bistro ShipAddress = Vinbæltet 34 ShipCity = Kobenhavn ShipRegion = nothing ShipPostalCode = 1734 ShipCountry = Denmark
OrderID = 10559 CustomerID = BLONP EmployeeID = 6 OrderDate = 6/5/1997 12:00:00 AM RequiredDate = 7/3/1997 12:00:00 AM ShippedDate = 6/13/1997 12:00:00 AM ShipVia = 1 Freight = 8.0500 ShipName = Blondel père et fils ShipAddress = 24, place Kléber ShipCity = Strasbourg ShipRegion = nothing ShipPostalCode = 67000 ShipCountry = France
OrderID = 10563 CustomerID = RICAR EmployeeID = 2 OrderDate = 6/10/1997 12:00:00 AM RequiredDate = 7/22/1997 12:00:00 AM ShippedDate = 6/24/1997 12:00:00 AM ShipVia = 2 Freight = 60.4300 ShipName = Ricardo Adocicados ShipAddress = Av. Copacabana, 267 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-890 ShipCountry = Brazil
OrderID = 10568 CustomerID = GALED EmployeeID = 3 OrderDate = 6/13/1997 12:00:00 AM RequiredDate = 7/11/1997 12:00:00 AM ShippedDate = 7/9/1997 12:00:00 AM ShipVia = 3 Freight = 6.5400 ShipName = Galería del gastronómo ShipAddress = Rambla de Cataluña, 23 ShipCity = Barcelona ShipRegion = nothing ShipPostalCode = 8022 ShipCountry = Spain
OrderID = 10569 CustomerID = RATTC EmployeeID = 5 OrderDate = 6/16/1997 12:00:00 AM RequiredDate = 7/14/1997 12:00:00 AM ShippedDate = 7/11/1997 12:00:00 AM ShipVia = 1 Freight = 58.9800 ShipName = Rattlesnake Canyon Grocery ShipAddress = 2817 Milton Dr. ShipCity = Albuquerque ShipRegion = NM ShipPostalCode = 87110 ShipCountry = USA
OrderID = 10571 CustomerID = ERNSH EmployeeID = 8 OrderDate = 6/17/1997 12:00:00 AM RequiredDate = 7/29/1997 12:00:00 AM ShippedDate = 7/4/1997 12:00:00 AM ShipVia = 3 Freight = 26.0600 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10574 CustomerID = TRAIH EmployeeID = 4 OrderDate = 6/19/1997 12:00:00 AM RequiredDate = 7/17/1997 12:00:00 AM ShippedDate = 6/30/1997 12:00:00 AM ShipVia = 2 Freight = 37.6000 ShipName = Trail's Head Gourmet Provisioners ShipAddress = 722 DaVinci Blvd. ShipCity = Kirkland ShipRegion = WA ShipPostalCode = 98034 ShipCountry = USA
OrderID = 10575 CustomerID = MORGK EmployeeID = 5 OrderDate = 6/20/1997 12:00:00 AM RequiredDate = 7/4/1997 12:00:00 AM ShippedDate = 6/30/1997 12:00:00 AM ShipVia = 1 Freight = 127.3400 ShipName = Morgenstern Gesundkost ShipAddress = Heerstr. 22 ShipCity = Leipzig ShipRegion = nothing ShipPostalCode = 04179 ShipCountry = Germany
OrderID = 10578 CustomerID = BSBEV EmployeeID = 4 OrderDate = 6/24/1997 12:00:00 AM RequiredDate = 7/22/1997 12:00:00 AM ShippedDate = 7/25/1997 12:00:00 AM ShipVia = 3 Freight = 29.6000 ShipName = B's Beverages ShipAddress = Fauntleroy Circus ShipCity = London ShipRegion = nothing ShipPostalCode = EC2 5NT ShipCountry = UK
OrderID = 10579 CustomerID = LETSS EmployeeID = 1 OrderDate = 6/25/1997 12:00:00 AM RequiredDate = 7/23/1997 12:00:00 AM ShippedDate = 7/4/1997 12:00:00 AM ShipVia = 2 Freight = 13.7300 ShipName = Let's Stop N Shop ShipAddress = 87 Polk St. Suite 5 ShipCity = San Francisco ShipRegion = CA ShipPostalCode = 94117 ShipCountry = USA
OrderID = 10582 CustomerID = BLAUS EmployeeID = 3 OrderDate = 6/27/1997 12:00:00 AM RequiredDate = 7/25/1997 12:00:00 AM ShippedDate = 7/14/1997 12:00:00 AM ShipVia = 2 Freight = 27.7100 ShipName = Blauer See Delikatessen ShipAddress = Forsterstr. 57 ShipCity = Mannheim ShipRegion = nothing ShipPostalCode = 68306 ShipCountry = Germany
OrderID = 10585 CustomerID = WELLI EmployeeID = 7 OrderDate = 7/1/1997 12:00:00 AM RequiredDate = 7/29/1997 12:00:00 AM ShippedDate = 7/10/1997 12:00:00 AM ShipVia = 1 Freight = 13.4100 ShipName = Wellington Importadora ShipAddress = Rua do Mercado, 12 ShipCity = Resende ShipRegion = SP ShipPostalCode = 08737-363 ShipCountry = Brazil
OrderID = 10589 CustomerID = GREAL EmployeeID = 8 OrderDate = 7/4/1997 12:00:00 AM RequiredDate = 8/1/1997 12:00:00 AM ShippedDate = 7/14/1997 12:00:00 AM ShipVia = 2 Freight = 4.4200 ShipName = Great Lakes Food Market ShipAddress = 2732 Baker Blvd. ShipCity = Eugene ShipRegion = OR ShipPostalCode = 97403 ShipCountry = USA
OrderID = 10591 CustomerID = VAFFE EmployeeID = 1 OrderDate = 7/7/1997 12:00:00 AM RequiredDate = 7/21/1997 12:00:00 AM ShippedDate = 7/16/1997 12:00:00 AM ShipVia = 1 Freight = 55.9200 ShipName = Vaffeljernet ShipAddress = Smagsloget 45 ShipCity = Århus ShipRegion = nothing ShipPostalCode = 8200 ShipCountry = Denmark
OrderID = 10592 CustomerID = LEHMS EmployeeID = 3 OrderDate = 7/8/1997 12:00:00 AM RequiredDate = 8/5/1997 12:00:00 AM ShippedDate = 7/16/1997 12:00:00 AM ShipVia = 1 Freight = 32.1000 ShipName = Lehmanns Marktstand ShipAddress = Magazinweg 7 ShipCity = Frankfurt a.M. ShipRegion = nothing ShipPostalCode = 60528 ShipCountry = Germany
OrderID = 10593 CustomerID = LEHMS EmployeeID = 7 OrderDate = 7/9/1997 12:00:00 AM RequiredDate = 8/6/1997 12:00:00 AM ShippedDate = 8/13/1997 12:00:00 AM ShipVia = 2 Freight = 174.2000 ShipName = Lehmanns Marktstand ShipAddress = Magazinweg 7 ShipCity = Frankfurt a.M. ShipRegion = nothing ShipPostalCode = 60528 ShipCountry = Germany
OrderID = 10596 CustomerID = WHITC EmployeeID = 8 OrderDate = 7/11/1997 12:00:00 AM RequiredDate = 8/8/1997 12:00:00 AM ShippedDate = 8/12/1997 12:00:00 AM ShipVia = 1 Freight = 16.3400 ShipName = White Clover Markets ShipAddress = 1029 - 12th Ave. S. ShipCity = Seattle ShipRegion = WA ShipPostalCode = 98124 ShipCountry = USA
OrderID = 10603 CustomerID = SAVEA EmployeeID = 8 OrderDate = 7/18/1997 12:00:00 AM RequiredDate = 8/15/1997 12:00:00 AM ShippedDate = 8/8/1997 12:00:00 AM ShipVia = 2 Freight = 48.7700 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10604 CustomerID = FURIB EmployeeID = 1 OrderDate = 7/18/1997 12:00:00 AM RequiredDate = 8/15/1997 12:00:00 AM ShippedDate = 7/29/1997 12:00:00 AM ShipVia = 1 Freight = 7.4600 ShipName = Furia Bacalhau e Frutos do Mar ShipAddress = Jardim das rosas n. 32 ShipCity = Lisboa ShipRegion = nothing ShipPostalCode = 1675 ShipCountry = Portugal
OrderID = 10605 CustomerID = MEREP EmployeeID = 1 OrderDate = 7/21/1997 12:00:00 AM RequiredDate = 8/18/1997 12:00:00 AM ShippedDate = 7/29/1997 12:00:00 AM ShipVia = 2 Freight = 379.1300 ShipName = Mère Paillarde ShipAddress = 43 rue St. Laurent ShipCity = Montréal ShipRegion = Québec ShipPostalCode = H1J 1C3 ShipCountry = Canada
OrderID = 10606 CustomerID = TRADH EmployeeID = 4 OrderDate = 7/22/1997 12:00:00 AM RequiredDate = 8/19/1997 12:00:00 AM ShippedDate = 7/31/1997 12:00:00 AM ShipVia = 3 Freight = 79.4000 ShipName = Tradiçao Hipermercados ShipAddress = Av. Inês de Castro, 414 ShipCity = Sao Paulo ShipRegion = SP ShipPostalCode = 05634-030 ShipCountry = Brazil
OrderID = 10608 CustomerID = TOMSP EmployeeID = 4 OrderDate = 7/23/1997 12:00:00 AM RequiredDate = 8/20/1997 12:00:00 AM ShippedDate = 8/1/1997 12:00:00 AM ShipVia = 2 Freight = 27.7900 ShipName = Toms Spezialitäten ShipAddress = Luisenstr. 48 ShipCity = Münster ShipRegion = nothing ShipPostalCode = 44087 ShipCountry = Germany
OrderID = 10610 CustomerID = LAMAI EmployeeID = 8 OrderDate = 7/25/1997 12:00:00 AM RequiredDate = 8/22/1997 12:00:00 AM ShippedDate = 8/6/1997 12:00:00 AM ShipVia = 1 Freight = 26.7800 ShipName = La maison d'Asie ShipAddress = 1 rue Alsace-Lorraine ShipCity = Toulouse ShipRegion = nothing ShipPostalCode = 31000 ShipCountry = France
OrderID = 10620 CustomerID = LAUGB EmployeeID = 2 OrderDate = 8/5/1997 12:00:00 AM RequiredDate = 9/2/1997 12:00:00 AM ShippedDate = 8/14/1997 12:00:00 AM ShipVia = 3 Freight = 0.9400 ShipName = Laughing Bacchus Wine Cellars ShipAddress = 2319 Elm St. ShipCity = Vancouver ShipRegion = BC ShipPostalCode = V3F 2K1 ShipCountry = Canada
OrderID = 10624 CustomerID = THECR EmployeeID = 4 OrderDate = 8/7/1997 12:00:00 AM RequiredDate = 9/4/1997 12:00:00 AM ShippedDate = 8/19/1997 12:00:00 AM ShipVia = 2 Freight = 94.8000 ShipName = The Cracker Box ShipAddress = 55 Grizzly Peak Rd. ShipCity = Butte ShipRegion = MT ShipPostalCode = 59801 ShipCountry = USA
OrderID = 10626 CustomerID = BERGS EmployeeID = 1 OrderDate = 8/11/1997 12:00:00 AM RequiredDate = 9/8/1997 12:00:00 AM ShippedDate = 8/20/1997 12:00:00 AM ShipVia = 2 Freight = 138.6900 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10627 CustomerID = SAVEA EmployeeID = 8 OrderDate = 8/11/1997 12:00:00 AM RequiredDate = 9/22/1997 12:00:00 AM ShippedDate = 8/21/1997 12:00:00 AM ShipVia = 3 Freight = 107.4600 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10628 CustomerID = BLONP EmployeeID = 4 OrderDate = 8/12/1997 12:00:00 AM RequiredDate = 9/9/1997 12:00:00 AM ShippedDate = 8/20/1997 12:00:00 AM ShipVia = 3 Freight = 30.3600 ShipName = Blondel père et fils ShipAddress = 24, place Kléber ShipCity = Strasbourg ShipRegion = nothing ShipPostalCode = 67000 ShipCountry = France
OrderID = 10629 CustomerID = GODOS EmployeeID = 4 OrderDate = 8/12/1997 12:00:00 AM RequiredDate = 9/9/1997 12:00:00 AM ShippedDate = 8/20/1997 12:00:00 AM ShipVia = 3 Freight = 85.4600 ShipName = Godos Cocina Típica ShipAddress = C/ Romero, 33 ShipCity = Sevilla ShipRegion = nothing ShipPostalCode = 41101 ShipCountry = Spain
OrderID = 10638 CustomerID = LINOD EmployeeID = 3 OrderDate = 8/20/1997 12:00:00 AM RequiredDate = 9/17/1997 12:00:00 AM ShippedDate = 9/1/1997 12:00:00 AM ShipVia = 1 Freight = 158.4400 ShipName = LINO-Delicateses ShipAddress = Ave. 5 de Mayo Porlamar ShipCity = I. de Margarita ShipRegion = Nueva Esparta ShipPostalCode = 4980 ShipCountry = Venezuela
OrderID = 10642 CustomerID = SIMOB EmployeeID = 7 OrderDate = 8/22/1997 12:00:00 AM RequiredDate = 9/19/1997 12:00:00 AM ShippedDate = 9/5/1997 12:00:00 AM ShipVia = 3 Freight = 41.8900 ShipName = Simons bistro ShipAddress = Vinbæltet 34 ShipCity = Kobenhavn ShipRegion = nothing ShipPostalCode = 1734 ShipCountry = Denmark
OrderID = 10643 CustomerID = ALFKI EmployeeID = 6 OrderDate = 8/25/1997 12:00:00 AM RequiredDate = 9/22/1997 12:00:00 AM ShippedDate = 9/2/1997 12:00:00 AM ShipVia = 1 Freight = 1.2100 ShipName = Alfreds Futterkiste ShipAddress = Obere Str. 57 ShipCity = Berlin ShipRegion = nothing ShipPostalCode = 12209 ShipCountry = Germany
OrderID = 10648 CustomerID = RICAR EmployeeID = 5 OrderDate = 8/28/1997 12:00:00 AM RequiredDate = 10/9/1997 12:00:00 AM ShippedDate = 9/9/1997 12:00:00 AM ShipVia = 2 Freight = 14.2500 ShipName = Ricardo Adocicados ShipAddress = Av. Copacabana, 267 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-890 ShipCountry = Brazil
OrderID = 10651 CustomerID = WANDK EmployeeID = 8 OrderDate = 9/1/1997 12:00:00 AM RequiredDate = 9/29/1997 12:00:00 AM ShippedDate = 9/11/1997 12:00:00 AM ShipVia = 2 Freight = 20.6000 ShipName = Die Wandernde Kuh ShipAddress = Adenauerallee 900 ShipCity = Stuttgart ShipRegion = nothing ShipPostalCode = 70563 ShipCountry = Germany
OrderID = 10653 CustomerID = FRANK EmployeeID = 1 OrderDate = 9/2/1997 12:00:00 AM RequiredDate = 9/30/1997 12:00:00 AM ShippedDate = 9/19/1997 12:00:00 AM ShipVia = 1 Freight = 93.2500 ShipName = Frankenversand ShipAddress = Berliner Platz 43 ShipCity = München ShipRegion = nothing ShipPostalCode = 80805 ShipCountry = Germany
OrderID = 10654 CustomerID = BERGS EmployeeID = 5 OrderDate = 9/2/1997 12:00:00 AM RequiredDate = 9/30/1997 12:00:00 AM ShippedDate = 9/11/1997 12:00:00 AM ShipVia = 1 Freight = 55.2600 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10655 CustomerID = REGGC EmployeeID = 1 OrderDate = 9/3/1997 12:00:00 AM RequiredDate = 10/1/1997 12:00:00 AM ShippedDate = 9/11/1997 12:00:00 AM ShipVia = 2 Freight = 4.4100 ShipName = Reggiani Caseifici ShipAddress = Strada Provinciale 124 ShipCity = Reggio Emilia ShipRegion = nothing ShipPostalCode = 42100 ShipCountry = Italy
OrderID = 10657 CustomerID = SAVEA EmployeeID = 2 OrderDate = 9/4/1997 12:00:00 AM RequiredDate = 10/2/1997 12:00:00 AM ShippedDate = 9/15/1997 12:00:00 AM ShipVia = 2 Freight = 352.6900 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10660 CustomerID = HUNGC EmployeeID = 8 OrderDate = 9/8/1997 12:00:00 AM RequiredDate = 10/6/1997 12:00:00 AM ShippedDate = 10/15/1997 12:00:00 AM ShipVia = 1 Freight = 111.2900 ShipName = Hungry Coyote Import Store ShipAddress = City Center Plaza 516 Main St. ShipCity = Elgin ShipRegion = OR ShipPostalCode = 97827 ShipCountry = USA
OrderID = 10662 CustomerID = LONEP EmployeeID = 3 OrderDate = 9/9/1997 12:00:00 AM RequiredDate = 10/7/1997 12:00:00 AM ShippedDate = 9/18/1997 12:00:00 AM ShipVia = 2 Freight = 1.2800 ShipName = Lonesome Pine Restaurant ShipAddress = 89 Chiaroscuro Rd. ShipCity = Portland ShipRegion = OR ShipPostalCode = 97219 ShipCountry = USA
OrderID = 10663 CustomerID = BONAP EmployeeID = 2 OrderDate = 9/10/1997 12:00:00 AM RequiredDate = 9/24/1997 12:00:00 AM ShippedDate = 10/3/1997 12:00:00 AM ShipVia = 2 Freight = 113.1500 ShipName = Bon app' ShipAddress = 12, rue des Bouchers ShipCity = Marseille ShipRegion = nothing ShipPostalCode = 13008 ShipCountry = France
OrderID = 10664 CustomerID = FURIB EmployeeID = 1 OrderDate = 9/10/1997 12:00:00 AM RequiredDate = 10/8/1997 12:00:00 AM ShippedDate = 9/19/1997 12:00:00 AM ShipVia = 3 Freight = 1.2700 ShipName = Furia Bacalhau e Frutos do Mar ShipAddress = Jardim das rosas n. 32 ShipCity = Lisboa ShipRegion = nothing ShipPostalCode = 1675 ShipCountry = Portugal
OrderID = 10666 CustomerID = RICSU EmployeeID = 7 OrderDate = 9/12/1997 12:00:00 AM RequiredDate = 10/10/1997 12:00:00 AM ShippedDate = 9/22/1997 12:00:00 AM ShipVia = 2 Freight = 232.4200 ShipName = Richter Supermarkt ShipAddress = Starenweg 5 ShipCity = Genève ShipRegion = nothing ShipPostalCode = 1204 ShipCountry = Switzerland
OrderID = 10668 CustomerID = WANDK EmployeeID = 1 OrderDate = 9/15/1997 12:00:00 AM RequiredDate = 10/13/1997 12:00:00 AM ShippedDate = 9/23/1997 12:00:00 AM ShipVia = 2 Freight = 47.2200 ShipName = Die Wandernde Kuh ShipAddress = Adenauerallee 900 ShipCity = Stuttgart ShipRegion = nothing ShipPostalCode = 70563 ShipCountry = Germany
OrderID = 10672 CustomerID = BERGS EmployeeID = 9 OrderDate = 9/17/1997 12:00:00 AM RequiredDate = 10/1/1997 12:00:00 AM ShippedDate = 9/26/1997 12:00:00 AM ShipVia = 2 Freight = 95.7500 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10674 CustomerID = ISLAT EmployeeID = 4 OrderDate = 9/18/1997 12:00:00 AM RequiredDate = 10/16/1997 12:00:00 AM ShippedDate = 9/30/1997 12:00:00 AM ShipVia = 2 Freight = 0.9000 ShipName = Island Trading ShipAddress = Garden House Crowther Way ShipCity = Cowes ShipRegion = Isle of Wight ShipPostalCode = PO31 7PJ ShipCountry = UK
OrderID = 10678 CustomerID = SAVEA EmployeeID = 7 OrderDate = 9/23/1997 12:00:00 AM RequiredDate = 10/21/1997 12:00:00 AM ShippedDate = 10/16/1997 12:00:00 AM ShipVia = 3 Freight = 388.9800 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10686 CustomerID = PICCO EmployeeID = 2 OrderDate = 9/30/1997 12:00:00 AM RequiredDate = 10/28/1997 12:00:00 AM ShippedDate = 10/8/1997 12:00:00 AM ShipVia = 1 Freight = 96.5000 ShipName = Piccolo und mehr ShipAddress = Geislweg 14 ShipCity = Salzburg ShipRegion = nothing ShipPostalCode = 5020 ShipCountry = Austria
OrderID = 10687 CustomerID = HUNGO EmployeeID = 9 OrderDate = 9/30/1997 12:00:00 AM RequiredDate = 10/28/1997 12:00:00 AM ShippedDate = 10/30/1997 12:00:00 AM ShipVia = 2 Freight = 296.4300 ShipName = Hungry Owl All-Night Grocers ShipAddress = 8 Johnstown Road ShipCity = Cork ShipRegion = Co. Cork ShipPostalCode = nothing ShipCountry = Ireland
OrderID = 10691 CustomerID = QUICK EmployeeID = 2 OrderDate = 10/3/1997 12:00:00 AM RequiredDate = 11/14/1997 12:00:00 AM ShippedDate = 10/22/1997 12:00:00 AM ShipVia = 2 Freight = 810.0500 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10692 CustomerID = ALFKI EmployeeID = 4 OrderDate = 10/3/1997 12:00:00 AM RequiredDate = 10/31/1997 12:00:00 AM ShippedDate = 10/13/1997 12:00:00 AM ShipVia = 2 Freight = 61.0200 ShipName = Alfred's Futterkiste ShipAddress = Obere Str. 57 ShipCity = Berlin ShipRegion = nothing ShipPostalCode = 12209 ShipCountry = Germany
OrderID = 10698 CustomerID = ERNSH EmployeeID = 4 OrderDate = 10/9/1997 12:00:00 AM RequiredDate = 11/6/1997 12:00:00 AM ShippedDate = 10/17/1997 12:00:00 AM ShipVia = 1 Freight = 272.4700 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10702 CustomerID = ALFKI EmployeeID = 4 OrderDate = 10/13/1997 12:00:00 AM RequiredDate = 11/24/1997 12:00:00 AM ShippedDate = 10/21/1997 12:00:00 AM ShipVia = 1 Freight = 23.9400 ShipName = Alfred's Futterkiste ShipAddress = Obere Str. 57 ShipCity = Berlin ShipRegion = nothing ShipPostalCode = 12209 ShipCountry = Germany
OrderID = 10704 CustomerID = QUEEN EmployeeID = 6 OrderDate = 10/14/1997 12:00:00 AM RequiredDate = 11/11/1997 12:00:00 AM ShippedDate = 11/7/1997 12:00:00 AM ShipVia = 1 Freight = 4.7800 ShipName = Queen Cozinha ShipAddress = Alameda dos Canàrios, 891 ShipCity = Sao Paulo ShipRegion = SP ShipPostalCode = 05487-020 ShipCountry = Brazil
OrderID = 10705 CustomerID = HILAA EmployeeID = 9 OrderDate = 10/15/1997 12:00:00 AM RequiredDate = 11/12/1997 12:00:00 AM ShippedDate = 11/18/1997 12:00:00 AM ShipVia = 2 Freight = 3.5200 ShipName = HILARION-Abastos ShipAddress = Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity = San Cristóbal ShipRegion = Táchira ShipPostalCode = 5022 ShipCountry = Venezuela
OrderID = 10708 CustomerID = THEBI EmployeeID = 6 OrderDate = 10/17/1997 12:00:00 AM RequiredDate = 11/28/1997 12:00:00 AM ShippedDate = 11/5/1997 12:00:00 AM ShipVia = 2 Freight = 2.9600 ShipName = The Big Cheese ShipAddress = 89 Jefferson Way Suite 2 ShipCity = Portland ShipRegion = OR ShipPostalCode = 97201 ShipCountry = USA
OrderID = 10709 CustomerID = GOURL EmployeeID = 1 OrderDate = 10/17/1997 12:00:00 AM RequiredDate = 11/14/1997 12:00:00 AM ShippedDate = 11/20/1997 12:00:00 AM ShipVia = 3 Freight = 210.8000 ShipName = Gourmet Lanchonetes ShipAddress = Av. Brasil, 442 ShipCity = Campinas ShipRegion = SP ShipPostalCode = 04876-786 ShipCountry = Brazil
OrderID = 10711 CustomerID = SAVEA EmployeeID = 5 OrderDate = 10/21/1997 12:00:00 AM RequiredDate = 12/2/1997 12:00:00 AM ShippedDate = 10/29/1997 12:00:00 AM ShipVia = 2 Freight = 52.4100 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10712 CustomerID = HUNGO EmployeeID = 3 OrderDate = 10/21/1997 12:00:00 AM RequiredDate = 11/18/1997 12:00:00 AM ShippedDate = 10/31/1997 12:00:00 AM ShipVia = 1 Freight = 89.9300 ShipName = Hungry Owl All-Night Grocers ShipAddress = 8 Johnstown Road ShipCity = Cork ShipRegion = Co. Cork ShipPostalCode = nothing ShipCountry = Ireland
OrderID = 10719 CustomerID = LETSS EmployeeID = 8 OrderDate = 10/27/1997 12:00:00 AM RequiredDate = 11/24/1997 12:00:00 AM ShippedDate = 11/5/1997 12:00:00 AM ShipVia = 2 Freight = 51.4400 ShipName = Let's Stop N Shop ShipAddress = 87 Polk St. Suite 5 ShipCity = San Francisco ShipRegion = CA ShipPostalCode = 94117 ShipCountry = USA
OrderID = 10720 CustomerID = QUEDE EmployeeID = 8 OrderDate = 10/28/1997 12:00:00 AM RequiredDate = 11/11/1997 12:00:00 AM ShippedDate = 11/5/1997 12:00:00 AM ShipVia = 2 Freight = 9.5300 ShipName = Que Delícia ShipAddress = Rua da Panificadora, 12 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-673 ShipCountry = Brazil
OrderID = 10723 CustomerID = WHITC EmployeeID = 3 OrderDate = 10/30/1997 12:00:00 AM RequiredDate = 11/27/1997 12:00:00 AM ShippedDate = 11/25/1997 12:00:00 AM ShipVia = 1 Freight = 21.7200 ShipName = White Clover Markets ShipAddress = 1029 - 12th Ave. S. ShipCity = Seattle ShipRegion = WA ShipPostalCode = 98124 ShipCountry = USA
OrderID = 10726 CustomerID = EASTC EmployeeID = 4 OrderDate = 11/3/1997 12:00:00 AM RequiredDate = 11/17/1997 12:00:00 AM ShippedDate = 12/5/1997 12:00:00 AM ShipVia = 1 Freight = 16.5600 ShipName = Eastern Connection ShipAddress = 35 King George ShipCity = London ShipRegion = nothing ShipPostalCode = WX3 6FW ShipCountry = UK
OrderID = 10727 CustomerID = REGGC EmployeeID = 2 OrderDate = 11/3/1997 12:00:00 AM RequiredDate = 12/1/1997 12:00:00 AM ShippedDate = 12/5/1997 12:00:00 AM ShipVia = 1 Freight = 89.9000 ShipName = Reggiani Caseifici ShipAddress = Strada Provinciale 124 ShipCity = Reggio Emilia ShipRegion = nothing ShipPostalCode = 42100 ShipCountry = Italy
OrderID = 10729 CustomerID = LINOD EmployeeID = 8 OrderDate = 11/4/1997 12:00:00 AM RequiredDate = 12/16/1997 12:00:00 AM ShippedDate = 11/14/1997 12:00:00 AM ShipVia = 3 Freight = 141.0600 ShipName = LINO-Delicateses ShipAddress = Ave. 5 de Mayo Porlamar ShipCity = I. de Margarita ShipRegion = Nueva Esparta ShipPostalCode = 4980 ShipCountry = Venezuela
OrderID = 10730 CustomerID = BONAP EmployeeID = 5 OrderDate = 11/5/1997 12:00:00 AM RequiredDate = 12/3/1997 12:00:00 AM ShippedDate = 11/14/1997 12:00:00 AM ShipVia = 1 Freight = 20.1200 ShipName = Bon app' ShipAddress = 12, rue des Bouchers ShipCity = Marseille ShipRegion = nothing ShipPostalCode = 13008 ShipCountry = France
OrderID = 10731 CustomerID = CHOPS EmployeeID = 7 OrderDate = 11/6/1997 12:00:00 AM RequiredDate = 12/4/1997 12:00:00 AM ShippedDate = 11/14/1997 12:00:00 AM ShipVia = 1 Freight = 96.6500 ShipName = Chop-suey Chinese ShipAddress = Hauptstr. 31 ShipCity = Bern ShipRegion = nothing ShipPostalCode = 3012 ShipCountry = Switzerland
OrderID = 10735 CustomerID = LETSS EmployeeID = 6 OrderDate = 11/10/1997 12:00:00 AM RequiredDate = 12/8/1997 12:00:00 AM ShippedDate = 11/21/1997 12:00:00 AM ShipVia = 2 Freight = 45.9700 ShipName = Let's Stop N Shop ShipAddress = 87 Polk St. Suite 5 ShipCity = San Francisco ShipRegion = CA ShipPostalCode = 94117 ShipCountry = USA
OrderID = 10736 CustomerID = HUNGO EmployeeID = 9 OrderDate = 11/11/1997 12:00:00 AM RequiredDate = 12/9/1997 12:00:00 AM ShippedDate = 11/21/1997 12:00:00 AM ShipVia = 2 Freight = 44.1000 ShipName = Hungry Owl All-Night Grocers ShipAddress = 8 Johnstown Road ShipCity = Cork ShipRegion = Co. Cork ShipPostalCode = nothing ShipCountry = Ireland
OrderID = 10740 CustomerID = WHITC EmployeeID = 4 OrderDate = 11/13/1997 12:00:00 AM RequiredDate = 12/11/1997 12:00:00 AM ShippedDate = 11/25/1997 12:00:00 AM ShipVia = 2 Freight = 81.8800 ShipName = White Clover Markets ShipAddress = 1029 - 12th Ave. S. ShipCity = Seattle ShipRegion = WA ShipPostalCode = 98124 ShipCountry = USA
OrderID = 10745 CustomerID = QUICK EmployeeID = 9 OrderDate = 11/18/1997 12:00:00 AM RequiredDate = 12/16/1997 12:00:00 AM ShippedDate = 11/27/1997 12:00:00 AM ShipVia = 1 Freight = 3.5200 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10748 CustomerID = SAVEA EmployeeID = 3 OrderDate = 11/20/1997 12:00:00 AM RequiredDate = 12/18/1997 12:00:00 AM ShippedDate = 11/28/1997 12:00:00 AM ShipVia = 1 Freight = 232.5500 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10749 CustomerID = ISLAT EmployeeID = 4 OrderDate = 11/20/1997 12:00:00 AM RequiredDate = 12/18/1997 12:00:00 AM ShippedDate = 12/19/1997 12:00:00 AM ShipVia = 2 Freight = 61.5300 ShipName = Island Trading ShipAddress = Garden House Crowther Way ShipCity = Cowes ShipRegion = Isle of Wight ShipPostalCode = PO31 7PJ ShipCountry = UK
OrderID = 10751 CustomerID = RICSU EmployeeID = 3 OrderDate = 11/24/1997 12:00:00 AM RequiredDate = 12/22/1997 12:00:00 AM ShippedDate = 12/3/1997 12:00:00 AM ShipVia = 3 Freight = 130.7900 ShipName = Richter Supermarkt ShipAddress = Starenweg 5 ShipCity = Genève ShipRegion = nothing ShipPostalCode = 1204 ShipCountry = Switzerland
OrderID = 10757 CustomerID = SAVEA EmployeeID = 6 OrderDate = 11/27/1997 12:00:00 AM RequiredDate = 12/25/1997 12:00:00 AM ShippedDate = 12/15/1997 12:00:00 AM ShipVia = 1 Freight = 8.1900 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10759 CustomerID = ANATR EmployeeID = 3 OrderDate = 11/28/1997 12:00:00 AM RequiredDate = 12/26/1997 12:00:00 AM ShippedDate = 12/12/1997 12:00:00 AM ShipVia = 3 Freight = 11.9900 ShipName = Ana Trujillo Emparedados y helados ShipAddress = Avda. de la Constitución 2222 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05021 ShipCountry = Mexico
OrderID = 10760 CustomerID = MAISD EmployeeID = 4 OrderDate = 12/1/1997 12:00:00 AM RequiredDate = 12/29/1997 12:00:00 AM ShippedDate = 12/10/1997 12:00:00 AM ShipVia = 1 Freight = 155.6400 ShipName = Maison Dewey ShipAddress = Rue Joseph-Bens 532 ShipCity = Bruxelles ShipRegion = nothing ShipPostalCode = B-1180 ShipCountry = Belgium
OrderID = 10767 CustomerID = SUPRD EmployeeID = 4 OrderDate = 12/5/1997 12:00:00 AM RequiredDate = 1/2/1998 12:00:00 AM ShippedDate = 12/15/1997 12:00:00 AM ShipVia = 3 Freight = 1.5900 ShipName = Suprêmes délices ShipAddress = Boulevard Tirou, 255 ShipCity = Charleroi ShipRegion = nothing ShipPostalCode = B-6000 ShipCountry = Belgium
OrderID = 10770 CustomerID = HANAR EmployeeID = 8 OrderDate = 12/9/1997 12:00:00 AM RequiredDate = 1/6/1998 12:00:00 AM ShippedDate = 12/17/1997 12:00:00 AM ShipVia = 3 Freight = 5.3200 ShipName = Hanari Carnes ShipAddress = Rua do Paço, 67 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 05454-876 ShipCountry = Brazil
OrderID = 10771 CustomerID = ERNSH EmployeeID = 9 OrderDate = 12/10/1997 12:00:00 AM RequiredDate = 1/7/1998 12:00:00 AM ShippedDate = 1/2/1998 12:00:00 AM ShipVia = 2 Freight = 11.1900 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10772 CustomerID = LEHMS EmployeeID = 3 OrderDate = 12/10/1997 12:00:00 AM RequiredDate = 1/7/1998 12:00:00 AM ShippedDate = 12/19/1997 12:00:00 AM ShipVia = 2 Freight = 91.2800 ShipName = Lehmanns Marktstand ShipAddress = Magazinweg 7 ShipCity = Frankfurt a.M. ShipRegion = nothing ShipPostalCode = 60528 ShipCountry = Germany
OrderID = 10775 CustomerID = THECR EmployeeID = 7 OrderDate = 12/12/1997 12:00:00 AM RequiredDate = 1/9/1998 12:00:00 AM ShippedDate = 12/26/1997 12:00:00 AM ShipVia = 1 Freight = 20.2500 ShipName = The Cracker Box ShipAddress = 55 Grizzly Peak Rd. ShipCity = Butte ShipRegion = MT ShipPostalCode = 59801 ShipCountry = USA
OrderID = 10777 CustomerID = GOURL EmployeeID = 7 OrderDate = 12/15/1997 12:00:00 AM RequiredDate = 12/29/1997 12:00:00 AM ShippedDate = 1/21/1998 12:00:00 AM ShipVia = 2 Freight = 3.0100 ShipName = Gourmet Lanchonetes ShipAddress = Av. Brasil, 442 ShipCity = Campinas ShipRegion = SP ShipPostalCode = 04876-786 ShipCountry = Brazil
OrderID = 10778 CustomerID = BERGS EmployeeID = 3 OrderDate = 12/16/1997 12:00:00 AM RequiredDate = 1/13/1998 12:00:00 AM ShippedDate = 12/24/1997 12:00:00 AM ShipVia = 1 Freight = 6.7900 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10779 CustomerID = MORGK EmployeeID = 3 OrderDate = 12/16/1997 12:00:00 AM RequiredDate = 1/13/1998 12:00:00 AM ShippedDate = 1/14/1998 12:00:00 AM ShipVia = 2 Freight = 58.1300 ShipName = Morgenstern Gesundkost ShipAddress = Heerstr. 22 ShipCity = Leipzig ShipRegion = nothing ShipPostalCode = 04179 ShipCountry = Germany
OrderID = 10780 CustomerID = LILAS EmployeeID = 2 OrderDate = 12/16/1997 12:00:00 AM RequiredDate = 12/30/1997 12:00:00 AM ShippedDate = 12/25/1997 12:00:00 AM ShipVia = 1 Freight = 42.1300 ShipName = LILA-Supermercado ShipAddress = Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity = Barquisimeto ShipRegion = Lara ShipPostalCode = 3508 ShipCountry = Venezuela
OrderID = 10788 CustomerID = QUICK EmployeeID = 1 OrderDate = 12/22/1997 12:00:00 AM RequiredDate = 1/19/1998 12:00:00 AM ShippedDate = 1/19/1998 12:00:00 AM ShipVia = 2 Freight = 42.7000 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10789 CustomerID = FOLIG EmployeeID = 1 OrderDate = 12/22/1997 12:00:00 AM RequiredDate = 1/19/1998 12:00:00 AM ShippedDate = 12/31/1997 12:00:00 AM ShipVia = 2 Freight = 100.6000 ShipName = Folies gourmandes ShipAddress = 184, chaussée de Tournai ShipCity = Lille ShipRegion = nothing ShipPostalCode = 59000 ShipCountry = France
OrderID = 10791 CustomerID = FRANK EmployeeID = 6 OrderDate = 12/23/1997 12:00:00 AM RequiredDate = 1/20/1998 12:00:00 AM ShippedDate = 1/1/1998 12:00:00 AM ShipVia = 2 Freight = 16.8500 ShipName = Frankenversand ShipAddress = Berliner Platz 43 ShipCity = München ShipRegion = nothing ShipPostalCode = 80805 ShipCountry = Germany
OrderID = 10792 CustomerID = WOLZA EmployeeID = 1 OrderDate = 12/23/1997 12:00:00 AM RequiredDate = 1/20/1998 12:00:00 AM ShippedDate = 12/31/1997 12:00:00 AM ShipVia = 3 Freight = 23.7900 ShipName = Wolski Zajazd ShipAddress = ul. Filtrowa 68 ShipCity = Warszawa ShipRegion = nothing ShipPostalCode = 01-012 ShipCountry = Poland
OrderID = 10793 CustomerID = AROUT EmployeeID = 3 OrderDate = 12/24/1997 12:00:00 AM RequiredDate = 1/21/1998 12:00:00 AM ShippedDate = 1/8/1998 12:00:00 AM ShipVia = 3 Freight = 4.5200 ShipName = Around the Horn ShipAddress = Brook Farm Stratford St. Mary ShipCity = Colchester ShipRegion = Essex ShipPostalCode = CO7 6JX ShipCountry = UK
OrderID = 10794 CustomerID = QUEDE EmployeeID = 6 OrderDate = 12/24/1997 12:00:00 AM RequiredDate = 1/21/1998 12:00:00 AM ShippedDate = 1/2/1998 12:00:00 AM ShipVia = 1 Freight = 21.4900 ShipName = Que Delícia ShipAddress = Rua da Panificadora, 12 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-673 ShipCountry = Brazil
OrderID = 10795 CustomerID = ERNSH EmployeeID = 8 OrderDate = 12/24/1997 12:00:00 AM RequiredDate = 1/21/1998 12:00:00 AM ShippedDate = 1/20/1998 12:00:00 AM ShipVia = 2 Freight = 126.6600 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10796 CustomerID = HILAA EmployeeID = 3 OrderDate = 12/25/1997 12:00:00 AM RequiredDate = 1/22/1998 12:00:00 AM ShippedDate = 1/14/1998 12:00:00 AM ShipVia = 1 Freight = 26.5200 ShipName = HILARION-Abastos ShipAddress = Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity = San Cristóbal ShipRegion = Táchira ShipPostalCode = 5022 ShipCountry = Venezuela
OrderID = 10797 CustomerID = DRACD EmployeeID = 7 OrderDate = 12/25/1997 12:00:00 AM RequiredDate = 1/22/1998 12:00:00 AM ShippedDate = 1/5/1998 12:00:00 AM ShipVia = 2 Freight = 33.3500 ShipName = Drachenblut Delikatessen ShipAddress = Walserweg 21 ShipCity = Aachen ShipRegion = nothing ShipPostalCode = 52066 ShipCountry = Germany
OrderID = 10798 CustomerID = ISLAT EmployeeID = 2 OrderDate = 12/26/1997 12:00:00 AM RequiredDate = 1/23/1998 12:00:00 AM ShippedDate = 1/5/1998 12:00:00 AM ShipVia = 1 Freight = 2.3300 ShipName = Island Trading ShipAddress = Garden House Crowther Way ShipCity = Cowes ShipRegion = Isle of Wight ShipPostalCode = PO31 7PJ ShipCountry = UK
OrderID = 10799 CustomerID = KOENE EmployeeID = 9 OrderDate = 12/26/1997 12:00:00 AM RequiredDate = 2/6/1998 12:00:00 AM ShippedDate = 1/5/1998 12:00:00 AM ShipVia = 3 Freight = 30.7600 ShipName = Königlich Essen ShipAddress = Maubelstr. 90 ShipCity = Brandenburg ShipRegion = nothing ShipPostalCode = 14776 ShipCountry = Germany
OrderID = 10800 CustomerID = SEVES EmployeeID = 1 OrderDate = 12/26/1997 12:00:00 AM RequiredDate = 1/23/1998 12:00:00 AM ShippedDate = 1/5/1998 12:00:00 AM ShipVia = 3 Freight = 137.4400 ShipName = Seven Seas Imports ShipAddress = 90 Wadhurst Rd. ShipCity = London ShipRegion = nothing ShipPostalCode = OX15 4NB ShipCountry = UK
OrderID = 10804 CustomerID = SEVES EmployeeID = 6 OrderDate = 12/30/1997 12:00:00 AM RequiredDate = 1/27/1998 12:00:00 AM ShippedDate = 1/7/1998 12:00:00 AM ShipVia = 2 Freight = 27.3300 ShipName = Seven Seas Imports ShipAddress = 90 Wadhurst Rd. ShipCity = London ShipRegion = nothing ShipPostalCode = OX15 4NB ShipCountry = UK
OrderID = 10805 CustomerID = THEBI EmployeeID = 2 OrderDate = 12/30/1997 12:00:00 AM RequiredDate = 1/27/1998 12:00:00 AM ShippedDate = 1/9/1998 12:00:00 AM ShipVia = 3 Freight = 237.3400 ShipName = The Big Cheese ShipAddress = 89 Jefferson Way Suite 2 ShipCity = Portland ShipRegion = OR ShipPostalCode = 97201 ShipCountry = USA
OrderID = 10807 CustomerID = FRANS EmployeeID = 4 OrderDate = 12/31/1997 12:00:00 AM RequiredDate = 1/28/1998 12:00:00 AM ShippedDate = 1/30/1998 12:00:00 AM ShipVia = 1 Freight = 1.3600 ShipName = Franchi S.p.A. ShipAddress = Via Monte Bianco 34 ShipCity = Torino ShipRegion = nothing ShipPostalCode = 10100 ShipCountry = Italy
OrderID = 10808 CustomerID = OLDWO EmployeeID = 2 OrderDate = 1/1/1998 12:00:00 AM RequiredDate = 1/29/1998 12:00:00 AM ShippedDate = 1/9/1998 12:00:00 AM ShipVia = 3 Freight = 45.5300 ShipName = Old World Delicatessen ShipAddress = 2743 Bering St. ShipCity = Anchorage ShipRegion = AK ShipPostalCode = 99508 ShipCountry = USA
OrderID = 10812 CustomerID = REGGC EmployeeID = 5 OrderDate = 1/2/1998 12:00:00 AM RequiredDate = 1/30/1998 12:00:00 AM ShippedDate = 1/12/1998 12:00:00 AM ShipVia = 1 Freight = 59.7800 ShipName = Reggiani Caseifici ShipAddress = Strada Provinciale 124 ShipCity = Reggio Emilia ShipRegion = nothing ShipPostalCode = 42100 ShipCountry = Italy
OrderID = 10814 CustomerID = VICTE EmployeeID = 3 OrderDate = 1/5/1998 12:00:00 AM RequiredDate = 2/2/1998 12:00:00 AM ShippedDate = 1/14/1998 12:00:00 AM ShipVia = 3 Freight = 130.9400 ShipName = Victuailles en stock ShipAddress = 2, rue du Commerce ShipCity = Lyon ShipRegion = nothing ShipPostalCode = 69004 ShipCountry = France
OrderID = 10815 CustomerID = SAVEA EmployeeID = 2 OrderDate = 1/5/1998 12:00:00 AM RequiredDate = 2/2/1998 12:00:00 AM ShippedDate = 1/14/1998 12:00:00 AM ShipVia = 3 Freight = 14.6200 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10816 CustomerID = GREAL EmployeeID = 4 OrderDate = 1/6/1998 12:00:00 AM RequiredDate = 2/3/1998 12:00:00 AM ShippedDate = 2/4/1998 12:00:00 AM ShipVia = 2 Freight = 719.7800 ShipName = Great Lakes Food Market ShipAddress = 2732 Baker Blvd. ShipCity = Eugene ShipRegion = OR ShipPostalCode = 97403 ShipCountry = USA
OrderID = 10819 CustomerID = CACTU EmployeeID = 2 OrderDate = 1/7/1998 12:00:00 AM RequiredDate = 2/4/1998 12:00:00 AM ShippedDate = 1/16/1998 12:00:00 AM ShipVia = 3 Freight = 19.7600 ShipName = Cactus Comidas para llevar ShipAddress = Cerrito 333 ShipCity = Buenos Aires ShipRegion = nothing ShipPostalCode = 1010 ShipCountry = Argentina
OrderID = 10822 CustomerID = TRAIH EmployeeID = 6 OrderDate = 1/8/1998 12:00:00 AM RequiredDate = 2/5/1998 12:00:00 AM ShippedDate = 1/16/1998 12:00:00 AM ShipVia = 3 Freight = 7.0000 ShipName = Trail's Head Gourmet Provisioners ShipAddress = 722 DaVinci Blvd. ShipCity = Kirkland ShipRegion = WA ShipPostalCode = 98034 ShipCountry = USA
OrderID = 10824 CustomerID = FOLKO EmployeeID = 8 OrderDate = 1/9/1998 12:00:00 AM RequiredDate = 2/6/1998 12:00:00 AM ShippedDate = 1/30/1998 12:00:00 AM ShipVia = 1 Freight = 1.2300 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10826 CustomerID = BLONP EmployeeID = 6 OrderDate = 1/12/1998 12:00:00 AM RequiredDate = 2/9/1998 12:00:00 AM ShippedDate = 2/6/1998 12:00:00 AM ShipVia = 1 Freight = 7.0900 ShipName = Blondel père et fils ShipAddress = 24, place Kléber ShipCity = Strasbourg ShipRegion = nothing ShipPostalCode = 67000 ShipCountry = France
OrderID = 10827 CustomerID = BONAP EmployeeID = 1 OrderDate = 1/12/1998 12:00:00 AM RequiredDate = 1/26/1998 12:00:00 AM ShippedDate = 2/6/1998 12:00:00 AM ShipVia = 2 Freight = 63.5400 ShipName = Bon app' ShipAddress = 12, rue des Bouchers ShipCity = Marseille ShipRegion = nothing ShipPostalCode = 13008 ShipCountry = France
OrderID = 10828 CustomerID = RANCH EmployeeID = 9 OrderDate = 1/13/1998 12:00:00 AM RequiredDate = 1/27/1998 12:00:00 AM ShippedDate = 2/4/1998 12:00:00 AM ShipVia = 1 Freight = 90.8500 ShipName = Rancho grande ShipAddress = Av. del Libertador 900 ShipCity = Buenos Aires ShipRegion = nothing ShipPostalCode = 1010 ShipCountry = Argentina
OrderID = 10829 CustomerID = ISLAT EmployeeID = 9 OrderDate = 1/13/1998 12:00:00 AM RequiredDate = 2/10/1998 12:00:00 AM ShippedDate = 1/23/1998 12:00:00 AM ShipVia = 1 Freight = 154.7200 ShipName = Island Trading ShipAddress = Garden House Crowther Way ShipCity = Cowes ShipRegion = Isle of Wight ShipPostalCode = PO31 7PJ ShipCountry = UK
OrderID = 10830 CustomerID = TRADH EmployeeID = 4 OrderDate = 1/13/1998 12:00:00 AM RequiredDate = 2/24/1998 12:00:00 AM ShippedDate = 1/21/1998 12:00:00 AM ShipVia = 2 Freight = 81.8300 ShipName = Tradiçao Hipermercados ShipAddress = Av. Inês de Castro, 414 ShipCity = Sao Paulo ShipRegion = SP ShipPostalCode = 05634-030 ShipCountry = Brazil
OrderID = 10831 CustomerID = SANTG EmployeeID = 3 OrderDate = 1/14/1998 12:00:00 AM RequiredDate = 2/11/1998 12:00:00 AM ShippedDate = 1/23/1998 12:00:00 AM ShipVia = 2 Freight = 72.1900 ShipName = Santé Gourmet ShipAddress = Erling Skakkes gate 78 ShipCity = Stavern ShipRegion = nothing ShipPostalCode = 4110 ShipCountry = Norway
OrderID = 10833 CustomerID = OTTIK EmployeeID = 6 OrderDate = 1/15/1998 12:00:00 AM RequiredDate = 2/12/1998 12:00:00 AM ShippedDate = 1/23/1998 12:00:00 AM ShipVia = 2 Freight = 71.4900 ShipName = Ottilies Käseladen ShipAddress = Mehrheimerstr. 369 ShipCity = Köln ShipRegion = nothing ShipPostalCode = 50739 ShipCountry = Germany
OrderID = 10840 CustomerID = LINOD EmployeeID = 4 OrderDate = 1/19/1998 12:00:00 AM RequiredDate = 3/2/1998 12:00:00 AM ShippedDate = 2/16/1998 12:00:00 AM ShipVia = 2 Freight = 2.7100 ShipName = LINO-Delicateses ShipAddress = Ave. 5 de Mayo Porlamar ShipCity = I. de Margarita ShipRegion = Nueva Esparta ShipPostalCode = 4980 ShipCountry = Venezuela
OrderID = 10841 CustomerID = SUPRD EmployeeID = 5 OrderDate = 1/20/1998 12:00:00 AM RequiredDate = 2/17/1998 12:00:00 AM ShippedDate = 1/29/1998 12:00:00 AM ShipVia = 2 Freight = 424.3000 ShipName = Suprêmes délices ShipAddress = Boulevard Tirou, 255 ShipCity = Charleroi ShipRegion = nothing ShipPostalCode = B-6000 ShipCountry = Belgium
OrderID = 10842 CustomerID = TORTU EmployeeID = 1 OrderDate = 1/20/1998 12:00:00 AM RequiredDate = 2/17/1998 12:00:00 AM ShippedDate = 1/29/1998 12:00:00 AM ShipVia = 3 Freight = 54.4200 ShipName = Tortuga Restaurante ShipAddress = Avda. Azteca 123 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05033 ShipCountry = Mexico
OrderID = 10845 CustomerID = QUICK EmployeeID = 8 OrderDate = 1/21/1998 12:00:00 AM RequiredDate = 2/4/1998 12:00:00 AM ShippedDate = 1/30/1998 12:00:00 AM ShipVia = 1 Freight = 212.9800 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10847 CustomerID = SAVEA EmployeeID = 4 OrderDate = 1/22/1998 12:00:00 AM RequiredDate = 2/5/1998 12:00:00 AM ShippedDate = 2/10/1998 12:00:00 AM ShipVia = 3 Freight = 487.5700 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10854 CustomerID = ERNSH EmployeeID = 3 OrderDate = 1/27/1998 12:00:00 AM RequiredDate = 2/24/1998 12:00:00 AM ShippedDate = 2/5/1998 12:00:00 AM ShipVia = 2 Freight = 100.2200 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10855 CustomerID = OLDWO EmployeeID = 3 OrderDate = 1/27/1998 12:00:00 AM RequiredDate = 2/24/1998 12:00:00 AM ShippedDate = 2/4/1998 12:00:00 AM ShipVia = 1 Freight = 170.9700 ShipName = Old World Delicatessen ShipAddress = 2743 Bering St. ShipCity = Anchorage ShipRegion = AK ShipPostalCode = 99508 ShipCountry = USA
OrderID = 10856 CustomerID = ANTON EmployeeID = 3 OrderDate = 1/28/1998 12:00:00 AM RequiredDate = 2/25/1998 12:00:00 AM ShippedDate = 2/10/1998 12:00:00 AM ShipVia = 2 Freight = 58.4300 ShipName = Antonio Moreno Taquería ShipAddress = Mataderos 2312 ShipCity = México D.F. ShipRegion = nothing ShipPostalCode = 05023 ShipCountry = Mexico
OrderID = 10857 CustomerID = BERGS EmployeeID = 8 OrderDate = 1/28/1998 12:00:00 AM RequiredDate = 2/25/1998 12:00:00 AM ShippedDate = 2/6/1998 12:00:00 AM ShipVia = 2 Freight = 188.8500 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10861 CustomerID = WHITC EmployeeID = 4 OrderDate = 1/30/1998 12:00:00 AM RequiredDate = 2/27/1998 12:00:00 AM ShippedDate = 2/17/1998 12:00:00 AM ShipVia = 2 Freight = 14.9300 ShipName = White Clover Markets ShipAddress = 1029 - 12th Ave. S. ShipCity = Seattle ShipRegion = WA ShipPostalCode = 98124 ShipCountry = USA
OrderID = 10863 CustomerID = HILAA EmployeeID = 4 OrderDate = 2/2/1998 12:00:00 AM RequiredDate = 3/2/1998 12:00:00 AM ShippedDate = 2/17/1998 12:00:00 AM ShipVia = 2 Freight = 30.2600 ShipName = HILARION-Abastos ShipAddress = Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity = San Cristóbal ShipRegion = Táchira ShipPostalCode = 5022 ShipCountry = Venezuela
OrderID = 10865 CustomerID = QUICK EmployeeID = 2 OrderDate = 2/2/1998 12:00:00 AM RequiredDate = 2/16/1998 12:00:00 AM ShippedDate = 2/12/1998 12:00:00 AM ShipVia = 1 Freight = 348.1400 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10866 CustomerID = BERGS EmployeeID = 5 OrderDate = 2/3/1998 12:00:00 AM RequiredDate = 3/3/1998 12:00:00 AM ShippedDate = 2/12/1998 12:00:00 AM ShipVia = 1 Freight = 109.1100 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10867 CustomerID = LONEP EmployeeID = 6 OrderDate = 2/3/1998 12:00:00 AM RequiredDate = 3/17/1998 12:00:00 AM ShippedDate = 2/11/1998 12:00:00 AM ShipVia = 1 Freight = 1.9300 ShipName = Lonesome Pine Restaurant ShipAddress = 89 Chiaroscuro Rd. ShipCity = Portland ShipRegion = OR ShipPostalCode = 97219 ShipCountry = USA
OrderID = 10868 CustomerID = QUEEN EmployeeID = 7 OrderDate = 2/4/1998 12:00:00 AM RequiredDate = 3/4/1998 12:00:00 AM ShippedDate = 2/23/1998 12:00:00 AM ShipVia = 2 Freight = 191.2700 ShipName = Queen Cozinha ShipAddress = Alameda dos Canàrios, 891 ShipCity = Sao Paulo ShipRegion = SP ShipPostalCode = 05487-020 ShipCountry = Brazil
OrderID = 10870 CustomerID = WOLZA EmployeeID = 5 OrderDate = 2/4/1998 12:00:00 AM RequiredDate = 3/4/1998 12:00:00 AM ShippedDate = 2/13/1998 12:00:00 AM ShipVia = 3 Freight = 12.0400 ShipName = Wolski Zajazd ShipAddress = ul. Filtrowa 68 ShipCity = Warszawa ShipRegion = nothing ShipPostalCode = 01-012 ShipCountry = Poland
OrderID = 10875 CustomerID = BERGS EmployeeID = 4 OrderDate = 2/6/1998 12:00:00 AM RequiredDate = 3/6/1998 12:00:00 AM ShippedDate = 3/3/1998 12:00:00 AM ShipVia = 2 Freight = 32.3700 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10877 CustomerID = RICAR EmployeeID = 1 OrderDate = 2/9/1998 12:00:00 AM RequiredDate = 3/9/1998 12:00:00 AM ShippedDate = 2/19/1998 12:00:00 AM ShipVia = 1 Freight = 38.0600 ShipName = Ricardo Adocicados ShipAddress = Av. Copacabana, 267 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 02389-890 ShipCountry = Brazil
OrderID = 10880 CustomerID = FOLKO EmployeeID = 7 OrderDate = 2/10/1998 12:00:00 AM RequiredDate = 3/24/1998 12:00:00 AM ShippedDate = 2/18/1998 12:00:00 AM ShipVia = 1 Freight = 88.0100 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10882 CustomerID = SAVEA EmployeeID = 4 OrderDate = 2/11/1998 12:00:00 AM RequiredDate = 3/11/1998 12:00:00 AM ShippedDate = 2/20/1998 12:00:00 AM ShipVia = 3 Freight = 23.1000 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10883 CustomerID = LONEP EmployeeID = 8 OrderDate = 2/12/1998 12:00:00 AM RequiredDate = 3/12/1998 12:00:00 AM ShippedDate = 2/20/1998 12:00:00 AM ShipVia = 3 Freight = 0.5300 ShipName = Lonesome Pine Restaurant ShipAddress = 89 Chiaroscuro Rd. ShipCity = Portland ShipRegion = OR ShipPostalCode = 97219 ShipCountry = USA
OrderID = 10886 CustomerID = HANAR EmployeeID = 1 OrderDate = 2/13/1998 12:00:00 AM RequiredDate = 3/13/1998 12:00:00 AM ShippedDate = 3/2/1998 12:00:00 AM ShipVia = 1 Freight = 4.9900 ShipName = Hanari Carnes ShipAddress = Rua do Paço, 67 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 05454-876 ShipCountry = Brazil
OrderID = 10896 CustomerID = MAISD EmployeeID = 7 OrderDate = 2/19/1998 12:00:00 AM RequiredDate = 3/19/1998 12:00:00 AM ShippedDate = 2/27/1998 12:00:00 AM ShipVia = 3 Freight = 32.4500 ShipName = Maison Dewey ShipAddress = Rue Joseph-Bens 532 ShipCity = Bruxelles ShipRegion = nothing ShipPostalCode = B-1180 ShipCountry = Belgium
OrderID = 10898 CustomerID = OCEAN EmployeeID = 4 OrderDate = 2/20/1998 12:00:00 AM RequiredDate = 3/20/1998 12:00:00 AM ShippedDate = 3/6/1998 12:00:00 AM ShipVia = 2 Freight = 1.2700 ShipName = Océano Atlántico Ltda. ShipAddress = Ing. Gustavo Moncada 8585 Piso 20-A ShipCity = Buenos Aires ShipRegion = nothing ShipPostalCode = 1010 ShipCountry = Argentina
OrderID = 10900 CustomerID = WELLI EmployeeID = 1 OrderDate = 2/20/1998 12:00:00 AM RequiredDate = 3/20/1998 12:00:00 AM ShippedDate = 3/4/1998 12:00:00 AM ShipVia = 2 Freight = 1.6600 ShipName = Wellington Importadora ShipAddress = Rua do Mercado, 12 ShipCity = Resende ShipRegion = SP ShipPostalCode = 08737-363 ShipCountry = Brazil
OrderID = 10902 CustomerID = FOLKO EmployeeID = 1 OrderDate = 2/23/1998 12:00:00 AM RequiredDate = 3/23/1998 12:00:00 AM ShippedDate = 3/3/1998 12:00:00 AM ShipVia = 1 Freight = 44.1500 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10903 CustomerID = HANAR EmployeeID = 3 OrderDate = 2/24/1998 12:00:00 AM RequiredDate = 3/24/1998 12:00:00 AM ShippedDate = 3/4/1998 12:00:00 AM ShipVia = 3 Freight = 36.7100 ShipName = Hanari Carnes ShipAddress = Rua do Paço, 67 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 05454-876 ShipCountry = Brazil
OrderID = 10905 CustomerID = WELLI EmployeeID = 9 OrderDate = 2/24/1998 12:00:00 AM RequiredDate = 3/24/1998 12:00:00 AM ShippedDate = 3/6/1998 12:00:00 AM ShipVia = 2 Freight = 13.7200 ShipName = Wellington Importadora ShipAddress = Rua do Mercado, 12 ShipCity = Resende ShipRegion = SP ShipPostalCode = 08737-363 ShipCountry = Brazil
OrderID = 10908 CustomerID = REGGC EmployeeID = 4 OrderDate = 2/26/1998 12:00:00 AM RequiredDate = 3/26/1998 12:00:00 AM ShippedDate = 3/6/1998 12:00:00 AM ShipVia = 2 Freight = 32.9600 ShipName = Reggiani Caseifici ShipAddress = Strada Provinciale 124 ShipCity = Reggio Emilia ShipRegion = nothing ShipPostalCode = 42100 ShipCountry = Italy
OrderID = 10909 CustomerID = SANTG EmployeeID = 1 OrderDate = 2/26/1998 12:00:00 AM RequiredDate = 3/26/1998 12:00:00 AM ShippedDate = 3/10/1998 12:00:00 AM ShipVia = 2 Freight = 53.0500 ShipName = Santé Gourmet ShipAddress = Erling Skakkes gate 78 ShipCity = Stavern ShipRegion = nothing ShipPostalCode = 4110 ShipCountry = Norway
OrderID = 10912 CustomerID = HUNGO EmployeeID = 2 OrderDate = 2/26/1998 12:00:00 AM RequiredDate = 3/26/1998 12:00:00 AM ShippedDate = 3/18/1998 12:00:00 AM ShipVia = 2 Freight = 580.9100 ShipName = Hungry Owl All-Night Grocers ShipAddress = 8 Johnstown Road ShipCity = Cork ShipRegion = Co. Cork ShipPostalCode = nothing ShipCountry = Ireland
OrderID = 10916 CustomerID = RANCH EmployeeID = 1 OrderDate = 2/27/1998 12:00:00 AM RequiredDate = 3/27/1998 12:00:00 AM ShippedDate = 3/9/1998 12:00:00 AM ShipVia = 2 Freight = 63.7700 ShipName = Rancho grande ShipAddress = Av. del Libertador 900 ShipCity = Buenos Aires ShipRegion = nothing ShipPostalCode = 1010 ShipCountry = Argentina
OrderID = 10917 CustomerID = ROMEY EmployeeID = 4 OrderDate = 3/2/1998 12:00:00 AM RequiredDate = 3/30/1998 12:00:00 AM ShippedDate = 3/11/1998 12:00:00 AM ShipVia = 2 Freight = 8.2900 ShipName = Romero y tomillo ShipAddress = Gran Vía, 1 ShipCity = Madrid ShipRegion = nothing ShipPostalCode = 28001 ShipCountry = Spain
OrderID = 10918 CustomerID = BOTTM EmployeeID = 3 OrderDate = 3/2/1998 12:00:00 AM RequiredDate = 3/30/1998 12:00:00 AM ShippedDate = 3/11/1998 12:00:00 AM ShipVia = 3 Freight = 48.8300 ShipName = Bottom-Dollar Markets ShipAddress = 23 Tsawassen Blvd. ShipCity = Tsawassen ShipRegion = BC ShipPostalCode = T2F 8M4 ShipCountry = Canada
OrderID = 10923 CustomerID = LAMAI EmployeeID = 7 OrderDate = 3/3/1998 12:00:00 AM RequiredDate = 4/14/1998 12:00:00 AM ShippedDate = 3/13/1998 12:00:00 AM ShipVia = 3 Freight = 68.2600 ShipName = La maison d'Asie ShipAddress = 1 rue Alsace-Lorraine ShipCity = Toulouse ShipRegion = nothing ShipPostalCode = 31000 ShipCountry = France
OrderID = 10924 CustomerID = BERGS EmployeeID = 3 OrderDate = 3/4/1998 12:00:00 AM RequiredDate = 4/1/1998 12:00:00 AM ShippedDate = 4/8/1998 12:00:00 AM ShipVia = 2 Freight = 151.5200 ShipName = Berglunds snabbköp ShipAddress = Berguvsvägen 8 ShipCity = Luleå ShipRegion = nothing ShipPostalCode = S-958 22 ShipCountry = Sweden
OrderID = 10925 CustomerID = HANAR EmployeeID = 3 OrderDate = 3/4/1998 12:00:00 AM RequiredDate = 4/1/1998 12:00:00 AM ShippedDate = 3/13/1998 12:00:00 AM ShipVia = 1 Freight = 2.2700 ShipName = Hanari Carnes ShipAddress = Rua do Paço, 67 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 05454-876 ShipCountry = Brazil
OrderID = 10927 CustomerID = LACOR EmployeeID = 4 OrderDate = 3/5/1998 12:00:00 AM RequiredDate = 4/2/1998 12:00:00 AM ShippedDate = 4/8/1998 12:00:00 AM ShipVia = 1 Freight = 19.7900 ShipName = La corne d'abondance ShipAddress = 67, avenue de l'Europe ShipCity = Versailles ShipRegion = nothing ShipPostalCode = 78000 ShipCountry = France
OrderID = 10928 CustomerID = GALED EmployeeID = 1 OrderDate = 3/5/1998 12:00:00 AM RequiredDate = 4/2/1998 12:00:00 AM ShippedDate = 3/18/1998 12:00:00 AM ShipVia = 1 Freight = 1.3600 ShipName = Galería del gastronómo ShipAddress = Rambla de Cataluña, 23 ShipCity = Barcelona ShipRegion = nothing ShipPostalCode = 8022 ShipCountry = Spain
OrderID = 10930 CustomerID = SUPRD EmployeeID = 4 OrderDate = 3/6/1998 12:00:00 AM RequiredDate = 4/17/1998 12:00:00 AM ShippedDate = 3/18/1998 12:00:00 AM ShipVia = 3 Freight = 15.5500 ShipName = Suprêmes délices ShipAddress = Boulevard Tirou, 255 ShipCity = Charleroi ShipRegion = nothing ShipPostalCode = B-6000 ShipCountry = Belgium
OrderID = 10931 CustomerID = RICSU EmployeeID = 4 OrderDate = 3/6/1998 12:00:00 AM RequiredDate = 3/20/1998 12:00:00 AM ShippedDate = 3/19/1998 12:00:00 AM ShipVia = 2 Freight = 13.6000 ShipName = Richter Supermarkt ShipAddress = Starenweg 5 ShipCity = Genève ShipRegion = nothing ShipPostalCode = 1204 ShipCountry = Switzerland
OrderID = 10932 CustomerID = BONAP EmployeeID = 8 OrderDate = 3/6/1998 12:00:00 AM RequiredDate = 4/3/1998 12:00:00 AM ShippedDate = 3/24/1998 12:00:00 AM ShipVia = 1 Freight = 134.6400 ShipName = Bon app' ShipAddress = 12, rue des Bouchers ShipCity = Marseille ShipRegion = nothing ShipPostalCode = 13008 ShipCountry = France
OrderID = 10933 CustomerID = ISLAT EmployeeID = 6 OrderDate = 3/6/1998 12:00:00 AM RequiredDate = 4/3/1998 12:00:00 AM ShippedDate = 3/16/1998 12:00:00 AM ShipVia = 3 Freight = 54.1500 ShipName = Island Trading ShipAddress = Garden House Crowther Way ShipCity = Cowes ShipRegion = Isle of Wight ShipPostalCode = PO31 7PJ ShipCountry = UK
OrderID = 10935 CustomerID = WELLI EmployeeID = 4 OrderDate = 3/9/1998 12:00:00 AM RequiredDate = 4/6/1998 12:00:00 AM ShippedDate = 3/18/1998 12:00:00 AM ShipVia = 3 Freight = 47.5900 ShipName = Wellington Importadora ShipAddress = Rua do Mercado, 12 ShipCity = Resende ShipRegion = SP ShipPostalCode = 08737-363 ShipCountry = Brazil
OrderID = 10936 CustomerID = GREAL EmployeeID = 3 OrderDate = 3/9/1998 12:00:00 AM RequiredDate = 4/6/1998 12:00:00 AM ShippedDate = 3/18/1998 12:00:00 AM ShipVia = 2 Freight = 33.6800 ShipName = Great Lakes Food Market ShipAddress = 2732 Baker Blvd. ShipCity = Eugene ShipRegion = OR ShipPostalCode = 97403 ShipCountry = USA
OrderID = 10940 CustomerID = BONAP EmployeeID = 8 OrderDate = 3/11/1998 12:00:00 AM RequiredDate = 4/8/1998 12:00:00 AM ShippedDate = 3/23/1998 12:00:00 AM ShipVia = 3 Freight = 19.7700 ShipName = Bon app' ShipAddress = 12, rue des Bouchers ShipCity = Marseille ShipRegion = nothing ShipPostalCode = 13008 ShipCountry = France
OrderID = 10941 CustomerID = SAVEA EmployeeID = 7 OrderDate = 3/11/1998 12:00:00 AM RequiredDate = 4/8/1998 12:00:00 AM ShippedDate = 3/20/1998 12:00:00 AM ShipVia = 2 Freight = 400.8100 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10943 CustomerID = BSBEV EmployeeID = 4 OrderDate = 3/11/1998 12:00:00 AM RequiredDate = 4/8/1998 12:00:00 AM ShippedDate = 3/19/1998 12:00:00 AM ShipVia = 2 Freight = 2.1700 ShipName = B's Beverages ShipAddress = Fauntleroy Circus ShipCity = London ShipRegion = nothing ShipPostalCode = EC2 5NT ShipCountry = UK
OrderID = 10951 CustomerID = RICSU EmployeeID = 9 OrderDate = 3/16/1998 12:00:00 AM RequiredDate = 4/27/1998 12:00:00 AM ShippedDate = 4/7/1998 12:00:00 AM ShipVia = 2 Freight = 30.8500 ShipName = Richter Supermarkt ShipAddress = Starenweg 5 ShipCity = Genève ShipRegion = nothing ShipPostalCode = 1204 ShipCountry = Switzerland
OrderID = 10952 CustomerID = ALFKI EmployeeID = 1 OrderDate = 3/16/1998 12:00:00 AM RequiredDate = 4/27/1998 12:00:00 AM ShippedDate = 3/24/1998 12:00:00 AM ShipVia = 1 Freight = 40.4200 ShipName = Alfred's Futterkiste ShipAddress = Obere Str. 57 ShipCity = Berlin ShipRegion = nothing ShipPostalCode = 12209 ShipCountry = Germany
OrderID = 10953 CustomerID = AROUT EmployeeID = 9 OrderDate = 3/16/1998 12:00:00 AM RequiredDate = 3/30/1998 12:00:00 AM ShippedDate = 3/25/1998 12:00:00 AM ShipVia = 2 Freight = 23.7200 ShipName = Around the Horn ShipAddress = Brook Farm Stratford St. Mary ShipCity = Colchester ShipRegion = Essex ShipPostalCode = CO7 6JX ShipCountry = UK
OrderID = 10957 CustomerID = HILAA EmployeeID = 8 OrderDate = 3/18/1998 12:00:00 AM RequiredDate = 4/15/1998 12:00:00 AM ShippedDate = 3/27/1998 12:00:00 AM ShipVia = 3 Freight = 105.3600 ShipName = HILARION-Abastos ShipAddress = Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity = San Cristóbal ShipRegion = Táchira ShipPostalCode = 5022 ShipCountry = Venezuela
OrderID = 10958 CustomerID = OCEAN EmployeeID = 7 OrderDate = 3/18/1998 12:00:00 AM RequiredDate = 4/15/1998 12:00:00 AM ShippedDate = 3/27/1998 12:00:00 AM ShipVia = 2 Freight = 49.5600 ShipName = Océano Atlántico Ltda. ShipAddress = Ing. Gustavo Moncada 8585 Piso 20-A ShipCity = Buenos Aires ShipRegion = nothing ShipPostalCode = 1010 ShipCountry = Argentina
OrderID = 10960 CustomerID = HILAA EmployeeID = 3 OrderDate = 3/19/1998 12:00:00 AM RequiredDate = 4/2/1998 12:00:00 AM ShippedDate = 4/8/1998 12:00:00 AM ShipVia = 1 Freight = 2.0800 ShipName = HILARION-Abastos ShipAddress = Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity = San Cristóbal ShipRegion = Táchira ShipPostalCode = 5022 ShipCountry = Venezuela
OrderID = 10961 CustomerID = QUEEN EmployeeID = 8 OrderDate = 3/19/1998 12:00:00 AM RequiredDate = 4/16/1998 12:00:00 AM ShippedDate = 3/30/1998 12:00:00 AM ShipVia = 1 Freight = 104.4700 ShipName = Queen Cozinha ShipAddress = Alameda dos Canàrios, 891 ShipCity = Sao Paulo ShipRegion = SP ShipPostalCode = 05487-020 ShipCountry = Brazil
OrderID = 10965 CustomerID = OLDWO EmployeeID = 6 OrderDate = 3/20/1998 12:00:00 AM RequiredDate = 4/17/1998 12:00:00 AM ShippedDate = 3/30/1998 12:00:00 AM ShipVia = 3 Freight = 144.3800 ShipName = Old World Delicatessen ShipAddress = 2743 Bering St. ShipCity = Anchorage ShipRegion = AK ShipPostalCode = 99508 ShipCountry = USA
OrderID = 10966 CustomerID = CHOPS EmployeeID = 4 OrderDate = 3/20/1998 12:00:00 AM RequiredDate = 4/17/1998 12:00:00 AM ShippedDate = 4/8/1998 12:00:00 AM ShipVia = 1 Freight = 27.1900 ShipName = Chop-suey Chinese ShipAddress = Hauptstr. 31 ShipCity = Bern ShipRegion = nothing ShipPostalCode = 3012 ShipCountry = Switzerland
OrderID = 10967 CustomerID = TOMSP EmployeeID = 2 OrderDate = 3/23/1998 12:00:00 AM RequiredDate = 4/20/1998 12:00:00 AM ShippedDate = 4/2/1998 12:00:00 AM ShipVia = 2 Freight = 62.2200 ShipName = Toms Spezialitäten ShipAddress = Luisenstr. 48 ShipCity = Münster ShipRegion = nothing ShipPostalCode = 44087 ShipCountry = Germany
OrderID = 10968 CustomerID = ERNSH EmployeeID = 1 OrderDate = 3/23/1998 12:00:00 AM RequiredDate = 4/20/1998 12:00:00 AM ShippedDate = 4/1/1998 12:00:00 AM ShipVia = 3 Freight = 74.6000 ShipName = Ernst Handel ShipAddress = Kirchgasse 6 ShipCity = Graz ShipRegion = nothing ShipPostalCode = 8010 ShipCountry = Austria
OrderID = 10970 CustomerID = BOLID EmployeeID = 9 OrderDate = 3/24/1998 12:00:00 AM RequiredDate = 4/7/1998 12:00:00 AM ShippedDate = 4/24/1998 12:00:00 AM ShipVia = 1 Freight = 16.1600 ShipName = Bólido Comidas preparadas ShipAddress = C/ Araquil, 67 ShipCity = Madrid ShipRegion = nothing ShipPostalCode = 28023 ShipCountry = Spain
OrderID = 10971 CustomerID = FRANR EmployeeID = 2 OrderDate = 3/24/1998 12:00:00 AM RequiredDate = 4/21/1998 12:00:00 AM ShippedDate = 4/2/1998 12:00:00 AM ShipVia = 2 Freight = 121.8200 ShipName = France restauration ShipAddress = 54, rue Royale ShipCity = Nantes ShipRegion = nothing ShipPostalCode = 44000 ShipCountry = France
OrderID = 10974 CustomerID = SPLIR EmployeeID = 3 OrderDate = 3/25/1998 12:00:00 AM RequiredDate = 4/8/1998 12:00:00 AM ShippedDate = 4/3/1998 12:00:00 AM ShipVia = 3 Freight = 12.9600 ShipName = Split Rail Beer & Ale ShipAddress = P.O. Box 555 ShipCity = Lander ShipRegion = WY ShipPostalCode = 82520 ShipCountry = USA
OrderID = 10976 CustomerID = HILAA EmployeeID = 1 OrderDate = 3/25/1998 12:00:00 AM RequiredDate = 5/6/1998 12:00:00 AM ShippedDate = 4/3/1998 12:00:00 AM ShipVia = 1 Freight = 37.9700 ShipName = HILARION-Abastos ShipAddress = Carrera 22 con Ave. Carlos Soublette #8-35 ShipCity = San Cristóbal ShipRegion = Táchira ShipPostalCode = 5022 ShipCountry = Venezuela
OrderID = 10977 CustomerID = FOLKO EmployeeID = 8 OrderDate = 3/26/1998 12:00:00 AM RequiredDate = 4/23/1998 12:00:00 AM ShippedDate = 4/10/1998 12:00:00 AM ShipVia = 3 Freight = 208.5000 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10978 CustomerID = MAISD EmployeeID = 9 OrderDate = 3/26/1998 12:00:00 AM RequiredDate = 4/23/1998 12:00:00 AM ShippedDate = 4/23/1998 12:00:00 AM ShipVia = 2 Freight = 32.8200 ShipName = Maison Dewey ShipAddress = Rue Joseph-Bens 532 ShipCity = Bruxelles ShipRegion = nothing ShipPostalCode = B-1180 ShipCountry = Belgium
OrderID = 10980 CustomerID = FOLKO EmployeeID = 4 OrderDate = 3/27/1998 12:00:00 AM RequiredDate = 5/8/1998 12:00:00 AM ShippedDate = 4/17/1998 12:00:00 AM ShipVia = 1 Freight = 1.2600 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10982 CustomerID = BOTTM EmployeeID = 2 OrderDate = 3/27/1998 12:00:00 AM RequiredDate = 4/24/1998 12:00:00 AM ShippedDate = 4/8/1998 12:00:00 AM ShipVia = 1 Freight = 14.0100 ShipName = Bottom-Dollar Markets ShipAddress = 23 Tsawassen Blvd. ShipCity = Tsawassen ShipRegion = BC ShipPostalCode = T2F 8M4 ShipCountry = Canada
OrderID = 10983 CustomerID = SAVEA EmployeeID = 2 OrderDate = 3/27/1998 12:00:00 AM RequiredDate = 4/24/1998 12:00:00 AM ShippedDate = 4/6/1998 12:00:00 AM ShipVia = 2 Freight = 657.5400 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 10986 CustomerID = OCEAN EmployeeID = 8 OrderDate = 3/30/1998 12:00:00 AM RequiredDate = 4/27/1998 12:00:00 AM ShippedDate = 4/21/1998 12:00:00 AM ShipVia = 2 Freight = 217.8600 ShipName = Océano Atlántico Ltda. ShipAddress = Ing. Gustavo Moncada 8585 Piso 20-A ShipCity = Buenos Aires ShipRegion = nothing ShipPostalCode = 1010 ShipCountry = Argentina
OrderID = 10988 CustomerID = RATTC EmployeeID = 3 OrderDate = 3/31/1998 12:00:00 AM RequiredDate = 4/28/1998 12:00:00 AM ShippedDate = 4/10/1998 12:00:00 AM ShipVia = 2 Freight = 61.1400 ShipName = Rattlesnake Canyon Grocery ShipAddress = 2817 Milton Dr. ShipCity = Albuquerque ShipRegion = NM ShipPostalCode = 87110 ShipCountry = USA
OrderID = 10993 CustomerID = FOLKO EmployeeID = 7 OrderDate = 4/1/1998 12:00:00 AM RequiredDate = 4/29/1998 12:00:00 AM ShippedDate = 4/10/1998 12:00:00 AM ShipVia = 3 Freight = 8.8100 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 10996 CustomerID = QUICK EmployeeID = 4 OrderDate = 4/2/1998 12:00:00 AM RequiredDate = 4/30/1998 12:00:00 AM ShippedDate = 4/10/1998 12:00:00 AM ShipVia = 2 Freight = 1.1200 ShipName = QUICK-Stop ShipAddress = Taucherstraße 10 ShipCity = Cunewalde ShipRegion = nothing ShipPostalCode = 01307 ShipCountry = Germany
OrderID = 10997 CustomerID = LILAS EmployeeID = 8 OrderDate = 4/3/1998 12:00:00 AM RequiredDate = 5/15/1998 12:00:00 AM ShippedDate = 4/13/1998 12:00:00 AM ShipVia = 2 Freight = 73.9100 ShipName = LILA-Supermercado ShipAddress = Carrera 52 con Ave. Bolívar #65-98 Llano Largo ShipCity = Barquisimeto ShipRegion = Lara ShipPostalCode = 3508 ShipCountry = Venezuela
OrderID = 10998 CustomerID = WOLZA EmployeeID = 8 OrderDate = 4/3/1998 12:00:00 AM RequiredDate = 4/17/1998 12:00:00 AM ShippedDate = 4/17/1998 12:00:00 AM ShipVia = 2 Freight = 20.3100 ShipName = Wolski Zajazd ShipAddress = ul. Filtrowa 68 ShipCity = Warszawa ShipRegion = nothing ShipPostalCode = 01-012 ShipCountry = Poland
OrderID = 11000 CustomerID = RATTC EmployeeID = 2 OrderDate = 4/6/1998 12:00:00 AM RequiredDate = 5/4/1998 12:00:00 AM ShippedDate = 4/14/1998 12:00:00 AM ShipVia = 3 Freight = 55.1200 ShipName = Rattlesnake Canyon Grocery ShipAddress = 2817 Milton Dr. ShipCity = Albuquerque ShipRegion = NM ShipPostalCode = 87110 ShipCountry = USA
OrderID = 11001 CustomerID = FOLKO EmployeeID = 2 OrderDate = 4/6/1998 12:00:00 AM RequiredDate = 5/4/1998 12:00:00 AM ShippedDate = 4/14/1998 12:00:00 AM ShipVia = 2 Freight = 197.3000 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
OrderID = 11002 CustomerID = SAVEA EmployeeID = 4 OrderDate = 4/6/1998 12:00:00 AM RequiredDate = 5/4/1998 12:00:00 AM ShippedDate = 4/16/1998 12:00:00 AM ShipVia = 1 Freight = 141.1600 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 11004 CustomerID = MAISD EmployeeID = 3 OrderDate = 4/7/1998 12:00:00 AM RequiredDate = 5/5/1998 12:00:00 AM ShippedDate = 4/20/1998 12:00:00 AM ShipVia = 1 Freight = 44.8400 ShipName = Maison Dewey ShipAddress = Rue Joseph-Bens 532 ShipCity = Bruxelles ShipRegion = nothing ShipPostalCode = B-1180 ShipCountry = Belgium
OrderID = 11006 CustomerID = GREAL EmployeeID = 3 OrderDate = 4/7/1998 12:00:00 AM RequiredDate = 5/5/1998 12:00:00 AM ShippedDate = 4/15/1998 12:00:00 AM ShipVia = 2 Freight = 25.1900 ShipName = Great Lakes Food Market ShipAddress = 2732 Baker Blvd. ShipCity = Eugene ShipRegion = OR ShipPostalCode = 97403 ShipCountry = USA
OrderID = 11010 CustomerID = REGGC EmployeeID = 2 OrderDate = 4/9/1998 12:00:00 AM RequiredDate = 5/7/1998 12:00:00 AM ShippedDate = 4/21/1998 12:00:00 AM ShipVia = 2 Freight = 28.7100 ShipName = Reggiani Caseifici ShipAddress = Strada Provinciale 124 ShipCity = Reggio Emilia ShipRegion = nothing ShipPostalCode = 42100 ShipCountry = Italy
OrderID = 11012 CustomerID = FRANK EmployeeID = 1 OrderDate = 4/9/1998 12:00:00 AM RequiredDate = 4/23/1998 12:00:00 AM ShippedDate = 4/17/1998 12:00:00 AM ShipVia = 3 Freight = 242.9500 ShipName = Frankenversand ShipAddress = Berliner Platz 43 ShipCity = München ShipRegion = nothing ShipPostalCode = 80805 ShipCountry = Germany
OrderID = 11015 CustomerID = SANTG EmployeeID = 2 OrderDate = 4/10/1998 12:00:00 AM RequiredDate = 4/24/1998 12:00:00 AM ShippedDate = 4/20/1998 12:00:00 AM ShipVia = 2 Freight = 4.6200 ShipName = Santé Gourmet ShipAddress = Erling Skakkes gate 78 ShipCity = Stavern ShipRegion = nothing ShipPostalCode = 4110 ShipCountry = Norway
OrderID = 11022 CustomerID = HANAR EmployeeID = 9 OrderDate = 4/14/1998 12:00:00 AM RequiredDate = 5/12/1998 12:00:00 AM ShippedDate = 5/4/1998 12:00:00 AM ShipVia = 2 Freight = 6.2700 ShipName = Hanari Carnes ShipAddress = Rua do Paço, 67 ShipCity = Rio de Janeiro ShipRegion = RJ ShipPostalCode = 05454-876 ShipCountry = Brazil
OrderID = 11023 CustomerID = BSBEV EmployeeID = 1 OrderDate = 4/14/1998 12:00:00 AM RequiredDate = 4/28/1998 12:00:00 AM ShippedDate = 4/24/1998 12:00:00 AM ShipVia = 2 Freight = 123.8300 ShipName = B's Beverages ShipAddress = Fauntleroy Circus ShipCity = London ShipRegion = nothing ShipPostalCode = EC2 5NT ShipCountry = UK
OrderID = 11025 CustomerID = WARTH EmployeeID = 6 OrderDate = 4/15/1998 12:00:00 AM RequiredDate = 5/13/1998 12:00:00 AM ShippedDate = 4/24/1998 12:00:00 AM ShipVia = 3 Freight = 29.1700 ShipName = Wartian Herkku ShipAddress = Torikatu 38 ShipCity = Oulu ShipRegion = nothing ShipPostalCode = 90110 ShipCountry = Finland
OrderID = 11026 CustomerID = FRANS EmployeeID = 4 OrderDate = 4/15/1998 12:00:00 AM RequiredDate = 5/13/1998 12:00:00 AM ShippedDate = 4/28/1998 12:00:00 AM ShipVia = 1 Freight = 47.0900 ShipName = Franchi S.p.A. ShipAddress = Via Monte Bianco 34 ShipCity = Torino ShipRegion = nothing ShipPostalCode = 10100 ShipCountry = Italy
OrderID = 11029 CustomerID = CHOPS EmployeeID = 4 OrderDate = 4/16/1998 12:00:00 AM RequiredDate = 5/14/1998 12:00:00 AM ShippedDate = 4/27/1998 12:00:00 AM ShipVia = 1 Freight = 47.8400 ShipName = Chop-suey Chinese ShipAddress = Hauptstr. 31 ShipCity = Bern ShipRegion = nothing ShipPostalCode = 3012 ShipCountry = Switzerland
OrderID = 11030 CustomerID = SAVEA EmployeeID = 7 OrderDate = 4/17/1998 12:00:00 AM RequiredDate = 5/15/1998 12:00:00 AM ShippedDate = 4/27/1998 12:00:00 AM ShipVia = 2 Freight = 830.7500 ShipName = Save-a-lot Markets ShipAddress = 187 Suffolk Ln. ShipCity = Boise ShipRegion = ID ShipPostalCode = 83720 ShipCountry = USA
OrderID = 11038 CustomerID = SUPRD EmployeeID = 1 OrderDate = 4/21/1998 12:00:00 AM RequiredDate = 5/19/1998 12:00:00 AM ShippedDate = 4/30/1998 12:00:00 AM ShipVia = 2 Freight = 29.5900 ShipName = Suprêmes délices ShipAddress = Boulevard Tirou, 255 ShipCity = Charleroi ShipRegion = nothing ShipPostalCode = B-6000 ShipCountry = Belgium
OrderID = 11042 CustomerID = COMMI EmployeeID = 2 OrderDate = 4/22/1998 12:00:00 AM RequiredDate = 5/6/1998 12:00:00 AM ShippedDate = 5/1/1998 12:00:00 AM ShipVia = 1 Freight = 29.9900 ShipName = Comércio Mineiro ShipAddress = Av. dos Lusíadas, 23 ShipCity = Sao Paulo ShipRegion = SP ShipPostalCode = 05432-043 ShipCountry = Brazil
OrderID = 11044 CustomerID = WOLZA EmployeeID = 4 OrderDate = 4/23/1998 12:00:00 AM RequiredDate = 5/21/1998 12:00:00 AM ShippedDate = 5/1/1998 12:00:00 AM ShipVia = 1 Freight = 8.7200 ShipName = Wolski Zajazd ShipAddress = ul. Filtrowa 68 ShipCity = Warszawa ShipRegion = nothing ShipPostalCode = 01-012 ShipCountry = Poland
OrderID = 11049 CustomerID = GOURL EmployeeID = 3 OrderDate = 4/24/1998 12:00:00 AM RequiredDate = 5/22/1998 12:00:00 AM ShippedDate = 5/4/1998 12:00:00 AM ShipVia = 1 Freight = 8.3400 ShipName = Gourmet Lanchonetes ShipAddress = Av. Brasil, 442 ShipCity = Campinas ShipRegion = SP ShipPostalCode = 04876-786 ShipCountry = Brazil
OrderID = 11050 CustomerID = FOLKO EmployeeID = 8 OrderDate = 4/27/1998 12:00:00 AM RequiredDate = 5/25/1998 12:00:00 AM ShippedDate = 5/5/1998 12:00:00 AM ShipVia = 2 Freight = 59.4100 ShipName = Folk och fä HB ShipAddress = Åkergatan 24 ShipCity = Bräcke ShipRegion = nothing ShipPostalCode = S-844 67 ShipCountry = Sweden
