ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where cases = 3259 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 18
- Georgia 14
- Mississippi 12
- Ohio 11
- Virginia 11
- Texas 9
- Michigan 8
- Illinois 7
- Kansas 7
- Oklahoma 7
- Tennessee 7
- Arkansas 6
- North Carolina 6
- Oregon 6
- Wisconsin 6
- Missouri 5
- Montana 5
- Puerto Rico 5
- Alabama 4
- Minnesota 4
- Utah 4
- Indiana 3
- California 2
- Idaho 2
- Pennsylvania 2
- Arizona 1
- Colorado 1
- Delaware 1
- Florida 1
- Kentucky 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500995 | 2500995 | 2022-05-13 | Amite | Mississippi | 28005 | 3259 | 69 |
2497737 | 2497737 | 2022-05-12 | Amite | Mississippi | 28005 | 3259 | 69 |
2494479 | 2494479 | 2022-05-11 | Amite | Mississippi | 28005 | 3259 | 69 |
2491221 | 2491221 | 2022-05-10 | Amite | Mississippi | 28005 | 3259 | 69 |
2487964 | 2487964 | 2022-05-09 | Amite | Mississippi | 28005 | 3259 | 69 |
2484442 | 2484442 | 2022-05-08 | Madison | Louisiana | 22065 | 3259 | 59 |
2481184 | 2481184 | 2022-05-07 | Madison | Louisiana | 22065 | 3259 | 59 |
2477926 | 2477926 | 2022-05-06 | Madison | Louisiana | 22065 | 3259 | 59 |
2474668 | 2474668 | 2022-05-05 | Madison | Louisiana | 22065 | 3259 | 59 |
2476461 | 2476461 | 2022-05-05 | Brunswick | Virginia | 51025 | 3259 | 47 |
2471411 | 2471411 | 2022-05-04 | Madison | Louisiana | 22065 | 3259 | 59 |
2473203 | 2473203 | 2022-05-04 | Brunswick | Virginia | 51025 | 3259 | 47 |
2463699 | 2463699 | 2022-05-01 | Price | Wisconsin | 55099 | 3259 | 33 |
2460443 | 2460443 | 2022-04-30 | Price | Wisconsin | 55099 | 3259 | 33 |
2457187 | 2457187 | 2022-04-29 | Price | Wisconsin | 55099 | 3259 | 33 |
2447269 | 2447269 | 2022-04-26 | Westmoreland | Virginia | 51193 | 3259 | 51 |
2359361 | 2359361 | 2022-03-30 | Rockbridge | Virginia | 51163 | 3259 | 76 |
2352854 | 2352854 | 2022-03-28 | Rockbridge | Virginia | 51163 | 3259 | 75 |
2328701 | 2328701 | 2022-03-21 | Roosevelt | Montana | 30085 | 3259 | 72 |
2325449 | 2325449 | 2022-03-20 | Roosevelt | Montana | 30085 | 3259 | 72 |
2322195 | 2322195 | 2022-03-19 | Roosevelt | Montana | 30085 | 3259 | 72 |
2318941 | 2318941 | 2022-03-18 | Roosevelt | Montana | 30085 | 3259 | 72 |
2319672 | 2319672 | 2022-03-18 | Naguabo | Puerto Rico | 72103 | 3259 | |
2316418 | 2316418 | 2022-03-17 | Naguabo | Puerto Rico | 72103 | 3259 | |
2312900 | 2312900 | 2022-03-16 | Morgan | Ohio | 39115 | 3259 | 55 |
2309647 | 2309647 | 2022-03-15 | Morgan | Ohio | 39115 | 3259 | 55 |
2306394 | 2306394 | 2022-03-14 | Morgan | Ohio | 39115 | 3259 | 55 |
2307167 | 2307167 | 2022-03-14 | Millard | Utah | 49027 | 3259 | 35 |
2303143 | 2303143 | 2022-03-13 | Morgan | Ohio | 39115 | 3259 | 55 |
2303916 | 2303916 | 2022-03-13 | Millard | Utah | 49027 | 3259 | 35 |
2300664 | 2300664 | 2022-03-12 | Millard | Utah | 49027 | 3259 | 35 |
2296639 | 2296639 | 2022-03-11 | Morgan | Ohio | 39115 | 3259 | 55 |
2297412 | 2297412 | 2022-03-11 | Millard | Utah | 49027 | 3259 | 35 |
2293387 | 2293387 | 2022-03-10 | Morgan | Ohio | 39115 | 3259 | 55 |
2286728 | 2286728 | 2022-03-08 | Mitchell | North Carolina | 37121 | 3259 | 34 |
2270312 | 2270312 | 2022-03-03 | Unknown | New Jersey | 3259 | 0 | |
2263130 | 2263130 | 2022-03-01 | Claiborne | Louisiana | 22027 | 3259 | 73 |
2259879 | 2259879 | 2022-02-28 | Claiborne | Louisiana | 22027 | 3259 | 73 |
2256628 | 2256628 | 2022-02-27 | Claiborne | Louisiana | 22027 | 3259 | 73 |
2253377 | 2253377 | 2022-02-26 | Claiborne | Louisiana | 22027 | 3259 | 73 |
2250126 | 2250126 | 2022-02-25 | Claiborne | Louisiana | 22027 | 3259 | 73 |
2246875 | 2246875 | 2022-02-24 | Claiborne | Louisiana | 22027 | 3259 | 73 |
2242282 | 2242282 | 2022-02-22 | Southampton | Virginia | 51175 | 3259 | 82 |
2190226 | 2190226 | 2022-02-06 | Patrick | Virginia | 51141 | 3259 | 78 |
2186973 | 2186973 | 2022-02-05 | Patrick | Virginia | 51141 | 3259 | 78 |
2183720 | 2183720 | 2022-02-04 | Patrick | Virginia | 51141 | 3259 | 78 |
2172340 | 2172340 | 2022-02-01 | Sibley | Minnesota | 27143 | 3259 | 23 |
2165618 | 2165618 | 2022-01-30 | West Carroll | Louisiana | 22123 | 3259 | 53 |
2162363 | 2162363 | 2022-01-29 | West Carroll | Louisiana | 22123 | 3259 | 53 |
2159108 | 2159108 | 2022-01-28 | West Carroll | Louisiana | 22123 | 3259 | 53 |
2154354 | 2154354 | 2022-01-26 | Appomattox | Virginia | 51011 | 3259 | 41 |
2147784 | 2147784 | 2022-01-24 | Wilbarger | Texas | 48487 | 3259 | 77 |
2103298 | 2103298 | 2022-01-11 | Moultrie | Illinois | 17139 | 3259 | 47 |
2104976 | 2104976 | 2022-01-11 | Catano | Puerto Rico | 72033 | 3259 | |
2087725 | 2087725 | 2022-01-06 | Houston | Minnesota | 27055 | 3259 | 18 |
2078576 | 2078576 | 2022-01-03 | Madison | North Carolina | 37115 | 3259 | 66 |
2034540 | 2034540 | 2021-12-21 | Sharp | Arkansas | 5135 | 3259 | 76 |
2036532 | 2036532 | 2021-12-21 | Craig | Oklahoma | 40035 | 3259 | 36 |
2037131 | 2037131 | 2021-12-21 | Lavaca | Texas | 48285 | 3259 | 100 |
2031146 | 2031146 | 2021-12-20 | Henry | Alabama | 1067 | 3259 | 66 |
2033282 | 2033282 | 2021-12-20 | Craig | Oklahoma | 40035 | 3259 | 36 |
2033881 | 2033881 | 2021-12-20 | Lavaca | Texas | 48285 | 3259 | 100 |
2030032 | 2030032 | 2021-12-19 | Craig | Oklahoma | 40035 | 3259 | 36 |
2026781 | 2026781 | 2021-12-18 | Craig | Oklahoma | 40035 | 3259 | 36 |
2021369 | 2021369 | 2021-12-17 | Cherokee | Alabama | 1019 | 3259 | 64 |
2023530 | 2023530 | 2021-12-17 | Craig | Oklahoma | 40035 | 3259 | 36 |
2018650 | 2018650 | 2021-12-16 | Washington | Georgia | 13303 | 3259 | 124 |
2020279 | 2020279 | 2021-12-16 | Craig | Oklahoma | 40035 | 3259 | 36 |
2017028 | 2017028 | 2021-12-15 | Craig | Oklahoma | 40035 | 3259 | 36 |
1982223 | 1982223 | 2021-12-04 | Lincoln | West Virginia | 54043 | 3259 | 53 |
1969545 | 1969545 | 2021-12-01 | Colusa | California | 6011 | 3259 | 21 |
1971952 | 1971952 | 2021-12-01 | Polk | Tennessee | 47139 | 3259 | 33 |
1933268 | 1933268 | 2021-11-19 | Windsor | Vermont | 50027 | 3259 | 33 |
1927492 | 1927492 | 2021-11-18 | Ben Hill | Georgia | 13017 | 3259 | 105 |
1924242 | 1924242 | 2021-11-17 | Ben Hill | Georgia | 13017 | 3259 | 105 |
1920993 | 1920993 | 2021-11-16 | Ben Hill | Georgia | 13017 | 3259 | 105 |
1917309 | 1917309 | 2021-11-14 | Taylor | Wisconsin | 55119 | 3259 | 47 |
1914059 | 1914059 | 2021-11-13 | Taylor | Wisconsin | 55119 | 3259 | 47 |
1910809 | 1910809 | 2021-11-12 | Taylor | Wisconsin | 55119 | 3259 | 47 |
1901198 | 1901198 | 2021-11-10 | La Paz | Arizona | 4012 | 3259 | 100 |
1880919 | 1880919 | 2021-11-03 | Humphreys | Tennessee | 47085 | 3259 | 47 |
1876734 | 1876734 | 2021-11-02 | Hill | Montana | 30041 | 3259 | 63 |
1868721 | 1868721 | 2021-10-31 | Clark | Arkansas | 5019 | 3259 | 58 |
1842007 | 1842007 | 2021-10-22 | Burleson | Texas | 48051 | 3259 | 59 |
1832002 | 1832002 | 2021-10-19 | Rio Grande | Puerto Rico | 72119 | 3259 | |
1828753 | 1828753 | 2021-10-18 | Rio Grande | Puerto Rico | 72119 | 3259 | |
1778952 | 1778952 | 2021-10-03 | Wexford | Michigan | 26165 | 3259 | 50 |
1775702 | 1775702 | 2021-10-02 | Wexford | Michigan | 26165 | 3259 | 50 |
1772452 | 1772452 | 2021-10-01 | Wexford | Michigan | 26165 | 3259 | 50 |
1765399 | 1765399 | 2021-09-29 | Randolph | Indiana | 18135 | 3259 | 93 |
1763061 | 1763061 | 2021-09-28 | Cass | Nebraska | 31025 | 3259 | 19 |
1759548 | 1759548 | 2021-09-27 | Attala | Mississippi | 28007 | 3259 | 87 |
1742010 | 1742010 | 2021-09-22 | Columbia | Arkansas | 5027 | 3259 | 65 |
1742463 | 1742463 | 2021-09-22 | Elmore | Idaho | 16039 | 3259 | 29 |
1743985 | 1743985 | 2021-09-22 | Holmes | Ohio | 39075 | 3259 | 108 |
1718658 | 1718658 | 2021-09-14 | Lampasas | Texas | 48281 | 3259 | 50 |
1712837 | 1712837 | 2021-09-13 | Calaveras | California | 6009 | 3259 | 65 |
1698398 | 1698398 | 2021-09-08 | Transylvania | North Carolina | 37175 | 3259 | 36 |
1699386 | 1699386 | 2021-09-08 | Halifax | Virginia | 51083 | 3259 | 89 |
1693730 | 1693730 | 2021-09-07 | Cassia | Idaho | 16031 | 3259 | 29 |
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);