ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Caldwell", deaths = 18 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
627066 | 627066 | 2020-10-13 | Caldwell | North Carolina | 37027 | 2020 | 18 |
623824 | 623824 | 2020-10-12 | Caldwell | North Carolina | 37027 | 2003 | 18 |
620581 | 620581 | 2020-10-11 | Caldwell | North Carolina | 37027 | 1978 | 18 |
617339 | 617339 | 2020-10-10 | Caldwell | North Carolina | 37027 | 1948 | 18 |
614097 | 614097 | 2020-10-09 | Caldwell | North Carolina | 37027 | 1924 | 18 |
610856 | 610856 | 2020-10-08 | Caldwell | North Carolina | 37027 | 1882 | 18 |
607614 | 607614 | 2020-10-07 | Caldwell | North Carolina | 37027 | 1847 | 18 |
604371 | 604371 | 2020-10-06 | Caldwell | North Carolina | 37027 | 1838 | 18 |
601129 | 601129 | 2020-10-05 | Caldwell | North Carolina | 37027 | 1818 | 18 |
597886 | 597886 | 2020-10-04 | Caldwell | North Carolina | 37027 | 1771 | 18 |
594643 | 594643 | 2020-10-03 | Caldwell | North Carolina | 37027 | 1764 | 18 |
591402 | 591402 | 2020-10-02 | Caldwell | North Carolina | 37027 | 1724 | 18 |
588161 | 588161 | 2020-10-01 | Caldwell | North Carolina | 37027 | 1710 | 18 |
584921 | 584921 | 2020-09-30 | Caldwell | North Carolina | 37027 | 1681 | 18 |
581680 | 581680 | 2020-09-29 | Caldwell | North Carolina | 37027 | 1675 | 18 |
578440 | 578440 | 2020-09-28 | Caldwell | North Carolina | 37027 | 1672 | 18 |
575199 | 575199 | 2020-09-27 | Caldwell | North Carolina | 37027 | 1664 | 18 |
571955 | 571955 | 2020-09-26 | Caldwell | North Carolina | 37027 | 1657 | 18 |
568713 | 568713 | 2020-09-25 | Caldwell | North Carolina | 37027 | 1653 | 18 |
565472 | 565472 | 2020-09-24 | Caldwell | North Carolina | 37027 | 1603 | 18 |
562231 | 562231 | 2020-09-23 | Caldwell | North Carolina | 37027 | 1581 | 18 |
558994 | 558994 | 2020-09-22 | Caldwell | North Carolina | 37027 | 1580 | 18 |
555757 | 555757 | 2020-09-21 | Caldwell | North Carolina | 37027 | 1571 | 18 |
552520 | 552520 | 2020-09-20 | Caldwell | North Carolina | 37027 | 1560 | 18 |
549281 | 549281 | 2020-09-19 | Caldwell | North Carolina | 37027 | 1557 | 18 |
546042 | 546042 | 2020-09-18 | Caldwell | North Carolina | 37027 | 1551 | 18 |
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);