ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 473 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176986 | 2176986 | 2022-02-02 | Menard | Texas | 48327 | 473 | 12 |
2173574 | 2173574 | 2022-02-01 | Armstrong | Texas | 48011 | 473 | 8 |
2170322 | 2170322 | 2022-01-31 | Armstrong | Texas | 48011 | 473 | 8 |
2144340 | 2144340 | 2022-01-23 | Culberson | Texas | 48109 | 473 | 13 |
2105328 | 2105328 | 2022-01-11 | Fisher | Texas | 48151 | 473 | 20 |
2037136 | 2037136 | 2021-12-21 | Lipscomb | Texas | 48295 | 473 | 12 |
1910259 | 1910259 | 2021-11-12 | Cochran | Texas | 48079 | 473 | 18 |
1907010 | 1907010 | 2021-11-11 | Cochran | Texas | 48079 | 473 | 18 |
1715333 | 1715333 | 2021-09-13 | Donley | Texas | 48129 | 473 | 16 |
1712087 | 1712087 | 2021-09-12 | Donley | Texas | 48129 | 473 | 16 |
1708840 | 1708840 | 2021-09-11 | Donley | Texas | 48129 | 473 | 16 |
1699186 | 1699186 | 2021-09-08 | Mason | Texas | 48319 | 473 | 7 |
1679594 | 1679594 | 2021-09-02 | Delta | Texas | 48119 | 473 | 15 |
1637410 | 1637410 | 2021-08-20 | Haskell | Texas | 48207 | 473 | 28 |
1627666 | 1627666 | 2021-08-17 | Haskell | Texas | 48207 | 473 | 28 |
1559386 | 1559386 | 2021-07-27 | Coke | Texas | 48081 | 473 | 13 |
1556139 | 1556139 | 2021-07-26 | Coke | Texas | 48081 | 473 | 13 |
1410062 | 1410062 | 2021-06-11 | Concho | Texas | 48095 | 473 | 8 |
1406987 | 1406987 | 2021-06-10 | Sutton | Texas | 48435 | 473 | 8 |
1397121 | 1397121 | 2021-06-07 | Goliad | Texas | 48175 | 473 | 13 |
1393874 | 1393874 | 2021-06-06 | Goliad | Texas | 48175 | 473 | 13 |
1390629 | 1390629 | 2021-06-05 | Goliad | Texas | 48175 | 473 | 13 |
1387384 | 1387384 | 2021-06-04 | Goliad | Texas | 48175 | 473 | 13 |
1384139 | 1384139 | 2021-06-03 | Goliad | Texas | 48175 | 473 | 13 |
1380893 | 1380893 | 2021-06-02 | Goliad | Texas | 48175 | 473 | 13 |
1163474 | 1163474 | 2021-03-27 | Sutton | Texas | 48435 | 473 | 8 |
1160225 | 1160225 | 2021-03-26 | Sutton | Texas | 48435 | 473 | 8 |
1156978 | 1156978 | 2021-03-25 | Sutton | Texas | 48435 | 473 | 8 |
1153731 | 1153731 | 2021-03-24 | Sutton | Texas | 48435 | 473 | 8 |
1150484 | 1150484 | 2021-03-23 | Sutton | Texas | 48435 | 473 | 8 |
1147237 | 1147237 | 2021-03-22 | Sutton | Texas | 48435 | 473 | 8 |
1143990 | 1143990 | 2021-03-21 | Sutton | Texas | 48435 | 473 | 8 |
1078948 | 1078948 | 2021-03-01 | Hartley | Texas | 48205 | 473 | 2 |
1075703 | 1075703 | 2021-02-28 | Hartley | Texas | 48205 | 473 | 2 |
1072457 | 1072457 | 2021-02-27 | Hartley | Texas | 48205 | 473 | 2 |
1069211 | 1069211 | 2021-02-26 | Hartley | Texas | 48205 | 473 | 2 |
1065966 | 1065966 | 2021-02-25 | Hartley | Texas | 48205 | 473 | 2 |
955672 | 955672 | 2021-01-22 | McCulloch | Texas | 48307 | 473 | 12 |
952427 | 952427 | 2021-01-21 | McCulloch | Texas | 48307 | 473 | 12 |
907036 | 907036 | 2021-01-07 | San Augustine | Texas | 48405 | 473 | 26 |
903790 | 903790 | 2021-01-06 | San Augustine | Texas | 48405 | 473 | 25 |
900545 | 900545 | 2021-01-05 | San Augustine | Texas | 48405 | 473 | 24 |
897300 | 897300 | 2021-01-04 | San Augustine | Texas | 48405 | 473 | 24 |
894054 | 894054 | 2021-01-03 | San Augustine | Texas | 48405 | 473 | 24 |
890808 | 890808 | 2021-01-02 | San Augustine | Texas | 48405 | 473 | 24 |
887561 | 887561 | 2021-01-01 | San Augustine | Texas | 48405 | 473 | 24 |
884316 | 884316 | 2020-12-31 | San Augustine | Texas | 48405 | 473 | 23 |
851816 | 851816 | 2020-12-21 | Lynn | Texas | 48305 | 473 | 11 |
848571 | 848571 | 2020-12-20 | Lynn | Texas | 48305 | 473 | 11 |
845326 | 845326 | 2020-12-19 | Lynn | Texas | 48305 | 473 | 11 |
806412 | 806412 | 2020-12-07 | Presidio | Texas | 48377 | 473 | 11 |
744692 | 744692 | 2020-11-18 | Kendall | Texas | 48259 | 473 | 11 |
718686 | 718686 | 2020-11-10 | Freestone | Texas | 48161 | 473 | 5 |
637616 | 637616 | 2020-10-16 | Hopkins | Texas | 48223 | 473 | 21 |
634371 | 634371 | 2020-10-15 | Hopkins | Texas | 48223 | 473 | 21 |
579265 | 579265 | 2020-09-28 | Jasper | Texas | 48241 | 473 | 26 |
576024 | 576024 | 2020-09-27 | Jasper | Texas | 48241 | 473 | 25 |
572780 | 572780 | 2020-09-26 | Jasper | Texas | 48241 | 473 | 25 |
569492 | 569492 | 2020-09-25 | Fayette | Texas | 48149 | 473 | 18 |
566251 | 566251 | 2020-09-24 | Fayette | Texas | 48149 | 473 | 18 |
501598 | 501598 | 2020-09-04 | Limestone | Texas | 48293 | 473 | 8 |
408043 | 408043 | 2020-08-06 | Scurry | Texas | 48415 | 473 | 1 |
350251 | 350251 | 2020-07-19 | Willacy | Texas | 48489 | 473 | 3 |
315104 | 315104 | 2020-07-08 | Parker | Texas | 48367 | 473 | 1 |
270896 | 270896 | 2020-06-24 | McLennan | Texas | 48309 | 473 | 6 |
248957 | 248957 | 2020-06-17 | Grayson | Texas | 48181 | 473 | 4 |
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);