ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 496 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502371 | 2502371 | 2022-05-13 | Midland | Texas | 48329 | 40910 | 496 |
2499113 | 2499113 | 2022-05-12 | Midland | Texas | 48329 | 40896 | 496 |
2495855 | 2495855 | 2022-05-11 | Midland | Texas | 48329 | 40888 | 496 |
2492597 | 2492597 | 2022-05-10 | Midland | Texas | 48329 | 40887 | 496 |
2489339 | 2489339 | 2022-05-09 | Midland | Texas | 48329 | 40876 | 496 |
2486082 | 2486082 | 2022-05-08 | Midland | Texas | 48329 | 40875 | 496 |
2482824 | 2482824 | 2022-05-07 | Midland | Texas | 48329 | 40875 | 496 |
2479566 | 2479566 | 2022-05-06 | Midland | Texas | 48329 | 40871 | 496 |
2476308 | 2476308 | 2022-05-05 | Midland | Texas | 48329 | 40865 | 496 |
2381889 | 2381889 | 2022-04-06 | Midland | Texas | 48329 | 40134 | 496 |
2378634 | 2378634 | 2022-04-05 | Midland | Texas | 48329 | 40028 | 496 |
2375380 | 2375380 | 2022-04-04 | Midland | Texas | 48329 | 39920 | 496 |
2372128 | 2372128 | 2022-04-03 | Midland | Texas | 48329 | 39917 | 496 |
2368875 | 2368875 | 2022-04-02 | Midland | Texas | 48329 | 39916 | 496 |
2365622 | 2365622 | 2022-04-01 | Midland | Texas | 48329 | 39826 | 496 |
2349296 | 2349296 | 2022-03-27 | Hays | Texas | 48209 | 59901 | 496 |
2346043 | 2346043 | 2022-03-26 | Hays | Texas | 48209 | 59901 | 496 |
2342790 | 2342790 | 2022-03-25 | Hays | Texas | 48209 | 59901 | 496 |
2339537 | 2339537 | 2022-03-24 | Hays | Texas | 48209 | 59878 | 496 |
2336283 | 2336283 | 2022-03-23 | Hays | Texas | 48209 | 59861 | 496 |
2333029 | 2333029 | 2022-03-22 | Hays | Texas | 48209 | 59844 | 496 |
2329776 | 2329776 | 2022-03-21 | Hays | Texas | 48209 | 59830 | 496 |
2215985 | 2215985 | 2022-02-14 | Kaufman | Texas | 48257 | 34471 | 496 |
2212734 | 2212734 | 2022-02-13 | Kaufman | Texas | 48257 | 34449 | 496 |
2160598 | 2160598 | 2022-01-28 | Comal | Texas | 48091 | 29321 | 496 |
1890812 | 1890812 | 2021-11-06 | Grayson | Texas | 48181 | 16330 | 496 |
1887562 | 1887562 | 2021-11-05 | Grayson | Texas | 48181 | 16317 | 496 |
1790122 | 1790122 | 2021-10-06 | Johnson | Texas | 48251 | 26824 | 496 |
1786816 | 1786816 | 2021-10-05 | Ector | Texas | 48135 | 25149 | 496 |
1786969 | 1786969 | 2021-10-05 | Taylor | Texas | 48441 | 21915 | 496 |
1650388 | 1650388 | 2021-08-24 | Galveston | Texas | 48167 | 52035 | 496 |
1637320 | 1637320 | 2021-08-20 | Bell | Texas | 48027 | 30203 | 496 |
1595292 | 1595292 | 2021-08-07 | Smith | Texas | 48423 | 23060 | 496 |
1592043 | 1592043 | 2021-08-06 | Smith | Texas | 48423 | 23060 | 496 |
1588794 | 1588794 | 2021-08-05 | Smith | Texas | 48423 | 22634 | 496 |
1299664 | 1299664 | 2021-05-08 | Brazoria | Texas | 48039 | 37502 | 496 |
1137449 | 1137449 | 2021-03-19 | Montgomery | Texas | 48339 | 48064 | 496 |
877863 | 877863 | 2020-12-29 | Webb | Texas | 48479 | 26143 | 496 |
874618 | 874618 | 2020-12-28 | Webb | Texas | 48479 | 26143 | 496 |
809695 | 809695 | 2020-12-08 | Travis | Texas | 48453 | 40836 | 496 |
793421 | 793421 | 2020-12-03 | Nueces | Texas | 48355 | 24722 | 496 |
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);