ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 975 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2206195 | 2206195 | 2022-02-11 | Hall | Texas | 48191 | 975 | 21 |
2137796 | 2137796 | 2022-01-21 | Brewster | Texas | 48043 | 975 | 25 |
2105455 | 2105455 | 2022-01-11 | San Augustine | Texas | 48405 | 975 | 38 |
2056646 | 2056646 | 2021-12-27 | McCulloch | Texas | 48307 | 975 | 40 |
2033914 | 2033914 | 2021-12-20 | Newton | Texas | 48351 | 975 | 54 |
1923337 | 1923337 | 2021-11-16 | Jack | Texas | 48237 | 975 | 21 |
1796548 | 1796548 | 2021-10-08 | Crosby | Texas | 48107 | 975 | 34 |
1738021 | 1738021 | 2021-09-20 | Bailey | Texas | 48017 | 975 | 23 |
1734771 | 1734771 | 2021-09-19 | Bailey | Texas | 48017 | 975 | 23 |
1731521 | 1731521 | 2021-09-18 | Bailey | Texas | 48017 | 975 | 23 |
1656992 | 1656992 | 2021-08-26 | Red River | Texas | 48387 | 975 | 40 |
1228247 | 1228247 | 2021-04-16 | Castro | Texas | 48069 | 975 | 32 |
1224999 | 1224999 | 2021-04-15 | Castro | Texas | 48069 | 975 | 32 |
1221752 | 1221752 | 2021-04-14 | Castro | Texas | 48069 | 975 | 32 |
1218504 | 1218504 | 2021-04-13 | Castro | Texas | 48069 | 975 | 32 |
1053085 | 1053085 | 2021-02-21 | San Jacinto | Texas | 48407 | 975 | 24 |
1013973 | 1013973 | 2021-02-09 | Clay | Texas | 48077 | 975 | 16 |
955750 | 955750 | 2021-01-22 | Ward | Texas | 48475 | 975 | 13 |
793495 | 793495 | 2020-12-03 | Young | Texas | 48503 | 975 | 21 |
764066 | 764066 | 2020-11-24 | Calhoun | Texas | 48057 | 975 | 9 |
634505 | 634505 | 2020-10-15 | Wilson | Texas | 48493 | 975 | 28 |
614914 | 614914 | 2020-10-09 | Howard | Texas | 48227 | 975 | 17 |
579226 | 579226 | 2020-09-28 | Frio | Texas | 48163 | 975 | 9 |
575985 | 575985 | 2020-09-27 | Frio | Texas | 48163 | 975 | 9 |
572741 | 572741 | 2020-09-26 | Frio | Texas | 48163 | 975 | 9 |
556519 | 556519 | 2020-09-21 | DeWitt | Texas | 48123 | 975 | 33 |
553282 | 553282 | 2020-09-20 | DeWitt | Texas | 48123 | 975 | 33 |
550043 | 550043 | 2020-09-19 | DeWitt | Texas | 48123 | 975 | 33 |
527483 | 527483 | 2020-09-12 | Matagorda | Texas | 48321 | 975 | 40 |
331038 | 331038 | 2020-07-13 | Starr | Texas | 48427 | 975 | 4 |
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);