ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
339 rows where deaths = 92 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jones 33
- Gonzales 22
- Willacy 21
- Kerr 20
- Jasper 16
- Caldwell 15
- Fayette 13
- Moore 12
- Dawson 10
- Washington 10
- Frio 8
- Bastrop 7
- Scurry 7
- DeWitt 6
- Ector 5
- Guadalupe 5
- Jim Wells 5
- Llano 5
- Nacogdoches 5
- Shelby 5
- Hutchinson 4
- Lavaca 4
- Palo Pinto 4
- Potter 4
- Val Verde 4
- Angelina 3
- Bell 3
- Grayson 3
- Kleberg 3
- Maverick 3
- …
state 1
- Texas · 339 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424174 | 2424174 | 2022-04-19 | Jones | Texas | 48253 | 4592 | 92 |
2420918 | 2420918 | 2022-04-18 | Jones | Texas | 48253 | 4592 | 92 |
2417662 | 2417662 | 2022-04-17 | Jones | Texas | 48253 | 4589 | 92 |
2414406 | 2414406 | 2022-04-16 | Jones | Texas | 48253 | 4589 | 92 |
2411150 | 2411150 | 2022-04-15 | Jones | Texas | 48253 | 4589 | 92 |
2407894 | 2407894 | 2022-04-14 | Jones | Texas | 48253 | 4589 | 92 |
2404638 | 2404638 | 2022-04-13 | Jones | Texas | 48253 | 4587 | 92 |
2401383 | 2401383 | 2022-04-12 | Jones | Texas | 48253 | 4587 | 92 |
2398128 | 2398128 | 2022-04-11 | Jones | Texas | 48253 | 4587 | 92 |
2394873 | 2394873 | 2022-04-10 | Jones | Texas | 48253 | 4587 | 92 |
2391617 | 2391617 | 2022-04-09 | Jones | Texas | 48253 | 4586 | 92 |
2388361 | 2388361 | 2022-04-08 | Jones | Texas | 48253 | 4585 | 92 |
2388486 | 2388486 | 2022-04-08 | Young | Texas | 48503 | 3912 | 92 |
2385106 | 2385106 | 2022-04-07 | Jones | Texas | 48253 | 4583 | 92 |
2385231 | 2385231 | 2022-04-07 | Young | Texas | 48503 | 3909 | 92 |
2381851 | 2381851 | 2022-04-06 | Jones | Texas | 48253 | 4583 | 92 |
2378596 | 2378596 | 2022-04-05 | Jones | Texas | 48253 | 4583 | 92 |
2375342 | 2375342 | 2022-04-04 | Jones | Texas | 48253 | 4583 | 92 |
2372090 | 2372090 | 2022-04-03 | Jones | Texas | 48253 | 4583 | 92 |
2368837 | 2368837 | 2022-04-02 | Jones | Texas | 48253 | 4577 | 92 |
2365584 | 2365584 | 2022-04-01 | Jones | Texas | 48253 | 4577 | 92 |
2362331 | 2362331 | 2022-03-31 | Jones | Texas | 48253 | 4574 | 92 |
2359077 | 2359077 | 2022-03-30 | Jones | Texas | 48253 | 4560 | 92 |
2355823 | 2355823 | 2022-03-29 | Jones | Texas | 48253 | 4552 | 92 |
2352570 | 2352570 | 2022-03-28 | Jones | Texas | 48253 | 4549 | 92 |
2349318 | 2349318 | 2022-03-27 | Jones | Texas | 48253 | 4542 | 92 |
2346065 | 2346065 | 2022-03-26 | Jones | Texas | 48253 | 4542 | 92 |
2342812 | 2342812 | 2022-03-25 | Jones | Texas | 48253 | 4540 | 92 |
2339559 | 2339559 | 2022-03-24 | Jones | Texas | 48253 | 4533 | 92 |
2336305 | 2336305 | 2022-03-23 | Jones | Texas | 48253 | 4530 | 92 |
2333051 | 2333051 | 2022-03-22 | Jones | Texas | 48253 | 4528 | 92 |
2329798 | 2329798 | 2022-03-21 | Jones | Texas | 48253 | 4528 | 92 |
2326546 | 2326546 | 2022-03-20 | Jones | Texas | 48253 | 4527 | 92 |
2323248 | 2323248 | 2022-03-19 | Frio | Texas | 48163 | 5747 | 92 |
2323293 | 2323293 | 2022-03-19 | Jones | Texas | 48253 | 4527 | 92 |
2319994 | 2319994 | 2022-03-18 | Frio | Texas | 48163 | 5737 | 92 |
2320039 | 2320039 | 2022-03-18 | Jones | Texas | 48253 | 4527 | 92 |
2320057 | 2320057 | 2022-03-18 | Leon | Texas | 48289 | 3701 | 92 |
2316740 | 2316740 | 2022-03-17 | Frio | Texas | 48163 | 5732 | 92 |
2316803 | 2316803 | 2022-03-17 | Leon | Texas | 48289 | 3700 | 92 |
2313487 | 2313487 | 2022-03-16 | Frio | Texas | 48163 | 5727 | 92 |
2310234 | 2310234 | 2022-03-15 | Frio | Texas | 48163 | 5725 | 92 |
2306981 | 2306981 | 2022-03-14 | Frio | Texas | 48163 | 5706 | 92 |
2303730 | 2303730 | 2022-03-13 | Frio | Texas | 48163 | 5706 | 92 |
2300478 | 2300478 | 2022-03-12 | Frio | Texas | 48163 | 5698 | 92 |
2255018 | 2255018 | 2022-02-26 | Llano | Texas | 48299 | 3839 | 92 |
2251767 | 2251767 | 2022-02-25 | Llano | Texas | 48299 | 3838 | 92 |
2248516 | 2248516 | 2022-02-24 | Llano | Texas | 48299 | 3835 | 92 |
2245265 | 2245265 | 2022-02-23 | Llano | Texas | 48299 | 3833 | 92 |
2242014 | 2242014 | 2022-02-22 | Llano | Texas | 48299 | 3830 | 92 |
2225667 | 2225667 | 2022-02-17 | Dawson | Texas | 48115 | 2663 | 92 |
2225786 | 2225786 | 2022-02-17 | Nolan | Texas | 48353 | 3034 | 92 |
2222416 | 2222416 | 2022-02-16 | Dawson | Texas | 48115 | 2625 | 92 |
2222417 | 2222417 | 2022-02-16 | DeWitt | Texas | 48123 | 6373 | 92 |
2222535 | 2222535 | 2022-02-16 | Nolan | Texas | 48353 | 3019 | 92 |
2219165 | 2219165 | 2022-02-15 | Dawson | Texas | 48115 | 2571 | 92 |
2219166 | 2219166 | 2022-02-15 | DeWitt | Texas | 48123 | 6370 | 92 |
2215914 | 2215914 | 2022-02-14 | Dawson | Texas | 48115 | 2533 | 92 |
2215915 | 2215915 | 2022-02-14 | DeWitt | Texas | 48123 | 6370 | 92 |
2212663 | 2212663 | 2022-02-13 | Dawson | Texas | 48115 | 2532 | 92 |
2212664 | 2212664 | 2022-02-13 | DeWitt | Texas | 48123 | 6366 | 92 |
2209410 | 2209410 | 2022-02-12 | Dawson | Texas | 48115 | 2531 | 92 |
2209411 | 2209411 | 2022-02-12 | DeWitt | Texas | 48123 | 6362 | 92 |
2206157 | 2206157 | 2022-02-11 | Dawson | Texas | 48115 | 2531 | 92 |
2206158 | 2206158 | 2022-02-11 | DeWitt | Texas | 48123 | 6356 | 92 |
2202904 | 2202904 | 2022-02-10 | Dawson | Texas | 48115 | 2531 | 92 |
2199650 | 2199650 | 2022-02-09 | Dawson | Texas | 48115 | 2530 | 92 |
2196396 | 2196396 | 2022-02-08 | Dawson | Texas | 48115 | 2476 | 92 |
2196427 | 2196427 | 2022-02-08 | Gonzales | Texas | 48177 | 4623 | 92 |
2193173 | 2193173 | 2022-02-07 | Gonzales | Texas | 48177 | 4620 | 92 |
2193288 | 2193288 | 2022-02-07 | San Jacinto | Texas | 48407 | 5148 | 92 |
2189919 | 2189919 | 2022-02-06 | Gonzales | Texas | 48177 | 4618 | 92 |
2190034 | 2190034 | 2022-02-06 | San Jacinto | Texas | 48407 | 5139 | 92 |
2186666 | 2186666 | 2022-02-05 | Gonzales | Texas | 48177 | 4611 | 92 |
2186781 | 2186781 | 2022-02-05 | San Jacinto | Texas | 48407 | 5103 | 92 |
2183414 | 2183414 | 2022-02-04 | Gonzales | Texas | 48177 | 4342 | 92 |
2180162 | 2180162 | 2022-02-03 | Gonzales | Texas | 48177 | 4333 | 92 |
2176911 | 2176911 | 2022-02-02 | Gonzales | Texas | 48177 | 4320 | 92 |
2173657 | 2173657 | 2022-02-01 | Gonzales | Texas | 48177 | 4314 | 92 |
2170405 | 2170405 | 2022-01-31 | Gonzales | Texas | 48177 | 4304 | 92 |
2167151 | 2167151 | 2022-01-30 | Gonzales | Texas | 48177 | 4287 | 92 |
2163896 | 2163896 | 2022-01-29 | Gonzales | Texas | 48177 | 4274 | 92 |
2160641 | 2160641 | 2022-01-28 | Gonzales | Texas | 48177 | 4246 | 92 |
2157385 | 2157385 | 2022-01-27 | Gonzales | Texas | 48177 | 4223 | 92 |
2154132 | 2154132 | 2022-01-26 | Gonzales | Texas | 48177 | 4210 | 92 |
2150880 | 2150880 | 2022-01-25 | Gonzales | Texas | 48177 | 4199 | 92 |
2147628 | 2147628 | 2022-01-24 | Gonzales | Texas | 48177 | 4188 | 92 |
2144374 | 2144374 | 2022-01-23 | Gonzales | Texas | 48177 | 4173 | 92 |
2141119 | 2141119 | 2022-01-22 | Gonzales | Texas | 48177 | 4150 | 92 |
2137863 | 2137863 | 2022-01-21 | Gonzales | Texas | 48177 | 4128 | 92 |
2134587 | 2134587 | 2022-01-20 | Eastland | Texas | 48133 | 2557 | 92 |
2134609 | 2134609 | 2022-01-20 | Gonzales | Texas | 48177 | 4102 | 92 |
2131335 | 2131335 | 2022-01-19 | Eastland | Texas | 48133 | 2541 | 92 |
2131357 | 2131357 | 2022-01-19 | Gonzales | Texas | 48177 | 4077 | 92 |
2128103 | 2128103 | 2022-01-18 | Gonzales | Texas | 48177 | 4058 | 92 |
2111921 | 2111921 | 2022-01-13 | Milam | Texas | 48331 | 4363 | 92 |
2108669 | 2108669 | 2022-01-12 | Milam | Texas | 48331 | 4321 | 92 |
2105418 | 2105418 | 2022-01-11 | Milam | Texas | 48331 | 4287 | 92 |
2085951 | 2085951 | 2022-01-05 | Scurry | Texas | 48415 | 3864 | 92 |
2082699 | 2082699 | 2022-01-04 | Scurry | Texas | 48415 | 3825 | 92 |
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);