johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
333 rows where confirmed = 1810 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1966967 | 1966967 | 2022-11-30 | US | North Dakota | Bottineau | 38009 | 1810 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-12-01 04:21:03 | Bottineau, North Dakota, US | |
1240633 | 1240633 | 2022-11-28 | US | Illinois | Calhoun | 17013 | 1810 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-11-29 04:21:05 | Calhoun, Illinois, US | |
314326 | 314326 | 2022-11-13 | US | North Dakota | Ransom | 38073 | 1810 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-11-14 04:21:09 | Ransom, North Dakota, US | |
65487 | 65487 | 2022-11-12 | US | North Dakota | Ransom | 38073 | 1810 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-11-13 04:21:14 | Ransom, North Dakota, US | |
2929649 | 2929649 | 2022-11-11 | US | North Dakota | Ransom | 38073 | 1810 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-11-12 04:20:41 | Ransom, North Dakota, US | |
2508485 | 2508485 | 2022-11-10 | US | North Dakota | Ransom | 38073 | 1810 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-11-11 04:21:22 | Ransom, North Dakota, US | |
2433360 | 2433360 | 2022-11-09 | US | North Dakota | Ransom | 38073 | 1810 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-11-10 04:21:16 | Ransom, North Dakota, US | |
2025388 | 2025388 | 2022-10-17 | US | Colorado | Kit Carson | 8063 | 1810 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-10-18 04:22:42 | Kit Carson, Colorado, US | |
1979995 | 1979995 | 2022-09-25 | US | Virginia | Mathews | 51115 | 1810 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-09-26 04:20:52 | Mathews, Virginia, US | |
2653162 | 2653162 | 2022-09-24 | US | Virginia | Mathews | 51115 | 1810 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-09-25 04:23:31 | Mathews, Virginia, US | |
387602 | 387602 | 2022-09-23 | US | Virginia | Mathews | 51115 | 1810 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-09-24 04:21:40 | Mathews, Virginia, US | |
3546657 | 3546657 | 2022-08-08 | US | Texas | Marion | 48315 | 1810 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-08-09 04:20:34 | Marion, Texas, US | |
1406269 | 1406269 | 2022-08-02 | US | Iowa | Monona | 19133 | 1810 | 49 | 0 | 42.05220391 | -95.95743843 | 2022-08-03 04:20:59 | Monona, Iowa, US | |
3618307 | 3618307 | 2022-08-01 | US | Iowa | Monona | 19133 | 1810 | 49 | 0 | 42.05220391 | -95.95743843 | 2022-08-02 04:20:53 | Monona, Iowa, US | |
3617691 | 3617691 | 2022-08-01 | US | Colorado | Clear Creek | 8019 | 1810 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-08-02 04:20:53 | Clear Creek, Colorado, US | |
3872787 | 3872787 | 2022-07-31 | US | Iowa | Monona | 19133 | 1810 | 49 | 0 | 42.05220391 | -95.95743843 | 2022-08-01 04:21:03 | Monona, Iowa, US | |
675541 | 675541 | 2022-07-30 | US | Iowa | Monona | 19133 | 1810 | 49 | 0 | 42.05220391 | -95.95743843 | 2022-07-31 04:21:02 | Monona, Iowa, US | |
1784740 | 1784740 | 2022-07-29 | US | Iowa | Monona | 19133 | 1810 | 49 | 0 | 42.05220391 | -95.95743843 | 2022-07-30 04:20:42 | Monona, Iowa, US | |
1067103 | 1067103 | 2022-07-28 | US | Iowa | Monona | 19133 | 1810 | 49 | 0 | 42.05220391 | -95.95743843 | 2022-07-29 04:20:45 | Monona, Iowa, US | |
2336622 | 2336622 | 2022-07-27 | US | Iowa | Monona | 19133 | 1810 | 49 | 0 | 42.05220391 | -95.95743843 | 2022-07-28 04:20:56 | Monona, Iowa, US | |
1490467 | 1490467 | 2022-07-26 | US | South Dakota | Hutchinson | 46067 | 1810 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-07-27 04:21:04 | Hutchinson, South Dakota, US | |
2596913 | 2596913 | 2022-07-25 | US | South Dakota | Hutchinson | 46067 | 1810 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-07-26 04:20:58 | Hutchinson, South Dakota, US | |
899028 | 899028 | 2022-07-24 | US | South Dakota | Hutchinson | 46067 | 1810 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-07-25 04:20:51 | Hutchinson, South Dakota, US | |
94022 | 94022 | 2022-07-23 | US | South Dakota | Hutchinson | 46067 | 1810 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-07-24 04:20:47 | Hutchinson, South Dakota, US | |
903044 | 903044 | 2022-07-22 | US | South Dakota | Hutchinson | 46067 | 1810 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-07-23 04:20:53 | Hutchinson, South Dakota, US | |
673180 | 673180 | 2022-07-21 | US | South Dakota | Hutchinson | 46067 | 1810 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-07-22 04:21:15 | Hutchinson, South Dakota, US | |
1611143 | 1611143 | 2022-07-20 | US | South Dakota | Hutchinson | 46067 | 1810 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-07-21 04:21:10 | Hutchinson, South Dakota, US | |
1649031 | 1649031 | 2022-06-23 | US | Colorado | Rio Blanco | 8103 | 1810 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-24 04:20:58 | Rio Blanco, Colorado, US | |
2188266 | 2188266 | 2022-06-22 | US | Colorado | Rio Blanco | 8103 | 1810 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-23 04:20:55 | Rio Blanco, Colorado, US | |
166831 | 166831 | 2022-06-21 | US | Georgia | Crawford | 13079 | 1810 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-06-22 04:20:54 | Crawford, Georgia, US | |
1764114 | 1764114 | 2022-06-20 | US | Georgia | Crawford | 13079 | 1810 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-06-21 04:20:56 | Crawford, Georgia, US | |
3270300 | 3270300 | 2022-06-19 | US | Georgia | Crawford | 13079 | 1810 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-06-20 04:21:01 | Crawford, Georgia, US | |
3398212 | 3398212 | 2022-06-18 | US | Georgia | Crawford | 13079 | 1810 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-06-19 04:20:51 | Crawford, Georgia, US | |
2312089 | 2312089 | 2022-06-17 | US | Georgia | Crawford | 13079 | 1810 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-06-18 04:21:10 | Crawford, Georgia, US | |
559593 | 559593 | 2022-06-16 | US | Georgia | Crawford | 13079 | 1810 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-06-17 04:20:56 | Crawford, Georgia, US | |
3983395 | 3983395 | 2022-06-15 | US | Georgia | Crawford | 13079 | 1810 | 55 | 0 | 32.71391813 | -83.98061238 | 2022-06-16 04:20:55 | Crawford, Georgia, US | |
3136314 | 3136314 | 2022-06-03 | US | Puerto Rico | Maunabo | 72095 | 1810 | 0 | 0 | 18.017889 | -65.922235 | 2022-06-04 04:20:58 | Maunabo, Puerto Rico, US | |
3596335 | 3596335 | 2022-05-23 | US | Virginia | Bland | 51021 | 1810 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-05-24 04:20:57 | Bland, Virginia, US | |
1186485 | 1186485 | 2022-05-18 | US | Minnesota | Mahnomen | 27087 | 1810 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-05-19 04:20:54 | Mahnomen, Minnesota, US | |
3725565 | 3725565 | 2022-04-25 | US | Virginia | Lancaster | 51103 | 1810 | 31 | 0 | 37.71889653 | -76.46400482 | 2022-04-26 04:20:51 | Lancaster, Virginia, US | |
2252630 | 2252630 | 2022-04-19 | US | Iowa | Ida | 19093 | 1810 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-04-20 04:20:45 | Ida, Iowa, US | |
1847180 | 1847180 | 2022-04-18 | US | Iowa | Ida | 19093 | 1810 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-04-19 04:21:00 | Ida, Iowa, US | |
3418124 | 3418124 | 2022-04-17 | US | Iowa | Ida | 19093 | 1810 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-04-18 04:21:12 | Ida, Iowa, US | |
305073 | 305073 | 2022-04-16 | US | Iowa | Ida | 19093 | 1810 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-04-17 04:20:59 | Ida, Iowa, US | |
2671018 | 2671018 | 2022-04-15 | US | Iowa | Ida | 19093 | 1810 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-04-16 04:20:48 | Ida, Iowa, US | |
1224803 | 1224803 | 2022-04-14 | US | Iowa | Ida | 19093 | 1810 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-04-15 04:20:57 | Ida, Iowa, US | |
2443961 | 2443961 | 2022-04-13 | US | Iowa | Ida | 19093 | 1810 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-04-13 23:21:06 | Ida, Iowa, US | |
1655466 | 1655466 | 2022-04-09 | US | Texas | Delta | 48119 | 1810 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-10 04:20:52 | Delta, Texas, US | |
2118788 | 2118788 | 2022-04-08 | US | Texas | Delta | 48119 | 1810 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-09 04:20:42 | Delta, Texas, US | |
3323312 | 3323312 | 2022-04-07 | US | Texas | Delta | 48119 | 1810 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-08 04:20:48 | Delta, Texas, US | |
2803848 | 2803848 | 2022-04-06 | US | Texas | Delta | 48119 | 1810 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-07 04:20:53 | Delta, Texas, US | |
3870617 | 3870617 | 2022-04-05 | US | Texas | Delta | 48119 | 1810 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-06 04:20:49 | Delta, Texas, US | |
879641 | 879641 | 2022-03-27 | US | Virginia | Middlesex | 51119 | 1810 | 45 | 0 | 37.63191998 | -76.55064617 | 2022-03-28 04:20:33 | Middlesex, Virginia, US | |
2166924 | 2166924 | 2022-03-26 | US | Virginia | Middlesex | 51119 | 1810 | 45 | 0 | 37.63191998 | -76.55064617 | 2022-03-27 04:20:47 | Middlesex, Virginia, US | |
1723860 | 1723860 | 2022-03-25 | US | Virginia | Middlesex | 51119 | 1810 | 45 | 0 | 37.63191998 | -76.55064617 | 2022-03-26 04:20:23 | Middlesex, Virginia, US | |
1471477 | 1471477 | 2022-03-24 | US | Virginia | Middlesex | 51119 | 1810 | 45 | 0 | 37.63191998 | -76.55064617 | 2022-03-25 04:20:46 | Middlesex, Virginia, US | |
2265799 | 2265799 | 2022-03-14 | US | Missouri | Harrison | 29081 | 1810 | 30 | 0 | 40.35570088 | -93.99222144 | 2022-03-15 04:20:47 | Harrison, Missouri, US | |
3859034 | 3859034 | 2022-02-18 | US | Texas | Rains | 48379 | 1810 | 56 | 0 | 32.87109387 | -95.79232691 | 2022-02-19 04:21:11 | Rains, Texas, US | |
1301312 | 1301312 | 2022-02-17 | US | Texas | Winkler | 48495 | 1810 | 34 | 0 | 31.85008651 | -103.04851629999999 | 2022-02-18 04:21:04 | Winkler, Texas, US | |
74269 | 74269 | 2022-02-07 | US | Texas | Mitchell | 48335 | 1810 | 46 | 0 | 32.30623474 | -100.9212058 | 2022-02-08 04:21:15 | Mitchell, Texas, US | |
2015885 | 2015885 | 2022-02-06 | US | Texas | Mitchell | 48335 | 1810 | 46 | 0 | 32.30623474 | -100.9212058 | 2022-02-07 04:21:05 | Mitchell, Texas, US | |
462887 | 462887 | 2022-02-02 | US | West Virginia | Pocahontas | 54075 | 1810 | 25 | 0 | 38.32758728 | -80.00993811 | 2022-02-03 04:21:21 | Pocahontas, West Virginia, US | |
982563 | 982563 | 2022-02-01 | US | Wyoming | Platte | 56031 | 1810 | 38 | 0 | 42.13299116 | -104.96633100000001 | 2022-02-02 04:21:09 | Platte, Wyoming, US | |
980291 | 980291 | 2022-02-01 | US | Kansas | Russell | 20167 | 1810 | 35 | 0 | 38.91462787 | -98.76254297 | 2022-02-02 04:21:09 | Russell, Kansas, US | |
979099 | 979099 | 2022-02-01 | Palau | 1810 | 0 | 0 | 7.515 | 134.5825 | 2022-02-02 04:21:09 | Palau | ||||
2659133 | 2659133 | 2022-01-31 | US | Kansas | Russell | 20167 | 1810 | 35 | 0 | 38.91462787 | -98.76254297 | 2022-02-01 04:21:11 | Russell, Kansas, US | |
3303521 | 3303521 | 2022-01-30 | US | Virginia | Buena Vista | 51530 | 1810 | 36 | 0 | 37.73484642 | -79.35296097 | 2022-01-31 04:21:09 | Buena Vista, Virginia, US | |
3065312 | 3065312 | 2022-01-29 | US | Virginia | Buena Vista | 51530 | 1810 | 36 | 0 | 37.73484642 | -79.35296097 | 2022-01-30 04:21:26 | Buena Vista, Virginia, US | |
3813246 | 3813246 | 2022-01-28 | US | Virginia | Buena Vista | 51530 | 1810 | 36 | 0 | 37.73484642 | -79.35296097 | 2022-01-29 04:21:10 | Buena Vista, Virginia, US | |
1320025 | 1320025 | 2022-01-26 | US | Mississippi | Humphreys | 28053 | 1810 | 39 | 0 | 33.12825718 | -90.52252707 | 2022-01-27 04:21:19 | Humphreys, Mississippi, US | |
1319361 | 1319361 | 2022-01-26 | US | Indiana | Union | 18161 | 1810 | 20 | 0 | 39.62550777 | -84.92497066 | 2022-01-27 04:21:19 | Union, Indiana, US | |
1319095 | 1319095 | 2022-01-26 | US | Georgia | Taylor | 13269 | 1810 | 47 | 0 | 32.55792548 | -84.25077141 | 2022-01-27 04:21:19 | Taylor, Georgia, US | |
1142623 | 1142623 | 2022-01-23 | US | Minnesota | Clearwater | 27029 | 1810 | 27 | 0 | 47.57992111 | -95.37790562 | 2022-01-24 04:21:12 | Clearwater, Minnesota, US | |
2834541 | 2834541 | 2022-01-22 | US | Minnesota | Clearwater | 27029 | 1810 | 27 | 0 | 47.57992111 | -95.37790562 | 2022-01-23 04:21:13 | Clearwater, Minnesota, US | |
3427689 | 3427689 | 2022-01-21 | US | Puerto Rico | Florida | 72054 | 1810 | 0 | 0 | 18.373715 | -66.560488 | 2022-01-22 04:21:13 | Florida, Puerto Rico, US | |
3426659 | 3426659 | 2022-01-21 | US | Minnesota | Clearwater | 27029 | 1810 | 27 | 0 | 47.57992111 | -95.37790562 | 2022-01-22 04:21:13 | Clearwater, Minnesota, US | |
1472979 | 1472979 | 2022-01-17 | US | Georgia | Pulaski | 13235 | 1810 | 68 | 0 | 32.23334561 | -83.47549959999998 | 2022-01-18 04:21:04 | Pulaski, Georgia, US | |
3614853 | 3614853 | 2022-01-12 | US | Mississippi | Benton | 28009 | 1810 | 42 | 0 | 34.81681228 | -89.18945516 | 2022-01-13 08:00:09 | Benton, Mississippi, US | |
1390598 | 1390598 | 2022-01-07 | US | Idaho | Fremont | 16043 | 1810 | 20 | 0 | 44.22800938 | -111.48099429999999 | 2022-01-08 04:21:53 | Fremont, Idaho, US | |
1287285 | 1287285 | 2022-01-04 | US | Kansas | Doniphan | 20043 | 1810 | 31 | 0 | 39.79067154 | -95.14056866 | 2022-01-05 04:21:59 | Doniphan, Kansas, US | |
1701629 | 1701629 | 2022-01-03 | US | Kansas | Doniphan | 20043 | 1810 | 31 | 0 | 39.79067154 | -95.14056866 | 2022-01-04 04:22:17 | Doniphan, Kansas, US | |
1669295 | 1669295 | 2021-12-29 | US | Georgia | Long | 13183 | 1810 | 29 | 0 | 31.75218791 | -81.74952375 | 2021-12-30 04:21:25 | Long, Georgia, US | |
1434919 | 1434919 | 2021-12-28 | US | North Carolina | Pamlico | 37137 | 1810 | 26 | 0 | 35.15253315 | -76.66559823 | 2021-12-29 03:21:43 | Pamlico, North Carolina, US | |
730939 | 730939 | 2021-12-27 | US | Alabama | Wilcox | 1131 | 1810 | 38 | 0 | 31.98773215 | -87.30891118 | 2021-12-28 04:21:47 | Wilcox, Alabama, US | |
2112111 | 2112111 | 2021-12-26 | US | Alabama | Wilcox | 1131 | 1810 | 38 | 0 | 31.98773215 | -87.30891118 | 2021-12-27 04:21:58 | Wilcox, Alabama, US | |
2905486 | 2905486 | 2021-12-19 | US | Minnesota | Stevens | 27149 | 1810 | 11 | 0 | 45.58613007 | -96.00163705 | 2021-12-20 04:21:43 | Stevens, Minnesota, US | |
1260559 | 1260559 | 2021-12-18 | US | Minnesota | Stevens | 27149 | 1810 | 11 | 0 | 45.58613007 | -96.00163705 | 2021-12-19 04:21:11 | Stevens, Minnesota, US | |
2400587 | 2400587 | 2021-12-17 | US | Minnesota | Stevens | 27149 | 1810 | 11 | 0 | 45.58613007 | -96.00163705 | 2021-12-18 02:22:20 | Stevens, Minnesota, US | |
1717291 | 1717291 | 2021-12-16 | US | Idaho | Franklin | 16041 | 1810 | 26 | 0 | 42.18332217 | -111.81496659999999 | 2021-12-17 04:22:14 | Franklin, Idaho, US | |
785062 | 785062 | 2021-12-13 | US | Pennsylvania | Forest | 42053 | 1810 | 30 | 0 | 41.51095103 | -79.23229292 | 2021-12-14 04:22:38 | Forest, Pennsylvania, US | |
404940 | 404940 | 2021-12-07 | US | Colorado | Park | 8093 | 1810 | 15 | 0 | 39.120926000000004 | -105.7182065 | 2021-12-08 04:22:46 | Park, Colorado, US | |
1033663 | 1033663 | 2021-12-06 | US | Vermont | Lamoille | 50015 | 1810 | 9 | 0 | 44.60353043 | -72.64356694 | 2021-12-07 04:22:34 | Lamoille, Vermont, US | |
2197053 | 2197053 | 2021-12-03 | US | Kentucky | Lee | 21129 | 1810 | 37 | 0 | 37.59645942 | -83.71513901 | 2021-12-04 04:22:18 | Lee, Kentucky, US | |
3072551 | 3072551 | 2021-11-23 | US | Ohio | Vinton | 39163 | 1810 | 40 | 0 | 39.25208988 | -82.4831444 | 2021-11-24 04:22:14 | Vinton, Ohio, US | |
1016166 | 1016166 | 2021-11-21 | US | Mississippi | Montgomery | 28097 | 1810 | 57 | 0 | 33.49419589 | -89.61729103 | 2021-11-22 04:22:20 | Montgomery, Mississippi, US | |
724330 | 724330 | 2021-11-20 | US | Mississippi | Montgomery | 28097 | 1810 | 57 | 0 | 33.49419589 | -89.61729103 | 2021-11-21 04:22:13 | Montgomery, Mississippi, US | |
163860 | 163860 | 2021-11-19 | US | Mississippi | Montgomery | 28097 | 1810 | 57 | 0 | 33.49419589 | -89.61729103 | 2021-11-20 04:22:17 | Montgomery, Mississippi, US | |
3290747 | 3290747 | 2021-11-18 | US | Mississippi | Montgomery | 28097 | 1810 | 57 | 0 | 33.49419589 | -89.61729103 | 2021-11-19 04:21:40 | Montgomery, Mississippi, US | |
449203 | 449203 | 2021-11-17 | US | Mississippi | Montgomery | 28097 | 1810 | 57 | 0 | 33.49419589 | -89.61729103 | 2021-11-18 04:21:33 | Montgomery, Mississippi, US | |
3345478 | 3345478 | 2021-11-16 | US | South Dakota | Charles Mix | 46023 | 1810 | 27 | 0 | 43.20660134 | -98.58856175 | 2021-11-17 04:21:48 | Charles Mix, 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]);