ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 1024 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Texas 8
- New Jersey 5
- Pennsylvania 5
- California 4
- Colorado 4
- Massachusetts 4
- Tennessee 4
- Illinois 3
- Kansas 3
- Utah 3
- Arizona 2
- Connecticut 2
- Michigan 2
- Missouri 2
- New York 2
- South Carolina 2
- Washington 2
- District of Columbia 1
- Georgia 1
- Kentucky 1
- Maryland 1
- Nebraska 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333164 | 2333164 | 2022-03-22 | Webb | Texas | 48479 | 92817 | 1024 |
2329911 | 2329911 | 2022-03-21 | Webb | Texas | 48479 | 92800 | 1024 |
2326659 | 2326659 | 2022-03-20 | Webb | Texas | 48479 | 92792 | 1024 |
2323406 | 2323406 | 2022-03-19 | Webb | Texas | 48479 | 92776 | 1024 |
2320152 | 2320152 | 2022-03-18 | Webb | Texas | 48479 | 92772 | 1024 |
2212542 | 2212542 | 2022-02-13 | Hamilton | Tennessee | 47065 | 95951 | 1024 |
2209289 | 2209289 | 2022-02-12 | Hamilton | Tennessee | 47065 | 95951 | 1024 |
2206036 | 2206036 | 2022-02-11 | Hamilton | Tennessee | 47065 | 95951 | 1024 |
2192155 | 2192155 | 2022-02-07 | Douglas | Nebraska | 31055 | 139784 | 1024 |
2189518 | 2189518 | 2022-02-06 | Northampton | Pennsylvania | 42095 | 77740 | 1024 |
2186265 | 2186265 | 2022-02-05 | Northampton | Pennsylvania | 42095 | 77667 | 1024 |
2178992 | 2178992 | 2022-02-03 | Jackson | Missouri | 29095 | 90954 | 1024 |
2175740 | 2175740 | 2022-02-02 | Jackson | Missouri | 29095 | 90644 | 1024 |
2138513 | 2138513 | 2022-01-22 | Yuma | Arizona | 4027 | 54419 | 1024 |
2135257 | 2135257 | 2022-01-21 | Yuma | Arizona | 4027 | 53601 | 1024 |
2130923 | 2130923 | 2022-01-19 | Chester | Pennsylvania | 42029 | 83005 | 1024 |
2087312 | 2087312 | 2022-01-06 | Johnson | Kansas | 20091 | 99894 | 1024 |
2088165 | 2088165 | 2022-01-06 | Burlington | New Jersey | 34005 | 78653 | 1024 |
2084060 | 2084060 | 2022-01-05 | Johnson | Kansas | 20091 | 99894 | 1024 |
2005351 | 2005351 | 2021-12-12 | Adams | Colorado | 8001 | 88922 | 1024 |
2002102 | 2002102 | 2021-12-11 | Arapahoe | Colorado | 8005 | 93807 | 1024 |
1998852 | 1998852 | 2021-12-10 | Arapahoe | Colorado | 8005 | 93807 | 1024 |
1935397 | 1935397 | 2021-11-20 | Mercer | New Jersey | 34021 | 40794 | 1024 |
1905629 | 1905629 | 2021-11-11 | Kent | Michigan | 26081 | 97903 | 1024 |
1901336 | 1901336 | 2021-11-10 | Tulare | California | 6107 | 83971 | 1024 |
1902380 | 1902380 | 2021-11-10 | Kent | Michigan | 26081 | 97903 | 1024 |
1897283 | 1897283 | 2021-11-08 | Denton | Texas | 48121 | 108626 | 1024 |
1897688 | 1897688 | 2021-11-08 | Spokane | Washington | 53063 | 75019 | 1024 |
1868794 | 1868794 | 2021-10-31 | Contra Costa | California | 6013 | 100757 | 1024 |
1865545 | 1865545 | 2021-10-30 | Contra Costa | California | 6013 | 100757 | 1024 |
1862296 | 1862296 | 2021-10-29 | Contra Costa | California | 6013 | 100757 | 1024 |
1829155 | 1829155 | 2021-10-18 | Montgomery | Texas | 48339 | 86884 | 1024 |
1784389 | 1784389 | 2021-10-05 | El Paso | Colorado | 8041 | 93412 | 1024 |
1712294 | 1712294 | 2021-09-12 | Salt Lake | Utah | 49035 | 174854 | 1024 |
1709047 | 1709047 | 2021-09-11 | Salt Lake | Utah | 49035 | 174854 | 1024 |
1705800 | 1705800 | 2021-09-10 | Salt Lake | Utah | 49035 | 174854 | 1024 |
1406584 | 1406584 | 2021-06-10 | Greenville | South Carolina | 45045 | 75352 | 1024 |
1403338 | 1403338 | 2021-06-09 | Greenville | South Carolina | 45045 | 75337 | 1024 |
1377787 | 1377787 | 2021-06-01 | Travis | Texas | 48453 | 83722 | 1024 |
1316934 | 1316934 | 2021-05-14 | DeKalb | Georgia | 13089 | 66539 | 1024 |
1204726 | 1204726 | 2021-04-09 | Monroe | New York | 36055 | 58775 | 1024 |
1201478 | 1201478 | 2021-04-08 | Monroe | New York | 36055 | 58456 | 1024 |
1187261 | 1187261 | 2021-04-04 | Lake | Illinois | 17097 | 62746 | 1024 |
1184014 | 1184014 | 2021-04-03 | Lake | Illinois | 17097 | 62686 | 1024 |
1151884 | 1151884 | 2021-03-24 | Unknown | Kansas | 0 | 1024 | |
1142206 | 1142206 | 2021-03-21 | Jefferson | Kentucky | 21111 | 76835 | 1024 |
1086283 | 1086283 | 2021-03-04 | District of Columbia | District of Columbia | 11001 | 41014 | 1024 |
987139 | 987139 | 2021-02-01 | Camden | New Jersey | 34007 | 40534 | 1024 |
922721 | 922721 | 2021-01-12 | Delaware | Pennsylvania | 42045 | 33132 | 1024 |
919476 | 919476 | 2021-01-11 | Delaware | Pennsylvania | 42045 | 32836 | 1024 |
913306 | 913306 | 2021-01-09 | Shelby | Tennessee | 47157 | 73817 | 1024 |
878869 | 878869 | 2020-12-30 | DuPage | Illinois | 17043 | 61271 | 1024 |
878075 | 878075 | 2020-12-29 | King | Washington | 53033 | 61457 | 1024 |
863256 | 863256 | 2020-12-25 | Hampden | Massachusetts | 25013 | 24198 | 1024 |
860011 | 860011 | 2020-12-24 | Hampden | Massachusetts | 25013 | 24198 | 1024 |
827540 | 827540 | 2020-12-14 | Montgomery | Maryland | 24031 | 39765 | 1024 |
452163 | 452163 | 2020-08-20 | Ocean | New Jersey | 34029 | 10903 | 1024 |
335866 | 335866 | 2020-07-15 | Suffolk | Massachusetts | 25025 | 20411 | 1024 |
224912 | 224912 | 2020-06-10 | New Haven | Connecticut | 9009 | 11911 | 1024 |
225804 | 225804 | 2020-06-10 | Essex | Massachusetts | 25009 | 15365 | 1024 |
177137 | 177137 | 2020-05-25 | Union | New Jersey | 34039 | 15218 | 1024 |
130530 | 130530 | 2020-05-10 | Fairfield | Connecticut | 9001 | 13236 | 1024 |
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);