ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Chesterfield" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092156 | 1092156 | 2021-03-05 | Chesterfield | Virginia | 51041 | 23812 | 356 |
1088910 | 1088910 | 2021-03-04 | Chesterfield | Virginia | 51041 | 23757 | 353 |
1085665 | 1085665 | 2021-03-03 | Chesterfield | Virginia | 51041 | 23727 | 352 |
1082419 | 1082419 | 2021-03-02 | Chesterfield | Virginia | 51041 | 23654 | 324 |
1079173 | 1079173 | 2021-03-01 | Chesterfield | Virginia | 51041 | 23594 | 306 |
1075928 | 1075928 | 2021-02-28 | Chesterfield | Virginia | 51041 | 23546 | 298 |
1072682 | 1072682 | 2021-02-27 | Chesterfield | Virginia | 51041 | 23488 | 291 |
1069436 | 1069436 | 2021-02-26 | Chesterfield | Virginia | 51041 | 23402 | 287 |
1066191 | 1066191 | 2021-02-25 | Chesterfield | Virginia | 51041 | 23312 | 269 |
1062946 | 1062946 | 2021-02-24 | Chesterfield | Virginia | 51041 | 23245 | 263 |
1059701 | 1059701 | 2021-02-23 | Chesterfield | Virginia | 51041 | 23172 | 260 |
1056455 | 1056455 | 2021-02-22 | Chesterfield | Virginia | 51041 | 23077 | 246 |
1053209 | 1053209 | 2021-02-21 | Chesterfield | Virginia | 51041 | 23009 | 231 |
1049962 | 1049962 | 2021-02-20 | Chesterfield | Virginia | 51041 | 22919 | 222 |
1046715 | 1046715 | 2021-02-19 | Chesterfield | Virginia | 51041 | 22835 | 216 |
1043470 | 1043470 | 2021-02-18 | Chesterfield | Virginia | 51041 | 22708 | 216 |
1040225 | 1040225 | 2021-02-17 | Chesterfield | Virginia | 51041 | 22643 | 217 |
1036980 | 1036980 | 2021-02-16 | Chesterfield | Virginia | 51041 | 22541 | 216 |
1033735 | 1033735 | 2021-02-15 | Chesterfield | Virginia | 51041 | 22412 | 215 |
1030489 | 1030489 | 2021-02-14 | Chesterfield | Virginia | 51041 | 22270 | 215 |
1027242 | 1027242 | 2021-02-13 | Chesterfield | Virginia | 51041 | 22019 | 216 |
1023997 | 1023997 | 2021-02-12 | Chesterfield | Virginia | 51041 | 21701 | 216 |
1020752 | 1020752 | 2021-02-11 | Chesterfield | Virginia | 51041 | 21469 | 216 |
1017507 | 1017507 | 2021-02-10 | Chesterfield | Virginia | 51041 | 21131 | 216 |
1014262 | 1014262 | 2021-02-09 | Chesterfield | Virginia | 51041 | 20876 | 216 |
1011017 | 1011017 | 2021-02-08 | Chesterfield | Virginia | 51041 | 20654 | 214 |
1007771 | 1007771 | 2021-02-07 | Chesterfield | Virginia | 51041 | 20435 | 214 |
1004525 | 1004525 | 2021-02-06 | Chesterfield | Virginia | 51041 | 20141 | 214 |
1001279 | 1001279 | 2021-02-05 | Chesterfield | Virginia | 51041 | 19944 | 212 |
998033 | 998033 | 2021-02-04 | Chesterfield | Virginia | 51041 | 19697 | 209 |
994787 | 994787 | 2021-02-03 | Chesterfield | Virginia | 51041 | 19563 | 207 |
991541 | 991541 | 2021-02-02 | Chesterfield | Virginia | 51041 | 19449 | 206 |
988295 | 988295 | 2021-02-01 | Chesterfield | Virginia | 51041 | 19294 | 204 |
985048 | 985048 | 2021-01-31 | Chesterfield | Virginia | 51041 | 19150 | 203 |
981801 | 981801 | 2021-01-30 | Chesterfield | Virginia | 51041 | 18969 | 203 |
978555 | 978555 | 2021-01-29 | Chesterfield | Virginia | 51041 | 18802 | 202 |
975310 | 975310 | 2021-01-28 | Chesterfield | Virginia | 51041 | 18648 | 201 |
972065 | 972065 | 2021-01-27 | Chesterfield | Virginia | 51041 | 18451 | 201 |
968820 | 968820 | 2021-01-26 | Chesterfield | Virginia | 51041 | 18235 | 199 |
965576 | 965576 | 2021-01-25 | Chesterfield | Virginia | 51041 | 18005 | 198 |
962331 | 962331 | 2021-01-24 | Chesterfield | Virginia | 51041 | 17706 | 198 |
959086 | 959086 | 2021-01-23 | Chesterfield | Virginia | 51041 | 17542 | 198 |
955840 | 955840 | 2021-01-22 | Chesterfield | Virginia | 51041 | 17408 | 195 |
952595 | 952595 | 2021-01-21 | Chesterfield | Virginia | 51041 | 17254 | 194 |
949350 | 949350 | 2021-01-20 | Chesterfield | Virginia | 51041 | 17097 | 193 |
946104 | 946104 | 2021-01-19 | Chesterfield | Virginia | 51041 | 16897 | 193 |
942857 | 942857 | 2021-01-18 | Chesterfield | Virginia | 51041 | 16641 | 193 |
939612 | 939612 | 2021-01-17 | Chesterfield | Virginia | 51041 | 16327 | 193 |
936367 | 936367 | 2021-01-16 | Chesterfield | Virginia | 51041 | 15769 | 193 |
933122 | 933122 | 2021-01-15 | Chesterfield | Virginia | 51041 | 15425 | 191 |
929877 | 929877 | 2021-01-14 | Chesterfield | Virginia | 51041 | 15203 | 190 |
926632 | 926632 | 2021-01-13 | Chesterfield | Virginia | 51041 | 15057 | 186 |
923386 | 923386 | 2021-01-12 | Chesterfield | Virginia | 51041 | 14904 | 185 |
920141 | 920141 | 2021-01-11 | Chesterfield | Virginia | 51041 | 14778 | 183 |
916896 | 916896 | 2021-01-10 | Chesterfield | Virginia | 51041 | 14686 | 183 |
913651 | 913651 | 2021-01-09 | Chesterfield | Virginia | 51041 | 14531 | 183 |
910406 | 910406 | 2021-01-08 | Chesterfield | Virginia | 51041 | 14287 | 182 |
907161 | 907161 | 2021-01-07 | Chesterfield | Virginia | 51041 | 14142 | 178 |
903915 | 903915 | 2021-01-06 | Chesterfield | Virginia | 51041 | 13953 | 175 |
900670 | 900670 | 2021-01-05 | Chesterfield | Virginia | 51041 | 13822 | 174 |
897425 | 897425 | 2021-01-04 | Chesterfield | Virginia | 51041 | 13658 | 173 |
894179 | 894179 | 2021-01-03 | Chesterfield | Virginia | 51041 | 13505 | 173 |
890933 | 890933 | 2021-01-02 | Chesterfield | Virginia | 51041 | 13374 | 173 |
887686 | 887686 | 2021-01-01 | Chesterfield | Virginia | 51041 | 13215 | 171 |
884441 | 884441 | 2020-12-31 | Chesterfield | Virginia | 51041 | 13059 | 172 |
881196 | 881196 | 2020-12-30 | Chesterfield | Virginia | 51041 | 12876 | 169 |
877951 | 877951 | 2020-12-29 | Chesterfield | Virginia | 51041 | 12727 | 165 |
874706 | 874706 | 2020-12-28 | Chesterfield | Virginia | 51041 | 12552 | 163 |
871461 | 871461 | 2020-12-27 | Chesterfield | Virginia | 51041 | 12399 | 163 |
868216 | 868216 | 2020-12-26 | Chesterfield | Virginia | 51041 | 12321 | 164 |
864971 | 864971 | 2020-12-25 | Chesterfield | Virginia | 51041 | 12272 | 164 |
861726 | 861726 | 2020-12-24 | Chesterfield | Virginia | 51041 | 12186 | 163 |
858481 | 858481 | 2020-12-23 | Chesterfield | Virginia | 51041 | 12072 | 161 |
855236 | 855236 | 2020-12-22 | Chesterfield | Virginia | 51041 | 11896 | 158 |
851991 | 851991 | 2020-12-21 | Chesterfield | Virginia | 51041 | 11678 | 156 |
848746 | 848746 | 2020-12-20 | Chesterfield | Virginia | 51041 | 11583 | 156 |
845501 | 845501 | 2020-12-19 | Chesterfield | Virginia | 51041 | 11528 | 156 |
842255 | 842255 | 2020-12-18 | Chesterfield | Virginia | 51041 | 11409 | 156 |
839010 | 839010 | 2020-12-17 | Chesterfield | Virginia | 51041 | 11220 | 154 |
835764 | 835764 | 2020-12-16 | Chesterfield | Virginia | 51041 | 11129 | 151 |
832518 | 832518 | 2020-12-15 | Chesterfield | Virginia | 51041 | 10994 | 150 |
829271 | 829271 | 2020-12-14 | Chesterfield | Virginia | 51041 | 10822 | 148 |
826025 | 826025 | 2020-12-13 | Chesterfield | Virginia | 51041 | 10753 | 148 |
822778 | 822778 | 2020-12-12 | Chesterfield | Virginia | 51041 | 10680 | 148 |
819532 | 819532 | 2020-12-11 | Chesterfield | Virginia | 51041 | 10590 | 146 |
816286 | 816286 | 2020-12-10 | Chesterfield | Virginia | 51041 | 10445 | 143 |
813040 | 813040 | 2020-12-09 | Chesterfield | Virginia | 51041 | 10350 | 139 |
809796 | 809796 | 2020-12-08 | Chesterfield | Virginia | 51041 | 10216 | 139 |
806551 | 806551 | 2020-12-07 | Chesterfield | Virginia | 51041 | 10056 | 135 |
803306 | 803306 | 2020-12-06 | Chesterfield | Virginia | 51041 | 9957 | 135 |
800061 | 800061 | 2020-12-05 | Chesterfield | Virginia | 51041 | 9874 | 135 |
796816 | 796816 | 2020-12-04 | Chesterfield | Virginia | 51041 | 9732 | 135 |
793571 | 793571 | 2020-12-03 | Chesterfield | Virginia | 51041 | 9631 | 135 |
790326 | 790326 | 2020-12-02 | Chesterfield | Virginia | 51041 | 9563 | 131 |
787081 | 787081 | 2020-12-01 | Chesterfield | Virginia | 51041 | 9443 | 131 |
783837 | 783837 | 2020-11-30 | Chesterfield | Virginia | 51041 | 9323 | 131 |
780592 | 780592 | 2020-11-29 | Chesterfield | Virginia | 51041 | 9255 | 131 |
777346 | 777346 | 2020-11-28 | Chesterfield | Virginia | 51041 | 9181 | 131 |
774101 | 774101 | 2020-11-27 | Chesterfield | Virginia | 51041 | 9101 | 131 |
770856 | 770856 | 2020-11-26 | Chesterfield | Virginia | 51041 | 9045 | 129 |
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);