ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 1805 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2281099 | 2281099 | 2022-03-06 | Stephens | Texas | 48429 | 1805 | 45 |
2277846 | 2277846 | 2022-03-05 | Stephens | Texas | 48429 | 1805 | 45 |
2196392 | 2196392 | 2022-02-08 | Crosby | Texas | 48107 | 1805 | 44 |
2193138 | 2193138 | 2022-02-07 | Crosby | Texas | 48107 | 1805 | 44 |
2176990 | 2176990 | 2022-02-02 | Mitchell | Texas | 48335 | 1805 | 46 |
2147616 | 2147616 | 2022-01-24 | Floyd | Texas | 48153 | 1805 | 42 |
2137993 | 2137993 | 2022-01-21 | Swisher | Texas | 48437 | 1805 | 29 |
2118297 | 2118297 | 2022-01-15 | Clay | Texas | 48077 | 1805 | 26 |
2115201 | 2115201 | 2022-01-14 | Red River | Texas | 48387 | 1805 | 58 |
2079411 | 2079411 | 2022-01-03 | Morris | Texas | 48343 | 1805 | 58 |
1855010 | 1855010 | 2021-10-26 | Callahan | Texas | 48059 | 1805 | 53 |
1656808 | 1656808 | 2021-08-26 | Bandera | Texas | 48019 | 1805 | 36 |
1173080 | 1173080 | 2021-03-30 | Freestone | Texas | 48161 | 1805 | 48 |
1069116 | 1069116 | 2021-02-26 | Austin | Texas | 48015 | 1805 | 28 |
822559 | 822559 | 2020-12-12 | Hill | Texas | 48217 | 1805 | 23 |
650687 | 650687 | 2020-10-20 | Rockwall | Texas | 48397 | 1805 | 31 |
647443 | 647443 | 2020-10-19 | Rockwall | Texas | 48397 | 1805 | 31 |
530578 | 530578 | 2020-09-13 | Bee | Texas | 48025 | 1805 | 27 |
527341 | 527341 | 2020-09-12 | Bee | Texas | 48025 | 1805 | 27 |
388697 | 388697 | 2020-07-31 | Midland | Texas | 48329 | 1805 | 33 |
385480 | 385480 | 2020-07-30 | Midland | Texas | 48329 | 1805 | 33 |
382262 | 382262 | 2020-07-29 | Midland | Texas | 48329 | 1805 | 33 |
379045 | 379045 | 2020-07-28 | Midland | Texas | 48329 | 1805 | 33 |
375829 | 375829 | 2020-07-27 | Midland | Texas | 48329 | 1805 | 33 |
372616 | 372616 | 2020-07-26 | Midland | Texas | 48329 | 1805 | 33 |
369404 | 369404 | 2020-07-25 | Midland | Texas | 48329 | 1805 | 33 |
366195 | 366195 | 2020-07-24 | Midland | Texas | 48329 | 1805 | 33 |
123709 | 123709 | 2020-05-07 | Bexar | Texas | 48029 | 1805 | 54 |
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);