economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where cadence = "weekly", country = "United States" and "start_date" is on date 2022-09-25 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), end_date (date)
Link | rowid | country | region | region_code | start_date | end_date ▲ | days | year | week | population | total_deaths | covid_deaths | expected_deaths | excess_deaths | non_covid_deaths | covid_deaths_per_100k | excess_deaths_per_100k | excess_deaths_pct_change | cadence | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2421 | 2421 | United States | Alabama | AL | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 4903185 | 1089 | 27 | 1010.05012529605 | 78.9498747039482 | 1062 | 0.550662477552856 | 1.61017531877643 | 0.0781643135590004 | weekly | |||||||||
2573 | 2573 | United States | Alaska | AK | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 731545 | 104 | 0 | 103.150375944682 | 0.849624055318273 | 104 | 0.0 | 0.116141051516759 | 0.00823675190261941 | weekly | |||||||||
2725 | 2725 | United States | Arizona | AZ | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 7278717 | 1272 | 0 | 1175.06516291984 | 96.9348370801636 | 1272 | 0.0 | 1.33175719127648 | 0.0824931587958042 | weekly | |||||||||
2877 | 2877 | United States | Arkansas | AR | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 3017825 | 719 | 102 | 602.576441104549 | 116.423558895451 | 617 | 3.3799176559277 | 3.85786315957524 | 0.193209609526124 | weekly | |||||||||
3029 | 3029 | United States | California | CA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 39512223 | 5499 | 160 | 4871.76190476214 | 627.238095237864 | 5339 | 0.404937985898693 | 1.58745331852846 | 0.128749743419263 | weekly | |||||||||
3181 | 3181 | United States | Colorado | CO | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 5758736 | 886 | 40 | 764.954887219014 | 121.045112780986 | 846 | 0.694596869868666 | 2.10193891126431 | 0.158238237056102 | weekly | |||||||||
3333 | 3333 | United States | Connecticut | CT | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 3565287 | 678 | 0 | 564.859649123211 | 113.140350876789 | 678 | 0.0 | 3.1733869076119 | 0.200298164424398 | weekly | |||||||||
3485 | 3485 | United States | Delaware | DE | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 973764 | 200 | 10 | 179.421052636234 | 20.5789473637658 | 190 | 1.02694287322185 | 2.11334033336269 | 0.114696391874862 | weekly | |||||||||
3637 | 3637 | United States | District of Columbia | DC | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 705749 | 123 | 9 | 117.709273183401 | 5.29072681659909 | 114 | 1.27524091426272 | 0.749661255857123 | 0.0449474087598494 | weekly | |||||||||
3789 | 3789 | United States | Florida | FL | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 21477737 | 4268 | 288 | 3914.14786967507 | 353.852130324931 | 3980 | 1.3409233943036 | 1.64752985998912 | 0.0904033629047094 | weekly | |||||||||
3941 | 3941 | United States | Georgia | GA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 10617423 | 1819 | 110 | 1642.39348370982 | 176.606516290182 | 1709 | 1.03603294321042 | 1.66336517147506 | 0.107529966504291 | weekly | |||||||||
4093 | 4093 | United States | Hawaii | HI | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1415872 | 241 | 7 | 217.72932330909 | 23.2706766909101 | 234 | 0.494394973556932 | 1.64355794103634 | 0.106878928098605 | weekly | |||||||||
4245 | 4245 | United States | Idaho | ID | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1787065 | 283 | 10 | 285.062656642266 | -2.06265664226646 | 273 | 0.559576736156771 | -0.115421467169155 | -0.00723580095184106 | weekly | |||||||||
4397 | 4397 | United States | Illinois | IL | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 12671821 | 2201 | 0 | 1935.07017543902 | 265.929824560976 | 2201 | 0.0 | 2.09859202210145 | 0.137426449922232 | weekly | |||||||||
4549 | 4549 | United States | Indiana | IN | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 6732219 | 1374 | 38 | 1240.92230576626 | 133.077694233738 | 1336 | 0.564449849299317 | 1.97672853829826 | 0.107240955872385 | weekly | |||||||||
4701 | 4701 | United States | Iowa | IA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 3155070 | 649 | 26 | 573.796992481673 | 75.2030075183272 | 623 | 0.824070464363707 | 2.38356066642982 | 0.13106204546851 | weekly | |||||||||
4853 | 4853 | United States | Kansas | KS | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 2913314 | 533 | 476 | 499.786967419214 | 33.2130325807859 | 57 | 16.3387811955732 | 1.14004300877921 | 0.066454379057322 | weekly | |||||||||
5005 | 5005 | United States | Kentucky | KY | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 4467673 | 1016 | 67 | 908.879699249752 | 107.120300750248 | 949 | 1.49966212836078 | 2.39767549572781 | 0.117859713269723 | weekly | |||||||||
5157 | 5157 | United States | Louisiana | LA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 4648794 | 876 | 57 | 800.566416040905 | 75.433583959095 | 819 | 1.22612445292263 | 1.62264845375155 | 0.0942252665708134 | weekly | |||||||||
5309 | 5309 | United States | Maine | ME | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1344212 | 376 | 9 | 302.157894737476 | 73.8421052625243 | 367 | 0.669537245613043 | 5.49333775197099 | 0.244382511754924 | weekly | |||||||||
5461 | 5461 | United States | Maryland | MD | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 6045680 | 960 | 42 | 912.215538847963 | 47.784461152037 | 918 | 0.694710934088473 | 0.790390181948714 | 0.0523828625111824 | weekly | |||||||||
5613 | 5613 | United States | Massachusetts | MA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 6949503 | 1188 | 0 | 1043.58395990046 | 144.416040099543 | 1188 | 0.0 | 2.07807723947372 | 0.138384687431683 | weekly | |||||||||
5765 | 5765 | United States | Michigan | MI | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 9986857 | 2084 | 160 | 1826.06265664232 | 257.937343357682 | 1924 | 1.60210564745245 | 2.5827679655139 | 0.141253281983197 | weekly | |||||||||
5917 | 5917 | United States | Minnesota | MN | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 5639632 | 905 | 0 | 897.213032582191 | 7.78696741780857 | 905 | 0.0 | 0.138075807389712 | 0.00867906186716616 | weekly | |||||||||
6069 | 6069 | United States | Mississippi | MS | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 2976149 | 624 | 0 | 588.914786968068 | 35.0852130319321 | 624 | 0.0 | 1.17887958673884 | 0.0595760436116108 | weekly | |||||||||
6221 | 6221 | United States | Missouri | MO | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 6137428 | 1282 | 0 | 1194.78696741931 | 87.2130325806929 | 1282 | 0.0 | 1.42100294424135 | 0.0729946299707886 | weekly | |||||||||
6373 | 6373 | United States | Montana | MT | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1068778 | 212 | 2 | 184.847117795282 | 27.1528822047178 | 210 | 0.187129600347313 | 2.54055399762325 | 0.146893727792876 | weekly | |||||||||
6525 | 6525 | United States | Nebraska | NE | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1934408 | 351 | 35 | 303.52130325921 | 47.4786967407903 | 316 | 1.80933908461917 | 2.45443033428265 | 0.156426241687039 | weekly | |||||||||
6677 | 6677 | United States | Nevada | NV | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 3080156 | 550 | 26 | 497.042606517105 | 52.9573934828945 | 524 | 0.844113090375942 | 1.71930881042696 | 0.106544977811821 | weekly | |||||||||
6829 | 6829 | United States | New Hampshire | NH | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1359711 | 261 | 13 | 227.644110276479 | 33.3558897235206 | 248 | 0.956085521114413 | 2.45316024681132 | 0.146526478031912 | weekly | |||||||||
6981 | 6981 | United States | New Jersey | NJ | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 8882190 | 1444 | 35 | 1299.2355889734 | 144.764411026598 | 1409 | 0.394046963642975 | 1.6298279031027 | 0.111422756777302 | weekly | |||||||||
7133 | 7133 | United States | New Mexico | NM | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 2096829 | 404 | 15 | 362.949874687552 | 41.0501253124481 | 389 | 0.715365916820113 | 1.95772403531466 | 0.113101362406548 | weekly | |||||||||
7285 | 7285 | United States | New York | NY | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 19453561 | 3138 | 191 | 2842.46616541434 | 295.533834585658 | 2947 | 0.981825384051794 | 1.51917602430556 | 0.103970924326755 | weekly | |||||||||
7437 | 7437 | United States | North Carolina | NC | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 10488084 | 2093 | 67 | 1828.74185463727 | 264.258145362733 | 2026 | 0.638820207771029 | 2.51960363172847 | 0.14450270533954 | weekly | |||||||||
7589 | 7589 | United States | North Dakota | ND | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 762062 | 149 | 0 | 157.90225564 | -8.90225564000019 | 149 | 0.0 | -1.1681799696088 | -0.056378267706931 | weekly | |||||||||
7741 | 7741 | United States | Ohio | OH | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 11689100 | 2440 | 89 | 2173.63408521546 | 266.365914784544 | 2351 | 0.761393092710303 | 2.27875469270127 | 0.122544045750985 | weekly | |||||||||
7893 | 7893 | United States | Oklahoma | OK | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 3956971 | 808 | 50 | 707.197994988153 | 100.802005011847 | 758 | 1.26359278346998 | 2.5474537218455 | 0.142537175905788 | weekly | |||||||||
8045 | 8045 | United States | Oregon | OR | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 4217737 | 827 | 41 | 691.443609023496 | 135.556390976504 | 786 | 0.972085267526164 | 3.21396025822624 | 0.196048367802467 | weekly | |||||||||
8197 | 8197 | United States | Pennsylvania | PA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 12801989 | 2662 | 115 | 2363.2380952392 | 298.761904760799 | 2547 | 0.898297912925874 | 2.33371474355117 | 0.126420569033083 | weekly | |||||||||
8349 | 8349 | United States | Rhode Island | RI | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1059361 | 198 | 2 | 197.711779449501 | 0.288220550498551 | 196 | 0.188793055436249 | 0.0272070191840695 | 0.00145778137904107 | weekly | |||||||||
8501 | 8501 | United States | South Carolina | SC | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 5148714 | 1120 | 0 | 986.942355890679 | 133.057644109321 | 1120 | 0.0 | 2.58428889445637 | 0.13481805022872 | weekly | |||||||||
8653 | 8653 | United States | South Dakota | SD | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 884659 | 150 | 4 | 154.884711780124 | -4.88471178012429 | 146 | 0.452151620002736 | -0.552157586157411 | -0.0315377271519133 | weekly | |||||||||
8805 | 8805 | United States | Tennessee | TN | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 6833174 | 1630 | 114 | 1436.05513784552 | 193.944862154484 | 1516 | 1.66833158353644 | 2.83828367541181 | 0.135053910566036 | weekly | |||||||||
8957 | 8957 | United States | Texas | TX | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 28995881 | 4177 | 115 | 3840.23558897298 | 336.764411027016 | 4062 | 0.396608056158045 | 1.16142155165768 | 0.0876936852504611 | weekly | |||||||||
9109 | 9109 | United States | Utah | UT | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 3205958 | 413 | 10 | 385.882205514614 | 27.1177944853859 | 403 | 0.311919245355055 | 0.845856199157503 | 0.0702747991429704 | weekly | |||||||||
9261 | 9261 | United States | Vermont | VT | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 623989 | 111 | 0 | 101.829573935699 | 9.17042606430066 | 111 | 0.0 | 1.46964546879843 | 0.0900566084081953 | weekly | |||||||||
9413 | 9413 | United States | Virginia | VA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 8535519 | 1534 | 80 | 1329.81704260716 | 204.182957392838 | 1454 | 0.937259936976299 | 2.39215632222057 | 0.153542142152524 | weekly | |||||||||
9565 | 9565 | United States | Washington | WA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 7614893 | 1186 | 65 | 1041.91228070257 | 144.087719297427 | 1121 | 0.853590457541557 | 1.89218311140324 | 0.138291602821178 | weekly | |||||||||
9717 | 9717 | United States | West Virginia | WV | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 1792147 | 479 | 34 | 416.716791980962 | 62.2832080190378 | 445 | 1.89716580168926 | 3.47534036097696 | 0.149461718888168 | weekly | |||||||||
9869 | 9869 | United States | Wisconsin | WI | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 5822434 | 1111 | 40 | 1033.82706767002 | 77.1729323299799 | 1071 | 0.686997911869847 | 1.32544108408923 | 0.0746478156195967 | weekly | |||||||||
10021 | 10021 | United States | Wyoming | WY | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 578759 | 82 | 3 | 103.556390978297 | -21.5563909782967 | 79 | 0.518350470575835 | -3.72458846917227 | -0.208160894510262 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_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] FLOAT, [excess_deaths] FLOAT, [non_covid_deaths] INTEGER, [covid_deaths_per_100k] FLOAT, [excess_deaths_per_100k] FLOAT, [excess_deaths_pct_change] FLOAT, [cadence] TEXT , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);