johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
212 rows where confirmed = 3806 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755865 | 2755865 | 2022-12-29 | US | Tennessee | Jackson | 47087 | 3806 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-12-30 04:21:04 | Jackson, Tennessee, US | |
1076871 | 1076871 | 2022-12-28 | US | Tennessee | Jackson | 47087 | 3806 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-12-29 04:21:01 | Jackson, Tennessee, US | |
330868 | 330868 | 2022-12-27 | US | Tennessee | Jackson | 47087 | 3806 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-12-28 04:21:04 | Jackson, Tennessee, US | |
220941 | 220941 | 2022-12-26 | US | Tennessee | Jackson | 47087 | 3806 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-12-27 04:21:07 | Jackson, Tennessee, US | |
3225398 | 3225398 | 2022-12-25 | US | Tennessee | Jackson | 47087 | 3806 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-12-26 04:21:06 | Jackson, Tennessee, US | |
1021312 | 1021312 | 2022-12-24 | US | Tennessee | Jackson | 47087 | 3806 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-12-25 04:21:04 | Jackson, Tennessee, US | |
2952619 | 2952619 | 2022-12-20 | US | Iowa | O'Brien | 19141 | 3806 | 73 | 0 | 43.08310673 | -95.62474482 | 2022-12-21 04:21:03 | O'Brien, Iowa, US | |
3175021 | 3175021 | 2022-12-19 | US | Iowa | O'Brien | 19141 | 3806 | 73 | 0 | 43.08310673 | -95.62474482 | 2022-12-20 04:21:04 | O'Brien, Iowa, US | |
1629538 | 1629538 | 2022-12-18 | US | Iowa | O'Brien | 19141 | 3806 | 73 | 0 | 43.08310673 | -95.62474482 | 2022-12-19 04:21:03 | O'Brien, Iowa, US | |
504917 | 504917 | 2022-12-17 | US | Iowa | O'Brien | 19141 | 3806 | 73 | 0 | 43.08310673 | -95.62474482 | 2022-12-18 04:21:03 | O'Brien, Iowa, US | |
3325489 | 3325489 | 2022-12-16 | US | Iowa | O'Brien | 19141 | 3806 | 73 | 0 | 43.08310673 | -95.62474482 | 2022-12-17 04:21:04 | O'Brien, Iowa, US | |
544001 | 544001 | 2022-12-15 | US | Iowa | O'Brien | 19141 | 3806 | 73 | 0 | 43.08310673 | -95.62474482 | 2022-12-16 04:21:01 | O'Brien, Iowa, US | |
349529 | 349529 | 2022-12-14 | US | Iowa | O'Brien | 19141 | 3806 | 73 | 0 | 43.08310673 | -95.62474482 | 2022-12-15 04:20:58 | O'Brien, Iowa, US | |
310748 | 310748 | 2022-12-13 | US | South Dakota | Clay | 46027 | 3806 | 26 | 0 | 42.91296147 | -96.97656917 | 2022-12-14 04:21:04 | Clay, South Dakota, US | |
1151809 | 1151809 | 2022-12-12 | US | South Dakota | Clay | 46027 | 3806 | 26 | 0 | 42.91296147 | -96.97656917 | 2022-12-13 04:21:01 | Clay, South Dakota, US | |
871663 | 871663 | 2022-12-11 | US | South Dakota | Clay | 46027 | 3806 | 26 | 0 | 42.91296147 | -96.97656917 | 2022-12-12 04:21:01 | Clay, South Dakota, US | |
260193 | 260193 | 2022-12-10 | US | South Dakota | Clay | 46027 | 3806 | 26 | 0 | 42.91296147 | -96.97656917 | 2022-12-11 04:20:50 | Clay, South Dakota, US | |
3938907 | 3938907 | 2022-12-09 | US | South Dakota | Clay | 46027 | 3806 | 26 | 0 | 42.91296147 | -96.97656917 | 2022-12-10 04:21:02 | Clay, South Dakota, US | |
3380239 | 3380239 | 2022-12-08 | US | South Dakota | Clay | 46027 | 3806 | 26 | 0 | 42.91296147 | -96.97656917 | 2022-12-09 04:21:05 | Clay, South Dakota, US | |
1987510 | 1987510 | 2022-12-07 | US | South Dakota | Clay | 46027 | 3806 | 26 | 0 | 42.91296147 | -96.97656917 | 2022-12-08 04:21:07 | Clay, South Dakota, US | |
3312025 | 3312025 | 2022-11-23 | China | Heilongjiang | 3806 | 13 | 0 | 47.862 | 127.7615 | 2022-11-24 04:21:09 | Heilongjiang, China | |||
3463476 | 3463476 | 2022-11-21 | US | Virginia | Brunswick | 51025 | 3806 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-11-22 04:20:47 | Brunswick, Virginia, US | |
1643661 | 1643661 | 2022-11-20 | US | Virginia | Brunswick | 51025 | 3806 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-11-21 04:21:05 | Brunswick, Virginia, US | |
2067218 | 2067218 | 2022-11-19 | US | Virginia | Brunswick | 51025 | 3806 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-11-20 04:21:08 | Brunswick, Virginia, US | |
1758612 | 1758612 | 2022-11-18 | US | Virginia | Brunswick | 51025 | 3806 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-11-19 04:21:14 | Brunswick, Virginia, US | |
3029605 | 3029605 | 2022-11-17 | US | Virginia | Brunswick | 51025 | 3806 | 52 | 0 | 36.76366949 | -77.8593436 | 2022-11-18 04:21:15 | Brunswick, Virginia, US | |
3754456 | 3754456 | 2022-10-13 | US | Illinois | Cumberland | 17035 | 3806 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-10-14 04:22:28 | Cumberland, Illinois, US | |
1811404 | 1811404 | 2022-10-05 | US | Colorado | Gunnison | 8051 | 3806 | 15 | 0 | 38.66611652 | -107.0320729 | 2022-10-06 04:21:22 | Gunnison, Colorado, US | |
133527 | 133527 | 2022-10-04 | US | Puerto Rico | Rincon | 72117 | 3806 | 0 | 0 | 18.335443 | -67.23174 | 2022-10-05 04:23:06 | Rincon, Puerto Rico, US | |
2688474 | 2688474 | 2022-10-03 | US | Puerto Rico | Rincon | 72117 | 3806 | 0 | 0 | 18.335443 | -67.23174 | 2022-10-04 04:22:55 | Rincon, Puerto Rico, US | |
3375799 | 3375799 | 2022-09-17 | US | North Dakota | Walsh | 38099 | 3806 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-09-18 04:22:50 | Walsh, North Dakota, US | |
2357907 | 2357907 | 2022-09-16 | US | North Dakota | Walsh | 38099 | 3806 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-09-17 04:20:19 | Walsh, North Dakota, US | |
1892570 | 1892570 | 2022-09-14 | US | Virginia | Westmoreland | 51193 | 3806 | 56 | 0 | 38.11021557 | -76.80213247 | 2022-09-15 04:21:02 | Westmoreland, Virginia, US | |
254459 | 254459 | 2022-09-08 | US | Indiana | Tipton | 18159 | 3806 | 89 | 0 | 40.31123252 | -86.05234925 | 2022-09-09 04:21:11 | Tipton, Indiana, US | |
3746257 | 3746257 | 2022-09-07 | US | Indiana | Tipton | 18159 | 3806 | 89 | 0 | 40.31123252 | -86.05234925 | 2022-09-08 04:21:02 | Tipton, Indiana, US | |
3911304 | 3911304 | 2022-08-11 | US | Virginia | Alleghany | 51005 | 3806 | 102 | 0 | 37.78636074 | -80.00222498 | 2022-08-12 04:20:54 | Alleghany, Virginia, US | |
1085861 | 1085861 | 2022-08-09 | China | Fujian | 3806 | 1 | 0 | 26.0789 | 117.9874 | 2022-08-10 04:20:57 | Fujian, China | |||
2338929 | 2338929 | 2022-07-27 | US | Wisconsin | Buffalo | 55011 | 3806 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-07-28 04:20:56 | Buffalo, Wisconsin, US | |
899560 | 899560 | 2022-07-24 | US | Virginia | Southampton | 51175 | 3806 | 96 | 0 | 36.72231125 | -77.10642712 | 2022-07-25 04:20:51 | Southampton, Virginia, US | |
94554 | 94554 | 2022-07-23 | US | Virginia | Southampton | 51175 | 3806 | 96 | 0 | 36.72231125 | -77.10642712 | 2022-07-24 04:20:47 | Southampton, Virginia, US | |
903576 | 903576 | 2022-07-22 | US | Virginia | Southampton | 51175 | 3806 | 96 | 0 | 36.72231125 | -77.10642712 | 2022-07-23 04:20:53 | Southampton, Virginia, US | |
900788 | 900788 | 2022-07-22 | US | Colorado | Grand | 8049 | 3806 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-07-23 04:20:53 | Grand, Colorado, US | |
3212106 | 3212106 | 2022-07-18 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-19 04:20:58 | Lawrence, Mississippi, US | |
3407281 | 3407281 | 2022-07-17 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-18 04:20:59 | Lawrence, Mississippi, US | |
2153481 | 2153481 | 2022-07-16 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-17 04:21:15 | Lawrence, Mississippi, US | |
2420714 | 2420714 | 2022-07-15 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-16 04:21:05 | Lawrence, Mississippi, US | |
3430789 | 3430789 | 2022-07-14 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-15 04:20:53 | Lawrence, Mississippi, US | |
3111309 | 3111309 | 2022-07-13 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-14 04:20:57 | Lawrence, Mississippi, US | |
631732 | 631732 | 2022-07-12 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-13 04:20:58 | Lawrence, Mississippi, US | |
1213755 | 1213755 | 2022-07-11 | US | New Mexico | Los Alamos | 35028 | 3806 | 17 | 0 | 35.86631386 | -106.3134985 | 2022-07-12 04:20:51 | Los Alamos, New Mexico, US | |
1213376 | 1213376 | 2022-07-11 | US | Mississippi | Lawrence | 28077 | 3806 | 56 | 0 | 31.55147224 | -90.10841127 | 2022-07-12 04:20:51 | Lawrence, Mississippi, US | |
3078697 | 3078697 | 2022-07-04 | US | Colorado | Las Animas | 8071 | 3806 | 44 | 0 | 37.3153406 | -104.0376458 | 2022-07-05 04:20:45 | Las Animas, Colorado, US | |
2188107 | 2188107 | 2022-06-22 | US | Arkansas | Howard | 5061 | 3806 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-06-23 04:20:55 | Howard, Arkansas, US | |
166538 | 166538 | 2022-06-21 | US | Arkansas | Howard | 5061 | 3806 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-06-22 04:20:54 | Howard, Arkansas, US | |
950015 | 950015 | 2022-06-14 | US | Texas | Madison | 48313 | 3806 | 56 | 0 | 30.96694679 | -95.93003775 | 2022-06-15 04:20:54 | Madison, Texas, US | |
2236512 | 2236512 | 2022-06-12 | US | Indiana | Pike | 18125 | 3806 | 50 | 0 | 38.40112197 | -87.23574907 | 2022-06-13 04:21:14 | Pike, Indiana, US | |
3143866 | 3143866 | 2022-06-11 | US | New York | Yates | 36123 | 3806 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-06-12 04:20:53 | Yates, New York, US | |
3142710 | 3142710 | 2022-06-11 | US | Indiana | Pike | 18125 | 3806 | 50 | 0 | 38.40112197 | -87.23574907 | 2022-06-12 04:20:53 | Pike, Indiana, US | |
1945626 | 1945626 | 2022-06-10 | US | Indiana | Pike | 18125 | 3806 | 50 | 0 | 38.40112197 | -87.23574907 | 2022-06-11 04:21:01 | Pike, Indiana, US | |
3447899 | 3447899 | 2022-05-11 | US | Texas | Colorado | 48089 | 3806 | 64 | 0 | 29.622098 | -96.5273805 | 2022-05-12 04:20:54 | Colorado, Texas, US | |
3538516 | 3538516 | 2022-05-10 | US | Texas | Colorado | 48089 | 3806 | 64 | 0 | 29.622098 | -96.5273805 | 2022-05-11 04:20:48 | Colorado, Texas, US | |
225051 | 225051 | 2022-05-09 | US | Texas | Colorado | 48089 | 3806 | 64 | 0 | 29.622098 | -96.5273805 | 2022-05-10 04:20:50 | Colorado, Texas, US | |
2334436 | 2334436 | 2022-05-08 | US | Texas | Colorado | 48089 | 3806 | 64 | 0 | 29.622098 | -96.5273805 | 2022-05-09 04:20:54 | Colorado, Texas, US | |
2601351 | 2601351 | 2022-05-05 | US | Virginia | Appomattox | 51011 | 3806 | 53 | 0 | 37.37569884 | -78.81340003 | 2022-05-06 04:21:00 | Appomattox, Virginia, US | |
1952078 | 1952078 | 2022-04-12 | US | Wisconsin | Marquette | 55077 | 3806 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-04-13 04:21:03 | Marquette, Wisconsin, US | |
3209831 | 3209831 | 2022-04-11 | US | Wisconsin | Marquette | 55077 | 3806 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-04-12 04:20:49 | Marquette, Wisconsin, US | |
3320726 | 3320726 | 2022-04-07 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-08 04:20:48 | Franklin, Arkansas, US | |
2804341 | 2804341 | 2022-04-06 | US | Wisconsin | Marquette | 55077 | 3806 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-04-07 04:20:53 | Marquette, Wisconsin, US | |
2801262 | 2801262 | 2022-04-06 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-07 04:20:53 | Franklin, Arkansas, US | |
3871110 | 3871110 | 2022-04-05 | US | Wisconsin | Marquette | 55077 | 3806 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-04-06 04:20:49 | Marquette, Wisconsin, US | |
3868031 | 3868031 | 2022-04-05 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-06 04:20:49 | Franklin, Arkansas, US | |
2752452 | 2752452 | 2022-04-04 | US | Wisconsin | Marquette | 55077 | 3806 | 60 | 0 | 43.81911946 | -89.40073763 | 2022-04-05 04:20:48 | Marquette, Wisconsin, US | |
2749373 | 2749373 | 2022-04-04 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-05 04:20:48 | Franklin, Arkansas, US | |
3730719 | 3730719 | 2022-04-03 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-04 04:20:51 | Franklin, Arkansas, US | |
500154 | 500154 | 2022-04-02 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-03 04:20:48 | Franklin, Arkansas, US | |
3351139 | 3351139 | 2022-04-01 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-02 04:20:47 | Franklin, Arkansas, US | |
1540444 | 1540444 | 2022-03-31 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-04-01 04:20:28 | Franklin, Arkansas, US | |
2478457 | 2478457 | 2022-03-30 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-03-31 04:20:56 | Franklin, Arkansas, US | |
159267 | 159267 | 2022-03-29 | US | Iowa | Winneshiek | 19191 | 3806 | 48 | 0 | 43.29094334 | -91.84422722 | 2022-03-30 04:20:45 | Winneshiek, Iowa, US | |
158498 | 158498 | 2022-03-29 | US | Arkansas | Franklin | 5047 | 3806 | 72 | 0 | 35.51202821 | -93.89299569 | 2022-03-30 04:20:45 | Franklin, Arkansas, US | |
1437838 | 1437838 | 2022-03-28 | US | Iowa | Winneshiek | 19191 | 3806 | 48 | 0 | 43.29094334 | -91.84422722 | 2022-03-29 04:20:46 | Winneshiek, Iowa, US | |
877519 | 877519 | 2022-03-27 | US | Iowa | Winneshiek | 19191 | 3806 | 48 | 0 | 43.29094334 | -91.84422722 | 2022-03-28 04:20:33 | Winneshiek, Iowa, US | |
2164802 | 2164802 | 2022-03-26 | US | Iowa | Winneshiek | 19191 | 3806 | 48 | 0 | 43.29094334 | -91.84422722 | 2022-03-27 04:20:47 | Winneshiek, Iowa, US | |
1721738 | 1721738 | 2022-03-25 | US | Iowa | Winneshiek | 19191 | 3806 | 48 | 0 | 43.29094334 | -91.84422722 | 2022-03-26 04:20:23 | Winneshiek, Iowa, US | |
1469355 | 1469355 | 2022-03-24 | US | Iowa | Winneshiek | 19191 | 3806 | 48 | 0 | 43.29094334 | -91.84422722 | 2022-03-25 04:20:46 | Winneshiek, Iowa, US | |
3023529 | 3023529 | 2022-03-23 | US | Iowa | Winneshiek | 19191 | 3806 | 48 | 0 | 43.29094334 | -91.84422722 | 2022-03-24 04:20:43 | Winneshiek, Iowa, US | |
3631536 | 3631536 | 2022-03-13 | US | Wisconsin | Richland | 55103 | 3806 | 45 | 0 | 43.3762778 | -90.43012729 | 2022-03-14 04:20:46 | Richland, Wisconsin, US | |
954444 | 954444 | 2022-03-12 | US | Wisconsin | Richland | 55103 | 3806 | 45 | 0 | 43.3762778 | -90.43012729 | 2022-03-13 04:20:49 | Richland, Wisconsin, US | |
359905 | 359905 | 2022-03-11 | US | Wisconsin | Richland | 55103 | 3806 | 45 | 0 | 43.3762778 | -90.43012729 | 2022-03-12 04:20:50 | Richland, Wisconsin, US | |
3823786 | 3823786 | 2022-02-16 | US | Virginia | Grayson | 51077 | 3806 | 74 | 0 | 36.65677234 | -81.23215889 | 2022-02-17 04:20:56 | Grayson, Virginia, US | |
3822198 | 3822198 | 2022-02-16 | US | Minnesota | Redwood | 27127 | 3806 | 52 | 0 | 44.40555844 | -95.25207021 | 2022-02-17 04:20:56 | Redwood, Minnesota, US | |
3674744 | 3674744 | 2022-02-15 | US | Texas | Freestone | 48161 | 3806 | 81 | 0 | 31.70422788 | -96.15072516 | 2022-02-16 04:21:10 | Freestone, Texas, US | |
2327171 | 2327171 | 2022-02-04 | China | Shanghai | 3806 | 7 | 0 | 31.201999999999998 | 121.4491 | 2022-02-05 04:21:05 | Shanghai, China | |||
3062229 | 3062229 | 2022-01-29 | Russia | Nenets Autonomous Okrug | 3806 | 90 | 0 | 68.27557185 | 57.1686375 | 2022-01-30 04:21:26 | Nenets Autonomous Okrug, Russia | |||
3229605 | 3229605 | 2022-01-19 | US | Texas | Lavaca | 48285 | 3806 | 101 | 0 | 29.38508402 | -96.93186692 | 2022-01-20 04:21:07 | Lavaca, Texas, US | |
3464720 | 3464720 | 2022-01-18 | US | California | Colusa | 6011 | 3806 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-01-19 04:21:23 | Colusa, California, US | |
129870 | 129870 | 2022-01-09 | US | Texas | Jones | 48253 | 3806 | 81 | 0 | 32.73997145 | -99.87861576 | 2022-01-10 04:22:07 | Jones, Texas, US | |
2115114 | 2115114 | 2021-12-26 | US | Virginia | Staunton | 51790 | 3806 | 86 | 0 | 38.15965544 | -79.05979937 | 2021-12-27 04:21:58 | Staunton, Virginia, US | |
3608486 | 3608486 | 2021-12-25 | US | Virginia | Staunton | 51790 | 3806 | 86 | 0 | 38.15965544 | -79.05979937 | 2021-12-26 04:21:50 | Staunton, Virginia, US | |
2966804 | 2966804 | 2021-12-24 | US | Virginia | Staunton | 51790 | 3806 | 86 | 0 | 38.15965544 | -79.05979937 | 2021-12-25 04:21:37 | Staunton, 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]);