Search results

Visualize current view records of grid in chart in React Chart component

30 Jul 2021 / 2 minutes to read

You can visualize the data that returned by grid in chart.

To visualize the data in chart, follow the given steps:

Step 1:

Initialize the grid with datasource.

Step 2:

By using the grid’s actionComplete event and getCurrentViewRecords method, you can get the current page records. By using the grid’s databound event, you can update the current page records into the chart’s datasource and visualize the grid data in chart.

Source
Preview
index.tsx
datasource.ts
Copied to clipboard
import React from 'react';
import * as ReactDOM from "react-dom";
import {
  ChartComponent, SeriesCollectionDirective, SeriesDirective, Inject, AxisModel, Chart, ColumnSeries, DateTime
} from '@syncfusion/ej2-react-charts';
import { ColumnDirective, ColumnsDirective, GridComponent, Page, PageSettingsModel, Selection, Grid } from '@syncfusion/ej2-react-grids';
import { DataManager, Query } from '@syncfusion/ej2-data';
import { orderData } from './datasource';


class App extends React.Component<{}, {}> {
  public pageSettings: PageSettingsModel = { pageSize: 10 }
  public data: object[] = new DataManager(orderData).executeLocal(new Query().take(100));
  private grid: Grid | GridComponent | null;
  public chart: Chart | ChartComponent | null;
  public primaryxAxis: AxisModel = { valueType: 'DateTime' };
  public actionComplete(args: any) {
    if (args.requestType === 'paging') {
      (this.chart as Chart).series[0].dataSource = (this.grid as Grid).getCurrentViewRecords();
      (this.chart as Chart).refresh();
    }
  };
  public dataBound(args: any): void {
    (this.chart as Chart).series[0].dataSource = this.grid.getCurrentViewRecords();
  };
  render() {
    return (<div className='row'>
      <div className="col-sm-4" style={{ width: "400px", height: "350px", float: "left" }}>
        <GridComponent ref={g => this.grid = g} id='grid' dataSource={this.data} allowPaging={true} pageSettings={this.pageSettings} actionComplete={this.actionComplete.bind(this)} dataBound={this.dataBound.bind(this)}>
          <ColumnsDirective>
            <ColumnDirective field='OrderDate' headerText='Order Date' width='130' format='yMd' textAlign="Right" />
            <ColumnDirective field='Freight' width='120' format='C2' textAlign='Right' />
          </ColumnsDirective>
          <Inject services={[Page, Selection]} />
        </GridComponent>
      </div>
      <div className="col-sm-4" style={{ width: "400px", height: "400px", float: "left" }}>
        <ChartComponent ref={g => this.chart = g} id='chart' primaryXAxis={this.primaryxAxis}>
          <Inject services={[ColumnSeries, DateTime]} />
          <SeriesCollectionDirective>
            <SeriesDirective name='Germany' xName='OrderDate' yName='Freight' width={2} type='Column' marker={{ visible: true, width: 10, height: 10 }}>
            </SeriesDirective>
          </SeriesCollectionDirective>
        </ChartComponent>
      </div>
    </div>)
  }
};
ReactDOM.render(<App />, document.getElementById('charts'));
Copied to clipboard
export let productData: Object[] = [
    {
        'ProductID': 1,
        'ProductName': 'Chai',
        'SupplierID': 1,
        'QuantityPerUnit': '10 boxes x 20 bags',
        'UnitPrice': 18.00,
        'UnitsInStock': 39,
        'Discontinued': true
    },

    {
        'ProductID': 2,
        'ProductName': 'Chang',
        'SupplierID': 1,
        'QuantityPerUnit': '24 - 12 oz bottles',
        'UnitPrice': 19.00,
        'UnitsInStock': 17,
        'Discontinued': true
    },

    {
        'ProductID': 3,
        'ProductName': 'Aniseed Syrup',
        'SupplierID': 1,
        'QuantityPerUnit': '12 - 550 ml bottles',
        'UnitPrice': 10.00,
        'UnitsInStock': 13,
        'Discontinued': true
    },

    {
        'ProductID': 4,
        'ProductName': 'Chef Anton\'s Cajun Seasoning',
        'SupplierID': 2,
        'QuantityPerUnit': '48 - 6 oz jars',
        'UnitPrice': 22.00,
        'UnitsInStock': 53,
        'Discontinued': true
    },

    {
        'ProductID': 5,
        'ProductName': 'Chef Anton\'s Gumbo Mix',
        'SupplierID': 2,
        'QuantityPerUnit': '36 boxes',
        'UnitPrice': 21.35,
        'UnitsInStock': 0,
        'Discontinued': true
    },

    {
        'ProductID': 6,
        'ProductName': 'Grandma\'s Boysenberry Spread',
        'SupplierID': 3,
        'QuantityPerUnit': '12 - 8 oz jars',
        'UnitPrice': 25.00,
        'UnitsInStock': 120,
        'Discontinued': false
    },

    {
        'ProductID': 7,
        'ProductName': 'Uncle Bob\'s Organic Dried Pears',
        'SupplierID': 3,
        'QuantityPerUnit': '12 - 1 lb pkgs.',
        'UnitPrice': 30.00,
        'UnitsInStock': 15,
        'Discontinued': false
    },

    {
        'ProductID': 8,
        'ProductName': 'Northwoods Cranberry Sauce',
        'SupplierID': 3,
        'QuantityPerUnit': '12 - 12 oz jars',
        'UnitPrice': 40.00,
        'UnitsInStock': 6,
        'Discontinued': false
    },

    {
        'ProductID': 9,
        'ProductName': 'Mishi Kobe Niku',
        'SupplierID': 4,
        'QuantityPerUnit': '18 - 500 g pkgs.',
        'UnitPrice': 97.00,
        'UnitsInStock': 29,
        'Discontinued': true
    },

    {
        'ProductID': 10,
        'ProductName': 'Ikura',
        'SupplierID': 4,
        'QuantityPerUnit': '12 - 200 ml jars',
        'UnitPrice': 31.00,
        'UnitsInStock': 31,
        'Discontinued': false
    },

    {
        'ProductID': 11,
        'ProductName': 'Queso Cabrales',
        'SupplierID': 5,
        'QuantityPerUnit': '1 kg pkg.',
        'UnitPrice': 21.00,
        'UnitsInStock': 22,
        'Discontinued': false
    },

    {
        'ProductID': 12,
        'ProductName': 'Queso Manchego La Pastora',
        'SupplierID': 5,
        'QuantityPerUnit': '10 - 500 g pkgs.',
        'UnitPrice': 38.00,
        'UnitsInStock': 86,
        'Discontinued': false
    },

    {
        'ProductID': 13,
        'ProductName': 'Konbu',
        'SupplierID': 6,
        'QuantityPerUnit': '2 kg box',
        'UnitPrice': 6.00,
        'UnitsInStock': 24,
        'Discontinued': true
    },

    {
        'ProductID': 14,
        'ProductName': 'Tofu',
        'SupplierID': 6,
        'QuantityPerUnit': '40 - 100 g pkgs.',
        'UnitPrice': 23.25,
        'UnitsInStock': 35,
        'Discontinued': true
    },

    {
        'ProductID': 15,
        'ProductName': 'Genen Shouyu',
        'SupplierID': 6,
        'QuantityPerUnit': '24 - 250 ml bottles',
        'UnitPrice': 15.50,
        'UnitsInStock': 39,
        'Discontinued': true
    },

    {
        'ProductID': 16,
        'ProductName': 'Pavlova',
        'SupplierID': 7,
        'QuantityPerUnit': '32 - 500 g boxes',
        'UnitPrice': 17.45,
        'UnitsInStock': 29,
        'Discontinued': true
    },

    {
        'ProductID': 17,
        'ProductName': 'Alice Mutton',
        'SupplierID': 7,
        'QuantityPerUnit': '20 - 1 kg tins',
        'UnitPrice': 39.00,
        'UnitsInStock': 0,
        'Discontinued': true
    },

    {
        'ProductID': 18,
        'ProductName': 'Carnarvon Tigers',
        'SupplierID': 7,
        'QuantityPerUnit': '16 kg pkg.',
        'UnitPrice': 62.50,
        'UnitsInStock': 42,
        'Discontinued': false
    },

    {
        'ProductID': 19,
        'ProductName': 'Teatime Chocolate Biscuits',
        'SupplierID': 8,
        'QuantityPerUnit': '10 boxes x 12 pieces',
        'UnitPrice': 9.20,
        'UnitsInStock': 25,
        'Discontinued': false
    },

    {
        'ProductID': 20,
        'ProductName': 'Sir Rodney\'s Marmalade',
        'SupplierID': 8,
        'QuantityPerUnit': '30 gift boxes',
        'UnitPrice': 81.00,
        'UnitsInStock': 40,
        'Discontinued': false
    },

    {
        'ProductID': 21,
        'ProductName': 'Sir Rodney\'s Scones',
        'SupplierID': 8,
        'QuantityPerUnit': '24 pkgs. x 4 pieces',
        'UnitPrice': 10.00,
        'UnitsInStock': 3,
        'Discontinued': false
    },

    {
        'ProductID': 22,
        'ProductName': 'Gustaf\'s Knäckebröd',
        'SupplierID': 9,
        'QuantityPerUnit': '24 - 500 g pkgs.',
        'UnitPrice': 21.00,
        'UnitsInStock': 104,
        'Discontinued': false
    },

    {
        'ProductID': 23,
        'ProductName': 'Tunnbröd',
        'SupplierID': 9,
        'QuantityPerUnit': '12 - 250 g pkgs.',
        'UnitPrice': 9.00,
        'UnitsInStock': 61,
        'Discontinued': false
    },

    {
        'ProductID': 24,
        'ProductName': 'Guaraná Fantástica',
        'SupplierID': 10,
        'QuantityPerUnit': '12 - 355 ml cans',
        'UnitPrice': 4.50,
        'UnitsInStock': 20,
        'Discontinued': true
    },

    {
        'ProductID': 25,
        'ProductName': 'NuNuCa Nuß-Nougat-Creme',
        'SupplierID': 11,
        'QuantityPerUnit': '20 - 450 g glasses',
        'UnitPrice': 14.00,
        'UnitsInStock': 76,
        'Discontinued': false
    },

    {
        'ProductID': 26,
        'ProductName': 'Gumbär Gummibärchen',
        'SupplierID': 11,
        'QuantityPerUnit': '100 - 250 g bags',
        'UnitPrice': 31.23,
        'UnitsInStock': 15,
        'Discontinued': true
    },

    {
        'ProductID': 27,
        'ProductName': 'Schoggi Schokolade',
        'SupplierID': 11,
        'QuantityPerUnit': '100 - 100 g pieces',
        'UnitPrice': 43.90,
        'UnitsInStock': 49,
        'Discontinued': true
    },

    {
        'ProductID': 28,
        'ProductName': 'Rössle Sauerkraut',
        'SupplierID': 12,
        'QuantityPerUnit': '25 - 825 g cans',
        'UnitPrice': 45.60,
        'UnitsInStock': 26,
        'Discontinued': true
    },

    {
        'ProductID': 29,
        'ProductName': 'Thüringer Rostbratwurst',
        'SupplierID': 12,
        'QuantityPerUnit': '50 bags x 30 sausgs.',
        'UnitPrice': 123.79,
        'UnitsInStock': 0,
        'Discontinued': true
    },

    {
        'ProductID': 30,
        'ProductName': 'Nord-Ost Matjeshering',
        'SupplierID': 13,
        'QuantityPerUnit': '10 - 200 g glasses',
        'UnitPrice': 25.89,
        'UnitsInStock': 10,
        'Discontinued': true
    },

    {
        'ProductID': 31,
        'ProductName': 'Gorgonzola Telino',
        'SupplierID': 14,
        'QuantityPerUnit': '12 - 100 g pkgs',
        'UnitPrice': 12.50,
        'UnitsInStock': 0,
        'Discontinued': true
    },

    {
        'ProductID': 32,
        'ProductName': 'Mascarpone Fabioli',
        'SupplierID': 14,
        'QuantityPerUnit': '24 - 200 g pkgs.',
        'UnitPrice': 32.00,
        'UnitsInStock': 9,
        'Discontinued': false
    },

    {
        'ProductID': 33,
        'ProductName': 'Geitost',
        'SupplierID': 15,
        'QuantityPerUnit': '500 g',
        'UnitPrice': 2.50,
        'UnitsInStock': 112,
        'Discontinued': false
    },

    {
        'ProductID': 34,
        'ProductName': 'Sasquatch Ale',
        'SupplierID': 16,
        'QuantityPerUnit': '24 - 12 oz bottles',
        'UnitPrice': 14.00,
        'UnitsInStock': 111,
        'Discontinued': false
    },

    {
        'ProductID': 35,
        'ProductName': 'Steeleye Stout',
        'SupplierID': 16,
        'QuantityPerUnit': '24 - 12 oz bottles',
        'UnitPrice': 18.00,
        'UnitsInStock': 20,
        'Discontinued': false
    },

    {
        'ProductID': 36,
        'ProductName': 'Inlagd Sill',
        'SupplierID': 17,
        'QuantityPerUnit': '24 - 250 g  jars',
        'UnitPrice': 19.00,
        'UnitsInStock': 112,
        'Discontinued': false
    },

    {
        'ProductID': 37,
        'ProductName': 'Gravad lax',
        'SupplierID': 17,
        'QuantityPerUnit': '12 - 500 g pkgs.',
        'UnitPrice': 26.00,
        'UnitsInStock': 11,
        'Discontinued': false
    },

    {
        'ProductID': 38,
        'ProductName': 'Côte de Blaye',
        'SupplierID': 18,
        'QuantityPerUnit': '12 - 75 cl bottles',
        'UnitPrice': 263.50,
        'UnitsInStock': 17,
        'Discontinued': false
    },

    {
        'ProductID': 39,
        'ProductName': 'Chartreuse verte',
        'SupplierID': 18,
        'QuantityPerUnit': '750 cc per bottle',
        'UnitPrice': 18.00,
        'UnitsInStock': 69,
        'Discontinued': true
    },

    {
        'ProductID': 40,
        'ProductName': 'Boston Crab Meat',
        'SupplierID': 19,
        'QuantityPerUnit': '24 - 4 oz tins',
        'UnitPrice': 18.40,
        'UnitsInStock': 123,
        'Discontinued': true
    },

    {
        'ProductID': 41,
        'ProductName': 'Jack\'s New England Clam Chowder',
        'SupplierID': 19,
        'QuantityPerUnit': '12 - 12 oz cans',
        'UnitPrice': 9.65,
        'UnitsInStock': 85,
        'Discontinued': false
    },

    {
        'ProductID': 42,
        'ProductName': 'Singaporean Hokkien Fried Mee',
        'SupplierID': 20,
        'QuantityPerUnit': '32 - 1 kg pkgs.',
        'UnitPrice': 14.00,
        'UnitsInStock': 26,
        'Discontinued': true
    },

    {
        'ProductID': 43,
        'ProductName': 'Ipoh Coffee',
        'SupplierID': 20,
        'QuantityPerUnit': '16 - 500 g tins',
        'UnitPrice': 46.00,
        'UnitsInStock': 17,
        'Discontinued': false
    },

    {
        'ProductID': 44,
        'ProductName': 'Gula Malacca',
        'SupplierID': 20,
        'QuantityPerUnit': '20 - 2 kg bags',
        'UnitPrice': 19.45,
        'UnitsInStock': 27,
        'Discontinued': false
    },

    {
        'ProductID': 45,
        'ProductName': 'Rogede sild',
        'SupplierID': 21,
        'QuantityPerUnit': '1k pkg.',
        'UnitPrice': 9.50,
        'UnitsInStock': 5,
        'Discontinued': true
    },

    {
        'ProductID': 46,
        'ProductName': 'Spegesild',
        'SupplierID': 21,
        'QuantityPerUnit': '4 - 450 g glasses',
        'UnitPrice': 12.00,
        'UnitsInStock': 95,
        'Discontinued': true
    },

    {
        'ProductID': 47,
        'ProductName': 'Zaanse koeken',
        'SupplierID': 22,
        'QuantityPerUnit': '10 - 4 oz boxes',
        'UnitPrice': 9.50,
        'UnitsInStock': 36,
        'Discontinued': true
    },

    {
        'ProductID': 48,
        'ProductName': 'Chocolade',
        'SupplierID': 22,
        'QuantityPerUnit': '10 pkgs.',
        'UnitPrice': 12.75,
        'UnitsInStock': 15,
        'Discontinued': true
    },

    {
        'ProductID': 49,
        'ProductName': 'Maxilaku',
        'SupplierID': 23,
        'QuantityPerUnit': '24 - 50 g pkgs.',
        'UnitPrice': 20.00,
        'UnitsInStock': 10,
        'Discontinued': false
    },

    {
        'ProductID': 50,
        'ProductName': 'Valkoinen suklaa',
        'SupplierID': 23,
        'QuantityPerUnit': '12 - 100 g bars',
        'UnitPrice': 16.25,
        'UnitsInStock': 65,
        'Discontinued': false
    },

    {
        'ProductID': 51,
        'ProductName': 'Manjimup Dried Apples',
        'SupplierID': 24,
        'QuantityPerUnit': '50 - 300 g pkgs.',
        'UnitPrice': 53.00,
        'UnitsInStock': 20,
        'Discontinued': false
    },

    {
        'ProductID': 52,
        'ProductName': 'Filo Mix',
        'SupplierID': 24,
        'QuantityPerUnit': '16 - 2 kg boxes',
        'UnitPrice': 7.00,
        'UnitsInStock': 38,
        'Discontinued': true
    },

    {
        'ProductID': 53,
        'ProductName': 'Perth Pasties',
        'SupplierID': 24,
        'QuantityPerUnit': '48 pieces',
        'UnitPrice': 32.80,
        'UnitsInStock': 0,
        'Discontinued': true
    },

    {
        'ProductID': 54,
        'ProductName': 'Tourtière',
        'SupplierID': 25,
        'QuantityPerUnit': '16 pies',
        'UnitPrice': 7.45,
        'UnitsInStock': 21,
        'Discontinued': true
    },

    {
        'ProductID': 55,
        'ProductName': 'Pâté chinois',
        'SupplierID': 25,
        'QuantityPerUnit': '24 boxes x 2 pies',
        'UnitPrice': 24.00,
        'UnitsInStock': 115,
        'Discontinued': true
    },

    {
        'ProductID': 56,
        'ProductName': 'Gnocchi di nonna Alice',
        'SupplierID': 26,
        'QuantityPerUnit': '24 - 250 g pkgs.',
        'UnitPrice': 38.00,
        'UnitsInStock': 21,
        'Discontinued': false
    },

    {
        'ProductID': 57,
        'ProductName': 'Ravioli Angelo',
        'SupplierID': 26,
        'QuantityPerUnit': '24 - 250 g pkgs.',
        'UnitPrice': 19.50,
        'UnitsInStock': 36,
        'Discontinued': false
    },

    {
        'ProductID': 58,
        'ProductName': 'Escargots de Bourgogne',
        'SupplierID': 27,
        'QuantityPerUnit': '24 pieces',
        'UnitPrice': 13.25,
        'UnitsInStock': 62,
        'Discontinued': false
    },

    {
        'ProductID': 59,
        'ProductName': 'Raclette Courdavault',
        'SupplierID': 28,
        'QuantityPerUnit': '5 kg pkg.',
        'UnitPrice': 55.00,
        'UnitsInStock': 79,
        'Discontinued': false
    },

    {
        'ProductID': 60,
        'ProductName': 'Camembert Pierrot',
        'SupplierID': 28,
        'QuantityPerUnit': '15 - 300 g rounds',
        'UnitPrice': 34.00,
        'UnitsInStock': 19,
        'Discontinued': false
    },

    {
        'ProductID': 61,
        'ProductName': 'Sirop d\'érable',
        'SupplierID': 29,
        'QuantityPerUnit': '24 - 500 ml bottles',
        'UnitPrice': 28.50,
        'UnitsInStock': 113,
        'Discontinued': false
    },

    {
        'ProductID': 62,
        'ProductName': 'Tarte au sucre',
        'SupplierID': 29,
        'QuantityPerUnit': '48 pies',
        'UnitPrice': 49.30,
        'UnitsInStock': 17,
        'Discontinued': false
    },

    {
        'ProductID': 63,
        'ProductName': 'Vegie-spread',
        'SupplierID': 7,
        'QuantityPerUnit': '15 - 625 g jars',
        'UnitPrice': 43.90,
        'UnitsInStock': 24,
        'Discontinued': true
    },

    {
        'ProductID': 64,
        'ProductName': 'Wimmers gute Semmelknödel',
        'SupplierID': 12,
        'QuantityPerUnit': '20 bags x 4 pieces',
        'UnitPrice': 33.25,
        'UnitsInStock': 22,
        'Discontinued': true
    },

    {
        'ProductID': 65,
        'ProductName': 'Louisiana Fiery Hot Pepper Sauce',
        'SupplierID': 2,
        'QuantityPerUnit': '32 - 8 oz bottles',
        'UnitPrice': 21.05,
        'UnitsInStock': 76,
        'Discontinued': true
    },

    {
        'ProductID': 66,
        'ProductName': 'Louisiana Hot Spiced Okra',
        'SupplierID': 2,
        'QuantityPerUnit': '24 - 8 oz jars',
        'UnitPrice': 17.00,
        'UnitsInStock': 4,
        'Discontinued': false
    },

    {
        'ProductID': 67,
        'ProductName': 'Laughing Lumberjack Lager',
        'SupplierID': 16,
        'QuantityPerUnit': '24 - 12 oz bottles',
        'UnitPrice': 14.00,
        'UnitsInStock': 52,
        'Discontinued': false
    },

    {
        'ProductID': 68,
        'ProductName': 'Scottish Longbreads',
        'SupplierID': 8,
        'QuantityPerUnit': '10 boxes x 8 pieces',
        'UnitPrice': 12.50,
        'UnitsInStock': 6,
        'Discontinued': false
    },

    {
        'ProductID': 69,
        'ProductName': 'Gudbrandsdalsost',
        'SupplierID': 15,
        'QuantityPerUnit': '10 kg pkg.',
        'UnitPrice': 36.00,
        'UnitsInStock': 26,
        'Discontinued': false
    },

    {
        'ProductID': 70,
        'ProductName': 'Outback Lager',
        'SupplierID': 7,
        'QuantityPerUnit': '24 - 355 ml bottles',
        'UnitPrice': 15.00,
        'UnitsInStock': 15,
        'Discontinued': false
    },

    {
        'ProductID': 71,
        'ProductName': 'Flotemysost',
        'SupplierID': 15,
        'QuantityPerUnit': '10 - 500 g pkgs.',
        'UnitPrice': 21.50,
        'UnitsInStock': 26,
        'Discontinued': true
    },

    {
        'ProductID': 72,
        'ProductName': 'Mozzarella di Giovanni',
        'SupplierID': 14,
        'QuantityPerUnit': '24 - 200 g pkgs.',
        'UnitPrice': 34.80,
        'UnitsInStock': 14,
        'Discontinued': true
    },

    {
        'ProductID': 73,
        'ProductName': 'Röd Kaviar',
        'SupplierID': 17,
        'QuantityPerUnit': '24 - 150 g jars',
        'UnitPrice': 15.00,
        'UnitsInStock': 101,
        'Discontinued': true
    },

    {
        'ProductID': 74,
        'ProductName': 'Longlife Tofu',
        'SupplierID': 4,
        'QuantityPerUnit': '5 kg pkg.',
        'UnitPrice': 10.00,
        'UnitsInStock': 4,
        'Discontinued': true
    },

    {
        'ProductID': 75,
        'ProductName': 'Rhönbräu Klosterbier',
        'SupplierID': 12,
        'QuantityPerUnit': '24 - 0.5 l bottles',
        'UnitPrice': 7.75,
        'UnitsInStock': 125,
        'Discontinued': true
    },

    {
        'ProductID': 76,
        'ProductName': 'Lakkalikööri',
        'SupplierID': 23,
        'QuantityPerUnit': '500 ml',
        'UnitPrice': 18.00,
        'UnitsInStock': 57,
        'Discontinued': true
    },

    {
        'ProductID': 77,
        'ProductName': 'Original Frankfurter grüne Soße',
        'SupplierID': 12,
        'QuantityPerUnit': '12 boxes',
        'UnitPrice': 13.00,
        'UnitsInStock': 32,
        'Discontinued': false
    }];

export let employeeData: Object[] = [{
    'EmployeeID': 1,
    'LastName': 'Davolio',
    'FirstName': 'Nancy',
    'Title': 'Sales Representative',
    'TitleOfCourtesy': 'Ms.',
    'BirthDate': new Date(-664743600000),
    'HireDate': new Date(704692800000),
    'Address': '507 - 20th Ave. E.\r\nApt. 2A',
    'City': 'Seattle',
    'Region': 'WA',
    'PostalCode': '98122',
    'Country': 'USA',
    'HomePhone': '(206) 555-9857',
    'Extension': '5467',
    'Photo': { 'Length': 21626 },

    'Notes': 'Education includes a BA in psychology from Colorado State University in 1970.  She also completed\
    \'The Art of the Cold Call.\'  Nancy is a member of Toastmasters International.',
    'ReportsTo': 2,
    'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
    'EmployeeID': 2,
    'LastName': 'Fuller',
    'FirstName': 'Andrew',
    'Title': 'Vice President, Sales',
    'TitleOfCourtesy': 'Dr.',
    'BirthDate': new Date(-563828400000),
    'HireDate': new Date(713764800000),
    'Address': '908 W. Capital Way',
    'City': 'Tacoma',
    'Region': 'WA',
    'PostalCode': '98401',
    'Country': 'USA',
    'HomePhone': '(206) 555-9482',
    'Extension': '3457',
    'Photo': { 'Length': 21626 },

    'Notes': 'Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of \
    Dallas in 1981.  He is fluent in French and Italian and reads German.  He joined the company as a sales representative, \
    was promoted to sales manager in January 1992 and to vice president of sales in March 1993.  Andrew is a member of the \
    Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.',
    'ReportsTo': 0,
    'PhotoPath': 'http://accweb/emmployees/fuller.bmp'
},
{
    'EmployeeID': 3,
    'LastName': 'Leverling',
    'FirstName': 'Janet',
    'Title': 'Sales Representative',
    'TitleOfCourtesy': 'Ms.',
    'BirthDate': new Date(-200088000000),
    'HireDate': new Date(702104400000),
    'Address': '722 Moss Bay Blvd.',
    'City': 'Kirkland',
    'Region': 'WA',
    'PostalCode': '98033',
    'Country': 'USA',
    'HomePhone': '(206) 555-3412',
    'Extension': '3355',
    'Photo': { 'Length': 21722 },

    'Notes': 'Janet has a BS degree in chemistry from Boston College (1984). \
     She has also completed a certificate program in food retailing management.\
     Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.',
    'ReportsTo': 2,
    'PhotoPath': 'http://accweb/emmployees/leverling.bmp'
},
{
    'EmployeeID': 4,
    'LastName': 'Peacock',
    'FirstName': 'Margaret',
    'Title': 'Sales Representative',
    'TitleOfCourtesy': 'Mrs.',
    'BirthDate': new Date(-1018814400000),
    'HireDate': new Date(736401600000),
    'Address': '4110 Old Redmond Rd.',
    'City': 'Redmond',
    'Region': 'WA',
    'PostalCode': '98052',
    'Country': 'USA',
    'HomePhone': '(206) 555-8122',
    'Extension': '5176',
    'Photo': { 'Length': 21626 },

    'Notes': 'Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American \
    Institute of Culinary Arts (1966).  She was assigned to the London office temporarily from July through November 1992.',
    'ReportsTo': 2,
    'PhotoPath': 'http://accweb/emmployees/peacock.bmp'
},
{
    'EmployeeID': 5,
    'LastName': 'Buchanan',
    'FirstName': 'Steven',
    'Title': 'Sales Manager',
    'TitleOfCourtesy': 'Mr.',
    'BirthDate': new Date(-468010800000),
    'HireDate': new Date(750830400000),
    'Address': '14 Garrett Hill',
    'City': 'London',
    'Region': null,
    'PostalCode':
    'SW1 8JR',
    'Country': 'UK',
    'HomePhone': '(71) 555-4848',
    'Extension': '3453',
    'Photo': { 'Length': 21626 },

    'Notes': 'Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976.  Upon joining the company as \
    a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent \
    post in London.  He was promoted to sales manager in March 1993.  Mr. Buchanan has completed the courses \'Successful \
    Telemarketing\' and \'International Sales Management.\'  He is fluent in French.',
    'ReportsTo': 2,
    'PhotoPath': 'http://accweb/emmployees/buchanan.bmp'
},
{
    'EmployeeID': 6,
    'LastName': 'Suyama',
    'FirstName': 'Michael',
    'Title': 'Sales Representative',
    'TitleOfCourtesy': 'Mr.',
    'BirthDate': new Date(-205185600000),
    'HireDate': new Date(750830400000),
    'Address': 'Coventry House\r\nMiner Rd.',
    'City': 'London',
    'Region': null,
    'PostalCode': 'EC2 7JR',
    'Country': 'UK',
    'HomePhone': '(71) 555-7773',
    'Extension': '428',
    'Photo': { 'Length': 21626 },

    'Notes': 'Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles \
    (MBA, marketing, 1986).  He has also taken the courses \'Multi-Cultural Selling\' and \'Time Management for the Sales Professional.\'  \
    He is fluent in Japanese and can read and write French, Portuguese, and Spanish.',
    'ReportsTo': 5,
    'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
    'EmployeeID': 7,
    'LastName': 'King',
    'FirstName': 'Robert',
    'Title': 'Sales Representative',
    'TitleOfCourtesy': 'Mr.',
    'BirthDate': new Date(-302731200000),
    'HireDate': new Date(757486800000),
    'Address': 'Edgeham Hollow\r\nWinchester Way',
    'City': 'London',
    'Region': null,
    'PostalCode': 'RG1 9SP',
    'Country': 'UK',
    'HomePhone': '(71) 555-5598',
    'Extension': '465',
    'Photo': { 'Length': 21626 },

    'Notes': 'Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the \
    University of Michigan in 1992, the year he joined the company.  After completing a course entitled \'Selling in Europe,\' \
    he was transferred to the London office in March 1993.',
    'ReportsTo': 5,
    'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
    'EmployeeID': 8,
    'LastName': 'Callahan',
    'FirstName': 'Laura',
    'Title': 'Inside Sales Coordinator',
    'TitleOfCourtesy': 'Ms.',
    'BirthDate': new Date(-377982000000),
    'HireDate': new Date(762843600000),
    'Address': '4726 - 11th Ave. N.E.',
    'City': 'Seattle',
    'Region': 'WA',
    'PostalCode': '98105',
    'Country': 'USA',
    'HomePhone': '(206) 555-1189',
    'Extension': '2344',
    'Photo': { 'Length': 21626 },

    'Notes': 'Laura received a BA in psychology from the University of Washington.  She has also completed a course in business \
    French.  She reads and writes French.',
    'ReportsTo': 2,
    'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
},
{
    'EmployeeID': 9,
    'LastName': 'Dodsworth',
    'FirstName': 'Anne',
    'Title': 'Sales Representative',
    'TitleOfCourtesy': 'Ms.',
    'BirthDate': new Date(-123966000000),
    'HireDate': new Date(784875600000),
    'Address': '7 Houndstooth Rd.',
    'City': 'London',
    'Region': null,
    'PostalCode': 'WG2 7LT',
    'Country': 'UK',
    'HomePhone': '(71) 555-4444',
    'Extension': '452',
    'Photo': { 'Length': 21626 },

    'Notes': 'Anne has a BA degree in English from St. Lawrence College.  She is fluent in French and German.',
    'ReportsTo': 5,
    'PhotoPath': 'http://accweb/emmployees/davolio.bmp'
}];

let stringData: string = JSON.stringify([
    {
        'OrderID': 10248,
        'CustomerID': 'VINET',
        'OrderDate': '1996-07-04T00:00:00.000Z',
        'ShippedDate': '1996-07-16T00:00: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-05T00:00:00.000Z',
        'ShippedDate': '1996-07-10T00:00: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-08T00:00:00.000Z',
        'ShippedDate': '1996-07-12T00:00: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-08T00:00:00.000Z',
        'ShippedDate': '1996-07-15T00:00: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-09T00:00:00.000Z',
        'ShippedDate': '1996-07-11T00:00: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-10T00:00:00.000Z',
        'ShippedDate': '1996-07-16T00:00: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-11T00:00:00.000Z',
        'ShippedDate': '1996-07-23T00:00: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-12T00:00:00.000Z',
        'ShippedDate': '1996-07-15T00:00: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-15T00:00:00.000Z',
        'ShippedDate': '1996-07-17T00:00: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-16T00:00:00.000Z',
        'ShippedDate': '1996-07-22T00:00: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-17T00:00:00.000Z',
        'ShippedDate': '1996-07-23T00:00:00.000Z',
        'Freight': 140.51,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10259,
        'CustomerID': 'CENTC',
        'OrderDate': '1996-07-18T00:00:00.000Z',
        'ShippedDate': '1996-07-25T00:00: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-19T00:00:00.000Z',
        'ShippedDate': '1996-07-29T00:00: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-19T00:00:00.000Z',
        'ShippedDate': '1996-07-30T00:00: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-22T00:00:00.000Z',
        'ShippedDate': '1996-07-25T00:00: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:00:00.000Z',
        'ShippedDate': '1996-07-31T00:00:00.000Z',
        'Freight': 146.06,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10264,
        'CustomerID': 'FOLKO',
        'OrderDate': '1996-07-24T00:00:00.000Z',
        'ShippedDate': '1996-08-23T00:00: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-25T00:00:00.000Z',
        'ShippedDate': '1996-08-12T00:00: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-26T00:00:00.000Z',
        'ShippedDate': '1996-07-31T00:00:00.000Z',
        'Freight': 25.73,
        'ShipName': 'Wartian Herkku',
        'ShipAddress': 'Torikatu 38',
        'ShipCity': 'Oulu',
        'ShipRegion': null,
        'ShipCountry': 'Finland'
    },

    {
        'OrderID': 10267,
        'CustomerID': 'FRANK',
        'OrderDate': '1996-07-29T00:00:00.000Z',
        'ShippedDate': '1996-08-06T00:00: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-30T00:00:00.000Z',
        'ShippedDate': '1996-08-02T00:00: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-31T00:00:00.000Z',
        'ShippedDate': '1996-08-09T00:00: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-01T00:00:00.000Z',
        'ShippedDate': '1996-08-02T00:00:00.000Z',
        'Freight': 136.54,
        'ShipName': 'Wartian Herkku',
        'ShipAddress': 'Torikatu 38',
        'ShipCity': 'Oulu',
        'ShipRegion': null,
        'ShipCountry': 'Finland'
    },

    {
        'OrderID': 10271,
        'CustomerID': 'SPLIR',
        'OrderDate': '1996-08-01T00:00:00.000Z',
        'ShippedDate': '1996-08-30T00:00: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-02T00:00:00.000Z',
        'ShippedDate': '1996-08-06T00:00: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-05T00:00:00.000Z',
        'ShippedDate': '1996-08-12T00:00: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-06T00:00:00.000Z',
        'ShippedDate': '1996-08-16T00:00: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-07T00:00:00.000Z',
        'ShippedDate': '1996-08-09T00:00: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-08T00:00:00.000Z',
        'ShippedDate': '1996-08-14T00:00: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-09T00:00:00.000Z',
        'ShippedDate': '1996-08-13T00:00:00.000Z',
        'Freight': 125.77,
        'ShipName': 'Morgenstern Gesundkost',
        'ShipAddress': 'Heerstr. 22',
        'ShipCity': 'Leipzig',
        'ShipRegion': null,
        'ShipCountry': 'Germany'
    },

    {
        'OrderID': 10278,
        'CustomerID': 'BERGS',
        'OrderDate': '1996-08-12T00:00:00.000Z',
        'ShippedDate': '1996-08-16T00:00: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-13T00:00:00.000Z',
        'ShippedDate': '1996-08-16T00:00: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-14T00:00:00.000Z',
        'ShippedDate': '1996-09-12T00:00: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-14T00:00:00.000Z',
        'ShippedDate': '1996-08-21T00:00: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-15T00:00:00.000Z',
        'ShippedDate': '1996-08-21T00:00: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-16T00:00:00.000Z',
        'ShippedDate': '1996-08-23T00:00: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-19T00:00:00.000Z',
        'ShippedDate': '1996-08-27T00:00: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-20T00:00:00.000Z',
        'ShippedDate': '1996-08-26T00:00: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-21T00:00:00.000Z',
        'ShippedDate': '1996-08-30T00:00: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-22T00:00:00.000Z',
        'ShippedDate': '1996-08-28T00:00: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-23T00:00:00.000Z',
        'ShippedDate': '1996-09-03T00:00: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-26T00:00:00.000Z',
        'ShippedDate': '1996-08-28T00:00:00.000Z',
        'Freight': 22.77,
        'ShipName': 'B\' Beverages',
        'ShipAddress': 'Fauntleroy Circus',
        'ShipCity': 'London',
        'ShipRegion': null,
        'ShipCountry': 'UK'
    },

    {
        'OrderID': 10290,
        'CustomerID': 'COMMI',
        'OrderDate': '1996-08-27T00:00:00.000Z',
        'ShippedDate': '1996-09-03T00:00: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-27T00:00:00.000Z',
        'ShippedDate': '1996-09-04T00:00: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-28T00:00:00.000Z',
        'ShippedDate': '1996-09-02T00:00: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-29T00:00:00.000Z',
        'ShippedDate': '1996-09-11T00:00: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-30T00:00:00.000Z',
        'ShippedDate': '1996-09-05T00:00: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-02T00:00:00.000Z',
        'ShippedDate': '1996-09-10T00:00: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-03T00:00:00.000Z',
        'ShippedDate': '1996-09-11T00:00: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-04T00:00:00.000Z',
        'ShippedDate': '1996-09-10T00:00: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-05T00:00:00.000Z',
        'ShippedDate': '1996-09-11T00:00: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-06T00:00:00.000Z',
        'ShippedDate': '1996-09-13T00:00: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-09T00:00:00.000Z',
        'ShippedDate': '1996-09-18T00:00: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-09T00:00:00.000Z',
        'ShippedDate': '1996-09-17T00:00: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-10T00:00:00.000Z',
        'ShippedDate': '1996-10-09T00:00: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-11T00:00:00.000Z',
        'ShippedDate': '1996-09-18T00:00: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:00:00.000Z',
        'ShippedDate': '1996-09-17T00:00: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-13T00:00:00.000Z',
        'ShippedDate': '1996-10-09T00:00: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-16T00:00:00.000Z',
        'ShippedDate': '1996-09-23T00:00: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-17T00:00:00.000Z',
        'ShippedDate': '1996-09-25T00:00: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-18T00:00:00.000Z',
        'ShippedDate': '1996-09-24T00:00: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-19T00:00:00.000Z',
        'ShippedDate': '1996-10-23T00:00: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-20T00:00:00.000Z',
        'ShippedDate': '1996-09-27T00:00: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-20T00:00:00.000Z',
        'ShippedDate': '1996-09-26T00:00: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-23T00:00:00.000Z',
        'ShippedDate': '1996-10-03T00:00: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-24T00:00:00.000Z',
        'ShippedDate': '1996-10-04T00:00: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-25T00:00:00.000Z',
        'ShippedDate': '1996-10-04T00:00: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-26T00:00:00.000Z',
        'ShippedDate': '1996-10-03T00:00: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-27T00:00:00.000Z',
        'ShippedDate': '1996-10-08T00:00: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-30T00:00:00.000Z',
        'ShippedDate': '1996-10-10T00:00: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-01T00:00:00.000Z',
        'ShippedDate': '1996-10-04T00:00: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-02T00:00:00.000Z',
        'ShippedDate': '1996-10-11T00:00: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-03T00:00:00.000Z',
        'ShippedDate': '1996-10-18T00:00:00.000Z',
        'Freight': 34.57,
        'ShipName': 'Wartian Herkku',
        'ShipAddress': 'Torikatu 38',
        'ShipCity': 'Oulu',
        'ShipRegion': null,
        'ShipCountry': 'Finland'
    },

    {
        'OrderID': 10321,
        'CustomerID': 'ISLAT',
        'OrderDate': '1996-10-03T00:00:00.000Z',
        'ShippedDate': '1996-10-11T00:00: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-04T00:00:00.000Z',
        'ShippedDate': '1996-10-23T00:00: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-07T00:00:00.000Z',
        'ShippedDate': '1996-10-14T00:00: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-08T00:00:00.000Z',
        'ShippedDate': '1996-10-10T00:00: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-09T00:00:00.000Z',
        'ShippedDate': '1996-10-14T00:00: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-10T00:00:00.000Z',
        'ShippedDate': '1996-10-14T00:00: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-11T00:00:00.000Z',
        'ShippedDate': '1996-10-14T00:00: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-14T00:00:00.000Z',
        'ShippedDate': '1996-10-17T00:00: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:00:00.000Z',
        'ShippedDate': '1996-10-23T00:00: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-16T00:00:00.000Z',
        'ShippedDate': '1996-10-28T00:00: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-16T00:00:00.000Z',
        'ShippedDate': '1996-10-21T00:00: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-17T00:00:00.000Z',
        'ShippedDate': '1996-10-21T00:00: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-18T00:00:00.000Z',
        'ShippedDate': '1996-10-25T00:00:00.000Z',
        'Freight': 0.59,
        'ShipName': 'Wartian Herkku',
        'ShipAddress': 'Torikatu 38',
        'ShipCity': 'Oulu',
        'ShipRegion': null,
        'ShipCountry': 'Finland'
    },

    {
        'OrderID': 10334,
        'CustomerID': 'VICTE',
        'OrderDate': '1996-10-21T00:00:00.000Z',
        'ShippedDate': '1996-10-28T00:00: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-22T00:00:00.000Z',
        'ShippedDate': '1996-10-24T00:00: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-23T00:00:00.000Z',
        'ShippedDate': '1996-10-25T00:00: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-24T00:00:00.000Z',
        'ShippedDate': '1996-10-29T00:00: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-25T00:00:00.000Z',
        'ShippedDate': '1996-10-29T00:00: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-28T00:00:00.000Z',
        'ShippedDate': '1996-11-04T00:00: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-29T00:00:00.000Z',
        'ShippedDate': '1996-11-08T00:00: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-29T00:00:00.000Z',
        'ShippedDate': '1996-11-05T00:00: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-30T00:00:00.000Z',
        'ShippedDate': '1996-11-04T00:00: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-31T00:00:00.000Z',
        'ShippedDate': '1996-11-06T00:00: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-01T00:00:00.000Z',
        'ShippedDate': '1996-11-05T00:00: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-04T00:00:00.000Z',
        'ShippedDate': '1996-11-11T00:00: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-05T00:00:00.000Z',
        'ShippedDate': '1996-11-08T00:00: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-06T00:00:00.000Z',
        'ShippedDate': '1996-11-08T00:00: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-07T00:00:00.000Z',
        'ShippedDate': '1996-11-15T00:00: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-08T00:00:00.000Z',
        'ShippedDate': '1996-11-15T00:00: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-11T00:00:00.000Z',
        'ShippedDate': '1996-12-03T00:00: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-11T00:00:00.000Z',
        'ShippedDate': '1996-11-20T00:00:00.000Z',
        'Freight': 162.33,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10352,
        'CustomerID': 'FURIB',
        'OrderDate': '1996-11-12T00:00:00.000Z',
        'ShippedDate': '1996-11-18T00:00: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-13T00:00:00.000Z',
        'ShippedDate': '1996-11-25T00:00: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-14T00:00:00.000Z',
        'ShippedDate': '1996-11-20T00:00: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-15T00:00:00.000Z',
        'ShippedDate': '1996-11-20T00:00: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-18T00:00:00.000Z',
        'ShippedDate': '1996-11-27T00:00: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-19T00:00:00.000Z',
        'ShippedDate': '1996-12-02T00:00: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-20T00:00:00.000Z',
        'ShippedDate': '1996-11-27T00:00: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-21T00:00:00.000Z',
        'ShippedDate': '1996-11-26T00:00: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-22T00:00:00.000Z',
        'ShippedDate': '1996-12-02T00:00: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-22T00:00:00.000Z',
        'ShippedDate': '1996-12-03T00:00: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-25T00:00:00.000Z',
        'ShippedDate': '1996-11-28T00:00: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-26T00:00:00.000Z',
        'ShippedDate': '1996-12-04T00:00:00.000Z',
        'Freight': 30.54,
        'ShipName': 'Drachenblut Delikatessen',
        'ShipAddress': 'Walserweg 21',
        'ShipCity': 'Aachen',
        'ShipRegion': null,
        'ShipCountry': 'Germany'
    },

    {
        'OrderID': 10364,
        'CustomerID': 'EASTC',
        'OrderDate': '1996-11-26T00:00:00.000Z',
        'ShippedDate': '1996-12-04T00:00: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-27T00:00:00.000Z',
        'ShippedDate': '1996-12-02T00:00: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-28T00:00:00.000Z',
        'ShippedDate': '1996-12-30T00:00: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-28T00:00:00.000Z',
        'ShippedDate': '1996-12-02T00:00:00.000Z',
        'Freight': 13.55,
        'ShipName': 'Vaffeljernet',
        'ShipAddress': 'Smagsloget 45',
        'ShipCity': 'Århus',
        'ShipRegion': null,
        'ShipCountry': 'Denmark'
    },

    {
        'OrderID': 10368,
        'CustomerID': 'ERNSH',
        'OrderDate': '1996-11-29T00:00:00.000Z',
        'ShippedDate': '1996-12-02T00: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-02T00:00:00.000Z',
        'ShippedDate': '1996-12-09T00:00: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-03T00:00:00.000Z',
        'ShippedDate': '1996-12-27T00: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-03T00:00:00.000Z',
        'ShippedDate': '1996-12-24T00: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-04T00:00:00.000Z',
        'ShippedDate': '1996-12-09T00: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-05T00:00:00.000Z',
        'ShippedDate': '1996-12-11T00: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-05T00:00:00.000Z',
        'ShippedDate': '1996-12-09T00: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-06T00:00:00.000Z',
        'ShippedDate': '1996-12-09T00: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-09T00:00:00.000Z',
        'ShippedDate': '1996-12-13T00: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-09T00:00:00.000Z',
        'ShippedDate': '1996-12-13T00: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-10T00:00:00.000Z',
        'ShippedDate': '1996-12-19T00: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-11T00:00:00.000Z',
        'ShippedDate': '1996-12-13T00:00: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-12T00:00:00.000Z',
        'ShippedDate': '1997-01-16T00:00: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-12T00:00:00.000Z',
        'ShippedDate': '1996-12-13T00:00: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-13T00:00:00.000Z',
        'ShippedDate': '1996-12-16T00:00:00.000Z',
        'Freight': 94.77,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10383,
        'CustomerID': 'AROUT',
        'OrderDate': '1996-12-16T00:00:00.000Z',
        'ShippedDate': '1996-12-18T00:00: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-16T00:00:00.000Z',
        'ShippedDate': '1996-12-20T00:00: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-17T00:00:00.000Z',
        'ShippedDate': '1996-12-23T00:00: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-18T00:00:00.000Z',
        'ShippedDate': '1996-12-25T00:00: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-18T00:00:00.000Z',
        'ShippedDate': '1996-12-20T00:00: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-19T00:00:00.000Z',
        'ShippedDate': '1996-12-20T00:00: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-20T00:00:00.000Z',
        'ShippedDate': '1996-12-24T00:00: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-23T00:00:00.000Z',
        'ShippedDate': '1996-12-26T00:00:00.000Z',
        'Freight': 126.38,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10391,
        'CustomerID': 'DRACD',
        'OrderDate': '1996-12-23T00:00:00.000Z',
        'ShippedDate': '1996-12-31T00:00:00.000Z',
        'Freight': 5.45,
        'ShipName': 'Drachenblut Delikatessen',
        'ShipAddress': 'Walserweg 21',
        'ShipCity': 'Aachen',
        'ShipRegion': null,
        'ShipCountry': 'Germany'
    },

    {
        'OrderID': 10392,
        'CustomerID': 'PICCO',
        'OrderDate': '1996-12-24T00:00:00.000Z',
        'ShippedDate': '1997-01-01T00:00: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-25T00:00:00.000Z',
        'ShippedDate': '1997-01-03T00:00: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-25T00:00:00.000Z',
        'ShippedDate': '1997-01-03T00:00: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-26T00:00:00.000Z',
        'ShippedDate': '1997-01-03T00:00: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-27T00:00:00.000Z',
        'ShippedDate': '1997-01-06T00:00: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-27T00:00:00.000Z',
        'ShippedDate': '1997-01-02T00:00: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-30T00:00:00.000Z',
        'ShippedDate': '1997-01-09T00:00: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-31T00:00:00.000Z',
        'ShippedDate': '1997-01-08T00:00:00.000Z',
        'Freight': 27.36,
        'ShipName': 'Vaffeljernet',
        'ShipAddress': 'Smagsloget 45',
        'ShipCity': 'Århus',
        'ShipRegion': null,
        'ShipCountry': 'Denmark'
    },

    {
        'OrderID': 10400,
        'CustomerID': 'EASTC',
        'OrderDate': '1997-01-01T00:00:00.000Z',
        'ShippedDate': '1997-01-16T00:00: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-01T00:00:00.000Z',
        'ShippedDate': '1997-01-10T00:00: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-02T00:00:00.000Z',
        'ShippedDate': '1997-01-10T00:00:00.000Z',
        'Freight': 67.88,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10403,
        'CustomerID': 'ERNSH',
        'OrderDate': '1997-01-03T00:00:00.000Z',
        'ShippedDate': '1997-01-09T00:00:00.000Z',
        'Freight': 73.79,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10404,
        'CustomerID': 'MAGAA',
        'OrderDate': '1997-01-03T00:00:00.000Z',
        'ShippedDate': '1997-01-08T00:00: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-06T00:00:00.000Z',
        'ShippedDate': '1997-01-22T00:00: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-07T00:00:00.000Z',
        'ShippedDate': '1997-01-13T00:00: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-07T00:00:00.000Z',
        'ShippedDate': '1997-01-30T00:00: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-08T00:00:00.000Z',
        'ShippedDate': '1997-01-14T00:00: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-09T00:00:00.000Z',
        'ShippedDate': '1997-01-14T00:00: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-10T00:00:00.000Z',
        'ShippedDate': '1997-01-15T00:00: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-10T00:00:00.000Z',
        'ShippedDate': '1997-01-21T00:00: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-13T00:00:00.000Z',
        'ShippedDate': '1997-01-15T00:00:00.000Z',
        'Freight': 3.77,
        'ShipName': 'Wartian Herkku',
        'ShipAddress': 'Torikatu 38',
        'ShipCity': 'Oulu',
        'ShipRegion': null,
        'ShipCountry': 'Finland'
    },

    {
        'OrderID': 10413,
        'CustomerID': 'LAMAI',
        'OrderDate': '1997-01-14T00:00:00.000Z',
        'ShippedDate': '1997-01-16T00:00: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-14T00:00:00.000Z',
        'ShippedDate': '1997-01-17T00:00: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-15T00:00:00.000Z',
        'ShippedDate': '1997-01-24T00:00: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-16T00:00:00.000Z',
        'ShippedDate': '1997-01-27T00:00:00.000Z',
        'Freight': 22.72,
        'ShipName': 'Wartian Herkku',
        'ShipAddress': 'Torikatu 38',
        'ShipCity': 'Oulu',
        'ShipRegion': null,
        'ShipCountry': 'Finland'
    },

    {
        'OrderID': 10417,
        'CustomerID': 'SIMOB',
        'OrderDate': '1997-01-16T00:00:00.000Z',
        'ShippedDate': '1997-01-28T00:00: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-17T00:00:00.000Z',
        'ShippedDate': '1997-01-24T00:00: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-20T00:00:00.000Z',
        'ShippedDate': '1997-01-30T00:00: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-21T00:00:00.000Z',
        'ShippedDate': '1997-01-27T00:00: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-21T00:00:00.000Z',
        'ShippedDate': '1997-01-27T00:00: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-22T00:00:00.000Z',
        'ShippedDate': '1997-01-31T00:00: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-23T00:00:00.000Z',
        'ShippedDate': '1997-02-24T00:00: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-23T00:00:00.000Z',
        'ShippedDate': '1997-01-27T00:00: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-24T00:00:00.000Z',
        'ShippedDate': '1997-02-14T00:00: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-27T00:00:00.000Z',
        'ShippedDate': '1997-02-06T00:00: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-27T00:00:00.000Z',
        'ShippedDate': '1997-03-03T00:00: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-28T00:00:00.000Z',
        'ShippedDate': '1997-02-04T00:00: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-29T00:00:00.000Z',
        'ShippedDate': '1997-02-07T00:00: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-30T00:00:00.000Z',
        'ShippedDate': '1997-02-03T00:00:00.000Z',
        'Freight': 458.78,
        'ShipName': 'Ernst Handel',
        'ShipAddress': 'Kirchgasse 6',
        'ShipCity': 'Graz',
        'ShipRegion': null,
        'ShipCountry': 'Austria'
    },

    {
        'OrderID': 10431,
        'CustomerID': 'BOTTM',
        'OrderDate': '1997-01-30T00:00:00.000Z',
        'ShippedDate': '1997-02-07T00:00: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-31T00:00:00.000Z',
        'ShippedDate': '1997-02-07T00:00: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-03T00:00:00.000Z',
        'ShippedDate': '1997-03-04T00:00: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-03T00:00:00.000Z',
        'ShippedDate'