ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 21085 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386975 | 386975 | 2020-07-31 | Grayson | Kentucky | 21085 | 175 | 11 |
383757 | 383757 | 2020-07-30 | Grayson | Kentucky | 21085 | 171 | 11 |
380540 | 380540 | 2020-07-29 | Grayson | Kentucky | 21085 | 169 | 11 |
377323 | 377323 | 2020-07-28 | Grayson | Kentucky | 21085 | 167 | 11 |
374108 | 374108 | 2020-07-27 | Grayson | Kentucky | 21085 | 166 | 11 |
370896 | 370896 | 2020-07-26 | Grayson | Kentucky | 21085 | 166 | 11 |
367686 | 367686 | 2020-07-25 | Grayson | Kentucky | 21085 | 166 | 11 |
364479 | 364479 | 2020-07-24 | Grayson | Kentucky | 21085 | 166 | 11 |
361272 | 361272 | 2020-07-23 | Grayson | Kentucky | 21085 | 165 | 11 |
358067 | 358067 | 2020-07-22 | Grayson | Kentucky | 21085 | 163 | 11 |
354864 | 354864 | 2020-07-21 | Grayson | Kentucky | 21085 | 162 | 11 |
351662 | 351662 | 2020-07-20 | Grayson | Kentucky | 21085 | 159 | 11 |
348462 | 348462 | 2020-07-19 | Grayson | Kentucky | 21085 | 158 | 11 |
345261 | 345261 | 2020-07-18 | Grayson | Kentucky | 21085 | 157 | 11 |
342061 | 342061 | 2020-07-17 | Grayson | Kentucky | 21085 | 156 | 11 |
338865 | 338865 | 2020-07-16 | Grayson | Kentucky | 21085 | 156 | 11 |
335669 | 335669 | 2020-07-15 | Grayson | Kentucky | 21085 | 152 | 11 |
332476 | 332476 | 2020-07-14 | Grayson | Kentucky | 21085 | 150 | 11 |
329289 | 329289 | 2020-07-13 | Grayson | Kentucky | 21085 | 147 | 11 |
326103 | 326103 | 2020-07-12 | Grayson | Kentucky | 21085 | 147 | 11 |
322920 | 322920 | 2020-07-11 | Grayson | Kentucky | 21085 | 147 | 11 |
319741 | 319741 | 2020-07-10 | Grayson | Kentucky | 21085 | 146 | 11 |
316566 | 316566 | 2020-07-09 | Grayson | Kentucky | 21085 | 143 | 11 |
313392 | 313392 | 2020-07-08 | Grayson | Kentucky | 21085 | 140 | 11 |
310222 | 310222 | 2020-07-07 | Grayson | Kentucky | 21085 | 140 | 11 |
307054 | 307054 | 2020-07-06 | Grayson | Kentucky | 21085 | 140 | 11 |
303887 | 303887 | 2020-07-05 | Grayson | Kentucky | 21085 | 140 | 11 |
300723 | 300723 | 2020-07-04 | Grayson | Kentucky | 21085 | 140 | 11 |
297561 | 297561 | 2020-07-03 | Grayson | Kentucky | 21085 | 140 | 11 |
294403 | 294403 | 2020-07-02 | Grayson | Kentucky | 21085 | 139 | 11 |
291249 | 291249 | 2020-07-01 | Grayson | Kentucky | 21085 | 138 | 10 |
288099 | 288099 | 2020-06-30 | Grayson | Kentucky | 21085 | 138 | 10 |
284950 | 284950 | 2020-06-29 | Grayson | Kentucky | 21085 | 137 | 10 |
281804 | 281804 | 2020-06-28 | Grayson | Kentucky | 21085 | 137 | 10 |
278656 | 278656 | 2020-06-27 | Grayson | Kentucky | 21085 | 137 | 10 |
275508 | 275508 | 2020-06-26 | Grayson | Kentucky | 21085 | 137 | 10 |
272365 | 272365 | 2020-06-25 | Grayson | Kentucky | 21085 | 137 | 10 |
269229 | 269229 | 2020-06-24 | Grayson | Kentucky | 21085 | 137 | 10 |
266096 | 266096 | 2020-06-23 | Grayson | Kentucky | 21085 | 137 | 10 |
262969 | 262969 | 2020-06-22 | Grayson | Kentucky | 21085 | 137 | 10 |
259840 | 259840 | 2020-06-21 | Grayson | Kentucky | 21085 | 137 | 10 |
256714 | 256714 | 2020-06-20 | Grayson | Kentucky | 21085 | 137 | 10 |
253594 | 253594 | 2020-06-19 | Grayson | Kentucky | 21085 | 137 | 10 |
250479 | 250479 | 2020-06-18 | Grayson | Kentucky | 21085 | 137 | 10 |
247367 | 247367 | 2020-06-17 | Grayson | Kentucky | 21085 | 137 | 11 |
244254 | 244254 | 2020-06-16 | Grayson | Kentucky | 21085 | 137 | 11 |
241143 | 241143 | 2020-06-15 | Grayson | Kentucky | 21085 | 137 | 11 |
238034 | 238034 | 2020-06-14 | Grayson | Kentucky | 21085 | 137 | 11 |
234927 | 234927 | 2020-06-13 | Grayson | Kentucky | 21085 | 137 | 11 |
231822 | 231822 | 2020-06-12 | Grayson | Kentucky | 21085 | 136 | 10 |
228718 | 228718 | 2020-06-11 | Grayson | Kentucky | 21085 | 135 | 10 |
225616 | 225616 | 2020-06-10 | Grayson | Kentucky | 21085 | 135 | 10 |
222520 | 222520 | 2020-06-09 | Grayson | Kentucky | 21085 | 135 | 10 |
219425 | 219425 | 2020-06-08 | Grayson | Kentucky | 21085 | 135 | 10 |
216333 | 216333 | 2020-06-07 | Grayson | Kentucky | 21085 | 135 | 10 |
213246 | 213246 | 2020-06-06 | Grayson | Kentucky | 21085 | 135 | 10 |
210161 | 210161 | 2020-06-05 | Grayson | Kentucky | 21085 | 134 | 10 |
207080 | 207080 | 2020-06-04 | Grayson | Kentucky | 21085 | 132 | 10 |
203999 | 203999 | 2020-06-03 | Grayson | Kentucky | 21085 | 127 | 9 |
200922 | 200922 | 2020-06-02 | Grayson | Kentucky | 21085 | 126 | 9 |
197850 | 197850 | 2020-06-01 | Grayson | Kentucky | 21085 | 126 | 9 |
194779 | 194779 | 2020-05-31 | Grayson | Kentucky | 21085 | 124 | 8 |
191711 | 191711 | 2020-05-30 | Grayson | Kentucky | 21085 | 124 | 8 |
188647 | 188647 | 2020-05-29 | Grayson | Kentucky | 21085 | 124 | 8 |
185589 | 185589 | 2020-05-28 | Grayson | Kentucky | 21085 | 124 | 8 |
182535 | 182535 | 2020-05-27 | Grayson | Kentucky | 21085 | 124 | 8 |
179490 | 179490 | 2020-05-26 | Grayson | Kentucky | 21085 | 124 | 8 |
176446 | 176446 | 2020-05-25 | Grayson | Kentucky | 21085 | 121 | 8 |
173402 | 173402 | 2020-05-24 | Grayson | Kentucky | 21085 | 121 | 8 |
170361 | 170361 | 2020-05-23 | Grayson | Kentucky | 21085 | 121 | 8 |
167323 | 167323 | 2020-05-22 | Grayson | Kentucky | 21085 | 120 | 8 |
164287 | 164287 | 2020-05-21 | Grayson | Kentucky | 21085 | 119 | 8 |
161258 | 161258 | 2020-05-20 | Grayson | Kentucky | 21085 | 110 | 8 |
158232 | 158232 | 2020-05-19 | Grayson | Kentucky | 21085 | 109 | 8 |
155215 | 155215 | 2020-05-18 | Grayson | Kentucky | 21085 | 107 | 8 |
152201 | 152201 | 2020-05-17 | Grayson | Kentucky | 21085 | 103 | 8 |
149190 | 149190 | 2020-05-16 | Grayson | Kentucky | 21085 | 103 | 8 |
146186 | 146186 | 2020-05-15 | Grayson | Kentucky | 21085 | 103 | 8 |
143186 | 143186 | 2020-05-14 | Grayson | Kentucky | 21085 | 101 | 8 |
140190 | 140190 | 2020-05-13 | Grayson | Kentucky | 21085 | 99 | 6 |
137197 | 137197 | 2020-05-12 | Grayson | Kentucky | 21085 | 99 | 6 |
134207 | 134207 | 2020-05-11 | Grayson | Kentucky | 21085 | 98 | 6 |
131216 | 131216 | 2020-05-10 | Grayson | Kentucky | 21085 | 95 | 6 |
128226 | 128226 | 2020-05-09 | Grayson | Kentucky | 21085 | 95 | 6 |
125238 | 125238 | 2020-05-08 | Grayson | Kentucky | 21085 | 93 | 6 |
122256 | 122256 | 2020-05-07 | Grayson | Kentucky | 21085 | 93 | 6 |
119286 | 119286 | 2020-05-06 | Grayson | Kentucky | 21085 | 90 | 5 |
116325 | 116325 | 2020-05-05 | Grayson | Kentucky | 21085 | 91 | 5 |
113443 | 113443 | 2020-05-04 | Grayson | Kentucky | 21085 | 84 | 5 |
110566 | 110566 | 2020-05-03 | Grayson | Kentucky | 21085 | 79 | 5 |
107695 | 107695 | 2020-05-02 | Grayson | Kentucky | 21085 | 69 | 5 |
104830 | 104830 | 2020-05-01 | Grayson | Kentucky | 21085 | 69 | 5 |
101969 | 101969 | 2020-04-30 | Grayson | Kentucky | 21085 | 65 | 5 |
99117 | 99117 | 2020-04-29 | Grayson | Kentucky | 21085 | 62 | 3 |
96271 | 96271 | 2020-04-28 | Grayson | Kentucky | 21085 | 60 | 1 |
93438 | 93438 | 2020-04-27 | Grayson | Kentucky | 21085 | 60 | 1 |
90617 | 90617 | 2020-04-26 | Grayson | Kentucky | 21085 | 60 | 1 |
87801 | 87801 | 2020-04-25 | Grayson | Kentucky | 21085 | 42 | 1 |
84992 | 84992 | 2020-04-24 | Grayson | Kentucky | 21085 | 37 | 1 |
82189 | 82189 | 2020-04-23 | Grayson | Kentucky | 21085 | 25 | 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);