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

18 rows where cases = 1749 and state = "Texas" sorted by date descending

✎ View and edit SQL

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

fips 15

state 1

  • Texas · 18 ✖
Link rowid date ▲ county state fips cases deaths
2268069 2268069 2022-03-02 Refugio Texas 48391 1749 31
2190045 2190045 2022-02-06 Stephens Texas 48429 1749 39
2134644 2134644 2022-01-20 Jim Hogg Texas 48247 1749 20
2040410 2040410 2021-12-22 Morris Texas 48343 1749 58
1985177 1985177 2021-12-05 Runnels Texas 48399 1749 55
1981927 1981927 2021-12-04 Runnels Texas 48399 1749 55
1965515 1965515 2021-11-29 Childress Texas 48075 1749 21
1819268 1819268 2021-10-15 Callahan Texas 48059 1749 53
1585477 1585477 2021-08-04 Leon Texas 48289 1749 44
1111559 1111559 2021-03-11 Zapata Texas 48505 1749 29
1078926 1078926 2021-03-01 Freestone Texas 48161 1749 44
997849 997849 2021-02-04 Lee Texas 48287 1749 36
919954 919954 2021-01-11 Lamb Texas 48279 1749 72
916709 916709 2021-01-10 Lamb Texas 48279 1749 71
913464 913464 2021-01-09 Lamb Texas 48279 1749 70
812719 812719 2020-12-09 Atascosa Texas 48013 1749 46
803219 803219 2020-12-06 Wharton Texas 48481 1749 71
702415 702415 2020-11-05 Caldwell Texas 48055 1749 38

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