ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 2744 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476329 | 2476329 | 2022-05-05 | Pecos | Texas | 48371 | 2744 | 71 |
2473072 | 2473072 | 2022-05-04 | Pecos | Texas | 48371 | 2744 | 71 |
2469816 | 2469816 | 2022-05-03 | Pecos | Texas | 48371 | 2744 | 71 |
2466560 | 2466560 | 2022-05-02 | Pecos | Texas | 48371 | 2744 | 71 |
2463305 | 2463305 | 2022-05-01 | Pecos | Texas | 48371 | 2744 | 71 |
2460049 | 2460049 | 2022-04-30 | Pecos | Texas | 48371 | 2744 | 71 |
2456793 | 2456793 | 2022-04-29 | Pecos | Texas | 48371 | 2744 | 71 |
2453537 | 2453537 | 2022-04-28 | Pecos | Texas | 48371 | 2744 | 71 |
2450281 | 2450281 | 2022-04-27 | Pecos | Texas | 48371 | 2744 | 71 |
2447024 | 2447024 | 2022-04-26 | Pecos | Texas | 48371 | 2744 | 71 |
2219137 | 2219137 | 2022-02-15 | Callahan | Texas | 48059 | 2744 | 70 |
2105262 | 2105262 | 2022-01-11 | Bandera | Texas | 48019 | 2744 | 65 |
2082745 | 2082745 | 2022-01-04 | Zavala | Texas | 48507 | 2744 | 56 |
1848562 | 1848562 | 2021-10-24 | Freestone | Texas | 48161 | 2744 | 67 |
1845312 | 1845312 | 2021-10-23 | Freestone | Texas | 48161 | 2744 | 67 |
1786952 | 1786952 | 2021-10-05 | San Jacinto | Texas | 48407 | 2744 | 68 |
1582210 | 1582210 | 2021-08-03 | Karnes | Texas | 48255 | 2744 | 37 |
1539999 | 1539999 | 2021-07-21 | Kleberg | Texas | 48273 | 2744 | 95 |
1536752 | 1536752 | 2021-07-20 | Kleberg | Texas | 48273 | 2744 | 95 |
1533431 | 1533431 | 2021-07-19 | Dimmit | Texas | 48127 | 2744 | 37 |
1530184 | 1530184 | 2021-07-18 | Dimmit | Texas | 48127 | 2744 | 37 |
1526937 | 1526937 | 2021-07-17 | Dimmit | Texas | 48127 | 2744 | 37 |
1475014 | 1475014 | 2021-07-01 | Gonzales | Texas | 48177 | 2744 | 58 |
1380880 | 1380880 | 2021-06-02 | Fayette | Texas | 48149 | 2744 | 67 |
1179575 | 1179575 | 2021-04-01 | Frio | Texas | 48163 | 2744 | 48 |
1176328 | 1176328 | 2021-03-31 | Frio | Texas | 48163 | 2744 | 48 |
975140 | 975140 | 2021-01-28 | Matagorda | Texas | 48321 | 2744 | 80 |
520857 | 520857 | 2020-09-10 | Anderson | Texas | 48001 | 2744 | 18 |
517621 | 517621 | 2020-09-09 | Anderson | Texas | 48001 | 2744 | 18 |
330986 | 330986 | 2020-07-13 | McLennan | Texas | 48309 | 2744 | 19 |
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);