ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where deaths = 904 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Florida 28
- Ohio 11
- New Jersey 9
- Tennessee 9
- Pennsylvania 7
- Illinois 6
- North Carolina 6
- California 5
- Arizona 4
- Indiana 4
- Colorado 3
- Michigan 3
- Missouri 3
- New Mexico 3
- New York 3
- South Carolina 3
- Alabama 2
- Georgia 2
- Idaho 2
- Nevada 2
- Texas 2
- Minnesota 1
- New Hampshire 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502185 | 2502185 | 2022-05-13 | Rutherford | Tennessee | 47149 | 96372 | 904 |
2498927 | 2498927 | 2022-05-12 | Rutherford | Tennessee | 47149 | 96372 | 904 |
2495669 | 2495669 | 2022-05-11 | Rutherford | Tennessee | 47149 | 96372 | 904 |
2397161 | 2397161 | 2022-04-11 | Hillsborough | New Hampshire | 33011 | 97579 | 904 |
2362565 | 2362565 | 2022-03-31 | Henrico | Virginia | 51087 | 64166 | 904 |
2309122 | 2309122 | 2022-03-15 | St. Charles | Missouri | 29183 | 101323 | 904 |
2304323 | 2304323 | 2022-03-14 | Montgomery | Alabama | 1101 | 54559 | 904 |
2284805 | 2284805 | 2022-03-08 | Madison | Alabama | 1089 | 88518 | 904 |
2283938 | 2283938 | 2022-03-07 | Charleston | South Carolina | 45019 | 111104 | 904 |
2218903 | 2218903 | 2022-02-15 | Anderson | South Carolina | 45007 | 57100 | 904 |
2215652 | 2215652 | 2022-02-14 | Anderson | South Carolina | 45007 | 57053 | 904 |
2171275 | 2171275 | 2022-02-01 | Collier | Florida | 12021 | 78527 | 904 |
2168022 | 2168022 | 2022-01-31 | Collier | Florida | 12021 | 78527 | 904 |
2164767 | 2164767 | 2022-01-30 | Collier | Florida | 12021 | 78527 | 904 |
2161512 | 2161512 | 2022-01-29 | Collier | Florida | 12021 | 78527 | 904 |
2158256 | 2158256 | 2022-01-28 | Collier | Florida | 12021 | 78527 | 904 |
2159806 | 2159806 | 2022-01-28 | Orange | New York | 36071 | 102371 | 904 |
2155003 | 2155003 | 2022-01-27 | Collier | Florida | 12021 | 76187 | 904 |
2151750 | 2151750 | 2022-01-26 | Collier | Florida | 12021 | 76187 | 904 |
2153210 | 2153210 | 2022-01-26 | Atlantic | New Jersey | 34001 | 65160 | 904 |
2154063 | 2154063 | 2022-01-26 | Brazoria | Texas | 48039 | 86956 | 904 |
2142216 | 2142216 | 2022-01-23 | Ada | Idaho | 16001 | 99096 | 904 |
2138961 | 2138961 | 2022-01-22 | Ada | Idaho | 16001 | 99096 | 904 |
2125767 | 2125767 | 2022-01-18 | Seminole | Florida | 12117 | 86316 | 904 |
2122515 | 2122515 | 2022-01-17 | Seminole | Florida | 12117 | 86316 | 904 |
2119263 | 2119263 | 2022-01-16 | Seminole | Florida | 12117 | 86316 | 904 |
2116011 | 2116011 | 2022-01-15 | Seminole | Florida | 12117 | 86316 | 904 |
2112760 | 2112760 | 2022-01-14 | Seminole | Florida | 12117 | 86316 | 904 |
2109508 | 2109508 | 2022-01-13 | Seminole | Florida | 12117 | 78133 | 904 |
2106257 | 2106257 | 2022-01-12 | Seminole | Florida | 12117 | 78133 | 904 |
2103006 | 2103006 | 2022-01-11 | Seminole | Florida | 12117 | 78133 | 904 |
2099755 | 2099755 | 2022-01-10 | Seminole | Florida | 12117 | 78133 | 904 |
2096504 | 2096504 | 2022-01-09 | Seminole | Florida | 12117 | 78133 | 904 |
2098004 | 2098004 | 2022-01-09 | Onondaga | New York | 36067 | 83866 | 904 |
2098687 | 2098687 | 2022-01-09 | Hamilton | Tennessee | 47065 | 76054 | 904 |
2093252 | 2093252 | 2022-01-08 | Seminole | Florida | 12117 | 78133 | 904 |
2095435 | 2095435 | 2022-01-08 | Hamilton | Tennessee | 47065 | 75128 | 904 |
2090000 | 2090000 | 2022-01-07 | Seminole | Florida | 12117 | 78133 | 904 |
2091166 | 2091166 | 2022-01-07 | Jackson | Missouri | 29095 | 72717 | 904 |
2092183 | 2092183 | 2022-01-07 | Hamilton | Tennessee | 47065 | 75128 | 904 |
2086749 | 2086749 | 2022-01-06 | Seminole | Florida | 12117 | 71009 | 904 |
2088931 | 2088931 | 2022-01-06 | Hamilton | Tennessee | 47065 | 74557 | 904 |
2083497 | 2083497 | 2022-01-05 | Seminole | Florida | 12117 | 71009 | 904 |
2085680 | 2085680 | 2022-01-05 | Hamilton | Tennessee | 47065 | 73041 | 904 |
2082428 | 2082428 | 2022-01-04 | Hamilton | Tennessee | 47065 | 73041 | 904 |
2065420 | 2065420 | 2021-12-30 | Somerset | New Jersey | 34035 | 45926 | 904 |
2062170 | 2062170 | 2021-12-29 | Somerset | New Jersey | 34035 | 44674 | 904 |
2058921 | 2058921 | 2021-12-28 | Somerset | New Jersey | 34035 | 43783 | 904 |
2055672 | 2055672 | 2021-12-27 | Somerset | New Jersey | 34035 | 43076 | 904 |
1922540 | 1922540 | 2021-11-16 | Guilford | North Carolina | 37081 | 69475 | 904 |
1906342 | 1906342 | 2021-11-11 | Wake | North Carolina | 37183 | 132846 | 904 |
1903093 | 1903093 | 2021-11-10 | Wake | North Carolina | 37183 | 132681 | 904 |
1899843 | 1899843 | 2021-11-09 | Wake | North Carolina | 37183 | 132454 | 904 |
1880128 | 1880128 | 2021-11-03 | Washoe | Nevada | 32031 | 65644 | 904 |
1876879 | 1876879 | 2021-11-02 | Washoe | Nevada | 32031 | 65491 | 904 |
1828470 | 1828470 | 2021-10-18 | Lucas | Ohio | 39095 | 55643 | 904 |
1825221 | 1825221 | 2021-10-17 | Lucas | Ohio | 39095 | 55560 | 904 |
1821972 | 1821972 | 2021-10-16 | Lucas | Ohio | 39095 | 55462 | 904 |
1818723 | 1818723 | 2021-10-15 | Lucas | Ohio | 39095 | 55296 | 904 |
1800615 | 1800615 | 2021-10-10 | Arapahoe | Colorado | 8005 | 77113 | 904 |
1797366 | 1797366 | 2021-10-09 | Arapahoe | Colorado | 8005 | 76936 | 904 |
1794117 | 1794117 | 2021-10-08 | Arapahoe | Colorado | 8005 | 76936 | 904 |
1773457 | 1773457 | 2021-10-01 | York | Pennsylvania | 42133 | 56473 | 904 |
1770207 | 1770207 | 2021-09-30 | York | Pennsylvania | 42133 | 56293 | 904 |
1761618 | 1761618 | 2021-09-28 | Tulare | California | 6107 | 74941 | 904 |
1758370 | 1758370 | 2021-09-27 | Tulare | California | 6107 | 74793 | 904 |
1755528 | 1755528 | 2021-09-26 | Kane | Illinois | 17089 | 66108 | 904 |
1752280 | 1752280 | 2021-09-25 | Kane | Illinois | 17089 | 66108 | 904 |
1749031 | 1749031 | 2021-09-24 | Kane | Illinois | 17089 | 66108 | 904 |
1691703 | 1691703 | 2021-09-06 | Burlington | New Jersey | 34005 | 49164 | 904 |
1688453 | 1688453 | 2021-09-05 | Burlington | New Jersey | 34005 | 49034 | 904 |
1685203 | 1685203 | 2021-09-04 | Burlington | New Jersey | 34005 | 48963 | 904 |
1473691 | 1473691 | 2021-07-01 | Ramsey | Minnesota | 27123 | 52577 | 904 |
1469444 | 1469444 | 2021-06-30 | Unknown | Florida | 7610 | 904 | |
1462675 | 1462675 | 2021-06-28 | Pinal | Arizona | 4021 | 53860 | 904 |
1459430 | 1459430 | 2021-06-27 | Pinal | Arizona | 4021 | 53859 | 904 |
1456185 | 1456185 | 2021-06-26 | Pinal | Arizona | 4021 | 53851 | 904 |
1452940 | 1452940 | 2021-06-25 | Pinal | Arizona | 4021 | 53808 | 904 |
1214735 | 1214735 | 2021-04-12 | Summit | Ohio | 39153 | 44761 | 904 |
1211488 | 1211488 | 2021-04-11 | Summit | Ohio | 39153 | 44613 | 904 |
1208239 | 1208239 | 2021-04-10 | Summit | Ohio | 39153 | 44494 | 904 |
1204991 | 1204991 | 2021-04-09 | Summit | Ohio | 39153 | 44336 | 904 |
1201743 | 1201743 | 2021-04-08 | Summit | Ohio | 39153 | 44226 | 904 |
1198494 | 1198494 | 2021-04-07 | Summit | Ohio | 39153 | 44078 | 904 |
1195245 | 1195245 | 2021-04-06 | Summit | Ohio | 39153 | 43976 | 904 |
1188425 | 1188425 | 2021-04-04 | Bernalillo | New Mexico | 35001 | 54906 | 904 |
1185178 | 1185178 | 2021-04-03 | Bernalillo | New Mexico | 35001 | 54906 | 904 |
1181931 | 1181931 | 2021-04-02 | Bernalillo | New Mexico | 35001 | 54906 | 904 |
1148076 | 1148076 | 2021-03-23 | DeKalb | Georgia | 13089 | 60594 | 904 |
1149445 | 1149445 | 2021-03-23 | Mercer | New Jersey | 34021 | 29946 | 904 |
1138266 | 1138266 | 2021-03-20 | Marion | Florida | 12083 | 28609 | 904 |
1139866 | 1139866 | 2021-03-20 | Mecklenburg | North Carolina | 37119 | 100377 | 904 |
1135020 | 1135020 | 2021-03-19 | Marion | Florida | 12083 | 28564 | 904 |
1136620 | 1136620 | 2021-03-19 | Mecklenburg | North Carolina | 37119 | 100099 | 904 |
1125273 | 1125273 | 2021-03-16 | Lee | Florida | 12071 | 60116 | 904 |
1115533 | 1115533 | 2021-03-13 | Lee | Florida | 12071 | 59684 | 904 |
1114779 | 1114779 | 2021-03-12 | Travis | Texas | 48453 | 77329 | 904 |
1084983 | 1084983 | 2021-03-03 | Berks | Pennsylvania | 42011 | 35888 | 904 |
1060746 | 1060746 | 2021-02-24 | Lake | Indiana | 18089 | 48237 | 904 |
1057500 | 1057500 | 2021-02-23 | Lake | Indiana | 18089 | 48179 | 904 |
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);