ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 468 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2154049 | 2154049 | 2022-01-26 | Armstrong | Texas | 48011 | 468 | 8 |
2102077 | 2102077 | 2022-01-10 | Fisher | Texas | 48151 | 468 | 20 |
2098826 | 2098826 | 2022-01-09 | Fisher | Texas | 48151 | 468 | 20 |
2063029 | 2063029 | 2021-12-29 | Collingsworth | Texas | 48087 | 468 | 11 |
1608179 | 1608179 | 2021-08-11 | Haskell | Texas | 48207 | 468 | 28 |
1413300 | 1413300 | 2021-06-12 | Coke | Texas | 48081 | 468 | 13 |
1410055 | 1410055 | 2021-06-11 | Coke | Texas | 48081 | 468 | 13 |
1354887 | 1354887 | 2021-05-25 | Concho | Texas | 48095 | 468 | 8 |
1351641 | 1351641 | 2021-05-24 | Concho | Texas | 48095 | 468 | 8 |
1348395 | 1348395 | 2021-05-23 | Concho | Texas | 48095 | 468 | 8 |
1088623 | 1088623 | 2021-03-04 | Coke | Texas | 48081 | 468 | 11 |
1085378 | 1085378 | 2021-03-03 | Coke | Texas | 48081 | 468 | 11 |
1004312 | 1004312 | 2021-02-06 | Hudspeth | Texas | 48229 | 468 | 11 |
1001106 | 1001106 | 2021-02-05 | Marion | Texas | 48315 | 468 | 24 |
971939 | 971939 | 2021-01-27 | Sabine | Texas | 48403 | 468 | 31 |
955568 | 955568 | 2021-01-22 | Dallam | Texas | 48111 | 468 | 20 |
952323 | 952323 | 2021-01-21 | Dallam | Texas | 48111 | 468 | 20 |
949078 | 949078 | 2021-01-20 | Dallam | Texas | 48111 | 468 | 20 |
942582 | 942582 | 2021-01-18 | Crockett | Texas | 48105 | 468 | 13 |
939337 | 939337 | 2021-01-17 | Crockett | Texas | 48105 | 468 | 13 |
913438 | 913438 | 2021-01-09 | Hudspeth | Texas | 48229 | 468 | 8 |
835575 | 835575 | 2020-12-16 | La Salle | Texas | 48283 | 468 | 14 |
670137 | 670137 | 2020-10-26 | Panola | Texas | 48365 | 468 | 28 |
650523 | 650523 | 2020-10-20 | Cass | Texas | 48067 | 468 | 21 |
640817 | 640817 | 2020-10-17 | Duval | Texas | 48131 | 468 | 20 |
533908 | 533908 | 2020-09-14 | Hill | Texas | 48217 | 468 | 12 |
530673 | 530673 | 2020-09-13 | Hill | Texas | 48217 | 468 | 12 |
524271 | 524271 | 2020-09-11 | Palo Pinto | Texas | 48363 | 468 | 14 |
356474 | 356474 | 2020-07-21 | Deaf Smith | Texas | 48117 | 468 | 17 |
305426 | 305426 | 2020-07-05 | Bastrop | Texas | 48021 | 468 | 6 |
302262 | 302262 | 2020-07-04 | Bastrop | Texas | 48021 | 468 | 6 |
75199 | 75199 | 2020-04-20 | Galveston | Texas | 48167 | 468 | 19 |
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);