ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where deaths = 659 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Florida 16
- New York 11
- California 10
- Pennsylvania 9
- Texas 9
- Iowa 7
- Michigan 7
- Mississippi 7
- New Hampshire 7
- Indiana 6
- Massachusetts 6
- North Carolina 5
- Arizona 4
- Georgia 4
- Illinois 4
- Louisiana 4
- Nevada 4
- New Jersey 4
- Connecticut 3
- Washington 3
- Arkansas 2
- Maryland 2
- Missouri 2
- Tennessee 2
- Alabama 1
- Colorado 1
- Delaware 1
- New Mexico 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501440 | 2501440 | 2022-05-13 | Dutchess | New York | 36027 | 66962 | 659 |
2498182 | 2498182 | 2022-05-12 | Dutchess | New York | 36027 | 66962 | 659 |
2494924 | 2494924 | 2022-05-11 | Dutchess | New York | 36027 | 66790 | 659 |
2491666 | 2491666 | 2022-05-10 | Dutchess | New York | 36027 | 66665 | 659 |
2488408 | 2488408 | 2022-05-09 | Dutchess | New York | 36027 | 66576 | 659 |
2485151 | 2485151 | 2022-05-08 | Dutchess | New York | 36027 | 66472 | 659 |
2473826 | 2473826 | 2022-05-05 | New London | Connecticut | 9011 | 56984 | 659 |
2470569 | 2470569 | 2022-05-04 | New London | Connecticut | 9011 | 56880 | 659 |
2467313 | 2467313 | 2022-05-03 | New London | Connecticut | 9011 | 56816 | 659 |
2467357 | 2467357 | 2022-05-03 | Leon | Florida | 12073 | 85273 | 659 |
2464102 | 2464102 | 2022-05-02 | Leon | Florida | 12073 | 85273 | 659 |
2460846 | 2460846 | 2022-05-01 | Leon | Florida | 12073 | 85273 | 659 |
2457590 | 2457590 | 2022-04-30 | Leon | Florida | 12073 | 85273 | 659 |
2454334 | 2454334 | 2022-04-29 | Leon | Florida | 12073 | 85273 | 659 |
2451078 | 2451078 | 2022-04-28 | Leon | Florida | 12073 | 85273 | 659 |
2447822 | 2447822 | 2022-04-27 | Leon | Florida | 12073 | 85273 | 659 |
2398949 | 2398949 | 2022-04-12 | Alachua | Florida | 12001 | 68136 | 659 |
2399359 | 2399359 | 2022-04-12 | Hamilton | Indiana | 18057 | 81852 | 659 |
2395694 | 2395694 | 2022-04-11 | Alachua | Florida | 12001 | 68136 | 659 |
2396104 | 2396104 | 2022-04-11 | Hamilton | Indiana | 18057 | 81852 | 659 |
2392438 | 2392438 | 2022-04-10 | Alachua | Florida | 12001 | 68136 | 659 |
2392848 | 2392848 | 2022-04-10 | Hamilton | Indiana | 18057 | 81823 | 659 |
2389182 | 2389182 | 2022-04-09 | Alachua | Florida | 12001 | 68136 | 659 |
2389592 | 2389592 | 2022-04-09 | Hamilton | Indiana | 18057 | 81823 | 659 |
2385927 | 2385927 | 2022-04-08 | Alachua | Florida | 12001 | 68136 | 659 |
2386337 | 2386337 | 2022-04-08 | Hamilton | Indiana | 18057 | 81823 | 659 |
2382672 | 2382672 | 2022-04-07 | Alachua | Florida | 12001 | 67908 | 659 |
2379417 | 2379417 | 2022-04-06 | Alachua | Florida | 12001 | 67908 | 659 |
2348002 | 2348002 | 2022-03-27 | Harrison | Mississippi | 28047 | 53472 | 659 |
2344749 | 2344749 | 2022-03-26 | Harrison | Mississippi | 28047 | 53472 | 659 |
2341496 | 2341496 | 2022-03-25 | Harrison | Mississippi | 28047 | 53472 | 659 |
2338243 | 2338243 | 2022-03-24 | Harrison | Mississippi | 28047 | 53472 | 659 |
2334989 | 2334989 | 2022-03-23 | Harrison | Mississippi | 28047 | 53472 | 659 |
2331735 | 2331735 | 2022-03-22 | Harrison | Mississippi | 28047 | 53472 | 659 |
2328483 | 2328483 | 2022-03-21 | Harrison | Mississippi | 28047 | 53472 | 659 |
2314495 | 2314495 | 2022-03-17 | Henry | Georgia | 13151 | 57553 | 659 |
2288241 | 2288241 | 2022-03-09 | Santa Barbara | California | 6083 | 90153 | 659 |
2290732 | 2290732 | 2022-03-09 | Gregg | Texas | 48183 | 23061 | 659 |
2284990 | 2284990 | 2022-03-08 | Santa Barbara | California | 6083 | 90135 | 659 |
2281738 | 2281738 | 2022-03-07 | Santa Barbara | California | 6083 | 90107 | 659 |
2283830 | 2283830 | 2022-03-07 | Schuylkill | Pennsylvania | 42107 | 34219 | 659 |
2280578 | 2280578 | 2022-03-06 | Schuylkill | Pennsylvania | 42107 | 34208 | 659 |
2225677 | 2225677 | 2022-02-17 | Ector | Texas | 48135 | 36739 | 659 |
2193305 | 2193305 | 2022-02-07 | Taylor | Texas | 48441 | 32090 | 659 |
2190051 | 2190051 | 2022-02-06 | Taylor | Texas | 48441 | 31936 | 659 |
2186798 | 2186798 | 2022-02-05 | Taylor | Texas | 48441 | 31936 | 659 |
2183546 | 2183546 | 2022-02-04 | Taylor | Texas | 48441 | 31936 | 659 |
2175326 | 2175326 | 2022-02-02 | Calcasieu | Louisiana | 22019 | 50804 | 659 |
2172073 | 2172073 | 2022-02-01 | Calcasieu | Louisiana | 22019 | 50596 | 659 |
2160227 | 2160227 | 2022-01-28 | Lackawanna | Pennsylvania | 42069 | 40199 | 659 |
2141871 | 2141871 | 2022-01-23 | Monterey | California | 6053 | 70370 | 659 |
2138616 | 2138616 | 2022-01-22 | Monterey | California | 6053 | 70370 | 659 |
2135360 | 2135360 | 2022-01-21 | Monterey | California | 6053 | 70370 | 659 |
2134185 | 2134185 | 2022-01-20 | Erie | Pennsylvania | 42049 | 51624 | 659 |
2129366 | 2129366 | 2022-01-19 | Elkhart | Indiana | 18039 | 49023 | 659 |
2104568 | 2104568 | 2022-01-11 | Gaston | North Carolina | 37071 | 50101 | 659 |
2101317 | 2101317 | 2022-01-10 | Gaston | North Carolina | 37071 | 49684 | 659 |
2098066 | 2098066 | 2022-01-09 | Gaston | North Carolina | 37071 | 48286 | 659 |
2094814 | 2094814 | 2022-01-08 | Gaston | North Carolina | 37071 | 48286 | 659 |
2091562 | 2091562 | 2022-01-07 | Gaston | North Carolina | 37071 | 48286 | 659 |
2084956 | 2084956 | 2022-01-05 | San Juan | New Mexico | 35045 | 28958 | 659 |
2024725 | 2024725 | 2021-12-18 | Benton | Arkansas | 5007 | 45150 | 659 |
2021474 | 2021474 | 2021-12-17 | Benton | Arkansas | 5007 | 45093 | 659 |
1982753 | 1982753 | 2021-12-05 | Bibb | Georgia | 13021 | 26150 | 659 |
1979503 | 1979503 | 2021-12-04 | Bibb | Georgia | 13021 | 26150 | 659 |
1976253 | 1976253 | 2021-12-03 | Bibb | Georgia | 13021 | 26150 | 659 |
1924531 | 1924531 | 2021-11-17 | St. Clair | Illinois | 17163 | 41493 | 659 |
1893633 | 1893633 | 2021-11-07 | Dauphin | Pennsylvania | 42043 | 35485 | 659 |
1890383 | 1890383 | 2021-11-06 | Dauphin | Pennsylvania | 42043 | 35428 | 659 |
1887133 | 1887133 | 2021-11-05 | Dauphin | Pennsylvania | 42043 | 35342 | 659 |
1807526 | 1807526 | 2021-10-12 | Madison | Illinois | 17119 | 39698 | 659 |
1790665 | 1790665 | 2021-10-07 | Madison | Alabama | 1089 | 51380 | 659 |
1792166 | 1792166 | 2021-10-07 | Jackson | Missouri | 29095 | 54469 | 659 |
1790242 | 1790242 | 2021-10-06 | Williamson | Texas | 48491 | 73625 | 659 |
1785669 | 1785669 | 2021-10-05 | Jackson | Missouri | 29095 | 54275 | 659 |
1769192 | 1769192 | 2021-09-30 | Saginaw | Michigan | 26145 | 25841 | 659 |
1765943 | 1765943 | 2021-09-29 | Saginaw | Michigan | 26145 | 25841 | 659 |
1756197 | 1756197 | 2021-09-26 | Saginaw | Michigan | 26145 | 25519 | 659 |
1752949 | 1752949 | 2021-09-25 | Saginaw | Michigan | 26145 | 25519 | 659 |
1749701 | 1749701 | 2021-09-24 | Saginaw | Michigan | 26145 | 25519 | 659 |
1746451 | 1746451 | 2021-09-23 | Saginaw | Michigan | 26145 | 25358 | 659 |
1743202 | 1743202 | 2021-09-22 | Saginaw | Michigan | 26145 | 25358 | 659 |
1724176 | 1724176 | 2021-09-16 | Hillsborough | New Hampshire | 33011 | 40467 | 659 |
1720927 | 1720927 | 2021-09-15 | Hillsborough | New Hampshire | 33011 | 40300 | 659 |
1717679 | 1717679 | 2021-09-14 | Hillsborough | New Hampshire | 33011 | 40137 | 659 |
1714431 | 1714431 | 2021-09-13 | Hillsborough | New Hampshire | 33011 | 40047 | 659 |
1711185 | 1711185 | 2021-09-12 | Hillsborough | New Hampshire | 33011 | 39775 | 659 |
1707938 | 1707938 | 2021-09-11 | Hillsborough | New Hampshire | 33011 | 39775 | 659 |
1704691 | 1704691 | 2021-09-10 | Hillsborough | New Hampshire | 33011 | 39775 | 659 |
1694030 | 1694030 | 2021-09-07 | Polk | Iowa | 19153 | 63926 | 659 |
1690781 | 1690781 | 2021-09-06 | Polk | Iowa | 19153 | 63926 | 659 |
1687531 | 1687531 | 2021-09-05 | Polk | Iowa | 19153 | 63926 | 659 |
1684281 | 1684281 | 2021-09-04 | Polk | Iowa | 19153 | 63926 | 659 |
1681030 | 1681030 | 2021-09-03 | Polk | Iowa | 19153 | 63926 | 659 |
1677782 | 1677782 | 2021-09-02 | Polk | Iowa | 19153 | 63926 | 659 |
1674535 | 1674535 | 2021-09-01 | Polk | Iowa | 19153 | 63926 | 659 |
1665719 | 1665719 | 2021-08-29 | Gloucester | New Jersey | 34015 | 33187 | 659 |
1650902 | 1650902 | 2021-08-24 | Waukesha | Wisconsin | 55133 | 53015 | 659 |
1270504 | 1270504 | 2021-04-29 | Fort Bend | Texas | 48157 | 66660 | 659 |
1267257 | 1267257 | 2021-04-28 | Fort Bend | Texas | 48157 | 66515 | 659 |
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);