ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 432 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2206217 | 2206217 | 2022-02-11 | Irion | Texas | 48235 | 432 | 3 |
2134727 | 2134727 | 2022-01-20 | Schleicher | Texas | 48413 | 432 | 9 |
1975271 | 1975271 | 2021-12-02 | Collingsworth | Texas | 48087 | 432 | 11 |
1929866 | 1929866 | 2021-11-18 | Lipscomb | Texas | 48295 | 432 | 12 |
1926616 | 1926616 | 2021-11-17 | Lipscomb | Texas | 48295 | 432 | 12 |
1712215 | 1712215 | 2021-09-12 | Real | Texas | 48385 | 432 | 14 |
1708968 | 1708968 | 2021-09-11 | Real | Texas | 48385 | 432 | 14 |
1705721 | 1705721 | 2021-09-10 | Real | Texas | 48385 | 432 | 14 |
1595237 | 1595237 | 2021-08-07 | Mason | Texas | 48319 | 432 | 6 |
1591988 | 1591988 | 2021-08-06 | Mason | Texas | 48319 | 432 | 6 |
1588739 | 1588739 | 2021-08-05 | Mason | Texas | 48319 | 432 | 6 |
1578898 | 1578898 | 2021-08-02 | Donley | Texas | 48129 | 432 | 15 |
1575650 | 1575650 | 2021-08-01 | Donley | Texas | 48129 | 432 | 15 |
1572402 | 1572402 | 2021-07-31 | Donley | Texas | 48129 | 432 | 15 |
1569154 | 1569154 | 2021-07-30 | Donley | Texas | 48129 | 432 | 15 |
1192516 | 1192516 | 2021-04-05 | Carson | Texas | 48065 | 432 | 14 |
1189267 | 1189267 | 2021-04-04 | Carson | Texas | 48065 | 432 | 14 |
1186020 | 1186020 | 2021-04-03 | Carson | Texas | 48065 | 432 | 14 |
1182773 | 1182773 | 2021-04-02 | Carson | Texas | 48065 | 432 | 14 |
1179526 | 1179526 | 2021-04-01 | Carson | Texas | 48065 | 432 | 14 |
1176279 | 1176279 | 2021-03-31 | Carson | Texas | 48065 | 432 | 14 |
1176342 | 1176342 | 2021-03-31 | Hall | Texas | 48191 | 432 | 14 |
1173095 | 1173095 | 2021-03-30 | Hall | Texas | 48191 | 432 | 14 |
1169848 | 1169848 | 2021-03-29 | Hall | Texas | 48191 | 432 | 14 |
1166600 | 1166600 | 2021-03-28 | Hall | Texas | 48191 | 432 | 14 |
1163352 | 1163352 | 2021-03-27 | Hall | Texas | 48191 | 432 | 14 |
1134121 | 1134121 | 2021-03-18 | Goliad | Texas | 48175 | 432 | 13 |
1130873 | 1130873 | 2021-03-17 | Goliad | Texas | 48175 | 432 | 13 |
1101672 | 1101672 | 2021-03-08 | Haskell | Texas | 48207 | 432 | 24 |
1098426 | 1098426 | 2021-03-07 | Haskell | Texas | 48207 | 432 | 23 |
1095178 | 1095178 | 2021-03-06 | Haskell | Texas | 48207 | 432 | 23 |
1091932 | 1091932 | 2021-03-05 | Haskell | Texas | 48207 | 432 | 23 |
1088686 | 1088686 | 2021-03-04 | Haskell | Texas | 48207 | 432 | 23 |
1085441 | 1085441 | 2021-03-03 | Haskell | Texas | 48207 | 432 | 23 |
1082195 | 1082195 | 2021-03-02 | Haskell | Texas | 48207 | 432 | 23 |
1078949 | 1078949 | 2021-03-01 | Haskell | Texas | 48207 | 432 | 22 |
1075704 | 1075704 | 2021-02-28 | Haskell | Texas | 48207 | 432 | 22 |
1072458 | 1072458 | 2021-02-27 | Haskell | Texas | 48207 | 432 | 22 |
978445 | 978445 | 2021-01-29 | Sutton | Texas | 48435 | 432 | 6 |
968647 | 968647 | 2021-01-26 | Marion | Texas | 48315 | 432 | 21 |
903793 | 903793 | 2021-01-06 | San Saba | Texas | 48411 | 432 | 14 |
812751 | 812751 | 2020-12-09 | Clay | Texas | 48077 | 432 | 8 |
790236 | 790236 | 2020-12-02 | Ward | Texas | 48475 | 432 | 5 |
741347 | 741347 | 2020-11-17 | Camp | Texas | 48063 | 432 | 15 |
738101 | 738101 | 2020-11-16 | Camp | Texas | 48063 | 432 | 14 |
660249 | 660249 | 2020-10-23 | Burleson | Texas | 48051 | 432 | 6 |
660408 | 660408 | 2020-10-23 | Pecos | Texas | 48371 | 432 | 6 |
631097 | 631097 | 2020-10-14 | Gaines | Texas | 48165 | 432 | 10 |
427394 | 427394 | 2020-08-12 | Van Zandt | Texas | 48467 | 432 | 4 |
378911 | 378911 | 2020-07-28 | Calhoun | Texas | 48057 | 432 | 3 |
378964 | 378964 | 2020-07-28 | Frio | Texas | 48163 | 432 | 5 |
346898 | 346898 | 2020-07-18 | Gonzales | Texas | 48177 | 432 | 4 |
343669 | 343669 | 2020-07-17 | Deaf Smith | Texas | 48117 | 432 | 17 |
211663 | 211663 | 2020-06-05 | Bell | Texas | 48027 | 432 | 5 |
111942 | 111942 | 2020-05-03 | Cameron | Texas | 48061 | 432 | 18 |
45354 | 45354 | 2020-04-09 | Fort Bend | Texas | 48157 | 432 | 7 |
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);