daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
119 rows where active = 2070 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-07-06 | Colombia | Meta | 76865 | 1811 | 72984 | 2070 | 3.272 | -73.0877 | 2021-07-07 04:21:20 | Meta, Colombia | ||
2021-06-29 | Russia | Irkutsk Oblast | 73840 | 2717 | 69053 | 2070 | 56.6370122 | 104.719221 | 2021-06-30 04:21:41 | Irkutsk Oblast, Russia | ||
2021-06-07 | Japan | Kanagawa | 62987 | 913 | 60004 | 2070 | 35.415312 | 139.338983 | 2021-06-08 04:22:35 | Kanagawa, Japan | ||
2021-05-30 | Colombia | Bolivar | 101452 | 1992 | 97390 | 2070 | 8.6704 | -74.03 | 2021-05-31 03:08:59 | Bolivar, Colombia | ||
2021-05-04 | Russia | Bashkortostan Republic | 35763 | 461 | 33232 | 2070 | 54.8573563 | 57.1439682 | 2021-05-05 04:20:43 | Bashkortostan Republic, Russia | ||
2021-04-28 | Russia | Lipetsk Oblast | 29710 | 647 | 26993 | 2070 | 52.6935178 | 39.1122664 | 2021-04-29 04:20:55 | Lipetsk Oblast, Russia | ||
2021-04-01 | Russia | Karelia Republic | 43945 | 390 | 41485 | 2070 | 62.61940309999999 | 33.4920267 | 2021-04-02 04:20:36 | Karelia Republic, Russia | ||
2021-03-12 | Malaysia | Sarawak | 12051 | 91 | 9890 | 2070 | 1.5533 | 110.3592 | 2021-03-13 05:25:15 | Sarawak, Malaysia | ||
2021-03-06 | US | Nebraska | Gage | 31067 | 2089 | 19 | 0 | 2070 | 40.26186809 | -96.68946704 | 2021-03-07 05:21:54 | Gage, Nebraska, US |
2021-03-02 | US | Minnesota | Waseca | 27161 | 2087 | 17 | 0 | 2070 | 44.02211116 | -93.58720034 | 2021-03-03 05:23:28 | Waseca, Minnesota, US |
2021-02-24 | US | North Carolina | Cherokee | 37039 | 2088 | 18 | 0 | 2070 | 35.1349263 | -84.05970864 | 2021-02-25 05:24:57 | Cherokee, North Carolina, US |
2021-02-24 | US | Arkansas | Columbia | 5027 | 2124 | 54 | 0 | 2070 | 33.21230701 | -93.22642793 | 2021-02-25 05:24:57 | Columbia, Arkansas, US |
2021-02-23 | US | West Virginia | Mingo | 54059 | 2104 | 34 | 0 | 2070 | 37.73048351 | -82.13338365 | 2021-02-24 05:29:16 | Mingo, West Virginia, US |
2021-02-22 | US | South Carolina | Jasper | 45053 | 2111 | 41 | 0 | 2070 | 32.43171982 | -81.02487495 | 2021-02-23 05:23:41 | Jasper, South Carolina, US |
2021-02-22 | Russia | Kaluga Oblast | 29109 | 247 | 26792 | 2070 | 54.4382773 | 35.5272854 | 2021-02-23 05:23:41 | Kaluga Oblast, Russia | ||
2021-02-21 | Ukraine | Sumy Oblast | 47704 | 657 | 44977 | 2070 | 50.9077 | 34.7981 | 2021-02-22 05:24:21 | Sumy Oblast, Ukraine | ||
2021-02-18 | US | Kentucky | Marion | 21155 | 2093 | 23 | 0 | 2070 | 37.55218078 | -85.26898542 | 2021-02-19 05:24:16 | Marion, Kentucky, US |
2021-02-13 | US | Maine | Oxford | 23017 | 2111 | 41 | 0 | 2070 | 44.49952995 | -70.75682123 | 2021-02-14 05:23:43 | Oxford, Maine, US |
2021-02-13 | US | Arkansas | Ouachita | 5103 | 2118 | 48 | 0 | 2070 | 33.58839816 | -92.87795984 | 2021-02-14 05:23:43 | Ouachita, Arkansas, US |
2021-02-12 | US | Georgia | Tattnall | 13267 | 2122 | 52 | 0 | 2070 | 32.04785085 | -82.05539188 | 2021-02-13 05:22:12 | Tattnall, Georgia, US |
2021-02-09 | US | Ohio | Gallia | 39053 | 2111 | 41 | 0 | 2070 | 38.82708533 | -82.31647569 | 2021-02-10 05:22:41 | Gallia, Ohio, US |
2021-02-08 | US | Missouri | Polk | 29167 | 2096 | 26 | 0 | 2070 | 37.6162296 | -93.39828174 | 2021-02-09 05:23:30 | Polk, Missouri, US |
2021-02-05 | US | Texas | Fayette | 48149 | 2187 | 50 | 0 | 2070 | 29.87788372 | -96.92076062 | 2021-02-06 05:23:55 | Fayette, Texas, US |
2021-02-05 | US | South Carolina | Barnwell | 45011 | 2113 | 43 | 0 | 2070 | 33.26679302 | -81.43584352 | 2021-02-06 05:23:55 | Barnwell, South Carolina, US |
2021-02-03 | US | Georgia | Monroe | 13207 | 2153 | 83 | 0 | 2070 | 33.014289 | -83.92097166 | 2021-02-04 05:22:26 | Monroe, Georgia, US |
2021-02-02 | US | Puerto Rico | Vega Baja | 72145 | 2070 | 0 | 0 | 2070 | 18.428262 | -66.397924 | 2021-02-03 05:22:52 | Vega Baja, Puerto Rico, US |
2021-02-02 | US | Missouri | Barry | 29009 | 2114 | 44 | 0 | 2070 | 36.70978521 | -93.82919888 | 2021-02-03 05:22:52 | Barry, Missouri, US |
2021-02-02 | US | Maryland | Dorchester | 24019 | 2106 | 36 | 0 | 2070 | 38.45413522 | -76.02752426 | 2021-02-03 05:22:52 | Dorchester, Maryland, US |
2021-01-29 | US | New York | Orleans | 36073 | 2146 | 76 | 0 | 2070 | 43.2516977 | -78.2320066 | 2021-01-30 05:22:49 | Orleans, New York, US |
2021-01-27 | US | Texas | Kleberg | 48273 | 2321 | 64 | 0 | 2070 | 27.42435506 | -97.69894948 | 2021-01-28 05:22:24 | Kleberg, Texas, US |
2021-01-25 | US | Kentucky | Harlan | 21095 | 2105 | 35 | 0 | 2070 | 36.85699301 | -83.21899516 | 2021-01-26 05:22:02 | Harlan, Kentucky, US |
2021-01-24 | US | Kentucky | Clark | 21049 | 2086 | 16 | 0 | 2070 | 37.9689263 | -84.14615986 | 2021-01-25 05:22:16 | Clark, Kentucky, US |
2021-01-23 | US | Indiana | Randolph | 18135 | 2135 | 65 | 0 | 2070 | 40.15734772 | -85.01139319 | 2021-01-24 05:22:35 | Randolph, Indiana, US |
2021-01-22 | Ukraine | Volyn Oblast | 35856 | 563 | 33223 | 2070 | 50.7472 | 25.3254 | 2021-01-23 05:22:03 | Volyn Oblast, Ukraine | ||
2021-01-22 | US | Texas | Moore | 48341 | 2694 | 58 | 0 | 2070 | 35.83769242 | -101.8930281 | 2021-01-23 05:22:03 | Moore, Texas, US |
2021-01-22 | US | Minnesota | Cass | 27021 | 2094 | 24 | 0 | 2070 | 46.95043611 | -94.32603968 | 2021-01-23 05:22:03 | Cass, Minnesota, US |
2021-01-21 | Russia | Kaliningrad Oblast | 22127 | 214 | 19843 | 2070 | 54.7293041 | 21.1489473 | 2021-01-22 05:22:10 | Kaliningrad Oblast, Russia | ||
2021-01-20 | US | Virginia | Amherst | 51009 | 2080 | 10 | 0 | 2070 | 37.60308293 | -79.14548696 | 2021-01-21 05:22:01 | Amherst, Virginia, US |
2021-01-16 | US | Minnesota | Le Sueur | 27079 | 2085 | 15 | 0 | 2070 | 44.37136597 | -93.72844721 | 2021-01-17 05:22:17 | Le Sueur, Minnesota, US |
2021-01-16 | US | Kentucky | Taylor | 21217 | 2091 | 21 | 0 | 2070 | 37.3677562 | -85.3329931 | 2021-01-17 05:22:17 | Taylor, Kentucky, US |
2021-01-15 | US | New York | Tioga | 36107 | 2124 | 54 | 0 | 2070 | 42.16852837 | -76.30835812 | 2021-01-16 05:22:40 | Tioga, New York, US |
2021-01-11 | US | Missouri | Stoddard | 29207 | 2104 | 34 | 0 | 2070 | 36.85571651 | -89.9444155 | 2021-01-12 05:22:15 | Stoddard, Missouri, US |
2021-01-08 | US | West Virginia | Hancock | 54029 | 2126 | 56 | 0 | 2070 | 40.51943859 | -80.57461608 | 2021-01-09 05:22:18 | Hancock, West Virginia, US |
2021-01-07 | US | Florida | Taylor | 12123 | 2098 | 28 | 0 | 2070 | 30.04848048 | -83.60445406 | 2021-01-08 05:22:42 | Taylor, Florida, US |
2021-01-02 | US | Tennessee | McNairy | 47109 | 2084 | 38 | 0 | 2070 | 35.17468549 | -88.5647812 | 2021-01-03 05:22:52 | McNairy, Tennessee, US |
2020-12-30 | US | Nevada | Lyon | 32019 | 2112 | 42 | 0 | 2070 | 39.01777974 | -119.1870479 | 2020-12-31 05:22:49 | Lyon, Nevada, US |
2020-12-28 | US | Kentucky | Franklin | 21073 | 2089 | 19 | 0 | 2070 | 38.2379395 | -84.87962551 | 2020-12-29 05:22:37 | Franklin, Kentucky, US |
2020-12-25 | US | North Carolina | Jackson | 37099 | 2086 | 16 | 0 | 2070 | 35.28814273 | -83.14093385 | 2020-12-26 05:22:28 | Jackson, North Carolina, US |
2020-12-24 | US | Texas | Hopkins | 48223 | 1684 | 69 | 0 | 2070 | 33.14875072 | -95.56351139 | 2020-12-25 05:22:48 | Hopkins, Texas, US |
2020-12-24 | US | North Carolina | Jackson | 37099 | 2086 | 16 | 0 | 2070 | 35.28814273 | -83.14093385 | 2020-12-25 05:22:48 | Jackson, North Carolina, US |
2020-12-23 | US | North Carolina | Jackson | 37099 | 2086 | 16 | 0 | 2070 | 35.28814273 | -83.14093385 | 2020-12-24 05:23:04 | Jackson, North Carolina, US |
2020-12-23 | US | New York | Wayne | 36117 | 2101 | 31 | 0 | 2070 | 43.15494365 | -77.02976528 | 2020-12-24 05:23:04 | Wayne, New York, US |
2020-12-18 | US | Texas | Wharton | 48481 | 2075 | 73 | 0 | 2070 | 29.27765923 | -96.22319248 | 2020-12-19 05:27:52 | Wharton, Texas, US |
2020-12-18 | Colombia | Bolivar | 45346 | 999 | 42277 | 2070 | 8.6704 | -74.03 | 2020-12-19 05:27:52 | Bolivar, Colombia | ||
2020-12-17 | Namibia | 17607 | 164 | 15373 | 2070 | -22.9576 | 18.4904 | 2020-12-18 05:28:18 | Namibia | |||
2020-12-15 | US | Kansas | Cowley | 20035 | 2080 | 10 | 0 | 2070 | 37.23781842 | -96.83776647 | 2020-12-16 05:28:04 | Cowley, Kansas, US |
2020-12-14 | US | Kansas | Cowley | 20035 | 2080 | 10 | 0 | 2070 | 37.23781842 | -96.83776647 | 2020-12-15 05:26:38 | Cowley, Kansas, US |
2020-12-10 | US | Oklahoma | Woodward | 40153 | 2078 | 8 | 0 | 2070 | 36.42316318 | -99.26283045 | 2020-12-11 05:26:59 | Woodward, Oklahoma, US |
2020-12-01 | US | Indiana | Gibson | 18051 | 2111 | 41 | 0 | 2070 | 38.30393723 | -87.58054938 | 2020-12-02 05:27:41 | Gibson, Indiana, US |
2020-11-28 | Ukraine | Luhansk Oblast | 6185 | 166 | 3949 | 2070 | 48.574 | 39.3078 | 2020-11-29 05:25:55 | Luhansk Oblast, Ukraine | ||
2020-11-27 | US | Massachusetts | Hampshire | 25015 | 2231 | 126 | 0 | 2070 | 42.33997957 | -72.65898478 | 2020-11-28 05:25:50 | Hampshire, Massachusetts, US |
2020-11-27 | Russia | Altai Krai | 25450 | 522 | 22858 | 2070 | 52.6932243 | 82.69314240000001 | 2020-11-28 05:25:50 | Altai Krai, Russia | ||
2020-11-26 | US | New York | Saratoga | 36091 | 2089 | 19 | 0 | 2070 | 43.10904162 | -73.86653895 | 2020-11-27 05:26:53 | Saratoga, New York, US |
2020-11-25 | Russia | Lipetsk Oblast | 10616 | 97 | 8449 | 2070 | 52.6935178 | 39.1122664 | 2020-11-26 05:27:44 | Lipetsk Oblast, Russia | ||
2020-11-22 | US | Wisconsin | Clark | 55019 | 2106 | 36 | 0 | 2070 | 44.73483377 | -90.61207486 | 2020-11-23 05:25:26 | Clark, Wisconsin, US |
2020-11-21 | Malaysia | Selangor | 9153 | 27 | 7056 | 2070 | 3.0738 | 101.5183 | 2020-11-22 05:25:45 | Selangor, Malaysia | ||
2020-11-20 | US | Pennsylvania | Indiana | 42063 | 2101 | 31 | 0 | 2070 | 40.65241041 | -79.08963285 | 2020-11-21 05:25:51 | Indiana, Pennsylvania, US |
2020-11-16 | US | Mississippi | Lowndes | 28087 | 2132 | 62 | 0 | 2070 | 33.47386518 | -88.44191529999998 | 2020-11-17 05:25:54 | Lowndes, Mississippi, US |
2020-11-15 | US | Michigan | Midland | 26111 | 2086 | 16 | 0 | 2070 | 43.64330771 | -84.38804374 | 2020-11-16 05:25:57 | Midland, Michigan, US |
2020-11-15 | US | Alabama | Russell | 1113 | 2073 | 3 | 0 | 2070 | 32.28725256 | -85.18415324 | 2020-11-16 05:25:57 | Russell, Alabama, US |
2020-11-14 | US | New York | Putnam | 36079 | 2134 | 64 | 0 | 2070 | 41.42630093 | -73.74965532 | 2020-11-15 05:26:53 | Putnam, New York, US |
2020-11-14 | US | Michigan | Midland | 26111 | 2086 | 16 | 0 | 2070 | 43.64330771 | -84.38804374 | 2020-11-15 05:26:53 | Midland, Michigan, US |
2020-11-13 | Chile | Metropolitana | 300290 | 10085 | 288135 | 2070 | -33.4376 | -70.6505 | 2020-11-14 05:25:37 | Metropolitana, Chile | ||
2020-11-12 | US | Oregon | Malheur | 41045 | 2108 | 38 | 0 | 2070 | 43.1937027 | -117.6227395 | 2020-11-13 05:25:30 | Malheur, Oregon, US |
2020-11-12 | US | California | Sutter | 6101 | 2081 | 12 | 0 | 2070 | 39.03417539 | -121.6945899 | 2020-11-13 05:25:30 | Sutter, California, US |
2020-11-11 | US | Oregon | Malheur | 41045 | 2108 | 38 | 0 | 2070 | 43.1937027 | -117.6227395 | 2020-11-12 05:25:55 | Malheur, Oregon, US |
2020-11-04 | US | Texas | Nacogdoches | 48347 | 2185 | 72 | 0 | 2070 | 31.62017125 | -94.61803994 | 2020-11-05 06:05:03 | Nacogdoches, Texas, US |
2020-10-30 | US | Ohio | Medina | 39103 | 2126 | 56 | 0 | 2070 | 41.11770589 | -81.89986209999998 | 2020-10-31 04:24:44 | Medina, Ohio, US |
2020-10-30 | US | Indiana | Warrick | 18173 | 2140 | 70 | 0 | 2070 | 38.08922676 | -87.2716085 | 2020-10-31 04:24:44 | Warrick, Indiana, US |
2020-10-26 | US | Virginia | Hampton | 51650 | 2102 | 32 | 0 | 2070 | 37.03513786 | -76.35879121 | 2020-10-27 04:24:45 | Hampton, Virginia, US |
2020-10-26 | US | Ohio | Miami | 39109 | 2132 | 62 | 0 | 2070 | 40.0543329 | -84.22871271 | 2020-10-27 04:24:45 | Miami, Ohio, US |
2020-10-25 | US | Ohio | Columbiana | 39029 | 2162 | 92 | 0 | 2070 | 40.76932373 | -80.78094576 | 2020-10-26 04:25:02 | Columbiana, Ohio, US |
2020-10-22 | US | Texas | Orange | 48361 | 990 | 46 | 0 | 2070 | 30.11879481 | -93.89412775 | 2020-10-23 04:24:46 | Orange, Texas, US |
2020-10-21 | US | Texas | Orange | 48361 | 968 | 46 | 0 | 2070 | 30.11879481 | -93.89412775 | 2020-10-22 04:24:27 | Orange, Texas, US |
2020-10-20 | US | Texas | Orange | 48361 | 941 | 46 | 0 | 2070 | 30.11879481 | -93.89412775 | 2020-10-21 04:24:14 | Orange, Texas, US |
2020-10-19 | US | Indiana | LaPorte | 18091 | 2130 | 60 | 0 | 2070 | 41.54366008 | -86.74072188 | 2020-10-20 04:24:22 | LaPorte, Indiana, US |
2020-10-18 | US | Missouri | Christian | 29043 | 2080 | 10 | 0 | 2070 | 36.9711783 | -93.18537118 | 2020-10-19 04:24:16 | Christian, Missouri, US |
2020-10-13 | US | Texas | Grayson | 48181 | 2156 | 55 | 0 | 2070 | 33.62744998 | -96.67753461 | 2020-10-14 04:24:05 | Grayson, Texas, US |
2020-10-13 | US | Michigan | Berrien | 26021 | 2147 | 77 | 0 | 2070 | 41.95447397 | -86.41313079999998 | 2020-10-14 04:24:05 | Berrien, Michigan, US |
2020-10-12 | US | Louisiana | St. Martin | 22099 | 2131 | 61 | 0 | 2070 | 30.13112107 | -91.61403569 | 2020-10-13 04:24:02 | St. Martin, Louisiana, US |
2020-10-11 | US | Florida | Hendry | 12051 | 2113 | 43 | 0 | 2070 | 26.55386945 | -81.16469006 | 2020-10-12 04:23:45 | Hendry, Florida, US |
2020-10-08 | US | Louisiana | St. Martin | 22099 | 2131 | 61 | 0 | 2070 | 30.13112107 | -91.61403569 | 2020-10-09 04:23:59 | St. Martin, Louisiana, US |
2020-10-08 | US | Georgia | Jackson | 13157 | 2106 | 36 | 0 | 2070 | 34.13794553 | -83.56814788 | 2020-10-09 04:23:59 | Jackson, Georgia, US |
2020-10-08 | Russia | Penza Oblast | 11660 | 137 | 9453 | 2070 | 53.1655415 | 44.78791810000001 | 2020-10-09 04:23:59 | Penza Oblast, Russia | ||
2020-10-07 | US | Iowa | Buena Vista | 19021 | 2082 | 12 | 0 | 2070 | 42.73545875 | -95.15100162 | 2020-10-08 04:23:56 | Buena Vista, Iowa, US |
2020-10-05 | US | South Carolina | Kershaw | 45055 | 2108 | 38 | 0 | 2070 | 34.33988254 | -80.58763164 | 2020-10-06 04:23:33 | Kershaw, South Carolina, US |
2020-10-03 | US | Illinois | Kendall | 17093 | 2096 | 26 | 0 | 2070 | 41.59081014 | -88.42869583 | 2020-10-04 04:23:44 | Kendall, Illinois, US |
2020-10-01 | US | Georgia | Baldwin | 13009 | 2127 | 57 | 0 | 2070 | 33.06882326 | -83.24701748 | 2020-10-02 04:23:51 | Baldwin, Georgia, US |
2020-09-27 | US | Florida | Highlands | 12055 | 2156 | 86 | 0 | 2070 | 27.34254618 | -81.34071957 | 2020-09-28 04:23:00 | Highlands, Florida, US |
2020-09-23 | US | Oklahoma | Canadian | 40017 | 2087 | 17 | 0 | 2070 | 35.5426055 | -97.98465569 | 2020-09-24 04:23:00 | Canadian, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;