ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 495 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473051 | 2473051 | 2022-05-04 | Midland | Texas | 48329 | 40859 | 495 |
2469795 | 2469795 | 2022-05-03 | Midland | Texas | 48329 | 40846 | 495 |
2466539 | 2466539 | 2022-05-02 | Midland | Texas | 48329 | 40843 | 495 |
2463284 | 2463284 | 2022-05-01 | Midland | Texas | 48329 | 40842 | 495 |
2460028 | 2460028 | 2022-04-30 | Midland | Texas | 48329 | 40841 | 495 |
2456772 | 2456772 | 2022-04-29 | Midland | Texas | 48329 | 40839 | 495 |
2453516 | 2453516 | 2022-04-28 | Midland | Texas | 48329 | 40836 | 495 |
2450260 | 2450260 | 2022-04-27 | Midland | Texas | 48329 | 40819 | 495 |
2447003 | 2447003 | 2022-04-26 | Midland | Texas | 48329 | 40799 | 495 |
2443748 | 2443748 | 2022-04-25 | Midland | Texas | 48329 | 40783 | 495 |
2440492 | 2440492 | 2022-04-24 | Midland | Texas | 48329 | 40783 | 495 |
2437236 | 2437236 | 2022-04-23 | Midland | Texas | 48329 | 40781 | 495 |
2433980 | 2433980 | 2022-04-22 | Midland | Texas | 48329 | 40747 | 495 |
2430724 | 2430724 | 2022-04-21 | Midland | Texas | 48329 | 40724 | 495 |
2427468 | 2427468 | 2022-04-20 | Midland | Texas | 48329 | 40699 | 495 |
2424212 | 2424212 | 2022-04-19 | Midland | Texas | 48329 | 40668 | 495 |
2420956 | 2420956 | 2022-04-18 | Midland | Texas | 48329 | 40627 | 495 |
2417700 | 2417700 | 2022-04-17 | Midland | Texas | 48329 | 40552 | 495 |
2414444 | 2414444 | 2022-04-16 | Midland | Texas | 48329 | 40552 | 495 |
2411188 | 2411188 | 2022-04-15 | Midland | Texas | 48329 | 40552 | 495 |
2407932 | 2407932 | 2022-04-14 | Midland | Texas | 48329 | 40552 | 495 |
2404676 | 2404676 | 2022-04-13 | Midland | Texas | 48329 | 40503 | 495 |
2401421 | 2401421 | 2022-04-12 | Midland | Texas | 48329 | 40430 | 495 |
2398166 | 2398166 | 2022-04-11 | Midland | Texas | 48329 | 40366 | 495 |
2394911 | 2394911 | 2022-04-10 | Midland | Texas | 48329 | 40366 | 495 |
2391655 | 2391655 | 2022-04-09 | Midland | Texas | 48329 | 40366 | 495 |
2388399 | 2388399 | 2022-04-08 | Midland | Texas | 48329 | 40321 | 495 |
2385144 | 2385144 | 2022-04-07 | Midland | Texas | 48329 | 40257 | 495 |
2375406 | 2375406 | 2022-04-04 | Randall | Texas | 48381 | 38126 | 495 |
2362369 | 2362369 | 2022-03-31 | Midland | Texas | 48329 | 39748 | 495 |
2359115 | 2359115 | 2022-03-30 | Midland | Texas | 48329 | 39653 | 495 |
2355861 | 2355861 | 2022-03-29 | Midland | Texas | 48329 | 39566 | 495 |
2352608 | 2352608 | 2022-03-28 | Midland | Texas | 48329 | 39526 | 495 |
2349356 | 2349356 | 2022-03-27 | Midland | Texas | 48329 | 39526 | 495 |
2346103 | 2346103 | 2022-03-26 | Midland | Texas | 48329 | 39526 | 495 |
2342850 | 2342850 | 2022-03-25 | Midland | Texas | 48329 | 39408 | 495 |
2339597 | 2339597 | 2022-03-24 | Midland | Texas | 48329 | 39274 | 495 |
2336343 | 2336343 | 2022-03-23 | Midland | Texas | 48329 | 39187 | 495 |
2326524 | 2326524 | 2022-03-20 | Hays | Texas | 48209 | 59804 | 495 |
2323271 | 2323271 | 2022-03-19 | Hays | Texas | 48209 | 59804 | 495 |
2320017 | 2320017 | 2022-03-18 | Hays | Texas | 48209 | 59804 | 495 |
2209481 | 2209481 | 2022-02-12 | Kaufman | Texas | 48257 | 34419 | 495 |
2092317 | 2092317 | 2022-01-07 | Ellis | Texas | 48139 | 38092 | 495 |
1884312 | 1884312 | 2021-11-04 | Grayson | Texas | 48181 | 16291 | 495 |
1881063 | 1881063 | 2021-11-03 | Grayson | Texas | 48181 | 16291 | 495 |
1851974 | 1851974 | 2021-10-25 | Wichita | Texas | 48485 | 21843 | 495 |
1848724 | 1848724 | 2021-10-24 | Wichita | Texas | 48485 | 21843 | 495 |
1783720 | 1783720 | 2021-10-04 | Taylor | Texas | 48441 | 21865 | 495 |
1780471 | 1780471 | 2021-10-03 | Taylor | Texas | 48441 | 21722 | 495 |
1647139 | 1647139 | 2021-08-23 | Galveston | Texas | 48167 | 51565 | 495 |
1595241 | 1595241 | 2021-08-07 | McLennan | Texas | 48309 | 29967 | 495 |
1588828 | 1588828 | 2021-08-05 | Williamson | Texas | 48491 | 53100 | 495 |
1585578 | 1585578 | 2021-08-04 | Williamson | Texas | 48491 | 52760 | 495 |
1582328 | 1582328 | 2021-08-03 | Williamson | Texas | 48491 | 52278 | 495 |
1579079 | 1579079 | 2021-08-02 | Williamson | Texas | 48491 | 51860 | 495 |
1575831 | 1575831 | 2021-08-01 | Williamson | Texas | 48491 | 50815 | 495 |
1572583 | 1572583 | 2021-07-31 | Williamson | Texas | 48491 | 50815 | 495 |
1296417 | 1296417 | 2021-05-07 | Brazoria | Texas | 48039 | 37502 | 495 |
838834 | 838834 | 2020-12-17 | Lubbock | Texas | 48303 | 38273 | 495 |
806450 | 806450 | 2020-12-07 | Travis | Texas | 48453 | 40481 | 495 |
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);