ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 51179 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095494 | 1095494 | 2021-03-06 | Stafford | Virginia | 51179 | 9659 | 68 |
1092248 | 1092248 | 2021-03-05 | Stafford | Virginia | 51179 | 9649 | 68 |
1089002 | 1089002 | 2021-03-04 | Stafford | Virginia | 51179 | 9653 | 68 |
1085757 | 1085757 | 2021-03-03 | Stafford | Virginia | 51179 | 9644 | 68 |
1082511 | 1082511 | 2021-03-02 | Stafford | Virginia | 51179 | 9620 | 68 |
1079265 | 1079265 | 2021-03-01 | Stafford | Virginia | 51179 | 9582 | 67 |
1076020 | 1076020 | 2021-02-28 | Stafford | Virginia | 51179 | 9555 | 67 |
1072774 | 1072774 | 2021-02-27 | Stafford | Virginia | 51179 | 9491 | 66 |
1069528 | 1069528 | 2021-02-26 | Stafford | Virginia | 51179 | 9479 | 66 |
1066283 | 1066283 | 2021-02-25 | Stafford | Virginia | 51179 | 9448 | 65 |
1063038 | 1063038 | 2021-02-24 | Stafford | Virginia | 51179 | 9418 | 65 |
1059793 | 1059793 | 2021-02-23 | Stafford | Virginia | 51179 | 9368 | 64 |
1056547 | 1056547 | 2021-02-22 | Stafford | Virginia | 51179 | 9341 | 61 |
1053301 | 1053301 | 2021-02-21 | Stafford | Virginia | 51179 | 9333 | 58 |
1050054 | 1050054 | 2021-02-20 | Stafford | Virginia | 51179 | 9320 | 55 |
1046807 | 1046807 | 2021-02-19 | Stafford | Virginia | 51179 | 9312 | 55 |
1043562 | 1043562 | 2021-02-18 | Stafford | Virginia | 51179 | 9290 | 55 |
1040317 | 1040317 | 2021-02-17 | Stafford | Virginia | 51179 | 9252 | 54 |
1037072 | 1037072 | 2021-02-16 | Stafford | Virginia | 51179 | 9199 | 54 |
1033827 | 1033827 | 2021-02-15 | Stafford | Virginia | 51179 | 9159 | 54 |
1030581 | 1030581 | 2021-02-14 | Stafford | Virginia | 51179 | 9140 | 54 |
1027334 | 1027334 | 2021-02-13 | Stafford | Virginia | 51179 | 9061 | 54 |
1024089 | 1024089 | 2021-02-12 | Stafford | Virginia | 51179 | 9015 | 54 |
1020844 | 1020844 | 2021-02-11 | Stafford | Virginia | 51179 | 8839 | 53 |
1017599 | 1017599 | 2021-02-10 | Stafford | Virginia | 51179 | 8727 | 53 |
1014354 | 1014354 | 2021-02-09 | Stafford | Virginia | 51179 | 8623 | 53 |
1011109 | 1011109 | 2021-02-08 | Stafford | Virginia | 51179 | 8554 | 52 |
1007863 | 1007863 | 2021-02-07 | Stafford | Virginia | 51179 | 8525 | 52 |
1004617 | 1004617 | 2021-02-06 | Stafford | Virginia | 51179 | 8490 | 52 |
1001371 | 1001371 | 2021-02-05 | Stafford | Virginia | 51179 | 8299 | 51 |
998125 | 998125 | 2021-02-04 | Stafford | Virginia | 51179 | 8183 | 50 |
994879 | 994879 | 2021-02-03 | Stafford | Virginia | 51179 | 8123 | 50 |
991633 | 991633 | 2021-02-02 | Stafford | Virginia | 51179 | 8058 | 50 |
988387 | 988387 | 2021-02-01 | Stafford | Virginia | 51179 | 8005 | 48 |
985140 | 985140 | 2021-01-31 | Stafford | Virginia | 51179 | 7956 | 48 |
981893 | 981893 | 2021-01-30 | Stafford | Virginia | 51179 | 7909 | 48 |
978647 | 978647 | 2021-01-29 | Stafford | Virginia | 51179 | 7766 | 46 |
975402 | 975402 | 2021-01-28 | Stafford | Virginia | 51179 | 7687 | 46 |
972157 | 972157 | 2021-01-27 | Stafford | Virginia | 51179 | 7586 | 45 |
968912 | 968912 | 2021-01-26 | Stafford | Virginia | 51179 | 7489 | 44 |
965668 | 965668 | 2021-01-25 | Stafford | Virginia | 51179 | 7341 | 42 |
962423 | 962423 | 2021-01-24 | Stafford | Virginia | 51179 | 7210 | 42 |
959178 | 959178 | 2021-01-23 | Stafford | Virginia | 51179 | 7169 | 42 |
955932 | 955932 | 2021-01-22 | Stafford | Virginia | 51179 | 7080 | 41 |
952687 | 952687 | 2021-01-21 | Stafford | Virginia | 51179 | 6992 | 37 |
949442 | 949442 | 2021-01-20 | Stafford | Virginia | 51179 | 6948 | 36 |
946196 | 946196 | 2021-01-19 | Stafford | Virginia | 51179 | 6887 | 35 |
942949 | 942949 | 2021-01-18 | Stafford | Virginia | 51179 | 6759 | 34 |
939704 | 939704 | 2021-01-17 | Stafford | Virginia | 51179 | 6636 | 34 |
936459 | 936459 | 2021-01-16 | Stafford | Virginia | 51179 | 6535 | 34 |
933214 | 933214 | 2021-01-15 | Stafford | Virginia | 51179 | 6425 | 32 |
929969 | 929969 | 2021-01-14 | Stafford | Virginia | 51179 | 6270 | 31 |
926724 | 926724 | 2021-01-13 | Stafford | Virginia | 51179 | 6192 | 30 |
923478 | 923478 | 2021-01-12 | Stafford | Virginia | 51179 | 6124 | 30 |
920233 | 920233 | 2021-01-11 | Stafford | Virginia | 51179 | 6050 | 29 |
916988 | 916988 | 2021-01-10 | Stafford | Virginia | 51179 | 5972 | 29 |
913743 | 913743 | 2021-01-09 | Stafford | Virginia | 51179 | 5876 | 29 |
910498 | 910498 | 2021-01-08 | Stafford | Virginia | 51179 | 5848 | 27 |
907253 | 907253 | 2021-01-07 | Stafford | Virginia | 51179 | 5788 | 26 |
904007 | 904007 | 2021-01-06 | Stafford | Virginia | 51179 | 5684 | 26 |
900762 | 900762 | 2021-01-05 | Stafford | Virginia | 51179 | 5559 | 25 |
897517 | 897517 | 2021-01-04 | Stafford | Virginia | 51179 | 5481 | 25 |
894271 | 894271 | 2021-01-03 | Stafford | Virginia | 51179 | 5418 | 25 |
891025 | 891025 | 2021-01-02 | Stafford | Virginia | 51179 | 5387 | 25 |
887778 | 887778 | 2021-01-01 | Stafford | Virginia | 51179 | 5284 | 25 |
884533 | 884533 | 2020-12-31 | Stafford | Virginia | 51179 | 5221 | 24 |
881288 | 881288 | 2020-12-30 | Stafford | Virginia | 51179 | 5099 | 24 |
878043 | 878043 | 2020-12-29 | Stafford | Virginia | 51179 | 5036 | 24 |
874798 | 874798 | 2020-12-28 | Stafford | Virginia | 51179 | 4930 | 23 |
871553 | 871553 | 2020-12-27 | Stafford | Virginia | 51179 | 4891 | 23 |
868308 | 868308 | 2020-12-26 | Stafford | Virginia | 51179 | 4886 | 23 |
865063 | 865063 | 2020-12-25 | Stafford | Virginia | 51179 | 4883 | 23 |
861818 | 861818 | 2020-12-24 | Stafford | Virginia | 51179 | 4769 | 23 |
858573 | 858573 | 2020-12-23 | Stafford | Virginia | 51179 | 4659 | 23 |
855328 | 855328 | 2020-12-22 | Stafford | Virginia | 51179 | 4578 | 23 |
852083 | 852083 | 2020-12-21 | Stafford | Virginia | 51179 | 4520 | 23 |
848838 | 848838 | 2020-12-20 | Stafford | Virginia | 51179 | 4371 | 23 |
845593 | 845593 | 2020-12-19 | Stafford | Virginia | 51179 | 4335 | 23 |
842347 | 842347 | 2020-12-18 | Stafford | Virginia | 51179 | 4307 | 23 |
839102 | 839102 | 2020-12-17 | Stafford | Virginia | 51179 | 4257 | 23 |
835856 | 835856 | 2020-12-16 | Stafford | Virginia | 51179 | 4207 | 23 |
832610 | 832610 | 2020-12-15 | Stafford | Virginia | 51179 | 4145 | 23 |
829363 | 829363 | 2020-12-14 | Stafford | Virginia | 51179 | 4105 | 22 |
826117 | 826117 | 2020-12-13 | Stafford | Virginia | 51179 | 4003 | 22 |
822870 | 822870 | 2020-12-12 | Stafford | Virginia | 51179 | 4007 | 22 |
819624 | 819624 | 2020-12-11 | Stafford | Virginia | 51179 | 3925 | 22 |
816378 | 816378 | 2020-12-10 | Stafford | Virginia | 51179 | 3876 | 22 |
813132 | 813132 | 2020-12-09 | Stafford | Virginia | 51179 | 3811 | 22 |
809888 | 809888 | 2020-12-08 | Stafford | Virginia | 51179 | 3750 | 22 |
806643 | 806643 | 2020-12-07 | Stafford | Virginia | 51179 | 3724 | 22 |
803398 | 803398 | 2020-12-06 | Stafford | Virginia | 51179 | 3615 | 22 |
800153 | 800153 | 2020-12-05 | Stafford | Virginia | 51179 | 3536 | 22 |
796908 | 796908 | 2020-12-04 | Stafford | Virginia | 51179 | 3458 | 22 |
793663 | 793663 | 2020-12-03 | Stafford | Virginia | 51179 | 3388 | 22 |
790418 | 790418 | 2020-12-02 | Stafford | Virginia | 51179 | 3366 | 22 |
787173 | 787173 | 2020-12-01 | Stafford | Virginia | 51179 | 3330 | 22 |
783929 | 783929 | 2020-11-30 | Stafford | Virginia | 51179 | 3306 | 22 |
780684 | 780684 | 2020-11-29 | Stafford | Virginia | 51179 | 3291 | 22 |
777438 | 777438 | 2020-11-28 | Stafford | Virginia | 51179 | 3279 | 22 |
774193 | 774193 | 2020-11-27 | Stafford | Virginia | 51179 | 3215 | 22 |
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);