{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### New to Plotly?\n",
"Plotly's Python library is free and open source! [Get started](https://plotly.com/python/getting-started/) by downloading the client and [reading the primer](https://plotly.com/python/getting-started/).\n",
"
You can set up Plotly to work in [online](https://plotly.com/python/getting-started/#initialization-for-online-plotting) or [offline](https://plotly.com/python/getting-started/#initialization-for-offline-plotting) mode, or in [jupyter notebooks](https://plotly.com/python/getting-started/#start-plotting-online).\n",
"
We also have a quick-reference [cheatsheet](https://images.plot.ly/plotly-documentation/images/python_cheat_sheet.pdf) (new!) to help you get started!"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Version Check\n",
"Plotly's python package is updated frequently. Run `pip install plotly --upgrade` to use the latest version."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'2.2.3'"
]
},
"execution_count": 1,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import plotly\n",
"plotly.__version__"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Introduction"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Aggregates are a type of transform that can be applied to values in a given expression. Available aggregations are:\n",
"\n",
"Function | Description\n",
"------------- | -------------\n",
"`count` | Returns the quantity of items for each group.\n",
"`sum` | Returns the summation of all numeric values.\n",
"`avg` | Returns the average of all numeric values.\n",
"`median` | Returns the median of all numeric values.\n",
"`mode` | Returns the mode of all numeric values.\n",
"`rms` | Returns the rms of all numeric values.\n",
"`stddev` | Returns the standard deviation of all numeric values.\n",
"`min` | Returns the minimum numeric value for each group.\n",
"`max` | Returns the maximum numeric value for each group.\n",
"`first` | Returns the first numeric value for each group.\n",
"`last` | Returns the last numeric value for each group."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Basic Example"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"mode": "markers",
"transforms": [
{
"aggregations": [
{
"enabled": true,
"func": "sum",
"target": "y"
}
],
"groups": [
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly"
],
"type": "aggregate"
}
],
"type": "scatter",
"x": [
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly"
],
"y": [
1,
6,
2,
8,
2,
9,
4,
5,
1,
5,
2,
8
]
}
],
"layout": {}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import plotly.offline as off\n",
"\n",
"off.init_notebook_mode(connected=False)\n",
"\n",
"subject = ['Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly']\n",
"score = [1,6,2,8,2,9,4,5,1,5,2,8]\n",
"\n",
"data = [dict(\n",
" type = 'scatter',\n",
" x = subject,\n",
" y = score,\n",
" mode = 'markers',\n",
" transforms = [dict(\n",
" type = 'aggregate',\n",
" groups = subject,\n",
" aggregations = [dict(\n",
" target = 'y', func = 'sum', enabled = True),\n",
" ]\n",
" )]\n",
")]\n",
"\n",
"\n",
"off.iplot({'data': data}, validate=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Aggregate Functions"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"mode": "markers",
"transforms": [
{
"aggregations": [
{
"enabled": true,
"func": "sum",
"target": "y"
}
],
"groups": [
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly"
],
"type": "aggregate"
}
],
"type": "scatter",
"x": [
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly",
"Moe",
"Larry",
"Curly"
],
"y": [
1,
6,
2,
8,
2,
9,
4,
5,
1,
5,
2,
8
]
}
],
"layout": {
"title": "Plotly Aggregations
use dropdown to change aggregation",
"updatemenus": [
{
"active": 1,
"buttons": [
{
"args": [
"transforms[0].aggregations[0].func",
"count"
],
"label": "count",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"sum"
],
"label": "sum",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"avg"
],
"label": "avg",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"median"
],
"label": "median",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"mode"
],
"label": "mode",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"rms"
],
"label": "rms",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"stddev"
],
"label": "stddev",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"min"
],
"label": "min",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"max"
],
"label": "max",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"first"
],
"label": "first",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"last"
],
"label": "last",
"method": "restyle"
}
],
"showactive": false,
"x": 0.85,
"xref": "paper",
"y": 1.15,
"yanchor": "top",
"yref": "paper"
}
],
"xaxis": {
"title": "Subject"
},
"yaxis": {
"range": [
0,
22
],
"title": "Score"
}
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import plotly.offline as off\n",
"\n",
"off.init_notebook_mode(connected=False)\n",
"\n",
"subject = ['Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly','Moe','Larry','Curly']\n",
"score = [1,6,2,8,2,9,4,5,1,5,2,8]\n",
"\n",
"aggs = [\"count\",\"sum\",\"avg\",\"median\",\"mode\",\"rms\",\"stddev\",\"min\",\"max\",\"first\",\"last\"]\n",
"\n",
"agg = []\n",
"agg_func = []\n",
"for i in range(0, len(aggs)):\n",
" agg = dict(\n",
" args=['transforms[0].aggregations[0].func', aggs[i]],\n",
" label=aggs[i],\n",
" method='restyle'\n",
" )\n",
" agg_func.append(agg)\n",
"\n",
"\n",
"data = [dict(\n",
" type = 'scatter',\n",
" x = subject,\n",
" y = score,\n",
" mode = 'markers',\n",
" transforms = [dict(\n",
" type = 'aggregate',\n",
" groups = subject,\n",
" aggregations = [dict(\n",
" target = 'y', func = 'sum', enabled = True)\n",
" ]\n",
" )]\n",
")]\n",
"\n",
"layout = dict(\n",
" title = 'Plotly Aggregations
use dropdown to change aggregation',\n",
" xaxis = dict(title = 'Subject'),\n",
" yaxis = dict(title = 'Score', range = [0,22]),\n",
" updatemenus = [dict(\n",
" x = 0.85,\n",
" y = 1.15,\n",
" xref = 'paper',\n",
" yref = 'paper',\n",
" yanchor = 'top',\n",
" active = 1,\n",
" showactive = False,\n",
" buttons = agg_func\n",
" )]\n",
")\n",
"\n",
"off.iplot({'data': data,'layout': layout}, validate=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Histogram Binning"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"autobinx": false,
"autobiny": true,
"marker": {
"color": "rgb(68, 68, 68)"
},
"name": "date",
"type": "histogram",
"x": [
"1984-07-13",
"1984-07-13",
"1984-07-18",
"1984-07-20",
"1984-07-20",
"1984-07-21",
"1984-07-23",
"1984-07-24",
"1984-07-24",
"1984-07-27",
"1984-07-27",
"1984-07-29",
"1984-07-30",
"1984-08-04",
"1984-08-06",
"1984-08-06",
"1984-08-09",
"1984-08-19",
"1984-08-19",
"1984-08-21",
"1984-08-26",
"1984-08-26",
"1984-09-01",
"1984-09-02",
"1984-09-02",
"1984-09-02",
"1984-09-05",
"1984-09-07",
"1984-09-09",
"1984-09-09",
"1984-09-12",
"1984-09-12",
"1984-09-12",
"1984-09-14",
"1984-09-16",
"1984-09-17",
"1984-09-18",
"1984-09-20",
"1984-09-21",
"1984-09-23",
"1984-10-02",
"1984-10-02",
"1984-10-06",
"1984-10-15",
"1984-10-18",
"1984-10-21",
"1984-10-21",
"1984-10-25",
"1984-10-25",
"1984-10-26",
"1984-10-26",
"1984-10-27",
"1984-11-04",
"1984-11-06",
"1984-11-08",
"1984-11-09",
"1984-11-10",
"1984-11-13",
"1984-11-16",
"1984-11-19",
"1984-11-24",
"1984-11-26",
"1984-11-30",
"1984-12-02",
"1984-12-03",
"1984-12-05",
"1984-12-06",
"1984-12-13",
"1984-12-14",
"1984-12-17",
"1984-12-18",
"1984-12-18",
"1984-12-19",
"1984-12-19",
"1984-12-21",
"1984-12-21",
"1984-12-23",
"1984-12-26",
"1984-12-29",
"1984-12-30",
"1984-12-31",
"1984-12-31",
"1985-01-14",
"1985-01-16",
"1985-01-19",
"1985-01-19",
"1985-01-24",
"1985-01-26",
"1985-01-26",
"1985-01-27",
"1985-02-01",
"1985-02-02",
"1985-02-02",
"1985-02-03",
"1985-02-05",
"1985-02-09",
"1985-02-10",
"1985-02-10",
"1985-02-14",
"1985-02-14",
"1985-02-18",
"1985-02-24",
"1985-02-26",
"1985-02-28",
"1985-03-01",
"1985-03-01",
"1985-03-02",
"1985-03-04",
"1985-03-08",
"1985-03-09",
"1985-03-10",
"1985-03-12",
"1985-03-15",
"1985-03-19",
"1985-03-19",
"1985-03-21",
"1985-03-23",
"1985-03-23",
"1985-03-27",
"1985-03-27",
"1985-03-30",
"1985-03-31",
"1985-04-03",
"1985-04-04",
"1985-04-06",
"1985-04-06",
"1985-04-06",
"1985-04-09",
"1985-04-11",
"1985-04-12",
"1985-04-12",
"1985-04-15",
"1985-04-18",
"1985-04-19",
"1985-04-20",
"1985-04-23",
"1985-04-26",
"1985-04-28",
"1985-04-29",
"1985-05-02",
"1985-05-08",
"1985-05-09",
"1985-05-10",
"1985-05-13",
"1985-05-14",
"1985-05-16",
"1985-05-19",
"1985-05-20",
"1985-05-20",
"1985-05-21",
"1985-05-21",
"1985-05-23",
"1985-05-23",
"1985-05-24",
"1985-05-25",
"1985-05-27",
"1985-05-28",
"1985-05-29",
"1985-06-03",
"1985-06-03",
"1985-06-05",
"1985-06-06",
"1985-06-08",
"1985-06-09",
"1985-06-16",
"1985-06-18",
"1985-06-30",
"1985-06-30",
"1985-07-05",
"1985-07-05",
"1985-07-11",
"1985-07-12",
"1985-07-14",
"1985-07-16",
"1985-07-17",
"1985-07-20",
"1985-07-23",
"1985-07-23",
"1985-07-23",
"1985-07-28",
"1985-07-29",
"1985-08-01",
"1985-08-05",
"1985-08-05",
"1985-08-06",
"1985-08-09",
"1985-08-10",
"1985-08-14",
"1985-08-16",
"1985-08-21",
"1985-08-23",
"1985-08-25",
"1985-08-26",
"1985-08-28",
"1985-08-29",
"1985-08-30",
"1985-08-31",
"1985-09-03",
"1985-09-05",
"1985-09-06",
"1985-09-07",
"1985-09-08",
"1985-09-13",
"1985-09-13",
"1985-09-14",
"1985-09-14",
"1985-09-16",
"1985-09-19",
"1985-09-21",
"1985-09-22",
"1985-09-27",
"1985-09-27",
"1985-09-30",
"1985-10-02",
"1985-10-08",
"1985-10-10",
"1985-10-11",
"1985-10-12",
"1985-10-14",
"1985-10-17",
"1985-10-17",
"1985-10-31",
"1985-11-01",
"1985-11-05",
"1985-11-11",
"1985-11-12",
"1985-11-13",
"1985-11-15",
"1985-11-18",
"1985-11-23",
"1985-11-26",
"1985-11-26",
"1985-11-28",
"1985-12-04",
"1985-12-08",
"1985-12-10",
"1985-12-12",
"1985-12-13",
"1985-12-13",
"1985-12-17",
"1985-12-18",
"1985-12-28",
"1985-12-30",
"1986-01-01",
"1986-01-01",
"1986-01-03",
"1986-01-03",
"1986-01-07",
"1986-01-08",
"1986-01-13",
"1986-01-15",
"1986-01-19",
"1986-01-19",
"1986-01-19",
"1986-01-21",
"1986-01-21",
"1986-01-22",
"1986-01-22",
"1986-01-23",
"1986-01-23",
"1986-01-26",
"1986-01-26",
"1986-01-28",
"1986-01-31",
"1986-01-31",
"1986-02-01",
"1986-02-04",
"1986-02-05",
"1986-02-05",
"1986-02-06",
"1986-02-06",
"1986-02-08",
"1986-02-08",
"1986-02-08",
"1986-02-09",
"1986-02-12",
"1986-02-12",
"1986-02-16",
"1986-02-17",
"1986-02-19",
"1986-02-23",
"1986-02-23",
"1986-02-27",
"1986-03-03",
"1986-03-05",
"1986-03-15",
"1986-03-20",
"1986-03-23",
"1986-03-31",
"1986-04-03",
"1986-04-03",
"1986-04-05",
"1986-04-05",
"1986-04-09",
"1986-04-11",
"1986-04-11",
"1986-04-12",
"1986-04-17",
"1986-04-17",
"1986-04-17",
"1986-04-18",
"1986-04-27",
"1986-05-04",
"1986-05-07",
"1986-05-08",
"1986-05-08",
"1986-05-09",
"1986-05-10",
"1986-05-15",
"1986-05-16",
"1986-05-23",
"1986-05-25",
"1986-05-27",
"1986-05-29",
"1986-06-03",
"1986-06-03",
"1986-06-04",
"1986-06-05",
"1986-06-05",
"1986-06-09",
"1986-06-12",
"1986-06-14",
"1986-06-15",
"1986-06-17",
"1986-06-18",
"1986-06-25",
"1986-06-25",
"1986-06-27",
"1986-06-28",
"1986-07-05",
"1986-07-09",
"1986-07-13",
"1986-07-14",
"1986-07-17",
"1986-07-20",
"1986-07-21",
"1986-07-24",
"1986-07-24",
"1986-07-24",
"1986-07-27",
"1986-07-29",
"1986-07-31",
"1986-07-31",
"1986-07-31",
"1986-08-01",
"1986-08-04",
"1986-08-08",
"1986-08-15",
"1986-08-16",
"1986-08-16",
"1986-08-16",
"1986-08-21",
"1986-08-23",
"1986-08-27",
"1986-08-28",
"1986-09-03",
"1986-09-03",
"1986-09-04",
"1986-09-05",
"1986-09-13",
"1986-09-14",
"1986-09-14",
"1986-09-20",
"1986-09-22",
"1986-09-22",
"1986-09-23",
"1986-09-27",
"1986-09-27",
"1986-09-28",
"1986-10-04",
"1986-10-06",
"1986-10-07",
"1986-10-12",
"1986-10-14",
"1986-10-17",
"1986-10-22",
"1986-10-25",
"1986-10-28",
"1986-10-31",
"1986-11-02",
"1986-11-03",
"1986-11-06",
"1986-11-06",
"1986-11-08",
"1986-11-10",
"1986-11-10",
"1986-11-12",
"1986-11-14",
"1986-11-15",
"1986-11-17",
"1986-11-21",
"1986-11-21",
"1986-11-24",
"1986-11-28",
"1986-12-04",
"1986-12-05",
"1986-12-07",
"1986-12-08",
"1986-12-10",
"1986-12-12",
"1986-12-12",
"1986-12-12",
"1986-12-12",
"1986-12-15",
"1986-12-20",
"1987-01-01",
"1987-01-02",
"1987-01-02",
"1987-01-02",
"1987-01-06",
"1987-01-10",
"1987-01-12",
"1987-01-12",
"1987-01-12",
"1987-01-13",
"1987-01-14",
"1987-01-15",
"1987-01-15",
"1987-01-17",
"1987-01-21",
"1987-01-22",
"1987-01-23",
"1987-01-24",
"1987-01-27",
"1987-01-28",
"1987-01-30",
"1987-02-02",
"1987-02-02",
"1987-02-02",
"1987-02-06",
"1987-02-08",
"1987-02-10",
"1987-02-11",
"1987-02-13",
"1987-02-16",
"1987-02-19",
"1987-02-22",
"1987-02-23",
"1987-02-25",
"1987-02-27",
"1987-03-02",
"1987-03-03",
"1987-03-03",
"1987-03-10",
"1987-03-10",
"1987-03-10",
"1987-03-10",
"1987-03-11",
"1987-03-14",
"1987-03-15",
"1987-03-16",
"1987-03-17",
"1987-03-18",
"1987-03-19",
"1987-03-24",
"1987-03-25",
"1987-03-25",
"1987-03-28",
"1987-03-28",
"1987-03-28",
"1987-04-02",
"1987-04-03",
"1987-04-06",
"1987-04-10",
"1987-04-10",
"1987-04-12",
"1987-04-12",
"1987-04-12",
"1987-04-13",
"1987-04-15",
"1987-04-16",
"1987-04-16",
"1987-04-22",
"1987-04-23",
"1987-04-23",
"1987-05-03",
"1987-05-07",
"1987-05-08",
"1987-05-09",
"1987-05-11",
"1987-05-11",
"1987-05-15",
"1987-06-01",
"1987-06-02",
"1987-06-03",
"1987-06-04",
"1987-06-07",
"1987-06-08",
"1987-06-14",
"1987-06-14",
"1987-06-15",
"1987-06-17",
"1987-06-19",
"1987-06-21",
"1987-06-22",
"1987-06-24",
"1987-06-24",
"1987-07-01",
"1987-07-02",
"1987-07-04",
"1987-07-09",
"1987-07-09",
"1987-07-09",
"1987-07-16",
"1987-07-19",
"1987-07-21",
"1987-07-22",
"1987-07-26",
"1987-07-26",
"1987-07-30",
"1987-07-30",
"1987-08-13",
"1987-08-13",
"1987-08-17",
"1987-08-18",
"1987-08-20",
"1987-08-28",
"1987-09-01",
"1987-09-03",
"1987-09-04",
"1987-09-06",
"1987-09-07",
"1987-09-09",
"1987-09-11",
"1987-09-11",
"1987-09-15",
"1987-09-19",
"1987-09-20",
"1987-09-21",
"1987-09-22",
"1987-09-22",
"1987-09-22",
"1987-09-22",
"1987-09-24",
"1987-09-26",
"1987-09-29",
"1987-09-30",
"1987-09-30",
"1987-09-30",
"1987-10-01",
"1987-10-02",
"1987-10-09",
"1987-10-10",
"1987-10-10",
"1987-10-11",
"1987-10-14",
"1987-10-20",
"1987-10-22",
"1987-10-23",
"1987-10-26",
"1987-10-26",
"1987-10-27",
"1987-10-28",
"1987-11-02",
"1987-11-02",
"1987-11-03",
"1987-11-04",
"1987-11-05",
"1987-11-14",
"1987-11-14",
"1987-11-14",
"1987-11-18",
"1987-11-21",
"1987-11-23",
"1987-11-25",
"1987-11-26",
"1987-11-27",
"1987-11-28",
"1987-11-30",
"1987-12-05",
"1987-12-10",
"1987-12-15",
"1987-12-19",
"1987-12-19",
"1987-12-27",
"1987-12-27",
"1987-12-30",
"1988-01-05",
"1988-01-07",
"1988-01-09",
"1988-01-14",
"1988-01-15",
"1988-01-17",
"1988-01-18",
"1988-01-19",
"1988-01-21",
"1988-01-21",
"1988-01-23",
"1988-01-26",
"1988-01-28",
"1988-01-31",
"1988-02-01",
"1988-02-01",
"1988-02-03",
"1988-02-05",
"1988-02-06",
"1988-02-07",
"1988-02-09",
"1988-02-10",
"1988-02-12",
"1988-02-12",
"1988-02-13",
"1988-02-16",
"1988-02-17",
"1988-02-18",
"1988-02-18",
"1988-02-26",
"1988-02-26",
"1988-03-02",
"1988-03-14",
"1988-03-18",
"1988-03-21",
"1988-03-22",
"1988-03-27",
"1988-03-31",
"1988-03-31",
"1988-04-09",
"1988-04-09",
"1988-04-13",
"1988-04-13",
"1988-04-22",
"1988-04-27",
"1988-05-07",
"1988-05-07",
"1988-05-08",
"1988-05-09",
"1988-05-09",
"1988-05-12",
"1988-05-19",
"1988-05-20",
"1988-05-21",
"1988-05-27",
"1988-05-29",
"1988-06-05",
"1988-06-07",
"1988-06-08",
"1988-06-10",
"1988-06-14",
"1988-06-16",
"1988-06-19",
"1988-06-21",
"1988-06-21",
"1988-06-22",
"1988-06-22",
"1988-06-28",
"1988-06-28",
"1988-06-30",
"1988-06-30",
"1988-07-03",
"1988-07-03",
"1988-07-03",
"1988-07-05",
"1988-07-05",
"1988-07-07",
"1988-07-08",
"1988-07-13",
"1988-07-20",
"1988-07-21",
"1988-07-22",
"1988-07-23",
"1988-07-24",
"1988-07-25",
"1988-07-26",
"1988-07-30",
"1988-08-02",
"1988-08-02",
"1988-08-02",
"1988-08-05",
"1988-08-09",
"1988-08-12",
"1988-08-16",
"1988-08-16",
"1988-08-16",
"1988-08-20",
"1988-08-22",
"1988-08-23",
"1988-08-23",
"1988-08-26",
"1988-08-29",
"1988-09-01",
"1988-09-03",
"1988-09-06",
"1988-09-07",
"1988-09-08",
"1988-09-09",
"1988-09-10",
"1988-09-15",
"1988-09-15",
"1988-09-17",
"1988-09-17",
"1988-09-17",
"1988-09-19",
"1988-09-20",
"1988-09-21",
"1988-09-21",
"1988-09-22",
"1988-09-22",
"1988-09-23",
"1988-09-30",
"1988-09-30",
"1988-10-01",
"1988-10-05",
"1988-10-06",
"1988-10-07",
"1988-10-11",
"1988-10-16",
"1988-10-17",
"1988-10-17",
"1988-10-18",
"1988-10-18",
"1988-10-18",
"1988-10-24",
"1988-10-24",
"1988-10-24",
"1988-10-24",
"1988-10-24",
"1988-10-27",
"1988-10-28",
"1988-10-28",
"1988-10-28",
"1988-10-29",
"1988-11-01",
"1988-11-02",
"1988-11-03",
"1988-11-04",
"1988-11-05",
"1988-11-07",
"1988-11-07",
"1988-11-09",
"1988-11-10",
"1988-11-16",
"1988-11-16",
"1988-11-16",
"1988-11-19",
"1988-11-21",
"1988-11-22",
"1988-11-23",
"1988-11-28",
"1988-11-28",
"1988-11-28",
"1988-11-29",
"1988-12-02",
"1988-12-03",
"1988-12-04",
"1988-12-06",
"1988-12-12",
"1988-12-12",
"1988-12-12",
"1988-12-13",
"1988-12-14",
"1988-12-15",
"1988-12-21",
"1988-12-25",
"1988-12-26",
"1988-12-27",
"1988-12-29",
"1988-12-30",
"1989-01-01",
"1989-01-02",
"1989-01-02",
"1989-01-04",
"1989-01-04",
"1989-01-04",
"1989-01-06",
"1989-01-10",
"1989-01-10",
"1989-01-13",
"1989-01-14",
"1989-01-17",
"1989-01-20",
"1989-01-20",
"1989-01-25",
"1989-01-27",
"1989-01-29",
"1989-01-29",
"1989-02-02",
"1989-02-06",
"1989-02-08",
"1989-02-10",
"1989-02-11",
"1989-02-11",
"1989-02-14",
"1989-02-15",
"1989-02-15",
"1989-02-18",
"1989-02-20",
"1989-02-20",
"1989-02-22",
"1989-02-24",
"1989-02-25",
"1989-02-26",
"1989-02-27",
"1989-03-02",
"1989-03-03",
"1989-03-03",
"1989-03-04",
"1989-03-09",
"1989-03-12",
"1989-03-12",
"1989-03-12",
"1989-03-15",
"1989-03-15",
"1989-03-22",
"1989-03-22",
"1989-03-25",
"1989-03-27",
"1989-03-28",
"1989-03-28",
"1989-03-28",
"1989-03-31",
"1989-03-31",
"1989-04-01",
"1989-04-12",
"1989-04-12",
"1989-04-14",
"1989-04-15",
"1989-04-20",
"1989-04-29",
"1989-05-02",
"1989-05-05",
"1989-05-08",
"1989-05-08",
"1989-05-16",
"1989-05-17",
"1989-05-21",
"1989-05-21",
"1989-05-25",
"1989-05-25",
"1989-05-27",
"1989-05-28",
"1989-06-01",
"1989-06-01",
"1989-06-02",
"1989-06-06",
"1989-06-06",
"1989-06-07",
"1989-06-09",
"1989-06-09",
"1989-06-21",
"1989-06-22",
"1989-06-24",
"1989-06-25",
"1989-06-27",
"1989-06-30",
"1989-06-30",
"1989-07-02",
"1989-07-02",
"1989-07-02",
"1989-07-06",
"1989-07-07",
"1989-07-11",
"1989-07-11",
"1989-07-15",
"1989-07-18",
"1989-07-25",
"1989-07-28",
"1989-07-28",
"1989-08-01",
"1989-08-03",
"1989-08-03",
"1989-08-07",
"1989-08-08",
"1989-08-14",
"1989-08-17",
"1989-08-18",
"1989-08-19",
"1989-08-19",
"1989-08-20",
"1989-08-22",
"1989-08-22",
"1989-08-22",
"1989-08-24",
"1989-08-27",
"1989-08-29",
"1989-09-02",
"1989-09-06",
"1989-09-07",
"1989-09-08",
"1989-09-09",
"1989-09-11",
"1989-09-12",
"1989-09-15",
"1989-09-16",
"1989-09-17",
"1989-09-22",
"1989-09-23",
"1989-09-26",
"1989-10-01",
"1989-10-08",
"1989-10-09",
"1989-10-10",
"1989-10-14",
"1989-10-14",
"1989-10-16",
"1989-10-17",
"1989-10-17",
"1989-10-19",
"1989-10-20",
"1989-10-20",
"1989-10-22",
"1989-10-22",
"1989-10-23",
"1989-10-26",
"1989-10-27",
"1989-10-27",
"1989-10-27",
"1989-11-04",
"1989-11-05",
"1989-11-07",
"1989-11-10",
"1989-11-11",
"1989-11-13",
"1989-11-13",
"1989-11-14",
"1989-11-15",
"1989-11-16",
"1989-11-19",
"1989-11-19",
"1989-11-22",
"1989-11-24",
"1989-11-29",
"1989-11-30",
"1989-12-03",
"1989-12-06",
"1989-12-06",
"1989-12-09",
"1989-12-12",
"1989-12-15",
"1989-12-15",
"1989-12-23",
"1989-12-23",
"1989-12-23",
"1989-12-27",
"1989-12-29",
"1990-01-02",
"1990-01-02",
"1990-01-02",
"1990-01-05",
"1990-01-06",
"1990-01-09",
"1990-01-12",
"1990-01-13",
"1990-01-14",
"1990-01-15",
"1990-01-17",
"1990-01-24",
"1990-01-25",
"1990-01-26",
"1990-01-27",
"1990-02-04",
"1990-02-10",
"1990-02-14",
"1990-02-15",
"1990-02-17",
"1990-02-22",
"1990-02-24",
"1990-03-05",
"1990-03-05",
"1990-03-05",
"1990-03-06",
"1990-03-17",
"1990-03-19",
"1990-03-19",
"1990-03-20",
"1990-03-22",
"1990-03-29",
"1990-04-09",
"1990-04-10",
"1990-04-11",
"1990-04-11",
"1990-04-11",
"1990-04-13",
"1990-04-14",
"1990-04-17",
"1990-04-17",
"1990-04-19",
"1990-04-27",
"1990-04-27",
"1990-04-28",
"1990-04-29",
"1990-05-05",
"1990-05-06",
"1990-05-06",
"1990-05-07",
"1990-05-09",
"1990-05-12",
"1990-05-12",
"1990-05-13",
"1990-05-13",
"1990-05-16",
"1990-05-19",
"1990-05-21",
"1990-05-26",
"1990-05-26",
"1990-05-28",
"1990-05-29",
"1990-05-30",
"1990-05-31",
"1990-05-31",
"1990-05-31",
"1990-06-04",
"1990-06-05",
"1990-06-07",
"1990-06-12",
"1990-06-14",
"1990-06-15",
"1990-06-16",
"1990-06-18",
"1990-06-19",
"1990-06-20",
"1990-06-21",
"1990-06-23",
"1990-06-26",
"1990-06-27",
"1990-06-28",
"1990-07-02",
"1990-07-04",
"1990-07-09",
"1990-07-21",
"1990-07-26",
"1990-07-26",
"1990-07-26",
"1990-07-26",
"1990-07-28",
"1990-07-29",
"1990-08-01",
"1990-08-01",
"1990-08-06",
"1990-08-12",
"1990-08-16",
"1990-08-17",
"1990-08-20",
"1990-08-22",
"1990-08-24",
"1990-08-26",
"1990-08-26",
"1990-08-30",
"1990-08-31",
"1990-08-31",
"1990-08-31",
"1990-09-05",
"1990-09-11",
"1990-09-13",
"1990-09-17",
"1990-09-25",
"1990-09-27",
"1990-09-29",
"1990-10-01",
"1990-10-02",
"1990-10-09",
"1990-10-14",
"1990-10-16",
"1990-10-19",
"1990-10-20",
"1990-10-23",
"1990-10-23",
"1990-10-25",
"1990-10-26",
"1990-10-30",
"1990-11-04",
"1990-11-13",
"1990-11-15",
"1990-11-15",
"1990-11-16",
"1990-11-16",
"1990-11-18",
"1990-11-22",
"1990-11-25",
"1990-11-26",
"1990-11-29",
"1990-12-02",
"1990-12-05",
"1990-12-14",
"1990-12-18",
"1990-12-25",
"1990-12-26",
"1990-12-31",
"1990-12-31",
"1991-01-04",
"1991-01-06",
"1991-01-07",
"1991-01-08",
"1991-01-08",
"1991-01-14",
"1991-01-18",
"1991-01-20",
"1991-01-23",
"1991-01-26",
"1991-01-26",
"1991-01-28",
"1991-02-04",
"1991-02-06",
"1991-02-06",
"1991-02-11",
"1991-02-13",
"1991-02-13",
"1991-02-26",
"1991-02-28",
"1991-03-01",
"1991-03-01",
"1991-03-05",
"1991-03-06",
"1991-03-06",
"1991-03-10",
"1991-03-13",
"1991-03-14",
"1991-03-17",
"1991-03-17",
"1991-03-17",
"1991-03-18",
"1991-03-19",
"1991-03-20",
"1991-03-22",
"1991-03-25",
"1991-04-04",
"1991-04-07",
"1991-04-11",
"1991-04-12",
"1991-04-12",
"1991-04-14",
"1991-04-15",
"1991-04-19",
"1991-04-20",
"1991-04-20",
"1991-04-21",
"1991-04-22",
"1991-04-23",
"1991-04-23",
"1991-04-25",
"1991-04-25",
"1991-04-27",
"1991-04-27",
"1991-04-27",
"1991-05-12",
"1991-05-19",
"1991-05-22",
"1991-05-23",
"1991-05-24",
"1991-05-26",
"1991-05-28",
"1991-06-05",
"1991-06-08",
"1991-06-10",
"1991-06-11",
"1991-06-11",
"1991-06-13",
"1991-06-13",
"1991-06-16",
"1991-06-18",
"1991-06-18",
"1991-06-21",
"1991-07-01",
"1991-07-06",
"1991-07-07",
"1991-07-10",
"1991-07-13",
"1991-07-21",
"1991-07-24",
"1991-07-24",
"1991-07-28",
"1991-08-01",
"1991-08-04",
"1991-08-13",
"1991-08-17",
"1991-08-18",
"1991-08-19",
"1991-08-22",
"1991-08-24",
"1991-08-28",
"1991-08-30",
"1991-08-31",
"1991-09-01",
"1991-09-04",
"1991-09-09",
"1991-09-11",
"1991-09-12",
"1991-09-14",
"1991-09-15",
"1991-09-17",
"1991-09-20",
"1991-09-22",
"1991-10-03",
"1991-10-09",
"1991-10-16",
"1991-10-19",
"1991-10-20",
"1991-10-21",
"1991-10-24",
"1991-10-28",
"1991-10-31",
"1991-11-04",
"1991-11-08",
"1991-11-12",
"1991-11-14",
"1991-11-17",
"1991-11-20",
"1991-11-22",
"1991-11-24",
"1991-11-28",
"1991-12-07",
"1991-12-10",
"1991-12-10",
"1991-12-10",
"1991-12-11",
"1991-12-11",
"1991-12-11",
"1991-12-14",
"1991-12-21",
"1991-12-28",
"1992-01-03",
"1992-01-05",
"1992-01-09",
"1992-01-10",
"1992-01-15",
"1992-01-17",
"1992-01-21",
"1992-01-22",
"1992-01-23",
"1992-01-26",
"1992-01-27",
"1992-01-30",
"1992-01-30",
"1992-01-31",
"1992-02-01",
"1992-02-01",
"1992-02-02",
"1992-02-04",
"1992-02-08",
"1992-02-12",
"1992-02-18",
"1992-02-29",
"1992-02-29",
"1992-03-06",
"1992-03-07",
"1992-03-14",
"1992-03-18",
"1992-03-21",
"1992-03-24",
"1992-03-25",
"1992-03-26",
"1992-03-26",
"1992-03-27",
"1992-03-31",
"1992-04-02",
"1992-04-08",
"1992-04-08",
"1992-04-10",
"1992-04-10",
"1992-04-12",
"1992-04-13",
"1992-04-14",
"1992-04-17",
"1992-04-20",
"1992-04-20",
"1992-04-22",
"1992-05-02",
"1992-05-02",
"1992-05-04",
"1992-05-08",
"1992-05-11",
"1992-05-12",
"1992-05-13",
"1992-05-13",
"1992-05-21",
"1992-05-29",
"1992-05-31",
"1992-05-31",
"1992-06-01",
"1992-06-07",
"1992-06-07",
"1992-06-08",
"1992-06-12",
"1992-06-16",
"1992-06-18",
"1992-06-18",
"1992-06-18",
"1992-06-19",
"1992-06-21",
"1992-06-25",
"1992-06-26",
"1992-06-30",
"1992-07-02",
"1992-07-03",
"1992-07-07",
"1992-07-08",
"1992-07-09",
"1992-07-10",
"1992-07-11",
"1992-07-16",
"1992-07-18",
"1992-07-22",
"1992-07-23",
"1992-08-05",
"1992-08-06",
"1992-08-11",
"1992-08-14",
"1992-08-22",
"1992-08-22",
"1992-08-23",
"1992-08-24",
"1992-08-26",
"1992-08-26",
"1992-08-26",
"1992-08-27",
"1992-08-30",
"1992-09-01",
"1992-09-02",
"1992-09-03",
"1992-09-11",
"1992-09-15",
"1992-09-18",
"1992-09-21",
"1992-09-22",
"1992-09-25",
"1992-09-25",
"1992-09-26",
"1992-09-26",
"1992-09-30",
"1992-10-01",
"1992-10-02",
"1992-10-02",
"1992-10-05",
"1992-10-09",
"1992-10-09",
"1992-10-09",
"1992-10-11",
"1992-10-12",
"1992-10-12",
"1992-10-13",
"1992-10-22",
"1992-10-23",
"1992-10-27",
"1992-11-05",
"1992-11-11",
"1992-11-12",
"1992-11-13",
"1992-11-14",
"1992-11-14",
"1992-11-17",
"1992-11-17",
"1992-11-17",
"1992-11-19",
"1992-11-20",
"1992-11-20",
"1992-11-21",
"1992-11-23",
"1992-11-23",
"1992-11-24",
"1992-11-27",
"1992-11-28",
"1992-12-01",
"1992-12-01",
"1992-12-07",
"1992-12-11",
"1992-12-16",
"1992-12-16",
"1992-12-18",
"1992-12-23",
"1992-12-24",
"1992-12-28",
"1992-12-28",
"1993-01-07",
"1993-01-15",
"1993-01-20",
"1993-01-22",
"1993-01-24",
"1993-01-27",
"1993-01-28",
"1993-01-29",
"1993-01-31",
"1993-02-02",
"1993-02-03",
"1993-02-05",
"1993-02-19",
"1993-02-19",
"1993-02-21",
"1993-02-21",
"1993-02-22",
"1993-02-23",
"1993-02-24",
"1993-02-26",
"1993-02-26",
"1993-02-28",
"1993-03-03",
"1993-03-06",
"1993-03-07",
"1993-03-09",
"1993-03-09",
"1993-03-10",
"1993-03-17",
"1993-03-22",
"1993-03-24",
"1993-03-24",
"1993-03-30",
"1993-03-31",
"1993-04-09",
"1993-04-14",
"1993-04-17",
"1993-04-22",
"1993-04-22",
"1993-04-23",
"1993-04-23",
"1993-04-23",
"1993-04-27",
"1993-05-08",
"1993-05-08",
"1993-05-09",
"1993-05-15",
"1993-05-15",
"1993-05-17",
"1993-05-20",
"1993-05-21",
"1993-05-23",
"1993-05-23",
"1993-05-24",
"1993-05-26",
"1993-05-29",
"1993-06-03",
"1993-06-08",
"1993-06-09",
"1993-06-11",
"1993-06-11",
"1993-06-13",
"1993-06-16",
"1993-06-16",
"1993-06-17",
"1993-06-17",
"1993-06-19",
"1993-06-22",
"1993-06-27",
"1993-07-01",
"1993-07-03",
"1993-07-03",
"1993-07-04",
"1993-07-06",
"1993-07-10",
"1993-07-13",
"1993-07-14",
"1993-07-14",
"1993-07-14",
"1993-07-16",
"1993-07-22",
"1993-07-22",
"1993-07-29",
"1993-07-31",
"1993-08-02",
"1993-08-07",
"1993-08-17",
"1993-08-24",
"1993-08-26",
"1993-08-27",
"1993-08-27",
"1993-08-30",
"1993-09-06",
"1993-09-07",
"1993-09-26",
"1993-10-01",
"1993-10-02",
"1993-10-03",
"1993-10-04",
"1993-10-04",
"1993-10-05",
"1993-10-05",
"1993-10-08",
"1993-10-09",
"1993-10-09",
"1993-10-10",
"1993-10-15",
"1993-10-20",
"1993-10-22",
"1993-10-24",
"1993-10-27",
"1993-10-27",
"1993-10-30",
"1993-11-05",
"1993-11-05",
"1993-11-09",
"1993-11-10",
"1993-11-14",
"1993-11-15",
"1993-11-16",
"1993-11-16",
"1993-11-19",
"1993-11-20",
"1993-11-20",
"1993-11-22",
"1993-11-26",
"1993-12-01",
"1993-12-01",
"1993-12-02",
"1993-12-07",
"1993-12-10",
"1993-12-13",
"1993-12-14",
"1993-12-15",
"1993-12-20",
"1993-12-25",
"1993-12-25",
"1993-12-27",
"1993-12-27",
"1993-12-31",
"1994-01-04",
"1994-01-05",
"1994-01-06",
"1994-01-07",
"1994-01-12",
"1994-01-14",
"1994-01-15",
"1994-01-16",
"1994-01-17",
"1994-01-20",
"1994-01-25",
"1994-01-25",
"1994-01-25",
"1994-01-25",
"1994-01-27",
"1994-01-27",
"1994-01-27",
"1994-01-31",
"1994-02-01",
"1994-02-03",
"1994-02-04",
"1994-02-05",
"1994-02-07",
"1994-02-14",
"1994-02-14",
"1994-02-18",
"1994-02-22",
"1994-02-24",
"1994-02-25",
"1994-02-25",
"1994-02-25",
"1994-02-28",
"1994-03-01",
"1994-03-05",
"1994-03-09",
"1994-03-11",
"1994-03-11",
"1994-03-11",
"1994-03-15",
"1994-03-18",
"1994-03-19",
"1994-03-25",
"1994-03-31",
"1994-04-05",
"1994-04-05",
"1994-04-10",
"1994-04-16",
"1994-04-18",
"1994-04-19",
"1994-04-20",
"1994-04-27",
"1994-04-28",
"1994-05-02",
"1994-05-02",
"1994-05-13",
"1994-05-14",
"1994-05-15",
"1994-05-16",
"1994-05-20",
"1994-05-21",
"1994-05-22",
"1994-05-25",
"1994-05-25",
"1994-05-26",
"1994-05-27",
"1994-05-30",
"1994-06-04",
"1994-06-09",
"1994-06-12",
"1994-06-14",
"1994-06-17",
"1994-06-21",
"1994-06-22",
"1994-06-28",
"1994-06-28",
"1994-06-29",
"1994-07-05",
"1994-07-11",
"1994-07-11",
"1994-07-12",
"1994-07-13",
"1994-07-17",
"1994-07-25",
"1994-07-28",
"1994-07-30",
"1994-07-31",
"1994-08-03",
"1994-08-14",
"1994-08-15",
"1994-08-15",
"1994-08-17",
"1994-08-18",
"1994-08-19",
"1994-08-19",
"1994-08-24",
"1994-08-26",
"1994-08-26",
"1994-08-26",
"1994-08-27",
"1994-09-02",
"1994-09-02",
"1994-09-02",
"1994-09-07",
"1994-09-07",
"1994-09-10",
"1994-09-11",
"1994-09-11",
"1994-09-11",
"1994-09-18",
"1994-09-18",
"1994-09-23",
"1994-09-26",
"1994-09-28",
"1994-09-29",
"1994-10-03",
"1994-10-03",
"1994-10-05",
"1994-10-11",
"1994-10-11",
"1994-10-11",
"1994-10-11",
"1994-10-20",
"1994-10-22",
"1994-10-23",
"1994-10-23",
"1994-10-28",
"1994-10-31",
"1994-11-01",
"1994-11-01",
"1994-11-04",
"1994-11-05",
"1994-11-07",
"1994-11-09",
"1994-11-12",
"1994-11-12",
"1994-11-13",
"1994-11-14",
"1994-11-17",
"1994-11-17",
"1994-11-18",
"1994-11-18",
"1994-11-20",
"1994-11-27",
"1994-11-30",
"1994-12-01",
"1994-12-02",
"1994-12-04",
"1994-12-06",
"1994-12-07",
"1994-12-07",
"1994-12-08",
"1994-12-08",
"1994-12-13",
"1994-12-13",
"1994-12-13",
"1994-12-16",
"1994-12-21",
"1994-12-29",
"1994-12-29",
"1994-12-30",
"1995-01-08",
"1995-01-11",
"1995-01-14",
"1995-01-15",
"1995-01-16",
"1995-01-18",
"1995-01-19",
"1995-01-21",
"1995-01-22",
"1995-01-22",
"1995-01-25",
"1995-01-30",
"1995-02-03",
"1995-02-05",
"1995-02-07",
"1995-02-07",
"1995-02-09",
"1995-02-10",
"1995-02-13",
"1995-02-14",
"1995-02-15",
"1995-02-22",
"1995-02-22",
"1995-02-25",
"1995-02-28",
"1995-03-02",
"1995-03-04",
"1995-03-05",
"1995-03-08",
"1995-03-11",
"1995-03-18",
"1995-03-19",
"1995-03-26",
"1995-03-29",
"1995-04-05",
"1995-04-05",
"1995-04-09",
"1995-04-10",
"1995-04-11",
"1995-04-12",
"1995-04-13",
"1995-04-13",
"1995-04-14",
"1995-04-14",
"1995-04-17",
"1995-04-20",
"1995-04-20",
"1995-04-26",
"1995-04-28",
"1995-04-30",
"1995-05-01",
"1995-05-03",
"1995-05-03",
"1995-05-04",
"1995-05-06",
"1995-05-06",
"1995-05-07",
"1995-05-09",
"1995-05-09",
"1995-05-11",
"1995-05-12",
"1995-05-12",
"1995-05-14",
"1995-05-18",
"1995-05-18",
"1995-05-22",
"1995-05-22",
"1995-05-23",
"1995-05-25",
"1995-05-28",
"1995-05-29",
"1995-05-30",
"1995-05-30",
"1995-06-01",
"1995-06-02",
"1995-06-02",
"1995-06-06",
"1995-06-06",
"1995-06-09",
"1995-06-13",
"1995-06-14",
"1995-06-18",
"1995-06-23",
"1995-06-25",
"1995-06-27",
"1995-06-30",
"1995-07-01",
"1995-07-04",
"1995-07-05",
"1995-07-08",
"1995-07-09",
"1995-07-10",
"1995-07-10",
"1995-07-19",
"1995-07-19",
"1995-07-22",
"1995-07-22",
"1995-07-25",
"1995-07-29",
"1995-07-31",
"1995-07-31",
"1995-08-03",
"1995-08-04",
"1995-08-04",
"1995-08-05",
"1995-08-05",
"1995-08-06",
"1995-08-06",
"1995-08-07",
"1995-08-15",
"1995-08-16",
"1995-08-17",
"1995-08-20",
"1995-08-22",
"1995-08-26",
"1995-08-26",
"1995-08-28",
"1995-08-28",
"1995-08-28",
"1995-09-03",
"1995-09-06",
"1995-09-07",
"1995-09-08",
"1995-09-11",
"1995-09-16",
"1995-09-16",
"1995-09-17",
"1995-09-22",
"1995-09-22",
"1995-09-25",
"1995-09-25",
"1995-09-28",
"1995-10-03",
"1995-10-04",
"1995-10-09",
"1995-10-10",
"1995-10-12",
"1995-10-16",
"1995-10-16",
"1995-10-17",
"1995-10-19",
"1995-10-28",
"1995-10-28",
"1995-10-30",
"1995-11-04",
"1995-11-04",
"1995-11-07",
"1995-11-11",
"1995-11-13",
"1995-11-15",
"1995-11-17",
"1995-11-22",
"1995-11-24",
"1995-11-24",
"1995-11-29",
"1995-12-08",
"1995-12-12",
"1995-12-13",
"1995-12-16",
"1995-12-17",
"1995-12-19",
"1995-12-24",
"1995-12-25",
"1996-01-02",
"1996-01-03",
"1996-01-06",
"1996-01-08",
"1996-01-08",
"1996-01-09",
"1996-01-17",
"1996-01-19",
"1996-01-19",
"1996-01-19",
"1996-01-20",
"1996-01-24",
"1996-01-27",
"1996-01-29",
"1996-02-09",
"1996-02-12",
"1996-02-12",
"1996-02-13",
"1996-02-13",
"1996-02-15",
"1996-02-17",
"1996-02-17",
"1996-02-18",
"1996-02-20",
"1996-02-25",
"1996-02-26",
"1996-02-26",
"1996-03-02",
"1996-03-09",
"1996-03-13",
"1996-03-14",
"1996-03-16",
"1996-03-20",
"1996-03-21",
"1996-03-23",
"1996-03-29",
"1996-03-30",
"1996-04-02",
"1996-04-04",
"1996-04-05",
"1996-04-10",
"1996-04-15",
"1996-04-15",
"1996-04-15",
"1996-04-17",
"1996-04-18",
"1996-04-19",
"1996-04-19",
"1996-05-03",
"1996-05-09",
"1996-05-11",
"1996-05-15",
"1996-05-17",
"1996-05-21",
"1996-05-22",
"1996-05-22",
"1996-05-23",
"1996-05-23",
"1996-05-24",
"1996-05-29",
"1996-05-29",
"1996-05-31",
"1996-06-04",
"1996-06-05",
"1996-06-08",
"1996-06-10",
"1996-06-13",
"1996-06-19",
"1996-06-23",
"1996-06-23",
"1996-06-26",
"1996-07-07",
"1996-07-13",
"1996-07-16",
"1996-07-17",
"1996-07-17",
"1996-07-18",
"1996-07-22",
"1996-07-22",
"1996-07-26",
"1996-07-26",
"1996-08-01",
"1996-08-07",
"1996-08-07",
"1996-08-09",
"1996-08-15",
"1996-08-26",
"1996-09-02",
"1996-09-07",
"1996-09-10",
"1996-09-12",
"1996-09-17",
"1996-09-19",
"1996-09-24",
"1996-09-26",
"1996-09-30",
"1996-10-01",
"1996-10-05",
"1996-10-05",
"1996-10-06",
"1996-10-09",
"1996-10-13",
"1996-10-13",
"1996-10-17",
"1996-10-17",
"1996-10-18",
"1996-10-26",
"1996-10-26",
"1996-10-26",
"1996-10-27",
"1996-10-30",
"1996-11-08",
"1996-11-15",
"1996-11-17",
"1996-11-20",
"1996-11-28",
"1996-12-12",
"1996-12-13",
"1996-12-14",
"1996-12-21",
"1996-12-21",
"1996-12-21",
"1996-12-22",
"1996-12-28",
"1996-12-30",
"1996-12-31",
"1997-01-05",
"1997-01-05",
"1997-01-10",
"1997-01-18",
"1997-01-18",
"1997-01-18",
"1997-01-23",
"1997-01-25",
"1997-01-28",
"1997-01-29",
"1997-01-29",
"1997-01-30",
"1997-02-05",
"1997-02-05",
"1997-02-07",
"1997-02-10",
"1997-02-11",
"1997-02-11",
"1997-02-12",
"1997-02-14",
"1997-02-14",
"1997-02-15",
"1997-02-16",
"1997-02-20",
"1997-02-21",
"1997-02-21",
"1997-02-22",
"1997-02-26",
"1997-02-27",
"1997-02-27",
"1997-02-27",
"1997-02-27",
"1997-03-04",
"1997-03-04",
"1997-03-07",
"1997-03-07",
"1997-03-08",
"1997-03-10",
"1997-03-10",
"1997-03-14",
"1997-03-15",
"1997-03-16",
"1997-03-21",
"1997-03-23",
"1997-03-23",
"1997-03-26",
"1997-03-27",
"1997-04-01",
"1997-04-01",
"1997-04-02",
"1997-04-06",
"1997-04-09",
"1997-04-09",
"1997-04-11",
"1997-04-15",
"1997-04-18",
"1997-04-24",
"1997-04-25",
"1997-04-25",
"1997-04-25",
"1997-04-28",
"1997-04-29",
"1997-04-30",
"1997-05-02",
"1997-05-04",
"1997-05-07",
"1997-05-07",
"1997-05-15",
"1997-05-19",
"1997-05-21",
"1997-05-21",
"1997-05-22",
"1997-05-27",
"1997-06-01",
"1997-06-01",
"1997-06-02",
"1997-06-04",
"1997-06-07",
"1997-06-08",
"1997-06-23",
"1997-06-26",
"1997-07-04",
"1997-07-10",
"1997-07-11",
"1997-07-16",
"1997-07-18",
"1997-07-21",
"1997-07-26",
"1997-07-27",
"1997-07-29",
"1997-07-30",
"1997-08-02",
"1997-08-05",
"1997-08-09",
"1997-08-14",
"1997-08-15",
"1997-08-16",
"1997-08-19",
"1997-08-19",
"1997-08-21",
"1997-08-24",
"1997-08-24",
"1997-08-24",
"1997-08-25",
"1997-08-28",
"1997-08-31",
"1997-09-02",
"1997-09-02",
"1997-09-05",
"1997-09-06",
"1997-09-08",
"1997-09-11",
"1997-09-11",
"1997-09-12",
"1997-09-17",
"1997-09-17",
"1997-09-18",
"1997-09-20",
"1997-09-20",
"1997-09-23",
"1997-09-23",
"1997-09-23",
"1997-09-24",
"1997-10-01",
"1997-10-02",
"1997-10-10",
"1997-10-12",
"1997-10-13",
"1997-10-14",
"1997-10-15",
"1997-10-17",
"1997-10-17",
"1997-10-19",
"1997-10-22",
"1997-10-24",
"1997-10-27",
"1997-10-30",
"1997-10-30",
"1997-10-30",
"1997-11-04",
"1997-11-07",
"1997-11-09",
"1997-11-11",
"1997-11-12",
"1997-11-14",
"1997-11-16",
"1997-11-17",
"1997-11-18",
"1997-11-18",
"1997-11-20",
"1997-11-20",
"1997-11-25",
"1997-11-29",
"1997-12-02",
"1997-12-03",
"1997-12-04",
"1997-12-05",
"1997-12-05",
"1997-12-05",
"1997-12-06",
"1997-12-11",
"1997-12-11",
"1997-12-13",
"1997-12-13",
"1997-12-15",
"1997-12-25",
"1997-12-31",
"1997-12-31",
"1998-01-01",
"1998-01-01",
"1998-01-02",
"1998-01-04",
"1998-01-05",
"1998-01-07",
"1998-01-09",
"1998-01-10",
"1998-01-12",
"1998-01-12",
"1998-01-13",
"1998-01-14",
"1998-01-15",
"1998-01-17",
"1998-01-19",
"1998-01-27",
"1998-01-29",
"1998-01-29",
"1998-02-01",
"1998-02-02",
"1998-02-03",
"1998-02-08",
"1998-02-08",
"1998-02-08",
"1998-02-13",
"1998-02-17",
"1998-02-24",
"1998-02-24",
"1998-02-25",
"1998-03-02",
"1998-03-03",
"1998-03-03",
"1998-03-15",
"1998-03-19",
"1998-03-24",
"1998-03-25",
"1998-03-26",
"1998-03-31",
"1998-04-04",
"1998-04-05",
"1998-04-10",
"1998-04-14",
"1998-04-16",
"1998-04-17",
"1998-04-23",
"1998-04-25",
"1998-04-25",
"1998-04-26",
"1998-04-26",
"1998-05-03",
"1998-05-06",
"1998-05-06",
"1998-05-09",
"1998-05-13",
"1998-05-14",
"1998-05-15",
"1998-05-16",
"1998-05-19",
"1998-05-19",
"1998-05-19",
"1998-05-21",
"1998-05-22",
"1998-05-23",
"1998-05-24",
"1998-05-25",
"1998-05-26",
"1998-05-26",
"1998-05-27",
"1998-05-28",
"1998-05-29",
"1998-06-05",
"1998-06-11",
"1998-06-17",
"1998-06-18",
"1998-06-25",
"1998-06-25",
"1998-06-26",
"1998-06-27",
"1998-06-28",
"1998-06-29",
"1998-06-30",
"1998-06-30",
"1998-06-30",
"1998-07-01",
"1998-07-07",
"1998-07-08",
"1998-07-09",
"1998-07-12",
"1998-07-16",
"1998-07-19",
"1998-07-20",
"1998-07-26",
"1998-07-28",
"1998-07-31",
"1998-08-07",
"1998-08-09",
"1998-08-12",
"1998-08-13",
"1998-08-20",
"1998-08-20",
"1998-08-21",
"1998-08-28",
"1998-08-31",
"1998-09-02",
"1998-09-04",
"1998-09-04",
"1998-09-07",
"1998-09-13",
"1998-09-16",
"1998-09-21",
"1998-09-22",
"1998-09-23",
"1998-09-24",
"1998-09-29",
"1998-09-29",
"1998-10-05",
"1998-10-09",
"1998-10-13",
"1998-10-14",
"1998-10-14",
"1998-10-17",
"1998-10-25",
"1998-10-27",
"1998-10-30",
"1998-11-04",
"1998-11-09",
"1998-11-10",
"1998-11-10",
"1998-11-12",
"1998-11-15",
"1998-11-20",
"1998-11-21",
"1998-11-29",
"1998-12-01",
"1998-12-04",
"1998-12-04",
"1998-12-06",
"1998-12-08",
"1998-12-09",
"1998-12-09",
"1998-12-11",
"1998-12-12",
"1998-12-15",
"1998-12-16",
"1998-12-29",
"1998-12-29",
"1999-01-03",
"1999-01-09",
"1999-01-09",
"1999-01-10",
"1999-01-19",
"1999-01-20",
"1999-01-23",
"1999-01-23",
"1999-01-23",
"1999-01-24",
"1999-01-28",
"1999-01-31",
"1999-01-31",
"1999-02-01",
"1999-02-05",
"1999-02-09",
"1999-02-11",
"1999-02-14",
"1999-02-16",
"1999-02-17",
"1999-02-20",
"1999-02-26",
"1999-02-27",
"1999-03-03",
"1999-03-04",
"1999-03-04",
"1999-03-04",
"1999-03-04",
"1999-03-07",
"1999-03-09",
"1999-03-11",
"1999-03-15",
"1999-03-26",
"1999-03-31",
"1999-04-03",
"1999-04-04",
"1999-04-08",
"1999-04-12",
"1999-04-12",
"1999-04-12",
"1999-04-15",
"1999-04-16",
"1999-04-29",
"1999-05-04",
"1999-05-06",
"1999-05-15",
"1999-05-17",
"1999-05-19",
"1999-05-21",
"1999-05-21",
"1999-05-22",
"1999-05-22",
"1999-05-24",
"1999-05-27",
"1999-05-28",
"1999-05-30",
"1999-05-30",
"1999-05-31",
"1999-06-03",
"1999-06-05",
"1999-06-05",
"1999-06-11",
"1999-06-12",
"1999-06-12",
"1999-06-17",
"1999-06-23",
"1999-06-27",
"1999-07-10",
"1999-07-11",
"1999-07-12",
"1999-07-15",
"1999-07-16",
"1999-07-18",
"1999-07-19",
"1999-07-20",
"1999-07-24",
"1999-07-24",
"1999-07-26",
"1999-07-27",
"1999-08-01",
"1999-08-03",
"1999-08-07",
"1999-08-08",
"1999-08-09",
"1999-08-09",
"1999-08-12",
"1999-08-13",
"1999-08-19",
"1999-08-30",
"1999-08-31",
"1999-09-06",
"1999-09-08",
"1999-09-09",
"1999-09-24",
"1999-09-24",
"1999-09-25",
"1999-09-29",
"1999-10-02",
"1999-10-03",
"1999-10-06",
"1999-10-07",
"1999-10-08",
"1999-10-08",
"1999-10-09",
"1999-10-12",
"1999-10-12",
"1999-10-12",
"1999-10-12",
"1999-10-13",
"1999-10-17",
"1999-10-18",
"1999-10-18",
"1999-10-21",
"1999-10-21",
"1999-10-23",
"1999-10-25",
"1999-10-28",
"1999-10-30",
"1999-11-01",
"1999-11-05",
"1999-11-06",
"1999-11-09",
"1999-11-09",
"1999-11-16",
"1999-11-16",
"1999-11-16",
"1999-11-28",
"1999-12-01",
"1999-12-07",
"1999-12-11",
"1999-12-12",
"1999-12-16",
"1999-12-17",
"1999-12-22",
"1999-12-24",
"1999-12-27",
"1999-12-27",
"1999-12-28",
"1999-12-28",
"1999-12-30",
"2000-01-02",
"2000-01-03",
"2000-01-03",
"2000-01-11",
"2000-01-11",
"2000-01-14",
"2000-01-14",
"2000-01-15",
"2000-01-18",
"2000-01-19",
"2000-01-24",
"2000-01-25",
"2000-01-27",
"2000-01-28",
"2000-01-28",
"2000-02-01",
"2000-02-03",
"2000-02-05",
"2000-02-07",
"2000-02-08",
"2000-02-10",
"2000-02-11",
"2000-02-12",
"2000-02-13",
"2000-02-18",
"2000-02-18",
"2000-02-21",
"2000-02-26",
"2000-02-29",
"2000-03-01",
"2000-03-02",
"2000-03-08",
"2000-03-08",
"2000-03-10",
"2000-03-12",
"2000-03-12",
"2000-03-17",
"2000-03-17",
"2000-03-21",
"2000-03-24",
"2000-03-24",
"2000-03-25",
"2000-03-30",
"2000-04-05",
"2000-04-12",
"2000-04-19",
"2000-04-20",
"2000-04-21",
"2000-04-23",
"2000-04-30",
"2000-05-04",
"2000-05-06",
"2000-05-09",
"2000-05-13",
"2000-05-15",
"2000-05-18",
"2000-05-24",
"2000-05-26",
"2000-05-28",
"2000-05-28",
"2000-05-31",
"2000-05-31",
"2000-06-01",
"2000-06-02",
"2000-06-04",
"2000-06-05",
"2000-06-06",
"2000-06-10",
"2000-06-11",
"2000-06-13",
"2000-06-13",
"2000-06-13",
"2000-06-14",
"2000-06-21",
"2000-06-22",
"2000-06-22",
"2000-06-24",
"2000-06-25",
"2000-06-25",
"2000-07-02",
"2000-07-03",
"2000-07-10",
"2000-07-10",
"2000-07-10",
"2000-07-13",
"2000-07-14",
"2000-07-15",
"2000-07-16",
"2000-07-17",
"2000-07-17",
"2000-07-18",
"2000-07-19",
"2000-07-21",
"2000-07-22",
"2000-07-23",
"2000-07-23",
"2000-07-24",
"2000-07-26",
"2000-08-05",
"2000-08-07",
"2000-08-08",
"2000-08-11",
"2000-08-17",
"2000-08-17",
"2000-08-19",
"2000-08-28",
"2000-08-29",
"2000-08-31",
"2000-08-31",
"2000-08-31",
"2000-09-01",
"2000-09-06",
"2000-09-08",
"2000-09-08",
"2000-09-11",
"2000-09-12",
"2000-09-17",
"2000-09-18",
"2000-09-19",
"2000-09-19",
"2000-09-20",
"2000-09-21",
"2000-09-21",
"2000-09-27",
"2000-09-29",
"2000-10-05",
"2000-10-05",
"2000-10-05",
"2000-10-11",
"2000-10-14",
"2000-10-14",
"2000-10-14",
"2000-10-18",
"2000-10-19",
"2000-10-20",
"2000-10-21",
"2000-10-23",
"2000-10-25",
"2000-10-28",
"2000-10-29",
"2000-10-30",
"2000-10-31",
"2000-11-03",
"2000-11-04",
"2000-11-10",
"2000-11-14",
"2000-11-27",
"2000-11-28",
"2000-12-01",
"2000-12-01",
"2000-12-02",
"2000-12-04",
"2000-12-06",
"2000-12-06",
"2000-12-09",
"2000-12-14",
"2000-12-16",
"2000-12-23",
"2000-12-24",
"2000-12-24",
"2000-12-26",
"2000-12-30",
"2001-01-01",
"2001-01-03",
"2001-01-03",
"2001-01-05",
"2001-01-09",
"2001-01-10",
"2001-01-12",
"2001-01-13",
"2001-01-20",
"2001-01-23",
"2001-01-31",
"2001-02-01",
"2001-02-02",
"2001-02-03",
"2001-02-06",
"2001-02-12",
"2001-02-13",
"2001-02-13",
"2001-02-14",
"2001-02-14",
"2001-02-15",
"2001-02-16",
"2001-02-17",
"2001-02-19",
"2001-02-19",
"2001-02-28",
"2001-03-02",
"2001-03-02",
"2001-03-04",
"2001-03-07",
"2001-03-13",
"2001-03-15",
"2001-03-15",
"2001-03-17",
"2001-03-17",
"2001-03-17",
"2001-03-18",
"2001-03-20",
"2001-03-20",
"2001-03-29",
"2001-04-04",
"2001-04-04",
"2001-04-07",
"2001-04-27",
"2001-04-29",
"2001-04-30",
"2001-05-04",
"2001-05-06",
"2001-05-09",
"2001-05-09",
"2001-05-12",
"2001-05-16",
"2001-05-19",
"2001-05-22",
"2001-05-22",
"2001-05-23",
"2001-05-30",
"2001-05-31",
"2001-06-04",
"2001-06-06",
"2001-06-06",
"2001-06-07",
"2001-06-08",
"2001-06-09",
"2001-06-09",
"2001-06-17",
"2001-06-23",
"2001-06-25",
"2001-06-28",
"2001-06-30",
"2001-07-06",
"2001-07-06",
"2001-07-06",
"2001-07-06",
"2001-07-08",
"2001-07-08",
"2001-07-09",
"2001-07-10",
"2001-07-13",
"2001-07-26",
"2001-07-26",
"2001-07-29",
"2001-07-30",
"2001-08-01",
"2001-08-02",
"2001-08-03",
"2001-08-03",
"2001-08-04",
"2001-08-07",
"2001-08-08",
"2001-08-12",
"2001-08-13",
"2001-08-15",
"2001-08-19",
"2001-08-21",
"2001-08-22",
"2001-08-24",
"2001-08-27",
"2001-08-31",
"2001-09-03",
"2001-09-04",
"2001-09-04",
"2001-09-06",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-11",
"2001-09-13",
"2001-09-14",
"2001-09-15",
"2001-09-15",
"2001-09-17",
"2001-09-18",
"2001-09-20",
"2001-09-26",
"2001-09-28",
"2001-09-28",
"2001-09-29",
"2001-09-30",
"2001-09-30",
"2001-09-30",
"2001-10-01",
"2001-10-01",
"2001-10-02",
"2001-10-03",
"2001-10-03",
"2001-10-13",
"2001-10-16",
"2001-10-19",
"2001-10-19",
"2001-10-22",
"2001-10-22",
"2001-10-22",
"2001-10-23",
"2001-10-26",
"2001-10-28",
"2001-10-28",
"2001-11-02",
"2001-11-06",
"2001-11-07",
"2001-11-08",
"2001-11-13",
"2001-11-13",
"2001-11-24",
"2001-11-25",
"2001-11-28",
"2001-11-29",
"2001-11-30",
"2001-12-02",
"2001-12-03",
"2001-12-08",
"2001-12-09",
"2001-12-11",
"2001-12-17",
"2001-12-23",
"2001-12-25",
"2001-12-26",
"2001-12-27",
"2001-12-28",
"2001-12-29",
"2002-01-04",
"2002-01-08",
"2002-01-08",
"2002-01-08",
"2002-01-08",
"2002-01-08",
"2002-01-14",
"2002-01-17",
"2002-01-18",
"2002-01-19",
"2002-01-21",
"2002-01-30",
"2002-01-31",
"2002-02-02",
"2002-02-02",
"2002-02-08",
"2002-02-08",
"2002-02-10",
"2002-02-11",
"2002-02-12",
"2002-02-17",
"2002-02-20",
"2002-03-01",
"2002-03-04",
"2002-03-05",
"2002-03-07",
"2002-03-12",
"2002-03-13",
"2002-03-19",
"2002-03-22",
"2002-03-25",
"2002-03-31",
"2002-03-31",
"2002-04-05",
"2002-04-13",
"2002-04-15",
"2002-04-19",
"2002-04-23",
"2002-04-24",
"2002-04-29",
"2002-05-02",
"2002-05-04",
"2002-05-06",
"2002-05-10",
"2002-05-16",
"2002-05-17",
"2002-05-18",
"2002-05-20",
"2002-05-23",
"2002-05-24",
"2002-05-26",
"2002-05-30",
"2002-06-01",
"2002-06-03",
"2002-06-03",
"2002-06-04",
"2002-06-05",
"2002-06-06",
"2002-06-07",
"2002-06-07",
"2002-06-12",
"2002-06-12",
"2002-06-12",
"2002-06-12",
"2002-06-22",
"2002-07-04",
"2002-07-07",
"2002-07-09",
"2002-07-17",
"2002-07-17",
"2002-07-17",
"2002-07-17",
"2002-07-20",
"2002-07-22",
"2002-07-22",
"2002-07-24",
"2002-07-28",
"2002-08-01",
"2002-08-04",
"2002-08-06",
"2002-08-09",
"2002-08-11",
"2002-08-22",
"2002-08-24",
"2002-08-25",
"2002-08-25",
"2002-08-27",
"2002-08-29",
"2002-08-29",
"2002-08-29",
"2002-09-02",
"2002-09-03",
"2002-09-04",
"2002-09-06",
"2002-09-09",
"2002-09-10",
"2002-09-10",
"2002-09-14",
"2002-09-18",
"2002-09-22",
"2002-09-24",
"2002-09-26",
"2002-10-06",
"2002-10-06",
"2002-10-06",
"2002-10-17",
"2002-10-18",
"2002-10-23",
"2002-10-23",
"2002-10-29",
"2002-10-30",
"2002-11-08",
"2002-11-09",
"2002-11-10",
"2002-11-11",
"2002-11-13",
"2002-11-13",
"2002-11-13",
"2002-11-18",
"2002-11-18",
"2002-11-19",
"2002-11-19",
"2002-11-19",
"2002-11-19",
"2002-11-22",
"2002-11-23",
"2002-11-23",
"2002-11-28",
"2002-11-29",
"2002-11-30",
"2002-12-03",
"2002-12-04",
"2002-12-05",
"2002-12-10",
"2002-12-10",
"2002-12-12",
"2002-12-14",
"2002-12-17",
"2002-12-19",
"2002-12-22",
"2002-12-23",
"2002-12-28",
"2002-12-29",
"2003-01-03",
"2003-01-07",
"2003-01-12",
"2003-01-13",
"2003-01-16",
"2003-01-16",
"2003-01-18",
"2003-01-23",
"2003-01-26",
"2003-01-29",
"2003-01-29",
"2003-02-04",
"2003-02-14",
"2003-02-17",
"2003-02-19",
"2003-02-20",
"2003-02-20",
"2003-02-20",
"2003-02-21",
"2003-03-04",
"2003-03-07",
"2003-03-09",
"2003-03-10",
"2003-03-10",
"2003-03-16",
"2003-03-18",
"2003-03-25",
"2003-03-26",
"2003-04-02",
"2003-04-02",
"2003-04-03",
"2003-04-05",
"2003-04-06",
"2003-04-11",
"2003-04-14",
"2003-04-15",
"2003-04-16",
"2003-04-16",
"2003-04-17",
"2003-04-22",
"2003-04-25",
"2003-04-25",
"2003-04-27",
"2003-04-29",
"2003-05-02",
"2003-05-03",
"2003-05-04",
"2003-05-09",
"2003-05-13",
"2003-05-19",
"2003-05-19",
"2003-05-22",
"2003-05-26",
"2003-05-27",
"2003-05-28",
"2003-05-28",
"2003-05-29",
"2003-05-29",
"2003-05-30",
"2003-05-30",
"2003-06-01",
"2003-06-06",
"2003-06-07",
"2003-06-07",
"2003-06-11",
"2003-06-11",
"2003-06-13",
"2003-06-15",
"2003-06-22",
"2003-06-23",
"2003-06-24",
"2003-06-24",
"2003-06-25",
"2003-06-26",
"2003-06-26",
"2003-06-28",
"2003-07-05",
"2003-07-07",
"2003-07-08",
"2003-07-09",
"2003-07-09",
"2003-07-16",
"2003-07-17",
"2003-07-17",
"2003-07-21",
"2003-07-23",
"2003-07-23",
"2003-07-26",
"2003-07-28",
"2003-07-30",
"2003-07-31",
"2003-07-31",
"2003-08-02",
"2003-08-02",
"2003-08-02",
"2003-08-05",
"2003-08-05",
"2003-08-15",
"2003-08-17",
"2003-08-21",
"2003-08-22",
"2003-08-24",
"2003-08-24",
"2003-08-26",
"2003-08-27",
"2003-08-27",
"2003-08-29",
"2003-09-05",
"2003-09-11",
"2003-09-13",
"2003-09-19",
"2003-09-21",
"2003-09-23",
"2003-09-24",
"2003-10-02",
"2003-10-05",
"2003-10-09",
"2003-10-16",
"2003-10-17",
"2003-10-19",
"2003-10-25",
"2003-10-25",
"2003-11-02",
"2003-11-02",
"2003-11-02",
"2003-11-03",
"2003-11-08",
"2003-11-13",
"2003-11-15",
"2003-11-15",
"2003-11-19",
"2003-11-21",
"2003-11-21",
"2003-11-23",
"2003-11-24",
"2003-11-24",
"2003-11-28",
"2003-11-29",
"2003-11-30",
"2003-12-02",
"2003-12-05",
"2003-12-08",
"2003-12-08",
"2003-12-13",
"2003-12-13",
"2003-12-22",
"2003-12-22",
"2003-12-25",
"2003-12-26",
"2003-12-26",
"2003-12-27",
"2003-12-30",
"2003-12-30",
"2004-01-02",
"2004-01-02",
"2004-01-02",
"2004-01-04",
"2004-01-08",
"2004-01-14",
"2004-01-25",
"2004-01-26",
"2004-01-29",
"2004-01-30",
"2004-01-31",
"2004-02-01",
"2004-02-04",
"2004-02-05",
"2004-02-07",
"2004-02-10",
"2004-02-12",
"2004-02-12",
"2004-02-12",
"2004-02-16",
"2004-02-16",
"2004-02-19",
"2004-02-20",
"2004-02-25",
"2004-03-03",
"2004-03-10",
"2004-03-10",
"2004-03-12",
"2004-03-14",
"2004-03-17",
"2004-03-19",
"2004-03-25",
"2004-03-27",
"2004-03-30",
"2004-03-31",
"2004-03-31",
"2004-04-04",
"2004-04-05",
"2004-04-06",
"2004-04-08",
"2004-04-10",
"2004-04-11",
"2004-04-15",
"2004-04-20",
"2004-04-21",
"2004-04-21",
"2004-04-23",
"2004-04-23",
"2004-04-24",
"2004-04-24",
"2004-04-27",
"2004-04-27",
"2004-05-02",
"2004-05-02",
"2004-05-04",
"2004-05-06",
"2004-05-08",
"2004-05-09",
"2004-05-11",
"2004-05-11",
"2004-05-12",
"2004-05-13",
"2004-05-13",
"2004-05-14",
"2004-05-15",
"2004-05-17",
"2004-05-20",
"2004-05-22",
"2004-05-31",
"2004-06-03",
"2004-06-05",
"2004-06-05",
"2004-06-06",
"2004-06-12",
"2004-06-15",
"2004-06-17",
"2004-06-17",
"2004-06-17",
"2004-06-17",
"2004-06-17",
"2004-06-18",
"2004-06-25",
"2004-06-29",
"2004-07-03",
"2004-07-03",
"2004-07-09",
"2004-07-09",
"2004-07-10",
"2004-07-11",
"2004-07-12",
"2004-07-12",
"2004-07-14",
"2004-07-16",
"2004-07-18",
"2004-07-18",
"2004-07-19",
"2004-07-20",
"2004-07-20",
"2004-07-22",
"2004-07-22",
"2004-07-26",
"2004-07-27",
"2004-07-29",
"2004-07-30",
"2004-08-04",
"2004-08-08",
"2004-08-09",
"2004-08-10",
"2004-08-11",
"2004-08-15",
"2004-08-16",
"2004-08-18",
"2004-08-19",
"2004-08-20",
"2004-08-28",
"2004-08-28",
"2004-09-01",
"2004-09-01",
"2004-09-06",
"2004-09-10",
"2004-09-10",
"2004-09-12",
"2004-09-12",
"2004-09-13",
"2004-09-16",
"2004-09-16",
"2004-09-24",
"2004-09-25",
"2004-09-26",
"2004-10-02",
"2004-10-08",
"2004-10-10",
"2004-10-14",
"2004-10-17",
"2004-10-24",
"2004-10-28",
"2004-10-29",
"2004-10-31",
"2004-11-05",
"2004-11-07",
"2004-11-11",
"2004-11-13",
"2004-11-24",
"2004-11-25",
"2004-11-27",
"2004-12-04",
"2004-12-08",
"2004-12-14",
"2004-12-18",
"2004-12-29",
"2004-12-30",
"2004-12-30",
"2004-12-30",
"2005-01-03",
"2005-01-06",
"2005-01-09",
"2005-01-10",
"2005-01-10",
"2005-01-12",
"2005-01-15",
"2005-01-18",
"2005-01-18",
"2005-01-19",
"2005-01-26",
"2005-01-26",
"2005-02-04",
"2005-02-09",
"2005-02-09",
"2005-02-10",
"2005-02-16",
"2005-02-24",
"2005-02-26",
"2005-02-27",
"2005-03-02",
"2005-03-04",
"2005-03-06",
"2005-03-11",
"2005-03-12",
"2005-03-16",
"2005-03-16",
"2005-03-17",
"2005-03-17",
"2005-03-19",
"2005-03-20",
"2005-03-23",
"2005-03-25",
"2005-03-27",
"2005-04-08",
"2005-04-09",
"2005-04-09",
"2005-04-16",
"2005-04-17",
"2005-04-20",
"2005-04-21",
"2005-04-21",
"2005-04-23",
"2005-04-24",
"2005-04-25",
"2005-04-25",
"2005-04-29",
"2005-05-04",
"2005-05-06",
"2005-05-06",
"2005-05-08",
"2005-05-09",
"2005-05-09",
"2005-05-10",
"2005-05-16",
"2005-05-19",
"2005-05-26",
"2005-06-01",
"2005-06-02",
"2005-06-02",
"2005-06-06",
"2005-06-19",
"2005-06-21",
"2005-06-21",
"2005-06-21",
"2005-06-22",
"2005-06-24",
"2005-06-27",
"2005-07-01",
"2005-07-05",
"2005-07-05",
"2005-07-06",
"2005-07-08",
"2005-07-11",
"2005-07-13",
"2005-07-13",
"2005-07-15",
"2005-07-16",
"2005-07-18",
"2005-07-19",
"2005-07-22",
"2005-07-25",
"2005-07-25",
"2005-07-26",
"2005-07-31",
"2005-08-09",
"2005-08-10",
"2005-08-10",
"2005-08-11",
"2005-08-13",
"2005-08-13",
"2005-08-13",
"2005-08-13",
"2005-08-17",
"2005-08-17",
"2005-08-18",
"2005-08-18",
"2005-08-23",
"2005-08-29",
"2005-09-04",
"2005-09-06",
"2005-09-12",
"2005-09-13",
"2005-09-14",
"2005-09-15",
"2005-09-17",
"2005-09-17",
"2005-09-20",
"2005-09-22",
"2005-09-23",
"2005-09-23",
"2005-09-24",
"2005-09-24",
"2005-09-24",
"2005-09-28",
"2005-09-29",
"2005-09-30",
"2005-10-03",
"2005-10-03",
"2005-10-03",
"2005-10-03",
"2005-10-07",
"2005-10-07",
"2005-10-08",
"2005-10-08",
"2005-10-08",
"2005-10-09",
"2005-10-10",
"2005-10-11",
"2005-10-14",
"2005-10-18",
"2005-10-20",
"2005-10-26",
"2005-10-28",
"2005-11-05",
"2005-11-09",
"2005-11-11",
"2005-11-13",
"2005-11-16",
"2005-11-17",
"2005-11-18",
"2005-11-18",
"2005-11-22",
"2005-11-22",
"2005-11-23",
"2005-11-27",
"2005-11-27",
"2005-11-28",
"2005-11-29",
"2005-12-01",
"2005-12-05",
"2005-12-10",
"2005-12-12",
"2005-12-13",
"2005-12-16",
"2005-12-21",
"2005-12-25",
"2005-12-25",
"2005-12-28",
"2005-12-31",
"2006-01-01",
"2006-01-04",
"2006-01-04",
"2006-01-06",
"2006-01-07",
"2006-01-10",
"2006-01-10",
"2006-01-11",
"2006-01-13",
"2006-01-17",
"2006-01-20",
"2006-01-23",
"2006-01-27",
"2006-01-27",
"2006-02-01",
"2006-02-01",
"2006-02-04",
"2006-02-09",
"2006-02-10",
"2006-02-12",
"2006-02-12",
"2006-02-15",
"2006-02-16",
"2006-02-17",
"2006-02-17",
"2006-02-18",
"2006-02-22",
"2006-02-24",
"2006-02-25",
"2006-02-25",
"2006-02-27",
"2006-03-01",
"2006-03-01",
"2006-03-08",
"2006-03-22",
"2006-03-23",
"2006-03-23",
"2006-03-27",
"2006-03-27",
"2006-03-28",
"2006-04-03",
"2006-04-07",
"2006-04-13",
"2006-04-13",
"2006-04-23",
"2006-04-23",
"2006-04-23",
"2006-04-24",
"2006-04-26",
"2006-04-30",
"2006-05-01",
"2006-05-02",
"2006-05-04",
"2006-05-08",
"2006-05-08",
"2006-05-09",
"2006-05-11",
"2006-05-12",
"2006-05-15",
"2006-05-17",
"2006-05-19",
"2006-05-21",
"2006-05-24",
"2006-05-25",
"2006-05-28",
"2006-06-04",
"2006-06-07",
"2006-06-11",
"2006-06-15",
"2006-06-16",
"2006-06-16",
"2006-06-21",
"2006-06-29",
"2006-06-30",
"2006-07-03",
"2006-07-07",
"2006-07-08",
"2006-07-08",
"2006-07-23",
"2006-07-25",
"2006-07-26",
"2006-08-02",
"2006-08-02",
"2006-08-03",
"2006-08-06",
"2006-08-06",
"2006-08-07",
"2006-08-13",
"2006-08-14",
"2006-08-16",
"2006-08-21",
"2006-08-22",
"2006-08-22",
"2006-08-23",
"2006-08-29",
"2006-08-29",
"2006-08-31",
"2006-09-01",
"2006-09-02",
"2006-09-03",
"2006-09-07",
"2006-09-08",
"2006-09-12",
"2006-09-20",
"2006-09-20",
"2006-09-21",
"2006-09-27",
"2006-09-27",
"2006-09-28",
"2006-09-28",
"2006-09-28",
"2006-09-28",
"2006-09-28",
"2006-09-30",
"2006-10-01",
"2006-10-14",
"2006-10-17",
"2006-10-18",
"2006-10-20",
"2006-10-21",
"2006-10-21",
"2006-10-22",
"2006-10-22",
"2006-10-22",
"2006-10-23",
"2006-10-23",
"2006-10-26",
"2006-10-27",
"2006-10-31",
"2006-11-03",
"2006-11-04",
"2006-11-06",
"2006-11-07",
"2006-11-09",
"2006-11-12",
"2006-11-14",
"2006-11-17",
"2006-11-22",
"2006-11-24",
"2006-11-26",
"2006-11-28",
"2006-12-02",
"2006-12-03",
"2006-12-04",
"2006-12-05",
"2006-12-06",
"2006-12-07",
"2006-12-11",
"2006-12-17",
"2006-12-19",
"2006-12-20",
"2006-12-23",
"2007-01-06",
"2007-01-07",
"2007-01-07",
"2007-01-09",
"2007-01-10",
"2007-01-11",
"2007-01-12",
"2007-01-19",
"2007-01-19",
"2007-01-23",
"2007-01-24",
"2007-01-25",
"2007-01-27",
"2007-01-30",
"2007-02-01",
"2007-02-10",
"2007-02-11",
"2007-02-14",
"2007-02-16",
"2007-02-17",
"2007-02-19",
"2007-02-19",
"2007-02-21",
"2007-02-21",
"2007-02-21",
"2007-02-23",
"2007-02-27",
"2007-03-03",
"2007-03-04",
"2007-03-06",
"2007-03-09",
"2007-03-09",
"2007-03-13",
"2007-03-14",
"2007-03-14",
"2007-03-14",
"2007-03-17",
"2007-03-19",
"2007-03-20",
"2007-03-21",
"2007-03-23",
"2007-03-23",
"2007-03-25",
"2007-03-26",
"2007-03-26",
"2007-03-29",
"2007-04-01",
"2007-04-01",
"2007-04-02",
"2007-04-03",
"2007-04-04",
"2007-04-06",
"2007-04-08",
"2007-04-10",
"2007-04-12",
"2007-04-12",
"2007-04-13",
"2007-04-13",
"2007-04-14",
"2007-04-14",
"2007-04-21",
"2007-04-24",
"2007-04-25",
"2007-04-25",
"2007-04-27",
"2007-05-01",
"2007-05-02",
"2007-05-03",
"2007-05-04",
"2007-05-07",
"2007-05-08",
"2007-05-08",
"2007-05-11",
"2007-05-13",
"2007-05-14",
"2007-05-14",
"2007-05-14",
"2007-05-17",
"2007-05-17",
"2007-05-17",
"2007-05-19",
"2007-05-20",
"2007-05-20",
"2007-05-22",
"2007-05-26",
"2007-05-30",
"2007-06-05",
"2007-06-09",
"2007-06-10",
"2007-06-13",
"2007-06-13",
"2007-06-13",
"2007-06-15",
"2007-06-16",
"2007-06-18",
"2007-06-18",
"2007-06-20",
"2007-06-22",
"2007-06-22",
"2007-06-24",
"2007-06-25",
"2007-06-28",
"2007-06-30",
"2007-07-05",
"2007-07-05",
"2007-07-07",
"2007-07-08",
"2007-07-14",
"2007-07-14",
"2007-07-15",
"2007-07-15",
"2007-07-17",
"2007-07-18",
"2007-07-27",
"2007-07-27",
"2007-07-28",
"2007-07-31",
"2007-08-05",
"2007-08-05",
"2007-08-10",
"2007-08-10",
"2007-08-10",
"2007-08-11",
"2007-08-12",
"2007-08-13",
"2007-08-15",
"2007-08-15",
"2007-08-17",
"2007-08-19",
"2007-08-20",
"2007-08-20",
"2007-08-21",
"2007-08-27",
"2007-08-28",
"2007-09-03",
"2007-09-08",
"2007-09-08",
"2007-09-11",
"2007-09-12",
"2007-09-13",
"2007-09-14",
"2007-09-18",
"2007-09-21",
"2007-09-23",
"2007-09-24",
"2007-09-29",
"2007-10-01",
"2007-10-04",
"2007-10-06",
"2007-10-09",
"2007-10-10",
"2007-10-10",
"2007-10-12",
"2007-10-12",
"2007-10-18",
"2007-10-19",
"2007-10-19",
"2007-10-19",
"2007-10-23",
"2007-10-25",
"2007-10-27",
"2007-10-28",
"2007-10-29",
"2007-11-01",
"2007-11-01",
"2007-11-02",
"2007-11-05",
"2007-11-07",
"2007-11-09",
"2007-11-09",
"2007-11-09",
"2007-11-16",
"2007-11-28",
"2007-11-28",
"2007-11-29",
"2007-12-03",
"2007-12-07",
"2007-12-07",
"2007-12-13",
"2007-12-14",
"2007-12-15",
"2007-12-17",
"2007-12-19",
"2007-12-19",
"2007-12-19",
"2007-12-19",
"2007-12-21",
"2007-12-26",
"2007-12-31",
"2008-01-01",
"2008-01-05",
"2008-01-06",
"2008-01-08",
"2008-01-10",
"2008-01-10",
"2008-01-12",
"2008-01-16",
"2008-01-16",
"2008-01-17",
"2008-01-20",
"2008-01-22",
"2008-01-25",
"2008-01-27",
"2008-01-28",
"2008-02-01",
"2008-02-03",
"2008-02-04",
"2008-02-04",
"2008-02-07",
"2008-02-07",
"2008-02-07",
"2008-02-17",
"2008-02-20",
"2008-02-21",
"2008-02-22",
"2008-02-25",
"2008-02-28",
"2008-03-01",
"2008-03-10",
"2008-03-20",
"2008-03-29",
"2008-03-29",
"2008-04-01",
"2008-04-22",
"2008-04-23",
"2008-04-26",
"2008-04-29",
"2008-05-01",
"2008-05-01",
"2008-05-03",
"2008-05-03",
"2008-05-06",
"2008-05-06",
"2008-05-23",
"2008-05-25",
"2008-05-29",
"2008-05-30",
"2008-06-02",
"2008-06-03",
"2008-06-05",
"2008-06-06",
"2008-06-13",
"2008-06-14",
"2008-06-15",
"2008-06-16",
"2008-06-17",
"2008-06-21",
"2008-06-25",
"2008-06-27",
"2008-06-29",
"2008-07-01",
"2008-07-02",
"2008-07-04",
"2008-07-13",
"2008-07-17",
"2008-07-18",
"2008-07-22",
"2008-07-27",
"2008-07-28",
"2008-08-01",
"2008-08-02",
"2008-08-03",
"2008-08-05",
"2008-08-06",
"2008-08-06",
"2008-08-07",
"2008-08-09",
"2008-08-11",
"2008-08-13",
"2008-08-14",
"2008-08-15",
"2008-08-19",
"2008-08-20",
"2008-08-21",
"2008-08-22",
"2008-08-22",
"2008-08-25",
"2008-08-26",
"2008-08-26",
"2008-08-27",
"2008-08-29",
"2008-09-01",
"2008-09-02",
"2008-09-04",
"2008-09-05",
"2008-09-06",
"2008-09-06",
"2008-09-06",
"2008-09-09",
"2008-09-10",
"2008-09-10",
"2008-09-12",
"2008-09-13",
"2008-09-14",
"2008-09-15",
"2008-09-19",
"2008-09-23",
"2008-09-26",
"2008-09-28",
"2008-09-28",
"2008-09-28",
"2008-10-01",
"2008-10-01",
"2008-10-03",
"2008-10-07",
"2008-10-08",
"2008-10-09",
"2008-10-10",
"2008-10-10",
"2008-10-13",
"2008-10-13",
"2008-10-19",
"2008-10-21",
"2008-10-22",
"2008-10-23",
"2008-10-24",
"2008-10-25",
"2008-10-25",
"2008-10-25",
"2008-10-31",
"2008-11-01",
"2008-11-04",
"2008-11-04",
"2008-11-07",
"2008-11-08",
"2008-11-11",
"2008-11-12",
"2008-11-16",
"2008-11-16",
"2008-11-17",
"2008-11-22",
"2008-11-22",
"2008-11-26",
"2008-11-27",
"2008-12-01",
"2008-12-02",
"2008-12-07",
"2008-12-08",
"2008-12-12",
"2008-12-12",
"2008-12-12",
"2008-12-15",
"2008-12-17",
"2008-12-19",
"2008-12-24",
"2008-12-25",
"2008-12-28",
"2009-01-04",
"2009-01-06",
"2009-01-09",
"2009-01-14",
"2009-01-18",
"2009-01-18",
"2009-01-19",
"2009-01-20",
"2009-01-25",
"2009-01-27",
"2009-01-28",
"2009-01-28",
"2009-01-28",
"2009-01-29",
"2009-02-06",
"2009-02-13",
"2009-02-14",
"2009-02-17",
"2009-02-18",
"2009-02-19",
"2009-02-22",
"2009-02-24",
"2009-03-06",
"2009-03-10",
"2009-03-11",
"2009-03-14",
"2009-03-15",
"2009-03-19",
"2009-03-19",
"2009-03-21",
"2009-03-21",
"2009-03-21",
"2009-03-24",
"2009-03-25",
"2009-03-27",
"2009-03-30",
"2009-04-02",
"2009-04-04",
"2009-04-04",
"2009-04-04",
"2009-04-07",
"2009-04-07",
"2009-04-08",
"2009-04-22",
"2009-04-24",
"2009-04-25",
"2009-04-25",
"2009-04-25",
"2009-04-26",
"2009-04-29",
"2009-05-05",
"2009-05-07",
"2009-05-12",
"2009-05-15",
"2009-05-15",
"2009-05-17",
"2009-05-19",
"2009-05-28",
"2009-05-29",
"2009-05-29",
"2009-05-29",
"2009-06-01",
"2009-06-02",
"2009-06-02",
"2009-06-04",
"2009-06-07",
"2009-06-07",
"2009-06-07",
"2009-06-10",
"2009-06-11",
"2009-06-14",
"2009-06-16",
"2009-06-19",
"2009-06-23",
"2009-07-06",
"2009-07-10",
"2009-07-13",
"2009-07-16",
"2009-07-18",
"2009-07-21",
"2009-07-23",
"2009-07-23",
"2009-07-25",
"2009-07-26",
"2009-07-26",
"2009-08-06",
"2009-08-18",
"2009-08-19",
"2009-08-20",
"2009-08-21",
"2009-08-24",
"2009-08-25",
"2009-08-29",
"2009-08-29",
"2009-09-01",
"2009-09-07",
"2009-09-08",
"2009-09-12",
"2009-09-13",
"2009-09-19",
"2009-09-23",
"2009-09-24",
"2009-09-28",
"2009-10-03",
"2009-10-07",
"2009-10-07",
"2009-10-08",
"2009-10-09",
"2009-10-12",
"2009-10-15",
"2009-10-16",
"2009-10-16",
"2009-10-23",
"2009-10-25",
"2009-10-31",
"2009-11-04",
"2009-11-07",
"2009-11-08",
"2009-11-12",
"2009-11-16",
"2009-11-19",
"2009-11-21",
"2009-11-21",
"2009-11-29",
"2009-11-29",
"2009-11-29",
"2009-11-29",
"2009-12-03",
"2009-12-04",
"2009-12-06",
"2009-12-08",
"2009-12-11",
"2009-12-13",
"2009-12-17",
"2009-12-17",
"2009-12-25",
"2009-12-28",
"2009-12-30",
"2010-01-01",
"2010-01-01",
"2010-01-03",
"2010-01-03",
"2010-01-05",
"2010-01-09",
"2010-01-09",
"2010-01-09",
"2010-01-11",
"2010-01-12",
"2010-01-12",
"2010-01-13",
"2010-01-13",
"2010-01-13",
"2010-01-14",
"2010-01-14",
"2010-01-16",
"2010-01-20",
"2010-01-26",
"2010-01-28",
"2010-01-28",
"2010-01-29",
"2010-01-31",
"2010-02-04",
"2010-02-04",
"2010-02-07",
"2010-02-07",
"2010-02-07",
"2010-02-07",
"2010-02-08",
"2010-02-11",
"2010-02-12",
"2010-02-12",
"2010-02-15",
"2010-02-18",
"2010-02-22",
"2010-02-25",
"2010-02-28",
"2010-03-01",
"2010-03-06",
"2010-03-09",
"2010-03-09",
"2010-03-13",
"2010-03-15",
"2010-03-21",
"2010-03-24",
"2010-03-24",
"2010-03-26",
"2010-03-27",
"2010-04-04",
"2010-04-06",
"2010-04-10",
"2010-04-11",
"2010-04-24",
"2010-04-25",
"2010-04-26",
"2010-04-29",
"2010-04-29",
"2010-04-29",
"2010-05-01",
"2010-05-03",
"2010-05-07",
"2010-05-08",
"2010-05-15",
"2010-05-15",
"2010-05-19",
"2010-05-20",
"2010-05-20",
"2010-05-20",
"2010-05-20",
"2010-05-26",
"2010-05-26",
"2010-05-29",
"2010-06-06",
"2010-06-10",
"2010-06-11",
"2010-06-11",
"2010-06-11",
"2010-06-12",
"2010-06-18",
"2010-06-19",
"2010-06-19",
"2010-06-20",
"2010-06-22",
"2010-06-22",
"2010-06-22",
"2010-06-25",
"2010-06-26",
"2010-06-27",
"2010-06-27",
"2010-06-29",
"2010-06-29",
"2010-07-05",
"2010-07-07",
"2010-07-07",
"2010-07-18",
"2010-07-20",
"2010-07-21",
"2010-07-21",
"2010-07-23",
"2010-07-23",
"2010-07-23",
"2010-07-28",
"2010-07-28",
"2010-07-28",
"2010-08-06",
"2010-08-06",
"2010-08-09",
"2010-08-10",
"2010-08-13",
"2010-08-18",
"2010-08-26",
"2010-08-27",
"2010-08-28",
"2010-08-29",
"2010-09-02",
"2010-09-03",
"2010-09-07",
"2010-09-11",
"2010-09-14",
"2010-09-15",
"2010-09-20",
"2010-09-21",
"2010-09-27",
"2010-09-28",
"2010-09-28",
"2010-09-30",
"2010-10-05",
"2010-10-13",
"2010-10-15",
"2010-10-20",
"2010-10-24",
"2010-10-25",
"2010-10-25",
"2010-10-26",
"2010-10-28",
"2010-10-29",
"2010-10-29",
"2010-11-07",
"2010-11-11",
"2010-11-11",
"2010-11-14",
"2010-11-15",
"2010-11-15",
"2010-11-16",
"2010-11-21",
"2010-11-23",
"2010-11-26",
"2010-11-29",
"2010-11-30",
"2010-12-01",
"2010-12-03",
"2010-12-05",
"2010-12-08",
"2010-12-08",
"2010-12-12",
"2010-12-16",
"2010-12-16",
"2010-12-20",
"2010-12-23",
"2010-12-25",
"2010-12-26",
"2010-12-27",
"2010-12-27",
"2010-12-28",
"2011-01-01",
"2011-01-04",
"2011-01-05",
"2011-01-09",
"2011-01-13",
"2011-01-14",
"2011-01-14",
"2011-01-17",
"2011-01-20",
"2011-01-20",
"2011-01-20",
"2011-01-21",
"2011-01-24",
"2011-01-24",
"2011-01-26",
"2011-01-28",
"2011-01-29",
"2011-02-02",
"2011-02-05",
"2011-02-05",
"2011-02-15",
"2011-02-15",
"2011-02-16",
"2011-02-17",
"2011-02-18",
"2011-02-21",
"2011-02-25",
"2011-03-03",
"2011-03-03",
"2011-03-04",
"2011-03-04",
"2011-03-05",
"2011-03-05",
"2011-03-08",
"2011-03-09",
"2011-03-12",
"2011-03-13",
"2011-03-13",
"2011-03-13",
"2011-03-15",
"2011-03-16",
"2011-03-19",
"2011-03-19",
"2011-03-19",
"2011-03-20",
"2011-03-22",
"2011-03-23",
"2011-03-25",
"2011-03-26",
"2011-03-28",
"2011-03-28",
"2011-04-02",
"2011-04-04",
"2011-04-06",
"2011-04-10",
"2011-04-12",
"2011-04-13",
"2011-04-17",
"2011-04-18",
"2011-04-18",
"2011-04-22",
"2011-04-23",
"2011-04-24",
"2011-05-01",
"2011-05-02",
"2011-05-07",
"2011-05-10",
"2011-05-12",
"2011-05-20",
"2011-05-21",
"2011-05-21",
"2011-05-24",
"2011-05-25",
"2011-05-26",
"2011-05-27",
"2011-05-28",
"2011-05-29",
"2011-06-01",
"2011-06-03",
"2011-06-04",
"2011-06-07",
"2011-06-07",
"2011-06-09",
"2011-06-09",
"2011-06-11",
"2011-06-12",
"2011-06-14",
"2011-06-18",
"2011-06-24",
"2011-06-26",
"2011-06-26",
"2011-06-26",
"2011-06-29",
"2011-07-03",
"2011-07-03",
"2011-07-03",
"2011-07-04",
"2011-07-05",
"2011-07-08",
"2011-07-08",
"2011-07-10",
"2011-07-11",
"2011-07-13",
"2011-07-14",
"2011-07-20",
"2011-07-28",
"2011-07-30",
"2011-07-30",
"2011-08-01",
"2011-08-01",
"2011-08-01",
"2011-08-01",
"2011-08-02",
"2011-08-04",
"2011-08-04",
"2011-08-06",
"2011-08-06",
"2011-08-07",
"2011-08-08",
"2011-08-09",
"2011-08-11",
"2011-08-14",
"2011-08-16",
"2011-08-25",
"2011-08-27",
"2011-08-31",
"2011-09-10",
"2011-09-12",
"2011-09-13",
"2011-09-16",
"2011-09-18",
"2011-09-20",
"2011-09-28",
"2011-09-30",
"2011-09-30",
"2011-09-30",
"2011-10-07",
"2011-10-10",
"2011-10-12",
"2011-10-13",
"2011-10-16",
"2011-10-23",
"2011-10-26",
"2011-10-28",
"2011-10-29",
"2011-10-30",
"2011-11-03",
"2011-11-04",
"2011-11-06",
"2011-11-07",
"2011-11-14",
"2011-11-17",
"2011-11-29",
"2011-11-30",
"2011-12-04",
"2011-12-04",
"2011-12-07",
"2011-12-08",
"2011-12-08",
"2011-12-09",
"2011-12-12",
"2011-12-12",
"2011-12-14",
"2011-12-16",
"2011-12-17",
"2011-12-19",
"2011-12-20",
"2011-12-21",
"2011-12-21",
"2011-12-23",
"2011-12-26",
"2011-12-28",
"2011-12-29",
"2011-12-30",
"2011-12-30",
"2012-01-05",
"2012-01-06",
"2012-01-08",
"2012-01-11",
"2012-01-17",
"2012-01-18",
"2012-01-20",
"2012-01-20",
"2012-01-21",
"2012-01-23",
"2012-01-23",
"2012-01-24",
"2012-01-27",
"2012-01-28",
"2012-02-03",
"2012-02-12",
"2012-02-16",
"2012-02-18",
"2012-02-23",
"2012-03-01",
"2012-03-06",
"2012-03-06",
"2012-03-18",
"2012-03-23",
"2012-03-24",
"2012-03-31",
"2012-04-06",
"2012-04-10",
"2012-04-11",
"2012-04-12",
"2012-04-12",
"2012-04-19",
"2012-04-19",
"2012-04-30",
"2012-05-01",
"2012-05-01",
"2012-05-18",
"2012-05-20",
"2012-05-26",
"2012-05-28",
"2012-06-04",
"2012-06-08",
"2012-06-08",
"2012-06-10",
"2012-06-15",
"2012-06-16",
"2012-06-17",
"2012-06-20",
"2012-06-23",
"2012-06-24",
"2012-06-26",
"2012-06-30",
"2012-07-03",
"2012-07-08",
"2012-07-08",
"2012-07-11",
"2012-07-12",
"2012-07-16",
"2012-07-17",
"2012-07-18",
"2012-07-22",
"2012-07-23",
"2012-07-24",
"2012-07-24",
"2012-07-24",
"2012-07-26",
"2012-07-26",
"2012-07-26",
"2012-07-27",
"2012-07-28",
"2012-07-31",
"2012-08-01",
"2012-08-01",
"2012-08-01",
"2012-08-05",
"2012-08-09",
"2012-08-13",
"2012-08-16",
"2012-08-16",
"2012-08-16",
"2012-08-18",
"2012-08-19",
"2012-08-20",
"2012-08-20",
"2012-08-20",
"2012-08-21",
"2012-08-23",
"2012-08-26",
"2012-08-28",
"2012-08-28",
"2012-08-29",
"2012-08-29",
"2012-08-31",
"2012-08-31",
"2012-09-01",
"2012-09-05",
"2012-09-06",
"2012-09-08",
"2012-09-09",
"2012-09-09",
"2012-09-12",
"2012-09-13",
"2012-09-15",
"2012-09-16",
"2012-09-21",
"2012-09-24",
"2012-09-26",
"2012-10-04",
"2012-10-04",
"2012-10-05",
"2012-10-05",
"2012-10-07",
"2012-10-11",
"2012-10-13",
"2012-10-18",
"2012-10-23",
"2012-11-03",
"2012-11-03",
"2012-11-09",
"2012-11-12",
"2012-11-14",
"2012-11-16",
"2012-11-23",
"2012-11-26",
"2012-11-29",
"2012-12-01",
"2012-12-08",
"2012-12-12",
"2012-12-14",
"2012-12-15",
"2012-12-16",
"2012-12-16",
"2012-12-16",
"2012-12-18",
"2012-12-19",
"2012-12-24",
"2012-12-24",
"2012-12-24",
"2012-12-28",
"2012-12-29",
"2012-12-31",
"2013-01-15",
"2013-01-15",
"2013-01-21",
"2013-01-22",
"2013-01-25",
"2013-01-31",
"2013-02-01",
"2013-02-02",
"2013-02-03",
"2013-02-03",
"2013-02-07",
"2013-02-12",
"2013-02-12",
"2013-02-16",
"2013-02-26",
"2013-02-26",
"2013-02-28",
"2013-03-02",
"2013-03-05",
"2013-03-07",
"2013-03-19",
"2013-03-19",
"2013-03-19",
"2013-03-25",
"2013-03-25",
"2013-03-26",
"2013-03-28",
"2013-03-30",
"2013-04-04",
"2013-04-07",
"2013-04-08",
"2013-04-09",
"2013-04-13",
"2013-04-14",
"2013-04-18",
"2013-04-20",
"2013-04-21",
"2013-04-26",
"2013-04-26",
"2013-05-01",
"2013-05-01",
"2013-05-01",
"2013-05-02",
"2013-05-06",
"2013-05-14",
"2013-05-14",
"2013-05-19",
"2013-05-19",
"2013-05-24",
"2013-05-25",
"2013-05-26",
"2013-05-31",
"2013-05-31",
"2013-05-31",
"2013-06-07",
"2013-06-08",
"2013-06-15",
"2013-06-15",
"2013-06-17",
"2013-06-18",
"2013-06-20",
"2013-06-22",
"2013-06-24",
"2013-06-24",
"2013-06-29",
"2013-07-07",
"2013-07-08",
"2013-07-14",
"2013-07-20",
"2013-07-22",
"2013-07-24",
"2013-07-30",
"2013-08-01",
"2013-08-03",
"2013-08-04",
"2013-08-05",
"2013-08-06",
"2013-08-09",
"2013-08-10",
"2013-08-11",
"2013-08-15",
"2013-08-23",
"2013-08-28",
"2013-09-01",
"2013-09-08",
"2013-09-09",
"2013-09-11",
"2013-09-13",
"2013-09-13",
"2013-09-14",
"2013-09-14",
"2013-09-17",
"2013-09-20",
"2013-09-21",
"2013-09-21",
"2013-10-02",
"2013-10-06",
"2013-10-16",
"2013-10-19",
"2013-10-19",
"2013-10-23",
"2013-10-29",
"2013-10-30",
"2013-10-30",
"2013-11-01",
"2013-11-01",
"2013-11-04",
"2013-11-10",
"2013-11-20",
"2013-11-28",
"2013-11-29",
"2013-12-06",
"2013-12-11",
"2013-12-17",
"2013-12-17",
"2013-12-18",
"2013-12-19",
"2013-12-20",
"2013-12-20",
"2013-12-20",
"2013-12-22",
"2013-12-23",
"2013-12-24",
"2014-01-03",
"2014-01-12",
"2014-01-12",
"2014-01-14",
"2014-01-21",
"2014-01-21",
"2014-01-23",
"2014-01-23",
"2014-01-23",
"2014-01-26",
"2014-01-27",
"2014-01-27",
"2014-01-28",
"2014-01-30",
"2014-01-30",
"2014-01-31",
"2014-02-11",
"2014-02-16",
"2014-02-17",
"2014-02-17",
"2014-03-03",
"2014-03-05",
"2014-03-07",
"2014-03-08",
"2014-03-14",
"2014-03-16",
"2014-03-17",
"2014-03-17",
"2014-03-19",
"2014-03-22",
"2014-03-24",
"2014-03-31",
"2014-03-31",
"2014-04-01",
"2014-04-02",
"2014-04-06",
"2014-04-09",
"2014-04-09",
"2014-04-09",
"2014-04-10",
"2014-04-14",
"2014-04-16",
"2014-04-18",
"2014-04-28",
"2014-05-01",
"2014-05-01",
"2014-05-03",
"2014-05-03",
"2014-05-03",
"2014-05-04",
"2014-05-09",
"2014-05-10",
"2014-05-11",
"2014-05-12",
"2014-05-21",
"2014-05-21",
"2014-05-29",
"2014-05-30",
"2014-05-30",
"2014-05-31",
"2014-06-08",
"2014-06-08",
"2014-06-11",
"2014-06-13",
"2014-06-19",
"2014-06-23",
"2014-06-28",
"2014-07-05",
"2014-07-06",
"2014-07-07",
"2014-07-07",
"2014-07-08",
"2014-07-09",
"2014-07-13",
"2014-07-17",
"2014-07-19",
"2014-07-20",
"2014-07-22",
"2014-07-30",
"2014-08-12",
"2014-08-12",
"2014-08-13",
"2014-08-14",
"2014-08-19",
"2014-08-20",
"2014-08-23",
"2014-08-25",
"2014-08-27",
"2014-08-28",
"2014-08-28",
"2014-09-03",
"2014-09-07",
"2014-09-07",
"2014-09-08",
"2014-09-08",
"2014-09-12",
"2014-09-14",
"2014-09-16",
"2014-09-18",
"2014-09-21",
"2014-09-28",
"2014-09-28",
"2014-09-30",
"2014-09-30",
"2014-10-01",
"2014-10-07",
"2014-10-08",
"2014-10-09",
"2014-10-16",
"2014-10-20",
"2014-10-20",
"2014-10-24",
"2014-10-24",
"2014-10-24",
"2014-10-25",
"2014-10-26",
"2014-10-26",
"2014-10-27",
"2014-10-27",
"2014-10-28",
"2014-10-29",
"2014-10-29",
"2014-10-31",
"2014-10-31",
"2014-11-01",
"2014-11-02",
"2014-11-04",
"2014-11-05",
"2014-11-16",
"2014-11-19",
"2014-11-21",
"2014-11-22",
"2014-11-23",
"2014-12-04",
"2014-12-07",
"2014-12-10",
"2014-12-14",
"2014-12-16",
"2014-12-20",
"2014-12-20",
"2014-12-21",
"2014-12-21",
"2014-12-27",
"2014-12-29",
"2014-12-29",
"2014-12-29",
"2014-12-30",
"2014-12-30",
"2015-01-03",
"2015-01-03",
"2015-01-09",
"2015-01-10",
"2015-01-14",
"2015-01-14",
"2015-01-17",
"2015-01-21",
"2015-01-21",
"2015-01-21",
"2015-01-26",
"2015-01-28",
"2015-01-28",
"2015-01-28",
"2015-01-30",
"2015-01-31",
"2015-02-12",
"2015-02-19",
"2015-02-23",
"2015-03-04",
"2015-03-05",
"2015-03-05",
"2015-03-07",
"2015-03-10",
"2015-03-11",
"2015-03-12",
"2015-03-12",
"2015-03-13",
"2015-03-15",
"2015-03-17",
"2015-03-18",
"2015-03-24",
"2015-03-24",
"2015-03-25",
"2015-03-28",
"2015-04-04",
"2015-04-06",
"2015-04-08",
"2015-04-10",
"2015-04-15",
"2015-04-18",
"2015-04-20",
"2015-04-21",
"2015-05-04",
"2015-05-05",
"2015-05-05",
"2015-05-05",
"2015-05-08",
"2015-05-09",
"2015-05-09",
"2015-05-15",
"2015-05-18",
"2015-05-20",
"2015-05-21",
"2015-05-21",
"2015-05-23",
"2015-05-24",
"2015-05-25",
"2015-05-25",
"2015-05-27",
"2015-05-27",
"2015-05-30",
"2015-06-15",
"2015-06-16",
"2015-06-18",
"2015-06-19",
"2015-06-20",
"2015-06-23",
"2015-06-24",
"2015-06-25",
"2015-06-26",
"2015-06-30",
"2015-07-07",
"2015-07-10",
"2015-07-12",
"2015-07-14",
"2015-07-15",
"2015-07-15",
"2015-07-16",
"2015-07-17",
"2015-07-22",
"2015-07-23",
"2015-08-01",
"2015-08-05",
"2015-08-06",
"2015-08-09",
"2015-08-10",
"2015-08-11",
"2015-08-12",
"2015-08-12",
"2015-08-13",
"2015-08-14",
"2015-08-15",
"2015-08-20",
"2015-08-24",
"2015-08-24",
"2015-08-25",
"2015-08-25",
"2015-08-26",
"2015-08-28",
"2015-08-28",
"2015-08-28",
"2015-09-02",
"2015-09-05",
"2015-09-10",
"2015-09-12",
"2015-09-13",
"2015-09-13",
"2015-09-14",
"2015-09-16",
"2015-09-17",
"2015-09-17",
"2015-09-19",
"2015-09-21",
"2015-09-22",
"2015-09-28",
"2015-09-30",
"2015-10-16",
"2015-10-18",
"2015-10-20",
"2015-10-21",
"2015-10-25",
"2015-10-28",
"2015-10-29",
"2015-10-29",
"2015-11-05",
"2015-11-06",
"2015-11-07",
"2015-11-07",
"2015-11-10",
"2015-11-15",
"2015-11-18",
"2015-11-19",
"2015-11-20",
"2015-11-23",
"2015-11-27",
"2015-11-28",
"2015-12-10",
"2015-12-17",
"2015-12-29",
"2016-01-06",
"2016-01-10",
"2016-01-11",
"2016-01-14",
"2016-01-17",
"2016-01-17",
"2016-01-19",
"2016-01-20",
"2016-01-20",
"2016-01-23",
"2016-01-29",
"2016-01-31",
"2016-02-05",
"2016-02-08",
"2016-02-10",
"2016-02-10",
"2016-02-10",
"2016-02-11",
"2016-02-11",
"2016-02-20",
"2016-02-24",
"2016-02-27",
"2016-03-01",
"2016-03-01",
"2016-03-04",
"2016-03-08",
"2016-03-09",
"2016-03-09",
"2016-03-12",
"2016-03-13",
"2016-03-13",
"2016-03-14",
"2016-03-14",
"2016-03-16",
"2016-03-18",
"2016-03-20",
"2016-03-26",
"2016-03-26",
"2016-03-26",
"2016-03-31",
"2016-03-31",
"2016-04-12",
"2016-04-27",
"2016-05-01",
"2016-05-05",
"2016-05-09",
"2016-05-18",
"2016-05-19",
"2016-05-19",
"2016-05-20",
"2016-05-22",
"2016-05-29",
"2016-05-31",
"2016-06-01",
"2016-06-02",
"2016-06-04",
"2016-06-04",
"2016-06-07",
"2016-06-10",
"2016-06-12",
"2016-06-12",
"2016-06-14",
"2016-06-15",
"2016-06-19",
"2016-06-22",
"2016-06-27",
"2016-06-28",
"2016-06-30",
"2016-07-01"
],
"xbins": {
"end": "2016-12-31 12:00",
"size": "M1",
"start": "1983-12-31 12:00"
}
}
],
"layout": {
"paper_bgcolor": "rgb(240, 240, 240)",
"plot_bgcolor": "rgb(240, 240, 240)",
"title": "Shooting Incidents",
"updatemenus": [
{
"active": 1,
"buttons": [
{
"args": [
"xbins.size",
"D1"
],
"label": "Day",
"method": "restyle"
},
{
"args": [
"xbins.size",
"M1"
],
"label": "Month",
"method": "restyle"
},
{
"args": [
"xbins.size",
"M3"
],
"label": "Quater",
"method": "restyle"
},
{
"args": [
"xbins.size",
"M6"
],
"label": "Half Year",
"method": "restyle"
},
{
"args": [
"xbins.size",
"M12"
],
"label": "Year",
"method": "restyle"
}
],
"showactive": true,
"x": 0.1,
"xref": "paper",
"y": 1.15,
"yanchor": "top",
"yref": "paper"
}
],
"xaxis": {
"title": "",
"type": "date"
},
"yaxis": {
"title": "Shootings Incidents",
"type": "linear"
}
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import plotly.offline as off\n",
"\n",
"import pandas as pd\n",
"\n",
"off.init_notebook_mode(connected=False)\n",
"\n",
"df = pd.read_csv(\"https://plotly.com/~public.health/17.csv\")\n",
"\n",
"data = [dict(\n",
" x = df['date'],\n",
" autobinx = False,\n",
" autobiny = True,\n",
" marker = dict(color = 'rgb(68, 68, 68)'),\n",
" name = 'date',\n",
" type = 'histogram',\n",
" xbins = dict(\n",
" end = '2016-12-31 12:00',\n",
" size = 'M1',\n",
" start = '1983-12-31 12:00'\n",
" )\n",
")]\n",
"\n",
"layout = dict(\n",
" paper_bgcolor = 'rgb(240, 240, 240)',\n",
" plot_bgcolor = 'rgb(240, 240, 240)',\n",
" title = 'Shooting Incidents',\n",
" xaxis = dict(\n",
" title = '',\n",
" type = 'date'\n",
" ),\n",
" yaxis = dict(\n",
" title = 'Shootings Incidents',\n",
" type = 'linear'\n",
" ),\n",
" updatemenus = [dict(\n",
" x = 0.1,\n",
" y = 1.15,\n",
" xref = 'paper',\n",
" yref = 'paper',\n",
" yanchor = 'top',\n",
" active = 1,\n",
" showactive = True,\n",
" buttons = [\n",
" dict(\n",
" args = ['xbins.size', 'D1'],\n",
" label = 'Day',\n",
" method = 'restyle',\n",
" ), dict(\n",
" args = ['xbins.size', 'M1'],\n",
" label = 'Month',\n",
" method = 'restyle',\n",
" ), dict(\n",
" args = ['xbins.size', 'M3'],\n",
" label = 'Quater',\n",
" method = 'restyle',\n",
" ), dict(\n",
" args = ['xbins.size', 'M6'],\n",
" label = 'Half Year',\n",
" method = 'restyle',\n",
" ), dict(\n",
" args = ['xbins.size', 'M12'],\n",
" label = 'Year',\n",
" method = 'restyle',\n",
" )]\n",
" )]\n",
")\n",
"\n",
"off.iplot({'data': data,'layout': layout}, validate=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Mapping with Aggregates "
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"scrolled": false
},
"outputs": [
{
"data": {
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"application/vnd.plotly.v1+json": {
"data": [
{
"autocolorscale": false,
"colorscale": "Portland",
"locationmode": "country names",
"locations": [
"Switzerland",
"Iceland",
"Denmark",
"Norway",
"Canada",
"Finland",
"Netherlands",
"Sweden",
"New Zealand",
"Australia",
"Israel",
"Costa Rica",
"Austria",
"Mexico",
"United States",
"Brazil",
"Luxembourg",
"Ireland",
"Belgium",
"United Arab Emirates",
"United Kingdom",
"Oman",
"Venezuela",
"Singapore",
"Panama",
"Germany",
"Chile",
"Qatar",
"France",
"Argentina",
"Czech Republic",
"Uruguay",
"Colombia",
"Thailand",
"Saudi Arabia",
"Spain",
"Malta",
"Taiwan",
"Kuwait",
"Suriname",
"Trinidad and Tobago",
"El Salvador",
"Guatemala",
"Uzbekistan",
"Slovakia",
"Japan",
"South Korea",
"Ecuador",
"Bahrain",
"Italy",
"Bolivia",
"Moldova",
"Paraguay",
"Kazakhstan",
"Slovenia",
"Lithuania",
"Nicaragua",
"Peru",
"Belarus",
"Poland",
"Malaysia",
"Croatia",
"Libya",
"Russia",
"Jamaica",
"North Cyprus",
"Cyprus",
"Algeria",
"Kosovo",
"Turkmenistan",
"Mauritius",
"Hong Kong",
"Estonia",
"Indonesia",
"Vietnam",
"Turkey",
"Kyrgyzstan",
"Nigeria",
"Bhutan",
"Azerbaijan",
"Pakistan",
"Jordan",
"Montenegro",
"China",
"Zambia",
"Romania",
"Serbia",
"Portugal",
"Latvia",
"Philippines",
"Somaliland region",
"Morocco",
"Macedonia",
"Mozambique",
"Albania",
"Bosnia and Herzegovina",
"Lesotho",
"Dominican Republic",
"Laos",
"Mongolia",
"Swaziland",
"Greece",
"Lebanon",
"Hungary",
"Honduras",
"Tajikistan",
"Tunisia",
"Palestinian Territories",
"Bangladesh",
"Iran",
"Ukraine",
"Iraq",
"South Africa",
"Ghana",
"Zimbabwe",
"Liberia",
"India",
"Sudan",
"Haiti",
"Congo (Kinshasa)",
"Nepal",
"Ethiopia",
"Sierra Leone",
"Mauritania",
"Kenya",
"Djibouti",
"Armenia",
"Botswana",
"Myanmar",
"Georgia",
"Malawi",
"Sri Lanka",
"Cameroon",
"Bulgaria",
"Egypt",
"Yemen",
"Angola",
"Mali",
"Congo (Brazzaville)",
"Comoros",
"Uganda",
"Senegal",
"Gabon",
"Niger",
"Cambodia",
"Tanzania",
"Madagascar",
"Central African Republic",
"Chad",
"Guinea",
"Ivory Coast",
"Burkina Faso",
"Afghanistan",
"Rwanda",
"Benin",
"Syria",
"Burundi",
"Togo",
"Denmark",
"Switzerland",
"Iceland",
"Norway",
"Finland",
"Canada",
"Netherlands",
"New Zealand",
"Australia",
"Sweden",
"Israel",
"Austria",
"United States",
"Costa Rica",
"Puerto Rico",
"Germany",
"Brazil",
"Belgium",
"Ireland",
"Luxembourg",
"Mexico",
"Singapore",
"United Kingdom",
"Chile",
"Panama",
"Argentina",
"Czech Republic",
"United Arab Emirates",
"Uruguay",
"Malta",
"Colombia",
"France",
"Thailand",
"Saudi Arabia",
"Taiwan",
"Qatar",
"Spain",
"Algeria",
"Guatemala",
"Suriname",
"Kuwait",
"Bahrain",
"Trinidad and Tobago",
"Venezuela",
"Slovakia",
"El Salvador",
"Malaysia",
"Nicaragua",
"Uzbekistan",
"Italy",
"Ecuador",
"Belize",
"Japan",
"Kazakhstan",
"Moldova",
"Russia",
"Poland",
"South Korea",
"Bolivia",
"Lithuania",
"Belarus",
"North Cyprus",
"Slovenia",
"Peru",
"Turkmenistan",
"Mauritius",
"Libya",
"Latvia",
"Cyprus",
"Paraguay",
"Romania",
"Estonia",
"Jamaica",
"Croatia",
"Hong Kong",
"Somalia",
"Kosovo",
"Turkey",
"Indonesia",
"Jordan",
"Azerbaijan",
"Philippines",
"China",
"Bhutan",
"Kyrgyzstan",
"Serbia",
"Bosnia and Herzegovina",
"Montenegro",
"Dominican Republic",
"Morocco",
"Hungary",
"Pakistan",
"Lebanon",
"Portugal",
"Macedonia",
"Vietnam",
"Somaliland Region",
"Tunisia",
"Greece",
"Tajikistan",
"Mongolia",
"Laos",
"Nigeria",
"Honduras",
"Iran",
"Zambia",
"Nepal",
"Palestinian Territories",
"Albania",
"Bangladesh",
"Sierra Leone",
"Iraq",
"Namibia",
"Cameroon",
"Ethiopia",
"South Africa",
"Sri Lanka",
"India",
"Myanmar",
"Egypt",
"Armenia",
"Kenya",
"Ukraine",
"Ghana",
"Congo (Kinshasa)",
"Georgia",
"Congo (Brazzaville)",
"Senegal",
"Bulgaria",
"Mauritania",
"Zimbabwe",
"Malawi",
"Sudan",
"Gabon",
"Mali",
"Haiti",
"Botswana",
"Comoros",
"Ivory Coast",
"Cambodia",
"Angola",
"Niger",
"South Sudan",
"Chad",
"Burkina Faso",
"Uganda",
"Yemen",
"Madagascar",
"Tanzania",
"Liberia",
"Guinea",
"Rwanda",
"Benin",
"Afghanistan",
"Togo",
"Syria",
"Burundi",
"Norway",
"Denmark",
"Iceland",
"Switzerland",
"Finland",
"Netherlands",
"Canada",
"New Zealand",
"Sweden",
"Australia",
"Israel",
"Costa Rica",
"Austria",
"United States",
"Ireland",
"Germany",
"Belgium",
"Luxembourg",
"United Kingdom",
"Chile",
"United Arab Emirates",
"Brazil",
"Czech Republic",
"Argentina",
"Mexico",
"Singapore",
"Malta",
"Uruguay",
"Guatemala",
"Panama",
"France",
"Thailand",
"Taiwan Province of China",
"Spain",
"Qatar",
"Colombia",
"Saudi Arabia",
"Trinidad and Tobago",
"Kuwait",
"Slovakia",
"Bahrain",
"Malaysia",
"Nicaragua",
"Ecuador",
"El Salvador",
"Poland",
"Uzbekistan",
"Italy",
"Russia",
"Belize",
"Japan",
"Lithuania",
"Algeria",
"Latvia",
"South Korea",
"Moldova",
"Romania",
"Bolivia",
"Turkmenistan",
"Kazakhstan",
"North Cyprus",
"Slovenia",
"Peru",
"Mauritius",
"Cyprus",
"Estonia",
"Belarus",
"Libya",
"Turkey",
"Paraguay",
"Hong Kong S.A.R., China",
"Philippines",
"Serbia",
"Jordan",
"Hungary",
"Jamaica",
"Croatia",
"Kosovo",
"China",
"Pakistan",
"Indonesia",
"Venezuela",
"Montenegro",
"Morocco",
"Azerbaijan",
"Dominican Republic",
"Greece",
"Lebanon",
"Portugal",
"Bosnia and Herzegovina",
"Honduras",
"Macedonia",
"Somalia",
"Vietnam",
"Nigeria",
"Tajikistan",
"Bhutan",
"Kyrgyzstan",
"Nepal",
"Mongolia",
"South Africa",
"Tunisia",
"Palestinian Territories",
"Egypt",
"Bulgaria",
"Sierra Leone",
"Cameroon",
"Iran",
"Albania",
"Bangladesh",
"Namibia",
"Kenya",
"Mozambique",
"Myanmar",
"Senegal",
"Zambia",
"Iraq",
"Gabon",
"Ethiopia",
"Sri Lanka",
"Armenia",
"India",
"Mauritania",
"Congo (Brazzaville)",
"Georgia",
"Congo (Kinshasa)",
"Mali",
"Ivory Coast",
"Cambodia",
"Sudan",
"Ghana",
"Ukraine",
"Uganda",
"Burkina Faso",
"Niger",
"Malawi",
"Chad",
"Zimbabwe",
"Lesotho",
"Angola",
"Afghanistan",
"Botswana",
"Benin",
"Madagascar",
"Haiti",
"Yemen",
"South Sudan",
"Liberia",
"Guinea",
"Togo",
"Rwanda",
"Syria",
"Tanzania",
"Burundi",
"Central African Republic"
],
"reversescale": true,
"transforms": [
{
"aggregations": [
{
"enabled": true,
"func": "sum",
"target": "z"
}
],
"groups": [
"Switzerland",
"Iceland",
"Denmark",
"Norway",
"Canada",
"Finland",
"Netherlands",
"Sweden",
"New Zealand",
"Australia",
"Israel",
"Costa Rica",
"Austria",
"Mexico",
"United States",
"Brazil",
"Luxembourg",
"Ireland",
"Belgium",
"United Arab Emirates",
"United Kingdom",
"Oman",
"Venezuela",
"Singapore",
"Panama",
"Germany",
"Chile",
"Qatar",
"France",
"Argentina",
"Czech Republic",
"Uruguay",
"Colombia",
"Thailand",
"Saudi Arabia",
"Spain",
"Malta",
"Taiwan",
"Kuwait",
"Suriname",
"Trinidad and Tobago",
"El Salvador",
"Guatemala",
"Uzbekistan",
"Slovakia",
"Japan",
"South Korea",
"Ecuador",
"Bahrain",
"Italy",
"Bolivia",
"Moldova",
"Paraguay",
"Kazakhstan",
"Slovenia",
"Lithuania",
"Nicaragua",
"Peru",
"Belarus",
"Poland",
"Malaysia",
"Croatia",
"Libya",
"Russia",
"Jamaica",
"North Cyprus",
"Cyprus",
"Algeria",
"Kosovo",
"Turkmenistan",
"Mauritius",
"Hong Kong",
"Estonia",
"Indonesia",
"Vietnam",
"Turkey",
"Kyrgyzstan",
"Nigeria",
"Bhutan",
"Azerbaijan",
"Pakistan",
"Jordan",
"Montenegro",
"China",
"Zambia",
"Romania",
"Serbia",
"Portugal",
"Latvia",
"Philippines",
"Somaliland region",
"Morocco",
"Macedonia",
"Mozambique",
"Albania",
"Bosnia and Herzegovina",
"Lesotho",
"Dominican Republic",
"Laos",
"Mongolia",
"Swaziland",
"Greece",
"Lebanon",
"Hungary",
"Honduras",
"Tajikistan",
"Tunisia",
"Palestinian Territories",
"Bangladesh",
"Iran",
"Ukraine",
"Iraq",
"South Africa",
"Ghana",
"Zimbabwe",
"Liberia",
"India",
"Sudan",
"Haiti",
"Congo (Kinshasa)",
"Nepal",
"Ethiopia",
"Sierra Leone",
"Mauritania",
"Kenya",
"Djibouti",
"Armenia",
"Botswana",
"Myanmar",
"Georgia",
"Malawi",
"Sri Lanka",
"Cameroon",
"Bulgaria",
"Egypt",
"Yemen",
"Angola",
"Mali",
"Congo (Brazzaville)",
"Comoros",
"Uganda",
"Senegal",
"Gabon",
"Niger",
"Cambodia",
"Tanzania",
"Madagascar",
"Central African Republic",
"Chad",
"Guinea",
"Ivory Coast",
"Burkina Faso",
"Afghanistan",
"Rwanda",
"Benin",
"Syria",
"Burundi",
"Togo",
"Denmark",
"Switzerland",
"Iceland",
"Norway",
"Finland",
"Canada",
"Netherlands",
"New Zealand",
"Australia",
"Sweden",
"Israel",
"Austria",
"United States",
"Costa Rica",
"Puerto Rico",
"Germany",
"Brazil",
"Belgium",
"Ireland",
"Luxembourg",
"Mexico",
"Singapore",
"United Kingdom",
"Chile",
"Panama",
"Argentina",
"Czech Republic",
"United Arab Emirates",
"Uruguay",
"Malta",
"Colombia",
"France",
"Thailand",
"Saudi Arabia",
"Taiwan",
"Qatar",
"Spain",
"Algeria",
"Guatemala",
"Suriname",
"Kuwait",
"Bahrain",
"Trinidad and Tobago",
"Venezuela",
"Slovakia",
"El Salvador",
"Malaysia",
"Nicaragua",
"Uzbekistan",
"Italy",
"Ecuador",
"Belize",
"Japan",
"Kazakhstan",
"Moldova",
"Russia",
"Poland",
"South Korea",
"Bolivia",
"Lithuania",
"Belarus",
"North Cyprus",
"Slovenia",
"Peru",
"Turkmenistan",
"Mauritius",
"Libya",
"Latvia",
"Cyprus",
"Paraguay",
"Romania",
"Estonia",
"Jamaica",
"Croatia",
"Hong Kong",
"Somalia",
"Kosovo",
"Turkey",
"Indonesia",
"Jordan",
"Azerbaijan",
"Philippines",
"China",
"Bhutan",
"Kyrgyzstan",
"Serbia",
"Bosnia and Herzegovina",
"Montenegro",
"Dominican Republic",
"Morocco",
"Hungary",
"Pakistan",
"Lebanon",
"Portugal",
"Macedonia",
"Vietnam",
"Somaliland Region",
"Tunisia",
"Greece",
"Tajikistan",
"Mongolia",
"Laos",
"Nigeria",
"Honduras",
"Iran",
"Zambia",
"Nepal",
"Palestinian Territories",
"Albania",
"Bangladesh",
"Sierra Leone",
"Iraq",
"Namibia",
"Cameroon",
"Ethiopia",
"South Africa",
"Sri Lanka",
"India",
"Myanmar",
"Egypt",
"Armenia",
"Kenya",
"Ukraine",
"Ghana",
"Congo (Kinshasa)",
"Georgia",
"Congo (Brazzaville)",
"Senegal",
"Bulgaria",
"Mauritania",
"Zimbabwe",
"Malawi",
"Sudan",
"Gabon",
"Mali",
"Haiti",
"Botswana",
"Comoros",
"Ivory Coast",
"Cambodia",
"Angola",
"Niger",
"South Sudan",
"Chad",
"Burkina Faso",
"Uganda",
"Yemen",
"Madagascar",
"Tanzania",
"Liberia",
"Guinea",
"Rwanda",
"Benin",
"Afghanistan",
"Togo",
"Syria",
"Burundi",
"Norway",
"Denmark",
"Iceland",
"Switzerland",
"Finland",
"Netherlands",
"Canada",
"New Zealand",
"Sweden",
"Australia",
"Israel",
"Costa Rica",
"Austria",
"United States",
"Ireland",
"Germany",
"Belgium",
"Luxembourg",
"United Kingdom",
"Chile",
"United Arab Emirates",
"Brazil",
"Czech Republic",
"Argentina",
"Mexico",
"Singapore",
"Malta",
"Uruguay",
"Guatemala",
"Panama",
"France",
"Thailand",
"Taiwan Province of China",
"Spain",
"Qatar",
"Colombia",
"Saudi Arabia",
"Trinidad and Tobago",
"Kuwait",
"Slovakia",
"Bahrain",
"Malaysia",
"Nicaragua",
"Ecuador",
"El Salvador",
"Poland",
"Uzbekistan",
"Italy",
"Russia",
"Belize",
"Japan",
"Lithuania",
"Algeria",
"Latvia",
"South Korea",
"Moldova",
"Romania",
"Bolivia",
"Turkmenistan",
"Kazakhstan",
"North Cyprus",
"Slovenia",
"Peru",
"Mauritius",
"Cyprus",
"Estonia",
"Belarus",
"Libya",
"Turkey",
"Paraguay",
"Hong Kong S.A.R., China",
"Philippines",
"Serbia",
"Jordan",
"Hungary",
"Jamaica",
"Croatia",
"Kosovo",
"China",
"Pakistan",
"Indonesia",
"Venezuela",
"Montenegro",
"Morocco",
"Azerbaijan",
"Dominican Republic",
"Greece",
"Lebanon",
"Portugal",
"Bosnia and Herzegovina",
"Honduras",
"Macedonia",
"Somalia",
"Vietnam",
"Nigeria",
"Tajikistan",
"Bhutan",
"Kyrgyzstan",
"Nepal",
"Mongolia",
"South Africa",
"Tunisia",
"Palestinian Territories",
"Egypt",
"Bulgaria",
"Sierra Leone",
"Cameroon",
"Iran",
"Albania",
"Bangladesh",
"Namibia",
"Kenya",
"Mozambique",
"Myanmar",
"Senegal",
"Zambia",
"Iraq",
"Gabon",
"Ethiopia",
"Sri Lanka",
"Armenia",
"India",
"Mauritania",
"Congo (Brazzaville)",
"Georgia",
"Congo (Kinshasa)",
"Mali",
"Ivory Coast",
"Cambodia",
"Sudan",
"Ghana",
"Ukraine",
"Uganda",
"Burkina Faso",
"Niger",
"Malawi",
"Chad",
"Zimbabwe",
"Lesotho",
"Angola",
"Afghanistan",
"Botswana",
"Benin",
"Madagascar",
"Haiti",
"Yemen",
"South Sudan",
"Liberia",
"Guinea",
"Togo",
"Rwanda",
"Syria",
"Tanzania",
"Burundi",
"Central African Republic"
],
"type": "aggregate"
}
],
"type": "choropleth",
"z": [
7.587000000000001,
7.561,
7.527,
7.522,
7.4270000000000005,
7.406000000000001,
7.377999999999999,
7.364,
7.2860000000000005,
7.284,
7.278,
7.226,
7.2,
7.187,
7.119,
6.983,
6.946000000000001,
6.94,
6.937,
6.901,
6.867000000000001,
6.853,
6.81,
6.797999999999999,
6.7860000000000005,
6.75,
6.67,
6.611000000000001,
6.575,
6.574,
6.505,
6.485,
6.477,
6.455,
6.4110000000000005,
6.329,
6.3020000000000005,
6.297999999999999,
6.295,
6.269,
6.167999999999999,
6.13,
6.122999999999999,
6.002999999999999,
5.995,
5.987,
5.984,
5.975,
5.96,
5.9479999999999995,
5.89,
5.888999999999999,
5.877999999999999,
5.855,
5.848,
5.832999999999999,
5.827999999999999,
5.824,
5.813,
5.791,
5.77,
5.7589999999999995,
5.754,
5.716,
5.709,
5.695,
5.689,
5.605,
5.5889999999999995,
5.547999999999999,
5.477,
5.474,
5.428999999999999,
5.399,
5.36,
5.332000000000001,
5.2860000000000005,
5.268,
5.252999999999999,
5.212000000000001,
5.194,
5.192,
5.192,
5.14,
5.129,
5.124,
5.122999999999999,
5.102,
5.098,
5.073,
5.0569999999999995,
5.013,
5.007,
4.971,
4.959,
4.949,
4.898,
4.885,
4.876,
4.874,
4.867,
4.857,
4.8389999999999995,
4.8,
4.788,
4.7860000000000005,
4.739,
4.715,
4.694,
4.686,
4.681,
4.677,
4.6419999999999995,
4.633,
4.61,
4.571000000000001,
4.565,
4.55,
4.518,
4.5169999999999995,
4.513999999999999,
4.512,
4.507,
4.436,
4.419,
4.369,
4.35,
4.332,
4.3069999999999995,
4.297,
4.292,
4.271,
4.252,
4.218,
4.194,
4.077,
4.033,
3.995,
3.989,
3.9560000000000004,
3.931,
3.904,
3.8960000000000004,
3.845,
3.819,
3.781,
3.681,
3.678,
3.667,
3.656,
3.655,
3.5869999999999997,
3.575,
3.465,
3.34,
3.0060000000000002,
2.905,
2.839,
7.526,
7.5089999999999995,
7.501,
7.497999999999999,
7.412999999999999,
7.404,
7.3389999999999995,
7.334,
7.313,
7.291,
7.267,
7.119,
7.104,
7.087000000000001,
7.039,
6.994,
6.952000000000001,
6.928999999999999,
6.907,
6.871,
6.778,
6.739,
6.725,
6.705,
6.7010000000000005,
6.65,
6.596,
6.5729999999999995,
6.545,
6.4879999999999995,
6.481,
6.478,
6.474,
6.379,
6.379,
6.375,
6.361000000000001,
6.355,
6.324,
6.269,
6.239,
6.218,
6.167999999999999,
6.084,
6.077999999999999,
6.068,
6.005,
5.992000000000001,
5.987,
5.977,
5.976,
5.956,
5.921,
5.919,
5.897,
5.856,
5.835,
5.835,
5.822,
5.813,
5.8020000000000005,
5.771,
5.768,
5.742999999999999,
5.6579999999999995,
5.648,
5.615,
5.56,
5.546,
5.537999999999999,
5.528,
5.517,
5.51,
5.4879999999999995,
5.457999999999999,
5.44,
5.401,
5.388999999999999,
5.314,
5.303,
5.291,
5.279,
5.245,
5.196000000000001,
5.185,
5.1770000000000005,
5.162999999999999,
5.1610000000000005,
5.155,
5.151,
5.145,
5.132000000000001,
5.129,
5.122999999999999,
5.121,
5.061,
5.0569999999999995,
5.045,
5.033,
4.996,
4.907,
4.876,
4.875,
4.871,
4.813,
4.795,
4.793,
4.754,
4.655,
4.643,
4.635,
4.575,
4.574,
4.513,
4.508,
4.459,
4.415,
4.404,
4.395,
4.362,
4.36,
4.356,
4.324,
4.276,
4.272,
4.252,
4.236000000000001,
4.218999999999999,
4.217,
4.2010000000000005,
4.1930000000000005,
4.156000000000001,
4.138999999999999,
4.121,
4.073,
4.0280000000000005,
3.9739999999999998,
3.9560000000000004,
3.9160000000000004,
3.907,
3.866,
3.8560000000000003,
3.832,
3.763,
3.739,
3.739,
3.7239999999999998,
3.695,
3.6660000000000004,
3.622,
3.6069999999999998,
3.515,
3.484,
3.36,
3.303,
3.069,
2.905,
7.537000179,
7.521999836,
7.504000187000001,
7.493999958,
7.468999863,
7.376999855,
7.315999985,
7.31400013,
7.28399992,
7.28399992,
7.212999821,
7.078999996,
7.006000042,
6.993000031,
6.977000237,
6.951000214,
6.890999794,
6.862999916000001,
6.714000225,
6.65199995,
6.647999763,
6.635000229,
6.609000206,
6.598999977,
6.578000069,
6.5720000270000005,
6.52699995,
6.453999996,
6.453999996,
6.452000141,
6.441999912000001,
6.423999786,
6.421999931,
6.402999877999999,
6.375,
6.3569998739999996,
6.343999863,
6.168000221000001,
6.105000018999999,
6.09800005,
6.086999893,
6.084000111,
6.071000099,
6.007999897,
6.002999783,
5.97300005,
5.971000195,
5.964000225,
5.962999821,
5.9559998510000005,
5.920000076,
5.90199995,
5.872000217,
5.849999905,
5.837999821,
5.837999821,
5.8249998089999995,
5.822999954,
5.8220000270000005,
5.818999767,
5.809999942999999,
5.757999897,
5.715000152999999,
5.629000187000001,
5.620999812999999,
5.611000061,
5.568999767,
5.525000095,
5.5,
5.493000031,
5.472000122000001,
5.429999828,
5.394999981000001,
5.335999966,
5.323999882,
5.31099987,
5.293000221000001,
5.278999805,
5.2729997630000005,
5.269000053,
5.262000083999999,
5.25,
5.236999989,
5.235000134,
5.234000206,
5.230000018999999,
5.2270002369999995,
5.224999905,
5.195000172,
5.18200016,
5.181000233,
5.1750001910000005,
5.151000023,
5.073999882,
5.073999882,
5.040999889,
5.011000156000001,
5.004000187,
4.961999893,
4.954999924,
4.828999996,
4.804999828,
4.775000095,
4.735000134,
4.714000225,
4.709000111,
4.695000172,
4.691999912,
4.644000053,
4.607999802,
4.573999882,
4.552999973,
4.5500001910000005,
4.545000076,
4.534999847,
4.513999939,
4.497000217,
4.465000153,
4.460000038,
4.440000057,
4.375999928,
4.315000057,
4.291999817,
4.290999889,
4.285999775,
4.28000021,
4.190000057,
4.179999828,
4.168000221000001,
4.138999939,
4.1199998860000004,
4.096000195,
4.0809998510000005,
4.032000065,
4.027999878,
3.970000029,
3.9360001089999996,
3.875,
3.808000088,
3.7950000760000004,
3.79399991,
3.766000032,
3.657000065,
3.644000053,
3.6029999260000003,
3.592999935,
3.59100008,
3.5329999919999997,
3.5069999689999998,
3.4949998860000004,
3.4709999560000004,
3.461999893,
3.348999977,
2.904999971,
2.6930000780000003
]
}
],
"layout": {
"height": 600,
"title": "Plotly Aggregations
use dropdown to change aggregation",
"updatemenus": [
{
"active": 1,
"buttons": [
{
"args": [
"transforms[0].aggregations[0].func",
"count"
],
"label": "count",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"sum"
],
"label": "sum",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"avg"
],
"label": "avg",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"median"
],
"label": "median",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"mode"
],
"label": "mode",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"rms"
],
"label": "rms",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"stddev"
],
"label": "stddev",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"min"
],
"label": "min",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"max"
],
"label": "max",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"first"
],
"label": "first",
"method": "restyle"
},
{
"args": [
"transforms[0].aggregations[0].func",
"last"
],
"label": "last",
"method": "restyle"
}
],
"showactive": false,
"x": 0.85,
"xref": "paper",
"y": 1.15,
"yanchor": "top",
"yref": "paper"
}
],
"width": 900,
"xaxis": {
"title": "Subject"
},
"yaxis": {
"range": [
0,
22
],
"title": "Score"
}
}
},
"text/html": [
""
],
"text/vnd.plotly.v1+html": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import plotly.offline as off\n",
"\n",
"import pandas as pd\n",
"\n",
"off.init_notebook_mode(connected=False)\n",
"\n",
"df = pd.read_csv(\"https://raw.githubusercontent.com/bcdunbar/datasets/master/worldhappiness.csv\")\n",
"\n",
"aggs = [\"count\",\"sum\",\"avg\",\"median\",\"mode\",\"rms\",\"stddev\",\"min\",\"max\",\"first\",\"last\"]\n",
"\n",
"agg = []\n",
"agg_func = []\n",
"for i in range(0, len(aggs)):\n",
" agg = dict(\n",
" args=['transforms[0].aggregations[0].func', aggs[i]],\n",
" label=aggs[i],\n",
" method='restyle'\n",
" )\n",
" agg_func.append(agg)\n",
"\n",
"data = [dict(\n",
" type = 'choropleth',\n",
" locationmode = 'country names',\n",
" locations = df['Country'],\n",
" z = df['HappinessScore'],\n",
" autocolorscale = False,\n",
" colorscale = 'Portland',\n",
" reversescale = True,\n",
" transforms = [dict(\n",
" type = 'aggregate',\n",
" groups = df['Country'],\n",
" aggregations = [dict(\n",
" target = 'z', func = 'sum', enabled = True)\n",
" ]\n",
" )]\n",
")]\n",
"\n",
"layout = dict(\n",
" title = 'Plotly Aggregations
use dropdown to change aggregation',\n",
" xaxis = dict(title = 'Subject'),\n",
" yaxis = dict(title = 'Score', range = [0,22]),\n",
" height = 600,\n",
" width = 900,\n",
" updatemenus = [dict(\n",
" x = 0.85,\n",
" y = 1.15,\n",
" xref = 'paper',\n",
" yref = 'paper',\n",
" yanchor = 'top',\n",
" active = 1,\n",
" showactive = False,\n",
" buttons = agg_func\n",
" )]\n",
")\n",
"\n",
"off.iplot({'data': data,'layout': layout}, validate=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"#### Reference\n",
"See https://plotly.com/python/reference/ for more information and chart attribute options!"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
""
],
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
""
],
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"Collecting git+https://github.com/plotly/publisher.git\n",
" Cloning https://github.com/plotly/publisher.git to c:\\users\\branden\\appdata\\local\\temp\\pip-ftibjt4h-build\n",
"Installing collected packages: publisher\n",
" Found existing installation: publisher 0.11\n",
" Uninstalling publisher-0.11:\n",
" Successfully uninstalled publisher-0.11\n",
" Running setup.py install for publisher: started\n",
" Running setup.py install for publisher: finished with status 'done'\n",
"Successfully installed publisher-0.11\n"
]
},
{
"name": "stderr",
"output_type": "stream",
"text": [
"C:\\Users\\Branden\\Anaconda3\\envs\\ipykernel_py2\\lib\\site-packages\\IPython\\nbconvert.py:13: ShimWarning:\n",
"\n",
"The `IPython.nbconvert` package has been deprecated. You should import from nbconvert instead.\n",
"\n",
"C:\\Users\\Branden\\Anaconda3\\envs\\ipykernel_py2\\lib\\site-packages\\publisher\\publisher.py:53: UserWarning:\n",
"\n",
"Did you \"Save\" this notebook before running this command? Remember to save, always save.\n",
"\n"
]
}
],
"source": [
"from IPython.display import display, HTML\n",
"\n",
"display(HTML(''))\n",
"display(HTML(''))\n",
"\n",
"! pip install git+https://github.com/plotly/publisher.git --upgrade\n",
"import publisher\n",
"publisher.publish(\n",
" 'aggregations.ipynb', 'python/aggregations/', 'Aggregations',\n",
" 'How to use aggregates in Python with Plotly.',\n",
" title = 'Aggregations | Plotly',\n",
" has_thumbnail='true', thumbnail='thumbnail/aggregations.jpg', \n",
" language='python', uses_plotly_offline=True,\n",
" page_type='example_index',\n",
" display_as='transforms', order=3,\n",
" ipynb= '~notebook_demo/192')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"anaconda-cloud": {},
"kernelspec": {
"display_name": "Python 2",
"language": "python",
"name": "python2"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.12"
}
},
"nbformat": 4,
"nbformat_minor": 2
}