ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Forsyth" 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 |
---|---|---|---|---|---|---|---|
958074 | 958074 | 2021-01-23 | Forsyth | North Carolina | 37067 | 26315 | 266 |
954828 | 954828 | 2021-01-22 | Forsyth | North Carolina | 37067 | 26007 | 265 |
951583 | 951583 | 2021-01-21 | Forsyth | North Carolina | 37067 | 25696 | 259 |
948338 | 948338 | 2021-01-20 | Forsyth | North Carolina | 37067 | 25473 | 255 |
945091 | 945091 | 2021-01-19 | Forsyth | North Carolina | 37067 | 25217 | 256 |
941845 | 941845 | 2021-01-18 | Forsyth | North Carolina | 37067 | 24973 | 248 |
938600 | 938600 | 2021-01-17 | Forsyth | North Carolina | 37067 | 24973 | 248 |
935355 | 935355 | 2021-01-16 | Forsyth | North Carolina | 37067 | 24699 | 248 |
932110 | 932110 | 2021-01-15 | Forsyth | North Carolina | 37067 | 24381 | 246 |
928865 | 928865 | 2021-01-14 | Forsyth | North Carolina | 37067 | 24103 | 237 |
925620 | 925620 | 2021-01-13 | Forsyth | North Carolina | 37067 | 23776 | 236 |
922374 | 922374 | 2021-01-12 | Forsyth | North Carolina | 37067 | 23660 | 235 |
919129 | 919129 | 2021-01-11 | Forsyth | North Carolina | 37067 | 23404 | 235 |
915884 | 915884 | 2021-01-10 | Forsyth | North Carolina | 37067 | 23205 | 235 |
912639 | 912639 | 2021-01-09 | Forsyth | North Carolina | 37067 | 22957 | 235 |
909394 | 909394 | 2021-01-08 | Forsyth | North Carolina | 37067 | 22527 | 234 |
906149 | 906149 | 2021-01-07 | Forsyth | North Carolina | 37067 | 22248 | 233 |
902903 | 902903 | 2021-01-06 | Forsyth | North Carolina | 37067 | 21913 | 231 |
899658 | 899658 | 2021-01-05 | Forsyth | North Carolina | 37067 | 21691 | 231 |
896413 | 896413 | 2021-01-04 | Forsyth | North Carolina | 37067 | 21527 | 231 |
893167 | 893167 | 2021-01-03 | Forsyth | North Carolina | 37067 | 21367 | 225 |
889921 | 889921 | 2021-01-02 | Forsyth | North Carolina | 37067 | 21208 | 225 |
886674 | 886674 | 2021-01-01 | Forsyth | North Carolina | 37067 | 20643 | 221 |
883429 | 883429 | 2020-12-31 | Forsyth | North Carolina | 37067 | 20643 | 221 |
880184 | 880184 | 2020-12-30 | Forsyth | North Carolina | 37067 | 20374 | 221 |
876939 | 876939 | 2020-12-29 | Forsyth | North Carolina | 37067 | 20077 | 221 |
873694 | 873694 | 2020-12-28 | Forsyth | North Carolina | 37067 | 19947 | 221 |
870449 | 870449 | 2020-12-27 | Forsyth | North Carolina | 37067 | 19814 | 216 |
867204 | 867204 | 2020-12-26 | Forsyth | North Carolina | 37067 | 19697 | 213 |
863959 | 863959 | 2020-12-25 | Forsyth | North Carolina | 37067 | 18979 | 212 |
860714 | 860714 | 2020-12-24 | Forsyth | North Carolina | 37067 | 18979 | 212 |
857469 | 857469 | 2020-12-23 | Forsyth | North Carolina | 37067 | 18979 | 212 |
854224 | 854224 | 2020-12-22 | Forsyth | North Carolina | 37067 | 18770 | 207 |
850979 | 850979 | 2020-12-21 | Forsyth | North Carolina | 37067 | 18525 | 206 |
847734 | 847734 | 2020-12-20 | Forsyth | North Carolina | 37067 | 18341 | 200 |
844489 | 844489 | 2020-12-19 | Forsyth | North Carolina | 37067 | 18087 | 197 |
841243 | 841243 | 2020-12-18 | Forsyth | North Carolina | 37067 | 17734 | 197 |
837998 | 837998 | 2020-12-17 | Forsyth | North Carolina | 37067 | 17429 | 196 |
834752 | 834752 | 2020-12-16 | Forsyth | North Carolina | 37067 | 17224 | 189 |
831506 | 831506 | 2020-12-15 | Forsyth | North Carolina | 37067 | 17035 | 189 |
828259 | 828259 | 2020-12-14 | Forsyth | North Carolina | 37067 | 16785 | 190 |
825013 | 825013 | 2020-12-13 | Forsyth | North Carolina | 37067 | 16568 | 185 |
821766 | 821766 | 2020-12-12 | Forsyth | North Carolina | 37067 | 16264 | 184 |
818520 | 818520 | 2020-12-11 | Forsyth | North Carolina | 37067 | 16015 | 178 |
815274 | 815274 | 2020-12-10 | Forsyth | North Carolina | 37067 | 15686 | 178 |
812029 | 812029 | 2020-12-09 | Forsyth | North Carolina | 37067 | 15480 | 176 |
808784 | 808784 | 2020-12-08 | Forsyth | North Carolina | 37067 | 15134 | 173 |
805539 | 805539 | 2020-12-07 | Forsyth | North Carolina | 37067 | 14919 | 173 |
802294 | 802294 | 2020-12-06 | Forsyth | North Carolina | 37067 | 14729 | 173 |
799049 | 799049 | 2020-12-05 | Forsyth | North Carolina | 37067 | 14448 | 171 |
795804 | 795804 | 2020-12-04 | Forsyth | North Carolina | 37067 | 14180 | 169 |
792559 | 792559 | 2020-12-03 | Forsyth | North Carolina | 37067 | 13892 | 168 |
789314 | 789314 | 2020-12-02 | Forsyth | North Carolina | 37067 | 13703 | 168 |
786069 | 786069 | 2020-12-01 | Forsyth | North Carolina | 37067 | 13538 | 166 |
782825 | 782825 | 2020-11-30 | Forsyth | North Carolina | 37067 | 13421 | 166 |
779579 | 779579 | 2020-11-29 | Forsyth | North Carolina | 37067 | 13288 | 166 |
776334 | 776334 | 2020-11-28 | Forsyth | North Carolina | 37067 | 13074 | 164 |
773089 | 773089 | 2020-11-27 | Forsyth | North Carolina | 37067 | 12968 | 164 |
769844 | 769844 | 2020-11-26 | Forsyth | North Carolina | 37067 | 12588 | 163 |
766598 | 766598 | 2020-11-25 | Forsyth | North Carolina | 37067 | 12588 | 163 |
763353 | 763353 | 2020-11-24 | Forsyth | North Carolina | 37067 | 12394 | 158 |
760108 | 760108 | 2020-11-23 | Forsyth | North Carolina | 37067 | 12249 | 157 |
756862 | 756862 | 2020-11-22 | Forsyth | North Carolina | 37067 | 12101 | 157 |
753615 | 753615 | 2020-11-21 | Forsyth | North Carolina | 37067 | 11909 | 157 |
750369 | 750369 | 2020-11-20 | Forsyth | North Carolina | 37067 | 11723 | 156 |
747123 | 747123 | 2020-11-19 | Forsyth | North Carolina | 37067 | 11577 | 153 |
743877 | 743877 | 2020-11-18 | Forsyth | North Carolina | 37067 | 11366 | 151 |
740630 | 740630 | 2020-11-17 | Forsyth | North Carolina | 37067 | 11182 | 150 |
737385 | 737385 | 2020-11-16 | Forsyth | North Carolina | 37067 | 11014 | 146 |
734141 | 734141 | 2020-11-15 | Forsyth | North Carolina | 37067 | 10938 | 143 |
730895 | 730895 | 2020-11-14 | Forsyth | North Carolina | 37067 | 10740 | 141 |
727651 | 727651 | 2020-11-13 | Forsyth | North Carolina | 37067 | 10562 | 137 |
724407 | 724407 | 2020-11-12 | Forsyth | North Carolina | 37067 | 10474 | 137 |
721164 | 721164 | 2020-11-11 | Forsyth | North Carolina | 37067 | 10296 | 137 |
717921 | 717921 | 2020-11-10 | Forsyth | North Carolina | 37067 | 10156 | 137 |
714678 | 714678 | 2020-11-09 | Forsyth | North Carolina | 37067 | 10050 | 129 |
711434 | 711434 | 2020-11-08 | Forsyth | North Carolina | 37067 | 9975 | 129 |
708190 | 708190 | 2020-11-07 | Forsyth | North Carolina | 37067 | 9818 | 129 |
704947 | 704947 | 2020-11-06 | Forsyth | North Carolina | 37067 | 9682 | 128 |
701704 | 701704 | 2020-11-05 | Forsyth | North Carolina | 37067 | 9546 | 126 |
698460 | 698460 | 2020-11-04 | Forsyth | North Carolina | 37067 | 9436 | 125 |
695217 | 695217 | 2020-11-03 | Forsyth | North Carolina | 37067 | 9336 | 121 |
691975 | 691975 | 2020-11-02 | Forsyth | North Carolina | 37067 | 9289 | 121 |
688731 | 688731 | 2020-11-01 | Forsyth | North Carolina | 37067 | 9221 | 121 |
685486 | 685486 | 2020-10-31 | Forsyth | North Carolina | 37067 | 9121 | 121 |
682243 | 682243 | 2020-10-30 | Forsyth | North Carolina | 37067 | 9039 | 121 |
679000 | 679000 | 2020-10-29 | Forsyth | North Carolina | 37067 | 8937 | 120 |
675757 | 675757 | 2020-10-28 | Forsyth | North Carolina | 37067 | 8834 | 119 |
672514 | 672514 | 2020-10-27 | Forsyth | North Carolina | 37067 | 8756 | 119 |
669272 | 669272 | 2020-10-26 | Forsyth | North Carolina | 37067 | 8703 | 119 |
666028 | 666028 | 2020-10-25 | Forsyth | North Carolina | 37067 | 8623 | 118 |
662783 | 662783 | 2020-10-24 | Forsyth | North Carolina | 37067 | 8542 | 118 |
659539 | 659539 | 2020-10-23 | Forsyth | North Carolina | 37067 | 8388 | 116 |
656295 | 656295 | 2020-10-22 | Forsyth | North Carolina | 37067 | 8319 | 115 |
653050 | 653050 | 2020-10-21 | Forsyth | North Carolina | 37067 | 8264 | 114 |
649805 | 649805 | 2020-10-20 | Forsyth | North Carolina | 37067 | 8201 | 114 |
646561 | 646561 | 2020-10-19 | Forsyth | North Carolina | 37067 | 8155 | 112 |
643315 | 643315 | 2020-10-18 | Forsyth | North Carolina | 37067 | 8131 | 111 |
640067 | 640067 | 2020-10-17 | Forsyth | North Carolina | 37067 | 8049 | 111 |
636821 | 636821 | 2020-10-16 | Forsyth | North Carolina | 37067 | 7968 | 110 |
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);