ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21199 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535520 | 535520 | 2020-09-15 | Pulaski | Kentucky | 21199 | 710 | 9 |
532285 | 532285 | 2020-09-14 | Pulaski | Kentucky | 21199 | 703 | 9 |
529048 | 529048 | 2020-09-13 | Pulaski | Kentucky | 21199 | 697 | 9 |
525812 | 525812 | 2020-09-12 | Pulaski | Kentucky | 21199 | 693 | 8 |
522576 | 522576 | 2020-09-11 | Pulaski | Kentucky | 21199 | 684 | 8 |
519339 | 519339 | 2020-09-10 | Pulaski | Kentucky | 21199 | 674 | 8 |
516104 | 516104 | 2020-09-09 | Pulaski | Kentucky | 21199 | 652 | 8 |
512871 | 512871 | 2020-09-08 | Pulaski | Kentucky | 21199 | 645 | 7 |
509639 | 509639 | 2020-09-07 | Pulaski | Kentucky | 21199 | 639 | 7 |
506406 | 506406 | 2020-09-06 | Pulaski | Kentucky | 21199 | 638 | 7 |
503172 | 503172 | 2020-09-05 | Pulaski | Kentucky | 21199 | 634 | 7 |
499939 | 499939 | 2020-09-04 | Pulaski | Kentucky | 21199 | 626 | 7 |
496705 | 496705 | 2020-09-03 | Pulaski | Kentucky | 21199 | 602 | 7 |
493472 | 493472 | 2020-09-02 | Pulaski | Kentucky | 21199 | 592 | 7 |
490238 | 490238 | 2020-09-01 | Pulaski | Kentucky | 21199 | 564 | 7 |
487005 | 487005 | 2020-08-31 | Pulaski | Kentucky | 21199 | 557 | 7 |
483770 | 483770 | 2020-08-30 | Pulaski | Kentucky | 21199 | 552 | 7 |
480536 | 480536 | 2020-08-29 | Pulaski | Kentucky | 21199 | 530 | 7 |
477303 | 477303 | 2020-08-28 | Pulaski | Kentucky | 21199 | 523 | 7 |
474070 | 474070 | 2020-08-27 | Pulaski | Kentucky | 21199 | 515 | 6 |
470838 | 470838 | 2020-08-26 | Pulaski | Kentucky | 21199 | 499 | 6 |
467609 | 467609 | 2020-08-25 | Pulaski | Kentucky | 21199 | 487 | 6 |
464380 | 464380 | 2020-08-24 | Pulaski | Kentucky | 21199 | 475 | 6 |
461149 | 461149 | 2020-08-23 | Pulaski | Kentucky | 21199 | 468 | 6 |
457922 | 457922 | 2020-08-22 | Pulaski | Kentucky | 21199 | 463 | 6 |
454694 | 454694 | 2020-08-21 | Pulaski | Kentucky | 21199 | 439 | 6 |
451466 | 451466 | 2020-08-20 | Pulaski | Kentucky | 21199 | 427 | 6 |
448238 | 448238 | 2020-08-19 | Pulaski | Kentucky | 21199 | 416 | 6 |
445011 | 445011 | 2020-08-18 | Pulaski | Kentucky | 21199 | 409 | 5 |
441785 | 441785 | 2020-08-17 | Pulaski | Kentucky | 21199 | 396 | 5 |
438558 | 438558 | 2020-08-16 | Pulaski | Kentucky | 21199 | 391 | 5 |
435333 | 435333 | 2020-08-15 | Pulaski | Kentucky | 21199 | 387 | 5 |
432108 | 432108 | 2020-08-14 | Pulaski | Kentucky | 21199 | 383 | 5 |
428880 | 428880 | 2020-08-13 | Pulaski | Kentucky | 21199 | 379 | 5 |
425656 | 425656 | 2020-08-12 | Pulaski | Kentucky | 21199 | 368 | 5 |
422435 | 422435 | 2020-08-11 | Pulaski | Kentucky | 21199 | 362 | 5 |
419213 | 419213 | 2020-08-10 | Pulaski | Kentucky | 21199 | 359 | 5 |
415992 | 415992 | 2020-08-09 | Pulaski | Kentucky | 21199 | 350 | 5 |
412772 | 412772 | 2020-08-08 | Pulaski | Kentucky | 21199 | 347 | 5 |
409552 | 409552 | 2020-08-07 | Pulaski | Kentucky | 21199 | 343 | 4 |
406332 | 406332 | 2020-08-06 | Pulaski | Kentucky | 21199 | 335 | 3 |
403114 | 403114 | 2020-08-05 | Pulaski | Kentucky | 21199 | 328 | 2 |
399897 | 399897 | 2020-08-04 | Pulaski | Kentucky | 21199 | 319 | 2 |
396682 | 396682 | 2020-08-03 | Pulaski | Kentucky | 21199 | 311 | 2 |
393466 | 393466 | 2020-08-02 | Pulaski | Kentucky | 21199 | 298 | 2 |
390249 | 390249 | 2020-08-01 | Pulaski | Kentucky | 21199 | 290 | 2 |
387032 | 387032 | 2020-07-31 | Pulaski | Kentucky | 21199 | 280 | 2 |
383814 | 383814 | 2020-07-30 | Pulaski | Kentucky | 21199 | 265 | 2 |
380597 | 380597 | 2020-07-29 | Pulaski | Kentucky | 21199 | 257 | 2 |
377380 | 377380 | 2020-07-28 | Pulaski | Kentucky | 21199 | 248 | 2 |
374165 | 374165 | 2020-07-27 | Pulaski | Kentucky | 21199 | 240 | 2 |
370953 | 370953 | 2020-07-26 | Pulaski | Kentucky | 21199 | 225 | 2 |
367743 | 367743 | 2020-07-25 | Pulaski | Kentucky | 21199 | 220 | 2 |
364536 | 364536 | 2020-07-24 | Pulaski | Kentucky | 21199 | 212 | 2 |
361329 | 361329 | 2020-07-23 | Pulaski | Kentucky | 21199 | 205 | 2 |
358124 | 358124 | 2020-07-22 | Pulaski | Kentucky | 21199 | 200 | 2 |
354921 | 354921 | 2020-07-21 | Pulaski | Kentucky | 21199 | 192 | 2 |
351719 | 351719 | 2020-07-20 | Pulaski | Kentucky | 21199 | 182 | 2 |
348519 | 348519 | 2020-07-19 | Pulaski | Kentucky | 21199 | 179 | 2 |
345318 | 345318 | 2020-07-18 | Pulaski | Kentucky | 21199 | 168 | 2 |
342118 | 342118 | 2020-07-17 | Pulaski | Kentucky | 21199 | 164 | 2 |
338922 | 338922 | 2020-07-16 | Pulaski | Kentucky | 21199 | 155 | 2 |
335726 | 335726 | 2020-07-15 | Pulaski | Kentucky | 21199 | 150 | 2 |
332533 | 332533 | 2020-07-14 | Pulaski | Kentucky | 21199 | 149 | 2 |
329346 | 329346 | 2020-07-13 | Pulaski | Kentucky | 21199 | 146 | 2 |
326160 | 326160 | 2020-07-12 | Pulaski | Kentucky | 21199 | 137 | 2 |
322977 | 322977 | 2020-07-11 | Pulaski | Kentucky | 21199 | 135 | 2 |
319798 | 319798 | 2020-07-10 | Pulaski | Kentucky | 21199 | 131 | 2 |
316623 | 316623 | 2020-07-09 | Pulaski | Kentucky | 21199 | 126 | 2 |
313449 | 313449 | 2020-07-08 | Pulaski | Kentucky | 21199 | 121 | 2 |
310279 | 310279 | 2020-07-07 | Pulaski | Kentucky | 21199 | 119 | 2 |
307111 | 307111 | 2020-07-06 | Pulaski | Kentucky | 21199 | 117 | 2 |
303944 | 303944 | 2020-07-05 | Pulaski | Kentucky | 21199 | 100 | 2 |
300780 | 300780 | 2020-07-04 | Pulaski | Kentucky | 21199 | 100 | 2 |
297618 | 297618 | 2020-07-03 | Pulaski | Kentucky | 21199 | 100 | 2 |
294460 | 294460 | 2020-07-02 | Pulaski | Kentucky | 21199 | 99 | 2 |
291306 | 291306 | 2020-07-01 | Pulaski | Kentucky | 21199 | 94 | 2 |
288156 | 288156 | 2020-06-30 | Pulaski | Kentucky | 21199 | 94 | 2 |
285007 | 285007 | 2020-06-29 | Pulaski | Kentucky | 21199 | 94 | 2 |
281861 | 281861 | 2020-06-28 | Pulaski | Kentucky | 21199 | 93 | 2 |
278713 | 278713 | 2020-06-27 | Pulaski | Kentucky | 21199 | 89 | 2 |
275565 | 275565 | 2020-06-26 | Pulaski | Kentucky | 21199 | 88 | 2 |
272422 | 272422 | 2020-06-25 | Pulaski | Kentucky | 21199 | 84 | 2 |
269286 | 269286 | 2020-06-24 | Pulaski | Kentucky | 21199 | 83 | 2 |
266153 | 266153 | 2020-06-23 | Pulaski | Kentucky | 21199 | 82 | 2 |
263026 | 263026 | 2020-06-22 | Pulaski | Kentucky | 21199 | 77 | 2 |
259897 | 259897 | 2020-06-21 | Pulaski | Kentucky | 21199 | 77 | 2 |
256771 | 256771 | 2020-06-20 | Pulaski | Kentucky | 21199 | 75 | 2 |
253651 | 253651 | 2020-06-19 | Pulaski | Kentucky | 21199 | 74 | 2 |
250536 | 250536 | 2020-06-18 | Pulaski | Kentucky | 21199 | 74 | 2 |
247424 | 247424 | 2020-06-17 | Pulaski | Kentucky | 21199 | 73 | 2 |
244311 | 244311 | 2020-06-16 | Pulaski | Kentucky | 21199 | 72 | 2 |
241200 | 241200 | 2020-06-15 | Pulaski | Kentucky | 21199 | 72 | 2 |
238091 | 238091 | 2020-06-14 | Pulaski | Kentucky | 21199 | 72 | 2 |
234984 | 234984 | 2020-06-13 | Pulaski | Kentucky | 21199 | 71 | 2 |
231879 | 231879 | 2020-06-12 | Pulaski | Kentucky | 21199 | 71 | 2 |
228775 | 228775 | 2020-06-11 | Pulaski | Kentucky | 21199 | 68 | 2 |
225673 | 225673 | 2020-06-10 | Pulaski | Kentucky | 21199 | 68 | 2 |
222577 | 222577 | 2020-06-09 | Pulaski | Kentucky | 21199 | 65 | 2 |
219482 | 219482 | 2020-06-08 | Pulaski | Kentucky | 21199 | 65 | 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);