ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 54055 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 |
---|---|---|---|---|---|---|---|
1420252 | 1420252 | 2021-06-14 | Mercer | West Virginia | 54055 | 5105 | 121 |
1417007 | 1417007 | 2021-06-13 | Mercer | West Virginia | 54055 | 5100 | 121 |
1413761 | 1413761 | 2021-06-12 | Mercer | West Virginia | 54055 | 5100 | 121 |
1410516 | 1410516 | 2021-06-11 | Mercer | West Virginia | 54055 | 5100 | 121 |
1407271 | 1407271 | 2021-06-10 | Mercer | West Virginia | 54055 | 5096 | 121 |
1404025 | 1404025 | 2021-06-09 | Mercer | West Virginia | 54055 | 5092 | 121 |
1400780 | 1400780 | 2021-06-08 | Mercer | West Virginia | 54055 | 5087 | 120 |
1397535 | 1397535 | 2021-06-07 | Mercer | West Virginia | 54055 | 5087 | 120 |
1394288 | 1394288 | 2021-06-06 | Mercer | West Virginia | 54055 | 5076 | 120 |
1391043 | 1391043 | 2021-06-05 | Mercer | West Virginia | 54055 | 5076 | 120 |
1387798 | 1387798 | 2021-06-04 | Mercer | West Virginia | 54055 | 5076 | 120 |
1384553 | 1384553 | 2021-06-03 | Mercer | West Virginia | 54055 | 5072 | 119 |
1381307 | 1381307 | 2021-06-02 | Mercer | West Virginia | 54055 | 5068 | 119 |
1378062 | 1378062 | 2021-06-01 | Mercer | West Virginia | 54055 | 5064 | 119 |
1374816 | 1374816 | 2021-05-31 | Mercer | West Virginia | 54055 | 5043 | 119 |
1371571 | 1371571 | 2021-05-30 | Mercer | West Virginia | 54055 | 5043 | 119 |
1368325 | 1368325 | 2021-05-29 | Mercer | West Virginia | 54055 | 5043 | 119 |
1365079 | 1365079 | 2021-05-28 | Mercer | West Virginia | 54055 | 5043 | 119 |
1361833 | 1361833 | 2021-05-27 | Mercer | West Virginia | 54055 | 5037 | 119 |
1358587 | 1358587 | 2021-05-26 | Mercer | West Virginia | 54055 | 5021 | 119 |
1355341 | 1355341 | 2021-05-25 | Mercer | West Virginia | 54055 | 5015 | 117 |
1352095 | 1352095 | 2021-05-24 | Mercer | West Virginia | 54055 | 4999 | 117 |
1348849 | 1348849 | 2021-05-23 | Mercer | West Virginia | 54055 | 4962 | 117 |
1345601 | 1345601 | 2021-05-22 | Mercer | West Virginia | 54055 | 4962 | 117 |
1342353 | 1342353 | 2021-05-21 | Mercer | West Virginia | 54055 | 4962 | 117 |
1339105 | 1339105 | 2021-05-20 | Mercer | West Virginia | 54055 | 4943 | 117 |
1335858 | 1335858 | 2021-05-19 | Mercer | West Virginia | 54055 | 4929 | 116 |
1332611 | 1332611 | 2021-05-18 | Mercer | West Virginia | 54055 | 4919 | 116 |
1329364 | 1329364 | 2021-05-17 | Mercer | West Virginia | 54055 | 4908 | 116 |
1326118 | 1326118 | 2021-05-16 | Mercer | West Virginia | 54055 | 4901 | 116 |
1322872 | 1322872 | 2021-05-15 | Mercer | West Virginia | 54055 | 4886 | 116 |
1319626 | 1319626 | 2021-05-14 | Mercer | West Virginia | 54055 | 4870 | 116 |
1316378 | 1316378 | 2021-05-13 | Mercer | West Virginia | 54055 | 4856 | 116 |
1313132 | 1313132 | 2021-05-12 | Mercer | West Virginia | 54055 | 4831 | 116 |
1309885 | 1309885 | 2021-05-11 | Mercer | West Virginia | 54055 | 4815 | 115 |
1306639 | 1306639 | 2021-05-10 | Mercer | West Virginia | 54055 | 4808 | 115 |
1303393 | 1303393 | 2021-05-09 | Mercer | West Virginia | 54055 | 4801 | 115 |
1300146 | 1300146 | 2021-05-08 | Mercer | West Virginia | 54055 | 4792 | 115 |
1296899 | 1296899 | 2021-05-07 | Mercer | West Virginia | 54055 | 4777 | 115 |
1293653 | 1293653 | 2021-05-06 | Mercer | West Virginia | 54055 | 4762 | 115 |
1290407 | 1290407 | 2021-05-05 | Mercer | West Virginia | 54055 | 4752 | 116 |
1287161 | 1287161 | 2021-05-04 | Mercer | West Virginia | 54055 | 4740 | 116 |
1283915 | 1283915 | 2021-05-03 | Mercer | West Virginia | 54055 | 4733 | 116 |
1280668 | 1280668 | 2021-05-02 | Mercer | West Virginia | 54055 | 4722 | 116 |
1277421 | 1277421 | 2021-05-01 | Mercer | West Virginia | 54055 | 4700 | 116 |
1274174 | 1274174 | 2021-04-30 | Mercer | West Virginia | 54055 | 4682 | 116 |
1270927 | 1270927 | 2021-04-29 | Mercer | West Virginia | 54055 | 4666 | 116 |
1267680 | 1267680 | 2021-04-28 | Mercer | West Virginia | 54055 | 4657 | 116 |
1264433 | 1264433 | 2021-04-27 | Mercer | West Virginia | 54055 | 4645 | 116 |
1261186 | 1261186 | 2021-04-26 | Mercer | West Virginia | 54055 | 4637 | 125 |
1257939 | 1257939 | 2021-04-25 | Mercer | West Virginia | 54055 | 4625 | 125 |
1254692 | 1254692 | 2021-04-24 | Mercer | West Virginia | 54055 | 4616 | 125 |
1251445 | 1251445 | 2021-04-23 | Mercer | West Virginia | 54055 | 4604 | 125 |
1248198 | 1248198 | 2021-04-22 | Mercer | West Virginia | 54055 | 4596 | 125 |
1244951 | 1244951 | 2021-04-21 | Mercer | West Virginia | 54055 | 4591 | 125 |
1241704 | 1241704 | 2021-04-20 | Mercer | West Virginia | 54055 | 4580 | 125 |
1238457 | 1238457 | 2021-04-19 | Mercer | West Virginia | 54055 | 4574 | 125 |
1235210 | 1235210 | 2021-04-18 | Mercer | West Virginia | 54055 | 4565 | 125 |
1231962 | 1231962 | 2021-04-17 | Mercer | West Virginia | 54055 | 4557 | 125 |
1228714 | 1228714 | 2021-04-16 | Mercer | West Virginia | 54055 | 4548 | 125 |
1225466 | 1225466 | 2021-04-15 | Mercer | West Virginia | 54055 | 4541 | 125 |
1222219 | 1222219 | 2021-04-14 | Mercer | West Virginia | 54055 | 4526 | 125 |
1218971 | 1218971 | 2021-04-13 | Mercer | West Virginia | 54055 | 4512 | 125 |
1215723 | 1215723 | 2021-04-12 | Mercer | West Virginia | 54055 | 4503 | 125 |
1212476 | 1212476 | 2021-04-11 | Mercer | West Virginia | 54055 | 4488 | 125 |
1209227 | 1209227 | 2021-04-10 | Mercer | West Virginia | 54055 | 4467 | 125 |
1205979 | 1205979 | 2021-04-09 | Mercer | West Virginia | 54055 | 4452 | 125 |
1202731 | 1202731 | 2021-04-08 | Mercer | West Virginia | 54055 | 4439 | 125 |
1199483 | 1199483 | 2021-04-07 | Mercer | West Virginia | 54055 | 4428 | 125 |
1196234 | 1196234 | 2021-04-06 | Mercer | West Virginia | 54055 | 4423 | 123 |
1192986 | 1192986 | 2021-04-05 | Mercer | West Virginia | 54055 | 4419 | 123 |
1189736 | 1189736 | 2021-04-04 | Mercer | West Virginia | 54055 | 4419 | 123 |
1186489 | 1186489 | 2021-04-03 | Mercer | West Virginia | 54055 | 4415 | 123 |
1183242 | 1183242 | 2021-04-02 | Mercer | West Virginia | 54055 | 4410 | 123 |
1179995 | 1179995 | 2021-04-01 | Mercer | West Virginia | 54055 | 4402 | 123 |
1176748 | 1176748 | 2021-03-31 | Mercer | West Virginia | 54055 | 4389 | 123 |
1173501 | 1173501 | 2021-03-30 | Mercer | West Virginia | 54055 | 4385 | 121 |
1170254 | 1170254 | 2021-03-29 | Mercer | West Virginia | 54055 | 4382 | 120 |
1167006 | 1167006 | 2021-03-28 | Mercer | West Virginia | 54055 | 4372 | 120 |
1163758 | 1163758 | 2021-03-27 | Mercer | West Virginia | 54055 | 4366 | 120 |
1160510 | 1160510 | 2021-03-26 | Mercer | West Virginia | 54055 | 4359 | 120 |
1157262 | 1157262 | 2021-03-25 | Mercer | West Virginia | 54055 | 4351 | 120 |
1154015 | 1154015 | 2021-03-24 | Mercer | West Virginia | 54055 | 4344 | 120 |
1150768 | 1150768 | 2021-03-23 | Mercer | West Virginia | 54055 | 4334 | 120 |
1147521 | 1147521 | 2021-03-22 | Mercer | West Virginia | 54055 | 4333 | 120 |
1144274 | 1144274 | 2021-03-21 | Mercer | West Virginia | 54055 | 4327 | 120 |
1141027 | 1141027 | 2021-03-20 | Mercer | West Virginia | 54055 | 4320 | 120 |
1137781 | 1137781 | 2021-03-19 | Mercer | West Virginia | 54055 | 4316 | 120 |
1134535 | 1134535 | 2021-03-18 | Mercer | West Virginia | 54055 | 4313 | 119 |
1131287 | 1131287 | 2021-03-17 | Mercer | West Virginia | 54055 | 4306 | 119 |
1128040 | 1128040 | 2021-03-16 | Mercer | West Virginia | 54055 | 4303 | 119 |
1124794 | 1124794 | 2021-03-15 | Mercer | West Virginia | 54055 | 4296 | 119 |
1121548 | 1121548 | 2021-03-14 | Mercer | West Virginia | 54055 | 4293 | 119 |
1118301 | 1118301 | 2021-03-13 | Mercer | West Virginia | 54055 | 4282 | 117 |
1115054 | 1115054 | 2021-03-12 | Mercer | West Virginia | 54055 | 4276 | 117 |
1111808 | 1111808 | 2021-03-11 | Mercer | West Virginia | 54055 | 4270 | 112 |
1108562 | 1108562 | 2021-03-10 | Mercer | West Virginia | 54055 | 4265 | 112 |
1105316 | 1105316 | 2021-03-09 | Mercer | West Virginia | 54055 | 4262 | 112 |
1102070 | 1102070 | 2021-03-08 | Mercer | West Virginia | 54055 | 4255 | 112 |
1098824 | 1098824 | 2021-03-07 | Mercer | West Virginia | 54055 | 4253 | 112 |
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);