johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where confirmed = 16598 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1832286 | 1832286 | 2022-10-25 | US | Nebraska | Unassigned | 90031 | 16598 | 1038 | 0 | 42.8997274 | 0.0 | 2022-10-26 04:22:19 | Unassigned, Nebraska, US | |
796547 | 796547 | 2022-10-24 | US | Nebraska | Unassigned | 90031 | 16598 | 1038 | 0 | 42.8997274 | 0.0 | 2022-10-25 04:21:53 | Unassigned, Nebraska, US | |
3279002 | 3279002 | 2022-10-23 | US | Nebraska | Unassigned | 90031 | 16598 | 1038 | 0 | 42.8997274 | 0.0 | 2022-10-24 04:22:29 | Unassigned, Nebraska, US | |
2270040 | 2270040 | 2022-10-22 | US | Nebraska | Unassigned | 90031 | 16598 | 1038 | 0 | 42.8997274 | 0.0 | 2022-10-23 04:22:46 | Unassigned, Nebraska, US | |
1594340 | 1594340 | 2022-10-21 | US | Nebraska | Unassigned | 90031 | 16598 | 1038 | 0 | 42.8997274 | 0.0 | 2022-10-22 04:22:53 | Unassigned, Nebraska, US | |
2274056 | 2274056 | 2022-10-20 | US | Nebraska | Unassigned | 90031 | 16598 | 1038 | 0 | 42.8997274 | 0.0 | 2022-10-21 04:22:23 | Unassigned, Nebraska, US | |
2272625 | 2272625 | 2022-10-20 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-21 04:22:23 | Gadsden, Florida, US | |
200391 | 200391 | 2022-10-19 | US | Nebraska | Unassigned | 90031 | 16598 | 1038 | 0 | 42.8997274 | 0.0 | 2022-10-20 04:22:59 | Unassigned, Nebraska, US | |
198960 | 198960 | 2022-10-19 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-20 04:22:59 | Gadsden, Florida, US | |
2757621 | 2757621 | 2022-10-18 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-19 04:22:26 | Gadsden, Florida, US | |
2025455 | 2025455 | 2022-10-17 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-18 04:22:42 | Gadsden, Florida, US | |
2160233 | 2160233 | 2022-10-16 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-17 04:20:31 | Gadsden, Florida, US | |
516430 | 516430 | 2022-10-15 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-16 04:22:39 | Gadsden, Florida, US | |
2033487 | 2033487 | 2022-10-14 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-15 04:22:00 | Gadsden, Florida, US | |
3756900 | 3756900 | 2022-10-13 | US | Virginia | Washington | 51191 | 16598 | 230 | 0 | 36.72341572 | -81.95666289 | 2022-10-14 04:22:28 | Washington, Virginia, US | |
3754175 | 3754175 | 2022-10-13 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-14 04:22:28 | Gadsden, Florida, US | |
3215000 | 3215000 | 2022-10-12 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-13 04:22:39 | Gadsden, Florida, US | |
3250849 | 3250849 | 2022-10-11 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-12 04:22:51 | Gadsden, Florida, US | |
2968108 | 2968108 | 2022-10-10 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-11 04:23:05 | Gadsden, Florida, US | |
3098144 | 3098144 | 2022-10-09 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-10 04:22:32 | Gadsden, Florida, US | |
4003369 | 4003369 | 2022-10-08 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-09 04:21:16 | Gadsden, Florida, US | |
396966 | 396966 | 2022-10-07 | US | Florida | Gadsden | 12039 | 16598 | 224 | 0 | 30.57796289 | -84.61915825 | 2022-10-08 04:22:56 | Gadsden, Florida, US | |
3826636 | 3826636 | 2022-09-10 | US | New Jersey | Salem | 34033 | 16598 | 257 | 0 | 39.58719656 | -75.3469663 | 2022-09-11 04:20:50 | Salem, New Jersey, US | |
3618729 | 3618729 | 2022-08-01 | US | Michigan | Isabella | 26073 | 16598 | 221 | 0 | 43.64060976 | -84.84664923 | 2022-08-02 04:20:53 | Isabella, Michigan, US | |
3873209 | 3873209 | 2022-07-31 | US | Michigan | Isabella | 26073 | 16598 | 221 | 0 | 43.64060976 | -84.84664923 | 2022-08-01 04:21:03 | Isabella, Michigan, US | |
675963 | 675963 | 2022-07-30 | US | Michigan | Isabella | 26073 | 16598 | 221 | 0 | 43.64060976 | -84.84664923 | 2022-07-31 04:21:02 | Isabella, Michigan, US | |
1785162 | 1785162 | 2022-07-29 | US | Michigan | Isabella | 26073 | 16598 | 221 | 0 | 43.64060976 | -84.84664923 | 2022-07-30 04:20:42 | Isabella, Michigan, US | |
1067525 | 1067525 | 2022-07-28 | US | Michigan | Isabella | 26073 | 16598 | 221 | 0 | 43.64060976 | -84.84664923 | 2022-07-29 04:20:45 | Isabella, Michigan, US | |
2337044 | 2337044 | 2022-07-27 | US | Michigan | Isabella | 26073 | 16598 | 221 | 0 | 43.64060976 | -84.84664923 | 2022-07-28 04:20:56 | Isabella, Michigan, US | |
1489234 | 1489234 | 2022-07-26 | US | Michigan | Isabella | 26073 | 16598 | 221 | 0 | 43.64060976 | -84.84664923 | 2022-07-27 04:21:04 | Isabella, Michigan, US | |
3211945 | 3211945 | 2022-07-18 | US | Michigan | Marquette | 26103 | 16598 | 139 | 0 | 46.4338914 | -87.64043701 | 2022-07-19 04:20:58 | Marquette, Michigan, US | |
3407120 | 3407120 | 2022-07-17 | US | Michigan | Marquette | 26103 | 16598 | 139 | 0 | 46.4338914 | -87.64043701 | 2022-07-18 04:20:59 | Marquette, Michigan, US | |
2153320 | 2153320 | 2022-07-16 | US | Michigan | Marquette | 26103 | 16598 | 139 | 0 | 46.4338914 | -87.64043701 | 2022-07-17 04:21:15 | Marquette, Michigan, US | |
2420553 | 2420553 | 2022-07-15 | US | Michigan | Marquette | 26103 | 16598 | 139 | 0 | 46.4338914 | -87.64043701 | 2022-07-16 04:21:05 | Marquette, Michigan, US | |
3430628 | 3430628 | 2022-07-14 | US | Michigan | Marquette | 26103 | 16598 | 139 | 0 | 46.4338914 | -87.64043701 | 2022-07-15 04:20:53 | Marquette, Michigan, US | |
3111148 | 3111148 | 2022-07-13 | US | Michigan | Marquette | 26103 | 16598 | 139 | 0 | 46.4338914 | -87.64043701 | 2022-07-14 04:20:57 | Marquette, Michigan, US | |
631571 | 631571 | 2022-07-12 | US | Michigan | Marquette | 26103 | 16598 | 139 | 0 | 46.4338914 | -87.64043701 | 2022-07-13 04:20:58 | Marquette, Michigan, US | |
2238019 | 2238019 | 2022-06-12 | US | Oregon | Polk | 41053 | 16598 | 135 | 0 | 44.90322804 | -123.4128888 | 2022-06-13 04:21:14 | Polk, Oregon, US | |
3144217 | 3144217 | 2022-06-11 | US | Oregon | Polk | 41053 | 16598 | 135 | 0 | 44.90322804 | -123.4128888 | 2022-06-12 04:20:53 | Polk, Oregon, US | |
1947133 | 1947133 | 2022-06-10 | US | Oregon | Polk | 41053 | 16598 | 135 | 0 | 44.90322804 | -123.4128888 | 2022-06-11 04:21:01 | Polk, Oregon, US | |
922635 | 922635 | 2022-03-08 | US | Tennessee | Hawkins | 47073 | 16598 | 293 | 0 | 36.44355426 | -82.94885298 | 2022-03-09 04:20:59 | Hawkins, Tennessee, US | |
1781606 | 1781606 | 2022-01-27 | US | New Mexico | Valencia | 35061 | 16598 | 220 | 0 | 34.71669834 | -106.8103733 | 2022-01-28 04:21:09 | Valencia, New Mexico, US | |
1320719 | 1320719 | 2022-01-26 | US | Ohio | Pickaway | 39129 | 16598 | 208 | 0 | 39.64170392 | -83.0243386 | 2022-01-27 04:21:19 | Pickaway, Ohio, US | |
1701311 | 1701311 | 2022-01-03 | US | Illinois | Adams | 17001 | 16598 | 172 | 0 | 39.98815591 | -91.18786813 | 2022-01-04 04:22:17 | Adams, Illinois, US | |
2776079 | 2776079 | 2021-09-30 | US | Texas | Gregg | 48183 | 16598 | 477 | 0 | 32.47940482 | -94.81591935 | 2021-10-01 04:21:35 | Gregg, Texas, US | |
709535 | 709535 | 2021-09-29 | US | Texas | Gregg | 48183 | 16598 | 472 | 0 | 32.47940482 | -94.81591935 | 2021-09-30 04:21:20 | Gregg, Texas, US | |
1337377 | 1337377 | 2021-09-28 | US | Texas | Gregg | 48183 | 16598 | 468 | 0 | 32.47940482 | -94.81591935 | 2021-09-29 04:21:45 | Gregg, Texas, US | |
602067 | 602067 | 2021-09-23 | US | Alabama | Houston | 1069 | 16598 | 377 | 0 | 31.15197924 | -85.29939599 | 2021-09-24 04:21:44 | Houston, Alabama, US | |
3127965 | 3127965 | 2021-06-28 | US | Ohio | Fairfield | 39045 | 16598 | 207 | 0 | 39.75107189 | -82.63088163 | 2021-06-29 04:21:28 | Fairfield, Ohio, US | |
2592460 | 2592460 | 2021-06-27 | US | Ohio | Fairfield | 39045 | 16598 | 207 | 0 | 39.75107189 | -82.63088163 | 2021-06-28 04:21:29 | Fairfield, Ohio, US | |
609062 | 609062 | 2021-04-09 | US | Virginia | Norfolk | 51710 | 16598 | 239 | 0 | 36.89934014 | -76.26420872 | 2021-04-10 04:20:59 | Norfolk, Virginia, US | |
1858938 | 1858938 | 2021-02-25 | US | Idaho | Kootenai | 16055 | 16598 | 179 | 0 | 16419 | 47.67282258 | -116.7020872 | 2021-02-26 05:22:40 | Kootenai, Idaho, US |
3601143 | 3601143 | 2021-02-17 | Mexico | Tlaxcala | 16598 | 2063 | 0 | 14535 | 19.3139 | -98.2404 | 2021-02-18 05:22:58 | Tlaxcala, Mexico | ||
2227713 | 2227713 | 2021-01-02 | Russia | Chuvashia Republic | 16598 | 549 | 14960 | 1089 | 55.4259922 | 47.0849429 | 2021-01-03 05:22:52 | Chuvashia Republic, Russia | ||
1600107 | 1600107 | 2020-12-10 | Estonia | 16598 | 141 | 9945 | 6512 | 58.5953 | 25.0136 | 2020-12-11 05:26:59 | Estonia | |||
895757 | 895757 | 2020-11-05 | Ukraine | Zhytomyr Oblast | 16598 | 290 | 9051 | 7257 | 50.2547 | 28.6587 | 2020-11-06 05:24:55 | Zhytomyr Oblast, Ukraine | ||
2060252 | 2060252 | 2020-09-01 | US | Alabama | Jefferson | 1073 | 16598 | 299 | 0 | 16299 | 33.55554728 | -86.89506300000002 | 2020-09-02 04:28:25 | Jefferson, Alabama, US |
2991832 | 2991832 | 2020-08-24 | US | California | San Joaquin | 6077 | 16598 | 305 | 0 | 16292 | 37.93433732 | -121.2730061 | 2020-08-25 04:28:02 | San Joaquin, California, 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]);