{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name": "CoronaBasic.ipynb", "provenance": [], "collapsed_sections": [] }, "kernelspec": { "name": "python3", "display_name": "Python 3" } }, "cells": [ { "cell_type": "markdown", "metadata": { "id": "htDHburyBuEe", "colab_type": "text" }, "source": [ "# Preliminary Analysis of CoronaVirus Time Series Data\n", "In this notebook we will conduct some preliminary analysis and forecasting on the Coronavirus time seires data. For this analysis we will look at forecasting using the data scraper.\n", "\n", "**Warning this is a basic analysis/machine learning model. The goal of this notebook is to gage the utility of data augmentation/transfer learning for virus forecasting. NOT provide actionable insights. It would additional rounds of training/validation + verification by epidemiologists and public health experts before I would be confident relying on using it for any actionable insights**" ] }, { "cell_type": "code", "metadata": { "id": "CA1NxnWmHOAQ", "colab_type": "code", "outputId": "660af867-2d02-4a00-aa96-4e8461c4f045", "colab": { "base_uri": "https://localhost:8080/", "height": 1000 } }, "source": [ "#!git clone https://github.com/CoronaWhy/task-geo.git\n", "#!os.chdir('task-geo')\n", "import pandas as pd\n", "!wget -O coronavirus_timeseries.csv https://coronadatascraper.com/timeseries.csv\n", "!pip install wandb\n", "!wandb login\n", "import wandb\n", "from tensorflow import keras\n", "from wandb.keras import WandbCallback " ], "execution_count": 1, "outputs": [ { "output_type": "stream", "text": [ "--2020-05-04 01:42:51-- https://coronadatascraper.com/timeseries.csv\n", "Resolving coronadatascraper.com (coronadatascraper.com)... 185.199.110.153, 185.199.108.153, 185.199.111.153\n", "Connecting to coronadatascraper.com (coronadatascraper.com)|185.199.110.153|:443... connected.\n", "HTTP request sent, awaiting response... 200 OK\n", "Length: 41874411 (40M) [text/csv]\n", "Saving to: ‘coronavirus_timeseries.csv’\n", "\n", "coronavirus_timeser 100%[===================>] 39.93M 73.4MB/s in 0.5s \n", "\n", "2020-05-04 01:42:52 (73.4 MB/s) - ‘coronavirus_timeseries.csv’ saved [41874411/41874411]\n", "\n", "Collecting wandb\n", "\u001b[?25l Downloading https://files.pythonhosted.org/packages/2d/c9/ebbcefa6ef2ba14a7c62a4ee4415a5fecef8fac5e4d1b4e22af26fd9fe22/wandb-0.8.35-py2.py3-none-any.whl (1.4MB)\n", "\u001b[K |████████████████████████████████| 1.4MB 4.9MB/s \n", "\u001b[?25hRequirement already satisfied: python-dateutil>=2.6.1 in /usr/local/lib/python3.6/dist-packages (from wandb) (2.8.1)\n", "Requirement already satisfied: requests>=2.0.0 in /usr/local/lib/python3.6/dist-packages (from wandb) (2.23.0)\n", "Collecting gql==0.2.0\n", " Downloading https://files.pythonhosted.org/packages/c4/6f/cf9a3056045518f06184e804bae89390eb706168349daa9dff8ac609962a/gql-0.2.0.tar.gz\n", "Collecting shortuuid>=0.5.0\n", " Downloading https://files.pythonhosted.org/packages/25/a6/2ecc1daa6a304e7f1b216f0896b26156b78e7c38e1211e9b798b4716c53d/shortuuid-1.0.1-py3-none-any.whl\n", "Collecting configparser>=3.8.1\n", " Downloading https://files.pythonhosted.org/packages/4b/6b/01baa293090240cf0562cc5eccb69c6f5006282127f2b846fad011305c79/configparser-5.0.0-py3-none-any.whl\n", "Collecting watchdog>=0.8.3\n", "\u001b[?25l Downloading https://files.pythonhosted.org/packages/73/c3/ed6d992006837e011baca89476a4bbffb0a91602432f73bd4473816c76e2/watchdog-0.10.2.tar.gz (95kB)\n", "\u001b[K |████████████████████████████████| 102kB 10.5MB/s \n", "\u001b[?25hCollecting docker-pycreds>=0.4.0\n", " Downloading https://files.pythonhosted.org/packages/f5/e8/f6bd1eee09314e7e6dee49cbe2c5e22314ccdb38db16c9fc72d2fa80d054/docker_pycreds-0.4.0-py2.py3-none-any.whl\n", "Collecting GitPython>=1.0.0\n", "\u001b[?25l Downloading https://files.pythonhosted.org/packages/19/1a/0df85d2bddbca33665d2148173d3281b290ac054b5f50163ea735740ac7b/GitPython-3.1.1-py3-none-any.whl (450kB)\n", "\u001b[K |████████████████████████████████| 460kB 27.6MB/s \n", "\u001b[?25hRequirement already satisfied: Click>=7.0 in /usr/local/lib/python3.6/dist-packages (from wandb) (7.1.2)\n", "Requirement already satisfied: nvidia-ml-py3>=7.352.0 in /usr/local/lib/python3.6/dist-packages (from wandb) (7.352.0)\n", "Requirement already satisfied: PyYAML>=3.10 in /usr/local/lib/python3.6/dist-packages (from wandb) (3.13)\n", "Requirement already satisfied: psutil>=5.0.0 in /usr/local/lib/python3.6/dist-packages (from wandb) (5.4.8)\n", "Collecting sentry-sdk>=0.4.0\n", "\u001b[?25l Downloading https://files.pythonhosted.org/packages/20/7e/19545324e83db4522b885808cd913c3b93ecc0c88b03e037b78c6a417fa8/sentry_sdk-0.14.3-py2.py3-none-any.whl (103kB)\n", "\u001b[K |████████████████████████████████| 112kB 40.3MB/s \n", "\u001b[?25hCollecting subprocess32>=3.5.3\n", "\u001b[?25l Downloading https://files.pythonhosted.org/packages/32/c8/564be4d12629b912ea431f1a50eb8b3b9d00f1a0b1ceff17f266be190007/subprocess32-3.5.4.tar.gz (97kB)\n", "\u001b[K |████████████████████████████████| 102kB 12.1MB/s \n", "\u001b[?25hRequirement already satisfied: six>=1.10.0 in /usr/local/lib/python3.6/dist-packages (from wandb) (1.12.0)\n", "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.6/dist-packages (from requests>=2.0.0->wandb) (2.9)\n", "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.6/dist-packages (from requests>=2.0.0->wandb) (3.0.4)\n", "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.6/dist-packages (from requests>=2.0.0->wandb) (1.24.3)\n", "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.6/dist-packages (from requests>=2.0.0->wandb) (2020.4.5.1)\n", "Collecting graphql-core<2,>=0.5.0\n", "\u001b[?25l Downloading https://files.pythonhosted.org/packages/b0/89/00ad5e07524d8c523b14d70c685e0299a8b0de6d0727e368c41b89b7ed0b/graphql-core-1.1.tar.gz (70kB)\n", "\u001b[K |████████████████████████████████| 71kB 8.9MB/s \n", "\u001b[?25hRequirement already satisfied: promise<3,>=2.0 in /usr/local/lib/python3.6/dist-packages (from gql==0.2.0->wandb) (2.3)\n", "Collecting pathtools>=0.1.1\n", " Downloading https://files.pythonhosted.org/packages/e7/7f/470d6fcdf23f9f3518f6b0b76be9df16dcc8630ad409947f8be2eb0ed13a/pathtools-0.1.2.tar.gz\n", "Collecting gitdb<5,>=4.0.1\n", "\u001b[?25l Downloading https://files.pythonhosted.org/packages/74/52/ca35448b56c53a079d3ffe18b1978c6e424f6d4df02404877094c89f5bfb/gitdb-4.0.4-py3-none-any.whl (63kB)\n", "\u001b[K |████████████████████████████████| 71kB 9.1MB/s \n", "\u001b[?25hCollecting smmap<4,>=3.0.1\n", " Downloading https://files.pythonhosted.org/packages/27/b1/e379cfb7c07bbf8faee29c4a1a2469dbea525f047c2b454c4afdefa20a30/smmap-3.0.2-py2.py3-none-any.whl\n", "Building wheels for collected packages: gql, watchdog, subprocess32, graphql-core, pathtools\n", " Building wheel for gql (setup.py) ... \u001b[?25l\u001b[?25hdone\n", " Created wheel for gql: filename=gql-0.2.0-cp36-none-any.whl size=7630 sha256=78b8c25cb64e51b2f7716c489dd89b343318e43cb94e34c7ca3d9e430286901c\n", " Stored in directory: /root/.cache/pip/wheels/ce/0e/7b/58a8a5268655b3ad74feef5aa97946f0addafb3cbb6bd2da23\n", " Building wheel for watchdog (setup.py) ... \u001b[?25l\u001b[?25hdone\n", " Created wheel for watchdog: filename=watchdog-0.10.2-cp36-none-any.whl size=73605 sha256=ba4bb5dacf91b7b48c111a26d4c42ac96e7fbb31a5c0ab5d6f05d1d1491e16b8\n", " Stored in directory: /root/.cache/pip/wheels/bc/ed/6c/028dea90d31b359cd2a7c8b0da4db80e41d24a59614154072e\n", " Building wheel for subprocess32 (setup.py) ... \u001b[?25l\u001b[?25hdone\n", " Created wheel for subprocess32: filename=subprocess32-3.5.4-cp36-none-any.whl size=6489 sha256=ac15431ebcba218c446fb317b8090e545e424d836ff7d1c3451dc2128759a9c7\n", " Stored in directory: /root/.cache/pip/wheels/68/39/1a/5e402bdfdf004af1786c8b853fd92f8c4a04f22aad179654d1\n", " Building wheel for graphql-core (setup.py) ... \u001b[?25l\u001b[?25hdone\n", " Created wheel for graphql-core: filename=graphql_core-1.1-cp36-none-any.whl size=104650 sha256=1e43d09eb938e0a725303f391b1e7d282d76c67fc2871935e447146a5d40b717\n", " Stored in directory: /root/.cache/pip/wheels/45/99/d7/c424029bb0fe910c63b68dbf2aa20d3283d023042521bcd7d5\n", " Building wheel for pathtools (setup.py) ... \u001b[?25l\u001b[?25hdone\n", " Created wheel for pathtools: filename=pathtools-0.1.2-cp36-none-any.whl size=8784 sha256=da849bba746bfd1680d0712bc005e3b05941ea2f02bf243560dbceafb7f3d4c3\n", " Stored in directory: /root/.cache/pip/wheels/0b/04/79/c3b0c3a0266a3cb4376da31e5bfe8bba0c489246968a68e843\n", "Successfully built gql watchdog subprocess32 graphql-core pathtools\n", "Installing collected packages: graphql-core, gql, shortuuid, configparser, pathtools, watchdog, docker-pycreds, smmap, gitdb, GitPython, sentry-sdk, subprocess32, wandb\n", "Successfully installed GitPython-3.1.1 configparser-5.0.0 docker-pycreds-0.4.0 gitdb-4.0.4 gql-0.2.0 graphql-core-1.1 pathtools-0.1.2 sentry-sdk-0.14.3 shortuuid-1.0.1 smmap-3.0.2 subprocess32-3.5.4 wandb-0.8.35 watchdog-0.10.2\n", "\u001b[34m\u001b[1mwandb\u001b[0m: You can find your API key in your browser here: https://app.wandb.ai/authorize\n", "\u001b[34m\u001b[1mwandb\u001b[0m: Paste an API key from your profile and hit enter: 936f243deff8f026e476a495792f87a7942c65bf\n", "\u001b[34m\u001b[1mwandb\u001b[0m: Appending key for api.wandb.ai to your netrc file: /root/.netrc\n", "\u001b[32mSuccessfully logged in to Weights & Biases!\u001b[0m\n" ], "name": "stdout" } ] }, { "cell_type": "code", "metadata": { "id": "-YTGbDgAxUFD", "colab_type": "code", "colab": {} }, "source": [ "from google.colab import auth\n", "from datetime import datetime\n", "auth.authenticate_user()" ], "execution_count": 0, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "WmOWKLuxHT7j", "colab_type": "code", "outputId": "a23cc2ac-be5a-4654-fe05-be09873832a0", "colab": { "base_uri": "https://localhost:8080/", "height": 120 } }, "source": [ "df = pd.read_csv(\"coronavirus_timeseries.csv\")\n", "!gsutil cp coronavirus_timeseries.csv gs://coronaviruspublicdata/coronavirus_timeseries.csv \n", "df['month'] = pd.to_datetime(df['date']).map(lambda x: x.month)\n", "df['weekday'] = pd.to_datetime(df['date']).map(lambda x: x.weekday())" ], "execution_count": 3, "outputs": [ { "output_type": "stream", "text": [ "/usr/local/lib/python3.6/dist-packages/IPython/core/interactiveshell.py:2718: DtypeWarning: Columns (2) have mixed types.Specify dtype option on import or set low_memory=False.\n", " interactivity=interactivity, compiler=compiler, result=result)\n" ], "name": "stderr" }, { "output_type": "stream", "text": [ "Copying file://coronavirus_timeseries.csv [Content-Type=text/csv]...\n", "-\n", "Operation completed over 1 objects/39.9 MiB. \n" ], "name": "stdout" } ] }, { "cell_type": "code", "metadata": { "id": "asrssixL6XZo", "colab_type": "code", "outputId": "3bc9d7c2-6a5d-43b4-bf94-d28ee354751f", "colab": { "base_uri": "https://localhost:8080/", "height": 54 } }, "source": [ "unqiue_counties = df['county'].unique()\n", "print(len(unqiue_counties))" ], "execution_count": 4, "outputs": [ { "output_type": "stream", "text": [ "2035\n" ], "name": "stdout" } ] }, { "cell_type": "markdown", "metadata": { "id": "QL0c52gZYRKs", "colab_type": "text" }, "source": [ "We will now construct a list of suitable data at the county level." ] }, { "cell_type": "code", "metadata": { "id": "PfOvVyOCl9JL", "colab_type": "code", "outputId": "eb65dd3b-6b88-4631-c10f-694995906181", "colab": { "base_uri": "https://localhost:8080/", "height": 54 } }, "source": [ "def loop_through_geo_codes(df, column='full_county'):\n", " df_county_list = []\n", " df['full_county'] = df['state'] + \"_\" + df['county'] \n", " for code in df['full_county'].unique():\n", " mask = df['full_county'] == code\n", " df_code = df[mask]\n", " ts_count = len(df_code)\n", " if ts_count > 60:\n", " df_county_list.append(df_code)\n", " return df_county_list \n", "county_info = loop_through_geo_codes(df)\n", "print(len(county_info))" ], "execution_count": 5, "outputs": [ { "output_type": "stream", "text": [ "56\n" ], "name": "stdout" } ] }, { "cell_type": "code", "metadata": { "id": "NDj4y3mKXBrA", "colab_type": "code", "outputId": "f5974c0e-aac6-4bc9-996f-ccf9eb4eea7e", "colab": { "base_uri": "https://localhost:8080/", "height": 763 } }, "source": [ "county_info[0]" ], "execution_count": 0, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
| \n", " | name | \n", "level | \n", "city | \n", "county | \n", "state | \n", "country | \n", "population | \n", "lat | \n", "long | \n", "url | \n", "aggregate | \n", "tz | \n", "cases | \n", "deaths | \n", "recovered | \n", "active | \n", "tested | \n", "hospitalized | \n", "discharged | \n", "growthFactor | \n", "date | \n", "month | \n", "weekday | \n", "full_county | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "4.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2020-01-22 | \n", "1 | \n", "2 | \n", "Flanders_Antwerp | \n", "
| 1 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "4.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2020-01-23 | \n", "1 | \n", "3 | \n", "Flanders_Antwerp | \n", "
| 2 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "4.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2020-01-24 | \n", "1 | \n", "4 | \n", "Flanders_Antwerp | \n", "
| 3 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "4.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2020-01-25 | \n", "1 | \n", "5 | \n", "Flanders_Antwerp | \n", "
| 4 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "4.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2020-01-26 | \n", "1 | \n", "6 | \n", "Flanders_Antwerp | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 95 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "5815.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2181.0 | \n", "1869.0 | \n", "NaN | \n", "2020-04-26 | \n", "4 | \n", "6 | \n", "Flanders_Antwerp | \n", "
| 96 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "5960.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2202.0 | \n", "1884.0 | \n", "NaN | \n", "2020-04-27 | \n", "4 | \n", "0 | \n", "Flanders_Antwerp | \n", "
| 97 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "6001.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2238.0 | \n", "1938.0 | \n", "NaN | \n", "2020-04-28 | \n", "4 | \n", "1 | \n", "Flanders_Antwerp | \n", "
| 98 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "6002.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2256.0 | \n", "1985.0 | \n", "NaN | \n", "2020-04-29 | \n", "4 | \n", "2 | \n", "Flanders_Antwerp | \n", "
| 99 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "NaN | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "NaN | \n", "Europe/Brussels | \n", "6002.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2256.0 | \n", "1985.0 | \n", "NaN | \n", "2020-04-30 | \n", "4 | \n", "3 | \n", "Flanders_Antwerp | \n", "
100 rows × 24 columns
\n", "| \n", " | Unnamed: 0 | \n", "name | \n", "level | \n", "city | \n", "county | \n", "state | \n", "country | \n", "population | \n", "lat | \n", "long | \n", "url | \n", "aggregate | \n", "tz | \n", "cases | \n", "deaths | \n", "recovered | \n", "active | \n", "tested | \n", "hospitalized | \n", "discharged | \n", "growthFactor | \n", "date | \n", "month | \n", "weekday | \n", "state_county | \n", "full_county | \n", "datetime | \n", "new_cases | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "4.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2020-01-22 | \n", "1 | \n", "2 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-01-22 | \n", "0.0 | \n", "
| 1 | \n", "1 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "4.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2020-01-23 | \n", "1 | \n", "3 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-01-23 | \n", "0.0 | \n", "
| 2 | \n", "2 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "4.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2020-01-24 | \n", "1 | \n", "4 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-01-24 | \n", "0.0 | \n", "
| 3 | \n", "3 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "4.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2020-01-25 | \n", "1 | \n", "5 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-01-25 | \n", "0.0 | \n", "
| 4 | \n", "4 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "4.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2020-01-26 | \n", "1 | \n", "6 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-01-26 | \n", "0.0 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 93 | \n", "93 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "5713.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2134.0 | \n", "1788.0 | \n", "0.0 | \n", "2020-04-24 | \n", "4 | \n", "4 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-04-24 | \n", "71.0 | \n", "
| 94 | \n", "94 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "5743.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2169.0 | \n", "1850.0 | \n", "0.0 | \n", "2020-04-25 | \n", "4 | \n", "5 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-04-25 | \n", "30.0 | \n", "
| 95 | \n", "95 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "5761.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2181.0 | \n", "1869.0 | \n", "0.0 | \n", "2020-04-26 | \n", "4 | \n", "6 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-04-26 | \n", "18.0 | \n", "
| 96 | \n", "96 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "5761.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2202.0 | \n", "1884.0 | \n", "0.0 | \n", "2020-04-27 | \n", "4 | \n", "0 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-04-27 | \n", "0.0 | \n", "
| 97 | \n", "97 | \n", "Antwerp, Flanders, Belgium | \n", "county | \n", "0 | \n", "Antwerp | \n", "Flanders | \n", "Belgium | \n", "1847486.0 | \n", "51.2485 | \n", "4.7175 | \n", "https://epistat.wiv-isp.be/ | \n", "0 | \n", "Europe/Brussels | \n", "5761.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "2202.0 | \n", "1884.0 | \n", "0.0 | \n", "2020-04-28 | \n", "4 | \n", "1 | \n", "Flanders_Antwerp | \n", "Flanders_Antwerp | \n", "2020-04-28 | \n", "0.0 | \n", "
98 rows × 28 columns
\n", "| \n", " | country | \n", "region | \n", "sub_region | \n", "city | \n", "lat | \n", "long | \n", "date | \n", "level | \n", "tz | \n", "cases | \n", "deaths | \n", "recovered | \n", "active | \n", "tested | \n", "hospitalized | \n", "discharged | \n", "country_retail_recreation | \n", "country_grocery_pharmacy | \n", "country_parks | \n", "country_transit_stations | \n", "country_workplaces | \n", "country_residential | \n", "region_retail_recreation | \n", "region_grocery_pharmacy | \n", "region_parks | \n", "region_transit_stations | \n", "region_workplaces | \n", "region_residential | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27492 | \n", "United States | \n", "Florida | \n", "Manatee County | \n", "NaN | \n", "27.4270 | \n", "-82.4000 | \n", "2020-03-01 | \n", "sub_region | \n", "America/New_York | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "13.0 | \n", "9.0 | \n", "18.0 | \n", "7.0 | \n", "3.0 | \n", "-1.0 | \n", "8.0 | \n", "7.0 | \n", "10.0 | \n", "7.0 | \n", "1.0 | \n", "-1.0 | \n", "
| 27493 | \n", "United States | \n", "Florida | \n", "Manatee County | \n", "NaN | \n", "27.4270 | \n", "-82.4000 | \n", "2020-03-01 | \n", "sub_region | \n", "America/New_York | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "13.0 | \n", "9.0 | \n", "18.0 | \n", "7.0 | \n", "3.0 | \n", "-1.0 | \n", "3.0 | \n", "5.0 | \n", "16.0 | \n", "-4.0 | \n", "-3.0 | \n", "-1.0 | \n", "
| 27494 | \n", "United States | \n", "Florida | \n", "Manatee County | \n", "NaN | \n", "27.4270 | \n", "-82.4000 | \n", "2020-03-01 | \n", "sub_region | \n", "America/New_York | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "13.0 | \n", "9.0 | \n", "18.0 | \n", "7.0 | \n", "3.0 | \n", "-1.0 | \n", "19.0 | \n", "19.0 | \n", "NaN | \n", "NaN | \n", "0.0 | \n", "NaN | \n", "
| 27495 | \n", "United States | \n", "Florida | \n", "Manatee County | \n", "NaN | \n", "27.4270 | \n", "-82.4000 | \n", "2020-03-01 | \n", "sub_region | \n", "America/New_York | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "13.0 | \n", "9.0 | \n", "18.0 | \n", "7.0 | \n", "3.0 | \n", "-1.0 | \n", "19.0 | \n", "11.0 | \n", "33.0 | \n", "24.0 | \n", "11.0 | \n", "-3.0 | \n", "
| 27496 | \n", "United States | \n", "Florida | \n", "Manatee County | \n", "NaN | \n", "27.4270 | \n", "-82.4000 | \n", "2020-03-01 | \n", "sub_region | \n", "America/New_York | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "13.0 | \n", "9.0 | \n", "18.0 | \n", "7.0 | \n", "3.0 | \n", "-1.0 | \n", "19.0 | \n", "12.0 | \n", "NaN | \n", "NaN | \n", "0.0 | \n", "NaN | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 7679488 | \n", "United States | \n", "Florida | \n", "Calhoun County | \n", "NaN | \n", "30.4040 | \n", "-85.1615 | \n", "2020-05-02 | \n", "sub_region | \n", "America/Chicago | \n", "14 | \n", "0 | \n", "0 | \n", "0 | \n", "141 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 7679495 | \n", "United States | \n", "Florida | \n", "Citrus County | \n", "NaN | \n", "28.8570 | \n", "-82.4640 | \n", "2020-05-02 | \n", "sub_region | \n", "America/New_York | \n", "99 | \n", "11 | \n", "0 | \n", "0 | \n", "1704 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 7679499 | \n", "United States | \n", "Florida | \n", "Collier County | \n", "NaN | \n", "26.1600 | \n", "-81.3595 | \n", "2020-05-02 | \n", "sub_region | \n", "America/New_York | \n", "628 | \n", "21 | \n", "0 | \n", "0 | \n", "5867 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 7679508 | \n", "United States | \n", "Florida | \n", "Clay County | \n", "NaN | \n", "29.9560 | \n", "-81.8150 | \n", "2020-05-02 | \n", "sub_region | \n", "America/New_York | \n", "278 | \n", "18 | \n", "0 | \n", "0 | \n", "4060 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 7679765 | \n", "United States | \n", "Florida | \n", "NaN | \n", "NaN | \n", "27.8185 | \n", "-83.8385 | \n", "2020-05-02 | \n", "region | \n", "America/New_York | \n", "35463 | \n", "1364 | \n", "0 | \n", "0 | \n", "417762 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
192901 rows × 28 columns
\n", "