ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where county = "Berkeley" and deaths = 208 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 |
---|---|---|---|---|---|---|---|
2030964 | 2030964 | 2021-12-19 | Berkeley | West Virginia | 54003 | 22467 | 208 |
2027713 | 2027713 | 2021-12-18 | Berkeley | West Virginia | 54003 | 22325 | 208 |
2024462 | 2024462 | 2021-12-17 | Berkeley | West Virginia | 54003 | 22174 | 208 |
1578633 | 1578633 | 2021-08-02 | Berkeley | South Carolina | 45015 | 19323 | 208 |
1575385 | 1575385 | 2021-08-01 | Berkeley | South Carolina | 45015 | 18865 | 208 |
1572137 | 1572137 | 2021-07-31 | Berkeley | South Carolina | 45015 | 18865 | 208 |
1568889 | 1568889 | 2021-07-30 | Berkeley | South Carolina | 45015 | 18865 | 208 |
1565641 | 1565641 | 2021-07-29 | Berkeley | South Carolina | 45015 | 18780 | 208 |
1536415 | 1536415 | 2021-07-20 | Berkeley | South Carolina | 45015 | 18314 | 208 |
1533167 | 1533167 | 2021-07-19 | Berkeley | South Carolina | 45015 | 18303 | 208 |
1529920 | 1529920 | 2021-07-18 | Berkeley | South Carolina | 45015 | 18234 | 208 |
1526673 | 1526673 | 2021-07-17 | Berkeley | South Carolina | 45015 | 18234 | 208 |
1523426 | 1523426 | 2021-07-16 | Berkeley | South Carolina | 45015 | 18234 | 208 |
1520178 | 1520178 | 2021-07-15 | Berkeley | South Carolina | 45015 | 18212 | 208 |
1516930 | 1516930 | 2021-07-14 | Berkeley | South Carolina | 45015 | 18186 | 208 |
1513683 | 1513683 | 2021-07-13 | Berkeley | South Carolina | 45015 | 18165 | 208 |
1510437 | 1510437 | 2021-07-12 | Berkeley | South Carolina | 45015 | 18154 | 208 |
1507190 | 1507190 | 2021-07-11 | Berkeley | South Carolina | 45015 | 18098 | 208 |
1503944 | 1503944 | 2021-07-10 | Berkeley | South Carolina | 45015 | 18098 | 208 |
1500698 | 1500698 | 2021-07-09 | Berkeley | South Carolina | 45015 | 18098 | 208 |
1497452 | 1497452 | 2021-07-08 | Berkeley | South Carolina | 45015 | 18077 | 208 |
1494205 | 1494205 | 2021-07-07 | Berkeley | South Carolina | 45015 | 18064 | 208 |
1490958 | 1490958 | 2021-07-06 | Berkeley | South Carolina | 45015 | 18053 | 208 |
1487711 | 1487711 | 2021-07-05 | Berkeley | South Carolina | 45015 | 18048 | 208 |
1484464 | 1484464 | 2021-07-04 | Berkeley | South Carolina | 45015 | 18016 | 208 |
1481218 | 1481218 | 2021-07-03 | Berkeley | South Carolina | 45015 | 18016 | 208 |
1477971 | 1477971 | 2021-07-02 | Berkeley | South Carolina | 45015 | 18016 | 208 |
1474725 | 1474725 | 2021-07-01 | Berkeley | South Carolina | 45015 | 18007 | 208 |
1471479 | 1471479 | 2021-06-30 | Berkeley | South Carolina | 45015 | 17999 | 208 |
1468234 | 1468234 | 2021-06-29 | Berkeley | South Carolina | 45015 | 17990 | 208 |
1464989 | 1464989 | 2021-06-28 | Berkeley | South Carolina | 45015 | 17987 | 208 |
1461744 | 1461744 | 2021-06-27 | Berkeley | South Carolina | 45015 | 17968 | 208 |
1458499 | 1458499 | 2021-06-26 | Berkeley | South Carolina | 45015 | 17968 | 208 |
1455254 | 1455254 | 2021-06-25 | Berkeley | South Carolina | 45015 | 17968 | 208 |
1452009 | 1452009 | 2021-06-24 | Berkeley | South Carolina | 45015 | 17965 | 208 |
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);