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 "start_date" is on date 2019-11-18

✎ View and edit SQL

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

Suggested facets: start_date (date)

cadence 1

Link rowid ▼ country region region_code start_date end_date days year week population total_deaths covid_deaths expected_deaths cadence month
255 255 United States United States 0 2019-11-18 2019-11-24 7 2019 47 338289856 56321 0 TBC weekly  
740 740 Ecuador Ecuador 0 2019-11-18 2019-11-24 7 2019 47 18001002 1441 0 TBC weekly  
1226 1226 Latvia Latvia 0 2019-11-18 2019-11-24 7 2019 47 1850654 538 0 TBC weekly  
1733 1733 Slovakia Slovakia 0 2019-11-18 2019-11-24 7 2019 47 5643455 986 0 TBC weekly  
2234 2234 Bulgaria Bulgaria 0 2019-11-18 2019-11-24 7 2019 47 6781955 1958 0 TBC weekly  
2644 2644 Luxembourg Luxembourg 0 2019-11-18 2019-11-24 7 2019 47 647601 89 0 TBC weekly  
3054 3054 Belgium Belgium 0 2019-11-18 2019-11-24 7 2019 47 11655923 2187 0 TBC weekly  
3561 3561 Sweden Sweden 0 2019-11-18 2019-11-24 7 2019 47 10549349 1764.9 0 TBC weekly  
4066 4066 Australia Australia 0 2019-11-18 2019-11-24 7 2019 47 26177410 2980 0 TBC weekly  
4730 4730 Czech Republic Czech Republic 0 2019-11-18 2019-11-24 7 2019 47 10493990 2173 0 TBC weekly  
5139 5139 Slovenia Slovenia 0 2019-11-18 2019-11-24 7 2019 47 2119843 362 0 TBC weekly  
5551 5551 Estonia Estonia 0 2019-11-18 2019-11-24 7 2019 47 1326064 299 0 TBC weekly  
6138 6138 Israel Israel 0 2019-11-18 2019-11-24 7 2019 47 9449000 799 0 TBC weekly  
6549 6549 Hungary Hungary 0 2019-11-18 2019-11-24 7 2019 47 9967304 2301 0 TBC weekly  
6945 6945 Peru Peru 0 2019-11-18 2019-11-24 7 2019 47 34049588 3015.1 0 TBC weekly  
7698 7698 South Korea South Korea 0 2019-11-18 2019-11-24 7 2019 47 51815808 5993 0 TBC weekly  
8093 8093 South Africa South Africa 0 2019-11-18 2019-11-24 7 2019 47 59893884 9311 0 TBC weekly  
8695 8695 Malta Malta 0 2019-11-18 2019-11-24 7 2019 47 533293 75 0 TBC weekly  
9416 9416 Romania Romania 0 2019-11-18 2019-11-24 7 2019 47 19659270 4685 0 TBC weekly  
9825 9825 New Zealand New Zealand 0 2019-11-18 2019-11-24 7 2019 47 5185289 585 0 TBC weekly  
10323 10323 Switzerland Switzerland 0 2019-11-18 2019-11-24 7 2019 47 8740471 1331 0 TBC weekly  
11042 11042 Lithuania Lithuania 0 2019-11-18 2019-11-24 7 2019 47 2750058 702 0 TBC weekly  
11536 11536 Britain Britain 0 2019-11-18 2019-11-24 7 2019 47 67508936 12470 0 TBC weekly  
11950 11950 Mexico Mexico 0 2019-11-18 2019-11-24 7 2019 47 127504120 14855 0 TBC weekly  
12618 12618 Iran Iran 0 2019-11-18 2019-11-24 7 2019 47 88550568 8571.4 0 TBC weekly  
13117 13117 Portugal Portugal 0 2019-11-18 2019-11-24 7 2019 47 10270857 2233 0 TBC weekly  
13531 13531 Croatia Croatia 0 2019-11-18 2019-11-24 7 2019 47 4030361 915 0 TBC weekly  
14201 14201 Montenegro Montenegro 0 2019-11-18 2019-11-24 7 2019 47 627082 128 0 TBC weekly  
14786 14786 Italy Italy 0 2019-11-18 2019-11-24 7 2019 47 59037472 11968 0 TBC weekly  
15275 15275 Canada Canada 0 2019-11-18 2019-11-24 7 2019 47 38454328 5600 0 TBC weekly  
15671 15671 Finland Finland 0 2019-11-18 2019-11-24 7 2019 47 5540745 970 0 TBC weekly  
16423 16423 Iceland Iceland 0 2019-11-18 2019-11-24 7 2019 47 372903 51 0 TBC weekly  
17047 17047 Netherlands Netherlands 0 2019-11-18 2019-11-24 7 2019 47 17564020 3026 0 TBC weekly  
17462 17462 Austria Austria 0 2019-11-18 2019-11-24 7 2019 47 8939617 1553 0 TBC weekly  
17876 17876 Spain Spain 0 2019-11-18 2019-11-24 7 2019 47 47558632 8217 0 TBC weekly  
18380 18380 Denmark Denmark 0 2019-11-18 2019-11-24 7 2019 47 5882259 1057 0 TBC weekly  
18795 18795 Cyprus Cyprus 0 2019-11-18 2019-11-24 7 2019 47 896007 101 0 TBC weekly  
19485 19485 Colombia Colombia 0 2019-11-18 2019-11-24 7 2019 47 51874028 4738 0 TBC weekly  
20062 20062 Greece Greece 0 2019-11-18 2019-11-24 7 2019 47 10384972 2216 0 TBC weekly  
20561 20561 Poland Poland 0 2019-11-18 2019-11-24 7 2019 47 39857144 7527 0 TBC weekly  
21303 21303 France France 0 2019-11-18 2019-11-24 7 2019 47 67813000 12109 0 TBC weekly  
37825 37825 Guatemala Guatemala 0 2019-11-18 2019-11-24 7 2019 47 17843914 1585 0 TBC weekly  
38221 38221 Germany Germany 0 2019-11-18 2019-11-24 7 2019 47 83369840 18535 0 TBC weekly  
38920 38920 Chile Chile 0 2019-11-18 2019-11-24 7 2019 47 19603736 2003 0 TBC weekly  
39503 39503 Norway Norway 0 2019-11-18 2019-11-24 7 2019 47 5434324 784 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]);