ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 48379 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280356 | 1280356 | 2021-05-02 | Rains | Texas | 48379 | 797 | 25 |
1277109 | 1277109 | 2021-05-01 | Rains | Texas | 48379 | 797 | 25 |
1273862 | 1273862 | 2021-04-30 | Rains | Texas | 48379 | 797 | 25 |
1270615 | 1270615 | 2021-04-29 | Rains | Texas | 48379 | 796 | 25 |
1267368 | 1267368 | 2021-04-28 | Rains | Texas | 48379 | 796 | 25 |
1264121 | 1264121 | 2021-04-27 | Rains | Texas | 48379 | 796 | 25 |
1260874 | 1260874 | 2021-04-26 | Rains | Texas | 48379 | 790 | 25 |
1257627 | 1257627 | 2021-04-25 | Rains | Texas | 48379 | 790 | 25 |
1254380 | 1254380 | 2021-04-24 | Rains | Texas | 48379 | 790 | 25 |
1251133 | 1251133 | 2021-04-23 | Rains | Texas | 48379 | 790 | 25 |
1247886 | 1247886 | 2021-04-22 | Rains | Texas | 48379 | 790 | 25 |
1244639 | 1244639 | 2021-04-21 | Rains | Texas | 48379 | 788 | 25 |
1241392 | 1241392 | 2021-04-20 | Rains | Texas | 48379 | 788 | 25 |
1238145 | 1238145 | 2021-04-19 | Rains | Texas | 48379 | 785 | 25 |
1234898 | 1234898 | 2021-04-18 | Rains | Texas | 48379 | 785 | 25 |
1231650 | 1231650 | 2021-04-17 | Rains | Texas | 48379 | 785 | 25 |
1228402 | 1228402 | 2021-04-16 | Rains | Texas | 48379 | 785 | 25 |
1225154 | 1225154 | 2021-04-15 | Rains | Texas | 48379 | 785 | 25 |
1221907 | 1221907 | 2021-04-14 | Rains | Texas | 48379 | 785 | 25 |
1218659 | 1218659 | 2021-04-13 | Rains | Texas | 48379 | 785 | 25 |
1215411 | 1215411 | 2021-04-12 | Rains | Texas | 48379 | 785 | 25 |
1212164 | 1212164 | 2021-04-11 | Rains | Texas | 48379 | 785 | 25 |
1208915 | 1208915 | 2021-04-10 | Rains | Texas | 48379 | 785 | 25 |
1205667 | 1205667 | 2021-04-09 | Rains | Texas | 48379 | 785 | 25 |
1202419 | 1202419 | 2021-04-08 | Rains | Texas | 48379 | 785 | 25 |
1199170 | 1199170 | 2021-04-07 | Rains | Texas | 48379 | 783 | 25 |
1195921 | 1195921 | 2021-04-06 | Rains | Texas | 48379 | 783 | 25 |
1192673 | 1192673 | 2021-04-05 | Rains | Texas | 48379 | 783 | 25 |
1189424 | 1189424 | 2021-04-04 | Rains | Texas | 48379 | 783 | 25 |
1186177 | 1186177 | 2021-04-03 | Rains | Texas | 48379 | 783 | 25 |
1182930 | 1182930 | 2021-04-02 | Rains | Texas | 48379 | 783 | 25 |
1179683 | 1179683 | 2021-04-01 | Rains | Texas | 48379 | 783 | 25 |
1176436 | 1176436 | 2021-03-31 | Rains | Texas | 48379 | 783 | 25 |
1173189 | 1173189 | 2021-03-30 | Rains | Texas | 48379 | 783 | 25 |
1169942 | 1169942 | 2021-03-29 | Rains | Texas | 48379 | 783 | 25 |
1166694 | 1166694 | 2021-03-28 | Rains | Texas | 48379 | 782 | 25 |
1163446 | 1163446 | 2021-03-27 | Rains | Texas | 48379 | 782 | 25 |
1160197 | 1160197 | 2021-03-26 | Rains | Texas | 48379 | 782 | 25 |
1156950 | 1156950 | 2021-03-25 | Rains | Texas | 48379 | 782 | 25 |
1153703 | 1153703 | 2021-03-24 | Rains | Texas | 48379 | 780 | 25 |
1150456 | 1150456 | 2021-03-23 | Rains | Texas | 48379 | 780 | 25 |
1147209 | 1147209 | 2021-03-22 | Rains | Texas | 48379 | 780 | 25 |
1143962 | 1143962 | 2021-03-21 | Rains | Texas | 48379 | 779 | 25 |
1140715 | 1140715 | 2021-03-20 | Rains | Texas | 48379 | 779 | 25 |
1137469 | 1137469 | 2021-03-19 | Rains | Texas | 48379 | 779 | 25 |
1134223 | 1134223 | 2021-03-18 | Rains | Texas | 48379 | 778 | 25 |
1130975 | 1130975 | 2021-03-17 | Rains | Texas | 48379 | 778 | 25 |
1127728 | 1127728 | 2021-03-16 | Rains | Texas | 48379 | 774 | 25 |
1124482 | 1124482 | 2021-03-15 | Rains | Texas | 48379 | 774 | 24 |
1121236 | 1121236 | 2021-03-14 | Rains | Texas | 48379 | 774 | 24 |
1117989 | 1117989 | 2021-03-13 | Rains | Texas | 48379 | 774 | 24 |
1114742 | 1114742 | 2021-03-12 | Rains | Texas | 48379 | 774 | 24 |
1111496 | 1111496 | 2021-03-11 | Rains | Texas | 48379 | 771 | 24 |
1108250 | 1108250 | 2021-03-10 | Rains | Texas | 48379 | 770 | 24 |
1105004 | 1105004 | 2021-03-09 | Rains | Texas | 48379 | 770 | 24 |
1101758 | 1101758 | 2021-03-08 | Rains | Texas | 48379 | 770 | 24 |
1098512 | 1098512 | 2021-03-07 | Rains | Texas | 48379 | 769 | 24 |
1095264 | 1095264 | 2021-03-06 | Rains | Texas | 48379 | 769 | 24 |
1092018 | 1092018 | 2021-03-05 | Rains | Texas | 48379 | 769 | 24 |
1088772 | 1088772 | 2021-03-04 | Rains | Texas | 48379 | 763 | 24 |
1085527 | 1085527 | 2021-03-03 | Rains | Texas | 48379 | 763 | 24 |
1082281 | 1082281 | 2021-03-02 | Rains | Texas | 48379 | 762 | 24 |
1079035 | 1079035 | 2021-03-01 | Rains | Texas | 48379 | 762 | 24 |
1075790 | 1075790 | 2021-02-28 | Rains | Texas | 48379 | 761 | 24 |
1072544 | 1072544 | 2021-02-27 | Rains | Texas | 48379 | 761 | 24 |
1069298 | 1069298 | 2021-02-26 | Rains | Texas | 48379 | 761 | 24 |
1066053 | 1066053 | 2021-02-25 | Rains | Texas | 48379 | 753 | 23 |
1062808 | 1062808 | 2021-02-24 | Rains | Texas | 48379 | 751 | 23 |
1059563 | 1059563 | 2021-02-23 | Rains | Texas | 48379 | 751 | 23 |
1056317 | 1056317 | 2021-02-22 | Rains | Texas | 48379 | 751 | 23 |
1053071 | 1053071 | 2021-02-21 | Rains | Texas | 48379 | 747 | 23 |
1049824 | 1049824 | 2021-02-20 | Rains | Texas | 48379 | 747 | 23 |
1046577 | 1046577 | 2021-02-19 | Rains | Texas | 48379 | 747 | 23 |
1043332 | 1043332 | 2021-02-18 | Rains | Texas | 48379 | 747 | 23 |
1040087 | 1040087 | 2021-02-17 | Rains | Texas | 48379 | 747 | 23 |
1036842 | 1036842 | 2021-02-16 | Rains | Texas | 48379 | 745 | 23 |
1033597 | 1033597 | 2021-02-15 | Rains | Texas | 48379 | 739 | 23 |
1030351 | 1030351 | 2021-02-14 | Rains | Texas | 48379 | 739 | 23 |
1027104 | 1027104 | 2021-02-13 | Rains | Texas | 48379 | 739 | 23 |
1023859 | 1023859 | 2021-02-12 | Rains | Texas | 48379 | 739 | 23 |
1020614 | 1020614 | 2021-02-11 | Rains | Texas | 48379 | 734 | 23 |
1017369 | 1017369 | 2021-02-10 | Rains | Texas | 48379 | 734 | 23 |
1014124 | 1014124 | 2021-02-09 | Rains | Texas | 48379 | 721 | 23 |
1010879 | 1010879 | 2021-02-08 | Rains | Texas | 48379 | 719 | 23 |
1007633 | 1007633 | 2021-02-07 | Rains | Texas | 48379 | 719 | 23 |
1004387 | 1004387 | 2021-02-06 | Rains | Texas | 48379 | 719 | 23 |
1001141 | 1001141 | 2021-02-05 | Rains | Texas | 48379 | 719 | 23 |
997895 | 997895 | 2021-02-04 | Rains | Texas | 48379 | 709 | 23 |
994649 | 994649 | 2021-02-03 | Rains | Texas | 48379 | 709 | 22 |
991403 | 991403 | 2021-02-02 | Rains | Texas | 48379 | 695 | 22 |
988157 | 988157 | 2021-02-01 | Rains | Texas | 48379 | 695 | 21 |
984910 | 984910 | 2021-01-31 | Rains | Texas | 48379 | 687 | 21 |
981663 | 981663 | 2021-01-30 | Rains | Texas | 48379 | 687 | 21 |
978417 | 978417 | 2021-01-29 | Rains | Texas | 48379 | 683 | 21 |
975172 | 975172 | 2021-01-28 | Rains | Texas | 48379 | 683 | 21 |
971927 | 971927 | 2021-01-27 | Rains | Texas | 48379 | 670 | 20 |
968682 | 968682 | 2021-01-26 | Rains | Texas | 48379 | 670 | 20 |
965438 | 965438 | 2021-01-25 | Rains | Texas | 48379 | 655 | 20 |
962193 | 962193 | 2021-01-24 | Rains | Texas | 48379 | 655 | 20 |
958948 | 958948 | 2021-01-23 | Rains | Texas | 48379 | 655 | 20 |
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);