ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Goochland" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092181 | 1092181 | 2021-03-05 | Goochland | Virginia | 51075 | 1225 | 17 |
1088935 | 1088935 | 2021-03-04 | Goochland | Virginia | 51075 | 1219 | 17 |
1085690 | 1085690 | 2021-03-03 | Goochland | Virginia | 51075 | 1220 | 17 |
1082444 | 1082444 | 2021-03-02 | Goochland | Virginia | 51075 | 1219 | 16 |
1079198 | 1079198 | 2021-03-01 | Goochland | Virginia | 51075 | 1209 | 15 |
1075953 | 1075953 | 2021-02-28 | Goochland | Virginia | 51075 | 1207 | 13 |
1072707 | 1072707 | 2021-02-27 | Goochland | Virginia | 51075 | 1208 | 13 |
1069461 | 1069461 | 2021-02-26 | Goochland | Virginia | 51075 | 1204 | 12 |
1066216 | 1066216 | 2021-02-25 | Goochland | Virginia | 51075 | 1199 | 11 |
1062971 | 1062971 | 2021-02-24 | Goochland | Virginia | 51075 | 1201 | 10 |
1059726 | 1059726 | 2021-02-23 | Goochland | Virginia | 51075 | 1198 | 8 |
1056480 | 1056480 | 2021-02-22 | Goochland | Virginia | 51075 | 1196 | 8 |
1053234 | 1053234 | 2021-02-21 | Goochland | Virginia | 51075 | 1194 | 8 |
1049987 | 1049987 | 2021-02-20 | Goochland | Virginia | 51075 | 1191 | 8 |
1046740 | 1046740 | 2021-02-19 | Goochland | Virginia | 51075 | 1189 | 8 |
1043495 | 1043495 | 2021-02-18 | Goochland | Virginia | 51075 | 1187 | 8 |
1040250 | 1040250 | 2021-02-17 | Goochland | Virginia | 51075 | 1178 | 8 |
1037005 | 1037005 | 2021-02-16 | Goochland | Virginia | 51075 | 1171 | 8 |
1033760 | 1033760 | 2021-02-15 | Goochland | Virginia | 51075 | 1169 | 8 |
1030514 | 1030514 | 2021-02-14 | Goochland | Virginia | 51075 | 1161 | 8 |
1027267 | 1027267 | 2021-02-13 | Goochland | Virginia | 51075 | 1151 | 8 |
1024022 | 1024022 | 2021-02-12 | Goochland | Virginia | 51075 | 1144 | 8 |
1020777 | 1020777 | 2021-02-11 | Goochland | Virginia | 51075 | 1141 | 8 |
1017532 | 1017532 | 2021-02-10 | Goochland | Virginia | 51075 | 1135 | 8 |
1014287 | 1014287 | 2021-02-09 | Goochland | Virginia | 51075 | 1126 | 8 |
1011042 | 1011042 | 2021-02-08 | Goochland | Virginia | 51075 | 1107 | 8 |
1007796 | 1007796 | 2021-02-07 | Goochland | Virginia | 51075 | 1104 | 8 |
1004550 | 1004550 | 2021-02-06 | Goochland | Virginia | 51075 | 1098 | 8 |
1001304 | 1001304 | 2021-02-05 | Goochland | Virginia | 51075 | 1088 | 8 |
998058 | 998058 | 2021-02-04 | Goochland | Virginia | 51075 | 1077 | 8 |
994812 | 994812 | 2021-02-03 | Goochland | Virginia | 51075 | 1065 | 8 |
991566 | 991566 | 2021-02-02 | Goochland | Virginia | 51075 | 1050 | 8 |
988320 | 988320 | 2021-02-01 | Goochland | Virginia | 51075 | 1043 | 8 |
985073 | 985073 | 2021-01-31 | Goochland | Virginia | 51075 | 1035 | 8 |
981826 | 981826 | 2021-01-30 | Goochland | Virginia | 51075 | 1028 | 8 |
978580 | 978580 | 2021-01-29 | Goochland | Virginia | 51075 | 1017 | 7 |
975335 | 975335 | 2021-01-28 | Goochland | Virginia | 51075 | 1006 | 7 |
972090 | 972090 | 2021-01-27 | Goochland | Virginia | 51075 | 989 | 7 |
968845 | 968845 | 2021-01-26 | Goochland | Virginia | 51075 | 980 | 7 |
965601 | 965601 | 2021-01-25 | Goochland | Virginia | 51075 | 968 | 7 |
962356 | 962356 | 2021-01-24 | Goochland | Virginia | 51075 | 949 | 7 |
959111 | 959111 | 2021-01-23 | Goochland | Virginia | 51075 | 943 | 7 |
955865 | 955865 | 2021-01-22 | Goochland | Virginia | 51075 | 930 | 7 |
952620 | 952620 | 2021-01-21 | Goochland | Virginia | 51075 | 917 | 7 |
949375 | 949375 | 2021-01-20 | Goochland | Virginia | 51075 | 903 | 7 |
946129 | 946129 | 2021-01-19 | Goochland | Virginia | 51075 | 888 | 7 |
942882 | 942882 | 2021-01-18 | Goochland | Virginia | 51075 | 877 | 7 |
939637 | 939637 | 2021-01-17 | Goochland | Virginia | 51075 | 844 | 7 |
936392 | 936392 | 2021-01-16 | Goochland | Virginia | 51075 | 817 | 7 |
933147 | 933147 | 2021-01-15 | Goochland | Virginia | 51075 | 814 | 7 |
929902 | 929902 | 2021-01-14 | Goochland | Virginia | 51075 | 805 | 7 |
926657 | 926657 | 2021-01-13 | Goochland | Virginia | 51075 | 771 | 7 |
923411 | 923411 | 2021-01-12 | Goochland | Virginia | 51075 | 766 | 7 |
920166 | 920166 | 2021-01-11 | Goochland | Virginia | 51075 | 755 | 7 |
916921 | 916921 | 2021-01-10 | Goochland | Virginia | 51075 | 728 | 7 |
913676 | 913676 | 2021-01-09 | Goochland | Virginia | 51075 | 699 | 7 |
910431 | 910431 | 2021-01-08 | Goochland | Virginia | 51075 | 688 | 7 |
907186 | 907186 | 2021-01-07 | Goochland | Virginia | 51075 | 678 | 7 |
903940 | 903940 | 2021-01-06 | Goochland | Virginia | 51075 | 671 | 7 |
900695 | 900695 | 2021-01-05 | Goochland | Virginia | 51075 | 670 | 8 |
897450 | 897450 | 2021-01-04 | Goochland | Virginia | 51075 | 653 | 7 |
894204 | 894204 | 2021-01-03 | Goochland | Virginia | 51075 | 650 | 7 |
890958 | 890958 | 2021-01-02 | Goochland | Virginia | 51075 | 644 | 7 |
887711 | 887711 | 2021-01-01 | Goochland | Virginia | 51075 | 621 | 7 |
884466 | 884466 | 2020-12-31 | Goochland | Virginia | 51075 | 612 | 7 |
881221 | 881221 | 2020-12-30 | Goochland | Virginia | 51075 | 607 | 7 |
877976 | 877976 | 2020-12-29 | Goochland | Virginia | 51075 | 604 | 7 |
874731 | 874731 | 2020-12-28 | Goochland | Virginia | 51075 | 603 | 7 |
871486 | 871486 | 2020-12-27 | Goochland | Virginia | 51075 | 598 | 7 |
868241 | 868241 | 2020-12-26 | Goochland | Virginia | 51075 | 594 | 7 |
864996 | 864996 | 2020-12-25 | Goochland | Virginia | 51075 | 583 | 7 |
861751 | 861751 | 2020-12-24 | Goochland | Virginia | 51075 | 579 | 7 |
858506 | 858506 | 2020-12-23 | Goochland | Virginia | 51075 | 569 | 7 |
855261 | 855261 | 2020-12-22 | Goochland | Virginia | 51075 | 553 | 7 |
852016 | 852016 | 2020-12-21 | Goochland | Virginia | 51075 | 543 | 7 |
848771 | 848771 | 2020-12-20 | Goochland | Virginia | 51075 | 528 | 7 |
845526 | 845526 | 2020-12-19 | Goochland | Virginia | 51075 | 525 | 7 |
842280 | 842280 | 2020-12-18 | Goochland | Virginia | 51075 | 524 | 7 |
839035 | 839035 | 2020-12-17 | Goochland | Virginia | 51075 | 522 | 7 |
835789 | 835789 | 2020-12-16 | Goochland | Virginia | 51075 | 519 | 7 |
832543 | 832543 | 2020-12-15 | Goochland | Virginia | 51075 | 515 | 7 |
829296 | 829296 | 2020-12-14 | Goochland | Virginia | 51075 | 514 | 7 |
826050 | 826050 | 2020-12-13 | Goochland | Virginia | 51075 | 514 | 7 |
822803 | 822803 | 2020-12-12 | Goochland | Virginia | 51075 | 508 | 7 |
819557 | 819557 | 2020-12-11 | Goochland | Virginia | 51075 | 501 | 7 |
816311 | 816311 | 2020-12-10 | Goochland | Virginia | 51075 | 497 | 7 |
813065 | 813065 | 2020-12-09 | Goochland | Virginia | 51075 | 495 | 7 |
809821 | 809821 | 2020-12-08 | Goochland | Virginia | 51075 | 492 | 7 |
806576 | 806576 | 2020-12-07 | Goochland | Virginia | 51075 | 486 | 7 |
803331 | 803331 | 2020-12-06 | Goochland | Virginia | 51075 | 479 | 7 |
800086 | 800086 | 2020-12-05 | Goochland | Virginia | 51075 | 476 | 7 |
796841 | 796841 | 2020-12-04 | Goochland | Virginia | 51075 | 470 | 7 |
793596 | 793596 | 2020-12-03 | Goochland | Virginia | 51075 | 463 | 7 |
790351 | 790351 | 2020-12-02 | Goochland | Virginia | 51075 | 457 | 7 |
787106 | 787106 | 2020-12-01 | Goochland | Virginia | 51075 | 453 | 7 |
783862 | 783862 | 2020-11-30 | Goochland | Virginia | 51075 | 450 | 7 |
780617 | 780617 | 2020-11-29 | Goochland | Virginia | 51075 | 443 | 7 |
777371 | 777371 | 2020-11-28 | Goochland | Virginia | 51075 | 441 | 7 |
774126 | 774126 | 2020-11-27 | Goochland | Virginia | 51075 | 436 | 7 |
770881 | 770881 | 2020-11-26 | Goochland | Virginia | 51075 | 427 | 7 |
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);