johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
346 rows where confirmed = 1955 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2179432 | 2179432 | 2022-12-22 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-23 04:21:04 | Vaupes, Colombia | |||
451236 | 451236 | 2022-12-21 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-22 04:20:56 | Vaupes, Colombia | |||
2951235 | 2951235 | 2022-12-20 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-21 04:21:03 | Vaupes, Colombia | |||
3173637 | 3173637 | 2022-12-19 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-20 04:21:04 | Vaupes, Colombia | |||
1628154 | 1628154 | 2022-12-18 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-19 04:21:03 | Vaupes, Colombia | |||
503533 | 503533 | 2022-12-17 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-18 04:21:03 | Vaupes, Colombia | |||
3324105 | 3324105 | 2022-12-16 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-17 04:21:04 | Vaupes, Colombia | |||
542617 | 542617 | 2022-12-15 | Colombia | Vaupes | 1955 | 22 | 0 | 0.8554 | -70.812 | 2022-12-16 04:21:01 | Vaupes, Colombia | |||
295069 | 295069 | 2022-11-15 | US | Texas | Coleman | 48083 | 1955 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-11-16 04:21:09 | Coleman, Texas, US | |
293211 | 293211 | 2022-11-15 | US | Iowa | Greene | 19073 | 1955 | 26 | 0 | 42.03614551 | -94.39658081 | 2022-11-16 04:21:09 | Greene, Iowa, US | |
3600099 | 3600099 | 2022-11-14 | US | Texas | Coleman | 48083 | 1955 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-11-15 04:21:16 | Coleman, Texas, US | |
3598241 | 3598241 | 2022-11-14 | US | Iowa | Greene | 19073 | 1955 | 26 | 0 | 42.03614551 | -94.39658081 | 2022-11-15 04:21:16 | Greene, Iowa, US | |
313099 | 313099 | 2022-11-13 | US | Iowa | Greene | 19073 | 1955 | 26 | 0 | 42.03614551 | -94.39658081 | 2022-11-14 04:21:09 | Greene, Iowa, US | |
64260 | 64260 | 2022-11-12 | US | Iowa | Greene | 19073 | 1955 | 26 | 0 | 42.03614551 | -94.39658081 | 2022-11-13 04:21:14 | Greene, Iowa, US | |
2928422 | 2928422 | 2022-11-11 | US | Iowa | Greene | 19073 | 1955 | 26 | 0 | 42.03614551 | -94.39658081 | 2022-11-12 04:20:41 | Greene, Iowa, US | |
2507258 | 2507258 | 2022-11-10 | US | Iowa | Greene | 19073 | 1955 | 26 | 0 | 42.03614551 | -94.39658081 | 2022-11-11 04:21:22 | Greene, Iowa, US | |
2432133 | 2432133 | 2022-11-09 | US | Iowa | Greene | 19073 | 1955 | 26 | 0 | 42.03614551 | -94.39658081 | 2022-11-10 04:21:16 | Greene, Iowa, US | |
1052877 | 1052877 | 2022-11-06 | US | Texas | Brooks | 48047 | 1955 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-07 04:21:26 | Brooks, Texas, US | |
620901 | 620901 | 2022-11-05 | US | Texas | Brooks | 48047 | 1955 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-06 04:21:24 | Brooks, Texas, US | |
1025405 | 1025405 | 2022-11-04 | US | Texas | Brooks | 48047 | 1955 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-11-05 04:21:52 | Brooks, Texas, US | |
3287087 | 3287087 | 2022-10-31 | US | New Jersey | Unassigned | 90034 | 1955 | 0 | 0 | 41.13891592 | 0.0 | 2022-11-01 04:22:36 | Unassigned, New Jersey, US | |
1831414 | 1831414 | 2022-10-25 | US | Iowa | Worth | 19195 | 1955 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-10-26 04:22:19 | Worth, Iowa, US | |
795675 | 795675 | 2022-10-24 | US | Iowa | Worth | 19195 | 1955 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-10-25 04:21:53 | Worth, Iowa, US | |
3278130 | 3278130 | 2022-10-23 | US | Iowa | Worth | 19195 | 1955 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-10-24 04:22:29 | Worth, Iowa, US | |
2269168 | 2269168 | 2022-10-22 | US | Iowa | Worth | 19195 | 1955 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-10-23 04:22:46 | Worth, Iowa, US | |
1593468 | 1593468 | 2022-10-21 | US | Iowa | Worth | 19195 | 1955 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-10-22 04:22:53 | Worth, Iowa, US | |
2273184 | 2273184 | 2022-10-20 | US | Iowa | Worth | 19195 | 1955 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-10-21 04:22:23 | Worth, Iowa, US | |
199519 | 199519 | 2022-10-19 | US | Iowa | Worth | 19195 | 1955 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-10-20 04:22:59 | Worth, Iowa, US | |
1813323 | 1813323 | 2022-10-05 | US | Oklahoma | Coal | 40029 | 1955 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-06 04:21:22 | Coal, Oklahoma, US | |
133297 | 133297 | 2022-10-04 | US | Oklahoma | Coal | 40029 | 1955 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-05 04:23:06 | Coal, Oklahoma, US | |
2688244 | 2688244 | 2022-10-03 | US | Oklahoma | Coal | 40029 | 1955 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-04 04:22:55 | Coal, Oklahoma, US | |
2262311 | 2262311 | 2022-10-02 | US | Oklahoma | Coal | 40029 | 1955 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-03 04:23:11 | Coal, Oklahoma, US | |
2997837 | 2997837 | 2022-10-01 | US | Oklahoma | Coal | 40029 | 1955 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-02 04:21:23 | Coal, Oklahoma, US | |
856163 | 856163 | 2022-09-30 | US | Oklahoma | Coal | 40029 | 1955 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-01 04:23:01 | Coal, Oklahoma, US | |
2378089 | 2378089 | 2022-09-29 | US | Oklahoma | Coal | 40029 | 1955 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-09-30 04:23:09 | Coal, Oklahoma, US | |
115957 | 115957 | 2022-09-06 | US | Iowa | Ida | 19093 | 1955 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-07 04:20:59 | Ida, Iowa, US | |
2634929 | 2634929 | 2022-09-05 | US | Iowa | Ida | 19093 | 1955 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-06 04:21:02 | Ida, Iowa, US | |
2988493 | 2988493 | 2022-09-04 | US | Iowa | Ida | 19093 | 1955 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-05 04:21:01 | Ida, Iowa, US | |
2714178 | 2714178 | 2022-09-03 | US | Iowa | Ida | 19093 | 1955 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-04 04:21:22 | Ida, Iowa, US | |
1394883 | 1394883 | 2022-09-02 | US | Iowa | Ida | 19093 | 1955 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-03 04:21:04 | Ida, Iowa, US | |
3548712 | 3548712 | 2022-09-01 | US | Iowa | Ida | 19093 | 1955 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-02 04:21:07 | Ida, Iowa, US | |
2344632 | 2344632 | 2022-08-31 | US | Iowa | Ida | 19093 | 1955 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-09-01 04:21:03 | Ida, Iowa, US | |
992338 | 992338 | 2022-08-16 | US | Kansas | Russell | 20167 | 1955 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-17 04:20:59 | Russell, Kansas, US | |
2495377 | 2495377 | 2022-08-15 | US | Kansas | Russell | 20167 | 1955 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-16 04:20:58 | Russell, Kansas, US | |
3648927 | 3648927 | 2022-08-14 | US | Kansas | Russell | 20167 | 1955 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-15 04:20:59 | Russell, Kansas, US | |
1969933 | 1969933 | 2022-08-13 | US | Kansas | Russell | 20167 | 1955 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-14 04:20:55 | Russell, Kansas, US | |
2889742 | 2889742 | 2022-08-12 | US | Kansas | Russell | 20167 | 1955 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-13 04:20:52 | Russell, Kansas, US | |
3909347 | 3909347 | 2022-08-11 | US | Kansas | Russell | 20167 | 1955 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-12 04:20:54 | Russell, Kansas, US | |
1347664 | 1347664 | 2022-08-10 | US | Kansas | Russell | 20167 | 1955 | 38 | 0 | 38.91462787 | -98.76254297 | 2022-08-11 04:20:49 | Russell, Kansas, US | |
1073154 | 1073154 | 2022-08-07 | US | Texas | Winkler | 48495 | 1955 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-08 04:21:08 | Winkler, Texas, US | |
1943742 | 1943742 | 2022-08-06 | US | Texas | Winkler | 48495 | 1955 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-07 04:20:54 | Winkler, Texas, US | |
883541 | 883541 | 2022-08-05 | US | Texas | Winkler | 48495 | 1955 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-06 04:20:56 | Winkler, Texas, US | |
1490788 | 1490788 | 2022-07-26 | US | Texas | Rains | 48379 | 1955 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-07-27 04:21:04 | Rains, Texas, US | |
3969421 | 3969421 | 2022-07-05 | US | South Dakota | Fall River | 46047 | 1955 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-07-06 04:20:58 | Fall River, South Dakota, US | |
3080932 | 3080932 | 2022-07-04 | US | South Dakota | Fall River | 46047 | 1955 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-07-05 04:20:45 | Fall River, South Dakota, US | |
1770214 | 1770214 | 2022-07-03 | US | South Dakota | Fall River | 46047 | 1955 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-07-04 04:20:54 | Fall River, South Dakota, US | |
3368200 | 3368200 | 2022-07-02 | US | South Dakota | Fall River | 46047 | 1955 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-07-03 04:20:59 | Fall River, South Dakota, US | |
596529 | 596529 | 2022-07-01 | US | South Dakota | Fall River | 46047 | 1955 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-07-02 04:21:16 | Fall River, South Dakota, US | |
3942930 | 3942930 | 2022-06-30 | US | South Dakota | Fall River | 46047 | 1955 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-07-01 04:21:10 | Fall River, South Dakota, US | |
2492888 | 2492888 | 2022-06-29 | US | South Dakota | Fall River | 46047 | 1955 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-06-30 04:21:01 | Fall River, South Dakota, US | |
476053 | 476053 | 2022-06-26 | US | Colorado | Conejos | 8021 | 1955 | 57 | 0 | 37.201606 | -106.1917488 | 2022-06-27 04:21:00 | Conejos, Colorado, US | |
2982635 | 2982635 | 2022-06-13 | US | Virginia | Middlesex | 51119 | 1955 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-06-14 04:20:52 | Middlesex, Virginia, US | |
3186656 | 3186656 | 2022-05-30 | US | Colorado | Yuma | 8125 | 1955 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-05-31 04:20:51 | Yuma, Colorado, US | |
3439917 | 3439917 | 2022-04-22 | US | Texas | Floyd | 48153 | 1955 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-04-23 04:20:50 | Floyd, Texas, US | |
2445323 | 2445323 | 2022-04-13 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-13 23:21:06 | Kiowa, Oklahoma, US | |
1951080 | 1951080 | 2022-04-12 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-13 04:21:03 | Kiowa, Oklahoma, US | |
1949559 | 1949559 | 2022-04-12 | US | Illinois | Schuyler | 17169 | 1955 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-04-13 04:21:03 | Schuyler, Illinois, US | |
3208833 | 3208833 | 2022-04-11 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-12 04:20:49 | Kiowa, Oklahoma, US | |
3207312 | 3207312 | 2022-04-11 | US | Illinois | Schuyler | 17169 | 1955 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-04-12 04:20:49 | Schuyler, Illinois, US | |
1578719 | 1578719 | 2022-04-10 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-11 04:21:02 | Kiowa, Oklahoma, US | |
1577198 | 1577198 | 2022-04-10 | US | Illinois | Schuyler | 17169 | 1955 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-04-11 04:21:02 | Schuyler, Illinois, US | |
1654961 | 1654961 | 2022-04-09 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-10 04:20:52 | Kiowa, Oklahoma, US | |
1653440 | 1653440 | 2022-04-09 | US | Illinois | Schuyler | 17169 | 1955 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-04-10 04:20:52 | Schuyler, Illinois, US | |
2118283 | 2118283 | 2022-04-08 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-09 04:20:42 | Kiowa, Oklahoma, US | |
2116762 | 2116762 | 2022-04-08 | US | Illinois | Schuyler | 17169 | 1955 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-04-09 04:20:42 | Schuyler, Illinois, US | |
3322807 | 3322807 | 2022-04-07 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-08 04:20:48 | Kiowa, Oklahoma, US | |
2803343 | 2803343 | 2022-04-06 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-07 04:20:53 | Kiowa, Oklahoma, US | |
3870112 | 3870112 | 2022-04-05 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-06 04:20:49 | Kiowa, Oklahoma, US | |
2751454 | 2751454 | 2022-04-04 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-05 04:20:48 | Kiowa, Oklahoma, US | |
3732800 | 3732800 | 2022-04-03 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-04 04:20:51 | Kiowa, Oklahoma, US | |
502235 | 502235 | 2022-04-02 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-03 04:20:48 | Kiowa, Oklahoma, US | |
3353220 | 3353220 | 2022-04-01 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-02 04:20:47 | Kiowa, Oklahoma, US | |
1542525 | 1542525 | 2022-03-31 | US | Oklahoma | Kiowa | 40075 | 1955 | 51 | 0 | 34.91671958 | -98.97720696 | 2022-04-01 04:20:28 | Kiowa, Oklahoma, US | |
1471436 | 1471436 | 2022-03-24 | US | Virginia | Falls Church | 51610 | 1955 | 16 | 0 | 38.88485255 | -77.17560759 | 2022-03-25 04:20:46 | Falls Church, Virginia, US | |
2266279 | 2266279 | 2022-03-14 | US | North Dakota | Benson | 38005 | 1955 | 22 | 0 | 48.0683985 | -99.35916363 | 2022-03-15 04:20:47 | Benson, North Dakota, US | |
3630345 | 3630345 | 2022-03-13 | US | North Dakota | Benson | 38005 | 1955 | 22 | 0 | 48.0683985 | -99.35916363 | 2022-03-14 04:20:46 | Benson, North Dakota, US | |
953253 | 953253 | 2022-03-12 | US | North Dakota | Benson | 38005 | 1955 | 22 | 0 | 48.0683985 | -99.35916363 | 2022-03-13 04:20:49 | Benson, North Dakota, US | |
358714 | 358714 | 2022-03-11 | US | North Dakota | Benson | 38005 | 1955 | 22 | 0 | 48.0683985 | -99.35916363 | 2022-03-12 04:20:50 | Benson, North Dakota, US | |
1867866 | 1867866 | 2022-03-10 | US | North Dakota | Benson | 38005 | 1955 | 22 | 0 | 48.0683985 | -99.35916363 | 2022-03-11 04:20:50 | Benson, North Dakota, US | |
1646781 | 1646781 | 2022-03-03 | US | North Dakota | Pembina | 38067 | 1955 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-03-04 04:21:09 | Pembina, North Dakota, US | |
1995767 | 1995767 | 2022-03-01 | US | Texas | Hamilton | 48193 | 1955 | 31 | 0 | 31.70470573 | -98.11083887 | 2022-03-02 04:21:07 | Hamilton, Texas, US | |
2735086 | 2735086 | 2022-02-27 | US | Nebraska | Custer | 31041 | 1955 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-02-28 04:21:05 | Custer, Nebraska, US | |
3048239 | 3048239 | 2022-02-26 | US | Nebraska | Custer | 31041 | 1955 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-02-27 04:21:04 | Custer, Nebraska, US | |
576894 | 576894 | 2022-02-25 | US | Nebraska | Custer | 31041 | 1955 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-02-26 04:21:12 | Custer, Nebraska, US | |
1513470 | 1513470 | 2022-02-24 | US | Nebraska | Custer | 31041 | 1955 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-02-25 04:21:11 | Custer, Nebraska, US | |
3720172 | 3720172 | 2022-02-21 | US | Montana | Blaine | 30005 | 1955 | 30 | 0 | 48.43175214 | -108.9582723 | 2022-02-22 04:21:01 | Blaine, Montana, US | |
3914006 | 3914006 | 2022-02-20 | US | Montana | Blaine | 30005 | 1955 | 30 | 0 | 48.43175214 | -108.9582723 | 2022-02-21 04:21:05 | Blaine, Montana, US | |
3912900 | 3912900 | 2022-02-20 | US | Georgia | Taylor | 13269 | 1955 | 49 | 0 | 32.55792548 | -84.25077141 | 2022-02-21 04:21:05 | Taylor, Georgia, US | |
3877564 | 3877564 | 2022-02-19 | US | Montana | Blaine | 30005 | 1955 | 30 | 0 | 48.43175214 | -108.9582723 | 2022-02-20 04:21:00 | Blaine, Montana, US | |
3876458 | 3876458 | 2022-02-19 | US | Georgia | Taylor | 13269 | 1955 | 49 | 0 | 32.55792548 | -84.25077141 | 2022-02-20 04:21:00 | Taylor, Georgia, 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]);