ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 1255 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271285 | 2271285 | 2022-03-03 | McCulloch | Texas | 48307 | 1255 | 46 |
2268033 | 2268033 | 2022-03-02 | McCulloch | Texas | 48307 | 1255 | 46 |
2264780 | 2264780 | 2022-03-01 | McCulloch | Texas | 48307 | 1255 | 46 |
2261530 | 2261530 | 2022-02-28 | McCulloch | Texas | 48307 | 1255 | 46 |
2258279 | 2258279 | 2022-02-27 | McCulloch | Texas | 48307 | 1255 | 46 |
2255028 | 2255028 | 2022-02-26 | McCulloch | Texas | 48307 | 1255 | 46 |
2251777 | 2251777 | 2022-02-25 | McCulloch | Texas | 48307 | 1255 | 46 |
2189933 | 2189933 | 2022-02-06 | Hartley | Texas | 48205 | 1255 | 3 |
1998057 | 1998057 | 2021-12-09 | Floyd | Texas | 48153 | 1255 | 40 |
1926719 | 1926719 | 2021-11-17 | Yoakum | Texas | 48501 | 1255 | 34 |
1923469 | 1923469 | 2021-11-16 | Yoakum | Texas | 48501 | 1255 | 34 |
1920220 | 1920220 | 2021-11-15 | Yoakum | Texas | 48501 | 1255 | 34 |
1916970 | 1916970 | 2021-11-14 | Yoakum | Texas | 48501 | 1255 | 34 |
1913485 | 1913485 | 2021-11-13 | Blanco | Texas | 48031 | 1255 | 28 |
1913720 | 1913720 | 2021-11-13 | Yoakum | Texas | 48501 | 1255 | 34 |
1910235 | 1910235 | 2021-11-12 | Blanco | Texas | 48031 | 1255 | 28 |
1910470 | 1910470 | 2021-11-12 | Yoakum | Texas | 48501 | 1255 | 34 |
1906986 | 1906986 | 2021-11-11 | Blanco | Texas | 48031 | 1255 | 28 |
1907221 | 1907221 | 2021-11-11 | Yoakum | Texas | 48501 | 1255 | 34 |
1780266 | 1780266 | 2021-10-03 | Blanco | Texas | 48031 | 1255 | 27 |
1777016 | 1777016 | 2021-10-02 | Blanco | Texas | 48031 | 1255 | 27 |
1770597 | 1770597 | 2021-09-30 | Hamilton | Texas | 48193 | 1255 | 29 |
1624494 | 1624494 | 2021-08-16 | Ochiltree | Texas | 48357 | 1255 | 29 |
1621247 | 1621247 | 2021-08-15 | Ochiltree | Texas | 48357 | 1255 | 29 |
1617999 | 1617999 | 2021-08-14 | Ochiltree | Texas | 48357 | 1255 | 29 |
1361335 | 1361335 | 2021-05-27 | Aransas | Texas | 48007 | 1255 | 41 |
1315908 | 1315908 | 2021-05-13 | Camp | Texas | 48063 | 1255 | 43 |
1312696 | 1312696 | 2021-05-12 | Duval | Texas | 48131 | 1255 | 41 |
1215406 | 1215406 | 2021-04-12 | Parmer | Texas | 48369 | 1255 | 35 |
1212159 | 1212159 | 2021-04-11 | Parmer | Texas | 48369 | 1255 | 35 |
1208910 | 1208910 | 2021-04-10 | Parmer | Texas | 48369 | 1255 | 35 |
793480 | 793480 | 2020-12-03 | Waller | Texas | 48473 | 1255 | 19 |
725324 | 725324 | 2020-11-12 | Van Zandt | Texas | 48467 | 1255 | 31 |
556479 | 556479 | 2020-09-21 | Bowie | Texas | 48037 | 1255 | 71 |
546781 | 546781 | 2020-09-18 | Chambers | Texas | 48071 | 1255 | 15 |
543544 | 543544 | 2020-09-17 | Chambers | Texas | 48071 | 1255 | 15 |
498246 | 498246 | 2020-09-03 | Caldwell | Texas | 48055 | 1255 | 34 |
245861 | 245861 | 2020-06-16 | Hidalgo | Texas | 48215 | 1255 | 17 |
239615 | 239615 | 2020-06-14 | Galveston | Texas | 48167 | 1255 | 40 |
181010 | 181010 | 2020-05-26 | Denton | Texas | 48121 | 1255 | 30 |
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);