ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lincoln" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
622977 | 622977 | 2020-10-12 | Lincoln | Kentucky | 21137 | 250 | 16 |
619733 | 619733 | 2020-10-11 | Lincoln | Kentucky | 21137 | 246 | 16 |
616491 | 616491 | 2020-10-10 | Lincoln | Kentucky | 21137 | 245 | 16 |
613250 | 613250 | 2020-10-09 | Lincoln | Kentucky | 21137 | 246 | 16 |
610008 | 610008 | 2020-10-08 | Lincoln | Kentucky | 21137 | 244 | 16 |
606766 | 606766 | 2020-10-07 | Lincoln | Kentucky | 21137 | 242 | 15 |
603524 | 603524 | 2020-10-06 | Lincoln | Kentucky | 21137 | 238 | 15 |
600281 | 600281 | 2020-10-05 | Lincoln | Kentucky | 21137 | 227 | 15 |
597039 | 597039 | 2020-10-04 | Lincoln | Kentucky | 21137 | 225 | 15 |
593797 | 593797 | 2020-10-03 | Lincoln | Kentucky | 21137 | 225 | 15 |
590556 | 590556 | 2020-10-02 | Lincoln | Kentucky | 21137 | 220 | 13 |
587315 | 587315 | 2020-10-01 | Lincoln | Kentucky | 21137 | 213 | 13 |
584075 | 584075 | 2020-09-30 | Lincoln | Kentucky | 21137 | 210 | 13 |
580835 | 580835 | 2020-09-29 | Lincoln | Kentucky | 21137 | 200 | 13 |
577594 | 577594 | 2020-09-28 | Lincoln | Kentucky | 21137 | 192 | 13 |
574352 | 574352 | 2020-09-27 | Lincoln | Kentucky | 21137 | 192 | 13 |
571109 | 571109 | 2020-09-26 | Lincoln | Kentucky | 21137 | 192 | 13 |
567867 | 567867 | 2020-09-25 | Lincoln | Kentucky | 21137 | 188 | 13 |
564627 | 564627 | 2020-09-24 | Lincoln | Kentucky | 21137 | 186 | 13 |
561387 | 561387 | 2020-09-23 | Lincoln | Kentucky | 21137 | 183 | 13 |
558151 | 558151 | 2020-09-22 | Lincoln | Kentucky | 21137 | 183 | 13 |
554914 | 554914 | 2020-09-21 | Lincoln | Kentucky | 21137 | 179 | 13 |
551675 | 551675 | 2020-09-20 | Lincoln | Kentucky | 21137 | 179 | 13 |
548436 | 548436 | 2020-09-19 | Lincoln | Kentucky | 21137 | 179 | 13 |
545198 | 545198 | 2020-09-18 | Lincoln | Kentucky | 21137 | 178 | 12 |
541962 | 541962 | 2020-09-17 | Lincoln | Kentucky | 21137 | 175 | 12 |
538726 | 538726 | 2020-09-16 | Lincoln | Kentucky | 21137 | 171 | 12 |
535489 | 535489 | 2020-09-15 | Lincoln | Kentucky | 21137 | 165 | 12 |
532254 | 532254 | 2020-09-14 | Lincoln | Kentucky | 21137 | 164 | 12 |
529017 | 529017 | 2020-09-13 | Lincoln | Kentucky | 21137 | 161 | 12 |
525781 | 525781 | 2020-09-12 | Lincoln | Kentucky | 21137 | 160 | 12 |
522545 | 522545 | 2020-09-11 | Lincoln | Kentucky | 21137 | 157 | 12 |
519308 | 519308 | 2020-09-10 | Lincoln | Kentucky | 21137 | 151 | 11 |
516073 | 516073 | 2020-09-09 | Lincoln | Kentucky | 21137 | 150 | 11 |
512840 | 512840 | 2020-09-08 | Lincoln | Kentucky | 21137 | 148 | 10 |
509608 | 509608 | 2020-09-07 | Lincoln | Kentucky | 21137 | 146 | 10 |
506375 | 506375 | 2020-09-06 | Lincoln | Kentucky | 21137 | 146 | 10 |
503141 | 503141 | 2020-09-05 | Lincoln | Kentucky | 21137 | 145 | 10 |
499908 | 499908 | 2020-09-04 | Lincoln | Kentucky | 21137 | 144 | 10 |
496674 | 496674 | 2020-09-03 | Lincoln | Kentucky | 21137 | 142 | 10 |
493441 | 493441 | 2020-09-02 | Lincoln | Kentucky | 21137 | 141 | 10 |
490207 | 490207 | 2020-09-01 | Lincoln | Kentucky | 21137 | 141 | 9 |
486974 | 486974 | 2020-08-31 | Lincoln | Kentucky | 21137 | 139 | 7 |
483739 | 483739 | 2020-08-30 | Lincoln | Kentucky | 21137 | 138 | 6 |
480505 | 480505 | 2020-08-29 | Lincoln | Kentucky | 21137 | 137 | 5 |
477272 | 477272 | 2020-08-28 | Lincoln | Kentucky | 21137 | 134 | 2 |
474039 | 474039 | 2020-08-27 | Lincoln | Kentucky | 21137 | 134 | 2 |
470807 | 470807 | 2020-08-26 | Lincoln | Kentucky | 21137 | 132 | 2 |
467578 | 467578 | 2020-08-25 | Lincoln | Kentucky | 21137 | 132 | 2 |
464349 | 464349 | 2020-08-24 | Lincoln | Kentucky | 21137 | 132 | 2 |
461118 | 461118 | 2020-08-23 | Lincoln | Kentucky | 21137 | 130 | 2 |
457891 | 457891 | 2020-08-22 | Lincoln | Kentucky | 21137 | 130 | 2 |
454663 | 454663 | 2020-08-21 | Lincoln | Kentucky | 21137 | 130 | 2 |
451435 | 451435 | 2020-08-20 | Lincoln | Kentucky | 21137 | 128 | 2 |
448207 | 448207 | 2020-08-19 | Lincoln | Kentucky | 21137 | 123 | 2 |
444980 | 444980 | 2020-08-18 | Lincoln | Kentucky | 21137 | 121 | 2 |
441754 | 441754 | 2020-08-17 | Lincoln | Kentucky | 21137 | 121 | 2 |
438527 | 438527 | 2020-08-16 | Lincoln | Kentucky | 21137 | 119 | 2 |
435302 | 435302 | 2020-08-15 | Lincoln | Kentucky | 21137 | 119 | 2 |
432077 | 432077 | 2020-08-14 | Lincoln | Kentucky | 21137 | 118 | 2 |
428849 | 428849 | 2020-08-13 | Lincoln | Kentucky | 21137 | 118 | 2 |
425625 | 425625 | 2020-08-12 | Lincoln | Kentucky | 21137 | 117 | 2 |
422404 | 422404 | 2020-08-11 | Lincoln | Kentucky | 21137 | 116 | 2 |
419182 | 419182 | 2020-08-10 | Lincoln | Kentucky | 21137 | 106 | 2 |
415961 | 415961 | 2020-08-09 | Lincoln | Kentucky | 21137 | 105 | 1 |
412741 | 412741 | 2020-08-08 | Lincoln | Kentucky | 21137 | 102 | 1 |
409521 | 409521 | 2020-08-07 | Lincoln | Kentucky | 21137 | 101 | 1 |
406301 | 406301 | 2020-08-06 | Lincoln | Kentucky | 21137 | 100 | 1 |
403083 | 403083 | 2020-08-05 | Lincoln | Kentucky | 21137 | 99 | 1 |
399866 | 399866 | 2020-08-04 | Lincoln | Kentucky | 21137 | 99 | 1 |
396651 | 396651 | 2020-08-03 | Lincoln | Kentucky | 21137 | 99 | 1 |
393435 | 393435 | 2020-08-02 | Lincoln | Kentucky | 21137 | 99 | 1 |
390218 | 390218 | 2020-08-01 | Lincoln | Kentucky | 21137 | 98 | 1 |
387001 | 387001 | 2020-07-31 | Lincoln | Kentucky | 21137 | 96 | 1 |
383783 | 383783 | 2020-07-30 | Lincoln | Kentucky | 21137 | 92 | 1 |
380566 | 380566 | 2020-07-29 | Lincoln | Kentucky | 21137 | 90 | 1 |
377349 | 377349 | 2020-07-28 | Lincoln | Kentucky | 21137 | 87 | 1 |
374134 | 374134 | 2020-07-27 | Lincoln | Kentucky | 21137 | 84 | 1 |
370922 | 370922 | 2020-07-26 | Lincoln | Kentucky | 21137 | 83 | 1 |
367712 | 367712 | 2020-07-25 | Lincoln | Kentucky | 21137 | 82 | 1 |
364505 | 364505 | 2020-07-24 | Lincoln | Kentucky | 21137 | 81 | 1 |
361298 | 361298 | 2020-07-23 | Lincoln | Kentucky | 21137 | 75 | 1 |
358093 | 358093 | 2020-07-22 | Lincoln | Kentucky | 21137 | 75 | 1 |
354890 | 354890 | 2020-07-21 | Lincoln | Kentucky | 21137 | 75 | 1 |
351688 | 351688 | 2020-07-20 | Lincoln | Kentucky | 21137 | 73 | 1 |
348488 | 348488 | 2020-07-19 | Lincoln | Kentucky | 21137 | 73 | 1 |
345287 | 345287 | 2020-07-18 | Lincoln | Kentucky | 21137 | 71 | 1 |
342087 | 342087 | 2020-07-17 | Lincoln | Kentucky | 21137 | 69 | 1 |
338891 | 338891 | 2020-07-16 | Lincoln | Kentucky | 21137 | 65 | 1 |
335695 | 335695 | 2020-07-15 | Lincoln | Kentucky | 21137 | 61 | 1 |
332502 | 332502 | 2020-07-14 | Lincoln | Kentucky | 21137 | 61 | 1 |
329315 | 329315 | 2020-07-13 | Lincoln | Kentucky | 21137 | 56 | 1 |
326129 | 326129 | 2020-07-12 | Lincoln | Kentucky | 21137 | 53 | 1 |
322946 | 322946 | 2020-07-11 | Lincoln | Kentucky | 21137 | 51 | 1 |
319767 | 319767 | 2020-07-10 | Lincoln | Kentucky | 21137 | 48 | 1 |
316592 | 316592 | 2020-07-09 | Lincoln | Kentucky | 21137 | 42 | 1 |
313418 | 313418 | 2020-07-08 | Lincoln | Kentucky | 21137 | 42 | 1 |
310248 | 310248 | 2020-07-07 | Lincoln | Kentucky | 21137 | 39 | 1 |
307080 | 307080 | 2020-07-06 | Lincoln | Kentucky | 21137 | 36 | 1 |
303913 | 303913 | 2020-07-05 | Lincoln | Kentucky | 21137 | 30 | 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);