Search results

Pie & Doughnut in React Accumulation Chart component

25 Sep 2022 / 9 minutes to read

Pie Chart

To render a pie series, use the series type as Pie and inject the PieSeries module into the services. If the PieSeries module is not injected, this module will be loaded by default.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, PieSeries, Inject } from '@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';
class App extends React.Component {
    render() {
        return <AccumulationChartComponent id='charts'>
      <Inject services={[PieSeries]}/>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' type='Pie'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, PieSeries, Inject}
from'@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';

class App extends React.Component<{}, {}> {

  render() {
    return <AccumulationChartComponent id='charts'>
      <Inject services={[PieSeries]} />
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' type='Pie'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Radius customization

By default, radius of the pie series will be 80% of the size (minimum of chart width and height). You can customize this using radius property of the series.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective } from '@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';
class App extends React.Component {
    render() {
        return <AccumulationChartComponent id='charts'>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' radius='100%'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective}
from'@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';

class App extends React.Component<{}, {}> {

  render() {
    return <AccumulationChartComponent id='charts'>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' radius='100%'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Pie Center

The center position of the pie can be changed by Center X and Center Y. By default, center value of the pie series x and y is 50%. You can customize this using centerproperty of the series.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, Inject, AccumulationLegend, PieSeries, AccumulationTooltip, AccumulationDataLabel } from '@syncfusion/ej2-react-charts';
import { data1 } from 'datasource.ts';
class App extends React.Component {
    render() {
        return <AccumulationChartComponent id='pie-chart' ref={pie => this.pie = pie} title='Mobile Browser Statistics' load={this.load.bind(this)} legendSettings={{ visible: false }} enableSmartLabels={true} enableAnimation={false} center={{ x: '60%', y: '60%' }} tooltip={{ enable: false, format: '${point.x} : <b>${point.y}%</b>' }}>
              <Inject services={[AccumulationLegend, PieSeries, AccumulationTooltip, AccumulationDataLabel]}/>
              <AccumulationSeriesCollectionDirective>
                <AccumulationSeriesDirective dataSource={data1} name='Browser' xName='x' yName='y' explode={true} explodeOffset='10%' explodeIndex={0} dataLabel={{
            visible: true,
            position: 'Inside', name: 'text',
            font: {
                fontWeight: '600'
            }
        }} radius='70%'>
                </AccumulationSeriesDirective>
              </AccumulationSeriesCollectionDirective>
            </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective,
  Inject, AccumulationLegend, PieSeries, AccumulationTooltip,
  AccumulationDataLabel }
from'@syncfusion/ej2-react-charts';
import { data1 } from 'datasource.ts';

class App extends React.Component<{}, {}> {
  public pie: AccumulationChartComponent;
  render() {
   return <AccumulationChartComponent id='pie-chart' ref={pie => this.pie = pie}
              title='Mobile Browser Statistics'
              load={this.load.bind(this)}
              legendSettings={{ visible: false }}
              enableSmartLabels={true}
              enableAnimation={false}
              center={{x: '60%', y: '60%'}}
              tooltip={{ enable: false, format: '${point.x} : <b>${point.y}%</b>' }}
            >
              <Inject services={[AccumulationLegend, PieSeries, AccumulationTooltip, AccumulationDataLabel]} />
              <AccumulationSeriesCollectionDirective>
                <AccumulationSeriesDirective dataSource={data1} name='Browser' xName='x' yName='y'
                  explode={true} explodeOffset='10%' explodeIndex={0}
                  dataLabel={{
                    visible: true,
                    position: 'Inside', name: 'text',
                    font: {
                      fontWeight: '600'
                    }
                  }}
                  radius='70%'
                >
                </AccumulationSeriesDirective>
              </AccumulationSeriesCollectionDirective>
            </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Various Radius Pie Chart

You can use radius mapping to render the slice with different radius pie and also use border , fill properties to customize the point. dataLabel is used to represent individual data and its value.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, AccumulationLegend, PieSeries, AccumulationDataLabel, AccumulationTooltip, Inject } from '@syncfusion/ej2-react-charts';
class App extends React.Component {
    render() {
        return <AccumulationChartComponent id='pie-chart' ref={pie => this.pie = pie} legendSettings={{
            visible: true
        }} enableSmartLabels={true} enableAnimation={true} tooltip={{ enable: true }}>
            <Inject services={[AccumulationLegend, PieSeries, AccumulationDataLabel, AccumulationTooltip]}/>
            <AccumulationSeriesCollectionDirective>
              <AccumulationSeriesDirective dataSource={data1} xName='x' yName='y' innerRadius='20%' dataLabel={{
            visible: true, position: 'Outside', name: 'x'
        }} radius='r'>
              </AccumulationSeriesDirective>
            </AccumulationSeriesCollectionDirective>
          </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import {  AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, AccumulationLegend, PieSeries, AccumulationDataLabel, AccumulationTooltip,
Inject } from'@syncfusion/ej2-react-charts';
import { variouspiedata } from 'datasource.ts';

class App extends React.Component<{}, {}> {
  public pie: AccumulationChartComponent;
  render() {
    return <AccumulationChartComponent id='pie-chart' ref={pie => this.pie = pie}
            legendSettings={{
              visible: true
            }}
            enableSmartLabels={true}
            enableAnimation={true}
            tooltip={{ enable: true }}
          >
            <Inject services={[AccumulationLegend, PieSeries, AccumulationDataLabel, AccumulationTooltip]} />
            <AccumulationSeriesCollectionDirective>
              <AccumulationSeriesDirective dataSource={data1} xName='x' yName='y' innerRadius='20%'
                dataLabel={{
                  visible: true, position: 'Outside', name: 'x'
                }}
                radius='r'
              >
              </AccumulationSeriesDirective>
            </AccumulationSeriesCollectionDirective>
          </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Doughnut Chart

To achieve a doughnut in pie series, customize the innerRadius property of the series. By setting value greater than 0%, a doughnut will appear. The innerRadius property takes value from 0% to 100% of the pie radius.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective } from '@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';
class App extends React.Component {
    render() {
        return <AccumulationChartComponent id='charts'>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' innerRadius='40%'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective}
from'@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';

class App extends React.Component<{}, {}> {

  render() {
    return <AccumulationChartComponent id='charts'>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' innerRadius='40%'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Start and End angles

You can customize the start and end angle of the pie series using the startAngle and endAngle properties. The default value of startAngle is 0 degree, and endAngle is 360 degrees. By customizing this, you can achieve a semi pie series.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, Inject, AccumulationDataLabel } from '@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';
class App extends React.Component {
    render() {
        return <AccumulationChartComponent id='charts'>
      <Inject services={[AccumulationDataLabel]}/>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' startAngle='270' endAngle='90' dataLabel={{ visible: true, name: 'text', position: 'Outside' }}>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, Inject, AccumulationDataLabel}
from'@syncfusion/ej2-react-charts';
import { accData } from 'datasource.ts';

class App extends React.Component<{}, {}> {

  render() {
    return <AccumulationChartComponent id='charts'>
      <Inject services={[AccumulationDataLabel]} />
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={accData} xName='x' yName='y' startAngle='270' endAngle='90'
          dataLabel={{ visible: true, name: 'text', position: 'Outside' }}>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Color & Text Mapping

The fill color and the text in the data source can be mapped to the chart using pointColorMapping in series and name in datalabel respectively.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, Inject, AccumulationDataLabel } from '@syncfusion/ej2-react-charts';
import { dataMapping } from 'datasource.ts';
class App extends React.Component {
    constructor() {
        super(...arguments);
        this.datalabel = { visible: true, name: 'text', position: 'Outside' };
    }
    render() {
        return <AccumulationChartComponent id='charts'>
      <Inject services={[AccumulationDataLabel]}/>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={dataMapping} xName='x' yName='y' pointColorMapping='fill' dataLabel={this.datalabel}></AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective,
Inject, AccumulationDataLabel,AccumulationDataLabelSettingsModel}
from'@syncfusion/ej2-react-charts';
import { dataMapping } from 'datasource.ts';

class App extends React.Component<{}, {}> {

  public datalabel: AccumulationDataLabelSettingsModel = { visible: true, name: 'text', position: 'Outside' };

  render() {
    return <AccumulationChartComponent id='charts'>
      <Inject services={[AccumulationDataLabel]} />
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={dataMapping} xName='x' yName='y' pointColorMapping='fill'
          dataLabel={this.datalabel}></AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Customization

Individual points can be customized using the pointRender event.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, Inject, AccumulationDataLabel } from '@syncfusion/ej2-react-charts';
import { dataMapping } from 'datasource.ts';
class App extends React.Component {
    constructor() {
        super(...arguments);
        this.onPointRender = (args) => {
            if (args.point.x.indexOf('Apr') > -1) {
                args.fill = '#f4bc42';
            }
            else {
                args.fill = '#597cf9';
            }
        };
    }
    render() {
        return <AccumulationChartComponent id='charts' pointRender={this.onPointRender}>
      <Inject services={[AccumulationDataLabel]}/>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={dataMapping} xName='x' yName='y'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective,IAccPointRenderEventArgs, AccumulationSeriesDirective, Inject, AccumulationDataLabel}
from'@syncfusion/ej2-react-charts';
import { dataMapping } from 'datasource.ts';

class App extends React.Component<{}, {}> {

  public onPointRender: EmitType<IAccPointRenderEventArgs> = (args: IAccPointRenderEventArgs): void => {
    if ((args.point.x as string).indexOf('Apr') > -1) {
      args.fill = '#f4bc42';
    }
    else {
      args.fill = '#597cf9';
    }
  };

  render() {
    return <AccumulationChartComponent id='charts' pointRender={this.onPointRender}>
      <Inject services={[AccumulationDataLabel]} />
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={dataMapping} xName='x' yName='y'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Hide pie or doughnut border

By default, the border will appear in the pie/doughnut chart while mouse hover on the chart. You can disable the the border by setting enableBorderOnMouseMove property is false.

Source
Preview
index.jsx
index.tsx
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective, AccumulationSeriesDirective, Inject, AccumulationDataLabel } from '@syncfusion/ej2-react-charts';
import { dataMapping } from 'datasource.ts';
class App extends React.Component {
    render() {
        return <AccumulationChartComponent id='charts' enableBorderOnMouseMove={false}>
      <Inject services={[AccumulationDataLabel]}/>
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={dataMapping} xName='x' yName='y'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>;
    }
}
;
ReactDOM.render(<App />, document.getElementById("charts"));
Copied to clipboard
import * as React from "react";
import * as ReactDOM from "react-dom";
import { AccumulationChartComponent, AccumulationSeriesCollectionDirective,IAccPointRenderEventArgs, AccumulationSeriesDirective, Inject, AccumulationDataLabel}
from'@syncfusion/ej2-react-charts';
import { dataMapping } from 'datasource.ts';

class App extends React.Component<{}, {}> {
  render() {
    return <AccumulationChartComponent id='charts'
    enableBorderOnMouseMove={false}>
      <Inject services={[AccumulationDataLabel]} />
      <AccumulationSeriesCollectionDirective>
        <AccumulationSeriesDirective dataSource={dataMapping} xName='x' yName='y'>
        </AccumulationSeriesDirective>
      </AccumulationSeriesCollectionDirective>
    </AccumulationChartComponent>
  }

};
ReactDOM.render(<App />, document.getElementById("charts"));

Multi-level pie chart

You can achieve a multi-level drill down in pie and doughnut charts using pointClick event. If user clicks any point in the chart, that corresponding data will be shown in the next level and so on based on point clicked.

You can also achieve drill-up (back to the initial state) by using chartMouseClick event. In below sample, you can drill-up by clicking back button in the center of the chart.

Source
Preview
datasource.jsx
index.jsx
index.tsx
Copied to clipboard
export let productData = [
    {
        '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 = [{
        '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 = 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':