ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 54093 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 |
---|---|---|---|---|---|---|---|
1199502 | 1199502 | 2021-04-07 | Tucker | West Virginia | 54093 | 521 | 10 |
1196253 | 1196253 | 2021-04-06 | Tucker | West Virginia | 54093 | 520 | 10 |
1193005 | 1193005 | 2021-04-05 | Tucker | West Virginia | 54093 | 520 | 10 |
1189755 | 1189755 | 2021-04-04 | Tucker | West Virginia | 54093 | 519 | 10 |
1186508 | 1186508 | 2021-04-03 | Tucker | West Virginia | 54093 | 519 | 10 |
1183261 | 1183261 | 2021-04-02 | Tucker | West Virginia | 54093 | 519 | 10 |
1180014 | 1180014 | 2021-04-01 | Tucker | West Virginia | 54093 | 518 | 10 |
1176767 | 1176767 | 2021-03-31 | Tucker | West Virginia | 54093 | 517 | 10 |
1173520 | 1173520 | 2021-03-30 | Tucker | West Virginia | 54093 | 516 | 10 |
1170273 | 1170273 | 2021-03-29 | Tucker | West Virginia | 54093 | 517 | 10 |
1167025 | 1167025 | 2021-03-28 | Tucker | West Virginia | 54093 | 516 | 10 |
1163777 | 1163777 | 2021-03-27 | Tucker | West Virginia | 54093 | 516 | 10 |
1160529 | 1160529 | 2021-03-26 | Tucker | West Virginia | 54093 | 516 | 10 |
1157281 | 1157281 | 2021-03-25 | Tucker | West Virginia | 54093 | 514 | 10 |
1154034 | 1154034 | 2021-03-24 | Tucker | West Virginia | 54093 | 513 | 10 |
1150787 | 1150787 | 2021-03-23 | Tucker | West Virginia | 54093 | 513 | 10 |
1147540 | 1147540 | 2021-03-22 | Tucker | West Virginia | 54093 | 512 | 10 |
1144293 | 1144293 | 2021-03-21 | Tucker | West Virginia | 54093 | 512 | 10 |
1141046 | 1141046 | 2021-03-20 | Tucker | West Virginia | 54093 | 512 | 10 |
1137800 | 1137800 | 2021-03-19 | Tucker | West Virginia | 54093 | 512 | 10 |
1134554 | 1134554 | 2021-03-18 | Tucker | West Virginia | 54093 | 510 | 9 |
1131306 | 1131306 | 2021-03-17 | Tucker | West Virginia | 54093 | 508 | 9 |
1128059 | 1128059 | 2021-03-16 | Tucker | West Virginia | 54093 | 510 | 9 |
1124813 | 1124813 | 2021-03-15 | Tucker | West Virginia | 54093 | 509 | 9 |
1121567 | 1121567 | 2021-03-14 | Tucker | West Virginia | 54093 | 509 | 9 |
1118320 | 1118320 | 2021-03-13 | Tucker | West Virginia | 54093 | 509 | 9 |
1115073 | 1115073 | 2021-03-12 | Tucker | West Virginia | 54093 | 509 | 9 |
1111827 | 1111827 | 2021-03-11 | Tucker | West Virginia | 54093 | 509 | 9 |
1108581 | 1108581 | 2021-03-10 | Tucker | West Virginia | 54093 | 508 | 9 |
1105335 | 1105335 | 2021-03-09 | Tucker | West Virginia | 54093 | 508 | 9 |
1102089 | 1102089 | 2021-03-08 | Tucker | West Virginia | 54093 | 508 | 9 |
1098843 | 1098843 | 2021-03-07 | Tucker | West Virginia | 54093 | 508 | 9 |
1095595 | 1095595 | 2021-03-06 | Tucker | West Virginia | 54093 | 507 | 9 |
1092349 | 1092349 | 2021-03-05 | Tucker | West Virginia | 54093 | 507 | 9 |
1089103 | 1089103 | 2021-03-04 | Tucker | West Virginia | 54093 | 506 | 9 |
1085858 | 1085858 | 2021-03-03 | Tucker | West Virginia | 54093 | 503 | 9 |
1082612 | 1082612 | 2021-03-02 | Tucker | West Virginia | 54093 | 503 | 8 |
1079366 | 1079366 | 2021-03-01 | Tucker | West Virginia | 54093 | 499 | 8 |
1076121 | 1076121 | 2021-02-28 | Tucker | West Virginia | 54093 | 499 | 8 |
1072875 | 1072875 | 2021-02-27 | Tucker | West Virginia | 54093 | 499 | 8 |
1069629 | 1069629 | 2021-02-26 | Tucker | West Virginia | 54093 | 499 | 8 |
1066384 | 1066384 | 2021-02-25 | Tucker | West Virginia | 54093 | 499 | 8 |
1063139 | 1063139 | 2021-02-24 | Tucker | West Virginia | 54093 | 499 | 7 |
1059894 | 1059894 | 2021-02-23 | Tucker | West Virginia | 54093 | 496 | 7 |
1056648 | 1056648 | 2021-02-22 | Tucker | West Virginia | 54093 | 495 | 7 |
1053402 | 1053402 | 2021-02-21 | Tucker | West Virginia | 54093 | 495 | 7 |
1050155 | 1050155 | 2021-02-20 | Tucker | West Virginia | 54093 | 495 | 7 |
1046908 | 1046908 | 2021-02-19 | Tucker | West Virginia | 54093 | 495 | 7 |
1043663 | 1043663 | 2021-02-18 | Tucker | West Virginia | 54093 | 492 | 7 |
1040418 | 1040418 | 2021-02-17 | Tucker | West Virginia | 54093 | 492 | 7 |
1037173 | 1037173 | 2021-02-16 | Tucker | West Virginia | 54093 | 492 | 7 |
1033928 | 1033928 | 2021-02-15 | Tucker | West Virginia | 54093 | 488 | 7 |
1030682 | 1030682 | 2021-02-14 | Tucker | West Virginia | 54093 | 485 | 7 |
1027435 | 1027435 | 2021-02-13 | Tucker | West Virginia | 54093 | 484 | 7 |
1024190 | 1024190 | 2021-02-12 | Tucker | West Virginia | 54093 | 483 | 7 |
1020945 | 1020945 | 2021-02-11 | Tucker | West Virginia | 54093 | 480 | 7 |
1017700 | 1017700 | 2021-02-10 | Tucker | West Virginia | 54093 | 477 | 7 |
1014455 | 1014455 | 2021-02-09 | Tucker | West Virginia | 54093 | 477 | 7 |
1011210 | 1011210 | 2021-02-08 | Tucker | West Virginia | 54093 | 477 | 7 |
1007964 | 1007964 | 2021-02-07 | Tucker | West Virginia | 54093 | 476 | 7 |
1004718 | 1004718 | 2021-02-06 | Tucker | West Virginia | 54093 | 476 | 7 |
1001472 | 1001472 | 2021-02-05 | Tucker | West Virginia | 54093 | 475 | 7 |
998226 | 998226 | 2021-02-04 | Tucker | West Virginia | 54093 | 471 | 7 |
994980 | 994980 | 2021-02-03 | Tucker | West Virginia | 54093 | 463 | 7 |
991734 | 991734 | 2021-02-02 | Tucker | West Virginia | 54093 | 460 | 7 |
988488 | 988488 | 2021-02-01 | Tucker | West Virginia | 54093 | 459 | 7 |
985241 | 985241 | 2021-01-31 | Tucker | West Virginia | 54093 | 457 | 7 |
981994 | 981994 | 2021-01-30 | Tucker | West Virginia | 54093 | 454 | 7 |
978748 | 978748 | 2021-01-29 | Tucker | West Virginia | 54093 | 451 | 7 |
975503 | 975503 | 2021-01-28 | Tucker | West Virginia | 54093 | 449 | 7 |
972258 | 972258 | 2021-01-27 | Tucker | West Virginia | 54093 | 442 | 7 |
969013 | 969013 | 2021-01-26 | Tucker | West Virginia | 54093 | 442 | 7 |
965769 | 965769 | 2021-01-25 | Tucker | West Virginia | 54093 | 438 | 7 |
962524 | 962524 | 2021-01-24 | Tucker | West Virginia | 54093 | 433 | 7 |
959279 | 959279 | 2021-01-23 | Tucker | West Virginia | 54093 | 430 | 7 |
956033 | 956033 | 2021-01-22 | Tucker | West Virginia | 54093 | 428 | 7 |
952788 | 952788 | 2021-01-21 | Tucker | West Virginia | 54093 | 427 | 7 |
949543 | 949543 | 2021-01-20 | Tucker | West Virginia | 54093 | 422 | 7 |
946297 | 946297 | 2021-01-19 | Tucker | West Virginia | 54093 | 419 | 7 |
943050 | 943050 | 2021-01-18 | Tucker | West Virginia | 54093 | 417 | 6 |
939805 | 939805 | 2021-01-17 | Tucker | West Virginia | 54093 | 417 | 6 |
936560 | 936560 | 2021-01-16 | Tucker | West Virginia | 54093 | 416 | 6 |
933315 | 933315 | 2021-01-15 | Tucker | West Virginia | 54093 | 409 | 5 |
930070 | 930070 | 2021-01-14 | Tucker | West Virginia | 54093 | 405 | 4 |
926825 | 926825 | 2021-01-13 | Tucker | West Virginia | 54093 | 405 | 4 |
923579 | 923579 | 2021-01-12 | Tucker | West Virginia | 54093 | 403 | 4 |
920334 | 920334 | 2021-01-11 | Tucker | West Virginia | 54093 | 406 | 4 |
917089 | 917089 | 2021-01-10 | Tucker | West Virginia | 54093 | 404 | 4 |
913844 | 913844 | 2021-01-09 | Tucker | West Virginia | 54093 | 401 | 4 |
910599 | 910599 | 2021-01-08 | Tucker | West Virginia | 54093 | 399 | 4 |
907354 | 907354 | 2021-01-07 | Tucker | West Virginia | 54093 | 386 | 4 |
904108 | 904108 | 2021-01-06 | Tucker | West Virginia | 54093 | 364 | 4 |
900863 | 900863 | 2021-01-05 | Tucker | West Virginia | 54093 | 357 | 3 |
897618 | 897618 | 2021-01-04 | Tucker | West Virginia | 54093 | 355 | 2 |
894372 | 894372 | 2021-01-03 | Tucker | West Virginia | 54093 | 348 | 2 |
891126 | 891126 | 2021-01-02 | Tucker | West Virginia | 54093 | 341 | 2 |
887879 | 887879 | 2021-01-01 | Tucker | West Virginia | 54093 | 338 | 2 |
884634 | 884634 | 2020-12-31 | Tucker | West Virginia | 54093 | 330 | 2 |
881389 | 881389 | 2020-12-30 | Tucker | West Virginia | 54093 | 321 | 2 |
878144 | 878144 | 2020-12-29 | Tucker | West Virginia | 54093 | 312 | 2 |
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);