ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where "date" is on date 2022-02-05 and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2186712 | 2186712 | 2022-02-05 | King | Texas | 48269 | 40 | 0 |
2186728 | 2186728 | 2022-02-05 | Loving | Texas | 48301 | 139 | 0 |
2186807 | 2186807 | 2022-02-05 | Unknown | Texas | 2792 | 0 | |
2186774 | 2186774 | 2022-02-05 | Roberts | Texas | 48393 | 160 | 1 |
2186594 | 2186594 | 2022-02-05 | Borden | Texas | 48033 | 94 | 2 |
2186708 | 2186708 | 2022-02-05 | Kenedy | Texas | 48261 | 74 | 2 |
2186664 | 2186664 | 2022-02-05 | Glasscock | Texas | 48173 | 192 | 3 |
2186680 | 2186680 | 2022-02-05 | Hartley | Texas | 48205 | 1254 | 3 |
2186695 | 2186695 | 2022-02-05 | Irion | Texas | 48235 | 419 | 3 |
2186799 | 2186799 | 2022-02-05 | Terrell | Texas | 48443 | 113 | 3 |
2186683 | 2186683 | 2022-02-05 | Hemphill | Texas | 48211 | 1039 | 4 |
2186709 | 2186709 | 2022-02-05 | Kent | Texas | 48263 | 197 | 4 |
2186793 | 2186793 | 2022-02-05 | Sterling | Texas | 48431 | 244 | 5 |
2186757 | 2186757 | 2022-02-05 | Oldham | Texas | 48359 | 515 | 6 |
2186794 | 2186794 | 2022-02-05 | Stonewall | Texas | 48433 | 333 | 7 |
2186801 | 2186801 | 2022-02-05 | Throckmorton | Texas | 48447 | 254 | 7 |
2186583 | 2186583 | 2022-02-05 | Armstrong | Texas | 48011 | 481 | 8 |
2186600 | 2186600 | 2022-02-05 | Briscoe | Texas | 48045 | 426 | 8 |
2186699 | 2186699 | 2022-02-05 | Jeff Davis | Texas | 48243 | 217 | 8 |
2186739 | 2186739 | 2022-02-05 | McMullen | Texas | 48311 | 161 | 8 |
2186628 | 2186628 | 2022-02-05 | Cottle | Texas | 48101 | 275 | 9 |
2186784 | 2186784 | 2022-02-05 | Schleicher | Texas | 48413 | 499 | 9 |
2186646 | 2186646 | 2022-02-05 | Edwards | Texas | 48137 | 454 | 10 |
2186713 | 2186713 | 2022-02-05 | Kinney | Texas | 48271 | 712 | 10 |
2186734 | 2186734 | 2022-02-05 | Mason | Texas | 48319 | 759 | 10 |
2186625 | 2186625 | 2022-02-05 | Concho | Texas | 48095 | 1002 | 11 |
2186655 | 2186655 | 2022-02-05 | Foard | Texas | 48155 | 194 | 11 |
2186750 | 2186750 | 2022-02-05 | Motley | Texas | 48345 | 263 | 11 |
2186725 | 2186725 | 2022-02-05 | Lipscomb | Texas | 48295 | 606 | 12 |
2186741 | 2186741 | 2022-02-05 | Menard | Texas | 48327 | 482 | 12 |
2186786 | 2186786 | 2022-02-05 | Shackelford | Texas | 48417 | 619 | 12 |
2186795 | 2186795 | 2022-02-05 | Sutton | Texas | 48435 | 786 | 12 |
2186621 | 2186621 | 2022-02-05 | Collingsworth | Texas | 48087 | 634 | 13 |
2186632 | 2186632 | 2022-02-05 | Culberson | Texas | 48109 | 502 | 13 |
2186769 | 2186769 | 2022-02-05 | Reagan | Texas | 48383 | 815 | 13 |
2186676 | 2186676 | 2022-02-05 | Hardeman | Texas | 48197 | 549 | 14 |
2186711 | 2186711 | 2022-02-05 | Kimble | Texas | 48267 | 648 | 14 |
2186640 | 2186640 | 2022-02-05 | Dickens | Texas | 48125 | 408 | 15 |
2186692 | 2186692 | 2022-02-05 | Hudspeth | Texas | 48229 | 941 | 16 |
2186788 | 2186788 | 2022-02-05 | Sherman | Texas | 48421 | 469 | 16 |
2186630 | 2186630 | 2022-02-05 | Crockett | Texas | 48105 | 1012 | 17 |
2186809 | 2186809 | 2022-02-05 | Upton | Texas | 48461 | 791 | 17 |
2186618 | 2186618 | 2022-02-05 | Coke | Texas | 48081 | 816 | 18 |
2186820 | 2186820 | 2022-02-05 | Wheeler | Texas | 48483 | 1117 | 18 |
2186653 | 2186653 | 2022-02-05 | Fisher | Texas | 48151 | 578 | 20 |
2186673 | 2186673 | 2022-02-05 | Hall | Texas | 48191 | 924 | 20 |
2186701 | 2186701 | 2022-02-05 | Jim Hogg | Texas | 48247 | 2263 | 20 |
2186617 | 2186617 | 2022-02-05 | Cochran | Texas | 48079 | 821 | 21 |
2186629 | 2186629 | 2022-02-05 | Crane | Texas | 48103 | 1232 | 21 |
2186642 | 2186642 | 2022-02-05 | Donley | Texas | 48129 | 954 | 22 |
2186715 | 2186715 | 2022-02-05 | Knox | Texas | 48275 | 475 | 22 |
2186638 | 2186638 | 2022-02-05 | Delta | Texas | 48119 | 1719 | 23 |
2186770 | 2186770 | 2022-02-05 | Real | Texas | 48385 | 781 | 23 |
2186696 | 2186696 | 2022-02-05 | Jack | Texas | 48237 | 1439 | 24 |
2186582 | 2186582 | 2022-02-05 | Archer | Texas | 48009 | 2041 | 25 |
2186599 | 2186599 | 2022-02-05 | Brewster | Texas | 48043 | 1013 | 25 |
2186733 | 2186733 | 2022-02-05 | Martin | Texas | 48317 | 1110 | 25 |
2186662 | 2186662 | 2022-02-05 | Garza | Texas | 48169 | 1210 | 26 |
2186615 | 2186615 | 2022-02-05 | Childress | Texas | 48075 | 2320 | 27 |
2186616 | 2186616 | 2022-02-05 | Clay | Texas | 48077 | 2004 | 27 |
2186675 | 2186675 | 2022-02-05 | Hansford | Texas | 48195 | 1598 | 27 |
2186589 | 2186589 | 2022-02-05 | Baylor | Texas | 48023 | 788 | 28 |
2186665 | 2186665 | 2022-02-05 | Goliad | Texas | 48175 | 1116 | 29 |
2186674 | 2186674 | 2022-02-05 | Hamilton | Texas | 48193 | 1927 | 29 |
2186593 | 2186593 | 2022-02-05 | Blanco | Texas | 48031 | 2388 | 30 |
2186744 | 2186744 | 2022-02-05 | Mills | Texas | 48333 | 1428 | 30 |
2186796 | 2186796 | 2022-02-05 | Swisher | Texas | 48437 | 1864 | 30 |
2186610 | 2186610 | 2022-02-05 | Carson | Texas | 48065 | 1414 | 31 |
2186773 | 2186773 | 2022-02-05 | Refugio | Texas | 48391 | 1692 | 31 |
2186783 | 2186783 | 2022-02-05 | San Saba | Texas | 48411 | 1216 | 31 |
2186790 | 2186790 | 2022-02-05 | Somervell | Texas | 48425 | 2030 | 31 |
2186586 | 2186586 | 2022-02-05 | Bailey | Texas | 48017 | 1347 | 33 |
2186766 | 2186766 | 2022-02-05 | Presidio | Texas | 48377 | 947 | 33 |
2186826 | 2186826 | 2022-02-05 | Winkler | Texas | 48495 | 1763 | 33 |
2186730 | 2186730 | 2022-02-05 | Lynn | Texas | 48305 | 1331 | 34 |
2186633 | 2186633 | 2022-02-05 | Dallam | Texas | 48111 | 1986 | 36 |
2186657 | 2186657 | 2022-02-05 | Franklin | Texas | 48159 | 2014 | 37 |
2186681 | 2186681 | 2022-02-05 | Haskell | Texas | 48207 | 880 | 37 |
2186780 | 2186780 | 2022-02-05 | San Augustine | Texas | 48405 | 1013 | 38 |
2186829 | 2186829 | 2022-02-05 | Yoakum | Texas | 48501 | 1023 | 38 |
2186792 | 2186792 | 2022-02-05 | Stephens | Texas | 48429 | 1748 | 39 |
2186726 | 2186726 | 2022-02-05 | Live Oak | Texas | 48297 | 2086 | 40 |
2186816 | 2186816 | 2022-02-05 | Ward | Texas | 48475 | 2693 | 41 |
2186606 | 2186606 | 2022-02-05 | Calhoun | Texas | 48057 | 5445 | 42 |
2186716 | 2186716 | 2022-02-05 | La Salle | Texas | 48283 | 2129 | 42 |
2186737 | 2186737 | 2022-02-05 | McCulloch | Texas | 48307 | 1233 | 42 |
2186756 | 2186756 | 2022-02-05 | Ochiltree | Texas | 48357 | 1957 | 43 |
2186631 | 2186631 | 2022-02-05 | Crosby | Texas | 48107 | 1800 | 44 |
2186612 | 2186612 | 2022-02-05 | Castro | Texas | 48069 | 2210 | 46 |
2186654 | 2186654 | 2022-02-05 | Floyd | Texas | 48153 | 1862 | 46 |
2186745 | 2186745 | 2022-02-05 | Mitchell | Texas | 48335 | 1809 | 46 |
2186831 | 2186831 | 2022-02-05 | Zapata | Texas | 48505 | 3141 | 47 |
2186762 | 2186762 | 2022-02-05 | Parmer | Texas | 48369 | 2158 | 48 |
2186601 | 2186601 | 2022-02-05 | Brooks | Texas | 48047 | 1517 | 49 |
2186641 | 2186641 | 2022-02-05 | Dimmit | Texas | 48127 | 5433 | 50 |
2186731 | 2186731 | 2022-02-05 | Madison | Texas | 48313 | 3603 | 50 |
2186767 | 2186767 | 2022-02-05 | Rains | Texas | 48379 | 1763 | 53 |
2186697 | 2186697 | 2022-02-05 | Jackson | Texas | 48239 | 3133 | 55 |
2186721 | 2186721 | 2022-02-05 | Lee | Texas | 48287 | 4045 | 56 |
2186732 | 2186732 | 2022-02-05 | Marion | Texas | 48315 | 1570 | 56 |
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);