ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where deaths = 393 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2293986 | 2293986 | 2022-03-10 | Guadalupe | Texas | 48187 | 37185 | 393 |
2271271 | 2271271 | 2022-03-03 | Liberty | Texas | 48291 | 17507 | 393 |
2242099 | 2242099 | 2022-02-22 | Victoria | Texas | 48469 | 18335 | 393 |
2225630 | 2225630 | 2022-02-17 | Brazos | Texas | 48041 | 59299 | 393 |
2190014 | 2190014 | 2022-02-06 | Parker | Texas | 48367 | 33075 | 393 |
2186761 | 2186761 | 2022-02-05 | Parker | Texas | 48367 | 33012 | 393 |
2056712 | 2056712 | 2021-12-27 | Tom Green | Texas | 48451 | 25934 | 393 |
2053463 | 2053463 | 2021-12-26 | Tom Green | Texas | 48451 | 25874 | 393 |
2050213 | 2050213 | 2021-12-25 | Tom Green | Texas | 48451 | 25874 | 393 |
2046963 | 2046963 | 2021-12-24 | Tom Green | Texas | 48451 | 25874 | 393 |
2043713 | 2043713 | 2021-12-23 | Tom Green | Texas | 48451 | 25874 | 393 |
2040464 | 2040464 | 2021-12-22 | Tom Green | Texas | 48451 | 25874 | 393 |
2037214 | 2037214 | 2021-12-21 | Tom Green | Texas | 48451 | 25835 | 393 |
2033964 | 2033964 | 2021-12-20 | Tom Green | Texas | 48451 | 25805 | 393 |
2030714 | 2030714 | 2021-12-19 | Tom Green | Texas | 48451 | 25751 | 393 |
2027463 | 2027463 | 2021-12-18 | Tom Green | Texas | 48451 | 25751 | 393 |
2024212 | 2024212 | 2021-12-17 | Tom Green | Texas | 48451 | 25751 | 393 |
2020961 | 2020961 | 2021-12-16 | Tom Green | Texas | 48451 | 25722 | 393 |
2017710 | 2017710 | 2021-12-15 | Tom Green | Texas | 48451 | 25698 | 393 |
2014460 | 2014460 | 2021-12-14 | Tom Green | Texas | 48451 | 25673 | 393 |
2011209 | 2011209 | 2021-12-13 | Tom Green | Texas | 48451 | 25647 | 393 |
2007958 | 2007958 | 2021-12-12 | Tom Green | Texas | 48451 | 25603 | 393 |
2004707 | 2004707 | 2021-12-11 | Tom Green | Texas | 48451 | 25603 | 393 |
2001456 | 2001456 | 2021-12-10 | Tom Green | Texas | 48451 | 25603 | 393 |
1998206 | 1998206 | 2021-12-09 | Tom Green | Texas | 48451 | 25582 | 393 |
1994955 | 1994955 | 2021-12-08 | Tom Green | Texas | 48451 | 25564 | 393 |
1991704 | 1991704 | 2021-12-07 | Tom Green | Texas | 48451 | 25542 | 393 |
1988453 | 1988453 | 2021-12-06 | Tom Green | Texas | 48451 | 25518 | 393 |
1985203 | 1985203 | 2021-12-05 | Tom Green | Texas | 48451 | 25458 | 393 |
1981953 | 1981953 | 2021-12-04 | Tom Green | Texas | 48451 | 25458 | 393 |
1978703 | 1978703 | 2021-12-03 | Tom Green | Texas | 48451 | 25458 | 393 |
1851836 | 1851836 | 2021-10-25 | Hays | Texas | 48209 | 32819 | 393 |
1799872 | 1799872 | 2021-10-09 | Kaufman | Texas | 48257 | 23205 | 393 |
1790155 | 1790155 | 2021-10-06 | Maverick | Texas | 48323 | 12588 | 393 |
1705619 | 1705619 | 2021-09-10 | Grayson | Texas | 48181 | 13749 | 393 |
1630877 | 1630877 | 2021-08-18 | Ector | Texas | 48135 | 20130 | 393 |
1611449 | 1611449 | 2021-08-12 | Johnson | Texas | 48251 | 21619 | 393 |
1611566 | 1611566 | 2021-08-12 | Wichita | Texas | 48485 | 16117 | 393 |
1608201 | 1608201 | 2021-08-11 | Johnson | Texas | 48251 | 21495 | 393 |
1195815 | 1195815 | 2021-04-06 | Galveston | Texas | 48167 | 37436 | 393 |
1176369 | 1176369 | 2021-03-31 | Jefferson | Texas | 48245 | 18893 | 393 |
1173220 | 1173220 | 2021-03-30 | Taylor | Texas | 48441 | 15482 | 393 |
1053069 | 1053069 | 2021-02-21 | Potter | Texas | 48375 | 16730 | 393 |
1049822 | 1049822 | 2021-02-20 | Potter | Texas | 48375 | 16730 | 393 |
1046575 | 1046575 | 2021-02-19 | Potter | Texas | 48375 | 16730 | 393 |
1043330 | 1043330 | 2021-02-18 | Potter | Texas | 48375 | 16730 | 393 |
1040085 | 1040085 | 2021-02-17 | Potter | Texas | 48375 | 16730 | 393 |
1036840 | 1036840 | 2021-02-16 | Potter | Texas | 48375 | 16730 | 393 |
1033595 | 1033595 | 2021-02-15 | Potter | Texas | 48375 | 16730 | 393 |
919875 | 919875 | 2021-01-11 | Denton | Texas | 48121 | 43580 | 393 |
916630 | 916630 | 2021-01-10 | Denton | Texas | 48121 | 43107 | 393 |
893930 | 893930 | 2021-01-03 | Fort Bend | Texas | 48157 | 36324 | 393 |
890684 | 890684 | 2021-01-02 | Fort Bend | Texas | 48157 | 36324 | 393 |
501677 | 501677 | 2020-09-04 | Travis | Texas | 48453 | 26854 | 393 |
299143 | 299143 | 2020-07-03 | Dallas | Texas | 48113 | 23675 | 393 |
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);