ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
310 rows where cases = 24 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- McMullen 33
- Hill 12
- Stonewall 12
- Donley 11
- Hardeman 11
- Delta 8
- Shackelford 8
- Kendall 7
- Kinney 7
- Roberts 6
- Colorado 5
- Edwards 5
- Jeff Davis 5
- Fisher 4
- Hall 4
- Henderson 4
- Limestone 4
- Maverick 4
- Rockwall 4
- San Saba 4
- Sherman 4
- Starr 4
- Armstrong 3
- Brewster 3
- Burleson 3
- Burnet 3
- Fannin 3
- Foard 3
- Haskell 3
- Howard 3
- …
state 1
- Texas · 310 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1988362 | 1988362 | 2021-12-06 | King | Texas | 48269 | 24 | 0 |
1985112 | 1985112 | 2021-12-05 | King | Texas | 48269 | 24 | 0 |
1981862 | 1981862 | 2021-12-04 | King | Texas | 48269 | 24 | 0 |
906964 | 906964 | 2021-01-07 | Kenedy | Texas | 48261 | 24 | 2 |
903718 | 903718 | 2021-01-06 | Kenedy | Texas | 48261 | 24 | 2 |
900473 | 900473 | 2021-01-05 | Kenedy | Texas | 48261 | 24 | 2 |
790222 | 790222 | 2020-12-02 | Throckmorton | Texas | 48447 | 24 | 2 |
777240 | 777240 | 2020-11-28 | Terrell | Texas | 48443 | 24 | 1 |
773995 | 773995 | 2020-11-27 | Terrell | Texas | 48443 | 24 | 1 |
767479 | 767479 | 2020-11-25 | Roberts | Texas | 48393 | 24 | 0 |
767499 | 767499 | 2020-11-25 | Stonewall | Texas | 48433 | 24 | 2 |
764234 | 764234 | 2020-11-24 | Roberts | Texas | 48393 | 24 | 0 |
764254 | 764254 | 2020-11-24 | Stonewall | Texas | 48433 | 24 | 1 |
760989 | 760989 | 2020-11-23 | Roberts | Texas | 48393 | 24 | 0 |
761009 | 761009 | 2020-11-23 | Stonewall | Texas | 48433 | 24 | 1 |
757744 | 757744 | 2020-11-22 | Roberts | Texas | 48393 | 24 | 0 |
757764 | 757764 | 2020-11-22 | Stonewall | Texas | 48433 | 24 | 1 |
754497 | 754497 | 2020-11-21 | Roberts | Texas | 48393 | 24 | 0 |
754517 | 754517 | 2020-11-21 | Stonewall | Texas | 48433 | 24 | 1 |
751251 | 751251 | 2020-11-20 | Roberts | Texas | 48393 | 24 | 0 |
751271 | 751271 | 2020-11-20 | Stonewall | Texas | 48433 | 24 | 1 |
748025 | 748025 | 2020-11-19 | Stonewall | Texas | 48433 | 24 | 1 |
744779 | 744779 | 2020-11-18 | Stonewall | Texas | 48433 | 24 | 1 |
741532 | 741532 | 2020-11-17 | Stonewall | Texas | 48433 | 24 | 1 |
738285 | 738285 | 2020-11-16 | Stonewall | Texas | 48433 | 24 | 1 |
735041 | 735041 | 2020-11-15 | Stonewall | Texas | 48433 | 24 | 1 |
731795 | 731795 | 2020-11-14 | Stonewall | Texas | 48433 | 24 | 1 |
725169 | 725169 | 2020-11-12 | Foard | Texas | 48155 | 24 | 1 |
721926 | 721926 | 2020-11-11 | Foard | Texas | 48155 | 24 | 1 |
718683 | 718683 | 2020-11-10 | Foard | Texas | 48155 | 24 | 1 |
718727 | 718727 | 2020-11-10 | Jeff Davis | Texas | 48243 | 24 | 0 |
715484 | 715484 | 2020-11-09 | Jeff Davis | Texas | 48243 | 24 | 0 |
712240 | 712240 | 2020-11-08 | Jeff Davis | Texas | 48243 | 24 | 0 |
708996 | 708996 | 2020-11-07 | Jeff Davis | Texas | 48243 | 24 | 0 |
705752 | 705752 | 2020-11-06 | Jeff Davis | Texas | 48243 | 24 | 0 |
682949 | 682949 | 2020-10-30 | Briscoe | Texas | 48045 | 24 | 1 |
669961 | 669961 | 2020-10-26 | Armstrong | Texas | 48011 | 24 | 1 |
670089 | 670089 | 2020-10-26 | Kimble | Texas | 48267 | 24 | 1 |
670116 | 670116 | 2020-10-26 | McMullen | Texas | 48311 | 24 | 1 |
666718 | 666718 | 2020-10-25 | Armstrong | Texas | 48011 | 24 | 1 |
666846 | 666846 | 2020-10-25 | Kimble | Texas | 48267 | 24 | 1 |
666873 | 666873 | 2020-10-25 | McMullen | Texas | 48311 | 24 | 1 |
663473 | 663473 | 2020-10-24 | Armstrong | Texas | 48011 | 24 | 1 |
663601 | 663601 | 2020-10-24 | Kimble | Texas | 48267 | 24 | 1 |
663628 | 663628 | 2020-10-24 | McMullen | Texas | 48311 | 24 | 1 |
660384 | 660384 | 2020-10-23 | McMullen | Texas | 48311 | 24 | 1 |
657140 | 657140 | 2020-10-22 | McMullen | Texas | 48311 | 24 | 1 |
653895 | 653895 | 2020-10-21 | McMullen | Texas | 48311 | 24 | 1 |
650650 | 650650 | 2020-10-20 | McMullen | Texas | 48311 | 24 | 1 |
647406 | 647406 | 2020-10-19 | McMullen | Texas | 48311 | 24 | 1 |
644160 | 644160 | 2020-10-18 | McMullen | Texas | 48311 | 24 | 1 |
640912 | 640912 | 2020-10-17 | McMullen | Texas | 48311 | 24 | 1 |
637665 | 637665 | 2020-10-16 | McMullen | Texas | 48311 | 24 | 1 |
634420 | 634420 | 2020-10-15 | McMullen | Texas | 48311 | 24 | 1 |
631175 | 631175 | 2020-10-14 | McMullen | Texas | 48311 | 24 | 1 |
631193 | 631193 | 2020-10-14 | Oldham | Texas | 48359 | 24 | 1 |
627931 | 627931 | 2020-10-13 | McMullen | Texas | 48311 | 24 | 1 |
624688 | 624688 | 2020-10-12 | McMullen | Texas | 48311 | 24 | 1 |
621445 | 621445 | 2020-10-11 | McMullen | Texas | 48311 | 24 | 1 |
618202 | 618202 | 2020-10-10 | McMullen | Texas | 48311 | 24 | 1 |
614960 | 614960 | 2020-10-09 | McMullen | Texas | 48311 | 24 | 1 |
611719 | 611719 | 2020-10-08 | McMullen | Texas | 48311 | 24 | 1 |
608477 | 608477 | 2020-10-07 | McMullen | Texas | 48311 | 24 | 1 |
605234 | 605234 | 2020-10-06 | McMullen | Texas | 48311 | 24 | 1 |
601992 | 601992 | 2020-10-05 | McMullen | Texas | 48311 | 24 | 1 |
598749 | 598749 | 2020-10-04 | McMullen | Texas | 48311 | 24 | 1 |
595506 | 595506 | 2020-10-03 | McMullen | Texas | 48311 | 24 | 1 |
592264 | 592264 | 2020-10-02 | McMullen | Texas | 48311 | 24 | 1 |
589024 | 589024 | 2020-10-01 | McMullen | Texas | 48311 | 24 | 1 |
585783 | 585783 | 2020-09-30 | McMullen | Texas | 48311 | 24 | 1 |
582543 | 582543 | 2020-09-29 | McMullen | Texas | 48311 | 24 | 1 |
579304 | 579304 | 2020-09-28 | McMullen | Texas | 48311 | 24 | 1 |
576063 | 576063 | 2020-09-27 | McMullen | Texas | 48311 | 24 | 1 |
572819 | 572819 | 2020-09-26 | McMullen | Texas | 48311 | 24 | 1 |
569478 | 569478 | 2020-09-25 | Delta | Texas | 48119 | 24 | 0 |
569577 | 569577 | 2020-09-25 | McMullen | Texas | 48311 | 24 | 0 |
569646 | 569646 | 2020-09-25 | Upton | Texas | 48461 | 24 | 2 |
566237 | 566237 | 2020-09-24 | Delta | Texas | 48119 | 24 | 0 |
566336 | 566336 | 2020-09-24 | McMullen | Texas | 48311 | 24 | 0 |
566405 | 566405 | 2020-09-24 | Upton | Texas | 48461 | 24 | 2 |
562996 | 562996 | 2020-09-23 | Delta | Texas | 48119 | 24 | 0 |
563142 | 563142 | 2020-09-23 | Shackelford | Texas | 48417 | 24 | 0 |
559757 | 559757 | 2020-09-22 | Delta | Texas | 48119 | 24 | 0 |
559903 | 559903 | 2020-09-22 | Shackelford | Texas | 48417 | 24 | 0 |
556521 | 556521 | 2020-09-21 | Delta | Texas | 48119 | 24 | 0 |
556556 | 556556 | 2020-09-21 | Hall | Texas | 48191 | 24 | 1 |
556559 | 556559 | 2020-09-21 | Hardeman | Texas | 48197 | 24 | 0 |
556667 | 556667 | 2020-09-21 | Shackelford | Texas | 48417 | 24 | 0 |
553284 | 553284 | 2020-09-20 | Delta | Texas | 48119 | 24 | 0 |
553319 | 553319 | 2020-09-20 | Hall | Texas | 48191 | 24 | 1 |
553322 | 553322 | 2020-09-20 | Hardeman | Texas | 48197 | 24 | 0 |
553430 | 553430 | 2020-09-20 | Shackelford | Texas | 48417 | 24 | 0 |
550045 | 550045 | 2020-09-19 | Delta | Texas | 48119 | 24 | 0 |
550080 | 550080 | 2020-09-19 | Hall | Texas | 48191 | 24 | 1 |
550083 | 550083 | 2020-09-19 | Hardeman | Texas | 48197 | 24 | 0 |
550191 | 550191 | 2020-09-19 | Shackelford | Texas | 48417 | 24 | 0 |
546806 | 546806 | 2020-09-18 | Delta | Texas | 48119 | 24 | 0 |
546841 | 546841 | 2020-09-18 | Hall | Texas | 48191 | 24 | 1 |
546844 | 546844 | 2020-09-18 | Hardeman | Texas | 48197 | 24 | 0 |
546952 | 546952 | 2020-09-18 | Shackelford | Texas | 48417 | 24 | 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);