ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
750 rows where fips = 48353 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419927 | 1419927 | 2021-06-14 | Nolan | Texas | 48353 | 1547 | 52 |
1416682 | 1416682 | 2021-06-13 | Nolan | Texas | 48353 | 1547 | 52 |
1413436 | 1413436 | 2021-06-12 | Nolan | Texas | 48353 | 1547 | 52 |
1410191 | 1410191 | 2021-06-11 | Nolan | Texas | 48353 | 1547 | 52 |
1406946 | 1406946 | 2021-06-10 | Nolan | Texas | 48353 | 1547 | 51 |
1403700 | 1403700 | 2021-06-09 | Nolan | Texas | 48353 | 1547 | 51 |
1400455 | 1400455 | 2021-06-08 | Nolan | Texas | 48353 | 1546 | 51 |
1397210 | 1397210 | 2021-06-07 | Nolan | Texas | 48353 | 1546 | 51 |
1393963 | 1393963 | 2021-06-06 | Nolan | Texas | 48353 | 1546 | 51 |
1390718 | 1390718 | 2021-06-05 | Nolan | Texas | 48353 | 1546 | 51 |
1387473 | 1387473 | 2021-06-04 | Nolan | Texas | 48353 | 1546 | 51 |
1384228 | 1384228 | 2021-06-03 | Nolan | Texas | 48353 | 1545 | 51 |
1380982 | 1380982 | 2021-06-02 | Nolan | Texas | 48353 | 1545 | 51 |
1377737 | 1377737 | 2021-06-01 | Nolan | Texas | 48353 | 1545 | 51 |
1374491 | 1374491 | 2021-05-31 | Nolan | Texas | 48353 | 1545 | 51 |
1371246 | 1371246 | 2021-05-30 | Nolan | Texas | 48353 | 1545 | 51 |
1368000 | 1368000 | 2021-05-29 | Nolan | Texas | 48353 | 1545 | 51 |
1364754 | 1364754 | 2021-05-28 | Nolan | Texas | 48353 | 1545 | 51 |
1361508 | 1361508 | 2021-05-27 | Nolan | Texas | 48353 | 1545 | 51 |
1358262 | 1358262 | 2021-05-26 | Nolan | Texas | 48353 | 1545 | 51 |
1355016 | 1355016 | 2021-05-25 | Nolan | Texas | 48353 | 1543 | 51 |
1351770 | 1351770 | 2021-05-24 | Nolan | Texas | 48353 | 1543 | 51 |
1348524 | 1348524 | 2021-05-23 | Nolan | Texas | 48353 | 1543 | 51 |
1345276 | 1345276 | 2021-05-22 | Nolan | Texas | 48353 | 1543 | 51 |
1342028 | 1342028 | 2021-05-21 | Nolan | Texas | 48353 | 1543 | 51 |
1338780 | 1338780 | 2021-05-20 | Nolan | Texas | 48353 | 1543 | 51 |
1335533 | 1335533 | 2021-05-19 | Nolan | Texas | 48353 | 1541 | 51 |
1332286 | 1332286 | 2021-05-18 | Nolan | Texas | 48353 | 1539 | 51 |
1329039 | 1329039 | 2021-05-17 | Nolan | Texas | 48353 | 1539 | 51 |
1325793 | 1325793 | 2021-05-16 | Nolan | Texas | 48353 | 1539 | 51 |
1322547 | 1322547 | 2021-05-15 | Nolan | Texas | 48353 | 1539 | 51 |
1319301 | 1319301 | 2021-05-14 | Nolan | Texas | 48353 | 1539 | 51 |
1316053 | 1316053 | 2021-05-13 | Nolan | Texas | 48353 | 1539 | 51 |
1312807 | 1312807 | 2021-05-12 | Nolan | Texas | 48353 | 1538 | 51 |
1309560 | 1309560 | 2021-05-11 | Nolan | Texas | 48353 | 1538 | 51 |
1306314 | 1306314 | 2021-05-10 | Nolan | Texas | 48353 | 1537 | 51 |
1303068 | 1303068 | 2021-05-09 | Nolan | Texas | 48353 | 1537 | 51 |
1299821 | 1299821 | 2021-05-08 | Nolan | Texas | 48353 | 1537 | 51 |
1296574 | 1296574 | 2021-05-07 | Nolan | Texas | 48353 | 1536 | 51 |
1293328 | 1293328 | 2021-05-06 | Nolan | Texas | 48353 | 1536 | 51 |
1290082 | 1290082 | 2021-05-05 | Nolan | Texas | 48353 | 1533 | 51 |
1286836 | 1286836 | 2021-05-04 | Nolan | Texas | 48353 | 1533 | 51 |
1283590 | 1283590 | 2021-05-03 | Nolan | Texas | 48353 | 1532 | 51 |
1280343 | 1280343 | 2021-05-02 | Nolan | Texas | 48353 | 1532 | 51 |
1277096 | 1277096 | 2021-05-01 | Nolan | Texas | 48353 | 1532 | 51 |
1273849 | 1273849 | 2021-04-30 | Nolan | Texas | 48353 | 1530 | 51 |
1270602 | 1270602 | 2021-04-29 | Nolan | Texas | 48353 | 1528 | 51 |
1267355 | 1267355 | 2021-04-28 | Nolan | Texas | 48353 | 1528 | 51 |
1264108 | 1264108 | 2021-04-27 | Nolan | Texas | 48353 | 1528 | 51 |
1260861 | 1260861 | 2021-04-26 | Nolan | Texas | 48353 | 1528 | 51 |
1257614 | 1257614 | 2021-04-25 | Nolan | Texas | 48353 | 1528 | 51 |
1254367 | 1254367 | 2021-04-24 | Nolan | Texas | 48353 | 1528 | 51 |
1251120 | 1251120 | 2021-04-23 | Nolan | Texas | 48353 | 1528 | 51 |
1247873 | 1247873 | 2021-04-22 | Nolan | Texas | 48353 | 1528 | 51 |
1244626 | 1244626 | 2021-04-21 | Nolan | Texas | 48353 | 1528 | 51 |
1241379 | 1241379 | 2021-04-20 | Nolan | Texas | 48353 | 1528 | 51 |
1238132 | 1238132 | 2021-04-19 | Nolan | Texas | 48353 | 1528 | 51 |
1234885 | 1234885 | 2021-04-18 | Nolan | Texas | 48353 | 1528 | 51 |
1231637 | 1231637 | 2021-04-17 | Nolan | Texas | 48353 | 1528 | 51 |
1228389 | 1228389 | 2021-04-16 | Nolan | Texas | 48353 | 1527 | 51 |
1225141 | 1225141 | 2021-04-15 | Nolan | Texas | 48353 | 1527 | 51 |
1221894 | 1221894 | 2021-04-14 | Nolan | Texas | 48353 | 1527 | 51 |
1218646 | 1218646 | 2021-04-13 | Nolan | Texas | 48353 | 1526 | 51 |
1215398 | 1215398 | 2021-04-12 | Nolan | Texas | 48353 | 1526 | 51 |
1212151 | 1212151 | 2021-04-11 | Nolan | Texas | 48353 | 1526 | 51 |
1208902 | 1208902 | 2021-04-10 | Nolan | Texas | 48353 | 1526 | 50 |
1205654 | 1205654 | 2021-04-09 | Nolan | Texas | 48353 | 1526 | 50 |
1202406 | 1202406 | 2021-04-08 | Nolan | Texas | 48353 | 1526 | 50 |
1199157 | 1199157 | 2021-04-07 | Nolan | Texas | 48353 | 1526 | 50 |
1195908 | 1195908 | 2021-04-06 | Nolan | Texas | 48353 | 1525 | 50 |
1192660 | 1192660 | 2021-04-05 | Nolan | Texas | 48353 | 1524 | 50 |
1189411 | 1189411 | 2021-04-04 | Nolan | Texas | 48353 | 1524 | 50 |
1186164 | 1186164 | 2021-04-03 | Nolan | Texas | 48353 | 1524 | 50 |
1182917 | 1182917 | 2021-04-02 | Nolan | Texas | 48353 | 1524 | 50 |
1179670 | 1179670 | 2021-04-01 | Nolan | Texas | 48353 | 1524 | 50 |
1176423 | 1176423 | 2021-03-31 | Nolan | Texas | 48353 | 1524 | 50 |
1173176 | 1173176 | 2021-03-30 | Nolan | Texas | 48353 | 1522 | 50 |
1169929 | 1169929 | 2021-03-29 | Nolan | Texas | 48353 | 1520 | 50 |
1166681 | 1166681 | 2021-03-28 | Nolan | Texas | 48353 | 1520 | 50 |
1163433 | 1163433 | 2021-03-27 | Nolan | Texas | 48353 | 1520 | 50 |
1160184 | 1160184 | 2021-03-26 | Nolan | Texas | 48353 | 1519 | 50 |
1156937 | 1156937 | 2021-03-25 | Nolan | Texas | 48353 | 1519 | 50 |
1153690 | 1153690 | 2021-03-24 | Nolan | Texas | 48353 | 1519 | 50 |
1150443 | 1150443 | 2021-03-23 | Nolan | Texas | 48353 | 1517 | 50 |
1147196 | 1147196 | 2021-03-22 | Nolan | Texas | 48353 | 1516 | 50 |
1143949 | 1143949 | 2021-03-21 | Nolan | Texas | 48353 | 1516 | 50 |
1140702 | 1140702 | 2021-03-20 | Nolan | Texas | 48353 | 1516 | 50 |
1137456 | 1137456 | 2021-03-19 | Nolan | Texas | 48353 | 1516 | 50 |
1134210 | 1134210 | 2021-03-18 | Nolan | Texas | 48353 | 1513 | 50 |
1130962 | 1130962 | 2021-03-17 | Nolan | Texas | 48353 | 1513 | 50 |
1127715 | 1127715 | 2021-03-16 | Nolan | Texas | 48353 | 1512 | 50 |
1124469 | 1124469 | 2021-03-15 | Nolan | Texas | 48353 | 1511 | 50 |
1121223 | 1121223 | 2021-03-14 | Nolan | Texas | 48353 | 1511 | 50 |
1117976 | 1117976 | 2021-03-13 | Nolan | Texas | 48353 | 1509 | 50 |
1114729 | 1114729 | 2021-03-12 | Nolan | Texas | 48353 | 1509 | 50 |
1111483 | 1111483 | 2021-03-11 | Nolan | Texas | 48353 | 1509 | 50 |
1108237 | 1108237 | 2021-03-10 | Nolan | Texas | 48353 | 1507 | 50 |
1104991 | 1104991 | 2021-03-09 | Nolan | Texas | 48353 | 1507 | 50 |
1101745 | 1101745 | 2021-03-08 | Nolan | Texas | 48353 | 1504 | 50 |
1098499 | 1098499 | 2021-03-07 | Nolan | Texas | 48353 | 1504 | 50 |
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);