ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
426 rows where cases = 884 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 40
- Iowa 36
- Virginia 27
- Texas 26
- Kentucky 25
- Puerto Rico 21
- Missouri 17
- South Dakota 15
- Colorado 14
- Washington 14
- Louisiana 12
- Mississippi 12
- West Virginia 12
- Illinois 11
- Kansas 10
- Arkansas 9
- Minnesota 9
- Indiana 8
- North Carolina 8
- Oklahoma 8
- Montana 7
- Nebraska 7
- Michigan 6
- New York 6
- Tennessee 6
- California 5
- Ohio 5
- South Carolina 5
- Vermont 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499866 | 2499866 | 2022-05-13 | Ouray | Colorado | 8091 | 884 | 6 |
2378509 | 2378509 | 2022-04-05 | Cochran | Texas | 48079 | 884 | 23 |
2375255 | 2375255 | 2022-04-04 | Cochran | Texas | 48079 | 884 | 23 |
2372003 | 2372003 | 2022-04-03 | Cochran | Texas | 48079 | 884 | 23 |
2368750 | 2368750 | 2022-04-02 | Cochran | Texas | 48079 | 884 | 23 |
2303960 | 2303960 | 2022-03-13 | Bath | Virginia | 51017 | 884 | 19 |
2300708 | 2300708 | 2022-03-12 | Bath | Virginia | 51017 | 884 | 19 |
2297456 | 2297456 | 2022-03-11 | Bath | Virginia | 51017 | 884 | 19 |
2294204 | 2294204 | 2022-03-10 | Bath | Virginia | 51017 | 884 | 19 |
2222462 | 2222462 | 2022-02-16 | Haskell | Texas | 48207 | 884 | 39 |
2219211 | 2219211 | 2022-02-15 | Haskell | Texas | 48207 | 884 | 38 |
2213347 | 2213347 | 2022-02-14 | Calhoun | Arkansas | 5013 | 884 | 9 |
2198612 | 2198612 | 2022-02-09 | Musselshell | Montana | 30065 | 884 | 26 |
2195358 | 2195358 | 2022-02-08 | Musselshell | Montana | 30065 | 884 | 26 |
2173975 | 2173975 | 2022-02-01 | Rappahannock | Virginia | 51157 | 884 | 7 |
2168250 | 2168250 | 2022-01-31 | Bear Lake | Idaho | 16007 | 884 | 15 |
2166922 | 2166922 | 2022-01-30 | Edmunds | South Dakota | 46045 | 884 | 16 |
2163667 | 2163667 | 2022-01-29 | Edmunds | South Dakota | 46045 | 884 | 16 |
2160412 | 2160412 | 2022-01-28 | Edmunds | South Dakota | 46045 | 884 | 16 |
2149343 | 2149343 | 2022-01-25 | Unknown | Louisiana | 884 | 0 | |
2141126 | 2141126 | 2022-01-22 | Hall | Texas | 48191 | 884 | 19 |
2125311 | 2125311 | 2022-01-17 | Florence | Wisconsin | 55037 | 884 | 15 |
2078387 | 2078387 | 2022-01-03 | Lander | Nevada | 32015 | 884 | 16 |
2079528 | 2079528 | 2022-01-03 | Essex | Vermont | 50009 | 884 | 3 |
2062056 | 2062056 | 2021-12-29 | Dixon | Nebraska | 31051 | 884 | 11 |
2058244 | 2058244 | 2021-12-28 | Cameron | Louisiana | 22023 | 884 | 8 |
2047509 | 2047509 | 2021-12-25 | Lafayette | Arkansas | 5073 | 884 | 28 |
2008177 | 2008177 | 2021-12-12 | Ferry | Washington | 53019 | 884 | 18 |
2004926 | 2004926 | 2021-12-11 | Ferry | Washington | 53019 | 884 | 18 |
2001675 | 2001675 | 2021-12-10 | Ferry | Washington | 53019 | 884 | 18 |
1973561 | 1973561 | 2021-12-02 | Mitchell | Kansas | 20123 | 884 | 17 |
1970311 | 1970311 | 2021-12-01 | Mitchell | Kansas | 20123 | 884 | 17 |
1967085 | 1967085 | 2021-11-30 | Scott | Kansas | 20171 | 884 | 31 |
1963833 | 1963833 | 2021-11-29 | Scott | Kansas | 20171 | 884 | 31 |
1956604 | 1956604 | 2021-11-27 | Clear Creek | Colorado | 8019 | 884 | 6 |
1953353 | 1953353 | 2021-11-26 | Clear Creek | Colorado | 8019 | 884 | 6 |
1950102 | 1950102 | 2021-11-25 | Clear Creek | Colorado | 8019 | 884 | 6 |
1945026 | 1945026 | 2021-11-23 | Burt | Nebraska | 31021 | 884 | 13 |
1925563 | 1925563 | 2021-11-17 | Kearney | Nebraska | 31099 | 884 | 6 |
1921356 | 1921356 | 2021-11-16 | Ohio | Indiana | 18115 | 884 | 13 |
1907580 | 1907580 | 2021-11-11 | Hot Springs | Wyoming | 56017 | 884 | 9 |
1904331 | 1904331 | 2021-11-10 | Hot Springs | Wyoming | 56017 | 884 | 9 |
1890773 | 1890773 | 2021-11-06 | Crane | Texas | 48103 | 884 | 18 |
1852595 | 1852595 | 2021-10-26 | Trinity | California | 6105 | 884 | 11 |
1850488 | 1850488 | 2021-10-25 | Norman | Minnesota | 27107 | 884 | 9 |
1846832 | 1846832 | 2021-10-24 | Republic | Kansas | 20157 | 884 | 15 |
1843582 | 1843582 | 2021-10-23 | Republic | Kansas | 20157 | 884 | 15 |
1840332 | 1840332 | 2021-10-22 | Republic | Kansas | 20157 | 884 | 15 |
1815891 | 1815891 | 2021-10-14 | Walworth | South Dakota | 46129 | 884 | 18 |
1789878 | 1789878 | 2021-10-06 | McCook | South Dakota | 46087 | 884 | 25 |
1785868 | 1785868 | 2021-10-05 | Richardson | Nebraska | 31147 | 884 | 24 |
1728468 | 1728468 | 2021-09-17 | San Saba | Texas | 48411 | 884 | 25 |
1725219 | 1725219 | 2021-09-16 | San Saba | Texas | 48411 | 884 | 25 |
1720799 | 1720799 | 2021-09-15 | Sanders | Montana | 30089 | 884 | 16 |
1715780 | 1715780 | 2021-09-13 | Pocahontas | West Virginia | 54075 | 884 | 15 |
1702467 | 1702467 | 2021-09-09 | Presidio | Texas | 48377 | 884 | 25 |
1693990 | 1693990 | 2021-09-07 | Greene | Iowa | 19073 | 884 | 11 |
1694277 | 1694277 | 2021-09-07 | Wolfe | Kentucky | 21237 | 884 | 8 |
1690741 | 1690741 | 2021-09-06 | Greene | Iowa | 19073 | 884 | 11 |
1687491 | 1687491 | 2021-09-05 | Greene | Iowa | 19073 | 884 | 11 |
1684241 | 1684241 | 2021-09-04 | Greene | Iowa | 19073 | 884 | 11 |
1686552 | 1686552 | 2021-09-04 | Roane | West Virginia | 54087 | 884 | 10 |
1680990 | 1680990 | 2021-09-03 | Greene | Iowa | 19073 | 884 | 11 |
1681718 | 1681718 | 2021-09-03 | Maries | Missouri | 29125 | 884 | 15 |
1677742 | 1677742 | 2021-09-02 | Greene | Iowa | 19073 | 884 | 11 |
1679506 | 1679506 | 2021-09-02 | Pickett | Tennessee | 47137 | 884 | 24 |
1674495 | 1674495 | 2021-09-01 | Greene | Iowa | 19073 | 884 | 11 |
1675026 | 1675026 | 2021-09-01 | Lake | Minnesota | 27075 | 884 | 21 |
1675181 | 1675181 | 2021-09-01 | Clark | Missouri | 29045 | 884 | 12 |
1676660 | 1676660 | 2021-09-01 | Lunenburg | Virginia | 51111 | 884 | 18 |
1670129 | 1670129 | 2021-08-30 | Essex | Virginia | 51057 | 884 | 11 |
1667000 | 1667000 | 2021-08-29 | Lincoln | Washington | 53043 | 884 | 12 |
1663752 | 1663752 | 2021-08-28 | Lincoln | Washington | 53043 | 884 | 12 |
1660504 | 1660504 | 2021-08-27 | Lincoln | Washington | 53043 | 884 | 12 |
1657321 | 1657321 | 2021-08-26 | Tyler | West Virginia | 54095 | 884 | 13 |
1648542 | 1648542 | 2021-08-24 | Monona | Iowa | 19133 | 884 | 32 |
1648551 | 1648551 | 2021-08-24 | Pocahontas | Iowa | 19151 | 884 | 22 |
1648719 | 1648719 | 2021-08-24 | Gallatin | Kentucky | 21077 | 884 | 34 |
1645294 | 1645294 | 2021-08-23 | Monona | Iowa | 19133 | 884 | 32 |
1645303 | 1645303 | 2021-08-23 | Pocahontas | Iowa | 19151 | 884 | 22 |
1641461 | 1641461 | 2021-08-22 | Lake | Colorado | 8065 | 884 | 1 |
1641867 | 1641867 | 2021-08-22 | Schuyler | Illinois | 17169 | 884 | 19 |
1642045 | 1642045 | 2021-08-22 | Monona | Iowa | 19133 | 884 | 32 |
1642054 | 1642054 | 2021-08-22 | Pocahontas | Iowa | 19151 | 884 | 22 |
1638211 | 1638211 | 2021-08-21 | Lake | Colorado | 8065 | 884 | 1 |
1638617 | 1638617 | 2021-08-21 | Schuyler | Illinois | 17169 | 884 | 19 |
1638795 | 1638795 | 2021-08-21 | Monona | Iowa | 19133 | 884 | 32 |
1638804 | 1638804 | 2021-08-21 | Pocahontas | Iowa | 19151 | 884 | 22 |
1634961 | 1634961 | 2021-08-20 | Lake | Colorado | 8065 | 884 | 1 |
1635367 | 1635367 | 2021-08-20 | Schuyler | Illinois | 17169 | 884 | 19 |
1635545 | 1635545 | 2021-08-20 | Monona | Iowa | 19133 | 884 | 32 |
1635554 | 1635554 | 2021-08-20 | Pocahontas | Iowa | 19151 | 884 | 22 |
1632295 | 1632295 | 2021-08-19 | Monona | Iowa | 19133 | 884 | 32 |
1632304 | 1632304 | 2021-08-19 | Pocahontas | Iowa | 19151 | 884 | 22 |
1629048 | 1629048 | 2021-08-18 | Monona | Iowa | 19133 | 884 | 32 |
1629057 | 1629057 | 2021-08-18 | Pocahontas | Iowa | 19151 | 884 | 22 |
1626455 | 1626455 | 2021-08-17 | Chariton | Missouri | 29041 | 884 | 8 |
1624331 | 1624331 | 2021-08-16 | Blanco | Texas | 48031 | 884 | 23 |
1624934 | 1624934 | 2021-08-16 | Sublette | Wyoming | 56035 | 884 | 9 |
1610123 | 1610123 | 2021-08-12 | Choctaw | Mississippi | 28019 | 884 | 19 |
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);