ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056202 | 1056202 | 2021-02-22 | Fayette | Texas | 48149 | 2233 | 50 |
1052956 | 1052956 | 2021-02-21 | Fayette | Texas | 48149 | 2229 | 50 |
1049709 | 1049709 | 2021-02-20 | Fayette | Texas | 48149 | 2229 | 50 |
1046462 | 1046462 | 2021-02-19 | Fayette | Texas | 48149 | 2229 | 50 |
1043217 | 1043217 | 2021-02-18 | Fayette | Texas | 48149 | 2224 | 50 |
1039972 | 1039972 | 2021-02-17 | Fayette | Texas | 48149 | 2219 | 50 |
1036727 | 1036727 | 2021-02-16 | Fayette | Texas | 48149 | 2219 | 50 |
1033482 | 1033482 | 2021-02-15 | Fayette | Texas | 48149 | 2208 | 50 |
1030236 | 1030236 | 2021-02-14 | Fayette | Texas | 48149 | 2208 | 50 |
1026989 | 1026989 | 2021-02-13 | Fayette | Texas | 48149 | 2208 | 50 |
1023744 | 1023744 | 2021-02-12 | Fayette | Texas | 48149 | 2197 | 50 |
1020499 | 1020499 | 2021-02-11 | Fayette | Texas | 48149 | 2188 | 50 |
1017254 | 1017254 | 2021-02-10 | Fayette | Texas | 48149 | 2167 | 50 |
1014009 | 1014009 | 2021-02-09 | Fayette | Texas | 48149 | 2159 | 50 |
1010764 | 1010764 | 2021-02-08 | Fayette | Texas | 48149 | 2153 | 50 |
1007518 | 1007518 | 2021-02-07 | Fayette | Texas | 48149 | 2142 | 50 |
1004272 | 1004272 | 2021-02-06 | Fayette | Texas | 48149 | 2139 | 50 |
1001026 | 1001026 | 2021-02-05 | Fayette | Texas | 48149 | 2120 | 50 |
997780 | 997780 | 2021-02-04 | Fayette | Texas | 48149 | 2111 | 49 |
994534 | 994534 | 2021-02-03 | Fayette | Texas | 48149 | 2096 | 48 |
991288 | 991288 | 2021-02-02 | Fayette | Texas | 48149 | 2087 | 48 |
988042 | 988042 | 2021-02-01 | Fayette | Texas | 48149 | 2060 | 48 |
984795 | 984795 | 2021-01-31 | Fayette | Texas | 48149 | 1594 | 48 |
981548 | 981548 | 2021-01-30 | Fayette | Texas | 48149 | 1588 | 48 |
978302 | 978302 | 2021-01-29 | Fayette | Texas | 48149 | 1577 | 48 |
975057 | 975057 | 2021-01-28 | Fayette | Texas | 48149 | 1564 | 48 |
971812 | 971812 | 2021-01-27 | Fayette | Texas | 48149 | 1544 | 46 |
968567 | 968567 | 2021-01-26 | Fayette | Texas | 48149 | 1533 | 46 |
965323 | 965323 | 2021-01-25 | Fayette | Texas | 48149 | 1524 | 45 |
962078 | 962078 | 2021-01-24 | Fayette | Texas | 48149 | 1522 | 45 |
958833 | 958833 | 2021-01-23 | Fayette | Texas | 48149 | 1522 | 45 |
955587 | 955587 | 2021-01-22 | Fayette | Texas | 48149 | 1511 | 44 |
952342 | 952342 | 2021-01-21 | Fayette | Texas | 48149 | 1489 | 44 |
949097 | 949097 | 2021-01-20 | Fayette | Texas | 48149 | 1462 | 43 |
945851 | 945851 | 2021-01-19 | Fayette | Texas | 48149 | 1447 | 43 |
942604 | 942604 | 2021-01-18 | Fayette | Texas | 48149 | 1432 | 43 |
939359 | 939359 | 2021-01-17 | Fayette | Texas | 48149 | 1431 | 43 |
936114 | 936114 | 2021-01-16 | Fayette | Texas | 48149 | 1430 | 43 |
932869 | 932869 | 2021-01-15 | Fayette | Texas | 48149 | 1410 | 43 |
929624 | 929624 | 2021-01-14 | Fayette | Texas | 48149 | 1403 | 43 |
926379 | 926379 | 2021-01-13 | Fayette | Texas | 48149 | 1372 | 40 |
923133 | 923133 | 2021-01-12 | Fayette | Texas | 48149 | 1370 | 39 |
919888 | 919888 | 2021-01-11 | Fayette | Texas | 48149 | 1367 | 39 |
916643 | 916643 | 2021-01-10 | Fayette | Texas | 48149 | 1367 | 39 |
913398 | 913398 | 2021-01-09 | Fayette | Texas | 48149 | 1360 | 39 |
910153 | 910153 | 2021-01-08 | Fayette | Texas | 48149 | 1354 | 37 |
906908 | 906908 | 2021-01-07 | Fayette | Texas | 48149 | 1339 | 37 |
903662 | 903662 | 2021-01-06 | Fayette | Texas | 48149 | 1324 | 36 |
900417 | 900417 | 2021-01-05 | Fayette | Texas | 48149 | 1313 | 36 |
897172 | 897172 | 2021-01-04 | Fayette | Texas | 48149 | 1301 | 36 |
893926 | 893926 | 2021-01-03 | Fayette | Texas | 48149 | 1301 | 35 |
890680 | 890680 | 2021-01-02 | Fayette | Texas | 48149 | 1298 | 35 |
887433 | 887433 | 2021-01-01 | Fayette | Texas | 48149 | 1298 | 35 |
884188 | 884188 | 2020-12-31 | Fayette | Texas | 48149 | 1290 | 35 |
880943 | 880943 | 2020-12-30 | Fayette | Texas | 48149 | 1277 | 34 |
877698 | 877698 | 2020-12-29 | Fayette | Texas | 48149 | 1260 | 32 |
874453 | 874453 | 2020-12-28 | Fayette | Texas | 48149 | 1241 | 32 |
871208 | 871208 | 2020-12-27 | Fayette | Texas | 48149 | 1241 | 32 |
867963 | 867963 | 2020-12-26 | Fayette | Texas | 48149 | 1239 | 32 |
864718 | 864718 | 2020-12-25 | Fayette | Texas | 48149 | 1239 | 32 |
861473 | 861473 | 2020-12-24 | Fayette | Texas | 48149 | 1239 | 32 |
858228 | 858228 | 2020-12-23 | Fayette | Texas | 48149 | 1238 | 32 |
854983 | 854983 | 2020-12-22 | Fayette | Texas | 48149 | 1225 | 32 |
851738 | 851738 | 2020-12-21 | Fayette | Texas | 48149 | 1191 | 32 |
848493 | 848493 | 2020-12-20 | Fayette | Texas | 48149 | 1191 | 32 |
845248 | 845248 | 2020-12-19 | Fayette | Texas | 48149 | 1185 | 32 |
842002 | 842002 | 2020-12-18 | Fayette | Texas | 48149 | 1173 | 32 |
838757 | 838757 | 2020-12-17 | Fayette | Texas | 48149 | 1156 | 32 |
835511 | 835511 | 2020-12-16 | Fayette | Texas | 48149 | 1144 | 31 |
832265 | 832265 | 2020-12-15 | Fayette | Texas | 48149 | 1127 | 30 |
829018 | 829018 | 2020-12-14 | Fayette | Texas | 48149 | 1090 | 30 |
825772 | 825772 | 2020-12-13 | Fayette | Texas | 48149 | 1087 | 30 |
822525 | 822525 | 2020-12-12 | Fayette | Texas | 48149 | 1083 | 30 |
819279 | 819279 | 2020-12-11 | Fayette | Texas | 48149 | 1075 | 30 |
816033 | 816033 | 2020-12-10 | Fayette | Texas | 48149 | 657 | 30 |
812787 | 812787 | 2020-12-09 | Fayette | Texas | 48149 | 645 | 29 |
809543 | 809543 | 2020-12-08 | Fayette | Texas | 48149 | 642 | 29 |
806298 | 806298 | 2020-12-07 | Fayette | Texas | 48149 | 624 | 29 |
803053 | 803053 | 2020-12-06 | Fayette | Texas | 48149 | 624 | 29 |
799808 | 799808 | 2020-12-05 | Fayette | Texas | 48149 | 624 | 29 |
796563 | 796563 | 2020-12-04 | Fayette | Texas | 48149 | 616 | 29 |
793318 | 793318 | 2020-12-03 | Fayette | Texas | 48149 | 612 | 29 |
790073 | 790073 | 2020-12-02 | Fayette | Texas | 48149 | 608 | 28 |
786828 | 786828 | 2020-12-01 | Fayette | Texas | 48149 | 607 | 27 |
783584 | 783584 | 2020-11-30 | Fayette | Texas | 48149 | 605 | 27 |
780339 | 780339 | 2020-11-29 | Fayette | Texas | 48149 | 604 | 26 |
777093 | 777093 | 2020-11-28 | Fayette | Texas | 48149 | 602 | 26 |
773848 | 773848 | 2020-11-27 | Fayette | Texas | 48149 | 602 | 26 |
770603 | 770603 | 2020-11-26 | Fayette | Texas | 48149 | 602 | 26 |
767357 | 767357 | 2020-11-25 | Fayette | Texas | 48149 | 595 | 26 |
764112 | 764112 | 2020-11-24 | Fayette | Texas | 48149 | 592 | 24 |
760867 | 760867 | 2020-11-23 | Fayette | Texas | 48149 | 585 | 23 |
757622 | 757622 | 2020-11-22 | Fayette | Texas | 48149 | 584 | 23 |
754375 | 754375 | 2020-11-21 | Fayette | Texas | 48149 | 583 | 23 |
751129 | 751129 | 2020-11-20 | Fayette | Texas | 48149 | 573 | 23 |
747883 | 747883 | 2020-11-19 | Fayette | Texas | 48149 | 570 | 23 |
744637 | 744637 | 2020-11-18 | Fayette | Texas | 48149 | 567 | 23 |
741390 | 741390 | 2020-11-17 | Fayette | Texas | 48149 | 566 | 23 |
738144 | 738144 | 2020-11-16 | Fayette | Texas | 48149 | 564 | 23 |
734900 | 734900 | 2020-11-15 | Fayette | Texas | 48149 | 564 | 23 |
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);