ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
691 rows where fips = 48327 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936203 | 936203 | 2021-01-16 | Menard | Texas | 48327 | 180 | 5 |
932958 | 932958 | 2021-01-15 | Menard | Texas | 48327 | 175 | 5 |
929713 | 929713 | 2021-01-14 | Menard | Texas | 48327 | 174 | 5 |
926468 | 926468 | 2021-01-13 | Menard | Texas | 48327 | 174 | 4 |
923222 | 923222 | 2021-01-12 | Menard | Texas | 48327 | 174 | 4 |
919977 | 919977 | 2021-01-11 | Menard | Texas | 48327 | 172 | 4 |
916732 | 916732 | 2021-01-10 | Menard | Texas | 48327 | 172 | 4 |
913487 | 913487 | 2021-01-09 | Menard | Texas | 48327 | 172 | 4 |
910242 | 910242 | 2021-01-08 | Menard | Texas | 48327 | 172 | 4 |
906997 | 906997 | 2021-01-07 | Menard | Texas | 48327 | 172 | 4 |
903751 | 903751 | 2021-01-06 | Menard | Texas | 48327 | 171 | 4 |
900506 | 900506 | 2021-01-05 | Menard | Texas | 48327 | 170 | 4 |
897261 | 897261 | 2021-01-04 | Menard | Texas | 48327 | 170 | 4 |
894015 | 894015 | 2021-01-03 | Menard | Texas | 48327 | 170 | 4 |
890769 | 890769 | 2021-01-02 | Menard | Texas | 48327 | 170 | 4 |
887522 | 887522 | 2021-01-01 | Menard | Texas | 48327 | 170 | 4 |
884277 | 884277 | 2020-12-31 | Menard | Texas | 48327 | 170 | 4 |
881032 | 881032 | 2020-12-30 | Menard | Texas | 48327 | 172 | 3 |
877787 | 877787 | 2020-12-29 | Menard | Texas | 48327 | 172 | 3 |
874542 | 874542 | 2020-12-28 | Menard | Texas | 48327 | 163 | 3 |
871297 | 871297 | 2020-12-27 | Menard | Texas | 48327 | 163 | 3 |
868052 | 868052 | 2020-12-26 | Menard | Texas | 48327 | 163 | 3 |
864807 | 864807 | 2020-12-25 | Menard | Texas | 48327 | 162 | 3 |
861562 | 861562 | 2020-12-24 | Menard | Texas | 48327 | 160 | 3 |
858317 | 858317 | 2020-12-23 | Menard | Texas | 48327 | 157 | 3 |
855072 | 855072 | 2020-12-22 | Menard | Texas | 48327 | 156 | 3 |
851827 | 851827 | 2020-12-21 | Menard | Texas | 48327 | 154 | 3 |
848582 | 848582 | 2020-12-20 | Menard | Texas | 48327 | 152 | 3 |
845337 | 845337 | 2020-12-19 | Menard | Texas | 48327 | 152 | 3 |
842091 | 842091 | 2020-12-18 | Menard | Texas | 48327 | 151 | 3 |
838846 | 838846 | 2020-12-17 | Menard | Texas | 48327 | 146 | 3 |
835600 | 835600 | 2020-12-16 | Menard | Texas | 48327 | 142 | 3 |
832354 | 832354 | 2020-12-15 | Menard | Texas | 48327 | 142 | 3 |
829107 | 829107 | 2020-12-14 | Menard | Texas | 48327 | 141 | 3 |
825861 | 825861 | 2020-12-13 | Menard | Texas | 48327 | 139 | 3 |
822614 | 822614 | 2020-12-12 | Menard | Texas | 48327 | 139 | 3 |
819368 | 819368 | 2020-12-11 | Menard | Texas | 48327 | 139 | 3 |
816122 | 816122 | 2020-12-10 | Menard | Texas | 48327 | 119 | 3 |
812876 | 812876 | 2020-12-09 | Menard | Texas | 48327 | 119 | 3 |
809632 | 809632 | 2020-12-08 | Menard | Texas | 48327 | 119 | 3 |
806387 | 806387 | 2020-12-07 | Menard | Texas | 48327 | 119 | 3 |
803142 | 803142 | 2020-12-06 | Menard | Texas | 48327 | 118 | 3 |
799897 | 799897 | 2020-12-05 | Menard | Texas | 48327 | 117 | 3 |
796652 | 796652 | 2020-12-04 | Menard | Texas | 48327 | 116 | 3 |
793407 | 793407 | 2020-12-03 | Menard | Texas | 48327 | 114 | 3 |
790162 | 790162 | 2020-12-02 | Menard | Texas | 48327 | 113 | 3 |
786917 | 786917 | 2020-12-01 | Menard | Texas | 48327 | 112 | 3 |
783673 | 783673 | 2020-11-30 | Menard | Texas | 48327 | 112 | 3 |
780428 | 780428 | 2020-11-29 | Menard | Texas | 48327 | 112 | 3 |
777182 | 777182 | 2020-11-28 | Menard | Texas | 48327 | 112 | 3 |
773937 | 773937 | 2020-11-27 | Menard | Texas | 48327 | 112 | 3 |
770692 | 770692 | 2020-11-26 | Menard | Texas | 48327 | 108 | 3 |
767446 | 767446 | 2020-11-25 | Menard | Texas | 48327 | 108 | 3 |
764201 | 764201 | 2020-11-24 | Menard | Texas | 48327 | 107 | 3 |
760956 | 760956 | 2020-11-23 | Menard | Texas | 48327 | 107 | 3 |
757711 | 757711 | 2020-11-22 | Menard | Texas | 48327 | 106 | 3 |
754464 | 754464 | 2020-11-21 | Menard | Texas | 48327 | 104 | 3 |
751218 | 751218 | 2020-11-20 | Menard | Texas | 48327 | 103 | 3 |
747972 | 747972 | 2020-11-19 | Menard | Texas | 48327 | 100 | 3 |
744726 | 744726 | 2020-11-18 | Menard | Texas | 48327 | 98 | 3 |
741479 | 741479 | 2020-11-17 | Menard | Texas | 48327 | 97 | 3 |
738232 | 738232 | 2020-11-16 | Menard | Texas | 48327 | 91 | 3 |
734988 | 734988 | 2020-11-15 | Menard | Texas | 48327 | 91 | 3 |
731742 | 731742 | 2020-11-14 | Menard | Texas | 48327 | 91 | 3 |
728497 | 728497 | 2020-11-13 | Menard | Texas | 48327 | 88 | 3 |
725254 | 725254 | 2020-11-12 | Menard | Texas | 48327 | 87 | 2 |
722011 | 722011 | 2020-11-11 | Menard | Texas | 48327 | 85 | 1 |
718768 | 718768 | 2020-11-10 | Menard | Texas | 48327 | 84 | 1 |
715525 | 715525 | 2020-11-09 | Menard | Texas | 48327 | 84 | 1 |
712281 | 712281 | 2020-11-08 | Menard | Texas | 48327 | 84 | 1 |
709037 | 709037 | 2020-11-07 | Menard | Texas | 48327 | 84 | 1 |
705793 | 705793 | 2020-11-06 | Menard | Texas | 48327 | 84 | 0 |
702550 | 702550 | 2020-11-05 | Menard | Texas | 48327 | 80 | 0 |
699307 | 699307 | 2020-11-04 | Menard | Texas | 48327 | 78 | 0 |
696063 | 696063 | 2020-11-03 | Menard | Texas | 48327 | 78 | 0 |
692821 | 692821 | 2020-11-02 | Menard | Texas | 48327 | 77 | 0 |
689577 | 689577 | 2020-11-01 | Menard | Texas | 48327 | 77 | 0 |
686332 | 686332 | 2020-10-31 | Menard | Texas | 48327 | 77 | 0 |
683089 | 683089 | 2020-10-30 | Menard | Texas | 48327 | 78 | 0 |
679846 | 679846 | 2020-10-29 | Menard | Texas | 48327 | 75 | 0 |
676603 | 676603 | 2020-10-28 | Menard | Texas | 48327 | 72 | 0 |
673360 | 673360 | 2020-10-27 | Menard | Texas | 48327 | 68 | 0 |
670118 | 670118 | 2020-10-26 | Menard | Texas | 48327 | 62 | 0 |
666875 | 666875 | 2020-10-25 | Menard | Texas | 48327 | 62 | 0 |
663630 | 663630 | 2020-10-24 | Menard | Texas | 48327 | 62 | 0 |
660386 | 660386 | 2020-10-23 | Menard | Texas | 48327 | 50 | 0 |
657142 | 657142 | 2020-10-22 | Menard | Texas | 48327 | 49 | 0 |
653897 | 653897 | 2020-10-21 | Menard | Texas | 48327 | 49 | 0 |
650652 | 650652 | 2020-10-20 | Menard | Texas | 48327 | 40 | 0 |
647408 | 647408 | 2020-10-19 | Menard | Texas | 48327 | 39 | 0 |
644162 | 644162 | 2020-10-18 | Menard | Texas | 48327 | 39 | 0 |
640914 | 640914 | 2020-10-17 | Menard | Texas | 48327 | 39 | 0 |
637667 | 637667 | 2020-10-16 | Menard | Texas | 48327 | 39 | 0 |
634422 | 634422 | 2020-10-15 | Menard | Texas | 48327 | 39 | 0 |
631177 | 631177 | 2020-10-14 | Menard | Texas | 48327 | 38 | 0 |
627933 | 627933 | 2020-10-13 | Menard | Texas | 48327 | 37 | 0 |
624690 | 624690 | 2020-10-12 | Menard | Texas | 48327 | 35 | 0 |
621447 | 621447 | 2020-10-11 | Menard | Texas | 48327 | 35 | 0 |
618204 | 618204 | 2020-10-10 | Menard | Texas | 48327 | 35 | 0 |
614962 | 614962 | 2020-10-09 | Menard | Texas | 48327 | 32 | 0 |
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);