johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where confirmed = 13658 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3406580 | 3406580 | 2022-07-17 | US | Indiana | Noble | 18113 | 13658 | 161 | 0 | 41.39672484 | -85.41966713 | 2022-07-18 04:20:59 | Noble, Indiana, US | |
2152780 | 2152780 | 2022-07-16 | US | Indiana | Noble | 18113 | 13658 | 161 | 0 | 41.39672484 | -85.41966713 | 2022-07-17 04:21:15 | Noble, Indiana, US | |
2420013 | 2420013 | 2022-07-15 | US | Indiana | Noble | 18113 | 13658 | 161 | 0 | 41.39672484 | -85.41966713 | 2022-07-16 04:21:05 | Noble, Indiana, US | |
2334909 | 2334909 | 2022-05-08 | US | Wisconsin | Barron | 55005 | 13658 | 144 | 0 | 45.42372701 | -91.84833627 | 2022-05-09 04:20:54 | Barron, Wisconsin, US | |
363871 | 363871 | 2022-05-07 | US | Wisconsin | Barron | 55005 | 13658 | 144 | 0 | 45.42372701 | -91.84833627 | 2022-05-08 04:20:49 | Barron, Wisconsin, US | |
1401222 | 1401222 | 2022-05-06 | US | Wisconsin | Barron | 55005 | 13658 | 144 | 0 | 45.42372701 | -91.84833627 | 2022-05-07 04:21:09 | Barron, Wisconsin, US | |
1573888 | 1573888 | 2022-05-03 | US | Minnesota | Otter Tail | 27111 | 13658 | 167 | 0 | 46.40846929 | -95.70835255 | 2022-05-04 04:20:59 | Otter Tail, Minnesota, US | |
1329843 | 1329843 | 2022-04-26 | US | Wisconsin | Waupaca | 55135 | 13658 | 251 | 0 | 44.47068056 | -88.96534501 | 2022-04-27 04:20:52 | Waupaca, Wisconsin, US | |
2088539 | 2088539 | 2021-12-14 | US | California | Napa | 6055 | 13658 | 107 | 0 | 38.50735751 | -122.33283899999999 | 2021-12-15 03:22:16 | Napa, California, US | |
554057 | 554057 | 2021-12-08 | US | Vermont | Chittenden | 50007 | 13658 | 132 | 0 | 44.46322849 | -73.08359212 | 2021-12-09 04:22:49 | Chittenden, Vermont, US | |
3576 | 3576 | 2021-12-02 | US | Texas | Victoria | 48469 | 13658 | 353 | 0 | 28.79780988 | -96.96813006 | 2021-12-03 04:23:05 | Victoria, Texas, US | |
43526 | 43526 | 2021-11-02 | Colombia | Arauca | 13658 | 464 | 0 | 7.0762 | -70.7105 | 2021-11-03 06:22:09 | Arauca, Colombia | |||
2619927 | 2619927 | 2021-09-17 | US | Missouri | Clay | 29047 | 13658 | 196 | 0 | 39.31132056 | -94.41850862 | 2021-09-18 04:21:24 | Clay, Missouri, US | |
180864 | 180864 | 2021-09-02 | US | South Carolina | Sumter | 45085 | 13658 | 237 | 0 | 33.91826534 | -80.37942316 | 2021-09-03 04:21:20 | Sumter, South Carolina, US | |
3106118 | 3106118 | 2021-08-24 | US | Connecticut | Middlesex | 9007 | 13658 | 377 | 0 | 41.45949668 | -72.53714864 | 2021-08-25 04:21:41 | Middlesex, Connecticut, US | |
1082500 | 1082500 | 2021-05-14 | US | California | Shasta | 6089 | 13658 | 200 | 0 | 40.76391419 | -122.0396884 | 2021-05-15 04:20:58 | Shasta, California, US | |
2008198 | 2008198 | 2021-05-12 | US | Wisconsin | Fond du Lac | 55039 | 13658 | 121 | 0 | 43.75354908 | -88.48885325 | 2021-05-13 04:20:51 | Fond du Lac, Wisconsin, US | |
1637680 | 1637680 | 2021-04-29 | US | Kentucky | Boone | 21015 | 13658 | 120 | 0 | 38.97065142 | -84.72615357 | 2021-04-30 04:21:03 | Boone, Kentucky, US | |
888189 | 888189 | 2021-04-26 | Mali | 13658 | 474 | 8183 | 5001 | 17.570692 | -3.996166000000001 | 2021-04-27 04:20:52 | Mali | |||
3085665 | 3085665 | 2021-04-05 | US | Alabama | Etowah | 1055 | 13658 | 345 | 0 | 34.04567266 | -86.04051873 | 2021-04-06 04:20:32 | Etowah, Alabama, US | |
1733122 | 1733122 | 2021-03-14 | US | Colorado | Mesa | 8077 | 13658 | 212 | 0 | 39.01787888 | -108.469799 | 2021-03-15 05:25:51 | Mesa, Colorado, US | |
354645 | 354645 | 2021-03-11 | US | North Carolina | Randolph | 37151 | 13658 | 206 | 0 | 35.71015088 | -79.80570339 | 2021-03-12 05:26:50 | Randolph, North Carolina, US | |
1616447 | 1616447 | 2021-03-05 | Russia | Kamchatka Krai | 13658 | 127 | 12386 | 1145 | 57.1914882 | 160.03838190000005 | 2021-03-06 04:23:41 | Kamchatka Krai, Russia | ||
1096915 | 1096915 | 2021-01-20 | US | South Carolina | Pickens | 45077 | 13658 | 189 | 0 | 13469 | 34.88807695 | -82.72791551 | 2021-01-21 05:22:01 | Pickens, South Carolina, US |
238997 | 238997 | 2021-01-18 | US | Minnesota | St. Louis | 27137 | 13658 | 241 | 0 | 13417 | 47.6048407 | -92.46879855 | 2021-01-19 05:22:15 | St. Louis, Minnesota, US |
1065157 | 1065157 | 2021-01-04 | US | Virginia | Chesterfield | 51041 | 13658 | 173 | 0 | 13485 | 37.37373208 | -77.58680140000001 | 2021-01-05 05:21:49 | Chesterfield, Virginia, US |
1903326 | 1903326 | 2020-12-18 | US | New Jersey | Gloucester | 34015 | 13658 | 345 | 0 | 13313 | 39.71581067 | -75.13995546 | 2020-12-19 05:27:52 | Gloucester, New Jersey, US |
3786060 | 3786060 | 2020-10-11 | Peru | Moquegua | 13658 | 793 | 0 | 12865 | -16.860271 | -70.839046 | 2020-10-12 04:23:45 | Moquegua, Peru | ||
2514471 | 2514471 | 2020-10-03 | Sudan | 13658 | 836 | 6764 | 6058 | 12.8628 | 30.2176 | 2020-10-04 04:23:44 | Sudan | |||
1612802 | 1612802 | 2020-08-14 | US | California | Sacramento | 6067 | 13658 | 212 | 0 | 13439 | 38.45106826 | -121.3425374 | 2020-08-15 04:27:31 | Sacramento, California, US |
1195962 | 1195962 | 2020-06-17 | Spain | Pais Vasco | 13658 | 1424 | 16160 | 0 | 42.9896 | -2.6189 | 2020-06-18 04:33:18 | Pais Vasco, Spain |
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]);