ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where county = "Crawford" and deaths = 30 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Crawford · 114 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445473 | 2445473 | 2022-04-26 | Crawford | Michigan | 26039 | 2576 | 30 |
2442217 | 2442217 | 2022-04-25 | Crawford | Michigan | 26039 | 2576 | 30 |
2438961 | 2438961 | 2022-04-24 | Crawford | Michigan | 26039 | 2576 | 30 |
2435705 | 2435705 | 2022-04-23 | Crawford | Michigan | 26039 | 2576 | 30 |
2432449 | 2432449 | 2022-04-22 | Crawford | Michigan | 26039 | 2576 | 30 |
2429193 | 2429193 | 2022-04-21 | Crawford | Michigan | 26039 | 2576 | 30 |
2425937 | 2425937 | 2022-04-20 | Crawford | Michigan | 26039 | 2576 | 30 |
2422681 | 2422681 | 2022-04-19 | Crawford | Michigan | 26039 | 2566 | 30 |
2419425 | 2419425 | 2022-04-18 | Crawford | Michigan | 26039 | 2566 | 30 |
2416169 | 2416169 | 2022-04-17 | Crawford | Michigan | 26039 | 2566 | 30 |
2412913 | 2412913 | 2022-04-16 | Crawford | Michigan | 26039 | 2566 | 30 |
2409657 | 2409657 | 2022-04-15 | Crawford | Michigan | 26039 | 2566 | 30 |
2406401 | 2406401 | 2022-04-14 | Crawford | Michigan | 26039 | 2566 | 30 |
2403145 | 2403145 | 2022-04-13 | Crawford | Michigan | 26039 | 2566 | 30 |
2399891 | 2399891 | 2022-04-12 | Crawford | Michigan | 26039 | 2557 | 30 |
2396635 | 2396635 | 2022-04-11 | Crawford | Michigan | 26039 | 2557 | 30 |
2393380 | 2393380 | 2022-04-10 | Crawford | Michigan | 26039 | 2557 | 30 |
2390124 | 2390124 | 2022-04-09 | Crawford | Michigan | 26039 | 2557 | 30 |
2386868 | 2386868 | 2022-04-08 | Crawford | Michigan | 26039 | 2557 | 30 |
2383613 | 2383613 | 2022-04-07 | Crawford | Michigan | 26039 | 2557 | 30 |
2380358 | 2380358 | 2022-04-06 | Crawford | Michigan | 26039 | 2557 | 30 |
2377103 | 2377103 | 2022-04-05 | Crawford | Michigan | 26039 | 2555 | 30 |
2373851 | 2373851 | 2022-04-04 | Crawford | Michigan | 26039 | 2555 | 30 |
2370598 | 2370598 | 2022-04-03 | Crawford | Michigan | 26039 | 2555 | 30 |
2367345 | 2367345 | 2022-04-02 | Crawford | Michigan | 26039 | 2555 | 30 |
2364092 | 2364092 | 2022-04-01 | Crawford | Michigan | 26039 | 2555 | 30 |
2360838 | 2360838 | 2022-03-31 | Crawford | Michigan | 26039 | 2554 | 30 |
2357584 | 2357584 | 2022-03-30 | Crawford | Michigan | 26039 | 2554 | 30 |
2354331 | 2354331 | 2022-03-29 | Crawford | Michigan | 26039 | 2553 | 30 |
2351079 | 2351079 | 2022-03-28 | Crawford | Michigan | 26039 | 2553 | 30 |
2347826 | 2347826 | 2022-03-27 | Crawford | Michigan | 26039 | 2553 | 30 |
2344573 | 2344573 | 2022-03-26 | Crawford | Michigan | 26039 | 2553 | 30 |
2341320 | 2341320 | 2022-03-25 | Crawford | Michigan | 26039 | 2553 | 30 |
2338067 | 2338067 | 2022-03-24 | Crawford | Michigan | 26039 | 2549 | 30 |
2334813 | 2334813 | 2022-03-23 | Crawford | Michigan | 26039 | 2549 | 30 |
2331559 | 2331559 | 2022-03-22 | Crawford | Michigan | 26039 | 2549 | 30 |
2328307 | 2328307 | 2022-03-21 | Crawford | Michigan | 26039 | 2549 | 30 |
2325054 | 2325054 | 2022-03-20 | Crawford | Michigan | 26039 | 2549 | 30 |
2321800 | 2321800 | 2022-03-19 | Crawford | Michigan | 26039 | 2549 | 30 |
2318546 | 2318546 | 2022-03-18 | Crawford | Michigan | 26039 | 2549 | 30 |
2315293 | 2315293 | 2022-03-17 | Crawford | Michigan | 26039 | 2548 | 30 |
2312040 | 2312040 | 2022-03-16 | Crawford | Michigan | 26039 | 2548 | 30 |
2308787 | 2308787 | 2022-03-15 | Crawford | Michigan | 26039 | 2542 | 30 |
2305536 | 2305536 | 2022-03-14 | Crawford | Michigan | 26039 | 2542 | 30 |
2302284 | 2302284 | 2022-03-13 | Crawford | Michigan | 26039 | 2543 | 30 |
2299032 | 2299032 | 2022-03-12 | Crawford | Michigan | 26039 | 2543 | 30 |
2295780 | 2295780 | 2022-03-11 | Crawford | Michigan | 26039 | 2543 | 30 |
2292528 | 2292528 | 2022-03-10 | Crawford | Michigan | 26039 | 2541 | 30 |
2289276 | 2289276 | 2022-03-09 | Crawford | Michigan | 26039 | 2541 | 30 |
2035080 | 2035080 | 2021-12-21 | Crawford | Indiana | 18025 | 1804 | 30 |
2031830 | 2031830 | 2021-12-20 | Crawford | Indiana | 18025 | 1797 | 30 |
2028579 | 2028579 | 2021-12-19 | Crawford | Indiana | 18025 | 1779 | 30 |
2025328 | 2025328 | 2021-12-18 | Crawford | Indiana | 18025 | 1779 | 30 |
2022077 | 2022077 | 2021-12-17 | Crawford | Indiana | 18025 | 1779 | 30 |
2018826 | 2018826 | 2021-12-16 | Crawford | Indiana | 18025 | 1773 | 30 |
2015576 | 2015576 | 2021-12-15 | Crawford | Indiana | 18025 | 1768 | 30 |
2012325 | 2012325 | 2021-12-14 | Crawford | Indiana | 18025 | 1761 | 30 |
2009074 | 2009074 | 2021-12-13 | Crawford | Indiana | 18025 | 1755 | 30 |
2005823 | 2005823 | 2021-12-12 | Crawford | Indiana | 18025 | 1736 | 30 |
2002572 | 2002572 | 2021-12-11 | Crawford | Indiana | 18025 | 1736 | 30 |
1999322 | 1999322 | 2021-12-10 | Crawford | Indiana | 18025 | 1736 | 30 |
1996071 | 1996071 | 2021-12-09 | Crawford | Indiana | 18025 | 1729 | 30 |
1992820 | 1992820 | 2021-12-08 | Crawford | Indiana | 18025 | 1721 | 30 |
1989569 | 1989569 | 2021-12-07 | Crawford | Indiana | 18025 | 1714 | 30 |
1986319 | 1986319 | 2021-12-06 | Crawford | Indiana | 18025 | 1709 | 30 |
1983069 | 1983069 | 2021-12-05 | Crawford | Indiana | 18025 | 1693 | 30 |
1979819 | 1979819 | 2021-12-04 | Crawford | Indiana | 18025 | 1693 | 30 |
1976569 | 1976569 | 2021-12-03 | Crawford | Indiana | 18025 | 1693 | 30 |
1973320 | 1973320 | 2021-12-02 | Crawford | Indiana | 18025 | 1690 | 30 |
1970070 | 1970070 | 2021-12-01 | Crawford | Indiana | 18025 | 1685 | 30 |
1966820 | 1966820 | 2021-11-30 | Crawford | Indiana | 18025 | 1683 | 30 |
1963568 | 1963568 | 2021-11-29 | Crawford | Indiana | 18025 | 1681 | 30 |
1960317 | 1960317 | 2021-11-28 | Crawford | Indiana | 18025 | 1673 | 30 |
1957066 | 1957066 | 2021-11-27 | Crawford | Indiana | 18025 | 1673 | 30 |
1953815 | 1953815 | 2021-11-26 | Crawford | Indiana | 18025 | 1673 | 30 |
1950564 | 1950564 | 2021-11-25 | Crawford | Indiana | 18025 | 1673 | 30 |
1947313 | 1947313 | 2021-11-24 | Crawford | Indiana | 18025 | 1673 | 30 |
1944062 | 1944062 | 2021-11-23 | Crawford | Indiana | 18025 | 1671 | 30 |
1940812 | 1940812 | 2021-11-22 | Crawford | Indiana | 18025 | 1666 | 30 |
1937562 | 1937562 | 2021-11-21 | Crawford | Indiana | 18025 | 1660 | 30 |
1934312 | 1934312 | 2021-11-20 | Crawford | Indiana | 18025 | 1660 | 30 |
1931061 | 1931061 | 2021-11-19 | Crawford | Indiana | 18025 | 1660 | 30 |
1927810 | 1927810 | 2021-11-18 | Crawford | Indiana | 18025 | 1656 | 30 |
1924560 | 1924560 | 2021-11-17 | Crawford | Indiana | 18025 | 1654 | 30 |
1921311 | 1921311 | 2021-11-16 | Crawford | Indiana | 18025 | 1651 | 30 |
1918061 | 1918061 | 2021-11-15 | Crawford | Indiana | 18025 | 1650 | 30 |
1914811 | 1914811 | 2021-11-14 | Crawford | Indiana | 18025 | 1647 | 30 |
1911561 | 1911561 | 2021-11-13 | Crawford | Indiana | 18025 | 1647 | 30 |
1908312 | 1908312 | 2021-11-12 | Crawford | Indiana | 18025 | 1647 | 30 |
1905063 | 1905063 | 2021-11-11 | Crawford | Indiana | 18025 | 1643 | 30 |
1901813 | 1901813 | 2021-11-10 | Crawford | Indiana | 18025 | 1635 | 30 |
1898563 | 1898563 | 2021-11-09 | Crawford | Indiana | 18025 | 1634 | 30 |
1895313 | 1895313 | 2021-11-08 | Crawford | Indiana | 18025 | 1633 | 30 |
1892063 | 1892063 | 2021-11-07 | Crawford | Indiana | 18025 | 1630 | 30 |
1888813 | 1888813 | 2021-11-06 | Crawford | Indiana | 18025 | 1630 | 30 |
1885563 | 1885563 | 2021-11-05 | Crawford | Indiana | 18025 | 1630 | 30 |
1080994 | 1080994 | 2021-03-02 | Crawford | Missouri | 29055 | 2052 | 30 |
1077748 | 1077748 | 2021-03-01 | Crawford | Missouri | 29055 | 2052 | 30 |
1074502 | 1074502 | 2021-02-28 | Crawford | Missouri | 29055 | 2051 | 30 |
1071256 | 1071256 | 2021-02-27 | Crawford | Missouri | 29055 | 2049 | 30 |
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);