economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
122 rows where "start_date" is on date 2018-04-01 sorted by cadence
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence ▼ | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30764 | 30764 | United States | New Jersey | NJ | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 8882190 | 1463 | 0 | 1428 | weekly | |
31072 | 31072 | United States | New Mexico | NM | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 2096829 | 369 | 0 | 356 | weekly | |
31380 | 31380 | United States | New York | NY | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 19453561 | 3018 | 0 | 3030 | weekly | |
31688 | 31688 | United States | North Carolina | NC | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 10488084 | 1799 | 0 | 1863 | weekly | |
31996 | 31996 | United States | North Dakota | ND | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 762062 | 144 | 0 | 139 | weekly | |
32304 | 32304 | United States | Ohio | OH | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 11689100 | 2540 | 0 | 2383 | weekly | |
32612 | 32612 | United States | Oklahoma | OK | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3956971 | 743 | 0 | 776 | weekly | |
32920 | 32920 | United States | Oregon | OR | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 4217737 | 743 | 0 | 751 | weekly | |
33228 | 33228 | United States | Pennsylvania | PA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 12801989 | 2669 | 0 | 2699 | weekly | |
33536 | 33536 | United States | Rhode Island | RI | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1059361 | 229 | 0 | 227 | weekly | |
33844 | 33844 | United States | South Carolina | SC | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 5148714 | 927 | 0 | 961 | weekly | |
34152 | 34152 | United States | South Dakota | SD | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 884659 | 150 | 0 | 160 | weekly | |
34460 | 34460 | United States | Tennessee | TN | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 6833174 | 1415 | 0 | 1433 | weekly | |
34768 | 34768 | United States | Texas | TX | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 28995881 | 3768 | 0 | 4039 | weekly | |
35076 | 35076 | United States | Utah | UT | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 3205958 | 344 | 0 | 373 | weekly | |
35384 | 35384 | United States | Vermont | VT | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 623989 | 94 | 0 | 116 | weekly | |
35692 | 35692 | United States | Virginia | VA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 8535519 | 1338 | 0 | 1317 | weekly | |
36000 | 36000 | United States | Washington | WA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 7614893 | 1166 | 0 | 1134 | weekly | |
36308 | 36308 | United States | West Virginia | WV | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 1792147 | 443 | 0 | 431 | weekly | |
36616 | 36616 | United States | Wisconsin | WI | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 5822434 | 1034 | 0 | 1057 | weekly | |
36924 | 36924 | United States | Wyoming | WY | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 578759 | 94 | 0 | 91 | weekly | |
37232 | 37232 | United States | United States | USA | 2018-04-01 | 2018-04-07 | 7 | 2018 | 14 | 328300544 | 55423 | 0 | 55790 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
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]);