ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Wood" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420278 | 1420278 | 2021-06-14 | Wood | West Virginia | 54107 | 7921 | 176 |
1417033 | 1417033 | 2021-06-13 | Wood | West Virginia | 54107 | 7918 | 176 |
1413787 | 1413787 | 2021-06-12 | Wood | West Virginia | 54107 | 7918 | 176 |
1410542 | 1410542 | 2021-06-11 | Wood | West Virginia | 54107 | 7918 | 176 |
1407297 | 1407297 | 2021-06-10 | Wood | West Virginia | 54107 | 7917 | 176 |
1404051 | 1404051 | 2021-06-09 | Wood | West Virginia | 54107 | 7912 | 176 |
1400806 | 1400806 | 2021-06-08 | Wood | West Virginia | 54107 | 7912 | 175 |
1397561 | 1397561 | 2021-06-07 | Wood | West Virginia | 54107 | 7909 | 175 |
1394314 | 1394314 | 2021-06-06 | Wood | West Virginia | 54107 | 7902 | 173 |
1391069 | 1391069 | 2021-06-05 | Wood | West Virginia | 54107 | 7902 | 173 |
1387824 | 1387824 | 2021-06-04 | Wood | West Virginia | 54107 | 7902 | 173 |
1384579 | 1384579 | 2021-06-03 | Wood | West Virginia | 54107 | 7898 | 173 |
1381333 | 1381333 | 2021-06-02 | Wood | West Virginia | 54107 | 7895 | 173 |
1378088 | 1378088 | 2021-06-01 | Wood | West Virginia | 54107 | 7892 | 173 |
1374842 | 1374842 | 2021-05-31 | Wood | West Virginia | 54107 | 7879 | 173 |
1371597 | 1371597 | 2021-05-30 | Wood | West Virginia | 54107 | 7879 | 173 |
1368351 | 1368351 | 2021-05-29 | Wood | West Virginia | 54107 | 7879 | 173 |
1365105 | 1365105 | 2021-05-28 | Wood | West Virginia | 54107 | 7879 | 173 |
1361859 | 1361859 | 2021-05-27 | Wood | West Virginia | 54107 | 7875 | 173 |
1358613 | 1358613 | 2021-05-26 | Wood | West Virginia | 54107 | 7873 | 172 |
1355367 | 1355367 | 2021-05-25 | Wood | West Virginia | 54107 | 7868 | 172 |
1352121 | 1352121 | 2021-05-24 | Wood | West Virginia | 54107 | 7864 | 171 |
1348875 | 1348875 | 2021-05-23 | Wood | West Virginia | 54107 | 7850 | 170 |
1345627 | 1345627 | 2021-05-22 | Wood | West Virginia | 54107 | 7850 | 170 |
1342379 | 1342379 | 2021-05-21 | Wood | West Virginia | 54107 | 7850 | 170 |
1339131 | 1339131 | 2021-05-20 | Wood | West Virginia | 54107 | 7838 | 170 |
1335884 | 1335884 | 2021-05-19 | Wood | West Virginia | 54107 | 7831 | 170 |
1332637 | 1332637 | 2021-05-18 | Wood | West Virginia | 54107 | 7826 | 170 |
1329390 | 1329390 | 2021-05-17 | Wood | West Virginia | 54107 | 7816 | 170 |
1326144 | 1326144 | 2021-05-16 | Wood | West Virginia | 54107 | 7812 | 170 |
1322898 | 1322898 | 2021-05-15 | Wood | West Virginia | 54107 | 7802 | 169 |
1319652 | 1319652 | 2021-05-14 | Wood | West Virginia | 54107 | 7796 | 169 |
1316404 | 1316404 | 2021-05-13 | Wood | West Virginia | 54107 | 7788 | 169 |
1313158 | 1313158 | 2021-05-12 | Wood | West Virginia | 54107 | 7767 | 169 |
1309911 | 1309911 | 2021-05-11 | Wood | West Virginia | 54107 | 7757 | 168 |
1306665 | 1306665 | 2021-05-10 | Wood | West Virginia | 54107 | 7751 | 168 |
1303419 | 1303419 | 2021-05-09 | Wood | West Virginia | 54107 | 7747 | 168 |
1300172 | 1300172 | 2021-05-08 | Wood | West Virginia | 54107 | 7737 | 168 |
1296925 | 1296925 | 2021-05-07 | Wood | West Virginia | 54107 | 7733 | 168 |
1293679 | 1293679 | 2021-05-06 | Wood | West Virginia | 54107 | 7720 | 168 |
1290433 | 1290433 | 2021-05-05 | Wood | West Virginia | 54107 | 7713 | 168 |
1287187 | 1287187 | 2021-05-04 | Wood | West Virginia | 54107 | 7701 | 165 |
1283941 | 1283941 | 2021-05-03 | Wood | West Virginia | 54107 | 7693 | 165 |
1280694 | 1280694 | 2021-05-02 | Wood | West Virginia | 54107 | 7687 | 165 |
1277447 | 1277447 | 2021-05-01 | Wood | West Virginia | 54107 | 7678 | 165 |
1274200 | 1274200 | 2021-04-30 | Wood | West Virginia | 54107 | 7669 | 165 |
1270953 | 1270953 | 2021-04-29 | Wood | West Virginia | 54107 | 7662 | 165 |
1267706 | 1267706 | 2021-04-28 | Wood | West Virginia | 54107 | 7653 | 165 |
1264459 | 1264459 | 2021-04-27 | Wood | West Virginia | 54107 | 7640 | 165 |
1261212 | 1261212 | 2021-04-26 | Wood | West Virginia | 54107 | 7635 | 168 |
1257965 | 1257965 | 2021-04-25 | Wood | West Virginia | 54107 | 7626 | 168 |
1254718 | 1254718 | 2021-04-24 | Wood | West Virginia | 54107 | 7620 | 168 |
1251471 | 1251471 | 2021-04-23 | Wood | West Virginia | 54107 | 7608 | 168 |
1248224 | 1248224 | 2021-04-22 | Wood | West Virginia | 54107 | 7600 | 168 |
1244977 | 1244977 | 2021-04-21 | Wood | West Virginia | 54107 | 7591 | 168 |
1241730 | 1241730 | 2021-04-20 | Wood | West Virginia | 54107 | 7580 | 167 |
1238483 | 1238483 | 2021-04-19 | Wood | West Virginia | 54107 | 7578 | 168 |
1235236 | 1235236 | 2021-04-18 | Wood | West Virginia | 54107 | 7575 | 168 |
1231988 | 1231988 | 2021-04-17 | Wood | West Virginia | 54107 | 7573 | 168 |
1228740 | 1228740 | 2021-04-16 | Wood | West Virginia | 54107 | 7564 | 167 |
1225492 | 1225492 | 2021-04-15 | Wood | West Virginia | 54107 | 7554 | 167 |
1222245 | 1222245 | 2021-04-14 | Wood | West Virginia | 54107 | 7548 | 167 |
1218997 | 1218997 | 2021-04-13 | Wood | West Virginia | 54107 | 7543 | 166 |
1215749 | 1215749 | 2021-04-12 | Wood | West Virginia | 54107 | 7538 | 166 |
1212502 | 1212502 | 2021-04-11 | Wood | West Virginia | 54107 | 7536 | 166 |
1209253 | 1209253 | 2021-04-10 | Wood | West Virginia | 54107 | 7531 | 166 |
1206005 | 1206005 | 2021-04-09 | Wood | West Virginia | 54107 | 7518 | 166 |
1202757 | 1202757 | 2021-04-08 | Wood | West Virginia | 54107 | 7505 | 166 |
1199509 | 1199509 | 2021-04-07 | Wood | West Virginia | 54107 | 7493 | 166 |
1196260 | 1196260 | 2021-04-06 | Wood | West Virginia | 54107 | 7487 | 166 |
1193012 | 1193012 | 2021-04-05 | Wood | West Virginia | 54107 | 7481 | 164 |
1189762 | 1189762 | 2021-04-04 | Wood | West Virginia | 54107 | 7475 | 164 |
1186515 | 1186515 | 2021-04-03 | Wood | West Virginia | 54107 | 7469 | 164 |
1183268 | 1183268 | 2021-04-02 | Wood | West Virginia | 54107 | 7460 | 164 |
1180021 | 1180021 | 2021-04-01 | Wood | West Virginia | 54107 | 7458 | 164 |
1176774 | 1176774 | 2021-03-31 | Wood | West Virginia | 54107 | 7446 | 164 |
1173527 | 1173527 | 2021-03-30 | Wood | West Virginia | 54107 | 7438 | 163 |
1170280 | 1170280 | 2021-03-29 | Wood | West Virginia | 54107 | 7427 | 163 |
1167032 | 1167032 | 2021-03-28 | Wood | West Virginia | 54107 | 7422 | 163 |
1163784 | 1163784 | 2021-03-27 | Wood | West Virginia | 54107 | 7404 | 163 |
1160536 | 1160536 | 2021-03-26 | Wood | West Virginia | 54107 | 7395 | 163 |
1157288 | 1157288 | 2021-03-25 | Wood | West Virginia | 54107 | 7378 | 163 |
1154041 | 1154041 | 2021-03-24 | Wood | West Virginia | 54107 | 7359 | 162 |
1150794 | 1150794 | 2021-03-23 | Wood | West Virginia | 54107 | 7343 | 162 |
1147547 | 1147547 | 2021-03-22 | Wood | West Virginia | 54107 | 7323 | 161 |
1144300 | 1144300 | 2021-03-21 | Wood | West Virginia | 54107 | 7310 | 161 |
1141053 | 1141053 | 2021-03-20 | Wood | West Virginia | 54107 | 7293 | 160 |
1137807 | 1137807 | 2021-03-19 | Wood | West Virginia | 54107 | 7285 | 160 |
1134561 | 1134561 | 2021-03-18 | Wood | West Virginia | 54107 | 7280 | 157 |
1131313 | 1131313 | 2021-03-17 | Wood | West Virginia | 54107 | 7264 | 157 |
1128066 | 1128066 | 2021-03-16 | Wood | West Virginia | 54107 | 7263 | 157 |
1124820 | 1124820 | 2021-03-15 | Wood | West Virginia | 54107 | 7260 | 155 |
1121574 | 1121574 | 2021-03-14 | Wood | West Virginia | 54107 | 7254 | 155 |
1118327 | 1118327 | 2021-03-13 | Wood | West Virginia | 54107 | 7241 | 155 |
1115080 | 1115080 | 2021-03-12 | Wood | West Virginia | 54107 | 7226 | 156 |
1111834 | 1111834 | 2021-03-11 | Wood | West Virginia | 54107 | 7205 | 133 |
1108588 | 1108588 | 2021-03-10 | Wood | West Virginia | 54107 | 7194 | 132 |
1105342 | 1105342 | 2021-03-09 | Wood | West Virginia | 54107 | 7176 | 132 |
1102096 | 1102096 | 2021-03-08 | Wood | West Virginia | 54107 | 7165 | 132 |
1098850 | 1098850 | 2021-03-07 | Wood | West Virginia | 54107 | 7154 | 132 |
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);