ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Clarke" and state = "Iowa" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
33856 | 33856 | 2020-04-05 | Clarke | Iowa | 19039 | 1 | 0 |
36310 | 36310 | 2020-04-06 | Clarke | Iowa | 19039 | 1 | 0 |
38809 | 38809 | 2020-04-07 | Clarke | Iowa | 19039 | 1 | 0 |
41355 | 41355 | 2020-04-08 | Clarke | Iowa | 19039 | 1 | 0 |
43931 | 43931 | 2020-04-09 | Clarke | Iowa | 19039 | 1 | 0 |
46536 | 46536 | 2020-04-10 | Clarke | Iowa | 19039 | 2 | 0 |
49170 | 49170 | 2020-04-11 | Clarke | Iowa | 19039 | 2 | 0 |
51834 | 51834 | 2020-04-12 | Clarke | Iowa | 19039 | 2 | 0 |
54516 | 54516 | 2020-04-13 | Clarke | Iowa | 19039 | 2 | 0 |
57209 | 57209 | 2020-04-14 | Clarke | Iowa | 19039 | 2 | 0 |
59917 | 59917 | 2020-04-15 | Clarke | Iowa | 19039 | 2 | 0 |
62638 | 62638 | 2020-04-16 | Clarke | Iowa | 19039 | 2 | 0 |
65372 | 65372 | 2020-04-17 | Clarke | Iowa | 19039 | 2 | 0 |
68121 | 68121 | 2020-04-18 | Clarke | Iowa | 19039 | 2 | 0 |
70883 | 70883 | 2020-04-19 | Clarke | Iowa | 19039 | 2 | 0 |
73654 | 73654 | 2020-04-20 | Clarke | Iowa | 19039 | 2 | 0 |
76432 | 76432 | 2020-04-21 | Clarke | Iowa | 19039 | 2 | 0 |
79216 | 79216 | 2020-04-22 | Clarke | Iowa | 19039 | 2 | 0 |
82009 | 82009 | 2020-04-23 | Clarke | Iowa | 19039 | 2 | 0 |
84809 | 84809 | 2020-04-24 | Clarke | Iowa | 19039 | 2 | 0 |
87619 | 87619 | 2020-04-25 | Clarke | Iowa | 19039 | 2 | 0 |
90435 | 90435 | 2020-04-26 | Clarke | Iowa | 19039 | 2 | 0 |
93254 | 93254 | 2020-04-27 | Clarke | Iowa | 19039 | 2 | 0 |
96086 | 96086 | 2020-04-28 | Clarke | Iowa | 19039 | 2 | 0 |
98930 | 98930 | 2020-04-29 | Clarke | Iowa | 19039 | 2 | 0 |
101781 | 101781 | 2020-04-30 | Clarke | Iowa | 19039 | 2 | 0 |
104638 | 104638 | 2020-05-01 | Clarke | Iowa | 19039 | 2 | 0 |
107503 | 107503 | 2020-05-02 | Clarke | Iowa | 19039 | 2 | 0 |
110373 | 110373 | 2020-05-03 | Clarke | Iowa | 19039 | 3 | 0 |
113248 | 113248 | 2020-05-04 | Clarke | Iowa | 19039 | 3 | 0 |
116131 | 116131 | 2020-05-05 | Clarke | Iowa | 19039 | 3 | 0 |
119091 | 119091 | 2020-05-06 | Clarke | Iowa | 19039 | 3 | 0 |
122061 | 122061 | 2020-05-07 | Clarke | Iowa | 19039 | 4 | 0 |
125041 | 125041 | 2020-05-08 | Clarke | Iowa | 19039 | 5 | 0 |
128028 | 128028 | 2020-05-09 | Clarke | Iowa | 19039 | 5 | 0 |
131019 | 131019 | 2020-05-10 | Clarke | Iowa | 19039 | 6 | 0 |
134009 | 134009 | 2020-05-11 | Clarke | Iowa | 19039 | 8 | 0 |
136998 | 136998 | 2020-05-12 | Clarke | Iowa | 19039 | 8 | 0 |
139990 | 139990 | 2020-05-13 | Clarke | Iowa | 19039 | 9 | 0 |
142986 | 142986 | 2020-05-14 | Clarke | Iowa | 19039 | 11 | 0 |
145986 | 145986 | 2020-05-15 | Clarke | Iowa | 19039 | 11 | 0 |
148990 | 148990 | 2020-05-16 | Clarke | Iowa | 19039 | 14 | 0 |
152000 | 152000 | 2020-05-17 | Clarke | Iowa | 19039 | 17 | 0 |
155012 | 155012 | 2020-05-18 | Clarke | Iowa | 19039 | 18 | 0 |
158028 | 158028 | 2020-05-19 | Clarke | Iowa | 19039 | 23 | 0 |
161054 | 161054 | 2020-05-20 | Clarke | Iowa | 19039 | 24 | 0 |
164082 | 164082 | 2020-05-21 | Clarke | Iowa | 19039 | 25 | 0 |
167115 | 167115 | 2020-05-22 | Clarke | Iowa | 19039 | 29 | 0 |
170152 | 170152 | 2020-05-23 | Clarke | Iowa | 19039 | 29 | 0 |
173193 | 173193 | 2020-05-24 | Clarke | Iowa | 19039 | 34 | 0 |
176237 | 176237 | 2020-05-25 | Clarke | Iowa | 19039 | 34 | 0 |
179281 | 179281 | 2020-05-26 | Clarke | Iowa | 19039 | 37 | 0 |
182325 | 182325 | 2020-05-27 | Clarke | Iowa | 19039 | 44 | 0 |
185379 | 185379 | 2020-05-28 | Clarke | Iowa | 19039 | 46 | 0 |
188437 | 188437 | 2020-05-29 | Clarke | Iowa | 19039 | 50 | 0 |
191502 | 191502 | 2020-05-30 | Clarke | Iowa | 19039 | 54 | 0 |
194569 | 194569 | 2020-05-31 | Clarke | Iowa | 19039 | 55 | 0 |
197639 | 197639 | 2020-06-01 | Clarke | Iowa | 19039 | 58 | 0 |
200712 | 200712 | 2020-06-02 | Clarke | Iowa | 19039 | 62 | 0 |
203788 | 203788 | 2020-06-03 | Clarke | Iowa | 19039 | 64 | 0 |
206868 | 206868 | 2020-06-04 | Clarke | Iowa | 19039 | 67 | 0 |
209949 | 209949 | 2020-06-05 | Clarke | Iowa | 19039 | 69 | 0 |
213034 | 213034 | 2020-06-06 | Clarke | Iowa | 19039 | 71 | 1 |
216121 | 216121 | 2020-06-07 | Clarke | Iowa | 19039 | 75 | 1 |
219213 | 219213 | 2020-06-08 | Clarke | Iowa | 19039 | 76 | 1 |
222308 | 222308 | 2020-06-09 | Clarke | Iowa | 19039 | 79 | 1 |
225403 | 225403 | 2020-06-10 | Clarke | Iowa | 19039 | 83 | 1 |
228505 | 228505 | 2020-06-11 | Clarke | Iowa | 19039 | 85 | 1 |
231608 | 231608 | 2020-06-12 | Clarke | Iowa | 19039 | 86 | 1 |
234714 | 234714 | 2020-06-13 | Clarke | Iowa | 19039 | 88 | 1 |
237821 | 237821 | 2020-06-14 | Clarke | Iowa | 19039 | 89 | 1 |
240929 | 240929 | 2020-06-15 | Clarke | Iowa | 19039 | 89 | 1 |
244040 | 244040 | 2020-06-16 | Clarke | Iowa | 19039 | 89 | 1 |
247153 | 247153 | 2020-06-17 | Clarke | Iowa | 19039 | 90 | 1 |
250265 | 250265 | 2020-06-18 | Clarke | Iowa | 19039 | 96 | 2 |
253380 | 253380 | 2020-06-19 | Clarke | Iowa | 19039 | 110 | 2 |
256500 | 256500 | 2020-06-20 | Clarke | Iowa | 19039 | 111 | 2 |
262753 | 262753 | 2020-06-22 | Clarke | Iowa | 19039 | 111 | 2 |
265881 | 265881 | 2020-06-23 | Clarke | Iowa | 19039 | 111 | 2 |
259626 | 259626 | 2020-06-21 | Clarke | Iowa | 19039 | 112 | 2 |
269011 | 269011 | 2020-06-24 | Clarke | Iowa | 19039 | 112 | 2 |
272148 | 272148 | 2020-06-25 | Clarke | Iowa | 19039 | 114 | 2 |
275290 | 275290 | 2020-06-26 | Clarke | Iowa | 19039 | 114 | 2 |
278438 | 278438 | 2020-06-27 | Clarke | Iowa | 19039 | 120 | 2 |
281586 | 281586 | 2020-06-28 | Clarke | Iowa | 19039 | 123 | 2 |
284731 | 284731 | 2020-06-29 | Clarke | Iowa | 19039 | 124 | 2 |
287880 | 287880 | 2020-06-30 | Clarke | Iowa | 19039 | 125 | 2 |
291030 | 291030 | 2020-07-01 | Clarke | Iowa | 19039 | 126 | 2 |
294184 | 294184 | 2020-07-02 | Clarke | Iowa | 19039 | 127 | 2 |
297342 | 297342 | 2020-07-03 | Clarke | Iowa | 19039 | 129 | 2 |
300504 | 300504 | 2020-07-04 | Clarke | Iowa | 19039 | 132 | 2 |
303668 | 303668 | 2020-07-05 | Clarke | Iowa | 19039 | 132 | 2 |
306833 | 306833 | 2020-07-06 | Clarke | Iowa | 19039 | 132 | 2 |
310001 | 310001 | 2020-07-07 | Clarke | Iowa | 19039 | 133 | 3 |
313171 | 313171 | 2020-07-08 | Clarke | Iowa | 19039 | 134 | 3 |
316345 | 316345 | 2020-07-09 | Clarke | Iowa | 19039 | 140 | 3 |
319518 | 319518 | 2020-07-10 | Clarke | Iowa | 19039 | 143 | 3 |
322697 | 322697 | 2020-07-11 | Clarke | Iowa | 19039 | 143 | 3 |
325878 | 325878 | 2020-07-12 | Clarke | Iowa | 19039 | 144 | 3 |
329064 | 329064 | 2020-07-13 | Clarke | Iowa | 19039 | 145 | 3 |
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);