ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
228 rows where deaths = 128 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Titus 44
- Wood 23
- Montague 14
- Wise 13
- Washington 12
- Hutchinson 7
- Bee 6
- Comal 6
- Panola 6
- Walker 6
- Anderson 5
- Shelby 5
- Van Zandt 5
- Cooke 4
- Harrison 4
- Val Verde 4
- Caldwell 3
- Cherokee 3
- Fannin 3
- Henderson 3
- Hockley 3
- Jefferson 3
- Victoria 3
- Burnet 2
- Guadalupe 2
- Hopkins 2
- Hunt 2
- Kleberg 2
- Medina 2
- Webb 2
- …
state 1
- Texas · 228 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502432 | 2502432 | 2022-05-13 | Titus | Texas | 48449 | 8673 | 128 |
2499174 | 2499174 | 2022-05-12 | Titus | Texas | 48449 | 8662 | 128 |
2495916 | 2495916 | 2022-05-11 | Titus | Texas | 48449 | 8658 | 128 |
2492658 | 2492658 | 2022-05-10 | Titus | Texas | 48449 | 8657 | 128 |
2489400 | 2489400 | 2022-05-09 | Titus | Texas | 48449 | 8655 | 128 |
2486142 | 2486142 | 2022-05-08 | Titus | Texas | 48449 | 8653 | 128 |
2482884 | 2482884 | 2022-05-07 | Titus | Texas | 48449 | 8652 | 128 |
2479626 | 2479626 | 2022-05-06 | Titus | Texas | 48449 | 8652 | 128 |
2476312 | 2476312 | 2022-05-05 | Montague | Texas | 48337 | 4687 | 128 |
2476368 | 2476368 | 2022-05-05 | Titus | Texas | 48449 | 8651 | 128 |
2473055 | 2473055 | 2022-05-04 | Montague | Texas | 48337 | 4684 | 128 |
2473111 | 2473111 | 2022-05-04 | Titus | Texas | 48449 | 8650 | 128 |
2469799 | 2469799 | 2022-05-03 | Montague | Texas | 48337 | 4684 | 128 |
2469855 | 2469855 | 2022-05-03 | Titus | Texas | 48449 | 8650 | 128 |
2466543 | 2466543 | 2022-05-02 | Montague | Texas | 48337 | 4684 | 128 |
2466599 | 2466599 | 2022-05-02 | Titus | Texas | 48449 | 8650 | 128 |
2463288 | 2463288 | 2022-05-01 | Montague | Texas | 48337 | 4684 | 128 |
2463344 | 2463344 | 2022-05-01 | Titus | Texas | 48449 | 8650 | 128 |
2460032 | 2460032 | 2022-04-30 | Montague | Texas | 48337 | 4684 | 128 |
2460088 | 2460088 | 2022-04-30 | Titus | Texas | 48449 | 8650 | 128 |
2456776 | 2456776 | 2022-04-29 | Montague | Texas | 48337 | 4683 | 128 |
2456832 | 2456832 | 2022-04-29 | Titus | Texas | 48449 | 8650 | 128 |
2453520 | 2453520 | 2022-04-28 | Montague | Texas | 48337 | 4679 | 128 |
2453576 | 2453576 | 2022-04-28 | Titus | Texas | 48449 | 8649 | 128 |
2450264 | 2450264 | 2022-04-27 | Montague | Texas | 48337 | 4678 | 128 |
2450320 | 2450320 | 2022-04-27 | Titus | Texas | 48449 | 8649 | 128 |
2447007 | 2447007 | 2022-04-26 | Montague | Texas | 48337 | 4677 | 128 |
2447063 | 2447063 | 2022-04-26 | Titus | Texas | 48449 | 8649 | 128 |
2443752 | 2443752 | 2022-04-25 | Montague | Texas | 48337 | 4677 | 128 |
2443808 | 2443808 | 2022-04-25 | Titus | Texas | 48449 | 8649 | 128 |
2440496 | 2440496 | 2022-04-24 | Montague | Texas | 48337 | 4676 | 128 |
2440552 | 2440552 | 2022-04-24 | Titus | Texas | 48449 | 8649 | 128 |
2437240 | 2437240 | 2022-04-23 | Montague | Texas | 48337 | 4676 | 128 |
2437296 | 2437296 | 2022-04-23 | Titus | Texas | 48449 | 8649 | 128 |
2433984 | 2433984 | 2022-04-22 | Montague | Texas | 48337 | 4674 | 128 |
2434040 | 2434040 | 2022-04-22 | Titus | Texas | 48449 | 8649 | 128 |
2430784 | 2430784 | 2022-04-21 | Titus | Texas | 48449 | 8648 | 128 |
2427528 | 2427528 | 2022-04-20 | Titus | Texas | 48449 | 8646 | 128 |
2424272 | 2424272 | 2022-04-19 | Titus | Texas | 48449 | 8642 | 128 |
2421016 | 2421016 | 2022-04-18 | Titus | Texas | 48449 | 8640 | 128 |
2417760 | 2417760 | 2022-04-17 | Titus | Texas | 48449 | 8632 | 128 |
2414504 | 2414504 | 2022-04-16 | Titus | Texas | 48449 | 8632 | 128 |
2411248 | 2411248 | 2022-04-15 | Titus | Texas | 48449 | 8632 | 128 |
2407992 | 2407992 | 2022-04-14 | Titus | Texas | 48449 | 8632 | 128 |
2404736 | 2404736 | 2022-04-13 | Titus | Texas | 48449 | 8595 | 128 |
2401481 | 2401481 | 2022-04-12 | Titus | Texas | 48449 | 8590 | 128 |
2398226 | 2398226 | 2022-04-11 | Titus | Texas | 48449 | 8587 | 128 |
2394971 | 2394971 | 2022-04-10 | Titus | Texas | 48449 | 8587 | 128 |
2391715 | 2391715 | 2022-04-09 | Titus | Texas | 48449 | 8587 | 128 |
2388459 | 2388459 | 2022-04-08 | Titus | Texas | 48449 | 8587 | 128 |
2385204 | 2385204 | 2022-04-07 | Titus | Texas | 48449 | 8584 | 128 |
2381949 | 2381949 | 2022-04-06 | Titus | Texas | 48449 | 8584 | 128 |
2378694 | 2378694 | 2022-04-05 | Titus | Texas | 48449 | 8584 | 128 |
2375440 | 2375440 | 2022-04-04 | Titus | Texas | 48449 | 8580 | 128 |
2372188 | 2372188 | 2022-04-03 | Titus | Texas | 48449 | 8580 | 128 |
2368935 | 2368935 | 2022-04-02 | Titus | Texas | 48449 | 8580 | 128 |
2365682 | 2365682 | 2022-04-01 | Titus | Texas | 48449 | 8579 | 128 |
2362429 | 2362429 | 2022-03-31 | Titus | Texas | 48449 | 8578 | 128 |
2352688 | 2352688 | 2022-03-28 | Willacy | Texas | 48489 | 6952 | 128 |
2349436 | 2349436 | 2022-03-27 | Willacy | Texas | 48489 | 6949 | 128 |
2313615 | 2313615 | 2022-03-16 | Shelby | Texas | 48419 | 4376 | 128 |
2310362 | 2310362 | 2022-03-15 | Shelby | Texas | 48419 | 4373 | 128 |
2307109 | 2307109 | 2022-03-14 | Shelby | Texas | 48419 | 4372 | 128 |
2303858 | 2303858 | 2022-03-13 | Shelby | Texas | 48419 | 4372 | 128 |
2300606 | 2300606 | 2022-03-12 | Shelby | Texas | 48419 | 4372 | 128 |
2294075 | 2294075 | 2022-03-10 | Panola | Texas | 48365 | 4528 | 128 |
2290823 | 2290823 | 2022-03-09 | Panola | Texas | 48365 | 4515 | 128 |
2287571 | 2287571 | 2022-03-08 | Panola | Texas | 48365 | 4511 | 128 |
2284319 | 2284319 | 2022-03-07 | Panola | Texas | 48365 | 4508 | 128 |
2281067 | 2281067 | 2022-03-06 | Panola | Texas | 48365 | 4507 | 128 |
2277814 | 2277814 | 2022-03-05 | Panola | Texas | 48365 | 4507 | 128 |
2251666 | 2251666 | 2022-02-25 | Cooke | Texas | 48097 | 7132 | 128 |
2248415 | 2248415 | 2022-02-24 | Cooke | Texas | 48097 | 7124 | 128 |
2245164 | 2245164 | 2022-02-23 | Cooke | Texas | 48097 | 7112 | 128 |
2241913 | 2241913 | 2022-02-22 | Cooke | Texas | 48097 | 7103 | 128 |
2219224 | 2219224 | 2022-02-15 | Hutchinson | Texas | 48233 | 6514 | 128 |
2215973 | 2215973 | 2022-02-14 | Hutchinson | Texas | 48233 | 6510 | 128 |
2212722 | 2212722 | 2022-02-13 | Hutchinson | Texas | 48233 | 6506 | 128 |
2209469 | 2209469 | 2022-02-12 | Hutchinson | Texas | 48233 | 6499 | 128 |
2206216 | 2206216 | 2022-02-11 | Hutchinson | Texas | 48233 | 6483 | 128 |
2202963 | 2202963 | 2022-02-10 | Hutchinson | Texas | 48233 | 6471 | 128 |
2199709 | 2199709 | 2022-02-09 | Hutchinson | Texas | 48233 | 6442 | 128 |
1906983 | 1906983 | 2021-11-11 | Bee | Texas | 48025 | 5338 | 128 |
1903734 | 1903734 | 2021-11-10 | Bee | Texas | 48025 | 5336 | 128 |
1903748 | 1903748 | 2021-11-10 | Burnet | Texas | 48053 | 7447 | 128 |
1900484 | 1900484 | 2021-11-09 | Bee | Texas | 48025 | 5336 | 128 |
1900498 | 1900498 | 2021-11-09 | Burnet | Texas | 48053 | 7447 | 128 |
1897234 | 1897234 | 2021-11-08 | Bee | Texas | 48025 | 5321 | 128 |
1893984 | 1893984 | 2021-11-07 | Bee | Texas | 48025 | 5321 | 128 |
1890734 | 1890734 | 2021-11-06 | Bee | Texas | 48025 | 5317 | 128 |
1884460 | 1884460 | 2021-11-04 | Washington | Texas | 48477 | 5758 | 128 |
1881109 | 1881109 | 2021-11-03 | Kleberg | Texas | 48273 | 4326 | 128 |
1881211 | 1881211 | 2021-11-03 | Washington | Texas | 48477 | 5756 | 128 |
1877860 | 1877860 | 2021-11-02 | Kleberg | Texas | 48273 | 4324 | 128 |
1877962 | 1877962 | 2021-11-02 | Washington | Texas | 48477 | 5756 | 128 |
1874713 | 1874713 | 2021-11-01 | Washington | Texas | 48477 | 5754 | 128 |
1871464 | 1871464 | 2021-10-31 | Washington | Texas | 48477 | 5749 | 128 |
1868215 | 1868215 | 2021-10-30 | Washington | Texas | 48477 | 5749 | 128 |
1864966 | 1864966 | 2021-10-29 | Washington | Texas | 48477 | 5747 | 128 |
1861717 | 1861717 | 2021-10-28 | Washington | Texas | 48477 | 5737 | 128 |
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);