ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and fips = 27081 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 |
---|---|---|---|---|---|---|---|
14837 | 14837 | 2020-03-27 | Lincoln | Minnesota | 27081 | 1 | 0 |
16659 | 16659 | 2020-03-28 | Lincoln | Minnesota | 27081 | 1 | 0 |
18578 | 18578 | 2020-03-29 | Lincoln | Minnesota | 27081 | 1 | 0 |
20599 | 20599 | 2020-03-30 | Lincoln | Minnesota | 27081 | 1 | 0 |
22713 | 22713 | 2020-03-31 | Lincoln | Minnesota | 27081 | 1 | 0 |
24895 | 24895 | 2020-04-01 | Lincoln | Minnesota | 27081 | 1 | 0 |
27149 | 27149 | 2020-04-02 | Lincoln | Minnesota | 27081 | 1 | 0 |
29468 | 29468 | 2020-04-03 | Lincoln | Minnesota | 27081 | 1 | 0 |
31846 | 31846 | 2020-04-04 | Lincoln | Minnesota | 27081 | 1 | 0 |
34272 | 34272 | 2020-04-05 | Lincoln | Minnesota | 27081 | 1 | 0 |
36732 | 36732 | 2020-04-06 | Lincoln | Minnesota | 27081 | 2 | 0 |
39241 | 39241 | 2020-04-07 | Lincoln | Minnesota | 27081 | 2 | 0 |
41794 | 41794 | 2020-04-08 | Lincoln | Minnesota | 27081 | 2 | 0 |
44370 | 44370 | 2020-04-09 | Lincoln | Minnesota | 27081 | 2 | 0 |
46979 | 46979 | 2020-04-10 | Lincoln | Minnesota | 27081 | 2 | 0 |
49624 | 49624 | 2020-04-11 | Lincoln | Minnesota | 27081 | 2 | 0 |
52294 | 52294 | 2020-04-12 | Lincoln | Minnesota | 27081 | 2 | 0 |
54976 | 54976 | 2020-04-13 | Lincoln | Minnesota | 27081 | 2 | 0 |
57674 | 57674 | 2020-04-14 | Lincoln | Minnesota | 27081 | 2 | 0 |
60384 | 60384 | 2020-04-15 | Lincoln | Minnesota | 27081 | 2 | 0 |
63106 | 63106 | 2020-04-16 | Lincoln | Minnesota | 27081 | 2 | 0 |
65845 | 65845 | 2020-04-17 | Lincoln | Minnesota | 27081 | 2 | 0 |
68597 | 68597 | 2020-04-18 | Lincoln | Minnesota | 27081 | 2 | 0 |
71361 | 71361 | 2020-04-19 | Lincoln | Minnesota | 27081 | 2 | 0 |
74134 | 74134 | 2020-04-20 | Lincoln | Minnesota | 27081 | 2 | 0 |
76914 | 76914 | 2020-04-21 | Lincoln | Minnesota | 27081 | 2 | 0 |
79699 | 79699 | 2020-04-22 | Lincoln | Minnesota | 27081 | 2 | 0 |
82495 | 82495 | 2020-04-23 | Lincoln | Minnesota | 27081 | 2 | 0 |
85299 | 85299 | 2020-04-24 | Lincoln | Minnesota | 27081 | 2 | 0 |
88109 | 88109 | 2020-04-25 | Lincoln | Minnesota | 27081 | 2 | 0 |
90925 | 90925 | 2020-04-26 | Lincoln | Minnesota | 27081 | 2 | 0 |
93746 | 93746 | 2020-04-27 | Lincoln | Minnesota | 27081 | 2 | 0 |
96581 | 96581 | 2020-04-28 | Lincoln | Minnesota | 27081 | 2 | 0 |
99427 | 99427 | 2020-04-29 | Lincoln | Minnesota | 27081 | 3 | 0 |
102279 | 102279 | 2020-04-30 | Lincoln | Minnesota | 27081 | 3 | 0 |
105140 | 105140 | 2020-05-01 | Lincoln | Minnesota | 27081 | 3 | 0 |
108005 | 108005 | 2020-05-02 | Lincoln | Minnesota | 27081 | 3 | 0 |
110876 | 110876 | 2020-05-03 | Lincoln | Minnesota | 27081 | 3 | 0 |
113755 | 113755 | 2020-05-04 | Lincoln | Minnesota | 27081 | 3 | 0 |
116636 | 116636 | 2020-05-05 | Lincoln | Minnesota | 27081 | 3 | 0 |
119596 | 119596 | 2020-05-06 | Lincoln | Minnesota | 27081 | 3 | 0 |
122570 | 122570 | 2020-05-07 | Lincoln | Minnesota | 27081 | 3 | 0 |
125552 | 125552 | 2020-05-08 | Lincoln | Minnesota | 27081 | 3 | 0 |
128539 | 128539 | 2020-05-09 | Lincoln | Minnesota | 27081 | 3 | 0 |
131529 | 131529 | 2020-05-10 | Lincoln | Minnesota | 27081 | 3 | 0 |
134520 | 134520 | 2020-05-11 | Lincoln | Minnesota | 27081 | 4 | 0 |
137510 | 137510 | 2020-05-12 | Lincoln | Minnesota | 27081 | 4 | 0 |
140504 | 140504 | 2020-05-13 | Lincoln | Minnesota | 27081 | 4 | 0 |
143499 | 143499 | 2020-05-14 | Lincoln | Minnesota | 27081 | 4 | 0 |
146499 | 146499 | 2020-05-15 | Lincoln | Minnesota | 27081 | 4 | 0 |
149504 | 149504 | 2020-05-16 | Lincoln | Minnesota | 27081 | 4 | 0 |
152515 | 152515 | 2020-05-17 | Lincoln | Minnesota | 27081 | 4 | 0 |
155529 | 155529 | 2020-05-18 | Lincoln | Minnesota | 27081 | 4 | 0 |
158547 | 158547 | 2020-05-19 | Lincoln | Minnesota | 27081 | 4 | 0 |
161573 | 161573 | 2020-05-20 | Lincoln | Minnesota | 27081 | 4 | 0 |
164602 | 164602 | 2020-05-21 | Lincoln | Minnesota | 27081 | 4 | 0 |
167638 | 167638 | 2020-05-22 | Lincoln | Minnesota | 27081 | 4 | 0 |
170676 | 170676 | 2020-05-23 | Lincoln | Minnesota | 27081 | 5 | 0 |
173718 | 173718 | 2020-05-24 | Lincoln | Minnesota | 27081 | 5 | 0 |
176761 | 176761 | 2020-05-25 | Lincoln | Minnesota | 27081 | 5 | 0 |
179805 | 179805 | 2020-05-26 | Lincoln | Minnesota | 27081 | 5 | 0 |
182851 | 182851 | 2020-05-27 | Lincoln | Minnesota | 27081 | 5 | 0 |
185906 | 185906 | 2020-05-28 | Lincoln | Minnesota | 27081 | 5 | 0 |
188964 | 188964 | 2020-05-29 | Lincoln | Minnesota | 27081 | 5 | 0 |
192028 | 192028 | 2020-05-30 | Lincoln | Minnesota | 27081 | 5 | 0 |
195096 | 195096 | 2020-05-31 | Lincoln | Minnesota | 27081 | 5 | 0 |
198167 | 198167 | 2020-06-01 | Lincoln | Minnesota | 27081 | 5 | 0 |
201240 | 201240 | 2020-06-02 | Lincoln | Minnesota | 27081 | 6 | 0 |
204317 | 204317 | 2020-06-03 | Lincoln | Minnesota | 27081 | 6 | 0 |
207398 | 207398 | 2020-06-04 | Lincoln | Minnesota | 27081 | 6 | 0 |
210479 | 210479 | 2020-06-05 | Lincoln | Minnesota | 27081 | 6 | 0 |
213563 | 213563 | 2020-06-06 | Lincoln | Minnesota | 27081 | 6 | 0 |
216651 | 216651 | 2020-06-07 | Lincoln | Minnesota | 27081 | 6 | 0 |
219743 | 219743 | 2020-06-08 | Lincoln | Minnesota | 27081 | 6 | 0 |
222838 | 222838 | 2020-06-09 | Lincoln | Minnesota | 27081 | 6 | 0 |
225936 | 225936 | 2020-06-10 | Lincoln | Minnesota | 27081 | 6 | 0 |
229038 | 229038 | 2020-06-11 | Lincoln | Minnesota | 27081 | 6 | 0 |
232142 | 232142 | 2020-06-12 | Lincoln | Minnesota | 27081 | 6 | 0 |
235248 | 235248 | 2020-06-13 | Lincoln | Minnesota | 27081 | 6 | 0 |
238355 | 238355 | 2020-06-14 | Lincoln | Minnesota | 27081 | 6 | 0 |
241464 | 241464 | 2020-06-15 | Lincoln | Minnesota | 27081 | 6 | 0 |
244575 | 244575 | 2020-06-16 | Lincoln | Minnesota | 27081 | 6 | 0 |
247688 | 247688 | 2020-06-17 | Lincoln | Minnesota | 27081 | 6 | 0 |
250800 | 250800 | 2020-06-18 | Lincoln | Minnesota | 27081 | 6 | 0 |
253915 | 253915 | 2020-06-19 | Lincoln | Minnesota | 27081 | 6 | 0 |
257035 | 257035 | 2020-06-20 | Lincoln | Minnesota | 27081 | 6 | 0 |
260161 | 260161 | 2020-06-21 | Lincoln | Minnesota | 27081 | 6 | 0 |
263290 | 263290 | 2020-06-22 | Lincoln | Minnesota | 27081 | 6 | 0 |
266416 | 266416 | 2020-06-23 | Lincoln | Minnesota | 27081 | 6 | 0 |
269549 | 269549 | 2020-06-24 | Lincoln | Minnesota | 27081 | 7 | 0 |
272686 | 272686 | 2020-06-25 | Lincoln | Minnesota | 27081 | 7 | 0 |
275829 | 275829 | 2020-06-26 | Lincoln | Minnesota | 27081 | 7 | 0 |
278977 | 278977 | 2020-06-27 | Lincoln | Minnesota | 27081 | 7 | 0 |
282125 | 282125 | 2020-06-28 | Lincoln | Minnesota | 27081 | 7 | 0 |
285270 | 285270 | 2020-06-29 | Lincoln | Minnesota | 27081 | 9 | 0 |
288420 | 288420 | 2020-06-30 | Lincoln | Minnesota | 27081 | 8 | 0 |
291571 | 291571 | 2020-07-01 | Lincoln | Minnesota | 27081 | 9 | 0 |
294725 | 294725 | 2020-07-02 | Lincoln | Minnesota | 27081 | 10 | 0 |
297883 | 297883 | 2020-07-03 | Lincoln | Minnesota | 27081 | 10 | 0 |
301046 | 301046 | 2020-07-04 | Lincoln | Minnesota | 27081 | 10 | 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);