ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where deaths = 781 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- New York 21
- Alabama 19
- Pennsylvania 16
- Georgia 14
- Texas 10
- Washington 9
- California 8
- Florida 8
- Michigan 8
- Kansas 7
- Mississippi 7
- Tennessee 7
- Colorado 6
- Delaware 6
- Ohio 5
- South Carolina 5
- Louisiana 4
- Maryland 4
- Nebraska 4
- New Jersey 3
- North Carolina 3
- Arizona 1
- Illinois 1
- Indiana 1
- Massachusetts 1
- New Mexico 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444609 | 2444609 | 2022-04-26 | Bibb | Georgia | 13021 | 37160 | 781 |
2441353 | 2441353 | 2022-04-25 | Bibb | Georgia | 13021 | 37160 | 781 |
2437992 | 2437992 | 2022-04-24 | Pueblo | Colorado | 8101 | 46810 | 781 |
2438097 | 2438097 | 2022-04-24 | Bibb | Georgia | 13021 | 37170 | 781 |
2434736 | 2434736 | 2022-04-23 | Pueblo | Colorado | 8101 | 46810 | 781 |
2434841 | 2434841 | 2022-04-23 | Bibb | Georgia | 13021 | 37170 | 781 |
2431480 | 2431480 | 2022-04-22 | Pueblo | Colorado | 8101 | 46810 | 781 |
2431585 | 2431585 | 2022-04-22 | Bibb | Georgia | 13021 | 37170 | 781 |
2427990 | 2427990 | 2022-04-21 | Tuscaloosa | Alabama | 1125 | 56058 | 781 |
2428329 | 2428329 | 2022-04-21 | Bibb | Georgia | 13021 | 37170 | 781 |
2431033 | 2431033 | 2022-04-21 | Yakima | Washington | 53077 | 73492 | 781 |
2424734 | 2424734 | 2022-04-20 | Tuscaloosa | Alabama | 1125 | 56053 | 781 |
2425073 | 2425073 | 2022-04-20 | Bibb | Georgia | 13021 | 37170 | 781 |
2427777 | 2427777 | 2022-04-20 | Yakima | Washington | 53077 | 73480 | 781 |
2421478 | 2421478 | 2022-04-19 | Tuscaloosa | Alabama | 1125 | 56053 | 781 |
2418222 | 2418222 | 2022-04-18 | Tuscaloosa | Alabama | 1125 | 56044 | 781 |
2414966 | 2414966 | 2022-04-17 | Tuscaloosa | Alabama | 1125 | 56044 | 781 |
2411710 | 2411710 | 2022-04-16 | Tuscaloosa | Alabama | 1125 | 56044 | 781 |
2408454 | 2408454 | 2022-04-15 | Tuscaloosa | Alabama | 1125 | 56044 | 781 |
2367963 | 2367963 | 2022-04-02 | Oneida | New York | 36065 | 53275 | 781 |
2364710 | 2364710 | 2022-04-01 | Oneida | New York | 36065 | 53192 | 781 |
2361456 | 2361456 | 2022-03-31 | Oneida | New York | 36065 | 53137 | 781 |
2358202 | 2358202 | 2022-03-30 | Oneida | New York | 36065 | 53070 | 781 |
2354948 | 2354948 | 2022-03-29 | Oneida | New York | 36065 | 52985 | 781 |
2351695 | 2351695 | 2022-03-28 | Oneida | New York | 36065 | 52951 | 781 |
2348443 | 2348443 | 2022-03-27 | Oneida | New York | 36065 | 52915 | 781 |
2345190 | 2345190 | 2022-03-26 | Oneida | New York | 36065 | 52876 | 781 |
2341937 | 2341937 | 2022-03-25 | Oneida | New York | 36065 | 52827 | 781 |
2338684 | 2338684 | 2022-03-24 | Oneida | New York | 36065 | 52777 | 781 |
2339712 | 2339712 | 2022-03-24 | Utah | Utah | 49049 | 201389 | 781 |
2335430 | 2335430 | 2022-03-23 | Oneida | New York | 36065 | 52730 | 781 |
2331609 | 2331609 | 2022-03-22 | Ottawa | Michigan | 26139 | 74437 | 781 |
2332176 | 2332176 | 2022-03-22 | Oneida | New York | 36065 | 52661 | 781 |
2328357 | 2328357 | 2022-03-21 | Ottawa | Michigan | 26139 | 74437 | 781 |
2328923 | 2328923 | 2022-03-21 | Oneida | New York | 36065 | 52648 | 781 |
2325104 | 2325104 | 2022-03-20 | Ottawa | Michigan | 26139 | 74386 | 781 |
2325231 | 2325231 | 2022-03-20 | Hinds | Mississippi | 28049 | 52025 | 781 |
2325671 | 2325671 | 2022-03-20 | Oneida | New York | 36065 | 52645 | 781 |
2326860 | 2326860 | 2022-03-20 | Clark | Washington | 53011 | 87115 | 781 |
2321850 | 2321850 | 2022-03-19 | Ottawa | Michigan | 26139 | 74386 | 781 |
2321977 | 2321977 | 2022-03-19 | Hinds | Mississippi | 28049 | 52025 | 781 |
2322418 | 2322418 | 2022-03-19 | Oneida | New York | 36065 | 52628 | 781 |
2323607 | 2323607 | 2022-03-19 | Clark | Washington | 53011 | 87115 | 781 |
2318596 | 2318596 | 2022-03-18 | Ottawa | Michigan | 26139 | 74386 | 781 |
2318723 | 2318723 | 2022-03-18 | Hinds | Mississippi | 28049 | 52025 | 781 |
2319164 | 2319164 | 2022-03-18 | Oneida | New York | 36065 | 52605 | 781 |
2320353 | 2320353 | 2022-03-18 | Clark | Washington | 53011 | 87115 | 781 |
2315343 | 2315343 | 2022-03-17 | Ottawa | Michigan | 26139 | 74346 | 781 |
2315470 | 2315470 | 2022-03-17 | Hinds | Mississippi | 28049 | 52025 | 781 |
2315910 | 2315910 | 2022-03-17 | Oneida | New York | 36065 | 52568 | 781 |
2312090 | 2312090 | 2022-03-16 | Ottawa | Michigan | 26139 | 74346 | 781 |
2312217 | 2312217 | 2022-03-16 | Hinds | Mississippi | 28049 | 52025 | 781 |
2312657 | 2312657 | 2022-03-16 | Oneida | New York | 36065 | 52529 | 781 |
2308964 | 2308964 | 2022-03-15 | Hinds | Mississippi | 28049 | 52025 | 781 |
2309404 | 2309404 | 2022-03-15 | Oneida | New York | 36065 | 52505 | 781 |
2305713 | 2305713 | 2022-03-14 | Hinds | Mississippi | 28049 | 52025 | 781 |
2306151 | 2306151 | 2022-03-14 | Oneida | New York | 36065 | 52490 | 781 |
2302900 | 2302900 | 2022-03-13 | Oneida | New York | 36065 | 52478 | 781 |
2206222 | 2206222 | 2022-02-11 | Jefferson | Texas | 48245 | 42441 | 781 |
2197380 | 2197380 | 2022-02-09 | Chatham | Georgia | 13051 | 60226 | 781 |
2164945 | 2164945 | 2022-01-30 | Richmond | Georgia | 13245 | 47256 | 781 |
2161690 | 2161690 | 2022-01-29 | Richmond | Georgia | 13245 | 47256 | 781 |
2158434 | 2158434 | 2022-01-28 | Richmond | Georgia | 13245 | 47256 | 781 |
2155181 | 2155181 | 2022-01-27 | Richmond | Georgia | 13245 | 46935 | 781 |
2152075 | 2152075 | 2022-01-26 | Madison | Illinois | 17119 | 65766 | 781 |
2150770 | 2150770 | 2022-01-25 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2147518 | 2147518 | 2022-01-24 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2144264 | 2144264 | 2022-01-23 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2141009 | 2141009 | 2022-01-22 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2137753 | 2137753 | 2022-01-21 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2134499 | 2134499 | 2022-01-20 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2131247 | 2131247 | 2022-01-19 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2062160 | 2062160 | 2021-12-29 | Gloucester | New Jersey | 34015 | 47823 | 781 |
2018530 | 2018530 | 2021-12-16 | Clayton | Georgia | 13063 | 41075 | 781 |
2015280 | 2015280 | 2021-12-15 | Clayton | Georgia | 13063 | 40981 | 781 |
2005305 | 2005305 | 2021-12-12 | Imperial | California | 6025 | 39462 | 781 |
2002054 | 2002054 | 2021-12-11 | Imperial | California | 6025 | 39462 | 781 |
1998804 | 1998804 | 2021-12-10 | Imperial | California | 6025 | 39462 | 781 |
1995553 | 1995553 | 2021-12-09 | Imperial | California | 6025 | 39364 | 781 |
1995326 | 1995326 | 2021-12-08 | Waukesha | Wisconsin | 55133 | 71765 | 781 |
1969403 | 1969403 | 2021-12-01 | Montgomery | Alabama | 1101 | 34509 | 781 |
1966153 | 1966153 | 2021-11-30 | Montgomery | Alabama | 1101 | 34492 | 781 |
1962901 | 1962901 | 2021-11-29 | Montgomery | Alabama | 1101 | 34492 | 781 |
1959650 | 1959650 | 2021-11-28 | Montgomery | Alabama | 1101 | 34483 | 781 |
1962057 | 1962057 | 2021-11-28 | Richland | South Carolina | 45079 | 70094 | 781 |
1956399 | 1956399 | 2021-11-27 | Montgomery | Alabama | 1101 | 34482 | 781 |
1958806 | 1958806 | 2021-11-27 | Richland | South Carolina | 45079 | 70094 | 781 |
1953148 | 1953148 | 2021-11-26 | Montgomery | Alabama | 1101 | 34473 | 781 |
1955555 | 1955555 | 2021-11-26 | Richland | South Carolina | 45079 | 70094 | 781 |
1949897 | 1949897 | 2021-11-25 | Montgomery | Alabama | 1101 | 34473 | 781 |
1946646 | 1946646 | 2021-11-24 | Montgomery | Alabama | 1101 | 34462 | 781 |
1943395 | 1943395 | 2021-11-23 | Montgomery | Alabama | 1101 | 34462 | 781 |
1943186 | 1943186 | 2021-11-22 | Snohomish | Washington | 53061 | 70946 | 781 |
1939936 | 1939936 | 2021-11-21 | Snohomish | Washington | 53061 | 70411 | 781 |
1936686 | 1936686 | 2021-11-20 | Snohomish | Washington | 53061 | 70411 | 781 |
1930393 | 1930393 | 2021-11-19 | Montgomery | Alabama | 1101 | 34431 | 781 |
1933436 | 1933436 | 2021-11-19 | Snohomish | Washington | 53061 | 70411 | 781 |
1927143 | 1927143 | 2021-11-18 | Montgomery | Alabama | 1101 | 34421 | 781 |
1923893 | 1923893 | 2021-11-17 | Montgomery | Alabama | 1101 | 34412 | 781 |
1921799 | 1921799 | 2021-11-16 | Anne Arundel | Maryland | 24003 | 54258 | 781 |
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);