daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

480,329 rows sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

country_or_region

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-08-04 US Oregon Wheeler 41069 0 0 0 0 44.72698162 -120.02814270000002 2020-07-06 19:33:59 Wheeler, Oregon, US
2020-08-04 US Idaho Lewis 16061 1 0 0 1 46.23315327 -116.434146 2020-07-10 02:34:22 Lewis, Idaho, US
2020-08-04 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-07-13 12:34:33 Grand Princess, Canada
2020-08-04 Colombia Unknown     0 0 0 0     2020-07-17 22:34:48 Unknown, Colombia
2020-08-04 US Maine Unassigned 90023 2 0 0 2 46.65926321 0.0 2020-08-04 12:34:49 Unassigned, Maine, US
2020-08-04 Zimbabwe       4221 81 1238 2902 -19.015438 29.154857 2020-08-05 04:34:43 Zimbabwe
2020-08-04 Zambia       6793 173 5109 1511 -13.133897 27.849332 2020-08-05 04:34:43 Zambia
2020-08-04 Yemen       1760 506 863 391 15.552727 48.516388 2020-08-05 04:34:43 Yemen
2020-08-04 Western Sahara       10 1 8 1 24.2155 -12.8858 2020-08-05 04:34:43 Western Sahara
2020-08-04 West Bank and Gaza       12770 86 6419 6265 31.9522 35.2332 2020-08-05 04:34:43 West Bank and Gaza
2020-08-04 Vietnam       672 8 378 286 14.058324 108.277199 2020-08-05 04:34:43 Vietnam
2020-08-04 Venezuela       21438 187 11875 9376 6.4238 -66.5897 2020-08-05 04:34:43 Venezuela
2020-08-04 Uzbekistan       27047 165 18051 8831 41.377491 64.585262 2020-08-05 04:34:43 Uzbekistan
2020-08-04 Uruguay       1300 37 1048 215 -32.5228 -55.7658 2020-08-05 04:34:43 Uruguay
2020-08-04 United Arab Emirates       61352 351 55090 5911 23.424076 53.847818 2020-08-05 04:34:43 United Arab Emirates
2020-08-04 Uganda       1203 5 1073 125 1.373333 32.290275 2020-08-05 04:34:43 Uganda
2020-08-04 Turkey       234934 5765 218491 10678 38.9637 35.2433 2020-08-05 04:34:43 Turkey
2020-08-04 Tunisia       1584 51 1227 306 33.886917 9.537499 2020-08-05 04:34:43 Tunisia
2020-08-04 Trinidad and Tobago       194 8 135 51 10.6918 -61.2225 2020-08-05 04:34:43 Trinidad and Tobago
2020-08-04 Togo       988 19 673 296 8.6195 0.8248 2020-08-05 04:34:43 Togo
2020-08-04 Timor-Leste       25 0 24 1 -8.874217 125.727539 2020-08-05 04:34:43 Timor-Leste
2020-08-04 Thailand       3321 58 3142 121 15.870032 100.992541 2020-08-05 04:34:43 Thailand
2020-08-04 Tanzania       509 21 183 305 -6.369028 34.888822 2020-08-05 04:34:43 Tanzania
2020-08-04 Tajikistan       7583 61 6356 1166 38.861034 71.276093 2020-08-05 04:34:43 Tajikistan
2020-08-04 Taiwan*       476 7 441 28 23.7 121.0 2020-08-05 04:34:43 Taiwan*
2020-08-04 Syria       892 46 283 563 34.802075 38.99681500000001 2020-08-05 04:34:43 Syria
2020-08-04 Switzerland       35746 1981 31600 2165 46.8182 8.2275 2020-08-05 04:34:43 Switzerland
2020-08-04 Suriname       1981 27 1278 676 3.9193 -56.0278 2020-08-05 04:34:43 Suriname
2020-08-04 Sudan       11780 763 6194 4823 12.8628 30.2176 2020-08-05 04:34:43 Sudan
2020-08-04 Sri Lanka       2834 11 2524 299 7.873054 80.77179699999998 2020-08-05 04:34:43 Sri Lanka
2020-08-04 South Sudan       2437 47 1175 1215 6.877000000000002 31.307 2020-08-05 04:34:43 South Sudan
2020-08-04 South Africa       521318 8884 363751 148683 -30.5595 22.9375 2020-08-05 04:34:43 South Africa
2020-08-04 Somalia       3220 93 1598 1529 5.152149 46.199616 2020-08-05 04:34:43 Somalia
2020-08-04 Slovenia       2190 123 1854 213 46.1512 14.9955 2020-08-05 04:34:43 Slovenia
2020-08-04 Slovakia       2368 29 1771 568 48.669 19.699 2020-08-05 04:34:43 Slovakia
2020-08-04 Singapore       53346 27 47454 5865 1.2833 103.8333 2020-08-05 04:34:43 Singapore
2020-08-04 Sierra Leone       1855 67 1397 391 8.460555000000001 -11.779889 2020-08-05 04:34:43 Sierra Leone
2020-08-04 Seychelles       114 0 113 1 -4.6796 55.492 2020-08-05 04:34:43 Seychelles
2020-08-04 Serbia       26738 605 0 26133 44.0165 21.0059 2020-08-05 04:34:43 Serbia
2020-08-04 Senegal       10432 214 6920 3298 14.4974 -14.4524 2020-08-05 04:34:43 Senegal
2020-08-04 Saudi Arabia       281456 2984 243713 34759 23.885942 45.079162 2020-08-05 04:34:43 Saudi Arabia
2020-08-04 Sao Tome and Principe       875 15 794 66 0.18636 6.613081 2020-08-05 04:34:43 Sao Tome and Principe
2020-08-04 San Marino       699 42 657 0 43.9424 12.4578 2020-08-05 04:34:43 San Marino
2020-08-04 Saint Vincent and the Grenadines       55 0 45 10 12.9843 -61.2872 2020-08-05 04:34:43 Saint Vincent and the Grenadines
2020-08-04 Saint Lucia       25 0 22 3 13.9094 -60.9789 2020-08-05 04:34:43 Saint Lucia
2020-08-04 Saint Kitts and Nevis       17 0 16 1 17.357822 -62.782998 2020-08-05 04:34:43 Saint Kitts and Nevis
2020-08-04 Rwanda       2099 5 1222 872 -1.9403 29.8739 2020-08-05 04:34:43 Rwanda
2020-08-04 Romania       55241 2480 28006 24755 45.9432 24.9668 2020-08-05 04:34:43 Romania
2020-08-04 Qatar       111538 177 108254 3107 25.3548 51.1839 2020-08-05 04:34:43 Qatar
2020-08-04 Portugal       51681 1739 37318 12624 39.3999 -8.2245 2020-08-05 04:34:43 Portugal
2020-08-04 Poland       48149 1738 35056 11355 51.9194 19.1451 2020-08-05 04:34:43 Poland
2020-08-04 Philippines       112593 2115 66049 44429 12.879721 121.774017 2020-08-05 04:34:43 Philippines
2020-08-04 Paraguay       5852 59 4645 1148 -23.4425 -58.4438 2020-08-05 04:34:43 Paraguay
2020-08-04 Papua New Guinea       114 2 34 78 -6.314993 143.95555 2020-08-05 04:34:43 Papua New Guinea
2020-08-04 Panama       69424 1522 43330 24572 8.538 -80.7821 2020-08-05 04:34:43 Panama
2020-08-04 Oman       79159 421 61421 17317 21.512583 55.92325500000001 2020-08-05 04:34:43 Oman
2020-08-04 Norway       9362 256 8752 354 60.472 8.4689 2020-08-05 04:34:43 Norway
2020-08-04 North Macedonia       11202 505 7108 3589 41.6086 21.7453 2020-08-05 04:34:43 North Macedonia
2020-08-04 Nigeria       44433 910 31851 11672 9.082 8.6753 2020-08-05 04:34:43 Nigeria
2020-08-04 Niger       1152 69 1037 46 17.607789 8.081666 2020-08-05 04:34:43 Niger
2020-08-04 Nicaragua       3902 123 2913 866 12.865416 -85.207229 2020-08-05 04:34:43 Nicaragua
2020-08-04 New Zealand       1569 22 1523 24 -40.9006 174.886 2020-08-05 04:34:43 New Zealand
2020-08-04 Nepal       21009 58 15026 5925 28.1667 84.25 2020-08-05 04:34:43 Nepal
2020-08-04 Namibia       2470 12 211 2247 -22.9576 18.4904 2020-08-05 04:34:43 Namibia
2020-08-04 Mozambique       2029 15 765 1249 -18.665695 35.529562 2020-08-05 04:34:43 Mozambique
2020-08-04 Morocco       27217 417 19629 7171 31.7917 -7.0926 2020-08-05 04:34:43 Morocco
2020-08-04 Montenegro       3361 53 1869 1439 42.708678000000006 19.37439 2020-08-05 04:34:43 Montenegro
2020-08-04 Mongolia       293 0 244 49 46.8625 103.8467 2020-08-05 04:34:43 Mongolia
2020-08-04 Monaco       123 4 105 14 43.7333 7.4167 2020-08-05 04:34:43 Monaco
2020-08-04 Moldova       25814 810 18167 6837 47.4116 28.3699 2020-08-05 04:34:43 Moldova
2020-08-04 Mauritius       344 10 334 0 -20.348404 57.552152 2020-08-05 04:34:43 Mauritius
2020-08-04 Mauritania       6418 157 5209 1052 21.0079 -10.9408 2020-08-05 04:34:43 Mauritania
2020-08-04 Malta       890 9 666 215 35.9375 14.3754 2020-08-05 04:34:43 Malta
2020-08-04 Mali       2543 124 1946 473 17.570692 -3.996166000000001 2020-08-05 04:34:43 Mali
2020-08-04 Maldives       4446 19 2693 1734 3.2028 73.2207 2020-08-05 04:34:43 Maldives
2020-08-04 Malaysia       9002 125 8684 193 4.210483999999999 101.975766 2020-08-05 04:34:43 Malaysia
2020-08-04 Malawi       4361 128 2047 2186 -13.254307999999998 34.301525 2020-08-05 04:34:43 Malawi
2020-08-04 Madagascar       11895 123 9286 2486 -18.766947 46.869107 2020-08-05 04:34:43 Madagascar
2020-08-04 MS Zaandam       9 2 0 7     2020-08-05 04:34:43 MS Zaandam
2020-08-04 Luxembourg       6917 118 5537 1262 49.8153 6.1296 2020-08-05 04:34:43 Luxembourg
2020-08-04 Lithuania       2137 80 1647 410 55.1694 23.8813 2020-08-05 04:34:43 Lithuania
2020-08-04 Liechtenstein       89 1 85 3 47.14 9.55 2020-08-05 04:34:43 Liechtenstein
2020-08-04 Libya       4224 96 633 3495 26.3351 17.228331 2020-08-05 04:34:43 Libya
2020-08-04 Liberia       1216 78 698 440 6.4280550000000005 -9.429499 2020-08-05 04:34:43 Liberia
2020-08-04 Lesotho       726 21 174 531 -29.609988 28.233608 2020-08-05 04:34:43 Lesotho
2020-08-04 Lebanon       5062 65 1837 3160 33.8547 35.8623 2020-08-05 04:34:43 Lebanon
2020-08-04 Latvia       1249 32 1070 147 56.8796 24.6032 2020-08-05 04:34:43 Latvia
2020-08-04 Laos       20 0 19 1 19.85627 102.495496 2020-08-05 04:34:43 Laos
2020-08-04 Kyrgyzstan       37541 1427 28743 7371 41.20438 74.766098 2020-08-05 04:34:43 Kyrgyzstan
2020-08-04 Kuwait       68774 465 60326 7983 29.31166 47.481766 2020-08-05 04:34:43 Kuwait
2020-08-04 Kosovo       9274 296 5190 3788 42.602636 20.902977 2020-08-05 04:34:43 Kosovo
2020-08-04 Korea, South       14456 302 13406 748 35.90775700000001 127.766922 2020-08-05 04:34:43 Korea, South
2020-08-04 Kenya       23202 388 9327 13487 -0.0236 37.9062 2020-08-05 04:34:43 Kenya
2020-08-04 Kazakhstan       94882 1058 67031 26793 48.0196 66.9237 2020-08-05 04:34:43 Kazakhstan
2020-08-04 Jordan       1224 11 1155 58 31.24 36.51 2020-08-05 04:34:43 Jordan
2020-08-04 Jamaica       920 12 745 163 18.1096 -77.2975 2020-08-05 04:34:43 Jamaica
2020-08-04 Israel       76198 561 49834 25803 31.046051 34.851612 2020-08-05 04:34:43 Israel
2020-08-04 Ireland       26253 1763 23364 1126 53.1424 -7.6921 2020-08-05 04:34:43 Ireland
2020-08-04 Iraq       134722 5017 96103 33602 33.223191 43.679291 2020-08-05 04:34:43 Iraq
2020-08-04 Iran       314786 17617 272535 24634 32.427908 53.68804599999999 2020-08-05 04:34:43 Iran

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 3049.598ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette