ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Audubon" and state = "Iowa" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20249 | 20249 | 2020-03-30 | Audubon | Iowa | 19009 | 1 | 0 |
22344 | 22344 | 2020-03-31 | Audubon | Iowa | 19009 | 1 | 0 |
24516 | 24516 | 2020-04-01 | Audubon | Iowa | 19009 | 1 | 0 |
26756 | 26756 | 2020-04-02 | Audubon | Iowa | 19009 | 1 | 0 |
29067 | 29067 | 2020-04-03 | Audubon | Iowa | 19009 | 1 | 0 |
31435 | 31435 | 2020-04-04 | Audubon | Iowa | 19009 | 1 | 0 |
33846 | 33846 | 2020-04-05 | Audubon | Iowa | 19009 | 1 | 0 |
36299 | 36299 | 2020-04-06 | Audubon | Iowa | 19009 | 1 | 0 |
38797 | 38797 | 2020-04-07 | Audubon | Iowa | 19009 | 1 | 0 |
41343 | 41343 | 2020-04-08 | Audubon | Iowa | 19009 | 1 | 0 |
43919 | 43919 | 2020-04-09 | Audubon | Iowa | 19009 | 1 | 0 |
46524 | 46524 | 2020-04-10 | Audubon | Iowa | 19009 | 1 | 0 |
49158 | 49158 | 2020-04-11 | Audubon | Iowa | 19009 | 1 | 0 |
51822 | 51822 | 2020-04-12 | Audubon | Iowa | 19009 | 1 | 0 |
54503 | 54503 | 2020-04-13 | Audubon | Iowa | 19009 | 1 | 0 |
57196 | 57196 | 2020-04-14 | Audubon | Iowa | 19009 | 1 | 0 |
59904 | 59904 | 2020-04-15 | Audubon | Iowa | 19009 | 1 | 0 |
62625 | 62625 | 2020-04-16 | Audubon | Iowa | 19009 | 1 | 0 |
65359 | 65359 | 2020-04-17 | Audubon | Iowa | 19009 | 1 | 0 |
68108 | 68108 | 2020-04-18 | Audubon | Iowa | 19009 | 1 | 0 |
70870 | 70870 | 2020-04-19 | Audubon | Iowa | 19009 | 1 | 0 |
73641 | 73641 | 2020-04-20 | Audubon | Iowa | 19009 | 1 | 0 |
76418 | 76418 | 2020-04-21 | Audubon | Iowa | 19009 | 1 | 0 |
79202 | 79202 | 2020-04-22 | Audubon | Iowa | 19009 | 1 | 0 |
81995 | 81995 | 2020-04-23 | Audubon | Iowa | 19009 | 1 | 0 |
84795 | 84795 | 2020-04-24 | Audubon | Iowa | 19009 | 1 | 0 |
87605 | 87605 | 2020-04-25 | Audubon | Iowa | 19009 | 1 | 0 |
90421 | 90421 | 2020-04-26 | Audubon | Iowa | 19009 | 1 | 0 |
93240 | 93240 | 2020-04-27 | Audubon | Iowa | 19009 | 1 | 0 |
96072 | 96072 | 2020-04-28 | Audubon | Iowa | 19009 | 1 | 0 |
98916 | 98916 | 2020-04-29 | Audubon | Iowa | 19009 | 1 | 0 |
101767 | 101767 | 2020-04-30 | Audubon | Iowa | 19009 | 1 | 0 |
104623 | 104623 | 2020-05-01 | Audubon | Iowa | 19009 | 2 | 0 |
107488 | 107488 | 2020-05-02 | Audubon | Iowa | 19009 | 2 | 0 |
110358 | 110358 | 2020-05-03 | Audubon | Iowa | 19009 | 5 | 0 |
113233 | 113233 | 2020-05-04 | Audubon | Iowa | 19009 | 5 | 0 |
116116 | 116116 | 2020-05-05 | Audubon | Iowa | 19009 | 8 | 0 |
119076 | 119076 | 2020-05-06 | Audubon | Iowa | 19009 | 8 | 0 |
122046 | 122046 | 2020-05-07 | Audubon | Iowa | 19009 | 8 | 0 |
125026 | 125026 | 2020-05-08 | Audubon | Iowa | 19009 | 9 | 0 |
128013 | 128013 | 2020-05-09 | Audubon | Iowa | 19009 | 9 | 0 |
131004 | 131004 | 2020-05-10 | Audubon | Iowa | 19009 | 10 | 0 |
133994 | 133994 | 2020-05-11 | Audubon | Iowa | 19009 | 10 | 0 |
136983 | 136983 | 2020-05-12 | Audubon | Iowa | 19009 | 10 | 1 |
139975 | 139975 | 2020-05-13 | Audubon | Iowa | 19009 | 10 | 1 |
142971 | 142971 | 2020-05-14 | Audubon | Iowa | 19009 | 11 | 1 |
145971 | 145971 | 2020-05-15 | Audubon | Iowa | 19009 | 11 | 1 |
148975 | 148975 | 2020-05-16 | Audubon | Iowa | 19009 | 11 | 1 |
151985 | 151985 | 2020-05-17 | Audubon | Iowa | 19009 | 11 | 1 |
154997 | 154997 | 2020-05-18 | Audubon | Iowa | 19009 | 11 | 1 |
158013 | 158013 | 2020-05-19 | Audubon | Iowa | 19009 | 11 | 1 |
161039 | 161039 | 2020-05-20 | Audubon | Iowa | 19009 | 11 | 1 |
164067 | 164067 | 2020-05-21 | Audubon | Iowa | 19009 | 11 | 1 |
167100 | 167100 | 2020-05-22 | Audubon | Iowa | 19009 | 11 | 1 |
170137 | 170137 | 2020-05-23 | Audubon | Iowa | 19009 | 11 | 1 |
173178 | 173178 | 2020-05-24 | Audubon | Iowa | 19009 | 11 | 1 |
176222 | 176222 | 2020-05-25 | Audubon | Iowa | 19009 | 12 | 1 |
179266 | 179266 | 2020-05-26 | Audubon | Iowa | 19009 | 12 | 1 |
182310 | 182310 | 2020-05-27 | Audubon | Iowa | 19009 | 12 | 1 |
185364 | 185364 | 2020-05-28 | Audubon | Iowa | 19009 | 12 | 1 |
188422 | 188422 | 2020-05-29 | Audubon | Iowa | 19009 | 12 | 1 |
191487 | 191487 | 2020-05-30 | Audubon | Iowa | 19009 | 12 | 1 |
194554 | 194554 | 2020-05-31 | Audubon | Iowa | 19009 | 12 | 1 |
197624 | 197624 | 2020-06-01 | Audubon | Iowa | 19009 | 12 | 1 |
200697 | 200697 | 2020-06-02 | Audubon | Iowa | 19009 | 13 | 1 |
203773 | 203773 | 2020-06-03 | Audubon | Iowa | 19009 | 13 | 1 |
206853 | 206853 | 2020-06-04 | Audubon | Iowa | 19009 | 13 | 1 |
209934 | 209934 | 2020-06-05 | Audubon | Iowa | 19009 | 13 | 1 |
213019 | 213019 | 2020-06-06 | Audubon | Iowa | 19009 | 13 | 1 |
216106 | 216106 | 2020-06-07 | Audubon | Iowa | 19009 | 13 | 1 |
219198 | 219198 | 2020-06-08 | Audubon | Iowa | 19009 | 13 | 1 |
222293 | 222293 | 2020-06-09 | Audubon | Iowa | 19009 | 13 | 1 |
225388 | 225388 | 2020-06-10 | Audubon | Iowa | 19009 | 14 | 1 |
228490 | 228490 | 2020-06-11 | Audubon | Iowa | 19009 | 13 | 1 |
231593 | 231593 | 2020-06-12 | Audubon | Iowa | 19009 | 13 | 1 |
234699 | 234699 | 2020-06-13 | Audubon | Iowa | 19009 | 13 | 1 |
237806 | 237806 | 2020-06-14 | Audubon | Iowa | 19009 | 14 | 1 |
240914 | 240914 | 2020-06-15 | Audubon | Iowa | 19009 | 14 | 1 |
244025 | 244025 | 2020-06-16 | Audubon | Iowa | 19009 | 14 | 1 |
247138 | 247138 | 2020-06-17 | Audubon | Iowa | 19009 | 14 | 1 |
250250 | 250250 | 2020-06-18 | Audubon | Iowa | 19009 | 14 | 1 |
253365 | 253365 | 2020-06-19 | Audubon | Iowa | 19009 | 15 | 1 |
256485 | 256485 | 2020-06-20 | Audubon | Iowa | 19009 | 15 | 1 |
259611 | 259611 | 2020-06-21 | Audubon | Iowa | 19009 | 15 | 1 |
262738 | 262738 | 2020-06-22 | Audubon | Iowa | 19009 | 15 | 1 |
265866 | 265866 | 2020-06-23 | Audubon | Iowa | 19009 | 15 | 1 |
268996 | 268996 | 2020-06-24 | Audubon | Iowa | 19009 | 15 | 1 |
272133 | 272133 | 2020-06-25 | Audubon | Iowa | 19009 | 16 | 1 |
275275 | 275275 | 2020-06-26 | Audubon | Iowa | 19009 | 18 | 1 |
278423 | 278423 | 2020-06-27 | Audubon | Iowa | 19009 | 17 | 1 |
281571 | 281571 | 2020-06-28 | Audubon | Iowa | 19009 | 17 | 1 |
284716 | 284716 | 2020-06-29 | Audubon | Iowa | 19009 | 17 | 1 |
287865 | 287865 | 2020-06-30 | Audubon | Iowa | 19009 | 17 | 1 |
291015 | 291015 | 2020-07-01 | Audubon | Iowa | 19009 | 16 | 1 |
294169 | 294169 | 2020-07-02 | Audubon | Iowa | 19009 | 16 | 1 |
297327 | 297327 | 2020-07-03 | Audubon | Iowa | 19009 | 16 | 1 |
300489 | 300489 | 2020-07-04 | Audubon | Iowa | 19009 | 16 | 1 |
303653 | 303653 | 2020-07-05 | Audubon | Iowa | 19009 | 16 | 1 |
306818 | 306818 | 2020-07-06 | Audubon | Iowa | 19009 | 16 | 1 |
309986 | 309986 | 2020-07-07 | Audubon | Iowa | 19009 | 16 | 1 |
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);