ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 1312 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2108601 | 2108601 | 2022-01-12 | Hansford | Texas | 48195 | 1312 | 27 |
1991729 | 1991729 | 2021-12-07 | Yoakum | Texas | 48501 | 1312 | 35 |
1968733 | 1968733 | 2021-11-30 | Archer | Texas | 48009 | 1312 | 23 |
1965482 | 1965482 | 2021-11-29 | Archer | Texas | 48009 | 1312 | 23 |
1851766 | 1851766 | 2021-10-25 | Castro | Texas | 48069 | 1312 | 37 |
1848516 | 1848516 | 2021-10-24 | Castro | Texas | 48069 | 1312 | 37 |
1845266 | 1845266 | 2021-10-23 | Castro | Texas | 48069 | 1312 | 37 |
1432919 | 1432919 | 2021-06-18 | Parmer | Texas | 48369 | 1312 | 35 |
1270654 | 1270654 | 2021-04-29 | Tyler | Texas | 48457 | 1312 | 38 |
1267407 | 1267407 | 2021-04-28 | Tyler | Texas | 48457 | 1312 | 37 |
1264160 | 1264160 | 2021-04-27 | Tyler | Texas | 48457 | 1312 | 37 |
1134100 | 1134100 | 2021-03-18 | Eastland | Texas | 48133 | 1312 | 45 |
874547 | 874547 | 2020-12-28 | Montague | Texas | 48337 | 1312 | 34 |
871302 | 871302 | 2020-12-27 | Montague | Texas | 48337 | 1312 | 34 |
504811 | 504811 | 2020-09-05 | Jim Wells | Texas | 48249 | 1312 | 28 |
501577 | 501577 | 2020-09-04 | Jim Wells | Texas | 48249 | 1312 | 26 |
404839 | 404839 | 2020-08-05 | Titus | Texas | 48449 | 1312 | 14 |
401621 | 401621 | 2020-08-04 | Titus | Texas | 48449 | 1312 | 14 |
242725 | 242725 | 2020-06-15 | Galveston | Texas | 48167 | 1312 | 40 |
196299 | 196299 | 2020-05-31 | Collin | Texas | 48085 | 1312 | 34 |
83680 | 83680 | 2020-04-23 | Travis | Texas | 48453 | 1312 | 31 |
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);