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

20 rows where county = "Blanco", deaths = 18 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 · 20 ✖

fips 1

county 1

  • Blanco · 20 ✖
Link rowid date ▲ county state fips cases deaths
1130801 1130801 2021-03-17 Blanco Texas 48031 694 18
1127554 1127554 2021-03-16 Blanco Texas 48031 693 18
1124308 1124308 2021-03-15 Blanco Texas 48031 693 18
1121062 1121062 2021-03-14 Blanco Texas 48031 692 18
1117815 1117815 2021-03-13 Blanco Texas 48031 692 18
1114568 1114568 2021-03-12 Blanco Texas 48031 690 18
1111322 1111322 2021-03-11 Blanco Texas 48031 690 18
1108076 1108076 2021-03-10 Blanco Texas 48031 689 18
1104830 1104830 2021-03-09 Blanco Texas 48031 687 18
1101584 1101584 2021-03-08 Blanco Texas 48031 687 18
1098338 1098338 2021-03-07 Blanco Texas 48031 687 18
1095090 1095090 2021-03-06 Blanco Texas 48031 687 18
1091844 1091844 2021-03-05 Blanco Texas 48031 685 18
1088598 1088598 2021-03-04 Blanco Texas 48031 685 18
1085353 1085353 2021-03-03 Blanco Texas 48031 684 18
1082107 1082107 2021-03-02 Blanco Texas 48031 684 18
1078861 1078861 2021-03-01 Blanco Texas 48031 683 18
1075616 1075616 2021-02-28 Blanco Texas 48031 681 18
1072370 1072370 2021-02-27 Blanco Texas 48031 681 18
1069124 1069124 2021-02-26 Blanco Texas 48031 679 18

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