daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,852 rows where "day" is on date 2020-07-13 sorted by country_or_region descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
day | country_or_region ▲ | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-13 | Zimbabwe | 1034 | 19 | 343 | 672 | -19.015438 | 29.154857 | 2020-07-14 04:34:46 | Zimbabwe | |||
2020-07-13 | Zambia | 1895 | 42 | 1412 | 441 | -13.133897 | 27.849332 | 2020-07-14 04:34:46 | Zambia | |||
2020-07-13 | Yemen | 1498 | 424 | 675 | 399 | 15.552726999999999 | 48.516388 | 2020-07-14 04:34:46 | Yemen | |||
2020-07-13 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-07-14 04:34:46 | Winter Olympics 2022 | |||
2020-07-13 | West Bank and Gaza | 6566 | 39 | 1084 | 5443 | 31.9522 | 35.2332 | 2020-07-14 04:34:46 | West Bank and Gaza | |||
2020-07-13 | Vietnam | 373 | 0 | 352 | 21 | 14.058323999999999 | 108.277199 | 2020-07-14 04:34:46 | Vietnam | |||
2020-07-13 | Venezuela | 9707 | 93 | 2671 | 6943 | 6.4238 | -66.5897 | 2020-07-14 04:34:46 | Venezuela | |||
2020-07-13 | Uzbekistan | 13591 | 64 | 8030 | 5497 | 41.377491 | 64.585262 | 2020-07-14 04:34:46 | Uzbekistan | |||
2020-07-13 | Uruguay | 989 | 31 | 903 | 55 | -32.5228 | -55.7658 | 2020-07-14 04:34:46 | Uruguay | |||
2020-07-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-07-14 04:34:46 | Pitcairn Islands, United Kingdom | ||
2020-07-13 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-14 04:34:46 | Guernsey, United Kingdom | ||
2020-07-13 | United Kingdom | Jersey | 321 | 31 | 0 | 0 | 49.2138 | -2.1358 | 2020-07-14 04:34:46 | Jersey, United Kingdom | ||
2020-07-13 | United Kingdom | Wales | 15973 | 2519 | 0 | 14432 | 52.1307 | -3.7837 | 2020-07-14 04:34:46 | Wales, United Kingdom | ||
2020-07-13 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-07-14 04:34:46 | Unknown, United Kingdom | ||
2020-07-13 | United Kingdom | Turks and Caicos Islands | 72 | 2 | 11 | 59 | 21.69400000000001 | -71.7979 | 2020-07-14 04:34:46 | Turks and Caicos Islands, United Kingdom | ||
2020-07-13 | United Kingdom | Scotland | 18365 | 4194 | 0 | 15875 | 56.4907 | -4.2026 | 2020-07-14 04:34:46 | Scotland, United Kingdom | ||
2020-07-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 0 | 0 | 0 | 0 | -7.9467 | -14.3559 | 2020-07-14 04:34:46 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2020-07-13 | United Kingdom | Northern Ireland | 5788 | 848 | 0 | 5234 | 54.7877 | -6.4923 | 2020-07-14 04:34:46 | Northern Ireland, United Kingdom | ||
2020-07-13 | United Kingdom | Montserrat | 12 | 1 | 10 | 1 | 16.742498 | -62.187366000000004 | 2020-07-14 04:34:46 | Montserrat, United Kingdom | ||
2020-07-13 | United Kingdom | Isle of Man | 336 | 24 | 312 | 0 | 54.2361 | -4.5481 | 2020-07-14 04:34:46 | Isle of Man, United Kingdom | ||
2020-07-13 | United Kingdom | Gibraltar | 180 | 0 | 179 | 1 | 36.1408 | -5.3536 | 2020-07-14 04:34:46 | Gibraltar, United Kingdom | ||
2020-07-13 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-07-14 04:34:46 | Falkland Islands (Malvinas), United Kingdom | ||
2020-07-13 | United Kingdom | England | 250007 | 49197 | 0 | 209762 | 52.3555 | -1.1743 | 2020-07-14 04:34:46 | England, United Kingdom | ||
2020-07-13 | United Kingdom | Channel Islands | 0 | 0 | 512 | 22 | 49.3723 | -2.3644 | 2020-07-14 04:34:46 | Channel Islands, United Kingdom | ||
2020-07-13 | United Kingdom | Cayman Islands | 203 | 1 | 200 | 2 | 19.3133 | -81.2546 | 2020-07-14 04:34:46 | Cayman Islands, United Kingdom | ||
2020-07-13 | United Kingdom | British Virgin Islands | 8 | 1 | 7 | 0 | 18.4207 | -64.64 | 2020-07-14 04:34:46 | British Virgin Islands, United Kingdom | ||
2020-07-13 | United Kingdom | Bermuda | 150 | 9 | 137 | 4 | 32.3078 | -64.7505 | 2020-07-14 04:34:46 | Bermuda, United Kingdom | ||
2020-07-13 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-14 04:34:46 | Anguilla, United Kingdom | ||
2020-07-13 | United Arab Emirates | 55198 | 334 | 45513 | 9351 | 23.424076 | 53.847818000000004 | 2020-07-14 04:34:46 | United Arab Emirates | |||
2020-07-13 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-07-14 04:34:46 | Unknown, Ukraine | ||||
2020-07-13 | Ukraine | Zhytomyr Oblast | 1542 | 34 | 1129 | 379 | 50.2547 | 28.6587 | 2020-07-14 04:34:46 | Zhytomyr Oblast, Ukraine | ||
2020-07-13 | Ukraine | Zaporizhia Oblast | 622 | 20 | 518 | 84 | 47.8388 | 35.1396 | 2020-07-14 04:34:46 | Zaporizhia Oblast, Ukraine | ||
2020-07-13 | Ukraine | Zakarpattia Oblast | 3988 | 139 | 1265 | 2584 | 48.6208 | 22.2879 | 2020-07-14 04:34:46 | Zakarpattia Oblast, Ukraine | ||
2020-07-13 | Ukraine | Volyn Oblast | 3071 | 72 | 1618 | 1381 | 50.7472 | 25.3254 | 2020-07-14 04:34:46 | Volyn Oblast, Ukraine | ||
2020-07-13 | Ukraine | Vinnytsia Oblast | 2122 | 38 | 1553 | 531 | 49.2331 | 28.4682 | 2020-07-14 04:34:46 | Vinnytsia Oblast, Ukraine | ||
2020-07-13 | Ukraine | Ternopil Oblast | 2260 | 34 | 1415 | 811 | 49.5535 | 25.5948 | 2020-07-14 04:34:46 | Ternopil Oblast, Ukraine | ||
2020-07-13 | Ukraine | Sumy Oblast | 341 | 6 | 295 | 40 | 50.9077 | 34.7981 | 2020-07-14 04:34:46 | Sumy Oblast, Ukraine | ||
2020-07-13 | Ukraine | Sevastopol* | 281 | 5 | 208 | 68 | 44.6054 | 33.522 | 2020-07-14 04:34:46 | Sevastopol*, Ukraine | ||
2020-07-13 | Ukraine | Rivne Oblast | 4697 | 80 | 2773 | 1844 | 50.6199 | 26.2516 | 2020-07-14 04:34:46 | Rivne Oblast, Ukraine | ||
2020-07-13 | Ukraine | Poltava Oblast | 334 | 13 | 297 | 24 | 49.5883 | 34.5514 | 2020-07-14 04:34:46 | Poltava Oblast, Ukraine | ||
2020-07-13 | Ukraine | Odessa Oblast | 2208 | 30 | 988 | 1190 | 46.4846 | 30.7326 | 2020-07-14 04:34:46 | Odessa Oblast, Ukraine | ||
2020-07-13 | Ukraine | Mykolaiv Oblast | 482 | 11 | 369 | 102 | 46.975 | 31.9946 | 2020-07-14 04:34:46 | Mykolaiv Oblast, Ukraine | ||
2020-07-13 | Ukraine | Lviv Oblast | 7107 | 186 | 1113 | 5808 | 49.8397 | 24.0297 | 2020-07-14 04:34:46 | Lviv Oblast, Ukraine | ||
2020-07-13 | Ukraine | Luhansk Oblast | 93 | 0 | 73 | 20 | 48.574 | 39.3078 | 2020-07-14 04:34:46 | Luhansk Oblast, Ukraine | ||
2020-07-13 | Ukraine | Kirovohrad Oblast | 674 | 33 | 585 | 56 | 48.5079 | 32.2623 | 2020-07-14 04:34:46 | Kirovohrad Oblast, Ukraine | ||
2020-07-13 | Ukraine | Kiev Oblast | 3068 | 58 | 1838 | 1172 | 50.053000000000004 | 30.7667 | 2020-07-14 04:34:46 | Kiev Oblast, Ukraine | ||
2020-07-13 | Ukraine | Kiev | 6238 | 124 | 2108 | 4006 | 50.4501 | 30.5234 | 2020-07-14 04:34:46 | Kiev, Ukraine | ||
2020-07-13 | Ukraine | Khmelnytskyi Oblast | 908 | 20 | 756 | 132 | 49.423 | 26.9871 | 2020-07-14 04:34:46 | Khmelnytskyi Oblast, Ukraine | ||
2020-07-13 | Ukraine | Kherson Oblast | 204 | 3 | 186 | 15 | 46.6354 | 32.6169 | 2020-07-14 04:34:46 | Kherson Oblast, Ukraine | ||
2020-07-13 | Ukraine | Kharkiv Oblast | 2677 | 109 | 1445 | 1123 | 49.9935 | 36.2304 | 2020-07-14 04:34:46 | Kharkiv Oblast, Ukraine | ||
2020-07-13 | Ukraine | Ivano-Frankivsk Oblast | 3071 | 109 | 1229 | 1733 | 48.9226 | 24.7111 | 2020-07-14 04:34:46 | Ivano-Frankivsk Oblast, Ukraine | ||
2020-07-13 | Ukraine | Donetsk Oblast | 759 | 10 | 249 | 500 | 48.0159 | 37.8028 | 2020-07-14 04:34:46 | Donetsk Oblast, Ukraine | ||
2020-07-13 | Ukraine | Dnipropetrovsk Oblast | 1144 | 23 | 1033 | 88 | 48.4647 | 35.0462 | 2020-07-14 04:34:46 | Dnipropetrovsk Oblast, Ukraine | ||
2020-07-13 | Ukraine | Crimea Republic* | 871 | 12 | 645 | 214 | 45.2835 | 34.2008 | 2020-07-14 04:34:46 | Crimea Republic*, Ukraine | ||
2020-07-13 | Ukraine | Chernivtsi Oblast | 5161 | 201 | 2792 | 2168 | 48.2917 | 25.9352 | 2020-07-14 04:34:46 | Chernivtsi Oblast, Ukraine | ||
2020-07-13 | Ukraine | Chernihiv Oblast | 608 | 14 | 282 | 312 | 51.4982 | 31.2893 | 2020-07-14 04:34:46 | Chernihiv Oblast, Ukraine | ||
2020-07-13 | Ukraine | Cherkasy Oblast | 754 | 31 | 594 | 129 | 49.4444 | 32.0598 | 2020-07-14 04:34:46 | Cherkasy Oblast, Ukraine | ||
2020-07-13 | Uganda | 1029 | 0 | 977 | 52 | 1.373333 | 32.290275 | 2020-07-14 04:34:46 | Uganda | |||
2020-07-13 | US | Alaska | Chugach | 2063 | 39 | 0 | 0 | 39 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
2020-07-13 | US | Alaska | Copper River | 2066 | 5 | 0 | 0 | 5 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2020-07-13 | US | Oregon | Wheeler | 41069 | 0 | 0 | 0 | 0 | 44.72698162 | -120.02814270000002 | 2020-07-06 19:33:59 | Wheeler, Oregon, US |
2020-07-13 | US | Idaho | Lewis | 16061 | 1 | 0 | 0 | 1 | 46.23315327 | -116.434146 | 2020-07-10 02:34:22 | Lewis, Idaho, US |
2020-07-13 | US | Arizona | Unassigned | 90004 | 0 | 1 | 0 | 0 | 35.83883429 | 0.0 | 2020-07-13 22:34:29 | Unassigned, Arizona, US |
2020-07-13 | US | Virgin Islands | 78 | 206 | 6 | 0 | 200 | 18.3358 | -64.8963 | 2020-07-14 04:34:46 | Virgin Islands, US | |
2020-07-13 | US | Recovered | 0 | 0 | 1031939 | 0 | 0.0 | 0.0 | 2020-07-14 04:34:46 | Recovered, US | ||
2020-07-13 | US | Puerto Rico | 72 | 10010 | 167 | 0 | 9843 | 18.2208 | -66.5901 | 2020-07-14 04:34:46 | Puerto Rico, US | |
2020-07-13 | US | Northern Mariana Islands | 69 | 33 | 2 | 0 | 31 | 15.0979 | 145.6739 | 2020-07-14 04:34:46 | Northern Mariana Islands, US | |
2020-07-13 | US | Guam | 66 | 312 | 5 | 0 | 307 | 13.4443 | 144.7937 | 2020-07-14 04:34:46 | Guam, US | |
2020-07-13 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-14 04:34:46 | Grand Princess, US | |
2020-07-13 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-07-14 04:34:46 | Diamond Princess, US | |
2020-07-13 | US | South Dakota | Ziebach | 46137 | 3 | 0 | 0 | 3 | 44.97881876 | -101.6654622 | 2020-07-14 04:34:46 | Ziebach, South Dakota, US |
2020-07-13 | US | Texas | Zavala | 48507 | 46 | 0 | 0 | 60 | 28.86617238 | -99.76050829 | 2020-07-14 04:34:46 | Zavala, Texas, US |
2020-07-13 | US | Texas | Zapata | 48505 | 89 | 0 | 0 | 81 | 27.00156391 | -99.16987152 | 2020-07-14 04:34:46 | Zapata, Texas, US |
2020-07-13 | US | Colorado | Yuma | 8125 | 57 | 0 | 0 | 54 | 40.00346839 | -102.4258673 | 2020-07-14 04:34:46 | Yuma, Colorado, US |
2020-07-13 | US | Arizona | Yuma | 4027 | 8384 | 154 | 0 | 8230 | 32.76895712 | -113.90666740000002 | 2020-07-14 04:34:46 | Yuma, Arizona, US |
2020-07-13 | US | Alaska | Yukon-Koyukuk | 2290 | 13 | 0 | 0 | 13 | 65.50815459 | -151.3907387 | 2020-07-14 04:34:46 | Yukon-Koyukuk, Alaska, US |
2020-07-13 | US | California | Yuba | 6115 | 194 | 1 | 0 | 193 | 39.26255932 | -121.3535644 | 2020-07-14 04:34:46 | Yuba, California, US |
2020-07-13 | US | Texas | Young | 48503 | 50 | 1 | 0 | 52 | 33.17659707 | -98.68790885 | 2020-07-14 04:34:46 | Young, Texas, US |
2020-07-13 | US | Virginia | York | 51199 | 168 | 3 | 0 | 165 | 37.24374789 | -76.54412815 | 2020-07-14 04:34:46 | York, Virginia, US |
2020-07-13 | US | South Carolina | York | 45091 | 1949 | 13 | 0 | 1936 | 34.97281497 | -81.18085944 | 2020-07-14 04:34:46 | York, South Carolina, US |
2020-07-13 | US | Pennsylvania | York | 42133 | 1865 | 63 | 0 | 1802 | 39.9210089 | -76.73040131 | 2020-07-14 04:34:46 | York, Pennsylvania, US |
2020-07-13 | US | Nebraska | York | 31185 | 52 | 0 | 0 | 52 | 40.87272618 | -97.59710186 | 2020-07-14 04:34:46 | York, Nebraska, US |
2020-07-13 | US | Maine | York | 23031 | 578 | 11 | 0 | 567 | 43.47808377 | -70.71052375 | 2020-07-14 04:34:46 | York, Maine, US |
2020-07-13 | US | California | Yolo | 6113 | 944 | 27 | 0 | 917 | 38.68278902 | -121.9018288 | 2020-07-14 04:34:46 | Yolo, California, US |
2020-07-13 | US | Texas | Yoakum | 48501 | 30 | 0 | 0 | 42 | 33.17320212 | -102.8276433 | 2020-07-14 04:34:46 | Yoakum, Texas, US |
2020-07-13 | US | Montana | Yellowstone | 30111 | 525 | 11 | 0 | 514 | 45.93955949 | -108.2691486 | 2020-07-14 04:34:46 | Yellowstone, Montana, US |
2020-07-13 | US | Minnesota | Yellow Medicine | 27173 | 31 | 0 | 0 | 31 | 44.71710183 | -95.86842453 | 2020-07-14 04:34:46 | Yellow Medicine, Minnesota, US |
2020-07-13 | US | Arkansas | Yell | 5149 | 838 | 5 | 0 | 833 | 35.00292371 | -93.41171338 | 2020-07-14 04:34:46 | Yell, Arkansas, US |
2020-07-13 | US | Mississippi | Yazoo | 28163 | 566 | 7 | 0 | 559 | 32.77890365 | -90.39656148 | 2020-07-14 04:34:46 | Yazoo, Mississippi, US |
2020-07-13 | US | Arizona | Yavapai | 4025 | 1156 | 15 | 0 | 1141 | 34.59933926 | -112.5538588 | 2020-07-14 04:34:46 | Yavapai, Arizona, US |
2020-07-13 | US | New York | Yates | 36123 | 48 | 6 | 0 | 42 | 42.63505484 | -77.10369919 | 2020-07-14 04:34:46 | Yates, New York, US |
2020-07-13 | US | South Dakota | Yankton | 46135 | 85 | 2 | 0 | 83 | 43.00924485 | -97.39467635 | 2020-07-14 04:34:46 | Yankton, South Dakota, US |
2020-07-13 | US | North Carolina | Yancey | 37199 | 60 | 0 | 0 | 60 | 35.90079156 | -82.31237181 | 2020-07-14 04:34:46 | Yancey, North Carolina, US |
2020-07-13 | US | Oregon | Yamhill | 41071 | 205 | 9 | 0 | 196 | 45.23330449 | -123.3086963 | 2020-07-14 04:34:46 | Yamhill, Oregon, US |
2020-07-13 | US | Mississippi | Yalobusha | 28161 | 208 | 9 | 0 | 199 | 34.02824175 | -89.70762049999998 | 2020-07-14 04:34:46 | Yalobusha, Mississippi, US |
2020-07-13 | US | Washington | Yakima | 53077 | 8375 | 190 | 0 | 8185 | 46.45738486 | -120.7380126 | 2020-07-14 04:34:46 | Yakima, Washington, US |
2020-07-13 | US | North Carolina | Yadkin | 37197 | 385 | 5 | 0 | 380 | 36.16222629 | -80.66239436 | 2020-07-14 04:34:46 | Yadkin, North Carolina, US |
2020-07-13 | US | Virginia | Wythe | 51197 | 59 | 1 | 0 | 58 | 36.91582035 | -81.07834059 | 2020-07-14 04:34:46 | Wythe, Virginia, US |
2020-07-13 | US | West Virginia | Wyoming | 54109 | 7 | 0 | 0 | 7 | 37.612327 | -81.54511071 | 2020-07-14 04:34:46 | Wyoming, West Virginia, US |
2020-07-13 | US | Pennsylvania | Wyoming | 42131 | 47 | 7 | 0 | 40 | 41.51955538 | -76.01074915 | 2020-07-14 04:34:46 | Wyoming, Pennsylvania, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;