ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 51730 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420146 | 1420146 | 2021-06-14 | Petersburg city | Virginia | 51730 | 3934 | 88 |
1416901 | 1416901 | 2021-06-13 | Petersburg city | Virginia | 51730 | 3934 | 87 |
1413655 | 1413655 | 2021-06-12 | Petersburg city | Virginia | 51730 | 3934 | 86 |
1410410 | 1410410 | 2021-06-11 | Petersburg city | Virginia | 51730 | 3933 | 86 |
1407165 | 1407165 | 2021-06-10 | Petersburg city | Virginia | 51730 | 3933 | 86 |
1403919 | 1403919 | 2021-06-09 | Petersburg city | Virginia | 51730 | 3926 | 86 |
1400674 | 1400674 | 2021-06-08 | Petersburg city | Virginia | 51730 | 3924 | 86 |
1397429 | 1397429 | 2021-06-07 | Petersburg city | Virginia | 51730 | 3920 | 86 |
1394182 | 1394182 | 2021-06-06 | Petersburg city | Virginia | 51730 | 3920 | 86 |
1390937 | 1390937 | 2021-06-05 | Petersburg city | Virginia | 51730 | 3918 | 86 |
1387692 | 1387692 | 2021-06-04 | Petersburg city | Virginia | 51730 | 3917 | 86 |
1384447 | 1384447 | 2021-06-03 | Petersburg city | Virginia | 51730 | 3914 | 86 |
1381201 | 1381201 | 2021-06-02 | Petersburg city | Virginia | 51730 | 3914 | 86 |
1377956 | 1377956 | 2021-06-01 | Petersburg city | Virginia | 51730 | 3914 | 86 |
1374710 | 1374710 | 2021-05-31 | Petersburg city | Virginia | 51730 | 3913 | 86 |
1371465 | 1371465 | 2021-05-30 | Petersburg city | Virginia | 51730 | 3911 | 86 |
1368219 | 1368219 | 2021-05-29 | Petersburg city | Virginia | 51730 | 3910 | 86 |
1364973 | 1364973 | 2021-05-28 | Petersburg city | Virginia | 51730 | 3911 | 86 |
1361727 | 1361727 | 2021-05-27 | Petersburg city | Virginia | 51730 | 3901 | 86 |
1358481 | 1358481 | 2021-05-26 | Petersburg city | Virginia | 51730 | 3900 | 86 |
1355235 | 1355235 | 2021-05-25 | Petersburg city | Virginia | 51730 | 3895 | 86 |
1351989 | 1351989 | 2021-05-24 | Petersburg city | Virginia | 51730 | 3889 | 86 |
1348743 | 1348743 | 2021-05-23 | Petersburg city | Virginia | 51730 | 3891 | 86 |
1345495 | 1345495 | 2021-05-22 | Petersburg city | Virginia | 51730 | 3889 | 86 |
1342247 | 1342247 | 2021-05-21 | Petersburg city | Virginia | 51730 | 3884 | 86 |
1338999 | 1338999 | 2021-05-20 | Petersburg city | Virginia | 51730 | 3887 | 86 |
1335752 | 1335752 | 2021-05-19 | Petersburg city | Virginia | 51730 | 3881 | 86 |
1332505 | 1332505 | 2021-05-18 | Petersburg city | Virginia | 51730 | 3879 | 86 |
1329258 | 1329258 | 2021-05-17 | Petersburg city | Virginia | 51730 | 3876 | 86 |
1326012 | 1326012 | 2021-05-16 | Petersburg city | Virginia | 51730 | 3874 | 86 |
1322766 | 1322766 | 2021-05-15 | Petersburg city | Virginia | 51730 | 3872 | 86 |
1319520 | 1319520 | 2021-05-14 | Petersburg city | Virginia | 51730 | 3867 | 86 |
1316272 | 1316272 | 2021-05-13 | Petersburg city | Virginia | 51730 | 3862 | 86 |
1313026 | 1313026 | 2021-05-12 | Petersburg city | Virginia | 51730 | 3860 | 84 |
1309779 | 1309779 | 2021-05-11 | Petersburg city | Virginia | 51730 | 3858 | 84 |
1306533 | 1306533 | 2021-05-10 | Petersburg city | Virginia | 51730 | 3851 | 84 |
1303287 | 1303287 | 2021-05-09 | Petersburg city | Virginia | 51730 | 3848 | 84 |
1300040 | 1300040 | 2021-05-08 | Petersburg city | Virginia | 51730 | 3852 | 84 |
1296793 | 1296793 | 2021-05-07 | Petersburg city | Virginia | 51730 | 3845 | 84 |
1293547 | 1293547 | 2021-05-06 | Petersburg city | Virginia | 51730 | 3834 | 84 |
1290301 | 1290301 | 2021-05-05 | Petersburg city | Virginia | 51730 | 3825 | 84 |
1287055 | 1287055 | 2021-05-04 | Petersburg city | Virginia | 51730 | 3823 | 84 |
1283809 | 1283809 | 2021-05-03 | Petersburg city | Virginia | 51730 | 3815 | 84 |
1280562 | 1280562 | 2021-05-02 | Petersburg city | Virginia | 51730 | 3812 | 84 |
1277315 | 1277315 | 2021-05-01 | Petersburg city | Virginia | 51730 | 3806 | 84 |
1274068 | 1274068 | 2021-04-30 | Petersburg city | Virginia | 51730 | 3792 | 83 |
1270821 | 1270821 | 2021-04-29 | Petersburg city | Virginia | 51730 | 3786 | 83 |
1267574 | 1267574 | 2021-04-28 | Petersburg city | Virginia | 51730 | 3776 | 83 |
1264327 | 1264327 | 2021-04-27 | Petersburg city | Virginia | 51730 | 3772 | 83 |
1261080 | 1261080 | 2021-04-26 | Petersburg city | Virginia | 51730 | 3759 | 83 |
1257833 | 1257833 | 2021-04-25 | Petersburg city | Virginia | 51730 | 3753 | 83 |
1254586 | 1254586 | 2021-04-24 | Petersburg city | Virginia | 51730 | 3751 | 83 |
1251339 | 1251339 | 2021-04-23 | Petersburg city | Virginia | 51730 | 3742 | 82 |
1248092 | 1248092 | 2021-04-22 | Petersburg city | Virginia | 51730 | 3738 | 82 |
1244845 | 1244845 | 2021-04-21 | Petersburg city | Virginia | 51730 | 3717 | 81 |
1241598 | 1241598 | 2021-04-20 | Petersburg city | Virginia | 51730 | 3709 | 81 |
1238351 | 1238351 | 2021-04-19 | Petersburg city | Virginia | 51730 | 3703 | 81 |
1235104 | 1235104 | 2021-04-18 | Petersburg city | Virginia | 51730 | 3694 | 81 |
1231856 | 1231856 | 2021-04-17 | Petersburg city | Virginia | 51730 | 3689 | 81 |
1228608 | 1228608 | 2021-04-16 | Petersburg city | Virginia | 51730 | 3665 | 81 |
1225360 | 1225360 | 2021-04-15 | Petersburg city | Virginia | 51730 | 3657 | 81 |
1222113 | 1222113 | 2021-04-14 | Petersburg city | Virginia | 51730 | 3650 | 80 |
1218865 | 1218865 | 2021-04-13 | Petersburg city | Virginia | 51730 | 3637 | 80 |
1215617 | 1215617 | 2021-04-12 | Petersburg city | Virginia | 51730 | 3628 | 80 |
1212370 | 1212370 | 2021-04-11 | Petersburg city | Virginia | 51730 | 3616 | 80 |
1209121 | 1209121 | 2021-04-10 | Petersburg city | Virginia | 51730 | 3602 | 79 |
1205873 | 1205873 | 2021-04-09 | Petersburg city | Virginia | 51730 | 3598 | 79 |
1202625 | 1202625 | 2021-04-08 | Petersburg city | Virginia | 51730 | 3587 | 79 |
1199377 | 1199377 | 2021-04-07 | Petersburg city | Virginia | 51730 | 3573 | 79 |
1196128 | 1196128 | 2021-04-06 | Petersburg city | Virginia | 51730 | 3572 | 79 |
1192880 | 1192880 | 2021-04-05 | Petersburg city | Virginia | 51730 | 3553 | 78 |
1189630 | 1189630 | 2021-04-04 | Petersburg city | Virginia | 51730 | 3546 | 78 |
1186383 | 1186383 | 2021-04-03 | Petersburg city | Virginia | 51730 | 3533 | 77 |
1183136 | 1183136 | 2021-04-02 | Petersburg city | Virginia | 51730 | 3524 | 77 |
1179889 | 1179889 | 2021-04-01 | Petersburg city | Virginia | 51730 | 3516 | 77 |
1176642 | 1176642 | 2021-03-31 | Petersburg city | Virginia | 51730 | 3509 | 77 |
1173395 | 1173395 | 2021-03-30 | Petersburg city | Virginia | 51730 | 3505 | 77 |
1170148 | 1170148 | 2021-03-29 | Petersburg city | Virginia | 51730 | 3492 | 76 |
1166900 | 1166900 | 2021-03-28 | Petersburg city | Virginia | 51730 | 3487 | 76 |
1163652 | 1163652 | 2021-03-27 | Petersburg city | Virginia | 51730 | 3485 | 74 |
1160404 | 1160404 | 2021-03-26 | Petersburg city | Virginia | 51730 | 3468 | 74 |
1157156 | 1157156 | 2021-03-25 | Petersburg city | Virginia | 51730 | 3451 | 74 |
1153909 | 1153909 | 2021-03-24 | Petersburg city | Virginia | 51730 | 3448 | 74 |
1150662 | 1150662 | 2021-03-23 | Petersburg city | Virginia | 51730 | 3440 | 74 |
1147415 | 1147415 | 2021-03-22 | Petersburg city | Virginia | 51730 | 3427 | 74 |
1144168 | 1144168 | 2021-03-21 | Petersburg city | Virginia | 51730 | 3420 | 74 |
1140921 | 1140921 | 2021-03-20 | Petersburg city | Virginia | 51730 | 3413 | 74 |
1137675 | 1137675 | 2021-03-19 | Petersburg city | Virginia | 51730 | 3399 | 74 |
1134429 | 1134429 | 2021-03-18 | Petersburg city | Virginia | 51730 | 3400 | 75 |
1131181 | 1131181 | 2021-03-17 | Petersburg city | Virginia | 51730 | 3384 | 74 |
1127934 | 1127934 | 2021-03-16 | Petersburg city | Virginia | 51730 | 3388 | 74 |
1124688 | 1124688 | 2021-03-15 | Petersburg city | Virginia | 51730 | 3355 | 73 |
1121442 | 1121442 | 2021-03-14 | Petersburg city | Virginia | 51730 | 3345 | 73 |
1118195 | 1118195 | 2021-03-13 | Petersburg city | Virginia | 51730 | 3335 | 72 |
1114948 | 1114948 | 2021-03-12 | Petersburg city | Virginia | 51730 | 3332 | 72 |
1111702 | 1111702 | 2021-03-11 | Petersburg city | Virginia | 51730 | 3315 | 72 |
1108456 | 1108456 | 2021-03-10 | Petersburg city | Virginia | 51730 | 3291 | 71 |
1105210 | 1105210 | 2021-03-09 | Petersburg city | Virginia | 51730 | 3282 | 69 |
1101964 | 1101964 | 2021-03-08 | Petersburg city | Virginia | 51730 | 3251 | 68 |
1098718 | 1098718 | 2021-03-07 | Petersburg city | Virginia | 51730 | 3244 | 68 |
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);