johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
212 rows where confirmed = 4321 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
872362 | 872362 | 2022-12-11 | US | Wisconsin | Lafayette | 55065 | 4321 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-12 04:21:01 | Lafayette, Wisconsin, US | |
260892 | 260892 | 2022-12-10 | US | Wisconsin | Lafayette | 55065 | 4321 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-11 04:20:50 | Lafayette, Wisconsin, US | |
3939606 | 3939606 | 2022-12-09 | US | Wisconsin | Lafayette | 55065 | 4321 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-10 04:21:02 | Lafayette, Wisconsin, US | |
3717438 | 3717438 | 2022-12-06 | US | Texas | Zapata | 48505 | 4321 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-07 04:20:58 | Zapata, Texas, US | |
2418143 | 2418143 | 2022-12-05 | US | Texas | Zapata | 48505 | 4321 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-06 04:21:03 | Zapata, Texas, US | |
721751 | 721751 | 2022-12-04 | US | Texas | Zapata | 48505 | 4321 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-05 04:20:58 | Zapata, Texas, US | |
718972 | 718972 | 2022-12-04 | US | Arkansas | Franklin | 5047 | 4321 | 79 | 0 | 35.51202821 | -93.89299569 | 2022-12-05 04:20:58 | Franklin, Arkansas, US | |
2820040 | 2820040 | 2022-12-03 | US | Texas | Zapata | 48505 | 4321 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-04 04:20:56 | Zapata, Texas, US | |
836896 | 836896 | 2022-12-02 | US | Texas | Zapata | 48505 | 4321 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-03 04:21:02 | Zapata, Texas, US | |
2139426 | 2139426 | 2022-12-01 | US | Texas | Zapata | 48505 | 4321 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-02 04:21:07 | Zapata, Texas, US | |
1967842 | 1967842 | 2022-11-30 | US | Texas | Zapata | 48505 | 4321 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-12-01 04:21:03 | Zapata, Texas, US | |
3598696 | 3598696 | 2022-11-14 | US | Michigan | Kalkaska | 26079 | 4321 | 68 | 0 | 44.68512729 | -85.09085699 | 2022-11-15 04:21:16 | Kalkaska, Michigan, US | |
313554 | 313554 | 2022-11-13 | US | Michigan | Kalkaska | 26079 | 4321 | 68 | 0 | 44.68512729 | -85.09085699 | 2022-11-14 04:21:09 | Kalkaska, Michigan, US | |
64715 | 64715 | 2022-11-12 | US | Michigan | Kalkaska | 26079 | 4321 | 68 | 0 | 44.68512729 | -85.09085699 | 2022-11-13 04:21:14 | Kalkaska, Michigan, US | |
2928877 | 2928877 | 2022-11-11 | US | Michigan | Kalkaska | 26079 | 4321 | 68 | 0 | 44.68512729 | -85.09085699 | 2022-11-12 04:20:41 | Kalkaska, Michigan, US | |
2507713 | 2507713 | 2022-11-10 | US | Michigan | Kalkaska | 26079 | 4321 | 68 | 0 | 44.68512729 | -85.09085699 | 2022-11-11 04:21:22 | Kalkaska, Michigan, US | |
2432588 | 2432588 | 2022-11-09 | US | Michigan | Kalkaska | 26079 | 4321 | 68 | 0 | 44.68512729 | -85.09085699 | 2022-11-10 04:21:16 | Kalkaska, Michigan, US | |
2162799 | 2162799 | 2022-10-16 | US | Texas | Young | 48503 | 4321 | 96 | 0 | 33.17659707 | -98.68790885 | 2022-10-17 04:20:31 | Young, Texas, US | |
518996 | 518996 | 2022-10-15 | US | Texas | Young | 48503 | 4321 | 96 | 0 | 33.17659707 | -98.68790885 | 2022-10-16 04:22:39 | Young, Texas, US | |
2036053 | 2036053 | 2022-10-14 | US | Texas | Young | 48503 | 4321 | 96 | 0 | 33.17659707 | -98.68790885 | 2022-10-15 04:22:00 | Young, Texas, US | |
3097226 | 3097226 | 2022-10-09 | China | Beijing | 4321 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-10 04:22:32 | Beijing, China | |||
2530935 | 2530935 | 2022-10-06 | US | Louisiana | West Carroll | 22123 | 4321 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-07 04:23:08 | West Carroll, Louisiana, US | |
1891677 | 1891677 | 2022-09-14 | US | Oklahoma | Atoka | 40005 | 4321 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-15 04:21:02 | Atoka, Oklahoma, US | |
374732 | 374732 | 2022-09-13 | US | Oklahoma | Atoka | 40005 | 4321 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-14 04:20:44 | Atoka, Oklahoma, US | |
2397418 | 2397418 | 2022-09-12 | US | Oregon | Curry | 41015 | 4321 | 65 | 0 | 42.45911325 | -124.157282 | 2022-09-13 04:20:57 | Curry, Oregon, US | |
2397334 | 2397334 | 2022-09-12 | US | Oklahoma | Atoka | 40005 | 4321 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-13 04:20:57 | Atoka, Oklahoma, US | |
3768412 | 3768412 | 2022-09-11 | US | Oklahoma | Atoka | 40005 | 4321 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-12 04:20:58 | Atoka, Oklahoma, US | |
3826987 | 3826987 | 2022-09-10 | US | Oklahoma | Atoka | 40005 | 4321 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-11 04:20:50 | Atoka, Oklahoma, US | |
965444 | 965444 | 2022-09-09 | US | Oklahoma | Atoka | 40005 | 4321 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-10 04:21:10 | Atoka, Oklahoma, US | |
255846 | 255846 | 2022-09-08 | US | Oklahoma | Atoka | 40005 | 4321 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-09 04:21:11 | Atoka, Oklahoma, US | |
2096609 | 2096609 | 2022-08-27 | US | Arkansas | Izard | 5065 | 4321 | 75 | 0 | 36.09604046 | -91.90847954 | 2022-08-28 04:21:02 | Izard, Arkansas, US | |
2855484 | 2855484 | 2022-08-22 | US | Oregon | Hood River | 41027 | 4321 | 46 | 0 | 45.51872811 | -121.6552036 | 2022-08-23 04:20:56 | Hood River, Oregon, US | |
1349694 | 1349694 | 2022-08-10 | US | Virginia | Manassas Park | 51685 | 4321 | 28 | 0 | 38.77058531 | -77.44399307 | 2022-08-11 04:20:49 | Manassas Park, Virginia, US | |
3617601 | 3617601 | 2022-08-01 | US | Arkansas | Polk | 5113 | 4321 | 151 | 0 | 34.48254879 | -94.22728802 | 2022-08-02 04:20:53 | Polk, Arkansas, US | |
3617192 | 3617192 | 2022-08-01 | Micronesia | 4321 | 4 | 0 | 7.4256 | 150.5508 | 2022-08-02 04:20:53 | Micronesia | ||||
3871672 | 3871672 | 2022-07-31 | Micronesia | 4321 | 4 | 0 | 7.4256 | 150.5508 | 2022-08-01 04:21:03 | Micronesia | ||||
674426 | 674426 | 2022-07-30 | Micronesia | 4321 | 4 | 0 | 7.4256 | 150.5508 | 2022-07-31 04:21:02 | Micronesia | ||||
1783625 | 1783625 | 2022-07-29 | Micronesia | 4321 | 4 | 0 | 7.4256 | 150.5508 | 2022-07-30 04:20:42 | Micronesia | ||||
1649383 | 1649383 | 2022-06-23 | US | Illinois | Jo Daviess | 17085 | 4321 | 36 | 0 | 42.36542373 | -90.21094405 | 2022-06-24 04:20:58 | Jo Daviess, Illinois, US | |
3984123 | 3984123 | 2022-06-15 | US | Louisiana | LaSalle | 22059 | 4321 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-16 04:20:55 | LaSalle, Louisiana, US | |
2238539 | 2238539 | 2022-06-12 | US | Texas | Lee | 48287 | 4321 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-06-13 04:21:14 | Lee, Texas, US | |
3596529 | 3596529 | 2022-05-23 | US | West Virginia | Monroe | 54063 | 4321 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-05-24 04:20:57 | Monroe, West Virginia, US | |
1188249 | 1188249 | 2022-05-18 | US | West Virginia | Morgan | 54065 | 4321 | 69 | 0 | 39.55439028 | -78.26311676 | 2022-05-19 04:20:54 | Morgan, West Virginia, US | |
1185715 | 1185715 | 2022-05-18 | US | Illinois | Carroll | 17015 | 4321 | 48 | 0 | 42.06823429 | -89.93395545 | 2022-05-19 04:20:54 | Carroll, Illinois, US | |
1573812 | 1573812 | 2022-05-03 | US | Michigan | Ogemaw | 26129 | 4321 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-05-04 04:20:59 | Ogemaw, Michigan, US | |
465072 | 465072 | 2022-05-02 | US | Michigan | Ogemaw | 26129 | 4321 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-05-03 04:21:00 | Ogemaw, Michigan, US | |
3917711 | 3917711 | 2022-05-01 | US | Michigan | Ogemaw | 26129 | 4321 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-05-02 04:21:10 | Ogemaw, Michigan, US | |
2842515 | 2842515 | 2022-04-30 | US | Michigan | Ogemaw | 26129 | 4321 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-05-01 04:20:57 | Ogemaw, Michigan, US | |
1158828 | 1158828 | 2022-04-29 | US | Michigan | Ogemaw | 26129 | 4321 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-04-30 04:21:05 | Ogemaw, Michigan, US | |
1698010 | 1698010 | 2022-04-28 | US | Michigan | Ogemaw | 26129 | 4321 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-04-29 04:20:59 | Ogemaw, Michigan, US | |
3853493 | 3853493 | 2022-04-27 | US | Michigan | Ogemaw | 26129 | 4321 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-04-28 04:20:47 | Ogemaw, Michigan, US | |
1328597 | 1328597 | 2022-04-26 | US | North Carolina | Northampton | 37131 | 4321 | 82 | 0 | 36.41736238 | -77.39769443 | 2022-04-27 04:20:52 | Northampton, North Carolina, US | |
3724551 | 3724551 | 2022-04-25 | US | North Carolina | Northampton | 37131 | 4321 | 82 | 0 | 36.41736238 | -77.39769443 | 2022-04-26 04:20:51 | Northampton, North Carolina, US | |
2031119 | 2031119 | 2022-04-24 | US | North Carolina | Northampton | 37131 | 4321 | 82 | 0 | 36.41736238 | -77.39769443 | 2022-04-25 04:20:56 | Northampton, North Carolina, US | |
748694 | 748694 | 2022-04-23 | US | North Carolina | Northampton | 37131 | 4321 | 82 | 0 | 36.41736238 | -77.39769443 | 2022-04-24 04:20:56 | Northampton, North Carolina, US | |
3439179 | 3439179 | 2022-04-22 | US | North Carolina | Northampton | 37131 | 4321 | 82 | 0 | 36.41736238 | -77.39769443 | 2022-04-23 04:20:50 | Northampton, North Carolina, US | |
2894764 | 2894764 | 2022-04-21 | US | North Carolina | Northampton | 37131 | 4321 | 82 | 0 | 36.41736238 | -77.39769443 | 2022-04-22 04:20:45 | Northampton, North Carolina, US | |
2309636 | 2309636 | 2022-04-20 | US | North Carolina | Northampton | 37131 | 4321 | 82 | 0 | 36.41736238 | -77.39769443 | 2022-04-21 04:20:46 | Northampton, North Carolina, US | |
2801740 | 2801740 | 2022-04-06 | US | Illinois | Bond | 17005 | 4321 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-04-07 04:20:53 | Bond, Illinois, US | |
2751630 | 2751630 | 2022-04-04 | US | Puerto Rico | Guayama | 72057 | 4321 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-04-05 04:20:48 | Guayama, Puerto Rico, US | |
3352222 | 3352222 | 2022-04-01 | US | Maine | Washington | 23029 | 4321 | 52 | 0 | 45.01607142 | -67.62813524 | 2022-04-02 04:20:47 | Washington, Maine, US | |
1543481 | 1543481 | 2022-03-31 | US | West Virginia | Wetzel | 54103 | 4321 | 83 | 0 | 39.6065771 | -80.64016540000001 | 2022-04-01 04:20:28 | Wetzel, West Virginia, US | |
161535 | 161535 | 2022-03-29 | US | West Virginia | Wetzel | 54103 | 4321 | 83 | 0 | 39.6065771 | -80.64016540000001 | 2022-03-30 04:20:45 | Wetzel, West Virginia, US | |
160777 | 160777 | 2022-03-29 | US | Puerto Rico | Morovis | 72101 | 4321 | 0 | 0 | 18.316963 | -66.420383 | 2022-03-30 04:20:45 | Morovis, Puerto Rico, US | |
1439348 | 1439348 | 2022-03-28 | US | Puerto Rico | Morovis | 72101 | 4321 | 0 | 0 | 18.316963 | -66.420383 | 2022-03-29 04:20:46 | Morovis, Puerto Rico, US | |
943732 | 943732 | 2022-02-28 | US | Georgia | Washington | 13303 | 4321 | 132 | 0 | 32.96711864 | -82.79357039 | 2022-03-01 04:21:09 | Washington, Georgia, US | |
3720912 | 3720912 | 2022-02-21 | US | Puerto Rico | Camuy | 72027 | 4321 | 0 | 0 | 18.418578 | -66.860206 | 2022-02-22 04:21:01 | Camuy, Puerto Rico, US | |
3914746 | 3914746 | 2022-02-20 | US | Puerto Rico | Camuy | 72027 | 4321 | 0 | 0 | 18.418578 | -66.860206 | 2022-02-21 04:21:05 | Camuy, Puerto Rico, US | |
1365044 | 1365044 | 2022-02-08 | US | Pennsylvania | Montour | 42093 | 4321 | 86 | 0 | 41.03023987 | -76.66345939 | 2022-02-09 04:21:04 | Montour, Pennsylvania, US | |
1363520 | 1363520 | 2022-02-08 | US | Iowa | Buchanan | 19019 | 4321 | 54 | 0 | 42.4709188 | -91.83510825 | 2022-02-09 04:21:04 | Buchanan, Iowa, US | |
73221 | 73221 | 2022-02-07 | US | Nebraska | Washington | 31177 | 4321 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-08 04:21:15 | Washington, Nebraska, US | |
72258 | 72258 | 2022-02-07 | US | Iowa | Buchanan | 19019 | 4321 | 54 | 0 | 42.4709188 | -91.83510825 | 2022-02-08 04:21:15 | Buchanan, Iowa, US | |
2013874 | 2013874 | 2022-02-06 | US | Iowa | Buchanan | 19019 | 4321 | 54 | 0 | 42.4709188 | -91.83510825 | 2022-02-07 04:21:05 | Buchanan, Iowa, US | |
1295203 | 1295203 | 2022-02-05 | US | Iowa | Buchanan | 19019 | 4321 | 54 | 0 | 42.4709188 | -91.83510825 | 2022-02-06 04:21:00 | Buchanan, Iowa, US | |
2328531 | 2328531 | 2022-02-04 | US | Iowa | Buchanan | 19019 | 4321 | 54 | 0 | 42.4709188 | -91.83510825 | 2022-02-05 04:21:05 | Buchanan, Iowa, US | |
2327854 | 2327854 | 2022-02-04 | US | Arkansas | Hempstead | 5057 | 4321 | 52 | 0 | 33.73325583 | -93.66935133 | 2022-02-05 04:21:05 | Hempstead, Arkansas, US | |
2475122 | 2475122 | 2022-02-03 | US | Iowa | Buchanan | 19019 | 4321 | 54 | 0 | 42.4709188 | -91.83510825 | 2022-02-04 04:21:10 | Buchanan, Iowa, US | |
460547 | 460547 | 2022-02-02 | US | Iowa | Buchanan | 19019 | 4321 | 54 | 0 | 42.4709188 | -91.83510825 | 2022-02-03 04:21:21 | Buchanan, Iowa, US | |
1473257 | 1473257 | 2022-01-17 | US | Indiana | Sullivan | 18153 | 4321 | 64 | 0 | 39.08952258 | -87.41414469 | 2022-01-18 04:21:04 | Sullivan, Indiana, US | |
1116123 | 1116123 | 2022-01-11 | US | Oklahoma | Beckham | 40009 | 4321 | 84 | 0 | 35.26862449 | -99.68128023 | 2022-01-12 04:21:44 | Beckham, Oklahoma, US | |
1694851 | 1694851 | 2022-01-10 | US | Oklahoma | Beckham | 40009 | 4321 | 84 | 0 | 35.26862449 | -99.68128023 | 2022-01-11 04:22:01 | Beckham, Oklahoma, US | |
129266 | 129266 | 2022-01-09 | US | Oklahoma | Beckham | 40009 | 4321 | 84 | 0 | 35.26862449 | -99.68128023 | 2022-01-10 04:22:07 | Beckham, Oklahoma, US | |
1218101 | 1218101 | 2022-01-08 | US | Oklahoma | Beckham | 40009 | 4321 | 84 | 0 | 35.26862449 | -99.68128023 | 2022-01-09 04:21:46 | Beckham, Oklahoma, US | |
1392194 | 1392194 | 2022-01-07 | US | Oklahoma | Beckham | 40009 | 4321 | 84 | 0 | 35.26862449 | -99.68128023 | 2022-01-08 04:21:53 | Beckham, Oklahoma, US | |
2612786 | 2612786 | 2022-01-06 | US | Puerto Rico | Dorado | 72051 | 4321 | 0 | 0 | 18.436115 | -66.278669 | 2022-01-07 04:22:09 | Dorado, Puerto Rico, US | |
2612581 | 2612581 | 2022-01-06 | US | Oklahoma | Beckham | 40009 | 4321 | 84 | 0 | 35.26862449 | -99.68128023 | 2022-01-07 04:22:09 | Beckham, Oklahoma, US | |
1284523 | 1284523 | 2022-01-05 | US | Oklahoma | Beckham | 40009 | 4321 | 84 | 0 | 35.26862449 | -99.68128023 | 2022-01-06 04:22:09 | Beckham, Oklahoma, US | |
3521486 | 3521486 | 2022-01-02 | US | Nebraska | Cass | 31025 | 4321 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-01-03 02:22:25 | Cass, Nebraska, US | |
2170040 | 2170040 | 2022-01-01 | US | Ohio | Holmes | 39075 | 4321 | 165 | 0 | 40.56163713 | -81.92635677 | 2022-01-02 04:20:52 | Holmes, Ohio, US | |
2169616 | 2169616 | 2022-01-01 | US | Nebraska | Cass | 31025 | 4321 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-01-02 04:20:52 | Cass, Nebraska, US | |
2780000 | 2780000 | 2021-12-31 | US | Tennessee | Wayne | 47181 | 4321 | 47 | 0 | 35.23868267 | -87.78644456 | 2022-01-01 04:22:14 | Wayne, Tennessee, US | |
2779471 | 2779471 | 2021-12-31 | US | Ohio | Holmes | 39075 | 4321 | 165 | 0 | 40.56163713 | -81.92635677 | 2022-01-01 04:22:14 | Holmes, Ohio, US | |
2779047 | 2779047 | 2021-12-31 | US | Nebraska | Cass | 31025 | 4321 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-01-01 04:22:14 | Cass, Nebraska, US | |
4000704 | 4000704 | 2021-12-30 | US | Nebraska | Cass | 31025 | 4321 | 16 | 0 | 40.90899107 | -96.13971217 | 2021-12-31 04:21:50 | Cass, Nebraska, US | |
3497986 | 3497986 | 2021-12-15 | US | Mississippi | Coahoma | 28027 | 4321 | 112 | 0 | 34.22772299 | -90.60415045 | 2021-12-16 04:22:11 | Coahoma, Mississippi, US | |
406227 | 406227 | 2021-12-07 | US | Missouri | Miller | 29131 | 4321 | 100 | 0 | 38.21450288 | -92.42610898 | 2021-12-08 04:22:46 | Miller, Missouri, US | |
1741415 | 1741415 | 2021-12-05 | US | Georgia | Sumter | 13261 | 4321 | 138 | 0 | 32.03650571 | -84.19821492 | 2021-12-06 04:22:34 | Sumter, Georgia, US | |
138847 | 138847 | 2021-12-04 | US | Georgia | Sumter | 13261 | 4321 | 138 | 0 | 32.03650571 | -84.19821492 | 2021-12-05 04:22:25 | Sumter, Georgia, US | |
2196500 | 2196500 | 2021-12-03 | US | Georgia | Sumter | 13261 | 4321 | 138 | 0 | 32.03650571 | -84.19821492 | 2021-12-04 04:22:18 | Sumter, Georgia, US | |
3263 | 3263 | 2021-12-02 | US | Tennessee | DeKalb | 47041 | 4321 | 77 | 0 | 35.97616272 | -85.83689361 | 2021-12-03 04:23:05 | DeKalb, 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]);