The first and foremost step is to obtain the Pager component from Grid. Install the ej2-angular-grids package using the following command.
npm install @syncfusion/ej2-angular-grids --saveImport the Pager to the ListView sample which has been created.
import { Pager } from "@syncfusion/ej2-angular-grids";The totalRecordsCount property of Pager must be specified whenever using this particular component. By using pageSize property, the number of list items to be displayed is made available. The pageCount property allows the user to specify the visibility of the page numbers accordingly. Since the paging sample in the upcoming code snippet uses these three properties, the explanation provided here were minimal and to the point. For further API concerns in Pager component, click here.
With the help of the query property of ListView, the user can specify the number of records to be displayed in the current page.
The query property helps in splitting the entire datasource based on our convenience. In the sample provided below, when clicking the next button in pager, it fetches the datasource based on page size and current page of Pager component.
The headerTemplate and the template property of ListView is defined within ng-template. The required styles can be changed here accordingly.
public clickevent(args) {
this.query = new Query().range((args.currentPage - 1) * this.pagesize, (args.currentPage * this.pagesize));
}In the above code snippet, the event stores the currentPage value, and the datasource which is to be displayed in the next page is obtained.
Note: When pageize isn’t mentioned, it defaults to 12 records per page.
import { Component} from '@angular/core';
import { Browser } from '@syncfusion/ej2-base';
import { datasource } from './dataSource';
import { DataManager, Query, JsonAdaptor } from '@syncfusion/ej2-data';
import { Pager } from "@syncfusion/ej2-angular-grids";
@Component({
selector: 'my-app',
template: `<div class="control-section">
<ejs-listview id='listview' [dataSource]='data' [query]='query' showHeader='true' >
<ng-template #headerTemplate let-data="">
<table class="w-100"> <tr><td class="w-25">Order ID</td><td class="w-45">Ship Name</td><td class="w-25">Ship City</td></tr></table>
</ng-template>
<ng-template #template let-data="">
<table class="w-100"> <tr><td class="w-25">{{data.OrderID}}</td><td class="w-45">{{data.ShipName}}</td><td class="w-25" >{{data.ShipCity}}</td></tr></table>
</ng-template>
</ejs-listview>
<ejs-pager [pageSize]= 'pagesize' [totalRecordsCount]='totalrec' [pageCount]='pageCount' (click)='clickevent($event)'>
</ejs-pager>
</div>`
})
export class AppComponent {
public totalrec: number = datasource.length;
public pagesize: number = 10;
public pageCount: number = 2;
//Define an array of JSON data
public data: Object = new DataManager({
json: datasource,
adaptor: new JsonAdaptor
});
public query = new Query().range(0,this.pagesize);
public clickevent(args) {
this.query = new Query().range((args.currentPage - 1) * this.pagesize, (args.currentPage * this.pagesize));
}
constructor(){
this.templatecheck = Browser.isDevice;
}
}import { NgModule } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { AppComponent } from './app.component';
import { ListViewModule } from '@syncfusion/ej2-angular-lists';
import { ButtonModule } from '@syncfusion/ej2-angular-buttons';
import { PagerModule } from '@syncfusion/ej2-angular-grids';
/**
* Module
*/
@NgModule({
imports: [
BrowserModule,
ListViewModule, PagerModule, ButtonModule
],
declarations: [AppComponent],
bootstrap: [AppComponent]
})
export class AppModule { }export let datasource: Object[] = [
{
'OrderID': 10248,
'CustomerID': 'VINET',
'OrderDate': '1996-07-04T10:10:00.000Z',
'ShippedDate': '1996-07-16T12:20:00.000Z',
'Freight': 32.38,
'ShipName': 'Vins et alcools Chevalier',
'ShipAddress': '59 rue de l\'Abbaye',
'ShipCity': 'Reims',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10249,
'CustomerID': 'TOMSP',
'OrderDate': '1996-07-05T12:20:00.000Z',
'ShippedDate': '1996-07-10T13:20:00.000Z',
'Freight': 11.61,
'ShipName': 'Toms Spezialitäten',
'ShipAddress': 'Luisenstr. 48',
'ShipCity': 'Münster',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10250,
'CustomerID': 'HANAR',
'OrderDate': '1996-07-08T08:',
'ShippedDate': '1996-07-12T07:50:00.000Z',
'Freight': 65.83,
'ShipName': 'Hanari Carnes',
'ShipAddress': 'Rua do Paço, 67',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10251,
'CustomerID': 'VICTE',
'OrderDate': '1996-07-08T07:50:00.000Z',
'ShippedDate': '1996-07-15T15:50:00.000Z',
'Freight': 41.34,
'ShipName': 'Victuailles en stock',
'ShipAddress': '2, rue du Commerce',
'ShipCity': 'Lyon',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10252,
'CustomerID': 'SUPRD',
'OrderDate': '1996-07-09T12:05:00.000Z',
'ShippedDate': '1996-07-11T17:',
'Freight': 51.3,
'ShipName': 'Suprêmes délices',
'ShipAddress': 'Boulevard Tirou, 255',
'ShipCity': 'Charleroi',
'ShipRegion': null,
'ShipCountry': 'Belgium'
},
{
'OrderID': 10253,
'CustomerID': 'HANAR',
'OrderDate': '1996-07-10T11:20:00.000Z',
'ShippedDate': '1996-07-16T10:10:00.000Z',
'Freight': 58.17,
'ShipName': 'Hanari Carnes',
'ShipAddress': 'Rua do Paço, 67',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10254,
'CustomerID': 'CHOPS',
'OrderDate': '1996-07-11T10:00.00.000Z',
'ShippedDate': '1996-07-23T20:',
'Freight': 22.98,
'ShipName': 'Chop-suey Chinese',
'ShipAddress': 'Hauptstr. 31',
'ShipCity': 'Bern',
'ShipRegion': null,
'ShipCountry': 'Switzerland'
},
{
'OrderID': 10255,
'CustomerID': 'RICSU',
'OrderDate': '1996-07-12T10:',
'ShippedDate': '1996-07-15T05:',
'Freight': 148.33,
'ShipName': 'Richter Supermarkt',
'ShipAddress': 'Starenweg 5',
'ShipCity': 'Genève',
'ShipRegion': null,
'ShipCountry': 'Switzerland'
},
{
'OrderID': 10256,
'CustomerID': 'WELLI',
'OrderDate': '1996-07-15T20:50:00.000Z',
'ShippedDate': '1996-07-1750:00.000Z',
'Freight': 13.97,
'ShipName': 'Wellington Importadora',
'ShipAddress': 'Rua do Mercado, 12',
'ShipCity': 'Resende',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10257,
'CustomerID': 'HILAA',
'OrderDate': '1996-07-16T03:20:00.000Z',
'ShippedDate': '1996-07-22T14:',
'Freight': 81.91,
'ShipName': 'HILARION-Abastos',
'ShipAddress': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'ShipCity': 'San Cristóbal',
'ShipRegion': 'Táchira',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10258,
'CustomerID': 'ERNSH',
'OrderDate': '1996-07-17T18:',
'ShippedDate': '1996-07-23T14:50:00.000Z',
'Freight': 140.51,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10259,
'CustomerID': 'CENTC',
'OrderDate': '1996-07-18T01:20:00.000Z',
'ShippedDate': '1996-07-25T16:20:00.000Z',
'Freight': 3.25,
'ShipName': 'Centro comercial Moctezuma',
'ShipAddress': 'Sierras de Granada 9993',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10260,
'CustomerID': 'OTTIK',
'OrderDate': '1996-07-19T11:20:00.000Z',
'ShippedDate': '1996-07-29T03:10:00.000Z',
'Freight': 55.09,
'ShipName': 'Ottilies Käseladen',
'ShipAddress': 'Mehrheimerstr. 369',
'ShipCity': 'Köln',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10261,
'CustomerID': 'QUEDE',
'OrderDate': '1996-07-19T18:',
'ShippedDate': '1996-07-30T23:10:00.000Z',
'Freight': 3.05,
'ShipName': 'Que Delícia',
'ShipAddress': 'Rua da Panificadora, 12',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10262,
'CustomerID': 'RATTC',
'OrderDate': '1996-07-22',
'ShippedDate': '1996-07-25T19:10:00.000Z',
'Freight': 48.29,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10263,
'CustomerID': 'ERNSH',
'OrderDate': '1996-07-23T00:10:00.000Z',
'ShippedDate': '1996-07-31T22:50:00.000Z',
'Freight': 146.06,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10264,
'CustomerID': 'FOLKO',
'OrderDate': '1996-07-24T20:10:00.000Z',
'ShippedDate': '1996-08-23T11:',
'Freight': 3.67,
'ShipName': 'Folk och fä HB',
'ShipAddress': 'Åkergatan 24',
'ShipCity': 'Bräcke',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10265,
'CustomerID': 'BLONP',
'OrderDate': '1996-07-25T23:50:00.000Z',
'ShippedDate': '1996-08-12T02:10:00.000Z',
'Freight': 55.28,
'ShipName': 'Blondel père et fils',
'ShipAddress': '24, place Kléber',
'ShipCity': 'Strasbourg',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10266,
'CustomerID': 'WARTH',
'OrderDate': '1996-07-26T03:10:00.000Z',
'ShippedDate': '1996-07-31T01:50:00.000Z',
'Freight': 25.73,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10267,
'CustomerID': 'FRANK',
'OrderDate': '1996-07-29T04:10:00.000Z',
'ShippedDate': '1996-08-06T17:20:00.000Z',
'Freight': 208.58,
'ShipName': 'Frankenversand',
'ShipAddress': 'Berliner Platz 43',
'ShipCity': 'München',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10268,
'CustomerID': 'GROSR',
'OrderDate': '1996-07-30T01:20:00.000Z',
'ShippedDate': '1996-08-02T03:',
'Freight': 66.29,
'ShipName': 'GROSELLA-Restaurante',
'ShipAddress': '5ª Ave. Los Palos Grandes',
'ShipCity': 'Caracas',
'ShipRegion': 'DF',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10269,
'CustomerID': 'WHITC',
'OrderDate': '1996-07-31T05:10:00.000Z',
'ShippedDate': '1996-08-09T07:10:00.000Z',
'Freight': 4.56,
'ShipName': 'White Clover Markets',
'ShipAddress': '1029 - 12th Ave. S.',
'ShipCity': 'Seattle',
'ShipRegion': 'WA',
'ShipCountry': 'USA'
},
{
'OrderID': 10270,
'CustomerID': 'WARTH',
'OrderDate': '1996-08-01T09:10:00.000Z',
'ShippedDate': '1996-08-02T11:10:00.000Z',
'Freight': 136.54,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10271,
'CustomerID': 'SPLIR',
'OrderDate': '1996-08-01T13:10:00.000Z',
'ShippedDate': '1996-08-30T15:10:00.000Z',
'Freight': 4.54,
'ShipName': 'Split Rail Beer & Ale',
'ShipAddress': 'P.O. Box 555',
'ShipCity': 'Lander',
'ShipRegion': 'WY',
'ShipCountry': 'USA'
},
{
'OrderID': 10272,
'CustomerID': 'RATTC',
'OrderDate': '1996-08-02T17:10:00.000Z',
'ShippedDate': '1996-08-06T19:10:00.000Z',
'Freight': 98.03,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10273,
'CustomerID': 'QUICK',
'OrderDate': '1996-08-0510:00.000Z',
'ShippedDate': '1996-08-12T23:10:00.000Z',
'Freight': 76.07,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10274,
'CustomerID': 'VINET',
'OrderDate': '1996-08-06T02:10:00.000Z',
'ShippedDate': '1996-08-16T04:10:00.000Z',
'Freight': 6.01,
'ShipName': 'Vins et alcools Chevalier',
'ShipAddress': '59 rue de l\'Abbaye',
'ShipCity': 'Reims',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10275,
'CustomerID': 'MAGAA',
'OrderDate': '1996-08-07T06:10:00.000Z',
'ShippedDate': '1996-08-09T08:10:00.000Z',
'Freight': 26.93,
'ShipName': 'Magazzini Alimentari Riuniti',
'ShipAddress': 'Via Ludovico il Moro 22',
'ShipCity': 'Bergamo',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10276,
'CustomerID': 'TORTU',
'OrderDate': '1996-08-08T10:10:00.000Z',
'ShippedDate': '1996-08-14T12:10:00.000Z',
'Freight': 13.84,
'ShipName': 'Tortuga Restaurante',
'ShipAddress': 'Avda. Azteca 123',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10277,
'CustomerID': 'MORGK',
'OrderDate': '1996-08-09T14:10:00.000Z',
'ShippedDate': '1996-08-13T16:10:00.000Z',
'Freight': 125.77,
'ShipName': 'Morgenstern Gesundkost',
'ShipAddress': 'Heerstr. 22',
'ShipCity': 'Leipzig',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10278,
'CustomerID': 'BERGS',
'OrderDate': '1996-08-12T18:10:00.000Z',
'ShippedDate': '1996-08-16T20:10:00.000Z',
'Freight': 92.69,
'ShipName': 'Berglunds snabbköp',
'ShipAddress': 'Berguvsvägen 8',
'ShipCity': 'Luleå',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10279,
'CustomerID': 'LEHMS',
'OrderDate': '1996-08-13T22:10:00.000Z',
'ShippedDate': '1996-08-16T02:10:00.000Z',
'Freight': 25.83,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10280,
'CustomerID': 'BERGS',
'OrderDate': '1996-08-14T01:',
'ShippedDate': '1996-09-12T02:',
'Freight': 8.98,
'ShipName': 'Berglunds snabbköp',
'ShipAddress': 'Berguvsvägen 8',
'ShipCity': 'Luleå',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10281,
'CustomerID': 'ROMEY',
'OrderDate': '1996-08-14T03:',
'ShippedDate': '1996-08-21T04:',
'Freight': 2.94,
'ShipName': 'Romero y tomillo',
'ShipAddress': 'Gran Vía, 1',
'ShipCity': 'Madrid',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10282,
'CustomerID': 'ROMEY',
'OrderDate': '1996-08-15T05:',
'ShippedDate': '1996-08-21T06:',
'Freight': 12.69,
'ShipName': 'Romero y tomillo',
'ShipAddress': 'Gran Vía, 1',
'ShipCity': 'Madrid',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10283,
'CustomerID': 'LILAS',
'OrderDate': '1996-08-16T07:',
'ShippedDate': '1996-08-23T08:',
'Freight': 84.81,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10284,
'CustomerID': 'LEHMS',
'OrderDate': '1996-08-19T09:',
'ShippedDate': '1996-08-27T10:',
'Freight': 76.56,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10285,
'CustomerID': 'QUICK',
'OrderDate': '1996-08-20T11:',
'ShippedDate': '1996-08-26T12:',
'Freight': 76.83,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10286,
'CustomerID': 'QUICK',
'OrderDate': '1996-08-21T01:50:00.000Z',
'ShippedDate': '1996-08-30T02:50:00.000Z',
'Freight': 229.24,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10287,
'CustomerID': 'RICAR',
'OrderDate': '1996-08-22T03:50:00.000Z',
'ShippedDate': '1996-08-28T04:50:00.000Z',
'Freight': 12.76,
'ShipName': 'Ricardo Adocicados',
'ShipAddress': 'Av. Copacabana, 267',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10288,
'CustomerID': 'REGGC',
'OrderDate': '1996-08-23T05:50:00.000Z',
'ShippedDate': '1996-09-03T06:50:00.000Z',
'Freight': 7.45,
'ShipName': 'Reggiani Caseifici',
'ShipAddress': 'Strada Provinciale 124',
'ShipCity': 'Reggio Emilia',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10289,
'CustomerID': 'BSBEV',
'OrderDate': '1996-08-26T07:50:00.000Z',
'ShippedDate': '1996-08-28T08:50:00.000Z',
'Freight': 22.77,
'ShipName': 'B\'s Beverages',
'ShipAddress': 'Fauntleroy Circus',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10290,
'CustomerID': 'COMMI',
'OrderDate': '1996-08-27T09:50:00.000Z',
'ShippedDate': '1996-09-03T10:50:00.000Z',
'Freight': 79.7,
'ShipName': 'Comércio Mineiro',
'ShipAddress': 'Av. dos Lusíadas, 23',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10291,
'CustomerID': 'QUEDE',
'OrderDate': '1996-08-27T11:50:00.000Z',
'ShippedDate': '1996-09-04T12:50:00.000Z',
'Freight': 6.4,
'ShipName': 'Que Delícia',
'ShipAddress': 'Rua da Panificadora, 12',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10292,
'CustomerID': 'TRADH',
'OrderDate': '1996-08-28T01:10:00.000Z',
'ShippedDate': '1996-09-02T02:10:00.000Z',
'Freight': 1.35,
'ShipName': 'Tradiçao Hipermercados',
'ShipAddress': 'Av. Inês de Castro, 414',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10293,
'CustomerID': 'TORTU',
'OrderDate': '1996-08-29T03:10:00.000Z',
'ShippedDate': '1996-09-11T04:10:00.000Z',
'Freight': 21.18,
'ShipName': 'Tortuga Restaurante',
'ShipAddress': 'Avda. Azteca 123',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10294,
'CustomerID': 'RATTC',
'OrderDate': '1996-08-30T05:10:00.000Z',
'ShippedDate': '1996-09-05T06:10:00.000Z',
'Freight': 147.26,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10295,
'CustomerID': 'VINET',
'OrderDate': '1996-09-02T07:10:00.000Z',
'ShippedDate': '1996-09-10T08:10:00.000Z',
'Freight': 1.15,
'ShipName': 'Vins et alcools Chevalier',
'ShipAddress': '59 rue de l\'Abbaye',
'ShipCity': 'Reims',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10296,
'CustomerID': 'LILAS',
'OrderDate': '1996-09-03T09:10:00.000Z',
'ShippedDate': '1996-09-11T10:10:00.000Z',
'Freight': 0.12,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10297,
'CustomerID': 'BLONP',
'OrderDate': '1996-09-04T11:10:00.000Z',
'ShippedDate': '1996-09-10T12:10:00.000Z',
'Freight': 5.74,
'ShipName': 'Blondel père et fils',
'ShipAddress': '24, place Kléber',
'ShipCity': 'Strasbourg',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10298,
'CustomerID': 'HUNGO',
'OrderDate': '1996-09-05T01:10:00.000Z',
'ShippedDate': '1996-09-11T02:20:00.000Z',
'Freight': 168.22,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10299,
'CustomerID': 'RICAR',
'OrderDate': '1996-09-06T03:20:00.000Z',
'ShippedDate': '1996-09-13T04:20:00.000Z',
'Freight': 29.76,
'ShipName': 'Ricardo Adocicados',
'ShipAddress': 'Av. Copacabana, 267',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10300,
'CustomerID': 'MAGAA',
'OrderDate': '1996-09-09T05:20:00.000Z',
'ShippedDate': '1996-09-18T06:20:00.000Z',
'Freight': 17.68,
'ShipName': 'Magazzini Alimentari Riuniti',
'ShipAddress': 'Via Ludovico il Moro 22',
'ShipCity': 'Bergamo',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10301,
'CustomerID': 'WANDK',
'OrderDate': '1996-09-09T07:20:00.000Z',
'ShippedDate': '1996-09-17T08:20:00.000Z',
'Freight': 45.08,
'ShipName': 'Die Wandernde Kuh',
'ShipAddress': 'Adenauerallee 900',
'ShipCity': 'Stuttgart',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10302,
'CustomerID': 'SUPRD',
'OrderDate': '1996-09-10T09:20:00.000Z',
'ShippedDate': '1996-10-09T10:20:00.000Z',
'Freight': 6.27,
'ShipName': 'Suprêmes délices',
'ShipAddress': 'Boulevard Tirou, 255',
'ShipCity': 'Charleroi',
'ShipRegion': null,
'ShipCountry': 'Belgium'
},
{
'OrderID': 10303,
'CustomerID': 'GODOS',
'OrderDate': '1996-09-11T11:20:00.000Z',
'ShippedDate': '1996-09-18T12:20:00.000Z',
'Freight': 107.83,
'ShipName': 'Godos Cocina Típica',
'ShipAddress': 'C/ Romero, 33',
'ShipCity': 'Sevilla',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10304,
'CustomerID': 'TORTU',
'OrderDate': '1996-09-12T00:10:00.000Z',
'ShippedDate': '1996-09-17T01:20:00.000Z',
'Freight': 63.79,
'ShipName': 'Tortuga Restaurante',
'ShipAddress': 'Avda. Azteca 123',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10305,
'CustomerID': 'OLDWO',
'OrderDate': '1996-09-13T01:20:00.000Z',
'ShippedDate': '1996-10-09T02:20:00.000Z',
'Freight': 257.62,
'ShipName': 'Old World Delicatessen',
'ShipAddress': '2743 Bering St.',
'ShipCity': 'Anchorage',
'ShipRegion': 'AK',
'ShipCountry': 'USA'
},
{
'OrderID': 10306,
'CustomerID': 'ROMEY',
'OrderDate': '1996-09-16T03:20:00.000Z',
'ShippedDate': '1996-09-23T04:20:00.000Z',
'Freight': 7.56,
'ShipName': 'Romero y tomillo',
'ShipAddress': 'Gran Vía, 1',
'ShipCity': 'Madrid',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10307,
'CustomerID': 'LONEP',
'OrderDate': '1996-09-17T05:20:00.000Z',
'ShippedDate': '1996-09-25T06:20:00.000Z',
'Freight': 0.56,
'ShipName': 'Lonesome Pine Restaurant',
'ShipAddress': '89 Chiaroscuro Rd.',
'ShipCity': 'Portland',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10308,
'CustomerID': 'ANATR',
'OrderDate': '1996-09-18T07:20:00.000Z',
'ShippedDate': '1996-09-24T08:20:00.000Z',
'Freight': 1.61,
'ShipName': 'Ana Trujillo Emparedados y helados',
'ShipAddress': 'Avda. de la Constitución 2222',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10309,
'CustomerID': 'HUNGO',
'OrderDate': '1996-09-19T09:20:00.000Z',
'ShippedDate': '1996-10-23T10:20:00.000Z',
'Freight': 47.3,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10310,
'CustomerID': 'THEBI',
'OrderDate': '1996-09-20T11:20:00.000Z',
'ShippedDate': '1996-09-27T12:20:00.000Z',
'Freight': 17.52,
'ShipName': 'The Big Cheese',
'ShipAddress': '89 Jefferson Way Suite 2',
'ShipCity': 'Portland',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10311,
'CustomerID': 'DUMON',
'OrderDate': '1996-09-20T13:20:00.000Z',
'ShippedDate': '1996-09-26T14:20:00.000Z',
'Freight': 24.69,
'ShipName': 'Du monde entier',
'ShipAddress': '67, rue des Cinquante Otages',
'ShipCity': 'Nantes',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10312,
'CustomerID': 'WANDK',
'OrderDate': '1996-09-23T15:20:00.000Z',
'ShippedDate': '1996-10-03T16:20:00.000Z',
'Freight': 40.26,
'ShipName': 'Die Wandernde Kuh',
'ShipAddress': 'Adenauerallee 900',
'ShipCity': 'Stuttgart',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10313,
'CustomerID': 'QUICK',
'OrderDate': '1996-09-24T17:20:00.000Z',
'ShippedDate': '1996-10-04T18:20:00.000Z',
'Freight': 1.96,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10314,
'CustomerID': 'RATTC',
'OrderDate': '1996-09-25T19:20:00.000Z',
'ShippedDate': '1996-10-04T20:20:00.000Z',
'Freight': 74.16,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10315,
'CustomerID': 'ISLAT',
'OrderDate': '1996-09-2620:00.000Z',
'ShippedDate': '1996-10-03T22:20:00.000Z',
'Freight': 41.76,
'ShipName': 'Island Trading',
'ShipAddress': 'Garden House Crowther Way',
'ShipCity': 'Cowes',
'ShipRegion': 'Isle of Wight',
'ShipCountry': 'UK'
},
{
'OrderID': 10316,
'CustomerID': 'RATTC',
'OrderDate': '1996-09-27T23:20:00.000Z',
'ShippedDate': '1996-10-08T00:',
'Freight': 150.15,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10317,
'CustomerID': 'LONEP',
'OrderDate': '1996-09-30T',
'ShippedDate': '1996-10-10',
'Freight': 12.69,
'ShipName': 'Lonesome Pine Restaurant',
'ShipAddress': '89 Chiaroscuro Rd.',
'ShipCity': 'Portland',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10318,
'CustomerID': 'ISLAT',
'OrderDate': '1996-10-01T03:',
'ShippedDate': '1996-10-04T03:',
'Freight': 4.73,
'ShipName': 'Island Trading',
'ShipAddress': 'Garden House Crowther Way',
'ShipCity': 'Cowes',
'ShipRegion': 'Isle of Wight',
'ShipCountry': 'UK'
},
{
'OrderID': 10319,
'CustomerID': 'TORTU',
'OrderDate': '1996-10-02T04:',
'ShippedDate': '1996-10-11T05:',
'Freight': 64.5,
'ShipName': 'Tortuga Restaurante',
'ShipAddress': 'Avda. Azteca 123',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10320,
'CustomerID': 'WARTH',
'OrderDate': '1996-10-03T06:',
'ShippedDate': '1996-10-18T07:',
'Freight': 34.57,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10321,
'CustomerID': 'ISLAT',
'OrderDate': '1996-10-03T08:',
'ShippedDate': '1996-10-11T09:',
'Freight': 3.43,
'ShipName': 'Island Trading',
'ShipAddress': 'Garden House Crowther Way',
'ShipCity': 'Cowes',
'ShipRegion': 'Isle of Wight',
'ShipCountry': 'UK'
},
{
'OrderID': 10322,
'CustomerID': 'PERIC',
'OrderDate': '1996-10-04T10:',
'ShippedDate': '1996-10-23T11:',
'Freight': 0.4,
'ShipName': 'Pericles Comidas clásicas',
'ShipAddress': 'Calle Dr. Jorge Cash 321',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10323,
'CustomerID': 'KOENE',
'OrderDate': '1996-10-07T12:',
'ShippedDate': '1996-10-14T13:',
'Freight': 4.88,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10324,
'CustomerID': 'SAVEA',
'OrderDate': '1996-10-08T14:',
'ShippedDate': '1996-10-10T15:',
'Freight': 214.27,
'ShipName': 'Save-a-lot Markets',
'ShipAddress': '187 Suffolk Ln.',
'ShipCity': 'Boise',
'ShipRegion': 'ID',
'ShipCountry': 'USA'
},
{
'OrderID': 10325,
'CustomerID': 'KOENE',
'OrderDate': '1996-10-09T16:',
'ShippedDate': '1996-10-14T17:',
'Freight': 64.86,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10326,
'CustomerID': 'BOLID',
'OrderDate': '1996-10-10T18:',
'ShippedDate': '1996-10-14T19:',
'Freight': 77.92,
'ShipName': 'Bólido Comidas preparadas',
'ShipAddress': 'C/ Araquil, 67',
'ShipCity': 'Madrid',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10327,
'CustomerID': 'FOLKO',
'OrderDate': '1996-10-11T20:',
'ShippedDate': '1996-10-14',
'Freight': 63.36,
'ShipName': 'Folk och fä HB',
'ShipAddress': 'Åkergatan 24',
'ShipCity': 'Bräcke',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10328,
'CustomerID': 'FURIB',
'OrderDate': '1996-10-14T22:',
'ShippedDate': '1996-10-17T23:',
'Freight': 87.03,
'ShipName': 'Furia Bacalhau e Frutos do Mar',
'ShipAddress': 'Jardim das rosas n. 32',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10329,
'CustomerID': 'SPLIR',
'OrderDate': '1996-10-15T00:',
'ShippedDate': '1996-10-23T01:',
'Freight': 191.67,
'ShipName': 'Split Rail Beer & Ale',
'ShipAddress': 'P.O. Box 555',
'ShipCity': 'Lander',
'ShipRegion': 'WY',
'ShipCountry': 'USA'
},
{
'OrderID': 10330,
'CustomerID': 'LILAS',
'OrderDate': '1996-10-16T02:',
'ShippedDate': '1996-10-28T03:',
'Freight': 12.75,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10331,
'CustomerID': 'BONAP',
'OrderDate': '1996-10-16T02:',
'ShippedDate': '1996-10-21T03:',
'Freight': 10.19,
'ShipName': 'Bon app',
'ShipAddress': '12, rue des Bouchers',
'ShipCity': 'Marseille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10332,
'CustomerID': 'MEREP',
'OrderDate': '1996-10-17T04:',
'ShippedDate': '1996-10-21T05:',
'Freight': 52.84,
'ShipName': 'Mère Paillarde',
'ShipAddress': '43 rue St. Laurent',
'ShipCity': 'Montréal',
'ShipRegion': 'Québec',
'ShipCountry': 'Canada'
},
{
'OrderID': 10333,
'CustomerID': 'WARTH',
'OrderDate': '1996-10-18T06:',
'ShippedDate': '1996-10-25T07:',
'Freight': 0.59,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10334,
'CustomerID': 'VICTE',
'OrderDate': '1996-10-21T08:',
'ShippedDate': '1996-10-28T09:',
'Freight': 8.56,
'ShipName': 'Victuailles en stock',
'ShipAddress': '2, rue du Commerce',
'ShipCity': 'Lyon',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10335,
'CustomerID': 'HUNGO',
'OrderDate': '1996-10-22T10:',
'ShippedDate': '1996-10-24T11:',
'Freight': 42.11,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10336,
'CustomerID': 'PRINI',
'OrderDate': '1996-10-23T12:',
'ShippedDate': '1996-10-25T13:',
'Freight': 15.51,
'ShipName': 'Princesa Isabel Vinhos',
'ShipAddress': 'Estrada da saúde n. 58',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10337,
'CustomerID': 'FRANK',
'OrderDate': '1996-10-24T14:',
'ShippedDate': '1996-10-29T14:',
'Freight': 108.26,
'ShipName': 'Frankenversand',
'ShipAddress': 'Berliner Platz 43',
'ShipCity': 'München',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10338,
'CustomerID': 'OLDWO',
'OrderDate': '1996-10-25T15:',
'ShippedDate': '1996-10-29T16:',
'Freight': 84.21,
'ShipName': 'Old World Delicatessen',
'ShipAddress': '2743 Bering St.',
'ShipCity': 'Anchorage',
'ShipRegion': 'AK',
'ShipCountry': 'USA'
},
{
'OrderID': 10339,
'CustomerID': 'MEREP',
'OrderDate': '1996-10-28T17:',
'ShippedDate': '1996-11-04T18:',
'Freight': 15.66,
'ShipName': 'Mère Paillarde',
'ShipAddress': '43 rue St. Laurent',
'ShipCity': 'Montréal',
'ShipRegion': 'Québec',
'ShipCountry': 'Canada'
},
{
'OrderID': 10340,
'CustomerID': 'BONAP',
'OrderDate': '1996-10-29T19:',
'ShippedDate': '1996-11-08T20:',
'Freight': 166.31,
'ShipName': 'Bon app',
'ShipAddress': '12, rue des Bouchers',
'ShipCity': 'Marseille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10341,
'CustomerID': 'SIMOB',
'OrderDate': '1996-10-29',
'ShippedDate': '1996-11-05T22:',
'Freight': 26.78,
'ShipName': 'Simons bistro',
'ShipAddress': 'Vinbæltet 34',
'ShipCity': 'Kobenhavn',
'ShipRegion': null,
'ShipCountry': 'Denmark'
},
{
'OrderID': 10342,
'CustomerID': 'FRANK',
'OrderDate': '1996-10-30T23:',
'ShippedDate': '1996-11-04T00:50:00.000Z',
'Freight': 54.83,
'ShipName': 'Frankenversand',
'ShipAddress': 'Berliner Platz 43',
'ShipCity': 'München',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10343,
'CustomerID': 'LEHMS',
'OrderDate': '1996-10-31T01:50:00.000Z',
'ShippedDate': '1996-11-06T02:50:00.000Z',
'Freight': 110.37,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10344,
'CustomerID': 'WHITC',
'OrderDate': '1996-11-01T03:50:00.000Z',
'ShippedDate': '1996-11-05T04:50:00.000Z',
'Freight': 23.29,
'ShipName': 'White Clover Markets',
'ShipAddress': '1029 - 12th Ave. S.',
'ShipCity': 'Seattle',
'ShipRegion': 'WA',
'ShipCountry': 'USA'
},
{
'OrderID': 10345,
'CustomerID': 'QUICK',
'OrderDate': '1996-11-04T05:50:00.000Z',
'ShippedDate': '1996-11-11T05:50:00.000Z',
'Freight': 249.06,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10346,
'CustomerID': 'RATTC',
'OrderDate': '1996-11-05T06:50:00.000Z',
'ShippedDate': '1996-11-08T07:50:00.000Z',
'Freight': 142.08,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10347,
'CustomerID': 'FAMIA',
'OrderDate': '1996-11-06T08:50:00.000Z',
'ShippedDate': '1996-11-08T09:50:00.000Z',
'Freight': 3.1,
'ShipName': 'Familia Arquibaldo',
'ShipAddress': 'Rua Orós, 92',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10348,
'CustomerID': 'WANDK',
'OrderDate': '1996-11-07T10:50:00.000Z',
'ShippedDate': '1996-11-15T11:50:00.000Z',
'Freight': 0.78,
'ShipName': 'Die Wandernde Kuh',
'ShipAddress': 'Adenauerallee 900',
'ShipCity': 'Stuttgart',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10349,
'CustomerID': 'SPLIR',
'OrderDate': '1996-11-08T12:50:00.000Z',
'ShippedDate': '1996-11-15T13:50:00.000Z',
'Freight': 8.63,
'ShipName': 'Split Rail Beer & Ale',
'ShipAddress': 'P.O. Box 555',
'ShipCity': 'Lander',
'ShipRegion': 'WY',
'ShipCountry': 'USA'
},
{
'OrderID': 10350,
'CustomerID': 'LAMAI',
'OrderDate': '1996-11-11T14:50:00.000Z',
'ShippedDate': '1996-12-03T15:50:00.000Z',
'Freight': 64.19,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10351,
'CustomerID': 'ERNSH',
'OrderDate': '1996-11-11T16:50:00.000Z',
'ShippedDate': '1996-11-20T17:50:00.000Z',
'Freight': 162.33,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10352,
'CustomerID': 'FURIB',
'OrderDate': '1996-11-12T18:50:00.000Z',
'ShippedDate': '1996-11-18T19:50:00.000Z',
'Freight': 1.3,
'ShipName': 'Furia Bacalhau e Frutos do Mar',
'ShipAddress': 'Jardim das rosas n. 32',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10353,
'CustomerID': 'PICCO',
'OrderDate': '1996-11-13T20:50:00.000Z',
'ShippedDate': '1996-11-2550:00.000Z',
'Freight': 360.63,
'ShipName': 'Piccolo und mehr',
'ShipAddress': 'Geislweg 14',
'ShipCity': 'Salzburg',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10354,
'CustomerID': 'PERIC',
'OrderDate': '1996-11-1450:00.000Z',
'ShippedDate': '1996-11-20T22:50:00.000Z',
'Freight': 53.8,
'ShipName': 'Pericles Comidas clásicas',
'ShipAddress': 'Calle Dr. Jorge Cash 321',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10355,
'CustomerID': 'AROUT',
'OrderDate': '1996-11-15T23:50:00.000Z',
'ShippedDate': '1996-11-20T00:50:00.000Z',
'Freight': 41.95,
'ShipName': 'Around the Horn',
'ShipAddress': 'Brook Farm Stratford St. Mary',
'ShipCity': 'Colchester',
'ShipRegion': 'Essex',
'ShipCountry': 'UK'
},
{
'OrderID': 10356,
'CustomerID': 'WANDK',
'OrderDate': '1996-11-18T01:05:00.000Z',
'ShippedDate': '1996-11-27T02:05:00.000Z',
'Freight': 36.71,
'ShipName': 'Die Wandernde Kuh',
'ShipAddress': 'Adenauerallee 900',
'ShipCity': 'Stuttgart',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10357,
'CustomerID': 'LILAS',
'OrderDate': '1996-11-19T03:05:00.000Z',
'ShippedDate': '1996-12-02T04:05:00.000Z',
'Freight': 34.88,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10358,
'CustomerID': 'LAMAI',
'OrderDate': '1996-11-20T05:05:00.000Z',
'ShippedDate': '1996-11-27T06:05:00.000Z',
'Freight': 19.64,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10359,
'CustomerID': 'SEVES',
'OrderDate': '1996-11-21T07:05:00.000Z',
'ShippedDate': '1996-11-26T08:05:00.000Z',
'Freight': 288.43,
'ShipName': 'Seven Seas Imports',
'ShipAddress': '90 Wadhurst Rd.',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10360,
'CustomerID': 'BLONP',
'OrderDate': '1996-11-22T09:05:00.000Z',
'ShippedDate': '1996-12-02T10:05:00.000Z',
'Freight': 131.7,
'ShipName': 'Blondel père et fils',
'ShipAddress': '24, place Kléber',
'ShipCity': 'Strasbourg',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10361,
'CustomerID': 'QUICK',
'OrderDate': '1996-11-22T11:05:00.000Z',
'ShippedDate': '1996-12-03T12:05:00.000Z',
'Freight': 183.17,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10362,
'CustomerID': 'BONAP',
'OrderDate': '1996-11-25T13:05:00.000Z',
'ShippedDate': '1996-11-28T14:05:00.000Z',
'Freight': 96.04,
'ShipName': 'Bon app',
'ShipAddress': '12, rue des Bouchers',
'ShipCity': 'Marseille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10363,
'CustomerID': 'DRACD',
'OrderDate': '1996-11-26T15:05:00.000Z',
'ShippedDate': '1996-12-04T16:05:00.000Z',
'Freight': 30.54,
'ShipName': 'Drachenblut Delikatessen',
'ShipAddress': 'Walserweg 21',
'ShipCity': 'Aachen',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10364,
'CustomerID': 'EASTC',
'OrderDate': '1996-11-26T17:05:00.000Z',
'ShippedDate': '1996-12-04T18:05:00.000Z',
'Freight': 71.97,
'ShipName': 'Eastern Connection',
'ShipAddress': '35 King George',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10365,
'CustomerID': 'ANTON',
'OrderDate': '1996-11-27T19:05:00.000Z',
'ShippedDate': '1996-12-02T20:05:00.000Z',
'Freight': 22,
'ShipName': 'Antonio Moreno Taquería',
'ShipAddress': 'Mataderos 2312',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10366,
'CustomerID': 'GALED',
'OrderDate': '1996-11-2805:00.000Z',
'ShippedDate': '1996-12-30T22:05:00.000Z',
'Freight': 10.14,
'ShipName': 'Galería del gastronómo',
'ShipAddress': 'Rambla de Cataluña, 23',
'ShipCity': 'Barcelona',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10367,
'CustomerID': 'VAFFE',
'OrderDate': '1996-11-28T23:05:00.000Z',
'ShippedDate': '1996-12-02T00:05:00.000Z',
'Freight': 13.55,
'ShipName': 'Vaffeljernet',
'ShipAddress': 'Smagsloget 45',
'ShipCity': 'Århus',
'ShipRegion': null,
'ShipCountry': 'Denmark'
},
{
'OrderID': 10368,
'CustomerID': 'ERNSH',
'OrderDate': '1996-11-29T02:00.00.000Z',
'ShippedDate': '1996-12-02T04:00.00.000Z',
'Freight': 101.95,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10369,
'CustomerID': 'SPLIR',
'OrderDate': '1996-12-02T04:00.00.000Z',
'ShippedDate': '1996-12-09T07:25:00.000Z',
'Freight': 195.68,
'ShipName': 'Split Rail Beer & Ale',
'ShipAddress': 'P.O. Box 555',
'ShipCity': 'Lander',
'ShipRegion': 'WY',
'ShipCountry': 'USA'
},
{
'OrderID': 10370,
'CustomerID': 'CHOPS',
'OrderDate': '1996-12-03T06:00.00.000Z',
'ShippedDate': '1996-12-27T07:00.00.000Z',
'Freight': 1.17,
'ShipName': 'Chop-suey Chinese',
'ShipAddress': 'Hauptstr. 31',
'ShipCity': 'Bern',
'ShipRegion': null,
'ShipCountry': 'Switzerland'
},
{
'OrderID': 10371,
'CustomerID': 'LAMAI',
'OrderDate': '1996-12-03T08:00.00.000Z',
'ShippedDate': '1996-12-24T09:00.00.000Z',
'Freight': 0.45,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10372,
'CustomerID': 'QUEEN',
'OrderDate': '1996-12-04T10:00.00.000Z',
'ShippedDate': '1996-12-09T11:00.00.000Z',
'Freight': 890.78,
'ShipName': 'Queen Cozinha',
'ShipAddress': 'Alameda dos Canàrios, 891',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10373,
'CustomerID': 'HUNGO',
'OrderDate': '1996-12-05T12:00.00.000Z',
'ShippedDate': '1996-12-11T13:00.00.000Z',
'Freight': 124.12,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10374,
'CustomerID': 'WOLZA',
'OrderDate': '1996-12-05T14:00.00.000Z',
'ShippedDate': '1996-12-09T15:00.00.000Z',
'Freight': 3.94,
'ShipName': 'Wolski Zajazd',
'ShipAddress': 'ul. Filtrowa 68',
'ShipCity': 'Warszawa',
'ShipRegion': null,
'ShipCountry': 'Poland'
},
{
'OrderID': 10375,
'CustomerID': 'HUNGC',
'OrderDate': '1996-12-06T16:00.00.000Z',
'ShippedDate': '1996-12-09T17:00.00.000Z',
'Freight': 20.12,
'ShipName': 'Hungry Coyote Import Store',
'ShipAddress': 'City Center Plaza 516 Main St.',
'ShipCity': 'Elgin',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10376,
'CustomerID': 'MEREP',
'OrderDate': '1996-12-09T18:00.00.000Z',
'ShippedDate': '1996-12-13T19:00.00.000Z',
'Freight': 20.39,
'ShipName': 'Mère Paillarde',
'ShipAddress': '43 rue St. Laurent',
'ShipCity': 'Montréal',
'ShipRegion': 'Québec',
'ShipCountry': 'Canada'
},
{
'OrderID': 10377,
'CustomerID': 'SEVES',
'OrderDate': '1996-12-09T20:00.00.000Z',
'ShippedDate': '1996-12-1300.00.000Z',
'Freight': 22.21,
'ShipName': 'Seven Seas Imports',
'ShipAddress': '90 Wadhurst Rd.',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10378,
'CustomerID': 'FOLKO',
'OrderDate': '1996-12-10T22:00.00.000Z',
'ShippedDate': '1996-12-19T23:00.00.000Z',
'Freight': 5.44,
'ShipName': 'Folk och fä HB',
'ShipAddress': 'Åkergatan 24',
'ShipCity': 'Bräcke',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10379,
'CustomerID': 'QUEDE',
'OrderDate': '1996-12-11T01:25:00.000Z',
'ShippedDate': '1996-12-13T02:25:00.000Z',
'Freight': 45.03,
'ShipName': 'Que Delícia',
'ShipAddress': 'Rua da Panificadora, 12',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10380,
'CustomerID': 'HUNGO',
'OrderDate': '1996-12-12T03:25:00.000Z',
'ShippedDate': '1997-01-16T04:25:00.000Z',
'Freight': 35.03,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10381,
'CustomerID': 'LILAS',
'OrderDate': '1996-12-12T05:25:00.000Z',
'ShippedDate': '1996-12-13T06:25:00.000Z',
'Freight': 7.99,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10382,
'CustomerID': 'ERNSH',
'OrderDate': '1996-12-13T07:25:00.000Z',
'ShippedDate': '1996-12-16T07:25:00.000Z',
'Freight': 94.77,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10383,
'CustomerID': 'AROUT',
'OrderDate': '1996-12-16T07:25:00.000Z',
'ShippedDate': '1996-12-18T02:25:00.000Z',
'Freight': 34.24,
'ShipName': 'Around the Horn',
'ShipAddress': 'Brook Farm Stratford St. Mary',
'ShipCity': 'Colchester',
'ShipRegion': 'Essex',
'ShipCountry': 'UK'
},
{
'OrderID': 10384,
'CustomerID': 'BERGS',
'OrderDate': '1996-12-16T03:25:00.000Z',
'ShippedDate': '1996-12-20T04:25:00.000Z',
'Freight': 168.64,
'ShipName': 'Berglunds snabbköp',
'ShipAddress': 'Berguvsvägen 8',
'ShipCity': 'Luleå',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10385,
'CustomerID': 'SPLIR',
'OrderDate': '1996-12-17T04:25:00.000Z',
'ShippedDate': '1996-12-23T04:25:00.000Z',
'Freight': 30.96,
'ShipName': 'Split Rail Beer & Ale',
'ShipAddress': 'P.O. Box 555',
'ShipCity': 'Lander',
'ShipRegion': 'WY',
'ShipCountry': 'USA'
},
{
'OrderID': 10386,
'CustomerID': 'FAMIA',
'OrderDate': '1996-12-18T05:25:00.000Z',
'ShippedDate': '1996-12-25T06:25:00.000Z',
'Freight': 13.99,
'ShipName': 'Familia Arquibaldo',
'ShipAddress': 'Rua Orós, 92',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10387,
'CustomerID': 'SANTG',
'OrderDate': '1996-12-18T07:25:00.000Z',
'ShippedDate': '1996-12-20T08:25:00.000Z',
'Freight': 93.63,
'ShipName': 'Santé Gourmet',
'ShipAddress': 'Erling Skakkes gate 78',
'ShipCity': 'Stavern',
'ShipRegion': null,
'ShipCountry': 'Norway'
},
{
'OrderID': 10388,
'CustomerID': 'SEVES',
'OrderDate': '1996-12-19T09:25:00.000Z',
'ShippedDate': '1996-12-20T10:25:00.000Z',
'Freight': 34.86,
'ShipName': 'Seven Seas Imports',
'ShipAddress': '90 Wadhurst Rd.',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10389,
'CustomerID': 'BOTTM',
'OrderDate': '1996-12-20T11:25:00.000Z',
'ShippedDate': '1996-12-24T12:25:00.000Z',
'Freight': 47.42,
'ShipName': 'Bottom-Dollar Markets',
'ShipAddress': '23 Tsawassen Blvd.',
'ShipCity': 'Tsawassen',
'ShipRegion': 'BC',
'ShipCountry': 'Canada'
},
{
'OrderID': 10390,
'CustomerID': 'ERNSH',
'OrderDate': '1996-12-23T13:25:00.000Z',
'ShippedDate': '1996-12-26T14:25:00.000Z',
'Freight': 126.38,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10391,
'CustomerID': 'DRACD',
'OrderDate': '1996-12-23T15:25:00.000Z',
'ShippedDate': '1996-12-31T16:25:00.000Z',
'Freight': 5.45,
'ShipName': 'Drachenblut Delikatessen',
'ShipAddress': 'Walserweg 21',
'ShipCity': 'Aachen',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10392,
'CustomerID': 'PICCO',
'OrderDate': '1996-12-24T17:25:00.000Z',
'ShippedDate': '1997-01-01T18:25:00.000Z',
'Freight': 122.46,
'ShipName': 'Piccolo und mehr',
'ShipAddress': 'Geislweg 14',
'ShipCity': 'Salzburg',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10393,
'CustomerID': 'SAVEA',
'OrderDate': '1996-12-25T19:25:00.000Z',
'ShippedDate': '1997-01-03T20:25:00.000Z',
'Freight': 126.56,
'ShipName': 'Save-a-lot Markets',
'ShipAddress': '187 Suffolk Ln.',
'ShipCity': 'Boise',
'ShipRegion': 'ID',
'ShipCountry': 'USA'
},
{
'OrderID': 10394,
'CustomerID': 'HUNGC',
'OrderDate': '1996-12-2525:00.000Z',
'ShippedDate': '1997-01-03T22:25:00.000Z',
'Freight': 30.34,
'ShipName': 'Hungry Coyote Import Store',
'ShipAddress': 'City Center Plaza 516 Main St.',
'ShipCity': 'Elgin',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10395,
'CustomerID': 'HILAA',
'OrderDate': '1996-12-26T23:25:00.000Z',
'ShippedDate': '1997-01-03T00:25:00.000Z',
'Freight': 184.41,
'ShipName': 'HILARION-Abastos',
'ShipAddress': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'ShipCity': 'San Cristóbal',
'ShipRegion': 'Táchira',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10396,
'CustomerID': 'FRANK',
'OrderDate': '1996-12-27T01:45:00.000Z',
'ShippedDate': '1997-01-06T02:45:00.000Z',
'Freight': 135.35,
'ShipName': 'Frankenversand',
'ShipAddress': 'Berliner Platz 43',
'ShipCity': 'München',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10397,
'CustomerID': 'PRINI',
'OrderDate': '1996-12-27T03:45:00.000Z',
'ShippedDate': '1997-01-02T04:45:00.000Z',
'Freight': 60.26,
'ShipName': 'Princesa Isabel Vinhos',
'ShipAddress': 'Estrada da saúde n. 58',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10398,
'CustomerID': 'SAVEA',
'OrderDate': '1996-12-30T05:45:00.000Z',
'ShippedDate': '1997-01-09T06:45:00.000Z',
'Freight': 89.16,
'ShipName': 'Save-a-lot Markets',
'ShipAddress': '187 Suffolk Ln.',
'ShipCity': 'Boise',
'ShipRegion': 'ID',
'ShipCountry': 'USA'
},
{
'OrderID': 10399,
'CustomerID': 'VAFFE',
'OrderDate': '1996-12-31T07:45:00.000Z',
'ShippedDate': '1997-01-08T08:45:00.000Z',
'Freight': 27.36,
'ShipName': 'Vaffeljernet',
'ShipAddress': 'Smagsloget 45',
'ShipCity': 'Århus',
'ShipRegion': null,
'ShipCountry': 'Denmark'
},
{
'OrderID': 10400,
'CustomerID': 'EASTC',
'OrderDate': '1997-01-01T09:45:00.000Z',
'ShippedDate': '1997-01-16T10:45:00.000Z',
'Freight': 83.93,
'ShipName': 'Eastern Connection',
'ShipAddress': '35 King George',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10401,
'CustomerID': 'RATTC',
'OrderDate': '1997-01-01T11:45:00.000Z',
'ShippedDate': '1997-01-10T12:45:00.000Z',
'Freight': 12.51,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10402,
'CustomerID': 'ERNSH',
'OrderDate': '1997-01-02T13:45:00.000Z',
'ShippedDate': '1997-01-10T14:45:00.000Z',
'Freight': 67.88,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10403,
'CustomerID': 'ERNSH',
'OrderDate': '1997-01-03T15:45:00.000Z',
'ShippedDate': '1997-01-09T16:45:00.000Z',
'Freight': 73.79,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10404,
'CustomerID': 'MAGAA',
'OrderDate': '1997-01-03T17:45:00.000Z',
'ShippedDate': '1997-01-08T18:45:00.000Z',
'Freight': 155.97,
'ShipName': 'Magazzini Alimentari Riuniti',
'ShipAddress': 'Via Ludovico il Moro 22',
'ShipCity': 'Bergamo',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10405,
'CustomerID': 'LINOD',
'OrderDate': '1997-01-06T19:45:00.000Z',
'ShippedDate': '1997-01-22T20:45:00.000Z',
'Freight': 34.82,
'ShipName': 'LINO-Delicateses',
'ShipAddress': 'Ave. 5 de Mayo Porlamar',
'ShipCity': 'I. de Margarita',
'ShipRegion': 'Nueva Esparta',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10406,
'CustomerID': 'QUEEN',
'OrderDate': '1997-01-0745:00.000Z',
'ShippedDate': '1997-01-13T22:45:00.000Z',
'Freight': 108.04,
'ShipName': 'Queen Cozinha',
'ShipAddress': 'Alameda dos Canàrios, 891',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10407,
'CustomerID': 'OTTIK',
'OrderDate': '1997-01-07T23:45:00.000Z',
'ShippedDate': '1997-01-30T01:55:00.000Z',
'Freight': 91.48,
'ShipName': 'Ottilies Käseladen',
'ShipAddress': 'Mehrheimerstr. 369',
'ShipCity': 'Köln',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10408,
'CustomerID': 'FOLIG',
'OrderDate': '1997-01-08T01:55:00.000Z',
'ShippedDate': '1997-01-14T01:55:00.000Z',
'Freight': 11.26,
'ShipName': 'Folies gourmandes',
'ShipAddress': '184, chaussée de Tournai',
'ShipCity': 'Lille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10409,
'CustomerID': 'OCEAN',
'OrderDate': '1997-01-09T02:55:00.000Z',
'ShippedDate': '1997-01-14T03:55:00.000Z',
'Freight': 29.83,
'ShipName': 'Océano Atlántico Ltda.',
'ShipAddress': 'Ing. Gustavo Moncada 8585 Piso 20-A',
'ShipCity': 'Buenos Aires',
'ShipRegion': null,
'ShipCountry': 'Argentina'
},
{
'OrderID': 10410,
'CustomerID': 'BOTTM',
'OrderDate': '1997-01-10T04:55:00.000Z',
'ShippedDate': '1997-01-15T05:55:00.000Z',
'Freight': 2.4,
'ShipName': 'Bottom-Dollar Markets',
'ShipAddress': '23 Tsawassen Blvd.',
'ShipCity': 'Tsawassen',
'ShipRegion': 'BC',
'ShipCountry': 'Canada'
},
{
'OrderID': 10411,
'CustomerID': 'BOTTM',
'OrderDate': '1997-01-10T06:55:00.000Z',
'ShippedDate': '1997-01-21T07:55:00.000Z',
'Freight': 23.65,
'ShipName': 'Bottom-Dollar Markets',
'ShipAddress': '23 Tsawassen Blvd.',
'ShipCity': 'Tsawassen',
'ShipRegion': 'BC',
'ShipCountry': 'Canada'
},
{
'OrderID': 10412,
'CustomerID': 'WARTH',
'OrderDate': '1997-01-13T08:55:00.000Z',
'ShippedDate': '1997-01-15T09:55:00.000Z',
'Freight': 3.77,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10413,
'CustomerID': 'LAMAI',
'OrderDate': '1997-01-14T10:55:00.000Z',
'ShippedDate': '1997-01-16T11:55:00.000Z',
'Freight': 95.66,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10414,
'CustomerID': 'FAMIA',
'OrderDate': '1997-01-14T12:55:00.000Z',
'ShippedDate': '1997-01-17T13:55:00.000Z',
'Freight': 21.48,
'ShipName': 'Familia Arquibaldo',
'ShipAddress': 'Rua Orós, 92',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10415,
'CustomerID': 'HUNGC',
'OrderDate': '1997-01-15T14:55:00.000Z',
'ShippedDate': '1997-01-24T15:55:00.000Z',
'Freight': 0.2,
'ShipName': 'Hungry Coyote Import Store',
'ShipAddress': 'City Center Plaza 516 Main St.',
'ShipCity': 'Elgin',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10416,
'CustomerID': 'WARTH',
'OrderDate': '1997-01-16T16:55:00.000Z',
'ShippedDate': '1997-01-27T17:55:00.000Z',
'Freight': 22.72,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10417,
'CustomerID': 'SIMOB',
'OrderDate': '1997-01-16T18:55:00.000Z',
'ShippedDate': '1997-01-28T19:55:00.000Z',
'Freight': 70.29,
'ShipName': 'Simons bistro',
'ShipAddress': 'Vinbæltet 34',
'ShipCity': 'Kobenhavn',
'ShipRegion': null,
'ShipCountry': 'Denmark'
},
{
'OrderID': 10418,
'CustomerID': 'QUICK',
'OrderDate': '1997-01-17T20:55:00.000Z',
'ShippedDate': '1997-01-2455:00.000Z',
'Freight': 17.55,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10419,
'CustomerID': 'RICSU',
'OrderDate': '1997-01-20T22:55:00.000Z',
'ShippedDate': '1997-01-30T23:55:00.000Z',
'Freight': 137.35,
'ShipName': 'Richter Supermarkt',
'ShipAddress': 'Starenweg 5',
'ShipCity': 'Genève',
'ShipRegion': null,
'ShipCountry': 'Switzerland'
},
{
'OrderID': 10420,
'CustomerID': 'WELLI',
'OrderDate': '1997-01-21T01:05:00.000Z',
'ShippedDate': '1997-01-27T012:05:00.000Z',
'Freight': 44.12,
'ShipName': 'Wellington Importadora',
'ShipAddress': 'Rua do Mercado, 12',
'ShipCity': 'Resende',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10421,
'CustomerID': 'QUEDE',
'OrderDate': '1997-01-21T02:05:00.000Z',
'ShippedDate': '1997-01-27T03:05:00.000Z',
'Freight': 99.23,
'ShipName': 'Que Delícia',
'ShipAddress': 'Rua da Panificadora, 12',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10422,
'CustomerID': 'FRANS',
'OrderDate': '1997-01-22T04:05:00.000Z',
'ShippedDate': '1997-01-31T05:05:00.000Z',
'Freight': 3.02,
'ShipName': 'Franchi S.p.A.',
'ShipAddress': 'Via Monte Bianco 34',
'ShipCity': 'Torino',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10423,
'CustomerID': 'GOURL',
'OrderDate': '1997-01-23T06:05:00.000Z',
'ShippedDate': '1997-02-24T07:05:00.000Z',
'Freight': 24.5,
'ShipName': 'Gourmet Lanchonetes',
'ShipAddress': 'Av. Brasil, 442',
'ShipCity': 'Campinas',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10424,
'CustomerID': 'MEREP',
'OrderDate': '1997-01-23T08:05:00.000Z',
'ShippedDate': '1997-01-27T09:05:00.000Z',
'Freight': 370.61,
'ShipName': 'Mère Paillarde',
'ShipAddress': '43 rue St. Laurent',
'ShipCity': 'Montréal',
'ShipRegion': 'Québec',
'ShipCountry': 'Canada'
},
{
'OrderID': 10425,
'CustomerID': 'LAMAI',
'OrderDate': '1997-01-24T10:05:00.000Z',
'ShippedDate': '1997-02-14T11:05:00.000Z',
'Freight': 7.93,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10426,
'CustomerID': 'GALED',
'OrderDate': '1997-01-27T12:05:00.000Z',
'ShippedDate': '1997-02-06T13:05:00.000Z',
'Freight': 18.69,
'ShipName': 'Galería del gastronómo',
'ShipAddress': 'Rambla de Cataluña, 23',
'ShipCity': 'Barcelona',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10427,
'CustomerID': 'PICCO',
'OrderDate': '1997-01-27T14:05:00.000Z',
'ShippedDate': '1997-03-03T15:05:00.000Z',
'Freight': 31.29,
'ShipName': 'Piccolo und mehr',
'ShipAddress': 'Geislweg 14',
'ShipCity': 'Salzburg',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10428,
'CustomerID': 'REGGC',
'OrderDate': '1997-01-28T16:05:00.000Z',
'ShippedDate': '1997-02-04T17:05:00.000Z',
'Freight': 11.09,
'ShipName': 'Reggiani Caseifici',
'ShipAddress': 'Strada Provinciale 124',
'ShipCity': 'Reggio Emilia',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10429,
'CustomerID': 'HUNGO',
'OrderDate': '1997-01-29T18:05:00.000Z',
'ShippedDate': '1997-02-07T19:05:00.000Z',
'Freight': 56.63,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10430,
'CustomerID': 'ERNSH',
'OrderDate': '1997-01-30T20:05:00.000Z',
'ShippedDate': '1997-02-0305:00.000Z',
'Freight': 458.78,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10431,
'CustomerID': 'BOTTM',
'OrderDate': '1997-01-30T22:05:00.000Z',
'ShippedDate': '1997-02-07T23:05:00.000Z',
'Freight': 44.17,
'ShipName': 'Bottom-Dollar Markets',
'ShipAddress': '23 Tsawassen Blvd.',
'ShipCity': 'Tsawassen',
'ShipRegion': 'BC',
'ShipCountry': 'Canada'
},
{
'OrderID': 10432,
'CustomerID': 'SPLIR',
'OrderDate': '1997-01-31T01:15:00.000Z',
'ShippedDate': '1997-02-07T02:15:00.000Z',
'Freight': 4.34,
'ShipName': 'Split Rail Beer & Ale',
'ShipAddress': 'P.O. Box 555',
'ShipCity': 'Lander',
'ShipRegion': 'WY',
'ShipCountry': 'USA'
},
{
'OrderID': 10433,
'CustomerID': 'PRINI',
'OrderDate': '1997-02-03T03:15:00.000Z',
'ShippedDate': '1997-03-04T04:15:00.000Z',
'Freight': 73.83,
'ShipName': 'Princesa Isabel Vinhos',
'ShipAddress': 'Estrada da saúde n. 58',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10434,
'CustomerID': 'FOLKO',
'OrderDate': '1997-02-03T05:15:00.000Z',
'ShippedDate': '1997-02-13T06:15:00.000Z',
'Freight': 17.92,
'ShipName': 'Folk och fä HB',
'ShipAddress': 'Åkergatan 24',
'ShipCity': 'Bräcke',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10435,
'CustomerID': 'CONSH',
'OrderDate': '1997-02-04T07:15:00.000Z',
'ShippedDate': '1997-02-07T08:15:00.000Z',
'Freight': 9.21,
'ShipName': 'Consolidated Holdings',
'ShipAddress': 'Berkeley Gardens 12 Brewery',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10436,
'CustomerID': 'BLONP',
'OrderDate': '1997-02-05T09:15:00.000Z',
'ShippedDate': '1997-02-11T10:15:00.000Z',
'Freight': 156.66,
'ShipName': 'Blondel père et fils',
'ShipAddress': '24, place Kléber',
'ShipCity': 'Strasbourg',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10437,
'CustomerID': 'WARTH',
'OrderDate': '1997-02-05T11:15:00.000Z',
'ShippedDate': '1997-02-12T12:15:00.000Z',
'Freight': 19.97,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10438,
'CustomerID': 'TOMSP',
'OrderDate': '1997-02-06T13:15:00.000Z',
'ShippedDate': '1997-02-14T14:15:00.000Z',
'Freight': 8.24,
'ShipName': 'Toms Spezialitäten',
'ShipAddress': 'Luisenstr. 48',
'ShipCity': 'Münster',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10439,
'CustomerID': 'MEREP',
'OrderDate': '1997-02-07T15:15:00.000Z',
'ShippedDate': '1997-02-10T16:15:00.000Z',
'Freight': 4.07,
'ShipName': 'Mère Paillarde',
'ShipAddress': '43 rue St. Laurent',
'ShipCity': 'Montréal',
'ShipRegion': 'Québec',
'ShipCountry': 'Canada'
},
{
'OrderID': 10440,
'CustomerID': 'SAVEA',
'OrderDate': '1997-02-10T17:15:00.000Z',
'ShippedDate': '1997-02-28T18:15:00.000Z',
'Freight': 86.53,
'ShipName': 'Save-a-lot Markets',
'ShipAddress': '187 Suffolk Ln.',
'ShipCity': 'Boise',
'ShipRegion': 'ID',
'ShipCountry': 'USA'
},
{
'OrderID': 10441,
'CustomerID': 'OLDWO',
'OrderDate': '1997-02-10T19:15:00.000Z',
'ShippedDate': '1997-03-14T20:15:00.000Z',
'Freight': 73.02,
'ShipName': 'Old World Delicatessen',
'ShipAddress': '2743 Bering St.',
'ShipCity': 'Anchorage',
'ShipRegion': 'AK',
'ShipCountry': 'USA'
},
{
'OrderID': 10442,
'CustomerID': 'ERNSH',
'OrderDate': '1997-02-1115:00.000Z',
'ShippedDate': '1997-02-18T22:15:00.000Z',
'Freight': 47.94,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10443,
'CustomerID': 'REGGC',
'OrderDate': '1997-02-12T23:15:00.000Z',
'ShippedDate': '1997-02-14T00:25:00.000Z',
'Freight': 13.95,
'ShipName': 'Reggiani Caseifici',
'ShipAddress': 'Strada Provinciale 124',
'ShipCity': 'Reggio Emilia',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10444,
'CustomerID': 'BERGS',
'OrderDate': '1997-02-12T00:25:00.000Z',
'ShippedDate': '1997-02-21T01:25:00.000Z',
'Freight': 3.5,
'ShipName': 'Berglunds snabbköp',
'ShipAddress': 'Berguvsvägen 8',
'ShipCity': 'Luleå',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10445,
'CustomerID': 'BERGS',
'OrderDate': '1997-02-13T02:25:00.000Z',
'ShippedDate': '1997-02-20T03:00.00.000Z',
'Freight': 9.3,
'ShipName': 'Berglunds snabbköp',
'ShipAddress': 'Berguvsvägen 8',
'ShipCity': 'Luleå',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10446,
'CustomerID': 'TOMSP',
'OrderDate': '1997-02-14T04:00.00.000Z',
'ShippedDate': '1997-02-19T05:00.00.000Z',
'Freight': 14.68,
'ShipName': 'Toms Spezialitäten',
'ShipAddress': 'Luisenstr. 48',
'ShipCity': 'Münster',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10447,
'CustomerID': 'RICAR',
'OrderDate': '1997-02-14T05:00.00.000Z',
'ShippedDate': '1997-03-07T06:25:00.000Z',
'Freight': 68.66,
'ShipName': 'Ricardo Adocicados',
'ShipAddress': 'Av. Copacabana, 267',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10448,
'CustomerID': 'RANCH',
'OrderDate': '1997-02-17T07:25:00.000Z',
'ShippedDate': '1997-02-24T08:25:00.000Z',
'Freight': 38.82,
'ShipName': 'Rancho grande',
'ShipAddress': 'Av. del Libertador 900',
'ShipCity': 'Buenos Aires',
'ShipRegion': null,
'ShipCountry': 'Argentina'
},
{
'OrderID': 10449,
'CustomerID': 'BLONP',
'OrderDate': '1997-02-18T09:25:00.000Z',
'ShippedDate': '1997-02-27T10:25:00.000Z',
'Freight': 53.3,
'ShipName': 'Blondel père et fils',
'ShipAddress': '24, place Kléber',
'ShipCity': 'Strasbourg',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10450,
'CustomerID': 'VICTE',
'OrderDate': '1997-02-19T11:25:00.000Z',
'ShippedDate': '1997-03-11T12:25:00.000Z',
'Freight': 7.23,
'ShipName': 'Victuailles en stock',
'ShipAddress': '2, rue du Commerce',
'ShipCity': 'Lyon',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10451,
'CustomerID': 'QUICK',
'OrderDate': '1997-02-19T13:25:00.000Z',
'ShippedDate': '1997-03-12T14:25:00.000Z',
'Freight': 189.09,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10452,
'CustomerID': 'SAVEA',
'OrderDate': '1997-02-20T15:25:00.000Z',
'ShippedDate': '1997-02-26T16:25:00.000Z',
'Freight': 140.26,
'ShipName': 'Save-a-lot Markets',
'ShipAddress': '187 Suffolk Ln.',
'ShipCity': 'Boise',
'ShipRegion': 'ID',
'ShipCountry': 'USA'
},
{
'OrderID': 10453,
'CustomerID': 'AROUT',
'OrderDate': '1997-02-21T17:25:00.000Z',
'ShippedDate': '1997-02-26T18:25:00.000Z',
'Freight': 25.36,
'ShipName': 'Around the Horn',
'ShipAddress': 'Brook Farm Stratford St. Mary',
'ShipCity': 'Colchester',
'ShipRegion': 'Essex',
'ShipCountry': 'UK'
},
{
'OrderID': 10454,
'CustomerID': 'LAMAI',
'OrderDate': '1997-02-21T19:25:00.000Z',
'ShippedDate': '1997-02-25T20:25:00.000Z',
'Freight': 2.74,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10455,
'CustomerID': 'WARTH',
'OrderDate': '1997-02-2425:00.000Z',
'ShippedDate': '1997-03-03T22:25:00.000Z',
'Freight': 180.45,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10456,
'CustomerID': 'KOENE',
'OrderDate': '1997-02-25T23:25:00.000Z',
'ShippedDate': '1997-02-28T01:25:00.000Z',
'Freight': 8.12,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10457,
'CustomerID': 'KOENE',
'OrderDate': '1997-02-25T01:35:00.000Z',
'ShippedDate': '1997-03-03T02:35:00.000Z',
'Freight': 11.57,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10458,
'CustomerID': 'SUPRD',
'OrderDate': '1997-02-26T03:35:00.000Z',
'ShippedDate': '1997-03-04T04:35:00.000Z',
'Freight': 147.06,
'ShipName': 'Suprêmes délices',
'ShipAddress': 'Boulevard Tirou, 255',
'ShipCity': 'Charleroi',
'ShipRegion': null,
'ShipCountry': 'Belgium'
},
{
'OrderID': 10459,
'CustomerID': 'VICTE',
'OrderDate': '1997-02-27T04:35:00.000Z',
'ShippedDate': '1997-02-28T04:35:00.000Z',
'Freight': 25.09,
'ShipName': 'Victuailles en stock',
'ShipAddress': '2, rue du Commerce',
'ShipCity': 'Lyon',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10460,
'CustomerID': 'FOLKO',
'OrderDate': '1997-02-28T05:35:00.000Z',
'ShippedDate': '1997-03-03T06:35:00.000Z',
'Freight': 16.27,
'ShipName': 'Folk och fä HB',
'ShipAddress': 'Åkergatan 24',
'ShipCity': 'Bräcke',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10461,
'CustomerID': 'LILAS',
'OrderDate': '1997-02-28T07:35:00.000Z',
'ShippedDate': '1997-03-05T08:35:00.000Z',
'Freight': 148.61,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10462,
'CustomerID': 'CONSH',
'OrderDate': '1997-03-03T09:00.00.000Z',
'ShippedDate': '1997-03-18T10:00.00.000Z',
'Freight': 6.17,
'ShipName': 'Consolidated Holdings',
'ShipAddress': 'Berkeley Gardens 12 Brewery',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10463,
'CustomerID': 'SUPRD',
'OrderDate': '1997-03-04T11:00.00.000Z',
'ShippedDate': '1997-03-06T12:00.00.000Z',
'Freight': 14.78,
'ShipName': 'Suprêmes délices',
'ShipAddress': 'Boulevard Tirou, 255',
'ShipCity': 'Charleroi',
'ShipRegion': null,
'ShipCountry': 'Belgium'
},
{
'OrderID': 10464,
'CustomerID': 'FURIB',
'OrderDate': '1997-03-04T13:00.00.000Z',
'ShippedDate': '1997-03-14T14:00.00.000Z',
'Freight': 89,
'ShipName': 'Furia Bacalhau e Frutos do Mar',
'ShipAddress': 'Jardim das rosas n. 32',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10465,
'CustomerID': 'VAFFE',
'OrderDate': '1997-03-05T15:00.00.000Z',
'ShippedDate': '1997-03-14T16:00.00.000Z',
'Freight': 145.04,
'ShipName': 'Vaffeljernet',
'ShipAddress': 'Smagsloget 45',
'ShipCity': 'Århus',
'ShipRegion': null,
'ShipCountry': 'Denmark'
},
{
'OrderID': 10466,
'CustomerID': 'COMMI',
'OrderDate': '1997-03-06T17:00.00.000Z',
'ShippedDate': '1997-03-13T18:00.00.000Z',
'Freight': 11.93,
'ShipName': 'Comércio Mineiro',
'ShipAddress': 'Av. dos Lusíadas, 23',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10467,
'CustomerID': 'MAGAA',
'OrderDate': '1997-03-06T19:00.00.000Z',
'ShippedDate': '1997-03-11T20:00.00.000Z',
'Freight': 4.93,
'ShipName': 'Magazzini Alimentari Riuniti',
'ShipAddress': 'Via Ludovico il Moro 22',
'ShipCity': 'Bergamo',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10468,
'CustomerID': 'KOENE',
'OrderDate': '1997-03-0700.00.000Z',
'ShippedDate': '1997-03-12T22:00.00.000Z',
'Freight': 44.12,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10469,
'CustomerID': 'WHITC',
'OrderDate': '1997-03-10T23:00.00.000Z',
'ShippedDate': '1997-03-14T01:00.00.000Z',
'Freight': 60.18,
'ShipName': 'White Clover Markets',
'ShipAddress': '1029 - 12th Ave. S.',
'ShipCity': 'Seattle',
'ShipRegion': 'WA',
'ShipCountry': 'USA'
},
{
'OrderID': 10470,
'CustomerID': 'BONAP',
'OrderDate': '1997-03-11T02:00.00.000Z',
'ShippedDate': '1997-03-14T03:00.00.000Z',
'Freight': 64.56,
'ShipName': 'Bon app',
'ShipAddress': '12, rue des Bouchers',
'ShipCity': 'Marseille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10471,
'CustomerID': 'BSBEV',
'OrderDate': '1997-03-11T04:00.00.000Z',
'ShippedDate': '1997-03-18T05:00.00.000Z',
'Freight': 45.59,
'ShipName': 'B\'s Beverages',
'ShipAddress': 'Fauntleroy Circus',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10472,
'CustomerID': 'SEVES',
'OrderDate': '1997-03-12T06:00.00.000Z',
'ShippedDate': '1997-03-19T07:00.00.000Z',
'Freight': 4.2,
'ShipName': 'Seven Seas Imports',
'ShipAddress': '90 Wadhurst Rd.',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10473,
'CustomerID': 'ISLAT',
'OrderDate': '1997-03-13T08:00.00.000Z',
'ShippedDate': '1997-03-21T09:00.00.000Z',
'Freight': 16.37,
'ShipName': 'Island Trading',
'ShipAddress': 'Garden House Crowther Way',
'ShipCity': 'Cowes',
'ShipRegion': 'Isle of Wight',
'ShipCountry': 'UK'
},
{
'OrderID': 10474,
'CustomerID': 'PERIC',
'OrderDate': '1997-03-13T10:00.00.000Z',
'ShippedDate': '1997-03-21T11:00.00.000Z',
'Freight': 83.49,
'ShipName': 'Pericles Comidas clásicas',
'ShipAddress': 'Calle Dr. Jorge Cash 321',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10475,
'CustomerID': 'SUPRD',
'OrderDate': '1997-03-14T12:00.00.000Z',
'ShippedDate': '1997-04-04T13:00.00.000Z',
'Freight': 68.52,
'ShipName': 'Suprêmes délices',
'ShipAddress': 'Boulevard Tirou, 255',
'ShipCity': 'Charleroi',
'ShipRegion': null,
'ShipCountry': 'Belgium'
},
{
'OrderID': 10476,
'CustomerID': 'HILAA',
'OrderDate': '1997-03-17T14:00.00.000Z',
'ShippedDate': '1997-03-24T15:00.00.000Z',
'Freight': 4.41,
'ShipName': 'HILARION-Abastos',
'ShipAddress': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'ShipCity': 'San Cristóbal',
'ShipRegion': 'Táchira',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10477,
'CustomerID': 'PRINI',
'OrderDate': '1997-03-17T16:00.00.000Z',
'ShippedDate': '1997-03-25T17:00.00.000Z',
'Freight': 13.02,
'ShipName': 'Princesa Isabel Vinhos',
'ShipAddress': 'Estrada da saúde n. 58',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10478,
'CustomerID': 'VICTE',
'OrderDate': '1997-03-18T18:00.00.000Z',
'ShippedDate': '1997-03-26T19:00.00.000Z',
'Freight': 4.81,
'ShipName': 'Victuailles en stock',
'ShipAddress': '2, rue du Commerce',
'ShipCity': 'Lyon',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10479,
'CustomerID': 'RATTC',
'OrderDate': '1997-03-19T20:00.00.000Z',
'ShippedDate': '1997-03-2100.00.000Z',
'Freight': 708.95,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10480,
'CustomerID': 'FOLIG',
'OrderDate': '1997-03-20T22:00.00.000Z',
'ShippedDate': '1997-03-24T23:00.00.000Z',
'Freight': 1.35,
'ShipName': 'Folies gourmandes',
'ShipAddress': '184, chaussée de Tournai',
'ShipCity': 'Lille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10481,
'CustomerID': 'RICAR',
'OrderDate': '1997-03-20T01:00.00.000Z',
'ShippedDate': '1997-03-25T02:00.00.000Z',
'Freight': 64.33,
'ShipName': 'Ricardo Adocicados',
'ShipAddress': 'Av. Copacabana, 267',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10482,
'CustomerID': 'LAZYK',
'OrderDate': '1997-03-21T03:00.00.000Z',
'ShippedDate': '1997-04-10T04:00.00.000Z',
'Freight': 7.48,
'ShipName': 'Lazy K Kountry Store',
'ShipAddress': '12 Orchestra Terrace',
'ShipCity': 'Walla Walla',
'ShipRegion': 'WA',
'ShipCountry': 'USA'
},
{
'OrderID': 10483,
'CustomerID': 'WHITC',
'OrderDate': '1997-03-24T05:00.00.000Z',
'ShippedDate': '1997-04-25T06:00.00.000Z',
'Freight': 15.28,
'ShipName': 'White Clover Markets',
'ShipAddress': '1029 - 12th Ave. S.',
'ShipCity': 'Seattle',
'ShipRegion': 'WA',
'ShipCountry': 'USA'
},
{
'OrderID': 10484,
'CustomerID': 'BSBEV',
'OrderDate': '1997-03-24T07:00.00.000Z',
'ShippedDate': '1997-04-01T08:00.00.000Z',
'Freight': 6.88,
'ShipName': 'B\'s Beverages',
'ShipAddress': 'Fauntleroy Circus',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10485,
'CustomerID': 'LINOD',
'OrderDate': '1997-03-25T09:00.00.000Z',
'ShippedDate': '1997-03-31T10:00.00.000Z',
'Freight': 64.45,
'ShipName': 'LINO-Delicateses',
'ShipAddress': 'Ave. 5 de Mayo Porlamar',
'ShipCity': 'I. de Margarita',
'ShipRegion': 'Nueva Esparta',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10486,
'CustomerID': 'HILAA',
'OrderDate': '1997-03-26T11:00.00.000Z',
'ShippedDate': '1997-04-02T12:00.00.000Z',
'Freight': 30.53,
'ShipName': 'HILARION-Abastos',
'ShipAddress': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'ShipCity': 'San Cristóbal',
'ShipRegion': 'Táchira',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10487,
'CustomerID': 'QUEEN',
'OrderDate': '1997-03-26T13:00.00.000Z',
'ShippedDate': '1997-03-28T14:00.00.000Z',
'Freight': 71.07,
'ShipName': 'Queen Cozinha',
'ShipAddress': 'Alameda dos Canàrios, 891',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10488,
'CustomerID': 'FRANK',
'OrderDate': '1997-03-27T15:00.00.000Z',
'ShippedDate': '1997-04-02T16:00.00.000Z',
'Freight': 4.93,
'ShipName': 'Frankenversand',
'ShipAddress': 'Berliner Platz 43',
'ShipCity': 'München',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10489,
'CustomerID': 'PICCO',
'OrderDate': '1997-03-28T17:00.00.000Z',
'ShippedDate': '1997-04-09T18:00.00.000Z',
'Freight': 5.29,
'ShipName': 'Piccolo und mehr',
'ShipAddress': 'Geislweg 14',
'ShipCity': 'Salzburg',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10490,
'CustomerID': 'HILAA',
'OrderDate': '1997-03-31T19:00.00.000Z',
'ShippedDate': '1997-04-03T20:00.00.000Z',
'Freight': 210.19,
'ShipName': 'HILARION-Abastos',
'ShipAddress': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'ShipCity': 'San Cristóbal',
'ShipRegion': 'Táchira',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10491,
'CustomerID': 'FURIB',
'OrderDate': '1997-03-3100.00.000Z',
'ShippedDate': '1997-04-08T22:00.00.000Z',
'Freight': 16.96,
'ShipName': 'Furia Bacalhau e Frutos do Mar',
'ShipAddress': 'Jardim das rosas n. 32',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10492,
'CustomerID': 'BOTTM',
'OrderDate': '1997-04-01T23:00.00.000Z',
'ShippedDate': '1997-04-11T01:00.00.000Z',
'Freight': 62.89,
'ShipName': 'Bottom-Dollar Markets',
'ShipAddress': '23 Tsawassen Blvd.',
'ShipCity': 'Tsawassen',
'ShipRegion': 'BC',
'ShipCountry': 'Canada'
},
{
'OrderID': 10493,
'CustomerID': 'LAMAI',
'OrderDate': '1997-04-02T02:00.00.000Z',
'ShippedDate': '1997-04-10T03:00.00.000Z',
'Freight': 10.64,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10494,
'CustomerID': 'COMMI',
'OrderDate': '1997-04-02T04:00.00.000Z',
'ShippedDate': '1997-04-09T05:00.00.000Z',
'Freight': 65.99,
'ShipName': 'Comércio Mineiro',
'ShipAddress': 'Av. dos Lusíadas, 23',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10495,
'CustomerID': 'LAUGB',
'OrderDate': '1997-04-03T06:00.00.000Z',
'ShippedDate': '1997-04-11T07:00.00.000Z',
'Freight': 4.65,
'ShipName': 'Laughing Bacchus Wine Cellars',
'ShipAddress': '2319 Elm St.',
'ShipCity': 'Vancouver',
'ShipRegion': 'BC',
'ShipCountry': 'Canada'
},
{
'OrderID': 10496,
'CustomerID': 'TRADH',
'OrderDate': '1997-04-04T08:00.00.000Z',
'ShippedDate': '1997-04-07T09:00.00.000Z',
'Freight': 46.77,
'ShipName': 'Tradiçao Hipermercados',
'ShipAddress': 'Av. Inês de Castro, 414',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10497,
'CustomerID': 'LEHMS',
'OrderDate': '1997-04-04T10:00.00.000Z',
'ShippedDate': '1997-04-07T11:00.00.000Z',
'Freight': 36.21,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10498,
'CustomerID': 'HILAA',
'OrderDate': '1997-04-07T12:00.00.000Z',
'ShippedDate': '1997-04-11T13:00.00.000Z',
'Freight': 29.75,
'ShipName': 'HILARION-Abastos',
'ShipAddress': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'ShipCity': 'San Cristóbal',
'ShipRegion': 'Táchira',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10499,
'CustomerID': 'LILAS',
'OrderDate': '1997-04-08T14:00.00.000Z',
'ShippedDate': '1997-04-16T15:00.00.000Z',
'Freight': 102.02,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10500,
'CustomerID': 'LAMAI',
'OrderDate': '1997-04-09T16:00.00.000Z',
'ShippedDate': '1997-04-17T17:00.00.000Z',
'Freight': 42.68,
'ShipName': 'La maison d\'Asie',
'ShipAddress': '1 rue Alsace-Lorraine',
'ShipCity': 'Toulouse',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10501,
'CustomerID': 'BLAUS',
'OrderDate': '1997-04-09T18:00.00.000Z',
'ShippedDate': '1997-04-16T19:00.00.000Z',
'Freight': 8.85,
'ShipName': 'Blauer See Delikatessen',
'ShipAddress': 'Forsterstr. 57',
'ShipCity': 'Mannheim',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10502,
'CustomerID': 'PERIC',
'OrderDate': '1997-04-10T20:00.00.000Z',
'ShippedDate': '1997-04-2900.00.000Z',
'Freight': 69.32,
'ShipName': 'Pericles Comidas clásicas',
'ShipAddress': 'Calle Dr. Jorge Cash 321',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10503,
'CustomerID': 'HUNGO',
'OrderDate': '1997-04-11T22:00.00.000Z',
'ShippedDate': '1997-04-16T23:00.00.000Z',
'Freight': 16.74,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10504,
'CustomerID': 'WHITC',
'OrderDate': '1997-04-11T01:00.00.000Z',
'ShippedDate': '1997-04-18T02:00.00.000Z',
'Freight': 59.13,
'ShipName': 'White Clover Markets',
'ShipAddress': '1029 - 12th Ave. S.',
'ShipCity': 'Seattle',
'ShipRegion': 'WA',
'ShipCountry': 'USA'
},
{
'OrderID': 10505,
'CustomerID': 'MEREP',
'OrderDate': '1997-04-14T03:00.00.000Z',
'ShippedDate': '1997-04-21T04:00.00.000Z',
'Freight': 7.13,
'ShipName': 'Mère Paillarde',
'ShipAddress': '43 rue St. Laurent',
'ShipCity': 'Montréal',
'ShipRegion': 'Québec',
'ShipCountry': 'Canada'
},
{
'OrderID': 10506,
'CustomerID': 'KOENE',
'OrderDate': '1997-04-15T05:05:00.000Z',
'ShippedDate': '1997-05-02T06:05:00.000Z',
'Freight': 21.19,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10507,
'CustomerID': 'ANTON',
'OrderDate': '1997-04-15T07:05:00.000Z',
'ShippedDate': '1997-04-22T08:05:00.000Z',
'Freight': 47.45,
'ShipName': 'Antonio Moreno Taquería',
'ShipAddress': 'Mataderos 2312',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10508,
'CustomerID': 'OTTIK',
'OrderDate': '1997-04-16T09:05:00.000Z',
'ShippedDate': '1997-05-13T10:05:00.000Z',
'Freight': 4.99,
'ShipName': 'Ottilies Käseladen',
'ShipAddress': 'Mehrheimerstr. 369',
'ShipCity': 'Köln',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10509,
'CustomerID': 'BLAUS',
'OrderDate': '1997-04-17T11:05:00.000Z',
'ShippedDate': '1997-04-29T12:05:00.000Z',
'Freight': 0.15,
'ShipName': 'Blauer See Delikatessen',
'ShipAddress': 'Forsterstr. 57',
'ShipCity': 'Mannheim',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10510,
'CustomerID': 'SAVEA',
'OrderDate': '1997-04-18T13:05:00.000Z',
'ShippedDate': '1997-04-28T14:05:00.000Z',
'Freight': 367.63,
'ShipName': 'Save-a-lot Markets',
'ShipAddress': '187 Suffolk Ln.',
'ShipCity': 'Boise',
'ShipRegion': 'ID',
'ShipCountry': 'USA'
},
{
'OrderID': 10511,
'CustomerID': 'BONAP',
'OrderDate': '1997-04-18T15:05:00.000Z',
'ShippedDate': '1997-04-21T01:05:00.000Z',
'Freight': 350.64,
'ShipName': 'Bon app',
'ShipAddress': '12, rue des Bouchers',
'ShipCity': 'Marseille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10512,
'CustomerID': 'FAMIA',
'OrderDate': '1997-04-21T02:05:00.000Z',
'ShippedDate': '1997-04-24T03:05:00.000Z',
'Freight': 3.53,
'ShipName': 'Familia Arquibaldo',
'ShipAddress': 'Rua Orós, 92',
'ShipCity': 'Sao Paulo',
'ShipRegion': 'SP',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10513,
'CustomerID': 'WANDK',
'OrderDate': '1997-04-22T04:05:00.000Z',
'ShippedDate': '1997-04-28T05:05:00.000Z',
'Freight': 105.65,
'ShipName': 'Die Wandernde Kuh',
'ShipAddress': 'Adenauerallee 900',
'ShipCity': 'Stuttgart',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10514,
'CustomerID': 'ERNSH',
'OrderDate': '1997-04-22T05:05:00.000Z',
'ShippedDate': '1997-05-16T07:05:00.000Z',
'Freight': 789.95,
'ShipName': 'Ernst Handel',
'ShipAddress': 'Kirchgasse 6',
'ShipCity': 'Graz',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10515,
'CustomerID': 'QUICK',
'OrderDate': '1997-04-23T08:05:00.000Z',
'ShippedDate': '1997-05-23T09:05:00.000Z',
'Freight': 204.47,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10516,
'CustomerID': 'HUNGO',
'OrderDate': '1997-04-24T10:05:00.000Z',
'ShippedDate': '1997-05-01T11:05:00.000Z',
'Freight': 62.78,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10517,
'CustomerID': 'NORTS',
'OrderDate': '1997-04-24T12:05:00.000Z',
'ShippedDate': '1997-04-29T13:05:00.000Z',
'Freight': 32.07,
'ShipName': 'North/South',
'ShipAddress': 'South House 300 Queensbridge',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10518,
'CustomerID': 'TORTU',
'OrderDate': '1997-04-25T14:05:00.000Z',
'ShippedDate': '1997-05-05T15:05:00.000Z',
'Freight': 218.15,
'ShipName': 'Tortuga Restaurante',
'ShipAddress': 'Avda. Azteca 123',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10519,
'CustomerID': 'CHOPS',
'OrderDate': '1997-04-28T16:05:00.000Z',
'ShippedDate': '1997-05-01T17:05:00.000Z',
'Freight': 91.76,
'ShipName': 'Chop-suey Chinese',
'ShipAddress': 'Hauptstr. 31',
'ShipCity': 'Bern',
'ShipRegion': null,
'ShipCountry': 'Switzerland'
},
{
'OrderID': 10520,
'CustomerID': 'SANTG',
'OrderDate': '1997-04-29T18:05:00.000Z',
'ShippedDate': '1997-05-01T19:05:00.000Z',
'Freight': 13.37,
'ShipName': 'Santé Gourmet',
'ShipAddress': 'Erling Skakkes gate 78',
'ShipCity': 'Stavern',
'ShipRegion': null,
'ShipCountry': 'Norway'
},
{
'OrderID': 10521,
'CustomerID': 'CACTU',
'OrderDate': '1997-04-29T20:05:00.000Z',
'ShippedDate': '1997-05-0205:00.000Z',
'Freight': 17.22,
'ShipName': 'Cactus Comidas para llevar',
'ShipAddress': 'Cerrito 333',
'ShipCity': 'Buenos Aires',
'ShipRegion': null,
'ShipCountry': 'Argentina'
},
{
'OrderID': 10522,
'CustomerID': 'LEHMS',
'OrderDate': '1997-04-30T22:05:00.000Z',
'ShippedDate': '1997-05-06T23:05:00.000Z',
'Freight': 45.33,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10523,
'CustomerID': 'SEVES',
'OrderDate': '1997-05-01T01:10:00.000Z',
'ShippedDate': '1997-05-30T02:10:00.000Z',
'Freight': 77.63,
'ShipName': 'Seven Seas Imports',
'ShipAddress': '90 Wadhurst Rd.',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10524,
'CustomerID': 'BERGS',
'OrderDate': '1997-05-01T03:10:00.000Z',
'ShippedDate': '1997-05-07T04:10:00.000Z',
'Freight': 244.79,
'ShipName': 'Berglunds snabbköp',
'ShipAddress': 'Berguvsvägen 8',
'ShipCity': 'Luleå',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10525,
'CustomerID': 'BONAP',
'OrderDate': '1997-05-02T05:10:00.000Z',
'ShippedDate': '1997-05-23T06:10:00.000Z',
'Freight': 11.06,
'ShipName': 'Bon app',
'ShipAddress': '12, rue des Bouchers',
'ShipCity': 'Marseille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10526,
'CustomerID': 'WARTH',
'OrderDate': '1997-05-05T07:10:00.000Z',
'ShippedDate': '1997-05-15T08:10:00.000Z',
'Freight': 58.59,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10527,
'CustomerID': 'QUICK',
'OrderDate': '1997-05-05T09:10:00.000Z',
'ShippedDate': '1997-05-07T10:10:00.000Z',
'Freight': 41.9,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10528,
'CustomerID': 'GREAL',
'OrderDate': '1997-05-06T11:10:00.000Z',
'ShippedDate': '1997-05-09T12:10:00.000Z',
'Freight': 3.35,
'ShipName': 'Great Lakes Food Market',
'ShipAddress': '2732 Baker Blvd.',
'ShipCity': 'Eugene',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10529,
'CustomerID': 'MAISD',
'OrderDate': '1997-05-07T13:10:00.000Z',
'ShippedDate': '1997-05-09T14:10:00.000Z',
'Freight': 66.69,
'ShipName': 'Maison Dewey',
'ShipAddress': 'Rue Joseph-Bens 532',
'ShipCity': 'Bruxelles',
'ShipRegion': null,
'ShipCountry': 'Belgium'
},
{
'OrderID': 10530,
'CustomerID': 'PICCO',
'OrderDate': '1997-05-08T15:10:00.000Z',
'ShippedDate': '1997-05-12T16:10:00.000Z',
'Freight': 339.22,
'ShipName': 'Piccolo und mehr',
'ShipAddress': 'Geislweg 14',
'ShipCity': 'Salzburg',
'ShipRegion': null,
'ShipCountry': 'Austria'
},
{
'OrderID': 10531,
'CustomerID': 'OCEAN',
'OrderDate': '1997-05-08T17:10:00.000Z',
'ShippedDate': '1997-05-19T18:10:00.000Z',
'Freight': 8.12,
'ShipName': 'Océano Atlántico Ltda.',
'ShipAddress': 'Ing. Gustavo Moncada 8585 Piso 20-A',
'ShipCity': 'Buenos Aires',
'ShipRegion': null,
'ShipCountry': 'Argentina'
},
{
'OrderID': 10532,
'CustomerID': 'EASTC',
'OrderDate': '1997-05-09T19:10:00.000Z',
'ShippedDate': '1997-05-12T20:10:00.000Z',
'Freight': 74.46,
'ShipName': 'Eastern Connection',
'ShipAddress': '35 King George',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10533,
'CustomerID': 'FOLKO',
'OrderDate': '1997-05-1210:00.000Z',
'ShippedDate': '1997-05-22T22:10:00.000Z',
'Freight': 188.04,
'ShipName': 'Folk och fä HB',
'ShipAddress': 'Åkergatan 24',
'ShipCity': 'Bräcke',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10534,
'CustomerID': 'LEHMS',
'OrderDate': '1997-05-12T23:10:00.000Z',
'ShippedDate': '1997-05-14T01:15:00.000Z',
'Freight': 27.94,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10535,
'CustomerID': 'ANTON',
'OrderDate': '1997-05-13T02:15:00.000Z',
'ShippedDate': '1997-05-21T03:15:00.000Z',
'Freight': 15.64,
'ShipName': 'Antonio Moreno Taquería',
'ShipAddress': 'Mataderos 2312',
'ShipCity': 'México D.F.',
'ShipRegion': null,
'ShipCountry': 'Mexico'
},
{
'OrderID': 10536,
'CustomerID': 'LEHMS',
'OrderDate': '1997-05-14T04:15:00.000Z',
'ShippedDate': '1997-06-06T05:15:00.000Z',
'Freight': 58.88,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10537,
'CustomerID': 'RICSU',
'OrderDate': '1997-05-14T06:15:00.000Z',
'ShippedDate': '1997-05-19T07:15:00.000Z',
'Freight': 78.85,
'ShipName': 'Richter Supermarkt',
'ShipAddress': 'Starenweg 5',
'ShipCity': 'Genève',
'ShipRegion': null,
'ShipCountry': 'Switzerland'
},
{
'OrderID': 10538,
'CustomerID': 'BSBEV',
'OrderDate': '1997-05-15T08:15:00.000Z',
'ShippedDate': '1997-05-16T09:15:00.000Z',
'Freight': 4.87,
'ShipName': 'B\'s Beverages',
'ShipAddress': 'Fauntleroy Circus',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10539,
'CustomerID': 'BSBEV',
'OrderDate': '1997-05-16T10:15:00.000Z',
'ShippedDate': '1997-05-23T11:15:00.000Z',
'Freight': 12.36,
'ShipName': 'B\'s Beverages',
'ShipAddress': 'Fauntleroy Circus',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10540,
'CustomerID': 'QUICK',
'OrderDate': '1997-05-19T12:15:00.000Z',
'ShippedDate': '1997-06-13T13:15:00.000Z',
'Freight': 1007.64,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10541,
'CustomerID': 'HANAR',
'OrderDate': '1997-05-19T14:15:00.000Z',
'ShippedDate': '1997-05-29T15:15:00.000Z',
'Freight': 68.65,
'ShipName': 'Hanari Carnes',
'ShipAddress': 'Rua do Paço, 67',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10542,
'CustomerID': 'KOENE',
'OrderDate': '1997-05-20T16:15:00.000Z',
'ShippedDate': '1997-05-26T17:15:00.000Z',
'Freight': 10.95,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10543,
'CustomerID': 'LILAS',
'OrderDate': '1997-05-21T18:15:00.000Z',
'ShippedDate': '1997-05-23T19:15:00.000Z',
'Freight': 48.17,
'ShipName': 'LILA-Supermercado',
'ShipAddress': 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo',
'ShipCity': 'Barquisimeto',
'ShipRegion': 'Lara',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10544,
'CustomerID': 'LONEP',
'OrderDate': '1997-05-21T20:15:00.000Z',
'ShippedDate': '1997-05-3015:00.000Z',
'Freight': 24.91,
'ShipName': 'Lonesome Pine Restaurant',
'ShipAddress': '89 Chiaroscuro Rd.',
'ShipCity': 'Portland',
'ShipRegion': 'OR',
'ShipCountry': 'USA'
},
{
'OrderID': 10545,
'CustomerID': 'LAZYK',
'OrderDate': '1997-05-22T23:15:00.000Z',
'ShippedDate': '1997-06-26T01:20:00.000Z',
'Freight': 11.92,
'ShipName': 'Lazy K Kountry Store',
'ShipAddress': '12 Orchestra Terrace',
'ShipCity': 'Walla Walla',
'ShipRegion': 'WA',
'ShipCountry': 'USA'
},
{
'OrderID': 10546,
'CustomerID': 'VICTE',
'OrderDate': '1997-05-23T02:20:00.000Z',
'ShippedDate': '1997-05-27T03:20:00.000Z',
'Freight': 194.72,
'ShipName': 'Victuailles en stock',
'ShipAddress': '2, rue du Commerce',
'ShipCity': 'Lyon',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10547,
'CustomerID': 'SEVES',
'OrderDate': '1997-05-23T04:20:00.000Z',
'ShippedDate': '1997-06-02T05:20:00.000Z',
'Freight': 178.43,
'ShipName': 'Seven Seas Imports',
'ShipAddress': '90 Wadhurst Rd.',
'ShipCity': 'London',
'ShipRegion': null,
'ShipCountry': 'UK'
},
{
'OrderID': 10548,
'CustomerID': 'TOMSP',
'OrderDate': '1997-05-26T06:20:00.000Z',
'ShippedDate': '1997-06-02T07:20:00.000Z',
'Freight': 1.43,
'ShipName': 'Toms Spezialitäten',
'ShipAddress': 'Luisenstr. 48',
'ShipCity': 'Münster',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10549,
'CustomerID': 'QUICK',
'OrderDate': '1997-05-27T08:20:00.000Z',
'ShippedDate': '1997-05-30T09:20:00.000Z',
'Freight': 171.24,
'ShipName': 'QUICK-Stop',
'ShipAddress': 'Taucherstraße 10',
'ShipCity': 'Cunewalde',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10550,
'CustomerID': 'GODOS',
'OrderDate': '1997-05-28T10:20:00.000Z',
'ShippedDate': '1997-06-06T11:20:00.000Z',
'Freight': 4.32,
'ShipName': 'Godos Cocina Típica',
'ShipAddress': 'C/ Romero, 33',
'ShipCity': 'Sevilla',
'ShipRegion': null,
'ShipCountry': 'Spain'
},
{
'OrderID': 10551,
'CustomerID': 'FURIB',
'OrderDate': '1997-05-28T12:20:00.000Z',
'ShippedDate': '1997-06-06T13:20:00.000Z',
'Freight': 72.95,
'ShipName': 'Furia Bacalhau e Frutos do Mar',
'ShipAddress': 'Jardim das rosas n. 32',
'ShipCity': 'Lisboa',
'ShipRegion': null,
'ShipCountry': 'Portugal'
},
{
'OrderID': 10552,
'CustomerID': 'HILAA',
'OrderDate': '1997-05-29T14:20:00.000Z',
'ShippedDate': '1997-06-05T15:20:00.000Z',
'Freight': 83.22,
'ShipName': 'HILARION-Abastos',
'ShipAddress': 'Carrera 22 con Ave. Carlos Soublette #8-35',
'ShipCity': 'San Cristóbal',
'ShipRegion': 'Táchira',
'ShipCountry': 'Venezuela'
},
{
'OrderID': 10553,
'CustomerID': 'WARTH',
'OrderDate': '1997-05-30T16:20:00.000Z',
'ShippedDate': '1997-06-03T17:20:00.000Z',
'Freight': 149.49,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10554,
'CustomerID': 'OTTIK',
'OrderDate': '1997-05-30T18:20:00.000Z',
'ShippedDate': '1997-06-05T19:20:00.000Z',
'Freight': 120.97,
'ShipName': 'Ottilies Käseladen',
'ShipAddress': 'Mehrheimerstr. 369',
'ShipCity': 'Köln',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10555,
'CustomerID': 'SAVEA',
'OrderDate': '1997-06-02T20:20:00.000Z',
'ShippedDate': '1997-06-0420:00.000Z',
'Freight': 252.49,
'ShipName': 'Save-a-lot Markets',
'ShipAddress': '187 Suffolk Ln.',
'ShipCity': 'Boise',
'ShipRegion': 'ID',
'ShipCountry': 'USA'
},
{
'OrderID': 10556,
'CustomerID': 'SIMOB',
'OrderDate': '1997-06-03T22:20:00.000Z',
'ShippedDate': '1997-06-13T23:20:00.000Z',
'Freight': 9.8,
'ShipName': 'Simons bistro',
'ShipAddress': 'Vinbæltet 34',
'ShipCity': 'Kobenhavn',
'ShipRegion': null,
'ShipCountry': 'Denmark'
},
{
'OrderID': 10557,
'CustomerID': 'LEHMS',
'OrderDate': '1997-06-03T01:25:00.000Z',
'ShippedDate': '1997-06-06T02:25:00.000Z',
'Freight': 96.72,
'ShipName': 'Lehmanns Marktstand',
'ShipAddress': 'Magazinweg 7',
'ShipCity': 'Frankfurt a.M.',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10558,
'CustomerID': 'AROUT',
'OrderDate': '1997-06-04T03:25:00.000Z',
'ShippedDate': '1997-06-10T04:25:00.000Z',
'Freight': 72.97,
'ShipName': 'Around the Horn',
'ShipAddress': 'Brook Farm Stratford St. Mary',
'ShipCity': 'Colchester',
'ShipRegion': 'Essex',
'ShipCountry': 'UK'
},
{
'OrderID': 10559,
'CustomerID': 'BLONP',
'OrderDate': '1997-06-05T05:25:00.000Z',
'ShippedDate': '1997-06-13T06:25:00.000Z',
'Freight': 8.05,
'ShipName': 'Blondel père et fils',
'ShipAddress': '24, place Kléber',
'ShipCity': 'Strasbourg',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10560,
'CustomerID': 'FRANK',
'OrderDate': '1997-06-06T07:25:00.000Z',
'ShippedDate': '1997-06-09T08:25:00.000Z',
'Freight': 36.65,
'ShipName': 'Frankenversand',
'ShipAddress': 'Berliner Platz 43',
'ShipCity': 'München',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10561,
'CustomerID': 'FOLKO',
'OrderDate': '1997-06-06T09:25:00.000Z',
'ShippedDate': '1997-06-09T10:25:00.000Z',
'Freight': 242.21,
'ShipName': 'Folk och fä HB',
'ShipAddress': 'Åkergatan 24',
'ShipCity': 'Bräcke',
'ShipRegion': null,
'ShipCountry': 'Sweden'
},
{
'OrderID': 10562,
'CustomerID': 'REGGC',
'OrderDate': '1997-06-09T11:25:00.000Z',
'ShippedDate': '1997-06-12T12:25:00.000Z',
'Freight': 22.95,
'ShipName': 'Reggiani Caseifici',
'ShipAddress': 'Strada Provinciale 124',
'ShipCity': 'Reggio Emilia',
'ShipRegion': null,
'ShipCountry': 'Italy'
},
{
'OrderID': 10563,
'CustomerID': 'RICAR',
'OrderDate': '1997-06-10T13:25:00.000Z',
'ShippedDate': '1997-06-24T14:25:00.000Z',
'Freight': 60.43,
'ShipName': 'Ricardo Adocicados',
'ShipAddress': 'Av. Copacabana, 267',
'ShipCity': 'Rio de Janeiro',
'ShipRegion': 'RJ',
'ShipCountry': 'Brazil'
},
{
'OrderID': 10564,
'CustomerID': 'RATTC',
'OrderDate': '1997-06-10T15:25:00.000Z',
'ShippedDate': '1997-06-16T16:25:00.000Z',
'Freight': 13.75,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10565,
'CustomerID': 'MEREP',
'OrderDate': '1997-06-11T17:25:00.000Z',
'ShippedDate': '1997-06-18T18:25:00.000Z',
'Freight': 7.15,
'ShipName': 'Mère Paillarde',
'ShipAddress': '43 rue St. Laurent',
'ShipCity': 'Montréal',
'ShipRegion': 'Québec',
'ShipCountry': 'Canada'
},
{
'OrderID': 10566,
'CustomerID': 'BLONP',
'OrderDate': '1997-06-12T01:10:00.000Z',
'ShippedDate': '1997-06-18T02:10:00.000Z',
'Freight': 88.4,
'ShipName': 'Blondel père et fils',
'ShipAddress': '24, place Kléber',
'ShipCity': 'Strasbourg',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10567,
'CustomerID': 'HUNGO',
'OrderDate': '1997-06-12T03:10:00.000Z',
'ShippedDate': '1997-06-17T03:10:00.000Z',
'Freight': 33.97,
'ShipName': 'Hungry Owl All-Night Grocers',
'ShipAddress': '8 Johnstown Road',
'ShipCity': 'Cork',
'ShipRegion': 'Co. Cork',
'ShipCountry': 'Ireland'
},
{
'OrderID': 10568,
'CustomerID': 'GAL