ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where deaths = 911 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Louisiana 10
- Pennsylvania 8
- Minnesota 7
- North Carolina 7
- New Jersey 6
- Ohio 6
- Florida 4
- Kansas 4
- Arizona 3
- Michigan 3
- Nevada 3
- South Carolina 3
- Texas 3
- Colorado 2
- Massachusetts 2
- New Mexico 2
- Oregon 2
- Tennessee 2
- California 1
- Georgia 1
- Indiana 1
- Missouri 1
- New Hampshire 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465534 | 2465534 | 2022-05-02 | Hillsborough | New Hampshire | 33011 | 99872 | 911 |
2382085 | 2382085 | 2022-04-06 | Henrico | Virginia | 51087 | 64344 | 911 |
2293694 | 2293694 | 2022-03-10 | Charleston | South Carolina | 45019 | 111163 | 911 |
2281931 | 2281931 | 2022-03-07 | Clayton | Georgia | 13063 | 63248 | 911 |
2225093 | 2225093 | 2022-02-17 | Lorain | Ohio | 39093 | 65907 | 911 |
2221842 | 2221842 | 2022-02-16 | Lorain | Ohio | 39093 | 65884 | 911 |
2222154 | 2222154 | 2022-02-16 | Anderson | South Carolina | 45007 | 57146 | 911 |
2218591 | 2218591 | 2022-02-15 | Lorain | Ohio | 39093 | 65856 | 911 |
2205272 | 2205272 | 2022-02-11 | Gloucester | New Jersey | 34015 | 68249 | 911 |
2202019 | 2202019 | 2022-02-10 | Gloucester | New Jersey | 34015 | 68153 | 911 |
2163827 | 2163827 | 2022-01-29 | Brazoria | Texas | 48039 | 88081 | 911 |
2101938 | 2101938 | 2022-01-10 | Hamilton | Tennessee | 47065 | 76545 | 911 |
2091431 | 2091431 | 2022-01-07 | Somerset | New Jersey | 34035 | 54839 | 911 |
2088180 | 2088180 | 2022-01-06 | Somerset | New Jersey | 34035 | 53355 | 911 |
2085373 | 2085373 | 2022-01-05 | Multnomah | Oregon | 41051 | 70432 | 911 |
2082121 | 2082121 | 2022-01-04 | Multnomah | Oregon | 41051 | 69166 | 911 |
2007104 | 2007104 | 2021-12-12 | Wake | North Carolina | 37183 | 137498 | 911 |
2003853 | 2003853 | 2021-12-11 | Wake | North Carolina | 37183 | 137498 | 911 |
2000602 | 2000602 | 2021-12-10 | Wake | North Carolina | 37183 | 137498 | 911 |
1997352 | 1997352 | 2021-12-09 | Wake | North Carolina | 37183 | 137145 | 911 |
1994101 | 1994101 | 2021-12-08 | Wake | North Carolina | 37183 | 136639 | 911 |
1990850 | 1990850 | 2021-12-07 | Wake | North Carolina | 37183 | 136441 | 911 |
1987599 | 1987599 | 2021-12-06 | Wake | North Carolina | 37183 | 136320 | 911 |
1893126 | 1893126 | 2021-11-07 | Washoe | Nevada | 32031 | 66051 | 911 |
1889876 | 1889876 | 2021-11-06 | Washoe | Nevada | 32031 | 66051 | 911 |
1885091 | 1885091 | 2021-11-05 | Adams | Colorado | 8001 | 79531 | 911 |
1886626 | 1886626 | 2021-11-05 | Washoe | Nevada | 32031 | 66051 | 911 |
1881707 | 1881707 | 2021-11-04 | Yuma | Arizona | 4027 | 41802 | 911 |
1878458 | 1878458 | 2021-11-03 | Yuma | Arizona | 4027 | 41725 | 911 |
1838683 | 1838683 | 2021-10-21 | Knox | Tennessee | 47093 | 78054 | 911 |
1816861 | 1816861 | 2021-10-15 | Arapahoe | Colorado | 8005 | 78701 | 911 |
1814308 | 1814308 | 2021-10-14 | Johnson | Kansas | 20091 | 76453 | 911 |
1811059 | 1811059 | 2021-10-13 | Johnson | Kansas | 20091 | 76453 | 911 |
1807810 | 1807810 | 2021-10-12 | Johnson | Kansas | 20091 | 76202 | 911 |
1804559 | 1804559 | 2021-10-11 | Johnson | Kansas | 20091 | 76202 | 911 |
1783178 | 1783178 | 2021-10-04 | Lehigh | Pennsylvania | 42077 | 46432 | 911 |
1779929 | 1779929 | 2021-10-03 | Lehigh | Pennsylvania | 42077 | 46321 | 911 |
1764172 | 1764172 | 2021-09-28 | Montgomery | Texas | 48339 | 84476 | 911 |
1759260 | 1759260 | 2021-09-27 | Caddo | Louisiana | 22017 | 38098 | 911 |
1745239 | 1745239 | 2021-09-23 | Mohave | Arizona | 4015 | 30677 | 911 |
1747912 | 1747912 | 2021-09-23 | Lubbock | Texas | 48303 | 62969 | 911 |
1733422 | 1733422 | 2021-09-19 | Kent | Michigan | 26081 | 81902 | 911 |
1730172 | 1730172 | 2021-09-18 | Kent | Michigan | 26081 | 81902 | 911 |
1726922 | 1726922 | 2021-09-17 | Kent | Michigan | 26081 | 81902 | 911 |
1727433 | 1727433 | 2021-09-17 | Burlington | New Jersey | 34005 | 50535 | 911 |
1719333 | 1719333 | 2021-09-15 | Contra Costa | California | 6013 | 94702 | 911 |
1692367 | 1692367 | 2021-09-06 | Spartanburg | South Carolina | 45083 | 51764 | 911 |
1584095 | 1584095 | 2021-08-04 | Ramsey | Minnesota | 27123 | 53670 | 911 |
1574349 | 1574349 | 2021-08-01 | Ramsey | Minnesota | 27123 | 53350 | 911 |
1571101 | 1571101 | 2021-07-31 | Ramsey | Minnesota | 27123 | 53350 | 911 |
1567853 | 1567853 | 2021-07-30 | Ramsey | Minnesota | 27123 | 53350 | 911 |
1564605 | 1564605 | 2021-07-29 | Ramsey | Minnesota | 27123 | 53281 | 911 |
1561357 | 1561357 | 2021-07-28 | Ramsey | Minnesota | 27123 | 53242 | 911 |
1558109 | 1558109 | 2021-07-27 | Ramsey | Minnesota | 27123 | 53172 | 911 |
1496175 | 1496175 | 2021-07-08 | Jefferson | Louisiana | 22051 | 47940 | 911 |
1492929 | 1492929 | 2021-07-07 | Jefferson | Louisiana | 22051 | 47877 | 911 |
1489682 | 1489682 | 2021-07-06 | Jefferson | Louisiana | 22051 | 47816 | 911 |
1486435 | 1486435 | 2021-07-05 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1483189 | 1483189 | 2021-07-04 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1479942 | 1479942 | 2021-07-03 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1476696 | 1476696 | 2021-07-02 | Jefferson | Louisiana | 22051 | 47666 | 911 |
1473450 | 1473450 | 2021-07-01 | Jefferson | Louisiana | 22051 | 47640 | 911 |
1470204 | 1470204 | 2021-06-30 | Jefferson | Louisiana | 22051 | 47582 | 911 |
1338116 | 1338116 | 2021-05-20 | Stark | Ohio | 39151 | 32835 | 911 |
1334869 | 1334869 | 2021-05-19 | Stark | Ohio | 39151 | 32776 | 911 |
1331622 | 1331622 | 2021-05-18 | Stark | Ohio | 39151 | 32726 | 911 |
1224155 | 1224155 | 2021-04-15 | Bernalillo | New Mexico | 35001 | 55801 | 911 |
1220908 | 1220908 | 2021-04-14 | Bernalillo | New Mexico | 35001 | 55737 | 911 |
1204656 | 1204656 | 2021-04-09 | Mercer | New Jersey | 34021 | 31845 | 911 |
1148006 | 1148006 | 2021-03-23 | Marion | Florida | 12083 | 28677 | 911 |
1120692 | 1120692 | 2021-03-14 | Berks | Pennsylvania | 42011 | 37166 | 911 |
1117445 | 1117445 | 2021-03-13 | Berks | Pennsylvania | 42011 | 37061 | 911 |
1114198 | 1114198 | 2021-03-12 | Berks | Pennsylvania | 42011 | 36951 | 911 |
1110952 | 1110952 | 2021-03-11 | Berks | Pennsylvania | 42011 | 36740 | 911 |
1107706 | 1107706 | 2021-03-10 | Berks | Pennsylvania | 42011 | 36611 | 911 |
1073727 | 1073727 | 2021-02-28 | Lake | Indiana | 18089 | 48464 | 911 |
982434 | 982434 | 2021-01-31 | Duval | Florida | 12031 | 81927 | 911 |
977903 | 977903 | 2021-01-29 | Lancaster | Pennsylvania | 42071 | 37912 | 911 |
798351 | 798351 | 2020-12-05 | Plymouth | Massachusetts | 25023 | 16142 | 911 |
787752 | 787752 | 2020-12-02 | Pinellas | Florida | 12103 | 33493 | 911 |
784508 | 784508 | 2020-12-01 | Pinellas | Florida | 12103 | 33246 | 911 |
782122 | 782122 | 2020-11-30 | Hampden | Massachusetts | 25013 | 16143 | 911 |
724070 | 724070 | 2020-11-12 | St. Louis | Missouri | 29189 | 38620 | 911 |
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);