ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 685 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469839 | 2469839 | 2022-05-03 | Shackelford | Texas | 48417 | 685 | 12 |
2466583 | 2466583 | 2022-05-02 | Shackelford | Texas | 48417 | 685 | 12 |
2463328 | 2463328 | 2022-05-01 | Shackelford | Texas | 48417 | 685 | 12 |
2460072 | 2460072 | 2022-04-30 | Shackelford | Texas | 48417 | 685 | 12 |
2251661 | 2251661 | 2022-02-25 | Collingsworth | Texas | 48087 | 685 | 16 |
2248410 | 2248410 | 2022-02-24 | Collingsworth | Texas | 48087 | 685 | 16 |
2102193 | 2102193 | 2022-01-10 | Reagan | Texas | 48383 | 685 | 11 |
2063089 | 2063089 | 2021-12-29 | Haskell | Texas | 48207 | 685 | 37 |
2059839 | 2059839 | 2021-12-28 | Haskell | Texas | 48207 | 685 | 37 |
1968769 | 1968769 | 2021-11-30 | Coke | Texas | 48081 | 685 | 18 |
1673090 | 1673090 | 2021-08-31 | Crane | Texas | 48103 | 685 | 14 |
1601744 | 1601744 | 2021-08-09 | Mills | Texas | 48333 | 685 | 21 |
1591934 | 1591934 | 2021-08-06 | Hartley | Texas | 48205 | 685 | 2 |
1445914 | 1445914 | 2021-06-22 | Refugio | Texas | 48391 | 685 | 23 |
1442669 | 1442669 | 2021-06-21 | Refugio | Texas | 48391 | 685 | 23 |
1439424 | 1439424 | 2021-06-20 | Refugio | Texas | 48391 | 685 | 23 |
1436177 | 1436177 | 2021-06-19 | Refugio | Texas | 48391 | 685 | 23 |
1432930 | 1432930 | 2021-06-18 | Refugio | Texas | 48391 | 685 | 23 |
1429684 | 1429684 | 2021-06-17 | Refugio | Texas | 48391 | 685 | 23 |
1426439 | 1426439 | 2021-06-16 | Refugio | Texas | 48391 | 685 | 23 |
1423192 | 1423192 | 2021-06-15 | Refugio | Texas | 48391 | 685 | 23 |
1419946 | 1419946 | 2021-06-14 | Refugio | Texas | 48391 | 685 | 23 |
1416701 | 1416701 | 2021-06-13 | Refugio | Texas | 48391 | 685 | 23 |
1091844 | 1091844 | 2021-03-05 | Blanco | Texas | 48031 | 685 | 18 |
1088598 | 1088598 | 2021-03-04 | Blanco | Texas | 48031 | 685 | 18 |
1059453 | 1059453 | 2021-02-23 | Franklin | Texas | 48159 | 685 | 24 |
1001199 | 1001199 | 2021-02-05 | Winkler | Texas | 48495 | 685 | 18 |
978304 | 978304 | 2021-01-29 | Floyd | Texas | 48153 | 685 | 29 |
975059 | 975059 | 2021-01-28 | Floyd | Texas | 48153 | 685 | 28 |
975171 | 975171 | 2021-01-28 | Presidio | Texas | 48377 | 685 | 22 |
945800 | 945800 | 2021-01-19 | Brooks | Texas | 48047 | 685 | 29 |
861540 | 861540 | 2020-12-24 | Lampasas | Texas | 48281 | 685 | 14 |
858183 | 858183 | 2020-12-23 | Callahan | Texas | 48059 | 685 | 14 |
845205 | 845205 | 2020-12-19 | Camp | Texas | 48063 | 685 | 21 |
819442 | 819442 | 2020-12-11 | Ward | Texas | 48475 | 685 | 7 |
767467 | 767467 | 2020-11-25 | Parmer | Texas | 48369 | 685 | 22 |
498453 | 498453 | 2020-09-03 | Waller | Texas | 48473 | 685 | 8 |
453128 | 453128 | 2020-08-20 | Madison | Texas | 48313 | 685 | 3 |
449900 | 449900 | 2020-08-19 | Madison | Texas | 48313 | 685 | 3 |
430542 | 430542 | 2020-08-13 | Madison | Texas | 48313 | 685 | 2 |
132734 | 132734 | 2020-05-10 | Galveston | Texas | 48167 | 685 | 29 |
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);