johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
355 rows where confirmed = 1887 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754204 | 2754204 | 2022-12-29 | US | Kansas | Harper | 20077 | 1887 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-30 04:21:04 | Harper, Kansas, US | |
1075210 | 1075210 | 2022-12-28 | US | Kansas | Harper | 20077 | 1887 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-29 04:21:01 | Harper, Kansas, US | |
219947 | 219947 | 2022-12-26 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-27 04:21:07 | Shannon, Missouri, US | |
3224404 | 3224404 | 2022-12-25 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-26 04:21:06 | Shannon, Missouri, US | |
1020318 | 1020318 | 2022-12-24 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-25 04:21:04 | Shannon, Missouri, US | |
692341 | 692341 | 2022-12-23 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-24 04:21:02 | Shannon, Missouri, US | |
2181551 | 2181551 | 2022-12-22 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-23 04:21:04 | Shannon, Missouri, US | |
453355 | 453355 | 2022-12-21 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-22 04:20:56 | Shannon, Missouri, US | |
453172 | 453172 | 2022-12-21 | US | Minnesota | Wilkin | 27167 | 1887 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-22 04:20:56 | Wilkin, Minnesota, US | |
2953354 | 2953354 | 2022-12-20 | US | Missouri | Shannon | 29203 | 1887 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-21 04:21:03 | Shannon, Missouri, US | |
2953171 | 2953171 | 2022-12-20 | US | Minnesota | Wilkin | 27167 | 1887 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-21 04:21:03 | Wilkin, Minnesota, US | |
3175573 | 3175573 | 2022-12-19 | US | Minnesota | Wilkin | 27167 | 1887 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-20 04:21:04 | Wilkin, Minnesota, US | |
1630090 | 1630090 | 2022-12-18 | US | Minnesota | Wilkin | 27167 | 1887 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-19 04:21:03 | Wilkin, Minnesota, US | |
505469 | 505469 | 2022-12-17 | US | Minnesota | Wilkin | 27167 | 1887 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-18 04:21:03 | Wilkin, Minnesota, US | |
3326041 | 3326041 | 2022-12-16 | US | Minnesota | Wilkin | 27167 | 1887 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-17 04:21:04 | Wilkin, Minnesota, US | |
544553 | 544553 | 2022-12-15 | US | Minnesota | Wilkin | 27167 | 1887 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-16 04:21:01 | Wilkin, Minnesota, US | |
1150879 | 1150879 | 2022-12-12 | US | Missouri | Maries | 29125 | 1887 | 41 | 0 | 38.16193985 | -91.92249662 | 2022-12-13 04:21:01 | Maries, Missouri, US | |
870733 | 870733 | 2022-12-11 | US | Missouri | Maries | 29125 | 1887 | 41 | 0 | 38.16193985 | -91.92249662 | 2022-12-12 04:21:01 | Maries, Missouri, US | |
259263 | 259263 | 2022-12-10 | US | Missouri | Maries | 29125 | 1887 | 41 | 0 | 38.16193985 | -91.92249662 | 2022-12-11 04:20:50 | Maries, Missouri, US | |
3937977 | 3937977 | 2022-12-09 | US | Missouri | Maries | 29125 | 1887 | 41 | 0 | 38.16193985 | -91.92249662 | 2022-12-10 04:21:02 | Maries, Missouri, US | |
3379309 | 3379309 | 2022-12-08 | US | Missouri | Maries | 29125 | 1887 | 41 | 0 | 38.16193985 | -91.92249662 | 2022-12-09 04:21:05 | Maries, Missouri, US | |
1986580 | 1986580 | 2022-12-07 | US | Missouri | Maries | 29125 | 1887 | 41 | 0 | 38.16193985 | -91.92249662 | 2022-12-08 04:21:07 | Maries, Missouri, US | |
3716103 | 3716103 | 2022-12-06 | US | Missouri | Maries | 29125 | 1887 | 41 | 0 | 38.16193985 | -91.92249662 | 2022-12-07 04:20:58 | Maries, Missouri, US | |
1241275 | 1241275 | 2022-11-28 | US | Michigan | Alcona | 26001 | 1887 | 76 | 0 | 44.6846864 | -83.59507875 | 2022-11-29 04:21:05 | Alcona, Michigan, US | |
3553263 | 3553263 | 2022-11-27 | US | Michigan | Alcona | 26001 | 1887 | 76 | 0 | 44.6846864 | -83.59507875 | 2022-11-28 04:21:02 | Alcona, Michigan, US | |
3552262 | 3552262 | 2022-11-27 | US | Colorado | Clear Creek | 8019 | 1887 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-11-28 04:21:02 | Clear Creek, Colorado, US | |
2101743 | 2101743 | 2022-11-26 | US | Michigan | Alcona | 26001 | 1887 | 76 | 0 | 44.6846864 | -83.59507875 | 2022-11-27 04:21:05 | Alcona, Michigan, US | |
2100742 | 2100742 | 2022-11-26 | US | Colorado | Clear Creek | 8019 | 1887 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-11-27 04:21:05 | Clear Creek, Colorado, US | |
489234 | 489234 | 2022-11-25 | US | Michigan | Alcona | 26001 | 1887 | 76 | 0 | 44.6846864 | -83.59507875 | 2022-11-26 04:21:11 | Alcona, Michigan, US | |
488233 | 488233 | 2022-11-25 | US | Colorado | Clear Creek | 8019 | 1887 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-11-26 04:21:11 | Clear Creek, Colorado, US | |
3525063 | 3525063 | 2022-11-24 | US | Michigan | Alcona | 26001 | 1887 | 76 | 0 | 44.6846864 | -83.59507875 | 2022-11-25 04:21:06 | Alcona, Michigan, US | |
3313846 | 3313846 | 2022-11-23 | US | Michigan | Alcona | 26001 | 1887 | 76 | 0 | 44.6846864 | -83.59507875 | 2022-11-24 04:21:09 | Alcona, Michigan, US | |
1621887 | 1621887 | 2022-11-22 | US | Michigan | Alcona | 26001 | 1887 | 76 | 0 | 44.6846864 | -83.59507875 | 2022-11-23 04:21:06 | Alcona, Michigan, US | |
852978 | 852978 | 2022-11-02 | US | Virginia | Mathews | 51115 | 1887 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-03 04:22:05 | Mathews, Virginia, US | |
713829 | 713829 | 2022-11-01 | US | Virginia | Mathews | 51115 | 1887 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-02 04:22:09 | Mathews, Virginia, US | |
3288278 | 3288278 | 2022-10-31 | US | Virginia | Mathews | 51115 | 1887 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-01 04:22:36 | Mathews, Virginia, US | |
115947 | 115947 | 2022-09-06 | US | Iowa | Greene | 19073 | 1887 | 23 | 0 | 42.03614551 | -94.39658081 | 2022-09-07 04:20:59 | Greene, Iowa, US | |
2634919 | 2634919 | 2022-09-05 | US | Iowa | Greene | 19073 | 1887 | 23 | 0 | 42.03614551 | -94.39658081 | 2022-09-06 04:21:02 | Greene, Iowa, US | |
2988483 | 2988483 | 2022-09-04 | US | Iowa | Greene | 19073 | 1887 | 23 | 0 | 42.03614551 | -94.39658081 | 2022-09-05 04:21:01 | Greene, Iowa, US | |
2987801 | 2987801 | 2022-09-04 | US | Arkansas | Newton | 5101 | 1887 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-09-05 04:21:01 | Newton, Arkansas, US | |
2714168 | 2714168 | 2022-09-03 | US | Iowa | Greene | 19073 | 1887 | 23 | 0 | 42.03614551 | -94.39658081 | 2022-09-04 04:21:22 | Greene, Iowa, US | |
1394873 | 1394873 | 2022-09-02 | US | Iowa | Greene | 19073 | 1887 | 23 | 0 | 42.03614551 | -94.39658081 | 2022-09-03 04:21:04 | Greene, Iowa, US | |
3548702 | 3548702 | 2022-09-01 | US | Iowa | Greene | 19073 | 1887 | 23 | 0 | 42.03614551 | -94.39658081 | 2022-09-02 04:21:07 | Greene, Iowa, US | |
2344622 | 2344622 | 2022-08-31 | US | Iowa | Greene | 19073 | 1887 | 23 | 0 | 42.03614551 | -94.39658081 | 2022-09-01 04:21:03 | Greene, Iowa, US | |
1086558 | 1086558 | 2022-08-09 | US | Arkansas | Dallas | 5039 | 1887 | 33 | 0 | 33.97042763 | -92.65167437 | 2022-08-10 04:20:57 | Dallas, Arkansas, US | |
1071758 | 1071758 | 2022-08-07 | US | Mississippi | Wilkinson | 28157 | 1887 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-08-08 04:21:08 | Wilkinson, Mississippi, US | |
1942346 | 1942346 | 2022-08-06 | US | Mississippi | Wilkinson | 28157 | 1887 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-08-07 04:20:54 | Wilkinson, Mississippi, US | |
882145 | 882145 | 2022-08-05 | US | Mississippi | Wilkinson | 28157 | 1887 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-08-06 04:20:56 | Wilkinson, Mississippi, US | |
2010556 | 2010556 | 2022-08-04 | US | Mississippi | Wilkinson | 28157 | 1887 | 46 | 0 | 31.16078225 | -91.31018819 | 2022-08-05 04:20:52 | Wilkinson, Mississippi, US | |
632893 | 632893 | 2022-07-12 | US | Tennessee | Pickett | 47137 | 1887 | 36 | 0 | 36.55606529 | -85.077633 | 2022-07-13 04:20:58 | Pickett, Tennessee, US | |
1214760 | 1214760 | 2022-07-11 | US | Texas | Refugio | 48391 | 1887 | 37 | 0 | 28.3238976 | -97.15766311 | 2022-07-12 04:20:51 | Refugio, Texas, US | |
3081263 | 3081263 | 2022-07-04 | US | Texas | Rains | 48379 | 1887 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-07-05 04:20:45 | Rains, Texas, US | |
1770545 | 1770545 | 2022-07-03 | US | Texas | Rains | 48379 | 1887 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-07-04 04:20:54 | Rains, Texas, US | |
3368531 | 3368531 | 2022-07-02 | US | Texas | Rains | 48379 | 1887 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-07-03 04:20:59 | Rains, Texas, US | |
596860 | 596860 | 2022-07-01 | US | Texas | Rains | 48379 | 1887 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-07-02 04:21:16 | Rains, Texas, US | |
2150821 | 2150821 | 2022-06-27 | US | Texas | Mitchell | 48335 | 1887 | 49 | 0 | 32.30623474 | -100.9212058 | 2022-06-28 04:20:58 | Mitchell, Texas, US | |
478622 | 478622 | 2022-06-26 | US | Texas | Mitchell | 48335 | 1887 | 49 | 0 | 32.30623474 | -100.9212058 | 2022-06-27 04:21:00 | Mitchell, Texas, US | |
169049 | 169049 | 2022-06-21 | US | Tennessee | Van Buren | 47175 | 1887 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-06-22 04:20:54 | Van Buren, Tennessee, US | |
3891046 | 3891046 | 2022-06-06 | US | Virginia | Williamsburg | 51830 | 1887 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-06-07 04:21:08 | Williamsburg, Virginia, US | |
3510815 | 3510815 | 2022-06-05 | US | Virginia | Williamsburg | 51830 | 1887 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-06-06 04:20:57 | Williamsburg, Virginia, US | |
3530892 | 3530892 | 2022-06-04 | US | Virginia | Williamsburg | 51830 | 1887 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-06-05 04:20:55 | Williamsburg, Virginia, US | |
3136978 | 3136978 | 2022-06-03 | US | Virginia | Williamsburg | 51830 | 1887 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-06-04 04:20:58 | Williamsburg, Virginia, US | |
2087436 | 2087436 | 2022-05-15 | US | West Virginia | Calhoun | 54013 | 1887 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-16 04:20:47 | Calhoun, West Virginia, US | |
3358146 | 3358146 | 2022-05-14 | US | West Virginia | Calhoun | 54013 | 1887 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-15 04:20:53 | Calhoun, West Virginia, US | |
661791 | 661791 | 2022-05-13 | US | West Virginia | Calhoun | 54013 | 1887 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-14 04:20:48 | Calhoun, West Virginia, US | |
3419689 | 3419689 | 2022-04-17 | US | Puerto Rico | Patillas | 72109 | 1887 | 0 | 0 | 18.03174 | -66.012242 | 2022-04-18 04:21:12 | Patillas, Puerto Rico, US | |
1438904 | 1438904 | 2022-03-28 | US | North Carolina | Gates | 37073 | 1887 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-03-29 04:20:46 | Gates, North Carolina, US | |
1436432 | 1436432 | 2022-03-28 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-29 04:20:46 | Vaupes, Colombia | |||
878585 | 878585 | 2022-03-27 | US | North Carolina | Gates | 37073 | 1887 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-03-28 04:20:33 | Gates, North Carolina, US | |
876113 | 876113 | 2022-03-27 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-28 04:20:33 | Vaupes, Colombia | |||
2165868 | 2165868 | 2022-03-26 | US | North Carolina | Gates | 37073 | 1887 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-03-27 04:20:47 | Gates, North Carolina, US | |
2163396 | 2163396 | 2022-03-26 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-27 04:20:47 | Vaupes, Colombia | |||
1722804 | 1722804 | 2022-03-25 | US | North Carolina | Gates | 37073 | 1887 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-03-26 04:20:23 | Gates, North Carolina, US | |
1720332 | 1720332 | 2022-03-25 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-26 04:20:23 | Vaupes, Colombia | |||
1470421 | 1470421 | 2022-03-24 | US | North Carolina | Gates | 37073 | 1887 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-03-25 04:20:46 | Gates, North Carolina, US | |
1467949 | 1467949 | 2022-03-24 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-25 04:20:46 | Vaupes, Colombia | |||
3022123 | 3022123 | 2022-03-23 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-24 04:20:43 | Vaupes, Colombia | |||
1905045 | 1905045 | 2022-03-22 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-23 04:20:48 | Vaupes, Colombia | |||
3238176 | 3238176 | 2022-03-21 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-22 04:20:54 | Vaupes, Colombia | |||
24249 | 24249 | 2022-03-20 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-21 04:20:50 | Vaupes, Colombia | |||
1656259 | 1656259 | 2022-03-19 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-20 04:20:45 | Vaupes, Colombia | |||
335785 | 335785 | 2022-03-18 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-19 04:20:47 | Vaupes, Colombia | |||
694238 | 694238 | 2022-03-17 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-18 04:20:55 | Vaupes, Colombia | |||
2319181 | 2319181 | 2022-03-16 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-17 04:20:56 | Vaupes, Colombia | |||
261381 | 261381 | 2022-03-15 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-16 04:20:50 | Vaupes, Colombia | |||
2263740 | 2263740 | 2022-03-14 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-15 04:20:47 | Vaupes, Colombia | |||
3627806 | 3627806 | 2022-03-13 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-14 04:20:46 | Vaupes, Colombia | |||
950714 | 950714 | 2022-03-12 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-13 04:20:49 | Vaupes, Colombia | |||
356175 | 356175 | 2022-03-11 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-12 04:20:50 | Vaupes, Colombia | |||
1865327 | 1865327 | 2022-03-10 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-11 04:20:50 | Vaupes, Colombia | |||
2140022 | 2140022 | 2022-03-09 | Colombia | Vaupes | 1887 | 19 | 0 | 0.8554 | -70.812 | 2022-03-10 04:20:48 | Vaupes, Colombia | |||
1515023 | 1515023 | 2022-02-24 | US | Wyoming | Platte | 56031 | 1887 | 39 | 0 | 42.13299116 | -104.96633100000001 | 2022-02-25 04:21:11 | Platte, Wyoming, US | |
3718365 | 3718365 | 2022-02-21 | Peru | Unknown | 1887 | 173 | 0 | 2022-02-22 04:21:01 | Unknown, Peru | |||||
315731 | 315731 | 2022-02-12 | China | Yunnan | 1887 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-13 04:21:00 | Yunnan, China | |||
3076103 | 3076103 | 2022-02-09 | US | Nebraska | Cheyenne | 31033 | 1887 | 16 | 0 | 41.21999357 | -102.9941693 | 2022-02-10 04:21:14 | Cheyenne, Nebraska, US | |
3074709 | 3074709 | 2022-02-09 | US | Colorado | Yuma | 8125 | 1887 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-02-10 04:21:14 | Yuma, Colorado, US | |
1363016 | 1363016 | 2022-02-08 | US | Colorado | Yuma | 8125 | 1887 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-02-09 04:21:04 | Yuma, Colorado, US | |
2476373 | 2476373 | 2022-02-03 | US | North Dakota | Pembina | 38067 | 1887 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-02-04 04:21:10 | Pembina, North Dakota, US | |
2661312 | 2661312 | 2022-01-31 | US | West Virginia | Webster | 54101 | 1887 | 27 | 0 | 38.49370949 | -80.4202023 | 2022-02-01 04:21:11 | Webster, West Virginia, US | |
1321123 | 1321123 | 2022-01-26 | US | South Dakota | Turner | 46125 | 1887 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-01-27 04:21:19 | Turner, South Dakota, 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]);