ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 6423 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Kentucky 8
- Iowa 7
- Arkansas 6
- Michigan 6
- Pennsylvania 6
- Indiana 5
- Mississippi 4
- North Carolina 4
- Texas 4
- Utah 4
- Montana 3
- California 2
- Illinois 2
- Louisiana 2
- Tennessee 2
- Wisconsin 2
- Arizona 1
- Florida 1
- Idaho 1
- Maryland 1
- Ohio 1
- South Carolina 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445477 | 2445477 | 2022-04-26 | Emmet | Michigan | 26047 | 6423 | 86 |
2447438 | 2447438 | 2022-04-26 | Waushara | Wisconsin | 55137 | 6423 | 87 |
2442221 | 2442221 | 2022-04-25 | Emmet | Michigan | 26047 | 6423 | 86 |
2438965 | 2438965 | 2022-04-24 | Emmet | Michigan | 26047 | 6423 | 86 |
2435709 | 2435709 | 2022-04-23 | Emmet | Michigan | 26047 | 6423 | 86 |
2432453 | 2432453 | 2022-04-22 | Emmet | Michigan | 26047 | 6423 | 86 |
2429197 | 2429197 | 2022-04-21 | Emmet | Michigan | 26047 | 6423 | 86 |
2416011 | 2416011 | 2022-04-17 | Russell | Kentucky | 21207 | 6423 | 86 |
2412755 | 2412755 | 2022-04-16 | Russell | Kentucky | 21207 | 6423 | 86 |
2409499 | 2409499 | 2022-04-15 | Russell | Kentucky | 21207 | 6423 | 86 |
2406243 | 2406243 | 2022-04-14 | Russell | Kentucky | 21207 | 6423 | 86 |
2402987 | 2402987 | 2022-04-13 | Russell | Kentucky | 21207 | 6423 | 86 |
2399733 | 2399733 | 2022-04-12 | Russell | Kentucky | 21207 | 6423 | 86 |
2396477 | 2396477 | 2022-04-11 | Russell | Kentucky | 21207 | 6423 | 86 |
2333672 | 2333672 | 2022-03-23 | Cleburne | Arkansas | 5023 | 6423 | 126 |
2330418 | 2330418 | 2022-03-22 | Cleburne | Arkansas | 5023 | 6423 | 126 |
2308331 | 2308331 | 2022-03-15 | Buena Vista | Iowa | 19021 | 6423 | 56 |
2305080 | 2305080 | 2022-03-14 | Buena Vista | Iowa | 19021 | 6423 | 56 |
2301828 | 2301828 | 2022-03-13 | Buena Vista | Iowa | 19021 | 6423 | 56 |
2298576 | 2298576 | 2022-03-12 | Buena Vista | Iowa | 19021 | 6423 | 56 |
2295324 | 2295324 | 2022-03-11 | Buena Vista | Iowa | 19021 | 6423 | 56 |
2292072 | 2292072 | 2022-03-10 | Buena Vista | Iowa | 19021 | 6423 | 56 |
2288820 | 2288820 | 2022-03-09 | Buena Vista | Iowa | 19021 | 6423 | 56 |
2284195 | 2284195 | 2022-03-07 | DeWitt | Texas | 48123 | 6423 | 96 |
2280943 | 2280943 | 2022-03-06 | DeWitt | Texas | 48123 | 6423 | 96 |
2256922 | 2256922 | 2022-02-27 | Coahoma | Mississippi | 28027 | 6423 | 120 |
2253671 | 2253671 | 2022-02-26 | Coahoma | Mississippi | 28027 | 6423 | 120 |
2250420 | 2250420 | 2022-02-25 | Coahoma | Mississippi | 28027 | 6423 | 120 |
2210747 | 2210747 | 2022-02-13 | Posey | Indiana | 18129 | 6423 | 53 |
2207494 | 2207494 | 2022-02-12 | Posey | Indiana | 18129 | 6423 | 53 |
2204241 | 2204241 | 2022-02-11 | Posey | Indiana | 18129 | 6423 | 53 |
2193856 | 2193856 | 2022-02-08 | Johnson | Arkansas | 5071 | 6423 | 65 |
2166089 | 2166089 | 2022-01-30 | Ravalli | Montana | 30081 | 6423 | 130 |
2162834 | 2162834 | 2022-01-29 | Ravalli | Montana | 30081 | 6423 | 130 |
2159579 | 2159579 | 2022-01-28 | Ravalli | Montana | 30081 | 6423 | 130 |
2150973 | 2150973 | 2022-01-25 | Palo Pinto | Texas | 48363 | 6423 | 134 |
2017174 | 2017174 | 2021-12-15 | Perry | Pennsylvania | 42099 | 6423 | 140 |
1997653 | 1997653 | 2021-12-09 | Jefferson | Pennsylvania | 42065 | 6423 | 157 |
1963647 | 1963647 | 2021-11-29 | Whitley | Indiana | 18183 | 6423 | 61 |
1920250 | 1920250 | 2021-11-15 | Wasatch | Utah | 49051 | 6423 | 29 |
1835720 | 1835720 | 2021-10-20 | Waller | Texas | 48473 | 6423 | 78 |
1808868 | 1808868 | 2021-10-12 | Watauga | North Carolina | 37189 | 6423 | 35 |
1703113 | 1703113 | 2021-09-10 | Mendocino | California | 6045 | 6423 | 67 |
1678035 | 1678035 | 2021-09-02 | Avoyelles | Louisiana | 22009 | 6423 | 146 |
1678400 | 1678400 | 2021-09-02 | Washington | Mississippi | 28151 | 6423 | 143 |
1672555 | 1672555 | 2021-08-31 | Union | Ohio | 39159 | 6423 | 49 |
1666799 | 1666799 | 2021-08-29 | Box Elder | Utah | 49003 | 6423 | 62 |
1663551 | 1663551 | 2021-08-28 | Box Elder | Utah | 49003 | 6423 | 62 |
1660303 | 1660303 | 2021-08-27 | Box Elder | Utah | 49003 | 6423 | 62 |
1612105 | 1612105 | 2021-08-13 | Mississippi | Arkansas | 5093 | 6423 | 114 |
1566593 | 1566593 | 2021-07-30 | Crittenden | Arkansas | 5035 | 6423 | 98 |
1539839 | 1539839 | 2021-07-21 | Roane | Tennessee | 47145 | 6423 | 109 |
1536268 | 1536268 | 2021-07-20 | Carbon | Pennsylvania | 42025 | 6423 | 176 |
1513194 | 1513194 | 2021-07-13 | Duplin | North Carolina | 37061 | 6423 | 142 |
1510309 | 1510309 | 2021-07-12 | Indiana | Pennsylvania | 42063 | 6423 | 179 |
1507062 | 1507062 | 2021-07-11 | Indiana | Pennsylvania | 42063 | 6423 | 179 |
1503816 | 1503816 | 2021-07-10 | Indiana | Pennsylvania | 42063 | 6423 | 179 |
1428793 | 1428793 | 2021-06-17 | Columbus | North Carolina | 37047 | 6423 | 152 |
1394654 | 1394654 | 2021-06-07 | Yuba | California | 6115 | 6423 | 49 |
1259140 | 1259140 | 2021-04-26 | McCracken | Kentucky | 21145 | 6423 | 119 |
1187320 | 1187320 | 2021-04-04 | Boone | Indiana | 18011 | 6423 | 103 |
1102291 | 1102291 | 2021-03-09 | Gila | Arizona | 4007 | 6423 | 217 |
1100149 | 1100149 | 2021-03-08 | Allegany | Maryland | 24001 | 6423 | 200 |
1091748 | 1091748 | 2021-03-05 | Coffee | Tennessee | 47031 | 6423 | 115 |
952846 | 952846 | 2021-01-21 | Portage | Wisconsin | 55097 | 6423 | 60 |
873683 | 873683 | 2020-12-28 | Cleveland | North Carolina | 37045 | 6423 | 137 |
856152 | 856152 | 2020-12-23 | DeKalb | Illinois | 17037 | 6423 | 72 |
775052 | 775052 | 2020-11-28 | Macon | Illinois | 17115 | 6423 | 132 |
777406 | 777406 | 2020-11-28 | Norfolk city | Virginia | 51710 | 6423 | 89 |
760605 | 760605 | 2020-11-23 | Florence | South Carolina | 45041 | 6423 | 211 |
748559 | 748559 | 2020-11-20 | Craighead | Arkansas | 5031 | 6423 | 71 |
722849 | 722849 | 2020-11-12 | Santa Rosa | Florida | 12113 | 6423 | 90 |
396731 | 396731 | 2020-08-03 | Lafayette | Louisiana | 22055 | 6423 | 87 |
357586 | 357586 | 2020-07-22 | Ada | Idaho | 16001 | 6423 | 41 |
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);