ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51153 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095477 | 1095477 | 2021-03-06 | Prince William | Virginia | 51153 | 39868 | 450 |
1092231 | 1092231 | 2021-03-05 | Prince William | Virginia | 51153 | 39767 | 446 |
1088985 | 1088985 | 2021-03-04 | Prince William | Virginia | 51153 | 39667 | 442 |
1085740 | 1085740 | 2021-03-03 | Prince William | Virginia | 51153 | 39570 | 441 |
1082494 | 1082494 | 2021-03-02 | Prince William | Virginia | 51153 | 39472 | 424 |
1079248 | 1079248 | 2021-03-01 | Prince William | Virginia | 51153 | 39398 | 420 |
1076003 | 1076003 | 2021-02-28 | Prince William | Virginia | 51153 | 39333 | 404 |
1072757 | 1072757 | 2021-02-27 | Prince William | Virginia | 51153 | 39211 | 398 |
1069511 | 1069511 | 2021-02-26 | Prince William | Virginia | 51153 | 39150 | 389 |
1066266 | 1066266 | 2021-02-25 | Prince William | Virginia | 51153 | 39029 | 375 |
1063021 | 1063021 | 2021-02-24 | Prince William | Virginia | 51153 | 38920 | 368 |
1059776 | 1059776 | 2021-02-23 | Prince William | Virginia | 51153 | 38832 | 358 |
1056530 | 1056530 | 2021-02-22 | Prince William | Virginia | 51153 | 38744 | 354 |
1053284 | 1053284 | 2021-02-21 | Prince William | Virginia | 51153 | 38678 | 345 |
1050037 | 1050037 | 2021-02-20 | Prince William | Virginia | 51153 | 38518 | 334 |
1046790 | 1046790 | 2021-02-19 | Prince William | Virginia | 51153 | 38420 | 328 |
1043545 | 1043545 | 2021-02-18 | Prince William | Virginia | 51153 | 38318 | 328 |
1040300 | 1040300 | 2021-02-17 | Prince William | Virginia | 51153 | 38197 | 328 |
1037055 | 1037055 | 2021-02-16 | Prince William | Virginia | 51153 | 38070 | 327 |
1033810 | 1033810 | 2021-02-15 | Prince William | Virginia | 51153 | 37969 | 327 |
1030564 | 1030564 | 2021-02-14 | Prince William | Virginia | 51153 | 37886 | 327 |
1027317 | 1027317 | 2021-02-13 | Prince William | Virginia | 51153 | 37753 | 327 |
1024072 | 1024072 | 2021-02-12 | Prince William | Virginia | 51153 | 37556 | 326 |
1020827 | 1020827 | 2021-02-11 | Prince William | Virginia | 51153 | 37422 | 327 |
1017582 | 1017582 | 2021-02-10 | Prince William | Virginia | 51153 | 37184 | 327 |
1014337 | 1014337 | 2021-02-09 | Prince William | Virginia | 51153 | 36916 | 326 |
1011092 | 1011092 | 2021-02-08 | Prince William | Virginia | 51153 | 36668 | 324 |
1007846 | 1007846 | 2021-02-07 | Prince William | Virginia | 51153 | 36581 | 324 |
1004600 | 1004600 | 2021-02-06 | Prince William | Virginia | 51153 | 36413 | 325 |
1001354 | 1001354 | 2021-02-05 | Prince William | Virginia | 51153 | 36126 | 324 |
998108 | 998108 | 2021-02-04 | Prince William | Virginia | 51153 | 35862 | 321 |
994862 | 994862 | 2021-02-03 | Prince William | Virginia | 51153 | 35693 | 317 |
991616 | 991616 | 2021-02-02 | Prince William | Virginia | 51153 | 35573 | 315 |
988370 | 988370 | 2021-02-01 | Prince William | Virginia | 51153 | 35412 | 313 |
985123 | 985123 | 2021-01-31 | Prince William | Virginia | 51153 | 35245 | 313 |
981876 | 981876 | 2021-01-30 | Prince William | Virginia | 51153 | 35092 | 313 |
978630 | 978630 | 2021-01-29 | Prince William | Virginia | 51153 | 34751 | 308 |
975385 | 975385 | 2021-01-28 | Prince William | Virginia | 51153 | 34545 | 302 |
972140 | 972140 | 2021-01-27 | Prince William | Virginia | 51153 | 34314 | 295 |
968895 | 968895 | 2021-01-26 | Prince William | Virginia | 51153 | 34036 | 291 |
965651 | 965651 | 2021-01-25 | Prince William | Virginia | 51153 | 33739 | 285 |
962406 | 962406 | 2021-01-24 | Prince William | Virginia | 51153 | 33260 | 285 |
959161 | 959161 | 2021-01-23 | Prince William | Virginia | 51153 | 33048 | 285 |
955915 | 955915 | 2021-01-22 | Prince William | Virginia | 51153 | 32874 | 283 |
952670 | 952670 | 2021-01-21 | Prince William | Virginia | 51153 | 32591 | 282 |
949425 | 949425 | 2021-01-20 | Prince William | Virginia | 51153 | 32480 | 281 |
946179 | 946179 | 2021-01-19 | Prince William | Virginia | 51153 | 32237 | 278 |
942932 | 942932 | 2021-01-18 | Prince William | Virginia | 51153 | 31927 | 276 |
939687 | 939687 | 2021-01-17 | Prince William | Virginia | 51153 | 31379 | 276 |
936442 | 936442 | 2021-01-16 | Prince William | Virginia | 51153 | 30023 | 276 |
933197 | 933197 | 2021-01-15 | Prince William | Virginia | 51153 | 29627 | 274 |
929952 | 929952 | 2021-01-14 | Prince William | Virginia | 51153 | 29278 | 273 |
926707 | 926707 | 2021-01-13 | Prince William | Virginia | 51153 | 28987 | 268 |
923461 | 923461 | 2021-01-12 | Prince William | Virginia | 51153 | 28796 | 267 |
920216 | 920216 | 2021-01-11 | Prince William | Virginia | 51153 | 28532 | 264 |
916971 | 916971 | 2021-01-10 | Prince William | Virginia | 51153 | 28271 | 264 |
913726 | 913726 | 2021-01-09 | Prince William | Virginia | 51153 | 28065 | 264 |
910481 | 910481 | 2021-01-08 | Prince William | Virginia | 51153 | 27776 | 264 |
907236 | 907236 | 2021-01-07 | Prince William | Virginia | 51153 | 27574 | 264 |
903990 | 903990 | 2021-01-06 | Prince William | Virginia | 51153 | 27297 | 263 |
900745 | 900745 | 2021-01-05 | Prince William | Virginia | 51153 | 26963 | 262 |
897500 | 897500 | 2021-01-04 | Prince William | Virginia | 51153 | 26664 | 262 |
894254 | 894254 | 2021-01-03 | Prince William | Virginia | 51153 | 26456 | 262 |
891008 | 891008 | 2021-01-02 | Prince William | Virginia | 51153 | 26178 | 262 |
887761 | 887761 | 2021-01-01 | Prince William | Virginia | 51153 | 25877 | 261 |
884516 | 884516 | 2020-12-31 | Prince William | Virginia | 51153 | 25519 | 260 |
881271 | 881271 | 2020-12-30 | Prince William | Virginia | 51153 | 25247 | 256 |
878026 | 878026 | 2020-12-29 | Prince William | Virginia | 51153 | 25057 | 251 |
874781 | 874781 | 2020-12-28 | Prince William | Virginia | 51153 | 24795 | 249 |
871536 | 871536 | 2020-12-27 | Prince William | Virginia | 51153 | 24657 | 249 |
868291 | 868291 | 2020-12-26 | Prince William | Virginia | 51153 | 24292 | 249 |
865046 | 865046 | 2020-12-25 | Prince William | Virginia | 51153 | 24120 | 249 |
861801 | 861801 | 2020-12-24 | Prince William | Virginia | 51153 | 23723 | 249 |
858556 | 858556 | 2020-12-23 | Prince William | Virginia | 51153 | 23407 | 249 |
855311 | 855311 | 2020-12-22 | Prince William | Virginia | 51153 | 23041 | 247 |
852066 | 852066 | 2020-12-21 | Prince William | Virginia | 51153 | 22734 | 247 |
848821 | 848821 | 2020-12-20 | Prince William | Virginia | 51153 | 22592 | 247 |
845576 | 845576 | 2020-12-19 | Prince William | Virginia | 51153 | 22355 | 247 |
842330 | 842330 | 2020-12-18 | Prince William | Virginia | 51153 | 22173 | 247 |
839085 | 839085 | 2020-12-17 | Prince William | Virginia | 51153 | 21969 | 246 |
835839 | 835839 | 2020-12-16 | Prince William | Virginia | 51153 | 21678 | 244 |
832593 | 832593 | 2020-12-15 | Prince William | Virginia | 51153 | 21431 | 244 |
829346 | 829346 | 2020-12-14 | Prince William | Virginia | 51153 | 21272 | 242 |
826100 | 826100 | 2020-12-13 | Prince William | Virginia | 51153 | 21176 | 242 |
822853 | 822853 | 2020-12-12 | Prince William | Virginia | 51153 | 20908 | 242 |
819607 | 819607 | 2020-12-11 | Prince William | Virginia | 51153 | 20543 | 240 |
816361 | 816361 | 2020-12-10 | Prince William | Virginia | 51153 | 20293 | 239 |
813115 | 813115 | 2020-12-09 | Prince William | Virginia | 51153 | 20080 | 237 |
809871 | 809871 | 2020-12-08 | Prince William | Virginia | 51153 | 19766 | 236 |
806626 | 806626 | 2020-12-07 | Prince William | Virginia | 51153 | 19498 | 235 |
803381 | 803381 | 2020-12-06 | Prince William | Virginia | 51153 | 19404 | 235 |
800136 | 800136 | 2020-12-05 | Prince William | Virginia | 51153 | 19161 | 235 |
796891 | 796891 | 2020-12-04 | Prince William | Virginia | 51153 | 18968 | 235 |
793646 | 793646 | 2020-12-03 | Prince William | Virginia | 51153 | 18852 | 235 |
790401 | 790401 | 2020-12-02 | Prince William | Virginia | 51153 | 18662 | 235 |
787156 | 787156 | 2020-12-01 | Prince William | Virginia | 51153 | 18490 | 235 |
783912 | 783912 | 2020-11-30 | Prince William | Virginia | 51153 | 18352 | 235 |
780667 | 780667 | 2020-11-29 | Prince William | Virginia | 51153 | 18199 | 235 |
777421 | 777421 | 2020-11-28 | Prince William | Virginia | 51153 | 18105 | 235 |
774176 | 774176 | 2020-11-27 | Prince William | Virginia | 51153 | 17863 | 236 |
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);