ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 753 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2154055 | 2154055 | 2022-01-26 | Baylor | Texas | 48023 | 753 | 28 |
2150803 | 2150803 | 2022-01-25 | Baylor | Texas | 48023 | 753 | 27 |
2128055 | 2128055 | 2022-01-18 | Coke | Texas | 48081 | 753 | 18 |
2128118 | 2128118 | 2022-01-18 | Haskell | Texas | 48207 | 753 | 37 |
1877965 | 1877965 | 2021-11-02 | Wheeler | Texas | 48483 | 753 | 13 |
1874716 | 1874716 | 2021-11-01 | Wheeler | Texas | 48483 | 753 | 13 |
1871467 | 1871467 | 2021-10-31 | Wheeler | Texas | 48483 | 753 | 13 |
1868218 | 1868218 | 2021-10-30 | Wheeler | Texas | 48483 | 753 | 13 |
1679689 | 1679689 | 2021-09-02 | Martin | Texas | 48317 | 753 | 20 |
1458893 | 1458893 | 2021-06-26 | Red River | Texas | 48387 | 753 | 38 |
1400320 | 1400320 | 2021-06-08 | Coleman | Texas | 48083 | 753 | 33 |
1199228 | 1199228 | 2021-04-07 | Winkler | Texas | 48495 | 753 | 21 |
1150363 | 1150363 | 2021-03-23 | Hamilton | Texas | 48193 | 753 | 26 |
1147116 | 1147116 | 2021-03-22 | Hamilton | Texas | 48193 | 753 | 26 |
1066053 | 1066053 | 2021-02-25 | Rains | Texas | 48379 | 753 | 23 |
1013939 | 1013939 | 2021-02-09 | Archer | Texas | 48009 | 753 | 11 |
1010694 | 1010694 | 2021-02-08 | Archer | Texas | 48009 | 753 | 11 |
1007448 | 1007448 | 2021-02-07 | Archer | Texas | 48009 | 753 | 11 |
1004202 | 1004202 | 2021-02-06 | Archer | Texas | 48009 | 753 | 11 |
1000956 | 1000956 | 2021-02-05 | Archer | Texas | 48009 | 753 | 11 |
838748 | 838748 | 2020-12-17 | Duval | Texas | 48131 | 753 | 27 |
829196 | 829196 | 2020-12-14 | Zapata | Texas | 48505 | 753 | 9 |
825950 | 825950 | 2020-12-13 | Zapata | Texas | 48505 | 753 | 9 |
663620 | 663620 | 2020-10-24 | Madison | Texas | 48313 | 753 | 6 |
637613 | 637613 | 2020-10-16 | Hill | Texas | 48217 | 753 | 15 |
540400 | 540400 | 2020-09-16 | Karnes | Texas | 48255 | 753 | 16 |
537163 | 537163 | 2020-09-15 | Karnes | Texas | 48255 | 753 | 16 |
177987 | 177987 | 2020-05-25 | Galveston | Texas | 48167 | 753 | 32 |
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);