ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 19013 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 203 ✖
- 0 31
- 306 25
- 320 21
- 316 20
- 308 15
- 312 14
- 96 12
- 62 11
- 309 11
- 58 9
- 66 9
- 310 9
- 56 8
- 300 8
- 307 8
- 319 7
- 324 7
- 328 7
- 330 7
- 332 7
- 334 7
- 338 7
- 344 7
- 345 7
- 355 7
- 358 7
- 363 7
- 364 7
- 368 7
- 371 7
- 378 7
- 382 7
- 387 7
- 394 7
- 397 7
- 399 7
- 406 7
- 417 7
- 421 7
- 426 7
- 438 7
- 445 7
- 449 7
- 454 7
- 457 7
- 463 7
- 465 7
- 467 7
- 469 7
- 472 7
- 473 7
- 475 7
- 477 7
- 479 7
- 60 6
- 61 6
- 98 6
- 243 6
- 53 5
- 57 5
- 59 5
- 13 4
- 37 4
- 67 4
- 81 4
- 86 4
- 90 4
- 92 4
- 102 4
- 215 4
- 218 4
- 220 4
- 228 4
- 236 4
- 265 4
- 295 4
- 298 4
- 315 4
- 1 3
- 2 3
- 29 3
- 44 3
- 74 3
- 76 3
- 78 3
- 88 3
- 95 3
- 134 3
- 275 3
- 284 3
- 290 3
- 293 3
- 294 3
- 480 3
- 15 2
- 19 2
- 20 2
- 28 2
- 30 2
- 39 2
- 43 2
- 46 2
- 49 2
- 50 2
- 55 2
- 63 2
- 69 2
- 72 2
- 79 2
- 83 2
- 94 2
- 106 2
- 107 2
- 108 2
- 110 2
- 112 2
- 125 2
- 126 2
- 137 2
- 156 2
- 184 2
- 200 2
- 207 2
- 222 2
- 224 2
- 225 2
- 248 2
- 261 2
- 286 2
- 292 2
- 296 2
- 299 2
- 301 2
- 311 2
- 4 1
- 7 1
- 8 1
- 9 1
- 11 1
- 12 1
- 18 1
- 23 1
- 25 1
- 31 1
- 41 1
- 45 1
- 51 1
- 52 1
- 70 1
- 71 1
- 73 1
- 75 1
- 82 1
- 84 1
- 85 1
- 93 1
- 101 1
- 103 1
- 104 1
- 113 1
- 115 1
- 116 1
- 118 1
- 122 1
- 124 1
- 127 1
- 131 1
- 132 1
- 135 1
- 139 1
- 147 1
- 149 1
- 152 1
- 161 1
- 169 1
- 178 1
- 183 1
- 189 1
- 193 1
- 195 1
- 204 1
- 210 1
- 211 1
- 214 1
- 238 1
- 242 1
- 246 1
- 259 1
- 263 1
- 264 1
- 267 1
- 270 1
- 271 1
- 274 1
- 277 1
- 279 1
- 280 1
- 285 1
- 287 1
- 291 1
- 297 1
- 302 1
- 314 1
state 1
- Iowa 788
fips 1
- 19013 · 788 ✖
county 1
- Black Hawk 788
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3391 | 3391 | 2020-03-17 | Black Hawk | Iowa | 19013 | 1 | 0 |
3965 | 3965 | 2020-03-18 | Black Hawk | Iowa | 19013 | 1 | 0 |
4644 | 4644 | 2020-03-19 | Black Hawk | Iowa | 19013 | 1 | 0 |
5455 | 5455 | 2020-03-20 | Black Hawk | Iowa | 19013 | 1 | 0 |
6396 | 6396 | 2020-03-21 | Black Hawk | Iowa | 19013 | 3 | 0 |
7456 | 7456 | 2020-03-22 | Black Hawk | Iowa | 19013 | 3 | 0 |
8614 | 8614 | 2020-03-23 | Black Hawk | Iowa | 19013 | 3 | 0 |
9890 | 9890 | 2020-03-24 | Black Hawk | Iowa | 19013 | 4 | 0 |
11287 | 11287 | 2020-03-25 | Black Hawk | Iowa | 19013 | 4 | 0 |
12849 | 12849 | 2020-03-26 | Black Hawk | Iowa | 19013 | 5 | 0 |
14536 | 14536 | 2020-03-27 | Black Hawk | Iowa | 19013 | 7 | 0 |
16339 | 16339 | 2020-03-28 | Black Hawk | Iowa | 19013 | 6 | 0 |
18244 | 18244 | 2020-03-29 | Black Hawk | Iowa | 19013 | 6 | 0 |
20251 | 20251 | 2020-03-30 | Black Hawk | Iowa | 19013 | 6 | 0 |
22346 | 22346 | 2020-03-31 | Black Hawk | Iowa | 19013 | 7 | 0 |
24518 | 24518 | 2020-04-01 | Black Hawk | Iowa | 19013 | 7 | 0 |
26758 | 26758 | 2020-04-02 | Black Hawk | Iowa | 19013 | 8 | 0 |
29069 | 29069 | 2020-04-03 | Black Hawk | Iowa | 19013 | 8 | 0 |
31437 | 31437 | 2020-04-04 | Black Hawk | Iowa | 19013 | 10 | 0 |
33848 | 33848 | 2020-04-05 | Black Hawk | Iowa | 19013 | 12 | 0 |
36301 | 36301 | 2020-04-06 | Black Hawk | Iowa | 19013 | 12 | 0 |
38799 | 38799 | 2020-04-07 | Black Hawk | Iowa | 19013 | 15 | 0 |
41345 | 41345 | 2020-04-08 | Black Hawk | Iowa | 19013 | 19 | 0 |
43921 | 43921 | 2020-04-09 | Black Hawk | Iowa | 19013 | 21 | 0 |
46526 | 46526 | 2020-04-10 | Black Hawk | Iowa | 19013 | 35 | 0 |
49160 | 49160 | 2020-04-11 | Black Hawk | Iowa | 19013 | 41 | 0 |
51824 | 51824 | 2020-04-12 | Black Hawk | Iowa | 19013 | 47 | 0 |
54505 | 54505 | 2020-04-13 | Black Hawk | Iowa | 19013 | 62 | 0 |
57198 | 57198 | 2020-04-14 | Black Hawk | Iowa | 19013 | 78 | 0 |
59906 | 59906 | 2020-04-15 | Black Hawk | Iowa | 19013 | 85 | 0 |
62627 | 62627 | 2020-04-16 | Black Hawk | Iowa | 19013 | 109 | 0 |
65361 | 65361 | 2020-04-17 | Black Hawk | Iowa | 19013 | 138 | 1 |
68110 | 68110 | 2020-04-18 | Black Hawk | Iowa | 19013 | 166 | 1 |
70872 | 70872 | 2020-04-19 | Black Hawk | Iowa | 19013 | 192 | 1 |
73643 | 73643 | 2020-04-20 | Black Hawk | Iowa | 19013 | 259 | 2 |
76420 | 76420 | 2020-04-21 | Black Hawk | Iowa | 19013 | 366 | 2 |
79204 | 79204 | 2020-04-22 | Black Hawk | Iowa | 19013 | 379 | 2 |
81997 | 81997 | 2020-04-23 | Black Hawk | Iowa | 19013 | 420 | 4 |
84797 | 84797 | 2020-04-24 | Black Hawk | Iowa | 19013 | 530 | 7 |
87607 | 87607 | 2020-04-25 | Black Hawk | Iowa | 19013 | 692 | 8 |
90423 | 90423 | 2020-04-26 | Black Hawk | Iowa | 19013 | 715 | 9 |
93242 | 93242 | 2020-04-27 | Black Hawk | Iowa | 19013 | 844 | 11 |
96074 | 96074 | 2020-04-28 | Black Hawk | Iowa | 19013 | 941 | 12 |
98918 | 98918 | 2020-04-29 | Black Hawk | Iowa | 19013 | 1082 | 13 |
101769 | 101769 | 2020-04-30 | Black Hawk | Iowa | 19013 | 1140 | 13 |
104625 | 104625 | 2020-05-01 | Black Hawk | Iowa | 19013 | 1195 | 13 |
107490 | 107490 | 2020-05-02 | Black Hawk | Iowa | 19013 | 1255 | 13 |
110360 | 110360 | 2020-05-03 | Black Hawk | Iowa | 19013 | 1306 | 15 |
113235 | 113235 | 2020-05-04 | Black Hawk | Iowa | 19013 | 1361 | 15 |
116118 | 116118 | 2020-05-05 | Black Hawk | Iowa | 19013 | 1378 | 18 |
119078 | 119078 | 2020-05-06 | Black Hawk | Iowa | 19013 | 1396 | 19 |
122048 | 122048 | 2020-05-07 | Black Hawk | Iowa | 19013 | 1450 | 19 |
125028 | 125028 | 2020-05-08 | Black Hawk | Iowa | 19013 | 1463 | 20 |
128015 | 128015 | 2020-05-09 | Black Hawk | Iowa | 19013 | 1477 | 20 |
131006 | 131006 | 2020-05-10 | Black Hawk | Iowa | 19013 | 1493 | 23 |
133996 | 133996 | 2020-05-11 | Black Hawk | Iowa | 19013 | 1512 | 25 |
136985 | 136985 | 2020-05-12 | Black Hawk | Iowa | 19013 | 1521 | 28 |
139977 | 139977 | 2020-05-13 | Black Hawk | Iowa | 19013 | 1528 | 28 |
142973 | 142973 | 2020-05-14 | Black Hawk | Iowa | 19013 | 1533 | 29 |
145973 | 145973 | 2020-05-15 | Black Hawk | Iowa | 19013 | 1548 | 29 |
148977 | 148977 | 2020-05-16 | Black Hawk | Iowa | 19013 | 1571 | 29 |
151987 | 151987 | 2020-05-17 | Black Hawk | Iowa | 19013 | 1587 | 30 |
154999 | 154999 | 2020-05-18 | Black Hawk | Iowa | 19013 | 1603 | 30 |
158015 | 158015 | 2020-05-19 | Black Hawk | Iowa | 19013 | 1628 | 31 |
161041 | 161041 | 2020-05-20 | Black Hawk | Iowa | 19013 | 1643 | 37 |
164069 | 164069 | 2020-05-21 | Black Hawk | Iowa | 19013 | 1655 | 37 |
167102 | 167102 | 2020-05-22 | Black Hawk | Iowa | 19013 | 1663 | 37 |
170139 | 170139 | 2020-05-23 | Black Hawk | Iowa | 19013 | 1663 | 37 |
173180 | 173180 | 2020-05-24 | Black Hawk | Iowa | 19013 | 1680 | 39 |
176224 | 176224 | 2020-05-25 | Black Hawk | Iowa | 19013 | 1686 | 39 |
179268 | 179268 | 2020-05-26 | Black Hawk | Iowa | 19013 | 1696 | 41 |
182312 | 182312 | 2020-05-27 | Black Hawk | Iowa | 19013 | 1713 | 43 |
185366 | 185366 | 2020-05-28 | Black Hawk | Iowa | 19013 | 1724 | 43 |
188424 | 188424 | 2020-05-29 | Black Hawk | Iowa | 19013 | 1730 | 44 |
191489 | 191489 | 2020-05-30 | Black Hawk | Iowa | 19013 | 1743 | 44 |
194556 | 194556 | 2020-05-31 | Black Hawk | Iowa | 19013 | 1747 | 44 |
197626 | 197626 | 2020-06-01 | Black Hawk | Iowa | 19013 | 1750 | 45 |
200699 | 200699 | 2020-06-02 | Black Hawk | Iowa | 19013 | 1759 | 46 |
203775 | 203775 | 2020-06-03 | Black Hawk | Iowa | 19013 | 1759 | 46 |
206855 | 206855 | 2020-06-04 | Black Hawk | Iowa | 19013 | 1776 | 49 |
209936 | 209936 | 2020-06-05 | Black Hawk | Iowa | 19013 | 1788 | 49 |
213021 | 213021 | 2020-06-06 | Black Hawk | Iowa | 19013 | 1791 | 50 |
216108 | 216108 | 2020-06-07 | Black Hawk | Iowa | 19013 | 1800 | 50 |
219200 | 219200 | 2020-06-08 | Black Hawk | Iowa | 19013 | 1801 | 51 |
222295 | 222295 | 2020-06-09 | Black Hawk | Iowa | 19013 | 1802 | 52 |
225390 | 225390 | 2020-06-10 | Black Hawk | Iowa | 19013 | 1817 | 53 |
228492 | 228492 | 2020-06-11 | Black Hawk | Iowa | 19013 | 1821 | 53 |
231595 | 231595 | 2020-06-12 | Black Hawk | Iowa | 19013 | 1825 | 53 |
234701 | 234701 | 2020-06-13 | Black Hawk | Iowa | 19013 | 1830 | 53 |
237808 | 237808 | 2020-06-14 | Black Hawk | Iowa | 19013 | 1834 | 53 |
240916 | 240916 | 2020-06-15 | Black Hawk | Iowa | 19013 | 1836 | 55 |
244027 | 244027 | 2020-06-16 | Black Hawk | Iowa | 19013 | 1840 | 55 |
247140 | 247140 | 2020-06-17 | Black Hawk | Iowa | 19013 | 1846 | 56 |
250252 | 250252 | 2020-06-18 | Black Hawk | Iowa | 19013 | 1866 | 56 |
253367 | 253367 | 2020-06-19 | Black Hawk | Iowa | 19013 | 1876 | 56 |
256487 | 256487 | 2020-06-20 | Black Hawk | Iowa | 19013 | 1883 | 56 |
259613 | 259613 | 2020-06-21 | Black Hawk | Iowa | 19013 | 1895 | 56 |
262740 | 262740 | 2020-06-22 | Black Hawk | Iowa | 19013 | 1899 | 56 |
265868 | 265868 | 2020-06-23 | Black Hawk | Iowa | 19013 | 1914 | 56 |
268998 | 268998 | 2020-06-24 | Black Hawk | Iowa | 19013 | 1932 | 56 |
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);