ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 628 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2160686 | 2160686 | 2022-01-28 | Kimble | Texas | 48267 | 628 | 12 |
2089006 | 2089006 | 2022-01-06 | Baylor | Texas | 48023 | 628 | 25 |
2056601 | 2056601 | 2021-12-27 | Hudspeth | Texas | 48229 | 628 | 14 |
2040334 | 2040334 | 2021-12-22 | Hall | Texas | 48191 | 628 | 15 |
1988458 | 1988458 | 2021-12-06 | Upton | Texas | 48461 | 628 | 15 |
1985208 | 1985208 | 2021-12-05 | Upton | Texas | 48461 | 628 | 15 |
1981958 | 1981958 | 2021-12-04 | Upton | Texas | 48461 | 628 | 15 |
1942780 | 1942780 | 2021-11-22 | Delta | Texas | 48119 | 628 | 22 |
1939530 | 1939530 | 2021-11-21 | Delta | Texas | 48119 | 628 | 22 |
1936280 | 1936280 | 2021-11-20 | Delta | Texas | 48119 | 628 | 22 |
1591950 | 1591950 | 2021-08-06 | Jack | Texas | 48237 | 628 | 16 |
1491311 | 1491311 | 2021-07-06 | Lynn | Texas | 48305 | 628 | 24 |
1488064 | 1488064 | 2021-07-05 | Lynn | Texas | 48305 | 628 | 24 |
1484817 | 1484817 | 2021-07-04 | Lynn | Texas | 48305 | 628 | 24 |
1481571 | 1481571 | 2021-07-03 | Lynn | Texas | 48305 | 628 | 24 |
1478324 | 1478324 | 2021-07-02 | Lynn | Texas | 48305 | 628 | 24 |
1475078 | 1475078 | 2021-07-01 | Lynn | Texas | 48305 | 628 | 24 |
1020618 | 1020618 | 2021-02-11 | Red River | Texas | 48387 | 628 | 34 |
942606 | 942606 | 2021-01-18 | Floyd | Texas | 48153 | 628 | 25 |
939361 | 939361 | 2021-01-17 | Floyd | Texas | 48153 | 628 | 25 |
936116 | 936116 | 2021-01-16 | Floyd | Texas | 48153 | 628 | 25 |
757573 | 757573 | 2020-11-22 | Burleson | Texas | 48051 | 628 | 8 |
754326 | 754326 | 2020-11-21 | Burleson | Texas | 48051 | 628 | 7 |
715396 | 715396 | 2020-11-09 | Cass | Texas | 48067 | 628 | 31 |
712152 | 712152 | 2020-11-08 | Cass | Texas | 48067 | 628 | 31 |
699285 | 699285 | 2020-11-04 | Lamb | Texas | 48279 | 628 | 25 |
676442 | 676442 | 2020-10-28 | Andrews | Texas | 48003 | 628 | 10 |
673199 | 673199 | 2020-10-27 | Andrews | Texas | 48003 | 628 | 10 |
627951 | 627951 | 2020-10-13 | Palo Pinto | Texas | 48363 | 628 | 17 |
559933 | 559933 | 2020-09-22 | Washington | Texas | 48477 | 628 | 48 |
472377 | 472377 | 2020-08-26 | Burnet | Texas | 48053 | 628 | 12 |
401526 | 401526 | 2020-08-04 | Jones | Texas | 48253 | 628 | 0 |
398285 | 398285 | 2020-08-03 | Harrison | Texas | 48203 | 628 | 35 |
375851 | 375851 | 2020-07-27 | Polk | Texas | 48373 | 628 | 5 |
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);