ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 464 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Angelina 7
- Comal 6
- Williamson 4
- El Paso 3
- Bell 1
- Fort Bend 1
- Montgomery 1
- Randall 1
- Wichita 1
state 1
- Texas · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264623 | 2264623 | 2022-03-01 | Angelina | Texas | 48005 | 15238 | 464 |
2261373 | 2261373 | 2022-02-28 | Angelina | Texas | 48005 | 15235 | 464 |
2258122 | 2258122 | 2022-02-27 | Angelina | Texas | 48005 | 15235 | 464 |
2254871 | 2254871 | 2022-02-26 | Angelina | Texas | 48005 | 15235 | 464 |
2251620 | 2251620 | 2022-02-25 | Angelina | Texas | 48005 | 15224 | 464 |
2248369 | 2248369 | 2022-02-24 | Angelina | Texas | 48005 | 15217 | 464 |
2245118 | 2245118 | 2022-02-23 | Angelina | Texas | 48005 | 15216 | 464 |
2225800 | 2225800 | 2022-02-17 | Randall | Texas | 48381 | 37383 | 464 |
1946016 | 1946016 | 2021-11-23 | Comal | Texas | 48091 | 20091 | 464 |
1942765 | 1942765 | 2021-11-22 | Comal | Texas | 48091 | 20026 | 464 |
1939515 | 1939515 | 2021-11-21 | Comal | Texas | 48091 | 20026 | 464 |
1936265 | 1936265 | 2021-11-20 | Comal | Texas | 48091 | 20026 | 464 |
1933015 | 1933015 | 2021-11-19 | Comal | Texas | 48091 | 19996 | 464 |
1929764 | 1929764 | 2021-11-18 | Comal | Texas | 48091 | 19971 | 464 |
1793488 | 1793488 | 2021-10-07 | Wichita | Texas | 48485 | 21162 | 464 |
1585346 | 1585346 | 2021-08-04 | Bell | Texas | 48027 | 27441 | 464 |
1293397 | 1293397 | 2021-05-06 | Williamson | Texas | 48491 | 45817 | 464 |
1290151 | 1290151 | 2021-05-05 | Williamson | Texas | 48491 | 45759 | 464 |
1286905 | 1286905 | 2021-05-04 | Williamson | Texas | 48491 | 45706 | 464 |
1283659 | 1283659 | 2021-05-03 | Williamson | Texas | 48491 | 45648 | 464 |
1088752 | 1088752 | 2021-03-04 | Montgomery | Texas | 48339 | 46058 | 464 |
968571 | 968571 | 2021-01-26 | Fort Bend | Texas | 48157 | 48425 | 464 |
514454 | 514454 | 2020-09-08 | El Paso | Texas | 48141 | 21187 | 464 |
511221 | 511221 | 2020-09-07 | El Paso | Texas | 48141 | 21093 | 464 |
507988 | 507988 | 2020-09-06 | El Paso | Texas | 48141 | 20939 | 464 |
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);