johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where confirmed = 14438 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1241472 | 1241472 | 2022-11-28 | US | Mississippi | Hancock | 28045 | 14438 | 161 | 0 | 30.41830223 | -89.48851033 | 2022-11-29 04:21:05 | Hancock, Mississippi, US | |
3553079 | 3553079 | 2022-11-27 | US | Kentucky | Knox | 21121 | 14438 | 165 | 0 | 36.89225732 | -83.85403396 | 2022-11-28 04:21:02 | Knox, Kentucky, US | |
2101559 | 2101559 | 2022-11-26 | US | Kentucky | Knox | 21121 | 14438 | 165 | 0 | 36.89225732 | -83.85403396 | 2022-11-27 04:21:05 | Knox, Kentucky, US | |
489050 | 489050 | 2022-11-25 | US | Kentucky | Knox | 21121 | 14438 | 165 | 0 | 36.89225732 | -83.85403396 | 2022-11-26 04:21:11 | Knox, Kentucky, US | |
3524879 | 3524879 | 2022-11-24 | US | Kentucky | Knox | 21121 | 14438 | 165 | 0 | 36.89225732 | -83.85403396 | 2022-11-25 04:21:06 | Knox, Kentucky, US | |
3313662 | 3313662 | 2022-11-23 | US | Kentucky | Knox | 21121 | 14438 | 165 | 0 | 36.89225732 | -83.85403396 | 2022-11-24 04:21:09 | Knox, Kentucky, US | |
1621703 | 1621703 | 2022-11-22 | US | Kentucky | Knox | 21121 | 14438 | 165 | 0 | 36.89225732 | -83.85403396 | 2022-11-23 04:21:06 | Knox, Kentucky, US | |
3461591 | 3461591 | 2022-11-21 | US | Kentucky | Knox | 21121 | 14438 | 165 | 0 | 36.89225732 | -83.85403396 | 2022-11-22 04:20:47 | Knox, Kentucky, US | |
3600621 | 3600621 | 2022-11-14 | US | Wisconsin | Polk | 55095 | 14438 | 124 | 0 | 45.46130348 | -92.44182875 | 2022-11-15 04:21:16 | Polk, Wisconsin, US | |
2597562 | 2597562 | 2022-07-25 | US | Wisconsin | Barron | 55005 | 14438 | 147 | 0 | 45.42372701 | -91.84833627 | 2022-07-26 04:20:58 | Barron, Wisconsin, US | |
1994795 | 1994795 | 2022-03-01 | US | Nevada | Carson City | 32510 | 14438 | 202 | 0 | 39.15509045 | -119.7480219 | 2022-03-02 04:21:07 | Carson City, Nevada, US | |
3302522 | 3302522 | 2022-01-30 | US | North Carolina | Duplin | 37061 | 14438 | 207 | 0 | 34.93449805 | -77.93140529 | 2022-01-31 04:21:09 | Duplin, North Carolina, US | |
3064313 | 3064313 | 2022-01-29 | US | North Carolina | Duplin | 37061 | 14438 | 207 | 0 | 34.93449805 | -77.93140529 | 2022-01-30 04:21:26 | Duplin, North Carolina, US | |
3812247 | 3812247 | 2022-01-28 | US | North Carolina | Duplin | 37061 | 14438 | 207 | 0 | 34.93449805 | -77.93140529 | 2022-01-29 04:21:10 | Duplin, North Carolina, US | |
2052372 | 2052372 | 2022-01-25 | US | Arkansas | Greene | 5055 | 14438 | 141 | 0 | 36.11735460000001 | -90.55832668 | 2022-01-26 04:21:07 | Greene, Arkansas, US | |
798965 | 798965 | 2021-12-22 | US | Arkansas | White | 5145 | 14438 | 209 | 0 | 35.25688493 | -91.74908296 | 2021-12-23 04:21:21 | White, Arkansas, US | |
3072658 | 3072658 | 2021-11-23 | US | Oregon | Linn | 41043 | 14438 | 174 | 0 | 44.48899494 | -122.53731540000001 | 2021-11-24 04:22:14 | Linn, Oregon, US | |
449679 | 449679 | 2021-11-17 | US | North Carolina | Craven | 37049 | 14438 | 158 | 0 | 35.11833364 | -77.08398081 | 2021-11-18 04:21:33 | Craven, North Carolina, US | |
2901958 | 2901958 | 2021-08-12 | US | New York | Ulster | 36111 | 14438 | 258 | 0 | 41.89027881 | -74.26252104 | 2021-08-13 04:21:24 | Ulster, New York, US | |
589350 | 589350 | 2021-08-08 | Belize | 14438 | 339 | 0 | 17.1899 | -88.4976 | 2021-08-09 04:21:24 | Belize | ||||
2203362 | 2203362 | 2021-08-07 | Belize | 14438 | 339 | 0 | 17.1899 | -88.4976 | 2021-08-08 04:21:33 | Belize | ||||
1117312 | 1117312 | 2021-08-06 | Belize | 14438 | 339 | 0 | 17.1899 | -88.4976 | 2021-08-07 04:21:30 | Belize | ||||
1495672 | 1495672 | 2021-07-03 | Mali | 14438 | 526 | 10079 | 3833 | 17.570692 | -3.996166000000001 | 2021-07-04 04:21:38 | Mali | |||
3126996 | 3126996 | 2021-06-28 | US | Louisiana | Bossier | 22015 | 14438 | 310 | 0 | 32.67932307 | -93.60460152 | 2021-06-29 04:21:28 | Bossier, Louisiana, US | |
3090421 | 3090421 | 2021-05-30 | US | Illinois | Kankakee | 17091 | 14438 | 214 | 0 | 41.13746989 | -87.86205334 | 2021-05-31 03:08:59 | Kankakee, Illinois, US | |
380538 | 380538 | 2021-04-30 | US | Alabama | Calhoun | 1015 | 14438 | 312 | 0 | 33.77483727 | -85.82630386 | 2021-05-01 04:20:47 | Calhoun, Alabama, US | |
3885940 | 3885940 | 2021-04-11 | US | North Carolina | Randolph | 37151 | 14438 | 217 | 0 | 35.71015088 | -79.80570339 | 2021-04-12 04:21:00 | Randolph, North Carolina, US | |
2985608 | 2985608 | 2021-04-10 | US | North Carolina | Randolph | 37151 | 14438 | 217 | 0 | 35.71015088 | -79.80570339 | 2021-04-11 04:20:56 | Randolph, North Carolina, US | |
608040 | 608040 | 2021-04-09 | US | North Carolina | Randolph | 37151 | 14438 | 217 | 0 | 35.71015088 | -79.80570339 | 2021-04-10 04:20:59 | Randolph, North Carolina, US | |
183054 | 183054 | 2021-02-21 | US | Illinois | McLean | 17113 | 14438 | 156 | 0 | 14282 | 40.48996987 | -88.84621113 | 2021-02-22 05:24:21 | McLean, Illinois, US |
472159 | 472159 | 2021-02-19 | US | Georgia | Bibb | 13021 | 14438 | 366 | 0 | 14072 | 32.80904227 | -83.70489165 | 2021-02-20 05:22:51 | Bibb, Georgia, US |
1587621 | 1587621 | 2020-11-30 | US | Washington | Yakima | 53077 | 14438 | 293 | 0 | 14145 | 46.45738486 | -120.7380126 | 2020-12-01 05:26:18 | Yakima, Washington, US |
3117667 | 3117667 | 2020-10-06 | Russia | Arkhangelsk Oblast | 14438 | 262 | 10308 | 3868 | 63.5589686 | 43.1221646 | 2020-10-07 04:23:40 | Arkhangelsk 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]);