This section explains you the steps required to create a simple Essential JS 2 Grid and demonstrate the basic usage of the Grid control in a JavaScript application.
Following is the list of dependencies to use the grid with all features.
|-- @syncfusion/ej2-grids
|-- @syncfusion/ej2-base
|-- @syncfusion/ej2-data
|-- @syncfusion/ej2-buttons
|-- @syncfusion/ej2-popups
|-- @syncfusion/ej2-navigations
|-- @syncfusion/ej2-dropdowns
|-- @syncfusion/ej2-lists
|-- @syncfusion/ej2-inputs
|-- @syncfusion/ej2-splitbuttons
|-- @syncfusion/ej2-calendars
|-- @syncfusion/ej2-excel-export
|-- @syncfusion/ej2-pdf-export
|-- @syncfusion/ej2-file-utils
|-- @syncfusion/ej2-compression
|-- @syncfusion/ej2-notificationsRefer the following steps for setup your local environment.
Step 1: Create a root folder myapp for your application.
Step 2: Create myapp/resources folder to store local scripts and styles files.
Step 3: Create myapp/index.js and myapp/index.html files for initializing Essential JS 2 Grid control.
The Essential JS 2 Grid control can be initialized by using either of the following ways.
You can get the global scripts and styles from the Essential Studio JavaScript (Essential JS 2) build installed location.
After installing the Essential JS 2 product build, you can copy the grid and its dependencies scripts and style file into the resources/scripts and resources/styles folder.
Refer the below code to find location grid’s script and style file.
Syntax:
Script:
**(installed location)**/Syncfusion/Essential Studio/{RELEASE_VERSION}/Essential JS 2/{PACKAGE_NAME}/dist/global/{PACKAGE_NAME}.min.jsStyles:
**(installed location)**/Syncfusion/Essential Studio/{RELEASE_VERSION}/Essential JS 2/{PACKAGE_NAME}/styles/material.css
Example:
Script:
C:/Program Files (x86)/Syncfusion/Essential Studio/15.4.30/Essential JS 2/ej2-grids/dist/global/ej2-grids.min.jsStyles:
C:/Program Files (x86)/Syncfusion/Essential Studio/15.4.30/Essential JS 2/ej2-grids/styles/material.css
After copying the files, then you can refer the grid’s scripts and styles into the index.html file.
The below html code example shows the minimal dependency of grid.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Essential JS 2 Grid</title>
<!-- Essential JS 2 Grid's dependent material theme -->
<link href="resources/base/styles/material.css" rel="stylesheet" type="text/css"/>
<link href="resources/popups/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 material theme -->
<link href="resources/grids/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 Grid's dependent scripts -->
<script src="resources/scripts/ej2-base.min.js" type="text/javascript"></script>
<script src="resources/scripts/ej2-data.min.js" type="text/javascript"></script>
<script src="resources/scripts/ej2-popups.min.js" type="text/javascript"></script>
<!-- Essential JS 2 Grid's global script -->
<script src="resources/scripts/ej2-grids.min.js" type="text/javascript"></script>
</head>
<body>
</body>
</html>Using CDN link, you can directly refer the grid control’s script and style into the index.html.
Refer the grid’s CDN links as below
Syntax:
Script:
http://cdn.syncfusion.com/ej2/21.1.35/{PACKAGE_NAME}/dist/global/{PACKAGE_NAME}.min.jsStyles:
http://cdn.syncfusion.com/ej2/21.1.35/{PACKAGE_NAME}/styles/material.css
Example:
Script:
http://cdn.syncfusion.com/ej2/21.1.35/ej2-grids/dist/global/ej2-grids.min.jsStyles:
http://cdn.syncfusion.com/ej2/21.1.35/ej2-grids/styles/material.css
The below html code example shows the minimal dependency of grid.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Essential JS 2 Grid</title>
<!-- Essential JS 2 Grid's dependent material theme -->
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-base/styles/material.css" rel="stylesheet" type="text/css"/>
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-popups/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 material theme -->
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-grids/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 Grid's dependent script -->
<script src="http://cdn.syncfusion.com/ej2/21.1.35/ej2-base/dist/global/ej2-base.min.js" type="text/javascript"></script>
<script src="http://cdn.syncfusion.com/ej2/21.1.35/ej2-data/dist/global/ej2-data.min.js" type="text/javascript"></script>
<script src="http://cdn.syncfusion.com/ej2/21.1.35/ej2-popups/dist/global/ej2-popups.min.js" type="text/javascript"></script>
<!-- Essential JS 2 Grid's global script -->
<script src="http://cdn.syncfusion.com/ej2/21.1.35/ej2-grids/dist/global/ej2-grids.min.js" type="text/javascript"></script>
</head>
<body>
</body>
</html>Now, you can start adding Grid control in the application. For getting started, add a div element for Grid control in index.html. Then refer the index.js file into the index.html file.
In this document context we are going to use ej2.min.js which includes all the Essential JS 2 components and its dependent scripts.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Essential JS 2 Grid</title>
<!-- Essential JS 2 Grid's dependent material theme -->
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-base/styles/material.css" rel="stylesheet" type="text/css"/>
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-popups/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 material theme -->
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-grids/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 all script -->
<script src="http://cdn.syncfusion.com/ej2/21.1.35/dist/ej2.min.js" type="text/javascript"></script>
</head>
<body>
<!-- Add the HTML <div> element for grid -->
<div id="Grid"></div>
<script src="index.js" type="text/javascript"></script>
</body>
</html>Place the following grid code in the index.js.
var grid = new ej.grids.Grid();
grid.appendTo('#Grid');Data for the Grid control is bind by using dataSource property. It accepts either array of JavaScript object or DataManager instance.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Essential JS 2 Grid</title>
<!-- Essential JS 2 Grid's dependent material theme -->
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-base/styles/material.css" rel="stylesheet" type="text/css"/>
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-popups/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 material theme -->
<link href="http://cdn.syncfusion.com/ej2/21.1.35/ej2-grids/styles/material.css" rel="stylesheet" type="text/css"/>
<!-- Essential JS 2 all script -->
<script src="http://cdn.syncfusion.com/ej2/21.1.35/dist/ej2.min.js" type="text/javascript"></script>
</head>
<body>
<!-- Add the HTML <div> element for grid -->
<div id="Grid"></div>
<script src="index.js" type="text/javascript"></script>
</body>
</html>Place the following grid code in the index.js.
var data = [{ OrderID: 10248, CustomerID: 'VINET', Freight: 32.38, OrderDate: new Date(8364186e5) },
{ OrderID: 10249, CustomerID: 'TOMSP', Freight: 11.61, OrderDate: new Date(836505e6) },
{ OrderID: 10250, CustomerID: 'HANAR', Freight: 65.83, OrderDate: new Date(8367642e5) },
{ OrderID: 10251, CustomerID: 'VICTE', Freight: 41.34, OrderDate: new Date(8368506e5) },
{ OrderID: 10252, CustomerID: 'SUPRD', Freight: 51.3, OrderDate: new Date(8367642e5) },
{ OrderID: 10253, CustomerID: 'HANAR', Freight: 58.17, OrderDate: new Date(836937e6) },
{ OrderID: 10254, CustomerID: 'CHOPS', Freight: 22.98, OrderDate: new Date(8370234e5) },
{ OrderID: 10255, CustomerID: 'RICSU', Freight: 148.33, OrderDate: new Date(8371098e5) },
{ OrderID: 10256, CustomerID: 'WELLI', Freight: 13.97, OrderDate: new Date(837369e6) }];
var grid = new ej.grids.Grid({dataSource: data});
grid.appendTo('#Grid');The Grid has an option to define columns as array. In these columns, we have properties to customize columns. Let’s check the properties used here:
field to map with a property name an array of JavaScript objects.headerText to change the title of columns.textAlign to change the alignment of columns. By default, columns will be left aligned. To change columns to right align, we need to define textAlign as Right.format. Using this, we can format number and date values to standard or custom formats. Here, we have defined it for the conversion of numeric values to currency.var grid = new ej.grids.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' }
]
});
grid.appendTo('#Grid');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 ej.grids.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.
ej.grids.Grid.Inject(ej.grids.Page);
var grid = new ej.grids.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">
<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>
<script src="https://cdn.syncfusion.com/ej2/21.1.35/dist/ej2.min.js" type="text/javascript"></script>
<script src="es5-datasource.js" type="text/javascript"></script>
</head>
<body>
<div id="container">
<div id="Grid"></div>
</div>
<script>
var ele = document.getElementById('container');
if(ele) {
ele.style.visibility = "visible";
}
</script>
<script src="index.js" type="text/javascript"></script>
</body></html>var data = [
{
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
}];
var childdata = [
{
OrderID: 10248, CustomerID: 'VINET', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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', ID: 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
}];
var cascadeData = [
{
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: 'Australia', ShipState: 'Queensland', 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: 'Australia', ShipState: 'Tasmania', 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: 'United States', ShipState: 'New York', 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: 'Australia', ShipState: 'Queensland', 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: 'United States', ShipState: 'New York', 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: 'United States', ShipState: 'New York', 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: 'United States', ShipState: 'Virginia', 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: 'Australia', ShipState: 'Tasmania', 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: 'United States', ShipState: 'Virginia', 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: 'United States', ShipState: 'Virginia', 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: 'United States', ShipState: 'Washington', 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: 'United States', ShipState: 'Washington', 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: 'Australia', ShipState: 'Victoria', 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: 'United States', ShipState: 'Washington', 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: 'Australia', ShipState: 'Victoria', Freight: 48.29, Verified: !0
}];
var productData = [
{
ProductID: 1,
ProductName: 'Chai',
UnitPrice: 18.0,
UnitsInStock: 39,
TotalCost: 702
},
{
ProductID: 2,
ProductName: 'Chang',
UnitPrice: 19.0,
UnitsInStock: 17,
TotalCost: 323
},
{
ProductID: 3,
ProductName: 'Aniseed Syrup',
UnitPrice: 10.0,
UnitsInStock: 13,
TotalCost: 130
},
{
ProductID: 4,
ProductName: "Chef Anton's Cajun Seasoning",
UnitPrice: 22.0,
UnitsInStock: 53,
TotalCost: 1166
},
{
ProductID: 5,
ProductName: "Chef Anton's Gumbo Mix",
UnitPrice: 21.35,
UnitsInStock: 0,
TotalCost: 0
}
];
var purchaseData = [{
'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':