ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Union", fips = 21225 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387045 | 387045 | 2020-07-31 | Union | Kentucky | 21225 | 53 | 0 |
383827 | 383827 | 2020-07-30 | Union | Kentucky | 21225 | 52 | 0 |
380610 | 380610 | 2020-07-29 | Union | Kentucky | 21225 | 50 | 0 |
377393 | 377393 | 2020-07-28 | Union | Kentucky | 21225 | 50 | 0 |
374178 | 374178 | 2020-07-27 | Union | Kentucky | 21225 | 49 | 0 |
370966 | 370966 | 2020-07-26 | Union | Kentucky | 21225 | 46 | 0 |
367756 | 367756 | 2020-07-25 | Union | Kentucky | 21225 | 45 | 0 |
364549 | 364549 | 2020-07-24 | Union | Kentucky | 21225 | 44 | 0 |
361342 | 361342 | 2020-07-23 | Union | Kentucky | 21225 | 42 | 0 |
358137 | 358137 | 2020-07-22 | Union | Kentucky | 21225 | 40 | 0 |
354934 | 354934 | 2020-07-21 | Union | Kentucky | 21225 | 40 | 0 |
351732 | 351732 | 2020-07-20 | Union | Kentucky | 21225 | 37 | 0 |
348532 | 348532 | 2020-07-19 | Union | Kentucky | 21225 | 37 | 0 |
345331 | 345331 | 2020-07-18 | Union | Kentucky | 21225 | 34 | 0 |
342131 | 342131 | 2020-07-17 | Union | Kentucky | 21225 | 34 | 0 |
338935 | 338935 | 2020-07-16 | Union | Kentucky | 21225 | 33 | 0 |
335739 | 335739 | 2020-07-15 | Union | Kentucky | 21225 | 33 | 0 |
332546 | 332546 | 2020-07-14 | Union | Kentucky | 21225 | 32 | 0 |
329359 | 329359 | 2020-07-13 | Union | Kentucky | 21225 | 32 | 0 |
326173 | 326173 | 2020-07-12 | Union | Kentucky | 21225 | 32 | 0 |
322990 | 322990 | 2020-07-11 | Union | Kentucky | 21225 | 31 | 0 |
319811 | 319811 | 2020-07-10 | Union | Kentucky | 21225 | 30 | 0 |
316636 | 316636 | 2020-07-09 | Union | Kentucky | 21225 | 30 | 0 |
313462 | 313462 | 2020-07-08 | Union | Kentucky | 21225 | 30 | 0 |
310292 | 310292 | 2020-07-07 | Union | Kentucky | 21225 | 30 | 0 |
307124 | 307124 | 2020-07-06 | Union | Kentucky | 21225 | 29 | 0 |
303957 | 303957 | 2020-07-05 | Union | Kentucky | 21225 | 29 | 0 |
300793 | 300793 | 2020-07-04 | Union | Kentucky | 21225 | 29 | 0 |
297631 | 297631 | 2020-07-03 | Union | Kentucky | 21225 | 29 | 0 |
294473 | 294473 | 2020-07-02 | Union | Kentucky | 21225 | 29 | 0 |
291319 | 291319 | 2020-07-01 | Union | Kentucky | 21225 | 29 | 0 |
288168 | 288168 | 2020-06-30 | Union | Kentucky | 21225 | 29 | 0 |
285019 | 285019 | 2020-06-29 | Union | Kentucky | 21225 | 29 | 0 |
281873 | 281873 | 2020-06-28 | Union | Kentucky | 21225 | 29 | 0 |
278725 | 278725 | 2020-06-27 | Union | Kentucky | 21225 | 29 | 0 |
275577 | 275577 | 2020-06-26 | Union | Kentucky | 21225 | 28 | 0 |
272434 | 272434 | 2020-06-25 | Union | Kentucky | 21225 | 26 | 0 |
269298 | 269298 | 2020-06-24 | Union | Kentucky | 21225 | 25 | 0 |
266165 | 266165 | 2020-06-23 | Union | Kentucky | 21225 | 25 | 0 |
263038 | 263038 | 2020-06-22 | Union | Kentucky | 21225 | 25 | 0 |
259909 | 259909 | 2020-06-21 | Union | Kentucky | 21225 | 25 | 0 |
256783 | 256783 | 2020-06-20 | Union | Kentucky | 21225 | 25 | 0 |
253663 | 253663 | 2020-06-19 | Union | Kentucky | 21225 | 24 | 0 |
250548 | 250548 | 2020-06-18 | Union | Kentucky | 21225 | 22 | 0 |
247436 | 247436 | 2020-06-17 | Union | Kentucky | 21225 | 20 | 0 |
244323 | 244323 | 2020-06-16 | Union | Kentucky | 21225 | 19 | 0 |
241212 | 241212 | 2020-06-15 | Union | Kentucky | 21225 | 19 | 0 |
238103 | 238103 | 2020-06-14 | Union | Kentucky | 21225 | 17 | 0 |
234996 | 234996 | 2020-06-13 | Union | Kentucky | 21225 | 17 | 0 |
231891 | 231891 | 2020-06-12 | Union | Kentucky | 21225 | 16 | 0 |
228787 | 228787 | 2020-06-11 | Union | Kentucky | 21225 | 15 | 0 |
225685 | 225685 | 2020-06-10 | Union | Kentucky | 21225 | 15 | 0 |
222589 | 222589 | 2020-06-09 | Union | Kentucky | 21225 | 15 | 0 |
219494 | 219494 | 2020-06-08 | Union | Kentucky | 21225 | 15 | 0 |
216402 | 216402 | 2020-06-07 | Union | Kentucky | 21225 | 15 | 0 |
213315 | 213315 | 2020-06-06 | Union | Kentucky | 21225 | 15 | 0 |
210230 | 210230 | 2020-06-05 | Union | Kentucky | 21225 | 15 | 0 |
207149 | 207149 | 2020-06-04 | Union | Kentucky | 21225 | 15 | 0 |
204068 | 204068 | 2020-06-03 | Union | Kentucky | 21225 | 15 | 0 |
200991 | 200991 | 2020-06-02 | Union | Kentucky | 21225 | 15 | 0 |
197919 | 197919 | 2020-06-01 | Union | Kentucky | 21225 | 13 | 0 |
194848 | 194848 | 2020-05-31 | Union | Kentucky | 21225 | 11 | 0 |
191780 | 191780 | 2020-05-30 | Union | Kentucky | 21225 | 11 | 0 |
188716 | 188716 | 2020-05-29 | Union | Kentucky | 21225 | 11 | 0 |
185658 | 185658 | 2020-05-28 | Union | Kentucky | 21225 | 10 | 0 |
182603 | 182603 | 2020-05-27 | Union | Kentucky | 21225 | 10 | 0 |
179558 | 179558 | 2020-05-26 | Union | Kentucky | 21225 | 10 | 0 |
176514 | 176514 | 2020-05-25 | Union | Kentucky | 21225 | 10 | 0 |
173470 | 173470 | 2020-05-24 | Union | Kentucky | 21225 | 10 | 0 |
170429 | 170429 | 2020-05-23 | Union | Kentucky | 21225 | 10 | 0 |
167391 | 167391 | 2020-05-22 | Union | Kentucky | 21225 | 10 | 0 |
164355 | 164355 | 2020-05-21 | Union | Kentucky | 21225 | 10 | 0 |
161326 | 161326 | 2020-05-20 | Union | Kentucky | 21225 | 10 | 0 |
158300 | 158300 | 2020-05-19 | Union | Kentucky | 21225 | 10 | 0 |
155283 | 155283 | 2020-05-18 | Union | Kentucky | 21225 | 10 | 0 |
152269 | 152269 | 2020-05-17 | Union | Kentucky | 21225 | 10 | 0 |
149258 | 149258 | 2020-05-16 | Union | Kentucky | 21225 | 10 | 0 |
146253 | 146253 | 2020-05-15 | Union | Kentucky | 21225 | 10 | 0 |
143253 | 143253 | 2020-05-14 | Union | Kentucky | 21225 | 10 | 0 |
140257 | 140257 | 2020-05-13 | Union | Kentucky | 21225 | 10 | 0 |
137264 | 137264 | 2020-05-12 | Union | Kentucky | 21225 | 10 | 0 |
134274 | 134274 | 2020-05-11 | Union | Kentucky | 21225 | 10 | 0 |
131283 | 131283 | 2020-05-10 | Union | Kentucky | 21225 | 10 | 0 |
128293 | 128293 | 2020-05-09 | Union | Kentucky | 21225 | 10 | 0 |
125305 | 125305 | 2020-05-08 | Union | Kentucky | 21225 | 10 | 0 |
122323 | 122323 | 2020-05-07 | Union | Kentucky | 21225 | 10 | 0 |
119352 | 119352 | 2020-05-06 | Union | Kentucky | 21225 | 10 | 0 |
116391 | 116391 | 2020-05-05 | Union | Kentucky | 21225 | 9 | 0 |
113509 | 113509 | 2020-05-04 | Union | Kentucky | 21225 | 8 | 0 |
110632 | 110632 | 2020-05-03 | Union | Kentucky | 21225 | 8 | 0 |
107761 | 107761 | 2020-05-02 | Union | Kentucky | 21225 | 8 | 0 |
104896 | 104896 | 2020-05-01 | Union | Kentucky | 21225 | 8 | 0 |
102035 | 102035 | 2020-04-30 | Union | Kentucky | 21225 | 8 | 0 |
99183 | 99183 | 2020-04-29 | Union | Kentucky | 21225 | 8 | 0 |
96337 | 96337 | 2020-04-28 | Union | Kentucky | 21225 | 8 | 0 |
93502 | 93502 | 2020-04-27 | Union | Kentucky | 21225 | 8 | 0 |
90681 | 90681 | 2020-04-26 | Union | Kentucky | 21225 | 8 | 0 |
87865 | 87865 | 2020-04-25 | Union | Kentucky | 21225 | 8 | 0 |
85056 | 85056 | 2020-04-24 | Union | Kentucky | 21225 | 8 | 0 |
82253 | 82253 | 2020-04-23 | Union | Kentucky | 21225 | 8 | 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);