ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where deaths = 149 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2284149 | 2284149 | 2022-03-07 | Bee | Texas | 48025 | 8168 | 149 |
2280897 | 2280897 | 2022-03-06 | Bee | Texas | 48025 | 8165 | 149 |
2277644 | 2277644 | 2022-03-05 | Bee | Texas | 48025 | 8164 | 149 |
2274391 | 2274391 | 2022-03-04 | Bee | Texas | 48025 | 8159 | 149 |
2271138 | 2271138 | 2022-03-03 | Bee | Texas | 48025 | 8153 | 149 |
2267886 | 2267886 | 2022-03-02 | Bee | Texas | 48025 | 8148 | 149 |
2264633 | 2264633 | 2022-03-01 | Bee | Texas | 48025 | 8126 | 149 |
2261383 | 2261383 | 2022-02-28 | Bee | Texas | 48025 | 8109 | 149 |
2258132 | 2258132 | 2022-02-27 | Bee | Texas | 48025 | 8104 | 149 |
2254881 | 2254881 | 2022-02-26 | Bee | Texas | 48025 | 8103 | 149 |
2251630 | 2251630 | 2022-02-25 | Bee | Texas | 48025 | 8097 | 149 |
2248379 | 2248379 | 2022-02-24 | Bee | Texas | 48025 | 8091 | 149 |
2245128 | 2245128 | 2022-02-23 | Bee | Texas | 48025 | 8081 | 149 |
2241877 | 2241877 | 2022-02-22 | Bee | Texas | 48025 | 8074 | 149 |
2238626 | 2238626 | 2022-02-21 | Bee | Texas | 48025 | 8068 | 149 |
2235375 | 2235375 | 2022-02-20 | Bee | Texas | 48025 | 8066 | 149 |
2232124 | 2232124 | 2022-02-19 | Bee | Texas | 48025 | 8064 | 149 |
2228873 | 2228873 | 2022-02-18 | Bee | Texas | 48025 | 8050 | 149 |
2225622 | 2225622 | 2022-02-17 | Bee | Texas | 48025 | 8041 | 149 |
2222371 | 2222371 | 2022-02-16 | Bee | Texas | 48025 | 8028 | 149 |
2202873 | 2202873 | 2022-02-10 | Burnet | Texas | 48053 | 10432 | 149 |
2199619 | 2199619 | 2022-02-09 | Burnet | Texas | 48053 | 10403 | 149 |
2160662 | 2160662 | 2022-01-28 | Hockley | Texas | 48219 | 7266 | 149 |
2157406 | 2157406 | 2022-01-27 | Hockley | Texas | 48219 | 7226 | 149 |
2154153 | 2154153 | 2022-01-26 | Hockley | Texas | 48219 | 7200 | 149 |
2147787 | 2147787 | 2022-01-24 | Wilson | Texas | 48493 | 9742 | 149 |
2144533 | 2144533 | 2022-01-23 | Wilson | Texas | 48493 | 9637 | 149 |
2141278 | 2141278 | 2022-01-22 | Wilson | Texas | 48493 | 9543 | 149 |
2053351 | 2053351 | 2021-12-26 | Howard | Texas | 48227 | 5941 | 149 |
2050101 | 2050101 | 2021-12-25 | Howard | Texas | 48227 | 5941 | 149 |
2046851 | 2046851 | 2021-12-24 | Howard | Texas | 48227 | 5941 | 149 |
2043601 | 2043601 | 2021-12-23 | Howard | Texas | 48227 | 5941 | 149 |
2040352 | 2040352 | 2021-12-22 | Howard | Texas | 48227 | 5937 | 149 |
2037102 | 2037102 | 2021-12-21 | Howard | Texas | 48227 | 5927 | 149 |
2033852 | 2033852 | 2021-12-20 | Howard | Texas | 48227 | 5925 | 149 |
2030602 | 2030602 | 2021-12-19 | Howard | Texas | 48227 | 5924 | 149 |
2027351 | 2027351 | 2021-12-18 | Howard | Texas | 48227 | 5924 | 149 |
2020847 | 2020847 | 2021-12-16 | Hopkins | Texas | 48223 | 5594 | 149 |
2017596 | 2017596 | 2021-12-15 | Hopkins | Texas | 48223 | 5580 | 149 |
2014346 | 2014346 | 2021-12-14 | Hopkins | Texas | 48223 | 5565 | 149 |
1920199 | 1920199 | 2021-11-15 | Upshur | Texas | 48459 | 5873 | 149 |
1916949 | 1916949 | 2021-11-14 | Upshur | Texas | 48459 | 5873 | 149 |
1913699 | 1913699 | 2021-11-13 | Upshur | Texas | 48459 | 5873 | 149 |
1903755 | 1903755 | 2021-11-10 | Cass | Texas | 48067 | 4504 | 149 |
1900505 | 1900505 | 2021-11-09 | Cass | Texas | 48067 | 4504 | 149 |
1897255 | 1897255 | 2021-11-08 | Cass | Texas | 48067 | 4496 | 149 |
1894005 | 1894005 | 2021-11-07 | Cass | Texas | 48067 | 4496 | 149 |
1890755 | 1890755 | 2021-11-06 | Cass | Texas | 48067 | 4496 | 149 |
1887505 | 1887505 | 2021-11-05 | Cass | Texas | 48067 | 4492 | 149 |
1884255 | 1884255 | 2021-11-04 | Cass | Texas | 48067 | 4490 | 149 |
1864801 | 1864801 | 2021-10-29 | Fannin | Texas | 48147 | 4995 | 149 |
1861552 | 1861552 | 2021-10-28 | Fannin | Texas | 48147 | 4989 | 149 |
1858303 | 1858303 | 2021-10-27 | Fannin | Texas | 48147 | 4983 | 149 |
1855054 | 1855054 | 2021-10-26 | Fannin | Texas | 48147 | 4983 | 149 |
1851805 | 1851805 | 2021-10-25 | Fannin | Texas | 48147 | 4965 | 149 |
1851852 | 1851852 | 2021-10-25 | Jasper | Texas | 48241 | 4009 | 149 |
1848555 | 1848555 | 2021-10-24 | Fannin | Texas | 48147 | 4965 | 149 |
1848602 | 1848602 | 2021-10-24 | Jasper | Texas | 48241 | 4009 | 149 |
1845305 | 1845305 | 2021-10-23 | Fannin | Texas | 48147 | 4965 | 149 |
1845352 | 1845352 | 2021-10-23 | Jasper | Texas | 48241 | 4009 | 149 |
1842102 | 1842102 | 2021-10-22 | Jasper | Texas | 48241 | 4009 | 149 |
1835511 | 1835511 | 2021-10-20 | Caldwell | Texas | 48055 | 8367 | 149 |
1812850 | 1812850 | 2021-10-13 | Hill | Texas | 48217 | 5731 | 149 |
1809601 | 1809601 | 2021-10-12 | Hill | Texas | 48217 | 5722 | 149 |
1790046 | 1790046 | 2021-10-06 | Coryell | Texas | 48099 | 10375 | 149 |
1790154 | 1790154 | 2021-10-06 | Matagorda | Texas | 48321 | 5954 | 149 |
1773761 | 1773761 | 2021-10-01 | Bastrop | Texas | 48021 | 13891 | 149 |
1770511 | 1770511 | 2021-09-30 | Bastrop | Texas | 48021 | 13870 | 149 |
1760855 | 1760855 | 2021-09-27 | Harrison | Texas | 48203 | 8682 | 149 |
1760954 | 1760954 | 2021-09-27 | Rusk | Texas | 48401 | 7587 | 149 |
1757607 | 1757607 | 2021-09-26 | Harrison | Texas | 48203 | 8682 | 149 |
1757706 | 1757706 | 2021-09-26 | Rusk | Texas | 48401 | 7587 | 149 |
1754359 | 1754359 | 2021-09-25 | Harrison | Texas | 48203 | 8682 | 149 |
1751111 | 1751111 | 2021-09-24 | Harrison | Texas | 48203 | 8648 | 149 |
1747862 | 1747862 | 2021-09-23 | Harrison | Texas | 48203 | 8627 | 149 |
1744612 | 1744612 | 2021-09-22 | Harrison | Texas | 48203 | 8571 | 149 |
1731753 | 1731753 | 2021-09-18 | Wharton | Texas | 48481 | 5685 | 149 |
1699278 | 1699278 | 2021-09-08 | Wise | Texas | 48497 | 9729 | 149 |
1611360 | 1611360 | 2021-08-12 | Cherokee | Texas | 48073 | 4737 | 149 |
1608112 | 1608112 | 2021-08-11 | Cherokee | Texas | 48073 | 4680 | 149 |
1604863 | 1604863 | 2021-08-10 | Cherokee | Texas | 48073 | 4637 | 149 |
1601614 | 1601614 | 2021-08-09 | Cherokee | Texas | 48073 | 4586 | 149 |
1598366 | 1598366 | 2021-08-08 | Cherokee | Texas | 48073 | 4586 | 149 |
1595117 | 1595117 | 2021-08-07 | Cherokee | Texas | 48073 | 4586 | 149 |
1591868 | 1591868 | 2021-08-06 | Cherokee | Texas | 48073 | 4586 | 149 |
1588619 | 1588619 | 2021-08-05 | Cherokee | Texas | 48073 | 4577 | 149 |
1585369 | 1585369 | 2021-08-04 | Cherokee | Texas | 48073 | 4537 | 149 |
1582119 | 1582119 | 2021-08-03 | Cherokee | Texas | 48073 | 4537 | 149 |
1578870 | 1578870 | 2021-08-02 | Cherokee | Texas | 48073 | 4508 | 149 |
1575622 | 1575622 | 2021-08-01 | Cherokee | Texas | 48073 | 4508 | 149 |
1572374 | 1572374 | 2021-07-31 | Cherokee | Texas | 48073 | 4508 | 149 |
1569126 | 1569126 | 2021-07-30 | Cherokee | Texas | 48073 | 4508 | 149 |
1380986 | 1380986 | 2021-06-02 | Orange | Texas | 48361 | 8714 | 149 |
1377741 | 1377741 | 2021-06-01 | Orange | Texas | 48361 | 8710 | 149 |
1374495 | 1374495 | 2021-05-31 | Orange | Texas | 48361 | 8710 | 149 |
1371250 | 1371250 | 2021-05-30 | Orange | Texas | 48361 | 8710 | 149 |
1368004 | 1368004 | 2021-05-29 | Orange | Texas | 48361 | 8710 | 149 |
1364758 | 1364758 | 2021-05-28 | Orange | Texas | 48361 | 8710 | 149 |
1361512 | 1361512 | 2021-05-27 | Orange | Texas | 48361 | 8697 | 149 |
1358266 | 1358266 | 2021-05-26 | Orange | Texas | 48361 | 8671 | 149 |
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);