johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
385 rows where confirmed = 1658 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753838 | 2753838 | 2022-12-29 | US | Idaho | Caribou | 16029 | 1658 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-30 04:21:04 | Caribou, Idaho, US | |
1074844 | 1074844 | 2022-12-28 | US | Idaho | Caribou | 16029 | 1658 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-29 04:21:01 | Caribou, Idaho, US | |
329243 | 329243 | 2022-12-27 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-28 04:21:04 | Phillips, Kansas, US | |
219316 | 219316 | 2022-12-26 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-27 04:21:07 | Phillips, Kansas, US | |
3223773 | 3223773 | 2022-12-25 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-26 04:21:06 | Phillips, Kansas, US | |
1019687 | 1019687 | 2022-12-24 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-25 04:21:04 | Phillips, Kansas, US | |
691710 | 691710 | 2022-12-23 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-24 04:21:02 | Phillips, Kansas, US | |
2180920 | 2180920 | 2022-12-22 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-23 04:21:04 | Phillips, Kansas, US | |
452724 | 452724 | 2022-12-21 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-22 04:20:56 | Phillips, Kansas, US | |
2954298 | 2954298 | 2022-12-20 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-21 04:21:03 | Tripp, South Dakota, US | |
3176700 | 3176700 | 2022-12-19 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-20 04:21:04 | Tripp, South Dakota, US | |
1631217 | 1631217 | 2022-12-18 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-19 04:21:03 | Tripp, South Dakota, US | |
506596 | 506596 | 2022-12-17 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-18 04:21:03 | Tripp, South Dakota, US | |
3327168 | 3327168 | 2022-12-16 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-17 04:21:04 | Tripp, South Dakota, US | |
545680 | 545680 | 2022-12-15 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-16 04:21:01 | Tripp, South Dakota, US | |
351208 | 351208 | 2022-12-14 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-15 04:20:58 | Tripp, South Dakota, US | |
1831280 | 1831280 | 2022-10-25 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-26 04:22:19 | Ohio, Indiana, US | |
795541 | 795541 | 2022-10-24 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-25 04:21:53 | Ohio, Indiana, US | |
3277996 | 3277996 | 2022-10-23 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-24 04:22:29 | Ohio, Indiana, US | |
2269034 | 2269034 | 2022-10-22 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-23 04:22:46 | Ohio, Indiana, US | |
1593334 | 1593334 | 2022-10-21 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-22 04:22:53 | Ohio, Indiana, US | |
2273050 | 2273050 | 2022-10-20 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-21 04:22:23 | Ohio, Indiana, US | |
199385 | 199385 | 2022-10-19 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-20 04:22:59 | Ohio, Indiana, US | |
2162579 | 2162579 | 2022-10-16 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-17 04:20:31 | Carson, Texas, US | |
2160904 | 2160904 | 2022-10-16 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-17 04:20:31 | Ballard, Kentucky, US | |
518776 | 518776 | 2022-10-15 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-16 04:22:39 | Carson, Texas, US | |
517101 | 517101 | 2022-10-15 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-16 04:22:39 | Ballard, Kentucky, US | |
2035833 | 2035833 | 2022-10-14 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-15 04:22:00 | Carson, Texas, US | |
2034158 | 2034158 | 2022-10-14 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-15 04:22:00 | Ballard, Kentucky, US | |
3756521 | 3756521 | 2022-10-13 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-14 04:22:28 | Carson, Texas, US | |
3754846 | 3754846 | 2022-10-13 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-14 04:22:28 | Ballard, Kentucky, US | |
3217346 | 3217346 | 2022-10-12 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-13 04:22:39 | Carson, Texas, US | |
3215671 | 3215671 | 2022-10-12 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-13 04:22:39 | Ballard, Kentucky, US | |
3253195 | 3253195 | 2022-10-11 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-12 04:22:51 | Carson, Texas, US | |
3251520 | 3251520 | 2022-10-11 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-12 04:22:51 | Ballard, Kentucky, US | |
2970454 | 2970454 | 2022-10-10 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-11 04:23:05 | Carson, Texas, US | |
2968779 | 2968779 | 2022-10-10 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-11 04:23:05 | Ballard, Kentucky, US | |
3100490 | 3100490 | 2022-10-09 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-10 04:22:32 | Carson, Texas, US | |
4005715 | 4005715 | 2022-10-08 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-09 04:21:16 | Carson, Texas, US | |
399312 | 399312 | 2022-10-07 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-08 04:22:56 | Carson, Texas, US | |
2532429 | 2532429 | 2022-10-06 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-07 04:23:08 | Carson, Texas, US | |
2531281 | 2531281 | 2022-10-06 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-07 04:23:08 | Dade, Missouri, US | |
1813823 | 1813823 | 2022-10-05 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-06 04:21:22 | Carson, Texas, US | |
1812675 | 1812675 | 2022-10-05 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-06 04:21:22 | Dade, Missouri, US | |
133797 | 133797 | 2022-10-04 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-05 04:23:06 | Carson, Texas, US | |
132649 | 132649 | 2022-10-04 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-05 04:23:06 | Dade, Missouri, US | |
131699 | 131699 | 2022-10-04 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-05 04:23:06 | Lemhi, Idaho, US | |
2688744 | 2688744 | 2022-10-03 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-04 04:22:55 | Carson, Texas, US | |
2687596 | 2687596 | 2022-10-03 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-04 04:22:55 | Dade, Missouri, US | |
2686646 | 2686646 | 2022-10-03 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-04 04:22:55 | Lemhi, Idaho, US | |
2262811 | 2262811 | 2022-10-02 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-03 04:23:11 | Carson, Texas, US | |
2261663 | 2261663 | 2022-10-02 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-03 04:23:11 | Dade, Missouri, US | |
2260713 | 2260713 | 2022-10-02 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-03 04:23:11 | Lemhi, Idaho, US | |
2998337 | 2998337 | 2022-10-01 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-02 04:21:23 | Carson, Texas, US | |
2997189 | 2997189 | 2022-10-01 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-02 04:21:23 | Dade, Missouri, US | |
2996239 | 2996239 | 2022-10-01 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-02 04:21:23 | Lemhi, Idaho, US | |
856663 | 856663 | 2022-09-30 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-01 04:23:01 | Carson, Texas, US | |
855515 | 855515 | 2022-09-30 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-01 04:23:01 | Dade, Missouri, US | |
854565 | 854565 | 2022-09-30 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-01 04:23:01 | Lemhi, Idaho, US | |
2378589 | 2378589 | 2022-09-29 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-09-30 04:23:09 | Carson, Texas, US | |
3997967 | 3997967 | 2022-09-27 | US | Virginia | Cumberland | 51049 | 1658 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-09-28 04:23:01 | Cumberland, Virginia, US | |
2395429 | 2395429 | 2022-09-12 | US | Colorado | Huerfano | 8055 | 1658 | 38 | 0 | 37.68473101 | -104.9612585 | 2022-09-13 04:20:57 | Huerfano, Colorado, US | |
1253633 | 1253633 | 2022-08-23 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-24 04:20:46 | Hamlin, South Dakota, US | |
1251749 | 1251749 | 2022-08-23 | US | Illinois | Gallatin | 17059 | 1658 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-08-24 04:20:46 | Gallatin, Illinois, US | |
2855737 | 2855737 | 2022-08-22 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-23 04:20:56 | Hamlin, South Dakota, US | |
2405709 | 2405709 | 2022-08-21 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-22 04:20:38 | Hamlin, South Dakota, US | |
3800787 | 3800787 | 2022-08-20 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-21 04:20:44 | Hamlin, South Dakota, US | |
2366373 | 2366373 | 2022-08-19 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-20 04:21:01 | Hamlin, South Dakota, US | |
1164044 | 1164044 | 2022-08-18 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-19 04:20:54 | Hamlin, South Dakota, US | |
3953368 | 3953368 | 2022-08-17 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-18 04:21:11 | Hamlin, South Dakota, US | |
3544002 | 3544002 | 2022-08-08 | US | Arkansas | Montgomery | 5097 | 1658 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-08-09 04:20:34 | Montgomery, Arkansas, US | |
1490607 | 1490607 | 2022-07-26 | US | Texas | Bailey | 48017 | 1658 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-07-27 04:21:04 | Bailey, Texas, US | |
2597053 | 2597053 | 2022-07-25 | US | Texas | Bailey | 48017 | 1658 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-07-26 04:20:58 | Bailey, Texas, US | |
899168 | 899168 | 2022-07-24 | US | Texas | Bailey | 48017 | 1658 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-07-25 04:20:51 | Bailey, Texas, US | |
2151446 | 2151446 | 2022-07-16 | China | Guangxi | 1658 | 2 | 0 | 23.8298 | 108.7881 | 2022-07-17 04:21:15 | Guangxi, China | |||
2242858 | 2242858 | 2022-06-28 | US | Washington | San Juan | 53055 | 1658 | 2 | 0 | 48.60182783 | -122.96745 | 2022-06-29 04:20:59 | San Juan, Washington, US | |
2151100 | 2151100 | 2022-06-27 | US | Washington | San Juan | 53055 | 1658 | 2 | 0 | 48.60182783 | -122.96745 | 2022-06-28 04:20:58 | San Juan, Washington, US | |
3349028 | 3349028 | 2022-06-24 | US | North Dakota | Bottineau | 38009 | 1658 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-06-25 04:20:57 | Bottineau, North Dakota, US | |
221797 | 221797 | 2022-05-09 | China | Liaoning | 1658 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-10 04:20:50 | Liaoning, China | |||
3917816 | 3917816 | 2022-05-01 | US | Minnesota | Wilkin | 27167 | 1658 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-02 04:21:10 | Wilkin, Minnesota, US | |
2842620 | 2842620 | 2022-04-30 | US | Minnesota | Wilkin | 27167 | 1658 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-01 04:20:57 | Wilkin, Minnesota, US | |
1158933 | 1158933 | 2022-04-29 | US | Minnesota | Wilkin | 27167 | 1658 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-04-30 04:21:05 | Wilkin, Minnesota, US | |
1470720 | 1470720 | 2022-03-24 | US | Oregon | Grant | 41023 | 1658 | 20 | 0 | 44.49024544 | -119.0068631 | 2022-03-25 04:20:46 | Grant, Oregon, US | |
3627749 | 3627749 | 2022-03-13 | China | Hebei | 1658 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-14 04:20:46 | Hebei, China | |||
1868199 | 1868199 | 2022-03-10 | US | Puerto Rico | Arroyo | 72015 | 1658 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-03-11 04:20:50 | Arroyo, Puerto Rico, US | |
922850 | 922850 | 2022-03-08 | US | Texas | Marion | 48315 | 1658 | 59 | 0 | 32.79868409 | -94.35661230000001 | 2022-03-09 04:20:59 | Marion, Texas, US | |
1364326 | 1364326 | 2022-02-08 | US | Missouri | Sullivan | 29211 | 1658 | 19 | 0 | 40.2099105 | -93.11150106 | 2022-02-09 04:21:04 | Sullivan, Missouri, US | |
558362 | 558362 | 2022-01-16 | US | Wisconsin | Pepin | 55091 | 1658 | 16 | 0 | 44.58307413 | -91.99949611 | 2022-01-17 04:21:08 | Pepin, Wisconsin, US | |
3844083 | 3844083 | 2022-01-15 | US | Wisconsin | Pepin | 55091 | 1658 | 16 | 0 | 44.58307413 | -91.99949611 | 2022-01-16 04:21:12 | Pepin, Wisconsin, US | |
102898 | 102898 | 2022-01-14 | US | Wisconsin | Pepin | 55091 | 1658 | 16 | 0 | 44.58307413 | -91.99949611 | 2022-01-15 04:21:07 | Pepin, Wisconsin, US | |
3690496 | 3690496 | 2022-01-13 | US | Texas | Archer | 48009 | 1658 | 24 | 0 | 33.61569967 | -98.68754589 | 2022-01-14 04:21:54 | Archer, Texas, US | |
1283105 | 1283105 | 2022-01-05 | US | Indiana | Martin | 18101 | 1658 | 20 | 0 | 38.7099921 | -86.80373186 | 2022-01-06 04:22:09 | Martin, Indiana, US | |
1287208 | 1287208 | 2022-01-04 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-05 04:21:59 | Howard, Iowa, US | |
1702261 | 1702261 | 2022-01-03 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-04 04:22:17 | Howard, Missouri, US | |
1701552 | 1701552 | 2022-01-03 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-04 04:22:17 | Howard, Iowa, US | |
3521344 | 3521344 | 2022-01-02 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-03 02:22:25 | Howard, Missouri, US | |
3520635 | 3520635 | 2022-01-02 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-03 02:22:25 | Howard, Iowa, US | |
2169474 | 2169474 | 2022-01-01 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-02 04:20:52 | Howard, Missouri, US | |
2168765 | 2168765 | 2022-01-01 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-02 04:20:52 | Howard, Iowa, US | |
2778905 | 2778905 | 2021-12-31 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-01 04:22:14 | Howard, 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]);