ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where county = "Clay" 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 |
---|---|---|---|---|---|---|---|
1053363 | 1053363 | 2021-02-21 | Clay | West Virginia | 54015 | 370 | 4 |
1050116 | 1050116 | 2021-02-20 | Clay | West Virginia | 54015 | 370 | 4 |
1046869 | 1046869 | 2021-02-19 | Clay | West Virginia | 54015 | 370 | 4 |
1043624 | 1043624 | 2021-02-18 | Clay | West Virginia | 54015 | 370 | 4 |
1040379 | 1040379 | 2021-02-17 | Clay | West Virginia | 54015 | 370 | 4 |
1037134 | 1037134 | 2021-02-16 | Clay | West Virginia | 54015 | 370 | 4 |
1033889 | 1033889 | 2021-02-15 | Clay | West Virginia | 54015 | 369 | 4 |
1030643 | 1030643 | 2021-02-14 | Clay | West Virginia | 54015 | 366 | 4 |
1027396 | 1027396 | 2021-02-13 | Clay | West Virginia | 54015 | 365 | 4 |
1024151 | 1024151 | 2021-02-12 | Clay | West Virginia | 54015 | 364 | 4 |
1020906 | 1020906 | 2021-02-11 | Clay | West Virginia | 54015 | 362 | 4 |
1017661 | 1017661 | 2021-02-10 | Clay | West Virginia | 54015 | 363 | 4 |
1014416 | 1014416 | 2021-02-09 | Clay | West Virginia | 54015 | 361 | 4 |
1011171 | 1011171 | 2021-02-08 | Clay | West Virginia | 54015 | 361 | 4 |
1007925 | 1007925 | 2021-02-07 | Clay | West Virginia | 54015 | 361 | 4 |
1004679 | 1004679 | 2021-02-06 | Clay | West Virginia | 54015 | 362 | 4 |
1001433 | 1001433 | 2021-02-05 | Clay | West Virginia | 54015 | 360 | 4 |
998187 | 998187 | 2021-02-04 | Clay | West Virginia | 54015 | 359 | 4 |
994941 | 994941 | 2021-02-03 | Clay | West Virginia | 54015 | 357 | 4 |
991695 | 991695 | 2021-02-02 | Clay | West Virginia | 54015 | 358 | 4 |
988449 | 988449 | 2021-02-01 | Clay | West Virginia | 54015 | 355 | 4 |
985202 | 985202 | 2021-01-31 | Clay | West Virginia | 54015 | 352 | 4 |
981955 | 981955 | 2021-01-30 | Clay | West Virginia | 54015 | 352 | 4 |
978709 | 978709 | 2021-01-29 | Clay | West Virginia | 54015 | 349 | 4 |
975464 | 975464 | 2021-01-28 | Clay | West Virginia | 54015 | 342 | 4 |
972219 | 972219 | 2021-01-27 | Clay | West Virginia | 54015 | 339 | 4 |
968974 | 968974 | 2021-01-26 | Clay | West Virginia | 54015 | 334 | 4 |
965730 | 965730 | 2021-01-25 | Clay | West Virginia | 54015 | 324 | 4 |
962485 | 962485 | 2021-01-24 | Clay | West Virginia | 54015 | 324 | 4 |
959240 | 959240 | 2021-01-23 | Clay | West Virginia | 54015 | 324 | 4 |
955994 | 955994 | 2021-01-22 | Clay | West Virginia | 54015 | 322 | 4 |
952749 | 952749 | 2021-01-21 | Clay | West Virginia | 54015 | 310 | 4 |
949504 | 949504 | 2021-01-20 | Clay | West Virginia | 54015 | 306 | 4 |
946258 | 946258 | 2021-01-19 | Clay | West Virginia | 54015 | 303 | 4 |
943011 | 943011 | 2021-01-18 | Clay | West Virginia | 54015 | 301 | 4 |
939766 | 939766 | 2021-01-17 | Clay | West Virginia | 54015 | 299 | 4 |
936521 | 936521 | 2021-01-16 | Clay | West Virginia | 54015 | 300 | 4 |
933276 | 933276 | 2021-01-15 | Clay | West Virginia | 54015 | 295 | 4 |
930031 | 930031 | 2021-01-14 | Clay | West Virginia | 54015 | 291 | 4 |
926786 | 926786 | 2021-01-13 | Clay | West Virginia | 54015 | 289 | 4 |
923540 | 923540 | 2021-01-12 | Clay | West Virginia | 54015 | 288 | 4 |
920295 | 920295 | 2021-01-11 | Clay | West Virginia | 54015 | 286 | 4 |
917050 | 917050 | 2021-01-10 | Clay | West Virginia | 54015 | 285 | 4 |
913805 | 913805 | 2021-01-09 | Clay | West Virginia | 54015 | 283 | 4 |
910560 | 910560 | 2021-01-08 | Clay | West Virginia | 54015 | 278 | 4 |
907315 | 907315 | 2021-01-07 | Clay | West Virginia | 54015 | 271 | 4 |
904069 | 904069 | 2021-01-06 | Clay | West Virginia | 54015 | 269 | 4 |
900824 | 900824 | 2021-01-05 | Clay | West Virginia | 54015 | 269 | 4 |
897579 | 897579 | 2021-01-04 | Clay | West Virginia | 54015 | 271 | 4 |
894333 | 894333 | 2021-01-03 | Clay | West Virginia | 54015 | 268 | 4 |
891087 | 891087 | 2021-01-02 | Clay | West Virginia | 54015 | 263 | 4 |
887840 | 887840 | 2021-01-01 | Clay | West Virginia | 54015 | 263 | 4 |
884595 | 884595 | 2020-12-31 | Clay | West Virginia | 54015 | 258 | 4 |
881350 | 881350 | 2020-12-30 | Clay | West Virginia | 54015 | 258 | 4 |
878105 | 878105 | 2020-12-29 | Clay | West Virginia | 54015 | 252 | 4 |
874860 | 874860 | 2020-12-28 | Clay | West Virginia | 54015 | 252 | 4 |
871615 | 871615 | 2020-12-27 | Clay | West Virginia | 54015 | 245 | 4 |
868370 | 868370 | 2020-12-26 | Clay | West Virginia | 54015 | 246 | 4 |
865125 | 865125 | 2020-12-25 | Clay | West Virginia | 54015 | 243 | 4 |
861880 | 861880 | 2020-12-24 | Clay | West Virginia | 54015 | 241 | 4 |
858635 | 858635 | 2020-12-23 | Clay | West Virginia | 54015 | 239 | 4 |
855390 | 855390 | 2020-12-22 | Clay | West Virginia | 54015 | 236 | 3 |
852145 | 852145 | 2020-12-21 | Clay | West Virginia | 54015 | 231 | 3 |
848900 | 848900 | 2020-12-20 | Clay | West Virginia | 54015 | 230 | 3 |
845655 | 845655 | 2020-12-19 | Clay | West Virginia | 54015 | 223 | 3 |
842409 | 842409 | 2020-12-18 | Clay | West Virginia | 54015 | 222 | 3 |
839164 | 839164 | 2020-12-17 | Clay | West Virginia | 54015 | 216 | 3 |
835919 | 835919 | 2020-12-16 | Clay | West Virginia | 54015 | 211 | 3 |
832673 | 832673 | 2020-12-15 | Clay | West Virginia | 54015 | 200 | 3 |
829426 | 829426 | 2020-12-14 | Clay | West Virginia | 54015 | 193 | 3 |
826180 | 826180 | 2020-12-13 | Clay | West Virginia | 54015 | 192 | 3 |
822933 | 822933 | 2020-12-12 | Clay | West Virginia | 54015 | 190 | 3 |
819687 | 819687 | 2020-12-11 | Clay | West Virginia | 54015 | 186 | 3 |
816441 | 816441 | 2020-12-10 | Clay | West Virginia | 54015 | 183 | 3 |
813195 | 813195 | 2020-12-09 | Clay | West Virginia | 54015 | 170 | 3 |
809951 | 809951 | 2020-12-08 | Clay | West Virginia | 54015 | 161 | 3 |
806706 | 806706 | 2020-12-07 | Clay | West Virginia | 54015 | 158 | 3 |
803461 | 803461 | 2020-12-06 | Clay | West Virginia | 54015 | 149 | 3 |
800216 | 800216 | 2020-12-05 | Clay | West Virginia | 54015 | 149 | 3 |
796971 | 796971 | 2020-12-04 | Clay | West Virginia | 54015 | 147 | 3 |
793726 | 793726 | 2020-12-03 | Clay | West Virginia | 54015 | 132 | 3 |
790481 | 790481 | 2020-12-02 | Clay | West Virginia | 54015 | 123 | 3 |
787236 | 787236 | 2020-12-01 | Clay | West Virginia | 54015 | 120 | 3 |
783992 | 783992 | 2020-11-30 | Clay | West Virginia | 54015 | 121 | 3 |
780747 | 780747 | 2020-11-29 | Clay | West Virginia | 54015 | 117 | 3 |
777501 | 777501 | 2020-11-28 | Clay | West Virginia | 54015 | 107 | 3 |
774256 | 774256 | 2020-11-27 | Clay | West Virginia | 54015 | 107 | 3 |
771011 | 771011 | 2020-11-26 | Clay | West Virginia | 54015 | 106 | 3 |
767765 | 767765 | 2020-11-25 | Clay | West Virginia | 54015 | 107 | 3 |
764520 | 764520 | 2020-11-24 | Clay | West Virginia | 54015 | 107 | 3 |
761275 | 761275 | 2020-11-23 | Clay | West Virginia | 54015 | 104 | 3 |
758030 | 758030 | 2020-11-22 | Clay | West Virginia | 54015 | 104 | 3 |
754783 | 754783 | 2020-11-21 | Clay | West Virginia | 54015 | 104 | 3 |
751537 | 751537 | 2020-11-20 | Clay | West Virginia | 54015 | 104 | 3 |
748291 | 748291 | 2020-11-19 | Clay | West Virginia | 54015 | 100 | 3 |
745045 | 745045 | 2020-11-18 | Clay | West Virginia | 54015 | 100 | 3 |
741798 | 741798 | 2020-11-17 | Clay | West Virginia | 54015 | 99 | 3 |
738551 | 738551 | 2020-11-16 | Clay | West Virginia | 54015 | 94 | 3 |
735307 | 735307 | 2020-11-15 | Clay | West Virginia | 54015 | 94 | 3 |
732061 | 732061 | 2020-11-14 | Clay | West Virginia | 54015 | 94 | 3 |
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);