ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
266 rows where cases = 2496 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 32
- Iowa 17
- Texas 17
- Illinois 15
- Virginia 15
- Georgia 14
- Alabama 12
- Tennessee 12
- Indiana 11
- Arkansas 10
- Montana 10
- Ohio 9
- Michigan 8
- Missouri 8
- Kentucky 7
- Mississippi 6
- New Hampshire 6
- Puerto Rico 6
- Kansas 5
- New York 5
- Louisiana 4
- Maryland 3
- Minnesota 3
- Pennsylvania 3
- West Virginia 3
- Wisconsin 3
- Arizona 2
- Delaware 2
- Idaho 2
- North Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475057 | 2475057 | 2022-05-05 | Howard | Missouri | 29089 | 2496 | 30 |
2417860 | 2417860 | 2022-04-17 | Charlotte | Virginia | 51037 | 2496 | 45 |
2414604 | 2414604 | 2022-04-16 | Charlotte | Virginia | 51037 | 2496 | 45 |
2411348 | 2411348 | 2022-04-15 | Charlotte | Virginia | 51037 | 2496 | 45 |
2382709 | 2382709 | 2022-04-07 | Liberty | Florida | 12077 | 2496 | 30 |
2379454 | 2379454 | 2022-04-06 | Liberty | Florida | 12077 | 2496 | 30 |
2376200 | 2376200 | 2022-04-05 | Liberty | Florida | 12077 | 2496 | 30 |
2372948 | 2372948 | 2022-04-04 | Liberty | Florida | 12077 | 2496 | 30 |
2369695 | 2369695 | 2022-04-03 | Liberty | Florida | 12077 | 2496 | 30 |
2366442 | 2366442 | 2022-04-02 | Liberty | Florida | 12077 | 2496 | 30 |
2363189 | 2363189 | 2022-04-01 | Liberty | Florida | 12077 | 2496 | 30 |
2359935 | 2359935 | 2022-03-31 | Liberty | Florida | 12077 | 2496 | 30 |
2356681 | 2356681 | 2022-03-30 | Liberty | Florida | 12077 | 2496 | 30 |
2353428 | 2353428 | 2022-03-29 | Liberty | Florida | 12077 | 2496 | 29 |
2350176 | 2350176 | 2022-03-28 | Liberty | Florida | 12077 | 2496 | 29 |
2346923 | 2346923 | 2022-03-27 | Liberty | Florida | 12077 | 2496 | 29 |
2343670 | 2343670 | 2022-03-26 | Liberty | Florida | 12077 | 2496 | 29 |
2340417 | 2340417 | 2022-03-25 | Liberty | Florida | 12077 | 2496 | 29 |
2337164 | 2337164 | 2022-03-24 | Liberty | Florida | 12077 | 2496 | 29 |
2339655 | 2339655 | 2022-03-24 | Terry | Texas | 48445 | 2496 | 84 |
2333910 | 2333910 | 2022-03-23 | Liberty | Florida | 12077 | 2496 | 29 |
2336401 | 2336401 | 2022-03-23 | Terry | Texas | 48445 | 2496 | 84 |
2330656 | 2330656 | 2022-03-22 | Liberty | Florida | 12077 | 2496 | 29 |
2327404 | 2327404 | 2022-03-21 | Liberty | Florida | 12077 | 2496 | 29 |
2324151 | 2324151 | 2022-03-20 | Liberty | Florida | 12077 | 2496 | 29 |
2320897 | 2320897 | 2022-03-19 | Liberty | Florida | 12077 | 2496 | 29 |
2317643 | 2317643 | 2022-03-18 | Liberty | Florida | 12077 | 2496 | 29 |
2314390 | 2314390 | 2022-03-17 | Liberty | Florida | 12077 | 2496 | 29 |
2311137 | 2311137 | 2022-03-16 | Liberty | Florida | 12077 | 2496 | 29 |
2307884 | 2307884 | 2022-03-15 | Liberty | Florida | 12077 | 2496 | 29 |
2309153 | 2309153 | 2022-03-15 | Fergus | Montana | 30027 | 2496 | 54 |
2304633 | 2304633 | 2022-03-14 | Liberty | Florida | 12077 | 2496 | 29 |
2301184 | 2301184 | 2022-03-13 | Perry | Arkansas | 5105 | 2496 | 35 |
2301381 | 2301381 | 2022-03-13 | Liberty | Florida | 12077 | 2496 | 29 |
2298129 | 2298129 | 2022-03-12 | Liberty | Florida | 12077 | 2496 | 29 |
2294877 | 2294877 | 2022-03-11 | Liberty | Florida | 12077 | 2496 | 29 |
2290415 | 2290415 | 2022-03-09 | Santa Isabel | Puerto Rico | 72133 | 2496 | |
2260301 | 2260301 | 2022-02-28 | Linn | Missouri | 29115 | 2496 | 62 |
2233768 | 2233768 | 2022-02-20 | Edmonson | Kentucky | 21061 | 2496 | 38 |
2230517 | 2230517 | 2022-02-19 | Edmonson | Kentucky | 21061 | 2496 | 38 |
2227266 | 2227266 | 2022-02-18 | Edmonson | Kentucky | 21061 | 2496 | 38 |
2210143 | 2210143 | 2022-02-13 | Pike | Arkansas | 5109 | 2496 | 39 |
2211634 | 2211634 | 2022-02-13 | Richland | Montana | 30083 | 2496 | 30 |
2206890 | 2206890 | 2022-02-12 | Pike | Arkansas | 5109 | 2496 | 39 |
2208381 | 2208381 | 2022-02-12 | Richland | Montana | 30083 | 2496 | 30 |
2205128 | 2205128 | 2022-02-11 | Richland | Montana | 30083 | 2496 | 30 |
2200751 | 2200751 | 2022-02-10 | Turner | Georgia | 13287 | 2496 | 52 |
2198388 | 2198388 | 2022-02-09 | Carroll | Mississippi | 28015 | 2496 | 48 |
2167436 | 2167436 | 2022-01-30 | Lexington city | Virginia | 51678 | 2496 | 38 |
2164181 | 2164181 | 2022-01-29 | Lexington city | Virginia | 51678 | 2496 | 38 |
2160926 | 2160926 | 2022-01-28 | Lexington city | Virginia | 51678 | 2496 | 38 |
2152058 | 2152058 | 2022-01-26 | Jasper | Illinois | 17079 | 2496 | 26 |
2086449 | 2086449 | 2022-01-06 | Kusilvak Census Area | Alaska | 2158 | 2496 | 9 |
2085376 | 2085376 | 2022-01-05 | Tillamook | Oregon | 41057 | 2496 | 51 |
2080727 | 2080727 | 2022-01-04 | Mills | Iowa | 19129 | 2496 | 30 |
2077475 | 2077475 | 2022-01-03 | Mills | Iowa | 19129 | 2496 | 30 |
2074224 | 2074224 | 2022-01-02 | Mills | Iowa | 19129 | 2496 | 30 |
2070973 | 2070973 | 2022-01-01 | Mills | Iowa | 19129 | 2496 | 30 |
2067722 | 2067722 | 2021-12-31 | Mills | Iowa | 19129 | 2496 | 30 |
2064471 | 2064471 | 2021-12-30 | Mills | Iowa | 19129 | 2496 | 30 |
2061221 | 2061221 | 2021-12-29 | Mills | Iowa | 19129 | 2496 | 30 |
2057021 | 2057021 | 2021-12-27 | Buffalo | Wisconsin | 55011 | 2496 | 10 |
2027905 | 2027905 | 2021-12-19 | Macon | Alabama | 1087 | 2496 | 68 |
2028524 | 2028524 | 2021-12-19 | Massac | Illinois | 17127 | 2496 | 59 |
2030246 | 2030246 | 2021-12-19 | Moca | Puerto Rico | 72099 | 2496 | |
2025273 | 2025273 | 2021-12-18 | Massac | Illinois | 17127 | 2496 | 59 |
2022022 | 2022022 | 2021-12-17 | Massac | Illinois | 17127 | 2496 | 59 |
2023695 | 2023695 | 2021-12-17 | Aguada | Puerto Rico | 72003 | 2496 | |
2021153 | 2021153 | 2021-12-16 | Southampton | Virginia | 51175 | 2496 | 72 |
2017494 | 2017494 | 2021-12-15 | Bandera | Texas | 48019 | 2496 | 64 |
1986247 | 1986247 | 2021-12-06 | Johnson | Illinois | 17087 | 2496 | 38 |
1984902 | 1984902 | 2021-12-05 | Decatur | Tennessee | 47039 | 2496 | 44 |
1981652 | 1981652 | 2021-12-04 | Decatur | Tennessee | 47039 | 2496 | 44 |
1978402 | 1978402 | 2021-12-03 | Decatur | Tennessee | 47039 | 2496 | 44 |
1978622 | 1978622 | 2021-12-03 | Leon | Texas | 48289 | 2496 | 71 |
1952782 | 1952782 | 2021-11-25 | Appomattox | Virginia | 51011 | 2496 | 36 |
1948952 | 1948952 | 2021-11-24 | Corozal | Puerto Rico | 72047 | 2496 | |
1940132 | 1940132 | 2021-11-22 | Lamar | Alabama | 1075 | 2496 | 53 |
1920607 | 1920607 | 2021-11-16 | Clay | Alabama | 1027 | 2496 | 69 |
1918462 | 1918462 | 2021-11-15 | Webster | Kentucky | 21233 | 2496 | 38 |
1902842 | 1902842 | 2021-11-10 | Saline | Nebraska | 31151 | 2496 | 6 |
1894750 | 1894750 | 2021-11-08 | Madison | Arkansas | 5087 | 2496 | 40 |
1892594 | 1892594 | 2021-11-07 | Antrim | Michigan | 26009 | 2496 | 38 |
1889344 | 1889344 | 2021-11-06 | Antrim | Michigan | 26009 | 2496 | 38 |
1886094 | 1886094 | 2021-11-05 | Antrim | Michigan | 26009 | 2496 | 38 |
1872964 | 1872964 | 2021-11-01 | Union | Kentucky | 21225 | 2496 | 32 |
1856733 | 1856733 | 2021-10-27 | Bienville | Louisiana | 22013 | 2496 | 96 |
1853168 | 1853168 | 2021-10-26 | Cedar | Iowa | 19031 | 2496 | 26 |
1849919 | 1849919 | 2021-10-25 | Cedar | Iowa | 19031 | 2496 | 26 |
1851418 | 1851418 | 2021-10-25 | Montour | Pennsylvania | 42093 | 2496 | 71 |
1846669 | 1846669 | 2021-10-24 | Cedar | Iowa | 19031 | 2496 | 26 |
1843419 | 1843419 | 2021-10-23 | Cedar | Iowa | 19031 | 2496 | 26 |
1840169 | 1840169 | 2021-10-22 | Cedar | Iowa | 19031 | 2496 | 26 |
1836920 | 1836920 | 2021-10-21 | Cedar | Iowa | 19031 | 2496 | 26 |
1833671 | 1833671 | 2021-10-20 | Cedar | Iowa | 19031 | 2496 | 26 |
1815812 | 1815812 | 2021-10-14 | Lee | South Carolina | 45061 | 2496 | 74 |
1812696 | 1812696 | 2021-10-13 | Lewis | Tennessee | 47101 | 2496 | 37 |
1784188 | 1784188 | 2021-10-05 | Washington | Alabama | 1129 | 2496 | 49 |
1783995 | 1783995 | 2021-10-04 | Lincoln | West Virginia | 54043 | 2496 | 37 |
1768604 | 1768604 | 2021-09-30 | Franklin | Indiana | 18047 | 2496 | 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);