ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51147 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092229 | 1092229 | 2021-03-05 | Prince Edward | Virginia | 51147 | 1971 | 29 |
1088983 | 1088983 | 2021-03-04 | Prince Edward | Virginia | 51147 | 1964 | 28 |
1085738 | 1085738 | 2021-03-03 | Prince Edward | Virginia | 51147 | 1962 | 28 |
1082492 | 1082492 | 2021-03-02 | Prince Edward | Virginia | 51147 | 1960 | 27 |
1079246 | 1079246 | 2021-03-01 | Prince Edward | Virginia | 51147 | 1960 | 27 |
1076001 | 1076001 | 2021-02-28 | Prince Edward | Virginia | 51147 | 1953 | 26 |
1072755 | 1072755 | 2021-02-27 | Prince Edward | Virginia | 51147 | 1950 | 26 |
1069509 | 1069509 | 2021-02-26 | Prince Edward | Virginia | 51147 | 1944 | 25 |
1066264 | 1066264 | 2021-02-25 | Prince Edward | Virginia | 51147 | 1941 | 24 |
1063019 | 1063019 | 2021-02-24 | Prince Edward | Virginia | 51147 | 1929 | 23 |
1059774 | 1059774 | 2021-02-23 | Prince Edward | Virginia | 51147 | 1925 | 23 |
1056528 | 1056528 | 2021-02-22 | Prince Edward | Virginia | 51147 | 1922 | 22 |
1053282 | 1053282 | 2021-02-21 | Prince Edward | Virginia | 51147 | 1923 | 21 |
1050035 | 1050035 | 2021-02-20 | Prince Edward | Virginia | 51147 | 1918 | 21 |
1046788 | 1046788 | 2021-02-19 | Prince Edward | Virginia | 51147 | 1911 | 21 |
1043543 | 1043543 | 2021-02-18 | Prince Edward | Virginia | 51147 | 1907 | 21 |
1040298 | 1040298 | 2021-02-17 | Prince Edward | Virginia | 51147 | 1899 | 21 |
1037053 | 1037053 | 2021-02-16 | Prince Edward | Virginia | 51147 | 1901 | 21 |
1033808 | 1033808 | 2021-02-15 | Prince Edward | Virginia | 51147 | 1906 | 20 |
1030562 | 1030562 | 2021-02-14 | Prince Edward | Virginia | 51147 | 1907 | 20 |
1027315 | 1027315 | 2021-02-13 | Prince Edward | Virginia | 51147 | 1906 | 20 |
1024070 | 1024070 | 2021-02-12 | Prince Edward | Virginia | 51147 | 1892 | 20 |
1020825 | 1020825 | 2021-02-11 | Prince Edward | Virginia | 51147 | 1880 | 20 |
1017580 | 1017580 | 2021-02-10 | Prince Edward | Virginia | 51147 | 1861 | 20 |
1014335 | 1014335 | 2021-02-09 | Prince Edward | Virginia | 51147 | 1846 | 20 |
1011090 | 1011090 | 2021-02-08 | Prince Edward | Virginia | 51147 | 1840 | 20 |
1007844 | 1007844 | 2021-02-07 | Prince Edward | Virginia | 51147 | 1838 | 20 |
1004598 | 1004598 | 2021-02-06 | Prince Edward | Virginia | 51147 | 1818 | 20 |
1001352 | 1001352 | 2021-02-05 | Prince Edward | Virginia | 51147 | 1801 | 20 |
998106 | 998106 | 2021-02-04 | Prince Edward | Virginia | 51147 | 1767 | 20 |
994860 | 994860 | 2021-02-03 | Prince Edward | Virginia | 51147 | 1744 | 20 |
991614 | 991614 | 2021-02-02 | Prince Edward | Virginia | 51147 | 1741 | 20 |
988368 | 988368 | 2021-02-01 | Prince Edward | Virginia | 51147 | 1734 | 20 |
985121 | 985121 | 2021-01-31 | Prince Edward | Virginia | 51147 | 1709 | 20 |
981874 | 981874 | 2021-01-30 | Prince Edward | Virginia | 51147 | 1689 | 20 |
978628 | 978628 | 2021-01-29 | Prince Edward | Virginia | 51147 | 1663 | 20 |
975383 | 975383 | 2021-01-28 | Prince Edward | Virginia | 51147 | 1635 | 20 |
972138 | 972138 | 2021-01-27 | Prince Edward | Virginia | 51147 | 1611 | 19 |
968893 | 968893 | 2021-01-26 | Prince Edward | Virginia | 51147 | 1576 | 19 |
965649 | 965649 | 2021-01-25 | Prince Edward | Virginia | 51147 | 1562 | 19 |
962404 | 962404 | 2021-01-24 | Prince Edward | Virginia | 51147 | 1537 | 19 |
959159 | 959159 | 2021-01-23 | Prince Edward | Virginia | 51147 | 1524 | 19 |
955913 | 955913 | 2021-01-22 | Prince Edward | Virginia | 51147 | 1505 | 19 |
952668 | 952668 | 2021-01-21 | Prince Edward | Virginia | 51147 | 1481 | 19 |
949423 | 949423 | 2021-01-20 | Prince Edward | Virginia | 51147 | 1471 | 19 |
946177 | 946177 | 2021-01-19 | Prince Edward | Virginia | 51147 | 1448 | 19 |
942930 | 942930 | 2021-01-18 | Prince Edward | Virginia | 51147 | 1439 | 19 |
939685 | 939685 | 2021-01-17 | Prince Edward | Virginia | 51147 | 1411 | 19 |
936440 | 936440 | 2021-01-16 | Prince Edward | Virginia | 51147 | 1355 | 19 |
933195 | 933195 | 2021-01-15 | Prince Edward | Virginia | 51147 | 1313 | 19 |
929950 | 929950 | 2021-01-14 | Prince Edward | Virginia | 51147 | 1275 | 18 |
926705 | 926705 | 2021-01-13 | Prince Edward | Virginia | 51147 | 1244 | 18 |
923459 | 923459 | 2021-01-12 | Prince Edward | Virginia | 51147 | 1232 | 18 |
920214 | 920214 | 2021-01-11 | Prince Edward | Virginia | 51147 | 1225 | 18 |
916969 | 916969 | 2021-01-10 | Prince Edward | Virginia | 51147 | 1222 | 18 |
913724 | 913724 | 2021-01-09 | Prince Edward | Virginia | 51147 | 1220 | 18 |
910479 | 910479 | 2021-01-08 | Prince Edward | Virginia | 51147 | 1218 | 18 |
907234 | 907234 | 2021-01-07 | Prince Edward | Virginia | 51147 | 1203 | 18 |
903988 | 903988 | 2021-01-06 | Prince Edward | Virginia | 51147 | 1191 | 17 |
900743 | 900743 | 2021-01-05 | Prince Edward | Virginia | 51147 | 1170 | 17 |
897498 | 897498 | 2021-01-04 | Prince Edward | Virginia | 51147 | 1145 | 17 |
894252 | 894252 | 2021-01-03 | Prince Edward | Virginia | 51147 | 1148 | 17 |
891006 | 891006 | 2021-01-02 | Prince Edward | Virginia | 51147 | 1104 | 17 |
887759 | 887759 | 2021-01-01 | Prince Edward | Virginia | 51147 | 1094 | 17 |
884514 | 884514 | 2020-12-31 | Prince Edward | Virginia | 51147 | 1083 | 17 |
881269 | 881269 | 2020-12-30 | Prince Edward | Virginia | 51147 | 1080 | 16 |
878024 | 878024 | 2020-12-29 | Prince Edward | Virginia | 51147 | 1077 | 16 |
874779 | 874779 | 2020-12-28 | Prince Edward | Virginia | 51147 | 1065 | 16 |
871534 | 871534 | 2020-12-27 | Prince Edward | Virginia | 51147 | 1063 | 16 |
868289 | 868289 | 2020-12-26 | Prince Edward | Virginia | 51147 | 1049 | 16 |
865044 | 865044 | 2020-12-25 | Prince Edward | Virginia | 51147 | 1047 | 16 |
861799 | 861799 | 2020-12-24 | Prince Edward | Virginia | 51147 | 1026 | 16 |
858554 | 858554 | 2020-12-23 | Prince Edward | Virginia | 51147 | 1023 | 16 |
855309 | 855309 | 2020-12-22 | Prince Edward | Virginia | 51147 | 1015 | 16 |
852064 | 852064 | 2020-12-21 | Prince Edward | Virginia | 51147 | 992 | 16 |
848819 | 848819 | 2020-12-20 | Prince Edward | Virginia | 51147 | 981 | 16 |
845574 | 845574 | 2020-12-19 | Prince Edward | Virginia | 51147 | 970 | 16 |
842328 | 842328 | 2020-12-18 | Prince Edward | Virginia | 51147 | 966 | 16 |
839083 | 839083 | 2020-12-17 | Prince Edward | Virginia | 51147 | 951 | 16 |
835837 | 835837 | 2020-12-16 | Prince Edward | Virginia | 51147 | 949 | 16 |
832591 | 832591 | 2020-12-15 | Prince Edward | Virginia | 51147 | 943 | 16 |
829344 | 829344 | 2020-12-14 | Prince Edward | Virginia | 51147 | 937 | 16 |
826098 | 826098 | 2020-12-13 | Prince Edward | Virginia | 51147 | 932 | 16 |
822851 | 822851 | 2020-12-12 | Prince Edward | Virginia | 51147 | 928 | 16 |
819605 | 819605 | 2020-12-11 | Prince Edward | Virginia | 51147 | 923 | 16 |
816359 | 816359 | 2020-12-10 | Prince Edward | Virginia | 51147 | 918 | 16 |
813113 | 813113 | 2020-12-09 | Prince Edward | Virginia | 51147 | 917 | 16 |
809869 | 809869 | 2020-12-08 | Prince Edward | Virginia | 51147 | 913 | 16 |
806624 | 806624 | 2020-12-07 | Prince Edward | Virginia | 51147 | 907 | 16 |
803379 | 803379 | 2020-12-06 | Prince Edward | Virginia | 51147 | 902 | 16 |
800134 | 800134 | 2020-12-05 | Prince Edward | Virginia | 51147 | 897 | 16 |
796889 | 796889 | 2020-12-04 | Prince Edward | Virginia | 51147 | 893 | 16 |
793644 | 793644 | 2020-12-03 | Prince Edward | Virginia | 51147 | 886 | 16 |
790399 | 790399 | 2020-12-02 | Prince Edward | Virginia | 51147 | 884 | 16 |
787154 | 787154 | 2020-12-01 | Prince Edward | Virginia | 51147 | 879 | 16 |
783910 | 783910 | 2020-11-30 | Prince Edward | Virginia | 51147 | 877 | 16 |
780665 | 780665 | 2020-11-29 | Prince Edward | Virginia | 51147 | 876 | 16 |
777419 | 777419 | 2020-11-28 | Prince Edward | Virginia | 51147 | 871 | 16 |
774174 | 774174 | 2020-11-27 | Prince Edward | Virginia | 51147 | 866 | 16 |
770929 | 770929 | 2020-11-26 | Prince Edward | Virginia | 51147 | 865 | 16 |
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);