var data = [
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 15
},
"count" : 6232
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 10
},
"count" : 5576
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 1
},
"count" : 5849
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 2
},
"count" : 6213
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 26
},
"count" : 2640
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 11
},
"count" : 5233
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 19
},
"count" : 5881
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 3
},
"count" : 6028
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 24
},
"count" : 5942
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 31
},
"count" : 3104
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 28
},
"count" : 5827
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 4
},
"count" : 5402
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 1
},
"count" : 5525
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 4
},
"count" : 4147
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 5
},
"count" : 3175
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 28
},
"count" : 2308
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 19
},
"count" : 6787
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 24
},
"count" : 5442
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 25
},
"count" : 4590
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 27
},
"count" : 5416
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 6
},
"count" : 3183
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 9
},
"count" : 6368
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 12
},
"count" : 2862
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 30
},
"count" : 6231
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 28
},
"count" : 7274
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 7
},
"count" : 6171
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 21
},
"count" : 3092
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 25
},
"count" : 5576
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 13
},
"count" : 3218
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 8
},
"count" : 6096
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 9
},
"count" : 5910
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 1
},
"count" : 2985
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 16
},
"count" : 6899
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 5
},
"count" : 5743
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 14
},
"count" : 6025
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 2
},
"count" : 5849
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 2
},
"count" : 5116
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 17
},
"count" : 5730
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 21
},
"count" : 6462
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 18
},
"count" : 4720
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 19
},
"count" : 2775
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 18
},
"count" : 3660
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 20
},
"count" : 2997
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 21
},
"count" : 6060
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 15
},
"count" : 3532
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 16
},
"count" : 5323
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 22
},
"count" : 5763
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 23
},
"count" : 5564
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 27
},
"count" : 6892
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 27
},
"count" : 3414
},
{
"_id" : {
"year" : 2015,
"month" : 9,
"day" : 29
},
"count" : 6138
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 4
},
"count" : 3097
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 3
},
"count" : 2938
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 14
},
"count" : 7231
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 5
},
"count" : 6293
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 3
},
"count" : 5451
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 24
},
"count" : 3603
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 17
},
"count" : 6259
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 6
},
"count" : 6461
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 7
},
"count" : 5916
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 8
},
"count" : 5768
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 22
},
"count" : 6122
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 9
},
"count" : 5523
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 10
},
"count" : 3212
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 11
},
"count" : 214
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 12
},
"count" : 6128
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 29
},
"count" : 5854
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 12
},
"count" : 6039
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 13
},
"count" : 6326
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 15
},
"count" : 6018
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 18
},
"count" : 7090
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 17
},
"count" : 3245
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 20
},
"count" : 6450
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 23
},
"count" : 5826
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 25
},
"count" : 3747
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 10
},
"count" : 6574
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 26
},
"count" : 6907
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 23
},
"count" : 6114
},
{
"_id" : {
"year" : 2015,
"month" : 10,
"day" : 30
},
"count" : 5329
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 14
},
"count" : 3082
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 6
},
"count" : 5042
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 7
},
"count" : 3029
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 8
},
"count" : 3461
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 11
},
"count" : 6497
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 13
},
"count" : 5293
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 16
},
"count" : 6193
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 20
},
"count" : 5280
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 22
},
"count" : 3365
},
{
"_id" : {
"year" : 2015,
"month" : 11,
"day" : 26
},
"count" : 6838
}
]
var result = [],
zf = function(n) {return n<10?'0'+n:n};
for (var index in data) {
var item = data[index];
result.push({
date_ts: new Date(item['_id']['year'], item['_id']['month'], item['_id']['day']).getTime(),
date: item['_id']['year']+'-'+zf(item['_id']['month'])+'-'+zf(item['_id']['day']),
count: item['count']
});
}
function json2csv(json, sortby) {
Object.values = function (obj) {
var vals = [];
for( var key in obj ) {
if ( obj.hasOwnProperty(key) ) {
vals.push(obj[key]);
}
}
return vals;
}
if (sortby) {
json = json.sort(function (a, b) {
if (a[sortby] > b[sortby]) return 1;
if (a[sortby] < b[sortby]) return -1;
return 0;
});
}
var keys = Object.keys(json[0]);
console.log(keys.join(','));
for (var index in json) {
var item = json[index];
console.log(Object.values(item).join(','));
}
}
json2csv(result, 'date_ts');
