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-01-24 and state = "Texas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2147674 | 2147674 | 2022-01-24 | King | Texas | 48269 | 39 | 0 |
2147670 | 2147670 | 2022-01-24 | Kenedy | Texas | 48261 | 67 | 2 |
2147690 | 2147690 | 2022-01-24 | Loving | Texas | 48301 | 89 | 0 |
2147556 | 2147556 | 2022-01-24 | Borden | Texas | 48033 | 91 | 2 |
2147761 | 2147761 | 2022-01-24 | Terrell | Texas | 48443 | 111 | 3 |
2147701 | 2147701 | 2022-01-24 | McMullen | Texas | 48311 | 146 | 8 |
2147736 | 2147736 | 2022-01-24 | Roberts | Texas | 48393 | 153 | 1 |
2147617 | 2147617 | 2022-01-24 | Foard | Texas | 48155 | 187 | 10 |
2147626 | 2147626 | 2022-01-24 | Glasscock | Texas | 48173 | 187 | 3 |
2147671 | 2147671 | 2022-01-24 | Kent | Texas | 48263 | 189 | 3 |
2147661 | 2147661 | 2022-01-24 | Jeff Davis | Texas | 48243 | 213 | 8 |
2147755 | 2147755 | 2022-01-24 | Sterling | Texas | 48431 | 236 | 5 |
2147763 | 2147763 | 2022-01-24 | Throckmorton | Texas | 48447 | 249 | 7 |
2147712 | 2147712 | 2022-01-24 | Motley | Texas | 48345 | 250 | 10 |
2147590 | 2147590 | 2022-01-24 | Cottle | Texas | 48101 | 267 | 9 |
2147756 | 2147756 | 2022-01-24 | Stonewall | Texas | 48433 | 302 | 7 |
2147657 | 2147657 | 2022-01-24 | Irion | Texas | 48235 | 370 | 2 |
2147602 | 2147602 | 2022-01-24 | Dickens | Texas | 48125 | 390 | 15 |
2147608 | 2147608 | 2022-01-24 | Edwards | Texas | 48137 | 413 | 10 |
2147562 | 2147562 | 2022-01-24 | Briscoe | Texas | 48045 | 414 | 8 |
2147746 | 2147746 | 2022-01-24 | Schleicher | Texas | 48413 | 447 | 9 |
2147750 | 2147750 | 2022-01-24 | Sherman | Texas | 48421 | 450 | 16 |
2147703 | 2147703 | 2022-01-24 | Menard | Texas | 48327 | 451 | 12 |
2147677 | 2147677 | 2022-01-24 | Knox | Texas | 48275 | 459 | 22 |
2147545 | 2147545 | 2022-01-24 | Armstrong | Texas | 48011 | 464 | 8 |
2147594 | 2147594 | 2022-01-24 | Culberson | Texas | 48109 | 479 | 13 |
2147719 | 2147719 | 2022-01-24 | Oldham | Texas | 48359 | 507 | 6 |
2147638 | 2147638 | 2022-01-24 | Hardeman | Texas | 48197 | 532 | 14 |
2147615 | 2147615 | 2022-01-24 | Fisher | Texas | 48151 | 540 | 20 |
2147687 | 2147687 | 2022-01-24 | Lipscomb | Texas | 48295 | 585 | 13 |
2147673 | 2147673 | 2022-01-24 | Kimble | Texas | 48267 | 600 | 12 |
2147748 | 2147748 | 2022-01-24 | Shackelford | Texas | 48417 | 600 | 11 |
2147583 | 2147583 | 2022-01-24 | Collingsworth | Texas | 48087 | 609 | 13 |
2147675 | 2147675 | 2022-01-24 | Kinney | Texas | 48271 | 674 | 10 |
2147696 | 2147696 | 2022-01-24 | Mason | Texas | 48319 | 704 | 9 |
2147757 | 2147757 | 2022-01-24 | Sutton | Texas | 48435 | 716 | 11 |
2147732 | 2147732 | 2022-01-24 | Real | Texas | 48385 | 723 | 22 |
2147771 | 2147771 | 2022-01-24 | Upton | Texas | 48461 | 732 | 16 |
2147551 | 2147551 | 2022-01-24 | Baylor | Texas | 48023 | 750 | 26 |
2147579 | 2147579 | 2022-01-24 | Cochran | Texas | 48079 | 762 | 21 |
2147731 | 2147731 | 2022-01-24 | Reagan | Texas | 48383 | 763 | 11 |
2147580 | 2147580 | 2022-01-24 | Coke | Texas | 48081 | 784 | 18 |
2147643 | 2147643 | 2022-01-24 | Haskell | Texas | 48207 | 845 | 37 |
2147654 | 2147654 | 2022-01-24 | Hudspeth | Texas | 48229 | 874 | 16 |
2147635 | 2147635 | 2022-01-24 | Hall | Texas | 48191 | 886 | 19 |
2147604 | 2147604 | 2022-01-24 | Donley | Texas | 48129 | 902 | 20 |
2147728 | 2147728 | 2022-01-24 | Presidio | Texas | 48377 | 917 | 32 |
2147587 | 2147587 | 2022-01-24 | Concho | Texas | 48095 | 966 | 10 |
2147592 | 2147592 | 2022-01-24 | Crockett | Texas | 48105 | 973 | 17 |
2147742 | 2147742 | 2022-01-24 | San Augustine | Texas | 48405 | 974 | 38 |
2147561 | 2147561 | 2022-01-24 | Brewster | Texas | 48043 | 985 | 25 |
2147791 | 2147791 | 2022-01-24 | Yoakum | Texas | 48501 | 1000 | 37 |
2147645 | 2147645 | 2022-01-24 | Hemphill | Texas | 48211 | 1003 | 4 |
2147627 | 2147627 | 2022-01-24 | Goliad | Texas | 48175 | 1015 | 28 |
2147695 | 2147695 | 2022-01-24 | Martin | Texas | 48317 | 1057 | 24 |
2147782 | 2147782 | 2022-01-24 | Wheeler | Texas | 48483 | 1092 | 15 |
2147591 | 2147591 | 2022-01-24 | Crane | Texas | 48103 | 1102 | 19 |
2147745 | 2147745 | 2022-01-24 | San Saba | Texas | 48411 | 1132 | 29 |
2147624 | 2147624 | 2022-01-24 | Garza | Texas | 48169 | 1152 | 25 |
2147741 | 2147741 | 2022-01-24 | Sabine | Texas | 48403 | 1152 | 78 |
2147699 | 2147699 | 2022-01-24 | McCulloch | Texas | 48307 | 1170 | 42 |
2147715 | 2147715 | 2022-01-24 | Newton | Texas | 48351 | 1177 | 55 |
2147642 | 2147642 | 2022-01-24 | Hartley | Texas | 48205 | 1210 | 3 |
2147692 | 2147692 | 2022-01-24 | Lynn | Texas | 48305 | 1238 | 30 |
2147548 | 2147548 | 2022-01-24 | Bailey | Texas | 48017 | 1302 | 31 |
2147572 | 2147572 | 2022-01-24 | Carson | Texas | 48065 | 1357 | 31 |
2147706 | 2147706 | 2022-01-24 | Mills | Texas | 48333 | 1358 | 29 |
2147658 | 2147658 | 2022-01-24 | Jack | Texas | 48237 | 1362 | 23 |
2147563 | 2147563 | 2022-01-24 | Brooks | Texas | 48047 | 1424 | 48 |
2147694 | 2147694 | 2022-01-24 | Marion | Texas | 48315 | 1482 | 55 |
2147581 | 2147581 | 2022-01-24 | Coleman | Texas | 48083 | 1514 | 64 |
2147637 | 2147637 | 2022-01-24 | Hansford | Texas | 48195 | 1546 | 27 |
2147735 | 2147735 | 2022-01-24 | Refugio | Texas | 48391 | 1546 | 31 |
2147600 | 2147600 | 2022-01-24 | Delta | Texas | 48119 | 1617 | 22 |
2147788 | 2147788 | 2022-01-24 | Winkler | Texas | 48495 | 1620 | 33 |
2147622 | 2147622 | 2022-01-24 | Gaines | Texas | 48165 | 1625 | 73 |
2147754 | 2147754 | 2022-01-24 | Stephens | Texas | 48429 | 1682 | 40 |
2147729 | 2147729 | 2022-01-24 | Rains | Texas | 48379 | 1685 | 51 |
2147593 | 2147593 | 2022-01-24 | Crosby | Texas | 48107 | 1726 | 44 |
2147707 | 2147707 | 2022-01-24 | Mitchell | Texas | 48335 | 1729 | 45 |
2147616 | 2147616 | 2022-01-24 | Floyd | Texas | 48153 | 1805 | 42 |
2147758 | 2147758 | 2022-01-24 | Swisher | Texas | 48437 | 1823 | 30 |
2147636 | 2147636 | 2022-01-24 | Hamilton | Texas | 48193 | 1833 | 29 |
2147663 | 2147663 | 2022-01-24 | Jim Hogg | Texas | 48247 | 1849 | 20 |
2147619 | 2147619 | 2022-01-24 | Franklin | Texas | 48159 | 1872 | 37 |
2147595 | 2147595 | 2022-01-24 | Dallam | Texas | 48111 | 1888 | 33 |
2147544 | 2147544 | 2022-01-24 | Archer | Texas | 48009 | 1894 | 24 |
2147752 | 2147752 | 2022-01-24 | Somervell | Texas | 48425 | 1916 | 31 |
2147578 | 2147578 | 2022-01-24 | Clay | Texas | 48077 | 1917 | 26 |
2147718 | 2147718 | 2022-01-24 | Ochiltree | Texas | 48357 | 1932 | 40 |
2147688 | 2147688 | 2022-01-24 | Live Oak | Texas | 48297 | 1958 | 39 |
2147678 | 2147678 | 2022-01-24 | La Salle | Texas | 48283 | 1985 | 41 |
2147733 | 2147733 | 2022-01-24 | Red River | Texas | 48387 | 1997 | 59 |
2147762 | 2147762 | 2022-01-24 | Terry | Texas | 48445 | 2033 | 79 |
2147724 | 2147724 | 2022-01-24 | Parmer | Texas | 48369 | 2057 | 46 |
2147739 | 2147739 | 2022-01-24 | Runnels | Texas | 48399 | 2099 | 59 |
2147574 | 2147574 | 2022-01-24 | Castro | Texas | 48069 | 2124 | 45 |
2147555 | 2147555 | 2022-01-24 | Blanco | Texas | 48031 | 2206 | 29 |
2147577 | 2147577 | 2022-01-24 | Childress | Texas | 48075 | 2211 | 26 |
2147711 | 2147711 | 2022-01-24 | Morris | Texas | 48343 | 2271 | 61 |
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);