ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 444 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329855 | 2329855 | 2022-03-21 | Parker | Texas | 48367 | 34133 | 444 |
2183516 | 2183516 | 2022-02-04 | Randall | Texas | 48381 | 36539 | 444 |
2173571 | 2173571 | 2022-02-01 | Angelina | Texas | 48005 | 14858 | 444 |
1975356 | 1975356 | 2021-12-02 | Kaufman | Texas | 48257 | 24306 | 444 |
1851777 | 1851777 | 2021-10-25 | Comal | Texas | 48091 | 19304 | 444 |
1848527 | 1848527 | 2021-10-24 | Comal | Texas | 48091 | 19304 | 444 |
1845277 | 1845277 | 2021-10-23 | Comal | Texas | 48091 | 19304 | 444 |
1835554 | 1835554 | 2021-10-20 | Ellis | Texas | 48139 | 33006 | 444 |
1728388 | 1728388 | 2021-09-17 | Johnson | Texas | 48251 | 25162 | 444 |
1718584 | 1718584 | 2021-09-14 | Ector | Texas | 48135 | 23180 | 444 |
1696002 | 1696002 | 2021-09-07 | Taylor | Texas | 48441 | 19315 | 444 |
1543233 | 1543233 | 2021-07-22 | Jefferson | Texas | 48245 | 20944 | 444 |
1471763 | 1471763 | 2021-06-30 | Galveston | Texas | 48167 | 41070 | 444 |
1465203 | 1465203 | 2021-06-28 | Bell | Texas | 48027 | 24986 | 444 |
1461958 | 1461958 | 2021-06-27 | Bell | Texas | 48027 | 24986 | 444 |
1458713 | 1458713 | 2021-06-26 | Bell | Texas | 48027 | 24962 | 444 |
1267366 | 1267366 | 2021-04-28 | Potter | Texas | 48375 | 17297 | 444 |
1264119 | 1264119 | 2021-04-27 | Potter | Texas | 48375 | 17275 | 444 |
1260872 | 1260872 | 2021-04-26 | Potter | Texas | 48375 | 17248 | 444 |
1257625 | 1257625 | 2021-04-25 | Potter | Texas | 48375 | 17245 | 444 |
1254378 | 1254378 | 2021-04-24 | Potter | Texas | 48375 | 17245 | 444 |
1251131 | 1251131 | 2021-04-23 | Potter | Texas | 48375 | 17245 | 444 |
1247884 | 1247884 | 2021-04-22 | Potter | Texas | 48375 | 17237 | 444 |
1173211 | 1173211 | 2021-03-30 | Smith | Texas | 48423 | 19524 | 444 |
1160027 | 1160027 | 2021-03-26 | Brazoria | Texas | 48039 | 35190 | 444 |
1157006 | 1157006 | 2021-03-25 | Williamson | Texas | 48491 | 42775 | 444 |
1101729 | 1101729 | 2021-03-08 | McLennan | Texas | 48309 | 25387 | 444 |
952346 | 952346 | 2021-01-21 | Fort Bend | Texas | 48157 | 46639 | 444 |
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);