ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 21207 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387036 | 387036 | 2020-07-31 | Russell | Kentucky | 21207 | 106 | 5 |
383818 | 383818 | 2020-07-30 | Russell | Kentucky | 21207 | 101 | 5 |
380601 | 380601 | 2020-07-29 | Russell | Kentucky | 21207 | 99 | 5 |
377384 | 377384 | 2020-07-28 | Russell | Kentucky | 21207 | 99 | 5 |
374169 | 374169 | 2020-07-27 | Russell | Kentucky | 21207 | 99 | 5 |
370957 | 370957 | 2020-07-26 | Russell | Kentucky | 21207 | 95 | 5 |
367747 | 367747 | 2020-07-25 | Russell | Kentucky | 21207 | 94 | 5 |
364540 | 364540 | 2020-07-24 | Russell | Kentucky | 21207 | 93 | 5 |
361333 | 361333 | 2020-07-23 | Russell | Kentucky | 21207 | 91 | 5 |
358128 | 358128 | 2020-07-22 | Russell | Kentucky | 21207 | 89 | 5 |
354925 | 354925 | 2020-07-21 | Russell | Kentucky | 21207 | 88 | 5 |
351723 | 351723 | 2020-07-20 | Russell | Kentucky | 21207 | 88 | 5 |
348523 | 348523 | 2020-07-19 | Russell | Kentucky | 21207 | 84 | 5 |
345322 | 345322 | 2020-07-18 | Russell | Kentucky | 21207 | 84 | 5 |
342122 | 342122 | 2020-07-17 | Russell | Kentucky | 21207 | 84 | 5 |
338926 | 338926 | 2020-07-16 | Russell | Kentucky | 21207 | 83 | 5 |
335730 | 335730 | 2020-07-15 | Russell | Kentucky | 21207 | 80 | 5 |
332537 | 332537 | 2020-07-14 | Russell | Kentucky | 21207 | 73 | 5 |
329350 | 329350 | 2020-07-13 | Russell | Kentucky | 21207 | 73 | 5 |
326164 | 326164 | 2020-07-12 | Russell | Kentucky | 21207 | 73 | 5 |
322981 | 322981 | 2020-07-11 | Russell | Kentucky | 21207 | 73 | 5 |
319802 | 319802 | 2020-07-10 | Russell | Kentucky | 21207 | 70 | 5 |
316627 | 316627 | 2020-07-09 | Russell | Kentucky | 21207 | 65 | 5 |
313453 | 313453 | 2020-07-08 | Russell | Kentucky | 21207 | 65 | 4 |
310283 | 310283 | 2020-07-07 | Russell | Kentucky | 21207 | 61 | 4 |
307115 | 307115 | 2020-07-06 | Russell | Kentucky | 21207 | 58 | 4 |
303948 | 303948 | 2020-07-05 | Russell | Kentucky | 21207 | 57 | 4 |
300784 | 300784 | 2020-07-04 | Russell | Kentucky | 21207 | 57 | 4 |
297622 | 297622 | 2020-07-03 | Russell | Kentucky | 21207 | 52 | 4 |
294464 | 294464 | 2020-07-02 | Russell | Kentucky | 21207 | 50 | 4 |
291310 | 291310 | 2020-07-01 | Russell | Kentucky | 21207 | 47 | 4 |
288159 | 288159 | 2020-06-30 | Russell | Kentucky | 21207 | 46 | 4 |
285010 | 285010 | 2020-06-29 | Russell | Kentucky | 21207 | 45 | 4 |
281864 | 281864 | 2020-06-28 | Russell | Kentucky | 21207 | 44 | 4 |
278716 | 278716 | 2020-06-27 | Russell | Kentucky | 21207 | 44 | 4 |
275568 | 275568 | 2020-06-26 | Russell | Kentucky | 21207 | 43 | 4 |
272425 | 272425 | 2020-06-25 | Russell | Kentucky | 21207 | 40 | 4 |
269289 | 269289 | 2020-06-24 | Russell | Kentucky | 21207 | 39 | 4 |
266156 | 266156 | 2020-06-23 | Russell | Kentucky | 21207 | 39 | 4 |
263029 | 263029 | 2020-06-22 | Russell | Kentucky | 21207 | 39 | 4 |
259900 | 259900 | 2020-06-21 | Russell | Kentucky | 21207 | 39 | 4 |
256774 | 256774 | 2020-06-20 | Russell | Kentucky | 21207 | 38 | 4 |
253654 | 253654 | 2020-06-19 | Russell | Kentucky | 21207 | 38 | 4 |
250539 | 250539 | 2020-06-18 | Russell | Kentucky | 21207 | 38 | 4 |
247427 | 247427 | 2020-06-17 | Russell | Kentucky | 21207 | 38 | 4 |
244314 | 244314 | 2020-06-16 | Russell | Kentucky | 21207 | 38 | 4 |
241203 | 241203 | 2020-06-15 | Russell | Kentucky | 21207 | 38 | 4 |
238094 | 238094 | 2020-06-14 | Russell | Kentucky | 21207 | 38 | 4 |
234987 | 234987 | 2020-06-13 | Russell | Kentucky | 21207 | 38 | 4 |
231882 | 231882 | 2020-06-12 | Russell | Kentucky | 21207 | 37 | 4 |
228778 | 228778 | 2020-06-11 | Russell | Kentucky | 21207 | 37 | 4 |
225676 | 225676 | 2020-06-10 | Russell | Kentucky | 21207 | 36 | 4 |
222580 | 222580 | 2020-06-09 | Russell | Kentucky | 21207 | 36 | 4 |
219485 | 219485 | 2020-06-08 | Russell | Kentucky | 21207 | 35 | 4 |
216393 | 216393 | 2020-06-07 | Russell | Kentucky | 21207 | 30 | 4 |
213306 | 213306 | 2020-06-06 | Russell | Kentucky | 21207 | 30 | 4 |
210221 | 210221 | 2020-06-05 | Russell | Kentucky | 21207 | 30 | 4 |
207140 | 207140 | 2020-06-04 | Russell | Kentucky | 21207 | 26 | 4 |
204059 | 204059 | 2020-06-03 | Russell | Kentucky | 21207 | 25 | 4 |
200982 | 200982 | 2020-06-02 | Russell | Kentucky | 21207 | 24 | 4 |
197910 | 197910 | 2020-06-01 | Russell | Kentucky | 21207 | 24 | 4 |
194839 | 194839 | 2020-05-31 | Russell | Kentucky | 21207 | 24 | 4 |
191771 | 191771 | 2020-05-30 | Russell | Kentucky | 21207 | 24 | 4 |
188707 | 188707 | 2020-05-29 | Russell | Kentucky | 21207 | 23 | 4 |
185649 | 185649 | 2020-05-28 | Russell | Kentucky | 21207 | 23 | 4 |
182594 | 182594 | 2020-05-27 | Russell | Kentucky | 21207 | 23 | 4 |
179549 | 179549 | 2020-05-26 | Russell | Kentucky | 21207 | 23 | 4 |
176505 | 176505 | 2020-05-25 | Russell | Kentucky | 21207 | 23 | 4 |
173461 | 173461 | 2020-05-24 | Russell | Kentucky | 21207 | 23 | 4 |
170420 | 170420 | 2020-05-23 | Russell | Kentucky | 21207 | 23 | 4 |
167382 | 167382 | 2020-05-22 | Russell | Kentucky | 21207 | 23 | 4 |
164346 | 164346 | 2020-05-21 | Russell | Kentucky | 21207 | 23 | 4 |
161317 | 161317 | 2020-05-20 | Russell | Kentucky | 21207 | 23 | 4 |
158291 | 158291 | 2020-05-19 | Russell | Kentucky | 21207 | 23 | 4 |
155274 | 155274 | 2020-05-18 | Russell | Kentucky | 21207 | 23 | 4 |
152260 | 152260 | 2020-05-17 | Russell | Kentucky | 21207 | 23 | 4 |
149249 | 149249 | 2020-05-16 | Russell | Kentucky | 21207 | 23 | 4 |
146244 | 146244 | 2020-05-15 | Russell | Kentucky | 21207 | 19 | 4 |
143244 | 143244 | 2020-05-14 | Russell | Kentucky | 21207 | 19 | 4 |
140248 | 140248 | 2020-05-13 | Russell | Kentucky | 21207 | 18 | 4 |
137255 | 137255 | 2020-05-12 | Russell | Kentucky | 21207 | 18 | 4 |
134265 | 134265 | 2020-05-11 | Russell | Kentucky | 21207 | 18 | 4 |
131274 | 131274 | 2020-05-10 | Russell | Kentucky | 21207 | 18 | 4 |
128284 | 128284 | 2020-05-09 | Russell | Kentucky | 21207 | 18 | 4 |
125296 | 125296 | 2020-05-08 | Russell | Kentucky | 21207 | 18 | 4 |
122314 | 122314 | 2020-05-07 | Russell | Kentucky | 21207 | 17 | 4 |
119343 | 119343 | 2020-05-06 | Russell | Kentucky | 21207 | 17 | 4 |
116382 | 116382 | 2020-05-05 | Russell | Kentucky | 21207 | 17 | 3 |
113500 | 113500 | 2020-05-04 | Russell | Kentucky | 21207 | 16 | 3 |
110623 | 110623 | 2020-05-03 | Russell | Kentucky | 21207 | 16 | 3 |
107752 | 107752 | 2020-05-02 | Russell | Kentucky | 21207 | 16 | 3 |
104887 | 104887 | 2020-05-01 | Russell | Kentucky | 21207 | 16 | 3 |
102026 | 102026 | 2020-04-30 | Russell | Kentucky | 21207 | 16 | 3 |
99174 | 99174 | 2020-04-29 | Russell | Kentucky | 21207 | 16 | 3 |
96328 | 96328 | 2020-04-28 | Russell | Kentucky | 21207 | 16 | 3 |
93493 | 93493 | 2020-04-27 | Russell | Kentucky | 21207 | 16 | 2 |
90672 | 90672 | 2020-04-26 | Russell | Kentucky | 21207 | 16 | 2 |
87856 | 87856 | 2020-04-25 | Russell | Kentucky | 21207 | 16 | 2 |
85047 | 85047 | 2020-04-24 | Russell | Kentucky | 21207 | 16 | 2 |
82244 | 82244 | 2020-04-23 | Russell | Kentucky | 21207 | 16 | 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);