ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Union" and fips = 21225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918305 | 918305 | 2021-01-11 | Union | Kentucky | 21225 | 1035 | 9 |
915060 | 915060 | 2021-01-10 | Union | Kentucky | 21225 | 1029 | 9 |
911815 | 911815 | 2021-01-09 | Union | Kentucky | 21225 | 1020 | 9 |
908570 | 908570 | 2021-01-08 | Union | Kentucky | 21225 | 1005 | 9 |
905324 | 905324 | 2021-01-07 | Union | Kentucky | 21225 | 996 | 9 |
902079 | 902079 | 2021-01-06 | Union | Kentucky | 21225 | 992 | 9 |
898834 | 898834 | 2021-01-05 | Union | Kentucky | 21225 | 986 | 9 |
895589 | 895589 | 2021-01-04 | Union | Kentucky | 21225 | 985 | 9 |
892342 | 892342 | 2021-01-03 | Union | Kentucky | 21225 | 973 | 9 |
889096 | 889096 | 2021-01-02 | Union | Kentucky | 21225 | 966 | 9 |
885850 | 885850 | 2021-01-01 | Union | Kentucky | 21225 | 954 | 9 |
882605 | 882605 | 2020-12-31 | Union | Kentucky | 21225 | 954 | 9 |
879360 | 879360 | 2020-12-30 | Union | Kentucky | 21225 | 954 | 9 |
876115 | 876115 | 2020-12-29 | Union | Kentucky | 21225 | 943 | 9 |
872870 | 872870 | 2020-12-28 | Union | Kentucky | 21225 | 941 | 9 |
869625 | 869625 | 2020-12-27 | Union | Kentucky | 21225 | 935 | 9 |
866380 | 866380 | 2020-12-26 | Union | Kentucky | 21225 | 925 | 9 |
863135 | 863135 | 2020-12-25 | Union | Kentucky | 21225 | 910 | 9 |
859890 | 859890 | 2020-12-24 | Union | Kentucky | 21225 | 910 | 9 |
856645 | 856645 | 2020-12-23 | Union | Kentucky | 21225 | 910 | 9 |
853400 | 853400 | 2020-12-22 | Union | Kentucky | 21225 | 899 | 9 |
850155 | 850155 | 2020-12-21 | Union | Kentucky | 21225 | 890 | 9 |
846910 | 846910 | 2020-12-20 | Union | Kentucky | 21225 | 883 | 9 |
843664 | 843664 | 2020-12-19 | Union | Kentucky | 21225 | 879 | 9 |
840419 | 840419 | 2020-12-18 | Union | Kentucky | 21225 | 862 | 9 |
837174 | 837174 | 2020-12-17 | Union | Kentucky | 21225 | 850 | 9 |
833928 | 833928 | 2020-12-16 | Union | Kentucky | 21225 | 847 | 9 |
830681 | 830681 | 2020-12-15 | Union | Kentucky | 21225 | 840 | 10 |
827435 | 827435 | 2020-12-14 | Union | Kentucky | 21225 | 825 | 10 |
824188 | 824188 | 2020-12-13 | Union | Kentucky | 21225 | 822 | 10 |
820942 | 820942 | 2020-12-12 | Union | Kentucky | 21225 | 816 | 10 |
817696 | 817696 | 2020-12-11 | Union | Kentucky | 21225 | 811 | 10 |
814450 | 814450 | 2020-12-10 | Union | Kentucky | 21225 | 802 | 9 |
811205 | 811205 | 2020-12-09 | Union | Kentucky | 21225 | 789 | 9 |
807960 | 807960 | 2020-12-08 | Union | Kentucky | 21225 | 785 | 9 |
804715 | 804715 | 2020-12-07 | Union | Kentucky | 21225 | 784 | 9 |
801470 | 801470 | 2020-12-06 | Union | Kentucky | 21225 | 774 | 9 |
798225 | 798225 | 2020-12-05 | Union | Kentucky | 21225 | 764 | 9 |
794980 | 794980 | 2020-12-04 | Union | Kentucky | 21225 | 756 | 9 |
791735 | 791735 | 2020-12-03 | Union | Kentucky | 21225 | 750 | 9 |
788490 | 788490 | 2020-12-02 | Union | Kentucky | 21225 | 743 | 7 |
785246 | 785246 | 2020-12-01 | Union | Kentucky | 21225 | 733 | 7 |
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 |
629507 | 629507 | 2020-10-14 | Union | Kentucky | 21225 | 441 | 5 |
626263 | 626263 | 2020-10-13 | Union | Kentucky | 21225 | 433 | 5 |
623021 | 623021 | 2020-10-12 | Union | Kentucky | 21225 | 429 | 5 |
619777 | 619777 | 2020-10-11 | Union | Kentucky | 21225 | 424 | 5 |
616535 | 616535 | 2020-10-10 | Union | Kentucky | 21225 | 417 | 5 |
613294 | 613294 | 2020-10-09 | Union | Kentucky | 21225 | 406 | 3 |
610052 | 610052 | 2020-10-08 | Union | Kentucky | 21225 | 399 | 3 |
606810 | 606810 | 2020-10-07 | Union | Kentucky | 21225 | 392 | 3 |
603568 | 603568 | 2020-10-06 | Union | Kentucky | 21225 | 388 | 3 |
600325 | 600325 | 2020-10-05 | Union | Kentucky | 21225 | 383 | 3 |
597083 | 597083 | 2020-10-04 | Union | Kentucky | 21225 | 379 | 3 |
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);