ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54077 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 |
---|---|---|---|---|---|---|---|
1196245 | 1196245 | 2021-04-06 | Preston | West Virginia | 54077 | 2752 | 47 |
1192997 | 1192997 | 2021-04-05 | Preston | West Virginia | 54077 | 2745 | 47 |
1189747 | 1189747 | 2021-04-04 | Preston | West Virginia | 54077 | 2738 | 47 |
1186500 | 1186500 | 2021-04-03 | Preston | West Virginia | 54077 | 2734 | 47 |
1183253 | 1183253 | 2021-04-02 | Preston | West Virginia | 54077 | 2722 | 47 |
1180006 | 1180006 | 2021-04-01 | Preston | West Virginia | 54077 | 2724 | 47 |
1176759 | 1176759 | 2021-03-31 | Preston | West Virginia | 54077 | 2720 | 47 |
1173512 | 1173512 | 2021-03-30 | Preston | West Virginia | 54077 | 2714 | 46 |
1170265 | 1170265 | 2021-03-29 | Preston | West Virginia | 54077 | 2708 | 46 |
1167017 | 1167017 | 2021-03-28 | Preston | West Virginia | 54077 | 2701 | 46 |
1163769 | 1163769 | 2021-03-27 | Preston | West Virginia | 54077 | 2700 | 46 |
1160521 | 1160521 | 2021-03-26 | Preston | West Virginia | 54077 | 2688 | 46 |
1157273 | 1157273 | 2021-03-25 | Preston | West Virginia | 54077 | 2687 | 46 |
1154026 | 1154026 | 2021-03-24 | Preston | West Virginia | 54077 | 2675 | 46 |
1150779 | 1150779 | 2021-03-23 | Preston | West Virginia | 54077 | 2672 | 46 |
1147532 | 1147532 | 2021-03-22 | Preston | West Virginia | 54077 | 2665 | 46 |
1144285 | 1144285 | 2021-03-21 | Preston | West Virginia | 54077 | 2660 | 46 |
1141038 | 1141038 | 2021-03-20 | Preston | West Virginia | 54077 | 2656 | 46 |
1137792 | 1137792 | 2021-03-19 | Preston | West Virginia | 54077 | 2652 | 46 |
1134546 | 1134546 | 2021-03-18 | Preston | West Virginia | 54077 | 2645 | 46 |
1131298 | 1131298 | 2021-03-17 | Preston | West Virginia | 54077 | 2638 | 46 |
1128051 | 1128051 | 2021-03-16 | Preston | West Virginia | 54077 | 2635 | 46 |
1124805 | 1124805 | 2021-03-15 | Preston | West Virginia | 54077 | 2631 | 45 |
1121559 | 1121559 | 2021-03-14 | Preston | West Virginia | 54077 | 2626 | 45 |
1118312 | 1118312 | 2021-03-13 | Preston | West Virginia | 54077 | 2618 | 45 |
1115065 | 1115065 | 2021-03-12 | Preston | West Virginia | 54077 | 2612 | 45 |
1111819 | 1111819 | 2021-03-11 | Preston | West Virginia | 54077 | 2605 | 43 |
1108573 | 1108573 | 2021-03-10 | Preston | West Virginia | 54077 | 2591 | 43 |
1105327 | 1105327 | 2021-03-09 | Preston | West Virginia | 54077 | 2586 | 43 |
1102081 | 1102081 | 2021-03-08 | Preston | West Virginia | 54077 | 2581 | 43 |
1098835 | 1098835 | 2021-03-07 | Preston | West Virginia | 54077 | 2572 | 43 |
1095587 | 1095587 | 2021-03-06 | Preston | West Virginia | 54077 | 2568 | 43 |
1092341 | 1092341 | 2021-03-05 | Preston | West Virginia | 54077 | 2561 | 43 |
1089095 | 1089095 | 2021-03-04 | Preston | West Virginia | 54077 | 2553 | 43 |
1085850 | 1085850 | 2021-03-03 | Preston | West Virginia | 54077 | 2548 | 43 |
1082604 | 1082604 | 2021-03-02 | Preston | West Virginia | 54077 | 2544 | 43 |
1079358 | 1079358 | 2021-03-01 | Preston | West Virginia | 54077 | 2542 | 43 |
1076113 | 1076113 | 2021-02-28 | Preston | West Virginia | 54077 | 2536 | 43 |
1072867 | 1072867 | 2021-02-27 | Preston | West Virginia | 54077 | 2531 | 42 |
1069621 | 1069621 | 2021-02-26 | Preston | West Virginia | 54077 | 2528 | 42 |
1066376 | 1066376 | 2021-02-25 | Preston | West Virginia | 54077 | 2525 | 42 |
1063131 | 1063131 | 2021-02-24 | Preston | West Virginia | 54077 | 2518 | 42 |
1059886 | 1059886 | 2021-02-23 | Preston | West Virginia | 54077 | 2519 | 42 |
1056640 | 1056640 | 2021-02-22 | Preston | West Virginia | 54077 | 2512 | 41 |
1053394 | 1053394 | 2021-02-21 | Preston | West Virginia | 54077 | 2505 | 41 |
1050147 | 1050147 | 2021-02-20 | Preston | West Virginia | 54077 | 2505 | 41 |
1046900 | 1046900 | 2021-02-19 | Preston | West Virginia | 54077 | 2499 | 41 |
1043655 | 1043655 | 2021-02-18 | Preston | West Virginia | 54077 | 2496 | 41 |
1040410 | 1040410 | 2021-02-17 | Preston | West Virginia | 54077 | 2488 | 41 |
1037165 | 1037165 | 2021-02-16 | Preston | West Virginia | 54077 | 2485 | 41 |
1033920 | 1033920 | 2021-02-15 | Preston | West Virginia | 54077 | 2485 | 41 |
1030674 | 1030674 | 2021-02-14 | Preston | West Virginia | 54077 | 2481 | 41 |
1027427 | 1027427 | 2021-02-13 | Preston | West Virginia | 54077 | 2479 | 41 |
1024182 | 1024182 | 2021-02-12 | Preston | West Virginia | 54077 | 2477 | 40 |
1020937 | 1020937 | 2021-02-11 | Preston | West Virginia | 54077 | 2473 | 40 |
1017692 | 1017692 | 2021-02-10 | Preston | West Virginia | 54077 | 2468 | 40 |
1014447 | 1014447 | 2021-02-09 | Preston | West Virginia | 54077 | 2461 | 40 |
1011202 | 1011202 | 2021-02-08 | Preston | West Virginia | 54077 | 2468 | 40 |
1007956 | 1007956 | 2021-02-07 | Preston | West Virginia | 54077 | 2463 | 40 |
1004710 | 1004710 | 2021-02-06 | Preston | West Virginia | 54077 | 2459 | 40 |
1001464 | 1001464 | 2021-02-05 | Preston | West Virginia | 54077 | 2452 | 40 |
998218 | 998218 | 2021-02-04 | Preston | West Virginia | 54077 | 2443 | 40 |
994972 | 994972 | 2021-02-03 | Preston | West Virginia | 54077 | 2436 | 40 |
991726 | 991726 | 2021-02-02 | Preston | West Virginia | 54077 | 2433 | 38 |
988480 | 988480 | 2021-02-01 | Preston | West Virginia | 54077 | 2431 | 38 |
985233 | 985233 | 2021-01-31 | Preston | West Virginia | 54077 | 2425 | 38 |
981986 | 981986 | 2021-01-30 | Preston | West Virginia | 54077 | 2419 | 38 |
978740 | 978740 | 2021-01-29 | Preston | West Virginia | 54077 | 2408 | 38 |
975495 | 975495 | 2021-01-28 | Preston | West Virginia | 54077 | 2392 | 38 |
972250 | 972250 | 2021-01-27 | Preston | West Virginia | 54077 | 2382 | 37 |
969005 | 969005 | 2021-01-26 | Preston | West Virginia | 54077 | 2378 | 37 |
965761 | 965761 | 2021-01-25 | Preston | West Virginia | 54077 | 2365 | 37 |
962516 | 962516 | 2021-01-24 | Preston | West Virginia | 54077 | 2341 | 37 |
959271 | 959271 | 2021-01-23 | Preston | West Virginia | 54077 | 2336 | 37 |
956025 | 956025 | 2021-01-22 | Preston | West Virginia | 54077 | 2315 | 35 |
952780 | 952780 | 2021-01-21 | Preston | West Virginia | 54077 | 2305 | 35 |
949535 | 949535 | 2021-01-20 | Preston | West Virginia | 54077 | 2266 | 35 |
946289 | 946289 | 2021-01-19 | Preston | West Virginia | 54077 | 2258 | 34 |
943042 | 943042 | 2021-01-18 | Preston | West Virginia | 54077 | 2234 | 34 |
939797 | 939797 | 2021-01-17 | Preston | West Virginia | 54077 | 2213 | 34 |
936552 | 936552 | 2021-01-16 | Preston | West Virginia | 54077 | 2206 | 34 |
933307 | 933307 | 2021-01-15 | Preston | West Virginia | 54077 | 2167 | 34 |
930062 | 930062 | 2021-01-14 | Preston | West Virginia | 54077 | 2117 | 34 |
926817 | 926817 | 2021-01-13 | Preston | West Virginia | 54077 | 2083 | 34 |
923571 | 923571 | 2021-01-12 | Preston | West Virginia | 54077 | 2043 | 34 |
920326 | 920326 | 2021-01-11 | Preston | West Virginia | 54077 | 2024 | 34 |
917081 | 917081 | 2021-01-10 | Preston | West Virginia | 54077 | 1992 | 34 |
913836 | 913836 | 2021-01-09 | Preston | West Virginia | 54077 | 1970 | 34 |
910591 | 910591 | 2021-01-08 | Preston | West Virginia | 54077 | 1932 | 32 |
907346 | 907346 | 2021-01-07 | Preston | West Virginia | 54077 | 1882 | 31 |
904100 | 904100 | 2021-01-06 | Preston | West Virginia | 54077 | 1870 | 31 |
900855 | 900855 | 2021-01-05 | Preston | West Virginia | 54077 | 1839 | 31 |
897610 | 897610 | 2021-01-04 | Preston | West Virginia | 54077 | 1805 | 31 |
894364 | 894364 | 2021-01-03 | Preston | West Virginia | 54077 | 1773 | 31 |
891118 | 891118 | 2021-01-02 | Preston | West Virginia | 54077 | 1719 | 31 |
887871 | 887871 | 2021-01-01 | Preston | West Virginia | 54077 | 1691 | 31 |
884626 | 884626 | 2020-12-31 | Preston | West Virginia | 54077 | 1649 | 30 |
881381 | 881381 | 2020-12-30 | Preston | West Virginia | 54077 | 1635 | 30 |
878136 | 878136 | 2020-12-29 | Preston | West Virginia | 54077 | 1612 | 28 |
874891 | 874891 | 2020-12-28 | Preston | West Virginia | 54077 | 1586 | 27 |
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);