johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
383 rows where confirmed = 1537 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754245 | 2754245 | 2022-12-29 | US | Kansas | Republic | 20157 | 1537 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-30 04:21:04 | Republic, Kansas, US | |
2754137 | 2754137 | 2022-12-29 | US | Iowa | Osceola | 19143 | 1537 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-12-30 04:21:04 | Osceola, Iowa, US | |
2753870 | 2753870 | 2022-12-29 | US | Illinois | Alexander | 17003 | 1537 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-12-30 04:21:04 | Alexander, Illinois, US | |
1075251 | 1075251 | 2022-12-28 | US | Kansas | Republic | 20157 | 1537 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-29 04:21:01 | Republic, Kansas, US | |
1075143 | 1075143 | 2022-12-28 | US | Iowa | Osceola | 19143 | 1537 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-12-29 04:21:01 | Osceola, Iowa, US | |
1966987 | 1966987 | 2022-11-30 | US | North Dakota | McHenry | 38049 | 1537 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-01 04:21:03 | McHenry, North Dakota, US | |
2434256 | 2434256 | 2022-11-09 | US | Virginia | Charles City | 51036 | 1537 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-11-10 04:21:16 | Charles City, Virginia, US | |
434693 | 434693 | 2022-11-03 | US | Virginia | Emporia | 51595 | 1537 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-04 04:22:11 | Emporia, Virginia, US | |
852935 | 852935 | 2022-11-02 | US | Virginia | Emporia | 51595 | 1537 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-03 04:22:05 | Emporia, Virginia, US | |
713786 | 713786 | 2022-11-01 | US | Virginia | Emporia | 51595 | 1537 | 56 | 0 | 36.69455571 | -77.53406129 | 2022-11-02 04:22:09 | Emporia, Virginia, US | |
3284682 | 3284682 | 2022-10-31 | China | Anhui | 1537 | 6 | 0 | 31.8257 | 117.2264 | 2022-11-01 04:22:36 | Anhui, China | |||
319715 | 319715 | 2022-10-30 | China | Anhui | 1537 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-31 04:21:36 | Anhui, China | |||
911991 | 911991 | 2022-10-29 | China | Anhui | 1537 | 6 | 0 | 31.8257 | 117.2264 | 2022-10-30 04:22:14 | Anhui, China | |||
375378 | 375378 | 2022-09-13 | US | Texas | Mills | 48333 | 1537 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-14 04:20:44 | Mills, Texas, US | |
2397980 | 2397980 | 2022-09-12 | US | Texas | Mills | 48333 | 1537 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-13 04:20:57 | Mills, Texas, US | |
1254021 | 1254021 | 2022-08-23 | US | Texas | Yoakum | 48501 | 1537 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-08-24 04:20:46 | Yoakum, Texas, US | |
2497205 | 2497205 | 2022-08-15 | US | Texas | McCulloch | 48307 | 1537 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-08-16 04:20:58 | McCulloch, Texas, US | |
1087031 | 1087031 | 2022-08-09 | US | Idaho | Power | 16077 | 1537 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-08-10 04:20:57 | Power, Idaho, US | |
3546118 | 3546118 | 2022-08-08 | US | Oregon | Lake | 41037 | 1537 | 30 | 0 | 42.79246693 | -120.3850163 | 2022-08-09 04:20:34 | Lake, Oregon, US | |
3544446 | 3544446 | 2022-08-08 | US | Idaho | Power | 16077 | 1537 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-08-09 04:20:34 | Power, Idaho, US | |
1072521 | 1072521 | 2022-08-07 | US | Oregon | Lake | 41037 | 1537 | 30 | 0 | 42.79246693 | -120.3850163 | 2022-08-08 04:21:08 | Lake, Oregon, US | |
1070849 | 1070849 | 2022-08-07 | US | Idaho | Power | 16077 | 1537 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-08-08 04:21:08 | Power, Idaho, US | |
1943109 | 1943109 | 2022-08-06 | US | Oregon | Lake | 41037 | 1537 | 30 | 0 | 42.79246693 | -120.3850163 | 2022-08-07 04:20:54 | Lake, Oregon, US | |
1941437 | 1941437 | 2022-08-06 | US | Idaho | Power | 16077 | 1537 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-08-07 04:20:54 | Power, Idaho, US | |
882908 | 882908 | 2022-08-05 | US | Oregon | Lake | 41037 | 1537 | 30 | 0 | 42.79246693 | -120.3850163 | 2022-08-06 04:20:56 | Lake, Oregon, US | |
881236 | 881236 | 2022-08-05 | US | Idaho | Power | 16077 | 1537 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-08-06 04:20:56 | Power, Idaho, US | |
2011319 | 2011319 | 2022-08-04 | US | Oregon | Lake | 41037 | 1537 | 30 | 0 | 42.79246693 | -120.3850163 | 2022-08-05 04:20:52 | Lake, Oregon, US | |
3967901 | 3967901 | 2022-07-05 | US | Kansas | Sherman | 20181 | 1537 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-07-06 04:20:58 | Sherman, Kansas, US | |
3079412 | 3079412 | 2022-07-04 | US | Kansas | Sherman | 20181 | 1537 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-07-05 04:20:45 | Sherman, Kansas, US | |
1768694 | 1768694 | 2022-07-03 | US | Kansas | Sherman | 20181 | 1537 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-07-04 04:20:54 | Sherman, Kansas, US | |
3366680 | 3366680 | 2022-07-02 | US | Kansas | Sherman | 20181 | 1537 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-07-03 04:20:59 | Sherman, Kansas, US | |
595009 | 595009 | 2022-07-01 | US | Kansas | Sherman | 20181 | 1537 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-07-02 04:21:16 | Sherman, Kansas, US | |
3941410 | 3941410 | 2022-06-30 | US | Kansas | Sherman | 20181 | 1537 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-07-01 04:21:10 | Sherman, Kansas, US | |
2491368 | 2491368 | 2022-06-29 | US | Kansas | Sherman | 20181 | 1537 | 22 | 0 | 39.35147699 | -101.7197624 | 2022-06-30 04:21:01 | Sherman, Kansas, US | |
2240722 | 2240722 | 2022-06-28 | US | Kansas | Morris | 20127 | 1537 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-29 04:20:59 | Morris, Kansas, US | |
2151194 | 2151194 | 2022-06-27 | US | Wisconsin | Iron | 55051 | 1537 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-06-28 04:20:58 | Iron, Wisconsin, US | |
2148964 | 2148964 | 2022-06-27 | US | Kansas | Morris | 20127 | 1537 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-28 04:20:58 | Morris, Kansas, US | |
476765 | 476765 | 2022-06-26 | US | Kansas | Morris | 20127 | 1537 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-27 04:21:00 | Morris, Kansas, US | |
940140 | 940140 | 2022-06-25 | US | Kansas | Morris | 20127 | 1537 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-26 04:21:02 | Morris, Kansas, US | |
939445 | 939445 | 2022-06-25 | US | Colorado | Huerfano | 8055 | 1537 | 37 | 0 | 37.68473101 | -104.9612585 | 2022-06-26 04:21:02 | Huerfano, Colorado, US | |
3348697 | 3348697 | 2022-06-24 | US | Nebraska | Clay | 31035 | 1537 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-06-25 04:20:57 | Clay, Nebraska, US | |
3347960 | 3347960 | 2022-06-24 | US | Kansas | Morris | 20127 | 1537 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-25 04:20:57 | Morris, Kansas, US | |
1650438 | 1650438 | 2022-06-23 | US | Nebraska | Clay | 31035 | 1537 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-06-24 04:20:58 | Clay, Nebraska, US | |
1649701 | 1649701 | 2022-06-23 | US | Kansas | Morris | 20127 | 1537 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-24 04:20:58 | Morris, Kansas, US | |
2189673 | 2189673 | 2022-06-22 | US | Nebraska | Clay | 31035 | 1537 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-06-23 04:20:55 | Clay, Nebraska, US | |
2188936 | 2188936 | 2022-06-22 | US | Kansas | Morris | 20127 | 1537 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-06-23 04:20:55 | Morris, Kansas, US | |
168104 | 168104 | 2022-06-21 | US | Nebraska | Clay | 31035 | 1537 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-06-22 04:20:54 | Clay, Nebraska, US | |
1765387 | 1765387 | 2022-06-20 | US | Nebraska | Clay | 31035 | 1537 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-06-21 04:20:56 | Clay, Nebraska, US | |
561229 | 561229 | 2022-06-16 | US | North Dakota | Ransom | 38073 | 1537 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-06-17 04:20:56 | Ransom, North Dakota, US | |
948035 | 948035 | 2022-06-14 | US | Iowa | Decatur | 19053 | 1537 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-15 04:20:54 | Decatur, Iowa, US | |
2980443 | 2980443 | 2022-06-13 | US | Iowa | Decatur | 19053 | 1537 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-14 04:20:52 | Decatur, Iowa, US | |
2236569 | 2236569 | 2022-06-12 | US | Iowa | Decatur | 19053 | 1537 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-13 04:21:14 | Decatur, Iowa, US | |
3142767 | 3142767 | 2022-06-11 | US | Iowa | Decatur | 19053 | 1537 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-12 04:20:53 | Decatur, Iowa, US | |
1945683 | 1945683 | 2022-06-10 | US | Iowa | Decatur | 19053 | 1537 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-11 04:21:01 | Decatur, Iowa, US | |
3158822 | 3158822 | 2022-06-09 | US | Iowa | Decatur | 19053 | 1537 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-10 04:20:55 | Decatur, Iowa, US | |
1422289 | 1422289 | 2022-06-08 | US | Iowa | Decatur | 19053 | 1537 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-06-09 04:20:54 | Decatur, Iowa, US | |
3135644 | 3135644 | 2022-06-03 | US | Nebraska | Keith | 31101 | 1537 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-06-04 04:20:58 | Keith, Nebraska, US | |
3580719 | 3580719 | 2022-06-02 | US | Nebraska | Keith | 31101 | 1537 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-06-03 04:20:58 | Keith, Nebraska, US | |
973012 | 973012 | 2022-06-01 | US | Nebraska | Keith | 31101 | 1537 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-06-02 05:20:39 | Keith, Nebraska, US | |
232271 | 232271 | 2022-05-31 | US | Texas | Carson | 48065 | 1537 | 36 | 0 | 35.40365929 | -101.3542669 | 2022-06-01 04:20:55 | Carson, Texas, US | |
231319 | 231319 | 2022-05-31 | US | Nebraska | Keith | 31101 | 1537 | 20 | 0 | 41.19930341 | -101.6620164 | 2022-06-01 04:20:55 | Keith, Nebraska, US | |
3189036 | 3189036 | 2022-05-30 | US | Texas | Carson | 48065 | 1537 | 36 | 0 | 35.40365929 | -101.3542669 | 2022-05-31 04:20:51 | Carson, Texas, US | |
3201185 | 3201185 | 2022-05-29 | US | Texas | Carson | 48065 | 1537 | 36 | 0 | 35.40365929 | -101.3542669 | 2022-05-30 04:20:50 | Carson, Texas, US | |
2728063 | 2728063 | 2022-05-28 | US | Texas | Carson | 48065 | 1537 | 36 | 0 | 35.40365929 | -101.3542669 | 2022-05-29 04:20:53 | Carson, Texas, US | |
1317244 | 1317244 | 2022-05-27 | US | Texas | Carson | 48065 | 1537 | 36 | 0 | 35.40365929 | -101.3542669 | 2022-05-28 04:21:07 | Carson, Texas, US | |
1112950 | 1112950 | 2022-05-21 | US | Virginia | Mathews | 51115 | 1537 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-05-22 04:20:52 | Mathews, Virginia, US | |
1172574 | 1172574 | 2022-05-20 | US | Virginia | Mathews | 51115 | 1537 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-05-21 04:20:58 | Mathews, Virginia, US | |
2084927 | 2084927 | 2022-05-15 | US | Illinois | Calhoun | 17013 | 1537 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-16 04:20:47 | Calhoun, Illinois, US | |
3355637 | 3355637 | 2022-05-14 | US | Illinois | Calhoun | 17013 | 1537 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-15 04:20:53 | Calhoun, Illinois, US | |
659282 | 659282 | 2022-05-13 | US | Illinois | Calhoun | 17013 | 1537 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-14 04:20:48 | Calhoun, Illinois, US | |
2534365 | 2534365 | 2022-05-12 | US | Illinois | Calhoun | 17013 | 1537 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-13 04:20:51 | Calhoun, Illinois, US | |
3447575 | 3447575 | 2022-05-11 | US | Puerto Rico | Ceiba | 72037 | 1537 | 0 | 0 | 18.251818 | -65.666416 | 2022-05-12 04:20:54 | Ceiba, Puerto Rico, US | |
3918067 | 3918067 | 2022-05-01 | US | Montana | Stillwater | 30095 | 1537 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-02 04:21:10 | Stillwater, Montana, US | |
2842871 | 2842871 | 2022-04-30 | US | Montana | Stillwater | 30095 | 1537 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-01 04:20:57 | Stillwater, Montana, US | |
1159184 | 1159184 | 2022-04-29 | US | Montana | Stillwater | 30095 | 1537 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-04-30 04:21:05 | Stillwater, Montana, US | |
3352745 | 3352745 | 2022-04-01 | US | Nebraska | Keith | 31101 | 1537 | 19 | 0 | 41.19930341 | -101.66201640000001 | 2022-04-02 04:20:47 | Keith, Nebraska, US | |
3823059 | 3823059 | 2022-02-16 | US | Oregon | Harney | 41025 | 1537 | 36 | 0 | 43.06422669 | -118.96663059999999 | 2022-02-17 04:20:56 | Harney, Oregon, US | |
1363586 | 1363586 | 2022-02-08 | US | Iowa | Pocahontas | 19151 | 1537 | 26 | 0 | 42.73420133 | -94.67862564 | 2022-02-09 04:21:04 | Pocahontas, Iowa, US | |
73020 | 73020 | 2022-02-07 | US | Missouri | Maries | 29125 | 1537 | 28 | 0 | 38.16193985 | -91.92249662 | 2022-02-08 04:21:15 | Maries, Missouri, US | |
72324 | 72324 | 2022-02-07 | US | Iowa | Pocahontas | 19151 | 1537 | 26 | 0 | 42.73420133 | -94.67862564 | 2022-02-08 04:21:15 | Pocahontas, Iowa, US | |
2013940 | 2013940 | 2022-02-06 | US | Iowa | Pocahontas | 19151 | 1537 | 26 | 0 | 42.73420133 | -94.67862564 | 2022-02-07 04:21:05 | Pocahontas, Iowa, US | |
1295269 | 1295269 | 2022-02-05 | US | Iowa | Pocahontas | 19151 | 1537 | 26 | 0 | 42.73420133 | -94.67862564 | 2022-02-06 04:21:00 | Pocahontas, Iowa, US | |
2328597 | 2328597 | 2022-02-04 | US | Iowa | Pocahontas | 19151 | 1537 | 26 | 0 | 42.73420133 | -94.67862564 | 2022-02-05 04:21:05 | Pocahontas, Iowa, US | |
2475188 | 2475188 | 2022-02-03 | US | Iowa | Pocahontas | 19151 | 1537 | 26 | 0 | 42.73420133 | -94.67862564 | 2022-02-04 04:21:10 | Pocahontas, Iowa, US | |
460613 | 460613 | 2022-02-02 | US | Iowa | Pocahontas | 19151 | 1537 | 26 | 0 | 42.73420133 | -94.67862564 | 2022-02-03 04:21:21 | Pocahontas, Iowa, US | |
2660843 | 2660843 | 2022-01-31 | US | Texas | Coleman | 48083 | 1537 | 64 | 0 | 31.76736834 | -99.45240766 | 2022-02-01 04:21:11 | Coleman, Texas, US | |
1229715 | 1229715 | 2022-01-24 | US | Nebraska | Merrick | 31121 | 1537 | 15 | 0 | 41.16624273 | -98.0374887 | 2022-01-25 04:21:05 | Merrick, Nebraska, US | |
1143782 | 1143782 | 2022-01-23 | US | South Dakota | Fall River | 46047 | 1537 | 34 | 0 | 43.23929297 | -103.5275691 | 2022-01-24 04:21:12 | Fall River, South Dakota, US | |
2835700 | 2835700 | 2022-01-22 | US | South Dakota | Fall River | 46047 | 1537 | 34 | 0 | 43.23929297 | -103.5275691 | 2022-01-23 04:21:13 | Fall River, South Dakota, US | |
3427818 | 3427818 | 2022-01-21 | US | South Dakota | Fall River | 46047 | 1537 | 34 | 0 | 43.23929297 | -103.5275691 | 2022-01-22 04:21:13 | Fall River, South Dakota, US | |
3466475 | 3466475 | 2022-01-18 | US | North Carolina | Camden | 37029 | 1537 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-01-19 04:21:23 | Camden, North Carolina, US | |
3690256 | 3690256 | 2022-01-13 | US | Puerto Rico | Sabana Grande | 72121 | 1537 | 0 | 0 | 18.08282 | -66.943758 | 2022-01-14 04:21:54 | Sabana Grande, Puerto Rico, US | |
1115977 | 1115977 | 2022-01-11 | US | North Dakota | Benson | 38005 | 1537 | 22 | 0 | 48.0683985 | -99.35916363 | 2022-01-12 04:21:44 | Benson, North Dakota, US | |
1694225 | 1694225 | 2022-01-10 | US | Missouri | Harrison | 29081 | 1537 | 26 | 0 | 40.35570088 | -93.99222144 | 2022-01-11 04:22:01 | Harrison, Missouri, US | |
1693141 | 1693141 | 2022-01-10 | US | Georgia | Irwin | 13155 | 1537 | 42 | 0 | 31.60213036 | -83.27501387 | 2022-01-11 04:22:01 | Irwin, Georgia, US | |
2612466 | 2612466 | 2022-01-06 | US | North Dakota | Pembina | 38067 | 1537 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-01-07 04:22:09 | Pembina, North Dakota, US | |
1289622 | 1289622 | 2022-01-04 | US | Wyoming | Sublette | 56035 | 1537 | 24 | 0 | 42.76558279 | -109.91309220000001 | 2022-01-05 04:21:59 | Sublette, Wyoming, US | |
1288764 | 1288764 | 2022-01-04 | US | Puerto Rico | Luquillo | 72089 | 1537 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-01-05 04:21:59 | Luquillo, Puerto Rico, US | |
3522459 | 3522459 | 2022-01-02 | US | Texas | Blanco | 48031 | 1537 | 28 | 0 | 30.26640707 | -98.3999852 | 2022-01-03 02:22:25 | Blanco, Texas, US | |
1435438 | 1435438 | 2021-12-28 | US | South Dakota | Grant | 46051 | 1537 | 47 | 0 | 45.1723937 | -96.77002276 | 2021-12-29 03:21:43 | Grant, South Dakota, 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]);