ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
172 rows where county = "St. Clair", deaths = 8 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1659021 | 1659021 | 2021-08-27 | St. Clair | Missouri | 29185 | 1088 | 8 |
1655772 | 1655772 | 2021-08-26 | St. Clair | Missouri | 29185 | 1085 | 8 |
1652525 | 1652525 | 2021-08-25 | St. Clair | Missouri | 29185 | 1084 | 8 |
1649277 | 1649277 | 2021-08-24 | St. Clair | Missouri | 29185 | 1080 | 8 |
1646028 | 1646028 | 2021-08-23 | St. Clair | Missouri | 29185 | 1076 | 8 |
1642779 | 1642779 | 2021-08-22 | St. Clair | Missouri | 29185 | 1076 | 8 |
1639529 | 1639529 | 2021-08-21 | St. Clair | Missouri | 29185 | 1076 | 8 |
1636279 | 1636279 | 2021-08-20 | St. Clair | Missouri | 29185 | 1072 | 8 |
1633029 | 1633029 | 2021-08-19 | St. Clair | Missouri | 29185 | 1069 | 8 |
1629782 | 1629782 | 2021-08-18 | St. Clair | Missouri | 29185 | 1065 | 8 |
1626535 | 1626535 | 2021-08-17 | St. Clair | Missouri | 29185 | 1059 | 8 |
1623288 | 1623288 | 2021-08-16 | St. Clair | Missouri | 29185 | 1051 | 8 |
1620041 | 1620041 | 2021-08-15 | St. Clair | Missouri | 29185 | 1050 | 8 |
1616793 | 1616793 | 2021-08-14 | St. Clair | Missouri | 29185 | 1047 | 8 |
1613545 | 1613545 | 2021-08-13 | St. Clair | Missouri | 29185 | 1035 | 8 |
1610296 | 1610296 | 2021-08-12 | St. Clair | Missouri | 29185 | 1030 | 8 |
1607048 | 1607048 | 2021-08-11 | St. Clair | Missouri | 29185 | 1023 | 8 |
1603799 | 1603799 | 2021-08-10 | St. Clair | Missouri | 29185 | 1016 | 8 |
1600550 | 1600550 | 2021-08-09 | St. Clair | Missouri | 29185 | 1012 | 8 |
1597302 | 1597302 | 2021-08-08 | St. Clair | Missouri | 29185 | 1009 | 8 |
1594053 | 1594053 | 2021-08-07 | St. Clair | Missouri | 29185 | 1003 | 8 |
1590804 | 1590804 | 2021-08-06 | St. Clair | Missouri | 29185 | 997 | 8 |
1587555 | 1587555 | 2021-08-05 | St. Clair | Missouri | 29185 | 985 | 8 |
1584304 | 1584304 | 2021-08-04 | St. Clair | Missouri | 29185 | 965 | 8 |
1581055 | 1581055 | 2021-08-03 | St. Clair | Missouri | 29185 | 961 | 8 |
1577806 | 1577806 | 2021-08-02 | St. Clair | Missouri | 29185 | 955 | 8 |
1574558 | 1574558 | 2021-08-01 | St. Clair | Missouri | 29185 | 954 | 8 |
1571310 | 1571310 | 2021-07-31 | St. Clair | Missouri | 29185 | 951 | 8 |
1568062 | 1568062 | 2021-07-30 | St. Clair | Missouri | 29185 | 941 | 8 |
1564814 | 1564814 | 2021-07-29 | St. Clair | Missouri | 29185 | 940 | 8 |
1561566 | 1561566 | 2021-07-28 | St. Clair | Missouri | 29185 | 929 | 8 |
1558318 | 1558318 | 2021-07-27 | St. Clair | Missouri | 29185 | 924 | 8 |
1555071 | 1555071 | 2021-07-26 | St. Clair | Missouri | 29185 | 914 | 8 |
1551824 | 1551824 | 2021-07-25 | St. Clair | Missouri | 29185 | 913 | 8 |
1548577 | 1548577 | 2021-07-24 | St. Clair | Missouri | 29185 | 910 | 8 |
1545330 | 1545330 | 2021-07-23 | St. Clair | Missouri | 29185 | 900 | 8 |
1542082 | 1542082 | 2021-07-22 | St. Clair | Missouri | 29185 | 892 | 8 |
1538835 | 1538835 | 2021-07-21 | St. Clair | Missouri | 29185 | 885 | 8 |
1535588 | 1535588 | 2021-07-20 | St. Clair | Missouri | 29185 | 876 | 8 |
1532340 | 1532340 | 2021-07-19 | St. Clair | Missouri | 29185 | 862 | 8 |
1529093 | 1529093 | 2021-07-18 | St. Clair | Missouri | 29185 | 861 | 8 |
1525846 | 1525846 | 2021-07-17 | St. Clair | Missouri | 29185 | 861 | 8 |
1522599 | 1522599 | 2021-07-16 | St. Clair | Missouri | 29185 | 855 | 8 |
1519350 | 1519350 | 2021-07-15 | St. Clair | Missouri | 29185 | 848 | 8 |
1516103 | 1516103 | 2021-07-14 | St. Clair | Missouri | 29185 | 844 | 8 |
1512857 | 1512857 | 2021-07-13 | St. Clair | Missouri | 29185 | 837 | 8 |
1509610 | 1509610 | 2021-07-12 | St. Clair | Missouri | 29185 | 833 | 8 |
1506364 | 1506364 | 2021-07-11 | St. Clair | Missouri | 29185 | 833 | 8 |
1503118 | 1503118 | 2021-07-10 | St. Clair | Missouri | 29185 | 831 | 8 |
1499872 | 1499872 | 2021-07-09 | St. Clair | Missouri | 29185 | 829 | 8 |
1496626 | 1496626 | 2021-07-08 | St. Clair | Missouri | 29185 | 827 | 8 |
1493379 | 1493379 | 2021-07-07 | St. Clair | Missouri | 29185 | 823 | 8 |
1490132 | 1490132 | 2021-07-06 | St. Clair | Missouri | 29185 | 823 | 8 |
1486885 | 1486885 | 2021-07-05 | St. Clair | Missouri | 29185 | 820 | 8 |
1483639 | 1483639 | 2021-07-04 | St. Clair | Missouri | 29185 | 819 | 8 |
1480393 | 1480393 | 2021-07-03 | St. Clair | Missouri | 29185 | 816 | 8 |
1477146 | 1477146 | 2021-07-02 | St. Clair | Missouri | 29185 | 816 | 8 |
1473900 | 1473900 | 2021-07-01 | St. Clair | Missouri | 29185 | 815 | 8 |
1470654 | 1470654 | 2021-06-30 | St. Clair | Missouri | 29185 | 811 | 8 |
1467409 | 1467409 | 2021-06-29 | St. Clair | Missouri | 29185 | 810 | 8 |
1464164 | 1464164 | 2021-06-28 | St. Clair | Missouri | 29185 | 809 | 8 |
1460919 | 1460919 | 2021-06-27 | St. Clair | Missouri | 29185 | 809 | 8 |
1457674 | 1457674 | 2021-06-26 | St. Clair | Missouri | 29185 | 809 | 8 |
1454429 | 1454429 | 2021-06-25 | St. Clair | Missouri | 29185 | 808 | 8 |
1451184 | 1451184 | 2021-06-24 | St. Clair | Missouri | 29185 | 807 | 8 |
1447938 | 1447938 | 2021-06-23 | St. Clair | Missouri | 29185 | 804 | 8 |
1444693 | 1444693 | 2021-06-22 | St. Clair | Missouri | 29185 | 804 | 8 |
1441448 | 1441448 | 2021-06-21 | St. Clair | Missouri | 29185 | 804 | 8 |
1438202 | 1438202 | 2021-06-20 | St. Clair | Missouri | 29185 | 804 | 8 |
1434955 | 1434955 | 2021-06-19 | St. Clair | Missouri | 29185 | 804 | 8 |
1431708 | 1431708 | 2021-06-18 | St. Clair | Missouri | 29185 | 804 | 8 |
1428463 | 1428463 | 2021-06-17 | St. Clair | Missouri | 29185 | 803 | 8 |
1425218 | 1425218 | 2021-06-16 | St. Clair | Missouri | 29185 | 801 | 8 |
1421970 | 1421970 | 2021-06-15 | St. Clair | Missouri | 29185 | 799 | 8 |
1418725 | 1418725 | 2021-06-14 | St. Clair | Missouri | 29185 | 799 | 8 |
1415480 | 1415480 | 2021-06-13 | St. Clair | Missouri | 29185 | 799 | 8 |
1412234 | 1412234 | 2021-06-12 | St. Clair | Missouri | 29185 | 798 | 8 |
1408989 | 1408989 | 2021-06-11 | St. Clair | Missouri | 29185 | 798 | 8 |
1405744 | 1405744 | 2021-06-10 | St. Clair | Missouri | 29185 | 797 | 8 |
1402498 | 1402498 | 2021-06-09 | St. Clair | Missouri | 29185 | 796 | 8 |
1399253 | 1399253 | 2021-06-08 | St. Clair | Missouri | 29185 | 795 | 8 |
1396007 | 1396007 | 2021-06-07 | St. Clair | Missouri | 29185 | 793 | 8 |
1392761 | 1392761 | 2021-06-06 | St. Clair | Missouri | 29185 | 793 | 8 |
1389516 | 1389516 | 2021-06-05 | St. Clair | Missouri | 29185 | 793 | 8 |
1386271 | 1386271 | 2021-06-04 | St. Clair | Missouri | 29185 | 793 | 8 |
1383026 | 1383026 | 2021-06-03 | St. Clair | Missouri | 29185 | 793 | 8 |
1379780 | 1379780 | 2021-06-02 | St. Clair | Missouri | 29185 | 793 | 8 |
1376535 | 1376535 | 2021-06-01 | St. Clair | Missouri | 29185 | 791 | 8 |
1373289 | 1373289 | 2021-05-31 | St. Clair | Missouri | 29185 | 791 | 8 |
1370044 | 1370044 | 2021-05-30 | St. Clair | Missouri | 29185 | 791 | 8 |
1366798 | 1366798 | 2021-05-29 | St. Clair | Missouri | 29185 | 791 | 8 |
1363552 | 1363552 | 2021-05-28 | St. Clair | Missouri | 29185 | 791 | 8 |
1360305 | 1360305 | 2021-05-27 | St. Clair | Missouri | 29185 | 790 | 8 |
1357059 | 1357059 | 2021-05-26 | St. Clair | Missouri | 29185 | 789 | 8 |
1353813 | 1353813 | 2021-05-25 | St. Clair | Missouri | 29185 | 787 | 8 |
1350567 | 1350567 | 2021-05-24 | St. Clair | Missouri | 29185 | 787 | 8 |
1347321 | 1347321 | 2021-05-23 | St. Clair | Missouri | 29185 | 787 | 8 |
1344073 | 1344073 | 2021-05-22 | St. Clair | Missouri | 29185 | 787 | 8 |
1340824 | 1340824 | 2021-05-21 | St. Clair | Missouri | 29185 | 786 | 8 |
1337577 | 1337577 | 2021-05-20 | St. Clair | Missouri | 29185 | 786 | 8 |
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);