ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 543 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271305 | 2271305 | 2022-03-03 | Oldham | Texas | 48359 | 543 | 6 |
2268053 | 2268053 | 2022-03-02 | Oldham | Texas | 48359 | 543 | 6 |
2264800 | 2264800 | 2022-03-01 | Oldham | Texas | 48359 | 543 | 6 |
2173667 | 2173667 | 2022-02-01 | Hardeman | Texas | 48197 | 543 | 14 |
2170415 | 2170415 | 2022-01-31 | Hardeman | Texas | 48197 | 543 | 14 |
2167161 | 2167161 | 2022-01-30 | Hardeman | Texas | 48197 | 543 | 14 |
2098886 | 2098886 | 2022-01-09 | Kinney | Texas | 48271 | 543 | 10 |
1760857 | 1760857 | 2021-09-27 | Haskell | Texas | 48207 | 543 | 30 |
1757609 | 1757609 | 2021-09-26 | Haskell | Texas | 48207 | 543 | 30 |
1754361 | 1754361 | 2021-09-25 | Haskell | Texas | 48207 | 543 | 30 |
1575700 | 1575700 | 2021-08-01 | Hudspeth | Texas | 48229 | 543 | 12 |
1572452 | 1572452 | 2021-07-31 | Hudspeth | Texas | 48229 | 543 | 12 |
1569204 | 1569204 | 2021-07-30 | Hudspeth | Texas | 48229 | 543 | 12 |
1565956 | 1565956 | 2021-07-29 | Hudspeth | Texas | 48229 | 543 | 12 |
1562708 | 1562708 | 2021-07-28 | Hudspeth | Texas | 48229 | 543 | 12 |
1559460 | 1559460 | 2021-07-27 | Hudspeth | Texas | 48229 | 543 | 12 |
1556213 | 1556213 | 2021-07-26 | Hudspeth | Texas | 48229 | 543 | 12 |
1552966 | 1552966 | 2021-07-25 | Hudspeth | Texas | 48229 | 543 | 12 |
1474977 | 1474977 | 2021-07-01 | Crane | Texas | 48103 | 543 | 12 |
1471731 | 1471731 | 2021-06-30 | Crane | Texas | 48103 | 543 | 12 |
1384206 | 1384206 | 2021-06-03 | Marion | Texas | 48315 | 543 | 33 |
1380960 | 1380960 | 2021-06-02 | Marion | Texas | 48315 | 543 | 33 |
1195785 | 1195785 | 2021-04-06 | Crosby | Texas | 48107 | 543 | 28 |
1124495 | 1124495 | 2021-03-15 | San Augustine | Texas | 48405 | 543 | 30 |
1121249 | 1121249 | 2021-03-14 | San Augustine | Texas | 48405 | 543 | 30 |
1118002 | 1118002 | 2021-03-13 | San Augustine | Texas | 48405 | 543 | 30 |
1114755 | 1114755 | 2021-03-12 | San Augustine | Texas | 48405 | 543 | 30 |
1111509 | 1111509 | 2021-03-11 | San Augustine | Texas | 48405 | 543 | 30 |
1108263 | 1108263 | 2021-03-10 | San Augustine | Texas | 48405 | 543 | 30 |
1105017 | 1105017 | 2021-03-09 | San Augustine | Texas | 48405 | 543 | 30 |
1082251 | 1082251 | 2021-03-02 | McCulloch | Texas | 48307 | 543 | 15 |
978351 | 978351 | 2021-01-29 | Jim Hogg | Texas | 48247 | 543 | 13 |
942723 | 942723 | 2021-01-18 | Red River | Texas | 48387 | 543 | 31 |
932874 | 932874 | 2021-01-15 | Franklin | Texas | 48159 | 543 | 15 |
842066 | 842066 | 2020-12-18 | La Salle | Texas | 48283 | 543 | 14 |
793261 | 793261 | 2020-12-03 | Bosque | Texas | 48035 | 543 | 16 |
741360 | 741360 | 2020-11-17 | Colorado | Texas | 48089 | 543 | 4 |
741381 | 741381 | 2020-11-17 | Duval | Texas | 48131 | 543 | 22 |
738135 | 738135 | 2020-11-16 | Duval | Texas | 48131 | 543 | 22 |
734891 | 734891 | 2020-11-15 | Duval | Texas | 48131 | 543 | 22 |
728510 | 728510 | 2020-11-13 | Nolan | Texas | 48353 | 543 | 7 |
715591 | 715591 | 2020-11-09 | Upshur | Texas | 48459 | 543 | 15 |
712347 | 712347 | 2020-11-08 | Upshur | Texas | 48459 | 543 | 15 |
679766 | 679766 | 2020-10-29 | Gaines | Texas | 48165 | 543 | 11 |
479022 | 479022 | 2020-08-28 | Scurry | Texas | 48415 | 543 | 2 |
417726 | 417726 | 2020-08-09 | Uvalde | Texas | 48463 | 543 | 10 |
106301 | 106301 | 2020-05-01 | Lubbock | Texas | 48303 | 543 | 43 |
55995 | 55995 | 2020-04-13 | Fort Bend | Texas | 48157 | 543 | 12 |
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);