ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 51069 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420098 | 1420098 | 2021-06-14 | Frederick | Virginia | 51069 | 8092 | 102 |
1416853 | 1416853 | 2021-06-13 | Frederick | Virginia | 51069 | 8090 | 102 |
1413607 | 1413607 | 2021-06-12 | Frederick | Virginia | 51069 | 8088 | 102 |
1410362 | 1410362 | 2021-06-11 | Frederick | Virginia | 51069 | 8086 | 102 |
1407117 | 1407117 | 2021-06-10 | Frederick | Virginia | 51069 | 8084 | 102 |
1403871 | 1403871 | 2021-06-09 | Frederick | Virginia | 51069 | 8085 | 102 |
1400626 | 1400626 | 2021-06-08 | Frederick | Virginia | 51069 | 8088 | 102 |
1397381 | 1397381 | 2021-06-07 | Frederick | Virginia | 51069 | 8082 | 102 |
1394134 | 1394134 | 2021-06-06 | Frederick | Virginia | 51069 | 8081 | 102 |
1390889 | 1390889 | 2021-06-05 | Frederick | Virginia | 51069 | 8081 | 102 |
1387644 | 1387644 | 2021-06-04 | Frederick | Virginia | 51069 | 8082 | 102 |
1384399 | 1384399 | 2021-06-03 | Frederick | Virginia | 51069 | 8073 | 102 |
1381153 | 1381153 | 2021-06-02 | Frederick | Virginia | 51069 | 8067 | 102 |
1377908 | 1377908 | 2021-06-01 | Frederick | Virginia | 51069 | 8067 | 102 |
1374662 | 1374662 | 2021-05-31 | Frederick | Virginia | 51069 | 8067 | 102 |
1371417 | 1371417 | 2021-05-30 | Frederick | Virginia | 51069 | 8063 | 102 |
1368171 | 1368171 | 2021-05-29 | Frederick | Virginia | 51069 | 8058 | 102 |
1364925 | 1364925 | 2021-05-28 | Frederick | Virginia | 51069 | 8054 | 102 |
1361679 | 1361679 | 2021-05-27 | Frederick | Virginia | 51069 | 8050 | 102 |
1358433 | 1358433 | 2021-05-26 | Frederick | Virginia | 51069 | 8041 | 102 |
1355187 | 1355187 | 2021-05-25 | Frederick | Virginia | 51069 | 8033 | 102 |
1351941 | 1351941 | 2021-05-24 | Frederick | Virginia | 51069 | 8019 | 102 |
1348695 | 1348695 | 2021-05-23 | Frederick | Virginia | 51069 | 8016 | 101 |
1345447 | 1345447 | 2021-05-22 | Frederick | Virginia | 51069 | 8009 | 101 |
1342199 | 1342199 | 2021-05-21 | Frederick | Virginia | 51069 | 8000 | 101 |
1338951 | 1338951 | 2021-05-20 | Frederick | Virginia | 51069 | 8001 | 101 |
1335704 | 1335704 | 2021-05-19 | Frederick | Virginia | 51069 | 7990 | 101 |
1332457 | 1332457 | 2021-05-18 | Frederick | Virginia | 51069 | 7987 | 101 |
1329210 | 1329210 | 2021-05-17 | Frederick | Virginia | 51069 | 7978 | 101 |
1325964 | 1325964 | 2021-05-16 | Frederick | Virginia | 51069 | 7970 | 101 |
1322718 | 1322718 | 2021-05-15 | Frederick | Virginia | 51069 | 7968 | 101 |
1319472 | 1319472 | 2021-05-14 | Frederick | Virginia | 51069 | 7960 | 100 |
1316224 | 1316224 | 2021-05-13 | Frederick | Virginia | 51069 | 7948 | 100 |
1312978 | 1312978 | 2021-05-12 | Frederick | Virginia | 51069 | 7935 | 99 |
1309731 | 1309731 | 2021-05-11 | Frederick | Virginia | 51069 | 7939 | 100 |
1306485 | 1306485 | 2021-05-10 | Frederick | Virginia | 51069 | 7925 | 100 |
1303239 | 1303239 | 2021-05-09 | Frederick | Virginia | 51069 | 7920 | 100 |
1299992 | 1299992 | 2021-05-08 | Frederick | Virginia | 51069 | 7912 | 100 |
1296745 | 1296745 | 2021-05-07 | Frederick | Virginia | 51069 | 7905 | 100 |
1293499 | 1293499 | 2021-05-06 | Frederick | Virginia | 51069 | 7885 | 100 |
1290253 | 1290253 | 2021-05-05 | Frederick | Virginia | 51069 | 7885 | 100 |
1287007 | 1287007 | 2021-05-04 | Frederick | Virginia | 51069 | 7864 | 100 |
1283761 | 1283761 | 2021-05-03 | Frederick | Virginia | 51069 | 7850 | 100 |
1280514 | 1280514 | 2021-05-02 | Frederick | Virginia | 51069 | 7847 | 100 |
1277267 | 1277267 | 2021-05-01 | Frederick | Virginia | 51069 | 7842 | 100 |
1274020 | 1274020 | 2021-04-30 | Frederick | Virginia | 51069 | 7831 | 100 |
1270773 | 1270773 | 2021-04-29 | Frederick | Virginia | 51069 | 7802 | 98 |
1267526 | 1267526 | 2021-04-28 | Frederick | Virginia | 51069 | 7780 | 98 |
1264279 | 1264279 | 2021-04-27 | Frederick | Virginia | 51069 | 7769 | 97 |
1261032 | 1261032 | 2021-04-26 | Frederick | Virginia | 51069 | 7749 | 97 |
1257785 | 1257785 | 2021-04-25 | Frederick | Virginia | 51069 | 7740 | 97 |
1254538 | 1254538 | 2021-04-24 | Frederick | Virginia | 51069 | 7731 | 97 |
1251291 | 1251291 | 2021-04-23 | Frederick | Virginia | 51069 | 7707 | 97 |
1248044 | 1248044 | 2021-04-22 | Frederick | Virginia | 51069 | 7681 | 97 |
1244797 | 1244797 | 2021-04-21 | Frederick | Virginia | 51069 | 7663 | 97 |
1241550 | 1241550 | 2021-04-20 | Frederick | Virginia | 51069 | 7646 | 98 |
1238303 | 1238303 | 2021-04-19 | Frederick | Virginia | 51069 | 7632 | 97 |
1235056 | 1235056 | 2021-04-18 | Frederick | Virginia | 51069 | 7618 | 97 |
1231808 | 1231808 | 2021-04-17 | Frederick | Virginia | 51069 | 7606 | 96 |
1228560 | 1228560 | 2021-04-16 | Frederick | Virginia | 51069 | 7576 | 95 |
1225312 | 1225312 | 2021-04-15 | Frederick | Virginia | 51069 | 7558 | 95 |
1222065 | 1222065 | 2021-04-14 | Frederick | Virginia | 51069 | 7525 | 95 |
1218817 | 1218817 | 2021-04-13 | Frederick | Virginia | 51069 | 7515 | 95 |
1215569 | 1215569 | 2021-04-12 | Frederick | Virginia | 51069 | 7487 | 95 |
1212322 | 1212322 | 2021-04-11 | Frederick | Virginia | 51069 | 7474 | 95 |
1209073 | 1209073 | 2021-04-10 | Frederick | Virginia | 51069 | 7450 | 95 |
1205825 | 1205825 | 2021-04-09 | Frederick | Virginia | 51069 | 7419 | 95 |
1202577 | 1202577 | 2021-04-08 | Frederick | Virginia | 51069 | 7388 | 95 |
1199329 | 1199329 | 2021-04-07 | Frederick | Virginia | 51069 | 7367 | 95 |
1196080 | 1196080 | 2021-04-06 | Frederick | Virginia | 51069 | 7343 | 95 |
1192832 | 1192832 | 2021-04-05 | Frederick | Virginia | 51069 | 7322 | 95 |
1189582 | 1189582 | 2021-04-04 | Frederick | Virginia | 51069 | 7307 | 95 |
1186335 | 1186335 | 2021-04-03 | Frederick | Virginia | 51069 | 7292 | 95 |
1183088 | 1183088 | 2021-04-02 | Frederick | Virginia | 51069 | 7280 | 95 |
1179841 | 1179841 | 2021-04-01 | Frederick | Virginia | 51069 | 7257 | 95 |
1176594 | 1176594 | 2021-03-31 | Frederick | Virginia | 51069 | 7233 | 94 |
1173347 | 1173347 | 2021-03-30 | Frederick | Virginia | 51069 | 7225 | 94 |
1170100 | 1170100 | 2021-03-29 | Frederick | Virginia | 51069 | 7205 | 94 |
1166852 | 1166852 | 2021-03-28 | Frederick | Virginia | 51069 | 7193 | 94 |
1163604 | 1163604 | 2021-03-27 | Frederick | Virginia | 51069 | 7169 | 94 |
1160356 | 1160356 | 2021-03-26 | Frederick | Virginia | 51069 | 7152 | 96 |
1157108 | 1157108 | 2021-03-25 | Frederick | Virginia | 51069 | 7132 | 96 |
1153861 | 1153861 | 2021-03-24 | Frederick | Virginia | 51069 | 7111 | 96 |
1150614 | 1150614 | 2021-03-23 | Frederick | Virginia | 51069 | 7087 | 96 |
1147367 | 1147367 | 2021-03-22 | Frederick | Virginia | 51069 | 7071 | 96 |
1144120 | 1144120 | 2021-03-21 | Frederick | Virginia | 51069 | 7054 | 96 |
1140873 | 1140873 | 2021-03-20 | Frederick | Virginia | 51069 | 7042 | 96 |
1137627 | 1137627 | 2021-03-19 | Frederick | Virginia | 51069 | 7022 | 96 |
1134381 | 1134381 | 2021-03-18 | Frederick | Virginia | 51069 | 7004 | 96 |
1131133 | 1131133 | 2021-03-17 | Frederick | Virginia | 51069 | 6979 | 96 |
1127886 | 1127886 | 2021-03-16 | Frederick | Virginia | 51069 | 6960 | 96 |
1124640 | 1124640 | 2021-03-15 | Frederick | Virginia | 51069 | 6952 | 96 |
1121394 | 1121394 | 2021-03-14 | Frederick | Virginia | 51069 | 6945 | 96 |
1118147 | 1118147 | 2021-03-13 | Frederick | Virginia | 51069 | 6930 | 94 |
1114900 | 1114900 | 2021-03-12 | Frederick | Virginia | 51069 | 6911 | 93 |
1111654 | 1111654 | 2021-03-11 | Frederick | Virginia | 51069 | 6893 | 91 |
1108408 | 1108408 | 2021-03-10 | Frederick | Virginia | 51069 | 6878 | 91 |
1105162 | 1105162 | 2021-03-09 | Frederick | Virginia | 51069 | 6863 | 88 |
1101916 | 1101916 | 2021-03-08 | Frederick | Virginia | 51069 | 6851 | 88 |
1098670 | 1098670 | 2021-03-07 | Frederick | Virginia | 51069 | 6843 | 88 |
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);