ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Boone" and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12909 | 12909 | 2020-03-26 | Boone | Kentucky | 21015 | 2 | 0 |
14612 | 14612 | 2020-03-27 | Boone | Kentucky | 21015 | 3 | 0 |
16420 | 16420 | 2020-03-28 | Boone | Kentucky | 21015 | 4 | 0 |
18329 | 18329 | 2020-03-29 | Boone | Kentucky | 21015 | 4 | 0 |
20343 | 20343 | 2020-03-30 | Boone | Kentucky | 21015 | 5 | 0 |
22443 | 22443 | 2020-03-31 | Boone | Kentucky | 21015 | 5 | 0 |
24619 | 24619 | 2020-04-01 | Boone | Kentucky | 21015 | 5 | 0 |
26864 | 26864 | 2020-04-02 | Boone | Kentucky | 21015 | 5 | 0 |
29180 | 29180 | 2020-04-03 | Boone | Kentucky | 21015 | 5 | 0 |
31554 | 31554 | 2020-04-04 | Boone | Kentucky | 21015 | 6 | 1 |
33971 | 33971 | 2020-04-05 | Boone | Kentucky | 21015 | 27 | 1 |
36429 | 36429 | 2020-04-06 | Boone | Kentucky | 21015 | 27 | 1 |
38934 | 38934 | 2020-04-07 | Boone | Kentucky | 21015 | 34 | 1 |
41483 | 41483 | 2020-04-08 | Boone | Kentucky | 21015 | 34 | 1 |
44058 | 44058 | 2020-04-09 | Boone | Kentucky | 21015 | 46 | 1 |
46666 | 46666 | 2020-04-10 | Boone | Kentucky | 21015 | 48 | 1 |
49303 | 49303 | 2020-04-11 | Boone | Kentucky | 21015 | 48 | 2 |
51969 | 51969 | 2020-04-12 | Boone | Kentucky | 21015 | 54 | 2 |
54650 | 54650 | 2020-04-13 | Boone | Kentucky | 21015 | 58 | 2 |
57345 | 57345 | 2020-04-14 | Boone | Kentucky | 21015 | 61 | 2 |
60054 | 60054 | 2020-04-15 | Boone | Kentucky | 21015 | 65 | 2 |
62774 | 62774 | 2020-04-16 | Boone | Kentucky | 21015 | 67 | 2 |
65513 | 65513 | 2020-04-17 | Boone | Kentucky | 21015 | 73 | 2 |
68262 | 68262 | 2020-04-18 | Boone | Kentucky | 21015 | 74 | 2 |
71023 | 71023 | 2020-04-19 | Boone | Kentucky | 21015 | 81 | 2 |
73795 | 73795 | 2020-04-20 | Boone | Kentucky | 21015 | 81 | 2 |
76575 | 76575 | 2020-04-21 | Boone | Kentucky | 21015 | 86 | 2 |
79360 | 79360 | 2020-04-22 | Boone | Kentucky | 21015 | 93 | 2 |
82156 | 82156 | 2020-04-23 | Boone | Kentucky | 21015 | 94 | 2 |
84959 | 84959 | 2020-04-24 | Boone | Kentucky | 21015 | 98 | 2 |
87768 | 87768 | 2020-04-25 | Boone | Kentucky | 21015 | 103 | 2 |
90584 | 90584 | 2020-04-26 | Boone | Kentucky | 21015 | 113 | 2 |
93405 | 93405 | 2020-04-27 | Boone | Kentucky | 21015 | 116 | 2 |
96238 | 96238 | 2020-04-28 | Boone | Kentucky | 21015 | 125 | 2 |
99084 | 99084 | 2020-04-29 | Boone | Kentucky | 21015 | 125 | 2 |
101936 | 101936 | 2020-04-30 | Boone | Kentucky | 21015 | 138 | 2 |
104797 | 104797 | 2020-05-01 | Boone | Kentucky | 21015 | 144 | 2 |
107662 | 107662 | 2020-05-02 | Boone | Kentucky | 21015 | 144 | 2 |
110533 | 110533 | 2020-05-03 | Boone | Kentucky | 21015 | 170 | 2 |
113410 | 113410 | 2020-05-04 | Boone | Kentucky | 21015 | 172 | 4 |
116292 | 116292 | 2020-05-05 | Boone | Kentucky | 21015 | 191 | 4 |
119253 | 119253 | 2020-05-06 | Boone | Kentucky | 21015 | 196 | 4 |
122223 | 122223 | 2020-05-07 | Boone | Kentucky | 21015 | 197 | 4 |
125205 | 125205 | 2020-05-08 | Boone | Kentucky | 21015 | 203 | 4 |
128193 | 128193 | 2020-05-09 | Boone | Kentucky | 21015 | 213 | 4 |
131183 | 131183 | 2020-05-10 | Boone | Kentucky | 21015 | 218 | 4 |
134174 | 134174 | 2020-05-11 | Boone | Kentucky | 21015 | 232 | 5 |
137164 | 137164 | 2020-05-12 | Boone | Kentucky | 21015 | 250 | 8 |
140157 | 140157 | 2020-05-13 | Boone | Kentucky | 21015 | 268 | 8 |
143153 | 143153 | 2020-05-14 | Boone | Kentucky | 21015 | 283 | 8 |
146153 | 146153 | 2020-05-15 | Boone | Kentucky | 21015 | 312 | 8 |
149157 | 149157 | 2020-05-16 | Boone | Kentucky | 21015 | 326 | 8 |
152168 | 152168 | 2020-05-17 | Boone | Kentucky | 21015 | 342 | 8 |
155182 | 155182 | 2020-05-18 | Boone | Kentucky | 21015 | 355 | 10 |
158199 | 158199 | 2020-05-19 | Boone | Kentucky | 21015 | 361 | 11 |
161224 | 161224 | 2020-05-20 | Boone | Kentucky | 21015 | 363 | 11 |
164253 | 164253 | 2020-05-21 | Boone | Kentucky | 21015 | 368 | 11 |
167289 | 167289 | 2020-05-22 | Boone | Kentucky | 21015 | 379 | 11 |
170327 | 170327 | 2020-05-23 | Boone | Kentucky | 21015 | 401 | 11 |
173368 | 173368 | 2020-05-24 | Boone | Kentucky | 21015 | 401 | 11 |
176412 | 176412 | 2020-05-25 | Boone | Kentucky | 21015 | 401 | 11 |
179456 | 179456 | 2020-05-26 | Boone | Kentucky | 21015 | 425 | 11 |
182501 | 182501 | 2020-05-27 | Boone | Kentucky | 21015 | 429 | 17 |
185555 | 185555 | 2020-05-28 | Boone | Kentucky | 21015 | 435 | 17 |
188613 | 188613 | 2020-05-29 | Boone | Kentucky | 21015 | 447 | 17 |
191677 | 191677 | 2020-05-30 | Boone | Kentucky | 21015 | 458 | 17 |
194745 | 194745 | 2020-05-31 | Boone | Kentucky | 21015 | 462 | 17 |
197816 | 197816 | 2020-06-01 | Boone | Kentucky | 21015 | 466 | 17 |
200887 | 200887 | 2020-06-02 | Boone | Kentucky | 21015 | 469 | 17 |
203964 | 203964 | 2020-06-03 | Boone | Kentucky | 21015 | 492 | 18 |
207045 | 207045 | 2020-06-04 | Boone | Kentucky | 21015 | 505 | 18 |
210126 | 210126 | 2020-06-05 | Boone | Kentucky | 21015 | 508 | 18 |
213211 | 213211 | 2020-06-06 | Boone | Kentucky | 21015 | 516 | 18 |
216298 | 216298 | 2020-06-07 | Boone | Kentucky | 21015 | 516 | 18 |
219390 | 219390 | 2020-06-08 | Boone | Kentucky | 21015 | 522 | 18 |
222485 | 222485 | 2020-06-09 | Boone | Kentucky | 21015 | 527 | 18 |
225581 | 225581 | 2020-06-10 | Boone | Kentucky | 21015 | 532 | 18 |
228683 | 228683 | 2020-06-11 | Boone | Kentucky | 21015 | 535 | 21 |
231787 | 231787 | 2020-06-12 | Boone | Kentucky | 21015 | 538 | 21 |
234892 | 234892 | 2020-06-13 | Boone | Kentucky | 21015 | 539 | 21 |
237999 | 237999 | 2020-06-14 | Boone | Kentucky | 21015 | 539 | 21 |
241108 | 241108 | 2020-06-15 | Boone | Kentucky | 21015 | 541 | 21 |
244219 | 244219 | 2020-06-16 | Boone | Kentucky | 21015 | 541 | 23 |
247332 | 247332 | 2020-06-17 | Boone | Kentucky | 21015 | 552 | 23 |
250444 | 250444 | 2020-06-18 | Boone | Kentucky | 21015 | 557 | 23 |
253559 | 253559 | 2020-06-19 | Boone | Kentucky | 21015 | 567 | 23 |
256679 | 256679 | 2020-06-20 | Boone | Kentucky | 21015 | 567 | 23 |
259805 | 259805 | 2020-06-21 | Boone | Kentucky | 21015 | 570 | 23 |
262934 | 262934 | 2020-06-22 | Boone | Kentucky | 21015 | 575 | 23 |
266061 | 266061 | 2020-06-23 | Boone | Kentucky | 21015 | 579 | 23 |
269194 | 269194 | 2020-06-24 | Boone | Kentucky | 21015 | 587 | 23 |
272330 | 272330 | 2020-06-25 | Boone | Kentucky | 21015 | 588 | 23 |
275473 | 275473 | 2020-06-26 | Boone | Kentucky | 21015 | 590 | 23 |
278621 | 278621 | 2020-06-27 | Boone | Kentucky | 21015 | 594 | 23 |
281769 | 281769 | 2020-06-28 | Boone | Kentucky | 21015 | 594 | 23 |
284915 | 284915 | 2020-06-29 | Boone | Kentucky | 21015 | 594 | 23 |
288064 | 288064 | 2020-06-30 | Boone | Kentucky | 21015 | 597 | 23 |
291214 | 291214 | 2020-07-01 | Boone | Kentucky | 21015 | 602 | 23 |
294368 | 294368 | 2020-07-02 | Boone | Kentucky | 21015 | 606 | 23 |
297526 | 297526 | 2020-07-03 | Boone | Kentucky | 21015 | 615 | 23 |
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);