ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77 rows where deaths = 310 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2134701 | 2134701 | 2022-01-20 | Orange | Texas | 48361 | 13748 | 310 |
2131449 | 2131449 | 2022-01-19 | Orange | Texas | 48361 | 13699 | 310 |
1936335 | 1936335 | 2021-11-20 | Hunt | Texas | 48231 | 11062 | 310 |
1933085 | 1933085 | 2021-11-19 | Hunt | Texas | 48231 | 11062 | 310 |
1929834 | 1929834 | 2021-11-18 | Hunt | Texas | 48231 | 11062 | 310 |
1926584 | 1926584 | 2021-11-17 | Hunt | Texas | 48231 | 11044 | 310 |
1848665 | 1848665 | 2021-10-24 | Parker | Texas | 48367 | 24096 | 310 |
1764237 | 1764237 | 2021-09-28 | Victoria | Texas | 48469 | 12851 | 310 |
1715433 | 1715433 | 2021-09-13 | Midland | Texas | 48329 | 23848 | 310 |
1676288 | 1676288 | 2021-09-01 | Angelina | Texas | 48005 | 11327 | 310 |
1660261 | 1660261 | 2021-08-27 | Starr | Texas | 48427 | 10571 | 310 |
1657012 | 1657012 | 2021-08-26 | Starr | Texas | 48427 | 10533 | 310 |
1653765 | 1653765 | 2021-08-25 | Starr | Texas | 48427 | 10502 | 310 |
1559536 | 1559536 | 2021-07-27 | Randall | Texas | 48381 | 17502 | 310 |
1556289 | 1556289 | 2021-07-26 | Randall | Texas | 48381 | 17502 | 310 |
1553042 | 1553042 | 2021-07-25 | Randall | Texas | 48381 | 17457 | 310 |
1549795 | 1549795 | 2021-07-24 | Randall | Texas | 48381 | 17457 | 310 |
1546548 | 1546548 | 2021-07-23 | Randall | Texas | 48381 | 17457 | 310 |
1543301 | 1543301 | 2021-07-22 | Randall | Texas | 48381 | 17413 | 310 |
1540053 | 1540053 | 2021-07-21 | Randall | Texas | 48381 | 17393 | 310 |
1536806 | 1536806 | 2021-07-20 | Randall | Texas | 48381 | 17332 | 310 |
1533558 | 1533558 | 2021-07-19 | Randall | Texas | 48381 | 17293 | 310 |
1530311 | 1530311 | 2021-07-18 | Randall | Texas | 48381 | 17274 | 310 |
1527064 | 1527064 | 2021-07-17 | Randall | Texas | 48381 | 17274 | 310 |
1523817 | 1523817 | 2021-07-16 | Randall | Texas | 48381 | 17274 | 310 |
1520569 | 1520569 | 2021-07-15 | Randall | Texas | 48381 | 17237 | 310 |
1517321 | 1517321 | 2021-07-14 | Randall | Texas | 48381 | 17223 | 310 |
1514074 | 1514074 | 2021-07-13 | Randall | Texas | 48381 | 17184 | 310 |
1510828 | 1510828 | 2021-07-12 | Randall | Texas | 48381 | 17155 | 310 |
1507581 | 1507581 | 2021-07-11 | Randall | Texas | 48381 | 17144 | 310 |
1504335 | 1504335 | 2021-07-10 | Randall | Texas | 48381 | 17144 | 310 |
1501089 | 1501089 | 2021-07-09 | Randall | Texas | 48381 | 17144 | 310 |
1497843 | 1497843 | 2021-07-08 | Randall | Texas | 48381 | 17135 | 310 |
1494596 | 1494596 | 2021-07-07 | Randall | Texas | 48381 | 17122 | 310 |
1491349 | 1491349 | 2021-07-06 | Randall | Texas | 48381 | 17108 | 310 |
1488102 | 1488102 | 2021-07-05 | Randall | Texas | 48381 | 17104 | 310 |
1484855 | 1484855 | 2021-07-04 | Randall | Texas | 48381 | 17104 | 310 |
1481609 | 1481609 | 2021-07-03 | Randall | Texas | 48381 | 17104 | 310 |
1478362 | 1478362 | 2021-07-02 | Randall | Texas | 48381 | 17104 | 310 |
1475116 | 1475116 | 2021-07-01 | Randall | Texas | 48381 | 17091 | 310 |
1471870 | 1471870 | 2021-06-30 | Randall | Texas | 48381 | 17083 | 310 |
1468625 | 1468625 | 2021-06-29 | Randall | Texas | 48381 | 17075 | 310 |
1465380 | 1465380 | 2021-06-28 | Randall | Texas | 48381 | 17065 | 310 |
1462135 | 1462135 | 2021-06-27 | Randall | Texas | 48381 | 17062 | 310 |
1458890 | 1458890 | 2021-06-26 | Randall | Texas | 48381 | 17062 | 310 |
1455645 | 1455645 | 2021-06-25 | Randall | Texas | 48381 | 17062 | 310 |
1452400 | 1452400 | 2021-06-24 | Randall | Texas | 48381 | 17051 | 310 |
1312701 | 1312701 | 2021-05-12 | Ellis | Texas | 48139 | 22805 | 310 |
1309454 | 1309454 | 2021-05-11 | Ellis | Texas | 48139 | 22797 | 310 |
1306208 | 1306208 | 2021-05-10 | Ellis | Texas | 48139 | 22765 | 310 |
1302962 | 1302962 | 2021-05-09 | Ellis | Texas | 48139 | 22765 | 310 |
1299715 | 1299715 | 2021-05-08 | Ellis | Texas | 48139 | 22765 | 310 |
1296468 | 1296468 | 2021-05-07 | Ellis | Texas | 48139 | 22753 | 310 |
1293222 | 1293222 | 2021-05-06 | Ellis | Texas | 48139 | 22745 | 310 |
1289976 | 1289976 | 2021-05-05 | Ellis | Texas | 48139 | 22727 | 310 |
1286730 | 1286730 | 2021-05-04 | Ellis | Texas | 48139 | 22720 | 310 |
1283484 | 1283484 | 2021-05-03 | Ellis | Texas | 48139 | 22677 | 310 |
1280237 | 1280237 | 2021-05-02 | Ellis | Texas | 48139 | 22677 | 310 |
1276990 | 1276990 | 2021-05-01 | Ellis | Texas | 48139 | 22677 | 310 |
1254261 | 1254261 | 2021-04-24 | Ellis | Texas | 48139 | 22468 | 310 |
1251014 | 1251014 | 2021-04-23 | Ellis | Texas | 48139 | 22462 | 310 |
1247767 | 1247767 | 2021-04-22 | Ellis | Texas | 48139 | 22454 | 310 |
1244520 | 1244520 | 2021-04-21 | Ellis | Texas | 48139 | 22429 | 310 |
1075691 | 1075691 | 2021-02-28 | Grayson | Texas | 48181 | 10788 | 310 |
1072445 | 1072445 | 2021-02-27 | Grayson | Texas | 48181 | 10788 | 310 |
1069199 | 1069199 | 2021-02-26 | Grayson | Texas | 48181 | 10780 | 310 |
1033421 | 1033421 | 2021-02-15 | Bell | Texas | 48027 | 20122 | 310 |
1033475 | 1033475 | 2021-02-15 | Ector | Texas | 48135 | 15616 | 310 |
1030175 | 1030175 | 2021-02-14 | Bell | Texas | 48027 | 20122 | 310 |
1030229 | 1030229 | 2021-02-14 | Ector | Texas | 48135 | 15616 | 310 |
1026928 | 1026928 | 2021-02-13 | Bell | Texas | 48027 | 20122 | 310 |
994582 | 994582 | 2021-02-03 | Jefferson | Texas | 48245 | 17371 | 310 |
900530 | 900530 | 2021-01-05 | Potter | Texas | 48375 | 15391 | 310 |
689493 | 689493 | 2020-11-01 | Fort Bend | Texas | 48157 | 18416 | 310 |
598827 | 598827 | 2020-10-04 | Webb | Texas | 48479 | 14145 | 310 |
427233 | 427233 | 2020-08-12 | El Paso | Texas | 48141 | 17210 | 310 |
359836 | 359836 | 2020-07-22 | Tarrant | Texas | 48439 | 23536 | 310 |
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);