ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where deaths = 1446 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Massachusetts 24
- California 21
- Florida 5
- Michigan 5
- Illinois 2
- Pennsylvania 2
- Georgia 1
- Maryland 1
- New Jersey 1
- South Carolina 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2437936 | 2437936 | 2022-04-24 | Tulare | California | 6107 | 135110 | 1446 |
2434680 | 2434680 | 2022-04-23 | Tulare | California | 6107 | 135110 | 1446 |
2431424 | 2431424 | 2022-04-22 | Tulare | California | 6107 | 135110 | 1446 |
2428168 | 2428168 | 2022-04-21 | Tulare | California | 6107 | 134546 | 1446 |
2383000 | 2383000 | 2022-04-07 | Lake | Illinois | 17097 | 149774 | 1446 |
2379745 | 2379745 | 2022-04-06 | Lake | Illinois | 17097 | 149682 | 1446 |
2126656 | 2126656 | 2022-01-18 | Genesee | Michigan | 26049 | 84530 | 1446 |
2123404 | 2123404 | 2022-01-17 | Genesee | Michigan | 26049 | 84530 | 1446 |
2120152 | 2120152 | 2022-01-16 | Genesee | Michigan | 26049 | 84530 | 1446 |
2116900 | 2116900 | 2022-01-15 | Genesee | Michigan | 26049 | 84530 | 1446 |
2113649 | 2113649 | 2022-01-14 | Genesee | Michigan | 26049 | 84530 | 1446 |
1897448 | 1897448 | 2021-11-08 | Travis | Texas | 48453 | 120366 | 1446 |
1877538 | 1877538 | 2021-11-02 | Greenville | South Carolina | 45045 | 105394 | 1446 |
1852813 | 1852813 | 2021-10-26 | Gwinnett | Georgia | 13135 | 132798 | 1446 |
1725965 | 1725965 | 2021-09-17 | Brevard | Florida | 12009 | 77272 | 1446 |
1722716 | 1722716 | 2021-09-16 | Brevard | Florida | 12009 | 75107 | 1446 |
1719467 | 1719467 | 2021-09-15 | Brevard | Florida | 12009 | 75107 | 1446 |
1716219 | 1716219 | 2021-09-14 | Brevard | Florida | 12009 | 75107 | 1446 |
1718179 | 1718179 | 2021-09-14 | Delaware | Pennsylvania | 42045 | 57430 | 1446 |
1628132 | 1628132 | 2021-08-17 | Milwaukee | Wisconsin | 55079 | 126489 | 1446 |
1553700 | 1553700 | 2021-07-26 | San Joaquin | California | 6077 | 79959 | 1446 |
1550453 | 1550453 | 2021-07-25 | San Joaquin | California | 6077 | 79494 | 1446 |
1547206 | 1547206 | 2021-07-24 | San Joaquin | California | 6077 | 79494 | 1446 |
1543959 | 1543959 | 2021-07-23 | San Joaquin | California | 6077 | 79494 | 1446 |
1540711 | 1540711 | 2021-07-22 | San Joaquin | California | 6077 | 79321 | 1446 |
1537464 | 1537464 | 2021-07-21 | San Joaquin | California | 6077 | 79067 | 1446 |
1534216 | 1534216 | 2021-07-20 | San Joaquin | California | 6077 | 78955 | 1446 |
1530969 | 1530969 | 2021-07-19 | San Joaquin | California | 6077 | 78866 | 1446 |
1531982 | 1531982 | 2021-07-19 | Plymouth | Massachusetts | 25023 | 49479 | 1446 |
1527722 | 1527722 | 2021-07-18 | San Joaquin | California | 6077 | 78564 | 1446 |
1528735 | 1528735 | 2021-07-18 | Plymouth | Massachusetts | 25023 | 49435 | 1446 |
1524475 | 1524475 | 2021-07-17 | San Joaquin | California | 6077 | 78564 | 1446 |
1525488 | 1525488 | 2021-07-17 | Plymouth | Massachusetts | 25023 | 49435 | 1446 |
1521227 | 1521227 | 2021-07-16 | San Joaquin | California | 6077 | 78564 | 1446 |
1522241 | 1522241 | 2021-07-16 | Plymouth | Massachusetts | 25023 | 49435 | 1446 |
1517979 | 1517979 | 2021-07-15 | San Joaquin | California | 6077 | 78468 | 1446 |
1518992 | 1518992 | 2021-07-15 | Plymouth | Massachusetts | 25023 | 49422 | 1446 |
1514732 | 1514732 | 2021-07-14 | San Joaquin | California | 6077 | 78369 | 1446 |
1515745 | 1515745 | 2021-07-14 | Plymouth | Massachusetts | 25023 | 49401 | 1446 |
1512499 | 1512499 | 2021-07-13 | Plymouth | Massachusetts | 25023 | 49386 | 1446 |
1509252 | 1509252 | 2021-07-12 | Plymouth | Massachusetts | 25023 | 49373 | 1446 |
1506006 | 1506006 | 2021-07-11 | Plymouth | Massachusetts | 25023 | 49356 | 1446 |
1502760 | 1502760 | 2021-07-10 | Plymouth | Massachusetts | 25023 | 49356 | 1446 |
1499514 | 1499514 | 2021-07-09 | Plymouth | Massachusetts | 25023 | 49356 | 1446 |
1496268 | 1496268 | 2021-07-08 | Plymouth | Massachusetts | 25023 | 49342 | 1446 |
1486527 | 1486527 | 2021-07-05 | Plymouth | Massachusetts | 25023 | 49311 | 1446 |
1483281 | 1483281 | 2021-07-04 | Plymouth | Massachusetts | 25023 | 49311 | 1446 |
1480035 | 1480035 | 2021-07-03 | Plymouth | Massachusetts | 25023 | 49311 | 1446 |
1476788 | 1476788 | 2021-07-02 | Plymouth | Massachusetts | 25023 | 49311 | 1446 |
1473542 | 1473542 | 2021-07-01 | Plymouth | Massachusetts | 25023 | 49305 | 1446 |
1470296 | 1470296 | 2021-06-30 | Plymouth | Massachusetts | 25023 | 49299 | 1446 |
1467051 | 1467051 | 2021-06-29 | Plymouth | Massachusetts | 25023 | 49292 | 1446 |
1463806 | 1463806 | 2021-06-28 | Plymouth | Massachusetts | 25023 | 49291 | 1446 |
1460561 | 1460561 | 2021-06-27 | Plymouth | Massachusetts | 25023 | 49288 | 1446 |
1457316 | 1457316 | 2021-06-26 | Plymouth | Massachusetts | 25023 | 49284 | 1446 |
1377223 | 1377223 | 2021-06-01 | Delaware | Pennsylvania | 42045 | 52164 | 1446 |
1212785 | 1212785 | 2021-04-12 | Alameda | California | 6001 | 84777 | 1446 |
1209537 | 1209537 | 2021-04-11 | Alameda | California | 6001 | 84647 | 1446 |
1206288 | 1206288 | 2021-04-10 | Alameda | California | 6001 | 84469 | 1446 |
1178105 | 1178105 | 2021-04-01 | Hampden | Massachusetts | 25013 | 46061 | 1446 |
1174858 | 1174858 | 2021-03-31 | Hampden | Massachusetts | 25013 | 45841 | 1446 |
1129381 | 1129381 | 2021-03-17 | Montgomery | Maryland | 24031 | 65098 | 1446 |
1056971 | 1056971 | 2021-02-23 | Sacramento | California | 6067 | 92620 | 1446 |
795677 | 795677 | 2020-12-04 | Union | New Jersey | 34039 | 29750 | 1446 |
619037 | 619037 | 2020-10-11 | Palm Beach | Florida | 12099 | 47953 | 1446 |
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);