ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 18, fips = 48387 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
816152 | 816152 | 2020-12-10 | Red River | Texas | 48387 | 250 | 18 |
812906 | 812906 | 2020-12-09 | Red River | Texas | 48387 | 249 | 18 |
809662 | 809662 | 2020-12-08 | Red River | Texas | 48387 | 247 | 18 |
806417 | 806417 | 2020-12-07 | Red River | Texas | 48387 | 246 | 18 |
803172 | 803172 | 2020-12-06 | Red River | Texas | 48387 | 246 | 18 |
799927 | 799927 | 2020-12-05 | Red River | Texas | 48387 | 246 | 18 |
796682 | 796682 | 2020-12-04 | Red River | Texas | 48387 | 234 | 18 |
793437 | 793437 | 2020-12-03 | Red River | Texas | 48387 | 230 | 18 |
790192 | 790192 | 2020-12-02 | Red River | Texas | 48387 | 228 | 18 |
786947 | 786947 | 2020-12-01 | Red River | Texas | 48387 | 227 | 18 |
783703 | 783703 | 2020-11-30 | Red River | Texas | 48387 | 225 | 18 |
780458 | 780458 | 2020-11-29 | Red River | Texas | 48387 | 225 | 18 |
777212 | 777212 | 2020-11-28 | Red River | Texas | 48387 | 225 | 18 |
773967 | 773967 | 2020-11-27 | Red River | Texas | 48387 | 225 | 18 |
770722 | 770722 | 2020-11-26 | Red River | Texas | 48387 | 225 | 18 |
767476 | 767476 | 2020-11-25 | Red River | Texas | 48387 | 221 | 18 |
764231 | 764231 | 2020-11-24 | Red River | Texas | 48387 | 220 | 18 |
760986 | 760986 | 2020-11-23 | Red River | Texas | 48387 | 219 | 18 |
757741 | 757741 | 2020-11-22 | Red River | Texas | 48387 | 219 | 18 |
754494 | 754494 | 2020-11-21 | Red River | Texas | 48387 | 218 | 18 |
751248 | 751248 | 2020-11-20 | Red River | Texas | 48387 | 216 | 18 |
748002 | 748002 | 2020-11-19 | Red River | Texas | 48387 | 215 | 18 |
744756 | 744756 | 2020-11-18 | Red River | Texas | 48387 | 213 | 18 |
741509 | 741509 | 2020-11-17 | Red River | Texas | 48387 | 213 | 18 |
738262 | 738262 | 2020-11-16 | Red River | Texas | 48387 | 213 | 18 |
735018 | 735018 | 2020-11-15 | Red River | Texas | 48387 | 212 | 18 |
731772 | 731772 | 2020-11-14 | Red River | Texas | 48387 | 212 | 18 |
728527 | 728527 | 2020-11-13 | Red River | Texas | 48387 | 212 | 18 |
725284 | 725284 | 2020-11-12 | Red River | Texas | 48387 | 212 | 18 |
722041 | 722041 | 2020-11-11 | Red River | Texas | 48387 | 211 | 18 |
718798 | 718798 | 2020-11-10 | Red River | Texas | 48387 | 211 | 18 |
715555 | 715555 | 2020-11-09 | Red River | Texas | 48387 | 209 | 18 |
712311 | 712311 | 2020-11-08 | Red River | Texas | 48387 | 209 | 18 |
709067 | 709067 | 2020-11-07 | Red River | Texas | 48387 | 209 | 18 |
705823 | 705823 | 2020-11-06 | Red River | Texas | 48387 | 209 | 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);