ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "King and Queen" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092197 | 1092197 | 2021-03-05 | King and Queen | Virginia | 51097 | 318 | 6 |
1088951 | 1088951 | 2021-03-04 | King and Queen | Virginia | 51097 | 316 | 6 |
1085706 | 1085706 | 2021-03-03 | King and Queen | Virginia | 51097 | 315 | 6 |
1082460 | 1082460 | 2021-03-02 | King and Queen | Virginia | 51097 | 312 | 6 |
1079214 | 1079214 | 2021-03-01 | King and Queen | Virginia | 51097 | 309 | 6 |
1075969 | 1075969 | 2021-02-28 | King and Queen | Virginia | 51097 | 304 | 6 |
1072723 | 1072723 | 2021-02-27 | King and Queen | Virginia | 51097 | 305 | 6 |
1069477 | 1069477 | 2021-02-26 | King and Queen | Virginia | 51097 | 303 | 6 |
1066232 | 1066232 | 2021-02-25 | King and Queen | Virginia | 51097 | 301 | 6 |
1062987 | 1062987 | 2021-02-24 | King and Queen | Virginia | 51097 | 300 | 6 |
1059742 | 1059742 | 2021-02-23 | King and Queen | Virginia | 51097 | 299 | 6 |
1056496 | 1056496 | 2021-02-22 | King and Queen | Virginia | 51097 | 298 | 6 |
1053250 | 1053250 | 2021-02-21 | King and Queen | Virginia | 51097 | 298 | 6 |
1050003 | 1050003 | 2021-02-20 | King and Queen | Virginia | 51097 | 297 | 5 |
1046756 | 1046756 | 2021-02-19 | King and Queen | Virginia | 51097 | 297 | 4 |
1043511 | 1043511 | 2021-02-18 | King and Queen | Virginia | 51097 | 296 | 4 |
1040266 | 1040266 | 2021-02-17 | King and Queen | Virginia | 51097 | 293 | 4 |
1037021 | 1037021 | 2021-02-16 | King and Queen | Virginia | 51097 | 291 | 4 |
1033776 | 1033776 | 2021-02-15 | King and Queen | Virginia | 51097 | 292 | 4 |
1030530 | 1030530 | 2021-02-14 | King and Queen | Virginia | 51097 | 292 | 4 |
1027283 | 1027283 | 2021-02-13 | King and Queen | Virginia | 51097 | 292 | 4 |
1024038 | 1024038 | 2021-02-12 | King and Queen | Virginia | 51097 | 291 | 4 |
1020793 | 1020793 | 2021-02-11 | King and Queen | Virginia | 51097 | 287 | 4 |
1017548 | 1017548 | 2021-02-10 | King and Queen | Virginia | 51097 | 281 | 4 |
1014303 | 1014303 | 2021-02-09 | King and Queen | Virginia | 51097 | 281 | 4 |
1011058 | 1011058 | 2021-02-08 | King and Queen | Virginia | 51097 | 276 | 3 |
1007812 | 1007812 | 2021-02-07 | King and Queen | Virginia | 51097 | 274 | 3 |
1004566 | 1004566 | 2021-02-06 | King and Queen | Virginia | 51097 | 272 | 3 |
1001320 | 1001320 | 2021-02-05 | King and Queen | Virginia | 51097 | 270 | 3 |
998074 | 998074 | 2021-02-04 | King and Queen | Virginia | 51097 | 259 | 3 |
994828 | 994828 | 2021-02-03 | King and Queen | Virginia | 51097 | 257 | 3 |
991582 | 991582 | 2021-02-02 | King and Queen | Virginia | 51097 | 255 | 3 |
988336 | 988336 | 2021-02-01 | King and Queen | Virginia | 51097 | 255 | 3 |
985089 | 985089 | 2021-01-31 | King and Queen | Virginia | 51097 | 251 | 3 |
981842 | 981842 | 2021-01-30 | King and Queen | Virginia | 51097 | 250 | 3 |
978596 | 978596 | 2021-01-29 | King and Queen | Virginia | 51097 | 249 | 3 |
975351 | 975351 | 2021-01-28 | King and Queen | Virginia | 51097 | 249 | 3 |
972106 | 972106 | 2021-01-27 | King and Queen | Virginia | 51097 | 247 | 3 |
968861 | 968861 | 2021-01-26 | King and Queen | Virginia | 51097 | 244 | 3 |
965617 | 965617 | 2021-01-25 | King and Queen | Virginia | 51097 | 242 | 3 |
962372 | 962372 | 2021-01-24 | King and Queen | Virginia | 51097 | 238 | 3 |
959127 | 959127 | 2021-01-23 | King and Queen | Virginia | 51097 | 237 | 3 |
955881 | 955881 | 2021-01-22 | King and Queen | Virginia | 51097 | 234 | 3 |
952636 | 952636 | 2021-01-21 | King and Queen | Virginia | 51097 | 228 | 3 |
949391 | 949391 | 2021-01-20 | King and Queen | Virginia | 51097 | 226 | 2 |
946145 | 946145 | 2021-01-19 | King and Queen | Virginia | 51097 | 225 | 2 |
942898 | 942898 | 2021-01-18 | King and Queen | Virginia | 51097 | 219 | 2 |
939653 | 939653 | 2021-01-17 | King and Queen | Virginia | 51097 | 214 | 2 |
936408 | 936408 | 2021-01-16 | King and Queen | Virginia | 51097 | 212 | 2 |
933163 | 933163 | 2021-01-15 | King and Queen | Virginia | 51097 | 210 | 2 |
929918 | 929918 | 2021-01-14 | King and Queen | Virginia | 51097 | 209 | 2 |
926673 | 926673 | 2021-01-13 | King and Queen | Virginia | 51097 | 204 | 2 |
923427 | 923427 | 2021-01-12 | King and Queen | Virginia | 51097 | 201 | 2 |
920182 | 920182 | 2021-01-11 | King and Queen | Virginia | 51097 | 197 | 2 |
916937 | 916937 | 2021-01-10 | King and Queen | Virginia | 51097 | 194 | 2 |
913692 | 913692 | 2021-01-09 | King and Queen | Virginia | 51097 | 192 | 2 |
910447 | 910447 | 2021-01-08 | King and Queen | Virginia | 51097 | 188 | 2 |
907202 | 907202 | 2021-01-07 | King and Queen | Virginia | 51097 | 188 | 2 |
903956 | 903956 | 2021-01-06 | King and Queen | Virginia | 51097 | 183 | 2 |
900711 | 900711 | 2021-01-05 | King and Queen | Virginia | 51097 | 178 | 2 |
897466 | 897466 | 2021-01-04 | King and Queen | Virginia | 51097 | 176 | 2 |
894220 | 894220 | 2021-01-03 | King and Queen | Virginia | 51097 | 176 | 2 |
890974 | 890974 | 2021-01-02 | King and Queen | Virginia | 51097 | 175 | 2 |
887727 | 887727 | 2021-01-01 | King and Queen | Virginia | 51097 | 175 | 2 |
884482 | 884482 | 2020-12-31 | King and Queen | Virginia | 51097 | 171 | 2 |
881237 | 881237 | 2020-12-30 | King and Queen | Virginia | 51097 | 171 | 2 |
877992 | 877992 | 2020-12-29 | King and Queen | Virginia | 51097 | 171 | 2 |
874747 | 874747 | 2020-12-28 | King and Queen | Virginia | 51097 | 170 | 2 |
871502 | 871502 | 2020-12-27 | King and Queen | Virginia | 51097 | 169 | 2 |
868257 | 868257 | 2020-12-26 | King and Queen | Virginia | 51097 | 169 | 2 |
865012 | 865012 | 2020-12-25 | King and Queen | Virginia | 51097 | 169 | 2 |
861767 | 861767 | 2020-12-24 | King and Queen | Virginia | 51097 | 165 | 2 |
858522 | 858522 | 2020-12-23 | King and Queen | Virginia | 51097 | 161 | 2 |
855277 | 855277 | 2020-12-22 | King and Queen | Virginia | 51097 | 150 | 2 |
852032 | 852032 | 2020-12-21 | King and Queen | Virginia | 51097 | 149 | 2 |
848787 | 848787 | 2020-12-20 | King and Queen | Virginia | 51097 | 145 | 2 |
845542 | 845542 | 2020-12-19 | King and Queen | Virginia | 51097 | 140 | 2 |
842296 | 842296 | 2020-12-18 | King and Queen | Virginia | 51097 | 139 | 2 |
839051 | 839051 | 2020-12-17 | King and Queen | Virginia | 51097 | 137 | 2 |
835805 | 835805 | 2020-12-16 | King and Queen | Virginia | 51097 | 127 | 2 |
832559 | 832559 | 2020-12-15 | King and Queen | Virginia | 51097 | 123 | 2 |
829312 | 829312 | 2020-12-14 | King and Queen | Virginia | 51097 | 123 | 2 |
826066 | 826066 | 2020-12-13 | King and Queen | Virginia | 51097 | 121 | 2 |
822819 | 822819 | 2020-12-12 | King and Queen | Virginia | 51097 | 119 | 2 |
819573 | 819573 | 2020-12-11 | King and Queen | Virginia | 51097 | 113 | 2 |
816327 | 816327 | 2020-12-10 | King and Queen | Virginia | 51097 | 113 | 2 |
813081 | 813081 | 2020-12-09 | King and Queen | Virginia | 51097 | 110 | 2 |
809837 | 809837 | 2020-12-08 | King and Queen | Virginia | 51097 | 109 | 2 |
806592 | 806592 | 2020-12-07 | King and Queen | Virginia | 51097 | 109 | 2 |
803347 | 803347 | 2020-12-06 | King and Queen | Virginia | 51097 | 109 | 2 |
800102 | 800102 | 2020-12-05 | King and Queen | Virginia | 51097 | 106 | 2 |
796857 | 796857 | 2020-12-04 | King and Queen | Virginia | 51097 | 106 | 2 |
793612 | 793612 | 2020-12-03 | King and Queen | Virginia | 51097 | 105 | 2 |
790367 | 790367 | 2020-12-02 | King and Queen | Virginia | 51097 | 105 | 2 |
787122 | 787122 | 2020-12-01 | King and Queen | Virginia | 51097 | 105 | 2 |
783878 | 783878 | 2020-11-30 | King and Queen | Virginia | 51097 | 104 | 2 |
780633 | 780633 | 2020-11-29 | King and Queen | Virginia | 51097 | 104 | 2 |
777387 | 777387 | 2020-11-28 | King and Queen | Virginia | 51097 | 104 | 2 |
774142 | 774142 | 2020-11-27 | King and Queen | Virginia | 51097 | 104 | 2 |
770897 | 770897 | 2020-11-26 | King and Queen | Virginia | 51097 | 102 | 2 |
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);