ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Cameron" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923089 | 923089 | 2021-01-12 | Cameron | Texas | 48061 | 31347 | 1212 |
919844 | 919844 | 2021-01-11 | Cameron | Texas | 48061 | 31347 | 1212 |
916599 | 916599 | 2021-01-10 | Cameron | Texas | 48061 | 31192 | 1205 |
913354 | 913354 | 2021-01-09 | Cameron | Texas | 48061 | 31192 | 1205 |
910109 | 910109 | 2021-01-08 | Cameron | Texas | 48061 | 31192 | 1205 |
906864 | 906864 | 2021-01-07 | Cameron | Texas | 48061 | 30969 | 1201 |
903618 | 903618 | 2021-01-06 | Cameron | Texas | 48061 | 30768 | 1198 |
900373 | 900373 | 2021-01-05 | Cameron | Texas | 48061 | 30465 | 1193 |
897128 | 897128 | 2021-01-04 | Cameron | Texas | 48061 | 30292 | 1187 |
893882 | 893882 | 2021-01-03 | Cameron | Texas | 48061 | 29672 | 1186 |
890636 | 890636 | 2021-01-02 | Cameron | Texas | 48061 | 29672 | 1186 |
887389 | 887389 | 2021-01-01 | Cameron | Texas | 48061 | 29672 | 1186 |
884144 | 884144 | 2020-12-31 | Cameron | Texas | 48061 | 29525 | 1183 |
880899 | 880899 | 2020-12-30 | Cameron | Texas | 48061 | 29525 | 1183 |
877654 | 877654 | 2020-12-29 | Cameron | Texas | 48061 | 29321 | 1173 |
874409 | 874409 | 2020-12-28 | Cameron | Texas | 48061 | 29321 | 1173 |
871164 | 871164 | 2020-12-27 | Cameron | Texas | 48061 | 28875 | 1172 |
867919 | 867919 | 2020-12-26 | Cameron | Texas | 48061 | 28875 | 1172 |
864674 | 864674 | 2020-12-25 | Cameron | Texas | 48061 | 28875 | 1172 |
861429 | 861429 | 2020-12-24 | Cameron | Texas | 48061 | 28875 | 1172 |
858184 | 858184 | 2020-12-23 | Cameron | Texas | 48061 | 28740 | 1168 |
854939 | 854939 | 2020-12-22 | Cameron | Texas | 48061 | 28613 | 1164 |
851694 | 851694 | 2020-12-21 | Cameron | Texas | 48061 | 28252 | 1159 |
848449 | 848449 | 2020-12-20 | Cameron | Texas | 48061 | 28252 | 1159 |
845204 | 845204 | 2020-12-19 | Cameron | Texas | 48061 | 28252 | 1159 |
841958 | 841958 | 2020-12-18 | Cameron | Texas | 48061 | 28252 | 1159 |
838713 | 838713 | 2020-12-17 | Cameron | Texas | 48061 | 28113 | 1158 |
835467 | 835467 | 2020-12-16 | Cameron | Texas | 48061 | 27926 | 1157 |
832221 | 832221 | 2020-12-15 | Cameron | Texas | 48061 | 27742 | 1153 |
828974 | 828974 | 2020-12-14 | Cameron | Texas | 48061 | 27585 | 1150 |
825728 | 825728 | 2020-12-13 | Cameron | Texas | 48061 | 27291 | 1146 |
822481 | 822481 | 2020-12-12 | Cameron | Texas | 48061 | 27291 | 1146 |
819235 | 819235 | 2020-12-11 | Cameron | Texas | 48061 | 27291 | 1146 |
815989 | 815989 | 2020-12-10 | Cameron | Texas | 48061 | 27178 | 1143 |
812743 | 812743 | 2020-12-09 | Cameron | Texas | 48061 | 27021 | 1142 |
809499 | 809499 | 2020-12-08 | Cameron | Texas | 48061 | 26937 | 1140 |
806254 | 806254 | 2020-12-07 | Cameron | Texas | 48061 | 26836 | 1136 |
803009 | 803009 | 2020-12-06 | Cameron | Texas | 48061 | 26575 | 1132 |
799764 | 799764 | 2020-12-05 | Cameron | Texas | 48061 | 26575 | 1132 |
796519 | 796519 | 2020-12-04 | Cameron | Texas | 48061 | 26575 | 1132 |
793274 | 793274 | 2020-12-03 | Cameron | Texas | 48061 | 26466 | 1129 |
790029 | 790029 | 2020-12-02 | Cameron | Texas | 48061 | 26342 | 1127 |
786784 | 786784 | 2020-12-01 | Cameron | Texas | 48061 | 26290 | 1125 |
783540 | 783540 | 2020-11-30 | Cameron | Texas | 48061 | 26151 | 1121 |
780295 | 780295 | 2020-11-29 | Cameron | Texas | 48061 | 25855 | 1115 |
777049 | 777049 | 2020-11-28 | Cameron | Texas | 48061 | 25855 | 1115 |
773804 | 773804 | 2020-11-27 | Cameron | Texas | 48061 | 25855 | 1115 |
770559 | 770559 | 2020-11-26 | Cameron | Texas | 48061 | 25855 | 1115 |
767313 | 767313 | 2020-11-25 | Cameron | Texas | 48061 | 25855 | 1115 |
764068 | 764068 | 2020-11-24 | Cameron | Texas | 48061 | 25772 | 1115 |
760823 | 760823 | 2020-11-23 | Cameron | Texas | 48061 | 25701 | 1112 |
757578 | 757578 | 2020-11-22 | Cameron | Texas | 48061 | 25507 | 1110 |
754331 | 754331 | 2020-11-21 | Cameron | Texas | 48061 | 25507 | 1110 |
751085 | 751085 | 2020-11-20 | Cameron | Texas | 48061 | 25507 | 1110 |
747839 | 747839 | 2020-11-19 | Cameron | Texas | 48061 | 25396 | 1108 |
744593 | 744593 | 2020-11-18 | Cameron | Texas | 48061 | 25308 | 1106 |
741346 | 741346 | 2020-11-17 | Cameron | Texas | 48061 | 25234 | 1103 |
738100 | 738100 | 2020-11-16 | Cameron | Texas | 48061 | 25159 | 1100 |
734856 | 734856 | 2020-11-15 | Cameron | Texas | 48061 | 24992 | 1100 |
731610 | 731610 | 2020-11-14 | Cameron | Texas | 48061 | 24992 | 1100 |
728365 | 728365 | 2020-11-13 | Cameron | Texas | 48061 | 24992 | 1100 |
725122 | 725122 | 2020-11-12 | Cameron | Texas | 48061 | 24895 | 1099 |
721879 | 721879 | 2020-11-11 | Cameron | Texas | 48061 | 24825 | 1096 |
718636 | 718636 | 2020-11-10 | Cameron | Texas | 48061 | 24825 | 1096 |
715393 | 715393 | 2020-11-09 | Cameron | Texas | 48061 | 24747 | 1094 |
712149 | 712149 | 2020-11-08 | Cameron | Texas | 48061 | 24598 | 1092 |
708905 | 708905 | 2020-11-07 | Cameron | Texas | 48061 | 24598 | 1092 |
705661 | 705661 | 2020-11-06 | Cameron | Texas | 48061 | 24598 | 1092 |
702418 | 702418 | 2020-11-05 | Cameron | Texas | 48061 | 24478 | 1089 |
699175 | 699175 | 2020-11-04 | Cameron | Texas | 48061 | 24478 | 1089 |
695931 | 695931 | 2020-11-03 | Cameron | Texas | 48061 | 24380 | 1085 |
692689 | 692689 | 2020-11-02 | Cameron | Texas | 48061 | 24380 | 1085 |
689445 | 689445 | 2020-11-01 | Cameron | Texas | 48061 | 24280 | 1083 |
686200 | 686200 | 2020-10-31 | Cameron | Texas | 48061 | 24280 | 1083 |
682957 | 682957 | 2020-10-30 | Cameron | Texas | 48061 | 24280 | 1083 |
679714 | 679714 | 2020-10-29 | Cameron | Texas | 48061 | 24221 | 1083 |
676471 | 676471 | 2020-10-28 | Cameron | Texas | 48061 | 24180 | 1081 |
673228 | 673228 | 2020-10-27 | Cameron | Texas | 48061 | 24150 | 1081 |
669986 | 669986 | 2020-10-26 | Cameron | Texas | 48061 | 24085 | 1079 |
666743 | 666743 | 2020-10-25 | Cameron | Texas | 48061 | 23976 | 1078 |
663498 | 663498 | 2020-10-24 | Cameron | Texas | 48061 | 23976 | 1078 |
660254 | 660254 | 2020-10-23 | Cameron | Texas | 48061 | 23976 | 1078 |
657010 | 657010 | 2020-10-22 | Cameron | Texas | 48061 | 23937 | 1075 |
653765 | 653765 | 2020-10-21 | Cameron | Texas | 48061 | 23906 | 1072 |
650520 | 650520 | 2020-10-20 | Cameron | Texas | 48061 | 23871 | 1070 |
647276 | 647276 | 2020-10-19 | Cameron | Texas | 48061 | 23818 | 1068 |
644030 | 644030 | 2020-10-18 | Cameron | Texas | 48061 | 23709 | 1066 |
640782 | 640782 | 2020-10-17 | Cameron | Texas | 48061 | 23709 | 1066 |
637535 | 637535 | 2020-10-16 | Cameron | Texas | 48061 | 23662 | 1063 |
634290 | 634290 | 2020-10-15 | Cameron | Texas | 48061 | 23662 | 1063 |
631045 | 631045 | 2020-10-14 | Cameron | Texas | 48061 | 23612 | 1058 |
627801 | 627801 | 2020-10-13 | Cameron | Texas | 48061 | 23559 | 1052 |
624559 | 624559 | 2020-10-12 | Cameron | Texas | 48061 | 23492 | 1047 |
621316 | 621316 | 2020-10-11 | Cameron | Texas | 48061 | 23312 | 1044 |
618073 | 618073 | 2020-10-10 | Cameron | Texas | 48061 | 23312 | 1044 |
614831 | 614831 | 2020-10-09 | Cameron | Texas | 48061 | 23174 | 1042 |
611590 | 611590 | 2020-10-08 | Cameron | Texas | 48061 | 23174 | 1042 |
608348 | 608348 | 2020-10-07 | Cameron | Texas | 48061 | 23127 | 1037 |
605105 | 605105 | 2020-10-06 | Cameron | Texas | 48061 | 23084 | 1034 |
601863 | 601863 | 2020-10-05 | Cameron | Texas | 48061 | 23029 | 1029 |
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);