ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Zapata" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420003 | 1420003 | 2021-06-14 | Zapata | Texas | 48505 | 1788 | 36 |
1416758 | 1416758 | 2021-06-13 | Zapata | Texas | 48505 | 1788 | 36 |
1413512 | 1413512 | 2021-06-12 | Zapata | Texas | 48505 | 1786 | 36 |
1410267 | 1410267 | 2021-06-11 | Zapata | Texas | 48505 | 1786 | 36 |
1407022 | 1407022 | 2021-06-10 | Zapata | Texas | 48505 | 1786 | 36 |
1403776 | 1403776 | 2021-06-09 | Zapata | Texas | 48505 | 1786 | 36 |
1400531 | 1400531 | 2021-06-08 | Zapata | Texas | 48505 | 1785 | 36 |
1397286 | 1397286 | 2021-06-07 | Zapata | Texas | 48505 | 1783 | 36 |
1394039 | 1394039 | 2021-06-06 | Zapata | Texas | 48505 | 1783 | 36 |
1390794 | 1390794 | 2021-06-05 | Zapata | Texas | 48505 | 1783 | 36 |
1387549 | 1387549 | 2021-06-04 | Zapata | Texas | 48505 | 1783 | 36 |
1384304 | 1384304 | 2021-06-03 | Zapata | Texas | 48505 | 1783 | 36 |
1381058 | 1381058 | 2021-06-02 | Zapata | Texas | 48505 | 1783 | 36 |
1377813 | 1377813 | 2021-06-01 | Zapata | Texas | 48505 | 1780 | 36 |
1374567 | 1374567 | 2021-05-31 | Zapata | Texas | 48505 | 1780 | 36 |
1371322 | 1371322 | 2021-05-30 | Zapata | Texas | 48505 | 1780 | 36 |
1368076 | 1368076 | 2021-05-29 | Zapata | Texas | 48505 | 1780 | 36 |
1364830 | 1364830 | 2021-05-28 | Zapata | Texas | 48505 | 1776 | 36 |
1361584 | 1361584 | 2021-05-27 | Zapata | Texas | 48505 | 1776 | 36 |
1358338 | 1358338 | 2021-05-26 | Zapata | Texas | 48505 | 1775 | 36 |
1355092 | 1355092 | 2021-05-25 | Zapata | Texas | 48505 | 1775 | 36 |
1351846 | 1351846 | 2021-05-24 | Zapata | Texas | 48505 | 1772 | 36 |
1348600 | 1348600 | 2021-05-23 | Zapata | Texas | 48505 | 1772 | 36 |
1345352 | 1345352 | 2021-05-22 | Zapata | Texas | 48505 | 1771 | 36 |
1342104 | 1342104 | 2021-05-21 | Zapata | Texas | 48505 | 1771 | 36 |
1338856 | 1338856 | 2021-05-20 | Zapata | Texas | 48505 | 1771 | 36 |
1335609 | 1335609 | 2021-05-19 | Zapata | Texas | 48505 | 1770 | 36 |
1332362 | 1332362 | 2021-05-18 | Zapata | Texas | 48505 | 1771 | 36 |
1329115 | 1329115 | 2021-05-17 | Zapata | Texas | 48505 | 1770 | 36 |
1325869 | 1325869 | 2021-05-16 | Zapata | Texas | 48505 | 1770 | 36 |
1322623 | 1322623 | 2021-05-15 | Zapata | Texas | 48505 | 1770 | 36 |
1319377 | 1319377 | 2021-05-14 | Zapata | Texas | 48505 | 1770 | 36 |
1316129 | 1316129 | 2021-05-13 | Zapata | Texas | 48505 | 1769 | 36 |
1312883 | 1312883 | 2021-05-12 | Zapata | Texas | 48505 | 1768 | 36 |
1309636 | 1309636 | 2021-05-11 | Zapata | Texas | 48505 | 1767 | 36 |
1306390 | 1306390 | 2021-05-10 | Zapata | Texas | 48505 | 1766 | 36 |
1303144 | 1303144 | 2021-05-09 | Zapata | Texas | 48505 | 1766 | 36 |
1299897 | 1299897 | 2021-05-08 | Zapata | Texas | 48505 | 1766 | 36 |
1296650 | 1296650 | 2021-05-07 | Zapata | Texas | 48505 | 1766 | 36 |
1293404 | 1293404 | 2021-05-06 | Zapata | Texas | 48505 | 1766 | 36 |
1290158 | 1290158 | 2021-05-05 | Zapata | Texas | 48505 | 1766 | 36 |
1286912 | 1286912 | 2021-05-04 | Zapata | Texas | 48505 | 1766 | 36 |
1283666 | 1283666 | 2021-05-03 | Zapata | Texas | 48505 | 1764 | 36 |
1280419 | 1280419 | 2021-05-02 | Zapata | Texas | 48505 | 1764 | 36 |
1277172 | 1277172 | 2021-05-01 | Zapata | Texas | 48505 | 1764 | 36 |
1273925 | 1273925 | 2021-04-30 | Zapata | Texas | 48505 | 1764 | 36 |
1270678 | 1270678 | 2021-04-29 | Zapata | Texas | 48505 | 1764 | 36 |
1267431 | 1267431 | 2021-04-28 | Zapata | Texas | 48505 | 1764 | 36 |
1264184 | 1264184 | 2021-04-27 | Zapata | Texas | 48505 | 1764 | 36 |
1260937 | 1260937 | 2021-04-26 | Zapata | Texas | 48505 | 1764 | 36 |
1257690 | 1257690 | 2021-04-25 | Zapata | Texas | 48505 | 1764 | 36 |
1254443 | 1254443 | 2021-04-24 | Zapata | Texas | 48505 | 1763 | 36 |
1251196 | 1251196 | 2021-04-23 | Zapata | Texas | 48505 | 1763 | 36 |
1247949 | 1247949 | 2021-04-22 | Zapata | Texas | 48505 | 1763 | 36 |
1244702 | 1244702 | 2021-04-21 | Zapata | Texas | 48505 | 1763 | 36 |
1241455 | 1241455 | 2021-04-20 | Zapata | Texas | 48505 | 1762 | 36 |
1238208 | 1238208 | 2021-04-19 | Zapata | Texas | 48505 | 1763 | 36 |
1234961 | 1234961 | 2021-04-18 | Zapata | Texas | 48505 | 1763 | 36 |
1231713 | 1231713 | 2021-04-17 | Zapata | Texas | 48505 | 1762 | 36 |
1228465 | 1228465 | 2021-04-16 | Zapata | Texas | 48505 | 1762 | 36 |
1225217 | 1225217 | 2021-04-15 | Zapata | Texas | 48505 | 1762 | 34 |
1221970 | 1221970 | 2021-04-14 | Zapata | Texas | 48505 | 1762 | 34 |
1218722 | 1218722 | 2021-04-13 | Zapata | Texas | 48505 | 1762 | 34 |
1215474 | 1215474 | 2021-04-12 | Zapata | Texas | 48505 | 1762 | 33 |
1212227 | 1212227 | 2021-04-11 | Zapata | Texas | 48505 | 1762 | 33 |
1208978 | 1208978 | 2021-04-10 | Zapata | Texas | 48505 | 1761 | 33 |
1205730 | 1205730 | 2021-04-09 | Zapata | Texas | 48505 | 1761 | 33 |
1202482 | 1202482 | 2021-04-08 | Zapata | Texas | 48505 | 1761 | 31 |
1199233 | 1199233 | 2021-04-07 | Zapata | Texas | 48505 | 1761 | 31 |
1195984 | 1195984 | 2021-04-06 | Zapata | Texas | 48505 | 1761 | 31 |
1192736 | 1192736 | 2021-04-05 | Zapata | Texas | 48505 | 1761 | 31 |
1189487 | 1189487 | 2021-04-04 | Zapata | Texas | 48505 | 1761 | 31 |
1186240 | 1186240 | 2021-04-03 | Zapata | Texas | 48505 | 1761 | 31 |
1182993 | 1182993 | 2021-04-02 | Zapata | Texas | 48505 | 1761 | 31 |
1179746 | 1179746 | 2021-04-01 | Zapata | Texas | 48505 | 1760 | 31 |
1176499 | 1176499 | 2021-03-31 | Zapata | Texas | 48505 | 1760 | 31 |
1173252 | 1173252 | 2021-03-30 | Zapata | Texas | 48505 | 1760 | 30 |
1170005 | 1170005 | 2021-03-29 | Zapata | Texas | 48505 | 1759 | 30 |
1166757 | 1166757 | 2021-03-28 | Zapata | Texas | 48505 | 1759 | 30 |
1163509 | 1163509 | 2021-03-27 | Zapata | Texas | 48505 | 1757 | 30 |
1160260 | 1160260 | 2021-03-26 | Zapata | Texas | 48505 | 1757 | 30 |
1157013 | 1157013 | 2021-03-25 | Zapata | Texas | 48505 | 1757 | 30 |
1153766 | 1153766 | 2021-03-24 | Zapata | Texas | 48505 | 1757 | 30 |
1150519 | 1150519 | 2021-03-23 | Zapata | Texas | 48505 | 1757 | 30 |
1147272 | 1147272 | 2021-03-22 | Zapata | Texas | 48505 | 1756 | 30 |
1144025 | 1144025 | 2021-03-21 | Zapata | Texas | 48505 | 1756 | 30 |
1140778 | 1140778 | 2021-03-20 | Zapata | Texas | 48505 | 1754 | 30 |
1137532 | 1137532 | 2021-03-19 | Zapata | Texas | 48505 | 1754 | 30 |
1134286 | 1134286 | 2021-03-18 | Zapata | Texas | 48505 | 1754 | 29 |
1131038 | 1131038 | 2021-03-17 | Zapata | Texas | 48505 | 1754 | 29 |
1127791 | 1127791 | 2021-03-16 | Zapata | Texas | 48505 | 1754 | 29 |
1124545 | 1124545 | 2021-03-15 | Zapata | Texas | 48505 | 1754 | 29 |
1121299 | 1121299 | 2021-03-14 | Zapata | Texas | 48505 | 1754 | 29 |
1118052 | 1118052 | 2021-03-13 | Zapata | Texas | 48505 | 1752 | 29 |
1114805 | 1114805 | 2021-03-12 | Zapata | Texas | 48505 | 1750 | 29 |
1111559 | 1111559 | 2021-03-11 | Zapata | Texas | 48505 | 1749 | 29 |
1108313 | 1108313 | 2021-03-10 | Zapata | Texas | 48505 | 1745 | 29 |
1105067 | 1105067 | 2021-03-09 | Zapata | Texas | 48505 | 1743 | 29 |
1101821 | 1101821 | 2021-03-08 | Zapata | Texas | 48505 | 1742 | 29 |
1098575 | 1098575 | 2021-03-07 | Zapata | Texas | 48505 | 1742 | 29 |
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);