johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where confirmed = 17012 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 24
- Equatorial Guinea 4
- Russia 3
- Netherlands 1
- Peru 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3279849 | 3279849 | 2022-10-23 | US | Tennessee | Monroe | 47123 | 17012 | 258 | 0 | 35.44550387 | -84.24902965 | 2022-10-24 04:22:29 | Monroe, Tennessee, US | |
2259633 | 2259633 | 2022-10-02 | Equatorial Guinea | 17012 | 183 | 0 | 1.6508 | 10.2679 | 2022-10-03 04:23:11 | Equatorial Guinea | ||||
2995159 | 2995159 | 2022-10-01 | Equatorial Guinea | 17012 | 183 | 0 | 1.6508 | 10.2679 | 2022-10-02 04:21:23 | Equatorial Guinea | ||||
853485 | 853485 | 2022-09-30 | Equatorial Guinea | 17012 | 183 | 0 | 1.6508 | 10.2679 | 2022-10-01 04:23:01 | Equatorial Guinea | ||||
2375411 | 2375411 | 2022-09-29 | Equatorial Guinea | 17012 | 183 | 0 | 1.6508 | 10.2679 | 2022-09-30 04:23:09 | Equatorial Guinea | ||||
2772358 | 2772358 | 2022-09-26 | US | Virginia | Pittsylvania | 51143 | 17012 | 223 | 0 | 36.81980341 | -79.39731264 | 2022-09-27 04:23:01 | Pittsylvania, Virginia, US | |
2601344 | 2601344 | 2022-05-05 | US | Virgin Islands | 78 | 17012 | 113 | 0 | 18.3358 | -64.8963 | 2022-05-06 04:21:00 | Virgin Islands, US | ||
3419114 | 3419114 | 2022-04-17 | US | New Mexico | Eddy | 35015 | 17012 | 276 | 0 | 32.47167456 | -104.3053527 | 2022-04-18 04:21:12 | Eddy, New Mexico, US | |
306063 | 306063 | 2022-04-16 | US | New Mexico | Eddy | 35015 | 17012 | 276 | 0 | 32.47167456 | -104.3053527 | 2022-04-17 04:20:59 | Eddy, New Mexico, US | |
2672008 | 2672008 | 2022-04-15 | US | New Mexico | Eddy | 35015 | 17012 | 276 | 0 | 32.47167456 | -104.3053527 | 2022-04-16 04:20:48 | Eddy, New Mexico, US | |
1950206 | 1950206 | 2022-04-12 | US | Michigan | Van Buren | 26159 | 17012 | 266 | 0 | 42.25190229 | -86.01939087 | 2022-04-13 04:21:03 | Van Buren, Michigan, US | |
3207959 | 3207959 | 2022-04-11 | US | Michigan | Van Buren | 26159 | 17012 | 266 | 0 | 42.25190229 | -86.01939087 | 2022-04-12 04:20:49 | Van Buren, Michigan, US | |
1577845 | 1577845 | 2022-04-10 | US | Michigan | Van Buren | 26159 | 17012 | 266 | 0 | 42.25190229 | -86.01939087 | 2022-04-11 04:21:02 | Van Buren, Michigan, US | |
1654087 | 1654087 | 2022-04-09 | US | Michigan | Van Buren | 26159 | 17012 | 266 | 0 | 42.25190229 | -86.01939087 | 2022-04-10 04:20:52 | Van Buren, Michigan, US | |
2117409 | 2117409 | 2022-04-08 | US | Michigan | Van Buren | 26159 | 17012 | 266 | 0 | 42.25190229 | -86.01939087 | 2022-04-09 04:20:42 | Van Buren, Michigan, US | |
3321933 | 3321933 | 2022-04-07 | US | Michigan | Van Buren | 26159 | 17012 | 266 | 0 | 42.25190229 | -86.01939087 | 2022-04-08 04:20:48 | Van Buren, Michigan, US | |
2802469 | 2802469 | 2022-04-06 | US | Michigan | Van Buren | 26159 | 17012 | 266 | 0 | 42.25190229 | -86.01939087 | 2022-04-07 04:20:53 | Van Buren, Michigan, US | |
1867116 | 1867116 | 2022-03-10 | US | Michigan | Grand Traverse | 26055 | 17012 | 221 | 0 | 44.69565625 | -85.55585247 | 2022-03-11 04:20:50 | Grand Traverse, Michigan, US | |
2141811 | 2141811 | 2022-03-09 | US | Michigan | Grand Traverse | 26055 | 17012 | 221 | 0 | 44.69565625 | -85.55585247 | 2022-03-10 04:20:48 | Grand Traverse, Michigan, US | |
3794015 | 3794015 | 2021-10-25 | Netherlands | Curacao | 17012 | 173 | 0 | 12.1696 | -68.99 | 2021-10-26 04:22:09 | Curacao, Netherlands | |||
643306 | 643306 | 2021-09-07 | US | Kentucky | Boone | 21015 | 17012 | 162 | 0 | 38.97065142 | -84.72615357 | 2021-09-08 04:21:31 | Boone, Kentucky, US | |
34880 | 34880 | 2021-08-25 | US | Ohio | Greene | 39057 | 17012 | 267 | 0 | 39.69116283 | -83.89032084 | 2021-08-26 04:21:28 | Greene, Ohio, US | |
1958105 | 1958105 | 2021-08-05 | US | Maryland | Harford | 24025 | 17012 | 304 | 0 | 39.55010644 | -76.30775940000002 | 2021-08-06 04:21:18 | Harford, Maryland, US | |
1957050 | 1957050 | 2021-08-05 | US | Arkansas | Sebastian | 5131 | 17012 | 292 | 0 | 35.19605503 | -94.27162713 | 2021-08-06 04:21:18 | Sebastian, Arkansas, US | |
2372930 | 2372930 | 2021-07-20 | US | Kentucky | Kenton | 21117 | 17012 | 207 | 0 | 38.93950319 | -84.53241199 | 2021-07-21 04:21:40 | Kenton, Kentucky, US | |
3741929 | 3741929 | 2021-07-12 | US | Georgia | Muscogee | 13215 | 17012 | 500 | 0 | 32.50931999 | -84.87142262 | 2021-07-13 04:21:18 | Muscogee, Georgia, US | |
3359567 | 3359567 | 2021-06-21 | US | Georgia | Whitfield | 13313 | 17012 | 250 | 0 | 34.80987459 | -84.96093476 | 2021-06-22 04:21:34 | Whitfield, Georgia, US | |
2885266 | 2885266 | 2021-06-20 | US | Georgia | Whitfield | 13313 | 17012 | 250 | 0 | 34.80987459 | -84.96093476 | 2021-06-21 04:21:41 | Whitfield, Georgia, US | |
2104358 | 2104358 | 2021-06-01 | Russia | North Ossetia - Alania Republic | 17012 | 214 | 16397 | 401 | 42.79336110000001 | 44.6324493 | 2021-06-02 04:24:34 | North Ossetia - Alania Republic, Russia | ||
2984377 | 2984377 | 2021-04-10 | US | Indiana | Porter | 18127 | 17012 | 297 | 0 | 41.45986947 | -87.06848888 | 2021-04-11 04:20:56 | Porter, Indiana, US | |
2283648 | 2283648 | 2021-02-14 | Russia | Mordovia Republic | 17012 | 150 | 14772 | 2090 | 54.4419829 | 44.4661144 | 2021-02-15 05:24:49 | Mordovia Republic, Russia | ||
678501 | 678501 | 2020-11-23 | Russia | Buryatia Republic | 17012 | 362 | 15011 | 1639 | 52.7182426 | 109.492143 | 2020-11-24 05:27:31 | Buryatia Republic, Russia | ||
2919330 | 2919330 | 2020-11-04 | Peru | Amazonas | 17012 | 534 | 0 | 16478 | -5.077253 | -78.050172 | 2020-11-05 06:05:03 | Amazonas, Peru |
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]);