ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 1743 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2248562 | 2248562 | 2022-02-24 | Refugio | Texas | 48391 | 1743 | 31 |
2150845 | 2150845 | 2022-01-25 | Crosby | Texas | 48107 | 1743 | 44 |
2150959 | 2150959 | 2022-01-25 | Mitchell | Texas | 48335 | 1743 | 45 |
2102186 | 2102186 | 2022-01-10 | Parmer | Texas | 48369 | 1743 | 45 |
2092436 | 2092436 | 2022-01-07 | Rains | Texas | 48379 | 1743 | 49 |
2033910 | 2033910 | 2021-12-20 | Morris | Texas | 48343 | 1743 | 58 |
2030660 | 2030660 | 2021-12-19 | Morris | Texas | 48343 | 1743 | 58 |
1751247 | 1751247 | 2021-09-24 | Ward | Texas | 48475 | 1743 | 26 |
1656845 | 1656845 | 2021-08-26 | Comanche | Texas | 48093 | 1743 | 54 |
1533517 | 1533517 | 2021-07-19 | Llano | Texas | 48299 | 1743 | 54 |
1530270 | 1530270 | 2021-07-18 | Llano | Texas | 48299 | 1743 | 54 |
1527023 | 1527023 | 2021-07-17 | Llano | Texas | 48299 | 1743 | 53 |
1452392 | 1452392 | 2021-06-24 | Panola | Texas | 48365 | 1743 | 75 |
1429533 | 1429533 | 2021-06-17 | Colorado | Texas | 48089 | 1743 | 32 |
1400323 | 1400323 | 2021-06-08 | Colorado | Texas | 48089 | 1743 | 32 |
1397078 | 1397078 | 2021-06-07 | Colorado | Texas | 48089 | 1743 | 32 |
1387341 | 1387341 | 2021-06-04 | Colorado | Texas | 48089 | 1743 | 32 |
1384096 | 1384096 | 2021-06-03 | Colorado | Texas | 48089 | 1743 | 32 |
1380850 | 1380850 | 2021-06-02 | Colorado | Texas | 48089 | 1743 | 32 |
1105067 | 1105067 | 2021-03-09 | Zapata | Texas | 48505 | 1743 | 29 |
897342 | 897342 | 2021-01-04 | Willacy | Texas | 48489 | 1743 | 63 |
894096 | 894096 | 2021-01-03 | Willacy | Texas | 48489 | 1743 | 63 |
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);