ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 51023 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092143 | 1092143 | 2021-03-05 | Botetourt | Virginia | 51023 | 2252 | 29 |
1088897 | 1088897 | 2021-03-04 | Botetourt | Virginia | 51023 | 2246 | 29 |
1085652 | 1085652 | 2021-03-03 | Botetourt | Virginia | 51023 | 2238 | 29 |
1082406 | 1082406 | 2021-03-02 | Botetourt | Virginia | 51023 | 2229 | 28 |
1079160 | 1079160 | 2021-03-01 | Botetourt | Virginia | 51023 | 2223 | 27 |
1075915 | 1075915 | 2021-02-28 | Botetourt | Virginia | 51023 | 2216 | 26 |
1072669 | 1072669 | 2021-02-27 | Botetourt | Virginia | 51023 | 2211 | 26 |
1069423 | 1069423 | 2021-02-26 | Botetourt | Virginia | 51023 | 2201 | 26 |
1066178 | 1066178 | 2021-02-25 | Botetourt | Virginia | 51023 | 2193 | 25 |
1062933 | 1062933 | 2021-02-24 | Botetourt | Virginia | 51023 | 2186 | 25 |
1059688 | 1059688 | 2021-02-23 | Botetourt | Virginia | 51023 | 2168 | 25 |
1056442 | 1056442 | 2021-02-22 | Botetourt | Virginia | 51023 | 2155 | 23 |
1053196 | 1053196 | 2021-02-21 | Botetourt | Virginia | 51023 | 2149 | 23 |
1049949 | 1049949 | 2021-02-20 | Botetourt | Virginia | 51023 | 2141 | 21 |
1046702 | 1046702 | 2021-02-19 | Botetourt | Virginia | 51023 | 2082 | 21 |
1043457 | 1043457 | 2021-02-18 | Botetourt | Virginia | 51023 | 2059 | 21 |
1040212 | 1040212 | 2021-02-17 | Botetourt | Virginia | 51023 | 2036 | 21 |
1036967 | 1036967 | 2021-02-16 | Botetourt | Virginia | 51023 | 2029 | 21 |
1033722 | 1033722 | 2021-02-15 | Botetourt | Virginia | 51023 | 2021 | 21 |
1030476 | 1030476 | 2021-02-14 | Botetourt | Virginia | 51023 | 2016 | 21 |
1027229 | 1027229 | 2021-02-13 | Botetourt | Virginia | 51023 | 2010 | 21 |
1023984 | 1023984 | 2021-02-12 | Botetourt | Virginia | 51023 | 1990 | 21 |
1020739 | 1020739 | 2021-02-11 | Botetourt | Virginia | 51023 | 1974 | 22 |
1017494 | 1017494 | 2021-02-10 | Botetourt | Virginia | 51023 | 1965 | 22 |
1014249 | 1014249 | 2021-02-09 | Botetourt | Virginia | 51023 | 1959 | 22 |
1011004 | 1011004 | 2021-02-08 | Botetourt | Virginia | 51023 | 1946 | 22 |
1007758 | 1007758 | 2021-02-07 | Botetourt | Virginia | 51023 | 1944 | 22 |
1004512 | 1004512 | 2021-02-06 | Botetourt | Virginia | 51023 | 1935 | 22 |
1001266 | 1001266 | 2021-02-05 | Botetourt | Virginia | 51023 | 1922 | 22 |
998020 | 998020 | 2021-02-04 | Botetourt | Virginia | 51023 | 1912 | 22 |
994774 | 994774 | 2021-02-03 | Botetourt | Virginia | 51023 | 1900 | 22 |
991528 | 991528 | 2021-02-02 | Botetourt | Virginia | 51023 | 1891 | 21 |
988282 | 988282 | 2021-02-01 | Botetourt | Virginia | 51023 | 1879 | 21 |
985035 | 985035 | 2021-01-31 | Botetourt | Virginia | 51023 | 1866 | 21 |
981788 | 981788 | 2021-01-30 | Botetourt | Virginia | 51023 | 1851 | 21 |
978542 | 978542 | 2021-01-29 | Botetourt | Virginia | 51023 | 1834 | 21 |
975297 | 975297 | 2021-01-28 | Botetourt | Virginia | 51023 | 1813 | 21 |
972052 | 972052 | 2021-01-27 | Botetourt | Virginia | 51023 | 1802 | 21 |
968807 | 968807 | 2021-01-26 | Botetourt | Virginia | 51023 | 1781 | 20 |
965563 | 965563 | 2021-01-25 | Botetourt | Virginia | 51023 | 1771 | 20 |
962318 | 962318 | 2021-01-24 | Botetourt | Virginia | 51023 | 1755 | 20 |
959073 | 959073 | 2021-01-23 | Botetourt | Virginia | 51023 | 1743 | 20 |
955827 | 955827 | 2021-01-22 | Botetourt | Virginia | 51023 | 1734 | 20 |
952582 | 952582 | 2021-01-21 | Botetourt | Virginia | 51023 | 1716 | 19 |
949337 | 949337 | 2021-01-20 | Botetourt | Virginia | 51023 | 1708 | 19 |
946091 | 946091 | 2021-01-19 | Botetourt | Virginia | 51023 | 1684 | 18 |
942844 | 942844 | 2021-01-18 | Botetourt | Virginia | 51023 | 1670 | 18 |
939599 | 939599 | 2021-01-17 | Botetourt | Virginia | 51023 | 1657 | 18 |
936354 | 936354 | 2021-01-16 | Botetourt | Virginia | 51023 | 1644 | 18 |
933109 | 933109 | 2021-01-15 | Botetourt | Virginia | 51023 | 1610 | 18 |
929864 | 929864 | 2021-01-14 | Botetourt | Virginia | 51023 | 1595 | 18 |
926619 | 926619 | 2021-01-13 | Botetourt | Virginia | 51023 | 1579 | 18 |
923373 | 923373 | 2021-01-12 | Botetourt | Virginia | 51023 | 1548 | 18 |
920128 | 920128 | 2021-01-11 | Botetourt | Virginia | 51023 | 1516 | 18 |
916883 | 916883 | 2021-01-10 | Botetourt | Virginia | 51023 | 1509 | 18 |
913638 | 913638 | 2021-01-09 | Botetourt | Virginia | 51023 | 1483 | 18 |
910393 | 910393 | 2021-01-08 | Botetourt | Virginia | 51023 | 1461 | 18 |
907148 | 907148 | 2021-01-07 | Botetourt | Virginia | 51023 | 1434 | 18 |
903902 | 903902 | 2021-01-06 | Botetourt | Virginia | 51023 | 1397 | 18 |
900657 | 900657 | 2021-01-05 | Botetourt | Virginia | 51023 | 1383 | 18 |
897412 | 897412 | 2021-01-04 | Botetourt | Virginia | 51023 | 1368 | 18 |
894166 | 894166 | 2021-01-03 | Botetourt | Virginia | 51023 | 1353 | 18 |
890920 | 890920 | 2021-01-02 | Botetourt | Virginia | 51023 | 1338 | 18 |
887673 | 887673 | 2021-01-01 | Botetourt | Virginia | 51023 | 1316 | 18 |
884428 | 884428 | 2020-12-31 | Botetourt | Virginia | 51023 | 1292 | 17 |
881183 | 881183 | 2020-12-30 | Botetourt | Virginia | 51023 | 1274 | 16 |
877938 | 877938 | 2020-12-29 | Botetourt | Virginia | 51023 | 1263 | 16 |
874693 | 874693 | 2020-12-28 | Botetourt | Virginia | 51023 | 1243 | 16 |
871448 | 871448 | 2020-12-27 | Botetourt | Virginia | 51023 | 1232 | 16 |
868203 | 868203 | 2020-12-26 | Botetourt | Virginia | 51023 | 1221 | 16 |
864958 | 864958 | 2020-12-25 | Botetourt | Virginia | 51023 | 1212 | 16 |
861713 | 861713 | 2020-12-24 | Botetourt | Virginia | 51023 | 1190 | 16 |
858468 | 858468 | 2020-12-23 | Botetourt | Virginia | 51023 | 1142 | 16 |
855223 | 855223 | 2020-12-22 | Botetourt | Virginia | 51023 | 1110 | 15 |
851978 | 851978 | 2020-12-21 | Botetourt | Virginia | 51023 | 1099 | 15 |
848733 | 848733 | 2020-12-20 | Botetourt | Virginia | 51023 | 1094 | 15 |
845488 | 845488 | 2020-12-19 | Botetourt | Virginia | 51023 | 1074 | 15 |
842242 | 842242 | 2020-12-18 | Botetourt | Virginia | 51023 | 1052 | 15 |
838997 | 838997 | 2020-12-17 | Botetourt | Virginia | 51023 | 1040 | 14 |
835751 | 835751 | 2020-12-16 | Botetourt | Virginia | 51023 | 1022 | 14 |
832505 | 832505 | 2020-12-15 | Botetourt | Virginia | 51023 | 977 | 14 |
829258 | 829258 | 2020-12-14 | Botetourt | Virginia | 51023 | 978 | 14 |
826012 | 826012 | 2020-12-13 | Botetourt | Virginia | 51023 | 978 | 14 |
822765 | 822765 | 2020-12-12 | Botetourt | Virginia | 51023 | 967 | 14 |
819519 | 819519 | 2020-12-11 | Botetourt | Virginia | 51023 | 953 | 14 |
816273 | 816273 | 2020-12-10 | Botetourt | Virginia | 51023 | 942 | 14 |
813027 | 813027 | 2020-12-09 | Botetourt | Virginia | 51023 | 922 | 14 |
809783 | 809783 | 2020-12-08 | Botetourt | Virginia | 51023 | 895 | 14 |
806538 | 806538 | 2020-12-07 | Botetourt | Virginia | 51023 | 854 | 13 |
803293 | 803293 | 2020-12-06 | Botetourt | Virginia | 51023 | 852 | 13 |
800048 | 800048 | 2020-12-05 | Botetourt | Virginia | 51023 | 839 | 13 |
796803 | 796803 | 2020-12-04 | Botetourt | Virginia | 51023 | 818 | 13 |
793558 | 793558 | 2020-12-03 | Botetourt | Virginia | 51023 | 802 | 13 |
790313 | 790313 | 2020-12-02 | Botetourt | Virginia | 51023 | 794 | 13 |
787068 | 787068 | 2020-12-01 | Botetourt | Virginia | 51023 | 784 | 13 |
783824 | 783824 | 2020-11-30 | Botetourt | Virginia | 51023 | 778 | 13 |
780579 | 780579 | 2020-11-29 | Botetourt | Virginia | 51023 | 778 | 13 |
777333 | 777333 | 2020-11-28 | Botetourt | Virginia | 51023 | 767 | 13 |
774088 | 774088 | 2020-11-27 | Botetourt | Virginia | 51023 | 752 | 13 |
770843 | 770843 | 2020-11-26 | Botetourt | Virginia | 51023 | 741 | 13 |
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);