ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lubbock" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280318 | 1280318 | 2021-05-02 | Lubbock | Texas | 48303 | 48910 | 784 |
1277071 | 1277071 | 2021-05-01 | Lubbock | Texas | 48303 | 48910 | 784 |
1273824 | 1273824 | 2021-04-30 | Lubbock | Texas | 48303 | 48910 | 784 |
1270577 | 1270577 | 2021-04-29 | Lubbock | Texas | 48303 | 48890 | 784 |
1267330 | 1267330 | 2021-04-28 | Lubbock | Texas | 48303 | 48850 | 784 |
1264083 | 1264083 | 2021-04-27 | Lubbock | Texas | 48303 | 48830 | 783 |
1260836 | 1260836 | 2021-04-26 | Lubbock | Texas | 48303 | 48815 | 783 |
1257589 | 1257589 | 2021-04-25 | Lubbock | Texas | 48303 | 48798 | 783 |
1254342 | 1254342 | 2021-04-24 | Lubbock | Texas | 48303 | 48798 | 783 |
1251095 | 1251095 | 2021-04-23 | Lubbock | Texas | 48303 | 48798 | 783 |
1247848 | 1247848 | 2021-04-22 | Lubbock | Texas | 48303 | 48779 | 783 |
1244601 | 1244601 | 2021-04-21 | Lubbock | Texas | 48303 | 48770 | 783 |
1241354 | 1241354 | 2021-04-20 | Lubbock | Texas | 48303 | 48765 | 782 |
1238107 | 1238107 | 2021-04-19 | Lubbock | Texas | 48303 | 48751 | 782 |
1234860 | 1234860 | 2021-04-18 | Lubbock | Texas | 48303 | 48741 | 782 |
1231612 | 1231612 | 2021-04-17 | Lubbock | Texas | 48303 | 48741 | 782 |
1228364 | 1228364 | 2021-04-16 | Lubbock | Texas | 48303 | 48741 | 781 |
1225116 | 1225116 | 2021-04-15 | Lubbock | Texas | 48303 | 48733 | 781 |
1221869 | 1221869 | 2021-04-14 | Lubbock | Texas | 48303 | 48732 | 781 |
1218621 | 1218621 | 2021-04-13 | Lubbock | Texas | 48303 | 48725 | 781 |
1215373 | 1215373 | 2021-04-12 | Lubbock | Texas | 48303 | 48710 | 780 |
1212126 | 1212126 | 2021-04-11 | Lubbock | Texas | 48303 | 48687 | 780 |
1208877 | 1208877 | 2021-04-10 | Lubbock | Texas | 48303 | 48687 | 780 |
1205629 | 1205629 | 2021-04-09 | Lubbock | Texas | 48303 | 48687 | 780 |
1202381 | 1202381 | 2021-04-08 | Lubbock | Texas | 48303 | 48678 | 779 |
1199132 | 1199132 | 2021-04-07 | Lubbock | Texas | 48303 | 48671 | 779 |
1195883 | 1195883 | 2021-04-06 | Lubbock | Texas | 48303 | 48661 | 779 |
1192635 | 1192635 | 2021-04-05 | Lubbock | Texas | 48303 | 48647 | 779 |
1189386 | 1189386 | 2021-04-04 | Lubbock | Texas | 48303 | 48610 | 779 |
1186139 | 1186139 | 2021-04-03 | Lubbock | Texas | 48303 | 48610 | 779 |
1182892 | 1182892 | 2021-04-02 | Lubbock | Texas | 48303 | 48610 | 779 |
1179645 | 1179645 | 2021-04-01 | Lubbock | Texas | 48303 | 48608 | 778 |
1176398 | 1176398 | 2021-03-31 | Lubbock | Texas | 48303 | 48591 | 777 |
1173151 | 1173151 | 2021-03-30 | Lubbock | Texas | 48303 | 48577 | 776 |
1169904 | 1169904 | 2021-03-29 | Lubbock | Texas | 48303 | 48566 | 776 |
1166656 | 1166656 | 2021-03-28 | Lubbock | Texas | 48303 | 48537 | 776 |
1163408 | 1163408 | 2021-03-27 | Lubbock | Texas | 48303 | 48537 | 776 |
1160159 | 1160159 | 2021-03-26 | Lubbock | Texas | 48303 | 48537 | 775 |
1156912 | 1156912 | 2021-03-25 | Lubbock | Texas | 48303 | 48503 | 774 |
1153665 | 1153665 | 2021-03-24 | Lubbock | Texas | 48303 | 48470 | 773 |
1150418 | 1150418 | 2021-03-23 | Lubbock | Texas | 48303 | 48458 | 773 |
1147171 | 1147171 | 2021-03-22 | Lubbock | Texas | 48303 | 48457 | 773 |
1143924 | 1143924 | 2021-03-21 | Lubbock | Texas | 48303 | 48433 | 773 |
1140677 | 1140677 | 2021-03-20 | Lubbock | Texas | 48303 | 48433 | 773 |
1137431 | 1137431 | 2021-03-19 | Lubbock | Texas | 48303 | 48433 | 773 |
1134185 | 1134185 | 2021-03-18 | Lubbock | Texas | 48303 | 48424 | 773 |
1130937 | 1130937 | 2021-03-17 | Lubbock | Texas | 48303 | 48414 | 773 |
1127690 | 1127690 | 2021-03-16 | Lubbock | Texas | 48303 | 48399 | 771 |
1124444 | 1124444 | 2021-03-15 | Lubbock | Texas | 48303 | 48392 | 771 |
1121198 | 1121198 | 2021-03-14 | Lubbock | Texas | 48303 | 48347 | 771 |
1117951 | 1117951 | 2021-03-13 | Lubbock | Texas | 48303 | 48347 | 770 |
1114704 | 1114704 | 2021-03-12 | Lubbock | Texas | 48303 | 48347 | 769 |
1111458 | 1111458 | 2021-03-11 | Lubbock | Texas | 48303 | 48319 | 769 |
1108212 | 1108212 | 2021-03-10 | Lubbock | Texas | 48303 | 48301 | 769 |
1104966 | 1104966 | 2021-03-09 | Lubbock | Texas | 48303 | 48285 | 769 |
1101720 | 1101720 | 2021-03-08 | Lubbock | Texas | 48303 | 48272 | 769 |
1098474 | 1098474 | 2021-03-07 | Lubbock | Texas | 48303 | 48260 | 769 |
1095226 | 1095226 | 2021-03-06 | Lubbock | Texas | 48303 | 48249 | 769 |
1091980 | 1091980 | 2021-03-05 | Lubbock | Texas | 48303 | 48241 | 769 |
1088734 | 1088734 | 2021-03-04 | Lubbock | Texas | 48303 | 48223 | 769 |
1085489 | 1085489 | 2021-03-03 | Lubbock | Texas | 48303 | 48196 | 770 |
1082243 | 1082243 | 2021-03-02 | Lubbock | Texas | 48303 | 48191 | 769 |
1078997 | 1078997 | 2021-03-01 | Lubbock | Texas | 48303 | 48175 | 765 |
1075752 | 1075752 | 2021-02-28 | Lubbock | Texas | 48303 | 48160 | 764 |
1072506 | 1072506 | 2021-02-27 | Lubbock | Texas | 48303 | 48147 | 763 |
1069260 | 1069260 | 2021-02-26 | Lubbock | Texas | 48303 | 48123 | 763 |
1066015 | 1066015 | 2021-02-25 | Lubbock | Texas | 48303 | 48098 | 762 |
1062770 | 1062770 | 2021-02-24 | Lubbock | Texas | 48303 | 48068 | 762 |
1059525 | 1059525 | 2021-02-23 | Lubbock | Texas | 48303 | 48023 | 759 |
1056279 | 1056279 | 2021-02-22 | Lubbock | Texas | 48303 | 48002 | 758 |
1053033 | 1053033 | 2021-02-21 | Lubbock | Texas | 48303 | 47984 | 758 |
1049786 | 1049786 | 2021-02-20 | Lubbock | Texas | 48303 | 47976 | 756 |
1046539 | 1046539 | 2021-02-19 | Lubbock | Texas | 48303 | 47954 | 756 |
1043294 | 1043294 | 2021-02-18 | Lubbock | Texas | 48303 | 47905 | 753 |
1040049 | 1040049 | 2021-02-17 | Lubbock | Texas | 48303 | 47883 | 749 |
1036804 | 1036804 | 2021-02-16 | Lubbock | Texas | 48303 | 47851 | 745 |
1033559 | 1033559 | 2021-02-15 | Lubbock | Texas | 48303 | 47802 | 744 |
1030313 | 1030313 | 2021-02-14 | Lubbock | Texas | 48303 | 47788 | 743 |
1027066 | 1027066 | 2021-02-13 | Lubbock | Texas | 48303 | 47760 | 742 |
1023821 | 1023821 | 2021-02-12 | Lubbock | Texas | 48303 | 47715 | 736 |
1020576 | 1020576 | 2021-02-11 | Lubbock | Texas | 48303 | 47673 | 733 |
1017331 | 1017331 | 2021-02-10 | Lubbock | Texas | 48303 | 47600 | 728 |
1014086 | 1014086 | 2021-02-09 | Lubbock | Texas | 48303 | 47530 | 724 |
1010841 | 1010841 | 2021-02-08 | Lubbock | Texas | 48303 | 47474 | 721 |
1007595 | 1007595 | 2021-02-07 | Lubbock | Texas | 48303 | 47436 | 718 |
1004349 | 1004349 | 2021-02-06 | Lubbock | Texas | 48303 | 47418 | 717 |
1001103 | 1001103 | 2021-02-05 | Lubbock | Texas | 48303 | 47367 | 715 |
997857 | 997857 | 2021-02-04 | Lubbock | Texas | 48303 | 47288 | 708 |
994611 | 994611 | 2021-02-03 | Lubbock | Texas | 48303 | 47195 | 705 |
991365 | 991365 | 2021-02-02 | Lubbock | Texas | 48303 | 47132 | 697 |
988119 | 988119 | 2021-02-01 | Lubbock | Texas | 48303 | 47020 | 693 |
984872 | 984872 | 2021-01-31 | Lubbock | Texas | 48303 | 46942 | 692 |
981625 | 981625 | 2021-01-30 | Lubbock | Texas | 48303 | 46862 | 690 |
978379 | 978379 | 2021-01-29 | Lubbock | Texas | 48303 | 46802 | 687 |
975134 | 975134 | 2021-01-28 | Lubbock | Texas | 48303 | 46705 | 684 |
971889 | 971889 | 2021-01-27 | Lubbock | Texas | 48303 | 46572 | 680 |
968644 | 968644 | 2021-01-26 | Lubbock | Texas | 48303 | 46452 | 675 |
965400 | 965400 | 2021-01-25 | Lubbock | Texas | 48303 | 46329 | 671 |
962155 | 962155 | 2021-01-24 | Lubbock | Texas | 48303 | 46241 | 671 |
958910 | 958910 | 2021-01-23 | Lubbock | Texas | 48303 | 46163 | 665 |
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);