johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
443 rows where confirmed = 1417 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3177400 | 3177400 | 2022-12-19 | US | Wyoming | Hot Springs | 56017 | 1417 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-20 04:21:04 | Hot Springs, Wyoming, US | |
1631917 | 1631917 | 2022-12-18 | US | Wyoming | Hot Springs | 56017 | 1417 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-19 04:21:03 | Hot Springs, Wyoming, US | |
507296 | 507296 | 2022-12-17 | US | Wyoming | Hot Springs | 56017 | 1417 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-18 04:21:03 | Hot Springs, Wyoming, US | |
3327868 | 3327868 | 2022-12-16 | US | Wyoming | Hot Springs | 56017 | 1417 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-17 04:21:04 | Hot Springs, Wyoming, US | |
546380 | 546380 | 2022-12-15 | US | Wyoming | Hot Springs | 56017 | 1417 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-16 04:21:01 | Hot Springs, Wyoming, US | |
351908 | 351908 | 2022-12-14 | US | Wyoming | Hot Springs | 56017 | 1417 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-15 04:20:58 | Hot Springs, Wyoming, US | |
311496 | 311496 | 2022-12-13 | US | Wyoming | Hot Springs | 56017 | 1417 | 20 | 0 | 43.71930657 | -108.4423174 | 2022-12-14 04:21:04 | Hot Springs, Wyoming, US | |
870206 | 870206 | 2022-12-11 | US | Kentucky | Fulton | 21075 | 1417 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-12 04:21:01 | Fulton, Kentucky, US | |
258736 | 258736 | 2022-12-10 | US | Kentucky | Fulton | 21075 | 1417 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-11 04:20:50 | Fulton, Kentucky, US | |
3937450 | 3937450 | 2022-12-09 | US | Kentucky | Fulton | 21075 | 1417 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-10 04:21:02 | Fulton, Kentucky, US | |
3378782 | 3378782 | 2022-12-08 | US | Kentucky | Fulton | 21075 | 1417 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-09 04:21:05 | Fulton, Kentucky, US | |
1986053 | 1986053 | 2022-12-07 | US | Kentucky | Fulton | 21075 | 1417 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-08 04:21:07 | Fulton, Kentucky, US | |
3715576 | 3715576 | 2022-12-06 | US | Kentucky | Fulton | 21075 | 1417 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-07 04:20:58 | Fulton, Kentucky, US | |
2416281 | 2416281 | 2022-12-05 | US | Kentucky | Fulton | 21075 | 1417 | 35 | 0 | 36.55238827 | -89.20140068 | 2022-12-06 04:21:03 | Fulton, Kentucky, US | |
1052938 | 1052938 | 2022-11-06 | US | Texas | Garza | 48169 | 1417 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-07 04:21:26 | Garza, Texas, US | |
620962 | 620962 | 2022-11-05 | US | Texas | Garza | 48169 | 1417 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-06 04:21:24 | Garza, Texas, US | |
1025466 | 1025466 | 2022-11-04 | US | Texas | Garza | 48169 | 1417 | 30 | 0 | 33.17969345 | -101.2984114 | 2022-11-05 04:21:52 | Garza, Texas, US | |
1811434 | 1811434 | 2022-10-05 | US | Colorado | Saguache | 8109 | 1417 | 12 | 0 | 38.08054629 | -106.282466 | 2022-10-06 04:21:22 | Saguache, Colorado, US | |
115799 | 115799 | 2022-09-06 | US | Illinois | Scott | 17171 | 1417 | 13 | 0 | 39.6429169 | -90.47814431 | 2022-09-07 04:20:59 | Scott, Illinois, US | |
1532428 | 1532428 | 2022-08-26 | US | Arkansas | Lafayette | 5073 | 1417 | 30 | 0 | 33.24116713 | -93.60677071 | 2022-08-27 04:20:57 | Lafayette, Arkansas, US | |
1252103 | 1252103 | 2022-08-23 | US | Kansas | Scott | 20171 | 1417 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-08-24 04:20:46 | Scott, Kansas, US | |
2854207 | 2854207 | 2022-08-22 | US | Kansas | Scott | 20171 | 1417 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-08-23 04:20:56 | Scott, Kansas, US | |
2404179 | 2404179 | 2022-08-21 | US | Kansas | Scott | 20171 | 1417 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-08-22 04:20:38 | Scott, Kansas, US | |
3799257 | 3799257 | 2022-08-20 | US | Kansas | Scott | 20171 | 1417 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-08-21 04:20:44 | Scott, Kansas, US | |
2364843 | 2364843 | 2022-08-19 | US | Kansas | Scott | 20171 | 1417 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-08-20 04:21:01 | Scott, Kansas, US | |
2363294 | 2363294 | 2022-08-19 | China | Hunan | 1417 | 4 | 0 | 27.6104 | 111.7088 | 2022-08-20 04:21:01 | Hunan, China | |||
1162514 | 1162514 | 2022-08-18 | US | Kansas | Scott | 20171 | 1417 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-08-19 04:20:54 | Scott, Kansas, US | |
1160965 | 1160965 | 2022-08-18 | China | Hunan | 1417 | 4 | 0 | 27.6104 | 111.7088 | 2022-08-19 04:20:54 | Hunan, China | |||
3951838 | 3951838 | 2022-08-17 | US | Kansas | Scott | 20171 | 1417 | 34 | 0 | 38.48222076 | -100.9066539 | 2022-08-18 04:21:11 | Scott, Kansas, US | |
3950289 | 3950289 | 2022-08-17 | China | Hunan | 1417 | 4 | 0 | 27.6104 | 111.7088 | 2022-08-18 04:21:11 | Hunan, China | |||
1099082 | 1099082 | 2022-08-03 | US | Illinois | Alexander | 17003 | 1417 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-08-04 04:20:58 | Alexander, Illinois, US | |
1407454 | 1407454 | 2022-08-02 | US | North Dakota | McHenry | 38049 | 1417 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-08-03 04:20:59 | McHenry, North Dakota, US | |
960126 | 960126 | 2022-07-19 | US | Iowa | Osceola | 19143 | 1417 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-20 04:20:59 | Osceola, Iowa, US | |
3211513 | 3211513 | 2022-07-18 | US | Iowa | Osceola | 19143 | 1417 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-19 04:20:58 | Osceola, Iowa, US | |
3406688 | 3406688 | 2022-07-17 | US | Iowa | Osceola | 19143 | 1417 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-18 04:20:59 | Osceola, Iowa, US | |
2152888 | 2152888 | 2022-07-16 | US | Iowa | Osceola | 19143 | 1417 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-17 04:21:15 | Osceola, Iowa, US | |
2420121 | 2420121 | 2022-07-15 | US | Iowa | Osceola | 19143 | 1417 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-16 04:21:05 | Osceola, Iowa, US | |
3430196 | 3430196 | 2022-07-14 | US | Iowa | Osceola | 19143 | 1417 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-15 04:20:53 | Osceola, Iowa, US | |
3110716 | 3110716 | 2022-07-13 | US | Iowa | Osceola | 19143 | 1417 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-07-14 04:20:57 | Osceola, Iowa, US | |
2240594 | 2240594 | 2022-06-28 | US | Iowa | Fremont | 19071 | 1417 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-29 04:20:59 | Fremont, Iowa, US | |
2148836 | 2148836 | 2022-06-27 | US | Iowa | Fremont | 19071 | 1417 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-28 04:20:58 | Fremont, Iowa, US | |
476637 | 476637 | 2022-06-26 | US | Iowa | Fremont | 19071 | 1417 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-27 04:21:00 | Fremont, Iowa, US | |
940012 | 940012 | 2022-06-25 | US | Iowa | Fremont | 19071 | 1417 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-26 04:21:02 | Fremont, Iowa, US | |
3347832 | 3347832 | 2022-06-24 | US | Iowa | Fremont | 19071 | 1417 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-25 04:20:57 | Fremont, Iowa, US | |
1649573 | 1649573 | 2022-06-23 | US | Iowa | Fremont | 19071 | 1417 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-24 04:20:58 | Fremont, Iowa, US | |
2188808 | 2188808 | 2022-06-22 | US | Iowa | Fremont | 19071 | 1417 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-23 04:20:55 | Fremont, Iowa, US | |
168942 | 168942 | 2022-06-21 | US | South Dakota | Moody | 46101 | 1417 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-22 04:20:54 | Moody, South Dakota, US | |
1766225 | 1766225 | 2022-06-20 | US | South Dakota | Moody | 46101 | 1417 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-21 04:20:56 | Moody, South Dakota, US | |
3272411 | 3272411 | 2022-06-19 | US | South Dakota | Moody | 46101 | 1417 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-20 04:21:01 | Moody, South Dakota, US | |
3400323 | 3400323 | 2022-06-18 | US | South Dakota | Moody | 46101 | 1417 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-19 04:20:51 | Moody, South Dakota, US | |
2314200 | 2314200 | 2022-06-17 | US | South Dakota | Moody | 46101 | 1417 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-18 04:21:10 | Moody, South Dakota, US | |
561704 | 561704 | 2022-06-16 | US | South Dakota | Moody | 46101 | 1417 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-17 04:20:56 | Moody, South Dakota, US | |
3985506 | 3985506 | 2022-06-15 | US | South Dakota | Moody | 46101 | 1417 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-06-16 04:20:55 | Moody, South Dakota, US | |
1424432 | 1424432 | 2022-06-08 | US | Virginia | Cumberland | 51049 | 1417 | 26 | 0 | 37.51328851 | -78.24398086 | 2022-06-09 04:20:54 | Cumberland, Virginia, US | |
1185737 | 1185737 | 2022-05-18 | US | Illinois | Gallatin | 17059 | 1417 | 17 | 0 | 37.76430935 | -88.22953869 | 2022-05-19 04:20:54 | Gallatin, Illinois, US | |
3583634 | 3583634 | 2022-05-17 | US | Illinois | Gallatin | 17059 | 1417 | 17 | 0 | 37.76430935 | -88.22953869 | 2022-05-18 04:20:50 | Gallatin, Illinois, US | |
3919475 | 3919475 | 2022-05-01 | US | Washington | Ferry | 53019 | 1417 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-02 04:21:10 | Ferry, Washington, US | |
2844279 | 2844279 | 2022-04-30 | US | Washington | Ferry | 53019 | 1417 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-05-01 04:20:57 | Ferry, Washington, US | |
1160592 | 1160592 | 2022-04-29 | US | Washington | Ferry | 53019 | 1417 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-04-30 04:21:05 | Ferry, Washington, US | |
3724828 | 3724828 | 2022-04-25 | US | Oregon | Lake | 41037 | 1417 | 29 | 0 | 42.79246693 | -120.38501629999999 | 2022-04-26 04:20:51 | Lake, Oregon, US | |
2031396 | 2031396 | 2022-04-24 | US | Oregon | Lake | 41037 | 1417 | 28 | 0 | 42.79246693 | -120.38501629999999 | 2022-04-25 04:20:56 | Lake, Oregon, US | |
748971 | 748971 | 2022-04-23 | US | Oregon | Lake | 41037 | 1417 | 28 | 0 | 42.79246693 | -120.38501629999999 | 2022-04-24 04:20:56 | Lake, Oregon, US | |
3439456 | 3439456 | 2022-04-22 | US | Oregon | Lake | 41037 | 1417 | 28 | 0 | 42.79246693 | -120.38501629999999 | 2022-04-23 04:20:50 | Lake, Oregon, US | |
1867374 | 1867374 | 2022-03-10 | US | Missouri | Dade | 29057 | 1417 | 40 | 0 | 37.431814 | -93.8503345 | 2022-03-11 04:20:50 | Dade, Missouri, US | |
2142069 | 2142069 | 2022-03-09 | US | Missouri | Dade | 29057 | 1417 | 40 | 0 | 37.431814 | -93.8503345 | 2022-03-10 04:20:48 | Dade, Missouri, US | |
921580 | 921580 | 2022-03-08 | US | Missouri | Dade | 29057 | 1417 | 40 | 0 | 37.431814 | -93.8503345 | 2022-03-09 04:20:59 | Dade, Missouri, US | |
1551346 | 1551346 | 2022-03-07 | US | Virginia | Mathews | 51115 | 1417 | 28 | 0 | 37.44164146 | -76.34098896 | 2022-03-08 04:20:54 | Mathews, Virginia, US | |
1549867 | 1549867 | 2022-03-07 | US | Missouri | Dade | 29057 | 1417 | 40 | 0 | 37.431814 | -93.8503345 | 2022-03-08 04:20:54 | Dade, Missouri, US | |
1646258 | 1646258 | 2022-03-03 | US | Missouri | Dade | 29057 | 1417 | 40 | 0 | 37.431814 | -93.8503345 | 2022-03-04 04:21:09 | Dade, Missouri, US | |
2735083 | 2735083 | 2022-02-27 | US | Nebraska | Clay | 31035 | 1417 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-28 04:21:05 | Clay, Nebraska, US | |
3048236 | 3048236 | 2022-02-26 | US | Nebraska | Clay | 31035 | 1417 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-27 04:21:04 | Clay, Nebraska, US | |
576891 | 576891 | 2022-02-25 | US | Nebraska | Clay | 31035 | 1417 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-26 04:21:12 | Clay, Nebraska, US | |
1059908 | 1059908 | 2022-02-23 | US | Nebraska | Clay | 31035 | 1417 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-24 04:21:14 | Clay, Nebraska, US | |
2448831 | 2448831 | 2022-02-22 | US | Nebraska | Clay | 31035 | 1417 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-23 04:21:09 | Clay, Nebraska, US | |
2448451 | 2448451 | 2022-02-22 | US | Michigan | Oscoda | 26135 | 1417 | 53 | 0 | 44.68192279 | -84.12939244 | 2022-02-23 04:21:09 | Oscoda, Michigan, US | |
3720244 | 3720244 | 2022-02-21 | US | Nebraska | Clay | 31035 | 1417 | 11 | 0 | 40.52439441 | -98.05126296 | 2022-02-22 04:21:01 | Clay, Nebraska, US | |
3719864 | 3719864 | 2022-02-21 | US | Michigan | Oscoda | 26135 | 1417 | 53 | 0 | 44.68192279 | -84.12939244 | 2022-02-22 04:21:01 | Oscoda, Michigan, US | |
3913698 | 3913698 | 2022-02-20 | US | Michigan | Oscoda | 26135 | 1417 | 53 | 0 | 44.68192279 | -84.12939244 | 2022-02-21 04:21:05 | Oscoda, Michigan, US | |
3877256 | 3877256 | 2022-02-19 | US | Michigan | Oscoda | 26135 | 1417 | 53 | 0 | 44.68192279 | -84.12939244 | 2022-02-20 04:21:00 | Oscoda, Michigan, US | |
3857512 | 3857512 | 2022-02-18 | US | Michigan | Oscoda | 26135 | 1417 | 53 | 0 | 44.68192279 | -84.12939244 | 2022-02-19 04:21:11 | Oscoda, Michigan, US | |
2014761 | 2014761 | 2022-02-06 | US | Nebraska | Cedar | 31027 | 1417 | 11 | 0 | 42.598885100000004 | -97.25311951 | 2022-02-07 04:21:05 | Cedar, Nebraska, US | |
1296090 | 1296090 | 2022-02-05 | US | Nebraska | Cedar | 31027 | 1417 | 11 | 0 | 42.598885100000004 | -97.25311951 | 2022-02-06 04:21:00 | Cedar, Nebraska, US | |
2329418 | 2329418 | 2022-02-04 | US | Nebraska | Cedar | 31027 | 1417 | 11 | 0 | 42.598885100000004 | -97.25311951 | 2022-02-05 04:21:05 | Cedar, Nebraska, US | |
556904 | 556904 | 2022-01-16 | US | Nebraska | Richardson | 31147 | 1417 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-01-17 04:21:08 | Richardson, Nebraska, US | |
3842625 | 3842625 | 2022-01-15 | US | Nebraska | Richardson | 31147 | 1417 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-01-16 04:21:12 | Richardson, Nebraska, US | |
102460 | 102460 | 2022-01-14 | US | Texas | Jim Hogg | 48247 | 1417 | 20 | 0 | 27.04453923 | -98.69681870000001 | 2022-01-15 04:21:07 | Jim Hogg, Texas, US | |
101440 | 101440 | 2022-01-14 | US | Nebraska | Richardson | 31147 | 1417 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-01-15 04:21:07 | Richardson, Nebraska, US | |
3616400 | 3616400 | 2022-01-12 | US | Virginia | Falls Church | 51610 | 1417 | 14 | 0 | 38.88485255 | -77.17560759 | 2022-01-13 08:00:09 | Falls Church, Virginia, US | |
1692830 | 1692830 | 2022-01-10 | US | Arkansas | Newton | 5101 | 1417 | 44 | 0 | 35.91947491 | -93.21612969 | 2022-01-11 04:22:01 | Newton, Arkansas, US | |
1703575 | 1703575 | 2022-01-03 | US | Texas | Stephens | 48429 | 1417 | 38 | 0 | 32.73553157 | -98.83631615 | 2022-01-04 04:22:17 | Stephens, Texas, US | |
3521564 | 3521564 | 2022-01-02 | US | Nebraska | Wayne | 31179 | 1417 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-01-03 02:22:25 | Wayne, Nebraska, US | |
2170321 | 2170321 | 2022-01-01 | US | Puerto Rico | Luquillo | 72089 | 1417 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-01-02 04:20:52 | Luquillo, Puerto Rico, US | |
2169694 | 2169694 | 2022-01-01 | US | Nebraska | Wayne | 31179 | 1417 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-01-02 04:20:52 | Wayne, Nebraska, US | |
2779752 | 2779752 | 2021-12-31 | US | Puerto Rico | Luquillo | 72089 | 1417 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-01-01 04:22:14 | Luquillo, Puerto Rico, US | |
2779125 | 2779125 | 2021-12-31 | US | Nebraska | Wayne | 31179 | 1417 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-01-01 04:22:14 | Wayne, Nebraska, US | |
4001598 | 4001598 | 2021-12-30 | US | Tennessee | Hancock | 47067 | 1417 | 26 | 0 | 36.52692871 | -83.22375847 | 2021-12-31 04:21:50 | Hancock, Tennessee, US | |
4000782 | 4000782 | 2021-12-30 | US | Nebraska | Wayne | 31179 | 1417 | 7 | 0 | 42.20934475 | -97.11926964 | 2021-12-31 04:21:50 | Wayne, Nebraska, US | |
1435582 | 1435582 | 2021-12-28 | US | Texas | Archer | 48009 | 1417 | 24 | 0 | 33.61569967 | -98.68754589 | 2021-12-29 03:21:43 | Archer, Texas, US | |
2963794 | 2963794 | 2021-12-24 | US | Alabama | Sumter | 1119 | 1417 | 42 | 0 | 32.59117397 | -88.19916205 | 2021-12-25 04:21:37 | Sumter, Alabama, US | |
2906780 | 2906780 | 2021-12-19 | US | Texas | Crosby | 48107 | 1417 | 40 | 0 | 33.61431553 | -101.30003640000001 | 2021-12-20 04:21:43 | Crosby, Texas, 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]);