johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
180 rows where confirmed = 3976 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453827 | 453827 | 2022-12-21 | US | North Dakota | Walsh | 38099 | 3976 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-22 04:20:56 | Walsh, North Dakota, US | |
295272 | 295272 | 2022-11-15 | US | Texas | Wilbarger | 48487 | 3976 | 90 | 0 | 34.07945812 | -99.24178437 | 2022-11-16 04:21:09 | Wilbarger, Texas, US | |
3600302 | 3600302 | 2022-11-14 | US | Texas | Wilbarger | 48487 | 3976 | 90 | 0 | 34.07945812 | -99.24178437 | 2022-11-15 04:21:16 | Wilbarger, Texas, US | |
1833685 | 1833685 | 2022-10-25 | US | Wisconsin | Ashland | 55003 | 3976 | 42 | 0 | 46.31956891 | -90.67837132 | 2022-10-26 04:22:19 | Ashland, Wisconsin, US | |
3757058 | 3757058 | 2022-10-13 | US | Wisconsin | Rusk | 55107 | 3976 | 61 | 0 | 45.47498854 | -91.1333012 | 2022-10-14 04:22:28 | Rusk, Wisconsin, US | |
3098888 | 3098888 | 2022-10-09 | US | Kentucky | Martin | 21159 | 3976 | 50 | 0 | 37.79990579 | -82.51247478 | 2022-10-10 04:22:32 | Martin, Kentucky, US | |
4004113 | 4004113 | 2022-10-08 | US | Kentucky | Martin | 21159 | 3976 | 50 | 0 | 37.79990579 | -82.51247478 | 2022-10-09 04:21:16 | Martin, Kentucky, US | |
397710 | 397710 | 2022-10-07 | US | Kentucky | Martin | 21159 | 3976 | 50 | 0 | 37.79990579 | -82.51247478 | 2022-10-08 04:22:56 | Martin, Kentucky, US | |
2530827 | 2530827 | 2022-10-06 | US | Kentucky | Martin | 21159 | 3976 | 50 | 0 | 37.79990579 | -82.51247478 | 2022-10-07 04:23:08 | Martin, Kentucky, US | |
1812221 | 1812221 | 2022-10-05 | US | Kentucky | Martin | 21159 | 3976 | 50 | 0 | 37.79990579 | -82.51247478 | 2022-10-06 04:21:22 | Martin, Kentucky, US | |
132195 | 132195 | 2022-10-04 | US | Kentucky | Martin | 21159 | 3976 | 50 | 0 | 37.79990579 | -82.51247478 | 2022-10-05 04:23:06 | Martin, Kentucky, US | |
2687142 | 2687142 | 2022-10-03 | US | Kentucky | Martin | 21159 | 3976 | 50 | 0 | 37.79990579 | -82.51247478 | 2022-10-04 04:22:55 | Martin, Kentucky, US | |
2263299 | 2263299 | 2022-10-02 | US | Wisconsin | Buffalo | 55011 | 3976 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-10-03 04:23:11 | Buffalo, Wisconsin, US | |
2998825 | 2998825 | 2022-10-01 | US | Wisconsin | Buffalo | 55011 | 3976 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-10-02 04:21:23 | Buffalo, Wisconsin, US | |
857151 | 857151 | 2022-09-30 | US | Wisconsin | Buffalo | 55011 | 3976 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-10-01 04:23:01 | Buffalo, Wisconsin, US | |
3995578 | 3995578 | 2022-09-27 | US | Idaho | Gem | 16045 | 3976 | 82 | 0 | 44.06482372 | -116.398376 | 2022-09-28 04:23:01 | Gem, Idaho, US | |
2769906 | 2769906 | 2022-09-26 | US | Idaho | Gem | 16045 | 3976 | 82 | 0 | 44.06482372 | -116.398376 | 2022-09-27 04:23:01 | Gem, Idaho, US | |
1977559 | 1977559 | 2022-09-25 | US | Idaho | Gem | 16045 | 3976 | 82 | 0 | 44.06482372 | -116.398376 | 2022-09-26 04:20:52 | Gem, Idaho, US | |
2650726 | 2650726 | 2022-09-24 | US | Idaho | Gem | 16045 | 3976 | 82 | 0 | 44.06482372 | -116.398376 | 2022-09-25 04:23:31 | Gem, Idaho, US | |
385166 | 385166 | 2022-09-23 | US | Idaho | Gem | 16045 | 3976 | 82 | 0 | 44.06482372 | -116.398376 | 2022-09-24 04:21:40 | Gem, Idaho, US | |
3988557 | 3988557 | 2022-09-15 | US | Missouri | Madison | 29123 | 3976 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-09-16 04:21:19 | Madison, Missouri, US | |
1891074 | 1891074 | 2022-09-14 | US | Missouri | Madison | 29123 | 3976 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-09-15 04:21:02 | Madison, Missouri, US | |
374129 | 374129 | 2022-09-13 | US | Missouri | Madison | 29123 | 3976 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-09-14 04:20:44 | Madison, Missouri, US | |
2396731 | 2396731 | 2022-09-12 | US | Missouri | Madison | 29123 | 3976 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-09-13 04:20:57 | Madison, Missouri, US | |
3767809 | 3767809 | 2022-09-11 | US | Missouri | Madison | 29123 | 3976 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-09-12 04:20:58 | Madison, Missouri, US | |
3826384 | 3826384 | 2022-09-10 | US | Missouri | Madison | 29123 | 3976 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-09-11 04:20:50 | Madison, Missouri, US | |
964841 | 964841 | 2022-09-09 | US | Missouri | Madison | 29123 | 3976 | 59 | 0 | 37.47865134 | -90.3467143 | 2022-09-10 04:21:10 | Madison, Missouri, US | |
3745747 | 3745747 | 2022-09-07 | US | Colorado | Las Animas | 8071 | 3976 | 45 | 0 | 37.3153406 | -104.0376458 | 2022-09-08 04:21:02 | Las Animas, Colorado, US | |
1073059 | 1073059 | 2022-08-07 | US | Texas | Madison | 48313 | 3976 | 57 | 0 | 30.96694679 | -95.93003775 | 2022-08-08 04:21:08 | Madison, Texas, US | |
1943647 | 1943647 | 2022-08-06 | US | Texas | Madison | 48313 | 3976 | 57 | 0 | 30.96694679 | -95.93003775 | 2022-08-07 04:20:54 | Madison, Texas, US | |
883446 | 883446 | 2022-08-05 | US | Texas | Madison | 48313 | 3976 | 57 | 0 | 30.96694679 | -95.93003775 | 2022-08-06 04:20:56 | Madison, Texas, US | |
903248 | 903248 | 2022-07-22 | US | Texas | Falls | 48145 | 3976 | 67 | 0 | 31.25350609 | -96.93630086 | 2022-07-23 04:20:53 | Falls, Texas, US | |
960446 | 960446 | 2022-07-19 | US | Louisiana | West Carroll | 22123 | 3976 | 67 | 0 | 32.78550125 | -91.461201 | 2022-07-20 04:20:59 | West Carroll, Louisiana, US | |
2419384 | 2419384 | 2022-07-15 | US | Arkansas | Howard | 5061 | 3976 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-07-16 04:21:05 | Howard, Arkansas, US | |
1420144 | 1420144 | 2022-07-08 | US | Texas | Colorado | 48089 | 3976 | 66 | 0 | 29.622098 | -96.5273805 | 2022-07-09 04:20:59 | Colorado, Texas, US | |
167763 | 167763 | 2022-06-21 | US | Minnesota | Faribault | 27043 | 3976 | 54 | 0 | 43.67381499 | -93.94787458 | 2022-06-22 04:20:54 | Faribault, Minnesota, US | |
3583149 | 3583149 | 2022-05-17 | US | Arkansas | Madison | 5087 | 3976 | 61 | 0 | 36.01038185 | -93.72524943 | 2022-05-18 04:20:50 | Madison, Arkansas, US | |
1504106 | 1504106 | 2022-05-16 | US | Arkansas | Madison | 5087 | 3976 | 61 | 0 | 36.01038185 | -93.72524943 | 2022-05-17 04:20:59 | Madison, Arkansas, US | |
2084465 | 2084465 | 2022-05-15 | US | Arkansas | Madison | 5087 | 3976 | 61 | 0 | 36.01038185 | -93.72524943 | 2022-05-16 04:20:47 | Madison, Arkansas, US | |
3355175 | 3355175 | 2022-05-14 | US | Arkansas | Madison | 5087 | 3976 | 61 | 0 | 36.01038185 | -93.72524943 | 2022-05-15 04:20:53 | Madison, Arkansas, US | |
2534656 | 2534656 | 2022-05-12 | US | Kansas | Allen | 20001 | 3976 | 54 | 0 | 37.88582951 | -95.30030847 | 2022-05-13 04:20:51 | Allen, Kansas, US | |
3448422 | 3448422 | 2022-05-11 | US | Wisconsin | Richland | 55103 | 3976 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-05-12 04:20:54 | Richland, Wisconsin, US | |
3446603 | 3446603 | 2022-05-11 | US | Minnesota | Redwood | 27127 | 3976 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-05-12 04:20:54 | Redwood, Minnesota, US | |
3446102 | 3446102 | 2022-05-11 | US | Kansas | Allen | 20001 | 3976 | 54 | 0 | 37.88582951 | -95.30030847 | 2022-05-12 04:20:54 | Allen, Kansas, US | |
3536719 | 3536719 | 2022-05-10 | US | Kansas | Allen | 20001 | 3976 | 54 | 0 | 37.88582951 | -95.30030847 | 2022-05-11 04:20:48 | Allen, Kansas, US | |
223254 | 223254 | 2022-05-09 | US | Kansas | Allen | 20001 | 3976 | 54 | 0 | 37.88582951 | -95.30030847 | 2022-05-10 04:20:50 | Allen, Kansas, US | |
2332639 | 2332639 | 2022-05-08 | US | Kansas | Allen | 20001 | 3976 | 54 | 0 | 37.88582951 | -95.30030847 | 2022-05-09 04:20:54 | Allen, Kansas, US | |
361601 | 361601 | 2022-05-07 | US | Kansas | Allen | 20001 | 3976 | 54 | 0 | 37.88582951 | -95.30030847 | 2022-05-08 04:20:49 | Allen, Kansas, US | |
1398952 | 1398952 | 2022-05-06 | US | Kansas | Allen | 20001 | 3976 | 54 | 0 | 37.88582951 | -95.30030847 | 2022-05-07 04:21:09 | Allen, Kansas, US | |
1575449 | 1575449 | 2022-05-03 | US | Virginia | Buckingham | 51029 | 3976 | 57 | 0 | 37.57242268 | -78.52518834 | 2022-05-04 04:20:59 | Buckingham, Virginia, US | |
3207759 | 3207759 | 2022-04-11 | US | Louisiana | Bienville | 22013 | 3976 | 111 | 0 | 32.34569994 | -93.05398492 | 2022-04-12 04:20:49 | Bienville, Louisiana, US | |
1577645 | 1577645 | 2022-04-10 | US | Louisiana | Bienville | 22013 | 3976 | 111 | 0 | 32.34569994 | -93.05398492 | 2022-04-11 04:21:02 | Bienville, Louisiana, US | |
1653887 | 1653887 | 2022-04-09 | US | Louisiana | Bienville | 22013 | 3976 | 111 | 0 | 32.34569994 | -93.05398492 | 2022-04-10 04:20:52 | Bienville, Louisiana, US | |
2117209 | 2117209 | 2022-04-08 | US | Louisiana | Bienville | 22013 | 3976 | 111 | 0 | 32.34569994 | -93.05398492 | 2022-04-09 04:20:42 | Bienville, Louisiana, US | |
3321733 | 3321733 | 2022-04-07 | US | Louisiana | Bienville | 22013 | 3976 | 111 | 0 | 32.34569994 | -93.05398492 | 2022-04-08 04:20:48 | Bienville, Louisiana, US | |
2804047 | 2804047 | 2022-04-06 | US | Utah | San Juan | 49037 | 3976 | 48 | 0 | 37.62762978 | -109.80337140000002 | 2022-04-07 04:20:53 | San Juan, Utah, US | |
2802269 | 2802269 | 2022-04-06 | US | Louisiana | Bienville | 22013 | 3976 | 111 | 0 | 32.34569994 | -93.05398492 | 2022-04-07 04:20:53 | Bienville, Louisiana, US | |
3870816 | 3870816 | 2022-04-05 | US | Utah | San Juan | 49037 | 3976 | 48 | 0 | 37.62762978 | -109.80337140000002 | 2022-04-06 04:20:49 | San Juan, Utah, US | |
2752158 | 2752158 | 2022-04-04 | US | Utah | San Juan | 49037 | 3976 | 48 | 0 | 37.62762978 | -109.80337140000002 | 2022-04-05 04:20:48 | San Juan, Utah, US | |
3733504 | 3733504 | 2022-04-03 | US | Utah | San Juan | 49037 | 3976 | 48 | 0 | 37.62762978 | -109.80337140000002 | 2022-04-04 04:20:51 | San Juan, Utah, US | |
502939 | 502939 | 2022-04-02 | US | Utah | San Juan | 49037 | 3976 | 48 | 0 | 37.62762978 | -109.80337140000002 | 2022-04-03 04:20:48 | San Juan, Utah, US | |
3353924 | 3353924 | 2022-04-01 | US | Utah | San Juan | 49037 | 3976 | 48 | 0 | 37.62762978 | -109.80337140000002 | 2022-04-02 04:20:47 | San Juan, Utah, US | |
1543229 | 1543229 | 2022-03-31 | US | Utah | San Juan | 49037 | 3976 | 48 | 0 | 37.62762978 | -109.80337140000002 | 2022-04-01 04:20:28 | San Juan, Utah, US | |
1468251 | 1468251 | 2022-03-24 | Palau | 3976 | 6 | 0 | 7.515 | 134.5825 | 2022-03-25 04:20:46 | Palau | ||||
3022425 | 3022425 | 2022-03-23 | Palau | 3976 | 6 | 0 | 7.515 | 134.5825 | 2022-03-24 04:20:43 | Palau | ||||
2141200 | 2141200 | 2022-03-09 | US | Illinois | Mercer | 17131 | 3976 | 47 | 0 | 41.20596782 | -90.74290052 | 2022-03-10 04:20:48 | Mercer, Illinois, US | |
2526422 | 2526422 | 2022-03-02 | US | Illinois | Warren | 17187 | 3976 | 81 | 0 | 40.84925021 | -90.6147432 | 2022-03-03 04:21:01 | Warren, Illinois, US | |
1513347 | 1513347 | 2022-02-24 | US | Missouri | Morgan | 29141 | 3976 | 101 | 0 | 38.4181765 | -92.88791859 | 2022-02-25 04:21:11 | Morgan, Missouri, US | |
3721096 | 3721096 | 2022-02-21 | US | South Dakota | Union | 46127 | 3976 | 49 | 0 | 42.83112163 | -96.6557828 | 2022-02-22 04:21:01 | Union, South Dakota, US | |
3914930 | 3914930 | 2022-02-20 | US | South Dakota | Union | 46127 | 3976 | 49 | 0 | 42.83112163 | -96.6557828 | 2022-02-21 04:21:05 | Union, South Dakota, US | |
3878488 | 3878488 | 2022-02-19 | US | South Dakota | Union | 46127 | 3976 | 49 | 0 | 42.83112163 | -96.6557828 | 2022-02-20 04:21:00 | Union, South Dakota, US | |
3875385 | 3875385 | 2022-02-19 | China | Shanghai | 3976 | 7 | 0 | 31.201999999999998 | 121.4491 | 2022-02-20 04:21:00 | Shanghai, China | |||
3858744 | 3858744 | 2022-02-18 | US | South Dakota | Union | 46127 | 3976 | 49 | 0 | 42.83112163 | -96.6557828 | 2022-02-19 04:21:11 | Union, South Dakota, US | |
3823704 | 3823704 | 2022-02-16 | US | Texas | Zavala | 48507 | 3976 | 62 | 0 | 28.86617238 | -99.76050829 | 2022-02-17 04:20:56 | Zavala, Texas, US | |
2330879 | 2330879 | 2022-02-04 | US | West Virginia | Taylor | 54091 | 3976 | 59 | 0 | 39.33602617 | -80.0421439 | 2022-02-05 04:21:05 | Taylor, West Virginia, US | |
461684 | 461684 | 2022-02-02 | US | North Carolina | Chowan | 37041 | 3976 | 48 | 0 | 36.12908077 | -76.60118385 | 2022-02-03 04:21:21 | Chowan, North Carolina, US | |
130319 | 130319 | 2022-01-09 | US | Wisconsin | Taylor | 55119 | 3976 | 62 | 0 | 45.21179252 | -90.5004405 | 2022-01-10 04:22:07 | Taylor, Wisconsin, US | |
1219154 | 1219154 | 2022-01-08 | US | Wisconsin | Taylor | 55119 | 3976 | 62 | 0 | 45.21179252 | -90.5004405 | 2022-01-09 04:21:46 | Taylor, Wisconsin, US | |
1393247 | 1393247 | 2022-01-07 | US | Wisconsin | Taylor | 55119 | 3976 | 62 | 0 | 45.21179252 | -90.5004405 | 2022-01-08 04:21:53 | Taylor, Wisconsin, US | |
2610593 | 2610593 | 2022-01-06 | US | California | Del Norte | 6015 | 3976 | 43 | 0 | 41.74228275 | -123.89740630000001 | 2022-01-07 04:22:09 | Del Norte, California, US | |
1283363 | 1283363 | 2022-01-05 | US | Kentucky | Bourbon | 21017 | 3976 | 44 | 0 | 38.2054607 | -84.21827874 | 2022-01-06 04:22:09 | Bourbon, Kentucky, US | |
1435585 | 1435585 | 2021-12-28 | US | Texas | Austin | 48015 | 3976 | 57 | 0 | 29.88548725 | -96.27736949 | 2021-12-29 03:21:43 | Austin, Texas, US | |
2115123 | 2115123 | 2021-12-26 | US | Virginia | Waynesboro | 51820 | 3976 | 53 | 0 | 38.06451466 | -78.90293905 | 2021-12-27 04:21:58 | Waynesboro, Virginia, US | |
3608495 | 3608495 | 2021-12-25 | US | Virginia | Waynesboro | 51820 | 3976 | 53 | 0 | 38.06451466 | -78.90293905 | 2021-12-26 04:21:50 | Waynesboro, Virginia, US | |
2966813 | 2966813 | 2021-12-24 | US | Virginia | Waynesboro | 51820 | 3976 | 53 | 0 | 38.06451466 | -78.90293905 | 2021-12-25 04:21:37 | Waynesboro, Virginia, US | |
799231 | 799231 | 2021-12-22 | US | Georgia | Fannin | 13111 | 3976 | 115 | 0 | 34.86430205 | -84.316964 | 2021-12-23 04:21:21 | Fannin, Georgia, US | |
3828649 | 3828649 | 2021-12-21 | Peru | Unknown | 3976 | 184 | 0 | 2021-12-22 04:21:54 | Unknown, Peru | |||||
1662260 | 1662260 | 2021-12-12 | US | Mississippi | Newton | 28101 | 3976 | 83 | 0 | 32.40021118 | -89.11843336 | 2021-12-13 04:22:02 | Newton, Mississippi, US | |
1666276 | 1666276 | 2021-12-11 | US | Mississippi | Newton | 28101 | 3976 | 83 | 0 | 32.40021118 | -89.11843336 | 2021-12-12 04:22:12 | Newton, Mississippi, US | |
3657428 | 3657428 | 2021-12-10 | US | Mississippi | Newton | 28101 | 3976 | 83 | 0 | 32.40021118 | -89.11843336 | 2021-12-11 04:22:45 | Newton, Mississippi, US | |
688589 | 688589 | 2021-11-13 | US | New York | Delaware | 36025 | 3976 | 49 | 0 | 42.19837623 | -74.96709306 | 2021-11-14 04:21:31 | Delaware, New York, US | |
3514720 | 3514720 | 2021-11-01 | US | Virginia | Carroll | 51035 | 3976 | 95 | 0 | 36.73066666 | -80.73455942 | 2021-11-02 04:22:03 | Carroll, Virginia, US | |
2722973 | 2722973 | 2021-10-30 | US | Missouri | Stone | 29209 | 3976 | 84 | 0 | 36.75000327 | -93.45256475 | 2021-10-31 04:22:08 | Stone, Missouri, US | |
7384 | 7384 | 2021-10-28 | US | Texas | Calhoun | 48057 | 3976 | 36 | 0 | 28.47048236 | -96.61633945 | 2021-10-29 04:22:03 | Calhoun, Texas, US | |
2124683 | 2124683 | 2021-10-21 | US | Idaho | Jefferson | 16051 | 3976 | 43 | 0 | 43.82078483 | -112.3131749 | 2021-10-22 04:21:14 | Jefferson, Idaho, US | |
635502 | 635502 | 2021-10-13 | US | Maryland | Dorchester | 24019 | 3976 | 77 | 0 | 38.45413522 | -76.02752426 | 2021-10-14 04:21:29 | Dorchester, Maryland, US | |
2461797 | 2461797 | 2021-10-06 | US | Tennessee | Wayne | 47181 | 3976 | 39 | 0 | 35.23868267 | -87.78644456 | 2021-10-07 04:21:36 | Wayne, Tennessee, US | |
2459649 | 2459649 | 2021-10-06 | US | Georgia | Peach | 13225 | 3976 | 91 | 0 | 32.56934316 | -83.82937 | 2021-10-07 04:21:36 | Peach, Georgia, US | |
1237926 | 1237926 | 2021-09-27 | US | New York | Wyoming | 36121 | 3976 | 54 | 0 | 42.70145109 | -78.22199579 | 2021-09-28 04:21:28 | Wyoming, New York, US | |
604682 | 604682 | 2021-09-23 | US | Tennessee | Smith | 47159 | 3976 | 44 | 0 | 36.25359775 | -85.95411046 | 2021-09-24 04:21:44 | Smith, Tennessee, 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]);