johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where confirmed = 12176 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2396425 | 2396425 | 2022-09-12 | US | Michigan | Cass | 26027 | 12176 | 154 | 0 | 41.91522292 | -85.99405727 | 2022-09-13 04:20:57 | Cass, Michigan, US | |
3767503 | 3767503 | 2022-09-11 | US | Michigan | Cass | 26027 | 12176 | 154 | 0 | 41.91522292 | -85.99405727 | 2022-09-12 04:20:58 | Cass, Michigan, US | |
3826078 | 3826078 | 2022-09-10 | US | Michigan | Cass | 26027 | 12176 | 154 | 0 | 41.91522292 | -85.99405727 | 2022-09-11 04:20:50 | Cass, Michigan, US | |
964535 | 964535 | 2022-09-09 | US | Michigan | Cass | 26027 | 12176 | 154 | 0 | 41.91522292 | -85.99405727 | 2022-09-10 04:21:10 | Cass, Michigan, US | |
254937 | 254937 | 2022-09-08 | US | Michigan | Cass | 26027 | 12176 | 154 | 0 | 41.91522292 | -85.99405727 | 2022-09-09 04:21:11 | Cass, Michigan, US | |
3746735 | 3746735 | 2022-09-07 | US | Michigan | Cass | 26027 | 12176 | 154 | 0 | 41.91522292 | -85.99405727 | 2022-09-08 04:21:02 | Cass, Michigan, US | |
117677 | 117677 | 2022-09-06 | US | Tennessee | Cheatham | 47021 | 12176 | 133 | 0 | 36.26136216 | -87.08903581 | 2022-09-07 04:20:59 | Cheatham, Tennessee, US | |
116375 | 116375 | 2022-09-06 | US | Michigan | Cass | 26027 | 12176 | 154 | 0 | 41.91522292 | -85.99405727 | 2022-09-07 04:20:59 | Cass, Michigan, US | |
115848 | 115848 | 2022-09-06 | US | Indiana | Harrison | 18061 | 12176 | 144 | 0 | 38.19467379 | -86.10948271 | 2022-09-07 04:20:59 | Harrison, Indiana, US | |
2634820 | 2634820 | 2022-09-05 | US | Indiana | Harrison | 18061 | 12176 | 144 | 0 | 38.19467379 | -86.10948271 | 2022-09-06 04:21:02 | Harrison, Indiana, US | |
2988384 | 2988384 | 2022-09-04 | US | Indiana | Harrison | 18061 | 12176 | 144 | 0 | 38.19467379 | -86.10948271 | 2022-09-05 04:21:01 | Harrison, Indiana, US | |
2714069 | 2714069 | 2022-09-03 | US | Indiana | Harrison | 18061 | 12176 | 144 | 0 | 38.19467379 | -86.10948271 | 2022-09-04 04:21:22 | Harrison, Indiana, US | |
1394774 | 1394774 | 2022-09-02 | US | Indiana | Harrison | 18061 | 12176 | 144 | 0 | 38.19467379 | -86.10948271 | 2022-09-03 04:21:04 | Harrison, Indiana, US | |
1651943 | 1651943 | 2022-06-23 | US | Wisconsin | Marinette | 55075 | 12176 | 130 | 0 | 45.38553432 | -88.033246 | 2022-06-24 04:20:58 | Marinette, Wisconsin, US | |
2202931 | 2202931 | 2022-03-06 | US | Vermont | Rutland | 50021 | 12176 | 71 | 0 | 43.57723578 | -73.03741676 | 2022-03-07 04:20:47 | Rutland, Vermont, US | |
2095388 | 2095388 | 2022-03-05 | US | Vermont | Rutland | 50021 | 12176 | 71 | 0 | 43.57723578 | -73.03741676 | 2022-03-06 04:20:49 | Rutland, Vermont, US | |
2669088 | 2669088 | 2022-03-04 | US | Vermont | Rutland | 50021 | 12176 | 71 | 0 | 43.57723578 | -73.03741676 | 2022-03-05 04:21:10 | Rutland, Vermont, US | |
1646742 | 1646742 | 2022-03-03 | US | North Carolina | Watauga | 37189 | 12176 | 53 | 0 | 36.23103603 | -81.70033724 | 2022-03-04 04:21:09 | Watauga, North Carolina, US | |
945522 | 945522 | 2022-02-28 | US | Pennsylvania | Mifflin | 42087 | 12176 | 270 | 0 | 40.61116939 | -77.61070738 | 2022-03-01 04:21:09 | Mifflin, Pennsylvania, US | |
3226831 | 3226831 | 2022-01-19 | US | Alabama | Jackson | 1071 | 12176 | 207 | 0 | 34.78144169 | -85.99750489 | 2022-01-20 04:21:07 | Jackson, Alabama, US | |
102313 | 102313 | 2022-01-14 | US | Tennessee | Roane | 47145 | 12176 | 190 | 0 | 35.84923189 | -84.52458689 | 2022-01-15 04:21:07 | Roane, Tennessee, US | |
551860 | 551860 | 2021-12-08 | US | Indiana | Floyd | 18043 | 12176 | 228 | 0 | 38.32117957 | -85.90385377 | 2021-12-09 04:22:49 | Floyd, Indiana, US | |
3403808 | 3403808 | 2021-11-30 | US | North Carolina | Stanly | 37167 | 12176 | 198 | 0 | 35.31647813 | -80.25093221 | 2021-12-01 04:22:29 | Stanly, North Carolina, US | |
723017 | 723017 | 2021-11-20 | US | Arkansas | Pope | 5115 | 12176 | 159 | 0 | 35.44871474 | -93.03212219 | 2021-11-21 04:22:13 | Pope, Arkansas, US | |
2078859 | 2078859 | 2021-09-26 | US | Tennessee | Anderson | 47001 | 12176 | 195 | 0 | 36.12684348 | -84.19965764 | 2021-09-27 04:21:16 | Anderson, Tennessee, US | |
1921013 | 1921013 | 2021-09-24 | China | Hong Kong | 12176 | 213 | 0 | 22.3 | 114.2 | 2021-09-25 04:21:31 | Hong Kong, China | |||
1596234 | 1596234 | 2021-08-26 | Japan | Nara | 12176 | 136 | 0 | 34.317451 | 135.871644 | 2021-08-27 04:21:37 | Nara, Japan | |||
3359111 | 3359111 | 2021-06-21 | US | Arizona | Cochise | 4003 | 12176 | 292 | 0 | 31.87934684 | -109.7516088 | 2021-06-22 04:21:34 | Cochise, Arizona, US | |
1188837 | 1188837 | 2021-05-31 | Mexico | Nayarit | 12176 | 1829 | 0 | 10347 | 21.7514 | -104.8455 | 2021-06-01 04:23:09 | Nayarit, Mexico | ||
1809536 | 1809536 | 2021-05-27 | US | Rhode Island | Unassigned | 90044 | 12176 | 11 | 0 | 41.87064746 | 0.0 | 2021-05-28 04:20:36 | Unassigned, Rhode Island, US | |
1413368 | 1413368 | 2021-05-24 | Sweden | Jamtland Harjedalen | 12176 | 120 | 0 | 12056 | 63.1712 | 14.9592 | 2021-05-25 04:21:08 | Jamtland Harjedalen, Sweden | ||
1771654 | 1771654 | 2021-05-23 | Sweden | Jamtland Harjedalen | 12176 | 120 | 0 | 12056 | 63.1712 | 14.9592 | 2021-05-24 04:20:53 | Jamtland Harjedalen, Sweden | ||
726809 | 726809 | 2021-05-22 | Sweden | Jamtland Harjedalen | 12176 | 120 | 0 | 12056 | 63.1712 | 14.9592 | 2021-05-23 04:20:51 | Jamtland Harjedalen, Sweden | ||
1952824 | 1952824 | 2021-05-21 | Sweden | Jamtland Harjedalen | 12176 | 120 | 0 | 12056 | 63.1712 | 14.9592 | 2021-05-22 04:20:45 | Jamtland Harjedalen, Sweden | ||
3666590 | 3666590 | 2021-03-09 | US | Tennessee | Sevier | 47155 | 12176 | 165 | 0 | 35.78077323 | -83.52244332 | 2021-03-10 05:24:35 | Sevier, Tennessee, US | |
57593 | 57593 | 2021-03-07 | US | Rhode Island | Unassigned | 90044 | 12176 | 41 | 0 | 41.87064746 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Rhode Island, US | |
3670410 | 3670410 | 2021-03-06 | US | Rhode Island | Unassigned | 90044 | 12176 | 41 | 0 | 12135 | 41.87064746 | 0.0 | 2021-03-07 05:21:54 | Unassigned, Rhode Island, US |
1619031 | 1619031 | 2021-03-05 | US | Rhode Island | Unassigned | 90044 | 12176 | 41 | 0 | 12135 | 41.87064746 | 0.0 | 2021-03-06 04:23:41 | Unassigned, Rhode Island, US |
2211287 | 2211287 | 2021-03-04 | Ukraine | Sevastopol* | 12176 | 506 | 11351 | 319 | 44.6054 | 33.522 | 2021-03-05 05:26:29 | Sevastopol*, Ukraine | ||
2211133 | 2211133 | 2021-03-04 | US | West Virginia | Kanawha | 54039 | 12176 | 286 | 0 | 11890 | 38.33860077 | -81.52857054 | 2021-03-05 05:26:29 | Kanawha, West Virginia, US |
3539419 | 3539419 | 2021-02-12 | India | Nagaland | 12176 | 88 | 12011 | 77 | 26.06702 | 94.470302 | 2021-02-13 05:22:12 | Nagaland, India | ||
1529731 | 1529731 | 2021-02-09 | US | Mississippi | Rankin | 28121 | 12176 | 246 | 0 | 11930 | 32.26469147 | -89.94537876 | 2021-02-10 05:22:41 | Rankin, Mississippi, US |
1675105 | 1675105 | 2021-02-07 | US | Pennsylvania | Centre | 42027 | 12176 | 201 | 0 | 11975 | 40.92058903 | -77.82200624 | 2021-02-08 05:22:39 | Centre, Pennsylvania, US |
3035638 | 3035638 | 2021-01-05 | US | Kansas | Shawnee | 20177 | 12176 | 225 | 0 | 11951 | 39.04100763 | -95.7557264 | 2021-01-06 05:22:16 | Shawnee, Kansas, US |
1063183 | 1063183 | 2021-01-04 | US | Kansas | Shawnee | 20177 | 12176 | 225 | 0 | 11951 | 39.04100763 | -95.7557264 | 2021-01-05 05:21:49 | Shawnee, Kansas, US |
1037560 | 1037560 | 2020-12-15 | US | Texas | Potter | 48375 | 12176 | 264 | 0 | 14151 | 35.40133773 | -101.893964 | 2020-12-16 05:28:04 | Potter, Texas, US |
1584422 | 1584422 | 2020-11-30 | Russia | Vologda Oblast | 12176 | 152 | 10231 | 1793 | 60.0391461 | 43.1215213 | 2020-12-01 05:26:18 | Vologda Oblast, Russia | ||
2702178 | 2702178 | 2020-11-20 | US | Florida | Alachua | 12001 | 12176 | 92 | 0 | 12084 | 29.67866525 | -82.35928158 | 2020-11-21 05:25:51 | Alachua, Florida, US |
79983 | 79983 | 2020-10-14 | US | Hawaii | Honolulu | 15003 | 12176 | 146 | 0 | 12030 | 21.45803166 | -157.97121819999995 | 2020-10-15 04:24:28 | Honolulu, Hawaii, US |
969569 | 969569 | 2020-09-29 | US | Pennsylvania | Montgomery | 42091 | 12176 | 878 | 0 | 11298 | 40.21053671 | -75.36652296 | 2020-09-30 04:23:33 | Montgomery, Pennsylvania, US |
1920249 | 1920249 | 2020-08-10 | Russia | Chelyabinsk Oblast | 12176 | 95 | 7693 | 4388 | 54.4223954 | 61.1865846 | 2020-08-11 04:35:08 | Chelyabinsk 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]);