johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
324 rows where confirmed = 1884 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309247 | 309247 | 2022-12-13 | US | Kansas | Wabaunsee | 20197 | 1884 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-14 04:21:04 | Wabaunsee, Kansas, US | |
1150308 | 1150308 | 2022-12-12 | US | Kansas | Wabaunsee | 20197 | 1884 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-13 04:21:01 | Wabaunsee, Kansas, US | |
870162 | 870162 | 2022-12-11 | US | Kansas | Wabaunsee | 20197 | 1884 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-12 04:21:01 | Wabaunsee, Kansas, US | |
258692 | 258692 | 2022-12-10 | US | Kansas | Wabaunsee | 20197 | 1884 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-11 04:20:50 | Wabaunsee, Kansas, US | |
3937406 | 3937406 | 2022-12-09 | US | Kansas | Wabaunsee | 20197 | 1884 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-10 04:21:02 | Wabaunsee, Kansas, US | |
3378738 | 3378738 | 2022-12-08 | US | Kansas | Wabaunsee | 20197 | 1884 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-09 04:21:05 | Wabaunsee, Kansas, US | |
1986009 | 1986009 | 2022-12-07 | US | Kansas | Wabaunsee | 20197 | 1884 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-12-08 04:21:07 | Wabaunsee, Kansas, US | |
2136753 | 2136753 | 2022-12-01 | US | California | Trinity | 6105 | 1884 | 22 | 0 | 40.6491767 | -123.114713 | 2022-12-02 04:21:07 | Trinity, California, US | |
2969081 | 2969081 | 2022-10-10 | US | Michigan | Montmorency | 26119 | 1884 | 49 | 0 | 45.0275929 | -84.12696227 | 2022-10-11 04:23:05 | Montmorency, Michigan, US | |
3099117 | 3099117 | 2022-10-09 | US | Michigan | Montmorency | 26119 | 1884 | 49 | 0 | 45.0275929 | -84.12696227 | 2022-10-10 04:22:32 | Montmorency, Michigan, US | |
4004342 | 4004342 | 2022-10-08 | US | Michigan | Montmorency | 26119 | 1884 | 49 | 0 | 45.0275929 | -84.12696227 | 2022-10-09 04:21:16 | Montmorency, Michigan, US | |
397939 | 397939 | 2022-10-07 | US | Michigan | Montmorency | 26119 | 1884 | 49 | 0 | 45.0275929 | -84.12696227 | 2022-10-08 04:22:56 | Montmorency, Michigan, US | |
2531056 | 2531056 | 2022-10-06 | US | Michigan | Montmorency | 26119 | 1884 | 49 | 0 | 45.0275929 | -84.12696227 | 2022-10-07 04:23:08 | Montmorency, Michigan, US | |
1812450 | 1812450 | 2022-10-05 | US | Michigan | Montmorency | 26119 | 1884 | 49 | 0 | 45.0275929 | -84.12696227 | 2022-10-06 04:21:22 | Montmorency, Michigan, US | |
132424 | 132424 | 2022-10-04 | US | Michigan | Montmorency | 26119 | 1884 | 49 | 0 | 45.0275929 | -84.12696227 | 2022-10-05 04:23:06 | Montmorency, Michigan, US | |
1978080 | 1978080 | 2022-09-25 | US | Kentucky | Owsley | 21189 | 1884 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-26 04:20:52 | Owsley, Kentucky, US | |
2651247 | 2651247 | 2022-09-24 | US | Kentucky | Owsley | 21189 | 1884 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-25 04:23:31 | Owsley, Kentucky, US | |
385687 | 385687 | 2022-09-23 | US | Kentucky | Owsley | 21189 | 1884 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-24 04:21:40 | Owsley, Kentucky, US | |
1626267 | 1626267 | 2022-09-22 | US | Missouri | Sullivan | 29211 | 1884 | 25 | 0 | 40.2099105 | -93.11150106 | 2022-09-23 04:23:13 | Sullivan, Missouri, US | |
1625753 | 1625753 | 2022-09-22 | US | Kentucky | Owsley | 21189 | 1884 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-23 04:23:13 | Owsley, Kentucky, US | |
1372471 | 1372471 | 2022-09-21 | US | Missouri | Sullivan | 29211 | 1884 | 25 | 0 | 40.2099105 | -93.11150106 | 2022-09-22 04:22:56 | Sullivan, Missouri, US | |
1371957 | 1371957 | 2022-09-21 | US | Kentucky | Owsley | 21189 | 1884 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-22 04:22:56 | Owsley, Kentucky, US | |
2018701 | 2018701 | 2022-09-20 | US | Missouri | Sullivan | 29211 | 1884 | 25 | 0 | 40.2099105 | -93.11150106 | 2022-09-21 04:23:22 | Sullivan, Missouri, US | |
2018187 | 2018187 | 2022-09-20 | US | Kentucky | Owsley | 21189 | 1884 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-21 04:23:22 | Owsley, Kentucky, US | |
2017142 | 2017142 | 2022-09-20 | US | Alaska | Aleutians West | 2016 | 1884 | 3 | 0 | 52.3233 | -174.1596 | 2022-09-21 04:23:22 | Aleutians West, Alaska, US | |
3572574 | 3572574 | 2022-09-19 | US | Missouri | Sullivan | 29211 | 1884 | 25 | 0 | 40.2099105 | -93.11150106 | 2022-09-20 04:22:48 | Sullivan, Missouri, US | |
3572060 | 3572060 | 2022-09-19 | US | Kentucky | Owsley | 21189 | 1884 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-09-20 04:22:48 | Owsley, Kentucky, US | |
3571015 | 3571015 | 2022-09-19 | US | Alaska | Aleutians West | 2016 | 1884 | 3 | 0 | 52.3233 | -174.1596 | 2022-09-20 04:22:48 | Aleutians West, Alaska, US | |
421313 | 421313 | 2022-09-18 | US | Missouri | Sullivan | 29211 | 1884 | 25 | 0 | 40.2099105 | -93.11150106 | 2022-09-19 04:21:49 | Sullivan, Missouri, US | |
419754 | 419754 | 2022-09-18 | US | Alaska | Aleutians West | 2016 | 1884 | 3 | 0 | 52.3233 | -174.1596 | 2022-09-19 04:21:49 | Aleutians West, Alaska, US | |
3375337 | 3375337 | 2022-09-17 | US | Missouri | Sullivan | 29211 | 1884 | 25 | 0 | 40.2099105 | -93.11150106 | 2022-09-18 04:22:50 | Sullivan, Missouri, US | |
3373778 | 3373778 | 2022-09-17 | US | Alaska | Aleutians West | 2016 | 1884 | 3 | 0 | 52.3233 | -174.1596 | 2022-09-18 04:22:50 | Aleutians West, Alaska, US | |
2357445 | 2357445 | 2022-09-16 | US | Missouri | Sullivan | 29211 | 1884 | 25 | 0 | 40.2099105 | -93.11150106 | 2022-09-17 04:20:19 | Sullivan, Missouri, US | |
2355886 | 2355886 | 2022-09-16 | US | Alaska | Aleutians West | 2016 | 1884 | 3 | 0 | 52.3233 | -174.1596 | 2022-09-17 04:20:19 | Aleutians West, Alaska, US | |
3987043 | 3987043 | 2022-09-15 | US | Alaska | Aleutians West | 2016 | 1884 | 3 | 0 | 52.3233 | -174.1596 | 2022-09-16 04:21:19 | Aleutians West, Alaska, US | |
1889560 | 1889560 | 2022-09-14 | US | Alaska | Aleutians West | 2016 | 1884 | 3 | 0 | 52.3233 | -174.1596 | 2022-09-15 04:21:02 | Aleutians West, Alaska, US | |
2831851 | 2831851 | 2022-08-25 | US | Texas | Brooks | 48047 | 1884 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-08-26 04:21:02 | Brooks, Texas, US | |
880763 | 880763 | 2022-08-05 | US | Arkansas | Dallas | 5039 | 1884 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-08-06 04:20:56 | Dallas, Arkansas, US | |
1214537 | 1214537 | 2022-07-11 | US | Tennessee | Pickett | 47137 | 1884 | 36 | 0 | 36.55606529 | -85.077633 | 2022-07-12 04:20:51 | Pickett, Tennessee, US | |
1650289 | 1650289 | 2022-06-23 | US | Missouri | Hickory | 29085 | 1884 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-06-24 04:20:58 | Hickory, Missouri, US | |
2189524 | 2189524 | 2022-06-22 | US | Missouri | Hickory | 29085 | 1884 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-06-23 04:20:55 | Hickory, Missouri, US | |
167955 | 167955 | 2022-06-21 | US | Missouri | Hickory | 29085 | 1884 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-06-22 04:20:54 | Hickory, Missouri, US | |
1765238 | 1765238 | 2022-06-20 | US | Missouri | Hickory | 29085 | 1884 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-06-21 04:20:56 | Hickory, Missouri, US | |
3271424 | 3271424 | 2022-06-19 | US | Missouri | Hickory | 29085 | 1884 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-06-20 04:21:01 | Hickory, Missouri, US | |
3399336 | 3399336 | 2022-06-18 | US | Missouri | Hickory | 29085 | 1884 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-06-19 04:20:51 | Hickory, Missouri, US | |
2314307 | 2314307 | 2022-06-17 | US | Tennessee | Van Buren | 47175 | 1884 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-06-18 04:21:10 | Van Buren, Tennessee, US | |
2313213 | 2313213 | 2022-06-17 | US | Missouri | Hickory | 29085 | 1884 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-06-18 04:21:10 | Hickory, Missouri, US | |
973652 | 973652 | 2022-06-01 | US | Puerto Rico | Ceiba | 72037 | 1884 | 0 | 0 | 18.251818 | -65.666416 | 2022-06-02 05:20:39 | Ceiba, Puerto Rico, US | |
230570 | 230570 | 2022-05-31 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-01 04:20:55 | Russell, Kansas, US | |
3187335 | 3187335 | 2022-05-30 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-05-31 04:20:51 | Russell, Kansas, US | |
3199484 | 3199484 | 2022-05-29 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-05-30 04:20:50 | Russell, Kansas, US | |
2726362 | 2726362 | 2022-05-28 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-05-29 04:20:53 | Russell, Kansas, US | |
1315543 | 1315543 | 2022-05-27 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-05-28 04:21:07 | Russell, Kansas, US | |
1851335 | 1851335 | 2022-05-26 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-05-27 04:20:56 | Russell, Kansas, US | |
2049211 | 2049211 | 2022-05-25 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-05-26 04:20:50 | Russell, Kansas, US | |
623222 | 623222 | 2022-05-22 | US | Kansas | Russell | 20167 | 1884 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-05-26 04:20:50 | Russell, Kansas, US | |
1112952 | 1112952 | 2022-05-21 | US | Virginia | Middlesex | 51119 | 1884 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-05-22 04:20:52 | Middlesex, Virginia, US | |
1172576 | 1172576 | 2022-05-20 | US | Virginia | Middlesex | 51119 | 1884 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-05-21 04:20:58 | Middlesex, Virginia, US | |
3448320 | 3448320 | 2022-05-11 | US | West Virginia | Calhoun | 54013 | 1884 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-12 04:20:54 | Calhoun, West Virginia, US | |
3538937 | 3538937 | 2022-05-10 | US | West Virginia | Calhoun | 54013 | 1884 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-11 04:20:48 | Calhoun, West Virginia, US | |
225472 | 225472 | 2022-05-09 | US | West Virginia | Calhoun | 54013 | 1884 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-10 04:20:50 | Calhoun, West Virginia, US | |
3852450 | 3852450 | 2022-04-27 | US | Colorado | Lake | 8065 | 1884 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-04-28 04:20:47 | Lake, Colorado, US | |
1327071 | 1327071 | 2022-04-26 | US | Georgia | Irwin | 13155 | 1884 | 49 | 0 | 31.60213036 | -83.27501387 | 2022-04-27 04:20:52 | Irwin, Georgia, US | |
3723025 | 3723025 | 2022-04-25 | US | Georgia | Irwin | 13155 | 1884 | 49 | 0 | 31.60213036 | -83.27501387 | 2022-04-26 04:20:51 | Irwin, Georgia, US | |
2029593 | 2029593 | 2022-04-24 | US | Georgia | Irwin | 13155 | 1884 | 49 | 0 | 31.60213036 | -83.27501387 | 2022-04-25 04:20:56 | Irwin, Georgia, US | |
747168 | 747168 | 2022-04-23 | US | Georgia | Irwin | 13155 | 1884 | 49 | 0 | 31.60213036 | -83.27501387 | 2022-04-24 04:20:56 | Irwin, Georgia, US | |
3437653 | 3437653 | 2022-04-22 | US | Georgia | Irwin | 13155 | 1884 | 49 | 0 | 31.60213036 | -83.27501387 | 2022-04-23 04:20:50 | Irwin, Georgia, US | |
2893238 | 2893238 | 2022-04-21 | US | Georgia | Irwin | 13155 | 1884 | 49 | 0 | 31.60213036 | -83.27501387 | 2022-04-22 04:20:45 | Irwin, Georgia, US | |
2308110 | 2308110 | 2022-04-20 | US | Georgia | Irwin | 13155 | 1884 | 49 | 0 | 31.60213036 | -83.27501387 | 2022-04-21 04:20:46 | Irwin, Georgia, US | |
2254490 | 2254490 | 2022-04-19 | US | Texas | Crosby | 48107 | 1884 | 45 | 0 | 33.61431553 | -101.30003640000001 | 2022-04-20 04:20:45 | Crosby, Texas, US | |
1655145 | 1655145 | 2022-04-09 | US | Puerto Rico | Jayuya | 72073 | 1884 | 0 | 0 | 18.211446 | -66.58878 | 2022-04-10 04:20:52 | Jayuya, Puerto Rico, US | |
2118467 | 2118467 | 2022-04-08 | US | Puerto Rico | Jayuya | 72073 | 1884 | 0 | 0 | 18.211446 | -66.58878 | 2022-04-09 04:20:42 | Jayuya, Puerto Rico, US | |
1547820 | 1547820 | 2022-03-07 | Colombia | Vaupes | 1884 | 19 | 0 | 0.8554 | -70.812 | 2022-03-08 04:20:54 | Vaupes, Colombia | |||
3915107 | 3915107 | 2022-02-20 | US | Texas | Floyd | 48153 | 1884 | 47 | 0 | 34.07227468 | -101.3031546 | 2022-02-21 04:21:05 | Floyd, Texas, US | |
3878665 | 3878665 | 2022-02-19 | US | Texas | Floyd | 48153 | 1884 | 47 | 0 | 34.07227468 | -101.3031546 | 2022-02-20 04:21:00 | Floyd, Texas, US | |
3823955 | 3823955 | 2022-02-16 | US | West Virginia | Tucker | 54093 | 1884 | 33 | 0 | 39.11240885 | -79.57053576 | 2022-02-17 04:20:56 | Tucker, West Virginia, US | |
233752 | 233752 | 2022-02-11 | US | Arkansas | Monroe | 5095 | 1884 | 28 | 0 | 34.6815935 | -91.20540287 | 2022-02-12 04:21:06 | Monroe, Arkansas, US | |
3073860 | 3073860 | 2022-02-09 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-10 04:21:14 | Yunnan, China | |||
1364410 | 1364410 | 2022-02-08 | US | Nebraska | Cheyenne | 31033 | 1884 | 16 | 0 | 41.21999357 | -102.9941693 | 2022-02-09 04:21:04 | Cheyenne, Nebraska, US | |
1362167 | 1362167 | 2022-02-08 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-09 04:21:04 | Yunnan, China | |||
70905 | 70905 | 2022-02-07 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-08 04:21:15 | Yunnan, China | |||
2012521 | 2012521 | 2022-02-06 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-07 04:21:05 | Yunnan, China | |||
1293850 | 1293850 | 2022-02-05 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-06 04:21:00 | Yunnan, China | |||
2327178 | 2327178 | 2022-02-04 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-05 04:21:05 | Yunnan, China | |||
980688 | 980688 | 2022-02-01 | US | Minnesota | Marshall | 27089 | 1884 | 23 | 0 | 48.35825983 | -96.37017407 | 2022-02-02 04:21:09 | Marshall, Minnesota, US | |
2659584 | 2659584 | 2022-01-31 | US | Mississippi | Choctaw | 28019 | 1884 | 28 | 0 | 33.34598242 | -89.24809382 | 2022-02-01 04:21:11 | Choctaw, Mississippi, US | |
2658717 | 2658717 | 2022-01-31 | US | Idaho | Boundary | 16021 | 1884 | 54 | 0 | 48.76684761 | -116.4630179 | 2022-02-01 04:21:11 | Boundary, Idaho, US | |
1782755 | 1782755 | 2022-01-27 | US | Virginia | Lunenburg | 51111 | 1884 | 23 | 0 | 36.94618528 | -78.24133319 | 2022-01-28 04:21:09 | Lunenburg, Virginia, US | |
2054623 | 2054623 | 2022-01-25 | US | Puerto Rico | Florida | 72054 | 1884 | 0 | 0 | 18.373715 | -66.560488 | 2022-01-26 04:21:07 | Florida, Puerto Rico, US | |
1229935 | 1229935 | 2022-01-24 | US | North Carolina | Graham | 37075 | 1884 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-01-25 04:21:05 | Graham, North Carolina, US | |
1141865 | 1141865 | 2022-01-23 | US | Idaho | Owyhee | 16073 | 1884 | 43 | 0 | 42.58016894 | -116.16938710000001 | 2022-01-24 04:21:12 | Owyhee, Idaho, US | |
2833783 | 2833783 | 2022-01-22 | US | Idaho | Owyhee | 16073 | 1884 | 43 | 0 | 42.58016894 | -116.16938710000001 | 2022-01-23 04:21:13 | Owyhee, Idaho, US | |
1961432 | 1961432 | 2022-01-20 | US | Georgia | Stewart | 13259 | 1884 | 30 | 0 | 32.07996777 | -84.83208037 | 2022-01-21 04:21:09 | Stewart, Georgia, US | |
3229611 | 3229611 | 2022-01-19 | US | Texas | Live Oak | 48297 | 1884 | 39 | 0 | 28.35101362 | -98.1246786 | 2022-01-20 04:21:07 | Live Oak, Texas, US | |
1115035 | 1115035 | 2022-01-11 | US | Kentucky | McLean | 21149 | 1884 | 44 | 0 | 37.5301951 | -87.26803443 | 2022-01-12 04:21:44 | McLean, Kentucky, US | |
129085 | 129085 | 2022-01-09 | US | North Carolina | Pamlico | 37137 | 1884 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-10 04:22:07 | Pamlico, North Carolina, US | |
1217920 | 1217920 | 2022-01-08 | US | North Carolina | Pamlico | 37137 | 1884 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-09 04:21:46 | Pamlico, North Carolina, US | |
1392332 | 1392332 | 2022-01-07 | US | Pennsylvania | Forest | 42053 | 1884 | 31 | 0 | 41.51095103 | -79.23229292 | 2022-01-08 04:21:53 | Forest, Pennsylvania, US | |
1392013 | 1392013 | 2022-01-07 | US | North Carolina | Pamlico | 37137 | 1884 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-01-08 04:21:53 | Pamlico, North Carolina, US | |
1434473 | 1434473 | 2021-12-28 | US | Missouri | Grundy | 29079 | 1884 | 57 | 0 | 40.11406587 | -93.56509276 | 2021-12-29 03:21:43 | Grundy, Missouri, 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]);