ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,308 rows where deaths = 20 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Jim Hogg 147
- Blanco 56
- Refugio 40
- Knox 38
- Mills 38
- Coke 36
- Jack 34
- Fisher 33
- Live Oak 33
- McCulloch 30
- Childress 28
- Real 26
- Deaf Smith 25
- Calhoun 24
- Gonzales 23
- Chambers 21
- Cochran 21
- Winkler 21
- Martin 20
- Donley 19
- Trinity 18
- Ward 18
- Dallam 17
- Delta 15
- Somervell 15
- Wheeler 15
- Panola 14
- Hall 13
- Kerr 13
- Limestone 13
- …
state 1
- Texas · 1,308 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502247 | 2502247 | 2022-05-13 | Coke | Texas | 48081 | 843 | 20 |
2498989 | 2498989 | 2022-05-12 | Coke | Texas | 48081 | 843 | 20 |
2495731 | 2495731 | 2022-05-11 | Coke | Texas | 48081 | 842 | 20 |
2492473 | 2492473 | 2022-05-10 | Coke | Texas | 48081 | 842 | 20 |
2489215 | 2489215 | 2022-05-09 | Coke | Texas | 48081 | 842 | 20 |
2485958 | 2485958 | 2022-05-08 | Coke | Texas | 48081 | 842 | 20 |
2482700 | 2482700 | 2022-05-07 | Coke | Texas | 48081 | 842 | 20 |
2479442 | 2479442 | 2022-05-06 | Coke | Texas | 48081 | 842 | 20 |
2476184 | 2476184 | 2022-05-05 | Coke | Texas | 48081 | 842 | 20 |
2472927 | 2472927 | 2022-05-04 | Coke | Texas | 48081 | 842 | 20 |
2469671 | 2469671 | 2022-05-03 | Coke | Texas | 48081 | 842 | 20 |
2466415 | 2466415 | 2022-05-02 | Coke | Texas | 48081 | 842 | 20 |
2463160 | 2463160 | 2022-05-01 | Coke | Texas | 48081 | 842 | 20 |
2459904 | 2459904 | 2022-04-30 | Coke | Texas | 48081 | 842 | 20 |
2456648 | 2456648 | 2022-04-29 | Coke | Texas | 48081 | 840 | 20 |
2453392 | 2453392 | 2022-04-28 | Coke | Texas | 48081 | 840 | 20 |
2450136 | 2450136 | 2022-04-27 | Coke | Texas | 48081 | 840 | 20 |
2446879 | 2446879 | 2022-04-26 | Coke | Texas | 48081 | 840 | 20 |
2443624 | 2443624 | 2022-04-25 | Coke | Texas | 48081 | 840 | 20 |
2440368 | 2440368 | 2022-04-24 | Coke | Texas | 48081 | 840 | 20 |
2437112 | 2437112 | 2022-04-23 | Coke | Texas | 48081 | 840 | 20 |
2433856 | 2433856 | 2022-04-22 | Coke | Texas | 48081 | 840 | 20 |
2430600 | 2430600 | 2022-04-21 | Coke | Texas | 48081 | 840 | 20 |
2427344 | 2427344 | 2022-04-20 | Coke | Texas | 48081 | 840 | 20 |
2424088 | 2424088 | 2022-04-19 | Coke | Texas | 48081 | 840 | 20 |
2420832 | 2420832 | 2022-04-18 | Coke | Texas | 48081 | 840 | 20 |
2417576 | 2417576 | 2022-04-17 | Coke | Texas | 48081 | 839 | 20 |
2414320 | 2414320 | 2022-04-16 | Coke | Texas | 48081 | 839 | 20 |
2411064 | 2411064 | 2022-04-15 | Coke | Texas | 48081 | 839 | 20 |
2407808 | 2407808 | 2022-04-14 | Coke | Texas | 48081 | 839 | 20 |
2404552 | 2404552 | 2022-04-13 | Coke | Texas | 48081 | 839 | 20 |
2401297 | 2401297 | 2022-04-12 | Coke | Texas | 48081 | 838 | 20 |
2398042 | 2398042 | 2022-04-11 | Coke | Texas | 48081 | 838 | 20 |
2394787 | 2394787 | 2022-04-10 | Coke | Texas | 48081 | 838 | 20 |
2391531 | 2391531 | 2022-04-09 | Coke | Texas | 48081 | 838 | 20 |
2388275 | 2388275 | 2022-04-08 | Coke | Texas | 48081 | 838 | 20 |
2287630 | 2287630 | 2022-03-08 | Wheeler | Texas | 48483 | 1157 | 20 |
2284378 | 2284378 | 2022-03-07 | Wheeler | Texas | 48483 | 1157 | 20 |
2281126 | 2281126 | 2022-03-06 | Wheeler | Texas | 48483 | 1157 | 20 |
2277873 | 2277873 | 2022-03-05 | Wheeler | Texas | 48483 | 1157 | 20 |
2274620 | 2274620 | 2022-03-04 | Wheeler | Texas | 48483 | 1156 | 20 |
2271367 | 2271367 | 2022-03-03 | Wheeler | Texas | 48483 | 1155 | 20 |
2268115 | 2268115 | 2022-03-02 | Wheeler | Texas | 48483 | 1155 | 20 |
2264862 | 2264862 | 2022-03-01 | Wheeler | Texas | 48483 | 1154 | 20 |
2261612 | 2261612 | 2022-02-28 | Wheeler | Texas | 48483 | 1152 | 20 |
2258361 | 2258361 | 2022-02-27 | Wheeler | Texas | 48483 | 1152 | 20 |
2255110 | 2255110 | 2022-02-26 | Wheeler | Texas | 48483 | 1152 | 20 |
2251859 | 2251859 | 2022-02-25 | Wheeler | Texas | 48483 | 1149 | 20 |
2248608 | 2248608 | 2022-02-24 | Wheeler | Texas | 48483 | 1146 | 20 |
2245357 | 2245357 | 2022-02-23 | Wheeler | Texas | 48483 | 1143 | 20 |
2242106 | 2242106 | 2022-02-22 | Wheeler | Texas | 48483 | 1141 | 20 |
2225733 | 2225733 | 2022-02-17 | Jim Hogg | Texas | 48247 | 2446 | 20 |
2222482 | 2222482 | 2022-02-16 | Jim Hogg | Texas | 48247 | 2428 | 20 |
2219231 | 2219231 | 2022-02-15 | Jim Hogg | Texas | 48247 | 2391 | 20 |
2215980 | 2215980 | 2022-02-14 | Jim Hogg | Texas | 48247 | 2387 | 20 |
2212729 | 2212729 | 2022-02-13 | Jim Hogg | Texas | 48247 | 2386 | 20 |
2209476 | 2209476 | 2022-02-12 | Jim Hogg | Texas | 48247 | 2371 | 20 |
2206223 | 2206223 | 2022-02-11 | Jim Hogg | Texas | 48247 | 2371 | 20 |
2202970 | 2202970 | 2022-02-10 | Jim Hogg | Texas | 48247 | 2317 | 20 |
2199688 | 2199688 | 2022-02-09 | Hall | Texas | 48191 | 936 | 20 |
2199716 | 2199716 | 2022-02-09 | Jim Hogg | Texas | 48247 | 2316 | 20 |
2196434 | 2196434 | 2022-02-08 | Hall | Texas | 48191 | 932 | 20 |
2196462 | 2196462 | 2022-02-08 | Jim Hogg | Texas | 48247 | 2298 | 20 |
2193160 | 2193160 | 2022-02-07 | Fisher | Texas | 48151 | 579 | 20 |
2193180 | 2193180 | 2022-02-07 | Hall | Texas | 48191 | 924 | 20 |
2193208 | 2193208 | 2022-02-07 | Jim Hogg | Texas | 48247 | 2297 | 20 |
2189906 | 2189906 | 2022-02-06 | Fisher | Texas | 48151 | 579 | 20 |
2189926 | 2189926 | 2022-02-06 | Hall | Texas | 48191 | 924 | 20 |
2189954 | 2189954 | 2022-02-06 | Jim Hogg | Texas | 48247 | 2284 | 20 |
2186653 | 2186653 | 2022-02-05 | Fisher | Texas | 48151 | 578 | 20 |
2186673 | 2186673 | 2022-02-05 | Hall | Texas | 48191 | 924 | 20 |
2186701 | 2186701 | 2022-02-05 | Jim Hogg | Texas | 48247 | 2263 | 20 |
2183401 | 2183401 | 2022-02-04 | Fisher | Texas | 48151 | 577 | 20 |
2183421 | 2183421 | 2022-02-04 | Hall | Texas | 48191 | 911 | 20 |
2183449 | 2183449 | 2022-02-04 | Jim Hogg | Texas | 48247 | 2239 | 20 |
2180149 | 2180149 | 2022-02-03 | Fisher | Texas | 48151 | 577 | 20 |
2180169 | 2180169 | 2022-02-03 | Hall | Texas | 48191 | 910 | 20 |
2180197 | 2180197 | 2022-02-03 | Jim Hogg | Texas | 48247 | 2215 | 20 |
2176898 | 2176898 | 2022-02-02 | Fisher | Texas | 48151 | 576 | 20 |
2176918 | 2176918 | 2022-02-02 | Hall | Texas | 48191 | 907 | 20 |
2176946 | 2176946 | 2022-02-02 | Jim Hogg | Texas | 48247 | 2168 | 20 |
2173633 | 2173633 | 2022-02-01 | Donley | Texas | 48129 | 929 | 20 |
2173644 | 2173644 | 2022-02-01 | Fisher | Texas | 48151 | 574 | 20 |
2173664 | 2173664 | 2022-02-01 | Hall | Texas | 48191 | 907 | 20 |
2173692 | 2173692 | 2022-02-01 | Jim Hogg | Texas | 48247 | 2101 | 20 |
2170368 | 2170368 | 2022-01-31 | Crane | Texas | 48103 | 1168 | 20 |
2170381 | 2170381 | 2022-01-31 | Donley | Texas | 48129 | 927 | 20 |
2170392 | 2170392 | 2022-01-31 | Fisher | Texas | 48151 | 568 | 20 |
2170412 | 2170412 | 2022-01-31 | Hall | Texas | 48191 | 905 | 20 |
2170440 | 2170440 | 2022-01-31 | Jim Hogg | Texas | 48247 | 2055 | 20 |
2167114 | 2167114 | 2022-01-30 | Crane | Texas | 48103 | 1166 | 20 |
2167127 | 2167127 | 2022-01-30 | Donley | Texas | 48129 | 926 | 20 |
2167138 | 2167138 | 2022-01-30 | Fisher | Texas | 48151 | 568 | 20 |
2167158 | 2167158 | 2022-01-30 | Hall | Texas | 48191 | 902 | 20 |
2167186 | 2167186 | 2022-01-30 | Jim Hogg | Texas | 48247 | 2054 | 20 |
2163872 | 2163872 | 2022-01-29 | Donley | Texas | 48129 | 924 | 20 |
2163883 | 2163883 | 2022-01-29 | Fisher | Texas | 48151 | 565 | 20 |
2163903 | 2163903 | 2022-01-29 | Hall | Texas | 48191 | 901 | 20 |
2163931 | 2163931 | 2022-01-29 | Jim Hogg | Texas | 48247 | 2010 | 20 |
2160617 | 2160617 | 2022-01-28 | Donley | Texas | 48129 | 922 | 20 |
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);