ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48103 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419802 | 1419802 | 2021-06-14 | Crane | Texas | 48103 | 540 | 12 |
1416557 | 1416557 | 2021-06-13 | Crane | Texas | 48103 | 540 | 12 |
1413311 | 1413311 | 2021-06-12 | Crane | Texas | 48103 | 540 | 12 |
1410066 | 1410066 | 2021-06-11 | Crane | Texas | 48103 | 541 | 12 |
1406821 | 1406821 | 2021-06-10 | Crane | Texas | 48103 | 540 | 12 |
1403575 | 1403575 | 2021-06-09 | Crane | Texas | 48103 | 540 | 12 |
1400330 | 1400330 | 2021-06-08 | Crane | Texas | 48103 | 540 | 12 |
1397085 | 1397085 | 2021-06-07 | Crane | Texas | 48103 | 540 | 12 |
1393838 | 1393838 | 2021-06-06 | Crane | Texas | 48103 | 540 | 12 |
1390593 | 1390593 | 2021-06-05 | Crane | Texas | 48103 | 540 | 12 |
1387348 | 1387348 | 2021-06-04 | Crane | Texas | 48103 | 539 | 12 |
1384103 | 1384103 | 2021-06-03 | Crane | Texas | 48103 | 540 | 12 |
1380857 | 1380857 | 2021-06-02 | Crane | Texas | 48103 | 538 | 12 |
1377612 | 1377612 | 2021-06-01 | Crane | Texas | 48103 | 537 | 12 |
1374366 | 1374366 | 2021-05-31 | Crane | Texas | 48103 | 537 | 12 |
1371121 | 1371121 | 2021-05-30 | Crane | Texas | 48103 | 536 | 12 |
1367875 | 1367875 | 2021-05-29 | Crane | Texas | 48103 | 536 | 12 |
1364629 | 1364629 | 2021-05-28 | Crane | Texas | 48103 | 536 | 12 |
1361383 | 1361383 | 2021-05-27 | Crane | Texas | 48103 | 536 | 12 |
1358137 | 1358137 | 2021-05-26 | Crane | Texas | 48103 | 535 | 12 |
1354891 | 1354891 | 2021-05-25 | Crane | Texas | 48103 | 534 | 12 |
1351645 | 1351645 | 2021-05-24 | Crane | Texas | 48103 | 534 | 12 |
1348399 | 1348399 | 2021-05-23 | Crane | Texas | 48103 | 534 | 12 |
1345151 | 1345151 | 2021-05-22 | Crane | Texas | 48103 | 534 | 12 |
1341903 | 1341903 | 2021-05-21 | Crane | Texas | 48103 | 534 | 12 |
1338655 | 1338655 | 2021-05-20 | Crane | Texas | 48103 | 534 | 12 |
1335408 | 1335408 | 2021-05-19 | Crane | Texas | 48103 | 534 | 12 |
1332161 | 1332161 | 2021-05-18 | Crane | Texas | 48103 | 533 | 12 |
1328914 | 1328914 | 2021-05-17 | Crane | Texas | 48103 | 533 | 12 |
1325668 | 1325668 | 2021-05-16 | Crane | Texas | 48103 | 533 | 12 |
1322422 | 1322422 | 2021-05-15 | Crane | Texas | 48103 | 533 | 12 |
1319176 | 1319176 | 2021-05-14 | Crane | Texas | 48103 | 532 | 12 |
1315928 | 1315928 | 2021-05-13 | Crane | Texas | 48103 | 532 | 12 |
1312682 | 1312682 | 2021-05-12 | Crane | Texas | 48103 | 531 | 12 |
1309435 | 1309435 | 2021-05-11 | Crane | Texas | 48103 | 531 | 12 |
1306189 | 1306189 | 2021-05-10 | Crane | Texas | 48103 | 531 | 12 |
1302943 | 1302943 | 2021-05-09 | Crane | Texas | 48103 | 531 | 12 |
1299696 | 1299696 | 2021-05-08 | Crane | Texas | 48103 | 531 | 12 |
1296449 | 1296449 | 2021-05-07 | Crane | Texas | 48103 | 531 | 12 |
1293203 | 1293203 | 2021-05-06 | Crane | Texas | 48103 | 530 | 12 |
1289957 | 1289957 | 2021-05-05 | Crane | Texas | 48103 | 530 | 12 |
1286711 | 1286711 | 2021-05-04 | Crane | Texas | 48103 | 530 | 12 |
1283465 | 1283465 | 2021-05-03 | Crane | Texas | 48103 | 530 | 12 |
1280218 | 1280218 | 2021-05-02 | Crane | Texas | 48103 | 530 | 12 |
1276971 | 1276971 | 2021-05-01 | Crane | Texas | 48103 | 530 | 12 |
1273724 | 1273724 | 2021-04-30 | Crane | Texas | 48103 | 529 | 12 |
1270477 | 1270477 | 2021-04-29 | Crane | Texas | 48103 | 528 | 12 |
1267230 | 1267230 | 2021-04-28 | Crane | Texas | 48103 | 528 | 12 |
1263983 | 1263983 | 2021-04-27 | Crane | Texas | 48103 | 528 | 12 |
1260736 | 1260736 | 2021-04-26 | Crane | Texas | 48103 | 527 | 12 |
1257489 | 1257489 | 2021-04-25 | Crane | Texas | 48103 | 527 | 12 |
1254242 | 1254242 | 2021-04-24 | Crane | Texas | 48103 | 527 | 12 |
1250995 | 1250995 | 2021-04-23 | Crane | Texas | 48103 | 527 | 12 |
1247748 | 1247748 | 2021-04-22 | Crane | Texas | 48103 | 526 | 12 |
1244501 | 1244501 | 2021-04-21 | Crane | Texas | 48103 | 525 | 12 |
1241254 | 1241254 | 2021-04-20 | Crane | Texas | 48103 | 523 | 12 |
1238007 | 1238007 | 2021-04-19 | Crane | Texas | 48103 | 523 | 12 |
1234760 | 1234760 | 2021-04-18 | Crane | Texas | 48103 | 523 | 12 |
1231512 | 1231512 | 2021-04-17 | Crane | Texas | 48103 | 523 | 12 |
1228264 | 1228264 | 2021-04-16 | Crane | Texas | 48103 | 522 | 12 |
1225016 | 1225016 | 2021-04-15 | Crane | Texas | 48103 | 522 | 12 |
1221769 | 1221769 | 2021-04-14 | Crane | Texas | 48103 | 521 | 12 |
1218521 | 1218521 | 2021-04-13 | Crane | Texas | 48103 | 521 | 12 |
1215273 | 1215273 | 2021-04-12 | Crane | Texas | 48103 | 521 | 12 |
1212026 | 1212026 | 2021-04-11 | Crane | Texas | 48103 | 521 | 12 |
1208777 | 1208777 | 2021-04-10 | Crane | Texas | 48103 | 521 | 12 |
1205529 | 1205529 | 2021-04-09 | Crane | Texas | 48103 | 521 | 12 |
1202281 | 1202281 | 2021-04-08 | Crane | Texas | 48103 | 521 | 12 |
1199032 | 1199032 | 2021-04-07 | Crane | Texas | 48103 | 521 | 12 |
1195783 | 1195783 | 2021-04-06 | Crane | Texas | 48103 | 520 | 12 |
1192535 | 1192535 | 2021-04-05 | Crane | Texas | 48103 | 520 | 12 |
1189286 | 1189286 | 2021-04-04 | Crane | Texas | 48103 | 520 | 12 |
1186039 | 1186039 | 2021-04-03 | Crane | Texas | 48103 | 520 | 12 |
1182792 | 1182792 | 2021-04-02 | Crane | Texas | 48103 | 520 | 12 |
1179545 | 1179545 | 2021-04-01 | Crane | Texas | 48103 | 519 | 12 |
1176298 | 1176298 | 2021-03-31 | Crane | Texas | 48103 | 518 | 12 |
1173051 | 1173051 | 2021-03-30 | Crane | Texas | 48103 | 518 | 12 |
1169804 | 1169804 | 2021-03-29 | Crane | Texas | 48103 | 516 | 12 |
1166556 | 1166556 | 2021-03-28 | Crane | Texas | 48103 | 516 | 12 |
1163308 | 1163308 | 2021-03-27 | Crane | Texas | 48103 | 516 | 12 |
1160059 | 1160059 | 2021-03-26 | Crane | Texas | 48103 | 516 | 12 |
1156812 | 1156812 | 2021-03-25 | Crane | Texas | 48103 | 516 | 12 |
1153565 | 1153565 | 2021-03-24 | Crane | Texas | 48103 | 515 | 12 |
1150318 | 1150318 | 2021-03-23 | Crane | Texas | 48103 | 515 | 12 |
1147071 | 1147071 | 2021-03-22 | Crane | Texas | 48103 | 514 | 12 |
1143824 | 1143824 | 2021-03-21 | Crane | Texas | 48103 | 514 | 12 |
1140577 | 1140577 | 2021-03-20 | Crane | Texas | 48103 | 513 | 12 |
1137331 | 1137331 | 2021-03-19 | Crane | Texas | 48103 | 514 | 12 |
1134085 | 1134085 | 2021-03-18 | Crane | Texas | 48103 | 514 | 12 |
1130837 | 1130837 | 2021-03-17 | Crane | Texas | 48103 | 513 | 12 |
1127590 | 1127590 | 2021-03-16 | Crane | Texas | 48103 | 513 | 12 |
1124344 | 1124344 | 2021-03-15 | Crane | Texas | 48103 | 513 | 12 |
1121098 | 1121098 | 2021-03-14 | Crane | Texas | 48103 | 513 | 12 |
1117851 | 1117851 | 2021-03-13 | Crane | Texas | 48103 | 513 | 12 |
1114604 | 1114604 | 2021-03-12 | Crane | Texas | 48103 | 513 | 12 |
1111358 | 1111358 | 2021-03-11 | Crane | Texas | 48103 | 511 | 12 |
1108112 | 1108112 | 2021-03-10 | Crane | Texas | 48103 | 514 | 12 |
1104866 | 1104866 | 2021-03-09 | Crane | Texas | 48103 | 509 | 12 |
1101620 | 1101620 | 2021-03-08 | Crane | Texas | 48103 | 509 | 12 |
1098374 | 1098374 | 2021-03-07 | Crane | Texas | 48103 | 509 | 12 |
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);