economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
40,255 rows sorted by days descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country >30
- United States 16,429
- Denmark 415
- Netherlands 415
- Austria 414
- Britain 414
- Ecuador 414
- New Zealand 414
- Norway 414
- Portugal 414
- South Africa 414
- Germany 413
- Latvia 413
- Poland 413
- Belgium 412
- Estonia 412
- Slovenia 412
- Switzerland 412
- Colombia 411
- France 411
- Hungary 411
- Israel 411
- Sweden 411
- Bulgaria 410
- Croatia 410
- Cyprus 410
- Finland 410
- Greece 410
- Iceland 410
- Lithuania 410
- Luxembourg 410
- …
Link | rowid | country | region | region_code | start_date | end_date | days ▲ | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1412 | 1412 | Kyrgyzstan | Kyrgyzstan | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 6630621 | 2882 | 0 | TBC | monthly | 5 | |
1414 | 1414 | Kyrgyzstan | Kyrgyzstan | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 6630621 | 2858 | 0 | TBC | monthly | 7 | |
1415 | 1415 | Kyrgyzstan | Kyrgyzstan | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 6630621 | 2573 | 0 | TBC | monthly | 8 | |
1417 | 1417 | Kyrgyzstan | Kyrgyzstan | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 6630621 | 2777 | 0 | TBC | monthly | 10 | |
1419 | 1419 | Kyrgyzstan | Kyrgyzstan | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 6630621 | 3045 | 0 | TBC | monthly | 12 | |
1420 | 1420 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-01-01 | 2018-01-31 | 31 | 2018 | 6630621 | 2781 | 0 | TBC | monthly | 1 | |
1422 | 1422 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-03-01 | 2018-03-31 | 31 | 2018 | 6630621 | 2887 | 0 | TBC | monthly | 3 | |
1424 | 1424 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-05-01 | 2018-05-31 | 31 | 2018 | 6630621 | 2775 | 0 | TBC | monthly | 5 | |
1426 | 1426 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-07-01 | 2018-07-31 | 31 | 2018 | 6630621 | 2912 | 0 | TBC | monthly | 7 | |
1427 | 1427 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-08-01 | 2018-08-31 | 31 | 2018 | 6630621 | 2646 | 0 | TBC | monthly | 8 | |
1429 | 1429 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 6630621 | 2803 | 0 | TBC | monthly | 10 | |
1431 | 1431 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-12-01 | 2018-12-31 | 31 | 2018 | 6630621 | 3041 | 0 | TBC | monthly | 12 | |
1432 | 1432 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 6630621 | 3085 | 0 | TBC | monthly | 1 | |
1434 | 1434 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 6630621 | 2606 | 0 | TBC | monthly | 3 | |
1436 | 1436 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 6630621 | 2802 | 0 | TBC | monthly | 5 | |
1438 | 1438 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 6630621 | 3059 | 0 | TBC | monthly | 7 | |
1439 | 1439 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 6630621 | 2663 | 0 | TBC | monthly | 8 | |
1441 | 1441 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 6630621 | 2809 | 0 | TBC | monthly | 10 | |
1443 | 1443 | Kyrgyzstan | Kyrgyzstan | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 6630621 | 3206 | 0 | TBC | monthly | 12 | |
1444 | 1444 | Kyrgyzstan | Kyrgyzstan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 6630621 | 3082 | 0 | TBC | monthly | 1 | |
1446 | 1446 | Kyrgyzstan | Kyrgyzstan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 6630621 | 2390 | 0 | TBC | monthly | 3 | |
1448 | 1448 | Kyrgyzstan | Kyrgyzstan | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 6630621 | 2919 | 8 | TBC | monthly | 5 | |
1450 | 1450 | Kyrgyzstan | Kyrgyzstan | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 6630621 | 4045 | 1317 | TBC | monthly | 7 | |
1451 | 1451 | Kyrgyzstan | Kyrgyzstan | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 6630621 | 4572 | 123 | TBC | monthly | 8 | |
1453 | 1453 | Kyrgyzstan | Kyrgyzstan | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 6630621 | 3423 | 80 | TBC | monthly | 10 | |
1455 | 1455 | Kyrgyzstan | Kyrgyzstan | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 6630621 | 4259 | 80 | TBC | monthly | 12 | |
1456 | 1456 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 6630621 | 2988 | 57 | TBC | monthly | 1 | |
1458 | 1458 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 6630621 | 3137 | 34 | TBC | monthly | 3 | |
1460 | 1460 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 6630621 | 2868 | 204 | TBC | monthly | 5 | |
1462 | 1462 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 6630621 | 3835 | 325 | TBC | monthly | 7 | |
1463 | 1463 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 6630621 | 3810 | 203 | TBC | monthly | 8 | |
1465 | 1465 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 6630621 | 3257 | 64 | TBC | monthly | 10 | |
1467 | 1467 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 6630621 | 3590 | 56 | TBC | monthly | 12 | |
1468 | 1468 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 6630621 | 2671 | 78 | TBC | monthly | 1 | |
1470 | 1470 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 6630621 | 2955 | 30 | TBC | monthly | 3 | |
1472 | 1472 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 6630621 | 1951 | 0 | TBC | monthly | 5 | |
1474 | 1474 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 6630621 | 2378 | 0 | TBC | monthly | 7 | |
1475 | 1475 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 6630621 | 4307 | 0 | TBC | monthly | 8 | |
1477 | 1477 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 6630621 | 1656 | 0 | TBC | monthly | 10 | |
1885 | 1885 | Brazil | Brazil | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 215313504 | 106695 | 0 | TBC | monthly | 1 | |
1887 | 1887 | Brazil | Brazil | 0 | 2015-03-01 | 2015-03-31 | 31 | 2015 | 215313504 | 102473 | 0 | TBC | monthly | 3 | |
1889 | 1889 | Brazil | Brazil | 0 | 2015-05-01 | 2015-05-31 | 31 | 2015 | 215313504 | 114042 | 0 | TBC | monthly | 5 | |
1891 | 1891 | Brazil | Brazil | 0 | 2015-07-01 | 2015-07-31 | 31 | 2015 | 215313504 | 112975 | 0 | TBC | monthly | 7 | |
1892 | 1892 | Brazil | Brazil | 0 | 2015-08-01 | 2015-08-31 | 31 | 2015 | 215313504 | 107510 | 0 | TBC | monthly | 8 | |
1894 | 1894 | Brazil | Brazil | 0 | 2015-10-01 | 2015-10-31 | 31 | 2015 | 215313504 | 104756 | 0 | TBC | monthly | 10 | |
1896 | 1896 | Brazil | Brazil | 0 | 2015-12-01 | 2015-12-31 | 31 | 2015 | 215313504 | 106733 | 0 | TBC | monthly | 12 | |
1897 | 1897 | Brazil | Brazil | 0 | 2016-01-01 | 2016-01-31 | 31 | 2016 | 215313504 | 106199 | 0 | TBC | monthly | 1 | |
1899 | 1899 | Brazil | Brazil | 0 | 2016-03-01 | 2016-03-31 | 31 | 2016 | 215313504 | 111631 | 0 | TBC | monthly | 3 | |
1901 | 1901 | Brazil | Brazil | 0 | 2016-05-01 | 2016-05-31 | 31 | 2016 | 215313504 | 115315 | 0 | TBC | monthly | 5 | |
1903 | 1903 | Brazil | Brazil | 0 | 2016-07-01 | 2016-07-31 | 31 | 2016 | 215313504 | 118151 | 0 | TBC | monthly | 7 | |
1904 | 1904 | Brazil | Brazil | 0 | 2016-08-01 | 2016-08-31 | 31 | 2016 | 215313504 | 111120 | 0 | TBC | monthly | 8 | |
1906 | 1906 | Brazil | Brazil | 0 | 2016-10-01 | 2016-10-31 | 31 | 2016 | 215313504 | 107472 | 0 | TBC | monthly | 10 | |
1908 | 1908 | Brazil | Brazil | 0 | 2016-12-01 | 2016-12-31 | 31 | 2016 | 215313504 | 105227 | 0 | TBC | monthly | 12 | |
1909 | 1909 | Brazil | Brazil | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 215313504 | 105899 | 0 | TBC | monthly | 1 | |
1911 | 1911 | Brazil | Brazil | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 215313504 | 108850 | 0 | TBC | monthly | 3 | |
1913 | 1913 | Brazil | Brazil | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 215313504 | 114774 | 0 | TBC | monthly | 5 | |
1915 | 1915 | Brazil | Brazil | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 215313504 | 122610 | 0 | TBC | monthly | 7 | |
1916 | 1916 | Brazil | Brazil | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 215313504 | 114698 | 0 | TBC | monthly | 8 | |
1918 | 1918 | Brazil | Brazil | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 215313504 | 109666 | 0 | TBC | monthly | 10 | |
1920 | 1920 | Brazil | Brazil | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 215313504 | 107971 | 0 | TBC | monthly | 12 | |
1921 | 1921 | Brazil | Brazil | 0 | 2018-01-01 | 2018-01-31 | 31 | 2018 | 215313504 | 106838 | 0 | TBC | monthly | 1 | |
1923 | 1923 | Brazil | Brazil | 0 | 2018-03-01 | 2018-03-31 | 31 | 2018 | 215313504 | 109390 | 0 | TBC | monthly | 3 | |
1925 | 1925 | Brazil | Brazil | 0 | 2018-05-01 | 2018-05-31 | 31 | 2018 | 215313504 | 115068 | 0 | TBC | monthly | 5 | |
1927 | 1927 | Brazil | Brazil | 0 | 2018-07-01 | 2018-07-31 | 31 | 2018 | 215313504 | 119675 | 0 | TBC | monthly | 7 | |
1928 | 1928 | Brazil | Brazil | 0 | 2018-08-01 | 2018-08-31 | 31 | 2018 | 215313504 | 115169 | 0 | TBC | monthly | 8 | |
1930 | 1930 | Brazil | Brazil | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 215313504 | 107666 | 0 | TBC | monthly | 10 | |
1932 | 1932 | Brazil | Brazil | 0 | 2018-12-01 | 2018-12-31 | 31 | 2018 | 215313504 | 110878 | 0 | TBC | monthly | 12 | |
1933 | 1933 | Brazil | Brazil | 0 | 2019-01-01 | 2019-01-31 | 31 | 2019 | 215313504 | 110373 | 0 | TBC | monthly | 1 | |
1935 | 1935 | Brazil | Brazil | 0 | 2019-03-01 | 2019-03-31 | 31 | 2019 | 215313504 | 109549 | 0 | TBC | monthly | 3 | |
1937 | 1937 | Brazil | Brazil | 0 | 2019-05-01 | 2019-05-31 | 31 | 2019 | 215313504 | 118736 | 0 | TBC | monthly | 5 | |
1939 | 1939 | Brazil | Brazil | 0 | 2019-07-01 | 2019-07-31 | 31 | 2019 | 215313504 | 124885 | 0 | TBC | monthly | 7 | |
1940 | 1940 | Brazil | Brazil | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 215313504 | 118568 | 0 | TBC | monthly | 8 | |
1942 | 1942 | Brazil | Brazil | 0 | 2019-10-01 | 2019-10-31 | 31 | 2019 | 215313504 | 111532 | 0 | TBC | monthly | 10 | |
1944 | 1944 | Brazil | Brazil | 0 | 2019-12-01 | 2019-12-31 | 31 | 2019 | 215313504 | 111193 | 0 | TBC | monthly | 12 | |
1945 | 1945 | Brazil | Brazil | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 215313504 | 110932 | 0 | TBC | monthly | 1 | |
1947 | 1947 | Brazil | Brazil | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 215313504 | 117888 | 201 | TBC | monthly | 3 | |
1949 | 1949 | Brazil | Brazil | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 215313504 | 154511 | 23361 | TBC | monthly | 5 | |
1951 | 1951 | Brazil | Brazil | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 215313504 | 145262 | 32936 | TBC | monthly | 7 | |
1952 | 1952 | Brazil | Brazil | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 215313504 | 141329 | 28890 | TBC | monthly | 8 | |
1954 | 1954 | Brazil | Brazil | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 215313504 | 128797 | 15894 | TBC | monthly | 10 | |
1956 | 1956 | Brazil | Brazil | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 215313504 | 139878 | 21804 | TBC | monthly | 12 | |
1957 | 1957 | Brazil | Brazil | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 215313504 | 151728 | 29576 | TBC | monthly | 1 | |
1959 | 1959 | Brazil | Brazil | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 215313504 | 209406 | 66959 | TBC | monthly | 3 | |
1961 | 1961 | Brazil | Brazil | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 215313504 | 182945 | 58714 | TBC | monthly | 5 | |
1963 | 1963 | Brazil | Brazil | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 215313504 | 158549 | 38188 | TBC | monthly | 7 | |
1964 | 1964 | Brazil | Brazil | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 215313504 | 143594 | 24088 | TBC | monthly | 8 | |
1966 | 1966 | Brazil | Brazil | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 215313504 | 125180 | 11050 | TBC | monthly | 10 | |
1968 | 1968 | Brazil | Brazil | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 215313504 | 132436 | 4349 | TBC | monthly | 12 | |
1969 | 1969 | Brazil | Brazil | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 215313504 | 167728 | 8255 | TBC | monthly | 1 | |
1971 | 1971 | Brazil | Brazil | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 215313504 | 123152 | 10346 | TBC | monthly | 3 | |
1973 | 1973 | Brazil | Brazil | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 215313504 | 133191.4 | 3023 | TBC | monthly | 5 | |
1975 | 1975 | Brazil | Brazil | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 215313504 | 136795 | 7098 | TBC | monthly | 7 | |
1976 | 1976 | Brazil | Brazil | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 215313504 | 135185.3 | 5451 | TBC | monthly | 8 | |
1978 | 1978 | Brazil | Brazil | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 215313504 | 118679.9 | 2121 | TBC | monthly | 10 | |
3211 | 3211 | Thailand | Thailand | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 71697024 | 44867 | 0 | TBC | monthly | 1 | |
3213 | 3213 | Thailand | Thailand | 0 | 2015-03-01 | 2015-03-31 | 31 | 2015 | 71697024 | 38987 | 0 | TBC | monthly | 3 | |
3215 | 3215 | Thailand | Thailand | 0 | 2015-05-01 | 2015-05-31 | 31 | 2015 | 71697024 | 38708 | 0 | TBC | monthly | 5 | |
3217 | 3217 | Thailand | Thailand | 0 | 2015-07-01 | 2015-07-31 | 31 | 2015 | 71697024 | 39105 | 0 | TBC | monthly | 7 | |
3218 | 3218 | Thailand | Thailand | 0 | 2015-08-01 | 2015-08-31 | 31 | 2015 | 71697024 | 40663 | 0 | TBC | monthly | 8 | |
3220 | 3220 | Thailand | Thailand | 0 | 2015-10-01 | 2015-10-31 | 31 | 2015 | 71697024 | 41876 | 0 | TBC | monthly | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_historical_deaths] ( [country] TEXT, [region] TEXT, [region_code] INTEGER, [start_date] TEXT, [end_date] TEXT, [days] INTEGER, [year] INTEGER, [week] INTEGER, [population] INTEGER, [total_deaths] INTEGER, [covid_deaths] INTEGER, [expected_deaths] TEXT, [cadence] TEXT , [month] INTEGER); CREATE INDEX [idx_economist_historical_deaths_country] ON [economist_historical_deaths] ([country]); CREATE INDEX [idx_economist_historical_deaths_cadence] ON [economist_historical_deaths] ([cadence]); CREATE INDEX [idx_economist_historical_deaths_end_date] ON [economist_historical_deaths] ([end_date]);