ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where county = "Crawford" and deaths = 43 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Crawford · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1921023 | 1921023 | 2021-11-16 | Crawford | Georgia | 13079 | 1156 | 43 |
1917773 | 1917773 | 2021-11-15 | Crawford | Georgia | 13079 | 1152 | 43 |
1914523 | 1914523 | 2021-11-14 | Crawford | Georgia | 13079 | 1150 | 43 |
1911273 | 1911273 | 2021-11-13 | Crawford | Georgia | 13079 | 1150 | 43 |
1908024 | 1908024 | 2021-11-12 | Crawford | Georgia | 13079 | 1150 | 43 |
1904775 | 1904775 | 2021-11-11 | Crawford | Georgia | 13079 | 1143 | 43 |
1901525 | 1901525 | 2021-11-10 | Crawford | Georgia | 13079 | 1143 | 43 |
1898275 | 1898275 | 2021-11-09 | Crawford | Georgia | 13079 | 1140 | 43 |
1895025 | 1895025 | 2021-11-08 | Crawford | Georgia | 13079 | 1138 | 43 |
1891775 | 1891775 | 2021-11-07 | Crawford | Georgia | 13079 | 1137 | 43 |
1888525 | 1888525 | 2021-11-06 | Crawford | Georgia | 13079 | 1137 | 43 |
1885275 | 1885275 | 2021-11-05 | Crawford | Georgia | 13079 | 1137 | 43 |
1882026 | 1882026 | 2021-11-04 | Crawford | Georgia | 13079 | 1137 | 43 |
1878777 | 1878777 | 2021-11-03 | Crawford | Georgia | 13079 | 1137 | 43 |
1875528 | 1875528 | 2021-11-02 | Crawford | Georgia | 13079 | 1136 | 43 |
1872279 | 1872279 | 2021-11-01 | Crawford | Georgia | 13079 | 1136 | 43 |
1869030 | 1869030 | 2021-10-31 | Crawford | Georgia | 13079 | 1134 | 43 |
1865781 | 1865781 | 2021-10-30 | Crawford | Georgia | 13079 | 1134 | 43 |
1862532 | 1862532 | 2021-10-29 | Crawford | Georgia | 13079 | 1134 | 43 |
1859283 | 1859283 | 2021-10-28 | Crawford | Georgia | 13079 | 1132 | 43 |
1856034 | 1856034 | 2021-10-27 | Crawford | Georgia | 13079 | 1131 | 43 |
1852785 | 1852785 | 2021-10-26 | Crawford | Georgia | 13079 | 1131 | 43 |
1849536 | 1849536 | 2021-10-25 | Crawford | Georgia | 13079 | 1131 | 43 |
1716712 | 1716712 | 2021-09-14 | Crawford | Iowa | 19047 | 3152 | 43 |
1713466 | 1713466 | 2021-09-13 | Crawford | Iowa | 19047 | 3152 | 43 |
1710219 | 1710219 | 2021-09-12 | Crawford | Iowa | 19047 | 3152 | 43 |
1706972 | 1706972 | 2021-09-11 | Crawford | Iowa | 19047 | 3152 | 43 |
1703724 | 1703724 | 2021-09-10 | Crawford | Iowa | 19047 | 3152 | 43 |
1700474 | 1700474 | 2021-09-09 | Crawford | Iowa | 19047 | 3152 | 43 |
1697225 | 1697225 | 2021-09-08 | Crawford | Iowa | 19047 | 3152 | 43 |
1693977 | 1693977 | 2021-09-07 | Crawford | Iowa | 19047 | 3077 | 43 |
1690728 | 1690728 | 2021-09-06 | Crawford | Iowa | 19047 | 3077 | 43 |
1687478 | 1687478 | 2021-09-05 | Crawford | Iowa | 19047 | 3077 | 43 |
1684228 | 1684228 | 2021-09-04 | Crawford | Iowa | 19047 | 3077 | 43 |
1680977 | 1680977 | 2021-09-03 | Crawford | Iowa | 19047 | 3077 | 43 |
1677729 | 1677729 | 2021-09-02 | Crawford | Iowa | 19047 | 3077 | 43 |
1674482 | 1674482 | 2021-09-01 | Crawford | Iowa | 19047 | 3077 | 43 |
1671233 | 1671233 | 2021-08-31 | Crawford | Iowa | 19047 | 2978 | 43 |
1667784 | 1667784 | 2021-08-30 | Crawford | Illinois | 17033 | 2722 | 43 |
1667986 | 1667986 | 2021-08-30 | Crawford | Iowa | 19047 | 2978 | 43 |
1668691 | 1668691 | 2021-08-30 | Crawford | Missouri | 29055 | 3183 | 43 |
1664537 | 1664537 | 2021-08-29 | Crawford | Illinois | 17033 | 2696 | 43 |
1664739 | 1664739 | 2021-08-29 | Crawford | Iowa | 19047 | 2978 | 43 |
1665444 | 1665444 | 2021-08-29 | Crawford | Missouri | 29055 | 3174 | 43 |
1661289 | 1661289 | 2021-08-28 | Crawford | Illinois | 17033 | 2696 | 43 |
1661491 | 1661491 | 2021-08-28 | Crawford | Iowa | 19047 | 2978 | 43 |
1662196 | 1662196 | 2021-08-28 | Crawford | Missouri | 29055 | 3171 | 43 |
1658041 | 1658041 | 2021-08-27 | Crawford | Illinois | 17033 | 2696 | 43 |
1658243 | 1658243 | 2021-08-27 | Crawford | Iowa | 19047 | 2978 | 43 |
1658948 | 1658948 | 2021-08-27 | Crawford | Missouri | 29055 | 3163 | 43 |
1654793 | 1654793 | 2021-08-26 | Crawford | Illinois | 17033 | 2687 | 43 |
1654995 | 1654995 | 2021-08-26 | Crawford | Iowa | 19047 | 2978 | 43 |
1655699 | 1655699 | 2021-08-26 | Crawford | Missouri | 29055 | 3148 | 43 |
1651546 | 1651546 | 2021-08-25 | Crawford | Illinois | 17033 | 2680 | 43 |
1651748 | 1651748 | 2021-08-25 | Crawford | Iowa | 19047 | 2978 | 43 |
1652452 | 1652452 | 2021-08-25 | Crawford | Missouri | 29055 | 3136 | 43 |
1648297 | 1648297 | 2021-08-24 | Crawford | Illinois | 17033 | 2640 | 43 |
1648499 | 1648499 | 2021-08-24 | Crawford | Iowa | 19047 | 2887 | 43 |
1649204 | 1649204 | 2021-08-24 | Crawford | Missouri | 29055 | 3119 | 43 |
1645049 | 1645049 | 2021-08-23 | Crawford | Illinois | 17033 | 2631 | 43 |
1645251 | 1645251 | 2021-08-23 | Crawford | Iowa | 19047 | 2887 | 43 |
1641800 | 1641800 | 2021-08-22 | Crawford | Illinois | 17033 | 2593 | 43 |
1642002 | 1642002 | 2021-08-22 | Crawford | Iowa | 19047 | 2887 | 43 |
1638550 | 1638550 | 2021-08-21 | Crawford | Illinois | 17033 | 2593 | 43 |
1638752 | 1638752 | 2021-08-21 | Crawford | Iowa | 19047 | 2887 | 43 |
1635300 | 1635300 | 2021-08-20 | Crawford | Illinois | 17033 | 2593 | 43 |
1635502 | 1635502 | 2021-08-20 | Crawford | Iowa | 19047 | 2887 | 43 |
1632050 | 1632050 | 2021-08-19 | Crawford | Illinois | 17033 | 2559 | 43 |
1632252 | 1632252 | 2021-08-19 | Crawford | Iowa | 19047 | 2887 | 43 |
1628803 | 1628803 | 2021-08-18 | Crawford | Illinois | 17033 | 2539 | 43 |
1629005 | 1629005 | 2021-08-18 | Crawford | Iowa | 19047 | 2887 | 43 |
1625556 | 1625556 | 2021-08-17 | Crawford | Illinois | 17033 | 2506 | 43 |
1625758 | 1625758 | 2021-08-17 | Crawford | Iowa | 19047 | 2830 | 43 |
1622309 | 1622309 | 2021-08-16 | Crawford | Illinois | 17033 | 2476 | 43 |
1622511 | 1622511 | 2021-08-16 | Crawford | Iowa | 19047 | 2830 | 43 |
1619062 | 1619062 | 2021-08-15 | Crawford | Illinois | 17033 | 2437 | 43 |
1619264 | 1619264 | 2021-08-15 | Crawford | Iowa | 19047 | 2830 | 43 |
1615814 | 1615814 | 2021-08-14 | Crawford | Illinois | 17033 | 2437 | 43 |
1616016 | 1616016 | 2021-08-14 | Crawford | Iowa | 19047 | 2830 | 43 |
1612565 | 1612565 | 2021-08-13 | Crawford | Illinois | 17033 | 2437 | 43 |
1612767 | 1612767 | 2021-08-13 | Crawford | Iowa | 19047 | 2830 | 43 |
1609317 | 1609317 | 2021-08-12 | Crawford | Illinois | 17033 | 2416 | 43 |
1609519 | 1609519 | 2021-08-12 | Crawford | Iowa | 19047 | 2830 | 43 |
1606270 | 1606270 | 2021-08-11 | Crawford | Iowa | 19047 | 2830 | 43 |
870588 | 870588 | 2020-12-27 | Crawford | Ohio | 39033 | 2482 | 43 |
867343 | 867343 | 2020-12-26 | Crawford | Ohio | 39033 | 2462 | 43 |
864098 | 864098 | 2020-12-25 | Crawford | Ohio | 39033 | 2420 | 43 |
860853 | 860853 | 2020-12-24 | Crawford | Ohio | 39033 | 2420 | 43 |
822110 | 822110 | 2020-12-12 | Crawford | Pennsylvania | 42039 | 3566 | 43 |
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);