ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Portsmouth city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056526 | 1056526 | 2021-02-22 | Portsmouth city | Virginia | 51740 | 7523 | 130 |
1053280 | 1053280 | 2021-02-21 | Portsmouth city | Virginia | 51740 | 7502 | 128 |
1050033 | 1050033 | 2021-02-20 | Portsmouth city | Virginia | 51740 | 7471 | 126 |
1046786 | 1046786 | 2021-02-19 | Portsmouth city | Virginia | 51740 | 7435 | 125 |
1043541 | 1043541 | 2021-02-18 | Portsmouth city | Virginia | 51740 | 7404 | 125 |
1040296 | 1040296 | 2021-02-17 | Portsmouth city | Virginia | 51740 | 7353 | 123 |
1037051 | 1037051 | 2021-02-16 | Portsmouth city | Virginia | 51740 | 7285 | 108 |
1033806 | 1033806 | 2021-02-15 | Portsmouth city | Virginia | 51740 | 7255 | 108 |
1030560 | 1030560 | 2021-02-14 | Portsmouth city | Virginia | 51740 | 7217 | 108 |
1027313 | 1027313 | 2021-02-13 | Portsmouth city | Virginia | 51740 | 7178 | 107 |
1024068 | 1024068 | 2021-02-12 | Portsmouth city | Virginia | 51740 | 7145 | 107 |
1020823 | 1020823 | 2021-02-11 | Portsmouth city | Virginia | 51740 | 7093 | 107 |
1017578 | 1017578 | 2021-02-10 | Portsmouth city | Virginia | 51740 | 7059 | 99 |
1014333 | 1014333 | 2021-02-09 | Portsmouth city | Virginia | 51740 | 7026 | 99 |
1011088 | 1011088 | 2021-02-08 | Portsmouth city | Virginia | 51740 | 6942 | 99 |
1007842 | 1007842 | 2021-02-07 | Portsmouth city | Virginia | 51740 | 6935 | 99 |
1004596 | 1004596 | 2021-02-06 | Portsmouth city | Virginia | 51740 | 6916 | 99 |
1001350 | 1001350 | 2021-02-05 | Portsmouth city | Virginia | 51740 | 6832 | 99 |
998104 | 998104 | 2021-02-04 | Portsmouth city | Virginia | 51740 | 6785 | 97 |
994858 | 994858 | 2021-02-03 | Portsmouth city | Virginia | 51740 | 6679 | 97 |
991612 | 991612 | 2021-02-02 | Portsmouth city | Virginia | 51740 | 6623 | 97 |
988366 | 988366 | 2021-02-01 | Portsmouth city | Virginia | 51740 | 6580 | 97 |
985119 | 985119 | 2021-01-31 | Portsmouth city | Virginia | 51740 | 6547 | 97 |
981872 | 981872 | 2021-01-30 | Portsmouth city | Virginia | 51740 | 6528 | 97 |
978626 | 978626 | 2021-01-29 | Portsmouth city | Virginia | 51740 | 6488 | 97 |
975381 | 975381 | 2021-01-28 | Portsmouth city | Virginia | 51740 | 6434 | 96 |
972136 | 972136 | 2021-01-27 | Portsmouth city | Virginia | 51740 | 6332 | 96 |
968891 | 968891 | 2021-01-26 | Portsmouth city | Virginia | 51740 | 6269 | 96 |
965647 | 965647 | 2021-01-25 | Portsmouth city | Virginia | 51740 | 6215 | 96 |
962402 | 962402 | 2021-01-24 | Portsmouth city | Virginia | 51740 | 6145 | 96 |
959157 | 959157 | 2021-01-23 | Portsmouth city | Virginia | 51740 | 6115 | 96 |
955911 | 955911 | 2021-01-22 | Portsmouth city | Virginia | 51740 | 6028 | 96 |
952666 | 952666 | 2021-01-21 | Portsmouth city | Virginia | 51740 | 5996 | 96 |
949421 | 949421 | 2021-01-20 | Portsmouth city | Virginia | 51740 | 5954 | 95 |
946175 | 946175 | 2021-01-19 | Portsmouth city | Virginia | 51740 | 5878 | 94 |
942928 | 942928 | 2021-01-18 | Portsmouth city | Virginia | 51740 | 5808 | 94 |
939683 | 939683 | 2021-01-17 | Portsmouth city | Virginia | 51740 | 5716 | 94 |
936438 | 936438 | 2021-01-16 | Portsmouth city | Virginia | 51740 | 5645 | 94 |
933193 | 933193 | 2021-01-15 | Portsmouth city | Virginia | 51740 | 5546 | 90 |
929948 | 929948 | 2021-01-14 | Portsmouth city | Virginia | 51740 | 5521 | 90 |
926703 | 926703 | 2021-01-13 | Portsmouth city | Virginia | 51740 | 5462 | 90 |
923457 | 923457 | 2021-01-12 | Portsmouth city | Virginia | 51740 | 5391 | 90 |
920212 | 920212 | 2021-01-11 | Portsmouth city | Virginia | 51740 | 5340 | 87 |
916967 | 916967 | 2021-01-10 | Portsmouth city | Virginia | 51740 | 5229 | 87 |
913722 | 913722 | 2021-01-09 | Portsmouth city | Virginia | 51740 | 5196 | 87 |
910477 | 910477 | 2021-01-08 | Portsmouth city | Virginia | 51740 | 5075 | 87 |
907232 | 907232 | 2021-01-07 | Portsmouth city | Virginia | 51740 | 4995 | 87 |
903986 | 903986 | 2021-01-06 | Portsmouth city | Virginia | 51740 | 4895 | 86 |
900741 | 900741 | 2021-01-05 | Portsmouth city | Virginia | 51740 | 4820 | 86 |
897496 | 897496 | 2021-01-04 | Portsmouth city | Virginia | 51740 | 4787 | 78 |
894250 | 894250 | 2021-01-03 | Portsmouth city | Virginia | 51740 | 4693 | 78 |
891004 | 891004 | 2021-01-02 | Portsmouth city | Virginia | 51740 | 4608 | 78 |
887757 | 887757 | 2021-01-01 | Portsmouth city | Virginia | 51740 | 4545 | 78 |
884512 | 884512 | 2020-12-31 | Portsmouth city | Virginia | 51740 | 4519 | 78 |
881267 | 881267 | 2020-12-30 | Portsmouth city | Virginia | 51740 | 4421 | 78 |
878022 | 878022 | 2020-12-29 | Portsmouth city | Virginia | 51740 | 4390 | 78 |
874777 | 874777 | 2020-12-28 | Portsmouth city | Virginia | 51740 | 4337 | 77 |
871532 | 871532 | 2020-12-27 | Portsmouth city | Virginia | 51740 | 4295 | 77 |
868287 | 868287 | 2020-12-26 | Portsmouth city | Virginia | 51740 | 4193 | 77 |
865042 | 865042 | 2020-12-25 | Portsmouth city | Virginia | 51740 | 4182 | 76 |
861797 | 861797 | 2020-12-24 | Portsmouth city | Virginia | 51740 | 4128 | 76 |
858552 | 858552 | 2020-12-23 | Portsmouth city | Virginia | 51740 | 4045 | 76 |
855307 | 855307 | 2020-12-22 | Portsmouth city | Virginia | 51740 | 3991 | 75 |
852062 | 852062 | 2020-12-21 | Portsmouth city | Virginia | 51740 | 3947 | 75 |
848817 | 848817 | 2020-12-20 | Portsmouth city | Virginia | 51740 | 3895 | 75 |
845572 | 845572 | 2020-12-19 | Portsmouth city | Virginia | 51740 | 3826 | 75 |
842326 | 842326 | 2020-12-18 | Portsmouth city | Virginia | 51740 | 3760 | 74 |
839081 | 839081 | 2020-12-17 | Portsmouth city | Virginia | 51740 | 3722 | 73 |
835835 | 835835 | 2020-12-16 | Portsmouth city | Virginia | 51740 | 3677 | 73 |
832589 | 832589 | 2020-12-15 | Portsmouth city | Virginia | 51740 | 3642 | 73 |
829342 | 829342 | 2020-12-14 | Portsmouth city | Virginia | 51740 | 3623 | 73 |
826096 | 826096 | 2020-12-13 | Portsmouth city | Virginia | 51740 | 3593 | 73 |
822849 | 822849 | 2020-12-12 | Portsmouth city | Virginia | 51740 | 3546 | 73 |
819603 | 819603 | 2020-12-11 | Portsmouth city | Virginia | 51740 | 3509 | 73 |
816357 | 816357 | 2020-12-10 | Portsmouth city | Virginia | 51740 | 3480 | 73 |
813111 | 813111 | 2020-12-09 | Portsmouth city | Virginia | 51740 | 3435 | 72 |
809867 | 809867 | 2020-12-08 | Portsmouth city | Virginia | 51740 | 3410 | 71 |
806622 | 806622 | 2020-12-07 | Portsmouth city | Virginia | 51740 | 3380 | 71 |
803377 | 803377 | 2020-12-06 | Portsmouth city | Virginia | 51740 | 3339 | 71 |
800132 | 800132 | 2020-12-05 | Portsmouth city | Virginia | 51740 | 3298 | 71 |
796887 | 796887 | 2020-12-04 | Portsmouth city | Virginia | 51740 | 3256 | 71 |
793642 | 793642 | 2020-12-03 | Portsmouth city | Virginia | 51740 | 3246 | 71 |
790397 | 790397 | 2020-12-02 | Portsmouth city | Virginia | 51740 | 3234 | 71 |
787152 | 787152 | 2020-12-01 | Portsmouth city | Virginia | 51740 | 3216 | 71 |
783908 | 783908 | 2020-11-30 | Portsmouth city | Virginia | 51740 | 3202 | 71 |
780663 | 780663 | 2020-11-29 | Portsmouth city | Virginia | 51740 | 3193 | 71 |
777417 | 777417 | 2020-11-28 | Portsmouth city | Virginia | 51740 | 3188 | 71 |
774172 | 774172 | 2020-11-27 | Portsmouth city | Virginia | 51740 | 3170 | 71 |
770927 | 770927 | 2020-11-26 | Portsmouth city | Virginia | 51740 | 3156 | 71 |
767681 | 767681 | 2020-11-25 | Portsmouth city | Virginia | 51740 | 3136 | 71 |
764436 | 764436 | 2020-11-24 | Portsmouth city | Virginia | 51740 | 3128 | 71 |
761191 | 761191 | 2020-11-23 | Portsmouth city | Virginia | 51740 | 3115 | 70 |
757946 | 757946 | 2020-11-22 | Portsmouth city | Virginia | 51740 | 3091 | 70 |
754699 | 754699 | 2020-11-21 | Portsmouth city | Virginia | 51740 | 3067 | 70 |
751453 | 751453 | 2020-11-20 | Portsmouth city | Virginia | 51740 | 3053 | 70 |
748207 | 748207 | 2020-11-19 | Portsmouth city | Virginia | 51740 | 3039 | 70 |
744961 | 744961 | 2020-11-18 | Portsmouth city | Virginia | 51740 | 3031 | 70 |
741714 | 741714 | 2020-11-17 | Portsmouth city | Virginia | 51740 | 3027 | 70 |
738467 | 738467 | 2020-11-16 | Portsmouth city | Virginia | 51740 | 3021 | 70 |
735223 | 735223 | 2020-11-15 | Portsmouth city | Virginia | 51740 | 2997 | 70 |
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);