ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 54051 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 |
---|---|---|---|---|---|---|---|
1196231 | 1196231 | 2021-04-06 | Marshall | West Virginia | 54051 | 3201 | 73 |
1192983 | 1192983 | 2021-04-05 | Marshall | West Virginia | 54051 | 3197 | 73 |
1189733 | 1189733 | 2021-04-04 | Marshall | West Virginia | 54051 | 3191 | 73 |
1186486 | 1186486 | 2021-04-03 | Marshall | West Virginia | 54051 | 3189 | 73 |
1183239 | 1183239 | 2021-04-02 | Marshall | West Virginia | 54051 | 3183 | 73 |
1179992 | 1179992 | 2021-04-01 | Marshall | West Virginia | 54051 | 3176 | 73 |
1176745 | 1176745 | 2021-03-31 | Marshall | West Virginia | 54051 | 3175 | 73 |
1173498 | 1173498 | 2021-03-30 | Marshall | West Virginia | 54051 | 3171 | 72 |
1170251 | 1170251 | 2021-03-29 | Marshall | West Virginia | 54051 | 3168 | 72 |
1167003 | 1167003 | 2021-03-28 | Marshall | West Virginia | 54051 | 3167 | 72 |
1163755 | 1163755 | 2021-03-27 | Marshall | West Virginia | 54051 | 3163 | 72 |
1160507 | 1160507 | 2021-03-26 | Marshall | West Virginia | 54051 | 3156 | 72 |
1157259 | 1157259 | 2021-03-25 | Marshall | West Virginia | 54051 | 3154 | 72 |
1154012 | 1154012 | 2021-03-24 | Marshall | West Virginia | 54051 | 3153 | 72 |
1150765 | 1150765 | 2021-03-23 | Marshall | West Virginia | 54051 | 3147 | 72 |
1147518 | 1147518 | 2021-03-22 | Marshall | West Virginia | 54051 | 3143 | 72 |
1144271 | 1144271 | 2021-03-21 | Marshall | West Virginia | 54051 | 3138 | 72 |
1141024 | 1141024 | 2021-03-20 | Marshall | West Virginia | 54051 | 3134 | 72 |
1137778 | 1137778 | 2021-03-19 | Marshall | West Virginia | 54051 | 3128 | 72 |
1134532 | 1134532 | 2021-03-18 | Marshall | West Virginia | 54051 | 3124 | 71 |
1131284 | 1131284 | 2021-03-17 | Marshall | West Virginia | 54051 | 3116 | 71 |
1128037 | 1128037 | 2021-03-16 | Marshall | West Virginia | 54051 | 3110 | 71 |
1124791 | 1124791 | 2021-03-15 | Marshall | West Virginia | 54051 | 3106 | 71 |
1121545 | 1121545 | 2021-03-14 | Marshall | West Virginia | 54051 | 3099 | 71 |
1118298 | 1118298 | 2021-03-13 | Marshall | West Virginia | 54051 | 3092 | 71 |
1115051 | 1115051 | 2021-03-12 | Marshall | West Virginia | 54051 | 3089 | 72 |
1111805 | 1111805 | 2021-03-11 | Marshall | West Virginia | 54051 | 3078 | 66 |
1108559 | 1108559 | 2021-03-10 | Marshall | West Virginia | 54051 | 3073 | 66 |
1105313 | 1105313 | 2021-03-09 | Marshall | West Virginia | 54051 | 3069 | 66 |
1102067 | 1102067 | 2021-03-08 | Marshall | West Virginia | 54051 | 3066 | 66 |
1098821 | 1098821 | 2021-03-07 | Marshall | West Virginia | 54051 | 3059 | 66 |
1095573 | 1095573 | 2021-03-06 | Marshall | West Virginia | 54051 | 3035 | 66 |
1092327 | 1092327 | 2021-03-05 | Marshall | West Virginia | 54051 | 3029 | 66 |
1089081 | 1089081 | 2021-03-04 | Marshall | West Virginia | 54051 | 3025 | 66 |
1085836 | 1085836 | 2021-03-03 | Marshall | West Virginia | 54051 | 3016 | 66 |
1082590 | 1082590 | 2021-03-02 | Marshall | West Virginia | 54051 | 3016 | 66 |
1079344 | 1079344 | 2021-03-01 | Marshall | West Virginia | 54051 | 3013 | 66 |
1076099 | 1076099 | 2021-02-28 | Marshall | West Virginia | 54051 | 3008 | 66 |
1072853 | 1072853 | 2021-02-27 | Marshall | West Virginia | 54051 | 3003 | 66 |
1069607 | 1069607 | 2021-02-26 | Marshall | West Virginia | 54051 | 2997 | 66 |
1066362 | 1066362 | 2021-02-25 | Marshall | West Virginia | 54051 | 2995 | 66 |
1063117 | 1063117 | 2021-02-24 | Marshall | West Virginia | 54051 | 2989 | 66 |
1059872 | 1059872 | 2021-02-23 | Marshall | West Virginia | 54051 | 2987 | 66 |
1056626 | 1056626 | 2021-02-22 | Marshall | West Virginia | 54051 | 2982 | 66 |
1053380 | 1053380 | 2021-02-21 | Marshall | West Virginia | 54051 | 2975 | 66 |
1050133 | 1050133 | 2021-02-20 | Marshall | West Virginia | 54051 | 2970 | 66 |
1046886 | 1046886 | 2021-02-19 | Marshall | West Virginia | 54051 | 2967 | 66 |
1043641 | 1043641 | 2021-02-18 | Marshall | West Virginia | 54051 | 2968 | 66 |
1040396 | 1040396 | 2021-02-17 | Marshall | West Virginia | 54051 | 2966 | 66 |
1037151 | 1037151 | 2021-02-16 | Marshall | West Virginia | 54051 | 2961 | 66 |
1033906 | 1033906 | 2021-02-15 | Marshall | West Virginia | 54051 | 2956 | 66 |
1030660 | 1030660 | 2021-02-14 | Marshall | West Virginia | 54051 | 2950 | 66 |
1027413 | 1027413 | 2021-02-13 | Marshall | West Virginia | 54051 | 2944 | 65 |
1024168 | 1024168 | 2021-02-12 | Marshall | West Virginia | 54051 | 2937 | 65 |
1020923 | 1020923 | 2021-02-11 | Marshall | West Virginia | 54051 | 2941 | 65 |
1017678 | 1017678 | 2021-02-10 | Marshall | West Virginia | 54051 | 2931 | 65 |
1014433 | 1014433 | 2021-02-09 | Marshall | West Virginia | 54051 | 2925 | 65 |
1011188 | 1011188 | 2021-02-08 | Marshall | West Virginia | 54051 | 2914 | 65 |
1007942 | 1007942 | 2021-02-07 | Marshall | West Virginia | 54051 | 2901 | 65 |
1004696 | 1004696 | 2021-02-06 | Marshall | West Virginia | 54051 | 2890 | 64 |
1001450 | 1001450 | 2021-02-05 | Marshall | West Virginia | 54051 | 2874 | 63 |
998204 | 998204 | 2021-02-04 | Marshall | West Virginia | 54051 | 2864 | 63 |
994958 | 994958 | 2021-02-03 | Marshall | West Virginia | 54051 | 2855 | 63 |
991712 | 991712 | 2021-02-02 | Marshall | West Virginia | 54051 | 2838 | 63 |
988466 | 988466 | 2021-02-01 | Marshall | West Virginia | 54051 | 2823 | 63 |
985219 | 985219 | 2021-01-31 | Marshall | West Virginia | 54051 | 2816 | 63 |
981972 | 981972 | 2021-01-30 | Marshall | West Virginia | 54051 | 2796 | 63 |
978726 | 978726 | 2021-01-29 | Marshall | West Virginia | 54051 | 2771 | 63 |
975481 | 975481 | 2021-01-28 | Marshall | West Virginia | 54051 | 2740 | 63 |
972236 | 972236 | 2021-01-27 | Marshall | West Virginia | 54051 | 2724 | 61 |
968991 | 968991 | 2021-01-26 | Marshall | West Virginia | 54051 | 2694 | 61 |
965747 | 965747 | 2021-01-25 | Marshall | West Virginia | 54051 | 2675 | 61 |
962502 | 962502 | 2021-01-24 | Marshall | West Virginia | 54051 | 2652 | 61 |
959257 | 959257 | 2021-01-23 | Marshall | West Virginia | 54051 | 2640 | 60 |
956011 | 956011 | 2021-01-22 | Marshall | West Virginia | 54051 | 2624 | 60 |
952766 | 952766 | 2021-01-21 | Marshall | West Virginia | 54051 | 2612 | 60 |
949521 | 949521 | 2021-01-20 | Marshall | West Virginia | 54051 | 2593 | 60 |
946275 | 946275 | 2021-01-19 | Marshall | West Virginia | 54051 | 2586 | 60 |
943028 | 943028 | 2021-01-18 | Marshall | West Virginia | 54051 | 2554 | 59 |
939783 | 939783 | 2021-01-17 | Marshall | West Virginia | 54051 | 2538 | 59 |
936538 | 936538 | 2021-01-16 | Marshall | West Virginia | 54051 | 2534 | 57 |
933293 | 933293 | 2021-01-15 | Marshall | West Virginia | 54051 | 2492 | 57 |
930048 | 930048 | 2021-01-14 | Marshall | West Virginia | 54051 | 2465 | 57 |
926803 | 926803 | 2021-01-13 | Marshall | West Virginia | 54051 | 2454 | 57 |
923557 | 923557 | 2021-01-12 | Marshall | West Virginia | 54051 | 2433 | 57 |
920312 | 920312 | 2021-01-11 | Marshall | West Virginia | 54051 | 2421 | 57 |
917067 | 917067 | 2021-01-10 | Marshall | West Virginia | 54051 | 2391 | 57 |
913822 | 913822 | 2021-01-09 | Marshall | West Virginia | 54051 | 2347 | 57 |
910577 | 910577 | 2021-01-08 | Marshall | West Virginia | 54051 | 2318 | 56 |
907332 | 907332 | 2021-01-07 | Marshall | West Virginia | 54051 | 2290 | 55 |
904086 | 904086 | 2021-01-06 | Marshall | West Virginia | 54051 | 2273 | 54 |
900841 | 900841 | 2021-01-05 | Marshall | West Virginia | 54051 | 2245 | 54 |
897596 | 897596 | 2021-01-04 | Marshall | West Virginia | 54051 | 2219 | 53 |
894350 | 894350 | 2021-01-03 | Marshall | West Virginia | 54051 | 2201 | 53 |
891104 | 891104 | 2021-01-02 | Marshall | West Virginia | 54051 | 2166 | 53 |
887857 | 887857 | 2021-01-01 | Marshall | West Virginia | 54051 | 2139 | 53 |
884612 | 884612 | 2020-12-31 | Marshall | West Virginia | 54051 | 2100 | 53 |
881367 | 881367 | 2020-12-30 | Marshall | West Virginia | 54051 | 2027 | 53 |
878122 | 878122 | 2020-12-29 | Marshall | West Virginia | 54051 | 1960 | 53 |
874877 | 874877 | 2020-12-28 | Marshall | West Virginia | 54051 | 1891 | 51 |
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);