ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Staunton city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420171 | 1420171 | 2021-06-14 | Staunton city | Virginia | 51790 | 2527 | 71 |
1416926 | 1416926 | 2021-06-13 | Staunton city | Virginia | 51790 | 2527 | 71 |
1413680 | 1413680 | 2021-06-12 | Staunton city | Virginia | 51790 | 2527 | 71 |
1410435 | 1410435 | 2021-06-11 | Staunton city | Virginia | 51790 | 2527 | 71 |
1407190 | 1407190 | 2021-06-10 | Staunton city | Virginia | 51790 | 2526 | 71 |
1403944 | 1403944 | 2021-06-09 | Staunton city | Virginia | 51790 | 2526 | 71 |
1400699 | 1400699 | 2021-06-08 | Staunton city | Virginia | 51790 | 2525 | 71 |
1397454 | 1397454 | 2021-06-07 | Staunton city | Virginia | 51790 | 2525 | 71 |
1394207 | 1394207 | 2021-06-06 | Staunton city | Virginia | 51790 | 2525 | 71 |
1390962 | 1390962 | 2021-06-05 | Staunton city | Virginia | 51790 | 2525 | 71 |
1387717 | 1387717 | 2021-06-04 | Staunton city | Virginia | 51790 | 2525 | 71 |
1384472 | 1384472 | 2021-06-03 | Staunton city | Virginia | 51790 | 2526 | 71 |
1381226 | 1381226 | 2021-06-02 | Staunton city | Virginia | 51790 | 2525 | 71 |
1377981 | 1377981 | 2021-06-01 | Staunton city | Virginia | 51790 | 2524 | 71 |
1374735 | 1374735 | 2021-05-31 | Staunton city | Virginia | 51790 | 2524 | 71 |
1371490 | 1371490 | 2021-05-30 | Staunton city | Virginia | 51790 | 2524 | 71 |
1368244 | 1368244 | 2021-05-29 | Staunton city | Virginia | 51790 | 2525 | 71 |
1364998 | 1364998 | 2021-05-28 | Staunton city | Virginia | 51790 | 2524 | 71 |
1361752 | 1361752 | 2021-05-27 | Staunton city | Virginia | 51790 | 2525 | 71 |
1358506 | 1358506 | 2021-05-26 | Staunton city | Virginia | 51790 | 2524 | 71 |
1355260 | 1355260 | 2021-05-25 | Staunton city | Virginia | 51790 | 2524 | 71 |
1352014 | 1352014 | 2021-05-24 | Staunton city | Virginia | 51790 | 2524 | 71 |
1348768 | 1348768 | 2021-05-23 | Staunton city | Virginia | 51790 | 2524 | 71 |
1345520 | 1345520 | 2021-05-22 | Staunton city | Virginia | 51790 | 2525 | 71 |
1342272 | 1342272 | 2021-05-21 | Staunton city | Virginia | 51790 | 2525 | 71 |
1339024 | 1339024 | 2021-05-20 | Staunton city | Virginia | 51790 | 2527 | 71 |
1335777 | 1335777 | 2021-05-19 | Staunton city | Virginia | 51790 | 2526 | 71 |
1332530 | 1332530 | 2021-05-18 | Staunton city | Virginia | 51790 | 2527 | 71 |
1329283 | 1329283 | 2021-05-17 | Staunton city | Virginia | 51790 | 2527 | 71 |
1326037 | 1326037 | 2021-05-16 | Staunton city | Virginia | 51790 | 2526 | 71 |
1322791 | 1322791 | 2021-05-15 | Staunton city | Virginia | 51790 | 2526 | 71 |
1319545 | 1319545 | 2021-05-14 | Staunton city | Virginia | 51790 | 2526 | 71 |
1316297 | 1316297 | 2021-05-13 | Staunton city | Virginia | 51790 | 2526 | 71 |
1313051 | 1313051 | 2021-05-12 | Staunton city | Virginia | 51790 | 2527 | 71 |
1309804 | 1309804 | 2021-05-11 | Staunton city | Virginia | 51790 | 2527 | 71 |
1306558 | 1306558 | 2021-05-10 | Staunton city | Virginia | 51790 | 2524 | 71 |
1303312 | 1303312 | 2021-05-09 | Staunton city | Virginia | 51790 | 2518 | 71 |
1300065 | 1300065 | 2021-05-08 | Staunton city | Virginia | 51790 | 2514 | 71 |
1296818 | 1296818 | 2021-05-07 | Staunton city | Virginia | 51790 | 2513 | 71 |
1293572 | 1293572 | 2021-05-06 | Staunton city | Virginia | 51790 | 2511 | 71 |
1290326 | 1290326 | 2021-05-05 | Staunton city | Virginia | 51790 | 2512 | 71 |
1287080 | 1287080 | 2021-05-04 | Staunton city | Virginia | 51790 | 2510 | 70 |
1283834 | 1283834 | 2021-05-03 | Staunton city | Virginia | 51790 | 2505 | 70 |
1280587 | 1280587 | 2021-05-02 | Staunton city | Virginia | 51790 | 2503 | 70 |
1277340 | 1277340 | 2021-05-01 | Staunton city | Virginia | 51790 | 2500 | 70 |
1274093 | 1274093 | 2021-04-30 | Staunton city | Virginia | 51790 | 2494 | 69 |
1270846 | 1270846 | 2021-04-29 | Staunton city | Virginia | 51790 | 2490 | 69 |
1267599 | 1267599 | 2021-04-28 | Staunton city | Virginia | 51790 | 2490 | 69 |
1264352 | 1264352 | 2021-04-27 | Staunton city | Virginia | 51790 | 2490 | 69 |
1261105 | 1261105 | 2021-04-26 | Staunton city | Virginia | 51790 | 2489 | 68 |
1257858 | 1257858 | 2021-04-25 | Staunton city | Virginia | 51790 | 2488 | 68 |
1254611 | 1254611 | 2021-04-24 | Staunton city | Virginia | 51790 | 2484 | 68 |
1251364 | 1251364 | 2021-04-23 | Staunton city | Virginia | 51790 | 2486 | 68 |
1248117 | 1248117 | 2021-04-22 | Staunton city | Virginia | 51790 | 2482 | 68 |
1244870 | 1244870 | 2021-04-21 | Staunton city | Virginia | 51790 | 2478 | 68 |
1241623 | 1241623 | 2021-04-20 | Staunton city | Virginia | 51790 | 2477 | 68 |
1238376 | 1238376 | 2021-04-19 | Staunton city | Virginia | 51790 | 2477 | 68 |
1235129 | 1235129 | 2021-04-18 | Staunton city | Virginia | 51790 | 2474 | 68 |
1231881 | 1231881 | 2021-04-17 | Staunton city | Virginia | 51790 | 2471 | 68 |
1228633 | 1228633 | 2021-04-16 | Staunton city | Virginia | 51790 | 2469 | 68 |
1225385 | 1225385 | 2021-04-15 | Staunton city | Virginia | 51790 | 2469 | 68 |
1222138 | 1222138 | 2021-04-14 | Staunton city | Virginia | 51790 | 2465 | 68 |
1218890 | 1218890 | 2021-04-13 | Staunton city | Virginia | 51790 | 2464 | 67 |
1215642 | 1215642 | 2021-04-12 | Staunton city | Virginia | 51790 | 2448 | 67 |
1212395 | 1212395 | 2021-04-11 | Staunton city | Virginia | 51790 | 2445 | 67 |
1209146 | 1209146 | 2021-04-10 | Staunton city | Virginia | 51790 | 2439 | 67 |
1205898 | 1205898 | 2021-04-09 | Staunton city | Virginia | 51790 | 2434 | 67 |
1202650 | 1202650 | 2021-04-08 | Staunton city | Virginia | 51790 | 2437 | 67 |
1199402 | 1199402 | 2021-04-07 | Staunton city | Virginia | 51790 | 2499 | 67 |
1196153 | 1196153 | 2021-04-06 | Staunton city | Virginia | 51790 | 2551 | 67 |
1192905 | 1192905 | 2021-04-05 | Staunton city | Virginia | 51790 | 2546 | 67 |
1189655 | 1189655 | 2021-04-04 | Staunton city | Virginia | 51790 | 2544 | 67 |
1186408 | 1186408 | 2021-04-03 | Staunton city | Virginia | 51790 | 2537 | 67 |
1183161 | 1183161 | 2021-04-02 | Staunton city | Virginia | 51790 | 2533 | 67 |
1179914 | 1179914 | 2021-04-01 | Staunton city | Virginia | 51790 | 2533 | 67 |
1176667 | 1176667 | 2021-03-31 | Staunton city | Virginia | 51790 | 2527 | 67 |
1173420 | 1173420 | 2021-03-30 | Staunton city | Virginia | 51790 | 2524 | 67 |
1170173 | 1170173 | 2021-03-29 | Staunton city | Virginia | 51790 | 2526 | 66 |
1166925 | 1166925 | 2021-03-28 | Staunton city | Virginia | 51790 | 2526 | 66 |
1163677 | 1163677 | 2021-03-27 | Staunton city | Virginia | 51790 | 2525 | 66 |
1160429 | 1160429 | 2021-03-26 | Staunton city | Virginia | 51790 | 2517 | 66 |
1157181 | 1157181 | 2021-03-25 | Staunton city | Virginia | 51790 | 2512 | 66 |
1153934 | 1153934 | 2021-03-24 | Staunton city | Virginia | 51790 | 2511 | 66 |
1150687 | 1150687 | 2021-03-23 | Staunton city | Virginia | 51790 | 2506 | 66 |
1147440 | 1147440 | 2021-03-22 | Staunton city | Virginia | 51790 | 2505 | 66 |
1144193 | 1144193 | 2021-03-21 | Staunton city | Virginia | 51790 | 2506 | 66 |
1140946 | 1140946 | 2021-03-20 | Staunton city | Virginia | 51790 | 2505 | 66 |
1137700 | 1137700 | 2021-03-19 | Staunton city | Virginia | 51790 | 2504 | 66 |
1134454 | 1134454 | 2021-03-18 | Staunton city | Virginia | 51790 | 2500 | 68 |
1131206 | 1131206 | 2021-03-17 | Staunton city | Virginia | 51790 | 2495 | 68 |
1127959 | 1127959 | 2021-03-16 | Staunton city | Virginia | 51790 | 2496 | 69 |
1124713 | 1124713 | 2021-03-15 | Staunton city | Virginia | 51790 | 2492 | 69 |
1121467 | 1121467 | 2021-03-14 | Staunton city | Virginia | 51790 | 2490 | 69 |
1118220 | 1118220 | 2021-03-13 | Staunton city | Virginia | 51790 | 2489 | 69 |
1114973 | 1114973 | 2021-03-12 | Staunton city | Virginia | 51790 | 2489 | 69 |
1111727 | 1111727 | 2021-03-11 | Staunton city | Virginia | 51790 | 2488 | 68 |
1108481 | 1108481 | 2021-03-10 | Staunton city | Virginia | 51790 | 2488 | 68 |
1105235 | 1105235 | 2021-03-09 | Staunton city | Virginia | 51790 | 2483 | 68 |
1101989 | 1101989 | 2021-03-08 | Staunton city | Virginia | 51790 | 2478 | 67 |
1098743 | 1098743 | 2021-03-07 | Staunton city | Virginia | 51790 | 2473 | 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);