ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 19065 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 340 ✖
- 28 16
- 1878 15
- 4093 14
- 24 9
- 26 8
- 1 7
- 3 7
- 25 7
- 1757 7
- 1852 7
- 1882 7
- 1889 7
- 1916 7
- 1949 7
- 1990 7
- 2048 7
- 2089 7
- 2127 7
- 2208 7
- 2284 7
- 2368 7
- 2471 7
- 2540 7
- 2606 7
- 2648 7
- 2695 7
- 2746 7
- 2807 7
- 2866 7
- 2914 7
- 2977 7
- 3051 7
- 3099 7
- 3152 7
- 3266 7
- 3417 7
- 3581 7
- 3755 7
- 3855 7
- 3943 7
- 3994 7
- 4038 7
- 4061 7
- 4069 7
- 4074 7
- 4080 7
- 4081 7
- 4087 7
- 4097 7
- 4110 7
- 2 6
- 27 6
- 1854 6
- 1825 5
- 1843 5
- 1847 5
- 1860 5
- 5 4
- 6 4
- 30 4
- 63 4
- 81 4
- 1839 4
- 1853 4
- 4 3
- 7 3
- 65 3
- 82 3
- 1768 3
- 1791 3
- 1804 3
- 1807 3
- 1821 3
- 1826 3
- 1864 3
- 1865 3
- 1866 3
- 1871 3
- 1872 3
- 1875 3
- 4123 3
- 20 2
- 22 2
- 23 2
- 29 2
- 31 2
- 33 2
- 50 2
- 59 2
- 71 2
- 72 2
- 75 2
- 77 2
- 114 2
- 137 2
- 159 2
- 164 2
- 1695 2
- 1747 2
- 1800 2
- 1801 2
- 1813 2
- 1816 2
- 1817 2
- 1822 2
- 1828 2
- 1829 2
- 1830 2
- 1851 2
- 1861 2
- 1874 2
- 1879 2
- 10 1
- 12 1
- 15 1
- 16 1
- 17 1
- 21 1
- 32 1
- 34 1
- 45 1
- 48 1
- 51 1
- 52 1
- 54 1
- 56 1
- 57 1
- 62 1
- 66 1
- 68 1
- 69 1
- 79 1
- 84 1
- 85 1
- 86 1
- 93 1
- 96 1
- 99 1
- 102 1
- 105 1
- 106 1
- 120 1
- 122 1
- 123 1
- 125 1
- 127 1
- 130 1
- 134 1
- 138 1
- 142 1
- 143 1
- 144 1
- 150 1
- 153 1
- 157 1
- 165 1
- 166 1
- 168 1
- 169 1
- 170 1
- 173 1
- 174 1
- 176 1
- 178 1
- 187 1
- 191 1
- 200 1
- 203 1
- 206 1
- 211 1
- 217 1
- 222 1
- 227 1
- 231 1
- 238 1
- 240 1
- 244 1
- 246 1
- 249 1
- 250 1
- 255 1
- 258 1
- 264 1
- 275 1
- 281 1
- 285 1
- 286 1
- 290 1
- 301 1
- 309 1
- 321 1
- 329 1
- 331 1
- 337 1
- 341 1
- 346 1
- 348 1
- 358 1
- 362 1
- 369 1
- 374 1
- 381 1
- 385 1
- 393 1
- 407 1
- 422 1
- 440 1
- 454 1
- 471 1
- 489 1
- 511 1
- 527 1
- 544 1
- 560 1
- 594 1
- 635 1
- 672 1
- 706 1
- 739 1
- 767 1
- 783 1
- 797 1
- 826 1
- 857 1
- 884 1
- 910 1
- 928 1
- 942 1
- 958 1
- 977 1
- 1000 1
- 1014 1
- 1015 1
- 1022 1
- 1033 1
- 1039 1
- 1057 1
- 1076 1
- 1087 1
- 1098 1
- 1118 1
- 1125 1
- 1131 1
- 1138 1
- 1140 1
- 1148 1
- 1160 1
- 1173 1
- 1184 1
- 1186 1
- 1188 1
- 1197 1
- 1205 1
- 1211 1
- 1226 1
- 1241 1
- 1242 1
- 1260 1
- 1287 1
- 1301 1
- 1308 1
- 1327 1
- 1329 1
- 1338 1
- 1359 1
- 1380 1
- 1396 1
- 1405 1
- 1412 1
- 1426 1
- 1436 1
- 1447 1
- 1460 1
- 1481 1
- 1494 1
- 1505 1
- 1513 1
- 1519 1
- 1530 1
- 1535 1
- 1556 1
- 1569 1
- 1591 1
- 1595 1
- 1601 1
- 1611 1
- 1623 1
- 1636 1
- 1641 1
- 1650 1
- 1659 1
- 1660 1
- 1663 1
- 1668 1
- 1684 1
- 1687 1
- 1689 1
- 1696 1
- 1704 1
- 1709 1
- 1712 1
- 1718 1
- 1722 1
- 1723 1
- 1725 1
- 1730 1
- 1736 1
- 1739 1
- 1744 1
- 1745 1
- 1751 1
- 1755 1
- 1766 1
- 1769 1
- 1775 1
- 1779 1
- 1789 1
- 1795 1
- 1797 1
- 1799 1
- 1803 1
- 1809 1
- 1811 1
- 1819 1
- 1823 1
- 1832 1
- 1835 1
- 1837 1
- 1838 1
- 1840 1
- 1842 1
- 1844 1
- 1848 1
- 1849 1
- 1850 1
- 1855 1
- 1857 1
- 1859 1
- 1867 1
- 1869 1
state 1
- Iowa 784
fips 1
- 19065 · 784 ✖
county 1
- Fayette 784
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500405 | 2500405 | 2022-05-13 | Fayette | Iowa | 19065 | 4123 | 74 |
2497147 | 2497147 | 2022-05-12 | Fayette | Iowa | 19065 | 4123 | 74 |
2493889 | 2493889 | 2022-05-11 | Fayette | Iowa | 19065 | 4123 | 74 |
2490631 | 2490631 | 2022-05-10 | Fayette | Iowa | 19065 | 4110 | 74 |
2487374 | 2487374 | 2022-05-09 | Fayette | Iowa | 19065 | 4110 | 74 |
2484116 | 2484116 | 2022-05-08 | Fayette | Iowa | 19065 | 4110 | 74 |
2480858 | 2480858 | 2022-05-07 | Fayette | Iowa | 19065 | 4110 | 74 |
2477600 | 2477600 | 2022-05-06 | Fayette | Iowa | 19065 | 4110 | 74 |
2474342 | 2474342 | 2022-05-05 | Fayette | Iowa | 19065 | 4110 | 74 |
2471085 | 2471085 | 2022-05-04 | Fayette | Iowa | 19065 | 4110 | 74 |
2467829 | 2467829 | 2022-05-03 | Fayette | Iowa | 19065 | 4097 | 74 |
2464574 | 2464574 | 2022-05-02 | Fayette | Iowa | 19065 | 4097 | 74 |
2461318 | 2461318 | 2022-05-01 | Fayette | Iowa | 19065 | 4097 | 74 |
2458062 | 2458062 | 2022-04-30 | Fayette | Iowa | 19065 | 4097 | 74 |
2454806 | 2454806 | 2022-04-29 | Fayette | Iowa | 19065 | 4097 | 74 |
2451550 | 2451550 | 2022-04-28 | Fayette | Iowa | 19065 | 4097 | 74 |
2448294 | 2448294 | 2022-04-27 | Fayette | Iowa | 19065 | 4097 | 74 |
2445038 | 2445038 | 2022-04-26 | Fayette | Iowa | 19065 | 4093 | 74 |
2441782 | 2441782 | 2022-04-25 | Fayette | Iowa | 19065 | 4093 | 74 |
2438526 | 2438526 | 2022-04-24 | Fayette | Iowa | 19065 | 4093 | 74 |
2435270 | 2435270 | 2022-04-23 | Fayette | Iowa | 19065 | 4093 | 74 |
2432014 | 2432014 | 2022-04-22 | Fayette | Iowa | 19065 | 4093 | 74 |
2428758 | 2428758 | 2022-04-21 | Fayette | Iowa | 19065 | 4093 | 74 |
2425502 | 2425502 | 2022-04-20 | Fayette | Iowa | 19065 | 4093 | 74 |
2422246 | 2422246 | 2022-04-19 | Fayette | Iowa | 19065 | 4093 | 72 |
2418990 | 2418990 | 2022-04-18 | Fayette | Iowa | 19065 | 4093 | 72 |
2415734 | 2415734 | 2022-04-17 | Fayette | Iowa | 19065 | 4093 | 72 |
2412478 | 2412478 | 2022-04-16 | Fayette | Iowa | 19065 | 4093 | 72 |
2409222 | 2409222 | 2022-04-15 | Fayette | Iowa | 19065 | 4093 | 72 |
2405966 | 2405966 | 2022-04-14 | Fayette | Iowa | 19065 | 4093 | 72 |
2402710 | 2402710 | 2022-04-13 | Fayette | Iowa | 19065 | 4093 | 72 |
2399456 | 2399456 | 2022-04-12 | Fayette | Iowa | 19065 | 4087 | 72 |
2396200 | 2396200 | 2022-04-11 | Fayette | Iowa | 19065 | 4087 | 72 |
2392945 | 2392945 | 2022-04-10 | Fayette | Iowa | 19065 | 4087 | 72 |
2389689 | 2389689 | 2022-04-09 | Fayette | Iowa | 19065 | 4087 | 72 |
2386433 | 2386433 | 2022-04-08 | Fayette | Iowa | 19065 | 4087 | 72 |
2383179 | 2383179 | 2022-04-07 | Fayette | Iowa | 19065 | 4087 | 72 |
2379924 | 2379924 | 2022-04-06 | Fayette | Iowa | 19065 | 4087 | 72 |
2376669 | 2376669 | 2022-04-05 | Fayette | Iowa | 19065 | 4081 | 72 |
2373417 | 2373417 | 2022-04-04 | Fayette | Iowa | 19065 | 4081 | 72 |
2370164 | 2370164 | 2022-04-03 | Fayette | Iowa | 19065 | 4081 | 72 |
2366911 | 2366911 | 2022-04-02 | Fayette | Iowa | 19065 | 4081 | 72 |
2363658 | 2363658 | 2022-04-01 | Fayette | Iowa | 19065 | 4081 | 72 |
2360404 | 2360404 | 2022-03-31 | Fayette | Iowa | 19065 | 4081 | 72 |
2357150 | 2357150 | 2022-03-30 | Fayette | Iowa | 19065 | 4081 | 72 |
2353897 | 2353897 | 2022-03-29 | Fayette | Iowa | 19065 | 4080 | 71 |
2350645 | 2350645 | 2022-03-28 | Fayette | Iowa | 19065 | 4080 | 71 |
2347392 | 2347392 | 2022-03-27 | Fayette | Iowa | 19065 | 4080 | 71 |
2344139 | 2344139 | 2022-03-26 | Fayette | Iowa | 19065 | 4080 | 71 |
2340886 | 2340886 | 2022-03-25 | Fayette | Iowa | 19065 | 4080 | 71 |
2337633 | 2337633 | 2022-03-24 | Fayette | Iowa | 19065 | 4080 | 71 |
2334379 | 2334379 | 2022-03-23 | Fayette | Iowa | 19065 | 4080 | 71 |
2331125 | 2331125 | 2022-03-22 | Fayette | Iowa | 19065 | 4074 | 71 |
2327873 | 2327873 | 2022-03-21 | Fayette | Iowa | 19065 | 4074 | 71 |
2324620 | 2324620 | 2022-03-20 | Fayette | Iowa | 19065 | 4074 | 71 |
2321366 | 2321366 | 2022-03-19 | Fayette | Iowa | 19065 | 4074 | 71 |
2318112 | 2318112 | 2022-03-18 | Fayette | Iowa | 19065 | 4074 | 71 |
2314859 | 2314859 | 2022-03-17 | Fayette | Iowa | 19065 | 4074 | 71 |
2311606 | 2311606 | 2022-03-16 | Fayette | Iowa | 19065 | 4074 | 71 |
2308353 | 2308353 | 2022-03-15 | Fayette | Iowa | 19065 | 4069 | 71 |
2305102 | 2305102 | 2022-03-14 | Fayette | Iowa | 19065 | 4069 | 71 |
2301850 | 2301850 | 2022-03-13 | Fayette | Iowa | 19065 | 4069 | 71 |
2298598 | 2298598 | 2022-03-12 | Fayette | Iowa | 19065 | 4069 | 71 |
2295346 | 2295346 | 2022-03-11 | Fayette | Iowa | 19065 | 4069 | 71 |
2292094 | 2292094 | 2022-03-10 | Fayette | Iowa | 19065 | 4069 | 71 |
2288842 | 2288842 | 2022-03-09 | Fayette | Iowa | 19065 | 4069 | 71 |
2285591 | 2285591 | 2022-03-08 | Fayette | Iowa | 19065 | 4061 | 71 |
2282339 | 2282339 | 2022-03-07 | Fayette | Iowa | 19065 | 4061 | 71 |
2279086 | 2279086 | 2022-03-06 | Fayette | Iowa | 19065 | 4061 | 71 |
2275833 | 2275833 | 2022-03-05 | Fayette | Iowa | 19065 | 4061 | 71 |
2272580 | 2272580 | 2022-03-04 | Fayette | Iowa | 19065 | 4061 | 71 |
2269328 | 2269328 | 2022-03-03 | Fayette | Iowa | 19065 | 4061 | 71 |
2266075 | 2266075 | 2022-03-02 | Fayette | Iowa | 19065 | 4061 | 71 |
2262824 | 2262824 | 2022-03-01 | Fayette | Iowa | 19065 | 4038 | 71 |
2259573 | 2259573 | 2022-02-28 | Fayette | Iowa | 19065 | 4038 | 71 |
2256322 | 2256322 | 2022-02-27 | Fayette | Iowa | 19065 | 4038 | 71 |
2253071 | 2253071 | 2022-02-26 | Fayette | Iowa | 19065 | 4038 | 71 |
2249820 | 2249820 | 2022-02-25 | Fayette | Iowa | 19065 | 4038 | 71 |
2246569 | 2246569 | 2022-02-24 | Fayette | Iowa | 19065 | 4038 | 71 |
2243318 | 2243318 | 2022-02-23 | Fayette | Iowa | 19065 | 4038 | 71 |
2240067 | 2240067 | 2022-02-22 | Fayette | Iowa | 19065 | 3994 | 71 |
2236816 | 2236816 | 2022-02-21 | Fayette | Iowa | 19065 | 3994 | 71 |
2233565 | 2233565 | 2022-02-20 | Fayette | Iowa | 19065 | 3994 | 71 |
2230314 | 2230314 | 2022-02-19 | Fayette | Iowa | 19065 | 3994 | 71 |
2227063 | 2227063 | 2022-02-18 | Fayette | Iowa | 19065 | 3994 | 71 |
2223812 | 2223812 | 2022-02-17 | Fayette | Iowa | 19065 | 3994 | 71 |
2220561 | 2220561 | 2022-02-16 | Fayette | Iowa | 19065 | 3994 | 71 |
2217310 | 2217310 | 2022-02-15 | Fayette | Iowa | 19065 | 3943 | 70 |
2214059 | 2214059 | 2022-02-14 | Fayette | Iowa | 19065 | 3943 | 70 |
2210807 | 2210807 | 2022-02-13 | Fayette | Iowa | 19065 | 3943 | 70 |
2207554 | 2207554 | 2022-02-12 | Fayette | Iowa | 19065 | 3943 | 70 |
2204301 | 2204301 | 2022-02-11 | Fayette | Iowa | 19065 | 3943 | 70 |
2201048 | 2201048 | 2022-02-10 | Fayette | Iowa | 19065 | 3943 | 70 |
2197794 | 2197794 | 2022-02-09 | Fayette | Iowa | 19065 | 3943 | 70 |
2194540 | 2194540 | 2022-02-08 | Fayette | Iowa | 19065 | 3855 | 68 |
2191286 | 2191286 | 2022-02-07 | Fayette | Iowa | 19065 | 3855 | 68 |
2188033 | 2188033 | 2022-02-06 | Fayette | Iowa | 19065 | 3855 | 68 |
2184780 | 2184780 | 2022-02-05 | Fayette | Iowa | 19065 | 3855 | 68 |
2181528 | 2181528 | 2022-02-04 | Fayette | Iowa | 19065 | 3855 | 68 |
2178277 | 2178277 | 2022-02-03 | Fayette | Iowa | 19065 | 3855 | 68 |
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);