ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
723 rows where deaths = 44 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Young 65
- Reeves 54
- Camp 44
- San Augustine 38
- DeWitt 33
- Crosby 27
- Gaines 22
- Leon 21
- Mitchell 17
- Parmer 16
- Van Zandt 14
- Palo Pinto 13
- Harrison 12
- Bee 11
- Brooks 11
- McCulloch 11
- Madison 10
- Orange 9
- Pecos 9
- Callahan 8
- Duval 8
- Lavaca 8
- Andrews 7
- Calhoun 7
- Lamar 7
- Tyler 7
- Grimes 6
- Jasper 6
- Karnes 6
- Marion 6
- …
state 1
- Texas · 723 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502410 | 2502410 | 2022-05-13 | San Augustine | Texas | 48405 | 1082 | 44 |
2502445 | 2502445 | 2022-05-13 | Ward | Texas | 48475 | 2830 | 44 |
2499152 | 2499152 | 2022-05-12 | San Augustine | Texas | 48405 | 1081 | 44 |
2499187 | 2499187 | 2022-05-12 | Ward | Texas | 48475 | 2830 | 44 |
2495894 | 2495894 | 2022-05-11 | San Augustine | Texas | 48405 | 1081 | 44 |
2495929 | 2495929 | 2022-05-11 | Ward | Texas | 48475 | 2829 | 44 |
2492636 | 2492636 | 2022-05-10 | San Augustine | Texas | 48405 | 1078 | 44 |
2492671 | 2492671 | 2022-05-10 | Ward | Texas | 48475 | 2829 | 44 |
2489378 | 2489378 | 2022-05-09 | San Augustine | Texas | 48405 | 1077 | 44 |
2486120 | 2486120 | 2022-05-08 | San Augustine | Texas | 48405 | 1077 | 44 |
2482862 | 2482862 | 2022-05-07 | San Augustine | Texas | 48405 | 1077 | 44 |
2479604 | 2479604 | 2022-05-06 | San Augustine | Texas | 48405 | 1077 | 44 |
2476346 | 2476346 | 2022-05-05 | San Augustine | Texas | 48405 | 1077 | 44 |
2473089 | 2473089 | 2022-05-04 | San Augustine | Texas | 48405 | 1077 | 44 |
2469833 | 2469833 | 2022-05-03 | San Augustine | Texas | 48405 | 1077 | 44 |
2466577 | 2466577 | 2022-05-02 | San Augustine | Texas | 48405 | 1077 | 44 |
2463322 | 2463322 | 2022-05-01 | San Augustine | Texas | 48405 | 1077 | 44 |
2460066 | 2460066 | 2022-04-30 | San Augustine | Texas | 48405 | 1077 | 44 |
2456810 | 2456810 | 2022-04-29 | San Augustine | Texas | 48405 | 1076 | 44 |
2453554 | 2453554 | 2022-04-28 | San Augustine | Texas | 48405 | 1067 | 44 |
2450298 | 2450298 | 2022-04-27 | San Augustine | Texas | 48405 | 1067 | 44 |
2447041 | 2447041 | 2022-04-26 | San Augustine | Texas | 48405 | 1067 | 44 |
2443786 | 2443786 | 2022-04-25 | San Augustine | Texas | 48405 | 1067 | 44 |
2440530 | 2440530 | 2022-04-24 | San Augustine | Texas | 48405 | 1067 | 44 |
2437274 | 2437274 | 2022-04-23 | San Augustine | Texas | 48405 | 1066 | 44 |
2434018 | 2434018 | 2022-04-22 | San Augustine | Texas | 48405 | 1066 | 44 |
2430762 | 2430762 | 2022-04-21 | San Augustine | Texas | 48405 | 1066 | 44 |
2427506 | 2427506 | 2022-04-20 | San Augustine | Texas | 48405 | 1066 | 44 |
2424250 | 2424250 | 2022-04-19 | San Augustine | Texas | 48405 | 1066 | 44 |
2420994 | 2420994 | 2022-04-18 | San Augustine | Texas | 48405 | 1066 | 44 |
2417738 | 2417738 | 2022-04-17 | San Augustine | Texas | 48405 | 1066 | 44 |
2414482 | 2414482 | 2022-04-16 | San Augustine | Texas | 48405 | 1066 | 44 |
2411226 | 2411226 | 2022-04-15 | San Augustine | Texas | 48405 | 1066 | 44 |
2407970 | 2407970 | 2022-04-14 | San Augustine | Texas | 48405 | 1066 | 44 |
2404714 | 2404714 | 2022-04-13 | San Augustine | Texas | 48405 | 1066 | 44 |
2401459 | 2401459 | 2022-04-12 | San Augustine | Texas | 48405 | 1065 | 44 |
2398204 | 2398204 | 2022-04-11 | San Augustine | Texas | 48405 | 1065 | 44 |
2394949 | 2394949 | 2022-04-10 | San Augustine | Texas | 48405 | 1065 | 44 |
2391693 | 2391693 | 2022-04-09 | San Augustine | Texas | 48405 | 1065 | 44 |
2388437 | 2388437 | 2022-04-08 | San Augustine | Texas | 48405 | 1065 | 44 |
2385182 | 2385182 | 2022-04-07 | San Augustine | Texas | 48405 | 1065 | 44 |
2381927 | 2381927 | 2022-04-06 | San Augustine | Texas | 48405 | 1065 | 44 |
2268088 | 2268088 | 2022-03-02 | Stephens | Texas | 48429 | 1802 | 44 |
2264835 | 2264835 | 2022-03-01 | Stephens | Texas | 48429 | 1800 | 44 |
2261585 | 2261585 | 2022-02-28 | Stephens | Texas | 48429 | 1797 | 44 |
2258334 | 2258334 | 2022-02-27 | Stephens | Texas | 48429 | 1797 | 44 |
2255083 | 2255083 | 2022-02-26 | Stephens | Texas | 48429 | 1797 | 44 |
2251832 | 2251832 | 2022-02-25 | Stephens | Texas | 48429 | 1795 | 44 |
2242003 | 2242003 | 2022-02-22 | La Salle | Texas | 48283 | 2235 | 44 |
2238752 | 2238752 | 2022-02-21 | La Salle | Texas | 48283 | 2234 | 44 |
2238773 | 2238773 | 2022-02-21 | McCulloch | Texas | 48307 | 1253 | 44 |
2235501 | 2235501 | 2022-02-20 | La Salle | Texas | 48283 | 2217 | 44 |
2235522 | 2235522 | 2022-02-20 | McCulloch | Texas | 48307 | 1253 | 44 |
2232250 | 2232250 | 2022-02-19 | La Salle | Texas | 48283 | 2216 | 44 |
2232271 | 2232271 | 2022-02-19 | McCulloch | Texas | 48307 | 1253 | 44 |
2228999 | 2228999 | 2022-02-18 | La Salle | Texas | 48283 | 2207 | 44 |
2229020 | 2229020 | 2022-02-18 | McCulloch | Texas | 48307 | 1251 | 44 |
2225638 | 2225638 | 2022-02-17 | Calhoun | Texas | 48057 | 5567 | 44 |
2225769 | 2225769 | 2022-02-17 | McCulloch | Texas | 48307 | 1250 | 44 |
2222387 | 2222387 | 2022-02-16 | Calhoun | Texas | 48057 | 5555 | 44 |
2222412 | 2222412 | 2022-02-16 | Crosby | Texas | 48107 | 1820 | 44 |
2222518 | 2222518 | 2022-02-16 | McCulloch | Texas | 48307 | 1250 | 44 |
2219136 | 2219136 | 2022-02-15 | Calhoun | Texas | 48057 | 5548 | 44 |
2219161 | 2219161 | 2022-02-15 | Crosby | Texas | 48107 | 1818 | 44 |
2219267 | 2219267 | 2022-02-15 | McCulloch | Texas | 48307 | 1249 | 44 |
2215885 | 2215885 | 2022-02-14 | Calhoun | Texas | 48057 | 5546 | 44 |
2215910 | 2215910 | 2022-02-14 | Crosby | Texas | 48107 | 1818 | 44 |
2216016 | 2216016 | 2022-02-14 | McCulloch | Texas | 48307 | 1246 | 44 |
2212634 | 2212634 | 2022-02-13 | Calhoun | Texas | 48057 | 5543 | 44 |
2212659 | 2212659 | 2022-02-13 | Crosby | Texas | 48107 | 1818 | 44 |
2212765 | 2212765 | 2022-02-13 | McCulloch | Texas | 48307 | 1245 | 44 |
2209381 | 2209381 | 2022-02-12 | Calhoun | Texas | 48057 | 5538 | 44 |
2209406 | 2209406 | 2022-02-12 | Crosby | Texas | 48107 | 1817 | 44 |
2209512 | 2209512 | 2022-02-12 | McCulloch | Texas | 48307 | 1242 | 44 |
2206128 | 2206128 | 2022-02-11 | Calhoun | Texas | 48057 | 5525 | 44 |
2206153 | 2206153 | 2022-02-11 | Crosby | Texas | 48107 | 1815 | 44 |
2206259 | 2206259 | 2022-02-11 | McCulloch | Texas | 48307 | 1240 | 44 |
2202900 | 2202900 | 2022-02-10 | Crosby | Texas | 48107 | 1813 | 44 |
2199646 | 2199646 | 2022-02-09 | Crosby | Texas | 48107 | 1808 | 44 |
2196392 | 2196392 | 2022-02-08 | Crosby | Texas | 48107 | 1805 | 44 |
2193138 | 2193138 | 2022-02-07 | Crosby | Texas | 48107 | 1805 | 44 |
2189884 | 2189884 | 2022-02-06 | Crosby | Texas | 48107 | 1804 | 44 |
2186631 | 2186631 | 2022-02-05 | Crosby | Texas | 48107 | 1800 | 44 |
2183379 | 2183379 | 2022-02-04 | Crosby | Texas | 48107 | 1797 | 44 |
2180127 | 2180127 | 2022-02-03 | Crosby | Texas | 48107 | 1791 | 44 |
2176876 | 2176876 | 2022-02-02 | Crosby | Texas | 48107 | 1789 | 44 |
2173622 | 2173622 | 2022-02-01 | Crosby | Texas | 48107 | 1785 | 44 |
2173645 | 2173645 | 2022-02-01 | Floyd | Texas | 48153 | 1848 | 44 |
2170370 | 2170370 | 2022-01-31 | Crosby | Texas | 48107 | 1779 | 44 |
2170393 | 2170393 | 2022-01-31 | Floyd | Texas | 48153 | 1845 | 44 |
2167116 | 2167116 | 2022-01-30 | Crosby | Texas | 48107 | 1770 | 44 |
2167139 | 2167139 | 2022-01-30 | Floyd | Texas | 48153 | 1845 | 44 |
2163861 | 2163861 | 2022-01-29 | Crosby | Texas | 48107 | 1768 | 44 |
2160606 | 2160606 | 2022-01-28 | Crosby | Texas | 48107 | 1755 | 44 |
2157350 | 2157350 | 2022-01-27 | Crosby | Texas | 48107 | 1746 | 44 |
2154097 | 2154097 | 2022-01-26 | Crosby | Texas | 48107 | 1744 | 44 |
2150845 | 2150845 | 2022-01-25 | Crosby | Texas | 48107 | 1743 | 44 |
2147593 | 2147593 | 2022-01-24 | Crosby | Texas | 48107 | 1726 | 44 |
2144339 | 2144339 | 2022-01-23 | Crosby | Texas | 48107 | 1716 | 44 |
2141084 | 2141084 | 2022-01-22 | Crosby | Texas | 48107 | 1703 | 44 |
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);