daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69 rows where active = 2283 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-08-04 | Russia | Novgorod Oblast | 37055 | 240 | 34532 | 2283 | 58.2843833 | 32.5169757 | 2021-08-05 04:21:51 | Novgorod Oblast, Russia | ||
2021-06-20 | Colombia | Huila | 66679 | 2243 | 62153 | 2283 | 2.5359 | -75.5277 | 2021-06-21 04:21:41 | Huila, Colombia | ||
2021-06-14 | Russia | Kostroma Oblast | 22020 | 498 | 19239 | 2283 | 58.424756 | 44.2533273 | 2021-06-15 04:22:22 | Kostroma Oblast, Russia | ||
2021-06-12 | Malaysia | Pahang | 11539 | 73 | 9183 | 2283 | 3.8126 | 103.3256 | 2021-06-13 04:22:44 | Pahang, Malaysia | ||
2021-06-08 | Colombia | Cordoba | 67203 | 2611 | 62309 | 2283 | 8.0493 | -75.574 | 2021-06-09 04:23:31 | Cordoba, Colombia | ||
2021-06-07 | Colombia | Cordoba | 67203 | 2611 | 62309 | 2283 | 8.0493 | -75.574 | 2021-06-08 04:22:35 | Cordoba, Colombia | ||
2021-04-12 | Guinea | 21032 | 136 | 18613 | 2283 | 9.9456 | -9.6966 | 2021-04-13 04:20:37 | Guinea | |||
2021-03-19 | Russia | Kostroma Oblast | 19133 | 375 | 16475 | 2283 | 58.424756 | 44.2533273 | 2021-03-20 05:25:46 | Kostroma Oblast, Russia | ||
2021-03-02 | US | Kentucky | Montgomery | 21173 | 2307 | 24 | 0 | 2283 | 38.03253032 | -83.9145241 | 2021-03-03 05:23:28 | Montgomery, Kentucky, US |
2021-03-02 | El Salvador | 60491 | 1869 | 56339 | 2283 | 13.7942 | -88.8965 | 2021-03-03 05:23:28 | El Salvador | |||
2021-03-01 | US | Kentucky | Montgomery | 21173 | 2307 | 24 | 0 | 2283 | 38.03253032 | -83.9145241 | 2021-03-02 05:23:30 | Montgomery, Kentucky, US |
2021-02-28 | US | New York | Washington | 36115 | 2335 | 52 | 0 | 2283 | 43.31153794 | -73.43043448 | 2021-03-01 05:23:01 | Washington, New York, US |
2021-02-28 | US | Georgia | Harris | 13145 | 2330 | 47 | 0 | 2283 | 32.73709786 | -84.90538572 | 2021-03-01 05:23:01 | Harris, Georgia, US |
2021-02-27 | US | Louisiana | Plaquemines | 22075 | 2307 | 24 | 0 | 2283 | 29.42245447 | -89.60322085 | 2021-02-28 05:22:20 | Plaquemines, Louisiana, US |
2021-02-26 | US | Louisiana | Plaquemines | 22075 | 2307 | 24 | 0 | 2283 | 29.42245447 | -89.60322085 | 2021-02-27 05:22:28 | Plaquemines, Louisiana, US |
2021-02-25 | US | Louisiana | Richland | 22083 | 2332 | 49 | 0 | 2283 | 32.41391005 | -91.76634876 | 2021-02-26 05:22:40 | Richland, Louisiana, US |
2021-02-14 | US | Pennsylvania | Tioga | 42117 | 2376 | 93 | 0 | 2283 | 41.77255149 | -77.25433032 | 2021-02-15 05:24:49 | Tioga, Pennsylvania, US |
2021-02-13 | US | New York | Orleans | 36073 | 2363 | 80 | 0 | 2283 | 43.2516977 | -78.2320066 | 2021-02-14 05:23:43 | Orleans, New York, US |
2021-02-11 | US | Michigan | Dickinson | 26043 | 2352 | 69 | 0 | 2283 | 46.00999672 | -87.86961634 | 2021-02-12 05:23:29 | Dickinson, Michigan, US |
2021-02-11 | US | Georgia | Haralson | 13143 | 2352 | 69 | 0 | 2283 | 33.79602175 | -85.21005667 | 2021-02-12 05:23:29 | Haralson, Georgia, US |
2021-02-10 | US | Michigan | Dickinson | 26043 | 2352 | 69 | 0 | 2283 | 46.00999672 | -87.86961634 | 2021-02-11 05:23:55 | Dickinson, Michigan, US |
2021-02-09 | US | Mississippi | Grenada | 28043 | 2357 | 74 | 0 | 2283 | 33.77036166 | -89.80245083 | 2021-02-10 05:22:41 | Grenada, Mississippi, US |
2021-02-09 | US | Georgia | Sumter | 13261 | 2371 | 88 | 0 | 2283 | 32.03650571 | -84.19821492 | 2021-02-10 05:22:41 | Sumter, Georgia, US |
2021-02-06 | US | Ohio | Henry | 39069 | 2344 | 61 | 0 | 2283 | 41.3339642 | -84.06830637 | 2021-02-07 05:23:00 | Henry, Ohio, US |
2021-01-21 | US | West Virginia | Hancock | 54029 | 2360 | 77 | 0 | 2283 | 40.51943859 | -80.57461608 | 2021-01-22 05:22:10 | Hancock, West Virginia, US |
2021-01-18 | US | Mississippi | Coahoma | 28027 | 2337 | 54 | 0 | 2283 | 34.22772299 | -90.60415045 | 2021-01-19 05:22:15 | Coahoma, Mississippi, US |
2021-01-16 | Russia | Kemerovo Oblast | 27704 | 498 | 24923 | 2283 | 54.53357809999999 | 87.342861 | 2021-01-17 05:22:17 | Kemerovo Oblast, Russia | ||
2021-01-15 | US | Pennsylvania | Snyder | 42109 | 2338 | 55 | 0 | 2283 | 40.77129231 | -77.06840691 | 2021-01-16 05:22:40 | Snyder, Pennsylvania, US |
2021-01-15 | US | Pennsylvania | Clinton | 42035 | 2320 | 37 | 0 | 2283 | 41.23255967 | -77.63785995 | 2021-01-16 05:22:40 | Clinton, Pennsylvania, US |
2021-01-09 | US | Mississippi | Prentiss | 28117 | 2330 | 47 | 0 | 2283 | 34.61810501 | -88.51986294 | 2021-01-10 05:22:12 | Prentiss, Mississippi, US |
2021-01-07 | US | Iowa | Bremer | 19017 | 2329 | 46 | 0 | 2283 | 42.77461496 | -92.31795937 | 2021-01-08 05:22:42 | Bremer, Iowa, US |
2021-01-05 | US | Maine | Penobscot | 23019 | 2305 | 22 | 0 | 2283 | 45.40194593 | -68.65020455 | 2021-01-06 05:22:16 | Penobscot, Maine, US |
2020-12-26 | US | Florida | Okeechobee | 12093 | 2334 | 51 | 0 | 2283 | 27.386336199999995 | -80.88944347 | 2020-12-27 05:22:55 | Okeechobee, Florida, US |
2020-12-25 | US | Texas | Harrison | 48203 | 2625 | 60 | 0 | 2283 | 32.54935988 | -94.36934071 | 2020-12-26 05:22:28 | Harrison, Texas, US |
2020-12-25 | US | Iowa | Carroll | 19027 | 2310 | 27 | 0 | 2283 | 42.03617207 | -94.86032705 | 2020-12-26 05:22:28 | Carroll, Iowa, US |
2020-12-24 | US | New York | Cayuga | 36011 | 2297 | 14 | 0 | 2283 | 42.91261714 | -76.55731592 | 2020-12-25 05:22:48 | Cayuga, New York, US |
2020-12-23 | US | Texas | Van Zandt | 48467 | 1535 | 58 | 0 | 2283 | 32.56483801 | -95.83766469 | 2020-12-24 05:23:04 | Van Zandt, Texas, US |
2020-12-20 | Japan | Saitama | 11669 | 177 | 9209 | 2283 | 35.997101 | 139.347635 | 2020-12-21 05:27:58 | Saitama, Japan | ||
2020-12-18 | US | California | Nevada | 6057 | 2297 | 13 | 0 | 2283 | 39.30394768 | -120.7627281 | 2020-12-19 05:27:52 | Nevada, California, US |
2020-12-15 | US | Texas | Titus | 48449 | 2169 | 42 | 0 | 2283 | 33.21339719 | -94.96797273 | 2020-12-16 05:28:04 | Titus, Texas, US |
2020-12-15 | US | Indiana | Wabash | 18169 | 2324 | 41 | 0 | 2283 | 40.84704239 | -85.79328272 | 2020-12-16 05:28:04 | Wabash, Indiana, US |
2020-12-14 | US | Iowa | Henry | 19087 | 2302 | 19 | 0 | 2283 | 40.98767962 | -91.54436349 | 2020-12-15 05:26:38 | Henry, Iowa, US |
2020-12-12 | US | Texas | Jim Wells | 48249 | 2518 | 58 | 0 | 2283 | 27.73103938 | -98.0904705 | 2020-12-13 05:27:20 | Jim Wells, Texas, US |
2020-12-12 | US | Illinois | Jefferson | 17081 | 2348 | 65 | 0 | 2283 | 38.29980057 | -88.9240025 | 2020-12-13 05:27:20 | Jefferson, Illinois, US |
2020-12-10 | US | Oklahoma | Pontotoc | 40123 | 2299 | 16 | 0 | 2283 | 34.72959848 | -96.68337199 | 2020-12-11 05:26:59 | Pontotoc, Oklahoma, US |
2020-12-01 | US | Alabama | Dallas | 1047 | 2315 | 32 | 0 | 2283 | 32.32688101 | -87.10866709999998 | 2020-12-02 05:27:41 | Dallas, Alabama, US |
2020-11-30 | US | Virginia | Manassas | 51683 | 2311 | 28 | 0 | 2283 | 38.7464321 | -77.48509905 | 2020-12-01 05:26:18 | Manassas, Virginia, US |
2020-11-21 | Russia | Altai Krai | 24084 | 489 | 21312 | 2283 | 52.6932243 | 82.69314240000001 | 2020-11-22 05:25:45 | Altai Krai, Russia | ||
2020-11-11 | US | Indiana | Floyd | 18043 | 2367 | 84 | 0 | 2283 | 38.32117957 | -85.90385377 | 2020-11-12 05:25:55 | Floyd, Indiana, US |
2020-11-03 | US | California | Shasta | 6089 | 2316 | 33 | 0 | 2283 | 40.76391419 | -122.0396884 | 2020-11-04 05:25:09 | Shasta, California, US |
2020-10-30 | US | Arkansas | Mississippi | 5093 | 2351 | 68 | 0 | 2283 | 35.76271485 | -90.05194370000002 | 2020-10-31 04:24:44 | Mississippi, Arkansas, US |
2020-10-26 | US | North Dakota | Stark | 38089 | 2327 | 34 | 0 | 2283 | 46.80851182 | -102.6576326 | 2020-10-27 04:24:45 | Stark, North Dakota, US |
2020-10-24 | US | Oklahoma | Muskogee | 40101 | 2311 | 28 | 0 | 2283 | 35.61318461 | -95.37802952 | 2020-10-25 04:24:36 | Muskogee, Oklahoma, US |
2020-10-23 | US | Georgia | Jackson | 13157 | 2323 | 40 | 0 | 2283 | 34.13794553 | -83.56814788 | 2020-10-24 04:24:46 | Jackson, Georgia, US |
2020-10-23 | US | Arkansas | Lincoln | 5079 | 2300 | 17 | 0 | 2283 | 33.95317155 | -91.74002806 | 2020-10-24 04:24:46 | Lincoln, Arkansas, US |
2020-10-17 | US | South Carolina | Kershaw | 45055 | 2325 | 42 | 0 | 2283 | 34.33988254 | -80.58763164 | 2020-10-18 04:24:25 | Kershaw, South Carolina, US |
2020-10-09 | US | Mississippi | Lafayette | 28071 | 2324 | 41 | 0 | 2283 | 34.35687874 | -89.48490961 | 2020-10-10 04:23:57 | Lafayette, Mississippi, US |
2020-10-08 | US | South Carolina | Greenwood | 45047 | 2356 | 73 | 0 | 2283 | 34.15272415 | -82.12715789 | 2020-10-09 04:23:59 | Greenwood, South Carolina, US |
2020-10-07 | US | Arkansas | Saline | 5125 | 2307 | 24 | 0 | 2283 | 34.64916145 | -92.67583224 | 2020-10-08 04:23:56 | Saline, Arkansas, US |
2020-10-03 | US | Alabama | Limestone | 1083 | 2305 | 22 | 0 | 2283 | 34.81185586 | -86.98310072 | 2020-10-04 04:23:44 | Limestone, Alabama, US |
2020-09-07 | Colombia | Risaralda | 7280 | 138 | 4859 | 2283 | 5.3158 | -75.9928 | 2020-09-08 04:28:25 | Risaralda, Colombia | ||
2020-09-06 | Colombia | Risaralda | 7280 | 138 | 4859 | 2283 | 5.3158 | -75.9928 | 2020-09-07 04:28:30 | Risaralda, Colombia | ||
2020-08-07 | US | Texas | Maverick | 48323 | 1290 | 38 | 0 | 2283 | 28.7429195 | -100.3157686 | 2020-08-08 04:34:53 | Maverick, Texas, US |
2020-08-04 | US | Pennsylvania | York | 42133 | 2372 | 89 | 0 | 2283 | 39.9210089 | -76.73040131 | 2020-08-05 04:34:43 | York, Pennsylvania, US |
2020-07-13 | Russia | Samara Oblast | 5954 | 64 | 3607 | 2283 | 53.2128813 | 50.8914633 | 2020-07-14 04:34:46 | Samara Oblast, Russia | ||
2020-07-01 | Russia | Bashkortostan Republic | 5405 | 18 | 3104 | 2283 | 54.8573563 | 57.1439682 | 2020-07-02 04:33:46 | Bashkortostan Republic, Russia | ||
2020-06-21 | US | Oklahoma | Tulsa | 40143 | 2349 | 66 | 0 | 2283 | 36.11939621 | -95.94013939 | 2020-06-22 04:33:20 | Tulsa, Oklahoma, US |
2020-06-01 | US | Wisconsin | Brown | 55009 | 2320 | 37 | 0 | 2283 | 44.4526553 | -88.00411844 | 2020-06-02 02:33:08 | Brown, Wisconsin, US |
2020-04-27 | US | Tennessee | Shelby | 47157 | 2377 | 44 | 0 | 2283 | 35.1864775 | -89.89692423 | 2020-04-28 02:30:51 | Shelby, Tennessee, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;