northwindTradersMockDb.js

// exports.handler =  async function(event, context) {
//   console.log("EVENT: \n" + JSON.stringify(event, null, 2))
//   return context.logStreamName
// }

exports.handler = async (event, context) => {

  // SCROLL TO THE END TO SEE HOW DATA IS PROCESSED
  console.log("Received event {}", JSON.stringify(event, 3));
  var customers = [
    {
      CustomerID: "ALFKI",
      CompanyName: "Alfreds Futterkiste",
      ContactName: "Maria Anders",
      ContactTitle: "Sales Representative",
      Address: "Obere Str. 57",
      City: "Berlin",
      Region: "NULL",
      PostalCode: 12209,
      Country: "Germany",
      Phone: "030-0074321",
      Fax: "030-0076545"
    },
    {
      CustomerID: "ANATR",
      CompanyName: "Ana Trujillo Emparedados y helados",
      ContactName: "Ana Trujillo",
      ContactTitle: "Owner",
      Address: "Avda. de la Constitución 2222",
      City: "México D.F.",
      Region: "NULL",
      PostalCode: "05021",
      Country: "Mexico",
      Phone: "(5) 555-4729",
      Fax: "(5) 555-3745"
    },
    {
      CustomerID: "ANTON",
      CompanyName: "Antonio Moreno Taquería",
      ContactName: "Antonio Moreno",
      ContactTitle: "Owner",
      Address: "Mataderos  2312",
      City: "México D.F.",
      Region: "NULL",
      PostalCode: "05023",
      Country: "Mexico",
      Phone: "(5) 555-3932",
      Fax: "NULL"
    },
    {
      CustomerID: "AROUT",
      CompanyName: "Around the Horn",
      ContactName: "Thomas Hardy",
      ContactTitle: "Sales Representative",
      Address: "120 Hanover Sq.",
      City: "London",
      Region: "NULL",
      PostalCode: "WA1 1DP",
      Country: "UK",
      Phone: "(171) 555-7788",
      Fax: "(171) 555-6750"
    },
    {
      CustomerID: "BERGS",
      CompanyName: "Berglunds snabbköp",
      ContactName: "Christina Berglund",
      ContactTitle: "Order Administrator",
      Address: "Berguvsvägen  8",
      City: "Luleå",
      Region: "NULL",
      PostalCode: "S-958 22",
      Country: "Sweden",
      Phone: "0921-12 34 65",
      Fax: "0921-12 34 67"
    },
    {
      CustomerID: "BLAUS",
      CompanyName: "Blauer See Delikatessen",
      ContactName: "Hanna Moos",
      ContactTitle: "Sales Representative",
      Address: "Forsterstr. 57",
      City: "Mannheim",
      Region: "NULL",
      PostalCode: 68306,
      Country: "Germany",
      Phone: "0621-08460",
      Fax: "0621-08924"
    },
    {
      CustomerID: "BLONP",
      CompanyName: "Blondesddsl père et fils",
      ContactName: "Frédérique Citeaux",
      ContactTitle: "Marketing Manager",
      Address: 24,
      City: "place Kléber",
      Region: "Strasbourg",
      PostalCode: "NULL",
      Country: 67000,
      Phone: "France",
      Fax: "88.60.15.31"
    },
    {
      CustomerID: "BOLID",
      CompanyName: "Bólido Comidas preparadas",
      ContactName: "Martín Sommer",
      ContactTitle: "Owner",
      Address: "C/ Araquil",
      City: 67,
      Region: "Madrid",
      PostalCode: "NULL",
      Country: 28023,
      Phone: "Spain",
      Fax: "(91) 555 22 82"
    },
    {
      CustomerID: "BONAP",
      CompanyName: "Bon app'",
      ContactName: "Laurence Lebihan",
      ContactTitle: "Owner",
      Address: 12,
      City: "rue des Bouchers",
      Region: "Marseille",
      PostalCode: "NULL",
      Country: 13008,
      Phone: "France",
      Fax: "91.24.45.40"
    },
    {
      CustomerID: "BOTTM",
      CompanyName: "Bottom-Dollar Markets",
      ContactName: "Elizabeth Lincoln",
      ContactTitle: "Accounting Manager",
      Address: "23 Tsawassen Blvd.",
      City: "Tsawassen",
      Region: "BC",
      PostalCode: "T2F 8M4",
      Country: "Canada",
      Phone: "(604) 555-4729",
      Fax: "(604) 555-3745"
    },
    {
      CustomerID: "BSBEV",
      CompanyName: "B's Beverages",
      ContactName: "Victoria Ashworth",
      ContactTitle: "Sales Representative",
      Address: "Fauntleroy Circus",
      City: "London",
      Region: "NULL",
      PostalCode: "EC2 5NT",
      Country: "UK",
      Phone: "(171) 555-1212",
      Fax: "NULL"
    },
    {
      CustomerID: "CACTU",
      CompanyName: "Cactus Comidas para llevar",
      ContactName: "Patricio Simpson",
      ContactTitle: "Sales Agent",
      Address: "Cerrito 333",
      City: "Buenos Aires",
      Region: "NULL",
      PostalCode: 1010,
      Country: "Argentina",
      Phone: "(1) 135-5555",
      Fax: "(1) 135-4892"
    },
    {
      CustomerID: "CENTC",
      CompanyName: "Centro comercial Moctezuma",
      ContactName: "Francisco Chang",
      ContactTitle: "Marketing Manager",
      Address: "Sierras de Granada 9993",
      City: "México D.F.",
      Region: "NULL",
      PostalCode: "05022",
      Country: "Mexico",
      Phone: "(5) 555-3392",
      Fax: "(5) 555-7293"
    },
    {
      CustomerID: "CHOPS",
      CompanyName: "Chop-suey Chinese",
      ContactName: "Yang Wang",
      ContactTitle: "Owner",
      Address: "Hauptstr. 29",
      City: "Bern",
      Region: "NULL",
      PostalCode: 3012,
      Country: "Switzerland",
      Phone: "0452-076545",
      Fax: "NULL"
    },
    {
      CustomerID: "COMMI",
      CompanyName: "Comércio Mineiro",
      ContactName: "Pedro Afonso",
      ContactTitle: "Sales Associate",
      Address: "Av. dos Lusíadas",
      City: 23,
      Region: "Sao Paulo",
      PostalCode: "SP",
      Country: "05432-043",
      Phone: "Brazil",
      Fax: "(11) 555-7647"
    },
    {
      CustomerID: "CONSH",
      CompanyName: "Consolidated Holdings",
      ContactName: "Elizabeth Brown",
      ContactTitle: "Sales Representative",
      Address: "Berkeley Gardens 12  Brewery",
      City: "London",
      Region: "NULL",
      PostalCode: "WX1 6LT",
      Country: "UK",
      Phone: "(171) 555-2282",
      Fax: "(171) 555-9199"
    },
    {
      CustomerID: "DRACD",
      CompanyName: "Drachenblut Delikatessen",
      ContactName: "Sven Ottlieb",
      ContactTitle: "Order Administrator",
      Address: "Walserweg 21",
      City: "Aachen",
      Region: "NULL",
      PostalCode: 52066,
      Country: "Germany",
      Phone: "0241-039123",
      Fax: "0241-059428"
    },
    {
      CustomerID: "DUMON",
      CompanyName: "Du monde entier",
      ContactName: "Janine Labrune",
      ContactTitle: "Owner",
      Address: 67,
      City: "rue des Cinquante Otages",
      Region: "Nantes",
      PostalCode: "NULL",
      Country: 44000,
      Phone: "France",
      Fax: "40.67.88.88"
    },
    {
      CustomerID: "EASTC",
      CompanyName: "Eastern Connection",
      ContactName: "Ann Devon",
      ContactTitle: "Sales Agent",
      Address: "35 King George",
      City: "London",
      Region: "NULL",
      PostalCode: "WX3 6FW",
      Country: "UK",
      Phone: "(171) 555-0297",
      Fax: "(171) 555-3373"
    },
    {
      CustomerID: "ERNSH",
      CompanyName: "Ernst Handel",
      ContactName: "Roland Mendel",
      ContactTitle: "Sales Manager",
      Address: "Kirchgasse 6",
      City: "Graz",
      Region: "NULL",
      PostalCode: 8010,
      Country: "Austria",
      Phone: "7675-3425",
      Fax: "7675-3426"
    },
    {
      CustomerID: "FAMIA",
      CompanyName: "Familia Arquibaldo",
      ContactName: "Aria Cruz",
      ContactTitle: "Marketing Assistant",
      Address: "Rua Orós",
      City: 92,
      Region: "Sao Paulo",
      PostalCode: "SP",
      Country: "05442-030",
      Phone: "Brazil",
      Fax: "(11) 555-9857"
    },
    {
      CustomerID: "FISSA",
      CompanyName: "FISSA Fabrica Inter. Salchichas S.A.",
      ContactName: "Diego Roel",
      ContactTitle: "Accounting Manager",
      Address: "C/ Moralzarzal",
      City: 86,
      Region: "Madrid",
      PostalCode: "NULL",
      Country: 28034,
      Phone: "Spain",
      Fax: "(91) 555 94 44"
    },
    {
      CustomerID: "FOLIG",
      CompanyName: "Folies gourmandes",
      ContactName: "Martine Rancé",
      ContactTitle: "Assistant Sales Agent",
      Address: 184,
      City: "chaussée de Tournai",
      Region: "Lille",
      PostalCode: "NULL",
      Country: 59000,
      Phone: "France",
      Fax: "20.16.10.16"
    },
    {
      CustomerID: "FOLKO",
      CompanyName: "Folk och fä HB",
      ContactName: "Maria Larsson",
      ContactTitle: "Owner",
      Address: "Åkergatan 24",
      City: "Bräcke",
      Region: "NULL",
      PostalCode: "S-844 67",
      Country: "Sweden",
      Phone: "0695-34 67 21",
      Fax: "NULL"
    },
    {
      CustomerID: "FRANK",
      CompanyName: "Frankenversand",
      ContactName: "Peter Franken",
      ContactTitle: "Marketing Manager",
      Address: "Berliner Platz 43",
      City: "München",
      Region: "NULL",
      PostalCode: 80805,
      Country: "Germany",
      Phone: "089-0877310",
      Fax: "089-0877451"
    },
    {
      CustomerID: "FRANR",
      CompanyName: "France restauration",
      ContactName: "Carine Schmitt",
      ContactTitle: "Marketing Manager",
      Address: 54,
      City: "rue Royale",
      Region: "Nantes",
      PostalCode: "NULL",
      Country: 44000,
      Phone: "France",
      Fax: "40.32.21.21"
    },
    {
      CustomerID: "FRANS",
      CompanyName: "Franchi S.p.A.",
      ContactName: "Paolo Accorti",
      ContactTitle: "Sales Representative",
      Address: "Via Monte Bianco 34",
      City: "Torino",
      Region: "NULL",
      PostalCode: 10100,
      Country: "Italy",
      Phone: "011-4988260",
      Fax: "011-4988261"
    },
    {
      CustomerID: "FURIB",
      CompanyName: "Furia Bacalhau e Frutos do Mar",
      ContactName: "Lino Rodriguez",
      ContactTitle: "Sales Manager",
      Address: "Jardim das rosas n. 32",
      City: "Lisboa",
      Region: "NULL",
      PostalCode: 1675,
      Country: "Portugal",
      Phone: "(1) 354-2534",
      Fax: "(1) 354-2535"
    },
    {
      CustomerID: "GALED",
      CompanyName: "Galería del gastrónomo",
      ContactName: "Eduardo Saavedra",
      ContactTitle: "Marketing Manager",
      Address: "Rambla de Cataluña",
      City: 23,
      Region: "Barcelona",
      PostalCode: "NULL",
      Country: "08022",
      Phone: "Spain",
      Fax: "(93) 203 4560"
    },
    {
      CustomerID: "GODOS",
      CompanyName: "Godos Cocina Típica",
      ContactName: "José Pedro Freyre",
      ContactTitle: "Sales Manager",
      Address: "C/ Romero",
      City: 33,
      Region: "Sevilla",
      PostalCode: "NULL",
      Country: 41101,
      Phone: "Spain",
      Fax: "(95) 555 82 82"
    },
    {
      CustomerID: "GOURL",
      CompanyName: "Gourmet Lanchonetes",
      ContactName: "André Fonseca",
      ContactTitle: "Sales Associate",
      Address: "Av. Brasil",
      City: 442,
      Region: "Campinas",
      PostalCode: "SP",
      Country: "04876-786",
      Phone: "Brazil",
      Fax: "(11) 555-9482"
    },
    {
      CustomerID: "GREAL",
      CompanyName: "Great Lakes Food Market",
      ContactName: "Howard Snyder",
      ContactTitle: "Marketing Manager",
      Address: "2732 Baker Blvd.",
      City: "Eugene",
      Region: "OR",
      PostalCode: 97403,
      Country: "USA",
      Phone: "(503) 555-7555",
      Fax: "NULL"
    },
    {
      CustomerID: "GROSR",
      CompanyName: "GROSELLA-Restaurante",
      ContactName: "Manuel Pereira",
      ContactTitle: "Owner",
      Address: "5ª Ave. Los Palos Grandes",
      City: "Caracas",
      Region: "DF",
      PostalCode: 1081,
      Country: "Venezuela",
      Phone: "(2) 283-2951",
      Fax: "(2) 283-3397"
    },
    {
      CustomerID: "HANAR",
      CompanyName: "Hanari Carnes",
      ContactName: "Mario Pontes",
      ContactTitle: "Accounting Manager",
      Address: "Rua do Paço",
      City: 67,
      Region: "Rio de Janeiro",
      PostalCode: "RJ",
      Country: "05454-876",
      Phone: "Brazil",
      Fax: "(21) 555-0091"
    },
    {
      CustomerID: "HILAA",
      CompanyName: "HILARION-Abastos",
      ContactName: "Carlos Hernández",
      ContactTitle: "Sales Representative",
      Address: "Carrera 22 con Ave. Carlos Soublette #8-35",
      City: "San Cristóbal",
      Region: "Táchira",
      PostalCode: 5022,
      Country: "Venezuela",
      Phone: "(5) 555-1340",
      Fax: "(5) 555-1948"
    },
    {
      CustomerID: "HUNGC",
      CompanyName: "Hungry Coyote Import Store",
      ContactName: "Yoshi Latimer",
      ContactTitle: "Sales Representative",
      Address: "City Center Plaza 516 Main St.",
      City: "Elgin",
      Region: "OR",
      PostalCode: 97827,
      Country: "USA",
      Phone: "(503) 555-6874",
      Fax: "(503) 555-2376"
    },
    {
      CustomerID: "HUNGO",
      CompanyName: "Hungry Owl All-Night Grocers",
      ContactName: "Patricia McKenna",
      ContactTitle: "Sales Associate",
      Address: "8 Johnstown Road",
      City: "Cork",
      Region: "Co. Cork",
      PostalCode: "NULL",
      Country: "Ireland",
      Phone: "2967 542",
      Fax: "2967 3333"
    },
    {
      CustomerID: "ISLAT",
      CompanyName: "Island Trading",
      ContactName: "Helen Bennett",
      ContactTitle: "Marketing Manager",
      Address: "Garden House Crowther Way",
      City: "Cowes",
      Region: "Isle of Wight",
      PostalCode: "PO31 7PJ",
      Country: "UK",
      Phone: "(198) 555-8888",
      Fax: "NULL"
    },
    {
      CustomerID: "KOENE",
      CompanyName: "Königlich Essen",
      ContactName: "Philip Cramer",
      ContactTitle: "Sales Associate",
      Address: "Maubelstr. 90",
      City: "Brandenburg",
      Region: "NULL",
      PostalCode: 14776,
      Country: "Germany",
      Phone: "0555-09876",
      Fax: "NULL"
    },
    {
      CustomerID: "LACOR",
      CompanyName: "La corne d'abondance",
      ContactName: "Daniel Tonini",
      ContactTitle: "Sales Representative",
      Address: 67,
      City: "avenue de l'Europe",
      Region: "Versailles",
      PostalCode: "NULL",
      Country: 78000,
      Phone: "France",
      Fax: "30.59.84.10"
    },
    {
      CustomerID: "LAMAI",
      CompanyName: "La maison d'Asie",
      ContactName: "Annette Roulet",
      ContactTitle: "Sales Manager",
      Address: "1 rue Alsace-Lorraine",
      City: "Toulouse",
      Region: "NULL",
      PostalCode: 31000,
      Country: "France",
      Phone: "61.77.61.10",
      Fax: "61.77.61.11"
    },
    {
      CustomerID: "LAUGB",
      CompanyName: "Laughing Bacchus Wine Cellars",
      ContactName: "Yoshi Tannamuri",
      ContactTitle: "Marketing Assistant",
      Address: "1900 Oak St.",
      City: "Vancouver",
      Region: "BC",
      PostalCode: "V3F 2K1",
      Country: "Canada",
      Phone: "(604) 555-3392",
      Fax: "(604) 555-7293"
    },
    {
      CustomerID: "LAZYK",
      CompanyName: "Lazy K Kountry Store",
      ContactName: "John Steel",
      ContactTitle: "Marketing Manager",
      Address: "12 Orchestra Terrace",
      City: "Walla Walla",
      Region: "WA",
      PostalCode: 99362,
      Country: "USA",
      Phone: "(509) 555-7969",
      Fax: "(509) 555-6221"
    },
    {
      CustomerID: "LEHMS",
      CompanyName: "Lehmanns Marktstand",
      ContactName: "Renate Messner",
      ContactTitle: "Sales Representative",
      Address: "Magazinweg 7",
      City: "Frankfurt a.M.",
      Region: "NULL",
      PostalCode: 60528,
      Country: "Germany",
      Phone: "069-0245984",
      Fax: "069-0245874"
    },
    {
      CustomerID: "LETSS",
      CompanyName: "Let's Stop N Shop",
      ContactName: "Jaime Yorres",
      ContactTitle: "Owner",
      Address: "87 Polk St. Suite 5",
      City: "San Francisco",
      Region: "CA",
      PostalCode: 94117,
      Country: "USA",
      Phone: "(415) 555-5938",
      Fax: "NULL"
    },
    {
      CustomerID: "LILAS",
      CompanyName: "LILA-Supermercado",
      ContactName: "Carlos González",
      ContactTitle: "Accounting Manager",
      Address: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      City: "Barquisimeto",
      Region: "Lara",
      PostalCode: 3508,
      Country: "Venezuela",
      Phone: "(9) 331-6954",
      Fax: "(9) 331-7256"
    },
    {
      CustomerID: "LINOD",
      CompanyName: "LINO-Delicateses",
      ContactName: "Felipe Izquierdo",
      ContactTitle: "Owner",
      Address: "Ave. 5 de Mayo Porlamar",
      City: "I. de Margarita",
      Region: "Nueva Esparta",
      PostalCode: 4980,
      Country: "Venezuela",
      Phone: "(8) 34-56-12",
      Fax: "(8) 34-93-93"
    },
    {
      CustomerID: "LONEP",
      CompanyName: "Lonesome Pine Restaurant",
      ContactName: "Fran Wilson",
      ContactTitle: "Sales Manager",
      Address: "89 Chiaroscuro Rd.",
      City: "Portland",
      Region: "OR",
      PostalCode: 97219,
      Country: "USA",
      Phone: "(503) 555-9573",
      Fax: "(503) 555-9646"
    },
    {
      CustomerID: "MAGAA",
      CompanyName: "Magazzini Alimentari Riuniti",
      ContactName: "Giovanni Rovelli",
      ContactTitle: "Marketing Manager",
      Address: "Via Ludovico il Moro 22",
      City: "Bergamo",
      Region: "NULL",
      PostalCode: 24100,
      Country: "Italy",
      Phone: "035-640230",
      Fax: "035-640231"
    },
    {
      CustomerID: "MAISD",
      CompanyName: "Maison Dewey",
      ContactName: "Catherine Dewey",
      ContactTitle: "Sales Agent",
      Address: "Rue Joseph-Bens 532",
      City: "Bruxelles",
      Region: "NULL",
      PostalCode: "B-1180",
      Country: "Belgium",
      Phone: "(02) 201 24 67",
      Fax: "(02) 201 24 68"
    },
    {
      CustomerID: "MEREP",
      CompanyName: "Mère Paillarde",
      ContactName: "Jean Fresnière",
      ContactTitle: "Marketing Assistant",
      Address: "43 rue St. Laurent",
      City: "Montréal",
      Region: "Québec",
      PostalCode: "H1J 1C3",
      Country: "Canada",
      Phone: "(514) 555-8054",
      Fax: "(514) 555-8055"
    },
    {
      CustomerID: "MORGK",
      CompanyName: "Morgenstern Gesundkost",
      ContactName: "Alexander Feuer",
      ContactTitle: "Marketing Assistant",
      Address: "Heerstr. 22",
      City: "Leipzig",
      Region: "NULL",
      PostalCode: "04179",
      Country: "Germany",
      Phone: "0342-023176",
      Fax: "NULL"
    },
    {
      CustomerID: "NORTS",
      CompanyName: "North/South",
      ContactName: "Simon Crowther",
      ContactTitle: "Sales Associate",
      Address: "South House 300 Queensbridge",
      City: "London",
      Region: "NULL",
      PostalCode: "SW7 1RZ",
      Country: "UK",
      Phone: "(171) 555-7733",
      Fax: "(171) 555-2530"
    },
    {
      CustomerID: "OCEAN",
      CompanyName: "Océano Atlántico Ltda.",
      ContactName: "Yvonne Moncada",
      ContactTitle: "Sales Agent",
      Address: "Ing. Gustavo Moncada 8585 Piso 20-A",
      City: "Buenos Aires",
      Region: "NULL",
      PostalCode: 1010,
      Country: "Argentina",
      Phone: "(1) 135-5333",
      Fax: "(1) 135-5535"
    },
    {
      CustomerID: "OLDWO",
      CompanyName: "Old World Delicatessen",
      ContactName: "Rene Phillips",
      ContactTitle: "Sales Representative",
      Address: "2743 Bering St.",
      City: "Anchorage",
      Region: "AK",
      PostalCode: 99508,
      Country: "USA",
      Phone: "(907) 555-7584",
      Fax: "(907) 555-2880"
    },
    {
      CustomerID: "OTTIK",
      CompanyName: "Ottilies Käseladen",
      ContactName: "Henriette Pfalzheim",
      ContactTitle: "Owner",
      Address: "Mehrheimerstr. 369",
      City: "Köln",
      Region: "NULL",
      PostalCode: 50739,
      Country: "Germany",
      Phone: "0221-0644327",
      Fax: "0221-0765721"
    },
    {
      CustomerID: "PARIS",
      CompanyName: "Paris spécialités",
      ContactName: "Marie Bertrand",
      ContactTitle: "Owner",
      Address: 265,
      City: "boulevard Charonne",
      Region: "Paris",
      PostalCode: "NULL",
      Country: 75012,
      Phone: "France",
      Fax: "(1) 42.34.22.66"
    },
    {
      CustomerID: "PERIC",
      CompanyName: "Pericles Comidas clásicas",
      ContactName: "Guillermo Fernández",
      ContactTitle: "Sales Representative",
      Address: "Calle Dr. Jorge Cash 321",
      City: "México D.F.",
      Region: "NULL",
      PostalCode: "05033",
      Country: "Mexico",
      Phone: "(5) 552-3745",
      Fax: "(5) 545-3745"
    },
    {
      CustomerID: "PICCO",
      CompanyName: "Piccolo und mehr",
      ContactName: "Georg Pipps",
      ContactTitle: "Sales Manager",
      Address: "Geislweg 14",
      City: "Salzburg",
      Region: "NULL",
      PostalCode: 5020,
      Country: "Austria",
      Phone: "6562-9722",
      Fax: "6562-9723"
    },
    {
      CustomerID: "PRINI",
      CompanyName: "Princesa Isabel Vinhos",
      ContactName: "Isabel de Castro",
      ContactTitle: "Sales Representative",
      Address: "Estrada da saúde n. 58",
      City: "Lisboa",
      Region: "NULL",
      PostalCode: 1756,
      Country: "Portugal",
      Phone: "(1) 356-5634",
      Fax: "NULL"
    },
    {
      CustomerID: "QUEDE",
      CompanyName: "Que Delícia",
      ContactName: "Bernardo Batista",
      ContactTitle: "Accounting Manager",
      Address: "Rua da Panificadora",
      City: 12,
      Region: "Rio de Janeiro",
      PostalCode: "RJ",
      Country: "02389-673",
      Phone: "Brazil",
      Fax: "(21) 555-4252"
    },
    {
      CustomerID: "QUEEN",
      CompanyName: "Queen Cozinha",
      ContactName: "Lúcia Carvalho",
      ContactTitle: "Marketing Assistant",
      Address: "Alameda dos Canàrios",
      City: 891,
      Region: "Sao Paulo",
      PostalCode: "SP",
      Country: "05487-020",
      Phone: "Brazil",
      Fax: "(11) 555-1189"
    },
    {
      CustomerID: "QUICK",
      CompanyName: "QUICK-Stop",
      ContactName: "Horst Kloss",
      ContactTitle: "Accounting Manager",
      Address: "Taucherstraße 10",
      City: "Cunewalde",
      Region: "NULL",
      PostalCode: "01307",
      Country: "Germany",
      Phone: "0372-035188",
      Fax: "NULL"
    },
    {
      CustomerID: "RANCH",
      CompanyName: "Rancho grande",
      ContactName: "Sergio Gutiérrez",
      ContactTitle: "Sales Representative",
      Address: "Av. del Libertador 900",
      City: "Buenos Aires",
      Region: "NULL",
      PostalCode: 1010,
      Country: "Argentina",
      Phone: "(1) 123-5555",
      Fax: "(1) 123-5556"
    },
    {
      CustomerID: "RATTC",
      CompanyName: "Rattlesnake Canyon Grocery",
      ContactName: "Paula Wilson",
      ContactTitle: "Assistant Sales Representative",
      Address: "2817 Milton Dr.",
      City: "Albuquerque",
      Region: "NM",
      PostalCode: 87110,
      Country: "USA",
      Phone: "(505) 555-5939",
      Fax: "(505) 555-3620"
    },
    {
      CustomerID: "REGGC",
      CompanyName: "Reggiani Caseifici",
      ContactName: "Maurizio Moroni",
      ContactTitle: "Sales Associate",
      Address: "Strada Provinciale 124",
      City: "Reggio Emilia",
      Region: "NULL",
      PostalCode: 42100,
      Country: "Italy",
      Phone: "0522-556721",
      Fax: "0522-556722"
    },
    {
      CustomerID: "RICAR",
      CompanyName: "Ricardo Adocicados",
      ContactName: "Janete Limeira",
      ContactTitle: "Assistant Sales Agent",
      Address: "Av. Copacabana",
      City: 267,
      Region: "Rio de Janeiro",
      PostalCode: "RJ",
      Country: "02389-890",
      Phone: "Brazil",
      Fax: "(21) 555-3412"
    },
    {
      CustomerID: "RICSU",
      CompanyName: "Richter Supermarkt",
      ContactName: "Michael Holz",
      ContactTitle: "Sales Manager",
      Address: "Grenzacherweg 237",
      City: "Genève",
      Region: "NULL",
      PostalCode: 1203,
      Country: "Switzerland",
      Phone: "0897-034214",
      Fax: "NULL"
    },
    {
      CustomerID: "ROMEY",
      CompanyName: "Romero y tomillo",
      ContactName: "Alejandra Camino",
      ContactTitle: "Accounting Manager",
      Address: "Gran Vía",
      City: 1,
      Region: "Madrid",
      PostalCode: "NULL",
      Country: 28001,
      Phone: "Spain",
      Fax: "(91) 745 6200"
    },
    {
      CustomerID: "SANTG",
      CompanyName: "Santé Gourmet",
      ContactName: "Jonas Bergulfsen",
      ContactTitle: "Owner",
      Address: "Erling Skakkes gate 78",
      City: "Stavern",
      Region: "NULL",
      PostalCode: 4110,
      Country: "Norway",
      Phone: "07-98 92 35",
      Fax: "07-98 92 47"
    },
    {
      CustomerID: "SAVEA",
      CompanyName: "Save-a-lot Markets",
      ContactName: "Jose Pavarotti",
      ContactTitle: "Sales Representative",
      Address: "187 Suffolk Ln.",
      City: "Boise",
      Region: "ID",
      PostalCode: 83720,
      Country: "USA",
      Phone: "(208) 555-8097",
      Fax: "NULL"
    },
    {
      CustomerID: "SEVES",
      CompanyName: "Seven Seas Imports",
      ContactName: "Hari Kumar",
      ContactTitle: "Sales Manager",
      Address: "90 Wadhurst Rd.",
      City: "London",
      Region: "NULL",
      PostalCode: "OX15 4NB",
      Country: "UK",
      Phone: "(171) 555-1717",
      Fax: "(171) 555-5646"
    },
    {
      CustomerID: "SIMOB",
      CompanyName: "Simons bistro",
      ContactName: "Jytte Petersen",
      ContactTitle: "Owner",
      Address: "Vinbæltet 34",
      City: "Kobenhavn",
      Region: "NULL",
      PostalCode: 1734,
      Country: "Denmark",
      Phone: "31 12 34 56",
      Fax: "31 13 35 57"
    },
    {
      CustomerID: "SPECD",
      CompanyName: "Spécialités du monde",
      ContactName: "Dominique Perrier",
      ContactTitle: "Marketing Manager",
      Address: 25,
      City: "rue Lauriston",
      Region: "Paris",
      PostalCode: "NULL",
      Country: 75016,
      Phone: "France",
      Fax: "(1) 47.55.60.10"
    },
    {
      CustomerID: "SPLIR",
      CompanyName: "Split Rail Beer & Ale",
      ContactName: "Art Braunschweiger",
      ContactTitle: "Sales Manager",
      Address: "P.O. Box 555",
      City: "Lander",
      Region: "WY",
      PostalCode: 82520,
      Country: "USA",
      Phone: "(307) 555-4680",
      Fax: "(307) 555-6525"
    },
    {
      CustomerID: "SUPRD",
      CompanyName: "Suprêmes délices",
      ContactName: "Pascale Cartrain",
      ContactTitle: "Accounting Manager",
      Address: "Boulevard Tirou",
      City: 255,
      Region: "Charleroi",
      PostalCode: "NULL",
      Country: "B-6000",
      Phone: "Belgium",
      Fax: "(071) 23 67 22 20"
    },
    {
      CustomerID: "THEBI",
      CompanyName: "The Big Cheese",
      ContactName: "Liz Nixon",
      ContactTitle: "Marketing Manager",
      Address: "89 Jefferson Way Suite 2",
      City: "Portland",
      Region: "OR",
      PostalCode: 97201,
      Country: "USA",
      Phone: "(503) 555-3612",
      Fax: "NULL"
    },
    {
      CustomerID: "THECR",
      CompanyName: "The Cracker Box",
      ContactName: "Liu Wong",
      ContactTitle: "Marketing Assistant",
      Address: "55 Grizzly Peak Rd.",
      City: "Butte",
      Region: "MT",
      PostalCode: 59801,
      Country: "USA",
      Phone: "(406) 555-5834",
      Fax: "(406) 555-8083"
    },
    {
      CustomerID: "TOMSP",
      CompanyName: "Toms Spezialitäten",
      ContactName: "Karin Josephs",
      ContactTitle: "Marketing Manager",
      Address: "Luisenstr. 48",
      City: "Münster",
      Region: "NULL",
      PostalCode: 44087,
      Country: "Germany",
      Phone: "0251-031259",
      Fax: "0251-035695"
    },
    {
      CustomerID: "TORTU",
      CompanyName: "Tortuga Restaurante",
      ContactName: "Miguel Angel Paolino",
      ContactTitle: "Owner",
      Address: "Avda. Azteca 123",
      City: "México D.F.",
      Region: "NULL",
      PostalCode: "05033",
      Country: "Mexico",
      Phone: "(5) 555-2933",
      Fax: "NULL"
    },
    {
      CustomerID: "TRADH",
      CompanyName: "Tradição Hipermercados",
      ContactName: "Anabela Domingues",
      ContactTitle: "Sales Representative",
      Address: "Av. Inês de Castro",
      City: 414,
      Region: "Sao Paulo",
      PostalCode: "SP",
      Country: "05634-030",
      Phone: "Brazil",
      Fax: "(11) 555-2167"
    },
    {
      CustomerID: "TRAIH",
      CompanyName: "Trail's Head Gourmet Provisioners",
      ContactName: "Helvetius Nagy",
      ContactTitle: "Sales Associate",
      Address: "722 DaVinci Blvd.",
      City: "Kirkland",
      Region: "WA",
      PostalCode: 98034,
      Country: "USA",
      Phone: "(206) 555-8257",
      Fax: "(206) 555-2174"
    },
    {
      CustomerID: "VAFFE",
      CompanyName: "Vaffeljernet",
      ContactName: "Palle Ibsen",
      ContactTitle: "Sales Manager",
      Address: "Smagsloget 45",
      City: "Århus",
      Region: "NULL",
      PostalCode: 8200,
      Country: "Denmark",
      Phone: "86 21 32 43",
      Fax: "86 22 33 44"
    },
    {
      CustomerID: "VICTE",
      CompanyName: "Victuailles en stock",
      ContactName: "Mary Saveley",
      ContactTitle: "Sales Agent",
      Address: 2,
      City: "rue du Commerce",
      Region: "Lyon",
      PostalCode: "NULL",
      Country: 69004,
      Phone: "France",
      Fax: "78.32.54.86"
    },
    {
      CustomerID: "VINET",
      CompanyName: "Vins et alcools Chevalier",
      ContactName: "Paul Henriot",
      ContactTitle: "Accounting Manager",
      Address: "59 rue de l'Abbaye",
      City: "Reims",
      Region: "NULL",
      PostalCode: 51100,
      Country: "France",
      Phone: "26.47.15.10",
      Fax: "26.47.15.11"
    },
    {
      CustomerID: "WANDK",
      CompanyName: "Die Wandernde Kuh",
      ContactName: "Rita Müller",
      ContactTitle: "Sales Representative",
      Address: "Adenauerallee 900",
      City: "Stuttgart",
      Region: "NULL",
      PostalCode: 70563,
      Country: "Germany",
      Phone: "0711-020361",
      Fax: "0711-035428"
    },
    {
      CustomerID: "WARTH",
      CompanyName: "Wartian Herkku",
      ContactName: "Pirkko Koskitalo",
      ContactTitle: "Accounting Manager",
      Address: "Torikatu 38",
      City: "Oulu",
      Region: "NULL",
      PostalCode: 90110,
      Country: "Finland",
      Phone: "981-443655",
      Fax: "981-443655"
    },
    {
      CustomerID: "WELLI",
      CompanyName: "Wellington Importadora",
      ContactName: "Paula Parente",
      ContactTitle: "Sales Manager",
      Address: "Rua do Mercado",
      City: 12,
      Region: "Resende",
      PostalCode: "SP",
      Country: "08737-363",
      Phone: "Brazil",
      Fax: "(14) 555-8122"
    },
    {
      CustomerID: "WHITC",
      CompanyName: "White Clover Markets",
      ContactName: "Karl Jablonski",
      ContactTitle: "Owner",
      Address: "305 - 14th Ave. S. Suite 3B",
      City: "Seattle",
      Region: "WA",
      PostalCode: 98128,
      Country: "USA",
      Phone: "(206) 555-4112",
      Fax: "(206) 555-4115"
    },
    {
      CustomerID: "WILMK",
      CompanyName: "Wilman Kala",
      ContactName: "Matti Karttunen",
      ContactTitle: "Owner/Marketing Assistant",
      Address: "Keskuskatu 45",
      City: "Helsinki",
      Region: "NULL",
      PostalCode: 21240,
      Country: "Finland",
      Phone: "90-224 8858",
      Fax: "90-224 8858"
    },
    {
      CustomerID: "WOLZA",
      CompanyName: "Wolski  Zajazd",
      ContactName: "Zbyszek Piestrzeniewicz",
      ContactTitle: "Owner",
      Address: "ul. Filtrowa 68",
      City: "Warszawa",
      Region: "NULL",
      PostalCode: "01-012",
      Country: "Poland",
      Phone: "(26) 642-7012",
      Fax: "(26) 642-7012"
    }
  ];

  var products = [
    {
      ProductID: 1,
      ProductName: "Chai",
      SupplierID: 1,
      CategoryID: 1,
      QuantityPerUnit: "10 boxes x 20 bags",
      UnitPrice: 18,
      UnitsInStock: 39,
      UnitsOnOrder: 0,
      ReorderLevel: 10,
      Discontinued: 0
    },
    {
      ProductID: 2,
      ProductName: "Chang",
      SupplierID: 1,
      CategoryID: 1,
      QuantityPerUnit: "24 - 12 oz bottles",
      UnitPrice: 19,
      UnitsInStock: 17,
      UnitsOnOrder: 40,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 3,
      ProductName: "Aniseed Syrup",
      SupplierID: 1,
      CategoryID: 2,
      QuantityPerUnit: "12 - 550 ml bottles",
      UnitPrice: 10,
      UnitsInStock: 13,
      UnitsOnOrder: 70,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 4,
      ProductName: "Chef Anton's Cajun Seasoning",
      SupplierID: 2,
      CategoryID: 2,
      QuantityPerUnit: "48 - 6 oz jars",
      UnitPrice: 22,
      UnitsInStock: 53,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 5,
      ProductName: "Chef Anton's Gumbo Mix",
      SupplierID: 2,
      CategoryID: 2,
      QuantityPerUnit: "36 boxes",
      UnitPrice: 21.35,
      UnitsInStock: 0,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 6,
      ProductName: "Grandma's Boysenberry Spread",
      SupplierID: 3,
      CategoryID: 2,
      QuantityPerUnit: "12 - 8 oz jars",
      UnitPrice: 25,
      UnitsInStock: 120,
      UnitsOnOrder: 0,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 7,
      ProductName: "Uncle Bob's Organic Dried Pears",
      SupplierID: 3,
      CategoryID: 7,
      QuantityPerUnit: "12 - 1 lb pkgs.",
      UnitPrice: 30,
      UnitsInStock: 15,
      UnitsOnOrder: 0,
      ReorderLevel: 10,
      Discontinued: 0
    },
    {
      ProductID: 8,
      ProductName: "Northwoods Cranberry Sauce",
      SupplierID: 3,
      CategoryID: 2,
      QuantityPerUnit: "12 - 12 oz jars",
      UnitPrice: 40,
      UnitsInStock: 6,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 9,
      ProductName: "Mishi Kobe Niku",
      SupplierID: 4,
      CategoryID: 6,
      QuantityPerUnit: "18 - 500 g pkgs.",
      UnitPrice: 97,
      UnitsInStock: 29,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 10,
      ProductName: "Ikura",
      SupplierID: 4,
      CategoryID: 8,
      QuantityPerUnit: "12 - 200 ml jars",
      UnitPrice: 31,
      UnitsInStock: 31,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 11,
      ProductName: "Queso Cabrales",
      SupplierID: 5,
      CategoryID: 4,
      QuantityPerUnit: "1 kg pkg.",
      UnitPrice: 21,
      UnitsInStock: 22,
      UnitsOnOrder: 30,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 12,
      ProductName: "Queso Manchego La Pastora",
      SupplierID: 5,
      CategoryID: 4,
      QuantityPerUnit: "10 - 500 g pkgs.",
      UnitPrice: 38,
      UnitsInStock: 86,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 13,
      ProductName: "Konbu",
      SupplierID: 6,
      CategoryID: 8,
      QuantityPerUnit: "2 kg box",
      UnitPrice: 6,
      UnitsInStock: 24,
      UnitsOnOrder: 0,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 14,
      ProductName: "Tofu",
      SupplierID: 6,
      CategoryID: 7,
      QuantityPerUnit: "40 - 100 g pkgs.",
      UnitPrice: 23.25,
      UnitsInStock: 35,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 15,
      ProductName: "Genen Shouyu",
      SupplierID: 6,
      CategoryID: 2,
      QuantityPerUnit: "24 - 250 ml bottles",
      UnitPrice: 15.5,
      UnitsInStock: 39,
      UnitsOnOrder: 0,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 16,
      ProductName: "Pavlova",
      SupplierID: 7,
      CategoryID: 3,
      QuantityPerUnit: "32 - 500 g boxes",
      UnitPrice: 17.45,
      UnitsInStock: 29,
      UnitsOnOrder: 0,
      ReorderLevel: 10,
      Discontinued: 0
    },
    {
      ProductID: 17,
      ProductName: "Alice Mutton",
      SupplierID: 7,
      CategoryID: 6,
      QuantityPerUnit: "20 - 1 kg tins",
      UnitPrice: 39,
      UnitsInStock: 0,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 18,
      ProductName: "Carnarvon Tigers",
      SupplierID: 7,
      CategoryID: 8,
      QuantityPerUnit: "16 kg pkg.",
      UnitPrice: 62.5,
      UnitsInStock: 42,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 19,
      ProductName: "Teatime Chocolate Biscuits",
      SupplierID: 8,
      CategoryID: 3,
      QuantityPerUnit: "10 boxes x 12 pieces",
      UnitPrice: 9.2,
      UnitsInStock: 25,
      UnitsOnOrder: 0,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 20,
      ProductName: "Sir Rodney's Marmalade",
      SupplierID: 8,
      CategoryID: 3,
      QuantityPerUnit: "30 gift boxes",
      UnitPrice: 81,
      UnitsInStock: 40,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 21,
      ProductName: "Sir Rodney's Scones",
      SupplierID: 8,
      CategoryID: 3,
      QuantityPerUnit: "24 pkgs. x 4 pieces",
      UnitPrice: 10,
      UnitsInStock: 3,
      UnitsOnOrder: 40,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 22,
      ProductName: "Gustaf's Knäckebröd",
      SupplierID: 9,
      CategoryID: 5,
      QuantityPerUnit: "24 - 500 g pkgs.",
      UnitPrice: 21,
      UnitsInStock: 104,
      UnitsOnOrder: 0,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 23,
      ProductName: "Tunnbröd",
      SupplierID: 9,
      CategoryID: 5,
      QuantityPerUnit: "12 - 250 g pkgs.",
      UnitPrice: 9,
      UnitsInStock: 61,
      UnitsOnOrder: 0,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 24,
      ProductName: "Guaraná Fantástica",
      SupplierID: 10,
      CategoryID: 1,
      QuantityPerUnit: "12 - 355 ml cans",
      UnitPrice: 4.5,
      UnitsInStock: 20,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 25,
      ProductName: "NuNuCa Nuß-Nougat-Creme",
      SupplierID: 11,
      CategoryID: 3,
      QuantityPerUnit: "20 - 450 g glasses",
      UnitPrice: 14,
      UnitsInStock: 76,
      UnitsOnOrder: 0,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 26,
      ProductName: "Gumbär Gummibärchen",
      SupplierID: 11,
      CategoryID: 3,
      QuantityPerUnit: "100 - 250 g bags",
      UnitPrice: 31.23,
      UnitsInStock: 15,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 27,
      ProductName: "Schoggi Schokolade",
      SupplierID: 11,
      CategoryID: 3,
      QuantityPerUnit: "100 - 100 g pieces",
      UnitPrice: 43.9,
      UnitsInStock: 49,
      UnitsOnOrder: 0,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 28,
      ProductName: "Rössle Sauerkraut",
      SupplierID: 12,
      CategoryID: 7,
      QuantityPerUnit: "25 - 825 g cans",
      UnitPrice: 45.6,
      UnitsInStock: 26,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 29,
      ProductName: "Thüringer Rostbratwurst",
      SupplierID: 12,
      CategoryID: 6,
      QuantityPerUnit: "50 bags x 30 sausgs.",
      UnitPrice: 123.79,
      UnitsInStock: 0,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 30,
      ProductName: "Nord-Ost Matjeshering",
      SupplierID: 13,
      CategoryID: 8,
      QuantityPerUnit: "10 - 200 g glasses",
      UnitPrice: 25.89,
      UnitsInStock: 10,
      UnitsOnOrder: 0,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 31,
      ProductName: "Gorgonzola Telino",
      SupplierID: 14,
      CategoryID: 4,
      QuantityPerUnit: "12 - 100 g pkgs",
      UnitPrice: 12.5,
      UnitsInStock: 0,
      UnitsOnOrder: 70,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 32,
      ProductName: "Mascarpone Fabioli",
      SupplierID: 14,
      CategoryID: 4,
      QuantityPerUnit: "24 - 200 g pkgs.",
      UnitPrice: 32,
      UnitsInStock: 9,
      UnitsOnOrder: 40,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 33,
      ProductName: "Geitost",
      SupplierID: 15,
      CategoryID: 4,
      QuantityPerUnit: "500 g",
      UnitPrice: 2.5,
      UnitsInStock: 112,
      UnitsOnOrder: 0,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 34,
      ProductName: "Sasquatch Ale",
      SupplierID: 16,
      CategoryID: 1,
      QuantityPerUnit: "24 - 12 oz bottles",
      UnitPrice: 14,
      UnitsInStock: 111,
      UnitsOnOrder: 0,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 35,
      ProductName: "Steeleye Stout",
      SupplierID: 16,
      CategoryID: 1,
      QuantityPerUnit: "24 - 12 oz bottles",
      UnitPrice: 18,
      UnitsInStock: 20,
      UnitsOnOrder: 0,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 36,
      ProductName: "Inlagd Sill",
      SupplierID: 17,
      CategoryID: 8,
      QuantityPerUnit: "24 - 250 g  jars",
      UnitPrice: 19,
      UnitsInStock: 112,
      UnitsOnOrder: 0,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 37,
      ProductName: "Gravad lax",
      SupplierID: 17,
      CategoryID: 8,
      QuantityPerUnit: "12 - 500 g pkgs.",
      UnitPrice: 26,
      UnitsInStock: 11,
      UnitsOnOrder: 50,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 38,
      ProductName: "Côte de Blaye",
      SupplierID: 18,
      CategoryID: 1,
      QuantityPerUnit: "12 - 75 cl bottles",
      UnitPrice: 263.5,
      UnitsInStock: 17,
      UnitsOnOrder: 0,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 39,
      ProductName: "Chartreuse verte",
      SupplierID: 18,
      CategoryID: 1,
      QuantityPerUnit: "750 cc per bottle",
      UnitPrice: 18,
      UnitsInStock: 69,
      UnitsOnOrder: 0,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 40,
      ProductName: "Boston Crab Meat",
      SupplierID: 19,
      CategoryID: 8,
      QuantityPerUnit: "24 - 4 oz tins",
      UnitPrice: 18.4,
      UnitsInStock: 123,
      UnitsOnOrder: 0,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 41,
      ProductName: "Jack's New England Clam Chowder",
      SupplierID: 19,
      CategoryID: 8,
      QuantityPerUnit: "12 - 12 oz cans",
      UnitPrice: 9.65,
      UnitsInStock: 85,
      UnitsOnOrder: 0,
      ReorderLevel: 10,
      Discontinued: 0
    },
    {
      ProductID: 42,
      ProductName: "Singaporean Hokkien Fried Mee",
      SupplierID: 20,
      CategoryID: 5,
      QuantityPerUnit: "32 - 1 kg pkgs.",
      UnitPrice: 14,
      UnitsInStock: 26,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 43,
      ProductName: "Ipoh Coffee",
      SupplierID: 20,
      CategoryID: 1,
      QuantityPerUnit: "16 - 500 g tins",
      UnitPrice: 46,
      UnitsInStock: 17,
      UnitsOnOrder: 10,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 44,
      ProductName: "Gula Malacca",
      SupplierID: 20,
      CategoryID: 2,
      QuantityPerUnit: "20 - 2 kg bags",
      UnitPrice: 19.45,
      UnitsInStock: 27,
      UnitsOnOrder: 0,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 45,
      ProductName: "Rogede sild",
      SupplierID: 21,
      CategoryID: 8,
      QuantityPerUnit: "1k pkg.",
      UnitPrice: 9.5,
      UnitsInStock: 5,
      UnitsOnOrder: 70,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 46,
      ProductName: "Spegesild",
      SupplierID: 21,
      CategoryID: 8,
      QuantityPerUnit: "4 - 450 g glasses",
      UnitPrice: 12,
      UnitsInStock: 95,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 47,
      ProductName: "Zaanse koeken",
      SupplierID: 22,
      CategoryID: 3,
      QuantityPerUnit: "10 - 4 oz boxes",
      UnitPrice: 9.5,
      UnitsInStock: 36,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 48,
      ProductName: "Chocolade",
      SupplierID: 22,
      CategoryID: 3,
      QuantityPerUnit: "10 pkgs.",
      UnitPrice: 12.75,
      UnitsInStock: 15,
      UnitsOnOrder: 70,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 49,
      ProductName: "Maxilaku",
      SupplierID: 23,
      CategoryID: 3,
      QuantityPerUnit: "24 - 50 g pkgs.",
      UnitPrice: 20,
      UnitsInStock: 10,
      UnitsOnOrder: 60,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 50,
      ProductName: "Valkoinen suklaa",
      SupplierID: 23,
      CategoryID: 3,
      QuantityPerUnit: "12 - 100 g bars",
      UnitPrice: 16.25,
      UnitsInStock: 65,
      UnitsOnOrder: 0,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 51,
      ProductName: "Manjimup Dried Apples",
      SupplierID: 24,
      CategoryID: 7,
      QuantityPerUnit: "50 - 300 g pkgs.",
      UnitPrice: 53,
      UnitsInStock: 20,
      UnitsOnOrder: 0,
      ReorderLevel: 10,
      Discontinued: 0
    },
    {
      ProductID: 52,
      ProductName: "Filo Mix",
      SupplierID: 24,
      CategoryID: 5,
      QuantityPerUnit: "16 - 2 kg boxes",
      UnitPrice: 7,
      UnitsInStock: 38,
      UnitsOnOrder: 0,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 53,
      ProductName: "Perth Pasties",
      SupplierID: 24,
      CategoryID: 6,
      QuantityPerUnit: "48 pieces",
      UnitPrice: 32.8,
      UnitsInStock: 0,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 1
    },
    {
      ProductID: 54,
      ProductName: "Tourtière",
      SupplierID: 25,
      CategoryID: 6,
      QuantityPerUnit: "16 pies",
      UnitPrice: 7.45,
      UnitsInStock: 21,
      UnitsOnOrder: 0,
      ReorderLevel: 10,
      Discontinued: 0
    },
    {
      ProductID: 55,
      ProductName: "Pâté chinois",
      SupplierID: 25,
      CategoryID: 6,
      QuantityPerUnit: "24 boxes x 2 pies",
      UnitPrice: 24,
      UnitsInStock: 115,
      UnitsOnOrder: 0,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 56,
      ProductName: "Gnocchi di nonna Alice",
      SupplierID: 26,
      CategoryID: 5,
      QuantityPerUnit: "24 - 250 g pkgs.",
      UnitPrice: 38,
      UnitsInStock: 21,
      UnitsOnOrder: 10,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 57,
      ProductName: "Ravioli Angelo",
      SupplierID: 26,
      CategoryID: 5,
      QuantityPerUnit: "24 - 250 g pkgs.",
      UnitPrice: 19.5,
      UnitsInStock: 36,
      UnitsOnOrder: 0,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 58,
      ProductName: "Escargots de Bourgogne",
      SupplierID: 27,
      CategoryID: 8,
      QuantityPerUnit: "24 pieces",
      UnitPrice: 13.25,
      UnitsInStock: 62,
      UnitsOnOrder: 0,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 59,
      ProductName: "Raclette Courdavault",
      SupplierID: 28,
      CategoryID: 4,
      QuantityPerUnit: "5 kg pkg.",
      UnitPrice: 55,
      UnitsInStock: 79,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 60,
      ProductName: "Camembert Pierrot",
      SupplierID: 28,
      CategoryID: 4,
      QuantityPerUnit: "15 - 300 g rounds",
      UnitPrice: 34,
      UnitsInStock: 19,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 61,
      ProductName: "Sirop d'érable",
      SupplierID: 29,
      CategoryID: 2,
      QuantityPerUnit: "24 - 500 ml bottles",
      UnitPrice: 28.5,
      UnitsInStock: 113,
      UnitsOnOrder: 0,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 62,
      ProductName: "Tarte au sucre",
      SupplierID: 29,
      CategoryID: 3,
      QuantityPerUnit: "48 pies",
      UnitPrice: 49.3,
      UnitsInStock: 17,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 63,
      ProductName: "Vegie-spread",
      SupplierID: 7,
      CategoryID: 2,
      QuantityPerUnit: "15 - 625 g jars",
      UnitPrice: 43.9,
      UnitsInStock: 24,
      UnitsOnOrder: 0,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 64,
      ProductName: "Wimmers gute Semmelknödel",
      SupplierID: 12,
      CategoryID: 5,
      QuantityPerUnit: "20 bags x 4 pieces",
      UnitPrice: 33.25,
      UnitsInStock: 22,
      UnitsOnOrder: 80,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 65,
      ProductName: "Louisiana Fiery Hot Pepper Sauce",
      SupplierID: 2,
      CategoryID: 2,
      QuantityPerUnit: "32 - 8 oz bottles",
      UnitPrice: 21.05,
      UnitsInStock: 76,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 66,
      ProductName: "Louisiana Hot Spiced Okra",
      SupplierID: 2,
      CategoryID: 2,
      QuantityPerUnit: "24 - 8 oz jars",
      UnitPrice: 17,
      UnitsInStock: 4,
      UnitsOnOrder: 100,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 67,
      ProductName: "Laughing Lumberjack Lager",
      SupplierID: 16,
      CategoryID: 1,
      QuantityPerUnit: "24 - 12 oz bottles",
      UnitPrice: 14,
      UnitsInStock: 52,
      UnitsOnOrder: 0,
      ReorderLevel: 10,
      Discontinued: 0
    },
    {
      ProductID: 68,
      ProductName: "Scottish Longbreads",
      SupplierID: 8,
      CategoryID: 3,
      QuantityPerUnit: "10 boxes x 8 pieces",
      UnitPrice: 12.5,
      UnitsInStock: 6,
      UnitsOnOrder: 10,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 69,
      ProductName: "Gudbrandsdalsost",
      SupplierID: 15,
      CategoryID: 4,
      QuantityPerUnit: "10 kg pkg.",
      UnitPrice: 36,
      UnitsInStock: 26,
      UnitsOnOrder: 0,
      ReorderLevel: 15,
      Discontinued: 0
    },
    {
      ProductID: 70,
      ProductName: "Outback Lager",
      SupplierID: 7,
      CategoryID: 1,
      QuantityPerUnit: "24 - 355 ml bottles",
      UnitPrice: 15,
      UnitsInStock: 15,
      UnitsOnOrder: 10,
      ReorderLevel: 30,
      Discontinued: 0
    },
    {
      ProductID: 71,
      ProductName: "Flotemysost",
      SupplierID: 15,
      CategoryID: 4,
      QuantityPerUnit: "10 - 500 g pkgs.",
      UnitPrice: 21.5,
      UnitsInStock: 26,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 72,
      ProductName: "Mozzarella di Giovanni",
      SupplierID: 14,
      CategoryID: 4,
      QuantityPerUnit: "24 - 200 g pkgs.",
      UnitPrice: 34.8,
      UnitsInStock: 14,
      UnitsOnOrder: 0,
      ReorderLevel: 0,
      Discontinued: 0
    },
    {
      ProductID: 73,
      ProductName: "Röd Kaviar",
      SupplierID: 17,
      CategoryID: 8,
      QuantityPerUnit: "24 - 150 g jars",
      UnitPrice: 15,
      UnitsInStock: 101,
      UnitsOnOrder: 0,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 74,
      ProductName: "Longlife Tofu",
      SupplierID: 4,
      CategoryID: 7,
      QuantityPerUnit: "5 kg pkg.",
      UnitPrice: 10,
      UnitsInStock: 4,
      UnitsOnOrder: 20,
      ReorderLevel: 5,
      Discontinued: 0
    },
    {
      ProductID: 75,
      ProductName: "Rhönbräu Klosterbier",
      SupplierID: 12,
      CategoryID: 1,
      QuantityPerUnit: "24 - 0.5 l bottles",
      UnitPrice: 7.75,
      UnitsInStock: 125,
      UnitsOnOrder: 0,
      ReorderLevel: 25,
      Discontinued: 0
    },
    {
      ProductID: 76,
      ProductName: "Lakkalikööri",
      SupplierID: 23,
      CategoryID: 1,
      QuantityPerUnit: "500 ml",
      UnitPrice: 18,
      UnitsInStock: 57,
      UnitsOnOrder: 0,
      ReorderLevel: 20,
      Discontinued: 0
    },
    {
      ProductID: 77,
      ProductName: "Original Frankfurter grüne Soße",
      SupplierID: 12,
      CategoryID: 2,
      QuantityPerUnit: "12 boxes",
      UnitPrice: 13,
      UnitsInStock: 32,
      UnitsOnOrder: 0,
      ReorderLevel: 15,
      Discontinued: 0
    }
  ];

  var orders = [
    {
      OrderID: 10248,
      CustomerID: "VINET",
      EmployeeID: 5,
      OrderDate: "1996-07-04 00:00:00.000",
      RequiredDate: "1996-08-01 00:00:00.000",
      ShippedDate: "1996-07-16 00:00:00.000",
      ShipVia: 3,
      Freight: 32.38,
      ShipName: "Vins et alcools Chevalier",
      ShipAddress: "59 rue de l'Abbaye",
      ShipCity: "Reims",
      ShipRegion: "NULL",
      ShipPostalCode: 51100,
      ShipCountry: "France"
    },
    {
      OrderID: 10249,
      CustomerID: "TOMSP",
      EmployeeID: 6,
      OrderDate: "1996-07-05 00:00:00.000",
      RequiredDate: "1996-08-16 00:00:00.000",
      ShippedDate: "1996-07-10 00:00:00.000",
      ShipVia: 1,
      Freight: 11.61,
      ShipName: "Toms Spezialitäten",
      ShipAddress: "Luisenstr. 48",
      ShipCity: "Münster",
      ShipRegion: "NULL",
      ShipPostalCode: 44087,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10250,
      CustomerID: "HANAR",
      EmployeeID: 4,
      OrderDate: "1996-07-08 00:00:00.000",
      RequiredDate: "1996-08-05 00:00:00.000",
      ShippedDate: "1996-07-12 00:00:00.000",
      ShipVia: 2,
      Freight: 65.83,
      ShipName: "Hanari Carnes",
      ShipAddress: "Rua do Paço",
      ShipCity: 67,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "05454-876"
    },
    {
      OrderID: 10251,
      CustomerID: "VICTE",
      EmployeeID: 3,
      OrderDate: "1996-07-08 00:00:00.000",
      RequiredDate: "1996-08-05 00:00:00.000",
      ShippedDate: "1996-07-15 00:00:00.000",
      ShipVia: 1,
      Freight: 41.34,
      ShipName: "Victuailles en stock",
      ShipAddress: 2,
      ShipCity: "rue du Commerce",
      ShipRegion: "Lyon",
      ShipPostalCode: "NULL",
      ShipCountry: 69004
    },
    {
      OrderID: 10252,
      CustomerID: "SUPRD",
      EmployeeID: 4,
      OrderDate: "1996-07-09 00:00:00.000",
      RequiredDate: "1996-08-06 00:00:00.000",
      ShippedDate: "1996-07-11 00:00:00.000",
      ShipVia: 2,
      Freight: 51.3,
      ShipName: "Suprêmes délices",
      ShipAddress: "Boulevard Tirou",
      ShipCity: 255,
      ShipRegion: "Charleroi",
      ShipPostalCode: "NULL",
      ShipCountry: "B-6000"
    },
    {
      OrderID: 10253,
      CustomerID: "HANAR",
      EmployeeID: 3,
      OrderDate: "1996-07-10 00:00:00.000",
      RequiredDate: "1996-07-24 00:00:00.000",
      ShippedDate: "1996-07-16 00:00:00.000",
      ShipVia: 2,
      Freight: 58.17,
      ShipName: "Hanari Carnes",
      ShipAddress: "Rua do Paço",
      ShipCity: 67,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "05454-876"
    },
    {
      OrderID: 10254,
      CustomerID: "CHOPS",
      EmployeeID: 5,
      OrderDate: "1996-07-11 00:00:00.000",
      RequiredDate: "1996-08-08 00:00:00.000",
      ShippedDate: "1996-07-23 00:00:00.000",
      ShipVia: 2,
      Freight: 22.98,
      ShipName: "Chop-suey Chinese",
      ShipAddress: "Hauptstr. 31",
      ShipCity: "Bern",
      ShipRegion: "NULL",
      ShipPostalCode: 3012,
      ShipCountry: "Switzerland"
    },
    {
      OrderID: 10255,
      CustomerID: "RICSU",
      EmployeeID: 9,
      OrderDate: "1996-07-12 00:00:00.000",
      RequiredDate: "1996-08-09 00:00:00.000",
      ShippedDate: "1996-07-15 00:00:00.000",
      ShipVia: 3,
      Freight: 148.33,
      ShipName: "Richter Supermarkt",
      ShipAddress: "Starenweg 5",
      ShipCity: "Genève",
      ShipRegion: "NULL",
      ShipPostalCode: 1204,
      ShipCountry: "Switzerland"
    },
    {
      OrderID: 10256,
      CustomerID: "WELLI",
      EmployeeID: 3,
      OrderDate: "1996-07-15 00:00:00.000",
      RequiredDate: "1996-08-12 00:00:00.000",
      ShippedDate: "1996-07-17 00:00:00.000",
      ShipVia: 2,
      Freight: 13.97,
      ShipName: "Wellington Importadora",
      ShipAddress: "Rua do Mercado",
      ShipCity: 12,
      ShipRegion: "Resende",
      ShipPostalCode: "SP",
      ShipCountry: "08737-363"
    },
    {
      OrderID: 10257,
      CustomerID: "HILAA",
      EmployeeID: 4,
      OrderDate: "1996-07-16 00:00:00.000",
      RequiredDate: "1996-08-13 00:00:00.000",
      ShippedDate: "1996-07-22 00:00:00.000",
      ShipVia: 3,
      Freight: 81.91,
      ShipName: "HILARION-Abastos",
      ShipAddress: "Carrera 22 con Ave. Carlos Soublette #8-35",
      ShipCity: "San Cristóbal",
      ShipRegion: "Táchira",
      ShipPostalCode: 5022,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10258,
      CustomerID: "ERNSH",
      EmployeeID: 1,
      OrderDate: "1996-07-17 00:00:00.000",
      RequiredDate: "1996-08-14 00:00:00.000",
      ShippedDate: "1996-07-23 00:00:00.000",
      ShipVia: 1,
      Freight: 140.51,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10259,
      CustomerID: "CENTC",
      EmployeeID: 4,
      OrderDate: "1996-07-18 00:00:00.000",
      RequiredDate: "1996-08-15 00:00:00.000",
      ShippedDate: "1996-07-25 00:00:00.000",
      ShipVia: 3,
      Freight: 3.25,
      ShipName: "Centro comercial Moctezuma",
      ShipAddress: "Sierras de Granada 9993",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05022",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10260,
      CustomerID: "OTTIK",
      EmployeeID: 4,
      OrderDate: "1996-07-19 00:00:00.000",
      RequiredDate: "1996-08-16 00:00:00.000",
      ShippedDate: "1996-07-29 00:00:00.000",
      ShipVia: 1,
      Freight: 55.09,
      ShipName: "Ottilies Käseladen",
      ShipAddress: "Mehrheimerstr. 369",
      ShipCity: "Köln",
      ShipRegion: "NULL",
      ShipPostalCode: 50739,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10261,
      CustomerID: "QUEDE",
      EmployeeID: 4,
      OrderDate: "1996-07-19 00:00:00.000",
      RequiredDate: "1996-08-16 00:00:00.000",
      ShippedDate: "1996-07-30 00:00:00.000",
      ShipVia: 2,
      Freight: 3.05,
      ShipName: "Que Delícia",
      ShipAddress: "Rua da Panificadora",
      ShipCity: 12,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-673"
    },
    {
      OrderID: 10262,
      CustomerID: "RATTC",
      EmployeeID: 8,
      OrderDate: "1996-07-22 00:00:00.000",
      RequiredDate: "1996-08-19 00:00:00.000",
      ShippedDate: "1996-07-25 00:00:00.000",
      ShipVia: 3,
      Freight: 48.29,
      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-23 00:00:00.000",
      RequiredDate: "1996-08-20 00:00:00.000",
      ShippedDate: "1996-07-31 00:00:00.000",
      ShipVia: 3,
      Freight: 146.06,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10264,
      CustomerID: "FOLKO",
      EmployeeID: 6,
      OrderDate: "1996-07-24 00:00:00.000",
      RequiredDate: "1996-08-21 00:00:00.000",
      ShippedDate: "1996-08-23 00:00:00.000",
      ShipVia: 3,
      Freight: 3.67,
      ShipName: "Folk och fä HB",
      ShipAddress: "Åkergatan 24",
      ShipCity: "Bräcke",
      ShipRegion: "NULL",
      ShipPostalCode: "S-844 67",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10265,
      CustomerID: "BLONP",
      EmployeeID: 2,
      OrderDate: "1996-07-25 00:00:00.000",
      RequiredDate: "1996-08-22 00:00:00.000",
      ShippedDate: "1996-08-12 00:00:00.000",
      ShipVia: 1,
      Freight: 55.28,
      ShipName: "Blondel père et fils",
      ShipAddress: 24,
      ShipCity: "place Kléber",
      ShipRegion: "Strasbourg",
      ShipPostalCode: "NULL",
      ShipCountry: 67000
    },
    {
      OrderID: 10266,
      CustomerID: "WARTH",
      EmployeeID: 3,
      OrderDate: "1996-07-26 00:00:00.000",
      RequiredDate: "1996-09-06 00:00:00.000",
      ShippedDate: "1996-07-31 00:00:00.000",
      ShipVia: 3,
      Freight: 25.73,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10267,
      CustomerID: "FRANK",
      EmployeeID: 4,
      OrderDate: "1996-07-29 00:00:00.000",
      RequiredDate: "1996-08-26 00:00:00.000",
      ShippedDate: "1996-08-06 00:00:00.000",
      ShipVia: 1,
      Freight: 208.58,
      ShipName: "Frankenversand",
      ShipAddress: "Berliner Platz 43",
      ShipCity: "München",
      ShipRegion: "NULL",
      ShipPostalCode: 80805,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10268,
      CustomerID: "GROSR",
      EmployeeID: 8,
      OrderDate: "1996-07-30 00:00:00.000",
      RequiredDate: "1996-08-27 00:00:00.000",
      ShippedDate: "1996-08-02 00:00:00.000",
      ShipVia: 3,
      Freight: 66.29,
      ShipName: "GROSELLA-Restaurante",
      ShipAddress: "5ª Ave. Los Palos Grandes",
      ShipCity: "Caracas",
      ShipRegion: "DF",
      ShipPostalCode: 1081,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10269,
      CustomerID: "WHITC",
      EmployeeID: 5,
      OrderDate: "1996-07-31 00:00:00.000",
      RequiredDate: "1996-08-14 00:00:00.000",
      ShippedDate: "1996-08-09 00:00:00.000",
      ShipVia: 1,
      Freight: 4.56,
      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-01 00:00:00.000",
      RequiredDate: "1996-08-29 00:00:00.000",
      ShippedDate: "1996-08-02 00:00:00.000",
      ShipVia: 1,
      Freight: 136.54,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10271,
      CustomerID: "SPLIR",
      EmployeeID: 6,
      OrderDate: "1996-08-01 00:00:00.000",
      RequiredDate: "1996-08-29 00:00:00.000",
      ShippedDate: "1996-08-30 00:00:00.000",
      ShipVia: 2,
      Freight: 4.54,
      ShipName: "Split Rail Beer & Ale",
      ShipAddress: "P.O. Box 555",
      ShipCity: "Lander",
      ShipRegion: "WY",
      ShipPostalCode: 82520,
      ShipCountry: "USA"
    },
    {
      OrderID: 10272,
      CustomerID: "RATTC",
      EmployeeID: 6,
      OrderDate: "1996-08-02 00:00:00.000",
      RequiredDate: "1996-08-30 00:00:00.000",
      ShippedDate: "1996-08-06 00:00:00.000",
      ShipVia: 2,
      Freight: 98.03,
      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-05 00:00:00.000",
      RequiredDate: "1996-09-02 00:00:00.000",
      ShippedDate: "1996-08-12 00:00:00.000",
      ShipVia: 3,
      Freight: 76.07,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10274,
      CustomerID: "VINET",
      EmployeeID: 6,
      OrderDate: "1996-08-06 00:00:00.000",
      RequiredDate: "1996-09-03 00:00:00.000",
      ShippedDate: "1996-08-16 00:00:00.000",
      ShipVia: 1,
      Freight: 6.01,
      ShipName: "Vins et alcools Chevalier",
      ShipAddress: "59 rue de l'Abbaye",
      ShipCity: "Reims",
      ShipRegion: "NULL",
      ShipPostalCode: 51100,
      ShipCountry: "France"
    },
    {
      OrderID: 10275,
      CustomerID: "MAGAA",
      EmployeeID: 1,
      OrderDate: "1996-08-07 00:00:00.000",
      RequiredDate: "1996-09-04 00:00:00.000",
      ShippedDate: "1996-08-09 00:00:00.000",
      ShipVia: 1,
      Freight: 26.93,
      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-08 00:00:00.000",
      RequiredDate: "1996-08-22 00:00:00.000",
      ShippedDate: "1996-08-14 00:00:00.000",
      ShipVia: 3,
      Freight: 13.84,
      ShipName: "Tortuga Restaurante",
      ShipAddress: "Avda. Azteca 123",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10277,
      CustomerID: "MORGK",
      EmployeeID: 2,
      OrderDate: "1996-08-09 00:00:00.000",
      RequiredDate: "1996-09-06 00:00:00.000",
      ShippedDate: "1996-08-13 00:00:00.000",
      ShipVia: 3,
      Freight: 125.77,
      ShipName: "Morgenstern Gesundkost",
      ShipAddress: "Heerstr. 22",
      ShipCity: "Leipzig",
      ShipRegion: "NULL",
      ShipPostalCode: "04179",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10278,
      CustomerID: "BERGS",
      EmployeeID: 8,
      OrderDate: "1996-08-12 00:00:00.000",
      RequiredDate: "1996-09-09 00:00:00.000",
      ShippedDate: "1996-08-16 00:00:00.000",
      ShipVia: 2,
      Freight: 92.69,
      ShipName: "Berglunds snabbköp",
      ShipAddress: "Berguvsvägen  8",
      ShipCity: "Luleå",
      ShipRegion: "NULL",
      ShipPostalCode: "S-958 22",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10279,
      CustomerID: "LEHMS",
      EmployeeID: 8,
      OrderDate: "1996-08-13 00:00:00.000",
      RequiredDate: "1996-09-10 00:00:00.000",
      ShippedDate: "1996-08-16 00:00:00.000",
      ShipVia: 2,
      Freight: 25.83,
      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-14 00:00:00.000",
      RequiredDate: "1996-09-11 00:00:00.000",
      ShippedDate: "1996-09-12 00:00:00.000",
      ShipVia: 1,
      Freight: 8.98,
      ShipName: "Berglunds snabbköp",
      ShipAddress: "Berguvsvägen  8",
      ShipCity: "Luleå",
      ShipRegion: "NULL",
      ShipPostalCode: "S-958 22",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10281,
      CustomerID: "ROMEY",
      EmployeeID: 4,
      OrderDate: "1996-08-14 00:00:00.000",
      RequiredDate: "1996-08-28 00:00:00.000",
      ShippedDate: "1996-08-21 00:00:00.000",
      ShipVia: 1,
      Freight: 2.94,
      ShipName: "Romero y tomillo",
      ShipAddress: "Gran Vía",
      ShipCity: 1,
      ShipRegion: "Madrid",
      ShipPostalCode: "NULL",
      ShipCountry: 28001
    },
    {
      OrderID: 10282,
      CustomerID: "ROMEY",
      EmployeeID: 4,
      OrderDate: "1996-08-15 00:00:00.000",
      RequiredDate: "1996-09-12 00:00:00.000",
      ShippedDate: "1996-08-21 00:00:00.000",
      ShipVia: 1,
      Freight: 12.69,
      ShipName: "Romero y tomillo",
      ShipAddress: "Gran Vía",
      ShipCity: 1,
      ShipRegion: "Madrid",
      ShipPostalCode: "NULL",
      ShipCountry: 28001
    },
    {
      OrderID: 10283,
      CustomerID: "LILAS",
      EmployeeID: 3,
      OrderDate: "1996-08-16 00:00:00.000",
      RequiredDate: "1996-09-13 00:00:00.000",
      ShippedDate: "1996-08-23 00:00:00.000",
      ShipVia: 3,
      Freight: 84.81,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10284,
      CustomerID: "LEHMS",
      EmployeeID: 4,
      OrderDate: "1996-08-19 00:00:00.000",
      RequiredDate: "1996-09-16 00:00:00.000",
      ShippedDate: "1996-08-27 00:00:00.000",
      ShipVia: 1,
      Freight: 76.56,
      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-20 00:00:00.000",
      RequiredDate: "1996-09-17 00:00:00.000",
      ShippedDate: "1996-08-26 00:00:00.000",
      ShipVia: 2,
      Freight: 76.83,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10286,
      CustomerID: "QUICK",
      EmployeeID: 8,
      OrderDate: "1996-08-21 00:00:00.000",
      RequiredDate: "1996-09-18 00:00:00.000",
      ShippedDate: "1996-08-30 00:00:00.000",
      ShipVia: 3,
      Freight: 229.24,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10287,
      CustomerID: "RICAR",
      EmployeeID: 8,
      OrderDate: "1996-08-22 00:00:00.000",
      RequiredDate: "1996-09-19 00:00:00.000",
      ShippedDate: "1996-08-28 00:00:00.000",
      ShipVia: 3,
      Freight: 12.76,
      ShipName: "Ricardo Adocicados",
      ShipAddress: "Av. Copacabana",
      ShipCity: 267,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-890"
    },
    {
      OrderID: 10288,
      CustomerID: "REGGC",
      EmployeeID: 4,
      OrderDate: "1996-08-23 00:00:00.000",
      RequiredDate: "1996-09-20 00:00:00.000",
      ShippedDate: "1996-09-03 00:00:00.000",
      ShipVia: 1,
      Freight: 7.45,
      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-26 00:00:00.000",
      RequiredDate: "1996-09-23 00:00:00.000",
      ShippedDate: "1996-08-28 00:00:00.000",
      ShipVia: 3,
      Freight: 22.77,
      ShipName: "B's Beverages",
      ShipAddress: "Fauntleroy Circus",
      ShipCity: "London",
      ShipRegion: "NULL",
      ShipPostalCode: "EC2 5NT",
      ShipCountry: "UK"
    },
    {
      OrderID: 10290,
      CustomerID: "COMMI",
      EmployeeID: 8,
      OrderDate: "1996-08-27 00:00:00.000",
      RequiredDate: "1996-09-24 00:00:00.000",
      ShippedDate: "1996-09-03 00:00:00.000",
      ShipVia: 1,
      Freight: 79.7,
      ShipName: "Comércio Mineiro",
      ShipAddress: "Av. dos Lusíadas",
      ShipCity: 23,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05432-043"
    },
    {
      OrderID: 10291,
      CustomerID: "QUEDE",
      EmployeeID: 6,
      OrderDate: "1996-08-27 00:00:00.000",
      RequiredDate: "1996-09-24 00:00:00.000",
      ShippedDate: "1996-09-04 00:00:00.000",
      ShipVia: 2,
      Freight: 6.4,
      ShipName: "Que Delícia",
      ShipAddress: "Rua da Panificadora",
      ShipCity: 12,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-673"
    },
    {
      OrderID: 10292,
      CustomerID: "TRADH",
      EmployeeID: 1,
      OrderDate: "1996-08-28 00:00:00.000",
      RequiredDate: "1996-09-25 00:00:00.000",
      ShippedDate: "1996-09-02 00:00:00.000",
      ShipVia: 2,
      Freight: 1.35,
      ShipName: "Tradiçao Hipermercados",
      ShipAddress: "Av. Inês de Castro",
      ShipCity: 414,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05634-030"
    },
    {
      OrderID: 10293,
      CustomerID: "TORTU",
      EmployeeID: 1,
      OrderDate: "1996-08-29 00:00:00.000",
      RequiredDate: "1996-09-26 00:00:00.000",
      ShippedDate: "1996-09-11 00:00:00.000",
      ShipVia: 3,
      Freight: 21.18,
      ShipName: "Tortuga Restaurante",
      ShipAddress: "Avda. Azteca 123",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10294,
      CustomerID: "RATTC",
      EmployeeID: 4,
      OrderDate: "1996-08-30 00:00:00.000",
      RequiredDate: "1996-09-27 00:00:00.000",
      ShippedDate: "1996-09-05 00:00:00.000",
      ShipVia: 2,
      Freight: 147.26,
      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-02 00:00:00.000",
      RequiredDate: "1996-09-30 00:00:00.000",
      ShippedDate: "1996-09-10 00:00:00.000",
      ShipVia: 2,
      Freight: 1.15,
      ShipName: "Vins et alcools Chevalier",
      ShipAddress: "59 rue de l'Abbaye",
      ShipCity: "Reims",
      ShipRegion: "NULL",
      ShipPostalCode: 51100,
      ShipCountry: "France"
    },
    {
      OrderID: 10296,
      CustomerID: "LILAS",
      EmployeeID: 6,
      OrderDate: "1996-09-03 00:00:00.000",
      RequiredDate: "1996-10-01 00:00:00.000",
      ShippedDate: "1996-09-11 00:00:00.000",
      ShipVia: 1,
      Freight: 0.12,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10297,
      CustomerID: "BLONP",
      EmployeeID: 5,
      OrderDate: "1996-09-04 00:00:00.000",
      RequiredDate: "1996-10-16 00:00:00.000",
      ShippedDate: "1996-09-10 00:00:00.000",
      ShipVia: 2,
      Freight: 5.74,
      ShipName: "Blondel père et fils",
      ShipAddress: 24,
      ShipCity: "place Kléber",
      ShipRegion: "Strasbourg",
      ShipPostalCode: "NULL",
      ShipCountry: 67000
    },
    {
      OrderID: 10298,
      CustomerID: "HUNGO",
      EmployeeID: 6,
      OrderDate: "1996-09-05 00:00:00.000",
      RequiredDate: "1996-10-03 00:00:00.000",
      ShippedDate: "1996-09-11 00:00:00.000",
      ShipVia: 2,
      Freight: 168.22,
      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-06 00:00:00.000",
      RequiredDate: "1996-10-04 00:00:00.000",
      ShippedDate: "1996-09-13 00:00:00.000",
      ShipVia: 2,
      Freight: 29.76,
      ShipName: "Ricardo Adocicados",
      ShipAddress: "Av. Copacabana",
      ShipCity: 267,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-890"
    },
    {
      OrderID: 10300,
      CustomerID: "MAGAA",
      EmployeeID: 2,
      OrderDate: "1996-09-09 00:00:00.000",
      RequiredDate: "1996-10-07 00:00:00.000",
      ShippedDate: "1996-09-18 00:00:00.000",
      ShipVia: 2,
      Freight: 17.68,
      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-09 00:00:00.000",
      RequiredDate: "1996-10-07 00:00:00.000",
      ShippedDate: "1996-09-17 00:00:00.000",
      ShipVia: 2,
      Freight: 45.08,
      ShipName: "Die Wandernde Kuh",
      ShipAddress: "Adenauerallee 900",
      ShipCity: "Stuttgart",
      ShipRegion: "NULL",
      ShipPostalCode: 70563,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10302,
      CustomerID: "SUPRD",
      EmployeeID: 4,
      OrderDate: "1996-09-10 00:00:00.000",
      RequiredDate: "1996-10-08 00:00:00.000",
      ShippedDate: "1996-10-09 00:00:00.000",
      ShipVia: 2,
      Freight: 6.27,
      ShipName: "Suprêmes délices",
      ShipAddress: "Boulevard Tirou",
      ShipCity: 255,
      ShipRegion: "Charleroi",
      ShipPostalCode: "NULL",
      ShipCountry: "B-6000"
    },
    {
      OrderID: 10303,
      CustomerID: "GODOS",
      EmployeeID: 7,
      OrderDate: "1996-09-11 00:00:00.000",
      RequiredDate: "1996-10-09 00:00:00.000",
      ShippedDate: "1996-09-18 00:00:00.000",
      ShipVia: 2,
      Freight: 107.83,
      ShipName: "Godos Cocina Típica",
      ShipAddress: "C/ Romero",
      ShipCity: 33,
      ShipRegion: "Sevilla",
      ShipPostalCode: "NULL",
      ShipCountry: 41101
    },
    {
      OrderID: 10304,
      CustomerID: "TORTU",
      EmployeeID: 1,
      OrderDate: "1996-09-12 00:00:00.000",
      RequiredDate: "1996-10-10 00:00:00.000",
      ShippedDate: "1996-09-17 00:00:00.000",
      ShipVia: 2,
      Freight: 63.79,
      ShipName: "Tortuga Restaurante",
      ShipAddress: "Avda. Azteca 123",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10305,
      CustomerID: "OLDWO",
      EmployeeID: 8,
      OrderDate: "1996-09-13 00:00:00.000",
      RequiredDate: "1996-10-11 00:00:00.000",
      ShippedDate: "1996-10-09 00:00:00.000",
      ShipVia: 3,
      Freight: 257.62,
      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-16 00:00:00.000",
      RequiredDate: "1996-10-14 00:00:00.000",
      ShippedDate: "1996-09-23 00:00:00.000",
      ShipVia: 3,
      Freight: 7.56,
      ShipName: "Romero y tomillo",
      ShipAddress: "Gran Vía",
      ShipCity: 1,
      ShipRegion: "Madrid",
      ShipPostalCode: "NULL",
      ShipCountry: 28001
    },
    {
      OrderID: 10307,
      CustomerID: "LONEP",
      EmployeeID: 2,
      OrderDate: "1996-09-17 00:00:00.000",
      RequiredDate: "1996-10-15 00:00:00.000",
      ShippedDate: "1996-09-25 00:00:00.000",
      ShipVia: 2,
      Freight: 0.56,
      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-18 00:00:00.000",
      RequiredDate: "1996-10-16 00:00:00.000",
      ShippedDate: "1996-09-24 00:00:00.000",
      ShipVia: 3,
      Freight: 1.61,
      ShipName: "Ana Trujillo Emparedados y helados",
      ShipAddress: "Avda. de la Constitución 2222",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05021",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10309,
      CustomerID: "HUNGO",
      EmployeeID: 3,
      OrderDate: "1996-09-19 00:00:00.000",
      RequiredDate: "1996-10-17 00:00:00.000",
      ShippedDate: "1996-10-23 00:00:00.000",
      ShipVia: 1,
      Freight: 47.3,
      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-20 00:00:00.000",
      RequiredDate: "1996-10-18 00:00:00.000",
      ShippedDate: "1996-09-27 00:00:00.000",
      ShipVia: 2,
      Freight: 17.52,
      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-20 00:00:00.000",
      RequiredDate: "1996-10-04 00:00:00.000",
      ShippedDate: "1996-09-26 00:00:00.000",
      ShipVia: 3,
      Freight: 24.69,
      ShipName: "Du monde entier",
      ShipAddress: 67,
      ShipCity: "rue des Cinquante Otages",
      ShipRegion: "Nantes",
      ShipPostalCode: "NULL",
      ShipCountry: 44000
    },
    {
      OrderID: 10312,
      CustomerID: "WANDK",
      EmployeeID: 2,
      OrderDate: "1996-09-23 00:00:00.000",
      RequiredDate: "1996-10-21 00:00:00.000",
      ShippedDate: "1996-10-03 00:00:00.000",
      ShipVia: 2,
      Freight: 40.26,
      ShipName: "Die Wandernde Kuh",
      ShipAddress: "Adenauerallee 900",
      ShipCity: "Stuttgart",
      ShipRegion: "NULL",
      ShipPostalCode: 70563,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10313,
      CustomerID: "QUICK",
      EmployeeID: 2,
      OrderDate: "1996-09-24 00:00:00.000",
      RequiredDate: "1996-10-22 00:00:00.000",
      ShippedDate: "1996-10-04 00:00:00.000",
      ShipVia: 2,
      Freight: 1.96,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10314,
      CustomerID: "RATTC",
      EmployeeID: 1,
      OrderDate: "1996-09-25 00:00:00.000",
      RequiredDate: "1996-10-23 00:00:00.000",
      ShippedDate: "1996-10-04 00:00:00.000",
      ShipVia: 2,
      Freight: 74.16,
      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-26 00:00:00.000",
      RequiredDate: "1996-10-24 00:00:00.000",
      ShippedDate: "1996-10-03 00:00:00.000",
      ShipVia: 2,
      Freight: 41.76,
      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-27 00:00:00.000",
      RequiredDate: "1996-10-25 00:00:00.000",
      ShippedDate: "1996-10-08 00:00:00.000",
      ShipVia: 3,
      Freight: 150.15,
      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-30 00:00:00.000",
      RequiredDate: "1996-10-28 00:00:00.000",
      ShippedDate: "1996-10-10 00:00:00.000",
      ShipVia: 1,
      Freight: 12.69,
      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-01 00:00:00.000",
      RequiredDate: "1996-10-29 00:00:00.000",
      ShippedDate: "1996-10-04 00:00:00.000",
      ShipVia: 2,
      Freight: 4.73,
      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-02 00:00:00.000",
      RequiredDate: "1996-10-30 00:00:00.000",
      ShippedDate: "1996-10-11 00:00:00.000",
      ShipVia: 3,
      Freight: 64.5,
      ShipName: "Tortuga Restaurante",
      ShipAddress: "Avda. Azteca 123",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10320,
      CustomerID: "WARTH",
      EmployeeID: 5,
      OrderDate: "1996-10-03 00:00:00.000",
      RequiredDate: "1996-10-17 00:00:00.000",
      ShippedDate: "1996-10-18 00:00:00.000",
      ShipVia: 3,
      Freight: 34.57,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10321,
      CustomerID: "ISLAT",
      EmployeeID: 3,
      OrderDate: "1996-10-03 00:00:00.000",
      RequiredDate: "1996-10-31 00:00:00.000",
      ShippedDate: "1996-10-11 00:00:00.000",
      ShipVia: 2,
      Freight: 3.43,
      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-04 00:00:00.000",
      RequiredDate: "1996-11-01 00:00:00.000",
      ShippedDate: "1996-10-23 00:00:00.000",
      ShipVia: 3,
      Freight: 0.4,
      ShipName: "Pericles Comidas clásicas",
      ShipAddress: "Calle Dr. Jorge Cash 321",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10323,
      CustomerID: "KOENE",
      EmployeeID: 4,
      OrderDate: "1996-10-07 00:00:00.000",
      RequiredDate: "1996-11-04 00:00:00.000",
      ShippedDate: "1996-10-14 00:00:00.000",
      ShipVia: 1,
      Freight: 4.88,
      ShipName: "Königlich Essen",
      ShipAddress: "Maubelstr. 90",
      ShipCity: "Brandenburg",
      ShipRegion: "NULL",
      ShipPostalCode: 14776,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10324,
      CustomerID: "SAVEA",
      EmployeeID: 9,
      OrderDate: "1996-10-08 00:00:00.000",
      RequiredDate: "1996-11-05 00:00:00.000",
      ShippedDate: "1996-10-10 00:00:00.000",
      ShipVia: 1,
      Freight: 214.27,
      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-09 00:00:00.000",
      RequiredDate: "1996-10-23 00:00:00.000",
      ShippedDate: "1996-10-14 00:00:00.000",
      ShipVia: 3,
      Freight: 64.86,
      ShipName: "Königlich Essen",
      ShipAddress: "Maubelstr. 90",
      ShipCity: "Brandenburg",
      ShipRegion: "NULL",
      ShipPostalCode: 14776,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10326,
      CustomerID: "BOLID",
      EmployeeID: 4,
      OrderDate: "1996-10-10 00:00:00.000",
      RequiredDate: "1996-11-07 00:00:00.000",
      ShippedDate: "1996-10-14 00:00:00.000",
      ShipVia: 2,
      Freight: 77.92,
      ShipName: "Bólido Comidas preparadas",
      ShipAddress: "C/ Araquil",
      ShipCity: 67,
      ShipRegion: "Madrid",
      ShipPostalCode: "NULL",
      ShipCountry: 28023
    },
    {
      OrderID: 10327,
      CustomerID: "FOLKO",
      EmployeeID: 2,
      OrderDate: "1996-10-11 00:00:00.000",
      RequiredDate: "1996-11-08 00:00:00.000",
      ShippedDate: "1996-10-14 00:00:00.000",
      ShipVia: 1,
      Freight: 63.36,
      ShipName: "Folk och fä HB",
      ShipAddress: "Åkergatan 24",
      ShipCity: "Bräcke",
      ShipRegion: "NULL",
      ShipPostalCode: "S-844 67",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10328,
      CustomerID: "FURIB",
      EmployeeID: 4,
      OrderDate: "1996-10-14 00:00:00.000",
      RequiredDate: "1996-11-11 00:00:00.000",
      ShippedDate: "1996-10-17 00:00:00.000",
      ShipVia: 3,
      Freight: 87.03,
      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-15 00:00:00.000",
      RequiredDate: "1996-11-26 00:00:00.000",
      ShippedDate: "1996-10-23 00:00:00.000",
      ShipVia: 2,
      Freight: 191.67,
      ShipName: "Split Rail Beer & Ale",
      ShipAddress: "P.O. Box 555",
      ShipCity: "Lander",
      ShipRegion: "WY",
      ShipPostalCode: 82520,
      ShipCountry: "USA"
    },
    {
      OrderID: 10330,
      CustomerID: "LILAS",
      EmployeeID: 3,
      OrderDate: "1996-10-16 00:00:00.000",
      RequiredDate: "1996-11-13 00:00:00.000",
      ShippedDate: "1996-10-28 00:00:00.000",
      ShipVia: 1,
      Freight: 12.75,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10331,
      CustomerID: "BONAP",
      EmployeeID: 9,
      OrderDate: "1996-10-16 00:00:00.000",
      RequiredDate: "1996-11-27 00:00:00.000",
      ShippedDate: "1996-10-21 00:00:00.000",
      ShipVia: 1,
      Freight: 10.19,
      ShipName: "Bon app'",
      ShipAddress: 12,
      ShipCity: "rue des Bouchers",
      ShipRegion: "Marseille",
      ShipPostalCode: "NULL",
      ShipCountry: 13008
    },
    {
      OrderID: 10332,
      CustomerID: "MEREP",
      EmployeeID: 3,
      OrderDate: "1996-10-17 00:00:00.000",
      RequiredDate: "1996-11-28 00:00:00.000",
      ShippedDate: "1996-10-21 00:00:00.000",
      ShipVia: 2,
      Freight: 52.84,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10333,
      CustomerID: "WARTH",
      EmployeeID: 5,
      OrderDate: "1996-10-18 00:00:00.000",
      RequiredDate: "1996-11-15 00:00:00.000",
      ShippedDate: "1996-10-25 00:00:00.000",
      ShipVia: 3,
      Freight: 0.59,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10334,
      CustomerID: "VICTE",
      EmployeeID: 8,
      OrderDate: "1996-10-21 00:00:00.000",
      RequiredDate: "1996-11-18 00:00:00.000",
      ShippedDate: "1996-10-28 00:00:00.000",
      ShipVia: 2,
      Freight: 8.56,
      ShipName: "Victuailles en stock",
      ShipAddress: 2,
      ShipCity: "rue du Commerce",
      ShipRegion: "Lyon",
      ShipPostalCode: "NULL",
      ShipCountry: 69004
    },
    {
      OrderID: 10335,
      CustomerID: "HUNGO",
      EmployeeID: 7,
      OrderDate: "1996-10-22 00:00:00.000",
      RequiredDate: "1996-11-19 00:00:00.000",
      ShippedDate: "1996-10-24 00:00:00.000",
      ShipVia: 2,
      Freight: 42.11,
      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-23 00:00:00.000",
      RequiredDate: "1996-11-20 00:00:00.000",
      ShippedDate: "1996-10-25 00:00:00.000",
      ShipVia: 2,
      Freight: 15.51,
      ShipName: "Princesa Isabel Vinhos",
      ShipAddress: "Estrada da saúde n. 58",
      ShipCity: "Lisboa",
      ShipRegion: "NULL",
      ShipPostalCode: 1756,
      ShipCountry: "Portugal"
    },
    {
      OrderID: 10337,
      CustomerID: "FRANK",
      EmployeeID: 4,
      OrderDate: "1996-10-24 00:00:00.000",
      RequiredDate: "1996-11-21 00:00:00.000",
      ShippedDate: "1996-10-29 00:00:00.000",
      ShipVia: 3,
      Freight: 108.26,
      ShipName: "Frankenversand",
      ShipAddress: "Berliner Platz 43",
      ShipCity: "München",
      ShipRegion: "NULL",
      ShipPostalCode: 80805,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10338,
      CustomerID: "OLDWO",
      EmployeeID: 4,
      OrderDate: "1996-10-25 00:00:00.000",
      RequiredDate: "1996-11-22 00:00:00.000",
      ShippedDate: "1996-10-29 00:00:00.000",
      ShipVia: 3,
      Freight: 84.21,
      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-28 00:00:00.000",
      RequiredDate: "1996-11-25 00:00:00.000",
      ShippedDate: "1996-11-04 00:00:00.000",
      ShipVia: 2,
      Freight: 15.66,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10340,
      CustomerID: "BONAP",
      EmployeeID: 1,
      OrderDate: "1996-10-29 00:00:00.000",
      RequiredDate: "1996-11-26 00:00:00.000",
      ShippedDate: "1996-11-08 00:00:00.000",
      ShipVia: 3,
      Freight: 166.31,
      ShipName: "Bon app'",
      ShipAddress: 12,
      ShipCity: "rue des Bouchers",
      ShipRegion: "Marseille",
      ShipPostalCode: "NULL",
      ShipCountry: 13008
    },
    {
      OrderID: 10341,
      CustomerID: "SIMOB",
      EmployeeID: 7,
      OrderDate: "1996-10-29 00:00:00.000",
      RequiredDate: "1996-11-26 00:00:00.000",
      ShippedDate: "1996-11-05 00:00:00.000",
      ShipVia: 3,
      Freight: 26.78,
      ShipName: "Simons bistro",
      ShipAddress: "Vinbæltet 34",
      ShipCity: "Kobenhavn",
      ShipRegion: "NULL",
      ShipPostalCode: 1734,
      ShipCountry: "Denmark"
    },
    {
      OrderID: 10342,
      CustomerID: "FRANK",
      EmployeeID: 4,
      OrderDate: "1996-10-30 00:00:00.000",
      RequiredDate: "1996-11-13 00:00:00.000",
      ShippedDate: "1996-11-04 00:00:00.000",
      ShipVia: 2,
      Freight: 54.83,
      ShipName: "Frankenversand",
      ShipAddress: "Berliner Platz 43",
      ShipCity: "München",
      ShipRegion: "NULL",
      ShipPostalCode: 80805,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10343,
      CustomerID: "LEHMS",
      EmployeeID: 4,
      OrderDate: "1996-10-31 00:00:00.000",
      RequiredDate: "1996-11-28 00:00:00.000",
      ShippedDate: "1996-11-06 00:00:00.000",
      ShipVia: 1,
      Freight: 110.37,
      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-01 00:00:00.000",
      RequiredDate: "1996-11-29 00:00:00.000",
      ShippedDate: "1996-11-05 00:00:00.000",
      ShipVia: 2,
      Freight: 23.29,
      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-04 00:00:00.000",
      RequiredDate: "1996-12-02 00:00:00.000",
      ShippedDate: "1996-11-11 00:00:00.000",
      ShipVia: 2,
      Freight: 249.06,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10346,
      CustomerID: "RATTC",
      EmployeeID: 3,
      OrderDate: "1996-11-05 00:00:00.000",
      RequiredDate: "1996-12-17 00:00:00.000",
      ShippedDate: "1996-11-08 00:00:00.000",
      ShipVia: 3,
      Freight: 142.08,
      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-06 00:00:00.000",
      RequiredDate: "1996-12-04 00:00:00.000",
      ShippedDate: "1996-11-08 00:00:00.000",
      ShipVia: 3,
      Freight: 3.1,
      ShipName: "Familia Arquibaldo",
      ShipAddress: "Rua Orós",
      ShipCity: 92,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05442-030"
    },
    {
      OrderID: 10348,
      CustomerID: "WANDK",
      EmployeeID: 4,
      OrderDate: "1996-11-07 00:00:00.000",
      RequiredDate: "1996-12-05 00:00:00.000",
      ShippedDate: "1996-11-15 00:00:00.000",
      ShipVia: 2,
      Freight: 0.78,
      ShipName: "Die Wandernde Kuh",
      ShipAddress: "Adenauerallee 900",
      ShipCity: "Stuttgart",
      ShipRegion: "NULL",
      ShipPostalCode: 70563,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10349,
      CustomerID: "SPLIR",
      EmployeeID: 7,
      OrderDate: "1996-11-08 00:00:00.000",
      RequiredDate: "1996-12-06 00:00:00.000",
      ShippedDate: "1996-11-15 00:00:00.000",
      ShipVia: 1,
      Freight: 8.63,
      ShipName: "Split Rail Beer & Ale",
      ShipAddress: "P.O. Box 555",
      ShipCity: "Lander",
      ShipRegion: "WY",
      ShipPostalCode: 82520,
      ShipCountry: "USA"
    },
    {
      OrderID: 10350,
      CustomerID: "LAMAI",
      EmployeeID: 6,
      OrderDate: "1996-11-11 00:00:00.000",
      RequiredDate: "1996-12-09 00:00:00.000",
      ShippedDate: "1996-12-03 00:00:00.000",
      ShipVia: 2,
      Freight: 64.19,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10351,
      CustomerID: "ERNSH",
      EmployeeID: 1,
      OrderDate: "1996-11-11 00:00:00.000",
      RequiredDate: "1996-12-09 00:00:00.000",
      ShippedDate: "1996-11-20 00:00:00.000",
      ShipVia: 1,
      Freight: 162.33,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10352,
      CustomerID: "FURIB",
      EmployeeID: 3,
      OrderDate: "1996-11-12 00:00:00.000",
      RequiredDate: "1996-11-26 00:00:00.000",
      ShippedDate: "1996-11-18 00:00:00.000",
      ShipVia: 3,
      Freight: 1.3,
      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-13 00:00:00.000",
      RequiredDate: "1996-12-11 00:00:00.000",
      ShippedDate: "1996-11-25 00:00:00.000",
      ShipVia: 3,
      Freight: 360.63,
      ShipName: "Piccolo und mehr",
      ShipAddress: "Geislweg 14",
      ShipCity: "Salzburg",
      ShipRegion: "NULL",
      ShipPostalCode: 5020,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10354,
      CustomerID: "PERIC",
      EmployeeID: 8,
      OrderDate: "1996-11-14 00:00:00.000",
      RequiredDate: "1996-12-12 00:00:00.000",
      ShippedDate: "1996-11-20 00:00:00.000",
      ShipVia: 3,
      Freight: 53.8,
      ShipName: "Pericles Comidas clásicas",
      ShipAddress: "Calle Dr. Jorge Cash 321",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10355,
      CustomerID: "AROUT",
      EmployeeID: 6,
      OrderDate: "1996-11-15 00:00:00.000",
      RequiredDate: "1996-12-13 00:00:00.000",
      ShippedDate: "1996-11-20 00:00:00.000",
      ShipVia: 1,
      Freight: 41.95,
      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-18 00:00:00.000",
      RequiredDate: "1996-12-16 00:00:00.000",
      ShippedDate: "1996-11-27 00:00:00.000",
      ShipVia: 2,
      Freight: 36.71,
      ShipName: "Die Wandernde Kuh",
      ShipAddress: "Adenauerallee 900",
      ShipCity: "Stuttgart",
      ShipRegion: "NULL",
      ShipPostalCode: 70563,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10357,
      CustomerID: "LILAS",
      EmployeeID: 1,
      OrderDate: "1996-11-19 00:00:00.000",
      RequiredDate: "1996-12-17 00:00:00.000",
      ShippedDate: "1996-12-02 00:00:00.000",
      ShipVia: 3,
      Freight: 34.88,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10358,
      CustomerID: "LAMAI",
      EmployeeID: 5,
      OrderDate: "1996-11-20 00:00:00.000",
      RequiredDate: "1996-12-18 00:00:00.000",
      ShippedDate: "1996-11-27 00:00:00.000",
      ShipVia: 1,
      Freight: 19.64,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10359,
      CustomerID: "SEVES",
      EmployeeID: 5,
      OrderDate: "1996-11-21 00:00:00.000",
      RequiredDate: "1996-12-19 00:00:00.000",
      ShippedDate: "1996-11-26 00:00:00.000",
      ShipVia: 3,
      Freight: 288.43,
      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-22 00:00:00.000",
      RequiredDate: "1996-12-20 00:00:00.000",
      ShippedDate: "1996-12-02 00:00:00.000",
      ShipVia: 3,
      Freight: 131.7,
      ShipName: "Blondel père et fils",
      ShipAddress: 24,
      ShipCity: "place Kléber",
      ShipRegion: "Strasbourg",
      ShipPostalCode: "NULL",
      ShipCountry: 67000
    },
    {
      OrderID: 10361,
      CustomerID: "QUICK",
      EmployeeID: 1,
      OrderDate: "1996-11-22 00:00:00.000",
      RequiredDate: "1996-12-20 00:00:00.000",
      ShippedDate: "1996-12-03 00:00:00.000",
      ShipVia: 2,
      Freight: 183.17,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10362,
      CustomerID: "BONAP",
      EmployeeID: 3,
      OrderDate: "1996-11-25 00:00:00.000",
      RequiredDate: "1996-12-23 00:00:00.000",
      ShippedDate: "1996-11-28 00:00:00.000",
      ShipVia: 1,
      Freight: 96.04,
      ShipName: "Bon app'",
      ShipAddress: 12,
      ShipCity: "rue des Bouchers",
      ShipRegion: "Marseille",
      ShipPostalCode: "NULL",
      ShipCountry: 13008
    },
    {
      OrderID: 10363,
      CustomerID: "DRACD",
      EmployeeID: 4,
      OrderDate: "1996-11-26 00:00:00.000",
      RequiredDate: "1996-12-24 00:00:00.000",
      ShippedDate: "1996-12-04 00:00:00.000",
      ShipVia: 3,
      Freight: 30.54,
      ShipName: "Drachenblut Delikatessen",
      ShipAddress: "Walserweg 21",
      ShipCity: "Aachen",
      ShipRegion: "NULL",
      ShipPostalCode: 52066,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10364,
      CustomerID: "EASTC",
      EmployeeID: 1,
      OrderDate: "1996-11-26 00:00:00.000",
      RequiredDate: "1997-01-07 00:00:00.000",
      ShippedDate: "1996-12-04 00:00:00.000",
      ShipVia: 1,
      Freight: 71.97,
      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-27 00:00:00.000",
      RequiredDate: "1996-12-25 00:00:00.000",
      ShippedDate: "1996-12-02 00:00:00.000",
      ShipVia: 2,
      Freight: 22,
      ShipName: "Antonio Moreno Taquería",
      ShipAddress: "Mataderos  2312",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05023",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10366,
      CustomerID: "GALED",
      EmployeeID: 8,
      OrderDate: "1996-11-28 00:00:00.000",
      RequiredDate: "1997-01-09 00:00:00.000",
      ShippedDate: "1996-12-30 00:00:00.000",
      ShipVia: 2,
      Freight: 10.14,
      ShipName: "Galería del gastronómo",
      ShipAddress: "Rambla de Cataluña",
      ShipCity: 23,
      ShipRegion: "Barcelona",
      ShipPostalCode: "NULL",
      ShipCountry: 8022
    },
    {
      OrderID: 10367,
      CustomerID: "VAFFE",
      EmployeeID: 7,
      OrderDate: "1996-11-28 00:00:00.000",
      RequiredDate: "1996-12-26 00:00:00.000",
      ShippedDate: "1996-12-02 00:00:00.000",
      ShipVia: 3,
      Freight: 13.55,
      ShipName: "Vaffeljernet",
      ShipAddress: "Smagsloget 45",
      ShipCity: "Århus",
      ShipRegion: "NULL",
      ShipPostalCode: 8200,
      ShipCountry: "Denmark"
    },
    {
      OrderID: 10368,
      CustomerID: "ERNSH",
      EmployeeID: 2,
      OrderDate: "1996-11-29 00:00:00.000",
      RequiredDate: "1996-12-27 00:00:00.000",
      ShippedDate: "1996-12-02 00:00:00.000",
      ShipVia: 2,
      Freight: 101.95,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10369,
      CustomerID: "SPLIR",
      EmployeeID: 8,
      OrderDate: "1996-12-02 00:00:00.000",
      RequiredDate: "1996-12-30 00:00:00.000",
      ShippedDate: "1996-12-09 00:00:00.000",
      ShipVia: 2,
      Freight: 195.68,
      ShipName: "Split Rail Beer & Ale",
      ShipAddress: "P.O. Box 555",
      ShipCity: "Lander",
      ShipRegion: "WY",
      ShipPostalCode: 82520,
      ShipCountry: "USA"
    },
    {
      OrderID: 10370,
      CustomerID: "CHOPS",
      EmployeeID: 6,
      OrderDate: "1996-12-03 00:00:00.000",
      RequiredDate: "1996-12-31 00:00:00.000",
      ShippedDate: "1996-12-27 00:00:00.000",
      ShipVia: 2,
      Freight: 1.17,
      ShipName: "Chop-suey Chinese",
      ShipAddress: "Hauptstr. 31",
      ShipCity: "Bern",
      ShipRegion: "NULL",
      ShipPostalCode: 3012,
      ShipCountry: "Switzerland"
    },
    {
      OrderID: 10371,
      CustomerID: "LAMAI",
      EmployeeID: 1,
      OrderDate: "1996-12-03 00:00:00.000",
      RequiredDate: "1996-12-31 00:00:00.000",
      ShippedDate: "1996-12-24 00:00:00.000",
      ShipVia: 1,
      Freight: 0.45,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10372,
      CustomerID: "QUEEN",
      EmployeeID: 5,
      OrderDate: "1996-12-04 00:00:00.000",
      RequiredDate: "1997-01-01 00:00:00.000",
      ShippedDate: "1996-12-09 00:00:00.000",
      ShipVia: 2,
      Freight: 890.78,
      ShipName: "Queen Cozinha",
      ShipAddress: "Alameda dos Canàrios",
      ShipCity: 891,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05487-020"
    },
    {
      OrderID: 10373,
      CustomerID: "HUNGO",
      EmployeeID: 4,
      OrderDate: "1996-12-05 00:00:00.000",
      RequiredDate: "1997-01-02 00:00:00.000",
      ShippedDate: "1996-12-11 00:00:00.000",
      ShipVia: 3,
      Freight: 124.12,
      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-05 00:00:00.000",
      RequiredDate: "1997-01-02 00:00:00.000",
      ShippedDate: "1996-12-09 00:00:00.000",
      ShipVia: 3,
      Freight: 3.94,
      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-06 00:00:00.000",
      RequiredDate: "1997-01-03 00:00:00.000",
      ShippedDate: "1996-12-09 00:00:00.000",
      ShipVia: 2,
      Freight: 20.12,
      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-09 00:00:00.000",
      RequiredDate: "1997-01-06 00:00:00.000",
      ShippedDate: "1996-12-13 00:00:00.000",
      ShipVia: 2,
      Freight: 20.39,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10377,
      CustomerID: "SEVES",
      EmployeeID: 1,
      OrderDate: "1996-12-09 00:00:00.000",
      RequiredDate: "1997-01-06 00:00:00.000",
      ShippedDate: "1996-12-13 00:00:00.000",
      ShipVia: 3,
      Freight: 22.21,
      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-10 00:00:00.000",
      RequiredDate: "1997-01-07 00:00:00.000",
      ShippedDate: "1996-12-19 00:00:00.000",
      ShipVia: 3,
      Freight: 5.44,
      ShipName: "Folk och fä HB",
      ShipAddress: "Åkergatan 24",
      ShipCity: "Bräcke",
      ShipRegion: "NULL",
      ShipPostalCode: "S-844 67",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10379,
      CustomerID: "QUEDE",
      EmployeeID: 2,
      OrderDate: "1996-12-11 00:00:00.000",
      RequiredDate: "1997-01-08 00:00:00.000",
      ShippedDate: "1996-12-13 00:00:00.000",
      ShipVia: 1,
      Freight: 45.03,
      ShipName: "Que Delícia",
      ShipAddress: "Rua da Panificadora",
      ShipCity: 12,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-673"
    },
    {
      OrderID: 10380,
      CustomerID: "HUNGO",
      EmployeeID: 8,
      OrderDate: "1996-12-12 00:00:00.000",
      RequiredDate: "1997-01-09 00:00:00.000",
      ShippedDate: "1997-01-16 00:00:00.000",
      ShipVia: 3,
      Freight: 35.03,
      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-12 00:00:00.000",
      RequiredDate: "1997-01-09 00:00:00.000",
      ShippedDate: "1996-12-13 00:00:00.000",
      ShipVia: 3,
      Freight: 7.99,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10382,
      CustomerID: "ERNSH",
      EmployeeID: 4,
      OrderDate: "1996-12-13 00:00:00.000",
      RequiredDate: "1997-01-10 00:00:00.000",
      ShippedDate: "1996-12-16 00:00:00.000",
      ShipVia: 1,
      Freight: 94.77,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10383,
      CustomerID: "AROUT",
      EmployeeID: 8,
      OrderDate: "1996-12-16 00:00:00.000",
      RequiredDate: "1997-01-13 00:00:00.000",
      ShippedDate: "1996-12-18 00:00:00.000",
      ShipVia: 3,
      Freight: 34.24,
      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-16 00:00:00.000",
      RequiredDate: "1997-01-13 00:00:00.000",
      ShippedDate: "1996-12-20 00:00:00.000",
      ShipVia: 3,
      Freight: 168.64,
      ShipName: "Berglunds snabbköp",
      ShipAddress: "Berguvsvägen  8",
      ShipCity: "Luleå",
      ShipRegion: "NULL",
      ShipPostalCode: "S-958 22",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10385,
      CustomerID: "SPLIR",
      EmployeeID: 1,
      OrderDate: "1996-12-17 00:00:00.000",
      RequiredDate: "1997-01-14 00:00:00.000",
      ShippedDate: "1996-12-23 00:00:00.000",
      ShipVia: 2,
      Freight: 30.96,
      ShipName: "Split Rail Beer & Ale",
      ShipAddress: "P.O. Box 555",
      ShipCity: "Lander",
      ShipRegion: "WY",
      ShipPostalCode: 82520,
      ShipCountry: "USA"
    },
    {
      OrderID: 10386,
      CustomerID: "FAMIA",
      EmployeeID: 9,
      OrderDate: "1996-12-18 00:00:00.000",
      RequiredDate: "1997-01-01 00:00:00.000",
      ShippedDate: "1996-12-25 00:00:00.000",
      ShipVia: 3,
      Freight: 13.99,
      ShipName: "Familia Arquibaldo",
      ShipAddress: "Rua Orós",
      ShipCity: 92,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05442-030"
    },
    {
      OrderID: 10387,
      CustomerID: "SANTG",
      EmployeeID: 1,
      OrderDate: "1996-12-18 00:00:00.000",
      RequiredDate: "1997-01-15 00:00:00.000",
      ShippedDate: "1996-12-20 00:00:00.000",
      ShipVia: 2,
      Freight: 93.63,
      ShipName: "Santé Gourmet",
      ShipAddress: "Erling Skakkes gate 78",
      ShipCity: "Stavern",
      ShipRegion: "NULL",
      ShipPostalCode: 4110,
      ShipCountry: "Norway"
    },
    {
      OrderID: 10388,
      CustomerID: "SEVES",
      EmployeeID: 2,
      OrderDate: "1996-12-19 00:00:00.000",
      RequiredDate: "1997-01-16 00:00:00.000",
      ShippedDate: "1996-12-20 00:00:00.000",
      ShipVia: 1,
      Freight: 34.86,
      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-20 00:00:00.000",
      RequiredDate: "1997-01-17 00:00:00.000",
      ShippedDate: "1996-12-24 00:00:00.000",
      ShipVia: 2,
      Freight: 47.42,
      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-23 00:00:00.000",
      RequiredDate: "1997-01-20 00:00:00.000",
      ShippedDate: "1996-12-26 00:00:00.000",
      ShipVia: 1,
      Freight: 126.38,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10391,
      CustomerID: "DRACD",
      EmployeeID: 3,
      OrderDate: "1996-12-23 00:00:00.000",
      RequiredDate: "1997-01-20 00:00:00.000",
      ShippedDate: "1996-12-31 00:00:00.000",
      ShipVia: 3,
      Freight: 5.45,
      ShipName: "Drachenblut Delikatessen",
      ShipAddress: "Walserweg 21",
      ShipCity: "Aachen",
      ShipRegion: "NULL",
      ShipPostalCode: 52066,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10392,
      CustomerID: "PICCO",
      EmployeeID: 2,
      OrderDate: "1996-12-24 00:00:00.000",
      RequiredDate: "1997-01-21 00:00:00.000",
      ShippedDate: "1997-01-01 00:00:00.000",
      ShipVia: 3,
      Freight: 122.46,
      ShipName: "Piccolo und mehr",
      ShipAddress: "Geislweg 14",
      ShipCity: "Salzburg",
      ShipRegion: "NULL",
      ShipPostalCode: 5020,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10393,
      CustomerID: "SAVEA",
      EmployeeID: 1,
      OrderDate: "1996-12-25 00:00:00.000",
      RequiredDate: "1997-01-22 00:00:00.000",
      ShippedDate: "1997-01-03 00:00:00.000",
      ShipVia: 3,
      Freight: 126.56,
      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-25 00:00:00.000",
      RequiredDate: "1997-01-22 00:00:00.000",
      ShippedDate: "1997-01-03 00:00:00.000",
      ShipVia: 3,
      Freight: 30.34,
      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-26 00:00:00.000",
      RequiredDate: "1997-01-23 00:00:00.000",
      ShippedDate: "1997-01-03 00:00:00.000",
      ShipVia: 1,
      Freight: 184.41,
      ShipName: "HILARION-Abastos",
      ShipAddress: "Carrera 22 con Ave. Carlos Soublette #8-35",
      ShipCity: "San Cristóbal",
      ShipRegion: "Táchira",
      ShipPostalCode: 5022,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10396,
      CustomerID: "FRANK",
      EmployeeID: 1,
      OrderDate: "1996-12-27 00:00:00.000",
      RequiredDate: "1997-01-10 00:00:00.000",
      ShippedDate: "1997-01-06 00:00:00.000",
      ShipVia: 3,
      Freight: 135.35,
      ShipName: "Frankenversand",
      ShipAddress: "Berliner Platz 43",
      ShipCity: "München",
      ShipRegion: "NULL",
      ShipPostalCode: 80805,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10397,
      CustomerID: "PRINI",
      EmployeeID: 5,
      OrderDate: "1996-12-27 00:00:00.000",
      RequiredDate: "1997-01-24 00:00:00.000",
      ShippedDate: "1997-01-02 00:00:00.000",
      ShipVia: 1,
      Freight: 60.26,
      ShipName: "Princesa Isabel Vinhos",
      ShipAddress: "Estrada da saúde n. 58",
      ShipCity: "Lisboa",
      ShipRegion: "NULL",
      ShipPostalCode: 1756,
      ShipCountry: "Portugal"
    },
    {
      OrderID: 10398,
      CustomerID: "SAVEA",
      EmployeeID: 2,
      OrderDate: "1996-12-30 00:00:00.000",
      RequiredDate: "1997-01-27 00:00:00.000",
      ShippedDate: "1997-01-09 00:00:00.000",
      ShipVia: 3,
      Freight: 89.16,
      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-31 00:00:00.000",
      RequiredDate: "1997-01-14 00:00:00.000",
      ShippedDate: "1997-01-08 00:00:00.000",
      ShipVia: 3,
      Freight: 27.36,
      ShipName: "Vaffeljernet",
      ShipAddress: "Smagsloget 45",
      ShipCity: "Århus",
      ShipRegion: "NULL",
      ShipPostalCode: 8200,
      ShipCountry: "Denmark"
    },
    {
      OrderID: 10400,
      CustomerID: "EASTC",
      EmployeeID: 1,
      OrderDate: "1997-01-01 00:00:00.000",
      RequiredDate: "1997-01-29 00:00:00.000",
      ShippedDate: "1997-01-16 00:00:00.000",
      ShipVia: 3,
      Freight: 83.93,
      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-01 00:00:00.000",
      RequiredDate: "1997-01-29 00:00:00.000",
      ShippedDate: "1997-01-10 00:00:00.000",
      ShipVia: 1,
      Freight: 12.51,
      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-02 00:00:00.000",
      RequiredDate: "1997-02-13 00:00:00.000",
      ShippedDate: "1997-01-10 00:00:00.000",
      ShipVia: 2,
      Freight: 67.88,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10403,
      CustomerID: "ERNSH",
      EmployeeID: 4,
      OrderDate: "1997-01-03 00:00:00.000",
      RequiredDate: "1997-01-31 00:00:00.000",
      ShippedDate: "1997-01-09 00:00:00.000",
      ShipVia: 3,
      Freight: 73.79,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10404,
      CustomerID: "MAGAA",
      EmployeeID: 2,
      OrderDate: "1997-01-03 00:00:00.000",
      RequiredDate: "1997-01-31 00:00:00.000",
      ShippedDate: "1997-01-08 00:00:00.000",
      ShipVia: 1,
      Freight: 155.97,
      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-06 00:00:00.000",
      RequiredDate: "1997-02-03 00:00:00.000",
      ShippedDate: "1997-01-22 00:00:00.000",
      ShipVia: 1,
      Freight: 34.82,
      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-07 00:00:00.000",
      RequiredDate: "1997-02-18 00:00:00.000",
      ShippedDate: "1997-01-13 00:00:00.000",
      ShipVia: 1,
      Freight: 108.04,
      ShipName: "Queen Cozinha",
      ShipAddress: "Alameda dos Canàrios",
      ShipCity: 891,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05487-020"
    },
    {
      OrderID: 10407,
      CustomerID: "OTTIK",
      EmployeeID: 2,
      OrderDate: "1997-01-07 00:00:00.000",
      RequiredDate: "1997-02-04 00:00:00.000",
      ShippedDate: "1997-01-30 00:00:00.000",
      ShipVia: 2,
      Freight: 91.48,
      ShipName: "Ottilies Käseladen",
      ShipAddress: "Mehrheimerstr. 369",
      ShipCity: "Köln",
      ShipRegion: "NULL",
      ShipPostalCode: 50739,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10408,
      CustomerID: "FOLIG",
      EmployeeID: 8,
      OrderDate: "1997-01-08 00:00:00.000",
      RequiredDate: "1997-02-05 00:00:00.000",
      ShippedDate: "1997-01-14 00:00:00.000",
      ShipVia: 1,
      Freight: 11.26,
      ShipName: "Folies gourmandes",
      ShipAddress: 184,
      ShipCity: "chaussée de Tournai",
      ShipRegion: "Lille",
      ShipPostalCode: "NULL",
      ShipCountry: 59000
    },
    {
      OrderID: 10409,
      CustomerID: "OCEAN",
      EmployeeID: 3,
      OrderDate: "1997-01-09 00:00:00.000",
      RequiredDate: "1997-02-06 00:00:00.000",
      ShippedDate: "1997-01-14 00:00:00.000",
      ShipVia: 1,
      Freight: 29.83,
      ShipName: "Océano Atlántico 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-10 00:00:00.000",
      RequiredDate: "1997-02-07 00:00:00.000",
      ShippedDate: "1997-01-15 00:00:00.000",
      ShipVia: 3,
      Freight: 2.4,
      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-10 00:00:00.000",
      RequiredDate: "1997-02-07 00:00:00.000",
      ShippedDate: "1997-01-21 00:00:00.000",
      ShipVia: 3,
      Freight: 23.65,
      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-13 00:00:00.000",
      RequiredDate: "1997-02-10 00:00:00.000",
      ShippedDate: "1997-01-15 00:00:00.000",
      ShipVia: 2,
      Freight: 3.77,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10413,
      CustomerID: "LAMAI",
      EmployeeID: 3,
      OrderDate: "1997-01-14 00:00:00.000",
      RequiredDate: "1997-02-11 00:00:00.000",
      ShippedDate: "1997-01-16 00:00:00.000",
      ShipVia: 2,
      Freight: 95.66,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10414,
      CustomerID: "FAMIA",
      EmployeeID: 2,
      OrderDate: "1997-01-14 00:00:00.000",
      RequiredDate: "1997-02-11 00:00:00.000",
      ShippedDate: "1997-01-17 00:00:00.000",
      ShipVia: 3,
      Freight: 21.48,
      ShipName: "Familia Arquibaldo",
      ShipAddress: "Rua Orós",
      ShipCity: 92,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05442-030"
    },
    {
      OrderID: 10415,
      CustomerID: "HUNGC",
      EmployeeID: 3,
      OrderDate: "1997-01-15 00:00:00.000",
      RequiredDate: "1997-02-12 00:00:00.000",
      ShippedDate: "1997-01-24 00:00:00.000",
      ShipVia: 1,
      Freight: 0.2,
      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-16 00:00:00.000",
      RequiredDate: "1997-02-13 00:00:00.000",
      ShippedDate: "1997-01-27 00:00:00.000",
      ShipVia: 3,
      Freight: 22.72,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10417,
      CustomerID: "SIMOB",
      EmployeeID: 4,
      OrderDate: "1997-01-16 00:00:00.000",
      RequiredDate: "1997-02-13 00:00:00.000",
      ShippedDate: "1997-01-28 00:00:00.000",
      ShipVia: 3,
      Freight: 70.29,
      ShipName: "Simons bistro",
      ShipAddress: "Vinbæltet 34",
      ShipCity: "Kobenhavn",
      ShipRegion: "NULL",
      ShipPostalCode: 1734,
      ShipCountry: "Denmark"
    },
    {
      OrderID: 10418,
      CustomerID: "QUICK",
      EmployeeID: 4,
      OrderDate: "1997-01-17 00:00:00.000",
      RequiredDate: "1997-02-14 00:00:00.000",
      ShippedDate: "1997-01-24 00:00:00.000",
      ShipVia: 1,
      Freight: 17.55,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10419,
      CustomerID: "RICSU",
      EmployeeID: 4,
      OrderDate: "1997-01-20 00:00:00.000",
      RequiredDate: "1997-02-17 00:00:00.000",
      ShippedDate: "1997-01-30 00:00:00.000",
      ShipVia: 2,
      Freight: 137.35,
      ShipName: "Richter Supermarkt",
      ShipAddress: "Starenweg 5",
      ShipCity: "Genève",
      ShipRegion: "NULL",
      ShipPostalCode: 1204,
      ShipCountry: "Switzerland"
    },
    {
      OrderID: 10420,
      CustomerID: "WELLI",
      EmployeeID: 3,
      OrderDate: "1997-01-21 00:00:00.000",
      RequiredDate: "1997-02-18 00:00:00.000",
      ShippedDate: "1997-01-27 00:00:00.000",
      ShipVia: 1,
      Freight: 44.12,
      ShipName: "Wellington Importadora",
      ShipAddress: "Rua do Mercado",
      ShipCity: 12,
      ShipRegion: "Resende",
      ShipPostalCode: "SP",
      ShipCountry: "08737-363"
    },
    {
      OrderID: 10421,
      CustomerID: "QUEDE",
      EmployeeID: 8,
      OrderDate: "1997-01-21 00:00:00.000",
      RequiredDate: "1997-03-04 00:00:00.000",
      ShippedDate: "1997-01-27 00:00:00.000",
      ShipVia: 1,
      Freight: 99.23,
      ShipName: "Que Delícia",
      ShipAddress: "Rua da Panificadora",
      ShipCity: 12,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-673"
    },
    {
      OrderID: 10422,
      CustomerID: "FRANS",
      EmployeeID: 2,
      OrderDate: "1997-01-22 00:00:00.000",
      RequiredDate: "1997-02-19 00:00:00.000",
      ShippedDate: "1997-01-31 00:00:00.000",
      ShipVia: 1,
      Freight: 3.02,
      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-23 00:00:00.000",
      RequiredDate: "1997-02-06 00:00:00.000",
      ShippedDate: "1997-02-24 00:00:00.000",
      ShipVia: 3,
      Freight: 24.5,
      ShipName: "Gourmet Lanchonetes",
      ShipAddress: "Av. Brasil",
      ShipCity: 442,
      ShipRegion: "Campinas",
      ShipPostalCode: "SP",
      ShipCountry: "04876-786"
    },
    {
      OrderID: 10424,
      CustomerID: "MEREP",
      EmployeeID: 7,
      OrderDate: "1997-01-23 00:00:00.000",
      RequiredDate: "1997-02-20 00:00:00.000",
      ShippedDate: "1997-01-27 00:00:00.000",
      ShipVia: 2,
      Freight: 370.61,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10425,
      CustomerID: "LAMAI",
      EmployeeID: 6,
      OrderDate: "1997-01-24 00:00:00.000",
      RequiredDate: "1997-02-21 00:00:00.000",
      ShippedDate: "1997-02-14 00:00:00.000",
      ShipVia: 2,
      Freight: 7.93,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10426,
      CustomerID: "GALED",
      EmployeeID: 4,
      OrderDate: "1997-01-27 00:00:00.000",
      RequiredDate: "1997-02-24 00:00:00.000",
      ShippedDate: "1997-02-06 00:00:00.000",
      ShipVia: 1,
      Freight: 18.69,
      ShipName: "Galería del gastronómo",
      ShipAddress: "Rambla de Cataluña",
      ShipCity: 23,
      ShipRegion: "Barcelona",
      ShipPostalCode: "NULL",
      ShipCountry: 8022
    },
    {
      OrderID: 10427,
      CustomerID: "PICCO",
      EmployeeID: 4,
      OrderDate: "1997-01-27 00:00:00.000",
      RequiredDate: "1997-02-24 00:00:00.000",
      ShippedDate: "1997-03-03 00:00:00.000",
      ShipVia: 2,
      Freight: 31.29,
      ShipName: "Piccolo und mehr",
      ShipAddress: "Geislweg 14",
      ShipCity: "Salzburg",
      ShipRegion: "NULL",
      ShipPostalCode: 5020,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10428,
      CustomerID: "REGGC",
      EmployeeID: 7,
      OrderDate: "1997-01-28 00:00:00.000",
      RequiredDate: "1997-02-25 00:00:00.000",
      ShippedDate: "1997-02-04 00:00:00.000",
      ShipVia: 1,
      Freight: 11.09,
      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-29 00:00:00.000",
      RequiredDate: "1997-03-12 00:00:00.000",
      ShippedDate: "1997-02-07 00:00:00.000",
      ShipVia: 2,
      Freight: 56.63,
      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-30 00:00:00.000",
      RequiredDate: "1997-02-13 00:00:00.000",
      ShippedDate: "1997-02-03 00:00:00.000",
      ShipVia: 1,
      Freight: 458.78,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10431,
      CustomerID: "BOTTM",
      EmployeeID: 4,
      OrderDate: "1997-01-30 00:00:00.000",
      RequiredDate: "1997-02-13 00:00:00.000",
      ShippedDate: "1997-02-07 00:00:00.000",
      ShipVia: 2,
      Freight: 44.17,
      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-31 00:00:00.000",
      RequiredDate: "1997-02-14 00:00:00.000",
      ShippedDate: "1997-02-07 00:00:00.000",
      ShipVia: 2,
      Freight: 4.34,
      ShipName: "Split Rail Beer & Ale",
      ShipAddress: "P.O. Box 555",
      ShipCity: "Lander",
      ShipRegion: "WY",
      ShipPostalCode: 82520,
      ShipCountry: "USA"
    },
    {
      OrderID: 10433,
      CustomerID: "PRINI",
      EmployeeID: 3,
      OrderDate: "1997-02-03 00:00:00.000",
      RequiredDate: "1997-03-03 00:00:00.000",
      ShippedDate: "1997-03-04 00:00:00.000",
      ShipVia: 3,
      Freight: 73.83,
      ShipName: "Princesa Isabel Vinhos",
      ShipAddress: "Estrada da saúde n. 58",
      ShipCity: "Lisboa",
      ShipRegion: "NULL",
      ShipPostalCode: 1756,
      ShipCountry: "Portugal"
    },
    {
      OrderID: 10434,
      CustomerID: "FOLKO",
      EmployeeID: 3,
      OrderDate: "1997-02-03 00:00:00.000",
      RequiredDate: "1997-03-03 00:00:00.000",
      ShippedDate: "1997-02-13 00:00:00.000",
      ShipVia: 2,
      Freight: 17.92,
      ShipName: "Folk och fä HB",
      ShipAddress: "Åkergatan 24",
      ShipCity: "Bräcke",
      ShipRegion: "NULL",
      ShipPostalCode: "S-844 67",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10435,
      CustomerID: "CONSH",
      EmployeeID: 8,
      OrderDate: "1997-02-04 00:00:00.000",
      RequiredDate: "1997-03-18 00:00:00.000",
      ShippedDate: "1997-02-07 00:00:00.000",
      ShipVia: 2,
      Freight: 9.21,
      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-05 00:00:00.000",
      RequiredDate: "1997-03-05 00:00:00.000",
      ShippedDate: "1997-02-11 00:00:00.000",
      ShipVia: 2,
      Freight: 156.66,
      ShipName: "Blondel père et fils",
      ShipAddress: 24,
      ShipCity: "place Kléber",
      ShipRegion: "Strasbourg",
      ShipPostalCode: "NULL",
      ShipCountry: 67000
    },
    {
      OrderID: 10437,
      CustomerID: "WARTH",
      EmployeeID: 8,
      OrderDate: "1997-02-05 00:00:00.000",
      RequiredDate: "1997-03-05 00:00:00.000",
      ShippedDate: "1997-02-12 00:00:00.000",
      ShipVia: 1,
      Freight: 19.97,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10438,
      CustomerID: "TOMSP",
      EmployeeID: 3,
      OrderDate: "1997-02-06 00:00:00.000",
      RequiredDate: "1997-03-06 00:00:00.000",
      ShippedDate: "1997-02-14 00:00:00.000",
      ShipVia: 2,
      Freight: 8.24,
      ShipName: "Toms Spezialitäten",
      ShipAddress: "Luisenstr. 48",
      ShipCity: "Münster",
      ShipRegion: "NULL",
      ShipPostalCode: 44087,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10439,
      CustomerID: "MEREP",
      EmployeeID: 6,
      OrderDate: "1997-02-07 00:00:00.000",
      RequiredDate: "1997-03-07 00:00:00.000",
      ShippedDate: "1997-02-10 00:00:00.000",
      ShipVia: 3,
      Freight: 4.07,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10440,
      CustomerID: "SAVEA",
      EmployeeID: 4,
      OrderDate: "1997-02-10 00:00:00.000",
      RequiredDate: "1997-03-10 00:00:00.000",
      ShippedDate: "1997-02-28 00:00:00.000",
      ShipVia: 2,
      Freight: 86.53,
      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-10 00:00:00.000",
      RequiredDate: "1997-03-24 00:00:00.000",
      ShippedDate: "1997-03-14 00:00:00.000",
      ShipVia: 2,
      Freight: 73.02,
      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-11 00:00:00.000",
      RequiredDate: "1997-03-11 00:00:00.000",
      ShippedDate: "1997-02-18 00:00:00.000",
      ShipVia: 2,
      Freight: 47.94,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10443,
      CustomerID: "REGGC",
      EmployeeID: 8,
      OrderDate: "1997-02-12 00:00:00.000",
      RequiredDate: "1997-03-12 00:00:00.000",
      ShippedDate: "1997-02-14 00:00:00.000",
      ShipVia: 1,
      Freight: 13.95,
      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-12 00:00:00.000",
      RequiredDate: "1997-03-12 00:00:00.000",
      ShippedDate: "1997-02-21 00:00:00.000",
      ShipVia: 3,
      Freight: 3.5,
      ShipName: "Berglunds snabbköp",
      ShipAddress: "Berguvsvägen  8",
      ShipCity: "Luleå",
      ShipRegion: "NULL",
      ShipPostalCode: "S-958 22",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10445,
      CustomerID: "BERGS",
      EmployeeID: 3,
      OrderDate: "1997-02-13 00:00:00.000",
      RequiredDate: "1997-03-13 00:00:00.000",
      ShippedDate: "1997-02-20 00:00:00.000",
      ShipVia: 1,
      Freight: 9.3,
      ShipName: "Berglunds snabbköp",
      ShipAddress: "Berguvsvägen  8",
      ShipCity: "Luleå",
      ShipRegion: "NULL",
      ShipPostalCode: "S-958 22",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10446,
      CustomerID: "TOMSP",
      EmployeeID: 6,
      OrderDate: "1997-02-14 00:00:00.000",
      RequiredDate: "1997-03-14 00:00:00.000",
      ShippedDate: "1997-02-19 00:00:00.000",
      ShipVia: 1,
      Freight: 14.68,
      ShipName: "Toms Spezialitäten",
      ShipAddress: "Luisenstr. 48",
      ShipCity: "Münster",
      ShipRegion: "NULL",
      ShipPostalCode: 44087,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10447,
      CustomerID: "RICAR",
      EmployeeID: 4,
      OrderDate: "1997-02-14 00:00:00.000",
      RequiredDate: "1997-03-14 00:00:00.000",
      ShippedDate: "1997-03-07 00:00:00.000",
      ShipVia: 2,
      Freight: 68.66,
      ShipName: "Ricardo Adocicados",
      ShipAddress: "Av. Copacabana",
      ShipCity: 267,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-890"
    },
    {
      OrderID: 10448,
      CustomerID: "RANCH",
      EmployeeID: 4,
      OrderDate: "1997-02-17 00:00:00.000",
      RequiredDate: "1997-03-17 00:00:00.000",
      ShippedDate: "1997-02-24 00:00:00.000",
      ShipVia: 2,
      Freight: 38.82,
      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-18 00:00:00.000",
      RequiredDate: "1997-03-18 00:00:00.000",
      ShippedDate: "1997-02-27 00:00:00.000",
      ShipVia: 2,
      Freight: 53.3,
      ShipName: "Blondel père et fils",
      ShipAddress: 24,
      ShipCity: "place Kléber",
      ShipRegion: "Strasbourg",
      ShipPostalCode: "NULL",
      ShipCountry: 67000
    },
    {
      OrderID: 10450,
      CustomerID: "VICTE",
      EmployeeID: 8,
      OrderDate: "1997-02-19 00:00:00.000",
      RequiredDate: "1997-03-19 00:00:00.000",
      ShippedDate: "1997-03-11 00:00:00.000",
      ShipVia: 2,
      Freight: 7.23,
      ShipName: "Victuailles en stock",
      ShipAddress: 2,
      ShipCity: "rue du Commerce",
      ShipRegion: "Lyon",
      ShipPostalCode: "NULL",
      ShipCountry: 69004
    },
    {
      OrderID: 10451,
      CustomerID: "QUICK",
      EmployeeID: 4,
      OrderDate: "1997-02-19 00:00:00.000",
      RequiredDate: "1997-03-05 00:00:00.000",
      ShippedDate: "1997-03-12 00:00:00.000",
      ShipVia: 3,
      Freight: 189.09,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10452,
      CustomerID: "SAVEA",
      EmployeeID: 8,
      OrderDate: "1997-02-20 00:00:00.000",
      RequiredDate: "1997-03-20 00:00:00.000",
      ShippedDate: "1997-02-26 00:00:00.000",
      ShipVia: 1,
      Freight: 140.26,
      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-21 00:00:00.000",
      RequiredDate: "1997-03-21 00:00:00.000",
      ShippedDate: "1997-02-26 00:00:00.000",
      ShipVia: 2,
      Freight: 25.36,
      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-21 00:00:00.000",
      RequiredDate: "1997-03-21 00:00:00.000",
      ShippedDate: "1997-02-25 00:00:00.000",
      ShipVia: 3,
      Freight: 2.74,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10455,
      CustomerID: "WARTH",
      EmployeeID: 8,
      OrderDate: "1997-02-24 00:00:00.000",
      RequiredDate: "1997-04-07 00:00:00.000",
      ShippedDate: "1997-03-03 00:00:00.000",
      ShipVia: 2,
      Freight: 180.45,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10456,
      CustomerID: "KOENE",
      EmployeeID: 8,
      OrderDate: "1997-02-25 00:00:00.000",
      RequiredDate: "1997-04-08 00:00:00.000",
      ShippedDate: "1997-02-28 00:00:00.000",
      ShipVia: 2,
      Freight: 8.12,
      ShipName: "Königlich Essen",
      ShipAddress: "Maubelstr. 90",
      ShipCity: "Brandenburg",
      ShipRegion: "NULL",
      ShipPostalCode: 14776,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10457,
      CustomerID: "KOENE",
      EmployeeID: 2,
      OrderDate: "1997-02-25 00:00:00.000",
      RequiredDate: "1997-03-25 00:00:00.000",
      ShippedDate: "1997-03-03 00:00:00.000",
      ShipVia: 1,
      Freight: 11.57,
      ShipName: "Königlich Essen",
      ShipAddress: "Maubelstr. 90",
      ShipCity: "Brandenburg",
      ShipRegion: "NULL",
      ShipPostalCode: 14776,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10458,
      CustomerID: "SUPRD",
      EmployeeID: 7,
      OrderDate: "1997-02-26 00:00:00.000",
      RequiredDate: "1997-03-26 00:00:00.000",
      ShippedDate: "1997-03-04 00:00:00.000",
      ShipVia: 3,
      Freight: 147.06,
      ShipName: "Suprêmes délices",
      ShipAddress: "Boulevard Tirou",
      ShipCity: 255,
      ShipRegion: "Charleroi",
      ShipPostalCode: "NULL",
      ShipCountry: "B-6000"
    },
    {
      OrderID: 10459,
      CustomerID: "VICTE",
      EmployeeID: 4,
      OrderDate: "1997-02-27 00:00:00.000",
      RequiredDate: "1997-03-27 00:00:00.000",
      ShippedDate: "1997-02-28 00:00:00.000",
      ShipVia: 2,
      Freight: 25.09,
      ShipName: "Victuailles en stock",
      ShipAddress: 2,
      ShipCity: "rue du Commerce",
      ShipRegion: "Lyon",
      ShipPostalCode: "NULL",
      ShipCountry: 69004
    },
    {
      OrderID: 10460,
      CustomerID: "FOLKO",
      EmployeeID: 8,
      OrderDate: "1997-02-28 00:00:00.000",
      RequiredDate: "1997-03-28 00:00:00.000",
      ShippedDate: "1997-03-03 00:00:00.000",
      ShipVia: 1,
      Freight: 16.27,
      ShipName: "Folk och fä HB",
      ShipAddress: "Åkergatan 24",
      ShipCity: "Bräcke",
      ShipRegion: "NULL",
      ShipPostalCode: "S-844 67",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10461,
      CustomerID: "LILAS",
      EmployeeID: 1,
      OrderDate: "1997-02-28 00:00:00.000",
      RequiredDate: "1997-03-28 00:00:00.000",
      ShippedDate: "1997-03-05 00:00:00.000",
      ShipVia: 3,
      Freight: 148.61,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10462,
      CustomerID: "CONSH",
      EmployeeID: 2,
      OrderDate: "1997-03-03 00:00:00.000",
      RequiredDate: "1997-03-31 00:00:00.000",
      ShippedDate: "1997-03-18 00:00:00.000",
      ShipVia: 1,
      Freight: 6.17,
      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-04 00:00:00.000",
      RequiredDate: "1997-04-01 00:00:00.000",
      ShippedDate: "1997-03-06 00:00:00.000",
      ShipVia: 3,
      Freight: 14.78,
      ShipName: "Suprêmes délices",
      ShipAddress: "Boulevard Tirou",
      ShipCity: 255,
      ShipRegion: "Charleroi",
      ShipPostalCode: "NULL",
      ShipCountry: "B-6000"
    },
    {
      OrderID: 10464,
      CustomerID: "FURIB",
      EmployeeID: 4,
      OrderDate: "1997-03-04 00:00:00.000",
      RequiredDate: "1997-04-01 00:00:00.000",
      ShippedDate: "1997-03-14 00:00:00.000",
      ShipVia: 2,
      Freight: 89,
      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-05 00:00:00.000",
      RequiredDate: "1997-04-02 00:00:00.000",
      ShippedDate: "1997-03-14 00:00:00.000",
      ShipVia: 3,
      Freight: 145.04,
      ShipName: "Vaffeljernet",
      ShipAddress: "Smagsloget 45",
      ShipCity: "Århus",
      ShipRegion: "NULL",
      ShipPostalCode: 8200,
      ShipCountry: "Denmark"
    },
    {
      OrderID: 10466,
      CustomerID: "COMMI",
      EmployeeID: 4,
      OrderDate: "1997-03-06 00:00:00.000",
      RequiredDate: "1997-04-03 00:00:00.000",
      ShippedDate: "1997-03-13 00:00:00.000",
      ShipVia: 1,
      Freight: 11.93,
      ShipName: "Comércio Mineiro",
      ShipAddress: "Av. dos Lusíadas",
      ShipCity: 23,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05432-043"
    },
    {
      OrderID: 10467,
      CustomerID: "MAGAA",
      EmployeeID: 8,
      OrderDate: "1997-03-06 00:00:00.000",
      RequiredDate: "1997-04-03 00:00:00.000",
      ShippedDate: "1997-03-11 00:00:00.000",
      ShipVia: 2,
      Freight: 4.93,
      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-07 00:00:00.000",
      RequiredDate: "1997-04-04 00:00:00.000",
      ShippedDate: "1997-03-12 00:00:00.000",
      ShipVia: 3,
      Freight: 44.12,
      ShipName: "Königlich Essen",
      ShipAddress: "Maubelstr. 90",
      ShipCity: "Brandenburg",
      ShipRegion: "NULL",
      ShipPostalCode: 14776,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10469,
      CustomerID: "WHITC",
      EmployeeID: 1,
      OrderDate: "1997-03-10 00:00:00.000",
      RequiredDate: "1997-04-07 00:00:00.000",
      ShippedDate: "1997-03-14 00:00:00.000",
      ShipVia: 1,
      Freight: 60.18,
      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-11 00:00:00.000",
      RequiredDate: "1997-04-08 00:00:00.000",
      ShippedDate: "1997-03-14 00:00:00.000",
      ShipVia: 2,
      Freight: 64.56,
      ShipName: "Bon app'",
      ShipAddress: 12,
      ShipCity: "rue des Bouchers",
      ShipRegion: "Marseille",
      ShipPostalCode: "NULL",
      ShipCountry: 13008
    },
    {
      OrderID: 10471,
      CustomerID: "BSBEV",
      EmployeeID: 2,
      OrderDate: "1997-03-11 00:00:00.000",
      RequiredDate: "1997-04-08 00:00:00.000",
      ShippedDate: "1997-03-18 00:00:00.000",
      ShipVia: 3,
      Freight: 45.59,
      ShipName: "B's Beverages",
      ShipAddress: "Fauntleroy Circus",
      ShipCity: "London",
      ShipRegion: "NULL",
      ShipPostalCode: "EC2 5NT",
      ShipCountry: "UK"
    },
    {
      OrderID: 10472,
      CustomerID: "SEVES",
      EmployeeID: 8,
      OrderDate: "1997-03-12 00:00:00.000",
      RequiredDate: "1997-04-09 00:00:00.000",
      ShippedDate: "1997-03-19 00:00:00.000",
      ShipVia: 1,
      Freight: 4.2,
      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-13 00:00:00.000",
      RequiredDate: "1997-03-27 00:00:00.000",
      ShippedDate: "1997-03-21 00:00:00.000",
      ShipVia: 3,
      Freight: 16.37,
      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-13 00:00:00.000",
      RequiredDate: "1997-04-10 00:00:00.000",
      ShippedDate: "1997-03-21 00:00:00.000",
      ShipVia: 2,
      Freight: 83.49,
      ShipName: "Pericles Comidas clásicas",
      ShipAddress: "Calle Dr. Jorge Cash 321",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10475,
      CustomerID: "SUPRD",
      EmployeeID: 9,
      OrderDate: "1997-03-14 00:00:00.000",
      RequiredDate: "1997-04-11 00:00:00.000",
      ShippedDate: "1997-04-04 00:00:00.000",
      ShipVia: 1,
      Freight: 68.52,
      ShipName: "Suprêmes délices",
      ShipAddress: "Boulevard Tirou",
      ShipCity: 255,
      ShipRegion: "Charleroi",
      ShipPostalCode: "NULL",
      ShipCountry: "B-6000"
    },
    {
      OrderID: 10476,
      CustomerID: "HILAA",
      EmployeeID: 8,
      OrderDate: "1997-03-17 00:00:00.000",
      RequiredDate: "1997-04-14 00:00:00.000",
      ShippedDate: "1997-03-24 00:00:00.000",
      ShipVia: 3,
      Freight: 4.41,
      ShipName: "HILARION-Abastos",
      ShipAddress: "Carrera 22 con Ave. Carlos Soublette #8-35",
      ShipCity: "San Cristóbal",
      ShipRegion: "Táchira",
      ShipPostalCode: 5022,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10477,
      CustomerID: "PRINI",
      EmployeeID: 5,
      OrderDate: "1997-03-17 00:00:00.000",
      RequiredDate: "1997-04-14 00:00:00.000",
      ShippedDate: "1997-03-25 00:00:00.000",
      ShipVia: 2,
      Freight: 13.02,
      ShipName: "Princesa Isabel Vinhos",
      ShipAddress: "Estrada da saúde n. 58",
      ShipCity: "Lisboa",
      ShipRegion: "NULL",
      ShipPostalCode: 1756,
      ShipCountry: "Portugal"
    },
    {
      OrderID: 10478,
      CustomerID: "VICTE",
      EmployeeID: 2,
      OrderDate: "1997-03-18 00:00:00.000",
      RequiredDate: "1997-04-01 00:00:00.000",
      ShippedDate: "1997-03-26 00:00:00.000",
      ShipVia: 3,
      Freight: 4.81,
      ShipName: "Victuailles en stock",
      ShipAddress: 2,
      ShipCity: "rue du Commerce",
      ShipRegion: "Lyon",
      ShipPostalCode: "NULL",
      ShipCountry: 69004
    },
    {
      OrderID: 10479,
      CustomerID: "RATTC",
      EmployeeID: 3,
      OrderDate: "1997-03-19 00:00:00.000",
      RequiredDate: "1997-04-16 00:00:00.000",
      ShippedDate: "1997-03-21 00:00:00.000",
      ShipVia: 3,
      Freight: 708.95,
      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-20 00:00:00.000",
      RequiredDate: "1997-04-17 00:00:00.000",
      ShippedDate: "1997-03-24 00:00:00.000",
      ShipVia: 2,
      Freight: 1.35,
      ShipName: "Folies gourmandes",
      ShipAddress: 184,
      ShipCity: "chaussée de Tournai",
      ShipRegion: "Lille",
      ShipPostalCode: "NULL",
      ShipCountry: 59000
    },
    {
      OrderID: 10481,
      CustomerID: "RICAR",
      EmployeeID: 8,
      OrderDate: "1997-03-20 00:00:00.000",
      RequiredDate: "1997-04-17 00:00:00.000",
      ShippedDate: "1997-03-25 00:00:00.000",
      ShipVia: 2,
      Freight: 64.33,
      ShipName: "Ricardo Adocicados",
      ShipAddress: "Av. Copacabana",
      ShipCity: 267,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-890"
    },
    {
      OrderID: 10482,
      CustomerID: "LAZYK",
      EmployeeID: 1,
      OrderDate: "1997-03-21 00:00:00.000",
      RequiredDate: "1997-04-18 00:00:00.000",
      ShippedDate: "1997-04-10 00:00:00.000",
      ShipVia: 3,
      Freight: 7.48,
      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-24 00:00:00.000",
      RequiredDate: "1997-04-21 00:00:00.000",
      ShippedDate: "1997-04-25 00:00:00.000",
      ShipVia: 2,
      Freight: 15.28,
      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-24 00:00:00.000",
      RequiredDate: "1997-04-21 00:00:00.000",
      ShippedDate: "1997-04-01 00:00:00.000",
      ShipVia: 3,
      Freight: 6.88,
      ShipName: "B's Beverages",
      ShipAddress: "Fauntleroy Circus",
      ShipCity: "London",
      ShipRegion: "NULL",
      ShipPostalCode: "EC2 5NT",
      ShipCountry: "UK"
    },
    {
      OrderID: 10485,
      CustomerID: "LINOD",
      EmployeeID: 4,
      OrderDate: "1997-03-25 00:00:00.000",
      RequiredDate: "1997-04-08 00:00:00.000",
      ShippedDate: "1997-03-31 00:00:00.000",
      ShipVia: 2,
      Freight: 64.45,
      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-26 00:00:00.000",
      RequiredDate: "1997-04-23 00:00:00.000",
      ShippedDate: "1997-04-02 00:00:00.000",
      ShipVia: 2,
      Freight: 30.53,
      ShipName: "HILARION-Abastos",
      ShipAddress: "Carrera 22 con Ave. Carlos Soublette #8-35",
      ShipCity: "San Cristóbal",
      ShipRegion: "Táchira",
      ShipPostalCode: 5022,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10487,
      CustomerID: "QUEEN",
      EmployeeID: 2,
      OrderDate: "1997-03-26 00:00:00.000",
      RequiredDate: "1997-04-23 00:00:00.000",
      ShippedDate: "1997-03-28 00:00:00.000",
      ShipVia: 2,
      Freight: 71.07,
      ShipName: "Queen Cozinha",
      ShipAddress: "Alameda dos Canàrios",
      ShipCity: 891,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05487-020"
    },
    {
      OrderID: 10488,
      CustomerID: "FRANK",
      EmployeeID: 8,
      OrderDate: "1997-03-27 00:00:00.000",
      RequiredDate: "1997-04-24 00:00:00.000",
      ShippedDate: "1997-04-02 00:00:00.000",
      ShipVia: 2,
      Freight: 4.93,
      ShipName: "Frankenversand",
      ShipAddress: "Berliner Platz 43",
      ShipCity: "München",
      ShipRegion: "NULL",
      ShipPostalCode: 80805,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10489,
      CustomerID: "PICCO",
      EmployeeID: 6,
      OrderDate: "1997-03-28 00:00:00.000",
      RequiredDate: "1997-04-25 00:00:00.000",
      ShippedDate: "1997-04-09 00:00:00.000",
      ShipVia: 2,
      Freight: 5.29,
      ShipName: "Piccolo und mehr",
      ShipAddress: "Geislweg 14",
      ShipCity: "Salzburg",
      ShipRegion: "NULL",
      ShipPostalCode: 5020,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10490,
      CustomerID: "HILAA",
      EmployeeID: 7,
      OrderDate: "1997-03-31 00:00:00.000",
      RequiredDate: "1997-04-28 00:00:00.000",
      ShippedDate: "1997-04-03 00:00:00.000",
      ShipVia: 2,
      Freight: 210.19,
      ShipName: "HILARION-Abastos",
      ShipAddress: "Carrera 22 con Ave. Carlos Soublette #8-35",
      ShipCity: "San Cristóbal",
      ShipRegion: "Táchira",
      ShipPostalCode: 5022,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10491,
      CustomerID: "FURIB",
      EmployeeID: 8,
      OrderDate: "1997-03-31 00:00:00.000",
      RequiredDate: "1997-04-28 00:00:00.000",
      ShippedDate: "1997-04-08 00:00:00.000",
      ShipVia: 3,
      Freight: 16.96,
      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-01 00:00:00.000",
      RequiredDate: "1997-04-29 00:00:00.000",
      ShippedDate: "1997-04-11 00:00:00.000",
      ShipVia: 1,
      Freight: 62.89,
      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-02 00:00:00.000",
      RequiredDate: "1997-04-30 00:00:00.000",
      ShippedDate: "1997-04-10 00:00:00.000",
      ShipVia: 3,
      Freight: 10.64,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10494,
      CustomerID: "COMMI",
      EmployeeID: 4,
      OrderDate: "1997-04-02 00:00:00.000",
      RequiredDate: "1997-04-30 00:00:00.000",
      ShippedDate: "1997-04-09 00:00:00.000",
      ShipVia: 2,
      Freight: 65.99,
      ShipName: "Comércio Mineiro",
      ShipAddress: "Av. dos Lusíadas",
      ShipCity: 23,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05432-043"
    },
    {
      OrderID: 10495,
      CustomerID: "LAUGB",
      EmployeeID: 3,
      OrderDate: "1997-04-03 00:00:00.000",
      RequiredDate: "1997-05-01 00:00:00.000",
      ShippedDate: "1997-04-11 00:00:00.000",
      ShipVia: 3,
      Freight: 4.65,
      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-04 00:00:00.000",
      RequiredDate: "1997-05-02 00:00:00.000",
      ShippedDate: "1997-04-07 00:00:00.000",
      ShipVia: 2,
      Freight: 46.77,
      ShipName: "Tradiçao Hipermercados",
      ShipAddress: "Av. Inês de Castro",
      ShipCity: 414,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05634-030"
    },
    {
      OrderID: 10497,
      CustomerID: "LEHMS",
      EmployeeID: 7,
      OrderDate: "1997-04-04 00:00:00.000",
      RequiredDate: "1997-05-02 00:00:00.000",
      ShippedDate: "1997-04-07 00:00:00.000",
      ShipVia: 1,
      Freight: 36.21,
      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-07 00:00:00.000",
      RequiredDate: "1997-05-05 00:00:00.000",
      ShippedDate: "1997-04-11 00:00:00.000",
      ShipVia: 2,
      Freight: 29.75,
      ShipName: "HILARION-Abastos",
      ShipAddress: "Carrera 22 con Ave. Carlos Soublette #8-35",
      ShipCity: "San Cristóbal",
      ShipRegion: "Táchira",
      ShipPostalCode: 5022,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10499,
      CustomerID: "LILAS",
      EmployeeID: 4,
      OrderDate: "1997-04-08 00:00:00.000",
      RequiredDate: "1997-05-06 00:00:00.000",
      ShippedDate: "1997-04-16 00:00:00.000",
      ShipVia: 2,
      Freight: 102.02,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10500,
      CustomerID: "LAMAI",
      EmployeeID: 6,
      OrderDate: "1997-04-09 00:00:00.000",
      RequiredDate: "1997-05-07 00:00:00.000",
      ShippedDate: "1997-04-17 00:00:00.000",
      ShipVia: 1,
      Freight: 42.68,
      ShipName: "La maison d'Asie",
      ShipAddress: "1 rue Alsace-Lorraine",
      ShipCity: "Toulouse",
      ShipRegion: "NULL",
      ShipPostalCode: 31000,
      ShipCountry: "France"
    },
    {
      OrderID: 10501,
      CustomerID: "BLAUS",
      EmployeeID: 9,
      OrderDate: "1997-04-09 00:00:00.000",
      RequiredDate: "1997-05-07 00:00:00.000",
      ShippedDate: "1997-04-16 00:00:00.000",
      ShipVia: 3,
      Freight: 8.85,
      ShipName: "Blauer See Delikatessen",
      ShipAddress: "Forsterstr. 57",
      ShipCity: "Mannheim",
      ShipRegion: "NULL",
      ShipPostalCode: 68306,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10502,
      CustomerID: "PERIC",
      EmployeeID: 2,
      OrderDate: "1997-04-10 00:00:00.000",
      RequiredDate: "1997-05-08 00:00:00.000",
      ShippedDate: "1997-04-29 00:00:00.000",
      ShipVia: 1,
      Freight: 69.32,
      ShipName: "Pericles Comidas clásicas",
      ShipAddress: "Calle Dr. Jorge Cash 321",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10503,
      CustomerID: "HUNGO",
      EmployeeID: 6,
      OrderDate: "1997-04-11 00:00:00.000",
      RequiredDate: "1997-05-09 00:00:00.000",
      ShippedDate: "1997-04-16 00:00:00.000",
      ShipVia: 2,
      Freight: 16.74,
      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-11 00:00:00.000",
      RequiredDate: "1997-05-09 00:00:00.000",
      ShippedDate: "1997-04-18 00:00:00.000",
      ShipVia: 3,
      Freight: 59.13,
      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-14 00:00:00.000",
      RequiredDate: "1997-05-12 00:00:00.000",
      ShippedDate: "1997-04-21 00:00:00.000",
      ShipVia: 3,
      Freight: 7.13,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10506,
      CustomerID: "KOENE",
      EmployeeID: 9,
      OrderDate: "1997-04-15 00:00:00.000",
      RequiredDate: "1997-05-13 00:00:00.000",
      ShippedDate: "1997-05-02 00:00:00.000",
      ShipVia: 2,
      Freight: 21.19,
      ShipName: "Königlich Essen",
      ShipAddress: "Maubelstr. 90",
      ShipCity: "Brandenburg",
      ShipRegion: "NULL",
      ShipPostalCode: 14776,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10507,
      CustomerID: "ANTON",
      EmployeeID: 7,
      OrderDate: "1997-04-15 00:00:00.000",
      RequiredDate: "1997-05-13 00:00:00.000",
      ShippedDate: "1997-04-22 00:00:00.000",
      ShipVia: 1,
      Freight: 47.45,
      ShipName: "Antonio Moreno Taquería",
      ShipAddress: "Mataderos  2312",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05023",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10508,
      CustomerID: "OTTIK",
      EmployeeID: 1,
      OrderDate: "1997-04-16 00:00:00.000",
      RequiredDate: "1997-05-14 00:00:00.000",
      ShippedDate: "1997-05-13 00:00:00.000",
      ShipVia: 2,
      Freight: 4.99,
      ShipName: "Ottilies Käseladen",
      ShipAddress: "Mehrheimerstr. 369",
      ShipCity: "Köln",
      ShipRegion: "NULL",
      ShipPostalCode: 50739,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10509,
      CustomerID: "BLAUS",
      EmployeeID: 4,
      OrderDate: "1997-04-17 00:00:00.000",
      RequiredDate: "1997-05-15 00:00:00.000",
      ShippedDate: "1997-04-29 00:00:00.000",
      ShipVia: 1,
      Freight: 0.15,
      ShipName: "Blauer See Delikatessen",
      ShipAddress: "Forsterstr. 57",
      ShipCity: "Mannheim",
      ShipRegion: "NULL",
      ShipPostalCode: 68306,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10510,
      CustomerID: "SAVEA",
      EmployeeID: 6,
      OrderDate: "1997-04-18 00:00:00.000",
      RequiredDate: "1997-05-16 00:00:00.000",
      ShippedDate: "1997-04-28 00:00:00.000",
      ShipVia: 3,
      Freight: 367.63,
      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-18 00:00:00.000",
      RequiredDate: "1997-05-16 00:00:00.000",
      ShippedDate: "1997-04-21 00:00:00.000",
      ShipVia: 3,
      Freight: 350.64,
      ShipName: "Bon app'",
      ShipAddress: 12,
      ShipCity: "rue des Bouchers",
      ShipRegion: "Marseille",
      ShipPostalCode: "NULL",
      ShipCountry: 13008
    },
    {
      OrderID: 10512,
      CustomerID: "FAMIA",
      EmployeeID: 7,
      OrderDate: "1997-04-21 00:00:00.000",
      RequiredDate: "1997-05-19 00:00:00.000",
      ShippedDate: "1997-04-24 00:00:00.000",
      ShipVia: 2,
      Freight: 3.53,
      ShipName: "Familia Arquibaldo",
      ShipAddress: "Rua Orós",
      ShipCity: 92,
      ShipRegion: "Sao Paulo",
      ShipPostalCode: "SP",
      ShipCountry: "05442-030"
    },
    {
      OrderID: 10513,
      CustomerID: "WANDK",
      EmployeeID: 7,
      OrderDate: "1997-04-22 00:00:00.000",
      RequiredDate: "1997-06-03 00:00:00.000",
      ShippedDate: "1997-04-28 00:00:00.000",
      ShipVia: 1,
      Freight: 105.65,
      ShipName: "Die Wandernde Kuh",
      ShipAddress: "Adenauerallee 900",
      ShipCity: "Stuttgart",
      ShipRegion: "NULL",
      ShipPostalCode: 70563,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10514,
      CustomerID: "ERNSH",
      EmployeeID: 3,
      OrderDate: "1997-04-22 00:00:00.000",
      RequiredDate: "1997-05-20 00:00:00.000",
      ShippedDate: "1997-05-16 00:00:00.000",
      ShipVia: 2,
      Freight: 789.95,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10515,
      CustomerID: "QUICK",
      EmployeeID: 2,
      OrderDate: "1997-04-23 00:00:00.000",
      RequiredDate: "1997-05-07 00:00:00.000",
      ShippedDate: "1997-05-23 00:00:00.000",
      ShipVia: 1,
      Freight: 204.47,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10516,
      CustomerID: "HUNGO",
      EmployeeID: 2,
      OrderDate: "1997-04-24 00:00:00.000",
      RequiredDate: "1997-05-22 00:00:00.000",
      ShippedDate: "1997-05-01 00:00:00.000",
      ShipVia: 3,
      Freight: 62.78,
      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-24 00:00:00.000",
      RequiredDate: "1997-05-22 00:00:00.000",
      ShippedDate: "1997-04-29 00:00:00.000",
      ShipVia: 3,
      Freight: 32.07,
      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-25 00:00:00.000",
      RequiredDate: "1997-05-09 00:00:00.000",
      ShippedDate: "1997-05-05 00:00:00.000",
      ShipVia: 2,
      Freight: 218.15,
      ShipName: "Tortuga Restaurante",
      ShipAddress: "Avda. Azteca 123",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05033",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10519,
      CustomerID: "CHOPS",
      EmployeeID: 6,
      OrderDate: "1997-04-28 00:00:00.000",
      RequiredDate: "1997-05-26 00:00:00.000",
      ShippedDate: "1997-05-01 00:00:00.000",
      ShipVia: 3,
      Freight: 91.76,
      ShipName: "Chop-suey Chinese",
      ShipAddress: "Hauptstr. 31",
      ShipCity: "Bern",
      ShipRegion: "NULL",
      ShipPostalCode: 3012,
      ShipCountry: "Switzerland"
    },
    {
      OrderID: 10520,
      CustomerID: "SANTG",
      EmployeeID: 7,
      OrderDate: "1997-04-29 00:00:00.000",
      RequiredDate: "1997-05-27 00:00:00.000",
      ShippedDate: "1997-05-01 00:00:00.000",
      ShipVia: 1,
      Freight: 13.37,
      ShipName: "Santé Gourmet",
      ShipAddress: "Erling Skakkes gate 78",
      ShipCity: "Stavern",
      ShipRegion: "NULL",
      ShipPostalCode: 4110,
      ShipCountry: "Norway"
    },
    {
      OrderID: 10521,
      CustomerID: "CACTU",
      EmployeeID: 8,
      OrderDate: "1997-04-29 00:00:00.000",
      RequiredDate: "1997-05-27 00:00:00.000",
      ShippedDate: "1997-05-02 00:00:00.000",
      ShipVia: 2,
      Freight: 17.22,
      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-30 00:00:00.000",
      RequiredDate: "1997-05-28 00:00:00.000",
      ShippedDate: "1997-05-06 00:00:00.000",
      ShipVia: 1,
      Freight: 45.33,
      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-01 00:00:00.000",
      RequiredDate: "1997-05-29 00:00:00.000",
      ShippedDate: "1997-05-30 00:00:00.000",
      ShipVia: 2,
      Freight: 77.63,
      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-01 00:00:00.000",
      RequiredDate: "1997-05-29 00:00:00.000",
      ShippedDate: "1997-05-07 00:00:00.000",
      ShipVia: 2,
      Freight: 244.79,
      ShipName: "Berglunds snabbköp",
      ShipAddress: "Berguvsvägen  8",
      ShipCity: "Luleå",
      ShipRegion: "NULL",
      ShipPostalCode: "S-958 22",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10525,
      CustomerID: "BONAP",
      EmployeeID: 1,
      OrderDate: "1997-05-02 00:00:00.000",
      RequiredDate: "1997-05-30 00:00:00.000",
      ShippedDate: "1997-05-23 00:00:00.000",
      ShipVia: 2,
      Freight: 11.06,
      ShipName: "Bon app'",
      ShipAddress: 12,
      ShipCity: "rue des Bouchers",
      ShipRegion: "Marseille",
      ShipPostalCode: "NULL",
      ShipCountry: 13008
    },
    {
      OrderID: 10526,
      CustomerID: "WARTH",
      EmployeeID: 4,
      OrderDate: "1997-05-05 00:00:00.000",
      RequiredDate: "1997-06-02 00:00:00.000",
      ShippedDate: "1997-05-15 00:00:00.000",
      ShipVia: 2,
      Freight: 58.59,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10527,
      CustomerID: "QUICK",
      EmployeeID: 7,
      OrderDate: "1997-05-05 00:00:00.000",
      RequiredDate: "1997-06-02 00:00:00.000",
      ShippedDate: "1997-05-07 00:00:00.000",
      ShipVia: 1,
      Freight: 41.9,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10528,
      CustomerID: "GREAL",
      EmployeeID: 6,
      OrderDate: "1997-05-06 00:00:00.000",
      RequiredDate: "1997-05-20 00:00:00.000",
      ShippedDate: "1997-05-09 00:00:00.000",
      ShipVia: 2,
      Freight: 3.35,
      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-07 00:00:00.000",
      RequiredDate: "1997-06-04 00:00:00.000",
      ShippedDate: "1997-05-09 00:00:00.000",
      ShipVia: 2,
      Freight: 66.69,
      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-08 00:00:00.000",
      RequiredDate: "1997-06-05 00:00:00.000",
      ShippedDate: "1997-05-12 00:00:00.000",
      ShipVia: 2,
      Freight: 339.22,
      ShipName: "Piccolo und mehr",
      ShipAddress: "Geislweg 14",
      ShipCity: "Salzburg",
      ShipRegion: "NULL",
      ShipPostalCode: 5020,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10531,
      CustomerID: "OCEAN",
      EmployeeID: 7,
      OrderDate: "1997-05-08 00:00:00.000",
      RequiredDate: "1997-06-05 00:00:00.000",
      ShippedDate: "1997-05-19 00:00:00.000",
      ShipVia: 1,
      Freight: 8.12,
      ShipName: "Océano Atlántico 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-09 00:00:00.000",
      RequiredDate: "1997-06-06 00:00:00.000",
      ShippedDate: "1997-05-12 00:00:00.000",
      ShipVia: 3,
      Freight: 74.46,
      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-12 00:00:00.000",
      RequiredDate: "1997-06-09 00:00:00.000",
      ShippedDate: "1997-05-22 00:00:00.000",
      ShipVia: 1,
      Freight: 188.04,
      ShipName: "Folk och fä HB",
      ShipAddress: "Åkergatan 24",
      ShipCity: "Bräcke",
      ShipRegion: "NULL",
      ShipPostalCode: "S-844 67",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10534,
      CustomerID: "LEHMS",
      EmployeeID: 8,
      OrderDate: "1997-05-12 00:00:00.000",
      RequiredDate: "1997-06-09 00:00:00.000",
      ShippedDate: "1997-05-14 00:00:00.000",
      ShipVia: 2,
      Freight: 27.94,
      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-13 00:00:00.000",
      RequiredDate: "1997-06-10 00:00:00.000",
      ShippedDate: "1997-05-21 00:00:00.000",
      ShipVia: 1,
      Freight: 15.64,
      ShipName: "Antonio Moreno Taquería",
      ShipAddress: "Mataderos  2312",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05023",
      ShipCountry: "Mexico"
    },
    {
      OrderID: 10536,
      CustomerID: "LEHMS",
      EmployeeID: 3,
      OrderDate: "1997-05-14 00:00:00.000",
      RequiredDate: "1997-06-11 00:00:00.000",
      ShippedDate: "1997-06-06 00:00:00.000",
      ShipVia: 2,
      Freight: 58.88,
      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-14 00:00:00.000",
      RequiredDate: "1997-05-28 00:00:00.000",
      ShippedDate: "1997-05-19 00:00:00.000",
      ShipVia: 1,
      Freight: 78.85,
      ShipName: "Richter Supermarkt",
      ShipAddress: "Starenweg 5",
      ShipCity: "Genève",
      ShipRegion: "NULL",
      ShipPostalCode: 1204,
      ShipCountry: "Switzerland"
    },
    {
      OrderID: 10538,
      CustomerID: "BSBEV",
      EmployeeID: 9,
      OrderDate: "1997-05-15 00:00:00.000",
      RequiredDate: "1997-06-12 00:00:00.000",
      ShippedDate: "1997-05-16 00:00:00.000",
      ShipVia: 3,
      Freight: 4.87,
      ShipName: "B's Beverages",
      ShipAddress: "Fauntleroy Circus",
      ShipCity: "London",
      ShipRegion: "NULL",
      ShipPostalCode: "EC2 5NT",
      ShipCountry: "UK"
    },
    {
      OrderID: 10539,
      CustomerID: "BSBEV",
      EmployeeID: 6,
      OrderDate: "1997-05-16 00:00:00.000",
      RequiredDate: "1997-06-13 00:00:00.000",
      ShippedDate: "1997-05-23 00:00:00.000",
      ShipVia: 3,
      Freight: 12.36,
      ShipName: "B's Beverages",
      ShipAddress: "Fauntleroy Circus",
      ShipCity: "London",
      ShipRegion: "NULL",
      ShipPostalCode: "EC2 5NT",
      ShipCountry: "UK"
    },
    {
      OrderID: 10540,
      CustomerID: "QUICK",
      EmployeeID: 3,
      OrderDate: "1997-05-19 00:00:00.000",
      RequiredDate: "1997-06-16 00:00:00.000",
      ShippedDate: "1997-06-13 00:00:00.000",
      ShipVia: 3,
      Freight: 1007.64,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10541,
      CustomerID: "HANAR",
      EmployeeID: 2,
      OrderDate: "1997-05-19 00:00:00.000",
      RequiredDate: "1997-06-16 00:00:00.000",
      ShippedDate: "1997-05-29 00:00:00.000",
      ShipVia: 1,
      Freight: 68.65,
      ShipName: "Hanari Carnes",
      ShipAddress: "Rua do Paço",
      ShipCity: 67,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "05454-876"
    },
    {
      OrderID: 10542,
      CustomerID: "KOENE",
      EmployeeID: 1,
      OrderDate: "1997-05-20 00:00:00.000",
      RequiredDate: "1997-06-17 00:00:00.000",
      ShippedDate: "1997-05-26 00:00:00.000",
      ShipVia: 3,
      Freight: 10.95,
      ShipName: "Königlich Essen",
      ShipAddress: "Maubelstr. 90",
      ShipCity: "Brandenburg",
      ShipRegion: "NULL",
      ShipPostalCode: 14776,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10543,
      CustomerID: "LILAS",
      EmployeeID: 8,
      OrderDate: "1997-05-21 00:00:00.000",
      RequiredDate: "1997-06-18 00:00:00.000",
      ShippedDate: "1997-05-23 00:00:00.000",
      ShipVia: 2,
      Freight: 48.17,
      ShipName: "LILA-Supermercado",
      ShipAddress: "Carrera 52 con Ave. Bolívar #65-98 Llano Largo",
      ShipCity: "Barquisimeto",
      ShipRegion: "Lara",
      ShipPostalCode: 3508,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10544,
      CustomerID: "LONEP",
      EmployeeID: 4,
      OrderDate: "1997-05-21 00:00:00.000",
      RequiredDate: "1997-06-18 00:00:00.000",
      ShippedDate: "1997-05-30 00:00:00.000",
      ShipVia: 1,
      Freight: 24.91,
      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-22 00:00:00.000",
      RequiredDate: "1997-06-19 00:00:00.000",
      ShippedDate: "1997-06-26 00:00:00.000",
      ShipVia: 2,
      Freight: 11.92,
      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-23 00:00:00.000",
      RequiredDate: "1997-06-20 00:00:00.000",
      ShippedDate: "1997-05-27 00:00:00.000",
      ShipVia: 3,
      Freight: 194.72,
      ShipName: "Victuailles en stock",
      ShipAddress: 2,
      ShipCity: "rue du Commerce",
      ShipRegion: "Lyon",
      ShipPostalCode: "NULL",
      ShipCountry: 69004
    },
    {
      OrderID: 10547,
      CustomerID: "SEVES",
      EmployeeID: 3,
      OrderDate: "1997-05-23 00:00:00.000",
      RequiredDate: "1997-06-20 00:00:00.000",
      ShippedDate: "1997-06-02 00:00:00.000",
      ShipVia: 2,
      Freight: 178.43,
      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-26 00:00:00.000",
      RequiredDate: "1997-06-23 00:00:00.000",
      ShippedDate: "1997-06-02 00:00:00.000",
      ShipVia: 2,
      Freight: 1.43,
      ShipName: "Toms Spezialitäten",
      ShipAddress: "Luisenstr. 48",
      ShipCity: "Münster",
      ShipRegion: "NULL",
      ShipPostalCode: 44087,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10549,
      CustomerID: "QUICK",
      EmployeeID: 5,
      OrderDate: "1997-05-27 00:00:00.000",
      RequiredDate: "1997-06-10 00:00:00.000",
      ShippedDate: "1997-05-30 00:00:00.000",
      ShipVia: 1,
      Freight: 171.24,
      ShipName: "QUICK-Stop",
      ShipAddress: "Taucherstraße 10",
      ShipCity: "Cunewalde",
      ShipRegion: "NULL",
      ShipPostalCode: "01307",
      ShipCountry: "Germany"
    },
    {
      OrderID: 10550,
      CustomerID: "GODOS",
      EmployeeID: 7,
      OrderDate: "1997-05-28 00:00:00.000",
      RequiredDate: "1997-06-25 00:00:00.000",
      ShippedDate: "1997-06-06 00:00:00.000",
      ShipVia: 3,
      Freight: 4.32,
      ShipName: "Godos Cocina Típica",
      ShipAddress: "C/ Romero",
      ShipCity: 33,
      ShipRegion: "Sevilla",
      ShipPostalCode: "NULL",
      ShipCountry: 41101
    },
    {
      OrderID: 10551,
      CustomerID: "FURIB",
      EmployeeID: 4,
      OrderDate: "1997-05-28 00:00:00.000",
      RequiredDate: "1997-07-09 00:00:00.000",
      ShippedDate: "1997-06-06 00:00:00.000",
      ShipVia: 3,
      Freight: 72.95,
      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-29 00:00:00.000",
      RequiredDate: "1997-06-26 00:00:00.000",
      ShippedDate: "1997-06-05 00:00:00.000",
      ShipVia: 1,
      Freight: 83.22,
      ShipName: "HILARION-Abastos",
      ShipAddress: "Carrera 22 con Ave. Carlos Soublette #8-35",
      ShipCity: "San Cristóbal",
      ShipRegion: "Táchira",
      ShipPostalCode: 5022,
      ShipCountry: "Venezuela"
    },
    {
      OrderID: 10553,
      CustomerID: "WARTH",
      EmployeeID: 2,
      OrderDate: "1997-05-30 00:00:00.000",
      RequiredDate: "1997-06-27 00:00:00.000",
      ShippedDate: "1997-06-03 00:00:00.000",
      ShipVia: 2,
      Freight: 149.49,
      ShipName: "Wartian Herkku",
      ShipAddress: "Torikatu 38",
      ShipCity: "Oulu",
      ShipRegion: "NULL",
      ShipPostalCode: 90110,
      ShipCountry: "Finland"
    },
    {
      OrderID: 10554,
      CustomerID: "OTTIK",
      EmployeeID: 4,
      OrderDate: "1997-05-30 00:00:00.000",
      RequiredDate: "1997-06-27 00:00:00.000",
      ShippedDate: "1997-06-05 00:00:00.000",
      ShipVia: 3,
      Freight: 120.97,
      ShipName: "Ottilies Käseladen",
      ShipAddress: "Mehrheimerstr. 369",
      ShipCity: "Köln",
      ShipRegion: "NULL",
      ShipPostalCode: 50739,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10555,
      CustomerID: "SAVEA",
      EmployeeID: 6,
      OrderDate: "1997-06-02 00:00:00.000",
      RequiredDate: "1997-06-30 00:00:00.000",
      ShippedDate: "1997-06-04 00:00:00.000",
      ShipVia: 3,
      Freight: 252.49,
      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-03 00:00:00.000",
      RequiredDate: "1997-07-15 00:00:00.000",
      ShippedDate: "1997-06-13 00:00:00.000",
      ShipVia: 1,
      Freight: 9.8,
      ShipName: "Simons bistro",
      ShipAddress: "Vinbæltet 34",
      ShipCity: "Kobenhavn",
      ShipRegion: "NULL",
      ShipPostalCode: 1734,
      ShipCountry: "Denmark"
    },
    {
      OrderID: 10557,
      CustomerID: "LEHMS",
      EmployeeID: 9,
      OrderDate: "1997-06-03 00:00:00.000",
      RequiredDate: "1997-06-17 00:00:00.000",
      ShippedDate: "1997-06-06 00:00:00.000",
      ShipVia: 2,
      Freight: 96.72,
      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-04 00:00:00.000",
      RequiredDate: "1997-07-02 00:00:00.000",
      ShippedDate: "1997-06-10 00:00:00.000",
      ShipVia: 2,
      Freight: 72.97,
      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-05 00:00:00.000",
      RequiredDate: "1997-07-03 00:00:00.000",
      ShippedDate: "1997-06-13 00:00:00.000",
      ShipVia: 1,
      Freight: 8.05,
      ShipName: "Blondel père et fils",
      ShipAddress: 24,
      ShipCity: "place Kléber",
      ShipRegion: "Strasbourg",
      ShipPostalCode: "NULL",
      ShipCountry: 67000
    },
    {
      OrderID: 10560,
      CustomerID: "FRANK",
      EmployeeID: 8,
      OrderDate: "1997-06-06 00:00:00.000",
      RequiredDate: "1997-07-04 00:00:00.000",
      ShippedDate: "1997-06-09 00:00:00.000",
      ShipVia: 1,
      Freight: 36.65,
      ShipName: "Frankenversand",
      ShipAddress: "Berliner Platz 43",
      ShipCity: "München",
      ShipRegion: "NULL",
      ShipPostalCode: 80805,
      ShipCountry: "Germany"
    },
    {
      OrderID: 10561,
      CustomerID: "FOLKO",
      EmployeeID: 2,
      OrderDate: "1997-06-06 00:00:00.000",
      RequiredDate: "1997-07-04 00:00:00.000",
      ShippedDate: "1997-06-09 00:00:00.000",
      ShipVia: 2,
      Freight: 242.21,
      ShipName: "Folk och fä HB",
      ShipAddress: "Åkergatan 24",
      ShipCity: "Bräcke",
      ShipRegion: "NULL",
      ShipPostalCode: "S-844 67",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10562,
      CustomerID: "REGGC",
      EmployeeID: 1,
      OrderDate: "1997-06-09 00:00:00.000",
      RequiredDate: "1997-07-07 00:00:00.000",
      ShippedDate: "1997-06-12 00:00:00.000",
      ShipVia: 1,
      Freight: 22.95,
      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-10 00:00:00.000",
      RequiredDate: "1997-07-22 00:00:00.000",
      ShippedDate: "1997-06-24 00:00:00.000",
      ShipVia: 2,
      Freight: 60.43,
      ShipName: "Ricardo Adocicados",
      ShipAddress: "Av. Copacabana",
      ShipCity: 267,
      ShipRegion: "Rio de Janeiro",
      ShipPostalCode: "RJ",
      ShipCountry: "02389-890"
    },
    {
      OrderID: 10564,
      CustomerID: "RATTC",
      EmployeeID: 4,
      OrderDate: "1997-06-10 00:00:00.000",
      RequiredDate: "1997-07-08 00:00:00.000",
      ShippedDate: "1997-06-16 00:00:00.000",
      ShipVia: 3,
      Freight: 13.75,
      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-11 00:00:00.000",
      RequiredDate: "1997-07-09 00:00:00.000",
      ShippedDate: "1997-06-18 00:00:00.000",
      ShipVia: 2,
      Freight: 7.15,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10566,
      CustomerID: "BLONP",
      EmployeeID: 9,
      OrderDate: "1997-06-12 00:00:00.000",
      RequiredDate: "1997-07-10 00:00:00.000",
      ShippedDate: "1997-06-18 00:00:00.000",
      ShipVia: 1,
      Freight: 88.4,
      ShipName: "Blondel père et fils",
      ShipAddress: 24,
      ShipCity: "place Kléber",
      ShipRegion: "Strasbourg",
      ShipPostalCode: "NULL",
      ShipCountry: 67000
    },
    {
      OrderID: 10567,
      CustomerID: "HUNGO",
      EmployeeID: 1,
      OrderDate: "1997-06-12 00:00:00.000",
      RequiredDate: "1997-07-10 00:00:00.000",
      ShippedDate: "1997-06-17 00:00:00.000",
      ShipVia: 1,
      Freight: 33.97,
      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-13 00:00:00.000",
      RequiredDate: "1997-07-11 00:00:00.000",
      ShippedDate: "1997-07-09 00:00:00.000",
      ShipVia: 3,
      Freight: 6.54,
      ShipName: "Galería del gastronómo",
      ShipAddress: "Rambla de Cataluña",
      ShipCity: 23,
      ShipRegion: "Barcelona",
      ShipPostalCode: "NULL",
      ShipCountry: 8022
    },
    {
      OrderID: 10569,
      CustomerID: "RATTC",
      EmployeeID: 5,
      OrderDate: "1997-06-16 00:00:00.000",
      RequiredDate: "1997-07-14 00:00:00.000",
      ShippedDate: "1997-07-11 00:00:00.000",
      ShipVia: 1,
      Freight: 58.98,
      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-17 00:00:00.000",
      RequiredDate: "1997-07-15 00:00:00.000",
      ShippedDate: "1997-06-19 00:00:00.000",
      ShipVia: 3,
      Freight: 188.99,
      ShipName: "Mère Paillarde",
      ShipAddress: "43 rue St. Laurent",
      ShipCity: "Montréal",
      ShipRegion: "Québec",
      ShipPostalCode: "H1J 1C3",
      ShipCountry: "Canada"
    },
    {
      OrderID: 10571,
      CustomerID: "ERNSH",
      EmployeeID: 8,
      OrderDate: "1997-06-17 00:00:00.000",
      RequiredDate: "1997-07-29 00:00:00.000",
      ShippedDate: "1997-07-04 00:00:00.000",
      ShipVia: 3,
      Freight: 26.06,
      ShipName: "Ernst Handel",
      ShipAddress: "Kirchgasse 6",
      ShipCity: "Graz",
      ShipRegion: "NULL",
      ShipPostalCode: 8010,
      ShipCountry: "Austria"
    },
    {
      OrderID: 10572,
      CustomerID: "BERGS",
      EmployeeID: 3,
      OrderDate: "1997-06-18 00:00:00.000",
      RequiredDate: "1997-07-16 00:00:00.000",
      ShippedDate: "1997-06-25 00:00:00.000",
      ShipVia: 2,
      Freight: 116.43,
      ShipName: "Berglunds snabbköp",
      ShipAddress: "Berguvsvägen  8",
      ShipCity: "Luleå",
      ShipRegion: "NULL",
      ShipPostalCode: "S-958 22",
      ShipCountry: "Sweden"
    },
    {
      OrderID: 10573,
      CustomerID: "ANTON",
      EmployeeID: 7,
      OrderDate: "1997-06-19 00:00:00.000",
      RequiredDate: "1997-07-17 00:00:00.000",
      ShippedDate: "1997-06-20 00:00:00.000",
      ShipVia: 3,
      Freight: 84.84,
      ShipName: "Antonio Moreno Taquería",
      ShipAddress: "Mataderos  2312",
      ShipCity: "México D.F.",
      ShipRegion: "NULL",
      ShipPostalCode: "05023",
      ShipCountry: "Mexico"
    }
  ];

  var orderDetails = [
    {
      OrderID: 10248,
      ProductID: 11,
      UnitPrice: 14,
      Quantity: 12,
      Discount: 0
    },
    {
      OrderID: 10248,
      ProductID: 42,
      UnitPrice: 9.8,
      Quantity: 10,
      Discount: 0
    },
    {
      OrderID: 10248,
      ProductID: 72,
      UnitPrice: 34.8,
      Quantity: 5,
      Discount: 0
    },
    {
      OrderID: 10249,
      ProductID: 14,
      UnitPrice: 18.6,
      Quantity: 9,
      Discount: 0
    },
    {
      OrderID: 10249,
      ProductID: 51,
      UnitPrice: 42.4,
      Quantity: 40,
      Discount: 0
    },
    {
      OrderID: 10250,
      ProductID: 41,
      UnitPrice: 7.7,
      Quantity: 10,
      Discount: 0
    },
    {
      OrderID: 10250,
      ProductID: 51,
      UnitPrice: 42.4,
      Quantity: 35,
      Discount: 0.15
    },
    {
      OrderID: 10250,
      ProductID: 65,
      UnitPrice: 16.8,
      Quantity: 15,
      Discount: 0.15
    },
    {
      OrderID: 10251,
      ProductID: 22,
      UnitPrice: 16.8,
      Quantity: 6,
      Discount: 0.05
    },
    {
      OrderID: 10251,
      ProductID: 57,
      UnitPrice: 15.6,
      Quantity: 15,
      Discount: 0.05
    },
    {
      OrderID: 10251,
      ProductID: 65,
      UnitPrice: 16.8,
      Quantity: 20,
      Discount: 0
    },
    {
      OrderID: 10252,
      ProductID: 20,
      UnitPrice: 64.8,
      Quantity: 40,
      Discount: 0.05
    },
    {
      OrderID: 10252,
      ProductID: 33,
      UnitPrice: 2,
      Quantity: 25,
      Discount: 0.05
    },
    {
      OrderID: 10252,
      ProductID: 60,
      UnitPrice: 27.2,
      Quantity: 40,
      Discount: 0
    },
    {
      OrderID: 10253,
      ProductID: 31,
      UnitPrice: 10,
      Quantity: 20,
      Discount: 0
    },
    {
      OrderID: 10253,
      ProductID: 39,
      UnitPrice: 14.4,
      Quantity: 42,
      Discount: 0
    },
    {
      OrderID: 10253,
      ProductID: 49,
      UnitPrice: 16,
      Quantity: 40,
      Discount: 0
    },
    {
      OrderID: 10254,
      ProductID: 24,
      UnitPrice: 3.6,
      Quantity: 15,
      Discount: 0.15
    },
    {
      OrderID: 10254,
      ProductID: 55,
      UnitPrice: 19.2,
      Quantity: 21,
      Discount: 0.15
    }
  ];
  var employees = [
    {
      EmployeeID: 1,
      LastName: "Davolio",
      FirstName: "Nancy",
      Title: "Sales Representative",
      TitleOfCourtesy: "Ms.",
      BirthDate: "1948-12-08 00:00:00.000",
      HireDate: "1992-05-01 00:00:00.000",
      Address: "507 - 20th Ave. E.",
      City: "",
      Region: "",
      PostalCode: "",
      Country: "",
      HomePhone: "",
      Extension: "",
      Photo: "",
      Notes: "",
      ReportsTo: "",
      PhotoPath: ""
    },
    {
      EmployeeID: "Apt. 2A",
      LastName: "Seattle",
      FirstName: "WA",
      Title: 98122,
      TitleOfCourtesy: "USA",
      BirthDate: "(206) 555-9857",
      HireDate: 5467,
      Address:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      City:
        'Education includes a BA in psychology from Colorado State University in 1970.  She also completed "The Art of the Cold Call."  Nancy is a member of Toastmasters International.',
      Region: 2,
      PostalCode: "http://accweb/emmployees/davolio.bmp",
      Country: "",
      HomePhone: "",
      Extension: "",
      Photo: "",
      Notes: "",
      ReportsTo: "",
      PhotoPath: ""
    },
    {
      EmployeeID: 2,
      LastName: "Fuller",
      FirstName: "Andrew",
      Title: "Vice President",
      TitleOfCourtesy: "Sales",
      BirthDate: "Dr.",
      HireDate: "1952-02-19 00:00:00.000",
      Address: "1992-08-14 00:00:00.000",
      City: "908 W. Capital Way",
      Region: "Tacoma",
      PostalCode: "WA",
      Country: 98401,
      HomePhone: "USA",
      Extension: "(206) 555-9482",
      Photo: 3457,
      Notes:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      ReportsTo:
        "Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981.  He is fluent in French and Italian and reads German.  He joined the company as a sales representative",
      PhotoPath: "was promoted to sales manager i"
    },
    {
      EmployeeID: 3,
      LastName: "Leverling",
      FirstName: "Janet",
      Title: "Sales Representative",
      TitleOfCourtesy: "Ms.",
      BirthDate: "1963-08-30 00:00:00.000",
      HireDate: "1992-04-01 00:00:00.000",
      Address: "722 Moss Bay Blvd.",
      City: "Kirkland",
      Region: "WA",
      PostalCode: 98033,
      Country: "USA",
      HomePhone: "(206) 555-3412",
      Extension: 3355,
      Photo:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000080540000424D80540000000000007600000028000000C0000000E0000000010004000000000000540000CE0E0000D80E0000000000",
      Notes:
        "Janet has a BS degree in chemistry from Boston College (1984).  She has also completed a certificate program in food retailing management.  Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.",
      ReportsTo: 2,
      PhotoPath: "http://accweb/emmployees/leverling.bmp"
    },
    {
      EmployeeID: 4,
      LastName: "Peacock",
      FirstName: "Margaret",
      Title: "Sales Representative",
      TitleOfCourtesy: "Mrs.",
      BirthDate: "1937-09-19 00:00:00.000",
      HireDate: "1993-05-03 00:00:00.000",
      Address: "4110 Old Redmond Rd.",
      City: "Redmond",
      Region: "WA",
      PostalCode: 98052,
      Country: "USA",
      HomePhone: "(206) 555-8122",
      Extension: 5176,
      Photo:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      Notes:
        "Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966).  She was assigned to the London office temporarily from July through November 1992.",
      ReportsTo: 2,
      PhotoPath: "http://accweb/emmployees/peacock.bmp"
    },
    {
      EmployeeID: 5,
      LastName: "Buchanan",
      FirstName: "Steven",
      Title: "Sales Manager",
      TitleOfCourtesy: "Mr.",
      BirthDate: "1955-03-04 00:00:00.000",
      HireDate: "1993-10-17 00:00:00.000",
      Address: "14 Garrett Hill",
      City: "London",
      Region: "NULL",
      PostalCode: "SW1 8JR",
      Country: "UK",
      HomePhone: "(71) 555-4848",
      Extension: 3453,
      Photo:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      Notes: "Steven Buchanan graduated from St. Andrews University",
      ReportsTo: "Scotland",
      PhotoPath:
        "with a BSC degree in 1976.  Upon joining the company as a sales representative in 1992"
    },
    {
      EmployeeID: 6,
      LastName: "Suyama",
      FirstName: "Michael",
      Title: "Sales Representative",
      TitleOfCourtesy: "Mr.",
      BirthDate: "1963-07-02 00:00:00.000",
      HireDate: "1993-10-17 00:00:00.000",
      Address: "Coventry House",
      City: "",
      Region: "",
      PostalCode: "",
      Country: "",
      HomePhone: "",
      Extension: "",
      Photo: "",
      Notes: "",
      ReportsTo: "",
      PhotoPath: ""
    },
    {
      EmployeeID: "Miner Rd.",
      LastName: "London",
      FirstName: "NULL",
      Title: "EC2 7JR",
      TitleOfCourtesy: "UK",
      BirthDate: "(71) 555-7773",
      HireDate: 428,
      Address:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      City: "Michael is a graduate of Sussex University (MA",
      Region: "economics",
      PostalCode: "1983) and the University of California at Los Angeles (MBA",
      Country: "marketing",
      HomePhone:
        '1986).  He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional."  He is fluent',
      Extension: 5,
      Photo: "http://accweb/emmployees/davolio.bmp",
      Notes: "",
      ReportsTo: "",
      PhotoPath: ""
    },
    {
      EmployeeID: 7,
      LastName: "King",
      FirstName: "Robert",
      Title: "Sales Representative",
      TitleOfCourtesy: "Mr.",
      BirthDate: "1960-05-29 00:00:00.000",
      HireDate: "1994-01-02 00:00:00.000",
      Address: "Edgeham Hollow",
      City: "",
      Region: "",
      PostalCode: "",
      Country: "",
      HomePhone: "",
      Extension: "",
      Photo: "",
      Notes: "",
      ReportsTo: "",
      PhotoPath: ""
    },
    {
      EmployeeID: "Winchester Way",
      LastName: "London",
      FirstName: "NULL",
      Title: "RG1 9SP",
      TitleOfCourtesy: "UK",
      BirthDate: "(71) 555-5598",
      HireDate: 465,
      Address:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      City:
        "Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992",
      Region:
        'the year he joined the company.  After completing a course entitled "Selling in Europe',
      PostalCode: " he was transferred to the",
      Country: 5,
      HomePhone: "http://accweb/emmployees/davolio.bmp",
      Extension: "",
      Photo: "",
      Notes: "",
      ReportsTo: "",
      PhotoPath: ""
    },
    {
      EmployeeID: 8,
      LastName: "Callahan",
      FirstName: "Laura",
      Title: "Inside Sales Coordinator",
      TitleOfCourtesy: "Ms.",
      BirthDate: "1958-01-09 00:00:00.000",
      HireDate: "1994-03-05 00:00:00.000",
      Address: "4726 - 11th Ave. N.E.",
      City: "Seattle",
      Region: "WA",
      PostalCode: 98105,
      Country: "USA",
      HomePhone: "(206) 555-1189",
      Extension: 2344,
      Photo:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      Notes:
        "Laura received a BA in psychology from the University of Washington.  She has also completed a course in business French.  She reads and writes French.",
      ReportsTo: 2,
      PhotoPath: "http://accweb/emmployees/davolio.bmp"
    },
    {
      EmployeeID: 9,
      LastName: "Dodsworth",
      FirstName: "Anne",
      Title: "Sales Representative",
      TitleOfCourtesy: "Ms.",
      BirthDate: "1966-01-27 00:00:00.000",
      HireDate: "1994-11-15 00:00:00.000",
      Address: "7 Houndstooth Rd.",
      City: "London",
      Region: "NULL",
      PostalCode: "WG2 7LT",
      Country: "UK",
      HomePhone: "(71) 555-4444",
      Extension: 452,
      Photo:
        "0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D16540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000",
      Notes:
        "Anne has a BA degree in English from St. Lawrence College.  She is fluent in French and German.",
      ReportsTo: 5,
      PhotoPath: "http://accweb/emmployees/davolio.bmp"
    }
  ];

  // PROCESS DATA REQUESTS HERE
  switch (event.field) {
    case "allCustomers":
      return customers;
    case "getCustomer":
      var id = event.arguments.id;
      return customers.find(customer => customer.CustomerID == id);
    case "getCustomerOrders":
      var id = event.source.CustomerID;
      return orders.filter(order => order.CustomerID === id);
    case "allEmployees":
      return employees;
    case "getEmployee":
      var id = event.source.EmployeeID;
      return employees.find(employee => employee.EmployeeID == id);
    case "updateOrder":
      var id = event.arguments.OrderID;
      var order = orders.find(order => order.OrderID === id);
      order.ShippedDate = event.arguments.ShippedDate;
      return order;
    default:
      throw new Error("Unknown field, unable to resolve");
  }
};