ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where deaths = 782 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- New York 30
- Alabama 16
- Texas 16
- Michigan 13
- California 12
- Colorado 9
- Georgia 9
- Florida 6
- North Carolina 5
- Washington 5
- Louisiana 4
- Ohio 4
- Pennsylvania 4
- Arizona 3
- Maryland 3
- Missouri 3
- New Jersey 3
- Illinois 2
- Kansas 2
- Minnesota 2
- South Carolina 2
- Delaware 1
- Idaho 1
- Indiana 1
- Massachusetts 1
- Nevada 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468314 | 2468314 | 2022-05-03 | Ottawa | Michigan | 26139 | 75339 | 782 |
2463806 | 2463806 | 2022-05-02 | Tuscaloosa | Alabama | 1125 | 56140 | 782 |
2464040 | 2464040 | 2022-05-02 | Pueblo | Colorado | 8101 | 47056 | 782 |
2465059 | 2465059 | 2022-05-02 | Ottawa | Michigan | 26139 | 75339 | 782 |
2460550 | 2460550 | 2022-05-01 | Tuscaloosa | Alabama | 1125 | 56128 | 782 |
2460784 | 2460784 | 2022-05-01 | Pueblo | Colorado | 8101 | 47036 | 782 |
2461803 | 2461803 | 2022-05-01 | Ottawa | Michigan | 26139 | 75339 | 782 |
2457294 | 2457294 | 2022-04-30 | Tuscaloosa | Alabama | 1125 | 56128 | 782 |
2457528 | 2457528 | 2022-04-30 | Pueblo | Colorado | 8101 | 47036 | 782 |
2458547 | 2458547 | 2022-04-30 | Ottawa | Michigan | 26139 | 75339 | 782 |
2454038 | 2454038 | 2022-04-29 | Tuscaloosa | Alabama | 1125 | 56128 | 782 |
2454272 | 2454272 | 2022-04-29 | Pueblo | Colorado | 8101 | 47036 | 782 |
2455291 | 2455291 | 2022-04-29 | Ottawa | Michigan | 26139 | 75339 | 782 |
2450782 | 2450782 | 2022-04-28 | Tuscaloosa | Alabama | 1125 | 56114 | 782 |
2451016 | 2451016 | 2022-04-28 | Pueblo | Colorado | 8101 | 47026 | 782 |
2452035 | 2452035 | 2022-04-28 | Ottawa | Michigan | 26139 | 75339 | 782 |
2447526 | 2447526 | 2022-04-27 | Tuscaloosa | Alabama | 1125 | 56108 | 782 |
2447760 | 2447760 | 2022-04-27 | Pueblo | Colorado | 8101 | 47000 | 782 |
2448779 | 2448779 | 2022-04-27 | Ottawa | Michigan | 26139 | 75339 | 782 |
2444270 | 2444270 | 2022-04-26 | Tuscaloosa | Alabama | 1125 | 56092 | 782 |
2444504 | 2444504 | 2022-04-26 | Pueblo | Colorado | 8101 | 46915 | 782 |
2441014 | 2441014 | 2022-04-25 | Tuscaloosa | Alabama | 1125 | 56066 | 782 |
2441248 | 2441248 | 2022-04-25 | Pueblo | Colorado | 8101 | 46893 | 782 |
2437758 | 2437758 | 2022-04-24 | Tuscaloosa | Alabama | 1125 | 56060 | 782 |
2434502 | 2434502 | 2022-04-23 | Tuscaloosa | Alabama | 1125 | 56060 | 782 |
2431246 | 2431246 | 2022-04-22 | Tuscaloosa | Alabama | 1125 | 56060 | 782 |
2400508 | 2400508 | 2022-04-12 | Oneida | New York | 36065 | 54154 | 782 |
2397253 | 2397253 | 2022-04-11 | Oneida | New York | 36065 | 54075 | 782 |
2393998 | 2393998 | 2022-04-10 | Oneida | New York | 36065 | 53999 | 782 |
2390742 | 2390742 | 2022-04-09 | Oneida | New York | 36065 | 53884 | 782 |
2387486 | 2387486 | 2022-04-08 | Oneida | New York | 36065 | 53756 | 782 |
2384231 | 2384231 | 2022-04-07 | Oneida | New York | 36065 | 53644 | 782 |
2380976 | 2380976 | 2022-04-06 | Oneida | New York | 36065 | 53521 | 782 |
2377721 | 2377721 | 2022-04-05 | Oneida | New York | 36065 | 53408 | 782 |
2374468 | 2374468 | 2022-04-04 | Oneida | New York | 36065 | 53357 | 782 |
2371216 | 2371216 | 2022-04-03 | Oneida | New York | 36065 | 53319 | 782 |
2354381 | 2354381 | 2022-03-29 | Ottawa | Michigan | 26139 | 74562 | 782 |
2351129 | 2351129 | 2022-03-28 | Ottawa | Michigan | 26139 | 74562 | 782 |
2338117 | 2338117 | 2022-03-24 | Ottawa | Michigan | 26139 | 74484 | 782 |
2339873 | 2339873 | 2022-03-24 | Clark | Washington | 53011 | 87608 | 782 |
2334863 | 2334863 | 2022-03-23 | Ottawa | Michigan | 26139 | 74484 | 782 |
2336620 | 2336620 | 2022-03-23 | Clark | Washington | 53011 | 87608 | 782 |
2333366 | 2333366 | 2022-03-22 | Clark | Washington | 53011 | 87198 | 782 |
2330112 | 2330112 | 2022-03-21 | Clark | Washington | 53011 | 87198 | 782 |
2311273 | 2311273 | 2022-03-16 | Muscogee | Georgia | 13215 | 37902 | 782 |
2286091 | 2286091 | 2022-03-08 | Anoka | Minnesota | 27003 | 97674 | 782 |
2283451 | 2283451 | 2022-03-07 | Gaston | North Carolina | 37071 | 64760 | 782 |
2242948 | 2242948 | 2022-02-23 | Hall | Georgia | 13139 | 53201 | 782 |
2217801 | 2217801 | 2022-02-15 | St. Clair | Michigan | 26147 | 39656 | 782 |
2170330 | 2170330 | 2022-01-31 | Bell | Texas | 48027 | 60491 | 782 |
2151038 | 2151038 | 2022-01-25 | Williamson | Texas | 48491 | 118260 | 782 |
2147786 | 2147786 | 2022-01-24 | Williamson | Texas | 48491 | 116531 | 782 |
2128746 | 2128746 | 2022-01-19 | Navajo | Arizona | 4017 | 31799 | 782 |
2125493 | 2125493 | 2022-01-18 | Navajo | Arizona | 4017 | 31529 | 782 |
2111916 | 2111916 | 2022-01-13 | McLennan | Texas | 48309 | 49847 | 782 |
2108664 | 2108664 | 2022-01-12 | McLennan | Texas | 48309 | 49301 | 782 |
2105413 | 2105413 | 2022-01-11 | McLennan | Texas | 48309 | 48506 | 782 |
2095160 | 2095160 | 2022-01-08 | Dauphin | Pennsylvania | 42043 | 48019 | 782 |
2031534 | 2031534 | 2021-12-20 | Clayton | Georgia | 13063 | 41623 | 782 |
2028283 | 2028283 | 2021-12-19 | Clayton | Georgia | 13063 | 41228 | 782 |
2025032 | 2025032 | 2021-12-18 | Clayton | Georgia | 13063 | 41228 | 782 |
2021781 | 2021781 | 2021-12-17 | Clayton | Georgia | 13063 | 41228 | 782 |
1985652 | 1985652 | 2021-12-06 | Montgomery | Alabama | 1101 | 34573 | 782 |
1982402 | 1982402 | 2021-12-05 | Montgomery | Alabama | 1101 | 34570 | 782 |
1979152 | 1979152 | 2021-12-04 | Montgomery | Alabama | 1101 | 34562 | 782 |
1975902 | 1975902 | 2021-12-03 | Montgomery | Alabama | 1101 | 34571 | 782 |
1972653 | 1972653 | 2021-12-02 | Montgomery | Alabama | 1101 | 34535 | 782 |
1965309 | 1965309 | 2021-11-29 | Richland | South Carolina | 45079 | 70200 | 782 |
1954985 | 1954985 | 2021-11-26 | Rockland | New York | 36087 | 55201 | 782 |
1951734 | 1951734 | 2021-11-25 | Rockland | New York | 36087 | 55139 | 782 |
1948483 | 1948483 | 2021-11-24 | Rockland | New York | 36087 | 55056 | 782 |
1945232 | 1945232 | 2021-11-23 | Rockland | New York | 36087 | 54984 | 782 |
1941981 | 1941981 | 2021-11-22 | Rockland | New York | 36087 | 54921 | 782 |
1938731 | 1938731 | 2021-11-21 | Rockland | New York | 36087 | 54877 | 782 |
1935481 | 1935481 | 2021-11-20 | Rockland | New York | 36087 | 54824 | 782 |
1932231 | 1932231 | 2021-11-19 | Rockland | New York | 36087 | 54756 | 782 |
1928980 | 1928980 | 2021-11-18 | Rockland | New York | 36087 | 54686 | 782 |
1929514 | 1929514 | 2021-11-18 | Anderson | South Carolina | 45007 | 37191 | 782 |
1925048 | 1925048 | 2021-11-17 | Anne Arundel | Maryland | 24003 | 54341 | 782 |
1925730 | 1925730 | 2021-11-17 | Rockland | New York | 36087 | 54607 | 782 |
1922481 | 1922481 | 2021-11-16 | Rockland | New York | 36087 | 54533 | 782 |
1919231 | 1919231 | 2021-11-15 | Rockland | New York | 36087 | 54467 | 782 |
1915981 | 1915981 | 2021-11-14 | Rockland | New York | 36087 | 54425 | 782 |
1912731 | 1912731 | 2021-11-13 | Rockland | New York | 36087 | 54375 | 782 |
1909481 | 1909481 | 2021-11-12 | Rockland | New York | 36087 | 54317 | 782 |
1906232 | 1906232 | 2021-11-11 | Rockland | New York | 36087 | 54249 | 782 |
1902983 | 1902983 | 2021-11-10 | Rockland | New York | 36087 | 54181 | 782 |
1899733 | 1899733 | 2021-11-09 | Rockland | New York | 36087 | 54130 | 782 |
1878906 | 1878906 | 2021-11-03 | Ada | Idaho | 16001 | 82156 | 782 |
1876980 | 1876980 | 2021-11-02 | Orange | New York | 36071 | 58517 | 782 |
1873731 | 1873731 | 2021-11-01 | Orange | New York | 36071 | 58439 | 782 |
1864939 | 1864939 | 2021-10-29 | Smith | Texas | 48423 | 36535 | 782 |
1796514 | 1796514 | 2021-10-08 | Brazoria | Texas | 48039 | 58211 | 782 |
1742592 | 1742592 | 2021-09-22 | Allen | Indiana | 18003 | 53665 | 782 |
1714424 | 1714424 | 2021-09-13 | Washoe | Nevada | 32031 | 57745 | 782 |
1702745 | 1702745 | 2021-09-09 | Spokane | Washington | 53063 | 60053 | 782 |
1691906 | 1691906 | 2021-09-06 | Wake | North Carolina | 37183 | 112726 | 782 |
1688656 | 1688656 | 2021-09-05 | Wake | North Carolina | 37183 | 112726 | 782 |
1685406 | 1685406 | 2021-09-04 | Wake | North Carolina | 37183 | 112726 | 782 |
1682155 | 1682155 | 2021-09-03 | Wake | North Carolina | 37183 | 112726 | 782 |
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);