ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
154 rows where cases = 3721 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- Kentucky 12
- Missouri 9
- Georgia 8
- Louisiana 8
- Virginia 8
- Alabama 7
- Florida 7
- Ohio 6
- Vermont 6
- Indiana 5
- Mississippi 5
- South Dakota 5
- Arkansas 4
- Kansas 4
- New York 4
- Tennessee 4
- Illinois 3
- Montana 3
- Virgin Islands 3
- Wisconsin 3
- Minnesota 2
- Oklahoma 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- West Virginia 2
- California 1
- Colorado 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484355 | 2484355 | 2022-05-08 | Leslie | Kentucky | 21131 | 3721 | 49 |
2481097 | 2481097 | 2022-05-07 | Leslie | Kentucky | 21131 | 3721 | 49 |
2477839 | 2477839 | 2022-05-06 | Leslie | Kentucky | 21131 | 3721 | 49 |
2474581 | 2474581 | 2022-05-05 | Leslie | Kentucky | 21131 | 3721 | 49 |
2471324 | 2471324 | 2022-05-04 | Leslie | Kentucky | 21131 | 3721 | 49 |
2467694 | 2467694 | 2022-05-03 | Wabash | Illinois | 17185 | 3721 | 31 |
2468068 | 2468068 | 2022-05-03 | Leslie | Kentucky | 21131 | 3721 | 49 |
2464813 | 2464813 | 2022-05-02 | Leslie | Kentucky | 21131 | 3721 | 49 |
2449728 | 2449728 | 2022-04-27 | Tillamook | Oregon | 41057 | 3721 | 64 |
2446992 | 2446992 | 2022-04-26 | Madison | Texas | 48313 | 3721 | 54 |
2443728 | 2443728 | 2022-04-25 | Leon | Texas | 48289 | 3721 | 93 |
2443737 | 2443737 | 2022-04-25 | Madison | Texas | 48313 | 3721 | 54 |
2440481 | 2440481 | 2022-04-24 | Madison | Texas | 48313 | 3721 | 54 |
2437225 | 2437225 | 2022-04-23 | Madison | Texas | 48313 | 3721 | 54 |
2314094 | 2314094 | 2022-03-17 | Washington | Alabama | 1129 | 3721 | 58 |
2310841 | 2310841 | 2022-03-16 | Washington | Alabama | 1129 | 3721 | 58 |
2312169 | 2312169 | 2022-03-16 | Renville | Minnesota | 27129 | 3721 | 56 |
2307588 | 2307588 | 2022-03-15 | Washington | Alabama | 1129 | 3721 | 58 |
2304337 | 2304337 | 2022-03-14 | Washington | Alabama | 1129 | 3721 | 58 |
2302580 | 2302580 | 2022-03-13 | Livingston | Missouri | 29117 | 3721 | 91 |
2299328 | 2299328 | 2022-03-12 | Livingston | Missouri | 29117 | 3721 | 91 |
2296076 | 2296076 | 2022-03-11 | Livingston | Missouri | 29117 | 3721 | 91 |
2281176 | 2281176 | 2022-03-06 | Lamoille | Vermont | 50015 | 3721 | 17 |
2277923 | 2277923 | 2022-03-05 | Lamoille | Vermont | 50015 | 3721 | 17 |
2274670 | 2274670 | 2022-03-04 | Lamoille | Vermont | 50015 | 3721 | 17 |
2214757 | 2214757 | 2022-02-14 | Dallas | Missouri | 29059 | 3721 | 67 |
2170602 | 2170602 | 2022-01-31 | Addison | Vermont | 50001 | 3721 | 13 |
2143293 | 2143293 | 2022-01-23 | Hill | Montana | 30041 | 3721 | 71 |
2140038 | 2140038 | 2022-01-22 | Hill | Montana | 30041 | 3721 | 71 |
2136782 | 2136782 | 2022-01-21 | Hill | Montana | 30041 | 3721 | 71 |
2125787 | 2125787 | 2022-01-18 | Ben Hill | Georgia | 13017 | 3721 | 113 |
2125050 | 2125050 | 2022-01-17 | Caledonia | Vermont | 50005 | 3721 | 22 |
2121798 | 2121798 | 2022-01-16 | Caledonia | Vermont | 50005 | 3721 | 22 |
2106981 | 2106981 | 2022-01-12 | Rockcastle | Kentucky | 21203 | 3721 | 48 |
2103544 | 2103544 | 2022-01-11 | Dickinson | Kansas | 20041 | 3721 | 63 |
2100293 | 2100293 | 2022-01-10 | Dickinson | Kansas | 20041 | 3721 | 63 |
2094998 | 2094998 | 2022-01-08 | Paulding | Ohio | 39125 | 3721 | 62 |
2087789 | 2087789 | 2022-01-06 | Attala | Mississippi | 28007 | 3721 | 90 |
2078983 | 2078983 | 2022-01-03 | Isabela | Puerto Rico | 72071 | 3721 | |
2075828 | 2075828 | 2022-01-02 | Beadle | South Dakota | 46005 | 3721 | 49 |
2072577 | 2072577 | 2022-01-01 | Beadle | South Dakota | 46005 | 3721 | 49 |
2069326 | 2069326 | 2021-12-31 | Beadle | South Dakota | 46005 | 3721 | 49 |
2066075 | 2066075 | 2021-12-30 | Beadle | South Dakota | 46005 | 3721 | 49 |
2066572 | 2066572 | 2021-12-30 | Dinwiddie | Virginia | 51053 | 3721 | 62 |
2031568 | 2031568 | 2021-12-20 | Grady | Georgia | 13131 | 3721 | 91 |
2033909 | 2033909 | 2021-12-20 | Moore | Texas | 48341 | 3721 | 92 |
2030635 | 2030635 | 2021-12-19 | Limestone | Texas | 48293 | 3721 | 111 |
2030790 | 2030790 | 2021-12-19 | St. Thomas | Virgin Islands | 78030 | 3721 | 46 |
2027384 | 2027384 | 2021-12-18 | Limestone | Texas | 48293 | 3721 | 111 |
2027539 | 2027539 | 2021-12-18 | St. Thomas | Virgin Islands | 78030 | 3721 | 46 |
2024288 | 2024288 | 2021-12-17 | St. Thomas | Virgin Islands | 78030 | 3721 | 46 |
1946748 | 1946748 | 2021-11-24 | Logan | Arkansas | 5083 | 3721 | 51 |
1943497 | 1943497 | 2021-11-23 | Logan | Arkansas | 5083 | 3721 | 51 |
1922092 | 1922092 | 2021-11-16 | Adair | Missouri | 29001 | 3721 | 35 |
1900971 | 1900971 | 2021-11-09 | Mason | West Virginia | 54053 | 3721 | 58 |
1869660 | 1869660 | 2021-10-31 | Johnson | Kentucky | 21115 | 3721 | 47 |
1866411 | 1866411 | 2021-10-30 | Johnson | Kentucky | 21115 | 3721 | 47 |
1863162 | 1863162 | 2021-10-29 | Johnson | Kentucky | 21115 | 3721 | 47 |
1859913 | 1859913 | 2021-10-28 | Johnson | Kentucky | 21115 | 3721 | 47 |
1854835 | 1854835 | 2021-10-26 | Davison | South Dakota | 46035 | 3721 | 70 |
1851897 | 1851897 | 2021-10-25 | Milam | Texas | 48331 | 3721 | 82 |
1848647 | 1848647 | 2021-10-24 | Milam | Texas | 48331 | 3721 | 82 |
1845397 | 1845397 | 2021-10-23 | Milam | Texas | 48331 | 3721 | 82 |
1840858 | 1840858 | 2021-10-22 | Audrain | Missouri | 29007 | 3721 | 64 |
1842147 | 1842147 | 2021-10-22 | Milam | Texas | 48331 | 3721 | 82 |
1833321 | 1833321 | 2021-10-20 | Harris | Georgia | 13145 | 3721 | 85 |
1807275 | 1807275 | 2021-10-12 | Burke | Georgia | 13033 | 3721 | 78 |
1768227 | 1768227 | 2021-09-30 | Holmes | Florida | 12059 | 3721 | 61 |
1764978 | 1764978 | 2021-09-29 | Holmes | Florida | 12059 | 3721 | 61 |
1761729 | 1761729 | 2021-09-28 | Holmes | Florida | 12059 | 3721 | 61 |
1758481 | 1758481 | 2021-09-27 | Holmes | Florida | 12059 | 3721 | 61 |
1755233 | 1755233 | 2021-09-26 | Holmes | Florida | 12059 | 3721 | 61 |
1751985 | 1751985 | 2021-09-25 | Holmes | Florida | 12059 | 3721 | 61 |
1748736 | 1748736 | 2021-09-24 | Holmes | Florida | 12059 | 3721 | 59 |
1745657 | 1745657 | 2021-09-23 | Tattnall | Georgia | 13267 | 3721 | 97 |
1720317 | 1720317 | 2021-09-15 | Union | Louisiana | 22111 | 3721 | 93 |
1702765 | 1702765 | 2021-09-09 | Greenbrier | West Virginia | 54025 | 3721 | 68 |
1689041 | 1689041 | 2021-09-05 | Mayaguez | Puerto Rico | 72097 | 3721 | |
1683475 | 1683475 | 2021-09-04 | Winston | Alabama | 1133 | 3721 | 79 |
1682024 | 1682024 | 2021-09-03 | Greene | New York | 36039 | 3721 | 82 |
1675193 | 1675193 | 2021-09-01 | Dunklin | Missouri | 29069 | 3721 | 55 |
1675510 | 1675510 | 2021-09-01 | Allegany | New York | 36003 | 3721 | 89 |
1667207 | 1667207 | 2021-08-30 | Lawrence | Alabama | 1079 | 3721 | 100 |
1652092 | 1652092 | 2021-08-25 | Sabine | Louisiana | 22085 | 3721 | 67 |
1620592 | 1620592 | 2021-08-15 | Williams | Ohio | 39171 | 3721 | 79 |
1605379 | 1605379 | 2021-08-10 | Green | Wisconsin | 55045 | 3721 | 26 |
1587414 | 1587414 | 2021-08-05 | Leflore | Mississippi | 28083 | 3721 | 125 |
1556500 | 1556500 | 2021-07-26 | Prince George | Virginia | 51149 | 3721 | 33 |
1552509 | 1552509 | 2021-07-25 | Clinton | Pennsylvania | 42035 | 3721 | 68 |
1549262 | 1549262 | 2021-07-24 | Clinton | Pennsylvania | 42035 | 3721 | 68 |
1535218 | 1535218 | 2021-07-20 | Worcester | Maryland | 24047 | 3721 | 106 |
1537154 | 1537154 | 2021-07-20 | Clark | Wisconsin | 55019 | 3721 | 65 |
1510550 | 1510550 | 2021-07-12 | Carroll | Tennessee | 47017 | 3721 | 83 |
1505908 | 1505908 | 2021-07-11 | Evangeline | Louisiana | 22039 | 3721 | 99 |
1502662 | 1502662 | 2021-07-10 | Evangeline | Louisiana | 22039 | 3721 | 99 |
1499416 | 1499416 | 2021-07-09 | Evangeline | Louisiana | 22039 | 3721 | 99 |
1420563 | 1420563 | 2021-06-15 | Amador | California | 6005 | 3721 | 47 |
1410439 | 1410439 | 2021-06-11 | Tazewell | Virginia | 51185 | 3721 | 74 |
1407194 | 1407194 | 2021-06-10 | Tazewell | Virginia | 51185 | 3721 | 74 |
1401672 | 1401672 | 2021-06-09 | Putnam | Indiana | 18133 | 3721 | 60 |
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);