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 |
---|---|---|---|---|---|---|---|
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 |
1095576 | 1095576 | 2021-03-06 | Mercer | West Virginia | 54055 | 4244 | 112 |
1092330 | 1092330 | 2021-03-05 | Mercer | West Virginia | 54055 | 4241 | 112 |
1089084 | 1089084 | 2021-03-04 | Mercer | West Virginia | 54055 | 4232 | 112 |
1085839 | 1085839 | 2021-03-03 | Mercer | West Virginia | 54055 | 4229 | 112 |
1082593 | 1082593 | 2021-03-02 | Mercer | West Virginia | 54055 | 4228 | 112 |
1079347 | 1079347 | 2021-03-01 | Mercer | West Virginia | 54055 | 4223 | 112 |
1076102 | 1076102 | 2021-02-28 | Mercer | West Virginia | 54055 | 4220 | 112 |
1072856 | 1072856 | 2021-02-27 | Mercer | West Virginia | 54055 | 4211 | 112 |
1069610 | 1069610 | 2021-02-26 | Mercer | West Virginia | 54055 | 4205 | 112 |
1066365 | 1066365 | 2021-02-25 | Mercer | West Virginia | 54055 | 4192 | 112 |
1063120 | 1063120 | 2021-02-24 | Mercer | West Virginia | 54055 | 4184 | 112 |
1059875 | 1059875 | 2021-02-23 | Mercer | West Virginia | 54055 | 4175 | 108 |
1056629 | 1056629 | 2021-02-22 | Mercer | West Virginia | 54055 | 4161 | 104 |
1053383 | 1053383 | 2021-02-21 | Mercer | West Virginia | 54055 | 4154 | 104 |
1050136 | 1050136 | 2021-02-20 | Mercer | West Virginia | 54055 | 4150 | 104 |
1046889 | 1046889 | 2021-02-19 | Mercer | West Virginia | 54055 | 4138 | 103 |
1043644 | 1043644 | 2021-02-18 | Mercer | West Virginia | 54055 | 4126 | 100 |
1040399 | 1040399 | 2021-02-17 | Mercer | West Virginia | 54055 | 4123 | 100 |
1037154 | 1037154 | 2021-02-16 | Mercer | West Virginia | 54055 | 4109 | 99 |
1033909 | 1033909 | 2021-02-15 | Mercer | West Virginia | 54055 | 4099 | 99 |
1030663 | 1030663 | 2021-02-14 | Mercer | West Virginia | 54055 | 4090 | 99 |
1027416 | 1027416 | 2021-02-13 | Mercer | West Virginia | 54055 | 4083 | 99 |
1024171 | 1024171 | 2021-02-12 | Mercer | West Virginia | 54055 | 4068 | 99 |
1020926 | 1020926 | 2021-02-11 | Mercer | West Virginia | 54055 | 4052 | 98 |
1017681 | 1017681 | 2021-02-10 | Mercer | West Virginia | 54055 | 4038 | 98 |
1014436 | 1014436 | 2021-02-09 | Mercer | West Virginia | 54055 | 4029 | 97 |
1011191 | 1011191 | 2021-02-08 | Mercer | West Virginia | 54055 | 4015 | 93 |
1007945 | 1007945 | 2021-02-07 | Mercer | West Virginia | 54055 | 4001 | 93 |
1004699 | 1004699 | 2021-02-06 | Mercer | West Virginia | 54055 | 3987 | 93 |
1001453 | 1001453 | 2021-02-05 | Mercer | West Virginia | 54055 | 3977 | 92 |
998207 | 998207 | 2021-02-04 | Mercer | West Virginia | 54055 | 3960 | 91 |
994961 | 994961 | 2021-02-03 | Mercer | West Virginia | 54055 | 3946 | 91 |
991715 | 991715 | 2021-02-02 | Mercer | West Virginia | 54055 | 3937 | 91 |
988469 | 988469 | 2021-02-01 | Mercer | West Virginia | 54055 | 3924 | 91 |
985222 | 985222 | 2021-01-31 | Mercer | West Virginia | 54055 | 3914 | 91 |
981975 | 981975 | 2021-01-30 | Mercer | West Virginia | 54055 | 3896 | 91 |
978729 | 978729 | 2021-01-29 | Mercer | West Virginia | 54055 | 3887 | 90 |
975484 | 975484 | 2021-01-28 | Mercer | West Virginia | 54055 | 3864 | 88 |
972239 | 972239 | 2021-01-27 | Mercer | West Virginia | 54055 | 3847 | 85 |
968994 | 968994 | 2021-01-26 | Mercer | West Virginia | 54055 | 3831 | 84 |
965750 | 965750 | 2021-01-25 | Mercer | West Virginia | 54055 | 3819 | 79 |
962505 | 962505 | 2021-01-24 | Mercer | West Virginia | 54055 | 3808 | 79 |
959260 | 959260 | 2021-01-23 | Mercer | West Virginia | 54055 | 3795 | 79 |
956014 | 956014 | 2021-01-22 | Mercer | West Virginia | 54055 | 3770 | 79 |
952769 | 952769 | 2021-01-21 | Mercer | West Virginia | 54055 | 3754 | 78 |
949524 | 949524 | 2021-01-20 | Mercer | West Virginia | 54055 | 3737 | 77 |
946278 | 946278 | 2021-01-19 | Mercer | West Virginia | 54055 | 3722 | 72 |
943031 | 943031 | 2021-01-18 | Mercer | West Virginia | 54055 | 3690 | 72 |
939786 | 939786 | 2021-01-17 | Mercer | West Virginia | 54055 | 3675 | 72 |
936541 | 936541 | 2021-01-16 | Mercer | West Virginia | 54055 | 3663 | 72 |
933296 | 933296 | 2021-01-15 | Mercer | West Virginia | 54055 | 3616 | 71 |
930051 | 930051 | 2021-01-14 | Mercer | West Virginia | 54055 | 3595 | 69 |
926806 | 926806 | 2021-01-13 | Mercer | West Virginia | 54055 | 3559 | 67 |
923560 | 923560 | 2021-01-12 | Mercer | West Virginia | 54055 | 3534 | 67 |
920315 | 920315 | 2021-01-11 | Mercer | West Virginia | 54055 | 3508 | 64 |
917070 | 917070 | 2021-01-10 | Mercer | West Virginia | 54055 | 3474 | 64 |
913825 | 913825 | 2021-01-09 | Mercer | West Virginia | 54055 | 3418 | 64 |
910580 | 910580 | 2021-01-08 | Mercer | West Virginia | 54055 | 3316 | 64 |
907335 | 907335 | 2021-01-07 | Mercer | West Virginia | 54055 | 3254 | 62 |
904089 | 904089 | 2021-01-06 | Mercer | West Virginia | 54055 | 3209 | 61 |
900844 | 900844 | 2021-01-05 | Mercer | West Virginia | 54055 | 3170 | 58 |
897599 | 897599 | 2021-01-04 | Mercer | West Virginia | 54055 | 3111 | 54 |
894353 | 894353 | 2021-01-03 | Mercer | West Virginia | 54055 | 3081 | 54 |
891107 | 891107 | 2021-01-02 | Mercer | West Virginia | 54055 | 3003 | 54 |
887860 | 887860 | 2021-01-01 | Mercer | West Virginia | 54055 | 2885 | 54 |
884615 | 884615 | 2020-12-31 | Mercer | West Virginia | 54055 | 2783 | 54 |
881370 | 881370 | 2020-12-30 | Mercer | West Virginia | 54055 | 2713 | 52 |
878125 | 878125 | 2020-12-29 | Mercer | West Virginia | 54055 | 2669 | 51 |
874880 | 874880 | 2020-12-28 | Mercer | West Virginia | 54055 | 2622 | 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);