ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where cases = 4173 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- West Virginia 12
- Texas 9
- Georgia 6
- Mississippi 5
- Alabama 4
- Arkansas 4
- Colorado 4
- Illinois 4
- Michigan 4
- Ohio 4
- Tennessee 4
- Washington 4
- California 3
- Kentucky 3
- Minnesota 3
- Missouri 3
- New York 3
- North Carolina 3
- Pennsylvania 3
- Florida 2
- Indiana 2
- Oklahoma 2
- South Carolina 2
- Virginia 2
- Wisconsin 2
- Iowa 1
- Louisiana 1
- Maine 1
- Maryland 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449861 | 2449861 | 2022-04-27 | Quebradillas | Puerto Rico | 72115 | 4173 | |
2408273 | 2408273 | 2022-04-14 | Monroe | West Virginia | 54063 | 4173 | 46 |
2405017 | 2405017 | 2022-04-13 | Monroe | West Virginia | 54063 | 4173 | 46 |
2349681 | 2349681 | 2022-03-27 | Hardy | West Virginia | 54031 | 4173 | 49 |
2346428 | 2346428 | 2022-03-26 | Hardy | West Virginia | 54031 | 4173 | 49 |
2343175 | 2343175 | 2022-03-25 | Hardy | West Virginia | 54031 | 4173 | 49 |
2339922 | 2339922 | 2022-03-24 | Hardy | West Virginia | 54031 | 4173 | 49 |
2336685 | 2336685 | 2022-03-23 | Monroe | West Virginia | 54063 | 4173 | 43 |
2333431 | 2333431 | 2022-03-22 | Monroe | West Virginia | 54063 | 4173 | 42 |
2330177 | 2330177 | 2022-03-21 | Monroe | West Virginia | 54063 | 4173 | 42 |
2326925 | 2326925 | 2022-03-20 | Monroe | West Virginia | 54063 | 4173 | 42 |
2323672 | 2323672 | 2022-03-19 | Monroe | West Virginia | 54063 | 4173 | 42 |
2320418 | 2320418 | 2022-03-18 | Monroe | West Virginia | 54063 | 4173 | 42 |
2294035 | 2294035 | 2022-03-10 | Lavaca | Texas | 48285 | 4173 | 115 |
2246030 | 2246030 | 2022-02-24 | Otero | Colorado | 8089 | 4173 | 125 |
2178147 | 2178147 | 2022-02-03 | White | Illinois | 17193 | 4173 | 49 |
2174894 | 2174894 | 2022-02-02 | White | Illinois | 17193 | 4173 | 49 |
2156430 | 2156430 | 2022-01-27 | Washington | Nebraska | 31177 | 4173 | 31 |
2144374 | 2144374 | 2022-01-23 | Gonzales | Texas | 48177 | 4173 | 92 |
2137969 | 2137969 | 2022-01-21 | Reeves | Texas | 48389 | 4173 | 64 |
2110610 | 2110610 | 2022-01-13 | Stone | Mississippi | 28131 | 4173 | 67 |
2106880 | 2106880 | 2022-01-12 | Adair | Kentucky | 21001 | 4173 | 91 |
2079611 | 2079611 | 2022-01-03 | Lee | Virginia | 51105 | 4173 | 67 |
2079862 | 2079862 | 2022-01-03 | Uinta | Wyoming | 56041 | 4173 | 31 |
2055234 | 2055234 | 2021-12-27 | Martin | Minnesota | 27091 | 4173 | 51 |
2041150 | 2041150 | 2021-12-23 | Montezuma | Colorado | 8083 | 4173 | 51 |
2044043 | 2044043 | 2021-12-23 | Jackson | Wisconsin | 55053 | 4173 | 37 |
2030609 | 2030609 | 2021-12-19 | Jasper | Texas | 48241 | 4173 | 165 |
1926791 | 1926791 | 2021-11-17 | Carroll | Virginia | 51035 | 4173 | 101 |
1876312 | 1876312 | 2021-11-02 | Dorchester | Maryland | 24019 | 4173 | 82 |
1869093 | 1869093 | 2021-10-31 | Monroe | Georgia | 13207 | 4173 | 147 |
1865844 | 1865844 | 2021-10-30 | Monroe | Georgia | 13207 | 4173 | 147 |
1862595 | 1862595 | 2021-10-29 | Monroe | Georgia | 13207 | 4173 | 147 |
1838656 | 1838656 | 2021-10-21 | DeKalb | Tennessee | 47041 | 4173 | 70 |
1819348 | 1819348 | 2021-10-15 | Hockley | Texas | 48219 | 4173 | 130 |
1777664 | 1777664 | 2021-10-03 | Lawrence | Alabama | 1079 | 4173 | 109 |
1780690 | 1780690 | 2021-10-03 | Clallam | Washington | 53009 | 4173 | 48 |
1777440 | 1777440 | 2021-10-02 | Clallam | Washington | 53009 | 4173 | 48 |
1774190 | 1774190 | 2021-10-01 | Clallam | Washington | 53009 | 4173 | 48 |
1765402 | 1765402 | 2021-09-29 | Scott | Indiana | 18143 | 4173 | 67 |
1724977 | 1724977 | 2021-09-16 | McNairy | Tennessee | 47109 | 4173 | 61 |
1718970 | 1718970 | 2021-09-14 | Kittitas | Washington | 53037 | 4173 | 41 |
1696813 | 1696813 | 2021-09-08 | Butts | Georgia | 13035 | 4173 | 92 |
1670949 | 1670949 | 2021-08-31 | Unknown | Georgia | 4173 | 7 | |
1667450 | 1667450 | 2021-08-30 | Logan | Colorado | 8075 | 4173 | 69 |
1651107 | 1651107 | 2021-08-25 | St. Francis | Arkansas | 5123 | 4173 | 51 |
1646560 | 1646560 | 2021-08-23 | Preble | Ohio | 39135 | 4173 | 108 |
1588036 | 1588036 | 2021-08-05 | Crawford | Ohio | 39033 | 4173 | 112 |
1588675 | 1588675 | 2021-08-05 | Grimes | Texas | 48185 | 4173 | 74 |
1540599 | 1540599 | 2021-07-22 | Baxter | Arkansas | 5005 | 4173 | 112 |
1523330 | 1523330 | 2021-07-16 | Wayne | Pennsylvania | 42127 | 4173 | 84 |
1517934 | 1517934 | 2021-07-15 | Union | Arkansas | 5139 | 4173 | 116 |
1495091 | 1495091 | 2021-07-08 | Tallapoosa | Alabama | 1123 | 4173 | 156 |
1491844 | 1491844 | 2021-07-07 | Tallapoosa | Alabama | 1123 | 4173 | 156 |
1491897 | 1491897 | 2021-07-07 | Boone | Arkansas | 5009 | 4173 | 80 |
1486775 | 1486775 | 2021-07-05 | Union | Mississippi | 28145 | 4173 | 78 |
1483529 | 1483529 | 2021-07-04 | Union | Mississippi | 28145 | 4173 | 78 |
1480283 | 1480283 | 2021-07-03 | Union | Mississippi | 28145 | 4173 | 78 |
1477036 | 1477036 | 2021-07-02 | Union | Mississippi | 28145 | 4173 | 78 |
1470837 | 1470837 | 2021-06-30 | Belknap | New Hampshire | 33001 | 4173 | 100 |
1448274 | 1448274 | 2021-06-23 | Davie | North Carolina | 37059 | 4173 | 40 |
1391406 | 1391406 | 2021-06-06 | Tuolumne | California | 6109 | 4173 | 69 |
1388161 | 1388161 | 2021-06-05 | Tuolumne | California | 6109 | 4173 | 69 |
1384916 | 1384916 | 2021-06-04 | Tuolumne | California | 6109 | 4173 | 69 |
1335353 | 1335353 | 2021-05-19 | Weakley | Tennessee | 47183 | 4173 | 67 |
1320400 | 1320400 | 2021-05-15 | Lee | Illinois | 17103 | 4173 | 91 |
1322607 | 1322607 | 2021-05-15 | Waller | Texas | 48473 | 4173 | 46 |
1308116 | 1308116 | 2021-05-11 | Isanti | Minnesota | 27059 | 4173 | 64 |
1308135 | 1308135 | 2021-05-11 | Morrison | Minnesota | 27097 | 4173 | 60 |
1285544 | 1285544 | 2021-05-04 | Butler | Missouri | 29023 | 4173 | 42 |
1256677 | 1256677 | 2021-04-25 | Fulton | New York | 36035 | 4173 | 90 |
1224289 | 1224289 | 2021-04-15 | Haywood | North Carolina | 37087 | 4173 | 92 |
1201114 | 1201114 | 2021-04-08 | Butler | Missouri | 29023 | 4173 | 40 |
1198228 | 1198228 | 2021-04-07 | Madison | New York | 36053 | 4173 | 85 |
1170628 | 1170628 | 2021-03-30 | Broomfield | Colorado | 8014 | 4173 | 74 |
1151696 | 1151696 | 2021-03-24 | Buena Vista | Iowa | 19021 | 4173 | 39 |
1057277 | 1057277 | 2021-02-23 | Thomas | Georgia | 13275 | 4173 | 112 |
1051529 | 1051529 | 2021-02-21 | Grand Traverse | Michigan | 26055 | 4173 | 68 |
1048282 | 1048282 | 2021-02-20 | Grand Traverse | Michigan | 26055 | 4173 | 68 |
1045036 | 1045036 | 2021-02-19 | Grand Traverse | Michigan | 26055 | 4173 | 68 |
1017288 | 1017288 | 2021-02-10 | Hill | Texas | 48217 | 4173 | 77 |
979509 | 979509 | 2021-01-30 | Marion | Illinois | 17121 | 4173 | 113 |
980718 | 980718 | 2021-01-30 | Herkimer | New York | 36043 | 4173 | 89 |
945288 | 945288 | 2021-01-19 | Seneca | Ohio | 39147 | 4173 | 57 |
931778 | 931778 | 2021-01-15 | Taney | Missouri | 29213 | 4173 | 60 |
903139 | 903139 | 2021-01-06 | Grady | Oklahoma | 40051 | 4173 | 39 |
890150 | 890150 | 2021-01-02 | Creek | Oklahoma | 40037 | 4173 | 66 |
869591 | 869591 | 2020-12-27 | McCracken | Kentucky | 21145 | 4173 | 40 |
849059 | 849059 | 2020-12-21 | Colbert | Alabama | 1033 | 4173 | 56 |
827616 | 827616 | 2020-12-14 | Marquette | Michigan | 26103 | 4173 | 45 |
828877 | 828877 | 2020-12-14 | Greene | Tennessee | 47059 | 4173 | 80 |
805746 | 805746 | 2020-12-07 | Wayne | Ohio | 39169 | 4173 | 116 |
801545 | 801545 | 2020-12-06 | Cumberland | Maine | 23005 | 4173 | 71 |
732154 | 732154 | 2020-11-14 | Ozaukee | Wisconsin | 55089 | 4173 | 32 |
710240 | 710240 | 2020-11-08 | Johnson | Indiana | 18081 | 4173 | 163 |
575713 | 575713 | 2020-09-27 | Dorchester | South Carolina | 45035 | 4173 | 91 |
542869 | 542869 | 2020-09-17 | Robeson | North Carolina | 37155 | 4173 | 71 |
512944 | 512944 | 2020-09-08 | Tangipahoa | Louisiana | 22105 | 4173 | 107 |
510840 | 510840 | 2020-09-07 | Northampton | Pennsylvania | 42095 | 4173 | 301 |
478630 | 478630 | 2020-08-28 | Florence | South Carolina | 45041 | 4173 | 150 |
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);