ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

22 rows where deaths = 54, fips = 48273 and state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases, date (date)

state 1

  • Texas · 22 ✖

fips 1

  • 48273 · 22 ✖

county 1

Link rowid date ▲ county state fips cases deaths
767419 767419 2020-11-25 Kleberg Texas 48273 1177 54
764174 764174 2020-11-24 Kleberg Texas 48273 1176 54
760929 760929 2020-11-23 Kleberg Texas 48273 1175 54
757684 757684 2020-11-22 Kleberg Texas 48273 1175 54
754437 754437 2020-11-21 Kleberg Texas 48273 1160 54
751191 751191 2020-11-20 Kleberg Texas 48273 1129 54
747945 747945 2020-11-19 Kleberg Texas 48273 1124 54
744699 744699 2020-11-18 Kleberg Texas 48273 1124 54
741452 741452 2020-11-17 Kleberg Texas 48273 1123 54
738206 738206 2020-11-16 Kleberg Texas 48273 1121 54
734962 734962 2020-11-15 Kleberg Texas 48273 1121 54
731716 731716 2020-11-14 Kleberg Texas 48273 1116 54
728471 728471 2020-11-13 Kleberg Texas 48273 1116 54
725228 725228 2020-11-12 Kleberg Texas 48273 1099 54
721985 721985 2020-11-11 Kleberg Texas 48273 1079 54
718742 718742 2020-11-10 Kleberg Texas 48273 1065 54
715499 715499 2020-11-09 Kleberg Texas 48273 1054 54
712255 712255 2020-11-08 Kleberg Texas 48273 1054 54
709011 709011 2020-11-07 Kleberg Texas 48273 1047 54
705767 705767 2020-11-06 Kleberg Texas 48273 1047 54
702524 702524 2020-11-05 Kleberg Texas 48273 1045 54
699281 699281 2020-11-04 Kleberg Texas 48273 1042 54

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);