ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 130 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Throckmorton 8
- Irion 7
- Concho 6
- Eastland 6
- Real 6
- Dickens 5
- Stephens 4
- Franklin 3
- Hartley 3
- Mason 3
- Winkler 3
- Camp 2
- Chambers 2
- Childress 2
- Red River 2
- San Jacinto 2
- Austin 1
- Bailey 1
- Bowie 1
- Brewster 1
- Castro 1
- Cherokee 1
- Collingsworth 1
- Culberson 1
- Ector 1
- Edwards 1
- Fannin 1
- Frio 1
- Galveston 1
- Gray 1
- …
state 1
- Texas · 93 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2105414 | 2105414 | 2022-01-11 | McMullen | Texas | 48311 | 130 | 8 |
1881196 | 1881196 | 2021-11-03 | Throckmorton | Texas | 48447 | 130 | 6 |
1877947 | 1877947 | 2021-11-02 | Throckmorton | Texas | 48447 | 130 | 6 |
1874698 | 1874698 | 2021-11-01 | Throckmorton | Texas | 48447 | 130 | 6 |
1871449 | 1871449 | 2021-10-31 | Throckmorton | Texas | 48447 | 130 | 6 |
1868200 | 1868200 | 2021-10-30 | Throckmorton | Texas | 48447 | 130 | 6 |
1864951 | 1864951 | 2021-10-29 | Throckmorton | Texas | 48447 | 130 | 6 |
1861702 | 1861702 | 2021-10-28 | Throckmorton | Texas | 48447 | 130 | 6 |
1858453 | 1858453 | 2021-10-27 | Throckmorton | Texas | 48447 | 130 | 6 |
1546475 | 1546475 | 2021-07-23 | Irion | Texas | 48235 | 130 | 1 |
1543228 | 1543228 | 2021-07-22 | Irion | Texas | 48235 | 130 | 1 |
1400396 | 1400396 | 2021-06-08 | Irion | Texas | 48235 | 130 | 1 |
1397151 | 1397151 | 2021-06-07 | Irion | Texas | 48235 | 130 | 1 |
1393904 | 1393904 | 2021-06-06 | Irion | Texas | 48235 | 130 | 1 |
1390659 | 1390659 | 2021-06-05 | Irion | Texas | 48235 | 130 | 1 |
1387414 | 1387414 | 2021-06-04 | Irion | Texas | 48235 | 130 | 1 |
900405 | 900405 | 2021-01-05 | Dickens | Texas | 48125 | 130 | 7 |
897160 | 897160 | 2021-01-04 | Dickens | Texas | 48125 | 130 | 7 |
893914 | 893914 | 2021-01-03 | Dickens | Texas | 48125 | 130 | 7 |
890668 | 890668 | 2021-01-02 | Dickens | Texas | 48125 | 130 | 7 |
887421 | 887421 | 2021-01-01 | Dickens | Texas | 48125 | 130 | 7 |
816027 | 816027 | 2020-12-10 | Edwards | Texas | 48137 | 130 | 2 |
812756 | 812756 | 2020-12-09 | Collingsworth | Texas | 48087 | 130 | 2 |
812760 | 812760 | 2020-12-09 | Concho | Texas | 48095 | 130 | 3 |
793291 | 793291 | 2020-12-03 | Concho | Texas | 48095 | 130 | 2 |
790046 | 790046 | 2020-12-02 | Concho | Texas | 48095 | 130 | 2 |
777175 | 777175 | 2020-11-28 | Mason | Texas | 48319 | 130 | 2 |
777225 | 777225 | 2020-11-28 | Schleicher | Texas | 48413 | 130 | 4 |
773930 | 773930 | 2020-11-27 | Mason | Texas | 48319 | 130 | 2 |
764230 | 764230 | 2020-11-24 | Real | Texas | 48385 | 130 | 8 |
760985 | 760985 | 2020-11-23 | Real | Texas | 48385 | 130 | 8 |
757740 | 757740 | 2020-11-22 | Real | Texas | 48385 | 130 | 8 |
754493 | 754493 | 2020-11-21 | Real | Texas | 48385 | 130 | 8 |
751247 | 751247 | 2020-11-20 | Real | Texas | 48385 | 130 | 8 |
748001 | 748001 | 2020-11-19 | Real | Texas | 48385 | 130 | 8 |
744719 | 744719 | 2020-11-18 | Mason | Texas | 48319 | 130 | 2 |
705685 | 705685 | 2020-11-06 | Culberson | Texas | 48109 | 130 | 3 |
699182 | 699182 | 2020-11-04 | Childress | Texas | 48075 | 130 | 0 |
695938 | 695938 | 2020-11-03 | Childress | Texas | 48075 | 130 | 0 |
647492 | 647492 | 2020-10-19 | Winkler | Texas | 48495 | 130 | 4 |
644246 | 644246 | 2020-10-18 | Winkler | Texas | 48495 | 130 | 4 |
640969 | 640969 | 2020-10-17 | Swisher | Texas | 48437 | 130 | 3 |
640998 | 640998 | 2020-10-17 | Winkler | Texas | 48495 | 130 | 4 |
579192 | 579192 | 2020-09-28 | Concho | Texas | 48095 | 130 | 2 |
579247 | 579247 | 2020-09-28 | Hartley | Texas | 48205 | 130 | 2 |
575951 | 575951 | 2020-09-27 | Concho | Texas | 48095 | 130 | 2 |
576006 | 576006 | 2020-09-27 | Hartley | Texas | 48205 | 130 | 2 |
572707 | 572707 | 2020-09-26 | Concho | Texas | 48095 | 130 | 2 |
572762 | 572762 | 2020-09-26 | Hartley | Texas | 48205 | 130 | 2 |
556540 | 556540 | 2020-09-21 | Franklin | Texas | 48159 | 130 | 6 |
553303 | 553303 | 2020-09-20 | Franklin | Texas | 48159 | 130 | 6 |
550064 | 550064 | 2020-09-19 | Franklin | Texas | 48159 | 130 | 6 |
520922 | 520922 | 2020-09-10 | Eastland | Texas | 48133 | 130 | 3 |
521068 | 521068 | 2020-09-10 | Stephens | Texas | 48429 | 130 | 4 |
517686 | 517686 | 2020-09-09 | Eastland | Texas | 48133 | 130 | 3 |
517832 | 517832 | 2020-09-09 | Stephens | Texas | 48429 | 130 | 4 |
488585 | 488585 | 2020-08-31 | Eastland | Texas | 48133 | 130 | 2 |
485352 | 485352 | 2020-08-30 | Eastland | Texas | 48133 | 130 | 2 |
482117 | 482117 | 2020-08-29 | Eastland | Texas | 48133 | 130 | 2 |
478883 | 478883 | 2020-08-28 | Eastland | Texas | 48133 | 130 | 2 |
449961 | 449961 | 2020-08-19 | Stephens | Texas | 48429 | 130 | 3 |
446733 | 446733 | 2020-08-18 | Stephens | Texas | 48429 | 130 | 3 |
430560 | 430560 | 2020-08-13 | Morris | Texas | 48343 | 130 | 3 |
411209 | 411209 | 2020-08-07 | Marion | Texas | 48315 | 130 | 8 |
378996 | 378996 | 2020-07-28 | Howard | Texas | 48227 | 130 | 3 |
379026 | 379026 | 2020-07-28 | Leon | Texas | 48289 | 130 | 1 |
366042 | 366042 | 2020-07-24 | Bailey | Texas | 48017 | 130 | 2 |
363028 | 363028 | 2020-07-23 | San Jacinto | Texas | 48407 | 130 | 2 |
356606 | 356606 | 2020-07-21 | Red River | Texas | 48387 | 130 | 12 |
353403 | 353403 | 2020-07-20 | Red River | Texas | 48387 | 130 | 12 |
353438 | 353438 | 2020-07-20 | Upshur | Texas | 48459 | 130 | 0 |
350211 | 350211 | 2020-07-19 | San Jacinto | Texas | 48407 | 130 | 2 |
343729 | 343729 | 2020-07-17 | Jackson | Texas | 48239 | 130 | 1 |
337249 | 337249 | 2020-07-15 | Castro | Texas | 48069 | 130 | 1 |
334220 | 334220 | 2020-07-14 | San Augustine | Texas | 48405 | 130 | 12 |
330979 | 330979 | 2020-07-13 | Madison | Texas | 48313 | 130 | 0 |
327651 | 327651 | 2020-07-12 | Austin | Texas | 48015 | 130 | 0 |
321308 | 321308 | 2020-07-10 | Camp | Texas | 48063 | 130 | 2 |
321366 | 321366 | 2020-07-10 | Gray | Texas | 48179 | 130 | 4 |
318130 | 318130 | 2020-07-09 | Camp | Texas | 48063 | 130 | 2 |
318172 | 318172 | 2020-07-09 | Fannin | Texas | 48147 | 130 | 8 |
318206 | 318206 | 2020-07-09 | Hill | Texas | 48217 | 130 | 2 |
296106 | 296106 | 2020-07-02 | Pecos | Texas | 48371 | 130 | 0 |
289640 | 289640 | 2020-06-30 | Brewster | Texas | 48043 | 130 | 1 |
286505 | 286505 | 2020-06-29 | Cherokee | Texas | 48073 | 130 | 2 |
258305 | 258305 | 2020-06-20 | Frio | Texas | 48163 | 130 | 0 |
252020 | 252020 | 2020-06-18 | Chambers | Texas | 48071 | 130 | 0 |
248905 | 248905 | 2020-06-17 | Chambers | Texas | 48071 | 130 | 0 |
162782 | 162782 | 2020-05-20 | Ector | Texas | 48135 | 130 | 4 |
150658 | 150658 | 2020-05-16 | Bowie | Texas | 48037 | 130 | 11 |
72506 | 72506 | 2020-04-19 | Potter | Texas | 48375 | 130 | 2 |
32817 | 32817 | 2020-04-04 | Montgomery | Texas | 48339 | 130 | 3 |
28035 | 28035 | 2020-04-02 | Galveston | Texas | 48167 | 130 | 0 |
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);