ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where deaths = 59 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jackson 73
- DeWitt 63
- Marion 59
- Rains 53
- Houston 33
- Bosque 25
- Burleson 24
- Coleman 23
- Reeves 21
- Newton 20
- Willacy 18
- Gonzales 16
- Duval 15
- Liberty 14
- Red River 13
- Trinity 13
- Matagorda 12
- Zavala 12
- Chambers 11
- Shelby 9
- Callahan 8
- Wilbarger 8
- Comanche 7
- Dawson 7
- Gregg 7
- Terry 7
- Washington 7
- Freestone 6
- Gaines 6
- Gillespie 6
- …
state 1
- Texas · 783 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502326 | 2502326 | 2022-05-13 | Jackson | Texas | 48239 | 3258 | 59 |
2502397 | 2502397 | 2022-05-13 | Rains | Texas | 48379 | 1839 | 59 |
2499068 | 2499068 | 2022-05-12 | Jackson | Texas | 48239 | 3258 | 59 |
2499139 | 2499139 | 2022-05-12 | Rains | Texas | 48379 | 1839 | 59 |
2495810 | 2495810 | 2022-05-11 | Jackson | Texas | 48239 | 3258 | 59 |
2495881 | 2495881 | 2022-05-11 | Rains | Texas | 48379 | 1839 | 59 |
2492552 | 2492552 | 2022-05-10 | Jackson | Texas | 48239 | 3258 | 59 |
2492623 | 2492623 | 2022-05-10 | Rains | Texas | 48379 | 1839 | 59 |
2489294 | 2489294 | 2022-05-09 | Jackson | Texas | 48239 | 3257 | 59 |
2489365 | 2489365 | 2022-05-09 | Rains | Texas | 48379 | 1839 | 59 |
2486037 | 2486037 | 2022-05-08 | Jackson | Texas | 48239 | 3257 | 59 |
2486107 | 2486107 | 2022-05-08 | Rains | Texas | 48379 | 1839 | 59 |
2482779 | 2482779 | 2022-05-07 | Jackson | Texas | 48239 | 3257 | 59 |
2482849 | 2482849 | 2022-05-07 | Rains | Texas | 48379 | 1839 | 59 |
2479521 | 2479521 | 2022-05-06 | Jackson | Texas | 48239 | 3257 | 59 |
2479591 | 2479591 | 2022-05-06 | Rains | Texas | 48379 | 1839 | 59 |
2476263 | 2476263 | 2022-05-05 | Jackson | Texas | 48239 | 3257 | 59 |
2476333 | 2476333 | 2022-05-05 | Rains | Texas | 48379 | 1839 | 59 |
2473006 | 2473006 | 2022-05-04 | Jackson | Texas | 48239 | 3257 | 59 |
2473076 | 2473076 | 2022-05-04 | Rains | Texas | 48379 | 1839 | 59 |
2469750 | 2469750 | 2022-05-03 | Jackson | Texas | 48239 | 3257 | 59 |
2469820 | 2469820 | 2022-05-03 | Rains | Texas | 48379 | 1839 | 59 |
2466494 | 2466494 | 2022-05-02 | Jackson | Texas | 48239 | 3257 | 59 |
2466529 | 2466529 | 2022-05-02 | Marion | Texas | 48315 | 1690 | 59 |
2466564 | 2466564 | 2022-05-02 | Rains | Texas | 48379 | 1838 | 59 |
2463239 | 2463239 | 2022-05-01 | Jackson | Texas | 48239 | 3257 | 59 |
2463274 | 2463274 | 2022-05-01 | Marion | Texas | 48315 | 1690 | 59 |
2463309 | 2463309 | 2022-05-01 | Rains | Texas | 48379 | 1838 | 59 |
2459983 | 2459983 | 2022-04-30 | Jackson | Texas | 48239 | 3257 | 59 |
2460018 | 2460018 | 2022-04-30 | Marion | Texas | 48315 | 1690 | 59 |
2460053 | 2460053 | 2022-04-30 | Rains | Texas | 48379 | 1838 | 59 |
2456727 | 2456727 | 2022-04-29 | Jackson | Texas | 48239 | 3257 | 59 |
2456762 | 2456762 | 2022-04-29 | Marion | Texas | 48315 | 1690 | 59 |
2456797 | 2456797 | 2022-04-29 | Rains | Texas | 48379 | 1838 | 59 |
2453471 | 2453471 | 2022-04-28 | Jackson | Texas | 48239 | 3257 | 59 |
2453506 | 2453506 | 2022-04-28 | Marion | Texas | 48315 | 1690 | 59 |
2453541 | 2453541 | 2022-04-28 | Rains | Texas | 48379 | 1837 | 59 |
2450215 | 2450215 | 2022-04-27 | Jackson | Texas | 48239 | 3257 | 59 |
2450250 | 2450250 | 2022-04-27 | Marion | Texas | 48315 | 1689 | 59 |
2450285 | 2450285 | 2022-04-27 | Rains | Texas | 48379 | 1836 | 59 |
2446958 | 2446958 | 2022-04-26 | Jackson | Texas | 48239 | 3257 | 59 |
2446993 | 2446993 | 2022-04-26 | Marion | Texas | 48315 | 1689 | 59 |
2447028 | 2447028 | 2022-04-26 | Rains | Texas | 48379 | 1836 | 59 |
2443703 | 2443703 | 2022-04-25 | Jackson | Texas | 48239 | 3256 | 59 |
2443738 | 2443738 | 2022-04-25 | Marion | Texas | 48315 | 1689 | 59 |
2443773 | 2443773 | 2022-04-25 | Rains | Texas | 48379 | 1836 | 59 |
2440447 | 2440447 | 2022-04-24 | Jackson | Texas | 48239 | 3255 | 59 |
2440482 | 2440482 | 2022-04-24 | Marion | Texas | 48315 | 1689 | 59 |
2440517 | 2440517 | 2022-04-24 | Rains | Texas | 48379 | 1834 | 59 |
2437191 | 2437191 | 2022-04-23 | Jackson | Texas | 48239 | 3255 | 59 |
2437226 | 2437226 | 2022-04-23 | Marion | Texas | 48315 | 1689 | 59 |
2437261 | 2437261 | 2022-04-23 | Rains | Texas | 48379 | 1834 | 59 |
2433935 | 2433935 | 2022-04-22 | Jackson | Texas | 48239 | 3255 | 59 |
2433970 | 2433970 | 2022-04-22 | Marion | Texas | 48315 | 1689 | 59 |
2434005 | 2434005 | 2022-04-22 | Rains | Texas | 48379 | 1834 | 59 |
2430679 | 2430679 | 2022-04-21 | Jackson | Texas | 48239 | 3254 | 59 |
2430714 | 2430714 | 2022-04-21 | Marion | Texas | 48315 | 1688 | 59 |
2430749 | 2430749 | 2022-04-21 | Rains | Texas | 48379 | 1834 | 59 |
2427423 | 2427423 | 2022-04-20 | Jackson | Texas | 48239 | 3254 | 59 |
2427458 | 2427458 | 2022-04-20 | Marion | Texas | 48315 | 1687 | 59 |
2427493 | 2427493 | 2022-04-20 | Rains | Texas | 48379 | 1834 | 59 |
2424167 | 2424167 | 2022-04-19 | Jackson | Texas | 48239 | 3254 | 59 |
2424202 | 2424202 | 2022-04-19 | Marion | Texas | 48315 | 1687 | 59 |
2424237 | 2424237 | 2022-04-19 | Rains | Texas | 48379 | 1834 | 59 |
2420911 | 2420911 | 2022-04-18 | Jackson | Texas | 48239 | 3254 | 59 |
2420946 | 2420946 | 2022-04-18 | Marion | Texas | 48315 | 1687 | 59 |
2420981 | 2420981 | 2022-04-18 | Rains | Texas | 48379 | 1834 | 59 |
2417655 | 2417655 | 2022-04-17 | Jackson | Texas | 48239 | 3254 | 59 |
2417690 | 2417690 | 2022-04-17 | Marion | Texas | 48315 | 1687 | 59 |
2417725 | 2417725 | 2022-04-17 | Rains | Texas | 48379 | 1834 | 59 |
2414399 | 2414399 | 2022-04-16 | Jackson | Texas | 48239 | 3254 | 59 |
2414434 | 2414434 | 2022-04-16 | Marion | Texas | 48315 | 1687 | 59 |
2414469 | 2414469 | 2022-04-16 | Rains | Texas | 48379 | 1834 | 59 |
2411143 | 2411143 | 2022-04-15 | Jackson | Texas | 48239 | 3254 | 59 |
2411178 | 2411178 | 2022-04-15 | Marion | Texas | 48315 | 1687 | 59 |
2411213 | 2411213 | 2022-04-15 | Rains | Texas | 48379 | 1834 | 59 |
2407887 | 2407887 | 2022-04-14 | Jackson | Texas | 48239 | 3254 | 59 |
2407922 | 2407922 | 2022-04-14 | Marion | Texas | 48315 | 1687 | 59 |
2407957 | 2407957 | 2022-04-14 | Rains | Texas | 48379 | 1834 | 59 |
2404631 | 2404631 | 2022-04-13 | Jackson | Texas | 48239 | 3253 | 59 |
2404666 | 2404666 | 2022-04-13 | Marion | Texas | 48315 | 1687 | 59 |
2404701 | 2404701 | 2022-04-13 | Rains | Texas | 48379 | 1834 | 59 |
2401376 | 2401376 | 2022-04-12 | Jackson | Texas | 48239 | 3253 | 59 |
2401411 | 2401411 | 2022-04-12 | Marion | Texas | 48315 | 1682 | 59 |
2401446 | 2401446 | 2022-04-12 | Rains | Texas | 48379 | 1834 | 59 |
2398121 | 2398121 | 2022-04-11 | Jackson | Texas | 48239 | 3253 | 59 |
2398156 | 2398156 | 2022-04-11 | Marion | Texas | 48315 | 1681 | 59 |
2398191 | 2398191 | 2022-04-11 | Rains | Texas | 48379 | 1834 | 59 |
2394866 | 2394866 | 2022-04-10 | Jackson | Texas | 48239 | 3253 | 59 |
2394901 | 2394901 | 2022-04-10 | Marion | Texas | 48315 | 1681 | 59 |
2394936 | 2394936 | 2022-04-10 | Rains | Texas | 48379 | 1834 | 59 |
2391610 | 2391610 | 2022-04-09 | Jackson | Texas | 48239 | 3253 | 59 |
2391645 | 2391645 | 2022-04-09 | Marion | Texas | 48315 | 1681 | 59 |
2391680 | 2391680 | 2022-04-09 | Rains | Texas | 48379 | 1834 | 59 |
2388354 | 2388354 | 2022-04-08 | Jackson | Texas | 48239 | 3253 | 59 |
2388389 | 2388389 | 2022-04-08 | Marion | Texas | 48315 | 1680 | 59 |
2388424 | 2388424 | 2022-04-08 | Rains | Texas | 48379 | 1834 | 59 |
2385099 | 2385099 | 2022-04-07 | Jackson | Texas | 48239 | 3251 | 59 |
2385134 | 2385134 | 2022-04-07 | Marion | Texas | 48315 | 1677 | 59 |
2385169 | 2385169 | 2022-04-07 | Rains | Texas | 48379 | 1833 | 59 |
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);