ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 696 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2332968 | 2332968 | 2022-03-22 | Collingsworth | Texas | 48087 | 696 | 16 |
2144442 | 2144442 | 2022-01-23 | Mason | Texas | 48319 | 696 | 9 |
2134713 | 2134713 | 2022-01-20 | Real | Texas | 48385 | 696 | 22 |
2131461 | 2131461 | 2022-01-19 | Real | Texas | 48385 | 696 | 22 |
2121742 | 2121742 | 2022-01-16 | Upton | Texas | 48461 | 696 | 15 |
2118490 | 2118490 | 2022-01-15 | Upton | Texas | 48461 | 696 | 15 |
2020796 | 2020796 | 2021-12-16 | Delta | Texas | 48119 | 696 | 22 |
2014275 | 2014275 | 2021-12-14 | Coke | Texas | 48081 | 696 | 18 |
1842087 | 1842087 | 2021-10-22 | Hemphill | Texas | 48211 | 696 | 3 |
1838838 | 1838838 | 2021-10-21 | Hemphill | Texas | 48211 | 696 | 3 |
1799791 | 1799791 | 2021-10-09 | Concho | Texas | 48095 | 696 | 10 |
1319318 | 1319318 | 2021-05-14 | Red River | Texas | 48387 | 696 | 37 |
1316070 | 1316070 | 2021-05-13 | Red River | Texas | 48387 | 696 | 37 |
1312824 | 1312824 | 2021-05-12 | Red River | Texas | 48387 | 696 | 37 |
991310 | 991310 | 2021-02-02 | Hamilton | Texas | 48193 | 696 | 23 |
936215 | 936215 | 2021-01-16 | Newton | Texas | 48351 | 696 | 19 |
854926 | 854926 | 2020-12-22 | Bosque | Texas | 48035 | 696 | 16 |
582615 | 582615 | 2020-09-29 | Van Zandt | Texas | 48467 | 696 | 26 |
514536 | 514536 | 2020-09-08 | Madison | Texas | 48313 | 696 | 5 |
511303 | 511303 | 2020-09-07 | Madison | Texas | 48313 | 696 | 5 |
508070 | 508070 | 2020-09-06 | Madison | Texas | 48313 | 696 | 5 |
504838 | 504838 | 2020-09-05 | Madison | Texas | 48313 | 696 | 5 |
456332 | 456332 | 2020-08-21 | Karnes | Texas | 48255 | 696 | 10 |
427213 | 427213 | 2020-08-12 | Coryell | Texas | 48099 | 696 | 5 |
404631 | 404631 | 2020-08-05 | Bee | Texas | 48025 | 696 | 9 |
147711 | 147711 | 2020-05-15 | Galveston | Texas | 48167 | 696 | 30 |
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);