johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 26744 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
198668 | 198668 | 2022-10-19 | US | Alabama | Talladega | 1121 | 26744 | 388 | 0 | 33.37823223 | -86.16886178 | 2022-10-20 04:22:59 | Talladega, Alabama, US | |
2757329 | 2757329 | 2022-10-18 | US | Alabama | Talladega | 1121 | 26744 | 388 | 0 | 33.37823223 | -86.16886178 | 2022-10-19 04:22:26 | Talladega, Alabama, US | |
2025163 | 2025163 | 2022-10-17 | US | Alabama | Talladega | 1121 | 26744 | 388 | 0 | 33.37823223 | -86.16886178 | 2022-10-18 04:22:42 | Talladega, Alabama, US | |
2159941 | 2159941 | 2022-10-16 | US | Alabama | Talladega | 1121 | 26744 | 388 | 0 | 33.37823223 | -86.16886178 | 2022-10-17 04:20:31 | Talladega, Alabama, US | |
516138 | 516138 | 2022-10-15 | US | Alabama | Talladega | 1121 | 26744 | 388 | 0 | 33.37823223 | -86.16886178 | 2022-10-16 04:22:39 | Talladega, Alabama, US | |
2033195 | 2033195 | 2022-10-14 | US | Alabama | Talladega | 1121 | 26744 | 388 | 0 | 33.37823223 | -86.16886178 | 2022-10-15 04:22:00 | Talladega, Alabama, US | |
3753883 | 3753883 | 2022-10-13 | US | Alabama | Talladega | 1121 | 26744 | 388 | 0 | 33.37823223 | -86.16886178 | 2022-10-14 04:22:28 | Talladega, Alabama, US | |
1088415 | 1088415 | 2022-08-09 | US | North Carolina | Lincoln | 37109 | 26744 | 185 | 0 | 35.48508185 | -81.21740317 | 2022-08-10 04:20:57 | Lincoln, North Carolina, US | |
3545830 | 3545830 | 2022-08-08 | US | North Carolina | Lincoln | 37109 | 26744 | 185 | 0 | 35.48508185 | -81.21740317 | 2022-08-09 04:20:34 | Lincoln, North Carolina, US | |
1072233 | 1072233 | 2022-08-07 | US | North Carolina | Lincoln | 37109 | 26744 | 185 | 0 | 35.48508185 | -81.21740317 | 2022-08-08 04:21:08 | Lincoln, North Carolina, US | |
1942821 | 1942821 | 2022-08-06 | US | North Carolina | Lincoln | 37109 | 26744 | 185 | 0 | 35.48508185 | -81.21740317 | 2022-08-07 04:20:54 | Lincoln, North Carolina, US | |
882620 | 882620 | 2022-08-05 | US | North Carolina | Lincoln | 37109 | 26744 | 185 | 0 | 35.48508185 | -81.21740317 | 2022-08-06 04:20:56 | Lincoln, North Carolina, US | |
2011031 | 2011031 | 2022-08-04 | US | North Carolina | Lincoln | 37109 | 26744 | 185 | 0 | 35.48508185 | -81.21740317 | 2022-08-05 04:20:52 | Lincoln, North Carolina, US | |
1100458 | 1100458 | 2022-08-03 | US | North Carolina | Lincoln | 37109 | 26744 | 185 | 0 | 35.48508185 | -81.21740317 | 2022-08-04 04:20:58 | Lincoln, North Carolina, US | |
2333205 | 2333205 | 2022-05-08 | US | Mississippi | Lee | 28081 | 26744 | 301 | 0 | 34.2918775 | -88.68149954 | 2022-05-09 04:20:54 | Lee, Mississippi, US | |
362167 | 362167 | 2022-05-07 | US | Mississippi | Lee | 28081 | 26744 | 301 | 0 | 34.2918775 | -88.68149954 | 2022-05-08 04:20:49 | Lee, Mississippi, US | |
1399518 | 1399518 | 2022-05-06 | US | Mississippi | Lee | 28081 | 26744 | 301 | 0 | 34.2918775 | -88.68149954 | 2022-05-07 04:21:09 | Lee, Mississippi, US | |
2599873 | 2599873 | 2022-05-05 | US | Mississippi | Lee | 28081 | 26744 | 301 | 0 | 34.2918775 | -88.68149954 | 2022-05-06 04:21:00 | Lee, Mississippi, US | |
3267322 | 3267322 | 2022-05-04 | US | Mississippi | Lee | 28081 | 26744 | 301 | 0 | 34.2918775 | -88.68149954 | 2022-05-05 04:20:55 | Lee, Mississippi, US | |
1573961 | 1573961 | 2022-05-03 | US | Mississippi | Lee | 28081 | 26744 | 301 | 0 | 34.2918775 | -88.68149954 | 2022-05-04 04:20:59 | Lee, Mississippi, US | |
465221 | 465221 | 2022-05-02 | US | Mississippi | Lee | 28081 | 26744 | 301 | 0 | 34.2918775 | -88.68149954 | 2022-05-03 04:21:00 | Lee, Mississippi, US | |
1513026 | 1513026 | 2022-02-24 | US | Michigan | Bay | 26017 | 26744 | 561 | 0 | 43.70639106 | -83.98731479 | 2022-02-25 04:21:11 | Bay, Michigan, US | |
1059467 | 1059467 | 2022-02-23 | US | Michigan | Bay | 26017 | 26744 | 561 | 0 | 43.70639106 | -83.98731479 | 2022-02-24 04:21:14 | Bay, Michigan, US | |
483550 | 483550 | 2021-07-19 | India | Nagaland | 26744 | 530 | 25067 | 1147 | 26.06702 | 94.470302 | 2021-07-20 04:21:48 | Nagaland, India | ||
1709798 | 1709798 | 2021-06-02 | US | Louisiana | Caddo | 22017 | 26744 | 753 | 0 | 32.57991587 | -93.88375652 | 2021-06-03 04:23:32 | Caddo, Louisiana, US | |
2006318 | 2006318 | 2021-05-12 | US | Michigan | Michigan Department of Corrections (MDOC) | 26744 | 151 | 0 | 47.63197653 | 0.0 | 2021-05-13 04:20:51 | Michigan Department of Corrections (MDOC), Michigan, US | ||
2551176 | 2551176 | 2021-04-15 | US | North Carolina | Cumberland | 37051 | 26744 | 294 | 0 | 35.04762133 | -78.82623165 | 2021-04-16 04:20:46 | Cumberland, North Carolina, US | |
3883759 | 3883759 | 2021-04-11 | Peru | Puno | 26744 | 2615 | 0 | 24129 | -14.995826999999998 | -69.922726 | 2021-04-12 04:21:00 | Puno, Peru | ||
2983427 | 2983427 | 2021-04-10 | Peru | Puno | 26744 | 2603 | 0 | 24141 | -14.995826999999998 | -69.922726 | 2021-04-11 04:20:56 | Puno, Peru | ||
1989201 | 1989201 | 2020-11-09 | US | California | Santa Clara | 6085 | 26744 | 409 | 0 | 26320 | 37.23104908 | -121.6970462 | 2020-11-10 05:40:07 | Santa Clara, California, US |
3317014 | 3317014 | 2020-09-22 | US | Georgia | Gwinnett | 13135 | 26744 | 396 | 0 | 26348 | 33.96044201 | -84.02137802 | 2020-09-23 04:23:00 | Gwinnett, Georgia, US |
2991496 | 2991496 | 2020-08-24 | Russia | Nizhny Novgorod Oblast | 26744 | 449 | 23715 | 2580 | 55.47180329999999 | 44.0911594 | 2020-08-25 04:28:02 | Nizhny Novgorod Oblast, Russia |
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]);