ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 66 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2134651 | 2134651 | 2022-01-20 | Kenedy | Texas | 48261 | 66 | 2 |
2131399 | 2131399 | 2022-01-19 | Kenedy | Texas | 48261 | 66 | 2 |
2128145 | 2128145 | 2022-01-18 | Kenedy | Texas | 48261 | 66 | 2 |
2124893 | 2124893 | 2022-01-17 | Kenedy | Texas | 48261 | 66 | 2 |
2121641 | 2121641 | 2022-01-16 | Kenedy | Texas | 48261 | 66 | 2 |
2118389 | 2118389 | 2022-01-15 | Kenedy | Texas | 48261 | 66 | 2 |
2118409 | 2118409 | 2022-01-15 | Loving | Texas | 48301 | 66 | 0 |
2115158 | 2115158 | 2022-01-14 | Loving | Texas | 48301 | 66 | 0 |
1592028 | 1592028 | 2021-08-06 | Roberts | Texas | 48393 | 66 | 1 |
1588779 | 1588779 | 2021-08-05 | Roberts | Texas | 48393 | 66 | 1 |
1585529 | 1585529 | 2021-08-04 | Roberts | Texas | 48393 | 66 | 1 |
1582279 | 1582279 | 2021-08-03 | Roberts | Texas | 48393 | 66 | 1 |
1579030 | 1579030 | 2021-08-02 | Roberts | Texas | 48393 | 66 | 1 |
1575782 | 1575782 | 2021-08-01 | Roberts | Texas | 48393 | 66 | 1 |
1572534 | 1572534 | 2021-07-31 | Roberts | Texas | 48393 | 66 | 1 |
1569286 | 1569286 | 2021-07-30 | Roberts | Texas | 48393 | 66 | 1 |
1566038 | 1566038 | 2021-07-29 | Roberts | Texas | 48393 | 66 | 1 |
1562790 | 1562790 | 2021-07-28 | Roberts | Texas | 48393 | 66 | 1 |
932926 | 932926 | 2021-01-15 | Kent | Texas | 48263 | 66 | 1 |
929681 | 929681 | 2021-01-14 | Kent | Texas | 48263 | 66 | 1 |
903749 | 903749 | 2021-01-06 | McMullen | Texas | 48311 | 66 | 2 |
868006 | 868006 | 2020-12-26 | Irion | Texas | 48235 | 66 | 0 |
864761 | 864761 | 2020-12-25 | Irion | Texas | 48235 | 66 | 0 |
861516 | 861516 | 2020-12-24 | Irion | Texas | 48235 | 66 | 0 |
851781 | 851781 | 2020-12-21 | Irion | Texas | 48235 | 66 | 0 |
816019 | 816019 | 2020-12-10 | Delta | Texas | 48119 | 66 | 2 |
812773 | 812773 | 2020-12-09 | Delta | Texas | 48119 | 66 | 2 |
783572 | 783572 | 2020-11-30 | Dickens | Texas | 48125 | 66 | 4 |
780327 | 780327 | 2020-11-29 | Dickens | Texas | 48125 | 66 | 4 |
777081 | 777081 | 2020-11-28 | Dickens | Texas | 48125 | 66 | 4 |
773836 | 773836 | 2020-11-27 | Dickens | Texas | 48125 | 66 | 4 |
770591 | 770591 | 2020-11-26 | Dickens | Texas | 48125 | 66 | 4 |
767345 | 767345 | 2020-11-25 | Dickens | Texas | 48125 | 66 | 4 |
764100 | 764100 | 2020-11-24 | Dickens | Texas | 48125 | 66 | 4 |
660371 | 660371 | 2020-10-23 | Lipscomb | Texas | 48295 | 66 | 1 |
657127 | 657127 | 2020-10-22 | Lipscomb | Texas | 48295 | 66 | 1 |
653882 | 653882 | 2020-10-21 | Lipscomb | Texas | 48295 | 66 | 1 |
650558 | 650558 | 2020-10-20 | Edwards | Texas | 48137 | 66 | 2 |
647314 | 647314 | 2020-10-19 | Edwards | Texas | 48137 | 66 | 2 |
644068 | 644068 | 2020-10-18 | Edwards | Texas | 48137 | 66 | 2 |
640820 | 640820 | 2020-10-17 | Edwards | Texas | 48137 | 66 | 2 |
637573 | 637573 | 2020-10-16 | Edwards | Texas | 48137 | 66 | 2 |
624693 | 624693 | 2020-10-12 | Mills | Texas | 48333 | 66 | 0 |
621450 | 621450 | 2020-10-11 | Mills | Texas | 48333 | 66 | 0 |
618207 | 618207 | 2020-10-10 | Mills | Texas | 48333 | 66 | 0 |
611768 | 611768 | 2020-10-08 | Sherman | Texas | 48421 | 66 | 1 |
608526 | 608526 | 2020-10-07 | Sherman | Texas | 48421 | 66 | 1 |
605283 | 605283 | 2020-10-06 | Sherman | Texas | 48421 | 66 | 1 |
601897 | 601897 | 2020-10-05 | Donley | Texas | 48129 | 66 | 1 |
602041 | 602041 | 2020-10-05 | Sherman | Texas | 48421 | 66 | 1 |
598654 | 598654 | 2020-10-04 | Donley | Texas | 48129 | 66 | 1 |
598798 | 598798 | 2020-10-04 | Sherman | Texas | 48421 | 66 | 1 |
595411 | 595411 | 2020-10-03 | Donley | Texas | 48129 | 66 | 1 |
595555 | 595555 | 2020-10-03 | Sherman | Texas | 48421 | 66 | 1 |
592169 | 592169 | 2020-10-02 | Donley | Texas | 48129 | 66 | 1 |
592308 | 592308 | 2020-10-02 | San Saba | Texas | 48411 | 66 | 0 |
592313 | 592313 | 2020-10-02 | Sherman | Texas | 48421 | 66 | 1 |
588929 | 588929 | 2020-10-01 | Donley | Texas | 48129 | 66 | 1 |
589068 | 589068 | 2020-10-01 | San Saba | Texas | 48411 | 66 | 0 |
589073 | 589073 | 2020-10-01 | Sherman | Texas | 48421 | 66 | 1 |
585688 | 585688 | 2020-09-30 | Donley | Texas | 48129 | 66 | 1 |
585699 | 585699 | 2020-09-30 | Fisher | Texas | 48151 | 66 | 3 |
585827 | 585827 | 2020-09-30 | San Saba | Texas | 48411 | 66 | 0 |
585832 | 585832 | 2020-09-30 | Sherman | Texas | 48421 | 66 | 0 |
582459 | 582459 | 2020-09-29 | Fisher | Texas | 48151 | 66 | 3 |
582592 | 582592 | 2020-09-29 | Sherman | Texas | 48421 | 66 | 0 |
579220 | 579220 | 2020-09-28 | Fisher | Texas | 48151 | 66 | 3 |
575979 | 575979 | 2020-09-27 | Fisher | Texas | 48151 | 66 | 3 |
572735 | 572735 | 2020-09-26 | Fisher | Texas | 48151 | 66 | 3 |
569493 | 569493 | 2020-09-25 | Fisher | Texas | 48151 | 66 | 3 |
566252 | 566252 | 2020-09-24 | Fisher | Texas | 48151 | 66 | 3 |
563011 | 563011 | 2020-09-23 | Fisher | Texas | 48151 | 66 | 3 |
559734 | 559734 | 2020-09-22 | Childress | Texas | 48075 | 66 | 0 |
556498 | 556498 | 2020-09-21 | Childress | Texas | 48075 | 66 | 0 |
553261 | 553261 | 2020-09-20 | Childress | Texas | 48075 | 66 | 0 |
550022 | 550022 | 2020-09-19 | Childress | Texas | 48075 | 66 | 0 |
546783 | 546783 | 2020-09-18 | Childress | Texas | 48075 | 66 | 0 |
546793 | 546793 | 2020-09-18 | Concho | Texas | 48095 | 66 | 2 |
543556 | 543556 | 2020-09-17 | Concho | Texas | 48095 | 66 | 2 |
540320 | 540320 | 2020-09-16 | Concho | Texas | 48095 | 66 | 2 |
537083 | 537083 | 2020-09-15 | Concho | Texas | 48095 | 66 | 2 |
498405 | 498405 | 2020-09-03 | Presidio | Texas | 48377 | 66 | 5 |
495172 | 495172 | 2020-09-02 | Presidio | Texas | 48377 | 66 | 5 |
446710 | 446710 | 2020-08-18 | Reagan | Texas | 48383 | 66 | 5 |
446720 | 446720 | 2020-08-18 | Sabine | Texas | 48403 | 66 | 6 |
443483 | 443483 | 2020-08-17 | Reagan | Texas | 48383 | 66 | 4 |
443493 | 443493 | 2020-08-17 | Sabine | Texas | 48403 | 66 | 6 |
440257 | 440257 | 2020-08-16 | Reagan | Texas | 48383 | 66 | 4 |
437031 | 437031 | 2020-08-15 | Reagan | Texas | 48383 | 66 | 4 |
433734 | 433734 | 2020-08-14 | Jack | Texas | 48237 | 66 | 0 |
427378 | 427378 | 2020-08-12 | Sutton | Texas | 48435 | 66 | 1 |
424154 | 424154 | 2020-08-11 | Sutton | Texas | 48435 | 66 | 1 |
411207 | 411207 | 2020-08-07 | Lynn | Texas | 48305 | 66 | 4 |
407988 | 407988 | 2020-08-06 | Lynn | Texas | 48305 | 66 | 4 |
408048 | 408048 | 2020-08-06 | Somervell | Texas | 48425 | 66 | 0 |
404768 | 404768 | 2020-08-05 | Lynn | Texas | 48305 | 66 | 4 |
401550 | 401550 | 2020-08-04 | Lynn | Texas | 48305 | 66 | 4 |
388779 | 388779 | 2020-07-31 | Winkler | Texas | 48495 | 66 | 1 |
385562 | 385562 | 2020-07-30 | Winkler | Texas | 48495 | 66 | 1 |
382151 | 382151 | 2020-07-29 | Crane | Texas | 48103 | 66 | 2 |
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);