Standalone Field Chooser
DevExtreme includes a standalone PivotGridFieldChooser component. Unlike its integrated counterpart, the standalone field chooser can remain visible on the page at all times.
Follow the steps below to connect the PivotGridFieldChooser with the PivotGrid:
-
Bind both components to the same data source
Assign the same PivotGridDataSource instance to the dataSource property of both components. -
(Optional) Disable the integrated field chooser
Both field choosers can work simultaneously, but if you want to disable the integrated version, set the PivotGrid's fieldChooser.enabled property to false. -
(Optional) Apply field changes on demand
When users move fields within the field chooser, the changes are applied to the connected PivotGrid instantly. To change this behavior, set the applyChangesMode to "onDemand". In this mode, the changes are applied/canceled only when you call the applyChanges()/cancelChanges() method or set a new state. You can add a UI for these methods. For example, in this demo, they are bound to the Apply and Cancel buttons. Select "onDemand" from the Apply Changes Mode drop-down menu to display these buttons.
The standalone and integrated field choosers share features. For example, both field choosers include three layouts. You can use the radio buttons to switch between field choosers and review the differences. For information about other available features, refer to the Integrated Field Chooser demo.
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
<dx-pivot-grid
[allowSortingBySummary]="true"
[allowSorting]="true"
[allowFiltering]="true"
[showBorders]="true"
[dataSource]="pivotGridDataSource">
<dxo-field-chooser [enabled]="false"></dxo-field-chooser>
</dx-pivot-grid>
<div class="container">
<dx-pivot-grid-field-chooser
[dataSource]="pivotGridDataSource"
[width]="400"
[height]="400"
[layout]="layout"
[applyChangesMode]="applyChangesMode"
[(state)]="state">
<dxo-texts allFields="All"
columnFields="Columns"
dataFields="Data"
rowFields="Rows"
filterFields="Filter">
</dxo-texts>
</dx-pivot-grid-field-chooser>
<div class="bottom-bar" *ngIf="applyChangesMode === 'onDemand'">
<dx-button id="applyButton"
text="Apply"
type="default"
(onClick)="applyClick()">
</dx-button>
<dx-button
text="Cancel"
(onClick)="cancelClick()">
</dx-button>
</div>
<div class="options">
<div class="caption">Options</div>
<div class="option">
<span>Choose layout:</span>
<dx-radio-group
class="option-editor"
id="layouts"
[items]="layouts"
layout="vertical"
valueExpr="key"
displayExpr="name"
[(value)]="layout">
</dx-radio-group>
</div>
<div class="option">
<span>Apply Changes Mode:</span>
<dx-select-box
class="option-editor"
[items]="applyChangesModes"
width="180"
[(value)]="applyChangesMode">
</dx-select-box>
</div>
</div>
</div>
import { NgModule, Component, enableProdMode } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { DxPivotGridModule,
DxPivotGridFieldChooserModule,
DxRadioGroupModule,
DxButtonModule,
DxSelectBoxModule } from 'devextreme-angular';
import { Service, Layout, Sale } from './app.service';
import PivotGridDataSource from 'devextreme/ui/pivot_grid/data_source';
if(!/localhost/.test(document.location.host)) {
enableProdMode();
}
@Component({
selector: 'demo-app',
templateUrl: 'app/app.component.html',
styleUrls: ['app/app.component.css'],
providers: [Service],
preserveWhitespaces: true
})
export class AppComponent {
pivotGridDataSource: any;
layouts: Layout[];
layout = 0;
applyChangesModes: any;
applyChangesMode: any;
state: any;
constructor(service: Service) {
this.pivotGridDataSource = new PivotGridDataSource({
fields: [{
caption: "Region",
width: 120,
dataField: "region",
area: "row",
headerFilter: {
allowSearch: true
}
}, {
caption: "City",
dataField: "city",
width: 150,
area: "row",
headerFilter: {
allowSearch: true
},
selector: function(data: Sale) {
return data.city + " (" + data.country + ")";
}
}, {
dataField: "date",
dataType: "date",
area: "column"
}, {
caption: "Sales",
dataField: "amount",
dataType: "number",
summaryType: "sum",
format: "currency",
area: "data"
}],
store: service.getSales()
});
this.state = this.pivotGridDataSource.state();
this.layouts = service.getLayouts();
this.applyChangesModes = ["instantly", "onDemand"];
this.applyChangesMode = this.applyChangesModes[0];
}
applyClick(data) {
this.pivotGridDataSource.state(this.state);
}
cancelClick(data) {
this.state = this.pivotGridDataSource.state();
}
}
@NgModule({
imports: [
BrowserModule,
DxPivotGridModule,
DxRadioGroupModule,
DxPivotGridFieldChooserModule,
DxSelectBoxModule,
DxButtonModule
],
declarations: [AppComponent],
bootstrap: [AppComponent]
})
export class AppModule { }
platformBrowserDynamic().bootstrapModule(AppModule);
::ng-deep .container {
position: relative;
margin-top: 20px;
}
::ng-deep .options {
padding: 20px;
background-color: rgba(191, 191, 191, 0.15);
position: absolute;
top: 29px;
bottom: 5px;
left: 420px;
width: 180px;
}
::ng-deep .caption {
font-size: 18px;
font-weight: 500;
}
::ng-deep .option {
margin-top: 10px;
}
::ng-deep .bottom-bar {
width: 396px;
text-align: right;
margin-top: 5px;
}
::ng-deep #applyButton {
margin-right: 10px;
}
::ng-deep .option-editor {
margin-top: 5px;
}
import { Injectable } from '@angular/core';
export class Sale {
orderId: number;
region: string;
country: string;
city: string;
amount: number;
date: string;
}
export class Layout {
key: number;
name: string;
}
let sales: Sale[] = [{
"orderId": 1,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 1740,
"date": "2013/01/06"
}, {
"orderId": 2,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 850,
"date": "2013/01/13"
}, {
"orderId": 3,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2235,
"date": "2013/01/07"
}, {
"orderId": 4,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1965,
"date": "2013/01/03"
}, {
"orderId": 5,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 880,
"date": "2013/01/10"
}, {
"orderId": 6,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 5260,
"date": "2013/01/17"
}, {
"orderId": 7,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 2790,
"date": "2013/01/21"
}, {
"orderId": 8,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 3140,
"date": "2013/01/01"
}, {
"orderId": 9,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 6175,
"date": "2013/01/24"
}, {
"orderId": 10,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 4575,
"date": "2013/01/11"
}, {
"orderId": 11,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 3680,
"date": "2013/01/12"
}, {
"orderId": 12,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 2260,
"date": "2013/01/01"
}, {
"orderId": 13,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 2910,
"date": "2013/01/26"
}, {
"orderId": 14,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 8400,
"date": "2013/01/05"
}, {
"orderId": 15,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 1325,
"date": "2013/01/14"
}, {
"orderId": 16,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 3920,
"date": "2013/01/05"
}, {
"orderId": 17,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2220,
"date": "2013/01/15"
}, {
"orderId": 18,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 940,
"date": "2013/01/01"
}, {
"orderId": 19,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1630,
"date": "2013/01/10"
}, {
"orderId": 20,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2910,
"date": "2013/01/23"
}, {
"orderId": 21,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 2600,
"date": "2013/01/14"
}, {
"orderId": 22,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 4340,
"date": "2013/01/26"
}, {
"orderId": 23,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 6650,
"date": "2013/01/24"
}, {
"orderId": 24,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 490,
"date": "2013/01/22"
}, {
"orderId": 25,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 3390,
"date": "2013/01/25"
}, {
"orderId": 26,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 5160,
"date": "2013/02/20"
}, {
"orderId": 27,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 5750,
"date": "2013/02/12"
}, {
"orderId": 28,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2805,
"date": "2013/02/13"
}, {
"orderId": 29,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2505,
"date": "2013/02/09"
}, {
"orderId": 30,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 930,
"date": "2013/02/04"
}, {
"orderId": 31,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 1240,
"date": "2013/02/03"
}, {
"orderId": 32,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 315,
"date": "2013/02/04"
}, {
"orderId": 33,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2870,
"date": "2013/02/18"
}, {
"orderId": 34,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 5150,
"date": "2013/02/18"
}, {
"orderId": 35,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 2725,
"date": "2013/02/20"
}, {
"orderId": 36,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 2840,
"date": "2013/02/04"
}, {
"orderId": 37,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5840,
"date": "2013/02/13"
}, {
"orderId": 38,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 6750,
"date": "2013/02/11"
}, {
"orderId": 39,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 1200,
"date": "2013/02/03"
}, {
"orderId": 40,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 4550,
"date": "2013/02/08"
}, {
"orderId": 41,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 6040,
"date": "2013/02/17"
}, {
"orderId": 42,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2205,
"date": "2013/02/08"
}, {
"orderId": 43,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 990,
"date": "2013/02/20"
}, {
"orderId": 44,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 700,
"date": "2013/02/11"
}, {
"orderId": 45,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2325,
"date": "2013/02/15"
}, {
"orderId": 46,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 930,
"date": "2013/02/21"
}, {
"orderId": 47,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1560,
"date": "2013/02/04"
}, {
"orderId": 48,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 1740,
"date": "2013/03/04"
}, {
"orderId": 49,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 3575,
"date": "2013/03/20"
}, {
"orderId": 50,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 4500,
"date": "2013/03/04"
}, {
"orderId": 51,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1605,
"date": "2013/03/17"
}, {
"orderId": 52,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 800,
"date": "2013/03/21"
}, {
"orderId": 53,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 640,
"date": "2013/03/08"
}, {
"orderId": 54,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 735,
"date": "2013/03/19"
}, {
"orderId": 55,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2520,
"date": "2013/03/20"
}, {
"orderId": 56,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 6675,
"date": "2013/03/18"
}, {
"orderId": 57,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 3625,
"date": "2013/03/25"
}, {
"orderId": 58,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 1200,
"date": "2013/03/07"
}, {
"orderId": 59,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 2000,
"date": "2013/03/07"
}, {
"orderId": 60,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 1410,
"date": "2013/03/10"
}, {
"orderId": 61,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 2700,
"date": "2013/03/19"
}, {
"orderId": 62,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 5950,
"date": "2013/03/24"
}, {
"orderId": 63,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 5120,
"date": "2013/03/08"
}, {
"orderId": 64,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1980,
"date": "2013/03/17"
}, {
"orderId": 65,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1110,
"date": "2013/03/08"
}, {
"orderId": 66,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 980,
"date": "2013/03/21"
}, {
"orderId": 67,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 5460,
"date": "2013/03/19"
}, {
"orderId": 68,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 3800,
"date": "2013/03/12"
}, {
"orderId": 69,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2610,
"date": "2013/03/04"
}, {
"orderId": 70,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 3080,
"date": "2013/03/22"
}, {
"orderId": 71,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 2010,
"date": "2013/03/23"
}, {
"orderId": 72,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 1200,
"date": "2013/03/04"
}, {
"orderId": 73,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 7680,
"date": "2013/04/15"
}, {
"orderId": 74,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 1325,
"date": "2013/04/07"
}, {
"orderId": 75,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2835,
"date": "2013/04/10"
}, {
"orderId": 76,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 3660,
"date": "2013/04/10"
}, {
"orderId": 77,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 390,
"date": "2013/04/12"
}, {
"orderId": 78,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 4420,
"date": "2013/04/08"
}, {
"orderId": 79,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1755,
"date": "2013/04/13"
}, {
"orderId": 80,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2580,
"date": "2013/04/15"
}, {
"orderId": 81,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 850,
"date": "2013/04/01"
}, {
"orderId": 82,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 2825,
"date": "2013/04/10"
}, {
"orderId": 83,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 540,
"date": "2013/04/06"
}, {
"orderId": 84,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1520,
"date": "2013/04/08"
}, {
"orderId": 85,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 8760,
"date": "2013/04/26"
}, {
"orderId": 86,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 1110,
"date": "2013/04/16"
}, {
"orderId": 87,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 6850,
"date": "2013/04/19"
}, {
"orderId": 88,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 1940,
"date": "2013/04/23"
}, {
"orderId": 89,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1980,
"date": "2013/04/21"
}, {
"orderId": 90,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 3090,
"date": "2013/04/03"
}, {
"orderId": 91,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1640,
"date": "2013/04/24"
}, {
"orderId": 92,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3585,
"date": "2013/04/01"
}, {
"orderId": 93,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1770,
"date": "2013/04/01"
}, {
"orderId": 94,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4005,
"date": "2013/04/04"
}, {
"orderId": 95,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2870,
"date": "2013/04/02"
}, {
"orderId": 96,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 960,
"date": "2013/04/20"
}, {
"orderId": 97,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 8640,
"date": "2013/05/14"
}, {
"orderId": 98,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 5450,
"date": "2013/05/24"
}, {
"orderId": 99,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2535,
"date": "2013/05/07"
}, {
"orderId": 100,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1155,
"date": "2013/05/20"
}, {
"orderId": 101,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 3140,
"date": "2013/05/18"
}, {
"orderId": 102,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 2260,
"date": "2013/05/19"
}, {
"orderId": 103,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1215,
"date": "2013/05/23"
}, {
"orderId": 104,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1210,
"date": "2013/05/08"
}, {
"orderId": 105,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 875,
"date": "2013/05/25"
}, {
"orderId": 106,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5400,
"date": "2013/05/03"
}, {
"orderId": 107,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 5940,
"date": "2013/05/25"
}, {
"orderId": 108,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 4700,
"date": "2013/05/03"
}, {
"orderId": 109,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 5520,
"date": "2013/05/12"
}, {
"orderId": 110,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 9210,
"date": "2013/05/22"
}, {
"orderId": 111,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 7950,
"date": "2013/05/12"
}, {
"orderId": 112,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 3740,
"date": "2013/05/24"
}, {
"orderId": 113,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 990,
"date": "2013/05/02"
}, {
"orderId": 114,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 3190,
"date": "2013/05/03"
}, {
"orderId": 115,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 2430,
"date": "2013/05/11"
}, {
"orderId": 116,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 7380,
"date": "2013/06/15"
}, {
"orderId": 117,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 4475,
"date": "2013/06/08"
}, {
"orderId": 118,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 1290,
"date": "2013/06/10"
}, {
"orderId": 119,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2250,
"date": "2013/06/10"
}, {
"orderId": 120,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 350,
"date": "2013/06/22"
}, {
"orderId": 121,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 5480,
"date": "2013/06/24"
}, {
"orderId": 122,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 2355,
"date": "2013/06/10"
}, {
"orderId": 123,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1960,
"date": "2013/06/23"
}, {
"orderId": 124,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 4125,
"date": "2013/06/06"
}, {
"orderId": 125,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 7925,
"date": "2013/06/12"
}, {
"orderId": 126,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 1120,
"date": "2013/06/22"
}, {
"orderId": 127,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5100,
"date": "2013/06/01"
}, {
"orderId": 128,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 1500,
"date": "2013/06/25"
}, {
"orderId": 129,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 5130,
"date": "2013/06/10"
}, {
"orderId": 130,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 2475,
"date": "2013/06/10"
}, {
"orderId": 131,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 2100,
"date": "2013/06/06"
}, {
"orderId": 132,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3570,
"date": "2013/06/10"
}, {
"orderId": 133,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 550,
"date": "2013/06/02"
}, {
"orderId": 134,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 2850,
"date": "2013/06/26"
}, {
"orderId": 135,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 4280,
"date": "2013/06/19"
}, {
"orderId": 136,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 1460,
"date": "2013/06/17"
}, {
"orderId": 137,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 960,
"date": "2013/06/17"
}, {
"orderId": 138,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1520,
"date": "2013/06/03"
}, {
"orderId": 139,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 6750,
"date": "2013/06/21"
}, {
"orderId": 140,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 7260,
"date": "2013/07/14"
}, {
"orderId": 141,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 2450,
"date": "2013/07/11"
}, {
"orderId": 142,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 3540,
"date": "2013/07/02"
}, {
"orderId": 143,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1950,
"date": "2013/07/03"
}, {
"orderId": 144,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 360,
"date": "2013/07/07"
}, {
"orderId": 145,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 4500,
"date": "2013/07/03"
}, {
"orderId": 146,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4575,
"date": "2013/07/21"
}, {
"orderId": 147,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2310,
"date": "2013/07/18"
}, {
"orderId": 148,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 7500,
"date": "2013/07/04"
}, {
"orderId": 149,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 3575,
"date": "2013/07/23"
}, {
"orderId": 150,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 760,
"date": "2013/07/01"
}, {
"orderId": 151,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 2400,
"date": "2013/07/11"
}, {
"orderId": 152,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 3330,
"date": "2013/07/04"
}, {
"orderId": 153,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 3480,
"date": "2013/07/23"
}, {
"orderId": 154,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 4875,
"date": "2013/07/11"
}, {
"orderId": 155,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4980,
"date": "2013/07/19"
}, {
"orderId": 156,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2580,
"date": "2013/07/04"
}, {
"orderId": 157,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2650,
"date": "2013/07/16"
}, {
"orderId": 158,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1190,
"date": "2013/07/02"
}, {
"orderId": 159,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 960,
"date": "2013/07/26"
}, {
"orderId": 160,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 3600,
"date": "2013/08/08"
}, {
"orderId": 161,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 2250,
"date": "2013/08/01"
}, {
"orderId": 162,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 1275,
"date": "2013/08/02"
}, {
"orderId": 163,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 3885,
"date": "2013/08/14"
}, {
"orderId": 164,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1900,
"date": "2013/08/05"
}, {
"orderId": 165,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 2300,
"date": "2013/08/09"
}, {
"orderId": 166,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 2895,
"date": "2013/08/15"
}, {
"orderId": 167,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 350,
"date": "2013/08/20"
}, {
"orderId": 168,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 4200,
"date": "2013/08/22"
}, {
"orderId": 169,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 7175,
"date": "2013/08/14"
}, {
"orderId": 170,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 4420,
"date": "2013/08/24"
}, {
"orderId": 171,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5200,
"date": "2013/08/21"
}, {
"orderId": 172,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 7920,
"date": "2013/08/17"
}, {
"orderId": 173,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 6990,
"date": "2013/08/22"
}, {
"orderId": 174,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 2125,
"date": "2013/08/05"
}, {
"orderId": 175,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 2220,
"date": "2013/08/16"
}, {
"orderId": 176,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1575,
"date": "2013/08/23"
}, {
"orderId": 177,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1880,
"date": "2013/08/12"
}, {
"orderId": 178,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 710,
"date": "2013/08/25"
}, {
"orderId": 179,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 390,
"date": "2013/08/20"
}, {
"orderId": 180,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4635,
"date": "2013/08/04"
}, {
"orderId": 181,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 4350,
"date": "2013/08/19"
}, {
"orderId": 182,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 6020,
"date": "2013/08/02"
}, {
"orderId": 183,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 3660,
"date": "2013/08/19"
}, {
"orderId": 184,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 4525,
"date": "2013/08/24"
}, {
"orderId": 185,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 4410,
"date": "2013/09/12"
}, {
"orderId": 186,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 1725,
"date": "2013/09/07"
}, {
"orderId": 187,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2715,
"date": "2013/09/14"
}, {
"orderId": 188,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2820,
"date": "2013/09/08"
}, {
"orderId": 189,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2310,
"date": "2013/09/12"
}, {
"orderId": 190,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 780,
"date": "2013/09/08"
}, {
"orderId": 191,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 2370,
"date": "2013/09/19"
}, {
"orderId": 192,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1410,
"date": "2013/09/09"
}, {
"orderId": 193,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 1825,
"date": "2013/09/23"
}, {
"orderId": 194,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 4075,
"date": "2013/09/06"
}, {
"orderId": 195,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 1020,
"date": "2013/09/04"
}, {
"orderId": 196,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 4320,
"date": "2013/09/25"
}, {
"orderId": 197,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 7530,
"date": "2013/09/13"
}, {
"orderId": 198,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 2820,
"date": "2013/09/08"
}, {
"orderId": 199,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 3050,
"date": "2013/09/04"
}, {
"orderId": 200,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 5080,
"date": "2013/09/25"
}, {
"orderId": 201,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1125,
"date": "2013/09/13"
}, {
"orderId": 202,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 850,
"date": "2013/09/24"
}, {
"orderId": 203,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1440,
"date": "2013/09/19"
}, {
"orderId": 204,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1950,
"date": "2013/09/02"
}, {
"orderId": 205,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 6390,
"date": "2013/10/11"
}, {
"orderId": 206,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 4625,
"date": "2013/10/02"
}, {
"orderId": 207,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 3510,
"date": "2013/10/24"
}, {
"orderId": 208,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2730,
"date": "2013/10/15"
}, {
"orderId": 209,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2070,
"date": "2013/10/15"
}, {
"orderId": 210,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 2320,
"date": "2013/10/18"
}, {
"orderId": 211,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4260,
"date": "2013/10/24"
}, {
"orderId": 212,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 840,
"date": "2013/10/18"
}, {
"orderId": 213,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 7300,
"date": "2013/10/24"
}, {
"orderId": 214,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5950,
"date": "2013/10/11"
}, {
"orderId": 215,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 3220,
"date": "2013/10/25"
}, {
"orderId": 216,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 3480,
"date": "2013/10/08"
}, {
"orderId": 217,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 4830,
"date": "2013/10/26"
}, {
"orderId": 218,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 4470,
"date": "2013/10/05"
}, {
"orderId": 219,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 3675,
"date": "2013/10/23"
}, {
"orderId": 220,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4260,
"date": "2013/10/01"
}, {
"orderId": 221,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4245,
"date": "2013/10/26"
}, {
"orderId": 222,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1470,
"date": "2013/10/01"
}, {
"orderId": 223,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1810,
"date": "2013/10/02"
}, {
"orderId": 224,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 600,
"date": "2013/10/23"
}, {
"orderId": 225,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 7500,
"date": "2013/11/03"
}, {
"orderId": 226,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 4625,
"date": "2013/11/02"
}, {
"orderId": 227,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2625,
"date": "2013/11/09"
}, {
"orderId": 228,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1440,
"date": "2013/11/15"
}, {
"orderId": 229,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2420,
"date": "2013/11/15"
}, {
"orderId": 230,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 4180,
"date": "2013/11/15"
}, {
"orderId": 231,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 3720,
"date": "2013/11/25"
}, {
"orderId": 232,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2730,
"date": "2013/11/08"
}, {
"orderId": 233,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 3775,
"date": "2013/11/17"
}, {
"orderId": 234,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 3525,
"date": "2013/11/15"
}, {
"orderId": 235,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 5320,
"date": "2013/11/08"
}, {
"orderId": 236,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5340,
"date": "2013/11/13"
}, {
"orderId": 237,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 8850,
"date": "2013/11/01"
}, {
"orderId": 238,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 7050,
"date": "2013/11/14"
}, {
"orderId": 239,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 4200,
"date": "2013/11/18"
}, {
"orderId": 240,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4960,
"date": "2013/11/04"
}, {
"orderId": 241,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2280,
"date": "2013/11/13"
}, {
"orderId": 242,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 590,
"date": "2013/11/11"
}, {
"orderId": 243,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 810,
"date": "2013/11/12"
}, {
"orderId": 244,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 2625,
"date": "2013/11/07"
}, {
"orderId": 245,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 8280,
"date": "2013/12/01"
}, {
"orderId": 246,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 5650,
"date": "2013/12/19"
}, {
"orderId": 247,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2760,
"date": "2013/12/14"
}, {
"orderId": 248,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2670,
"date": "2013/12/03"
}, {
"orderId": 249,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2520,
"date": "2013/12/20"
}, {
"orderId": 250,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 4080,
"date": "2013/12/21"
}, {
"orderId": 251,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4140,
"date": "2013/12/22"
}, {
"orderId": 252,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 390,
"date": "2013/12/04"
}, {
"orderId": 253,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 1400,
"date": "2013/12/19"
}, {
"orderId": 254,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 7275,
"date": "2013/12/22"
}, {
"orderId": 255,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 4100,
"date": "2013/12/20"
}, {
"orderId": 256,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5520,
"date": "2013/12/25"
}, {
"orderId": 257,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 9210,
"date": "2013/12/24"
}, {
"orderId": 258,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 7290,
"date": "2013/12/05"
}, {
"orderId": 259,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 625,
"date": "2013/12/22"
}, {
"orderId": 260,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4460,
"date": "2013/12/12"
}, {
"orderId": 261,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3825,
"date": "2013/12/13"
}, {
"orderId": 262,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2850,
"date": "2013/12/17"
}, {
"orderId": 263,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 2780,
"date": "2013/12/07"
}, {
"orderId": 264,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 840,
"date": "2013/12/18"
}, {
"orderId": 265,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2970,
"date": "2013/12/23"
}, {
"orderId": 266,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 945,
"date": "2013/12/06"
}, {
"orderId": 267,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2625,
"date": "2013/12/04"
}, {
"orderId": 268,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 390,
"date": "2013/12/01"
}, {
"orderId": 269,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 2250,
"date": "2013/12/02"
}, {
"orderId": 270,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 7710,
"date": "2014/01/18"
}, {
"orderId": 271,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 7975,
"date": "2014/01/10"
}, {
"orderId": 272,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 3285,
"date": "2014/01/13"
}, {
"orderId": 273,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2580,
"date": "2014/01/22"
}, {
"orderId": 274,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2160,
"date": "2014/01/26"
}, {
"orderId": 275,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 1100,
"date": "2014/01/25"
}, {
"orderId": 276,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4425,
"date": "2014/01/21"
}, {
"orderId": 277,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1360,
"date": "2014/01/22"
}, {
"orderId": 278,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 3250,
"date": "2014/01/14"
}, {
"orderId": 279,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5550,
"date": "2014/01/21"
}, {
"orderId": 280,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 2860,
"date": "2014/01/25"
}, {
"orderId": 281,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5320,
"date": "2014/01/08"
}, {
"orderId": 282,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 4050,
"date": "2014/01/14"
}, {
"orderId": 283,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 3450,
"date": "2014/01/24"
}, {
"orderId": 284,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 5425,
"date": "2014/01/11"
}, {
"orderId": 285,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4860,
"date": "2014/01/12"
}, {
"orderId": 286,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4695,
"date": "2014/01/16"
}, {
"orderId": 287,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 610,
"date": "2014/01/05"
}, {
"orderId": 288,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1580,
"date": "2014/01/15"
}, {
"orderId": 289,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 3780,
"date": "2014/02/18"
}, {
"orderId": 290,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 5400,
"date": "2014/02/21"
}, {
"orderId": 291,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 630,
"date": "2014/02/18"
}, {
"orderId": 292,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 3960,
"date": "2014/02/04"
}, {
"orderId": 293,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2010,
"date": "2014/02/25"
}, {
"orderId": 294,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 5000,
"date": "2014/02/01"
}, {
"orderId": 295,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1995,
"date": "2014/02/20"
}, {
"orderId": 296,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 860,
"date": "2014/02/12"
}, {
"orderId": 297,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 2150,
"date": "2014/02/10"
}, {
"orderId": 298,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 4050,
"date": "2014/02/06"
}, {
"orderId": 299,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 2960,
"date": "2014/02/18"
}, {
"orderId": 300,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1780,
"date": "2014/02/26"
}, {
"orderId": 301,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 8700,
"date": "2014/02/03"
}, {
"orderId": 302,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 3390,
"date": "2014/02/03"
}, {
"orderId": 303,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 4425,
"date": "2014/02/15"
}, {
"orderId": 304,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 1180,
"date": "2014/02/23"
}, {
"orderId": 305,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 360,
"date": "2014/02/08"
}, {
"orderId": 306,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2310,
"date": "2014/02/13"
}, {
"orderId": 307,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1770,
"date": "2014/02/20"
}, {
"orderId": 308,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 3060,
"date": "2014/02/26"
}, {
"orderId": 309,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1750,
"date": "2014/02/12"
}, {
"orderId": 310,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 2280,
"date": "2014/03/09"
}, {
"orderId": 311,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 7600,
"date": "2014/03/25"
}, {
"orderId": 312,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 1035,
"date": "2014/03/23"
}, {
"orderId": 313,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1245,
"date": "2014/03/01"
}, {
"orderId": 314,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2860,
"date": "2014/03/19"
}, {
"orderId": 315,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 440,
"date": "2014/03/19"
}, {
"orderId": 316,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4665,
"date": "2014/03/02"
}, {
"orderId": 317,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2270,
"date": "2014/03/15"
}, {
"orderId": 318,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 5000,
"date": "2014/03/09"
}, {
"orderId": 319,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5100,
"date": "2014/03/23"
}, {
"orderId": 320,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 2120,
"date": "2014/03/11"
}, {
"orderId": 321,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5140,
"date": "2014/03/05"
}, {
"orderId": 322,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 6210,
"date": "2014/03/19"
}, {
"orderId": 323,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 9510,
"date": "2014/03/19"
}, {
"orderId": 324,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 7600,
"date": "2014/03/21"
}, {
"orderId": 325,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 5420,
"date": "2014/03/15"
}, {
"orderId": 326,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1980,
"date": "2014/03/05"
}, {
"orderId": 327,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1820,
"date": "2014/03/07"
}, {
"orderId": 328,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1670,
"date": "2014/03/21"
}, {
"orderId": 329,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 4800,
"date": "2014/03/08"
}, {
"orderId": 330,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2925,
"date": "2014/03/03"
}, {
"orderId": 331,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 2940,
"date": "2014/04/11"
}, {
"orderId": 332,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 3525,
"date": "2014/04/13"
}, {
"orderId": 333,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2475,
"date": "2014/04/22"
}, {
"orderId": 334,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 3315,
"date": "2014/04/08"
}, {
"orderId": 335,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 3140,
"date": "2014/04/07"
}, {
"orderId": 336,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 2520,
"date": "2014/04/01"
}, {
"orderId": 337,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1200,
"date": "2014/04/10"
}, {
"orderId": 338,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2060,
"date": "2014/04/21"
}, {
"orderId": 339,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 7875,
"date": "2014/04/02"
}, {
"orderId": 340,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 1450,
"date": "2014/04/07"
}, {
"orderId": 341,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 2640,
"date": "2014/04/22"
}, {
"orderId": 342,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1960,
"date": "2014/04/16"
}, {
"orderId": 343,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 2250,
"date": "2014/04/23"
}, {
"orderId": 344,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 4500,
"date": "2014/04/05"
}, {
"orderId": 345,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 5050,
"date": "2014/04/11"
}, {
"orderId": 346,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 2940,
"date": "2014/04/02"
}, {
"orderId": 347,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2880,
"date": "2014/04/14"
}, {
"orderId": 348,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1050,
"date": "2014/04/19"
}, {
"orderId": 349,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1850,
"date": "2014/04/02"
}, {
"orderId": 350,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 3160,
"date": "2014/04/01"
}, {
"orderId": 351,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 875,
"date": "2014/04/04"
}, {
"orderId": 352,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 3200,
"date": "2014/04/08"
}, {
"orderId": 353,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1380,
"date": "2014/04/21"
}, {
"orderId": 354,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 3060,
"date": "2014/04/06"
}, {
"orderId": 355,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 6690,
"date": "2014/05/19"
}, {
"orderId": 356,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 4525,
"date": "2014/05/15"
}, {
"orderId": 357,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 4665,
"date": "2014/05/10"
}, {
"orderId": 358,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 4530,
"date": "2014/05/18"
}, {
"orderId": 359,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1330,
"date": "2014/05/08"
}, {
"orderId": 360,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 1720,
"date": "2014/05/20"
}, {
"orderId": 361,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 3750,
"date": "2014/05/16"
}, {
"orderId": 362,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1290,
"date": "2014/05/10"
}, {
"orderId": 363,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 4925,
"date": "2014/05/14"
}, {
"orderId": 364,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 4300,
"date": "2014/05/22"
}, {
"orderId": 365,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 5740,
"date": "2014/05/08"
}, {
"orderId": 366,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 3760,
"date": "2014/05/18"
}, {
"orderId": 367,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 7920,
"date": "2014/05/22"
}, {
"orderId": 368,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 1440,
"date": "2014/05/21"
}, {
"orderId": 369,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 5975,
"date": "2014/05/25"
}, {
"orderId": 370,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4440,
"date": "2014/05/05"
}, {
"orderId": 371,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2310,
"date": "2014/05/24"
}, {
"orderId": 372,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2250,
"date": "2014/05/06"
}, {
"orderId": 373,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 2320,
"date": "2014/05/14"
}, {
"orderId": 374,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 8370,
"date": "2014/05/06"
}, {
"orderId": 375,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 5190,
"date": "2014/06/26"
}, {
"orderId": 376,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 925,
"date": "2014/06/04"
}, {
"orderId": 377,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 3240,
"date": "2014/06/20"
}, {
"orderId": 378,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 3180,
"date": "2014/06/23"
}, {
"orderId": 379,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 780,
"date": "2014/06/13"
}, {
"orderId": 380,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 4680,
"date": "2014/06/08"
}, {
"orderId": 381,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 2475,
"date": "2014/06/25"
}, {
"orderId": 382,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1920,
"date": "2014/06/20"
}, {
"orderId": 383,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 7500,
"date": "2014/06/25"
}, {
"orderId": 384,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5025,
"date": "2014/06/26"
}, {
"orderId": 385,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 2400,
"date": "2014/06/08"
}, {
"orderId": 386,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1720,
"date": "2014/06/09"
}, {
"orderId": 387,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 2880,
"date": "2014/06/21"
}, {
"orderId": 388,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 5430,
"date": "2014/06/03"
}, {
"orderId": 389,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 4475,
"date": "2014/06/19"
}, {
"orderId": 390,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 1420,
"date": "2014/06/20"
}, {
"orderId": 391,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2670,
"date": "2014/06/25"
}, {
"orderId": 392,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1930,
"date": "2014/06/02"
}, {
"orderId": 393,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 580,
"date": "2014/06/25"
}, {
"orderId": 394,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1620,
"date": "2014/06/12"
}, {
"orderId": 395,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4530,
"date": "2014/06/02"
}, {
"orderId": 396,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 6025,
"date": "2014/06/23"
}, {
"orderId": 397,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 3540,
"date": "2014/07/21"
}, {
"orderId": 398,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 3000,
"date": "2014/07/01"
}, {
"orderId": 399,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 3240,
"date": "2014/07/26"
}, {
"orderId": 400,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2265,
"date": "2014/07/22"
}, {
"orderId": 401,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 400,
"date": "2014/07/09"
}, {
"orderId": 402,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 1460,
"date": "2014/07/08"
}, {
"orderId": 403,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1620,
"date": "2014/07/18"
}, {
"orderId": 404,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2400,
"date": "2014/07/25"
}, {
"orderId": 405,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 5275,
"date": "2014/07/04"
}, {
"orderId": 406,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 4475,
"date": "2014/07/03"
}, {
"orderId": 407,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 3980,
"date": "2014/07/21"
}, {
"orderId": 408,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 5240,
"date": "2014/07/11"
}, {
"orderId": 409,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 1200,
"date": "2014/07/21"
}, {
"orderId": 410,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 5700,
"date": "2014/07/18"
}, {
"orderId": 411,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 5575,
"date": "2014/07/01"
}, {
"orderId": 412,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 2160,
"date": "2014/07/02"
}, {
"orderId": 413,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 960,
"date": "2014/07/09"
}, {
"orderId": 414,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1280,
"date": "2014/07/04"
}, {
"orderId": 415,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1040,
"date": "2014/07/02"
}, {
"orderId": 416,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 5520,
"date": "2014/07/21"
}, {
"orderId": 417,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1760,
"date": "2014/07/25"
}, {
"orderId": 418,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 4080,
"date": "2014/07/07"
}, {
"orderId": 419,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1000,
"date": "2014/07/21"
}, {
"orderId": 420,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 3270,
"date": "2014/07/12"
}, {
"orderId": 421,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 1770,
"date": "2014/08/23"
}, {
"orderId": 422,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 2700,
"date": "2014/08/09"
}, {
"orderId": 423,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2175,
"date": "2014/08/03"
}, {
"orderId": 424,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 3375,
"date": "2014/08/11"
}, {
"orderId": 425,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2040,
"date": "2014/08/01"
}, {
"orderId": 426,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 3000,
"date": "2014/08/21"
}, {
"orderId": 427,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 3900,
"date": "2014/08/16"
}, {
"orderId": 428,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1370,
"date": "2014/08/20"
}, {
"orderId": 429,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 5700,
"date": "2014/08/01"
}, {
"orderId": 430,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 1275,
"date": "2014/08/22"
}, {
"orderId": 431,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 4060,
"date": "2014/08/13"
}, {
"orderId": 432,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 2320,
"date": "2014/08/18"
}, {
"orderId": 433,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 7590,
"date": "2014/08/24"
}, {
"orderId": 434,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 4560,
"date": "2014/08/20"
}, {
"orderId": 435,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 7575,
"date": "2014/08/20"
}, {
"orderId": 436,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 700,
"date": "2014/08/25"
}, {
"orderId": 437,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2400,
"date": "2014/08/16"
}, {
"orderId": 438,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1390,
"date": "2014/08/15"
}, {
"orderId": 439,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1320,
"date": "2014/08/09"
}, {
"orderId": 440,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 1680,
"date": "2014/08/09"
}, {
"orderId": 441,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1500,
"date": "2014/08/11"
}, {
"orderId": 442,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 6150,
"date": "2014/09/21"
}, {
"orderId": 443,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 3675,
"date": "2014/09/02"
}, {
"orderId": 444,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 2250,
"date": "2014/09/05"
}, {
"orderId": 445,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 3585,
"date": "2014/09/10"
}, {
"orderId": 446,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1470,
"date": "2014/09/01"
}, {
"orderId": 447,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 2260,
"date": "2014/09/02"
}, {
"orderId": 448,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 3765,
"date": "2014/09/03"
}, {
"orderId": 449,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1640,
"date": "2014/09/04"
}, {
"orderId": 450,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 4475,
"date": "2014/09/09"
}, {
"orderId": 451,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5975,
"date": "2014/09/04"
}, {
"orderId": 452,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 1100,
"date": "2014/09/16"
}, {
"orderId": 453,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1320,
"date": "2014/09/18"
}, {
"orderId": 454,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 8610,
"date": "2014/09/19"
}, {
"orderId": 455,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 9210,
"date": "2014/09/09"
}, {
"orderId": 456,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 3700,
"date": "2014/09/01"
}, {
"orderId": 457,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 3620,
"date": "2014/09/19"
}, {
"orderId": 458,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4275,
"date": "2014/09/01"
}, {
"orderId": 459,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2370,
"date": "2014/09/03"
}, {
"orderId": 460,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1870,
"date": "2014/09/10"
}, {
"orderId": 461,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2070,
"date": "2014/09/25"
}, {
"orderId": 462,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5025,
"date": "2014/09/19"
}, {
"orderId": 463,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 1080,
"date": "2014/10/15"
}, {
"orderId": 464,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 1400,
"date": "2014/10/22"
}, {
"orderId": 465,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 4260,
"date": "2014/10/01"
}, {
"orderId": 466,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 2745,
"date": "2014/10/01"
}, {
"orderId": 467,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2920,
"date": "2014/10/23"
}, {
"orderId": 468,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 3520,
"date": "2014/10/11"
}, {
"orderId": 469,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4035,
"date": "2014/10/20"
}, {
"orderId": 470,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1730,
"date": "2014/10/05"
}, {
"orderId": 471,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 975,
"date": "2014/10/06"
}, {
"orderId": 472,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5700,
"date": "2014/10/06"
}, {
"orderId": 473,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 5080,
"date": "2014/10/18"
}, {
"orderId": 474,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 2940,
"date": "2014/10/24"
}, {
"orderId": 475,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 2670,
"date": "2014/10/04"
}, {
"orderId": 476,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 1230,
"date": "2014/10/11"
}, {
"orderId": 477,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 600,
"date": "2014/10/08"
}, {
"orderId": 478,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 3700,
"date": "2014/10/08"
}, {
"orderId": 479,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3375,
"date": "2014/10/11"
}, {
"orderId": 480,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1500,
"date": "2014/10/17"
}, {
"orderId": 481,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 370,
"date": "2014/10/05"
}, {
"orderId": 482,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2340,
"date": "2014/10/16"
}, {
"orderId": 483,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 1080,
"date": "2014/10/08"
}, {
"orderId": 484,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 2775,
"date": "2014/10/21"
}, {
"orderId": 485,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 4380,
"date": "2014/11/09"
}, {
"orderId": 486,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 5500,
"date": "2014/11/21"
}, {
"orderId": 487,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 1920,
"date": "2014/11/24"
}, {
"orderId": 488,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 765,
"date": "2014/11/24"
}, {
"orderId": 489,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 370,
"date": "2014/11/18"
}, {
"orderId": 490,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 3500,
"date": "2014/11/25"
}, {
"orderId": 491,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 825,
"date": "2014/11/09"
}, {
"orderId": 492,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 490,
"date": "2014/11/23"
}, {
"orderId": 493,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 7075,
"date": "2014/11/20"
}, {
"orderId": 494,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 1350,
"date": "2014/11/25"
}, {
"orderId": 495,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 1440,
"date": "2014/11/15"
}, {
"orderId": 496,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 2820,
"date": "2014/11/13"
}, {
"orderId": 497,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 2280,
"date": "2014/11/12"
}, {
"orderId": 498,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 1110,
"date": "2014/11/03"
}, {
"orderId": 499,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 1150,
"date": "2014/11/23"
}, {
"orderId": 500,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 2040,
"date": "2014/11/20"
}, {
"orderId": 501,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3090,
"date": "2014/11/24"
}, {
"orderId": 502,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1940,
"date": "2014/11/24"
}, {
"orderId": 503,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 3090,
"date": "2014/11/16"
}, {
"orderId": 504,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 4900,
"date": "2014/11/05"
}, {
"orderId": 505,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 3465,
"date": "2014/11/07"
}, {
"orderId": 506,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1110,
"date": "2014/11/20"
}, {
"orderId": 507,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1650,
"date": "2014/11/02"
}, {
"orderId": 508,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 5280,
"date": "2014/12/04"
}, {
"orderId": 509,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 3075,
"date": "2014/12/02"
}, {
"orderId": 510,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 690,
"date": "2014/12/07"
}, {
"orderId": 511,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1305,
"date": "2014/12/15"
}, {
"orderId": 512,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1970,
"date": "2014/12/01"
}, {
"orderId": 513,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 3760,
"date": "2014/12/18"
}, {
"orderId": 514,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1920,
"date": "2014/12/22"
}, {
"orderId": 515,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1360,
"date": "2014/12/12"
}, {
"orderId": 516,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 2525,
"date": "2014/12/06"
}, {
"orderId": 517,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 5575,
"date": "2014/12/20"
}, {
"orderId": 518,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 5560,
"date": "2014/12/10"
}, {
"orderId": 519,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 4880,
"date": "2014/12/13"
}, {
"orderId": 520,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 8850,
"date": "2014/12/03"
}, {
"orderId": 521,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 2820,
"date": "2014/12/10"
}, {
"orderId": 522,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 4000,
"date": "2014/12/12"
}, {
"orderId": 523,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 5820,
"date": "2014/12/02"
}, {
"orderId": 524,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 1275,
"date": "2014/12/12"
}, {
"orderId": 525,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1310,
"date": "2014/12/01"
}, {
"orderId": 526,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 2180,
"date": "2014/12/26"
}, {
"orderId": 527,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4470,
"date": "2014/12/17"
}, {
"orderId": 528,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2990,
"date": "2014/12/15"
}, {
"orderId": 529,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 7650,
"date": "2014/12/18"
}, {
"orderId": 530,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 780,
"date": "2014/12/02"
}, {
"orderId": 531,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2970,
"date": "2014/12/13"
}, {
"orderId": 532,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1155,
"date": "2014/12/05"
}, {
"orderId": 533,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 4470,
"date": "2015/01/10"
}, {
"orderId": 534,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 1125,
"date": "2015/01/21"
}, {
"orderId": 535,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 645,
"date": "2015/01/17"
}, {
"orderId": 536,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 675,
"date": "2015/01/05"
}, {
"orderId": 537,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2840,
"date": "2015/01/05"
}, {
"orderId": 538,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 2660,
"date": "2015/01/04"
}, {
"orderId": 539,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4560,
"date": "2015/01/12"
}, {
"orderId": 540,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2880,
"date": "2015/01/20"
}, {
"orderId": 541,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 500,
"date": "2015/01/02"
}, {
"orderId": 542,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 3925,
"date": "2015/01/07"
}, {
"orderId": 543,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 5660,
"date": "2015/01/18"
}, {
"orderId": 544,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1460,
"date": "2015/01/22"
}, {
"orderId": 545,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 5040,
"date": "2015/01/10"
}, {
"orderId": 546,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 4830,
"date": "2015/01/13"
}, {
"orderId": 547,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 3075,
"date": "2015/01/22"
}, {
"orderId": 548,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 3120,
"date": "2015/01/14"
}, {
"orderId": 549,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3525,
"date": "2015/01/23"
}, {
"orderId": 550,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1930,
"date": "2015/01/09"
}, {
"orderId": 551,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 2890,
"date": "2015/01/02"
}, {
"orderId": 552,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 1545,
"date": "2015/01/17"
}, {
"orderId": 553,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3630,
"date": "2015/01/20"
}, {
"orderId": 554,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 4035,
"date": "2015/01/14"
}, {
"orderId": 555,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 345,
"date": "2015/01/06"
}, {
"orderId": 556,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 7000,
"date": "2015/01/07"
}, {
"orderId": 557,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 3060,
"date": "2015/02/13"
}, {
"orderId": 558,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 6425,
"date": "2015/02/04"
}, {
"orderId": 559,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 615,
"date": "2015/02/22"
}, {
"orderId": 560,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1755,
"date": "2015/02/07"
}, {
"orderId": 561,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1540,
"date": "2015/02/21"
}, {
"orderId": 562,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 2820,
"date": "2015/02/24"
}, {
"orderId": 563,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4305,
"date": "2015/02/10"
}, {
"orderId": 564,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 1520,
"date": "2015/02/26"
}, {
"orderId": 565,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 4725,
"date": "2015/02/18"
}, {
"orderId": 566,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 6750,
"date": "2015/02/16"
}, {
"orderId": 567,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 5540,
"date": "2015/02/07"
}, {
"orderId": 568,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1880,
"date": "2015/02/24"
}, {
"orderId": 569,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 6180,
"date": "2015/02/26"
}, {
"orderId": 570,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 9300,
"date": "2015/02/03"
}, {
"orderId": 571,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 3700,
"date": "2015/02/26"
}, {
"orderId": 572,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 740,
"date": "2015/02/01"
}, {
"orderId": 573,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4755,
"date": "2015/02/23"
}, {
"orderId": 574,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2570,
"date": "2015/02/20"
}, {
"orderId": 575,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 2860,
"date": "2015/02/19"
}, {
"orderId": 576,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 5430,
"date": "2015/03/21"
}, {
"orderId": 577,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 4525,
"date": "2015/03/21"
}, {
"orderId": 578,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 1515,
"date": "2015/03/10"
}, {
"orderId": 579,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 630,
"date": "2015/03/15"
}, {
"orderId": 580,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1310,
"date": "2015/03/01"
}, {
"orderId": 581,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 3200,
"date": "2015/03/17"
}, {
"orderId": 582,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 3945,
"date": "2015/03/20"
}, {
"orderId": 583,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2990,
"date": "2015/03/18"
}, {
"orderId": 584,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 1125,
"date": "2015/03/22"
}, {
"orderId": 585,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 7950,
"date": "2015/03/17"
}, {
"orderId": 586,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 2960,
"date": "2015/03/25"
}, {
"orderId": 587,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 6300,
"date": "2015/03/20"
}, {
"orderId": 588,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 8670,
"date": "2015/03/07"
}, {
"orderId": 589,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 3930,
"date": "2015/03/23"
}, {
"orderId": 590,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 6975,
"date": "2015/03/02"
}, {
"orderId": 591,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4220,
"date": "2015/03/17"
}, {
"orderId": 592,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 3090,
"date": "2015/03/25"
}, {
"orderId": 593,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2380,
"date": "2015/03/01"
}, {
"orderId": 594,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1510,
"date": "2015/03/07"
}, {
"orderId": 595,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 1020,
"date": "2015/03/19"
}, {
"orderId": 596,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 6700,
"date": "2015/03/26"
}, {
"orderId": 597,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 4890,
"date": "2015/04/02"
}, {
"orderId": 598,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 7225,
"date": "2015/04/13"
}, {
"orderId": 599,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 795,
"date": "2015/04/07"
}, {
"orderId": 600,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1785,
"date": "2015/04/03"
}, {
"orderId": 601,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1850,
"date": "2015/04/03"
}, {
"orderId": 602,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 5120,
"date": "2015/04/12"
}, {
"orderId": 603,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 615,
"date": "2015/04/07"
}, {
"orderId": 604,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2860,
"date": "2015/04/05"
}, {
"orderId": 605,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 1525,
"date": "2015/04/24"
}, {
"orderId": 606,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 7425,
"date": "2015/04/15"
}, {
"orderId": 607,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 6080,
"date": "2015/04/13"
}, {
"orderId": 608,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 2940,
"date": "2015/04/04"
}, {
"orderId": 609,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 5580,
"date": "2015/04/16"
}, {
"orderId": 610,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 9390,
"date": "2015/04/19"
}, {
"orderId": 611,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 3200,
"date": "2015/04/26"
}, {
"orderId": 612,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4380,
"date": "2015/04/05"
}, {
"orderId": 613,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 4725,
"date": "2015/04/06"
}, {
"orderId": 614,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 930,
"date": "2015/04/25"
}, {
"orderId": 615,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 1910,
"date": "2015/04/05"
}, {
"orderId": 616,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 2725,
"date": "2015/04/16"
}, {
"orderId": 617,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 4720,
"date": "2015/04/02"
}, {
"orderId": 618,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 5190,
"date": "2015/04/10"
}, {
"orderId": 619,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 2800,
"date": "2015/04/26"
}, {
"orderId": 620,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 3780,
"date": "2015/04/24"
}, {
"orderId": 621,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 2340,
"date": "2015/04/17"
}, {
"orderId": 622,
"region": "North America",
"country": "USA",
"city": "New York",
"amount": 4830,
"date": "2015/05/12"
}, {
"orderId": 623,
"region": "North America",
"country": "USA",
"city": "Los Angeles",
"amount": 2075,
"date": "2015/05/23"
}, {
"orderId": 624,
"region": "North America",
"country": "USA",
"city": "Denver",
"amount": 3420,
"date": "2015/05/21"
}, {
"orderId": 625,
"region": "North America",
"country": "CAN",
"city": "Vancouver",
"amount": 1440,
"date": "2015/05/10"
}, {
"orderId": 626,
"region": "North America",
"country": "CAN",
"city": "Edmonton",
"amount": 1680,
"date": "2015/05/15"
}, {
"orderId": 627,
"region": "South America",
"country": "BRA",
"city": "Rio de Janeiro",
"amount": 3440,
"date": "2015/05/16"
}, {
"orderId": 628,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 4695,
"date": "2015/05/10"
}, {
"orderId": 629,
"region": "South America",
"country": "PRY",
"city": "Asuncion",
"amount": 2380,
"date": "2015/05/06"
}, {
"orderId": 630,
"region": "Europe",
"country": "GBR",
"city": "London",
"amount": 1875,
"date": "2015/05/25"
}, {
"orderId": 631,
"region": "Europe",
"country": "DEU",
"city": "Berlin",
"amount": 7550,
"date": "2015/05/14"
}, {
"orderId": 632,
"region": "Europe",
"country": "ESP",
"city": "Madrid",
"amount": 3340,
"date": "2015/05/01"
}, {
"orderId": 633,
"region": "Europe",
"country": "RUS",
"city": "Moscow",
"amount": 1400,
"date": "2015/05/22"
}, {
"orderId": 634,
"region": "Asia",
"country": "CHN",
"city": "Beijing",
"amount": 6060,
"date": "2015/05/22"
}, {
"orderId": 635,
"region": "Asia",
"country": "JPN",
"city": "Tokyo",
"amount": 8370,
"date": "2015/05/13"
}, {
"orderId": 636,
"region": "Asia",
"country": "KOR",
"city": "Seoul",
"amount": 3550,
"date": "2015/05/26"
}, {
"orderId": 637,
"region": "Australia",
"country": "AUS",
"city": "Sydney",
"amount": 2620,
"date": "2015/05/17"
}, {
"orderId": 638,
"region": "Australia",
"country": "AUS",
"city": "Melbourne",
"amount": 2400,
"date": "2015/05/21"
}, {
"orderId": 639,
"region": "Africa",
"country": "ZAF",
"city": "Pretoria",
"amount": 1740,
"date": "2015/05/21"
}, {
"orderId": 640,
"region": "Africa",
"country": "EGY",
"city": "Cairo",
"amount": 500,
"date": "2015/05/26"
}, {
"orderId": 641,
"region": "South America",
"country": "ARG",
"city": "Buenos Aires",
"amount": 780,
"date": "2015/05/07"
}];
let layouts:Layout[] = [{
key: 0,
name: "Layout0"
}, {
key: 1,
name: "Layout1"
}, {
key: 2,
name: "Layout2"
}];
@Injectable()
export class Service {
getSales() {
return sales;
}
getLayouts() {
return layouts;
}
}
// In real applications, you should not transpile code in the browser. You can see how to create your own application with Angular and DevExtreme here:
// https://js.devexpress.com/Documentation/Guide/Angular_Components/Getting_Started/Create_a_DevExtreme_Application/
window.config = {
transpiler: 'ts',
typescriptOptions: {
module: "system",
emitDecoratorMetadata: true,
experimentalDecorators: true
},
meta: {
'typescript': {
"exports": "ts"
},
'devextreme/localization.js': {
"esModule": true
},
},
paths: {
'npm:': 'https://unpkg.com/'
},
map: {
'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js',
'typescript': 'npm:typescript@3.5.3/lib/typescript.js',
'@angular': 'npm:@angular',
'tslib': 'npm:tslib@2.3.1/tslib.js',
'rxjs': 'npm:rxjs@6.4.0',
'rrule': 'npm:rrule@2.6.6/dist/es5/rrule.js',
'luxon': 'npm:luxon@1.28.0/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign@1.1.0',
'devextreme': 'npm:devextreme@21.1.6/cjs',
'devextreme/bundles/dx.all': 'npm:devextreme@21.1.6/bundles/dx.all.js',
'jszip': 'npm:jszip@3.7.1/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@1.4.2/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.1.32',
'devexpress-gantt': 'npm:devexpress-gantt@3.0.14',
'devextreme-angular': 'npm:devextreme-angular@21.1.6',
'@devextreme/vdom': 'npm:@devextreme/vdom@1.2.2',
'inferno': 'npm:inferno@7.4.10/dist/inferno.min.js',
'inferno-compat': 'npm:inferno-compat@7.4.10/dist/inferno-compat.min.js',
'inferno-create-element': 'npm:inferno-create-element@7.4.10/dist/inferno-create-element.min.js',
'inferno-dom': 'npm:inferno-dom@1.0.7/dist/inferno-dom.min.js',
'inferno-hydrate': 'npm:inferno-hydrate@7.4.10/dist/inferno-hydrate.min.js',
'inferno-clone-vnode': 'npm:inferno-clone-vnode@7.4.10/dist/inferno-clone-vnode.min.js',
'inferno-create-class': 'npm:inferno-create-class@7.4.10/dist/inferno-create-class.min.js',
'inferno-extras': 'npm:inferno-extras@7.4.10/dist/inferno-extras.min.js'
},
packages: {
'app': {
main: './app.component.ts',
defaultExtension: 'ts'
},
'devextreme': {
defaultExtension: 'js'
},
'@devextreme/vdom': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js'
}
},
packageConfigPaths: [
"npm:@devextreme/*/package.json",
"npm:@angular/*/package.json",
"npm:@angular/common/*/package.json",
"npm:rxjs/package.json",
"npm:rxjs/operators/package.json",
"npm:devextreme-angular/*/package.json",
"npm:devextreme-angular/ui/*/package.json",
"npm:devextreme-angular/package.json",
"npm:devexpress-diagram/package.json",
"npm:devexpress-gantt/package.json",
]
};
System.config(window.config);
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>DevExtreme Demo</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/21.1.6/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/21.1.6/css/dx.light.css" />
<script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script>
<script src="https://unpkg.com/zone.js@0.10.3/dist/zone.js"></script>
<script src="https://unpkg.com/reflect-metadata@0.1.3/Reflect.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script src="config.js"></script>
<script>
System.import('app').catch(console.error.bind(console));
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<demo-app>Loading...</demo-app>
</div>
</body>
</html>