ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where deaths = 600 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- California 14
- New Jersey 12
- Ohio 12
- North Carolina 11
- Indiana 9
- Alabama 8
- Arizona 7
- Florida 7
- Missouri 7
- Washington 7
- Louisiana 6
- Pennsylvania 6
- Connecticut 5
- Arkansas 4
- New York 4
- Virginia 4
- Colorado 3
- Georgia 3
- Illinois 3
- Oregon 3
- Tennessee 3
- Maryland 2
- Michigan 2
- Nevada 2
- District of Columbia 1
- Kansas 1
- Massachusetts 1
- Mississippi 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501503 | 2501503 | 2022-05-13 | Catawba | North Carolina | 37035 | 47959 | 600 |
2498245 | 2498245 | 2022-05-12 | Catawba | North Carolina | 37035 | 47959 | 600 |
2494987 | 2494987 | 2022-05-11 | Catawba | North Carolina | 37035 | 47959 | 600 |
2491729 | 2491729 | 2022-05-10 | Catawba | North Carolina | 37035 | 47793 | 600 |
2488471 | 2488471 | 2022-05-09 | Catawba | North Carolina | 37035 | 47793 | 600 |
2485214 | 2485214 | 2022-05-08 | Catawba | North Carolina | 37035 | 47793 | 600 |
2481956 | 2481956 | 2022-05-07 | Catawba | North Carolina | 37035 | 47793 | 600 |
2478698 | 2478698 | 2022-05-06 | Catawba | North Carolina | 37035 | 47793 | 600 |
2475440 | 2475440 | 2022-05-05 | Catawba | North Carolina | 37035 | 47793 | 600 |
2472183 | 2472183 | 2022-05-04 | Catawba | North Carolina | 37035 | 47793 | 600 |
2439498 | 2439498 | 2022-04-24 | Cumberland | New Jersey | 34011 | 39744 | 600 |
2436242 | 2436242 | 2022-04-23 | Cumberland | New Jersey | 34011 | 39735 | 600 |
2327462 | 2327462 | 2022-03-21 | Cherokee | Georgia | 13057 | 63036 | 600 |
2307707 | 2307707 | 2022-03-15 | Washington | Arkansas | 5143 | 67716 | 600 |
2304456 | 2304456 | 2022-03-14 | Washington | Arkansas | 5143 | 67698 | 600 |
2301204 | 2301204 | 2022-03-13 | Washington | Arkansas | 5143 | 67685 | 600 |
2293539 | 2293539 | 2022-03-10 | Blair | Pennsylvania | 42013 | 29499 | 600 |
2290287 | 2290287 | 2022-03-09 | Blair | Pennsylvania | 42013 | 29485 | 600 |
2285507 | 2285507 | 2022-03-08 | Johnson | Indiana | 18081 | 42234 | 600 |
2282255 | 2282255 | 2022-03-07 | Johnson | Indiana | 18081 | 42223 | 600 |
2265272 | 2265272 | 2022-03-02 | Etowah | Alabama | 1055 | 28687 | 600 |
2266793 | 2266793 | 2022-03-02 | Jefferson | Missouri | 29099 | 53653 | 600 |
2263542 | 2263542 | 2022-03-01 | Jefferson | Missouri | 29099 | 53635 | 600 |
2246526 | 2246526 | 2022-02-24 | Vanderburgh | Indiana | 18163 | 56920 | 600 |
2245206 | 2245206 | 2022-02-23 | Grayson | Texas | 48181 | 26946 | 600 |
2241955 | 2241955 | 2022-02-22 | Grayson | Texas | 48181 | 26944 | 600 |
2226168 | 2226168 | 2022-02-17 | Kenosha | Wisconsin | 55059 | 43424 | 600 |
2194025 | 2194025 | 2022-02-08 | New London | Connecticut | 9011 | 52274 | 600 |
2190771 | 2190771 | 2022-02-07 | New London | Connecticut | 9011 | 52125 | 600 |
2193327 | 2193327 | 2022-02-07 | Wichita | Texas | 48485 | 32709 | 600 |
2187518 | 2187518 | 2022-02-06 | New London | Connecticut | 9011 | 51909 | 600 |
2189458 | 2189458 | 2022-02-06 | Marion | Oregon | 41047 | 64738 | 600 |
2190074 | 2190074 | 2022-02-06 | Wichita | Texas | 48485 | 32084 | 600 |
2184265 | 2184265 | 2022-02-05 | New London | Connecticut | 9011 | 51909 | 600 |
2186205 | 2186205 | 2022-02-05 | Marion | Oregon | 41047 | 64738 | 600 |
2186821 | 2186821 | 2022-02-05 | Wichita | Texas | 48485 | 32084 | 600 |
2181013 | 2181013 | 2022-02-04 | New London | Connecticut | 9011 | 51909 | 600 |
2182953 | 2182953 | 2022-02-04 | Marion | Oregon | 41047 | 64738 | 600 |
2183568 | 2183568 | 2022-02-04 | Wichita | Texas | 48485 | 32084 | 600 |
2178886 | 2178886 | 2022-02-03 | Harrison | Mississippi | 28047 | 48647 | 600 |
2180316 | 2180316 | 2022-02-03 | Wichita | Texas | 48485 | 32084 | 600 |
2174928 | 2174928 | 2022-02-02 | Hamilton | Indiana | 18057 | 79037 | 600 |
2171675 | 2171675 | 2022-02-01 | Hamilton | Indiana | 18057 | 78820 | 600 |
2154898 | 2154898 | 2022-01-27 | Santa Barbara | California | 6083 | 79395 | 600 |
2149394 | 2149394 | 2022-01-25 | Barnstable | Massachusetts | 25001 | 32099 | 600 |
2099683 | 2099683 | 2022-01-10 | Weld | Colorado | 8123 | 63891 | 600 |
2043815 | 2043815 | 2021-12-23 | Chesterfield | Virginia | 51041 | 44421 | 600 |
2039888 | 2039888 | 2021-12-22 | Butler | Pennsylvania | 42019 | 31478 | 600 |
2012921 | 2012921 | 2021-12-14 | Ottawa | Michigan | 26139 | 53029 | 600 |
2009670 | 2009670 | 2021-12-13 | Ottawa | Michigan | 26139 | 53029 | 600 |
1970511 | 1970511 | 2021-12-01 | Ouachita | Louisiana | 22073 | 32240 | 600 |
1907444 | 1907444 | 2021-11-11 | Yakima | Washington | 53077 | 45911 | 600 |
1904195 | 1904195 | 2021-11-10 | Yakima | Washington | 53077 | 45911 | 600 |
1900945 | 1900945 | 2021-11-09 | Yakima | Washington | 53077 | 45819 | 600 |
1883705 | 1883705 | 2021-11-04 | Lorain | Ohio | 39093 | 36841 | 600 |
1880456 | 1880456 | 2021-11-03 | Lorain | Ohio | 39093 | 36686 | 600 |
1877207 | 1877207 | 2021-11-02 | Lorain | Ohio | 39093 | 36549 | 600 |
1872063 | 1872063 | 2021-11-01 | Monterey | California | 6053 | 51283 | 600 |
1873958 | 1873958 | 2021-11-01 | Lorain | Ohio | 39093 | 36469 | 600 |
1868814 | 1868814 | 2021-10-31 | Monterey | California | 6053 | 51188 | 600 |
1870709 | 1870709 | 2021-10-31 | Lorain | Ohio | 39093 | 36386 | 600 |
1865565 | 1865565 | 2021-10-30 | Monterey | California | 6053 | 51188 | 600 |
1867460 | 1867460 | 2021-10-30 | Lorain | Ohio | 39093 | 36286 | 600 |
1862316 | 1862316 | 2021-10-29 | Monterey | California | 6053 | 51188 | 600 |
1864211 | 1864211 | 2021-10-29 | Lorain | Ohio | 39093 | 36219 | 600 |
1845971 | 1845971 | 2021-10-24 | Benton | Arkansas | 5007 | 41951 | 600 |
1834460 | 1834460 | 2021-10-20 | St. Louis city | Missouri | 29510 | 32251 | 600 |
1831211 | 1831211 | 2021-10-19 | St. Louis city | Missouri | 29510 | 32218 | 600 |
1831895 | 1831895 | 2021-10-19 | Cumberland | Pennsylvania | 42041 | 27399 | 600 |
1827962 | 1827962 | 2021-10-18 | St. Louis city | Missouri | 29510 | 32184 | 600 |
1824713 | 1824713 | 2021-10-17 | St. Louis city | Missouri | 29510 | 32163 | 600 |
1793975 | 1793975 | 2021-10-08 | Navajo | Arizona | 4017 | 20079 | 600 |
1767981 | 1767981 | 2021-09-30 | Navajo | Arizona | 4017 | 19704 | 600 |
1739148 | 1739148 | 2021-09-21 | Richmond | Georgia | 13245 | 33116 | 600 |
1738224 | 1738224 | 2021-09-20 | Smith | Texas | 48423 | 32559 | 600 |
1738258 | 1738258 | 2021-09-20 | Williamson | Texas | 48491 | 69994 | 600 |
1734974 | 1734974 | 2021-09-19 | Smith | Texas | 48423 | 32559 | 600 |
1735008 | 1735008 | 2021-09-19 | Williamson | Texas | 48491 | 69496 | 600 |
1722810 | 1722810 | 2021-09-16 | Clayton | Georgia | 13063 | 35899 | 600 |
1716580 | 1716580 | 2021-09-14 | St. Clair | Illinois | 17163 | 38221 | 600 |
1710177 | 1710177 | 2021-09-12 | St. Joseph | Indiana | 18141 | 40632 | 600 |
1706930 | 1706930 | 2021-09-11 | St. Joseph | Indiana | 18141 | 40632 | 600 |
1703682 | 1703682 | 2021-09-10 | St. Joseph | Indiana | 18141 | 40632 | 600 |
1699881 | 1699881 | 2021-09-09 | San Mateo | California | 6081 | 51155 | 600 |
1700432 | 1700432 | 2021-09-09 | St. Joseph | Indiana | 18141 | 40483 | 600 |
1696632 | 1696632 | 2021-09-08 | San Mateo | California | 6081 | 50940 | 600 |
1693384 | 1693384 | 2021-09-07 | San Mateo | California | 6081 | 50886 | 600 |
1690135 | 1690135 | 2021-09-06 | San Mateo | California | 6081 | 50836 | 600 |
1686885 | 1686885 | 2021-09-05 | San Mateo | California | 6081 | 50748 | 600 |
1683635 | 1683635 | 2021-09-04 | San Mateo | California | 6081 | 50644 | 600 |
1680384 | 1680384 | 2021-09-03 | San Mateo | California | 6081 | 50517 | 600 |
1652101 | 1652101 | 2021-08-25 | St. Tammany | Louisiana | 22103 | 39229 | 600 |
1538834 | 1538834 | 2021-07-21 | St. Charles | Missouri | 29183 | 49615 | 600 |
1465655 | 1465655 | 2021-06-28 | Snohomish | Washington | 53061 | 40136 | 600 |
1462410 | 1462410 | 2021-06-27 | Snohomish | Washington | 53061 | 40069 | 600 |
1459165 | 1459165 | 2021-06-26 | Snohomish | Washington | 53061 | 40069 | 600 |
1455920 | 1455920 | 2021-06-25 | Snohomish | Washington | 53061 | 40026 | 600 |
1445888 | 1445888 | 2021-06-22 | Montgomery | Texas | 48339 | 55348 | 600 |
1442643 | 1442643 | 2021-06-21 | Montgomery | Texas | 48339 | 55262 | 600 |
1439398 | 1439398 | 2021-06-20 | Montgomery | Texas | 48339 | 55262 | 600 |
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);