ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where county = "Union", deaths = 6 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
782001 | 782001 | 2020-11-30 | Union | Kentucky | 21225 | 723 | 6 |
778755 | 778755 | 2020-11-29 | Union | Kentucky | 21225 | 719 | 6 |
775510 | 775510 | 2020-11-28 | Union | Kentucky | 21225 | 711 | 6 |
772265 | 772265 | 2020-11-27 | Union | Kentucky | 21225 | 708 | 6 |
769020 | 769020 | 2020-11-26 | Union | Kentucky | 21225 | 699 | 6 |
765774 | 765774 | 2020-11-25 | Union | Kentucky | 21225 | 699 | 6 |
762529 | 762529 | 2020-11-24 | Union | Kentucky | 21225 | 695 | 6 |
759284 | 759284 | 2020-11-23 | Union | Kentucky | 21225 | 691 | 6 |
756037 | 756037 | 2020-11-22 | Union | Kentucky | 21225 | 686 | 6 |
752791 | 752791 | 2020-11-21 | Union | Kentucky | 21225 | 681 | 6 |
749545 | 749545 | 2020-11-20 | Union | Kentucky | 21225 | 668 | 6 |
746299 | 746299 | 2020-11-19 | Union | Kentucky | 21225 | 655 | 6 |
743052 | 743052 | 2020-11-18 | Union | Kentucky | 21225 | 647 | 6 |
739805 | 739805 | 2020-11-17 | Union | Kentucky | 21225 | 625 | 6 |
736561 | 736561 | 2020-11-16 | Union | Kentucky | 21225 | 614 | 6 |
733315 | 733315 | 2020-11-15 | Union | Kentucky | 21225 | 613 | 6 |
730070 | 730070 | 2020-11-14 | Union | Kentucky | 21225 | 610 | 6 |
726827 | 726827 | 2020-11-13 | Union | Kentucky | 21225 | 604 | 6 |
723584 | 723584 | 2020-11-12 | Union | Kentucky | 21225 | 589 | 6 |
720341 | 720341 | 2020-11-11 | Union | Kentucky | 21225 | 582 | 6 |
717098 | 717098 | 2020-11-10 | Union | Kentucky | 21225 | 573 | 6 |
713854 | 713854 | 2020-11-09 | Union | Kentucky | 21225 | 557 | 6 |
710610 | 710610 | 2020-11-08 | Union | Kentucky | 21225 | 552 | 6 |
707366 | 707366 | 2020-11-07 | Union | Kentucky | 21225 | 549 | 6 |
704123 | 704123 | 2020-11-06 | Union | Kentucky | 21225 | 546 | 6 |
700881 | 700881 | 2020-11-05 | Union | Kentucky | 21225 | 542 | 6 |
697637 | 697637 | 2020-11-04 | Union | Kentucky | 21225 | 535 | 6 |
694394 | 694394 | 2020-11-03 | Union | Kentucky | 21225 | 532 | 6 |
691152 | 691152 | 2020-11-02 | Union | Kentucky | 21225 | 530 | 6 |
687907 | 687907 | 2020-11-01 | Union | Kentucky | 21225 | 529 | 6 |
684663 | 684663 | 2020-10-31 | Union | Kentucky | 21225 | 526 | 6 |
681420 | 681420 | 2020-10-30 | Union | Kentucky | 21225 | 524 | 6 |
678176 | 678176 | 2020-10-29 | Union | Kentucky | 21225 | 519 | 6 |
674934 | 674934 | 2020-10-28 | Union | Kentucky | 21225 | 515 | 6 |
671691 | 671691 | 2020-10-27 | Union | Kentucky | 21225 | 508 | 6 |
668449 | 668449 | 2020-10-26 | Union | Kentucky | 21225 | 507 | 6 |
665205 | 665205 | 2020-10-25 | Union | Kentucky | 21225 | 506 | 6 |
661960 | 661960 | 2020-10-24 | Union | Kentucky | 21225 | 503 | 6 |
658716 | 658716 | 2020-10-23 | Union | Kentucky | 21225 | 496 | 6 |
655471 | 655471 | 2020-10-22 | Union | Kentucky | 21225 | 493 | 6 |
652226 | 652226 | 2020-10-21 | Union | Kentucky | 21225 | 485 | 6 |
648981 | 648981 | 2020-10-20 | Union | Kentucky | 21225 | 484 | 6 |
645737 | 645737 | 2020-10-19 | Union | Kentucky | 21225 | 481 | 6 |
642490 | 642490 | 2020-10-18 | Union | Kentucky | 21225 | 471 | 6 |
639243 | 639243 | 2020-10-17 | Union | Kentucky | 21225 | 469 | 6 |
635997 | 635997 | 2020-10-16 | Union | Kentucky | 21225 | 462 | 6 |
632751 | 632751 | 2020-10-15 | Union | Kentucky | 21225 | 448 | 6 |
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);