ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 1748 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264816 | 2264816 | 2022-03-01 | Refugio | Texas | 48391 | 1748 | 31 |
2261566 | 2261566 | 2022-02-28 | Refugio | Texas | 48391 | 1748 | 31 |
2258315 | 2258315 | 2022-02-27 | Refugio | Texas | 48391 | 1748 | 31 |
2255064 | 2255064 | 2022-02-26 | Refugio | Texas | 48391 | 1748 | 31 |
2186792 | 2186792 | 2022-02-05 | Stephens | Texas | 48429 | 1748 | 39 |
2177012 | 2177012 | 2022-02-02 | Rains | Texas | 48379 | 1748 | 53 |
2154211 | 2154211 | 2022-01-26 | Mitchell | Texas | 48335 | 1748 | 45 |
1540012 | 1540012 | 2021-07-21 | Llano | Texas | 48299 | 1748 | 54 |
1536765 | 1536765 | 2021-07-20 | Llano | Texas | 48299 | 1748 | 54 |
1533425 | 1533425 | 2021-07-19 | Dawson | Texas | 48115 | 1748 | 69 |
1530178 | 1530178 | 2021-07-18 | Dawson | Texas | 48115 | 1748 | 69 |
1526931 | 1526931 | 2021-07-17 | Dawson | Texas | 48115 | 1748 | 69 |
1523684 | 1523684 | 2021-07-16 | Dawson | Texas | 48115 | 1748 | 69 |
1520436 | 1520436 | 2021-07-15 | Dawson | Texas | 48115 | 1748 | 69 |
1517188 | 1517188 | 2021-07-14 | Dawson | Texas | 48115 | 1748 | 69 |
1513941 | 1513941 | 2021-07-13 | Dawson | Texas | 48115 | 1748 | 69 |
1082172 | 1082172 | 2021-03-02 | Freestone | Texas | 48161 | 1748 | 44 |
942619 | 942619 | 2021-01-18 | Gray | Texas | 48179 | 1748 | 40 |
939374 | 939374 | 2021-01-17 | Gray | Texas | 48179 | 1748 | 40 |
936129 | 936129 | 2021-01-16 | Gray | Texas | 48179 | 1748 | 40 |
835485 | 835485 | 2020-12-16 | Cooke | Texas | 48097 | 1748 | 21 |
815965 | 815965 | 2020-12-10 | Atascosa | Texas | 48013 | 1748 | 49 |
780324 | 780324 | 2020-11-29 | Deaf Smith | Texas | 48117 | 1748 | 38 |
777078 | 777078 | 2020-11-28 | Deaf Smith | Texas | 48117 | 1748 | 38 |
773833 | 773833 | 2020-11-27 | Deaf Smith | Texas | 48117 | 1748 | 38 |
761017 | 761017 | 2020-11-23 | Titus | Texas | 48449 | 1748 | 40 |
757772 | 757772 | 2020-11-22 | Titus | Texas | 48449 | 1748 | 40 |
696025 | 696025 | 2020-11-03 | Jim Wells | Texas | 48249 | 1748 | 52 |
614916 | 614916 | 2020-10-09 | Hunt | Texas | 48231 | 1748 | 40 |
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);