ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
222 rows where deaths = 519 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 27
- New York 16
- Texas 14
- Georgia 13
- Indiana 13
- South Carolina 11
- South Dakota 10
- Arizona 9
- Florida 9
- Maryland 9
- Alabama 8
- Arkansas 8
- Alaska 7
- Illinois 7
- North Carolina 7
- Ohio 6
- Minnesota 4
- New Jersey 4
- New Mexico 4
- Delaware 3
- Kansas 3
- Louisiana 3
- Massachusetts 3
- Nebraska 3
- Virginia 3
- Washington 3
- Michigan 2
- Missouri 2
- New Hampshire 2
- Oregon 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502093 | 2502093 | 2022-05-13 | Minnehaha | South Dakota | 46099 | 57428 | 519 |
2498835 | 2498835 | 2022-05-12 | Minnehaha | South Dakota | 46099 | 57428 | 519 |
2494914 | 2494914 | 2022-05-11 | Broome | New York | 36007 | 48812 | 519 |
2495577 | 2495577 | 2022-05-11 | Minnehaha | South Dakota | 46099 | 57428 | 519 |
2491656 | 2491656 | 2022-05-10 | Broome | New York | 36007 | 48673 | 519 |
2492319 | 2492319 | 2022-05-10 | Minnehaha | South Dakota | 46099 | 57297 | 519 |
2488398 | 2488398 | 2022-05-09 | Broome | New York | 36007 | 48549 | 519 |
2489061 | 2489061 | 2022-05-09 | Minnehaha | South Dakota | 46099 | 57297 | 519 |
2485141 | 2485141 | 2022-05-08 | Broome | New York | 36007 | 48509 | 519 |
2485804 | 2485804 | 2022-05-08 | Minnehaha | South Dakota | 46099 | 57297 | 519 |
2481883 | 2481883 | 2022-05-07 | Broome | New York | 36007 | 48437 | 519 |
2482546 | 2482546 | 2022-05-07 | Minnehaha | South Dakota | 46099 | 57297 | 519 |
2479288 | 2479288 | 2022-05-06 | Minnehaha | South Dakota | 46099 | 57297 | 519 |
2476030 | 2476030 | 2022-05-05 | Minnehaha | South Dakota | 46099 | 57297 | 519 |
2472773 | 2472773 | 2022-05-04 | Minnehaha | South Dakota | 46099 | 57297 | 519 |
2444277 | 2444277 | 2022-04-26 | Anchorage | Alaska | 2020 | 103601 | 519 |
2441021 | 2441021 | 2022-04-25 | Anchorage | Alaska | 2020 | 103601 | 519 |
2437765 | 2437765 | 2022-04-24 | Anchorage | Alaska | 2020 | 103601 | 519 |
2434509 | 2434509 | 2022-04-23 | Anchorage | Alaska | 2020 | 103601 | 519 |
2436756 | 2436756 | 2022-04-23 | Monroe | Pennsylvania | 42089 | 37264 | 519 |
2431253 | 2431253 | 2022-04-22 | Anchorage | Alaska | 2020 | 103601 | 519 |
2433500 | 2433500 | 2022-04-22 | Monroe | Pennsylvania | 42089 | 37238 | 519 |
2427997 | 2427997 | 2022-04-21 | Anchorage | Alaska | 2020 | 103601 | 519 |
2430244 | 2430244 | 2022-04-21 | Monroe | Pennsylvania | 42089 | 37208 | 519 |
2424741 | 2424741 | 2022-04-20 | Anchorage | Alaska | 2020 | 103601 | 519 |
2426988 | 2426988 | 2022-04-20 | Monroe | Pennsylvania | 42089 | 37169 | 519 |
2421863 | 2421863 | 2022-04-19 | Floyd | Georgia | 13115 | 27325 | 519 |
2422632 | 2422632 | 2022-04-19 | Frederick | Maryland | 24021 | 45883 | 519 |
2423732 | 2423732 | 2022-04-19 | Monroe | Pennsylvania | 42089 | 37162 | 519 |
2418607 | 2418607 | 2022-04-18 | Floyd | Georgia | 13115 | 27325 | 519 |
2419376 | 2419376 | 2022-04-18 | Frederick | Maryland | 24021 | 45814 | 519 |
2420476 | 2420476 | 2022-04-18 | Monroe | Pennsylvania | 42089 | 37137 | 519 |
2415351 | 2415351 | 2022-04-17 | Floyd | Georgia | 13115 | 27328 | 519 |
2416120 | 2416120 | 2022-04-17 | Frederick | Maryland | 24021 | 45780 | 519 |
2417220 | 2417220 | 2022-04-17 | Monroe | Pennsylvania | 42089 | 37126 | 519 |
2412095 | 2412095 | 2022-04-16 | Floyd | Georgia | 13115 | 27328 | 519 |
2412864 | 2412864 | 2022-04-16 | Frederick | Maryland | 24021 | 45780 | 519 |
2413964 | 2413964 | 2022-04-16 | Monroe | Pennsylvania | 42089 | 37112 | 519 |
2408839 | 2408839 | 2022-04-15 | Floyd | Georgia | 13115 | 27328 | 519 |
2409608 | 2409608 | 2022-04-15 | Frederick | Maryland | 24021 | 45780 | 519 |
2405583 | 2405583 | 2022-04-14 | Floyd | Georgia | 13115 | 27318 | 519 |
2392797 | 2392797 | 2022-04-10 | Rock Island | Illinois | 17161 | 33099 | 519 |
2389541 | 2389541 | 2022-04-09 | Rock Island | Illinois | 17161 | 33099 | 519 |
2386286 | 2386286 | 2022-04-08 | Rock Island | Illinois | 17161 | 33099 | 519 |
2384598 | 2384598 | 2022-04-07 | Jackson | Oregon | 41029 | 42673 | 519 |
2380854 | 2380854 | 2022-04-06 | Unknown | Nebraska | 2859 | 519 | |
2376015 | 2376015 | 2022-04-05 | Sebastian | Arkansas | 5131 | 32681 | 519 |
2377599 | 2377599 | 2022-04-05 | Unknown | Nebraska | 2799 | 519 | |
2372763 | 2372763 | 2022-04-04 | Sebastian | Arkansas | 5131 | 32678 | 519 |
2369510 | 2369510 | 2022-04-03 | Sebastian | Arkansas | 5131 | 32677 | 519 |
2366257 | 2366257 | 2022-04-02 | Sebastian | Arkansas | 5131 | 32675 | 519 |
2363004 | 2363004 | 2022-04-01 | Sebastian | Arkansas | 5131 | 32674 | 519 |
2359750 | 2359750 | 2022-03-31 | Sebastian | Arkansas | 5131 | 32671 | 519 |
2289997 | 2289997 | 2022-03-09 | Robeson | North Carolina | 37155 | 40291 | 519 |
2287026 | 2287026 | 2022-03-08 | Washington | Oregon | 41067 | 84518 | 519 |
2279656 | 2279656 | 2022-03-06 | St. Louis | Minnesota | 27137 | 46034 | 519 |
2276403 | 2276403 | 2022-03-05 | St. Louis | Minnesota | 27137 | 46034 | 519 |
2273150 | 2273150 | 2022-03-04 | St. Louis | Minnesota | 27137 | 46034 | 519 |
2261059 | 2261059 | 2022-02-28 | Northumberland | Pennsylvania | 42097 | 22622 | 519 |
2257808 | 2257808 | 2022-02-27 | Northumberland | Pennsylvania | 42097 | 22616 | 519 |
2254557 | 2254557 | 2022-02-26 | Northumberland | Pennsylvania | 42097 | 22609 | 519 |
2222404 | 2222404 | 2022-02-16 | Comal | Texas | 48091 | 31454 | 519 |
2202143 | 2202143 | 2022-02-10 | Catawba | North Carolina | 37035 | 45997 | 519 |
2198889 | 2198889 | 2022-02-09 | Catawba | North Carolina | 37035 | 45849 | 519 |
2192389 | 2192389 | 2022-02-07 | Cumberland | North Carolina | 37051 | 78446 | 519 |
2184047 | 2184047 | 2022-02-05 | Cochise | Arizona | 4003 | 29216 | 519 |
2171710 | 2171710 | 2022-02-01 | Porter | Indiana | 18127 | 35945 | 519 |
2159140 | 2159140 | 2022-01-28 | Harford | Maryland | 24025 | 35789 | 519 |
2152643 | 2152643 | 2022-01-26 | Washington | Maryland | 24043 | 32169 | 519 |
2133880 | 2133880 | 2022-01-20 | Rowan | North Carolina | 37159 | 34939 | 519 |
2112699 | 2112699 | 2022-01-14 | Kent | Delaware | 10001 | 41752 | 519 |
2086553 | 2086553 | 2022-01-06 | Washington | Arkansas | 5143 | 49949 | 519 |
2081664 | 2081664 | 2022-01-04 | Cumberland | New Jersey | 34011 | 27036 | 519 |
2082194 | 2082194 | 2022-01-04 | Washington | Pennsylvania | 42125 | 36720 | 519 |
2074115 | 2074115 | 2022-01-02 | Madison | Indiana | 18095 | 23854 | 519 |
2070864 | 2070864 | 2022-01-01 | Madison | Indiana | 18095 | 23854 | 519 |
2067613 | 2067613 | 2021-12-31 | Madison | Indiana | 18095 | 23854 | 519 |
2064362 | 2064362 | 2021-12-30 | Madison | Indiana | 18095 | 23854 | 519 |
2058415 | 2058415 | 2021-12-28 | Muskegon | Michigan | 26121 | 31219 | 519 |
2055166 | 2055166 | 2021-12-27 | Muskegon | Michigan | 26121 | 31219 | 519 |
2020215 | 2020215 | 2021-12-16 | Lake | Ohio | 39085 | 34809 | 519 |
2016964 | 2016964 | 2021-12-15 | Lake | Ohio | 39085 | 34513 | 519 |
2013714 | 2013714 | 2021-12-14 | Lake | Ohio | 39085 | 34279 | 519 |
2011074 | 2011074 | 2021-12-13 | Grayson | Texas | 48181 | 16730 | 519 |
2005839 | 2005839 | 2021-12-12 | Hamilton | Indiana | 18057 | 52750 | 519 |
2006967 | 2006967 | 2021-12-12 | Dutchess | New York | 36027 | 39719 | 519 |
2007823 | 2007823 | 2021-12-12 | Grayson | Texas | 48181 | 16720 | 519 |
2002588 | 2002588 | 2021-12-11 | Hamilton | Indiana | 18057 | 52750 | 519 |
2004572 | 2004572 | 2021-12-11 | Grayson | Texas | 48181 | 16714 | 519 |
1999338 | 1999338 | 2021-12-10 | Hamilton | Indiana | 18057 | 52750 | 519 |
2000924 | 2000924 | 2021-12-10 | Schuylkill | Pennsylvania | 42107 | 23753 | 519 |
2001321 | 2001321 | 2021-12-10 | Grayson | Texas | 48181 | 16698 | 519 |
1996087 | 1996087 | 2021-12-09 | Hamilton | Indiana | 18057 | 52515 | 519 |
1992836 | 1992836 | 2021-12-08 | Hamilton | Indiana | 18057 | 52211 | 519 |
1975859 | 1975859 | 2021-12-03 | Calhoun | Alabama | 1015 | 22622 | 519 |
1972610 | 1972610 | 2021-12-02 | Calhoun | Alabama | 1015 | 22620 | 519 |
1969360 | 1969360 | 2021-12-01 | Calhoun | Alabama | 1015 | 22610 | 519 |
1965121 | 1965121 | 2021-11-29 | Beaver | Pennsylvania | 42007 | 25798 | 519 |
1961869 | 1961869 | 2021-11-28 | Beaver | Pennsylvania | 42007 | 25631 | 519 |
1958618 | 1958618 | 2021-11-27 | Beaver | Pennsylvania | 42007 | 25599 | 519 |
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);