ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
362 rows where cases = 1251 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 34
- Iowa 23
- Mississippi 21
- Oregon 18
- Virginia 18
- Georgia 16
- Puerto Rico 16
- Idaho 14
- Illinois 13
- Oklahoma 13
- Kansas 12
- Missouri 12
- Kentucky 11
- Wisconsin 11
- Minnesota 10
- North Carolina 10
- West Virginia 10
- Tennessee 8
- Maine 7
- Alabama 6
- South Dakota 6
- Montana 5
- New Mexico 5
- Pennsylvania 5
- Utah 5
- Alaska 4
- Louisiana 4
- Nebraska 4
- North Dakota 4
- South Carolina 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2404147 | 2404147 | 2022-04-13 | Wallowa | Oregon | 41063 | 1251 | 16 |
2400892 | 2400892 | 2022-04-12 | Wallowa | Oregon | 41063 | 1251 | 16 |
2397637 | 2397637 | 2022-04-11 | Wallowa | Oregon | 41063 | 1251 | 16 |
2398332 | 2398332 | 2022-04-11 | Covington city | Virginia | 51580 | 1251 | 26 |
2394382 | 2394382 | 2022-04-10 | Wallowa | Oregon | 41063 | 1251 | 16 |
2391126 | 2391126 | 2022-04-09 | Wallowa | Oregon | 41063 | 1251 | 16 |
2387870 | 2387870 | 2022-04-08 | Wallowa | Oregon | 41063 | 1251 | 16 |
2384615 | 2384615 | 2022-04-07 | Wallowa | Oregon | 41063 | 1251 | 16 |
2381360 | 2381360 | 2022-04-06 | Wallowa | Oregon | 41063 | 1251 | 16 |
2378105 | 2378105 | 2022-04-05 | Wallowa | Oregon | 41063 | 1251 | 16 |
2374851 | 2374851 | 2022-04-04 | Wallowa | Oregon | 41063 | 1251 | 16 |
2371599 | 2371599 | 2022-04-03 | Wallowa | Oregon | 41063 | 1251 | 16 |
2368346 | 2368346 | 2022-04-02 | Wallowa | Oregon | 41063 | 1251 | 16 |
2365093 | 2365093 | 2022-04-01 | Wallowa | Oregon | 41063 | 1251 | 16 |
2361840 | 2361840 | 2022-03-31 | Wallowa | Oregon | 41063 | 1251 | 16 |
2358586 | 2358586 | 2022-03-30 | Wallowa | Oregon | 41063 | 1251 | 16 |
2355332 | 2355332 | 2022-03-29 | Wallowa | Oregon | 41063 | 1251 | 16 |
2352079 | 2352079 | 2022-03-28 | Wallowa | Oregon | 41063 | 1251 | 15 |
2334236 | 2334236 | 2022-03-23 | Scott | Illinois | 17171 | 1251 | 11 |
2330982 | 2330982 | 2022-03-22 | Scott | Illinois | 17171 | 1251 | 11 |
2327730 | 2327730 | 2022-03-21 | Scott | Illinois | 17171 | 1251 | 11 |
2301608 | 2301608 | 2022-03-13 | Lemhi | Idaho | 16059 | 1251 | 25 |
2298356 | 2298356 | 2022-03-12 | Lemhi | Idaho | 16059 | 1251 | 25 |
2295104 | 2295104 | 2022-03-11 | Lemhi | Idaho | 16059 | 1251 | 25 |
2291852 | 2291852 | 2022-03-10 | Lemhi | Idaho | 16059 | 1251 | 25 |
2229020 | 2229020 | 2022-02-18 | McCulloch | Texas | 48307 | 1251 | 44 |
2226000 | 2226000 | 2022-02-17 | Norton city | Virginia | 51720 | 1251 | 22 |
2216568 | 2216568 | 2022-02-15 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1251 | 6 |
2213317 | 2213317 | 2022-02-14 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1251 | 6 |
2215908 | 2215908 | 2022-02-14 | Crane | Texas | 48103 | 1251 | 23 |
2212657 | 2212657 | 2022-02-13 | Crane | Texas | 48103 | 1251 | 23 |
2190276 | 2190276 | 2022-02-06 | Ferry | Washington | 53019 | 1251 | 21 |
2187023 | 2187023 | 2022-02-05 | Ferry | Washington | 53019 | 1251 | 21 |
2183428 | 2183428 | 2022-02-04 | Hartley | Texas | 48205 | 1251 | 3 |
2183770 | 2183770 | 2022-02-04 | Ferry | Washington | 53019 | 1251 | 21 |
2123870 | 2123870 | 2022-01-17 | Nemaha | Nebraska | 31127 | 1251 | 18 |
2124929 | 2124929 | 2022-01-17 | Mills | Texas | 48333 | 1251 | 29 |
2098616 | 2098616 | 2022-01-09 | Hamlin | South Dakota | 46057 | 1251 | 40 |
2095364 | 2095364 | 2022-01-08 | Hamlin | South Dakota | 46057 | 1251 | 40 |
2092112 | 2092112 | 2022-01-07 | Hamlin | South Dakota | 46057 | 1251 | 40 |
2082973 | 2082973 | 2022-01-04 | Calhoun | West Virginia | 54013 | 1251 | 9 |
2056270 | 2056270 | 2021-12-27 | Villalba | Puerto Rico | 72149 | 1251 | |
2038103 | 2038103 | 2021-12-22 | Miller | Georgia | 13201 | 1251 | 24 |
2034113 | 2034113 | 2021-12-20 | Lunenburg | Virginia | 51111 | 1251 | 23 |
2020497 | 2020497 | 2021-12-16 | Orocovis | Puerto Rico | 72107 | 1251 | |
2017246 | 2017246 | 2021-12-15 | Orocovis | Puerto Rico | 72107 | 1251 | |
1972368 | 1972368 | 2021-12-01 | Northumberland | Virginia | 51133 | 1251 | 37 |
1930294 | 1930294 | 2021-11-18 | Pepin | Wisconsin | 55091 | 1251 | 10 |
1925525 | 1925525 | 2021-11-17 | Butler | Nebraska | 31023 | 1251 | 12 |
1910275 | 1910275 | 2021-11-12 | Dallam | Texas | 48111 | 1251 | 29 |
1907026 | 1907026 | 2021-11-11 | Dallam | Texas | 48111 | 1251 | 29 |
1897237 | 1897237 | 2021-11-08 | Blanco | Texas | 48031 | 1251 | 28 |
1893987 | 1893987 | 2021-11-07 | Blanco | Texas | 48031 | 1251 | 28 |
1890737 | 1890737 | 2021-11-06 | Blanco | Texas | 48031 | 1251 | 28 |
1877716 | 1877716 | 2021-11-02 | Van Buren | Tennessee | 47175 | 1251 | 28 |
1854550 | 1854550 | 2021-10-26 | Major | Oklahoma | 40093 | 1251 | 32 |
1850705 | 1850705 | 2021-10-25 | St. Clair | Missouri | 29185 | 1251 | 14 |
1851301 | 1851301 | 2021-10-25 | Major | Oklahoma | 40093 | 1251 | 32 |
1847455 | 1847455 | 2021-10-24 | St. Clair | Missouri | 29185 | 1251 | 14 |
1847474 | 1847474 | 2021-10-24 | Blaine | Montana | 30005 | 1251 | 25 |
1848051 | 1848051 | 2021-10-24 | Major | Oklahoma | 40093 | 1251 | 32 |
1844205 | 1844205 | 2021-10-23 | St. Clair | Missouri | 29185 | 1251 | 14 |
1844224 | 1844224 | 2021-10-23 | Blaine | Montana | 30005 | 1251 | 25 |
1844801 | 1844801 | 2021-10-23 | Major | Oklahoma | 40093 | 1251 | 32 |
1840955 | 1840955 | 2021-10-22 | St. Clair | Missouri | 29185 | 1251 | 14 |
1840974 | 1840974 | 2021-10-22 | Blaine | Montana | 30005 | 1251 | 25 |
1841551 | 1841551 | 2021-10-22 | Major | Oklahoma | 40093 | 1251 | 32 |
1838302 | 1838302 | 2021-10-21 | Major | Oklahoma | 40093 | 1251 | 32 |
1835053 | 1835053 | 2021-10-20 | Major | Oklahoma | 40093 | 1251 | 32 |
1787941 | 1787941 | 2021-10-06 | Boundary | Idaho | 16021 | 1251 | 23 |
1784671 | 1784671 | 2021-10-05 | Wilcox | Georgia | 13315 | 1251 | 53 |
1781422 | 1781422 | 2021-10-04 | Wilcox | Georgia | 13315 | 1251 | 53 |
1769833 | 1769833 | 2021-09-30 | Jones | North Carolina | 37103 | 1251 | 29 |
1760947 | 1760947 | 2021-09-27 | Red River | Texas | 48387 | 1251 | 46 |
1756244 | 1756244 | 2021-09-26 | Koochiching | Minnesota | 27071 | 1251 | 19 |
1757699 | 1757699 | 2021-09-26 | Red River | Texas | 48387 | 1251 | 46 |
1757849 | 1757849 | 2021-09-26 | Floyd | Virginia | 51063 | 1251 | 24 |
1752996 | 1752996 | 2021-09-25 | Koochiching | Minnesota | 27071 | 1251 | 19 |
1754451 | 1754451 | 2021-09-25 | Red River | Texas | 48387 | 1251 | 46 |
1754601 | 1754601 | 2021-09-25 | Floyd | Virginia | 51063 | 1251 | 24 |
1749748 | 1749748 | 2021-09-24 | Koochiching | Minnesota | 27071 | 1251 | 19 |
1751353 | 1751353 | 2021-09-24 | Floyd | Virginia | 51063 | 1251 | 24 |
1739453 | 1739453 | 2021-09-21 | Clarke | Iowa | 19039 | 1251 | 24 |
1739804 | 1739804 | 2021-09-21 | St. Helena | Louisiana | 22091 | 1251 | 15 |
1736204 | 1736204 | 2021-09-20 | Clarke | Iowa | 19039 | 1251 | 24 |
1732622 | 1732622 | 2021-09-19 | Macon | Georgia | 13193 | 1251 | 38 |
1732954 | 1732954 | 2021-09-19 | Clarke | Iowa | 19039 | 1251 | 24 |
1733553 | 1733553 | 2021-09-19 | Yellow Medicine | Minnesota | 27173 | 1251 | 20 |
1729372 | 1729372 | 2021-09-18 | Macon | Georgia | 13193 | 1251 | 38 |
1729704 | 1729704 | 2021-09-18 | Clarke | Iowa | 19039 | 1251 | 24 |
1730303 | 1730303 | 2021-09-18 | Yellow Medicine | Minnesota | 27173 | 1251 | 20 |
1726122 | 1726122 | 2021-09-17 | Macon | Georgia | 13193 | 1251 | 38 |
1726454 | 1726454 | 2021-09-17 | Clarke | Iowa | 19039 | 1251 | 24 |
1727053 | 1727053 | 2021-09-17 | Yellow Medicine | Minnesota | 27173 | 1251 | 20 |
1723205 | 1723205 | 2021-09-16 | Clarke | Iowa | 19039 | 1251 | 24 |
1725391 | 1725391 | 2021-09-16 | Manassas Park city | Virginia | 51685 | 1251 | 11 |
1719956 | 1719956 | 2021-09-15 | Clarke | Iowa | 19039 | 1251 | 24 |
1722142 | 1722142 | 2021-09-15 | Manassas Park city | Virginia | 51685 | 1251 | 11 |
1694351 | 1694351 | 2021-09-07 | Lincoln | Maine | 23015 | 1251 | 3 |
1695749 | 1695749 | 2021-09-07 | Moore | Tennessee | 47127 | 1251 | 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);