ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 48437 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419969 | 1419969 | 2021-06-14 | Swisher | Texas | 48437 | 896 | 18 |
1416724 | 1416724 | 2021-06-13 | Swisher | Texas | 48437 | 896 | 18 |
1413478 | 1413478 | 2021-06-12 | Swisher | Texas | 48437 | 896 | 18 |
1410233 | 1410233 | 2021-06-11 | Swisher | Texas | 48437 | 896 | 18 |
1406988 | 1406988 | 2021-06-10 | Swisher | Texas | 48437 | 896 | 18 |
1403742 | 1403742 | 2021-06-09 | Swisher | Texas | 48437 | 893 | 18 |
1400497 | 1400497 | 2021-06-08 | Swisher | Texas | 48437 | 892 | 18 |
1397252 | 1397252 | 2021-06-07 | Swisher | Texas | 48437 | 893 | 18 |
1394005 | 1394005 | 2021-06-06 | Swisher | Texas | 48437 | 893 | 18 |
1390760 | 1390760 | 2021-06-05 | Swisher | Texas | 48437 | 893 | 18 |
1387515 | 1387515 | 2021-06-04 | Swisher | Texas | 48437 | 893 | 18 |
1384270 | 1384270 | 2021-06-03 | Swisher | Texas | 48437 | 895 | 18 |
1381024 | 1381024 | 2021-06-02 | Swisher | Texas | 48437 | 883 | 18 |
1377779 | 1377779 | 2021-06-01 | Swisher | Texas | 48437 | 885 | 18 |
1374533 | 1374533 | 2021-05-31 | Swisher | Texas | 48437 | 885 | 18 |
1371288 | 1371288 | 2021-05-30 | Swisher | Texas | 48437 | 885 | 18 |
1368042 | 1368042 | 2021-05-29 | Swisher | Texas | 48437 | 885 | 18 |
1364796 | 1364796 | 2021-05-28 | Swisher | Texas | 48437 | 885 | 18 |
1361550 | 1361550 | 2021-05-27 | Swisher | Texas | 48437 | 886 | 18 |
1358304 | 1358304 | 2021-05-26 | Swisher | Texas | 48437 | 885 | 18 |
1355058 | 1355058 | 2021-05-25 | Swisher | Texas | 48437 | 884 | 17 |
1351812 | 1351812 | 2021-05-24 | Swisher | Texas | 48437 | 886 | 17 |
1348566 | 1348566 | 2021-05-23 | Swisher | Texas | 48437 | 886 | 17 |
1345318 | 1345318 | 2021-05-22 | Swisher | Texas | 48437 | 886 | 17 |
1342070 | 1342070 | 2021-05-21 | Swisher | Texas | 48437 | 882 | 17 |
1338822 | 1338822 | 2021-05-20 | Swisher | Texas | 48437 | 866 | 17 |
1335575 | 1335575 | 2021-05-19 | Swisher | Texas | 48437 | 864 | 17 |
1332328 | 1332328 | 2021-05-18 | Swisher | Texas | 48437 | 863 | 17 |
1329081 | 1329081 | 2021-05-17 | Swisher | Texas | 48437 | 855 | 17 |
1325835 | 1325835 | 2021-05-16 | Swisher | Texas | 48437 | 855 | 17 |
1322589 | 1322589 | 2021-05-15 | Swisher | Texas | 48437 | 855 | 17 |
1319343 | 1319343 | 2021-05-14 | Swisher | Texas | 48437 | 841 | 17 |
1316095 | 1316095 | 2021-05-13 | Swisher | Texas | 48437 | 841 | 17 |
1312849 | 1312849 | 2021-05-12 | Swisher | Texas | 48437 | 839 | 17 |
1309602 | 1309602 | 2021-05-11 | Swisher | Texas | 48437 | 839 | 17 |
1306356 | 1306356 | 2021-05-10 | Swisher | Texas | 48437 | 834 | 17 |
1303110 | 1303110 | 2021-05-09 | Swisher | Texas | 48437 | 834 | 17 |
1299863 | 1299863 | 2021-05-08 | Swisher | Texas | 48437 | 834 | 17 |
1296616 | 1296616 | 2021-05-07 | Swisher | Texas | 48437 | 834 | 17 |
1293370 | 1293370 | 2021-05-06 | Swisher | Texas | 48437 | 829 | 17 |
1290124 | 1290124 | 2021-05-05 | Swisher | Texas | 48437 | 829 | 17 |
1286878 | 1286878 | 2021-05-04 | Swisher | Texas | 48437 | 828 | 17 |
1283632 | 1283632 | 2021-05-03 | Swisher | Texas | 48437 | 826 | 17 |
1280385 | 1280385 | 2021-05-02 | Swisher | Texas | 48437 | 826 | 17 |
1277138 | 1277138 | 2021-05-01 | Swisher | Texas | 48437 | 826 | 17 |
1273891 | 1273891 | 2021-04-30 | Swisher | Texas | 48437 | 825 | 17 |
1270644 | 1270644 | 2021-04-29 | Swisher | Texas | 48437 | 824 | 17 |
1267397 | 1267397 | 2021-04-28 | Swisher | Texas | 48437 | 823 | 17 |
1264150 | 1264150 | 2021-04-27 | Swisher | Texas | 48437 | 821 | 17 |
1260903 | 1260903 | 2021-04-26 | Swisher | Texas | 48437 | 818 | 17 |
1257656 | 1257656 | 2021-04-25 | Swisher | Texas | 48437 | 818 | 17 |
1254409 | 1254409 | 2021-04-24 | Swisher | Texas | 48437 | 818 | 17 |
1251162 | 1251162 | 2021-04-23 | Swisher | Texas | 48437 | 817 | 17 |
1247915 | 1247915 | 2021-04-22 | Swisher | Texas | 48437 | 816 | 17 |
1244668 | 1244668 | 2021-04-21 | Swisher | Texas | 48437 | 815 | 17 |
1241421 | 1241421 | 2021-04-20 | Swisher | Texas | 48437 | 814 | 17 |
1238174 | 1238174 | 2021-04-19 | Swisher | Texas | 48437 | 817 | 17 |
1234927 | 1234927 | 2021-04-18 | Swisher | Texas | 48437 | 817 | 17 |
1231679 | 1231679 | 2021-04-17 | Swisher | Texas | 48437 | 817 | 17 |
1228431 | 1228431 | 2021-04-16 | Swisher | Texas | 48437 | 815 | 17 |
1225183 | 1225183 | 2021-04-15 | Swisher | Texas | 48437 | 814 | 17 |
1221936 | 1221936 | 2021-04-14 | Swisher | Texas | 48437 | 813 | 17 |
1218688 | 1218688 | 2021-04-13 | Swisher | Texas | 48437 | 813 | 17 |
1215440 | 1215440 | 2021-04-12 | Swisher | Texas | 48437 | 809 | 17 |
1212193 | 1212193 | 2021-04-11 | Swisher | Texas | 48437 | 809 | 17 |
1208944 | 1208944 | 2021-04-10 | Swisher | Texas | 48437 | 809 | 17 |
1205696 | 1205696 | 2021-04-09 | Swisher | Texas | 48437 | 804 | 17 |
1202448 | 1202448 | 2021-04-08 | Swisher | Texas | 48437 | 801 | 17 |
1199199 | 1199199 | 2021-04-07 | Swisher | Texas | 48437 | 796 | 17 |
1195950 | 1195950 | 2021-04-06 | Swisher | Texas | 48437 | 794 | 17 |
1192702 | 1192702 | 2021-04-05 | Swisher | Texas | 48437 | 793 | 17 |
1189453 | 1189453 | 2021-04-04 | Swisher | Texas | 48437 | 793 | 17 |
1186206 | 1186206 | 2021-04-03 | Swisher | Texas | 48437 | 793 | 17 |
1182959 | 1182959 | 2021-04-02 | Swisher | Texas | 48437 | 793 | 17 |
1179712 | 1179712 | 2021-04-01 | Swisher | Texas | 48437 | 792 | 17 |
1176465 | 1176465 | 2021-03-31 | Swisher | Texas | 48437 | 789 | 17 |
1173218 | 1173218 | 2021-03-30 | Swisher | Texas | 48437 | 786 | 17 |
1169971 | 1169971 | 2021-03-29 | Swisher | Texas | 48437 | 786 | 17 |
1166723 | 1166723 | 2021-03-28 | Swisher | Texas | 48437 | 786 | 17 |
1163475 | 1163475 | 2021-03-27 | Swisher | Texas | 48437 | 786 | 17 |
1160226 | 1160226 | 2021-03-26 | Swisher | Texas | 48437 | 784 | 17 |
1156979 | 1156979 | 2021-03-25 | Swisher | Texas | 48437 | 783 | 17 |
1153732 | 1153732 | 2021-03-24 | Swisher | Texas | 48437 | 783 | 17 |
1150485 | 1150485 | 2021-03-23 | Swisher | Texas | 48437 | 779 | 17 |
1147238 | 1147238 | 2021-03-22 | Swisher | Texas | 48437 | 767 | 17 |
1143991 | 1143991 | 2021-03-21 | Swisher | Texas | 48437 | 767 | 17 |
1140744 | 1140744 | 2021-03-20 | Swisher | Texas | 48437 | 767 | 17 |
1137498 | 1137498 | 2021-03-19 | Swisher | Texas | 48437 | 767 | 17 |
1134252 | 1134252 | 2021-03-18 | Swisher | Texas | 48437 | 764 | 17 |
1131004 | 1131004 | 2021-03-17 | Swisher | Texas | 48437 | 764 | 17 |
1127757 | 1127757 | 2021-03-16 | Swisher | Texas | 48437 | 764 | 17 |
1124511 | 1124511 | 2021-03-15 | Swisher | Texas | 48437 | 763 | 17 |
1121265 | 1121265 | 2021-03-14 | Swisher | Texas | 48437 | 763 | 17 |
1118018 | 1118018 | 2021-03-13 | Swisher | Texas | 48437 | 763 | 17 |
1114771 | 1114771 | 2021-03-12 | Swisher | Texas | 48437 | 762 | 17 |
1111525 | 1111525 | 2021-03-11 | Swisher | Texas | 48437 | 761 | 17 |
1108279 | 1108279 | 2021-03-10 | Swisher | Texas | 48437 | 760 | 17 |
1105033 | 1105033 | 2021-03-09 | Swisher | Texas | 48437 | 758 | 17 |
1101787 | 1101787 | 2021-03-08 | Swisher | Texas | 48437 | 757 | 17 |
1098541 | 1098541 | 2021-03-07 | Swisher | Texas | 48437 | 757 | 17 |
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);