ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 51800 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095496 | 1095496 | 2021-03-06 | Suffolk city | Virginia | 51800 | 7006 | 165 |
1092250 | 1092250 | 2021-03-05 | Suffolk city | Virginia | 51800 | 6995 | 163 |
1089004 | 1089004 | 2021-03-04 | Suffolk city | Virginia | 51800 | 6974 | 161 |
1085759 | 1085759 | 2021-03-03 | Suffolk city | Virginia | 51800 | 6963 | 159 |
1082513 | 1082513 | 2021-03-02 | Suffolk city | Virginia | 51800 | 6939 | 156 |
1079267 | 1079267 | 2021-03-01 | Suffolk city | Virginia | 51800 | 6909 | 151 |
1076022 | 1076022 | 2021-02-28 | Suffolk city | Virginia | 51800 | 6901 | 151 |
1072776 | 1072776 | 2021-02-27 | Suffolk city | Virginia | 51800 | 6876 | 150 |
1069530 | 1069530 | 2021-02-26 | Suffolk city | Virginia | 51800 | 6860 | 150 |
1066285 | 1066285 | 2021-02-25 | Suffolk city | Virginia | 51800 | 6841 | 150 |
1063040 | 1063040 | 2021-02-24 | Suffolk city | Virginia | 51800 | 6802 | 145 |
1059795 | 1059795 | 2021-02-23 | Suffolk city | Virginia | 51800 | 6776 | 140 |
1056549 | 1056549 | 2021-02-22 | Suffolk city | Virginia | 51800 | 6759 | 134 |
1053303 | 1053303 | 2021-02-21 | Suffolk city | Virginia | 51800 | 6741 | 133 |
1050056 | 1050056 | 2021-02-20 | Suffolk city | Virginia | 51800 | 6703 | 130 |
1046809 | 1046809 | 2021-02-19 | Suffolk city | Virginia | 51800 | 6671 | 129 |
1043564 | 1043564 | 2021-02-18 | Suffolk city | Virginia | 51800 | 6649 | 129 |
1040319 | 1040319 | 2021-02-17 | Suffolk city | Virginia | 51800 | 6606 | 128 |
1037074 | 1037074 | 2021-02-16 | Suffolk city | Virginia | 51800 | 6585 | 127 |
1033829 | 1033829 | 2021-02-15 | Suffolk city | Virginia | 51800 | 6558 | 127 |
1030583 | 1030583 | 2021-02-14 | Suffolk city | Virginia | 51800 | 6523 | 124 |
1027336 | 1027336 | 2021-02-13 | Suffolk city | Virginia | 51800 | 6489 | 120 |
1024091 | 1024091 | 2021-02-12 | Suffolk city | Virginia | 51800 | 6443 | 119 |
1020846 | 1020846 | 2021-02-11 | Suffolk city | Virginia | 51800 | 6406 | 119 |
1017601 | 1017601 | 2021-02-10 | Suffolk city | Virginia | 51800 | 6356 | 119 |
1014356 | 1014356 | 2021-02-09 | Suffolk city | Virginia | 51800 | 6312 | 120 |
1011111 | 1011111 | 2021-02-08 | Suffolk city | Virginia | 51800 | 6237 | 118 |
1007865 | 1007865 | 2021-02-07 | Suffolk city | Virginia | 51800 | 6220 | 117 |
1004619 | 1004619 | 2021-02-06 | Suffolk city | Virginia | 51800 | 6158 | 116 |
1001373 | 1001373 | 2021-02-05 | Suffolk city | Virginia | 51800 | 6096 | 115 |
998127 | 998127 | 2021-02-04 | Suffolk city | Virginia | 51800 | 6044 | 113 |
994881 | 994881 | 2021-02-03 | Suffolk city | Virginia | 51800 | 6011 | 113 |
991635 | 991635 | 2021-02-02 | Suffolk city | Virginia | 51800 | 5952 | 113 |
988389 | 988389 | 2021-02-01 | Suffolk city | Virginia | 51800 | 5865 | 112 |
985142 | 985142 | 2021-01-31 | Suffolk city | Virginia | 51800 | 5810 | 112 |
981895 | 981895 | 2021-01-30 | Suffolk city | Virginia | 51800 | 5778 | 112 |
978649 | 978649 | 2021-01-29 | Suffolk city | Virginia | 51800 | 5714 | 110 |
975404 | 975404 | 2021-01-28 | Suffolk city | Virginia | 51800 | 5620 | 109 |
972159 | 972159 | 2021-01-27 | Suffolk city | Virginia | 51800 | 5531 | 109 |
968914 | 968914 | 2021-01-26 | Suffolk city | Virginia | 51800 | 5454 | 108 |
965670 | 965670 | 2021-01-25 | Suffolk city | Virginia | 51800 | 5390 | 104 |
962425 | 962425 | 2021-01-24 | Suffolk city | Virginia | 51800 | 5328 | 104 |
959180 | 959180 | 2021-01-23 | Suffolk city | Virginia | 51800 | 5288 | 103 |
955934 | 955934 | 2021-01-22 | Suffolk city | Virginia | 51800 | 5201 | 103 |
952689 | 952689 | 2021-01-21 | Suffolk city | Virginia | 51800 | 5152 | 102 |
949444 | 949444 | 2021-01-20 | Suffolk city | Virginia | 51800 | 5116 | 101 |
946198 | 946198 | 2021-01-19 | Suffolk city | Virginia | 51800 | 5030 | 101 |
942951 | 942951 | 2021-01-18 | Suffolk city | Virginia | 51800 | 4956 | 100 |
939706 | 939706 | 2021-01-17 | Suffolk city | Virginia | 51800 | 4890 | 100 |
936461 | 936461 | 2021-01-16 | Suffolk city | Virginia | 51800 | 4800 | 100 |
933216 | 933216 | 2021-01-15 | Suffolk city | Virginia | 51800 | 4700 | 100 |
929971 | 929971 | 2021-01-14 | Suffolk city | Virginia | 51800 | 4638 | 101 |
926726 | 926726 | 2021-01-13 | Suffolk city | Virginia | 51800 | 4603 | 100 |
923480 | 923480 | 2021-01-12 | Suffolk city | Virginia | 51800 | 4588 | 100 |
920235 | 920235 | 2021-01-11 | Suffolk city | Virginia | 51800 | 4560 | 100 |
916990 | 916990 | 2021-01-10 | Suffolk city | Virginia | 51800 | 4510 | 94 |
913745 | 913745 | 2021-01-09 | Suffolk city | Virginia | 51800 | 4460 | 94 |
910500 | 910500 | 2021-01-08 | Suffolk city | Virginia | 51800 | 4395 | 94 |
907255 | 907255 | 2021-01-07 | Suffolk city | Virginia | 51800 | 4335 | 93 |
904009 | 904009 | 2021-01-06 | Suffolk city | Virginia | 51800 | 4282 | 91 |
900764 | 900764 | 2021-01-05 | Suffolk city | Virginia | 51800 | 4246 | 91 |
897519 | 897519 | 2021-01-04 | Suffolk city | Virginia | 51800 | 4214 | 90 |
894273 | 894273 | 2021-01-03 | Suffolk city | Virginia | 51800 | 4148 | 90 |
891027 | 891027 | 2021-01-02 | Suffolk city | Virginia | 51800 | 4059 | 90 |
887780 | 887780 | 2021-01-01 | Suffolk city | Virginia | 51800 | 4043 | 90 |
884535 | 884535 | 2020-12-31 | Suffolk city | Virginia | 51800 | 3987 | 90 |
881290 | 881290 | 2020-12-30 | Suffolk city | Virginia | 51800 | 3914 | 90 |
878045 | 878045 | 2020-12-29 | Suffolk city | Virginia | 51800 | 3890 | 89 |
874800 | 874800 | 2020-12-28 | Suffolk city | Virginia | 51800 | 3869 | 89 |
871555 | 871555 | 2020-12-27 | Suffolk city | Virginia | 51800 | 3841 | 89 |
868310 | 868310 | 2020-12-26 | Suffolk city | Virginia | 51800 | 3784 | 89 |
865065 | 865065 | 2020-12-25 | Suffolk city | Virginia | 51800 | 3781 | 89 |
861820 | 861820 | 2020-12-24 | Suffolk city | Virginia | 51800 | 3725 | 89 |
858575 | 858575 | 2020-12-23 | Suffolk city | Virginia | 51800 | 3635 | 89 |
855330 | 855330 | 2020-12-22 | Suffolk city | Virginia | 51800 | 3581 | 89 |
852085 | 852085 | 2020-12-21 | Suffolk city | Virginia | 51800 | 3552 | 89 |
848840 | 848840 | 2020-12-20 | Suffolk city | Virginia | 51800 | 3508 | 87 |
845595 | 845595 | 2020-12-19 | Suffolk city | Virginia | 51800 | 3423 | 87 |
842349 | 842349 | 2020-12-18 | Suffolk city | Virginia | 51800 | 3379 | 87 |
839104 | 839104 | 2020-12-17 | Suffolk city | Virginia | 51800 | 3354 | 87 |
835858 | 835858 | 2020-12-16 | Suffolk city | Virginia | 51800 | 3312 | 87 |
832612 | 832612 | 2020-12-15 | Suffolk city | Virginia | 51800 | 3287 | 84 |
829365 | 829365 | 2020-12-14 | Suffolk city | Virginia | 51800 | 3257 | 83 |
826119 | 826119 | 2020-12-13 | Suffolk city | Virginia | 51800 | 3211 | 83 |
822872 | 822872 | 2020-12-12 | Suffolk city | Virginia | 51800 | 3155 | 83 |
819626 | 819626 | 2020-12-11 | Suffolk city | Virginia | 51800 | 3120 | 83 |
816380 | 816380 | 2020-12-10 | Suffolk city | Virginia | 51800 | 3075 | 83 |
813134 | 813134 | 2020-12-09 | Suffolk city | Virginia | 51800 | 3022 | 83 |
809890 | 809890 | 2020-12-08 | Suffolk city | Virginia | 51800 | 2986 | 82 |
806645 | 806645 | 2020-12-07 | Suffolk city | Virginia | 51800 | 2965 | 80 |
803400 | 803400 | 2020-12-06 | Suffolk city | Virginia | 51800 | 2916 | 80 |
800155 | 800155 | 2020-12-05 | Suffolk city | Virginia | 51800 | 2867 | 80 |
796910 | 796910 | 2020-12-04 | Suffolk city | Virginia | 51800 | 2836 | 80 |
793665 | 793665 | 2020-12-03 | Suffolk city | Virginia | 51800 | 2812 | 80 |
790420 | 790420 | 2020-12-02 | Suffolk city | Virginia | 51800 | 2803 | 80 |
787175 | 787175 | 2020-12-01 | Suffolk city | Virginia | 51800 | 2776 | 80 |
783931 | 783931 | 2020-11-30 | Suffolk city | Virginia | 51800 | 2767 | 80 |
780686 | 780686 | 2020-11-29 | Suffolk city | Virginia | 51800 | 2762 | 80 |
777440 | 777440 | 2020-11-28 | Suffolk city | Virginia | 51800 | 2755 | 80 |
774195 | 774195 | 2020-11-27 | Suffolk city | Virginia | 51800 | 2715 | 80 |
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);