ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
206 rows where deaths = 672 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Florida 40
- Texas 18
- Pennsylvania 14
- Georgia 13
- Michigan 12
- South Carolina 10
- Ohio 9
- California 8
- Maryland 8
- Missouri 8
- Arkansas 7
- Iowa 7
- New York 7
- North Carolina 6
- Washington 6
- Colorado 5
- Louisiana 4
- Massachusetts 4
- Alabama 3
- Arizona 3
- Nebraska 3
- New Jersey 3
- Tennessee 2
- District of Columbia 1
- Idaho 1
- Illinois 1
- Minnesota 1
- New Hampshire 1
- Oklahoma 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466212 | 2466212 | 2022-05-02 | York | South Carolina | 45091 | 77793 | 672 |
2462957 | 2462957 | 2022-05-01 | York | South Carolina | 45091 | 77793 | 672 |
2459701 | 2459701 | 2022-04-30 | York | South Carolina | 45091 | 77793 | 672 |
2456445 | 2456445 | 2022-04-29 | York | South Carolina | 45091 | 77793 | 672 |
2453189 | 2453189 | 2022-04-28 | York | South Carolina | 45091 | 77793 | 672 |
2422700 | 2422700 | 2022-04-19 | Kalamazoo | Michigan | 26077 | 59282 | 672 |
2419444 | 2419444 | 2022-04-18 | Kalamazoo | Michigan | 26077 | 59282 | 672 |
2416188 | 2416188 | 2022-04-17 | Kalamazoo | Michigan | 26077 | 59282 | 672 |
2412932 | 2412932 | 2022-04-16 | Kalamazoo | Michigan | 26077 | 59282 | 672 |
2409676 | 2409676 | 2022-04-15 | Kalamazoo | Michigan | 26077 | 59282 | 672 |
2406420 | 2406420 | 2022-04-14 | Kalamazoo | Michigan | 26077 | 59282 | 672 |
2403164 | 2403164 | 2022-04-13 | Kalamazoo | Michigan | 26077 | 59282 | 672 |
2388477 | 2388477 | 2022-04-08 | Wichita | Texas | 48485 | 33997 | 672 |
2385222 | 2385222 | 2022-04-07 | Wichita | Texas | 48485 | 33990 | 672 |
2381967 | 2381967 | 2022-04-06 | Wichita | Texas | 48485 | 33990 | 672 |
2378712 | 2378712 | 2022-04-05 | Wichita | Texas | 48485 | 33990 | 672 |
2375458 | 2375458 | 2022-04-04 | Wichita | Texas | 48485 | 33990 | 672 |
2372206 | 2372206 | 2022-04-03 | Wichita | Texas | 48485 | 33982 | 672 |
2365151 | 2365151 | 2022-04-01 | Schuylkill | Pennsylvania | 42107 | 34384 | 672 |
2365700 | 2365700 | 2022-04-01 | Wichita | Texas | 48485 | 33982 | 672 |
2361898 | 2361898 | 2022-03-31 | Schuylkill | Pennsylvania | 42107 | 34382 | 672 |
2362447 | 2362447 | 2022-03-31 | Wichita | Texas | 48485 | 33982 | 672 |
2358644 | 2358644 | 2022-03-30 | Schuylkill | Pennsylvania | 42107 | 34378 | 672 |
2359193 | 2359193 | 2022-03-30 | Wichita | Texas | 48485 | 33982 | 672 |
2355390 | 2355390 | 2022-03-29 | Schuylkill | Pennsylvania | 42107 | 34373 | 672 |
2333778 | 2333778 | 2022-03-23 | Santa Barbara | California | 6083 | 90273 | 672 |
2330524 | 2330524 | 2022-03-22 | Santa Barbara | California | 6083 | 90232 | 672 |
2327045 | 2327045 | 2022-03-21 | Baldwin | Alabama | 1003 | 55353 | 672 |
2327272 | 2327272 | 2022-03-21 | Santa Barbara | California | 6083 | 90228 | 672 |
2283804 | 2283804 | 2022-03-07 | Franklin | Pennsylvania | 42055 | 40123 | 672 |
2280552 | 2280552 | 2022-03-06 | Franklin | Pennsylvania | 42055 | 40118 | 672 |
2259973 | 2259973 | 2022-02-28 | Barnstable | Massachusetts | 25001 | 34343 | 672 |
2214361 | 2214361 | 2022-02-14 | Calcasieu | Louisiana | 22019 | 53894 | 672 |
2215982 | 2215982 | 2022-02-14 | Johnson | Texas | 48251 | 41232 | 672 |
2212731 | 2212731 | 2022-02-13 | Johnson | Texas | 48251 | 41211 | 672 |
2209478 | 2209478 | 2022-02-12 | Johnson | Texas | 48251 | 41168 | 672 |
2176473 | 2176473 | 2022-02-02 | Cambria | Pennsylvania | 42021 | 32915 | 672 |
2144762 | 2144762 | 2022-01-23 | Yakima | Washington | 53077 | 59962 | 672 |
2141507 | 2141507 | 2022-01-22 | Yakima | Washington | 53077 | 59962 | 672 |
2138251 | 2138251 | 2022-01-21 | Yakima | Washington | 53077 | 59962 | 672 |
2128703 | 2128703 | 2022-01-19 | Tuscaloosa | Alabama | 1125 | 46371 | 672 |
2130584 | 2130584 | 2022-01-19 | Gaston | North Carolina | 37071 | 54614 | 672 |
2127330 | 2127330 | 2022-01-18 | Gaston | North Carolina | 37071 | 54331 | 672 |
2124078 | 2124078 | 2022-01-17 | Gaston | North Carolina | 37071 | 51897 | 672 |
2120826 | 2120826 | 2022-01-16 | Gaston | North Carolina | 37071 | 51897 | 672 |
2117574 | 2117574 | 2022-01-15 | Gaston | North Carolina | 37071 | 51897 | 672 |
2114323 | 2114323 | 2022-01-14 | Gaston | North Carolina | 37071 | 51897 | 672 |
2103940 | 2103940 | 2022-01-11 | Ottawa | Michigan | 26139 | 60057 | 672 |
2100689 | 2100689 | 2022-01-10 | Ottawa | Michigan | 26139 | 60057 | 672 |
2097438 | 2097438 | 2022-01-09 | Ottawa | Michigan | 26139 | 58717 | 672 |
2094186 | 2094186 | 2022-01-08 | Ottawa | Michigan | 26139 | 58717 | 672 |
2090934 | 2090934 | 2022-01-07 | Ottawa | Michigan | 26139 | 58717 | 672 |
2076910 | 2076910 | 2022-01-03 | Pueblo | Colorado | 8101 | 32142 | 672 |
2054358 | 2054358 | 2021-12-27 | Muscogee | Georgia | 13215 | 25587 | 672 |
2051108 | 2051108 | 2021-12-26 | Muscogee | Georgia | 13215 | 25357 | 672 |
2047858 | 2047858 | 2021-12-25 | Muscogee | Georgia | 13215 | 25357 | 672 |
2044608 | 2044608 | 2021-12-24 | Muscogee | Georgia | 13215 | 25357 | 672 |
2041359 | 2041359 | 2021-12-23 | Muscogee | Georgia | 13215 | 25276 | 672 |
2038109 | 2038109 | 2021-12-22 | Muscogee | Georgia | 13215 | 25223 | 672 |
2034693 | 2034693 | 2021-12-21 | Charlotte | Florida | 12015 | 23902 | 672 |
2034859 | 2034859 | 2021-12-21 | Muscogee | Georgia | 13215 | 25176 | 672 |
2031443 | 2031443 | 2021-12-20 | Charlotte | Florida | 12015 | 23902 | 672 |
2031609 | 2031609 | 2021-12-20 | Muscogee | Georgia | 13215 | 25118 | 672 |
2028192 | 2028192 | 2021-12-19 | Charlotte | Florida | 12015 | 23902 | 672 |
2028358 | 2028358 | 2021-12-19 | Muscogee | Georgia | 13215 | 25058 | 672 |
2024941 | 2024941 | 2021-12-18 | Charlotte | Florida | 12015 | 23902 | 672 |
2025107 | 2025107 | 2021-12-18 | Muscogee | Georgia | 13215 | 25058 | 672 |
2021690 | 2021690 | 2021-12-17 | Charlotte | Florida | 12015 | 23902 | 672 |
2021856 | 2021856 | 2021-12-17 | Muscogee | Georgia | 13215 | 25058 | 672 |
2018439 | 2018439 | 2021-12-16 | Charlotte | Florida | 12015 | 23758 | 672 |
2015189 | 2015189 | 2021-12-15 | Charlotte | Florida | 12015 | 23758 | 672 |
2011938 | 2011938 | 2021-12-14 | Charlotte | Florida | 12015 | 23758 | 672 |
2008687 | 2008687 | 2021-12-13 | Charlotte | Florida | 12015 | 23758 | 672 |
2005436 | 2005436 | 2021-12-12 | Charlotte | Florida | 12015 | 23758 | 672 |
2002185 | 2002185 | 2021-12-11 | Charlotte | Florida | 12015 | 23758 | 672 |
1998935 | 1998935 | 2021-12-10 | Charlotte | Florida | 12015 | 23758 | 672 |
1995684 | 1995684 | 2021-12-09 | Charlotte | Florida | 12015 | 23640 | 672 |
1997641 | 1997641 | 2021-12-09 | Cumberland | Pennsylvania | 42041 | 32746 | 672 |
1992433 | 1992433 | 2021-12-08 | Charlotte | Florida | 12015 | 23640 | 672 |
1989182 | 1989182 | 2021-12-07 | Charlotte | Florida | 12015 | 23640 | 672 |
1985932 | 1985932 | 2021-12-06 | Charlotte | Florida | 12015 | 23640 | 672 |
1982682 | 1982682 | 2021-12-05 | Charlotte | Florida | 12015 | 23640 | 672 |
1979432 | 1979432 | 2021-12-04 | Charlotte | Florida | 12015 | 23640 | 672 |
1976182 | 1976182 | 2021-12-03 | Charlotte | Florida | 12015 | 23640 | 672 |
1972827 | 1972827 | 2021-12-02 | San Francisco | California | 6075 | 57057 | 672 |
1972933 | 1972933 | 2021-12-02 | Charlotte | Florida | 12015 | 23556 | 672 |
1969577 | 1969577 | 2021-12-01 | San Francisco | California | 6075 | 56934 | 672 |
1969683 | 1969683 | 2021-12-01 | Charlotte | Florida | 12015 | 23556 | 672 |
1966433 | 1966433 | 2021-11-30 | Charlotte | Florida | 12015 | 23556 | 672 |
1963181 | 1963181 | 2021-11-29 | Charlotte | Florida | 12015 | 23477 | 672 |
1959930 | 1959930 | 2021-11-28 | Charlotte | Florida | 12015 | 23477 | 672 |
1956679 | 1956679 | 2021-11-27 | Charlotte | Florida | 12015 | 23477 | 672 |
1953428 | 1953428 | 2021-11-26 | Charlotte | Florida | 12015 | 23477 | 672 |
1950177 | 1950177 | 2021-11-25 | Charlotte | Florida | 12015 | 23477 | 672 |
1946701 | 1946701 | 2021-11-24 | Navajo | Arizona | 4017 | 24082 | 672 |
1946926 | 1946926 | 2021-11-24 | Charlotte | Florida | 12015 | 23477 | 672 |
1943675 | 1943675 | 2021-11-23 | Charlotte | Florida | 12015 | 23477 | 672 |
1940425 | 1940425 | 2021-11-22 | Charlotte | Florida | 12015 | 23477 | 672 |
1937175 | 1937175 | 2021-11-21 | Charlotte | Florida | 12015 | 23477 | 672 |
1933925 | 1933925 | 2021-11-20 | Charlotte | Florida | 12015 | 23477 | 672 |
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);