ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
192 rows where deaths = 569 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 22
- Michigan 18
- Texas 18
- New York 17
- New Mexico 11
- Louisiana 10
- New Jersey 9
- Washington 8
- Georgia 7
- Kentucky 7
- South Carolina 6
- Illinois 5
- Indiana 5
- Maryland 5
- Pennsylvania 5
- California 4
- Mississippi 4
- Missouri 4
- Alabama 3
- Arkansas 3
- Massachusetts 3
- New Hampshire 3
- North Carolina 3
- Virginia 3
- Colorado 2
- Arizona 1
- Delaware 1
- Idaho 1
- Kansas 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2380975 | 2380975 | 2022-04-06 | Niagara | New York | 36063 | 47904 | 569 |
2377720 | 2377720 | 2022-04-05 | Niagara | New York | 36063 | 47875 | 569 |
2374467 | 2374467 | 2022-04-04 | Niagara | New York | 36063 | 47858 | 569 |
2371215 | 2371215 | 2022-04-03 | Niagara | New York | 36063 | 47846 | 569 |
2367962 | 2367962 | 2022-04-02 | Niagara | New York | 36063 | 47826 | 569 |
2364709 | 2364709 | 2022-04-01 | Niagara | New York | 36063 | 47786 | 569 |
2361455 | 2361455 | 2022-03-31 | Niagara | New York | 36063 | 47773 | 569 |
2358201 | 2358201 | 2022-03-30 | Niagara | New York | 36063 | 47750 | 569 |
2354324 | 2354324 | 2022-03-29 | Calhoun | Michigan | 26025 | 34041 | 569 |
2354947 | 2354947 | 2022-03-29 | Niagara | New York | 36063 | 47728 | 569 |
2351072 | 2351072 | 2022-03-28 | Calhoun | Michigan | 26025 | 34041 | 569 |
2351694 | 2351694 | 2022-03-28 | Niagara | New York | 36063 | 47706 | 569 |
2347819 | 2347819 | 2022-03-27 | Calhoun | Michigan | 26025 | 34009 | 569 |
2348442 | 2348442 | 2022-03-27 | Niagara | New York | 36063 | 47687 | 569 |
2344566 | 2344566 | 2022-03-26 | Calhoun | Michigan | 26025 | 34009 | 569 |
2345189 | 2345189 | 2022-03-26 | Niagara | New York | 36063 | 47665 | 569 |
2341313 | 2341313 | 2022-03-25 | Calhoun | Michigan | 26025 | 34009 | 569 |
2341936 | 2341936 | 2022-03-25 | Niagara | New York | 36063 | 47645 | 569 |
2338060 | 2338060 | 2022-03-24 | Calhoun | Michigan | 26025 | 33986 | 569 |
2338683 | 2338683 | 2022-03-24 | Niagara | New York | 36063 | 47629 | 569 |
2334806 | 2334806 | 2022-03-23 | Calhoun | Michigan | 26025 | 33986 | 569 |
2335429 | 2335429 | 2022-03-23 | Niagara | New York | 36063 | 47603 | 569 |
2335785 | 2335785 | 2022-03-23 | Clackamas | Oregon | 41005 | 59747 | 569 |
2324826 | 2324826 | 2022-03-20 | Fayette | Kentucky | 21067 | 93846 | 569 |
2321572 | 2321572 | 2022-03-19 | Fayette | Kentucky | 21067 | 93846 | 569 |
2318318 | 2318318 | 2022-03-18 | Fayette | Kentucky | 21067 | 93846 | 569 |
2315065 | 2315065 | 2022-03-17 | Fayette | Kentucky | 21067 | 93846 | 569 |
2315191 | 2315191 | 2022-03-17 | Rapides | Louisiana | 22079 | 32673 | 569 |
2311812 | 2311812 | 2022-03-16 | Fayette | Kentucky | 21067 | 93846 | 569 |
2311938 | 2311938 | 2022-03-16 | Rapides | Louisiana | 22079 | 32664 | 569 |
2308559 | 2308559 | 2022-03-15 | Fayette | Kentucky | 21067 | 93846 | 569 |
2308685 | 2308685 | 2022-03-15 | Rapides | Louisiana | 22079 | 32663 | 569 |
2305308 | 2305308 | 2022-03-14 | Fayette | Kentucky | 21067 | 93846 | 569 |
2302302 | 2302302 | 2022-03-13 | Jackson | Michigan | 26075 | 44363 | 569 |
2299050 | 2299050 | 2022-03-12 | Jackson | Michigan | 26075 | 44363 | 569 |
2295798 | 2295798 | 2022-03-11 | Jackson | Michigan | 26075 | 44363 | 569 |
2292517 | 2292517 | 2022-03-10 | Bay | Michigan | 26017 | 26911 | 569 |
2292546 | 2292546 | 2022-03-10 | Jackson | Michigan | 26075 | 44334 | 569 |
2289229 | 2289229 | 2022-03-09 | Harford | Maryland | 24025 | 37871 | 569 |
2289265 | 2289265 | 2022-03-09 | Bay | Michigan | 26017 | 26911 | 569 |
2289294 | 2289294 | 2022-03-09 | Jackson | Michigan | 26075 | 44334 | 569 |
2285978 | 2285978 | 2022-03-08 | Harford | Maryland | 24025 | 37856 | 569 |
2283342 | 2283342 | 2022-03-07 | McKinley | New Mexico | 35031 | 25590 | 569 |
2280089 | 2280089 | 2022-03-06 | McKinley | New Mexico | 35031 | 25553 | 569 |
2276836 | 2276836 | 2022-03-05 | McKinley | New Mexico | 35031 | 25553 | 569 |
2273583 | 2273583 | 2022-03-04 | McKinley | New Mexico | 35031 | 25553 | 569 |
2270331 | 2270331 | 2022-03-03 | McKinley | New Mexico | 35031 | 25521 | 569 |
2271196 | 2271196 | 2022-03-03 | Ellis | Texas | 48139 | 48343 | 569 |
2266472 | 2266472 | 2022-03-02 | Washington | Maryland | 24043 | 34819 | 569 |
2267078 | 2267078 | 2022-03-02 | McKinley | New Mexico | 35031 | 25494 | 569 |
2263827 | 2263827 | 2022-03-01 | McKinley | New Mexico | 35031 | 25455 | 569 |
2223166 | 2223166 | 2022-02-17 | Washington | Arkansas | 5143 | 66742 | 569 |
2219759 | 2219759 | 2022-02-16 | Etowah | Alabama | 1055 | 28499 | 569 |
2219915 | 2219915 | 2022-02-16 | Washington | Arkansas | 5143 | 66638 | 569 |
2216664 | 2216664 | 2022-02-15 | Washington | Arkansas | 5143 | 66565 | 569 |
2191243 | 2191243 | 2022-02-07 | Vanderburgh | Indiana | 18163 | 55677 | 569 |
2158019 | 2158019 | 2022-01-28 | Apache | Arizona | 4001 | 20058 | 569 |
2150494 | 2150494 | 2022-01-25 | Washington | Pennsylvania | 42125 | 46752 | 569 |
2141274 | 2141274 | 2022-01-22 | Wichita | Texas | 48485 | 30042 | 569 |
2138018 | 2138018 | 2022-01-21 | Wichita | Texas | 48485 | 30042 | 569 |
2109862 | 2109862 | 2022-01-13 | Hamilton | Indiana | 18057 | 67950 | 569 |
2110411 | 2110411 | 2022-01-13 | Kalamazoo | Michigan | 26077 | 46870 | 569 |
2107160 | 2107160 | 2022-01-12 | Kalamazoo | Michigan | 26077 | 46870 | 569 |
2087809 | 2087809 | 2022-01-06 | Harrison | Mississippi | 28047 | 37914 | 569 |
2088688 | 2088688 | 2022-01-06 | Schuylkill | Pennsylvania | 42107 | 27168 | 569 |
2084557 | 2084557 | 2022-01-05 | Harrison | Mississippi | 28047 | 37544 | 569 |
2080215 | 2080215 | 2022-01-04 | Highlands | Florida | 12055 | 16972 | 569 |
2081305 | 2081305 | 2022-01-04 | Harrison | Mississippi | 28047 | 37028 | 569 |
2076963 | 2076963 | 2022-01-03 | Highlands | Florida | 12055 | 16972 | 569 |
2073712 | 2073712 | 2022-01-02 | Highlands | Florida | 12055 | 16972 | 569 |
2070461 | 2070461 | 2022-01-01 | Highlands | Florida | 12055 | 16972 | 569 |
2067210 | 2067210 | 2021-12-31 | Highlands | Florida | 12055 | 16972 | 569 |
2063959 | 2063959 | 2021-12-30 | Highlands | Florida | 12055 | 16343 | 569 |
2060709 | 2060709 | 2021-12-29 | Highlands | Florida | 12055 | 16343 | 569 |
2057460 | 2057460 | 2021-12-28 | Highlands | Florida | 12055 | 16343 | 569 |
2054211 | 2054211 | 2021-12-27 | Highlands | Florida | 12055 | 16343 | 569 |
2050961 | 2050961 | 2021-12-26 | Highlands | Florida | 12055 | 16343 | 569 |
2053305 | 2053305 | 2021-12-26 | Ector | Texas | 48135 | 27774 | 569 |
2047711 | 2047711 | 2021-12-25 | Highlands | Florida | 12055 | 16343 | 569 |
2050055 | 2050055 | 2021-12-25 | Ector | Texas | 48135 | 27774 | 569 |
2044461 | 2044461 | 2021-12-24 | Highlands | Florida | 12055 | 16343 | 569 |
2046805 | 2046805 | 2021-12-24 | Ector | Texas | 48135 | 27774 | 569 |
2041212 | 2041212 | 2021-12-23 | Highlands | Florida | 12055 | 16204 | 569 |
2043555 | 2043555 | 2021-12-23 | Ector | Texas | 48135 | 27774 | 569 |
2037962 | 2037962 | 2021-12-22 | Highlands | Florida | 12055 | 16204 | 569 |
2031420 | 2031420 | 2021-12-20 | Weld | Colorado | 8123 | 55599 | 569 |
2010179 | 2010179 | 2021-12-13 | Doña Ana | New Mexico | 35013 | 39029 | 569 |
2008173 | 2008173 | 2021-12-12 | Clark | Washington | 53011 | 46238 | 569 |
2004922 | 2004922 | 2021-12-11 | Clark | Washington | 53011 | 46238 | 569 |
2001671 | 2001671 | 2021-12-10 | Clark | Washington | 53011 | 46238 | 569 |
1997630 | 1997630 | 2021-12-09 | Butler | Pennsylvania | 42019 | 30205 | 569 |
1997645 | 1997645 | 2021-12-09 | Erie | Pennsylvania | 42049 | 37680 | 569 |
1990172 | 1990172 | 2021-12-07 | St. Clair | Michigan | 26147 | 27715 | 569 |
1986922 | 1986922 | 2021-12-06 | St. Clair | Michigan | 26147 | 27557 | 569 |
1973327 | 1973327 | 2021-12-02 | Elkhart | Indiana | 18039 | 40188 | 569 |
1970077 | 1970077 | 2021-12-01 | Elkhart | Indiana | 18039 | 39927 | 569 |
1972166 | 1972166 | 2021-12-01 | Potter | Texas | 48375 | 25099 | 569 |
1962351 | 1962351 | 2021-11-28 | Johnson | Texas | 48251 | 29246 | 569 |
1959100 | 1959100 | 2021-11-27 | Johnson | Texas | 48251 | 29246 | 569 |
1955849 | 1955849 | 2021-11-26 | Johnson | Texas | 48251 | 29246 | 569 |
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);