This section explains the steps to create a simple Grid and demonstrates the basic usage of the grid component using the Essential JS 2 quickstart seed repository. This seed repository is pre-configured with the Essential JS 2 package.
Following is the list of minimum dependencies required to use the grid.
|-- @syncfusion/ej2-grids
|-- @syncfusion/ej2-base
|-- @syncfusion/ej2-data
|-- @syncfusion/ej2-excel-export
|-- @syncfusion/ej2-file-utils
|-- @syncfusion/ej2-compression
|-- @syncfusion/ej2-pdf-export
|-- @syncfusion/ej2-file-utils
|-- @syncfusion/ej2-compression
|-- @syncfusion/ej2-notificationsClone the Essential JS 2 quickstart application project from GitHub, and install the necessary npm packages using the following command line scripts.
git clone https://github.com/syncfusion/ej2-quickstart.git quickstart
cd quickstart
npm installSyncfusion Grid packages have to be mapped in the system.config.js configuration file.
System.config({
paths: {
'npm:': './node_modules/',
'syncfusion:': 'npm:@syncfusion/'
},
map: {
app: 'app',
//Syncfusion packages mapping
"@syncfusion/ej2-base": "syncfusion:ej2-base/dist/ej2-base.umd.min.js",
"@syncfusion/ej2-data": "syncfusion:ej2-data/dist/ej2-data.umd.min.js",
"@syncfusion/ej2-buttons": "syncfusion:ej2-buttons/dist/ej2-buttons.umd.min.js",
"@syncfusion/ej2-splitbuttons": "syncfusion:ej2-splitbuttons/dist/ej2-splitbuttons.umd.min.js",
"@syncfusion/ej2-popups": "syncfusion:ej2-popups/dist/ej2-popups.umd.min.js",
"@syncfusion/ej2-navigations": "syncfusion:ej2-navigations/dist/ej2-navigations.umd.min.js",
"@syncfusion/ej2-inputs": "syncfusion:ej2-inputs/dist/ej2-inputs.umd.min.js",
"@syncfusion/ej2-dropdowns": "syncfusion:ej2-dropdowns/dist/ej2-dropdowns.umd.min.js",
"@syncfusion/ej2-calendars": "syncfusion:ej2-calendars/dist/ej2-calendars.umd.min.js",
"@syncfusion/ej2-lists": "syncfusion:ej2-lists/dist/ej2-lists.umd.min.js",
"@syncfusion/ej2-grids": "syncfusion:ej2-grids/dist/ej2-grids.umd.min.js",
"@syncfusion/ej2-excel-export": "syncfusion:ej2-excel-export/dist/ej2-excel-export.umd.min.js",
"@syncfusion/ej2-pdf-export": "syncfusion:ej2-pdf-export/dist/ej2-pdf-export.umd.min.js",
"@syncfusion/ej2-file-utils": "syncfusion:ej2-file-utils/dist/ej2-file-utils.umd.min.js",
"@syncfusion/ej2-querybuilder": "syncfusion:ej2-querybuilder/dist/ej2-querybuilder.umd.min.js",
"@syncfusion/ej2-compression": "syncfusion:ej2-compression/dist/ej2-compression.umd.min.js"
},
packages: {
'app': { main: 'app', defaultExtension: 'js' }
}
});
System.import('app');Combined CSS files are available in the Essential JS 2 package root folder.
This can be referenced in your [src/styles/styles.css] using the following code.
@import '../../node_modules/@syncfusion/ej2/material.css';To know about individual component CSS, please refer to Individual Component theme files section.
You can start adding Essential JS 2 grid component to the application. To get started, add the grid component in app.ts and index.html files using the following code.
Place the following grid code in the app.ts.
import { Grid } from '@syncfusion/ej2-grids';
import { data } from './datasource.ts';
let grid: Grid = new Grid({
dataSource: data,
columns: [
{ field: 'OrderID', headerText: 'Order ID', textAlign: 'Right', width: 120, type: 'number' },
{ field: 'CustomerID', width: 140, headerText: 'Customer ID', type: 'string' },
{ field: 'Freight', headerText: 'Freight', textAlign: 'Right', width: 120, format: 'C' },
{ field: 'OrderDate', headerText: 'Order Date', width: 140, format: 'yMd' }
],
height: 315
});
grid.appendTo('#Grid');Place the following grid data source code in the dataSource.ts.
export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', EmployeeID: 2, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', EmployeeID: 7, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];Now, add an HTML div element to act as the grid element in index.html using the following code.
<!DOCTYPE html>
<html lang="en">
<head>
<title>Essential JS 2</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no" />
<meta name="description" content="Essential JS 2" />
<meta name="author" content="Syncfusion" />
<link rel="shortcut icon" href="resources/favicon.ico" />
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" />
<!--style reference from app-->
<link href="/styles/styles.css" rel="stylesheet" />
<!--system js reference and configuration-->
<script src="node_modules/systemjs/dist/system.src.js" type="text/javascript"></script>
<script src="system.config.js" type="text/javascript"></script>
</head>
<body>
<!--Element which will render as Grid-->
<div id="Grid"></div>
</body>
</html>To create grids with additional features, inject the required modules. The following modules are used to extend grid’s basic functionality.
Page - Inject this module to use paging feature.Sort - Inject this module to use sorting feature.Filter - Inject this module to use filtering feature.Group - Inject this module to use grouping feature.These modules should be injected into the grid using the Grid.Inject method.
Additional feature modules are available
here.
The paging feature enables users to view the grid record in a paged view. It can be enabled by setting the allowPaging property to true. Inject the Page
module as follows. If the Page module is not injected, the pager will not be rendered in the grid. Pager can be customized using the pageSettings property.
import { Grid, Page } from '@syncfusion/ej2-grids';
import { data } from './datasource.ts';
Grid.Inject(Page);
let grid: Grid = new Grid({
dataSource: data,
columns: [
{ field: 'OrderID', headerText: 'Order ID', textAlign: 'Right', width: 120, type: 'number' },
{ field: 'CustomerID', width: 140, headerText: 'Customer ID', type: 'string' },
{ field: 'Freight', headerText: 'Freight', textAlign: 'Right', width: 120, format: 'C' },
{ field: 'OrderDate', headerText: 'Order Date', width: 140, format: 'yMd' }
],
allowPaging: true,
pageSettings: { pageSize: 7 }
});
grid.appendTo('#Grid');<!DOCTYPE html>
<html lang="en">
<head>
<title>EJ2 Grid</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta name="description" content="Typescript Grid Control" />
<meta name="author" content="Syncfusion" />
<link href="index.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-base/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-grids/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-buttons/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-popups/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-richtexteditor/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-navigations/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-dropdowns/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-lists/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-inputs/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-calendars/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-notifications/styles/material.css" rel="stylesheet" />
<link href="//cdn.syncfusion.com/ej2/21.1.35/ej2-splitbuttons/styles/material.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/systemjs/0.19.38/system.js"></script>
<script src="systemjs.config.js"></script>
<style>
.e-row[aria-selected="true"] .e-customizedExpandcell {
background-color: #e0e0e0;
}
.e-grid.e-gridhover tr[role='row']:hover {
background-color: #eee;
}
.e-expand::before {
content: '\e5b8';
}
.empImage {
margin: 6px 16px;
float: left;
width: 50px;
height: 50px;
}
</style>
</head>
<body>
<div id='loader'>Loading....</div>
<div id='container'>
<div id='Grid'></div>
</div>
</body>
</html>export let data: Object[] = [
{
OrderID: 10248, CustomerID: 'VINET', Role: 'Admin', EmployeeID: 5, OrderDate: new Date(8364186e5),
ShipName: 'Vins et alcools Chevalier', ShipCity: 'Reims', ShipAddress: '59 rue de l Abbaye',
ShipRegion: 'CJ', Mask: '1111',ShipPostalCode: '51100', ShipCountry: 'France', Freight: 32.38, Verified: !0
},
{
OrderID: 10249, CustomerID: 'TOMSP', Role: 'Employee', EmployeeID: 6, OrderDate: new Date(836505e6),
ShipName: 'Toms Spezialitäten', ShipCity: 'Münster', ShipAddress: 'Luisenstr. 48',
ShipRegion: 'CJ', Mask: '2222', ShipPostalCode: '44087', ShipCountry: 'Germany', Freight: 11.61, Verified: !1
},
{
OrderID: 10250, CustomerID: 'HANAR', Role: 'Admin', EmployeeID: 4, OrderDate: new Date(8367642e5),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', Mask: '3333', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 65.83, Verified: !0
},
{
OrderID: 10251, CustomerID: 'VICTE', Role: 'Manager', EmployeeID: 3, OrderDate: new Date(8367642e5),
ShipName: 'Victuailles en stock', ShipCity: 'Lyon', ShipAddress: '2, rue du Commerce',
ShipRegion: 'CJ', Mask: '4444', ShipPostalCode: '69004', ShipCountry: 'France', Freight: 41.34, Verified: !0
},
{
OrderID: 10252, CustomerID: 'SUPRD', Role: 'Manager', EmployeeID: 2, OrderDate: new Date(8368506e5),
ShipName: 'Suprêmes délices', ShipCity: 'Charleroi', ShipAddress: 'Boulevard Tirou, 255',
ShipRegion: 'CJ', Mask: '5555', ShipPostalCode: 'B-6000', ShipCountry: 'Belgium', Freight: 51.3, Verified: !0
},
{
OrderID: 10253, CustomerID: 'HANAR', Role: 'Admin', EmployeeID: 7, OrderDate: new Date(836937e6),
ShipName: 'Hanari Carnes', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua do Paço, 67',
ShipRegion: 'RJ', Mask: '6666', ShipPostalCode: '05454-876', ShipCountry: 'Brazil', Freight: 58.17, Verified: !0
},
{
OrderID: 10254, CustomerID: 'CHOPS', Role: 'Employee', EmployeeID: 5, OrderDate: new Date(8370234e5),
ShipName: 'Chop-suey Chinese', ShipCity: 'Bern', ShipAddress: 'Hauptstr. 31',
ShipRegion: 'CJ', Mask: '7777', ShipPostalCode: '3012', ShipCountry: 'Switzerland', Freight: 22.98, Verified: !1
},
{
OrderID: 10255, CustomerID: 'RICSU', Role: 'Admin', EmployeeID: 9, OrderDate: new Date(8371098e5),
ShipName: 'Richter Supermarkt', ShipCity: 'Genève', ShipAddress: 'Starenweg 5',
ShipRegion: 'CJ', Mask: '8888', ShipPostalCode: '1204', ShipCountry: 'Switzerland', Freight: 148.33, Verified: !0
},
{
OrderID: 10256, CustomerID: 'WELLI', Role: 'Employee', EmployeeID: 3, OrderDate: new Date(837369e6),
ShipName: 'Wellington Importadora', ShipCity: 'Resende', ShipAddress: 'Rua do Mercado, 12',
ShipRegion: 'SP', Mask: '9999', ShipPostalCode: '08737-363', ShipCountry: 'Brazil', Freight: 13.97, Verified: !1
},
{
OrderID: 10257, CustomerID: 'HILAA', Role: 'Admin', EmployeeID: 4, OrderDate: new Date(8374554e5),
ShipName: 'HILARION-Abastos', ShipCity: 'San Cristóbal', ShipAddress: 'Carrera 22 con Ave. Carlos Soublette #8-35',
ShipRegion: 'Táchira', Mask: '1234', ShipPostalCode: '5022', ShipCountry: 'Venezuela', Freight: 81.91, Verified: !0
},
{
OrderID: 10258, CustomerID: 'ERNSH', Role: 'Manager', EmployeeID: 1, OrderDate: new Date(8375418e5),
ShipName: 'Ernst Handel', ShipCity: 'Graz', ShipAddress: 'Kirchgasse 6',
ShipRegion: 'CJ', Mask: '2345', ShipPostalCode: '8010', ShipCountry: 'Austria', Freight: 140.51, Verified: !0
},
{
OrderID: 10259, CustomerID: 'CENTC', Role: 'Admin', EmployeeID: 4, OrderDate: new Date(8376282e5),
ShipName: 'Centro comercial Moctezuma', ShipCity: 'México D.F.', ShipAddress: 'Sierras de Granada 9993',
ShipRegion: 'CJ', Mask: '3456', ShipPostalCode: '05022', ShipCountry: 'Mexico', Freight: 3.25, Verified: !1
},
{
OrderID: 10260, CustomerID: 'OTTIK', Role: 'Admin', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Ottilies Käseladen', ShipCity: 'Köln', ShipAddress: 'Mehrheimerstr. 369',
ShipRegion: 'CJ', Mask: '4567', ShipPostalCode: '50739', ShipCountry: 'Germany', Freight: 55.09, Verified: !0
},
{
OrderID: 10261, CustomerID: 'QUEDE', Role: 'Manager', EmployeeID: 4, OrderDate: new Date(8377146e5),
ShipName: 'Que Delícia', ShipCity: 'Rio de Janeiro', ShipAddress: 'Rua da Panificadora, 12',
ShipRegion: 'RJ', Mask: '5678', ShipPostalCode: '02389-673', ShipCountry: 'Brazil', Freight: 3.05, Verified: !1
},
{
OrderID: 10262, CustomerID: 'RATTC', Role: 'Employee', EmployeeID: 8, OrderDate: new Date(8379738e5),
ShipName: 'Rattlesnake Canyon Grocery', ShipCity: 'Albuquerque', ShipAddress: '2817 Milton Dr.',
ShipRegion: 'NM', Mask: '6789', ShipPostalCode: '87110', ShipCountry: 'USA', Freight: 48.29, Verified: !0
}];
export let employeeDetails: Object[] = [
{
EmployeeID: 1, Role: 'TeamLead', Salary: 15000, Address: 'Chennai'
},
{
EmployeeID: 2, Role: 'Manager', Salary: 20000, Address: 'Bangalore'
},
{
EmployeeID: 3, Role: 'Engineer', Salary: 10000, Address: 'Cochin'
},
{
EmployeeID: 4, Role: 'Sales', Salary: 20000, Address: 'Trivandrum'
},
{
EmployeeID: 5, Role: 'Support', Salary: 10000, Address: 'Delhi'
}
];
export let purchaseData: 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:40:00.000Z',
'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:30:00.000Z',
'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-17T18:30:00.000Z',
'ShippedDate': '1996-07-23T20:40:00.000Z',
'Freight': 22.98,
'ShipName': 'Chop-suey Chinese',
'ShipAddress': 'Hauptstr. 31',
'ShipCity': 'Bern',
'ShipRegion': null,
'ShipCountry': 'Switzerland'
},
{
'OrderID': 10255,
'CustomerID': 'RICSU',
'OrderDate': '1996-07-12T10:40:00.000Z',
'ShippedDate': '1996-07-15T05:40:00.000Z',
'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-17T21:50: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:40:00.000Z',
'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:30:00.000Z',
'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:30:00.000Z',
'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-22T21:40:00.000Z',
'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:40:00.000Z',
'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:40:00.000Z',
'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-05T21:10: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:40:00.000Z',
'ShippedDate': '1996-09-12T02:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-08-21T04:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-08-21T06:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-08-23T08:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-08-27T10:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-08-26T12:40:00.000Z',
'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-26T21:20: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:30:00.000Z',
'Freight': 150.15,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',
'ShipCity': 'Albuquerque',
'ShipRegion': 'NM',
'ShipCountry': 'USA'
},
{
'OrderID': 10317,
'CustomerID': 'LONEP',
'OrderDate': '1996-09-30T01:30:00.000Z',
'ShippedDate': '1996-10-10T02:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-04T03:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-11T05:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-18T07:30:00.000Z',
'Freight': 34.57,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10321,
'CustomerID': 'ISLAT',
'OrderDate': '1996-10-03T08:30:00.000Z',
'ShippedDate': '1996-10-11T09:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-23T11:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-14T13:30:00.000Z',
'Freight': 4.88,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10324,
'CustomerID': 'SAVEA',
'OrderDate': '1996-10-08T14:30:00.000Z',
'ShippedDate': '1996-10-10T15:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-14T17:30:00.000Z',
'Freight': 64.86,
'ShipName': 'Königlich Essen',
'ShipAddress': 'Maubelstr. 90',
'ShipCity': 'Brandenburg',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10326,
'CustomerID': 'BOLID',
'OrderDate': '1996-10-10T18:30:00.000Z',
'ShippedDate': '1996-10-14T19:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-14T21:30:00.000Z',
'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:30:00.000Z',
'ShippedDate': '1996-10-17T23:30:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-23T01:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-28T03:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-21T03:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-21T05:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-25T07:40:00.000Z',
'Freight': 0.59,
'ShipName': 'Wartian Herkku',
'ShipAddress': 'Torikatu 38',
'ShipCity': 'Oulu',
'ShipRegion': null,
'ShipCountry': 'Finland'
},
{
'OrderID': 10334,
'CustomerID': 'VICTE',
'OrderDate': '1996-10-21T08:40:00.000Z',
'ShippedDate': '1996-10-28T09:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-24T11:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-25T13:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-10-29T14:40:00.000Z',
'Freight': 108.26,
'ShipName': 'Frankenversand',
'ShipAddress': 'Berliner Platz 43',
'ShipCity': 'München',
'ShipRegion': null,
'ShipCountry': 'Germany'
},
{
'OrderID': 10338,
'CustomerID': 'OLDWO',
'OrderDate': '1996-10-25T15:40:00.000Z',
'ShippedDate': '1996-10-29T16:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-11-04T18:40:00.000Z',
'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:40:00.000Z',
'ShippedDate': '1996-11-08T20:40:00.000Z',
'Freight': 166.31,
'ShipName': 'Bon app',
'ShipAddress': '12, rue des Bouchers',
'ShipCity': 'Marseille',
'ShipRegion': null,
'ShipCountry': 'France'
},
{
'OrderID': 10341,
'CustomerID': 'SIMOB',
'OrderDate': '1996-10-29T21:40:00.000Z',
'ShippedDate': '1996-11-05T22:40:00.000Z',
'Freight': 26.78,
'ShipName': 'Simons bistro',
'ShipAddress': 'Vinbæltet 34',
'ShipCity': 'Kobenhavn',
'ShipRegion': null,
'ShipCountry': 'Denmark'
},
{
'OrderID': 10342,
'CustomerID': 'FRANK',
'OrderDate': '1996-10-30T23:40:00.000Z',
'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-25T21:50: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-14T21:50: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-28T21:05: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-13T21:00.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-25T21:25: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-07T21:45: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-24T21:55: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-03T21:05: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-11T21:15: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-24T21:25: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-07T21:00.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-21T21:00.00.000Z',
'Freight': 708.95,
'ShipName': 'Rattlesnake Canyon Grocery',
'ShipAddress': '2817 Milton Dr.',