ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where cases = 287 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1880978 | 1880978 | 2021-11-03 | Armstrong | Texas | 48011 | 287 | 7 |
1877729 | 1877729 | 2021-11-02 | Armstrong | Texas | 48011 | 287 | 7 |
1728473 | 1728473 | 2021-09-17 | Sherman | Texas | 48421 | 287 | 13 |
1725224 | 1725224 | 2021-09-16 | Sherman | Texas | 48421 | 287 | 13 |
1705666 | 1705666 | 2021-09-10 | Knox | Texas | 48275 | 287 | 19 |
1702416 | 1702416 | 2021-09-09 | Knox | Texas | 48275 | 287 | 19 |
1699167 | 1699167 | 2021-09-08 | Knox | Texas | 48275 | 287 | 19 |
1585541 | 1585541 | 2021-08-04 | Shackelford | Texas | 48417 | 287 | 5 |
1403703 | 1403703 | 2021-06-09 | Oldham | Texas | 48359 | 287 | 4 |
1400458 | 1400458 | 2021-06-08 | Oldham | Texas | 48359 | 287 | 4 |
1397213 | 1397213 | 2021-06-07 | Oldham | Texas | 48359 | 287 | 4 |
1393966 | 1393966 | 2021-06-06 | Oldham | Texas | 48359 | 287 | 4 |
1390721 | 1390721 | 2021-06-05 | Oldham | Texas | 48359 | 287 | 4 |
1387476 | 1387476 | 2021-06-04 | Oldham | Texas | 48359 | 287 | 4 |
1238093 | 1238093 | 2021-04-19 | Knox | Texas | 48275 | 287 | 17 |
1234846 | 1234846 | 2021-04-18 | Knox | Texas | 48275 | 287 | 17 |
1231598 | 1231598 | 2021-04-17 | Knox | Texas | 48275 | 287 | 17 |
1228350 | 1228350 | 2021-04-16 | Knox | Texas | 48275 | 287 | 17 |
1225102 | 1225102 | 2021-04-15 | Knox | Texas | 48275 | 287 | 17 |
1221855 | 1221855 | 2021-04-14 | Knox | Texas | 48275 | 287 | 17 |
1218607 | 1218607 | 2021-04-13 | Knox | Texas | 48275 | 287 | 17 |
1215359 | 1215359 | 2021-04-12 | Knox | Texas | 48275 | 287 | 17 |
1212112 | 1212112 | 2021-04-11 | Knox | Texas | 48275 | 287 | 17 |
1208863 | 1208863 | 2021-04-10 | Knox | Texas | 48275 | 287 | 17 |
1205615 | 1205615 | 2021-04-09 | Knox | Texas | 48275 | 287 | 17 |
1043203 | 1043203 | 2021-02-18 | Delta | Texas | 48119 | 287 | 9 |
1039958 | 1039958 | 2021-02-17 | Delta | Texas | 48119 | 287 | 9 |
1036713 | 1036713 | 2021-02-16 | Delta | Texas | 48119 | 287 | 9 |
1033468 | 1033468 | 2021-02-15 | Delta | Texas | 48119 | 287 | 9 |
1030222 | 1030222 | 2021-02-14 | Delta | Texas | 48119 | 287 | 9 |
997781 | 997781 | 2021-02-04 | Fisher | Texas | 48151 | 287 | 13 |
994535 | 994535 | 2021-02-03 | Fisher | Texas | 48151 | 287 | 12 |
991289 | 991289 | 2021-02-02 | Fisher | Texas | 48151 | 287 | 12 |
845228 | 845228 | 2020-12-19 | Culberson | Texas | 48109 | 287 | 3 |
764181 | 764181 | 2020-11-24 | Lee | Texas | 48287 | 287 | 17 |
666776 | 666776 | 2020-10-25 | Dimmit | Texas | 48127 | 287 | 7 |
663531 | 663531 | 2020-10-24 | Dimmit | Texas | 48127 | 287 | 7 |
657178 | 657178 | 2020-10-22 | Runnels | Texas | 48399 | 287 | 9 |
653933 | 653933 | 2020-10-21 | Runnels | Texas | 48399 | 287 | 9 |
650688 | 650688 | 2020-10-20 | Runnels | Texas | 48399 | 287 | 9 |
647280 | 647280 | 2020-10-19 | Castro | Texas | 48069 | 287 | 6 |
647444 | 647444 | 2020-10-19 | Runnels | Texas | 48399 | 287 | 9 |
644034 | 644034 | 2020-10-18 | Castro | Texas | 48069 | 287 | 6 |
644198 | 644198 | 2020-10-18 | Runnels | Texas | 48399 | 287 | 9 |
640950 | 640950 | 2020-10-17 | Runnels | Texas | 48399 | 287 | 9 |
624726 | 624726 | 2020-10-12 | Runnels | Texas | 48399 | 287 | 9 |
621483 | 621483 | 2020-10-11 | Runnels | Texas | 48399 | 287 | 9 |
618240 | 618240 | 2020-10-10 | Runnels | Texas | 48399 | 287 | 9 |
614998 | 614998 | 2020-10-09 | Runnels | Texas | 48399 | 287 | 9 |
537147 | 537147 | 2020-09-15 | Hopkins | Texas | 48223 | 287 | 8 |
533911 | 533911 | 2020-09-14 | Hopkins | Texas | 48223 | 287 | 8 |
530676 | 530676 | 2020-09-13 | Hopkins | Texas | 48223 | 287 | 8 |
527439 | 527439 | 2020-09-12 | Hopkins | Texas | 48223 | 287 | 8 |
514636 | 514636 | 2020-09-08 | Zavala | Texas | 48507 | 287 | 13 |
511403 | 511403 | 2020-09-07 | Zavala | Texas | 48507 | 287 | 13 |
508170 | 508170 | 2020-09-06 | Zavala | Texas | 48507 | 287 | 13 |
504938 | 504938 | 2020-09-05 | Zavala | Texas | 48507 | 287 | 13 |
501704 | 501704 | 2020-09-04 | Zavala | Texas | 48507 | 287 | 12 |
498470 | 498470 | 2020-09-03 | Zavala | Texas | 48507 | 287 | 11 |
495237 | 495237 | 2020-09-02 | Zavala | Texas | 48507 | 287 | 11 |
491891 | 491891 | 2020-09-01 | Lamb | Texas | 48279 | 287 | 19 |
492003 | 492003 | 2020-09-01 | Zavala | Texas | 48507 | 287 | 10 |
488770 | 488770 | 2020-08-31 | Zavala | Texas | 48507 | 287 | 10 |
485311 | 485311 | 2020-08-30 | Burleson | Texas | 48051 | 287 | 6 |
485537 | 485537 | 2020-08-30 | Zavala | Texas | 48507 | 287 | 10 |
482302 | 482302 | 2020-08-29 | Zavala | Texas | 48507 | 287 | 10 |
479068 | 479068 | 2020-08-28 | Zavala | Texas | 48507 | 287 | 10 |
475835 | 475835 | 2020-08-27 | Zavala | Texas | 48507 | 287 | 10 |
472534 | 472534 | 2020-08-26 | Pecos | Texas | 48371 | 287 | 3 |
472602 | 472602 | 2020-08-26 | Zavala | Texas | 48507 | 287 | 10 |
469370 | 469370 | 2020-08-25 | Zavala | Texas | 48507 | 287 | 9 |
430536 | 430536 | 2020-08-13 | Limestone | Texas | 48293 | 287 | 3 |
427172 | 427172 | 2020-08-12 | Austin | Texas | 48015 | 287 | 4 |
340437 | 340437 | 2020-07-16 | Burnet | Texas | 48053 | 287 | 5 |
308787 | 308787 | 2020-07-06 | Shelby | Texas | 48419 | 287 | 10 |
305619 | 305619 | 2020-07-05 | Shelby | Texas | 48419 | 287 | 10 |
286528 | 286528 | 2020-06-29 | Deaf Smith | Texas | 48117 | 287 | 16 |
286610 | 286610 | 2020-06-29 | Liberty | Texas | 48291 | 287 | 3 |
283382 | 283382 | 2020-06-28 | Deaf Smith | Texas | 48117 | 287 | 16 |
280236 | 280236 | 2020-06-27 | Deaf Smith | Texas | 48117 | 287 | 16 |
248959 | 248959 | 2020-06-17 | Grimes | Texas | 48185 | 287 | 2 |
242733 | 242733 | 2020-06-15 | Gregg | Texas | 48183 | 287 | 12 |
205502 | 205502 | 2020-06-03 | Bowie | Texas | 48037 | 287 | 13 |
196418 | 196418 | 2020-05-31 | Nacogdoches | Texas | 48347 | 287 | 21 |
193348 | 193348 | 2020-05-30 | Nacogdoches | Texas | 48347 | 287 | 21 |
171907 | 171907 | 2020-05-23 | Grayson | Texas | 48181 | 287 | 2 |
138657 | 138657 | 2020-05-12 | Brazos | Texas | 48041 | 287 | 18 |
97807 | 97807 | 2020-04-28 | Williamson | Texas | 48491 | 287 | 7 |
94965 | 94965 | 2020-04-27 | Williamson | Texas | 48491 | 287 | 6 |
42769 | 42769 | 2020-04-08 | Galveston | Texas | 48167 | 287 | 5 |
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);