ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
941 rows where deaths = 42 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Camp 69
- Duval 57
- Tyler 56
- Franklin 52
- Live Oak 48
- Leon 31
- Yoakum 26
- Polk 22
- Gaines 21
- La Salle 20
- Crosby 18
- McCulloch 17
- DeWitt 16
- Floyd 15
- Hood 15
- Ward 15
- Hardin 13
- Morris 13
- Parmer 13
- Potter 13
- Dimmit 12
- Burleson 10
- Eastland 10
- Madison 10
- Van Zandt 10
- Bosque 9
- Reeves 9
- San Augustine 9
- San Jacinto 8
- Zavala 8
- …
state 1
- Texas · 941 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502286 | 2502286 | 2022-05-13 | Franklin | Texas | 48159 | 2228 | 42 |
2502355 | 2502355 | 2022-05-13 | Live Oak | Texas | 48297 | 2153 | 42 |
2502458 | 2502458 | 2022-05-13 | Yoakum | Texas | 48501 | 1317 | 42 |
2499028 | 2499028 | 2022-05-12 | Franklin | Texas | 48159 | 2228 | 42 |
2499097 | 2499097 | 2022-05-12 | Live Oak | Texas | 48297 | 2153 | 42 |
2499200 | 2499200 | 2022-05-12 | Yoakum | Texas | 48501 | 1317 | 42 |
2495770 | 2495770 | 2022-05-11 | Franklin | Texas | 48159 | 2228 | 42 |
2495839 | 2495839 | 2022-05-11 | Live Oak | Texas | 48297 | 2153 | 42 |
2495942 | 2495942 | 2022-05-11 | Yoakum | Texas | 48501 | 1313 | 42 |
2492512 | 2492512 | 2022-05-10 | Franklin | Texas | 48159 | 2228 | 42 |
2492581 | 2492581 | 2022-05-10 | Live Oak | Texas | 48297 | 2152 | 42 |
2492684 | 2492684 | 2022-05-10 | Yoakum | Texas | 48501 | 1313 | 42 |
2489254 | 2489254 | 2022-05-09 | Franklin | Texas | 48159 | 2228 | 42 |
2489323 | 2489323 | 2022-05-09 | Live Oak | Texas | 48297 | 2152 | 42 |
2489426 | 2489426 | 2022-05-09 | Yoakum | Texas | 48501 | 1313 | 42 |
2485997 | 2485997 | 2022-05-08 | Franklin | Texas | 48159 | 2228 | 42 |
2486066 | 2486066 | 2022-05-08 | Live Oak | Texas | 48297 | 2152 | 42 |
2486168 | 2486168 | 2022-05-08 | Yoakum | Texas | 48501 | 1313 | 42 |
2482739 | 2482739 | 2022-05-07 | Franklin | Texas | 48159 | 2228 | 42 |
2482808 | 2482808 | 2022-05-07 | Live Oak | Texas | 48297 | 2152 | 42 |
2482910 | 2482910 | 2022-05-07 | Yoakum | Texas | 48501 | 1313 | 42 |
2479481 | 2479481 | 2022-05-06 | Franklin | Texas | 48159 | 2228 | 42 |
2479550 | 2479550 | 2022-05-06 | Live Oak | Texas | 48297 | 2151 | 42 |
2479652 | 2479652 | 2022-05-06 | Yoakum | Texas | 48501 | 1311 | 42 |
2476223 | 2476223 | 2022-05-05 | Franklin | Texas | 48159 | 2226 | 42 |
2476292 | 2476292 | 2022-05-05 | Live Oak | Texas | 48297 | 2151 | 42 |
2476394 | 2476394 | 2022-05-05 | Yoakum | Texas | 48501 | 1311 | 42 |
2472966 | 2472966 | 2022-05-04 | Franklin | Texas | 48159 | 2226 | 42 |
2473035 | 2473035 | 2022-05-04 | Live Oak | Texas | 48297 | 2151 | 42 |
2473137 | 2473137 | 2022-05-04 | Yoakum | Texas | 48501 | 1311 | 42 |
2469710 | 2469710 | 2022-05-03 | Franklin | Texas | 48159 | 2225 | 42 |
2469779 | 2469779 | 2022-05-03 | Live Oak | Texas | 48297 | 2151 | 42 |
2469881 | 2469881 | 2022-05-03 | Yoakum | Texas | 48501 | 1311 | 42 |
2466454 | 2466454 | 2022-05-02 | Franklin | Texas | 48159 | 2225 | 42 |
2466523 | 2466523 | 2022-05-02 | Live Oak | Texas | 48297 | 2150 | 42 |
2466625 | 2466625 | 2022-05-02 | Yoakum | Texas | 48501 | 1311 | 42 |
2463199 | 2463199 | 2022-05-01 | Franklin | Texas | 48159 | 2225 | 42 |
2463268 | 2463268 | 2022-05-01 | Live Oak | Texas | 48297 | 2149 | 42 |
2463370 | 2463370 | 2022-05-01 | Yoakum | Texas | 48501 | 1311 | 42 |
2459943 | 2459943 | 2022-04-30 | Franklin | Texas | 48159 | 2225 | 42 |
2460012 | 2460012 | 2022-04-30 | Live Oak | Texas | 48297 | 2149 | 42 |
2460114 | 2460114 | 2022-04-30 | Yoakum | Texas | 48501 | 1311 | 42 |
2456687 | 2456687 | 2022-04-29 | Franklin | Texas | 48159 | 2225 | 42 |
2456756 | 2456756 | 2022-04-29 | Live Oak | Texas | 48297 | 2145 | 42 |
2456858 | 2456858 | 2022-04-29 | Yoakum | Texas | 48501 | 1311 | 42 |
2453431 | 2453431 | 2022-04-28 | Franklin | Texas | 48159 | 2224 | 42 |
2453500 | 2453500 | 2022-04-28 | Live Oak | Texas | 48297 | 2144 | 42 |
2453602 | 2453602 | 2022-04-28 | Yoakum | Texas | 48501 | 1311 | 42 |
2450175 | 2450175 | 2022-04-27 | Franklin | Texas | 48159 | 2224 | 42 |
2450244 | 2450244 | 2022-04-27 | Live Oak | Texas | 48297 | 2143 | 42 |
2450346 | 2450346 | 2022-04-27 | Yoakum | Texas | 48501 | 1311 | 42 |
2446918 | 2446918 | 2022-04-26 | Franklin | Texas | 48159 | 2224 | 42 |
2446987 | 2446987 | 2022-04-26 | Live Oak | Texas | 48297 | 2143 | 42 |
2447089 | 2447089 | 2022-04-26 | Yoakum | Texas | 48501 | 1311 | 42 |
2443663 | 2443663 | 2022-04-25 | Franklin | Texas | 48159 | 2224 | 42 |
2443732 | 2443732 | 2022-04-25 | Live Oak | Texas | 48297 | 2142 | 42 |
2443834 | 2443834 | 2022-04-25 | Yoakum | Texas | 48501 | 1311 | 42 |
2440407 | 2440407 | 2022-04-24 | Franklin | Texas | 48159 | 2224 | 42 |
2440476 | 2440476 | 2022-04-24 | Live Oak | Texas | 48297 | 2142 | 42 |
2440578 | 2440578 | 2022-04-24 | Yoakum | Texas | 48501 | 1311 | 42 |
2437151 | 2437151 | 2022-04-23 | Franklin | Texas | 48159 | 2224 | 42 |
2437220 | 2437220 | 2022-04-23 | Live Oak | Texas | 48297 | 2142 | 42 |
2437322 | 2437322 | 2022-04-23 | Yoakum | Texas | 48501 | 1311 | 42 |
2433895 | 2433895 | 2022-04-22 | Franklin | Texas | 48159 | 2224 | 42 |
2433964 | 2433964 | 2022-04-22 | Live Oak | Texas | 48297 | 2141 | 42 |
2434066 | 2434066 | 2022-04-22 | Yoakum | Texas | 48501 | 1311 | 42 |
2430639 | 2430639 | 2022-04-21 | Franklin | Texas | 48159 | 2222 | 42 |
2430708 | 2430708 | 2022-04-21 | Live Oak | Texas | 48297 | 2141 | 42 |
2430810 | 2430810 | 2022-04-21 | Yoakum | Texas | 48501 | 1311 | 42 |
2427383 | 2427383 | 2022-04-20 | Franklin | Texas | 48159 | 2215 | 42 |
2427452 | 2427452 | 2022-04-20 | Live Oak | Texas | 48297 | 2141 | 42 |
2427554 | 2427554 | 2022-04-20 | Yoakum | Texas | 48501 | 1311 | 42 |
2424127 | 2424127 | 2022-04-19 | Franklin | Texas | 48159 | 2203 | 42 |
2424196 | 2424196 | 2022-04-19 | Live Oak | Texas | 48297 | 2141 | 42 |
2424298 | 2424298 | 2022-04-19 | Yoakum | Texas | 48501 | 1311 | 42 |
2420871 | 2420871 | 2022-04-18 | Franklin | Texas | 48159 | 2198 | 42 |
2420940 | 2420940 | 2022-04-18 | Live Oak | Texas | 48297 | 2141 | 42 |
2421042 | 2421042 | 2022-04-18 | Yoakum | Texas | 48501 | 1311 | 42 |
2417615 | 2417615 | 2022-04-17 | Franklin | Texas | 48159 | 2196 | 42 |
2417684 | 2417684 | 2022-04-17 | Live Oak | Texas | 48297 | 2141 | 42 |
2414359 | 2414359 | 2022-04-16 | Franklin | Texas | 48159 | 2196 | 42 |
2414428 | 2414428 | 2022-04-16 | Live Oak | Texas | 48297 | 2141 | 42 |
2411103 | 2411103 | 2022-04-15 | Franklin | Texas | 48159 | 2196 | 42 |
2411172 | 2411172 | 2022-04-15 | Live Oak | Texas | 48297 | 2141 | 42 |
2407847 | 2407847 | 2022-04-14 | Franklin | Texas | 48159 | 2196 | 42 |
2407916 | 2407916 | 2022-04-14 | Live Oak | Texas | 48297 | 2141 | 42 |
2404591 | 2404591 | 2022-04-13 | Franklin | Texas | 48159 | 2196 | 42 |
2404660 | 2404660 | 2022-04-13 | Live Oak | Texas | 48297 | 2141 | 42 |
2401336 | 2401336 | 2022-04-12 | Franklin | Texas | 48159 | 2196 | 42 |
2401405 | 2401405 | 2022-04-12 | Live Oak | Texas | 48297 | 2141 | 42 |
2398081 | 2398081 | 2022-04-11 | Franklin | Texas | 48159 | 2186 | 42 |
2398150 | 2398150 | 2022-04-11 | Live Oak | Texas | 48297 | 2141 | 42 |
2394826 | 2394826 | 2022-04-10 | Franklin | Texas | 48159 | 2186 | 42 |
2394895 | 2394895 | 2022-04-10 | Live Oak | Texas | 48297 | 2141 | 42 |
2391570 | 2391570 | 2022-04-09 | Franklin | Texas | 48159 | 2186 | 42 |
2391639 | 2391639 | 2022-04-09 | Live Oak | Texas | 48297 | 2141 | 42 |
2388314 | 2388314 | 2022-04-08 | Franklin | Texas | 48159 | 2186 | 42 |
2388383 | 2388383 | 2022-04-08 | Live Oak | Texas | 48297 | 2141 | 42 |
2385059 | 2385059 | 2022-04-07 | Franklin | Texas | 48159 | 2174 | 42 |
2385128 | 2385128 | 2022-04-07 | Live Oak | Texas | 48297 | 2141 | 42 |
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);