ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 470 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264811 | 2264811 | 2022-03-01 | Randall | Texas | 48381 | 37487 | 470 |
2229025 | 2229025 | 2022-02-18 | Midland | Texas | 48329 | 36480 | 470 |
2157425 | 2157425 | 2022-01-27 | Kaufman | Texas | 48257 | 32689 | 470 |
1994775 | 1994775 | 2021-12-08 | Comal | Texas | 48091 | 20448 | 470 |
1991524 | 1991524 | 2021-12-07 | Comal | Texas | 48091 | 20420 | 470 |
1988273 | 1988273 | 2021-12-06 | Comal | Texas | 48091 | 20365 | 470 |
1985023 | 1985023 | 2021-12-05 | Comal | Texas | 48091 | 20365 | 470 |
1981773 | 1981773 | 2021-12-04 | Comal | Texas | 48091 | 20365 | 470 |
1978523 | 1978523 | 2021-12-03 | Comal | Texas | 48091 | 20345 | 470 |
1903792 | 1903792 | 2021-11-10 | Ellis | Texas | 48139 | 33917 | 470 |
1900542 | 1900542 | 2021-11-09 | Ellis | Texas | 48139 | 33917 | 470 |
1897292 | 1897292 | 2021-11-08 | Ellis | Texas | 48139 | 33878 | 470 |
1894042 | 1894042 | 2021-11-07 | Ellis | Texas | 48139 | 33878 | 470 |
1890792 | 1890792 | 2021-11-06 | Ellis | Texas | 48139 | 33878 | 470 |
1832325 | 1832325 | 2021-10-19 | Grayson | Texas | 48181 | 16067 | 470 |
1608159 | 1608159 | 2021-08-11 | Galveston | Texas | 48167 | 47978 | 470 |
1608263 | 1608263 | 2021-08-11 | Potter | Texas | 48375 | 18880 | 470 |
1604840 | 1604840 | 2021-08-10 | Bell | Texas | 48027 | 28072 | 470 |
1319370 | 1319370 | 2021-05-14 | Williamson | Texas | 48491 | 46265 | 470 |
1316122 | 1316122 | 2021-05-13 | Williamson | Texas | 48491 | 46184 | 470 |
1312842 | 1312842 | 2021-05-12 | Smith | Texas | 48423 | 20287 | 470 |
1293312 | 1293312 | 2021-05-06 | McLennan | Texas | 48309 | 27090 | 470 |
1290066 | 1290066 | 2021-05-05 | McLennan | Texas | 48309 | 27043 | 470 |
1286820 | 1286820 | 2021-05-04 | McLennan | Texas | 48309 | 27043 | 470 |
1283574 | 1283574 | 2021-05-03 | McLennan | Texas | 48309 | 27043 | 470 |
1280327 | 1280327 | 2021-05-02 | McLennan | Texas | 48309 | 26984 | 470 |
1277080 | 1277080 | 2021-05-01 | McLennan | Texas | 48309 | 26984 | 470 |
1273833 | 1273833 | 2021-04-30 | McLennan | Texas | 48309 | 26984 | 470 |
1270586 | 1270586 | 2021-04-29 | McLennan | Texas | 48309 | 26896 | 470 |
1267339 | 1267339 | 2021-04-28 | McLennan | Texas | 48309 | 26896 | 470 |
1264092 | 1264092 | 2021-04-27 | McLennan | Texas | 48309 | 26836 | 470 |
1260845 | 1260845 | 2021-04-26 | McLennan | Texas | 48309 | 26822 | 470 |
1257598 | 1257598 | 2021-04-25 | McLennan | Texas | 48309 | 26761 | 470 |
1254351 | 1254351 | 2021-04-24 | McLennan | Texas | 48309 | 26761 | 470 |
760970 | 760970 | 2020-11-23 | Nueces | Texas | 48355 | 23181 | 470 |
524161 | 524161 | 2020-09-11 | El Paso | Texas | 48141 | 21458 | 470 |
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);