johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
377 rows where confirmed = 1607 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
292971 | 292971 | 2022-11-15 | US | Idaho | Power | 16077 | 1607 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-11-16 04:21:09 | Power, Idaho, US | |
3598001 | 3598001 | 2022-11-14 | US | Idaho | Power | 16077 | 1607 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-11-15 04:21:16 | Power, Idaho, US | |
312859 | 312859 | 2022-11-13 | US | Idaho | Power | 16077 | 1607 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-11-14 04:21:09 | Power, Idaho, US | |
64020 | 64020 | 2022-11-12 | US | Idaho | Power | 16077 | 1607 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-11-13 04:21:14 | Power, Idaho, US | |
2928182 | 2928182 | 2022-11-11 | US | Idaho | Power | 16077 | 1607 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-11-12 04:20:41 | Power, Idaho, US | |
2507018 | 2507018 | 2022-11-10 | US | Idaho | Power | 16077 | 1607 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-11-11 04:21:22 | Power, Idaho, US | |
2431893 | 2431893 | 2022-11-09 | US | Idaho | Power | 16077 | 1607 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-11-10 04:21:16 | Power, Idaho, US | |
2159345 | 2159345 | 2022-10-16 | China | Xinjiang | 1607 | 3 | 0 | 41.1129 | 85.2401 | 2022-10-17 04:20:31 | Xinjiang, China | |||
3754408 | 3754408 | 2022-10-13 | US | Idaho | Caribou | 16029 | 1607 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-10-14 04:22:28 | Caribou, Idaho, US | |
3215233 | 3215233 | 2022-10-12 | US | Idaho | Caribou | 16029 | 1607 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-10-13 04:22:39 | Caribou, Idaho, US | |
2687379 | 2687379 | 2022-10-03 | US | Michigan | Oscoda | 26135 | 1607 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-10-04 04:22:55 | Oscoda, Michigan, US | |
2261446 | 2261446 | 2022-10-02 | US | Michigan | Oscoda | 26135 | 1607 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-10-03 04:23:11 | Oscoda, Michigan, US | |
2996972 | 2996972 | 2022-10-01 | US | Michigan | Oscoda | 26135 | 1607 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-10-02 04:21:23 | Oscoda, Michigan, US | |
855298 | 855298 | 2022-09-30 | US | Michigan | Oscoda | 26135 | 1607 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-10-01 04:23:01 | Oscoda, Michigan, US | |
2377224 | 2377224 | 2022-09-29 | US | Michigan | Oscoda | 26135 | 1607 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-09-30 04:23:09 | Oscoda, Michigan, US | |
1562886 | 1562886 | 2022-09-28 | US | Puerto Rico | Vieques | 72147 | 1607 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-29 04:22:34 | Vieques, Puerto Rico, US | |
1561775 | 1561775 | 2022-09-28 | US | Michigan | Oscoda | 26135 | 1607 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-09-29 04:22:34 | Oscoda, Michigan, US | |
3996318 | 3996318 | 2022-09-27 | US | Michigan | Oscoda | 26135 | 1607 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-09-28 04:23:01 | Oscoda, Michigan, US | |
3769051 | 3769051 | 2022-09-11 | US | Texas | McCulloch | 48307 | 1607 | 48 | 0 | 31.1925468 | -99.34682807 | 2022-09-12 04:20:58 | McCulloch, Texas, US | |
3827626 | 3827626 | 2022-09-10 | US | Texas | McCulloch | 48307 | 1607 | 48 | 0 | 31.1925468 | -99.34682807 | 2022-09-11 04:20:50 | McCulloch, Texas, US | |
966083 | 966083 | 2022-09-09 | US | Texas | McCulloch | 48307 | 1607 | 48 | 0 | 31.1925468 | -99.34682807 | 2022-09-10 04:21:10 | McCulloch, Texas, US | |
2325071 | 2325071 | 2022-08-24 | US | Minnesota | Grant | 27051 | 1607 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-08-25 04:21:13 | Grant, Minnesota, US | |
1252480 | 1252480 | 2022-08-23 | US | Minnesota | Grant | 27051 | 1607 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-08-24 04:20:46 | Grant, Minnesota, US | |
2854584 | 2854584 | 2022-08-22 | US | Minnesota | Grant | 27051 | 1607 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-08-23 04:20:56 | Grant, Minnesota, US | |
2404556 | 2404556 | 2022-08-21 | US | Minnesota | Grant | 27051 | 1607 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-08-22 04:20:38 | Grant, Minnesota, US | |
3799634 | 3799634 | 2022-08-20 | US | Minnesota | Grant | 27051 | 1607 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-08-21 04:20:44 | Grant, Minnesota, US | |
2365220 | 2365220 | 2022-08-19 | US | Minnesota | Grant | 27051 | 1607 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-08-20 04:21:01 | Grant, Minnesota, US | |
1162891 | 1162891 | 2022-08-18 | US | Minnesota | Grant | 27051 | 1607 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-08-19 04:20:54 | Grant, Minnesota, US | |
3953818 | 3953818 | 2022-08-17 | US | Virginia | Covington | 51580 | 1607 | 28 | 0 | 37.7824656 | -79.98631446 | 2022-08-18 04:21:11 | Covington, Virginia, US | |
2497198 | 2497198 | 2022-08-15 | US | Texas | Lynn | 48305 | 1607 | 39 | 0 | 33.17657705 | -101.8162849 | 2022-08-16 04:20:58 | Lynn, Texas, US | |
1089628 | 1089628 | 2022-08-09 | US | Wisconsin | Iron | 55051 | 1607 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-08-10 04:20:57 | Iron, Wisconsin, US | |
1068300 | 1068300 | 2022-07-28 | US | North Dakota | Ransom | 38073 | 1607 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-07-29 04:20:45 | Ransom, North Dakota, US | |
1608890 | 1608890 | 2022-07-20 | US | Colorado | Huerfano | 8055 | 1607 | 38 | 0 | 37.68473101 | -104.9612585 | 2022-07-21 04:21:10 | Huerfano, Colorado, US | |
630877 | 630877 | 2022-07-12 | US | Illinois | Calhoun | 17013 | 1607 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-07-13 04:20:58 | Calhoun, Illinois, US | |
3966987 | 3966987 | 2022-07-05 | US | Alaska | Prince of Wales-Hyder | 2198 | 1607 | 8 | 0 | 55.76261984 | -133.0511621 | 2022-07-06 04:20:58 | Prince of Wales-Hyder, Alaska, US | |
3078498 | 3078498 | 2022-07-04 | US | Alaska | Prince of Wales-Hyder | 2198 | 1607 | 8 | 0 | 55.76261984 | -133.0511621 | 2022-07-05 04:20:45 | Prince of Wales-Hyder, Alaska, US | |
1767780 | 1767780 | 2022-07-03 | US | Alaska | Prince of Wales-Hyder | 2198 | 1607 | 8 | 0 | 55.76261984 | -133.0511621 | 2022-07-04 04:20:54 | Prince of Wales-Hyder, Alaska, US | |
3365766 | 3365766 | 2022-07-02 | US | Alaska | Prince of Wales-Hyder | 2198 | 1607 | 8 | 0 | 55.76261984 | -133.0511621 | 2022-07-03 04:20:59 | Prince of Wales-Hyder, Alaska, US | |
594095 | 594095 | 2022-07-01 | US | Alaska | Prince of Wales-Hyder | 2198 | 1607 | 8 | 0 | 55.76261984 | -133.0511621 | 2022-07-02 04:21:16 | Prince of Wales-Hyder, Alaska, US | |
3940496 | 3940496 | 2022-06-30 | US | Alaska | Prince of Wales-Hyder | 2198 | 1607 | 8 | 0 | 55.76261984 | -133.0511621 | 2022-07-01 04:21:10 | Prince of Wales-Hyder, Alaska, US | |
2490454 | 2490454 | 2022-06-29 | US | Alaska | Prince of Wales-Hyder | 2198 | 1607 | 8 | 0 | 55.76261984 | -133.0511621 | 2022-06-30 04:21:01 | Prince of Wales-Hyder, Alaska, US | |
947667 | 947667 | 2022-06-14 | US | Georgia | Hancock | 13141 | 1607 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-06-15 04:20:54 | Hancock, Georgia, US | |
2980075 | 2980075 | 2022-06-13 | US | Georgia | Hancock | 13141 | 1607 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-06-14 04:20:52 | Hancock, Georgia, US | |
2236201 | 2236201 | 2022-06-12 | US | Georgia | Hancock | 13141 | 1607 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-06-13 04:21:14 | Hancock, Georgia, US | |
3142399 | 3142399 | 2022-06-11 | US | Georgia | Hancock | 13141 | 1607 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-06-12 04:20:53 | Hancock, Georgia, US | |
1945315 | 1945315 | 2022-06-10 | US | Georgia | Hancock | 13141 | 1607 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-06-11 04:21:01 | Hancock, Georgia, US | |
3158454 | 3158454 | 2022-06-09 | US | Georgia | Hancock | 13141 | 1607 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-06-10 04:20:55 | Hancock, Georgia, US | |
1421921 | 1421921 | 2022-06-08 | US | Georgia | Hancock | 13141 | 1607 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-06-09 04:20:54 | Hancock, Georgia, US | |
2533186 | 2533186 | 2022-05-12 | China | Guangxi | 1607 | 2 | 0 | 23.8298 | 108.7881 | 2022-05-13 04:20:51 | Guangxi, China | |||
3536694 | 3536694 | 2022-05-10 | US | Iowa | Pocahontas | 19151 | 1607 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-11 04:20:48 | Pocahontas, Iowa, US | |
223229 | 223229 | 2022-05-09 | US | Iowa | Pocahontas | 19151 | 1607 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-10 04:20:50 | Pocahontas, Iowa, US | |
2332614 | 2332614 | 2022-05-08 | US | Iowa | Pocahontas | 19151 | 1607 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-09 04:20:54 | Pocahontas, Iowa, US | |
361576 | 361576 | 2022-05-07 | US | Iowa | Pocahontas | 19151 | 1607 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-08 04:20:49 | Pocahontas, Iowa, US | |
1398927 | 1398927 | 2022-05-06 | US | Iowa | Pocahontas | 19151 | 1607 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-07 04:21:09 | Pocahontas, Iowa, US | |
2600669 | 2600669 | 2022-05-05 | US | Oregon | Harney | 41025 | 1607 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-05-06 04:21:00 | Harney, Oregon, US | |
2599282 | 2599282 | 2022-05-05 | US | Iowa | Pocahontas | 19151 | 1607 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-06 04:21:00 | Pocahontas, Iowa, US | |
3268118 | 3268118 | 2022-05-04 | US | Oregon | Harney | 41025 | 1607 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-05-05 04:20:55 | Harney, Oregon, US | |
3266731 | 3266731 | 2022-05-04 | US | Iowa | Pocahontas | 19151 | 1607 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-05 04:20:55 | Pocahontas, Iowa, US | |
1574757 | 1574757 | 2022-05-03 | US | Oregon | Harney | 41025 | 1607 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-05-04 04:20:59 | Harney, Oregon, US | |
2442558 | 2442558 | 2022-04-13 | China | Liaoning | 1607 | 2 | 0 | 41.2956 | 122.6085 | 2022-04-13 23:21:06 | Liaoning, China | |||
1948315 | 1948315 | 2022-04-12 | China | Liaoning | 1607 | 2 | 0 | 41.2956 | 122.6085 | 2022-04-13 04:21:03 | Liaoning, China | |||
2802740 | 2802740 | 2022-04-06 | US | Missouri | Shannon | 29203 | 1607 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-04-07 04:20:53 | Shannon, Missouri, US | |
3869509 | 3869509 | 2022-04-05 | US | Missouri | Shannon | 29203 | 1607 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-04-06 04:20:49 | Shannon, Missouri, US | |
2750851 | 2750851 | 2022-04-04 | US | Missouri | Shannon | 29203 | 1607 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-04-05 04:20:48 | Shannon, Missouri, US | |
3732197 | 3732197 | 2022-04-03 | US | Missouri | Shannon | 29203 | 1607 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-04-04 04:20:51 | Shannon, Missouri, US | |
501632 | 501632 | 2022-04-02 | US | Missouri | Shannon | 29203 | 1607 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-04-03 04:20:48 | Shannon, Missouri, US | |
3352617 | 3352617 | 2022-04-01 | US | Missouri | Shannon | 29203 | 1607 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-04-02 04:20:47 | Shannon, Missouri, US | |
1541922 | 1541922 | 2022-03-31 | US | Missouri | Shannon | 29203 | 1607 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-04-01 04:20:28 | Shannon, Missouri, US | |
953900 | 953900 | 2022-03-12 | US | Texas | Brooks | 48047 | 1607 | 51 | 0 | 27.03103197 | -98.21808402 | 2022-03-13 04:20:49 | Brooks, Texas, US | |
951474 | 951474 | 2022-03-12 | US | Colorado | Clear Creek | 8019 | 1607 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-13 04:20:49 | Clear Creek, Colorado, US | |
950657 | 950657 | 2022-03-12 | China | Hebei | 1607 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-13 04:20:49 | Hebei, China | |||
356935 | 356935 | 2022-03-11 | US | Colorado | Clear Creek | 8019 | 1607 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-12 04:20:50 | Clear Creek, Colorado, US | |
1866087 | 1866087 | 2022-03-10 | US | Colorado | Clear Creek | 8019 | 1607 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-11 04:20:50 | Clear Creek, Colorado, US | |
2140782 | 2140782 | 2022-03-09 | US | Colorado | Clear Creek | 8019 | 1607 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-10 04:20:48 | Clear Creek, Colorado, US | |
920293 | 920293 | 2022-03-08 | US | Colorado | Clear Creek | 8019 | 1607 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-09 04:20:59 | Clear Creek, Colorado, US | |
3822336 | 3822336 | 2022-02-16 | US | Missouri | Daviess | 29061 | 1607 | 26 | 0 | 39.96145298 | -93.98519678 | 2022-02-17 04:20:56 | Daviess, Missouri, US | |
3674818 | 3674818 | 2022-02-15 | US | Texas | Marion | 48315 | 1607 | 57 | 0 | 32.79868409 | -94.35661230000001 | 2022-02-16 04:21:10 | Marion, Texas, US | |
74516 | 74516 | 2022-02-07 | US | Virginia | Williamsburg | 51830 | 1607 | 13 | 0 | 37.28131268 | -76.70905141 | 2022-02-08 04:21:15 | Williamsburg, Virginia, US | |
1294666 | 1294666 | 2022-02-05 | US | Colorado | Kit Carson | 8063 | 1607 | 32 | 0 | 39.30497777 | -102.60221990000001 | 2022-02-06 04:21:00 | Kit Carson, Colorado, US | |
2475251 | 2475251 | 2022-02-03 | US | Kansas | Harper | 20077 | 1607 | 25 | 0 | 37.19175361 | -98.07578384 | 2022-02-04 04:21:10 | Harper, Kansas, US | |
460676 | 460676 | 2022-02-02 | US | Kansas | Harper | 20077 | 1607 | 25 | 0 | 37.19175361 | -98.07578384 | 2022-02-03 04:21:21 | Harper, Kansas, US | |
2055259 | 2055259 | 2022-01-25 | US | Virginia | Middlesex | 51119 | 1607 | 35 | 0 | 37.63191998 | -76.55064617 | 2022-01-26 04:21:07 | Middlesex, Virginia, US | |
3428042 | 3428042 | 2022-01-21 | US | Texas | Gaines | 48165 | 1607 | 73 | 0 | 32.74055318 | -102.6353295 | 2022-01-22 04:21:13 | Gaines, Texas, US | |
1695932 | 1695932 | 2022-01-10 | US | Wyoming | Platte | 56031 | 1607 | 37 | 0 | 42.13299116 | -104.96633100000001 | 2022-01-11 04:22:01 | Platte, Wyoming, US | |
1390135 | 1390135 | 2022-01-07 | US | Arkansas | Cleveland | 5025 | 1607 | 33 | 0 | 33.89723187 | -92.18537045 | 2022-01-08 04:21:53 | Cleveland, Arkansas, US | |
1285016 | 1285016 | 2022-01-05 | US | Texas | Blanco | 48031 | 1607 | 28 | 0 | 30.26640707 | -98.3999852 | 2022-01-06 04:22:09 | Blanco, Texas, US | |
1283517 | 1283517 | 2022-01-05 | US | Louisiana | Red River | 22081 | 1607 | 49 | 0 | 32.09530039 | -93.34213308 | 2022-01-06 04:22:09 | Red River, Louisiana, US | |
1703528 | 1703528 | 2022-01-03 | US | Texas | Mitchell | 48335 | 1607 | 43 | 0 | 32.30623474 | -100.9212058 | 2022-01-04 04:22:17 | Mitchell, Texas, US | |
1669206 | 1669206 | 2021-12-29 | US | Georgia | Atkinson | 13003 | 1607 | 38 | 0 | 31.29633502 | -82.87545866 | 2021-12-30 04:21:25 | Atkinson, Georgia, US | |
3831848 | 3831848 | 2021-12-21 | US | Virginia | Nelson | 51125 | 1607 | 22 | 0 | 37.78790447 | -78.88498513 | 2021-12-22 04:21:54 | Nelson, Virginia, US | |
2091488 | 2091488 | 2021-12-14 | US | West Virginia | Summers | 54089 | 1607 | 35 | 0 | 37.65390597 | -80.86009693 | 2021-12-15 03:22:16 | Summers, West Virginia, US | |
1663726 | 1663726 | 2021-12-12 | US | Virginia | Amelia | 51007 | 1607 | 42 | 0 | 37.34081025 | -77.98584649 | 2021-12-13 04:22:02 | Amelia, Virginia, US | |
1667742 | 1667742 | 2021-12-11 | US | Virginia | Amelia | 51007 | 1607 | 42 | 0 | 37.34081025 | -77.98584649 | 2021-12-12 04:22:12 | Amelia, Virginia, US | |
3658894 | 3658894 | 2021-12-10 | US | Virginia | Amelia | 51007 | 1607 | 42 | 0 | 37.34081025 | -77.98584649 | 2021-12-11 04:22:45 | Amelia, Virginia, US | |
405313 | 405313 | 2021-12-07 | US | Illinois | Marshall | 17123 | 1607 | 23 | 0 | 41.0327901 | -89.34510444 | 2021-12-08 04:22:46 | Marshall, Illinois, US | |
1742702 | 1742702 | 2021-12-05 | US | New Hampshire | Unassigned | 90033 | 1607 | 11 | 0 | 44.69063265 | 0.0 | 2021-12-06 04:22:34 | Unassigned, New Hampshire, US | |
140134 | 140134 | 2021-12-04 | US | New Hampshire | Unassigned | 90033 | 1607 | 11 | 0 | 44.69063265 | 0.0 | 2021-12-05 04:22:25 | Unassigned, New Hampshire, US | |
2197787 | 2197787 | 2021-12-03 | US | New Hampshire | Unassigned | 90033 | 1607 | 11 | 0 | 44.69063265 | 0.0 | 2021-12-04 04:22:18 | Unassigned, New Hampshire, US | |
1147038 | 1147038 | 2021-12-01 | US | Nebraska | Phelps | 31137 | 1607 | 10 | 0 | 40.51156033 | -99.41461667 | 2021-12-02 04:22:37 | Phelps, Nebraska, US | |
1145488 | 1145488 | 2021-12-01 | US | California | Mariposa | 6043 | 1607 | 18 | 0 | 37.57978556 | -119.9073334 | 2021-12-02 04:22:37 | Mariposa, California, 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]);