ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
758 rows where fips = 51057 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420089 | 1420089 | 2021-06-14 | Essex | Virginia | 51057 | 781 | 10 |
1416844 | 1416844 | 2021-06-13 | Essex | Virginia | 51057 | 782 | 10 |
1413598 | 1413598 | 2021-06-12 | Essex | Virginia | 51057 | 782 | 10 |
1410353 | 1410353 | 2021-06-11 | Essex | Virginia | 51057 | 782 | 10 |
1407108 | 1407108 | 2021-06-10 | Essex | Virginia | 51057 | 781 | 10 |
1403862 | 1403862 | 2021-06-09 | Essex | Virginia | 51057 | 781 | 10 |
1400617 | 1400617 | 2021-06-08 | Essex | Virginia | 51057 | 781 | 10 |
1397372 | 1397372 | 2021-06-07 | Essex | Virginia | 51057 | 781 | 10 |
1394125 | 1394125 | 2021-06-06 | Essex | Virginia | 51057 | 781 | 10 |
1390880 | 1390880 | 2021-06-05 | Essex | Virginia | 51057 | 781 | 10 |
1387635 | 1387635 | 2021-06-04 | Essex | Virginia | 51057 | 780 | 10 |
1384390 | 1384390 | 2021-06-03 | Essex | Virginia | 51057 | 780 | 10 |
1381144 | 1381144 | 2021-06-02 | Essex | Virginia | 51057 | 780 | 10 |
1377899 | 1377899 | 2021-06-01 | Essex | Virginia | 51057 | 781 | 10 |
1374653 | 1374653 | 2021-05-31 | Essex | Virginia | 51057 | 781 | 10 |
1371408 | 1371408 | 2021-05-30 | Essex | Virginia | 51057 | 780 | 10 |
1368162 | 1368162 | 2021-05-29 | Essex | Virginia | 51057 | 778 | 10 |
1364916 | 1364916 | 2021-05-28 | Essex | Virginia | 51057 | 778 | 10 |
1361670 | 1361670 | 2021-05-27 | Essex | Virginia | 51057 | 778 | 10 |
1358424 | 1358424 | 2021-05-26 | Essex | Virginia | 51057 | 778 | 10 |
1355178 | 1355178 | 2021-05-25 | Essex | Virginia | 51057 | 778 | 10 |
1351932 | 1351932 | 2021-05-24 | Essex | Virginia | 51057 | 768 | 10 |
1348686 | 1348686 | 2021-05-23 | Essex | Virginia | 51057 | 768 | 10 |
1345438 | 1345438 | 2021-05-22 | Essex | Virginia | 51057 | 768 | 10 |
1342190 | 1342190 | 2021-05-21 | Essex | Virginia | 51057 | 768 | 10 |
1338942 | 1338942 | 2021-05-20 | Essex | Virginia | 51057 | 766 | 10 |
1335695 | 1335695 | 2021-05-19 | Essex | Virginia | 51057 | 766 | 10 |
1332448 | 1332448 | 2021-05-18 | Essex | Virginia | 51057 | 764 | 10 |
1329201 | 1329201 | 2021-05-17 | Essex | Virginia | 51057 | 764 | 10 |
1325955 | 1325955 | 2021-05-16 | Essex | Virginia | 51057 | 764 | 9 |
1322709 | 1322709 | 2021-05-15 | Essex | Virginia | 51057 | 764 | 9 |
1319463 | 1319463 | 2021-05-14 | Essex | Virginia | 51057 | 763 | 9 |
1316215 | 1316215 | 2021-05-13 | Essex | Virginia | 51057 | 761 | 9 |
1312969 | 1312969 | 2021-05-12 | Essex | Virginia | 51057 | 761 | 9 |
1309722 | 1309722 | 2021-05-11 | Essex | Virginia | 51057 | 761 | 9 |
1306476 | 1306476 | 2021-05-10 | Essex | Virginia | 51057 | 761 | 9 |
1303230 | 1303230 | 2021-05-09 | Essex | Virginia | 51057 | 760 | 9 |
1299983 | 1299983 | 2021-05-08 | Essex | Virginia | 51057 | 759 | 9 |
1296736 | 1296736 | 2021-05-07 | Essex | Virginia | 51057 | 758 | 9 |
1293490 | 1293490 | 2021-05-06 | Essex | Virginia | 51057 | 755 | 9 |
1290244 | 1290244 | 2021-05-05 | Essex | Virginia | 51057 | 754 | 9 |
1286998 | 1286998 | 2021-05-04 | Essex | Virginia | 51057 | 754 | 9 |
1283752 | 1283752 | 2021-05-03 | Essex | Virginia | 51057 | 753 | 9 |
1280505 | 1280505 | 2021-05-02 | Essex | Virginia | 51057 | 753 | 9 |
1277258 | 1277258 | 2021-05-01 | Essex | Virginia | 51057 | 753 | 9 |
1274011 | 1274011 | 2021-04-30 | Essex | Virginia | 51057 | 753 | 9 |
1270764 | 1270764 | 2021-04-29 | Essex | Virginia | 51057 | 752 | 9 |
1267517 | 1267517 | 2021-04-28 | Essex | Virginia | 51057 | 752 | 9 |
1264270 | 1264270 | 2021-04-27 | Essex | Virginia | 51057 | 750 | 8 |
1261023 | 1261023 | 2021-04-26 | Essex | Virginia | 51057 | 750 | 8 |
1257776 | 1257776 | 2021-04-25 | Essex | Virginia | 51057 | 750 | 8 |
1254529 | 1254529 | 2021-04-24 | Essex | Virginia | 51057 | 749 | 8 |
1251282 | 1251282 | 2021-04-23 | Essex | Virginia | 51057 | 749 | 8 |
1248035 | 1248035 | 2021-04-22 | Essex | Virginia | 51057 | 748 | 8 |
1244788 | 1244788 | 2021-04-21 | Essex | Virginia | 51057 | 748 | 9 |
1241541 | 1241541 | 2021-04-20 | Essex | Virginia | 51057 | 746 | 9 |
1238294 | 1238294 | 2021-04-19 | Essex | Virginia | 51057 | 746 | 8 |
1235047 | 1235047 | 2021-04-18 | Essex | Virginia | 51057 | 743 | 8 |
1231799 | 1231799 | 2021-04-17 | Essex | Virginia | 51057 | 740 | 8 |
1228551 | 1228551 | 2021-04-16 | Essex | Virginia | 51057 | 738 | 8 |
1225303 | 1225303 | 2021-04-15 | Essex | Virginia | 51057 | 736 | 8 |
1222056 | 1222056 | 2021-04-14 | Essex | Virginia | 51057 | 733 | 8 |
1218808 | 1218808 | 2021-04-13 | Essex | Virginia | 51057 | 733 | 8 |
1215560 | 1215560 | 2021-04-12 | Essex | Virginia | 51057 | 730 | 8 |
1212313 | 1212313 | 2021-04-11 | Essex | Virginia | 51057 | 730 | 8 |
1209064 | 1209064 | 2021-04-10 | Essex | Virginia | 51057 | 728 | 8 |
1205816 | 1205816 | 2021-04-09 | Essex | Virginia | 51057 | 727 | 8 |
1202568 | 1202568 | 2021-04-08 | Essex | Virginia | 51057 | 722 | 8 |
1199320 | 1199320 | 2021-04-07 | Essex | Virginia | 51057 | 720 | 8 |
1196071 | 1196071 | 2021-04-06 | Essex | Virginia | 51057 | 714 | 8 |
1192823 | 1192823 | 2021-04-05 | Essex | Virginia | 51057 | 713 | 8 |
1189573 | 1189573 | 2021-04-04 | Essex | Virginia | 51057 | 712 | 8 |
1186326 | 1186326 | 2021-04-03 | Essex | Virginia | 51057 | 708 | 8 |
1183079 | 1183079 | 2021-04-02 | Essex | Virginia | 51057 | 706 | 8 |
1179832 | 1179832 | 2021-04-01 | Essex | Virginia | 51057 | 705 | 8 |
1176585 | 1176585 | 2021-03-31 | Essex | Virginia | 51057 | 705 | 8 |
1173338 | 1173338 | 2021-03-30 | Essex | Virginia | 51057 | 703 | 8 |
1170091 | 1170091 | 2021-03-29 | Essex | Virginia | 51057 | 701 | 8 |
1166843 | 1166843 | 2021-03-28 | Essex | Virginia | 51057 | 698 | 8 |
1163595 | 1163595 | 2021-03-27 | Essex | Virginia | 51057 | 696 | 8 |
1160347 | 1160347 | 2021-03-26 | Essex | Virginia | 51057 | 693 | 8 |
1157099 | 1157099 | 2021-03-25 | Essex | Virginia | 51057 | 691 | 8 |
1153852 | 1153852 | 2021-03-24 | Essex | Virginia | 51057 | 688 | 8 |
1150605 | 1150605 | 2021-03-23 | Essex | Virginia | 51057 | 681 | 8 |
1147358 | 1147358 | 2021-03-22 | Essex | Virginia | 51057 | 679 | 8 |
1144111 | 1144111 | 2021-03-21 | Essex | Virginia | 51057 | 678 | 8 |
1140864 | 1140864 | 2021-03-20 | Essex | Virginia | 51057 | 673 | 8 |
1137618 | 1137618 | 2021-03-19 | Essex | Virginia | 51057 | 672 | 8 |
1134372 | 1134372 | 2021-03-18 | Essex | Virginia | 51057 | 667 | 8 |
1131124 | 1131124 | 2021-03-17 | Essex | Virginia | 51057 | 664 | 8 |
1127877 | 1127877 | 2021-03-16 | Essex | Virginia | 51057 | 660 | 8 |
1124631 | 1124631 | 2021-03-15 | Essex | Virginia | 51057 | 659 | 8 |
1121385 | 1121385 | 2021-03-14 | Essex | Virginia | 51057 | 657 | 8 |
1118138 | 1118138 | 2021-03-13 | Essex | Virginia | 51057 | 655 | 7 |
1114891 | 1114891 | 2021-03-12 | Essex | Virginia | 51057 | 654 | 7 |
1111645 | 1111645 | 2021-03-11 | Essex | Virginia | 51057 | 652 | 7 |
1108399 | 1108399 | 2021-03-10 | Essex | Virginia | 51057 | 652 | 7 |
1105153 | 1105153 | 2021-03-09 | Essex | Virginia | 51057 | 650 | 7 |
1101907 | 1101907 | 2021-03-08 | Essex | Virginia | 51057 | 645 | 7 |
1098661 | 1098661 | 2021-03-07 | Essex | Virginia | 51057 | 645 | 7 |
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);