Data Export from Pivot, JavaScript Programming Example of Data Export from Pivot

Data Export from Pivot

Get the programming example below to ensure export of data from Pivot in different formats. Seize the opportunity to use our free coding samples for your web applications.

JS Code

function toPDF(){
	webix.toPDF("pivot");
};

function toPDF2(){
	webix.toPDF("pivot", options);
};

function toPDF3(){
	webix.toPDF("pivot", options2);
};

function toExcel(){
	webix.toExcel("pivot");
};

function toExcel2(){
	webix.toExcel("pivot", options);
};

function toExcel3(){
	webix.toExcel("pivot", options2);
};

function toCSV(){
	webix.toCSV("pivot");
};

function toCSV2(){
	webix.toCSV("pivot", options);
};

function toCSV3(){
	webix.toCSV("pivot", options2);
};


var options = { 
  flatTree:{
    id:"value",
    columns:[
      { header:"Form" },
      { header:"Country" },
    ]
  }
};

var options2 = { 
  flatTree:{
    id:"value",
    fill:true
  }
};

var grida = { 
  view:"pivot",
  id:"pivot",
  totalColumn: true,
  footer: true,
  max: true,
  structure: {
    rows: ["form", "name"],
    columns: ["year"],
    values: [{ name:"oil", operation:["min","max","sum"]}],
    filters:[]
  }    
};


var toolbar = {
    view:"toolbar",
    id:"myToolbar",
  	height:130,
  	rows:[
      {cols:[
          { view:"button", value:"get PDF", click:toPDF, inputWidth:150},
          { view:"button", value:"get flat PDF", click:toPDF2, inputWidth:150},
          { view:"button", value:"get fill PDF", click:toPDF3, inputWidth:150},
      ]},
      {cols:[
          { view:"button", value:"get Excel", click:toExcel, inputWidth:150},
          { view:"button", value:"get flat Excel", click:toExcel2, inputWidth:150},
          { view:"button", value:"get fill Excel", click:toExcel3, inputWidth:150}
      ]},
      {cols:[
          { view:"button", value:"get CSV", click:toCSV, inputWidth:150},
          { view:"button", value:"get flat CSV", click:toCSV2, inputWidth:150},
          { view:"button", value:"get fill CSV", click:toCSV3, inputWidth:150}
      ]}
   ]
};


webix.ui({
    margin:10,
	rows:[
      toolbar,grida
    ]
});

$$("pivot").$divider = "**";
$$("pivot").parse(pivot_dataset);

HTML Code

<script>
  var pivot_dataset = [
    {"name": "Argentina", "year": 2005, "continent": "South America", "form": "Republic", "gdp": 181.357, "oil": 1.545, "balance": 4.699},
    {"name": "Argentina", "year": 2006, "continent": "South America", "form": "Republic", "gdp": 212.507, "oil": 1.732, "balance": 7.167},
    {"name": "Argentina", "year": 2007, "continent": "South America", "form": "Republic", "gdp": 260.071, "oil": 2.845, "balance": 6.728},
    {"name": "Argentina", "year": 2008, "continent": "South America", "form": "Republic", "gdp": 324.405, "oil": 4.333, "balance": 5.990},
    {"name": "Argentina", "year": 2009, "continent": "South America", "form": "Republic", "gdp": 305.763, "oil": 2.626, "balance": 7.544},
    {"name": "Argentina", "year": 2010, "continent": "South America", "form": "Republic", "gdp": 367.565, "oil": 4.474, "balance": 2.418},
    {"name": "Argentina", "year": 2011, "continent": "South America", "form": "Republic", "gdp": 444.612, "oil": 9.414, "balance": -0.299},
    {"name": "Argentina", "year": 2012, "continent": "South America", "form": "Republic", "gdp": 474.812, "oil": 10.496, "balance": 1.264},
    {"name": "Argentina", "year": 2013, "continent": "South America", "form": "Republic", "gdp": 495.067, "oil": 10.851, "balance": -0.361},
    {"name": "Australia", "year": 2005, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 732.091, "oil": 8.014, "balance": -41.878},
    {"name": "Australia", "year": 2006, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 777.901, "oil": 9.997, "balance": -41.461},
    {"name": "Australia", "year": 2007, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 945.694, "oil": 12.322, "balance": -58.543},
    {"name": "Australia", "year": 2008, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 1053.862, "oil": 15.278, "balance": -46.325},
    {"name": "Australia", "year": 2009, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 992.244, "oil": 9.748, "balance": -41.432},
    {"name": "Australia", "year": 2010, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 1244.406, "oil": 14.910, "balance": -35.711},
    {"name": "Australia", "year": 2011, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 1486.914, "oil": 21.497, "balance": -33.522},
    {"name": "Australia", "year": 2012, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 1542.055, "oil": 22.596, "balance": -62.969},
    {"name": "Australia", "year": 2013, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 1598.069, "oil": 23.650, "balance": -87.944},
    {"name": "Austria", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 305.513, "oil": 7.600, "balance": 6.615},
    {"name": "Austria", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 325.256, "oil": 9.344, "balance": 9.112},
    {"name": "Austria", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 375.581, "oil": 9.864, "balance": 13.184},
    {"name": "Austria", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 416.119, "oil": 13.372, "balance": 20.246},
    {"name": "Austria", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 384.622, "oil": 8.475, "balance": 10.428},
    {"name": "Austria", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 380.018, "oil": 10.224, "balance": 11.435},
    {"name": "Austria", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 418.414, "oil": 16.376, "balance": 8.147},
    {"name": "Austria", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 391.469, "oil": 16.872, "balance": 7.315},
    {"name": "Austria", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 393.753, "oil": 16.877, "balance": 6.413},
    {"name": "Belarus", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 30.210, "oil": 4.375, "balance": 0.435},
    {"name": "Belarus", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 36.962, "oil": 6.093, "balance": -1.448},
    {"name": "Belarus", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 45.276, "oil": 7.721, "balance": -3.040},
    {"name": "Belarus", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 60.752, "oil": 11.019, "balance": -4.988},
    {"name": "Belarus", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 49.209, "oil": 8.386, "balance": -6.178},
    {"name": "Belarus", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 55.221, "oil": 7.686, "balance": -8.278},
    {"name": "Belarus", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 55.136, "oil": 12.875, "balance": -5.775},
    {"name": "Belarus", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 58.215, "oil": 12.409, "balance": -2.076},
    {"name": "Belarus", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 58.933, "oil": 11.434, "balance": -3.419},
    {"name": "Belgium", "year": 2005, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 378.006, "oil": 24.956, "balance": 7.465},
    {"name": "Belgium", "year": 2006, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 400.338, "oil": 30.561, "balance": 7.447},
    {"name": "Belgium", "year": 2007, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 460.279, "oil": 34.263, "balance": 7.438},
    {"name": "Belgium", "year": 2008, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 509.764, "oil": 49.070, "balance": -8.368},
    {"name": "Belgium", "year": 2009, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 474.633, "oil": 30.195, "balance": -7.400},
    {"name": "Belgium", "year": 2010, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 472.540, "oil": 38.998, "balance": 6.641},
    {"name": "Belgium", "year": 2011, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 514.593, "oil": 56.540, "balance": -5.119},
    {"name": "Belgium", "year": 2012, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 476.796, "oil": 51.684, "balance": -0.623},
    {"name": "Belgium", "year": 2013, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 475.746, "oil": 51.143, "balance": 1.643},
    {"name": "Brazil", "year": 2005, "continent": "South America", "form": "Republic", "gdp": 881.754, "oil": 11.779, "balance": 13.984},
    {"name": "Brazil", "year": 2006, "continent": "South America", "form": "Republic", "gdp": 1089.157, "oil": 15.365, "balance": 13.642},
    {"name": "Brazil", "year": 2007, "continent": "South America", "form": "Republic", "gdp": 1366.220, "oil": 20.408, "balance": 1.551},
    {"name": "Brazil", "year": 2008, "continent": "South America", "form": "Republic", "gdp": 1650.392, "oil": 30.505, "balance": -28.192},
    {"name": "Brazil", "year": 2009, "continent": "South America", "form": "Republic", "gdp": 1622.311, "oil": 16.475, "balance": -24.302},
    {"name": "Brazil", "year": 2010, "continent": "South America", "form": "Republic", "gdp": 2142.926, "oil": 26.089, "balance": -47.273},
    {"name": "Brazil", "year": 2011, "continent": "South America", "form": "Republic", "gdp": 2492.907, "oil": 37.498, "balance": -52.480},
    {"name": "Brazil", "year": 2012, "continent": "South America", "form": "Republic", "gdp": 2425.052, "oil": 37.763, "balance": -62.341},
    {"name": "Brazil", "year": 2013, "continent": "South America", "form": "Republic", "gdp": 2503.869, "oil": 39.648, "balance": -70.068},
    {"name": "Canada", "year": 2005, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1133.757, "oil": 27.777, "balance": 21.376},
    {"name": "Canada", "year": 2006, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1278.607, "oil": 30.626, "balance": 18.064},
    {"name": "Canada", "year": 2007, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1424.067, "oil": 34.726, "balance": 11.890},
    {"name": "Canada", "year": 2008, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1502.678, "oil": 49.833, "balance": 4.945},
    {"name": "Canada", "year": 2009, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1337.577, "oil": 29.701, "balance": -39.573},
    {"name": "Canada", "year": 2010, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1577.040, "oil": 39.361, "balance": -49.375},
    {"name": "Canada", "year": 2011, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1738.954, "oil": 52.574, "balance": -48.906},
    {"name": "Canada", "year": 2012, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1770.084, "oil": 51.378, "balance": -59.921},
    {"name": "Canada", "year": 2013, "continent": "North America", "form": "Constitutional monarchy", "gdp": 1839.141, "oil": 50.408, "balance": -68.182},
    {"name": "Central African Republic", "year": 2005, "continent": "Africa", "form": "Republic", "gdp": 1.350, "oil": 0.034, "balance": -0.088},
    {"name": "Central African Republic", "year": 2006, "continent": "Africa", "form": "Republic", "gdp": 1.473, "oil": 0.050, "balance": -0.044},
    {"name": "Central African Republic", "year": 2007, "continent": "Africa", "form": "Republic", "gdp": 1.697, "oil": 0.068, "balance": -0.106},
    {"name": "Central African Republic", "year": 2008, "continent": "Africa", "form": "Republic", "gdp": 1.983, "oil": 0.092, "balance": -0.198},
    {"name": "Central African Republic", "year": 2009, "continent": "Africa", "form": "Republic", "gdp": 1.982, "oil": 0.065, "balance": -0.182},
    {"name": "Central African Republic", "year": 2010, "continent": "Africa", "form": "Republic", "gdp": 1.986, "oil": 0.082, "balance": -0.202},
    {"name": "Central African Republic", "year": 2011, "continent": "Africa", "form": "Republic", "gdp": 2.195, "oil": 0.100, "balance": -0.191},
    {"name": "Central African Republic", "year": 2012, "continent": "Africa", "form": "Republic", "gdp": 2.168, "oil": 0.111, "balance": -0.165},
    {"name": "Central African Republic", "year": 2013, "continent": "Africa", "form": "Republic", "gdp": 2.249, "oil": 0.113, "balance": -0.141},
    {"name": "Chad", "year": 2005, "continent": "Africa", "form": "Republic", "gdp": 5.884, "oil": 0.253, "balance": 0.069},
    {"name": "Chad", "year": 2006, "continent": "Africa", "form": "Republic", "gdp": 6.306, "oil": 0.594, "balance": 0.375},
    {"name": "Chad", "year": 2007, "continent": "Africa", "form": "Republic", "gdp": 7.018, "oil": 0.298, "balance": 0.813},
    {"name": "Chad", "year": 2008, "continent": "Africa", "form": "Republic", "gdp": 8.394, "oil": 0.507, "balance": 0.754},
    {"name": "Chad", "year": 2009, "continent": "Africa", "form": "Republic", "gdp": 7.100, "oil": 0.535, "balance": -0.286},
    {"name": "Chad", "year": 2010, "continent": "Africa", "form": "Republic", "gdp": 8.556, "oil": 0.835, "balance": -0.300},
    {"name": "Chad", "year": 2011, "continent": "Africa", "form": "Republic", "gdp": 9.345, "oil": 1.057, "balance": 0.191},
    {"name": "Chad", "year": 2012, "continent": "Africa", "form": "Republic", "gdp": 9.723, "oil": 0.847, "balance": -0.181},
    {"name": "Chad", "year": 2013, "continent": "Africa", "form": "Republic", "gdp": 9.603, "oil": 0.811, "balance": -0.193},
    {"name": "China", "year": 2005, "continent": "Asia", "form": "Republic", "gdp": 2256.919, "oil": 59.615, "balance": 134.098},
    {"name": "China", "year": 2006, "continent": "Asia", "form": "Republic", "gdp": 2712.917, "oil": 84.061, "balance": 232.712},
    {"name": "China", "year": 2007, "continent": "Asia", "form": "Republic", "gdp": 3494.235, "oil": 98.845, "balance": 353.876},
    {"name": "China", "year": 2008, "continent": "Asia", "form": "Republic", "gdp": 4519.951, "oil": 161.770, "balance": 412.370},
    {"name": "China", "year": 2009, "continent": "Asia", "form": "Republic", "gdp": 4990.526, "oil": 108.553, "balance": 261.012},
    {"name": "China", "year": 2010, "continent": "Asia", "form": "Republic", "gdp": 5930.393, "oil": 163.558, "balance": 237.623},
    {"name": "China", "year": 2011, "continent": "Asia", "form": "Republic", "gdp": 7298.147, "oil": 235.753, "balance": 201.720},
    {"name": "China", "year": 2012, "continent": "Asia", "form": "Republic", "gdp": 8250.241, "oil": 238.267, "balance": 190.681},
    {"name": "China", "year": 2013, "continent": "Asia", "form": "Republic", "gdp": 9038.658, "oil": 231.625, "balance": 222.685},
    {"name": "Colombia", "year": 2005, "continent": "South America", "form": "Republic", "gdp": 146.585, "oil": 0.518, "balance": -1.886},
    {"name": "Colombia", "year": 2006, "continent": "South America", "form": "Republic", "gdp": 160.691, "oil": 0.651, "balance": -2.988},
    {"name": "Colombia", "year": 2007, "continent": "South America", "form": "Republic", "gdp": 210.565, "oil": 0.875, "balance": -5.978},
    {"name": "Colombia", "year": 2008, "continent": "South America", "form": "Republic", "gdp": 235.255, "oil": 1.754, "balance": -6.699},
    {"name": "Colombia", "year": 2009, "continent": "South America", "form": "Republic", "gdp": 231.597, "oil": 1.150, "balance": -4.960},
    {"name": "Colombia", "year": 2010, "continent": "South America", "form": "Republic", "gdp": 284.877, "oil": 2.008, "balance": -8.758},
    {"name": "Colombia", "year": 2011, "continent": "South America", "form": "Republic", "gdp": 327.626, "oil": 3.756, "balance": -9.978},
    {"name": "Colombia", "year": 2012, "continent": "South America", "form": "Republic", "gdp": 365.402, "oil": 4.056, "balance": -10.656},
    {"name": "Colombia", "year": 2013, "continent": "South America", "form": "Republic", "gdp": 387.399, "oil": 4.219, "balance": -11.190},
    {"name": "Czech Republic", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 130.066, "oil": 4.781, "balance": -1.210},
    {"name": "Czech Republic", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 148.374, "oil": 6.978, "balance": -3.129},
    {"name": "Czech Republic", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 180.479, "oil": 8.899, "balance": -7.931},
    {"name": "Czech Republic", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 225.427, "oil": 9.484, "balance": -4.782},
    {"name": "Czech Republic", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 196.151, "oil": 14.750, "balance": -4.849},
    {"name": "Czech Republic", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 197.674, "oil": 9.712, "balance": -7.601},
    {"name": "Czech Republic", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 215.180, "oil": 12.131, "balance": -6.348},
    {"name": "Czech Republic", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 193.513, "oil": 16.089, "balance": -4.630},
    {"name": "Czech Republic", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 192.597, "oil": 16.259, "balance": -4.146},
    {"name": "Denmark", "year": 2005, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 257.676, "oil": 5.041, "balance": 11.195},
    {"name": "Denmark", "year": 2006, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 274.377, "oil": 5.564, "balance": 8.171},
    {"name": "Denmark", "year": 2007, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 311.417, "oil": 5.535, "balance": 4.234},
    {"name": "Denmark", "year": 2008, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 343.881, "oil": 9.129, "balance": 9.910},
    {"name": "Denmark", "year": 2009, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 311.114, "oil": 5.840, "balance": 10.191},
    {"name": "Denmark", "year": 2010, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 311.989, "oil": 9.129, "balance": 17.221},
    {"name": "Denmark", "year": 2011, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 332.019, "oil": 9.129, "balance": 22.178},
    {"name": "Denmark", "year": 2012, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 309.180, "oil": 9.129, "balance": 15.498},
    {"name": "Denmark", "year": 2013, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 308.366, "oil": 9.129, "balance": 14.081},
    {"name": "Egypt", "year": 2005, "continent": "Africa", "form": "Republic", "gdp": 89.794, "oil": 3.975, "balance": 2.910},
    {"name": "Egypt", "year": 2006, "continent": "Africa", "form": "Republic", "gdp": 107.375, "oil": 5.359, "balance": 1.752},
    {"name": "Egypt", "year": 2007, "continent": "Africa", "form": "Republic", "gdp": 130.346, "oil": 4.128, "balance": 2.269},
    {"name": "Egypt", "year": 2008, "continent": "Africa", "form": "Republic", "gdp": 162.435, "oil": 9.561, "balance": 0.888},
    {"name": "Egypt", "year": 2009, "continent": "Africa", "form": "Republic", "gdp": 188.608, "oil": 7.032, "balance": -4.424},
    {"name": "Egypt", "year": 2010, "continent": "Africa", "form": "Republic", "gdp": 218.465, "oil": 5.161, "balance": -4.318},
    {"name": "Egypt", "year": 2011, "continent": "Africa", "form": "Republic", "gdp": 235.719, "oil": 9.262, "balance": -6.088},
    {"name": "Egypt", "year": 2012, "continent": "Africa", "form": "Republic", "gdp": 255.001, "oil": 11.830, "balance": -8.668},
    {"name": "Egypt", "year": 2013, "continent": "Africa", "form": "Republic", "gdp": 275.868, "oil": 11.888, "balance": -9.001},
    {"name": "Finland", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 196.118, "oil": 6.103, "balance": 6.573},
    {"name": "Finland", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 208.143, "oil": 8.081, "balance": 8.652},
    {"name": "Finland", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 246.481, "oil": 8.893, "balance": 10.510},
    {"name": "Finland", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 273.225, "oil": 12.173, "balance": 7.178},
    {"name": "Finland", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 240.004, "oil": 7.475, "balance": 4.254},
    {"name": "Finland", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 237.243, "oil": 9.282, "balance": 3.415},
    {"name": "Finland", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 263.488, "oil": 13.975, "balance": -3.124},
    {"name": "Finland", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 247.189, "oil": 14.638, "balance": -3.961},
    {"name": "Finland", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 252.163, "oil": 14.922, "balance": -4.238},
    {"name": "France", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 2140.207, "oil": 33.360, "balance": -10.375},
    {"name": "France", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 2257.781, "oil": 39.873, "balance": -12.995},
    {"name": "France", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 2586.115, "oil": 42.819, "balance": -25.931},
    {"name": "France", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 2845.119, "oil": 59.821, "balance": -49.632},
    {"name": "France", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 2626.537, "oil": 31.790, "balance": -35.016},
    {"name": "France", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 2570.592, "oil": 35.319, "balance": -40.042},
    {"name": "France", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 2778.085, "oil": 46.482, "balance": -54.169},
    {"name": "France", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 2580.423, "oil": 45.772, "balance": -44.755},
    {"name": "France", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 2565.622, "oil": 43.312, "balance": -43.327},
    {"name": "Georgia", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 6.411, "oil": 0.336, "balance": -0.709},
    {"name": "Georgia", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 7.768, "oil": 0.443, "balance": -1.176},
    {"name": "Georgia", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 10.224, "oil": 0.556, "balance": -2.009},
    {"name": "Georgia", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 12.870, "oil": 0.762, "balance": -2.824},
    {"name": "Georgia", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 10.768, "oil": 0.555, "balance": -1.144},
    {"name": "Georgia", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 11.638, "oil": 0.695, "balance": -1.194},
    {"name": "Georgia", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 14.347, "oil": 0.911, "balance": -1.688},
    {"name": "Georgia", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 15.803, "oil": 0.982, "balance": -1.989},
    {"name": "Georgia", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 17.284, "oil": 0.961, "balance": -1.929},
    {"name": "Germany", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 2771.057, "oil": 65.757, "balance": 140.261},
    {"name": "Germany", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 2905.445, "oil": 83.027, "balance": 181.741},
    {"name": "Germany", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 3328.589, "oil": 83.998, "balance": 247.967},
    {"name": "Germany", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 3640.727, "oil": 122.258, "balance": 226.105},
    {"name": "Germany", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 3307.197, "oil": 76.544, "balance": 195.769},
    {"name": "Germany", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 3312.193, "oil": 83.933, "balance": 199.920},
    {"name": "Germany", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 3607.364, "oil": 93.607, "balance": 203.929},
    {"name": "Germany", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 3366.651, "oil": 100.869, "balance": 182.827},
    {"name": "Germany", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 3373.327, "oil": 102.996, "balance": 157.823},
    {"name": "Greece", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 240.493, "oil": 11.071, "balance": -18.366},
    {"name": "Greece", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 262.296, "oil": 14.692, "balance": -29.832},
    {"name": "Greece", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 305.338, "oil": 16.800, "balance": -44.686},
    {"name": "Greece", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 342.792, "oil": 24.149, "balance": -51.212},
    {"name": "Greece", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 322.629, "oil": 14.847, "balance": -35.960},
    {"name": "Greece", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 301.627, "oil": 18.015, "balance": -30.486},
    {"name": "Greece", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 299.275, "oil": 24.092, "balance": -29.353},
    {"name": "Greece", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 254.978, "oil": 23.448, "balance": -14.821},
    {"name": "Greece", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 235.906, "oil": 22.111, "balance": -6.861},
    {"name": "India", "year": 2005, "continent": "Asia", "form": "Republic", "gdp": 808.744, "oil": 39.928, "balance": -10.285},
    {"name": "India", "year": 2006, "continent": "Asia", "form": "Republic", "gdp": 908.570, "oil": 56.284, "balance": -9.299},
    {"name": "India", "year": 2007, "continent": "Asia", "form": "Republic", "gdp": 1152.576, "oil": 67.565, "balance": -8.077},
    {"name": "India", "year": 2008, "continent": "Asia", "form": "Republic", "gdp": 1262.523, "oil": 106.399, "balance": -30.974},
    {"name": "India", "year": 2009, "continent": "Asia", "form": "Republic", "gdp": 1266.249, "oil": 74.229, "balance": -25.912},
    {"name": "India", "year": 2010, "continent": "Asia", "form": "Republic", "gdp": 1630.472, "oil": 100.686, "balance": -52.224},
    {"name": "India", "year": 2011, "continent": "Asia", "form": "Republic", "gdp": 1826.811, "oil": 141.755, "balance": -62.756},
    {"name": "India", "year": 2012, "continent": "Asia", "form": "Republic", "gdp": 1946.765, "oil": 164.447, "balance": -74.542},
    {"name": "India", "year": 2013, "continent": "Asia", "form": "Republic", "gdp": 2117.279, "oil": 177.548, "balance": -69.070},
    {"name": "Indonesia", "year": 2005, "continent": "Asia", "form": "Republic", "gdp": 285.776, "oil": 16.018, "balance": 0.277},
    {"name": "Indonesia", "year": 2006, "continent": "Asia", "form": "Republic", "gdp": 364.352, "oil": 16.146, "balance": 10.860},
    {"name": "Indonesia", "year": 2007, "continent": "Asia", "form": "Republic", "gdp": 432.170, "oil": 19.172, "balance": 10.492},
    {"name": "Indonesia", "year": 2008, "continent": "Asia", "form": "Republic", "gdp": 510.312, "oil": 23.749, "balance": 0.126},
    {"name": "Indonesia", "year": 2009, "continent": "Asia", "form": "Republic", "gdp": 538.764, "oil": 14.806, "balance": 10.628},
    {"name": "Indonesia", "year": 2010, "continent": "Asia", "form": "Republic", "gdp": 708.371, "oil": 24.344, "balance": 5.144},
    {"name": "Indonesia", "year": 2011, "continent": "Asia", "form": "Republic", "gdp": 846.450, "oil": 37.102, "balance": 1.719},
    {"name": "Indonesia", "year": 2012, "continent": "Asia", "form": "Republic", "gdp": 894.854, "oil": 40.906, "balance": -18.858},
    {"name": "Indonesia", "year": 2013, "continent": "Asia", "form": "Republic", "gdp": 1006.888, "oil": 42.110, "balance": -23.986},
    {"name": "Kazakhstan", "year": 2005, "continent": "Asia", "form": "Republic", "gdp": 57.125, "oil": 0.778, "balance": -1.056},
    {"name": "Kazakhstan", "year": 2006, "continent": "Asia", "form": "Republic", "gdp": 81.003, "oil": 1.493, "balance": -1.999},
    {"name": "Kazakhstan", "year": 2007, "continent": "Asia", "form": "Republic", "gdp": 103.142, "oil": 1.826, "balance": -8.322},
    {"name": "Kazakhstan", "year": 2008, "continent": "Asia", "form": "Republic", "gdp": 135.229, "oil": 2.773, "balance": 6.326},
    {"name": "Kazakhstan", "year": 2009, "continent": "Asia", "form": "Republic", "gdp": 115.308, "oil": 1.446, "balance": -4.114},
    {"name": "Kazakhstan", "year": 2010, "continent": "Asia", "form": "Republic", "gdp": 148.047, "oil": 2.402, "balance": 2.409},
    {"name": "Kazakhstan", "year": 2011, "continent": "Asia", "form": "Republic", "gdp": 186.199, "oil": 2.502, "balance": 14.110},
    {"name": "Kazakhstan", "year": 2012, "continent": "Asia", "form": "Republic", "gdp": 200.642, "oil": 2.930, "balance": 12.390},
    {"name": "Kazakhstan", "year": 2013, "continent": "Asia", "form": "Republic", "gdp": 220.141, "oil": 3.104, "balance": 9.974},
    {"name": "New Zealand", "year": 2005, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 111.569, "oil": 2.946, "balance": -8.816},
    {"name": "New Zealand", "year": 2006, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 107.966, "oil": 3.641, "balance": -8.942},
    {"name": "New Zealand", "year": 2007, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 131.894, "oil": 4.200, "balance": -10.721},
    {"name": "New Zealand", "year": 2008, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 132.335, "oil": 5.806, "balance": -11.622},
    {"name": "New Zealand", "year": 2009, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 117.284, "oil": 3.510, "balance": -3.015},
    {"name": "New Zealand", "year": 2010, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 140.066, "oil": 4.486, "balance": -4.849},
    {"name": "New Zealand", "year": 2011, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 158.869, "oil": 6.181, "balance": -6.645},
    {"name": "New Zealand", "year": 2012, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 166.923, "oil": 6.736, "balance": -8.959},
    {"name": "New Zealand", "year": 2013, "continent": "Australia", "form": "Constitutional monarchy", "gdp": 174.035, "oil": 6.485, "balance": -10.210},
    {"name": "Russia", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 763.704, "oil": 0.000, "balance": 84.443},
    {"name": "Russia", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 989.932, "oil": 0.000, "balance": 94.340},
    {"name": "Russia", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 1299.703, "oil": 0.000, "balance": 77.012},
    {"name": "Russia", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 1660.846, "oil": 0.000, "balance": 103.722},
    {"name": "Russia", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 1222.693, "oil": 0.000, "balance": 49.518},
    {"name": "Russia", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 1487.293, "oil": 0.000, "balance": 69.967},
    {"name": "Russia", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 1850.401, "oil": 0.000, "balance": 98.834},
    {"name": "Russia", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 1953.555, "oil": 0.000, "balance": 101.693},
    {"name": "Russia", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 2109.022, "oil": 0.000, "balance": 80.789},
    {"name": "Spain", "year": 2005, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1132.763, "oil": 40.002, "balance": -83.292},
    {"name": "Spain", "year": 2006, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1237.501, "oil": 51.127, "balance": -110.889},
    {"name": "Spain", "year": 2007, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1443.500, "oil": 57.276, "balance": -144.280},
    {"name": "Spain", "year": 2008, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1600.913, "oil": 83.857, "balance": -154.055},
    {"name": "Spain", "year": 2009, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1459.735, "oil": 47.657, "balance": -70.392},
    {"name": "Spain", "year": 2010, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1391.757, "oil": 58.939, "balance": -62.928},
    {"name": "Spain", "year": 2011, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1479.560, "oil": 78.276, "balance": -52.174},
    {"name": "Spain", "year": 2012, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1340.266, "oil": 77.477, "balance": -26.447},
    {"name": "Spain", "year": 2013, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 1311.122, "oil": 71.663, "balance": -1.945},
    {"name": "Switzerland", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 384.755, "oil": 11.194, "balance": 52.444},
    {"name": "Switzerland", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 405.183, "oil": 13.986, "balance": 58.153},
    {"name": "Switzerland", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 450.530, "oil": 13.184, "balance": 38.837},
    {"name": "Switzerland", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 524.289, "oil": 17.467, "balance": 10.934},
    {"name": "Switzerland", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 509.466, "oil": 22.000, "balance": 53.758},
    {"name": "Switzerland", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 550.686, "oil": 22.660, "balance": 78.566},
    {"name": "Switzerland", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 660.761, "oil": 23.340, "balance": 69.538},
    {"name": "Switzerland", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 622.855, "oil": 24.040, "balance": 62.613},
    {"name": "Switzerland", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 616.595, "oil": 24.761, "balance": 61.532},
    {"name": "Ukraine", "year": 2005, "continent": "Europe", "form": "Republic", "gdp": 86.183, "oil": 5.732, "balance": 2.531},
    {"name": "Ukraine", "year": 2006, "continent": "Europe", "form": "Republic", "gdp": 107.753, "oil": 6.843, "balance": -1.617},
    {"name": "Ukraine", "year": 2007, "continent": "Europe", "form": "Republic", "gdp": 142.719, "oil": 7.580, "balance": -5.272},
    {"name": "Ukraine", "year": 2008, "continent": "Europe", "form": "Republic", "gdp": 180.116, "oil": 10.466, "balance": -12.763},
    {"name": "Ukraine", "year": 2009, "continent": "Europe", "form": "Republic", "gdp": 117.227, "oil": 5.678, "balance": -1.732},
    {"name": "Ukraine", "year": 2010, "continent": "Europe", "form": "Republic", "gdp": 136.417, "oil": 8.076, "balance": -3.018},
    {"name": "Ukraine", "year": 2011, "continent": "Europe", "form": "Republic", "gdp": 165.245, "oil": 11.177, "balance": -9.006},
    {"name": "Ukraine", "year": 2012, "continent": "Europe", "form": "Republic", "gdp": 180.174, "oil": 11.336, "balance": -10.118},
    {"name": "Ukraine", "year": 2013, "continent": "Europe", "form": "Republic", "gdp": 195.353, "oil": 11.102, "balance": -12.968},
    {"name": "United Kingdom", "year": 2005, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2298.638, "oil": 40.167, "balance": -47.199},
    {"name": "United Kingdom", "year": 2006, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2456.515, "oil": 48.141, "balance": -72.043},
    {"name": "United Kingdom", "year": 2007, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2826.609, "oil": 54.344, "balance": -64.372},
    {"name": "United Kingdom", "year": 2008, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2670.397, "oil": 71.218, "balance": -26.711},
    {"name": "United Kingdom", "year": 2009, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2193.184, "oil": 43.863, "balance": -27.749},
    {"name": "United Kingdom", "year": 2010, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2267.482, "oil": 55.734, "balance": -57.645},
    {"name": "United Kingdom", "year": 2011, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2431.310, "oil": 79.362, "balance": -46.578},
    {"name": "United Kingdom", "year": 2012, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2433.779, "oil": 78.658, "balance": -80.589},
    {"name": "United Kingdom", "year": 2013, "continent": "Europe", "form": "Constitutional monarchy", "gdp": 2532.045, "oil": 80.259, "balance": -68.570},
    {"name": "United States", "year": 2005, "continent": "North America", "form": "Republic", "gdp": 12622.950, "oil": 251.850, "balance": -745.773},
    {"name": "United States", "year": 2006, "continent": "North America", "form": "Republic", "gdp": 13377.200, "oil": 302.450, "balance": -800.621},
    {"name": "United States", "year": 2007, "continent": "North America", "form": "Republic", "gdp": 14028.675, "oil": 346.700, "balance": -710.304},
    {"name": "United States", "year": 2008, "continent": "North America", "form": "Republic", "gdp": 14291.550, "oil": 476.125, "balance": -677.134},
    {"name": "United States", "year": 2009, "continent": "North America", "form": "Republic", "gdp": 13973.650, "oil": 267.700, "balance": -381.898},
    {"name": "United States", "year": 2010, "continent": "North America", "form": "Republic", "gdp": 14498.925, "oil": 353.750, "balance": -441.952},
    {"name": "United States", "year": 2011, "continent": "North America", "form": "Republic", "gdp": 15075.675, "oil": 462.300, "balance": -465.928},
    {"name": "United States", "year": 2012, "continent": "North America", "form": "Republic", "gdp": 15653.366, "oil": 458.457, "balance": -486.525},
    {"name": "United States", "year": 2013, "continent": "North America", "form": "Republic", "gdp": 16197.956, "oil": 464.907, "balance": -499.250},
    {"name": "Vietnam", "year": 2005, "continent": "Asia", "form": "Republic", "gdp": 52.931, "oil": 4.716, "balance": -0.560},
    {"name": "Vietnam", "year": 2006, "continent": "Asia", "form": "Republic", "gdp": 60.933, "oil": 5.665, "balance": -0.164},
    {"name": "Vietnam", "year": 2007, "continent": "Asia", "form": "Republic", "gdp": 71.112, "oil": 7.248, "balance": -6.992},
    {"name": "Vietnam", "year": 2008, "continent": "Asia", "form": "Republic", "gdp": 90.302, "oil": 11.286, "balance": -10.787},
    {"name": "Vietnam", "year": 2009, "continent": "Asia", "form": "Republic", "gdp": 93.170, "oil": 6.770, "balance": -6.116},
    {"name": "Vietnam", "year": 2010, "continent": "Asia", "form": "Republic", "gdp": 103.575, "oil": 6.846, "balance": -4.287},
    {"name": "Vietnam", "year": 2011, "continent": "Asia", "form": "Republic", "gdp": 122.722, "oil": 11.154, "balance": 0.201},
    {"name": "Vietnam", "year": 2012, "continent": "Asia", "form": "Republic", "gdp": 137.681, "oil": 11.969, "balance": 0.457},
    {"name": "Vietnam", "year": 2013, "continent": "Asia", "form": "Republic", "gdp": 151.876, "oil": 12.543, "balance": -1.326},
    {"name": "Zimbabwe", "year": 2005, "continent": "Africa", "form": "Republic", "gdp": 6.101, "oil": 0.428, "balance": -0.627},
    {"name": "Zimbabwe", "year": 2006, "continent": "Africa", "form": "Republic", "gdp": 5.776, "oil": 0.447, "balance": -0.464},
    {"name": "Zimbabwe", "year": 2007, "continent": "Africa", "form": "Republic", "gdp": 5.631, "oil": 0.471, "balance": -0.375},
    {"name": "Zimbabwe", "year": 2008, "continent": "Africa", "form": "Republic", "gdp": 4.681, "oil": 0.530, "balance": -1.010},
    {"name": "Zimbabwe", "year": 2009, "continent": "Africa", "form": "Republic", "gdp": 6.133, "oil": 0.568, "balance": -1.359},
    {"name": "Zimbabwe", "year": 2010, "continent": "Africa", "form": "Republic", "gdp": 7.433, "oil": 0.945, "balance": -2.141},
    {"name": "Zimbabwe", "year": 2011, "continent": "Africa", "form": "Republic", "gdp": 9.458, "oil": 1.571, "balance": -3.427},
    {"name": "Zimbabwe", "year": 2012, "continent": "Africa", "form": "Republic", "gdp": 10.796, "oil": 1.893, "balance": -2.199},
    {"name": "Zimbabwe", "year": 2013, "continent": "Africa", "form": "Republic", "gdp": 12.293, "oil": 1.927, "balance": -2.464}
];
</script>