johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where confirmed = 14207 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
722054 | 722054 | 2022-12-04 | US | Wisconsin | Monroe | 55081 | 14207 | 105 | 0 | 43.94641218 | -90.618819 | 2022-12-05 04:20:58 | Monroe, Wisconsin, US | |
2820343 | 2820343 | 2022-12-03 | US | Wisconsin | Monroe | 55081 | 14207 | 105 | 0 | 43.94641218 | -90.618819 | 2022-12-04 04:20:56 | Monroe, Wisconsin, US | |
837199 | 837199 | 2022-12-02 | US | Wisconsin | Monroe | 55081 | 14207 | 105 | 0 | 43.94641218 | -90.618819 | 2022-12-03 04:21:02 | Monroe, Wisconsin, US | |
3552704 | 3552704 | 2022-11-27 | US | Illinois | Stephenson | 17177 | 14207 | 177 | 0 | 42.35129217 | -89.662598 | 2022-11-28 04:21:02 | Stephenson, Illinois, US | |
2101184 | 2101184 | 2022-11-26 | US | Illinois | Stephenson | 17177 | 14207 | 177 | 0 | 42.35129217 | -89.662598 | 2022-11-27 04:21:05 | Stephenson, Illinois, US | |
488675 | 488675 | 2022-11-25 | US | Illinois | Stephenson | 17177 | 14207 | 177 | 0 | 42.35129217 | -89.662598 | 2022-11-26 04:21:11 | Stephenson, Illinois, US | |
3524504 | 3524504 | 2022-11-24 | US | Illinois | Stephenson | 17177 | 14207 | 177 | 0 | 42.35129217 | -89.662598 | 2022-11-25 04:21:06 | Stephenson, Illinois, US | |
3313287 | 3313287 | 2022-11-23 | US | Illinois | Stephenson | 17177 | 14207 | 177 | 0 | 42.35129217 | -89.662598 | 2022-11-24 04:21:09 | Stephenson, Illinois, US | |
1053027 | 1053027 | 2022-11-06 | US | Texas | Nacogdoches | 48347 | 14207 | 270 | 0 | 31.62017125 | -94.61803994 | 2022-11-07 04:21:26 | Nacogdoches, Texas, US | |
621051 | 621051 | 2022-11-05 | US | Texas | Nacogdoches | 48347 | 14207 | 270 | 0 | 31.62017125 | -94.61803994 | 2022-11-06 04:21:24 | Nacogdoches, Texas, US | |
1025555 | 1025555 | 2022-11-04 | US | Texas | Nacogdoches | 48347 | 14207 | 270 | 0 | 31.62017125 | -94.61803994 | 2022-11-05 04:21:52 | Nacogdoches, Texas, US | |
2830354 | 2830354 | 2022-08-25 | US | Louisiana | St. Mary | 22101 | 14207 | 273 | 0 | 29.69262097 | -91.44702164 | 2022-08-26 04:21:02 | St. Mary, Louisiana, US | |
562403 | 562403 | 2022-06-16 | US | Wisconsin | Waupaca | 55135 | 14207 | 257 | 0 | 44.47068056 | -88.96534501 | 2022-06-17 04:20:56 | Waupaca, Wisconsin, US | |
230571 | 230571 | 2022-05-31 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-06-01 04:20:55 | Saline, Kansas, US | |
3187336 | 3187336 | 2022-05-30 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-05-31 04:20:51 | Saline, Kansas, US | |
3199485 | 3199485 | 2022-05-29 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-05-30 04:20:50 | Saline, Kansas, US | |
2726363 | 2726363 | 2022-05-28 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-05-29 04:20:53 | Saline, Kansas, US | |
1315544 | 1315544 | 2022-05-27 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-05-28 04:21:07 | Saline, Kansas, US | |
1851336 | 1851336 | 2022-05-26 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-05-27 04:20:56 | Saline, Kansas, US | |
2049212 | 2049212 | 2022-05-25 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-05-26 04:20:50 | Saline, Kansas, US | |
623223 | 623223 | 2022-05-22 | US | Kansas | Saline | 20169 | 14207 | 250 | 0 | 38.78369175 | -97.65185177 | 2022-05-26 04:20:50 | Saline, Kansas, US | |
2600287 | 2600287 | 2022-05-05 | US | New York | Genesee | 36037 | 14207 | 187 | 0 | 43.0022601 | -78.19135193 | 2022-05-06 04:21:00 | Genesee, New York, US | |
921301 | 921301 | 2022-03-08 | US | Michigan | Barry | 26015 | 14207 | 160 | 0 | 42.59513984 | -85.30834519 | 2022-03-09 04:20:59 | Barry, Michigan, US | |
1549588 | 1549588 | 2022-03-07 | US | Michigan | Barry | 26015 | 14207 | 160 | 0 | 42.59513984 | -85.30834519 | 2022-03-08 04:20:54 | Barry, Michigan, US | |
2447046 | 2447046 | 2022-02-22 | San Marino | 14207 | 112 | 0 | 43.9424 | 12.4578 | 2022-02-23 04:21:09 | San Marino | ||||
3718459 | 3718459 | 2022-02-21 | San Marino | 14207 | 112 | 0 | 43.9424 | 12.4578 | 2022-02-22 04:21:01 | San Marino | ||||
3303744 | 3303744 | 2022-01-30 | US | Wisconsin | Columbia | 55021 | 14207 | 115 | 0 | 43.46492199 | -89.33589004 | 2022-01-31 04:21:09 | Columbia, Wisconsin, US | |
3065535 | 3065535 | 2022-01-29 | US | Wisconsin | Columbia | 55021 | 14207 | 115 | 0 | 43.46492199 | -89.33589004 | 2022-01-30 04:21:26 | Columbia, Wisconsin, US | |
3813469 | 3813469 | 2022-01-28 | US | Wisconsin | Columbia | 55021 | 14207 | 115 | 0 | 43.46492199 | -89.33589004 | 2022-01-29 04:21:10 | Columbia, Wisconsin, US | |
1781611 | 1781611 | 2022-01-27 | US | New York | Cattaraugus | 36009 | 14207 | 205 | 0 | 42.24778241 | -78.67923096 | 2022-01-28 04:21:09 | Cattaraugus, New York, US | |
717454 | 717454 | 2021-11-12 | US | Tennessee | Robertson | 47147 | 14207 | 195 | 0 | 36.52454807 | -86.87346725 | 2021-11-13 04:21:38 | Robertson, Tennessee, US | |
1815881 | 1815881 | 2021-09-19 | US | Indiana | LaPorte | 18091 | 14207 | 237 | 0 | 41.54366008 | -86.74072188 | 2021-09-20 04:21:22 | LaPorte, Indiana, US | |
1776121 | 1776121 | 2021-08-30 | US | Georgia | Carroll | 13045 | 14207 | 255 | 0 | 33.58138199 | -85.07976677 | 2021-08-31 04:21:46 | Carroll, Georgia, US | |
3030866 | 3030866 | 2021-06-16 | US | California | Shasta | 6089 | 14207 | 200 | 0 | 40.76391419 | -122.0396884 | 2021-06-17 04:22:36 | Shasta, California, US | |
1808110 | 1808110 | 2021-05-27 | US | Kentucky | Boone | 21015 | 14207 | 126 | 0 | 38.97065142 | -84.72615357 | 2021-05-28 04:20:36 | Boone, Kentucky, US | |
2390840 | 2390840 | 2021-05-18 | Mali | 14207 | 511 | 9309 | 4387 | 17.570692 | -3.996166000000001 | 2021-05-19 04:20:42 | Mali | |||
2411473 | 2411473 | 2021-04-19 | US | Colorado | Mesa | 8077 | 14207 | 218 | 0 | 39.01787888 | -108.469799 | 2021-04-20 04:20:41 | Mesa, Colorado, US | |
605647 | 605647 | 2021-04-09 | India | Meghalaya | 14207 | 151 | 13889 | 167 | 25.536934 | 91.278882 | 2021-04-10 04:20:59 | Meghalaya, India | ||
978545 | 978545 | 2021-02-06 | Ukraine | Luhansk Oblast | 14207 | 410 | 12307 | 1490 | 48.574 | 39.3078 | 2021-02-07 05:23:00 | Luhansk Oblast, Ukraine | ||
1094016 | 1094016 | 2021-01-20 | Guinea | 14207 | 81 | 13422 | 704 | 9.9456 | -9.6966 | 2021-01-21 05:22:01 | Guinea | |||
908106 | 908106 | 2021-01-19 | Guinea | 14207 | 81 | 13422 | 704 | 9.9456 | -9.6966 | 2021-01-20 05:21:54 | Guinea | |||
2407967 | 2407967 | 2020-12-23 | US | Indiana | Vanderburgh | 18163 | 14207 | 249 | 0 | 13958 | 38.02658833 | -87.58763124 | 2020-12-24 05:23:04 | Vanderburgh, Indiana, US |
1754888 | 1754888 | 2020-12-14 | Ukraine | Kherson Oblast | 14207 | 308 | 6115 | 7784 | 46.6354 | 32.6169 | 2020-12-15 05:26:38 | Kherson Oblast, Ukraine | ||
1585930 | 1585930 | 2020-11-30 | US | Minnesota | Washington | 27163 | 14207 | 116 | 0 | 14091 | 45.03864533 | -92.88429635 | 2020-12-01 05:26:18 | Washington, Minnesota, US |
392348 | 392348 | 2020-11-27 | Namibia | 14207 | 149 | 13388 | 670 | -22.9576 | 18.4904 | 2020-11-28 05:25:50 | Namibia | |||
3737862 | 3737862 | 2020-07-12 | Colombia | Valle del Cauca | 14207 | 590 | 6482 | 7135 | 3.8009 | -76.6413 | 2020-07-13 04:43:04 | Valle del Cauca, Colombia |
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]);