ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 336 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2203063 | 2203063 | 2022-02-10 | Stonewall | Texas | 48433 | 336 | 7 |
1998049 | 1998049 | 2021-12-09 | Edwards | Texas | 48137 | 336 | 8 |
1994798 | 1994798 | 2021-12-08 | Edwards | Texas | 48137 | 336 | 8 |
1991547 | 1991547 | 2021-12-07 | Edwards | Texas | 48137 | 336 | 8 |
1988296 | 1988296 | 2021-12-06 | Edwards | Texas | 48137 | 336 | 8 |
1985046 | 1985046 | 2021-12-05 | Edwards | Texas | 48137 | 336 | 8 |
1981796 | 1981796 | 2021-12-04 | Edwards | Texas | 48137 | 336 | 8 |
1978546 | 1978546 | 2021-12-03 | Edwards | Texas | 48137 | 336 | 8 |
1975296 | 1975296 | 2021-12-02 | Edwards | Texas | 48137 | 336 | 8 |
1972047 | 1972047 | 2021-12-01 | Edwards | Texas | 48137 | 336 | 8 |
1819418 | 1819418 | 2021-10-15 | Oldham | Texas | 48359 | 336 | 6 |
1816169 | 1816169 | 2021-10-14 | Oldham | Texas | 48359 | 336 | 6 |
1812921 | 1812921 | 2021-10-13 | Oldham | Texas | 48359 | 336 | 6 |
1809672 | 1809672 | 2021-10-12 | Oldham | Texas | 48359 | 336 | 6 |
1806422 | 1806422 | 2021-10-11 | Oldham | Texas | 48359 | 336 | 6 |
1803172 | 1803172 | 2021-10-10 | Oldham | Texas | 48359 | 336 | 6 |
1799923 | 1799923 | 2021-10-09 | Oldham | Texas | 48359 | 336 | 6 |
1728469 | 1728469 | 2021-09-17 | Schleicher | Texas | 48413 | 336 | 8 |
1725220 | 1725220 | 2021-09-16 | Schleicher | Texas | 48413 | 336 | 8 |
1702487 | 1702487 | 2021-09-09 | Shackelford | Texas | 48417 | 336 | 5 |
1621202 | 1621202 | 2021-08-15 | Kimble | Texas | 48267 | 336 | 8 |
1617954 | 1617954 | 2021-08-14 | Kimble | Texas | 48267 | 336 | 8 |
1614706 | 1614706 | 2021-08-13 | Kimble | Texas | 48267 | 336 | 8 |
1611399 | 1611399 | 2021-08-12 | Fisher | Texas | 48151 | 336 | 14 |
1601770 | 1601770 | 2021-08-09 | Real | Texas | 48385 | 336 | 13 |
1598522 | 1598522 | 2021-08-08 | Real | Texas | 48385 | 336 | 13 |
1595273 | 1595273 | 2021-08-07 | Real | Texas | 48385 | 336 | 13 |
1582126 | 1582126 | 2021-08-03 | Collingsworth | Texas | 48087 | 336 | 9 |
1578877 | 1578877 | 2021-08-02 | Collingsworth | Texas | 48087 | 336 | 9 |
1575629 | 1575629 | 2021-08-01 | Collingsworth | Texas | 48087 | 336 | 9 |
1572381 | 1572381 | 2021-07-31 | Collingsworth | Texas | 48087 | 336 | 9 |
1533407 | 1533407 | 2021-07-19 | Cochran | Texas | 48079 | 336 | 15 |
1530160 | 1530160 | 2021-07-18 | Cochran | Texas | 48079 | 336 | 15 |
1526913 | 1526913 | 2021-07-17 | Cochran | Texas | 48079 | 336 | 15 |
1523666 | 1523666 | 2021-07-16 | Cochran | Texas | 48079 | 336 | 15 |
1520418 | 1520418 | 2021-07-15 | Cochran | Texas | 48079 | 336 | 15 |
1517170 | 1517170 | 2021-07-14 | Cochran | Texas | 48079 | 336 | 15 |
1513923 | 1513923 | 2021-07-13 | Cochran | Texas | 48079 | 336 | 15 |
1510677 | 1510677 | 2021-07-12 | Cochran | Texas | 48079 | 336 | 15 |
1507430 | 1507430 | 2021-07-11 | Cochran | Texas | 48079 | 336 | 15 |
1504184 | 1504184 | 2021-07-10 | Cochran | Texas | 48079 | 336 | 15 |
1500938 | 1500938 | 2021-07-09 | Cochran | Texas | 48079 | 336 | 15 |
1452249 | 1452249 | 2021-06-24 | Cochran | Texas | 48079 | 336 | 15 |
1449003 | 1449003 | 2021-06-23 | Cochran | Texas | 48079 | 336 | 15 |
1062754 | 1062754 | 2021-02-24 | Kinney | Texas | 48271 | 336 | 6 |
1059509 | 1059509 | 2021-02-23 | Kinney | Texas | 48271 | 336 | 6 |
1026969 | 1026969 | 2021-02-13 | Culberson | Texas | 48109 | 336 | 7 |
1023724 | 1023724 | 2021-02-12 | Culberson | Texas | 48109 | 336 | 7 |
978326 | 978326 | 2021-01-29 | Hardeman | Texas | 48197 | 336 | 12 |
975139 | 975139 | 2021-01-28 | Mason | Texas | 48319 | 336 | 4 |
942686 | 942686 | 2021-01-18 | Mason | Texas | 48319 | 336 | 4 |
881096 | 881096 | 2020-12-30 | Trinity | Texas | 48455 | 336 | 9 |
809716 | 809716 | 2020-12-08 | Winkler | Texas | 48495 | 336 | 6 |
751121 | 751121 | 2020-11-20 | Eastland | Texas | 48133 | 336 | 9 |
715530 | 715530 | 2020-11-09 | Montague | Texas | 48337 | 336 | 13 |
712286 | 712286 | 2020-11-08 | Montague | Texas | 48337 | 336 | 13 |
709042 | 709042 | 2020-11-07 | Montague | Texas | 48337 | 336 | 13 |
705798 | 705798 | 2020-11-06 | Montague | Texas | 48337 | 336 | 13 |
670198 | 670198 | 2020-10-26 | Wilbarger | Texas | 48487 | 336 | 3 |
666955 | 666955 | 2020-10-25 | Wilbarger | Texas | 48487 | 336 | 3 |
663612 | 663612 | 2020-10-24 | Leon | Texas | 48289 | 336 | 11 |
663710 | 663710 | 2020-10-24 | Wilbarger | Texas | 48487 | 336 | 3 |
637551 | 637551 | 2020-10-16 | Comanche | Texas | 48093 | 336 | 5 |
634306 | 634306 | 2020-10-15 | Comanche | Texas | 48093 | 336 | 5 |
608407 | 608407 | 2020-10-07 | Gray | Texas | 48179 | 336 | 7 |
605164 | 605164 | 2020-10-06 | Gray | Texas | 48179 | 336 | 7 |
601918 | 601918 | 2020-10-05 | Gillespie | Texas | 48171 | 336 | 10 |
582523 | 582523 | 2020-09-29 | Lamb | Texas | 48279 | 336 | 22 |
579284 | 579284 | 2020-09-28 | Lamb | Texas | 48279 | 336 | 22 |
576043 | 576043 | 2020-09-27 | Lamb | Texas | 48279 | 336 | 22 |
572799 | 572799 | 2020-09-26 | Lamb | Texas | 48279 | 336 | 22 |
559808 | 559808 | 2020-09-22 | Hopkins | Texas | 48223 | 336 | 8 |
514612 | 514612 | 2020-09-08 | Upshur | Texas | 48459 | 336 | 8 |
430499 | 430499 | 2020-08-13 | Hill | Texas | 48217 | 336 | 7 |
382232 | 382232 | 2020-07-29 | Kerr | Texas | 48265 | 336 | 4 |
379015 | 379015 | 2020-07-28 | Kerr | Texas | 48265 | 336 | 4 |
334101 | 334101 | 2020-07-14 | Frio | Texas | 48163 | 336 | 0 |
330910 | 330910 | 2020-07-13 | Frio | Texas | 48163 | 336 | 0 |
327724 | 327724 | 2020-07-12 | Frio | Texas | 48163 | 336 | 0 |
311801 | 311801 | 2020-07-07 | Coryell | Texas | 48099 | 336 | 2 |
308632 | 308632 | 2020-07-06 | Coryell | Texas | 48099 | 336 | 2 |
305464 | 305464 | 2020-07-05 | Coryell | Texas | 48099 | 336 | 2 |
302300 | 302300 | 2020-07-04 | Coryell | Texas | 48099 | 336 | 2 |
299136 | 299136 | 2020-07-03 | Coryell | Texas | 48099 | 336 | 2 |
289646 | 289646 | 2020-06-30 | Caldwell | Texas | 48055 | 336 | 2 |
239702 | 239702 | 2020-06-14 | Nueces | Texas | 48355 | 336 | 3 |
236594 | 236594 | 2020-06-13 | Nueces | Texas | 48355 | 336 | 3 |
233488 | 233488 | 2020-06-12 | Nueces | Texas | 48355 | 336 | 3 |
220936 | 220936 | 2020-06-08 | Bowie | Texas | 48037 | 336 | 13 |
217844 | 217844 | 2020-06-07 | Bowie | Texas | 48037 | 336 | 13 |
205687 | 205687 | 2020-06-03 | Taylor | Texas | 48441 | 336 | 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);