ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 51035 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420073 | 1420073 | 2021-06-14 | Carroll | Virginia | 51035 | 2718 | 78 |
1416828 | 1416828 | 2021-06-13 | Carroll | Virginia | 51035 | 2718 | 78 |
1413582 | 1413582 | 2021-06-12 | Carroll | Virginia | 51035 | 2717 | 78 |
1410337 | 1410337 | 2021-06-11 | Carroll | Virginia | 51035 | 2717 | 78 |
1407092 | 1407092 | 2021-06-10 | Carroll | Virginia | 51035 | 2716 | 77 |
1403846 | 1403846 | 2021-06-09 | Carroll | Virginia | 51035 | 2714 | 77 |
1400601 | 1400601 | 2021-06-08 | Carroll | Virginia | 51035 | 2713 | 77 |
1397356 | 1397356 | 2021-06-07 | Carroll | Virginia | 51035 | 2709 | 77 |
1394109 | 1394109 | 2021-06-06 | Carroll | Virginia | 51035 | 2705 | 77 |
1390864 | 1390864 | 2021-06-05 | Carroll | Virginia | 51035 | 2703 | 77 |
1387619 | 1387619 | 2021-06-04 | Carroll | Virginia | 51035 | 2699 | 77 |
1384374 | 1384374 | 2021-06-03 | Carroll | Virginia | 51035 | 2695 | 77 |
1381128 | 1381128 | 2021-06-02 | Carroll | Virginia | 51035 | 2690 | 77 |
1377883 | 1377883 | 2021-06-01 | Carroll | Virginia | 51035 | 2686 | 76 |
1374637 | 1374637 | 2021-05-31 | Carroll | Virginia | 51035 | 2686 | 75 |
1371392 | 1371392 | 2021-05-30 | Carroll | Virginia | 51035 | 2685 | 75 |
1368146 | 1368146 | 2021-05-29 | Carroll | Virginia | 51035 | 2685 | 75 |
1364900 | 1364900 | 2021-05-28 | Carroll | Virginia | 51035 | 2682 | 75 |
1361654 | 1361654 | 2021-05-27 | Carroll | Virginia | 51035 | 2682 | 75 |
1358408 | 1358408 | 2021-05-26 | Carroll | Virginia | 51035 | 2682 | 76 |
1355162 | 1355162 | 2021-05-25 | Carroll | Virginia | 51035 | 2680 | 76 |
1351916 | 1351916 | 2021-05-24 | Carroll | Virginia | 51035 | 2678 | 74 |
1348670 | 1348670 | 2021-05-23 | Carroll | Virginia | 51035 | 2678 | 74 |
1345422 | 1345422 | 2021-05-22 | Carroll | Virginia | 51035 | 2678 | 74 |
1342174 | 1342174 | 2021-05-21 | Carroll | Virginia | 51035 | 2672 | 74 |
1338926 | 1338926 | 2021-05-20 | Carroll | Virginia | 51035 | 2669 | 74 |
1335679 | 1335679 | 2021-05-19 | Carroll | Virginia | 51035 | 2665 | 73 |
1332432 | 1332432 | 2021-05-18 | Carroll | Virginia | 51035 | 2663 | 73 |
1329185 | 1329185 | 2021-05-17 | Carroll | Virginia | 51035 | 2661 | 73 |
1325939 | 1325939 | 2021-05-16 | Carroll | Virginia | 51035 | 2662 | 73 |
1322693 | 1322693 | 2021-05-15 | Carroll | Virginia | 51035 | 2661 | 73 |
1319447 | 1319447 | 2021-05-14 | Carroll | Virginia | 51035 | 2658 | 72 |
1316199 | 1316199 | 2021-05-13 | Carroll | Virginia | 51035 | 2657 | 71 |
1312953 | 1312953 | 2021-05-12 | Carroll | Virginia | 51035 | 2656 | 71 |
1309706 | 1309706 | 2021-05-11 | Carroll | Virginia | 51035 | 2653 | 70 |
1306460 | 1306460 | 2021-05-10 | Carroll | Virginia | 51035 | 2651 | 70 |
1303214 | 1303214 | 2021-05-09 | Carroll | Virginia | 51035 | 2644 | 70 |
1299967 | 1299967 | 2021-05-08 | Carroll | Virginia | 51035 | 2641 | 70 |
1296720 | 1296720 | 2021-05-07 | Carroll | Virginia | 51035 | 2636 | 70 |
1293474 | 1293474 | 2021-05-06 | Carroll | Virginia | 51035 | 2630 | 70 |
1290228 | 1290228 | 2021-05-05 | Carroll | Virginia | 51035 | 2624 | 70 |
1286982 | 1286982 | 2021-05-04 | Carroll | Virginia | 51035 | 2614 | 70 |
1283736 | 1283736 | 2021-05-03 | Carroll | Virginia | 51035 | 2608 | 70 |
1280489 | 1280489 | 2021-05-02 | Carroll | Virginia | 51035 | 2603 | 69 |
1277242 | 1277242 | 2021-05-01 | Carroll | Virginia | 51035 | 2597 | 69 |
1273995 | 1273995 | 2021-04-30 | Carroll | Virginia | 51035 | 2594 | 69 |
1270748 | 1270748 | 2021-04-29 | Carroll | Virginia | 51035 | 2586 | 69 |
1267501 | 1267501 | 2021-04-28 | Carroll | Virginia | 51035 | 2579 | 69 |
1264254 | 1264254 | 2021-04-27 | Carroll | Virginia | 51035 | 2578 | 69 |
1261007 | 1261007 | 2021-04-26 | Carroll | Virginia | 51035 | 2570 | 69 |
1257760 | 1257760 | 2021-04-25 | Carroll | Virginia | 51035 | 2559 | 68 |
1254513 | 1254513 | 2021-04-24 | Carroll | Virginia | 51035 | 2558 | 68 |
1251266 | 1251266 | 2021-04-23 | Carroll | Virginia | 51035 | 2550 | 67 |
1248019 | 1248019 | 2021-04-22 | Carroll | Virginia | 51035 | 2543 | 67 |
1244772 | 1244772 | 2021-04-21 | Carroll | Virginia | 51035 | 2530 | 67 |
1241525 | 1241525 | 2021-04-20 | Carroll | Virginia | 51035 | 2524 | 67 |
1238278 | 1238278 | 2021-04-19 | Carroll | Virginia | 51035 | 2519 | 67 |
1235031 | 1235031 | 2021-04-18 | Carroll | Virginia | 51035 | 2505 | 67 |
1231783 | 1231783 | 2021-04-17 | Carroll | Virginia | 51035 | 2500 | 67 |
1228535 | 1228535 | 2021-04-16 | Carroll | Virginia | 51035 | 2487 | 67 |
1225287 | 1225287 | 2021-04-15 | Carroll | Virginia | 51035 | 2467 | 67 |
1222040 | 1222040 | 2021-04-14 | Carroll | Virginia | 51035 | 2456 | 67 |
1218792 | 1218792 | 2021-04-13 | Carroll | Virginia | 51035 | 2450 | 67 |
1215544 | 1215544 | 2021-04-12 | Carroll | Virginia | 51035 | 2435 | 67 |
1212297 | 1212297 | 2021-04-11 | Carroll | Virginia | 51035 | 2427 | 67 |
1209048 | 1209048 | 2021-04-10 | Carroll | Virginia | 51035 | 2404 | 67 |
1205800 | 1205800 | 2021-04-09 | Carroll | Virginia | 51035 | 2387 | 66 |
1202552 | 1202552 | 2021-04-08 | Carroll | Virginia | 51035 | 2375 | 65 |
1199304 | 1199304 | 2021-04-07 | Carroll | Virginia | 51035 | 2364 | 65 |
1196055 | 1196055 | 2021-04-06 | Carroll | Virginia | 51035 | 2352 | 65 |
1192807 | 1192807 | 2021-04-05 | Carroll | Virginia | 51035 | 2335 | 64 |
1189557 | 1189557 | 2021-04-04 | Carroll | Virginia | 51035 | 2321 | 64 |
1186310 | 1186310 | 2021-04-03 | Carroll | Virginia | 51035 | 2308 | 64 |
1183063 | 1183063 | 2021-04-02 | Carroll | Virginia | 51035 | 2300 | 64 |
1179816 | 1179816 | 2021-04-01 | Carroll | Virginia | 51035 | 2283 | 65 |
1176569 | 1176569 | 2021-03-31 | Carroll | Virginia | 51035 | 2270 | 65 |
1173322 | 1173322 | 2021-03-30 | Carroll | Virginia | 51035 | 2261 | 65 |
1170075 | 1170075 | 2021-03-29 | Carroll | Virginia | 51035 | 2253 | 65 |
1166827 | 1166827 | 2021-03-28 | Carroll | Virginia | 51035 | 2240 | 65 |
1163579 | 1163579 | 2021-03-27 | Carroll | Virginia | 51035 | 2235 | 65 |
1160331 | 1160331 | 2021-03-26 | Carroll | Virginia | 51035 | 2231 | 65 |
1157083 | 1157083 | 2021-03-25 | Carroll | Virginia | 51035 | 2217 | 65 |
1153836 | 1153836 | 2021-03-24 | Carroll | Virginia | 51035 | 2212 | 65 |
1150589 | 1150589 | 2021-03-23 | Carroll | Virginia | 51035 | 2207 | 65 |
1147342 | 1147342 | 2021-03-22 | Carroll | Virginia | 51035 | 2206 | 65 |
1144095 | 1144095 | 2021-03-21 | Carroll | Virginia | 51035 | 2199 | 65 |
1140848 | 1140848 | 2021-03-20 | Carroll | Virginia | 51035 | 2195 | 65 |
1137602 | 1137602 | 2021-03-19 | Carroll | Virginia | 51035 | 2193 | 65 |
1134356 | 1134356 | 2021-03-18 | Carroll | Virginia | 51035 | 2191 | 67 |
1131108 | 1131108 | 2021-03-17 | Carroll | Virginia | 51035 | 2188 | 67 |
1127861 | 1127861 | 2021-03-16 | Carroll | Virginia | 51035 | 2183 | 67 |
1124615 | 1124615 | 2021-03-15 | Carroll | Virginia | 51035 | 2180 | 67 |
1121369 | 1121369 | 2021-03-14 | Carroll | Virginia | 51035 | 2178 | 67 |
1118122 | 1118122 | 2021-03-13 | Carroll | Virginia | 51035 | 2177 | 67 |
1114875 | 1114875 | 2021-03-12 | Carroll | Virginia | 51035 | 2172 | 67 |
1111629 | 1111629 | 2021-03-11 | Carroll | Virginia | 51035 | 2164 | 67 |
1108383 | 1108383 | 2021-03-10 | Carroll | Virginia | 51035 | 2154 | 67 |
1105137 | 1105137 | 2021-03-09 | Carroll | Virginia | 51035 | 2150 | 67 |
1101891 | 1101891 | 2021-03-08 | Carroll | Virginia | 51035 | 2145 | 67 |
1098645 | 1098645 | 2021-03-07 | Carroll | Virginia | 51035 | 2142 | 67 |
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);