ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
159 rows where cases = 116 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2251839 | 2251839 | 2022-02-25 | Terrell | Texas | 48443 | 116 | 3 |
2248588 | 2248588 | 2022-02-24 | Terrell | Texas | 48443 | 116 | 3 |
2245337 | 2245337 | 2022-02-23 | Terrell | Texas | 48443 | 116 | 3 |
2242086 | 2242086 | 2022-02-22 | Terrell | Texas | 48443 | 116 | 3 |
2238835 | 2238835 | 2022-02-21 | Terrell | Texas | 48443 | 116 | 3 |
2235584 | 2235584 | 2022-02-20 | Terrell | Texas | 48443 | 116 | 3 |
2232333 | 2232333 | 2022-02-19 | Terrell | Texas | 48443 | 116 | 3 |
2053434 | 2053434 | 2021-12-26 | Roberts | Texas | 48393 | 116 | 1 |
2050184 | 2050184 | 2021-12-25 | Roberts | Texas | 48393 | 116 | 1 |
2046934 | 2046934 | 2021-12-24 | Roberts | Texas | 48393 | 116 | 1 |
2043684 | 2043684 | 2021-12-23 | Roberts | Texas | 48393 | 116 | 1 |
2040435 | 2040435 | 2021-12-22 | Roberts | Texas | 48393 | 116 | 1 |
2037185 | 2037185 | 2021-12-21 | Roberts | Texas | 48393 | 116 | 1 |
2033935 | 2033935 | 2021-12-20 | Roberts | Texas | 48393 | 116 | 1 |
2030685 | 2030685 | 2021-12-19 | Roberts | Texas | 48393 | 116 | 1 |
2027434 | 2027434 | 2021-12-18 | Roberts | Texas | 48393 | 116 | 1 |
2024183 | 2024183 | 2021-12-17 | Roberts | Texas | 48393 | 116 | 1 |
1864889 | 1864889 | 2021-10-29 | McMullen | Texas | 48311 | 116 | 8 |
1861640 | 1861640 | 2021-10-28 | McMullen | Texas | 48311 | 116 | 8 |
1858391 | 1858391 | 2021-10-27 | McMullen | Texas | 48311 | 116 | 8 |
1855142 | 1855142 | 2021-10-26 | McMullen | Texas | 48311 | 116 | 8 |
1851893 | 1851893 | 2021-10-25 | McMullen | Texas | 48311 | 116 | 8 |
1848643 | 1848643 | 2021-10-24 | McMullen | Texas | 48311 | 116 | 8 |
1845393 | 1845393 | 2021-10-23 | McMullen | Texas | 48311 | 116 | 8 |
1842143 | 1842143 | 2021-10-22 | McMullen | Texas | 48311 | 116 | 8 |
1838894 | 1838894 | 2021-10-21 | McMullen | Texas | 48311 | 116 | 8 |
1835645 | 1835645 | 2021-10-20 | McMullen | Texas | 48311 | 116 | 8 |
1796718 | 1796718 | 2021-10-08 | Throckmorton | Texas | 48447 | 116 | 5 |
1793469 | 1793469 | 2021-10-07 | Throckmorton | Texas | 48447 | 116 | 5 |
1738144 | 1738144 | 2021-09-20 | Kent | Texas | 48263 | 116 | 3 |
1734894 | 1734894 | 2021-09-19 | Kent | Texas | 48263 | 116 | 3 |
1731644 | 1731644 | 2021-09-18 | Kent | Texas | 48263 | 116 | 3 |
1728394 | 1728394 | 2021-09-17 | Kent | Texas | 48263 | 116 | 3 |
1725145 | 1725145 | 2021-09-16 | Kent | Texas | 48263 | 116 | 3 |
1721896 | 1721896 | 2021-09-15 | Kent | Texas | 48263 | 116 | 3 |
1718648 | 1718648 | 2021-09-14 | Kent | Texas | 48263 | 116 | 3 |
1715400 | 1715400 | 2021-09-13 | Kent | Texas | 48263 | 116 | 3 |
1712154 | 1712154 | 2021-09-12 | Kent | Texas | 48263 | 116 | 3 |
1708907 | 1708907 | 2021-09-11 | Kent | Texas | 48263 | 116 | 3 |
1705660 | 1705660 | 2021-09-10 | Kent | Texas | 48263 | 116 | 3 |
1702410 | 1702410 | 2021-09-09 | Kent | Texas | 48263 | 116 | 3 |
1699161 | 1699161 | 2021-09-08 | Kent | Texas | 48263 | 116 | 3 |
1630896 | 1630896 | 2021-08-18 | Glasscock | Texas | 48173 | 116 | 2 |
1403696 | 1403696 | 2021-06-09 | Motley | Texas | 48345 | 116 | 8 |
1400451 | 1400451 | 2021-06-08 | Motley | Texas | 48345 | 116 | 8 |
1397206 | 1397206 | 2021-06-07 | Motley | Texas | 48345 | 116 | 8 |
1393959 | 1393959 | 2021-06-06 | Motley | Texas | 48345 | 116 | 8 |
1390714 | 1390714 | 2021-06-05 | Motley | Texas | 48345 | 116 | 8 |
1387469 | 1387469 | 2021-06-04 | Motley | Texas | 48345 | 116 | 8 |
1384224 | 1384224 | 2021-06-03 | Motley | Texas | 48345 | 116 | 8 |
1380978 | 1380978 | 2021-06-02 | Motley | Texas | 48345 | 116 | 8 |
1351766 | 1351766 | 2021-05-24 | Motley | Texas | 48345 | 116 | 8 |
1348520 | 1348520 | 2021-05-23 | Motley | Texas | 48345 | 116 | 8 |
1345272 | 1345272 | 2021-05-22 | Motley | Texas | 48345 | 116 | 8 |
1342024 | 1342024 | 2021-05-21 | Motley | Texas | 48345 | 116 | 8 |
1338776 | 1338776 | 2021-05-20 | Motley | Texas | 48345 | 116 | 8 |
1335529 | 1335529 | 2021-05-19 | Motley | Texas | 48345 | 116 | 8 |
1332282 | 1332282 | 2021-05-18 | Motley | Texas | 48345 | 116 | 8 |
1104932 | 1104932 | 2021-03-09 | Irion | Texas | 48235 | 116 | 1 |
945898 | 945898 | 2021-01-19 | Jeff Davis | Texas | 48243 | 116 | 1 |
942651 | 942651 | 2021-01-18 | Jeff Davis | Texas | 48243 | 116 | 1 |
939406 | 939406 | 2021-01-17 | Jeff Davis | Texas | 48243 | 116 | 1 |
926515 | 926515 | 2021-01-13 | Sherman | Texas | 48421 | 116 | 11 |
923064 | 923064 | 2021-01-12 | Armstrong | Texas | 48011 | 116 | 5 |
919819 | 919819 | 2021-01-11 | Armstrong | Texas | 48011 | 116 | 5 |
920030 | 920030 | 2021-01-11 | Stonewall | Texas | 48433 | 116 | 3 |
916574 | 916574 | 2021-01-10 | Armstrong | Texas | 48011 | 116 | 5 |
916785 | 916785 | 2021-01-10 | Stonewall | Texas | 48433 | 116 | 3 |
913329 | 913329 | 2021-01-09 | Armstrong | Texas | 48011 | 116 | 5 |
913540 | 913540 | 2021-01-09 | Stonewall | Texas | 48433 | 116 | 3 |
819255 | 819255 | 2020-12-11 | Cottle | Texas | 48101 | 116 | 5 |
796652 | 796652 | 2020-12-04 | Menard | Texas | 48327 | 116 | 3 |
747946 | 747946 | 2020-11-19 | Knox | Texas | 48275 | 116 | 9 |
747975 | 747975 | 2020-11-19 | Mills | Texas | 48333 | 116 | 4 |
744700 | 744700 | 2020-11-18 | Knox | Texas | 48275 | 116 | 9 |
741453 | 741453 | 2020-11-17 | Knox | Texas | 48275 | 116 | 9 |
738207 | 738207 | 2020-11-16 | Knox | Texas | 48275 | 116 | 9 |
734963 | 734963 | 2020-11-15 | Knox | Texas | 48275 | 116 | 9 |
731717 | 731717 | 2020-11-14 | Knox | Texas | 48275 | 116 | 9 |
699361 | 699361 | 2020-11-04 | Sutton | Texas | 48435 | 116 | 3 |
696015 | 696015 | 2020-11-03 | Hudspeth | Texas | 48229 | 116 | 3 |
692698 | 692698 | 2020-11-02 | Cochran | Texas | 48079 | 116 | 2 |
689454 | 689454 | 2020-11-01 | Cochran | Texas | 48079 | 116 | 2 |
686209 | 686209 | 2020-10-31 | Cochran | Texas | 48079 | 116 | 2 |
682966 | 682966 | 2020-10-30 | Cochran | Texas | 48079 | 116 | 1 |
682980 | 682980 | 2020-10-30 | Crosby | Texas | 48107 | 116 | 7 |
660261 | 660261 | 2020-10-23 | Childress | Texas | 48075 | 116 | 0 |
624605 | 624605 | 2020-10-12 | Floyd | Texas | 48153 | 116 | 9 |
621362 | 621362 | 2020-10-11 | Floyd | Texas | 48153 | 116 | 9 |
618119 | 618119 | 2020-10-10 | Floyd | Texas | 48153 | 116 | 9 |
546894 | 546894 | 2020-09-18 | Llano | Texas | 48299 | 116 | 2 |
543657 | 543657 | 2020-09-17 | Llano | Texas | 48299 | 116 | 2 |
498298 | 498298 | 2020-09-03 | Franklin | Texas | 48159 | 116 | 6 |
495065 | 495065 | 2020-09-02 | Franklin | Texas | 48159 | 116 | 6 |
475750 | 475750 | 2020-08-27 | Montague | Texas | 48337 | 116 | 3 |
466008 | 466008 | 2020-08-24 | Jack | Texas | 48237 | 116 | 0 |
462779 | 462779 | 2020-08-23 | Jack | Texas | 48237 | 116 | 0 |
459550 | 459550 | 2020-08-22 | Jack | Texas | 48237 | 116 | 0 |
440084 | 440084 | 2020-08-16 | Blanco | Texas | 48031 | 116 | 5 |
433789 | 433789 | 2020-08-14 | Newton | Texas | 48351 | 116 | 4 |
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);