ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 1070 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492454 | 2492454 | 2022-05-10 | Brewster | Texas | 48043 | 1070 | 29 |
2489196 | 2489196 | 2022-05-09 | Brewster | Texas | 48043 | 1070 | 29 |
2485939 | 2485939 | 2022-05-08 | Brewster | Texas | 48043 | 1070 | 29 |
2482681 | 2482681 | 2022-05-07 | Brewster | Texas | 48043 | 1070 | 29 |
2479423 | 2479423 | 2022-05-06 | Brewster | Texas | 48043 | 1070 | 29 |
2319960 | 2319960 | 2022-03-18 | Concho | Texas | 48095 | 1070 | 11 |
2316706 | 2316706 | 2022-03-17 | Concho | Texas | 48095 | 1070 | 11 |
2313453 | 2313453 | 2022-03-16 | Concho | Texas | 48095 | 1070 | 11 |
2310200 | 2310200 | 2022-03-15 | Concho | Texas | 48095 | 1070 | 11 |
2306947 | 2306947 | 2022-03-14 | Concho | Texas | 48095 | 1070 | 11 |
2303696 | 2303696 | 2022-03-13 | Concho | Texas | 48095 | 1070 | 11 |
2300444 | 2300444 | 2022-03-12 | Concho | Texas | 48095 | 1070 | 11 |
2297192 | 2297192 | 2022-03-11 | Concho | Texas | 48095 | 1070 | 11 |
2297209 | 2297209 | 2022-03-11 | Donley | Texas | 48129 | 1070 | 26 |
2293940 | 2293940 | 2022-03-10 | Concho | Texas | 48095 | 1070 | 11 |
2290688 | 2290688 | 2022-03-09 | Concho | Texas | 48095 | 1070 | 11 |
2287436 | 2287436 | 2022-03-08 | Concho | Texas | 48095 | 1070 | 11 |
2284184 | 2284184 | 2022-03-07 | Concho | Texas | 48095 | 1070 | 11 |
2280932 | 2280932 | 2022-03-06 | Concho | Texas | 48095 | 1070 | 11 |
2277679 | 2277679 | 2022-03-05 | Concho | Texas | 48095 | 1070 | 11 |
2274426 | 2274426 | 2022-03-04 | Concho | Texas | 48095 | 1070 | 11 |
2274629 | 2274629 | 2022-03-04 | Yoakum | Texas | 48501 | 1070 | 41 |
2271376 | 2271376 | 2022-03-03 | Yoakum | Texas | 48501 | 1070 | 41 |
2020744 | 2020744 | 2021-12-16 | Bailey | Texas | 48017 | 1070 | 28 |
1809514 | 1809514 | 2021-10-12 | Brewster | Texas | 48043 | 1070 | 19 |
1760851 | 1760851 | 2021-09-27 | Hansford | Texas | 48195 | 1070 | 26 |
1757603 | 1757603 | 2021-09-26 | Hansford | Texas | 48195 | 1070 | 26 |
1754355 | 1754355 | 2021-09-25 | Hansford | Texas | 48195 | 1070 | 26 |
1747837 | 1747837 | 2021-09-23 | Floyd | Texas | 48153 | 1070 | 33 |
1689364 | 1689364 | 2021-09-05 | Franklin | Texas | 48159 | 1070 | 27 |
1533402 | 1533402 | 2021-07-19 | Castro | Texas | 48069 | 1070 | 32 |
1530155 | 1530155 | 2021-07-18 | Castro | Texas | 48069 | 1070 | 32 |
1526908 | 1526908 | 2021-07-17 | Castro | Texas | 48069 | 1070 | 32 |
1468469 | 1468469 | 2021-06-29 | Castro | Texas | 48069 | 1070 | 32 |
1114756 | 1114756 | 2021-03-12 | San Jacinto | Texas | 48407 | 1070 | 30 |
1017417 | 1017417 | 2021-02-10 | Ward | Texas | 48475 | 1070 | 18 |
854981 | 854981 | 2020-12-22 | Falls | Texas | 48145 | 1070 | 16 |
634370 | 634370 | 2020-10-15 | Hood | Texas | 48221 | 1070 | 33 |
605163 | 605163 | 2020-10-06 | Gonzales | Texas | 48177 | 1070 | 18 |
543601 | 543601 | 2020-09-17 | Grimes | Texas | 48185 | 1070 | 31 |
466050 | 466050 | 2020-08-24 | Medina | Texas | 48325 | 1070 | 34 |
398365 | 398365 | 2020-08-03 | Parker | Texas | 48367 | 1070 | 12 |
395149 | 395149 | 2020-08-02 | Parker | Texas | 48367 | 1070 | 12 |
391779 | 391779 | 2020-08-01 | Caldwell | Texas | 48055 | 1070 | 23 |
391933 | 391933 | 2020-08-01 | Parker | Texas | 48367 | 1070 | 12 |
363044 | 363044 | 2020-07-23 | Taylor | Texas | 48441 | 1070 | 13 |
318258 | 318258 | 2020-07-09 | Midland | Texas | 48329 | 1070 | 19 |
302252 | 302252 | 2020-07-04 | Anderson | Texas | 48001 | 1070 | 2 |
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);