ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where deaths = 217 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2307074 | 2307074 | 2022-03-14 | Navarro | Texas | 48349 | 12411 | 217 |
2303823 | 2303823 | 2022-03-13 | Navarro | Texas | 48349 | 12411 | 217 |
2300571 | 2300571 | 2022-03-12 | Navarro | Texas | 48349 | 12411 | 217 |
2297319 | 2297319 | 2022-03-11 | Navarro | Texas | 48349 | 12409 | 217 |
2294067 | 2294067 | 2022-03-10 | Navarro | Texas | 48349 | 12408 | 217 |
2290815 | 2290815 | 2022-03-09 | Navarro | Texas | 48349 | 12406 | 217 |
2287563 | 2287563 | 2022-03-08 | Navarro | Texas | 48349 | 12392 | 217 |
2284311 | 2284311 | 2022-03-07 | Navarro | Texas | 48349 | 12369 | 217 |
2281059 | 2281059 | 2022-03-06 | Navarro | Texas | 48349 | 12368 | 217 |
2277806 | 2277806 | 2022-03-05 | Navarro | Texas | 48349 | 12368 | 217 |
2274553 | 2274553 | 2022-03-04 | Navarro | Texas | 48349 | 12342 | 217 |
2271300 | 2271300 | 2022-03-03 | Navarro | Texas | 48349 | 12305 | 217 |
2268048 | 2268048 | 2022-03-02 | Navarro | Texas | 48349 | 12270 | 217 |
2251719 | 2251719 | 2022-02-25 | Harrison | Texas | 48203 | 12889 | 217 |
2232312 | 2232312 | 2022-02-19 | Rusk | Texas | 48401 | 10441 | 217 |
2173575 | 2173575 | 2022-02-01 | Atascosa | Texas | 48013 | 12537 | 217 |
2150792 | 2150792 | 2022-01-25 | Anderson | Texas | 48001 | 9134 | 217 |
2147540 | 2147540 | 2022-01-24 | Anderson | Texas | 48001 | 9100 | 217 |
2144286 | 2144286 | 2022-01-23 | Anderson | Texas | 48001 | 9073 | 217 |
2141031 | 2141031 | 2022-01-22 | Anderson | Texas | 48001 | 9038 | 217 |
2137775 | 2137775 | 2022-01-21 | Anderson | Texas | 48001 | 8987 | 217 |
2137869 | 2137869 | 2022-01-21 | Hale | Texas | 48189 | 5931 | 217 |
2089105 | 2089105 | 2022-01-06 | Hood | Texas | 48221 | 10541 | 217 |
2089243 | 2089243 | 2022-01-06 | Wise | Texas | 48497 | 12543 | 217 |
2085854 | 2085854 | 2022-01-05 | Hood | Texas | 48221 | 10503 | 217 |
2085992 | 2085992 | 2022-01-05 | Wise | Texas | 48497 | 12471 | 217 |
2082602 | 2082602 | 2022-01-04 | Hood | Texas | 48221 | 10472 | 217 |
2082740 | 2082740 | 2022-01-04 | Wise | Texas | 48497 | 12399 | 217 |
2079350 | 2079350 | 2022-01-03 | Hood | Texas | 48221 | 10423 | 217 |
1988414 | 1988414 | 2021-12-06 | Polk | Texas | 48373 | 5975 | 217 |
1985164 | 1985164 | 2021-12-05 | Polk | Texas | 48373 | 5975 | 217 |
1981914 | 1981914 | 2021-12-04 | Polk | Texas | 48373 | 5974 | 217 |
1978664 | 1978664 | 2021-12-03 | Polk | Texas | 48373 | 5973 | 217 |
1975414 | 1975414 | 2021-12-02 | Polk | Texas | 48373 | 5969 | 217 |
1946110 | 1946110 | 2021-11-23 | Lamar | Texas | 48277 | 8952 | 217 |
1942859 | 1942859 | 2021-11-22 | Lamar | Texas | 48277 | 8952 | 217 |
1851768 | 1851768 | 2021-10-25 | Cherokee | Texas | 48073 | 6784 | 217 |
1848518 | 1848518 | 2021-10-24 | Cherokee | Texas | 48073 | 6784 | 217 |
1845268 | 1845268 | 2021-10-23 | Cherokee | Texas | 48073 | 6784 | 217 |
1812915 | 1812915 | 2021-10-13 | Nacogdoches | Texas | 48347 | 7657 | 217 |
1669897 | 1669897 | 2021-08-30 | Henderson | Texas | 48213 | 7511 | 217 |
1666650 | 1666650 | 2021-08-29 | Henderson | Texas | 48213 | 7511 | 217 |
1663402 | 1663402 | 2021-08-28 | Henderson | Texas | 48213 | 7511 | 217 |
1660154 | 1660154 | 2021-08-27 | Henderson | Texas | 48213 | 7511 | 217 |
1247929 | 1247929 | 2021-04-22 | Val Verde | Texas | 48465 | 7823 | 217 |
1244682 | 1244682 | 2021-04-21 | Val Verde | Texas | 48465 | 7823 | 217 |
1241435 | 1241435 | 2021-04-20 | Val Verde | Texas | 48465 | 7823 | 217 |
1238188 | 1238188 | 2021-04-19 | Val Verde | Texas | 48465 | 7823 | 217 |
1234941 | 1234941 | 2021-04-18 | Val Verde | Texas | 48465 | 7823 | 217 |
1231693 | 1231693 | 2021-04-17 | Val Verde | Texas | 48465 | 7823 | 217 |
1228445 | 1228445 | 2021-04-16 | Val Verde | Texas | 48465 | 7823 | 217 |
1225197 | 1225197 | 2021-04-15 | Val Verde | Texas | 48465 | 7823 | 217 |
1221950 | 1221950 | 2021-04-14 | Val Verde | Texas | 48465 | 7823 | 217 |
1218702 | 1218702 | 2021-04-13 | Val Verde | Texas | 48465 | 7823 | 217 |
1215454 | 1215454 | 2021-04-12 | Val Verde | Texas | 48465 | 7797 | 217 |
1212207 | 1212207 | 2021-04-11 | Val Verde | Texas | 48465 | 7797 | 217 |
984723 | 984723 | 2021-01-31 | Angelina | Texas | 48005 | 7121 | 217 |
981476 | 981476 | 2021-01-30 | Angelina | Texas | 48005 | 7121 | 217 |
968657 | 968657 | 2021-01-26 | Midland | Texas | 48329 | 15231 | 217 |
958829 | 958829 | 2021-01-23 | Ellis | Texas | 48139 | 17597 | 217 |
955726 | 955726 | 2021-01-22 | Starr | Texas | 48427 | 7711 | 217 |
952481 | 952481 | 2021-01-21 | Starr | Texas | 48427 | 7617 | 217 |
942621 | 942621 | 2021-01-18 | Gregg | Texas | 48183 | 8451 | 217 |
939376 | 939376 | 2021-01-17 | Gregg | Texas | 48183 | 8451 | 217 |
932953 | 932953 | 2021-01-15 | Maverick | Texas | 48323 | 7996 | 217 |
884197 | 884197 | 2020-12-31 | Galveston | Texas | 48167 | 21429 | 217 |
809638 | 809638 | 2020-12-08 | Montgomery | Texas | 48339 | 19784 | 217 |
404793 | 404793 | 2020-08-05 | Nueces | Texas | 48355 | 13321 | 217 |
168877 | 168877 | 2020-05-22 | Harris | Texas | 48201 | 10526 | 217 |
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);