ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 278 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Texas · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2342919 | 2342919 | 2022-03-25 | Van Zandt | Texas | 48467 | 10357 | 278 |
2339666 | 2339666 | 2022-03-24 | Van Zandt | Texas | 48467 | 10356 | 278 |
2336412 | 2336412 | 2022-03-23 | Van Zandt | Texas | 48467 | 10355 | 278 |
2333158 | 2333158 | 2022-03-22 | Van Zandt | Texas | 48467 | 10354 | 278 |
2284386 | 2284386 | 2022-03-07 | Wood | Texas | 48499 | 7974 | 278 |
2281134 | 2281134 | 2022-03-06 | Wood | Texas | 48499 | 7966 | 278 |
1842162 | 1842162 | 2021-10-22 | Orange | Texas | 48361 | 13654 | 278 |
1728356 | 1728356 | 2021-09-17 | Guadalupe | Texas | 48187 | 21719 | 278 |
1637327 | 1637327 | 2021-08-20 | Brazos | Texas | 48041 | 30142 | 278 |
1611488 | 1611488 | 2021-08-12 | Midland | Texas | 48329 | 20772 | 278 |
1056173 | 1056173 | 2021-02-22 | Comal | Texas | 48091 | 8843 | 278 |
1052927 | 1052927 | 2021-02-21 | Comal | Texas | 48091 | 8843 | 278 |
1049680 | 1049680 | 2021-02-20 | Comal | Texas | 48091 | 8843 | 278 |
1046433 | 1046433 | 2021-02-19 | Comal | Texas | 48091 | 8843 | 278 |
1043188 | 1043188 | 2021-02-18 | Comal | Texas | 48091 | 8843 | 278 |
1039943 | 1039943 | 2021-02-17 | Comal | Texas | 48091 | 8843 | 278 |
1036698 | 1036698 | 2021-02-16 | Comal | Texas | 48091 | 8843 | 278 |
1033453 | 1033453 | 2021-02-15 | Comal | Texas | 48091 | 8843 | 278 |
1030207 | 1030207 | 2021-02-14 | Comal | Texas | 48091 | 8843 | 278 |
1026960 | 1026960 | 2021-02-13 | Comal | Texas | 48091 | 8843 | 278 |
907003 | 907003 | 2021-01-07 | Montgomery | Texas | 48339 | 29648 | 278 |
838870 | 838870 | 2020-12-17 | Potter | Texas | 48375 | 14549 | 278 |
556539 | 556539 | 2020-09-21 | Fort Bend | Texas | 48157 | 15814 | 278 |
553302 | 553302 | 2020-09-20 | Fort Bend | Texas | 48157 | 15789 | 278 |
401469 | 401469 | 2020-08-04 | El Paso | Texas | 48141 | 15142 | 278 |
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);