johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where confirmed = 13666 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756509 | 2756509 | 2022-12-29 | US | Wyoming | Campbell | 56005 | 13666 | 156 | 0 | 44.24886082 | -105.5474404 | 2022-12-30 04:21:04 | Campbell, Wyoming, US | |
1077515 | 1077515 | 2022-12-28 | US | Wyoming | Campbell | 56005 | 13666 | 156 | 0 | 44.24886082 | -105.5474404 | 2022-12-29 04:21:01 | Campbell, Wyoming, US | |
331512 | 331512 | 2022-12-27 | US | Wyoming | Campbell | 56005 | 13666 | 156 | 0 | 44.24886082 | -105.5474404 | 2022-12-28 04:21:04 | Campbell, Wyoming, US | |
1626211 | 1626211 | 2022-09-22 | US | Missouri | Johnson | 29101 | 13666 | 148 | 0 | 38.74719601 | -93.80691168 | 2022-09-23 04:23:13 | Johnson, Missouri, US | |
1372415 | 1372415 | 2022-09-21 | US | Missouri | Johnson | 29101 | 13666 | 148 | 0 | 38.74719601 | -93.80691168 | 2022-09-22 04:22:56 | Johnson, Missouri, US | |
2018645 | 2018645 | 2022-09-20 | US | Missouri | Johnson | 29101 | 13666 | 148 | 0 | 38.74719601 | -93.80691168 | 2022-09-21 04:23:22 | Johnson, Missouri, US | |
3572518 | 3572518 | 2022-09-19 | US | Missouri | Johnson | 29101 | 13666 | 148 | 0 | 38.74719601 | -93.80691168 | 2022-09-20 04:22:48 | Johnson, Missouri, US | |
421257 | 421257 | 2022-09-18 | US | Missouri | Johnson | 29101 | 13666 | 148 | 0 | 38.74719601 | -93.80691168 | 2022-09-19 04:21:49 | Johnson, Missouri, US | |
3375281 | 3375281 | 2022-09-17 | US | Missouri | Johnson | 29101 | 13666 | 148 | 0 | 38.74719601 | -93.80691168 | 2022-09-18 04:22:50 | Johnson, Missouri, US | |
2357389 | 2357389 | 2022-09-16 | US | Missouri | Johnson | 29101 | 13666 | 148 | 0 | 38.74719601 | -93.80691168 | 2022-09-17 04:20:19 | Johnson, Missouri, US | |
3112491 | 3112491 | 2022-07-13 | US | Tennessee | Warren | 47177 | 13666 | 181 | 0 | 35.6728299 | -85.77969117 | 2022-07-14 04:20:57 | Warren, Tennessee, US | |
2253579 | 2253579 | 2022-04-19 | US | New Hampshire | Belknap | 33001 | 13666 | 175 | 0 | 43.51637314 | -71.41684235 | 2022-04-20 04:20:45 | Belknap, New Hampshire, US | |
3856313 | 3856313 | 2022-02-18 | US | Arkansas | Crittenden | 5035 | 13666 | 208 | 0 | 35.21247318 | -90.30839406 | 2022-02-19 04:21:11 | Crittenden, Arkansas, US | |
3672684 | 3672684 | 2022-02-15 | US | Illinois | Ogle | 17141 | 13666 | 128 | 0 | 42.04165196 | -89.32184679 | 2022-02-16 04:21:10 | Ogle, Illinois, US | |
407847 | 407847 | 2021-12-07 | US | Wisconsin | Jefferson | 55055 | 13666 | 168 | 0 | 43.02054068 | -88.77529134 | 2021-12-08 04:22:46 | Jefferson, Wisconsin, US | |
1033929 | 1033929 | 2021-12-06 | US | Wisconsin | Jefferson | 55055 | 13666 | 168 | 0 | 43.02054068 | -88.77529134 | 2021-12-07 04:22:34 | Jefferson, Wisconsin, US | |
1744092 | 1744092 | 2021-12-05 | US | Wisconsin | Jefferson | 55055 | 13666 | 168 | 0 | 43.02054068 | -88.77529134 | 2021-12-06 04:22:34 | Jefferson, Wisconsin, US | |
141524 | 141524 | 2021-12-04 | US | Wisconsin | Jefferson | 55055 | 13666 | 168 | 0 | 43.02054068 | -88.77529134 | 2021-12-05 04:22:25 | Jefferson, Wisconsin, US | |
2199177 | 2199177 | 2021-12-03 | US | Wisconsin | Jefferson | 55055 | 13666 | 168 | 0 | 43.02054068 | -88.77529134 | 2021-12-04 04:22:18 | Jefferson, Wisconsin, US | |
290341 | 290341 | 2021-10-31 | US | North Carolina | Moore | 37125 | 13666 | 247 | 0 | 35.30885257 | -79.48474178 | 2021-11-01 04:22:01 | Moore, North Carolina, US | |
2723347 | 2723347 | 2021-10-30 | US | North Carolina | Moore | 37125 | 13666 | 247 | 0 | 35.30885257 | -79.48474178 | 2021-10-31 04:22:08 | Moore, North Carolina, US | |
569449 | 569449 | 2021-10-29 | US | North Carolina | Moore | 37125 | 13666 | 247 | 0 | 35.30885257 | -79.48474178 | 2021-10-30 04:22:03 | Moore, North Carolina, US | |
1887289 | 1887289 | 2021-09-12 | US | North Carolina | Brunswick | 37019 | 13666 | 187 | 0 | 34.070565 | -78.22814204 | 2021-09-13 04:21:15 | Brunswick, North Carolina, US | |
3808192 | 3808192 | 2021-09-11 | US | North Carolina | Brunswick | 37019 | 13666 | 187 | 0 | 34.070565 | -78.22814204 | 2021-09-12 04:21:13 | Brunswick, North Carolina, US | |
3451132 | 3451132 | 2021-09-10 | US | North Carolina | Brunswick | 37019 | 13666 | 187 | 0 | 34.070565 | -78.22814204 | 2021-09-11 04:21:30 | Brunswick, North Carolina, US | |
2282746 | 2282746 | 2021-09-08 | US | Wisconsin | Walworth | 55127 | 13666 | 177 | 0 | 42.66858202 | -88.54163073 | 2021-09-09 04:21:27 | Walworth, Wisconsin, US | |
3383181 | 3383181 | 2021-06-13 | US | Mississippi | Jackson | 28059 | 13666 | 248 | 0 | 30.54020656 | -88.64184064 | 2021-06-14 04:22:46 | Jackson, Mississippi, US | |
1738315 | 1738315 | 2021-06-12 | US | Mississippi | Jackson | 28059 | 13666 | 248 | 0 | 30.54020656 | -88.64184064 | 2021-06-13 04:22:44 | Jackson, Mississippi, US | |
3972356 | 3972356 | 2021-06-11 | US | Mississippi | Jackson | 28059 | 13666 | 248 | 0 | 30.54020656 | -88.64184064 | 2021-06-12 04:22:22 | Jackson, Mississippi, US | |
1313132 | 1313132 | 2021-05-26 | US | Tennessee | Maury | 47119 | 13666 | 173 | 0 | 35.6187413 | -87.07462444 | 2021-05-27 04:20:59 | Maury, Tennessee, US | |
3057728 | 3057728 | 2021-05-13 | US | Wisconsin | Fond du Lac | 55039 | 13666 | 121 | 0 | 43.75354908 | -88.48885325 | 2021-05-14 04:20:41 | Fond du Lac, Wisconsin, US | |
1095761 | 1095761 | 2021-01-20 | US | Michigan | Saginaw | 26145 | 13666 | 455 | 0 | 13211 | 43.33433923 | -84.05131209999998 | 2021-01-21 05:22:01 | Saginaw, Michigan, US |
1094315 | 1094315 | 2021-01-20 | Russia | North Ossetia - Alania Republic | 13666 | 105 | 12143 | 1418 | 42.79336110000001 | 44.6324493 | 2021-01-21 05:22:01 | North Ossetia - Alania Republic, Russia | ||
2227741 | 2227741 | 2021-01-02 | Russia | Mordovia Republic | 13666 | 95 | 11294 | 2277 | 54.4419829 | 44.4661144 | 2021-01-03 05:22:52 | Mordovia Republic, Russia | ||
3994125 | 3994125 | 2020-10-20 | US | Wisconsin | Brown | 55009 | 13666 | 86 | 0 | 13580 | 44.4526553 | -88.00411844 | 2020-10-21 04:24:14 | Brown, Wisconsin, US |
1245347 | 1245347 | 2020-09-08 | US | Massachusetts | Worcester | 25027 | 13666 | 963 | 0 | 12605 | 42.35026951 | -71.90493363 | 2020-09-09 04:28:48 | Worcester, Massachusetts, US |
174751 | 174751 | 2020-07-27 | US | California | Fresno | 6019 | 13666 | 117 | 0 | 13529 | 36.75733899 | -119.6466953 | 2020-07-28 04:58:43 | Fresno, California, 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]);