economist_historical_deaths

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

45 rows where cadence = "weekly" and "start_date" is on date 2017-09-04

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: start_date (date), end_date (date)

cadence 1

  • weekly · 45 ✖
Link rowid ▼ country region region_code start_date end_date days year week population total_deaths covid_deaths expected_deaths cadence month
140 140 United States United States 0 2017-09-04 2017-09-10 7 2017 36 338289856 51114 0 TBC weekly  
625 625 Ecuador Ecuador 0 2017-09-04 2017-09-10 7 2017 36 18001002 1258 0 TBC weekly  
1111 1111 Latvia Latvia 0 2017-09-04 2017-09-10 7 2017 36 1850654 471 0 TBC weekly  
1618 1618 Slovakia Slovakia 0 2017-09-04 2017-09-10 7 2017 36 5643455 953 0 TBC weekly  
2119 2119 Bulgaria Bulgaria 0 2017-09-04 2017-09-10 7 2017 36 6781955 1762 0 TBC weekly  
2529 2529 Luxembourg Luxembourg 0 2017-09-04 2017-09-10 7 2017 36 647601 75 0 TBC weekly  
2939 2939 Belgium Belgium 0 2017-09-04 2017-09-10 7 2017 36 11655923 1883 0 TBC weekly  
3446 3446 Sweden Sweden 0 2017-09-04 2017-09-10 7 2017 36 10549349 1635.1 0 TBC weekly  
3951 3951 Australia Australia 0 2017-09-04 2017-09-10 7 2017 36 26177410 3620 0 TBC weekly  
4615 4615 Czech Republic Czech Republic 0 2017-09-04 2017-09-10 7 2017 36 10493990 1920 0 TBC weekly  
5024 5024 Slovenia Slovenia 0 2017-09-04 2017-09-10 7 2017 36 2119843 339 0 TBC weekly  
5436 5436 Estonia Estonia 0 2017-09-04 2017-09-10 7 2017 36 1326064 259 0 TBC weekly  
6023 6023 Israel Israel 0 2017-09-04 2017-09-10 7 2017 36 9449000 737 0 TBC weekly  
6434 6434 Hungary Hungary 0 2017-09-04 2017-09-10 7 2017 36 9967304 2186 0 TBC weekly  
6830 6830 Peru Peru 0 2017-09-04 2017-09-10 7 2017 36 34049588 3072.6 0 TBC weekly  
7583 7583 South Korea South Korea 0 2017-09-04 2017-09-10 7 2017 36 51815808 5264 0 TBC weekly  
7978 7978 South Africa South Africa 0 2017-09-04 2017-09-10 7 2017 36 59893884 11441 0 TBC weekly  
8580 8580 Malta Malta 0 2017-09-04 2017-09-10 7 2017 36 533293 55 0 TBC weekly  
9301 9301 Romania Romania 0 2017-09-04 2017-09-10 7 2017 36 19659270 4301 0 TBC weekly  
9710 9710 New Zealand New Zealand 0 2017-09-04 2017-09-10 7 2017 36 5185289 687 0 TBC weekly  
10208 10208 Switzerland Switzerland 0 2017-09-04 2017-09-10 7 2017 36 8740471 1153 0 TBC weekly  
10927 10927 Lithuania Lithuania 0 2017-09-04 2017-09-10 7 2017 36 2750058 688 0 TBC weekly  
11421 11421 Britain Britain 0 2017-09-04 2017-09-10 7 2017 36 67508936 10776 0 TBC weekly  
11835 11835 Mexico Mexico 0 2017-09-04 2017-09-10 7 2017 36 127504120 12933 0 TBC weekly  
12503 12503 Iran Iran 0 2017-09-04 2017-09-10 7 2017 36 88550568 6644 0 TBC weekly  
13002 13002 Portugal Portugal 0 2017-09-04 2017-09-10 7 2017 36 10270857 1783 0 TBC weekly  
13416 13416 Croatia Croatia 0 2017-09-04 2017-09-10 7 2017 36 4030361 875 0 TBC weekly  
14086 14086 Montenegro Montenegro 0 2017-09-04 2017-09-10 7 2017 36 627082 102 0 TBC weekly  
14671 14671 Italy Italy 0 2017-09-04 2017-09-10 7 2017 36 59037472 10542 0 TBC weekly  
15160 15160 Canada Canada 0 2017-09-04 2017-09-10 7 2017 36 38454328 5045 0 TBC weekly  
15556 15556 Finland Finland 0 2017-09-04 2017-09-10 7 2017 36 5540745 1001 0 TBC weekly  
16308 16308 Iceland Iceland 0 2017-09-04 2017-09-10 7 2017 36 372903 36 0 TBC weekly  
16932 16932 Netherlands Netherlands 0 2017-09-04 2017-09-10 7 2017 36 17564020 2573 0 TBC weekly  
17347 17347 Austria Austria 0 2017-09-04 2017-09-10 7 2017 36 8939617 1318 0 TBC weekly  
17761 17761 Spain Spain 0 2017-09-04 2017-09-10 7 2017 36 47558632 6680 0 TBC weekly  
18265 18265 Denmark Denmark 0 2017-09-04 2017-09-10 7 2017 36 5882259 918 0 TBC weekly  
18680 18680 Cyprus Cyprus 0 2017-09-04 2017-09-10 7 2017 36 896007 81 0 TBC weekly  
19370 19370 Colombia Colombia 0 2017-09-04 2017-09-10 7 2017 36 51874028 4224 0 TBC weekly  
19947 19947 Greece Greece 0 2017-09-04 2017-09-10 7 2017 36 10384972 1976 0 TBC weekly  
20446 20446 Poland Poland 0 2017-09-04 2017-09-10 7 2017 36 39857144 6978 0 TBC weekly  
21188 21188 France France 0 2017-09-04 2017-09-10 7 2017 36 67813000 9776 0 TBC weekly  
37710 37710 Guatemala Guatemala 0 2017-09-04 2017-09-10 7 2017 36 17843914 1587 0 TBC weekly  
38106 38106 Germany Germany 0 2017-09-04 2017-09-10 7 2017 36 83369840 15706 0 TBC weekly  
38805 38805 Chile Chile 0 2017-09-04 2017-09-10 7 2017 36 19603736 2106 0 TBC weekly  
39388 39388 Norway Norway 0 2017-09-04 2017-09-10 7 2017 36 5434324 708 0 TBC weekly  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);