ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Bandera" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419760 | 1419760 | 2021-06-14 | Bandera | Texas | 48019 | 1452 | 28 |
1416515 | 1416515 | 2021-06-13 | Bandera | Texas | 48019 | 1452 | 28 |
1413269 | 1413269 | 2021-06-12 | Bandera | Texas | 48019 | 1452 | 28 |
1410024 | 1410024 | 2021-06-11 | Bandera | Texas | 48019 | 1446 | 28 |
1406779 | 1406779 | 2021-06-10 | Bandera | Texas | 48019 | 1445 | 28 |
1403533 | 1403533 | 2021-06-09 | Bandera | Texas | 48019 | 1437 | 28 |
1400288 | 1400288 | 2021-06-08 | Bandera | Texas | 48019 | 1432 | 28 |
1397043 | 1397043 | 2021-06-07 | Bandera | Texas | 48019 | 1428 | 28 |
1393796 | 1393796 | 2021-06-06 | Bandera | Texas | 48019 | 1428 | 28 |
1390551 | 1390551 | 2021-06-05 | Bandera | Texas | 48019 | 1428 | 28 |
1387306 | 1387306 | 2021-06-04 | Bandera | Texas | 48019 | 1428 | 28 |
1384061 | 1384061 | 2021-06-03 | Bandera | Texas | 48019 | 1428 | 28 |
1380815 | 1380815 | 2021-06-02 | Bandera | Texas | 48019 | 1427 | 28 |
1377570 | 1377570 | 2021-06-01 | Bandera | Texas | 48019 | 1427 | 28 |
1374324 | 1374324 | 2021-05-31 | Bandera | Texas | 48019 | 1427 | 28 |
1371079 | 1371079 | 2021-05-30 | Bandera | Texas | 48019 | 1427 | 28 |
1367833 | 1367833 | 2021-05-29 | Bandera | Texas | 48019 | 1427 | 28 |
1364587 | 1364587 | 2021-05-28 | Bandera | Texas | 48019 | 1427 | 27 |
1361341 | 1361341 | 2021-05-27 | Bandera | Texas | 48019 | 1427 | 27 |
1358095 | 1358095 | 2021-05-26 | Bandera | Texas | 48019 | 1427 | 27 |
1354849 | 1354849 | 2021-05-25 | Bandera | Texas | 48019 | 1427 | 27 |
1351603 | 1351603 | 2021-05-24 | Bandera | Texas | 48019 | 1425 | 27 |
1348357 | 1348357 | 2021-05-23 | Bandera | Texas | 48019 | 1425 | 27 |
1345109 | 1345109 | 2021-05-22 | Bandera | Texas | 48019 | 1425 | 27 |
1341861 | 1341861 | 2021-05-21 | Bandera | Texas | 48019 | 1424 | 27 |
1338613 | 1338613 | 2021-05-20 | Bandera | Texas | 48019 | 1420 | 27 |
1335366 | 1335366 | 2021-05-19 | Bandera | Texas | 48019 | 1416 | 27 |
1332119 | 1332119 | 2021-05-18 | Bandera | Texas | 48019 | 1416 | 27 |
1328872 | 1328872 | 2021-05-17 | Bandera | Texas | 48019 | 1410 | 27 |
1325626 | 1325626 | 2021-05-16 | Bandera | Texas | 48019 | 1410 | 27 |
1322380 | 1322380 | 2021-05-15 | Bandera | Texas | 48019 | 1410 | 27 |
1319134 | 1319134 | 2021-05-14 | Bandera | Texas | 48019 | 1409 | 27 |
1315886 | 1315886 | 2021-05-13 | Bandera | Texas | 48019 | 1403 | 27 |
1312640 | 1312640 | 2021-05-12 | Bandera | Texas | 48019 | 1402 | 27 |
1309393 | 1309393 | 2021-05-11 | Bandera | Texas | 48019 | 1402 | 27 |
1306147 | 1306147 | 2021-05-10 | Bandera | Texas | 48019 | 1393 | 27 |
1302901 | 1302901 | 2021-05-09 | Bandera | Texas | 48019 | 1393 | 27 |
1299654 | 1299654 | 2021-05-08 | Bandera | Texas | 48019 | 1393 | 27 |
1296407 | 1296407 | 2021-05-07 | Bandera | Texas | 48019 | 1392 | 27 |
1293161 | 1293161 | 2021-05-06 | Bandera | Texas | 48019 | 1389 | 27 |
1289915 | 1289915 | 2021-05-05 | Bandera | Texas | 48019 | 1387 | 27 |
1286669 | 1286669 | 2021-05-04 | Bandera | Texas | 48019 | 1387 | 27 |
1283423 | 1283423 | 2021-05-03 | Bandera | Texas | 48019 | 1399 | 27 |
1280176 | 1280176 | 2021-05-02 | Bandera | Texas | 48019 | 1386 | 27 |
1276929 | 1276929 | 2021-05-01 | Bandera | Texas | 48019 | 1386 | 27 |
1273682 | 1273682 | 2021-04-30 | Bandera | Texas | 48019 | 1383 | 27 |
1270435 | 1270435 | 2021-04-29 | Bandera | Texas | 48019 | 1379 | 27 |
1267188 | 1267188 | 2021-04-28 | Bandera | Texas | 48019 | 1375 | 27 |
1263941 | 1263941 | 2021-04-27 | Bandera | Texas | 48019 | 1373 | 27 |
1260694 | 1260694 | 2021-04-26 | Bandera | Texas | 48019 | 1372 | 27 |
1257447 | 1257447 | 2021-04-25 | Bandera | Texas | 48019 | 1372 | 27 |
1254200 | 1254200 | 2021-04-24 | Bandera | Texas | 48019 | 1372 | 27 |
1250953 | 1250953 | 2021-04-23 | Bandera | Texas | 48019 | 1370 | 27 |
1247706 | 1247706 | 2021-04-22 | Bandera | Texas | 48019 | 1369 | 27 |
1244459 | 1244459 | 2021-04-21 | Bandera | Texas | 48019 | 1362 | 27 |
1241212 | 1241212 | 2021-04-20 | Bandera | Texas | 48019 | 1353 | 27 |
1237965 | 1237965 | 2021-04-19 | Bandera | Texas | 48019 | 1353 | 27 |
1234718 | 1234718 | 2021-04-18 | Bandera | Texas | 48019 | 1353 | 27 |
1231470 | 1231470 | 2021-04-17 | Bandera | Texas | 48019 | 1353 | 27 |
1228222 | 1228222 | 2021-04-16 | Bandera | Texas | 48019 | 1347 | 27 |
1224974 | 1224974 | 2021-04-15 | Bandera | Texas | 48019 | 1346 | 27 |
1221727 | 1221727 | 2021-04-14 | Bandera | Texas | 48019 | 1340 | 27 |
1218479 | 1218479 | 2021-04-13 | Bandera | Texas | 48019 | 1338 | 27 |
1215231 | 1215231 | 2021-04-12 | Bandera | Texas | 48019 | 1338 | 27 |
1211984 | 1211984 | 2021-04-11 | Bandera | Texas | 48019 | 1338 | 27 |
1208735 | 1208735 | 2021-04-10 | Bandera | Texas | 48019 | 1338 | 27 |
1205487 | 1205487 | 2021-04-09 | Bandera | Texas | 48019 | 1338 | 27 |
1202239 | 1202239 | 2021-04-08 | Bandera | Texas | 48019 | 1338 | 27 |
1198990 | 1198990 | 2021-04-07 | Bandera | Texas | 48019 | 1335 | 27 |
1195741 | 1195741 | 2021-04-06 | Bandera | Texas | 48019 | 1332 | 27 |
1192493 | 1192493 | 2021-04-05 | Bandera | Texas | 48019 | 1332 | 27 |
1189244 | 1189244 | 2021-04-04 | Bandera | Texas | 48019 | 1332 | 27 |
1185997 | 1185997 | 2021-04-03 | Bandera | Texas | 48019 | 1332 | 27 |
1182750 | 1182750 | 2021-04-02 | Bandera | Texas | 48019 | 1332 | 27 |
1179503 | 1179503 | 2021-04-01 | Bandera | Texas | 48019 | 1331 | 27 |
1176256 | 1176256 | 2021-03-31 | Bandera | Texas | 48019 | 1331 | 27 |
1173009 | 1173009 | 2021-03-30 | Bandera | Texas | 48019 | 1326 | 27 |
1169762 | 1169762 | 2021-03-29 | Bandera | Texas | 48019 | 1325 | 27 |
1166514 | 1166514 | 2021-03-28 | Bandera | Texas | 48019 | 1325 | 27 |
1163266 | 1163266 | 2021-03-27 | Bandera | Texas | 48019 | 1325 | 27 |
1160017 | 1160017 | 2021-03-26 | Bandera | Texas | 48019 | 1323 | 27 |
1156770 | 1156770 | 2021-03-25 | Bandera | Texas | 48019 | 1321 | 27 |
1153523 | 1153523 | 2021-03-24 | Bandera | Texas | 48019 | 1314 | 27 |
1150276 | 1150276 | 2021-03-23 | Bandera | Texas | 48019 | 1307 | 27 |
1147029 | 1147029 | 2021-03-22 | Bandera | Texas | 48019 | 1308 | 27 |
1143782 | 1143782 | 2021-03-21 | Bandera | Texas | 48019 | 1308 | 27 |
1140535 | 1140535 | 2021-03-20 | Bandera | Texas | 48019 | 1308 | 27 |
1137289 | 1137289 | 2021-03-19 | Bandera | Texas | 48019 | 1304 | 27 |
1134043 | 1134043 | 2021-03-18 | Bandera | Texas | 48019 | 1299 | 27 |
1130795 | 1130795 | 2021-03-17 | Bandera | Texas | 48019 | 1296 | 27 |
1127548 | 1127548 | 2021-03-16 | Bandera | Texas | 48019 | 1294 | 27 |
1124302 | 1124302 | 2021-03-15 | Bandera | Texas | 48019 | 1294 | 27 |
1121056 | 1121056 | 2021-03-14 | Bandera | Texas | 48019 | 1294 | 27 |
1117809 | 1117809 | 2021-03-13 | Bandera | Texas | 48019 | 1294 | 26 |
1114562 | 1114562 | 2021-03-12 | Bandera | Texas | 48019 | 1291 | 26 |
1111316 | 1111316 | 2021-03-11 | Bandera | Texas | 48019 | 1290 | 26 |
1108070 | 1108070 | 2021-03-10 | Bandera | Texas | 48019 | 1290 | 26 |
1104824 | 1104824 | 2021-03-09 | Bandera | Texas | 48019 | 1289 | 26 |
1101578 | 1101578 | 2021-03-08 | Bandera | Texas | 48019 | 1286 | 25 |
1098332 | 1098332 | 2021-03-07 | Bandera | Texas | 48019 | 1285 | 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);