ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where deaths = 932 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Ohio 17
- South Carolina 13
- Virginia 11
- Alabama 8
- California 8
- Pennsylvania 8
- Tennessee 8
- North Carolina 6
- Kansas 5
- New Jersey 5
- Utah 4
- Colorado 3
- Delaware 3
- Georgia 3
- Illinois 3
- Louisiana 3
- Minnesota 3
- New York 3
- Texas 3
- Arkansas 2
- Florida 2
- Maryland 2
- District of Columbia 1
- Michigan 1
- Nebraska 1
- New Mexico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466735 | 2466735 | 2022-05-02 | Henrico | Virginia | 51087 | 65913 | 932 |
2463480 | 2463480 | 2022-05-01 | Henrico | Virginia | 51087 | 65716 | 932 |
2460224 | 2460224 | 2022-04-30 | Henrico | Virginia | 51087 | 65716 | 932 |
2456968 | 2456968 | 2022-04-29 | Henrico | Virginia | 51087 | 65716 | 932 |
2453712 | 2453712 | 2022-04-28 | Henrico | Virginia | 51087 | 65645 | 932 |
2450456 | 2450456 | 2022-04-27 | Henrico | Virginia | 51087 | 65589 | 932 |
2447199 | 2447199 | 2022-04-26 | Henrico | Virginia | 51087 | 65546 | 932 |
2443944 | 2443944 | 2022-04-25 | Henrico | Virginia | 51087 | 65467 | 932 |
2440688 | 2440688 | 2022-04-24 | Henrico | Virginia | 51087 | 65319 | 932 |
2437432 | 2437432 | 2022-04-23 | Henrico | Virginia | 51087 | 65319 | 932 |
2434176 | 2434176 | 2022-04-22 | Henrico | Virginia | 51087 | 65319 | 932 |
2395421 | 2395421 | 2022-04-11 | Montgomery | Alabama | 1101 | 54773 | 932 |
2392165 | 2392165 | 2022-04-10 | Montgomery | Alabama | 1101 | 54753 | 932 |
2388909 | 2388909 | 2022-04-09 | Montgomery | Alabama | 1101 | 54753 | 932 |
2385654 | 2385654 | 2022-04-08 | Montgomery | Alabama | 1101 | 54753 | 932 |
2382399 | 2382399 | 2022-04-07 | Montgomery | Alabama | 1101 | 54750 | 932 |
2379144 | 2379144 | 2022-04-06 | Montgomery | Alabama | 1101 | 54741 | 932 |
2381239 | 2381239 | 2022-04-06 | Trumbull | Ohio | 39155 | 41483 | 932 |
2375890 | 2375890 | 2022-04-05 | Montgomery | Alabama | 1101 | 54731 | 932 |
2377984 | 2377984 | 2022-04-05 | Trumbull | Ohio | 39155 | 41483 | 932 |
2374730 | 2374730 | 2022-04-04 | Trumbull | Ohio | 39155 | 41483 | 932 |
2375047 | 2375047 | 2022-04-04 | Richland | South Carolina | 45079 | 122129 | 932 |
2371478 | 2371478 | 2022-04-03 | Trumbull | Ohio | 39155 | 41483 | 932 |
2371795 | 2371795 | 2022-04-03 | Richland | South Carolina | 45079 | 122129 | 932 |
2368225 | 2368225 | 2022-04-02 | Trumbull | Ohio | 39155 | 41483 | 932 |
2368542 | 2368542 | 2022-04-02 | Richland | South Carolina | 45079 | 122129 | 932 |
2364972 | 2364972 | 2022-04-01 | Trumbull | Ohio | 39155 | 41483 | 932 |
2365289 | 2365289 | 2022-04-01 | Richland | South Carolina | 45079 | 122129 | 932 |
2361719 | 2361719 | 2022-03-31 | Trumbull | Ohio | 39155 | 41483 | 932 |
2362036 | 2362036 | 2022-03-31 | Richland | South Carolina | 45079 | 122129 | 932 |
2358782 | 2358782 | 2022-03-30 | Richland | South Carolina | 45079 | 122129 | 932 |
2355528 | 2355528 | 2022-03-29 | Richland | South Carolina | 45079 | 122129 | 932 |
2327088 | 2327088 | 2022-03-21 | Madison | Alabama | 1089 | 88911 | 932 |
2231366 | 2231366 | 2022-02-19 | Orange | New York | 36071 | 105036 | 932 |
2228115 | 2228115 | 2022-02-18 | Orange | New York | 36071 | 104966 | 932 |
2188997 | 2188997 | 2022-02-06 | Atlantic | New Jersey | 34001 | 66917 | 932 |
2185744 | 2185744 | 2022-02-05 | Atlantic | New Jersey | 34001 | 66841 | 932 |
2084816 | 2084816 | 2022-01-05 | Douglas | Nebraska | 31055 | 107918 | 932 |
2079057 | 2079057 | 2022-01-03 | Horry | South Carolina | 45051 | 67157 | 932 |
2075806 | 2075806 | 2022-01-02 | Horry | South Carolina | 45051 | 67157 | 932 |
2072555 | 2072555 | 2022-01-01 | Horry | South Carolina | 45051 | 67157 | 932 |
2069304 | 2069304 | 2021-12-31 | Horry | South Carolina | 45051 | 67157 | 932 |
2029809 | 2029809 | 2021-12-19 | Guilford | North Carolina | 37081 | 73138 | 932 |
2026558 | 2026558 | 2021-12-18 | Guilford | North Carolina | 37081 | 73138 | 932 |
2023307 | 2023307 | 2021-12-17 | Guilford | North Carolina | 37081 | 73138 | 932 |
2020056 | 2020056 | 2021-12-16 | Guilford | North Carolina | 37081 | 72981 | 932 |
2016805 | 2016805 | 2021-12-15 | Guilford | North Carolina | 37081 | 72787 | 932 |
2013555 | 2013555 | 2021-12-14 | Guilford | North Carolina | 37081 | 72566 | 932 |
1966796 | 1966796 | 2021-11-30 | Unknown | Illinois | 0 | 932 | |
1940265 | 1940265 | 2021-11-22 | Pulaski | Arkansas | 5119 | 59803 | 932 |
1937015 | 1937015 | 2021-11-21 | Pulaski | Arkansas | 5119 | 59775 | 932 |
1911089 | 1911089 | 2021-11-13 | Adams | Colorado | 8001 | 81889 | 932 |
1897172 | 1897172 | 2021-11-08 | Knox | Tennessee | 47093 | 79125 | 932 |
1893922 | 1893922 | 2021-11-07 | Knox | Tennessee | 47093 | 79125 | 932 |
1890672 | 1890672 | 2021-11-06 | Knox | Tennessee | 47093 | 79125 | 932 |
1887422 | 1887422 | 2021-11-05 | Knox | Tennessee | 47093 | 79125 | 932 |
1884172 | 1884172 | 2021-11-04 | Knox | Tennessee | 47093 | 79059 | 932 |
1880923 | 1880923 | 2021-11-03 | Knox | Tennessee | 47093 | 78979 | 932 |
1869543 | 1869543 | 2021-10-31 | Johnson | Kansas | 20091 | 78177 | 932 |
1866294 | 1866294 | 2021-10-30 | Johnson | Kansas | 20091 | 78177 | 932 |
1867656 | 1867656 | 2021-10-30 | Luzerne | Pennsylvania | 42079 | 41071 | 932 |
1863045 | 1863045 | 2021-10-29 | Johnson | Kansas | 20091 | 78177 | 932 |
1859101 | 1859101 | 2021-10-28 | Arapahoe | Colorado | 8005 | 81608 | 932 |
1853002 | 1853002 | 2021-10-26 | Kane | Illinois | 17089 | 68883 | 932 |
1838411 | 1838411 | 2021-10-21 | Lehigh | Pennsylvania | 42077 | 47872 | 932 |
1825815 | 1825815 | 2021-10-17 | Fort Bend | Texas | 48157 | 98307 | 932 |
1822566 | 1822566 | 2021-10-16 | Fort Bend | Texas | 48157 | 98307 | 932 |
1819317 | 1819317 | 2021-10-15 | Fort Bend | Texas | 48157 | 98307 | 932 |
1811912 | 1811912 | 2021-10-13 | Burlington | New Jersey | 34005 | 53387 | 932 |
1800608 | 1800608 | 2021-10-10 | Tulare | California | 6107 | 77528 | 932 |
1797359 | 1797359 | 2021-10-09 | Tulare | California | 6107 | 77528 | 932 |
1794110 | 1794110 | 2021-10-08 | Tulare | California | 6107 | 77528 | 932 |
1768859 | 1768859 | 2021-09-30 | Sedgwick | Kansas | 20173 | 76285 | 932 |
1765610 | 1765610 | 2021-09-29 | Sedgwick | Kansas | 20173 | 76285 | 932 |
1694546 | 1694546 | 2021-09-07 | Ramsey | Minnesota | 27123 | 56935 | 932 |
1667486 | 1667486 | 2021-08-30 | New Castle | Delaware | 10003 | 69877 | 932 |
1664239 | 1664239 | 2021-08-29 | New Castle | Delaware | 10003 | 69660 | 932 |
1660991 | 1660991 | 2021-08-28 | New Castle | Delaware | 10003 | 69507 | 932 |
1647945 | 1647945 | 2021-08-24 | El Paso | Colorado | 8041 | 80680 | 932 |
1574107 | 1574107 | 2021-08-01 | Jefferson | Louisiana | 22051 | 52912 | 932 |
1570859 | 1570859 | 2021-07-31 | Jefferson | Louisiana | 22051 | 52912 | 932 |
1567611 | 1567611 | 2021-07-30 | Jefferson | Louisiana | 22051 | 52912 | 932 |
1553123 | 1553123 | 2021-07-25 | Salt Lake | Utah | 49035 | 157373 | 932 |
1549876 | 1549876 | 2021-07-24 | Salt Lake | Utah | 49035 | 157373 | 932 |
1546629 | 1546629 | 2021-07-23 | Salt Lake | Utah | 49035 | 157373 | 932 |
1543382 | 1543382 | 2021-07-22 | Salt Lake | Utah | 49035 | 157373 | 932 |
1474438 | 1474438 | 2021-07-01 | Stark | Ohio | 39151 | 33423 | 932 |
1471192 | 1471192 | 2021-06-30 | Stark | Ohio | 39151 | 33409 | 932 |
1467947 | 1467947 | 2021-06-29 | Stark | Ohio | 39151 | 33410 | 932 |
1337247 | 1337247 | 2021-05-20 | Genesee | Michigan | 26049 | 41346 | 932 |
1289096 | 1289096 | 2021-05-05 | Bernalillo | New Mexico | 35001 | 57274 | 932 |
1289828 | 1289828 | 2021-05-05 | Davidson | Tennessee | 47037 | 98420 | 932 |
1286582 | 1286582 | 2021-05-04 | Davidson | Tennessee | 47037 | 98409 | 932 |
1282927 | 1282927 | 2021-05-03 | Summit | Ohio | 39153 | 46774 | 932 |
1279680 | 1279680 | 2021-05-02 | Summit | Ohio | 39153 | 46703 | 932 |
1276433 | 1276433 | 2021-05-01 | Summit | Ohio | 39153 | 46637 | 932 |
1273186 | 1273186 | 2021-04-30 | Summit | Ohio | 39153 | 46527 | 932 |
1196713 | 1196713 | 2021-04-07 | Lee | Florida | 12071 | 63956 | 932 |
1195377 | 1195377 | 2021-04-06 | Berks | Pennsylvania | 42011 | 41042 | 932 |
1192129 | 1192129 | 2021-04-05 | Berks | Pennsylvania | 42011 | 40836 | 932 |
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);