ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 4476 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 8
- Louisiana 8
- Virginia 7
- Illinois 6
- Kentucky 5
- Utah 5
- Georgia 4
- Indiana 4
- Pennsylvania 4
- Texas 4
- Wisconsin 4
- Kansas 3
- Mississippi 3
- Missouri 3
- Puerto Rico 3
- California 2
- Colorado 2
- Michigan 2
- Minnesota 2
- New Mexico 2
- Ohio 2
- Oklahoma 2
- South Dakota 2
- Arkansas 1
- Idaho 1
- Maine 1
- Nebraska 1
- New Jersey 1
- New York 1
- North Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487172 | 2487172 | 2022-05-09 | Ford | Illinois | 17053 | 4476 | 75 |
2455180 | 2455180 | 2022-04-29 | Washington | Maine | 23029 | 4476 | 55 |
2445605 | 2445605 | 2022-04-26 | Roseau | Minnesota | 27135 | 4476 | 44 |
2274438 | 2274438 | 2022-03-04 | Deaf Smith | Texas | 48117 | 4476 | 109 |
2270859 | 2270859 | 2022-03-03 | Fajardo | Puerto Rico | 72053 | 4476 | |
2222944 | 2222944 | 2022-02-16 | Sawyer | Wisconsin | 55113 | 4476 | 57 |
2201478 | 2201478 | 2022-02-10 | Cheboygan | Michigan | 26031 | 4476 | 93 |
2197538 | 2197538 | 2022-02-09 | Cassia | Idaho | 16031 | 4476 | 52 |
2198224 | 2198224 | 2022-02-09 | Cheboygan | Michigan | 26031 | 4476 | 93 |
2193741 | 2193741 | 2022-02-08 | Hale | Alabama | 1065 | 4476 | 95 |
2186746 | 2186746 | 2022-02-05 | Montague | Texas | 48337 | 4476 | 114 |
2178969 | 2178969 | 2022-02-03 | Clinton | Missouri | 29049 | 4476 | 108 |
2174461 | 2174461 | 2022-02-02 | Elbert | Colorado | 8039 | 4476 | 33 |
2142339 | 2142339 | 2022-01-23 | Richland | Illinois | 17159 | 4476 | 78 |
2139084 | 2139084 | 2022-01-22 | Richland | Illinois | 17159 | 4476 | 78 |
2135828 | 2135828 | 2022-01-21 | Richland | Illinois | 17159 | 4476 | 78 |
2128290 | 2128290 | 2022-01-18 | Sevier | Utah | 49041 | 4476 | 20 |
2125038 | 2125038 | 2022-01-17 | Sevier | Utah | 49041 | 4476 | 20 |
2125356 | 2125356 | 2022-01-17 | Vilas | Wisconsin | 55125 | 4476 | 79 |
2121786 | 2121786 | 2022-01-16 | Sevier | Utah | 49041 | 4476 | 20 |
2118534 | 2118534 | 2022-01-15 | Sevier | Utah | 49041 | 4476 | 20 |
2115282 | 2115282 | 2022-01-14 | Sevier | Utah | 49041 | 4476 | 20 |
2097285 | 2097285 | 2022-01-09 | Pointe Coupee | Louisiana | 22077 | 4476 | 85 |
2094033 | 2094033 | 2022-01-08 | Pointe Coupee | Louisiana | 22077 | 4476 | 85 |
2090781 | 2090781 | 2022-01-07 | Pointe Coupee | Louisiana | 22077 | 4476 | 85 |
2061970 | 2061970 | 2021-12-29 | Washington | Missouri | 29221 | 4476 | 102 |
2058274 | 2058274 | 2021-12-28 | Richland | Louisiana | 22083 | 4476 | 80 |
2039178 | 2039178 | 2021-12-22 | Miller | Missouri | 29131 | 4476 | 101 |
2014556 | 2014556 | 2021-12-14 | Caroline | Virginia | 51033 | 4476 | 56 |
1988631 | 1988631 | 2021-12-06 | Pulaski | Virginia | 51155 | 4476 | 97 |
1971024 | 1971024 | 2021-12-01 | Adams | Nebraska | 31001 | 4476 | 55 |
1924936 | 1924936 | 2021-11-17 | Ohio | Kentucky | 21183 | 4476 | 84 |
1881794 | 1881794 | 2021-11-04 | Glenn | California | 6021 | 4476 | 46 |
1878088 | 1878088 | 2021-11-02 | Isle of Wight | Virginia | 51093 | 4476 | 89 |
1846997 | 1846997 | 2021-10-24 | East Feliciana | Louisiana | 22037 | 4476 | 144 |
1843747 | 1843747 | 2021-10-23 | East Feliciana | Louisiana | 22037 | 4476 | 144 |
1840497 | 1840497 | 2021-10-22 | East Feliciana | Louisiana | 22037 | 4476 | 144 |
1823178 | 1823178 | 2021-10-17 | Winston | Alabama | 1133 | 4476 | 101 |
1809162 | 1809162 | 2021-10-12 | Greene | Pennsylvania | 42059 | 4476 | 50 |
1790905 | 1790905 | 2021-10-07 | Logan | Colorado | 8075 | 4476 | 79 |
1791340 | 1791340 | 2021-10-07 | Daviess | Indiana | 18027 | 4476 | 113 |
1767678 | 1767678 | 2021-09-29 | Warren | Virginia | 51187 | 4476 | 71 |
1756338 | 1756338 | 2021-09-26 | Leflore | Mississippi | 28083 | 4476 | 140 |
1753090 | 1753090 | 2021-09-25 | Leflore | Mississippi | 28083 | 4476 | 140 |
1749842 | 1749842 | 2021-09-24 | Leflore | Mississippi | 28083 | 4476 | 140 |
1750723 | 1750723 | 2021-09-24 | Arecibo | Puerto Rico | 72013 | 4476 | |
1721370 | 1721370 | 2021-09-15 | Benton | Oregon | 41003 | 4476 | 24 |
1680154 | 1680154 | 2021-09-02 | Teton | Wyoming | 56039 | 4476 | 11 |
1649758 | 1649758 | 2021-08-24 | Crawford | Ohio | 39033 | 4476 | 112 |
1642096 | 1642096 | 2021-08-22 | Cowley | Kansas | 20035 | 4476 | 115 |
1643312 | 1643312 | 2021-08-22 | Putnam | Ohio | 39137 | 4476 | 105 |
1638846 | 1638846 | 2021-08-21 | Cowley | Kansas | 20035 | 4476 | 115 |
1635596 | 1635596 | 2021-08-20 | Cowley | Kansas | 20035 | 4476 | 115 |
1628684 | 1628684 | 2021-08-18 | Oconee | Georgia | 13219 | 4476 | 74 |
1577565 | 1577565 | 2021-08-02 | Isanti | Minnesota | 27059 | 4476 | 67 |
1531478 | 1531478 | 2021-07-19 | Harrison | Indiana | 18061 | 4476 | 77 |
1526998 | 1526998 | 2021-07-17 | Jim Wells | Texas | 48249 | 4476 | 108 |
1519660 | 1519660 | 2021-07-15 | Alexander | North Carolina | 37003 | 4476 | 84 |
1491938 | 1491938 | 2021-07-07 | Miller | Arkansas | 5091 | 4476 | 37 |
1492498 | 1492498 | 2021-07-07 | Clinton | Indiana | 18023 | 4476 | 60 |
1463748 | 1463748 | 2021-06-28 | Washington | Louisiana | 22117 | 4476 | 134 |
1449598 | 1449598 | 2021-06-24 | Chilton | Alabama | 1021 | 4476 | 116 |
1446353 | 1446353 | 2021-06-23 | Chilton | Alabama | 1021 | 4476 | 116 |
1436616 | 1436616 | 2021-06-20 | Chilton | Alabama | 1021 | 4476 | 116 |
1433369 | 1433369 | 2021-06-19 | Chilton | Alabama | 1021 | 4476 | 116 |
1430123 | 1430123 | 2021-06-18 | Chilton | Alabama | 1021 | 4476 | 116 |
1387631 | 1387631 | 2021-06-04 | Danville city | Virginia | 51590 | 4476 | 141 |
1375943 | 1375943 | 2021-06-01 | Barren | Kentucky | 21009 | 4476 | 98 |
1333392 | 1333392 | 2021-05-19 | Marion | Illinois | 17121 | 4476 | 121 |
1293398 | 1293398 | 2021-05-06 | Wilson | Texas | 48493 | 4476 | 68 |
1236389 | 1236389 | 2021-04-19 | Jessamine | Kentucky | 21113 | 4476 | 61 |
1233142 | 1233142 | 2021-04-18 | Jessamine | Kentucky | 21113 | 4476 | 61 |
1234560 | 1234560 | 2021-04-18 | Codington | South Dakota | 46029 | 4476 | 80 |
1231312 | 1231312 | 2021-04-17 | Codington | South Dakota | 46029 | 4476 | 80 |
1216286 | 1216286 | 2021-04-13 | Effingham | Georgia | 13103 | 4476 | 67 |
1160522 | 1160522 | 2021-03-26 | Putnam | West Virginia | 54079 | 4476 | 88 |
1151996 | 1151996 | 2021-03-24 | Scott | Kentucky | 21209 | 4476 | 31 |
1136950 | 1136950 | 2021-03-19 | Huntingdon | Pennsylvania | 42061 | 4476 | 126 |
1120825 | 1120825 | 2021-03-14 | Unknown | Puerto Rico | 4476 | 2077 | |
1111134 | 1111134 | 2021-03-11 | Newberry | South Carolina | 45071 | 4476 | 92 |
1097909 | 1097909 | 2021-03-07 | Pittsburg | Oklahoma | 40121 | 4476 | 39 |
1081527 | 1081527 | 2021-03-02 | Williams | North Dakota | 38105 | 4476 | 36 |
1071937 | 1071937 | 2021-02-27 | Osage | Oklahoma | 40113 | 4476 | 49 |
1047636 | 1047636 | 2021-02-20 | Effingham | Illinois | 17049 | 4476 | 80 |
1042387 | 1042387 | 2021-02-18 | Herkimer | New York | 36043 | 4476 | 104 |
952578 | 952578 | 2021-01-21 | Augusta | Virginia | 51015 | 4476 | 43 |
907969 | 907969 | 2021-01-08 | Rockdale | Georgia | 13247 | 4476 | 83 |
891986 | 891986 | 2021-01-03 | Morgan | Indiana | 18109 | 4476 | 84 |
871542 | 871542 | 2020-12-27 | Roanoke | Virginia | 51161 | 4476 | 63 |
832876 | 832876 | 2020-12-16 | Talladega | Alabama | 1121 | 4476 | 64 |
807301 | 807301 | 2020-12-08 | Glynn | Georgia | 13127 | 4476 | 127 |
783177 | 783177 | 2020-11-30 | Franklin | Pennsylvania | 42055 | 4476 | 110 |
784111 | 784111 | 2020-11-30 | Wood | Wisconsin | 55141 | 4476 | 32 |
777608 | 777608 | 2020-11-28 | St. Croix | Wisconsin | 55109 | 4476 | 20 |
764905 | 764905 | 2020-11-25 | Yolo | California | 6113 | 4476 | 74 |
737284 | 737284 | 2020-11-16 | San Juan | New Mexico | 35045 | 4476 | 210 |
646454 | 646454 | 2020-10-19 | McKinley | New Mexico | 35031 | 4476 | 261 |
572347 | 572347 | 2020-09-26 | Northampton | Pennsylvania | 42095 | 4476 | 305 |
186269 | 186269 | 2020-05-28 | Burlington | New Jersey | 34005 | 4476 | 277 |
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);