economist_historical_deaths

⚠️ 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

450 rows where country = "Ecuador"

View and edit SQL

Suggested facets: region, region_code, start_date, end_date, year, population, covid_deaths, month, start_date (date), end_date (date)

country

  • Ecuador · 450

cadence

Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
1045 Ecuador Ecuador EC 2018-01-01 2018-01-31 2018   17226800 6675 0 TBC monthly 1
1046 Ecuador Ecuador EC 2018-02-01 2018-02-28 2018   17226800 5733 0 TBC monthly 2
1047 Ecuador Ecuador EC 2018-03-01 2018-03-31 2018   17226800 6047 0 TBC monthly 3
1048 Ecuador Ecuador EC 2018-04-01 2018-04-30 2018   17226800 5754 0 TBC monthly 4
1049 Ecuador Ecuador EC 2018-05-01 2018-05-31 2018   17226800 5867 0 TBC monthly 5
1050 Ecuador Ecuador EC 2018-06-01 2018-06-30 2018   17226800 5728 0 TBC monthly 6
1051 Ecuador Ecuador EC 2019-01-01 2019-01-31 2019   17226800 6653 0 TBC monthly 1
1052 Ecuador Ecuador EC 2019-02-01 2019-02-28 2019   17226800 5876 0 TBC monthly 2
1053 Ecuador Ecuador EC 2019-03-01 2019-03-31 2019   17226800 6500 0 TBC monthly 3
1054 Ecuador Ecuador EC 2019-04-01 2019-04-30 2019   17226800 6076 0 TBC monthly 4
1055 Ecuador Ecuador EC 2019-05-01 2019-05-31 2019   17226800 5896 0 TBC monthly 5
1056 Ecuador Ecuador EC 2019-06-01 2019-06-30 2019   17226800 5842 0 TBC monthly 6
1057 Ecuador Ecuador EC 2020-01-01 2020-01-31 2020   17226800 6682 0 TBC monthly 1
1058 Ecuador Ecuador EC 2020-02-01 2020-02-29 2020   17226800 5998 0 TBC monthly 2
1059 Ecuador Ecuador EC 2020-03-01 2020-03-31 2020   17226800 9470 79 TBC monthly 3
1060 Ecuador Ecuador EC 2020-04-01 2020-04-30 2020   17226800 19709 821 TBC monthly 4
1061 Ecuador Ecuador EC 2020-05-01 2020-05-31 2020   17226800 9475 2458 TBC monthly 5
1062 Ecuador Ecuador EC 2020-06-01 2020-06-30 2020   17226800 8034 1169 TBC monthly 6
1063 Ecuador Azuay EC-A 2018-01-01 2018-01-31 2018   867200 362 0 TBC monthly 1
1064 Ecuador Azuay EC-A 2018-02-01 2018-02-28 2018   867200 318 0 TBC monthly 2
1065 Ecuador Azuay EC-A 2018-03-01 2018-03-31 2018   867200 346 0 TBC monthly 3
1066 Ecuador Azuay EC-A 2018-04-01 2018-04-30 2018   867200 342 0 TBC monthly 4
1067 Ecuador Azuay EC-A 2018-05-01 2018-05-31 2018   867200 325 0 TBC monthly 5
1068 Ecuador Azuay EC-A 2018-06-01 2018-06-30 2018   867200 319 0 TBC monthly 6
1069 Ecuador Azuay EC-A 2019-01-01 2019-01-31 2019   867200 354 0 TBC monthly 1
1070 Ecuador Azuay EC-A 2019-02-01 2019-02-28 2019   867200 298 0 TBC monthly 2
1071 Ecuador Azuay EC-A 2019-03-01 2019-03-31 2019   867200 311 0 TBC monthly 3
1072 Ecuador Azuay EC-A 2019-04-01 2019-04-30 2019   867200 309 0 TBC monthly 4
1073 Ecuador Azuay EC-A 2019-05-01 2019-05-31 2019   867200 347 0 TBC monthly 5
1074 Ecuador Azuay EC-A 2019-06-01 2019-06-30 2019   867200 334 0 TBC monthly 6
1075 Ecuador Azuay EC-A 2020-01-01 2020-01-31 2020   867200 361 0 TBC monthly 1
1076 Ecuador Azuay EC-A 2020-02-01 2020-02-29 2020   867200 319 0 TBC monthly 2
1077 Ecuador Azuay EC-A 2020-03-01 2020-03-31 2020   867200 330 0 TBC monthly 3
1078 Ecuador Azuay EC-A 2020-04-01 2020-04-30 2020   867200 345 0 TBC monthly 4
1079 Ecuador Azuay EC-A 2020-05-01 2020-05-31 2020   867200 354 0 TBC monthly 5
1080 Ecuador Azuay EC-A 2020-06-01 2020-06-30 2020   867200 338 0 TBC monthly 6
1081 Ecuador Bolívar EC-B 2018-01-01 2018-01-31 2018   208400 92 0 TBC monthly 1
1082 Ecuador Bolívar EC-B 2018-02-01 2018-02-28 2018   208400 75 0 TBC monthly 2
1083 Ecuador Bolívar EC-B 2018-03-01 2018-03-31 2018   208400 73 0 TBC monthly 3
1084 Ecuador Bolívar EC-B 2018-04-01 2018-04-30 2018   208400 74 0 TBC monthly 4
1085 Ecuador Bolívar EC-B 2018-05-01 2018-05-31 2018   208400 64 0 TBC monthly 5
1086 Ecuador Bolívar EC-B 2018-06-01 2018-06-30 2018   208400 82 0 TBC monthly 6
1087 Ecuador Bolívar EC-B 2019-01-01 2019-01-31 2019   208400 72 0 TBC monthly 1
1088 Ecuador Bolívar EC-B 2019-02-01 2019-02-28 2019   208400 74 0 TBC monthly 2
1089 Ecuador Bolívar EC-B 2019-03-01 2019-03-31 2019   208400 82 0 TBC monthly 3
1090 Ecuador Bolívar EC-B 2019-04-01 2019-04-30 2019   208400 55 0 TBC monthly 4
1091 Ecuador Bolívar EC-B 2019-05-01 2019-05-31 2019   208400 69 0 TBC monthly 5
1092 Ecuador Bolívar EC-B 2019-06-01 2019-06-30 2019   208400 74 0 TBC monthly 6
1093 Ecuador Bolívar EC-B 2020-01-01 2020-01-31 2020   208400 63 0 TBC monthly 1
1094 Ecuador Bolívar EC-B 2020-02-01 2020-02-29 2020   208400 84 0 TBC monthly 2
1095 Ecuador Bolívar EC-B 2020-03-01 2020-03-31 2020   208400 58 0 TBC monthly 3
1096 Ecuador Bolívar EC-B 2020-04-01 2020-04-30 2020   208400 110 0 TBC monthly 4
1097 Ecuador Bolívar EC-B 2020-05-01 2020-05-31 2020   208400 91 0 TBC monthly 5
1098 Ecuador Bolívar EC-B 2020-06-01 2020-06-30 2020   208400 89 0 TBC monthly 6
1099 Ecuador Carchi EC-C 2018-01-01 2018-01-31 2018   185500 54 0 TBC monthly 1
1100 Ecuador Carchi EC-C 2018-02-01 2018-02-28 2018   185500 64 0 TBC monthly 2
1101 Ecuador Carchi EC-C 2018-03-01 2018-03-31 2018   185500 57 0 TBC monthly 3
1102 Ecuador Carchi EC-C 2018-04-01 2018-04-30 2018   185500 48 0 TBC monthly 4
1103 Ecuador Carchi EC-C 2018-05-01 2018-05-31 2018   185500 58 0 TBC monthly 5
1104 Ecuador Carchi EC-C 2018-06-01 2018-06-30 2018   185500 57 0 TBC monthly 6
1105 Ecuador Carchi EC-C 2019-01-01 2019-01-31 2019   185500 62 0 TBC monthly 1
1106 Ecuador Carchi EC-C 2019-02-01 2019-02-28 2019   185500 57 0 TBC monthly 2
1107 Ecuador Carchi EC-C 2019-03-01 2019-03-31 2019   185500 57 0 TBC monthly 3
1108 Ecuador Carchi EC-C 2019-04-01 2019-04-30 2019   185500 57 0 TBC monthly 4
1109 Ecuador Carchi EC-C 2019-05-01 2019-05-31 2019   185500 62 0 TBC monthly 5
1110 Ecuador Carchi EC-C 2019-06-01 2019-06-30 2019   185500 56 0 TBC monthly 6
1111 Ecuador Carchi EC-C 2020-01-01 2020-01-31 2020   185500 57 0 TBC monthly 1
1112 Ecuador Carchi EC-C 2020-02-01 2020-02-29 2020   185500 57 0 TBC monthly 2
1113 Ecuador Carchi EC-C 2020-03-01 2020-03-31 2020   185500 56 0 TBC monthly 3
1114 Ecuador Carchi EC-C 2020-04-01 2020-04-30 2020   185500 51 0 TBC monthly 4
1115 Ecuador Carchi EC-C 2020-05-01 2020-05-31 2020   185500 65 0 TBC monthly 5
1116 Ecuador Carchi EC-C 2020-06-01 2020-06-30 2020   185500 67 0 TBC monthly 6
1117 Ecuador Orellana EC-D 2018-01-01 2018-01-31 2018   159500 42 0 TBC monthly 1
1118 Ecuador Orellana EC-D 2018-02-01 2018-02-28 2018   159500 32 0 TBC monthly 2
1119 Ecuador Orellana EC-D 2018-03-01 2018-03-31 2018   159500 38 0 TBC monthly 3
1120 Ecuador Orellana EC-D 2018-04-01 2018-04-30 2018   159500 34 0 TBC monthly 4
1121 Ecuador Orellana EC-D 2018-05-01 2018-05-31 2018   159500 37 0 TBC monthly 5
1122 Ecuador Orellana EC-D 2018-06-01 2018-06-30 2018   159500 34 0 TBC monthly 6
1123 Ecuador Orellana EC-D 2019-01-01 2019-01-31 2019   159500 28 0 TBC monthly 1
1124 Ecuador Orellana EC-D 2019-02-01 2019-02-28 2019   159500 39 0 TBC monthly 2
1125 Ecuador Orellana EC-D 2019-03-01 2019-03-31 2019   159500 43 0 TBC monthly 3
1126 Ecuador Orellana EC-D 2019-04-01 2019-04-30 2019   159500 35 0 TBC monthly 4
1127 Ecuador Orellana EC-D 2019-05-01 2019-05-31 2019   159500 34 0 TBC monthly 5
1128 Ecuador Orellana EC-D 2019-06-01 2019-06-30 2019   159500 32 0 TBC monthly 6
1129 Ecuador Orellana EC-D 2020-01-01 2020-01-31 2020   159500 42 0 TBC monthly 1
1130 Ecuador Orellana EC-D 2020-02-01 2020-02-29 2020   159500 26 0 TBC monthly 2
1131 Ecuador Orellana EC-D 2020-03-01 2020-03-31 2020   159500 24 0 TBC monthly 3
1132 Ecuador Orellana EC-D 2020-04-01 2020-04-30 2020   159500 28 0 TBC monthly 4
1133 Ecuador Orellana EC-D 2020-05-01 2020-05-31 2020   159500 42 0 TBC monthly 5
1134 Ecuador Orellana EC-D 2020-06-01 2020-06-30 2020   159500 59 0 TBC monthly 6
1135 Ecuador Esmeraldas EC-E 2018-01-01 2018-01-31 2018   635200 160 0 TBC monthly 1
1136 Ecuador Esmeraldas EC-E 2018-02-01 2018-02-28 2018   635200 139 0 TBC monthly 2
1137 Ecuador Esmeraldas EC-E 2018-03-01 2018-03-31 2018   635200 127 0 TBC monthly 3
1138 Ecuador Esmeraldas EC-E 2018-04-01 2018-04-30 2018   635200 128 0 TBC monthly 4
1139 Ecuador Esmeraldas EC-E 2018-05-01 2018-05-31 2018   635200 113 0 TBC monthly 5
1140 Ecuador Esmeraldas EC-E 2018-06-01 2018-06-30 2018   635200 122 0 TBC monthly 6
1141 Ecuador Esmeraldas EC-E 2019-01-01 2019-01-31 2019   635200 154 0 TBC monthly 1
1142 Ecuador Esmeraldas EC-E 2019-02-01 2019-02-28 2019   635200 122 0 TBC monthly 2
1143 Ecuador Esmeraldas EC-E 2019-03-01 2019-03-31 2019   635200 154 0 TBC monthly 3
1144 Ecuador Esmeraldas EC-E 2019-04-01 2019-04-30 2019   635200 151 0 TBC monthly 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_historical_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [week] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] TEXT,
   [cadence] TEXT
, [month] INTEGER);
Powered by Datasette · Query took 250.495ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette