ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 19061 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 491 ✖
- 13561 7
- 13575 7
- 13595 7
- 13627 7
- 13670 7
- 13763 7
- 13875 7
- 14020 7
- 14164 7
- 14313 7
- 14553 7
- 14795 7
- 15022 7
- 15269 7
- 15590 7
- 15851 7
- 16210 7
- 16662 7
- 17257 7
- 17933 7
- 18584 7
- 19058 7
- 19582 7
- 19978 7
- 20315 7
- 20646 7
- 21223 7
- 22137 7
- 23138 7
- 23791 7
- 24764 7
- 25199 7
- 25432 7
- 25671 7
- 25773 7
- 25837 7
- 25850 7
- 25881 7
- 25897 7
- 25922 7
- 25946 7
- 25987 7
- 26053 7
- 26176 7
- 12202 6
- 6 4
- 35 3
- 12344 3
- 12431 3
- 26325 3
- 1 2
- 21 2
- 22 2
- 24 2
- 28 2
- 32 2
- 307 2
- 344 2
- 384 2
- 13399 2
- 13450 2
- 13475 2
- 13496 2
- 13536 2
- 13540 2
- 2 1
- 4 1
- 8 1
- 12 1
- 16 1
- 23 1
- 25 1
- 31 1
- 37 1
- 39 1
- 40 1
- 43 1
- 44 1
- 46 1
- 48 1
- 49 1
- 52 1
- 62 1
- 70 1
- 80 1
- 87 1
- 88 1
- 97 1
- 102 1
- 109 1
- 125 1
- 136 1
- 152 1
- 156 1
- 162 1
- 175 1
- 181 1
- 188 1
- 191 1
- 197 1
- 203 1
- 235 1
- 238 1
- 249 1
- 258 1
- 264 1
- 276 1
- 286 1
- 297 1
- 300 1
- 321 1
- 324 1
- 325 1
- 331 1
- 338 1
- 343 1
- 347 1
- 350 1
- 352 1
- 356 1
- 360 1
- 362 1
- 364 1
- 370 1
- 371 1
- 372 1
- 378 1
- 383 1
- 388 1
- 391 1
- 395 1
- 398 1
- 411 1
- 412 1
- 417 1
- 424 1
- 454 1
- 469 1
- 483 1
- 491 1
- 497 1
- 500 1
- 501 1
- 523 1
- 546 1
- 609 1
- 627 1
- 685 1
- 700 1
- 702 1
- 742 1
- 773 1
- 835 1
- 920 1
- 941 1
- 978 1
- 1000 1
- 1022 1
- 1054 1
- 1122 1
- 1136 1
- 1170 1
- 1189 1
- 1215 1
- 1237 1
- 1265 1
- 1301 1
- 1324 1
- 1340 1
- 1355 1
- 1368 1
- 1384 1
- 1416 1
- 1452 1
- 1484 1
- 1503 1
- 1527 1
- 1537 1
- 1549 1
- 1594 1
- 1623 1
- 1647 1
- 1665 1
- 1676 1
- 1686 1
- 1698 1
- 1722 1
- 1744 1
- 1773 1
- 1795 1
- 1797 1
- 1816 1
- 1823 1
- 1849 1
- 1868 1
- 1885 1
- 1899 1
- 1903 1
- 1907 1
- 1920 1
- 1938 1
- 1966 1
- 1984 1
- 2016 1
- 2027 1
- 2039 1
- 2049 1
- 2064 1
- 2106 1
- 2139 1
- 2165 1
- 2179 1
- 2197 1
- 2226 1
- 2263 1
- 2296 1
- 2340 1
- 2372 1
- 2384 1
- 2416 1
- 2436 1
- 2501 1
- 2568 1
- 2661 1
- 2760 1
- 2798 1
- 2823 1
- 2894 1
- 2991 1
- 3101 1
- 3173 1
- 3257 1
- 3283 1
- 3332 1
- 3402 1
- 3474 1
- 3539 1
- 3605 1
- 3696 1
- 3714 1
- 3751 1
- 3778 1
- 3877 1
- 3940 1
- 4037 1
- 4108 1
- 4157 1
- 4183 1
- 4273 1
- 4341 1
- 4441 1
- 4528 1
- 4601 1
- 4638 1
- 4679 1
- 4764 1
- 4809 1
- 4936 1
- 5030 1
- 5116 1
- 5186 1
- 5211 1
- 5310 1
- 5397 1
- 5511 1
- 5645 1
- 5769 1
- 5857 1
- 5934 1
- 6038 1
- 6127 1
- 6333 1
- 6477 1
- 6662 1
- 6881 1
- 6943 1
- 7135 1
- 7218 1
- 7388 1
- 7600 1
- 7744 1
- 7835 1
- 7885 1
- 8068 1
- 8200 1
- 8323 1
- 8476 1
- 8580 1
- 8664 1
- 8792 1
- 8865 1
- 9040 1
- 9077 1
- 9134 1
- 9181 1
- 9234 1
- 9272 1
- 9342 1
- 9415 1
- 9479 1
- 9547 1
- 9618 1
- 9656 1
- 9680 1
- 9699 1
- 9762 1
- 9828 1
- 9891 1
- 9940 1
- 9984 1
- 10008 1
- 10037 1
- 10109 1
- 10148 1
- 10193 1
- 10233 1
- 10235 1
- 10266 1
- 10308 1
- 10345 1
- 10400 1
- 10428 1
- 10439 1
- 10452 1
- 10482 1
- 10554 1
- 10568 1
- 10615 1
- 10653 1
- 10683 1
- 10719 1
- 10744 1
- 10787 1
- 10866 1
- 10952 1
- 11036 1
- 11079 1
- 11087 1
- 11112 1
- 11138 1
- 11204 1
- 11229 1
- 11276 1
- 11301 1
- 11311 1
- 11348 1
- 11387 1
- 11434 1
- 11504 1
- 11535 1
- 11615 1
- 11625 1
- 11650 1
- 11678 1
- 11743 1
- 11760 1
- 11780 1
- 11821 1
- 11830 1
- 11837 1
- 11872 1
- 11911 1
- 11935 1
- 11944 1
- 11958 1
- 11966 1
- 11991 1
- 12034 1
- 12058 1
- 12068 1
- 12106 1
- 12118 1
- 12126 1
- 12133 1
- 12153 1
- 12179 1
- 12194 1
- 12330 1
- 12367 1
- 12388 1
- 12407 1
- 12419 1
- 12452 1
- 12457 1
- 12482 1
- 12489 1
- 12500 1
- 12504 1
- 12507 1
- 12514 1
- 12522 1
- 12531 1
- 12544 1
- 12550 1
- 12558 1
- 12562 1
- 12577 1
- 12601 1
- 12624 1
- 12647 1
- 12660 1
- 12670 1
- 12677 1
- 12692 1
- 12718 1
- 12751 1
- 12779 1
- 12807 1
- 12827 1
- 12838 1
- 12868 1
- 12913 1
- 12929 1
- 12958 1
- 12985 1
- 13002 1
- 13033 1
- 13035 1
- 13066 1
- 13097 1
- 13116 1
- 13127 1
- 13153 1
- 13160 1
- 13168 1
- 13182 1
- 13199 1
- 13209 1
- 13222 1
- 13227 1
- 13232 1
- 13238 1
- 13250 1
- 13265 1
- 13273 1
- 13279 1
- 13289 1
- 13292 1
- 13298 1
- 13307 1
- 13321 1
- 13326 1
- 13333 1
- 13345 1
- 13348 1
- 13351 1
- 13354 1
- 13359 1
- 13367 1
- 13372 1
- 13379 1
- 13382 1
- 13385 1
- 13390 1
- 13404 1
- 13407 1
- 13413 1
- 13419 1
- 13430 1
- 13442 1
- 13443 1
- 13444 1
- 13446 1
- 13448 1
- 13464 1
- 13468 1
- 13469 1
- 13476 1
- 13481 1
- 13482 1
- 13486 1
- 13492 1
- 13500 1
- 13504 1
- 13505 1
- 13506 1
- 13508 1
- 13509 1
- 13510 1
- 13513 1
- 13515 1
- 13518 1
- 13519 1
- 13522 1
- 13524 1
- 13527 1
- 13529 1
- 13535 1
- 13538 1
- 13539 1
- 13543 1
state 1
- Iowa 786
fips 1
- 19061 · 786 ✖
county 1
- Dubuque 786
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4647 | 4647 | 2020-03-19 | Dubuque | Iowa | 19061 | 1 | 0 |
5458 | 5458 | 2020-03-20 | Dubuque | Iowa | 19061 | 1 | 0 |
6399 | 6399 | 2020-03-21 | Dubuque | Iowa | 19061 | 2 | 0 |
7460 | 7460 | 2020-03-22 | Dubuque | Iowa | 19061 | 4 | 0 |
8618 | 8618 | 2020-03-23 | Dubuque | Iowa | 19061 | 6 | 0 |
9896 | 9896 | 2020-03-24 | Dubuque | Iowa | 19061 | 6 | 1 |
11293 | 11293 | 2020-03-25 | Dubuque | Iowa | 19061 | 6 | 1 |
12857 | 12857 | 2020-03-26 | Dubuque | Iowa | 19061 | 6 | 1 |
14547 | 14547 | 2020-03-27 | Dubuque | Iowa | 19061 | 8 | 1 |
16351 | 16351 | 2020-03-28 | Dubuque | Iowa | 19061 | 12 | 1 |
18256 | 18256 | 2020-03-29 | Dubuque | Iowa | 19061 | 16 | 1 |
20264 | 20264 | 2020-03-30 | Dubuque | Iowa | 19061 | 21 | 1 |
22360 | 22360 | 2020-03-31 | Dubuque | Iowa | 19061 | 21 | 1 |
24532 | 24532 | 2020-04-01 | Dubuque | Iowa | 19061 | 22 | 1 |
26773 | 26773 | 2020-04-02 | Dubuque | Iowa | 19061 | 22 | 1 |
29084 | 29084 | 2020-04-03 | Dubuque | Iowa | 19061 | 23 | 1 |
31452 | 31452 | 2020-04-04 | Dubuque | Iowa | 19061 | 24 | 1 |
33864 | 33864 | 2020-04-05 | Dubuque | Iowa | 19061 | 24 | 1 |
36318 | 36318 | 2020-04-06 | Dubuque | Iowa | 19061 | 25 | 1 |
38818 | 38818 | 2020-04-07 | Dubuque | Iowa | 19061 | 28 | 1 |
41364 | 41364 | 2020-04-08 | Dubuque | Iowa | 19061 | 28 | 1 |
43940 | 43940 | 2020-04-09 | Dubuque | Iowa | 19061 | 31 | 1 |
46545 | 46545 | 2020-04-10 | Dubuque | Iowa | 19061 | 32 | 1 |
49179 | 49179 | 2020-04-11 | Dubuque | Iowa | 19061 | 32 | 1 |
51843 | 51843 | 2020-04-12 | Dubuque | Iowa | 19061 | 35 | 1 |
54525 | 54525 | 2020-04-13 | Dubuque | Iowa | 19061 | 35 | 1 |
57218 | 57218 | 2020-04-14 | Dubuque | Iowa | 19061 | 35 | 1 |
59926 | 59926 | 2020-04-15 | Dubuque | Iowa | 19061 | 37 | 1 |
62647 | 62647 | 2020-04-16 | Dubuque | Iowa | 19061 | 39 | 1 |
65381 | 65381 | 2020-04-17 | Dubuque | Iowa | 19061 | 40 | 1 |
68130 | 68130 | 2020-04-18 | Dubuque | Iowa | 19061 | 43 | 1 |
70892 | 70892 | 2020-04-19 | Dubuque | Iowa | 19061 | 44 | 1 |
73663 | 73663 | 2020-04-20 | Dubuque | Iowa | 19061 | 46 | 1 |
76441 | 76441 | 2020-04-21 | Dubuque | Iowa | 19061 | 48 | 1 |
79225 | 79225 | 2020-04-22 | Dubuque | Iowa | 19061 | 49 | 1 |
82018 | 82018 | 2020-04-23 | Dubuque | Iowa | 19061 | 52 | 1 |
84818 | 84818 | 2020-04-24 | Dubuque | Iowa | 19061 | 62 | 1 |
87628 | 87628 | 2020-04-25 | Dubuque | Iowa | 19061 | 70 | 1 |
90444 | 90444 | 2020-04-26 | Dubuque | Iowa | 19061 | 80 | 1 |
93263 | 93263 | 2020-04-27 | Dubuque | Iowa | 19061 | 87 | 2 |
96095 | 96095 | 2020-04-28 | Dubuque | Iowa | 19061 | 88 | 2 |
98940 | 98940 | 2020-04-29 | Dubuque | Iowa | 19061 | 97 | 3 |
101791 | 101791 | 2020-04-30 | Dubuque | Iowa | 19061 | 102 | 4 |
104648 | 104648 | 2020-05-01 | Dubuque | Iowa | 19061 | 109 | 4 |
107513 | 107513 | 2020-05-02 | Dubuque | Iowa | 19061 | 125 | 4 |
110383 | 110383 | 2020-05-03 | Dubuque | Iowa | 19061 | 136 | 5 |
113258 | 113258 | 2020-05-04 | Dubuque | Iowa | 19061 | 152 | 5 |
116141 | 116141 | 2020-05-05 | Dubuque | Iowa | 19061 | 156 | 5 |
119101 | 119101 | 2020-05-06 | Dubuque | Iowa | 19061 | 162 | 5 |
122071 | 122071 | 2020-05-07 | Dubuque | Iowa | 19061 | 175 | 5 |
125051 | 125051 | 2020-05-08 | Dubuque | Iowa | 19061 | 181 | 6 |
128038 | 128038 | 2020-05-09 | Dubuque | Iowa | 19061 | 188 | 6 |
131029 | 131029 | 2020-05-10 | Dubuque | Iowa | 19061 | 191 | 7 |
134019 | 134019 | 2020-05-11 | Dubuque | Iowa | 19061 | 197 | 7 |
137008 | 137008 | 2020-05-12 | Dubuque | Iowa | 19061 | 203 | 7 |
140000 | 140000 | 2020-05-13 | Dubuque | Iowa | 19061 | 235 | 9 |
142996 | 142996 | 2020-05-14 | Dubuque | Iowa | 19061 | 238 | 10 |
145996 | 145996 | 2020-05-15 | Dubuque | Iowa | 19061 | 249 | 10 |
149000 | 149000 | 2020-05-16 | Dubuque | Iowa | 19061 | 258 | 10 |
152010 | 152010 | 2020-05-17 | Dubuque | Iowa | 19061 | 264 | 10 |
155022 | 155022 | 2020-05-18 | Dubuque | Iowa | 19061 | 276 | 10 |
158038 | 158038 | 2020-05-19 | Dubuque | Iowa | 19061 | 286 | 10 |
161064 | 161064 | 2020-05-20 | Dubuque | Iowa | 19061 | 297 | 13 |
164092 | 164092 | 2020-05-21 | Dubuque | Iowa | 19061 | 300 | 14 |
167125 | 167125 | 2020-05-22 | Dubuque | Iowa | 19061 | 307 | 16 |
170162 | 170162 | 2020-05-23 | Dubuque | Iowa | 19061 | 307 | 16 |
173203 | 173203 | 2020-05-24 | Dubuque | Iowa | 19061 | 321 | 16 |
176247 | 176247 | 2020-05-25 | Dubuque | Iowa | 19061 | 324 | 16 |
179291 | 179291 | 2020-05-26 | Dubuque | Iowa | 19061 | 325 | 16 |
182336 | 182336 | 2020-05-27 | Dubuque | Iowa | 19061 | 331 | 16 |
185390 | 185390 | 2020-05-28 | Dubuque | Iowa | 19061 | 338 | 18 |
188448 | 188448 | 2020-05-29 | Dubuque | Iowa | 19061 | 344 | 18 |
191513 | 191513 | 2020-05-30 | Dubuque | Iowa | 19061 | 343 | 18 |
194580 | 194580 | 2020-05-31 | Dubuque | Iowa | 19061 | 344 | 18 |
197650 | 197650 | 2020-06-01 | Dubuque | Iowa | 19061 | 347 | 19 |
200723 | 200723 | 2020-06-02 | Dubuque | Iowa | 19061 | 350 | 21 |
203799 | 203799 | 2020-06-03 | Dubuque | Iowa | 19061 | 352 | 21 |
206879 | 206879 | 2020-06-04 | Dubuque | Iowa | 19061 | 356 | 21 |
209960 | 209960 | 2020-06-05 | Dubuque | Iowa | 19061 | 360 | 21 |
213045 | 213045 | 2020-06-06 | Dubuque | Iowa | 19061 | 362 | 21 |
216132 | 216132 | 2020-06-07 | Dubuque | Iowa | 19061 | 364 | 21 |
219224 | 219224 | 2020-06-08 | Dubuque | Iowa | 19061 | 370 | 21 |
222319 | 222319 | 2020-06-09 | Dubuque | Iowa | 19061 | 372 | 21 |
225414 | 225414 | 2020-06-10 | Dubuque | Iowa | 19061 | 371 | 21 |
228516 | 228516 | 2020-06-11 | Dubuque | Iowa | 19061 | 378 | 21 |
231619 | 231619 | 2020-06-12 | Dubuque | Iowa | 19061 | 383 | 21 |
234725 | 234725 | 2020-06-13 | Dubuque | Iowa | 19061 | 384 | 21 |
237832 | 237832 | 2020-06-14 | Dubuque | Iowa | 19061 | 384 | 21 |
240940 | 240940 | 2020-06-15 | Dubuque | Iowa | 19061 | 388 | 22 |
244051 | 244051 | 2020-06-16 | Dubuque | Iowa | 19061 | 391 | 22 |
247164 | 247164 | 2020-06-17 | Dubuque | Iowa | 19061 | 395 | 22 |
250276 | 250276 | 2020-06-18 | Dubuque | Iowa | 19061 | 398 | 22 |
253391 | 253391 | 2020-06-19 | Dubuque | Iowa | 19061 | 412 | 22 |
256511 | 256511 | 2020-06-20 | Dubuque | Iowa | 19061 | 411 | 22 |
259637 | 259637 | 2020-06-21 | Dubuque | Iowa | 19061 | 417 | 22 |
262764 | 262764 | 2020-06-22 | Dubuque | Iowa | 19061 | 424 | 22 |
265892 | 265892 | 2020-06-23 | Dubuque | Iowa | 19061 | 454 | 22 |
269022 | 269022 | 2020-06-24 | Dubuque | Iowa | 19061 | 469 | 22 |
272159 | 272159 | 2020-06-25 | Dubuque | Iowa | 19061 | 483 | 22 |
275301 | 275301 | 2020-06-26 | Dubuque | Iowa | 19061 | 491 | 22 |
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);