ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51041 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952595 | 952595 | 2021-01-21 | Chesterfield | Virginia | 51041 | 17254 | 194 |
949350 | 949350 | 2021-01-20 | Chesterfield | Virginia | 51041 | 17097 | 193 |
946104 | 946104 | 2021-01-19 | Chesterfield | Virginia | 51041 | 16897 | 193 |
942857 | 942857 | 2021-01-18 | Chesterfield | Virginia | 51041 | 16641 | 193 |
939612 | 939612 | 2021-01-17 | Chesterfield | Virginia | 51041 | 16327 | 193 |
936367 | 936367 | 2021-01-16 | Chesterfield | Virginia | 51041 | 15769 | 193 |
933122 | 933122 | 2021-01-15 | Chesterfield | Virginia | 51041 | 15425 | 191 |
929877 | 929877 | 2021-01-14 | Chesterfield | Virginia | 51041 | 15203 | 190 |
926632 | 926632 | 2021-01-13 | Chesterfield | Virginia | 51041 | 15057 | 186 |
923386 | 923386 | 2021-01-12 | Chesterfield | Virginia | 51041 | 14904 | 185 |
920141 | 920141 | 2021-01-11 | Chesterfield | Virginia | 51041 | 14778 | 183 |
916896 | 916896 | 2021-01-10 | Chesterfield | Virginia | 51041 | 14686 | 183 |
913651 | 913651 | 2021-01-09 | Chesterfield | Virginia | 51041 | 14531 | 183 |
910406 | 910406 | 2021-01-08 | Chesterfield | Virginia | 51041 | 14287 | 182 |
907161 | 907161 | 2021-01-07 | Chesterfield | Virginia | 51041 | 14142 | 178 |
903915 | 903915 | 2021-01-06 | Chesterfield | Virginia | 51041 | 13953 | 175 |
900670 | 900670 | 2021-01-05 | Chesterfield | Virginia | 51041 | 13822 | 174 |
897425 | 897425 | 2021-01-04 | Chesterfield | Virginia | 51041 | 13658 | 173 |
894179 | 894179 | 2021-01-03 | Chesterfield | Virginia | 51041 | 13505 | 173 |
890933 | 890933 | 2021-01-02 | Chesterfield | Virginia | 51041 | 13374 | 173 |
887686 | 887686 | 2021-01-01 | Chesterfield | Virginia | 51041 | 13215 | 171 |
884441 | 884441 | 2020-12-31 | Chesterfield | Virginia | 51041 | 13059 | 172 |
881196 | 881196 | 2020-12-30 | Chesterfield | Virginia | 51041 | 12876 | 169 |
877951 | 877951 | 2020-12-29 | Chesterfield | Virginia | 51041 | 12727 | 165 |
874706 | 874706 | 2020-12-28 | Chesterfield | Virginia | 51041 | 12552 | 163 |
871461 | 871461 | 2020-12-27 | Chesterfield | Virginia | 51041 | 12399 | 163 |
868216 | 868216 | 2020-12-26 | Chesterfield | Virginia | 51041 | 12321 | 164 |
864971 | 864971 | 2020-12-25 | Chesterfield | Virginia | 51041 | 12272 | 164 |
861726 | 861726 | 2020-12-24 | Chesterfield | Virginia | 51041 | 12186 | 163 |
858481 | 858481 | 2020-12-23 | Chesterfield | Virginia | 51041 | 12072 | 161 |
855236 | 855236 | 2020-12-22 | Chesterfield | Virginia | 51041 | 11896 | 158 |
851991 | 851991 | 2020-12-21 | Chesterfield | Virginia | 51041 | 11678 | 156 |
848746 | 848746 | 2020-12-20 | Chesterfield | Virginia | 51041 | 11583 | 156 |
845501 | 845501 | 2020-12-19 | Chesterfield | Virginia | 51041 | 11528 | 156 |
842255 | 842255 | 2020-12-18 | Chesterfield | Virginia | 51041 | 11409 | 156 |
839010 | 839010 | 2020-12-17 | Chesterfield | Virginia | 51041 | 11220 | 154 |
835764 | 835764 | 2020-12-16 | Chesterfield | Virginia | 51041 | 11129 | 151 |
832518 | 832518 | 2020-12-15 | Chesterfield | Virginia | 51041 | 10994 | 150 |
829271 | 829271 | 2020-12-14 | Chesterfield | Virginia | 51041 | 10822 | 148 |
826025 | 826025 | 2020-12-13 | Chesterfield | Virginia | 51041 | 10753 | 148 |
822778 | 822778 | 2020-12-12 | Chesterfield | Virginia | 51041 | 10680 | 148 |
819532 | 819532 | 2020-12-11 | Chesterfield | Virginia | 51041 | 10590 | 146 |
816286 | 816286 | 2020-12-10 | Chesterfield | Virginia | 51041 | 10445 | 143 |
813040 | 813040 | 2020-12-09 | Chesterfield | Virginia | 51041 | 10350 | 139 |
809796 | 809796 | 2020-12-08 | Chesterfield | Virginia | 51041 | 10216 | 139 |
806551 | 806551 | 2020-12-07 | Chesterfield | Virginia | 51041 | 10056 | 135 |
803306 | 803306 | 2020-12-06 | Chesterfield | Virginia | 51041 | 9957 | 135 |
800061 | 800061 | 2020-12-05 | Chesterfield | Virginia | 51041 | 9874 | 135 |
796816 | 796816 | 2020-12-04 | Chesterfield | Virginia | 51041 | 9732 | 135 |
793571 | 793571 | 2020-12-03 | Chesterfield | Virginia | 51041 | 9631 | 135 |
790326 | 790326 | 2020-12-02 | Chesterfield | Virginia | 51041 | 9563 | 131 |
787081 | 787081 | 2020-12-01 | Chesterfield | Virginia | 51041 | 9443 | 131 |
783837 | 783837 | 2020-11-30 | Chesterfield | Virginia | 51041 | 9323 | 131 |
780592 | 780592 | 2020-11-29 | Chesterfield | Virginia | 51041 | 9255 | 131 |
777346 | 777346 | 2020-11-28 | Chesterfield | Virginia | 51041 | 9181 | 131 |
774101 | 774101 | 2020-11-27 | Chesterfield | Virginia | 51041 | 9101 | 131 |
770856 | 770856 | 2020-11-26 | Chesterfield | Virginia | 51041 | 9045 | 129 |
767610 | 767610 | 2020-11-25 | Chesterfield | Virginia | 51041 | 8942 | 128 |
764365 | 764365 | 2020-11-24 | Chesterfield | Virginia | 51041 | 8827 | 127 |
761120 | 761120 | 2020-11-23 | Chesterfield | Virginia | 51041 | 8698 | 127 |
757875 | 757875 | 2020-11-22 | Chesterfield | Virginia | 51041 | 8617 | 127 |
754628 | 754628 | 2020-11-21 | Chesterfield | Virginia | 51041 | 8540 | 127 |
751382 | 751382 | 2020-11-20 | Chesterfield | Virginia | 51041 | 8451 | 124 |
748136 | 748136 | 2020-11-19 | Chesterfield | Virginia | 51041 | 8363 | 124 |
744890 | 744890 | 2020-11-18 | Chesterfield | Virginia | 51041 | 8295 | 123 |
741643 | 741643 | 2020-11-17 | Chesterfield | Virginia | 51041 | 8253 | 122 |
738396 | 738396 | 2020-11-16 | Chesterfield | Virginia | 51041 | 8169 | 121 |
735152 | 735152 | 2020-11-15 | Chesterfield | Virginia | 51041 | 8047 | 121 |
731906 | 731906 | 2020-11-14 | Chesterfield | Virginia | 51041 | 8011 | 121 |
728661 | 728661 | 2020-11-13 | Chesterfield | Virginia | 51041 | 7951 | 121 |
725418 | 725418 | 2020-11-12 | Chesterfield | Virginia | 51041 | 7924 | 121 |
722175 | 722175 | 2020-11-11 | Chesterfield | Virginia | 51041 | 7849 | 120 |
718932 | 718932 | 2020-11-10 | Chesterfield | Virginia | 51041 | 7761 | 120 |
715689 | 715689 | 2020-11-09 | Chesterfield | Virginia | 51041 | 7709 | 120 |
712445 | 712445 | 2020-11-08 | Chesterfield | Virginia | 51041 | 7619 | 120 |
709201 | 709201 | 2020-11-07 | Chesterfield | Virginia | 51041 | 7558 | 120 |
705957 | 705957 | 2020-11-06 | Chesterfield | Virginia | 51041 | 7481 | 120 |
702714 | 702714 | 2020-11-05 | Chesterfield | Virginia | 51041 | 7445 | 120 |
699471 | 699471 | 2020-11-04 | Chesterfield | Virginia | 51041 | 7407 | 120 |
696227 | 696227 | 2020-11-03 | Chesterfield | Virginia | 51041 | 7361 | 120 |
692985 | 692985 | 2020-11-02 | Chesterfield | Virginia | 51041 | 7320 | 120 |
689741 | 689741 | 2020-11-01 | Chesterfield | Virginia | 51041 | 7302 | 120 |
686496 | 686496 | 2020-10-31 | Chesterfield | Virginia | 51041 | 7274 | 120 |
683253 | 683253 | 2020-10-30 | Chesterfield | Virginia | 51041 | 7212 | 119 |
680010 | 680010 | 2020-10-29 | Chesterfield | Virginia | 51041 | 7162 | 118 |
676767 | 676767 | 2020-10-28 | Chesterfield | Virginia | 51041 | 7111 | 113 |
673524 | 673524 | 2020-10-27 | Chesterfield | Virginia | 51041 | 7058 | 106 |
670282 | 670282 | 2020-10-26 | Chesterfield | Virginia | 51041 | 7029 | 102 |
667039 | 667039 | 2020-10-25 | Chesterfield | Virginia | 51041 | 6980 | 102 |
663794 | 663794 | 2020-10-24 | Chesterfield | Virginia | 51041 | 6934 | 102 |
660550 | 660550 | 2020-10-23 | Chesterfield | Virginia | 51041 | 6869 | 101 |
657306 | 657306 | 2020-10-22 | Chesterfield | Virginia | 51041 | 6851 | 100 |
654061 | 654061 | 2020-10-21 | Chesterfield | Virginia | 51041 | 6796 | 100 |
650816 | 650816 | 2020-10-20 | Chesterfield | Virginia | 51041 | 6737 | 100 |
647572 | 647572 | 2020-10-19 | Chesterfield | Virginia | 51041 | 6695 | 99 |
644326 | 644326 | 2020-10-18 | Chesterfield | Virginia | 51041 | 6679 | 99 |
641078 | 641078 | 2020-10-17 | Chesterfield | Virginia | 51041 | 6662 | 99 |
637831 | 637831 | 2020-10-16 | Chesterfield | Virginia | 51041 | 6568 | 99 |
634586 | 634586 | 2020-10-15 | Chesterfield | Virginia | 51041 | 6546 | 98 |
631341 | 631341 | 2020-10-14 | Chesterfield | Virginia | 51041 | 6478 | 98 |
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);