{ "cells": [ { "cell_type": "code", "execution_count": 11, "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "import itertools\n", "import collections\n", "import json\n", "import pandas as pd\n", "import numpy as np\n", "from scipy.stats import gmean\n", "import datetime\n", "\n", "import matplotlib as mpl\n", "import matplotlib.pyplot as plt\n", "%matplotlib inline\n", "%load_ext sql" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "connection_string = 'postgresql://covid:3NbjJTkT63@localhost/covid'" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "text/plain": [ "'Connected: covid@covid'" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%sql $connection_string" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "Collapsed": "false" }, "outputs": [], "source": [ "normalisation_date = '2020-08-01' # '2020-05-15'\n", "\n", "hospital_normalisation_date = {\n", " 'hospital_normalisation_date': normalisation_date\n", "}\n", "\n", "with open('hospital_normalisation_date.json', 'w') as f:\n", " json.dump(hospital_normalisation_date, f)\n", " \n", "hnd = pd.to_datetime(normalisation_date).strftime(\"%d %B %Y\")\n", "with open('hospital_normalisation_date.js', 'w') as f:\n", " f.write(f\"document.write('{hnd}');\")" ] }, { "cell_type": "code", "execution_count": 19, "metadata": { "Collapsed": "false" }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " * postgresql://covid:***@localhost/covid\n", "377 rows affected.\n", "Returning data to local variable res\n" ] } ], "source": [ "%%sql res << select uk_data.date, uk_data.new_admissions, uk_data_7.new_admissions as admissions7\n", " from uk_data join uk_data_7 using (date)\n", " order by uk_data.date" ] }, { "cell_type": "code", "execution_count": 20, "metadata": { "Collapsed": "false" }, "outputs": [ { "data": { "text/html": [ "
\n", " | date | \n", "new_admissions | \n", "admissions7 | \n", "
---|---|---|---|
0 | \n", "2020-01-03 | \n", "NaN | \n", "NaN | \n", "
1 | \n", "2020-01-04 | \n", "NaN | \n", "NaN | \n", "
2 | \n", "2020-01-05 | \n", "NaN | \n", "NaN | \n", "
3 | \n", "2020-01-06 | \n", "NaN | \n", "NaN | \n", "
4 | \n", "2020-01-07 | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
372 | \n", "2021-01-09 | \n", "NaN | \n", "4042.8 | \n", "
373 | \n", "2021-01-10 | \n", "NaN | \n", "4148.0 | \n", "
374 | \n", "2021-01-11 | \n", "NaN | \n", "4231.0 | \n", "
375 | \n", "2021-01-12 | \n", "NaN | \n", "4310.0 | \n", "
376 | \n", "2021-01-13 | \n", "NaN | \n", "4253.0 | \n", "
377 rows × 3 columns
\n", "\n", " | areaName | \n", "areaType | \n", "newAdmissions | \n", "cumAdmissions | \n", "
---|---|---|---|---|
date | \n", "\n", " | \n", " | \n", " | \n", " |
2020-03-23 | \n", "United Kingdom | \n", "overview | \n", "1271 | \n", "4860 | \n", "
2020-03-24 | \n", "United Kingdom | \n", "overview | \n", "1719 | \n", "6579 | \n", "
2020-03-25 | \n", "United Kingdom | \n", "overview | \n", "2084 | \n", "8663 | \n", "
2020-03-26 | \n", "United Kingdom | \n", "overview | \n", "1929 | \n", "10592 | \n", "
2020-03-27 | \n", "United Kingdom | \n", "overview | \n", "2224 | \n", "12816 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2020-12-07 | \n", "United Kingdom | \n", "overview | \n", "1626 | \n", "233132 | \n", "
2020-12-08 | \n", "United Kingdom | \n", "overview | \n", "1729 | \n", "234861 | \n", "
2020-12-09 | \n", "United Kingdom | \n", "overview | \n", "1705 | \n", "236566 | \n", "
2020-12-10 | \n", "United Kingdom | \n", "overview | \n", "1707 | \n", "238273 | \n", "
2020-12-11 | \n", "United Kingdom | \n", "overview | \n", "1637 | \n", "239910 | \n", "
264 rows × 4 columns
\n", "\n", " | cases | \n", "deaths | \n", "cases_culm | \n", "deaths_culm | \n", "cases_diff | \n", "deaths_diff | \n", "cases_m7 | \n", "deaths_m7 | \n", "deaths_g4 | \n", "deaths_g7 | \n", "doubling_time | \n", "doubling_time_7 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
dateRep | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2019-12-31 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-01 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-02 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-03 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-04 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2020-12-10 | \n", "16578 | \n", "533 | \n", "1766819 | \n", "62566 | \n", "4297.0 | \n", "-66.0 | \n", "15366.142857 | \n", "409.571429 | \n", "343.603005 | \n", "380.495816 | \n", "126.560073 | \n", "114.322369 | \n", "
2020-12-11 | \n", "20964 | \n", "516 | \n", "1787783 | \n", "63082 | \n", "4386.0 | \n", "-17.0 | \n", "16235.571429 | \n", "424.142857 | \n", "420.064891 | \n", "392.657665 | \n", "104.437514 | \n", "111.703039 | \n", "
2020-12-12 | \n", "21672 | \n", "424 | \n", "1809455 | \n", "63506 | \n", "708.0 | \n", "-92.0 | \n", "17003.285714 | \n", "412.714286 | \n", "514.093837 | \n", "383.080949 | \n", "85.970563 | \n", "115.254067 | \n", "
2020-12-13 | \n", "21501 | \n", "520 | \n", "1830956 | \n", "64026 | \n", "-171.0 | \n", "96.0 | \n", "17855.000000 | \n", "430.285714 | \n", "496.234012 | \n", "398.139480 | \n", "89.778614 | \n", "111.813286 | \n", "
2020-12-14 | \n", "18447 | \n", "144 | \n", "1849403 | \n", "64170 | \n", "-3054.0 | \n", "-376.0 | \n", "18023.000000 | \n", "417.857143 | \n", "357.762938 | \n", "372.146458 | \n", "124.672307 | \n", "119.867072 | \n", "
350 rows × 12 columns
\n", "\n", " | cases | \n", "deaths | \n", "cases_culm | \n", "deaths_culm | \n", "cases_diff | \n", "deaths_diff | \n", "cases_m7 | \n", "deaths_m7 | \n", "deaths_g4 | \n", "deaths_g7 | \n", "doubling_time | \n", "doubling_time_7 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
dateRep | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2019-12-31 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-01 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-02 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-03 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
2020-01-04 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2020-12-10 | \n", "16578 | \n", "533 | \n", "1766819 | \n", "62566 | \n", "4297.0 | \n", "-66.0 | \n", "15366.142857 | \n", "409.571429 | \n", "343.603005 | \n", "380.495816 | \n", "126.560073 | \n", "114.322369 | \n", "
2020-12-11 | \n", "20964 | \n", "516 | \n", "1787783 | \n", "63082 | \n", "4386.0 | \n", "-17.0 | \n", "16235.571429 | \n", "424.142857 | \n", "420.064891 | \n", "392.657665 | \n", "104.437514 | \n", "111.703039 | \n", "
2020-12-12 | \n", "21672 | \n", "424 | \n", "1809455 | \n", "63506 | \n", "708.0 | \n", "-92.0 | \n", "17003.285714 | \n", "412.714286 | \n", "514.093837 | \n", "383.080949 | \n", "85.970563 | \n", "115.254067 | \n", "
2020-12-13 | \n", "21501 | \n", "520 | \n", "1830956 | \n", "64026 | \n", "-171.0 | \n", "96.0 | \n", "17855.000000 | \n", "430.285714 | \n", "496.234012 | \n", "398.139480 | \n", "89.778614 | \n", "111.813286 | \n", "
2020-12-14 | \n", "18447 | \n", "144 | \n", "1849403 | \n", "64170 | \n", "-3054.0 | \n", "-376.0 | \n", "18023.000000 | \n", "417.857143 | \n", "357.762938 | \n", "372.146458 | \n", "124.672307 | \n", "119.867072 | \n", "
350 rows × 12 columns
\n", "\n", " | cases | \n", "deaths | \n", "cases_culm | \n", "deaths_culm | \n", "cases_diff | \n", "deaths_diff | \n", "cases_m7 | \n", "deaths_m7 | \n", "deaths_g4 | \n", "deaths_g7 | \n", "doubling_time | \n", "doubling_time_7 | \n", "newAdmissions | \n", "cumAdmissions | \n", "admissions_m7 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019-12-31 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-01 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-02 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-03 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-04 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2020-12-10 | \n", "16578 | \n", "533 | \n", "1766819 | \n", "62566 | \n", "4297.0 | \n", "-66.0 | \n", "15366.142857 | \n", "409.571429 | \n", "343.603005 | \n", "380.495816 | \n", "126.560073 | \n", "114.322369 | \n", "1707.0 | \n", "238273.0 | \n", "1568.428571 | \n", "
2020-12-11 | \n", "20964 | \n", "516 | \n", "1787783 | \n", "63082 | \n", "4386.0 | \n", "-17.0 | \n", "16235.571429 | \n", "424.142857 | \n", "420.064891 | \n", "392.657665 | \n", "104.437514 | \n", "111.703039 | \n", "1637.0 | \n", "239910.0 | \n", "1601.714286 | \n", "
2020-12-12 | \n", "21672 | \n", "424 | \n", "1809455 | \n", "63506 | \n", "708.0 | \n", "-92.0 | \n", "17003.285714 | \n", "412.714286 | \n", "514.093837 | \n", "383.080949 | \n", "85.970563 | \n", "115.254067 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-12-13 | \n", "21501 | \n", "520 | \n", "1830956 | \n", "64026 | \n", "-171.0 | \n", "96.0 | \n", "17855.000000 | \n", "430.285714 | \n", "496.234012 | \n", "398.139480 | \n", "89.778614 | \n", "111.813286 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-12-14 | \n", "18447 | \n", "144 | \n", "1849403 | \n", "64170 | \n", "-3054.0 | \n", "-376.0 | \n", "18023.000000 | \n", "417.857143 | \n", "357.762938 | \n", "372.146458 | \n", "124.672307 | \n", "119.867072 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
350 rows × 15 columns
\n", "\n", " | cases | \n", "deaths | \n", "cases_culm | \n", "deaths_culm | \n", "cases_diff | \n", "deaths_diff | \n", "cases_m7 | \n", "deaths_m7 | \n", "deaths_g4 | \n", "deaths_g7 | \n", "... | \n", "admissions_m7 | \n", "cases_m7n | \n", "deaths_m7n | \n", "admissions_m7n | \n", "cases_m7nd | \n", "deaths_m7nd | \n", "admissions_m7nd | \n", "cases_nd | \n", "deaths_nd | \n", "admissions_nd | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019-12-31 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-01 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-02 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-03 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-04 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \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", "
2020-12-10 | \n", "16578 | \n", "533 | \n", "1766819 | \n", "62566 | \n", "4297.0 | \n", "-66.0 | \n", "15366.142857 | \n", "409.571429 | \n", "343.603005 | \n", "380.495816 | \n", "... | \n", "1568.428571 | \n", "0.606611 | \n", "0.434591 | \n", "0.503370 | \n", "26.770284 | \n", "28.386139 | \n", "12.796037 | \n", "28.881533 | \n", "36.940594 | \n", "13.926573 | \n", "
2020-12-11 | \n", "20964 | \n", "516 | \n", "1787783 | \n", "63082 | \n", "4386.0 | \n", "-17.0 | \n", "16235.571429 | \n", "424.142857 | \n", "420.064891 | \n", "392.657665 | \n", "... | \n", "1601.714286 | \n", "0.640933 | \n", "0.450053 | \n", "0.514053 | \n", "28.284968 | \n", "29.396040 | \n", "13.067599 | \n", "36.522648 | \n", "35.762376 | \n", "13.355478 | \n", "
2020-12-12 | \n", "21672 | \n", "424 | \n", "1809455 | \n", "63506 | \n", "708.0 | \n", "-92.0 | \n", "17003.285714 | \n", "412.714286 | \n", "514.093837 | \n", "383.080949 | \n", "... | \n", "NaN | \n", "0.671240 | \n", "0.437926 | \n", "NaN | \n", "29.622449 | \n", "28.603960 | \n", "NaN | \n", "37.756098 | \n", "29.386139 | \n", "NaN | \n", "
2020-12-13 | \n", "21501 | \n", "520 | \n", "1830956 | \n", "64026 | \n", "-171.0 | \n", "96.0 | \n", "17855.000000 | \n", "430.285714 | \n", "496.234012 | \n", "398.139480 | \n", "... | \n", "NaN | \n", "0.704864 | \n", "0.456571 | \n", "NaN | \n", "31.106272 | \n", "29.821782 | \n", "NaN | \n", "37.458188 | \n", "36.039604 | \n", "NaN | \n", "
2020-12-14 | \n", "18447 | \n", "144 | \n", "1849403 | \n", "64170 | \n", "-3054.0 | \n", "-376.0 | \n", "18023.000000 | \n", "417.857143 | \n", "357.762938 | \n", "372.146458 | \n", "... | \n", "NaN | \n", "0.711496 | \n", "0.443383 | \n", "NaN | \n", "31.398955 | \n", "28.960396 | \n", "NaN | \n", "32.137631 | \n", "9.980198 | \n", "NaN | \n", "
350 rows × 24 columns
\n", "\n", " | cases | \n", "deaths | \n", "cases_culm | \n", "deaths_culm | \n", "cases_diff | \n", "deaths_diff | \n", "cases_m7 | \n", "deaths_m7 | \n", "deaths_g4 | \n", "deaths_g7 | \n", "... | \n", "admissions_m7 | \n", "cases_m7n | \n", "deaths_m7n | \n", "admissions_m7n | \n", "cases_m7nd | \n", "deaths_m7nd | \n", "admissions_m7nd | \n", "cases_nd | \n", "deaths_nd | \n", "admissions_nd | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019-12-31 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-01 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-02 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-03 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-04 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \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", "
2020-12-10 | \n", "16578 | \n", "533 | \n", "1766819 | \n", "62566 | \n", "4297.0 | \n", "-66.0 | \n", "15366.142857 | \n", "409.571429 | \n", "343.603005 | \n", "380.495816 | \n", "... | \n", "1568.428571 | \n", "0.606611 | \n", "0.434591 | \n", "0.503370 | \n", "26.770284 | \n", "28.386139 | \n", "12.796037 | \n", "28.881533 | \n", "36.940594 | \n", "13.926573 | \n", "
2020-12-11 | \n", "20964 | \n", "516 | \n", "1787783 | \n", "63082 | \n", "4386.0 | \n", "-17.0 | \n", "16235.571429 | \n", "424.142857 | \n", "420.064891 | \n", "392.657665 | \n", "... | \n", "1601.714286 | \n", "0.640933 | \n", "0.450053 | \n", "0.514053 | \n", "28.284968 | \n", "29.396040 | \n", "13.067599 | \n", "36.522648 | \n", "35.762376 | \n", "13.355478 | \n", "
2020-12-12 | \n", "21672 | \n", "424 | \n", "1809455 | \n", "63506 | \n", "708.0 | \n", "-92.0 | \n", "17003.285714 | \n", "412.714286 | \n", "514.093837 | \n", "383.080949 | \n", "... | \n", "NaN | \n", "0.671240 | \n", "0.437926 | \n", "NaN | \n", "29.622449 | \n", "28.603960 | \n", "NaN | \n", "37.756098 | \n", "29.386139 | \n", "NaN | \n", "
2020-12-13 | \n", "21501 | \n", "520 | \n", "1830956 | \n", "64026 | \n", "-171.0 | \n", "96.0 | \n", "17855.000000 | \n", "430.285714 | \n", "496.234012 | \n", "398.139480 | \n", "... | \n", "NaN | \n", "0.704864 | \n", "0.456571 | \n", "NaN | \n", "31.106272 | \n", "29.821782 | \n", "NaN | \n", "37.458188 | \n", "36.039604 | \n", "NaN | \n", "
2020-12-14 | \n", "18447 | \n", "144 | \n", "1849403 | \n", "64170 | \n", "-3054.0 | \n", "-376.0 | \n", "18023.000000 | \n", "417.857143 | \n", "357.762938 | \n", "372.146458 | \n", "... | \n", "NaN | \n", "0.711496 | \n", "0.443383 | \n", "NaN | \n", "31.398955 | \n", "28.960396 | \n", "NaN | \n", "32.137631 | \n", "9.980198 | \n", "NaN | \n", "
350 rows × 24 columns
\n", "\n", " | cases | \n", "cases_culm | \n", "deaths | \n", "deaths_culm | \n", "newAdmissions | \n", "cumAdmissions | \n", "deaths_m7 | \n", "cases_m7 | \n", "admissions_m7 | \n", "cases_m7n | \n", "deaths_m7n | \n", "admissions_m7n | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
2019-12-31 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-01 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-02 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-03 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2020-01-04 | \n", "0.0 | \n", "0.0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2020-12-10 | \n", "NaN | \n", "NaN | \n", "533 | \n", "62566 | \n", "NaN | \n", "NaN | \n", "409.571429 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "28.386139 | \n", "NaN | \n", "
2020-12-11 | \n", "NaN | \n", "NaN | \n", "516 | \n", "63082 | \n", "NaN | \n", "NaN | \n", "424.142857 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "29.396040 | \n", "NaN | \n", "
2020-12-12 | \n", "NaN | \n", "NaN | \n", "424 | \n", "63506 | \n", "NaN | \n", "NaN | \n", "412.714286 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "28.603960 | \n", "NaN | \n", "
2020-12-13 | \n", "NaN | \n", "NaN | \n", "520 | \n", "64026 | \n", "NaN | \n", "NaN | \n", "430.285714 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "29.821782 | \n", "NaN | \n", "
2020-12-14 | \n", "NaN | \n", "NaN | \n", "144 | \n", "64170 | \n", "NaN | \n", "NaN | \n", "417.857143 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "28.960396 | \n", "NaN | \n", "
350 rows × 12 columns
\n", "\n", " | cases | \n", "deaths | \n", "cases_culm | \n", "deaths_culm | \n", "cases_diff | \n", "deaths_diff | \n", "cases_m7 | \n", "deaths_m7 | \n", "deaths_g4 | \n", "deaths_g7 | \n", "... | \n", "admissions_m7 | \n", "cases_m7n | \n", "deaths_m7n | \n", "admissions_m7n | \n", "cases_m7nd | \n", "deaths_m7nd | \n", "admissions_m7nd | \n", "cases_nd | \n", "deaths_nd | \n", "admissions_nd | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019-12-31 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-01 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-02 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-03 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-04 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \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", "
2020-12-10 | \n", "16578 | \n", "533 | \n", "1766819 | \n", "62566 | \n", "4297.0 | \n", "-66.0 | \n", "15366.142857 | \n", "409.571429 | \n", "343.603005 | \n", "380.495816 | \n", "... | \n", "1568.428571 | \n", "0.606611 | \n", "0.434591 | \n", "0.503370 | \n", "26.770284 | \n", "28.386139 | \n", "12.796037 | \n", "28.881533 | \n", "36.940594 | \n", "13.926573 | \n", "
2020-12-11 | \n", "20964 | \n", "516 | \n", "1787783 | \n", "63082 | \n", "4386.0 | \n", "-17.0 | \n", "16235.571429 | \n", "424.142857 | \n", "420.064891 | \n", "392.657665 | \n", "... | \n", "1601.714286 | \n", "0.640933 | \n", "0.450053 | \n", "0.514053 | \n", "28.284968 | \n", "29.396040 | \n", "13.067599 | \n", "36.522648 | \n", "35.762376 | \n", "13.355478 | \n", "
2020-12-12 | \n", "21672 | \n", "424 | \n", "1809455 | \n", "63506 | \n", "708.0 | \n", "-92.0 | \n", "17003.285714 | \n", "412.714286 | \n", "514.093837 | \n", "383.080949 | \n", "... | \n", "NaN | \n", "0.671240 | \n", "0.437926 | \n", "NaN | \n", "29.622449 | \n", "28.603960 | \n", "NaN | \n", "37.756098 | \n", "29.386139 | \n", "NaN | \n", "
2020-12-13 | \n", "21501 | \n", "520 | \n", "1830956 | \n", "64026 | \n", "-171.0 | \n", "96.0 | \n", "17855.000000 | \n", "430.285714 | \n", "496.234012 | \n", "398.139480 | \n", "... | \n", "NaN | \n", "0.704864 | \n", "0.456571 | \n", "NaN | \n", "31.106272 | \n", "29.821782 | \n", "NaN | \n", "37.458188 | \n", "36.039604 | \n", "NaN | \n", "
2020-12-14 | \n", "18447 | \n", "144 | \n", "1849403 | \n", "64170 | \n", "-3054.0 | \n", "-376.0 | \n", "18023.000000 | \n", "417.857143 | \n", "357.762938 | \n", "372.146458 | \n", "... | \n", "NaN | \n", "0.711496 | \n", "0.443383 | \n", "NaN | \n", "31.398955 | \n", "28.960396 | \n", "NaN | \n", "32.137631 | \n", "9.980198 | \n", "NaN | \n", "
350 rows × 24 columns
\n", "\n", " | areaType | \n", "areaName | \n", "newCasesByPublishDate | \n", "cumCasesByPublishDate | \n", "
---|---|---|---|---|
date | \n", "\n", " | \n", " | \n", " | \n", " |
2020-03-10 | \n", "overview | \n", "United Kingdom | \n", "NaN | \n", "373 | \n", "
2020-03-11 | \n", "overview | \n", "United Kingdom | \n", "83.0 | \n", "456 | \n", "
2020-03-12 | \n", "overview | \n", "United Kingdom | \n", "134.0 | \n", "590 | \n", "
2020-03-13 | \n", "overview | \n", "United Kingdom | \n", "207.0 | \n", "797 | \n", "
2020-03-14 | \n", "overview | \n", "United Kingdom | \n", "264.0 | \n", "1061 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2020-06-29 | \n", "overview | \n", "United Kingdom | \n", "815.0 | \n", "311965 | \n", "
2020-06-30 | \n", "overview | \n", "United Kingdom | \n", "689.0 | \n", "312654 | \n", "
2020-07-01 | \n", "overview | \n", "United Kingdom | \n", "829.0 | \n", "313483 | \n", "
2020-07-02 | \n", "overview | \n", "United Kingdom | \n", "576.0 | \n", "283757 | \n", "
2020-07-03 | \n", "overview | \n", "United Kingdom | \n", "544.0 | \n", "284276 | \n", "
116 rows × 4 columns
\n", "\n", " | cases | \n", "deaths | \n", "cases_culm | \n", "deaths_culm | \n", "cases_diff | \n", "deaths_diff | \n", "cases_m7 | \n", "deaths_m7 | \n", "deaths_g4 | \n", "deaths_g7 | \n", "... | \n", "admissions_m7 | \n", "cases_m7n | \n", "deaths_m7n | \n", "admissions_m7n | \n", "cases_m7nd | \n", "deaths_m7nd | \n", "admissions_m7nd | \n", "cases_nd | \n", "deaths_nd | \n", "admissions_nd | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019-12-31 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-01 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-02 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-03 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2020-01-04 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0.0 | \n", "0.0 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \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", "
2020-12-10 | \n", "16578 | \n", "533 | \n", "1766819 | \n", "62566 | \n", "4297.0 | \n", "-66.0 | \n", "15366.142857 | \n", "409.571429 | \n", "343.603005 | \n", "380.495816 | \n", "... | \n", "1568.428571 | \n", "0.606611 | \n", "0.434591 | \n", "0.503370 | \n", "26.770284 | \n", "28.386139 | \n", "12.796037 | \n", "28.881533 | \n", "36.940594 | \n", "13.926573 | \n", "
2020-12-11 | \n", "20964 | \n", "516 | \n", "1787783 | \n", "63082 | \n", "4386.0 | \n", "-17.0 | \n", "16235.571429 | \n", "424.142857 | \n", "420.064891 | \n", "392.657665 | \n", "... | \n", "1601.714286 | \n", "0.640933 | \n", "0.450053 | \n", "0.514053 | \n", "28.284968 | \n", "29.396040 | \n", "13.067599 | \n", "36.522648 | \n", "35.762376 | \n", "13.355478 | \n", "
2020-12-12 | \n", "21672 | \n", "424 | \n", "1809455 | \n", "63506 | \n", "708.0 | \n", "-92.0 | \n", "17003.285714 | \n", "412.714286 | \n", "514.093837 | \n", "383.080949 | \n", "... | \n", "NaN | \n", "0.671240 | \n", "0.437926 | \n", "NaN | \n", "29.622449 | \n", "28.603960 | \n", "NaN | \n", "37.756098 | \n", "29.386139 | \n", "NaN | \n", "
2020-12-13 | \n", "21501 | \n", "520 | \n", "1830956 | \n", "64026 | \n", "-171.0 | \n", "96.0 | \n", "17855.000000 | \n", "430.285714 | \n", "496.234012 | \n", "398.139480 | \n", "... | \n", "NaN | \n", "0.704864 | \n", "0.456571 | \n", "NaN | \n", "31.106272 | \n", "29.821782 | \n", "NaN | \n", "37.458188 | \n", "36.039604 | \n", "NaN | \n", "
2020-12-14 | \n", "18447 | \n", "144 | \n", "1849403 | \n", "64170 | \n", "-3054.0 | \n", "-376.0 | \n", "18023.000000 | \n", "417.857143 | \n", "357.762938 | \n", "372.146458 | \n", "... | \n", "NaN | \n", "0.711496 | \n", "0.443383 | \n", "NaN | \n", "31.398955 | \n", "28.960396 | \n", "NaN | \n", "32.137631 | \n", "9.980198 | \n", "NaN | \n", "
350 rows × 24 columns
\n", "