ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 37039 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922360 | 922360 | 2021-01-12 | Cherokee | North Carolina | 37039 | 1579 | 16 |
919115 | 919115 | 2021-01-11 | Cherokee | North Carolina | 37039 | 1553 | 16 |
915870 | 915870 | 2021-01-10 | Cherokee | North Carolina | 37039 | 1522 | 16 |
912625 | 912625 | 2021-01-09 | Cherokee | North Carolina | 37039 | 1501 | 16 |
909380 | 909380 | 2021-01-08 | Cherokee | North Carolina | 37039 | 1453 | 16 |
906135 | 906135 | 2021-01-07 | Cherokee | North Carolina | 37039 | 1406 | 16 |
902889 | 902889 | 2021-01-06 | Cherokee | North Carolina | 37039 | 1382 | 15 |
899644 | 899644 | 2021-01-05 | Cherokee | North Carolina | 37039 | 1372 | 15 |
896399 | 896399 | 2021-01-04 | Cherokee | North Carolina | 37039 | 1359 | 15 |
893153 | 893153 | 2021-01-03 | Cherokee | North Carolina | 37039 | 1345 | 15 |
889907 | 889907 | 2021-01-02 | Cherokee | North Carolina | 37039 | 1318 | 15 |
886660 | 886660 | 2021-01-01 | Cherokee | North Carolina | 37039 | 1257 | 15 |
883415 | 883415 | 2020-12-31 | Cherokee | North Carolina | 37039 | 1257 | 15 |
880170 | 880170 | 2020-12-30 | Cherokee | North Carolina | 37039 | 1251 | 15 |
876925 | 876925 | 2020-12-29 | Cherokee | North Carolina | 37039 | 1235 | 15 |
873680 | 873680 | 2020-12-28 | Cherokee | North Carolina | 37039 | 1227 | 15 |
870435 | 870435 | 2020-12-27 | Cherokee | North Carolina | 37039 | 1223 | 15 |
867190 | 867190 | 2020-12-26 | Cherokee | North Carolina | 37039 | 1218 | 15 |
863945 | 863945 | 2020-12-25 | Cherokee | North Carolina | 37039 | 1158 | 15 |
860700 | 860700 | 2020-12-24 | Cherokee | North Carolina | 37039 | 1158 | 15 |
857455 | 857455 | 2020-12-23 | Cherokee | North Carolina | 37039 | 1158 | 15 |
854210 | 854210 | 2020-12-22 | Cherokee | North Carolina | 37039 | 1147 | 15 |
850965 | 850965 | 2020-12-21 | Cherokee | North Carolina | 37039 | 1136 | 15 |
847720 | 847720 | 2020-12-20 | Cherokee | North Carolina | 37039 | 1135 | 15 |
844475 | 844475 | 2020-12-19 | Cherokee | North Carolina | 37039 | 1125 | 15 |
841229 | 841229 | 2020-12-18 | Cherokee | North Carolina | 37039 | 1123 | 15 |
837984 | 837984 | 2020-12-17 | Cherokee | North Carolina | 37039 | 1091 | 15 |
834738 | 834738 | 2020-12-16 | Cherokee | North Carolina | 37039 | 1089 | 15 |
831492 | 831492 | 2020-12-15 | Cherokee | North Carolina | 37039 | 1080 | 15 |
828245 | 828245 | 2020-12-14 | Cherokee | North Carolina | 37039 | 1072 | 15 |
824999 | 824999 | 2020-12-13 | Cherokee | North Carolina | 37039 | 1066 | 15 |
821752 | 821752 | 2020-12-12 | Cherokee | North Carolina | 37039 | 1051 | 15 |
818506 | 818506 | 2020-12-11 | Cherokee | North Carolina | 37039 | 1036 | 15 |
815260 | 815260 | 2020-12-10 | Cherokee | North Carolina | 37039 | 1030 | 15 |
812015 | 812015 | 2020-12-09 | Cherokee | North Carolina | 37039 | 1026 | 15 |
808770 | 808770 | 2020-12-08 | Cherokee | North Carolina | 37039 | 1014 | 15 |
805525 | 805525 | 2020-12-07 | Cherokee | North Carolina | 37039 | 1006 | 15 |
802280 | 802280 | 2020-12-06 | Cherokee | North Carolina | 37039 | 1002 | 15 |
799035 | 799035 | 2020-12-05 | Cherokee | North Carolina | 37039 | 987 | 15 |
795790 | 795790 | 2020-12-04 | Cherokee | North Carolina | 37039 | 975 | 15 |
792545 | 792545 | 2020-12-03 | Cherokee | North Carolina | 37039 | 960 | 15 |
789300 | 789300 | 2020-12-02 | Cherokee | North Carolina | 37039 | 956 | 15 |
786055 | 786055 | 2020-12-01 | Cherokee | North Carolina | 37039 | 946 | 15 |
782811 | 782811 | 2020-11-30 | Cherokee | North Carolina | 37039 | 942 | 15 |
779565 | 779565 | 2020-11-29 | Cherokee | North Carolina | 37039 | 936 | 15 |
776320 | 776320 | 2020-11-28 | Cherokee | North Carolina | 37039 | 928 | 15 |
773075 | 773075 | 2020-11-27 | Cherokee | North Carolina | 37039 | 919 | 15 |
769830 | 769830 | 2020-11-26 | Cherokee | North Carolina | 37039 | 909 | 15 |
766584 | 766584 | 2020-11-25 | Cherokee | North Carolina | 37039 | 909 | 15 |
763339 | 763339 | 2020-11-24 | Cherokee | North Carolina | 37039 | 907 | 15 |
760094 | 760094 | 2020-11-23 | Cherokee | North Carolina | 37039 | 903 | 15 |
756848 | 756848 | 2020-11-22 | Cherokee | North Carolina | 37039 | 897 | 15 |
753601 | 753601 | 2020-11-21 | Cherokee | North Carolina | 37039 | 895 | 15 |
750355 | 750355 | 2020-11-20 | Cherokee | North Carolina | 37039 | 887 | 15 |
747109 | 747109 | 2020-11-19 | Cherokee | North Carolina | 37039 | 877 | 15 |
743863 | 743863 | 2020-11-18 | Cherokee | North Carolina | 37039 | 870 | 15 |
740616 | 740616 | 2020-11-17 | Cherokee | North Carolina | 37039 | 865 | 15 |
737371 | 737371 | 2020-11-16 | Cherokee | North Carolina | 37039 | 858 | 15 |
734127 | 734127 | 2020-11-15 | Cherokee | North Carolina | 37039 | 854 | 15 |
730881 | 730881 | 2020-11-14 | Cherokee | North Carolina | 37039 | 848 | 15 |
727637 | 727637 | 2020-11-13 | Cherokee | North Carolina | 37039 | 838 | 15 |
724393 | 724393 | 2020-11-12 | Cherokee | North Carolina | 37039 | 835 | 15 |
721150 | 721150 | 2020-11-11 | Cherokee | North Carolina | 37039 | 833 | 15 |
717907 | 717907 | 2020-11-10 | Cherokee | North Carolina | 37039 | 829 | 15 |
714664 | 714664 | 2020-11-09 | Cherokee | North Carolina | 37039 | 821 | 15 |
711420 | 711420 | 2020-11-08 | Cherokee | North Carolina | 37039 | 821 | 15 |
708176 | 708176 | 2020-11-07 | Cherokee | North Carolina | 37039 | 820 | 15 |
704933 | 704933 | 2020-11-06 | Cherokee | North Carolina | 37039 | 816 | 15 |
701690 | 701690 | 2020-11-05 | Cherokee | North Carolina | 37039 | 806 | 15 |
698446 | 698446 | 2020-11-04 | Cherokee | North Carolina | 37039 | 798 | 15 |
695203 | 695203 | 2020-11-03 | Cherokee | North Carolina | 37039 | 794 | 15 |
691961 | 691961 | 2020-11-02 | Cherokee | North Carolina | 37039 | 785 | 15 |
688717 | 688717 | 2020-11-01 | Cherokee | North Carolina | 37039 | 782 | 15 |
685472 | 685472 | 2020-10-31 | Cherokee | North Carolina | 37039 | 781 | 15 |
682229 | 682229 | 2020-10-30 | Cherokee | North Carolina | 37039 | 778 | 15 |
678986 | 678986 | 2020-10-29 | Cherokee | North Carolina | 37039 | 776 | 15 |
675743 | 675743 | 2020-10-28 | Cherokee | North Carolina | 37039 | 773 | 14 |
672500 | 672500 | 2020-10-27 | Cherokee | North Carolina | 37039 | 773 | 14 |
669258 | 669258 | 2020-10-26 | Cherokee | North Carolina | 37039 | 769 | 14 |
666014 | 666014 | 2020-10-25 | Cherokee | North Carolina | 37039 | 767 | 14 |
662769 | 662769 | 2020-10-24 | Cherokee | North Carolina | 37039 | 765 | 14 |
659525 | 659525 | 2020-10-23 | Cherokee | North Carolina | 37039 | 755 | 14 |
656281 | 656281 | 2020-10-22 | Cherokee | North Carolina | 37039 | 753 | 14 |
653036 | 653036 | 2020-10-21 | Cherokee | North Carolina | 37039 | 738 | 12 |
649791 | 649791 | 2020-10-20 | Cherokee | North Carolina | 37039 | 738 | 12 |
646547 | 646547 | 2020-10-19 | Cherokee | North Carolina | 37039 | 733 | 12 |
643301 | 643301 | 2020-10-18 | Cherokee | North Carolina | 37039 | 731 | 12 |
640053 | 640053 | 2020-10-17 | Cherokee | North Carolina | 37039 | 729 | 12 |
636807 | 636807 | 2020-10-16 | Cherokee | North Carolina | 37039 | 723 | 12 |
633561 | 633561 | 2020-10-15 | Cherokee | North Carolina | 37039 | 718 | 12 |
630316 | 630316 | 2020-10-14 | Cherokee | North Carolina | 37039 | 711 | 12 |
627072 | 627072 | 2020-10-13 | Cherokee | North Carolina | 37039 | 711 | 12 |
623830 | 623830 | 2020-10-12 | Cherokee | North Carolina | 37039 | 710 | 12 |
620587 | 620587 | 2020-10-11 | Cherokee | North Carolina | 37039 | 706 | 12 |
617345 | 617345 | 2020-10-10 | Cherokee | North Carolina | 37039 | 702 | 12 |
614103 | 614103 | 2020-10-09 | Cherokee | North Carolina | 37039 | 694 | 12 |
610862 | 610862 | 2020-10-08 | Cherokee | North Carolina | 37039 | 683 | 12 |
607620 | 607620 | 2020-10-07 | Cherokee | North Carolina | 37039 | 679 | 12 |
604377 | 604377 | 2020-10-06 | Cherokee | North Carolina | 37039 | 679 | 12 |
601135 | 601135 | 2020-10-05 | Cherokee | North Carolina | 37039 | 677 | 12 |
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);