ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where cases = 4109 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 25
- Texas 19
- Oklahoma 8
- Virginia 8
- Iowa 7
- North Carolina 7
- Missouri 6
- Tennessee 5
- Georgia 4
- Illinois 4
- Indiana 4
- Mississippi 4
- Ohio 4
- West Virginia 4
- Wisconsin 4
- Alabama 3
- Alaska 3
- Oregon 3
- Pennsylvania 3
- Washington 3
- Arkansas 2
- Idaho 2
- Kansas 2
- Michigan 2
- Minnesota 2
- New York 2
- Utah 2
- Louisiana 1
- Nevada 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440606 | 2440606 | 2022-04-24 | Unknown | Utah | 4109 | 94 | |
2437350 | 2437350 | 2022-04-23 | Unknown | Utah | 4109 | 94 | |
2415940 | 2415940 | 2022-04-17 | Estill | Kentucky | 21065 | 4109 | 45 |
2412684 | 2412684 | 2022-04-16 | Estill | Kentucky | 21065 | 4109 | 45 |
2409428 | 2409428 | 2022-04-15 | Estill | Kentucky | 21065 | 4109 | 45 |
2406172 | 2406172 | 2022-04-14 | Estill | Kentucky | 21065 | 4109 | 45 |
2402916 | 2402916 | 2022-04-13 | Estill | Kentucky | 21065 | 4109 | 45 |
2399662 | 2399662 | 2022-04-12 | Estill | Kentucky | 21065 | 4109 | 45 |
2396406 | 2396406 | 2022-04-11 | Estill | Kentucky | 21065 | 4109 | 45 |
2393151 | 2393151 | 2022-04-10 | Estill | Kentucky | 21065 | 4109 | 45 |
2389895 | 2389895 | 2022-04-09 | Estill | Kentucky | 21065 | 4109 | 45 |
2386639 | 2386639 | 2022-04-08 | Estill | Kentucky | 21065 | 4109 | 45 |
2383384 | 2383384 | 2022-04-07 | Estill | Kentucky | 21065 | 4109 | 45 |
2380129 | 2380129 | 2022-04-06 | Estill | Kentucky | 21065 | 4109 | 45 |
2376874 | 2376874 | 2022-04-05 | Estill | Kentucky | 21065 | 4109 | 45 |
2373622 | 2373622 | 2022-04-04 | Estill | Kentucky | 21065 | 4109 | 45 |
2302948 | 2302948 | 2022-03-13 | Chowan | North Carolina | 37041 | 4109 | 54 |
2299696 | 2299696 | 2022-03-12 | Chowan | North Carolina | 37041 | 4109 | 54 |
2296444 | 2296444 | 2022-03-11 | Chowan | North Carolina | 37041 | 4109 | 54 |
2293192 | 2293192 | 2022-03-10 | Chowan | North Carolina | 37041 | 4109 | 54 |
2285574 | 2285574 | 2022-03-08 | Cedar | Iowa | 19031 | 4109 | 33 |
2282322 | 2282322 | 2022-03-07 | Cedar | Iowa | 19031 | 4109 | 33 |
2279069 | 2279069 | 2022-03-06 | Cedar | Iowa | 19031 | 4109 | 33 |
2275816 | 2275816 | 2022-03-05 | Cedar | Iowa | 19031 | 4109 | 33 |
2272563 | 2272563 | 2022-03-04 | Cedar | Iowa | 19031 | 4109 | 33 |
2269311 | 2269311 | 2022-03-03 | Cedar | Iowa | 19031 | 4109 | 33 |
2266058 | 2266058 | 2022-03-02 | Cedar | Iowa | 19031 | 4109 | 33 |
2262079 | 2262079 | 2022-03-01 | Northwest Arctic Borough | Alaska | 2188 | 4109 | 11 |
2258828 | 2258828 | 2022-02-28 | Northwest Arctic Borough | Alaska | 2188 | 4109 | 11 |
2260249 | 2260249 | 2022-02-28 | Benton | Missouri | 29015 | 4109 | 90 |
2221256 | 2221256 | 2022-02-16 | Cooper | Missouri | 29053 | 4109 | 73 |
2211092 | 2211092 | 2022-02-13 | Union | Kentucky | 21225 | 4109 | 53 |
2207839 | 2207839 | 2022-02-12 | Union | Kentucky | 21225 | 4109 | 53 |
2204586 | 2204586 | 2022-02-11 | Union | Kentucky | 21225 | 4109 | 53 |
2199735 | 2199735 | 2022-02-09 | Lavaca | Texas | 48285 | 4109 | 107 |
2190268 | 2190268 | 2022-02-06 | Asotin | Washington | 53003 | 4109 | 56 |
2187015 | 2187015 | 2022-02-05 | Asotin | Washington | 53003 | 4109 | 56 |
2183762 | 2183762 | 2022-02-04 | Asotin | Washington | 53003 | 4109 | 56 |
2168324 | 2168324 | 2022-01-31 | Hancock | Illinois | 17067 | 4109 | 53 |
2161029 | 2161029 | 2022-01-28 | Barbour | West Virginia | 54001 | 4109 | 63 |
2141534 | 2141534 | 2022-01-22 | McDowell | West Virginia | 54047 | 4109 | 57 |
2129998 | 2129998 | 2022-01-19 | Hubbard | Minnesota | 27057 | 4109 | 52 |
2125559 | 2125559 | 2022-01-18 | Randolph | Arkansas | 5121 | 4109 | 69 |
2108698 | 2108698 | 2022-01-12 | Reeves | Texas | 48389 | 4109 | 64 |
2105845 | 2105845 | 2022-01-11 | Vilas | Wisconsin | 55125 | 4109 | 77 |
2096902 | 2096902 | 2022-01-09 | Spencer | Indiana | 18147 | 4109 | 58 |
2093650 | 2093650 | 2022-01-08 | Spencer | Indiana | 18147 | 4109 | 58 |
2090398 | 2090398 | 2022-01-07 | Spencer | Indiana | 18147 | 4109 | 58 |
2075957 | 2075957 | 2022-01-02 | Morgan | Tennessee | 47129 | 4109 | 57 |
2072706 | 2072706 | 2022-01-01 | Morgan | Tennessee | 47129 | 4109 | 57 |
2069455 | 2069455 | 2021-12-31 | Morgan | Tennessee | 47129 | 4109 | 57 |
2066204 | 2066204 | 2021-12-30 | Morgan | Tennessee | 47129 | 4109 | 57 |
2037517 | 2037517 | 2021-12-21 | Wyoming | West Virginia | 54109 | 4109 | 76 |
2031562 | 2031562 | 2021-12-20 | Franklin | Georgia | 13119 | 4109 | 85 |
2030902 | 2030902 | 2021-12-19 | Salem city | Virginia | 51775 | 4109 | 81 |
2027651 | 2027651 | 2021-12-18 | Salem city | Virginia | 51775 | 4109 | 81 |
2024400 | 2024400 | 2021-12-17 | Salem city | Virginia | 51775 | 4109 | 81 |
2021291 | 2021291 | 2021-12-16 | Jackson | Wisconsin | 55053 | 4109 | 36 |
2009044 | 2009044 | 2021-12-13 | Shelby | Illinois | 17173 | 4109 | 57 |
2003956 | 2003956 | 2021-12-11 | Holmes | Ohio | 39075 | 4109 | 143 |
1996666 | 1996666 | 2021-12-09 | Otsego | Michigan | 26137 | 4109 | 73 |
1928697 | 1928697 | 2021-11-18 | Stone | Missouri | 29209 | 4109 | 96 |
1919110 | 1919110 | 2021-11-15 | Churchill | Nevada | 32001 | 4109 | 74 |
1916328 | 1916328 | 2021-11-14 | Columbia | Oregon | 41009 | 4109 | 49 |
1913078 | 1913078 | 2021-11-13 | Columbia | Oregon | 41009 | 4109 | 49 |
1909828 | 1909828 | 2021-11-12 | Columbia | Oregon | 41009 | 4109 | 49 |
1906489 | 1906489 | 2021-11-11 | Van Wert | Ohio | 39161 | 4109 | 84 |
1883188 | 1883188 | 2021-11-04 | Saline | Missouri | 29195 | 4109 | 48 |
1859431 | 1859431 | 2021-10-28 | Elmore | Idaho | 16039 | 4109 | 44 |
1809602 | 1809602 | 2021-10-12 | Hockley | Texas | 48219 | 4109 | 130 |
1806352 | 1806352 | 2021-10-11 | Hockley | Texas | 48219 | 4109 | 129 |
1803102 | 1803102 | 2021-10-10 | Hockley | Texas | 48219 | 4109 | 129 |
1799853 | 1799853 | 2021-10-09 | Hockley | Texas | 48219 | 4109 | 129 |
1796604 | 1796604 | 2021-10-08 | Hockley | Texas | 48219 | 4109 | 128 |
1778718 | 1778718 | 2021-10-03 | Ohio | Kentucky | 21183 | 4109 | 74 |
1775468 | 1775468 | 2021-10-02 | Ohio | Kentucky | 21183 | 4109 | 74 |
1772218 | 1772218 | 2021-10-01 | Ohio | Kentucky | 21183 | 4109 | 74 |
1768961 | 1768961 | 2021-09-30 | Mercer | Kentucky | 21167 | 4109 | 67 |
1761964 | 1761964 | 2021-09-28 | Latah | Idaho | 16057 | 4109 | 24 |
1740119 | 1740119 | 2021-09-21 | Sunflower | Mississippi | 28133 | 4109 | 104 |
1731207 | 1731207 | 2021-09-18 | Snyder | Pennsylvania | 42109 | 4109 | 92 |
1695305 | 1695305 | 2021-09-07 | Williams | Ohio | 39171 | 4109 | 81 |
1683463 | 1683463 | 2021-09-04 | Pike | Alabama | 1109 | 4109 | 84 |
1629204 | 1629204 | 2021-08-18 | Calloway | Kentucky | 21035 | 4109 | 52 |
1623474 | 1623474 | 2021-08-16 | Cheshire | New Hampshire | 33005 | 4109 | 36 |
1609745 | 1609745 | 2021-08-12 | Greenup | Kentucky | 21089 | 4109 | 63 |
1564596 | 1564596 | 2021-07-29 | Nobles | Minnesota | 27105 | 4109 | 50 |
1560598 | 1560598 | 2021-07-28 | Fulton | Illinois | 17057 | 4109 | 67 |
1557635 | 1557635 | 2021-07-27 | Cowley | Kansas | 20035 | 4109 | 109 |
1554388 | 1554388 | 2021-07-26 | Cowley | Kansas | 20035 | 4109 | 109 |
1548836 | 1548836 | 2021-07-24 | Columbia | New York | 36021 | 4109 | 104 |
1530771 | 1530771 | 2021-07-19 | Escambia | Alabama | 1053 | 4109 | 82 |
1472025 | 1472025 | 2021-06-30 | Franklin | Virginia | 51067 | 4109 | 81 |
1430292 | 1430292 | 2021-06-18 | Union | Arkansas | 5139 | 4109 | 115 |
1422761 | 1422761 | 2021-06-15 | Ponce | Puerto Rico | 72113 | 4109 | |
1418293 | 1418293 | 2021-06-14 | St. Bernard | Louisiana | 22087 | 4109 | 54 |
1394472 | 1394472 | 2021-06-07 | Tallapoosa | Alabama | 1123 | 4109 | 155 |
1380185 | 1380185 | 2021-06-02 | Yadkin | North Carolina | 37197 | 4109 | 51 |
1311469 | 1311469 | 2021-05-12 | Monroe | Mississippi | 28095 | 4109 | 133 |
1312831 | 1312831 | 2021-05-12 | Rusk | Texas | 48401 | 4109 | 107 |
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);