ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
246 rows where deaths = 528 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Louisiana 31
- Texas 26
- Florida 20
- Pennsylvania 19
- Colorado 18
- Georgia 12
- California 11
- South Carolina 11
- New York 9
- Arizona 8
- Indiana 8
- Alabama 7
- Massachusetts 7
- Michigan 7
- Ohio 7
- New Jersey 6
- Illinois 5
- Maryland 5
- Minnesota 4
- Mississippi 4
- Missouri 4
- North Carolina 4
- Oregon 3
- New Mexico 2
- Virginia 2
- Wisconsin 2
- Arkansas 1
- Idaho 1
- Kentucky 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426922 | 2426922 | 2022-04-20 | Jackson | Oregon | 41029 | 42870 | 528 |
2423666 | 2423666 | 2022-04-19 | Jackson | Oregon | 41029 | 42844 | 528 |
2406537 | 2406537 | 2022-04-14 | St. Louis | Minnesota | 27137 | 47091 | 528 |
2403281 | 2403281 | 2022-04-13 | St. Louis | Minnesota | 27137 | 47072 | 528 |
2400027 | 2400027 | 2022-04-12 | St. Louis | Minnesota | 27137 | 47039 | 528 |
2339121 | 2339121 | 2022-03-24 | Northumberland | Pennsylvania | 42097 | 22761 | 528 |
2324075 | 2324075 | 2022-03-20 | Mesa | Colorado | 8077 | 41789 | 528 |
2320821 | 2320821 | 2022-03-19 | Mesa | Colorado | 8077 | 41789 | 528 |
2317567 | 2317567 | 2022-03-18 | Mesa | Colorado | 8077 | 41789 | 528 |
2314314 | 2314314 | 2022-03-17 | Mesa | Colorado | 8077 | 41789 | 528 |
2311061 | 2311061 | 2022-03-16 | Mesa | Colorado | 8077 | 41763 | 528 |
2313534 | 2313534 | 2022-03-16 | Kaufman | Texas | 48257 | 35079 | 528 |
2307808 | 2307808 | 2022-03-15 | Mesa | Colorado | 8077 | 41715 | 528 |
2304557 | 2304557 | 2022-03-14 | Mesa | Colorado | 8077 | 41688 | 528 |
2301305 | 2301305 | 2022-03-13 | Mesa | Colorado | 8077 | 41656 | 528 |
2298053 | 2298053 | 2022-03-12 | Mesa | Colorado | 8077 | 41656 | 528 |
2294801 | 2294801 | 2022-03-11 | Mesa | Colorado | 8077 | 41656 | 528 |
2291549 | 2291549 | 2022-03-10 | Mesa | Colorado | 8077 | 41626 | 528 |
2288297 | 2288297 | 2022-03-09 | Mesa | Colorado | 8077 | 41586 | 528 |
2285046 | 2285046 | 2022-03-08 | Mesa | Colorado | 8077 | 41546 | 528 |
2281794 | 2281794 | 2022-03-07 | Mesa | Colorado | 8077 | 41523 | 528 |
2269753 | 2269753 | 2022-03-03 | Berrien | Michigan | 26021 | 34393 | 528 |
2266500 | 2266500 | 2022-03-02 | Berrien | Michigan | 26021 | 34393 | 528 |
2237419 | 2237419 | 2022-02-21 | DeSoto | Mississippi | 28033 | 49549 | 528 |
2234168 | 2234168 | 2022-02-20 | DeSoto | Mississippi | 28033 | 49549 | 528 |
2230917 | 2230917 | 2022-02-19 | DeSoto | Mississippi | 28033 | 49549 | 528 |
2227666 | 2227666 | 2022-02-18 | DeSoto | Mississippi | 28033 | 49549 | 528 |
2220468 | 2220468 | 2022-02-16 | Hendricks | Indiana | 18063 | 40362 | 528 |
2221663 | 2221663 | 2022-02-16 | Cumberland | North Carolina | 37051 | 80416 | 528 |
2218397 | 2218397 | 2022-02-15 | Buncombe | North Carolina | 37021 | 48751 | 528 |
2206822 | 2206822 | 2022-02-12 | Cochise | Arizona | 4003 | 30174 | 528 |
2201254 | 2201254 | 2022-02-10 | Fayette | Kentucky | 21067 | 88938 | 528 |
2198126 | 2198126 | 2022-02-09 | Rapides | Louisiana | 22079 | 32056 | 528 |
2174613 | 2174613 | 2022-02-02 | Cherokee | Georgia | 13057 | 61334 | 528 |
2174780 | 2174780 | 2022-02-02 | Kootenai | Idaho | 16055 | 36429 | 528 |
2172158 | 2172158 | 2022-02-01 | Harford | Maryland | 24025 | 36086 | 528 |
2172168 | 2172168 | 2022-02-01 | Washington | Maryland | 24043 | 32788 | 528 |
2128825 | 2128825 | 2022-01-19 | Washington | Arkansas | 5143 | 58500 | 528 |
2086396 | 2086396 | 2022-01-06 | Etowah | Alabama | 1055 | 21360 | 528 |
2074667 | 2074667 | 2022-01-02 | Muskegon | Michigan | 26121 | 31612 | 528 |
2071416 | 2071416 | 2022-01-01 | Muskegon | Michigan | 26121 | 31612 | 528 |
2068165 | 2068165 | 2021-12-31 | Muskegon | Michigan | 26121 | 31612 | 528 |
2064914 | 2064914 | 2021-12-30 | Muskegon | Michigan | 26121 | 31612 | 528 |
2061664 | 2061664 | 2021-12-29 | Muskegon | Michigan | 26121 | 31612 | 528 |
2052472 | 2052472 | 2021-12-26 | Dutchess | New York | 36027 | 42998 | 528 |
2049222 | 2049222 | 2021-12-25 | Dutchess | New York | 36027 | 42431 | 528 |
2045972 | 2045972 | 2021-12-24 | Dutchess | New York | 36027 | 42431 | 528 |
2039906 | 2039906 | 2021-12-22 | Franklin | Pennsylvania | 42055 | 27620 | 528 |
2034721 | 2034721 | 2021-12-21 | Leon | Florida | 12073 | 51493 | 528 |
2031471 | 2031471 | 2021-12-20 | Leon | Florida | 12073 | 51493 | 528 |
2028220 | 2028220 | 2021-12-19 | Leon | Florida | 12073 | 51493 | 528 |
2024969 | 2024969 | 2021-12-18 | Leon | Florida | 12073 | 51493 | 528 |
2021718 | 2021718 | 2021-12-17 | Leon | Florida | 12073 | 51493 | 528 |
2018467 | 2018467 | 2021-12-16 | Leon | Florida | 12073 | 51313 | 528 |
2015217 | 2015217 | 2021-12-15 | Leon | Florida | 12073 | 51313 | 528 |
2011704 | 2011704 | 2021-12-14 | Apache | Arizona | 4001 | 15784 | 528 |
2011966 | 2011966 | 2021-12-14 | Leon | Florida | 12073 | 51313 | 528 |
2010611 | 2010611 | 2021-12-13 | Marion | Oregon | 41047 | 40702 | 528 |
1968566 | 1968566 | 2021-11-30 | York | South Carolina | 45091 | 48219 | 528 |
1963158 | 1963158 | 2021-11-29 | Weld | Colorado | 8123 | 52711 | 528 |
1964080 | 1964080 | 2021-11-29 | Barnstable | Massachusetts | 25001 | 19650 | 528 |
1965315 | 1965315 | 2021-11-29 | York | South Carolina | 45091 | 48178 | 528 |
1960829 | 1960829 | 2021-11-28 | Barnstable | Massachusetts | 25001 | 19460 | 528 |
1962063 | 1962063 | 2021-11-28 | York | South Carolina | 45091 | 47997 | 528 |
1957578 | 1957578 | 2021-11-27 | Barnstable | Massachusetts | 25001 | 19460 | 528 |
1958812 | 1958812 | 2021-11-27 | York | South Carolina | 45091 | 47997 | 528 |
1954327 | 1954327 | 2021-11-26 | Barnstable | Massachusetts | 25001 | 19460 | 528 |
1955561 | 1955561 | 2021-11-26 | York | South Carolina | 45091 | 47997 | 528 |
1951076 | 1951076 | 2021-11-25 | Barnstable | Massachusetts | 25001 | 19273 | 528 |
1947825 | 1947825 | 2021-11-24 | Barnstable | Massachusetts | 25001 | 19273 | 528 |
1929961 | 1929961 | 2021-11-18 | Wichita | Texas | 48485 | 22168 | 528 |
1926711 | 1926711 | 2021-11-17 | Wichita | Texas | 48485 | 22168 | 528 |
1922868 | 1922868 | 2021-11-16 | Butler | Pennsylvania | 42019 | 27114 | 528 |
1876428 | 1876428 | 2021-11-02 | Anoka | Minnesota | 27003 | 56299 | 528 |
1868829 | 1868829 | 2021-10-31 | Santa Barbara | California | 6083 | 45650 | 528 |
1865580 | 1865580 | 2021-10-30 | Santa Barbara | California | 6083 | 45650 | 528 |
1862331 | 1862331 | 2021-10-29 | Santa Barbara | California | 6083 | 45650 | 528 |
1858297 | 1858297 | 2021-10-27 | Ector | Texas | 48135 | 25675 | 528 |
1836832 | 1836832 | 2021-10-21 | Elkhart | Indiana | 18039 | 35992 | 528 |
1838545 | 1838545 | 2021-10-21 | Florence | South Carolina | 45041 | 26497 | 528 |
1838858 | 1838858 | 2021-10-21 | Johnson | Texas | 48251 | 28085 | 528 |
1832326 | 1832326 | 2021-10-19 | Gregg | Texas | 48183 | 19123 | 528 |
1832660 | 1832660 | 2021-10-19 | Virginia Beach city | Virginia | 51810 | 49205 | 528 |
1829077 | 1829077 | 2021-10-18 | Gregg | Texas | 48183 | 19096 | 528 |
1823464 | 1823464 | 2021-10-17 | Indian River | Florida | 12061 | 22036 | 528 |
1825828 | 1825828 | 2021-10-17 | Gregg | Texas | 48183 | 19096 | 528 |
1820215 | 1820215 | 2021-10-16 | Indian River | Florida | 12061 | 22036 | 528 |
1816966 | 1816966 | 2021-10-15 | Indian River | Florida | 12061 | 22036 | 528 |
1808690 | 1808690 | 2021-10-12 | Doña Ana | New Mexico | 35013 | 29364 | 528 |
1790622 | 1790622 | 2021-10-07 | Baldwin | Alabama | 1003 | 36780 | 528 |
1783014 | 1783014 | 2021-10-04 | Trumbull | Ohio | 39155 | 21238 | 528 |
1779765 | 1779765 | 2021-10-03 | Trumbull | Ohio | 39155 | 21148 | 528 |
1776515 | 1776515 | 2021-10-02 | Trumbull | Ohio | 39155 | 21079 | 528 |
1773265 | 1773265 | 2021-10-01 | Trumbull | Ohio | 39155 | 20945 | 528 |
1747948 | 1747948 | 2021-09-23 | Potter | Texas | 48375 | 22194 | 528 |
1740475 | 1740475 | 2021-09-21 | San Juan | New Mexico | 35045 | 17925 | 528 |
1740578 | 1740578 | 2021-09-21 | Gaston | North Carolina | 37071 | 36236 | 528 |
1737329 | 1737329 | 2021-09-20 | Gaston | North Carolina | 37071 | 36056 | 528 |
1720298 | 1720298 | 2021-09-15 | Ouachita | Louisiana | 22073 | 29166 | 528 |
1708029 | 1708029 | 2021-09-11 | Oneida | New York | 36065 | 24830 | 528 |
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);