ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Plymouth" and state = "Iowa" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29111 | 29111 | 2020-04-03 | Plymouth | Iowa | 19149 | 1 | 0 |
31483 | 31483 | 2020-04-04 | Plymouth | Iowa | 19149 | 3 | 0 |
33896 | 33896 | 2020-04-05 | Plymouth | Iowa | 19149 | 4 | 0 |
36352 | 36352 | 2020-04-06 | Plymouth | Iowa | 19149 | 4 | 0 |
38853 | 38853 | 2020-04-07 | Plymouth | Iowa | 19149 | 4 | 0 |
41399 | 41399 | 2020-04-08 | Plymouth | Iowa | 19149 | 4 | 0 |
43975 | 43975 | 2020-04-09 | Plymouth | Iowa | 19149 | 4 | 0 |
46581 | 46581 | 2020-04-10 | Plymouth | Iowa | 19149 | 4 | 0 |
49215 | 49215 | 2020-04-11 | Plymouth | Iowa | 19149 | 4 | 0 |
51879 | 51879 | 2020-04-12 | Plymouth | Iowa | 19149 | 4 | 0 |
54561 | 54561 | 2020-04-13 | Plymouth | Iowa | 19149 | 4 | 0 |
57254 | 57254 | 2020-04-14 | Plymouth | Iowa | 19149 | 4 | 0 |
59962 | 59962 | 2020-04-15 | Plymouth | Iowa | 19149 | 4 | 0 |
62683 | 62683 | 2020-04-16 | Plymouth | Iowa | 19149 | 5 | 0 |
65417 | 65417 | 2020-04-17 | Plymouth | Iowa | 19149 | 6 | 0 |
68166 | 68166 | 2020-04-18 | Plymouth | Iowa | 19149 | 8 | 0 |
70928 | 70928 | 2020-04-19 | Plymouth | Iowa | 19149 | 8 | 0 |
73699 | 73699 | 2020-04-20 | Plymouth | Iowa | 19149 | 8 | 0 |
76478 | 76478 | 2020-04-21 | Plymouth | Iowa | 19149 | 9 | 0 |
79262 | 79262 | 2020-04-22 | Plymouth | Iowa | 19149 | 9 | 0 |
82055 | 82055 | 2020-04-23 | Plymouth | Iowa | 19149 | 9 | 0 |
84855 | 84855 | 2020-04-24 | Plymouth | Iowa | 19149 | 8 | 0 |
87665 | 87665 | 2020-04-25 | Plymouth | Iowa | 19149 | 11 | 0 |
90481 | 90481 | 2020-04-26 | Plymouth | Iowa | 19149 | 11 | 0 |
93300 | 93300 | 2020-04-27 | Plymouth | Iowa | 19149 | 10 | 0 |
96132 | 96132 | 2020-04-28 | Plymouth | Iowa | 19149 | 12 | 0 |
98977 | 98977 | 2020-04-29 | Plymouth | Iowa | 19149 | 12 | 0 |
101828 | 101828 | 2020-04-30 | Plymouth | Iowa | 19149 | 12 | 0 |
104686 | 104686 | 2020-05-01 | Plymouth | Iowa | 19149 | 14 | 0 |
107551 | 107551 | 2020-05-02 | Plymouth | Iowa | 19149 | 17 | 0 |
110422 | 110422 | 2020-05-03 | Plymouth | Iowa | 19149 | 23 | 0 |
113297 | 113297 | 2020-05-04 | Plymouth | Iowa | 19149 | 27 | 0 |
116180 | 116180 | 2020-05-05 | Plymouth | Iowa | 19149 | 33 | 0 |
119140 | 119140 | 2020-05-06 | Plymouth | Iowa | 19149 | 34 | 0 |
122110 | 122110 | 2020-05-07 | Plymouth | Iowa | 19149 | 44 | 0 |
125092 | 125092 | 2020-05-08 | Plymouth | Iowa | 19149 | 48 | 0 |
128079 | 128079 | 2020-05-09 | Plymouth | Iowa | 19149 | 51 | 0 |
131070 | 131070 | 2020-05-10 | Plymouth | Iowa | 19149 | 59 | 0 |
134060 | 134060 | 2020-05-11 | Plymouth | Iowa | 19149 | 62 | 0 |
137050 | 137050 | 2020-05-12 | Plymouth | Iowa | 19149 | 67 | 0 |
140043 | 140043 | 2020-05-13 | Plymouth | Iowa | 19149 | 71 | 0 |
143039 | 143039 | 2020-05-14 | Plymouth | Iowa | 19149 | 74 | 0 |
146039 | 146039 | 2020-05-15 | Plymouth | Iowa | 19149 | 78 | 0 |
149043 | 149043 | 2020-05-16 | Plymouth | Iowa | 19149 | 82 | 0 |
152054 | 152054 | 2020-05-17 | Plymouth | Iowa | 19149 | 83 | 0 |
155066 | 155066 | 2020-05-18 | Plymouth | Iowa | 19149 | 86 | 0 |
158082 | 158082 | 2020-05-19 | Plymouth | Iowa | 19149 | 89 | 0 |
161108 | 161108 | 2020-05-20 | Plymouth | Iowa | 19149 | 94 | 0 |
164136 | 164136 | 2020-05-21 | Plymouth | Iowa | 19149 | 98 | 0 |
167169 | 167169 | 2020-05-22 | Plymouth | Iowa | 19149 | 102 | 0 |
170206 | 170206 | 2020-05-23 | Plymouth | Iowa | 19149 | 102 | 0 |
173247 | 173247 | 2020-05-24 | Plymouth | Iowa | 19149 | 112 | 0 |
176291 | 176291 | 2020-05-25 | Plymouth | Iowa | 19149 | 117 | 0 |
179335 | 179335 | 2020-05-26 | Plymouth | Iowa | 19149 | 118 | 1 |
182380 | 182380 | 2020-05-27 | Plymouth | Iowa | 19149 | 119 | 1 |
185434 | 185434 | 2020-05-28 | Plymouth | Iowa | 19149 | 120 | 1 |
188492 | 188492 | 2020-05-29 | Plymouth | Iowa | 19149 | 127 | 2 |
191557 | 191557 | 2020-05-30 | Plymouth | Iowa | 19149 | 129 | 2 |
194624 | 194624 | 2020-05-31 | Plymouth | Iowa | 19149 | 133 | 2 |
197694 | 197694 | 2020-06-01 | Plymouth | Iowa | 19149 | 134 | 2 |
200767 | 200767 | 2020-06-02 | Plymouth | Iowa | 19149 | 135 | 2 |
203843 | 203843 | 2020-06-03 | Plymouth | Iowa | 19149 | 141 | 2 |
206923 | 206923 | 2020-06-04 | Plymouth | Iowa | 19149 | 149 | 2 |
210004 | 210004 | 2020-06-05 | Plymouth | Iowa | 19149 | 156 | 2 |
213089 | 213089 | 2020-06-06 | Plymouth | Iowa | 19149 | 156 | 2 |
216176 | 216176 | 2020-06-07 | Plymouth | Iowa | 19149 | 163 | 2 |
219268 | 219268 | 2020-06-08 | Plymouth | Iowa | 19149 | 172 | 4 |
222363 | 222363 | 2020-06-09 | Plymouth | Iowa | 19149 | 172 | 4 |
225458 | 225458 | 2020-06-10 | Plymouth | Iowa | 19149 | 179 | 4 |
228560 | 228560 | 2020-06-11 | Plymouth | Iowa | 19149 | 188 | 4 |
231663 | 231663 | 2020-06-12 | Plymouth | Iowa | 19149 | 196 | 4 |
234769 | 234769 | 2020-06-13 | Plymouth | Iowa | 19149 | 196 | 4 |
237876 | 237876 | 2020-06-14 | Plymouth | Iowa | 19149 | 200 | 4 |
240984 | 240984 | 2020-06-15 | Plymouth | Iowa | 19149 | 201 | 4 |
244095 | 244095 | 2020-06-16 | Plymouth | Iowa | 19149 | 204 | 4 |
247208 | 247208 | 2020-06-17 | Plymouth | Iowa | 19149 | 209 | 4 |
250320 | 250320 | 2020-06-18 | Plymouth | Iowa | 19149 | 216 | 4 |
253435 | 253435 | 2020-06-19 | Plymouth | Iowa | 19149 | 230 | 4 |
256555 | 256555 | 2020-06-20 | Plymouth | Iowa | 19149 | 230 | 4 |
259681 | 259681 | 2020-06-21 | Plymouth | Iowa | 19149 | 247 | 4 |
262808 | 262808 | 2020-06-22 | Plymouth | Iowa | 19149 | 249 | 4 |
265936 | 265936 | 2020-06-23 | Plymouth | Iowa | 19149 | 253 | 4 |
269066 | 269066 | 2020-06-24 | Plymouth | Iowa | 19149 | 260 | 4 |
272203 | 272203 | 2020-06-25 | Plymouth | Iowa | 19149 | 272 | 4 |
275345 | 275345 | 2020-06-26 | Plymouth | Iowa | 19149 | 283 | 4 |
278493 | 278493 | 2020-06-27 | Plymouth | Iowa | 19149 | 288 | 4 |
281641 | 281641 | 2020-06-28 | Plymouth | Iowa | 19149 | 291 | 4 |
284786 | 284786 | 2020-06-29 | Plymouth | Iowa | 19149 | 297 | 4 |
287935 | 287935 | 2020-06-30 | Plymouth | Iowa | 19149 | 303 | 4 |
291085 | 291085 | 2020-07-01 | Plymouth | Iowa | 19149 | 308 | 4 |
294239 | 294239 | 2020-07-02 | Plymouth | Iowa | 19149 | 313 | 4 |
297397 | 297397 | 2020-07-03 | Plymouth | Iowa | 19149 | 313 | 5 |
300559 | 300559 | 2020-07-04 | Plymouth | Iowa | 19149 | 316 | 5 |
303723 | 303723 | 2020-07-05 | Plymouth | Iowa | 19149 | 322 | 5 |
306888 | 306888 | 2020-07-06 | Plymouth | Iowa | 19149 | 321 | 5 |
310056 | 310056 | 2020-07-07 | Plymouth | Iowa | 19149 | 324 | 5 |
313226 | 313226 | 2020-07-08 | Plymouth | Iowa | 19149 | 328 | 5 |
316400 | 316400 | 2020-07-09 | Plymouth | Iowa | 19149 | 336 | 5 |
319573 | 319573 | 2020-07-10 | Plymouth | Iowa | 19149 | 345 | 5 |
322752 | 322752 | 2020-07-11 | Plymouth | Iowa | 19149 | 347 | 5 |
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);