ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Randolph" 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 |
---|---|---|---|---|---|---|---|
922416 | 922416 | 2021-01-12 | Randolph | North Carolina | 37151 | 9418 | 147 |
919171 | 919171 | 2021-01-11 | Randolph | North Carolina | 37151 | 9339 | 147 |
915926 | 915926 | 2021-01-10 | Randolph | North Carolina | 37151 | 9276 | 146 |
912681 | 912681 | 2021-01-09 | Randolph | North Carolina | 37151 | 9194 | 144 |
909436 | 909436 | 2021-01-08 | Randolph | North Carolina | 37151 | 9048 | 138 |
906191 | 906191 | 2021-01-07 | Randolph | North Carolina | 37151 | 8921 | 134 |
902945 | 902945 | 2021-01-06 | Randolph | North Carolina | 37151 | 8788 | 133 |
899700 | 899700 | 2021-01-05 | Randolph | North Carolina | 37151 | 8666 | 129 |
896455 | 896455 | 2021-01-04 | Randolph | North Carolina | 37151 | 8555 | 127 |
893209 | 893209 | 2021-01-03 | Randolph | North Carolina | 37151 | 8484 | 127 |
889963 | 889963 | 2021-01-02 | Randolph | North Carolina | 37151 | 8381 | 127 |
886716 | 886716 | 2021-01-01 | Randolph | North Carolina | 37151 | 8048 | 123 |
883471 | 883471 | 2020-12-31 | Randolph | North Carolina | 37151 | 8048 | 123 |
880226 | 880226 | 2020-12-30 | Randolph | North Carolina | 37151 | 7988 | 123 |
876981 | 876981 | 2020-12-29 | Randolph | North Carolina | 37151 | 7853 | 119 |
873736 | 873736 | 2020-12-28 | Randolph | North Carolina | 37151 | 7753 | 118 |
870491 | 870491 | 2020-12-27 | Randolph | North Carolina | 37151 | 7686 | 118 |
867246 | 867246 | 2020-12-26 | Randolph | North Carolina | 37151 | 7666 | 117 |
864001 | 864001 | 2020-12-25 | Randolph | North Carolina | 37151 | 7430 | 114 |
860756 | 860756 | 2020-12-24 | Randolph | North Carolina | 37151 | 7430 | 114 |
857511 | 857511 | 2020-12-23 | Randolph | North Carolina | 37151 | 7430 | 114 |
854266 | 854266 | 2020-12-22 | Randolph | North Carolina | 37151 | 7300 | 114 |
851021 | 851021 | 2020-12-21 | Randolph | North Carolina | 37151 | 7234 | 109 |
847776 | 847776 | 2020-12-20 | Randolph | North Carolina | 37151 | 7181 | 109 |
844531 | 844531 | 2020-12-19 | Randolph | North Carolina | 37151 | 7092 | 108 |
841285 | 841285 | 2020-12-18 | Randolph | North Carolina | 37151 | 6995 | 107 |
838040 | 838040 | 2020-12-17 | Randolph | North Carolina | 37151 | 6867 | 107 |
834794 | 834794 | 2020-12-16 | Randolph | North Carolina | 37151 | 6804 | 105 |
831548 | 831548 | 2020-12-15 | Randolph | North Carolina | 37151 | 6714 | 104 |
828301 | 828301 | 2020-12-14 | Randolph | North Carolina | 37151 | 6623 | 104 |
825055 | 825055 | 2020-12-13 | Randolph | North Carolina | 37151 | 6570 | 102 |
821808 | 821808 | 2020-12-12 | Randolph | North Carolina | 37151 | 6472 | 101 |
818562 | 818562 | 2020-12-11 | Randolph | North Carolina | 37151 | 6377 | 101 |
815316 | 815316 | 2020-12-10 | Randolph | North Carolina | 37151 | 6255 | 100 |
812071 | 812071 | 2020-12-09 | Randolph | North Carolina | 37151 | 6156 | 98 |
808826 | 808826 | 2020-12-08 | Randolph | North Carolina | 37151 | 6014 | 97 |
805581 | 805581 | 2020-12-07 | Randolph | North Carolina | 37151 | 5931 | 94 |
802336 | 802336 | 2020-12-06 | Randolph | North Carolina | 37151 | 5882 | 93 |
799091 | 799091 | 2020-12-05 | Randolph | North Carolina | 37151 | 5811 | 93 |
795846 | 795846 | 2020-12-04 | Randolph | North Carolina | 37151 | 5732 | 91 |
792601 | 792601 | 2020-12-03 | Randolph | North Carolina | 37151 | 5646 | 88 |
789356 | 789356 | 2020-12-02 | Randolph | North Carolina | 37151 | 5582 | 88 |
786111 | 786111 | 2020-12-01 | Randolph | North Carolina | 37151 | 5489 | 87 |
782867 | 782867 | 2020-11-30 | Randolph | North Carolina | 37151 | 5429 | 84 |
779621 | 779621 | 2020-11-29 | Randolph | North Carolina | 37151 | 5376 | 83 |
776376 | 776376 | 2020-11-28 | Randolph | North Carolina | 37151 | 5313 | 82 |
773131 | 773131 | 2020-11-27 | Randolph | North Carolina | 37151 | 5285 | 82 |
769886 | 769886 | 2020-11-26 | Randolph | North Carolina | 37151 | 5165 | 79 |
766640 | 766640 | 2020-11-25 | Randolph | North Carolina | 37151 | 5165 | 79 |
763395 | 763395 | 2020-11-24 | Randolph | North Carolina | 37151 | 5088 | 77 |
760150 | 760150 | 2020-11-23 | Randolph | North Carolina | 37151 | 5031 | 76 |
756904 | 756904 | 2020-11-22 | Randolph | North Carolina | 37151 | 5004 | 76 |
753657 | 753657 | 2020-11-21 | Randolph | North Carolina | 37151 | 4930 | 75 |
750411 | 750411 | 2020-11-20 | Randolph | North Carolina | 37151 | 4878 | 75 |
747165 | 747165 | 2020-11-19 | Randolph | North Carolina | 37151 | 4798 | 74 |
743919 | 743919 | 2020-11-18 | Randolph | North Carolina | 37151 | 4748 | 74 |
740672 | 740672 | 2020-11-17 | Randolph | North Carolina | 37151 | 4699 | 74 |
737427 | 737427 | 2020-11-16 | Randolph | North Carolina | 37151 | 4661 | 73 |
734183 | 734183 | 2020-11-15 | Randolph | North Carolina | 37151 | 4626 | 73 |
730937 | 730937 | 2020-11-14 | Randolph | North Carolina | 37151 | 4560 | 73 |
727693 | 727693 | 2020-11-13 | Randolph | North Carolina | 37151 | 4491 | 72 |
724449 | 724449 | 2020-11-12 | Randolph | North Carolina | 37151 | 4463 | 71 |
721206 | 721206 | 2020-11-11 | Randolph | North Carolina | 37151 | 4425 | 71 |
717963 | 717963 | 2020-11-10 | Randolph | North Carolina | 37151 | 4375 | 71 |
714720 | 714720 | 2020-11-09 | Randolph | North Carolina | 37151 | 4293 | 71 |
711476 | 711476 | 2020-11-08 | Randolph | North Carolina | 37151 | 4252 | 69 |
708232 | 708232 | 2020-11-07 | Randolph | North Carolina | 37151 | 4225 | 69 |
704989 | 704989 | 2020-11-06 | Randolph | North Carolina | 37151 | 4192 | 69 |
701746 | 701746 | 2020-11-05 | Randolph | North Carolina | 37151 | 4139 | 69 |
698502 | 698502 | 2020-11-04 | Randolph | North Carolina | 37151 | 4081 | 68 |
695259 | 695259 | 2020-11-03 | Randolph | North Carolina | 37151 | 4055 | 66 |
692017 | 692017 | 2020-11-02 | Randolph | North Carolina | 37151 | 3983 | 65 |
688773 | 688773 | 2020-11-01 | Randolph | North Carolina | 37151 | 3950 | 64 |
685528 | 685528 | 2020-10-31 | Randolph | North Carolina | 37151 | 3921 | 64 |
682285 | 682285 | 2020-10-30 | Randolph | North Carolina | 37151 | 3873 | 64 |
679042 | 679042 | 2020-10-29 | Randolph | North Carolina | 37151 | 3831 | 64 |
675799 | 675799 | 2020-10-28 | Randolph | North Carolina | 37151 | 3765 | 63 |
672556 | 672556 | 2020-10-27 | Randolph | North Carolina | 37151 | 3730 | 62 |
669314 | 669314 | 2020-10-26 | Randolph | North Carolina | 37151 | 3707 | 62 |
666070 | 666070 | 2020-10-25 | Randolph | North Carolina | 37151 | 3673 | 62 |
662825 | 662825 | 2020-10-24 | Randolph | North Carolina | 37151 | 3651 | 62 |
659581 | 659581 | 2020-10-23 | Randolph | North Carolina | 37151 | 3614 | 60 |
656337 | 656337 | 2020-10-22 | Randolph | North Carolina | 37151 | 3583 | 60 |
653092 | 653092 | 2020-10-21 | Randolph | North Carolina | 37151 | 3542 | 60 |
649847 | 649847 | 2020-10-20 | Randolph | North Carolina | 37151 | 3511 | 60 |
646603 | 646603 | 2020-10-19 | Randolph | North Carolina | 37151 | 3493 | 57 |
643357 | 643357 | 2020-10-18 | Randolph | North Carolina | 37151 | 3468 | 57 |
640109 | 640109 | 2020-10-17 | Randolph | North Carolina | 37151 | 3443 | 57 |
636863 | 636863 | 2020-10-16 | Randolph | North Carolina | 37151 | 3400 | 57 |
633617 | 633617 | 2020-10-15 | Randolph | North Carolina | 37151 | 3354 | 57 |
630372 | 630372 | 2020-10-14 | Randolph | North Carolina | 37151 | 3291 | 57 |
627128 | 627128 | 2020-10-13 | Randolph | North Carolina | 37151 | 3257 | 57 |
623886 | 623886 | 2020-10-12 | Randolph | North Carolina | 37151 | 3224 | 57 |
620643 | 620643 | 2020-10-11 | Randolph | North Carolina | 37151 | 3206 | 56 |
617401 | 617401 | 2020-10-10 | Randolph | North Carolina | 37151 | 3171 | 55 |
614159 | 614159 | 2020-10-09 | Randolph | North Carolina | 37151 | 3126 | 55 |
610918 | 610918 | 2020-10-08 | Randolph | North Carolina | 37151 | 3089 | 55 |
607676 | 607676 | 2020-10-07 | Randolph | North Carolina | 37151 | 3051 | 54 |
604433 | 604433 | 2020-10-06 | Randolph | North Carolina | 37151 | 3031 | 54 |
601191 | 601191 | 2020-10-05 | Randolph | North Carolina | 37151 | 3011 | 54 |
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);