ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Hancock" 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 |
---|---|---|---|---|---|---|---|
1196221 | 1196221 | 2021-04-06 | Hancock | West Virginia | 54029 | 2650 | 97 |
1192973 | 1192973 | 2021-04-05 | Hancock | West Virginia | 54029 | 2647 | 97 |
1189723 | 1189723 | 2021-04-04 | Hancock | West Virginia | 54029 | 2643 | 97 |
1186476 | 1186476 | 2021-04-03 | Hancock | West Virginia | 54029 | 2638 | 97 |
1183229 | 1183229 | 2021-04-02 | Hancock | West Virginia | 54029 | 2634 | 97 |
1179982 | 1179982 | 2021-04-01 | Hancock | West Virginia | 54029 | 2633 | 96 |
1176735 | 1176735 | 2021-03-31 | Hancock | West Virginia | 54029 | 2631 | 96 |
1173488 | 1173488 | 2021-03-30 | Hancock | West Virginia | 54029 | 2630 | 95 |
1170241 | 1170241 | 2021-03-29 | Hancock | West Virginia | 54029 | 2629 | 95 |
1166993 | 1166993 | 2021-03-28 | Hancock | West Virginia | 54029 | 2627 | 95 |
1163745 | 1163745 | 2021-03-27 | Hancock | West Virginia | 54029 | 2627 | 95 |
1160497 | 1160497 | 2021-03-26 | Hancock | West Virginia | 54029 | 2622 | 95 |
1157249 | 1157249 | 2021-03-25 | Hancock | West Virginia | 54029 | 2617 | 95 |
1154002 | 1154002 | 2021-03-24 | Hancock | West Virginia | 54029 | 2613 | 95 |
1150755 | 1150755 | 2021-03-23 | Hancock | West Virginia | 54029 | 2610 | 95 |
1147508 | 1147508 | 2021-03-22 | Hancock | West Virginia | 54029 | 2610 | 95 |
1144261 | 1144261 | 2021-03-21 | Hancock | West Virginia | 54029 | 2609 | 95 |
1141014 | 1141014 | 2021-03-20 | Hancock | West Virginia | 54029 | 2607 | 95 |
1137768 | 1137768 | 2021-03-19 | Hancock | West Virginia | 54029 | 2603 | 95 |
1134522 | 1134522 | 2021-03-18 | Hancock | West Virginia | 54029 | 2601 | 93 |
1131274 | 1131274 | 2021-03-17 | Hancock | West Virginia | 54029 | 2601 | 92 |
1128027 | 1128027 | 2021-03-16 | Hancock | West Virginia | 54029 | 2600 | 92 |
1124781 | 1124781 | 2021-03-15 | Hancock | West Virginia | 54029 | 2597 | 92 |
1121535 | 1121535 | 2021-03-14 | Hancock | West Virginia | 54029 | 2596 | 92 |
1118288 | 1118288 | 2021-03-13 | Hancock | West Virginia | 54029 | 2596 | 92 |
1115041 | 1115041 | 2021-03-12 | Hancock | West Virginia | 54029 | 2595 | 91 |
1111795 | 1111795 | 2021-03-11 | Hancock | West Virginia | 54029 | 2595 | 86 |
1108549 | 1108549 | 2021-03-10 | Hancock | West Virginia | 54029 | 2595 | 86 |
1105303 | 1105303 | 2021-03-09 | Hancock | West Virginia | 54029 | 2595 | 86 |
1102057 | 1102057 | 2021-03-08 | Hancock | West Virginia | 54029 | 2595 | 86 |
1098811 | 1098811 | 2021-03-07 | Hancock | West Virginia | 54029 | 2595 | 86 |
1095563 | 1095563 | 2021-03-06 | Hancock | West Virginia | 54029 | 2605 | 86 |
1092317 | 1092317 | 2021-03-05 | Hancock | West Virginia | 54029 | 2603 | 86 |
1089071 | 1089071 | 2021-03-04 | Hancock | West Virginia | 54029 | 2601 | 86 |
1085826 | 1085826 | 2021-03-03 | Hancock | West Virginia | 54029 | 2599 | 86 |
1082580 | 1082580 | 2021-03-02 | Hancock | West Virginia | 54029 | 2598 | 86 |
1079334 | 1079334 | 2021-03-01 | Hancock | West Virginia | 54029 | 2596 | 86 |
1076089 | 1076089 | 2021-02-28 | Hancock | West Virginia | 54029 | 2595 | 86 |
1072843 | 1072843 | 2021-02-27 | Hancock | West Virginia | 54029 | 2591 | 86 |
1069597 | 1069597 | 2021-02-26 | Hancock | West Virginia | 54029 | 2588 | 86 |
1066352 | 1066352 | 2021-02-25 | Hancock | West Virginia | 54029 | 2581 | 86 |
1063107 | 1063107 | 2021-02-24 | Hancock | West Virginia | 54029 | 2577 | 86 |
1059862 | 1059862 | 2021-02-23 | Hancock | West Virginia | 54029 | 2577 | 86 |
1056616 | 1056616 | 2021-02-22 | Hancock | West Virginia | 54029 | 2573 | 86 |
1053370 | 1053370 | 2021-02-21 | Hancock | West Virginia | 54029 | 2572 | 86 |
1050123 | 1050123 | 2021-02-20 | Hancock | West Virginia | 54029 | 2570 | 85 |
1046876 | 1046876 | 2021-02-19 | Hancock | West Virginia | 54029 | 2565 | 85 |
1043631 | 1043631 | 2021-02-18 | Hancock | West Virginia | 54029 | 2561 | 85 |
1040386 | 1040386 | 2021-02-17 | Hancock | West Virginia | 54029 | 2559 | 84 |
1037141 | 1037141 | 2021-02-16 | Hancock | West Virginia | 54029 | 2556 | 84 |
1033896 | 1033896 | 2021-02-15 | Hancock | West Virginia | 54029 | 2555 | 84 |
1030650 | 1030650 | 2021-02-14 | Hancock | West Virginia | 54029 | 2552 | 84 |
1027403 | 1027403 | 2021-02-13 | Hancock | West Virginia | 54029 | 2551 | 84 |
1024158 | 1024158 | 2021-02-12 | Hancock | West Virginia | 54029 | 2548 | 84 |
1020913 | 1020913 | 2021-02-11 | Hancock | West Virginia | 54029 | 2547 | 84 |
1017668 | 1017668 | 2021-02-10 | Hancock | West Virginia | 54029 | 2542 | 83 |
1014423 | 1014423 | 2021-02-09 | Hancock | West Virginia | 54029 | 2537 | 83 |
1011178 | 1011178 | 2021-02-08 | Hancock | West Virginia | 54029 | 2535 | 83 |
1007932 | 1007932 | 2021-02-07 | Hancock | West Virginia | 54029 | 2535 | 83 |
1004686 | 1004686 | 2021-02-06 | Hancock | West Virginia | 54029 | 2527 | 83 |
1001440 | 1001440 | 2021-02-05 | Hancock | West Virginia | 54029 | 2521 | 83 |
998194 | 998194 | 2021-02-04 | Hancock | West Virginia | 54029 | 2511 | 82 |
994948 | 994948 | 2021-02-03 | Hancock | West Virginia | 54029 | 2501 | 82 |
991702 | 991702 | 2021-02-02 | Hancock | West Virginia | 54029 | 2495 | 82 |
988456 | 988456 | 2021-02-01 | Hancock | West Virginia | 54029 | 2489 | 82 |
985209 | 985209 | 2021-01-31 | Hancock | West Virginia | 54029 | 2485 | 82 |
981962 | 981962 | 2021-01-30 | Hancock | West Virginia | 54029 | 2481 | 82 |
978716 | 978716 | 2021-01-29 | Hancock | West Virginia | 54029 | 2466 | 82 |
975471 | 975471 | 2021-01-28 | Hancock | West Virginia | 54029 | 2451 | 82 |
972226 | 972226 | 2021-01-27 | Hancock | West Virginia | 54029 | 2438 | 79 |
968981 | 968981 | 2021-01-26 | Hancock | West Virginia | 54029 | 2417 | 79 |
965737 | 965737 | 2021-01-25 | Hancock | West Virginia | 54029 | 2396 | 79 |
962492 | 962492 | 2021-01-24 | Hancock | West Virginia | 54029 | 2393 | 79 |
959247 | 959247 | 2021-01-23 | Hancock | West Virginia | 54029 | 2380 | 78 |
956001 | 956001 | 2021-01-22 | Hancock | West Virginia | 54029 | 2379 | 78 |
952756 | 952756 | 2021-01-21 | Hancock | West Virginia | 54029 | 2360 | 77 |
949511 | 949511 | 2021-01-20 | Hancock | West Virginia | 54029 | 2344 | 76 |
946265 | 946265 | 2021-01-19 | Hancock | West Virginia | 54029 | 2330 | 76 |
943018 | 943018 | 2021-01-18 | Hancock | West Virginia | 54029 | 2318 | 75 |
939773 | 939773 | 2021-01-17 | Hancock | West Virginia | 54029 | 2317 | 74 |
936528 | 936528 | 2021-01-16 | Hancock | West Virginia | 54029 | 2291 | 74 |
933283 | 933283 | 2021-01-15 | Hancock | West Virginia | 54029 | 2265 | 66 |
930038 | 930038 | 2021-01-14 | Hancock | West Virginia | 54029 | 2240 | 66 |
926793 | 926793 | 2021-01-13 | Hancock | West Virginia | 54029 | 2228 | 66 |
923547 | 923547 | 2021-01-12 | Hancock | West Virginia | 54029 | 2200 | 61 |
920302 | 920302 | 2021-01-11 | Hancock | West Virginia | 54029 | 2173 | 61 |
917057 | 917057 | 2021-01-10 | Hancock | West Virginia | 54029 | 2162 | 57 |
913812 | 913812 | 2021-01-09 | Hancock | West Virginia | 54029 | 2143 | 57 |
910567 | 910567 | 2021-01-08 | Hancock | West Virginia | 54029 | 2126 | 56 |
907322 | 907322 | 2021-01-07 | Hancock | West Virginia | 54029 | 2083 | 55 |
904076 | 904076 | 2021-01-06 | Hancock | West Virginia | 54029 | 2060 | 52 |
900831 | 900831 | 2021-01-05 | Hancock | West Virginia | 54029 | 2031 | 49 |
897586 | 897586 | 2021-01-04 | Hancock | West Virginia | 54029 | 1997 | 43 |
894340 | 894340 | 2021-01-03 | Hancock | West Virginia | 54029 | 1996 | 42 |
891094 | 891094 | 2021-01-02 | Hancock | West Virginia | 54029 | 1973 | 42 |
887847 | 887847 | 2021-01-01 | Hancock | West Virginia | 54029 | 1922 | 42 |
884602 | 884602 | 2020-12-31 | Hancock | West Virginia | 54029 | 1837 | 41 |
881357 | 881357 | 2020-12-30 | Hancock | West Virginia | 54029 | 1821 | 40 |
878112 | 878112 | 2020-12-29 | Hancock | West Virginia | 54029 | 1801 | 36 |
874867 | 874867 | 2020-12-28 | Hancock | West Virginia | 54029 | 1740 | 33 |
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);