ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,895 rows where county = "Lyon" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Lyon · 3,895 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
29101 | 29101 | 2020-04-03 | Lyon | Iowa | 19119 | 1 | 0 |
31472 | 31472 | 2020-04-04 | Lyon | Iowa | 19119 | 2 | 0 |
33885 | 33885 | 2020-04-05 | Lyon | Iowa | 19119 | 2 | 0 |
36340 | 36340 | 2020-04-06 | Lyon | Iowa | 19119 | 2 | 0 |
38841 | 38841 | 2020-04-07 | Lyon | Iowa | 19119 | 2 | 0 |
41387 | 41387 | 2020-04-08 | Lyon | Iowa | 19119 | 2 | 0 |
43963 | 43963 | 2020-04-09 | Lyon | Iowa | 19119 | 2 | 0 |
46568 | 46568 | 2020-04-10 | Lyon | Iowa | 19119 | 2 | 0 |
49202 | 49202 | 2020-04-11 | Lyon | Iowa | 19119 | 2 | 0 |
51866 | 51866 | 2020-04-12 | Lyon | Iowa | 19119 | 3 | 0 |
54548 | 54548 | 2020-04-13 | Lyon | Iowa | 19119 | 4 | 0 |
57241 | 57241 | 2020-04-14 | Lyon | Iowa | 19119 | 4 | 0 |
59949 | 59949 | 2020-04-15 | Lyon | Iowa | 19119 | 4 | 0 |
62670 | 62670 | 2020-04-16 | Lyon | Iowa | 19119 | 5 | 0 |
65404 | 65404 | 2020-04-17 | Lyon | Iowa | 19119 | 5 | 0 |
68153 | 68153 | 2020-04-18 | Lyon | Iowa | 19119 | 5 | 0 |
70915 | 70915 | 2020-04-19 | Lyon | Iowa | 19119 | 5 | 0 |
73686 | 73686 | 2020-04-20 | Lyon | Iowa | 19119 | 5 | 0 |
76465 | 76465 | 2020-04-21 | Lyon | Iowa | 19119 | 5 | 0 |
79249 | 79249 | 2020-04-22 | Lyon | Iowa | 19119 | 5 | 0 |
82042 | 82042 | 2020-04-23 | Lyon | Iowa | 19119 | 5 | 0 |
84842 | 84842 | 2020-04-24 | Lyon | Iowa | 19119 | 5 | 0 |
87652 | 87652 | 2020-04-25 | Lyon | Iowa | 19119 | 6 | 0 |
90468 | 90468 | 2020-04-26 | Lyon | Iowa | 19119 | 7 | 0 |
93287 | 93287 | 2020-04-27 | Lyon | Iowa | 19119 | 9 | 0 |
96119 | 96119 | 2020-04-28 | Lyon | Iowa | 19119 | 11 | 0 |
98964 | 98964 | 2020-04-29 | Lyon | Iowa | 19119 | 11 | 0 |
101815 | 101815 | 2020-04-30 | Lyon | Iowa | 19119 | 13 | 0 |
104673 | 104673 | 2020-05-01 | Lyon | Iowa | 19119 | 13 | 0 |
107538 | 107538 | 2020-05-02 | Lyon | Iowa | 19119 | 13 | 0 |
110408 | 110408 | 2020-05-03 | Lyon | Iowa | 19119 | 14 | 0 |
113283 | 113283 | 2020-05-04 | Lyon | Iowa | 19119 | 15 | 0 |
116166 | 116166 | 2020-05-05 | Lyon | Iowa | 19119 | 15 | 0 |
119126 | 119126 | 2020-05-06 | Lyon | Iowa | 19119 | 15 | 0 |
122096 | 122096 | 2020-05-07 | Lyon | Iowa | 19119 | 15 | 0 |
125077 | 125077 | 2020-05-08 | Lyon | Iowa | 19119 | 16 | 0 |
128064 | 128064 | 2020-05-09 | Lyon | Iowa | 19119 | 16 | 0 |
131055 | 131055 | 2020-05-10 | Lyon | Iowa | 19119 | 16 | 0 |
134045 | 134045 | 2020-05-11 | Lyon | Iowa | 19119 | 16 | 0 |
137035 | 137035 | 2020-05-12 | Lyon | Iowa | 19119 | 16 | 0 |
140028 | 140028 | 2020-05-13 | Lyon | Iowa | 19119 | 16 | 0 |
143024 | 143024 | 2020-05-14 | Lyon | Iowa | 19119 | 16 | 0 |
146024 | 146024 | 2020-05-15 | Lyon | Iowa | 19119 | 16 | 0 |
149028 | 149028 | 2020-05-16 | Lyon | Iowa | 19119 | 16 | 0 |
152039 | 152039 | 2020-05-17 | Lyon | Iowa | 19119 | 19 | 0 |
155051 | 155051 | 2020-05-18 | Lyon | Iowa | 19119 | 19 | 0 |
158067 | 158067 | 2020-05-19 | Lyon | Iowa | 19119 | 19 | 0 |
161093 | 161093 | 2020-05-20 | Lyon | Iowa | 19119 | 19 | 0 |
164121 | 164121 | 2020-05-21 | Lyon | Iowa | 19119 | 19 | 0 |
167154 | 167154 | 2020-05-22 | Lyon | Iowa | 19119 | 19 | 0 |
170191 | 170191 | 2020-05-23 | Lyon | Iowa | 19119 | 19 | 0 |
173232 | 173232 | 2020-05-24 | Lyon | Iowa | 19119 | 19 | 0 |
176276 | 176276 | 2020-05-25 | Lyon | Iowa | 19119 | 19 | 0 |
179320 | 179320 | 2020-05-26 | Lyon | Iowa | 19119 | 19 | 0 |
182365 | 182365 | 2020-05-27 | Lyon | Iowa | 19119 | 19 | 0 |
185419 | 185419 | 2020-05-28 | Lyon | Iowa | 19119 | 19 | 0 |
188477 | 188477 | 2020-05-29 | Lyon | Iowa | 19119 | 20 | 0 |
191542 | 191542 | 2020-05-30 | Lyon | Iowa | 19119 | 21 | 0 |
194609 | 194609 | 2020-05-31 | Lyon | Iowa | 19119 | 24 | 0 |
197679 | 197679 | 2020-06-01 | Lyon | Iowa | 19119 | 24 | 0 |
200752 | 200752 | 2020-06-02 | Lyon | Iowa | 19119 | 24 | 0 |
203828 | 203828 | 2020-06-03 | Lyon | Iowa | 19119 | 25 | 0 |
206908 | 206908 | 2020-06-04 | Lyon | Iowa | 19119 | 24 | 0 |
209989 | 209989 | 2020-06-05 | Lyon | Iowa | 19119 | 24 | 0 |
213074 | 213074 | 2020-06-06 | Lyon | Iowa | 19119 | 25 | 0 |
216161 | 216161 | 2020-06-07 | Lyon | Iowa | 19119 | 26 | 0 |
219253 | 219253 | 2020-06-08 | Lyon | Iowa | 19119 | 26 | 0 |
222348 | 222348 | 2020-06-09 | Lyon | Iowa | 19119 | 26 | 0 |
225443 | 225443 | 2020-06-10 | Lyon | Iowa | 19119 | 26 | 0 |
228545 | 228545 | 2020-06-11 | Lyon | Iowa | 19119 | 28 | 0 |
231648 | 231648 | 2020-06-12 | Lyon | Iowa | 19119 | 30 | 0 |
234754 | 234754 | 2020-06-13 | Lyon | Iowa | 19119 | 30 | 0 |
237861 | 237861 | 2020-06-14 | Lyon | Iowa | 19119 | 31 | 0 |
240969 | 240969 | 2020-06-15 | Lyon | Iowa | 19119 | 31 | 0 |
244080 | 244080 | 2020-06-16 | Lyon | Iowa | 19119 | 31 | 0 |
247193 | 247193 | 2020-06-17 | Lyon | Iowa | 19119 | 32 | 0 |
250305 | 250305 | 2020-06-18 | Lyon | Iowa | 19119 | 32 | 0 |
253420 | 253420 | 2020-06-19 | Lyon | Iowa | 19119 | 32 | 0 |
256540 | 256540 | 2020-06-20 | Lyon | Iowa | 19119 | 32 | 0 |
259666 | 259666 | 2020-06-21 | Lyon | Iowa | 19119 | 36 | 0 |
262793 | 262793 | 2020-06-22 | Lyon | Iowa | 19119 | 36 | 0 |
265921 | 265921 | 2020-06-23 | Lyon | Iowa | 19119 | 37 | 0 |
269051 | 269051 | 2020-06-24 | Lyon | Iowa | 19119 | 37 | 0 |
272188 | 272188 | 2020-06-25 | Lyon | Iowa | 19119 | 37 | 0 |
275330 | 275330 | 2020-06-26 | Lyon | Iowa | 19119 | 38 | 0 |
278478 | 278478 | 2020-06-27 | Lyon | Iowa | 19119 | 39 | 0 |
281626 | 281626 | 2020-06-28 | Lyon | Iowa | 19119 | 39 | 0 |
284771 | 284771 | 2020-06-29 | Lyon | Iowa | 19119 | 39 | 0 |
287920 | 287920 | 2020-06-30 | Lyon | Iowa | 19119 | 40 | 0 |
291070 | 291070 | 2020-07-01 | Lyon | Iowa | 19119 | 40 | 0 |
294224 | 294224 | 2020-07-02 | Lyon | Iowa | 19119 | 40 | 0 |
297382 | 297382 | 2020-07-03 | Lyon | Iowa | 19119 | 41 | 0 |
300544 | 300544 | 2020-07-04 | Lyon | Iowa | 19119 | 43 | 0 |
303708 | 303708 | 2020-07-05 | Lyon | Iowa | 19119 | 44 | 0 |
306873 | 306873 | 2020-07-06 | Lyon | Iowa | 19119 | 45 | 0 |
310041 | 310041 | 2020-07-07 | Lyon | Iowa | 19119 | 45 | 0 |
313211 | 313211 | 2020-07-08 | Lyon | Iowa | 19119 | 47 | 0 |
316385 | 316385 | 2020-07-09 | Lyon | Iowa | 19119 | 48 | 0 |
319558 | 319558 | 2020-07-10 | Lyon | Iowa | 19119 | 52 | 0 |
322737 | 322737 | 2020-07-11 | Lyon | Iowa | 19119 | 57 | 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);