ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where deaths = 398 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502300 | 2502300 | 2022-05-13 | Guadalupe | Texas | 48187 | 38361 | 398 |
2499042 | 2499042 | 2022-05-12 | Guadalupe | Texas | 48187 | 38338 | 398 |
2495784 | 2495784 | 2022-05-11 | Guadalupe | Texas | 48187 | 38319 | 398 |
2492526 | 2492526 | 2022-05-10 | Guadalupe | Texas | 48187 | 38304 | 398 |
2489268 | 2489268 | 2022-05-09 | Guadalupe | Texas | 48187 | 38290 | 398 |
2486011 | 2486011 | 2022-05-08 | Guadalupe | Texas | 48187 | 38285 | 398 |
2482753 | 2482753 | 2022-05-07 | Guadalupe | Texas | 48187 | 38277 | 398 |
2479495 | 2479495 | 2022-05-06 | Guadalupe | Texas | 48187 | 38263 | 398 |
2476237 | 2476237 | 2022-05-05 | Guadalupe | Texas | 48187 | 38254 | 398 |
2472980 | 2472980 | 2022-05-04 | Guadalupe | Texas | 48187 | 38252 | 398 |
2469724 | 2469724 | 2022-05-03 | Guadalupe | Texas | 48187 | 38239 | 398 |
2466468 | 2466468 | 2022-05-02 | Guadalupe | Texas | 48187 | 38232 | 398 |
2463213 | 2463213 | 2022-05-01 | Guadalupe | Texas | 48187 | 38226 | 398 |
2459957 | 2459957 | 2022-04-30 | Guadalupe | Texas | 48187 | 38223 | 398 |
2456701 | 2456701 | 2022-04-29 | Guadalupe | Texas | 48187 | 38212 | 398 |
2453445 | 2453445 | 2022-04-28 | Guadalupe | Texas | 48187 | 38189 | 398 |
2450189 | 2450189 | 2022-04-27 | Guadalupe | Texas | 48187 | 38169 | 398 |
2446932 | 2446932 | 2022-04-26 | Guadalupe | Texas | 48187 | 38165 | 398 |
2443677 | 2443677 | 2022-04-25 | Guadalupe | Texas | 48187 | 38162 | 398 |
2440421 | 2440421 | 2022-04-24 | Guadalupe | Texas | 48187 | 38159 | 398 |
2437165 | 2437165 | 2022-04-23 | Guadalupe | Texas | 48187 | 38152 | 398 |
2433909 | 2433909 | 2022-04-22 | Guadalupe | Texas | 48187 | 38147 | 398 |
2430653 | 2430653 | 2022-04-21 | Guadalupe | Texas | 48187 | 38142 | 398 |
2427397 | 2427397 | 2022-04-20 | Guadalupe | Texas | 48187 | 38139 | 398 |
2424141 | 2424141 | 2022-04-19 | Guadalupe | Texas | 48187 | 38121 | 398 |
2420885 | 2420885 | 2022-04-18 | Guadalupe | Texas | 48187 | 38116 | 398 |
2417629 | 2417629 | 2022-04-17 | Guadalupe | Texas | 48187 | 38090 | 398 |
2414373 | 2414373 | 2022-04-16 | Guadalupe | Texas | 48187 | 38090 | 398 |
2411117 | 2411117 | 2022-04-15 | Guadalupe | Texas | 48187 | 38090 | 398 |
2407861 | 2407861 | 2022-04-14 | Guadalupe | Texas | 48187 | 38090 | 398 |
2404605 | 2404605 | 2022-04-13 | Guadalupe | Texas | 48187 | 38086 | 398 |
2401350 | 2401350 | 2022-04-12 | Guadalupe | Texas | 48187 | 38079 | 398 |
2398095 | 2398095 | 2022-04-11 | Guadalupe | Texas | 48187 | 38070 | 398 |
2394840 | 2394840 | 2022-04-10 | Guadalupe | Texas | 48187 | 38070 | 398 |
2391584 | 2391584 | 2022-04-09 | Guadalupe | Texas | 48187 | 38065 | 398 |
2388328 | 2388328 | 2022-04-08 | Guadalupe | Texas | 48187 | 38045 | 398 |
2385073 | 2385073 | 2022-04-07 | Guadalupe | Texas | 48187 | 37999 | 398 |
2381818 | 2381818 | 2022-04-06 | Guadalupe | Texas | 48187 | 37995 | 398 |
2378563 | 2378563 | 2022-04-05 | Guadalupe | Texas | 48187 | 37994 | 398 |
2375309 | 2375309 | 2022-04-04 | Guadalupe | Texas | 48187 | 37988 | 398 |
2372057 | 2372057 | 2022-04-03 | Guadalupe | Texas | 48187 | 37985 | 398 |
2368804 | 2368804 | 2022-04-02 | Guadalupe | Texas | 48187 | 37971 | 398 |
2365551 | 2365551 | 2022-04-01 | Guadalupe | Texas | 48187 | 37968 | 398 |
2362298 | 2362298 | 2022-03-31 | Guadalupe | Texas | 48187 | 37964 | 398 |
2359044 | 2359044 | 2022-03-30 | Guadalupe | Texas | 48187 | 37963 | 398 |
2355790 | 2355790 | 2022-03-29 | Guadalupe | Texas | 48187 | 37946 | 398 |
2310298 | 2310298 | 2022-03-15 | Liberty | Texas | 48291 | 17632 | 398 |
2307045 | 2307045 | 2022-03-14 | Liberty | Texas | 48291 | 17617 | 398 |
2303794 | 2303794 | 2022-03-13 | Liberty | Texas | 48291 | 17617 | 398 |
2300542 | 2300542 | 2022-03-12 | Liberty | Texas | 48291 | 17616 | 398 |
2297290 | 2297290 | 2022-03-11 | Liberty | Texas | 48291 | 17606 | 398 |
2124988 | 2124988 | 2022-01-17 | Tom Green | Texas | 48451 | 34106 | 398 |
2121736 | 2121736 | 2022-01-16 | Tom Green | Texas | 48451 | 34106 | 398 |
2118484 | 2118484 | 2022-01-15 | Tom Green | Texas | 48451 | 34106 | 398 |
2115233 | 2115233 | 2022-01-14 | Tom Green | Texas | 48451 | 34106 | 398 |
1861583 | 1861583 | 2021-10-28 | Hays | Texas | 48209 | 32939 | 398 |
1799902 | 1799902 | 2021-10-09 | Maverick | Texas | 48323 | 12612 | 398 |
1796653 | 1796653 | 2021-10-08 | Maverick | Texas | 48323 | 12612 | 398 |
1793404 | 1793404 | 2021-10-07 | Maverick | Texas | 48323 | 12600 | 398 |
1679625 | 1679625 | 2021-09-02 | Gregg | Texas | 48183 | 14854 | 398 |
1653619 | 1653619 | 2021-08-25 | Ector | Texas | 48135 | 21076 | 398 |
1650372 | 1650372 | 2021-08-24 | Ector | Texas | 48135 | 20800 | 398 |
1647123 | 1647123 | 2021-08-23 | Ector | Texas | 48135 | 20645 | 398 |
1643874 | 1643874 | 2021-08-22 | Ector | Texas | 48135 | 20645 | 398 |
1640682 | 1640682 | 2021-08-21 | Johnson | Texas | 48251 | 22326 | 398 |
1637432 | 1637432 | 2021-08-20 | Johnson | Texas | 48251 | 22250 | 398 |
1634182 | 1634182 | 2021-08-19 | Johnson | Texas | 48251 | 22218 | 398 |
1221801 | 1221801 | 2021-04-14 | Galveston | Texas | 48167 | 38012 | 398 |
1215442 | 1215442 | 2021-04-12 | Taylor | Texas | 48441 | 15556 | 398 |
1212195 | 1212195 | 2021-04-11 | Taylor | Texas | 48441 | 15544 | 398 |
1208946 | 1208946 | 2021-04-10 | Taylor | Texas | 48441 | 15544 | 398 |
1192606 | 1192606 | 2021-04-05 | Jefferson | Texas | 48245 | 18998 | 398 |
1189357 | 1189357 | 2021-04-04 | Jefferson | Texas | 48245 | 18998 | 398 |
1079091 | 1079091 | 2021-03-01 | Williamson | Texas | 48491 | 40927 | 398 |
1075846 | 1075846 | 2021-02-28 | Williamson | Texas | 48491 | 39586 | 398 |
1072600 | 1072600 | 2021-02-27 | Williamson | Texas | 48491 | 39586 | 398 |
1056315 | 1056315 | 2021-02-22 | Potter | Texas | 48375 | 16744 | 398 |
997875 | 997875 | 2021-02-04 | Montgomery | Texas | 48339 | 40954 | 398 |
900421 | 900421 | 2021-01-05 | Fort Bend | Texas | 48157 | 37246 | 398 |
783749 | 783749 | 2020-11-30 | Webb | Texas | 48479 | 19703 | 398 |
780504 | 780504 | 2020-11-29 | Webb | Texas | 48479 | 19703 | 398 |
777258 | 777258 | 2020-11-28 | Webb | Texas | 48479 | 19703 | 398 |
401616 | 401616 | 2020-08-04 | Tarrant | Texas | 48439 | 30162 | 398 |
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);