ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
150 rows where cases = 4005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 16
- Louisiana 11
- Georgia 9
- Michigan 9
- Texas 9
- Oklahoma 8
- South Dakota 8
- Kansas 7
- Minnesota 6
- Ohio 6
- Tennessee 6
- Alabama 4
- Arkansas 4
- Indiana 4
- Iowa 4
- Nebraska 4
- Illinois 3
- Mississippi 3
- New York 3
- North Carolina 3
- Virginia 3
- Wisconsin 3
- Wyoming 3
- Missouri 2
- Puerto Rico 2
- South Carolina 2
- Arizona 1
- Colorado 1
- Florida 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2438810 | 2438810 | 2022-04-24 | Trigg | Kentucky | 21221 | 4005 | 44 |
2435554 | 2435554 | 2022-04-23 | Trigg | Kentucky | 21221 | 4005 | 44 |
2432298 | 2432298 | 2022-04-22 | Trigg | Kentucky | 21221 | 4005 | 44 |
2429042 | 2429042 | 2022-04-21 | Trigg | Kentucky | 21221 | 4005 | 44 |
2425786 | 2425786 | 2022-04-20 | Trigg | Kentucky | 21221 | 4005 | 44 |
2422530 | 2422530 | 2022-04-19 | Trigg | Kentucky | 21221 | 4005 | 44 |
2423948 | 2423948 | 2022-04-19 | Union | South Dakota | 46127 | 4005 | 52 |
2419274 | 2419274 | 2022-04-18 | Trigg | Kentucky | 21221 | 4005 | 44 |
2420692 | 2420692 | 2022-04-18 | Union | South Dakota | 46127 | 4005 | 52 |
2417436 | 2417436 | 2022-04-17 | Union | South Dakota | 46127 | 4005 | 52 |
2414180 | 2414180 | 2022-04-16 | Union | South Dakota | 46127 | 4005 | 52 |
2410924 | 2410924 | 2022-04-15 | Union | South Dakota | 46127 | 4005 | 52 |
2407668 | 2407668 | 2022-04-14 | Union | South Dakota | 46127 | 4005 | 52 |
2404412 | 2404412 | 2022-04-13 | Union | South Dakota | 46127 | 4005 | 52 |
2370447 | 2370447 | 2022-04-03 | Trigg | Kentucky | 21221 | 4005 | 44 |
2367194 | 2367194 | 2022-04-02 | Trigg | Kentucky | 21221 | 4005 | 44 |
2363941 | 2363941 | 2022-04-01 | Trigg | Kentucky | 21221 | 4005 | 44 |
2360687 | 2360687 | 2022-03-31 | Trigg | Kentucky | 21221 | 4005 | 44 |
2357433 | 2357433 | 2022-03-30 | Trigg | Kentucky | 21221 | 4005 | 44 |
2354180 | 2354180 | 2022-03-29 | Trigg | Kentucky | 21221 | 4005 | 44 |
2350928 | 2350928 | 2022-03-28 | Trigg | Kentucky | 21221 | 4005 | 44 |
2313797 | 2313797 | 2022-03-16 | Nottoway | Virginia | 51135 | 4005 | 87 |
2261388 | 2261388 | 2022-02-28 | Bosque | Texas | 48035 | 4005 | 70 |
2258137 | 2258137 | 2022-02-27 | Bosque | Texas | 48035 | 4005 | 70 |
2254886 | 2254886 | 2022-02-26 | Bosque | Texas | 48035 | 4005 | 70 |
2213397 | 2213397 | 2022-02-14 | Polk | Arkansas | 5113 | 4005 | 133 |
2169603 | 2169603 | 2022-01-31 | Bertie | North Carolina | 37015 | 4005 | 59 |
2164833 | 2164833 | 2022-01-30 | Ben Hill | Georgia | 13017 | 4005 | 114 |
2161578 | 2161578 | 2022-01-29 | Ben Hill | Georgia | 13017 | 4005 | 114 |
2158322 | 2158322 | 2022-01-28 | Ben Hill | Georgia | 13017 | 4005 | 114 |
2131409 | 2131409 | 2022-01-19 | Lamb | Texas | 48279 | 4005 | 102 |
2108222 | 2108222 | 2022-01-12 | Cabo Rojo | Puerto Rico | 72023 | 4005 | |
2101774 | 2101774 | 2022-01-10 | San Lorenzo | Puerto Rico | 72129 | 4005 | |
2087453 | 2087453 | 2022-01-06 | Meade | Kentucky | 21163 | 4005 | 51 |
2033185 | 2033185 | 2021-12-20 | Carroll | Ohio | 39019 | 4005 | 84 |
2014605 | 2014605 | 2021-12-14 | Lee | Virginia | 51105 | 4005 | 62 |
1991297 | 1991297 | 2021-12-07 | Jasper | South Carolina | 45053 | 4005 | 82 |
1967350 | 1967350 | 2021-11-30 | Alpena | Michigan | 26007 | 4005 | 81 |
1964098 | 1964098 | 2021-11-29 | Alpena | Michigan | 26007 | 4005 | 81 |
1960896 | 1960896 | 2021-11-28 | Mason | Michigan | 26105 | 4005 | 56 |
1957645 | 1957645 | 2021-11-27 | Mason | Michigan | 26105 | 4005 | 56 |
1954394 | 1954394 | 2021-11-26 | Mason | Michigan | 26105 | 4005 | 56 |
1951143 | 1951143 | 2021-11-25 | Mason | Michigan | 26105 | 4005 | 56 |
1947892 | 1947892 | 2021-11-24 | Mason | Michigan | 26105 | 4005 | 56 |
1942003 | 1942003 | 2021-11-22 | Anson | North Carolina | 37007 | 4005 | 82 |
1938538 | 1938538 | 2021-11-21 | Dawson | Nebraska | 31047 | 4005 | 33 |
1940092 | 1940092 | 2021-11-21 | Uinta | Wyoming | 56041 | 4005 | 30 |
1935288 | 1935288 | 2021-11-20 | Dawson | Nebraska | 31047 | 4005 | 33 |
1936842 | 1936842 | 2021-11-20 | Uinta | Wyoming | 56041 | 4005 | 30 |
1932038 | 1932038 | 2021-11-19 | Dawson | Nebraska | 31047 | 4005 | 33 |
1933592 | 1933592 | 2021-11-19 | Uinta | Wyoming | 56041 | 4005 | 30 |
1922527 | 1922527 | 2021-11-16 | Dare | North Carolina | 37055 | 4005 | 14 |
1895755 | 1895755 | 2021-11-08 | Plaquemines | Louisiana | 22075 | 4005 | 40 |
1869778 | 1869778 | 2021-10-31 | Union | Louisiana | 22111 | 4005 | 105 |
1866529 | 1866529 | 2021-10-30 | Union | Louisiana | 22111 | 4005 | 105 |
1863280 | 1863280 | 2021-10-29 | Union | Louisiana | 22111 | 4005 | 105 |
1823613 | 1823613 | 2021-10-17 | Peach | Georgia | 13225 | 4005 | 94 |
1820364 | 1820364 | 2021-10-16 | Peach | Georgia | 13225 | 4005 | 94 |
1817115 | 1817115 | 2021-10-15 | Peach | Georgia | 13225 | 4005 | 94 |
1785509 | 1785509 | 2021-10-05 | Pine | Minnesota | 27115 | 4005 | 29 |
1782254 | 1782254 | 2021-10-04 | Nicollet | Minnesota | 27103 | 4005 | 49 |
1766531 | 1766531 | 2021-09-29 | Wyoming | New York | 36121 | 4005 | 54 |
1761522 | 1761522 | 2021-09-28 | Jackson | Arkansas | 5067 | 4005 | 42 |
1760181 | 1760181 | 2021-09-27 | Stutsman | North Dakota | 38093 | 4005 | 82 |
1760249 | 1760249 | 2021-09-27 | Morrow | Ohio | 39117 | 4005 | 51 |
1706044 | 1706044 | 2021-09-10 | Randolph | West Virginia | 54083 | 4005 | 25 |
1654362 | 1654362 | 2021-08-26 | Yell | Arkansas | 5149 | 4005 | 67 |
1652480 | 1652480 | 2021-08-25 | Lafayette | Missouri | 29107 | 4005 | 62 |
1642568 | 1642568 | 2021-08-22 | Polk | Minnesota | 27119 | 4005 | 74 |
1639318 | 1639318 | 2021-08-21 | Polk | Minnesota | 27119 | 4005 | 74 |
1636068 | 1636068 | 2021-08-20 | Polk | Minnesota | 27119 | 4005 | 74 |
1597562 | 1597562 | 2021-08-08 | Cortland | New York | 36023 | 4005 | 64 |
1541885 | 1541885 | 2021-07-22 | Steele | Minnesota | 27147 | 4005 | 19 |
1513417 | 1513417 | 2021-07-13 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1510171 | 1510171 | 2021-07-12 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1506924 | 1506924 | 2021-07-11 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1503678 | 1503678 | 2021-07-10 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1500432 | 1500432 | 2021-07-09 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1497186 | 1497186 | 2021-07-08 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1492538 | 1492538 | 2021-07-07 | Miami | Indiana | 18103 | 4005 | 71 |
1493939 | 1493939 | 2021-07-07 | Caddo | Oklahoma | 40015 | 4005 | 96 |
1489291 | 1489291 | 2021-07-06 | Miami | Indiana | 18103 | 4005 | 71 |
1466726 | 1466726 | 2021-06-29 | Cowley | Kansas | 20035 | 4005 | 108 |
1463481 | 1463481 | 2021-06-28 | Cowley | Kansas | 20035 | 4005 | 108 |
1450500 | 1450500 | 2021-06-24 | Cowley | Kansas | 20035 | 4005 | 108 |
1447255 | 1447255 | 2021-06-23 | Cowley | Kansas | 20035 | 4005 | 108 |
1445349 | 1445349 | 2021-06-22 | Polk | Oregon | 41053 | 4005 | 56 |
1405604 | 1405604 | 2021-06-10 | Lincoln | Mississippi | 28085 | 4005 | 111 |
1392078 | 1392078 | 2021-06-06 | Cowley | Kansas | 20035 | 4005 | 109 |
1388833 | 1388833 | 2021-06-05 | Cowley | Kansas | 20035 | 4005 | 109 |
1385588 | 1385588 | 2021-06-04 | Cowley | Kansas | 20035 | 4005 | 109 |
1365940 | 1365940 | 2021-05-29 | Huntington | Indiana | 18069 | 4005 | 82 |
1362366 | 1362366 | 2021-05-28 | Camden | Georgia | 13039 | 4005 | 37 |
1358992 | 1358992 | 2021-05-27 | Logan | Colorado | 8075 | 4005 | 68 |
1340023 | 1340023 | 2021-05-21 | Whitley | Indiana | 18183 | 4005 | 39 |
1315580 | 1315580 | 2021-05-13 | Wayne | Pennsylvania | 42127 | 4005 | 80 |
1304385 | 1304385 | 2021-05-10 | Plymouth | Iowa | 19149 | 4005 | 80 |
1301138 | 1301138 | 2021-05-09 | Plymouth | Iowa | 19149 | 4005 | 80 |
1297891 | 1297891 | 2021-05-08 | Plymouth | Iowa | 19149 | 4005 | 80 |
1278580 | 1278580 | 2021-05-02 | Franklin | Kentucky | 21073 | 4005 | 46 |
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);