ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 1727 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- California 13
- Maryland 8
- Alabama 3
- Massachusetts 3
- Indiana 2
- New Jersey 2
- Minnesota 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424274 | 2424274 | 2022-04-19 | Travis | Texas | 48453 | 223264 | 1727 |
2256700 | 2256700 | 2022-02-27 | Baltimore city | Maryland | 24510 | 110504 | 1727 |
2110369 | 2110369 | 2022-01-13 | Plymouth | Massachusetts | 25023 | 98872 | 1727 |
2019344 | 2019344 | 2021-12-16 | Hampden | Massachusetts | 25013 | 76390 | 1727 |
1921813 | 1921813 | 2021-11-16 | Montgomery | Maryland | 24031 | 83844 | 1727 |
1895816 | 1895816 | 2021-11-08 | Prince George's | Maryland | 24033 | 100442 | 1727 |
1892566 | 1892566 | 2021-11-07 | Prince George's | Maryland | 24033 | 100401 | 1727 |
1889316 | 1889316 | 2021-11-06 | Prince George's | Maryland | 24033 | 100325 | 1727 |
1886066 | 1886066 | 2021-11-05 | Prince George's | Maryland | 24033 | 100221 | 1727 |
1882817 | 1882817 | 2021-11-04 | Prince George's | Maryland | 24033 | 100138 | 1727 |
1879568 | 1879568 | 2021-11-03 | Prince George's | Maryland | 24033 | 100068 | 1727 |
1828166 | 1828166 | 2021-10-18 | Monmouth | New Jersey | 34025 | 91120 | 1727 |
1824917 | 1824917 | 2021-10-17 | Monmouth | New Jersey | 34025 | 91039 | 1727 |
1735424 | 1735424 | 2021-09-20 | Jefferson | Alabama | 1073 | 109837 | 1727 |
1732174 | 1732174 | 2021-09-19 | Jefferson | Alabama | 1073 | 109572 | 1727 |
1728924 | 1728924 | 2021-09-18 | Jefferson | Alabama | 1073 | 109348 | 1727 |
1647508 | 1647508 | 2021-08-23 | King | Washington | 53033 | 130915 | 1727 |
1514703 | 1514703 | 2021-07-14 | Fresno | California | 6019 | 112176 | 1727 |
1491978 | 1491978 | 2021-07-07 | Fresno | California | 6019 | 102616 | 1727 |
1488731 | 1488731 | 2021-07-06 | Fresno | California | 6019 | 102592 | 1727 |
1485484 | 1485484 | 2021-07-05 | Fresno | California | 6019 | 102512 | 1727 |
1482238 | 1482238 | 2021-07-04 | Fresno | California | 6019 | 102512 | 1727 |
1478991 | 1478991 | 2021-07-03 | Fresno | California | 6019 | 102512 | 1727 |
1475745 | 1475745 | 2021-07-02 | Fresno | California | 6019 | 102512 | 1727 |
1472499 | 1472499 | 2021-07-01 | Fresno | California | 6019 | 102490 | 1727 |
1466009 | 1466009 | 2021-06-29 | Fresno | California | 6019 | 103121 | 1727 |
1462764 | 1462764 | 2021-06-28 | Fresno | California | 6019 | 103110 | 1727 |
1459519 | 1459519 | 2021-06-27 | Fresno | California | 6019 | 103091 | 1727 |
1456274 | 1456274 | 2021-06-26 | Fresno | California | 6019 | 103073 | 1727 |
1453029 | 1453029 | 2021-06-25 | Fresno | California | 6019 | 103061 | 1727 |
1353446 | 1353446 | 2021-05-25 | Bristol | Massachusetts | 25005 | 66508 | 1727 |
1311360 | 1311360 | 2021-05-12 | Hennepin | Minnesota | 27053 | 122274 | 1727 |
1099698 | 1099698 | 2021-03-08 | Marion | Indiana | 18097 | 91616 | 1727 |
1096450 | 1096450 | 2021-03-07 | Marion | Indiana | 18097 | 91559 | 1727 |
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);