ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 51179 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420170 | 1420170 | 2021-06-14 | Stafford | Virginia | 51179 | 11459 | 82 |
1416925 | 1416925 | 2021-06-13 | Stafford | Virginia | 51179 | 11458 | 82 |
1413679 | 1413679 | 2021-06-12 | Stafford | Virginia | 51179 | 11460 | 82 |
1410434 | 1410434 | 2021-06-11 | Stafford | Virginia | 51179 | 11458 | 82 |
1407189 | 1407189 | 2021-06-10 | Stafford | Virginia | 51179 | 11460 | 81 |
1403943 | 1403943 | 2021-06-09 | Stafford | Virginia | 51179 | 11460 | 81 |
1400698 | 1400698 | 2021-06-08 | Stafford | Virginia | 51179 | 11456 | 81 |
1397453 | 1397453 | 2021-06-07 | Stafford | Virginia | 51179 | 11453 | 81 |
1394206 | 1394206 | 2021-06-06 | Stafford | Virginia | 51179 | 11451 | 81 |
1390961 | 1390961 | 2021-06-05 | Stafford | Virginia | 51179 | 11444 | 81 |
1387716 | 1387716 | 2021-06-04 | Stafford | Virginia | 51179 | 11433 | 81 |
1384471 | 1384471 | 2021-06-03 | Stafford | Virginia | 51179 | 11435 | 81 |
1381225 | 1381225 | 2021-06-02 | Stafford | Virginia | 51179 | 11428 | 81 |
1377980 | 1377980 | 2021-06-01 | Stafford | Virginia | 51179 | 11417 | 80 |
1374734 | 1374734 | 2021-05-31 | Stafford | Virginia | 51179 | 11414 | 80 |
1371489 | 1371489 | 2021-05-30 | Stafford | Virginia | 51179 | 11408 | 80 |
1368243 | 1368243 | 2021-05-29 | Stafford | Virginia | 51179 | 11401 | 79 |
1364997 | 1364997 | 2021-05-28 | Stafford | Virginia | 51179 | 11400 | 79 |
1361751 | 1361751 | 2021-05-27 | Stafford | Virginia | 51179 | 11402 | 79 |
1358505 | 1358505 | 2021-05-26 | Stafford | Virginia | 51179 | 11393 | 79 |
1355259 | 1355259 | 2021-05-25 | Stafford | Virginia | 51179 | 11389 | 79 |
1352013 | 1352013 | 2021-05-24 | Stafford | Virginia | 51179 | 11378 | 79 |
1348767 | 1348767 | 2021-05-23 | Stafford | Virginia | 51179 | 11377 | 79 |
1345519 | 1345519 | 2021-05-22 | Stafford | Virginia | 51179 | 11373 | 79 |
1342271 | 1342271 | 2021-05-21 | Stafford | Virginia | 51179 | 11361 | 79 |
1339023 | 1339023 | 2021-05-20 | Stafford | Virginia | 51179 | 11345 | 79 |
1335776 | 1335776 | 2021-05-19 | Stafford | Virginia | 51179 | 11327 | 79 |
1332529 | 1332529 | 2021-05-18 | Stafford | Virginia | 51179 | 11317 | 79 |
1329282 | 1329282 | 2021-05-17 | Stafford | Virginia | 51179 | 11309 | 79 |
1326036 | 1326036 | 2021-05-16 | Stafford | Virginia | 51179 | 11304 | 79 |
1322790 | 1322790 | 2021-05-15 | Stafford | Virginia | 51179 | 11295 | 79 |
1319544 | 1319544 | 2021-05-14 | Stafford | Virginia | 51179 | 11275 | 79 |
1316296 | 1316296 | 2021-05-13 | Stafford | Virginia | 51179 | 11265 | 79 |
1313050 | 1313050 | 2021-05-12 | Stafford | Virginia | 51179 | 11244 | 79 |
1309803 | 1309803 | 2021-05-11 | Stafford | Virginia | 51179 | 11239 | 79 |
1306557 | 1306557 | 2021-05-10 | Stafford | Virginia | 51179 | 11230 | 79 |
1303311 | 1303311 | 2021-05-09 | Stafford | Virginia | 51179 | 11221 | 79 |
1300064 | 1300064 | 2021-05-08 | Stafford | Virginia | 51179 | 11208 | 78 |
1296817 | 1296817 | 2021-05-07 | Stafford | Virginia | 51179 | 11195 | 78 |
1293571 | 1293571 | 2021-05-06 | Stafford | Virginia | 51179 | 11178 | 78 |
1290325 | 1290325 | 2021-05-05 | Stafford | Virginia | 51179 | 11155 | 78 |
1287079 | 1287079 | 2021-05-04 | Stafford | Virginia | 51179 | 11133 | 76 |
1283833 | 1283833 | 2021-05-03 | Stafford | Virginia | 51179 | 11113 | 76 |
1280586 | 1280586 | 2021-05-02 | Stafford | Virginia | 51179 | 11106 | 75 |
1277339 | 1277339 | 2021-05-01 | Stafford | Virginia | 51179 | 11092 | 75 |
1274092 | 1274092 | 2021-04-30 | Stafford | Virginia | 51179 | 11067 | 75 |
1270845 | 1270845 | 2021-04-29 | Stafford | Virginia | 51179 | 11031 | 75 |
1267598 | 1267598 | 2021-04-28 | Stafford | Virginia | 51179 | 11007 | 75 |
1264351 | 1264351 | 2021-04-27 | Stafford | Virginia | 51179 | 10979 | 74 |
1261104 | 1261104 | 2021-04-26 | Stafford | Virginia | 51179 | 10958 | 74 |
1257857 | 1257857 | 2021-04-25 | Stafford | Virginia | 51179 | 10946 | 74 |
1254610 | 1254610 | 2021-04-24 | Stafford | Virginia | 51179 | 10922 | 74 |
1251363 | 1251363 | 2021-04-23 | Stafford | Virginia | 51179 | 10906 | 74 |
1248116 | 1248116 | 2021-04-22 | Stafford | Virginia | 51179 | 10867 | 73 |
1244869 | 1244869 | 2021-04-21 | Stafford | Virginia | 51179 | 10831 | 72 |
1241622 | 1241622 | 2021-04-20 | Stafford | Virginia | 51179 | 10789 | 72 |
1238375 | 1238375 | 2021-04-19 | Stafford | Virginia | 51179 | 10754 | 72 |
1235128 | 1235128 | 2021-04-18 | Stafford | Virginia | 51179 | 10739 | 72 |
1231880 | 1231880 | 2021-04-17 | Stafford | Virginia | 51179 | 10705 | 72 |
1228632 | 1228632 | 2021-04-16 | Stafford | Virginia | 51179 | 10658 | 72 |
1225384 | 1225384 | 2021-04-15 | Stafford | Virginia | 51179 | 10630 | 72 |
1222137 | 1222137 | 2021-04-14 | Stafford | Virginia | 51179 | 10599 | 72 |
1218889 | 1218889 | 2021-04-13 | Stafford | Virginia | 51179 | 10560 | 72 |
1215641 | 1215641 | 2021-04-12 | Stafford | Virginia | 51179 | 10519 | 71 |
1212394 | 1212394 | 2021-04-11 | Stafford | Virginia | 51179 | 10476 | 71 |
1209145 | 1209145 | 2021-04-10 | Stafford | Virginia | 51179 | 10454 | 71 |
1205897 | 1205897 | 2021-04-09 | Stafford | Virginia | 51179 | 10418 | 71 |
1202649 | 1202649 | 2021-04-08 | Stafford | Virginia | 51179 | 10393 | 71 |
1199401 | 1199401 | 2021-04-07 | Stafford | Virginia | 51179 | 10359 | 71 |
1196152 | 1196152 | 2021-04-06 | Stafford | Virginia | 51179 | 10332 | 70 |
1192904 | 1192904 | 2021-04-05 | Stafford | Virginia | 51179 | 10299 | 70 |
1189654 | 1189654 | 2021-04-04 | Stafford | Virginia | 51179 | 10284 | 70 |
1186407 | 1186407 | 2021-04-03 | Stafford | Virginia | 51179 | 10264 | 69 |
1183160 | 1183160 | 2021-04-02 | Stafford | Virginia | 51179 | 10241 | 69 |
1179913 | 1179913 | 2021-04-01 | Stafford | Virginia | 51179 | 10197 | 69 |
1176666 | 1176666 | 2021-03-31 | Stafford | Virginia | 51179 | 10150 | 69 |
1173419 | 1173419 | 2021-03-30 | Stafford | Virginia | 51179 | 10132 | 69 |
1170172 | 1170172 | 2021-03-29 | Stafford | Virginia | 51179 | 10109 | 69 |
1166924 | 1166924 | 2021-03-28 | Stafford | Virginia | 51179 | 10093 | 68 |
1163676 | 1163676 | 2021-03-27 | Stafford | Virginia | 51179 | 10081 | 68 |
1160428 | 1160428 | 2021-03-26 | Stafford | Virginia | 51179 | 10059 | 68 |
1157180 | 1157180 | 2021-03-25 | Stafford | Virginia | 51179 | 10036 | 68 |
1153933 | 1153933 | 2021-03-24 | Stafford | Virginia | 51179 | 9998 | 68 |
1150686 | 1150686 | 2021-03-23 | Stafford | Virginia | 51179 | 9970 | 68 |
1147439 | 1147439 | 2021-03-22 | Stafford | Virginia | 51179 | 9947 | 68 |
1144192 | 1144192 | 2021-03-21 | Stafford | Virginia | 51179 | 9928 | 68 |
1140945 | 1140945 | 2021-03-20 | Stafford | Virginia | 51179 | 9915 | 68 |
1137699 | 1137699 | 2021-03-19 | Stafford | Virginia | 51179 | 9891 | 68 |
1134453 | 1134453 | 2021-03-18 | Stafford | Virginia | 51179 | 9876 | 69 |
1131205 | 1131205 | 2021-03-17 | Stafford | Virginia | 51179 | 9858 | 69 |
1127958 | 1127958 | 2021-03-16 | Stafford | Virginia | 51179 | 9837 | 69 |
1124712 | 1124712 | 2021-03-15 | Stafford | Virginia | 51179 | 9843 | 70 |
1121466 | 1121466 | 2021-03-14 | Stafford | Virginia | 51179 | 9828 | 70 |
1118219 | 1118219 | 2021-03-13 | Stafford | Virginia | 51179 | 9802 | 69 |
1114972 | 1114972 | 2021-03-12 | Stafford | Virginia | 51179 | 9778 | 69 |
1111726 | 1111726 | 2021-03-11 | Stafford | Virginia | 51179 | 9754 | 69 |
1108480 | 1108480 | 2021-03-10 | Stafford | Virginia | 51179 | 9736 | 68 |
1105234 | 1105234 | 2021-03-09 | Stafford | Virginia | 51179 | 9715 | 69 |
1101988 | 1101988 | 2021-03-08 | Stafford | Virginia | 51179 | 9687 | 68 |
1098742 | 1098742 | 2021-03-07 | Stafford | Virginia | 51179 | 9671 | 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);