ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 732 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271261 | 2271261 | 2022-03-03 | Kinney | Texas | 48271 | 732 | 10 |
2154236 | 2154236 | 2022-01-26 | Real | Texas | 48385 | 732 | 22 |
2147771 | 2147771 | 2022-01-24 | Upton | Texas | 48461 | 732 | 16 |
2082532 | 2082532 | 2022-01-04 | Coke | Texas | 48081 | 732 | 18 |
1764035 | 1764035 | 2021-09-28 | Carson | Texas | 48065 | 732 | 18 |
1653718 | 1653718 | 2021-08-25 | Mills | Texas | 48333 | 732 | 24 |
1332189 | 1332189 | 2021-05-18 | Franklin | Texas | 48159 | 732 | 26 |
1328942 | 1328942 | 2021-05-17 | Franklin | Texas | 48159 | 732 | 26 |
1325696 | 1325696 | 2021-05-16 | Franklin | Texas | 48159 | 732 | 26 |
1280182 | 1280182 | 2021-05-02 | Blanco | Texas | 48031 | 732 | 20 |
1276935 | 1276935 | 2021-05-01 | Blanco | Texas | 48031 | 732 | 20 |
1062833 | 1062833 | 2021-02-24 | Stephens | Texas | 48429 | 732 | 24 |
1020639 | 1020639 | 2021-02-11 | Stephens | Texas | 48429 | 732 | 22 |
1000975 | 1000975 | 2021-02-05 | Brooks | Texas | 48047 | 732 | 31 |
997920 | 997920 | 2021-02-04 | Stephens | Texas | 48429 | 732 | 21 |
988065 | 988065 | 2021-02-01 | Hansford | Texas | 48195 | 732 | 18 |
984818 | 984818 | 2021-01-31 | Hansford | Texas | 48195 | 732 | 18 |
981571 | 981571 | 2021-01-30 | Hansford | Texas | 48195 | 732 | 18 |
838717 | 838717 | 2020-12-17 | Castro | Texas | 48069 | 732 | 12 |
501651 | 501651 | 2020-09-04 | Rusk | Texas | 48401 | 732 | 5 |
472478 | 472478 | 2020-08-26 | Karnes | Texas | 48255 | 732 | 11 |
258437 | 258437 | 2020-06-20 | Titus | Texas | 48449 | 732 | 5 |
165825 | 165825 | 2020-05-21 | Galveston | Texas | 48167 | 732 | 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);