ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 51059 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280506 | 1280506 | 2021-05-02 | Fairfax | Virginia | 51059 | 75942 | 1073 |
1277259 | 1277259 | 2021-05-01 | Fairfax | Virginia | 51059 | 75862 | 1073 |
1274012 | 1274012 | 2021-04-30 | Fairfax | Virginia | 51059 | 75783 | 1073 |
1270765 | 1270765 | 2021-04-29 | Fairfax | Virginia | 51059 | 75680 | 1072 |
1267518 | 1267518 | 2021-04-28 | Fairfax | Virginia | 51059 | 75581 | 1070 |
1264271 | 1264271 | 2021-04-27 | Fairfax | Virginia | 51059 | 75478 | 1070 |
1261024 | 1261024 | 2021-04-26 | Fairfax | Virginia | 51059 | 75417 | 1068 |
1257777 | 1257777 | 2021-04-25 | Fairfax | Virginia | 51059 | 75344 | 1067 |
1254530 | 1254530 | 2021-04-24 | Fairfax | Virginia | 51059 | 75244 | 1067 |
1251283 | 1251283 | 2021-04-23 | Fairfax | Virginia | 51059 | 75166 | 1067 |
1248036 | 1248036 | 2021-04-22 | Fairfax | Virginia | 51059 | 74988 | 1067 |
1244789 | 1244789 | 2021-04-21 | Fairfax | Virginia | 51059 | 74840 | 1065 |
1241542 | 1241542 | 2021-04-20 | Fairfax | Virginia | 51059 | 74708 | 1064 |
1238295 | 1238295 | 2021-04-19 | Fairfax | Virginia | 51059 | 74610 | 1063 |
1235048 | 1235048 | 2021-04-18 | Fairfax | Virginia | 51059 | 74499 | 1061 |
1231800 | 1231800 | 2021-04-17 | Fairfax | Virginia | 51059 | 74321 | 1059 |
1228552 | 1228552 | 2021-04-16 | Fairfax | Virginia | 51059 | 74175 | 1059 |
1225304 | 1225304 | 2021-04-15 | Fairfax | Virginia | 51059 | 74009 | 1058 |
1222057 | 1222057 | 2021-04-14 | Fairfax | Virginia | 51059 | 73841 | 1056 |
1218809 | 1218809 | 2021-04-13 | Fairfax | Virginia | 51059 | 73751 | 1055 |
1215561 | 1215561 | 2021-04-12 | Fairfax | Virginia | 51059 | 73520 | 1054 |
1212314 | 1212314 | 2021-04-11 | Fairfax | Virginia | 51059 | 73326 | 1053 |
1209065 | 1209065 | 2021-04-10 | Fairfax | Virginia | 51059 | 73156 | 1052 |
1205817 | 1205817 | 2021-04-09 | Fairfax | Virginia | 51059 | 72948 | 1051 |
1202569 | 1202569 | 2021-04-08 | Fairfax | Virginia | 51059 | 72781 | 1049 |
1199321 | 1199321 | 2021-04-07 | Fairfax | Virginia | 51059 | 72551 | 1049 |
1196072 | 1196072 | 2021-04-06 | Fairfax | Virginia | 51059 | 72390 | 1048 |
1192824 | 1192824 | 2021-04-05 | Fairfax | Virginia | 51059 | 72250 | 1045 |
1189574 | 1189574 | 2021-04-04 | Fairfax | Virginia | 51059 | 72127 | 1041 |
1186327 | 1186327 | 2021-04-03 | Fairfax | Virginia | 51059 | 71971 | 1040 |
1183080 | 1183080 | 2021-04-02 | Fairfax | Virginia | 51059 | 71805 | 1039 |
1179833 | 1179833 | 2021-04-01 | Fairfax | Virginia | 51059 | 71661 | 1040 |
1176586 | 1176586 | 2021-03-31 | Fairfax | Virginia | 51059 | 71411 | 1040 |
1173339 | 1173339 | 2021-03-30 | Fairfax | Virginia | 51059 | 71314 | 1038 |
1170092 | 1170092 | 2021-03-29 | Fairfax | Virginia | 51059 | 71199 | 1038 |
1166844 | 1166844 | 2021-03-28 | Fairfax | Virginia | 51059 | 71049 | 1036 |
1163596 | 1163596 | 2021-03-27 | Fairfax | Virginia | 51059 | 70898 | 1036 |
1160348 | 1160348 | 2021-03-26 | Fairfax | Virginia | 51059 | 70678 | 1034 |
1157100 | 1157100 | 2021-03-25 | Fairfax | Virginia | 51059 | 70426 | 1034 |
1153853 | 1153853 | 2021-03-24 | Fairfax | Virginia | 51059 | 70233 | 1033 |
1150606 | 1150606 | 2021-03-23 | Fairfax | Virginia | 51059 | 70096 | 1034 |
1147359 | 1147359 | 2021-03-22 | Fairfax | Virginia | 51059 | 69978 | 1038 |
1144112 | 1144112 | 2021-03-21 | Fairfax | Virginia | 51059 | 69859 | 1037 |
1140865 | 1140865 | 2021-03-20 | Fairfax | Virginia | 51059 | 69708 | 1035 |
1137619 | 1137619 | 2021-03-19 | Fairfax | Virginia | 51059 | 69514 | 1035 |
1134373 | 1134373 | 2021-03-18 | Fairfax | Virginia | 51059 | 69316 | 1040 |
1131125 | 1131125 | 2021-03-17 | Fairfax | Virginia | 51059 | 69041 | 1040 |
1127878 | 1127878 | 2021-03-16 | Fairfax | Virginia | 51059 | 68891 | 1033 |
1124632 | 1124632 | 2021-03-15 | Fairfax | Virginia | 51059 | 68755 | 1032 |
1121386 | 1121386 | 2021-03-14 | Fairfax | Virginia | 51059 | 68641 | 1029 |
1118139 | 1118139 | 2021-03-13 | Fairfax | Virginia | 51059 | 68491 | 1032 |
1114892 | 1114892 | 2021-03-12 | Fairfax | Virginia | 51059 | 68346 | 1031 |
1111646 | 1111646 | 2021-03-11 | Fairfax | Virginia | 51059 | 68208 | 1027 |
1108400 | 1108400 | 2021-03-10 | Fairfax | Virginia | 51059 | 68069 | 1027 |
1105154 | 1105154 | 2021-03-09 | Fairfax | Virginia | 51059 | 67945 | 1025 |
1101908 | 1101908 | 2021-03-08 | Fairfax | Virginia | 51059 | 67820 | 1012 |
1098662 | 1098662 | 2021-03-07 | Fairfax | Virginia | 51059 | 67693 | 1005 |
1095414 | 1095414 | 2021-03-06 | Fairfax | Virginia | 51059 | 67533 | 995 |
1092168 | 1092168 | 2021-03-05 | Fairfax | Virginia | 51059 | 67399 | 990 |
1088922 | 1088922 | 2021-03-04 | Fairfax | Virginia | 51059 | 67192 | 985 |
1085677 | 1085677 | 2021-03-03 | Fairfax | Virginia | 51059 | 67003 | 985 |
1082431 | 1082431 | 2021-03-02 | Fairfax | Virginia | 51059 | 66825 | 956 |
1079185 | 1079185 | 2021-03-01 | Fairfax | Virginia | 51059 | 66703 | 949 |
1075940 | 1075940 | 2021-02-28 | Fairfax | Virginia | 51059 | 66573 | 930 |
1072694 | 1072694 | 2021-02-27 | Fairfax | Virginia | 51059 | 66354 | 920 |
1069448 | 1069448 | 2021-02-26 | Fairfax | Virginia | 51059 | 66198 | 908 |
1066203 | 1066203 | 2021-02-25 | Fairfax | Virginia | 51059 | 65970 | 889 |
1062958 | 1062958 | 2021-02-24 | Fairfax | Virginia | 51059 | 65718 | 880 |
1059713 | 1059713 | 2021-02-23 | Fairfax | Virginia | 51059 | 65469 | 870 |
1056467 | 1056467 | 2021-02-22 | Fairfax | Virginia | 51059 | 65317 | 859 |
1053221 | 1053221 | 2021-02-21 | Fairfax | Virginia | 51059 | 65204 | 851 |
1049974 | 1049974 | 2021-02-20 | Fairfax | Virginia | 51059 | 64921 | 841 |
1046727 | 1046727 | 2021-02-19 | Fairfax | Virginia | 51059 | 64750 | 834 |
1043482 | 1043482 | 2021-02-18 | Fairfax | Virginia | 51059 | 64568 | 834 |
1040237 | 1040237 | 2021-02-17 | Fairfax | Virginia | 51059 | 64355 | 834 |
1036992 | 1036992 | 2021-02-16 | Fairfax | Virginia | 51059 | 64154 | 830 |
1033747 | 1033747 | 2021-02-15 | Fairfax | Virginia | 51059 | 63965 | 829 |
1030501 | 1030501 | 2021-02-14 | Fairfax | Virginia | 51059 | 63800 | 829 |
1027254 | 1027254 | 2021-02-13 | Fairfax | Virginia | 51059 | 63545 | 828 |
1024009 | 1024009 | 2021-02-12 | Fairfax | Virginia | 51059 | 63148 | 827 |
1020764 | 1020764 | 2021-02-11 | Fairfax | Virginia | 51059 | 62854 | 826 |
1017519 | 1017519 | 2021-02-10 | Fairfax | Virginia | 51059 | 62445 | 821 |
1014274 | 1014274 | 2021-02-09 | Fairfax | Virginia | 51059 | 61967 | 816 |
1011029 | 1011029 | 2021-02-08 | Fairfax | Virginia | 51059 | 61743 | 807 |
1007783 | 1007783 | 2021-02-07 | Fairfax | Virginia | 51059 | 61654 | 807 |
1004537 | 1004537 | 2021-02-06 | Fairfax | Virginia | 51059 | 61425 | 807 |
1001291 | 1001291 | 2021-02-05 | Fairfax | Virginia | 51059 | 60902 | 803 |
998045 | 998045 | 2021-02-04 | Fairfax | Virginia | 51059 | 60495 | 798 |
994799 | 994799 | 2021-02-03 | Fairfax | Virginia | 51059 | 60265 | 792 |
991553 | 991553 | 2021-02-02 | Fairfax | Virginia | 51059 | 59960 | 788 |
988307 | 988307 | 2021-02-01 | Fairfax | Virginia | 51059 | 59717 | 784 |
985060 | 985060 | 2021-01-31 | Fairfax | Virginia | 51059 | 59481 | 784 |
981813 | 981813 | 2021-01-30 | Fairfax | Virginia | 51059 | 59281 | 784 |
978567 | 978567 | 2021-01-29 | Fairfax | Virginia | 51059 | 58835 | 782 |
975322 | 975322 | 2021-01-28 | Fairfax | Virginia | 51059 | 58501 | 772 |
972077 | 972077 | 2021-01-27 | Fairfax | Virginia | 51059 | 58092 | 762 |
968832 | 968832 | 2021-01-26 | Fairfax | Virginia | 51059 | 57559 | 760 |
965588 | 965588 | 2021-01-25 | Fairfax | Virginia | 51059 | 57164 | 752 |
962343 | 962343 | 2021-01-24 | Fairfax | Virginia | 51059 | 56475 | 752 |
959098 | 959098 | 2021-01-23 | Fairfax | Virginia | 51059 | 56139 | 753 |
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);