ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where deaths = 541 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 26
- Texas 18
- Illinois 14
- Indiana 13
- Michigan 13
- Louisiana 10
- Ohio 10
- Pennsylvania 10
- California 9
- South Carolina 7
- Mississippi 6
- Missouri 6
- Arizona 5
- New York 5
- North Carolina 5
- New Jersey 4
- Tennessee 4
- Virginia 4
- Wisconsin 4
- Georgia 3
- Nebraska 3
- Washington 3
- Oklahoma 2
- Oregon 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Connecticut 1
- District of Columbia 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501830 | 2501830 | 2022-05-13 | Lane | Oregon | 41039 | 59853 | 541 |
2498110 | 2498110 | 2022-05-12 | Rockingham | New Hampshire | 33015 | 70216 | 541 |
2290247 | 2290247 | 2022-03-09 | Clackamas | Oregon | 41005 | 59431 | 541 |
2262731 | 2262731 | 2022-03-01 | Hendricks | Indiana | 18063 | 40626 | 541 |
2242586 | 2242586 | 2022-02-23 | Cochise | Arizona | 4003 | 30817 | 541 |
2244412 | 2244412 | 2022-02-23 | Catawba | North Carolina | 37035 | 46987 | 541 |
2240006 | 2240006 | 2022-02-22 | Porter | Indiana | 18127 | 37051 | 541 |
2236755 | 2236755 | 2022-02-21 | Porter | Indiana | 18127 | 37044 | 541 |
2233504 | 2233504 | 2022-02-20 | Porter | Indiana | 18127 | 37001 | 541 |
2230253 | 2230253 | 2022-02-19 | Porter | Indiana | 18127 | 37001 | 541 |
2227002 | 2227002 | 2022-02-18 | Porter | Indiana | 18127 | 37001 | 541 |
2223751 | 2223751 | 2022-02-17 | Porter | Indiana | 18127 | 36959 | 541 |
2220500 | 2220500 | 2022-02-16 | Porter | Indiana | 18127 | 36931 | 541 |
2217154 | 2217154 | 2022-02-15 | Peoria | Illinois | 17143 | 45485 | 541 |
2213903 | 2213903 | 2022-02-14 | Peoria | Illinois | 17143 | 45465 | 541 |
2215927 | 2215927 | 2022-02-14 | Ellis | Texas | 48139 | 47650 | 541 |
2210651 | 2210651 | 2022-02-13 | Peoria | Illinois | 17143 | 45347 | 541 |
2211964 | 2211964 | 2022-02-13 | Rowan | North Carolina | 37159 | 39903 | 541 |
2207398 | 2207398 | 2022-02-12 | Peoria | Illinois | 17143 | 45347 | 541 |
2208711 | 2208711 | 2022-02-12 | Rowan | North Carolina | 37159 | 39903 | 541 |
2204145 | 2204145 | 2022-02-11 | Peoria | Illinois | 17143 | 45347 | 541 |
2205458 | 2205458 | 2022-02-11 | Rowan | North Carolina | 37159 | 39903 | 541 |
2200892 | 2200892 | 2022-02-10 | Peoria | Illinois | 17143 | 45295 | 541 |
2197638 | 2197638 | 2022-02-09 | Peoria | Illinois | 17143 | 45243 | 541 |
2194034 | 2194034 | 2022-02-08 | Alachua | Florida | 12001 | 64444 | 541 |
2190780 | 2190780 | 2022-02-07 | Alachua | Florida | 12001 | 64444 | 541 |
2187527 | 2187527 | 2022-02-06 | Alachua | Florida | 12001 | 64444 | 541 |
2184274 | 2184274 | 2022-02-05 | Alachua | Florida | 12001 | 64444 | 541 |
2181022 | 2181022 | 2022-02-04 | Alachua | Florida | 12001 | 64444 | 541 |
2182576 | 2182576 | 2022-02-04 | Niagara | New York | 36063 | 46273 | 541 |
2177631 | 2177631 | 2022-02-03 | Washington | Arkansas | 5143 | 65082 | 541 |
2177771 | 2177771 | 2022-02-03 | Alachua | Florida | 12001 | 62121 | 541 |
2174518 | 2174518 | 2022-02-02 | Alachua | Florida | 12001 | 62121 | 541 |
2171306 | 2171306 | 2022-02-01 | Martin | Florida | 12085 | 29554 | 541 |
2168053 | 2168053 | 2022-01-31 | Martin | Florida | 12085 | 29554 | 541 |
2164798 | 2164798 | 2022-01-30 | Martin | Florida | 12085 | 29554 | 541 |
2161543 | 2161543 | 2022-01-29 | Martin | Florida | 12085 | 29554 | 541 |
2158287 | 2158287 | 2022-01-28 | Martin | Florida | 12085 | 29554 | 541 |
2155034 | 2155034 | 2022-01-27 | Martin | Florida | 12085 | 28457 | 541 |
2151781 | 2151781 | 2022-01-26 | Martin | Florida | 12085 | 28457 | 541 |
2102941 | 2102941 | 2022-01-11 | New London | Connecticut | 9011 | 42826 | 541 |
2103931 | 2103931 | 2022-01-11 | Muskegon | Michigan | 26121 | 34295 | 541 |
2100680 | 2100680 | 2022-01-10 | Muskegon | Michigan | 26121 | 34295 | 541 |
2097429 | 2097429 | 2022-01-09 | Muskegon | Michigan | 26121 | 33551 | 541 |
2094177 | 2094177 | 2022-01-08 | Muskegon | Michigan | 26121 | 33551 | 541 |
2090925 | 2090925 | 2022-01-07 | Muskegon | Michigan | 26121 | 33551 | 541 |
2092337 | 2092337 | 2022-01-07 | Grayson | Texas | 48181 | 18430 | 541 |
2081726 | 2081726 | 2022-01-04 | Dutchess | New York | 36027 | 48429 | 541 |
2082157 | 2082157 | 2022-01-04 | Fayette | Pennsylvania | 42051 | 23430 | 541 |
2077347 | 2077347 | 2022-01-03 | Hamilton | Indiana | 18057 | 60308 | 541 |
2060456 | 2060456 | 2021-12-29 | Apache | Arizona | 4001 | 16127 | 541 |
2057207 | 2057207 | 2021-12-28 | Apache | Arizona | 4001 | 16090 | 541 |
2053480 | 2053480 | 2021-12-26 | Wichita | Texas | 48485 | 22862 | 541 |
2050230 | 2050230 | 2021-12-25 | Wichita | Texas | 48485 | 22862 | 541 |
2046980 | 2046980 | 2021-12-24 | Wichita | Texas | 48485 | 22862 | 541 |
2043730 | 2043730 | 2021-12-23 | Wichita | Texas | 48485 | 22862 | 541 |
2039932 | 2039932 | 2021-12-22 | Schuylkill | Pennsylvania | 42107 | 25160 | 541 |
2040481 | 2040481 | 2021-12-22 | Wichita | Texas | 48485 | 22862 | 541 |
2037231 | 2037231 | 2021-12-21 | Wichita | Texas | 48485 | 22862 | 541 |
1985909 | 1985909 | 2021-12-06 | Weld | Colorado | 8123 | 53941 | 541 |
1965142 | 1965142 | 2021-11-29 | Erie | Pennsylvania | 42049 | 35643 | 541 |
1942369 | 1942369 | 2021-11-22 | Butler | Pennsylvania | 42019 | 28007 | 541 |
1938164 | 1938164 | 2021-11-21 | St. Clair | Michigan | 26147 | 25078 | 541 |
1939119 | 1939119 | 2021-11-21 | Butler | Pennsylvania | 42019 | 27882 | 541 |
1934914 | 1934914 | 2021-11-20 | St. Clair | Michigan | 26147 | 25021 | 541 |
1935869 | 1935869 | 2021-11-20 | Butler | Pennsylvania | 42019 | 27731 | 541 |
1931664 | 1931664 | 2021-11-19 | St. Clair | Michigan | 26147 | 24887 | 541 |
1922869 | 1922869 | 2021-11-16 | Cambria | Pennsylvania | 42021 | 21311 | 541 |
1903789 | 1903789 | 2021-11-10 | Ector | Texas | 48135 | 25958 | 541 |
1898417 | 1898417 | 2021-11-09 | Canyon | Idaho | 16027 | 42628 | 541 |
1900539 | 1900539 | 2021-11-09 | Ector | Texas | 48135 | 25958 | 541 |
1895320 | 1895320 | 2021-11-08 | Elkhart | Indiana | 18039 | 37091 | 541 |
1897289 | 1897289 | 2021-11-08 | Ector | Texas | 48135 | 25926 | 541 |
1894039 | 1894039 | 2021-11-07 | Ector | Texas | 48135 | 25926 | 541 |
1890789 | 1890789 | 2021-11-06 | Ector | Texas | 48135 | 25926 | 541 |
1860293 | 1860293 | 2021-10-28 | Harrison | Mississippi | 28047 | 34445 | 541 |
1857044 | 1857044 | 2021-10-27 | Harrison | Mississippi | 28047 | 34423 | 541 |
1853795 | 1853795 | 2021-10-26 | Harrison | Mississippi | 28047 | 34400 | 541 |
1815203 | 1815203 | 2021-10-14 | San Juan | New Mexico | 35045 | 19894 | 541 |
1815504 | 1815504 | 2021-10-14 | Trumbull | Ohio | 39155 | 22248 | 541 |
1812256 | 1812256 | 2021-10-13 | Trumbull | Ohio | 39155 | 22161 | 541 |
1812929 | 1812929 | 2021-10-13 | Potter | Texas | 48375 | 22967 | 541 |
1809007 | 1809007 | 2021-10-12 | Trumbull | Ohio | 39155 | 22040 | 541 |
1780653 | 1780653 | 2021-10-03 | Prince William | Virginia | 51153 | 52702 | 541 |
1777403 | 1777403 | 2021-10-02 | Prince William | Virginia | 51153 | 52702 | 541 |
1774153 | 1774153 | 2021-10-01 | Prince William | Virginia | 51153 | 52702 | 541 |
1770903 | 1770903 | 2021-09-30 | Prince William | Virginia | 51153 | 52588 | 541 |
1735598 | 1735598 | 2021-09-20 | Merced | California | 6047 | 39643 | 541 |
1733296 | 1733296 | 2021-09-19 | Ouachita | Louisiana | 22073 | 29392 | 541 |
1734016 | 1734016 | 2021-09-19 | Oneida | New York | 36065 | 25527 | 541 |
1730046 | 1730046 | 2021-09-18 | Ouachita | Louisiana | 22073 | 29392 | 541 |
1726796 | 1726796 | 2021-09-17 | Ouachita | Louisiana | 22073 | 29392 | 541 |
1688098 | 1688098 | 2021-09-05 | Hinds | Mississippi | 28049 | 29522 | 541 |
1689368 | 1689368 | 2021-09-05 | Galveston | Texas | 48167 | 56239 | 541 |
1684848 | 1684848 | 2021-09-04 | Hinds | Mississippi | 28049 | 29522 | 541 |
1681597 | 1681597 | 2021-09-03 | Hinds | Mississippi | 28049 | 29522 | 541 |
1649224 | 1649224 | 2021-08-24 | Jackson | Missouri | 29095 | 48598 | 541 |
1644645 | 1644645 | 2021-08-23 | Monterey | California | 6053 | 47358 | 541 |
1641395 | 1641395 | 2021-08-22 | Monterey | California | 6053 | 47310 | 541 |
1643743 | 1643743 | 2021-08-22 | Hamilton | Tennessee | 47065 | 51523 | 541 |
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);