ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,606 rows where deaths = 17 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Childress 181
- Knox 120
- Swisher 90
- Crockett 80
- Refugio 79
- Jim Hogg 54
- Brewster 51
- Clay 47
- Marion 36
- Upton 36
- Rockwall 33
- Fisher 29
- Waller 29
- Karnes 28
- Somervell 25
- Carson 24
- Deaf Smith 20
- Palo Pinto 20
- San Saba 19
- Crane 18
- Bailey 17
- Red River 17
- Runnels 17
- Newton 16
- Coke 15
- Garza 13
- Live Oak 13
- Nacogdoches 13
- Martin 12
- Webb 12
- …
state 1
- Texas · 1,606 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2326534 | 2326534 | 2022-03-20 | Hudspeth | Texas | 48229 | 982 | 17 |
2323281 | 2323281 | 2022-03-19 | Hudspeth | Texas | 48229 | 982 | 17 |
2320027 | 2320027 | 2022-03-18 | Hudspeth | Texas | 48229 | 982 | 17 |
2316773 | 2316773 | 2022-03-17 | Hudspeth | Texas | 48229 | 982 | 17 |
2313520 | 2313520 | 2022-03-16 | Hudspeth | Texas | 48229 | 982 | 17 |
2271356 | 2271356 | 2022-03-03 | Upton | Texas | 48461 | 827 | 17 |
2268104 | 2268104 | 2022-03-02 | Upton | Texas | 48461 | 827 | 17 |
2264851 | 2264851 | 2022-03-01 | Upton | Texas | 48461 | 826 | 17 |
2261601 | 2261601 | 2022-02-28 | Upton | Texas | 48461 | 825 | 17 |
2258350 | 2258350 | 2022-02-27 | Upton | Texas | 48461 | 825 | 17 |
2255099 | 2255099 | 2022-02-26 | Upton | Texas | 48461 | 825 | 17 |
2251848 | 2251848 | 2022-02-25 | Upton | Texas | 48461 | 823 | 17 |
2248597 | 2248597 | 2022-02-24 | Upton | Texas | 48461 | 823 | 17 |
2245346 | 2245346 | 2022-02-23 | Upton | Texas | 48461 | 822 | 17 |
2241963 | 2241963 | 2022-02-22 | Hardeman | Texas | 48197 | 551 | 17 |
2242095 | 2242095 | 2022-02-22 | Upton | Texas | 48461 | 822 | 17 |
2238844 | 2238844 | 2022-02-21 | Upton | Texas | 48461 | 822 | 17 |
2235593 | 2235593 | 2022-02-20 | Upton | Texas | 48461 | 820 | 17 |
2232342 | 2232342 | 2022-02-19 | Upton | Texas | 48461 | 820 | 17 |
2228913 | 2228913 | 2022-02-18 | Crockett | Texas | 48105 | 1018 | 17 |
2229091 | 2229091 | 2022-02-18 | Upton | Texas | 48461 | 818 | 17 |
2225662 | 2225662 | 2022-02-17 | Crockett | Texas | 48105 | 1018 | 17 |
2225840 | 2225840 | 2022-02-17 | Upton | Texas | 48461 | 816 | 17 |
2222411 | 2222411 | 2022-02-16 | Crockett | Texas | 48105 | 1017 | 17 |
2222589 | 2222589 | 2022-02-16 | Upton | Texas | 48461 | 813 | 17 |
2219160 | 2219160 | 2022-02-15 | Crockett | Texas | 48105 | 1015 | 17 |
2219338 | 2219338 | 2022-02-15 | Upton | Texas | 48461 | 812 | 17 |
2215909 | 2215909 | 2022-02-14 | Crockett | Texas | 48105 | 1015 | 17 |
2216087 | 2216087 | 2022-02-14 | Upton | Texas | 48461 | 810 | 17 |
2212658 | 2212658 | 2022-02-13 | Crockett | Texas | 48105 | 1015 | 17 |
2212836 | 2212836 | 2022-02-13 | Upton | Texas | 48461 | 810 | 17 |
2209405 | 2209405 | 2022-02-12 | Crockett | Texas | 48105 | 1015 | 17 |
2209583 | 2209583 | 2022-02-12 | Upton | Texas | 48461 | 810 | 17 |
2206152 | 2206152 | 2022-02-11 | Crockett | Texas | 48105 | 1015 | 17 |
2206330 | 2206330 | 2022-02-11 | Upton | Texas | 48461 | 806 | 17 |
2202899 | 2202899 | 2022-02-10 | Crockett | Texas | 48105 | 1015 | 17 |
2203077 | 2203077 | 2022-02-10 | Upton | Texas | 48461 | 803 | 17 |
2199645 | 2199645 | 2022-02-09 | Crockett | Texas | 48105 | 1015 | 17 |
2199823 | 2199823 | 2022-02-09 | Upton | Texas | 48461 | 797 | 17 |
2196391 | 2196391 | 2022-02-08 | Crockett | Texas | 48105 | 1015 | 17 |
2196569 | 2196569 | 2022-02-08 | Upton | Texas | 48461 | 794 | 17 |
2193137 | 2193137 | 2022-02-07 | Crockett | Texas | 48105 | 1014 | 17 |
2193315 | 2193315 | 2022-02-07 | Upton | Texas | 48461 | 792 | 17 |
2189883 | 2189883 | 2022-02-06 | Crockett | Texas | 48105 | 1012 | 17 |
2190062 | 2190062 | 2022-02-06 | Upton | Texas | 48461 | 791 | 17 |
2186630 | 2186630 | 2022-02-05 | Crockett | Texas | 48105 | 1012 | 17 |
2186809 | 2186809 | 2022-02-05 | Upton | Texas | 48461 | 791 | 17 |
2183378 | 2183378 | 2022-02-04 | Crockett | Texas | 48105 | 1010 | 17 |
2183556 | 2183556 | 2022-02-04 | Upton | Texas | 48461 | 786 | 17 |
2183567 | 2183567 | 2022-02-04 | Wheeler | Texas | 48483 | 1115 | 17 |
2180126 | 2180126 | 2022-02-03 | Crockett | Texas | 48105 | 1008 | 17 |
2180304 | 2180304 | 2022-02-03 | Upton | Texas | 48461 | 778 | 17 |
2176875 | 2176875 | 2022-02-02 | Crockett | Texas | 48105 | 1003 | 17 |
2177053 | 2177053 | 2022-02-02 | Upton | Texas | 48461 | 773 | 17 |
2173621 | 2173621 | 2022-02-01 | Crockett | Texas | 48105 | 1002 | 17 |
2173800 | 2173800 | 2022-02-01 | Upton | Texas | 48461 | 771 | 17 |
2170369 | 2170369 | 2022-01-31 | Crockett | Texas | 48105 | 1001 | 17 |
2170548 | 2170548 | 2022-01-31 | Upton | Texas | 48461 | 768 | 17 |
2167115 | 2167115 | 2022-01-30 | Crockett | Texas | 48105 | 999 | 17 |
2167294 | 2167294 | 2022-01-30 | Upton | Texas | 48461 | 768 | 17 |
2163860 | 2163860 | 2022-01-29 | Crockett | Texas | 48105 | 997 | 17 |
2164039 | 2164039 | 2022-01-29 | Upton | Texas | 48461 | 767 | 17 |
2160605 | 2160605 | 2022-01-28 | Crockett | Texas | 48105 | 996 | 17 |
2160784 | 2160784 | 2022-01-28 | Upton | Texas | 48461 | 760 | 17 |
2157349 | 2157349 | 2022-01-27 | Crockett | Texas | 48105 | 991 | 17 |
2157528 | 2157528 | 2022-01-27 | Upton | Texas | 48461 | 756 | 17 |
2154096 | 2154096 | 2022-01-26 | Crockett | Texas | 48105 | 986 | 17 |
2150844 | 2150844 | 2022-01-25 | Crockett | Texas | 48105 | 979 | 17 |
2147592 | 2147592 | 2022-01-24 | Crockett | Texas | 48105 | 973 | 17 |
2144338 | 2144338 | 2022-01-23 | Crockett | Texas | 48105 | 968 | 17 |
2141083 | 2141083 | 2022-01-22 | Crockett | Texas | 48105 | 966 | 17 |
2137827 | 2137827 | 2022-01-21 | Crockett | Texas | 48105 | 957 | 17 |
2134573 | 2134573 | 2022-01-20 | Crockett | Texas | 48105 | 942 | 17 |
2131321 | 2131321 | 2022-01-19 | Crockett | Texas | 48105 | 939 | 17 |
2128067 | 2128067 | 2022-01-18 | Crockett | Texas | 48105 | 913 | 17 |
2124815 | 2124815 | 2022-01-17 | Crockett | Texas | 48105 | 887 | 17 |
2121563 | 2121563 | 2022-01-16 | Crockett | Texas | 48105 | 838 | 17 |
2118311 | 2118311 | 2022-01-15 | Crockett | Texas | 48105 | 834 | 17 |
2115060 | 2115060 | 2022-01-14 | Crockett | Texas | 48105 | 822 | 17 |
2111808 | 2111808 | 2022-01-13 | Crockett | Texas | 48105 | 948 | 17 |
2108556 | 2108556 | 2022-01-12 | Crockett | Texas | 48105 | 913 | 17 |
2105305 | 2105305 | 2022-01-11 | Crockett | Texas | 48105 | 894 | 17 |
2102054 | 2102054 | 2022-01-10 | Crockett | Texas | 48105 | 890 | 17 |
2098803 | 2098803 | 2022-01-09 | Crockett | Texas | 48105 | 887 | 17 |
2095551 | 2095551 | 2022-01-08 | Crockett | Texas | 48105 | 881 | 17 |
2092299 | 2092299 | 2022-01-07 | Crockett | Texas | 48105 | 873 | 17 |
2089047 | 2089047 | 2022-01-06 | Crockett | Texas | 48105 | 863 | 17 |
2085796 | 2085796 | 2022-01-05 | Crockett | Texas | 48105 | 852 | 17 |
2082544 | 2082544 | 2022-01-04 | Crockett | Texas | 48105 | 840 | 17 |
2079292 | 2079292 | 2022-01-03 | Crockett | Texas | 48105 | 835 | 17 |
2076041 | 2076041 | 2022-01-02 | Crockett | Texas | 48105 | 808 | 17 |
2072790 | 2072790 | 2022-01-01 | Crockett | Texas | 48105 | 808 | 17 |
2069539 | 2069539 | 2021-12-31 | Crockett | Texas | 48105 | 808 | 17 |
2066288 | 2066288 | 2021-12-30 | Crockett | Texas | 48105 | 808 | 17 |
2063038 | 2063038 | 2021-12-29 | Crockett | Texas | 48105 | 807 | 17 |
2059788 | 2059788 | 2021-12-28 | Crockett | Texas | 48105 | 802 | 17 |
2056539 | 2056539 | 2021-12-27 | Crockett | Texas | 48105 | 800 | 17 |
2053290 | 2053290 | 2021-12-26 | Crockett | Texas | 48105 | 797 | 17 |
2050040 | 2050040 | 2021-12-25 | Crockett | Texas | 48105 | 797 | 17 |
2046790 | 2046790 | 2021-12-24 | Crockett | Texas | 48105 | 797 | 17 |
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);