ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where deaths = 250 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424147 | 2424147 | 2022-04-19 | Hardin | Texas | 48199 | 12033 | 250 |
2420891 | 2420891 | 2022-04-18 | Hardin | Texas | 48199 | 12032 | 250 |
2417635 | 2417635 | 2022-04-17 | Hardin | Texas | 48199 | 12026 | 250 |
2414379 | 2414379 | 2022-04-16 | Hardin | Texas | 48199 | 12026 | 250 |
2411123 | 2411123 | 2022-04-15 | Hardin | Texas | 48199 | 12026 | 250 |
2407867 | 2407867 | 2022-04-14 | Hardin | Texas | 48199 | 12026 | 250 |
2404611 | 2404611 | 2022-04-13 | Hardin | Texas | 48199 | 12024 | 250 |
2401356 | 2401356 | 2022-04-12 | Hardin | Texas | 48199 | 12024 | 250 |
2398101 | 2398101 | 2022-04-11 | Hardin | Texas | 48199 | 12024 | 250 |
2394846 | 2394846 | 2022-04-10 | Hardin | Texas | 48199 | 12024 | 250 |
2391590 | 2391590 | 2022-04-09 | Hardin | Texas | 48199 | 12024 | 250 |
2388334 | 2388334 | 2022-04-08 | Hardin | Texas | 48199 | 12023 | 250 |
2385079 | 2385079 | 2022-04-07 | Hardin | Texas | 48199 | 12022 | 250 |
2381824 | 2381824 | 2022-04-06 | Hardin | Texas | 48199 | 12022 | 250 |
2378569 | 2378569 | 2022-04-05 | Hardin | Texas | 48199 | 12021 | 250 |
2375315 | 2375315 | 2022-04-04 | Hardin | Texas | 48199 | 12021 | 250 |
2372063 | 2372063 | 2022-04-03 | Hardin | Texas | 48199 | 12021 | 250 |
2368810 | 2368810 | 2022-04-02 | Hardin | Texas | 48199 | 12021 | 250 |
2365557 | 2365557 | 2022-04-01 | Hardin | Texas | 48199 | 12021 | 250 |
2336203 | 2336203 | 2022-03-23 | Brown | Texas | 48049 | 11390 | 250 |
2332949 | 2332949 | 2022-03-22 | Brown | Texas | 48049 | 11390 | 250 |
2329696 | 2329696 | 2022-03-21 | Brown | Texas | 48049 | 11390 | 250 |
2326444 | 2326444 | 2022-03-20 | Brown | Texas | 48049 | 11390 | 250 |
2323191 | 2323191 | 2022-03-19 | Brown | Texas | 48049 | 11390 | 250 |
2319937 | 2319937 | 2022-03-18 | Brown | Texas | 48049 | 11390 | 250 |
2306936 | 2306936 | 2022-03-14 | Cherokee | Texas | 48073 | 7930 | 250 |
2303685 | 2303685 | 2022-03-13 | Cherokee | Texas | 48073 | 7930 | 250 |
2300433 | 2300433 | 2022-03-12 | Cherokee | Texas | 48073 | 7927 | 250 |
2290780 | 2290780 | 2022-03-09 | Lamar | Texas | 48277 | 12437 | 250 |
2287528 | 2287528 | 2022-03-08 | Lamar | Texas | 48277 | 12437 | 250 |
2232285 | 2232285 | 2022-02-19 | Nacogdoches | Texas | 48347 | 11845 | 250 |
2232360 | 2232360 | 2022-02-19 | Wise | Texas | 48497 | 16695 | 250 |
2229034 | 2229034 | 2022-02-18 | Nacogdoches | Texas | 48347 | 11832 | 250 |
2229109 | 2229109 | 2022-02-18 | Wise | Texas | 48497 | 16676 | 250 |
2225783 | 2225783 | 2022-02-17 | Nacogdoches | Texas | 48347 | 11794 | 250 |
2222532 | 2222532 | 2022-02-16 | Nacogdoches | Texas | 48347 | 11758 | 250 |
2219218 | 2219218 | 2022-02-15 | Hood | Texas | 48221 | 13142 | 250 |
2219281 | 2219281 | 2022-02-15 | Nacogdoches | Texas | 48347 | 11716 | 250 |
2215967 | 2215967 | 2022-02-14 | Hood | Texas | 48221 | 13125 | 250 |
2216030 | 2216030 | 2022-02-14 | Nacogdoches | Texas | 48347 | 11690 | 250 |
2212779 | 2212779 | 2022-02-13 | Nacogdoches | Texas | 48347 | 11683 | 250 |
2209526 | 2209526 | 2022-02-12 | Nacogdoches | Texas | 48347 | 11671 | 250 |
2180307 | 2180307 | 2022-02-03 | Van Zandt | Texas | 48467 | 9932 | 250 |
2138025 | 2138025 | 2022-01-21 | Wood | Texas | 48499 | 7089 | 250 |
2134771 | 2134771 | 2022-01-20 | Wood | Texas | 48499 | 7007 | 250 |
1855213 | 1855213 | 2021-10-26 | Val Verde | Texas | 48465 | 10558 | 250 |
1851964 | 1851964 | 2021-10-25 | Val Verde | Texas | 48465 | 10558 | 250 |
1848714 | 1848714 | 2021-10-24 | Val Verde | Texas | 48465 | 10558 | 250 |
1845464 | 1845464 | 2021-10-23 | Val Verde | Texas | 48465 | 10558 | 250 |
1842214 | 1842214 | 2021-10-22 | Val Verde | Texas | 48465 | 10558 | 250 |
1764118 | 1764118 | 2021-09-28 | Hunt | Texas | 48231 | 10224 | 250 |
1708882 | 1708882 | 2021-09-11 | Henderson | Texas | 48213 | 8517 | 250 |
1695800 | 1695800 | 2021-09-07 | Bowie | Texas | 48037 | 10723 | 250 |
1647290 | 1647290 | 2021-08-23 | Victoria | Texas | 48469 | 10976 | 250 |
1319145 | 1319145 | 2021-05-14 | Brazos | Texas | 48041 | 26729 | 250 |
1315897 | 1315897 | 2021-05-13 | Brazos | Texas | 48041 | 26706 | 250 |
1312651 | 1312651 | 2021-05-12 | Brazos | Texas | 48041 | 26701 | 250 |
1309404 | 1309404 | 2021-05-11 | Brazos | Texas | 48041 | 26658 | 250 |
1095239 | 1095239 | 2021-03-06 | Midland | Texas | 48329 | 16624 | 250 |
1062621 | 1062621 | 2021-02-24 | Angelina | Texas | 48005 | 7797 | 250 |
1062844 | 1062844 | 2021-02-24 | Tom Green | Texas | 48451 | 16296 | 250 |
1017393 | 1017393 | 2021-02-10 | Starr | Texas | 48427 | 8818 | 250 |
1014148 | 1014148 | 2021-02-09 | Starr | Texas | 48427 | 8762 | 250 |
1007514 | 1007514 | 2021-02-07 | Ellis | Texas | 48139 | 19505 | 250 |
968584 | 968584 | 2021-01-26 | Gregg | Texas | 48183 | 9409 | 250 |
929792 | 929792 | 2021-01-14 | Wichita | Texas | 48485 | 13068 | 250 |
910098 | 910098 | 2021-01-08 | Brazoria | Texas | 48039 | 23228 | 250 |
906853 | 906853 | 2021-01-07 | Brazoria | Texas | 48039 | 22947 | 250 |
816020 | 816020 | 2020-12-10 | Denton | Texas | 48121 | 28577 | 250 |
504924 | 504924 | 2020-09-05 | Webb | Texas | 48479 | 12025 | 250 |
501690 | 501690 | 2020-09-04 | Webb | Texas | 48479 | 11828 | 250 |
208620 | 208620 | 2020-06-04 | Dallas | Texas | 48113 | 11243 | 250 |
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);