ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where county = "Throckmorton", deaths = 2 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
845397 | 845397 | 2020-12-19 | Throckmorton | Texas | 48447 | 47 | 2 |
842151 | 842151 | 2020-12-18 | Throckmorton | Texas | 48447 | 46 | 2 |
838906 | 838906 | 2020-12-17 | Throckmorton | Texas | 48447 | 45 | 2 |
835660 | 835660 | 2020-12-16 | Throckmorton | Texas | 48447 | 46 | 2 |
832414 | 832414 | 2020-12-15 | Throckmorton | Texas | 48447 | 46 | 2 |
829167 | 829167 | 2020-12-14 | Throckmorton | Texas | 48447 | 45 | 2 |
825921 | 825921 | 2020-12-13 | Throckmorton | Texas | 48447 | 45 | 2 |
822674 | 822674 | 2020-12-12 | Throckmorton | Texas | 48447 | 45 | 2 |
819428 | 819428 | 2020-12-11 | Throckmorton | Texas | 48447 | 45 | 2 |
816182 | 816182 | 2020-12-10 | Throckmorton | Texas | 48447 | 26 | 2 |
812936 | 812936 | 2020-12-09 | Throckmorton | Texas | 48447 | 26 | 2 |
809692 | 809692 | 2020-12-08 | Throckmorton | Texas | 48447 | 26 | 2 |
806447 | 806447 | 2020-12-07 | Throckmorton | Texas | 48447 | 25 | 2 |
803202 | 803202 | 2020-12-06 | Throckmorton | Texas | 48447 | 25 | 2 |
799957 | 799957 | 2020-12-05 | Throckmorton | Texas | 48447 | 25 | 2 |
796712 | 796712 | 2020-12-04 | Throckmorton | Texas | 48447 | 25 | 2 |
793467 | 793467 | 2020-12-03 | Throckmorton | Texas | 48447 | 25 | 2 |
790222 | 790222 | 2020-12-02 | Throckmorton | Texas | 48447 | 24 | 2 |
786977 | 786977 | 2020-12-01 | Throckmorton | Texas | 48447 | 23 | 2 |
783733 | 783733 | 2020-11-30 | Throckmorton | Texas | 48447 | 23 | 2 |
780488 | 780488 | 2020-11-29 | Throckmorton | Texas | 48447 | 23 | 2 |
777242 | 777242 | 2020-11-28 | Throckmorton | Texas | 48447 | 23 | 2 |
773997 | 773997 | 2020-11-27 | Throckmorton | Texas | 48447 | 23 | 2 |
770752 | 770752 | 2020-11-26 | Throckmorton | Texas | 48447 | 23 | 2 |
767506 | 767506 | 2020-11-25 | Throckmorton | Texas | 48447 | 23 | 2 |
764261 | 764261 | 2020-11-24 | Throckmorton | Texas | 48447 | 23 | 2 |
761016 | 761016 | 2020-11-23 | Throckmorton | Texas | 48447 | 23 | 2 |
757771 | 757771 | 2020-11-22 | Throckmorton | Texas | 48447 | 23 | 2 |
754524 | 754524 | 2020-11-21 | Throckmorton | Texas | 48447 | 23 | 2 |
751278 | 751278 | 2020-11-20 | Throckmorton | Texas | 48447 | 23 | 2 |
748032 | 748032 | 2020-11-19 | Throckmorton | Texas | 48447 | 22 | 2 |
744786 | 744786 | 2020-11-18 | Throckmorton | Texas | 48447 | 22 | 2 |
741539 | 741539 | 2020-11-17 | Throckmorton | Texas | 48447 | 22 | 2 |
738292 | 738292 | 2020-11-16 | Throckmorton | Texas | 48447 | 20 | 2 |
735048 | 735048 | 2020-11-15 | Throckmorton | Texas | 48447 | 20 | 2 |
731802 | 731802 | 2020-11-14 | Throckmorton | Texas | 48447 | 20 | 2 |
728557 | 728557 | 2020-11-13 | Throckmorton | Texas | 48447 | 20 | 2 |
725314 | 725314 | 2020-11-12 | Throckmorton | Texas | 48447 | 20 | 2 |
722071 | 722071 | 2020-11-11 | Throckmorton | Texas | 48447 | 20 | 2 |
718828 | 718828 | 2020-11-10 | Throckmorton | Texas | 48447 | 20 | 2 |
715585 | 715585 | 2020-11-09 | Throckmorton | Texas | 48447 | 20 | 2 |
712341 | 712341 | 2020-11-08 | Throckmorton | Texas | 48447 | 20 | 2 |
709097 | 709097 | 2020-11-07 | Throckmorton | Texas | 48447 | 20 | 2 |
705853 | 705853 | 2020-11-06 | Throckmorton | Texas | 48447 | 20 | 2 |
702610 | 702610 | 2020-11-05 | Throckmorton | Texas | 48447 | 20 | 2 |
699367 | 699367 | 2020-11-04 | Throckmorton | Texas | 48447 | 19 | 2 |
696123 | 696123 | 2020-11-03 | Throckmorton | Texas | 48447 | 19 | 2 |
692881 | 692881 | 2020-11-02 | Throckmorton | Texas | 48447 | 19 | 2 |
689637 | 689637 | 2020-11-01 | Throckmorton | Texas | 48447 | 19 | 2 |
686392 | 686392 | 2020-10-31 | Throckmorton | Texas | 48447 | 19 | 2 |
683149 | 683149 | 2020-10-30 | Throckmorton | Texas | 48447 | 19 | 2 |
679906 | 679906 | 2020-10-29 | Throckmorton | Texas | 48447 | 19 | 2 |
676663 | 676663 | 2020-10-28 | Throckmorton | Texas | 48447 | 19 | 2 |
673420 | 673420 | 2020-10-27 | Throckmorton | Texas | 48447 | 17 | 2 |
670178 | 670178 | 2020-10-26 | Throckmorton | Texas | 48447 | 17 | 2 |
666935 | 666935 | 2020-10-25 | Throckmorton | Texas | 48447 | 17 | 2 |
663690 | 663690 | 2020-10-24 | Throckmorton | Texas | 48447 | 17 | 2 |
660446 | 660446 | 2020-10-23 | Throckmorton | Texas | 48447 | 17 | 2 |
657202 | 657202 | 2020-10-22 | Throckmorton | Texas | 48447 | 17 | 2 |
653957 | 653957 | 2020-10-21 | Throckmorton | Texas | 48447 | 17 | 2 |
650712 | 650712 | 2020-10-20 | Throckmorton | Texas | 48447 | 16 | 2 |
647468 | 647468 | 2020-10-19 | Throckmorton | Texas | 48447 | 16 | 2 |
644222 | 644222 | 2020-10-18 | Throckmorton | Texas | 48447 | 16 | 2 |
640974 | 640974 | 2020-10-17 | Throckmorton | Texas | 48447 | 16 | 2 |
637727 | 637727 | 2020-10-16 | Throckmorton | Texas | 48447 | 15 | 2 |
634482 | 634482 | 2020-10-15 | Throckmorton | Texas | 48447 | 15 | 2 |
631237 | 631237 | 2020-10-14 | Throckmorton | Texas | 48447 | 14 | 2 |
627993 | 627993 | 2020-10-13 | Throckmorton | Texas | 48447 | 14 | 2 |
624750 | 624750 | 2020-10-12 | Throckmorton | Texas | 48447 | 14 | 2 |
621507 | 621507 | 2020-10-11 | Throckmorton | Texas | 48447 | 14 | 2 |
618264 | 618264 | 2020-10-10 | Throckmorton | Texas | 48447 | 14 | 2 |
615022 | 615022 | 2020-10-09 | Throckmorton | Texas | 48447 | 14 | 2 |
611781 | 611781 | 2020-10-08 | Throckmorton | Texas | 48447 | 13 | 2 |
608539 | 608539 | 2020-10-07 | Throckmorton | Texas | 48447 | 10 | 2 |
605296 | 605296 | 2020-10-06 | Throckmorton | Texas | 48447 | 9 | 2 |
602054 | 602054 | 2020-10-05 | Throckmorton | Texas | 48447 | 8 | 2 |
598811 | 598811 | 2020-10-04 | Throckmorton | Texas | 48447 | 8 | 2 |
595568 | 595568 | 2020-10-03 | Throckmorton | Texas | 48447 | 8 | 2 |
592326 | 592326 | 2020-10-02 | Throckmorton | Texas | 48447 | 8 | 2 |
589086 | 589086 | 2020-10-01 | Throckmorton | Texas | 48447 | 8 | 2 |
585845 | 585845 | 2020-09-30 | Throckmorton | Texas | 48447 | 8 | 2 |
582605 | 582605 | 2020-09-29 | Throckmorton | Texas | 48447 | 8 | 2 |
579366 | 579366 | 2020-09-28 | Throckmorton | Texas | 48447 | 8 | 2 |
576125 | 576125 | 2020-09-27 | Throckmorton | Texas | 48447 | 8 | 2 |
572881 | 572881 | 2020-09-26 | Throckmorton | Texas | 48447 | 8 | 2 |
569639 | 569639 | 2020-09-25 | Throckmorton | Texas | 48447 | 8 | 2 |
566398 | 566398 | 2020-09-24 | Throckmorton | Texas | 48447 | 8 | 2 |
563157 | 563157 | 2020-09-23 | Throckmorton | Texas | 48447 | 8 | 2 |
559918 | 559918 | 2020-09-22 | Throckmorton | Texas | 48447 | 8 | 2 |
556682 | 556682 | 2020-09-21 | Throckmorton | Texas | 48447 | 7 | 2 |
553445 | 553445 | 2020-09-20 | Throckmorton | Texas | 48447 | 7 | 2 |
550206 | 550206 | 2020-09-19 | Throckmorton | Texas | 48447 | 7 | 2 |
546967 | 546967 | 2020-09-18 | Throckmorton | Texas | 48447 | 7 | 2 |
543730 | 543730 | 2020-09-17 | Throckmorton | Texas | 48447 | 6 | 2 |
540494 | 540494 | 2020-09-16 | Throckmorton | Texas | 48447 | 6 | 2 |
537257 | 537257 | 2020-09-15 | Throckmorton | Texas | 48447 | 6 | 2 |
534021 | 534021 | 2020-09-14 | Throckmorton | Texas | 48447 | 6 | 2 |
530786 | 530786 | 2020-09-13 | Throckmorton | Texas | 48447 | 6 | 2 |
527549 | 527549 | 2020-09-12 | Throckmorton | Texas | 48447 | 6 | 2 |
524313 | 524313 | 2020-09-11 | Throckmorton | Texas | 48447 | 6 | 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);