johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
202 rows where confirmed = 3863 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219883 | 219883 | 2022-12-26 | US | Missouri | Dent | 29065 | 3863 | 89 | 0 | 37.60663134 | -91.50790473 | 2022-12-27 04:21:07 | Dent, Missouri, US | |
3224340 | 3224340 | 2022-12-25 | US | Missouri | Dent | 29065 | 3863 | 89 | 0 | 37.60663134 | -91.50790473 | 2022-12-26 04:21:06 | Dent, Missouri, US | |
1020254 | 1020254 | 2022-12-24 | US | Missouri | Dent | 29065 | 3863 | 89 | 0 | 37.60663134 | -91.50790473 | 2022-12-25 04:21:04 | Dent, Missouri, US | |
692277 | 692277 | 2022-12-23 | US | Missouri | Dent | 29065 | 3863 | 89 | 0 | 37.60663134 | -91.50790473 | 2022-12-24 04:21:02 | Dent, Missouri, US | |
2181487 | 2181487 | 2022-12-22 | US | Missouri | Dent | 29065 | 3863 | 89 | 0 | 37.60663134 | -91.50790473 | 2022-12-23 04:21:04 | Dent, Missouri, US | |
453291 | 453291 | 2022-12-21 | US | Missouri | Dent | 29065 | 3863 | 89 | 0 | 37.60663134 | -91.50790473 | 2022-12-22 04:20:56 | Dent, Missouri, US | |
2953290 | 2953290 | 2022-12-20 | US | Missouri | Dent | 29065 | 3863 | 89 | 0 | 37.60663134 | -91.50790473 | 2022-12-21 04:21:03 | Dent, Missouri, US | |
3177103 | 3177103 | 2022-12-19 | US | Virginia | Brunswick | 51025 | 3863 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-12-20 04:21:04 | Brunswick, Virginia, US | |
1621256 | 1621256 | 2022-11-22 | US | Illinois | Cumberland | 17035 | 3863 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-11-23 04:21:06 | Cumberland, Illinois, US | |
3100871 | 3100871 | 2022-10-09 | US | Virginia | Westmoreland | 51193 | 3863 | 57 | 0 | 38.11021557 | -76.80213247 | 2022-10-10 04:22:32 | Westmoreland, Virginia, US | |
4006096 | 4006096 | 2022-10-08 | US | Virginia | Westmoreland | 51193 | 3863 | 57 | 0 | 38.11021557 | -76.80213247 | 2022-10-09 04:21:16 | Westmoreland, Virginia, US | |
399693 | 399693 | 2022-10-07 | US | Virginia | Westmoreland | 51193 | 3863 | 57 | 0 | 38.11021557 | -76.80213247 | 2022-10-08 04:22:56 | Westmoreland, Virginia, US | |
1813215 | 1813215 | 2022-10-05 | US | North Dakota | Walsh | 38099 | 3863 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-10-06 04:21:22 | Walsh, North Dakota, US | |
3995697 | 3995697 | 2022-09-27 | US | Illinois | Washington | 17189 | 3863 | 36 | 0 | 38.35309213 | -89.40982703 | 2022-09-28 04:23:01 | Washington, Illinois, US | |
2770025 | 2770025 | 2022-09-26 | US | Illinois | Washington | 17189 | 3863 | 36 | 0 | 38.35309213 | -89.40982703 | 2022-09-27 04:23:01 | Washington, Illinois, US | |
118333 | 118333 | 2022-09-06 | US | Wisconsin | Rusk | 55107 | 3863 | 59 | 0 | 45.47498854 | -91.1333012 | 2022-09-07 04:20:59 | Rusk, Wisconsin, US | |
3550565 | 3550565 | 2022-09-01 | US | Texas | Comanche | 48093 | 3863 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-09-02 04:21:07 | Comanche, Texas, US | |
1164543 | 1164543 | 2022-08-18 | US | Virginia | Martinsville | 51690 | 3863 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-08-19 04:20:54 | Martinsville, Virginia, US | |
1969124 | 1969124 | 2022-08-13 | US | Arkansas | Van Buren | 5141 | 3863 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-08-14 04:20:55 | Van Buren, Arkansas, US | |
1214286 | 1214286 | 2022-07-11 | US | Puerto Rico | Ciales | 72039 | 3863 | 0 | 0 | 18.28885 | -66.516475 | 2022-07-12 04:20:51 | Ciales, Puerto Rico, US | |
1213837 | 1213837 | 2022-07-11 | US | New York | Yates | 36123 | 3863 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-07-12 04:20:51 | Yates, New York, US | |
2791319 | 2791319 | 2022-07-10 | US | New York | Yates | 36123 | 3863 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-07-11 04:20:46 | Yates, New York, US | |
144272 | 144272 | 2022-07-09 | US | New York | Yates | 36123 | 3863 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-07-10 04:20:54 | Yates, New York, US | |
2744178 | 2744178 | 2022-07-07 | US | Texas | Madison | 48313 | 3863 | 56 | 0 | 30.96694679 | -95.93003775 | 2022-07-08 04:20:56 | Madison, Texas, US | |
1202973 | 1202973 | 2022-07-06 | US | Texas | Madison | 48313 | 3863 | 56 | 0 | 30.96694679 | -95.93003775 | 2022-07-07 04:20:55 | Madison, Texas, US | |
1767726 | 1767726 | 2022-07-03 | US | Alabama | Lamar | 1075 | 3863 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-07-04 04:20:54 | Lamar, Alabama, US | |
3365712 | 3365712 | 2022-07-02 | US | Alabama | Lamar | 1075 | 3863 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-07-03 04:20:59 | Lamar, Alabama, US | |
594041 | 594041 | 2022-07-01 | US | Alabama | Lamar | 1075 | 3863 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-07-02 04:21:16 | Lamar, Alabama, US | |
167700 | 167700 | 2022-06-21 | US | Michigan | Leelanau | 26089 | 3863 | 58 | 0 | 44.94430054 | -85.80150326 | 2022-06-22 04:20:54 | Leelanau, Michigan, US | |
1764983 | 1764983 | 2022-06-20 | US | Michigan | Leelanau | 26089 | 3863 | 58 | 0 | 44.94430054 | -85.80150326 | 2022-06-21 04:20:56 | Leelanau, Michigan, US | |
3271169 | 3271169 | 2022-06-19 | US | Michigan | Leelanau | 26089 | 3863 | 58 | 0 | 44.94430054 | -85.80150326 | 2022-06-20 04:21:01 | Leelanau, Michigan, US | |
3399081 | 3399081 | 2022-06-18 | US | Michigan | Leelanau | 26089 | 3863 | 58 | 0 | 44.94430054 | -85.80150326 | 2022-06-19 04:20:51 | Leelanau, Michigan, US | |
2312958 | 2312958 | 2022-06-17 | US | Michigan | Leelanau | 26089 | 3863 | 58 | 0 | 44.94430054 | -85.80150326 | 2022-06-18 04:21:10 | Leelanau, Michigan, US | |
560462 | 560462 | 2022-06-16 | US | Michigan | Leelanau | 26089 | 3863 | 58 | 0 | 44.94430054 | -85.80150326 | 2022-06-17 04:20:56 | Leelanau, Michigan, US | |
559293 | 559293 | 2022-06-16 | US | Arkansas | Franklin | 5047 | 3863 | 73 | 0 | 35.51202821 | -93.89299569 | 2022-06-17 04:20:56 | Franklin, Arkansas, US | |
3984264 | 3984264 | 2022-06-15 | US | Michigan | Leelanau | 26089 | 3863 | 58 | 0 | 44.94430054 | -85.80150326 | 2022-06-16 04:20:55 | Leelanau, Michigan, US | |
3160999 | 3160999 | 2022-06-09 | US | Virginia | King William | 51101 | 3863 | 44 | 0 | 37.70965316 | -77.09384941 | 2022-06-10 04:20:55 | King William, Virginia, US | |
3580611 | 3580611 | 2022-06-02 | US | Missouri | Wright | 29229 | 3863 | 85 | 0 | 37.27029221 | -92.46914488 | 2022-06-03 04:20:58 | Wright, Missouri, US | |
972904 | 972904 | 2022-06-01 | US | Missouri | Wright | 29229 | 3863 | 85 | 0 | 37.27029221 | -92.46914488 | 2022-06-02 05:20:39 | Wright, Missouri, US | |
231211 | 231211 | 2022-05-31 | US | Missouri | Wright | 29229 | 3863 | 85 | 0 | 37.27029221 | -92.46914488 | 2022-06-01 04:20:55 | Wright, Missouri, US | |
3187976 | 3187976 | 2022-05-30 | US | Missouri | Wright | 29229 | 3863 | 85 | 0 | 37.27029221 | -92.46914488 | 2022-05-31 04:20:51 | Wright, Missouri, US | |
3200125 | 3200125 | 2022-05-29 | US | Missouri | Wright | 29229 | 3863 | 85 | 0 | 37.27029221 | -92.46914488 | 2022-05-30 04:20:50 | Wright, Missouri, US | |
2727003 | 2727003 | 2022-05-28 | US | Missouri | Wright | 29229 | 3863 | 85 | 0 | 37.27029221 | -92.46914488 | 2022-05-29 04:20:53 | Wright, Missouri, US | |
1316184 | 1316184 | 2022-05-27 | US | Missouri | Wright | 29229 | 3863 | 85 | 0 | 37.27029221 | -92.46914488 | 2022-05-28 04:21:07 | Wright, Missouri, US | |
3002064 | 3002064 | 2022-05-24 | US | Puerto Rico | Loiza | 72087 | 3863 | 0 | 0 | 18.425688 | -65.89943 | 2022-05-25 04:20:56 | Loiza, Puerto Rico, US | |
3448408 | 3448408 | 2022-05-11 | US | Wisconsin | Marquette | 55077 | 3863 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-05-12 04:20:54 | Marquette, Wisconsin, US | |
3420498 | 3420498 | 2022-04-17 | US | Wisconsin | Richland | 55103 | 3863 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-04-18 04:21:12 | Richland, Wisconsin, US | |
3417307 | 3417307 | 2022-04-17 | US | Alabama | Macon | 1087 | 3863 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-18 04:21:12 | Macon, Alabama, US | |
307447 | 307447 | 2022-04-16 | US | Wisconsin | Richland | 55103 | 3863 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-04-17 04:20:59 | Richland, Wisconsin, US | |
304256 | 304256 | 2022-04-16 | US | Alabama | Macon | 1087 | 3863 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-17 04:20:59 | Macon, Alabama, US | |
2673392 | 2673392 | 2022-04-15 | US | Wisconsin | Richland | 55103 | 3863 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-04-16 04:20:48 | Richland, Wisconsin, US | |
2670201 | 2670201 | 2022-04-15 | US | Alabama | Macon | 1087 | 3863 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-16 04:20:48 | Macon, Alabama, US | |
1223986 | 1223986 | 2022-04-14 | US | Alabama | Macon | 1087 | 3863 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-15 04:20:57 | Macon, Alabama, US | |
2443144 | 2443144 | 2022-04-13 | US | Alabama | Macon | 1087 | 3863 | 83 | 0 | 32.38759944 | -85.69267724 | 2022-04-13 23:21:06 | Macon, Alabama, US | |
1948901 | 1948901 | 2022-04-12 | US | Alabama | Macon | 1087 | 3863 | 83 | 0 | 32.38759944 | -85.69267724 | 2022-04-13 04:21:03 | Macon, Alabama, US | |
3206654 | 3206654 | 2022-04-11 | US | Alabama | Macon | 1087 | 3863 | 83 | 0 | 32.38759944 | -85.69267724 | 2022-04-12 04:20:49 | Macon, Alabama, US | |
1579244 | 1579244 | 2022-04-10 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-11 04:21:02 | Freestone, Texas, US | |
1576540 | 1576540 | 2022-04-10 | US | Alabama | Macon | 1087 | 3863 | 83 | 0 | 32.38759944 | -85.69267724 | 2022-04-11 04:21:02 | Macon, Alabama, US | |
1655486 | 1655486 | 2022-04-09 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-10 04:20:52 | Freestone, Texas, US | |
1652782 | 1652782 | 2022-04-09 | US | Alabama | Macon | 1087 | 3863 | 83 | 0 | 32.38759944 | -85.69267724 | 2022-04-10 04:20:52 | Macon, Alabama, US | |
2118808 | 2118808 | 2022-04-08 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-09 04:20:42 | Freestone, Texas, US | |
2116104 | 2116104 | 2022-04-08 | US | Alabama | Macon | 1087 | 3863 | 83 | 0 | 32.38759944 | -85.69267724 | 2022-04-09 04:20:42 | Macon, Alabama, US | |
3323332 | 3323332 | 2022-04-07 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-08 04:20:48 | Freestone, Texas, US | |
3320628 | 3320628 | 2022-04-07 | US | Alabama | Macon | 1087 | 3863 | 83 | 0 | 32.38759944 | -85.69267724 | 2022-04-08 04:20:48 | Macon, Alabama, US | |
2803868 | 2803868 | 2022-04-06 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-07 04:20:53 | Freestone, Texas, US | |
3870637 | 3870637 | 2022-04-05 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-06 04:20:49 | Freestone, Texas, US | |
2751979 | 2751979 | 2022-04-04 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-05 04:20:48 | Freestone, Texas, US | |
3733325 | 3733325 | 2022-04-03 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-04 04:20:51 | Freestone, Texas, US | |
502760 | 502760 | 2022-04-02 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-03 04:20:48 | Freestone, Texas, US | |
3353745 | 3353745 | 2022-04-01 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-02 04:20:47 | Freestone, Texas, US | |
1543050 | 1543050 | 2022-03-31 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-04-01 04:20:28 | Freestone, Texas, US | |
2481063 | 2481063 | 2022-03-30 | US | Texas | Freestone | 48161 | 3863 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-03-31 04:20:56 | Freestone, Texas, US | |
2478993 | 2478993 | 2022-03-30 | US | Illinois | Massac | 17127 | 3863 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-31 04:20:56 | Massac, Illinois, US | |
2322806 | 2322806 | 2022-03-16 | US | West Virginia | Braxton | 54007 | 3863 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-03-17 04:20:56 | Braxton, West Virginia, US | |
2322493 | 2322493 | 2022-03-16 | US | Texas | Llano | 48299 | 3863 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-17 04:20:56 | Llano, Texas, US | |
265006 | 265006 | 2022-03-15 | US | West Virginia | Braxton | 54007 | 3863 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-03-16 04:20:50 | Braxton, West Virginia, US | |
1866231 | 1866231 | 2022-03-10 | US | Georgia | Banks | 13011 | 3863 | 84 | 0 | 34.35607081 | -83.49644388 | 2022-03-11 04:20:50 | Banks, Georgia, US | |
2734045 | 2734045 | 2022-02-27 | US | Illinois | Mason | 17125 | 3863 | 59 | 0 | 40.23917274 | -89.91824452 | 2022-02-28 04:21:05 | Mason, Illinois, US | |
3047198 | 3047198 | 2022-02-26 | US | Illinois | Mason | 17125 | 3863 | 59 | 0 | 40.23917274 | -89.91824452 | 2022-02-27 04:21:04 | Mason, Illinois, US | |
575853 | 575853 | 2022-02-25 | US | Illinois | Mason | 17125 | 3863 | 59 | 0 | 40.23917274 | -89.91824452 | 2022-02-26 04:21:12 | Mason, Illinois, US | |
3675001 | 3675001 | 2022-02-15 | US | Virginia | Greene | 51079 | 3863 | 56 | 0 | 38.29545894 | -78.46525378 | 2022-02-16 04:21:10 | Greene, Virginia, US | |
189351 | 189351 | 2022-02-13 | US | Vermont | Addison | 50001 | 3863 | 13 | 0 | 44.03217337 | -73.14130877 | 2022-02-14 04:20:51 | Addison, Vermont, US | |
189194 | 189194 | 2022-02-13 | US | Texas | Houston | 48225 | 3863 | 100 | 0 | 31.31925973 | -95.42226208 | 2022-02-14 04:20:51 | Houston, Texas, US | |
319197 | 319197 | 2022-02-12 | US | Vermont | Addison | 50001 | 3863 | 13 | 0 | 44.03217337 | -73.14130877 | 2022-02-13 04:21:00 | Addison, Vermont, US | |
236523 | 236523 | 2022-02-11 | US | Vermont | Addison | 50001 | 3863 | 13 | 0 | 44.03217337 | -73.14130877 | 2022-02-12 04:21:06 | Addison, Vermont, US | |
3076063 | 3076063 | 2022-02-09 | US | Montana | Park | 30067 | 3863 | 33 | 0 | 45.48965095 | -110.52643940000002 | 2022-02-10 04:21:14 | Park, Montana, US | |
72117 | 72117 | 2022-02-07 | US | Illinois | Mercer | 17131 | 3863 | 42 | 0 | 41.20596782 | -90.74290052 | 2022-02-08 04:21:15 | Mercer, Illinois, US | |
1320164 | 1320164 | 2022-01-26 | US | Missouri | Pike | 29163 | 3863 | 56 | 0 | 39.34310674 | -91.16980779 | 2022-01-27 04:21:19 | Pike, Missouri, US | |
3425437 | 3425437 | 2022-01-21 | US | Arkansas | Grant | 5053 | 3863 | 52 | 0 | 34.29017991 | -92.42320562 | 2022-01-22 04:21:13 | Grant, Arkansas, US | |
1695469 | 1695469 | 2022-01-10 | US | Texas | Lamb | 48279 | 3863 | 99 | 0 | 34.06859623 | -102.35162890000001 | 2022-01-11 04:22:01 | Lamb, Texas, US | |
1703936 | 1703936 | 2022-01-03 | US | Wisconsin | Taylor | 55119 | 3863 | 61 | 0 | 45.21179252 | -90.5004405 | 2022-01-04 04:22:17 | Taylor, Wisconsin, US | |
3522518 | 3522518 | 2022-01-02 | US | Texas | Fayette | 48149 | 3863 | 95 | 0 | 29.87788372 | -96.92076062 | 2022-01-03 02:22:25 | Fayette, Texas, US | |
1261807 | 1261807 | 2021-12-18 | US | Texas | Austin | 48015 | 3863 | 57 | 0 | 29.88548725 | -96.27736949 | 2021-12-19 04:21:11 | Austin, Texas, US | |
1743635 | 1743635 | 2021-12-05 | US | Texas | Gillespie | 48171 | 3863 | 82 | 0 | 30.31824095 | -98.94676915 | 2021-12-06 04:22:34 | Gillespie, Texas, US | |
1325323 | 1325323 | 2021-11-14 | US | Texas | Frio | 48163 | 3863 | 75 | 0 | 28.86751206 | -99.10804207 | 2021-11-15 04:21:36 | Frio, Texas, US | |
689449 | 689449 | 2021-11-13 | US | Texas | Frio | 48163 | 3863 | 75 | 0 | 28.86751206 | -99.10804207 | 2021-11-14 04:21:31 | Frio, Texas, US | |
717558 | 717558 | 2021-11-12 | US | Texas | Frio | 48163 | 3863 | 74 | 0 | 28.86751206 | -99.10804207 | 2021-11-13 04:21:38 | Frio, Texas, US | |
2845963 | 2845963 | 2021-11-10 | US | Indiana | LaGrange | 18087 | 3863 | 87 | 0 | 41.64232188 | -85.42674232 | 2021-11-11 04:21:45 | LaGrange, Indiana, US | |
89314 | 89314 | 2021-11-09 | US | New Mexico | Cibola | 35006 | 3863 | 145 | 0 | 34.91131525 | -107.998876 | 2021-11-10 04:21:38 | Cibola, New Mexico, US | |
3642959 | 3642959 | 2021-11-08 | US | Virginia | Russell | 51167 | 3863 | 65 | 0 | 36.93028320000001 | -82.10095486 | 2021-11-09 04:21:36 | Russell, Virginia, 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]);