johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
72 rows where active = 2338 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296209 | 3296209 | 2021-07-30 | Japan | Okinawa | 24296 | 236 | 21722 | 2338 | 25.768923 | 126.668016 | 2021-07-31 04:21:35 | Okinawa, Japan | ||
3125500 | 3125500 | 2021-06-28 | Italy | Sardegna | 57208 | 1490 | 53380 | 2338 | 39.21531192 | 9.110616306 | 2021-06-29 04:21:28 | Sardegna, Italy | ||
3475976 | 3475976 | 2021-06-08 | Malaysia | Perak | 22826 | 107 | 20381 | 2338 | 4.5921 | 101.0901 | 2021-06-09 04:23:31 | Perak, Malaysia | ||
20388 | 20388 | 2021-05-28 | Japan | Kanagawa | 60885 | 882 | 57665 | 2338 | 35.415312 | 139.338983 | 2021-05-29 04:20:41 | Kanagawa, Japan | ||
1617681 | 1617681 | 2021-03-05 | US | Kentucky | Mercer | 21167 | 2371 | 33 | 0 | 2338 | 37.81474237 | -84.87488475 | 2021-03-06 04:23:41 | Mercer, Kentucky, US |
2209092 | 2209092 | 2021-03-04 | US | Kentucky | Mercer | 21167 | 2371 | 33 | 0 | 2338 | 37.81474237 | -84.87488475 | 2021-03-05 05:26:29 | Mercer, Kentucky, US |
1091589 | 1091589 | 2021-03-03 | US | Louisiana | Plaquemines | 22075 | 2363 | 25 | 0 | 2338 | 29.42245447 | -89.60322085 | 2021-03-04 05:24:24 | Plaquemines, Louisiana, US |
999537 | 999537 | 2021-03-01 | US | Indiana | LaGrange | 18087 | 2408 | 70 | 0 | 2338 | 41.64232188 | -85.42674232 | 2021-03-02 05:23:30 | LaGrange, Indiana, US |
2370292 | 2370292 | 2021-02-28 | US | South Carolina | Barnwell | 45011 | 2386 | 48 | 0 | 2338 | 33.26679302 | -81.43584352 | 2021-03-01 05:23:01 | Barnwell, South Carolina, US |
2368595 | 2368595 | 2021-02-28 | US | Indiana | LaGrange | 18087 | 2408 | 70 | 0 | 2338 | 41.64232188 | -85.42674232 | 2021-03-01 05:23:01 | LaGrange, Indiana, US |
3067239 | 3067239 | 2021-02-27 | US | Iowa | Washington | 19183 | 2385 | 47 | 0 | 2338 | 41.33577126 | -91.71725711 | 2021-02-28 05:22:20 | Washington, Iowa, US |
2184823 | 2184823 | 2021-02-26 | US | Iowa | Washington | 19183 | 2385 | 47 | 0 | 2338 | 41.33577126 | -91.71725711 | 2021-02-27 05:22:28 | Washington, Iowa, US |
1860698 | 1860698 | 2021-02-25 | US | Pennsylvania | Tioga | 42117 | 2432 | 94 | 0 | 2338 | 41.77255149 | -77.25433032 | 2021-02-26 05:22:40 | Tioga, Pennsylvania, US |
743379 | 743379 | 2021-02-20 | US | Indiana | Clay | 18021 | 2381 | 43 | 0 | 2338 | 39.39561833 | -87.11723506 | 2021-02-21 05:24:33 | Clay, Indiana, US |
473105 | 473105 | 2021-02-19 | US | Minnesota | Brown | 27015 | 2375 | 37 | 0 | 2338 | 44.24205652 | -94.72562874 | 2021-02-20 05:22:51 | Brown, Minnesota, US |
1154064 | 1154064 | 2021-02-18 | US | Idaho | Payette | 16075 | 2369 | 31 | 0 | 2338 | 44.00545243 | -116.7647695 | 2021-02-19 05:24:16 | Payette, Idaho, US |
3602196 | 3602196 | 2021-02-17 | US | Iowa | Boone | 19015 | 2368 | 30 | 0 | 2338 | 42.03657094 | -93.9313999 | 2021-02-18 05:22:58 | Boone, Iowa, US |
3601984 | 3601984 | 2021-02-17 | US | Idaho | Payette | 16075 | 2368 | 30 | 0 | 2338 | 44.00545243 | -116.7647695 | 2021-02-18 05:22:58 | Payette, Idaho, US |
3051331 | 3051331 | 2021-02-16 | US | Iowa | Boone | 19015 | 2366 | 28 | 0 | 2338 | 42.03657094 | -93.9313999 | 2021-02-17 05:23:10 | Boone, Iowa, US |
1339700 | 1339700 | 2021-02-15 | US | Kentucky | Logan | 21141 | 2388 | 50 | 0 | 2338 | 36.85949479 | -86.877635 | 2021-02-16 05:24:38 | Logan, Kentucky, US |
1339206 | 1339206 | 2021-02-15 | US | Idaho | Jefferson | 16051 | 2359 | 21 | 0 | 2338 | 43.82078483 | -112.3131749 | 2021-02-16 05:24:38 | Jefferson, Idaho, US |
2284357 | 2284357 | 2021-02-14 | US | Idaho | Jefferson | 16051 | 2359 | 21 | 0 | 2338 | 43.82078483 | -112.3131749 | 2021-02-15 05:24:49 | Jefferson, Idaho, US |
2283767 | 2283767 | 2021-02-14 | US | Alabama | Bibb | 1007 | 2395 | 57 | 0 | 2338 | 32.99642064 | -87.12511459999997 | 2021-02-15 05:24:49 | Bibb, Alabama, US |
2678757 | 2678757 | 2021-02-13 | US | Idaho | Jefferson | 16051 | 2359 | 21 | 0 | 2338 | 43.82078483 | -112.3131749 | 2021-02-14 05:23:43 | Jefferson, Idaho, US |
3978364 | 3978364 | 2021-02-10 | Chile | Biobio | 64525 | 1139 | 61048 | 2338 | -37.4464 | -72.1416 | 2021-02-11 05:23:55 | Biobio, Chile | ||
343675 | 343675 | 2021-02-03 | US | Virginia | Smyth | 51173 | 2414 | 76 | 0 | 2338 | 36.84455636 | -81.53344948 | 2021-02-04 05:22:26 | Smyth, Virginia, US |
341267 | 341267 | 2021-02-03 | US | Illinois | Jersey | 17083 | 2382 | 44 | 0 | 2338 | 39.08869046 | -90.35393073 | 2021-02-04 05:22:26 | Jersey, Illinois, US |
2484238 | 2484238 | 2021-01-28 | US | New York | Warren | 36113 | 2385 | 47 | 0 | 2338 | 43.56173026 | -73.8433699 | 2021-01-29 05:22:23 | Warren, New York, US |
3154966 | 3154966 | 2021-01-27 | US | Kentucky | Bell | 21013 | 2370 | 32 | 0 | 2338 | 36.73355174 | -83.67766671 | 2021-01-28 05:22:24 | Bell, Kentucky, US |
15814 | 15814 | 2021-01-26 | US | West Virginia | Hancock | 54029 | 2417 | 79 | 0 | 2338 | 40.51943859 | -80.57461608 | 2021-01-27 05:23:41 | Hancock, West Virginia, US |
2469016 | 2469016 | 2021-01-22 | US | New York | Allegany | 36003 | 2413 | 75 | 0 | 2338 | 42.25748406 | -78.02750466 | 2021-01-23 05:22:03 | Allegany, New York, US |
3102372 | 3102372 | 2021-01-16 | US | Idaho | Jerome | 16053 | 2355 | 17 | 0 | 2338 | 42.68891267 | -114.2655033 | 2021-01-17 05:22:17 | Jerome, Idaho, US |
3879513 | 3879513 | 2021-01-14 | India | Andhra Pradesh | 885616 | 7138 | 876140 | 2338 | 15.9129 | 79.74 | 2021-01-15 17:22 | Andhra Pradesh, India | ||
2865739 | 2865739 | 2021-01-06 | US | Illinois | Perry | 17145 | 2388 | 50 | 0 | 2338 | 38.08510853 | -89.36856219 | 2021-01-07 05:22:03 | Perry, Illinois, US |
2228498 | 2228498 | 2021-01-02 | US | Illinois | Fulton | 17057 | 2366 | 28 | 0 | 2338 | 40.47289135 | -90.20862357 | 2021-01-03 05:22:52 | Fulton, Illinois, US |
202925 | 202925 | 2020-12-25 | US | Florida | Baker | 12003 | 2374 | 36 | 0 | 2338 | 30.33060121 | -82.28467476 | 2020-12-26 05:22:28 | Baker, Florida, US |
3692148 | 3692148 | 2020-12-24 | US | Florida | Baker | 12003 | 2374 | 36 | 0 | 2338 | 30.33060121 | -82.28467476 | 2020-12-25 05:22:48 | Baker, Florida, US |
2122240 | 2122240 | 2020-12-20 | US | Oklahoma | Carter | 40019 | 2354 | 16 | 0 | 2338 | 34.25103751 | -97.28552485 | 2020-12-21 05:27:58 | Carter, Oklahoma, US |
2121527 | 2121527 | 2020-12-20 | US | Mississippi | Leflore | 28083 | 2436 | 98 | 0 | 2338 | 33.55545125 | -90.29900733 | 2020-12-21 05:27:58 | Leflore, Mississippi, US |
1903454 | 1903454 | 2020-12-18 | US | North Carolina | Carteret | 37031 | 2354 | 16 | 0 | 2338 | 34.8932941 | -76.54120135 | 2020-12-19 05:27:52 | Carteret, North Carolina, US |
2129402 | 2129402 | 2020-12-17 | US | Kentucky | Jessamine | 21113 | 2379 | 41 | 0 | 2338 | 37.87119786 | -84.58252003 | 2020-12-18 05:28:18 | Jessamine, Kentucky, US |
1752960 | 1752960 | 2020-12-14 | US | Minnesota | Carlton | 27017 | 2367 | 29 | 0 | 2338 | 46.59180601 | -92.67601019 | 2020-12-15 05:26:38 | Carlton, Minnesota, US |
1602653 | 1602653 | 2020-12-10 | US | Ohio | Belmont | 39013 | 2400 | 62 | 0 | 2338 | 40.01625942 | -80.9924051 | 2020-12-11 05:26:59 | Belmont, Ohio, US |
2976183 | 2976183 | 2020-12-09 | US | Illinois | Bureau | 17011 | 2392 | 54 | 0 | 2338 | 41.40385234 | -89.5283051 | 2020-12-10 05:26:19 | Bureau, Illinois, US |
3860030 | 3860030 | 2020-12-04 | Russia | Kabardino-Balkarian Republic | 13098 | 224 | 10536 | 2338 | 43.4806048 | 43.5978976 | 2020-12-05 05:27:36 | Kabardino-Balkarian Republic, Russia | ||
741755 | 741755 | 2020-12-02 | US | Washington | Walla Walla | 53071 | 2362 | 24 | 0 | 2338 | 46.23040051 | -118.4775539 | 2020-12-03 05:28:22 | Walla Walla, Washington, US |
1352223 | 1352223 | 2020-11-24 | US | Missouri | Johnson | 29101 | 2353 | 15 | 0 | 2338 | 38.74719601 | -93.80691168 | 2020-11-25 05:27:20 | Johnson, Missouri, US |
3192663 | 3192663 | 2020-11-22 | US | Pennsylvania | Mercer | 42085 | 2377 | 39 | 0 | 2338 | 41.30248872 | -80.25816981 | 2020-11-23 05:25:26 | Mercer, Pennsylvania, US |
123724 | 123724 | 2020-11-18 | US | Illinois | Ogle | 17141 | 2356 | 18 | 0 | 2338 | 42.04165196 | -89.32184679 | 2020-11-19 05:25:23 | Ogle, Illinois, US |
864767 | 864767 | 2020-11-12 | Italy | Valle d'Aosta | 4755 | 231 | 2186 | 2338 | 45.73750286 | 7.320149366 | 2020-11-13 05:25:30 | Valle d'Aosta, Italy | ||
272645 | 272645 | 2020-11-10 | US | Arkansas | Lincoln | 5079 | 2356 | 18 | 0 | 2338 | 33.95317155 | -91.74002806 | 2020-11-11 05:25:30 | Lincoln, Arkansas, US |
3992214 | 3992214 | 2020-10-20 | US | Michigan | Berrien | 26021 | 2418 | 80 | 0 | 2338 | 41.95447397 | -86.41313079999998 | 2020-10-21 04:24:14 | Berrien, Michigan, US |
3784568 | 3784568 | 2020-10-13 | US | Pennsylvania | Lebanon | 42075 | 2403 | 65 | 0 | 2338 | 40.36680311 | -76.45651841 | 2020-10-14 04:24:05 | Lebanon, Pennsylvania, US |
2292180 | 2292180 | 2020-10-12 | US | Georgia | Barrow | 13013 | 2385 | 47 | 0 | 2338 | 33.99148694 | -83.71436292 | 2020-10-13 04:24:02 | Barrow, Georgia, US |
819516 | 819516 | 2020-10-09 | US | Missouri | St. Francois | 29187 | 2356 | 18 | 0 | 2338 | 37.81214171 | -90.47598685 | 2020-10-10 04:23:57 | St. Francois, Missouri, US |
2382072 | 2382072 | 2020-10-01 | US | Ohio | Delaware | 39041 | 2360 | 22 | 0 | 2338 | 40.27942393 | -83.00457058 | 2020-10-02 04:23:51 | Delaware, Ohio, US |
1046756 | 1046756 | 2020-09-30 | US | Idaho | Twin Falls | 16083 | 2376 | 38 | 0 | 2338 | 42.35440512 | -114.6685381 | 2020-10-01 04:23:42 | Twin Falls, Idaho, US |
1517723 | 1517723 | 2020-09-28 | US | North Carolina | Nash | 37127 | 2377 | 39 | 0 | 2338 | 35.96575634 | -77.98422508 | 2020-09-29 04:23:42 | Nash, North Carolina, US |
3318001 | 3318001 | 2020-09-22 | US | Mississippi | Forrest | 28035 | 2409 | 71 | 0 | 2338 | 31.18961454 | -89.25832496 | 2020-09-23 04:23:00 | Forrest, Mississippi, US |
2850429 | 2850429 | 2020-09-18 | US | Massachusetts | Unassigned | 90025 | 2343 | 3 | 0 | 2338 | 42.6687626 | 0.0 | 2020-09-19 04:22:00 | Unassigned, Massachusetts, US |
1444941 | 1444941 | 2020-09-11 | US | Alabama | Elmore | 1051 | 2382 | 44 | 0 | 2338 | 32.59785413 | -86.14415284 | 2020-09-12 04:25:05 | Elmore, Alabama, US |
2174044 | 2174044 | 2020-09-09 | US | Ohio | Stark | 39151 | 2483 | 145 | 0 | 2338 | 40.81482476 | -81.36437305 | 2020-09-10 04:29:01 | Stark, Ohio, US |
197033 | 197033 | 2020-08-31 | US | Tennessee | Putnam | 47141 | 2284 | 30 | 0 | 2338 | 36.14005459 | -85.50646123 | 2020-09-01 04:28:31 | Putnam, Tennessee, US |
3931815 | 3931815 | 2020-08-30 | Chile | Biobio | 17216 | 206 | 14672 | 2338 | -37.4464 | -72.1416 | 2020-08-31 04:28:27 | Biobio, Chile | ||
3533543 | 3533543 | 2020-08-12 | US | Nebraska | Sarpy | 31153 | 2349 | 11 | 0 | 2338 | 41.11314181 | -96.11156432 | 2020-08-13 04:29:15 | Sarpy, Nebraska, US |
665119 | 665119 | 2020-08-11 | US | South Carolina | Anderson | 45007 | 2405 | 67 | 0 | 2338 | 34.51828081 | -82.63959517 | 2020-08-12 04:27:29 | Anderson, South Carolina, US |
751213 | 751213 | 2020-08-01 | US | Indiana | Hamilton | 18057 | 2446 | 108 | 0 | 2338 | 40.07306535 | -86.05244729 | 2020-08-02 04:34:47 | Hamilton, Indiana, US |
1002347 | 1002347 | 2020-07-09 | US | Iowa | Black Hawk | 19013 | 2397 | 59 | 0 | 2338 | 42.4704581 | -92.30524729 | 2020-07-10 04:34:24 | Black Hawk, Iowa, US |
415218 | 415218 | 2020-07-05 | Russia | Chuvashia Republic | 5386 | 40 | 3008 | 2338 | 55.4259922 | 47.0849429 | 2020-07-06 04:33:57 | Chuvashia Republic, Russia | ||
301177 | 301177 | 2020-07-01 | US | California | Kings | 6031 | 2368 | 30 | 0 | 2338 | 36.07409056 | -119.8159973 | 2020-07-02 04:33:46 | Kings, California, US |
1508634 | 1508634 | 2020-06-22 | US | Colorado | Jefferson | 8059 | 2685 | 209 | 0 | 2338 | 39.58635604 | -105.2517692 | 2020-06-23 04:33:22 | Jefferson, Colorado, US |
3294251 | 3294251 | 2020-05-07 | US | Ohio | Marion | 39101 | 2350 | 12 | 0 | 2338 | 40.58610662 | -83.15736305 | 2020-05-08 02:32:32 | Marion, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);