johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
164 rows where confirmed = 5261 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
351218 | 351218 | 2022-12-14 | US | Tennessee | Bledsoe | 47007 | 5261 | 63 | 0 | 35.59942968 | -85.20611967 | 2022-12-15 04:20:58 | Bledsoe, Tennessee, US | |
1623292 | 1623292 | 2022-11-22 | US | Texas | Aransas | 48007 | 5261 | 94 | 0 | 28.10556197 | -96.9995047 | 2022-11-23 04:21:06 | Aransas, Texas, US | |
3463180 | 3463180 | 2022-11-21 | US | Texas | Aransas | 48007 | 5261 | 94 | 0 | 28.10556197 | -96.9995047 | 2022-11-22 04:20:47 | Aransas, Texas, US | |
1643365 | 1643365 | 2022-11-20 | US | Texas | Aransas | 48007 | 5261 | 94 | 0 | 28.10556197 | -96.9995047 | 2022-11-21 04:21:05 | Aransas, Texas, US | |
2066922 | 2066922 | 2022-11-19 | US | Texas | Aransas | 48007 | 5261 | 94 | 0 | 28.10556197 | -96.9995047 | 2022-11-20 04:21:08 | Aransas, Texas, US | |
1758316 | 1758316 | 2022-11-18 | US | Texas | Aransas | 48007 | 5261 | 94 | 0 | 28.10556197 | -96.9995047 | 2022-11-19 04:21:14 | Aransas, Texas, US | |
2757356 | 2757356 | 2022-10-18 | US | Alaska | North Slope | 2185 | 5261 | 15 | 0 | 69.31479216 | -153.4836093 | 2022-10-19 04:22:26 | North Slope, Alaska, US | |
2025190 | 2025190 | 2022-10-17 | US | Alaska | North Slope | 2185 | 5261 | 15 | 0 | 69.31479216 | -153.4836093 | 2022-10-18 04:22:42 | North Slope, Alaska, US | |
2159968 | 2159968 | 2022-10-16 | US | Alaska | North Slope | 2185 | 5261 | 15 | 0 | 69.31479216 | -153.4836093 | 2022-10-17 04:20:31 | North Slope, Alaska, US | |
516165 | 516165 | 2022-10-15 | US | Alaska | North Slope | 2185 | 5261 | 15 | 0 | 69.31479216 | -153.4836093 | 2022-10-16 04:22:39 | North Slope, Alaska, US | |
2033222 | 2033222 | 2022-10-14 | US | Alaska | North Slope | 2185 | 5261 | 15 | 0 | 69.31479216 | -153.4836093 | 2022-10-15 04:22:00 | North Slope, Alaska, US | |
3753910 | 3753910 | 2022-10-13 | US | Alaska | North Slope | 2185 | 5261 | 15 | 0 | 69.31479216 | -153.4836093 | 2022-10-14 04:22:28 | North Slope, Alaska, US | |
3215307 | 3215307 | 2022-10-12 | US | Illinois | Johnson | 17087 | 5261 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-10-13 04:22:39 | Johnson, Illinois, US | |
3214735 | 3214735 | 2022-10-12 | US | Alaska | North Slope | 2185 | 5261 | 15 | 0 | 69.31479216 | -153.4836093 | 2022-10-13 04:22:39 | North Slope, Alaska, US | |
2529887 | 2529887 | 2022-10-06 | US | Arkansas | Lincoln | 5079 | 5261 | 69 | 0 | 33.95317155 | -91.74002806 | 2022-10-07 04:23:08 | Lincoln, Arkansas, US | |
420479 | 420479 | 2022-09-18 | US | Indiana | Starke | 18149 | 5261 | 105 | 0 | 41.27890281 | -86.64686895 | 2022-09-19 04:21:49 | Starke, Indiana, US | |
3374503 | 3374503 | 2022-09-17 | US | Indiana | Starke | 18149 | 5261 | 105 | 0 | 41.27890281 | -86.64686895 | 2022-09-18 04:22:50 | Starke, Indiana, US | |
2356611 | 2356611 | 2022-09-16 | US | Indiana | Starke | 18149 | 5261 | 105 | 0 | 41.27890281 | -86.64686895 | 2022-09-17 04:20:19 | Starke, Indiana, US | |
1532458 | 1532458 | 2022-08-26 | US | Arkansas | Sharp | 5135 | 5261 | 113 | 0 | 36.16258158 | -91.47819342 | 2022-08-27 04:20:57 | Sharp, Arkansas, US | |
2326876 | 2326876 | 2022-08-24 | US | Wisconsin | Adams | 55001 | 5261 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-08-25 04:21:13 | Adams, Wisconsin, US | |
1162101 | 1162101 | 2022-08-18 | US | Idaho | Cassia | 16031 | 5261 | 55 | 0 | 42.28347888 | -113.6012409 | 2022-08-19 04:20:54 | Cassia, Idaho, US | |
3951425 | 3951425 | 2022-08-17 | US | Idaho | Cassia | 16031 | 5261 | 55 | 0 | 42.28347888 | -113.6012409 | 2022-08-18 04:21:11 | Cassia, Idaho, US | |
883035 | 883035 | 2022-08-05 | US | Puerto Rico | Lajas | 72079 | 5261 | 0 | 0 | 18.011661 | -67.040585 | 2022-08-06 04:20:56 | Lajas, Puerto Rico, US | |
1406017 | 1406017 | 2022-08-02 | US | Illinois | Clark | 17023 | 5261 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-08-03 04:20:59 | Clark, Illinois, US | |
1420246 | 1420246 | 2022-07-08 | US | Texas | Limestone | 48293 | 5261 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-07-09 04:20:59 | Limestone, Texas, US | |
2188274 | 2188274 | 2022-06-22 | US | Colorado | Teller | 8119 | 5261 | 58 | 0 | 38.88133511 | -105.1614893 | 2022-06-23 04:20:55 | Teller, Colorado, US | |
167723 | 167723 | 2022-06-21 | US | Michigan | Osceola | 26133 | 5261 | 83 | 0 | 43.98992088 | -85.32566756 | 2022-06-22 04:20:54 | Osceola, Michigan, US | |
1765006 | 1765006 | 2022-06-20 | US | Michigan | Osceola | 26133 | 5261 | 83 | 0 | 43.98992088 | -85.32566756 | 2022-06-21 04:20:56 | Osceola, Michigan, US | |
3271192 | 3271192 | 2022-06-19 | US | Michigan | Osceola | 26133 | 5261 | 83 | 0 | 43.98992088 | -85.32566756 | 2022-06-20 04:21:01 | Osceola, Michigan, US | |
3399104 | 3399104 | 2022-06-18 | US | Michigan | Osceola | 26133 | 5261 | 83 | 0 | 43.98992088 | -85.32566756 | 2022-06-19 04:20:51 | Osceola, Michigan, US | |
2312981 | 2312981 | 2022-06-17 | US | Michigan | Osceola | 26133 | 5261 | 83 | 0 | 43.98992088 | -85.32566756 | 2022-06-18 04:21:10 | Osceola, Michigan, US | |
560485 | 560485 | 2022-06-16 | US | Michigan | Osceola | 26133 | 5261 | 83 | 0 | 43.98992088 | -85.32566756 | 2022-06-17 04:20:56 | Osceola, Michigan, US | |
3984287 | 3984287 | 2022-06-15 | US | Michigan | Osceola | 26133 | 5261 | 83 | 0 | 43.98992088 | -85.32566756 | 2022-06-16 04:20:55 | Osceola, Michigan, US | |
2981976 | 2981976 | 2022-06-13 | US | Puerto Rico | Aibonito | 72009 | 5261 | 0 | 0 | 18.131361 | -66.264131 | 2022-06-14 04:20:52 | Aibonito, Puerto Rico, US | |
463795 | 463795 | 2022-05-02 | US | Alabama | Pickens | 1107 | 5261 | 102 | 0 | 33.28094866 | -88.08818103 | 2022-05-03 04:21:00 | Pickens, Alabama, US | |
160313 | 160313 | 2022-03-29 | US | North Carolina | Caswell | 37033 | 5261 | 44 | 0 | 36.39312665 | -79.33353281 | 2022-03-30 04:20:45 | Caswell, North Carolina, US | |
160077 | 160077 | 2022-03-29 | US | Nebraska | Dawson | 31047 | 5261 | 31 | 0 | 40.87028216 | -99.82014609999999 | 2022-03-30 04:20:45 | Dawson, Nebraska, US | |
2320474 | 2320474 | 2022-03-16 | US | Indiana | Sullivan | 18153 | 5261 | 74 | 0 | 39.08952258 | -87.41414469 | 2022-03-17 04:20:56 | Sullivan, Indiana, US | |
262674 | 262674 | 2022-03-15 | US | Indiana | Sullivan | 18153 | 5261 | 74 | 0 | 39.08952258 | -87.41414469 | 2022-03-16 04:20:50 | Sullivan, Indiana, US | |
2264363 | 2264363 | 2022-03-14 | US | Arkansas | Clark | 5019 | 5261 | 77 | 0 | 34.04613432 | -93.17484713 | 2022-03-15 04:20:47 | Clark, Arkansas, US | |
2264285 | 2264285 | 2022-03-14 | US | Alabama | Monroe | 1099 | 5261 | 79 | 0 | 31.56729412 | -87.36995001 | 2022-03-15 04:20:47 | Monroe, Alabama, US | |
3628351 | 3628351 | 2022-03-13 | US | Alabama | Monroe | 1099 | 5261 | 78 | 0 | 31.56729412 | -87.36995001 | 2022-03-14 04:20:46 | Monroe, Alabama, US | |
951259 | 951259 | 2022-03-12 | US | Alabama | Monroe | 1099 | 5261 | 78 | 0 | 31.56729412 | -87.36995001 | 2022-03-13 04:20:49 | Monroe, Alabama, US | |
356720 | 356720 | 2022-03-11 | US | Alabama | Monroe | 1099 | 5261 | 78 | 0 | 31.56729412 | -87.36995001 | 2022-03-12 04:20:50 | Monroe, Alabama, US | |
1867410 | 1867410 | 2022-03-10 | US | Missouri | McDonald | 29119 | 5261 | 66 | 0 | 36.62869595 | -94.34867205 | 2022-03-11 04:20:50 | McDonald, Missouri, US | |
1865872 | 1865872 | 2022-03-10 | US | Alabama | Monroe | 1099 | 5261 | 78 | 0 | 31.56729412 | -87.36995001 | 2022-03-11 04:20:50 | Monroe, Alabama, US | |
2141646 | 2141646 | 2022-03-09 | US | Kentucky | Spencer | 21215 | 5261 | 50 | 0 | 38.03223971 | -85.32749335 | 2022-03-10 04:20:48 | Spencer, Kentucky, US | |
2140567 | 2140567 | 2022-03-09 | US | Alabama | Monroe | 1099 | 5261 | 78 | 0 | 31.56729412 | -87.36995001 | 2022-03-10 04:20:48 | Monroe, Alabama, US | |
921157 | 921157 | 2022-03-08 | US | Kentucky | Spencer | 21215 | 5261 | 50 | 0 | 38.03223971 | -85.32749335 | 2022-03-09 04:20:59 | Spencer, Kentucky, US | |
1549444 | 1549444 | 2022-03-07 | US | Kentucky | Spencer | 21215 | 5261 | 50 | 0 | 38.03223971 | -85.32749335 | 2022-03-08 04:20:54 | Spencer, Kentucky, US | |
2201113 | 2201113 | 2022-03-06 | US | Kentucky | Spencer | 21215 | 5261 | 50 | 0 | 38.03223971 | -85.32749335 | 2022-03-07 04:20:47 | Spencer, Kentucky, US | |
2093570 | 2093570 | 2022-03-05 | US | Kentucky | Spencer | 21215 | 5261 | 50 | 0 | 38.03223971 | -85.32749335 | 2022-03-06 04:20:49 | Spencer, Kentucky, US | |
2667270 | 2667270 | 2022-03-04 | US | Kentucky | Spencer | 21215 | 5261 | 50 | 0 | 38.03223971 | -85.32749335 | 2022-03-05 04:21:10 | Spencer, Kentucky, US | |
3046653 | 3046653 | 2022-02-26 | US | Arkansas | Columbia | 5027 | 5261 | 85 | 0 | 33.21230701 | -93.22642793 | 2022-02-27 04:21:04 | Columbia, Arkansas, US | |
3878792 | 3878792 | 2022-02-19 | US | Texas | San Jacinto | 48407 | 5261 | 98 | 0 | 30.57933681 | -95.16260304 | 2022-02-20 04:21:00 | San Jacinto, Texas, US | |
188834 | 188834 | 2022-02-13 | US | Puerto Rico | Moca | 72099 | 5261 | 0 | 0 | 18.377805 | -67.080952 | 2022-02-14 04:20:51 | Moca, Puerto Rico, US | |
127837 | 127837 | 2022-01-09 | US | Indiana | Jennings | 18079 | 5261 | 71 | 0 | 38.99588883 | -85.62710784 | 2022-01-10 04:22:07 | Jennings, Indiana, US | |
1216672 | 1216672 | 2022-01-08 | US | Indiana | Jennings | 18079 | 5261 | 71 | 0 | 38.99588883 | -85.62710784 | 2022-01-09 04:21:46 | Jennings, Indiana, US | |
1390765 | 1390765 | 2022-01-07 | US | Indiana | Jennings | 18079 | 5261 | 71 | 0 | 38.99588883 | -85.62710784 | 2022-01-08 04:21:53 | Jennings, Indiana, US | |
1284421 | 1284421 | 2022-01-05 | US | North Dakota | Stutsman | 38093 | 5261 | 92 | 0 | 46.97962541 | -98.95637318 | 2022-01-06 04:22:09 | Stutsman, North Dakota, US | |
2779975 | 2779975 | 2021-12-31 | US | Tennessee | Overton | 47133 | 5261 | 106 | 0 | 36.34117832 | -85.28989535 | 2022-01-01 04:22:14 | Overton, Tennessee, US | |
1432426 | 1432426 | 2021-12-28 | Denmark | Faroe Islands | 5261 | 13 | 0 | 61.8926 | -6.9118 | 2021-12-29 03:21:43 | Faroe Islands, Denmark | |||
732867 | 732867 | 2021-12-27 | US | North Carolina | Macon | 37113 | 5261 | 87 | 0 | 35.14867843 | -83.41696617 | 2021-12-28 04:21:47 | Macon, North Carolina, US | |
730387 | 730387 | 2021-12-27 | Denmark | Faroe Islands | 5261 | 13 | 0 | 61.8926 | -6.9118 | 2021-12-28 04:21:47 | Faroe Islands, Denmark | |||
2114039 | 2114039 | 2021-12-26 | US | North Carolina | Macon | 37113 | 5261 | 87 | 0 | 35.14867843 | -83.41696617 | 2021-12-27 04:21:58 | Macon, North Carolina, US | |
3607411 | 3607411 | 2021-12-25 | US | North Carolina | Macon | 37113 | 5261 | 87 | 0 | 35.14867843 | -83.41696617 | 2021-12-26 04:21:50 | Macon, North Carolina, US | |
2965729 | 2965729 | 2021-12-24 | US | North Carolina | Macon | 37113 | 5261 | 87 | 0 | 35.14867843 | -83.41696617 | 2021-12-25 04:21:37 | Macon, North Carolina, US | |
3818761 | 3818761 | 2021-12-23 | US | North Carolina | Macon | 37113 | 5261 | 87 | 0 | 35.14867843 | -83.41696617 | 2021-12-24 04:21:34 | Macon, North Carolina, US | |
800769 | 800769 | 2021-12-22 | US | North Carolina | Macon | 37113 | 5261 | 87 | 0 | 35.14867843 | -83.41696617 | 2021-12-23 04:21:21 | Macon, North Carolina, US | |
1716872 | 1716872 | 2021-12-16 | US | Arkansas | Poinsett | 5111 | 5261 | 103 | 0 | 35.57433534 | -90.66268713 | 2021-12-17 04:22:14 | Poinsett, Arkansas, US | |
3658718 | 3658718 | 2021-12-10 | US | Texas | Howard | 48227 | 5261 | 145 | 0 | 32.30621324 | -101.4356444 | 2021-12-11 04:22:45 | Howard, Texas, US | |
405734 | 405734 | 2021-12-07 | US | Kentucky | Marshall | 21157 | 5261 | 85 | 0 | 36.88007070000001 | -88.32803576 | 2021-12-08 04:22:46 | Marshall, Kentucky, US | |
1235001 | 1235001 | 2021-11-28 | US | Virginia | Manassas | 51683 | 5261 | 54 | 0 | 38.7464321 | -77.48509905 | 2021-11-29 04:22:30 | Manassas, Virginia, US | |
1234592 | 1234592 | 2021-11-28 | US | Tennessee | Lauderdale | 47097 | 5261 | 70 | 0 | 35.75893438 | -89.63015909999999 | 2021-11-29 04:22:30 | Lauderdale, Tennessee, US | |
1361708 | 1361708 | 2021-11-27 | US | Virginia | Manassas | 51683 | 5261 | 54 | 0 | 38.7464321 | -77.48509905 | 2021-11-28 04:22:43 | Manassas, Virginia, US | |
1361299 | 1361299 | 2021-11-27 | US | Tennessee | Lauderdale | 47097 | 5261 | 70 | 0 | 35.75893438 | -89.63015909999999 | 2021-11-28 04:22:43 | Lauderdale, Tennessee, US | |
761699 | 761699 | 2021-11-26 | US | Virginia | Manassas | 51683 | 5261 | 54 | 0 | 38.7464321 | -77.48509905 | 2021-11-27 04:22:45 | Manassas, Virginia, US | |
761290 | 761290 | 2021-11-26 | US | Tennessee | Lauderdale | 47097 | 5261 | 70 | 0 | 35.75893438 | -89.63015909999999 | 2021-11-27 04:22:45 | Lauderdale, Tennessee, US | |
448753 | 448753 | 2021-11-17 | US | Kentucky | Calloway | 21035 | 5261 | 62 | 0 | 36.62093411 | -88.2731593 | 2021-11-18 04:21:33 | Calloway, Kentucky, US | |
47161 | 47161 | 2021-11-02 | US | Washington | Okanogan | 53047 | 5261 | 83 | 0 | 48.54855019 | -119.73872240000001 | 2021-11-03 06:22:09 | Okanogan, Washington, US | |
3494092 | 3494092 | 2021-10-26 | US | Missouri | Laclede | 29105 | 5261 | 128 | 0 | 37.65896829 | -92.5888493 | 2021-10-27 04:22:32 | Laclede, Missouri, US | |
2126268 | 2126268 | 2021-10-21 | US | Ohio | Williams | 39171 | 5261 | 93 | 0 | 41.56052014 | -84.58429552 | 2021-10-22 04:21:14 | Williams, Ohio, US | |
1493239 | 1493239 | 2021-10-12 | US | Michigan | Gratiot | 26057 | 5261 | 124 | 0 | 43.29265605 | -84.60505416 | 2021-10-13 04:20:51 | Gratiot, Michigan, US | |
3008972 | 3008972 | 2021-10-11 | US | Michigan | Gratiot | 26057 | 5261 | 124 | 0 | 43.29265605 | -84.60505416 | 2021-10-12 04:21:09 | Gratiot, Michigan, US | |
3832515 | 3832515 | 2021-10-05 | Japan | Wakayama | 5261 | 61 | 0 | 33.911879 | 135.505446 | 2021-10-06 04:21:33 | Wakayama, Japan | |||
1336981 | 1336981 | 2021-09-28 | US | Pennsylvania | Venango | 42121 | 5261 | 111 | 0 | 41.40323442 | -79.75845449 | 2021-09-29 04:21:45 | Venango, Pennsylvania, US | |
809331 | 809331 | 2021-09-20 | Brunei | 5261 | 28 | 0 | 4.5353 | 114.7277 | 2021-09-21 04:21:26 | Brunei | ||||
1818210 | 1818210 | 2021-09-19 | US | Washington | Douglas | 53017 | 5261 | 26 | 0 | 47.7361335 | -119.69293700000001 | 2021-09-20 04:21:22 | Douglas, Washington, US | |
19790 | 19790 | 2021-09-18 | US | Washington | Douglas | 53017 | 5261 | 26 | 0 | 47.7361335 | -119.69293700000001 | 2021-09-19 04:21:34 | Douglas, Washington, US | |
2621475 | 2621475 | 2021-09-17 | US | Washington | Douglas | 53017 | 5261 | 26 | 0 | 47.7361335 | -119.69293700000001 | 2021-09-18 04:21:24 | Douglas, Washington, US | |
1376735 | 1376735 | 2021-09-15 | US | New York | Madison | 36053 | 5261 | 96 | 0 | 42.91653905 | -75.67266639 | 2021-09-16 04:22:19 | Madison, New York, US | |
1388568 | 1388568 | 2021-09-13 | US | Tennessee | Giles | 47055 | 5261 | 102 | 0 | 35.20222469 | -87.03992678 | 2021-09-14 04:21:41 | Giles, Tennessee, US | |
1263835 | 1263835 | 2021-09-09 | US | Illinois | Stephenson | 17177 | 5261 | 88 | 0 | 42.35129217 | -89.662598 | 2021-09-10 04:21:20 | Stephenson, Illinois, US | |
70383 | 70383 | 2021-09-01 | US | Virginia | Culpeper | 51047 | 5261 | 70 | 0 | 38.48199985 | -77.95630870000002 | 2021-09-02 04:21:15 | Culpeper, Virginia, US | |
2794980 | 2794980 | 2021-08-28 | US | Missouri | Platte | 29165 | 5261 | 54 | 0 | 39.38154439 | -94.77068479 | 2021-08-29 04:21:14 | Platte, Missouri, US | |
35391 | 35391 | 2021-08-25 | US | Tennessee | Obion | 47131 | 5261 | 98 | 0 | 36.35732446 | -89.14921589 | 2021-08-26 04:21:28 | Obion, Tennessee, US | |
3165898 | 3165898 | 2021-08-23 | San Marino | 5261 | 90 | 0 | 43.9424 | 12.4578 | 2021-08-24 04:21:19 | San Marino | ||||
515353 | 515353 | 2021-08-19 | United Kingdom | Gibraltar | 5261 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-20 04:21:33 | Gibraltar, United Kingdom | |||
104319 | 104319 | 2021-08-15 | US | Illinois | Henry | 17073 | 5261 | 70 | 0 | 41.3533994 | -90.13296166 | 2021-08-16 04:21:31 | Henry, Illinois, US | |
508677 | 508677 | 2021-08-14 | US | Illinois | Henry | 17073 | 5261 | 70 | 0 | 41.3533994 | -90.13296166 | 2021-08-15 04:21:41 | Henry, Illinois, 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]);