ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
95 rows where cases = 568 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2170392 | 2170392 | 2022-01-31 | Fisher | Texas | 48151 | 568 | 20 |
2167138 | 2167138 | 2022-01-30 | Fisher | Texas | 48151 | 568 | 20 |
1880984 | 1880984 | 2021-11-03 | Baylor | Texas | 48023 | 568 | 24 |
1855137 | 1855137 | 2021-10-26 | Mason | Texas | 48319 | 568 | 7 |
1829050 | 1829050 | 2021-10-18 | Donley | Texas | 48129 | 568 | 18 |
1825801 | 1825801 | 2021-10-17 | Donley | Texas | 48129 | 568 | 18 |
1822552 | 1822552 | 2021-10-16 | Donley | Texas | 48129 | 568 | 18 |
1819303 | 1819303 | 2021-10-15 | Donley | Texas | 48129 | 568 | 18 |
1721852 | 1721852 | 2021-09-15 | Goliad | Texas | 48175 | 568 | 19 |
1718604 | 1718604 | 2021-09-14 | Goliad | Texas | 48175 | 568 | 19 |
1715356 | 1715356 | 2021-09-13 | Goliad | Texas | 48175 | 568 | 19 |
1712110 | 1712110 | 2021-09-12 | Goliad | Texas | 48175 | 568 | 19 |
1712137 | 1712137 | 2021-09-12 | Hudspeth | Texas | 48229 | 568 | 12 |
1708863 | 1708863 | 2021-09-11 | Goliad | Texas | 48175 | 568 | 19 |
1708890 | 1708890 | 2021-09-11 | Hudspeth | Texas | 48229 | 568 | 12 |
1705616 | 1705616 | 2021-09-10 | Goliad | Texas | 48175 | 568 | 19 |
1705643 | 1705643 | 2021-09-10 | Hudspeth | Texas | 48229 | 568 | 12 |
1702366 | 1702366 | 2021-09-09 | Goliad | Texas | 48175 | 568 | 19 |
1699117 | 1699117 | 2021-09-08 | Goliad | Texas | 48175 | 568 | 19 |
1695869 | 1695869 | 2021-09-07 | Goliad | Texas | 48175 | 568 | 19 |
1692621 | 1692621 | 2021-09-06 | Goliad | Texas | 48175 | 568 | 18 |
1689372 | 1689372 | 2021-09-05 | Goliad | Texas | 48175 | 568 | 18 |
1686122 | 1686122 | 2021-09-04 | Goliad | Texas | 48175 | 568 | 18 |
1682871 | 1682871 | 2021-09-03 | Goliad | Texas | 48175 | 568 | 17 |
1679621 | 1679621 | 2021-09-02 | Goliad | Texas | 48175 | 568 | 17 |
1676373 | 1676373 | 2021-09-01 | Goliad | Texas | 48175 | 568 | 17 |
1673126 | 1673126 | 2021-08-31 | Goliad | Texas | 48175 | 568 | 17 |
1669878 | 1669878 | 2021-08-30 | Goliad | Texas | 48175 | 568 | 17 |
1666631 | 1666631 | 2021-08-29 | Goliad | Texas | 48175 | 568 | 17 |
1663383 | 1663383 | 2021-08-28 | Goliad | Texas | 48175 | 568 | 17 |
1660135 | 1660135 | 2021-08-27 | Goliad | Texas | 48175 | 568 | 17 |
1656886 | 1656886 | 2021-08-26 | Goliad | Texas | 48175 | 568 | 17 |
1653639 | 1653639 | 2021-08-25 | Goliad | Texas | 48175 | 568 | 17 |
1650392 | 1650392 | 2021-08-24 | Goliad | Texas | 48175 | 568 | 17 |
1549656 | 1549656 | 2021-07-24 | Crane | Texas | 48103 | 568 | 12 |
1546409 | 1546409 | 2021-07-23 | Crane | Texas | 48103 | 568 | 12 |
1400520 | 1400520 | 2021-06-08 | Wheeler | Texas | 48483 | 568 | 12 |
1397275 | 1397275 | 2021-06-07 | Wheeler | Texas | 48483 | 568 | 12 |
1394028 | 1394028 | 2021-06-06 | Wheeler | Texas | 48483 | 568 | 12 |
1390783 | 1390783 | 2021-06-05 | Wheeler | Texas | 48483 | 568 | 11 |
1387538 | 1387538 | 2021-06-04 | Wheeler | Texas | 48483 | 568 | 11 |
1384293 | 1384293 | 2021-06-03 | Wheeler | Texas | 48483 | 568 | 11 |
1381047 | 1381047 | 2021-06-02 | Wheeler | Texas | 48483 | 568 | 11 |
1351835 | 1351835 | 2021-05-24 | Wheeler | Texas | 48483 | 568 | 11 |
1348589 | 1348589 | 2021-05-23 | Wheeler | Texas | 48483 | 568 | 11 |
1345341 | 1345341 | 2021-05-22 | Wheeler | Texas | 48483 | 568 | 11 |
1342093 | 1342093 | 2021-05-21 | Wheeler | Texas | 48483 | 568 | 11 |
1338845 | 1338845 | 2021-05-20 | Wheeler | Texas | 48483 | 568 | 11 |
1277122 | 1277122 | 2021-05-01 | San Augustine | Texas | 48405 | 568 | 32 |
1273875 | 1273875 | 2021-04-30 | San Augustine | Texas | 48405 | 568 | 32 |
1270628 | 1270628 | 2021-04-29 | San Augustine | Texas | 48405 | 568 | 32 |
1267381 | 1267381 | 2021-04-28 | San Augustine | Texas | 48405 | 568 | 32 |
1264134 | 1264134 | 2021-04-27 | San Augustine | Texas | 48405 | 568 | 32 |
1260844 | 1260844 | 2021-04-26 | McCulloch | Texas | 48307 | 568 | 19 |
1260887 | 1260887 | 2021-04-26 | San Augustine | Texas | 48405 | 568 | 32 |
1257640 | 1257640 | 2021-04-25 | San Augustine | Texas | 48405 | 568 | 32 |
1254393 | 1254393 | 2021-04-24 | San Augustine | Texas | 48405 | 568 | 32 |
1251146 | 1251146 | 2021-04-23 | San Augustine | Texas | 48405 | 568 | 32 |
1228372 | 1228372 | 2021-04-16 | McCulloch | Texas | 48307 | 568 | 19 |
1182900 | 1182900 | 2021-04-02 | McCulloch | Texas | 48307 | 568 | 19 |
1179653 | 1179653 | 2021-04-01 | McCulloch | Texas | 48307 | 568 | 19 |
1069161 | 1069161 | 2021-02-26 | Crockett | Texas | 48105 | 568 | 15 |
1065916 | 1065916 | 2021-02-25 | Crockett | Texas | 48105 | 568 | 15 |
1062671 | 1062671 | 2021-02-24 | Crockett | Texas | 48105 | 568 | 15 |
1062794 | 1062794 | 2021-02-24 | Newton | Texas | 48351 | 568 | 30 |
1004321 | 1004321 | 2021-02-06 | Jim Hogg | Texas | 48247 | 568 | 13 |
936192 | 936192 | 2021-01-16 | Lynn | Texas | 48305 | 568 | 17 |
932947 | 932947 | 2021-01-15 | Lynn | Texas | 48305 | 568 | 17 |
929702 | 929702 | 2021-01-14 | Lynn | Texas | 48305 | 568 | 15 |
880878 | 880878 | 2020-12-30 | Bandera | Texas | 48019 | 568 | 12 |
812730 | 812730 | 2020-12-09 | Bosque | Texas | 48035 | 568 | 16 |
812833 | 812833 | 2020-12-09 | Jasper | Texas | 48241 | 568 | 38 |
809589 | 809589 | 2020-12-08 | Jasper | Texas | 48241 | 568 | 37 |
751305 | 751305 | 2020-11-20 | Yoakum | Texas | 48501 | 568 | 10 |
725300 | 725300 | 2020-11-12 | Shelby | Texas | 48419 | 568 | 33 |
702640 | 702640 | 2020-11-05 | Zavala | Texas | 48507 | 568 | 19 |
699397 | 699397 | 2020-11-04 | Zavala | Texas | 48507 | 568 | 19 |
624655 | 624655 | 2020-10-12 | Jones | Texas | 48253 | 568 | 0 |
621412 | 621412 | 2020-10-11 | Jones | Texas | 48253 | 568 | 0 |
618169 | 618169 | 2020-10-10 | Jones | Texas | 48253 | 568 | 0 |
601959 | 601959 | 2020-10-05 | Jones | Texas | 48253 | 568 | 0 |
598716 | 598716 | 2020-10-04 | Jones | Texas | 48253 | 568 | 0 |
595473 | 595473 | 2020-10-03 | Jones | Texas | 48253 | 568 | 0 |
579290 | 579290 | 2020-09-28 | Limestone | Texas | 48293 | 568 | 13 |
576049 | 576049 | 2020-09-27 | Limestone | Texas | 48293 | 568 | 13 |
572805 | 572805 | 2020-09-26 | Limestone | Texas | 48293 | 568 | 13 |
553455 | 553455 | 2020-09-20 | Van Zandt | Texas | 48467 | 568 | 18 |
550216 | 550216 | 2020-09-19 | Van Zandt | Texas | 48467 | 568 | 18 |
537280 | 537280 | 2020-09-15 | Wilson | Texas | 48493 | 568 | 26 |
488526 | 488526 | 2020-08-31 | Atascosa | Texas | 48013 | 568 | 27 |
485293 | 485293 | 2020-08-30 | Atascosa | Texas | 48013 | 568 | 27 |
482058 | 482058 | 2020-08-29 | Atascosa | Texas | 48013 | 568 | 27 |
446767 | 446767 | 2020-08-18 | Wise | Texas | 48497 | 568 | 10 |
375908 | 375908 | 2020-07-27 | Willacy | Texas | 48489 | 568 | 16 |
356514 | 356514 | 2020-07-21 | Hardin | Texas | 48199 | 568 | 5 |
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);