ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where county = "Bexar" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718531 | 1718531 | 2021-09-14 | Bexar | Texas | 48029 | 300275 | 4357 |
1715283 | 1715283 | 2021-09-13 | Bexar | Texas | 48029 | 299500 | 4332 |
1712037 | 1712037 | 2021-09-12 | Bexar | Texas | 48029 | 296585 | 4328 |
1708790 | 1708790 | 2021-09-11 | Bexar | Texas | 48029 | 296585 | 4316 |
1705543 | 1705543 | 2021-09-10 | Bexar | Texas | 48029 | 296585 | 4277 |
1702293 | 1702293 | 2021-09-09 | Bexar | Texas | 48029 | 295965 | 4254 |
1699044 | 1699044 | 2021-09-08 | Bexar | Texas | 48029 | 294000 | 4209 |
1695796 | 1695796 | 2021-09-07 | Bexar | Texas | 48029 | 288389 | 4189 |
1692548 | 1692548 | 2021-09-06 | Bexar | Texas | 48029 | 288389 | 4173 |
1689299 | 1689299 | 2021-09-05 | Bexar | Texas | 48029 | 288389 | 4165 |
1686049 | 1686049 | 2021-09-04 | Bexar | Texas | 48029 | 288389 | 4142 |
1682798 | 1682798 | 2021-09-03 | Bexar | Texas | 48029 | 288389 | 4111 |
1679548 | 1679548 | 2021-09-02 | Bexar | Texas | 48029 | 287423 | 4082 |
1676300 | 1676300 | 2021-09-01 | Bexar | Texas | 48029 | 285742 | 4045 |
1673053 | 1673053 | 2021-08-31 | Bexar | Texas | 48029 | 283785 | 4024 |
1669805 | 1669805 | 2021-08-30 | Bexar | Texas | 48029 | 282921 | 4002 |
1666558 | 1666558 | 2021-08-29 | Bexar | Texas | 48029 | 279378 | 4000 |
1663310 | 1663310 | 2021-08-28 | Bexar | Texas | 48029 | 279378 | 3984 |
1660062 | 1660062 | 2021-08-27 | Bexar | Texas | 48029 | 279378 | 3964 |
1656813 | 1656813 | 2021-08-26 | Bexar | Texas | 48029 | 277788 | 3926 |
1653566 | 1653566 | 2021-08-25 | Bexar | Texas | 48029 | 276447 | 3900 |
1650319 | 1650319 | 2021-08-24 | Bexar | Texas | 48029 | 275179 | 3883 |
1647070 | 1647070 | 2021-08-23 | Bexar | Texas | 48029 | 273925 | 3867 |
1643821 | 1643821 | 2021-08-22 | Bexar | Texas | 48029 | 270223 | 3864 |
1640571 | 1640571 | 2021-08-21 | Bexar | Texas | 48029 | 270223 | 3859 |
1637321 | 1637321 | 2021-08-20 | Bexar | Texas | 48029 | 270223 | 3834 |
1634071 | 1634071 | 2021-08-19 | Bexar | Texas | 48029 | 268982 | 3814 |
1630824 | 1630824 | 2021-08-18 | Bexar | Texas | 48029 | 267642 | 3796 |
1627577 | 1627577 | 2021-08-17 | Bexar | Texas | 48029 | 266039 | 3779 |
1624330 | 1624330 | 2021-08-16 | Bexar | Texas | 48029 | 264250 | 3770 |
1621083 | 1621083 | 2021-08-15 | Bexar | Texas | 48029 | 259648 | 3770 |
1617835 | 1617835 | 2021-08-14 | Bexar | Texas | 48029 | 259648 | 3766 |
1614587 | 1614587 | 2021-08-13 | Bexar | Texas | 48029 | 259648 | 3754 |
1611338 | 1611338 | 2021-08-12 | Bexar | Texas | 48029 | 257806 | 3739 |
1608090 | 1608090 | 2021-08-11 | Bexar | Texas | 48029 | 256594 | 3728 |
1604841 | 1604841 | 2021-08-10 | Bexar | Texas | 48029 | 254645 | 3718 |
1601592 | 1601592 | 2021-08-09 | Bexar | Texas | 48029 | 252731 | 3710 |
1598344 | 1598344 | 2021-08-08 | Bexar | Texas | 48029 | 249550 | 3710 |
1595095 | 1595095 | 2021-08-07 | Bexar | Texas | 48029 | 249550 | 3707 |
1591846 | 1591846 | 2021-08-06 | Bexar | Texas | 48029 | 249550 | 3700 |
1588597 | 1588597 | 2021-08-05 | Bexar | Texas | 48029 | 248196 | 3695 |
1585347 | 1585347 | 2021-08-04 | Bexar | Texas | 48029 | 244814 | 3689 |
1582097 | 1582097 | 2021-08-03 | Bexar | Texas | 48029 | 244814 | 3684 |
1578848 | 1578848 | 2021-08-02 | Bexar | Texas | 48029 | 239062 | 3681 |
1575600 | 1575600 | 2021-08-01 | Bexar | Texas | 48029 | 239062 | 3681 |
1572352 | 1572352 | 2021-07-31 | Bexar | Texas | 48029 | 239062 | 3680 |
1569104 | 1569104 | 2021-07-30 | Bexar | Texas | 48029 | 239062 | 3679 |
1565856 | 1565856 | 2021-07-29 | Bexar | Texas | 48029 | 239062 | 3677 |
1562608 | 1562608 | 2021-07-28 | Bexar | Texas | 48029 | 236694 | 3676 |
1559360 | 1559360 | 2021-07-27 | Bexar | Texas | 48029 | 236694 | 3674 |
1556113 | 1556113 | 2021-07-26 | Bexar | Texas | 48029 | 233179 | 3670 |
1552866 | 1552866 | 2021-07-25 | Bexar | Texas | 48029 | 233179 | 3670 |
1549619 | 1549619 | 2021-07-24 | Bexar | Texas | 48029 | 233179 | 3667 |
1546372 | 1546372 | 2021-07-23 | Bexar | Texas | 48029 | 233179 | 3667 |
1543125 | 1543125 | 2021-07-22 | Bexar | Texas | 48029 | 233179 | 3659 |
1539877 | 1539877 | 2021-07-21 | Bexar | Texas | 48029 | 233179 | 3658 |
1536630 | 1536630 | 2021-07-20 | Bexar | Texas | 48029 | 230635 | 3655 |
1533382 | 1533382 | 2021-07-19 | Bexar | Texas | 48029 | 230635 | 3654 |
1530135 | 1530135 | 2021-07-18 | Bexar | Texas | 48029 | 230635 | 3654 |
1526888 | 1526888 | 2021-07-17 | Bexar | Texas | 48029 | 230635 | 3652 |
1523641 | 1523641 | 2021-07-16 | Bexar | Texas | 48029 | 230635 | 3650 |
1520393 | 1520393 | 2021-07-15 | Bexar | Texas | 48029 | 230635 | 3648 |
1517145 | 1517145 | 2021-07-14 | Bexar | Texas | 48029 | 230635 | 3643 |
1513898 | 1513898 | 2021-07-13 | Bexar | Texas | 48029 | 228650 | 3642 |
1510652 | 1510652 | 2021-07-12 | Bexar | Texas | 48029 | 228650 | 3639 |
1507405 | 1507405 | 2021-07-11 | Bexar | Texas | 48029 | 228650 | 3638 |
1504159 | 1504159 | 2021-07-10 | Bexar | Texas | 48029 | 228650 | 3639 |
1500913 | 1500913 | 2021-07-09 | Bexar | Texas | 48029 | 228650 | 3640 |
1497667 | 1497667 | 2021-07-08 | Bexar | Texas | 48029 | 228650 | 3637 |
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 |
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);