ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 3279 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 15
- Montana 13
- Arkansas 12
- Missouri 12
- Indiana 9
- Wisconsin 9
- Florida 7
- Georgia 7
- Idaho 7
- Illinois 7
- Texas 7
- Virginia 7
- Michigan 6
- Alabama 5
- Ohio 5
- Tennessee 5
- Kentucky 4
- New York 4
- Minnesota 3
- Colorado 2
- Hawaii 2
- New Jersey 2
- Puerto Rico 2
- South Carolina 2
- Arizona 1
- California 1
- Iowa 1
- Maryland 1
- Mississippi 1
- North Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501235 | 2501235 | 2022-05-13 | Roosevelt | Montana | 30085 | 3279 | 74 |
2497977 | 2497977 | 2022-05-12 | Roosevelt | Montana | 30085 | 3279 | 74 |
2494719 | 2494719 | 2022-05-11 | Roosevelt | Montana | 30085 | 3279 | 74 |
2496272 | 2496272 | 2022-05-11 | Price | Wisconsin | 55099 | 3279 | 33 |
2491461 | 2491461 | 2022-05-10 | Roosevelt | Montana | 30085 | 3279 | 74 |
2488203 | 2488203 | 2022-05-09 | Roosevelt | Montana | 30085 | 3279 | 74 |
2484946 | 2484946 | 2022-05-08 | Roosevelt | Montana | 30085 | 3279 | 74 |
2481688 | 2481688 | 2022-05-07 | Roosevelt | Montana | 30085 | 3279 | 74 |
2478430 | 2478430 | 2022-05-06 | Roosevelt | Montana | 30085 | 3279 | 74 |
2475172 | 2475172 | 2022-05-05 | Roosevelt | Montana | 30085 | 3279 | 74 |
2471915 | 2471915 | 2022-05-04 | Roosevelt | Montana | 30085 | 3279 | 74 |
2467150 | 2467150 | 2022-05-03 | Little River | Arkansas | 5081 | 3279 | 104 |
2463895 | 2463895 | 2022-05-02 | Little River | Arkansas | 5081 | 3279 | 104 |
2460639 | 2460639 | 2022-05-01 | Little River | Arkansas | 5081 | 3279 | 104 |
2457383 | 2457383 | 2022-04-30 | Little River | Arkansas | 5081 | 3279 | 104 |
2454127 | 2454127 | 2022-04-29 | Little River | Arkansas | 5081 | 3279 | 104 |
2448601 | 2448601 | 2022-04-27 | Claiborne | Louisiana | 22027 | 3279 | 76 |
2445345 | 2445345 | 2022-04-26 | Claiborne | Louisiana | 22027 | 3279 | 76 |
2442089 | 2442089 | 2022-04-25 | Claiborne | Louisiana | 22027 | 3279 | 76 |
2438833 | 2438833 | 2022-04-24 | Claiborne | Louisiana | 22027 | 3279 | 76 |
2435577 | 2435577 | 2022-04-23 | Claiborne | Louisiana | 22027 | 3279 | 76 |
2432321 | 2432321 | 2022-04-22 | Claiborne | Louisiana | 22027 | 3279 | 76 |
2429065 | 2429065 | 2022-04-21 | Claiborne | Louisiana | 22027 | 3279 | 76 |
2392696 | 2392696 | 2022-04-10 | Gooding | Idaho | 16047 | 3279 | 54 |
2395277 | 2395277 | 2022-04-10 | Ashland | Wisconsin | 55003 | 3279 | 36 |
2389440 | 2389440 | 2022-04-09 | Gooding | Idaho | 16047 | 3279 | 54 |
2392021 | 2392021 | 2022-04-09 | Ashland | Wisconsin | 55003 | 3279 | 36 |
2386185 | 2386185 | 2022-04-08 | Gooding | Idaho | 16047 | 3279 | 54 |
2388765 | 2388765 | 2022-04-08 | Ashland | Wisconsin | 55003 | 3279 | 36 |
2382930 | 2382930 | 2022-04-07 | Gooding | Idaho | 16047 | 3279 | 54 |
2379675 | 2379675 | 2022-04-06 | Gooding | Idaho | 16047 | 3279 | 54 |
2379002 | 2379002 | 2022-04-05 | Bayfield | Wisconsin | 55007 | 3279 | 40 |
2325606 | 2325606 | 2022-03-20 | Unknown | New Jersey | 3279 | 0 | |
2289827 | 2289827 | 2022-03-09 | Unknown | New Jersey | 3279 | 0 | |
2267485 | 2267485 | 2022-03-02 | Curry | Oregon | 41015 | 3279 | 44 |
2245471 | 2245471 | 2022-02-23 | Greensville | Virginia | 51081 | 3279 | 33 |
2240772 | 2240772 | 2022-02-22 | Gasconade | Missouri | 29073 | 3279 | 93 |
2171346 | 2171346 | 2022-02-01 | Brooks | Georgia | 13027 | 3279 | 77 |
2153894 | 2153894 | 2022-01-26 | Clay | South Dakota | 46027 | 3279 | 19 |
2142425 | 2142425 | 2022-01-23 | Pike | Indiana | 18125 | 3279 | 46 |
2144850 | 2144850 | 2022-01-23 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2139170 | 2139170 | 2022-01-22 | Pike | Indiana | 18125 | 3279 | 46 |
2141595 | 2141595 | 2022-01-22 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2135914 | 2135914 | 2022-01-21 | Pike | Indiana | 18125 | 3279 | 46 |
2138339 | 2138339 | 2022-01-21 | Lafayette | Wisconsin | 55065 | 3279 | 18 |
2122270 | 2122270 | 2022-01-17 | Franklin | Arkansas | 5047 | 3279 | 61 |
2112524 | 2112524 | 2022-01-14 | Izard | Arkansas | 5065 | 3279 | 59 |
2106487 | 2106487 | 2022-01-12 | Carroll | Illinois | 17015 | 3279 | 43 |
2078138 | 2078138 | 2022-01-03 | Cooper | Missouri | 29053 | 3279 | 58 |
2074075 | 2074075 | 2022-01-02 | Carroll | Indiana | 18015 | 3279 | 47 |
2070824 | 2070824 | 2022-01-01 | Carroll | Indiana | 18015 | 3279 | 47 |
2067573 | 2067573 | 2021-12-31 | Carroll | Indiana | 18015 | 3279 | 47 |
2064322 | 2064322 | 2021-12-30 | Carroll | Indiana | 18015 | 3279 | 47 |
2054403 | 2054403 | 2021-12-27 | Washington | Georgia | 13303 | 3279 | 124 |
2051920 | 2051920 | 2021-12-26 | Ogemaw | Michigan | 26129 | 3279 | 80 |
2047395 | 2047395 | 2021-12-25 | Henry | Alabama | 1067 | 3279 | 66 |
2048670 | 2048670 | 2021-12-25 | Ogemaw | Michigan | 26129 | 3279 | 80 |
2045420 | 2045420 | 2021-12-24 | Ogemaw | Michigan | 26129 | 3279 | 80 |
2041262 | 2041262 | 2021-12-23 | Ben Hill | Georgia | 13017 | 3279 | 111 |
2042170 | 2042170 | 2021-12-23 | Ogemaw | Michigan | 26129 | 3279 | 80 |
2037622 | 2037622 | 2021-12-22 | Cherokee | Alabama | 1019 | 3279 | 64 |
2038921 | 2038921 | 2021-12-22 | Ogemaw | Michigan | 26129 | 3279 | 80 |
2011772 | 2011772 | 2021-12-14 | Phillips | Arkansas | 5107 | 3279 | 79 |
2008912 | 2008912 | 2021-12-13 | Kauai | Hawaii | 15007 | 3279 | 13 |
2005787 | 2005787 | 2021-12-12 | Richland | Illinois | 17159 | 3279 | 72 |
2002536 | 2002536 | 2021-12-11 | Richland | Illinois | 17159 | 3279 | 72 |
1999286 | 1999286 | 2021-12-10 | Richland | Illinois | 17159 | 3279 | 72 |
1991974 | 1991974 | 2021-12-07 | Lincoln | West Virginia | 54043 | 3279 | 54 |
1961208 | 1961208 | 2021-11-28 | Vernon | Missouri | 29217 | 3279 | 81 |
1957957 | 1957957 | 2021-11-27 | Vernon | Missouri | 29217 | 3279 | 81 |
1954706 | 1954706 | 2021-11-26 | Vernon | Missouri | 29217 | 3279 | 81 |
1951455 | 1951455 | 2021-11-25 | Vernon | Missouri | 29217 | 3279 | 81 |
1948204 | 1948204 | 2021-11-24 | Vernon | Missouri | 29217 | 3279 | 81 |
1937948 | 1937948 | 2021-11-21 | Rockcastle | Kentucky | 21203 | 3279 | 36 |
1934698 | 1934698 | 2021-11-20 | Rockcastle | Kentucky | 21203 | 3279 | 36 |
1931447 | 1931447 | 2021-11-19 | Rockcastle | Kentucky | 21203 | 3279 | 36 |
1897899 | 1897899 | 2021-11-09 | Pickens | Alabama | 1107 | 3279 | 85 |
1888216 | 1888216 | 2021-11-06 | Clark | Arkansas | 5019 | 3279 | 59 |
1883232 | 1883232 | 2021-11-04 | Hill | Montana | 30041 | 3279 | 64 |
1880740 | 1880740 | 2021-11-03 | Rio Grande | Puerto Rico | 72119 | 3279 | |
1861605 | 1861605 | 2021-10-28 | Jones | Texas | 48253 | 3279 | 73 |
1855753 | 1855753 | 2021-10-27 | Lawrence | Arkansas | 5075 | 3279 | 57 |
1829665 | 1829665 | 2021-10-19 | Randolph | Alabama | 1111 | 3279 | 63 |
1810166 | 1810166 | 2021-10-13 | Monroe | Alabama | 1099 | 3279 | 61 |
1806663 | 1806663 | 2021-10-11 | Staunton city | Virginia | 51790 | 3279 | 79 |
1803413 | 1803413 | 2021-10-10 | Staunton city | Virginia | 51790 | 3279 | 79 |
1800164 | 1800164 | 2021-10-09 | Staunton city | Virginia | 51790 | 3279 | 79 |
1796915 | 1796915 | 2021-10-08 | Staunton city | Virginia | 51790 | 3279 | 79 |
1757700 | 1757700 | 2021-09-26 | Reeves | Texas | 48389 | 3279 | 47 |
1751069 | 1751069 | 2021-09-24 | Deaf Smith | Texas | 48117 | 3279 | 69 |
1728404 | 1728404 | 2021-09-17 | Lampasas | Texas | 48281 | 3279 | 51 |
1696978 | 1696978 | 2021-09-08 | Cassia | Idaho | 16031 | 3279 | 29 |
1681378 | 1681378 | 2021-09-03 | Queen Anne's | Maryland | 24035 | 3279 | 58 |
1676227 | 1676227 | 2021-09-01 | Haywood | Tennessee | 47075 | 3279 | 66 |
1657600 | 1657600 | 2021-08-27 | Sevier | Arkansas | 5133 | 3279 | 30 |
1656056 | 1656056 | 2021-08-26 | Orleans | New York | 36073 | 3279 | 83 |
1607351 | 1607351 | 2021-08-11 | Washington | New York | 36115 | 3279 | 56 |
1590771 | 1590771 | 2021-08-06 | Miller | Missouri | 29131 | 3279 | 63 |
1584310 | 1584310 | 2021-08-04 | Stone | Missouri | 29209 | 3279 | 56 |
1581918 | 1581918 | 2021-08-03 | Union | South Carolina | 45087 | 3279 | 82 |
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);