johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
191 rows where confirmed = 4186 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952382 | 2952382 | 2022-12-20 | US | Illinois | Greene | 17061 | 4186 | 47 | 0 | 39.35907414 | -90.388865 | 2022-12-21 04:21:03 | Greene, Illinois, US | |
2817346 | 2817346 | 2022-12-03 | US | California | Plumas | 6063 | 4186 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-04 04:20:56 | Plumas, California, US | |
834202 | 834202 | 2022-12-02 | US | California | Plumas | 6063 | 4186 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-03 04:21:02 | Plumas, California, US | |
2136732 | 2136732 | 2022-12-01 | US | California | Plumas | 6063 | 4186 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-02 04:21:07 | Plumas, California, US | |
1965148 | 1965148 | 2022-11-30 | US | California | Plumas | 6063 | 4186 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-12-01 04:21:03 | Plumas, California, US | |
292427 | 292427 | 2022-11-15 | US | Alabama | Washington | 1129 | 4186 | 60 | 0 | 31.4092794 | -88.20689944 | 2022-11-16 04:21:09 | Washington, Alabama, US | |
3597457 | 3597457 | 2022-11-14 | US | Alabama | Washington | 1129 | 4186 | 60 | 0 | 31.4092794 | -88.20689944 | 2022-11-15 04:21:16 | Washington, Alabama, US | |
312539 | 312539 | 2022-11-13 | US | Colorado | Las Animas | 8071 | 4186 | 48 | 0 | 37.3153406 | -104.0376458 | 2022-11-14 04:21:09 | Las Animas, Colorado, US | |
312315 | 312315 | 2022-11-13 | US | Alabama | Washington | 1129 | 4186 | 60 | 0 | 31.4092794 | -88.20689944 | 2022-11-14 04:21:09 | Washington, Alabama, US | |
63700 | 63700 | 2022-11-12 | US | Colorado | Las Animas | 8071 | 4186 | 48 | 0 | 37.3153406 | -104.0376458 | 2022-11-13 04:21:14 | Las Animas, Colorado, US | |
63476 | 63476 | 2022-11-12 | US | Alabama | Washington | 1129 | 4186 | 60 | 0 | 31.4092794 | -88.20689944 | 2022-11-13 04:21:14 | Washington, Alabama, US | |
2927862 | 2927862 | 2022-11-11 | US | Colorado | Las Animas | 8071 | 4186 | 48 | 0 | 37.3153406 | -104.0376458 | 2022-11-12 04:20:41 | Las Animas, Colorado, US | |
2927638 | 2927638 | 2022-11-11 | US | Alabama | Washington | 1129 | 4186 | 60 | 0 | 31.4092794 | -88.20689944 | 2022-11-12 04:20:41 | Washington, Alabama, US | |
2506474 | 2506474 | 2022-11-10 | US | Alabama | Washington | 1129 | 4186 | 60 | 0 | 31.4092794 | -88.20689944 | 2022-11-11 04:21:22 | Washington, Alabama, US | |
1053254 | 1053254 | 2022-11-06 | US | Virginia | Southampton | 51175 | 4186 | 97 | 0 | 36.72231125 | -77.10642712 | 2022-11-07 04:21:26 | Southampton, Virginia, US | |
621278 | 621278 | 2022-11-05 | US | Virginia | Southampton | 51175 | 4186 | 97 | 0 | 36.72231125 | -77.10642712 | 2022-11-06 04:21:24 | Southampton, Virginia, US | |
1025782 | 1025782 | 2022-11-04 | US | Virginia | Southampton | 51175 | 4186 | 97 | 0 | 36.72231125 | -77.10642712 | 2022-11-05 04:21:52 | Southampton, Virginia, US | |
1024639 | 1024639 | 2022-11-04 | US | New York | Schuyler | 36097 | 4186 | 30 | 0 | 42.39184015 | -76.8773299 | 2022-11-05 04:21:52 | Schuyler, New York, US | |
434773 | 434773 | 2022-11-03 | US | Virginia | Southampton | 51175 | 4186 | 97 | 0 | 36.72231125 | -77.10642712 | 2022-11-04 04:22:11 | Southampton, Virginia, US | |
853117 | 853117 | 2022-11-02 | US | West Virginia | Roane | 54087 | 4186 | 44 | 0 | 38.71622686 | -81.35243568 | 2022-11-03 04:22:05 | Roane, West Virginia, US | |
3280432 | 3280432 | 2022-10-23 | US | Wisconsin | Lafayette | 55065 | 4186 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-10-24 04:22:29 | Lafayette, Wisconsin, US | |
2271470 | 2271470 | 2022-10-22 | US | Wisconsin | Lafayette | 55065 | 4186 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-10-23 04:22:46 | Lafayette, Wisconsin, US | |
1595770 | 1595770 | 2022-10-21 | US | Wisconsin | Lafayette | 55065 | 4186 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-10-22 04:22:53 | Lafayette, Wisconsin, US | |
2275486 | 2275486 | 2022-10-20 | US | Wisconsin | Lafayette | 55065 | 4186 | 29 | 0 | 42.66005229 | -90.1317729 | 2022-10-21 04:22:23 | Lafayette, Wisconsin, US | |
2771902 | 2771902 | 2022-09-26 | US | Tennessee | Decatur | 47039 | 4186 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-09-27 04:23:01 | Decatur, Tennessee, US | |
384007 | 384007 | 2022-09-23 | China | Beijing | 4186 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-24 04:21:40 | Beijing, China | |||
3768964 | 3768964 | 2022-09-11 | US | Texas | Falls | 48145 | 4186 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-12 04:20:58 | Falls, Texas, US | |
3827539 | 3827539 | 2022-09-10 | US | Texas | Falls | 48145 | 4186 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-11 04:20:50 | Falls, Texas, US | |
965996 | 965996 | 2022-09-09 | US | Texas | Falls | 48145 | 4186 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-10 04:21:10 | Falls, Texas, US | |
117500 | 117500 | 2022-09-06 | US | Puerto Rico | Hormigueros | 72067 | 4186 | 0 | 0 | 18.134532 | -67.113972 | 2022-09-07 04:20:59 | Hormigueros, Puerto Rico, US | |
2636472 | 2636472 | 2022-09-05 | US | Puerto Rico | Hormigueros | 72067 | 4186 | 0 | 0 | 18.134532 | -67.113972 | 2022-09-06 04:21:02 | Hormigueros, Puerto Rico, US | |
1349091 | 1349091 | 2022-08-10 | US | Puerto Rico | Patillas | 72109 | 4186 | 0 | 0 | 18.03174 | -66.012242 | 2022-08-11 04:20:49 | Patillas, Puerto Rico, US | |
1088809 | 1088809 | 2022-08-09 | US | Puerto Rico | Ciales | 72039 | 4186 | 0 | 0 | 18.28885 | -66.516475 | 2022-08-10 04:20:57 | Ciales, Puerto Rico, US | |
1099141 | 1099141 | 2022-08-03 | US | Illinois | Massac | 17127 | 4186 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-08-04 04:20:58 | Massac, Illinois, US | |
672922 | 672922 | 2022-07-21 | US | Oregon | Hood River | 41027 | 4186 | 45 | 0 | 45.51872811 | -121.6552036 | 2022-07-22 04:21:15 | Hood River, Oregon, US | |
3213228 | 3213228 | 2022-07-18 | US | Tennessee | Grundy | 47061 | 4186 | 75 | 0 | 35.38433717 | -85.72142731 | 2022-07-19 04:20:58 | Grundy, Tennessee, US | |
2792490 | 2792490 | 2022-07-10 | US | Washington | Pacific | 53049 | 4186 | 62 | 0 | 46.55418369 | -123.7285716 | 2022-07-11 04:20:46 | Pacific, Washington, US | |
145443 | 145443 | 2022-07-09 | US | Washington | Pacific | 53049 | 4186 | 62 | 0 | 46.55418369 | -123.7285716 | 2022-07-10 04:20:54 | Pacific, Washington, US | |
1420543 | 1420543 | 2022-07-08 | US | Washington | Pacific | 53049 | 4186 | 62 | 0 | 46.55418369 | -123.7285716 | 2022-07-09 04:20:59 | Pacific, Washington, US | |
1650273 | 1650273 | 2022-06-23 | US | Missouri | Cooper | 29053 | 4186 | 78 | 0 | 38.844478 | -92.80896081 | 2022-06-24 04:20:58 | Cooper, Missouri, US | |
2189508 | 2189508 | 2022-06-22 | US | Missouri | Cooper | 29053 | 4186 | 78 | 0 | 38.844478 | -92.80896081 | 2022-06-23 04:20:55 | Cooper, Missouri, US | |
167939 | 167939 | 2022-06-21 | US | Missouri | Cooper | 29053 | 4186 | 78 | 0 | 38.844478 | -92.80896081 | 2022-06-22 04:20:54 | Cooper, Missouri, US | |
1765222 | 1765222 | 2022-06-20 | US | Missouri | Cooper | 29053 | 4186 | 78 | 0 | 38.844478 | -92.80896081 | 2022-06-21 04:20:56 | Cooper, Missouri, US | |
1764359 | 1764359 | 2022-06-20 | US | Illinois | Moultrie | 17139 | 4186 | 44 | 0 | 39.64187451 | -88.62099969 | 2022-06-21 04:20:56 | Moultrie, Illinois, US | |
3271938 | 3271938 | 2022-06-19 | US | North Dakota | Richland | 38077 | 4186 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-06-20 04:21:01 | Richland, North Dakota, US | |
3271408 | 3271408 | 2022-06-19 | US | Missouri | Cooper | 29053 | 4186 | 78 | 0 | 38.844478 | -92.80896081 | 2022-06-20 04:21:01 | Cooper, Missouri, US | |
3270545 | 3270545 | 2022-06-19 | US | Illinois | Moultrie | 17139 | 4186 | 44 | 0 | 39.64187451 | -88.62099969 | 2022-06-20 04:21:01 | Moultrie, Illinois, US | |
3399850 | 3399850 | 2022-06-18 | US | North Dakota | Richland | 38077 | 4186 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-06-19 04:20:51 | Richland, North Dakota, US | |
3399320 | 3399320 | 2022-06-18 | US | Missouri | Cooper | 29053 | 4186 | 78 | 0 | 38.844478 | -92.80896081 | 2022-06-19 04:20:51 | Cooper, Missouri, US | |
3398457 | 3398457 | 2022-06-18 | US | Illinois | Moultrie | 17139 | 4186 | 44 | 0 | 39.64187451 | -88.62099969 | 2022-06-19 04:20:51 | Moultrie, Illinois, US | |
2313197 | 2313197 | 2022-06-17 | US | Missouri | Cooper | 29053 | 4186 | 78 | 0 | 38.844478 | -92.80896081 | 2022-06-18 04:21:10 | Cooper, Missouri, US | |
2312334 | 2312334 | 2022-06-17 | US | Illinois | Moultrie | 17139 | 4186 | 44 | 0 | 39.64187451 | -88.62099969 | 2022-06-18 04:21:10 | Moultrie, Illinois, US | |
2236533 | 2236533 | 2022-06-12 | US | Indiana | Vermillion | 18165 | 4186 | 76 | 0 | 39.8523352 | -87.46160542 | 2022-06-13 04:21:14 | Vermillion, Indiana, US | |
3142731 | 3142731 | 2022-06-11 | US | Indiana | Vermillion | 18165 | 4186 | 76 | 0 | 39.8523352 | -87.46160542 | 2022-06-12 04:20:53 | Vermillion, Indiana, US | |
1945647 | 1945647 | 2022-06-10 | US | Indiana | Vermillion | 18165 | 4186 | 76 | 0 | 39.8523352 | -87.46160542 | 2022-06-11 04:21:01 | Vermillion, Indiana, US | |
973486 | 973486 | 2022-06-01 | US | Oklahoma | Kingfisher | 40073 | 4186 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-06-02 05:20:39 | Kingfisher, Oklahoma, US | |
231793 | 231793 | 2022-05-31 | US | Oklahoma | Kingfisher | 40073 | 4186 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-06-01 04:20:55 | Kingfisher, Oklahoma, US | |
3188558 | 3188558 | 2022-05-30 | US | Oklahoma | Kingfisher | 40073 | 4186 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-05-31 04:20:51 | Kingfisher, Oklahoma, US | |
3200707 | 3200707 | 2022-05-29 | US | Oklahoma | Kingfisher | 40073 | 4186 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-05-30 04:20:50 | Kingfisher, Oklahoma, US | |
2727585 | 2727585 | 2022-05-28 | US | Oklahoma | Kingfisher | 40073 | 4186 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-05-29 04:20:53 | Kingfisher, Oklahoma, US | |
1316766 | 1316766 | 2022-05-27 | US | Oklahoma | Kingfisher | 40073 | 4186 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-05-28 04:21:07 | Kingfisher, Oklahoma, US | |
1852558 | 1852558 | 2022-05-26 | US | Oklahoma | Kingfisher | 40073 | 4186 | 71 | 0 | 35.94530008 | -97.94193268 | 2022-05-27 04:20:56 | Kingfisher, Oklahoma, US | |
1187761 | 1187761 | 2022-05-18 | US | Texas | Aransas | 48007 | 4186 | 86 | 0 | 28.10556197 | -96.9995047 | 2022-05-19 04:20:54 | Aransas, Texas, US | |
1723637 | 1723637 | 2022-03-25 | US | Texas | Lavaca | 48285 | 4186 | 118 | 0 | 29.38508402 | -96.93186692 | 2022-03-26 04:20:23 | Lavaca, Texas, US | |
1471254 | 1471254 | 2022-03-24 | US | Texas | Lavaca | 48285 | 4186 | 118 | 0 | 29.38508402 | -96.93186692 | 2022-03-25 04:20:46 | Lavaca, Texas, US | |
3629734 | 3629734 | 2022-03-13 | US | Minnesota | Wadena | 27159 | 4186 | 52 | 0 | 46.58589171 | -94.96968506 | 2022-03-14 04:20:46 | Wadena, Minnesota, US | |
952642 | 952642 | 2022-03-12 | US | Minnesota | Wadena | 27159 | 4186 | 52 | 0 | 46.58589171 | -94.96968506 | 2022-03-13 04:20:49 | Wadena, Minnesota, US | |
358103 | 358103 | 2022-03-11 | US | Minnesota | Wadena | 27159 | 4186 | 52 | 0 | 46.58589171 | -94.96968506 | 2022-03-12 04:20:50 | Wadena, Minnesota, US | |
2736562 | 2736562 | 2022-02-27 | US | Wisconsin | Crawford | 55023 | 4186 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-02-28 04:21:05 | Crawford, Wisconsin, US | |
2735316 | 2735316 | 2022-02-27 | US | North Carolina | Bertie | 37015 | 4186 | 65 | 0 | 36.0688473 | -76.96545943 | 2022-02-28 04:21:05 | Bertie, North Carolina, US | |
2733993 | 2733993 | 2022-02-27 | US | Illinois | Carroll | 17015 | 4186 | 46 | 0 | 42.06823429 | -89.93395545 | 2022-02-28 04:21:05 | Carroll, Illinois, US | |
3049715 | 3049715 | 2022-02-26 | US | Wisconsin | Crawford | 55023 | 4186 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-02-27 04:21:04 | Crawford, Wisconsin, US | |
3048469 | 3048469 | 2022-02-26 | US | North Carolina | Bertie | 37015 | 4186 | 65 | 0 | 36.0688473 | -76.96545943 | 2022-02-27 04:21:04 | Bertie, North Carolina, US | |
3047146 | 3047146 | 2022-02-26 | US | Illinois | Carroll | 17015 | 4186 | 46 | 0 | 42.06823429 | -89.93395545 | 2022-02-27 04:21:04 | Carroll, Illinois, US | |
578370 | 578370 | 2022-02-25 | US | Wisconsin | Crawford | 55023 | 4186 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-02-26 04:21:12 | Crawford, Wisconsin, US | |
577124 | 577124 | 2022-02-25 | US | North Carolina | Bertie | 37015 | 4186 | 65 | 0 | 36.0688473 | -76.96545943 | 2022-02-26 04:21:12 | Bertie, North Carolina, US | |
575801 | 575801 | 2022-02-25 | US | Illinois | Carroll | 17015 | 4186 | 46 | 0 | 42.06823429 | -89.93395545 | 2022-02-26 04:21:12 | Carroll, Illinois, US | |
1060841 | 1060841 | 2022-02-23 | US | Tennessee | Sequatchie | 47153 | 4186 | 65 | 0 | 35.36979721 | -85.41022136 | 2022-02-24 04:21:14 | Sequatchie, Tennessee, US | |
3858988 | 3858988 | 2022-02-18 | US | Texas | Lee | 48287 | 4186 | 58 | 0 | 30.31120597 | -96.97045773 | 2022-02-19 04:21:11 | Lee, Texas, US | |
2474990 | 2474990 | 2022-02-03 | US | Illinois | Piatt | 17147 | 4186 | 21 | 0 | 40.01360584 | -88.59319339 | 2022-02-04 04:21:10 | Piatt, Illinois, US | |
460415 | 460415 | 2022-02-02 | US | Illinois | Piatt | 17147 | 4186 | 21 | 0 | 40.01360584 | -88.59319339 | 2022-02-03 04:21:21 | Piatt, Illinois, US | |
1231140 | 1231140 | 2022-01-24 | US | Wisconsin | Adams | 55001 | 4186 | 46 | 0 | 43.96974651 | -89.76782777 | 2022-01-25 04:21:05 | Adams, Wisconsin, US | |
1142727 | 1142727 | 2022-01-23 | US | Mississippi | Jasper | 28061 | 4186 | 66 | 0 | 32.01922104 | -89.11786866 | 2022-01-24 04:21:12 | Jasper, Mississippi, US | |
2834645 | 2834645 | 2022-01-22 | US | Mississippi | Jasper | 28061 | 4186 | 66 | 0 | 32.01922104 | -89.11786866 | 2022-01-23 04:21:13 | Jasper, Mississippi, US | |
3426763 | 3426763 | 2022-01-21 | US | Mississippi | Jasper | 28061 | 4186 | 66 | 0 | 32.01922104 | -89.11786866 | 2022-01-22 04:21:13 | Jasper, Mississippi, US | |
1389664 | 1389664 | 2022-01-07 | Japan | Kochi | 4186 | 33 | 0 | 33.422519 | 133.367307 | 2022-01-08 04:21:53 | Kochi, Japan | |||
2613471 | 2613471 | 2022-01-06 | US | Virginia | Waynesboro | 51820 | 4186 | 54 | 0 | 38.06451466 | -78.90293905 | 2022-01-07 04:22:09 | Waynesboro, Virginia, US | |
1259429 | 1259429 | 2021-12-18 | US | Colorado | Montezuma | 8083 | 4186 | 57 | 0 | 37.33859579 | -108.59588570000001 | 2021-12-19 04:21:11 | Montezuma, Colorado, US | |
2398493 | 2398493 | 2021-12-17 | Antigua and Barbuda | 4186 | 117 | 0 | 17.0608 | -61.7964 | 2021-12-18 02:22:20 | Antigua and Barbuda | ||||
1033382 | 1033382 | 2021-12-06 | US | Tennessee | Wayne | 47181 | 4186 | 41 | 0 | 35.23868267 | -87.78644456 | 2021-12-07 04:22:34 | Wayne, Tennessee, US | |
1032565 | 1032565 | 2021-12-06 | US | New Mexico | Cibola | 35006 | 4186 | 150 | 0 | 34.91131525 | -107.998876 | 2021-12-07 04:22:34 | Cibola, New Mexico, US | |
1742518 | 1742518 | 2021-12-05 | US | Missouri | Washington | 29221 | 4186 | 97 | 0 | 37.96130078 | -90.87948158 | 2021-12-06 04:22:34 | Washington, Missouri, US | |
1146901 | 1146901 | 2021-12-01 | US | Missouri | Stone | 29209 | 4186 | 89 | 0 | 36.75000327 | -93.45256475 | 2021-12-02 04:22:37 | Stone, Missouri, US | |
3402642 | 3402642 | 2021-11-30 | US | Iowa | Henry | 19087 | 4186 | 55 | 0 | 40.98767962 | -91.54436349 | 2021-12-01 04:22:29 | Henry, Iowa, US | |
151185 | 151185 | 2021-11-29 | US | Iowa | Henry | 19087 | 4186 | 55 | 0 | 40.98767962 | -91.54436349 | 2021-11-30 04:22:53 | Henry, Iowa, US | |
1232831 | 1232831 | 2021-11-28 | US | Iowa | Henry | 19087 | 4186 | 55 | 0 | 40.98767962 | -91.54436349 | 2021-11-29 04:22:30 | Henry, Iowa, US | |
1359538 | 1359538 | 2021-11-27 | US | Iowa | Henry | 19087 | 4186 | 55 | 0 | 40.98767962 | -91.54436349 | 2021-11-28 04:22:43 | Henry, Iowa, US | |
759529 | 759529 | 2021-11-26 | US | Iowa | Henry | 19087 | 4186 | 55 | 0 | 40.98767962 | -91.54436349 | 2021-11-27 04:22:45 | Henry, Iowa, US | |
1803946 | 1803946 | 2021-11-25 | US | Iowa | Henry | 19087 | 4186 | 55 | 0 | 40.98767962 | -91.54436349 | 2021-11-26 04:22:33 | Henry, Iowa, US | |
905380 | 905380 | 2021-11-24 | US | Iowa | Henry | 19087 | 4186 | 55 | 0 | 40.98767962 | -91.54436349 | 2021-11-25 04:22:33 | Henry, Iowa, 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]);