ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Loudoun" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955885 | 955885 | 2021-01-22 | Loudoun | Virginia | 51107 | 17809 | 171 |
952640 | 952640 | 2021-01-21 | Loudoun | Virginia | 51107 | 17571 | 171 |
949395 | 949395 | 2021-01-20 | Loudoun | Virginia | 51107 | 17389 | 170 |
946149 | 946149 | 2021-01-19 | Loudoun | Virginia | 51107 | 17236 | 170 |
942902 | 942902 | 2021-01-18 | Loudoun | Virginia | 51107 | 17014 | 168 |
939657 | 939657 | 2021-01-17 | Loudoun | Virginia | 51107 | 16637 | 168 |
936412 | 936412 | 2021-01-16 | Loudoun | Virginia | 51107 | 16245 | 168 |
933167 | 933167 | 2021-01-15 | Loudoun | Virginia | 51107 | 16035 | 166 |
929922 | 929922 | 2021-01-14 | Loudoun | Virginia | 51107 | 15876 | 165 |
926677 | 926677 | 2021-01-13 | Loudoun | Virginia | 51107 | 15711 | 165 |
923431 | 923431 | 2021-01-12 | Loudoun | Virginia | 51107 | 15604 | 165 |
920186 | 920186 | 2021-01-11 | Loudoun | Virginia | 51107 | 15443 | 164 |
916941 | 916941 | 2021-01-10 | Loudoun | Virginia | 51107 | 15368 | 164 |
913696 | 913696 | 2021-01-09 | Loudoun | Virginia | 51107 | 15286 | 164 |
910451 | 910451 | 2021-01-08 | Loudoun | Virginia | 51107 | 15219 | 162 |
907206 | 907206 | 2021-01-07 | Loudoun | Virginia | 51107 | 15095 | 162 |
903960 | 903960 | 2021-01-06 | Loudoun | Virginia | 51107 | 14973 | 161 |
900715 | 900715 | 2021-01-05 | Loudoun | Virginia | 51107 | 14786 | 161 |
897470 | 897470 | 2021-01-04 | Loudoun | Virginia | 51107 | 14569 | 161 |
894224 | 894224 | 2021-01-03 | Loudoun | Virginia | 51107 | 14518 | 161 |
890978 | 890978 | 2021-01-02 | Loudoun | Virginia | 51107 | 14481 | 161 |
887731 | 887731 | 2021-01-01 | Loudoun | Virginia | 51107 | 14352 | 161 |
884486 | 884486 | 2020-12-31 | Loudoun | Virginia | 51107 | 14169 | 159 |
881241 | 881241 | 2020-12-30 | Loudoun | Virginia | 51107 | 13996 | 158 |
877996 | 877996 | 2020-12-29 | Loudoun | Virginia | 51107 | 13848 | 156 |
874751 | 874751 | 2020-12-28 | Loudoun | Virginia | 51107 | 13683 | 154 |
871506 | 871506 | 2020-12-27 | Loudoun | Virginia | 51107 | 13600 | 154 |
868261 | 868261 | 2020-12-26 | Loudoun | Virginia | 51107 | 13441 | 154 |
865016 | 865016 | 2020-12-25 | Loudoun | Virginia | 51107 | 13280 | 154 |
861771 | 861771 | 2020-12-24 | Loudoun | Virginia | 51107 | 13171 | 154 |
858526 | 858526 | 2020-12-23 | Loudoun | Virginia | 51107 | 13082 | 154 |
855281 | 855281 | 2020-12-22 | Loudoun | Virginia | 51107 | 12925 | 154 |
852036 | 852036 | 2020-12-21 | Loudoun | Virginia | 51107 | 12861 | 155 |
848791 | 848791 | 2020-12-20 | Loudoun | Virginia | 51107 | 12682 | 155 |
845546 | 845546 | 2020-12-19 | Loudoun | Virginia | 51107 | 12503 | 155 |
842300 | 842300 | 2020-12-18 | Loudoun | Virginia | 51107 | 12386 | 155 |
839055 | 839055 | 2020-12-17 | Loudoun | Virginia | 51107 | 12297 | 155 |
835809 | 835809 | 2020-12-16 | Loudoun | Virginia | 51107 | 12193 | 154 |
832563 | 832563 | 2020-12-15 | Loudoun | Virginia | 51107 | 12029 | 154 |
829316 | 829316 | 2020-12-14 | Loudoun | Virginia | 51107 | 11937 | 151 |
826070 | 826070 | 2020-12-13 | Loudoun | Virginia | 51107 | 11788 | 151 |
822823 | 822823 | 2020-12-12 | Loudoun | Virginia | 51107 | 11709 | 151 |
819577 | 819577 | 2020-12-11 | Loudoun | Virginia | 51107 | 11545 | 151 |
816331 | 816331 | 2020-12-10 | Loudoun | Virginia | 51107 | 11420 | 151 |
813085 | 813085 | 2020-12-09 | Loudoun | Virginia | 51107 | 11270 | 151 |
809841 | 809841 | 2020-12-08 | Loudoun | Virginia | 51107 | 11005 | 151 |
806596 | 806596 | 2020-12-07 | Loudoun | Virginia | 51107 | 10832 | 150 |
803351 | 803351 | 2020-12-06 | Loudoun | Virginia | 51107 | 10635 | 150 |
800106 | 800106 | 2020-12-05 | Loudoun | Virginia | 51107 | 10557 | 150 |
796861 | 796861 | 2020-12-04 | Loudoun | Virginia | 51107 | 10469 | 150 |
793616 | 793616 | 2020-12-03 | Loudoun | Virginia | 51107 | 10376 | 150 |
790371 | 790371 | 2020-12-02 | Loudoun | Virginia | 51107 | 10302 | 144 |
787126 | 787126 | 2020-12-01 | Loudoun | Virginia | 51107 | 10232 | 144 |
783882 | 783882 | 2020-11-30 | Loudoun | Virginia | 51107 | 10049 | 143 |
780637 | 780637 | 2020-11-29 | Loudoun | Virginia | 51107 | 10021 | 142 |
777391 | 777391 | 2020-11-28 | Loudoun | Virginia | 51107 | 9980 | 142 |
774146 | 774146 | 2020-11-27 | Loudoun | Virginia | 51107 | 9872 | 142 |
770901 | 770901 | 2020-11-26 | Loudoun | Virginia | 51107 | 9817 | 142 |
767655 | 767655 | 2020-11-25 | Loudoun | Virginia | 51107 | 9717 | 142 |
764410 | 764410 | 2020-11-24 | Loudoun | Virginia | 51107 | 9512 | 139 |
761165 | 761165 | 2020-11-23 | Loudoun | Virginia | 51107 | 9345 | 139 |
757920 | 757920 | 2020-11-22 | Loudoun | Virginia | 51107 | 9265 | 139 |
754673 | 754673 | 2020-11-21 | Loudoun | Virginia | 51107 | 9216 | 139 |
751427 | 751427 | 2020-11-20 | Loudoun | Virginia | 51107 | 9149 | 139 |
748181 | 748181 | 2020-11-19 | Loudoun | Virginia | 51107 | 9046 | 138 |
744935 | 744935 | 2020-11-18 | Loudoun | Virginia | 51107 | 9020 | 136 |
741688 | 741688 | 2020-11-17 | Loudoun | Virginia | 51107 | 8954 | 136 |
738441 | 738441 | 2020-11-16 | Loudoun | Virginia | 51107 | 8894 | 136 |
735197 | 735197 | 2020-11-15 | Loudoun | Virginia | 51107 | 8810 | 135 |
731951 | 731951 | 2020-11-14 | Loudoun | Virginia | 51107 | 8706 | 135 |
728706 | 728706 | 2020-11-13 | Loudoun | Virginia | 51107 | 8642 | 135 |
725463 | 725463 | 2020-11-12 | Loudoun | Virginia | 51107 | 8622 | 134 |
722220 | 722220 | 2020-11-11 | Loudoun | Virginia | 51107 | 8560 | 134 |
718977 | 718977 | 2020-11-10 | Loudoun | Virginia | 51107 | 8486 | 134 |
715734 | 715734 | 2020-11-09 | Loudoun | Virginia | 51107 | 8413 | 134 |
712490 | 712490 | 2020-11-08 | Loudoun | Virginia | 51107 | 8336 | 134 |
709246 | 709246 | 2020-11-07 | Loudoun | Virginia | 51107 | 8313 | 134 |
706002 | 706002 | 2020-11-06 | Loudoun | Virginia | 51107 | 8225 | 134 |
702759 | 702759 | 2020-11-05 | Loudoun | Virginia | 51107 | 8175 | 133 |
699516 | 699516 | 2020-11-04 | Loudoun | Virginia | 51107 | 8143 | 132 |
696272 | 696272 | 2020-11-03 | Loudoun | Virginia | 51107 | 8105 | 132 |
693030 | 693030 | 2020-11-02 | Loudoun | Virginia | 51107 | 8048 | 132 |
689786 | 689786 | 2020-11-01 | Loudoun | Virginia | 51107 | 8048 | 132 |
686541 | 686541 | 2020-10-31 | Loudoun | Virginia | 51107 | 7981 | 131 |
683298 | 683298 | 2020-10-30 | Loudoun | Virginia | 51107 | 7946 | 130 |
680055 | 680055 | 2020-10-29 | Loudoun | Virginia | 51107 | 7908 | 130 |
676812 | 676812 | 2020-10-28 | Loudoun | Virginia | 51107 | 7876 | 130 |
673569 | 673569 | 2020-10-27 | Loudoun | Virginia | 51107 | 7817 | 130 |
670327 | 670327 | 2020-10-26 | Loudoun | Virginia | 51107 | 7784 | 130 |
667084 | 667084 | 2020-10-25 | Loudoun | Virginia | 51107 | 7736 | 130 |
663839 | 663839 | 2020-10-24 | Loudoun | Virginia | 51107 | 7730 | 130 |
660595 | 660595 | 2020-10-23 | Loudoun | Virginia | 51107 | 7704 | 130 |
657351 | 657351 | 2020-10-22 | Loudoun | Virginia | 51107 | 7680 | 130 |
654106 | 654106 | 2020-10-21 | Loudoun | Virginia | 51107 | 7634 | 130 |
650861 | 650861 | 2020-10-20 | Loudoun | Virginia | 51107 | 7599 | 130 |
647617 | 647617 | 2020-10-19 | Loudoun | Virginia | 51107 | 7576 | 129 |
644371 | 644371 | 2020-10-18 | Loudoun | Virginia | 51107 | 7558 | 129 |
641123 | 641123 | 2020-10-17 | Loudoun | Virginia | 51107 | 7505 | 129 |
637876 | 637876 | 2020-10-16 | Loudoun | Virginia | 51107 | 7454 | 129 |
634631 | 634631 | 2020-10-15 | Loudoun | Virginia | 51107 | 7417 | 129 |
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);