daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
319 rows where active = 776 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-09-03 | Malaysia | Perlis | 2157 | 28 | 1353 | 776 | 6.4449 | 100.2048 | 2021-09-04 04:21:28 | Perlis, Malaysia | ||
2021-07-22 | Russia | Jewish Autonomous Okrug | 5385 | 170 | 4439 | 776 | 48.57527615 | 132.66307460000002 | 2021-07-23 04:21:29 | Jewish Autonomous Okrug, Russia | ||
2021-06-25 | Pakistan | Balochistan | 26932 | 305 | 25851 | 776 | 28.328492 | 65.898403 | 2021-06-26 04:21:43 | Balochistan, Pakistan | ||
2021-06-23 | Russia | Kursk Oblast | 39999 | 904 | 38319 | 776 | 51.6568453 | 36.4852695 | 2021-06-24 04:21:55 | Kursk Oblast, Russia | ||
2021-06-11 | Ukraine | Mykolaiv Oblast | 69352 | 1820 | 66756 | 776 | 46.975 | 31.9946 | 2021-06-12 04:22:22 | Mykolaiv Oblast, Ukraine | ||
2021-06-02 | Russia | Kursk Oblast | 38571 | 822 | 36973 | 776 | 51.6568453 | 36.4852695 | 2021-06-03 04:23:32 | Kursk Oblast, Russia | ||
2021-05-31 | Russia | Smolensk Oblast | 31080 | 1025 | 29279 | 776 | 55.03434960000001 | 33.0192065 | 2021-06-01 04:23:09 | Smolensk Oblast, Russia | ||
2021-05-29 | Russia | Kursk Oblast | 38321 | 809 | 36736 | 776 | 51.6568453 | 36.4852695 | 2021-05-30 04:20:55 | Kursk Oblast, Russia | ||
2021-05-21 | Russia | Kaliningrad Oblast | 33015 | 468 | 31771 | 776 | 54.7293041 | 21.1489473 | 2021-05-22 04:20:45 | Kaliningrad Oblast, Russia | ||
2021-05-18 | Colombia | Meta | 49305 | 1165 | 47364 | 776 | 3.272 | -73.0877 | 2021-05-19 04:20:42 | Meta, Colombia | ||
2021-05-18 | Colombia | La Guajira | 33724 | 1084 | 31864 | 776 | 11.3548 | -72.5205 | 2021-05-19 04:20:42 | La Guajira, Colombia | ||
2021-05-13 | Russia | Yamalo-Nenets Autonomous Okrug | 38768 | 416 | 37576 | 776 | 67.1471631 | 74.3415488 | 2021-05-14 04:20:41 | Yamalo-Nenets Autonomous Okrug, Russia | ||
2021-05-08 | Russia | Zabaykalsky Krai | 42521 | 639 | 41106 | 776 | 52.248521 | 115.956325 | 2021-05-09 04:20:35 | Zabaykalsky Krai, Russia | ||
2021-05-05 | Colombia | La Guajira | 31094 | 964 | 29354 | 776 | 11.3548 | -72.5205 | 2021-05-06 04:20:38 | La Guajira, Colombia | ||
2021-04-17 | Russia | Chuvashia Republic | 23535 | 1310 | 21449 | 776 | 55.4259922 | 47.0849429 | 2021-04-18 04:20:41 | Chuvashia Republic, Russia | ||
2021-04-05 | Russia | North Ossetia - Alania Republic | 16418 | 166 | 15476 | 776 | 42.79336110000001 | 44.6324493 | 2021-04-06 04:20:32 | North Ossetia - Alania Republic, Russia | ||
2021-04-04 | Russia | North Ossetia - Alania Republic | 16401 | 165 | 15460 | 776 | 42.79336110000001 | 44.6324493 | 2021-04-05 04:20:35 | North Ossetia - Alania Republic, Russia | ||
2021-03-05 | US | South Dakota | Spink | 46115 | 801 | 25 | 0 | 776 | 44.93837606 | -98.34626602 | 2021-03-06 04:23:41 | Spink, South Dakota, US |
2021-03-05 | US | Nebraska | Holt | 31089 | 791 | 15 | 0 | 776 | 42.45522056 | -98.78402558 | 2021-03-06 04:23:41 | Holt, Nebraska, US |
2021-03-05 | US | Illinois | Hamilton | 17065 | 791 | 15 | 0 | 776 | 38.08163641 | -88.53883373 | 2021-03-06 04:23:41 | Hamilton, Illinois, US |
2021-03-04 | US | Illinois | Hamilton | 17065 | 791 | 15 | 0 | 776 | 38.08163641 | -88.53883373 | 2021-03-05 05:26:29 | Hamilton, Illinois, US |
2021-03-03 | US | Texas | Bailey | 48017 | 879 | 17 | 0 | 776 | 34.06854817 | -102.8299707 | 2021-03-04 05:24:24 | Bailey, Texas, US |
2021-03-03 | US | Tennessee | Van Buren | 47175 | 807 | 20 | 0 | 776 | 35.69864497 | -85.45221699 | 2021-03-04 05:24:24 | Van Buren, Tennessee, US |
2021-03-03 | US | Nebraska | Holt | 31089 | 791 | 15 | 0 | 776 | 42.45522056 | -98.78402558 | 2021-03-04 05:24:24 | Holt, Nebraska, US |
2021-03-03 | US | Illinois | Hamilton | 17065 | 791 | 15 | 0 | 776 | 38.08163641 | -88.53883373 | 2021-03-04 05:24:24 | Hamilton, Illinois, US |
2021-03-02 | US | West Virginia | Braxton | 54007 | 777 | 1 | 0 | 776 | 38.70036159 | -80.72011184 | 2021-03-03 05:23:28 | Braxton, West Virginia, US |
2021-03-02 | US | Oklahoma | Kiowa | 40075 | 792 | 16 | 0 | 776 | 34.91671958 | -98.97720696 | 2021-03-03 05:23:28 | Kiowa, Oklahoma, US |
2021-03-01 | US | West Virginia | Braxton | 54007 | 777 | 1 | 0 | 776 | 38.70036159 | -80.72011184 | 2021-03-02 05:23:30 | Braxton, West Virginia, US |
2021-03-01 | US | Texas | Bailey | 48017 | 879 | 17 | 0 | 776 | 34.06854817 | -102.8299707 | 2021-03-02 05:23:30 | Bailey, Texas, US |
2021-03-01 | US | Iowa | Ida | 19093 | 808 | 32 | 0 | 776 | 42.38696136 | -95.51355387 | 2021-03-02 05:23:30 | Ida, Iowa, US |
2021-02-28 | US | Texas | Bailey | 48017 | 879 | 17 | 0 | 776 | 34.06854817 | -102.8299707 | 2021-03-01 05:23:01 | Bailey, Texas, US |
2021-02-27 | US | Texas | Bailey | 48017 | 879 | 17 | 0 | 776 | 34.06854817 | -102.8299707 | 2021-02-28 05:22:20 | Bailey, Texas, US |
2021-02-24 | US | Kentucky | Leslie | 21131 | 778 | 2 | 0 | 776 | 37.09246661 | -83.37999606 | 2021-02-25 05:24:57 | Leslie, Kentucky, US |
2021-02-18 | US | West Virginia | Pleasants | 54073 | 793 | 17 | 0 | 776 | 39.37091679 | -81.16771771 | 2021-02-19 05:24:16 | Pleasants, West Virginia, US |
2021-02-17 | US | Oklahoma | Latimer | 40077 | 784 | 8 | 0 | 776 | 34.87844729 | -95.25215049 | 2021-02-18 05:22:58 | Latimer, Oklahoma, US |
2021-02-16 | US | South Carolina | Allendale | 45005 | 790 | 14 | 0 | 776 | 32.98837386 | -81.35321066 | 2021-02-17 05:23:10 | Allendale, South Carolina, US |
2021-02-16 | US | Oklahoma | Latimer | 40077 | 784 | 8 | 0 | 776 | 34.87844729 | -95.25215049 | 2021-02-17 05:23:10 | Latimer, Oklahoma, US |
2021-02-15 | US | Oklahoma | Latimer | 40077 | 784 | 8 | 0 | 776 | 34.87844729 | -95.25215049 | 2021-02-16 05:24:38 | Latimer, Oklahoma, US |
2021-02-11 | US | Puerto Rico | Loiza | 72087 | 776 | 0 | 0 | 776 | 18.425688 | -65.89943000000001 | 2021-02-12 05:23:29 | Loiza, Puerto Rico, US |
2021-02-10 | US | Puerto Rico | Loiza | 72087 | 776 | 0 | 0 | 776 | 18.425688 | -65.89943000000001 | 2021-02-11 05:23:55 | Loiza, Puerto Rico, US |
2021-02-09 | US | Puerto Rico | Loiza | 72087 | 776 | 0 | 0 | 776 | 18.425688 | -65.89943000000001 | 2021-02-10 05:22:41 | Loiza, Puerto Rico, US |
2021-02-08 | US | Virginia | Buena Vista | 51530 | 788 | 12 | 0 | 776 | 37.73484642 | -79.35296097 | 2021-02-09 05:23:30 | Buena Vista, Virginia, US |
2021-02-08 | US | Puerto Rico | Loiza | 72087 | 776 | 0 | 0 | 776 | 18.425688 | -65.89943000000001 | 2021-02-09 05:23:30 | Loiza, Puerto Rico, US |
2021-02-04 | US | Missouri | Dallas | 29059 | 798 | 22 | 0 | 776 | 37.6811355 | -93.02127031 | 2021-02-05 05:22:38 | Dallas, Missouri, US |
2021-02-04 | US | Maine | Hancock | 23009 | 807 | 31 | 0 | 776 | 44.59816444 | -68.38401854 | 2021-02-05 05:22:38 | Hancock, Maine, US |
2021-02-04 | US | Georgia | Hancock | 13141 | 830 | 54 | 0 | 776 | 33.2721566 | -82.99766919 | 2021-02-05 05:22:38 | Hancock, Georgia, US |
2021-02-02 | US | Puerto Rico | Barranquitas | 72019 | 776 | 0 | 0 | 776 | 18.201592 | -66.30963 | 2021-02-03 05:22:52 | Barranquitas, Puerto Rico, US |
2021-02-02 | US | Maine | Franklin | 23007 | 784 | 8 | 0 | 776 | 44.97330019 | -70.44381045 | 2021-02-03 05:22:52 | Franklin, Maine, US |
2021-02-02 | Chad | 3404 | 121 | 2507 | 776 | 15.4542 | 18.7322 | 2021-02-03 05:22:52 | Chad | |||
2021-02-01 | US | Iowa | Pocahontas | 19151 | 793 | 17 | 0 | 776 | 42.73420133 | -94.67862564 | 2021-02-02 05:22:49 | Pocahontas, Iowa, US |
2021-02-01 | US | Arkansas | Prairie | 5117 | 797 | 21 | 0 | 776 | 34.83624419 | -91.55162157 | 2021-02-02 05:22:49 | Prairie, Arkansas, US |
2021-01-31 | US | Kansas | Russell | 20167 | 798 | 22 | 0 | 776 | 38.91462787 | -98.76254297 | 2021-02-01 05:22:53 | Russell, Kansas, US |
2021-01-30 | US | Kansas | Russell | 20167 | 798 | 22 | 0 | 776 | 38.91462787 | -98.76254297 | 2021-01-31 05:22:42 | Russell, Kansas, US |
2021-01-29 | US | Kansas | Russell | 20167 | 798 | 22 | 0 | 776 | 38.91462787 | -98.76254297 | 2021-01-30 05:22:49 | Russell, Kansas, US |
2021-01-28 | US | Vermont | Windham | 50025 | 786 | 10 | 0 | 776 | 42.986982 | -72.71268875 | 2021-01-29 05:22:23 | Windham, Vermont, US |
2021-01-25 | US | Missouri | Dent | 29065 | 786 | 10 | 0 | 776 | 37.60663134 | -91.50790473 | 2021-01-26 05:22:02 | Dent, Missouri, US |
2021-01-25 | US | Iowa | Pocahontas | 19151 | 787 | 11 | 0 | 776 | 42.73420133 | -94.67862564 | 2021-01-26 05:22:02 | Pocahontas, Iowa, US |
2021-01-25 | US | Georgia | Wilkinson | 13319 | 797 | 21 | 0 | 776 | 32.80291082 | -83.17140684 | 2021-01-26 05:22:02 | Wilkinson, Georgia, US |
2021-01-21 | US | Puerto Rico | Camuy | 72027 | 776 | 0 | 0 | 776 | 18.418578 | -66.860206 | 2021-01-22 05:22:10 | Camuy, Puerto Rico, US |
2021-01-21 | US | Missouri | Gasconade | 29073 | 808 | 32 | 0 | 776 | 38.43947277 | -91.50847147 | 2021-01-22 05:22:10 | Gasconade, Missouri, US |
2021-01-20 | US | Georgia | Clinch | 13065 | 792 | 16 | 0 | 776 | 30.91395822 | -82.70432472 | 2021-01-21 05:22:01 | Clinch, Georgia, US |
2021-01-20 | US | Arkansas | Marion | 5089 | 803 | 27 | 0 | 776 | 36.26844485 | -92.68451899 | 2021-01-21 05:22:01 | Marion, Arkansas, US |
2021-01-19 | US | Kentucky | Martin | 21159 | 786 | 10 | 0 | 776 | 37.79990579 | -82.51247478 | 2021-01-20 05:21:54 | Martin, Kentucky, US |
2021-01-18 | Malaysia | Perak | 4479 | 20 | 3683 | 776 | 4.5921 | 101.0901 | 2021-01-19 05:22:15 | Perak, Malaysia | ||
2021-01-18 | US | Texas | Llano | 48299 | 975 | 29 | 0 | 776 | 30.70645047 | -98.68475262 | 2021-01-19 05:22:15 | Llano, Texas, US |
2021-01-18 | US | Kentucky | Magoffin | 21153 | 777 | 1 | 0 | 776 | 37.70820545 | -83.0657714 | 2021-01-19 05:22:15 | Magoffin, Kentucky, US |
2021-01-17 | US | Texas | Llano | 48299 | 975 | 29 | 0 | 776 | 30.70645047 | -98.68475262 | 2021-01-18 05:22:34 | Llano, Texas, US |
2021-01-17 | US | Kansas | Wilson | 20205 | 786 | 10 | 0 | 776 | 37.55937174 | -95.74323255 | 2021-01-18 05:22:34 | Wilson, Kansas, US |
2021-01-16 | US | Nebraska | Cheyenne | 31033 | 791 | 15 | 0 | 776 | 41.21999357 | -102.9941693 | 2021-01-17 05:22:17 | Cheyenne, Nebraska, US |
2021-01-16 | US | Kansas | Wilson | 20205 | 786 | 10 | 0 | 776 | 37.55937174 | -95.74323255 | 2021-01-17 05:22:17 | Wilson, Kansas, US |
2021-01-16 | US | Georgia | Dooly | 13093 | 804 | 28 | 0 | 776 | 32.15630737 | -83.79746561 | 2021-01-17 05:22:17 | Dooly, Georgia, US |
2021-01-16 | US | Georgia | Candler | 13043 | 813 | 37 | 0 | 776 | 32.40209349 | -82.07702563 | 2021-01-17 05:22:17 | Candler, Georgia, US |
2021-01-15 | US | Nebraska | Cheyenne | 31033 | 791 | 15 | 0 | 776 | 41.21999357 | -102.9941693 | 2021-01-16 05:22:40 | Cheyenne, Nebraska, US |
2021-01-15 | US | Kansas | Wilson | 20205 | 786 | 10 | 0 | 776 | 37.55937174 | -95.74323255 | 2021-01-16 05:22:40 | Wilson, Kansas, US |
2021-01-13 | US | Oklahoma | Blaine | 40011 | 780 | 4 | 0 | 776 | 35.87518314 | -98.43307003 | 2021-01-14 05:22:32 | Blaine, Oklahoma, US |
2021-01-13 | Japan | Gifu | 3197 | 49 | 2372 | 776 | 35.778671 | 137.055925 | 2021-01-14 05:22:32 | Gifu, Japan | ||
2021-01-12 | US | Puerto Rico | Aguada | 72003 | 776 | 0 | 0 | 776 | 18.360255 | -67.17513100000001 | 2021-01-13 05:22:15 | Aguada, Puerto Rico, US |
2021-01-12 | US | Arkansas | Pike | 5109 | 791 | 15 | 0 | 776 | 34.16250414 | -93.65789349 | 2021-01-13 05:22:15 | Pike, Arkansas, US |
2021-01-10 | US | Washington | Clallam | 53009 | 780 | 4 | 0 | 776 | 48.04754642 | -123.9226319 | 2021-01-11 05:21:50 | Clallam, Washington, US |
2021-01-09 | US | Washington | Clallam | 53009 | 780 | 4 | 0 | 776 | 48.04754642 | -123.9226319 | 2021-01-10 05:22:12 | Clallam, Washington, US |
2021-01-08 | US | Wyoming | Washakie | 56043 | 797 | 21 | 0 | 776 | 43.90451606 | -107.68018700000002 | 2021-01-09 05:22:18 | Washakie, Wyoming, US |
2021-01-07 | US | Indiana | Benton | 18007 | 786 | 10 | 0 | 776 | 40.60626947 | -87.31093999 | 2021-01-08 05:22:42 | Benton, Indiana, US |
2021-01-06 | US | Idaho | Teton | 16081 | 778 | 2 | 0 | 776 | 43.75303583 | -111.2056773 | 2021-01-07 05:22:03 | Teton, Idaho, US |
2021-01-05 | US | Kentucky | Fleming | 21069 | 778 | 2 | 0 | 776 | 38.36758311 | -83.69657514 | 2021-01-06 05:22:16 | Fleming, Kentucky, US |
2021-01-04 | US | Oklahoma | Unassigned | 90040 | 776 | 0 | 0 | 776 | 36.83532655 | 0.0 | 2021-01-05 05:21:49 | Unassigned, Oklahoma, US |
2021-01-02 | US | Nebraska | Box Butte | 31013 | 784 | 8 | 0 | 776 | 42.22079243 | -103.0878834 | 2021-01-03 05:22:52 | Box Butte, Nebraska, US |
2021-01-02 | US | Mississippi | Webster | 28155 | 794 | 18 | 0 | 776 | 33.61300486 | -89.28392912 | 2021-01-03 05:22:52 | Webster, Mississippi, US |
2021-01-01 | US | West Virginia | Lincoln | 54043 | 784 | 8 | 0 | 776 | 38.172154 | -82.07017953 | 2021-01-02 05:22:33 | Lincoln, West Virginia, US |
2021-01-01 | US | Virginia | Fluvanna | 51065 | 786 | 10 | 0 | 776 | 37.84157909 | -78.27715475 | 2021-01-02 05:22:33 | Fluvanna, Virginia, US |
2021-01-01 | US | Nebraska | Box Butte | 31013 | 784 | 8 | 0 | 776 | 42.22079243 | -103.0878834 | 2021-01-02 05:22:33 | Box Butte, Nebraska, US |
2021-01-01 | US | Michigan | Iron | 26071 | 813 | 37 | 0 | 776 | 46.20974132 | -88.53136251 | 2021-01-02 05:22:33 | Iron, Michigan, US |
2021-01-01 | US | Georgia | Towns | 13281 | 813 | 37 | 0 | 776 | 34.91369188 | -83.74107459999998 | 2021-01-02 05:22:33 | Towns, Georgia, US |
2020-12-31 | US | Michigan | Iron | 26071 | 813 | 37 | 0 | 776 | 46.20974132 | -88.53136251 | 2021-01-01 05:23:07 | Iron, Michigan, US |
2020-12-30 | US | South Carolina | Calhoun | 45017 | 796 | 20 | 0 | 776 | 33.66926881 | -80.77722168 | 2020-12-31 05:22:49 | Calhoun, South Carolina, US |
2020-12-30 | US | Minnesota | Jackson | 27063 | 784 | 8 | 0 | 776 | 43.67423373 | -95.15398258 | 2020-12-31 05:22:49 | Jackson, Minnesota, US |
2020-12-30 | US | Michigan | Iron | 26071 | 813 | 37 | 0 | 776 | 46.20974132 | -88.53136251 | 2020-12-31 05:22:49 | Iron, Michigan, US |
2020-12-28 | US | Missouri | Bates | 29013 | 786 | 10 | 0 | 776 | 38.25271289 | -94.34113157 | 2020-12-29 05:22:37 | Bates, Missouri, US |
2020-12-28 | US | Kentucky | Elliott | 21063 | 777 | 1 | 0 | 776 | 38.11624059 | -83.09771563 | 2020-12-29 05:22:37 | Elliott, Kentucky, US |
2020-12-25 | US | Montana | Powell | 30077 | 781 | 5 | 0 | 776 | 46.85538891 | -112.9359164 | 2020-12-26 05:22:28 | Powell, Montana, US |
2020-12-24 | US | New Mexico | San Miguel | 35047 | 779 | 3 | 0 | 776 | 35.48014807 | -104.8163562 | 2020-12-25 05:22:48 | San Miguel, New Mexico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;