ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 1308 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502366 | 2502366 | 2022-05-13 | McCulloch | Texas | 48307 | 1308 | 47 |
2499108 | 2499108 | 2022-05-12 | McCulloch | Texas | 48307 | 1308 | 47 |
2495850 | 2495850 | 2022-05-11 | McCulloch | Texas | 48307 | 1308 | 47 |
2492592 | 2492592 | 2022-05-10 | McCulloch | Texas | 48307 | 1308 | 47 |
2489334 | 2489334 | 2022-05-09 | McCulloch | Texas | 48307 | 1308 | 47 |
2098848 | 2098848 | 2022-01-09 | Hansford | Texas | 48195 | 1308 | 27 |
1997996 | 1997996 | 2021-12-09 | Blanco | Texas | 48031 | 1308 | 28 |
1913717 | 1913717 | 2021-11-13 | Winkler | Texas | 48495 | 1308 | 29 |
1910467 | 1910467 | 2021-11-12 | Winkler | Texas | 48495 | 1308 | 29 |
1877820 | 1877820 | 2021-11-02 | Hamilton | Texas | 48193 | 1308 | 29 |
1874571 | 1874571 | 2021-11-01 | Hamilton | Texas | 48193 | 1308 | 29 |
1871322 | 1871322 | 2021-10-31 | Hamilton | Texas | 48193 | 1308 | 29 |
1868073 | 1868073 | 2021-10-30 | Hamilton | Texas | 48193 | 1308 | 29 |
1864824 | 1864824 | 2021-10-29 | Hamilton | Texas | 48193 | 1308 | 29 |
1793439 | 1793439 | 2021-10-07 | Red River | Texas | 48387 | 1308 | 47 |
1738051 | 1738051 | 2021-09-20 | Clay | Texas | 48077 | 1308 | 21 |
1734801 | 1734801 | 2021-09-19 | Clay | Texas | 48077 | 1308 | 21 |
1731551 | 1731551 | 2021-09-18 | Clay | Texas | 48077 | 1308 | 21 |
1692761 | 1692761 | 2021-09-06 | Trinity | Texas | 48455 | 1308 | 40 |
1611353 | 1611353 | 2021-08-12 | Callahan | Texas | 48059 | 1308 | 41 |
1539928 | 1539928 | 2021-07-21 | Duval | Texas | 48131 | 1308 | 42 |
1497852 | 1497852 | 2021-07-08 | Runnels | Texas | 48399 | 1308 | 39 |
1494605 | 1494605 | 2021-07-07 | Runnels | Texas | 48399 | 1308 | 39 |
1491358 | 1491358 | 2021-07-06 | Runnels | Texas | 48399 | 1308 | 39 |
1488111 | 1488111 | 2021-07-05 | Runnels | Texas | 48399 | 1308 | 39 |
1484864 | 1484864 | 2021-07-04 | Runnels | Texas | 48399 | 1308 | 39 |
1481618 | 1481618 | 2021-07-03 | Runnels | Texas | 48399 | 1308 | 39 |
1478371 | 1478371 | 2021-07-02 | Runnels | Texas | 48399 | 1308 | 39 |
1475125 | 1475125 | 2021-07-01 | Runnels | Texas | 48399 | 1308 | 39 |
1471879 | 1471879 | 2021-06-30 | Runnels | Texas | 48399 | 1308 | 40 |
1468634 | 1468634 | 2021-06-29 | Runnels | Texas | 48399 | 1308 | 40 |
1465389 | 1465389 | 2021-06-28 | Runnels | Texas | 48399 | 1308 | 40 |
1462144 | 1462144 | 2021-06-27 | Runnels | Texas | 48399 | 1308 | 40 |
1458899 | 1458899 | 2021-06-26 | Runnels | Texas | 48399 | 1308 | 40 |
1455654 | 1455654 | 2021-06-25 | Runnels | Texas | 48399 | 1308 | 40 |
1452409 | 1452409 | 2021-06-24 | Runnels | Texas | 48399 | 1308 | 40 |
1449163 | 1449163 | 2021-06-23 | Runnels | Texas | 48399 | 1308 | 40 |
1445918 | 1445918 | 2021-06-22 | Runnels | Texas | 48399 | 1308 | 40 |
1429673 | 1429673 | 2021-06-17 | Parmer | Texas | 48369 | 1308 | 35 |
1147029 | 1147029 | 2021-03-22 | Bandera | Texas | 48019 | 1308 | 27 |
1143782 | 1143782 | 2021-03-21 | Bandera | Texas | 48019 | 1308 | 27 |
1140535 | 1140535 | 2021-03-20 | Bandera | Texas | 48019 | 1308 | 27 |
945849 | 945849 | 2021-01-19 | Falls | Texas | 48145 | 1308 | 22 |
942602 | 942602 | 2021-01-18 | Falls | Texas | 48145 | 1308 | 22 |
939357 | 939357 | 2021-01-17 | Falls | Texas | 48145 | 1308 | 22 |
936112 | 936112 | 2021-01-16 | Falls | Texas | 48145 | 1308 | 22 |
900489 | 900489 | 2021-01-05 | Limestone | Texas | 48293 | 1308 | 29 |
848420 | 848420 | 2020-12-20 | Andrews | Texas | 48003 | 1308 | 22 |
845175 | 845175 | 2020-12-19 | Andrews | Texas | 48003 | 1308 | 21 |
841929 | 841929 | 2020-12-18 | Andrews | Texas | 48003 | 1308 | 19 |
819263 | 819263 | 2020-12-11 | DeWitt | Texas | 48123 | 1308 | 46 |
816017 | 816017 | 2020-12-10 | DeWitt | Texas | 48123 | 1308 | 46 |
812771 | 812771 | 2020-12-09 | DeWitt | Texas | 48123 | 1308 | 46 |
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);