ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 19191 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 357 ✖
- 24 29
- 18 15
- 1969 12
- 5 10
- 1 9
- 1996 8
- 4 7
- 1971 7
- 1975 7
- 2001 7
- 2006 7
- 2013 7
- 2015 7
- 2025 7
- 2039 7
- 2060 7
- 2086 7
- 2113 7
- 2162 7
- 2195 7
- 2235 7
- 2277 7
- 2310 7
- 2335 7
- 2365 7
- 2405 7
- 2455 7
- 2528 7
- 2601 7
- 2690 7
- 2791 7
- 2870 7
- 2949 7
- 3021 7
- 3107 7
- 3229 7
- 3384 7
- 3523 7
- 3599 7
- 3673 7
- 3731 7
- 3760 7
- 3782 7
- 3795 7
- 3803 7
- 3806 7
- 3813 7
- 3818 7
- 3829 7
- 3839 7
- 3860 7
- 3879 7
- 1783 6
- 21 5
- 23 5
- 3 4
- 53 4
- 97 4
- 1854 4
- 1960 4
- 1968 4
- 2005 4
- 15 3
- 1807 3
- 1830 3
- 1890 3
- 1972 3
- 3906 3
- 2 2
- 6 2
- 17 2
- 25 2
- 38 2
- 39 2
- 43 2
- 50 2
- 71 2
- 224 2
- 340 2
- 346 2
- 1608 2
- 1757 2
- 1818 2
- 1837 2
- 1844 2
- 1910 2
- 1926 2
- 1947 2
- 1949 2
- 1951 2
- 1954 2
- 1976 2
- 1977 2
- 1986 2
- 1987 2
- 1989 2
- 1993 2
- 1998 2
- 2004 2
- 7 1
- 8 1
- 9 1
- 11 1
- 12 1
- 20 1
- 22 1
- 27 1
- 28 1
- 31 1
- 33 1
- 36 1
- 37 1
- 45 1
- 46 1
- 54 1
- 57 1
- 58 1
- 62 1
- 63 1
- 66 1
- 67 1
- 69 1
- 72 1
- 73 1
- 74 1
- 77 1
- 78 1
- 82 1
- 85 1
- 86 1
- 90 1
- 91 1
- 92 1
- 95 1
- 103 1
- 106 1
- 108 1
- 109 1
- 113 1
- 116 1
- 124 1
- 144 1
- 161 1
- 165 1
- 169 1
- 174 1
- 187 1
- 196 1
- 198 1
- 208 1
- 214 1
- 217 1
- 219 1
- 229 1
- 235 1
- 239 1
- 241 1
- 243 1
- 247 1
- 249 1
- 252 1
- 256 1
- 259 1
- 260 1
- 261 1
- 268 1
- 271 1
- 278 1
- 283 1
- 293 1
- 298 1
- 299 1
- 304 1
- 315 1
- 324 1
- 330 1
- 335 1
- 339 1
- 350 1
- 353 1
- 355 1
- 358 1
- 362 1
- 363 1
- 370 1
- 378 1
- 382 1
- 388 1
- 392 1
- 399 1
- 402 1
- 411 1
- 422 1
- 425 1
- 429 1
- 433 1
- 447 1
- 451 1
- 459 1
- 460 1
- 466 1
- 474 1
- 477 1
- 485 1
- 497 1
- 511 1
- 525 1
- 538 1
- 544 1
- 553 1
- 558 1
- 565 1
- 583 1
- 595 1
- 614 1
- 635 1
- 640 1
- 658 1
- 676 1
- 699 1
- 713 1
- 733 1
- 748 1
- 756 1
- 785 1
- 805 1
- 840 1
- 860 1
- 883 1
- 889 1
- 903 1
- 915 1
- 933 1
- 954 1
- 958 1
- 962 1
- 976 1
- 984 1
- 1010 1
- 1027 1
- 1055 1
- 1097 1
- 1109 1
- 1112 1
- 1117 1
- 1118 1
- 1156 1
- 1165 1
- 1184 1
- 1194 1
- 1205 1
- 1210 1
- 1217 1
- 1242 1
- 1253 1
- 1269 1
- 1293 1
- 1296 1
- 1299 1
- 1308 1
- 1330 1
- 1339 1
- 1340 1
- 1344 1
- 1345 1
- 1349 1
- 1368 1
- 1379 1
- 1381 1
- 1386 1
- 1393 1
- 1398 1
- 1400 1
- 1403 1
- 1424 1
- 1437 1
- 1462 1
- 1471 1
- 1472 1
- 1473 1
- 1474 1
- 1506 1
- 1508 1
- 1530 1
- 1548 1
- 1551 1
- 1552 1
- 1557 1
- 1569 1
- 1591 1
- 1597 1
- 1610 1
- 1614 1
- 1630 1
- 1632 1
- 1636 1
- 1652 1
- 1653 1
- 1658 1
- 1669 1
- 1678 1
- 1686 1
- 1687 1
- 1695 1
- 1698 1
- 1701 1
- 1717 1
- 1733 1
- 1735 1
- 1750 1
- 1760 1
- 1764 1
- 1778 1
- 1780 1
- 1806 1
- 1824 1
- 1829 1
- 1848 1
- 1859 1
- 1864 1
- 1868 1
- 1870 1
- 1871 1
- 1873 1
- 1875 1
- 1876 1
- 1879 1
- 1884 1
- 1891 1
- 1895 1
- 1897 1
- 1903 1
- 1905 1
- 1907 1
- 1908 1
- 1913 1
- 1918 1
- 1923 1
- 1928 1
- 1937 1
- 1939 1
- 1940 1
- 1944 1
- 1945 1
- 1953 1
- 1957 1
- 1962 1
- 1963 1
- 1965 1
- 1967 1
- 1970 1
- 1980 1
- 1981 1
- 1982 1
- 1984 1
- 1990 1
- 2003 1
state 1
- Iowa 787
fips 1
- 19191 · 787 ✖
county 1
- Winneshiek 787
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3973 | 3973 | 2020-03-18 | Winneshiek | Iowa | 19191 | 1 | 0 |
4654 | 4654 | 2020-03-19 | Winneshiek | Iowa | 19191 | 1 | 0 |
5465 | 5465 | 2020-03-20 | Winneshiek | Iowa | 19191 | 1 | 0 |
6410 | 6410 | 2020-03-21 | Winneshiek | Iowa | 19191 | 1 | 0 |
7476 | 7476 | 2020-03-22 | Winneshiek | Iowa | 19191 | 1 | 0 |
8636 | 8636 | 2020-03-23 | Winneshiek | Iowa | 19191 | 1 | 0 |
9916 | 9916 | 2020-03-24 | Winneshiek | Iowa | 19191 | 1 | 0 |
11313 | 11313 | 2020-03-25 | Winneshiek | Iowa | 19191 | 1 | 0 |
12880 | 12880 | 2020-03-26 | Winneshiek | Iowa | 19191 | 1 | 0 |
14575 | 14575 | 2020-03-27 | Winneshiek | Iowa | 19191 | 2 | 0 |
16382 | 16382 | 2020-03-28 | Winneshiek | Iowa | 19191 | 2 | 0 |
18287 | 18287 | 2020-03-29 | Winneshiek | Iowa | 19191 | 3 | 0 |
20299 | 20299 | 2020-03-30 | Winneshiek | Iowa | 19191 | 3 | 0 |
22395 | 22395 | 2020-03-31 | Winneshiek | Iowa | 19191 | 3 | 0 |
24570 | 24570 | 2020-04-01 | Winneshiek | Iowa | 19191 | 3 | 0 |
26812 | 26812 | 2020-04-02 | Winneshiek | Iowa | 19191 | 4 | 0 |
29126 | 29126 | 2020-04-03 | Winneshiek | Iowa | 19191 | 4 | 0 |
31498 | 31498 | 2020-04-04 | Winneshiek | Iowa | 19191 | 4 | 0 |
33911 | 33911 | 2020-04-05 | Winneshiek | Iowa | 19191 | 4 | 0 |
36368 | 36368 | 2020-04-06 | Winneshiek | Iowa | 19191 | 4 | 0 |
38869 | 38869 | 2020-04-07 | Winneshiek | Iowa | 19191 | 4 | 0 |
41415 | 41415 | 2020-04-08 | Winneshiek | Iowa | 19191 | 4 | 0 |
43991 | 43991 | 2020-04-09 | Winneshiek | Iowa | 19191 | 5 | 0 |
46598 | 46598 | 2020-04-10 | Winneshiek | Iowa | 19191 | 5 | 0 |
49232 | 49232 | 2020-04-11 | Winneshiek | Iowa | 19191 | 5 | 0 |
51896 | 51896 | 2020-04-12 | Winneshiek | Iowa | 19191 | 5 | 0 |
54578 | 54578 | 2020-04-13 | Winneshiek | Iowa | 19191 | 5 | 0 |
57271 | 57271 | 2020-04-14 | Winneshiek | Iowa | 19191 | 5 | 0 |
59979 | 59979 | 2020-04-15 | Winneshiek | Iowa | 19191 | 5 | 0 |
62700 | 62700 | 2020-04-16 | Winneshiek | Iowa | 19191 | 5 | 0 |
65435 | 65435 | 2020-04-17 | Winneshiek | Iowa | 19191 | 5 | 0 |
68184 | 68184 | 2020-04-18 | Winneshiek | Iowa | 19191 | 5 | 0 |
70945 | 70945 | 2020-04-19 | Winneshiek | Iowa | 19191 | 6 | 0 |
73716 | 73716 | 2020-04-20 | Winneshiek | Iowa | 19191 | 6 | 0 |
76496 | 76496 | 2020-04-21 | Winneshiek | Iowa | 19191 | 7 | 0 |
79280 | 79280 | 2020-04-22 | Winneshiek | Iowa | 19191 | 8 | 0 |
82072 | 82072 | 2020-04-23 | Winneshiek | Iowa | 19191 | 9 | 0 |
84873 | 84873 | 2020-04-24 | Winneshiek | Iowa | 19191 | 11 | 0 |
87682 | 87682 | 2020-04-25 | Winneshiek | Iowa | 19191 | 12 | 0 |
90498 | 90498 | 2020-04-26 | Winneshiek | Iowa | 19191 | 24 | 0 |
93319 | 93319 | 2020-04-27 | Winneshiek | Iowa | 19191 | 24 | 0 |
96151 | 96151 | 2020-04-28 | Winneshiek | Iowa | 19191 | 15 | 0 |
98996 | 98996 | 2020-04-29 | Winneshiek | Iowa | 19191 | 15 | 0 |
101847 | 101847 | 2020-04-30 | Winneshiek | Iowa | 19191 | 15 | 0 |
104707 | 104707 | 2020-05-01 | Winneshiek | Iowa | 19191 | 17 | 0 |
107572 | 107572 | 2020-05-02 | Winneshiek | Iowa | 19191 | 17 | 0 |
110443 | 110443 | 2020-05-03 | Winneshiek | Iowa | 19191 | 18 | 0 |
113318 | 113318 | 2020-05-04 | Winneshiek | Iowa | 19191 | 18 | 0 |
116200 | 116200 | 2020-05-05 | Winneshiek | Iowa | 19191 | 18 | 0 |
119161 | 119161 | 2020-05-06 | Winneshiek | Iowa | 19191 | 18 | 0 |
122131 | 122131 | 2020-05-07 | Winneshiek | Iowa | 19191 | 18 | 0 |
125113 | 125113 | 2020-05-08 | Winneshiek | Iowa | 19191 | 18 | 0 |
128100 | 128100 | 2020-05-09 | Winneshiek | Iowa | 19191 | 18 | 0 |
131090 | 131090 | 2020-05-10 | Winneshiek | Iowa | 19191 | 18 | 0 |
134081 | 134081 | 2020-05-11 | Winneshiek | Iowa | 19191 | 18 | 0 |
137071 | 137071 | 2020-05-12 | Winneshiek | Iowa | 19191 | 18 | 0 |
140064 | 140064 | 2020-05-13 | Winneshiek | Iowa | 19191 | 18 | 0 |
143060 | 143060 | 2020-05-14 | Winneshiek | Iowa | 19191 | 18 | 0 |
146060 | 146060 | 2020-05-15 | Winneshiek | Iowa | 19191 | 18 | 0 |
149064 | 149064 | 2020-05-16 | Winneshiek | Iowa | 19191 | 18 | 0 |
152075 | 152075 | 2020-05-17 | Winneshiek | Iowa | 19191 | 18 | 0 |
155087 | 155087 | 2020-05-18 | Winneshiek | Iowa | 19191 | 20 | 0 |
158104 | 158104 | 2020-05-19 | Winneshiek | Iowa | 19191 | 21 | 0 |
161129 | 161129 | 2020-05-20 | Winneshiek | Iowa | 19191 | 21 | 0 |
164158 | 164158 | 2020-05-21 | Winneshiek | Iowa | 19191 | 21 | 0 |
167190 | 167190 | 2020-05-22 | Winneshiek | Iowa | 19191 | 21 | 0 |
170228 | 170228 | 2020-05-23 | Winneshiek | Iowa | 19191 | 21 | 0 |
173269 | 173269 | 2020-05-24 | Winneshiek | Iowa | 19191 | 22 | 0 |
176313 | 176313 | 2020-05-25 | Winneshiek | Iowa | 19191 | 23 | 0 |
179357 | 179357 | 2020-05-26 | Winneshiek | Iowa | 19191 | 23 | 0 |
182402 | 182402 | 2020-05-27 | Winneshiek | Iowa | 19191 | 23 | 0 |
185456 | 185456 | 2020-05-28 | Winneshiek | Iowa | 19191 | 23 | 0 |
188514 | 188514 | 2020-05-29 | Winneshiek | Iowa | 19191 | 23 | 0 |
191578 | 191578 | 2020-05-30 | Winneshiek | Iowa | 19191 | 24 | 0 |
194646 | 194646 | 2020-05-31 | Winneshiek | Iowa | 19191 | 24 | 0 |
197716 | 197716 | 2020-06-01 | Winneshiek | Iowa | 19191 | 24 | 0 |
200788 | 200788 | 2020-06-02 | Winneshiek | Iowa | 19191 | 24 | 0 |
203864 | 203864 | 2020-06-03 | Winneshiek | Iowa | 19191 | 24 | 0 |
206945 | 206945 | 2020-06-04 | Winneshiek | Iowa | 19191 | 24 | 0 |
210026 | 210026 | 2020-06-05 | Winneshiek | Iowa | 19191 | 24 | 0 |
213111 | 213111 | 2020-06-06 | Winneshiek | Iowa | 19191 | 24 | 0 |
216198 | 216198 | 2020-06-07 | Winneshiek | Iowa | 19191 | 24 | 0 |
219290 | 219290 | 2020-06-08 | Winneshiek | Iowa | 19191 | 24 | 0 |
222385 | 222385 | 2020-06-09 | Winneshiek | Iowa | 19191 | 24 | 0 |
225480 | 225480 | 2020-06-10 | Winneshiek | Iowa | 19191 | 25 | 0 |
228582 | 228582 | 2020-06-11 | Winneshiek | Iowa | 19191 | 24 | 0 |
231685 | 231685 | 2020-06-12 | Winneshiek | Iowa | 19191 | 24 | 0 |
234791 | 234791 | 2020-06-13 | Winneshiek | Iowa | 19191 | 24 | 0 |
237898 | 237898 | 2020-06-14 | Winneshiek | Iowa | 19191 | 24 | 0 |
241006 | 241006 | 2020-06-15 | Winneshiek | Iowa | 19191 | 24 | 0 |
244117 | 244117 | 2020-06-16 | Winneshiek | Iowa | 19191 | 24 | 0 |
247230 | 247230 | 2020-06-17 | Winneshiek | Iowa | 19191 | 24 | 0 |
250342 | 250342 | 2020-06-18 | Winneshiek | Iowa | 19191 | 24 | 0 |
253457 | 253457 | 2020-06-19 | Winneshiek | Iowa | 19191 | 24 | 0 |
256577 | 256577 | 2020-06-20 | Winneshiek | Iowa | 19191 | 24 | 0 |
259703 | 259703 | 2020-06-21 | Winneshiek | Iowa | 19191 | 24 | 0 |
262830 | 262830 | 2020-06-22 | Winneshiek | Iowa | 19191 | 24 | 0 |
265958 | 265958 | 2020-06-23 | Winneshiek | Iowa | 19191 | 24 | 0 |
269088 | 269088 | 2020-06-24 | Winneshiek | Iowa | 19191 | 25 | 0 |
272225 | 272225 | 2020-06-25 | Winneshiek | Iowa | 19191 | 24 | 0 |
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);