ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where fips = 48029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1494420 | 1494420 | 2021-07-07 | Bexar | Texas | 48029 | 228650 | 3635 |
1491173 | 1491173 | 2021-07-06 | Bexar | Texas | 48029 | 227486 | 3635 |
1487926 | 1487926 | 2021-07-05 | Bexar | Texas | 48029 | 227486 | 3634 |
1484679 | 1484679 | 2021-07-04 | Bexar | Texas | 48029 | 227486 | 3634 |
1481433 | 1481433 | 2021-07-03 | Bexar | Texas | 48029 | 227486 | 3633 |
1478186 | 1478186 | 2021-07-02 | Bexar | Texas | 48029 | 227486 | 3629 |
1474940 | 1474940 | 2021-07-01 | Bexar | Texas | 48029 | 227486 | 3628 |
1471694 | 1471694 | 2021-06-30 | Bexar | Texas | 48029 | 227486 | 3628 |
1468449 | 1468449 | 2021-06-29 | Bexar | Texas | 48029 | 226416 | 3627 |
1465204 | 1465204 | 2021-06-28 | Bexar | Texas | 48029 | 226416 | 3626 |
1461959 | 1461959 | 2021-06-27 | Bexar | Texas | 48029 | 226416 | 3625 |
1458714 | 1458714 | 2021-06-26 | Bexar | Texas | 48029 | 226416 | 3623 |
1455469 | 1455469 | 2021-06-25 | Bexar | Texas | 48029 | 226416 | 3623 |
1452224 | 1452224 | 2021-06-24 | Bexar | Texas | 48029 | 226416 | 3617 |
1448978 | 1448978 | 2021-06-23 | Bexar | Texas | 48029 | 226416 | 3614 |
1445733 | 1445733 | 2021-06-22 | Bexar | Texas | 48029 | 225559 | 3613 |
1442488 | 1442488 | 2021-06-21 | Bexar | Texas | 48029 | 225559 | 3613 |
1439243 | 1439243 | 2021-06-20 | Bexar | Texas | 48029 | 225559 | 3613 |
1435996 | 1435996 | 2021-06-19 | Bexar | Texas | 48029 | 225559 | 3611 |
1432749 | 1432749 | 2021-06-18 | Bexar | Texas | 48029 | 225559 | 3610 |
1429503 | 1429503 | 2021-06-17 | Bexar | Texas | 48029 | 225559 | 3608 |
1426258 | 1426258 | 2021-06-16 | Bexar | Texas | 48029 | 225559 | 3605 |
1423011 | 1423011 | 2021-06-15 | Bexar | Texas | 48029 | 224679 | 3600 |
1419765 | 1419765 | 2021-06-14 | Bexar | Texas | 48029 | 224679 | 3596 |
1416520 | 1416520 | 2021-06-13 | Bexar | Texas | 48029 | 224679 | 3596 |
1413274 | 1413274 | 2021-06-12 | Bexar | Texas | 48029 | 224679 | 3596 |
1410029 | 1410029 | 2021-06-11 | Bexar | Texas | 48029 | 224679 | 3593 |
1406784 | 1406784 | 2021-06-10 | Bexar | Texas | 48029 | 224679 | 3590 |
1403538 | 1403538 | 2021-06-09 | Bexar | Texas | 48029 | 224679 | 3588 |
1400293 | 1400293 | 2021-06-08 | Bexar | Texas | 48029 | 224197 | 3585 |
1397048 | 1397048 | 2021-06-07 | Bexar | Texas | 48029 | 224197 | 3583 |
1393801 | 1393801 | 2021-06-06 | Bexar | Texas | 48029 | 224197 | 3583 |
1390556 | 1390556 | 2021-06-05 | Bexar | Texas | 48029 | 224197 | 3583 |
1387311 | 1387311 | 2021-06-04 | Bexar | Texas | 48029 | 224197 | 3580 |
1384066 | 1384066 | 2021-06-03 | Bexar | Texas | 48029 | 224096 | 3577 |
1380820 | 1380820 | 2021-06-02 | Bexar | Texas | 48029 | 222910 | 3574 |
1377575 | 1377575 | 2021-06-01 | Bexar | Texas | 48029 | 222910 | 3572 |
1374329 | 1374329 | 2021-05-31 | Bexar | Texas | 48029 | 222910 | 3571 |
1371084 | 1371084 | 2021-05-30 | Bexar | Texas | 48029 | 222910 | 3571 |
1367838 | 1367838 | 2021-05-29 | Bexar | Texas | 48029 | 222910 | 3571 |
1364592 | 1364592 | 2021-05-28 | Bexar | Texas | 48029 | 222910 | 3567 |
1361346 | 1361346 | 2021-05-27 | Bexar | Texas | 48029 | 222772 | 3565 |
1358100 | 1358100 | 2021-05-26 | Bexar | Texas | 48029 | 222598 | 3560 |
1354854 | 1354854 | 2021-05-25 | Bexar | Texas | 48029 | 222583 | 3558 |
1351608 | 1351608 | 2021-05-24 | Bexar | Texas | 48029 | 222441 | 3555 |
1348362 | 1348362 | 2021-05-23 | Bexar | Texas | 48029 | 221676 | 3555 |
1345114 | 1345114 | 2021-05-22 | Bexar | Texas | 48029 | 221676 | 3554 |
1341866 | 1341866 | 2021-05-21 | Bexar | Texas | 48029 | 221676 | 3550 |
1338618 | 1338618 | 2021-05-20 | Bexar | Texas | 48029 | 221615 | 3546 |
1335371 | 1335371 | 2021-05-19 | Bexar | Texas | 48029 | 221497 | 3546 |
1332124 | 1332124 | 2021-05-18 | Bexar | Texas | 48029 | 221349 | 3538 |
1328877 | 1328877 | 2021-05-17 | Bexar | Texas | 48029 | 221190 | 3536 |
1325631 | 1325631 | 2021-05-16 | Bexar | Texas | 48029 | 220629 | 3534 |
1322385 | 1322385 | 2021-05-15 | Bexar | Texas | 48029 | 220629 | 3534 |
1319139 | 1319139 | 2021-05-14 | Bexar | Texas | 48029 | 220629 | 3529 |
1315891 | 1315891 | 2021-05-13 | Bexar | Texas | 48029 | 220529 | 3523 |
1312645 | 1312645 | 2021-05-12 | Bexar | Texas | 48029 | 220264 | 3521 |
1309398 | 1309398 | 2021-05-11 | Bexar | Texas | 48029 | 220066 | 3518 |
1306152 | 1306152 | 2021-05-10 | Bexar | Texas | 48029 | 219941 | 3508 |
1302906 | 1302906 | 2021-05-09 | Bexar | Texas | 48029 | 219133 | 3508 |
1299659 | 1299659 | 2021-05-08 | Bexar | Texas | 48029 | 219133 | 3506 |
1296412 | 1296412 | 2021-05-07 | Bexar | Texas | 48029 | 219133 | 3504 |
1293166 | 1293166 | 2021-05-06 | Bexar | Texas | 48029 | 219020 | 3498 |
1289920 | 1289920 | 2021-05-05 | Bexar | Texas | 48029 | 218831 | 3494 |
1286674 | 1286674 | 2021-05-04 | Bexar | Texas | 48029 | 218724 | 3489 |
1283428 | 1283428 | 2021-05-03 | Bexar | Texas | 48029 | 218559 | 3485 |
1280181 | 1280181 | 2021-05-02 | Bexar | Texas | 48029 | 217498 | 3485 |
1276934 | 1276934 | 2021-05-01 | Bexar | Texas | 48029 | 217498 | 3485 |
1273687 | 1273687 | 2021-04-30 | Bexar | Texas | 48029 | 217498 | 3478 |
1270440 | 1270440 | 2021-04-29 | Bexar | Texas | 48029 | 217231 | 3472 |
1267193 | 1267193 | 2021-04-28 | Bexar | Texas | 48029 | 216890 | 3468 |
1263946 | 1263946 | 2021-04-27 | Bexar | Texas | 48029 | 216488 | 3461 |
1260699 | 1260699 | 2021-04-26 | Bexar | Texas | 48029 | 216351 | 3450 |
1257452 | 1257452 | 2021-04-25 | Bexar | Texas | 48029 | 214711 | 3450 |
1254205 | 1254205 | 2021-04-24 | Bexar | Texas | 48029 | 214711 | 3450 |
1250958 | 1250958 | 2021-04-23 | Bexar | Texas | 48029 | 214711 | 3446 |
1247711 | 1247711 | 2021-04-22 | Bexar | Texas | 48029 | 214643 | 3441 |
1244464 | 1244464 | 2021-04-21 | Bexar | Texas | 48029 | 214394 | 3437 |
1241217 | 1241217 | 2021-04-20 | Bexar | Texas | 48029 | 214083 | 3422 |
1237970 | 1237970 | 2021-04-19 | Bexar | Texas | 48029 | 213689 | 3422 |
1234723 | 1234723 | 2021-04-18 | Bexar | Texas | 48029 | 211434 | 3422 |
1231475 | 1231475 | 2021-04-17 | Bexar | Texas | 48029 | 211434 | 3422 |
1228227 | 1228227 | 2021-04-16 | Bexar | Texas | 48029 | 211434 | 3416 |
1224979 | 1224979 | 2021-04-15 | Bexar | Texas | 48029 | 211409 | 3413 |
1221732 | 1221732 | 2021-04-14 | Bexar | Texas | 48029 | 211333 | 3408 |
1218484 | 1218484 | 2021-04-13 | Bexar | Texas | 48029 | 211081 | 3403 |
1215236 | 1215236 | 2021-04-12 | Bexar | Texas | 48029 | 210808 | 3398 |
1211989 | 1211989 | 2021-04-11 | Bexar | Texas | 48029 | 208864 | 3398 |
1208740 | 1208740 | 2021-04-10 | Bexar | Texas | 48029 | 208864 | 3398 |
1205492 | 1205492 | 2021-04-09 | Bexar | Texas | 48029 | 208864 | 3389 |
1202244 | 1202244 | 2021-04-08 | Bexar | Texas | 48029 | 208618 | 3377 |
1198995 | 1198995 | 2021-04-07 | Bexar | Texas | 48029 | 208474 | 3366 |
1195746 | 1195746 | 2021-04-06 | Bexar | Texas | 48029 | 208184 | 3360 |
1192498 | 1192498 | 2021-04-05 | Bexar | Texas | 48029 | 207961 | 3350 |
1189249 | 1189249 | 2021-04-04 | Bexar | Texas | 48029 | 205789 | 3350 |
1186002 | 1186002 | 2021-04-03 | Bexar | Texas | 48029 | 205789 | 3349 |
1182755 | 1182755 | 2021-04-02 | Bexar | Texas | 48029 | 205789 | 3335 |
1179508 | 1179508 | 2021-04-01 | Bexar | Texas | 48029 | 205789 | 3319 |
1176261 | 1176261 | 2021-03-31 | Bexar | Texas | 48029 | 205540 | 3308 |
1173014 | 1173014 | 2021-03-30 | Bexar | Texas | 48029 | 205418 | 3304 |
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);