ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Louisa" and state = "Iowa" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
29100 | 29100 | 2020-04-03 | Louisa | Iowa | 19115 | 1 | 0 |
31471 | 31471 | 2020-04-04 | Louisa | Iowa | 19115 | 1 | 0 |
33884 | 33884 | 2020-04-05 | Louisa | Iowa | 19115 | 6 | 0 |
36339 | 36339 | 2020-04-06 | Louisa | Iowa | 19115 | 7 | 0 |
38840 | 38840 | 2020-04-07 | Louisa | Iowa | 19115 | 20 | 0 |
41386 | 41386 | 2020-04-08 | Louisa | Iowa | 19115 | 30 | 0 |
43962 | 43962 | 2020-04-09 | Louisa | Iowa | 19115 | 41 | 0 |
46567 | 46567 | 2020-04-10 | Louisa | Iowa | 19115 | 56 | 0 |
49201 | 49201 | 2020-04-11 | Louisa | Iowa | 19115 | 70 | 0 |
51865 | 51865 | 2020-04-12 | Louisa | Iowa | 19115 | 76 | 0 |
54547 | 54547 | 2020-04-13 | Louisa | Iowa | 19115 | 79 | 0 |
57240 | 57240 | 2020-04-14 | Louisa | Iowa | 19115 | 149 | 0 |
59948 | 59948 | 2020-04-15 | Louisa | Iowa | 19115 | 166 | 0 |
62669 | 62669 | 2020-04-16 | Louisa | Iowa | 19115 | 166 | 1 |
65403 | 65403 | 2020-04-17 | Louisa | Iowa | 19115 | 169 | 1 |
68152 | 68152 | 2020-04-18 | Louisa | Iowa | 19115 | 177 | 2 |
70914 | 70914 | 2020-04-19 | Louisa | Iowa | 19115 | 213 | 2 |
73685 | 73685 | 2020-04-20 | Louisa | Iowa | 19115 | 216 | 2 |
76464 | 76464 | 2020-04-21 | Louisa | Iowa | 19115 | 243 | 2 |
79248 | 79248 | 2020-04-22 | Louisa | Iowa | 19115 | 249 | 2 |
82041 | 82041 | 2020-04-23 | Louisa | Iowa | 19115 | 252 | 2 |
84841 | 84841 | 2020-04-24 | Louisa | Iowa | 19115 | 260 | 2 |
87651 | 87651 | 2020-04-25 | Louisa | Iowa | 19115 | 262 | 2 |
90467 | 90467 | 2020-04-26 | Louisa | Iowa | 19115 | 267 | 2 |
93286 | 93286 | 2020-04-27 | Louisa | Iowa | 19115 | 267 | 2 |
96118 | 96118 | 2020-04-28 | Louisa | Iowa | 19115 | 269 | 2 |
98963 | 98963 | 2020-04-29 | Louisa | Iowa | 19115 | 269 | 2 |
101814 | 101814 | 2020-04-30 | Louisa | Iowa | 19115 | 269 | 2 |
104672 | 104672 | 2020-05-01 | Louisa | Iowa | 19115 | 274 | 2 |
107537 | 107537 | 2020-05-02 | Louisa | Iowa | 19115 | 277 | 2 |
110407 | 110407 | 2020-05-03 | Louisa | Iowa | 19115 | 277 | 2 |
113282 | 113282 | 2020-05-04 | Louisa | Iowa | 19115 | 277 | 2 |
116165 | 116165 | 2020-05-05 | Louisa | Iowa | 19115 | 279 | 2 |
119125 | 119125 | 2020-05-06 | Louisa | Iowa | 19115 | 279 | 2 |
122095 | 122095 | 2020-05-07 | Louisa | Iowa | 19115 | 280 | 2 |
125076 | 125076 | 2020-05-08 | Louisa | Iowa | 19115 | 281 | 3 |
128063 | 128063 | 2020-05-09 | Louisa | Iowa | 19115 | 282 | 3 |
131054 | 131054 | 2020-05-10 | Louisa | Iowa | 19115 | 282 | 3 |
134044 | 134044 | 2020-05-11 | Louisa | Iowa | 19115 | 285 | 3 |
137034 | 137034 | 2020-05-12 | Louisa | Iowa | 19115 | 287 | 3 |
140027 | 140027 | 2020-05-13 | Louisa | Iowa | 19115 | 289 | 3 |
143023 | 143023 | 2020-05-14 | Louisa | Iowa | 19115 | 291 | 3 |
146023 | 146023 | 2020-05-15 | Louisa | Iowa | 19115 | 304 | 3 |
149027 | 149027 | 2020-05-16 | Louisa | Iowa | 19115 | 306 | 3 |
152037 | 152037 | 2020-05-17 | Louisa | Iowa | 19115 | 307 | 3 |
155049 | 155049 | 2020-05-18 | Louisa | Iowa | 19115 | 310 | 3 |
158065 | 158065 | 2020-05-19 | Louisa | Iowa | 19115 | 315 | 4 |
161091 | 161091 | 2020-05-20 | Louisa | Iowa | 19115 | 323 | 6 |
164119 | 164119 | 2020-05-21 | Louisa | Iowa | 19115 | 326 | 6 |
167152 | 167152 | 2020-05-22 | Louisa | Iowa | 19115 | 330 | 7 |
170189 | 170189 | 2020-05-23 | Louisa | Iowa | 19115 | 330 | 7 |
173230 | 173230 | 2020-05-24 | Louisa | Iowa | 19115 | 334 | 7 |
176274 | 176274 | 2020-05-25 | Louisa | Iowa | 19115 | 335 | 7 |
179318 | 179318 | 2020-05-26 | Louisa | Iowa | 19115 | 336 | 9 |
182363 | 182363 | 2020-05-27 | Louisa | Iowa | 19115 | 336 | 10 |
188475 | 188475 | 2020-05-29 | Louisa | Iowa | 19115 | 341 | 11 |
185417 | 185417 | 2020-05-28 | Louisa | Iowa | 19115 | 342 | 10 |
191540 | 191540 | 2020-05-30 | Louisa | Iowa | 19115 | 343 | 11 |
194607 | 194607 | 2020-05-31 | Louisa | Iowa | 19115 | 344 | 11 |
197677 | 197677 | 2020-06-01 | Louisa | Iowa | 19115 | 346 | 11 |
200750 | 200750 | 2020-06-02 | Louisa | Iowa | 19115 | 346 | 11 |
203826 | 203826 | 2020-06-03 | Louisa | Iowa | 19115 | 347 | 11 |
206906 | 206906 | 2020-06-04 | Louisa | Iowa | 19115 | 350 | 11 |
209987 | 209987 | 2020-06-05 | Louisa | Iowa | 19115 | 350 | 11 |
213072 | 213072 | 2020-06-06 | Louisa | Iowa | 19115 | 350 | 11 |
216159 | 216159 | 2020-06-07 | Louisa | Iowa | 19115 | 350 | 11 |
219251 | 219251 | 2020-06-08 | Louisa | Iowa | 19115 | 350 | 11 |
222346 | 222346 | 2020-06-09 | Louisa | Iowa | 19115 | 352 | 11 |
225441 | 225441 | 2020-06-10 | Louisa | Iowa | 19115 | 354 | 11 |
247191 | 247191 | 2020-06-17 | Louisa | Iowa | 19115 | 354 | 13 |
250303 | 250303 | 2020-06-18 | Louisa | Iowa | 19115 | 354 | 13 |
253418 | 253418 | 2020-06-19 | Louisa | Iowa | 19115 | 354 | 13 |
256538 | 256538 | 2020-06-20 | Louisa | Iowa | 19115 | 354 | 13 |
228543 | 228543 | 2020-06-11 | Louisa | Iowa | 19115 | 355 | 11 |
231646 | 231646 | 2020-06-12 | Louisa | Iowa | 19115 | 355 | 11 |
234752 | 234752 | 2020-06-13 | Louisa | Iowa | 19115 | 355 | 11 |
237859 | 237859 | 2020-06-14 | Louisa | Iowa | 19115 | 355 | 11 |
240967 | 240967 | 2020-06-15 | Louisa | Iowa | 19115 | 355 | 12 |
244078 | 244078 | 2020-06-16 | Louisa | Iowa | 19115 | 355 | 12 |
262791 | 262791 | 2020-06-22 | Louisa | Iowa | 19115 | 355 | 13 |
269049 | 269049 | 2020-06-24 | Louisa | Iowa | 19115 | 355 | 13 |
259664 | 259664 | 2020-06-21 | Louisa | Iowa | 19115 | 356 | 13 |
265919 | 265919 | 2020-06-23 | Louisa | Iowa | 19115 | 356 | 13 |
272186 | 272186 | 2020-06-25 | Louisa | Iowa | 19115 | 357 | 13 |
275328 | 275328 | 2020-06-26 | Louisa | Iowa | 19115 | 358 | 13 |
278476 | 278476 | 2020-06-27 | Louisa | Iowa | 19115 | 358 | 13 |
281624 | 281624 | 2020-06-28 | Louisa | Iowa | 19115 | 359 | 13 |
284769 | 284769 | 2020-06-29 | Louisa | Iowa | 19115 | 359 | 13 |
287918 | 287918 | 2020-06-30 | Louisa | Iowa | 19115 | 360 | 13 |
291068 | 291068 | 2020-07-01 | Louisa | Iowa | 19115 | 360 | 13 |
294222 | 294222 | 2020-07-02 | Louisa | Iowa | 19115 | 360 | 13 |
297380 | 297380 | 2020-07-03 | Louisa | Iowa | 19115 | 360 | 13 |
300542 | 300542 | 2020-07-04 | Louisa | Iowa | 19115 | 360 | 13 |
303706 | 303706 | 2020-07-05 | Louisa | Iowa | 19115 | 361 | 13 |
306871 | 306871 | 2020-07-06 | Louisa | Iowa | 19115 | 362 | 13 |
310039 | 310039 | 2020-07-07 | Louisa | Iowa | 19115 | 363 | 13 |
313209 | 313209 | 2020-07-08 | Louisa | Iowa | 19115 | 363 | 13 |
316383 | 316383 | 2020-07-09 | Louisa | Iowa | 19115 | 363 | 13 |
319556 | 319556 | 2020-07-10 | Louisa | Iowa | 19115 | 365 | 13 |
322735 | 322735 | 2020-07-11 | Louisa | Iowa | 19115 | 365 | 13 |
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);