ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
239 rows where deaths = 532 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Carolina 35
- Georgia 26
- Alabama 22
- Florida 16
- California 13
- Texas 13
- Oregon 11
- Arizona 10
- Indiana 10
- Louisiana 8
- Ohio 8
- Pennsylvania 8
- Michigan 7
- Kansas 6
- Wisconsin 6
- Illinois 5
- New Mexico 5
- New York 5
- Maryland 4
- Colorado 3
- Connecticut 3
- Montana 2
- North Carolina 2
- Utah 2
- Delaware 1
- Hawaii 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497718 | 2497718 | 2022-05-12 | St. Louis | Minnesota | 27137 | 48400 | 532 |
2485536 | 2485536 | 2022-05-08 | Jackson | Oregon | 41029 | 43316 | 532 |
2482278 | 2482278 | 2022-05-07 | Jackson | Oregon | 41029 | 43316 | 532 |
2479020 | 2479020 | 2022-05-06 | Jackson | Oregon | 41029 | 43316 | 532 |
2449719 | 2449719 | 2022-04-27 | Lane | Oregon | 41039 | 58215 | 532 |
2446462 | 2446462 | 2022-04-26 | Lane | Oregon | 41039 | 58150 | 532 |
2443207 | 2443207 | 2022-04-25 | Lane | Oregon | 41039 | 58057 | 532 |
2439951 | 2439951 | 2022-04-24 | Lane | Oregon | 41039 | 57879 | 532 |
2436695 | 2436695 | 2022-04-23 | Lane | Oregon | 41039 | 57879 | 532 |
2433439 | 2433439 | 2022-04-22 | Lane | Oregon | 41039 | 57879 | 532 |
2430183 | 2430183 | 2022-04-21 | Lane | Oregon | 41039 | 57841 | 532 |
2426927 | 2426927 | 2022-04-20 | Lane | Oregon | 41039 | 57790 | 532 |
2405420 | 2405420 | 2022-04-14 | Mesa | Colorado | 8077 | 42481 | 532 |
2398910 | 2398910 | 2022-04-12 | Mesa | Colorado | 8077 | 42429 | 532 |
2395655 | 2395655 | 2022-04-11 | Mesa | Colorado | 8077 | 42421 | 532 |
2333053 | 2333053 | 2022-03-22 | Kaufman | Texas | 48257 | 35107 | 532 |
2329800 | 2329800 | 2022-03-21 | Kaufman | Texas | 48257 | 35096 | 532 |
2270169 | 2270169 | 2022-03-03 | Yellowstone | Montana | 30111 | 42485 | 532 |
2266916 | 2266916 | 2022-03-02 | Yellowstone | Montana | 30111 | 42371 | 532 |
2223080 | 2223080 | 2022-02-17 | Cochise | Arizona | 4003 | 30548 | 532 |
2215377 | 2215377 | 2022-02-14 | Warren | Ohio | 39165 | 56739 | 532 |
2212126 | 2212126 | 2022-02-13 | Warren | Ohio | 39165 | 56710 | 532 |
2208873 | 2208873 | 2022-02-12 | Warren | Ohio | 39165 | 56669 | 532 |
2205620 | 2205620 | 2022-02-11 | Warren | Ohio | 39165 | 56636 | 532 |
2200987 | 2200987 | 2022-02-10 | Porter | Indiana | 18127 | 36659 | 532 |
2201500 | 2201500 | 2022-02-10 | Jackson | Michigan | 26075 | 43767 | 532 |
2198246 | 2198246 | 2022-02-09 | Jackson | Michigan | 26075 | 43767 | 532 |
2187877 | 2187877 | 2022-02-06 | Peoria | Illinois | 17143 | 44879 | 532 |
2184624 | 2184624 | 2022-02-05 | Peoria | Illinois | 17143 | 44879 | 532 |
2178673 | 2178673 | 2022-02-03 | Washington | Maryland | 24043 | 32979 | 532 |
2174412 | 2174412 | 2022-02-02 | Placer | California | 6061 | 64760 | 532 |
2169567 | 2169567 | 2022-01-31 | Niagara | New York | 36063 | 45874 | 532 |
2169675 | 2169675 | 2022-01-31 | Rowan | North Carolina | 37159 | 38566 | 532 |
2166312 | 2166312 | 2022-01-30 | Niagara | New York | 36063 | 45807 | 532 |
2148529 | 2148529 | 2022-01-25 | Martin | Florida | 12085 | 28457 | 532 |
2145277 | 2145277 | 2022-01-24 | Martin | Florida | 12085 | 28457 | 532 |
2142022 | 2142022 | 2022-01-23 | Martin | Florida | 12085 | 28457 | 532 |
2138767 | 2138767 | 2022-01-22 | Martin | Florida | 12085 | 28457 | 532 |
2135511 | 2135511 | 2022-01-21 | Martin | Florida | 12085 | 28457 | 532 |
2132259 | 2132259 | 2022-01-20 | Martin | Florida | 12085 | 27099 | 532 |
2129006 | 2129006 | 2022-01-19 | Martin | Florida | 12085 | 27099 | 532 |
2131829 | 2131829 | 2022-01-19 | Kenosha | Wisconsin | 55059 | 40098 | 532 |
2114654 | 2114654 | 2022-01-14 | Blair | Pennsylvania | 42013 | 24798 | 532 |
2102582 | 2102582 | 2022-01-10 | Racine | Wisconsin | 55101 | 45953 | 532 |
2086376 | 2086376 | 2022-01-06 | Calhoun | Alabama | 1015 | 24282 | 532 |
2086684 | 2086684 | 2022-01-06 | New London | Connecticut | 9011 | 39336 | 532 |
2087122 | 2087122 | 2022-01-06 | Madison | Indiana | 18095 | 25173 | 532 |
2087156 | 2087156 | 2022-01-06 | Vanderburgh | Indiana | 18163 | 39957 | 532 |
2083124 | 2083124 | 2022-01-05 | Calhoun | Alabama | 1015 | 24047 | 532 |
2083432 | 2083432 | 2022-01-05 | New London | Connecticut | 9011 | 38819 | 532 |
2079872 | 2079872 | 2022-01-04 | Calhoun | Alabama | 1015 | 23801 | 532 |
2080180 | 2080180 | 2022-01-04 | New London | Connecticut | 9011 | 37997 | 532 |
2076620 | 2076620 | 2022-01-03 | Calhoun | Alabama | 1015 | 23694 | 532 |
2073369 | 2073369 | 2022-01-02 | Calhoun | Alabama | 1015 | 23629 | 532 |
2070118 | 2070118 | 2022-01-01 | Calhoun | Alabama | 1015 | 23411 | 532 |
2066867 | 2066867 | 2021-12-31 | Calhoun | Alabama | 1015 | 23411 | 532 |
2063617 | 2063617 | 2021-12-30 | Calhoun | Alabama | 1015 | 23242 | 532 |
2060367 | 2060367 | 2021-12-29 | Calhoun | Alabama | 1015 | 23120 | 532 |
2057118 | 2057118 | 2021-12-28 | Calhoun | Alabama | 1015 | 23011 | 532 |
2038078 | 2038078 | 2021-12-22 | Henry | Georgia | 13151 | 40449 | 532 |
2035096 | 2035096 | 2021-12-21 | Hamilton | Indiana | 18057 | 54947 | 532 |
2032287 | 2032287 | 2021-12-20 | Tangipahoa | Louisiana | 22105 | 23269 | 532 |
2029694 | 2029694 | 2021-12-19 | McKinley | New Mexico | 35031 | 17272 | 532 |
2026443 | 2026443 | 2021-12-18 | McKinley | New Mexico | 35031 | 17272 | 532 |
2023192 | 2023192 | 2021-12-17 | McKinley | New Mexico | 35031 | 17272 | 532 |
2019941 | 2019941 | 2021-12-16 | McKinley | New Mexico | 35031 | 17255 | 532 |
1970582 | 1970582 | 2021-12-01 | Barnstable | Massachusetts | 25001 | 19877 | 532 |
1946213 | 1946213 | 2021-11-23 | Wichita | Texas | 48485 | 22236 | 532 |
1942962 | 1942962 | 2021-11-22 | Wichita | Texas | 48485 | 22236 | 532 |
1939712 | 1939712 | 2021-11-21 | Wichita | Texas | 48485 | 22236 | 532 |
1915414 | 1915414 | 2021-11-14 | St. Clair | Michigan | 26147 | 24009 | 532 |
1912164 | 1912164 | 2021-11-13 | St. Clair | Michigan | 26147 | 23719 | 532 |
1908914 | 1908914 | 2021-11-12 | St. Clair | Michigan | 26147 | 23719 | 532 |
1905665 | 1905665 | 2021-11-11 | St. Clair | Michigan | 26147 | 23437 | 532 |
1902416 | 1902416 | 2021-11-10 | St. Clair | Michigan | 26147 | 23437 | 532 |
1898074 | 1898074 | 2021-11-09 | Santa Barbara | California | 6083 | 46243 | 532 |
1900122 | 1900122 | 2021-11-09 | Cambria | Pennsylvania | 42021 | 20319 | 532 |
1894824 | 1894824 | 2021-11-08 | Santa Barbara | California | 6083 | 46196 | 532 |
1891574 | 1891574 | 2021-11-07 | Santa Barbara | California | 6083 | 45996 | 532 |
1888324 | 1888324 | 2021-11-06 | Santa Barbara | California | 6083 | 45996 | 532 |
1885074 | 1885074 | 2021-11-05 | Santa Barbara | California | 6083 | 45996 | 532 |
1874542 | 1874542 | 2021-11-01 | Ector | Texas | 48135 | 25767 | 532 |
1871293 | 1871293 | 2021-10-31 | Ector | Texas | 48135 | 25767 | 532 |
1868044 | 1868044 | 2021-10-30 | Ector | Texas | 48135 | 25767 | 532 |
1853080 | 1853080 | 2021-10-26 | Elkhart | Indiana | 18039 | 36206 | 532 |
1848294 | 1848294 | 2021-10-24 | Florence | South Carolina | 45041 | 26513 | 532 |
1845044 | 1845044 | 2021-10-23 | Florence | South Carolina | 45041 | 26513 | 532 |
1845357 | 1845357 | 2021-10-23 | Johnson | Texas | 48251 | 28219 | 532 |
1841794 | 1841794 | 2021-10-22 | Florence | South Carolina | 45041 | 26513 | 532 |
1823442 | 1823442 | 2021-10-17 | Charlotte | Florida | 12015 | 22972 | 532 |
1820193 | 1820193 | 2021-10-16 | Charlotte | Florida | 12015 | 22972 | 532 |
1816944 | 1816944 | 2021-10-15 | Charlotte | Florida | 12015 | 22972 | 532 |
1806869 | 1806869 | 2021-10-12 | Baldwin | Alabama | 1003 | 36933 | 532 |
1803618 | 1803618 | 2021-10-11 | Baldwin | Alabama | 1003 | 36905 | 532 |
1800369 | 1800369 | 2021-10-10 | Baldwin | Alabama | 1003 | 36889 | 532 |
1797120 | 1797120 | 2021-10-09 | Baldwin | Alabama | 1003 | 36870 | 532 |
1759967 | 1759967 | 2021-09-27 | San Juan | New Mexico | 35045 | 18229 | 532 |
1747243 | 1747243 | 2021-09-23 | Lorain | Ohio | 39093 | 31748 | 532 |
1741948 | 1741948 | 2021-09-22 | Tuscaloosa | Alabama | 1125 | 33410 | 532 |
1743994 | 1743994 | 2021-09-22 | Lorain | Ohio | 39093 | 31567 | 532 |
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);