ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Surry" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420173 | 1420173 | 2021-06-14 | Surry | Virginia | 51181 | 423 | 9 |
1416928 | 1416928 | 2021-06-13 | Surry | Virginia | 51181 | 423 | 9 |
1413682 | 1413682 | 2021-06-12 | Surry | Virginia | 51181 | 423 | 9 |
1410437 | 1410437 | 2021-06-11 | Surry | Virginia | 51181 | 422 | 9 |
1407192 | 1407192 | 2021-06-10 | Surry | Virginia | 51181 | 422 | 9 |
1403946 | 1403946 | 2021-06-09 | Surry | Virginia | 51181 | 422 | 9 |
1400701 | 1400701 | 2021-06-08 | Surry | Virginia | 51181 | 422 | 9 |
1397456 | 1397456 | 2021-06-07 | Surry | Virginia | 51181 | 422 | 9 |
1394209 | 1394209 | 2021-06-06 | Surry | Virginia | 51181 | 421 | 9 |
1390964 | 1390964 | 2021-06-05 | Surry | Virginia | 51181 | 421 | 9 |
1387719 | 1387719 | 2021-06-04 | Surry | Virginia | 51181 | 421 | 9 |
1384474 | 1384474 | 2021-06-03 | Surry | Virginia | 51181 | 421 | 9 |
1381228 | 1381228 | 2021-06-02 | Surry | Virginia | 51181 | 421 | 9 |
1377983 | 1377983 | 2021-06-01 | Surry | Virginia | 51181 | 421 | 9 |
1374737 | 1374737 | 2021-05-31 | Surry | Virginia | 51181 | 421 | 9 |
1371492 | 1371492 | 2021-05-30 | Surry | Virginia | 51181 | 421 | 9 |
1368246 | 1368246 | 2021-05-29 | Surry | Virginia | 51181 | 421 | 9 |
1365000 | 1365000 | 2021-05-28 | Surry | Virginia | 51181 | 421 | 9 |
1361754 | 1361754 | 2021-05-27 | Surry | Virginia | 51181 | 421 | 9 |
1358508 | 1358508 | 2021-05-26 | Surry | Virginia | 51181 | 421 | 9 |
1355262 | 1355262 | 2021-05-25 | Surry | Virginia | 51181 | 421 | 9 |
1352016 | 1352016 | 2021-05-24 | Surry | Virginia | 51181 | 421 | 9 |
1348770 | 1348770 | 2021-05-23 | Surry | Virginia | 51181 | 420 | 9 |
1345522 | 1345522 | 2021-05-22 | Surry | Virginia | 51181 | 420 | 9 |
1342274 | 1342274 | 2021-05-21 | Surry | Virginia | 51181 | 420 | 9 |
1339026 | 1339026 | 2021-05-20 | Surry | Virginia | 51181 | 421 | 9 |
1335779 | 1335779 | 2021-05-19 | Surry | Virginia | 51181 | 421 | 9 |
1332532 | 1332532 | 2021-05-18 | Surry | Virginia | 51181 | 422 | 9 |
1329285 | 1329285 | 2021-05-17 | Surry | Virginia | 51181 | 422 | 9 |
1326039 | 1326039 | 2021-05-16 | Surry | Virginia | 51181 | 422 | 9 |
1322793 | 1322793 | 2021-05-15 | Surry | Virginia | 51181 | 423 | 9 |
1319547 | 1319547 | 2021-05-14 | Surry | Virginia | 51181 | 423 | 9 |
1316299 | 1316299 | 2021-05-13 | Surry | Virginia | 51181 | 423 | 9 |
1313053 | 1313053 | 2021-05-12 | Surry | Virginia | 51181 | 423 | 9 |
1309806 | 1309806 | 2021-05-11 | Surry | Virginia | 51181 | 423 | 9 |
1306560 | 1306560 | 2021-05-10 | Surry | Virginia | 51181 | 423 | 9 |
1303314 | 1303314 | 2021-05-09 | Surry | Virginia | 51181 | 423 | 9 |
1300067 | 1300067 | 2021-05-08 | Surry | Virginia | 51181 | 423 | 9 |
1296820 | 1296820 | 2021-05-07 | Surry | Virginia | 51181 | 423 | 9 |
1293574 | 1293574 | 2021-05-06 | Surry | Virginia | 51181 | 424 | 9 |
1290328 | 1290328 | 2021-05-05 | Surry | Virginia | 51181 | 421 | 9 |
1287082 | 1287082 | 2021-05-04 | Surry | Virginia | 51181 | 421 | 9 |
1283836 | 1283836 | 2021-05-03 | Surry | Virginia | 51181 | 421 | 9 |
1280589 | 1280589 | 2021-05-02 | Surry | Virginia | 51181 | 421 | 9 |
1277342 | 1277342 | 2021-05-01 | Surry | Virginia | 51181 | 421 | 9 |
1274095 | 1274095 | 2021-04-30 | Surry | Virginia | 51181 | 421 | 9 |
1270848 | 1270848 | 2021-04-29 | Surry | Virginia | 51181 | 417 | 9 |
1267601 | 1267601 | 2021-04-28 | Surry | Virginia | 51181 | 417 | 9 |
1264354 | 1264354 | 2021-04-27 | Surry | Virginia | 51181 | 417 | 9 |
1261107 | 1261107 | 2021-04-26 | Surry | Virginia | 51181 | 417 | 9 |
1257860 | 1257860 | 2021-04-25 | Surry | Virginia | 51181 | 415 | 9 |
1254613 | 1254613 | 2021-04-24 | Surry | Virginia | 51181 | 415 | 9 |
1251366 | 1251366 | 2021-04-23 | Surry | Virginia | 51181 | 415 | 9 |
1248119 | 1248119 | 2021-04-22 | Surry | Virginia | 51181 | 414 | 9 |
1244872 | 1244872 | 2021-04-21 | Surry | Virginia | 51181 | 414 | 9 |
1241625 | 1241625 | 2021-04-20 | Surry | Virginia | 51181 | 414 | 9 |
1238378 | 1238378 | 2021-04-19 | Surry | Virginia | 51181 | 413 | 9 |
1235131 | 1235131 | 2021-04-18 | Surry | Virginia | 51181 | 413 | 9 |
1231883 | 1231883 | 2021-04-17 | Surry | Virginia | 51181 | 413 | 9 |
1228635 | 1228635 | 2021-04-16 | Surry | Virginia | 51181 | 412 | 9 |
1225387 | 1225387 | 2021-04-15 | Surry | Virginia | 51181 | 412 | 9 |
1222140 | 1222140 | 2021-04-14 | Surry | Virginia | 51181 | 411 | 9 |
1218892 | 1218892 | 2021-04-13 | Surry | Virginia | 51181 | 411 | 9 |
1215644 | 1215644 | 2021-04-12 | Surry | Virginia | 51181 | 412 | 9 |
1212397 | 1212397 | 2021-04-11 | Surry | Virginia | 51181 | 411 | 9 |
1209148 | 1209148 | 2021-04-10 | Surry | Virginia | 51181 | 409 | 9 |
1205900 | 1205900 | 2021-04-09 | Surry | Virginia | 51181 | 409 | 9 |
1202652 | 1202652 | 2021-04-08 | Surry | Virginia | 51181 | 407 | 9 |
1199404 | 1199404 | 2021-04-07 | Surry | Virginia | 51181 | 407 | 9 |
1196155 | 1196155 | 2021-04-06 | Surry | Virginia | 51181 | 407 | 9 |
1192907 | 1192907 | 2021-04-05 | Surry | Virginia | 51181 | 407 | 9 |
1189657 | 1189657 | 2021-04-04 | Surry | Virginia | 51181 | 407 | 9 |
1186410 | 1186410 | 2021-04-03 | Surry | Virginia | 51181 | 407 | 9 |
1183163 | 1183163 | 2021-04-02 | Surry | Virginia | 51181 | 406 | 9 |
1179916 | 1179916 | 2021-04-01 | Surry | Virginia | 51181 | 405 | 9 |
1176669 | 1176669 | 2021-03-31 | Surry | Virginia | 51181 | 405 | 9 |
1173422 | 1173422 | 2021-03-30 | Surry | Virginia | 51181 | 405 | 9 |
1170175 | 1170175 | 2021-03-29 | Surry | Virginia | 51181 | 405 | 9 |
1166927 | 1166927 | 2021-03-28 | Surry | Virginia | 51181 | 405 | 9 |
1163679 | 1163679 | 2021-03-27 | Surry | Virginia | 51181 | 403 | 9 |
1160431 | 1160431 | 2021-03-26 | Surry | Virginia | 51181 | 402 | 9 |
1157183 | 1157183 | 2021-03-25 | Surry | Virginia | 51181 | 400 | 9 |
1153936 | 1153936 | 2021-03-24 | Surry | Virginia | 51181 | 400 | 9 |
1150689 | 1150689 | 2021-03-23 | Surry | Virginia | 51181 | 400 | 9 |
1147442 | 1147442 | 2021-03-22 | Surry | Virginia | 51181 | 400 | 9 |
1144195 | 1144195 | 2021-03-21 | Surry | Virginia | 51181 | 400 | 9 |
1140948 | 1140948 | 2021-03-20 | Surry | Virginia | 51181 | 398 | 9 |
1137702 | 1137702 | 2021-03-19 | Surry | Virginia | 51181 | 398 | 9 |
1134456 | 1134456 | 2021-03-18 | Surry | Virginia | 51181 | 397 | 9 |
1131208 | 1131208 | 2021-03-17 | Surry | Virginia | 51181 | 398 | 9 |
1127961 | 1127961 | 2021-03-16 | Surry | Virginia | 51181 | 398 | 9 |
1124715 | 1124715 | 2021-03-15 | Surry | Virginia | 51181 | 395 | 8 |
1121469 | 1121469 | 2021-03-14 | Surry | Virginia | 51181 | 394 | 8 |
1118222 | 1118222 | 2021-03-13 | Surry | Virginia | 51181 | 389 | 8 |
1114975 | 1114975 | 2021-03-12 | Surry | Virginia | 51181 | 384 | 8 |
1111729 | 1111729 | 2021-03-11 | Surry | Virginia | 51181 | 384 | 8 |
1108483 | 1108483 | 2021-03-10 | Surry | Virginia | 51181 | 385 | 8 |
1105237 | 1105237 | 2021-03-09 | Surry | Virginia | 51181 | 383 | 8 |
1101991 | 1101991 | 2021-03-08 | Surry | Virginia | 51181 | 381 | 8 |
1098745 | 1098745 | 2021-03-07 | Surry | Virginia | 51181 | 377 | 8 |
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);