johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
73 rows where confirmed = 9554 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2136679 | 2136679 | 2022-12-01 | US | Arkansas | Poinsett | 5111 | 9554 | 138 | 0 | 35.57433534 | -90.66268713 | 2022-12-02 04:21:07 | Poinsett, Arkansas, US | |
1968077 | 1968077 | 2022-11-30 | US | West Virginia | Mingo | 54059 | 9554 | 132 | 0 | 37.73048351 | -82.13338365 | 2022-12-01 04:21:03 | Mingo, West Virginia, US | |
3600436 | 3600436 | 2022-11-14 | US | Virginia | Petersburg | 51730 | 9554 | 145 | 0 | 37.20530399 | -77.39368102 | 2022-11-15 04:21:16 | Petersburg, Virginia, US | |
315294 | 315294 | 2022-11-13 | US | Virginia | Petersburg | 51730 | 9554 | 145 | 0 | 37.20530399 | -77.39368102 | 2022-11-14 04:21:09 | Petersburg, Virginia, US | |
66455 | 66455 | 2022-11-12 | US | Virginia | Petersburg | 51730 | 9554 | 145 | 0 | 37.20530399 | -77.39368102 | 2022-11-13 04:21:14 | Petersburg, Virginia, US | |
2930617 | 2930617 | 2022-11-11 | US | Virginia | Petersburg | 51730 | 9554 | 145 | 0 | 37.20530399 | -77.39368102 | 2022-11-12 04:20:41 | Petersburg, Virginia, US | |
2998086 | 2998086 | 2022-10-01 | US | Puerto Rico | Yauco | 72153 | 9554 | 0 | 0 | 18.080374 | -66.858814 | 2022-10-02 04:21:23 | Yauco, Puerto Rico, US | |
1164638 | 1164638 | 2022-08-18 | US | Washington | Whitman | 53075 | 9554 | 96 | 0 | 46.90022523 | -117.5241763 | 2022-08-19 04:20:54 | Whitman, Washington, US | |
3953962 | 3953962 | 2022-08-17 | US | Washington | Whitman | 53075 | 9554 | 96 | 0 | 46.90022523 | -117.5241763 | 2022-08-18 04:21:11 | Whitman, Washington, US | |
2009643 | 2009643 | 2022-08-04 | US | Idaho | Nez Perce | 16069 | 9554 | 152 | 0 | 46.32638236 | -116.7500975 | 2022-08-05 04:20:52 | Nez Perce, Idaho, US | |
1099070 | 1099070 | 2022-08-03 | US | Idaho | Nez Perce | 16069 | 9554 | 152 | 0 | 46.32638236 | -116.7500975 | 2022-08-04 04:20:58 | Nez Perce, Idaho, US | |
670765 | 670765 | 2022-07-21 | US | Arkansas | Baxter | 5005 | 9554 | 252 | 0 | 36.28784385 | -92.33782872 | 2022-07-22 04:21:15 | Baxter, Arkansas, US | |
1650124 | 1650124 | 2022-06-23 | US | Minnesota | Morrison | 27097 | 9554 | 106 | 0 | 46.01265363 | -94.27341528 | 2022-06-24 04:20:58 | Morrison, Minnesota, US | |
1649483 | 1649483 | 2022-06-23 | US | Indiana | Jefferson | 18077 | 9554 | 162 | 0 | 38.78576239 | -85.43633383 | 2022-06-24 04:20:58 | Jefferson, Indiana, US | |
2188718 | 2188718 | 2022-06-22 | US | Indiana | Jefferson | 18077 | 9554 | 162 | 0 | 38.78576239 | -85.43633383 | 2022-06-23 04:20:55 | Jefferson, Indiana, US | |
1424046 | 1424046 | 2022-06-08 | US | Tennessee | Giles | 47055 | 9554 | 195 | 0 | 35.20222469 | -87.03992678 | 2022-06-09 04:20:54 | Giles, Tennessee, US | |
3724356 | 3724356 | 2022-04-25 | US | New Hampshire | Carroll | 33003 | 9554 | 60 | 0 | 43.87498583 | -71.20430216 | 2022-04-26 04:20:51 | Carroll, New Hampshire, US | |
1846483 | 1846483 | 2022-04-18 | US | Arkansas | Miller | 5091 | 9554 | 176 | 0 | 33.31403423 | -93.89285258 | 2022-04-19 04:21:00 | Miller, Arkansas, US | |
3417427 | 3417427 | 2022-04-17 | US | Arkansas | Miller | 5091 | 9554 | 176 | 0 | 33.31403423 | -93.89285258 | 2022-04-18 04:21:12 | Miller, Arkansas, US | |
304376 | 304376 | 2022-04-16 | US | Arkansas | Miller | 5091 | 9554 | 175 | 0 | 33.31403423 | -93.89285258 | 2022-04-17 04:20:59 | Miller, Arkansas, US | |
3870794 | 3870794 | 2022-04-05 | US | Texas | Waller | 48473 | 9554 | 107 | 0 | 30.01058447 | -95.99011759 | 2022-04-06 04:20:49 | Waller, Texas, US | |
2143324 | 2143324 | 2022-03-09 | US | Texas | Lamar | 48277 | 9554 | 250 | 0 | 33.66981763 | -95.57404777 | 2022-03-10 04:20:48 | Lamar, Texas, US | |
3915540 | 3915540 | 2022-02-20 | US | West Virginia | Wayne | 54099 | 9554 | 102 | 0 | 38.14901357 | -82.42287994 | 2022-02-21 04:21:05 | Wayne, West Virginia, US | |
3879098 | 3879098 | 2022-02-19 | US | West Virginia | Wayne | 54099 | 9554 | 102 | 0 | 38.14901357 | -82.42287994 | 2022-02-20 04:21:00 | Wayne, West Virginia, US | |
3859354 | 3859354 | 2022-02-18 | US | West Virginia | Wayne | 54099 | 9554 | 102 | 0 | 38.14901357 | -82.42287994 | 2022-02-19 04:21:11 | Wayne, West Virginia, US | |
3822927 | 3822927 | 2022-02-16 | US | Ohio | Madison | 39097 | 9554 | 126 | 0 | 39.89381073 | -83.40178317 | 2022-02-17 04:20:56 | Madison, Ohio, US | |
3671656 | 3671656 | 2022-02-15 | Japan | Kochi | 9554 | 51 | 0 | 33.422519 | 133.367307 | 2022-02-16 04:21:10 | Kochi, Japan | |||
2642782 | 2642782 | 2022-02-14 | US | Illinois | Montgomery | 17135 | 9554 | 96 | 0 | 39.23198845 | -89.47809254 | 2022-02-15 04:21:09 | Montgomery, Illinois, US | |
1467258 | 1467258 | 2022-02-10 | US | Texas | Medina | 48325 | 9554 | 186 | 0 | 29.355730100000002 | -99.11030298 | 2022-02-11 04:21:09 | Medina, Texas, US | |
3841169 | 3841169 | 2022-01-15 | US | Colorado | Summit | 8117 | 9554 | 13 | 0 | 39.63803232 | -106.1150762 | 2022-01-16 04:21:12 | Summit, Colorado, US | |
1693733 | 1693733 | 2022-01-10 | US | Kentucky | Henderson | 21101 | 9554 | 135 | 0 | 37.79344553 | -87.57392021 | 2022-01-11 04:22:01 | Henderson, Kentucky, US | |
3522980 | 3522980 | 2022-01-02 | US | Wisconsin | Grant | 55043 | 9554 | 127 | 0 | 42.8671731 | -90.7063218 | 2022-01-03 02:22:25 | Grant, Wisconsin, US | |
2171110 | 2171110 | 2022-01-01 | US | Wisconsin | Grant | 55043 | 9554 | 127 | 0 | 42.8671731 | -90.7063218 | 2022-01-02 04:20:52 | Grant, Wisconsin, US | |
2780541 | 2780541 | 2021-12-31 | US | Wisconsin | Grant | 55043 | 9554 | 127 | 0 | 42.8671731 | -90.7063218 | 2022-01-01 04:22:14 | Grant, Wisconsin, US | |
3403057 | 3403057 | 2021-11-30 | US | Michigan | Barry | 26015 | 9554 | 102 | 0 | 42.59513984 | -85.30834519 | 2021-12-01 04:22:29 | Barry, Michigan, US | |
151600 | 151600 | 2021-11-29 | US | Michigan | Barry | 26015 | 9554 | 102 | 0 | 42.59513984 | -85.30834519 | 2021-11-30 04:22:53 | Barry, Michigan, US | |
2848260 | 2848260 | 2021-11-10 | US | Virginia | Rockingham | 51165 | 9554 | 163 | 0 | 38.51006137 | -78.87260325 | 2021-11-11 04:21:45 | Rockingham, Virginia, US | |
276952 | 276952 | 2021-11-03 | US | Georgia | Catoosa | 13047 | 9554 | 111 | 0 | 34.89872298 | -85.13757014 | 2021-11-04 04:22:20 | Catoosa, Georgia, US | |
570066 | 570066 | 2021-10-29 | US | Tennessee | Lawrence | 47099 | 9554 | 125 | 0 | 35.21675201 | -87.39787695 | 2021-10-30 04:22:03 | Lawrence, Tennessee, US | |
3009414 | 3009414 | 2021-10-11 | US | Nebraska | Hall | 31079 | 9554 | 117 | 0 | 40.87257079 | -98.50218293 | 2021-10-12 04:21:09 | Hall, Nebraska, US | |
425430 | 425430 | 2021-10-10 | US | Nebraska | Hall | 31079 | 9554 | 117 | 0 | 40.87257079 | -98.50218293 | 2021-10-11 04:21:31 | Hall, Nebraska, US | |
2878287 | 2878287 | 2021-10-09 | US | Nebraska | Hall | 31079 | 9554 | 117 | 0 | 40.87257079 | -98.50218293 | 2021-10-10 04:21:38 | Hall, Nebraska, US | |
2961453 | 2961453 | 2021-10-08 | US | Nebraska | Hall | 31079 | 9554 | 117 | 0 | 40.87257079 | -98.50218293 | 2021-10-09 04:21:34 | Hall, Nebraska, US | |
988068 | 988068 | 2021-10-04 | US | Indiana | Grant | 18053 | 9554 | 212 | 0 | 40.51587228 | -85.65468702 | 2021-10-05 04:21:27 | Grant, Indiana, US | |
3930998 | 3930998 | 2021-10-02 | US | Tennessee | Jefferson | 47089 | 9554 | 135 | 0 | 36.04818632 | -83.45148924 | 2021-10-03 04:21:24 | Jefferson, Tennessee, US | |
3282692 | 3282692 | 2021-09-05 | US | Mississippi | Lowndes | 28087 | 9554 | 164 | 0 | 33.47386518 | -88.44191529999998 | 2021-09-06 04:21:22 | Lowndes, Mississippi, US | |
251106 | 251106 | 2021-09-04 | US | Mississippi | Lowndes | 28087 | 9554 | 164 | 0 | 33.47386518 | -88.44191529999998 | 2021-09-05 04:21:33 | Lowndes, Mississippi, US | |
3976387 | 3976387 | 2021-09-03 | US | Mississippi | Lowndes | 28087 | 9554 | 164 | 0 | 33.47386518 | -88.44191529999998 | 2021-09-04 04:21:28 | Lowndes, Mississippi, US | |
3975627 | 3975627 | 2021-09-03 | US | Indiana | Bartholomew | 18005 | 9554 | 161 | 0 | 39.20744865 | -85.89558181 | 2021-09-04 04:21:28 | Bartholomew, Indiana, US | |
35227 | 35227 | 2021-08-25 | US | South Carolina | Darlington | 45031 | 9554 | 186 | 0 | 34.33358335 | -79.96027485 | 2021-08-26 04:21:28 | Darlington, South Carolina, US | |
3167005 | 3167005 | 2021-08-23 | US | Kentucky | Campbell | 21037 | 9554 | 81 | 0 | 38.94384345 | -84.37875208 | 2021-08-24 04:21:19 | Campbell, Kentucky, US | |
2177151 | 2177151 | 2021-08-22 | US | Massachusetts | Hampshire | 25015 | 9554 | 235 | 0 | 42.33997957 | -72.65898478 | 2021-08-23 04:21:27 | Hampshire, Massachusetts, US | |
3557247 | 3557247 | 2021-08-21 | US | Massachusetts | Hampshire | 25015 | 9554 | 235 | 0 | 42.33997957 | -72.65898478 | 2021-08-22 04:21:29 | Hampshire, Massachusetts, US | |
1855589 | 1855589 | 2021-08-20 | US | Massachusetts | Hampshire | 25015 | 9554 | 235 | 0 | 42.33997957 | -72.65898478 | 2021-08-21 04:21:38 | Hampshire, Massachusetts, US | |
514193 | 514193 | 2021-08-19 | US | Ohio | Muskingum | 39119 | 9554 | 142 | 0 | 39.96575964 | -81.94363275 | 2021-08-20 04:21:33 | Muskingum, Ohio, US | |
1807845 | 1807845 | 2021-05-27 | US | Indiana | Kosciusko | 18085 | 9554 | 117 | 0 | 41.24521668 | -85.86312322 | 2021-05-28 04:20:36 | Kosciusko, Indiana, US | |
1953094 | 1953094 | 2021-05-21 | US | California | Sutter | 6101 | 9554 | 113 | 0 | 39.03417539 | -121.6945899 | 2021-05-22 04:20:45 | Sutter, California, US | |
2453146 | 2453146 | 2021-05-02 | US | North Carolina | Wilson | 37195 | 9554 | 171 | 0 | 35.70625477 | -77.917978 | 2021-05-03 04:20:39 | Wilson, North Carolina, US | |
2827159 | 2827159 | 2021-05-01 | US | North Carolina | Wilson | 37195 | 9554 | 171 | 0 | 35.70625477 | -77.917978 | 2021-05-02 04:20:48 | Wilson, North Carolina, US | |
382567 | 382567 | 2021-04-30 | US | North Carolina | Wilson | 37195 | 9554 | 171 | 0 | 35.70625477 | -77.917978 | 2021-05-01 04:20:47 | Wilson, North Carolina, US | |
3924371 | 3924371 | 2021-04-24 | US | Alabama | Cullman | 1043 | 9554 | 191 | 0 | 34.13020303 | -86.86888037 | 2021-04-25 04:20:32 | Cullman, Alabama, US | |
391462 | 391462 | 2021-04-04 | US | Texas | Walker | 48471 | 9554 | 123 | 0 | 30.73872995 | -95.57440968 | 2021-04-05 04:20:35 | Walker, Texas, US | |
2056165 | 2056165 | 2021-03-15 | South Sudan | 9554 | 104 | 7906 | 1544 | 6.877000000000002 | 31.307 | 2021-03-16 05:25:13 | South Sudan | |||
2229677 | 2229677 | 2021-01-02 | US | New Jersey | Cumberland | 34011 | 9554 | 231 | 0 | 9323 | 39.37199394 | -75.10712559 | 2021-01-03 05:22:52 | Cumberland, New Jersey, US |
1904356 | 1904356 | 2020-12-18 | US | Texas | Randall | 48381 | 9554 | 151 | 0 | 12920 | 34.96585996 | -101.8971322 | 2020-12-19 05:27:52 | Randall, Texas, US |
2537590 | 2537590 | 2020-12-01 | Russia | Ingushetia Republic | 9554 | 113 | 8094 | 1347 | 43.11542075 | 45.01713552 | 2020-12-02 05:27:41 | Ingushetia Republic, Russia | ||
1973620 | 1973620 | 2020-11-25 | US | Illinois | Sangamon | 17167 | 9554 | 88 | 0 | 9466 | 39.75836914 | -89.65872023 | 2020-11-26 05:27:44 | Sangamon, Illinois, US |
2194237 | 2194237 | 2020-10-21 | US | Pennsylvania | Bucks | 42017 | 9554 | 623 | 0 | 8931 | 40.33682119 | -75.10836643 | 2020-10-22 04:24:27 | Bucks, Pennsylvania, US |
583531 | 583531 | 2020-08-13 | US | Florida | Manatee | 12081 | 9554 | 242 | 0 | 9312 | 27.47196942 | -82.31831044 | 2020-08-14 04:51:19 | Manatee, Florida, US |
3610734 | 3610734 | 2020-08-06 | US | Alabama | Mobile | 1097 | 9554 | 204 | 0 | 9350 | 30.78472347 | -88.20842409 | 2020-08-07 04:35:11 | Mobile, Alabama, US |
61869 | 61869 | 2020-07-23 | Spain | Galicia | 9554 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-24 05:30:40 | Galicia, Spain | ||
3737404 | 3737404 | 2020-07-12 | Peru | Ancash | 9554 | 1441 | 0 | 8113 | -9.407125 | -77.67179499999997 | 2020-07-13 04:43:04 | Ancash, Peru | ||
3363895 | 3363895 | 2020-04-01 | US | New York | Nassau | 36059 | 9554 | 76 | 0 | 9478 | 40.74066522 | -73.58941873 | 2020-04-01 21:58:49 | Nassau, New York, 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]);