ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Accomack" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092131 | 1092131 | 2021-03-05 | Accomack | Virginia | 51001 | 2619 | 35 |
1088885 | 1088885 | 2021-03-04 | Accomack | Virginia | 51001 | 2609 | 35 |
1085640 | 1085640 | 2021-03-03 | Accomack | Virginia | 51001 | 2607 | 35 |
1082394 | 1082394 | 2021-03-02 | Accomack | Virginia | 51001 | 2604 | 35 |
1079148 | 1079148 | 2021-03-01 | Accomack | Virginia | 51001 | 2601 | 35 |
1075903 | 1075903 | 2021-02-28 | Accomack | Virginia | 51001 | 2602 | 35 |
1072657 | 1072657 | 2021-02-27 | Accomack | Virginia | 51001 | 2596 | 35 |
1069411 | 1069411 | 2021-02-26 | Accomack | Virginia | 51001 | 2588 | 35 |
1066166 | 1066166 | 2021-02-25 | Accomack | Virginia | 51001 | 2580 | 35 |
1062921 | 1062921 | 2021-02-24 | Accomack | Virginia | 51001 | 2575 | 35 |
1059676 | 1059676 | 2021-02-23 | Accomack | Virginia | 51001 | 2572 | 35 |
1056430 | 1056430 | 2021-02-22 | Accomack | Virginia | 51001 | 2565 | 35 |
1053184 | 1053184 | 2021-02-21 | Accomack | Virginia | 51001 | 2559 | 35 |
1049937 | 1049937 | 2021-02-20 | Accomack | Virginia | 51001 | 2552 | 35 |
1046690 | 1046690 | 2021-02-19 | Accomack | Virginia | 51001 | 2545 | 35 |
1043445 | 1043445 | 2021-02-18 | Accomack | Virginia | 51001 | 2538 | 35 |
1040200 | 1040200 | 2021-02-17 | Accomack | Virginia | 51001 | 2529 | 34 |
1036955 | 1036955 | 2021-02-16 | Accomack | Virginia | 51001 | 2527 | 34 |
1033710 | 1033710 | 2021-02-15 | Accomack | Virginia | 51001 | 2523 | 33 |
1030464 | 1030464 | 2021-02-14 | Accomack | Virginia | 51001 | 2519 | 33 |
1027217 | 1027217 | 2021-02-13 | Accomack | Virginia | 51001 | 2516 | 33 |
1023972 | 1023972 | 2021-02-12 | Accomack | Virginia | 51001 | 2506 | 33 |
1020727 | 1020727 | 2021-02-11 | Accomack | Virginia | 51001 | 2485 | 33 |
1017482 | 1017482 | 2021-02-10 | Accomack | Virginia | 51001 | 2473 | 33 |
1014237 | 1014237 | 2021-02-09 | Accomack | Virginia | 51001 | 2467 | 33 |
1010992 | 1010992 | 2021-02-08 | Accomack | Virginia | 51001 | 2461 | 33 |
1007746 | 1007746 | 2021-02-07 | Accomack | Virginia | 51001 | 2457 | 33 |
1004500 | 1004500 | 2021-02-06 | Accomack | Virginia | 51001 | 2448 | 33 |
1001254 | 1001254 | 2021-02-05 | Accomack | Virginia | 51001 | 2428 | 32 |
998008 | 998008 | 2021-02-04 | Accomack | Virginia | 51001 | 2403 | 32 |
994762 | 994762 | 2021-02-03 | Accomack | Virginia | 51001 | 2391 | 32 |
991516 | 991516 | 2021-02-02 | Accomack | Virginia | 51001 | 2388 | 32 |
988270 | 988270 | 2021-02-01 | Accomack | Virginia | 51001 | 2365 | 31 |
985023 | 985023 | 2021-01-31 | Accomack | Virginia | 51001 | 2342 | 31 |
981776 | 981776 | 2021-01-30 | Accomack | Virginia | 51001 | 2333 | 31 |
978530 | 978530 | 2021-01-29 | Accomack | Virginia | 51001 | 2324 | 31 |
975285 | 975285 | 2021-01-28 | Accomack | Virginia | 51001 | 2301 | 31 |
972040 | 972040 | 2021-01-27 | Accomack | Virginia | 51001 | 2295 | 31 |
968795 | 968795 | 2021-01-26 | Accomack | Virginia | 51001 | 2290 | 31 |
965551 | 965551 | 2021-01-25 | Accomack | Virginia | 51001 | 2272 | 31 |
962306 | 962306 | 2021-01-24 | Accomack | Virginia | 51001 | 2249 | 31 |
959061 | 959061 | 2021-01-23 | Accomack | Virginia | 51001 | 2228 | 31 |
955815 | 955815 | 2021-01-22 | Accomack | Virginia | 51001 | 2206 | 31 |
952570 | 952570 | 2021-01-21 | Accomack | Virginia | 51001 | 2198 | 31 |
949325 | 949325 | 2021-01-20 | Accomack | Virginia | 51001 | 2187 | 31 |
946079 | 946079 | 2021-01-19 | Accomack | Virginia | 51001 | 2176 | 31 |
942832 | 942832 | 2021-01-18 | Accomack | Virginia | 51001 | 2168 | 31 |
939587 | 939587 | 2021-01-17 | Accomack | Virginia | 51001 | 2140 | 31 |
936342 | 936342 | 2021-01-16 | Accomack | Virginia | 51001 | 2125 | 31 |
933097 | 933097 | 2021-01-15 | Accomack | Virginia | 51001 | 2100 | 31 |
929852 | 929852 | 2021-01-14 | Accomack | Virginia | 51001 | 2091 | 31 |
926607 | 926607 | 2021-01-13 | Accomack | Virginia | 51001 | 2056 | 31 |
923361 | 923361 | 2021-01-12 | Accomack | Virginia | 51001 | 2056 | 30 |
920116 | 920116 | 2021-01-11 | Accomack | Virginia | 51001 | 2037 | 30 |
916871 | 916871 | 2021-01-10 | Accomack | Virginia | 51001 | 2005 | 30 |
913626 | 913626 | 2021-01-09 | Accomack | Virginia | 51001 | 1928 | 30 |
910381 | 910381 | 2021-01-08 | Accomack | Virginia | 51001 | 1890 | 30 |
907136 | 907136 | 2021-01-07 | Accomack | Virginia | 51001 | 1855 | 30 |
903890 | 903890 | 2021-01-06 | Accomack | Virginia | 51001 | 1824 | 29 |
900645 | 900645 | 2021-01-05 | Accomack | Virginia | 51001 | 1814 | 27 |
897400 | 897400 | 2021-01-04 | Accomack | Virginia | 51001 | 1789 | 27 |
894154 | 894154 | 2021-01-03 | Accomack | Virginia | 51001 | 1760 | 27 |
890908 | 890908 | 2021-01-02 | Accomack | Virginia | 51001 | 1730 | 27 |
887661 | 887661 | 2021-01-01 | Accomack | Virginia | 51001 | 1709 | 27 |
884416 | 884416 | 2020-12-31 | Accomack | Virginia | 51001 | 1698 | 27 |
881171 | 881171 | 2020-12-30 | Accomack | Virginia | 51001 | 1692 | 27 |
877926 | 877926 | 2020-12-29 | Accomack | Virginia | 51001 | 1672 | 25 |
874681 | 874681 | 2020-12-28 | Accomack | Virginia | 51001 | 1665 | 25 |
871436 | 871436 | 2020-12-27 | Accomack | Virginia | 51001 | 1657 | 25 |
868191 | 868191 | 2020-12-26 | Accomack | Virginia | 51001 | 1633 | 25 |
864946 | 864946 | 2020-12-25 | Accomack | Virginia | 51001 | 1633 | 25 |
861701 | 861701 | 2020-12-24 | Accomack | Virginia | 51001 | 1625 | 25 |
858456 | 858456 | 2020-12-23 | Accomack | Virginia | 51001 | 1604 | 25 |
855211 | 855211 | 2020-12-22 | Accomack | Virginia | 51001 | 1588 | 25 |
851966 | 851966 | 2020-12-21 | Accomack | Virginia | 51001 | 1585 | 25 |
848721 | 848721 | 2020-12-20 | Accomack | Virginia | 51001 | 1579 | 25 |
845476 | 845476 | 2020-12-19 | Accomack | Virginia | 51001 | 1564 | 25 |
842230 | 842230 | 2020-12-18 | Accomack | Virginia | 51001 | 1553 | 23 |
838985 | 838985 | 2020-12-17 | Accomack | Virginia | 51001 | 1545 | 23 |
835739 | 835739 | 2020-12-16 | Accomack | Virginia | 51001 | 1533 | 22 |
832493 | 832493 | 2020-12-15 | Accomack | Virginia | 51001 | 1524 | 21 |
829246 | 829246 | 2020-12-14 | Accomack | Virginia | 51001 | 1499 | 21 |
826000 | 826000 | 2020-12-13 | Accomack | Virginia | 51001 | 1494 | 21 |
822753 | 822753 | 2020-12-12 | Accomack | Virginia | 51001 | 1486 | 21 |
819507 | 819507 | 2020-12-11 | Accomack | Virginia | 51001 | 1466 | 21 |
816261 | 816261 | 2020-12-10 | Accomack | Virginia | 51001 | 1448 | 21 |
813015 | 813015 | 2020-12-09 | Accomack | Virginia | 51001 | 1438 | 21 |
809771 | 809771 | 2020-12-08 | Accomack | Virginia | 51001 | 1416 | 21 |
806526 | 806526 | 2020-12-07 | Accomack | Virginia | 51001 | 1408 | 21 |
803281 | 803281 | 2020-12-06 | Accomack | Virginia | 51001 | 1390 | 21 |
800036 | 800036 | 2020-12-05 | Accomack | Virginia | 51001 | 1374 | 21 |
796791 | 796791 | 2020-12-04 | Accomack | Virginia | 51001 | 1367 | 21 |
793546 | 793546 | 2020-12-03 | Accomack | Virginia | 51001 | 1363 | 21 |
790301 | 790301 | 2020-12-02 | Accomack | Virginia | 51001 | 1359 | 21 |
787056 | 787056 | 2020-12-01 | Accomack | Virginia | 51001 | 1357 | 21 |
783812 | 783812 | 2020-11-30 | Accomack | Virginia | 51001 | 1346 | 21 |
780567 | 780567 | 2020-11-29 | Accomack | Virginia | 51001 | 1345 | 21 |
777321 | 777321 | 2020-11-28 | Accomack | Virginia | 51001 | 1340 | 21 |
774076 | 774076 | 2020-11-27 | Accomack | Virginia | 51001 | 1330 | 21 |
770831 | 770831 | 2020-11-26 | Accomack | Virginia | 51001 | 1324 | 21 |
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);