ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where deaths = 246 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2320099 | 2320099 | 2022-03-18 | Polk | Texas | 48373 | 7797 | 246 |
2316845 | 2316845 | 2022-03-17 | Polk | Texas | 48373 | 7796 | 246 |
2297331 | 2297331 | 2022-03-11 | Polk | Texas | 48373 | 7786 | 246 |
2294079 | 2294079 | 2022-03-10 | Polk | Texas | 48373 | 7785 | 246 |
2271162 | 2271162 | 2022-03-03 | Cherokee | Texas | 48073 | 7918 | 246 |
2267910 | 2267910 | 2022-03-02 | Cherokee | Texas | 48073 | 7913 | 246 |
2264657 | 2264657 | 2022-03-01 | Cherokee | Texas | 48073 | 7912 | 246 |
2261407 | 2261407 | 2022-02-28 | Cherokee | Texas | 48073 | 7909 | 246 |
2258156 | 2258156 | 2022-02-27 | Cherokee | Texas | 48073 | 7908 | 246 |
2254905 | 2254905 | 2022-02-26 | Cherokee | Texas | 48073 | 7908 | 246 |
2251654 | 2251654 | 2022-02-25 | Cherokee | Texas | 48073 | 7906 | 246 |
2248403 | 2248403 | 2022-02-24 | Cherokee | Texas | 48073 | 7904 | 246 |
2238753 | 2238753 | 2022-02-21 | Lamar | Texas | 48277 | 12313 | 246 |
2235502 | 2235502 | 2022-02-20 | Lamar | Texas | 48277 | 12313 | 246 |
2216055 | 2216055 | 2022-02-14 | Rockwall | Texas | 48397 | 25796 | 246 |
2212804 | 2212804 | 2022-02-13 | Rockwall | Texas | 48397 | 25784 | 246 |
2164042 | 2164042 | 2022-01-29 | Van Zandt | Texas | 48467 | 9728 | 246 |
2160787 | 2160787 | 2022-01-28 | Van Zandt | Texas | 48467 | 9677 | 246 |
2157531 | 2157531 | 2022-01-27 | Van Zandt | Texas | 48467 | 9624 | 246 |
2112005 | 2112005 | 2022-01-13 | Wood | Texas | 48499 | 7464 | 246 |
2108753 | 2108753 | 2022-01-12 | Wood | Texas | 48499 | 7395 | 246 |
2105502 | 2105502 | 2022-01-11 | Wood | Texas | 48499 | 7336 | 246 |
1760869 | 1760869 | 2021-09-27 | Hunt | Texas | 48231 | 10162 | 246 |
1757621 | 1757621 | 2021-09-26 | Hunt | Texas | 48231 | 10128 | 246 |
1734946 | 1734946 | 2021-09-19 | Parker | Texas | 48367 | 21702 | 246 |
1702385 | 1702385 | 2021-09-09 | Henderson | Texas | 48213 | 8361 | 246 |
1682802 | 1682802 | 2021-09-03 | Bowie | Texas | 48037 | 10347 | 246 |
1679552 | 1679552 | 2021-09-02 | Bowie | Texas | 48037 | 10178 | 246 |
1676304 | 1676304 | 2021-09-01 | Bowie | Texas | 48037 | 10087 | 246 |
1631044 | 1631044 | 2021-08-18 | Victoria | Texas | 48469 | 10802 | 246 |
1358190 | 1358190 | 2021-05-26 | Hays | Texas | 48209 | 20906 | 246 |
1354944 | 1354944 | 2021-05-25 | Hays | Texas | 48209 | 20889 | 246 |
1351698 | 1351698 | 2021-05-24 | Hays | Texas | 48209 | 20877 | 246 |
1250964 | 1250964 | 2021-04-23 | Brazos | Texas | 48041 | 26133 | 246 |
1247717 | 1247717 | 2021-04-22 | Brazos | Texas | 48041 | 26094 | 246 |
1199109 | 1199109 | 2021-04-07 | Kaufman | Texas | 48257 | 15573 | 246 |
1195860 | 1195860 | 2021-04-06 | Kaufman | Texas | 48257 | 15568 | 246 |
1192612 | 1192612 | 2021-04-05 | Kaufman | Texas | 48257 | 15539 | 246 |
1189363 | 1189363 | 2021-04-04 | Kaufman | Texas | 48257 | 15539 | 246 |
1082256 | 1082256 | 2021-03-02 | Midland | Texas | 48329 | 16236 | 246 |
1079010 | 1079010 | 2021-03-01 | Midland | Texas | 48329 | 16236 | 246 |
1075765 | 1075765 | 2021-02-28 | Midland | Texas | 48329 | 16236 | 246 |
1056130 | 1056130 | 2021-02-22 | Angelina | Texas | 48005 | 7797 | 246 |
1036878 | 1036878 | 2021-02-16 | Tom Green | Texas | 48451 | 16123 | 246 |
1033633 | 1033633 | 2021-02-15 | Tom Green | Texas | 48451 | 16123 | 246 |
1030387 | 1030387 | 2021-02-14 | Tom Green | Texas | 48451 | 16123 | 246 |
1027140 | 1027140 | 2021-02-13 | Tom Green | Texas | 48451 | 16123 | 246 |
1023895 | 1023895 | 2021-02-12 | Tom Green | Texas | 48451 | 16123 | 246 |
991372 | 991372 | 2021-02-02 | Maverick | Texas | 48323 | 9509 | 246 |
988158 | 988158 | 2021-02-01 | Randall | Texas | 48381 | 15738 | 246 |
919881 | 919881 | 2021-01-11 | Ector | Texas | 48135 | 11543 | 246 |
916636 | 916636 | 2021-01-10 | Ector | Texas | 48135 | 11543 | 246 |
903607 | 903607 | 2021-01-06 | Brazoria | Texas | 48039 | 22651 | 246 |
851833 | 851833 | 2020-12-21 | Montgomery | Texas | 48339 | 23267 | 246 |
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);