ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 19061 and state = "Iowa" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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);