ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 51109 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092202 | 1092202 | 2021-03-05 | Louisa | Virginia | 51109 | 1690 | 25 |
1088956 | 1088956 | 2021-03-04 | Louisa | Virginia | 51109 | 1693 | 24 |
1085711 | 1085711 | 2021-03-03 | Louisa | Virginia | 51109 | 1692 | 24 |
1082465 | 1082465 | 2021-03-02 | Louisa | Virginia | 51109 | 1691 | 22 |
1079219 | 1079219 | 2021-03-01 | Louisa | Virginia | 51109 | 1691 | 22 |
1075974 | 1075974 | 2021-02-28 | Louisa | Virginia | 51109 | 1687 | 21 |
1072728 | 1072728 | 2021-02-27 | Louisa | Virginia | 51109 | 1682 | 20 |
1069482 | 1069482 | 2021-02-26 | Louisa | Virginia | 51109 | 1682 | 20 |
1066237 | 1066237 | 2021-02-25 | Louisa | Virginia | 51109 | 1675 | 16 |
1062992 | 1062992 | 2021-02-24 | Louisa | Virginia | 51109 | 1672 | 15 |
1059747 | 1059747 | 2021-02-23 | Louisa | Virginia | 51109 | 1671 | 14 |
1056501 | 1056501 | 2021-02-22 | Louisa | Virginia | 51109 | 1666 | 13 |
1053255 | 1053255 | 2021-02-21 | Louisa | Virginia | 51109 | 1662 | 13 |
1050008 | 1050008 | 2021-02-20 | Louisa | Virginia | 51109 | 1660 | 13 |
1046761 | 1046761 | 2021-02-19 | Louisa | Virginia | 51109 | 1654 | 13 |
1043516 | 1043516 | 2021-02-18 | Louisa | Virginia | 51109 | 1641 | 13 |
1040271 | 1040271 | 2021-02-17 | Louisa | Virginia | 51109 | 1638 | 13 |
1037026 | 1037026 | 2021-02-16 | Louisa | Virginia | 51109 | 1631 | 13 |
1033781 | 1033781 | 2021-02-15 | Louisa | Virginia | 51109 | 1631 | 13 |
1030535 | 1030535 | 2021-02-14 | Louisa | Virginia | 51109 | 1629 | 13 |
1027288 | 1027288 | 2021-02-13 | Louisa | Virginia | 51109 | 1627 | 13 |
1024043 | 1024043 | 2021-02-12 | Louisa | Virginia | 51109 | 1624 | 13 |
1020798 | 1020798 | 2021-02-11 | Louisa | Virginia | 51109 | 1625 | 13 |
1017553 | 1017553 | 2021-02-10 | Louisa | Virginia | 51109 | 1620 | 13 |
1014308 | 1014308 | 2021-02-09 | Louisa | Virginia | 51109 | 1617 | 13 |
1011063 | 1011063 | 2021-02-08 | Louisa | Virginia | 51109 | 1610 | 13 |
1007817 | 1007817 | 2021-02-07 | Louisa | Virginia | 51109 | 1601 | 13 |
1004571 | 1004571 | 2021-02-06 | Louisa | Virginia | 51109 | 1591 | 13 |
1001325 | 1001325 | 2021-02-05 | Louisa | Virginia | 51109 | 1571 | 13 |
998079 | 998079 | 2021-02-04 | Louisa | Virginia | 51109 | 1547 | 12 |
994833 | 994833 | 2021-02-03 | Louisa | Virginia | 51109 | 1542 | 12 |
991587 | 991587 | 2021-02-02 | Louisa | Virginia | 51109 | 1535 | 12 |
988341 | 988341 | 2021-02-01 | Louisa | Virginia | 51109 | 1529 | 12 |
985094 | 985094 | 2021-01-31 | Louisa | Virginia | 51109 | 1502 | 12 |
981847 | 981847 | 2021-01-30 | Louisa | Virginia | 51109 | 1496 | 12 |
978601 | 978601 | 2021-01-29 | Louisa | Virginia | 51109 | 1480 | 12 |
975356 | 975356 | 2021-01-28 | Louisa | Virginia | 51109 | 1462 | 12 |
972111 | 972111 | 2021-01-27 | Louisa | Virginia | 51109 | 1430 | 11 |
968866 | 968866 | 2021-01-26 | Louisa | Virginia | 51109 | 1417 | 11 |
965622 | 965622 | 2021-01-25 | Louisa | Virginia | 51109 | 1403 | 11 |
962377 | 962377 | 2021-01-24 | Louisa | Virginia | 51109 | 1378 | 11 |
959132 | 959132 | 2021-01-23 | Louisa | Virginia | 51109 | 1358 | 11 |
955886 | 955886 | 2021-01-22 | Louisa | Virginia | 51109 | 1341 | 11 |
952641 | 952641 | 2021-01-21 | Louisa | Virginia | 51109 | 1329 | 11 |
949396 | 949396 | 2021-01-20 | Louisa | Virginia | 51109 | 1313 | 11 |
946150 | 946150 | 2021-01-19 | Louisa | Virginia | 51109 | 1299 | 11 |
942903 | 942903 | 2021-01-18 | Louisa | Virginia | 51109 | 1292 | 11 |
939658 | 939658 | 2021-01-17 | Louisa | Virginia | 51109 | 1269 | 11 |
936413 | 936413 | 2021-01-16 | Louisa | Virginia | 51109 | 1242 | 11 |
933168 | 933168 | 2021-01-15 | Louisa | Virginia | 51109 | 1212 | 11 |
929923 | 929923 | 2021-01-14 | Louisa | Virginia | 51109 | 1198 | 11 |
926678 | 926678 | 2021-01-13 | Louisa | Virginia | 51109 | 1179 | 11 |
923432 | 923432 | 2021-01-12 | Louisa | Virginia | 51109 | 1159 | 11 |
920187 | 920187 | 2021-01-11 | Louisa | Virginia | 51109 | 1141 | 11 |
916942 | 916942 | 2021-01-10 | Louisa | Virginia | 51109 | 1107 | 11 |
913697 | 913697 | 2021-01-09 | Louisa | Virginia | 51109 | 1077 | 11 |
910452 | 910452 | 2021-01-08 | Louisa | Virginia | 51109 | 1054 | 11 |
907207 | 907207 | 2021-01-07 | Louisa | Virginia | 51109 | 1033 | 11 |
903961 | 903961 | 2021-01-06 | Louisa | Virginia | 51109 | 1018 | 11 |
900716 | 900716 | 2021-01-05 | Louisa | Virginia | 51109 | 981 | 11 |
897471 | 897471 | 2021-01-04 | Louisa | Virginia | 51109 | 972 | 10 |
894225 | 894225 | 2021-01-03 | Louisa | Virginia | 51109 | 969 | 10 |
890979 | 890979 | 2021-01-02 | Louisa | Virginia | 51109 | 951 | 10 |
887732 | 887732 | 2021-01-01 | Louisa | Virginia | 51109 | 931 | 10 |
884487 | 884487 | 2020-12-31 | Louisa | Virginia | 51109 | 902 | 9 |
881242 | 881242 | 2020-12-30 | Louisa | Virginia | 51109 | 883 | 9 |
877997 | 877997 | 2020-12-29 | Louisa | Virginia | 51109 | 870 | 9 |
874752 | 874752 | 2020-12-28 | Louisa | Virginia | 51109 | 857 | 9 |
871507 | 871507 | 2020-12-27 | Louisa | Virginia | 51109 | 848 | 9 |
868262 | 868262 | 2020-12-26 | Louisa | Virginia | 51109 | 822 | 9 |
865017 | 865017 | 2020-12-25 | Louisa | Virginia | 51109 | 822 | 9 |
861772 | 861772 | 2020-12-24 | Louisa | Virginia | 51109 | 811 | 9 |
858527 | 858527 | 2020-12-23 | Louisa | Virginia | 51109 | 783 | 9 |
855282 | 855282 | 2020-12-22 | Louisa | Virginia | 51109 | 768 | 9 |
852037 | 852037 | 2020-12-21 | Louisa | Virginia | 51109 | 754 | 9 |
848792 | 848792 | 2020-12-20 | Louisa | Virginia | 51109 | 742 | 9 |
845547 | 845547 | 2020-12-19 | Louisa | Virginia | 51109 | 722 | 9 |
842301 | 842301 | 2020-12-18 | Louisa | Virginia | 51109 | 714 | 9 |
839056 | 839056 | 2020-12-17 | Louisa | Virginia | 51109 | 709 | 9 |
835810 | 835810 | 2020-12-16 | Louisa | Virginia | 51109 | 691 | 9 |
832564 | 832564 | 2020-12-15 | Louisa | Virginia | 51109 | 680 | 9 |
829317 | 829317 | 2020-12-14 | Louisa | Virginia | 51109 | 678 | 9 |
826071 | 826071 | 2020-12-13 | Louisa | Virginia | 51109 | 663 | 9 |
822824 | 822824 | 2020-12-12 | Louisa | Virginia | 51109 | 657 | 9 |
819578 | 819578 | 2020-12-11 | Louisa | Virginia | 51109 | 647 | 9 |
816332 | 816332 | 2020-12-10 | Louisa | Virginia | 51109 | 641 | 9 |
813086 | 813086 | 2020-12-09 | Louisa | Virginia | 51109 | 624 | 8 |
809842 | 809842 | 2020-12-08 | Louisa | Virginia | 51109 | 618 | 8 |
806597 | 806597 | 2020-12-07 | Louisa | Virginia | 51109 | 609 | 8 |
803352 | 803352 | 2020-12-06 | Louisa | Virginia | 51109 | 589 | 8 |
800107 | 800107 | 2020-12-05 | Louisa | Virginia | 51109 | 571 | 8 |
796862 | 796862 | 2020-12-04 | Louisa | Virginia | 51109 | 552 | 8 |
793617 | 793617 | 2020-12-03 | Louisa | Virginia | 51109 | 547 | 8 |
790372 | 790372 | 2020-12-02 | Louisa | Virginia | 51109 | 545 | 8 |
787127 | 787127 | 2020-12-01 | Louisa | Virginia | 51109 | 538 | 8 |
783883 | 783883 | 2020-11-30 | Louisa | Virginia | 51109 | 532 | 8 |
780638 | 780638 | 2020-11-29 | Louisa | Virginia | 51109 | 529 | 8 |
777392 | 777392 | 2020-11-28 | Louisa | Virginia | 51109 | 523 | 8 |
774147 | 774147 | 2020-11-27 | Louisa | Virginia | 51109 | 515 | 8 |
770902 | 770902 | 2020-11-26 | Louisa | Virginia | 51109 | 508 | 8 |
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);