Skip to content

Instantly share code, notes, and snippets.

@arikfr

arikfr/query_1025.json

Last active March 14, 2016 09:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arikfr/49df57970d999b32e13e to your computer and use it in GitHub Desktop.
Save arikfr/49df57970d999b32e13e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_1025.json
{
"columns": [
{
"name": "action",
"type": null,
"friendly_name": "action"
},
{
"name": "count",
"type": "integer",
"friendly_name": "count"
}
],
"rows": [
{
"count": 14041,
"action": "view_source"
},
{
"count": 12795,
"action": "pivot"
},
{
"count": 7025,
"action": "execute"
},
{
"count": 5399,
"action": "login"
},
{
"count": 3704,
"action": "autorefresh"
},
{
"count": 2858,
"action": "update_data_source"
},
{
"count": 2263,
"action": "execute_query"
},
{
"count": 1369,
"action": "create"
},
{
"count": 1088,
"action": "search"
},
{
"count": 541,
"action": "fork"
}
]
}
Raw
query_1026.json
{
"columns": [
{
"name": "lat",
"type": "string",
"friendly_name": "lat"
},
{
"name": "lon",
"type": "string",
"friendly_name": "lon"
},
{
"name": "total",
"type": "integer",
"friendly_name": "total"
},
{
"name": "series",
"type": "string",
"friendly_name": "series"
}
],
"rows": [
{
"lon": "-77.0364",
"total": 56725,
"series": ">50000",
"lat": "38.8951"
},
{
"lon": "-86.7489",
"total": 32862,
"series": ">10000",
"lat": "35.7449"
},
{
"lon": "-92.3809",
"total": 25719,
"series": ">10000",
"lat": "34.9513"
},
{
"lon": "77.2167",
"total": 17455,
"series": ">10000",
"lat": "28.6667"
},
{
"lon": "6.14811",
"total": 13019,
"series": ">10000",
"lat": "46.1956"
},
{
"lon": "-87.6501",
"total": 10895,
"series": ">10000",
"lat": "41.85"
},
{
"lon": "13.4",
"total": 10575,
"series": ">10000",
"lat": "52.5167"
},
{
"lon": "34.3333",
"total": 10461,
"series": ">10000",
"lat": "31.4167"
},
{
"lon": "-152.268",
"total": 10438,
"series": ">10000",
"lat": "61.385"
},
{
"lon": "23.7333",
"total": 9983,
"series": ">5000",
"lat": "37.9833"
},
{
"lon": "102",
"total": 9654,
"series": ">5000",
"lat": "0"
},
{
"lon": "-117.122",
"total": 8453,
"series": ">5000",
"lat": "38.4199"
},
{
"lon": "-118.327",
"total": 7928,
"series": ">5000",
"lat": "34.0983"
},
{
"lon": "16.3667",
"total": 6495,
"series": ">5000",
"lat": "48.2"
},
{
"lon": "-84.6514",
"total": 6332,
"series": ">5000",
"lat": "37.669"
},
{
"lon": "115",
"total": 6257,
"series": ">5000",
"lat": "15"
},
{
"lon": "2.18333",
"total": 6071,
"series": ">5000",
"lat": "41.3833"
},
{
"lon": "46.7728",
"total": 5051,
"series": ">5000",
"lat": "24.6408"
},
{
"lon": "-97.6475",
"total": 81972,
"series": ">50000",
"lat": "31.106"
},
{
"lon": "-81.717",
"total": 44243,
"series": ">10000",
"lat": "27.8333"
},
{
"lon": "-96.9247",
"total": 39732,
"series": ">10000",
"lat": "35.5376"
},
{
"lon": "116.388",
"total": 33900,
"series": ">10000",
"lat": "39.9289"
},
{
"lon": "37.6156",
"total": 31789,
"series": ">10000",
"lat": "55.7522"
},
{
"lon": "-0.116667",
"total": 30190,
"series": ">10000",
"lat": "51.5"
},
{
"lon": "-82.7755",
"total": 19163,
"series": ">10000",
"lat": "40.3736"
},
{
"lon": "12.4833",
"total": 16849,
"series": ">10000",
"lat": "41.9"
},
{
"lon": "-105.327",
"total": 15818,
"series": ">10000",
"lat": "39.0646"
},
{
"lon": "-93.214",
"total": 13236,
"series": ">10000",
"lat": "42.0046"
},
{
"lon": "35.2333",
"total": 12699,
"series": ">10000",
"lat": "31.7667"
},
{
"lon": "106.829",
"total": 11889,
"series": ">10000",
"lat": "-6.17444"
},
{
"lon": "-80.1937",
"total": 11171,
"series": ">10000",
"lat": "25.7743"
},
{
"lon": "-71.5653",
"total": 9958,
"series": ">5000",
"lat": "43.4108"
},
{
"lon": "111.117",
"total": 9636,
"series": ">5000",
"lat": "22.2"
},
{
"lon": "9.2",
"total": 9177,
"series": ">5000",
"lat": "45.4667"
},
{
"lon": "-3.68333",
"total": 8878,
"series": ">5000",
"lat": "40.4"
},
{
"lon": "-122.419",
"total": 8118,
"series": ">5000",
"lat": "37.7749"
},
{
"lon": "-77.264",
"total": 8011,
"series": ">5000",
"lat": "40.5773"
},
{
"lon": "51.5148",
"total": 6061,
"series": ">5000",
"lat": "35.75"
},
{
"lon": "-112.074",
"total": 5966,
"series": ">5000",
"lat": "33.4484"
},
{
"lon": "32.8644",
"total": 5815,
"series": ">5000",
"lat": "39.9272"
},
{
"lon": "-91.8749",
"total": 5381,
"series": ">5000",
"lat": "31.1801"
},
{
"lon": "-72",
"total": 5237,
"series": ">5000",
"lat": "47.5"
},
{
"lon": "11.5833",
"total": 5053,
"series": ">5000",
"lat": "48.15"
},
{
"lon": "127",
"total": 5030,
"series": ">5000",
"lat": "37.5664"
},
{
"lon": "-86.2604",
"total": 5017,
"series": ">5000",
"lat": "39.8647"
},
{
"lon": "0",
"total": 54711,
"series": ">50000",
"lat": "0"
},
{
"lon": "-72.7093",
"total": 45588,
"series": ">10000",
"lat": "44.0407"
},
{
"lon": "-74.9384",
"total": 43108,
"series": ">10000",
"lat": "42.1497"
},
{
"lon": "-119.746",
"total": 22747,
"series": ">10000",
"lat": "36.17"
},
{
"lon": "4.33333",
"total": 12320,
"series": ">10000",
"lat": "50.8333"
},
{
"lon": "-84.5603",
"total": 11203,
"series": ">10000",
"lat": "43.3504"
},
{
"lon": "-80.9066",
"total": 11200,
"series": ">10000",
"lat": "33.8191"
},
{
"lon": "55.28",
"total": 10355,
"series": ">10000",
"lat": "25.2522"
},
{
"lon": "139.751",
"total": 7958,
"series": ">5000",
"lat": "35.685"
},
{
"lon": "72.8258",
"total": 7714,
"series": ">5000",
"lat": "18.975"
},
{
"lon": "31.25",
"total": 6362,
"series": ">5000",
"lat": "30.05"
},
{
"lon": "-75.1638",
"total": 5872,
"series": ">5000",
"lat": "39.9523"
},
{
"lon": "120.55",
"total": 5537,
"series": ">5000",
"lat": "16.45"
},
{
"lon": "-111.388",
"total": 5454,
"series": ">5000",
"lat": "33.7712"
},
{
"lon": "129.336",
"total": 5033,
"series": ">5000",
"lat": "42.7683"
},
{
"lon": "-78.2057",
"total": 55219,
"series": ">50000",
"lat": "37.768"
},
{
"lon": "-86.8073",
"total": 35547,
"series": ">10000",
"lat": "32.799"
},
{
"lon": "-71.5314",
"total": 34879,
"series": ">10000",
"lat": "42.2373"
},
{
"lon": "-93.9196",
"total": 30031,
"series": ">10000",
"lat": "45.7326"
},
{
"lon": "121.458",
"total": 19247,
"series": ">10000",
"lat": "31.2222"
},
{
"lon": "5.73333",
"total": 14658,
"series": ">10000",
"lat": "45.6333"
},
{
"lon": "151.217",
"total": 14085,
"series": ">10000",
"lat": "-33.8833"
},
{
"lon": "28.9647",
"total": 13948,
"series": ">10000",
"lat": "41.0186"
},
{
"lon": "-71.0598",
"total": 13024,
"series": ">10000",
"lat": "42.3584"
},
{
"lon": "77.2",
"total": 10912,
"series": ">10000",
"lat": "28.6"
},
{
"lon": "-95.3633",
"total": 10437,
"series": ">10000",
"lat": "29.7633"
},
{
"lon": "-74.5089",
"total": 9383,
"series": ">5000",
"lat": "40.314"
},
{
"lon": "125.755",
"total": 9367,
"series": ">5000",
"lat": "39.0194"
},
{
"lon": "30.5167",
"total": 8446,
"series": ">5000",
"lat": "50.4333"
},
{
"lon": "113.25",
"total": 8007,
"series": ">5000",
"lat": "23.1167"
},
{
"lon": "-89.0022",
"total": 6440,
"series": ">5000",
"lat": "40.3363"
},
{
"lon": "-79.4167",
"total": 6171,
"series": ">5000",
"lat": "43.6667"
},
{
"lon": "26.1",
"total": 5980,
"series": ">5000",
"lat": "44.4333"
},
{
"lon": "-46.6167",
"total": 5589,
"series": ">5000",
"lat": "-23.5333"
},
{
"lon": "144.967",
"total": 5580,
"series": ">5000",
"lat": "-37.8167"
},
{
"lon": "-96.8067",
"total": 5103,
"series": ">5000",
"lat": "32.7831"
},
{
"lon": "-89.6385",
"total": 5005,
"series": ">5000",
"lat": "44.2563"
}
]
}
Raw
query_67.json
{
"columns": [
{
"name": "date",
"type": "date",
"friendly_name": "date"
},
{
"name": "day_number",
"type": "integer",
"friendly_name": "day_number"
},
{
"name": "value",
"type": "integer",
"friendly_name": "value"
},
{
"name": "total",
"type": "integer",
"friendly_name": "total"
}
],
"rows": [
{
"value": 40832,
"total": 53141,
"day_number": 0,
"date": "2014-01-30"
},
{
"value": 27296,
"total": 53141,
"day_number": 1,
"date": "2014-01-30"
},
{
"value": 22982,
"total": 53141,
"day_number": 2,
"date": "2014-01-30"
},
{
"value": 21397,
"total": 53141,
"day_number": 3,
"date": "2014-01-30"
},
{
"value": 19870,
"total": 53141,
"day_number": 4,
"date": "2014-01-30"
},
{
"value": 25843,
"total": 34361,
"day_number": 0,
"date": "2014-01-31"
},
{
"value": 16839,
"total": 34361,
"day_number": 1,
"date": "2014-01-31"
},
{
"value": 14287,
"total": 34361,
"day_number": 2,
"date": "2014-01-31"
},
{
"value": 13028,
"total": 34361,
"day_number": 3,
"date": "2014-01-31"
},
{
"value": 24137,
"total": 32614,
"day_number": 0,
"date": "2014-02-01"
},
{
"value": 15818,
"total": 32614,
"day_number": 1,
"date": "2014-02-01"
},
{
"value": 13398,
"total": 32614,
"day_number": 2,
"date": "2014-02-01"
},
{
"value": 25806,
"total": 34967,
"day_number": 0,
"date": "2014-02-02"
},
{
"value": 16184,
"total": 34967,
"day_number": 1,
"date": "2014-02-02"
},
{
"value": 26318,
"total": 35045,
"day_number": 0,
"date": "2014-02-03"
}
]
}
Raw
query_867.json
{
"columns": [
{
"name": "created_at",
"type": "date",
"friendly_name": "created_at"
},
{
"name": "action",
"type": null,
"friendly_name": "action"
},
{
"name": "count",
"type": "integer",
"friendly_name": "count"
}
],
"rows": [
{
"created_at": "2016-02-13",
"count": 7,
"action": "view"
},
{
"created_at": "2016-02-14",
"count": 8,
"action": "view"
},
{
"created_at": "2016-02-14",
"count": 2,
"action": "subscribe"
},
{
"created_at": "2016-02-14",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-02-15",
"count": 16,
"action": "view"
},
{
"created_at": "2016-02-15",
"count": 2,
"action": "subscribe"
},
{
"created_at": "2016-02-15",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-02-15",
"count": 2,
"action": "edit_name"
},
{
"created_at": "2016-02-16",
"count": 18,
"action": "view"
},
{
"created_at": "2016-02-16",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-02-16",
"count": 2,
"action": "edit_name"
},
{
"created_at": "2016-02-17",
"count": 17,
"action": "view"
},
{
"created_at": "2016-02-17",
"count": 1,
"action": "subscribe"
},
{
"created_at": "2016-02-17",
"count": 4,
"action": "fork"
},
{
"created_at": "2016-02-17",
"count": 1,
"action": "edit_name"
},
{
"created_at": "2016-02-18",
"count": 14,
"action": "view"
},
{
"created_at": "2016-02-18",
"count": 4,
"action": "fork"
},
{
"created_at": "2016-02-19",
"count": 11,
"action": "view"
},
{
"created_at": "2016-02-19",
"count": 3,
"action": "subscribe"
},
{
"created_at": "2016-02-19",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-02-19",
"count": 1,
"action": "edit_name"
},
{
"created_at": "2016-02-20",
"count": 7,
"action": "view"
},
{
"created_at": "2016-02-21",
"count": 4,
"action": "view"
},
{
"created_at": "2016-02-21",
"count": 4,
"action": "fork"
},
{
"created_at": "2016-02-21",
"count": 9,
"action": "edit_name"
},
{
"created_at": "2016-02-22",
"count": 9,
"action": "view"
},
{
"created_at": "2016-02-22",
"count": 2,
"action": "subscribe"
},
{
"created_at": "2016-02-22",
"count": 3,
"action": "fork"
},
{
"created_at": "2016-02-23",
"count": 18,
"action": "view"
},
{
"created_at": "2016-02-23",
"count": 4,
"action": "fork"
},
{
"created_at": "2016-02-24",
"count": 26,
"action": "view"
},
{
"created_at": "2016-02-24",
"count": 9,
"action": "subscribe"
},
{
"created_at": "2016-02-24",
"count": 9,
"action": "fork"
},
{
"created_at": "2016-02-24",
"count": 7,
"action": "edit_name"
},
{
"created_at": "2016-02-25",
"count": 12,
"action": "view"
},
{
"created_at": "2016-02-25",
"count": 3,
"action": "fork"
},
{
"created_at": "2016-02-25",
"count": 1,
"action": "edit_name"
},
{
"created_at": "2016-02-26",
"count": 11,
"action": "view"
},
{
"created_at": "2016-02-26",
"count": 1,
"action": "subscribe"
},
{
"created_at": "2016-02-26",
"count": 2,
"action": "fork"
},
{
"created_at": "2016-02-27",
"count": 7,
"action": "view"
},
{
"created_at": "2016-02-28",
"count": 9,
"action": "view"
},
{
"created_at": "2016-02-28",
"count": 4,
"action": "subscribe"
},
{
"created_at": "2016-02-28",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-02-29",
"count": 18,
"action": "view"
},
{
"created_at": "2016-02-29",
"count": 3,
"action": "subscribe"
},
{
"created_at": "2016-03-01",
"count": 9,
"action": "view"
},
{
"created_at": "2016-03-01",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-03-01",
"count": 1,
"action": "edit_name"
},
{
"created_at": "2016-03-02",
"count": 14,
"action": "view"
},
{
"created_at": "2016-03-02",
"count": 1,
"action": "subscribe"
},
{
"created_at": "2016-03-02",
"count": 2,
"action": "fork"
},
{
"created_at": "2016-03-03",
"count": 13,
"action": "view"
},
{
"created_at": "2016-03-03",
"count": 9,
"action": "fork"
},
{
"created_at": "2016-03-04",
"count": 7,
"action": "view"
},
{
"created_at": "2016-03-04",
"count": 2,
"action": "edit_name"
},
{
"created_at": "2016-03-05",
"count": 3,
"action": "view"
},
{
"created_at": "2016-03-05",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-03-05",
"count": 3,
"action": "edit_name"
},
{
"created_at": "2016-03-06",
"count": 5,
"action": "view"
},
{
"created_at": "2016-03-06",
"count": 3,
"action": "subscribe"
},
{
"created_at": "2016-03-06",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-03-06",
"count": 1,
"action": "edit_name"
},
{
"created_at": "2016-03-07",
"count": 18,
"action": "view"
},
{
"created_at": "2016-03-07",
"count": 2,
"action": "subscribe"
},
{
"created_at": "2016-03-07",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-03-08",
"count": 16,
"action": "view"
},
{
"created_at": "2016-03-08",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-03-08",
"count": 2,
"action": "edit_name"
},
{
"created_at": "2016-03-09",
"count": 15,
"action": "view"
},
{
"created_at": "2016-03-09",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-03-09",
"count": 2,
"action": "edit_name"
},
{
"created_at": "2016-03-10",
"count": 15,
"action": "view"
},
{
"created_at": "2016-03-10",
"count": 2,
"action": "fork"
},
{
"created_at": "2016-03-10",
"count": 1,
"action": "edit_name"
},
{
"created_at": "2016-03-11",
"count": 11,
"action": "view"
},
{
"created_at": "2016-03-11",
"count": 2,
"action": "fork"
},
{
"created_at": "2016-03-11",
"count": 5,
"action": "edit_name"
},
{
"created_at": "2016-03-12",
"count": 5,
"action": "view"
},
{
"created_at": "2016-03-12",
"count": 1,
"action": "fork"
},
{
"created_at": "2016-03-13",
"count": 2,
"action": "view"
},
{
"created_at": "2016-03-14",
"count": 5,
"action": "view"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment