ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 1832 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375430 | 2375430 | 2022-04-04 | Stephens | Texas | 48429 | 1832 | 45 |
2372178 | 2372178 | 2022-04-03 | Stephens | Texas | 48429 | 1832 | 45 |
2368925 | 2368925 | 2022-04-02 | Stephens | Texas | 48429 | 1832 | 45 |
2365672 | 2365672 | 2022-04-01 | Stephens | Texas | 48429 | 1832 | 45 |
2362419 | 2362419 | 2022-03-31 | Stephens | Texas | 48429 | 1832 | 45 |
2359165 | 2359165 | 2022-03-30 | Stephens | Texas | 48429 | 1832 | 45 |
2355911 | 2355911 | 2022-03-29 | Stephens | Texas | 48429 | 1832 | 45 |
2203014 | 2203014 | 2022-02-10 | Mitchell | Texas | 48335 | 1832 | 46 |
2115156 | 2115156 | 2022-01-14 | Live Oak | Texas | 48297 | 1832 | 39 |
2037026 | 2037026 | 2021-12-21 | Childress | Texas | 48075 | 1832 | 22 |
1718583 | 1718583 | 2021-09-14 | Eastland | Texas | 48133 | 1832 | 59 |
1621213 | 1621213 | 2021-08-15 | Leon | Texas | 48289 | 1832 | 44 |
1617965 | 1617965 | 2021-08-14 | Leon | Texas | 48289 | 1832 | 44 |
1569342 | 1569342 | 2021-07-30 | Zapata | Texas | 48505 | 1832 | 36 |
1361333 | 1361333 | 2021-05-27 | Andrews | Texas | 48003 | 1832 | 47 |
1358087 | 1358087 | 2021-05-26 | Andrews | Texas | 48003 | 1832 | 47 |
1354841 | 1354841 | 2021-05-25 | Andrews | Texas | 48003 | 1832 | 47 |
1351595 | 1351595 | 2021-05-24 | Andrews | Texas | 48003 | 1832 | 47 |
1348349 | 1348349 | 2021-05-23 | Andrews | Texas | 48003 | 1832 | 47 |
1345101 | 1345101 | 2021-05-22 | Andrews | Texas | 48003 | 1832 | 47 |
1228293 | 1228293 | 2021-04-16 | Freestone | Texas | 48161 | 1832 | 49 |
1218550 | 1218550 | 2021-04-13 | Freestone | Texas | 48161 | 1832 | 49 |
1156794 | 1156794 | 2021-03-25 | Cass | Texas | 48067 | 1832 | 79 |
1114806 | 1114806 | 2021-03-12 | Zavala | Texas | 48507 | 1832 | 39 |
1010843 | 1010843 | 2021-02-08 | Madison | Texas | 48313 | 1832 | 24 |
1007597 | 1007597 | 2021-02-07 | Madison | Texas | 48313 | 1832 | 24 |
1004351 | 1004351 | 2021-02-06 | Madison | Texas | 48313 | 1832 | 23 |
971906 | 971906 | 2021-01-27 | Montague | Texas | 48337 | 1832 | 51 |
806334 | 806334 | 2020-12-07 | Hood | Texas | 48221 | 1832 | 55 |
803089 | 803089 | 2020-12-06 | Hood | Texas | 48221 | 1832 | 55 |
799844 | 799844 | 2020-12-05 | Hood | Texas | 48221 | 1832 | 55 |
725216 | 725216 | 2020-11-12 | Jim Wells | Texas | 48249 | 1832 | 53 |
640764 | 640764 | 2020-10-17 | Bee | Texas | 48025 | 1832 | 37 |
582394 | 582394 | 2020-09-29 | Bastrop | Texas | 48021 | 1832 | 29 |
417715 | 417715 | 2020-08-09 | Taylor | Texas | 48441 | 1832 | 23 |
414494 | 414494 | 2020-08-08 | Taylor | Texas | 48441 | 1832 | 23 |
411274 | 411274 | 2020-08-07 | Taylor | Texas | 48441 | 1832 | 23 |
190196 | 190196 | 2020-05-29 | Fort Bend | Texas | 48157 | 1832 | 41 |
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);