johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where confirmed = 8753 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2532348 | 2532348 | 2022-10-06 | US | Tennessee | Lauderdale | 47097 | 8753 | 113 | 0 | 35.75893438 | -89.6301591 | 2022-10-07 04:23:08 | Lauderdale, Tennessee, US | |
168784 | 168784 | 2022-06-21 | US | Puerto Rico | Dorado | 72051 | 8753 | 0 | 0 | 18.436115 | -66.278669 | 2022-06-22 04:20:54 | Dorado, Puerto Rico, US | |
1766067 | 1766067 | 2022-06-20 | US | Puerto Rico | Dorado | 72051 | 8753 | 0 | 0 | 18.436115 | -66.278669 | 2022-06-21 04:20:56 | Dorado, Puerto Rico, US | |
2314067 | 2314067 | 2022-06-17 | US | Puerto Rico | Moca | 72099 | 8753 | 0 | 0 | 18.377805 | -67.080952 | 2022-06-18 04:21:10 | Moca, Puerto Rico, US | |
160962 | 160962 | 2022-03-29 | US | Tennessee | Hardin | 47071 | 8753 | 142 | 0 | 35.19732531 | -88.18593755 | 2022-03-30 04:20:45 | Hardin, Tennessee, US | |
1439533 | 1439533 | 2022-03-28 | US | Tennessee | Hardin | 47071 | 8753 | 142 | 0 | 35.19732531 | -88.18593755 | 2022-03-29 04:20:46 | Hardin, Tennessee, US | |
944538 | 944538 | 2022-02-28 | US | Minnesota | Carlton | 27017 | 8753 | 92 | 0 | 46.59180601 | -92.67601019 | 2022-03-01 04:21:09 | Carlton, Minnesota, US | |
3878547 | 3878547 | 2022-02-19 | US | Tennessee | Marion | 47115 | 8753 | 121 | 0 | 35.12997174 | -85.62265895 | 2022-02-20 04:21:00 | Marion, Tennessee, US | |
3076708 | 3076708 | 2022-02-09 | US | Pennsylvania | Clinton | 42035 | 8753 | 120 | 0 | 41.23255967 | -77.63785995 | 2022-02-10 04:21:14 | Clinton, Pennsylvania, US | |
2475446 | 2475446 | 2022-02-03 | US | Louisiana | Beauregard | 22011 | 8753 | 133 | 0 | 30.64836518 | -93.34173616 | 2022-02-04 04:21:10 | Beauregard, Louisiana, US | |
1288574 | 1288574 | 2022-01-04 | US | Oklahoma | Le Flore | 40079 | 8753 | 94 | 0 | 34.89851864 | -94.70392124 | 2022-01-05 04:21:59 | Le Flore, Oklahoma, US | |
1702918 | 1702918 | 2022-01-03 | US | Oklahoma | Le Flore | 40079 | 8753 | 94 | 0 | 34.89851864 | -94.70392124 | 2022-01-04 04:22:17 | Le Flore, Oklahoma, US | |
3522001 | 3522001 | 2022-01-02 | US | Oklahoma | Le Flore | 40079 | 8753 | 94 | 0 | 34.89851864 | -94.70392124 | 2022-01-03 02:22:25 | Le Flore, Oklahoma, US | |
2170774 | 2170774 | 2022-01-01 | US | Texas | Rusk | 48401 | 8753 | 191 | 0 | 32.10773545 | -94.76176432 | 2022-01-02 04:20:52 | Rusk, Texas, US | |
2170131 | 2170131 | 2022-01-01 | US | Oklahoma | Le Flore | 40079 | 8753 | 94 | 0 | 34.89851864 | -94.70392124 | 2022-01-02 04:20:52 | Le Flore, Oklahoma, US | |
2779562 | 2779562 | 2021-12-31 | US | Oklahoma | Le Flore | 40079 | 8753 | 94 | 0 | 34.89851864 | -94.70392124 | 2022-01-01 04:22:14 | Le Flore, Oklahoma, US | |
4001219 | 4001219 | 2021-12-30 | US | Oklahoma | Le Flore | 40079 | 8753 | 94 | 0 | 34.89851864 | -94.70392124 | 2021-12-31 04:21:50 | Le Flore, Oklahoma, US | |
1671026 | 1671026 | 2021-12-29 | US | Oklahoma | Le Flore | 40079 | 8753 | 94 | 0 | 34.89851864 | -94.70392124 | 2021-12-30 04:21:25 | Le Flore, Oklahoma, US | |
1433646 | 1433646 | 2021-12-28 | US | Indiana | DeKalb | 18033 | 8753 | 122 | 0 | 41.39804622 | -84.99906934 | 2021-12-29 03:21:43 | DeKalb, Indiana, US | |
799292 | 799292 | 2021-12-22 | US | Georgia | Polk | 13233 | 8753 | 164 | 0 | 34.00267074 | -85.18677781 | 2021-12-23 04:21:21 | Polk, Georgia, US | |
2907138 | 2907138 | 2021-12-19 | US | Virginia | Washington | 51191 | 8753 | 168 | 0 | 36.72341572 | -81.95666289 | 2021-12-20 04:21:43 | Washington, Virginia, US | |
1262211 | 1262211 | 2021-12-18 | US | Virginia | Washington | 51191 | 8753 | 168 | 0 | 36.72341572 | -81.95666289 | 2021-12-19 04:21:11 | Washington, Virginia, US | |
2402239 | 2402239 | 2021-12-17 | US | Virginia | Washington | 51191 | 8753 | 168 | 0 | 36.72341572 | -81.95666289 | 2021-12-18 02:22:20 | Washington, Virginia, US | |
2197045 | 2197045 | 2021-12-03 | US | Kentucky | Jessamine | 21113 | 8753 | 106 | 0 | 37.87119786 | -84.58252003 | 2021-12-04 04:22:18 | Jessamine, Kentucky, US | |
3289975 | 3289975 | 2021-11-18 | US | Illinois | Whiteside | 17195 | 8753 | 188 | 0 | 41.75509713 | -89.91556058 | 2021-11-19 04:21:40 | Whiteside, Illinois, US | |
449713 | 449713 | 2021-11-17 | US | North Carolina | McDowell | 37111 | 8753 | 135 | 0 | 35.67736232 | -82.0482425 | 2021-11-18 04:21:33 | McDowell, North Carolina, US | |
29759 | 29759 | 2021-11-11 | US | Kansas | Saline | 20169 | 8753 | 186 | 0 | 38.78369175 | -97.65185177 | 2021-11-12 04:22:01 | Saline, Kansas, US | |
2846198 | 2846198 | 2021-11-10 | US | Kansas | Saline | 20169 | 8753 | 186 | 0 | 38.78369175 | -97.65185177 | 2021-11-11 04:21:45 | Saline, Kansas, US | |
445708 | 445708 | 2021-10-20 | US | North Carolina | Pender | 37141 | 8753 | 100 | 0 | 34.52265624 | -77.90352133 | 2021-10-21 04:21:18 | Pender, North Carolina, US | |
424420 | 424420 | 2021-10-10 | US | Indiana | Boone | 18011 | 8753 | 115 | 0 | 40.0509304 | -86.46841646 | 2021-10-11 04:21:31 | Boone, Indiana, US | |
1724955 | 1724955 | 2021-09-25 | US | Arizona | Santa Cruz | 4023 | 8753 | 191 | 0 | 31.52508998 | -110.8479088 | 2021-09-26 04:21:29 | Santa Cruz, Arizona, US | |
68818 | 68818 | 2021-09-01 | US | Minnesota | Rice | 27131 | 8753 | 114 | 0 | 44.3543376 | -93.29658715 | 2021-09-02 04:21:15 | Rice, Minnesota, US | |
3470542 | 3470542 | 2021-08-03 | US | North Carolina | Surry | 37171 | 8753 | 173 | 0 | 36.41689489 | -80.69102283 | 2021-08-04 04:21:25 | Surry, North Carolina, US | |
3675950 | 3675950 | 2021-05-04 | Spain | Melilla | 8753 | 90 | 125 | 8538 | 35.2923 | -2.9381 | 2021-05-05 04:20:43 | Melilla, Spain | ||
3701939 | 3701939 | 2021-04-27 | China | Unknown | 8753 | 0 | 5 | 0 | 2021-04-28 04:20:32 | Unknown, China | ||||
1206633 | 1206633 | 2021-03-22 | US | South Carolina | Oconee | 45073 | 8753 | 131 | 0 | 34.75225169 | -83.06742317 | 2021-03-23 05:26:18 | Oconee, South Carolina, US | |
1684880 | 1684880 | 2021-02-02 | US | Alabama | Limestone | 1083 | 8753 | 107 | 0 | 8646 | 34.81185586 | -86.98310072 | 2021-02-03 05:22:52 | Limestone, Alabama, US |
435496 | 435496 | 2021-01-21 | Pakistan | Azad Jammu and Kashmir | 8753 | 248 | 8209 | 296 | 34.027401 | 73.947253 | 2021-01-22 05:22:10 | Azad Jammu and Kashmir, Pakistan | ||
157607 | 157607 | 2021-01-08 | Ukraine | Kirovohrad Oblast | 8753 | 269 | 4785 | 3699 | 48.5079 | 32.2623 | 2021-01-09 05:22:18 | Kirovohrad Oblast, Ukraine | ||
1988872 | 1988872 | 2020-11-09 | Russia | Sakhalin Oblast | 8753 | 4 | 5814 | 2935 | 49.7219665 | 143.448533 | 2020-11-10 05:40:07 | Sakhalin Oblast, Russia | ||
1178217 | 1178217 | 2020-10-22 | US | Florida | St. Lucie | 12111 | 8753 | 323 | 0 | 8430 | 27.37763908 | -80.47106649 | 2020-10-23 04:24:46 | St. Lucie, Florida, US |
2856686 | 2856686 | 2020-10-16 | Colombia | Caldas | 8753 | 181 | 6429 | 2143 | 5.2983 | -75.2479 | 2020-10-17 04:24:12 | Caldas, Colombia | ||
3391545 | 3391545 | 2020-10-02 | US | New Jersey | Mercer | 34021 | 8753 | 636 | 0 | 8117 | 40.28047017 | -74.70479631 | 2020-10-03 04:23:40 | Mercer, New Jersey, US |
177492 | 177492 | 2020-07-27 | Mexico | Yucatan | 8753 | 825 | 6369 | 1559 | 20.7099 | -89.0943 | 2020-07-28 04:58:43 | Yucatan, Mexico | ||
1209494 | 1209494 | 2020-06-09 | US | Massachusetts | Norfolk | 25021 | 8753 | 870 | 0 | 7883 | 42.16073095 | -71.20530408 | 2020-06-10 04:07:00 | Norfolk, Massachusetts, US |
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]);