ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 51107 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280539 | 1280539 | 2021-05-02 | Loudoun | Virginia | 51107 | 27391 | 274 |
1277292 | 1277292 | 2021-05-01 | Loudoun | Virginia | 51107 | 27358 | 274 |
1274045 | 1274045 | 2021-04-30 | Loudoun | Virginia | 51107 | 27309 | 274 |
1270798 | 1270798 | 2021-04-29 | Loudoun | Virginia | 51107 | 27259 | 274 |
1267551 | 1267551 | 2021-04-28 | Loudoun | Virginia | 51107 | 27202 | 274 |
1264304 | 1264304 | 2021-04-27 | Loudoun | Virginia | 51107 | 27159 | 274 |
1261057 | 1261057 | 2021-04-26 | Loudoun | Virginia | 51107 | 27104 | 274 |
1257810 | 1257810 | 2021-04-25 | Loudoun | Virginia | 51107 | 27077 | 274 |
1254563 | 1254563 | 2021-04-24 | Loudoun | Virginia | 51107 | 27043 | 274 |
1251316 | 1251316 | 2021-04-23 | Loudoun | Virginia | 51107 | 26997 | 274 |
1248069 | 1248069 | 2021-04-22 | Loudoun | Virginia | 51107 | 26928 | 274 |
1244822 | 1244822 | 2021-04-21 | Loudoun | Virginia | 51107 | 26849 | 274 |
1241575 | 1241575 | 2021-04-20 | Loudoun | Virginia | 51107 | 26795 | 274 |
1238328 | 1238328 | 2021-04-19 | Loudoun | Virginia | 51107 | 26736 | 274 |
1235081 | 1235081 | 2021-04-18 | Loudoun | Virginia | 51107 | 26694 | 274 |
1231833 | 1231833 | 2021-04-17 | Loudoun | Virginia | 51107 | 26645 | 274 |
1228585 | 1228585 | 2021-04-16 | Loudoun | Virginia | 51107 | 26569 | 273 |
1225337 | 1225337 | 2021-04-15 | Loudoun | Virginia | 51107 | 26488 | 273 |
1222090 | 1222090 | 2021-04-14 | Loudoun | Virginia | 51107 | 26430 | 273 |
1218842 | 1218842 | 2021-04-13 | Loudoun | Virginia | 51107 | 26379 | 273 |
1215594 | 1215594 | 2021-04-12 | Loudoun | Virginia | 51107 | 26243 | 273 |
1212347 | 1212347 | 2021-04-11 | Loudoun | Virginia | 51107 | 26169 | 273 |
1209098 | 1209098 | 2021-04-10 | Loudoun | Virginia | 51107 | 26116 | 273 |
1205850 | 1205850 | 2021-04-09 | Loudoun | Virginia | 51107 | 26012 | 273 |
1202602 | 1202602 | 2021-04-08 | Loudoun | Virginia | 51107 | 25897 | 273 |
1199354 | 1199354 | 2021-04-07 | Loudoun | Virginia | 51107 | 25794 | 273 |
1196105 | 1196105 | 2021-04-06 | Loudoun | Virginia | 51107 | 25693 | 271 |
1192857 | 1192857 | 2021-04-05 | Loudoun | Virginia | 51107 | 25623 | 271 |
1189607 | 1189607 | 2021-04-04 | Loudoun | Virginia | 51107 | 25572 | 271 |
1186360 | 1186360 | 2021-04-03 | Loudoun | Virginia | 51107 | 25517 | 270 |
1183113 | 1183113 | 2021-04-02 | Loudoun | Virginia | 51107 | 25452 | 270 |
1179866 | 1179866 | 2021-04-01 | Loudoun | Virginia | 51107 | 25391 | 269 |
1176619 | 1176619 | 2021-03-31 | Loudoun | Virginia | 51107 | 25251 | 269 |
1173372 | 1173372 | 2021-03-30 | Loudoun | Virginia | 51107 | 25221 | 269 |
1170125 | 1170125 | 2021-03-29 | Loudoun | Virginia | 51107 | 25136 | 269 |
1166877 | 1166877 | 2021-03-28 | Loudoun | Virginia | 51107 | 25089 | 268 |
1163629 | 1163629 | 2021-03-27 | Loudoun | Virginia | 51107 | 25011 | 268 |
1160381 | 1160381 | 2021-03-26 | Loudoun | Virginia | 51107 | 24924 | 265 |
1157133 | 1157133 | 2021-03-25 | Loudoun | Virginia | 51107 | 24794 | 264 |
1153886 | 1153886 | 2021-03-24 | Loudoun | Virginia | 51107 | 24706 | 264 |
1150639 | 1150639 | 2021-03-23 | Loudoun | Virginia | 51107 | 24659 | 263 |
1147392 | 1147392 | 2021-03-22 | Loudoun | Virginia | 51107 | 24603 | 263 |
1144145 | 1144145 | 2021-03-21 | Loudoun | Virginia | 51107 | 24552 | 263 |
1140898 | 1140898 | 2021-03-20 | Loudoun | Virginia | 51107 | 24491 | 263 |
1137652 | 1137652 | 2021-03-19 | Loudoun | Virginia | 51107 | 24434 | 262 |
1134406 | 1134406 | 2021-03-18 | Loudoun | Virginia | 51107 | 24345 | 266 |
1131158 | 1131158 | 2021-03-17 | Loudoun | Virginia | 51107 | 24197 | 267 |
1127911 | 1127911 | 2021-03-16 | Loudoun | Virginia | 51107 | 24060 | 265 |
1124665 | 1124665 | 2021-03-15 | Loudoun | Virginia | 51107 | 23986 | 264 |
1121419 | 1121419 | 2021-03-14 | Loudoun | Virginia | 51107 | 23928 | 264 |
1118172 | 1118172 | 2021-03-13 | Loudoun | Virginia | 51107 | 23848 | 264 |
1114925 | 1114925 | 2021-03-12 | Loudoun | Virginia | 51107 | 23782 | 264 |
1111679 | 1111679 | 2021-03-11 | Loudoun | Virginia | 51107 | 23708 | 262 |
1108433 | 1108433 | 2021-03-10 | Loudoun | Virginia | 51107 | 23641 | 260 |
1105187 | 1105187 | 2021-03-09 | Loudoun | Virginia | 51107 | 23589 | 259 |
1101941 | 1101941 | 2021-03-08 | Loudoun | Virginia | 51107 | 23533 | 254 |
1098695 | 1098695 | 2021-03-07 | Loudoun | Virginia | 51107 | 23472 | 253 |
1095447 | 1095447 | 2021-03-06 | Loudoun | Virginia | 51107 | 23418 | 252 |
1092201 | 1092201 | 2021-03-05 | Loudoun | Virginia | 51107 | 23352 | 252 |
1088955 | 1088955 | 2021-03-04 | Loudoun | Virginia | 51107 | 23272 | 250 |
1085710 | 1085710 | 2021-03-03 | Loudoun | Virginia | 51107 | 23221 | 249 |
1082464 | 1082464 | 2021-03-02 | Loudoun | Virginia | 51107 | 23183 | 246 |
1079218 | 1079218 | 2021-03-01 | Loudoun | Virginia | 51107 | 23126 | 237 |
1075973 | 1075973 | 2021-02-28 | Loudoun | Virginia | 51107 | 23076 | 229 |
1072727 | 1072727 | 2021-02-27 | Loudoun | Virginia | 51107 | 22997 | 221 |
1069481 | 1069481 | 2021-02-26 | Loudoun | Virginia | 51107 | 22939 | 214 |
1066236 | 1066236 | 2021-02-25 | Loudoun | Virginia | 51107 | 22873 | 208 |
1062991 | 1062991 | 2021-02-24 | Loudoun | Virginia | 51107 | 22816 | 207 |
1059746 | 1059746 | 2021-02-23 | Loudoun | Virginia | 51107 | 22762 | 205 |
1056500 | 1056500 | 2021-02-22 | Loudoun | Virginia | 51107 | 22704 | 203 |
1053254 | 1053254 | 2021-02-21 | Loudoun | Virginia | 51107 | 22654 | 200 |
1050007 | 1050007 | 2021-02-20 | Loudoun | Virginia | 51107 | 22557 | 199 |
1046760 | 1046760 | 2021-02-19 | Loudoun | Virginia | 51107 | 22486 | 195 |
1043515 | 1043515 | 2021-02-18 | Loudoun | Virginia | 51107 | 22405 | 195 |
1040270 | 1040270 | 2021-02-17 | Loudoun | Virginia | 51107 | 22351 | 195 |
1037025 | 1037025 | 2021-02-16 | Loudoun | Virginia | 51107 | 22310 | 195 |
1033780 | 1033780 | 2021-02-15 | Loudoun | Virginia | 51107 | 22246 | 193 |
1030534 | 1030534 | 2021-02-14 | Loudoun | Virginia | 51107 | 22186 | 193 |
1027287 | 1027287 | 2021-02-13 | Loudoun | Virginia | 51107 | 22102 | 193 |
1024042 | 1024042 | 2021-02-12 | Loudoun | Virginia | 51107 | 22007 | 193 |
1020797 | 1020797 | 2021-02-11 | Loudoun | Virginia | 51107 | 21897 | 190 |
1017552 | 1017552 | 2021-02-10 | Loudoun | Virginia | 51107 | 21808 | 191 |
1014307 | 1014307 | 2021-02-09 | Loudoun | Virginia | 51107 | 21723 | 189 |
1011062 | 1011062 | 2021-02-08 | Loudoun | Virginia | 51107 | 21564 | 188 |
1007816 | 1007816 | 2021-02-07 | Loudoun | Virginia | 51107 | 21552 | 188 |
1004570 | 1004570 | 2021-02-06 | Loudoun | Virginia | 51107 | 21492 | 188 |
1001324 | 1001324 | 2021-02-05 | Loudoun | Virginia | 51107 | 21261 | 186 |
998078 | 998078 | 2021-02-04 | Loudoun | Virginia | 51107 | 21015 | 184 |
994832 | 994832 | 2021-02-03 | Loudoun | Virginia | 51107 | 20791 | 184 |
991586 | 991586 | 2021-02-02 | Loudoun | Virginia | 51107 | 20618 | 183 |
988340 | 988340 | 2021-02-01 | Loudoun | Virginia | 51107 | 20484 | 181 |
985093 | 985093 | 2021-01-31 | Loudoun | Virginia | 51107 | 20384 | 181 |
981846 | 981846 | 2021-01-30 | Loudoun | Virginia | 51107 | 20277 | 181 |
978600 | 978600 | 2021-01-29 | Loudoun | Virginia | 51107 | 20077 | 179 |
975355 | 975355 | 2021-01-28 | Loudoun | Virginia | 51107 | 19821 | 175 |
972110 | 972110 | 2021-01-27 | Loudoun | Virginia | 51107 | 19508 | 173 |
968865 | 968865 | 2021-01-26 | Loudoun | Virginia | 51107 | 19161 | 171 |
965621 | 965621 | 2021-01-25 | Loudoun | Virginia | 51107 | 18848 | 171 |
962376 | 962376 | 2021-01-24 | Loudoun | Virginia | 51107 | 18381 | 171 |
959131 | 959131 | 2021-01-23 | Loudoun | Virginia | 51107 | 18151 | 171 |
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);