ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37071 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 |
---|---|---|---|---|---|---|---|
922376 | 922376 | 2021-01-12 | Gaston | North Carolina | 37071 | 18415 | 266 |
919131 | 919131 | 2021-01-11 | Gaston | North Carolina | 37071 | 18228 | 265 |
915886 | 915886 | 2021-01-10 | Gaston | North Carolina | 37071 | 18008 | 262 |
912641 | 912641 | 2021-01-09 | Gaston | North Carolina | 37071 | 17705 | 260 |
909396 | 909396 | 2021-01-08 | Gaston | North Carolina | 37071 | 17439 | 260 |
906151 | 906151 | 2021-01-07 | Gaston | North Carolina | 37071 | 17078 | 249 |
902905 | 902905 | 2021-01-06 | Gaston | North Carolina | 37071 | 16868 | 249 |
899660 | 899660 | 2021-01-05 | Gaston | North Carolina | 37071 | 16651 | 249 |
896415 | 896415 | 2021-01-04 | Gaston | North Carolina | 37071 | 16491 | 245 |
893169 | 893169 | 2021-01-03 | Gaston | North Carolina | 37071 | 16321 | 245 |
889923 | 889923 | 2021-01-02 | Gaston | North Carolina | 37071 | 16093 | 243 |
886676 | 886676 | 2021-01-01 | Gaston | North Carolina | 37071 | 15513 | 239 |
883431 | 883431 | 2020-12-31 | Gaston | North Carolina | 37071 | 15513 | 239 |
880186 | 880186 | 2020-12-30 | Gaston | North Carolina | 37071 | 15308 | 239 |
876941 | 876941 | 2020-12-29 | Gaston | North Carolina | 37071 | 15018 | 234 |
873696 | 873696 | 2020-12-28 | Gaston | North Carolina | 37071 | 14907 | 233 |
870451 | 870451 | 2020-12-27 | Gaston | North Carolina | 37071 | 14789 | 232 |
867206 | 867206 | 2020-12-26 | Gaston | North Carolina | 37071 | 14708 | 230 |
863961 | 863961 | 2020-12-25 | Gaston | North Carolina | 37071 | 14056 | 225 |
860716 | 860716 | 2020-12-24 | Gaston | North Carolina | 37071 | 14056 | 225 |
857471 | 857471 | 2020-12-23 | Gaston | North Carolina | 37071 | 14056 | 225 |
854226 | 854226 | 2020-12-22 | Gaston | North Carolina | 37071 | 13914 | 225 |
850981 | 850981 | 2020-12-21 | Gaston | North Carolina | 37071 | 13756 | 218 |
847736 | 847736 | 2020-12-20 | Gaston | North Carolina | 37071 | 13597 | 217 |
844491 | 844491 | 2020-12-19 | Gaston | North Carolina | 37071 | 13400 | 217 |
841245 | 841245 | 2020-12-18 | Gaston | North Carolina | 37071 | 13237 | 204 |
838000 | 838000 | 2020-12-17 | Gaston | North Carolina | 37071 | 12917 | 203 |
834754 | 834754 | 2020-12-16 | Gaston | North Carolina | 37071 | 12812 | 203 |
831508 | 831508 | 2020-12-15 | Gaston | North Carolina | 37071 | 12668 | 196 |
828261 | 828261 | 2020-12-14 | Gaston | North Carolina | 37071 | 12534 | 194 |
825015 | 825015 | 2020-12-13 | Gaston | North Carolina | 37071 | 12381 | 194 |
821768 | 821768 | 2020-12-12 | Gaston | North Carolina | 37071 | 12185 | 194 |
818522 | 818522 | 2020-12-11 | Gaston | North Carolina | 37071 | 12030 | 193 |
815276 | 815276 | 2020-12-10 | Gaston | North Carolina | 37071 | 11771 | 193 |
812031 | 812031 | 2020-12-09 | Gaston | North Carolina | 37071 | 11645 | 193 |
808786 | 808786 | 2020-12-08 | Gaston | North Carolina | 37071 | 11453 | 193 |
805541 | 805541 | 2020-12-07 | Gaston | North Carolina | 37071 | 11286 | 193 |
802296 | 802296 | 2020-12-06 | Gaston | North Carolina | 37071 | 11151 | 188 |
799051 | 799051 | 2020-12-05 | Gaston | North Carolina | 37071 | 10983 | 188 |
795806 | 795806 | 2020-12-04 | Gaston | North Carolina | 37071 | 10809 | 188 |
792561 | 792561 | 2020-12-03 | Gaston | North Carolina | 37071 | 10669 | 188 |
789316 | 789316 | 2020-12-02 | Gaston | North Carolina | 37071 | 10501 | 187 |
786071 | 786071 | 2020-12-01 | Gaston | North Carolina | 37071 | 10373 | 186 |
782827 | 782827 | 2020-11-30 | Gaston | North Carolina | 37071 | 10276 | 185 |
779581 | 779581 | 2020-11-29 | Gaston | North Carolina | 37071 | 10186 | 183 |
776336 | 776336 | 2020-11-28 | Gaston | North Carolina | 37071 | 10109 | 181 |
773091 | 773091 | 2020-11-27 | Gaston | North Carolina | 37071 | 9997 | 181 |
769846 | 769846 | 2020-11-26 | Gaston | North Carolina | 37071 | 9794 | 179 |
766600 | 766600 | 2020-11-25 | Gaston | North Carolina | 37071 | 9794 | 179 |
763355 | 763355 | 2020-11-24 | Gaston | North Carolina | 37071 | 9701 | 178 |
760110 | 760110 | 2020-11-23 | Gaston | North Carolina | 37071 | 9637 | 177 |
756864 | 756864 | 2020-11-22 | Gaston | North Carolina | 37071 | 9555 | 176 |
753617 | 753617 | 2020-11-21 | Gaston | North Carolina | 37071 | 9418 | 174 |
750371 | 750371 | 2020-11-20 | Gaston | North Carolina | 37071 | 9338 | 174 |
747125 | 747125 | 2020-11-19 | Gaston | North Carolina | 37071 | 9232 | 170 |
743879 | 743879 | 2020-11-18 | Gaston | North Carolina | 37071 | 9145 | 170 |
740632 | 740632 | 2020-11-17 | Gaston | North Carolina | 37071 | 9075 | 168 |
737387 | 737387 | 2020-11-16 | Gaston | North Carolina | 37071 | 8959 | 164 |
734143 | 734143 | 2020-11-15 | Gaston | North Carolina | 37071 | 8874 | 163 |
730897 | 730897 | 2020-11-14 | Gaston | North Carolina | 37071 | 8760 | 157 |
727653 | 727653 | 2020-11-13 | Gaston | North Carolina | 37071 | 8650 | 157 |
724409 | 724409 | 2020-11-12 | Gaston | North Carolina | 37071 | 8588 | 157 |
721166 | 721166 | 2020-11-11 | Gaston | North Carolina | 37071 | 8495 | 156 |
717923 | 717923 | 2020-11-10 | Gaston | North Carolina | 37071 | 8426 | 152 |
714680 | 714680 | 2020-11-09 | Gaston | North Carolina | 37071 | 8356 | 145 |
711436 | 711436 | 2020-11-08 | Gaston | North Carolina | 37071 | 8321 | 145 |
708192 | 708192 | 2020-11-07 | Gaston | North Carolina | 37071 | 8269 | 145 |
704949 | 704949 | 2020-11-06 | Gaston | North Carolina | 37071 | 8183 | 145 |
701706 | 701706 | 2020-11-05 | Gaston | North Carolina | 37071 | 8102 | 144 |
698462 | 698462 | 2020-11-04 | Gaston | North Carolina | 37071 | 8034 | 143 |
695219 | 695219 | 2020-11-03 | Gaston | North Carolina | 37071 | 7970 | 141 |
691977 | 691977 | 2020-11-02 | Gaston | North Carolina | 37071 | 7910 | 135 |
688733 | 688733 | 2020-11-01 | Gaston | North Carolina | 37071 | 7863 | 135 |
685488 | 685488 | 2020-10-31 | Gaston | North Carolina | 37071 | 7798 | 135 |
682245 | 682245 | 2020-10-30 | Gaston | North Carolina | 37071 | 7636 | 133 |
679002 | 679002 | 2020-10-29 | Gaston | North Carolina | 37071 | 7479 | 121 |
675759 | 675759 | 2020-10-28 | Gaston | North Carolina | 37071 | 7399 | 116 |
672516 | 672516 | 2020-10-27 | Gaston | North Carolina | 37071 | 7302 | 115 |
669274 | 669274 | 2020-10-26 | Gaston | North Carolina | 37071 | 7243 | 112 |
666030 | 666030 | 2020-10-25 | Gaston | North Carolina | 37071 | 7204 | 112 |
662785 | 662785 | 2020-10-24 | Gaston | North Carolina | 37071 | 7143 | 109 |
659541 | 659541 | 2020-10-23 | Gaston | North Carolina | 37071 | 7009 | 109 |
656297 | 656297 | 2020-10-22 | Gaston | North Carolina | 37071 | 6956 | 108 |
653052 | 653052 | 2020-10-21 | Gaston | North Carolina | 37071 | 6881 | 107 |
649807 | 649807 | 2020-10-20 | Gaston | North Carolina | 37071 | 6786 | 104 |
646563 | 646563 | 2020-10-19 | Gaston | North Carolina | 37071 | 6721 | 104 |
643317 | 643317 | 2020-10-18 | Gaston | North Carolina | 37071 | 6684 | 104 |
640069 | 640069 | 2020-10-17 | Gaston | North Carolina | 37071 | 6558 | 104 |
636823 | 636823 | 2020-10-16 | Gaston | North Carolina | 37071 | 6472 | 102 |
633577 | 633577 | 2020-10-15 | Gaston | North Carolina | 37071 | 6334 | 100 |
630332 | 630332 | 2020-10-14 | Gaston | North Carolina | 37071 | 6255 | 100 |
627088 | 627088 | 2020-10-13 | Gaston | North Carolina | 37071 | 6188 | 99 |
623846 | 623846 | 2020-10-12 | Gaston | North Carolina | 37071 | 6096 | 99 |
620603 | 620603 | 2020-10-11 | Gaston | North Carolina | 37071 | 6044 | 99 |
617361 | 617361 | 2020-10-10 | Gaston | North Carolina | 37071 | 6007 | 97 |
614119 | 614119 | 2020-10-09 | Gaston | North Carolina | 37071 | 5927 | 97 |
610878 | 610878 | 2020-10-08 | Gaston | North Carolina | 37071 | 5852 | 94 |
607636 | 607636 | 2020-10-07 | Gaston | North Carolina | 37071 | 5760 | 92 |
604393 | 604393 | 2020-10-06 | Gaston | North Carolina | 37071 | 5660 | 89 |
601151 | 601151 | 2020-10-05 | Gaston | North Carolina | 37071 | 5588 | 89 |
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);