ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
183 rows where deaths = 664 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Florida 37
- Pennsylvania 18
- New York 13
- California 11
- Nevada 9
- Texas 9
- Iowa 7
- Louisiana 7
- New Jersey 7
- Oklahoma 7
- Georgia 6
- Mississippi 6
- Washington 6
- Illinois 5
- Maryland 5
- Missouri 5
- Alabama 4
- Indiana 3
- Massachusetts 3
- Michigan 3
- Delaware 2
- New Hampshire 2
- South Carolina 2
- Colorado 1
- Nebraska 1
- Ohio 1
- Tennessee 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490124 | 2490124 | 2022-05-10 | Alachua | Florida | 12001 | 69008 | 664 |
2486867 | 2486867 | 2022-05-09 | Alachua | Florida | 12001 | 69008 | 664 |
2483609 | 2483609 | 2022-05-08 | Alachua | Florida | 12001 | 69008 | 664 |
2480351 | 2480351 | 2022-05-07 | Alachua | Florida | 12001 | 69008 | 664 |
2477093 | 2477093 | 2022-05-06 | Alachua | Florida | 12001 | 69008 | 664 |
2473835 | 2473835 | 2022-05-05 | Alachua | Florida | 12001 | 68467 | 664 |
2470578 | 2470578 | 2022-05-04 | Alachua | Florida | 12001 | 68467 | 664 |
2461929 | 2461929 | 2022-05-01 | Harrison | Mississippi | 28047 | 53702 | 664 |
2458673 | 2458673 | 2022-04-30 | Harrison | Mississippi | 28047 | 53702 | 664 |
2455417 | 2455417 | 2022-04-29 | Harrison | Mississippi | 28047 | 53702 | 664 |
2452161 | 2452161 | 2022-04-28 | Harrison | Mississippi | 28047 | 53702 | 664 |
2448905 | 2448905 | 2022-04-27 | Harrison | Mississippi | 28047 | 53702 | 664 |
2445649 | 2445649 | 2022-04-26 | Harrison | Mississippi | 28047 | 53702 | 664 |
2421739 | 2421739 | 2022-04-19 | Alachua | Florida | 12001 | 68136 | 664 |
2418483 | 2418483 | 2022-04-18 | Alachua | Florida | 12001 | 68136 | 664 |
2415227 | 2415227 | 2022-04-17 | Alachua | Florida | 12001 | 68136 | 664 |
2411971 | 2411971 | 2022-04-16 | Alachua | Florida | 12001 | 68136 | 664 |
2408715 | 2408715 | 2022-04-15 | Alachua | Florida | 12001 | 68136 | 664 |
2405459 | 2405459 | 2022-04-14 | Alachua | Florida | 12001 | 68136 | 664 |
2402204 | 2402204 | 2022-04-13 | Alachua | Florida | 12001 | 68136 | 664 |
2365123 | 2365123 | 2022-04-01 | Fayette | Pennsylvania | 42051 | 30994 | 664 |
2361870 | 2361870 | 2022-03-31 | Fayette | Pennsylvania | 42051 | 30989 | 664 |
2358616 | 2358616 | 2022-03-30 | Fayette | Pennsylvania | 42051 | 30983 | 664 |
2355362 | 2355362 | 2022-03-29 | Fayette | Pennsylvania | 42051 | 30976 | 664 |
2350281 | 2350281 | 2022-03-28 | Henry | Georgia | 13151 | 57633 | 664 |
2352109 | 2352109 | 2022-03-28 | Fayette | Pennsylvania | 42051 | 30961 | 664 |
2347028 | 2347028 | 2022-03-27 | Henry | Georgia | 13151 | 57616 | 664 |
2348857 | 2348857 | 2022-03-27 | Fayette | Pennsylvania | 42051 | 30959 | 664 |
2343775 | 2343775 | 2022-03-26 | Henry | Georgia | 13151 | 57616 | 664 |
2345604 | 2345604 | 2022-03-26 | Fayette | Pennsylvania | 42051 | 30958 | 664 |
2340522 | 2340522 | 2022-03-25 | Henry | Georgia | 13151 | 57616 | 664 |
2342351 | 2342351 | 2022-03-25 | Fayette | Pennsylvania | 42051 | 30951 | 664 |
2307892 | 2307892 | 2022-03-15 | Okaloosa | Florida | 12091 | 51180 | 664 |
2304641 | 2304641 | 2022-03-14 | Okaloosa | Florida | 12091 | 51180 | 664 |
2301249 | 2301249 | 2022-03-13 | Santa Barbara | California | 6083 | 90235 | 664 |
2301389 | 2301389 | 2022-03-13 | Okaloosa | Florida | 12091 | 51180 | 664 |
2297997 | 2297997 | 2022-03-12 | Santa Barbara | California | 6083 | 90235 | 664 |
2298137 | 2298137 | 2022-03-12 | Okaloosa | Florida | 12091 | 51180 | 664 |
2294745 | 2294745 | 2022-03-11 | Santa Barbara | California | 6083 | 90235 | 664 |
2294885 | 2294885 | 2022-03-11 | Okaloosa | Florida | 12091 | 51180 | 664 |
2291633 | 2291633 | 2022-03-10 | Okaloosa | Florida | 12091 | 51130 | 664 |
2288381 | 2288381 | 2022-03-09 | Okaloosa | Florida | 12091 | 51130 | 664 |
2287969 | 2287969 | 2022-03-08 | Racine | Wisconsin | 55101 | 55944 | 664 |
2238801 | 2238801 | 2022-02-21 | Potter | Texas | 48375 | 35141 | 664 |
2232179 | 2232179 | 2022-02-19 | Ector | Texas | 48135 | 36778 | 664 |
2196559 | 2196559 | 2022-02-08 | Taylor | Texas | 48441 | 32280 | 664 |
2196742 | 2196742 | 2022-02-08 | Prince William | Virginia | 51153 | 92536 | 664 |
2191588 | 2191588 | 2022-02-07 | Calcasieu | Louisiana | 22019 | 53342 | 664 |
2169991 | 2169991 | 2022-01-31 | Lackawanna | Pennsylvania | 42069 | 40571 | 664 |
2166737 | 2166737 | 2022-01-30 | Lackawanna | Pennsylvania | 42069 | 40455 | 664 |
2163482 | 2163482 | 2022-01-29 | Lackawanna | Pennsylvania | 42069 | 40338 | 664 |
2150331 | 2150331 | 2022-01-25 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2147079 | 2147079 | 2022-01-24 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2143825 | 2143825 | 2022-01-23 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2140570 | 2140570 | 2022-01-22 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2137314 | 2137314 | 2022-01-21 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2137439 | 2137439 | 2022-01-21 | Erie | Pennsylvania | 42049 | 51957 | 664 |
2134060 | 2134060 | 2022-01-20 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2130808 | 2130808 | 2022-01-19 | Cleveland | Oklahoma | 40027 | 63967 | 664 |
2110730 | 2110730 | 2022-01-13 | St. Louis city | Missouri | 29510 | 48068 | 664 |
2107479 | 2107479 | 2022-01-12 | St. Louis city | Missouri | 29510 | 47414 | 664 |
2086431 | 2086431 | 2022-01-06 | Tuscaloosa | Alabama | 1125 | 39371 | 664 |
2060656 | 2060656 | 2021-12-29 | Pueblo | Colorado | 8101 | 31340 | 664 |
2034764 | 2034764 | 2021-12-21 | Bibb | Georgia | 13021 | 26417 | 664 |
2015179 | 2015179 | 2021-12-15 | Sussex | Delaware | 10005 | 39562 | 664 |
2011928 | 2011928 | 2021-12-14 | Sussex | Delaware | 10005 | 39423 | 664 |
2005794 | 2005794 | 2021-12-12 | St. Clair | Illinois | 17163 | 44043 | 664 |
2002543 | 2002543 | 2021-12-11 | St. Clair | Illinois | 17163 | 44043 | 664 |
1999293 | 1999293 | 2021-12-10 | St. Clair | Illinois | 17163 | 44043 | 664 |
1996042 | 1996042 | 2021-12-09 | St. Clair | Illinois | 17163 | 43880 | 664 |
1992791 | 1992791 | 2021-12-08 | St. Clair | Illinois | 17163 | 43663 | 664 |
1973381 | 1973381 | 2021-12-02 | St. Joseph | Indiana | 18141 | 49531 | 664 |
1970131 | 1970131 | 2021-12-01 | St. Joseph | Indiana | 18141 | 49255 | 664 |
1940554 | 1940554 | 2021-11-22 | Hall | Georgia | 13139 | 39044 | 664 |
1803238 | 1803238 | 2021-10-10 | Williamson | Texas | 48491 | 73960 | 664 |
1799989 | 1799989 | 2021-10-09 | Williamson | Texas | 48491 | 73960 | 664 |
1796740 | 1796740 | 2021-10-08 | Williamson | Texas | 48491 | 73960 | 664 |
1791937 | 1791937 | 2021-10-07 | Saginaw | Michigan | 26145 | 26470 | 664 |
1788688 | 1788688 | 2021-10-06 | Saginaw | Michigan | 26145 | 26470 | 664 |
1790080 | 1790080 | 2021-10-06 | Galveston | Texas | 48167 | 62618 | 664 |
1786550 | 1786550 | 2021-10-05 | Charleston | South Carolina | 45019 | 63585 | 664 |
1770296 | 1770296 | 2021-09-30 | Anderson | South Carolina | 45007 | 34550 | 664 |
1763165 | 1763165 | 2021-09-28 | Hillsborough | New Hampshire | 33011 | 41945 | 664 |
1759916 | 1759916 | 2021-09-27 | Hillsborough | New Hampshire | 33011 | 41824 | 664 |
1735438 | 1735438 | 2021-09-20 | Montgomery | Alabama | 1101 | 32702 | 664 |
1732188 | 1732188 | 2021-09-19 | Montgomery | Alabama | 1101 | 32650 | 664 |
1728938 | 1728938 | 2021-09-18 | Montgomery | Alabama | 1101 | 32582 | 664 |
1716765 | 1716765 | 2021-09-14 | Polk | Iowa | 19153 | 65461 | 664 |
1713519 | 1713519 | 2021-09-13 | Polk | Iowa | 19153 | 65461 | 664 |
1710272 | 1710272 | 2021-09-12 | Polk | Iowa | 19153 | 65461 | 664 |
1707025 | 1707025 | 2021-09-11 | Polk | Iowa | 19153 | 65461 | 664 |
1703777 | 1703777 | 2021-09-10 | Polk | Iowa | 19153 | 65461 | 664 |
1700527 | 1700527 | 2021-09-09 | Polk | Iowa | 19153 | 65461 | 664 |
1697278 | 1697278 | 2021-09-08 | Polk | Iowa | 19153 | 65461 | 664 |
1645980 | 1645980 | 2021-08-23 | Kansas City | Missouri | 55104 | 664 | |
1642731 | 1642731 | 2021-08-22 | Kansas City | Missouri | 54900 | 664 | |
1639481 | 1639481 | 2021-08-21 | Kansas City | Missouri | 54731 | 664 | |
1601528 | 1601528 | 2021-08-09 | Knox | Tennessee | 47093 | 54722 | 664 |
1543572 | 1543572 | 2021-07-22 | Pierce | Washington | 53053 | 58525 | 664 |
1540324 | 1540324 | 2021-07-21 | Pierce | Washington | 53053 | 58383 | 664 |
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);