ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386750 | 386750 | 2020-07-31 | Clay | Iowa | 19041 | 168 | 1 |
383532 | 383532 | 2020-07-30 | Clay | Iowa | 19041 | 168 | 1 |
380315 | 380315 | 2020-07-29 | Clay | Iowa | 19041 | 168 | 1 |
377098 | 377098 | 2020-07-28 | Clay | Iowa | 19041 | 167 | 1 |
373883 | 373883 | 2020-07-27 | Clay | Iowa | 19041 | 166 | 1 |
370671 | 370671 | 2020-07-26 | Clay | Iowa | 19041 | 166 | 1 |
367461 | 367461 | 2020-07-25 | Clay | Iowa | 19041 | 165 | 1 |
364254 | 364254 | 2020-07-24 | Clay | Iowa | 19041 | 164 | 1 |
361047 | 361047 | 2020-07-23 | Clay | Iowa | 19041 | 162 | 1 |
357842 | 357842 | 2020-07-22 | Clay | Iowa | 19041 | 161 | 1 |
354640 | 354640 | 2020-07-21 | Clay | Iowa | 19041 | 161 | 1 |
351438 | 351438 | 2020-07-20 | Clay | Iowa | 19041 | 161 | 1 |
348238 | 348238 | 2020-07-19 | Clay | Iowa | 19041 | 159 | 1 |
345037 | 345037 | 2020-07-18 | Clay | Iowa | 19041 | 158 | 1 |
341837 | 341837 | 2020-07-17 | Clay | Iowa | 19041 | 155 | 1 |
338641 | 338641 | 2020-07-16 | Clay | Iowa | 19041 | 155 | 1 |
335445 | 335445 | 2020-07-15 | Clay | Iowa | 19041 | 152 | 1 |
332252 | 332252 | 2020-07-14 | Clay | Iowa | 19041 | 152 | 1 |
329065 | 329065 | 2020-07-13 | Clay | Iowa | 19041 | 151 | 1 |
325879 | 325879 | 2020-07-12 | Clay | Iowa | 19041 | 150 | 1 |
322698 | 322698 | 2020-07-11 | Clay | Iowa | 19041 | 149 | 1 |
319519 | 319519 | 2020-07-10 | Clay | Iowa | 19041 | 148 | 1 |
316346 | 316346 | 2020-07-09 | Clay | Iowa | 19041 | 145 | 1 |
313172 | 313172 | 2020-07-08 | Clay | Iowa | 19041 | 142 | 1 |
310002 | 310002 | 2020-07-07 | Clay | Iowa | 19041 | 137 | 0 |
306834 | 306834 | 2020-07-06 | Clay | Iowa | 19041 | 134 | 0 |
303669 | 303669 | 2020-07-05 | Clay | Iowa | 19041 | 134 | 0 |
300505 | 300505 | 2020-07-04 | Clay | Iowa | 19041 | 133 | 0 |
297343 | 297343 | 2020-07-03 | Clay | Iowa | 19041 | 129 | 0 |
294185 | 294185 | 2020-07-02 | Clay | Iowa | 19041 | 127 | 0 |
291031 | 291031 | 2020-07-01 | Clay | Iowa | 19041 | 126 | 0 |
287881 | 287881 | 2020-06-30 | Clay | Iowa | 19041 | 123 | 0 |
284732 | 284732 | 2020-06-29 | Clay | Iowa | 19041 | 120 | 0 |
281587 | 281587 | 2020-06-28 | Clay | Iowa | 19041 | 119 | 0 |
278439 | 278439 | 2020-06-27 | Clay | Iowa | 19041 | 117 | 0 |
275291 | 275291 | 2020-06-26 | Clay | Iowa | 19041 | 115 | 0 |
272149 | 272149 | 2020-06-25 | Clay | Iowa | 19041 | 113 | 0 |
269012 | 269012 | 2020-06-24 | Clay | Iowa | 19041 | 111 | 0 |
265882 | 265882 | 2020-06-23 | Clay | Iowa | 19041 | 109 | 0 |
262754 | 262754 | 2020-06-22 | Clay | Iowa | 19041 | 106 | 0 |
259627 | 259627 | 2020-06-21 | Clay | Iowa | 19041 | 106 | 0 |
256501 | 256501 | 2020-06-20 | Clay | Iowa | 19041 | 104 | 0 |
253381 | 253381 | 2020-06-19 | Clay | Iowa | 19041 | 102 | 0 |
250266 | 250266 | 2020-06-18 | Clay | Iowa | 19041 | 93 | 0 |
247154 | 247154 | 2020-06-17 | Clay | Iowa | 19041 | 86 | 0 |
244041 | 244041 | 2020-06-16 | Clay | Iowa | 19041 | 83 | 0 |
240930 | 240930 | 2020-06-15 | Clay | Iowa | 19041 | 77 | 0 |
237822 | 237822 | 2020-06-14 | Clay | Iowa | 19041 | 73 | 0 |
234715 | 234715 | 2020-06-13 | Clay | Iowa | 19041 | 66 | 0 |
231609 | 231609 | 2020-06-12 | Clay | Iowa | 19041 | 62 | 0 |
228506 | 228506 | 2020-06-11 | Clay | Iowa | 19041 | 55 | 0 |
225404 | 225404 | 2020-06-10 | Clay | Iowa | 19041 | 39 | 0 |
222309 | 222309 | 2020-06-09 | Clay | Iowa | 19041 | 36 | 0 |
219214 | 219214 | 2020-06-08 | Clay | Iowa | 19041 | 35 | 0 |
216122 | 216122 | 2020-06-07 | Clay | Iowa | 19041 | 34 | 0 |
213035 | 213035 | 2020-06-06 | Clay | Iowa | 19041 | 30 | 0 |
209950 | 209950 | 2020-06-05 | Clay | Iowa | 19041 | 29 | 0 |
206869 | 206869 | 2020-06-04 | Clay | Iowa | 19041 | 27 | 0 |
203789 | 203789 | 2020-06-03 | Clay | Iowa | 19041 | 21 | 0 |
200713 | 200713 | 2020-06-02 | Clay | Iowa | 19041 | 18 | 0 |
197640 | 197640 | 2020-06-01 | Clay | Iowa | 19041 | 18 | 0 |
194570 | 194570 | 2020-05-31 | Clay | Iowa | 19041 | 16 | 0 |
191503 | 191503 | 2020-05-30 | Clay | Iowa | 19041 | 15 | 0 |
188438 | 188438 | 2020-05-29 | Clay | Iowa | 19041 | 13 | 0 |
185380 | 185380 | 2020-05-28 | Clay | Iowa | 19041 | 13 | 0 |
182326 | 182326 | 2020-05-27 | Clay | Iowa | 19041 | 13 | 0 |
179282 | 179282 | 2020-05-26 | Clay | Iowa | 19041 | 12 | 0 |
176238 | 176238 | 2020-05-25 | Clay | Iowa | 19041 | 10 | 0 |
173194 | 173194 | 2020-05-24 | Clay | Iowa | 19041 | 10 | 0 |
170153 | 170153 | 2020-05-23 | Clay | Iowa | 19041 | 9 | 0 |
167116 | 167116 | 2020-05-22 | Clay | Iowa | 19041 | 9 | 0 |
164083 | 164083 | 2020-05-21 | Clay | Iowa | 19041 | 9 | 0 |
161055 | 161055 | 2020-05-20 | Clay | Iowa | 19041 | 9 | 0 |
158029 | 158029 | 2020-05-19 | Clay | Iowa | 19041 | 9 | 0 |
155013 | 155013 | 2020-05-18 | Clay | Iowa | 19041 | 9 | 0 |
152001 | 152001 | 2020-05-17 | Clay | Iowa | 19041 | 9 | 0 |
148991 | 148991 | 2020-05-16 | Clay | Iowa | 19041 | 10 | 0 |
145987 | 145987 | 2020-05-15 | Clay | Iowa | 19041 | 10 | 0 |
142987 | 142987 | 2020-05-14 | Clay | Iowa | 19041 | 9 | 0 |
139991 | 139991 | 2020-05-13 | Clay | Iowa | 19041 | 9 | 0 |
136999 | 136999 | 2020-05-12 | Clay | Iowa | 19041 | 9 | 0 |
134010 | 134010 | 2020-05-11 | Clay | Iowa | 19041 | 9 | 0 |
131020 | 131020 | 2020-05-10 | Clay | Iowa | 19041 | 9 | 0 |
128029 | 128029 | 2020-05-09 | Clay | Iowa | 19041 | 9 | 0 |
125042 | 125042 | 2020-05-08 | Clay | Iowa | 19041 | 9 | 0 |
122062 | 122062 | 2020-05-07 | Clay | Iowa | 19041 | 8 | 0 |
119092 | 119092 | 2020-05-06 | Clay | Iowa | 19041 | 7 | 0 |
116132 | 116132 | 2020-05-05 | Clay | Iowa | 19041 | 7 | 0 |
113249 | 113249 | 2020-05-04 | Clay | Iowa | 19041 | 6 | 0 |
110374 | 110374 | 2020-05-03 | Clay | Iowa | 19041 | 5 | 0 |
107504 | 107504 | 2020-05-02 | Clay | Iowa | 19041 | 4 | 0 |
104639 | 104639 | 2020-05-01 | Clay | Iowa | 19041 | 4 | 0 |
101782 | 101782 | 2020-04-30 | Clay | Iowa | 19041 | 4 | 0 |
98931 | 98931 | 2020-04-29 | Clay | Iowa | 19041 | 3 | 0 |
96087 | 96087 | 2020-04-28 | Clay | Iowa | 19041 | 3 | 0 |
93255 | 93255 | 2020-04-27 | Clay | Iowa | 19041 | 3 | 0 |
90436 | 90436 | 2020-04-26 | Clay | Iowa | 19041 | 3 | 0 |
87620 | 87620 | 2020-04-25 | Clay | Iowa | 19041 | 3 | 0 |
84810 | 84810 | 2020-04-24 | Clay | Iowa | 19041 | 3 | 0 |
82010 | 82010 | 2020-04-23 | Clay | Iowa | 19041 | 3 | 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);