ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 3605 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Iowa 12
- Missouri 12
- Kentucky 11
- Oklahoma 9
- Indiana 8
- North Dakota 8
- Tennessee 7
- Colorado 6
- Georgia 6
- Ohio 6
- West Virginia 6
- Virginia 5
- Wisconsin 5
- Alabama 4
- Alaska 4
- Illinois 4
- Louisiana 4
- Michigan 4
- New York 3
- Oregon 3
- Pennsylvania 3
- Arkansas 2
- Idaho 2
- Minnesota 2
- Mississippi 2
- Nebraska 2
- New Jersey 2
- South Carolina 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500406 | 2500406 | 2022-05-13 | Floyd | Iowa | 19067 | 3605 | 62 |
2497148 | 2497148 | 2022-05-12 | Floyd | Iowa | 19067 | 3605 | 62 |
2493890 | 2493890 | 2022-05-11 | Floyd | Iowa | 19067 | 3605 | 62 |
2437977 | 2437977 | 2022-04-24 | Las Animas | Colorado | 8071 | 3605 | 40 |
2434721 | 2434721 | 2022-04-23 | Las Animas | Colorado | 8071 | 3605 | 40 |
2431465 | 2431465 | 2022-04-22 | Las Animas | Colorado | 8071 | 3605 | 40 |
2428209 | 2428209 | 2022-04-21 | Las Animas | Colorado | 8071 | 3605 | 40 |
2418792 | 2418792 | 2022-04-18 | Greene | Illinois | 17061 | 3605 | 58 |
2353833 | 2353833 | 2022-03-29 | Parke | Indiana | 18121 | 3605 | 49 |
2350581 | 2350581 | 2022-03-28 | Parke | Indiana | 18121 | 3605 | 49 |
2316073 | 2316073 | 2022-03-17 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2312820 | 2312820 | 2022-03-16 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2309567 | 2309567 | 2022-03-15 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2306314 | 2306314 | 2022-03-14 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2302581 | 2302581 | 2022-03-13 | Macon | Missouri | 29121 | 3605 | 52 |
2303063 | 2303063 | 2022-03-13 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2299329 | 2299329 | 2022-03-12 | Macon | Missouri | 29121 | 3605 | 52 |
2299811 | 2299811 | 2022-03-12 | Ramsey | North Dakota | 38071 | 3605 | 57 |
2296077 | 2296077 | 2022-03-11 | Macon | Missouri | 29121 | 3605 | 52 |
2293525 | 2293525 | 2022-03-10 | Tillamook | Oregon | 41057 | 3605 | 58 |
2288778 | 2288778 | 2022-03-09 | Parke | Indiana | 18121 | 3605 | 49 |
2290273 | 2290273 | 2022-03-09 | Tillamook | Oregon | 41057 | 3605 | 58 |
2285527 | 2285527 | 2022-03-08 | Parke | Indiana | 18121 | 3605 | 48 |
2287021 | 2287021 | 2022-03-08 | Tillamook | Oregon | 41057 | 3605 | 57 |
2266313 | 2266313 | 2022-03-02 | Leslie | Kentucky | 21131 | 3605 | 39 |
2267288 | 2267288 | 2022-03-02 | Ramsey | North Dakota | 38071 | 3605 | 55 |
2259324 | 2259324 | 2022-02-28 | Gem | Idaho | 16045 | 3605 | 77 |
2245820 | 2245820 | 2022-02-24 | Kusilvak Census Area | Alaska | 2158 | 3605 | 11 |
2242569 | 2242569 | 2022-02-23 | Kusilvak Census Area | Alaska | 2158 | 3605 | 11 |
2214293 | 2214293 | 2022-02-14 | Larue | Kentucky | 21123 | 3605 | 64 |
2214994 | 2214994 | 2022-02-14 | York | Nebraska | 31185 | 3605 | 19 |
2200296 | 2200296 | 2022-02-10 | Ketchikan Gateway Borough | Alaska | 2130 | 3605 | 16 |
2197042 | 2197042 | 2022-02-09 | Ketchikan Gateway Borough | Alaska | 2130 | 3605 | 16 |
2171604 | 2171604 | 2022-02-01 | Massac | Illinois | 17127 | 3605 | 67 |
2144540 | 2144540 | 2022-01-23 | Zavala | Texas | 48507 | 3605 | 56 |
2131091 | 2131091 | 2022-01-19 | Lee | South Carolina | 45061 | 3605 | 84 |
2102654 | 2102654 | 2022-01-11 | Fayette | Alabama | 1057 | 3605 | 86 |
2104993 | 2104993 | 2022-01-11 | Hatillo | Puerto Rico | 72065 | 3605 | |
2073411 | 2073411 | 2022-01-02 | Monroe | Alabama | 1099 | 3605 | 66 |
2053716 | 2053716 | 2021-12-26 | Brooke | West Virginia | 54009 | 3605 | 86 |
2050466 | 2050466 | 2021-12-25 | Brooke | West Virginia | 54009 | 3605 | 86 |
2047216 | 2047216 | 2021-12-24 | Brooke | West Virginia | 54009 | 3605 | 86 |
2043966 | 2043966 | 2021-12-23 | Brooke | West Virginia | 54009 | 3605 | 86 |
2038781 | 2038781 | 2021-12-22 | St. James | Louisiana | 22093 | 3605 | 70 |
2036896 | 2036896 | 2021-12-21 | Bledsoe | Tennessee | 47007 | 3605 | 29 |
2032691 | 2032691 | 2021-12-20 | Perry | Missouri | 29157 | 3605 | 40 |
2019750 | 2019750 | 2021-12-16 | Lincoln | Montana | 30053 | 3605 | 72 |
2012428 | 2012428 | 2021-12-14 | Crawford | Iowa | 19047 | 3605 | 48 |
2009177 | 2009177 | 2021-12-13 | Crawford | Iowa | 19047 | 3605 | 48 |
2005926 | 2005926 | 2021-12-12 | Crawford | Iowa | 19047 | 3605 | 48 |
2002675 | 2002675 | 2021-12-11 | Crawford | Iowa | 19047 | 3605 | 48 |
1999425 | 1999425 | 2021-12-10 | Crawford | Iowa | 19047 | 3605 | 48 |
1996174 | 1996174 | 2021-12-09 | Crawford | Iowa | 19047 | 3605 | 48 |
1996364 | 1996364 | 2021-12-09 | Bourbon | Kentucky | 21017 | 3605 | 41 |
1992923 | 1992923 | 2021-12-08 | Crawford | Iowa | 19047 | 3605 | 48 |
1994818 | 1994818 | 2021-12-08 | Gonzales | Texas | 48177 | 3605 | 85 |
1992070 | 1992070 | 2021-12-07 | Vernon | Wisconsin | 55123 | 3605 | 69 |
1988819 | 1988819 | 2021-12-06 | Vernon | Wisconsin | 55123 | 3605 | 69 |
1985569 | 1985569 | 2021-12-05 | Vernon | Wisconsin | 55123 | 3605 | 69 |
1982319 | 1982319 | 2021-12-04 | Vernon | Wisconsin | 55123 | 3605 | 69 |
1979069 | 1979069 | 2021-12-03 | Vernon | Wisconsin | 55123 | 3605 | 69 |
1975369 | 1975369 | 2021-12-02 | Lampasas | Texas | 48281 | 3605 | 70 |
1922167 | 1922167 | 2021-11-16 | Nodaway | Missouri | 29147 | 3605 | 34 |
1905397 | 1905397 | 2021-11-11 | Hart | Kentucky | 21099 | 3605 | 66 |
1902147 | 1902147 | 2021-11-10 | Hart | Kentucky | 21099 | 3605 | 66 |
1895600 | 1895600 | 2021-11-08 | Anderson | Kentucky | 21005 | 3605 | 48 |
1894046 | 1894046 | 2021-11-07 | Fayette | Texas | 48149 | 3605 | 93 |
1890796 | 1890796 | 2021-11-06 | Fayette | Texas | 48149 | 3605 | 93 |
1878775 | 1878775 | 2021-11-03 | Cook | Georgia | 13075 | 3605 | 62 |
1879035 | 1879035 | 2021-11-03 | Shelby | Illinois | 17173 | 3605 | 53 |
1875101 | 1875101 | 2021-11-02 | Barbour | Alabama | 1005 | 3605 | 76 |
1858729 | 1858729 | 2021-10-27 | Mason | West Virginia | 54053 | 3605 | 54 |
1853881 | 1853881 | 2021-10-26 | Crawford | Missouri | 29055 | 3605 | 57 |
1849899 | 1849899 | 2021-10-25 | Washington | Indiana | 18175 | 3605 | 52 |
1839509 | 1839509 | 2021-10-22 | Logan | Arkansas | 5083 | 3605 | 44 |
1842098 | 1842098 | 2021-10-22 | Hutchinson | Texas | 48233 | 3605 | 86 |
1837415 | 1837415 | 2021-10-21 | Oceana | Michigan | 26127 | 3605 | 69 |
1837606 | 1837606 | 2021-10-21 | Adair | Missouri | 29001 | 3605 | 34 |
1838849 | 1838849 | 2021-10-21 | Hutchinson | Texas | 48233 | 3605 | 86 |
1834166 | 1834166 | 2021-10-20 | Oceana | Michigan | 26127 | 3605 | 69 |
1830871 | 1830871 | 2021-10-19 | Clare | Michigan | 26035 | 3605 | 97 |
1827622 | 1827622 | 2021-10-18 | Clare | Michigan | 26035 | 3605 | 97 |
1826107 | 1826107 | 2021-10-17 | Lee | Virginia | 51105 | 3605 | 57 |
1822858 | 1822858 | 2021-10-16 | Lee | Virginia | 51105 | 3605 | 57 |
1819609 | 1819609 | 2021-10-15 | Lee | Virginia | 51105 | 3605 | 57 |
1814554 | 1814554 | 2021-10-14 | Aroostook | Maine | 23003 | 3605 | 79 |
1770852 | 1770852 | 2021-09-30 | Gloucester | Virginia | 51073 | 3605 | 60 |
1694317 | 1694317 | 2021-09-07 | Pointe Coupee | Louisiana | 22077 | 3605 | 80 |
1682456 | 1682456 | 2021-09-03 | Jefferson | Pennsylvania | 42065 | 3605 | 100 |
1677106 | 1677106 | 2021-09-02 | Glenn | California | 6021 | 3605 | 30 |
1672017 | 1672017 | 2021-08-31 | Stone | Missouri | 29209 | 3605 | 65 |
1668770 | 1668770 | 2021-08-30 | Stone | Missouri | 29209 | 3605 | 62 |
1642208 | 1642208 | 2021-08-22 | Clark | Kentucky | 21049 | 3605 | 32 |
1643723 | 1643723 | 2021-08-22 | Claiborne | Tennessee | 47025 | 3605 | 79 |
1638958 | 1638958 | 2021-08-21 | Clark | Kentucky | 21049 | 3605 | 32 |
1640473 | 1640473 | 2021-08-21 | Claiborne | Tennessee | 47025 | 3605 | 79 |
1635708 | 1635708 | 2021-08-20 | Clark | Kentucky | 21049 | 3605 | 32 |
1637223 | 1637223 | 2021-08-20 | Claiborne | Tennessee | 47025 | 3605 | 79 |
1631867 | 1631867 | 2021-08-19 | Decatur | Georgia | 13087 | 3605 | 78 |
1629669 | 1629669 | 2021-08-18 | Tippah | Mississippi | 28139 | 3605 | 74 |
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);