ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
338 rows where deaths = 104 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Titus 49
- Scurry 25
- Fayette 20
- Hill 19
- Hockley 17
- Moore 15
- Howard 11
- Kendall 10
- Victoria 9
- Limestone 8
- Rusk 8
- Washington 8
- Harrison 7
- Palo Pinto 7
- Hardin 6
- Medina 6
- Bastrop 5
- Bell 5
- Gillespie 5
- Hutchinson 5
- Lamb 5
- Montague 5
- Panola 5
- Val Verde 5
- Anderson 3
- Matagorda 3
- Navarro 3
- Travis 3
- Willacy 3
- Bexar 2
- …
state 1
- Texas · 338 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502415 | 2502415 | 2022-05-13 | Scurry | Texas | 48415 | 4983 | 104 |
2499157 | 2499157 | 2022-05-12 | Scurry | Texas | 48415 | 4977 | 104 |
2495899 | 2495899 | 2022-05-11 | Scurry | Texas | 48415 | 4977 | 104 |
2492641 | 2492641 | 2022-05-10 | Scurry | Texas | 48415 | 4977 | 104 |
2489383 | 2489383 | 2022-05-09 | Scurry | Texas | 48415 | 4977 | 104 |
2486125 | 2486125 | 2022-05-08 | Scurry | Texas | 48415 | 4977 | 104 |
2482867 | 2482867 | 2022-05-07 | Scurry | Texas | 48415 | 4977 | 104 |
2479609 | 2479609 | 2022-05-06 | Scurry | Texas | 48415 | 4977 | 104 |
2476351 | 2476351 | 2022-05-05 | Scurry | Texas | 48415 | 4977 | 104 |
2473094 | 2473094 | 2022-05-04 | Scurry | Texas | 48415 | 4977 | 104 |
2469838 | 2469838 | 2022-05-03 | Scurry | Texas | 48415 | 4977 | 104 |
2466582 | 2466582 | 2022-05-02 | Scurry | Texas | 48415 | 4977 | 104 |
2463327 | 2463327 | 2022-05-01 | Scurry | Texas | 48415 | 4977 | 104 |
2460071 | 2460071 | 2022-04-30 | Scurry | Texas | 48415 | 4976 | 104 |
2456815 | 2456815 | 2022-04-29 | Scurry | Texas | 48415 | 4976 | 104 |
2453559 | 2453559 | 2022-04-28 | Scurry | Texas | 48415 | 4975 | 104 |
2450303 | 2450303 | 2022-04-27 | Scurry | Texas | 48415 | 4975 | 104 |
2447046 | 2447046 | 2022-04-26 | Scurry | Texas | 48415 | 4975 | 104 |
2443791 | 2443791 | 2022-04-25 | Scurry | Texas | 48415 | 4975 | 104 |
2440535 | 2440535 | 2022-04-24 | Scurry | Texas | 48415 | 4975 | 104 |
2437279 | 2437279 | 2022-04-23 | Scurry | Texas | 48415 | 4975 | 104 |
2434023 | 2434023 | 2022-04-22 | Scurry | Texas | 48415 | 4974 | 104 |
2430767 | 2430767 | 2022-04-21 | Scurry | Texas | 48415 | 4974 | 104 |
2427511 | 2427511 | 2022-04-20 | Scurry | Texas | 48415 | 4974 | 104 |
2424255 | 2424255 | 2022-04-19 | Scurry | Texas | 48415 | 4973 | 104 |
2398076 | 2398076 | 2022-04-11 | Fayette | Texas | 48149 | 4767 | 104 |
2394821 | 2394821 | 2022-04-10 | Fayette | Texas | 48149 | 4767 | 104 |
2391565 | 2391565 | 2022-04-09 | Fayette | Texas | 48149 | 4767 | 104 |
2388309 | 2388309 | 2022-04-08 | Fayette | Texas | 48149 | 4767 | 104 |
2385054 | 2385054 | 2022-04-07 | Fayette | Texas | 48149 | 4766 | 104 |
2381799 | 2381799 | 2022-04-06 | Fayette | Texas | 48149 | 4766 | 104 |
2378544 | 2378544 | 2022-04-05 | Fayette | Texas | 48149 | 4765 | 104 |
2375290 | 2375290 | 2022-04-04 | Fayette | Texas | 48149 | 4764 | 104 |
2372038 | 2372038 | 2022-04-03 | Fayette | Texas | 48149 | 4763 | 104 |
2368785 | 2368785 | 2022-04-02 | Fayette | Texas | 48149 | 4763 | 104 |
2365532 | 2365532 | 2022-04-01 | Fayette | Texas | 48149 | 4760 | 104 |
2362279 | 2362279 | 2022-03-31 | Fayette | Texas | 48149 | 4760 | 104 |
2359025 | 2359025 | 2022-03-30 | Fayette | Texas | 48149 | 4758 | 104 |
2355771 | 2355771 | 2022-03-29 | Fayette | Texas | 48149 | 4757 | 104 |
2352518 | 2352518 | 2022-03-28 | Fayette | Texas | 48149 | 4756 | 104 |
2349266 | 2349266 | 2022-03-27 | Fayette | Texas | 48149 | 4756 | 104 |
2346013 | 2346013 | 2022-03-26 | Fayette | Texas | 48149 | 4756 | 104 |
2342760 | 2342760 | 2022-03-25 | Fayette | Texas | 48149 | 4755 | 104 |
2339507 | 2339507 | 2022-03-24 | Fayette | Texas | 48149 | 4755 | 104 |
2336253 | 2336253 | 2022-03-23 | Fayette | Texas | 48149 | 4755 | 104 |
2316895 | 2316895 | 2022-03-17 | Waller | Texas | 48473 | 9409 | 104 |
2313642 | 2313642 | 2022-03-16 | Waller | Texas | 48473 | 9400 | 104 |
2248452 | 2248452 | 2022-02-24 | Gillespie | Texas | 48171 | 5220 | 104 |
2235448 | 2235448 | 2022-02-20 | Gillespie | Texas | 48171 | 5175 | 104 |
2232197 | 2232197 | 2022-02-19 | Gillespie | Texas | 48171 | 5175 | 104 |
2228927 | 2228927 | 2022-02-18 | Eastland | Texas | 48133 | 2734 | 104 |
2228946 | 2228946 | 2022-02-18 | Gillespie | Texas | 48171 | 5164 | 104 |
2225695 | 2225695 | 2022-02-17 | Gillespie | Texas | 48171 | 5159 | 104 |
2206270 | 2206270 | 2022-02-11 | Moore | Texas | 48341 | 5209 | 104 |
2203017 | 2203017 | 2022-02-10 | Moore | Texas | 48341 | 5185 | 104 |
2199763 | 2199763 | 2022-02-09 | Moore | Texas | 48341 | 5166 | 104 |
2196509 | 2196509 | 2022-02-08 | Moore | Texas | 48341 | 5163 | 104 |
2193255 | 2193255 | 2022-02-07 | Moore | Texas | 48341 | 5148 | 104 |
2190001 | 2190001 | 2022-02-06 | Moore | Texas | 48341 | 5143 | 104 |
2186748 | 2186748 | 2022-02-05 | Moore | Texas | 48341 | 5142 | 104 |
2183496 | 2183496 | 2022-02-04 | Moore | Texas | 48341 | 5137 | 104 |
2180244 | 2180244 | 2022-02-03 | Moore | Texas | 48341 | 5128 | 104 |
2176963 | 2176963 | 2022-02-02 | Lamb | Texas | 48279 | 4189 | 104 |
2176993 | 2176993 | 2022-02-02 | Moore | Texas | 48341 | 5094 | 104 |
2173709 | 2173709 | 2022-02-01 | Lamb | Texas | 48279 | 4184 | 104 |
2173739 | 2173739 | 2022-02-01 | Moore | Texas | 48341 | 5065 | 104 |
2170457 | 2170457 | 2022-01-31 | Lamb | Texas | 48279 | 4180 | 104 |
2170487 | 2170487 | 2022-01-31 | Moore | Texas | 48341 | 5042 | 104 |
2167203 | 2167203 | 2022-01-30 | Lamb | Texas | 48279 | 4179 | 104 |
2167233 | 2167233 | 2022-01-30 | Moore | Texas | 48341 | 5037 | 104 |
2163948 | 2163948 | 2022-01-29 | Lamb | Texas | 48279 | 4172 | 104 |
2163978 | 2163978 | 2022-01-29 | Moore | Texas | 48341 | 5033 | 104 |
2160695 | 2160695 | 2022-01-28 | Lavaca | Texas | 48285 | 3991 | 104 |
2160723 | 2160723 | 2022-01-28 | Moore | Texas | 48341 | 4984 | 104 |
2157356 | 2157356 | 2022-01-27 | Deaf Smith | Texas | 48117 | 4021 | 104 |
2154103 | 2154103 | 2022-01-26 | Deaf Smith | Texas | 48117 | 4004 | 104 |
2147669 | 2147669 | 2022-01-24 | Kendall | Texas | 48259 | 7096 | 104 |
2144415 | 2144415 | 2022-01-23 | Kendall | Texas | 48259 | 7044 | 104 |
2141160 | 2141160 | 2022-01-22 | Kendall | Texas | 48259 | 6967 | 104 |
2137904 | 2137904 | 2022-01-21 | Kendall | Texas | 48259 | 6887 | 104 |
2134650 | 2134650 | 2022-01-20 | Kendall | Texas | 48259 | 6804 | 104 |
2131398 | 2131398 | 2022-01-19 | Kendall | Texas | 48259 | 6761 | 104 |
2128144 | 2128144 | 2022-01-18 | Kendall | Texas | 48259 | 6713 | 104 |
2124892 | 2124892 | 2022-01-17 | Kendall | Texas | 48259 | 6670 | 104 |
2124931 | 2124931 | 2022-01-17 | Montague | Texas | 48337 | 3884 | 104 |
2121640 | 2121640 | 2022-01-16 | Kendall | Texas | 48259 | 6590 | 104 |
2121679 | 2121679 | 2022-01-16 | Montague | Texas | 48337 | 3774 | 104 |
2118388 | 2118388 | 2022-01-15 | Kendall | Texas | 48259 | 6559 | 104 |
2118427 | 2118427 | 2022-01-15 | Montague | Texas | 48337 | 3735 | 104 |
2115176 | 2115176 | 2022-01-14 | Montague | Texas | 48337 | 3674 | 104 |
2111845 | 2111845 | 2022-01-13 | Gray | Texas | 48179 | 4692 | 104 |
2111924 | 2111924 | 2022-01-13 | Montague | Texas | 48337 | 3567 | 104 |
2053354 | 2053354 | 2021-12-26 | Hutchinson | Texas | 48233 | 4320 | 104 |
2050104 | 2050104 | 2021-12-25 | Hutchinson | Texas | 48233 | 4320 | 104 |
2046854 | 2046854 | 2021-12-24 | Hutchinson | Texas | 48233 | 4320 | 104 |
2043604 | 2043604 | 2021-12-23 | Hutchinson | Texas | 48233 | 4320 | 104 |
2040355 | 2040355 | 2021-12-22 | Hutchinson | Texas | 48233 | 4312 | 104 |
2037213 | 2037213 | 2021-12-21 | Titus | Texas | 48449 | 6056 | 104 |
2033963 | 2033963 | 2021-12-20 | Titus | Texas | 48449 | 6044 | 104 |
2030713 | 2030713 | 2021-12-19 | Titus | Texas | 48449 | 6042 | 104 |
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);