Free Trial Buy
    Your search did not match any results.
    Pivot Grid

    Cell Customization

    Our PivotGrid allows you to control and manage the data export process. You can use the PivotGrid’s customizeCell callback to modify cell data and associated formatting prior to export operations (from the PivotGrid to an Excel file). Our PivotGrid gives you access and allows you to change the following attributes:

    The customizeCell function also allows you to identify cell area types.

    See more Hide details
    Prev Demo Next Demo

    jQuery

    Angular

    Vue

    React

    ASP.NET Core

    ASP.NET MVC

    Copy to CodeSandBox
    Apply
    Reset
    <dx-pivot-grid [allowSortingBySummary]="true" [allowSorting]="true" [allowFiltering]="true" [allowExpandAll]="true" [height]="490" [showBorders]="true" [dataSource]="dataSource" (onCellPrepared)="onCellPrepared($event)" (onExporting)="onExporting($event)"> <dxo-field-chooser [enabled]="false"></dxo-field-chooser> <dxo-export [enabled]="true"></dxo-export> </dx-pivot-grid>
    import { NgModule, Component, enableProdMode } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { DxPivotGridModule } from 'devextreme-angular'; import { Service, Sale } from './app.service'; import { exportPivotGrid } from 'devextreme/excel_exporter'; import ExcelJS from 'exceljs'; import saveAs from 'file-saver'; /* // Use this import for codeSandBox import * as ExcelJS from 'exceljs/dist/exceljs.min.js'; import * as FileSaver from 'file-saver'; */ if(!/localhost/.test(document.location.host)) { enableProdMode(); } @Component({ styleUrls: ['app/app.component.css'], selector: 'demo-app', templateUrl: 'app/app.component.html', providers: [Service] }) export class AppComponent { sales: Sale[]; dataSource: any; constructor(service: Service) { this.dataSource = { fields: [{ caption: 'Region', dataField: 'region', area: 'row', expanded: true }, { caption: 'City', dataField: 'city', width: 150, area: 'row' }, { dataField: 'date', dataType: 'date', area: 'column' }, { caption: 'Sales', dataField: 'amount', dataType: 'number', summaryType: 'sum', format: 'currency', area: 'data' }], store: service.getSales() } } onExporting(e) { const workbook = new ExcelJS.Workbook(); const worksheet = workbook.addWorksheet('Sales'); exportPivotGrid({ component: e.component, worksheet: worksheet, customizeCell: ({ pivotCell, excelCell }) => { if(this.isDataCell(pivotCell) || this.isTotalCell(pivotCell)) { const appearance = this.getConditionalAppearance(pivotCell); Object.assign(excelCell, this.getExcelCellFormat(appearance)); } const borderStyle = { style: 'thin', color: { argb: 'FF7E7E7E' } }; excelCell.border = { bottom: borderStyle, left: borderStyle, right: borderStyle, top: borderStyle }; } }).then(() => { workbook.xlsx.writeBuffer().then((buffer) => { saveAs(new Blob([buffer], { type: 'application/octet-stream' }), 'Sales.xlsx'); }); }); e.cancel = true; } onCellPrepared({ cell, area, cellElement }) { cell.area = area; if(this.isDataCell(cell) || this.isTotalCell(cell)) { const appearance = this.getConditionalAppearance(cell); Object.assign(cellElement.style, this.getCssStyles(appearance)); } } isDataCell(cell) { return (cell.area === 'data' && cell.rowType === 'D' && cell.columnType === 'D'); } isTotalCell(cell) { return (cell.type === 'T' || cell.type === 'GT' || cell.rowType === 'T' || cell.rowType === 'GT' || cell.columnType === 'T' || cell.columnType === 'GT'); } getExcelCellFormat({ fill, font, bold }) { return { fill: { type: 'pattern', pattern: 'solid', fgColor: { argb: fill } }, font: { color: { argb: font }, bold } }; } getCssStyles({ fill, font, bold }) { return { 'background-color': `#${fill}`, color: `#${font}`, 'font-weight': bold ? 'bold' : undefined }; } getConditionalAppearance(cell) { if(this.isTotalCell(cell)) { return { fill: 'F2F2F2', font: '3F3F3F', bold: true }; } else { const { value } = cell; if(value < 20000) { return { font: '9C0006', fill: 'FFC7CE' }; } if(value > 50000) { return { font: '006100', fill: 'C6EFCE' }; } return { font: '9C6500', fill: 'FFEB9C' }; } } } @NgModule({ imports: [ BrowserModule, DxPivotGridModule ], declarations: [AppComponent], bootstrap: [AppComponent] }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);
    import { Injectable } from '@angular/core'; export class Sale { id: number; region: string; country: string; city: string; amount: number; date: string; } let sales: Sale[] = [{ "id": 1, "region": "North America", "country": "USA", "city": "New York", "amount": 1740, "date": "2013/01/06" }, { "id": 2, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 850, "date": "2013/01/13" }, { "id": 3, "region": "North America", "country": "USA", "city": "Denver", "amount": 2235, "date": "2013/01/07" }, { "id": 4, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1965, "date": "2013/01/03" }, { "id": 5, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 880, "date": "2013/01/10" }, { "id": 6, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5260, "date": "2013/01/17" }, { "id": 7, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2790, "date": "2013/01/21" }, { "id": 8, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 3140, "date": "2013/01/01" }, { "id": 9, "region": "Europe", "country": "GBR", "city": "London", "amount": 6175, "date": "2013/01/24" }, { "id": 10, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4575, "date": "2013/01/11" }, { "id": 11, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3680, "date": "2013/01/12" }, { "id": 12, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2260, "date": "2013/01/01" }, { "id": 13, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2910, "date": "2013/01/26" }, { "id": 14, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 8400, "date": "2013/01/05" }, { "id": 15, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 1325, "date": "2013/01/14" }, { "id": 16, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3920, "date": "2013/01/05" }, { "id": 17, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2220, "date": "2013/01/15" }, { "id": 18, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 940, "date": "2013/01/01" }, { "id": 19, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1630, "date": "2013/01/10" }, { "id": 20, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2910, "date": "2013/01/23" }, { "id": 21, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2600, "date": "2013/01/14" }, { "id": 22, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4340, "date": "2013/01/26" }, { "id": 23, "region": "Europe", "country": "GBR", "city": "London", "amount": 6650, "date": "2013/01/24" }, { "id": 24, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 490, "date": "2013/01/22" }, { "id": 25, "region": "North America", "country": "USA", "city": "New York", "amount": 3390, "date": "2013/01/25" }, { "id": 26, "region": "North America", "country": "USA", "city": "New York", "amount": 5160, "date": "2013/02/20" }, { "id": 27, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5750, "date": "2013/02/12" }, { "id": 28, "region": "North America", "country": "USA", "city": "Denver", "amount": 2805, "date": "2013/02/13" }, { "id": 29, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2505, "date": "2013/02/09" }, { "id": 30, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 930, "date": "2013/02/04" }, { "id": 31, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1240, "date": "2013/02/03" }, { "id": 32, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 315, "date": "2013/02/04" }, { "id": 33, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2870, "date": "2013/02/18" }, { "id": 34, "region": "Europe", "country": "GBR", "city": "London", "amount": 5150, "date": "2013/02/18" }, { "id": 35, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 2725, "date": "2013/02/20" }, { "id": 36, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2840, "date": "2013/02/04" }, { "id": 37, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5840, "date": "2013/02/13" }, { "id": 38, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6750, "date": "2013/02/11" }, { "id": 39, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1200, "date": "2013/02/03" }, { "id": 40, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4550, "date": "2013/02/08" }, { "id": 41, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 6040, "date": "2013/02/17" }, { "id": 42, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2205, "date": "2013/02/08" }, { "id": 43, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 990, "date": "2013/02/20" }, { "id": 44, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 700, "date": "2013/02/11" }, { "id": 45, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2325, "date": "2013/02/15" }, { "id": 46, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 930, "date": "2013/02/21" }, { "id": 47, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1560, "date": "2013/02/04" }, { "id": 48, "region": "North America", "country": "USA", "city": "New York", "amount": 1740, "date": "2013/03/04" }, { "id": 49, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3575, "date": "2013/03/20" }, { "id": 50, "region": "North America", "country": "USA", "city": "Denver", "amount": 4500, "date": "2013/03/04" }, { "id": 51, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1605, "date": "2013/03/17" }, { "id": 52, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 800, "date": "2013/03/21" }, { "id": 53, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 640, "date": "2013/03/08" }, { "id": 54, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 735, "date": "2013/03/19" }, { "id": 55, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2520, "date": "2013/03/20" }, { "id": 56, "region": "Europe", "country": "GBR", "city": "London", "amount": 6675, "date": "2013/03/18" }, { "id": 57, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3625, "date": "2013/03/25" }, { "id": 58, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1200, "date": "2013/03/07" }, { "id": 59, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2000, "date": "2013/03/07" }, { "id": 60, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1410, "date": "2013/03/10" }, { "id": 61, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2700, "date": "2013/03/19" }, { "id": 62, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5950, "date": "2013/03/24" }, { "id": 63, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5120, "date": "2013/03/08" }, { "id": 64, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1980, "date": "2013/03/17" }, { "id": 65, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1110, "date": "2013/03/08" }, { "id": 66, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 980, "date": "2013/03/21" }, { "id": 67, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5460, "date": "2013/03/19" }, { "id": 68, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3800, "date": "2013/03/12" }, { "id": 69, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2610, "date": "2013/03/04" }, { "id": 70, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3080, "date": "2013/03/22" }, { "id": 71, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2010, "date": "2013/03/23" }, { "id": 72, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1200, "date": "2013/03/04" }, { "id": 73, "region": "North America", "country": "USA", "city": "New York", "amount": 7680, "date": "2013/04/15" }, { "id": 74, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1325, "date": "2013/04/07" }, { "id": 75, "region": "North America", "country": "USA", "city": "Denver", "amount": 2835, "date": "2013/04/10" }, { "id": 76, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3660, "date": "2013/04/10" }, { "id": 77, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 390, "date": "2013/04/12" }, { "id": 78, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4420, "date": "2013/04/08" }, { "id": 79, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1755, "date": "2013/04/13" }, { "id": 80, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2580, "date": "2013/04/15" }, { "id": 81, "region": "Europe", "country": "GBR", "city": "London", "amount": 850, "date": "2013/04/01" }, { "id": 82, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 2825, "date": "2013/04/10" }, { "id": 83, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 540, "date": "2013/04/06" }, { "id": 84, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1520, "date": "2013/04/08" }, { "id": 85, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8760, "date": "2013/04/26" }, { "id": 86, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1110, "date": "2013/04/16" }, { "id": 87, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 6850, "date": "2013/04/19" }, { "id": 88, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1940, "date": "2013/04/23" }, { "id": 89, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1980, "date": "2013/04/21" }, { "id": 90, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 3090, "date": "2013/04/03" }, { "id": 91, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1640, "date": "2013/04/24" }, { "id": 92, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3585, "date": "2013/04/01" }, { "id": 93, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1770, "date": "2013/04/01" }, { "id": 94, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4005, "date": "2013/04/04" }, { "id": 95, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2870, "date": "2013/04/02" }, { "id": 96, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 960, "date": "2013/04/20" }, { "id": 97, "region": "North America", "country": "USA", "city": "New York", "amount": 8640, "date": "2013/05/14" }, { "id": 98, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5450, "date": "2013/05/24" }, { "id": 99, "region": "North America", "country": "USA", "city": "Denver", "amount": 2535, "date": "2013/05/07" }, { "id": 100, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1155, "date": "2013/05/20" }, { "id": 101, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 3140, "date": "2013/05/18" }, { "id": 102, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2260, "date": "2013/05/19" }, { "id": 103, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1215, "date": "2013/05/23" }, { "id": 104, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1210, "date": "2013/05/08" }, { "id": 105, "region": "Europe", "country": "GBR", "city": "London", "amount": 875, "date": "2013/05/25" }, { "id": 106, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5400, "date": "2013/05/03" }, { "id": 107, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5940, "date": "2013/05/25" }, { "id": 108, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4700, "date": "2013/05/03" }, { "id": 109, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5520, "date": "2013/05/12" }, { "id": 110, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9210, "date": "2013/05/22" }, { "id": 111, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7950, "date": "2013/05/12" }, { "id": 112, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3740, "date": "2013/05/24" }, { "id": 113, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 990, "date": "2013/05/02" }, { "id": 114, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 3190, "date": "2013/05/03" }, { "id": 115, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2430, "date": "2013/05/11" }, { "id": 116, "region": "North America", "country": "USA", "city": "New York", "amount": 7380, "date": "2013/06/15" }, { "id": 117, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4475, "date": "2013/06/08" }, { "id": 118, "region": "North America", "country": "USA", "city": "Denver", "amount": 1290, "date": "2013/06/10" }, { "id": 119, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2250, "date": "2013/06/10" }, { "id": 120, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 350, "date": "2013/06/22" }, { "id": 121, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5480, "date": "2013/06/24" }, { "id": 122, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2355, "date": "2013/06/10" }, { "id": 123, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1960, "date": "2013/06/23" }, { "id": 124, "region": "Europe", "country": "GBR", "city": "London", "amount": 4125, "date": "2013/06/06" }, { "id": 125, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7925, "date": "2013/06/12" }, { "id": 126, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1120, "date": "2013/06/22" }, { "id": 127, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5100, "date": "2013/06/01" }, { "id": 128, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1500, "date": "2013/06/25" }, { "id": 129, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 5130, "date": "2013/06/10" }, { "id": 130, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 2475, "date": "2013/06/10" }, { "id": 131, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2100, "date": "2013/06/06" }, { "id": 132, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3570, "date": "2013/06/10" }, { "id": 133, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 550, "date": "2013/06/02" }, { "id": 134, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2850, "date": "2013/06/26" }, { "id": 135, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4280, "date": "2013/06/19" }, { "id": 136, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1460, "date": "2013/06/17" }, { "id": 137, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 960, "date": "2013/06/17" }, { "id": 138, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1520, "date": "2013/06/03" }, { "id": 139, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 6750, "date": "2013/06/21" }, { "id": 140, "region": "North America", "country": "USA", "city": "New York", "amount": 7260, "date": "2013/07/14" }, { "id": 141, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2450, "date": "2013/07/11" }, { "id": 142, "region": "North America", "country": "USA", "city": "Denver", "amount": 3540, "date": "2013/07/02" }, { "id": 143, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1950, "date": "2013/07/03" }, { "id": 144, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 360, "date": "2013/07/07" }, { "id": 145, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4500, "date": "2013/07/03" }, { "id": 146, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4575, "date": "2013/07/21" }, { "id": 147, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2310, "date": "2013/07/18" }, { "id": 148, "region": "Europe", "country": "GBR", "city": "London", "amount": 7500, "date": "2013/07/04" }, { "id": 149, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3575, "date": "2013/07/23" }, { "id": 150, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 760, "date": "2013/07/01" }, { "id": 151, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2400, "date": "2013/07/11" }, { "id": 152, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 3330, "date": "2013/07/04" }, { "id": 153, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3480, "date": "2013/07/23" }, { "id": 154, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4875, "date": "2013/07/11" }, { "id": 155, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4980, "date": "2013/07/19" }, { "id": 156, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2580, "date": "2013/07/04" }, { "id": 157, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2650, "date": "2013/07/16" }, { "id": 158, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1190, "date": "2013/07/02" }, { "id": 159, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 960, "date": "2013/07/26" }, { "id": 160, "region": "North America", "country": "USA", "city": "New York", "amount": 3600, "date": "2013/08/08" }, { "id": 161, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2250, "date": "2013/08/01" }, { "id": 162, "region": "North America", "country": "USA", "city": "Denver", "amount": 1275, "date": "2013/08/02" }, { "id": 163, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3885, "date": "2013/08/14" }, { "id": 164, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1900, "date": "2013/08/05" }, { "id": 165, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2300, "date": "2013/08/09" }, { "id": 166, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2895, "date": "2013/08/15" }, { "id": 167, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 350, "date": "2013/08/20" }, { "id": 168, "region": "Europe", "country": "GBR", "city": "London", "amount": 4200, "date": "2013/08/22" }, { "id": 169, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7175, "date": "2013/08/14" }, { "id": 170, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4420, "date": "2013/08/24" }, { "id": 171, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5200, "date": "2013/08/21" }, { "id": 172, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7920, "date": "2013/08/17" }, { "id": 173, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 6990, "date": "2013/08/22" }, { "id": 174, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 2125, "date": "2013/08/05" }, { "id": 175, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2220, "date": "2013/08/16" }, { "id": 176, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1575, "date": "2013/08/23" }, { "id": 177, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1880, "date": "2013/08/12" }, { "id": 178, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 710, "date": "2013/08/25" }, { "id": 179, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 390, "date": "2013/08/20" }, { "id": 180, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4635, "date": "2013/08/04" }, { "id": 181, "region": "North America", "country": "USA", "city": "Denver", "amount": 4350, "date": "2013/08/19" }, { "id": 182, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 6020, "date": "2013/08/02" }, { "id": 183, "region": "North America", "country": "USA", "city": "New York", "amount": 3660, "date": "2013/08/19" }, { "id": 184, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4525, "date": "2013/08/24" }, { "id": 185, "region": "North America", "country": "USA", "city": "New York", "amount": 4410, "date": "2013/09/12" }, { "id": 186, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1725, "date": "2013/09/07" }, { "id": 187, "region": "North America", "country": "USA", "city": "Denver", "amount": 2715, "date": "2013/09/14" }, { "id": 188, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2820, "date": "2013/09/08" }, { "id": 189, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2310, "date": "2013/09/12" }, { "id": 190, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 780, "date": "2013/09/08" }, { "id": 191, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2370, "date": "2013/09/19" }, { "id": 192, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1410, "date": "2013/09/09" }, { "id": 193, "region": "Europe", "country": "GBR", "city": "London", "amount": 1825, "date": "2013/09/23" }, { "id": 194, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4075, "date": "2013/09/06" }, { "id": 195, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1020, "date": "2013/09/04" }, { "id": 196, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4320, "date": "2013/09/25" }, { "id": 197, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7530, "date": "2013/09/13" }, { "id": 198, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2820, "date": "2013/09/08" }, { "id": 199, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3050, "date": "2013/09/04" }, { "id": 200, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5080, "date": "2013/09/25" }, { "id": 201, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1125, "date": "2013/09/13" }, { "id": 202, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 850, "date": "2013/09/24" }, { "id": 203, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1440, "date": "2013/09/19" }, { "id": 204, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1950, "date": "2013/09/02" }, { "id": 205, "region": "North America", "country": "USA", "city": "New York", "amount": 6390, "date": "2013/10/11" }, { "id": 206, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4625, "date": "2013/10/02" }, { "id": 207, "region": "North America", "country": "USA", "city": "Denver", "amount": 3510, "date": "2013/10/24" }, { "id": 208, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2730, "date": "2013/10/15" }, { "id": 209, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2070, "date": "2013/10/15" }, { "id": 210, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2320, "date": "2013/10/18" }, { "id": 211, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4260, "date": "2013/10/24" }, { "id": 212, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 840, "date": "2013/10/18" }, { "id": 213, "region": "Europe", "country": "GBR", "city": "London", "amount": 7300, "date": "2013/10/24" }, { "id": 214, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5950, "date": "2013/10/11" }, { "id": 215, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3220, "date": "2013/10/25" }, { "id": 216, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3480, "date": "2013/10/08" }, { "id": 217, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 4830, "date": "2013/10/26" }, { "id": 218, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4470, "date": "2013/10/05" }, { "id": 219, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3675, "date": "2013/10/23" }, { "id": 220, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4260, "date": "2013/10/01" }, { "id": 221, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4245, "date": "2013/10/26" }, { "id": 222, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1470, "date": "2013/10/01" }, { "id": 223, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1810, "date": "2013/10/02" }, { "id": 224, "region": "North America", "country": "USA", "city": "New York", "amount": 600, "date": "2013/10/23" }, { "id": 225, "region": "North America", "country": "USA", "city": "New York", "amount": 7500, "date": "2013/11/03" }, { "id": 226, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4625, "date": "2013/11/02" }, { "id": 227, "region": "North America", "country": "USA", "city": "Denver", "amount": 2625, "date": "2013/11/09" }, { "id": 228, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1440, "date": "2013/11/15" }, { "id": 229, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2420, "date": "2013/11/15" }, { "id": 230, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4180, "date": "2013/11/15" }, { "id": 231, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3720, "date": "2013/11/25" }, { "id": 232, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2730, "date": "2013/11/08" }, { "id": 233, "region": "Europe", "country": "GBR", "city": "London", "amount": 3775, "date": "2013/11/17" }, { "id": 234, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3525, "date": "2013/11/15" }, { "id": 235, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5320, "date": "2013/11/08" }, { "id": 236, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5340, "date": "2013/11/13" }, { "id": 237, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8850, "date": "2013/11/01" }, { "id": 238, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 7050, "date": "2013/11/14" }, { "id": 239, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4200, "date": "2013/11/18" }, { "id": 240, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4960, "date": "2013/11/04" }, { "id": 241, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2280, "date": "2013/11/13" }, { "id": 242, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 590, "date": "2013/11/11" }, { "id": 243, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 810, "date": "2013/11/12" }, { "id": 244, "region": "Europe", "country": "GBR", "city": "London", "amount": 2625, "date": "2013/11/07" }, { "id": 245, "region": "North America", "country": "USA", "city": "New York", "amount": 8280, "date": "2013/12/01" }, { "id": 246, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5650, "date": "2013/12/19" }, { "id": 247, "region": "North America", "country": "USA", "city": "Denver", "amount": 2760, "date": "2013/12/14" }, { "id": 248, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2670, "date": "2013/12/03" }, { "id": 249, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2520, "date": "2013/12/20" }, { "id": 250, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4080, "date": "2013/12/21" }, { "id": 251, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4140, "date": "2013/12/22" }, { "id": 252, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 390, "date": "2013/12/04" }, { "id": 253, "region": "Europe", "country": "GBR", "city": "London", "amount": 1400, "date": "2013/12/19" }, { "id": 254, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7275, "date": "2013/12/22" }, { "id": 255, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4100, "date": "2013/12/20" }, { "id": 256, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5520, "date": "2013/12/25" }, { "id": 257, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 9210, "date": "2013/12/24" }, { "id": 258, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 7290, "date": "2013/12/05" }, { "id": 259, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 625, "date": "2013/12/22" }, { "id": 260, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4460, "date": "2013/12/12" }, { "id": 261, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3825, "date": "2013/12/13" }, { "id": 262, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2850, "date": "2013/12/17" }, { "id": 263, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2780, "date": "2013/12/07" }, { "id": 264, "region": "North America", "country": "USA", "city": "New York", "amount": 840, "date": "2013/12/18" }, { "id": 265, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2970, "date": "2013/12/23" }, { "id": 266, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 945, "date": "2013/12/06" }, { "id": 267, "region": "North America", "country": "USA", "city": "Denver", "amount": 2625, "date": "2013/12/04" }, { "id": 268, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 390, "date": "2013/12/01" }, { "id": 269, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2250, "date": "2013/12/02" }, { "id": 270, "region": "North America", "country": "USA", "city": "New York", "amount": 7710, "date": "2014/01/18" }, { "id": 271, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 7975, "date": "2014/01/10" }, { "id": 272, "region": "North America", "country": "USA", "city": "Denver", "amount": 3285, "date": "2014/01/13" }, { "id": 273, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2580, "date": "2014/01/22" }, { "id": 274, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2160, "date": "2014/01/26" }, { "id": 275, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1100, "date": "2014/01/25" }, { "id": 276, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4425, "date": "2014/01/21" }, { "id": 277, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1360, "date": "2014/01/22" }, { "id": 278, "region": "Europe", "country": "GBR", "city": "London", "amount": 3250, "date": "2014/01/14" }, { "id": 279, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5550, "date": "2014/01/21" }, { "id": 280, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2860, "date": "2014/01/25" }, { "id": 281, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5320, "date": "2014/01/08" }, { "id": 282, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 4050, "date": "2014/01/14" }, { "id": 283, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3450, "date": "2014/01/24" }, { "id": 284, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5425, "date": "2014/01/11" }, { "id": 285, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4860, "date": "2014/01/12" }, { "id": 286, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4695, "date": "2014/01/16" }, { "id": 287, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 610, "date": "2014/01/05" }, { "id": 288, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1580, "date": "2014/01/15" }, { "id": 289, "region": "North America", "country": "USA", "city": "New York", "amount": 3780, "date": "2014/02/18" }, { "id": 290, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5400, "date": "2014/02/21" }, { "id": 291, "region": "North America", "country": "USA", "city": "Denver", "amount": 630, "date": "2014/02/18" }, { "id": 292, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3960, "date": "2014/02/04" }, { "id": 293, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2010, "date": "2014/02/25" }, { "id": 294, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5000, "date": "2014/02/01" }, { "id": 295, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1995, "date": "2014/02/20" }, { "id": 296, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 860, "date": "2014/02/12" }, { "id": 297, "region": "Europe", "country": "GBR", "city": "London", "amount": 2150, "date": "2014/02/10" }, { "id": 298, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4050, "date": "2014/02/06" }, { "id": 299, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2960, "date": "2014/02/18" }, { "id": 300, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1780, "date": "2014/02/26" }, { "id": 301, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8700, "date": "2014/02/03" }, { "id": 302, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3390, "date": "2014/02/03" }, { "id": 303, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4425, "date": "2014/02/15" }, { "id": 304, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1180, "date": "2014/02/23" }, { "id": 305, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 360, "date": "2014/02/08" }, { "id": 306, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2310, "date": "2014/02/13" }, { "id": 307, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1770, "date": "2014/02/20" }, { "id": 308, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3060, "date": "2014/02/26" }, { "id": 309, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1750, "date": "2014/02/12" }, { "id": 310, "region": "North America", "country": "USA", "city": "New York", "amount": 2280, "date": "2014/03/09" }, { "id": 311, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 7600, "date": "2014/03/25" }, { "id": 312, "region": "North America", "country": "USA", "city": "Denver", "amount": 1035, "date": "2014/03/23" }, { "id": 313, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1245, "date": "2014/03/01" }, { "id": 314, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2860, "date": "2014/03/19" }, { "id": 315, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 440, "date": "2014/03/19" }, { "id": 316, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4665, "date": "2014/03/02" }, { "id": 317, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2270, "date": "2014/03/15" }, { "id": 318, "region": "Europe", "country": "GBR", "city": "London", "amount": 5000, "date": "2014/03/09" }, { "id": 319, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5100, "date": "2014/03/23" }, { "id": 320, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2120, "date": "2014/03/11" }, { "id": 321, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5140, "date": "2014/03/05" }, { "id": 322, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6210, "date": "2014/03/19" }, { "id": 323, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9510, "date": "2014/03/19" }, { "id": 324, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7600, "date": "2014/03/21" }, { "id": 325, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5420, "date": "2014/03/15" }, { "id": 326, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1980, "date": "2014/03/05" }, { "id": 327, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1820, "date": "2014/03/07" }, { "id": 328, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1670, "date": "2014/03/21" }, { "id": 329, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4800, "date": "2014/03/08" }, { "id": 330, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2925, "date": "2014/03/03" }, { "id": 331, "region": "North America", "country": "USA", "city": "New York", "amount": 2940, "date": "2014/04/11" }, { "id": 332, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3525, "date": "2014/04/13" }, { "id": 333, "region": "North America", "country": "USA", "city": "Denver", "amount": 2475, "date": "2014/04/22" }, { "id": 334, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3315, "date": "2014/04/08" }, { "id": 335, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 3140, "date": "2014/04/07" }, { "id": 336, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2520, "date": "2014/04/01" }, { "id": 337, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1200, "date": "2014/04/10" }, { "id": 338, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2060, "date": "2014/04/21" }, { "id": 339, "region": "Europe", "country": "GBR", "city": "London", "amount": 7875, "date": "2014/04/02" }, { "id": 340, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 1450, "date": "2014/04/07" }, { "id": 341, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2640, "date": "2014/04/22" }, { "id": 342, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1960, "date": "2014/04/16" }, { "id": 343, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2250, "date": "2014/04/23" }, { "id": 344, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4500, "date": "2014/04/05" }, { "id": 345, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5050, "date": "2014/04/11" }, { "id": 346, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2940, "date": "2014/04/02" }, { "id": 347, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2880, "date": "2014/04/14" }, { "id": 348, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1050, "date": "2014/04/19" }, { "id": 349, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1850, "date": "2014/04/02" }, { "id": 350, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3160, "date": "2014/04/01" }, { "id": 351, "region": "Europe", "country": "GBR", "city": "London", "amount": 875, "date": "2014/04/04" }, { "id": 352, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3200, "date": "2014/04/08" }, { "id": 353, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1380, "date": "2014/04/21" }, { "id": 354, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 3060, "date": "2014/04/06" }, { "id": 355, "region": "North America", "country": "USA", "city": "New York", "amount": 6690, "date": "2014/05/19" }, { "id": 356, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4525, "date": "2014/05/15" }, { "id": 357, "region": "North America", "country": "USA", "city": "Denver", "amount": 4665, "date": "2014/05/10" }, { "id": 358, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 4530, "date": "2014/05/18" }, { "id": 359, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1330, "date": "2014/05/08" }, { "id": 360, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1720, "date": "2014/05/20" }, { "id": 361, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3750, "date": "2014/05/16" }, { "id": 362, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1290, "date": "2014/05/10" }, { "id": 363, "region": "Europe", "country": "GBR", "city": "London", "amount": 4925, "date": "2014/05/14" }, { "id": 364, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4300, "date": "2014/05/22" }, { "id": 365, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5740, "date": "2014/05/08" }, { "id": 366, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 3760, "date": "2014/05/18" }, { "id": 367, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7920, "date": "2014/05/22" }, { "id": 368, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1440, "date": "2014/05/21" }, { "id": 369, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5975, "date": "2014/05/25" }, { "id": 370, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4440, "date": "2014/05/05" }, { "id": 371, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2310, "date": "2014/05/24" }, { "id": 372, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2250, "date": "2014/05/06" }, { "id": 373, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2320, "date": "2014/05/14" }, { "id": 374, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8370, "date": "2014/05/06" }, { "id": 375, "region": "North America", "country": "USA", "city": "New York", "amount": 5190, "date": "2014/06/26" }, { "id": 376, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 925, "date": "2014/06/04" }, { "id": 377, "region": "North America", "country": "USA", "city": "Denver", "amount": 3240, "date": "2014/06/20" }, { "id": 378, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3180, "date": "2014/06/23" }, { "id": 379, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 780, "date": "2014/06/13" }, { "id": 380, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 4680, "date": "2014/06/08" }, { "id": 381, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 2475, "date": "2014/06/25" }, { "id": 382, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1920, "date": "2014/06/20" }, { "id": 383, "region": "Europe", "country": "GBR", "city": "London", "amount": 7500, "date": "2014/06/25" }, { "id": 384, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5025, "date": "2014/06/26" }, { "id": 385, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2400, "date": "2014/06/08" }, { "id": 386, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1720, "date": "2014/06/09" }, { "id": 387, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2880, "date": "2014/06/21" }, { "id": 388, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 5430, "date": "2014/06/03" }, { "id": 389, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4475, "date": "2014/06/19" }, { "id": 390, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 1420, "date": "2014/06/20" }, { "id": 391, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2670, "date": "2014/06/25" }, { "id": 392, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1930, "date": "2014/06/02" }, { "id": 393, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 580, "date": "2014/06/25" }, { "id": 394, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1620, "date": "2014/06/12" }, { "id": 395, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4530, "date": "2014/06/02" }, { "id": 396, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 6025, "date": "2014/06/23" }, { "id": 397, "region": "North America", "country": "USA", "city": "New York", "amount": 3540, "date": "2014/07/21" }, { "id": 398, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3000, "date": "2014/07/01" }, { "id": 399, "region": "North America", "country": "USA", "city": "Denver", "amount": 3240, "date": "2014/07/26" }, { "id": 400, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2265, "date": "2014/07/22" }, { "id": 401, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 400, "date": "2014/07/09" }, { "id": 402, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 1460, "date": "2014/07/08" }, { "id": 403, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1620, "date": "2014/07/18" }, { "id": 404, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2400, "date": "2014/07/25" }, { "id": 405, "region": "Europe", "country": "GBR", "city": "London", "amount": 5275, "date": "2014/07/04" }, { "id": 406, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 4475, "date": "2014/07/03" }, { "id": 407, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3980, "date": "2014/07/21" }, { "id": 408, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 5240, "date": "2014/07/11" }, { "id": 409, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 1200, "date": "2014/07/21" }, { "id": 410, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 5700, "date": "2014/07/18" }, { "id": 411, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 5575, "date": "2014/07/01" }, { "id": 412, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2160, "date": "2014/07/02" }, { "id": 413, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 960, "date": "2014/07/09" }, { "id": 414, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1280, "date": "2014/07/04" }, { "id": 415, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1040, "date": "2014/07/02" }, { "id": 416, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5520, "date": "2014/07/21" }, { "id": 417, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1760, "date": "2014/07/25" }, { "id": 418, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 4080, "date": "2014/07/07" }, { "id": 419, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1000, "date": "2014/07/21" }, { "id": 420, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 3270, "date": "2014/07/12" }, { "id": 421, "region": "North America", "country": "USA", "city": "New York", "amount": 1770, "date": "2014/08/23" }, { "id": 422, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2700, "date": "2014/08/09" }, { "id": 423, "region": "North America", "country": "USA", "city": "Denver", "amount": 2175, "date": "2014/08/03" }, { "id": 424, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3375, "date": "2014/08/11" }, { "id": 425, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2040, "date": "2014/08/01" }, { "id": 426, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3000, "date": "2014/08/21" }, { "id": 427, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3900, "date": "2014/08/16" }, { "id": 428, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1370, "date": "2014/08/20" }, { "id": 429, "region": "Europe", "country": "GBR", "city": "London", "amount": 5700, "date": "2014/08/01" }, { "id": 430, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 1275, "date": "2014/08/22" }, { "id": 431, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 4060, "date": "2014/08/13" }, { "id": 432, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2320, "date": "2014/08/18" }, { "id": 433, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 7590, "date": "2014/08/24" }, { "id": 434, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4560, "date": "2014/08/20" }, { "id": 435, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7575, "date": "2014/08/20" }, { "id": 436, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 700, "date": "2014/08/25" }, { "id": 437, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2400, "date": "2014/08/16" }, { "id": 438, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1390, "date": "2014/08/15" }, { "id": 439, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1320, "date": "2014/08/09" }, { "id": 440, "region": "North America", "country": "USA", "city": "Denver", "amount": 1680, "date": "2014/08/09" }, { "id": 441, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1500, "date": "2014/08/11" }, { "id": 442, "region": "North America", "country": "USA", "city": "New York", "amount": 6150, "date": "2014/09/21" }, { "id": 443, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3675, "date": "2014/09/02" }, { "id": 444, "region": "North America", "country": "USA", "city": "Denver", "amount": 2250, "date": "2014/09/05" }, { "id": 445, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 3585, "date": "2014/09/10" }, { "id": 446, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1470, "date": "2014/09/01" }, { "id": 447, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2260, "date": "2014/09/02" }, { "id": 448, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3765, "date": "2014/09/03" }, { "id": 449, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1640, "date": "2014/09/04" }, { "id": 450, "region": "Europe", "country": "GBR", "city": "London", "amount": 4475, "date": "2014/09/09" }, { "id": 451, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5975, "date": "2014/09/04" }, { "id": 452, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1100, "date": "2014/09/16" }, { "id": 453, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1320, "date": "2014/09/18" }, { "id": 454, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8610, "date": "2014/09/19" }, { "id": 455, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9210, "date": "2014/09/09" }, { "id": 456, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3700, "date": "2014/09/01" }, { "id": 457, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3620, "date": "2014/09/19" }, { "id": 458, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4275, "date": "2014/09/01" }, { "id": 459, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2370, "date": "2014/09/03" }, { "id": 460, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1870, "date": "2014/09/10" }, { "id": 461, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2070, "date": "2014/09/25" }, { "id": 462, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5025, "date": "2014/09/19" }, { "id": 463, "region": "North America", "country": "USA", "city": "New York", "amount": 1080, "date": "2014/10/15" }, { "id": 464, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1400, "date": "2014/10/22" }, { "id": 465, "region": "North America", "country": "USA", "city": "Denver", "amount": 4260, "date": "2014/10/01" }, { "id": 466, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 2745, "date": "2014/10/01" }, { "id": 467, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2920, "date": "2014/10/23" }, { "id": 468, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3520, "date": "2014/10/11" }, { "id": 469, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4035, "date": "2014/10/20" }, { "id": 470, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1730, "date": "2014/10/05" }, { "id": 471, "region": "Europe", "country": "GBR", "city": "London", "amount": 975, "date": "2014/10/06" }, { "id": 472, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5700, "date": "2014/10/06" }, { "id": 473, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5080, "date": "2014/10/18" }, { "id": 474, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2940, "date": "2014/10/24" }, { "id": 475, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2670, "date": "2014/10/04" }, { "id": 476, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1230, "date": "2014/10/11" }, { "id": 477, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 600, "date": "2014/10/08" }, { "id": 478, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3700, "date": "2014/10/08" }, { "id": 479, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3375, "date": "2014/10/11" }, { "id": 480, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1500, "date": "2014/10/17" }, { "id": 481, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 370, "date": "2014/10/05" }, { "id": 482, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2340, "date": "2014/10/16" }, { "id": 483, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1080, "date": "2014/10/08" }, { "id": 484, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 2775, "date": "2014/10/21" }, { "id": 485, "region": "North America", "country": "USA", "city": "New York", "amount": 4380, "date": "2014/11/09" }, { "id": 486, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 5500, "date": "2014/11/21" }, { "id": 487, "region": "North America", "country": "USA", "city": "Denver", "amount": 1920, "date": "2014/11/24" }, { "id": 488, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 765, "date": "2014/11/24" }, { "id": 489, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 370, "date": "2014/11/18" }, { "id": 490, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3500, "date": "2014/11/25" }, { "id": 491, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 825, "date": "2014/11/09" }, { "id": 492, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 490, "date": "2014/11/23" }, { "id": 493, "region": "Europe", "country": "GBR", "city": "London", "amount": 7075, "date": "2014/11/20" }, { "id": 494, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 1350, "date": "2014/11/25" }, { "id": 495, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 1440, "date": "2014/11/15" }, { "id": 496, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2820, "date": "2014/11/13" }, { "id": 497, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 2280, "date": "2014/11/12" }, { "id": 498, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1110, "date": "2014/11/03" }, { "id": 499, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 1150, "date": "2014/11/23" }, { "id": 500, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2040, "date": "2014/11/20" }, { "id": 501, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3090, "date": "2014/11/24" }, { "id": 502, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1940, "date": "2014/11/24" }, { "id": 503, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 3090, "date": "2014/11/16" }, { "id": 504, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4900, "date": "2014/11/05" }, { "id": 505, "region": "North America", "country": "USA", "city": "Denver", "amount": 3465, "date": "2014/11/07" }, { "id": 506, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1110, "date": "2014/11/20" }, { "id": 507, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1650, "date": "2014/11/02" }, { "id": 508, "region": "North America", "country": "USA", "city": "New York", "amount": 5280, "date": "2014/12/04" }, { "id": 509, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 3075, "date": "2014/12/02" }, { "id": 510, "region": "North America", "country": "USA", "city": "Denver", "amount": 690, "date": "2014/12/07" }, { "id": 511, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1305, "date": "2014/12/15" }, { "id": 512, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1970, "date": "2014/12/01" }, { "id": 513, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3760, "date": "2014/12/18" }, { "id": 514, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1920, "date": "2014/12/22" }, { "id": 515, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1360, "date": "2014/12/12" }, { "id": 516, "region": "Europe", "country": "GBR", "city": "London", "amount": 2525, "date": "2014/12/06" }, { "id": 517, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 5575, "date": "2014/12/20" }, { "id": 518, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5560, "date": "2014/12/10" }, { "id": 519, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 4880, "date": "2014/12/13" }, { "id": 520, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8850, "date": "2014/12/03" }, { "id": 521, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 2820, "date": "2014/12/10" }, { "id": 522, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 4000, "date": "2014/12/12" }, { "id": 523, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 5820, "date": "2014/12/02" }, { "id": 524, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 1275, "date": "2014/12/12" }, { "id": 525, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1310, "date": "2014/12/01" }, { "id": 526, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2180, "date": "2014/12/26" }, { "id": 527, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4470, "date": "2014/12/17" }, { "id": 528, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2990, "date": "2014/12/15" }, { "id": 529, "region": "Europe", "country": "GBR", "city": "London", "amount": 7650, "date": "2014/12/18" }, { "id": 530, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 780, "date": "2014/12/02" }, { "id": 531, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2970, "date": "2014/12/13" }, { "id": 532, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1155, "date": "2014/12/05" }, { "id": 533, "region": "North America", "country": "USA", "city": "New York", "amount": 4470, "date": "2015/01/10" }, { "id": 534, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 1125, "date": "2015/01/21" }, { "id": 535, "region": "North America", "country": "USA", "city": "Denver", "amount": 645, "date": "2015/01/17" }, { "id": 536, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 675, "date": "2015/01/05" }, { "id": 537, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2840, "date": "2015/01/05" }, { "id": 538, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2660, "date": "2015/01/04" }, { "id": 539, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4560, "date": "2015/01/12" }, { "id": 540, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2880, "date": "2015/01/20" }, { "id": 541, "region": "Europe", "country": "GBR", "city": "London", "amount": 500, "date": "2015/01/02" }, { "id": 542, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 3925, "date": "2015/01/07" }, { "id": 543, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5660, "date": "2015/01/18" }, { "id": 544, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1460, "date": "2015/01/22" }, { "id": 545, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5040, "date": "2015/01/10" }, { "id": 546, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 4830, "date": "2015/01/13" }, { "id": 547, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3075, "date": "2015/01/22" }, { "id": 548, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 3120, "date": "2015/01/14" }, { "id": 549, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3525, "date": "2015/01/23" }, { "id": 550, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1930, "date": "2015/01/09" }, { "id": 551, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2890, "date": "2015/01/02" }, { "id": 552, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 1545, "date": "2015/01/17" }, { "id": 553, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3630, "date": "2015/01/20" }, { "id": 554, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 4035, "date": "2015/01/14" }, { "id": 555, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 345, "date": "2015/01/06" }, { "id": 556, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 7000, "date": "2015/01/07" }, { "id": 557, "region": "North America", "country": "USA", "city": "New York", "amount": 3060, "date": "2015/02/13" }, { "id": 558, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 6425, "date": "2015/02/04" }, { "id": 559, "region": "North America", "country": "USA", "city": "Denver", "amount": 615, "date": "2015/02/22" }, { "id": 560, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1755, "date": "2015/02/07" }, { "id": 561, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1540, "date": "2015/02/21" }, { "id": 562, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 2820, "date": "2015/02/24" }, { "id": 563, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4305, "date": "2015/02/10" }, { "id": 564, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 1520, "date": "2015/02/26" }, { "id": 565, "region": "Europe", "country": "GBR", "city": "London", "amount": 4725, "date": "2015/02/18" }, { "id": 566, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 6750, "date": "2015/02/16" }, { "id": 567, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 5540, "date": "2015/02/07" }, { "id": 568, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1880, "date": "2015/02/24" }, { "id": 569, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6180, "date": "2015/02/26" }, { "id": 570, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9300, "date": "2015/02/03" }, { "id": 571, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3700, "date": "2015/02/26" }, { "id": 572, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 740, "date": "2015/02/01" }, { "id": 573, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4755, "date": "2015/02/23" }, { "id": 574, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2570, "date": "2015/02/20" }, { "id": 575, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 2860, "date": "2015/02/19" }, { "id": 576, "region": "North America", "country": "USA", "city": "New York", "amount": 5430, "date": "2015/03/21" }, { "id": 577, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 4525, "date": "2015/03/21" }, { "id": 578, "region": "North America", "country": "USA", "city": "Denver", "amount": 1515, "date": "2015/03/10" }, { "id": 579, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 630, "date": "2015/03/15" }, { "id": 580, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1310, "date": "2015/03/01" }, { "id": 581, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3200, "date": "2015/03/17" }, { "id": 582, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 3945, "date": "2015/03/20" }, { "id": 583, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2990, "date": "2015/03/18" }, { "id": 584, "region": "Europe", "country": "GBR", "city": "London", "amount": 1125, "date": "2015/03/22" }, { "id": 585, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7950, "date": "2015/03/17" }, { "id": 586, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 2960, "date": "2015/03/25" }, { "id": 587, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 6300, "date": "2015/03/20" }, { "id": 588, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 8670, "date": "2015/03/07" }, { "id": 589, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3930, "date": "2015/03/23" }, { "id": 590, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 6975, "date": "2015/03/02" }, { "id": 591, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4220, "date": "2015/03/17" }, { "id": 592, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 3090, "date": "2015/03/25" }, { "id": 593, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2380, "date": "2015/03/01" }, { "id": 594, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1510, "date": "2015/03/07" }, { "id": 595, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 1020, "date": "2015/03/19" }, { "id": 596, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 6700, "date": "2015/03/26" }, { "id": 597, "region": "North America", "country": "USA", "city": "New York", "amount": 4890, "date": "2015/04/02" }, { "id": 598, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 7225, "date": "2015/04/13" }, { "id": 599, "region": "North America", "country": "USA", "city": "Denver", "amount": 795, "date": "2015/04/07" }, { "id": 600, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1785, "date": "2015/04/03" }, { "id": 601, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1850, "date": "2015/04/03" }, { "id": 602, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 5120, "date": "2015/04/12" }, { "id": 603, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 615, "date": "2015/04/07" }, { "id": 604, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2860, "date": "2015/04/05" }, { "id": 605, "region": "Europe", "country": "GBR", "city": "London", "amount": 1525, "date": "2015/04/24" }, { "id": 606, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7425, "date": "2015/04/15" }, { "id": 607, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 6080, "date": "2015/04/13" }, { "id": 608, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 2940, "date": "2015/04/04" }, { "id": 609, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5580, "date": "2015/04/16" }, { "id": 610, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 9390, "date": "2015/04/19" }, { "id": 611, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3200, "date": "2015/04/26" }, { "id": 612, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4380, "date": "2015/04/05" }, { "id": 613, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 4725, "date": "2015/04/06" }, { "id": 614, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 930, "date": "2015/04/25" }, { "id": 615, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 1910, "date": "2015/04/05" }, { "id": 616, "region": "Europe", "country": "GBR", "city": "London", "amount": 2725, "date": "2015/04/16" }, { "id": 617, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 4720, "date": "2015/04/02" }, { "id": 618, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 5190, "date": "2015/04/10" }, { "id": 619, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 2800, "date": "2015/04/26" }, { "id": 620, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 3780, "date": "2015/04/24" }, { "id": 621, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 2340, "date": "2015/04/17" }, { "id": 622, "region": "North America", "country": "USA", "city": "New York", "amount": 4830, "date": "2015/05/12" }, { "id": 623, "region": "North America", "country": "USA", "city": "Los Angeles", "amount": 2075, "date": "2015/05/23" }, { "id": 624, "region": "North America", "country": "USA", "city": "Denver", "amount": 3420, "date": "2015/05/21" }, { "id": 625, "region": "North America", "country": "CAN", "city": "Vancouver", "amount": 1440, "date": "2015/05/10" }, { "id": 626, "region": "North America", "country": "CAN", "city": "Edmonton", "amount": 1680, "date": "2015/05/15" }, { "id": 627, "region": "South America", "country": "BRA", "city": "Rio de Janeiro", "amount": 3440, "date": "2015/05/16" }, { "id": 628, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 4695, "date": "2015/05/10" }, { "id": 629, "region": "South America", "country": "PRY", "city": "Asuncion", "amount": 2380, "date": "2015/05/06" }, { "id": 630, "region": "Europe", "country": "GBR", "city": "London", "amount": 1875, "date": "2015/05/25" }, { "id": 631, "region": "Europe", "country": "DEU", "city": "Berlin", "amount": 7550, "date": "2015/05/14" }, { "id": 632, "region": "Europe", "country": "ESP", "city": "Madrid", "amount": 3340, "date": "2015/05/01" }, { "id": 633, "region": "Europe", "country": "RUS", "city": "Moscow", "amount": 1400, "date": "2015/05/22" }, { "id": 634, "region": "Asia", "country": "CHN", "city": "Beijing", "amount": 6060, "date": "2015/05/22" }, { "id": 635, "region": "Asia", "country": "JPN", "city": "Tokyo", "amount": 8370, "date": "2015/05/13" }, { "id": 636, "region": "Asia", "country": "KOR", "city": "Seoul", "amount": 3550, "date": "2015/05/26" }, { "id": 637, "region": "Australia", "country": "AUS", "city": "Sydney", "amount": 2620, "date": "2015/05/17" }, { "id": 638, "region": "Australia", "country": "AUS", "city": "Melbourne", "amount": 2400, "date": "2015/05/21" }, { "id": 639, "region": "Africa", "country": "ZAF", "city": "Pretoria", "amount": 1740, "date": "2015/05/21" }, { "id": 640, "region": "Africa", "country": "EGY", "city": "Cairo", "amount": 500, "date": "2015/05/26" }, { "id": 641, "region": "South America", "country": "ARG", "city": "Buenos Aires", "amount": 780, "date": "2015/05/07" }]; @Injectable() export class Service { getSales() { return sales; } }
    // 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/ System.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.0.3/tslib.js', 'rxjs': 'npm:rxjs@6.3.3', 'exceljs': 'npm:exceljs@1.7.0/dist/exceljs.js', 'file-saver': 'npm:file-saver@1.3.8/FileSaver.js', 'rrule': 'npm:rrule@2.6.6/dist/es5/rrule.js', 'luxon': 'npm:luxon@1.25.0/build/global/luxon.min.js', 'es6-object-assign': 'npm:es6-object-assign@1.1.0', 'devextreme': 'npm:devextreme@20.2.4', 'jszip': 'npm:jszip@3.5.0/dist/jszip.min.js', 'devextreme-quill': 'npm:devextreme-quill@0.9.7/dist/dx-quill.min.js', 'devexpress-diagram': 'npm:devexpress-diagram@2.0.5', 'devexpress-gantt': 'npm:devexpress-gantt@2.0.8', 'devextreme-angular': 'npm:devextreme-angular@20.2.4', 'preact': 'npm:preact@10.5.7/dist/preact.js', 'preact/hooks': 'npm:preact@10.5.7/hooks/dist/hooks.js' }, packages: { 'app': { main: './app.component.ts', defaultExtension: 'ts' }, 'devextreme': { defaultExtension: 'js' }, 'devextreme/events/utils': { main: 'index' }, 'devextreme/events': { main: 'index' }, 'es6-object-assign': { main: './index.js', defaultExtension: 'js' } }, packageConfigPaths: [ "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", ] });
    <!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/20.2.4/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.4/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.2/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>