ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 7460 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Indiana 12
- Tennessee 10
- Alabama 4
- Maine 4
- Texas 3
- Utah 3
- Virginia 3
- Georgia 2
- Maryland 2
- Mississippi 2
- Missouri 2
- North Carolina 2
- Puerto Rico 2
- Alaska 1
- Florida 1
- Michigan 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422609 | 2422609 | 2022-04-19 | Hancock | Maine | 23009 | 7460 | 84 |
2419353 | 2419353 | 2022-04-18 | Hancock | Maine | 23009 | 7460 | 84 |
2416097 | 2416097 | 2022-04-17 | Hancock | Maine | 23009 | 7460 | 84 |
2412841 | 2412841 | 2022-04-16 | Hancock | Maine | 23009 | 7460 | 84 |
2385294 | 2385294 | 2022-04-07 | Botetourt | Virginia | 51023 | 7460 | 96 |
2353122 | 2353122 | 2022-03-29 | Pike | Alabama | 1109 | 7460 | 133 |
2333359 | 2333359 | 2022-03-22 | Wythe | Virginia | 51197 | 7460 | 139 |
2330105 | 2330105 | 2022-03-21 | Wythe | Virginia | 51197 | 7460 | 139 |
2308242 | 2308242 | 2022-03-15 | Daviess | Indiana | 18027 | 7460 | 150 |
2306642 | 2306642 | 2022-03-14 | Humacao | Puerto Rico | 72069 | 7460 | |
2226300 | 2226300 | 2022-02-18 | Winston | Alabama | 1133 | 7460 | 117 |
2152969 | 2152969 | 2022-01-26 | Laclede | Missouri | 29105 | 7460 | 158 |
2150723 | 2150723 | 2022-01-25 | Giles | Tennessee | 47055 | 7460 | 154 |
2147471 | 2147471 | 2022-01-24 | Giles | Tennessee | 47055 | 7460 | 154 |
2144217 | 2144217 | 2022-01-23 | Giles | Tennessee | 47055 | 7460 | 154 |
2140962 | 2140962 | 2022-01-22 | Giles | Tennessee | 47055 | 7460 | 154 |
2137706 | 2137706 | 2022-01-21 | Giles | Tennessee | 47055 | 7460 | 154 |
2134452 | 2134452 | 2022-01-20 | Giles | Tennessee | 47055 | 7460 | 154 |
2131200 | 2131200 | 2022-01-19 | Giles | Tennessee | 47055 | 7460 | 154 |
2125396 | 2125396 | 2022-01-18 | Chambers | Alabama | 1017 | 7460 | 147 |
2127344 | 2127344 | 2022-01-18 | Jackson | North Carolina | 37099 | 7460 | 80 |
2123364 | 2123364 | 2022-01-17 | Worcester | Maryland | 24047 | 7460 | 138 |
1968656 | 1968656 | 2021-11-30 | Fayette | Tennessee | 47047 | 7460 | 110 |
1962501 | 1962501 | 2021-11-28 | Summit | Utah | 49043 | 7460 | 19 |
1959250 | 1959250 | 2021-11-27 | Summit | Utah | 49043 | 7460 | 19 |
1955999 | 1955999 | 2021-11-26 | Summit | Utah | 49043 | 7460 | 19 |
1846608 | 1846608 | 2021-10-24 | Lawrence | Indiana | 18093 | 7460 | 174 |
1843358 | 1843358 | 2021-10-23 | Lawrence | Indiana | 18093 | 7460 | 174 |
1840108 | 1840108 | 2021-10-22 | Lawrence | Indiana | 18093 | 7460 | 174 |
1833354 | 1833354 | 2021-10-20 | Murray | Georgia | 13213 | 7460 | 131 |
1732858 | 1732858 | 2021-09-19 | Dearborn | Indiana | 18029 | 7460 | 90 |
1732914 | 1732914 | 2021-09-19 | Shelby | Indiana | 18145 | 7460 | 118 |
1729608 | 1729608 | 2021-09-18 | Dearborn | Indiana | 18029 | 7460 | 90 |
1729664 | 1729664 | 2021-09-18 | Shelby | Indiana | 18145 | 7460 | 118 |
1726358 | 1726358 | 2021-09-17 | Dearborn | Indiana | 18029 | 7460 | 90 |
1726414 | 1726414 | 2021-09-17 | Shelby | Indiana | 18145 | 7460 | 118 |
1634019 | 1634019 | 2021-08-19 | McMinn | Tennessee | 47107 | 7460 | 108 |
1549324 | 1549324 | 2021-07-24 | Caguas | Puerto Rico | 72025 | 7460 | |
1514462 | 1514462 | 2021-07-13 | Portage | Wisconsin | 55097 | 7460 | 75 |
1422984 | 1422984 | 2021-06-15 | Tipton | Tennessee | 47167 | 7460 | 105 |
1304245 | 1304245 | 2021-05-10 | Grant | Indiana | 18053 | 7460 | 181 |
1271580 | 1271580 | 2021-04-30 | Troup | Georgia | 13285 | 7460 | 225 |
1184089 | 1184089 | 2021-04-03 | Floyd | Indiana | 18043 | 7460 | 179 |
1183268 | 1183268 | 2021-04-02 | Wood | West Virginia | 54107 | 7460 | 164 |
1158817 | 1158817 | 2021-03-26 | Forrest | Mississippi | 28035 | 7460 | 143 |
1142582 | 1142582 | 2021-03-21 | Forrest | Mississippi | 28035 | 7460 | 142 |
1031152 | 1031152 | 2021-02-15 | Nassau | Florida | 12089 | 7460 | 106 |
1022336 | 1022336 | 2021-02-12 | Lenawee | Michigan | 26091 | 7460 | 117 |
1000258 | 1000258 | 2021-02-05 | Craven | North Carolina | 37049 | 7460 | 108 |
994694 | 994694 | 2021-02-03 | Victoria | Texas | 48469 | 7460 | 158 |
982179 | 982179 | 2021-01-31 | Matanuska-Susitna Borough | Alaska | 2170 | 7460 | 27 |
945990 | 945990 | 2021-01-19 | Starr | Texas | 48427 | 7460 | 214 |
930232 | 930232 | 2021-01-15 | St. Clair | Alabama | 1115 | 7460 | 120 |
790069 | 790069 | 2020-12-02 | Ellis | Texas | 48139 | 7460 | 117 |
584550 | 584550 | 2020-09-30 | Jackson | Missouri | 29095 | 7460 | 102 |
422538 | 422538 | 2020-08-11 | Anne Arundel | Maryland | 24003 | 7460 | 227 |
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);