johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where confirmed = 16468 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2147987 | 2147987 | 2022-06-27 | US | Alabama | Autauga | 1001 | 16468 | 217 | 0 | 32.53952745 | -86.64408227 | 2022-06-28 04:20:58 | Autauga, Alabama, US | |
3272446 | 3272446 | 2022-06-19 | US | Tennessee | Cumberland | 47035 | 16468 | 329 | 0 | 35.95271721 | -84.99840585 | 2022-06-20 04:21:01 | Cumberland, Tennessee, US | |
2982795 | 2982795 | 2022-06-13 | US | Wisconsin | Columbia | 55021 | 16468 | 130 | 0 | 43.46492199 | -89.33589004 | 2022-06-14 04:20:52 | Columbia, Wisconsin, US | |
3889198 | 3889198 | 2022-06-06 | US | Maryland | Cecil | 24015 | 16468 | 259 | 0 | 39.56647682 | -75.94627411 | 2022-06-07 04:21:08 | Cecil, Maryland, US | |
1851706 | 1851706 | 2022-05-26 | US | Minnesota | Crow Wing | 27035 | 16468 | 171 | 0 | 46.48096553 | -94.06755609 | 2022-05-27 04:20:56 | Crow Wing, Minnesota, US | |
360903 | 360903 | 2022-05-07 | US | California | Mendocino | 6045 | 16468 | 127 | 0 | 39.4381191 | -123.3911313 | 2022-05-08 04:20:49 | Mendocino, California, US | |
1659334 | 1659334 | 2022-03-19 | US | Tennessee | Carter | 47019 | 16468 | 326 | 0 | 36.28969086 | -82.12588974 | 2022-03-20 04:20:45 | Carter, Tennessee, US | |
1548589 | 1548589 | 2022-03-07 | US | Colorado | Eagle | 8037 | 16468 | 35 | 0 | 39.62754308 | -106.6933637 | 2022-03-08 04:20:54 | Eagle, Colorado, US | |
461655 | 461655 | 2022-02-02 | US | New York | Tompkins | 36109 | 16468 | 77 | 0 | 42.44945765 | -76.47229843 | 2022-02-03 04:21:21 | Tompkins, New York, US | |
1320580 | 1320580 | 2022-01-26 | US | North Carolina | Sampson | 37163 | 16468 | 147 | 0 | 34.98820368 | -78.36914061 | 2022-01-27 04:21:19 | Sampson, North Carolina, US | |
87196 | 87196 | 2021-11-09 | Mali | 16468 | 579 | 0 | 17.570692 | -3.996166000000001 | 2021-11-10 04:21:38 | Mali | ||||
707099 | 707099 | 2021-09-29 | US | Connecticut | Litchfield | 9005 | 16468 | 313 | 0 | 41.7937534 | -73.2451475 | 2021-09-30 04:21:20 | Litchfield, Connecticut, US | |
2675591 | 2675591 | 2021-07-18 | US | Minnesota | Wright | 27171 | 16468 | 151 | 0 | 45.17297924 | -93.96234781 | 2021-07-19 04:21:24 | Wright, Minnesota, US | |
3707903 | 3707903 | 2021-07-17 | US | Minnesota | Wright | 27171 | 16468 | 151 | 0 | 45.17297924 | -93.96234781 | 2021-07-18 04:22:07 | Wright, Minnesota, US | |
2949134 | 2949134 | 2021-07-16 | US | Minnesota | Wright | 27171 | 16468 | 151 | 0 | 45.17297924 | -93.96234781 | 2021-07-17 04:22:22 | Wright, Minnesota, US | |
2106584 | 2106584 | 2021-06-01 | US | Ohio | Fairfield | 39045 | 16468 | 205 | 0 | 39.75107189 | -82.63088163 | 2021-06-02 04:24:34 | Fairfield, Ohio, US | |
1914627 | 1914627 | 2021-05-20 | US | Kentucky | Kenton | 21117 | 16468 | 177 | 0 | 38.93950319 | -84.53241199 | 2021-05-21 04:20:43 | Kenton, Kentucky, US | |
640992 | 640992 | 2021-03-31 | US | Texas | Ector | 48135 | 16468 | 351 | 0 | 31.86898877 | -102.5429428 | 2021-04-01 04:27:05 | Ector, Texas, US | |
1292797 | 1292797 | 2021-03-29 | US | South Carolina | Aiken | 45003 | 16468 | 215 | 0 | 33.54338026 | -81.63645384 | 2021-03-30 04:26:23 | Aiken, South Carolina, US | |
3231073 | 3231073 | 2021-01-03 | US | Colorado | Larimer | 8069 | 16468 | 180 | 0 | 15216 | 40.66671597 | -105.4625784 | 2021-01-04 05:22:02 | Larimer, Colorado, US |
1122160 | 1122160 | 2020-09-17 | US | California | Stanislaus | 6099 | 16468 | 341 | 0 | 16211 | 37.55862499 | -120.9970722 | 2020-09-18 05:05:00 | Stanislaus, 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]);