ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
137 rows where cases = 4153 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 13
- Oklahoma 8
- West Virginia 8
- Louisiana 7
- Missouri 7
- Alabama 6
- Arkansas 6
- Virginia 6
- Illinois 5
- Minnesota 5
- Ohio 5
- Pennsylvania 5
- Wisconsin 5
- California 4
- Florida 4
- Kentucky 4
- New Mexico 4
- New York 4
- Connecticut 3
- Georgia 3
- Kansas 3
- Mississippi 3
- Oregon 3
- Puerto Rico 3
- Indiana 2
- North Carolina 2
- Washington 2
- Colorado 1
- Iowa 1
- Michigan 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501875 | 2501875 | 2022-05-13 | Fulton | Pennsylvania | 42057 | 4153 | 65 |
2502560 | 2502560 | 2022-05-13 | Goochland | Virginia | 51075 | 4153 | 53 |
2498617 | 2498617 | 2022-05-12 | Fulton | Pennsylvania | 42057 | 4153 | 65 |
2495359 | 2495359 | 2022-05-11 | Fulton | Pennsylvania | 42057 | 4153 | 65 |
2469634 | 2469634 | 2022-05-03 | Aransas | Texas | 48007 | 4153 | 85 |
2414003 | 2414003 | 2022-04-16 | Catano | Puerto Rico | 72033 | 4153 | |
2410747 | 2410747 | 2022-04-15 | Catano | Puerto Rico | 72033 | 4153 | |
2407491 | 2407491 | 2022-04-14 | Catano | Puerto Rico | 72033 | 4153 | |
2312968 | 2312968 | 2022-03-16 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2309715 | 2309715 | 2022-03-15 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2306462 | 2306462 | 2022-03-14 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2303211 | 2303211 | 2022-03-13 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2299959 | 2299959 | 2022-03-12 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2296707 | 2296707 | 2022-03-11 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2292914 | 2292914 | 2022-03-10 | Park | Montana | 30067 | 4153 | 34 |
2293455 | 2293455 | 2022-03-10 | Kingfisher | Oklahoma | 40073 | 4153 | 64 |
2271615 | 2271615 | 2022-03-03 | Hardy | West Virginia | 54031 | 4153 | 48 |
2235869 | 2235869 | 2022-02-20 | Morgan | West Virginia | 54065 | 4153 | 64 |
2232618 | 2232618 | 2022-02-19 | Morgan | West Virginia | 54065 | 4153 | 64 |
2229367 | 2229367 | 2022-02-18 | Morgan | West Virginia | 54065 | 4153 | 64 |
2203284 | 2203284 | 2022-02-10 | Asotin | Washington | 53003 | 4153 | 58 |
2200030 | 2200030 | 2022-02-09 | Asotin | Washington | 53003 | 4153 | 58 |
2194959 | 2194959 | 2022-02-08 | Antrim | Michigan | 26009 | 4153 | 55 |
2176430 | 2176430 | 2022-02-02 | Clatsop | Oregon | 41007 | 4153 | 38 |
2164611 | 2164611 | 2022-01-30 | Sharp | Arkansas | 5135 | 4153 | 85 |
2161356 | 2161356 | 2022-01-29 | Sharp | Arkansas | 5135 | 4153 | 85 |
2158100 | 2158100 | 2022-01-28 | Sharp | Arkansas | 5135 | 4153 | 85 |
2156020 | 2156020 | 2022-01-27 | Fillmore | Minnesota | 27045 | 4153 | 20 |
2132161 | 2132161 | 2022-01-20 | Elbert | Colorado | 8039 | 4153 | 32 |
2123965 | 2123965 | 2022-01-17 | Lincoln | New Mexico | 35027 | 4153 | 51 |
2120713 | 2120713 | 2022-01-16 | Lincoln | New Mexico | 35027 | 4153 | 51 |
2115796 | 2115796 | 2022-01-15 | Phillips | Arkansas | 5107 | 4153 | 84 |
2117461 | 2117461 | 2022-01-15 | Lincoln | New Mexico | 35027 | 4153 | 51 |
2114210 | 2114210 | 2022-01-14 | Lincoln | New Mexico | 35027 | 4153 | 51 |
2053766 | 2053766 | 2021-12-26 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2050516 | 2050516 | 2021-12-25 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2047266 | 2047266 | 2021-12-24 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2044016 | 2044016 | 2021-12-23 | Wyoming | West Virginia | 54109 | 4153 | 76 |
2009812 | 2009812 | 2021-12-13 | Leake | Mississippi | 28079 | 4153 | 92 |
2005282 | 2005282 | 2021-12-12 | Sevier | Arkansas | 5133 | 4153 | 61 |
2002031 | 2002031 | 2021-12-11 | Sevier | Arkansas | 5133 | 4153 | 61 |
1926077 | 1926077 | 2021-11-17 | Columbia | Oregon | 41009 | 4153 | 50 |
1912988 | 1912988 | 2021-11-13 | Van Wert | Ohio | 39161 | 4153 | 85 |
1852875 | 1852875 | 2021-10-26 | Sumter | Georgia | 13261 | 4153 | 131 |
1837483 | 1837483 | 2021-10-21 | Mille Lacs | Minnesota | 27095 | 4153 | 67 |
1838170 | 1838170 | 2021-10-21 | Adams | Ohio | 39001 | 4153 | 92 |
1821726 | 1821726 | 2021-10-16 | Franklin | New York | 36033 | 4153 | 20 |
1816099 | 1816099 | 2021-10-14 | Hockley | Texas | 48219 | 4153 | 130 |
1792525 | 1792525 | 2021-10-07 | Wyoming | New York | 36121 | 4153 | 55 |
1774378 | 1774378 | 2021-10-02 | Bibb | Alabama | 1007 | 4153 | 83 |
1755905 | 1755905 | 2021-09-26 | Carter | Kentucky | 21043 | 4153 | 50 |
1752657 | 1752657 | 2021-09-25 | Carter | Kentucky | 21043 | 4153 | 50 |
1749408 | 1749408 | 2021-09-24 | Carter | Kentucky | 21043 | 4153 | 50 |
1736530 | 1736530 | 2021-09-20 | Franklin | Louisiana | 22041 | 4153 | 133 |
1734239 | 1734239 | 2021-09-19 | Jackson | Ohio | 39079 | 4153 | 60 |
1713810 | 1713810 | 2021-09-13 | Sabine | Louisiana | 22085 | 4153 | 70 |
1681710 | 1681710 | 2021-09-03 | Lafayette | Missouri | 29107 | 4153 | 63 |
1679778 | 1679778 | 2021-09-02 | Willacy | Texas | 48489 | 4153 | 96 |
1648606 | 1648606 | 2021-08-24 | Geary | Kansas | 20061 | 4153 | 47 |
1645358 | 1645358 | 2021-08-23 | Geary | Kansas | 20061 | 4153 | 47 |
1585024 | 1585024 | 2021-08-04 | Pike | Pennsylvania | 42103 | 4153 | 54 |
1554270 | 1554270 | 2021-07-26 | Whitley | Indiana | 18183 | 4153 | 45 |
1553197 | 1553197 | 2021-07-25 | Franklin | Virginia | 51067 | 4153 | 83 |
1549950 | 1549950 | 2021-07-24 | Franklin | Virginia | 51067 | 4153 | 83 |
1546703 | 1546703 | 2021-07-23 | Franklin | Virginia | 51067 | 4153 | 83 |
1532998 | 1532998 | 2021-07-19 | Polk | Oregon | 41053 | 4153 | 56 |
1516509 | 1516509 | 2021-07-14 | Yadkin | North Carolina | 37197 | 4153 | 55 |
1486453 | 1486453 | 2021-07-05 | St. Bernard | Louisiana | 22087 | 4153 | 54 |
1483207 | 1483207 | 2021-07-04 | St. Bernard | Louisiana | 22087 | 4153 | 54 |
1479960 | 1479960 | 2021-07-03 | St. Bernard | Louisiana | 22087 | 4153 | 54 |
1476714 | 1476714 | 2021-07-02 | St. Bernard | Louisiana | 22087 | 4153 | 54 |
1472365 | 1472365 | 2021-07-01 | Tallapoosa | Alabama | 1123 | 4153 | 155 |
1469120 | 1469120 | 2021-06-30 | Tallapoosa | Alabama | 1123 | 4153 | 155 |
1405634 | 1405634 | 2021-06-10 | Union | Mississippi | 28145 | 4153 | 76 |
1401581 | 1401581 | 2021-06-09 | Randolph | Illinois | 17157 | 4153 | 93 |
1349180 | 1349180 | 2021-05-24 | Mendocino | California | 6045 | 4153 | 49 |
1345933 | 1345933 | 2021-05-23 | Mendocino | California | 6045 | 4153 | 49 |
1342685 | 1342685 | 2021-05-22 | Mendocino | California | 6045 | 4153 | 49 |
1339437 | 1339437 | 2021-05-21 | Mendocino | California | 6045 | 4153 | 49 |
1307413 | 1307413 | 2021-05-11 | Lee | Illinois | 17103 | 4153 | 91 |
1301624 | 1301624 | 2021-05-09 | Isanti | Minnesota | 27059 | 4153 | 64 |
1286696 | 1286696 | 2021-05-04 | Cherokee | Texas | 48073 | 4153 | 140 |
1282870 | 1282870 | 2021-05-03 | Defiance | Ohio | 39039 | 4153 | 97 |
1283450 | 1283450 | 2021-05-03 | Cherokee | Texas | 48073 | 4153 | 140 |
1278915 | 1278915 | 2021-05-02 | McLeod | Minnesota | 27085 | 4153 | 58 |
1280203 | 1280203 | 2021-05-02 | Cherokee | Texas | 48073 | 4153 | 140 |
1276956 | 1276956 | 2021-05-01 | Cherokee | Texas | 48073 | 4153 | 140 |
1273709 | 1273709 | 2021-04-30 | Cherokee | Texas | 48073 | 4153 | 139 |
1270462 | 1270462 | 2021-04-29 | Cherokee | Texas | 48073 | 4153 | 138 |
1267215 | 1267215 | 2021-04-28 | Cherokee | Texas | 48073 | 4153 | 138 |
1262816 | 1262816 | 2021-04-27 | Butler | Missouri | 29023 | 4153 | 42 |
1263968 | 1263968 | 2021-04-27 | Cherokee | Texas | 48073 | 4153 | 138 |
1259186 | 1259186 | 2021-04-26 | Avoyelles | Louisiana | 22009 | 4153 | 123 |
1259569 | 1259569 | 2021-04-26 | Butler | Missouri | 29023 | 4153 | 42 |
1260527 | 1260527 | 2021-04-26 | Brookings | South Dakota | 46011 | 4153 | 37 |
1256322 | 1256322 | 2021-04-25 | Butler | Missouri | 29023 | 4153 | 42 |
1253075 | 1253075 | 2021-04-24 | Butler | Missouri | 29023 | 4153 | 42 |
1241837 | 1241837 | 2021-04-21 | Chilton | Alabama | 1021 | 4153 | 110 |
1229477 | 1229477 | 2021-04-17 | Jefferson | Illinois | 17081 | 4153 | 120 |
1217794 | 1217794 | 2021-04-13 | Haywood | North Carolina | 37087 | 4153 | 92 |
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);