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 2021-01-11

✎ 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
315 315 United States United States 0 2021-01-11 2021-01-17 7 2021 2 338289856 87415 23341 TBC weekly  
800 800 Ecuador Ecuador 0 2021-01-11 2021-01-17 7 2021 2 18001002 2195 142 TBC weekly  
1286 1286 Latvia Latvia 0 2021-01-11 2021-01-17 7 2021 2 1850654 825 129 TBC weekly  
1793 1793 Slovakia Slovakia 0 2021-01-11 2021-01-17 7 2021 2 5643455 2045 556 TBC weekly  
2294 2294 Bulgaria Bulgaria 0 2021-01-11 2021-01-17 7 2021 2 6781955 2489 357 TBC weekly  
2704 2704 Luxembourg Luxembourg 0 2021-01-11 2021-01-17 7 2021 2 647601 94 22 TBC weekly  
3114 3114 Belgium Belgium 0 2021-01-11 2021-01-17 7 2021 2 11655923 2396 357 TBC weekly  
3621 3621 Sweden Sweden 0 2021-01-11 2021-01-17 7 2021 2 10549349 2352.9 890 TBC weekly  
4126 4126 Australia Australia 0 2021-01-11 2021-01-17 7 2021 2 26177410 2950 0 TBC weekly  
4790 4790 Czech Republic Czech Republic 0 2021-01-11 2021-01-17 7 2021 2 10493990 3751 1223 TBC weekly  
5199 5199 Slovenia Slovenia 0 2021-01-11 2021-01-17 7 2021 2 2119843 624 182 TBC weekly  
5611 5611 Estonia Estonia 0 2021-01-11 2021-01-17 7 2021 2 1326064 396 42 TBC weekly  
6198 6198 Israel Israel 0 2021-01-11 2021-01-17 7 2021 2 9449000 1264 334 TBC weekly  
6609 6609 Hungary Hungary 0 2021-01-11 2021-01-17 7 2021 2 9967304 3204 693 TBC weekly  
7005 7005 Peru Peru 0 2021-01-11 2021-01-17 7 2021 2 34049588 4932 2027 TBC weekly  
7758 7758 South Korea South Korea 0 2021-01-11 2021-01-17 7 2021 2 51815808 6332 124 TBC weekly  
8153 8153 South Africa South Africa 0 2021-01-11 2021-01-17 7 2021 2 59893884 24955 3942 TBC weekly  
8755 8755 Malta Malta 0 2021-01-11 2021-01-17 7 2021 2 533293 85 6 TBC weekly  
9476 9476 Romania Romania 0 2021-01-11 2021-01-17 7 2021 2 19659270 6524 567 TBC weekly  
9885 9885 New Zealand New Zealand 0 2021-01-11 2021-01-17 7 2021 2 5185289 631 0 TBC weekly  
10383 10383 Switzerland Switzerland 0 2021-01-11 2021-01-17 7 2021 2 8740471 1791 396 TBC weekly  
11102 11102 Lithuania Lithuania 0 2021-01-11 2021-01-17 7 2021 2 2750058 1195 248 TBC weekly  
11596 11596 Britain Britain 0 2021-01-11 2021-01-17 7 2021 2 67508936 20035 9317 TBC weekly  
12010 12010 Mexico Mexico 0 2021-01-11 2021-01-17 7 2021 2 127504120 43837 6998 TBC weekly  
12678 12678 Iran Iran 0 2021-01-11 2021-01-17 7 2021 2 88550568 8628.3 632 TBC weekly  
13177 13177 Portugal Portugal 0 2021-01-11 2021-01-17 7 2021 2 10270857 4618 1058 TBC weekly  
13591 13591 Croatia Croatia 0 2021-01-11 2021-01-17 7 2021 2 4030361 1358 248 TBC weekly  
14261 14261 Montenegro Montenegro 0 2021-01-11 2021-01-17 7 2021 2 627082 179 20 TBC weekly  
14846 14846 Italy Italy 0 2021-01-11 2021-01-17 7 2021 2 59037472 16921 3422 TBC weekly  
15335 15335 Canada Canada 0 2021-01-11 2021-01-17 7 2021 2 38454328 6775 1032 TBC weekly  
15731 15731 Finland Finland 0 2021-01-11 2021-01-17 7 2021 2 5540745 1130 32 TBC weekly  
16483 16483 Iceland Iceland 0 2021-01-11 2021-01-17 7 2021 2 372903 57 0 TBC weekly  
17107 17107 Netherlands Netherlands 0 2021-01-11 2021-01-17 7 2021 2 17564020 3852 645 TBC weekly  
17522 17522 Austria Austria 0 2021-01-11 2021-01-17 7 2021 2 8939617 1954 437 TBC weekly  
17936 17936 Spain Spain 0 2021-01-11 2021-01-17 7 2021 2 47558632 11858 1440 TBC weekly  
18440 18440 Denmark Denmark 0 2021-01-11 2021-01-17 7 2021 2 5882259 1213 205 TBC weekly  
18855 18855 Cyprus Cyprus 0 2021-01-11 2021-01-17 7 2021 2 896007 124 20 TBC weekly  
19545 19545 Colombia Colombia 0 2021-01-11 2021-01-17 7 2021 2 51874028 8537 2517 TBC weekly  
20122 20122 Greece Greece 0 2021-01-11 2021-01-17 7 2021 2 10384972 2498 206 TBC weekly  
20621 20621 Poland Poland 0 2021-01-11 2021-01-17 7 2021 2 39857144 10974 2166 TBC weekly  
21363 21363 France France 0 2021-01-11 2021-01-17 7 2021 2 67813000 14638 2533 TBC weekly  
37885 37885 Guatemala Guatemala 0 2021-01-11 2021-01-17 7 2021 2 17843914 1930 229 TBC weekly  
38281 38281 Germany Germany 0 2021-01-11 2021-01-17 7 2021 2 83369840 24532 6076 TBC weekly  
38980 38980 Chile Chile 0 2021-01-11 2021-01-17 7 2021 2 19603736 2439 381 TBC weekly  
39563 39563 Norway Norway 0 2021-01-11 2021-01-17 7 2021 2 5434324 868 45 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]);