ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 51071 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 473 ✖
- 5 32
- 4 26
- 18 22
- 23 9
- 1336 8
- 4036 8
- 8 7
- 6 6
- 1334 6
- 1365 6
- 2 5
- 7 5
- 94 5
- 1335 5
- 1338 5
- 20 4
- 90 4
- 1314 4
- 1329 4
- 2131 4
- 4051 4
- 4056 4
- 4058 4
- 34 3
- 35 3
- 37 3
- 61 3
- 101 3
- 1096 3
- 1282 3
- 1291 3
- 1313 3
- 1333 3
- 1379 3
- 1393 3
- 1434 3
- 1475 3
- 1561 3
- 1698 3
- 1833 3
- 1991 3
- 2077 3
- 2187 3
- 2240 3
- 2283 3
- 2310 3
- 2334 3
- 2358 3
- 2396 3
- 2426 3
- 2454 3
- 2507 3
- 2559 3
- 2612 3
- 2698 3
- 2875 3
- 3114 3
- 3390 3
- 3604 3
- 3778 3
- 3905 3
- 3968 3
- 4004 3
- 4028 3
- 4041 3
- 4048 3
- 4052 3
- 4070 3
- 4085 3
- 15 2
- 17 2
- 24 2
- 27 2
- 33 2
- 41 2
- 67 2
- 83 2
- 85 2
- 88 2
- 89 2
- 114 2
- 122 2
- 1066 2
- 1091 2
- 1103 2
- 1144 2
- 1147 2
- 1149 2
- 1177 2
- 1214 2
- 1257 2
- 1261 2
- 1278 2
- 1283 2
- 1292 2
- 1296 2
- 1297 2
- 1312 2
- 1316 2
- 1331 2
- 1337 2
- 1369 2
- 1386 2
- 2253 2
- 4014 2
- 4044 2
- 4054 2
- 4057 2
- 1 1
- 3 1
- 13 1
- 14 1
- 21 1
- 26 1
- 28 1
- 29 1
- 32 1
- 36 1
- 43 1
- 47 1
- 51 1
- 52 1
- 54 1
- 58 1
- 60 1
- 63 1
- 65 1
- 69 1
- 71 1
- 73 1
- 74 1
- 78 1
- 84 1
- 93 1
- 95 1
- 96 1
- 98 1
- 99 1
- 109 1
- 110 1
- 111 1
- 112 1
- 117 1
- 119 1
- 125 1
- 129 1
- 133 1
- 134 1
- 135 1
- 140 1
- 143 1
- 146 1
- 149 1
- 153 1
- 155 1
- 157 1
- 160 1
- 166 1
- 169 1
- 172 1
- 175 1
- 179 1
- 187 1
- 192 1
- 196 1
- 198 1
- 203 1
- 207 1
- 210 1
- 217 1
- 223 1
- 234 1
- 235 1
- 236 1
- 246 1
- 256 1
- 262 1
- 264 1
- 285 1
- 293 1
- 299 1
- 303 1
- 307 1
- 317 1
- 321 1
- 335 1
- 341 1
- 356 1
- 367 1
- 377 1
- 390 1
- 405 1
- 411 1
- 414 1
- 422 1
- 437 1
- 440 1
- 452 1
- 459 1
- 472 1
- 477 1
- 488 1
- 492 1
- 507 1
- 519 1
- 531 1
- 532 1
- 540 1
- 547 1
- 557 1
- 593 1
- 605 1
- 616 1
- 619 1
- 638 1
- 652 1
- 662 1
- 691 1
- 705 1
- 728 1
- 744 1
- 753 1
- 764 1
- 774 1
- 786 1
- 794 1
- 812 1
- 824 1
- 839 1
- 846 1
- 849 1
- 862 1
- 871 1
- 877 1
- 883 1
- 886 1
- 893 1
- 894 1
- 903 1
- 904 1
- 913 1
- 923 1
- 928 1
- 941 1
- 942 1
- 945 1
- 948 1
- 951 1
- 957 1
- 965 1
- 970 1
- 978 1
- 988 1
- 997 1
- 1002 1
- 1006 1
- 1010 1
- 1017 1
- 1018 1
- 1026 1
- 1029 1
- 1032 1
- 1036 1
- 1043 1
- 1044 1
- 1045 1
- 1052 1
- 1065 1
- 1075 1
- 1076 1
- 1083 1
- 1087 1
- 1088 1
- 1090 1
- 1092 1
- 1104 1
- 1106 1
- 1111 1
- 1112 1
- 1123 1
- 1129 1
- 1132 1
- 1133 1
- 1135 1
- 1150 1
- 1153 1
- 1156 1
- 1159 1
- 1163 1
- 1169 1
- 1172 1
- 1173 1
- 1182 1
- 1183 1
- 1184 1
- 1188 1
- 1190 1
- 1195 1
- 1199 1
- 1201 1
- 1202 1
- 1211 1
- 1217 1
- 1222 1
- 1224 1
- 1230 1
- 1234 1
- 1238 1
- 1239 1
- 1243 1
- 1246 1
- 1252 1
- 1255 1
- 1259 1
- 1267 1
- 1270 1
- 1274 1
- 1275 1
- 1279 1
- 1280 1
- 1284 1
- 1286 1
- 1287 1
- 1288 1
- 1298 1
- 1300 1
- 1303 1
- 1306 1
- 1308 1
- 1310 1
- 1315 1
- 1318 1
- 1323 1
- 1361 1
- 1372 1
- 1375 1
- 1388 1
- 1389 1
- 1415 1
- 1419 1
- 1420 1
- 1425 1
- 1440 1
- 1451 1
- 1457 1
- 1468 1
- 1496 1
- 1511 1
- 1522 1
- 1545 1
- 1607 1
- 1615 1
- 1646 1
- 1664 1
- 1743 1
- 1762 1
- 1779 1
- 1806 1
- 1904 1
- 1915 1
- 1944 1
- 1967 1
- 2035 1
- 2044 1
- 2056 1
- 2069 1
- 2100 1
- 2101 1
- 2111 1
- 2119 1
- 2165 1
- 2169 1
- 2180 1
- 2211 1
- 2213 1
- 2220 1
- 2229 1
- 2263 1
- 2270 1
- 2289 1
- 2290 1
- 2296 1
- 2300 1
- 2318 1
- 2320 1
- 2326 1
- 2330 1
- 2341 1
- 2347 1
- 2350 1
- 2353 1
- 2378 1
- 2384 1
- 2388 1
- 2391 1
- 2400 1
- 2408 1
- 2414 1
- 2420 1
- 2435 1
- 2441 1
- 2444 1
- 2447 1
- 2474 1
- 2478 1
- 2488 1
- 2502 1
- 2528 1
- 2535 1
- 2541 1
- 2545 1
- 2583 1
- 2586 1
- 2590 1
- 2597 1
- 2650 1
- 2657 1
- 2664 1
- 2681 1
- 2762 1
- 2774 1
- 2796 1
- 2832 1
- 2986 1
- 2997 1
- 3008 1
- 3039 1
- 3237 1
- 3265 1
- 3299 1
- 3353 1
- 3493 1
- 3515 1
- 3528 1
- 3574 1
- 3679 1
- 3692 1
- 3720 1
- 3745 1
- 3831 1
- 3844 1
- 3868 1
- 3890 1
- 3945 1
- 3950 1
- 3958 1
- 3963 1
- 3981 1
- 3986 1
- 3995 1
- 3999 1
- 4017 1
- 4021 1
- 4030 1
- 4033 1
- 4037 1
- 4045 1
- 4046 1
- 4049 1
- 4053 1
- 4061 1
- 4063 1
- 4066 1
- 4068 1
- 4079 1
- 4080 1
- 4081 1
- 4083 1
- 4091 1
- 4095 1
- 4100 1
- 4104 1
- 4115 1
state 1
- Virginia · 768 ✖
fips 1
- 51071 · 768 ✖
county 1
- Giles 768
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502558 | 2502558 | 2022-05-13 | Giles | Virginia | 51071 | 4115 | 50 |
2499300 | 2499300 | 2022-05-12 | Giles | Virginia | 51071 | 4104 | 50 |
2496042 | 2496042 | 2022-05-11 | Giles | Virginia | 51071 | 4100 | 50 |
2492784 | 2492784 | 2022-05-10 | Giles | Virginia | 51071 | 4095 | 50 |
2489526 | 2489526 | 2022-05-09 | Giles | Virginia | 51071 | 4091 | 50 |
2486269 | 2486269 | 2022-05-08 | Giles | Virginia | 51071 | 4085 | 50 |
2483011 | 2483011 | 2022-05-07 | Giles | Virginia | 51071 | 4085 | 50 |
2479753 | 2479753 | 2022-05-06 | Giles | Virginia | 51071 | 4085 | 50 |
2476495 | 2476495 | 2022-05-05 | Giles | Virginia | 51071 | 4083 | 50 |
2473237 | 2473237 | 2022-05-04 | Giles | Virginia | 51071 | 4081 | 50 |
2469981 | 2469981 | 2022-05-03 | Giles | Virginia | 51071 | 4080 | 50 |
2466725 | 2466725 | 2022-05-02 | Giles | Virginia | 51071 | 4079 | 50 |
2463470 | 2463470 | 2022-05-01 | Giles | Virginia | 51071 | 4070 | 50 |
2460214 | 2460214 | 2022-04-30 | Giles | Virginia | 51071 | 4070 | 50 |
2456958 | 2456958 | 2022-04-29 | Giles | Virginia | 51071 | 4070 | 50 |
2453702 | 2453702 | 2022-04-28 | Giles | Virginia | 51071 | 4068 | 50 |
2450446 | 2450446 | 2022-04-27 | Giles | Virginia | 51071 | 4066 | 50 |
2447189 | 2447189 | 2022-04-26 | Giles | Virginia | 51071 | 4063 | 50 |
2443934 | 2443934 | 2022-04-25 | Giles | Virginia | 51071 | 4061 | 50 |
2440678 | 2440678 | 2022-04-24 | Giles | Virginia | 51071 | 4058 | 50 |
2437422 | 2437422 | 2022-04-23 | Giles | Virginia | 51071 | 4058 | 50 |
2434166 | 2434166 | 2022-04-22 | Giles | Virginia | 51071 | 4058 | 50 |
2430910 | 2430910 | 2022-04-21 | Giles | Virginia | 51071 | 4056 | 50 |
2427654 | 2427654 | 2022-04-20 | Giles | Virginia | 51071 | 4057 | 50 |
2424398 | 2424398 | 2022-04-19 | Giles | Virginia | 51071 | 4057 | 50 |
2421142 | 2421142 | 2022-04-18 | Giles | Virginia | 51071 | 4058 | 49 |
2417886 | 2417886 | 2022-04-17 | Giles | Virginia | 51071 | 4056 | 49 |
2414630 | 2414630 | 2022-04-16 | Giles | Virginia | 51071 | 4056 | 49 |
2411374 | 2411374 | 2022-04-15 | Giles | Virginia | 51071 | 4056 | 49 |
2408118 | 2408118 | 2022-04-14 | Giles | Virginia | 51071 | 4054 | 49 |
2404862 | 2404862 | 2022-04-13 | Giles | Virginia | 51071 | 4054 | 49 |
2401607 | 2401607 | 2022-04-12 | Giles | Virginia | 51071 | 4053 | 48 |
2398352 | 2398352 | 2022-04-11 | Giles | Virginia | 51071 | 4051 | 48 |
2395097 | 2395097 | 2022-04-10 | Giles | Virginia | 51071 | 4052 | 48 |
2391841 | 2391841 | 2022-04-09 | Giles | Virginia | 51071 | 4052 | 48 |
2388585 | 2388585 | 2022-04-08 | Giles | Virginia | 51071 | 4052 | 48 |
2385330 | 2385330 | 2022-04-07 | Giles | Virginia | 51071 | 4051 | 47 |
2382075 | 2382075 | 2022-04-06 | Giles | Virginia | 51071 | 4051 | 47 |
2378820 | 2378820 | 2022-04-05 | Giles | Virginia | 51071 | 4051 | 46 |
2375566 | 2375566 | 2022-04-04 | Giles | Virginia | 51071 | 4049 | 46 |
2372314 | 2372314 | 2022-04-03 | Giles | Virginia | 51071 | 4048 | 46 |
2369061 | 2369061 | 2022-04-02 | Giles | Virginia | 51071 | 4048 | 46 |
2365808 | 2365808 | 2022-04-01 | Giles | Virginia | 51071 | 4048 | 46 |
2362555 | 2362555 | 2022-03-31 | Giles | Virginia | 51071 | 4046 | 46 |
2359301 | 2359301 | 2022-03-30 | Giles | Virginia | 51071 | 4045 | 46 |
2356047 | 2356047 | 2022-03-29 | Giles | Virginia | 51071 | 4044 | 46 |
2352794 | 2352794 | 2022-03-28 | Giles | Virginia | 51071 | 4044 | 46 |
2349542 | 2349542 | 2022-03-27 | Giles | Virginia | 51071 | 4041 | 46 |
2346289 | 2346289 | 2022-03-26 | Giles | Virginia | 51071 | 4041 | 46 |
2343036 | 2343036 | 2022-03-25 | Giles | Virginia | 51071 | 4041 | 46 |
2339783 | 2339783 | 2022-03-24 | Giles | Virginia | 51071 | 4037 | 46 |
2336529 | 2336529 | 2022-03-23 | Giles | Virginia | 51071 | 4036 | 46 |
2333275 | 2333275 | 2022-03-22 | Giles | Virginia | 51071 | 4036 | 46 |
2330022 | 2330022 | 2022-03-21 | Giles | Virginia | 51071 | 4036 | 46 |
2326770 | 2326770 | 2022-03-20 | Giles | Virginia | 51071 | 4036 | 46 |
2323517 | 2323517 | 2022-03-19 | Giles | Virginia | 51071 | 4036 | 46 |
2320263 | 2320263 | 2022-03-18 | Giles | Virginia | 51071 | 4036 | 46 |
2317009 | 2317009 | 2022-03-17 | Giles | Virginia | 51071 | 4036 | 46 |
2313756 | 2313756 | 2022-03-16 | Giles | Virginia | 51071 | 4036 | 46 |
2310503 | 2310503 | 2022-03-15 | Giles | Virginia | 51071 | 4033 | 46 |
2307250 | 2307250 | 2022-03-14 | Giles | Virginia | 51071 | 4030 | 46 |
2303999 | 2303999 | 2022-03-13 | Giles | Virginia | 51071 | 4028 | 45 |
2300747 | 2300747 | 2022-03-12 | Giles | Virginia | 51071 | 4028 | 45 |
2297495 | 2297495 | 2022-03-11 | Giles | Virginia | 51071 | 4028 | 45 |
2294243 | 2294243 | 2022-03-10 | Giles | Virginia | 51071 | 4021 | 44 |
2290991 | 2290991 | 2022-03-09 | Giles | Virginia | 51071 | 4017 | 44 |
2287739 | 2287739 | 2022-03-08 | Giles | Virginia | 51071 | 4014 | 44 |
2284487 | 2284487 | 2022-03-07 | Giles | Virginia | 51071 | 4014 | 44 |
2281235 | 2281235 | 2022-03-06 | Giles | Virginia | 51071 | 4004 | 44 |
2277982 | 2277982 | 2022-03-05 | Giles | Virginia | 51071 | 4004 | 44 |
2274729 | 2274729 | 2022-03-04 | Giles | Virginia | 51071 | 4004 | 44 |
2271476 | 2271476 | 2022-03-03 | Giles | Virginia | 51071 | 3999 | 44 |
2268224 | 2268224 | 2022-03-02 | Giles | Virginia | 51071 | 3995 | 44 |
2264971 | 2264971 | 2022-03-01 | Giles | Virginia | 51071 | 3986 | 44 |
2261721 | 2261721 | 2022-02-28 | Giles | Virginia | 51071 | 3981 | 44 |
2258470 | 2258470 | 2022-02-27 | Giles | Virginia | 51071 | 3968 | 43 |
2255219 | 2255219 | 2022-02-26 | Giles | Virginia | 51071 | 3968 | 43 |
2251968 | 2251968 | 2022-02-25 | Giles | Virginia | 51071 | 3968 | 43 |
2248717 | 2248717 | 2022-02-24 | Giles | Virginia | 51071 | 3963 | 43 |
2245466 | 2245466 | 2022-02-23 | Giles | Virginia | 51071 | 3958 | 43 |
2242215 | 2242215 | 2022-02-22 | Giles | Virginia | 51071 | 3950 | 43 |
2238964 | 2238964 | 2022-02-21 | Giles | Virginia | 51071 | 3945 | 43 |
2235713 | 2235713 | 2022-02-20 | Giles | Virginia | 51071 | 3905 | 43 |
2232462 | 2232462 | 2022-02-19 | Giles | Virginia | 51071 | 3905 | 43 |
2229211 | 2229211 | 2022-02-18 | Giles | Virginia | 51071 | 3905 | 43 |
2225960 | 2225960 | 2022-02-17 | Giles | Virginia | 51071 | 3890 | 43 |
2222709 | 2222709 | 2022-02-16 | Giles | Virginia | 51071 | 3868 | 43 |
2219458 | 2219458 | 2022-02-15 | Giles | Virginia | 51071 | 3844 | 43 |
2216208 | 2216208 | 2022-02-14 | Giles | Virginia | 51071 | 3831 | 43 |
2212957 | 2212957 | 2022-02-13 | Giles | Virginia | 51071 | 3778 | 42 |
2209704 | 2209704 | 2022-02-12 | Giles | Virginia | 51071 | 3778 | 42 |
2206451 | 2206451 | 2022-02-11 | Giles | Virginia | 51071 | 3778 | 42 |
2203198 | 2203198 | 2022-02-10 | Giles | Virginia | 51071 | 3745 | 42 |
2199944 | 2199944 | 2022-02-09 | Giles | Virginia | 51071 | 3720 | 42 |
2196690 | 2196690 | 2022-02-08 | Giles | Virginia | 51071 | 3692 | 42 |
2193435 | 2193435 | 2022-02-07 | Giles | Virginia | 51071 | 3679 | 42 |
2190182 | 2190182 | 2022-02-06 | Giles | Virginia | 51071 | 3604 | 42 |
2186929 | 2186929 | 2022-02-05 | Giles | Virginia | 51071 | 3604 | 42 |
2183676 | 2183676 | 2022-02-04 | Giles | Virginia | 51071 | 3604 | 42 |
2180424 | 2180424 | 2022-02-03 | Giles | Virginia | 51071 | 3574 | 41 |
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);