ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Parmer" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939469 | 939469 | 2021-01-17 | Parmer | Texas | 48369 | 1112 | 32 |
936224 | 936224 | 2021-01-16 | Parmer | Texas | 48369 | 1112 | 32 |
932979 | 932979 | 2021-01-15 | Parmer | Texas | 48369 | 1111 | 32 |
929734 | 929734 | 2021-01-14 | Parmer | Texas | 48369 | 1111 | 32 |
926489 | 926489 | 2021-01-13 | Parmer | Texas | 48369 | 1110 | 32 |
923243 | 923243 | 2021-01-12 | Parmer | Texas | 48369 | 1103 | 32 |
919998 | 919998 | 2021-01-11 | Parmer | Texas | 48369 | 1102 | 32 |
916753 | 916753 | 2021-01-10 | Parmer | Texas | 48369 | 1102 | 32 |
913508 | 913508 | 2021-01-09 | Parmer | Texas | 48369 | 1102 | 32 |
910263 | 910263 | 2021-01-08 | Parmer | Texas | 48369 | 1099 | 32 |
907018 | 907018 | 2021-01-07 | Parmer | Texas | 48369 | 1100 | 32 |
903772 | 903772 | 2021-01-06 | Parmer | Texas | 48369 | 1093 | 32 |
900527 | 900527 | 2021-01-05 | Parmer | Texas | 48369 | 1081 | 32 |
897282 | 897282 | 2021-01-04 | Parmer | Texas | 48369 | 1081 | 32 |
894036 | 894036 | 2021-01-03 | Parmer | Texas | 48369 | 1081 | 32 |
890790 | 890790 | 2021-01-02 | Parmer | Texas | 48369 | 1081 | 32 |
887543 | 887543 | 2021-01-01 | Parmer | Texas | 48369 | 1081 | 32 |
884298 | 884298 | 2020-12-31 | Parmer | Texas | 48369 | 1079 | 32 |
881053 | 881053 | 2020-12-30 | Parmer | Texas | 48369 | 1064 | 32 |
877808 | 877808 | 2020-12-29 | Parmer | Texas | 48369 | 1052 | 32 |
874563 | 874563 | 2020-12-28 | Parmer | Texas | 48369 | 1051 | 32 |
871318 | 871318 | 2020-12-27 | Parmer | Texas | 48369 | 1051 | 32 |
868073 | 868073 | 2020-12-26 | Parmer | Texas | 48369 | 1051 | 32 |
864828 | 864828 | 2020-12-25 | Parmer | Texas | 48369 | 1051 | 32 |
861583 | 861583 | 2020-12-24 | Parmer | Texas | 48369 | 1051 | 32 |
858338 | 858338 | 2020-12-23 | Parmer | Texas | 48369 | 1051 | 32 |
855093 | 855093 | 2020-12-22 | Parmer | Texas | 48369 | 1040 | 31 |
851848 | 851848 | 2020-12-21 | Parmer | Texas | 48369 | 1037 | 31 |
848603 | 848603 | 2020-12-20 | Parmer | Texas | 48369 | 1037 | 31 |
845358 | 845358 | 2020-12-19 | Parmer | Texas | 48369 | 1037 | 31 |
842112 | 842112 | 2020-12-18 | Parmer | Texas | 48369 | 1032 | 30 |
838867 | 838867 | 2020-12-17 | Parmer | Texas | 48369 | 1033 | 29 |
835621 | 835621 | 2020-12-16 | Parmer | Texas | 48369 | 1016 | 29 |
832375 | 832375 | 2020-12-15 | Parmer | Texas | 48369 | 1014 | 28 |
829128 | 829128 | 2020-12-14 | Parmer | Texas | 48369 | 1012 | 28 |
825882 | 825882 | 2020-12-13 | Parmer | Texas | 48369 | 1012 | 28 |
822635 | 822635 | 2020-12-12 | Parmer | Texas | 48369 | 998 | 28 |
819389 | 819389 | 2020-12-11 | Parmer | Texas | 48369 | 998 | 28 |
816143 | 816143 | 2020-12-10 | Parmer | Texas | 48369 | 780 | 28 |
812897 | 812897 | 2020-12-09 | Parmer | Texas | 48369 | 780 | 27 |
809653 | 809653 | 2020-12-08 | Parmer | Texas | 48369 | 776 | 27 |
806408 | 806408 | 2020-12-07 | Parmer | Texas | 48369 | 771 | 26 |
803163 | 803163 | 2020-12-06 | Parmer | Texas | 48369 | 770 | 26 |
799918 | 799918 | 2020-12-05 | Parmer | Texas | 48369 | 770 | 26 |
796673 | 796673 | 2020-12-04 | Parmer | Texas | 48369 | 755 | 25 |
793428 | 793428 | 2020-12-03 | Parmer | Texas | 48369 | 750 | 25 |
790183 | 790183 | 2020-12-02 | Parmer | Texas | 48369 | 722 | 25 |
786938 | 786938 | 2020-12-01 | Parmer | Texas | 48369 | 710 | 24 |
783694 | 783694 | 2020-11-30 | Parmer | Texas | 48369 | 704 | 22 |
780449 | 780449 | 2020-11-29 | Parmer | Texas | 48369 | 704 | 22 |
777203 | 777203 | 2020-11-28 | Parmer | Texas | 48369 | 704 | 22 |
773958 | 773958 | 2020-11-27 | Parmer | Texas | 48369 | 690 | 22 |
770713 | 770713 | 2020-11-26 | Parmer | Texas | 48369 | 690 | 22 |
767467 | 767467 | 2020-11-25 | Parmer | Texas | 48369 | 685 | 22 |
764222 | 764222 | 2020-11-24 | Parmer | Texas | 48369 | 681 | 22 |
760977 | 760977 | 2020-11-23 | Parmer | Texas | 48369 | 674 | 22 |
757732 | 757732 | 2020-11-22 | Parmer | Texas | 48369 | 674 | 22 |
754485 | 754485 | 2020-11-21 | Parmer | Texas | 48369 | 674 | 22 |
751239 | 751239 | 2020-11-20 | Parmer | Texas | 48369 | 669 | 22 |
747993 | 747993 | 2020-11-19 | Parmer | Texas | 48369 | 657 | 22 |
744747 | 744747 | 2020-11-18 | Parmer | Texas | 48369 | 653 | 22 |
741500 | 741500 | 2020-11-17 | Parmer | Texas | 48369 | 653 | 22 |
738253 | 738253 | 2020-11-16 | Parmer | Texas | 48369 | 653 | 22 |
735009 | 735009 | 2020-11-15 | Parmer | Texas | 48369 | 652 | 22 |
731763 | 731763 | 2020-11-14 | Parmer | Texas | 48369 | 652 | 21 |
728518 | 728518 | 2020-11-13 | Parmer | Texas | 48369 | 651 | 20 |
725275 | 725275 | 2020-11-12 | Parmer | Texas | 48369 | 641 | 20 |
722032 | 722032 | 2020-11-11 | Parmer | Texas | 48369 | 641 | 20 |
718789 | 718789 | 2020-11-10 | Parmer | Texas | 48369 | 638 | 20 |
715546 | 715546 | 2020-11-09 | Parmer | Texas | 48369 | 631 | 20 |
712302 | 712302 | 2020-11-08 | Parmer | Texas | 48369 | 631 | 20 |
709058 | 709058 | 2020-11-07 | Parmer | Texas | 48369 | 631 | 20 |
705814 | 705814 | 2020-11-06 | Parmer | Texas | 48369 | 612 | 20 |
702571 | 702571 | 2020-11-05 | Parmer | Texas | 48369 | 612 | 20 |
699328 | 699328 | 2020-11-04 | Parmer | Texas | 48369 | 609 | 19 |
696084 | 696084 | 2020-11-03 | Parmer | Texas | 48369 | 595 | 19 |
692842 | 692842 | 2020-11-02 | Parmer | Texas | 48369 | 579 | 19 |
689598 | 689598 | 2020-11-01 | Parmer | Texas | 48369 | 579 | 19 |
686353 | 686353 | 2020-10-31 | Parmer | Texas | 48369 | 579 | 19 |
683110 | 683110 | 2020-10-30 | Parmer | Texas | 48369 | 574 | 19 |
679867 | 679867 | 2020-10-29 | Parmer | Texas | 48369 | 579 | 19 |
676624 | 676624 | 2020-10-28 | Parmer | Texas | 48369 | 579 | 18 |
673381 | 673381 | 2020-10-27 | Parmer | Texas | 48369 | 579 | 18 |
670139 | 670139 | 2020-10-26 | Parmer | Texas | 48369 | 570 | 18 |
666896 | 666896 | 2020-10-25 | Parmer | Texas | 48369 | 570 | 18 |
663651 | 663651 | 2020-10-24 | Parmer | Texas | 48369 | 570 | 18 |
660407 | 660407 | 2020-10-23 | Parmer | Texas | 48369 | 552 | 18 |
657163 | 657163 | 2020-10-22 | Parmer | Texas | 48369 | 547 | 17 |
653918 | 653918 | 2020-10-21 | Parmer | Texas | 48369 | 547 | 17 |
650673 | 650673 | 2020-10-20 | Parmer | Texas | 48369 | 538 | 17 |
647429 | 647429 | 2020-10-19 | Parmer | Texas | 48369 | 532 | 16 |
644183 | 644183 | 2020-10-18 | Parmer | Texas | 48369 | 532 | 16 |
640935 | 640935 | 2020-10-17 | Parmer | Texas | 48369 | 529 | 16 |
637688 | 637688 | 2020-10-16 | Parmer | Texas | 48369 | 527 | 15 |
634443 | 634443 | 2020-10-15 | Parmer | Texas | 48369 | 521 | 15 |
631198 | 631198 | 2020-10-14 | Parmer | Texas | 48369 | 511 | 15 |
627954 | 627954 | 2020-10-13 | Parmer | Texas | 48369 | 495 | 14 |
624711 | 624711 | 2020-10-12 | Parmer | Texas | 48369 | 459 | 13 |
621468 | 621468 | 2020-10-11 | Parmer | Texas | 48369 | 459 | 13 |
618225 | 618225 | 2020-10-10 | Parmer | Texas | 48369 | 456 | 13 |
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);