ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 795 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2209364 | 2209364 | 2022-02-12 | Baylor | Texas | 48023 | 795 | 31 |
2206111 | 2206111 | 2022-02-11 | Baylor | Texas | 48023 | 795 | 31 |
2108544 | 2108544 | 2022-01-12 | Coke | Texas | 48081 | 795 | 18 |
2014287 | 2014287 | 2021-12-14 | Crockett | Texas | 48105 | 795 | 17 |
2011036 | 2011036 | 2021-12-13 | Crockett | Texas | 48105 | 795 | 17 |
2007785 | 2007785 | 2021-12-12 | Crockett | Texas | 48105 | 795 | 17 |
2004534 | 2004534 | 2021-12-11 | Crockett | Texas | 48105 | 795 | 17 |
1738115 | 1738115 | 2021-09-20 | Hartley | Texas | 48205 | 795 | 2 |
1734865 | 1734865 | 2021-09-19 | Hartley | Texas | 48205 | 795 | 2 |
1731615 | 1731615 | 2021-09-18 | Hartley | Texas | 48205 | 795 | 2 |
1728465 | 1728465 | 2021-09-17 | San Augustine | Texas | 48405 | 795 | 33 |
1725216 | 1725216 | 2021-09-16 | San Augustine | Texas | 48405 | 795 | 33 |
1384279 | 1384279 | 2021-06-03 | Trinity | Texas | 48455 | 795 | 26 |
1263936 | 1263936 | 2021-04-27 | Archer | Texas | 48009 | 795 | 12 |
1260689 | 1260689 | 2021-04-26 | Archer | Texas | 48009 | 795 | 12 |
1257442 | 1257442 | 2021-04-25 | Archer | Texas | 48009 | 795 | 12 |
1254195 | 1254195 | 2021-04-24 | Archer | Texas | 48009 | 795 | 12 |
1250948 | 1250948 | 2021-04-23 | Archer | Texas | 48009 | 795 | 12 |
1247701 | 1247701 | 2021-04-22 | Archer | Texas | 48009 | 795 | 12 |
1244454 | 1244454 | 2021-04-21 | Archer | Texas | 48009 | 795 | 12 |
1241207 | 1241207 | 2021-04-20 | Archer | Texas | 48009 | 795 | 12 |
1237960 | 1237960 | 2021-04-19 | Archer | Texas | 48009 | 795 | 12 |
1234713 | 1234713 | 2021-04-18 | Archer | Texas | 48009 | 795 | 12 |
1231465 | 1231465 | 2021-04-17 | Archer | Texas | 48009 | 795 | 12 |
1228217 | 1228217 | 2021-04-16 | Archer | Texas | 48009 | 795 | 12 |
1224969 | 1224969 | 2021-04-15 | Archer | Texas | 48009 | 795 | 12 |
1221722 | 1221722 | 2021-04-14 | Archer | Texas | 48009 | 795 | 12 |
1218474 | 1218474 | 2021-04-13 | Archer | Texas | 48009 | 795 | 12 |
1179699 | 1179699 | 2021-04-01 | San Saba | Texas | 48411 | 795 | 23 |
1176452 | 1176452 | 2021-03-31 | San Saba | Texas | 48411 | 795 | 23 |
1160213 | 1160213 | 2021-03-26 | San Saba | Texas | 48411 | 795 | 23 |
1092017 | 1092017 | 2021-03-05 | Presidio | Texas | 48377 | 795 | 24 |
1088591 | 1088591 | 2021-03-04 | Bailey | Texas | 48017 | 795 | 17 |
1088771 | 1088771 | 2021-03-04 | Presidio | Texas | 48377 | 795 | 24 |
1020596 | 1020596 | 2021-02-11 | Morris | Texas | 48343 | 795 | 22 |
929559 | 929559 | 2021-01-14 | Bandera | Texas | 48019 | 795 | 17 |
926314 | 926314 | 2021-01-13 | Bandera | Texas | 48019 | 795 | 16 |
832198 | 832198 | 2020-12-15 | Austin | Texas | 48015 | 795 | 13 |
676514 | 676514 | 2020-10-28 | Fannin | Texas | 48147 | 795 | 19 |
559721 | 559721 | 2020-09-22 | Brown | Texas | 48049 | 795 | 28 |
478918 | 478918 | 2020-08-28 | Harrison | Texas | 48203 | 795 | 35 |
469207 | 469207 | 2020-08-25 | Gonzales | Texas | 48177 | 795 | 12 |
359859 | 359859 | 2020-07-22 | Wichita | Texas | 48485 | 795 | 9 |
286624 | 286624 | 2020-06-29 | McLennan | Texas | 48309 | 795 | 8 |
190201 | 190201 | 2020-05-29 | Galveston | Texas | 48167 | 795 | 32 |
159709 | 159709 | 2020-05-19 | Brazoria | Texas | 48039 | 795 | 11 |
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);