ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Jackson" and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
342073 | 342073 | 2020-07-17 | Jackson | Kentucky | 21109 | 118 | 14 |
345273 | 345273 | 2020-07-18 | Jackson | Kentucky | 21109 | 118 | 14 |
348474 | 348474 | 2020-07-19 | Jackson | Kentucky | 21109 | 118 | 14 |
351674 | 351674 | 2020-07-20 | Jackson | Kentucky | 21109 | 118 | 14 |
354876 | 354876 | 2020-07-21 | Jackson | Kentucky | 21109 | 122 | 14 |
358079 | 358079 | 2020-07-22 | Jackson | Kentucky | 21109 | 123 | 14 |
361284 | 361284 | 2020-07-23 | Jackson | Kentucky | 21109 | 124 | 14 |
364491 | 364491 | 2020-07-24 | Jackson | Kentucky | 21109 | 125 | 14 |
367698 | 367698 | 2020-07-25 | Jackson | Kentucky | 21109 | 125 | 14 |
370908 | 370908 | 2020-07-26 | Jackson | Kentucky | 21109 | 127 | 14 |
374120 | 374120 | 2020-07-27 | Jackson | Kentucky | 21109 | 127 | 14 |
377335 | 377335 | 2020-07-28 | Jackson | Kentucky | 21109 | 131 | 14 |
380552 | 380552 | 2020-07-29 | Jackson | Kentucky | 21109 | 133 | 14 |
383769 | 383769 | 2020-07-30 | Jackson | Kentucky | 21109 | 137 | 14 |
386987 | 386987 | 2020-07-31 | Jackson | Kentucky | 21109 | 140 | 14 |
390204 | 390204 | 2020-08-01 | Jackson | Kentucky | 21109 | 140 | 14 |
393421 | 393421 | 2020-08-02 | Jackson | Kentucky | 21109 | 142 | 14 |
396637 | 396637 | 2020-08-03 | Jackson | Kentucky | 21109 | 143 | 14 |
399852 | 399852 | 2020-08-04 | Jackson | Kentucky | 21109 | 143 | 14 |
403069 | 403069 | 2020-08-05 | Jackson | Kentucky | 21109 | 143 | 14 |
406287 | 406287 | 2020-08-06 | Jackson | Kentucky | 21109 | 145 | 14 |
409507 | 409507 | 2020-08-07 | Jackson | Kentucky | 21109 | 149 | 14 |
412727 | 412727 | 2020-08-08 | Jackson | Kentucky | 21109 | 150 | 14 |
415947 | 415947 | 2020-08-09 | Jackson | Kentucky | 21109 | 150 | 14 |
419168 | 419168 | 2020-08-10 | Jackson | Kentucky | 21109 | 150 | 14 |
422390 | 422390 | 2020-08-11 | Jackson | Kentucky | 21109 | 150 | 14 |
425611 | 425611 | 2020-08-12 | Jackson | Kentucky | 21109 | 151 | 14 |
428835 | 428835 | 2020-08-13 | Jackson | Kentucky | 21109 | 154 | 14 |
432063 | 432063 | 2020-08-14 | Jackson | Kentucky | 21109 | 154 | 14 |
435288 | 435288 | 2020-08-15 | Jackson | Kentucky | 21109 | 155 | 14 |
438513 | 438513 | 2020-08-16 | Jackson | Kentucky | 21109 | 155 | 14 |
441740 | 441740 | 2020-08-17 | Jackson | Kentucky | 21109 | 158 | 14 |
444966 | 444966 | 2020-08-18 | Jackson | Kentucky | 21109 | 161 | 14 |
448193 | 448193 | 2020-08-19 | Jackson | Kentucky | 21109 | 161 | 14 |
451421 | 451421 | 2020-08-20 | Jackson | Kentucky | 21109 | 169 | 15 |
454649 | 454649 | 2020-08-21 | Jackson | Kentucky | 21109 | 167 | 15 |
457877 | 457877 | 2020-08-22 | Jackson | Kentucky | 21109 | 172 | 15 |
461104 | 461104 | 2020-08-23 | Jackson | Kentucky | 21109 | 172 | 15 |
464335 | 464335 | 2020-08-24 | Jackson | Kentucky | 21109 | 178 | 15 |
467564 | 467564 | 2020-08-25 | Jackson | Kentucky | 21109 | 187 | 15 |
470793 | 470793 | 2020-08-26 | Jackson | Kentucky | 21109 | 198 | 15 |
474025 | 474025 | 2020-08-27 | Jackson | Kentucky | 21109 | 202 | 15 |
477258 | 477258 | 2020-08-28 | Jackson | Kentucky | 21109 | 209 | 15 |
480491 | 480491 | 2020-08-29 | Jackson | Kentucky | 21109 | 216 | 15 |
483725 | 483725 | 2020-08-30 | Jackson | Kentucky | 21109 | 223 | 15 |
486960 | 486960 | 2020-08-31 | Jackson | Kentucky | 21109 | 226 | 15 |
490193 | 490193 | 2020-09-01 | Jackson | Kentucky | 21109 | 243 | 15 |
493427 | 493427 | 2020-09-02 | Jackson | Kentucky | 21109 | 255 | 15 |
496660 | 496660 | 2020-09-03 | Jackson | Kentucky | 21109 | 269 | 15 |
499894 | 499894 | 2020-09-04 | Jackson | Kentucky | 21109 | 279 | 15 |
503127 | 503127 | 2020-09-05 | Jackson | Kentucky | 21109 | 285 | 15 |
506361 | 506361 | 2020-09-06 | Jackson | Kentucky | 21109 | 287 | 15 |
509594 | 509594 | 2020-09-07 | Jackson | Kentucky | 21109 | 292 | 15 |
512826 | 512826 | 2020-09-08 | Jackson | Kentucky | 21109 | 293 | 15 |
516059 | 516059 | 2020-09-09 | Jackson | Kentucky | 21109 | 301 | 15 |
519294 | 519294 | 2020-09-10 | Jackson | Kentucky | 21109 | 308 | 15 |
522531 | 522531 | 2020-09-11 | Jackson | Kentucky | 21109 | 321 | 15 |
525767 | 525767 | 2020-09-12 | Jackson | Kentucky | 21109 | 323 | 15 |
529003 | 529003 | 2020-09-13 | Jackson | Kentucky | 21109 | 323 | 15 |
532240 | 532240 | 2020-09-14 | Jackson | Kentucky | 21109 | 326 | 15 |
535475 | 535475 | 2020-09-15 | Jackson | Kentucky | 21109 | 332 | 15 |
538712 | 538712 | 2020-09-16 | Jackson | Kentucky | 21109 | 333 | 16 |
541948 | 541948 | 2020-09-17 | Jackson | Kentucky | 21109 | 335 | 17 |
545184 | 545184 | 2020-09-18 | Jackson | Kentucky | 21109 | 342 | 17 |
548422 | 548422 | 2020-09-19 | Jackson | Kentucky | 21109 | 343 | 17 |
551661 | 551661 | 2020-09-20 | Jackson | Kentucky | 21109 | 345 | 17 |
554900 | 554900 | 2020-09-21 | Jackson | Kentucky | 21109 | 345 | 17 |
558137 | 558137 | 2020-09-22 | Jackson | Kentucky | 21109 | 350 | 17 |
561373 | 561373 | 2020-09-23 | Jackson | Kentucky | 21109 | 354 | 17 |
564613 | 564613 | 2020-09-24 | Jackson | Kentucky | 21109 | 361 | 17 |
567853 | 567853 | 2020-09-25 | Jackson | Kentucky | 21109 | 364 | 17 |
571095 | 571095 | 2020-09-26 | Jackson | Kentucky | 21109 | 367 | 17 |
574338 | 574338 | 2020-09-27 | Jackson | Kentucky | 21109 | 368 | 17 |
577580 | 577580 | 2020-09-28 | Jackson | Kentucky | 21109 | 368 | 17 |
580821 | 580821 | 2020-09-29 | Jackson | Kentucky | 21109 | 368 | 17 |
584061 | 584061 | 2020-09-30 | Jackson | Kentucky | 21109 | 374 | 17 |
587301 | 587301 | 2020-10-01 | Jackson | Kentucky | 21109 | 375 | 17 |
590542 | 590542 | 2020-10-02 | Jackson | Kentucky | 21109 | 382 | 17 |
593783 | 593783 | 2020-10-03 | Jackson | Kentucky | 21109 | 383 | 17 |
597025 | 597025 | 2020-10-04 | Jackson | Kentucky | 21109 | 383 | 17 |
600267 | 600267 | 2020-10-05 | Jackson | Kentucky | 21109 | 383 | 17 |
603510 | 603510 | 2020-10-06 | Jackson | Kentucky | 21109 | 389 | 17 |
606752 | 606752 | 2020-10-07 | Jackson | Kentucky | 21109 | 391 | 17 |
609994 | 609994 | 2020-10-08 | Jackson | Kentucky | 21109 | 393 | 17 |
613236 | 613236 | 2020-10-09 | Jackson | Kentucky | 21109 | 396 | 17 |
616477 | 616477 | 2020-10-10 | Jackson | Kentucky | 21109 | 401 | 17 |
619719 | 619719 | 2020-10-11 | Jackson | Kentucky | 21109 | 401 | 17 |
622963 | 622963 | 2020-10-12 | Jackson | Kentucky | 21109 | 401 | 17 |
626205 | 626205 | 2020-10-13 | Jackson | Kentucky | 21109 | 403 | 17 |
629449 | 629449 | 2020-10-14 | Jackson | Kentucky | 21109 | 406 | 17 |
632693 | 632693 | 2020-10-15 | Jackson | Kentucky | 21109 | 410 | 17 |
635939 | 635939 | 2020-10-16 | Jackson | Kentucky | 21109 | 416 | 17 |
639185 | 639185 | 2020-10-17 | Jackson | Kentucky | 21109 | 418 | 17 |
642432 | 642432 | 2020-10-18 | Jackson | Kentucky | 21109 | 418 | 17 |
645679 | 645679 | 2020-10-19 | Jackson | Kentucky | 21109 | 419 | 17 |
648923 | 648923 | 2020-10-20 | Jackson | Kentucky | 21109 | 422 | 17 |
652168 | 652168 | 2020-10-21 | Jackson | Kentucky | 21109 | 424 | 17 |
655413 | 655413 | 2020-10-22 | Jackson | Kentucky | 21109 | 431 | 17 |
658658 | 658658 | 2020-10-23 | Jackson | Kentucky | 21109 | 435 | 17 |
661902 | 661902 | 2020-10-24 | Jackson | Kentucky | 21109 | 444 | 17 |
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);