ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
724 rows where county = "Hall" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419846 | 1419846 | 2021-06-14 | Hall | Texas | 48191 | 496 | 14 |
1416601 | 1416601 | 2021-06-13 | Hall | Texas | 48191 | 496 | 14 |
1413355 | 1413355 | 2021-06-12 | Hall | Texas | 48191 | 496 | 14 |
1410110 | 1410110 | 2021-06-11 | Hall | Texas | 48191 | 496 | 14 |
1406865 | 1406865 | 2021-06-10 | Hall | Texas | 48191 | 496 | 14 |
1403619 | 1403619 | 2021-06-09 | Hall | Texas | 48191 | 495 | 14 |
1400374 | 1400374 | 2021-06-08 | Hall | Texas | 48191 | 495 | 14 |
1397129 | 1397129 | 2021-06-07 | Hall | Texas | 48191 | 495 | 14 |
1393882 | 1393882 | 2021-06-06 | Hall | Texas | 48191 | 495 | 14 |
1390637 | 1390637 | 2021-06-05 | Hall | Texas | 48191 | 495 | 14 |
1387392 | 1387392 | 2021-06-04 | Hall | Texas | 48191 | 495 | 14 |
1384147 | 1384147 | 2021-06-03 | Hall | Texas | 48191 | 495 | 14 |
1380901 | 1380901 | 2021-06-02 | Hall | Texas | 48191 | 495 | 14 |
1377656 | 1377656 | 2021-06-01 | Hall | Texas | 48191 | 487 | 14 |
1374410 | 1374410 | 2021-05-31 | Hall | Texas | 48191 | 487 | 14 |
1371165 | 1371165 | 2021-05-30 | Hall | Texas | 48191 | 487 | 14 |
1367919 | 1367919 | 2021-05-29 | Hall | Texas | 48191 | 487 | 14 |
1364673 | 1364673 | 2021-05-28 | Hall | Texas | 48191 | 487 | 14 |
1361427 | 1361427 | 2021-05-27 | Hall | Texas | 48191 | 487 | 14 |
1358181 | 1358181 | 2021-05-26 | Hall | Texas | 48191 | 486 | 14 |
1354935 | 1354935 | 2021-05-25 | Hall | Texas | 48191 | 486 | 14 |
1351689 | 1351689 | 2021-05-24 | Hall | Texas | 48191 | 486 | 14 |
1348443 | 1348443 | 2021-05-23 | Hall | Texas | 48191 | 486 | 14 |
1345195 | 1345195 | 2021-05-22 | Hall | Texas | 48191 | 486 | 14 |
1341947 | 1341947 | 2021-05-21 | Hall | Texas | 48191 | 478 | 14 |
1338699 | 1338699 | 2021-05-20 | Hall | Texas | 48191 | 469 | 14 |
1335452 | 1335452 | 2021-05-19 | Hall | Texas | 48191 | 470 | 14 |
1332205 | 1332205 | 2021-05-18 | Hall | Texas | 48191 | 470 | 14 |
1328958 | 1328958 | 2021-05-17 | Hall | Texas | 48191 | 470 | 14 |
1325712 | 1325712 | 2021-05-16 | Hall | Texas | 48191 | 470 | 14 |
1322466 | 1322466 | 2021-05-15 | Hall | Texas | 48191 | 470 | 14 |
1319220 | 1319220 | 2021-05-14 | Hall | Texas | 48191 | 470 | 14 |
1315972 | 1315972 | 2021-05-13 | Hall | Texas | 48191 | 470 | 14 |
1312726 | 1312726 | 2021-05-12 | Hall | Texas | 48191 | 470 | 14 |
1309479 | 1309479 | 2021-05-11 | Hall | Texas | 48191 | 470 | 14 |
1306233 | 1306233 | 2021-05-10 | Hall | Texas | 48191 | 462 | 14 |
1302987 | 1302987 | 2021-05-09 | Hall | Texas | 48191 | 462 | 14 |
1299740 | 1299740 | 2021-05-08 | Hall | Texas | 48191 | 462 | 14 |
1296493 | 1296493 | 2021-05-07 | Hall | Texas | 48191 | 462 | 14 |
1293247 | 1293247 | 2021-05-06 | Hall | Texas | 48191 | 462 | 14 |
1290001 | 1290001 | 2021-05-05 | Hall | Texas | 48191 | 462 | 14 |
1286755 | 1286755 | 2021-05-04 | Hall | Texas | 48191 | 462 | 14 |
1283509 | 1283509 | 2021-05-03 | Hall | Texas | 48191 | 462 | 14 |
1280262 | 1280262 | 2021-05-02 | Hall | Texas | 48191 | 462 | 14 |
1277015 | 1277015 | 2021-05-01 | Hall | Texas | 48191 | 462 | 14 |
1273768 | 1273768 | 2021-04-30 | Hall | Texas | 48191 | 462 | 14 |
1270521 | 1270521 | 2021-04-29 | Hall | Texas | 48191 | 462 | 14 |
1267274 | 1267274 | 2021-04-28 | Hall | Texas | 48191 | 462 | 14 |
1264027 | 1264027 | 2021-04-27 | Hall | Texas | 48191 | 462 | 14 |
1260780 | 1260780 | 2021-04-26 | Hall | Texas | 48191 | 462 | 14 |
1257533 | 1257533 | 2021-04-25 | Hall | Texas | 48191 | 462 | 14 |
1254286 | 1254286 | 2021-04-24 | Hall | Texas | 48191 | 462 | 14 |
1251039 | 1251039 | 2021-04-23 | Hall | Texas | 48191 | 462 | 14 |
1247792 | 1247792 | 2021-04-22 | Hall | Texas | 48191 | 462 | 14 |
1244545 | 1244545 | 2021-04-21 | Hall | Texas | 48191 | 461 | 14 |
1241298 | 1241298 | 2021-04-20 | Hall | Texas | 48191 | 461 | 14 |
1238051 | 1238051 | 2021-04-19 | Hall | Texas | 48191 | 462 | 14 |
1234804 | 1234804 | 2021-04-18 | Hall | Texas | 48191 | 462 | 14 |
1231556 | 1231556 | 2021-04-17 | Hall | Texas | 48191 | 462 | 14 |
1228308 | 1228308 | 2021-04-16 | Hall | Texas | 48191 | 462 | 14 |
1225060 | 1225060 | 2021-04-15 | Hall | Texas | 48191 | 461 | 14 |
1221813 | 1221813 | 2021-04-14 | Hall | Texas | 48191 | 461 | 14 |
1218565 | 1218565 | 2021-04-13 | Hall | Texas | 48191 | 462 | 14 |
1215317 | 1215317 | 2021-04-12 | Hall | Texas | 48191 | 456 | 14 |
1212070 | 1212070 | 2021-04-11 | Hall | Texas | 48191 | 456 | 14 |
1208821 | 1208821 | 2021-04-10 | Hall | Texas | 48191 | 456 | 14 |
1205573 | 1205573 | 2021-04-09 | Hall | Texas | 48191 | 449 | 14 |
1202325 | 1202325 | 2021-04-08 | Hall | Texas | 48191 | 448 | 14 |
1199076 | 1199076 | 2021-04-07 | Hall | Texas | 48191 | 435 | 14 |
1195827 | 1195827 | 2021-04-06 | Hall | Texas | 48191 | 434 | 14 |
1192579 | 1192579 | 2021-04-05 | Hall | Texas | 48191 | 437 | 14 |
1189330 | 1189330 | 2021-04-04 | Hall | Texas | 48191 | 437 | 14 |
1186083 | 1186083 | 2021-04-03 | Hall | Texas | 48191 | 437 | 14 |
1182836 | 1182836 | 2021-04-02 | Hall | Texas | 48191 | 437 | 14 |
1179589 | 1179589 | 2021-04-01 | Hall | Texas | 48191 | 436 | 14 |
1176342 | 1176342 | 2021-03-31 | Hall | Texas | 48191 | 432 | 14 |
1173095 | 1173095 | 2021-03-30 | Hall | Texas | 48191 | 432 | 14 |
1169848 | 1169848 | 2021-03-29 | Hall | Texas | 48191 | 432 | 14 |
1166600 | 1166600 | 2021-03-28 | Hall | Texas | 48191 | 432 | 14 |
1163352 | 1163352 | 2021-03-27 | Hall | Texas | 48191 | 432 | 14 |
1160103 | 1160103 | 2021-03-26 | Hall | Texas | 48191 | 429 | 14 |
1156856 | 1156856 | 2021-03-25 | Hall | Texas | 48191 | 429 | 14 |
1153609 | 1153609 | 2021-03-24 | Hall | Texas | 48191 | 429 | 14 |
1150362 | 1150362 | 2021-03-23 | Hall | Texas | 48191 | 426 | 14 |
1147115 | 1147115 | 2021-03-22 | Hall | Texas | 48191 | 425 | 14 |
1143868 | 1143868 | 2021-03-21 | Hall | Texas | 48191 | 425 | 14 |
1140621 | 1140621 | 2021-03-20 | Hall | Texas | 48191 | 425 | 14 |
1137375 | 1137375 | 2021-03-19 | Hall | Texas | 48191 | 425 | 14 |
1134129 | 1134129 | 2021-03-18 | Hall | Texas | 48191 | 425 | 14 |
1130881 | 1130881 | 2021-03-17 | Hall | Texas | 48191 | 425 | 14 |
1127634 | 1127634 | 2021-03-16 | Hall | Texas | 48191 | 425 | 14 |
1124388 | 1124388 | 2021-03-15 | Hall | Texas | 48191 | 425 | 14 |
1121142 | 1121142 | 2021-03-14 | Hall | Texas | 48191 | 425 | 14 |
1117895 | 1117895 | 2021-03-13 | Hall | Texas | 48191 | 425 | 14 |
1114648 | 1114648 | 2021-03-12 | Hall | Texas | 48191 | 425 | 14 |
1111402 | 1111402 | 2021-03-11 | Hall | Texas | 48191 | 425 | 14 |
1108156 | 1108156 | 2021-03-10 | Hall | Texas | 48191 | 424 | 14 |
1104910 | 1104910 | 2021-03-09 | Hall | Texas | 48191 | 424 | 14 |
1101664 | 1101664 | 2021-03-08 | Hall | Texas | 48191 | 421 | 14 |
1098418 | 1098418 | 2021-03-07 | Hall | Texas | 48191 | 421 | 14 |
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);