ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where cases = 282 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378520 | 2378520 | 2022-04-05 | Cottle | Texas | 48101 | 282 | 9 |
2375266 | 2375266 | 2022-04-04 | Cottle | Texas | 48101 | 282 | 9 |
2372014 | 2372014 | 2022-04-03 | Cottle | Texas | 48101 | 282 | 9 |
2368761 | 2368761 | 2022-04-02 | Cottle | Texas | 48101 | 282 | 9 |
2365508 | 2365508 | 2022-04-01 | Cottle | Texas | 48101 | 282 | 9 |
2362255 | 2362255 | 2022-03-31 | Cottle | Texas | 48101 | 282 | 9 |
2359001 | 2359001 | 2022-03-30 | Cottle | Texas | 48101 | 282 | 9 |
2329844 | 2329844 | 2022-03-21 | Motley | Texas | 48345 | 282 | 13 |
2326592 | 2326592 | 2022-03-20 | Motley | Texas | 48345 | 282 | 13 |
2323339 | 2323339 | 2022-03-19 | Motley | Texas | 48345 | 282 | 13 |
2320085 | 2320085 | 2022-03-18 | Motley | Texas | 48345 | 282 | 13 |
1695919 | 1695919 | 2021-09-07 | Knox | Texas | 48275 | 282 | 19 |
1692671 | 1692671 | 2021-09-06 | Knox | Texas | 48275 | 282 | 19 |
1689422 | 1689422 | 2021-09-05 | Knox | Texas | 48275 | 282 | 19 |
1686172 | 1686172 | 2021-09-04 | Knox | Texas | 48275 | 282 | 19 |
1682921 | 1682921 | 2021-09-03 | Knox | Texas | 48275 | 282 | 19 |
1679671 | 1679671 | 2021-09-02 | Knox | Texas | 48275 | 282 | 19 |
1676423 | 1676423 | 2021-09-01 | Knox | Texas | 48275 | 282 | 19 |
1631016 | 1631016 | 2021-08-18 | Schleicher | Texas | 48413 | 282 | 7 |
1374448 | 1374448 | 2021-05-31 | Kimble | Texas | 48267 | 282 | 6 |
1371203 | 1371203 | 2021-05-30 | Kimble | Texas | 48267 | 282 | 6 |
1367957 | 1367957 | 2021-05-29 | Kimble | Texas | 48267 | 282 | 6 |
1364711 | 1364711 | 2021-05-28 | Kimble | Texas | 48267 | 282 | 6 |
1361465 | 1361465 | 2021-05-27 | Kimble | Texas | 48267 | 282 | 6 |
1358219 | 1358219 | 2021-05-26 | Kimble | Texas | 48267 | 282 | 6 |
1354973 | 1354973 | 2021-05-25 | Kimble | Texas | 48267 | 282 | 6 |
1160051 | 1160051 | 2021-03-26 | Collingsworth | Texas | 48087 | 282 | 9 |
1020485 | 1020485 | 2021-02-11 | Delta | Texas | 48119 | 282 | 8 |
1017240 | 1017240 | 2021-02-10 | Delta | Texas | 48119 | 282 | 8 |
1010837 | 1010837 | 2021-02-08 | Lipscomb | Texas | 48295 | 282 | 11 |
1007591 | 1007591 | 2021-02-07 | Lipscomb | Texas | 48295 | 282 | 11 |
1004345 | 1004345 | 2021-02-06 | Lipscomb | Texas | 48295 | 282 | 11 |
978303 | 978303 | 2021-01-29 | Fisher | Texas | 48151 | 282 | 12 |
965260 | 965260 | 2021-01-25 | Baylor | Texas | 48023 | 282 | 11 |
962015 | 962015 | 2021-01-24 | Baylor | Texas | 48023 | 282 | 11 |
958770 | 958770 | 2021-01-23 | Baylor | Texas | 48023 | 282 | 11 |
955597 | 955597 | 2021-01-22 | Garza | Texas | 48169 | 282 | 18 |
933025 | 933025 | 2021-01-15 | Upton | Texas | 48461 | 282 | 7 |
910166 | 910166 | 2021-01-08 | Goliad | Texas | 48175 | 282 | 8 |
906921 | 906921 | 2021-01-07 | Goliad | Texas | 48175 | 282 | 8 |
903675 | 903675 | 2021-01-06 | Goliad | Texas | 48175 | 282 | 8 |
903744 | 903744 | 2021-01-06 | Mason | Texas | 48319 | 282 | 3 |
903754 | 903754 | 2021-01-06 | Mills | Texas | 48333 | 282 | 12 |
900430 | 900430 | 2021-01-05 | Goliad | Texas | 48175 | 282 | 8 |
900497 | 900497 | 2021-01-05 | Marion | Texas | 48315 | 282 | 17 |
897185 | 897185 | 2021-01-04 | Goliad | Texas | 48175 | 282 | 8 |
893939 | 893939 | 2021-01-03 | Goliad | Texas | 48175 | 282 | 8 |
890693 | 890693 | 2021-01-02 | Goliad | Texas | 48175 | 282 | 8 |
887446 | 887446 | 2021-01-01 | Goliad | Texas | 48175 | 282 | 8 |
884201 | 884201 | 2020-12-31 | Goliad | Texas | 48175 | 282 | 8 |
880956 | 880956 | 2020-12-30 | Goliad | Texas | 48175 | 282 | 8 |
877711 | 877711 | 2020-12-29 | Goliad | Texas | 48175 | 282 | 8 |
855012 | 855012 | 2020-12-22 | Haskell | Texas | 48207 | 282 | 8 |
851766 | 851766 | 2020-12-21 | Hartley | Texas | 48205 | 282 | 2 |
848521 | 848521 | 2020-12-20 | Hartley | Texas | 48205 | 282 | 2 |
845276 | 845276 | 2020-12-19 | Hartley | Texas | 48205 | 282 | 2 |
796648 | 796648 | 2020-12-04 | McCulloch | Texas | 48307 | 282 | 6 |
760936 | 760936 | 2020-11-23 | Lee | Texas | 48287 | 282 | 15 |
741505 | 741505 | 2020-11-17 | Rains | Texas | 48379 | 282 | 6 |
741544 | 741544 | 2020-11-17 | Tyler | Texas | 48457 | 282 | 4 |
738297 | 738297 | 2020-11-16 | Tyler | Texas | 48457 | 282 | 4 |
735053 | 735053 | 2020-11-15 | Tyler | Texas | 48457 | 282 | 4 |
699346 | 699346 | 2020-11-04 | San Augustine | Texas | 48405 | 282 | 15 |
696102 | 696102 | 2020-11-03 | San Augustine | Texas | 48405 | 282 | 15 |
634509 | 634509 | 2020-10-15 | Yoakum | Texas | 48501 | 282 | 5 |
624672 | 624672 | 2020-10-12 | Leon | Texas | 48289 | 282 | 8 |
621429 | 621429 | 2020-10-11 | Leon | Texas | 48289 | 282 | 8 |
618186 | 618186 | 2020-10-10 | Leon | Texas | 48289 | 282 | 8 |
608492 | 608492 | 2020-10-07 | Nolan | Texas | 48353 | 282 | 5 |
582456 | 582456 | 2020-09-29 | Falls | Texas | 48145 | 282 | 5 |
559946 | 559946 | 2020-09-22 | Young | Texas | 48503 | 282 | 6 |
537059 | 537059 | 2020-09-15 | Brooks | Texas | 48047 | 282 | 21 |
533823 | 533823 | 2020-09-14 | Brooks | Texas | 48047 | 282 | 20 |
530588 | 530588 | 2020-09-13 | Brooks | Texas | 48047 | 282 | 20 |
527351 | 527351 | 2020-09-12 | Brooks | Texas | 48047 | 282 | 20 |
501703 | 501703 | 2020-09-04 | Zapata | Texas | 48505 | 282 | 4 |
469266 | 469266 | 2020-08-25 | Live Oak | Texas | 48297 | 282 | 5 |
466037 | 466037 | 2020-08-24 | Live Oak | Texas | 48297 | 282 | 5 |
462808 | 462808 | 2020-08-23 | Live Oak | Texas | 48297 | 282 | 5 |
459579 | 459579 | 2020-08-22 | Live Oak | Texas | 48297 | 282 | 5 |
449797 | 449797 | 2020-08-19 | Cooke | Texas | 48097 | 282 | 3 |
446569 | 446569 | 2020-08-18 | Cooke | Texas | 48097 | 282 | 3 |
299318 | 299318 | 2020-07-03 | Washington | Texas | 48477 | 282 | 31 |
296083 | 296083 | 2020-07-02 | Medina | Texas | 48325 | 282 | 2 |
274034 | 274034 | 2020-06-25 | Maverick | Texas | 48323 | 282 | 2 |
252106 | 252106 | 2020-06-18 | Johnson | Texas | 48251 | 282 | 4 |
248991 | 248991 | 2020-06-17 | Johnson | Texas | 48251 | 282 | 4 |
199379 | 199379 | 2020-06-01 | Coryell | Texas | 48099 | 282 | 2 |
168796 | 168796 | 2020-05-22 | Bell | Texas | 48027 | 282 | 3 |
165760 | 165760 | 2020-05-21 | Bell | Texas | 48027 | 282 | 3 |
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);