johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where confirmed = 15798 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3714682 | 3714682 | 2022-12-06 | US | Arkansas | Mississippi | 5093 | 15798 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-07 04:20:58 | Mississippi, Arkansas, US | |
3029890 | 3029890 | 2022-11-17 | US | Wisconsin | Waupaca | 55135 | 15798 | 261 | 0 | 44.47068056 | -88.96534501 | 2022-11-18 04:21:15 | Waupaca, Wisconsin, US | |
168933 | 168933 | 2022-06-21 | US | South Dakota | Lincoln | 46083 | 15798 | 102 | 0 | 43.27841182 | -96.7203905 | 2022-06-22 04:20:54 | Lincoln, South Dakota, US | |
1766216 | 1766216 | 2022-06-20 | US | South Dakota | Lincoln | 46083 | 15798 | 102 | 0 | 43.27841182 | -96.7203905 | 2022-06-21 04:20:56 | Lincoln, South Dakota, US | |
3272402 | 3272402 | 2022-06-19 | US | South Dakota | Lincoln | 46083 | 15798 | 102 | 0 | 43.27841182 | -96.7203905 | 2022-06-20 04:21:01 | Lincoln, South Dakota, US | |
3400314 | 3400314 | 2022-06-18 | US | South Dakota | Lincoln | 46083 | 15798 | 102 | 0 | 43.27841182 | -96.7203905 | 2022-06-19 04:20:51 | Lincoln, South Dakota, US | |
2314191 | 2314191 | 2022-06-17 | US | South Dakota | Lincoln | 46083 | 15798 | 102 | 0 | 43.27841182 | -96.7203905 | 2022-06-18 04:21:10 | Lincoln, South Dakota, US | |
561695 | 561695 | 2022-06-16 | US | South Dakota | Lincoln | 46083 | 15798 | 102 | 0 | 43.27841182 | -96.7203905 | 2022-06-17 04:20:56 | Lincoln, South Dakota, US | |
3985497 | 3985497 | 2022-06-15 | US | South Dakota | Lincoln | 46083 | 15798 | 102 | 0 | 43.27841182 | -96.7203905 | 2022-06-16 04:20:55 | Lincoln, South Dakota, US | |
3731107 | 3731107 | 2022-04-03 | US | Georgia | Spalding | 13255 | 15798 | 404 | 0 | 33.26310031 | -84.28013991 | 2022-04-04 04:20:51 | Spalding, Georgia, US | |
500542 | 500542 | 2022-04-02 | US | Georgia | Spalding | 13255 | 15798 | 404 | 0 | 33.26310031 | -84.28013991 | 2022-04-03 04:20:48 | Spalding, Georgia, US | |
3351527 | 3351527 | 2022-04-01 | US | Georgia | Spalding | 13255 | 15798 | 404 | 0 | 33.26310031 | -84.28013991 | 2022-04-02 04:20:47 | Spalding, Georgia, US | |
2480959 | 2480959 | 2022-03-30 | US | Tennessee | Roane | 47145 | 15798 | 230 | 0 | 35.84923189 | -84.52458689 | 2022-03-31 04:20:56 | Roane, Tennessee, US | |
161000 | 161000 | 2022-03-29 | US | Tennessee | Roane | 47145 | 15798 | 230 | 0 | 35.84923189 | -84.52458689 | 2022-03-30 04:20:45 | Roane, Tennessee, US | |
1439571 | 1439571 | 2022-03-28 | US | Tennessee | Roane | 47145 | 15798 | 230 | 0 | 35.84923189 | -84.52458689 | 2022-03-29 04:20:46 | Roane, Tennessee, US | |
338594 | 338594 | 2022-03-18 | US | Pennsylvania | Carbon | 42025 | 15798 | 288 | 0 | 40.91545395 | -75.7068525 | 2022-03-19 04:20:47 | Carbon, Pennsylvania, US | |
1466552 | 1466552 | 2022-02-10 | US | Ohio | Geauga | 39055 | 15798 | 264 | 0 | 41.49952319 | -81.17935342 | 2022-02-11 04:21:09 | Geauga, Ohio, US | |
1080723 | 1080723 | 2021-12-09 | US | Rhode Island | Unassigned | 90044 | 15798 | 16 | 0 | 41.87064746 | 0.0 | 2021-12-10 04:22:28 | Unassigned, Rhode Island, US | |
2282123 | 2282123 | 2021-09-08 | US | Tennessee | Madison | 47113 | 15798 | 272 | 0 | 35.61181957 | -88.84076036 | 2021-09-09 04:21:27 | Madison, Tennessee, US | |
2351770 | 2351770 | 2021-08-10 | Taiwan* | 15798 | 814 | 0 | 23.7 | 121.0 | 2021-08-11 04:21:58 | Taiwan* | ||||
3470017 | 3470017 | 2021-08-03 | US | Mississippi | Rankin | 28121 | 15798 | 293 | 0 | 32.26469147 | -89.94537876 | 2021-08-04 04:21:25 | Rankin, Mississippi, US | |
3904311 | 3904311 | 2021-07-31 | Togo | 15798 | 152 | 14450 | 1196 | 8.6195 | 0.8248 | 2021-08-01 04:21:50 | Togo | |||
2587896 | 2587896 | 2021-06-05 | US | Missouri | Jasper | 29097 | 15798 | 239 | 0 | 37.20351921 | -94.34050458 | 2021-06-06 04:24:03 | Jasper, Missouri, US | |
2550631 | 2550631 | 2021-04-15 | US | Minnesota | Scott | 27139 | 15798 | 117 | 0 | 44.6490231 | -93.53340251 | 2021-04-16 04:20:46 | Scott, Minnesota, US | |
2369070 | 2369070 | 2021-02-28 | US | Maryland | Howard | 24027 | 15798 | 220 | 0 | 15578 | 39.25305293 | -76.93126208 | 2021-03-01 05:23:01 | Howard, Maryland, US |
2637905 | 2637905 | 2021-02-11 | Russia | Altai Republic | 15798 | 139 | 14955 | 704 | 50.7114101 | 86.8572186 | 2021-02-12 05:23:29 | Altai Republic, Russia | ||
2931468 | 2931468 | 2020-12-19 | Russia | Tambov Oblast | 15798 | 155 | 13983 | 1660 | 52.9019574 | 41.3578918 | 2020-12-20 05:27:32 | Tambov Oblast, Russia | ||
679698 | 679698 | 2020-11-23 | US | Kentucky | Fayette | 21067 | 15798 | 105 | 0 | 15693 | 38.0368225 | -84.45576892 | 2020-11-24 05:27:31 | Fayette, Kentucky, US |
892964 | 892964 | 2020-11-05 | US | Georgia | Out of GA | 80013 | 15798 | 219 | 0 | 15579 | 34.91369188 | 0.0 | 2020-11-06 05:24:55 | Out of GA, Georgia, US |
3789523 | 3789523 | 2020-10-11 | Ukraine | Ternopil Oblast | 15798 | 203 | 10901 | 4694 | 49.5535 | 25.5948 | 2020-10-12 04:23:45 | Ternopil Oblast, Ukraine |
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]);