Skip to content

Instantly share code, notes, and snippets.

@jesuslpm

jesuslpm/JsonFromDatatableResult.cs

Last active September 9, 2023 18:49
Show Gist options
  • Save jesuslpm/43b0400531efdd005da6741077d3fd63 to your computer and use it in GitHub Desktop.
Save jesuslpm/43b0400531efdd005da6741077d3fd63 to your computer and use it in GitHub Desktop.
Download ZIP
Get a pretty json response from datatable
Raw
JsonFromDatatableResult.cs
using Microsoft.AspNetCore.Mvc;
using System.Data;
using System.Text.Json;
namespace DynamicQueryToJson.Controllers
{
public class JsonFromDatatableResult : ActionResult
{
private readonly DataTable dataTable;
private static Dictionary<Type, Action<Utf8JsonWriter, string, object>> valueWriterByType = new Dictionary<Type, Action<Utf8JsonWriter, string, object>>
{
[typeof(decimal)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteNumber(propertyName, (decimal)value); },
[typeof(double)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteNumber(propertyName, (double)value); },
[typeof(float)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteNumber(propertyName, (float)value); },
[typeof(int)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteNumber(propertyName, (int)value); },
[typeof(long)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteNumber(propertyName, (long)value); },
[typeof(uint)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteNumber(propertyName, (uint)value); },
[typeof(ulong)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteNumber(propertyName, (ulong)value); },
[typeof(bool)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteBoolean(propertyName, (bool)value); },
[typeof(byte[])] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteBase64String(propertyName, (byte[])value); },
[typeof(string)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteString(propertyName, (string)value); },
[typeof(DateTime)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteString(propertyName, ((DateTime)value).ToString("O")); },
[typeof(DateOnly)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteString(propertyName, ((DateOnly)value).ToString("O")); },
[typeof(TimeSpan)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteString(propertyName, ((TimeSpan)value).ToString("c")); },
[typeof(TimeOnly)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteString(propertyName, ((TimeOnly)value).ToString("O")); },
[typeof(Guid)] = (Utf8JsonWriter writer, string propertyName, object value) => { writer.WriteString(propertyName, ((Guid)value).ToString()); },
};
public JsonFromDatatableResult(DataTable dataTable)
{
this.dataTable = dataTable;
}
public override void ExecuteResult(ActionContext context)
{
var valueWriters = new Action<Utf8JsonWriter, string, object>[this.dataTable.Columns.Count];
for (int i = 0; i < this.dataTable.Columns.Count; i++)
{
var column = this.dataTable.Columns[i];
if (valueWriterByType.TryGetValue(column.DataType, out var writer))
{
valueWriters[i] = writer;
}
else
{
throw new NotSupportedException($"Not supported type: '{column.DataType}' of column '{column.ColumnName}'");
}
}
context.HttpContext.Response.StatusCode = StatusCodes.Status200OK;
context.HttpContext.Response.Headers.ContentType = "application/json;charset=utf-8";
var options = new JsonWriterOptions { Indented= true };
using (var writer = new Utf8JsonWriter(context.HttpContext.Response.Body, options))
{
writer.WriteStartArray();
foreach (DataRow row in dataTable.Rows)
{
writer.WriteStartObject();
for (int i = 0; i < this.dataTable.Columns.Count; i++)
{
var col = this.dataTable.Columns[i];
var value = row[col];
if (Convert.IsDBNull(value) || value == null)
{
writer.WriteNull(col.ColumnName);
}
else
{
valueWriters[i](writer, col.ColumnName, value);
}
}
writer.WriteEndObject();
}
writer.WriteEndArray();
}
}
}
}
Raw
QueryController.cs
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using System.Data;
using System.Data.SqlClient;
namespace DynamicQueryToJson.Controllers
{
[Route("api/[controller]")]
[ApiController]
public class QueryController : ControllerBase
{
[HttpGet]
public async Task<IActionResult> Get()
{
using (var cn = new SqlConnection("Data Source=.;Initial Catalog=Northwind;Integrated Security=SSPI"))
using (var cmd = new SqlCommand("SELECT * FROM dbo.Orders", cn))
{
cn.Open();
using (var dataReader = await cmd.ExecuteReaderAsync())
{
var dataTable = new DataTable("Orders");
dataTable.Load(dataReader);
return new JsonFromDatatableResult(dataTable);
}
}
}
}
}
Raw
response_sample.json
[
{
"OrderID": 10248,
"CustomerID": "VINET",
"EmployeeID": 5,
"OrderDate": "1996-07-04T00:00:00.0000000",
"RequiredDate": "1996-08-01T00:00:00.0000000",
"ShippedDate": "1996-07-16T00:00:00.0000000",
"ShipVia": 3,
"Freight": 32.3800,
"ShipName": "Vins et alcools Chevalier",
"ShipAddress": "59 rue de l\u0027Abbaye",
"ShipCity": "Reims",
"ShipRegion": null,
"ShipPostalCode": "51100",
"ShipCountry": "France"
},
{
"OrderID": 10249,
"CustomerID": "TOMSP",
"EmployeeID": 6,
"OrderDate": "1996-07-05T00:00:00.0000000",
"RequiredDate": "1996-08-16T00:00:00.0000000",
"ShippedDate": "1996-07-10T00:00:00.0000000",
"ShipVia": 1,
"Freight": 11.6100,
"ShipName": "Toms Spezialit\u00E4ten",
"ShipAddress": "Luisenstr. 48",
"ShipCity": "M\u00FCnster",
"ShipRegion": null,
"ShipPostalCode": "44087",
"ShipCountry": "Germany"
},
{
"OrderID": 10250,
"CustomerID": "HANAR",
"EmployeeID": 4,
"OrderDate": "1996-07-08T00:00:00.0000000",
"RequiredDate": "1996-08-05T00:00:00.0000000",
"ShippedDate": "1996-07-12T00:00:00.0000000",
"ShipVia": 2,
"Freight": 65.8300,
"ShipName": "Hanari Carnes",
"ShipAddress": "Rua do Pa\u00E7o, 67",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "05454-876",
"ShipCountry": "Brazil"
},
{
"OrderID": 10251,
"CustomerID": "VICTE",
"EmployeeID": 3,
"OrderDate": "1996-07-08T00:00:00.0000000",
"RequiredDate": "1996-08-05T00:00:00.0000000",
"ShippedDate": "1996-07-15T00:00:00.0000000",
"ShipVia": 1,
"Freight": 41.3400,
"ShipName": "Victuailles en stock",
"ShipAddress": "2, rue du Commerce",
"ShipCity": "Lyon",
"ShipRegion": null,
"ShipPostalCode": "69004",
"ShipCountry": "France"
},
{
"OrderID": 10252,
"CustomerID": "SUPRD",
"EmployeeID": 4,
"OrderDate": "1996-07-09T00:00:00.0000000",
"RequiredDate": "1996-08-06T00:00:00.0000000",
"ShippedDate": "1996-07-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 51.3000,
"ShipName": "Supr\u00EAmes d\u00E9lices",
"ShipAddress": "Boulevard Tirou, 255",
"ShipCity": "Charleroi",
"ShipRegion": null,
"ShipPostalCode": "B-6000",
"ShipCountry": "Belgium"
},
{
"OrderID": 10253,
"CustomerID": "HANAR",
"EmployeeID": 3,
"OrderDate": "1996-07-10T00:00:00.0000000",
"RequiredDate": "1996-07-24T00:00:00.0000000",
"ShippedDate": "1996-07-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 58.1700,
"ShipName": "Hanari Carnes",
"ShipAddress": "Rua do Pa\u00E7o, 67",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "05454-876",
"ShipCountry": "Brazil"
},
{
"OrderID": 10254,
"CustomerID": "CHOPS",
"EmployeeID": 5,
"OrderDate": "1996-07-11T00:00:00.0000000",
"RequiredDate": "1996-08-08T00:00:00.0000000",
"ShippedDate": "1996-07-23T00:00:00.0000000",
"ShipVia": 2,
"Freight": 22.9800,
"ShipName": "Chop-suey Chinese",
"ShipAddress": "Hauptstr. 31",
"ShipCity": "Bern",
"ShipRegion": null,
"ShipPostalCode": "3012",
"ShipCountry": "Switzerland"
},
{
"OrderID": 10255,
"CustomerID": "RICSU",
"EmployeeID": 9,
"OrderDate": "1996-07-12T00:00:00.0000000",
"RequiredDate": "1996-08-09T00:00:00.0000000",
"ShippedDate": "1996-07-15T00:00:00.0000000",
"ShipVia": 3,
"Freight": 148.3300,
"ShipName": "Richter Supermarkt",
"ShipAddress": "Starenweg 5",
"ShipCity": "Gen\u00E8ve",
"ShipRegion": null,
"ShipPostalCode": "1204",
"ShipCountry": "Switzerland"
},
{
"OrderID": 10256,
"CustomerID": "WELLI",
"EmployeeID": 3,
"OrderDate": "1996-07-15T00:00:00.0000000",
"RequiredDate": "1996-08-12T00:00:00.0000000",
"ShippedDate": "1996-07-17T00:00:00.0000000",
"ShipVia": 2,
"Freight": 13.9700,
"ShipName": "Wellington Importadora",
"ShipAddress": "Rua do Mercado, 12",
"ShipCity": "Resende",
"ShipRegion": "SP",
"ShipPostalCode": "08737-363",
"ShipCountry": "Brazil"
},
{
"OrderID": 10257,
"CustomerID": "HILAA",
"EmployeeID": 4,
"OrderDate": "1996-07-16T00:00:00.0000000",
"RequiredDate": "1996-08-13T00:00:00.0000000",
"ShippedDate": "1996-07-22T00:00:00.0000000",
"ShipVia": 3,
"Freight": 81.9100,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10258,
"CustomerID": "ERNSH",
"EmployeeID": 1,
"OrderDate": "1996-07-17T00:00:00.0000000",
"RequiredDate": "1996-08-14T00:00:00.0000000",
"ShippedDate": "1996-07-23T00:00:00.0000000",
"ShipVia": 1,
"Freight": 140.5100,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10259,
"CustomerID": "CENTC",
"EmployeeID": 4,
"OrderDate": "1996-07-18T00:00:00.0000000",
"RequiredDate": "1996-08-15T00:00:00.0000000",
"ShippedDate": "1996-07-25T00:00:00.0000000",
"ShipVia": 3,
"Freight": 3.2500,
"ShipName": "Centro comercial Moctezuma",
"ShipAddress": "Sierras de Granada 9993",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05022",
"ShipCountry": "Mexico"
},
{
"OrderID": 10260,
"CustomerID": "OTTIK",
"EmployeeID": 4,
"OrderDate": "1996-07-19T00:00:00.0000000",
"RequiredDate": "1996-08-16T00:00:00.0000000",
"ShippedDate": "1996-07-29T00:00:00.0000000",
"ShipVia": 1,
"Freight": 55.0900,
"ShipName": "Ottilies K\u00E4seladen",
"ShipAddress": "Mehrheimerstr. 369",
"ShipCity": "K\u00F6ln",
"ShipRegion": null,
"ShipPostalCode": "50739",
"ShipCountry": "Germany"
},
{
"OrderID": 10261,
"CustomerID": "QUEDE",
"EmployeeID": 4,
"OrderDate": "1996-07-19T00:00:00.0000000",
"RequiredDate": "1996-08-16T00:00:00.0000000",
"ShippedDate": "1996-07-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 3.0500,
"ShipName": "Que Del\u00EDcia",
"ShipAddress": "Rua da Panificadora, 12",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-673",
"ShipCountry": "Brazil"
},
{
"OrderID": 10262,
"CustomerID": "RATTC",
"EmployeeID": 8,
"OrderDate": "1996-07-22T00:00:00.0000000",
"RequiredDate": "1996-08-19T00:00:00.0000000",
"ShippedDate": "1996-07-25T00:00:00.0000000",
"ShipVia": 3,
"Freight": 48.2900,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10263,
"CustomerID": "ERNSH",
"EmployeeID": 9,
"OrderDate": "1996-07-23T00:00:00.0000000",
"RequiredDate": "1996-08-20T00:00:00.0000000",
"ShippedDate": "1996-07-31T00:00:00.0000000",
"ShipVia": 3,
"Freight": 146.0600,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10264,
"CustomerID": "FOLKO",
"EmployeeID": 6,
"OrderDate": "1996-07-24T00:00:00.0000000",
"RequiredDate": "1996-08-21T00:00:00.0000000",
"ShippedDate": "1996-08-23T00:00:00.0000000",
"ShipVia": 3,
"Freight": 3.6700,
"ShipName": "Folk och f\u00E4 HB",
"ShipAddress": "\u00C5kergatan 24",
"ShipCity": "Br\u00E4cke",
"ShipRegion": null,
"ShipPostalCode": "S-844 67",
"ShipCountry": "Sweden"
},
{
"OrderID": 10265,
"CustomerID": "BLONP",
"EmployeeID": 2,
"OrderDate": "1996-07-25T00:00:00.0000000",
"RequiredDate": "1996-08-22T00:00:00.0000000",
"ShippedDate": "1996-08-12T00:00:00.0000000",
"ShipVia": 1,
"Freight": 55.2800,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10266,
"CustomerID": "WARTH",
"EmployeeID": 3,
"OrderDate": "1996-07-26T00:00:00.0000000",
"RequiredDate": "1996-09-06T00:00:00.0000000",
"ShippedDate": "1996-07-31T00:00:00.0000000",
"ShipVia": 3,
"Freight": 25.7300,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10267,
"CustomerID": "FRANK",
"EmployeeID": 4,
"OrderDate": "1996-07-29T00:00:00.0000000",
"RequiredDate": "1996-08-26T00:00:00.0000000",
"ShippedDate": "1996-08-06T00:00:00.0000000",
"ShipVia": 1,
"Freight": 208.5800,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10268,
"CustomerID": "GROSR",
"EmployeeID": 8,
"OrderDate": "1996-07-30T00:00:00.0000000",
"RequiredDate": "1996-08-27T00:00:00.0000000",
"ShippedDate": "1996-08-02T00:00:00.0000000",
"ShipVia": 3,
"Freight": 66.2900,
"ShipName": "GROSELLA-Restaurante",
"ShipAddress": "5\u00AA Ave. Los Palos Grandes",
"ShipCity": "Caracas",
"ShipRegion": "DF",
"ShipPostalCode": "1081",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10269,
"CustomerID": "WHITC",
"EmployeeID": 5,
"OrderDate": "1996-07-31T00:00:00.0000000",
"RequiredDate": "1996-08-14T00:00:00.0000000",
"ShippedDate": "1996-08-09T00:00:00.0000000",
"ShipVia": 1,
"Freight": 4.5600,
"ShipName": "White Clover Markets",
"ShipAddress": "1029 - 12th Ave. S.",
"ShipCity": "Seattle",
"ShipRegion": "WA",
"ShipPostalCode": "98124",
"ShipCountry": "USA"
},
{
"OrderID": 10270,
"CustomerID": "WARTH",
"EmployeeID": 1,
"OrderDate": "1996-08-01T00:00:00.0000000",
"RequiredDate": "1996-08-29T00:00:00.0000000",
"ShippedDate": "1996-08-02T00:00:00.0000000",
"ShipVia": 1,
"Freight": 136.5400,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10271,
"CustomerID": "SPLIR",
"EmployeeID": 6,
"OrderDate": "1996-08-01T00:00:00.0000000",
"RequiredDate": "1996-08-29T00:00:00.0000000",
"ShippedDate": "1996-08-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.5400,
"ShipName": "Split Rail Beer \u0026 Ale",
"ShipAddress": "P.O. Box 555",
"ShipCity": "Lander",
"ShipRegion": "WY",
"ShipPostalCode": "82520",
"ShipCountry": "USA"
},
{
"OrderID": 10272,
"CustomerID": "RATTC",
"EmployeeID": 6,
"OrderDate": "1996-08-02T00:00:00.0000000",
"RequiredDate": "1996-08-30T00:00:00.0000000",
"ShippedDate": "1996-08-06T00:00:00.0000000",
"ShipVia": 2,
"Freight": 98.0300,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10273,
"CustomerID": "QUICK",
"EmployeeID": 3,
"OrderDate": "1996-08-05T00:00:00.0000000",
"RequiredDate": "1996-09-02T00:00:00.0000000",
"ShippedDate": "1996-08-12T00:00:00.0000000",
"ShipVia": 3,
"Freight": 76.0700,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10274,
"CustomerID": "VINET",
"EmployeeID": 6,
"OrderDate": "1996-08-06T00:00:00.0000000",
"RequiredDate": "1996-09-03T00:00:00.0000000",
"ShippedDate": "1996-08-16T00:00:00.0000000",
"ShipVia": 1,
"Freight": 6.0100,
"ShipName": "Vins et alcools Chevalier",
"ShipAddress": "59 rue de l\u0027Abbaye",
"ShipCity": "Reims",
"ShipRegion": null,
"ShipPostalCode": "51100",
"ShipCountry": "France"
},
{
"OrderID": 10275,
"CustomerID": "MAGAA",
"EmployeeID": 1,
"OrderDate": "1996-08-07T00:00:00.0000000",
"RequiredDate": "1996-09-04T00:00:00.0000000",
"ShippedDate": "1996-08-09T00:00:00.0000000",
"ShipVia": 1,
"Freight": 26.9300,
"ShipName": "Magazzini Alimentari Riuniti",
"ShipAddress": "Via Ludovico il Moro 22",
"ShipCity": "Bergamo",
"ShipRegion": null,
"ShipPostalCode": "24100",
"ShipCountry": "Italy"
},
{
"OrderID": 10276,
"CustomerID": "TORTU",
"EmployeeID": 8,
"OrderDate": "1996-08-08T00:00:00.0000000",
"RequiredDate": "1996-08-22T00:00:00.0000000",
"ShippedDate": "1996-08-14T00:00:00.0000000",
"ShipVia": 3,
"Freight": 13.8400,
"ShipName": "Tortuga Restaurante",
"ShipAddress": "Avda. Azteca 123",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10277,
"CustomerID": "MORGK",
"EmployeeID": 2,
"OrderDate": "1996-08-09T00:00:00.0000000",
"RequiredDate": "1996-09-06T00:00:00.0000000",
"ShippedDate": "1996-08-13T00:00:00.0000000",
"ShipVia": 3,
"Freight": 125.7700,
"ShipName": "Morgenstern Gesundkost",
"ShipAddress": "Heerstr. 22",
"ShipCity": "Leipzig",
"ShipRegion": null,
"ShipPostalCode": "04179",
"ShipCountry": "Germany"
},
{
"OrderID": 10278,
"CustomerID": "BERGS",
"EmployeeID": 8,
"OrderDate": "1996-08-12T00:00:00.0000000",
"RequiredDate": "1996-09-09T00:00:00.0000000",
"ShippedDate": "1996-08-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 92.6900,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10279,
"CustomerID": "LEHMS",
"EmployeeID": 8,
"OrderDate": "1996-08-13T00:00:00.0000000",
"RequiredDate": "1996-09-10T00:00:00.0000000",
"ShippedDate": "1996-08-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 25.8300,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10280,
"CustomerID": "BERGS",
"EmployeeID": 2,
"OrderDate": "1996-08-14T00:00:00.0000000",
"RequiredDate": "1996-09-11T00:00:00.0000000",
"ShippedDate": "1996-09-12T00:00:00.0000000",
"ShipVia": 1,
"Freight": 8.9800,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10281,
"CustomerID": "ROMEY",
"EmployeeID": 4,
"OrderDate": "1996-08-14T00:00:00.0000000",
"RequiredDate": "1996-08-28T00:00:00.0000000",
"ShippedDate": "1996-08-21T00:00:00.0000000",
"ShipVia": 1,
"Freight": 2.9400,
"ShipName": "Romero y tomillo",
"ShipAddress": "Gran V\u00EDa, 1",
"ShipCity": "Madrid",
"ShipRegion": null,
"ShipPostalCode": "28001",
"ShipCountry": "Spain"
},
{
"OrderID": 10282,
"CustomerID": "ROMEY",
"EmployeeID": 4,
"OrderDate": "1996-08-15T00:00:00.0000000",
"RequiredDate": "1996-09-12T00:00:00.0000000",
"ShippedDate": "1996-08-21T00:00:00.0000000",
"ShipVia": 1,
"Freight": 12.6900,
"ShipName": "Romero y tomillo",
"ShipAddress": "Gran V\u00EDa, 1",
"ShipCity": "Madrid",
"ShipRegion": null,
"ShipPostalCode": "28001",
"ShipCountry": "Spain"
},
{
"OrderID": 10283,
"CustomerID": "LILAS",
"EmployeeID": 3,
"OrderDate": "1996-08-16T00:00:00.0000000",
"RequiredDate": "1996-09-13T00:00:00.0000000",
"ShippedDate": "1996-08-23T00:00:00.0000000",
"ShipVia": 3,
"Freight": 84.8100,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10284,
"CustomerID": "LEHMS",
"EmployeeID": 4,
"OrderDate": "1996-08-19T00:00:00.0000000",
"RequiredDate": "1996-09-16T00:00:00.0000000",
"ShippedDate": "1996-08-27T00:00:00.0000000",
"ShipVia": 1,
"Freight": 76.5600,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10285,
"CustomerID": "QUICK",
"EmployeeID": 1,
"OrderDate": "1996-08-20T00:00:00.0000000",
"RequiredDate": "1996-09-17T00:00:00.0000000",
"ShippedDate": "1996-08-26T00:00:00.0000000",
"ShipVia": 2,
"Freight": 76.8300,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10286,
"CustomerID": "QUICK",
"EmployeeID": 8,
"OrderDate": "1996-08-21T00:00:00.0000000",
"RequiredDate": "1996-09-18T00:00:00.0000000",
"ShippedDate": "1996-08-30T00:00:00.0000000",
"ShipVia": 3,
"Freight": 229.2400,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10287,
"CustomerID": "RICAR",
"EmployeeID": 8,
"OrderDate": "1996-08-22T00:00:00.0000000",
"RequiredDate": "1996-09-19T00:00:00.0000000",
"ShippedDate": "1996-08-28T00:00:00.0000000",
"ShipVia": 3,
"Freight": 12.7600,
"ShipName": "Ricardo Adocicados",
"ShipAddress": "Av. Copacabana, 267",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-890",
"ShipCountry": "Brazil"
},
{
"OrderID": 10288,
"CustomerID": "REGGC",
"EmployeeID": 4,
"OrderDate": "1996-08-23T00:00:00.0000000",
"RequiredDate": "1996-09-20T00:00:00.0000000",
"ShippedDate": "1996-09-03T00:00:00.0000000",
"ShipVia": 1,
"Freight": 7.4500,
"ShipName": "Reggiani Caseifici",
"ShipAddress": "Strada Provinciale 124",
"ShipCity": "Reggio Emilia",
"ShipRegion": null,
"ShipPostalCode": "42100",
"ShipCountry": "Italy"
},
{
"OrderID": 10289,
"CustomerID": "BSBEV",
"EmployeeID": 7,
"OrderDate": "1996-08-26T00:00:00.0000000",
"RequiredDate": "1996-09-23T00:00:00.0000000",
"ShippedDate": "1996-08-28T00:00:00.0000000",
"ShipVia": 3,
"Freight": 22.7700,
"ShipName": "B\u0027s Beverages",
"ShipAddress": "Fauntleroy Circus",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "EC2 5NT",
"ShipCountry": "UK"
},
{
"OrderID": 10290,
"CustomerID": "COMMI",
"EmployeeID": 8,
"OrderDate": "1996-08-27T00:00:00.0000000",
"RequiredDate": "1996-09-24T00:00:00.0000000",
"ShippedDate": "1996-09-03T00:00:00.0000000",
"ShipVia": 1,
"Freight": 79.7000,
"ShipName": "Com\u00E9rcio Mineiro",
"ShipAddress": "Av. dos Lus\u00EDadas, 23",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05432-043",
"ShipCountry": "Brazil"
},
{
"OrderID": 10291,
"CustomerID": "QUEDE",
"EmployeeID": 6,
"OrderDate": "1996-08-27T00:00:00.0000000",
"RequiredDate": "1996-09-24T00:00:00.0000000",
"ShippedDate": "1996-09-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 6.4000,
"ShipName": "Que Del\u00EDcia",
"ShipAddress": "Rua da Panificadora, 12",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-673",
"ShipCountry": "Brazil"
},
{
"OrderID": 10292,
"CustomerID": "TRADH",
"EmployeeID": 1,
"OrderDate": "1996-08-28T00:00:00.0000000",
"RequiredDate": "1996-09-25T00:00:00.0000000",
"ShippedDate": "1996-09-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 1.3500,
"ShipName": "Tradi\u00E7ao Hipermercados",
"ShipAddress": "Av. In\u00EAs de Castro, 414",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05634-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10293,
"CustomerID": "TORTU",
"EmployeeID": 1,
"OrderDate": "1996-08-29T00:00:00.0000000",
"RequiredDate": "1996-09-26T00:00:00.0000000",
"ShippedDate": "1996-09-11T00:00:00.0000000",
"ShipVia": 3,
"Freight": 21.1800,
"ShipName": "Tortuga Restaurante",
"ShipAddress": "Avda. Azteca 123",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10294,
"CustomerID": "RATTC",
"EmployeeID": 4,
"OrderDate": "1996-08-30T00:00:00.0000000",
"RequiredDate": "1996-09-27T00:00:00.0000000",
"ShippedDate": "1996-09-05T00:00:00.0000000",
"ShipVia": 2,
"Freight": 147.2600,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10295,
"CustomerID": "VINET",
"EmployeeID": 2,
"OrderDate": "1996-09-02T00:00:00.0000000",
"RequiredDate": "1996-09-30T00:00:00.0000000",
"ShippedDate": "1996-09-10T00:00:00.0000000",
"ShipVia": 2,
"Freight": 1.1500,
"ShipName": "Vins et alcools Chevalier",
"ShipAddress": "59 rue de l\u0027Abbaye",
"ShipCity": "Reims",
"ShipRegion": null,
"ShipPostalCode": "51100",
"ShipCountry": "France"
},
{
"OrderID": 10296,
"CustomerID": "LILAS",
"EmployeeID": 6,
"OrderDate": "1996-09-03T00:00:00.0000000",
"RequiredDate": "1996-10-01T00:00:00.0000000",
"ShippedDate": "1996-09-11T00:00:00.0000000",
"ShipVia": 1,
"Freight": 0.1200,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10297,
"CustomerID": "BLONP",
"EmployeeID": 5,
"OrderDate": "1996-09-04T00:00:00.0000000",
"RequiredDate": "1996-10-16T00:00:00.0000000",
"ShippedDate": "1996-09-10T00:00:00.0000000",
"ShipVia": 2,
"Freight": 5.7400,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10298,
"CustomerID": "HUNGO",
"EmployeeID": 6,
"OrderDate": "1996-09-05T00:00:00.0000000",
"RequiredDate": "1996-10-03T00:00:00.0000000",
"ShippedDate": "1996-09-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 168.2200,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10299,
"CustomerID": "RICAR",
"EmployeeID": 4,
"OrderDate": "1996-09-06T00:00:00.0000000",
"RequiredDate": "1996-10-04T00:00:00.0000000",
"ShippedDate": "1996-09-13T00:00:00.0000000",
"ShipVia": 2,
"Freight": 29.7600,
"ShipName": "Ricardo Adocicados",
"ShipAddress": "Av. Copacabana, 267",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-890",
"ShipCountry": "Brazil"
},
{
"OrderID": 10300,
"CustomerID": "MAGAA",
"EmployeeID": 2,
"OrderDate": "1996-09-09T00:00:00.0000000",
"RequiredDate": "1996-10-07T00:00:00.0000000",
"ShippedDate": "1996-09-18T00:00:00.0000000",
"ShipVia": 2,
"Freight": 17.6800,
"ShipName": "Magazzini Alimentari Riuniti",
"ShipAddress": "Via Ludovico il Moro 22",
"ShipCity": "Bergamo",
"ShipRegion": null,
"ShipPostalCode": "24100",
"ShipCountry": "Italy"
},
{
"OrderID": 10301,
"CustomerID": "WANDK",
"EmployeeID": 8,
"OrderDate": "1996-09-09T00:00:00.0000000",
"RequiredDate": "1996-10-07T00:00:00.0000000",
"ShippedDate": "1996-09-17T00:00:00.0000000",
"ShipVia": 2,
"Freight": 45.0800,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10302,
"CustomerID": "SUPRD",
"EmployeeID": 4,
"OrderDate": "1996-09-10T00:00:00.0000000",
"RequiredDate": "1996-10-08T00:00:00.0000000",
"ShippedDate": "1996-10-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 6.2700,
"ShipName": "Supr\u00EAmes d\u00E9lices",
"ShipAddress": "Boulevard Tirou, 255",
"ShipCity": "Charleroi",
"ShipRegion": null,
"ShipPostalCode": "B-6000",
"ShipCountry": "Belgium"
},
{
"OrderID": 10303,
"CustomerID": "GODOS",
"EmployeeID": 7,
"OrderDate": "1996-09-11T00:00:00.0000000",
"RequiredDate": "1996-10-09T00:00:00.0000000",
"ShippedDate": "1996-09-18T00:00:00.0000000",
"ShipVia": 2,
"Freight": 107.8300,
"ShipName": "Godos Cocina T\u00EDpica",
"ShipAddress": "C/ Romero, 33",
"ShipCity": "Sevilla",
"ShipRegion": null,
"ShipPostalCode": "41101",
"ShipCountry": "Spain"
},
{
"OrderID": 10304,
"CustomerID": "TORTU",
"EmployeeID": 1,
"OrderDate": "1996-09-12T00:00:00.0000000",
"RequiredDate": "1996-10-10T00:00:00.0000000",
"ShippedDate": "1996-09-17T00:00:00.0000000",
"ShipVia": 2,
"Freight": 63.7900,
"ShipName": "Tortuga Restaurante",
"ShipAddress": "Avda. Azteca 123",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10305,
"CustomerID": "OLDWO",
"EmployeeID": 8,
"OrderDate": "1996-09-13T00:00:00.0000000",
"RequiredDate": "1996-10-11T00:00:00.0000000",
"ShippedDate": "1996-10-09T00:00:00.0000000",
"ShipVia": 3,
"Freight": 257.6200,
"ShipName": "Old World Delicatessen",
"ShipAddress": "2743 Bering St.",
"ShipCity": "Anchorage",
"ShipRegion": "AK",
"ShipPostalCode": "99508",
"ShipCountry": "USA"
},
{
"OrderID": 10306,
"CustomerID": "ROMEY",
"EmployeeID": 1,
"OrderDate": "1996-09-16T00:00:00.0000000",
"RequiredDate": "1996-10-14T00:00:00.0000000",
"ShippedDate": "1996-09-23T00:00:00.0000000",
"ShipVia": 3,
"Freight": 7.5600,
"ShipName": "Romero y tomillo",
"ShipAddress": "Gran V\u00EDa, 1",
"ShipCity": "Madrid",
"ShipRegion": null,
"ShipPostalCode": "28001",
"ShipCountry": "Spain"
},
{
"OrderID": 10307,
"CustomerID": "LONEP",
"EmployeeID": 2,
"OrderDate": "1996-09-17T00:00:00.0000000",
"RequiredDate": "1996-10-15T00:00:00.0000000",
"ShippedDate": "1996-09-25T00:00:00.0000000",
"ShipVia": 2,
"Freight": 0.5600,
"ShipName": "Lonesome Pine Restaurant",
"ShipAddress": "89 Chiaroscuro Rd.",
"ShipCity": "Portland",
"ShipRegion": "OR",
"ShipPostalCode": "97219",
"ShipCountry": "USA"
},
{
"OrderID": 10308,
"CustomerID": "ANATR",
"EmployeeID": 7,
"OrderDate": "1996-09-18T00:00:00.0000000",
"RequiredDate": "1996-10-16T00:00:00.0000000",
"ShippedDate": "1996-09-24T00:00:00.0000000",
"ShipVia": 3,
"Freight": 1.6100,
"ShipName": "Ana Trujillo Emparedados y helados",
"ShipAddress": "Avda. de la Constituci\u00F3n 2222",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05021",
"ShipCountry": "Mexico"
},
{
"OrderID": 10309,
"CustomerID": "HUNGO",
"EmployeeID": 3,
"OrderDate": "1996-09-19T00:00:00.0000000",
"RequiredDate": "1996-10-17T00:00:00.0000000",
"ShippedDate": "1996-10-23T00:00:00.0000000",
"ShipVia": 1,
"Freight": 47.3000,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10310,
"CustomerID": "THEBI",
"EmployeeID": 8,
"OrderDate": "1996-09-20T00:00:00.0000000",
"RequiredDate": "1996-10-18T00:00:00.0000000",
"ShippedDate": "1996-09-27T00:00:00.0000000",
"ShipVia": 2,
"Freight": 17.5200,
"ShipName": "The Big Cheese",
"ShipAddress": "89 Jefferson Way Suite 2",
"ShipCity": "Portland",
"ShipRegion": "OR",
"ShipPostalCode": "97201",
"ShipCountry": "USA"
},
{
"OrderID": 10311,
"CustomerID": "DUMON",
"EmployeeID": 1,
"OrderDate": "1996-09-20T00:00:00.0000000",
"RequiredDate": "1996-10-04T00:00:00.0000000",
"ShippedDate": "1996-09-26T00:00:00.0000000",
"ShipVia": 3,
"Freight": 24.6900,
"ShipName": "Du monde entier",
"ShipAddress": "67, rue des Cinquante Otages",
"ShipCity": "Nantes",
"ShipRegion": null,
"ShipPostalCode": "44000",
"ShipCountry": "France"
},
{
"OrderID": 10312,
"CustomerID": "WANDK",
"EmployeeID": 2,
"OrderDate": "1996-09-23T00:00:00.0000000",
"RequiredDate": "1996-10-21T00:00:00.0000000",
"ShippedDate": "1996-10-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 40.2600,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10313,
"CustomerID": "QUICK",
"EmployeeID": 2,
"OrderDate": "1996-09-24T00:00:00.0000000",
"RequiredDate": "1996-10-22T00:00:00.0000000",
"ShippedDate": "1996-10-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 1.9600,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10314,
"CustomerID": "RATTC",
"EmployeeID": 1,
"OrderDate": "1996-09-25T00:00:00.0000000",
"RequiredDate": "1996-10-23T00:00:00.0000000",
"ShippedDate": "1996-10-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 74.1600,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10315,
"CustomerID": "ISLAT",
"EmployeeID": 4,
"OrderDate": "1996-09-26T00:00:00.0000000",
"RequiredDate": "1996-10-24T00:00:00.0000000",
"ShippedDate": "1996-10-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 41.7600,
"ShipName": "Island Trading",
"ShipAddress": "Garden House Crowther Way",
"ShipCity": "Cowes",
"ShipRegion": "Isle of Wight",
"ShipPostalCode": "PO31 7PJ",
"ShipCountry": "UK"
},
{
"OrderID": 10316,
"CustomerID": "RATTC",
"EmployeeID": 1,
"OrderDate": "1996-09-27T00:00:00.0000000",
"RequiredDate": "1996-10-25T00:00:00.0000000",
"ShippedDate": "1996-10-08T00:00:00.0000000",
"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": "1996-09-30T00:00:00.0000000",
"RequiredDate": "1996-10-28T00:00:00.0000000",
"ShippedDate": "1996-10-10T00:00:00.0000000",
"ShipVia": 1,
"Freight": 12.6900,
"ShipName": "Lonesome Pine Restaurant",
"ShipAddress": "89 Chiaroscuro Rd.",
"ShipCity": "Portland",
"ShipRegion": "OR",
"ShipPostalCode": "97219",
"ShipCountry": "USA"
},
{
"OrderID": 10318,
"CustomerID": "ISLAT",
"EmployeeID": 8,
"OrderDate": "1996-10-01T00:00:00.0000000",
"RequiredDate": "1996-10-29T00:00:00.0000000",
"ShippedDate": "1996-10-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.7300,
"ShipName": "Island Trading",
"ShipAddress": "Garden House Crowther Way",
"ShipCity": "Cowes",
"ShipRegion": "Isle of Wight",
"ShipPostalCode": "PO31 7PJ",
"ShipCountry": "UK"
},
{
"OrderID": 10319,
"CustomerID": "TORTU",
"EmployeeID": 7,
"OrderDate": "1996-10-02T00:00:00.0000000",
"RequiredDate": "1996-10-30T00:00:00.0000000",
"ShippedDate": "1996-10-11T00:00:00.0000000",
"ShipVia": 3,
"Freight": 64.5000,
"ShipName": "Tortuga Restaurante",
"ShipAddress": "Avda. Azteca 123",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10320,
"CustomerID": "WARTH",
"EmployeeID": 5,
"OrderDate": "1996-10-03T00:00:00.0000000",
"RequiredDate": "1996-10-17T00:00:00.0000000",
"ShippedDate": "1996-10-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 34.5700,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10321,
"CustomerID": "ISLAT",
"EmployeeID": 3,
"OrderDate": "1996-10-03T00:00:00.0000000",
"RequiredDate": "1996-10-31T00:00:00.0000000",
"ShippedDate": "1996-10-11T00:00:00.0000000",
"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": "1996-10-04T00:00:00.0000000",
"RequiredDate": "1996-11-01T00:00:00.0000000",
"ShippedDate": "1996-10-23T00:00:00.0000000",
"ShipVia": 3,
"Freight": 0.4000,
"ShipName": "Pericles Comidas cl\u00E1sicas",
"ShipAddress": "Calle Dr. Jorge Cash 321",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10323,
"CustomerID": "KOENE",
"EmployeeID": 4,
"OrderDate": "1996-10-07T00:00:00.0000000",
"RequiredDate": "1996-11-04T00:00:00.0000000",
"ShippedDate": "1996-10-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 4.8800,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10324,
"CustomerID": "SAVEA",
"EmployeeID": 9,
"OrderDate": "1996-10-08T00:00:00.0000000",
"RequiredDate": "1996-11-05T00:00:00.0000000",
"ShippedDate": "1996-10-10T00:00:00.0000000",
"ShipVia": 1,
"Freight": 214.2700,
"ShipName": "Save-a-lot Markets",
"ShipAddress": "187 Suffolk Ln.",
"ShipCity": "Boise",
"ShipRegion": "ID",
"ShipPostalCode": "83720",
"ShipCountry": "USA"
},
{
"OrderID": 10325,
"CustomerID": "KOENE",
"EmployeeID": 1,
"OrderDate": "1996-10-09T00:00:00.0000000",
"RequiredDate": "1996-10-23T00:00:00.0000000",
"ShippedDate": "1996-10-14T00:00:00.0000000",
"ShipVia": 3,
"Freight": 64.8600,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10326,
"CustomerID": "BOLID",
"EmployeeID": 4,
"OrderDate": "1996-10-10T00:00:00.0000000",
"RequiredDate": "1996-11-07T00:00:00.0000000",
"ShippedDate": "1996-10-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 77.9200,
"ShipName": "B\u00F3lido Comidas preparadas",
"ShipAddress": "C/ Araquil, 67",
"ShipCity": "Madrid",
"ShipRegion": null,
"ShipPostalCode": "28023",
"ShipCountry": "Spain"
},
{
"OrderID": 10327,
"CustomerID": "FOLKO",
"EmployeeID": 2,
"OrderDate": "1996-10-11T00:00:00.0000000",
"RequiredDate": "1996-11-08T00:00:00.0000000",
"ShippedDate": "1996-10-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 63.3600,
"ShipName": "Folk och f\u00E4 HB",
"ShipAddress": "\u00C5kergatan 24",
"ShipCity": "Br\u00E4cke",
"ShipRegion": null,
"ShipPostalCode": "S-844 67",
"ShipCountry": "Sweden"
},
{
"OrderID": 10328,
"CustomerID": "FURIB",
"EmployeeID": 4,
"OrderDate": "1996-10-14T00:00:00.0000000",
"RequiredDate": "1996-11-11T00:00:00.0000000",
"ShippedDate": "1996-10-17T00:00:00.0000000",
"ShipVia": 3,
"Freight": 87.0300,
"ShipName": "Furia Bacalhau e Frutos do Mar",
"ShipAddress": "Jardim das rosas n. 32",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1675",
"ShipCountry": "Portugal"
},
{
"OrderID": 10329,
"CustomerID": "SPLIR",
"EmployeeID": 4,
"OrderDate": "1996-10-15T00:00:00.0000000",
"RequiredDate": "1996-11-26T00:00:00.0000000",
"ShippedDate": "1996-10-23T00:00:00.0000000",
"ShipVia": 2,
"Freight": 191.6700,
"ShipName": "Split Rail Beer \u0026 Ale",
"ShipAddress": "P.O. Box 555",
"ShipCity": "Lander",
"ShipRegion": "WY",
"ShipPostalCode": "82520",
"ShipCountry": "USA"
},
{
"OrderID": 10330,
"CustomerID": "LILAS",
"EmployeeID": 3,
"OrderDate": "1996-10-16T00:00:00.0000000",
"RequiredDate": "1996-11-13T00:00:00.0000000",
"ShippedDate": "1996-10-28T00:00:00.0000000",
"ShipVia": 1,
"Freight": 12.7500,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10331,
"CustomerID": "BONAP",
"EmployeeID": 9,
"OrderDate": "1996-10-16T00:00:00.0000000",
"RequiredDate": "1996-11-27T00:00:00.0000000",
"ShippedDate": "1996-10-21T00:00:00.0000000",
"ShipVia": 1,
"Freight": 10.1900,
"ShipName": "Bon app\u0027",
"ShipAddress": "12, rue des Bouchers",
"ShipCity": "Marseille",
"ShipRegion": null,
"ShipPostalCode": "13008",
"ShipCountry": "France"
},
{
"OrderID": 10332,
"CustomerID": "MEREP",
"EmployeeID": 3,
"OrderDate": "1996-10-17T00:00:00.0000000",
"RequiredDate": "1996-11-28T00:00:00.0000000",
"ShippedDate": "1996-10-21T00:00:00.0000000",
"ShipVia": 2,
"Freight": 52.8400,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10333,
"CustomerID": "WARTH",
"EmployeeID": 5,
"OrderDate": "1996-10-18T00:00:00.0000000",
"RequiredDate": "1996-11-15T00:00:00.0000000",
"ShippedDate": "1996-10-25T00:00:00.0000000",
"ShipVia": 3,
"Freight": 0.5900,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10334,
"CustomerID": "VICTE",
"EmployeeID": 8,
"OrderDate": "1996-10-21T00:00:00.0000000",
"RequiredDate": "1996-11-18T00:00:00.0000000",
"ShippedDate": "1996-10-28T00:00:00.0000000",
"ShipVia": 2,
"Freight": 8.5600,
"ShipName": "Victuailles en stock",
"ShipAddress": "2, rue du Commerce",
"ShipCity": "Lyon",
"ShipRegion": null,
"ShipPostalCode": "69004",
"ShipCountry": "France"
},
{
"OrderID": 10335,
"CustomerID": "HUNGO",
"EmployeeID": 7,
"OrderDate": "1996-10-22T00:00:00.0000000",
"RequiredDate": "1996-11-19T00:00:00.0000000",
"ShippedDate": "1996-10-24T00:00:00.0000000",
"ShipVia": 2,
"Freight": 42.1100,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10336,
"CustomerID": "PRINI",
"EmployeeID": 7,
"OrderDate": "1996-10-23T00:00:00.0000000",
"RequiredDate": "1996-11-20T00:00:00.0000000",
"ShippedDate": "1996-10-25T00:00:00.0000000",
"ShipVia": 2,
"Freight": 15.5100,
"ShipName": "Princesa Isabel Vinhos",
"ShipAddress": "Estrada da sa\u00FAde n. 58",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1756",
"ShipCountry": "Portugal"
},
{
"OrderID": 10337,
"CustomerID": "FRANK",
"EmployeeID": 4,
"OrderDate": "1996-10-24T00:00:00.0000000",
"RequiredDate": "1996-11-21T00:00:00.0000000",
"ShippedDate": "1996-10-29T00:00:00.0000000",
"ShipVia": 3,
"Freight": 108.2600,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10338,
"CustomerID": "OLDWO",
"EmployeeID": 4,
"OrderDate": "1996-10-25T00:00:00.0000000",
"RequiredDate": "1996-11-22T00:00:00.0000000",
"ShippedDate": "1996-10-29T00:00:00.0000000",
"ShipVia": 3,
"Freight": 84.2100,
"ShipName": "Old World Delicatessen",
"ShipAddress": "2743 Bering St.",
"ShipCity": "Anchorage",
"ShipRegion": "AK",
"ShipPostalCode": "99508",
"ShipCountry": "USA"
},
{
"OrderID": 10339,
"CustomerID": "MEREP",
"EmployeeID": 2,
"OrderDate": "1996-10-28T00:00:00.0000000",
"RequiredDate": "1996-11-25T00:00:00.0000000",
"ShippedDate": "1996-11-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 15.6600,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10340,
"CustomerID": "BONAP",
"EmployeeID": 1,
"OrderDate": "1996-10-29T00:00:00.0000000",
"RequiredDate": "1996-11-26T00:00:00.0000000",
"ShippedDate": "1996-11-08T00:00:00.0000000",
"ShipVia": 3,
"Freight": 166.3100,
"ShipName": "Bon app\u0027",
"ShipAddress": "12, rue des Bouchers",
"ShipCity": "Marseille",
"ShipRegion": null,
"ShipPostalCode": "13008",
"ShipCountry": "France"
},
{
"OrderID": 10341,
"CustomerID": "SIMOB",
"EmployeeID": 7,
"OrderDate": "1996-10-29T00:00:00.0000000",
"RequiredDate": "1996-11-26T00:00:00.0000000",
"ShippedDate": "1996-11-05T00:00:00.0000000",
"ShipVia": 3,
"Freight": 26.7800,
"ShipName": "Simons bistro",
"ShipAddress": "Vinb\u00E6ltet 34",
"ShipCity": "Kobenhavn",
"ShipRegion": null,
"ShipPostalCode": "1734",
"ShipCountry": "Denmark"
},
{
"OrderID": 10342,
"CustomerID": "FRANK",
"EmployeeID": 4,
"OrderDate": "1996-10-30T00:00:00.0000000",
"RequiredDate": "1996-11-13T00:00:00.0000000",
"ShippedDate": "1996-11-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 54.8300,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10343,
"CustomerID": "LEHMS",
"EmployeeID": 4,
"OrderDate": "1996-10-31T00:00:00.0000000",
"RequiredDate": "1996-11-28T00:00:00.0000000",
"ShippedDate": "1996-11-06T00:00:00.0000000",
"ShipVia": 1,
"Freight": 110.3700,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10344,
"CustomerID": "WHITC",
"EmployeeID": 4,
"OrderDate": "1996-11-01T00:00:00.0000000",
"RequiredDate": "1996-11-29T00:00:00.0000000",
"ShippedDate": "1996-11-05T00:00:00.0000000",
"ShipVia": 2,
"Freight": 23.2900,
"ShipName": "White Clover Markets",
"ShipAddress": "1029 - 12th Ave. S.",
"ShipCity": "Seattle",
"ShipRegion": "WA",
"ShipPostalCode": "98124",
"ShipCountry": "USA"
},
{
"OrderID": 10345,
"CustomerID": "QUICK",
"EmployeeID": 2,
"OrderDate": "1996-11-04T00:00:00.0000000",
"RequiredDate": "1996-12-02T00:00:00.0000000",
"ShippedDate": "1996-11-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 249.0600,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10346,
"CustomerID": "RATTC",
"EmployeeID": 3,
"OrderDate": "1996-11-05T00:00:00.0000000",
"RequiredDate": "1996-12-17T00:00:00.0000000",
"ShippedDate": "1996-11-08T00:00:00.0000000",
"ShipVia": 3,
"Freight": 142.0800,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10347,
"CustomerID": "FAMIA",
"EmployeeID": 4,
"OrderDate": "1996-11-06T00:00:00.0000000",
"RequiredDate": "1996-12-04T00:00:00.0000000",
"ShippedDate": "1996-11-08T00:00:00.0000000",
"ShipVia": 3,
"Freight": 3.1000,
"ShipName": "Familia Arquibaldo",
"ShipAddress": "Rua Or\u00F3s, 92",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05442-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10348,
"CustomerID": "WANDK",
"EmployeeID": 4,
"OrderDate": "1996-11-07T00:00:00.0000000",
"RequiredDate": "1996-12-05T00:00:00.0000000",
"ShippedDate": "1996-11-15T00:00:00.0000000",
"ShipVia": 2,
"Freight": 0.7800,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10349,
"CustomerID": "SPLIR",
"EmployeeID": 7,
"OrderDate": "1996-11-08T00:00:00.0000000",
"RequiredDate": "1996-12-06T00:00:00.0000000",
"ShippedDate": "1996-11-15T00:00:00.0000000",
"ShipVia": 1,
"Freight": 8.6300,
"ShipName": "Split Rail Beer \u0026 Ale",
"ShipAddress": "P.O. Box 555",
"ShipCity": "Lander",
"ShipRegion": "WY",
"ShipPostalCode": "82520",
"ShipCountry": "USA"
},
{
"OrderID": 10350,
"CustomerID": "LAMAI",
"EmployeeID": 6,
"OrderDate": "1996-11-11T00:00:00.0000000",
"RequiredDate": "1996-12-09T00:00:00.0000000",
"ShippedDate": "1996-12-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 64.1900,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10351,
"CustomerID": "ERNSH",
"EmployeeID": 1,
"OrderDate": "1996-11-11T00:00:00.0000000",
"RequiredDate": "1996-12-09T00:00:00.0000000",
"ShippedDate": "1996-11-20T00:00:00.0000000",
"ShipVia": 1,
"Freight": 162.3300,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10352,
"CustomerID": "FURIB",
"EmployeeID": 3,
"OrderDate": "1996-11-12T00:00:00.0000000",
"RequiredDate": "1996-11-26T00:00:00.0000000",
"ShippedDate": "1996-11-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 1.3000,
"ShipName": "Furia Bacalhau e Frutos do Mar",
"ShipAddress": "Jardim das rosas n. 32",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1675",
"ShipCountry": "Portugal"
},
{
"OrderID": 10353,
"CustomerID": "PICCO",
"EmployeeID": 7,
"OrderDate": "1996-11-13T00:00:00.0000000",
"RequiredDate": "1996-12-11T00:00:00.0000000",
"ShippedDate": "1996-11-25T00:00:00.0000000",
"ShipVia": 3,
"Freight": 360.6300,
"ShipName": "Piccolo und mehr",
"ShipAddress": "Geislweg 14",
"ShipCity": "Salzburg",
"ShipRegion": null,
"ShipPostalCode": "5020",
"ShipCountry": "Austria"
},
{
"OrderID": 10354,
"CustomerID": "PERIC",
"EmployeeID": 8,
"OrderDate": "1996-11-14T00:00:00.0000000",
"RequiredDate": "1996-12-12T00:00:00.0000000",
"ShippedDate": "1996-11-20T00:00:00.0000000",
"ShipVia": 3,
"Freight": 53.8000,
"ShipName": "Pericles Comidas cl\u00E1sicas",
"ShipAddress": "Calle Dr. Jorge Cash 321",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10355,
"CustomerID": "AROUT",
"EmployeeID": 6,
"OrderDate": "1996-11-15T00:00:00.0000000",
"RequiredDate": "1996-12-13T00:00:00.0000000",
"ShippedDate": "1996-11-20T00:00:00.0000000",
"ShipVia": 1,
"Freight": 41.9500,
"ShipName": "Around the Horn",
"ShipAddress": "Brook Farm Stratford St. Mary",
"ShipCity": "Colchester",
"ShipRegion": "Essex",
"ShipPostalCode": "CO7 6JX",
"ShipCountry": "UK"
},
{
"OrderID": 10356,
"CustomerID": "WANDK",
"EmployeeID": 6,
"OrderDate": "1996-11-18T00:00:00.0000000",
"RequiredDate": "1996-12-16T00:00:00.0000000",
"ShippedDate": "1996-11-27T00:00:00.0000000",
"ShipVia": 2,
"Freight": 36.7100,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10357,
"CustomerID": "LILAS",
"EmployeeID": 1,
"OrderDate": "1996-11-19T00:00:00.0000000",
"RequiredDate": "1996-12-17T00:00:00.0000000",
"ShippedDate": "1996-12-02T00:00:00.0000000",
"ShipVia": 3,
"Freight": 34.8800,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10358,
"CustomerID": "LAMAI",
"EmployeeID": 5,
"OrderDate": "1996-11-20T00:00:00.0000000",
"RequiredDate": "1996-12-18T00:00:00.0000000",
"ShippedDate": "1996-11-27T00:00:00.0000000",
"ShipVia": 1,
"Freight": 19.6400,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10359,
"CustomerID": "SEVES",
"EmployeeID": 5,
"OrderDate": "1996-11-21T00:00:00.0000000",
"RequiredDate": "1996-12-19T00:00:00.0000000",
"ShippedDate": "1996-11-26T00:00:00.0000000",
"ShipVia": 3,
"Freight": 288.4300,
"ShipName": "Seven Seas Imports",
"ShipAddress": "90 Wadhurst Rd.",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "OX15 4NB",
"ShipCountry": "UK"
},
{
"OrderID": 10360,
"CustomerID": "BLONP",
"EmployeeID": 4,
"OrderDate": "1996-11-22T00:00:00.0000000",
"RequiredDate": "1996-12-20T00:00:00.0000000",
"ShippedDate": "1996-12-02T00:00:00.0000000",
"ShipVia": 3,
"Freight": 131.7000,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10361,
"CustomerID": "QUICK",
"EmployeeID": 1,
"OrderDate": "1996-11-22T00:00:00.0000000",
"RequiredDate": "1996-12-20T00:00:00.0000000",
"ShippedDate": "1996-12-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 183.1700,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10362,
"CustomerID": "BONAP",
"EmployeeID": 3,
"OrderDate": "1996-11-25T00:00:00.0000000",
"RequiredDate": "1996-12-23T00:00:00.0000000",
"ShippedDate": "1996-11-28T00:00:00.0000000",
"ShipVia": 1,
"Freight": 96.0400,
"ShipName": "Bon app\u0027",
"ShipAddress": "12, rue des Bouchers",
"ShipCity": "Marseille",
"ShipRegion": null,
"ShipPostalCode": "13008",
"ShipCountry": "France"
},
{
"OrderID": 10363,
"CustomerID": "DRACD",
"EmployeeID": 4,
"OrderDate": "1996-11-26T00:00:00.0000000",
"RequiredDate": "1996-12-24T00:00:00.0000000",
"ShippedDate": "1996-12-04T00:00:00.0000000",
"ShipVia": 3,
"Freight": 30.5400,
"ShipName": "Drachenblut Delikatessen",
"ShipAddress": "Walserweg 21",
"ShipCity": "Aachen",
"ShipRegion": null,
"ShipPostalCode": "52066",
"ShipCountry": "Germany"
},
{
"OrderID": 10364,
"CustomerID": "EASTC",
"EmployeeID": 1,
"OrderDate": "1996-11-26T00:00:00.0000000",
"RequiredDate": "1997-01-07T00:00:00.0000000",
"ShippedDate": "1996-12-04T00:00:00.0000000",
"ShipVia": 1,
"Freight": 71.9700,
"ShipName": "Eastern Connection",
"ShipAddress": "35 King George",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "WX3 6FW",
"ShipCountry": "UK"
},
{
"OrderID": 10365,
"CustomerID": "ANTON",
"EmployeeID": 3,
"OrderDate": "1996-11-27T00:00:00.0000000",
"RequiredDate": "1996-12-25T00:00:00.0000000",
"ShippedDate": "1996-12-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 22.0000,
"ShipName": "Antonio Moreno Taquer\u00EDa",
"ShipAddress": "Mataderos 2312",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05023",
"ShipCountry": "Mexico"
},
{
"OrderID": 10366,
"CustomerID": "GALED",
"EmployeeID": 8,
"OrderDate": "1996-11-28T00:00:00.0000000",
"RequiredDate": "1997-01-09T00:00:00.0000000",
"ShippedDate": "1996-12-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 10.1400,
"ShipName": "Galer\u00EDa del gastron\u00F3mo",
"ShipAddress": "Rambla de Catalu\u00F1a, 23",
"ShipCity": "Barcelona",
"ShipRegion": null,
"ShipPostalCode": "8022",
"ShipCountry": "Spain"
},
{
"OrderID": 10367,
"CustomerID": "VAFFE",
"EmployeeID": 7,
"OrderDate": "1996-11-28T00:00:00.0000000",
"RequiredDate": "1996-12-26T00:00:00.0000000",
"ShippedDate": "1996-12-02T00:00:00.0000000",
"ShipVia": 3,
"Freight": 13.5500,
"ShipName": "Vaffeljernet",
"ShipAddress": "Smagsloget 45",
"ShipCity": "\u00C5rhus",
"ShipRegion": null,
"ShipPostalCode": "8200",
"ShipCountry": "Denmark"
},
{
"OrderID": 10368,
"CustomerID": "ERNSH",
"EmployeeID": 2,
"OrderDate": "1996-11-29T00:00:00.0000000",
"RequiredDate": "1996-12-27T00:00:00.0000000",
"ShippedDate": "1996-12-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 101.9500,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10369,
"CustomerID": "SPLIR",
"EmployeeID": 8,
"OrderDate": "1996-12-02T00:00:00.0000000",
"RequiredDate": "1996-12-30T00:00:00.0000000",
"ShippedDate": "1996-12-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 195.6800,
"ShipName": "Split Rail Beer \u0026 Ale",
"ShipAddress": "P.O. Box 555",
"ShipCity": "Lander",
"ShipRegion": "WY",
"ShipPostalCode": "82520",
"ShipCountry": "USA"
},
{
"OrderID": 10370,
"CustomerID": "CHOPS",
"EmployeeID": 6,
"OrderDate": "1996-12-03T00:00:00.0000000",
"RequiredDate": "1996-12-31T00:00:00.0000000",
"ShippedDate": "1996-12-27T00:00:00.0000000",
"ShipVia": 2,
"Freight": 1.1700,
"ShipName": "Chop-suey Chinese",
"ShipAddress": "Hauptstr. 31",
"ShipCity": "Bern",
"ShipRegion": null,
"ShipPostalCode": "3012",
"ShipCountry": "Switzerland"
},
{
"OrderID": 10371,
"CustomerID": "LAMAI",
"EmployeeID": 1,
"OrderDate": "1996-12-03T00:00:00.0000000",
"RequiredDate": "1996-12-31T00:00:00.0000000",
"ShippedDate": "1996-12-24T00:00:00.0000000",
"ShipVia": 1,
"Freight": 0.4500,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10372,
"CustomerID": "QUEEN",
"EmployeeID": 5,
"OrderDate": "1996-12-04T00:00:00.0000000",
"RequiredDate": "1997-01-01T00:00:00.0000000",
"ShippedDate": "1996-12-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 890.7800,
"ShipName": "Queen Cozinha",
"ShipAddress": "Alameda dos Can\u00E0rios, 891",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05487-020",
"ShipCountry": "Brazil"
},
{
"OrderID": 10373,
"CustomerID": "HUNGO",
"EmployeeID": 4,
"OrderDate": "1996-12-05T00:00:00.0000000",
"RequiredDate": "1997-01-02T00:00:00.0000000",
"ShippedDate": "1996-12-11T00:00:00.0000000",
"ShipVia": 3,
"Freight": 124.1200,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10374,
"CustomerID": "WOLZA",
"EmployeeID": 1,
"OrderDate": "1996-12-05T00:00:00.0000000",
"RequiredDate": "1997-01-02T00:00:00.0000000",
"ShippedDate": "1996-12-09T00:00:00.0000000",
"ShipVia": 3,
"Freight": 3.9400,
"ShipName": "Wolski Zajazd",
"ShipAddress": "ul. Filtrowa 68",
"ShipCity": "Warszawa",
"ShipRegion": null,
"ShipPostalCode": "01-012",
"ShipCountry": "Poland"
},
{
"OrderID": 10375,
"CustomerID": "HUNGC",
"EmployeeID": 3,
"OrderDate": "1996-12-06T00:00:00.0000000",
"RequiredDate": "1997-01-03T00:00:00.0000000",
"ShippedDate": "1996-12-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 20.1200,
"ShipName": "Hungry Coyote Import Store",
"ShipAddress": "City Center Plaza 516 Main St.",
"ShipCity": "Elgin",
"ShipRegion": "OR",
"ShipPostalCode": "97827",
"ShipCountry": "USA"
},
{
"OrderID": 10376,
"CustomerID": "MEREP",
"EmployeeID": 1,
"OrderDate": "1996-12-09T00:00:00.0000000",
"RequiredDate": "1997-01-06T00:00:00.0000000",
"ShippedDate": "1996-12-13T00:00:00.0000000",
"ShipVia": 2,
"Freight": 20.3900,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10377,
"CustomerID": "SEVES",
"EmployeeID": 1,
"OrderDate": "1996-12-09T00:00:00.0000000",
"RequiredDate": "1997-01-06T00:00:00.0000000",
"ShippedDate": "1996-12-13T00:00:00.0000000",
"ShipVia": 3,
"Freight": 22.2100,
"ShipName": "Seven Seas Imports",
"ShipAddress": "90 Wadhurst Rd.",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "OX15 4NB",
"ShipCountry": "UK"
},
{
"OrderID": 10378,
"CustomerID": "FOLKO",
"EmployeeID": 5,
"OrderDate": "1996-12-10T00:00:00.0000000",
"RequiredDate": "1997-01-07T00:00:00.0000000",
"ShippedDate": "1996-12-19T00:00:00.0000000",
"ShipVia": 3,
"Freight": 5.4400,
"ShipName": "Folk och f\u00E4 HB",
"ShipAddress": "\u00C5kergatan 24",
"ShipCity": "Br\u00E4cke",
"ShipRegion": null,
"ShipPostalCode": "S-844 67",
"ShipCountry": "Sweden"
},
{
"OrderID": 10379,
"CustomerID": "QUEDE",
"EmployeeID": 2,
"OrderDate": "1996-12-11T00:00:00.0000000",
"RequiredDate": "1997-01-08T00:00:00.0000000",
"ShippedDate": "1996-12-13T00:00:00.0000000",
"ShipVia": 1,
"Freight": 45.0300,
"ShipName": "Que Del\u00EDcia",
"ShipAddress": "Rua da Panificadora, 12",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-673",
"ShipCountry": "Brazil"
},
{
"OrderID": 10380,
"CustomerID": "HUNGO",
"EmployeeID": 8,
"OrderDate": "1996-12-12T00:00:00.0000000",
"RequiredDate": "1997-01-09T00:00:00.0000000",
"ShippedDate": "1997-01-16T00:00:00.0000000",
"ShipVia": 3,
"Freight": 35.0300,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10381,
"CustomerID": "LILAS",
"EmployeeID": 3,
"OrderDate": "1996-12-12T00:00:00.0000000",
"RequiredDate": "1997-01-09T00:00:00.0000000",
"ShippedDate": "1996-12-13T00:00:00.0000000",
"ShipVia": 3,
"Freight": 7.9900,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10382,
"CustomerID": "ERNSH",
"EmployeeID": 4,
"OrderDate": "1996-12-13T00:00:00.0000000",
"RequiredDate": "1997-01-10T00:00:00.0000000",
"ShippedDate": "1996-12-16T00:00:00.0000000",
"ShipVia": 1,
"Freight": 94.7700,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10383,
"CustomerID": "AROUT",
"EmployeeID": 8,
"OrderDate": "1996-12-16T00:00:00.0000000",
"RequiredDate": "1997-01-13T00:00:00.0000000",
"ShippedDate": "1996-12-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 34.2400,
"ShipName": "Around the Horn",
"ShipAddress": "Brook Farm Stratford St. Mary",
"ShipCity": "Colchester",
"ShipRegion": "Essex",
"ShipPostalCode": "CO7 6JX",
"ShipCountry": "UK"
},
{
"OrderID": 10384,
"CustomerID": "BERGS",
"EmployeeID": 3,
"OrderDate": "1996-12-16T00:00:00.0000000",
"RequiredDate": "1997-01-13T00:00:00.0000000",
"ShippedDate": "1996-12-20T00:00:00.0000000",
"ShipVia": 3,
"Freight": 168.6400,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10385,
"CustomerID": "SPLIR",
"EmployeeID": 1,
"OrderDate": "1996-12-17T00:00:00.0000000",
"RequiredDate": "1997-01-14T00:00:00.0000000",
"ShippedDate": "1996-12-23T00:00:00.0000000",
"ShipVia": 2,
"Freight": 30.9600,
"ShipName": "Split Rail Beer \u0026 Ale",
"ShipAddress": "P.O. Box 555",
"ShipCity": "Lander",
"ShipRegion": "WY",
"ShipPostalCode": "82520",
"ShipCountry": "USA"
},
{
"OrderID": 10386,
"CustomerID": "FAMIA",
"EmployeeID": 9,
"OrderDate": "1996-12-18T00:00:00.0000000",
"RequiredDate": "1997-01-01T00:00:00.0000000",
"ShippedDate": "1996-12-25T00:00:00.0000000",
"ShipVia": 3,
"Freight": 13.9900,
"ShipName": "Familia Arquibaldo",
"ShipAddress": "Rua Or\u00F3s, 92",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05442-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10387,
"CustomerID": "SANTG",
"EmployeeID": 1,
"OrderDate": "1996-12-18T00:00:00.0000000",
"RequiredDate": "1997-01-15T00:00:00.0000000",
"ShippedDate": "1996-12-20T00:00:00.0000000",
"ShipVia": 2,
"Freight": 93.6300,
"ShipName": "Sant\u00E9 Gourmet",
"ShipAddress": "Erling Skakkes gate 78",
"ShipCity": "Stavern",
"ShipRegion": null,
"ShipPostalCode": "4110",
"ShipCountry": "Norway"
},
{
"OrderID": 10388,
"CustomerID": "SEVES",
"EmployeeID": 2,
"OrderDate": "1996-12-19T00:00:00.0000000",
"RequiredDate": "1997-01-16T00:00:00.0000000",
"ShippedDate": "1996-12-20T00:00:00.0000000",
"ShipVia": 1,
"Freight": 34.8600,
"ShipName": "Seven Seas Imports",
"ShipAddress": "90 Wadhurst Rd.",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "OX15 4NB",
"ShipCountry": "UK"
},
{
"OrderID": 10389,
"CustomerID": "BOTTM",
"EmployeeID": 4,
"OrderDate": "1996-12-20T00:00:00.0000000",
"RequiredDate": "1997-01-17T00:00:00.0000000",
"ShippedDate": "1996-12-24T00:00:00.0000000",
"ShipVia": 2,
"Freight": 47.4200,
"ShipName": "Bottom-Dollar Markets",
"ShipAddress": "23 Tsawassen Blvd.",
"ShipCity": "Tsawassen",
"ShipRegion": "BC",
"ShipPostalCode": "T2F 8M4",
"ShipCountry": "Canada"
},
{
"OrderID": 10390,
"CustomerID": "ERNSH",
"EmployeeID": 6,
"OrderDate": "1996-12-23T00:00:00.0000000",
"RequiredDate": "1997-01-20T00:00:00.0000000",
"ShippedDate": "1996-12-26T00:00:00.0000000",
"ShipVia": 1,
"Freight": 126.3800,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10391,
"CustomerID": "DRACD",
"EmployeeID": 3,
"OrderDate": "1996-12-23T00:00:00.0000000",
"RequiredDate": "1997-01-20T00:00:00.0000000",
"ShippedDate": "1996-12-31T00:00:00.0000000",
"ShipVia": 3,
"Freight": 5.4500,
"ShipName": "Drachenblut Delikatessen",
"ShipAddress": "Walserweg 21",
"ShipCity": "Aachen",
"ShipRegion": null,
"ShipPostalCode": "52066",
"ShipCountry": "Germany"
},
{
"OrderID": 10392,
"CustomerID": "PICCO",
"EmployeeID": 2,
"OrderDate": "1996-12-24T00:00:00.0000000",
"RequiredDate": "1997-01-21T00:00:00.0000000",
"ShippedDate": "1997-01-01T00:00:00.0000000",
"ShipVia": 3,
"Freight": 122.4600,
"ShipName": "Piccolo und mehr",
"ShipAddress": "Geislweg 14",
"ShipCity": "Salzburg",
"ShipRegion": null,
"ShipPostalCode": "5020",
"ShipCountry": "Austria"
},
{
"OrderID": 10393,
"CustomerID": "SAVEA",
"EmployeeID": 1,
"OrderDate": "1996-12-25T00:00:00.0000000",
"RequiredDate": "1997-01-22T00:00:00.0000000",
"ShippedDate": "1997-01-03T00:00:00.0000000",
"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": "1996-12-25T00:00:00.0000000",
"RequiredDate": "1997-01-22T00:00:00.0000000",
"ShippedDate": "1997-01-03T00:00:00.0000000",
"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": "1996-12-26T00:00:00.0000000",
"RequiredDate": "1997-01-23T00:00:00.0000000",
"ShippedDate": "1997-01-03T00:00:00.0000000",
"ShipVia": 1,
"Freight": 184.4100,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10396,
"CustomerID": "FRANK",
"EmployeeID": 1,
"OrderDate": "1996-12-27T00:00:00.0000000",
"RequiredDate": "1997-01-10T00:00:00.0000000",
"ShippedDate": "1997-01-06T00:00:00.0000000",
"ShipVia": 3,
"Freight": 135.3500,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10397,
"CustomerID": "PRINI",
"EmployeeID": 5,
"OrderDate": "1996-12-27T00:00:00.0000000",
"RequiredDate": "1997-01-24T00:00:00.0000000",
"ShippedDate": "1997-01-02T00:00:00.0000000",
"ShipVia": 1,
"Freight": 60.2600,
"ShipName": "Princesa Isabel Vinhos",
"ShipAddress": "Estrada da sa\u00FAde n. 58",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1756",
"ShipCountry": "Portugal"
},
{
"OrderID": 10398,
"CustomerID": "SAVEA",
"EmployeeID": 2,
"OrderDate": "1996-12-30T00:00:00.0000000",
"RequiredDate": "1997-01-27T00:00:00.0000000",
"ShippedDate": "1997-01-09T00:00:00.0000000",
"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": "1996-12-31T00:00:00.0000000",
"RequiredDate": "1997-01-14T00:00:00.0000000",
"ShippedDate": "1997-01-08T00:00:00.0000000",
"ShipVia": 3,
"Freight": 27.3600,
"ShipName": "Vaffeljernet",
"ShipAddress": "Smagsloget 45",
"ShipCity": "\u00C5rhus",
"ShipRegion": null,
"ShipPostalCode": "8200",
"ShipCountry": "Denmark"
},
{
"OrderID": 10400,
"CustomerID": "EASTC",
"EmployeeID": 1,
"OrderDate": "1997-01-01T00:00:00.0000000",
"RequiredDate": "1997-01-29T00:00:00.0000000",
"ShippedDate": "1997-01-16T00:00:00.0000000",
"ShipVia": 3,
"Freight": 83.9300,
"ShipName": "Eastern Connection",
"ShipAddress": "35 King George",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "WX3 6FW",
"ShipCountry": "UK"
},
{
"OrderID": 10401,
"CustomerID": "RATTC",
"EmployeeID": 1,
"OrderDate": "1997-01-01T00:00:00.0000000",
"RequiredDate": "1997-01-29T00:00:00.0000000",
"ShippedDate": "1997-01-10T00:00:00.0000000",
"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": "1997-01-02T00:00:00.0000000",
"RequiredDate": "1997-02-13T00:00:00.0000000",
"ShippedDate": "1997-01-10T00:00:00.0000000",
"ShipVia": 2,
"Freight": 67.8800,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10403,
"CustomerID": "ERNSH",
"EmployeeID": 4,
"OrderDate": "1997-01-03T00:00:00.0000000",
"RequiredDate": "1997-01-31T00:00:00.0000000",
"ShippedDate": "1997-01-09T00:00:00.0000000",
"ShipVia": 3,
"Freight": 73.7900,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10404,
"CustomerID": "MAGAA",
"EmployeeID": 2,
"OrderDate": "1997-01-03T00:00:00.0000000",
"RequiredDate": "1997-01-31T00:00:00.0000000",
"ShippedDate": "1997-01-08T00:00:00.0000000",
"ShipVia": 1,
"Freight": 155.9700,
"ShipName": "Magazzini Alimentari Riuniti",
"ShipAddress": "Via Ludovico il Moro 22",
"ShipCity": "Bergamo",
"ShipRegion": null,
"ShipPostalCode": "24100",
"ShipCountry": "Italy"
},
{
"OrderID": 10405,
"CustomerID": "LINOD",
"EmployeeID": 1,
"OrderDate": "1997-01-06T00:00:00.0000000",
"RequiredDate": "1997-02-03T00:00:00.0000000",
"ShippedDate": "1997-01-22T00:00:00.0000000",
"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": 10406,
"CustomerID": "QUEEN",
"EmployeeID": 7,
"OrderDate": "1997-01-07T00:00:00.0000000",
"RequiredDate": "1997-02-18T00:00:00.0000000",
"ShippedDate": "1997-01-13T00:00:00.0000000",
"ShipVia": 1,
"Freight": 108.0400,
"ShipName": "Queen Cozinha",
"ShipAddress": "Alameda dos Can\u00E0rios, 891",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05487-020",
"ShipCountry": "Brazil"
},
{
"OrderID": 10407,
"CustomerID": "OTTIK",
"EmployeeID": 2,
"OrderDate": "1997-01-07T00:00:00.0000000",
"RequiredDate": "1997-02-04T00:00:00.0000000",
"ShippedDate": "1997-01-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 91.4800,
"ShipName": "Ottilies K\u00E4seladen",
"ShipAddress": "Mehrheimerstr. 369",
"ShipCity": "K\u00F6ln",
"ShipRegion": null,
"ShipPostalCode": "50739",
"ShipCountry": "Germany"
},
{
"OrderID": 10408,
"CustomerID": "FOLIG",
"EmployeeID": 8,
"OrderDate": "1997-01-08T00:00:00.0000000",
"RequiredDate": "1997-02-05T00:00:00.0000000",
"ShippedDate": "1997-01-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 11.2600,
"ShipName": "Folies gourmandes",
"ShipAddress": "184, chauss\u00E9e de Tournai",
"ShipCity": "Lille",
"ShipRegion": null,
"ShipPostalCode": "59000",
"ShipCountry": "France"
},
{
"OrderID": 10409,
"CustomerID": "OCEAN",
"EmployeeID": 3,
"OrderDate": "1997-01-09T00:00:00.0000000",
"RequiredDate": "1997-02-06T00:00:00.0000000",
"ShippedDate": "1997-01-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 29.8300,
"ShipName": "Oc\u00E9ano Atl\u00E1ntico Ltda.",
"ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
"ShipCity": "Buenos Aires",
"ShipRegion": null,
"ShipPostalCode": "1010",
"ShipCountry": "Argentina"
},
{
"OrderID": 10410,
"CustomerID": "BOTTM",
"EmployeeID": 3,
"OrderDate": "1997-01-10T00:00:00.0000000",
"RequiredDate": "1997-02-07T00:00:00.0000000",
"ShippedDate": "1997-01-15T00:00:00.0000000",
"ShipVia": 3,
"Freight": 2.4000,
"ShipName": "Bottom-Dollar Markets",
"ShipAddress": "23 Tsawassen Blvd.",
"ShipCity": "Tsawassen",
"ShipRegion": "BC",
"ShipPostalCode": "T2F 8M4",
"ShipCountry": "Canada"
},
{
"OrderID": 10411,
"CustomerID": "BOTTM",
"EmployeeID": 9,
"OrderDate": "1997-01-10T00:00:00.0000000",
"RequiredDate": "1997-02-07T00:00:00.0000000",
"ShippedDate": "1997-01-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 23.6500,
"ShipName": "Bottom-Dollar Markets",
"ShipAddress": "23 Tsawassen Blvd.",
"ShipCity": "Tsawassen",
"ShipRegion": "BC",
"ShipPostalCode": "T2F 8M4",
"ShipCountry": "Canada"
},
{
"OrderID": 10412,
"CustomerID": "WARTH",
"EmployeeID": 8,
"OrderDate": "1997-01-13T00:00:00.0000000",
"RequiredDate": "1997-02-10T00:00:00.0000000",
"ShippedDate": "1997-01-15T00:00:00.0000000",
"ShipVia": 2,
"Freight": 3.7700,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10413,
"CustomerID": "LAMAI",
"EmployeeID": 3,
"OrderDate": "1997-01-14T00:00:00.0000000",
"RequiredDate": "1997-02-11T00:00:00.0000000",
"ShippedDate": "1997-01-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 95.6600,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10414,
"CustomerID": "FAMIA",
"EmployeeID": 2,
"OrderDate": "1997-01-14T00:00:00.0000000",
"RequiredDate": "1997-02-11T00:00:00.0000000",
"ShippedDate": "1997-01-17T00:00:00.0000000",
"ShipVia": 3,
"Freight": 21.4800,
"ShipName": "Familia Arquibaldo",
"ShipAddress": "Rua Or\u00F3s, 92",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05442-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10415,
"CustomerID": "HUNGC",
"EmployeeID": 3,
"OrderDate": "1997-01-15T00:00:00.0000000",
"RequiredDate": "1997-02-12T00:00:00.0000000",
"ShippedDate": "1997-01-24T00:00:00.0000000",
"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": "1997-01-16T00:00:00.0000000",
"RequiredDate": "1997-02-13T00:00:00.0000000",
"ShippedDate": "1997-01-27T00:00:00.0000000",
"ShipVia": 3,
"Freight": 22.7200,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10417,
"CustomerID": "SIMOB",
"EmployeeID": 4,
"OrderDate": "1997-01-16T00:00:00.0000000",
"RequiredDate": "1997-02-13T00:00:00.0000000",
"ShippedDate": "1997-01-28T00:00:00.0000000",
"ShipVia": 3,
"Freight": 70.2900,
"ShipName": "Simons bistro",
"ShipAddress": "Vinb\u00E6ltet 34",
"ShipCity": "Kobenhavn",
"ShipRegion": null,
"ShipPostalCode": "1734",
"ShipCountry": "Denmark"
},
{
"OrderID": 10418,
"CustomerID": "QUICK",
"EmployeeID": 4,
"OrderDate": "1997-01-17T00:00:00.0000000",
"RequiredDate": "1997-02-14T00:00:00.0000000",
"ShippedDate": "1997-01-24T00:00:00.0000000",
"ShipVia": 1,
"Freight": 17.5500,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10419,
"CustomerID": "RICSU",
"EmployeeID": 4,
"OrderDate": "1997-01-20T00:00:00.0000000",
"RequiredDate": "1997-02-17T00:00:00.0000000",
"ShippedDate": "1997-01-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 137.3500,
"ShipName": "Richter Supermarkt",
"ShipAddress": "Starenweg 5",
"ShipCity": "Gen\u00E8ve",
"ShipRegion": null,
"ShipPostalCode": "1204",
"ShipCountry": "Switzerland"
},
{
"OrderID": 10420,
"CustomerID": "WELLI",
"EmployeeID": 3,
"OrderDate": "1997-01-21T00:00:00.0000000",
"RequiredDate": "1997-02-18T00:00:00.0000000",
"ShippedDate": "1997-01-27T00:00:00.0000000",
"ShipVia": 1,
"Freight": 44.1200,
"ShipName": "Wellington Importadora",
"ShipAddress": "Rua do Mercado, 12",
"ShipCity": "Resende",
"ShipRegion": "SP",
"ShipPostalCode": "08737-363",
"ShipCountry": "Brazil"
},
{
"OrderID": 10421,
"CustomerID": "QUEDE",
"EmployeeID": 8,
"OrderDate": "1997-01-21T00:00:00.0000000",
"RequiredDate": "1997-03-04T00:00:00.0000000",
"ShippedDate": "1997-01-27T00:00:00.0000000",
"ShipVia": 1,
"Freight": 99.2300,
"ShipName": "Que Del\u00EDcia",
"ShipAddress": "Rua da Panificadora, 12",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-673",
"ShipCountry": "Brazil"
},
{
"OrderID": 10422,
"CustomerID": "FRANS",
"EmployeeID": 2,
"OrderDate": "1997-01-22T00:00:00.0000000",
"RequiredDate": "1997-02-19T00:00:00.0000000",
"ShippedDate": "1997-01-31T00:00:00.0000000",
"ShipVia": 1,
"Freight": 3.0200,
"ShipName": "Franchi S.p.A.",
"ShipAddress": "Via Monte Bianco 34",
"ShipCity": "Torino",
"ShipRegion": null,
"ShipPostalCode": "10100",
"ShipCountry": "Italy"
},
{
"OrderID": 10423,
"CustomerID": "GOURL",
"EmployeeID": 6,
"OrderDate": "1997-01-23T00:00:00.0000000",
"RequiredDate": "1997-02-06T00:00:00.0000000",
"ShippedDate": "1997-02-24T00:00:00.0000000",
"ShipVia": 3,
"Freight": 24.5000,
"ShipName": "Gourmet Lanchonetes",
"ShipAddress": "Av. Brasil, 442",
"ShipCity": "Campinas",
"ShipRegion": "SP",
"ShipPostalCode": "04876-786",
"ShipCountry": "Brazil"
},
{
"OrderID": 10424,
"CustomerID": "MEREP",
"EmployeeID": 7,
"OrderDate": "1997-01-23T00:00:00.0000000",
"RequiredDate": "1997-02-20T00:00:00.0000000",
"ShippedDate": "1997-01-27T00:00:00.0000000",
"ShipVia": 2,
"Freight": 370.6100,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10425,
"CustomerID": "LAMAI",
"EmployeeID": 6,
"OrderDate": "1997-01-24T00:00:00.0000000",
"RequiredDate": "1997-02-21T00:00:00.0000000",
"ShippedDate": "1997-02-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 7.9300,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10426,
"CustomerID": "GALED",
"EmployeeID": 4,
"OrderDate": "1997-01-27T00:00:00.0000000",
"RequiredDate": "1997-02-24T00:00:00.0000000",
"ShippedDate": "1997-02-06T00:00:00.0000000",
"ShipVia": 1,
"Freight": 18.6900,
"ShipName": "Galer\u00EDa del gastron\u00F3mo",
"ShipAddress": "Rambla de Catalu\u00F1a, 23",
"ShipCity": "Barcelona",
"ShipRegion": null,
"ShipPostalCode": "8022",
"ShipCountry": "Spain"
},
{
"OrderID": 10427,
"CustomerID": "PICCO",
"EmployeeID": 4,
"OrderDate": "1997-01-27T00:00:00.0000000",
"RequiredDate": "1997-02-24T00:00:00.0000000",
"ShippedDate": "1997-03-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 31.2900,
"ShipName": "Piccolo und mehr",
"ShipAddress": "Geislweg 14",
"ShipCity": "Salzburg",
"ShipRegion": null,
"ShipPostalCode": "5020",
"ShipCountry": "Austria"
},
{
"OrderID": 10428,
"CustomerID": "REGGC",
"EmployeeID": 7,
"OrderDate": "1997-01-28T00:00:00.0000000",
"RequiredDate": "1997-02-25T00:00:00.0000000",
"ShippedDate": "1997-02-04T00:00:00.0000000",
"ShipVia": 1,
"Freight": 11.0900,
"ShipName": "Reggiani Caseifici",
"ShipAddress": "Strada Provinciale 124",
"ShipCity": "Reggio Emilia",
"ShipRegion": null,
"ShipPostalCode": "42100",
"ShipCountry": "Italy"
},
{
"OrderID": 10429,
"CustomerID": "HUNGO",
"EmployeeID": 3,
"OrderDate": "1997-01-29T00:00:00.0000000",
"RequiredDate": "1997-03-12T00:00:00.0000000",
"ShippedDate": "1997-02-07T00:00:00.0000000",
"ShipVia": 2,
"Freight": 56.6300,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10430,
"CustomerID": "ERNSH",
"EmployeeID": 4,
"OrderDate": "1997-01-30T00:00:00.0000000",
"RequiredDate": "1997-02-13T00:00:00.0000000",
"ShippedDate": "1997-02-03T00:00:00.0000000",
"ShipVia": 1,
"Freight": 458.7800,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10431,
"CustomerID": "BOTTM",
"EmployeeID": 4,
"OrderDate": "1997-01-30T00:00:00.0000000",
"RequiredDate": "1997-02-13T00:00:00.0000000",
"ShippedDate": "1997-02-07T00:00:00.0000000",
"ShipVia": 2,
"Freight": 44.1700,
"ShipName": "Bottom-Dollar Markets",
"ShipAddress": "23 Tsawassen Blvd.",
"ShipCity": "Tsawassen",
"ShipRegion": "BC",
"ShipPostalCode": "T2F 8M4",
"ShipCountry": "Canada"
},
{
"OrderID": 10432,
"CustomerID": "SPLIR",
"EmployeeID": 3,
"OrderDate": "1997-01-31T00:00:00.0000000",
"RequiredDate": "1997-02-14T00:00:00.0000000",
"ShippedDate": "1997-02-07T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.3400,
"ShipName": "Split Rail Beer \u0026 Ale",
"ShipAddress": "P.O. Box 555",
"ShipCity": "Lander",
"ShipRegion": "WY",
"ShipPostalCode": "82520",
"ShipCountry": "USA"
},
{
"OrderID": 10433,
"CustomerID": "PRINI",
"EmployeeID": 3,
"OrderDate": "1997-02-03T00:00:00.0000000",
"RequiredDate": "1997-03-03T00:00:00.0000000",
"ShippedDate": "1997-03-04T00:00:00.0000000",
"ShipVia": 3,
"Freight": 73.8300,
"ShipName": "Princesa Isabel Vinhos",
"ShipAddress": "Estrada da sa\u00FAde n. 58",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1756",
"ShipCountry": "Portugal"
},
{
"OrderID": 10434,
"CustomerID": "FOLKO",
"EmployeeID": 3,
"OrderDate": "1997-02-03T00:00:00.0000000",
"RequiredDate": "1997-03-03T00:00:00.0000000",
"ShippedDate": "1997-02-13T00:00:00.0000000",
"ShipVia": 2,
"Freight": 17.9200,
"ShipName": "Folk och f\u00E4 HB",
"ShipAddress": "\u00C5kergatan 24",
"ShipCity": "Br\u00E4cke",
"ShipRegion": null,
"ShipPostalCode": "S-844 67",
"ShipCountry": "Sweden"
},
{
"OrderID": 10435,
"CustomerID": "CONSH",
"EmployeeID": 8,
"OrderDate": "1997-02-04T00:00:00.0000000",
"RequiredDate": "1997-03-18T00:00:00.0000000",
"ShippedDate": "1997-02-07T00:00:00.0000000",
"ShipVia": 2,
"Freight": 9.2100,
"ShipName": "Consolidated Holdings",
"ShipAddress": "Berkeley Gardens 12 Brewery",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "WX1 6LT",
"ShipCountry": "UK"
},
{
"OrderID": 10436,
"CustomerID": "BLONP",
"EmployeeID": 3,
"OrderDate": "1997-02-05T00:00:00.0000000",
"RequiredDate": "1997-03-05T00:00:00.0000000",
"ShippedDate": "1997-02-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 156.6600,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10437,
"CustomerID": "WARTH",
"EmployeeID": 8,
"OrderDate": "1997-02-05T00:00:00.0000000",
"RequiredDate": "1997-03-05T00:00:00.0000000",
"ShippedDate": "1997-02-12T00:00:00.0000000",
"ShipVia": 1,
"Freight": 19.9700,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10438,
"CustomerID": "TOMSP",
"EmployeeID": 3,
"OrderDate": "1997-02-06T00:00:00.0000000",
"RequiredDate": "1997-03-06T00:00:00.0000000",
"ShippedDate": "1997-02-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 8.2400,
"ShipName": "Toms Spezialit\u00E4ten",
"ShipAddress": "Luisenstr. 48",
"ShipCity": "M\u00FCnster",
"ShipRegion": null,
"ShipPostalCode": "44087",
"ShipCountry": "Germany"
},
{
"OrderID": 10439,
"CustomerID": "MEREP",
"EmployeeID": 6,
"OrderDate": "1997-02-07T00:00:00.0000000",
"RequiredDate": "1997-03-07T00:00:00.0000000",
"ShippedDate": "1997-02-10T00:00:00.0000000",
"ShipVia": 3,
"Freight": 4.0700,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10440,
"CustomerID": "SAVEA",
"EmployeeID": 4,
"OrderDate": "1997-02-10T00:00:00.0000000",
"RequiredDate": "1997-03-10T00:00:00.0000000",
"ShippedDate": "1997-02-28T00:00:00.0000000",
"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": "1997-02-10T00:00:00.0000000",
"RequiredDate": "1997-03-24T00:00:00.0000000",
"ShippedDate": "1997-03-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 73.0200,
"ShipName": "Old World Delicatessen",
"ShipAddress": "2743 Bering St.",
"ShipCity": "Anchorage",
"ShipRegion": "AK",
"ShipPostalCode": "99508",
"ShipCountry": "USA"
},
{
"OrderID": 10442,
"CustomerID": "ERNSH",
"EmployeeID": 3,
"OrderDate": "1997-02-11T00:00:00.0000000",
"RequiredDate": "1997-03-11T00:00:00.0000000",
"ShippedDate": "1997-02-18T00:00:00.0000000",
"ShipVia": 2,
"Freight": 47.9400,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10443,
"CustomerID": "REGGC",
"EmployeeID": 8,
"OrderDate": "1997-02-12T00:00:00.0000000",
"RequiredDate": "1997-03-12T00:00:00.0000000",
"ShippedDate": "1997-02-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 13.9500,
"ShipName": "Reggiani Caseifici",
"ShipAddress": "Strada Provinciale 124",
"ShipCity": "Reggio Emilia",
"ShipRegion": null,
"ShipPostalCode": "42100",
"ShipCountry": "Italy"
},
{
"OrderID": 10444,
"CustomerID": "BERGS",
"EmployeeID": 3,
"OrderDate": "1997-02-12T00:00:00.0000000",
"RequiredDate": "1997-03-12T00:00:00.0000000",
"ShippedDate": "1997-02-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 3.5000,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10445,
"CustomerID": "BERGS",
"EmployeeID": 3,
"OrderDate": "1997-02-13T00:00:00.0000000",
"RequiredDate": "1997-03-13T00:00:00.0000000",
"ShippedDate": "1997-02-20T00:00:00.0000000",
"ShipVia": 1,
"Freight": 9.3000,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10446,
"CustomerID": "TOMSP",
"EmployeeID": 6,
"OrderDate": "1997-02-14T00:00:00.0000000",
"RequiredDate": "1997-03-14T00:00:00.0000000",
"ShippedDate": "1997-02-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 14.6800,
"ShipName": "Toms Spezialit\u00E4ten",
"ShipAddress": "Luisenstr. 48",
"ShipCity": "M\u00FCnster",
"ShipRegion": null,
"ShipPostalCode": "44087",
"ShipCountry": "Germany"
},
{
"OrderID": 10447,
"CustomerID": "RICAR",
"EmployeeID": 4,
"OrderDate": "1997-02-14T00:00:00.0000000",
"RequiredDate": "1997-03-14T00:00:00.0000000",
"ShippedDate": "1997-03-07T00:00:00.0000000",
"ShipVia": 2,
"Freight": 68.6600,
"ShipName": "Ricardo Adocicados",
"ShipAddress": "Av. Copacabana, 267",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-890",
"ShipCountry": "Brazil"
},
{
"OrderID": 10448,
"CustomerID": "RANCH",
"EmployeeID": 4,
"OrderDate": "1997-02-17T00:00:00.0000000",
"RequiredDate": "1997-03-17T00:00:00.0000000",
"ShippedDate": "1997-02-24T00:00:00.0000000",
"ShipVia": 2,
"Freight": 38.8200,
"ShipName": "Rancho grande",
"ShipAddress": "Av. del Libertador 900",
"ShipCity": "Buenos Aires",
"ShipRegion": null,
"ShipPostalCode": "1010",
"ShipCountry": "Argentina"
},
{
"OrderID": 10449,
"CustomerID": "BLONP",
"EmployeeID": 3,
"OrderDate": "1997-02-18T00:00:00.0000000",
"RequiredDate": "1997-03-18T00:00:00.0000000",
"ShippedDate": "1997-02-27T00:00:00.0000000",
"ShipVia": 2,
"Freight": 53.3000,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10450,
"CustomerID": "VICTE",
"EmployeeID": 8,
"OrderDate": "1997-02-19T00:00:00.0000000",
"RequiredDate": "1997-03-19T00:00:00.0000000",
"ShippedDate": "1997-03-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 7.2300,
"ShipName": "Victuailles en stock",
"ShipAddress": "2, rue du Commerce",
"ShipCity": "Lyon",
"ShipRegion": null,
"ShipPostalCode": "69004",
"ShipCountry": "France"
},
{
"OrderID": 10451,
"CustomerID": "QUICK",
"EmployeeID": 4,
"OrderDate": "1997-02-19T00:00:00.0000000",
"RequiredDate": "1997-03-05T00:00:00.0000000",
"ShippedDate": "1997-03-12T00:00:00.0000000",
"ShipVia": 3,
"Freight": 189.0900,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10452,
"CustomerID": "SAVEA",
"EmployeeID": 8,
"OrderDate": "1997-02-20T00:00:00.0000000",
"RequiredDate": "1997-03-20T00:00:00.0000000",
"ShippedDate": "1997-02-26T00:00:00.0000000",
"ShipVia": 1,
"Freight": 140.2600,
"ShipName": "Save-a-lot Markets",
"ShipAddress": "187 Suffolk Ln.",
"ShipCity": "Boise",
"ShipRegion": "ID",
"ShipPostalCode": "83720",
"ShipCountry": "USA"
},
{
"OrderID": 10453,
"CustomerID": "AROUT",
"EmployeeID": 1,
"OrderDate": "1997-02-21T00:00:00.0000000",
"RequiredDate": "1997-03-21T00:00:00.0000000",
"ShippedDate": "1997-02-26T00:00:00.0000000",
"ShipVia": 2,
"Freight": 25.3600,
"ShipName": "Around the Horn",
"ShipAddress": "Brook Farm Stratford St. Mary",
"ShipCity": "Colchester",
"ShipRegion": "Essex",
"ShipPostalCode": "CO7 6JX",
"ShipCountry": "UK"
},
{
"OrderID": 10454,
"CustomerID": "LAMAI",
"EmployeeID": 4,
"OrderDate": "1997-02-21T00:00:00.0000000",
"RequiredDate": "1997-03-21T00:00:00.0000000",
"ShippedDate": "1997-02-25T00:00:00.0000000",
"ShipVia": 3,
"Freight": 2.7400,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10455,
"CustomerID": "WARTH",
"EmployeeID": 8,
"OrderDate": "1997-02-24T00:00:00.0000000",
"RequiredDate": "1997-04-07T00:00:00.0000000",
"ShippedDate": "1997-03-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 180.4500,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10456,
"CustomerID": "KOENE",
"EmployeeID": 8,
"OrderDate": "1997-02-25T00:00:00.0000000",
"RequiredDate": "1997-04-08T00:00:00.0000000",
"ShippedDate": "1997-02-28T00:00:00.0000000",
"ShipVia": 2,
"Freight": 8.1200,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10457,
"CustomerID": "KOENE",
"EmployeeID": 2,
"OrderDate": "1997-02-25T00:00:00.0000000",
"RequiredDate": "1997-03-25T00:00:00.0000000",
"ShippedDate": "1997-03-03T00:00:00.0000000",
"ShipVia": 1,
"Freight": 11.5700,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10458,
"CustomerID": "SUPRD",
"EmployeeID": 7,
"OrderDate": "1997-02-26T00:00:00.0000000",
"RequiredDate": "1997-03-26T00:00:00.0000000",
"ShippedDate": "1997-03-04T00:00:00.0000000",
"ShipVia": 3,
"Freight": 147.0600,
"ShipName": "Supr\u00EAmes d\u00E9lices",
"ShipAddress": "Boulevard Tirou, 255",
"ShipCity": "Charleroi",
"ShipRegion": null,
"ShipPostalCode": "B-6000",
"ShipCountry": "Belgium"
},
{
"OrderID": 10459,
"CustomerID": "VICTE",
"EmployeeID": 4,
"OrderDate": "1997-02-27T00:00:00.0000000",
"RequiredDate": "1997-03-27T00:00:00.0000000",
"ShippedDate": "1997-02-28T00:00:00.0000000",
"ShipVia": 2,
"Freight": 25.0900,
"ShipName": "Victuailles en stock",
"ShipAddress": "2, rue du Commerce",
"ShipCity": "Lyon",
"ShipRegion": null,
"ShipPostalCode": "69004",
"ShipCountry": "France"
},
{
"OrderID": 10460,
"CustomerID": "FOLKO",
"EmployeeID": 8,
"OrderDate": "1997-02-28T00:00:00.0000000",
"RequiredDate": "1997-03-28T00:00:00.0000000",
"ShippedDate": "1997-03-03T00:00:00.0000000",
"ShipVia": 1,
"Freight": 16.2700,
"ShipName": "Folk och f\u00E4 HB",
"ShipAddress": "\u00C5kergatan 24",
"ShipCity": "Br\u00E4cke",
"ShipRegion": null,
"ShipPostalCode": "S-844 67",
"ShipCountry": "Sweden"
},
{
"OrderID": 10461,
"CustomerID": "LILAS",
"EmployeeID": 1,
"OrderDate": "1997-02-28T00:00:00.0000000",
"RequiredDate": "1997-03-28T00:00:00.0000000",
"ShippedDate": "1997-03-05T00:00:00.0000000",
"ShipVia": 3,
"Freight": 148.6100,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10462,
"CustomerID": "CONSH",
"EmployeeID": 2,
"OrderDate": "1997-03-03T00:00:00.0000000",
"RequiredDate": "1997-03-31T00:00:00.0000000",
"ShippedDate": "1997-03-18T00:00:00.0000000",
"ShipVia": 1,
"Freight": 6.1700,
"ShipName": "Consolidated Holdings",
"ShipAddress": "Berkeley Gardens 12 Brewery",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "WX1 6LT",
"ShipCountry": "UK"
},
{
"OrderID": 10463,
"CustomerID": "SUPRD",
"EmployeeID": 5,
"OrderDate": "1997-03-04T00:00:00.0000000",
"RequiredDate": "1997-04-01T00:00:00.0000000",
"ShippedDate": "1997-03-06T00:00:00.0000000",
"ShipVia": 3,
"Freight": 14.7800,
"ShipName": "Supr\u00EAmes d\u00E9lices",
"ShipAddress": "Boulevard Tirou, 255",
"ShipCity": "Charleroi",
"ShipRegion": null,
"ShipPostalCode": "B-6000",
"ShipCountry": "Belgium"
},
{
"OrderID": 10464,
"CustomerID": "FURIB",
"EmployeeID": 4,
"OrderDate": "1997-03-04T00:00:00.0000000",
"RequiredDate": "1997-04-01T00:00:00.0000000",
"ShippedDate": "1997-03-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 89.0000,
"ShipName": "Furia Bacalhau e Frutos do Mar",
"ShipAddress": "Jardim das rosas n. 32",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1675",
"ShipCountry": "Portugal"
},
{
"OrderID": 10465,
"CustomerID": "VAFFE",
"EmployeeID": 1,
"OrderDate": "1997-03-05T00:00:00.0000000",
"RequiredDate": "1997-04-02T00:00:00.0000000",
"ShippedDate": "1997-03-14T00:00:00.0000000",
"ShipVia": 3,
"Freight": 145.0400,
"ShipName": "Vaffeljernet",
"ShipAddress": "Smagsloget 45",
"ShipCity": "\u00C5rhus",
"ShipRegion": null,
"ShipPostalCode": "8200",
"ShipCountry": "Denmark"
},
{
"OrderID": 10466,
"CustomerID": "COMMI",
"EmployeeID": 4,
"OrderDate": "1997-03-06T00:00:00.0000000",
"RequiredDate": "1997-04-03T00:00:00.0000000",
"ShippedDate": "1997-03-13T00:00:00.0000000",
"ShipVia": 1,
"Freight": 11.9300,
"ShipName": "Com\u00E9rcio Mineiro",
"ShipAddress": "Av. dos Lus\u00EDadas, 23",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05432-043",
"ShipCountry": "Brazil"
},
{
"OrderID": 10467,
"CustomerID": "MAGAA",
"EmployeeID": 8,
"OrderDate": "1997-03-06T00:00:00.0000000",
"RequiredDate": "1997-04-03T00:00:00.0000000",
"ShippedDate": "1997-03-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.9300,
"ShipName": "Magazzini Alimentari Riuniti",
"ShipAddress": "Via Ludovico il Moro 22",
"ShipCity": "Bergamo",
"ShipRegion": null,
"ShipPostalCode": "24100",
"ShipCountry": "Italy"
},
{
"OrderID": 10468,
"CustomerID": "KOENE",
"EmployeeID": 3,
"OrderDate": "1997-03-07T00:00:00.0000000",
"RequiredDate": "1997-04-04T00:00:00.0000000",
"ShippedDate": "1997-03-12T00:00:00.0000000",
"ShipVia": 3,
"Freight": 44.1200,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10469,
"CustomerID": "WHITC",
"EmployeeID": 1,
"OrderDate": "1997-03-10T00:00:00.0000000",
"RequiredDate": "1997-04-07T00:00:00.0000000",
"ShippedDate": "1997-03-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 60.1800,
"ShipName": "White Clover Markets",
"ShipAddress": "1029 - 12th Ave. S.",
"ShipCity": "Seattle",
"ShipRegion": "WA",
"ShipPostalCode": "98124",
"ShipCountry": "USA"
},
{
"OrderID": 10470,
"CustomerID": "BONAP",
"EmployeeID": 4,
"OrderDate": "1997-03-11T00:00:00.0000000",
"RequiredDate": "1997-04-08T00:00:00.0000000",
"ShippedDate": "1997-03-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 64.5600,
"ShipName": "Bon app\u0027",
"ShipAddress": "12, rue des Bouchers",
"ShipCity": "Marseille",
"ShipRegion": null,
"ShipPostalCode": "13008",
"ShipCountry": "France"
},
{
"OrderID": 10471,
"CustomerID": "BSBEV",
"EmployeeID": 2,
"OrderDate": "1997-03-11T00:00:00.0000000",
"RequiredDate": "1997-04-08T00:00:00.0000000",
"ShippedDate": "1997-03-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 45.5900,
"ShipName": "B\u0027s Beverages",
"ShipAddress": "Fauntleroy Circus",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "EC2 5NT",
"ShipCountry": "UK"
},
{
"OrderID": 10472,
"CustomerID": "SEVES",
"EmployeeID": 8,
"OrderDate": "1997-03-12T00:00:00.0000000",
"RequiredDate": "1997-04-09T00:00:00.0000000",
"ShippedDate": "1997-03-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 4.2000,
"ShipName": "Seven Seas Imports",
"ShipAddress": "90 Wadhurst Rd.",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "OX15 4NB",
"ShipCountry": "UK"
},
{
"OrderID": 10473,
"CustomerID": "ISLAT",
"EmployeeID": 1,
"OrderDate": "1997-03-13T00:00:00.0000000",
"RequiredDate": "1997-03-27T00:00:00.0000000",
"ShippedDate": "1997-03-21T00:00:00.0000000",
"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": "1997-03-13T00:00:00.0000000",
"RequiredDate": "1997-04-10T00:00:00.0000000",
"ShippedDate": "1997-03-21T00:00:00.0000000",
"ShipVia": 2,
"Freight": 83.4900,
"ShipName": "Pericles Comidas cl\u00E1sicas",
"ShipAddress": "Calle Dr. Jorge Cash 321",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10475,
"CustomerID": "SUPRD",
"EmployeeID": 9,
"OrderDate": "1997-03-14T00:00:00.0000000",
"RequiredDate": "1997-04-11T00:00:00.0000000",
"ShippedDate": "1997-04-04T00:00:00.0000000",
"ShipVia": 1,
"Freight": 68.5200,
"ShipName": "Supr\u00EAmes d\u00E9lices",
"ShipAddress": "Boulevard Tirou, 255",
"ShipCity": "Charleroi",
"ShipRegion": null,
"ShipPostalCode": "B-6000",
"ShipCountry": "Belgium"
},
{
"OrderID": 10476,
"CustomerID": "HILAA",
"EmployeeID": 8,
"OrderDate": "1997-03-17T00:00:00.0000000",
"RequiredDate": "1997-04-14T00:00:00.0000000",
"ShippedDate": "1997-03-24T00:00:00.0000000",
"ShipVia": 3,
"Freight": 4.4100,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10477,
"CustomerID": "PRINI",
"EmployeeID": 5,
"OrderDate": "1997-03-17T00:00:00.0000000",
"RequiredDate": "1997-04-14T00:00:00.0000000",
"ShippedDate": "1997-03-25T00:00:00.0000000",
"ShipVia": 2,
"Freight": 13.0200,
"ShipName": "Princesa Isabel Vinhos",
"ShipAddress": "Estrada da sa\u00FAde n. 58",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1756",
"ShipCountry": "Portugal"
},
{
"OrderID": 10478,
"CustomerID": "VICTE",
"EmployeeID": 2,
"OrderDate": "1997-03-18T00:00:00.0000000",
"RequiredDate": "1997-04-01T00:00:00.0000000",
"ShippedDate": "1997-03-26T00:00:00.0000000",
"ShipVia": 3,
"Freight": 4.8100,
"ShipName": "Victuailles en stock",
"ShipAddress": "2, rue du Commerce",
"ShipCity": "Lyon",
"ShipRegion": null,
"ShipPostalCode": "69004",
"ShipCountry": "France"
},
{
"OrderID": 10479,
"CustomerID": "RATTC",
"EmployeeID": 3,
"OrderDate": "1997-03-19T00:00:00.0000000",
"RequiredDate": "1997-04-16T00:00:00.0000000",
"ShippedDate": "1997-03-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 708.9500,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10480,
"CustomerID": "FOLIG",
"EmployeeID": 6,
"OrderDate": "1997-03-20T00:00:00.0000000",
"RequiredDate": "1997-04-17T00:00:00.0000000",
"ShippedDate": "1997-03-24T00:00:00.0000000",
"ShipVia": 2,
"Freight": 1.3500,
"ShipName": "Folies gourmandes",
"ShipAddress": "184, chauss\u00E9e de Tournai",
"ShipCity": "Lille",
"ShipRegion": null,
"ShipPostalCode": "59000",
"ShipCountry": "France"
},
{
"OrderID": 10481,
"CustomerID": "RICAR",
"EmployeeID": 8,
"OrderDate": "1997-03-20T00:00:00.0000000",
"RequiredDate": "1997-04-17T00:00:00.0000000",
"ShippedDate": "1997-03-25T00:00:00.0000000",
"ShipVia": 2,
"Freight": 64.3300,
"ShipName": "Ricardo Adocicados",
"ShipAddress": "Av. Copacabana, 267",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-890",
"ShipCountry": "Brazil"
},
{
"OrderID": 10482,
"CustomerID": "LAZYK",
"EmployeeID": 1,
"OrderDate": "1997-03-21T00:00:00.0000000",
"RequiredDate": "1997-04-18T00:00:00.0000000",
"ShippedDate": "1997-04-10T00:00:00.0000000",
"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": "1997-03-24T00:00:00.0000000",
"RequiredDate": "1997-04-21T00:00:00.0000000",
"ShippedDate": "1997-04-25T00:00:00.0000000",
"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": "1997-03-24T00:00:00.0000000",
"RequiredDate": "1997-04-21T00:00:00.0000000",
"ShippedDate": "1997-04-01T00:00:00.0000000",
"ShipVia": 3,
"Freight": 6.8800,
"ShipName": "B\u0027s Beverages",
"ShipAddress": "Fauntleroy Circus",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "EC2 5NT",
"ShipCountry": "UK"
},
{
"OrderID": 10485,
"CustomerID": "LINOD",
"EmployeeID": 4,
"OrderDate": "1997-03-25T00:00:00.0000000",
"RequiredDate": "1997-04-08T00:00:00.0000000",
"ShippedDate": "1997-03-31T00:00:00.0000000",
"ShipVia": 2,
"Freight": 64.4500,
"ShipName": "LINO-Delicateses",
"ShipAddress": "Ave. 5 de Mayo Porlamar",
"ShipCity": "I. de Margarita",
"ShipRegion": "Nueva Esparta",
"ShipPostalCode": "4980",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10486,
"CustomerID": "HILAA",
"EmployeeID": 1,
"OrderDate": "1997-03-26T00:00:00.0000000",
"RequiredDate": "1997-04-23T00:00:00.0000000",
"ShippedDate": "1997-04-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 30.5300,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10487,
"CustomerID": "QUEEN",
"EmployeeID": 2,
"OrderDate": "1997-03-26T00:00:00.0000000",
"RequiredDate": "1997-04-23T00:00:00.0000000",
"ShippedDate": "1997-03-28T00:00:00.0000000",
"ShipVia": 2,
"Freight": 71.0700,
"ShipName": "Queen Cozinha",
"ShipAddress": "Alameda dos Can\u00E0rios, 891",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05487-020",
"ShipCountry": "Brazil"
},
{
"OrderID": 10488,
"CustomerID": "FRANK",
"EmployeeID": 8,
"OrderDate": "1997-03-27T00:00:00.0000000",
"RequiredDate": "1997-04-24T00:00:00.0000000",
"ShippedDate": "1997-04-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.9300,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10489,
"CustomerID": "PICCO",
"EmployeeID": 6,
"OrderDate": "1997-03-28T00:00:00.0000000",
"RequiredDate": "1997-04-25T00:00:00.0000000",
"ShippedDate": "1997-04-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 5.2900,
"ShipName": "Piccolo und mehr",
"ShipAddress": "Geislweg 14",
"ShipCity": "Salzburg",
"ShipRegion": null,
"ShipPostalCode": "5020",
"ShipCountry": "Austria"
},
{
"OrderID": 10490,
"CustomerID": "HILAA",
"EmployeeID": 7,
"OrderDate": "1997-03-31T00:00:00.0000000",
"RequiredDate": "1997-04-28T00:00:00.0000000",
"ShippedDate": "1997-04-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 210.1900,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10491,
"CustomerID": "FURIB",
"EmployeeID": 8,
"OrderDate": "1997-03-31T00:00:00.0000000",
"RequiredDate": "1997-04-28T00:00:00.0000000",
"ShippedDate": "1997-04-08T00:00:00.0000000",
"ShipVia": 3,
"Freight": 16.9600,
"ShipName": "Furia Bacalhau e Frutos do Mar",
"ShipAddress": "Jardim das rosas n. 32",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1675",
"ShipCountry": "Portugal"
},
{
"OrderID": 10492,
"CustomerID": "BOTTM",
"EmployeeID": 3,
"OrderDate": "1997-04-01T00:00:00.0000000",
"RequiredDate": "1997-04-29T00:00:00.0000000",
"ShippedDate": "1997-04-11T00:00:00.0000000",
"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": "1997-04-02T00:00:00.0000000",
"RequiredDate": "1997-04-30T00:00:00.0000000",
"ShippedDate": "1997-04-10T00:00:00.0000000",
"ShipVia": 3,
"Freight": 10.6400,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10494,
"CustomerID": "COMMI",
"EmployeeID": 4,
"OrderDate": "1997-04-02T00:00:00.0000000",
"RequiredDate": "1997-04-30T00:00:00.0000000",
"ShippedDate": "1997-04-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 65.9900,
"ShipName": "Com\u00E9rcio Mineiro",
"ShipAddress": "Av. dos Lus\u00EDadas, 23",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05432-043",
"ShipCountry": "Brazil"
},
{
"OrderID": 10495,
"CustomerID": "LAUGB",
"EmployeeID": 3,
"OrderDate": "1997-04-03T00:00:00.0000000",
"RequiredDate": "1997-05-01T00:00:00.0000000",
"ShippedDate": "1997-04-11T00:00:00.0000000",
"ShipVia": 3,
"Freight": 4.6500,
"ShipName": "Laughing Bacchus Wine Cellars",
"ShipAddress": "2319 Elm St.",
"ShipCity": "Vancouver",
"ShipRegion": "BC",
"ShipPostalCode": "V3F 2K1",
"ShipCountry": "Canada"
},
{
"OrderID": 10496,
"CustomerID": "TRADH",
"EmployeeID": 7,
"OrderDate": "1997-04-04T00:00:00.0000000",
"RequiredDate": "1997-05-02T00:00:00.0000000",
"ShippedDate": "1997-04-07T00:00:00.0000000",
"ShipVia": 2,
"Freight": 46.7700,
"ShipName": "Tradi\u00E7ao Hipermercados",
"ShipAddress": "Av. In\u00EAs de Castro, 414",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05634-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10497,
"CustomerID": "LEHMS",
"EmployeeID": 7,
"OrderDate": "1997-04-04T00:00:00.0000000",
"RequiredDate": "1997-05-02T00:00:00.0000000",
"ShippedDate": "1997-04-07T00:00:00.0000000",
"ShipVia": 1,
"Freight": 36.2100,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10498,
"CustomerID": "HILAA",
"EmployeeID": 8,
"OrderDate": "1997-04-07T00:00:00.0000000",
"RequiredDate": "1997-05-05T00:00:00.0000000",
"ShippedDate": "1997-04-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 29.7500,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10499,
"CustomerID": "LILAS",
"EmployeeID": 4,
"OrderDate": "1997-04-08T00:00:00.0000000",
"RequiredDate": "1997-05-06T00:00:00.0000000",
"ShippedDate": "1997-04-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 102.0200,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10500,
"CustomerID": "LAMAI",
"EmployeeID": 6,
"OrderDate": "1997-04-09T00:00:00.0000000",
"RequiredDate": "1997-05-07T00:00:00.0000000",
"ShippedDate": "1997-04-17T00:00:00.0000000",
"ShipVia": 1,
"Freight": 42.6800,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10501,
"CustomerID": "BLAUS",
"EmployeeID": 9,
"OrderDate": "1997-04-09T00:00:00.0000000",
"RequiredDate": "1997-05-07T00:00:00.0000000",
"ShippedDate": "1997-04-16T00:00:00.0000000",
"ShipVia": 3,
"Freight": 8.8500,
"ShipName": "Blauer See Delikatessen",
"ShipAddress": "Forsterstr. 57",
"ShipCity": "Mannheim",
"ShipRegion": null,
"ShipPostalCode": "68306",
"ShipCountry": "Germany"
},
{
"OrderID": 10502,
"CustomerID": "PERIC",
"EmployeeID": 2,
"OrderDate": "1997-04-10T00:00:00.0000000",
"RequiredDate": "1997-05-08T00:00:00.0000000",
"ShippedDate": "1997-04-29T00:00:00.0000000",
"ShipVia": 1,
"Freight": 69.3200,
"ShipName": "Pericles Comidas cl\u00E1sicas",
"ShipAddress": "Calle Dr. Jorge Cash 321",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10503,
"CustomerID": "HUNGO",
"EmployeeID": 6,
"OrderDate": "1997-04-11T00:00:00.0000000",
"RequiredDate": "1997-05-09T00:00:00.0000000",
"ShippedDate": "1997-04-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 16.7400,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10504,
"CustomerID": "WHITC",
"EmployeeID": 4,
"OrderDate": "1997-04-11T00:00:00.0000000",
"RequiredDate": "1997-05-09T00:00:00.0000000",
"ShippedDate": "1997-04-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 59.1300,
"ShipName": "White Clover Markets",
"ShipAddress": "1029 - 12th Ave. S.",
"ShipCity": "Seattle",
"ShipRegion": "WA",
"ShipPostalCode": "98124",
"ShipCountry": "USA"
},
{
"OrderID": 10505,
"CustomerID": "MEREP",
"EmployeeID": 3,
"OrderDate": "1997-04-14T00:00:00.0000000",
"RequiredDate": "1997-05-12T00:00:00.0000000",
"ShippedDate": "1997-04-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 7.1300,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10506,
"CustomerID": "KOENE",
"EmployeeID": 9,
"OrderDate": "1997-04-15T00:00:00.0000000",
"RequiredDate": "1997-05-13T00:00:00.0000000",
"ShippedDate": "1997-05-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 21.1900,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10507,
"CustomerID": "ANTON",
"EmployeeID": 7,
"OrderDate": "1997-04-15T00:00:00.0000000",
"RequiredDate": "1997-05-13T00:00:00.0000000",
"ShippedDate": "1997-04-22T00:00:00.0000000",
"ShipVia": 1,
"Freight": 47.4500,
"ShipName": "Antonio Moreno Taquer\u00EDa",
"ShipAddress": "Mataderos 2312",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05023",
"ShipCountry": "Mexico"
},
{
"OrderID": 10508,
"CustomerID": "OTTIK",
"EmployeeID": 1,
"OrderDate": "1997-04-16T00:00:00.0000000",
"RequiredDate": "1997-05-14T00:00:00.0000000",
"ShippedDate": "1997-05-13T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.9900,
"ShipName": "Ottilies K\u00E4seladen",
"ShipAddress": "Mehrheimerstr. 369",
"ShipCity": "K\u00F6ln",
"ShipRegion": null,
"ShipPostalCode": "50739",
"ShipCountry": "Germany"
},
{
"OrderID": 10509,
"CustomerID": "BLAUS",
"EmployeeID": 4,
"OrderDate": "1997-04-17T00:00:00.0000000",
"RequiredDate": "1997-05-15T00:00:00.0000000",
"ShippedDate": "1997-04-29T00:00:00.0000000",
"ShipVia": 1,
"Freight": 0.1500,
"ShipName": "Blauer See Delikatessen",
"ShipAddress": "Forsterstr. 57",
"ShipCity": "Mannheim",
"ShipRegion": null,
"ShipPostalCode": "68306",
"ShipCountry": "Germany"
},
{
"OrderID": 10510,
"CustomerID": "SAVEA",
"EmployeeID": 6,
"OrderDate": "1997-04-18T00:00:00.0000000",
"RequiredDate": "1997-05-16T00:00:00.0000000",
"ShippedDate": "1997-04-28T00:00:00.0000000",
"ShipVia": 3,
"Freight": 367.6300,
"ShipName": "Save-a-lot Markets",
"ShipAddress": "187 Suffolk Ln.",
"ShipCity": "Boise",
"ShipRegion": "ID",
"ShipPostalCode": "83720",
"ShipCountry": "USA"
},
{
"OrderID": 10511,
"CustomerID": "BONAP",
"EmployeeID": 4,
"OrderDate": "1997-04-18T00:00:00.0000000",
"RequiredDate": "1997-05-16T00:00:00.0000000",
"ShippedDate": "1997-04-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 350.6400,
"ShipName": "Bon app\u0027",
"ShipAddress": "12, rue des Bouchers",
"ShipCity": "Marseille",
"ShipRegion": null,
"ShipPostalCode": "13008",
"ShipCountry": "France"
},
{
"OrderID": 10512,
"CustomerID": "FAMIA",
"EmployeeID": 7,
"OrderDate": "1997-04-21T00:00:00.0000000",
"RequiredDate": "1997-05-19T00:00:00.0000000",
"ShippedDate": "1997-04-24T00:00:00.0000000",
"ShipVia": 2,
"Freight": 3.5300,
"ShipName": "Familia Arquibaldo",
"ShipAddress": "Rua Or\u00F3s, 92",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05442-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10513,
"CustomerID": "WANDK",
"EmployeeID": 7,
"OrderDate": "1997-04-22T00:00:00.0000000",
"RequiredDate": "1997-06-03T00:00:00.0000000",
"ShippedDate": "1997-04-28T00:00:00.0000000",
"ShipVia": 1,
"Freight": 105.6500,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10514,
"CustomerID": "ERNSH",
"EmployeeID": 3,
"OrderDate": "1997-04-22T00:00:00.0000000",
"RequiredDate": "1997-05-20T00:00:00.0000000",
"ShippedDate": "1997-05-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 789.9500,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10515,
"CustomerID": "QUICK",
"EmployeeID": 2,
"OrderDate": "1997-04-23T00:00:00.0000000",
"RequiredDate": "1997-05-07T00:00:00.0000000",
"ShippedDate": "1997-05-23T00:00:00.0000000",
"ShipVia": 1,
"Freight": 204.4700,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10516,
"CustomerID": "HUNGO",
"EmployeeID": 2,
"OrderDate": "1997-04-24T00:00:00.0000000",
"RequiredDate": "1997-05-22T00:00:00.0000000",
"ShippedDate": "1997-05-01T00:00:00.0000000",
"ShipVia": 3,
"Freight": 62.7800,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10517,
"CustomerID": "NORTS",
"EmployeeID": 3,
"OrderDate": "1997-04-24T00:00:00.0000000",
"RequiredDate": "1997-05-22T00:00:00.0000000",
"ShippedDate": "1997-04-29T00:00:00.0000000",
"ShipVia": 3,
"Freight": 32.0700,
"ShipName": "North/South",
"ShipAddress": "South House 300 Queensbridge",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "SW7 1RZ",
"ShipCountry": "UK"
},
{
"OrderID": 10518,
"CustomerID": "TORTU",
"EmployeeID": 4,
"OrderDate": "1997-04-25T00:00:00.0000000",
"RequiredDate": "1997-05-09T00:00:00.0000000",
"ShippedDate": "1997-05-05T00:00:00.0000000",
"ShipVia": 2,
"Freight": 218.1500,
"ShipName": "Tortuga Restaurante",
"ShipAddress": "Avda. Azteca 123",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10519,
"CustomerID": "CHOPS",
"EmployeeID": 6,
"OrderDate": "1997-04-28T00:00:00.0000000",
"RequiredDate": "1997-05-26T00:00:00.0000000",
"ShippedDate": "1997-05-01T00:00:00.0000000",
"ShipVia": 3,
"Freight": 91.7600,
"ShipName": "Chop-suey Chinese",
"ShipAddress": "Hauptstr. 31",
"ShipCity": "Bern",
"ShipRegion": null,
"ShipPostalCode": "3012",
"ShipCountry": "Switzerland"
},
{
"OrderID": 10520,
"CustomerID": "SANTG",
"EmployeeID": 7,
"OrderDate": "1997-04-29T00:00:00.0000000",
"RequiredDate": "1997-05-27T00:00:00.0000000",
"ShippedDate": "1997-05-01T00:00:00.0000000",
"ShipVia": 1,
"Freight": 13.3700,
"ShipName": "Sant\u00E9 Gourmet",
"ShipAddress": "Erling Skakkes gate 78",
"ShipCity": "Stavern",
"ShipRegion": null,
"ShipPostalCode": "4110",
"ShipCountry": "Norway"
},
{
"OrderID": 10521,
"CustomerID": "CACTU",
"EmployeeID": 8,
"OrderDate": "1997-04-29T00:00:00.0000000",
"RequiredDate": "1997-05-27T00:00:00.0000000",
"ShippedDate": "1997-05-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 17.2200,
"ShipName": "Cactus Comidas para llevar",
"ShipAddress": "Cerrito 333",
"ShipCity": "Buenos Aires",
"ShipRegion": null,
"ShipPostalCode": "1010",
"ShipCountry": "Argentina"
},
{
"OrderID": 10522,
"CustomerID": "LEHMS",
"EmployeeID": 4,
"OrderDate": "1997-04-30T00:00:00.0000000",
"RequiredDate": "1997-05-28T00:00:00.0000000",
"ShippedDate": "1997-05-06T00:00:00.0000000",
"ShipVia": 1,
"Freight": 45.3300,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10523,
"CustomerID": "SEVES",
"EmployeeID": 7,
"OrderDate": "1997-05-01T00:00:00.0000000",
"RequiredDate": "1997-05-29T00:00:00.0000000",
"ShippedDate": "1997-05-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 77.6300,
"ShipName": "Seven Seas Imports",
"ShipAddress": "90 Wadhurst Rd.",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "OX15 4NB",
"ShipCountry": "UK"
},
{
"OrderID": 10524,
"CustomerID": "BERGS",
"EmployeeID": 1,
"OrderDate": "1997-05-01T00:00:00.0000000",
"RequiredDate": "1997-05-29T00:00:00.0000000",
"ShippedDate": "1997-05-07T00:00:00.0000000",
"ShipVia": 2,
"Freight": 244.7900,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10525,
"CustomerID": "BONAP",
"EmployeeID": 1,
"OrderDate": "1997-05-02T00:00:00.0000000",
"RequiredDate": "1997-05-30T00:00:00.0000000",
"ShippedDate": "1997-05-23T00:00:00.0000000",
"ShipVia": 2,
"Freight": 11.0600,
"ShipName": "Bon app\u0027",
"ShipAddress": "12, rue des Bouchers",
"ShipCity": "Marseille",
"ShipRegion": null,
"ShipPostalCode": "13008",
"ShipCountry": "France"
},
{
"OrderID": 10526,
"CustomerID": "WARTH",
"EmployeeID": 4,
"OrderDate": "1997-05-05T00:00:00.0000000",
"RequiredDate": "1997-06-02T00:00:00.0000000",
"ShippedDate": "1997-05-15T00:00:00.0000000",
"ShipVia": 2,
"Freight": 58.5900,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10527,
"CustomerID": "QUICK",
"EmployeeID": 7,
"OrderDate": "1997-05-05T00:00:00.0000000",
"RequiredDate": "1997-06-02T00:00:00.0000000",
"ShippedDate": "1997-05-07T00:00:00.0000000",
"ShipVia": 1,
"Freight": 41.9000,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10528,
"CustomerID": "GREAL",
"EmployeeID": 6,
"OrderDate": "1997-05-06T00:00:00.0000000",
"RequiredDate": "1997-05-20T00:00:00.0000000",
"ShippedDate": "1997-05-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 3.3500,
"ShipName": "Great Lakes Food Market",
"ShipAddress": "2732 Baker Blvd.",
"ShipCity": "Eugene",
"ShipRegion": "OR",
"ShipPostalCode": "97403",
"ShipCountry": "USA"
},
{
"OrderID": 10529,
"CustomerID": "MAISD",
"EmployeeID": 5,
"OrderDate": "1997-05-07T00:00:00.0000000",
"RequiredDate": "1997-06-04T00:00:00.0000000",
"ShippedDate": "1997-05-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 66.6900,
"ShipName": "Maison Dewey",
"ShipAddress": "Rue Joseph-Bens 532",
"ShipCity": "Bruxelles",
"ShipRegion": null,
"ShipPostalCode": "B-1180",
"ShipCountry": "Belgium"
},
{
"OrderID": 10530,
"CustomerID": "PICCO",
"EmployeeID": 3,
"OrderDate": "1997-05-08T00:00:00.0000000",
"RequiredDate": "1997-06-05T00:00:00.0000000",
"ShippedDate": "1997-05-12T00:00:00.0000000",
"ShipVia": 2,
"Freight": 339.2200,
"ShipName": "Piccolo und mehr",
"ShipAddress": "Geislweg 14",
"ShipCity": "Salzburg",
"ShipRegion": null,
"ShipPostalCode": "5020",
"ShipCountry": "Austria"
},
{
"OrderID": 10531,
"CustomerID": "OCEAN",
"EmployeeID": 7,
"OrderDate": "1997-05-08T00:00:00.0000000",
"RequiredDate": "1997-06-05T00:00:00.0000000",
"ShippedDate": "1997-05-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 8.1200,
"ShipName": "Oc\u00E9ano Atl\u00E1ntico Ltda.",
"ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
"ShipCity": "Buenos Aires",
"ShipRegion": null,
"ShipPostalCode": "1010",
"ShipCountry": "Argentina"
},
{
"OrderID": 10532,
"CustomerID": "EASTC",
"EmployeeID": 7,
"OrderDate": "1997-05-09T00:00:00.0000000",
"RequiredDate": "1997-06-06T00:00:00.0000000",
"ShippedDate": "1997-05-12T00:00:00.0000000",
"ShipVia": 3,
"Freight": 74.4600,
"ShipName": "Eastern Connection",
"ShipAddress": "35 King George",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "WX3 6FW",
"ShipCountry": "UK"
},
{
"OrderID": 10533,
"CustomerID": "FOLKO",
"EmployeeID": 8,
"OrderDate": "1997-05-12T00:00:00.0000000",
"RequiredDate": "1997-06-09T00:00:00.0000000",
"ShippedDate": "1997-05-22T00:00:00.0000000",
"ShipVia": 1,
"Freight": 188.0400,
"ShipName": "Folk och f\u00E4 HB",
"ShipAddress": "\u00C5kergatan 24",
"ShipCity": "Br\u00E4cke",
"ShipRegion": null,
"ShipPostalCode": "S-844 67",
"ShipCountry": "Sweden"
},
{
"OrderID": 10534,
"CustomerID": "LEHMS",
"EmployeeID": 8,
"OrderDate": "1997-05-12T00:00:00.0000000",
"RequiredDate": "1997-06-09T00:00:00.0000000",
"ShippedDate": "1997-05-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 27.9400,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10535,
"CustomerID": "ANTON",
"EmployeeID": 4,
"OrderDate": "1997-05-13T00:00:00.0000000",
"RequiredDate": "1997-06-10T00:00:00.0000000",
"ShippedDate": "1997-05-21T00:00:00.0000000",
"ShipVia": 1,
"Freight": 15.6400,
"ShipName": "Antonio Moreno Taquer\u00EDa",
"ShipAddress": "Mataderos 2312",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05023",
"ShipCountry": "Mexico"
},
{
"OrderID": 10536,
"CustomerID": "LEHMS",
"EmployeeID": 3,
"OrderDate": "1997-05-14T00:00:00.0000000",
"RequiredDate": "1997-06-11T00:00:00.0000000",
"ShippedDate": "1997-06-06T00:00:00.0000000",
"ShipVia": 2,
"Freight": 58.8800,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10537,
"CustomerID": "RICSU",
"EmployeeID": 1,
"OrderDate": "1997-05-14T00:00:00.0000000",
"RequiredDate": "1997-05-28T00:00:00.0000000",
"ShippedDate": "1997-05-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 78.8500,
"ShipName": "Richter Supermarkt",
"ShipAddress": "Starenweg 5",
"ShipCity": "Gen\u00E8ve",
"ShipRegion": null,
"ShipPostalCode": "1204",
"ShipCountry": "Switzerland"
},
{
"OrderID": 10538,
"CustomerID": "BSBEV",
"EmployeeID": 9,
"OrderDate": "1997-05-15T00:00:00.0000000",
"RequiredDate": "1997-06-12T00:00:00.0000000",
"ShippedDate": "1997-05-16T00:00:00.0000000",
"ShipVia": 3,
"Freight": 4.8700,
"ShipName": "B\u0027s Beverages",
"ShipAddress": "Fauntleroy Circus",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "EC2 5NT",
"ShipCountry": "UK"
},
{
"OrderID": 10539,
"CustomerID": "BSBEV",
"EmployeeID": 6,
"OrderDate": "1997-05-16T00:00:00.0000000",
"RequiredDate": "1997-06-13T00:00:00.0000000",
"ShippedDate": "1997-05-23T00:00:00.0000000",
"ShipVia": 3,
"Freight": 12.3600,
"ShipName": "B\u0027s Beverages",
"ShipAddress": "Fauntleroy Circus",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "EC2 5NT",
"ShipCountry": "UK"
},
{
"OrderID": 10540,
"CustomerID": "QUICK",
"EmployeeID": 3,
"OrderDate": "1997-05-19T00:00:00.0000000",
"RequiredDate": "1997-06-16T00:00:00.0000000",
"ShippedDate": "1997-06-13T00:00:00.0000000",
"ShipVia": 3,
"Freight": 1007.6400,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10541,
"CustomerID": "HANAR",
"EmployeeID": 2,
"OrderDate": "1997-05-19T00:00:00.0000000",
"RequiredDate": "1997-06-16T00:00:00.0000000",
"ShippedDate": "1997-05-29T00:00:00.0000000",
"ShipVia": 1,
"Freight": 68.6500,
"ShipName": "Hanari Carnes",
"ShipAddress": "Rua do Pa\u00E7o, 67",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "05454-876",
"ShipCountry": "Brazil"
},
{
"OrderID": 10542,
"CustomerID": "KOENE",
"EmployeeID": 1,
"OrderDate": "1997-05-20T00:00:00.0000000",
"RequiredDate": "1997-06-17T00:00:00.0000000",
"ShippedDate": "1997-05-26T00:00:00.0000000",
"ShipVia": 3,
"Freight": 10.9500,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10543,
"CustomerID": "LILAS",
"EmployeeID": 8,
"OrderDate": "1997-05-21T00:00:00.0000000",
"RequiredDate": "1997-06-18T00:00:00.0000000",
"ShippedDate": "1997-05-23T00:00:00.0000000",
"ShipVia": 2,
"Freight": 48.1700,
"ShipName": "LILA-Supermercado",
"ShipAddress": "Carrera 52 con Ave. Bol\u00EDvar #65-98 Llano Largo",
"ShipCity": "Barquisimeto",
"ShipRegion": "Lara",
"ShipPostalCode": "3508",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10544,
"CustomerID": "LONEP",
"EmployeeID": 4,
"OrderDate": "1997-05-21T00:00:00.0000000",
"RequiredDate": "1997-06-18T00:00:00.0000000",
"ShippedDate": "1997-05-30T00:00:00.0000000",
"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": "1997-05-22T00:00:00.0000000",
"RequiredDate": "1997-06-19T00:00:00.0000000",
"ShippedDate": "1997-06-26T00:00:00.0000000",
"ShipVia": 2,
"Freight": 11.9200,
"ShipName": "Lazy K Kountry Store",
"ShipAddress": "12 Orchestra Terrace",
"ShipCity": "Walla Walla",
"ShipRegion": "WA",
"ShipPostalCode": "99362",
"ShipCountry": "USA"
},
{
"OrderID": 10546,
"CustomerID": "VICTE",
"EmployeeID": 1,
"OrderDate": "1997-05-23T00:00:00.0000000",
"RequiredDate": "1997-06-20T00:00:00.0000000",
"ShippedDate": "1997-05-27T00:00:00.0000000",
"ShipVia": 3,
"Freight": 194.7200,
"ShipName": "Victuailles en stock",
"ShipAddress": "2, rue du Commerce",
"ShipCity": "Lyon",
"ShipRegion": null,
"ShipPostalCode": "69004",
"ShipCountry": "France"
},
{
"OrderID": 10547,
"CustomerID": "SEVES",
"EmployeeID": 3,
"OrderDate": "1997-05-23T00:00:00.0000000",
"RequiredDate": "1997-06-20T00:00:00.0000000",
"ShippedDate": "1997-06-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 178.4300,
"ShipName": "Seven Seas Imports",
"ShipAddress": "90 Wadhurst Rd.",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "OX15 4NB",
"ShipCountry": "UK"
},
{
"OrderID": 10548,
"CustomerID": "TOMSP",
"EmployeeID": 3,
"OrderDate": "1997-05-26T00:00:00.0000000",
"RequiredDate": "1997-06-23T00:00:00.0000000",
"ShippedDate": "1997-06-02T00:00:00.0000000",
"ShipVia": 2,
"Freight": 1.4300,
"ShipName": "Toms Spezialit\u00E4ten",
"ShipAddress": "Luisenstr. 48",
"ShipCity": "M\u00FCnster",
"ShipRegion": null,
"ShipPostalCode": "44087",
"ShipCountry": "Germany"
},
{
"OrderID": 10549,
"CustomerID": "QUICK",
"EmployeeID": 5,
"OrderDate": "1997-05-27T00:00:00.0000000",
"RequiredDate": "1997-06-10T00:00:00.0000000",
"ShippedDate": "1997-05-30T00:00:00.0000000",
"ShipVia": 1,
"Freight": 171.2400,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10550,
"CustomerID": "GODOS",
"EmployeeID": 7,
"OrderDate": "1997-05-28T00:00:00.0000000",
"RequiredDate": "1997-06-25T00:00:00.0000000",
"ShippedDate": "1997-06-06T00:00:00.0000000",
"ShipVia": 3,
"Freight": 4.3200,
"ShipName": "Godos Cocina T\u00EDpica",
"ShipAddress": "C/ Romero, 33",
"ShipCity": "Sevilla",
"ShipRegion": null,
"ShipPostalCode": "41101",
"ShipCountry": "Spain"
},
{
"OrderID": 10551,
"CustomerID": "FURIB",
"EmployeeID": 4,
"OrderDate": "1997-05-28T00:00:00.0000000",
"RequiredDate": "1997-07-09T00:00:00.0000000",
"ShippedDate": "1997-06-06T00:00:00.0000000",
"ShipVia": 3,
"Freight": 72.9500,
"ShipName": "Furia Bacalhau e Frutos do Mar",
"ShipAddress": "Jardim das rosas n. 32",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1675",
"ShipCountry": "Portugal"
},
{
"OrderID": 10552,
"CustomerID": "HILAA",
"EmployeeID": 2,
"OrderDate": "1997-05-29T00:00:00.0000000",
"RequiredDate": "1997-06-26T00:00:00.0000000",
"ShippedDate": "1997-06-05T00:00:00.0000000",
"ShipVia": 1,
"Freight": 83.2200,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10553,
"CustomerID": "WARTH",
"EmployeeID": 2,
"OrderDate": "1997-05-30T00:00:00.0000000",
"RequiredDate": "1997-06-27T00:00:00.0000000",
"ShippedDate": "1997-06-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 149.4900,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10554,
"CustomerID": "OTTIK",
"EmployeeID": 4,
"OrderDate": "1997-05-30T00:00:00.0000000",
"RequiredDate": "1997-06-27T00:00:00.0000000",
"ShippedDate": "1997-06-05T00:00:00.0000000",
"ShipVia": 3,
"Freight": 120.9700,
"ShipName": "Ottilies K\u00E4seladen",
"ShipAddress": "Mehrheimerstr. 369",
"ShipCity": "K\u00F6ln",
"ShipRegion": null,
"ShipPostalCode": "50739",
"ShipCountry": "Germany"
},
{
"OrderID": 10555,
"CustomerID": "SAVEA",
"EmployeeID": 6,
"OrderDate": "1997-06-02T00:00:00.0000000",
"RequiredDate": "1997-06-30T00:00:00.0000000",
"ShippedDate": "1997-06-04T00:00:00.0000000",
"ShipVia": 3,
"Freight": 252.4900,
"ShipName": "Save-a-lot Markets",
"ShipAddress": "187 Suffolk Ln.",
"ShipCity": "Boise",
"ShipRegion": "ID",
"ShipPostalCode": "83720",
"ShipCountry": "USA"
},
{
"OrderID": 10556,
"CustomerID": "SIMOB",
"EmployeeID": 2,
"OrderDate": "1997-06-03T00:00:00.0000000",
"RequiredDate": "1997-07-15T00:00:00.0000000",
"ShippedDate": "1997-06-13T00:00:00.0000000",
"ShipVia": 1,
"Freight": 9.8000,
"ShipName": "Simons bistro",
"ShipAddress": "Vinb\u00E6ltet 34",
"ShipCity": "Kobenhavn",
"ShipRegion": null,
"ShipPostalCode": "1734",
"ShipCountry": "Denmark"
},
{
"OrderID": 10557,
"CustomerID": "LEHMS",
"EmployeeID": 9,
"OrderDate": "1997-06-03T00:00:00.0000000",
"RequiredDate": "1997-06-17T00:00:00.0000000",
"ShippedDate": "1997-06-06T00:00:00.0000000",
"ShipVia": 2,
"Freight": 96.7200,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10558,
"CustomerID": "AROUT",
"EmployeeID": 1,
"OrderDate": "1997-06-04T00:00:00.0000000",
"RequiredDate": "1997-07-02T00:00:00.0000000",
"ShippedDate": "1997-06-10T00:00:00.0000000",
"ShipVia": 2,
"Freight": 72.9700,
"ShipName": "Around the Horn",
"ShipAddress": "Brook Farm Stratford St. Mary",
"ShipCity": "Colchester",
"ShipRegion": "Essex",
"ShipPostalCode": "CO7 6JX",
"ShipCountry": "UK"
},
{
"OrderID": 10559,
"CustomerID": "BLONP",
"EmployeeID": 6,
"OrderDate": "1997-06-05T00:00:00.0000000",
"RequiredDate": "1997-07-03T00:00:00.0000000",
"ShippedDate": "1997-06-13T00:00:00.0000000",
"ShipVia": 1,
"Freight": 8.0500,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10560,
"CustomerID": "FRANK",
"EmployeeID": 8,
"OrderDate": "1997-06-06T00:00:00.0000000",
"RequiredDate": "1997-07-04T00:00:00.0000000",
"ShippedDate": "1997-06-09T00:00:00.0000000",
"ShipVia": 1,
"Freight": 36.6500,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10561,
"CustomerID": "FOLKO",
"EmployeeID": 2,
"OrderDate": "1997-06-06T00:00:00.0000000",
"RequiredDate": "1997-07-04T00:00:00.0000000",
"ShippedDate": "1997-06-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 242.2100,
"ShipName": "Folk och f\u00E4 HB",
"ShipAddress": "\u00C5kergatan 24",
"ShipCity": "Br\u00E4cke",
"ShipRegion": null,
"ShipPostalCode": "S-844 67",
"ShipCountry": "Sweden"
},
{
"OrderID": 10562,
"CustomerID": "REGGC",
"EmployeeID": 1,
"OrderDate": "1997-06-09T00:00:00.0000000",
"RequiredDate": "1997-07-07T00:00:00.0000000",
"ShippedDate": "1997-06-12T00:00:00.0000000",
"ShipVia": 1,
"Freight": 22.9500,
"ShipName": "Reggiani Caseifici",
"ShipAddress": "Strada Provinciale 124",
"ShipCity": "Reggio Emilia",
"ShipRegion": null,
"ShipPostalCode": "42100",
"ShipCountry": "Italy"
},
{
"OrderID": 10563,
"CustomerID": "RICAR",
"EmployeeID": 2,
"OrderDate": "1997-06-10T00:00:00.0000000",
"RequiredDate": "1997-07-22T00:00:00.0000000",
"ShippedDate": "1997-06-24T00:00:00.0000000",
"ShipVia": 2,
"Freight": 60.4300,
"ShipName": "Ricardo Adocicados",
"ShipAddress": "Av. Copacabana, 267",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-890",
"ShipCountry": "Brazil"
},
{
"OrderID": 10564,
"CustomerID": "RATTC",
"EmployeeID": 4,
"OrderDate": "1997-06-10T00:00:00.0000000",
"RequiredDate": "1997-07-08T00:00:00.0000000",
"ShippedDate": "1997-06-16T00:00:00.0000000",
"ShipVia": 3,
"Freight": 13.7500,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10565,
"CustomerID": "MEREP",
"EmployeeID": 8,
"OrderDate": "1997-06-11T00:00:00.0000000",
"RequiredDate": "1997-07-09T00:00:00.0000000",
"ShippedDate": "1997-06-18T00:00:00.0000000",
"ShipVia": 2,
"Freight": 7.1500,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10566,
"CustomerID": "BLONP",
"EmployeeID": 9,
"OrderDate": "1997-06-12T00:00:00.0000000",
"RequiredDate": "1997-07-10T00:00:00.0000000",
"ShippedDate": "1997-06-18T00:00:00.0000000",
"ShipVia": 1,
"Freight": 88.4000,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10567,
"CustomerID": "HUNGO",
"EmployeeID": 1,
"OrderDate": "1997-06-12T00:00:00.0000000",
"RequiredDate": "1997-07-10T00:00:00.0000000",
"ShippedDate": "1997-06-17T00:00:00.0000000",
"ShipVia": 1,
"Freight": 33.9700,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10568,
"CustomerID": "GALED",
"EmployeeID": 3,
"OrderDate": "1997-06-13T00:00:00.0000000",
"RequiredDate": "1997-07-11T00:00:00.0000000",
"ShippedDate": "1997-07-09T00:00:00.0000000",
"ShipVia": 3,
"Freight": 6.5400,
"ShipName": "Galer\u00EDa del gastron\u00F3mo",
"ShipAddress": "Rambla de Catalu\u00F1a, 23",
"ShipCity": "Barcelona",
"ShipRegion": null,
"ShipPostalCode": "8022",
"ShipCountry": "Spain"
},
{
"OrderID": 10569,
"CustomerID": "RATTC",
"EmployeeID": 5,
"OrderDate": "1997-06-16T00:00:00.0000000",
"RequiredDate": "1997-07-14T00:00:00.0000000",
"ShippedDate": "1997-07-11T00:00:00.0000000",
"ShipVia": 1,
"Freight": 58.9800,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10570,
"CustomerID": "MEREP",
"EmployeeID": 3,
"OrderDate": "1997-06-17T00:00:00.0000000",
"RequiredDate": "1997-07-15T00:00:00.0000000",
"ShippedDate": "1997-06-19T00:00:00.0000000",
"ShipVia": 3,
"Freight": 188.9900,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10571,
"CustomerID": "ERNSH",
"EmployeeID": 8,
"OrderDate": "1997-06-17T00:00:00.0000000",
"RequiredDate": "1997-07-29T00:00:00.0000000",
"ShippedDate": "1997-07-04T00:00:00.0000000",
"ShipVia": 3,
"Freight": 26.0600,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10572,
"CustomerID": "BERGS",
"EmployeeID": 3,
"OrderDate": "1997-06-18T00:00:00.0000000",
"RequiredDate": "1997-07-16T00:00:00.0000000",
"ShippedDate": "1997-06-25T00:00:00.0000000",
"ShipVia": 2,
"Freight": 116.4300,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10573,
"CustomerID": "ANTON",
"EmployeeID": 7,
"OrderDate": "1997-06-19T00:00:00.0000000",
"RequiredDate": "1997-07-17T00:00:00.0000000",
"ShippedDate": "1997-06-20T00:00:00.0000000",
"ShipVia": 3,
"Freight": 84.8400,
"ShipName": "Antonio Moreno Taquer\u00EDa",
"ShipAddress": "Mataderos 2312",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05023",
"ShipCountry": "Mexico"
},
{
"OrderID": 10574,
"CustomerID": "TRAIH",
"EmployeeID": 4,
"OrderDate": "1997-06-19T00:00:00.0000000",
"RequiredDate": "1997-07-17T00:00:00.0000000",
"ShippedDate": "1997-06-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 37.6000,
"ShipName": "Trail\u0027s Head Gourmet Provisioners",
"ShipAddress": "722 DaVinci Blvd.",
"ShipCity": "Kirkland",
"ShipRegion": "WA",
"ShipPostalCode": "98034",
"ShipCountry": "USA"
},
{
"OrderID": 10575,
"CustomerID": "MORGK",
"EmployeeID": 5,
"OrderDate": "1997-06-20T00:00:00.0000000",
"RequiredDate": "1997-07-04T00:00:00.0000000",
"ShippedDate": "1997-06-30T00:00:00.0000000",
"ShipVia": 1,
"Freight": 127.3400,
"ShipName": "Morgenstern Gesundkost",
"ShipAddress": "Heerstr. 22",
"ShipCity": "Leipzig",
"ShipRegion": null,
"ShipPostalCode": "04179",
"ShipCountry": "Germany"
},
{
"OrderID": 10576,
"CustomerID": "TORTU",
"EmployeeID": 3,
"OrderDate": "1997-06-23T00:00:00.0000000",
"RequiredDate": "1997-07-07T00:00:00.0000000",
"ShippedDate": "1997-06-30T00:00:00.0000000",
"ShipVia": 3,
"Freight": 18.5600,
"ShipName": "Tortuga Restaurante",
"ShipAddress": "Avda. Azteca 123",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
},
{
"OrderID": 10577,
"CustomerID": "TRAIH",
"EmployeeID": 9,
"OrderDate": "1997-06-23T00:00:00.0000000",
"RequiredDate": "1997-08-04T00:00:00.0000000",
"ShippedDate": "1997-06-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 25.4100,
"ShipName": "Trail\u0027s Head Gourmet Provisioners",
"ShipAddress": "722 DaVinci Blvd.",
"ShipCity": "Kirkland",
"ShipRegion": "WA",
"ShipPostalCode": "98034",
"ShipCountry": "USA"
},
{
"OrderID": 10578,
"CustomerID": "BSBEV",
"EmployeeID": 4,
"OrderDate": "1997-06-24T00:00:00.0000000",
"RequiredDate": "1997-07-22T00:00:00.0000000",
"ShippedDate": "1997-07-25T00:00:00.0000000",
"ShipVia": 3,
"Freight": 29.6000,
"ShipName": "B\u0027s Beverages",
"ShipAddress": "Fauntleroy Circus",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "EC2 5NT",
"ShipCountry": "UK"
},
{
"OrderID": 10579,
"CustomerID": "LETSS",
"EmployeeID": 1,
"OrderDate": "1997-06-25T00:00:00.0000000",
"RequiredDate": "1997-07-23T00:00:00.0000000",
"ShippedDate": "1997-07-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 13.7300,
"ShipName": "Let\u0027s Stop N Shop",
"ShipAddress": "87 Polk St. Suite 5",
"ShipCity": "San Francisco",
"ShipRegion": "CA",
"ShipPostalCode": "94117",
"ShipCountry": "USA"
},
{
"OrderID": 10580,
"CustomerID": "OTTIK",
"EmployeeID": 4,
"OrderDate": "1997-06-26T00:00:00.0000000",
"RequiredDate": "1997-07-24T00:00:00.0000000",
"ShippedDate": "1997-07-01T00:00:00.0000000",
"ShipVia": 3,
"Freight": 75.8900,
"ShipName": "Ottilies K\u00E4seladen",
"ShipAddress": "Mehrheimerstr. 369",
"ShipCity": "K\u00F6ln",
"ShipRegion": null,
"ShipPostalCode": "50739",
"ShipCountry": "Germany"
},
{
"OrderID": 10581,
"CustomerID": "FAMIA",
"EmployeeID": 3,
"OrderDate": "1997-06-26T00:00:00.0000000",
"RequiredDate": "1997-07-24T00:00:00.0000000",
"ShippedDate": "1997-07-02T00:00:00.0000000",
"ShipVia": 1,
"Freight": 3.0100,
"ShipName": "Familia Arquibaldo",
"ShipAddress": "Rua Or\u00F3s, 92",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05442-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10582,
"CustomerID": "BLAUS",
"EmployeeID": 3,
"OrderDate": "1997-06-27T00:00:00.0000000",
"RequiredDate": "1997-07-25T00:00:00.0000000",
"ShippedDate": "1997-07-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 27.7100,
"ShipName": "Blauer See Delikatessen",
"ShipAddress": "Forsterstr. 57",
"ShipCity": "Mannheim",
"ShipRegion": null,
"ShipPostalCode": "68306",
"ShipCountry": "Germany"
},
{
"OrderID": 10583,
"CustomerID": "WARTH",
"EmployeeID": 2,
"OrderDate": "1997-06-30T00:00:00.0000000",
"RequiredDate": "1997-07-28T00:00:00.0000000",
"ShippedDate": "1997-07-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 7.2800,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10584,
"CustomerID": "BLONP",
"EmployeeID": 4,
"OrderDate": "1997-06-30T00:00:00.0000000",
"RequiredDate": "1997-07-28T00:00:00.0000000",
"ShippedDate": "1997-07-04T00:00:00.0000000",
"ShipVia": 1,
"Freight": 59.1400,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10585,
"CustomerID": "WELLI",
"EmployeeID": 7,
"OrderDate": "1997-07-01T00:00:00.0000000",
"RequiredDate": "1997-07-29T00:00:00.0000000",
"ShippedDate": "1997-07-10T00:00:00.0000000",
"ShipVia": 1,
"Freight": 13.4100,
"ShipName": "Wellington Importadora",
"ShipAddress": "Rua do Mercado, 12",
"ShipCity": "Resende",
"ShipRegion": "SP",
"ShipPostalCode": "08737-363",
"ShipCountry": "Brazil"
},
{
"OrderID": 10586,
"CustomerID": "REGGC",
"EmployeeID": 9,
"OrderDate": "1997-07-02T00:00:00.0000000",
"RequiredDate": "1997-07-30T00:00:00.0000000",
"ShippedDate": "1997-07-09T00:00:00.0000000",
"ShipVia": 1,
"Freight": 0.4800,
"ShipName": "Reggiani Caseifici",
"ShipAddress": "Strada Provinciale 124",
"ShipCity": "Reggio Emilia",
"ShipRegion": null,
"ShipPostalCode": "42100",
"ShipCountry": "Italy"
},
{
"OrderID": 10587,
"CustomerID": "QUEDE",
"EmployeeID": 1,
"OrderDate": "1997-07-02T00:00:00.0000000",
"RequiredDate": "1997-07-30T00:00:00.0000000",
"ShippedDate": "1997-07-09T00:00:00.0000000",
"ShipVia": 1,
"Freight": 62.5200,
"ShipName": "Que Del\u00EDcia",
"ShipAddress": "Rua da Panificadora, 12",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-673",
"ShipCountry": "Brazil"
},
{
"OrderID": 10588,
"CustomerID": "QUICK",
"EmployeeID": 2,
"OrderDate": "1997-07-03T00:00:00.0000000",
"RequiredDate": "1997-07-31T00:00:00.0000000",
"ShippedDate": "1997-07-10T00:00:00.0000000",
"ShipVia": 3,
"Freight": 194.6700,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10589,
"CustomerID": "GREAL",
"EmployeeID": 8,
"OrderDate": "1997-07-04T00:00:00.0000000",
"RequiredDate": "1997-08-01T00:00:00.0000000",
"ShippedDate": "1997-07-14T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.4200,
"ShipName": "Great Lakes Food Market",
"ShipAddress": "2732 Baker Blvd.",
"ShipCity": "Eugene",
"ShipRegion": "OR",
"ShipPostalCode": "97403",
"ShipCountry": "USA"
},
{
"OrderID": 10590,
"CustomerID": "MEREP",
"EmployeeID": 4,
"OrderDate": "1997-07-07T00:00:00.0000000",
"RequiredDate": "1997-08-04T00:00:00.0000000",
"ShippedDate": "1997-07-14T00:00:00.0000000",
"ShipVia": 3,
"Freight": 44.7700,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10591,
"CustomerID": "VAFFE",
"EmployeeID": 1,
"OrderDate": "1997-07-07T00:00:00.0000000",
"RequiredDate": "1997-07-21T00:00:00.0000000",
"ShippedDate": "1997-07-16T00:00:00.0000000",
"ShipVia": 1,
"Freight": 55.9200,
"ShipName": "Vaffeljernet",
"ShipAddress": "Smagsloget 45",
"ShipCity": "\u00C5rhus",
"ShipRegion": null,
"ShipPostalCode": "8200",
"ShipCountry": "Denmark"
},
{
"OrderID": 10592,
"CustomerID": "LEHMS",
"EmployeeID": 3,
"OrderDate": "1997-07-08T00:00:00.0000000",
"RequiredDate": "1997-08-05T00:00:00.0000000",
"ShippedDate": "1997-07-16T00:00:00.0000000",
"ShipVia": 1,
"Freight": 32.1000,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10593,
"CustomerID": "LEHMS",
"EmployeeID": 7,
"OrderDate": "1997-07-09T00:00:00.0000000",
"RequiredDate": "1997-08-06T00:00:00.0000000",
"ShippedDate": "1997-08-13T00:00:00.0000000",
"ShipVia": 2,
"Freight": 174.2000,
"ShipName": "Lehmanns Marktstand",
"ShipAddress": "Magazinweg 7",
"ShipCity": "Frankfurt a.M.",
"ShipRegion": null,
"ShipPostalCode": "60528",
"ShipCountry": "Germany"
},
{
"OrderID": 10594,
"CustomerID": "OLDWO",
"EmployeeID": 3,
"OrderDate": "1997-07-09T00:00:00.0000000",
"RequiredDate": "1997-08-06T00:00:00.0000000",
"ShippedDate": "1997-07-16T00:00:00.0000000",
"ShipVia": 2,
"Freight": 5.2400,
"ShipName": "Old World Delicatessen",
"ShipAddress": "2743 Bering St.",
"ShipCity": "Anchorage",
"ShipRegion": "AK",
"ShipPostalCode": "99508",
"ShipCountry": "USA"
},
{
"OrderID": 10595,
"CustomerID": "ERNSH",
"EmployeeID": 2,
"OrderDate": "1997-07-10T00:00:00.0000000",
"RequiredDate": "1997-08-07T00:00:00.0000000",
"ShippedDate": "1997-07-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 96.7800,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10596,
"CustomerID": "WHITC",
"EmployeeID": 8,
"OrderDate": "1997-07-11T00:00:00.0000000",
"RequiredDate": "1997-08-08T00:00:00.0000000",
"ShippedDate": "1997-08-12T00:00:00.0000000",
"ShipVia": 1,
"Freight": 16.3400,
"ShipName": "White Clover Markets",
"ShipAddress": "1029 - 12th Ave. S.",
"ShipCity": "Seattle",
"ShipRegion": "WA",
"ShipPostalCode": "98124",
"ShipCountry": "USA"
},
{
"OrderID": 10597,
"CustomerID": "PICCO",
"EmployeeID": 7,
"OrderDate": "1997-07-11T00:00:00.0000000",
"RequiredDate": "1997-08-08T00:00:00.0000000",
"ShippedDate": "1997-07-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 35.1200,
"ShipName": "Piccolo und mehr",
"ShipAddress": "Geislweg 14",
"ShipCity": "Salzburg",
"ShipRegion": null,
"ShipPostalCode": "5020",
"ShipCountry": "Austria"
},
{
"OrderID": 10598,
"CustomerID": "RATTC",
"EmployeeID": 1,
"OrderDate": "1997-07-14T00:00:00.0000000",
"RequiredDate": "1997-08-11T00:00:00.0000000",
"ShippedDate": "1997-07-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 44.4200,
"ShipName": "Rattlesnake Canyon Grocery",
"ShipAddress": "2817 Milton Dr.",
"ShipCity": "Albuquerque",
"ShipRegion": "NM",
"ShipPostalCode": "87110",
"ShipCountry": "USA"
},
{
"OrderID": 10599,
"CustomerID": "BSBEV",
"EmployeeID": 6,
"OrderDate": "1997-07-15T00:00:00.0000000",
"RequiredDate": "1997-08-26T00:00:00.0000000",
"ShippedDate": "1997-07-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 29.9800,
"ShipName": "B\u0027s Beverages",
"ShipAddress": "Fauntleroy Circus",
"ShipCity": "London",
"ShipRegion": null,
"ShipPostalCode": "EC2 5NT",
"ShipCountry": "UK"
},
{
"OrderID": 10600,
"CustomerID": "HUNGC",
"EmployeeID": 4,
"OrderDate": "1997-07-16T00:00:00.0000000",
"RequiredDate": "1997-08-13T00:00:00.0000000",
"ShippedDate": "1997-07-21T00:00:00.0000000",
"ShipVia": 1,
"Freight": 45.1300,
"ShipName": "Hungry Coyote Import Store",
"ShipAddress": "City Center Plaza 516 Main St.",
"ShipCity": "Elgin",
"ShipRegion": "OR",
"ShipPostalCode": "97827",
"ShipCountry": "USA"
},
{
"OrderID": 10601,
"CustomerID": "HILAA",
"EmployeeID": 7,
"OrderDate": "1997-07-16T00:00:00.0000000",
"RequiredDate": "1997-08-27T00:00:00.0000000",
"ShippedDate": "1997-07-22T00:00:00.0000000",
"ShipVia": 1,
"Freight": 58.3000,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10602,
"CustomerID": "VAFFE",
"EmployeeID": 8,
"OrderDate": "1997-07-17T00:00:00.0000000",
"RequiredDate": "1997-08-14T00:00:00.0000000",
"ShippedDate": "1997-07-22T00:00:00.0000000",
"ShipVia": 2,
"Freight": 2.9200,
"ShipName": "Vaffeljernet",
"ShipAddress": "Smagsloget 45",
"ShipCity": "\u00C5rhus",
"ShipRegion": null,
"ShipPostalCode": "8200",
"ShipCountry": "Denmark"
},
{
"OrderID": 10603,
"CustomerID": "SAVEA",
"EmployeeID": 8,
"OrderDate": "1997-07-18T00:00:00.0000000",
"RequiredDate": "1997-08-15T00:00:00.0000000",
"ShippedDate": "1997-08-08T00:00:00.0000000",
"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": "1997-07-18T00:00:00.0000000",
"RequiredDate": "1997-08-15T00:00:00.0000000",
"ShippedDate": "1997-07-29T00:00:00.0000000",
"ShipVia": 1,
"Freight": 7.4600,
"ShipName": "Furia Bacalhau e Frutos do Mar",
"ShipAddress": "Jardim das rosas n. 32",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1675",
"ShipCountry": "Portugal"
},
{
"OrderID": 10605,
"CustomerID": "MEREP",
"EmployeeID": 1,
"OrderDate": "1997-07-21T00:00:00.0000000",
"RequiredDate": "1997-08-18T00:00:00.0000000",
"ShippedDate": "1997-07-29T00:00:00.0000000",
"ShipVia": 2,
"Freight": 379.1300,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10606,
"CustomerID": "TRADH",
"EmployeeID": 4,
"OrderDate": "1997-07-22T00:00:00.0000000",
"RequiredDate": "1997-08-19T00:00:00.0000000",
"ShippedDate": "1997-07-31T00:00:00.0000000",
"ShipVia": 3,
"Freight": 79.4000,
"ShipName": "Tradi\u00E7ao Hipermercados",
"ShipAddress": "Av. In\u00EAs de Castro, 414",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05634-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10607,
"CustomerID": "SAVEA",
"EmployeeID": 5,
"OrderDate": "1997-07-22T00:00:00.0000000",
"RequiredDate": "1997-08-19T00:00:00.0000000",
"ShippedDate": "1997-07-25T00:00:00.0000000",
"ShipVia": 1,
"Freight": 200.2400,
"ShipName": "Save-a-lot Markets",
"ShipAddress": "187 Suffolk Ln.",
"ShipCity": "Boise",
"ShipRegion": "ID",
"ShipPostalCode": "83720",
"ShipCountry": "USA"
},
{
"OrderID": 10608,
"CustomerID": "TOMSP",
"EmployeeID": 4,
"OrderDate": "1997-07-23T00:00:00.0000000",
"RequiredDate": "1997-08-20T00:00:00.0000000",
"ShippedDate": "1997-08-01T00:00:00.0000000",
"ShipVia": 2,
"Freight": 27.7900,
"ShipName": "Toms Spezialit\u00E4ten",
"ShipAddress": "Luisenstr. 48",
"ShipCity": "M\u00FCnster",
"ShipRegion": null,
"ShipPostalCode": "44087",
"ShipCountry": "Germany"
},
{
"OrderID": 10609,
"CustomerID": "DUMON",
"EmployeeID": 7,
"OrderDate": "1997-07-24T00:00:00.0000000",
"RequiredDate": "1997-08-21T00:00:00.0000000",
"ShippedDate": "1997-07-30T00:00:00.0000000",
"ShipVia": 2,
"Freight": 1.8500,
"ShipName": "Du monde entier",
"ShipAddress": "67, rue des Cinquante Otages",
"ShipCity": "Nantes",
"ShipRegion": null,
"ShipPostalCode": "44000",
"ShipCountry": "France"
},
{
"OrderID": 10610,
"CustomerID": "LAMAI",
"EmployeeID": 8,
"OrderDate": "1997-07-25T00:00:00.0000000",
"RequiredDate": "1997-08-22T00:00:00.0000000",
"ShippedDate": "1997-08-06T00:00:00.0000000",
"ShipVia": 1,
"Freight": 26.7800,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10611,
"CustomerID": "WOLZA",
"EmployeeID": 6,
"OrderDate": "1997-07-25T00:00:00.0000000",
"RequiredDate": "1997-08-22T00:00:00.0000000",
"ShippedDate": "1997-08-01T00:00:00.0000000",
"ShipVia": 2,
"Freight": 80.6500,
"ShipName": "Wolski Zajazd",
"ShipAddress": "ul. Filtrowa 68",
"ShipCity": "Warszawa",
"ShipRegion": null,
"ShipPostalCode": "01-012",
"ShipCountry": "Poland"
},
{
"OrderID": 10612,
"CustomerID": "SAVEA",
"EmployeeID": 1,
"OrderDate": "1997-07-28T00:00:00.0000000",
"RequiredDate": "1997-08-25T00:00:00.0000000",
"ShippedDate": "1997-08-01T00:00:00.0000000",
"ShipVia": 2,
"Freight": 544.0800,
"ShipName": "Save-a-lot Markets",
"ShipAddress": "187 Suffolk Ln.",
"ShipCity": "Boise",
"ShipRegion": "ID",
"ShipPostalCode": "83720",
"ShipCountry": "USA"
},
{
"OrderID": 10613,
"CustomerID": "HILAA",
"EmployeeID": 4,
"OrderDate": "1997-07-29T00:00:00.0000000",
"RequiredDate": "1997-08-26T00:00:00.0000000",
"ShippedDate": "1997-08-01T00:00:00.0000000",
"ShipVia": 2,
"Freight": 8.1100,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10614,
"CustomerID": "BLAUS",
"EmployeeID": 8,
"OrderDate": "1997-07-29T00:00:00.0000000",
"RequiredDate": "1997-08-26T00:00:00.0000000",
"ShippedDate": "1997-08-01T00:00:00.0000000",
"ShipVia": 3,
"Freight": 1.9300,
"ShipName": "Blauer See Delikatessen",
"ShipAddress": "Forsterstr. 57",
"ShipCity": "Mannheim",
"ShipRegion": null,
"ShipPostalCode": "68306",
"ShipCountry": "Germany"
},
{
"OrderID": 10615,
"CustomerID": "WILMK",
"EmployeeID": 2,
"OrderDate": "1997-07-30T00:00:00.0000000",
"RequiredDate": "1997-08-27T00:00:00.0000000",
"ShippedDate": "1997-08-06T00:00:00.0000000",
"ShipVia": 3,
"Freight": 0.7500,
"ShipName": "Wilman Kala",
"ShipAddress": "Keskuskatu 45",
"ShipCity": "Helsinki",
"ShipRegion": null,
"ShipPostalCode": "21240",
"ShipCountry": "Finland"
},
{
"OrderID": 10616,
"CustomerID": "GREAL",
"EmployeeID": 1,
"OrderDate": "1997-07-31T00:00:00.0000000",
"RequiredDate": "1997-08-28T00:00:00.0000000",
"ShippedDate": "1997-08-05T00:00:00.0000000",
"ShipVia": 2,
"Freight": 116.5300,
"ShipName": "Great Lakes Food Market",
"ShipAddress": "2732 Baker Blvd.",
"ShipCity": "Eugene",
"ShipRegion": "OR",
"ShipPostalCode": "97403",
"ShipCountry": "USA"
},
{
"OrderID": 10617,
"CustomerID": "GREAL",
"EmployeeID": 4,
"OrderDate": "1997-07-31T00:00:00.0000000",
"RequiredDate": "1997-08-28T00:00:00.0000000",
"ShippedDate": "1997-08-04T00:00:00.0000000",
"ShipVia": 2,
"Freight": 18.5300,
"ShipName": "Great Lakes Food Market",
"ShipAddress": "2732 Baker Blvd.",
"ShipCity": "Eugene",
"ShipRegion": "OR",
"ShipPostalCode": "97403",
"ShipCountry": "USA"
},
{
"OrderID": 10618,
"CustomerID": "MEREP",
"EmployeeID": 1,
"OrderDate": "1997-08-01T00:00:00.0000000",
"RequiredDate": "1997-09-12T00:00:00.0000000",
"ShippedDate": "1997-08-08T00:00:00.0000000",
"ShipVia": 1,
"Freight": 154.6800,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10619,
"CustomerID": "MEREP",
"EmployeeID": 3,
"OrderDate": "1997-08-04T00:00:00.0000000",
"RequiredDate": "1997-09-01T00:00:00.0000000",
"ShippedDate": "1997-08-07T00:00:00.0000000",
"ShipVia": 3,
"Freight": 91.0500,
"ShipName": "M\u00E8re Paillarde",
"ShipAddress": "43 rue St. Laurent",
"ShipCity": "Montr\u00E9al",
"ShipRegion": "Qu\u00E9bec",
"ShipPostalCode": "H1J 1C3",
"ShipCountry": "Canada"
},
{
"OrderID": 10620,
"CustomerID": "LAUGB",
"EmployeeID": 2,
"OrderDate": "1997-08-05T00:00:00.0000000",
"RequiredDate": "1997-09-02T00:00:00.0000000",
"ShippedDate": "1997-08-14T00:00:00.0000000",
"ShipVia": 3,
"Freight": 0.9400,
"ShipName": "Laughing Bacchus Wine Cellars",
"ShipAddress": "2319 Elm St.",
"ShipCity": "Vancouver",
"ShipRegion": "BC",
"ShipPostalCode": "V3F 2K1",
"ShipCountry": "Canada"
},
{
"OrderID": 10621,
"CustomerID": "ISLAT",
"EmployeeID": 4,
"OrderDate": "1997-08-05T00:00:00.0000000",
"RequiredDate": "1997-09-02T00:00:00.0000000",
"ShippedDate": "1997-08-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 23.7300,
"ShipName": "Island Trading",
"ShipAddress": "Garden House Crowther Way",
"ShipCity": "Cowes",
"ShipRegion": "Isle of Wight",
"ShipPostalCode": "PO31 7PJ",
"ShipCountry": "UK"
},
{
"OrderID": 10622,
"CustomerID": "RICAR",
"EmployeeID": 4,
"OrderDate": "1997-08-06T00:00:00.0000000",
"RequiredDate": "1997-09-03T00:00:00.0000000",
"ShippedDate": "1997-08-11T00:00:00.0000000",
"ShipVia": 3,
"Freight": 50.9700,
"ShipName": "Ricardo Adocicados",
"ShipAddress": "Av. Copacabana, 267",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-890",
"ShipCountry": "Brazil"
},
{
"OrderID": 10623,
"CustomerID": "FRANK",
"EmployeeID": 8,
"OrderDate": "1997-08-07T00:00:00.0000000",
"RequiredDate": "1997-09-04T00:00:00.0000000",
"ShippedDate": "1997-08-12T00:00:00.0000000",
"ShipVia": 2,
"Freight": 97.1800,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10624,
"CustomerID": "THECR",
"EmployeeID": 4,
"OrderDate": "1997-08-07T00:00:00.0000000",
"RequiredDate": "1997-09-04T00:00:00.0000000",
"ShippedDate": "1997-08-19T00:00:00.0000000",
"ShipVia": 2,
"Freight": 94.8000,
"ShipName": "The Cracker Box",
"ShipAddress": "55 Grizzly Peak Rd.",
"ShipCity": "Butte",
"ShipRegion": "MT",
"ShipPostalCode": "59801",
"ShipCountry": "USA"
},
{
"OrderID": 10625,
"CustomerID": "ANATR",
"EmployeeID": 3,
"OrderDate": "1997-08-08T00:00:00.0000000",
"RequiredDate": "1997-09-05T00:00:00.0000000",
"ShippedDate": "1997-08-14T00:00:00.0000000",
"ShipVia": 1,
"Freight": 43.9000,
"ShipName": "Ana Trujillo Emparedados y helados",
"ShipAddress": "Avda. de la Constituci\u00F3n 2222",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05021",
"ShipCountry": "Mexico"
},
{
"OrderID": 10626,
"CustomerID": "BERGS",
"EmployeeID": 1,
"OrderDate": "1997-08-11T00:00:00.0000000",
"RequiredDate": "1997-09-08T00:00:00.0000000",
"ShippedDate": "1997-08-20T00:00:00.0000000",
"ShipVia": 2,
"Freight": 138.6900,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10627,
"CustomerID": "SAVEA",
"EmployeeID": 8,
"OrderDate": "1997-08-11T00:00:00.0000000",
"RequiredDate": "1997-09-22T00:00:00.0000000",
"ShippedDate": "1997-08-21T00:00:00.0000000",
"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": "1997-08-12T00:00:00.0000000",
"RequiredDate": "1997-09-09T00:00:00.0000000",
"ShippedDate": "1997-08-20T00:00:00.0000000",
"ShipVia": 3,
"Freight": 30.3600,
"ShipName": "Blondel p\u00E8re et fils",
"ShipAddress": "24, place Kl\u00E9ber",
"ShipCity": "Strasbourg",
"ShipRegion": null,
"ShipPostalCode": "67000",
"ShipCountry": "France"
},
{
"OrderID": 10629,
"CustomerID": "GODOS",
"EmployeeID": 4,
"OrderDate": "1997-08-12T00:00:00.0000000",
"RequiredDate": "1997-09-09T00:00:00.0000000",
"ShippedDate": "1997-08-20T00:00:00.0000000",
"ShipVia": 3,
"Freight": 85.4600,
"ShipName": "Godos Cocina T\u00EDpica",
"ShipAddress": "C/ Romero, 33",
"ShipCity": "Sevilla",
"ShipRegion": null,
"ShipPostalCode": "41101",
"ShipCountry": "Spain"
},
{
"OrderID": 10630,
"CustomerID": "KOENE",
"EmployeeID": 1,
"OrderDate": "1997-08-13T00:00:00.0000000",
"RequiredDate": "1997-09-10T00:00:00.0000000",
"ShippedDate": "1997-08-19T00:00:00.0000000",
"ShipVia": 2,
"Freight": 32.3500,
"ShipName": "K\u00F6niglich Essen",
"ShipAddress": "Maubelstr. 90",
"ShipCity": "Brandenburg",
"ShipRegion": null,
"ShipPostalCode": "14776",
"ShipCountry": "Germany"
},
{
"OrderID": 10631,
"CustomerID": "LAMAI",
"EmployeeID": 8,
"OrderDate": "1997-08-14T00:00:00.0000000",
"RequiredDate": "1997-09-11T00:00:00.0000000",
"ShippedDate": "1997-08-15T00:00:00.0000000",
"ShipVia": 1,
"Freight": 0.8700,
"ShipName": "La maison d\u0027Asie",
"ShipAddress": "1 rue Alsace-Lorraine",
"ShipCity": "Toulouse",
"ShipRegion": null,
"ShipPostalCode": "31000",
"ShipCountry": "France"
},
{
"OrderID": 10632,
"CustomerID": "WANDK",
"EmployeeID": 8,
"OrderDate": "1997-08-14T00:00:00.0000000",
"RequiredDate": "1997-09-11T00:00:00.0000000",
"ShippedDate": "1997-08-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 41.3800,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10633,
"CustomerID": "ERNSH",
"EmployeeID": 7,
"OrderDate": "1997-08-15T00:00:00.0000000",
"RequiredDate": "1997-09-12T00:00:00.0000000",
"ShippedDate": "1997-08-18T00:00:00.0000000",
"ShipVia": 3,
"Freight": 477.9000,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10634,
"CustomerID": "FOLIG",
"EmployeeID": 4,
"OrderDate": "1997-08-15T00:00:00.0000000",
"RequiredDate": "1997-09-12T00:00:00.0000000",
"ShippedDate": "1997-08-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 487.3800,
"ShipName": "Folies gourmandes",
"ShipAddress": "184, chauss\u00E9e de Tournai",
"ShipCity": "Lille",
"ShipRegion": null,
"ShipPostalCode": "59000",
"ShipCountry": "France"
},
{
"OrderID": 10635,
"CustomerID": "MAGAA",
"EmployeeID": 8,
"OrderDate": "1997-08-18T00:00:00.0000000",
"RequiredDate": "1997-09-15T00:00:00.0000000",
"ShippedDate": "1997-08-21T00:00:00.0000000",
"ShipVia": 3,
"Freight": 47.4600,
"ShipName": "Magazzini Alimentari Riuniti",
"ShipAddress": "Via Ludovico il Moro 22",
"ShipCity": "Bergamo",
"ShipRegion": null,
"ShipPostalCode": "24100",
"ShipCountry": "Italy"
},
{
"OrderID": 10636,
"CustomerID": "WARTH",
"EmployeeID": 4,
"OrderDate": "1997-08-19T00:00:00.0000000",
"RequiredDate": "1997-09-16T00:00:00.0000000",
"ShippedDate": "1997-08-26T00:00:00.0000000",
"ShipVia": 1,
"Freight": 1.1500,
"ShipName": "Wartian Herkku",
"ShipAddress": "Torikatu 38",
"ShipCity": "Oulu",
"ShipRegion": null,
"ShipPostalCode": "90110",
"ShipCountry": "Finland"
},
{
"OrderID": 10637,
"CustomerID": "QUEEN",
"EmployeeID": 6,
"OrderDate": "1997-08-19T00:00:00.0000000",
"RequiredDate": "1997-09-16T00:00:00.0000000",
"ShippedDate": "1997-08-26T00:00:00.0000000",
"ShipVia": 1,
"Freight": 201.2900,
"ShipName": "Queen Cozinha",
"ShipAddress": "Alameda dos Can\u00E0rios, 891",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05487-020",
"ShipCountry": "Brazil"
},
{
"OrderID": 10638,
"CustomerID": "LINOD",
"EmployeeID": 3,
"OrderDate": "1997-08-20T00:00:00.0000000",
"RequiredDate": "1997-09-17T00:00:00.0000000",
"ShippedDate": "1997-09-01T00:00:00.0000000",
"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": 10639,
"CustomerID": "SANTG",
"EmployeeID": 7,
"OrderDate": "1997-08-20T00:00:00.0000000",
"RequiredDate": "1997-09-17T00:00:00.0000000",
"ShippedDate": "1997-08-27T00:00:00.0000000",
"ShipVia": 3,
"Freight": 38.6400,
"ShipName": "Sant\u00E9 Gourmet",
"ShipAddress": "Erling Skakkes gate 78",
"ShipCity": "Stavern",
"ShipRegion": null,
"ShipPostalCode": "4110",
"ShipCountry": "Norway"
},
{
"OrderID": 10640,
"CustomerID": "WANDK",
"EmployeeID": 4,
"OrderDate": "1997-08-21T00:00:00.0000000",
"RequiredDate": "1997-09-18T00:00:00.0000000",
"ShippedDate": "1997-08-28T00:00:00.0000000",
"ShipVia": 1,
"Freight": 23.5500,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10641,
"CustomerID": "HILAA",
"EmployeeID": 4,
"OrderDate": "1997-08-22T00:00:00.0000000",
"RequiredDate": "1997-09-19T00:00:00.0000000",
"ShippedDate": "1997-08-26T00:00:00.0000000",
"ShipVia": 2,
"Freight": 179.6100,
"ShipName": "HILARION-Abastos",
"ShipAddress": "Carrera 22 con Ave. Carlos Soublette #8-35",
"ShipCity": "San Crist\u00F3bal",
"ShipRegion": "T\u00E1chira",
"ShipPostalCode": "5022",
"ShipCountry": "Venezuela"
},
{
"OrderID": 10642,
"CustomerID": "SIMOB",
"EmployeeID": 7,
"OrderDate": "1997-08-22T00:00:00.0000000",
"RequiredDate": "1997-09-19T00:00:00.0000000",
"ShippedDate": "1997-09-05T00:00:00.0000000",
"ShipVia": 3,
"Freight": 41.8900,
"ShipName": "Simons bistro",
"ShipAddress": "Vinb\u00E6ltet 34",
"ShipCity": "Kobenhavn",
"ShipRegion": null,
"ShipPostalCode": "1734",
"ShipCountry": "Denmark"
},
{
"OrderID": 10643,
"CustomerID": "ALFKI",
"EmployeeID": 6,
"OrderDate": "1997-08-25T00:00:00.0000000",
"RequiredDate": "1997-09-22T00:00:00.0000000",
"ShippedDate": "1997-09-02T00:00:00.0000000",
"ShipVia": 1,
"Freight": 29.4600,
"ShipName": "Alfreds Futterkiste",
"ShipAddress": "Obere Str. 57",
"ShipCity": "Berlin",
"ShipRegion": null,
"ShipPostalCode": "12209",
"ShipCountry": "Germany"
},
{
"OrderID": 10644,
"CustomerID": "WELLI",
"EmployeeID": 3,
"OrderDate": "1997-08-25T00:00:00.0000000",
"RequiredDate": "1997-09-22T00:00:00.0000000",
"ShippedDate": "1997-09-01T00:00:00.0000000",
"ShipVia": 2,
"Freight": 0.1400,
"ShipName": "Wellington Importadora",
"ShipAddress": "Rua do Mercado, 12",
"ShipCity": "Resende",
"ShipRegion": "SP",
"ShipPostalCode": "08737-363",
"ShipCountry": "Brazil"
},
{
"OrderID": 10645,
"CustomerID": "HANAR",
"EmployeeID": 4,
"OrderDate": "1997-08-26T00:00:00.0000000",
"RequiredDate": "1997-09-23T00:00:00.0000000",
"ShippedDate": "1997-09-02T00:00:00.0000000",
"ShipVia": 1,
"Freight": 12.4100,
"ShipName": "Hanari Carnes",
"ShipAddress": "Rua do Pa\u00E7o, 67",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "05454-876",
"ShipCountry": "Brazil"
},
{
"OrderID": 10646,
"CustomerID": "HUNGO",
"EmployeeID": 9,
"OrderDate": "1997-08-27T00:00:00.0000000",
"RequiredDate": "1997-10-08T00:00:00.0000000",
"ShippedDate": "1997-09-03T00:00:00.0000000",
"ShipVia": 3,
"Freight": 142.3300,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10647,
"CustomerID": "QUEDE",
"EmployeeID": 4,
"OrderDate": "1997-08-27T00:00:00.0000000",
"RequiredDate": "1997-09-10T00:00:00.0000000",
"ShippedDate": "1997-09-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 45.5400,
"ShipName": "Que Del\u00EDcia",
"ShipAddress": "Rua da Panificadora, 12",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-673",
"ShipCountry": "Brazil"
},
{
"OrderID": 10648,
"CustomerID": "RICAR",
"EmployeeID": 5,
"OrderDate": "1997-08-28T00:00:00.0000000",
"RequiredDate": "1997-10-09T00:00:00.0000000",
"ShippedDate": "1997-09-09T00:00:00.0000000",
"ShipVia": 2,
"Freight": 14.2500,
"ShipName": "Ricardo Adocicados",
"ShipAddress": "Av. Copacabana, 267",
"ShipCity": "Rio de Janeiro",
"ShipRegion": "RJ",
"ShipPostalCode": "02389-890",
"ShipCountry": "Brazil"
},
{
"OrderID": 10649,
"CustomerID": "MAISD",
"EmployeeID": 5,
"OrderDate": "1997-08-28T00:00:00.0000000",
"RequiredDate": "1997-09-25T00:00:00.0000000",
"ShippedDate": "1997-08-29T00:00:00.0000000",
"ShipVia": 3,
"Freight": 6.2000,
"ShipName": "Maison Dewey",
"ShipAddress": "Rue Joseph-Bens 532",
"ShipCity": "Bruxelles",
"ShipRegion": null,
"ShipPostalCode": "B-1180",
"ShipCountry": "Belgium"
},
{
"OrderID": 10650,
"CustomerID": "FAMIA",
"EmployeeID": 5,
"OrderDate": "1997-08-29T00:00:00.0000000",
"RequiredDate": "1997-09-26T00:00:00.0000000",
"ShippedDate": "1997-09-03T00:00:00.0000000",
"ShipVia": 3,
"Freight": 176.8100,
"ShipName": "Familia Arquibaldo",
"ShipAddress": "Rua Or\u00F3s, 92",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05442-030",
"ShipCountry": "Brazil"
},
{
"OrderID": 10651,
"CustomerID": "WANDK",
"EmployeeID": 8,
"OrderDate": "1997-09-01T00:00:00.0000000",
"RequiredDate": "1997-09-29T00:00:00.0000000",
"ShippedDate": "1997-09-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 20.6000,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10652,
"CustomerID": "GOURL",
"EmployeeID": 4,
"OrderDate": "1997-09-01T00:00:00.0000000",
"RequiredDate": "1997-09-29T00:00:00.0000000",
"ShippedDate": "1997-09-08T00:00:00.0000000",
"ShipVia": 2,
"Freight": 7.1400,
"ShipName": "Gourmet Lanchonetes",
"ShipAddress": "Av. Brasil, 442",
"ShipCity": "Campinas",
"ShipRegion": "SP",
"ShipPostalCode": "04876-786",
"ShipCountry": "Brazil"
},
{
"OrderID": 10653,
"CustomerID": "FRANK",
"EmployeeID": 1,
"OrderDate": "1997-09-02T00:00:00.0000000",
"RequiredDate": "1997-09-30T00:00:00.0000000",
"ShippedDate": "1997-09-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 93.2500,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10654,
"CustomerID": "BERGS",
"EmployeeID": 5,
"OrderDate": "1997-09-02T00:00:00.0000000",
"RequiredDate": "1997-09-30T00:00:00.0000000",
"ShippedDate": "1997-09-11T00:00:00.0000000",
"ShipVia": 1,
"Freight": 55.2600,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10655,
"CustomerID": "REGGC",
"EmployeeID": 1,
"OrderDate": "1997-09-03T00:00:00.0000000",
"RequiredDate": "1997-10-01T00:00:00.0000000",
"ShippedDate": "1997-09-11T00:00:00.0000000",
"ShipVia": 2,
"Freight": 4.4100,
"ShipName": "Reggiani Caseifici",
"ShipAddress": "Strada Provinciale 124",
"ShipCity": "Reggio Emilia",
"ShipRegion": null,
"ShipPostalCode": "42100",
"ShipCountry": "Italy"
},
{
"OrderID": 10656,
"CustomerID": "GREAL",
"EmployeeID": 6,
"OrderDate": "1997-09-04T00:00:00.0000000",
"RequiredDate": "1997-10-02T00:00:00.0000000",
"ShippedDate": "1997-09-10T00:00:00.0000000",
"ShipVia": 1,
"Freight": 57.1500,
"ShipName": "Great Lakes Food Market",
"ShipAddress": "2732 Baker Blvd.",
"ShipCity": "Eugene",
"ShipRegion": "OR",
"ShipPostalCode": "97403",
"ShipCountry": "USA"
},
{
"OrderID": 10657,
"CustomerID": "SAVEA",
"EmployeeID": 2,
"OrderDate": "1997-09-04T00:00:00.0000000",
"RequiredDate": "1997-10-02T00:00:00.0000000",
"ShippedDate": "1997-09-15T00:00:00.0000000",
"ShipVia": 2,
"Freight": 352.6900,
"ShipName": "Save-a-lot Markets",
"ShipAddress": "187 Suffolk Ln.",
"ShipCity": "Boise",
"ShipRegion": "ID",
"ShipPostalCode": "83720",
"ShipCountry": "USA"
},
{
"OrderID": 10658,
"CustomerID": "QUICK",
"EmployeeID": 4,
"OrderDate": "1997-09-05T00:00:00.0000000",
"RequiredDate": "1997-10-03T00:00:00.0000000",
"ShippedDate": "1997-09-08T00:00:00.0000000",
"ShipVia": 1,
"Freight": 364.1500,
"ShipName": "QUICK-Stop",
"ShipAddress": "Taucherstra\u00DFe 10",
"ShipCity": "Cunewalde",
"ShipRegion": null,
"ShipPostalCode": "01307",
"ShipCountry": "Germany"
},
{
"OrderID": 10659,
"CustomerID": "QUEEN",
"EmployeeID": 7,
"OrderDate": "1997-09-05T00:00:00.0000000",
"RequiredDate": "1997-10-03T00:00:00.0000000",
"ShippedDate": "1997-09-10T00:00:00.0000000",
"ShipVia": 2,
"Freight": 105.8100,
"ShipName": "Queen Cozinha",
"ShipAddress": "Alameda dos Can\u00E0rios, 891",
"ShipCity": "Sao Paulo",
"ShipRegion": "SP",
"ShipPostalCode": "05487-020",
"ShipCountry": "Brazil"
},
{
"OrderID": 10660,
"CustomerID": "HUNGC",
"EmployeeID": 8,
"OrderDate": "1997-09-08T00:00:00.0000000",
"RequiredDate": "1997-10-06T00:00:00.0000000",
"ShippedDate": "1997-10-15T00:00:00.0000000",
"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": 10661,
"CustomerID": "HUNGO",
"EmployeeID": 7,
"OrderDate": "1997-09-09T00:00:00.0000000",
"RequiredDate": "1997-10-07T00:00:00.0000000",
"ShippedDate": "1997-09-15T00:00:00.0000000",
"ShipVia": 3,
"Freight": 17.5500,
"ShipName": "Hungry Owl All-Night Grocers",
"ShipAddress": "8 Johnstown Road",
"ShipCity": "Cork",
"ShipRegion": "Co. Cork",
"ShipPostalCode": null,
"ShipCountry": "Ireland"
},
{
"OrderID": 10662,
"CustomerID": "LONEP",
"EmployeeID": 3,
"OrderDate": "1997-09-09T00:00:00.0000000",
"RequiredDate": "1997-10-07T00:00:00.0000000",
"ShippedDate": "1997-09-18T00:00:00.0000000",
"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": "1997-09-10T00:00:00.0000000",
"RequiredDate": "1997-09-24T00:00:00.0000000",
"ShippedDate": "1997-10-03T00:00:00.0000000",
"ShipVia": 2,
"Freight": 113.1500,
"ShipName": "Bon app\u0027",
"ShipAddress": "12, rue des Bouchers",
"ShipCity": "Marseille",
"ShipRegion": null,
"ShipPostalCode": "13008",
"ShipCountry": "France"
},
{
"OrderID": 10664,
"CustomerID": "FURIB",
"EmployeeID": 1,
"OrderDate": "1997-09-10T00:00:00.0000000",
"RequiredDate": "1997-10-08T00:00:00.0000000",
"ShippedDate": "1997-09-19T00:00:00.0000000",
"ShipVia": 3,
"Freight": 1.2700,
"ShipName": "Furia Bacalhau e Frutos do Mar",
"ShipAddress": "Jardim das rosas n. 32",
"ShipCity": "Lisboa",
"ShipRegion": null,
"ShipPostalCode": "1675",
"ShipCountry": "Portugal"
},
{
"OrderID": 10665,
"CustomerID": "LONEP",
"EmployeeID": 1,
"OrderDate": "1997-09-11T00:00:00.0000000",
"RequiredDate": "1997-10-09T00:00:00.0000000",
"ShippedDate": "1997-09-17T00:00:00.0000000",
"ShipVia": 2,
"Freight": 26.3100,
"ShipName": "Lonesome Pine Restaurant",
"ShipAddress": "89 Chiaroscuro Rd.",
"ShipCity": "Portland",
"ShipRegion": "OR",
"ShipPostalCode": "97219",
"ShipCountry": "USA"
},
{
"OrderID": 10666,
"CustomerID": "RICSU",
"EmployeeID": 7,
"OrderDate": "1997-09-12T00:00:00.0000000",
"RequiredDate": "1997-10-10T00:00:00.0000000",
"ShippedDate": "1997-09-22T00:00:00.0000000",
"ShipVia": 2,
"Freight": 232.4200,
"ShipName": "Richter Supermarkt",
"ShipAddress": "Starenweg 5",
"ShipCity": "Gen\u00E8ve",
"ShipRegion": null,
"ShipPostalCode": "1204",
"ShipCountry": "Switzerland"
},
{
"OrderID": 10667,
"CustomerID": "ERNSH",
"EmployeeID": 7,
"OrderDate": "1997-09-12T00:00:00.0000000",
"RequiredDate": "1997-10-10T00:00:00.0000000",
"ShippedDate": "1997-09-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 78.0900,
"ShipName": "Ernst Handel",
"ShipAddress": "Kirchgasse 6",
"ShipCity": "Graz",
"ShipRegion": null,
"ShipPostalCode": "8010",
"ShipCountry": "Austria"
},
{
"OrderID": 10668,
"CustomerID": "WANDK",
"EmployeeID": 1,
"OrderDate": "1997-09-15T00:00:00.0000000",
"RequiredDate": "1997-10-13T00:00:00.0000000",
"ShippedDate": "1997-09-23T00:00:00.0000000",
"ShipVia": 2,
"Freight": 47.2200,
"ShipName": "Die Wandernde Kuh",
"ShipAddress": "Adenauerallee 900",
"ShipCity": "Stuttgart",
"ShipRegion": null,
"ShipPostalCode": "70563",
"ShipCountry": "Germany"
},
{
"OrderID": 10669,
"CustomerID": "SIMOB",
"EmployeeID": 2,
"OrderDate": "1997-09-15T00:00:00.0000000",
"RequiredDate": "1997-10-13T00:00:00.0000000",
"ShippedDate": "1997-09-22T00:00:00.0000000",
"ShipVia": 1,
"Freight": 24.3900,
"ShipName": "Simons bistro",
"ShipAddress": "Vinb\u00E6ltet 34",
"ShipCity": "Kobenhavn",
"ShipRegion": null,
"ShipPostalCode": "1734",
"ShipCountry": "Denmark"
},
{
"OrderID": 10670,
"CustomerID": "FRANK",
"EmployeeID": 4,
"OrderDate": "1997-09-16T00:00:00.0000000",
"RequiredDate": "1997-10-14T00:00:00.0000000",
"ShippedDate": "1997-09-18T00:00:00.0000000",
"ShipVia": 1,
"Freight": 203.4800,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10671,
"CustomerID": "FRANR",
"EmployeeID": 1,
"OrderDate": "1997-09-17T00:00:00.0000000",
"RequiredDate": "1997-10-15T00:00:00.0000000",
"ShippedDate": "1997-09-24T00:00:00.0000000",
"ShipVia": 1,
"Freight": 30.3400,
"ShipName": "France restauration",
"ShipAddress": "54, rue Royale",
"ShipCity": "Nantes",
"ShipRegion": null,
"ShipPostalCode": "44000",
"ShipCountry": "France"
},
{
"OrderID": 10672,
"CustomerID": "BERGS",
"EmployeeID": 9,
"OrderDate": "1997-09-17T00:00:00.0000000",
"RequiredDate": "1997-10-01T00:00:00.0000000",
"ShippedDate": "1997-09-26T00:00:00.0000000",
"ShipVia": 2,
"Freight": 95.7500,
"ShipName": "Berglunds snabbk\u00F6p",
"ShipAddress": "Berguvsv\u00E4gen 8",
"ShipCity": "Lule\u00E5",
"ShipRegion": null,
"ShipPostalCode": "S-958 22",
"ShipCountry": "Sweden"
},
{
"OrderID": 10673,
"CustomerID": "WILMK",
"EmployeeID": 2,
"OrderDate": "1997-09-18T00:00:00.0000000",
"RequiredDate": "1997-10-16T00:00:00.0000000",
"ShippedDate": "1997-09-19T00:00:00.0000000",
"ShipVia": 1,
"Freight": 22.7600,
"ShipName": "Wilman Kala",
"ShipAddress": "Keskuskatu 45",
"ShipCity": "Helsinki",
"ShipRegion": null,
"ShipPostalCode": "21240",
"ShipCountry": "Finland"
},
{
"OrderID": 10674,
"CustomerID": "ISLAT",
"EmployeeID": 4,
"OrderDate": "1997-09-18T00:00:00.0000000",
"RequiredDate": "1997-10-16T00:00:00.0000000",
"ShippedDate": "1997-09-30T00:00:00.0000000",
"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": 10675,
"CustomerID": "FRANK",
"EmployeeID": 5,
"OrderDate": "1997-09-19T00:00:00.0000000",
"RequiredDate": "1997-10-17T00:00:00.0000000",
"ShippedDate": "1997-09-23T00:00:00.0000000",
"ShipVia": 2,
"Freight": 31.8500,
"ShipName": "Frankenversand",
"ShipAddress": "Berliner Platz 43",
"ShipCity": "M\u00FCnchen",
"ShipRegion": null,
"ShipPostalCode": "80805",
"ShipCountry": "Germany"
},
{
"OrderID": 10676,
"CustomerID": "TORTU",
"EmployeeID": 2,
"OrderDate": "1997-09-22T00:00:00.0000000",
"RequiredDate": "1997-10-20T00:00:00.0000000",
"ShippedDate": "1997-09-29T00:00:00.0000000",
"ShipVia": 2,
"Freight": 2.0100,
"ShipName": "Tortuga Restaurante",
"ShipAddress": "Avda. Azteca 123",
"ShipCity": "M\u00E9xico D.F.",
"ShipRegion": null,
"ShipPostalCode": "05033",
"ShipCountry": "Mexico"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment