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 |
---|---|---|---|---|---|---|---|
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 |
770931 | 770931 | 2020-11-26 | Prince William | Virginia | 51153 | 17704 | 237 |
767685 | 767685 | 2020-11-25 | Prince William | Virginia | 51153 | 17484 | 236 |
764440 | 764440 | 2020-11-24 | Prince William | Virginia | 51153 | 17158 | 234 |
761195 | 761195 | 2020-11-23 | Prince William | Virginia | 51153 | 16962 | 232 |
757950 | 757950 | 2020-11-22 | Prince William | Virginia | 51153 | 16771 | 232 |
754703 | 754703 | 2020-11-21 | Prince William | Virginia | 51153 | 16724 | 232 |
751457 | 751457 | 2020-11-20 | Prince William | Virginia | 51153 | 16595 | 231 |
748211 | 748211 | 2020-11-19 | Prince William | Virginia | 51153 | 16429 | 231 |
744965 | 744965 | 2020-11-18 | Prince William | Virginia | 51153 | 16283 | 230 |
741718 | 741718 | 2020-11-17 | Prince William | Virginia | 51153 | 16123 | 229 |
738471 | 738471 | 2020-11-16 | Prince William | Virginia | 51153 | 15979 | 229 |
735227 | 735227 | 2020-11-15 | Prince William | Virginia | 51153 | 15777 | 229 |
731981 | 731981 | 2020-11-14 | Prince William | Virginia | 51153 | 15720 | 229 |
728736 | 728736 | 2020-11-13 | Prince William | Virginia | 51153 | 15648 | 228 |
725493 | 725493 | 2020-11-12 | Prince William | Virginia | 51153 | 15546 | 228 |
722250 | 722250 | 2020-11-11 | Prince William | Virginia | 51153 | 15462 | 227 |
719007 | 719007 | 2020-11-10 | Prince William | Virginia | 51153 | 15367 | 226 |
715764 | 715764 | 2020-11-09 | Prince William | Virginia | 51153 | 15286 | 224 |
712520 | 712520 | 2020-11-08 | Prince William | Virginia | 51153 | 15208 | 224 |
709276 | 709276 | 2020-11-07 | Prince William | Virginia | 51153 | 15099 | 224 |
706032 | 706032 | 2020-11-06 | Prince William | Virginia | 51153 | 15013 | 224 |
702789 | 702789 | 2020-11-05 | Prince William | Virginia | 51153 | 14923 | 223 |
699546 | 699546 | 2020-11-04 | Prince William | Virginia | 51153 | 14833 | 223 |
696302 | 696302 | 2020-11-03 | Prince William | Virginia | 51153 | 14768 | 223 |
693060 | 693060 | 2020-11-02 | Prince William | Virginia | 51153 | 14660 | 223 |
689816 | 689816 | 2020-11-01 | Prince William | Virginia | 51153 | 14554 | 223 |
686571 | 686571 | 2020-10-31 | Prince William | Virginia | 51153 | 14513 | 223 |
683328 | 683328 | 2020-10-30 | Prince William | Virginia | 51153 | 14447 | 223 |
680085 | 680085 | 2020-10-29 | Prince William | Virginia | 51153 | 14350 | 223 |
676842 | 676842 | 2020-10-28 | Prince William | Virginia | 51153 | 14235 | 223 |
673599 | 673599 | 2020-10-27 | Prince William | Virginia | 51153 | 14162 | 223 |
670357 | 670357 | 2020-10-26 | Prince William | Virginia | 51153 | 14015 | 223 |
667114 | 667114 | 2020-10-25 | Prince William | Virginia | 51153 | 13984 | 223 |
663869 | 663869 | 2020-10-24 | Prince William | Virginia | 51153 | 13949 | 223 |
660625 | 660625 | 2020-10-23 | Prince William | Virginia | 51153 | 13912 | 223 |
657381 | 657381 | 2020-10-22 | Prince William | Virginia | 51153 | 13832 | 223 |
654136 | 654136 | 2020-10-21 | Prince William | Virginia | 51153 | 13735 | 222 |
650891 | 650891 | 2020-10-20 | Prince William | Virginia | 51153 | 13674 | 221 |
647647 | 647647 | 2020-10-19 | Prince William | Virginia | 51153 | 13612 | 218 |
644401 | 644401 | 2020-10-18 | Prince William | Virginia | 51153 | 13556 | 217 |
641153 | 641153 | 2020-10-17 | Prince William | Virginia | 51153 | 13493 | 217 |
637906 | 637906 | 2020-10-16 | Prince William | Virginia | 51153 | 13451 | 216 |
634661 | 634661 | 2020-10-15 | Prince William | Virginia | 51153 | 13390 | 216 |
631416 | 631416 | 2020-10-14 | Prince William | Virginia | 51153 | 13311 | 216 |
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);