ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where cases = 3466 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 14
- Indiana 12
- Ohio 11
- Alabama 10
- Arkansas 10
- North Carolina 10
- Texas 9
- Illinois 8
- Kentucky 7
- Missouri 7
- Michigan 6
- Georgia 5
- Mississippi 5
- Tennessee 5
- Virginia 5
- Maryland 4
- Minnesota 4
- Pennsylvania 4
- Florida 3
- Idaho 3
- Kansas 3
- Louisiana 3
- New York 3
- Oklahoma 3
- Puerto Rico 3
- South Carolina 3
- New Jersey 2
- New Mexico 2
- Arizona 1
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499329 | 2499329 | 2022-05-12 | Martinsville city | Virginia | 51690 | 3466 | 124 |
2491772 | 2491772 | 2022-05-10 | Mitchell | North Carolina | 37121 | 3466 | 37 |
2488514 | 2488514 | 2022-05-09 | Mitchell | North Carolina | 37121 | 3466 | 37 |
2485257 | 2485257 | 2022-05-08 | Mitchell | North Carolina | 37121 | 3466 | 37 |
2481999 | 2481999 | 2022-05-07 | Mitchell | North Carolina | 37121 | 3466 | 37 |
2478741 | 2478741 | 2022-05-06 | Mitchell | North Carolina | 37121 | 3466 | 37 |
2475483 | 2475483 | 2022-05-05 | Mitchell | North Carolina | 37121 | 3466 | 37 |
2472226 | 2472226 | 2022-05-04 | Mitchell | North Carolina | 37121 | 3466 | 37 |
2385786 | 2385786 | 2022-04-08 | Van Buren | Arkansas | 5141 | 3466 | 62 |
2382531 | 2382531 | 2022-04-07 | Van Buren | Arkansas | 5141 | 3466 | 62 |
2358443 | 2358443 | 2022-03-30 | Monroe | Ohio | 39111 | 3466 | 81 |
2353915 | 2353915 | 2022-03-29 | Jefferson | Iowa | 19101 | 3466 | 51 |
2355189 | 2355189 | 2022-03-29 | Monroe | Ohio | 39111 | 3466 | 81 |
2350663 | 2350663 | 2022-03-28 | Jefferson | Iowa | 19101 | 3466 | 51 |
2351936 | 2351936 | 2022-03-28 | Monroe | Ohio | 39111 | 3466 | 81 |
2347410 | 2347410 | 2022-03-27 | Jefferson | Iowa | 19101 | 3466 | 51 |
2348684 | 2348684 | 2022-03-27 | Monroe | Ohio | 39111 | 3466 | 81 |
2344157 | 2344157 | 2022-03-26 | Jefferson | Iowa | 19101 | 3466 | 51 |
2345431 | 2345431 | 2022-03-26 | Monroe | Ohio | 39111 | 3466 | 81 |
2340904 | 2340904 | 2022-03-25 | Jefferson | Iowa | 19101 | 3466 | 51 |
2342178 | 2342178 | 2022-03-25 | Monroe | Ohio | 39111 | 3466 | 81 |
2337651 | 2337651 | 2022-03-24 | Jefferson | Iowa | 19101 | 3466 | 51 |
2338925 | 2338925 | 2022-03-24 | Monroe | Ohio | 39111 | 3466 | 81 |
2334397 | 2334397 | 2022-03-23 | Jefferson | Iowa | 19101 | 3466 | 51 |
2319625 | 2319625 | 2022-03-18 | Anasco | Puerto Rico | 72011 | 3466 | |
2316371 | 2316371 | 2022-03-17 | Anasco | Puerto Rico | 72011 | 3466 | |
2309864 | 2309864 | 2022-03-15 | Aibonito | Puerto Rico | 72009 | 3466 | |
2292625 | 2292625 | 2022-03-10 | Kanabec | Minnesota | 27065 | 3466 | 54 |
2246406 | 2246406 | 2022-02-24 | Menard | Illinois | 17129 | 3466 | 23 |
2194895 | 2194895 | 2022-02-08 | West Carroll | Louisiana | 22123 | 3466 | 56 |
2195200 | 2195200 | 2022-02-08 | Walthall | Mississippi | 28147 | 3466 | 74 |
2196648 | 2196648 | 2022-02-08 | Appomattox | Virginia | 51011 | 3466 | 47 |
2189017 | 2189017 | 2022-02-06 | Unknown | New Jersey | 3466 | 0 | |
2179006 | 2179006 | 2022-02-03 | Macon | Missouri | 29121 | 3466 | 43 |
2173937 | 2173937 | 2022-02-01 | King William | Virginia | 51101 | 3466 | 27 |
2162737 | 2162737 | 2022-01-29 | Livingston | Missouri | 29117 | 3466 | 86 |
2157966 | 2157966 | 2022-01-28 | Macon | Alabama | 1087 | 3466 | 69 |
2154713 | 2154713 | 2022-01-27 | Macon | Alabama | 1087 | 3466 | 69 |
2151460 | 2151460 | 2022-01-26 | Macon | Alabama | 1087 | 3466 | 69 |
2148208 | 2148208 | 2022-01-25 | Macon | Alabama | 1087 | 3466 | 69 |
2144956 | 2144956 | 2022-01-24 | Macon | Alabama | 1087 | 3466 | 69 |
2145504 | 2145504 | 2022-01-24 | Minidoka | Idaho | 16067 | 3466 | 55 |
2129038 | 2129038 | 2022-01-19 | Banks | Georgia | 13011 | 3466 | 73 |
2131349 | 2131349 | 2022-01-19 | Freestone | Texas | 48161 | 3466 | 76 |
2103453 | 2103453 | 2022-01-11 | Dickinson | Iowa | 19059 | 3466 | 61 |
2100202 | 2100202 | 2022-01-10 | Dickinson | Iowa | 19059 | 3466 | 61 |
2096264 | 2096264 | 2022-01-09 | Hempstead | Arkansas | 5057 | 3466 | 50 |
2096738 | 2096738 | 2022-01-09 | Clark | Illinois | 17023 | 3466 | 54 |
2096951 | 2096951 | 2022-01-09 | Dickinson | Iowa | 19059 | 3466 | 61 |
2093012 | 2093012 | 2022-01-08 | Hempstead | Arkansas | 5057 | 3466 | 50 |
2093486 | 2093486 | 2022-01-08 | Clark | Illinois | 17023 | 3466 | 54 |
2093699 | 2093699 | 2022-01-08 | Dickinson | Iowa | 19059 | 3466 | 61 |
2090234 | 2090234 | 2022-01-07 | Clark | Illinois | 17023 | 3466 | 54 |
2090447 | 2090447 | 2022-01-07 | Dickinson | Iowa | 19059 | 3466 | 61 |
2087196 | 2087196 | 2022-01-06 | Dickinson | Iowa | 19059 | 3466 | 61 |
2089137 | 2089137 | 2022-01-06 | Lavaca | Texas | 48285 | 3466 | 100 |
2083944 | 2083944 | 2022-01-05 | Dickinson | Iowa | 19059 | 3466 | 61 |
2061041 | 2061041 | 2021-12-29 | Richland | Illinois | 17159 | 3466 | 76 |
2006421 | 2006421 | 2021-12-12 | Roscommon | Michigan | 26143 | 3466 | 92 |
2001861 | 2001861 | 2021-12-11 | Butler | Alabama | 1013 | 3466 | 102 |
2003170 | 2003170 | 2021-12-11 | Roscommon | Michigan | 26143 | 3466 | 92 |
1999920 | 1999920 | 2021-12-10 | Roscommon | Michigan | 26143 | 3466 | 92 |
1992205 | 1992205 | 2021-12-08 | La Paz | Arizona | 4012 | 3466 | 105 |
1984968 | 1984968 | 2021-12-05 | Union | Tennessee | 47173 | 3466 | 51 |
1981718 | 1981718 | 2021-12-04 | Union | Tennessee | 47173 | 3466 | 51 |
1978468 | 1978468 | 2021-12-03 | Union | Tennessee | 47173 | 3466 | 51 |
1963615 | 1963615 | 2021-11-29 | Owen | Indiana | 18119 | 3466 | 79 |
1960809 | 1960809 | 2021-11-28 | Caroline | Maryland | 24011 | 3466 | 52 |
1944655 | 1944655 | 2021-11-23 | Osceola | Michigan | 26133 | 3466 | 48 |
1941404 | 1941404 | 2021-11-22 | Osceola | Michigan | 26133 | 3466 | 48 |
1937574 | 1937574 | 2021-11-21 | Fulton | Indiana | 18049 | 3466 | 70 |
1934324 | 1934324 | 2021-11-20 | Fulton | Indiana | 18049 | 3466 | 70 |
1931073 | 1931073 | 2021-11-19 | Fulton | Indiana | 18049 | 3466 | 70 |
1925484 | 1925484 | 2021-11-17 | Lincoln | Montana | 30053 | 3466 | 59 |
1895598 | 1895598 | 2021-11-08 | Adair | Kentucky | 21001 | 3466 | 82 |
1892348 | 1892348 | 2021-11-07 | Adair | Kentucky | 21001 | 3466 | 82 |
1889098 | 1889098 | 2021-11-06 | Adair | Kentucky | 21001 | 3466 | 82 |
1885848 | 1885848 | 2021-11-05 | Adair | Kentucky | 21001 | 3466 | 82 |
1853477 | 1853477 | 2021-10-26 | Woodford | Kentucky | 21239 | 3466 | 27 |
1830001 | 1830001 | 2021-10-19 | Appling | Georgia | 13001 | 3466 | 102 |
1830297 | 1830297 | 2021-10-19 | Shelby | Illinois | 17173 | 3466 | 51 |
1830382 | 1830382 | 2021-10-19 | Randolph | Indiana | 18135 | 3466 | 100 |
1801160 | 1801160 | 2021-10-10 | Washington | Indiana | 18175 | 3466 | 47 |
1797911 | 1797911 | 2021-10-09 | Washington | Indiana | 18175 | 3466 | 47 |
1794662 | 1794662 | 2021-10-08 | Washington | Indiana | 18175 | 3466 | 47 |
1745708 | 1745708 | 2021-09-23 | Cassia | Idaho | 16031 | 3466 | 29 |
1746042 | 1746042 | 2021-09-23 | Cherokee | Kansas | 20021 | 3466 | 74 |
1742008 | 1742008 | 2021-09-22 | Cleburne | Arkansas | 5023 | 3466 | 88 |
1742793 | 1742793 | 2021-09-22 | Cherokee | Kansas | 20021 | 3466 | 74 |
1688940 | 1688940 | 2021-09-05 | Clarion | Pennsylvania | 42031 | 3466 | 99 |
1662772 | 1662772 | 2021-08-28 | Jackson | Ohio | 39079 | 3466 | 55 |
1630645 | 1630645 | 2021-08-18 | Union | South Carolina | 45087 | 3466 | 83 |
1627232 | 1627232 | 2021-08-17 | Greene | Pennsylvania | 42059 | 3466 | 42 |
1623134 | 1623134 | 2021-08-16 | Itawamba | Mississippi | 28057 | 3466 | 83 |
1585292 | 1585292 | 2021-08-04 | Marion | Tennessee | 47115 | 3466 | 50 |
1580934 | 1580934 | 2021-08-03 | Scott | Mississippi | 28123 | 3466 | 77 |
1577163 | 1577163 | 2021-08-02 | McPherson | Kansas | 20113 | 3466 | 86 |
1569334 | 1569334 | 2021-07-30 | Willacy | Texas | 48489 | 3466 | 93 |
1561834 | 1561834 | 2021-07-28 | Greene | New York | 36039 | 3466 | 79 |
1555248 | 1555248 | 2021-07-26 | Lyon | Nevada | 32019 | 3466 | 68 |
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);