ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 51199 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095509 | 1095509 | 2021-03-06 | York | Virginia | 51199 | 3104 | 39 |
1092263 | 1092263 | 2021-03-05 | York | Virginia | 51199 | 3082 | 38 |
1089017 | 1089017 | 2021-03-04 | York | Virginia | 51199 | 3059 | 38 |
1085772 | 1085772 | 2021-03-03 | York | Virginia | 51199 | 3054 | 38 |
1082526 | 1082526 | 2021-03-02 | York | Virginia | 51199 | 3037 | 35 |
1079280 | 1079280 | 2021-03-01 | York | Virginia | 51199 | 3011 | 33 |
1076035 | 1076035 | 2021-02-28 | York | Virginia | 51199 | 3008 | 30 |
1072789 | 1072789 | 2021-02-27 | York | Virginia | 51199 | 3000 | 30 |
1069543 | 1069543 | 2021-02-26 | York | Virginia | 51199 | 2990 | 30 |
1066298 | 1066298 | 2021-02-25 | York | Virginia | 51199 | 2984 | 29 |
1063053 | 1063053 | 2021-02-24 | York | Virginia | 51199 | 2967 | 29 |
1059808 | 1059808 | 2021-02-23 | York | Virginia | 51199 | 2952 | 27 |
1056562 | 1056562 | 2021-02-22 | York | Virginia | 51199 | 2932 | 26 |
1053316 | 1053316 | 2021-02-21 | York | Virginia | 51199 | 2924 | 23 |
1050069 | 1050069 | 2021-02-20 | York | Virginia | 51199 | 2897 | 21 |
1046822 | 1046822 | 2021-02-19 | York | Virginia | 51199 | 2895 | 22 |
1043577 | 1043577 | 2021-02-18 | York | Virginia | 51199 | 2878 | 22 |
1040332 | 1040332 | 2021-02-17 | York | Virginia | 51199 | 2872 | 22 |
1037087 | 1037087 | 2021-02-16 | York | Virginia | 51199 | 2849 | 22 |
1033842 | 1033842 | 2021-02-15 | York | Virginia | 51199 | 2840 | 21 |
1030596 | 1030596 | 2021-02-14 | York | Virginia | 51199 | 2832 | 21 |
1027349 | 1027349 | 2021-02-13 | York | Virginia | 51199 | 2809 | 21 |
1024104 | 1024104 | 2021-02-12 | York | Virginia | 51199 | 2790 | 21 |
1020859 | 1020859 | 2021-02-11 | York | Virginia | 51199 | 2774 | 21 |
1017614 | 1017614 | 2021-02-10 | York | Virginia | 51199 | 2755 | 21 |
1014369 | 1014369 | 2021-02-09 | York | Virginia | 51199 | 2743 | 21 |
1011124 | 1011124 | 2021-02-08 | York | Virginia | 51199 | 2728 | 19 |
1007878 | 1007878 | 2021-02-07 | York | Virginia | 51199 | 2701 | 18 |
1004632 | 1004632 | 2021-02-06 | York | Virginia | 51199 | 2672 | 18 |
1001386 | 1001386 | 2021-02-05 | York | Virginia | 51199 | 2643 | 17 |
998140 | 998140 | 2021-02-04 | York | Virginia | 51199 | 2602 | 17 |
994894 | 994894 | 2021-02-03 | York | Virginia | 51199 | 2592 | 16 |
991648 | 991648 | 2021-02-02 | York | Virginia | 51199 | 2574 | 16 |
988402 | 988402 | 2021-02-01 | York | Virginia | 51199 | 2559 | 16 |
985155 | 985155 | 2021-01-31 | York | Virginia | 51199 | 2548 | 16 |
981908 | 981908 | 2021-01-30 | York | Virginia | 51199 | 2534 | 16 |
978662 | 978662 | 2021-01-29 | York | Virginia | 51199 | 2514 | 16 |
975417 | 975417 | 2021-01-28 | York | Virginia | 51199 | 2485 | 16 |
972172 | 972172 | 2021-01-27 | York | Virginia | 51199 | 2448 | 16 |
968927 | 968927 | 2021-01-26 | York | Virginia | 51199 | 2397 | 16 |
965683 | 965683 | 2021-01-25 | York | Virginia | 51199 | 2347 | 16 |
962438 | 962438 | 2021-01-24 | York | Virginia | 51199 | 2287 | 16 |
959193 | 959193 | 2021-01-23 | York | Virginia | 51199 | 2253 | 16 |
955947 | 955947 | 2021-01-22 | York | Virginia | 51199 | 2198 | 15 |
952702 | 952702 | 2021-01-21 | York | Virginia | 51199 | 2175 | 15 |
949457 | 949457 | 2021-01-20 | York | Virginia | 51199 | 2137 | 13 |
946211 | 946211 | 2021-01-19 | York | Virginia | 51199 | 2099 | 13 |
942964 | 942964 | 2021-01-18 | York | Virginia | 51199 | 2077 | 13 |
939719 | 939719 | 2021-01-17 | York | Virginia | 51199 | 2040 | 13 |
936474 | 936474 | 2021-01-16 | York | Virginia | 51199 | 1999 | 13 |
933229 | 933229 | 2021-01-15 | York | Virginia | 51199 | 1956 | 13 |
929984 | 929984 | 2021-01-14 | York | Virginia | 51199 | 1919 | 13 |
926739 | 926739 | 2021-01-13 | York | Virginia | 51199 | 1899 | 13 |
923493 | 923493 | 2021-01-12 | York | Virginia | 51199 | 1886 | 13 |
920248 | 920248 | 2021-01-11 | York | Virginia | 51199 | 1843 | 13 |
917003 | 917003 | 2021-01-10 | York | Virginia | 51199 | 1801 | 13 |
913758 | 913758 | 2021-01-09 | York | Virginia | 51199 | 1757 | 13 |
910513 | 910513 | 2021-01-08 | York | Virginia | 51199 | 1729 | 13 |
907268 | 907268 | 2021-01-07 | York | Virginia | 51199 | 1701 | 13 |
904022 | 904022 | 2021-01-06 | York | Virginia | 51199 | 1661 | 13 |
900777 | 900777 | 2021-01-05 | York | Virginia | 51199 | 1634 | 13 |
897532 | 897532 | 2021-01-04 | York | Virginia | 51199 | 1601 | 13 |
894286 | 894286 | 2021-01-03 | York | Virginia | 51199 | 1566 | 13 |
891040 | 891040 | 2021-01-02 | York | Virginia | 51199 | 1493 | 13 |
887793 | 887793 | 2021-01-01 | York | Virginia | 51199 | 1491 | 13 |
884548 | 884548 | 2020-12-31 | York | Virginia | 51199 | 1472 | 12 |
881303 | 881303 | 2020-12-30 | York | Virginia | 51199 | 1452 | 12 |
878058 | 878058 | 2020-12-29 | York | Virginia | 51199 | 1441 | 11 |
874813 | 874813 | 2020-12-28 | York | Virginia | 51199 | 1397 | 11 |
871568 | 871568 | 2020-12-27 | York | Virginia | 51199 | 1372 | 11 |
868323 | 868323 | 2020-12-26 | York | Virginia | 51199 | 1368 | 11 |
865078 | 865078 | 2020-12-25 | York | Virginia | 51199 | 1367 | 11 |
861833 | 861833 | 2020-12-24 | York | Virginia | 51199 | 1362 | 11 |
858588 | 858588 | 2020-12-23 | York | Virginia | 51199 | 1334 | 11 |
855343 | 855343 | 2020-12-22 | York | Virginia | 51199 | 1306 | 10 |
852098 | 852098 | 2020-12-21 | York | Virginia | 51199 | 1276 | 10 |
848853 | 848853 | 2020-12-20 | York | Virginia | 51199 | 1262 | 10 |
845608 | 845608 | 2020-12-19 | York | Virginia | 51199 | 1241 | 10 |
842362 | 842362 | 2020-12-18 | York | Virginia | 51199 | 1213 | 10 |
839117 | 839117 | 2020-12-17 | York | Virginia | 51199 | 1181 | 9 |
835871 | 835871 | 2020-12-16 | York | Virginia | 51199 | 1159 | 9 |
832625 | 832625 | 2020-12-15 | York | Virginia | 51199 | 1129 | 9 |
829378 | 829378 | 2020-12-14 | York | Virginia | 51199 | 1105 | 9 |
826132 | 826132 | 2020-12-13 | York | Virginia | 51199 | 1089 | 9 |
822885 | 822885 | 2020-12-12 | York | Virginia | 51199 | 1069 | 9 |
819639 | 819639 | 2020-12-11 | York | Virginia | 51199 | 1046 | 9 |
816393 | 816393 | 2020-12-10 | York | Virginia | 51199 | 1038 | 9 |
813147 | 813147 | 2020-12-09 | York | Virginia | 51199 | 1023 | 9 |
809903 | 809903 | 2020-12-08 | York | Virginia | 51199 | 1012 | 9 |
806658 | 806658 | 2020-12-07 | York | Virginia | 51199 | 1007 | 9 |
803413 | 803413 | 2020-12-06 | York | Virginia | 51199 | 992 | 9 |
800168 | 800168 | 2020-12-05 | York | Virginia | 51199 | 975 | 9 |
796923 | 796923 | 2020-12-04 | York | Virginia | 51199 | 968 | 9 |
793678 | 793678 | 2020-12-03 | York | Virginia | 51199 | 957 | 9 |
790433 | 790433 | 2020-12-02 | York | Virginia | 51199 | 950 | 9 |
787188 | 787188 | 2020-12-01 | York | Virginia | 51199 | 929 | 9 |
783944 | 783944 | 2020-11-30 | York | Virginia | 51199 | 921 | 9 |
780699 | 780699 | 2020-11-29 | York | Virginia | 51199 | 908 | 9 |
777453 | 777453 | 2020-11-28 | York | Virginia | 51199 | 889 | 9 |
774208 | 774208 | 2020-11-27 | York | Virginia | 51199 | 877 | 9 |
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);