daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,847 rows where "day" is on date 2020-07-10 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-10 | Zimbabwe | 942 | 13 | 320 | 609 | -19.015438 | 29.154857 | 2020-07-11 04:34:26 | Zimbabwe | |||
2020-07-10 | Zambia | 1895 | 42 | 1348 | 505 | -13.133897 | 27.849332 | 2020-07-11 04:34:26 | Zambia | |||
2020-07-10 | Yemen | 1380 | 364 | 630 | 386 | 15.552726999999999 | 48.516388 | 2020-07-11 04:34:26 | Yemen | |||
2020-07-10 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-07-11 04:34:26 | Winter Olympics 2022 | |||
2020-07-10 | West Bank and Gaza | 5551 | 27 | 536 | 4988 | 31.9522 | 35.2332 | 2020-07-11 04:34:26 | West Bank and Gaza | |||
2020-07-10 | Vietnam | 370 | 0 | 350 | 20 | 14.058323999999999 | 108.277199 | 2020-07-11 04:34:26 | Vietnam | |||
2020-07-10 | Venezuela | 8803 | 83 | 2671 | 6049 | 6.4238 | -66.5897 | 2020-07-11 04:34:26 | Venezuela | |||
2020-07-10 | Uzbekistan | 12027 | 54 | 7530 | 4443 | 41.377491 | 64.585262 | 2020-07-11 04:34:26 | Uzbekistan | |||
2020-07-10 | Uruguay | 985 | 29 | 886 | 70 | -32.5228 | -55.7658 | 2020-07-11 04:34:26 | Uruguay | |||
2020-07-10 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-07-11 04:34:26 | Pitcairn Islands, United Kingdom | ||
2020-07-10 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-11 04:34:26 | Guernsey, United Kingdom | ||
2020-07-10 | United Kingdom | Jersey | 321 | 31 | 0 | 0 | 49.2138 | -2.1358 | 2020-07-11 04:34:26 | Jersey, United Kingdom | ||
2020-07-10 | United Kingdom | Wales | 15939 | 2514 | 0 | 14399 | 52.1307 | -3.7837 | 2020-07-11 04:34:26 | Wales, United Kingdom | ||
2020-07-10 | United Kingdom | Unknown | 0 | 72 | 0 | 0 | 55.3781 | -3.436 | 2020-07-11 04:34:26 | Unknown, United Kingdom | ||
2020-07-10 | United Kingdom | Turks and Caicos Islands | 66 | 2 | 11 | 53 | 21.69400000000001 | -71.7979 | 2020-07-11 04:34:26 | Turks and Caicos Islands, United Kingdom | ||
2020-07-10 | United Kingdom | Scotland | 18333 | 4190 | 0 | 15843 | 56.4907 | -4.2026 | 2020-07-11 04:34:26 | Scotland, United Kingdom | ||
2020-07-10 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 0 | 0 | 0 | 0 | -7.9467 | -14.3559 | 2020-07-11 04:34:26 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2020-07-10 | United Kingdom | Northern Ireland | 5772 | 846 | 0 | 5218 | 54.7877 | -6.4923 | 2020-07-11 04:34:26 | Northern Ireland, United Kingdom | ||
2020-07-10 | United Kingdom | Montserrat | 11 | 1 | 10 | 0 | 16.742498 | -62.187366000000004 | 2020-07-11 04:34:26 | Montserrat, United Kingdom | ||
2020-07-10 | United Kingdom | Isle of Man | 336 | 24 | 312 | 0 | 54.2361 | -4.5481 | 2020-07-11 04:34:26 | Isle of Man, United Kingdom | ||
2020-07-10 | United Kingdom | Gibraltar | 180 | 0 | 176 | 4 | 36.1408 | -5.3536 | 2020-07-11 04:34:26 | Gibraltar, United Kingdom | ||
2020-07-10 | United Kingdom | Falkland Islands (Malvinas) | 13 | 0 | 13 | 0 | -51.7963 | -59.5236 | 2020-07-11 04:34:26 | Falkland Islands (Malvinas), United Kingdom | ||
2020-07-10 | United Kingdom | England | 248089 | 49093 | 0 | 208023 | 52.3555 | -1.1743 | 2020-07-11 04:34:26 | England, United Kingdom | ||
2020-07-10 | United Kingdom | Channel Islands | 0 | 0 | 512 | 18 | 49.3723 | -2.3644 | 2020-07-11 04:34:26 | Channel Islands, United Kingdom | ||
2020-07-10 | United Kingdom | Cayman Islands | 201 | 1 | 197 | 3 | 19.3133 | -81.2546 | 2020-07-11 04:34:26 | Cayman Islands, United Kingdom | ||
2020-07-10 | United Kingdom | British Virgin Islands | 8 | 1 | 7 | 0 | 18.4207 | -64.64 | 2020-07-11 04:34:26 | British Virgin Islands, United Kingdom | ||
2020-07-10 | United Kingdom | Bermuda | 150 | 9 | 137 | 4 | 32.3078 | -64.7505 | 2020-07-11 04:34:26 | Bermuda, United Kingdom | ||
2020-07-10 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-11 04:34:26 | Anguilla, United Kingdom | ||
2020-07-10 | United Arab Emirates | 54050 | 330 | 43969 | 9751 | 23.424076 | 53.847818000000004 | 2020-07-11 04:34:26 | United Arab Emirates | |||
2020-07-10 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-07-11 04:34:26 | Unknown, Ukraine | ||||
2020-07-10 | Ukraine | Zhytomyr Oblast | 1512 | 33 | 1106 | 373 | 50.2547 | 28.6587 | 2020-07-11 04:34:26 | Zhytomyr Oblast, Ukraine | ||
2020-07-10 | Ukraine | Zaporizhia Oblast | 610 | 19 | 493 | 98 | 47.8388 | 35.1396 | 2020-07-11 04:34:26 | Zaporizhia Oblast, Ukraine | ||
2020-07-10 | Ukraine | Zakarpattia Oblast | 3734 | 132 | 1179 | 2423 | 48.6208 | 22.2879 | 2020-07-11 04:34:26 | Zakarpattia Oblast, Ukraine | ||
2020-07-10 | Ukraine | Volyn Oblast | 2932 | 71 | 1406 | 1455 | 50.7472 | 25.3254 | 2020-07-11 04:34:26 | Volyn Oblast, Ukraine | ||
2020-07-10 | Ukraine | Vinnytsia Oblast | 2060 | 34 | 1485 | 541 | 49.2331 | 28.4682 | 2020-07-11 04:34:26 | Vinnytsia Oblast, Ukraine | ||
2020-07-10 | Ukraine | Ternopil Oblast | 2174 | 32 | 1353 | 789 | 49.5535 | 25.5948 | 2020-07-11 04:34:26 | Ternopil Oblast, Ukraine | ||
2020-07-10 | Ukraine | Sumy Oblast | 332 | 5 | 275 | 52 | 50.9077 | 34.7981 | 2020-07-11 04:34:26 | Sumy Oblast, Ukraine | ||
2020-07-10 | Ukraine | Sevastopol* | 258 | 5 | 198 | 55 | 44.6054 | 33.522 | 2020-07-11 04:34:26 | Sevastopol*, Ukraine | ||
2020-07-10 | Ukraine | Rivne Oblast | 4454 | 79 | 2501 | 1874 | 50.6199 | 26.2516 | 2020-07-11 04:34:26 | Rivne Oblast, Ukraine | ||
2020-07-10 | Ukraine | Poltava Oblast | 330 | 13 | 290 | 27 | 49.5883 | 34.5514 | 2020-07-11 04:34:26 | Poltava Oblast, Ukraine | ||
2020-07-10 | Ukraine | Odessa Oblast | 2108 | 27 | 903 | 1178 | 46.4846 | 30.7326 | 2020-07-11 04:34:26 | Odessa Oblast, Ukraine | ||
2020-07-10 | Ukraine | Mykolaiv Oblast | 467 | 11 | 356 | 100 | 46.975 | 31.9946 | 2020-07-11 04:34:26 | Mykolaiv Oblast, Ukraine | ||
2020-07-10 | Ukraine | Lviv Oblast | 6763 | 178 | 1003 | 5582 | 49.8397 | 24.0297 | 2020-07-11 04:34:26 | Lviv Oblast, Ukraine | ||
2020-07-10 | Ukraine | Luhansk Oblast | 90 | 0 | 73 | 17 | 48.574 | 39.3078 | 2020-07-11 04:34:26 | Luhansk Oblast, Ukraine | ||
2020-07-10 | Ukraine | Kirovohrad Oblast | 670 | 33 | 582 | 55 | 48.5079 | 32.2623 | 2020-07-11 04:34:26 | Kirovohrad Oblast, Ukraine | ||
2020-07-10 | Ukraine | Kiev Oblast | 2940 | 55 | 1720 | 1165 | 50.053000000000004 | 30.7667 | 2020-07-11 04:34:26 | Kiev Oblast, Ukraine | ||
2020-07-10 | Ukraine | Kiev | 5990 | 122 | 2033 | 3835 | 50.4501 | 30.5234 | 2020-07-11 04:34:26 | Kiev, Ukraine | ||
2020-07-10 | Ukraine | Khmelnytskyi Oblast | 881 | 20 | 638 | 223 | 49.423 | 26.9871 | 2020-07-11 04:34:26 | Khmelnytskyi Oblast, Ukraine | ||
2020-07-10 | Ukraine | Kherson Oblast | 203 | 3 | 184 | 16 | 46.6354 | 32.6169 | 2020-07-11 04:34:26 | Kherson Oblast, Ukraine | ||
2020-07-10 | Ukraine | Kharkiv Oblast | 2577 | 102 | 1321 | 1154 | 49.9935 | 36.2304 | 2020-07-11 04:34:26 | Kharkiv Oblast, Ukraine | ||
2020-07-10 | Ukraine | Ivano-Frankivsk Oblast | 2915 | 107 | 1228 | 1580 | 48.9226 | 24.7111 | 2020-07-11 04:34:26 | Ivano-Frankivsk Oblast, Ukraine | ||
2020-07-10 | Ukraine | Donetsk Oblast | 751 | 10 | 235 | 506 | 48.0159 | 37.8028 | 2020-07-11 04:34:26 | Donetsk Oblast, Ukraine | ||
2020-07-10 | Ukraine | Dnipropetrovsk Oblast | 1137 | 23 | 1015 | 99 | 48.4647 | 35.0462 | 2020-07-11 04:34:26 | Dnipropetrovsk Oblast, Ukraine | ||
2020-07-10 | Ukraine | Crimea Republic* | 815 | 12 | 636 | 167 | 45.2835 | 34.2008 | 2020-07-11 04:34:26 | Crimea Republic*, Ukraine | ||
2020-07-10 | Ukraine | Chernivtsi Oblast | 5096 | 194 | 2582 | 2320 | 48.2917 | 25.9352 | 2020-07-11 04:34:26 | Chernivtsi Oblast, Ukraine | ||
2020-07-10 | Ukraine | Chernihiv Oblast | 592 | 14 | 261 | 317 | 51.4982 | 31.2893 | 2020-07-11 04:34:26 | Chernihiv Oblast, Ukraine | ||
2020-07-10 | Ukraine | Cherkasy Oblast | 725 | 28 | 578 | 119 | 49.4444 | 32.0598 | 2020-07-11 04:34:26 | Cherkasy Oblast, Ukraine | ||
2020-07-10 | Uganda | 1006 | 0 | 938 | 68 | 1.373333 | 32.290275 | 2020-07-11 04:34:26 | Uganda | |||
2020-07-10 | US | Alaska | Chugach | 2063 | 24 | 0 | 0 | 24 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
2020-07-10 | US | Alaska | Copper River | 2066 | 3 | 0 | 0 | 3 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2020-07-10 | US | Oregon | Wheeler | 41069 | 0 | 0 | 0 | 0 | 44.72698162 | -120.02814270000002 | 2020-07-06 19:33:59 | Wheeler, Oregon, US |
2020-07-10 | US | Idaho | Lewis | 16061 | 1 | 0 | 0 | 1 | 46.23315327 | -116.434146 | 2020-07-10 02:34:22 | Lewis, Idaho, US |
2020-07-10 | US | Virgin Islands | 78 | 153 | 6 | 0 | 147 | 18.3358 | -64.8963 | 2020-07-11 04:34:26 | Virgin Islands, US | |
2020-07-10 | US | Recovered | 0 | 0 | 983185 | 0 | 0.0 | 0.0 | 2020-07-11 04:34:26 | Recovered, US | ||
2020-07-10 | US | Puerto Rico | 72 | 9137 | 159 | 0 | 8978 | 18.2208 | -66.5901 | 2020-07-11 04:34:26 | Puerto Rico, US | |
2020-07-10 | US | Northern Mariana Islands | 69 | 31 | 2 | 0 | 29 | 15.0979 | 145.6739 | 2020-07-11 04:34:26 | Northern Mariana Islands, US | |
2020-07-10 | US | Guam | 66 | 310 | 5 | 0 | 305 | 13.4443 | 144.7937 | 2020-07-11 04:34:26 | Guam, US | |
2020-07-10 | US | Grand Princess | 99999 | 103 | 3 | 0 | 100 | 37.64894 | 0.0 | 2020-07-11 04:34:26 | Grand Princess, US | |
2020-07-10 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 49 | 35.4437 | 139.638 | 2020-07-11 04:34:26 | Diamond Princess, US | |
2020-07-10 | US | South Dakota | Ziebach | 46137 | 3 | 0 | 0 | 3 | 44.97881876 | -101.6654622 | 2020-07-11 04:34:26 | Ziebach, South Dakota, US |
2020-07-10 | US | Texas | Zavala | 48507 | 37 | 0 | 0 | 46 | 28.86617238 | -99.76050829 | 2020-07-11 04:34:26 | Zavala, Texas, US |
2020-07-10 | US | Texas | Zapata | 48505 | 65 | 0 | 0 | 66 | 27.00156391 | -99.16987152 | 2020-07-11 04:34:26 | Zapata, Texas, US |
2020-07-10 | US | Colorado | Yuma | 8125 | 56 | 0 | 0 | 54 | 40.00346839 | -102.4258673 | 2020-07-11 04:34:26 | Yuma, Colorado, US |
2020-07-10 | US | Arizona | Yuma | 4027 | 7994 | 128 | 0 | 7866 | 32.76895712 | -113.90666740000002 | 2020-07-11 04:34:26 | Yuma, Arizona, US |
2020-07-10 | US | Alaska | Yukon-Koyukuk | 2290 | 5 | 0 | 0 | 5 | 65.50815459 | -151.39073869999999 | 2020-07-11 04:34:26 | Yukon-Koyukuk, Alaska, US |
2020-07-10 | US | California | Yuba | 6115 | 164 | 1 | 0 | 163 | 39.26255932 | -121.35356440000001 | 2020-07-11 04:34:26 | Yuba, California, US |
2020-07-10 | US | Texas | Young | 48503 | 41 | 1 | 0 | 45 | 33.17659707 | -98.68790885 | 2020-07-11 04:34:26 | Young, Texas, US |
2020-07-10 | US | Virginia | York | 51199 | 144 | 3 | 0 | 141 | 37.24374789 | -76.54412815 | 2020-07-11 04:34:26 | York, Virginia, US |
2020-07-10 | US | South Carolina | York | 45091 | 1760 | 12 | 0 | 1748 | 34.97281497 | -81.18085944 | 2020-07-11 04:34:26 | York, South Carolina, US |
2020-07-10 | US | Pennsylvania | York | 42133 | 1798 | 61 | 0 | 1737 | 39.9210089 | -76.73040131 | 2020-07-11 04:34:26 | York, Pennsylvania, US |
2020-07-10 | US | Nebraska | York | 31185 | 49 | 0 | 0 | 49 | 40.87272618 | -97.59710186 | 2020-07-11 04:34:26 | York, Nebraska, US |
2020-07-10 | US | Maine | York | 23031 | 563 | 11 | 0 | 552 | 43.47808377 | -70.71052375 | 2020-07-11 04:34:26 | York, Maine, US |
2020-07-10 | US | California | Yolo | 6113 | 797 | 27 | 0 | 770 | 38.68278902 | -121.90182879999999 | 2020-07-11 04:34:26 | Yolo, California, US |
2020-07-10 | US | Texas | Yoakum | 48501 | 30 | 0 | 0 | 40 | 33.17320212 | -102.82764329999999 | 2020-07-11 04:34:26 | Yoakum, Texas, US |
2020-07-10 | US | Montana | Yellowstone | 30111 | 431 | 9 | 0 | 422 | 45.93955949 | -108.26914860000001 | 2020-07-11 04:34:26 | Yellowstone, Montana, US |
2020-07-10 | US | Minnesota | Yellow Medicine | 27173 | 31 | 0 | 0 | 31 | 44.71710183 | -95.86842453 | 2020-07-11 04:34:26 | Yellow Medicine, Minnesota, US |
2020-07-10 | US | Arkansas | Yell | 5149 | 822 | 5 | 0 | 817 | 35.00292371 | -93.41171338 | 2020-07-11 04:34:26 | Yell, Arkansas, US |
2020-07-10 | US | Mississippi | Yazoo | 28163 | 548 | 6 | 0 | 542 | 32.77890365 | -90.39656148 | 2020-07-11 04:34:26 | Yazoo, Mississippi, US |
2020-07-10 | US | Arizona | Yavapai | 4025 | 1058 | 11 | 0 | 1047 | 34.59933926 | -112.5538588 | 2020-07-11 04:34:26 | Yavapai, Arizona, US |
2020-07-10 | US | New York | Yates | 36123 | 48 | 6 | 0 | 42 | 42.63505484 | -77.10369919 | 2020-07-11 04:34:26 | Yates, New York, US |
2020-07-10 | US | South Dakota | Yankton | 46135 | 84 | 1 | 0 | 83 | 43.00924485 | -97.39467635 | 2020-07-11 04:34:26 | Yankton, South Dakota, US |
2020-07-10 | US | North Carolina | Yancey | 37199 | 59 | 0 | 0 | 59 | 35.90079156 | -82.31237181 | 2020-07-11 04:34:26 | Yancey, North Carolina, US |
2020-07-10 | US | Oregon | Yamhill | 41071 | 179 | 9 | 0 | 170 | 45.23330449 | -123.3086963 | 2020-07-11 04:34:26 | Yamhill, Oregon, US |
2020-07-10 | US | Mississippi | Yalobusha | 28161 | 202 | 8 | 0 | 194 | 34.02824175 | -89.70762049999998 | 2020-07-11 04:34:26 | Yalobusha, Mississippi, US |
2020-07-10 | US | Washington | Yakima | 53077 | 8049 | 181 | 0 | 7868 | 46.45738486 | -120.73801259999999 | 2020-07-11 04:34:26 | Yakima, Washington, US |
2020-07-10 | US | North Carolina | Yadkin | 37197 | 376 | 5 | 0 | 371 | 36.16222629 | -80.66239436 | 2020-07-11 04:34:26 | Yadkin, North Carolina, US |
2020-07-10 | US | Virginia | Wythe | 51197 | 57 | 1 | 0 | 56 | 36.91582035 | -81.07834059 | 2020-07-11 04:34:26 | Wythe, Virginia, US |
2020-07-10 | US | West Virginia | Wyoming | 54109 | 7 | 0 | 0 | 7 | 37.612327 | -81.54511071 | 2020-07-11 04:34:26 | Wyoming, West Virginia, US |
2020-07-10 | US | Pennsylvania | Wyoming | 42131 | 41 | 7 | 0 | 34 | 41.51955538 | -76.01074915 | 2020-07-11 04:34:26 | Wyoming, Pennsylvania, US |
2020-07-10 | US | New York | Wyoming | 36121 | 101 | 5 | 0 | 96 | 42.70145109 | -78.22199579 | 2020-07-11 04:34:26 | Wyoming, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;