johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
241 rows where confirmed = 5028 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1077184 | 1077184 | 2022-12-28 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-29 04:21:01 | San Juan, Utah, US | |
331199 | 331199 | 2022-12-27 | US | Vermont | Orange | 50017 | 5028 | 15 | 0 | 44.00470222 | -72.37640104 | 2022-12-28 04:21:04 | Orange, Vermont, US | |
331181 | 331181 | 2022-12-27 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-28 04:21:04 | San Juan, Utah, US | |
221272 | 221272 | 2022-12-26 | US | Vermont | Orange | 50017 | 5028 | 15 | 0 | 44.00470222 | -72.37640104 | 2022-12-27 04:21:07 | Orange, Vermont, US | |
221254 | 221254 | 2022-12-26 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-27 04:21:07 | San Juan, Utah, US | |
3225729 | 3225729 | 2022-12-25 | US | Vermont | Orange | 50017 | 5028 | 15 | 0 | 44.00470222 | -72.37640104 | 2022-12-26 04:21:06 | Orange, Vermont, US | |
3225711 | 3225711 | 2022-12-25 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-26 04:21:06 | San Juan, Utah, US | |
1021643 | 1021643 | 2022-12-24 | US | Vermont | Orange | 50017 | 5028 | 15 | 0 | 44.00470222 | -72.37640104 | 2022-12-25 04:21:04 | Orange, Vermont, US | |
1021625 | 1021625 | 2022-12-24 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-25 04:21:04 | San Juan, Utah, US | |
693666 | 693666 | 2022-12-23 | US | Vermont | Orange | 50017 | 5028 | 15 | 0 | 44.00470222 | -72.37640104 | 2022-12-24 04:21:02 | Orange, Vermont, US | |
693648 | 693648 | 2022-12-23 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-24 04:21:02 | San Juan, Utah, US | |
2182876 | 2182876 | 2022-12-22 | US | Vermont | Orange | 50017 | 5028 | 15 | 0 | 44.00470222 | -72.37640104 | 2022-12-23 04:21:04 | Orange, Vermont, US | |
2182858 | 2182858 | 2022-12-22 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-23 04:21:04 | San Juan, Utah, US | |
454680 | 454680 | 2022-12-21 | US | Vermont | Orange | 50017 | 5028 | 15 | 0 | 44.00470222 | -72.37640104 | 2022-12-22 04:20:56 | Orange, Vermont, US | |
544790 | 544790 | 2022-12-15 | US | Montana | Park | 30067 | 5028 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-12-16 04:21:01 | Park, Montana, US | |
350318 | 350318 | 2022-12-14 | US | Montana | Park | 30067 | 5028 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-12-15 04:20:58 | Park, Montana, US | |
309906 | 309906 | 2022-12-13 | US | Montana | Park | 30067 | 5028 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-12-14 04:21:04 | Park, Montana, US | |
3717095 | 3717095 | 2022-12-06 | US | Tennessee | Cannon | 47015 | 5028 | 75 | 0 | 35.80990797 | -86.05738983 | 2022-12-07 04:20:58 | Cannon, Tennessee, US | |
3715262 | 3715262 | 2022-12-06 | US | Indiana | Franklin | 18047 | 5028 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-07 04:20:58 | Franklin, Indiana, US | |
2417800 | 2417800 | 2022-12-05 | US | Tennessee | Cannon | 47015 | 5028 | 75 | 0 | 35.80990797 | -86.05738983 | 2022-12-06 04:21:03 | Cannon, Tennessee, US | |
2415967 | 2415967 | 2022-12-05 | US | Indiana | Franklin | 18047 | 5028 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-06 04:21:03 | Franklin, Indiana, US | |
719575 | 719575 | 2022-12-04 | US | Indiana | Franklin | 18047 | 5028 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-05 04:20:58 | Franklin, Indiana, US | |
2817864 | 2817864 | 2022-12-03 | US | Indiana | Franklin | 18047 | 5028 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-04 04:20:56 | Franklin, Indiana, US | |
834720 | 834720 | 2022-12-02 | US | Indiana | Franklin | 18047 | 5028 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-03 04:21:02 | Franklin, Indiana, US | |
2137250 | 2137250 | 2022-12-01 | US | Indiana | Franklin | 18047 | 5028 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-02 04:21:07 | Franklin, Indiana, US | |
1965666 | 1965666 | 2022-11-30 | US | Indiana | Franklin | 18047 | 5028 | 69 | 0 | 39.4142482 | -85.06062647 | 2022-12-01 04:21:03 | Franklin, Indiana, US | |
2064396 | 2064396 | 2022-11-19 | US | Arkansas | Grant | 5053 | 5028 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-11-20 04:21:08 | Grant, Arkansas, US | |
1755790 | 1755790 | 2022-11-18 | US | Arkansas | Grant | 5053 | 5028 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-11-19 04:21:14 | Grant, Arkansas, US | |
2929978 | 2929978 | 2022-11-11 | US | Puerto Rico | Jayuya | 72073 | 5028 | 0 | 0 | 18.211446 | -66.58878 | 2022-11-12 04:20:41 | Jayuya, Puerto Rico, US | |
3251146 | 3251146 | 2022-10-11 | US | Illinois | Hancock | 17067 | 5028 | 50 | 0 | 40.40423981 | -91.16313899 | 2022-10-12 04:22:51 | Hancock, Illinois, US | |
133045 | 133045 | 2022-10-04 | US | North Carolina | Bertie | 37015 | 5028 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-05 04:23:06 | Bertie, North Carolina, US | |
131618 | 131618 | 2022-10-04 | US | Georgia | Putnam | 13237 | 5028 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-05 04:23:06 | Putnam, Georgia, US | |
2687992 | 2687992 | 2022-10-03 | US | North Carolina | Bertie | 37015 | 5028 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-04 04:22:55 | Bertie, North Carolina, US | |
2686565 | 2686565 | 2022-10-03 | US | Georgia | Putnam | 13237 | 5028 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-04 04:22:55 | Putnam, Georgia, US | |
2262059 | 2262059 | 2022-10-02 | US | North Carolina | Bertie | 37015 | 5028 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-03 04:23:11 | Bertie, North Carolina, US | |
2260632 | 2260632 | 2022-10-02 | US | Georgia | Putnam | 13237 | 5028 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-03 04:23:11 | Putnam, Georgia, US | |
2997585 | 2997585 | 2022-10-01 | US | North Carolina | Bertie | 37015 | 5028 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-02 04:21:23 | Bertie, North Carolina, US | |
2996158 | 2996158 | 2022-10-01 | US | Georgia | Putnam | 13237 | 5028 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-02 04:21:23 | Putnam, Georgia, US | |
855911 | 855911 | 2022-09-30 | US | North Carolina | Bertie | 37015 | 5028 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-10-01 04:23:01 | Bertie, North Carolina, US | |
854484 | 854484 | 2022-09-30 | US | Georgia | Putnam | 13237 | 5028 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-10-01 04:23:01 | Putnam, Georgia, US | |
2377837 | 2377837 | 2022-09-29 | US | North Carolina | Bertie | 37015 | 5028 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-30 04:23:09 | Bertie, North Carolina, US | |
2377420 | 2377420 | 2022-09-29 | US | Missouri | Benton | 29015 | 5028 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-09-30 04:23:09 | Benton, Missouri, US | |
2376410 | 2376410 | 2022-09-29 | US | Georgia | Putnam | 13237 | 5028 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-09-30 04:23:09 | Putnam, Georgia, US | |
1562388 | 1562388 | 2022-09-28 | US | North Carolina | Bertie | 37015 | 5028 | 75 | 0 | 36.0688473 | -76.96545943 | 2022-09-29 04:22:34 | Bertie, North Carolina, US | |
1561971 | 1561971 | 2022-09-28 | US | Missouri | Benton | 29015 | 5028 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-09-29 04:22:34 | Benton, Missouri, US | |
1560961 | 1560961 | 2022-09-28 | US | Georgia | Putnam | 13237 | 5028 | 111 | 0 | 33.32056115 | -83.37552891 | 2022-09-29 04:22:34 | Putnam, Georgia, US | |
3996514 | 3996514 | 2022-09-27 | US | Missouri | Benton | 29015 | 5028 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-09-28 04:23:01 | Benton, Missouri, US | |
2770842 | 2770842 | 2022-09-26 | US | Missouri | Benton | 29015 | 5028 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-09-27 04:23:01 | Benton, Missouri, US | |
1978495 | 1978495 | 2022-09-25 | US | Missouri | Benton | 29015 | 5028 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-09-26 04:20:52 | Benton, Missouri, US | |
2651662 | 2651662 | 2022-09-24 | US | Missouri | Benton | 29015 | 5028 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-09-25 04:23:31 | Benton, Missouri, US | |
386102 | 386102 | 2022-09-23 | US | Missouri | Benton | 29015 | 5028 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-09-24 04:21:40 | Benton, Missouri, US | |
3776756 | 3776756 | 2022-08-30 | US | South Dakota | Beadle | 46005 | 5028 | 62 | 0 | 44.41464384 | -98.27858469 | 2022-08-31 04:20:57 | Beadle, South Dakota, US | |
1683352 | 1683352 | 2022-08-29 | US | South Dakota | Beadle | 46005 | 5028 | 62 | 0 | 44.41464384 | -98.27858469 | 2022-08-30 04:21:03 | Beadle, South Dakota, US | |
1879836 | 1879836 | 2022-08-28 | US | South Dakota | Beadle | 46005 | 5028 | 62 | 0 | 44.41464384 | -98.27858469 | 2022-08-29 04:21:06 | Beadle, South Dakota, US | |
2098963 | 2098963 | 2022-08-27 | US | South Dakota | Beadle | 46005 | 5028 | 62 | 0 | 44.41464384 | -98.27858469 | 2022-08-28 04:21:02 | Beadle, South Dakota, US | |
1534778 | 1534778 | 2022-08-26 | US | South Dakota | Beadle | 46005 | 5028 | 62 | 0 | 44.41464384 | -98.27858469 | 2022-08-27 04:20:57 | Beadle, South Dakota, US | |
2831665 | 2831665 | 2022-08-25 | US | South Dakota | Beadle | 46005 | 5028 | 62 | 0 | 44.41464384 | -98.27858469 | 2022-08-26 04:21:02 | Beadle, South Dakota, US | |
2326198 | 2326198 | 2022-08-24 | US | South Dakota | Beadle | 46005 | 5028 | 62 | 0 | 44.41464384 | -98.27858469 | 2022-08-25 04:21:13 | Beadle, South Dakota, US | |
2853898 | 2853898 | 2022-08-22 | US | Illinois | Piatt | 17147 | 5028 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-08-23 04:20:56 | Piatt, Illinois, US | |
1072994 | 1072994 | 2022-08-07 | US | Texas | Gonzales | 48177 | 5028 | 103 | 0 | 29.45634206 | -97.49424032 | 2022-08-08 04:21:08 | Gonzales, Texas, US | |
1943582 | 1943582 | 2022-08-06 | US | Texas | Gonzales | 48177 | 5028 | 103 | 0 | 29.45634206 | -97.49424032 | 2022-08-07 04:20:54 | Gonzales, Texas, US | |
883381 | 883381 | 2022-08-05 | US | Texas | Gonzales | 48177 | 5028 | 103 | 0 | 29.45634206 | -97.49424032 | 2022-08-06 04:20:56 | Gonzales, Texas, US | |
1490572 | 1490572 | 2022-07-26 | US | Tennessee | Polk | 47139 | 5028 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-07-27 04:21:04 | Polk, Tennessee, US | |
3213369 | 3213369 | 2022-07-18 | US | Texas | Fayette | 48149 | 5028 | 109 | 0 | 29.87788372 | -96.92076062 | 2022-07-19 04:20:58 | Fayette, Texas, US | |
1770931 | 1770931 | 2022-07-03 | US | Wisconsin | Taylor | 55119 | 5028 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-07-04 04:20:54 | Taylor, Wisconsin, US | |
1770656 | 1770656 | 2022-07-03 | US | Virginia | Buchanan | 51027 | 5028 | 126 | 0 | 37.26818323 | -82.03749726 | 2022-07-04 04:20:54 | Buchanan, Virginia, US | |
3368917 | 3368917 | 2022-07-02 | US | Wisconsin | Taylor | 55119 | 5028 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-07-03 04:20:59 | Taylor, Wisconsin, US | |
3368642 | 3368642 | 2022-07-02 | US | Virginia | Buchanan | 51027 | 5028 | 126 | 0 | 37.26818323 | -82.03749726 | 2022-07-03 04:20:59 | Buchanan, Virginia, US | |
597246 | 597246 | 2022-07-01 | US | Wisconsin | Taylor | 55119 | 5028 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-07-02 04:21:16 | Taylor, Wisconsin, US | |
596971 | 596971 | 2022-07-01 | US | Virginia | Buchanan | 51027 | 5028 | 126 | 0 | 37.26818323 | -82.03749726 | 2022-07-02 04:21:16 | Buchanan, Virginia, US | |
2148615 | 2148615 | 2022-06-27 | US | Illinois | Clark | 17023 | 5028 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-06-28 04:20:58 | Clark, Illinois, US | |
948022 | 948022 | 2022-06-14 | US | Iowa | Carroll | 19027 | 5028 | 66 | 0 | 42.03617207 | -94.86032705 | 2022-06-15 04:20:54 | Carroll, Iowa, US | |
2980430 | 2980430 | 2022-06-13 | US | Iowa | Carroll | 19027 | 5028 | 66 | 0 | 42.03617207 | -94.86032705 | 2022-06-14 04:20:52 | Carroll, Iowa, US | |
2236556 | 2236556 | 2022-06-12 | US | Iowa | Carroll | 19027 | 5028 | 66 | 0 | 42.03617207 | -94.86032705 | 2022-06-13 04:21:14 | Carroll, Iowa, US | |
2235991 | 2235991 | 2022-06-12 | US | Colorado | Chaffee | 8015 | 5028 | 48 | 0 | 38.74745778 | -106.1926573 | 2022-06-13 04:21:14 | Chaffee, Colorado, US | |
3142754 | 3142754 | 2022-06-11 | US | Iowa | Carroll | 19027 | 5028 | 66 | 0 | 42.03617207 | -94.86032705 | 2022-06-12 04:20:53 | Carroll, Iowa, US | |
1945670 | 1945670 | 2022-06-10 | US | Iowa | Carroll | 19027 | 5028 | 66 | 0 | 42.03617207 | -94.86032705 | 2022-06-11 04:21:01 | Carroll, Iowa, US | |
3160367 | 3160367 | 2022-06-09 | US | Puerto Rico | Catano | 72033 | 5028 | 0 | 0 | 18.437269 | -66.143306 | 2022-06-10 04:20:55 | Catano, Puerto Rico, US | |
3158809 | 3158809 | 2022-06-09 | US | Iowa | Carroll | 19027 | 5028 | 66 | 0 | 42.03617207 | -94.86032705 | 2022-06-10 04:20:55 | Carroll, Iowa, US | |
1422276 | 1422276 | 2022-06-08 | US | Iowa | Carroll | 19027 | 5028 | 66 | 0 | 42.03617207 | -94.86032705 | 2022-06-09 04:20:54 | Carroll, Iowa, US | |
3509204 | 3509204 | 2022-06-05 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-06-06 04:20:57 | Jasper, Mississippi, US | |
3529281 | 3529281 | 2022-06-04 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-06-05 04:20:55 | Jasper, Mississippi, US | |
3135367 | 3135367 | 2022-06-03 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-06-04 04:20:58 | Jasper, Mississippi, US | |
3580442 | 3580442 | 2022-06-02 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-06-03 04:20:58 | Jasper, Mississippi, US | |
972735 | 972735 | 2022-06-01 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-06-02 05:20:39 | Jasper, Mississippi, US | |
231042 | 231042 | 2022-05-31 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-06-01 04:20:55 | Jasper, Mississippi, US | |
3187807 | 3187807 | 2022-05-30 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-31 04:20:51 | Jasper, Mississippi, US | |
3199956 | 3199956 | 2022-05-29 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-30 04:20:50 | Jasper, Mississippi, US | |
2726834 | 2726834 | 2022-05-28 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-29 04:20:53 | Jasper, Mississippi, US | |
1316015 | 1316015 | 2022-05-27 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-28 04:21:07 | Jasper, Mississippi, US | |
1851807 | 1851807 | 2022-05-26 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-27 04:20:56 | Jasper, Mississippi, US | |
2049683 | 2049683 | 2022-05-25 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-26 04:20:50 | Jasper, Mississippi, US | |
3001121 | 3001121 | 2022-05-24 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-25 04:20:56 | Jasper, Mississippi, US | |
3596351 | 3596351 | 2022-05-23 | US | Virginia | Colonial Heights | 51570 | 5028 | 97 | 0 | 37.26420587 | -77.39609676 | 2022-05-24 04:20:57 | Colonial Heights, Virginia, US | |
3594842 | 3594842 | 2022-05-23 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-24 04:20:57 | Jasper, Mississippi, US | |
623694 | 623694 | 2022-05-22 | US | Mississippi | Jasper | 28061 | 5028 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-26 04:20:50 | Jasper, Mississippi, US | |
1110235 | 1110235 | 2022-05-21 | US | Colorado | Teller | 8119 | 5028 | 58 | 0 | 38.88133511 | -105.1614893 | 2022-05-22 04:20:52 | Teller, Colorado, US | |
3584852 | 3584852 | 2022-05-17 | US | New Mexico | Roosevelt | 35041 | 5028 | 97 | 0 | 34.02097406 | -103.4799493 | 2022-05-18 04:20:50 | Roosevelt, New Mexico, US | |
658934 | 658934 | 2022-05-13 | US | Colorado | Elbert | 8039 | 5028 | 40 | 0 | 39.28656773 | -104.1358721 | 2022-05-14 04:20:48 | Elbert, Colorado, US | |
2535337 | 2535337 | 2022-05-12 | US | Missouri | New Madrid | 29143 | 5028 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-05-13 04:20:51 | New Madrid, Missouri, 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]);