ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 456 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290799 | 2290799 | 2022-03-09 | Maverick | Texas | 48323 | 20682 | 456 |
2287547 | 2287547 | 2022-03-08 | Maverick | Texas | 48323 | 20678 | 456 |
2284295 | 2284295 | 2022-03-07 | Maverick | Texas | 48323 | 20677 | 456 |
2281043 | 2281043 | 2022-03-06 | Maverick | Texas | 48323 | 20673 | 456 |
2277790 | 2277790 | 2022-03-05 | Maverick | Texas | 48323 | 20668 | 456 |
2274604 | 2274604 | 2022-03-04 | Tom Green | Texas | 48451 | 40838 | 456 |
2202849 | 2202849 | 2022-02-10 | Angelina | Texas | 48005 | 15126 | 456 |
2193249 | 2193249 | 2022-02-07 | Midland | Texas | 48329 | 35650 | 456 |
2189995 | 2189995 | 2022-02-06 | Midland | Texas | 48329 | 35619 | 456 |
2102130 | 2102130 | 2022-01-10 | Kaufman | Texas | 48257 | 27767 | 456 |
2098879 | 2098879 | 2022-01-09 | Kaufman | Texas | 48257 | 27577 | 456 |
2095627 | 2095627 | 2022-01-08 | Kaufman | Texas | 48257 | 27318 | 456 |
2092375 | 2092375 | 2022-01-07 | Kaufman | Texas | 48257 | 26979 | 456 |
1903767 | 1903767 | 2021-11-10 | Comal | Texas | 48091 | 19775 | 456 |
1900517 | 1900517 | 2021-11-09 | Comal | Texas | 48091 | 19746 | 456 |
1897267 | 1897267 | 2021-11-08 | Comal | Texas | 48091 | 19676 | 456 |
1894017 | 1894017 | 2021-11-07 | Comal | Texas | 48091 | 19662 | 456 |
1890767 | 1890767 | 2021-11-06 | Comal | Texas | 48091 | 19662 | 456 |
1747852 | 1747852 | 2021-09-23 | Gregg | Texas | 48183 | 18021 | 456 |
1705749 | 1705749 | 2021-09-10 | Taylor | Texas | 48441 | 19315 | 456 |
1559429 | 1559429 | 2021-07-27 | Galveston | Texas | 48167 | 43241 | 456 |
1556182 | 1556182 | 2021-07-26 | Galveston | Texas | 48167 | 42809 | 456 |
1552935 | 1552935 | 2021-07-25 | Galveston | Texas | 48167 | 42809 | 456 |
1549688 | 1549688 | 2021-07-24 | Galveston | Texas | 48167 | 42809 | 456 |
1546441 | 1546441 | 2021-07-23 | Galveston | Texas | 48167 | 42649 | 456 |
1377748 | 1377748 | 2021-06-01 | Potter | Texas | 48375 | 17543 | 456 |
1374502 | 1374502 | 2021-05-31 | Potter | Texas | 48375 | 17543 | 456 |
1371257 | 1371257 | 2021-05-30 | Potter | Texas | 48375 | 17543 | 456 |
1368011 | 1368011 | 2021-05-29 | Potter | Texas | 48375 | 17543 | 456 |
1364765 | 1364765 | 2021-05-28 | Potter | Texas | 48375 | 17543 | 456 |
1225176 | 1225176 | 2021-04-15 | Smith | Texas | 48423 | 19868 | 456 |
1199226 | 1199226 | 2021-04-07 | Williamson | Texas | 48491 | 43590 | 456 |
731756 | 731756 | 2020-11-14 | Nueces | Texas | 48355 | 22133 | 456 |
728511 | 728511 | 2020-11-13 | Nueces | Texas | 48355 | 22133 | 456 |
702613 | 702613 | 2020-11-05 | Travis | Texas | 48453 | 32748 | 456 |
699370 | 699370 | 2020-11-04 | Travis | Texas | 48453 | 32605 | 456 |
696126 | 696126 | 2020-11-03 | Travis | Texas | 48453 | 32451 | 456 |
372561 | 372561 | 2020-07-26 | Hidalgo | Texas | 48215 | 15153 | 456 |
369349 | 369349 | 2020-07-25 | Hidalgo | Texas | 48215 | 15153 | 456 |
366140 | 366140 | 2020-07-24 | Hidalgo | Texas | 48215 | 15093 | 456 |
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);