johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where confirmed = 19281 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3327196 | 3327196 | 2022-12-16 | US | Tennessee | Dickson | 47043 | 19281 | 261 | 0 | 36.14669837 | -87.35891709 | 2022-12-17 04:21:04 | Dickson, Tennessee, US | |
2497341 | 2497341 | 2022-08-15 | US | Virginia | Bedford | 51019 | 19281 | 249 | 0 | 37.3080028 | -79.5281964 | 2022-08-16 04:20:58 | Bedford, Virginia, US | |
144218 | 144218 | 2022-07-09 | US | New York | Clinton | 36019 | 19281 | 93 | 0 | 44.74530905 | -73.67875352 | 2022-07-10 04:20:54 | Clinton, New York, US | |
3854328 | 3854328 | 2022-04-27 | US | Ohio | Ross | 39141 | 19281 | 303 | 0 | 39.33705391 | -83.06000914 | 2022-04-28 04:20:47 | Ross, Ohio, US | |
1328758 | 1328758 | 2022-04-26 | US | Ohio | Ross | 39141 | 19281 | 303 | 0 | 39.33705391 | -83.06000914 | 2022-04-27 04:20:52 | Ross, Ohio, US | |
3724712 | 3724712 | 2022-04-25 | US | Ohio | Ross | 39141 | 19281 | 303 | 0 | 39.33705391 | -83.06000914 | 2022-04-26 04:20:51 | Ross, Ohio, US | |
2031280 | 2031280 | 2022-04-24 | US | Ohio | Ross | 39141 | 19281 | 303 | 0 | 39.33705391 | -83.06000914 | 2022-04-25 04:20:56 | Ross, Ohio, US | |
748855 | 748855 | 2022-04-23 | US | Ohio | Ross | 39141 | 19281 | 303 | 0 | 39.33705391 | -83.06000914 | 2022-04-24 04:20:56 | Ross, Ohio, US | |
3439340 | 3439340 | 2022-04-22 | US | Ohio | Ross | 39141 | 19281 | 303 | 0 | 39.33705391 | -83.06000914 | 2022-04-23 04:20:50 | Ross, Ohio, US | |
2894925 | 2894925 | 2022-04-21 | US | Ohio | Ross | 39141 | 19281 | 302 | 0 | 39.33705391 | -83.06000914 | 2022-04-22 04:20:45 | Ross, Ohio, US | |
3208928 | 3208928 | 2022-04-11 | US | Pennsylvania | Clearfield | 42033 | 19281 | 344 | 0 | 41.00110782 | -78.47592663 | 2022-04-12 04:20:49 | Clearfield, Pennsylvania, US | |
261757 | 261757 | 2022-03-15 | Russia | Magadan Oblast | 19281 | 383 | 0 | 62.48858785 | 153.9903764 | 2022-03-16 04:20:50 | Magadan Oblast, Russia | |||
3720647 | 3720647 | 2022-02-21 | US | Ohio | Erie | 39043 | 19281 | 267 | 0 | 41.36796058 | -82.62904521 | 2022-02-22 04:21:01 | Erie, Ohio, US | |
2907183 | 2907183 | 2021-12-19 | US | Washington | Whatcom | 53073 | 19281 | 185 | 0 | 48.82227976 | -121.74900179999999 | 2021-12-20 04:21:43 | Whatcom, Washington, US | |
1262256 | 1262256 | 2021-12-18 | US | Washington | Whatcom | 53073 | 19281 | 185 | 0 | 48.82227976 | -121.74900179999999 | 2021-12-19 04:21:11 | Whatcom, Washington, US | |
2402284 | 2402284 | 2021-12-17 | US | Washington | Whatcom | 53073 | 19281 | 185 | 0 | 48.82227976 | -121.74900179999999 | 2021-12-18 02:22:20 | Whatcom, Washington, US | |
1337655 | 1337655 | 2021-09-28 | US | Virginia | Newport News | 51700 | 19281 | 274 | 0 | 37.08166899 | -76.51754109 | 2021-09-29 04:21:45 | Newport News, Virginia, US | |
3892830 | 3892830 | 2021-08-29 | US | Georgia | Whitfield | 13313 | 19281 | 262 | 0 | 34.80987459 | -84.96093476 | 2021-08-30 04:21:23 | Whitfield, Georgia, US | |
2793933 | 2793933 | 2021-08-28 | US | Georgia | Whitfield | 13313 | 19281 | 262 | 0 | 34.80987459 | -84.96093476 | 2021-08-29 04:21:14 | Whitfield, Georgia, US | |
2924092 | 2924092 | 2021-08-27 | US | Georgia | Whitfield | 13313 | 19281 | 262 | 0 | 34.80987459 | -84.96093476 | 2021-08-28 04:21:28 | Whitfield, Georgia, US | |
335457 | 335457 | 2021-08-04 | US | Wisconsin | Kenosha | 55059 | 19281 | 340 | 0 | 42.57639354 | -88.04051686 | 2021-08-05 04:21:51 | Kenosha, Wisconsin, US | |
3382951 | 3382951 | 2021-06-13 | US | Maryland | Howard | 24027 | 19281 | 252 | 0 | 39.25305293 | -76.93126208 | 2021-06-14 04:22:46 | Howard, Maryland, US | |
3092425 | 3092425 | 2021-05-30 | US | Tennessee | Wilson | 47189 | 19281 | 239 | 0 | 36.15496772 | -86.29775884 | 2021-05-31 03:08:59 | Wilson, Tennessee, US | |
2258073 | 2258073 | 2021-05-19 | US | North Carolina | New Hanover | 37129 | 19281 | 166 | 0 | 34.25758282 | -77.87075626 | 2021-05-20 04:21:05 | New Hanover, North Carolina, US | |
1983926 | 1983926 | 2021-03-25 | US | Virginia | Chesapeake | 51550 | 19281 | 266 | 0 | 36.67670048 | -76.30545744 | 2021-03-26 05:26:55 | Chesapeake, Virginia, US | |
55010 | 55010 | 2021-03-07 | Russia | Karachay-Cherkess Republic | 19281 | 64 | 17602 | 1615 | 43.7368326 | 41.7267991 | 2021-03-08 05:24:48 | Karachay-Cherkess Republic, Russia | ||
2184177 | 2184177 | 2021-02-26 | US | Colorado | Boulder | 8013 | 19281 | 226 | 0 | 18490 | 40.09313619 | -105.3546767 | 2021-02-27 05:22:28 | Boulder, Colorado, US |
3603834 | 3603834 | 2021-02-17 | US | South Carolina | Anderson | 45007 | 19281 | 434 | 0 | 18847 | 34.51828081 | -82.63959517 | 2021-02-18 05:22:58 | Anderson, South Carolina, US |
1013762 | 1013762 | 2020-12-30 | US | Washington | Yakima | 53077 | 19281 | 314 | 0 | 18967 | 46.45738486 | -120.7380126 | 2020-12-31 05:22:49 | Yakima, Washington, US |
1632461 | 1632461 | 2020-12-05 | Peru | Huanuco | 19281 | 998 | 0 | 18283 | -9.421676 | -76.040642 | 2020-12-06 05:26:18 | Huanuco, 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]);