ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
754 rows where county = "Hartley" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419853 | 1419853 | 2021-06-14 | Hartley | Texas | 48205 | 661 | 2 |
1416608 | 1416608 | 2021-06-13 | Hartley | Texas | 48205 | 661 | 2 |
1413362 | 1413362 | 2021-06-12 | Hartley | Texas | 48205 | 661 | 2 |
1410117 | 1410117 | 2021-06-11 | Hartley | Texas | 48205 | 660 | 2 |
1406872 | 1406872 | 2021-06-10 | Hartley | Texas | 48205 | 659 | 2 |
1403626 | 1403626 | 2021-06-09 | Hartley | Texas | 48205 | 659 | 2 |
1400381 | 1400381 | 2021-06-08 | Hartley | Texas | 48205 | 658 | 2 |
1397136 | 1397136 | 2021-06-07 | Hartley | Texas | 48205 | 659 | 2 |
1393889 | 1393889 | 2021-06-06 | Hartley | Texas | 48205 | 659 | 2 |
1390644 | 1390644 | 2021-06-05 | Hartley | Texas | 48205 | 659 | 2 |
1387399 | 1387399 | 2021-06-04 | Hartley | Texas | 48205 | 659 | 2 |
1384154 | 1384154 | 2021-06-03 | Hartley | Texas | 48205 | 654 | 2 |
1380908 | 1380908 | 2021-06-02 | Hartley | Texas | 48205 | 654 | 2 |
1377663 | 1377663 | 2021-06-01 | Hartley | Texas | 48205 | 650 | 2 |
1374417 | 1374417 | 2021-05-31 | Hartley | Texas | 48205 | 652 | 2 |
1371172 | 1371172 | 2021-05-30 | Hartley | Texas | 48205 | 652 | 2 |
1367926 | 1367926 | 2021-05-29 | Hartley | Texas | 48205 | 652 | 2 |
1364680 | 1364680 | 2021-05-28 | Hartley | Texas | 48205 | 650 | 2 |
1361434 | 1361434 | 2021-05-27 | Hartley | Texas | 48205 | 652 | 2 |
1358188 | 1358188 | 2021-05-26 | Hartley | Texas | 48205 | 651 | 2 |
1354942 | 1354942 | 2021-05-25 | Hartley | Texas | 48205 | 649 | 2 |
1351696 | 1351696 | 2021-05-24 | Hartley | Texas | 48205 | 653 | 2 |
1348450 | 1348450 | 2021-05-23 | Hartley | Texas | 48205 | 653 | 2 |
1345202 | 1345202 | 2021-05-22 | Hartley | Texas | 48205 | 653 | 2 |
1341954 | 1341954 | 2021-05-21 | Hartley | Texas | 48205 | 656 | 2 |
1338706 | 1338706 | 2021-05-20 | Hartley | Texas | 48205 | 654 | 2 |
1335459 | 1335459 | 2021-05-19 | Hartley | Texas | 48205 | 654 | 2 |
1332212 | 1332212 | 2021-05-18 | Hartley | Texas | 48205 | 653 | 2 |
1328965 | 1328965 | 2021-05-17 | Hartley | Texas | 48205 | 645 | 2 |
1325719 | 1325719 | 2021-05-16 | Hartley | Texas | 48205 | 645 | 2 |
1322473 | 1322473 | 2021-05-15 | Hartley | Texas | 48205 | 645 | 2 |
1319227 | 1319227 | 2021-05-14 | Hartley | Texas | 48205 | 640 | 2 |
1315979 | 1315979 | 2021-05-13 | Hartley | Texas | 48205 | 640 | 2 |
1312733 | 1312733 | 2021-05-12 | Hartley | Texas | 48205 | 640 | 2 |
1309486 | 1309486 | 2021-05-11 | Hartley | Texas | 48205 | 641 | 2 |
1306240 | 1306240 | 2021-05-10 | Hartley | Texas | 48205 | 635 | 2 |
1302994 | 1302994 | 2021-05-09 | Hartley | Texas | 48205 | 635 | 2 |
1299747 | 1299747 | 2021-05-08 | Hartley | Texas | 48205 | 635 | 2 |
1296500 | 1296500 | 2021-05-07 | Hartley | Texas | 48205 | 633 | 2 |
1293254 | 1293254 | 2021-05-06 | Hartley | Texas | 48205 | 632 | 2 |
1290008 | 1290008 | 2021-05-05 | Hartley | Texas | 48205 | 632 | 2 |
1286762 | 1286762 | 2021-05-04 | Hartley | Texas | 48205 | 632 | 2 |
1283516 | 1283516 | 2021-05-03 | Hartley | Texas | 48205 | 632 | 2 |
1280269 | 1280269 | 2021-05-02 | Hartley | Texas | 48205 | 632 | 2 |
1277022 | 1277022 | 2021-05-01 | Hartley | Texas | 48205 | 632 | 2 |
1273775 | 1273775 | 2021-04-30 | Hartley | Texas | 48205 | 632 | 2 |
1270528 | 1270528 | 2021-04-29 | Hartley | Texas | 48205 | 632 | 2 |
1267281 | 1267281 | 2021-04-28 | Hartley | Texas | 48205 | 631 | 2 |
1264034 | 1264034 | 2021-04-27 | Hartley | Texas | 48205 | 631 | 2 |
1260787 | 1260787 | 2021-04-26 | Hartley | Texas | 48205 | 630 | 2 |
1257540 | 1257540 | 2021-04-25 | Hartley | Texas | 48205 | 630 | 2 |
1254293 | 1254293 | 2021-04-24 | Hartley | Texas | 48205 | 630 | 2 |
1251046 | 1251046 | 2021-04-23 | Hartley | Texas | 48205 | 631 | 2 |
1247799 | 1247799 | 2021-04-22 | Hartley | Texas | 48205 | 631 | 2 |
1244552 | 1244552 | 2021-04-21 | Hartley | Texas | 48205 | 627 | 2 |
1241305 | 1241305 | 2021-04-20 | Hartley | Texas | 48205 | 624 | 2 |
1238058 | 1238058 | 2021-04-19 | Hartley | Texas | 48205 | 624 | 2 |
1234811 | 1234811 | 2021-04-18 | Hartley | Texas | 48205 | 624 | 2 |
1231563 | 1231563 | 2021-04-17 | Hartley | Texas | 48205 | 624 | 2 |
1228315 | 1228315 | 2021-04-16 | Hartley | Texas | 48205 | 624 | 2 |
1225067 | 1225067 | 2021-04-15 | Hartley | Texas | 48205 | 624 | 2 |
1221820 | 1221820 | 2021-04-14 | Hartley | Texas | 48205 | 624 | 2 |
1218572 | 1218572 | 2021-04-13 | Hartley | Texas | 48205 | 624 | 2 |
1215324 | 1215324 | 2021-04-12 | Hartley | Texas | 48205 | 621 | 2 |
1212077 | 1212077 | 2021-04-11 | Hartley | Texas | 48205 | 621 | 2 |
1208828 | 1208828 | 2021-04-10 | Hartley | Texas | 48205 | 621 | 2 |
1205580 | 1205580 | 2021-04-09 | Hartley | Texas | 48205 | 620 | 2 |
1202332 | 1202332 | 2021-04-08 | Hartley | Texas | 48205 | 620 | 2 |
1199083 | 1199083 | 2021-04-07 | Hartley | Texas | 48205 | 618 | 2 |
1195834 | 1195834 | 2021-04-06 | Hartley | Texas | 48205 | 618 | 2 |
1192586 | 1192586 | 2021-04-05 | Hartley | Texas | 48205 | 619 | 2 |
1189337 | 1189337 | 2021-04-04 | Hartley | Texas | 48205 | 619 | 2 |
1186090 | 1186090 | 2021-04-03 | Hartley | Texas | 48205 | 619 | 2 |
1182843 | 1182843 | 2021-04-02 | Hartley | Texas | 48205 | 619 | 2 |
1179596 | 1179596 | 2021-04-01 | Hartley | Texas | 48205 | 618 | 2 |
1176349 | 1176349 | 2021-03-31 | Hartley | Texas | 48205 | 617 | 2 |
1173102 | 1173102 | 2021-03-30 | Hartley | Texas | 48205 | 617 | 2 |
1169855 | 1169855 | 2021-03-29 | Hartley | Texas | 48205 | 614 | 2 |
1166607 | 1166607 | 2021-03-28 | Hartley | Texas | 48205 | 614 | 2 |
1163359 | 1163359 | 2021-03-27 | Hartley | Texas | 48205 | 614 | 2 |
1160110 | 1160110 | 2021-03-26 | Hartley | Texas | 48205 | 614 | 2 |
1156863 | 1156863 | 2021-03-25 | Hartley | Texas | 48205 | 614 | 2 |
1153616 | 1153616 | 2021-03-24 | Hartley | Texas | 48205 | 612 | 2 |
1150369 | 1150369 | 2021-03-23 | Hartley | Texas | 48205 | 611 | 2 |
1147122 | 1147122 | 2021-03-22 | Hartley | Texas | 48205 | 605 | 2 |
1143875 | 1143875 | 2021-03-21 | Hartley | Texas | 48205 | 605 | 2 |
1140628 | 1140628 | 2021-03-20 | Hartley | Texas | 48205 | 605 | 2 |
1137382 | 1137382 | 2021-03-19 | Hartley | Texas | 48205 | 606 | 2 |
1134136 | 1134136 | 2021-03-18 | Hartley | Texas | 48205 | 606 | 2 |
1130888 | 1130888 | 2021-03-17 | Hartley | Texas | 48205 | 607 | 2 |
1127641 | 1127641 | 2021-03-16 | Hartley | Texas | 48205 | 607 | 2 |
1124395 | 1124395 | 2021-03-15 | Hartley | Texas | 48205 | 603 | 2 |
1121149 | 1121149 | 2021-03-14 | Hartley | Texas | 48205 | 603 | 2 |
1117902 | 1117902 | 2021-03-13 | Hartley | Texas | 48205 | 603 | 2 |
1114655 | 1114655 | 2021-03-12 | Hartley | Texas | 48205 | 604 | 2 |
1111409 | 1111409 | 2021-03-11 | Hartley | Texas | 48205 | 602 | 2 |
1108163 | 1108163 | 2021-03-10 | Hartley | Texas | 48205 | 600 | 2 |
1104917 | 1104917 | 2021-03-09 | Hartley | Texas | 48205 | 603 | 2 |
1101671 | 1101671 | 2021-03-08 | Hartley | Texas | 48205 | 604 | 2 |
1098425 | 1098425 | 2021-03-07 | Hartley | Texas | 48205 | 604 | 2 |
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);