ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
137 rows where cases = 3960 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 15
- Louisiana 13
- Tennessee 10
- Wisconsin 9
- Florida 8
- Illinois 8
- Virginia 7
- South Dakota 6
- Ohio 5
- Alabama 4
- Minnesota 4
- Montana 4
- North Carolina 4
- Texas 4
- California 3
- Georgia 3
- Missouri 3
- Wyoming 3
- Kansas 2
- Michigan 2
- Mississippi 2
- Pennsylvania 2
- South Carolina 2
- Arizona 1
- Colorado 1
- Delaware 1
- Iowa 1
- Kentucky 1
- Maryland 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471890 | 2471890 | 2022-05-04 | Glacier | Montana | 30035 | 3960 | 74 |
2444362 | 2444362 | 2022-04-26 | Madison | Arkansas | 5087 | 3960 | 61 |
2441106 | 2441106 | 2022-04-25 | Madison | Arkansas | 5087 | 3960 | 61 |
2437850 | 2437850 | 2022-04-24 | Madison | Arkansas | 5087 | 3960 | 61 |
2434594 | 2434594 | 2022-04-23 | Madison | Arkansas | 5087 | 3960 | 61 |
2431338 | 2431338 | 2022-04-22 | Madison | Arkansas | 5087 | 3960 | 61 |
2428082 | 2428082 | 2022-04-21 | Madison | Arkansas | 5087 | 3960 | 61 |
2424826 | 2424826 | 2022-04-20 | Madison | Arkansas | 5087 | 3960 | 61 |
2421570 | 2421570 | 2022-04-19 | Madison | Arkansas | 5087 | 3960 | 61 |
2418314 | 2418314 | 2022-04-18 | Madison | Arkansas | 5087 | 3960 | 61 |
2415058 | 2415058 | 2022-04-17 | Madison | Arkansas | 5087 | 3960 | 61 |
2411802 | 2411802 | 2022-04-16 | Madison | Arkansas | 5087 | 3960 | 61 |
2408546 | 2408546 | 2022-04-15 | Madison | Arkansas | 5087 | 3960 | 61 |
2405290 | 2405290 | 2022-04-14 | Madison | Arkansas | 5087 | 3960 | 61 |
2402035 | 2402035 | 2022-04-13 | Madison | Arkansas | 5087 | 3960 | 61 |
2356232 | 2356232 | 2022-03-29 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2352979 | 2352979 | 2022-03-28 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2349727 | 2349727 | 2022-03-27 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2346474 | 2346474 | 2022-03-26 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2343221 | 2343221 | 2022-03-25 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2339968 | 2339968 | 2022-03-24 | Burnett | Wisconsin | 55013 | 3960 | 43 |
2287323 | 2287323 | 2022-03-08 | Grundy | Tennessee | 47061 | 3960 | 69 |
2284071 | 2284071 | 2022-03-07 | Grundy | Tennessee | 47061 | 3960 | 69 |
2280819 | 2280819 | 2022-03-06 | Grundy | Tennessee | 47061 | 3960 | 69 |
2277566 | 2277566 | 2022-03-05 | Grundy | Tennessee | 47061 | 3960 | 69 |
2274313 | 2274313 | 2022-03-04 | Grundy | Tennessee | 47061 | 3960 | 69 |
2271060 | 2271060 | 2022-03-03 | Grundy | Tennessee | 47061 | 3960 | 69 |
2271517 | 2271517 | 2022-03-03 | Nottoway | Virginia | 51135 | 3960 | 83 |
2267808 | 2267808 | 2022-03-02 | Grundy | Tennessee | 47061 | 3960 | 69 |
2223319 | 2223319 | 2022-02-17 | Dixie | Florida | 12029 | 3960 | 52 |
2220068 | 2220068 | 2022-02-16 | Dixie | Florida | 12029 | 3960 | 52 |
2222376 | 2222376 | 2022-02-16 | Bosque | Texas | 48035 | 3960 | 65 |
2216817 | 2216817 | 2022-02-15 | Dixie | Florida | 12029 | 3960 | 52 |
2219008 | 2219008 | 2022-02-15 | Union | South Dakota | 46127 | 3960 | 49 |
2213566 | 2213566 | 2022-02-14 | Dixie | Florida | 12029 | 3960 | 52 |
2210314 | 2210314 | 2022-02-13 | Dixie | Florida | 12029 | 3960 | 52 |
2207061 | 2207061 | 2022-02-12 | Dixie | Florida | 12029 | 3960 | 52 |
2203808 | 2203808 | 2022-02-11 | Dixie | Florida | 12029 | 3960 | 52 |
2196007 | 2196007 | 2022-02-08 | Fulton | Pennsylvania | 42057 | 3960 | 60 |
2180389 | 2180389 | 2022-02-03 | Bristol city | Virginia | 51520 | 3960 | 63 |
2151609 | 2151609 | 2022-01-26 | Colusa | California | 6011 | 3960 | 21 |
2036273 | 2036273 | 2021-12-21 | Ashe | North Carolina | 37009 | 3960 | 58 |
2013094 | 2013094 | 2021-12-14 | Tishomingo | Mississippi | 28141 | 3960 | 94 |
1991447 | 1991447 | 2021-12-07 | Morgan | Tennessee | 47129 | 3960 | 51 |
1983939 | 1983939 | 2021-12-05 | Randolph | Missouri | 29175 | 3960 | 79 |
1974068 | 1974068 | 2021-12-02 | Newton | Mississippi | 28101 | 3960 | 82 |
1971928 | 1971928 | 2021-12-01 | Johnson | Tennessee | 47091 | 3960 | 53 |
1962128 | 1962128 | 2021-11-28 | Yankton | South Dakota | 46135 | 3960 | 41 |
1958877 | 1958877 | 2021-11-27 | Yankton | South Dakota | 46135 | 3960 | 41 |
1955626 | 1955626 | 2021-11-26 | Yankton | South Dakota | 46135 | 3960 | 41 |
1952375 | 1952375 | 2021-11-25 | Yankton | South Dakota | 46135 | 3960 | 41 |
1949124 | 1949124 | 2021-11-24 | Yankton | South Dakota | 46135 | 3960 | 41 |
1939822 | 1939822 | 2021-11-21 | Gloucester | Virginia | 51073 | 3960 | 79 |
1936572 | 1936572 | 2021-11-20 | Gloucester | Virginia | 51073 | 3960 | 79 |
1933322 | 1933322 | 2021-11-19 | Gloucester | Virginia | 51073 | 3960 | 79 |
1925836 | 1925836 | 2021-11-17 | Transylvania | North Carolina | 37175 | 3960 | 48 |
1926287 | 1926287 | 2021-11-17 | Jasper | South Carolina | 45053 | 3960 | 82 |
1915254 | 1915254 | 2021-11-14 | Pointe Coupee | Louisiana | 22077 | 3960 | 83 |
1912004 | 1912004 | 2021-11-13 | Pointe Coupee | Louisiana | 22077 | 3960 | 83 |
1908755 | 1908755 | 2021-11-12 | Pointe Coupee | Louisiana | 22077 | 3960 | 83 |
1878524 | 1878524 | 2021-11-03 | Sevier | Arkansas | 5133 | 3960 | 53 |
1852805 | 1852805 | 2021-10-26 | Franklin | Georgia | 13119 | 3960 | 82 |
1784057 | 1784057 | 2021-10-04 | Juneau | Wisconsin | 55057 | 3960 | 33 |
1706192 | 1706192 | 2021-09-11 | Lawrence | Alabama | 1079 | 3960 | 101 |
1671568 | 1671568 | 2021-08-31 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1668321 | 1668321 | 2021-08-30 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1665074 | 1665074 | 2021-08-29 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1661826 | 1661826 | 2021-08-28 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1658578 | 1658578 | 2021-08-27 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1642734 | 1642734 | 2021-08-22 | Lafayette | Missouri | 29107 | 3960 | 62 |
1598950 | 1598950 | 2021-08-08 | Teton | Wyoming | 56039 | 3960 | 11 |
1595701 | 1595701 | 2021-08-07 | Teton | Wyoming | 56039 | 3960 | 11 |
1592452 | 1592452 | 2021-08-06 | Teton | Wyoming | 56039 | 3960 | 11 |
1580384 | 1580384 | 2021-08-03 | Geary | Kansas | 20061 | 3960 | 45 |
1577135 | 1577135 | 2021-08-02 | Geary | Kansas | 20061 | 3960 | 45 |
1553083 | 1553083 | 2021-07-25 | Uvalde | Texas | 48463 | 3960 | 73 |
1486433 | 1486433 | 2021-07-05 | Iberville | Louisiana | 22047 | 3960 | 102 |
1483187 | 1483187 | 2021-07-04 | Iberville | Louisiana | 22047 | 3960 | 102 |
1479940 | 1479940 | 2021-07-03 | Iberville | Louisiana | 22047 | 3960 | 102 |
1476694 | 1476694 | 2021-07-02 | Iberville | Louisiana | 22047 | 3960 | 102 |
1468048 | 1468048 | 2021-06-29 | Douglas | Oregon | 41019 | 3960 | 83 |
1441430 | 1441430 | 2021-06-21 | Phelps | Missouri | 29161 | 3960 | 131 |
1417783 | 1417783 | 2021-06-14 | Logan | Illinois | 17107 | 3960 | 76 |
1414537 | 1414537 | 2021-06-13 | Logan | Illinois | 17107 | 3960 | 76 |
1411292 | 1411292 | 2021-06-12 | Logan | Illinois | 17107 | 3960 | 76 |
1408047 | 1408047 | 2021-06-11 | Logan | Illinois | 17107 | 3960 | 75 |
1395064 | 1395064 | 2021-06-07 | Logan | Illinois | 17107 | 3960 | 75 |
1391819 | 1391819 | 2021-06-06 | Logan | Illinois | 17107 | 3960 | 75 |
1373092 | 1373092 | 2021-05-31 | Steele | Minnesota | 27147 | 3960 | 15 |
1369847 | 1369847 | 2021-05-30 | Steele | Minnesota | 27147 | 3960 | 15 |
1315321 | 1315321 | 2021-05-13 | Brown | Ohio | 39015 | 3960 | 57 |
1289359 | 1289359 | 2021-05-05 | Crawford | Ohio | 39033 | 3960 | 106 |
1236704 | 1236704 | 2021-04-19 | McLeod | Minnesota | 27085 | 3960 | 55 |
1233460 | 1233460 | 2021-04-18 | Morrison | Minnesota | 27097 | 3960 | 59 |
1226086 | 1226086 | 2021-04-16 | Oconee | Georgia | 13219 | 3960 | 70 |
1224801 | 1224801 | 2021-04-15 | Williamsburg | South Carolina | 45089 | 3960 | 98 |
1225290 | 1225290 | 2021-04-15 | Charlottesville city | Virginia | 51540 | 3960 | 55 |
1179949 | 1179949 | 2021-04-01 | Lewis | Washington | 53041 | 3960 | 54 |
1175284 | 1175284 | 2021-03-31 | Silver Bow | Montana | 30093 | 3960 | 82 |
1172037 | 1172037 | 2021-03-30 | Silver Bow | Montana | 30093 | 3960 | 82 |
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);