johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where active = 2874 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Georgia 7
- Florida 4
- North Carolina 4
- Indiana 3
- Tennessee 3
- Alabama 2
- Kentucky 2
- Minnesota 2
- Mississippi 2
- New Mexico 2
- Ohio 2
- Oklahoma 2
- Pennsylvania 2
- Texas 2
- Virginia 2
- Washington 2
- Alaska 1
- Arizona 1
- Arkansas 1
- California 1
- Hawaii 1
- Illinois 1
- Iowa 1
- Kansas 1
- Louisiana 1
- New York 1
- Oregon 1
- South Carolina 1
- South Dakota 1
- Utah 1
- …
country_or_region 1
- US · 58 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1616948 | 1616948 | 2021-03-05 | US | Florida | Levy | 12075 | 2914 | 40 | 0 | 2874 | 29.31829741 | -82.74007147 | 2021-03-06 04:23:41 | Levy, Florida, US |
1617146 | 1617146 | 2021-03-05 | US | Hawaii | Maui | 15009 | 2907 | 33 | 0 | 2874 | 20.86399628 | -156.56890969999995 | 2021-03-06 04:23:41 | Maui, Hawaii, US |
1000990 | 1000990 | 2021-03-01 | US | Oklahoma | Jackson | 40065 | 2918 | 44 | 0 | 2874 | 34.58781741 | -99.41138784 | 2021-03-02 05:23:30 | Jackson, Oklahoma, US |
2186542 | 2186542 | 2021-02-26 | US | Tennessee | Marion | 47115 | 2957 | 42 | 0 | 2874 | 35.12997174 | -85.62265895 | 2021-02-27 05:22:28 | Marion, Tennessee, US |
473747 | 473747 | 2021-02-19 | US | North Carolina | Montgomery | 37123 | 2958 | 84 | 0 | 2874 | 35.33155144 | -79.90416657 | 2021-02-20 05:22:51 | Montgomery, North Carolina, US |
474265 | 474265 | 2021-02-19 | US | South Dakota | Davison | 46035 | 2934 | 60 | 0 | 2874 | 43.67490933 | -98.14458906 | 2021-02-20 05:22:51 | Davison, South Dakota, US |
2640238 | 2640238 | 2021-02-11 | US | Ohio | Williams | 39171 | 2946 | 72 | 0 | 2874 | 41.56052014 | -84.58429552 | 2021-02-12 05:23:29 | Williams, Ohio, US |
2640411 | 2640411 | 2021-02-11 | US | Pennsylvania | Snyder | 42109 | 2947 | 73 | 0 | 2874 | 40.77129231 | -77.06840691 | 2021-02-12 05:23:29 | Snyder, Pennsylvania, US |
1588721 | 1588721 | 2021-02-05 | US | California | Lake | 6033 | 2907 | 33 | 0 | 2874 | 39.10124298 | -122.7536244 | 2021-02-06 05:23:55 | Lake, California, US |
791407 | 791407 | 2021-02-04 | US | Illinois | Perry | 17145 | 2930 | 56 | 0 | 2874 | 38.08510853 | -89.36856219 | 2021-02-05 05:22:38 | Perry, Illinois, US |
342470 | 342470 | 2021-02-03 | US | New Mexico | Otero | 35035 | 2924 | 50 | 0 | 2874 | 32.61348406 | -105.7417604 | 2021-02-04 05:22:26 | Otero, New Mexico, US |
1686216 | 1686216 | 2021-02-02 | US | Minnesota | Isanti | 27059 | 2918 | 44 | 0 | 2874 | 45.56181234 | -93.29487636 | 2021-02-03 05:22:52 | Isanti, Minnesota, US |
2482853 | 2482853 | 2021-01-28 | US | Georgia | Upson | 13293 | 2970 | 96 | 0 | 2874 | 32.87920671 | -84.30024826 | 2021-01-29 05:22:23 | Upson, Georgia, US |
2483658 | 2483658 | 2021-01-28 | US | Minnesota | Becker | 27005 | 2913 | 39 | 0 | 2874 | 46.93479392 | -95.67158144 | 2021-01-29 05:22:23 | Becker, Minnesota, US |
3104769 | 3104769 | 2021-01-16 | US | Virginia | Franklin | 51067 | 2902 | 28 | 0 | 2874 | 36.99536167 | -79.88023649 | 2021-01-17 05:22:17 | Franklin, Virginia, US |
3881098 | 3881098 | 2021-01-14 | US | Louisiana | St. John the Baptist | 22095 | 2997 | 123 | 0 | 2874 | 30.12597499 | -90.4753503 | 2021-01-15 05:22:24 | St. John the Baptist, Louisiana, US |
3902522 | 3902522 | 2021-01-09 | US | Oklahoma | Mayes | 40097 | 2901 | 27 | 0 | 2874 | 36.30179091 | -95.23175116 | 2021-01-10 05:22:12 | Mayes, Oklahoma, US |
1062242 | 1062242 | 2021-01-04 | US | Alabama | Russell | 1113 | 2880 | 6 | 0 | 2874 | 32.28725256 | -85.18415324 | 2021-01-05 05:21:49 | Russell, Alabama, US |
2230138 | 2230138 | 2021-01-02 | US | Oregon | Malheur | 41045 | 2924 | 50 | 0 | 2874 | 43.1937027 | -117.6227395 | 2021-01-03 05:22:52 | Malheur, Oregon, US |
3697703 | 3697703 | 2020-12-31 | US | New York | Cayuga | 36011 | 2894 | 20 | 0 | 2874 | 42.91261714 | -76.55731592 | 2021-01-01 05:23:07 | Cayuga, New York, US |
1013245 | 1013245 | 2020-12-30 | US | Tennessee | Henderson | 47077 | 2960 | 44 | 0 | 2874 | 35.65581134 | -88.38600175 | 2020-12-31 05:22:49 | Henderson, Tennessee, US |
930018 | 930018 | 2020-12-21 | US | North Carolina | Lenoir | 37107 | 2936 | 62 | 0 | 2874 | 35.24032589999999 | -77.64245615 | 2020-12-22 05:22:33 | Lenoir, North Carolina, US |
1904613 | 1904613 | 2020-12-18 | US | Washington | Skagit | 53057 | 2907 | 33 | 0 | 2874 | 48.48171488 | -121.766131 | 2020-12-19 05:27:52 | Skagit, Washington, US |
3152641 | 3152641 | 2020-12-16 | US | Texas | Coryell | 48099 | 4053 | 22 | 0 | 2874 | 31.39078397 | -97.79936155 | 2020-12-17 05:28:12 | Coryell, Texas, US |
1752141 | 1752141 | 2020-12-14 | US | Georgia | Tift | 13277 | 2953 | 79 | 0 | 2874 | 31.45743864 | -83.5236119 | 2020-12-15 05:26:38 | Tift, Georgia, US |
3848661 | 3848661 | 2020-12-13 | US | Georgia | Tift | 13277 | 2953 | 79 | 0 | 2874 | 31.45743864 | -83.5236119 | 2020-12-14 05:26:27 | Tift, Georgia, US |
2977043 | 2977043 | 2020-12-09 | US | Mississippi | Lowndes | 28087 | 2944 | 70 | 0 | 2874 | 33.47386518 | -88.44191529999998 | 2020-12-10 05:26:19 | Lowndes, Mississippi, US |
1819671 | 1819671 | 2020-12-08 | US | Georgia | Walker | 13295 | 2930 | 56 | 0 | 2874 | 34.73376362 | -85.30165174 | 2020-12-09 05:28:01 | Walker, Georgia, US |
1633375 | 1633375 | 2020-12-05 | US | Indiana | Dubois | 18037 | 2911 | 37 | 0 | 2874 | 38.36597551 | -86.87924170000002 | 2020-12-06 05:26:18 | Dubois, Indiana, US |
3837639 | 3837639 | 2020-11-21 | US | Iowa | Buena Vista | 19021 | 2888 | 14 | 0 | 2874 | 42.73545875 | -95.15100162 | 2020-11-22 05:25:45 | Buena Vista, Iowa, US |
125340 | 125340 | 2020-11-18 | US | Pennsylvania | Beaver | 42007 | 3018 | 144 | 0 | 2874 | 40.6825484 | -80.34921611 | 2020-11-19 05:25:23 | Beaver, Pennsylvania, US |
2880619 | 2880619 | 2020-11-15 | US | Alaska | Fairbanks North Star | 2090 | 2891 | 17 | 0 | 2874 | 64.80726247 | -146.5692662 | 2020-11-16 05:25:57 | Fairbanks North Star, Alaska, US |
2917382 | 2917382 | 2020-11-14 | US | New Mexico | Sandoval | 35043 | 2934 | 60 | 0 | 2874 | 35.68862401 | -106.8687803 | 2020-11-15 05:26:53 | Sandoval, New Mexico, US |
3441613 | 3441613 | 2020-11-11 | US | Georgia | Gordon | 13129 | 2931 | 57 | 0 | 2874 | 34.50487351 | -84.87296253 | 2020-11-12 05:25:55 | Gordon, Georgia, US |
1991607 | 1991607 | 2020-11-09 | US | Tennessee | Robertson | 47147 | 2921 | 43 | 0 | 2874 | 36.52454807 | -86.87346725 | 2020-11-10 05:40:07 | Robertson, Tennessee, US |
3409844 | 3409844 | 2020-11-01 | US | Alabama | Walker | 1127 | 2969 | 95 | 0 | 2874 | 33.80270512 | -87.30027177 | 2020-11-02 05:25:04 | Walker, Alabama, US |
3410168 | 3410168 | 2020-11-01 | US | Florida | Sumter | 12119 | 2960 | 86 | 0 | 2874 | 28.70181754 | -82.0794267 | 2020-11-02 05:25:04 | Sumter, Florida, US |
211376 | 211376 | 2020-10-29 | US | Indiana | Vigo | 18167 | 2930 | 56 | 0 | 2874 | 39.42944561 | -87.39169027 | 2020-10-30 04:24:49 | Vigo, Indiana, US |
3482678 | 3482678 | 2020-10-26 | US | North Carolina | Wilson | 37195 | 2937 | 63 | 0 | 2874 | 35.70625477 | -77.917978 | 2020-10-27 04:24:45 | Wilson, North Carolina, US |
3991484 | 3991484 | 2020-10-20 | US | Georgia | Troup | 13285 | 2980 | 106 | 0 | 2874 | 33.03349196 | -85.02812115 | 2020-10-21 04:24:14 | Troup, Georgia, US |
1796416 | 1796416 | 2020-10-19 | US | Mississippi | Forrest | 28035 | 2951 | 77 | 0 | 2874 | 31.18961454 | -89.25832496 | 2020-10-20 04:24:22 | Forrest, Mississippi, US |
80168 | 80168 | 2020-10-14 | US | Indiana | Hendricks | 18063 | 3005 | 131 | 0 | 2874 | 39.76719009 | -86.51037283 | 2020-10-15 04:24:28 | Hendricks, Indiana, US |
2294806 | 2294806 | 2020-10-12 | US | Virginia | Newport News | 51700 | 2923 | 49 | 0 | 2874 | 37.08166899 | -76.51754109 | 2020-10-13 04:24:02 | Newport News, Virginia, US |
3786736 | 3786736 | 2020-10-11 | US | Georgia | Paulding | 13223 | 2933 | 59 | 0 | 2874 | 33.91969522 | -84.86848792 | 2020-10-12 04:23:45 | Paulding, Georgia, US |
2602502 | 2602502 | 2020-10-10 | US | Arkansas | Faulkner | 5045 | 2900 | 26 | 0 | 2874 | 35.14719007 | -92.33717519 | 2020-10-11 04:23:46 | Faulkner, Arkansas, US |
2732250 | 2732250 | 2020-09-15 | US | Utah | Bear River | 2885 | 11 | 0 | 2874 | 41.52106798 | -113.0832816 | 2020-09-16 04:22:53 | Bear River, Utah, US | |
1246118 | 1246118 | 2020-09-08 | US | North Carolina | Wayne | 37191 | 2931 | 57 | 0 | 2874 | 35.36438125 | -78.00027268 | 2020-09-09 04:28:48 | Wayne, North Carolina, US |
1999424 | 1999424 | 2020-08-26 | US | South Carolina | Anderson | 45007 | 2978 | 104 | 0 | 2874 | 34.51828081 | -82.63959517 | 2020-08-27 04:28:15 | Anderson, South Carolina, US |
3610588 | 3610588 | 2020-08-06 | US | Ohio | Marion | 39101 | 2910 | 36 | 0 | 2874 | 40.58610662 | -83.15736305 | 2020-08-07 04:35:11 | Marion, Ohio, US |
2806439 | 2806439 | 2020-08-02 | US | Arizona | Mohave | 4015 | 3027 | 153 | 0 | 2874 | 35.70471703 | -113.7577902 | 2020-08-03 04:34:35 | Mohave, Arizona, US |
58534 | 58534 | 2020-07-23 | US | Florida | Alachua | 12001 | 2890 | 16 | 0 | 2874 | 29.67866525 | -82.35928158 | 2020-07-24 05:30:40 | Alachua, Florida, US |
3203481 | 3203481 | 2020-07-18 | US | Florida | Leon | 12073 | 2884 | 10 | 0 | 2874 | 30.45955727 | -84.27491114 | 2020-07-19 04:34:58 | Leon, Florida, US |
3735669 | 3735669 | 2020-07-12 | US | Kansas | Johnson | 20091 | 2967 | 93 | 0 | 2874 | 38.88548175 | -94.82250877 | 2020-07-13 04:43:04 | Johnson, Kansas, US |
3044288 | 3044288 | 2020-07-02 | US | Texas | Potter | 48375 | 2881 | 39 | 0 | 2874 | 35.40133773 | -101.893964 | 2020-07-03 04:33:54 | Potter, Texas, US |
299997 | 299997 | 2020-07-01 | US | Wisconsin | Brown | 55009 | 2916 | 42 | 0 | 2874 | 44.4526553 | -88.00411844 | 2020-07-02 04:33:46 | Brown, Wisconsin, US |
2798072 | 2798072 | 2020-06-07 | US | Kentucky | Jefferson | 21111 | 3043 | 169 | 0 | 2874 | 38.18664655 | -85.65931031 | 2020-06-08 03:33:22 | Jefferson, Kentucky, US |
572128 | 572128 | 2020-06-06 | US | Kentucky | Jefferson | 21111 | 3043 | 169 | 0 | 2874 | 38.18664655 | -85.65931031 | 2020-06-07 03:53:30 | Jefferson, Kentucky, US |
1268984 | 1268984 | 2020-06-05 | US | Washington | Snohomish | 53061 | 3026 | 152 | 0 | 2874 | 48.04615983 | -121.7170703 | 2020-06-06 02:33:00 | Snohomish, Washington, 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]);