ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 2923 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Texas · 14 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446896 | 2446896 | 2022-04-26 | Dawson | Texas | 48115 | 2923 | 94 |
1851941 | 1851941 | 2021-10-25 | Shelby | Texas | 48419 | 2923 | 109 |
1848691 | 1848691 | 2021-10-24 | Shelby | Texas | 48419 | 2923 | 109 |
1835627 | 1835627 | 2021-10-20 | Lee | Texas | 48287 | 2923 | 49 |
1630838 | 1630838 | 2021-08-18 | Calhoun | Texas | 48057 | 2923 | 26 |
1611494 | 1611494 | 2021-08-12 | Moore | Texas | 48341 | 2923 | 75 |
1556245 | 1556245 | 2021-07-26 | Limestone | Texas | 48293 | 2923 | 81 |
1429548 | 1429548 | 2021-06-17 | Deaf Smith | Texas | 48117 | 2923 | 68 |
1419932 | 1419932 | 2021-06-14 | Palo Pinto | Texas | 48363 | 2923 | 76 |
1416687 | 1416687 | 2021-06-13 | Palo Pinto | Texas | 48363 | 2923 | 76 |
1413441 | 1413441 | 2021-06-12 | Palo Pinto | Texas | 48363 | 2923 | 76 |
884120 | 884120 | 2020-12-31 | Atascosa | Texas | 48013 | 2923 | 63 |
443517 | 443517 | 2020-08-17 | Tom Green | Texas | 48451 | 2923 | 34 |
283405 | 283405 | 2020-06-28 | Galveston | Texas | 48167 | 2923 | 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);