ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lincoln" and fips = 21137 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
26901 | 26901 | 2020-04-02 | Lincoln | Kentucky | 21137 | 1 | 0 |
29217 | 29217 | 2020-04-03 | Lincoln | Kentucky | 21137 | 1 | 0 |
31593 | 31593 | 2020-04-04 | Lincoln | Kentucky | 21137 | 1 | 0 |
34015 | 34015 | 2020-04-05 | Lincoln | Kentucky | 21137 | 1 | 0 |
36473 | 36473 | 2020-04-06 | Lincoln | Kentucky | 21137 | 1 | 0 |
38980 | 38980 | 2020-04-07 | Lincoln | Kentucky | 21137 | 1 | 0 |
41530 | 41530 | 2020-04-08 | Lincoln | Kentucky | 21137 | 1 | 0 |
44106 | 44106 | 2020-04-09 | Lincoln | Kentucky | 21137 | 1 | 0 |
46714 | 46714 | 2020-04-10 | Lincoln | Kentucky | 21137 | 1 | 0 |
49354 | 49354 | 2020-04-11 | Lincoln | Kentucky | 21137 | 1 | 0 |
52020 | 52020 | 2020-04-12 | Lincoln | Kentucky | 21137 | 1 | 0 |
54701 | 54701 | 2020-04-13 | Lincoln | Kentucky | 21137 | 1 | 0 |
57398 | 57398 | 2020-04-14 | Lincoln | Kentucky | 21137 | 1 | 0 |
60107 | 60107 | 2020-04-15 | Lincoln | Kentucky | 21137 | 2 | 1 |
62827 | 62827 | 2020-04-16 | Lincoln | Kentucky | 21137 | 3 | 1 |
65566 | 65566 | 2020-04-17 | Lincoln | Kentucky | 21137 | 4 | 1 |
68315 | 68315 | 2020-04-18 | Lincoln | Kentucky | 21137 | 4 | 1 |
71078 | 71078 | 2020-04-19 | Lincoln | Kentucky | 21137 | 4 | 1 |
73850 | 73850 | 2020-04-20 | Lincoln | Kentucky | 21137 | 4 | 1 |
76631 | 76631 | 2020-04-21 | Lincoln | Kentucky | 21137 | 4 | 1 |
79416 | 79416 | 2020-04-22 | Lincoln | Kentucky | 21137 | 4 | 1 |
82213 | 82213 | 2020-04-23 | Lincoln | Kentucky | 21137 | 4 | 1 |
85016 | 85016 | 2020-04-24 | Lincoln | Kentucky | 21137 | 4 | 1 |
87825 | 87825 | 2020-04-25 | Lincoln | Kentucky | 21137 | 4 | 1 |
90641 | 90641 | 2020-04-26 | Lincoln | Kentucky | 21137 | 4 | 1 |
93462 | 93462 | 2020-04-27 | Lincoln | Kentucky | 21137 | 4 | 1 |
96295 | 96295 | 2020-04-28 | Lincoln | Kentucky | 21137 | 5 | 1 |
99141 | 99141 | 2020-04-29 | Lincoln | Kentucky | 21137 | 5 | 1 |
101993 | 101993 | 2020-04-30 | Lincoln | Kentucky | 21137 | 5 | 1 |
104854 | 104854 | 2020-05-01 | Lincoln | Kentucky | 21137 | 5 | 1 |
107719 | 107719 | 2020-05-02 | Lincoln | Kentucky | 21137 | 5 | 1 |
110590 | 110590 | 2020-05-03 | Lincoln | Kentucky | 21137 | 5 | 1 |
113467 | 113467 | 2020-05-04 | Lincoln | Kentucky | 21137 | 5 | 1 |
116349 | 116349 | 2020-05-05 | Lincoln | Kentucky | 21137 | 5 | 1 |
119310 | 119310 | 2020-05-06 | Lincoln | Kentucky | 21137 | 6 | 1 |
122281 | 122281 | 2020-05-07 | Lincoln | Kentucky | 21137 | 6 | 1 |
125263 | 125263 | 2020-05-08 | Lincoln | Kentucky | 21137 | 5 | 1 |
128251 | 128251 | 2020-05-09 | Lincoln | Kentucky | 21137 | 5 | 1 |
131241 | 131241 | 2020-05-10 | Lincoln | Kentucky | 21137 | 5 | 1 |
134232 | 134232 | 2020-05-11 | Lincoln | Kentucky | 21137 | 5 | 1 |
137222 | 137222 | 2020-05-12 | Lincoln | Kentucky | 21137 | 5 | 1 |
140215 | 140215 | 2020-05-13 | Lincoln | Kentucky | 21137 | 5 | 1 |
143211 | 143211 | 2020-05-14 | Lincoln | Kentucky | 21137 | 5 | 1 |
146211 | 146211 | 2020-05-15 | Lincoln | Kentucky | 21137 | 7 | 1 |
149215 | 149215 | 2020-05-16 | Lincoln | Kentucky | 21137 | 7 | 1 |
152226 | 152226 | 2020-05-17 | Lincoln | Kentucky | 21137 | 7 | 1 |
155240 | 155240 | 2020-05-18 | Lincoln | Kentucky | 21137 | 7 | 1 |
158257 | 158257 | 2020-05-19 | Lincoln | Kentucky | 21137 | 7 | 1 |
161283 | 161283 | 2020-05-20 | Lincoln | Kentucky | 21137 | 7 | 1 |
164312 | 164312 | 2020-05-21 | Lincoln | Kentucky | 21137 | 8 | 1 |
167348 | 167348 | 2020-05-22 | Lincoln | Kentucky | 21137 | 8 | 1 |
170386 | 170386 | 2020-05-23 | Lincoln | Kentucky | 21137 | 8 | 1 |
173427 | 173427 | 2020-05-24 | Lincoln | Kentucky | 21137 | 8 | 1 |
176471 | 176471 | 2020-05-25 | Lincoln | Kentucky | 21137 | 8 | 1 |
179515 | 179515 | 2020-05-26 | Lincoln | Kentucky | 21137 | 8 | 1 |
182560 | 182560 | 2020-05-27 | Lincoln | Kentucky | 21137 | 8 | 1 |
185615 | 185615 | 2020-05-28 | Lincoln | Kentucky | 21137 | 8 | 1 |
188673 | 188673 | 2020-05-29 | Lincoln | Kentucky | 21137 | 8 | 1 |
191737 | 191737 | 2020-05-30 | Lincoln | Kentucky | 21137 | 8 | 1 |
194805 | 194805 | 2020-05-31 | Lincoln | Kentucky | 21137 | 8 | 1 |
197876 | 197876 | 2020-06-01 | Lincoln | Kentucky | 21137 | 8 | 1 |
200948 | 200948 | 2020-06-02 | Lincoln | Kentucky | 21137 | 8 | 1 |
204025 | 204025 | 2020-06-03 | Lincoln | Kentucky | 21137 | 8 | 1 |
207106 | 207106 | 2020-06-04 | Lincoln | Kentucky | 21137 | 9 | 1 |
210187 | 210187 | 2020-06-05 | Lincoln | Kentucky | 21137 | 11 | 1 |
213272 | 213272 | 2020-06-06 | Lincoln | Kentucky | 21137 | 11 | 1 |
216359 | 216359 | 2020-06-07 | Lincoln | Kentucky | 21137 | 11 | 1 |
219451 | 219451 | 2020-06-08 | Lincoln | Kentucky | 21137 | 11 | 1 |
222546 | 222546 | 2020-06-09 | Lincoln | Kentucky | 21137 | 14 | 1 |
225642 | 225642 | 2020-06-10 | Lincoln | Kentucky | 21137 | 14 | 1 |
228744 | 228744 | 2020-06-11 | Lincoln | Kentucky | 21137 | 14 | 1 |
231848 | 231848 | 2020-06-12 | Lincoln | Kentucky | 21137 | 15 | 1 |
234953 | 234953 | 2020-06-13 | Lincoln | Kentucky | 21137 | 15 | 1 |
238060 | 238060 | 2020-06-14 | Lincoln | Kentucky | 21137 | 15 | 1 |
241169 | 241169 | 2020-06-15 | Lincoln | Kentucky | 21137 | 15 | 1 |
244280 | 244280 | 2020-06-16 | Lincoln | Kentucky | 21137 | 15 | 1 |
247393 | 247393 | 2020-06-17 | Lincoln | Kentucky | 21137 | 15 | 1 |
250505 | 250505 | 2020-06-18 | Lincoln | Kentucky | 21137 | 15 | 1 |
253620 | 253620 | 2020-06-19 | Lincoln | Kentucky | 21137 | 17 | 1 |
256740 | 256740 | 2020-06-20 | Lincoln | Kentucky | 21137 | 17 | 1 |
259866 | 259866 | 2020-06-21 | Lincoln | Kentucky | 21137 | 18 | 1 |
262995 | 262995 | 2020-06-22 | Lincoln | Kentucky | 21137 | 20 | 1 |
266122 | 266122 | 2020-06-23 | Lincoln | Kentucky | 21137 | 21 | 1 |
269255 | 269255 | 2020-06-24 | Lincoln | Kentucky | 21137 | 21 | 1 |
272391 | 272391 | 2020-06-25 | Lincoln | Kentucky | 21137 | 24 | 1 |
275534 | 275534 | 2020-06-26 | Lincoln | Kentucky | 21137 | 24 | 1 |
278682 | 278682 | 2020-06-27 | Lincoln | Kentucky | 21137 | 25 | 1 |
281830 | 281830 | 2020-06-28 | Lincoln | Kentucky | 21137 | 25 | 1 |
284976 | 284976 | 2020-06-29 | Lincoln | Kentucky | 21137 | 25 | 1 |
288125 | 288125 | 2020-06-30 | Lincoln | Kentucky | 21137 | 28 | 1 |
291275 | 291275 | 2020-07-01 | Lincoln | Kentucky | 21137 | 28 | 1 |
294429 | 294429 | 2020-07-02 | Lincoln | Kentucky | 21137 | 29 | 1 |
297587 | 297587 | 2020-07-03 | Lincoln | Kentucky | 21137 | 30 | 1 |
300749 | 300749 | 2020-07-04 | Lincoln | Kentucky | 21137 | 30 | 1 |
303913 | 303913 | 2020-07-05 | Lincoln | Kentucky | 21137 | 30 | 1 |
307080 | 307080 | 2020-07-06 | Lincoln | Kentucky | 21137 | 36 | 1 |
310248 | 310248 | 2020-07-07 | Lincoln | Kentucky | 21137 | 39 | 1 |
313418 | 313418 | 2020-07-08 | Lincoln | Kentucky | 21137 | 42 | 1 |
316592 | 316592 | 2020-07-09 | Lincoln | Kentucky | 21137 | 42 | 1 |
319767 | 319767 | 2020-07-10 | Lincoln | Kentucky | 21137 | 48 | 1 |
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);