ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
313 rows where deaths = 97 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Llano 67
- Victoria 19
- Gonzales 17
- Caldwell 15
- Kleberg 13
- Lamb 13
- Chambers 12
- Milam 10
- Matagorda 9
- Grimes 8
- Angelina 7
- Jim Wells 6
- Moore 6
- Waller 6
- Hockley 5
- Jasper 5
- Medina 5
- Panola 5
- San Patricio 5
- Eastland 4
- Montague 4
- Palo Pinto 4
- Bowie 3
- Kendall 3
- Kerr 3
- Lavaca 3
- McLennan 3
- Nacogdoches 3
- Nolan 3
- Titus 3
- …
state 1
- Texas · 313 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502356 | 2502356 | 2022-05-13 | Llano | Texas | 48299 | 3933 | 97 |
2499098 | 2499098 | 2022-05-12 | Llano | Texas | 48299 | 3933 | 97 |
2495840 | 2495840 | 2022-05-11 | Llano | Texas | 48299 | 3930 | 97 |
2492582 | 2492582 | 2022-05-10 | Llano | Texas | 48299 | 3928 | 97 |
2489324 | 2489324 | 2022-05-09 | Llano | Texas | 48299 | 3926 | 97 |
2486067 | 2486067 | 2022-05-08 | Llano | Texas | 48299 | 3926 | 97 |
2482809 | 2482809 | 2022-05-07 | Llano | Texas | 48299 | 3922 | 97 |
2479551 | 2479551 | 2022-05-06 | Llano | Texas | 48299 | 3916 | 97 |
2476293 | 2476293 | 2022-05-05 | Llano | Texas | 48299 | 3915 | 97 |
2473036 | 2473036 | 2022-05-04 | Llano | Texas | 48299 | 3914 | 97 |
2469780 | 2469780 | 2022-05-03 | Llano | Texas | 48299 | 3913 | 97 |
2466524 | 2466524 | 2022-05-02 | Llano | Texas | 48299 | 3913 | 97 |
2463269 | 2463269 | 2022-05-01 | Llano | Texas | 48299 | 3912 | 97 |
2460013 | 2460013 | 2022-04-30 | Llano | Texas | 48299 | 3908 | 97 |
2456757 | 2456757 | 2022-04-29 | Llano | Texas | 48299 | 3908 | 97 |
2453501 | 2453501 | 2022-04-28 | Llano | Texas | 48299 | 3908 | 97 |
2450245 | 2450245 | 2022-04-27 | Llano | Texas | 48299 | 3908 | 97 |
2446988 | 2446988 | 2022-04-26 | Llano | Texas | 48299 | 3906 | 97 |
2443733 | 2443733 | 2022-04-25 | Llano | Texas | 48299 | 3905 | 97 |
2440477 | 2440477 | 2022-04-24 | Llano | Texas | 48299 | 3905 | 97 |
2437221 | 2437221 | 2022-04-23 | Llano | Texas | 48299 | 3905 | 97 |
2433965 | 2433965 | 2022-04-22 | Llano | Texas | 48299 | 3905 | 97 |
2430709 | 2430709 | 2022-04-21 | Llano | Texas | 48299 | 3905 | 97 |
2427453 | 2427453 | 2022-04-20 | Llano | Texas | 48299 | 3905 | 97 |
2424197 | 2424197 | 2022-04-19 | Llano | Texas | 48299 | 3905 | 97 |
2420941 | 2420941 | 2022-04-18 | Llano | Texas | 48299 | 3903 | 97 |
2417685 | 2417685 | 2022-04-17 | Llano | Texas | 48299 | 3901 | 97 |
2414429 | 2414429 | 2022-04-16 | Llano | Texas | 48299 | 3901 | 97 |
2411173 | 2411173 | 2022-04-15 | Llano | Texas | 48299 | 3901 | 97 |
2407917 | 2407917 | 2022-04-14 | Llano | Texas | 48299 | 3901 | 97 |
2404661 | 2404661 | 2022-04-13 | Llano | Texas | 48299 | 3900 | 97 |
2401406 | 2401406 | 2022-04-12 | Llano | Texas | 48299 | 3900 | 97 |
2398151 | 2398151 | 2022-04-11 | Llano | Texas | 48299 | 3900 | 97 |
2394896 | 2394896 | 2022-04-10 | Llano | Texas | 48299 | 3900 | 97 |
2391640 | 2391640 | 2022-04-09 | Llano | Texas | 48299 | 3900 | 97 |
2388323 | 2388323 | 2022-04-08 | Gonzales | Texas | 48177 | 4720 | 97 |
2388384 | 2388384 | 2022-04-08 | Llano | Texas | 48299 | 3900 | 97 |
2385068 | 2385068 | 2022-04-07 | Gonzales | Texas | 48177 | 4720 | 97 |
2385129 | 2385129 | 2022-04-07 | Llano | Texas | 48299 | 3900 | 97 |
2381813 | 2381813 | 2022-04-06 | Gonzales | Texas | 48177 | 4720 | 97 |
2381874 | 2381874 | 2022-04-06 | Llano | Texas | 48299 | 3900 | 97 |
2378558 | 2378558 | 2022-04-05 | Gonzales | Texas | 48177 | 4720 | 97 |
2378619 | 2378619 | 2022-04-05 | Llano | Texas | 48299 | 3900 | 97 |
2375304 | 2375304 | 2022-04-04 | Gonzales | Texas | 48177 | 4720 | 97 |
2375365 | 2375365 | 2022-04-04 | Llano | Texas | 48299 | 3900 | 97 |
2372052 | 2372052 | 2022-04-03 | Gonzales | Texas | 48177 | 4720 | 97 |
2372113 | 2372113 | 2022-04-03 | Llano | Texas | 48299 | 3899 | 97 |
2368799 | 2368799 | 2022-04-02 | Gonzales | Texas | 48177 | 4720 | 97 |
2368860 | 2368860 | 2022-04-02 | Llano | Texas | 48299 | 3897 | 97 |
2365546 | 2365546 | 2022-04-01 | Gonzales | Texas | 48177 | 4720 | 97 |
2365607 | 2365607 | 2022-04-01 | Llano | Texas | 48299 | 3890 | 97 |
2362293 | 2362293 | 2022-03-31 | Gonzales | Texas | 48177 | 4720 | 97 |
2362354 | 2362354 | 2022-03-31 | Llano | Texas | 48299 | 3889 | 97 |
2359039 | 2359039 | 2022-03-30 | Gonzales | Texas | 48177 | 4719 | 97 |
2359100 | 2359100 | 2022-03-30 | Llano | Texas | 48299 | 3888 | 97 |
2355785 | 2355785 | 2022-03-29 | Gonzales | Texas | 48177 | 4719 | 97 |
2355846 | 2355846 | 2022-03-29 | Llano | Texas | 48299 | 3885 | 97 |
2352532 | 2352532 | 2022-03-28 | Gonzales | Texas | 48177 | 4719 | 97 |
2352593 | 2352593 | 2022-03-28 | Llano | Texas | 48299 | 3876 | 97 |
2349280 | 2349280 | 2022-03-27 | Gonzales | Texas | 48177 | 4719 | 97 |
2349341 | 2349341 | 2022-03-27 | Llano | Texas | 48299 | 3876 | 97 |
2346027 | 2346027 | 2022-03-26 | Gonzales | Texas | 48177 | 4719 | 97 |
2346088 | 2346088 | 2022-03-26 | Llano | Texas | 48299 | 3875 | 97 |
2342774 | 2342774 | 2022-03-25 | Gonzales | Texas | 48177 | 4718 | 97 |
2342835 | 2342835 | 2022-03-25 | Llano | Texas | 48299 | 3871 | 97 |
2339521 | 2339521 | 2022-03-24 | Gonzales | Texas | 48177 | 4717 | 97 |
2339582 | 2339582 | 2022-03-24 | Llano | Texas | 48299 | 3871 | 97 |
2336267 | 2336267 | 2022-03-23 | Gonzales | Texas | 48177 | 4714 | 97 |
2336328 | 2336328 | 2022-03-23 | Llano | Texas | 48299 | 3871 | 97 |
2333074 | 2333074 | 2022-03-22 | Llano | Texas | 48299 | 3866 | 97 |
2329821 | 2329821 | 2022-03-21 | Llano | Texas | 48299 | 3866 | 97 |
2326569 | 2326569 | 2022-03-20 | Llano | Texas | 48299 | 3866 | 97 |
2323316 | 2323316 | 2022-03-19 | Llano | Texas | 48299 | 3865 | 97 |
2320062 | 2320062 | 2022-03-18 | Llano | Texas | 48299 | 3865 | 97 |
2316808 | 2316808 | 2022-03-17 | Llano | Texas | 48299 | 3864 | 97 |
2313555 | 2313555 | 2022-03-16 | Llano | Texas | 48299 | 3863 | 97 |
2310211 | 2310211 | 2022-03-15 | DeWitt | Texas | 48123 | 6431 | 97 |
2310302 | 2310302 | 2022-03-15 | Llano | Texas | 48299 | 3862 | 97 |
2307049 | 2307049 | 2022-03-14 | Llano | Texas | 48299 | 3860 | 97 |
2303798 | 2303798 | 2022-03-13 | Llano | Texas | 48299 | 3860 | 97 |
2300546 | 2300546 | 2022-03-12 | Llano | Texas | 48299 | 3860 | 97 |
2297294 | 2297294 | 2022-03-11 | Llano | Texas | 48299 | 3860 | 97 |
2294042 | 2294042 | 2022-03-10 | Llano | Texas | 48299 | 3858 | 97 |
2294069 | 2294069 | 2022-03-10 | Nolan | Texas | 48353 | 3051 | 97 |
2290790 | 2290790 | 2022-03-09 | Llano | Texas | 48299 | 3857 | 97 |
2290817 | 2290817 | 2022-03-09 | Nolan | Texas | 48353 | 3050 | 97 |
2287538 | 2287538 | 2022-03-08 | Llano | Texas | 48299 | 3856 | 97 |
2287565 | 2287565 | 2022-03-08 | Nolan | Texas | 48353 | 3050 | 97 |
2242030 | 2242030 | 2022-02-22 | Milam | Texas | 48331 | 4876 | 97 |
2238779 | 2238779 | 2022-02-21 | Milam | Texas | 48331 | 4872 | 97 |
2235528 | 2235528 | 2022-02-20 | Milam | Texas | 48331 | 4872 | 97 |
2232277 | 2232277 | 2022-02-19 | Milam | Texas | 48331 | 4869 | 97 |
2229026 | 2229026 | 2022-02-18 | Milam | Texas | 48331 | 4866 | 97 |
2225775 | 2225775 | 2022-02-17 | Milam | Texas | 48331 | 4865 | 97 |
2222524 | 2222524 | 2022-02-16 | Milam | Texas | 48331 | 4858 | 97 |
2219273 | 2219273 | 2022-02-15 | Milam | Texas | 48331 | 4857 | 97 |
2216022 | 2216022 | 2022-02-14 | Milam | Texas | 48331 | 4854 | 97 |
2216060 | 2216060 | 2022-02-14 | San Jacinto | Texas | 48407 | 5219 | 97 |
2212771 | 2212771 | 2022-02-13 | Milam | Texas | 48331 | 4850 | 97 |
2212809 | 2212809 | 2022-02-13 | San Jacinto | Texas | 48407 | 5215 | 97 |
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);