ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where county = "Berkshire" and deaths = 288 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1531972 | 1531972 | 2021-07-19 | Berkshire | Massachusetts | 25003 | 6592 | 288 |
1528725 | 1528725 | 2021-07-18 | Berkshire | Massachusetts | 25003 | 6590 | 288 |
1525478 | 1525478 | 2021-07-17 | Berkshire | Massachusetts | 25003 | 6590 | 288 |
1522231 | 1522231 | 2021-07-16 | Berkshire | Massachusetts | 25003 | 6590 | 288 |
1518982 | 1518982 | 2021-07-15 | Berkshire | Massachusetts | 25003 | 6586 | 288 |
1515735 | 1515735 | 2021-07-14 | Berkshire | Massachusetts | 25003 | 6585 | 288 |
1512489 | 1512489 | 2021-07-13 | Berkshire | Massachusetts | 25003 | 6582 | 288 |
1509242 | 1509242 | 2021-07-12 | Berkshire | Massachusetts | 25003 | 6582 | 288 |
1505996 | 1505996 | 2021-07-11 | Berkshire | Massachusetts | 25003 | 6576 | 288 |
1502750 | 1502750 | 2021-07-10 | Berkshire | Massachusetts | 25003 | 6576 | 288 |
1499504 | 1499504 | 2021-07-09 | Berkshire | Massachusetts | 25003 | 6576 | 288 |
1496258 | 1496258 | 2021-07-08 | Berkshire | Massachusetts | 25003 | 6574 | 288 |
1493011 | 1493011 | 2021-07-07 | Berkshire | Massachusetts | 25003 | 6573 | 288 |
1489764 | 1489764 | 2021-07-06 | Berkshire | Massachusetts | 25003 | 6572 | 288 |
1486517 | 1486517 | 2021-07-05 | Berkshire | Massachusetts | 25003 | 6562 | 288 |
1483271 | 1483271 | 2021-07-04 | Berkshire | Massachusetts | 25003 | 6562 | 288 |
1480025 | 1480025 | 2021-07-03 | Berkshire | Massachusetts | 25003 | 6562 | 288 |
1476778 | 1476778 | 2021-07-02 | Berkshire | Massachusetts | 25003 | 6562 | 288 |
1473532 | 1473532 | 2021-07-01 | Berkshire | Massachusetts | 25003 | 6562 | 288 |
1470286 | 1470286 | 2021-06-30 | Berkshire | Massachusetts | 25003 | 6558 | 288 |
1467041 | 1467041 | 2021-06-29 | Berkshire | Massachusetts | 25003 | 6553 | 288 |
1463796 | 1463796 | 2021-06-28 | Berkshire | Massachusetts | 25003 | 6553 | 288 |
1460551 | 1460551 | 2021-06-27 | Berkshire | Massachusetts | 25003 | 6553 | 288 |
1457306 | 1457306 | 2021-06-26 | Berkshire | Massachusetts | 25003 | 6552 | 288 |
1454061 | 1454061 | 2021-06-25 | Berkshire | Massachusetts | 25003 | 6552 | 288 |
1450816 | 1450816 | 2021-06-24 | Berkshire | Massachusetts | 25003 | 6551 | 288 |
1447570 | 1447570 | 2021-06-23 | Berkshire | Massachusetts | 25003 | 6550 | 288 |
1444325 | 1444325 | 2021-06-22 | Berkshire | Massachusetts | 25003 | 6548 | 288 |
1441080 | 1441080 | 2021-06-21 | Berkshire | Massachusetts | 25003 | 6546 | 288 |
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);