ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Virginia Beach city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280592 | 1280592 | 2021-05-02 | Virginia Beach city | Virginia | 51810 | 35470 | 386 |
1277345 | 1277345 | 2021-05-01 | Virginia Beach city | Virginia | 51810 | 35419 | 386 |
1274098 | 1274098 | 2021-04-30 | Virginia Beach city | Virginia | 51810 | 35360 | 385 |
1270851 | 1270851 | 2021-04-29 | Virginia Beach city | Virginia | 51810 | 35316 | 384 |
1267604 | 1267604 | 2021-04-28 | Virginia Beach city | Virginia | 51810 | 35269 | 384 |
1264357 | 1264357 | 2021-04-27 | Virginia Beach city | Virginia | 51810 | 35197 | 383 |
1261110 | 1261110 | 2021-04-26 | Virginia Beach city | Virginia | 51810 | 35116 | 383 |
1257863 | 1257863 | 2021-04-25 | Virginia Beach city | Virginia | 51810 | 35069 | 382 |
1254616 | 1254616 | 2021-04-24 | Virginia Beach city | Virginia | 51810 | 35003 | 382 |
1251369 | 1251369 | 2021-04-23 | Virginia Beach city | Virginia | 51810 | 34939 | 382 |
1248122 | 1248122 | 2021-04-22 | Virginia Beach city | Virginia | 51810 | 34862 | 380 |
1244875 | 1244875 | 2021-04-21 | Virginia Beach city | Virginia | 51810 | 34799 | 379 |
1241628 | 1241628 | 2021-04-20 | Virginia Beach city | Virginia | 51810 | 34740 | 379 |
1238381 | 1238381 | 2021-04-19 | Virginia Beach city | Virginia | 51810 | 34650 | 375 |
1235134 | 1235134 | 2021-04-18 | Virginia Beach city | Virginia | 51810 | 34588 | 375 |
1231886 | 1231886 | 2021-04-17 | Virginia Beach city | Virginia | 51810 | 34507 | 375 |
1228638 | 1228638 | 2021-04-16 | Virginia Beach city | Virginia | 51810 | 34426 | 374 |
1225390 | 1225390 | 2021-04-15 | Virginia Beach city | Virginia | 51810 | 34316 | 372 |
1222143 | 1222143 | 2021-04-14 | Virginia Beach city | Virginia | 51810 | 34245 | 370 |
1218895 | 1218895 | 2021-04-13 | Virginia Beach city | Virginia | 51810 | 34174 | 370 |
1215647 | 1215647 | 2021-04-12 | Virginia Beach city | Virginia | 51810 | 34068 | 369 |
1212400 | 1212400 | 2021-04-11 | Virginia Beach city | Virginia | 51810 | 34010 | 369 |
1209151 | 1209151 | 2021-04-10 | Virginia Beach city | Virginia | 51810 | 33960 | 369 |
1205903 | 1205903 | 2021-04-09 | Virginia Beach city | Virginia | 51810 | 33866 | 368 |
1202655 | 1202655 | 2021-04-08 | Virginia Beach city | Virginia | 51810 | 33801 | 368 |
1199407 | 1199407 | 2021-04-07 | Virginia Beach city | Virginia | 51810 | 33705 | 368 |
1196158 | 1196158 | 2021-04-06 | Virginia Beach city | Virginia | 51810 | 33615 | 368 |
1192910 | 1192910 | 2021-04-05 | Virginia Beach city | Virginia | 51810 | 33538 | 367 |
1189660 | 1189660 | 2021-04-04 | Virginia Beach city | Virginia | 51810 | 33482 | 366 |
1186413 | 1186413 | 2021-04-03 | Virginia Beach city | Virginia | 51810 | 33412 | 365 |
1183166 | 1183166 | 2021-04-02 | Virginia Beach city | Virginia | 51810 | 33322 | 364 |
1179919 | 1179919 | 2021-04-01 | Virginia Beach city | Virginia | 51810 | 33253 | 364 |
1176672 | 1176672 | 2021-03-31 | Virginia Beach city | Virginia | 51810 | 33166 | 362 |
1173425 | 1173425 | 2021-03-30 | Virginia Beach city | Virginia | 51810 | 33122 | 362 |
1170178 | 1170178 | 2021-03-29 | Virginia Beach city | Virginia | 51810 | 33029 | 359 |
1166930 | 1166930 | 2021-03-28 | Virginia Beach city | Virginia | 51810 | 32971 | 359 |
1163682 | 1163682 | 2021-03-27 | Virginia Beach city | Virginia | 51810 | 32875 | 359 |
1160434 | 1160434 | 2021-03-26 | Virginia Beach city | Virginia | 51810 | 32766 | 358 |
1157186 | 1157186 | 2021-03-25 | Virginia Beach city | Virginia | 51810 | 32681 | 358 |
1153939 | 1153939 | 2021-03-24 | Virginia Beach city | Virginia | 51810 | 32590 | 358 |
1150692 | 1150692 | 2021-03-23 | Virginia Beach city | Virginia | 51810 | 32516 | 358 |
1147445 | 1147445 | 2021-03-22 | Virginia Beach city | Virginia | 51810 | 32465 | 358 |
1144198 | 1144198 | 2021-03-21 | Virginia Beach city | Virginia | 51810 | 32361 | 358 |
1140951 | 1140951 | 2021-03-20 | Virginia Beach city | Virginia | 51810 | 32303 | 358 |
1137705 | 1137705 | 2021-03-19 | Virginia Beach city | Virginia | 51810 | 32207 | 356 |
1134459 | 1134459 | 2021-03-18 | Virginia Beach city | Virginia | 51810 | 32116 | 357 |
1131211 | 1131211 | 2021-03-17 | Virginia Beach city | Virginia | 51810 | 32001 | 356 |
1127964 | 1127964 | 2021-03-16 | Virginia Beach city | Virginia | 51810 | 31937 | 354 |
1124718 | 1124718 | 2021-03-15 | Virginia Beach city | Virginia | 51810 | 31848 | 352 |
1121472 | 1121472 | 2021-03-14 | Virginia Beach city | Virginia | 51810 | 31793 | 349 |
1118225 | 1118225 | 2021-03-13 | Virginia Beach city | Virginia | 51810 | 31725 | 349 |
1114978 | 1114978 | 2021-03-12 | Virginia Beach city | Virginia | 51810 | 31630 | 348 |
1111732 | 1111732 | 2021-03-11 | Virginia Beach city | Virginia | 51810 | 31505 | 347 |
1108486 | 1108486 | 2021-03-10 | Virginia Beach city | Virginia | 51810 | 31423 | 343 |
1105240 | 1105240 | 2021-03-09 | Virginia Beach city | Virginia | 51810 | 31300 | 341 |
1101994 | 1101994 | 2021-03-08 | Virginia Beach city | Virginia | 51810 | 31182 | 338 |
1098748 | 1098748 | 2021-03-07 | Virginia Beach city | Virginia | 51810 | 31131 | 335 |
1095500 | 1095500 | 2021-03-06 | Virginia Beach city | Virginia | 51810 | 31077 | 333 |
1092254 | 1092254 | 2021-03-05 | Virginia Beach city | Virginia | 51810 | 31010 | 330 |
1089008 | 1089008 | 2021-03-04 | Virginia Beach city | Virginia | 51810 | 30929 | 328 |
1085763 | 1085763 | 2021-03-03 | Virginia Beach city | Virginia | 51810 | 30838 | 328 |
1082517 | 1082517 | 2021-03-02 | Virginia Beach city | Virginia | 51810 | 30739 | 311 |
1079271 | 1079271 | 2021-03-01 | Virginia Beach city | Virginia | 51810 | 30652 | 306 |
1076026 | 1076026 | 2021-02-28 | Virginia Beach city | Virginia | 51810 | 30595 | 302 |
1072780 | 1072780 | 2021-02-27 | Virginia Beach city | Virginia | 51810 | 30491 | 300 |
1069534 | 1069534 | 2021-02-26 | Virginia Beach city | Virginia | 51810 | 30393 | 293 |
1066289 | 1066289 | 2021-02-25 | Virginia Beach city | Virginia | 51810 | 30310 | 286 |
1063044 | 1063044 | 2021-02-24 | Virginia Beach city | Virginia | 51810 | 30161 | 280 |
1059799 | 1059799 | 2021-02-23 | Virginia Beach city | Virginia | 51810 | 30051 | 271 |
1056553 | 1056553 | 2021-02-22 | Virginia Beach city | Virginia | 51810 | 29876 | 259 |
1053307 | 1053307 | 2021-02-21 | Virginia Beach city | Virginia | 51810 | 29786 | 252 |
1050060 | 1050060 | 2021-02-20 | Virginia Beach city | Virginia | 51810 | 29660 | 250 |
1046813 | 1046813 | 2021-02-19 | Virginia Beach city | Virginia | 51810 | 29552 | 247 |
1043568 | 1043568 | 2021-02-18 | Virginia Beach city | Virginia | 51810 | 29438 | 246 |
1040323 | 1040323 | 2021-02-17 | Virginia Beach city | Virginia | 51810 | 29308 | 246 |
1037078 | 1037078 | 2021-02-16 | Virginia Beach city | Virginia | 51810 | 29186 | 243 |
1033833 | 1033833 | 2021-02-15 | Virginia Beach city | Virginia | 51810 | 29081 | 243 |
1030587 | 1030587 | 2021-02-14 | Virginia Beach city | Virginia | 51810 | 28975 | 243 |
1027340 | 1027340 | 2021-02-13 | Virginia Beach city | Virginia | 51810 | 28796 | 243 |
1024095 | 1024095 | 2021-02-12 | Virginia Beach city | Virginia | 51810 | 28608 | 239 |
1020850 | 1020850 | 2021-02-11 | Virginia Beach city | Virginia | 51810 | 28401 | 239 |
1017605 | 1017605 | 2021-02-10 | Virginia Beach city | Virginia | 51810 | 28219 | 238 |
1014360 | 1014360 | 2021-02-09 | Virginia Beach city | Virginia | 51810 | 28090 | 234 |
1011115 | 1011115 | 2021-02-08 | Virginia Beach city | Virginia | 51810 | 27866 | 225 |
1007869 | 1007869 | 2021-02-07 | Virginia Beach city | Virginia | 51810 | 27762 | 225 |
1004623 | 1004623 | 2021-02-06 | Virginia Beach city | Virginia | 51810 | 27545 | 225 |
1001377 | 1001377 | 2021-02-05 | Virginia Beach city | Virginia | 51810 | 27272 | 225 |
998131 | 998131 | 2021-02-04 | Virginia Beach city | Virginia | 51810 | 26913 | 222 |
994885 | 994885 | 2021-02-03 | Virginia Beach city | Virginia | 51810 | 26750 | 214 |
991639 | 991639 | 2021-02-02 | Virginia Beach city | Virginia | 51810 | 26580 | 209 |
988393 | 988393 | 2021-02-01 | Virginia Beach city | Virginia | 51810 | 26420 | 208 |
985146 | 985146 | 2021-01-31 | Virginia Beach city | Virginia | 51810 | 26211 | 206 |
981899 | 981899 | 2021-01-30 | Virginia Beach city | Virginia | 51810 | 26066 | 206 |
978653 | 978653 | 2021-01-29 | Virginia Beach city | Virginia | 51810 | 25762 | 203 |
975408 | 975408 | 2021-01-28 | Virginia Beach city | Virginia | 51810 | 25529 | 201 |
972163 | 972163 | 2021-01-27 | Virginia Beach city | Virginia | 51810 | 25199 | 195 |
968918 | 968918 | 2021-01-26 | Virginia Beach city | Virginia | 51810 | 24918 | 195 |
965674 | 965674 | 2021-01-25 | Virginia Beach city | Virginia | 51810 | 24600 | 194 |
962429 | 962429 | 2021-01-24 | Virginia Beach city | Virginia | 51810 | 24241 | 194 |
959184 | 959184 | 2021-01-23 | Virginia Beach city | Virginia | 51810 | 23990 | 194 |
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);