ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Norfolk 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 |
---|---|---|---|---|---|---|---|
1092216 | 1092216 | 2021-03-05 | Norfolk city | Virginia | 51710 | 15079 | 209 |
1088970 | 1088970 | 2021-03-04 | Norfolk city | Virginia | 51710 | 15049 | 205 |
1085725 | 1085725 | 2021-03-03 | Norfolk city | Virginia | 51710 | 15019 | 205 |
1082479 | 1082479 | 2021-03-02 | Norfolk city | Virginia | 51710 | 14970 | 196 |
1079233 | 1079233 | 2021-03-01 | Norfolk city | Virginia | 51710 | 14935 | 195 |
1075988 | 1075988 | 2021-02-28 | Norfolk city | Virginia | 51710 | 14898 | 189 |
1072742 | 1072742 | 2021-02-27 | Norfolk city | Virginia | 51710 | 14838 | 189 |
1069496 | 1069496 | 2021-02-26 | Norfolk city | Virginia | 51710 | 14780 | 183 |
1066251 | 1066251 | 2021-02-25 | Norfolk city | Virginia | 51710 | 14742 | 175 |
1063006 | 1063006 | 2021-02-24 | Norfolk city | Virginia | 51710 | 14686 | 168 |
1059761 | 1059761 | 2021-02-23 | Norfolk city | Virginia | 51710 | 14605 | 166 |
1056515 | 1056515 | 2021-02-22 | Norfolk city | Virginia | 51710 | 14564 | 164 |
1053269 | 1053269 | 2021-02-21 | Norfolk city | Virginia | 51710 | 14532 | 162 |
1050022 | 1050022 | 2021-02-20 | Norfolk city | Virginia | 51710 | 14456 | 160 |
1046775 | 1046775 | 2021-02-19 | Norfolk city | Virginia | 51710 | 14394 | 158 |
1043530 | 1043530 | 2021-02-18 | Norfolk city | Virginia | 51710 | 14311 | 153 |
1040285 | 1040285 | 2021-02-17 | Norfolk city | Virginia | 51710 | 14233 | 153 |
1037040 | 1037040 | 2021-02-16 | Norfolk city | Virginia | 51710 | 14174 | 153 |
1033795 | 1033795 | 2021-02-15 | Norfolk city | Virginia | 51710 | 14130 | 153 |
1030549 | 1030549 | 2021-02-14 | Norfolk city | Virginia | 51710 | 14081 | 153 |
1027302 | 1027302 | 2021-02-13 | Norfolk city | Virginia | 51710 | 13959 | 153 |
1024057 | 1024057 | 2021-02-12 | Norfolk city | Virginia | 51710 | 13878 | 149 |
1020812 | 1020812 | 2021-02-11 | Norfolk city | Virginia | 51710 | 13774 | 149 |
1017567 | 1017567 | 2021-02-10 | Norfolk city | Virginia | 51710 | 13693 | 149 |
1014322 | 1014322 | 2021-02-09 | Norfolk city | Virginia | 51710 | 13623 | 149 |
1011077 | 1011077 | 2021-02-08 | Norfolk city | Virginia | 51710 | 13564 | 149 |
1007831 | 1007831 | 2021-02-07 | Norfolk city | Virginia | 51710 | 13495 | 149 |
1004585 | 1004585 | 2021-02-06 | Norfolk city | Virginia | 51710 | 13437 | 149 |
1001339 | 1001339 | 2021-02-05 | Norfolk city | Virginia | 51710 | 13297 | 148 |
998093 | 998093 | 2021-02-04 | Norfolk city | Virginia | 51710 | 13145 | 147 |
994847 | 994847 | 2021-02-03 | Norfolk city | Virginia | 51710 | 13057 | 145 |
991601 | 991601 | 2021-02-02 | Norfolk city | Virginia | 51710 | 12960 | 142 |
988355 | 988355 | 2021-02-01 | Norfolk city | Virginia | 51710 | 12906 | 142 |
985108 | 985108 | 2021-01-31 | Norfolk city | Virginia | 51710 | 12850 | 142 |
981861 | 981861 | 2021-01-30 | Norfolk city | Virginia | 51710 | 12775 | 142 |
978615 | 978615 | 2021-01-29 | Norfolk city | Virginia | 51710 | 12667 | 141 |
975370 | 975370 | 2021-01-28 | Norfolk city | Virginia | 51710 | 12549 | 141 |
972125 | 972125 | 2021-01-27 | Norfolk city | Virginia | 51710 | 12400 | 139 |
968880 | 968880 | 2021-01-26 | Norfolk city | Virginia | 51710 | 12268 | 136 |
965636 | 965636 | 2021-01-25 | Norfolk city | Virginia | 51710 | 12117 | 136 |
962391 | 962391 | 2021-01-24 | Norfolk city | Virginia | 51710 | 11980 | 136 |
959146 | 959146 | 2021-01-23 | Norfolk city | Virginia | 51710 | 11895 | 136 |
955900 | 955900 | 2021-01-22 | Norfolk city | Virginia | 51710 | 11715 | 132 |
952655 | 952655 | 2021-01-21 | Norfolk city | Virginia | 51710 | 11615 | 127 |
949410 | 949410 | 2021-01-20 | Norfolk city | Virginia | 51710 | 11514 | 123 |
946164 | 946164 | 2021-01-19 | Norfolk city | Virginia | 51710 | 11392 | 123 |
942917 | 942917 | 2021-01-18 | Norfolk city | Virginia | 51710 | 11294 | 123 |
939672 | 939672 | 2021-01-17 | Norfolk city | Virginia | 51710 | 11075 | 123 |
936427 | 936427 | 2021-01-16 | Norfolk city | Virginia | 51710 | 10869 | 123 |
933182 | 933182 | 2021-01-15 | Norfolk city | Virginia | 51710 | 10746 | 123 |
929937 | 929937 | 2021-01-14 | Norfolk city | Virginia | 51710 | 10678 | 122 |
926692 | 926692 | 2021-01-13 | Norfolk city | Virginia | 51710 | 10507 | 120 |
923446 | 923446 | 2021-01-12 | Norfolk city | Virginia | 51710 | 10380 | 120 |
920201 | 920201 | 2021-01-11 | Norfolk city | Virginia | 51710 | 10176 | 117 |
916956 | 916956 | 2021-01-10 | Norfolk city | Virginia | 51710 | 10105 | 117 |
913711 | 913711 | 2021-01-09 | Norfolk city | Virginia | 51710 | 9976 | 117 |
910466 | 910466 | 2021-01-08 | Norfolk city | Virginia | 51710 | 9806 | 114 |
907221 | 907221 | 2021-01-07 | Norfolk city | Virginia | 51710 | 9703 | 113 |
903975 | 903975 | 2021-01-06 | Norfolk city | Virginia | 51710 | 9551 | 112 |
900730 | 900730 | 2021-01-05 | Norfolk city | Virginia | 51710 | 9395 | 111 |
897485 | 897485 | 2021-01-04 | Norfolk city | Virginia | 51710 | 9169 | 109 |
894239 | 894239 | 2021-01-03 | Norfolk city | Virginia | 51710 | 9077 | 109 |
890993 | 890993 | 2021-01-02 | Norfolk city | Virginia | 51710 | 8975 | 109 |
887746 | 887746 | 2021-01-01 | Norfolk city | Virginia | 51710 | 8978 | 108 |
884501 | 884501 | 2020-12-31 | Norfolk city | Virginia | 51710 | 8849 | 107 |
881256 | 881256 | 2020-12-30 | Norfolk city | Virginia | 51710 | 8697 | 105 |
878011 | 878011 | 2020-12-29 | Norfolk city | Virginia | 51710 | 8609 | 105 |
874766 | 874766 | 2020-12-28 | Norfolk city | Virginia | 51710 | 8448 | 105 |
871521 | 871521 | 2020-12-27 | Norfolk city | Virginia | 51710 | 8420 | 104 |
868276 | 868276 | 2020-12-26 | Norfolk city | Virginia | 51710 | 8322 | 104 |
865031 | 865031 | 2020-12-25 | Norfolk city | Virginia | 51710 | 8275 | 104 |
861786 | 861786 | 2020-12-24 | Norfolk city | Virginia | 51710 | 8230 | 104 |
858541 | 858541 | 2020-12-23 | Norfolk city | Virginia | 51710 | 8150 | 104 |
855296 | 855296 | 2020-12-22 | Norfolk city | Virginia | 51710 | 7988 | 102 |
852051 | 852051 | 2020-12-21 | Norfolk city | Virginia | 51710 | 7823 | 101 |
848806 | 848806 | 2020-12-20 | Norfolk city | Virginia | 51710 | 7767 | 101 |
845561 | 845561 | 2020-12-19 | Norfolk city | Virginia | 51710 | 7723 | 101 |
842315 | 842315 | 2020-12-18 | Norfolk city | Virginia | 51710 | 7684 | 101 |
839070 | 839070 | 2020-12-17 | Norfolk city | Virginia | 51710 | 7635 | 101 |
835824 | 835824 | 2020-12-16 | Norfolk city | Virginia | 51710 | 7572 | 101 |
832578 | 832578 | 2020-12-15 | Norfolk city | Virginia | 51710 | 7503 | 100 |
829331 | 829331 | 2020-12-14 | Norfolk city | Virginia | 51710 | 7395 | 99 |
826085 | 826085 | 2020-12-13 | Norfolk city | Virginia | 51710 | 7368 | 99 |
822838 | 822838 | 2020-12-12 | Norfolk city | Virginia | 51710 | 7331 | 99 |
819592 | 819592 | 2020-12-11 | Norfolk city | Virginia | 51710 | 7250 | 99 |
816346 | 816346 | 2020-12-10 | Norfolk city | Virginia | 51710 | 7176 | 99 |
813100 | 813100 | 2020-12-09 | Norfolk city | Virginia | 51710 | 7106 | 98 |
809856 | 809856 | 2020-12-08 | Norfolk city | Virginia | 51710 | 7038 | 98 |
806611 | 806611 | 2020-12-07 | Norfolk city | Virginia | 51710 | 6894 | 93 |
803366 | 803366 | 2020-12-06 | Norfolk city | Virginia | 51710 | 6783 | 93 |
800121 | 800121 | 2020-12-05 | Norfolk city | Virginia | 51710 | 6786 | 93 |
796876 | 796876 | 2020-12-04 | Norfolk city | Virginia | 51710 | 6728 | 92 |
793631 | 793631 | 2020-12-03 | Norfolk city | Virginia | 51710 | 6654 | 92 |
790386 | 790386 | 2020-12-02 | Norfolk city | Virginia | 51710 | 6617 | 91 |
787141 | 787141 | 2020-12-01 | Norfolk city | Virginia | 51710 | 6566 | 91 |
783897 | 783897 | 2020-11-30 | Norfolk city | Virginia | 51710 | 6528 | 91 |
780652 | 780652 | 2020-11-29 | Norfolk city | Virginia | 51710 | 6528 | 90 |
777406 | 777406 | 2020-11-28 | Norfolk city | Virginia | 51710 | 6423 | 89 |
774161 | 774161 | 2020-11-27 | Norfolk city | Virginia | 51710 | 6408 | 89 |
770916 | 770916 | 2020-11-26 | Norfolk city | Virginia | 51710 | 6401 | 89 |
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);