ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Colorado" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419795 | 1419795 | 2021-06-14 | Colorado | Texas | 48089 | 1747 | 32 |
1416550 | 1416550 | 2021-06-13 | Colorado | Texas | 48089 | 1747 | 32 |
1413304 | 1413304 | 2021-06-12 | Colorado | Texas | 48089 | 1747 | 32 |
1410059 | 1410059 | 2021-06-11 | Colorado | Texas | 48089 | 1747 | 32 |
1406814 | 1406814 | 2021-06-10 | Colorado | Texas | 48089 | 1745 | 32 |
1403568 | 1403568 | 2021-06-09 | Colorado | Texas | 48089 | 1744 | 32 |
1400323 | 1400323 | 2021-06-08 | Colorado | Texas | 48089 | 1743 | 32 |
1397078 | 1397078 | 2021-06-07 | Colorado | Texas | 48089 | 1743 | 32 |
1393831 | 1393831 | 2021-06-06 | Colorado | Texas | 48089 | 1741 | 32 |
1390586 | 1390586 | 2021-06-05 | Colorado | Texas | 48089 | 1740 | 32 |
1387341 | 1387341 | 2021-06-04 | Colorado | Texas | 48089 | 1743 | 32 |
1384096 | 1384096 | 2021-06-03 | Colorado | Texas | 48089 | 1743 | 32 |
1380850 | 1380850 | 2021-06-02 | Colorado | Texas | 48089 | 1743 | 32 |
1377605 | 1377605 | 2021-06-01 | Colorado | Texas | 48089 | 1744 | 32 |
1374359 | 1374359 | 2021-05-31 | Colorado | Texas | 48089 | 1744 | 32 |
1371114 | 1371114 | 2021-05-30 | Colorado | Texas | 48089 | 1744 | 32 |
1367868 | 1367868 | 2021-05-29 | Colorado | Texas | 48089 | 1744 | 32 |
1364622 | 1364622 | 2021-05-28 | Colorado | Texas | 48089 | 1742 | 32 |
1361376 | 1361376 | 2021-05-27 | Colorado | Texas | 48089 | 1741 | 32 |
1358130 | 1358130 | 2021-05-26 | Colorado | Texas | 48089 | 1739 | 32 |
1354884 | 1354884 | 2021-05-25 | Colorado | Texas | 48089 | 1739 | 32 |
1351638 | 1351638 | 2021-05-24 | Colorado | Texas | 48089 | 1739 | 32 |
1348392 | 1348392 | 2021-05-23 | Colorado | Texas | 48089 | 1737 | 32 |
1345144 | 1345144 | 2021-05-22 | Colorado | Texas | 48089 | 1737 | 32 |
1341896 | 1341896 | 2021-05-21 | Colorado | Texas | 48089 | 1736 | 32 |
1338648 | 1338648 | 2021-05-20 | Colorado | Texas | 48089 | 1736 | 32 |
1335401 | 1335401 | 2021-05-19 | Colorado | Texas | 48089 | 1736 | 32 |
1332154 | 1332154 | 2021-05-18 | Colorado | Texas | 48089 | 1734 | 32 |
1328907 | 1328907 | 2021-05-17 | Colorado | Texas | 48089 | 1736 | 32 |
1325661 | 1325661 | 2021-05-16 | Colorado | Texas | 48089 | 1736 | 32 |
1322415 | 1322415 | 2021-05-15 | Colorado | Texas | 48089 | 1736 | 32 |
1319169 | 1319169 | 2021-05-14 | Colorado | Texas | 48089 | 1735 | 32 |
1315921 | 1315921 | 2021-05-13 | Colorado | Texas | 48089 | 1731 | 31 |
1312675 | 1312675 | 2021-05-12 | Colorado | Texas | 48089 | 1727 | 31 |
1309428 | 1309428 | 2021-05-11 | Colorado | Texas | 48089 | 1727 | 30 |
1306182 | 1306182 | 2021-05-10 | Colorado | Texas | 48089 | 1727 | 30 |
1302936 | 1302936 | 2021-05-09 | Colorado | Texas | 48089 | 1727 | 30 |
1299689 | 1299689 | 2021-05-08 | Colorado | Texas | 48089 | 1724 | 30 |
1296442 | 1296442 | 2021-05-07 | Colorado | Texas | 48089 | 1722 | 30 |
1293196 | 1293196 | 2021-05-06 | Colorado | Texas | 48089 | 1720 | 30 |
1289950 | 1289950 | 2021-05-05 | Colorado | Texas | 48089 | 1720 | 30 |
1286704 | 1286704 | 2021-05-04 | Colorado | Texas | 48089 | 1720 | 30 |
1283458 | 1283458 | 2021-05-03 | Colorado | Texas | 48089 | 1718 | 30 |
1280211 | 1280211 | 2021-05-02 | Colorado | Texas | 48089 | 1715 | 30 |
1276964 | 1276964 | 2021-05-01 | Colorado | Texas | 48089 | 1715 | 30 |
1273717 | 1273717 | 2021-04-30 | Colorado | Texas | 48089 | 1715 | 30 |
1270470 | 1270470 | 2021-04-29 | Colorado | Texas | 48089 | 1715 | 30 |
1267223 | 1267223 | 2021-04-28 | Colorado | Texas | 48089 | 1714 | 30 |
1263976 | 1263976 | 2021-04-27 | Colorado | Texas | 48089 | 1712 | 30 |
1260729 | 1260729 | 2021-04-26 | Colorado | Texas | 48089 | 1711 | 30 |
1257482 | 1257482 | 2021-04-25 | Colorado | Texas | 48089 | 1711 | 30 |
1254235 | 1254235 | 2021-04-24 | Colorado | Texas | 48089 | 1709 | 30 |
1250988 | 1250988 | 2021-04-23 | Colorado | Texas | 48089 | 1708 | 30 |
1247741 | 1247741 | 2021-04-22 | Colorado | Texas | 48089 | 1704 | 30 |
1244494 | 1244494 | 2021-04-21 | Colorado | Texas | 48089 | 1703 | 30 |
1241247 | 1241247 | 2021-04-20 | Colorado | Texas | 48089 | 1699 | 30 |
1238000 | 1238000 | 2021-04-19 | Colorado | Texas | 48089 | 1693 | 30 |
1234753 | 1234753 | 2021-04-18 | Colorado | Texas | 48089 | 1693 | 30 |
1231505 | 1231505 | 2021-04-17 | Colorado | Texas | 48089 | 1693 | 30 |
1228257 | 1228257 | 2021-04-16 | Colorado | Texas | 48089 | 1690 | 30 |
1225009 | 1225009 | 2021-04-15 | Colorado | Texas | 48089 | 1690 | 30 |
1221762 | 1221762 | 2021-04-14 | Colorado | Texas | 48089 | 1689 | 29 |
1218514 | 1218514 | 2021-04-13 | Colorado | Texas | 48089 | 1686 | 28 |
1215266 | 1215266 | 2021-04-12 | Colorado | Texas | 48089 | 1680 | 28 |
1212019 | 1212019 | 2021-04-11 | Colorado | Texas | 48089 | 1677 | 28 |
1208770 | 1208770 | 2021-04-10 | Colorado | Texas | 48089 | 1676 | 28 |
1205522 | 1205522 | 2021-04-09 | Colorado | Texas | 48089 | 1673 | 28 |
1202274 | 1202274 | 2021-04-08 | Colorado | Texas | 48089 | 1686 | 27 |
1199025 | 1199025 | 2021-04-07 | Colorado | Texas | 48089 | 1666 | 27 |
1195776 | 1195776 | 2021-04-06 | Colorado | Texas | 48089 | 1663 | 27 |
1192528 | 1192528 | 2021-04-05 | Colorado | Texas | 48089 | 1661 | 27 |
1189279 | 1189279 | 2021-04-04 | Colorado | Texas | 48089 | 1659 | 27 |
1186032 | 1186032 | 2021-04-03 | Colorado | Texas | 48089 | 1654 | 27 |
1182785 | 1182785 | 2021-04-02 | Colorado | Texas | 48089 | 1644 | 27 |
1179538 | 1179538 | 2021-04-01 | Colorado | Texas | 48089 | 1644 | 27 |
1176291 | 1176291 | 2021-03-31 | Colorado | Texas | 48089 | 1642 | 27 |
1173044 | 1173044 | 2021-03-30 | Colorado | Texas | 48089 | 1641 | 26 |
1169797 | 1169797 | 2021-03-29 | Colorado | Texas | 48089 | 1640 | 26 |
1166549 | 1166549 | 2021-03-28 | Colorado | Texas | 48089 | 1636 | 26 |
1163301 | 1163301 | 2021-03-27 | Colorado | Texas | 48089 | 1629 | 26 |
1160052 | 1160052 | 2021-03-26 | Colorado | Texas | 48089 | 1628 | 25 |
1156805 | 1156805 | 2021-03-25 | Colorado | Texas | 48089 | 1626 | 25 |
1153558 | 1153558 | 2021-03-24 | Colorado | Texas | 48089 | 1624 | 25 |
1150311 | 1150311 | 2021-03-23 | Colorado | Texas | 48089 | 1623 | 25 |
1147064 | 1147064 | 2021-03-22 | Colorado | Texas | 48089 | 1623 | 25 |
1143817 | 1143817 | 2021-03-21 | Colorado | Texas | 48089 | 1620 | 25 |
1140570 | 1140570 | 2021-03-20 | Colorado | Texas | 48089 | 1610 | 25 |
1137324 | 1137324 | 2021-03-19 | Colorado | Texas | 48089 | 1608 | 25 |
1134078 | 1134078 | 2021-03-18 | Colorado | Texas | 48089 | 1608 | 25 |
1130830 | 1130830 | 2021-03-17 | Colorado | Texas | 48089 | 1607 | 25 |
1127583 | 1127583 | 2021-03-16 | Colorado | Texas | 48089 | 1603 | 25 |
1124337 | 1124337 | 2021-03-15 | Colorado | Texas | 48089 | 1600 | 25 |
1121091 | 1121091 | 2021-03-14 | Colorado | Texas | 48089 | 1598 | 25 |
1117844 | 1117844 | 2021-03-13 | Colorado | Texas | 48089 | 1594 | 25 |
1114597 | 1114597 | 2021-03-12 | Colorado | Texas | 48089 | 1591 | 25 |
1111351 | 1111351 | 2021-03-11 | Colorado | Texas | 48089 | 1587 | 25 |
1108105 | 1108105 | 2021-03-10 | Colorado | Texas | 48089 | 1587 | 25 |
1104859 | 1104859 | 2021-03-09 | Colorado | Texas | 48089 | 1586 | 25 |
1101613 | 1101613 | 2021-03-08 | Colorado | Texas | 48089 | 1578 | 25 |
1098367 | 1098367 | 2021-03-07 | Colorado | Texas | 48089 | 1578 | 25 |
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);