ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 4170 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- West Virginia 15
- Tennessee 11
- Georgia 9
- Oklahoma 8
- Indiana 6
- Virginia 6
- Michigan 5
- Montana 5
- Texas 5
- Illinois 4
- South Carolina 4
- Arkansas 3
- Minnesota 3
- Nebraska 3
- Pennsylvania 3
- Alabama 2
- California 2
- Colorado 2
- Idaho 2
- Kansas 2
- Louisiana 2
- Mississippi 2
- Missouri 2
- New Mexico 2
- Ohio 2
- Puerto Rico 2
- Arizona 1
- Florida 1
- Iowa 1
- Maine 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449658 | 2449658 | 2022-04-27 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2446401 | 2446401 | 2022-04-26 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2443146 | 2443146 | 2022-04-25 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2439890 | 2439890 | 2022-04-24 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2436634 | 2436634 | 2022-04-23 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2433378 | 2433378 | 2022-04-22 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2430122 | 2430122 | 2022-04-21 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2378975 | 2378975 | 2022-04-05 | Monroe | West Virginia | 54063 | 4170 | 46 |
2375721 | 2375721 | 2022-04-04 | Monroe | West Virginia | 54063 | 4170 | 46 |
2348212 | 2348212 | 2022-03-27 | Park | Montana | 30067 | 4170 | 35 |
2344959 | 2344959 | 2022-03-26 | Park | Montana | 30067 | 4170 | 35 |
2341706 | 2341706 | 2022-03-25 | Park | Montana | 30067 | 4170 | 35 |
2338453 | 2338453 | 2022-03-24 | Park | Montana | 30067 | 4170 | 35 |
2317148 | 2317148 | 2022-03-17 | Hardy | West Virginia | 54031 | 4170 | 49 |
2313895 | 2313895 | 2022-03-16 | Hardy | West Virginia | 54031 | 4170 | 49 |
2313911 | 2313911 | 2022-03-16 | Monroe | West Virginia | 54063 | 4170 | 42 |
2310064 | 2310064 | 2022-03-15 | Cannon | Tennessee | 47015 | 4170 | 56 |
2310642 | 2310642 | 2022-03-15 | Hardy | West Virginia | 54031 | 4170 | 49 |
2310658 | 2310658 | 2022-03-15 | Monroe | West Virginia | 54063 | 4170 | 42 |
2306811 | 2306811 | 2022-03-14 | Cannon | Tennessee | 47015 | 4170 | 56 |
2307389 | 2307389 | 2022-03-14 | Hardy | West Virginia | 54031 | 4170 | 49 |
2303560 | 2303560 | 2022-03-13 | Cannon | Tennessee | 47015 | 4170 | 56 |
2300308 | 2300308 | 2022-03-12 | Cannon | Tennessee | 47015 | 4170 | 56 |
2297056 | 2297056 | 2022-03-11 | Cannon | Tennessee | 47015 | 4170 | 56 |
2293804 | 2293804 | 2022-03-10 | Cannon | Tennessee | 47015 | 4170 | 56 |
2290552 | 2290552 | 2022-03-09 | Cannon | Tennessee | 47015 | 4170 | 56 |
2271268 | 2271268 | 2022-03-03 | Lavaca | Texas | 48285 | 4170 | 115 |
2239120 | 2239120 | 2022-02-21 | Morgan | West Virginia | 54065 | 4170 | 64 |
2222143 | 2222143 | 2022-02-16 | Yabucoa | Puerto Rico | 72151 | 4170 | |
2201467 | 2201467 | 2022-02-10 | Antrim | Michigan | 26009 | 4170 | 56 |
2172135 | 2172135 | 2022-02-01 | Knox | Maine | 23013 | 4170 | 22 |
2136669 | 2136669 | 2022-01-21 | Clinton | Missouri | 29049 | 4170 | 101 |
2130486 | 2130486 | 2022-01-19 | Taos | New Mexico | 35055 | 4170 | 75 |
2101707 | 2101707 | 2022-01-10 | Wyoming | Pennsylvania | 42131 | 4170 | 92 |
2034652 | 2034652 | 2021-12-21 | Morgan | Colorado | 8087 | 4170 | 123 |
2032568 | 2032568 | 2021-12-20 | Leake | Mississippi | 28079 | 4170 | 92 |
2030840 | 2030840 | 2021-12-19 | Gloucester | Virginia | 51073 | 4170 | 82 |
2030965 | 2030965 | 2021-12-19 | Boone | West Virginia | 54005 | 4170 | 62 |
2027589 | 2027589 | 2021-12-18 | Gloucester | Virginia | 51073 | 4170 | 82 |
2024338 | 2024338 | 2021-12-17 | Gloucester | Virginia | 51073 | 4170 | 82 |
2018285 | 2018285 | 2021-12-16 | Sevier | Arkansas | 5133 | 4170 | 61 |
2012554 | 2012554 | 2021-12-14 | Labette | Kansas | 20099 | 4170 | 65 |
2009303 | 2009303 | 2021-12-13 | Labette | Kansas | 20099 | 4170 | 65 |
1997048 | 1997048 | 2021-12-09 | Dawson | Nebraska | 31047 | 4170 | 36 |
1994584 | 1994584 | 2021-12-08 | Davison | South Dakota | 46035 | 4170 | 71 |
1975223 | 1975223 | 2021-12-02 | Wayne | Tennessee | 47181 | 4170 | 41 |
1962734 | 1962734 | 2021-11-28 | Nicholas | West Virginia | 54067 | 4170 | 61 |
1959483 | 1959483 | 2021-11-27 | Nicholas | West Virginia | 54067 | 4170 | 61 |
1956232 | 1956232 | 2021-11-26 | Nicholas | West Virginia | 54067 | 4170 | 61 |
1952981 | 1952981 | 2021-11-25 | Nicholas | West Virginia | 54067 | 4170 | 61 |
1949730 | 1949730 | 2021-11-24 | Nicholas | West Virginia | 54067 | 4170 | 61 |
1937346 | 1937346 | 2021-11-21 | Peach | Georgia | 13225 | 4170 | 108 |
1934096 | 1934096 | 2021-11-20 | Peach | Georgia | 13225 | 4170 | 108 |
1930844 | 1930844 | 2021-11-19 | Peach | Georgia | 13225 | 4170 | 108 |
1882192 | 1882192 | 2021-11-04 | Payette | Idaho | 16075 | 4170 | 65 |
1878925 | 1878925 | 2021-11-03 | Elmore | Idaho | 16039 | 4170 | 46 |
1814005 | 1814005 | 2021-10-14 | Iroquois | Illinois | 17075 | 4170 | 79 |
1814750 | 1814750 | 2021-10-14 | Pine | Minnesota | 27115 | 4170 | 30 |
1700984 | 1700984 | 2021-09-09 | Becker | Minnesota | 27005 | 4170 | 59 |
1682473 | 1682473 | 2021-09-03 | Perry | Pennsylvania | 42099 | 4170 | 102 |
1645571 | 1645571 | 2021-08-23 | East Feliciana | Louisiana | 22037 | 4170 | 128 |
1600809 | 1600809 | 2021-08-09 | Columbia | New York | 36021 | 4170 | 104 |
1596460 | 1596460 | 2021-08-08 | Miami | Indiana | 18103 | 4170 | 74 |
1593211 | 1593211 | 2021-08-07 | Miami | Indiana | 18103 | 4170 | 74 |
1589962 | 1589962 | 2021-08-06 | Miami | Indiana | 18103 | 4170 | 74 |
1573459 | 1573459 | 2021-08-01 | Oconee | Georgia | 13219 | 4170 | 74 |
1570211 | 1570211 | 2021-07-31 | Oconee | Georgia | 13219 | 4170 | 74 |
1566963 | 1566963 | 2021-07-30 | Oconee | Georgia | 13219 | 4170 | 74 |
1560172 | 1560172 | 2021-07-28 | Lake | California | 6033 | 4170 | 65 |
1552688 | 1552688 | 2021-07-25 | Williamsburg | South Carolina | 45089 | 4170 | 104 |
1549441 | 1549441 | 2021-07-24 | Williamsburg | South Carolina | 45089 | 4170 | 104 |
1546194 | 1546194 | 2021-07-23 | Williamsburg | South Carolina | 45089 | 4170 | 104 |
1514687 | 1514687 | 2021-07-14 | Union | Arkansas | 5139 | 4170 | 116 |
1512920 | 1512920 | 2021-07-13 | Silver Bow | Montana | 30093 | 4170 | 86 |
1513587 | 1513587 | 2021-07-13 | Wayne | Pennsylvania | 42127 | 4170 | 84 |
1473790 | 1473790 | 2021-07-01 | Union | Mississippi | 28145 | 4170 | 78 |
1466968 | 1466968 | 2021-06-29 | Natchitoches | Louisiana | 22069 | 4170 | 94 |
1467592 | 1467592 | 2021-06-29 | Belknap | New Hampshire | 33001 | 4170 | 100 |
1375179 | 1375179 | 2021-06-01 | Tuolumne | California | 6109 | 4170 | 67 |
1336000 | 1336000 | 2021-05-20 | Covington | Alabama | 1039 | 4170 | 119 |
1332267 | 1332267 | 2021-05-18 | Matagorda | Texas | 48321 | 4170 | 111 |
1304830 | 1304830 | 2021-05-10 | Sanilac | Michigan | 26151 | 4170 | 108 |
1304870 | 1304870 | 2021-05-10 | Isanti | Minnesota | 27059 | 4170 | 64 |
1288489 | 1288489 | 2021-05-05 | Calvert | Maryland | 24009 | 4170 | 78 |
1279051 | 1279051 | 2021-05-02 | Butler | Missouri | 29023 | 4170 | 42 |
1270497 | 1270497 | 2021-04-29 | Erath | Texas | 48143 | 4170 | 68 |
1252285 | 1252285 | 2021-04-24 | DeKalb | Indiana | 18033 | 4170 | 87 |
1248298 | 1248298 | 2021-04-22 | Albany | Wyoming | 56001 | 4170 | 11 |
1238411 | 1238411 | 2021-04-19 | Lewis | Washington | 53041 | 4170 | 59 |
1217574 | 1217574 | 2021-04-13 | Madison | Nebraska | 31119 | 4170 | 42 |
1214327 | 1214327 | 2021-04-12 | Madison | Nebraska | 31119 | 4170 | 42 |
1168379 | 1168379 | 2021-03-29 | Barry | Michigan | 26015 | 4170 | 50 |
1151624 | 1151624 | 2021-03-24 | Harrison | Indiana | 18061 | 4170 | 70 |
1135936 | 1135936 | 2021-03-19 | Isabella | Michigan | 26073 | 4170 | 74 |
1106066 | 1106066 | 2021-03-10 | Franklin | Illinois | 17055 | 4170 | 78 |
1102820 | 1102820 | 2021-03-09 | Franklin | Illinois | 17055 | 4170 | 78 |
1101524 | 1101524 | 2021-03-08 | Lincoln | Tennessee | 47103 | 4170 | 62 |
1069470 | 1069470 | 2021-02-26 | Henry | Virginia | 51089 | 4170 | 100 |
1063683 | 1063683 | 2021-02-25 | Effingham | Georgia | 13103 | 4170 | 60 |
1034426 | 1034426 | 2021-02-16 | Baldwin | Georgia | 13009 | 4170 | 104 |
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);