ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where deaths = 507 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420982 | 2420982 | 2022-04-18 | Randall | Texas | 48381 | 38176 | 507 |
2241993 | 2241993 | 2022-02-22 | Kaufman | Texas | 48257 | 34728 | 507 |
2238742 | 2238742 | 2022-02-21 | Kaufman | Texas | 48257 | 34710 | 507 |
2235491 | 2235491 | 2022-02-20 | Kaufman | Texas | 48257 | 34692 | 507 |
1946061 | 1946061 | 2021-11-23 | Grayson | Texas | 48181 | 16432 | 507 |
1942810 | 1942810 | 2021-11-22 | Grayson | Texas | 48181 | 16432 | 507 |
1796562 | 1796562 | 2021-10-08 | Ector | Texas | 48135 | 25238 | 507 |
1796586 | 1796586 | 2021-10-08 | Gregg | Texas | 48183 | 18939 | 507 |
1656812 | 1656812 | 2021-08-26 | Bell | Texas | 48027 | 31243 | 507 |
1656882 | 1656882 | 2021-08-26 | Galveston | Texas | 48167 | 52705 | 507 |
1653763 | 1653763 | 2021-08-25 | Smith | Texas | 48423 | 25678 | 507 |
1630970 | 1630970 | 2021-08-18 | McLennan | Texas | 48309 | 30940 | 507 |
1627808 | 1627808 | 2021-08-17 | Williamson | Texas | 48491 | 57527 | 507 |
1624561 | 1624561 | 2021-08-16 | Williamson | Texas | 48491 | 56780 | 507 |
1010768 | 1010768 | 2021-02-08 | Fort Bend | Texas | 48157 | 53153 | 507 |
832417 | 832417 | 2020-12-15 | Travis | Texas | 48453 | 43469 | 507 |
829170 | 829170 | 2020-12-14 | Travis | Texas | 48453 | 42856 | 507 |
816136 | 816136 | 2020-12-10 | Nueces | Texas | 48355 | 25530 | 507 |
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);