ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Yuma" and state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716002 | 1716002 | 2021-09-14 | Yuma | Arizona | 4027 | 40065 | 877 |
1712756 | 1712756 | 2021-09-13 | Yuma | Arizona | 4027 | 40039 | 871 |
1709509 | 1709509 | 2021-09-12 | Yuma | Arizona | 4027 | 39998 | 871 |
1706262 | 1706262 | 2021-09-11 | Yuma | Arizona | 4027 | 39933 | 871 |
1703014 | 1703014 | 2021-09-10 | Yuma | Arizona | 4027 | 39861 | 870 |
1699764 | 1699764 | 2021-09-09 | Yuma | Arizona | 4027 | 39791 | 870 |
1696515 | 1696515 | 2021-09-08 | Yuma | Arizona | 4027 | 39770 | 870 |
1693267 | 1693267 | 2021-09-07 | Yuma | Arizona | 4027 | 39746 | 870 |
1690018 | 1690018 | 2021-09-06 | Yuma | Arizona | 4027 | 39709 | 867 |
1686768 | 1686768 | 2021-09-05 | Yuma | Arizona | 4027 | 39674 | 867 |
1683518 | 1683518 | 2021-09-04 | Yuma | Arizona | 4027 | 39615 | 867 |
1680267 | 1680267 | 2021-09-03 | Yuma | Arizona | 4027 | 39531 | 866 |
1677019 | 1677019 | 2021-09-02 | Yuma | Arizona | 4027 | 39479 | 864 |
1673772 | 1673772 | 2021-09-01 | Yuma | Arizona | 4027 | 39405 | 862 |
1670524 | 1670524 | 2021-08-31 | Yuma | Arizona | 4027 | 39329 | 858 |
1667277 | 1667277 | 2021-08-30 | Yuma | Arizona | 4027 | 39327 | 860 |
1664030 | 1664030 | 2021-08-29 | Yuma | Arizona | 4027 | 39258 | 860 |
1660782 | 1660782 | 2021-08-28 | Yuma | Arizona | 4027 | 39219 | 859 |
1657534 | 1657534 | 2021-08-27 | Yuma | Arizona | 4027 | 38868 | 857 |
1654286 | 1654286 | 2021-08-26 | Yuma | Arizona | 4027 | 38802 | 857 |
1651039 | 1651039 | 2021-08-25 | Yuma | Arizona | 4027 | 38708 | 857 |
1647790 | 1647790 | 2021-08-24 | Yuma | Arizona | 4027 | 38708 | 857 |
1644542 | 1644542 | 2021-08-23 | Yuma | Arizona | 4027 | 38689 | 857 |
1641292 | 1641292 | 2021-08-22 | Yuma | Arizona | 4027 | 38619 | 857 |
1638042 | 1638042 | 2021-08-21 | Yuma | Arizona | 4027 | 38555 | 857 |
1634792 | 1634792 | 2021-08-20 | Yuma | Arizona | 4027 | 38508 | 857 |
1631543 | 1631543 | 2021-08-19 | Yuma | Arizona | 4027 | 38403 | 856 |
1628296 | 1628296 | 2021-08-18 | Yuma | Arizona | 4027 | 38340 | 856 |
1625049 | 1625049 | 2021-08-17 | Yuma | Arizona | 4027 | 38308 | 855 |
1621802 | 1621802 | 2021-08-16 | Yuma | Arizona | 4027 | 38292 | 855 |
1618555 | 1618555 | 2021-08-15 | Yuma | Arizona | 4027 | 38266 | 855 |
1615307 | 1615307 | 2021-08-14 | Yuma | Arizona | 4027 | 38203 | 855 |
1612058 | 1612058 | 2021-08-13 | Yuma | Arizona | 4027 | 38138 | 854 |
1608810 | 1608810 | 2021-08-12 | Yuma | Arizona | 4027 | 38038 | 853 |
1605561 | 1605561 | 2021-08-11 | Yuma | Arizona | 4027 | 37960 | 853 |
1602312 | 1602312 | 2021-08-10 | Yuma | Arizona | 4027 | 37944 | 853 |
1599063 | 1599063 | 2021-08-09 | Yuma | Arizona | 4027 | 37922 | 853 |
1595814 | 1595814 | 2021-08-08 | Yuma | Arizona | 4027 | 37873 | 853 |
1592565 | 1592565 | 2021-08-07 | Yuma | Arizona | 4027 | 37826 | 853 |
1589316 | 1589316 | 2021-08-06 | Yuma | Arizona | 4027 | 37744 | 853 |
1586067 | 1586067 | 2021-08-05 | Yuma | Arizona | 4027 | 37689 | 853 |
1582817 | 1582817 | 2021-08-04 | Yuma | Arizona | 4027 | 37668 | 853 |
1579567 | 1579567 | 2021-08-03 | Yuma | Arizona | 4027 | 37644 | 853 |
1576319 | 1576319 | 2021-08-02 | Yuma | Arizona | 4027 | 37640 | 852 |
1573071 | 1573071 | 2021-08-01 | Yuma | Arizona | 4027 | 37634 | 852 |
1569823 | 1569823 | 2021-07-31 | Yuma | Arizona | 4027 | 37605 | 852 |
1566575 | 1566575 | 2021-07-30 | Yuma | Arizona | 4027 | 37533 | 852 |
1563327 | 1563327 | 2021-07-29 | Yuma | Arizona | 4027 | 37509 | 852 |
1560079 | 1560079 | 2021-07-28 | Yuma | Arizona | 4027 | 37482 | 852 |
1556832 | 1556832 | 2021-07-27 | Yuma | Arizona | 4027 | 37478 | 852 |
1553585 | 1553585 | 2021-07-26 | Yuma | Arizona | 4027 | 37468 | 852 |
1550338 | 1550338 | 2021-07-25 | Yuma | Arizona | 4027 | 37453 | 852 |
1547091 | 1547091 | 2021-07-24 | Yuma | Arizona | 4027 | 37440 | 852 |
1543844 | 1543844 | 2021-07-23 | Yuma | Arizona | 4027 | 37426 | 850 |
1540596 | 1540596 | 2021-07-22 | Yuma | Arizona | 4027 | 37410 | 850 |
1537349 | 1537349 | 2021-07-21 | Yuma | Arizona | 4027 | 37427 | 851 |
1534101 | 1534101 | 2021-07-20 | Yuma | Arizona | 4027 | 37446 | 853 |
1530854 | 1530854 | 2021-07-19 | Yuma | Arizona | 4027 | 37432 | 851 |
1527607 | 1527607 | 2021-07-18 | Yuma | Arizona | 4027 | 37412 | 851 |
1524360 | 1524360 | 2021-07-17 | Yuma | Arizona | 4027 | 37442 | 849 |
1521112 | 1521112 | 2021-07-16 | Yuma | Arizona | 4027 | 37426 | 849 |
1517864 | 1517864 | 2021-07-15 | Yuma | Arizona | 4027 | 37406 | 849 |
1514617 | 1514617 | 2021-07-14 | Yuma | Arizona | 4027 | 37404 | 849 |
1511371 | 1511371 | 2021-07-13 | Yuma | Arizona | 4027 | 37378 | 849 |
1508124 | 1508124 | 2021-07-12 | Yuma | Arizona | 4027 | 37378 | 849 |
1504878 | 1504878 | 2021-07-11 | Yuma | Arizona | 4027 | 37377 | 849 |
1501632 | 1501632 | 2021-07-10 | Yuma | Arizona | 4027 | 37374 | 849 |
1498386 | 1498386 | 2021-07-09 | Yuma | Arizona | 4027 | 37364 | 849 |
1495139 | 1495139 | 2021-07-08 | Yuma | Arizona | 4027 | 37360 | 849 |
1491892 | 1491892 | 2021-07-07 | Yuma | Arizona | 4027 | 37355 | 849 |
1488645 | 1488645 | 2021-07-06 | Yuma | Arizona | 4027 | 37353 | 849 |
1485398 | 1485398 | 2021-07-05 | Yuma | Arizona | 4027 | 37347 | 848 |
1482152 | 1482152 | 2021-07-04 | Yuma | Arizona | 4027 | 37346 | 848 |
1478905 | 1478905 | 2021-07-03 | Yuma | Arizona | 4027 | 37345 | 848 |
1475659 | 1475659 | 2021-07-02 | Yuma | Arizona | 4027 | 37334 | 848 |
1472413 | 1472413 | 2021-07-01 | Yuma | Arizona | 4027 | 37326 | 848 |
1469168 | 1469168 | 2021-06-30 | Yuma | Arizona | 4027 | 37319 | 848 |
1465923 | 1465923 | 2021-06-29 | Yuma | Arizona | 4027 | 37312 | 848 |
1462678 | 1462678 | 2021-06-28 | Yuma | Arizona | 4027 | 37307 | 848 |
1459433 | 1459433 | 2021-06-27 | Yuma | Arizona | 4027 | 37307 | 848 |
1456188 | 1456188 | 2021-06-26 | Yuma | Arizona | 4027 | 37308 | 848 |
1452943 | 1452943 | 2021-06-25 | Yuma | Arizona | 4027 | 37305 | 848 |
1449697 | 1449697 | 2021-06-24 | Yuma | Arizona | 4027 | 37297 | 848 |
1446452 | 1446452 | 2021-06-23 | Yuma | Arizona | 4027 | 37294 | 848 |
1443207 | 1443207 | 2021-06-22 | Yuma | Arizona | 4027 | 37290 | 847 |
1439962 | 1439962 | 2021-06-21 | Yuma | Arizona | 4027 | 37287 | 847 |
1436715 | 1436715 | 2021-06-20 | Yuma | Arizona | 4027 | 37284 | 847 |
1433468 | 1433468 | 2021-06-19 | Yuma | Arizona | 4027 | 37284 | 847 |
1430222 | 1430222 | 2021-06-18 | Yuma | Arizona | 4027 | 37283 | 846 |
1426977 | 1426977 | 2021-06-17 | Yuma | Arizona | 4027 | 37283 | 845 |
1423732 | 1423732 | 2021-06-16 | Yuma | Arizona | 4027 | 37282 | 845 |
1420484 | 1420484 | 2021-06-15 | Yuma | Arizona | 4027 | 37280 | 845 |
1417239 | 1417239 | 2021-06-14 | Yuma | Arizona | 4027 | 37278 | 845 |
1413993 | 1413993 | 2021-06-13 | Yuma | Arizona | 4027 | 37275 | 845 |
1410748 | 1410748 | 2021-06-12 | Yuma | Arizona | 4027 | 37274 | 845 |
1407503 | 1407503 | 2021-06-11 | Yuma | Arizona | 4027 | 37272 | 846 |
1404257 | 1404257 | 2021-06-10 | Yuma | Arizona | 4027 | 37272 | 845 |
1401012 | 1401012 | 2021-06-09 | Yuma | Arizona | 4027 | 37266 | 843 |
1397767 | 1397767 | 2021-06-08 | Yuma | Arizona | 4027 | 37263 | 843 |
1394520 | 1394520 | 2021-06-07 | Yuma | Arizona | 4027 | 37257 | 843 |
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);