ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jefferson" 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 |
---|---|---|---|---|---|---|---|
1196225 | 1196225 | 2021-04-06 | Jefferson | West Virginia | 54037 | 4136 | 47 |
1192977 | 1192977 | 2021-04-05 | Jefferson | West Virginia | 54037 | 4127 | 47 |
1189727 | 1189727 | 2021-04-04 | Jefferson | West Virginia | 54037 | 4120 | 47 |
1186480 | 1186480 | 2021-04-03 | Jefferson | West Virginia | 54037 | 4107 | 47 |
1183233 | 1183233 | 2021-04-02 | Jefferson | West Virginia | 54037 | 4098 | 47 |
1179986 | 1179986 | 2021-04-01 | Jefferson | West Virginia | 54037 | 4077 | 47 |
1176739 | 1176739 | 2021-03-31 | Jefferson | West Virginia | 54037 | 4051 | 47 |
1173492 | 1173492 | 2021-03-30 | Jefferson | West Virginia | 54037 | 4009 | 46 |
1170245 | 1170245 | 2021-03-29 | Jefferson | West Virginia | 54037 | 3991 | 46 |
1166997 | 1166997 | 2021-03-28 | Jefferson | West Virginia | 54037 | 3963 | 46 |
1163749 | 1163749 | 2021-03-27 | Jefferson | West Virginia | 54037 | 3952 | 46 |
1160501 | 1160501 | 2021-03-26 | Jefferson | West Virginia | 54037 | 3929 | 46 |
1157253 | 1157253 | 2021-03-25 | Jefferson | West Virginia | 54037 | 3914 | 46 |
1154006 | 1154006 | 2021-03-24 | Jefferson | West Virginia | 54037 | 3884 | 46 |
1150759 | 1150759 | 2021-03-23 | Jefferson | West Virginia | 54037 | 3864 | 45 |
1147512 | 1147512 | 2021-03-22 | Jefferson | West Virginia | 54037 | 3854 | 45 |
1144265 | 1144265 | 2021-03-21 | Jefferson | West Virginia | 54037 | 3837 | 45 |
1141018 | 1141018 | 2021-03-20 | Jefferson | West Virginia | 54037 | 3814 | 45 |
1137772 | 1137772 | 2021-03-19 | Jefferson | West Virginia | 54037 | 3801 | 46 |
1134526 | 1134526 | 2021-03-18 | Jefferson | West Virginia | 54037 | 3770 | 44 |
1131278 | 1131278 | 2021-03-17 | Jefferson | West Virginia | 54037 | 3753 | 44 |
1128031 | 1128031 | 2021-03-16 | Jefferson | West Virginia | 54037 | 3734 | 44 |
1124785 | 1124785 | 2021-03-15 | Jefferson | West Virginia | 54037 | 3718 | 44 |
1121539 | 1121539 | 2021-03-14 | Jefferson | West Virginia | 54037 | 3713 | 44 |
1118292 | 1118292 | 2021-03-13 | Jefferson | West Virginia | 54037 | 3702 | 44 |
1115045 | 1115045 | 2021-03-12 | Jefferson | West Virginia | 54037 | 3692 | 44 |
1111799 | 1111799 | 2021-03-11 | Jefferson | West Virginia | 54037 | 3682 | 40 |
1108553 | 1108553 | 2021-03-10 | Jefferson | West Virginia | 54037 | 3679 | 40 |
1105307 | 1105307 | 2021-03-09 | Jefferson | West Virginia | 54037 | 3672 | 39 |
1102061 | 1102061 | 2021-03-08 | Jefferson | West Virginia | 54037 | 3671 | 38 |
1098815 | 1098815 | 2021-03-07 | Jefferson | West Virginia | 54037 | 3668 | 38 |
1095567 | 1095567 | 2021-03-06 | Jefferson | West Virginia | 54037 | 3678 | 39 |
1092321 | 1092321 | 2021-03-05 | Jefferson | West Virginia | 54037 | 3666 | 39 |
1089075 | 1089075 | 2021-03-04 | Jefferson | West Virginia | 54037 | 3656 | 37 |
1085830 | 1085830 | 2021-03-03 | Jefferson | West Virginia | 54037 | 3649 | 37 |
1082584 | 1082584 | 2021-03-02 | Jefferson | West Virginia | 54037 | 3638 | 37 |
1079338 | 1079338 | 2021-03-01 | Jefferson | West Virginia | 54037 | 3634 | 37 |
1076093 | 1076093 | 2021-02-28 | Jefferson | West Virginia | 54037 | 3624 | 37 |
1072847 | 1072847 | 2021-02-27 | Jefferson | West Virginia | 54037 | 3616 | 37 |
1069601 | 1069601 | 2021-02-26 | Jefferson | West Virginia | 54037 | 3607 | 37 |
1066356 | 1066356 | 2021-02-25 | Jefferson | West Virginia | 54037 | 3602 | 37 |
1063111 | 1063111 | 2021-02-24 | Jefferson | West Virginia | 54037 | 3592 | 37 |
1059866 | 1059866 | 2021-02-23 | Jefferson | West Virginia | 54037 | 3585 | 37 |
1056620 | 1056620 | 2021-02-22 | Jefferson | West Virginia | 54037 | 3579 | 37 |
1053374 | 1053374 | 2021-02-21 | Jefferson | West Virginia | 54037 | 3575 | 37 |
1050127 | 1050127 | 2021-02-20 | Jefferson | West Virginia | 54037 | 3561 | 37 |
1046880 | 1046880 | 2021-02-19 | Jefferson | West Virginia | 54037 | 3560 | 37 |
1043635 | 1043635 | 2021-02-18 | Jefferson | West Virginia | 54037 | 3550 | 36 |
1040390 | 1040390 | 2021-02-17 | Jefferson | West Virginia | 54037 | 3541 | 36 |
1037145 | 1037145 | 2021-02-16 | Jefferson | West Virginia | 54037 | 3527 | 36 |
1033900 | 1033900 | 2021-02-15 | Jefferson | West Virginia | 54037 | 3520 | 36 |
1030654 | 1030654 | 2021-02-14 | Jefferson | West Virginia | 54037 | 3512 | 36 |
1027407 | 1027407 | 2021-02-13 | Jefferson | West Virginia | 54037 | 3501 | 36 |
1024162 | 1024162 | 2021-02-12 | Jefferson | West Virginia | 54037 | 3490 | 36 |
1020917 | 1020917 | 2021-02-11 | Jefferson | West Virginia | 54037 | 3476 | 36 |
1017672 | 1017672 | 2021-02-10 | Jefferson | West Virginia | 54037 | 3462 | 36 |
1014427 | 1014427 | 2021-02-09 | Jefferson | West Virginia | 54037 | 3456 | 35 |
1011182 | 1011182 | 2021-02-08 | Jefferson | West Virginia | 54037 | 3451 | 35 |
1007936 | 1007936 | 2021-02-07 | Jefferson | West Virginia | 54037 | 3438 | 35 |
1004690 | 1004690 | 2021-02-06 | Jefferson | West Virginia | 54037 | 3421 | 35 |
1001444 | 1001444 | 2021-02-05 | Jefferson | West Virginia | 54037 | 3394 | 35 |
998198 | 998198 | 2021-02-04 | Jefferson | West Virginia | 54037 | 3381 | 35 |
994952 | 994952 | 2021-02-03 | Jefferson | West Virginia | 54037 | 3377 | 35 |
991706 | 991706 | 2021-02-02 | Jefferson | West Virginia | 54037 | 3366 | 34 |
988460 | 988460 | 2021-02-01 | Jefferson | West Virginia | 54037 | 3360 | 34 |
985213 | 985213 | 2021-01-31 | Jefferson | West Virginia | 54037 | 3351 | 34 |
981966 | 981966 | 2021-01-30 | Jefferson | West Virginia | 54037 | 3324 | 33 |
978720 | 978720 | 2021-01-29 | Jefferson | West Virginia | 54037 | 3299 | 33 |
975475 | 975475 | 2021-01-28 | Jefferson | West Virginia | 54037 | 3270 | 32 |
972230 | 972230 | 2021-01-27 | Jefferson | West Virginia | 54037 | 3248 | 31 |
968985 | 968985 | 2021-01-26 | Jefferson | West Virginia | 54037 | 3223 | 31 |
965741 | 965741 | 2021-01-25 | Jefferson | West Virginia | 54037 | 3182 | 31 |
962496 | 962496 | 2021-01-24 | Jefferson | West Virginia | 54037 | 3170 | 31 |
959251 | 959251 | 2021-01-23 | Jefferson | West Virginia | 54037 | 3139 | 31 |
956005 | 956005 | 2021-01-22 | Jefferson | West Virginia | 54037 | 3112 | 31 |
952760 | 952760 | 2021-01-21 | Jefferson | West Virginia | 54037 | 3072 | 31 |
949515 | 949515 | 2021-01-20 | Jefferson | West Virginia | 54037 | 3059 | 31 |
946269 | 946269 | 2021-01-19 | Jefferson | West Virginia | 54037 | 3044 | 31 |
943022 | 943022 | 2021-01-18 | Jefferson | West Virginia | 54037 | 3019 | 29 |
939777 | 939777 | 2021-01-17 | Jefferson | West Virginia | 54037 | 2981 | 29 |
936532 | 936532 | 2021-01-16 | Jefferson | West Virginia | 54037 | 2964 | 29 |
933287 | 933287 | 2021-01-15 | Jefferson | West Virginia | 54037 | 2937 | 29 |
930042 | 930042 | 2021-01-14 | Jefferson | West Virginia | 54037 | 2893 | 29 |
926797 | 926797 | 2021-01-13 | Jefferson | West Virginia | 54037 | 2861 | 28 |
923551 | 923551 | 2021-01-12 | Jefferson | West Virginia | 54037 | 2828 | 28 |
920306 | 920306 | 2021-01-11 | Jefferson | West Virginia | 54037 | 2795 | 27 |
917061 | 917061 | 2021-01-10 | Jefferson | West Virginia | 54037 | 2766 | 27 |
913816 | 913816 | 2021-01-09 | Jefferson | West Virginia | 54037 | 2737 | 27 |
910571 | 910571 | 2021-01-08 | Jefferson | West Virginia | 54037 | 2696 | 27 |
907326 | 907326 | 2021-01-07 | Jefferson | West Virginia | 54037 | 2627 | 27 |
904080 | 904080 | 2021-01-06 | Jefferson | West Virginia | 54037 | 2596 | 27 |
900835 | 900835 | 2021-01-05 | Jefferson | West Virginia | 54037 | 2547 | 27 |
897590 | 897590 | 2021-01-04 | Jefferson | West Virginia | 54037 | 2513 | 27 |
894344 | 894344 | 2021-01-03 | Jefferson | West Virginia | 54037 | 2492 | 26 |
891098 | 891098 | 2021-01-02 | Jefferson | West Virginia | 54037 | 2463 | 26 |
887851 | 887851 | 2021-01-01 | Jefferson | West Virginia | 54037 | 2423 | 26 |
884606 | 884606 | 2020-12-31 | Jefferson | West Virginia | 54037 | 2337 | 26 |
881361 | 881361 | 2020-12-30 | Jefferson | West Virginia | 54037 | 2324 | 26 |
878116 | 878116 | 2020-12-29 | Jefferson | West Virginia | 54037 | 2282 | 25 |
874871 | 874871 | 2020-12-28 | Jefferson | West Virginia | 54037 | 2249 | 25 |
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);