ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Mercer" 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 |
---|---|---|---|---|---|---|---|
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 |
871635 | 871635 | 2020-12-27 | Mercer | West Virginia | 54055 | 2574 | 51 |
868390 | 868390 | 2020-12-26 | Mercer | West Virginia | 54055 | 2561 | 51 |
865145 | 865145 | 2020-12-25 | Mercer | West Virginia | 54055 | 2486 | 51 |
861900 | 861900 | 2020-12-24 | Mercer | West Virginia | 54055 | 2410 | 51 |
858655 | 858655 | 2020-12-23 | Mercer | West Virginia | 54055 | 2353 | 51 |
855410 | 855410 | 2020-12-22 | Mercer | West Virginia | 54055 | 2303 | 51 |
852165 | 852165 | 2020-12-21 | Mercer | West Virginia | 54055 | 2243 | 49 |
848920 | 848920 | 2020-12-20 | Mercer | West Virginia | 54055 | 2177 | 49 |
845675 | 845675 | 2020-12-19 | Mercer | West Virginia | 54055 | 2114 | 49 |
842429 | 842429 | 2020-12-18 | Mercer | West Virginia | 54055 | 2060 | 49 |
839184 | 839184 | 2020-12-17 | Mercer | West Virginia | 54055 | 2006 | 49 |
835939 | 835939 | 2020-12-16 | Mercer | West Virginia | 54055 | 1935 | 47 |
832693 | 832693 | 2020-12-15 | Mercer | West Virginia | 54055 | 1905 | 46 |
829446 | 829446 | 2020-12-14 | Mercer | West Virginia | 54055 | 1834 | 45 |
826200 | 826200 | 2020-12-13 | Mercer | West Virginia | 54055 | 1781 | 45 |
822953 | 822953 | 2020-12-12 | Mercer | West Virginia | 54055 | 1732 | 45 |
819707 | 819707 | 2020-12-11 | Mercer | West Virginia | 54055 | 1670 | 45 |
816461 | 816461 | 2020-12-10 | Mercer | West Virginia | 54055 | 1652 | 45 |
813215 | 813215 | 2020-12-09 | Mercer | West Virginia | 54055 | 1617 | 45 |
809971 | 809971 | 2020-12-08 | Mercer | West Virginia | 54055 | 1581 | 41 |
806726 | 806726 | 2020-12-07 | Mercer | West Virginia | 54055 | 1542 | 41 |
803481 | 803481 | 2020-12-06 | Mercer | West Virginia | 54055 | 1495 | 41 |
800236 | 800236 | 2020-12-05 | Mercer | West Virginia | 54055 | 1465 | 41 |
796991 | 796991 | 2020-12-04 | Mercer | West Virginia | 54055 | 1423 | 39 |
793746 | 793746 | 2020-12-03 | Mercer | West Virginia | 54055 | 1401 | 39 |
790501 | 790501 | 2020-12-02 | Mercer | West Virginia | 54055 | 1383 | 39 |
787256 | 787256 | 2020-12-01 | Mercer | West Virginia | 54055 | 1374 | 39 |
784012 | 784012 | 2020-11-30 | Mercer | West Virginia | 54055 | 1360 | 37 |
780767 | 780767 | 2020-11-29 | Mercer | West Virginia | 54055 | 1330 | 37 |
777521 | 777521 | 2020-11-28 | Mercer | West Virginia | 54055 | 1317 | 37 |
774276 | 774276 | 2020-11-27 | Mercer | West Virginia | 54055 | 1307 | 37 |
771031 | 771031 | 2020-11-26 | Mercer | West Virginia | 54055 | 1286 | 37 |
767785 | 767785 | 2020-11-25 | Mercer | West Virginia | 54055 | 1264 | 37 |
764540 | 764540 | 2020-11-24 | Mercer | West Virginia | 54055 | 1252 | 37 |
761295 | 761295 | 2020-11-23 | Mercer | West Virginia | 54055 | 1227 | 37 |
758050 | 758050 | 2020-11-22 | Mercer | West Virginia | 54055 | 1203 | 37 |
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);