ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 19083 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281608 | 281608 | 2020-06-28 | Hardin | Iowa | 19083 | 65 | 0 |
278460 | 278460 | 2020-06-27 | Hardin | Iowa | 19083 | 62 | 0 |
275312 | 275312 | 2020-06-26 | Hardin | Iowa | 19083 | 59 | 0 |
272170 | 272170 | 2020-06-25 | Hardin | Iowa | 19083 | 58 | 0 |
269033 | 269033 | 2020-06-24 | Hardin | Iowa | 19083 | 56 | 0 |
265903 | 265903 | 2020-06-23 | Hardin | Iowa | 19083 | 54 | 0 |
262775 | 262775 | 2020-06-22 | Hardin | Iowa | 19083 | 53 | 0 |
259648 | 259648 | 2020-06-21 | Hardin | Iowa | 19083 | 53 | 0 |
256522 | 256522 | 2020-06-20 | Hardin | Iowa | 19083 | 52 | 0 |
253402 | 253402 | 2020-06-19 | Hardin | Iowa | 19083 | 52 | 0 |
250287 | 250287 | 2020-06-18 | Hardin | Iowa | 19083 | 52 | 0 |
247175 | 247175 | 2020-06-17 | Hardin | Iowa | 19083 | 46 | 0 |
244062 | 244062 | 2020-06-16 | Hardin | Iowa | 19083 | 44 | 0 |
240951 | 240951 | 2020-06-15 | Hardin | Iowa | 19083 | 45 | 0 |
237843 | 237843 | 2020-06-14 | Hardin | Iowa | 19083 | 44 | 0 |
234736 | 234736 | 2020-06-13 | Hardin | Iowa | 19083 | 43 | 0 |
231630 | 231630 | 2020-06-12 | Hardin | Iowa | 19083 | 42 | 0 |
228527 | 228527 | 2020-06-11 | Hardin | Iowa | 19083 | 42 | 0 |
225425 | 225425 | 2020-06-10 | Hardin | Iowa | 19083 | 39 | 0 |
222330 | 222330 | 2020-06-09 | Hardin | Iowa | 19083 | 33 | 0 |
219235 | 219235 | 2020-06-08 | Hardin | Iowa | 19083 | 33 | 0 |
216143 | 216143 | 2020-06-07 | Hardin | Iowa | 19083 | 33 | 0 |
213056 | 213056 | 2020-06-06 | Hardin | Iowa | 19083 | 31 | 0 |
209971 | 209971 | 2020-06-05 | Hardin | Iowa | 19083 | 29 | 0 |
206890 | 206890 | 2020-06-04 | Hardin | Iowa | 19083 | 21 | 0 |
203810 | 203810 | 2020-06-03 | Hardin | Iowa | 19083 | 19 | 0 |
200734 | 200734 | 2020-06-02 | Hardin | Iowa | 19083 | 17 | 0 |
197661 | 197661 | 2020-06-01 | Hardin | Iowa | 19083 | 17 | 0 |
194591 | 194591 | 2020-05-31 | Hardin | Iowa | 19083 | 17 | 0 |
191524 | 191524 | 2020-05-30 | Hardin | Iowa | 19083 | 17 | 0 |
188459 | 188459 | 2020-05-29 | Hardin | Iowa | 19083 | 16 | 0 |
185401 | 185401 | 2020-05-28 | Hardin | Iowa | 19083 | 16 | 0 |
182347 | 182347 | 2020-05-27 | Hardin | Iowa | 19083 | 16 | 0 |
179302 | 179302 | 2020-05-26 | Hardin | Iowa | 19083 | 13 | 0 |
176258 | 176258 | 2020-05-25 | Hardin | Iowa | 19083 | 13 | 0 |
173214 | 173214 | 2020-05-24 | Hardin | Iowa | 19083 | 13 | 0 |
170173 | 170173 | 2020-05-23 | Hardin | Iowa | 19083 | 13 | 0 |
167136 | 167136 | 2020-05-22 | Hardin | Iowa | 19083 | 13 | 0 |
164103 | 164103 | 2020-05-21 | Hardin | Iowa | 19083 | 13 | 0 |
161075 | 161075 | 2020-05-20 | Hardin | Iowa | 19083 | 13 | 0 |
158049 | 158049 | 2020-05-19 | Hardin | Iowa | 19083 | 12 | 0 |
155033 | 155033 | 2020-05-18 | Hardin | Iowa | 19083 | 12 | 0 |
152021 | 152021 | 2020-05-17 | Hardin | Iowa | 19083 | 12 | 0 |
149011 | 149011 | 2020-05-16 | Hardin | Iowa | 19083 | 12 | 0 |
146007 | 146007 | 2020-05-15 | Hardin | Iowa | 19083 | 11 | 0 |
143007 | 143007 | 2020-05-14 | Hardin | Iowa | 19083 | 11 | 0 |
140011 | 140011 | 2020-05-13 | Hardin | Iowa | 19083 | 12 | 0 |
137018 | 137018 | 2020-05-12 | Hardin | Iowa | 19083 | 12 | 0 |
134029 | 134029 | 2020-05-11 | Hardin | Iowa | 19083 | 12 | 0 |
131039 | 131039 | 2020-05-10 | Hardin | Iowa | 19083 | 12 | 0 |
128048 | 128048 | 2020-05-09 | Hardin | Iowa | 19083 | 12 | 0 |
125061 | 125061 | 2020-05-08 | Hardin | Iowa | 19083 | 12 | 0 |
122080 | 122080 | 2020-05-07 | Hardin | Iowa | 19083 | 11 | 0 |
119110 | 119110 | 2020-05-06 | Hardin | Iowa | 19083 | 9 | 0 |
116150 | 116150 | 2020-05-05 | Hardin | Iowa | 19083 | 9 | 0 |
113267 | 113267 | 2020-05-04 | Hardin | Iowa | 19083 | 9 | 0 |
110392 | 110392 | 2020-05-03 | Hardin | Iowa | 19083 | 9 | 0 |
107522 | 107522 | 2020-05-02 | Hardin | Iowa | 19083 | 9 | 0 |
104657 | 104657 | 2020-05-01 | Hardin | Iowa | 19083 | 9 | 0 |
101799 | 101799 | 2020-04-30 | Hardin | Iowa | 19083 | 8 | 0 |
98948 | 98948 | 2020-04-29 | Hardin | Iowa | 19083 | 7 | 0 |
96103 | 96103 | 2020-04-28 | Hardin | Iowa | 19083 | 7 | 0 |
93271 | 93271 | 2020-04-27 | Hardin | Iowa | 19083 | 7 | 0 |
90452 | 90452 | 2020-04-26 | Hardin | Iowa | 19083 | 6 | 0 |
87636 | 87636 | 2020-04-25 | Hardin | Iowa | 19083 | 5 | 0 |
84826 | 84826 | 2020-04-24 | Hardin | Iowa | 19083 | 4 | 0 |
82026 | 82026 | 2020-04-23 | Hardin | Iowa | 19083 | 4 | 0 |
79233 | 79233 | 2020-04-22 | Hardin | Iowa | 19083 | 4 | 0 |
76449 | 76449 | 2020-04-21 | Hardin | Iowa | 19083 | 4 | 0 |
73671 | 73671 | 2020-04-20 | Hardin | Iowa | 19083 | 3 | 0 |
70900 | 70900 | 2020-04-19 | Hardin | Iowa | 19083 | 2 | 0 |
68138 | 68138 | 2020-04-18 | Hardin | Iowa | 19083 | 2 | 0 |
65389 | 65389 | 2020-04-17 | Hardin | Iowa | 19083 | 1 | 0 |
62655 | 62655 | 2020-04-16 | Hardin | Iowa | 19083 | 1 | 0 |
59934 | 59934 | 2020-04-15 | Hardin | Iowa | 19083 | 1 | 0 |
57226 | 57226 | 2020-04-14 | Hardin | Iowa | 19083 | 2 | 0 |
54533 | 54533 | 2020-04-13 | Hardin | Iowa | 19083 | 2 | 0 |
51851 | 51851 | 2020-04-12 | Hardin | Iowa | 19083 | 1 | 0 |
49187 | 49187 | 2020-04-11 | Hardin | Iowa | 19083 | 1 | 0 |
46553 | 46553 | 2020-04-10 | Hardin | Iowa | 19083 | 1 | 0 |
43948 | 43948 | 2020-04-09 | Hardin | Iowa | 19083 | 1 | 0 |
41372 | 41372 | 2020-04-08 | Hardin | Iowa | 19083 | 1 | 0 |
38826 | 38826 | 2020-04-07 | Hardin | Iowa | 19083 | 1 | 0 |
36325 | 36325 | 2020-04-06 | Hardin | Iowa | 19083 | 1 | 0 |
33870 | 33870 | 2020-04-05 | Hardin | Iowa | 19083 | 1 | 0 |
31457 | 31457 | 2020-04-04 | Hardin | Iowa | 19083 | 1 | 0 |
29088 | 29088 | 2020-04-03 | Hardin | Iowa | 19083 | 1 | 0 |
26777 | 26777 | 2020-04-02 | Hardin | Iowa | 19083 | 1 | 0 |
24536 | 24536 | 2020-04-01 | Hardin | Iowa | 19083 | 1 | 0 |
22364 | 22364 | 2020-03-31 | Hardin | Iowa | 19083 | 1 | 0 |
20268 | 20268 | 2020-03-30 | Hardin | Iowa | 19083 | 1 | 0 |
18259 | 18259 | 2020-03-29 | Hardin | Iowa | 19083 | 1 | 0 |
16354 | 16354 | 2020-03-28 | Hardin | Iowa | 19083 | 1 | 0 |
14550 | 14550 | 2020-03-27 | Hardin | Iowa | 19083 | 1 | 0 |
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);