ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 54025 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 |
---|---|---|---|---|---|---|---|
1196219 | 1196219 | 2021-04-06 | Greenbrier | West Virginia | 54025 | 2544 | 63 |
1192971 | 1192971 | 2021-04-05 | Greenbrier | West Virginia | 54025 | 2543 | 63 |
1189721 | 1189721 | 2021-04-04 | Greenbrier | West Virginia | 54025 | 2536 | 63 |
1186474 | 1186474 | 2021-04-03 | Greenbrier | West Virginia | 54025 | 2526 | 63 |
1183227 | 1183227 | 2021-04-02 | Greenbrier | West Virginia | 54025 | 2516 | 63 |
1179980 | 1179980 | 2021-04-01 | Greenbrier | West Virginia | 54025 | 2509 | 63 |
1176733 | 1176733 | 2021-03-31 | Greenbrier | West Virginia | 54025 | 2500 | 62 |
1173486 | 1173486 | 2021-03-30 | Greenbrier | West Virginia | 54025 | 2498 | 60 |
1170239 | 1170239 | 2021-03-29 | Greenbrier | West Virginia | 54025 | 2487 | 60 |
1166991 | 1166991 | 2021-03-28 | Greenbrier | West Virginia | 54025 | 2485 | 60 |
1163743 | 1163743 | 2021-03-27 | Greenbrier | West Virginia | 54025 | 2484 | 60 |
1160495 | 1160495 | 2021-03-26 | Greenbrier | West Virginia | 54025 | 2478 | 60 |
1157247 | 1157247 | 2021-03-25 | Greenbrier | West Virginia | 54025 | 2474 | 60 |
1154000 | 1154000 | 2021-03-24 | Greenbrier | West Virginia | 54025 | 2468 | 60 |
1150753 | 1150753 | 2021-03-23 | Greenbrier | West Virginia | 54025 | 2464 | 60 |
1147506 | 1147506 | 2021-03-22 | Greenbrier | West Virginia | 54025 | 2462 | 60 |
1144259 | 1144259 | 2021-03-21 | Greenbrier | West Virginia | 54025 | 2459 | 60 |
1141012 | 1141012 | 2021-03-20 | Greenbrier | West Virginia | 54025 | 2458 | 60 |
1137766 | 1137766 | 2021-03-19 | Greenbrier | West Virginia | 54025 | 2457 | 60 |
1134520 | 1134520 | 2021-03-18 | Greenbrier | West Virginia | 54025 | 2452 | 60 |
1131272 | 1131272 | 2021-03-17 | Greenbrier | West Virginia | 54025 | 2451 | 60 |
1128025 | 1128025 | 2021-03-16 | Greenbrier | West Virginia | 54025 | 2449 | 60 |
1124779 | 1124779 | 2021-03-15 | Greenbrier | West Virginia | 54025 | 2448 | 60 |
1121533 | 1121533 | 2021-03-14 | Greenbrier | West Virginia | 54025 | 2448 | 60 |
1118286 | 1118286 | 2021-03-13 | Greenbrier | West Virginia | 54025 | 2446 | 60 |
1115039 | 1115039 | 2021-03-12 | Greenbrier | West Virginia | 54025 | 2445 | 60 |
1111793 | 1111793 | 2021-03-11 | Greenbrier | West Virginia | 54025 | 2440 | 52 |
1108547 | 1108547 | 2021-03-10 | Greenbrier | West Virginia | 54025 | 2441 | 53 |
1105301 | 1105301 | 2021-03-09 | Greenbrier | West Virginia | 54025 | 2438 | 53 |
1102055 | 1102055 | 2021-03-08 | Greenbrier | West Virginia | 54025 | 2435 | 53 |
1098809 | 1098809 | 2021-03-07 | Greenbrier | West Virginia | 54025 | 2431 | 53 |
1095561 | 1095561 | 2021-03-06 | Greenbrier | West Virginia | 54025 | 2423 | 52 |
1092315 | 1092315 | 2021-03-05 | Greenbrier | West Virginia | 54025 | 2422 | 52 |
1089069 | 1089069 | 2021-03-04 | Greenbrier | West Virginia | 54025 | 2416 | 52 |
1085824 | 1085824 | 2021-03-03 | Greenbrier | West Virginia | 54025 | 2413 | 52 |
1082578 | 1082578 | 2021-03-02 | Greenbrier | West Virginia | 54025 | 2434 | 52 |
1079332 | 1079332 | 2021-03-01 | Greenbrier | West Virginia | 54025 | 2430 | 52 |
1076087 | 1076087 | 2021-02-28 | Greenbrier | West Virginia | 54025 | 2429 | 52 |
1072841 | 1072841 | 2021-02-27 | Greenbrier | West Virginia | 54025 | 2422 | 52 |
1069595 | 1069595 | 2021-02-26 | Greenbrier | West Virginia | 54025 | 2419 | 52 |
1066350 | 1066350 | 2021-02-25 | Greenbrier | West Virginia | 54025 | 2391 | 52 |
1063105 | 1063105 | 2021-02-24 | Greenbrier | West Virginia | 54025 | 2381 | 52 |
1059860 | 1059860 | 2021-02-23 | Greenbrier | West Virginia | 54025 | 2380 | 52 |
1056614 | 1056614 | 2021-02-22 | Greenbrier | West Virginia | 54025 | 2375 | 52 |
1053368 | 1053368 | 2021-02-21 | Greenbrier | West Virginia | 54025 | 2374 | 52 |
1050121 | 1050121 | 2021-02-20 | Greenbrier | West Virginia | 54025 | 2371 | 52 |
1046874 | 1046874 | 2021-02-19 | Greenbrier | West Virginia | 54025 | 2371 | 52 |
1043629 | 1043629 | 2021-02-18 | Greenbrier | West Virginia | 54025 | 2369 | 52 |
1040384 | 1040384 | 2021-02-17 | Greenbrier | West Virginia | 54025 | 2368 | 52 |
1037139 | 1037139 | 2021-02-16 | Greenbrier | West Virginia | 54025 | 2364 | 51 |
1033894 | 1033894 | 2021-02-15 | Greenbrier | West Virginia | 54025 | 2362 | 51 |
1030648 | 1030648 | 2021-02-14 | Greenbrier | West Virginia | 54025 | 2356 | 51 |
1027401 | 1027401 | 2021-02-13 | Greenbrier | West Virginia | 54025 | 2354 | 51 |
1024156 | 1024156 | 2021-02-12 | Greenbrier | West Virginia | 54025 | 2349 | 51 |
1020911 | 1020911 | 2021-02-11 | Greenbrier | West Virginia | 54025 | 2341 | 50 |
1017666 | 1017666 | 2021-02-10 | Greenbrier | West Virginia | 54025 | 2329 | 50 |
1014421 | 1014421 | 2021-02-09 | Greenbrier | West Virginia | 54025 | 2328 | 50 |
1011176 | 1011176 | 2021-02-08 | Greenbrier | West Virginia | 54025 | 2326 | 50 |
1007930 | 1007930 | 2021-02-07 | Greenbrier | West Virginia | 54025 | 2317 | 50 |
1004684 | 1004684 | 2021-02-06 | Greenbrier | West Virginia | 54025 | 2309 | 50 |
1001438 | 1001438 | 2021-02-05 | Greenbrier | West Virginia | 54025 | 2301 | 49 |
998192 | 998192 | 2021-02-04 | Greenbrier | West Virginia | 54025 | 2295 | 49 |
994946 | 994946 | 2021-02-03 | Greenbrier | West Virginia | 54025 | 2286 | 49 |
991700 | 991700 | 2021-02-02 | Greenbrier | West Virginia | 54025 | 2268 | 49 |
988454 | 988454 | 2021-02-01 | Greenbrier | West Virginia | 54025 | 2264 | 49 |
985207 | 985207 | 2021-01-31 | Greenbrier | West Virginia | 54025 | 2253 | 49 |
981960 | 981960 | 2021-01-30 | Greenbrier | West Virginia | 54025 | 2236 | 49 |
978714 | 978714 | 2021-01-29 | Greenbrier | West Virginia | 54025 | 2221 | 49 |
975469 | 975469 | 2021-01-28 | Greenbrier | West Virginia | 54025 | 2205 | 49 |
972224 | 972224 | 2021-01-27 | Greenbrier | West Virginia | 54025 | 2187 | 49 |
968979 | 968979 | 2021-01-26 | Greenbrier | West Virginia | 54025 | 2178 | 49 |
965735 | 965735 | 2021-01-25 | Greenbrier | West Virginia | 54025 | 2155 | 47 |
962490 | 962490 | 2021-01-24 | Greenbrier | West Virginia | 54025 | 2143 | 47 |
959245 | 959245 | 2021-01-23 | Greenbrier | West Virginia | 54025 | 2137 | 47 |
955999 | 955999 | 2021-01-22 | Greenbrier | West Virginia | 54025 | 2126 | 47 |
952754 | 952754 | 2021-01-21 | Greenbrier | West Virginia | 54025 | 2100 | 47 |
949509 | 949509 | 2021-01-20 | Greenbrier | West Virginia | 54025 | 2083 | 47 |
946263 | 946263 | 2021-01-19 | Greenbrier | West Virginia | 54025 | 2067 | 47 |
943016 | 943016 | 2021-01-18 | Greenbrier | West Virginia | 54025 | 2056 | 45 |
939771 | 939771 | 2021-01-17 | Greenbrier | West Virginia | 54025 | 2037 | 45 |
936526 | 936526 | 2021-01-16 | Greenbrier | West Virginia | 54025 | 2024 | 45 |
933281 | 933281 | 2021-01-15 | Greenbrier | West Virginia | 54025 | 1978 | 45 |
930036 | 930036 | 2021-01-14 | Greenbrier | West Virginia | 54025 | 1961 | 43 |
926791 | 926791 | 2021-01-13 | Greenbrier | West Virginia | 54025 | 1936 | 43 |
923545 | 923545 | 2021-01-12 | Greenbrier | West Virginia | 54025 | 1914 | 43 |
920300 | 920300 | 2021-01-11 | Greenbrier | West Virginia | 54025 | 1877 | 43 |
917055 | 917055 | 2021-01-10 | Greenbrier | West Virginia | 54025 | 1823 | 43 |
913810 | 913810 | 2021-01-09 | Greenbrier | West Virginia | 54025 | 1790 | 43 |
910565 | 910565 | 2021-01-08 | Greenbrier | West Virginia | 54025 | 1761 | 43 |
907320 | 907320 | 2021-01-07 | Greenbrier | West Virginia | 54025 | 1711 | 41 |
904074 | 904074 | 2021-01-06 | Greenbrier | West Virginia | 54025 | 1677 | 40 |
900829 | 900829 | 2021-01-05 | Greenbrier | West Virginia | 54025 | 1641 | 40 |
897584 | 897584 | 2021-01-04 | Greenbrier | West Virginia | 54025 | 1619 | 36 |
894338 | 894338 | 2021-01-03 | Greenbrier | West Virginia | 54025 | 1612 | 35 |
891092 | 891092 | 2021-01-02 | Greenbrier | West Virginia | 54025 | 1564 | 35 |
887845 | 887845 | 2021-01-01 | Greenbrier | West Virginia | 54025 | 1521 | 35 |
884600 | 884600 | 2020-12-31 | Greenbrier | West Virginia | 54025 | 1469 | 35 |
881355 | 881355 | 2020-12-30 | Greenbrier | West Virginia | 54025 | 1436 | 32 |
878110 | 878110 | 2020-12-29 | Greenbrier | West Virginia | 54025 | 1391 | 31 |
874865 | 874865 | 2020-12-28 | Greenbrier | West Virginia | 54025 | 1368 | 28 |
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);