ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lyon" and fips = 27083 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 |
---|---|---|---|---|---|---|---|
22714 | 22714 | 2020-03-31 | Lyon | Minnesota | 27083 | 1 | 0 |
24896 | 24896 | 2020-04-01 | Lyon | Minnesota | 27083 | 2 | 0 |
27150 | 27150 | 2020-04-02 | Lyon | Minnesota | 27083 | 3 | 0 |
29469 | 29469 | 2020-04-03 | Lyon | Minnesota | 27083 | 3 | 0 |
31847 | 31847 | 2020-04-04 | Lyon | Minnesota | 27083 | 3 | 0 |
34273 | 34273 | 2020-04-05 | Lyon | Minnesota | 27083 | 3 | 0 |
36733 | 36733 | 2020-04-06 | Lyon | Minnesota | 27083 | 4 | 0 |
39242 | 39242 | 2020-04-07 | Lyon | Minnesota | 27083 | 4 | 0 |
41795 | 41795 | 2020-04-08 | Lyon | Minnesota | 27083 | 4 | 0 |
44371 | 44371 | 2020-04-09 | Lyon | Minnesota | 27083 | 5 | 0 |
46980 | 46980 | 2020-04-10 | Lyon | Minnesota | 27083 | 5 | 0 |
49625 | 49625 | 2020-04-11 | Lyon | Minnesota | 27083 | 5 | 0 |
52295 | 52295 | 2020-04-12 | Lyon | Minnesota | 27083 | 5 | 0 |
54977 | 54977 | 2020-04-13 | Lyon | Minnesota | 27083 | 5 | 0 |
57675 | 57675 | 2020-04-14 | Lyon | Minnesota | 27083 | 5 | 0 |
60385 | 60385 | 2020-04-15 | Lyon | Minnesota | 27083 | 5 | 0 |
63107 | 63107 | 2020-04-16 | Lyon | Minnesota | 27083 | 5 | 0 |
68598 | 68598 | 2020-04-18 | Lyon | Minnesota | 27083 | 5 | 0 |
71362 | 71362 | 2020-04-19 | Lyon | Minnesota | 27083 | 5 | 0 |
74135 | 74135 | 2020-04-20 | Lyon | Minnesota | 27083 | 5 | 0 |
76915 | 76915 | 2020-04-21 | Lyon | Minnesota | 27083 | 5 | 0 |
65846 | 65846 | 2020-04-17 | Lyon | Minnesota | 27083 | 6 | 0 |
79700 | 79700 | 2020-04-22 | Lyon | Minnesota | 27083 | 6 | 0 |
82496 | 82496 | 2020-04-23 | Lyon | Minnesota | 27083 | 6 | 0 |
85300 | 85300 | 2020-04-24 | Lyon | Minnesota | 27083 | 6 | 0 |
88110 | 88110 | 2020-04-25 | Lyon | Minnesota | 27083 | 6 | 0 |
90926 | 90926 | 2020-04-26 | Lyon | Minnesota | 27083 | 6 | 0 |
93747 | 93747 | 2020-04-27 | Lyon | Minnesota | 27083 | 6 | 0 |
96582 | 96582 | 2020-04-28 | Lyon | Minnesota | 27083 | 6 | 0 |
99428 | 99428 | 2020-04-29 | Lyon | Minnesota | 27083 | 6 | 0 |
102280 | 102280 | 2020-04-30 | Lyon | Minnesota | 27083 | 7 | 0 |
105141 | 105141 | 2020-05-01 | Lyon | Minnesota | 27083 | 7 | 0 |
108006 | 108006 | 2020-05-02 | Lyon | Minnesota | 27083 | 8 | 0 |
110877 | 110877 | 2020-05-03 | Lyon | Minnesota | 27083 | 9 | 0 |
113756 | 113756 | 2020-05-04 | Lyon | Minnesota | 27083 | 9 | 0 |
116637 | 116637 | 2020-05-05 | Lyon | Minnesota | 27083 | 10 | 0 |
119597 | 119597 | 2020-05-06 | Lyon | Minnesota | 27083 | 11 | 0 |
122571 | 122571 | 2020-05-07 | Lyon | Minnesota | 27083 | 15 | 0 |
125553 | 125553 | 2020-05-08 | Lyon | Minnesota | 27083 | 16 | 0 |
128540 | 128540 | 2020-05-09 | Lyon | Minnesota | 27083 | 17 | 0 |
131530 | 131530 | 2020-05-10 | Lyon | Minnesota | 27083 | 17 | 0 |
134521 | 134521 | 2020-05-11 | Lyon | Minnesota | 27083 | 18 | 0 |
137511 | 137511 | 2020-05-12 | Lyon | Minnesota | 27083 | 20 | 0 |
140505 | 140505 | 2020-05-13 | Lyon | Minnesota | 27083 | 20 | 0 |
143500 | 143500 | 2020-05-14 | Lyon | Minnesota | 27083 | 22 | 0 |
146500 | 146500 | 2020-05-15 | Lyon | Minnesota | 27083 | 25 | 0 |
149505 | 149505 | 2020-05-16 | Lyon | Minnesota | 27083 | 25 | 0 |
152516 | 152516 | 2020-05-17 | Lyon | Minnesota | 27083 | 26 | 0 |
155530 | 155530 | 2020-05-18 | Lyon | Minnesota | 27083 | 26 | 0 |
158548 | 158548 | 2020-05-19 | Lyon | Minnesota | 27083 | 26 | 0 |
161574 | 161574 | 2020-05-20 | Lyon | Minnesota | 27083 | 26 | 0 |
164603 | 164603 | 2020-05-21 | Lyon | Minnesota | 27083 | 28 | 0 |
167639 | 167639 | 2020-05-22 | Lyon | Minnesota | 27083 | 29 | 0 |
170677 | 170677 | 2020-05-23 | Lyon | Minnesota | 27083 | 31 | 0 |
173719 | 173719 | 2020-05-24 | Lyon | Minnesota | 27083 | 31 | 0 |
176762 | 176762 | 2020-05-25 | Lyon | Minnesota | 27083 | 34 | 0 |
179806 | 179806 | 2020-05-26 | Lyon | Minnesota | 27083 | 36 | 0 |
182852 | 182852 | 2020-05-27 | Lyon | Minnesota | 27083 | 36 | 0 |
185907 | 185907 | 2020-05-28 | Lyon | Minnesota | 27083 | 38 | 0 |
188965 | 188965 | 2020-05-29 | Lyon | Minnesota | 27083 | 43 | 0 |
192029 | 192029 | 2020-05-30 | Lyon | Minnesota | 27083 | 49 | 0 |
195097 | 195097 | 2020-05-31 | Lyon | Minnesota | 27083 | 56 | 0 |
198168 | 198168 | 2020-06-01 | Lyon | Minnesota | 27083 | 57 | 0 |
201241 | 201241 | 2020-06-02 | Lyon | Minnesota | 27083 | 65 | 1 |
204318 | 204318 | 2020-06-03 | Lyon | Minnesota | 27083 | 71 | 1 |
207399 | 207399 | 2020-06-04 | Lyon | Minnesota | 27083 | 81 | 1 |
210480 | 210480 | 2020-06-05 | Lyon | Minnesota | 27083 | 101 | 2 |
213564 | 213564 | 2020-06-06 | Lyon | Minnesota | 27083 | 110 | 2 |
216652 | 216652 | 2020-06-07 | Lyon | Minnesota | 27083 | 133 | 2 |
219744 | 219744 | 2020-06-08 | Lyon | Minnesota | 27083 | 144 | 2 |
222839 | 222839 | 2020-06-09 | Lyon | Minnesota | 27083 | 145 | 2 |
225937 | 225937 | 2020-06-10 | Lyon | Minnesota | 27083 | 158 | 2 |
229039 | 229039 | 2020-06-11 | Lyon | Minnesota | 27083 | 174 | 2 |
232143 | 232143 | 2020-06-12 | Lyon | Minnesota | 27083 | 183 | 2 |
235249 | 235249 | 2020-06-13 | Lyon | Minnesota | 27083 | 199 | 2 |
238356 | 238356 | 2020-06-14 | Lyon | Minnesota | 27083 | 208 | 2 |
241465 | 241465 | 2020-06-15 | Lyon | Minnesota | 27083 | 214 | 2 |
244576 | 244576 | 2020-06-16 | Lyon | Minnesota | 27083 | 222 | 2 |
247689 | 247689 | 2020-06-17 | Lyon | Minnesota | 27083 | 229 | 2 |
250801 | 250801 | 2020-06-18 | Lyon | Minnesota | 27083 | 250 | 2 |
253916 | 253916 | 2020-06-19 | Lyon | Minnesota | 27083 | 258 | 2 |
257036 | 257036 | 2020-06-20 | Lyon | Minnesota | 27083 | 270 | 2 |
260162 | 260162 | 2020-06-21 | Lyon | Minnesota | 27083 | 274 | 2 |
263291 | 263291 | 2020-06-22 | Lyon | Minnesota | 27083 | 276 | 2 |
266417 | 266417 | 2020-06-23 | Lyon | Minnesota | 27083 | 277 | 2 |
269550 | 269550 | 2020-06-24 | Lyon | Minnesota | 27083 | 279 | 2 |
272687 | 272687 | 2020-06-25 | Lyon | Minnesota | 27083 | 284 | 2 |
275830 | 275830 | 2020-06-26 | Lyon | Minnesota | 27083 | 289 | 2 |
278978 | 278978 | 2020-06-27 | Lyon | Minnesota | 27083 | 291 | 2 |
282126 | 282126 | 2020-06-28 | Lyon | Minnesota | 27083 | 294 | 2 |
285271 | 285271 | 2020-06-29 | Lyon | Minnesota | 27083 | 295 | 2 |
288421 | 288421 | 2020-06-30 | Lyon | Minnesota | 27083 | 295 | 2 |
291572 | 291572 | 2020-07-01 | Lyon | Minnesota | 27083 | 300 | 2 |
294726 | 294726 | 2020-07-02 | Lyon | Minnesota | 27083 | 305 | 2 |
297884 | 297884 | 2020-07-03 | Lyon | Minnesota | 27083 | 309 | 2 |
301047 | 301047 | 2020-07-04 | Lyon | Minnesota | 27083 | 309 | 2 |
304211 | 304211 | 2020-07-05 | Lyon | Minnesota | 27083 | 312 | 2 |
307378 | 307378 | 2020-07-06 | Lyon | Minnesota | 27083 | 316 | 2 |
310546 | 310546 | 2020-07-07 | Lyon | Minnesota | 27083 | 327 | 2 |
313716 | 313716 | 2020-07-08 | Lyon | Minnesota | 27083 | 327 | 2 |
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);