ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 5617 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Georgia 8
- Michigan 7
- Iowa 4
- Alabama 3
- New York 3
- Ohio 3
- Tennessee 3
- Texas 3
- West Virginia 3
- Illinois 2
- Indiana 2
- Kentucky 2
- North Carolina 2
- Pennsylvania 2
- South Carolina 2
- Virginia 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Louisiana 1
- Massachusetts 1
- Minnesota 1
- Oregon 1
- Utah 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2431060 | 2431060 | 2022-04-21 | McDowell | West Virginia | 54047 | 5617 | 74 |
2427804 | 2427804 | 2022-04-20 | McDowell | West Virginia | 54047 | 5617 | 73 |
2242600 | 2242600 | 2022-02-23 | Arkansas | Arkansas | 5001 | 5617 | 74 |
2232175 | 2232175 | 2022-02-19 | Dimmit | Texas | 48127 | 5617 | 50 |
2151156 | 2151156 | 2022-01-25 | Hopewell city | Virginia | 51670 | 5617 | 99 |
2109047 | 2109047 | 2022-01-12 | Door | Wisconsin | 55029 | 5617 | 52 |
2077142 | 2077142 | 2022-01-03 | Toombs | Georgia | 13279 | 5617 | 177 |
2073891 | 2073891 | 2022-01-02 | Toombs | Georgia | 13279 | 5617 | 177 |
2070640 | 2070640 | 2022-01-01 | Toombs | Georgia | 13279 | 5617 | 177 |
2067389 | 2067389 | 2021-12-31 | Toombs | Georgia | 13279 | 5617 | 177 |
1974484 | 1974484 | 2021-12-02 | Orleans | New York | 36073 | 5617 | 96 |
1954955 | 1954955 | 2021-11-26 | Columbia | New York | 36021 | 5617 | 113 |
1946470 | 1946470 | 2021-11-23 | Marshall | West Virginia | 54051 | 5617 | 118 |
1929400 | 1929400 | 2021-11-18 | McKean | Pennsylvania | 42083 | 5617 | 99 |
1919909 | 1919909 | 2021-11-15 | Hardin | Tennessee | 47071 | 5617 | 84 |
1878850 | 1878850 | 2021-11-03 | Pickens | Georgia | 13227 | 5617 | 117 |
1858036 | 1858036 | 2021-10-27 | Colleton | South Carolina | 45029 | 5617 | 189 |
1840467 | 1840467 | 2021-10-22 | Taylor | Kentucky | 21217 | 5617 | 82 |
1837218 | 1837218 | 2021-10-21 | Taylor | Kentucky | 21217 | 5617 | 82 |
1838359 | 1838359 | 2021-10-21 | Malheur | Oregon | 41045 | 5617 | 76 |
1802242 | 1802242 | 2021-10-10 | Montgomery | New York | 36057 | 5617 | 136 |
1789447 | 1789447 | 2021-10-06 | Clinton | Ohio | 39027 | 5617 | 87 |
1673658 | 1673658 | 2021-08-31 | Sweetwater | Wyoming | 56037 | 5617 | 49 |
1628644 | 1628644 | 2021-08-18 | Habersham | Georgia | 13137 | 5617 | 168 |
1524350 | 1524350 | 2021-07-17 | Graham | Arizona | 4009 | 5617 | 85 |
1473122 | 1473122 | 2021-07-01 | Clinton | Iowa | 19045 | 5617 | 93 |
1469876 | 1469876 | 2021-06-30 | Clinton | Iowa | 19045 | 5617 | 93 |
1466631 | 1466631 | 2021-06-29 | Clinton | Iowa | 19045 | 5617 | 93 |
1463386 | 1463386 | 2021-06-28 | Clinton | Iowa | 19045 | 5617 | 93 |
1450752 | 1450752 | 2021-06-24 | St. Charles | Louisiana | 22089 | 5617 | 98 |
1432990 | 1432990 | 2021-06-18 | Box Elder | Utah | 49003 | 5617 | 53 |
1404163 | 1404163 | 2021-06-10 | Coffee | Alabama | 1031 | 5617 | 125 |
1397673 | 1397673 | 2021-06-08 | Coffee | Alabama | 1031 | 5617 | 124 |
1346978 | 1346978 | 2021-05-23 | Branch | Michigan | 26023 | 5617 | 120 |
1343730 | 1343730 | 2021-05-22 | Branch | Michigan | 26023 | 5617 | 120 |
1337301 | 1337301 | 2021-05-20 | Tuscola | Michigan | 26157 | 5617 | 171 |
1337926 | 1337926 | 2021-05-20 | Halifax | North Carolina | 37083 | 5617 | 112 |
1307521 | 1307521 | 2021-05-11 | Noble | Indiana | 18113 | 5617 | 87 |
1302919 | 1302919 | 2021-05-09 | Caldwell | Texas | 48055 | 5617 | 97 |
1299672 | 1299672 | 2021-05-08 | Caldwell | Texas | 48055 | 5617 | 97 |
1242331 | 1242331 | 2021-04-21 | Polk | Georgia | 13233 | 5617 | 91 |
1218141 | 1218141 | 2021-04-13 | Indiana | Pennsylvania | 42063 | 5617 | 165 |
1171088 | 1171088 | 2021-03-30 | Cass | Indiana | 18017 | 5617 | 103 |
1074279 | 1074279 | 2021-02-28 | Montcalm | Michigan | 26117 | 5617 | 94 |
1071033 | 1071033 | 2021-02-27 | Montcalm | Michigan | 26117 | 5617 | 94 |
1058686 | 1058686 | 2021-02-23 | Duplin | North Carolina | 37061 | 5617 | 124 |
1012584 | 1012584 | 2021-02-09 | Gratiot | Michigan | 26057 | 5617 | 101 |
1009339 | 1009339 | 2021-02-08 | Gratiot | Michigan | 26057 | 5617 | 100 |
973721 | 973721 | 2021-01-28 | Kandiyohi | Minnesota | 27067 | 5617 | 72 |
953495 | 953495 | 2021-01-22 | Boone | Illinois | 17007 | 5617 | 78 |
904272 | 904272 | 2021-01-07 | Talladega | Alabama | 1121 | 5617 | 76 |
889211 | 889211 | 2021-01-02 | Barnstable | Massachusetts | 25001 | 5617 | 240 |
870656 | 870656 | 2020-12-27 | Wayne | Ohio | 39169 | 5617 | 139 |
871069 | 871069 | 2020-12-27 | Hamblen | Tennessee | 47063 | 5617 | 78 |
812201 | 812201 | 2020-12-09 | Marion | Ohio | 39101 | 5617 | 71 |
787319 | 787319 | 2020-12-01 | Manitowoc | Wisconsin | 55071 | 5617 | 41 |
768346 | 768346 | 2020-11-26 | Douglas | Georgia | 13097 | 5617 | 88 |
608676 | 608676 | 2020-10-07 | Henrico | Virginia | 51087 | 5617 | 219 |
517454 | 517454 | 2020-09-09 | Spartanburg | South Carolina | 45083 | 5617 | 175 |
473657 | 473657 | 2020-08-27 | St. Clair | Illinois | 17163 | 5617 | 174 |
447407 | 447407 | 2020-08-19 | El Paso | Colorado | 8041 | 5617 | 145 |
347619 | 347619 | 2020-07-19 | Contra Costa | California | 6013 | 5617 | 98 |
202329 | 202329 | 2020-06-02 | Davidson | Tennessee | 47037 | 5617 | 64 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);