economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
20 rows where cadence = "monthly", country = "Macao" and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_pct_change, month, total_deaths_per_7_days, covid_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, start_date (date), end_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22329 | 22329 | Macao | Macao | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 695180 | 186 | 0 | 162.631470838654 | 23.3685291613459 | 186 | 0.0 | 3.36150769028826 | 0.143690080651917 | monthly | 10 | 42.0 | 0.0 | 36.7232353506638 | 5.27676464933618 | 42.0 | 0.0 | 0.759050123613478 | ||
24469 | 24469 | Macao | Macao | 0 | 2022-10-01 | 2022-10-31 | 31 | 2022 | 695180 | 186 | 0 | 162.631470838654 | 23.3685291613459 | 186 | 0.0 | 3.36150769028826 | 0.143690080651916 | monthly | 10 | 42.0 | 0.0 | 36.7232353506638 | 5.27676464933618 | 42.0 | 0.0 | 0.759050123613478 | ||
22328 | 22328 | Macao | Macao | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 695180 | 158 | 0 | 155.165939521278 | 2.83406047872185 | 158 | 0.0 | 0.407672901798362 | 0.0182647073672593 | monthly | 9 | 36.8666666666667 | 0.0 | 36.2053858882982 | 0.661280778368432 | 36.8666666666667 | 0.0 | 0.0951236770862845 | ||
24468 | 24468 | Macao | Macao | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 695180 | 158 | 0 | 155.165939521278 | 2.83406047872185 | 158 | 0.0 | 0.407672901798362 | 0.0182647073672584 | monthly | 9 | 36.8666666666667 | 0.0 | 36.2053858882982 | 0.661280778368432 | 36.8666666666667 | 0.0 | 0.0951236770862845 | ||
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 | ||
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 | ||
22326 | 22326 | Macao | Macao | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 695180 | 203 | 6 | 174.831470838654 | 28.1685291613459 | 197 | 0.863085819499986 | 4.05197634588824 | 0.161118184421967 | monthly | 7 | 45.8387096774194 | 1.35483870967742 | 39.4780740603412 | 6.36063561707811 | 44.4838709677419 | 0.194890346338706 | 0.914962400684443 | ||
24466 | 24466 | Macao | Macao | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 695180 | 203 | 6 | 174.831470838654 | 28.1685291613459 | 197 | 0.863085819499986 | 4.05197634588825 | 0.161118184421966 | monthly | 7 | 45.8387096774194 | 1.35483870967742 | 39.4780740603412 | 6.36063561707811 | 44.4838709677419 | 0.194890346338706 | 0.914962400684443 | ||
22325 | 22325 | Macao | Macao | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 695180 | 228 | 0 | 164.965939521278 | 63.0340604787218 | 228 | 0.0 | 9.06730062411488 | 0.382103485493086 | monthly | 6 | 53.2 | 0.0 | 38.4920525549649 | 14.7079474450351 | 53.2 | 0.0 | 2.11570347896014 | ||
24465 | 24465 | Macao | Macao | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 695180 | 228 | 0 | 164.965939521278 | 63.0340604787218 | 228 | 0.0 | 9.06730062411488 | 0.382103485493085 | monthly | 6 | 53.2 | 0.0 | 38.4920525549649 | 14.7079474450351 | 53.2 | 0.0 | 2.11570347896014 | ||
22324 | 22324 | Macao | Macao | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 695180 | 202 | 0 | 172.231470838654 | 29.7685291613459 | 202 | 0.0 | 4.28213256442157 | 0.172840242357525 | monthly | 5 | 45.6129032258065 | 0.0 | 38.8909772861477 | 6.72192593965876 | 45.6129032258065 | 0.0 | 0.966933159708098 | ||
24464 | 24464 | Macao | Macao | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 695180 | 202 | 0 | 172.231470838654 | 29.7685291613459 | 202 | 0.0 | 4.28213256442158 | 0.172840242357525 | monthly | 5 | 45.6129032258065 | 0.0 | 38.8909772861477 | 6.72192593965876 | 45.6129032258065 | 0.0 | 0.966933159708098 | ||
22323 | 22323 | Macao | Macao | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 695180 | 209 | 0 | 167.365939521278 | 41.6340604787219 | 209 | 0.0 | 5.98896120123161 | 0.248760653438861 | monthly | 4 | 48.7666666666667 | 0.0 | 39.0520525549649 | 9.71461411170178 | 48.7666666666667 | 0.0 | 1.39742428028738 | ||
24463 | 24463 | Macao | Macao | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 695180 | 209 | 0 | 167.365939521278 | 41.6340604787219 | 209 | 0.0 | 5.98896120123161 | 0.24876065343886 | monthly | 4 | 48.7666666666667 | 0.0 | 39.0520525549649 | 9.71461411170178 | 48.7666666666667 | 0.0 | 1.39742428028738 | ||
22322 | 22322 | Macao | Macao | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 695180 | 218 | 0 | 176.231470838654 | 41.7685291613459 | 218 | 0.0 | 6.00830420342155 | 0.237009479422586 | monthly | 3 | 49.2258064516129 | 0.0 | 39.7942030925993 | 9.43160335901359 | 49.2258064516129 | 0.0 | 1.35671385238551 | ||
24462 | 24462 | Macao | Macao | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 695180 | 218 | 0 | 176.231470838654 | 41.7685291613459 | 218 | 0.0 | 6.00830420342155 | 0.237009479422585 | monthly | 3 | 49.2258064516129 | 0.0 | 39.7942030925993 | 9.43160335901359 | 49.2258064516129 | 0.0 | 1.35671385238551 | ||
22321 | 22321 | Macao | Macao | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 695180 | 190 | 0 | 171.163343220862 | 18.8366567791379 | 190 | 0.0 | 2.70960855881037 | 0.110050764519316 | monthly | 2 | 47.5 | 0.0 | 42.7908358052155 | 4.70916419478446 | 47.5 | 0.0 | 0.67740213970259 | ||
24461 | 24461 | Macao | Macao | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 695180 | 190 | 0 | 171.163343220862 | 18.8366567791379 | 190 | 0.0 | 2.70960855881036 | 0.110050764519315 | monthly | 2 | 47.5 | 0.0 | 42.7908358052155 | 4.70916419478446 | 47.5 | 0.0 | 0.67740213970259 | ||
22320 | 22320 | Macao | Macao | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 695180 | 205 | 0 | 201.168323754789 | 3.83167624521087 | 205 | 0.0 | 0.551177572026075 | 0.0190471152400791 | monthly | 1 | 46.2903225806452 | 0.0 | 45.4251053639846 | 0.865217216660519 | 46.2903225806452 | 0.0 | 0.124459451747823 | ||
24460 | 24460 | Macao | Macao | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 695180 | 205 | 0 | 201.168323754789 | 3.83167624521087 | 205 | 0.0 | 0.551177572026076 | 0.0190471152400784 | monthly | 1 | 46.2903225806452 | 0.0 | 45.4251053639846 | 0.865217216660519 | 46.2903225806452 | 0.0 | 0.124459451747823 |
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);