ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
356 rows where cases = 1359 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 33
- Georgia 29
- Kentucky 19
- Wisconsin 19
- Texas 17
- Virginia 15
- Arkansas 14
- Kansas 14
- Missouri 13
- Minnesota 12
- Tennessee 12
- Puerto Rico 11
- Illinois 10
- North Carolina 10
- Mississippi 9
- Utah 9
- Alabama 8
- Montana 8
- Pennsylvania 8
- Oregon 7
- South Dakota 7
- Michigan 6
- West Virginia 6
- New Mexico 5
- New York 5
- South Carolina 5
- Florida 4
- Louisiana 4
- New Jersey 4
- Ohio 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427406 | 2427406 | 2022-04-20 | Hartley | Texas | 48205 | 1359 | 3 |
2346972 | 2346972 | 2022-03-27 | Calhoun | Georgia | 13037 | 1359 | 22 |
2343719 | 2343719 | 2022-03-26 | Calhoun | Georgia | 13037 | 1359 | 22 |
2340466 | 2340466 | 2022-03-25 | Calhoun | Georgia | 13037 | 1359 | 22 |
2337213 | 2337213 | 2022-03-24 | Calhoun | Georgia | 13037 | 1359 | 22 |
2333959 | 2333959 | 2022-03-23 | Calhoun | Georgia | 13037 | 1359 | 22 |
2332680 | 2332680 | 2022-03-22 | Maunabo | Puerto Rico | 72095 | 1359 | |
2329427 | 2329427 | 2022-03-21 | Maunabo | Puerto Rico | 72095 | 1359 | |
2326175 | 2326175 | 2022-03-20 | Maunabo | Puerto Rico | 72095 | 1359 | |
2308494 | 2308494 | 2022-03-15 | Phillips | Kansas | 20147 | 1359 | 29 |
2304682 | 2304682 | 2022-03-14 | Calhoun | Georgia | 13037 | 1359 | 22 |
2305243 | 2305243 | 2022-03-14 | Phillips | Kansas | 20147 | 1359 | 29 |
2301991 | 2301991 | 2022-03-13 | Phillips | Kansas | 20147 | 1359 | 29 |
2298739 | 2298739 | 2022-03-12 | Phillips | Kansas | 20147 | 1359 | 29 |
2300572 | 2300572 | 2022-03-12 | Newton | Texas | 48351 | 1359 | 59 |
2295487 | 2295487 | 2022-03-11 | Phillips | Kansas | 20147 | 1359 | 29 |
2297320 | 2297320 | 2022-03-11 | Newton | Texas | 48351 | 1359 | 59 |
2294068 | 2294068 | 2022-03-10 | Newton | Texas | 48351 | 1359 | 59 |
2290816 | 2290816 | 2022-03-09 | Newton | Texas | 48351 | 1359 | 59 |
2241487 | 2241487 | 2022-02-22 | Lake | Oregon | 41037 | 1359 | 23 |
2217349 | 2217349 | 2022-02-15 | Osceola | Iowa | 19143 | 1359 | 20 |
2214098 | 2214098 | 2022-02-14 | Osceola | Iowa | 19143 | 1359 | 20 |
2210846 | 2210846 | 2022-02-13 | Osceola | Iowa | 19143 | 1359 | 20 |
2207593 | 2207593 | 2022-02-12 | Osceola | Iowa | 19143 | 1359 | 20 |
2204340 | 2204340 | 2022-02-11 | Osceola | Iowa | 19143 | 1359 | 20 |
2201087 | 2201087 | 2022-02-10 | Osceola | Iowa | 19143 | 1359 | 20 |
2197833 | 2197833 | 2022-02-09 | Osceola | Iowa | 19143 | 1359 | 20 |
2189725 | 2189725 | 2022-02-06 | Spink | South Dakota | 46115 | 1359 | 32 |
2186472 | 2186472 | 2022-02-05 | Spink | South Dakota | 46115 | 1359 | 32 |
2183220 | 2183220 | 2022-02-04 | Spink | South Dakota | 46115 | 1359 | 32 |
2152013 | 2152013 | 2022-01-26 | Power | Idaho | 16077 | 1359 | 18 |
2153151 | 2153151 | 2022-01-26 | Nemaha | Nebraska | 31127 | 1359 | 18 |
2113901 | 2113901 | 2022-01-14 | Clark | Missouri | 29045 | 1359 | 28 |
2080688 | 2080688 | 2022-01-04 | Davis | Iowa | 19051 | 1359 | 26 |
2082923 | 2082923 | 2022-01-04 | Williamsburg city | Virginia | 51830 | 1359 | 13 |
2077161 | 2077161 | 2022-01-03 | Wilcox | Georgia | 13315 | 1359 | 62 |
2077436 | 2077436 | 2022-01-03 | Davis | Iowa | 19051 | 1359 | 26 |
2073910 | 2073910 | 2022-01-02 | Wilcox | Georgia | 13315 | 1359 | 62 |
2074185 | 2074185 | 2022-01-02 | Davis | Iowa | 19051 | 1359 | 26 |
2074903 | 2074903 | 2022-01-02 | Hickory | Missouri | 29085 | 1359 | 45 |
2070659 | 2070659 | 2022-01-01 | Wilcox | Georgia | 13315 | 1359 | 62 |
2070934 | 2070934 | 2022-01-01 | Davis | Iowa | 19051 | 1359 | 26 |
2071652 | 2071652 | 2022-01-01 | Hickory | Missouri | 29085 | 1359 | 45 |
2067408 | 2067408 | 2021-12-31 | Wilcox | Georgia | 13315 | 1359 | 62 |
2067683 | 2067683 | 2021-12-31 | Davis | Iowa | 19051 | 1359 | 26 |
2068401 | 2068401 | 2021-12-31 | Hickory | Missouri | 29085 | 1359 | 45 |
2064432 | 2064432 | 2021-12-30 | Davis | Iowa | 19051 | 1359 | 26 |
2065150 | 2065150 | 2021-12-30 | Hickory | Missouri | 29085 | 1359 | 45 |
2061182 | 2061182 | 2021-12-29 | Davis | Iowa | 19051 | 1359 | 26 |
2036993 | 2036993 | 2021-12-21 | Archer | Texas | 48009 | 1359 | 24 |
2024083 | 2024083 | 2021-12-17 | Hamilton | Texas | 48193 | 1359 | 29 |
2012728 | 2012728 | 2021-12-14 | Wolfe | Kentucky | 21237 | 1359 | 13 |
2008531 | 2008531 | 2021-12-13 | Searcy | Arkansas | 5129 | 1359 | 26 |
2008841 | 2008841 | 2021-12-13 | Macon | Georgia | 13193 | 1359 | 45 |
2005280 | 2005280 | 2021-12-12 | Searcy | Arkansas | 5129 | 1359 | 26 |
2004537 | 2004537 | 2021-12-11 | Dallam | Texas | 48111 | 1359 | 30 |
1996298 | 1996298 | 2021-12-09 | Kingman | Kansas | 20095 | 1359 | 24 |
1996892 | 1996892 | 2021-12-09 | Harrison | Missouri | 29081 | 1359 | 21 |
1993047 | 1993047 | 2021-12-08 | Kingman | Kansas | 20095 | 1359 | 24 |
1995305 | 1995305 | 2021-12-08 | Pepin | Wisconsin | 55091 | 1359 | 10 |
1964795 | 1964795 | 2021-11-29 | Graham | North Carolina | 37075 | 1359 | 28 |
1960572 | 1960572 | 2021-11-28 | Pratt | Kansas | 20151 | 1359 | 27 |
1961267 | 1961267 | 2021-11-28 | Valley | Montana | 30105 | 1359 | 29 |
1957321 | 1957321 | 2021-11-27 | Pratt | Kansas | 20151 | 1359 | 27 |
1958016 | 1958016 | 2021-11-27 | Valley | Montana | 30105 | 1359 | 29 |
1954070 | 1954070 | 2021-11-26 | Pratt | Kansas | 20151 | 1359 | 27 |
1954765 | 1954765 | 2021-11-26 | Valley | Montana | 30105 | 1359 | 29 |
1950819 | 1950819 | 2021-11-25 | Pratt | Kansas | 20151 | 1359 | 27 |
1951514 | 1951514 | 2021-11-25 | Valley | Montana | 30105 | 1359 | 29 |
1947568 | 1947568 | 2021-11-24 | Pratt | Kansas | 20151 | 1359 | 27 |
1948263 | 1948263 | 2021-11-24 | Valley | Montana | 30105 | 1359 | 29 |
1939952 | 1939952 | 2021-11-21 | Clay | West Virginia | 54015 | 1359 | 21 |
1928518 | 1928518 | 2021-11-18 | Choctaw | Mississippi | 28019 | 1359 | 27 |
1925411 | 1925411 | 2021-11-17 | Monroe | Missouri | 29137 | 1359 | 13 |
1922019 | 1922019 | 2021-11-16 | Choctaw | Mississippi | 28019 | 1359 | 27 |
1918377 | 1918377 | 2021-11-15 | Elliott | Kentucky | 21063 | 1359 | 8 |
1920367 | 1920367 | 2021-11-15 | Poquoson city | Virginia | 51735 | 1359 | 22 |
1901155 | 1901155 | 2021-11-10 | Sumter | Alabama | 1119 | 1359 | 40 |
1899420 | 1899420 | 2021-11-09 | Oregon | Missouri | 29149 | 1359 | 11 |
1886043 | 1886043 | 2021-11-05 | Piscataquis | Maine | 23021 | 1359 | 12 |
1868498 | 1868498 | 2021-10-30 | Tyler | West Virginia | 54095 | 1359 | 19 |
1865249 | 1865249 | 2021-10-29 | Tyler | West Virginia | 54095 | 1359 | 19 |
1862000 | 1862000 | 2021-10-28 | Tyler | West Virginia | 54095 | 1359 | 19 |
1850766 | 1850766 | 2021-10-25 | Sanders | Montana | 30089 | 1359 | 19 |
1833954 | 1833954 | 2021-10-20 | Owen | Kentucky | 21187 | 1359 | 22 |
1829770 | 1829770 | 2021-10-19 | Nevada | Arkansas | 5099 | 1359 | 38 |
1813260 | 1813260 | 2021-10-13 | Summers | West Virginia | 54089 | 1359 | 29 |
1807791 | 1807791 | 2021-10-12 | Ellsworth | Kansas | 20053 | 1359 | 28 |
1809272 | 1809272 | 2021-10-12 | Utuado | Puerto Rico | 72141 | 1359 | |
1804540 | 1804540 | 2021-10-11 | Ellsworth | Kansas | 20053 | 1359 | 28 |
1805131 | 1805131 | 2021-10-11 | Carroll | Missouri | 29033 | 1359 | 26 |
1806022 | 1806022 | 2021-10-11 | Utuado | Puerto Rico | 72141 | 1359 | |
1801731 | 1801731 | 2021-10-10 | Koochiching | Minnesota | 27071 | 1359 | 19 |
1798482 | 1798482 | 2021-10-09 | Koochiching | Minnesota | 27071 | 1359 | 19 |
1795233 | 1795233 | 2021-10-08 | Koochiching | Minnesota | 27071 | 1359 | 19 |
1769291 | 1769291 | 2021-09-30 | Yellow Medicine | Minnesota | 27173 | 1359 | 20 |
1767536 | 1767536 | 2021-09-29 | Addison | Vermont | 50001 | 1359 | 8 |
1747728 | 1747728 | 2021-09-23 | Moore | Tennessee | 47127 | 1359 | 19 |
1742480 | 1742480 | 2021-09-22 | Owyhee | Idaho | 16073 | 1359 | 34 |
1718866 | 1718866 | 2021-09-14 | Galax city | Virginia | 51640 | 1359 | 53 |
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);