ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where deaths = 1058 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Ohio 8
- Pennsylvania 8
- Colorado 7
- Hawaii 7
- Indiana 6
- California 5
- Georgia 4
- Massachusetts 4
- Florida 3
- Maryland 3
- South Carolina 3
- Tennessee 3
- Illinois 2
- Texas 2
- Arizona 1
- Arkansas 1
- Louisiana 1
- Michigan 1
- Nevada 1
- New Jersey 1
- New York 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490354 | 2490354 | 2022-05-10 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2487097 | 2487097 | 2022-05-09 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2483839 | 2483839 | 2022-05-08 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2480581 | 2480581 | 2022-05-07 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2477323 | 2477323 | 2022-05-06 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2474065 | 2474065 | 2022-05-05 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2470808 | 2470808 | 2022-05-04 | Honolulu | Hawaii | 15003 | 174618 | 1058 |
2449348 | 2449348 | 2022-04-27 | Onondaga | New York | 36067 | 118676 | 1058 |
2351021 | 2351021 | 2022-03-28 | Anne Arundel | Maryland | 24003 | 89088 | 1058 |
2347768 | 2347768 | 2022-03-27 | Anne Arundel | Maryland | 24003 | 89063 | 1058 |
2307910 | 2307910 | 2022-03-15 | Unknown | Florida | 3875 | 1058 | |
2235299 | 2235299 | 2022-02-20 | Hamilton | Tennessee | 47065 | 96778 | 1058 |
2231799 | 2231799 | 2022-02-19 | Northampton | Pennsylvania | 42095 | 78545 | 1058 |
2232048 | 2232048 | 2022-02-19 | Hamilton | Tennessee | 47065 | 96778 | 1058 |
2228548 | 2228548 | 2022-02-18 | Northampton | Pennsylvania | 42095 | 78445 | 1058 |
2228797 | 2228797 | 2022-02-18 | Hamilton | Tennessee | 47065 | 96778 | 1058 |
2197135 | 2197135 | 2022-02-09 | Pulaski | Arkansas | 5119 | 99639 | 1058 |
2168846 | 2168846 | 2022-01-31 | Orleans | Louisiana | 22071 | 83051 | 1058 |
2169971 | 2169971 | 2022-01-31 | Chester | Pennsylvania | 42029 | 87448 | 1058 |
2166717 | 2166717 | 2022-01-30 | Chester | Pennsylvania | 42029 | 87343 | 1058 |
2154779 | 2154779 | 2022-01-27 | Yavapai | Arizona | 4025 | 43582 | 1058 |
2145619 | 2145619 | 2022-01-24 | Allen | Indiana | 18003 | 96546 | 1058 |
2133690 | 2133690 | 2022-01-20 | Burlington | New Jersey | 34005 | 92975 | 1058 |
2047609 | 2047609 | 2021-12-25 | Arapahoe | Colorado | 8005 | 97697 | 1058 |
2044359 | 2044359 | 2021-12-24 | Arapahoe | Colorado | 8005 | 97089 | 1058 |
2041110 | 2041110 | 2021-12-23 | Arapahoe | Colorado | 8005 | 96497 | 1058 |
2037860 | 2037860 | 2021-12-22 | Arapahoe | Colorado | 8005 | 96497 | 1058 |
2033223 | 2033223 | 2021-12-20 | Lucas | Ohio | 39095 | 66935 | 1058 |
2028123 | 2028123 | 2021-12-19 | Denver | Colorado | 8031 | 106128 | 1058 |
2029973 | 2029973 | 2021-12-19 | Lucas | Ohio | 39095 | 66731 | 1058 |
2024872 | 2024872 | 2021-12-18 | Denver | Colorado | 8031 | 106128 | 1058 |
2026722 | 2026722 | 2021-12-18 | Lucas | Ohio | 39095 | 66578 | 1058 |
2021621 | 2021621 | 2021-12-17 | Denver | Colorado | 8031 | 106128 | 1058 |
2023471 | 2023471 | 2021-12-17 | Lucas | Ohio | 39095 | 66348 | 1058 |
1995547 | 1995547 | 2021-12-09 | Contra Costa | California | 6013 | 104962 | 1058 |
1992296 | 1992296 | 2021-12-08 | Contra Costa | California | 6013 | 104815 | 1058 |
1989045 | 1989045 | 2021-12-07 | Contra Costa | California | 6013 | 104721 | 1058 |
1985795 | 1985795 | 2021-12-06 | Contra Costa | California | 6013 | 104645 | 1058 |
1981879 | 1981879 | 2021-12-04 | Lubbock | Texas | 48303 | 68477 | 1058 |
1948928 | 1948928 | 2021-11-24 | York | Pennsylvania | 42133 | 69066 | 1058 |
1705174 | 1705174 | 2021-09-10 | Berks | Pennsylvania | 42011 | 52092 | 1058 |
1701924 | 1701924 | 2021-09-09 | Berks | Pennsylvania | 42011 | 51980 | 1058 |
1643621 | 1643621 | 2021-08-22 | Greenville | South Carolina | 45045 | 82298 | 1058 |
1640371 | 1640371 | 2021-08-21 | Greenville | South Carolina | 45045 | 82298 | 1058 |
1637121 | 1637121 | 2021-08-20 | Greenville | South Carolina | 45045 | 82298 | 1058 |
1510131 | 1510131 | 2021-07-12 | Montgomery | Ohio | 39113 | 52831 | 1058 |
1506884 | 1506884 | 2021-07-11 | Montgomery | Ohio | 39113 | 52819 | 1058 |
1503638 | 1503638 | 2021-07-10 | Montgomery | Ohio | 39113 | 52793 | 1058 |
1500392 | 1500392 | 2021-07-09 | Montgomery | Ohio | 39113 | 52748 | 1058 |
1486038 | 1486038 | 2021-07-05 | Lake | Indiana | 18089 | 56346 | 1058 |
1482792 | 1482792 | 2021-07-04 | Lake | Indiana | 18089 | 56346 | 1058 |
1479545 | 1479545 | 2021-07-03 | Lake | Indiana | 18089 | 56346 | 1058 |
1476299 | 1476299 | 2021-07-02 | Lake | Indiana | 18089 | 56346 | 1058 |
1473053 | 1473053 | 2021-07-01 | Lake | Indiana | 18089 | 56270 | 1058 |
1326663 | 1326663 | 2021-05-17 | Cobb | Georgia | 13067 | 79287 | 1058 |
1323417 | 1323417 | 2021-05-16 | Cobb | Georgia | 13067 | 79251 | 1058 |
1320171 | 1320171 | 2021-05-15 | Cobb | Georgia | 13067 | 79218 | 1058 |
1316924 | 1316924 | 2021-05-14 | Cobb | Georgia | 13067 | 79173 | 1058 |
1310657 | 1310657 | 2021-05-12 | Lake | Illinois | 17097 | 67029 | 1058 |
1306997 | 1306997 | 2021-05-11 | Stanislaus | California | 6099 | 62058 | 1058 |
1294980 | 1294980 | 2021-05-07 | Baltimore city | Maryland | 24510 | 51766 | 1058 |
1291229 | 1291229 | 2021-05-06 | Will | Illinois | 17197 | 74655 | 1058 |
1225304 | 1225304 | 2021-04-15 | Fairfax | Virginia | 51059 | 74009 | 1058 |
1110982 | 1110982 | 2021-03-11 | Lancaster | Pennsylvania | 42071 | 44965 | 1058 |
915186 | 915186 | 2021-01-10 | Plymouth | Massachusetts | 25023 | 28588 | 1058 |
868862 | 868862 | 2020-12-27 | Hillsborough | Florida | 12057 | 74368 | 1058 |
865617 | 865617 | 2020-12-26 | Hillsborough | Florida | 12057 | 73980 | 1058 |
631045 | 631045 | 2020-10-14 | Cameron | Texas | 48061 | 23612 | 1058 |
574521 | 574521 | 2020-09-27 | Norfolk | Massachusetts | 25021 | 10247 | 1058 |
571278 | 571278 | 2020-09-26 | Norfolk | Massachusetts | 25021 | 10212 | 1058 |
468266 | 468266 | 2020-08-25 | Clark | Nevada | 32003 | 57131 | 1058 |
393606 | 393606 | 2020-08-02 | Suffolk | Massachusetts | 25025 | 21355 | 1058 |
225877 | 225877 | 2020-06-10 | Oakland | Michigan | 26125 | 11262 | 1058 |
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);