ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Chesapeake 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 |
---|---|---|---|---|---|---|---|
1092155 | 1092155 | 2021-03-05 | Chesapeake city | Virginia | 51550 | 18446 | 226 |
1088909 | 1088909 | 2021-03-04 | Chesapeake city | Virginia | 51550 | 18395 | 222 |
1085664 | 1085664 | 2021-03-03 | Chesapeake city | Virginia | 51550 | 18365 | 221 |
1082418 | 1082418 | 2021-03-02 | Chesapeake city | Virginia | 51550 | 18318 | 199 |
1079172 | 1079172 | 2021-03-01 | Chesapeake city | Virginia | 51550 | 18257 | 194 |
1075927 | 1075927 | 2021-02-28 | Chesapeake city | Virginia | 51550 | 18233 | 187 |
1072681 | 1072681 | 2021-02-27 | Chesapeake city | Virginia | 51550 | 18160 | 183 |
1069435 | 1069435 | 2021-02-26 | Chesapeake city | Virginia | 51550 | 18108 | 179 |
1066190 | 1066190 | 2021-02-25 | Chesapeake city | Virginia | 51550 | 18064 | 170 |
1062945 | 1062945 | 2021-02-24 | Chesapeake city | Virginia | 51550 | 17974 | 165 |
1059700 | 1059700 | 2021-02-23 | Chesapeake city | Virginia | 51550 | 17913 | 161 |
1056454 | 1056454 | 2021-02-22 | Chesapeake city | Virginia | 51550 | 17819 | 156 |
1053208 | 1053208 | 2021-02-21 | Chesapeake city | Virginia | 51550 | 17781 | 151 |
1049961 | 1049961 | 2021-02-20 | Chesapeake city | Virginia | 51550 | 17697 | 149 |
1046714 | 1046714 | 2021-02-19 | Chesapeake city | Virginia | 51550 | 17619 | 147 |
1043469 | 1043469 | 2021-02-18 | Chesapeake city | Virginia | 51550 | 17539 | 147 |
1040224 | 1040224 | 2021-02-17 | Chesapeake city | Virginia | 51550 | 17425 | 147 |
1036979 | 1036979 | 2021-02-16 | Chesapeake city | Virginia | 51550 | 17343 | 146 |
1033734 | 1033734 | 2021-02-15 | Chesapeake city | Virginia | 51550 | 17271 | 146 |
1030488 | 1030488 | 2021-02-14 | Chesapeake city | Virginia | 51550 | 17204 | 146 |
1027241 | 1027241 | 2021-02-13 | Chesapeake city | Virginia | 51550 | 17089 | 146 |
1023996 | 1023996 | 2021-02-12 | Chesapeake city | Virginia | 51550 | 16985 | 146 |
1020751 | 1020751 | 2021-02-11 | Chesapeake city | Virginia | 51550 | 16848 | 145 |
1017506 | 1017506 | 2021-02-10 | Chesapeake city | Virginia | 51550 | 16716 | 143 |
1014261 | 1014261 | 2021-02-09 | Chesapeake city | Virginia | 51550 | 16593 | 143 |
1011016 | 1011016 | 2021-02-08 | Chesapeake city | Virginia | 51550 | 16473 | 142 |
1007770 | 1007770 | 2021-02-07 | Chesapeake city | Virginia | 51550 | 16412 | 142 |
1004524 | 1004524 | 2021-02-06 | Chesapeake city | Virginia | 51550 | 16278 | 142 |
1001278 | 1001278 | 2021-02-05 | Chesapeake city | Virginia | 51550 | 16126 | 141 |
998032 | 998032 | 2021-02-04 | Chesapeake city | Virginia | 51550 | 15922 | 141 |
994786 | 994786 | 2021-02-03 | Chesapeake city | Virginia | 51550 | 15793 | 138 |
991540 | 991540 | 2021-02-02 | Chesapeake city | Virginia | 51550 | 15660 | 137 |
988294 | 988294 | 2021-02-01 | Chesapeake city | Virginia | 51550 | 15548 | 136 |
985047 | 985047 | 2021-01-31 | Chesapeake city | Virginia | 51550 | 15436 | 136 |
981800 | 981800 | 2021-01-30 | Chesapeake city | Virginia | 51550 | 15370 | 136 |
978554 | 978554 | 2021-01-29 | Chesapeake city | Virginia | 51550 | 15210 | 134 |
975309 | 975309 | 2021-01-28 | Chesapeake city | Virginia | 51550 | 15078 | 132 |
972064 | 972064 | 2021-01-27 | Chesapeake city | Virginia | 51550 | 14862 | 128 |
968819 | 968819 | 2021-01-26 | Chesapeake city | Virginia | 51550 | 14731 | 127 |
965575 | 965575 | 2021-01-25 | Chesapeake city | Virginia | 51550 | 14590 | 120 |
962330 | 962330 | 2021-01-24 | Chesapeake city | Virginia | 51550 | 14386 | 120 |
959085 | 959085 | 2021-01-23 | Chesapeake city | Virginia | 51550 | 14248 | 120 |
955839 | 955839 | 2021-01-22 | Chesapeake city | Virginia | 51550 | 14015 | 120 |
952594 | 952594 | 2021-01-21 | Chesapeake city | Virginia | 51550 | 13771 | 117 |
949349 | 949349 | 2021-01-20 | Chesapeake city | Virginia | 51550 | 13428 | 116 |
946103 | 946103 | 2021-01-19 | Chesapeake city | Virginia | 51550 | 13055 | 115 |
942856 | 942856 | 2021-01-18 | Chesapeake city | Virginia | 51550 | 12807 | 113 |
939611 | 939611 | 2021-01-17 | Chesapeake city | Virginia | 51550 | 12297 | 113 |
936366 | 936366 | 2021-01-16 | Chesapeake city | Virginia | 51550 | 11967 | 113 |
933121 | 933121 | 2021-01-15 | Chesapeake city | Virginia | 51550 | 11536 | 113 |
929876 | 929876 | 2021-01-14 | Chesapeake city | Virginia | 51550 | 11212 | 112 |
926631 | 926631 | 2021-01-13 | Chesapeake city | Virginia | 51550 | 10812 | 109 |
923385 | 923385 | 2021-01-12 | Chesapeake city | Virginia | 51550 | 10533 | 108 |
920140 | 920140 | 2021-01-11 | Chesapeake city | Virginia | 51550 | 10420 | 108 |
916895 | 916895 | 2021-01-10 | Chesapeake city | Virginia | 51550 | 10348 | 108 |
913650 | 913650 | 2021-01-09 | Chesapeake city | Virginia | 51550 | 10224 | 108 |
910405 | 910405 | 2021-01-08 | Chesapeake city | Virginia | 51550 | 10105 | 107 |
907160 | 907160 | 2021-01-07 | Chesapeake city | Virginia | 51550 | 10031 | 106 |
903914 | 903914 | 2021-01-06 | Chesapeake city | Virginia | 51550 | 9933 | 104 |
900669 | 900669 | 2021-01-05 | Chesapeake city | Virginia | 51550 | 9854 | 104 |
897424 | 897424 | 2021-01-04 | Chesapeake city | Virginia | 51550 | 9759 | 102 |
894178 | 894178 | 2021-01-03 | Chesapeake city | Virginia | 51550 | 9628 | 102 |
890932 | 890932 | 2021-01-02 | Chesapeake city | Virginia | 51550 | 9526 | 102 |
887685 | 887685 | 2021-01-01 | Chesapeake city | Virginia | 51550 | 9426 | 101 |
884440 | 884440 | 2020-12-31 | Chesapeake city | Virginia | 51550 | 9324 | 101 |
881195 | 881195 | 2020-12-30 | Chesapeake city | Virginia | 51550 | 9224 | 99 |
877950 | 877950 | 2020-12-29 | Chesapeake city | Virginia | 51550 | 9151 | 99 |
874705 | 874705 | 2020-12-28 | Chesapeake city | Virginia | 51550 | 9043 | 97 |
871460 | 871460 | 2020-12-27 | Chesapeake city | Virginia | 51550 | 8989 | 97 |
868215 | 868215 | 2020-12-26 | Chesapeake city | Virginia | 51550 | 8888 | 97 |
864970 | 864970 | 2020-12-25 | Chesapeake city | Virginia | 51550 | 8863 | 97 |
861725 | 861725 | 2020-12-24 | Chesapeake city | Virginia | 51550 | 8784 | 96 |
858480 | 858480 | 2020-12-23 | Chesapeake city | Virginia | 51550 | 8659 | 96 |
855235 | 855235 | 2020-12-22 | Chesapeake city | Virginia | 51550 | 8547 | 95 |
851990 | 851990 | 2020-12-21 | Chesapeake city | Virginia | 51550 | 8435 | 94 |
848745 | 848745 | 2020-12-20 | Chesapeake city | Virginia | 51550 | 8362 | 94 |
845500 | 845500 | 2020-12-19 | Chesapeake city | Virginia | 51550 | 8270 | 94 |
842254 | 842254 | 2020-12-18 | Chesapeake city | Virginia | 51550 | 8168 | 92 |
839009 | 839009 | 2020-12-17 | Chesapeake city | Virginia | 51550 | 8031 | 92 |
835763 | 835763 | 2020-12-16 | Chesapeake city | Virginia | 51550 | 7890 | 89 |
832517 | 832517 | 2020-12-15 | Chesapeake city | Virginia | 51550 | 7719 | 89 |
829270 | 829270 | 2020-12-14 | Chesapeake city | Virginia | 51550 | 7620 | 88 |
826024 | 826024 | 2020-12-13 | Chesapeake city | Virginia | 51550 | 7540 | 88 |
822777 | 822777 | 2020-12-12 | Chesapeake city | Virginia | 51550 | 7348 | 88 |
819531 | 819531 | 2020-12-11 | Chesapeake city | Virginia | 51550 | 7289 | 88 |
816285 | 816285 | 2020-12-10 | Chesapeake city | Virginia | 51550 | 7227 | 87 |
813039 | 813039 | 2020-12-09 | Chesapeake city | Virginia | 51550 | 7135 | 86 |
809795 | 809795 | 2020-12-08 | Chesapeake city | Virginia | 51550 | 7071 | 86 |
806550 | 806550 | 2020-12-07 | Chesapeake city | Virginia | 51550 | 7017 | 83 |
803305 | 803305 | 2020-12-06 | Chesapeake city | Virginia | 51550 | 6964 | 81 |
800060 | 800060 | 2020-12-05 | Chesapeake city | Virginia | 51550 | 6888 | 81 |
796815 | 796815 | 2020-12-04 | Chesapeake city | Virginia | 51550 | 6841 | 81 |
793570 | 793570 | 2020-12-03 | Chesapeake city | Virginia | 51550 | 6790 | 81 |
790325 | 790325 | 2020-12-02 | Chesapeake city | Virginia | 51550 | 6739 | 80 |
787080 | 787080 | 2020-12-01 | Chesapeake city | Virginia | 51550 | 6699 | 80 |
783836 | 783836 | 2020-11-30 | Chesapeake city | Virginia | 51550 | 6657 | 80 |
780591 | 780591 | 2020-11-29 | Chesapeake city | Virginia | 51550 | 6611 | 80 |
777345 | 777345 | 2020-11-28 | Chesapeake city | Virginia | 51550 | 6525 | 80 |
774100 | 774100 | 2020-11-27 | Chesapeake city | Virginia | 51550 | 6385 | 80 |
770855 | 770855 | 2020-11-26 | Chesapeake city | Virginia | 51550 | 6220 | 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);