ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
183 rows where deaths = 545 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 20
- Florida 18
- Pennsylvania 12
- California 11
- Tennessee 11
- Wisconsin 11
- Georgia 9
- Illinois 9
- Delaware 8
- Idaho 8
- Indiana 8
- Michigan 8
- Maryland 7
- Arizona 5
- Ohio 5
- South Carolina 5
- Louisiana 4
- New Mexico 4
- Washington 4
- Missouri 3
- North Carolina 3
- Colorado 2
- Iowa 2
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- New Jersey 1
- New York 1
- Oregon 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398535 | 2398535 | 2022-04-11 | Brown | Wisconsin | 55009 | 84077 | 545 |
2395280 | 2395280 | 2022-04-10 | Brown | Wisconsin | 55009 | 84019 | 545 |
2392024 | 2392024 | 2022-04-09 | Brown | Wisconsin | 55009 | 84019 | 545 |
2388768 | 2388768 | 2022-04-08 | Brown | Wisconsin | 55009 | 84019 | 545 |
2385513 | 2385513 | 2022-04-07 | Brown | Wisconsin | 55009 | 83958 | 545 |
2382258 | 2382258 | 2022-04-06 | Brown | Wisconsin | 55009 | 83925 | 545 |
2379003 | 2379003 | 2022-04-05 | Brown | Wisconsin | 55009 | 83893 | 545 |
2355742 | 2355742 | 2022-03-29 | Comal | Texas | 48091 | 33561 | 545 |
2352489 | 2352489 | 2022-03-28 | Comal | Texas | 48091 | 33561 | 545 |
2349237 | 2349237 | 2022-03-27 | Comal | Texas | 48091 | 33561 | 545 |
2345984 | 2345984 | 2022-03-26 | Comal | Texas | 48091 | 33561 | 545 |
2342731 | 2342731 | 2022-03-25 | Comal | Texas | 48091 | 33461 | 545 |
2300388 | 2300388 | 2022-03-12 | Unknown | Tennessee | 20141 | 545 | |
2269235 | 2269235 | 2022-03-03 | Hendricks | Indiana | 18063 | 40643 | 545 |
2260660 | 2260660 | 2022-02-28 | Buncombe | North Carolina | 37021 | 50412 | 545 |
2255724 | 2255724 | 2022-02-27 | Shasta | California | 6089 | 36201 | 545 |
2252473 | 2252473 | 2022-02-26 | Shasta | California | 6089 | 36201 | 545 |
2249222 | 2249222 | 2022-02-25 | Shasta | California | 6089 | 36201 | 545 |
2245971 | 2245971 | 2022-02-24 | Shasta | California | 6089 | 36159 | 545 |
2242720 | 2242720 | 2022-02-23 | Shasta | California | 6089 | 36022 | 545 |
2243257 | 2243257 | 2022-02-23 | Porter | Indiana | 18127 | 37064 | 545 |
2239469 | 2239469 | 2022-02-22 | Shasta | California | 6089 | 36002 | 545 |
2236218 | 2236218 | 2022-02-21 | Shasta | California | 6089 | 35853 | 545 |
2232967 | 2232967 | 2022-02-20 | Shasta | California | 6089 | 35853 | 545 |
2229716 | 2229716 | 2022-02-19 | Shasta | California | 6089 | 35853 | 545 |
2230766 | 2230766 | 2022-02-19 | Jackson | Michigan | 26075 | 43995 | 545 |
2226465 | 2226465 | 2022-02-18 | Shasta | California | 6089 | 35853 | 545 |
2227515 | 2227515 | 2022-02-18 | Jackson | Michigan | 26075 | 43995 | 545 |
2224264 | 2224264 | 2022-02-17 | Jackson | Michigan | 26075 | 43995 | 545 |
2221013 | 2221013 | 2022-02-16 | Jackson | Michigan | 26075 | 43995 | 545 |
2216804 | 2216804 | 2022-02-15 | Alachua | Florida | 12001 | 65992 | 545 |
2219178 | 2219178 | 2022-02-15 | Ellis | Texas | 48139 | 47698 | 545 |
2213553 | 2213553 | 2022-02-14 | Alachua | Florida | 12001 | 65992 | 545 |
2210301 | 2210301 | 2022-02-13 | Alachua | Florida | 12001 | 65992 | 545 |
2210563 | 2210563 | 2022-02-13 | Kootenai | Idaho | 16055 | 38090 | 545 |
2207048 | 2207048 | 2022-02-12 | Alachua | Florida | 12001 | 65992 | 545 |
2207310 | 2207310 | 2022-02-12 | Kootenai | Idaho | 16055 | 38090 | 545 |
2203795 | 2203795 | 2022-02-11 | Alachua | Florida | 12001 | 65992 | 545 |
2204057 | 2204057 | 2022-02-11 | Kootenai | Idaho | 16055 | 38039 | 545 |
2200542 | 2200542 | 2022-02-10 | Alachua | Florida | 12001 | 64444 | 545 |
2200804 | 2200804 | 2022-02-10 | Kootenai | Idaho | 16055 | 37934 | 545 |
2201445 | 2201445 | 2022-02-10 | Washington | Maryland | 24043 | 33331 | 545 |
2197288 | 2197288 | 2022-02-09 | Alachua | Florida | 12001 | 64444 | 545 |
2197550 | 2197550 | 2022-02-09 | Kootenai | Idaho | 16055 | 37701 | 545 |
2198843 | 2198843 | 2022-02-09 | Niagara | New York | 36063 | 46581 | 545 |
2143490 | 2143490 | 2022-01-23 | McKinley | New Mexico | 35031 | 21569 | 545 |
2140235 | 2140235 | 2022-01-22 | McKinley | New Mexico | 35031 | 21569 | 545 |
2136979 | 2136979 | 2022-01-21 | McKinley | New Mexico | 35031 | 21569 | 545 |
2134167 | 2134167 | 2022-01-20 | Blair | Pennsylvania | 42013 | 25927 | 545 |
2126133 | 2126133 | 2022-01-18 | Johnson | Indiana | 18081 | 37672 | 545 |
2110433 | 2110433 | 2022-01-13 | Muskegon | Michigan | 26121 | 34864 | 545 |
2107182 | 2107182 | 2022-01-12 | Muskegon | Michigan | 26121 | 34864 | 545 |
2108594 | 2108594 | 2022-01-12 | Grayson | Texas | 48181 | 19774 | 545 |
2089716 | 2089716 | 2022-01-07 | Apache | Arizona | 4001 | 16770 | 545 |
2086465 | 2086465 | 2022-01-06 | Apache | Arizona | 4001 | 16610 | 545 |
2083213 | 2083213 | 2022-01-05 | Apache | Arizona | 4001 | 16476 | 545 |
2082329 | 2082329 | 2022-01-04 | York | South Carolina | 45091 | 53661 | 545 |
2075974 | 2075974 | 2022-01-02 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2076231 | 2076231 | 2022-01-02 | Wichita | Texas | 48485 | 23104 | 545 |
2072723 | 2072723 | 2022-01-01 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2072980 | 2072980 | 2022-01-01 | Wichita | Texas | 48485 | 23104 | 545 |
2069472 | 2069472 | 2021-12-31 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2069729 | 2069729 | 2021-12-31 | Wichita | Texas | 48485 | 23104 | 545 |
2066221 | 2066221 | 2021-12-30 | Sullivan | Tennessee | 47163 | 30945 | 545 |
2066478 | 2066478 | 2021-12-30 | Wichita | Texas | 48485 | 23104 | 545 |
2059363 | 2059363 | 2021-12-28 | Marion | Oregon | 41047 | 41812 | 545 |
2055966 | 2055966 | 2021-12-27 | Lake | Ohio | 39085 | 39178 | 545 |
2052717 | 2052717 | 2021-12-26 | Lake | Ohio | 39085 | 38907 | 545 |
2049467 | 2049467 | 2021-12-25 | Lake | Ohio | 39085 | 38115 | 545 |
2046217 | 2046217 | 2021-12-24 | Lake | Ohio | 39085 | 38115 | 545 |
1991122 | 1991122 | 2021-12-07 | Beaver | Pennsylvania | 42007 | 26932 | 545 |
1972419 | 1972419 | 2021-12-01 | Clark | Washington | 53011 | 45118 | 545 |
1969169 | 1969169 | 2021-11-30 | Clark | Washington | 53011 | 45118 | 545 |
1965127 | 1965127 | 2021-11-29 | Butler | Pennsylvania | 42019 | 28860 | 545 |
1965152 | 1965152 | 2021-11-29 | Lackawanna | Pennsylvania | 42069 | 25358 | 545 |
1961875 | 1961875 | 2021-11-28 | Butler | Pennsylvania | 42019 | 28720 | 545 |
1944665 | 1944665 | 2021-11-23 | St. Clair | Michigan | 26147 | 25385 | 545 |
1941414 | 1941414 | 2021-11-22 | St. Clair | Michigan | 26147 | 25186 | 545 |
1924139 | 1924139 | 2021-11-17 | Pueblo | Colorado | 8101 | 28340 | 545 |
1908166 | 1908166 | 2021-11-12 | Canyon | Idaho | 16027 | 42694 | 545 |
1904917 | 1904917 | 2021-11-11 | Canyon | Idaho | 16027 | 42694 | 545 |
1905070 | 1905070 | 2021-11-11 | Elkhart | Indiana | 18039 | 37547 | 545 |
1901667 | 1901667 | 2021-11-10 | Canyon | Idaho | 16027 | 42694 | 545 |
1901820 | 1901820 | 2021-11-10 | Elkhart | Indiana | 18039 | 37263 | 545 |
1898570 | 1898570 | 2021-11-09 | Elkhart | Indiana | 18039 | 37164 | 545 |
1865701 | 1865701 | 2021-10-30 | Highlands | Florida | 12055 | 15931 | 545 |
1862452 | 1862452 | 2021-10-29 | Highlands | Florida | 12055 | 15931 | 545 |
1859203 | 1859203 | 2021-10-28 | Highlands | Florida | 12055 | 15882 | 545 |
1855954 | 1855954 | 2021-10-27 | Highlands | Florida | 12055 | 15882 | 545 |
1858417 | 1858417 | 2021-10-27 | Potter | Texas | 48375 | 23420 | 545 |
1852705 | 1852705 | 2021-10-26 | Highlands | Florida | 12055 | 15882 | 545 |
1855168 | 1855168 | 2021-10-26 | Potter | Texas | 48375 | 23362 | 545 |
1855201 | 1855201 | 2021-10-26 | Taylor | Texas | 48441 | 22873 | 545 |
1849456 | 1849456 | 2021-10-25 | Highlands | Florida | 12055 | 15882 | 545 |
1851710 | 1851710 | 2021-10-25 | Rutherford | Tennessee | 47149 | 61502 | 545 |
1848460 | 1848460 | 2021-10-24 | Rutherford | Tennessee | 47149 | 61502 | 545 |
1845210 | 1845210 | 2021-10-23 | Rutherford | Tennessee | 47149 | 61502 | 545 |
1841960 | 1841960 | 2021-10-22 | Rutherford | Tennessee | 47149 | 61502 | 545 |
1834697 | 1834697 | 2021-10-20 | San Juan | New Mexico | 35045 | 20563 | 545 |
1828300 | 1828300 | 2021-10-18 | Forsyth | North Carolina | 37067 | 50993 | 545 |
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);