economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
20 rows where covid_deaths_per_7_days = "0.0" and "start_date" is on date 2022-08-01 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, excess_deaths_per_100k, excess_deaths_pct_change, total_deaths_per_7_days, expected_deaths_per_7_days, excess_deaths_per_7_days, excess_deaths_per_100k_per_7_days, start_date (date), end_date (date)
country 10
- Faroe Islands 2
- Greenland 2
- Kyrgyzstan 2
- Macao 2
- Monaco 2
- Oman 2
- Qatar 2
- Saint Kitts and Nevis 2
- San Marino 2
- Uzbekistan 2
cadence 1
- monthly 20
Link | rowid | country | region | region_code | start_date | end_date ▲ | days | year | week | population | total_deaths | covid_deaths | expected_deaths | excess_deaths | non_covid_deaths | covid_deaths_per_100k | excess_deaths_per_100k | excess_deaths_pct_change | cadence | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10631 | 10631 | Oman | Oman | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 4576300 | 840 | 0 | 816.681794684666 | 23.318205315334 | 840 | 0.0 | 0.509542759769552 | 0.028552375560591 | monthly | 8 | 189.677419354839 | 0.0 | 184.412018154602 | 5.26540120023671 | 189.677419354839 | 0.0 | 0.115058042528609 | ||
10999 | 10999 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 6630621 | 4307 | 0 | 2566.07193790671 | 1740.92806209329 | 4307 | 0.0 | 26.2558825499646 | 0.67844086378711 | monthly | 8 | 972.548387096774 | 0.0 | 579.43559888216 | 393.112788214614 | 972.548387096774 | 0.0 | 5.92874767257266 | ||
17990 | 17990 | Faroe Islands | Faroe Islands | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 49085 | 43 | 0 | 34.1688955786658 | 8.83110442133416 | 43 | 0.0 | 17.9914524219908 | 0.258454488264118 | monthly | 8 | 9.70967741935484 | 0.0 | 7.71555706615035 | 1.99412035320449 | 9.70967741935484 | 0.0 | 4.06258603077211 | ||
18057 | 18057 | Qatar | Qatar | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 2695131 | 229 | 0 | 174.974294532628 | 54.0257054673721 | 229 | 0.0 | 2.00456695675914 | 0.308763670753351 | monthly | 8 | 51.7096774193548 | 0.0 | 39.5103245718837 | 12.1993528474711 | 51.7096774193548 | 0.0 | 0.452644151526257 | ||
18239 | 18239 | Greenland | Greenland | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 56494 | 52 | 0 | 45.7190004865295 | 6.2809995134705 | 52 | 0.0 | 11.1179939701039 | 0.137382695304573 | monthly | 8 | 11.741935483871 | 0.0 | 10.3236452711518 | 1.41829021271915 | 11.741935483871 | 0.0 | 2.51051476744282 | ||
18272 | 18272 | Monaco | Monaco | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 36491 | 40 | 0 | 32.7677081432831 | 7.23229185671693 | 40 | 0.0 | 19.8193852092761 | 0.220713997606801 | monthly | 8 | 9.03225806451613 | 0.0 | 7.39915990332199 | 1.63309816119414 | 9.03225806451613 | 0.0 | 4.47534504725588 | ||
18305 | 18305 | San Marino | San Marino | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 33690 | 24 | 0 | 21.4887702973912 | 2.5112297026088 | 24 | 0.0 | 7.45393203505134 | 0.116862420131769 | monthly | 8 | 5.41935483870968 | 0.0 | 4.85230297037866 | 0.567051868331019 | 5.41935483870968 | 0.0 | 1.68314594339869 | ||
19535 | 19535 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 47681 | 32 | 0 | 28.7983040112606 | 3.20169598873938 | 32 | 0.0 | 6.71482558826237 | 0.111176546628838 | monthly | 8 | 7.2258064516129 | 0.0 | 6.5028428412524 | 0.722963610360505 | 7.2258064516129 | 0.0 | 1.51625093928505 | ||
21867 | 21867 | Faroe Islands | Faroe Islands | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 49085 | 43 | 0 | 34.1688955786658 | 8.83110442133416 | 43 | 0.0 | 17.9914524219908 | 0.25845448826412 | monthly | 8 | 9.70967741935484 | 0.0 | 7.71555706615035 | 1.99412035320449 | 9.70967741935484 | 0.0 | 4.06258603077211 | ||
21968 | 21968 | Greenland | Greenland | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 56494 | 52 | 0 | 45.7190004865295 | 6.2809995134705 | 52 | 0.0 | 11.1179939701039 | 0.137382695304573 | monthly | 8 | 11.741935483871 | 0.0 | 10.3236452711518 | 1.41829021271915 | 11.741935483871 | 0.0 | 2.51051476744282 | ||
22240 | 22240 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 6630621 | 4307 | 0 | 2566.07193790671 | 1740.92806209329 | 4307 | 0.0 | 26.2558825499646 | 0.678440863787109 | monthly | 8 | 972.548387096774 | 0.0 | 579.43559888216 | 393.112788214614 | 972.548387096774 | 0.0 | 5.92874767257266 | ||
22327 | 22327 | Macao | Macao | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 695180 | 201 | 0 | 175.831470838654 | 25.1685291613459 | 201 | 0.0 | 3.62043343613825 | 0.143140070667105 | monthly | 8 | 45.3870967741935 | 0.0 | 39.7038805119541 | 5.6832162622394 | 45.3870967741935 | 0.0 | 0.81751722751509 | ||
22469 | 22469 | Monaco | Monaco | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 36491 | 40 | 0 | 32.7677081432831 | 7.23229185671693 | 40 | 0.0 | 19.8193852092761 | 0.2207139976068 | monthly | 8 | 9.03225806451613 | 0.0 | 7.39915990332199 | 1.63309816119414 | 9.03225806451613 | 0.0 | 4.47534504725588 | ||
22582 | 22582 | Oman | Oman | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 4576300 | 840 | 0 | 816.681794684666 | 23.318205315334 | 840 | 0.0 | 0.509542759769552 | 0.028552375560591 | monthly | 8 | 189.677419354839 | 0.0 | 184.412018154602 | 5.26540120023671 | 189.677419354839 | 0.0 | 0.115058042528609 | ||
22714 | 22714 | Qatar | Qatar | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 2695131 | 229 | 0 | 174.974294532628 | 54.0257054673721 | 229 | 0.0 | 2.00456695675914 | 0.30876367075335 | monthly | 8 | 51.7096774193548 | 0.0 | 39.5103245718837 | 12.1993528474711 | 51.7096774193548 | 0.0 | 0.452644151526257 | ||
22782 | 22782 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 47681 | 32 | 0 | 28.7983040112606 | 3.20169598873938 | 32 | 0.0 | 6.71482558826237 | 0.111176546628839 | monthly | 8 | 7.2258064516129 | 0.0 | 6.5028428412524 | 0.722963610360505 | 7.2258064516129 | 0.0 | 1.51625093928505 | ||
22838 | 22838 | San Marino | San Marino | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 33690 | 24 | 0 | 21.4887702973912 | 2.5112297026088 | 24 | 0.0 | 7.45393203505135 | 0.116862420131769 | monthly | 8 | 5.41935483870968 | 0.0 | 4.85230297037866 | 0.567051868331019 | 5.41935483870968 | 0.0 | 1.68314594339869 | ||
23102 | 23102 | Uzbekistan | Uzbekistan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 34627648 | 18771 | 0 | 12541.09826826 | 6229.90173174 | 18771 | 0.0 | 17.9911200776328 | 0.496758864214239 | monthly | 8 | 4238.61290322581 | 0.0 | 2831.86089928452 | 1406.75200394129 | 4238.61290322581 | 0.0 | 4.06251098527191 | ||
24467 | 24467 | Macao | Macao | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 695180 | 201 | 0 | 175.831470838654 | 25.1685291613459 | 201 | 0.0 | 3.62043343613826 | 0.143140070667105 | monthly | 8 | 45.3870967741935 | 0.0 | 39.7038805119541 | 5.6832162622394 | 45.3870967741935 | 0.0 | 0.81751722751509 | ||
24501 | 24501 | Uzbekistan | Uzbekistan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 34627648 | 18771 | 0 | 12541.09826826 | 6229.90173174 | 18771 | 0.0 | 17.9911200776328 | 0.496758864214239 | monthly | 8 | 4238.61290322581 | 0.0 | 2831.86089928452 | 1406.75200394129 | 4238.61290322581 | 0.0 | 4.06251098527191 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_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] FLOAT, [excess_deaths] FLOAT, [non_covid_deaths] INTEGER, [covid_deaths_per_100k] FLOAT, [excess_deaths_per_100k] FLOAT, [excess_deaths_pct_change] FLOAT, [cadence] TEXT , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);