ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48479 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280406 | 1280406 | 2021-05-02 | Webb | Texas | 48479 | 43842 | 834 |
1277159 | 1277159 | 2021-05-01 | Webb | Texas | 48479 | 43842 | 834 |
1273912 | 1273912 | 2021-04-30 | Webb | Texas | 48479 | 43842 | 834 |
1270665 | 1270665 | 2021-04-29 | Webb | Texas | 48479 | 43810 | 834 |
1267418 | 1267418 | 2021-04-28 | Webb | Texas | 48479 | 43810 | 834 |
1264171 | 1264171 | 2021-04-27 | Webb | Texas | 48479 | 43738 | 833 |
1260924 | 1260924 | 2021-04-26 | Webb | Texas | 48479 | 43738 | 833 |
1257677 | 1257677 | 2021-04-25 | Webb | Texas | 48479 | 43672 | 833 |
1254430 | 1254430 | 2021-04-24 | Webb | Texas | 48479 | 43672 | 833 |
1251183 | 1251183 | 2021-04-23 | Webb | Texas | 48479 | 43672 | 833 |
1247936 | 1247936 | 2021-04-22 | Webb | Texas | 48479 | 43614 | 833 |
1244689 | 1244689 | 2021-04-21 | Webb | Texas | 48479 | 43614 | 833 |
1241442 | 1241442 | 2021-04-20 | Webb | Texas | 48479 | 43548 | 831 |
1238195 | 1238195 | 2021-04-19 | Webb | Texas | 48479 | 43548 | 831 |
1234948 | 1234948 | 2021-04-18 | Webb | Texas | 48479 | 43498 | 829 |
1231700 | 1231700 | 2021-04-17 | Webb | Texas | 48479 | 43498 | 829 |
1228452 | 1228452 | 2021-04-16 | Webb | Texas | 48479 | 43498 | 829 |
1225204 | 1225204 | 2021-04-15 | Webb | Texas | 48479 | 43451 | 829 |
1221957 | 1221957 | 2021-04-14 | Webb | Texas | 48479 | 43451 | 829 |
1218709 | 1218709 | 2021-04-13 | Webb | Texas | 48479 | 43407 | 829 |
1215461 | 1215461 | 2021-04-12 | Webb | Texas | 48479 | 43407 | 829 |
1212214 | 1212214 | 2021-04-11 | Webb | Texas | 48479 | 43376 | 827 |
1208965 | 1208965 | 2021-04-10 | Webb | Texas | 48479 | 43376 | 827 |
1205717 | 1205717 | 2021-04-09 | Webb | Texas | 48479 | 43376 | 827 |
1202469 | 1202469 | 2021-04-08 | Webb | Texas | 48479 | 43349 | 826 |
1199220 | 1199220 | 2021-04-07 | Webb | Texas | 48479 | 43349 | 826 |
1195971 | 1195971 | 2021-04-06 | Webb | Texas | 48479 | 43244 | 820 |
1192723 | 1192723 | 2021-04-05 | Webb | Texas | 48479 | 43244 | 820 |
1189474 | 1189474 | 2021-04-04 | Webb | Texas | 48479 | 43244 | 820 |
1186227 | 1186227 | 2021-04-03 | Webb | Texas | 48479 | 43244 | 820 |
1182980 | 1182980 | 2021-04-02 | Webb | Texas | 48479 | 43229 | 820 |
1179733 | 1179733 | 2021-04-01 | Webb | Texas | 48479 | 43229 | 820 |
1176486 | 1176486 | 2021-03-31 | Webb | Texas | 48479 | 43199 | 819 |
1173239 | 1173239 | 2021-03-30 | Webb | Texas | 48479 | 43186 | 818 |
1169992 | 1169992 | 2021-03-29 | Webb | Texas | 48479 | 43164 | 818 |
1166744 | 1166744 | 2021-03-28 | Webb | Texas | 48479 | 43103 | 816 |
1163496 | 1163496 | 2021-03-27 | Webb | Texas | 48479 | 43103 | 816 |
1160247 | 1160247 | 2021-03-26 | Webb | Texas | 48479 | 43103 | 816 |
1157000 | 1157000 | 2021-03-25 | Webb | Texas | 48479 | 43047 | 813 |
1153753 | 1153753 | 2021-03-24 | Webb | Texas | 48479 | 43047 | 813 |
1150506 | 1150506 | 2021-03-23 | Webb | Texas | 48479 | 43047 | 813 |
1147259 | 1147259 | 2021-03-22 | Webb | Texas | 48479 | 43047 | 813 |
1144012 | 1144012 | 2021-03-21 | Webb | Texas | 48479 | 43003 | 811 |
1140765 | 1140765 | 2021-03-20 | Webb | Texas | 48479 | 43003 | 811 |
1137519 | 1137519 | 2021-03-19 | Webb | Texas | 48479 | 43003 | 811 |
1134273 | 1134273 | 2021-03-18 | Webb | Texas | 48479 | 43003 | 811 |
1131025 | 1131025 | 2021-03-17 | Webb | Texas | 48479 | 42932 | 802 |
1127778 | 1127778 | 2021-03-16 | Webb | Texas | 48479 | 42932 | 802 |
1124532 | 1124532 | 2021-03-15 | Webb | Texas | 48479 | 42932 | 802 |
1121286 | 1121286 | 2021-03-14 | Webb | Texas | 48479 | 42932 | 802 |
1118039 | 1118039 | 2021-03-13 | Webb | Texas | 48479 | 42932 | 802 |
1114792 | 1114792 | 2021-03-12 | Webb | Texas | 48479 | 42913 | 802 |
1111546 | 1111546 | 2021-03-11 | Webb | Texas | 48479 | 42913 | 802 |
1108300 | 1108300 | 2021-03-10 | Webb | Texas | 48479 | 42913 | 802 |
1105054 | 1105054 | 2021-03-09 | Webb | Texas | 48479 | 42866 | 800 |
1101808 | 1101808 | 2021-03-08 | Webb | Texas | 48479 | 42866 | 800 |
1098562 | 1098562 | 2021-03-07 | Webb | Texas | 48479 | 42757 | 788 |
1095314 | 1095314 | 2021-03-06 | Webb | Texas | 48479 | 42757 | 788 |
1092068 | 1092068 | 2021-03-05 | Webb | Texas | 48479 | 42757 | 788 |
1088822 | 1088822 | 2021-03-04 | Webb | Texas | 48479 | 42757 | 788 |
1085577 | 1085577 | 2021-03-03 | Webb | Texas | 48479 | 42757 | 788 |
1082331 | 1082331 | 2021-03-02 | Webb | Texas | 48479 | 42757 | 788 |
1079085 | 1079085 | 2021-03-01 | Webb | Texas | 48479 | 42685 | 780 |
1075840 | 1075840 | 2021-02-28 | Webb | Texas | 48479 | 42685 | 780 |
1072594 | 1072594 | 2021-02-27 | Webb | Texas | 48479 | 42685 | 780 |
1069348 | 1069348 | 2021-02-26 | Webb | Texas | 48479 | 42612 | 780 |
1066103 | 1066103 | 2021-02-25 | Webb | Texas | 48479 | 42612 | 780 |
1062858 | 1062858 | 2021-02-24 | Webb | Texas | 48479 | 42606 | 780 |
1059613 | 1059613 | 2021-02-23 | Webb | Texas | 48479 | 42470 | 765 |
1056367 | 1056367 | 2021-02-22 | Webb | Texas | 48479 | 42470 | 765 |
1053121 | 1053121 | 2021-02-21 | Webb | Texas | 48479 | 42470 | 765 |
1049874 | 1049874 | 2021-02-20 | Webb | Texas | 48479 | 42470 | 765 |
1046627 | 1046627 | 2021-02-19 | Webb | Texas | 48479 | 42470 | 765 |
1043382 | 1043382 | 2021-02-18 | Webb | Texas | 48479 | 42419 | 736 |
1040137 | 1040137 | 2021-02-17 | Webb | Texas | 48479 | 42419 | 736 |
1036892 | 1036892 | 2021-02-16 | Webb | Texas | 48479 | 42419 | 736 |
1033647 | 1033647 | 2021-02-15 | Webb | Texas | 48479 | 42270 | 731 |
1030401 | 1030401 | 2021-02-14 | Webb | Texas | 48479 | 42270 | 731 |
1027154 | 1027154 | 2021-02-13 | Webb | Texas | 48479 | 42270 | 731 |
1023909 | 1023909 | 2021-02-12 | Webb | Texas | 48479 | 42257 | 717 |
1020664 | 1020664 | 2021-02-11 | Webb | Texas | 48479 | 41703 | 688 |
1017419 | 1017419 | 2021-02-10 | Webb | Texas | 48479 | 41703 | 688 |
1014174 | 1014174 | 2021-02-09 | Webb | Texas | 48479 | 41703 | 688 |
1010929 | 1010929 | 2021-02-08 | Webb | Texas | 48479 | 41421 | 682 |
1007683 | 1007683 | 2021-02-07 | Webb | Texas | 48479 | 41421 | 682 |
1004437 | 1004437 | 2021-02-06 | Webb | Texas | 48479 | 41361 | 657 |
1001191 | 1001191 | 2021-02-05 | Webb | Texas | 48479 | 40818 | 657 |
997945 | 997945 | 2021-02-04 | Webb | Texas | 48479 | 40818 | 657 |
994699 | 994699 | 2021-02-03 | Webb | Texas | 48479 | 40818 | 657 |
991453 | 991453 | 2021-02-02 | Webb | Texas | 48479 | 40162 | 632 |
988207 | 988207 | 2021-02-01 | Webb | Texas | 48479 | 40162 | 632 |
984960 | 984960 | 2021-01-31 | Webb | Texas | 48479 | 40054 | 631 |
981713 | 981713 | 2021-01-30 | Webb | Texas | 48479 | 40054 | 631 |
978467 | 978467 | 2021-01-29 | Webb | Texas | 48479 | 39992 | 628 |
975222 | 975222 | 2021-01-28 | Webb | Texas | 48479 | 38923 | 609 |
971977 | 971977 | 2021-01-27 | Webb | Texas | 48479 | 38923 | 609 |
968732 | 968732 | 2021-01-26 | Webb | Texas | 48479 | 38452 | 609 |
965488 | 965488 | 2021-01-25 | Webb | Texas | 48479 | 37761 | 592 |
962243 | 962243 | 2021-01-24 | Webb | Texas | 48479 | 37761 | 592 |
958998 | 958998 | 2021-01-23 | Webb | Texas | 48479 | 37761 | 592 |
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);