ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 438 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313523 | 2313523 | 2022-03-16 | Irion | Texas | 48235 | 438 | 3 |
2310270 | 2310270 | 2022-03-15 | Irion | Texas | 48235 | 438 | 3 |
2307017 | 2307017 | 2022-03-14 | Irion | Texas | 48235 | 438 | 3 |
2303766 | 2303766 | 2022-03-13 | Irion | Texas | 48235 | 438 | 3 |
2300514 | 2300514 | 2022-03-12 | Irion | Texas | 48235 | 438 | 3 |
2297262 | 2297262 | 2022-03-11 | Irion | Texas | 48235 | 438 | 3 |
2294010 | 2294010 | 2022-03-10 | Irion | Texas | 48235 | 438 | 3 |
2290758 | 2290758 | 2022-03-09 | Irion | Texas | 48235 | 438 | 3 |
2287506 | 2287506 | 2022-03-08 | Irion | Texas | 48235 | 438 | 3 |
2284254 | 2284254 | 2022-03-07 | Irion | Texas | 48235 | 438 | 3 |
2281002 | 2281002 | 2022-03-06 | Irion | Texas | 48235 | 438 | 3 |
2277749 | 2277749 | 2022-03-05 | Irion | Texas | 48235 | 438 | 3 |
2274496 | 2274496 | 2022-03-04 | Irion | Texas | 48235 | 438 | 3 |
2271243 | 2271243 | 2022-03-03 | Irion | Texas | 48235 | 438 | 3 |
2267991 | 2267991 | 2022-03-02 | Irion | Texas | 48235 | 438 | 3 |
2264738 | 2264738 | 2022-03-01 | Irion | Texas | 48235 | 438 | 3 |
2261488 | 2261488 | 2022-02-28 | Irion | Texas | 48235 | 438 | 3 |
2258237 | 2258237 | 2022-02-27 | Irion | Texas | 48235 | 438 | 3 |
2254986 | 2254986 | 2022-02-26 | Irion | Texas | 48235 | 438 | 3 |
2251735 | 2251735 | 2022-02-25 | Irion | Texas | 48235 | 438 | 3 |
2248484 | 2248484 | 2022-02-24 | Irion | Texas | 48235 | 438 | 3 |
2245233 | 2245233 | 2022-02-23 | Irion | Texas | 48235 | 438 | 3 |
2241982 | 2241982 | 2022-02-22 | Irion | Texas | 48235 | 438 | 3 |
2115218 | 2115218 | 2022-01-14 | Sherman | Texas | 48421 | 438 | 16 |
1972054 | 1972054 | 2021-12-01 | Fisher | Texas | 48151 | 438 | 17 |
1968804 | 1968804 | 2021-11-30 | Fisher | Texas | 48151 | 438 | 17 |
1942867 | 1942867 | 2021-11-22 | Lipscomb | Texas | 48295 | 438 | 12 |
1939617 | 1939617 | 2021-11-21 | Lipscomb | Texas | 48295 | 438 | 12 |
1936367 | 1936367 | 2021-11-20 | Lipscomb | Texas | 48295 | 438 | 12 |
1829025 | 1829025 | 2021-10-18 | Cochran | Texas | 48079 | 438 | 18 |
1825776 | 1825776 | 2021-10-17 | Cochran | Texas | 48079 | 438 | 18 |
1822527 | 1822527 | 2021-10-16 | Cochran | Texas | 48079 | 438 | 18 |
1624380 | 1624380 | 2021-08-16 | Donley | Texas | 48129 | 438 | 15 |
1621133 | 1621133 | 2021-08-15 | Donley | Texas | 48129 | 438 | 15 |
1617885 | 1617885 | 2021-08-14 | Donley | Texas | 48129 | 438 | 15 |
1614637 | 1614637 | 2021-08-13 | Donley | Texas | 48129 | 438 | 15 |
1611388 | 1611388 | 2021-08-12 | Donley | Texas | 48129 | 438 | 15 |
1611480 | 1611480 | 2021-08-12 | Mason | Texas | 48319 | 438 | 6 |
1608140 | 1608140 | 2021-08-11 | Donley | Texas | 48129 | 438 | 15 |
1608232 | 1608232 | 2021-08-11 | Mason | Texas | 48319 | 438 | 6 |
1604891 | 1604891 | 2021-08-10 | Donley | Texas | 48129 | 438 | 15 |
1173103 | 1173103 | 2021-03-30 | Haskell | Texas | 48207 | 438 | 27 |
1114640 | 1114640 | 2021-03-12 | Goliad | Texas | 48175 | 438 | 13 |
1111394 | 1111394 | 2021-03-11 | Goliad | Texas | 48175 | 438 | 13 |
1108148 | 1108148 | 2021-03-10 | Goliad | Texas | 48175 | 438 | 13 |
1104902 | 1104902 | 2021-03-09 | Goliad | Texas | 48175 | 438 | 13 |
1101656 | 1101656 | 2021-03-08 | Goliad | Texas | 48175 | 438 | 13 |
1098410 | 1098410 | 2021-03-07 | Goliad | Texas | 48175 | 438 | 13 |
1095162 | 1095162 | 2021-03-06 | Goliad | Texas | 48175 | 438 | 13 |
1091916 | 1091916 | 2021-03-05 | Goliad | Texas | 48175 | 438 | 13 |
1088670 | 1088670 | 2021-03-04 | Goliad | Texas | 48175 | 438 | 13 |
1085425 | 1085425 | 2021-03-03 | Goliad | Texas | 48175 | 438 | 13 |
1082179 | 1082179 | 2021-03-02 | Goliad | Texas | 48175 | 438 | 13 |
1078886 | 1078886 | 2021-03-01 | Coke | Texas | 48081 | 438 | 11 |
1075641 | 1075641 | 2021-02-28 | Coke | Texas | 48081 | 438 | 11 |
1072395 | 1072395 | 2021-02-27 | Coke | Texas | 48081 | 438 | 11 |
1069149 | 1069149 | 2021-02-26 | Coke | Texas | 48081 | 438 | 11 |
1065904 | 1065904 | 2021-02-25 | Coke | Texas | 48081 | 438 | 11 |
1062659 | 1062659 | 2021-02-24 | Coke | Texas | 48081 | 438 | 11 |
1059414 | 1059414 | 2021-02-23 | Coke | Texas | 48081 | 438 | 11 |
971892 | 971892 | 2021-01-27 | Marion | Texas | 48315 | 438 | 21 |
955553 | 955553 | 2021-01-22 | Coke | Texas | 48081 | 438 | 10 |
845345 | 845345 | 2020-12-19 | Morris | Texas | 48343 | 438 | 8 |
838687 | 838687 | 2020-12-17 | Archer | Texas | 48009 | 438 | 4 |
816097 | 816097 | 2020-12-10 | La Salle | Texas | 48283 | 438 | 14 |
786757 | 786757 | 2020-12-01 | Aransas | Texas | 48007 | 438 | 19 |
715612 | 715612 | 2020-11-09 | Yoakum | Texas | 48501 | 438 | 10 |
712368 | 712368 | 2020-11-08 | Yoakum | Texas | 48501 | 438 | 10 |
709124 | 709124 | 2020-11-07 | Yoakum | Texas | 48501 | 438 | 8 |
647326 | 647326 | 2020-10-19 | Freestone | Texas | 48161 | 438 | 4 |
644080 | 644080 | 2020-10-18 | Freestone | Texas | 48161 | 438 | 4 |
640832 | 640832 | 2020-10-17 | Freestone | Texas | 48161 | 438 | 4 |
540347 | 540347 | 2020-09-16 | Fayette | Texas | 48149 | 438 | 18 |
537149 | 537149 | 2020-09-15 | Howard | Texas | 48227 | 438 | 10 |
495118 | 495118 | 2020-09-02 | Kerr | Texas | 48265 | 438 | 9 |
491884 | 491884 | 2020-09-01 | Kerr | Texas | 48265 | 438 | 9 |
491959 | 491959 | 2020-09-01 | Shelby | Texas | 48419 | 438 | 19 |
446640 | 446640 | 2020-08-18 | Jackson | Texas | 48239 | 438 | 11 |
292790 | 292790 | 2020-07-01 | Bowie | Texas | 48037 | 438 | 17 |
242732 | 242732 | 2020-06-15 | Grayson | Texas | 48181 | 438 | 4 |
174884 | 174884 | 2020-05-24 | Brazos | Texas | 48041 | 438 | 19 |
66896 | 66896 | 2020-04-17 | Galveston | Texas | 48167 | 438 | 14 |
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);