johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where active = 2053 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Illinois 7
- Texas 6
- Georgia 5
- Alabama 4
- Mississippi 4
- North Carolina 4
- Florida 3
- Iowa 3
- Kentucky 3
- Michigan 3
- Minnesota 3
- Missouri 3
- Virginia 3
- Indiana 2
- Ohio 2
- Tennessee 2
- West Virginia 2
- Wisconsin 2
- Alaska 1
- California 1
- Colorado 1
- Hawaii 1
- Kansas 1
- Louisiana 1
- Maine 1
- Massachusetts 1
- New Mexico 1
- New York 1
- North Dakota 1
- Pennsylvania 1
- …
country_or_region 1
- US · 75 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1616613 | 1616613 | 2021-03-05 | US | Alabama | Hale | 1065 | 2122 | 69 | 0 | 2053 | 32.76039258 | -87.63284988 | 2021-03-06 04:23:41 | Hale, Alabama, US |
2208024 | 2208024 | 2021-03-04 | US | Alabama | Hale | 1065 | 2122 | 69 | 0 | 2053 | 32.76039258 | -87.63284988 | 2021-03-05 05:26:29 | Hale, Alabama, US |
1001786 | 1001786 | 2021-03-01 | US | Virginia | Hopewell | 51670 | 2100 | 47 | 0 | 2053 | 37.29186313 | -77.29754684 | 2021-03-02 05:23:30 | Hopewell, Virginia, US |
1859428 | 1859428 | 2021-02-25 | US | Kentucky | Lincoln | 21137 | 2085 | 32 | 0 | 2053 | 37.45475628 | -84.6565327 | 2021-02-26 05:22:40 | Lincoln, Kentucky, US |
283436 | 283436 | 2021-02-24 | US | Texas | Young | 48503 | 2076 | 38 | 0 | 2053 | 33.17659707 | -98.68790885 | 2021-02-25 05:24:57 | Young, Texas, US |
2284855 | 2284855 | 2021-02-14 | US | Kentucky | Marion | 21155 | 2076 | 23 | 0 | 2053 | 37.55218078 | -85.26898542 | 2021-02-15 05:24:49 | Marion, Kentucky, US |
2638759 | 2638759 | 2021-02-11 | US | Illinois | Shelby | 17173 | 2086 | 33 | 0 | 2053 | 39.39133527 | -88.80611122 | 2021-02-12 05:23:29 | Shelby, Illinois, US |
3979446 | 3979446 | 2021-02-10 | US | Georgia | Tattnall | 13267 | 2105 | 52 | 0 | 2053 | 32.04785085 | -82.05539188 | 2021-02-11 05:23:55 | Tattnall, Georgia, US |
3979614 | 3979614 | 2021-02-10 | US | Illinois | Shelby | 17173 | 2086 | 33 | 0 | 2053 | 39.39133527 | -88.80611122 | 2021-02-11 05:23:55 | Shelby, Illinois, US |
3979671 | 3979671 | 2021-02-10 | US | Indiana | Jennings | 18079 | 2096 | 43 | 0 | 2053 | 38.99588883 | -85.62710784 | 2021-02-11 05:23:55 | Jennings, Indiana, US |
1590590 | 1590590 | 2021-02-05 | US | North Dakota | Rolette | 38079 | 2063 | 28 | 0 | 2053 | 48.77245354 | -99.84097493 | 2021-02-06 05:23:55 | Rolette, North Dakota, US |
791192 | 791192 | 2021-02-04 | US | Georgia | Hart | 13147 | 2099 | 46 | 0 | 2053 | 34.34626973 | -82.96567682 | 2021-02-05 05:22:38 | Hart, Georgia, US |
1677279 | 1677279 | 2021-02-01 | US | Georgia | Harris | 13145 | 2093 | 40 | 0 | 2053 | 32.73709786 | -84.90538572 | 2021-02-02 05:22:49 | Harris, Georgia, US |
1461613 | 1461613 | 2021-01-31 | US | Mississippi | Winston | 28159 | 2125 | 72 | 0 | 2053 | 33.08747908 | -89.03391385 | 2021-02-01 05:22:53 | Winston, Mississippi, US |
1899015 | 1899015 | 2021-01-29 | US | Missouri | Barry | 29009 | 2094 | 41 | 0 | 2053 | 36.70978521 | -93.82919888 | 2021-01-30 05:22:49 | Barry, Missouri, US |
2483831 | 2483831 | 2021-01-28 | US | Missouri | Barry | 29009 | 2094 | 41 | 0 | 2053 | 36.70978521 | -93.82919888 | 2021-01-29 05:22:23 | Barry, Missouri, US |
3154576 | 3154576 | 2021-01-27 | US | Illinois | Douglas | 17041 | 2081 | 28 | 0 | 2053 | 39.76768052 | -88.21854195 | 2021-01-28 05:22:24 | Douglas, Illinois, US |
2568697 | 2568697 | 2021-01-25 | US | Illinois | Saline | 17165 | 2092 | 39 | 0 | 2053 | 37.75332999 | -88.54119706 | 2021-01-26 05:22:02 | Saline, Illinois, US |
2468579 | 2468579 | 2021-01-22 | US | Mississippi | Adams | 28001 | 2123 | 70 | 0 | 2053 | 31.47669768 | -91.35326037 | 2021-01-23 05:22:03 | Adams, Mississippi, US |
438828 | 438828 | 2021-01-21 | US | West Virginia | Greenbrier | 54025 | 2100 | 47 | 0 | 2053 | 37.9463652 | -80.45335881 | 2021-01-22 05:22:10 | Greenbrier, West Virginia, US |
909873 | 909873 | 2021-01-19 | US | Minnesota | Cass | 27021 | 2076 | 23 | 0 | 2053 | 46.95043611 | -94.32603968 | 2021-01-20 05:21:54 | Cass, Minnesota, US |
238936 | 238936 | 2021-01-18 | US | Minnesota | Cass | 27021 | 2076 | 23 | 0 | 2053 | 46.95043611 | -94.32603968 | 2021-01-19 05:22:15 | Cass, Minnesota, US |
3504257 | 3504257 | 2021-01-17 | US | Hawaii | Hawaii | 15001 | 2098 | 45 | 0 | 2053 | 19.60121157 | -155.5210167 | 2021-01-18 05:22:34 | Hawaii, Hawaii, US |
777746 | 777746 | 2021-01-12 | US | Virginia | Smyth | 51173 | 2113 | 60 | 0 | 2053 | 36.84455636 | -81.53344948 | 2021-01-13 05:22:15 | Smyth, Virginia, US |
190608 | 190608 | 2021-01-11 | US | California | Humboldt | 6023 | 2075 | 22 | 0 | 2053 | 40.69923009 | -123.876044 | 2021-01-12 05:22:15 | Humboldt, California, US |
2628358 | 2628358 | 2021-01-10 | US | Ohio | Morrow | 39117 | 2081 | 28 | 0 | 2053 | 40.52363560000001 | -82.7892599 | 2021-01-11 05:21:50 | Morrow, Ohio, US |
2865121 | 2865121 | 2021-01-06 | US | Alabama | Winston | 1133 | 2083 | 30 | 0 | 2053 | 34.15030532 | -87.37325922 | 2021-01-07 05:22:03 | Winston, Alabama, US |
2866663 | 2866663 | 2021-01-06 | US | Missouri | Saline | 29195 | 2079 | 26 | 0 | 2053 | 39.13734288 | -93.20259964 | 2021-01-07 05:22:03 | Saline, Missouri, US |
3037281 | 3037281 | 2021-01-05 | US | Tennessee | Scott | 47151 | 2344 | 25 | 0 | 2053 | 36.42325673 | -84.50360494 | 2021-01-06 05:22:16 | Scott, Tennessee, US |
3232245 | 3232245 | 2021-01-03 | US | Mississippi | Hancock | 28045 | 2108 | 55 | 0 | 2053 | 30.41830223 | -89.48851033 | 2021-01-04 05:22:02 | Hancock, Mississippi, US |
1140468 | 1140468 | 2021-01-01 | US | Wisconsin | Waushara | 55137 | 2071 | 18 | 0 | 2053 | 44.11324419 | -89.24317107 | 2021-01-02 05:22:33 | Waushara, Wisconsin, US |
769566 | 769566 | 2020-12-29 | US | Texas | Wilson | 48493 | 2195 | 34 | 0 | 2053 | 29.1732598 | -98.08693082 | 2020-12-30 05:22:34 | Wilson, Texas, US |
3779074 | 3779074 | 2020-12-27 | US | Iowa | Crawford | 19047 | 2074 | 21 | 0 | 2053 | 42.03718237 | -95.3819718 | 2020-12-28 05:22:06 | Crawford, Iowa, US |
2934548 | 2934548 | 2020-12-19 | US | Virginia | Franklin | 51067 | 2073 | 20 | 0 | 2053 | 36.99536167 | -79.88023649 | 2020-12-20 05:27:32 | Franklin, Virginia, US |
1035361 | 1035361 | 2020-12-15 | US | Illinois | Iroquois | 17075 | 2092 | 39 | 0 | 2053 | 40.74717633 | -87.82466784 | 2020-12-16 05:28:04 | Iroquois, Illinois, US |
1754766 | 1754766 | 2020-12-14 | US | West Virginia | Raleigh | 54081 | 2073 | 20 | 0 | 2053 | 37.76936795 | -81.2456041 | 2020-12-15 05:26:38 | Raleigh, West Virginia, US |
863876 | 863876 | 2020-12-11 | US | Texas | Rusk | 48401 | 2114 | 39 | 0 | 2053 | 32.10773545 | -94.76176432 | 2020-12-12 05:26:19 | Rusk, Texas, US |
2348579 | 2348579 | 2020-12-07 | US | Iowa | Bremer | 19017 | 2067 | 14 | 0 | 2053 | 42.77461496 | -92.31795937 | 2020-12-08 05:27:42 | Bremer, Iowa, US |
741239 | 741239 | 2020-12-02 | US | Tennessee | Hawkins | 47073 | 2099 | 35 | 0 | 2053 | 36.44355426 | -82.94885298 | 2020-12-03 05:28:22 | Hawkins, Tennessee, US |
2936187 | 2936187 | 2020-11-28 | US | Illinois | Bureau | 17011 | 2094 | 41 | 0 | 2053 | 41.40385234 | -89.5283051 | 2020-11-29 05:25:55 | Bureau, Illinois, US |
394560 | 394560 | 2020-11-27 | US | North Carolina | Lenoir | 37107 | 2105 | 52 | 0 | 2053 | 35.24032589999999 | -77.64245615 | 2020-11-28 05:25:50 | Lenoir, North Carolina, US |
3839743 | 3839743 | 2020-11-21 | US | Utah | Summit | 49043 | 2056 | 3 | 0 | 2053 | 40.86688146 | -110.9535882 | 2020-11-22 05:25:45 | Summit, Utah, US |
3339675 | 3339675 | 2020-11-17 | US | Indiana | Hancock | 18059 | 2102 | 49 | 0 | 2053 | 39.82304555 | -85.77566351 | 2020-11-18 05:40:31 | Hancock, Indiana, US |
3340209 | 3340209 | 2020-11-17 | US | Michigan | Delta | 26041 | 2108 | 55 | 0 | 2053 | 45.90484910000001 | -86.9080745 | 2020-11-18 05:40:31 | Delta, Michigan, US |
272575 | 272575 | 2020-11-10 | US | Alaska | Matanuska-Susitna | 2170 | 2058 | 5 | 0 | 2053 | 62.31305045 | -149.5741743 | 2020-11-11 05:25:30 | Matanuska-Susitna, Alaska, US |
1730159 | 1730159 | 2020-11-08 | US | Michigan | St. Clair | 26147 | 2121 | 68 | 0 | 2053 | 42.92655373 | -82.67937954 | 2020-11-09 05:25:45 | St. Clair, Michigan, US |
1545619 | 1545619 | 2020-11-07 | US | Michigan | St. Clair | 26147 | 2121 | 68 | 0 | 2053 | 42.92655373 | -82.67937954 | 2020-11-08 05:24:56 | St. Clair, Michigan, US |
2921485 | 2921485 | 2020-11-04 | US | North Carolina | Edgecombe | 37065 | 2114 | 61 | 0 | 2053 | 35.91230639 | -77.59436892 | 2020-11-05 06:05:03 | Edgecombe, North Carolina, US |
3306431 | 3306431 | 2020-11-02 | US | New York | Niagara | 36063 | 2155 | 102 | 0 | 2053 | 43.19898042 | -78.74777412 | 2020-11-03 06:00:16 | Niagara, New York, US |
2081312 | 2081312 | 2020-10-31 | US | Kentucky | Daviess | 21059 | 2085 | 32 | 0 | 2053 | 37.73028906 | -87.09019479999998 | 2020-11-01 04:36:19 | Daviess, Kentucky, US |
2082616 | 2082616 | 2020-10-31 | US | Pennsylvania | Schuylkill | 42107 | 2150 | 97 | 0 | 2053 | 40.70497338 | -76.2150785 | 2020-11-01 04:36:19 | Schuylkill, Pennsylvania, US |
754667 | 754667 | 2020-10-28 | US | Alabama | Franklin | 1059 | 2085 | 32 | 0 | 2053 | 34.44235334 | -87.84289505 | 2020-10-29 04:24:49 | Franklin, Alabama, US |
3482495 | 3482495 | 2020-10-26 | US | New Mexico | Lea | 35025 | 2081 | 28 | 0 | 2053 | 32.79215361 | -103.4123733 | 2020-10-27 04:24:45 | Lea, New Mexico, US |
9653 | 9653 | 2020-10-25 | US | Kansas | Reno | 20155 | 2068 | 15 | 0 | 2053 | 37.95230263 | -98.08607292 | 2020-10-26 04:25:02 | Reno, Kansas, US |
1795596 | 1795596 | 2020-10-19 | US | Illinois | DeKalb | 17037 | 2095 | 42 | 0 | 2053 | 41.89373302 | -88.76958483 | 2020-10-20 04:24:22 | DeKalb, Illinois, US |
1028644 | 1028644 | 2020-10-17 | US | North Carolina | Craven | 37049 | 2103 | 50 | 0 | 2053 | 35.11833364 | -77.08398081 | 2020-10-18 04:24:25 | Craven, North Carolina, US |
2857642 | 2857642 | 2020-10-16 | US | Georgia | Gordon | 13129 | 2092 | 39 | 0 | 2053 | 34.50487351 | -84.87296253 | 2020-10-17 04:24:12 | Gordon, Georgia, US |
788698 | 788698 | 2020-10-15 | US | North Carolina | Lincoln | 37109 | 2069 | 16 | 0 | 2053 | 35.48508185 | -81.21740317 | 2020-10-16 04:24:01 | Lincoln, North Carolina, US |
2293208 | 2293208 | 2020-10-12 | US | Minnesota | Wright | 27171 | 2063 | 10 | 0 | 2053 | 45.17297924 | -93.96234781 | 2020-10-13 04:24:02 | Wright, Minnesota, US |
3118636 | 3118636 | 2020-10-06 | US | Iowa | Buena Vista | 19021 | 2065 | 12 | 0 | 2053 | 42.73545875 | -95.15100162 | 2020-10-07 04:23:40 | Buena Vista, Iowa, US |
2516968 | 2516968 | 2020-10-03 | US | South Carolina | Darlington | 45031 | 2112 | 59 | 0 | 2053 | 34.33358335 | -79.96027485 | 2020-10-04 04:23:44 | Darlington, South Carolina, US |
2582688 | 2582688 | 2020-09-27 | US | Florida | Nassau | 12089 | 2097 | 44 | 0 | 2053 | 30.61037141 | -81.80297522 | 2020-09-28 04:23:00 | Nassau, Florida, US |
2582716 | 2582716 | 2020-09-27 | US | Georgia | Baldwin | 13009 | 2109 | 56 | 0 | 2053 | 33.06882326 | -83.24701748 | 2020-09-28 04:23:00 | Baldwin, Georgia, US |
2609252 | 2609252 | 2020-09-24 | US | Texas | Val Verde | 48465 | 1238 | 100 | 0 | 2053 | 29.89149232 | -101.1525205 | 2020-09-25 04:23:00 | Val Verde, Texas, US |
2838618 | 2838618 | 2020-09-21 | US | Mississippi | Lafayette | 28071 | 2092 | 39 | 0 | 2053 | 34.35687874 | -89.48490961 | 2020-09-22 04:23:00 | Lafayette, Mississippi, US |
147505 | 147505 | 2020-08-15 | US | Maine | Cumberland | 23005 | 2122 | 69 | 0 | 2053 | 43.8370751 | -70.37226999 | 2020-08-16 04:27:42 | Cumberland, Maine, US |
3532136 | 3532136 | 2020-08-12 | US | Florida | Hernando | 12053 | 2106 | 53 | 0 | 2053 | 28.55364461 | -82.42700204 | 2020-08-13 04:29:15 | Hernando, Florida, US |
457806 | 457806 | 2020-08-07 | US | Texas | Starr | 48427 | 2092 | 64 | 0 | 2053 | 26.56150059 | -98.73892358 | 2020-08-08 04:34:53 | Starr, Texas, US |
414895 | 414895 | 2020-07-05 | US | Texas | Walker | 48471 | 2243 | 28 | 0 | 2053 | 30.73872995 | -95.57440968 | 2020-07-06 04:33:57 | Walker, Texas, US |
2623851 | 2623851 | 2020-06-25 | US | Louisiana | Ouachita | 22073 | 2125 | 72 | 0 | 2053 | 32.47645559 | -92.15704172 | 2020-06-26 04:33:43 | Ouachita, Louisiana, US |
2698219 | 2698219 | 2020-06-24 | US | Colorado | El Paso | 8041 | 2409 | 117 | 0 | 2053 | 38.83240149 | -104.5251411 | 2020-06-25 05:26:54 | El Paso, Colorado, US |
2699689 | 2699689 | 2020-06-24 | US | Wisconsin | Racine | 55101 | 2114 | 61 | 0 | 2053 | 42.74753117 | -88.05941254 | 2020-06-25 05:26:54 | Racine, Wisconsin, US |
2384120 | 2384120 | 2020-06-16 | US | Florida | Duval | 12031 | 2112 | 59 | 0 | 2053 | 30.33225875 | -81.66976468 | 2020-06-17 04:33:21 | Duval, Florida, US |
804253 | 804253 | 2020-06-01 | US | Ohio | Pickaway | 39129 | 2086 | 33 | 0 | 2053 | 39.64170392 | -83.0243386 | 2020-06-02 02:33:08 | Pickaway, Ohio, US |
3560085 | 3560085 | 2020-04-08 | US | Massachusetts | Essex | 25009 | 2103 | 50 | 0 | 2053 | 42.6687626 | -70.94687179 | 2020-04-08 22:51:58 | Essex, Massachusetts, 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]);