ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
394 rows where deaths = 154 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502388 | 2502388 | 2022-05-13 | Palo Pinto | Texas | 48363 | 7052 | 154 |
2499130 | 2499130 | 2022-05-12 | Palo Pinto | Texas | 48363 | 7050 | 154 |
2495872 | 2495872 | 2022-05-11 | Palo Pinto | Texas | 48363 | 7048 | 154 |
2492614 | 2492614 | 2022-05-10 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2489356 | 2489356 | 2022-05-09 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2486099 | 2486099 | 2022-05-08 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2482841 | 2482841 | 2022-05-07 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2479583 | 2479583 | 2022-05-06 | Palo Pinto | Texas | 48363 | 7045 | 154 |
2476325 | 2476325 | 2022-05-05 | Palo Pinto | Texas | 48363 | 7045 | 154 |
2473068 | 2473068 | 2022-05-04 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2469812 | 2469812 | 2022-05-03 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2466556 | 2466556 | 2022-05-02 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2463301 | 2463301 | 2022-05-01 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2460045 | 2460045 | 2022-04-30 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2456789 | 2456789 | 2022-04-29 | Palo Pinto | Texas | 48363 | 7042 | 154 |
2453533 | 2453533 | 2022-04-28 | Palo Pinto | Texas | 48363 | 7041 | 154 |
2450277 | 2450277 | 2022-04-27 | Palo Pinto | Texas | 48363 | 7037 | 154 |
2447020 | 2447020 | 2022-04-26 | Palo Pinto | Texas | 48363 | 7037 | 154 |
2443765 | 2443765 | 2022-04-25 | Palo Pinto | Texas | 48363 | 7037 | 154 |
2440509 | 2440509 | 2022-04-24 | Palo Pinto | Texas | 48363 | 7037 | 154 |
2437253 | 2437253 | 2022-04-23 | Palo Pinto | Texas | 48363 | 7037 | 154 |
2433997 | 2433997 | 2022-04-22 | Palo Pinto | Texas | 48363 | 7036 | 154 |
2430741 | 2430741 | 2022-04-21 | Palo Pinto | Texas | 48363 | 7035 | 154 |
2427485 | 2427485 | 2022-04-20 | Palo Pinto | Texas | 48363 | 7033 | 154 |
2424229 | 2424229 | 2022-04-19 | Palo Pinto | Texas | 48363 | 7032 | 154 |
2420973 | 2420973 | 2022-04-18 | Palo Pinto | Texas | 48363 | 7031 | 154 |
2417717 | 2417717 | 2022-04-17 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2414461 | 2414461 | 2022-04-16 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2411205 | 2411205 | 2022-04-15 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2407949 | 2407949 | 2022-04-14 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2404693 | 2404693 | 2022-04-13 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2401438 | 2401438 | 2022-04-12 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2398183 | 2398183 | 2022-04-11 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2394928 | 2394928 | 2022-04-10 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2391672 | 2391672 | 2022-04-09 | Palo Pinto | Texas | 48363 | 7027 | 154 |
2232138 | 2232138 | 2022-02-19 | Burnet | Texas | 48053 | 10599 | 154 |
2228887 | 2228887 | 2022-02-18 | Burnet | Texas | 48053 | 10587 | 154 |
2228970 | 2228970 | 2022-02-18 | Hockley | Texas | 48219 | 7541 | 154 |
2225719 | 2225719 | 2022-02-17 | Hockley | Texas | 48219 | 7540 | 154 |
2225856 | 2225856 | 2022-02-17 | Wilson | Texas | 48493 | 10562 | 154 |
2222468 | 2222468 | 2022-02-16 | Hockley | Texas | 48219 | 7535 | 154 |
2222605 | 2222605 | 2022-02-16 | Wilson | Texas | 48493 | 10544 | 154 |
2219217 | 2219217 | 2022-02-15 | Hockley | Texas | 48219 | 7527 | 154 |
2215966 | 2215966 | 2022-02-14 | Hockley | Texas | 48219 | 7515 | 154 |
2212715 | 2212715 | 2022-02-13 | Hockley | Texas | 48219 | 7512 | 154 |
2209462 | 2209462 | 2022-02-12 | Hockley | Texas | 48219 | 7503 | 154 |
2206209 | 2206209 | 2022-02-11 | Hockley | Texas | 48219 | 7489 | 154 |
2202956 | 2202956 | 2022-02-10 | Hockley | Texas | 48219 | 7483 | 154 |
2199702 | 2199702 | 2022-02-09 | Hockley | Texas | 48219 | 7473 | 154 |
2196448 | 2196448 | 2022-02-08 | Hockley | Texas | 48219 | 7463 | 154 |
2193194 | 2193194 | 2022-02-07 | Hockley | Texas | 48219 | 7446 | 154 |
2189940 | 2189940 | 2022-02-06 | Hockley | Texas | 48219 | 7445 | 154 |
2186687 | 2186687 | 2022-02-05 | Hockley | Texas | 48219 | 7429 | 154 |
2160685 | 2160685 | 2022-01-28 | Kerr | Texas | 48265 | 8848 | 154 |
2157429 | 2157429 | 2022-01-27 | Kerr | Texas | 48265 | 8815 | 154 |
2115121 | 2115121 | 2022-01-14 | Howard | Texas | 48227 | 5700 | 154 |
2111867 | 2111867 | 2022-01-13 | Hopkins | Texas | 48223 | 6816 | 154 |
2108615 | 2108615 | 2022-01-12 | Hopkins | Texas | 48223 | 6764 | 154 |
2105364 | 2105364 | 2022-01-11 | Hopkins | Texas | 48223 | 6703 | 154 |
2102113 | 2102113 | 2022-01-10 | Hopkins | Texas | 48223 | 6687 | 154 |
2098862 | 2098862 | 2022-01-09 | Hopkins | Texas | 48223 | 6654 | 154 |
2095610 | 2095610 | 2022-01-08 | Hopkins | Texas | 48223 | 6627 | 154 |
2092358 | 2092358 | 2022-01-07 | Hopkins | Texas | 48223 | 6587 | 154 |
2082565 | 2082565 | 2022-01-04 | Fannin | Texas | 48147 | 5316 | 154 |
2079313 | 2079313 | 2022-01-03 | Fannin | Texas | 48147 | 5297 | 154 |
2076062 | 2076062 | 2022-01-02 | Fannin | Texas | 48147 | 5233 | 154 |
2072811 | 2072811 | 2022-01-01 | Fannin | Texas | 48147 | 5233 | 154 |
2069560 | 2069560 | 2021-12-31 | Fannin | Texas | 48147 | 5233 | 154 |
2066309 | 2066309 | 2021-12-30 | Fannin | Texas | 48147 | 5233 | 154 |
2063059 | 2063059 | 2021-12-29 | Fannin | Texas | 48147 | 5223 | 154 |
2059809 | 2059809 | 2021-12-28 | Fannin | Texas | 48147 | 5213 | 154 |
2056560 | 2056560 | 2021-12-27 | Fannin | Texas | 48147 | 5198 | 154 |
2053311 | 2053311 | 2021-12-26 | Fannin | Texas | 48147 | 5179 | 154 |
2050061 | 2050061 | 2021-12-25 | Fannin | Texas | 48147 | 5179 | 154 |
2046811 | 2046811 | 2021-12-24 | Fannin | Texas | 48147 | 5179 | 154 |
2043561 | 2043561 | 2021-12-23 | Fannin | Texas | 48147 | 5179 | 154 |
2040312 | 2040312 | 2021-12-22 | Fannin | Texas | 48147 | 5177 | 154 |
2037062 | 2037062 | 2021-12-21 | Fannin | Texas | 48147 | 5171 | 154 |
2033812 | 2033812 | 2021-12-20 | Fannin | Texas | 48147 | 5163 | 154 |
2030562 | 2030562 | 2021-12-19 | Fannin | Texas | 48147 | 5161 | 154 |
2027311 | 2027311 | 2021-12-18 | Fannin | Texas | 48147 | 5160 | 154 |
2024060 | 2024060 | 2021-12-17 | Fannin | Texas | 48147 | 5157 | 154 |
2020809 | 2020809 | 2021-12-16 | Fannin | Texas | 48147 | 5152 | 154 |
2017558 | 2017558 | 2021-12-15 | Fannin | Texas | 48147 | 5141 | 154 |
2014308 | 2014308 | 2021-12-14 | Fannin | Texas | 48147 | 5129 | 154 |
2011057 | 2011057 | 2021-12-13 | Fannin | Texas | 48147 | 5126 | 154 |
2007806 | 2007806 | 2021-12-12 | Fannin | Texas | 48147 | 5124 | 154 |
2004555 | 2004555 | 2021-12-11 | Fannin | Texas | 48147 | 5124 | 154 |
2001304 | 2001304 | 2021-12-10 | Fannin | Texas | 48147 | 5116 | 154 |
1968756 | 1968756 | 2021-11-30 | Caldwell | Texas | 48055 | 8550 | 154 |
1968958 | 1968958 | 2021-11-30 | Upshur | Texas | 48459 | 5895 | 154 |
1965505 | 1965505 | 2021-11-29 | Caldwell | Texas | 48055 | 8549 | 154 |
1965707 | 1965707 | 2021-11-29 | Upshur | Texas | 48459 | 5888 | 154 |
1962253 | 1962253 | 2021-11-28 | Caldwell | Texas | 48055 | 8526 | 154 |
1962455 | 1962455 | 2021-11-28 | Upshur | Texas | 48459 | 5881 | 154 |
1959002 | 1959002 | 2021-11-27 | Caldwell | Texas | 48055 | 8526 | 154 |
1959204 | 1959204 | 2021-11-27 | Upshur | Texas | 48459 | 5881 | 154 |
1955751 | 1955751 | 2021-11-26 | Caldwell | Texas | 48055 | 8526 | 154 |
1955953 | 1955953 | 2021-11-26 | Upshur | Texas | 48459 | 5881 | 154 |
1952500 | 1952500 | 2021-11-25 | Caldwell | Texas | 48055 | 8526 | 154 |
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);