ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where county = "Crawford" and deaths = 17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
county 1
- Crawford · 254 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1967366 | 1967366 | 2021-11-30 | Crawford | Michigan | 26039 | 1734 | 17 |
1964114 | 1964114 | 2021-11-29 | Crawford | Michigan | 26039 | 1734 | 17 |
1960863 | 1960863 | 2021-11-28 | Crawford | Michigan | 26039 | 1684 | 17 |
1957612 | 1957612 | 2021-11-27 | Crawford | Michigan | 26039 | 1684 | 17 |
1954361 | 1954361 | 2021-11-26 | Crawford | Michigan | 26039 | 1684 | 17 |
1951110 | 1951110 | 2021-11-25 | Crawford | Michigan | 26039 | 1684 | 17 |
1947859 | 1947859 | 2021-11-24 | Crawford | Michigan | 26039 | 1684 | 17 |
1944608 | 1944608 | 2021-11-23 | Crawford | Michigan | 26039 | 1636 | 17 |
1941357 | 1941357 | 2021-11-22 | Crawford | Michigan | 26039 | 1636 | 17 |
1938107 | 1938107 | 2021-11-21 | Crawford | Michigan | 26039 | 1620 | 17 |
1934857 | 1934857 | 2021-11-20 | Crawford | Michigan | 26039 | 1620 | 17 |
1931607 | 1931607 | 2021-11-19 | Crawford | Michigan | 26039 | 1620 | 17 |
1928356 | 1928356 | 2021-11-18 | Crawford | Michigan | 26039 | 1574 | 17 |
1925106 | 1925106 | 2021-11-17 | Crawford | Michigan | 26039 | 1574 | 17 |
1921857 | 1921857 | 2021-11-16 | Crawford | Michigan | 26039 | 1547 | 17 |
1918607 | 1918607 | 2021-11-15 | Crawford | Michigan | 26039 | 1547 | 17 |
1915357 | 1915357 | 2021-11-14 | Crawford | Michigan | 26039 | 1507 | 17 |
1912107 | 1912107 | 2021-11-13 | Crawford | Michigan | 26039 | 1507 | 17 |
1908857 | 1908857 | 2021-11-12 | Crawford | Michigan | 26039 | 1507 | 17 |
1905608 | 1905608 | 2021-11-11 | Crawford | Michigan | 26039 | 1481 | 17 |
1902359 | 1902359 | 2021-11-10 | Crawford | Michigan | 26039 | 1481 | 17 |
1899109 | 1899109 | 2021-11-09 | Crawford | Michigan | 26039 | 1468 | 17 |
1895859 | 1895859 | 2021-11-08 | Crawford | Michigan | 26039 | 1468 | 17 |
1892609 | 1892609 | 2021-11-07 | Crawford | Michigan | 26039 | 1457 | 17 |
1889359 | 1889359 | 2021-11-06 | Crawford | Michigan | 26039 | 1457 | 17 |
1886109 | 1886109 | 2021-11-05 | Crawford | Michigan | 26039 | 1457 | 17 |
1882860 | 1882860 | 2021-11-04 | Crawford | Michigan | 26039 | 1431 | 17 |
1879611 | 1879611 | 2021-11-03 | Crawford | Michigan | 26039 | 1431 | 17 |
1876362 | 1876362 | 2021-11-02 | Crawford | Michigan | 26039 | 1398 | 17 |
1873113 | 1873113 | 2021-11-01 | Crawford | Michigan | 26039 | 1398 | 17 |
1869864 | 1869864 | 2021-10-31 | Crawford | Michigan | 26039 | 1377 | 17 |
1866615 | 1866615 | 2021-10-30 | Crawford | Michigan | 26039 | 1377 | 17 |
1863366 | 1863366 | 2021-10-29 | Crawford | Michigan | 26039 | 1377 | 17 |
1580174 | 1580174 | 2021-08-03 | Crawford | Indiana | 18025 | 1068 | 17 |
1576925 | 1576925 | 2021-08-02 | Crawford | Indiana | 18025 | 1066 | 17 |
1573677 | 1573677 | 2021-08-01 | Crawford | Indiana | 18025 | 1064 | 17 |
1570429 | 1570429 | 2021-07-31 | Crawford | Indiana | 18025 | 1064 | 17 |
1567181 | 1567181 | 2021-07-30 | Crawford | Indiana | 18025 | 1064 | 17 |
1563933 | 1563933 | 2021-07-29 | Crawford | Indiana | 18025 | 1063 | 17 |
1560685 | 1560685 | 2021-07-28 | Crawford | Indiana | 18025 | 1059 | 17 |
1557438 | 1557438 | 2021-07-27 | Crawford | Indiana | 18025 | 1057 | 17 |
1554191 | 1554191 | 2021-07-26 | Crawford | Indiana | 18025 | 1056 | 17 |
1550944 | 1550944 | 2021-07-25 | Crawford | Indiana | 18025 | 1052 | 17 |
1547697 | 1547697 | 2021-07-24 | Crawford | Indiana | 18025 | 1052 | 17 |
1544450 | 1544450 | 2021-07-23 | Crawford | Indiana | 18025 | 1052 | 17 |
1541202 | 1541202 | 2021-07-22 | Crawford | Indiana | 18025 | 1049 | 17 |
1537955 | 1537955 | 2021-07-21 | Crawford | Indiana | 18025 | 1045 | 17 |
1534707 | 1534707 | 2021-07-20 | Crawford | Indiana | 18025 | 1044 | 17 |
1531460 | 1531460 | 2021-07-19 | Crawford | Indiana | 18025 | 1039 | 17 |
1528213 | 1528213 | 2021-07-18 | Crawford | Indiana | 18025 | 1039 | 17 |
1524966 | 1524966 | 2021-07-17 | Crawford | Indiana | 18025 | 1039 | 17 |
1521718 | 1521718 | 2021-07-16 | Crawford | Indiana | 18025 | 1039 | 17 |
1518470 | 1518470 | 2021-07-15 | Crawford | Indiana | 18025 | 1037 | 17 |
1515223 | 1515223 | 2021-07-14 | Crawford | Indiana | 18025 | 1035 | 17 |
1511977 | 1511977 | 2021-07-13 | Crawford | Indiana | 18025 | 1030 | 17 |
1508730 | 1508730 | 2021-07-12 | Crawford | Indiana | 18025 | 1029 | 17 |
1505484 | 1505484 | 2021-07-11 | Crawford | Indiana | 18025 | 1027 | 17 |
1502238 | 1502238 | 2021-07-10 | Crawford | Indiana | 18025 | 1027 | 17 |
1498992 | 1498992 | 2021-07-09 | Crawford | Indiana | 18025 | 1027 | 17 |
1495745 | 1495745 | 2021-07-08 | Crawford | Indiana | 18025 | 1026 | 17 |
1492499 | 1492499 | 2021-07-07 | Crawford | Indiana | 18025 | 1026 | 17 |
1489252 | 1489252 | 2021-07-06 | Crawford | Indiana | 18025 | 1026 | 17 |
1486005 | 1486005 | 2021-07-05 | Crawford | Indiana | 18025 | 1026 | 17 |
1482759 | 1482759 | 2021-07-04 | Crawford | Indiana | 18025 | 1026 | 17 |
1479512 | 1479512 | 2021-07-03 | Crawford | Indiana | 18025 | 1026 | 17 |
1476266 | 1476266 | 2021-07-02 | Crawford | Indiana | 18025 | 1026 | 17 |
1473020 | 1473020 | 2021-07-01 | Crawford | Indiana | 18025 | 1026 | 17 |
1469774 | 1469774 | 2021-06-30 | Crawford | Indiana | 18025 | 1026 | 17 |
1466529 | 1466529 | 2021-06-29 | Crawford | Indiana | 18025 | 1026 | 17 |
1463284 | 1463284 | 2021-06-28 | Crawford | Indiana | 18025 | 1026 | 17 |
1460039 | 1460039 | 2021-06-27 | Crawford | Indiana | 18025 | 1026 | 17 |
1456794 | 1456794 | 2021-06-26 | Crawford | Indiana | 18025 | 1026 | 17 |
1453549 | 1453549 | 2021-06-25 | Crawford | Indiana | 18025 | 1026 | 17 |
1450303 | 1450303 | 2021-06-24 | Crawford | Indiana | 18025 | 1026 | 17 |
1447058 | 1447058 | 2021-06-23 | Crawford | Indiana | 18025 | 1026 | 17 |
1443813 | 1443813 | 2021-06-22 | Crawford | Indiana | 18025 | 1026 | 17 |
1440568 | 1440568 | 2021-06-21 | Crawford | Indiana | 18025 | 1026 | 17 |
1437321 | 1437321 | 2021-06-20 | Crawford | Indiana | 18025 | 1026 | 17 |
1434074 | 1434074 | 2021-06-19 | Crawford | Indiana | 18025 | 1026 | 17 |
1430828 | 1430828 | 2021-06-18 | Crawford | Indiana | 18025 | 1025 | 17 |
1427583 | 1427583 | 2021-06-17 | Crawford | Indiana | 18025 | 1024 | 17 |
1424338 | 1424338 | 2021-06-16 | Crawford | Indiana | 18025 | 1024 | 17 |
1421090 | 1421090 | 2021-06-15 | Crawford | Indiana | 18025 | 1024 | 17 |
1417845 | 1417845 | 2021-06-14 | Crawford | Indiana | 18025 | 1024 | 17 |
1414599 | 1414599 | 2021-06-13 | Crawford | Indiana | 18025 | 1024 | 17 |
1411354 | 1411354 | 2021-06-12 | Crawford | Indiana | 18025 | 1024 | 17 |
1408109 | 1408109 | 2021-06-11 | Crawford | Indiana | 18025 | 1024 | 17 |
1404863 | 1404863 | 2021-06-10 | Crawford | Indiana | 18025 | 1024 | 17 |
1401618 | 1401618 | 2021-06-09 | Crawford | Indiana | 18025 | 1023 | 17 |
1398373 | 1398373 | 2021-06-08 | Crawford | Indiana | 18025 | 1023 | 17 |
1395126 | 1395126 | 2021-06-07 | Crawford | Indiana | 18025 | 1023 | 17 |
1391881 | 1391881 | 2021-06-06 | Crawford | Indiana | 18025 | 1023 | 17 |
1388636 | 1388636 | 2021-06-05 | Crawford | Indiana | 18025 | 1023 | 17 |
1385391 | 1385391 | 2021-06-04 | Crawford | Indiana | 18025 | 1023 | 17 |
1382145 | 1382145 | 2021-06-03 | Crawford | Indiana | 18025 | 1022 | 17 |
1378900 | 1378900 | 2021-06-02 | Crawford | Indiana | 18025 | 1022 | 17 |
1375654 | 1375654 | 2021-06-01 | Crawford | Indiana | 18025 | 1022 | 17 |
1372409 | 1372409 | 2021-05-31 | Crawford | Indiana | 18025 | 1021 | 17 |
1369164 | 1369164 | 2021-05-30 | Crawford | Indiana | 18025 | 1021 | 17 |
1365918 | 1365918 | 2021-05-29 | Crawford | Indiana | 18025 | 1019 | 17 |
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);