ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Ohio" 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 |
---|---|---|---|---|---|---|---|
1196241 | 1196241 | 2021-04-06 | Ohio | West Virginia | 54069 | 3913 | 81 |
1192993 | 1192993 | 2021-04-05 | Ohio | West Virginia | 54069 | 3900 | 81 |
1189743 | 1189743 | 2021-04-04 | Ohio | West Virginia | 54069 | 3893 | 81 |
1186496 | 1186496 | 2021-04-03 | Ohio | West Virginia | 54069 | 3885 | 80 |
1183249 | 1183249 | 2021-04-02 | Ohio | West Virginia | 54069 | 3870 | 80 |
1180002 | 1180002 | 2021-04-01 | Ohio | West Virginia | 54069 | 3859 | 80 |
1176755 | 1176755 | 2021-03-31 | Ohio | West Virginia | 54069 | 3842 | 78 |
1173508 | 1173508 | 2021-03-30 | Ohio | West Virginia | 54069 | 3833 | 77 |
1170261 | 1170261 | 2021-03-29 | Ohio | West Virginia | 54069 | 3822 | 77 |
1167013 | 1167013 | 2021-03-28 | Ohio | West Virginia | 54069 | 3813 | 77 |
1163765 | 1163765 | 2021-03-27 | Ohio | West Virginia | 54069 | 3810 | 77 |
1160517 | 1160517 | 2021-03-26 | Ohio | West Virginia | 54069 | 3792 | 77 |
1157269 | 1157269 | 2021-03-25 | Ohio | West Virginia | 54069 | 3782 | 77 |
1154022 | 1154022 | 2021-03-24 | Ohio | West Virginia | 54069 | 3774 | 77 |
1150775 | 1150775 | 2021-03-23 | Ohio | West Virginia | 54069 | 3767 | 77 |
1147528 | 1147528 | 2021-03-22 | Ohio | West Virginia | 54069 | 3762 | 77 |
1144281 | 1144281 | 2021-03-21 | Ohio | West Virginia | 54069 | 3752 | 77 |
1141034 | 1141034 | 2021-03-20 | Ohio | West Virginia | 54069 | 3746 | 76 |
1137788 | 1137788 | 2021-03-19 | Ohio | West Virginia | 54069 | 3739 | 76 |
1134542 | 1134542 | 2021-03-18 | Ohio | West Virginia | 54069 | 3728 | 75 |
1131294 | 1131294 | 2021-03-17 | Ohio | West Virginia | 54069 | 3718 | 74 |
1128047 | 1128047 | 2021-03-16 | Ohio | West Virginia | 54069 | 3717 | 76 |
1124801 | 1124801 | 2021-03-15 | Ohio | West Virginia | 54069 | 3710 | 76 |
1121555 | 1121555 | 2021-03-14 | Ohio | West Virginia | 54069 | 3708 | 76 |
1118308 | 1118308 | 2021-03-13 | Ohio | West Virginia | 54069 | 3698 | 75 |
1115061 | 1115061 | 2021-03-12 | Ohio | West Virginia | 54069 | 3691 | 75 |
1111815 | 1111815 | 2021-03-11 | Ohio | West Virginia | 54069 | 3677 | 68 |
1108569 | 1108569 | 2021-03-10 | Ohio | West Virginia | 54069 | 3674 | 68 |
1105323 | 1105323 | 2021-03-09 | Ohio | West Virginia | 54069 | 3669 | 67 |
1102077 | 1102077 | 2021-03-08 | Ohio | West Virginia | 54069 | 3666 | 67 |
1098831 | 1098831 | 2021-03-07 | Ohio | West Virginia | 54069 | 3665 | 67 |
1095583 | 1095583 | 2021-03-06 | Ohio | West Virginia | 54069 | 3680 | 67 |
1092337 | 1092337 | 2021-03-05 | Ohio | West Virginia | 54069 | 3666 | 67 |
1089091 | 1089091 | 2021-03-04 | Ohio | West Virginia | 54069 | 3662 | 67 |
1085846 | 1085846 | 2021-03-03 | Ohio | West Virginia | 54069 | 3652 | 67 |
1082600 | 1082600 | 2021-03-02 | Ohio | West Virginia | 54069 | 3640 | 67 |
1079354 | 1079354 | 2021-03-01 | Ohio | West Virginia | 54069 | 3637 | 67 |
1076109 | 1076109 | 2021-02-28 | Ohio | West Virginia | 54069 | 3636 | 67 |
1072863 | 1072863 | 2021-02-27 | Ohio | West Virginia | 54069 | 3626 | 67 |
1069617 | 1069617 | 2021-02-26 | Ohio | West Virginia | 54069 | 3619 | 67 |
1066372 | 1066372 | 2021-02-25 | Ohio | West Virginia | 54069 | 3617 | 67 |
1063127 | 1063127 | 2021-02-24 | Ohio | West Virginia | 54069 | 3609 | 67 |
1059882 | 1059882 | 2021-02-23 | Ohio | West Virginia | 54069 | 3603 | 67 |
1056636 | 1056636 | 2021-02-22 | Ohio | West Virginia | 54069 | 3595 | 67 |
1053390 | 1053390 | 2021-02-21 | Ohio | West Virginia | 54069 | 3593 | 67 |
1050143 | 1050143 | 2021-02-20 | Ohio | West Virginia | 54069 | 3578 | 67 |
1046896 | 1046896 | 2021-02-19 | Ohio | West Virginia | 54069 | 3567 | 67 |
1043651 | 1043651 | 2021-02-18 | Ohio | West Virginia | 54069 | 3561 | 67 |
1040406 | 1040406 | 2021-02-17 | Ohio | West Virginia | 54069 | 3554 | 67 |
1037161 | 1037161 | 2021-02-16 | Ohio | West Virginia | 54069 | 3545 | 67 |
1033916 | 1033916 | 2021-02-15 | Ohio | West Virginia | 54069 | 3543 | 67 |
1030670 | 1030670 | 2021-02-14 | Ohio | West Virginia | 54069 | 3538 | 66 |
1027423 | 1027423 | 2021-02-13 | Ohio | West Virginia | 54069 | 3529 | 66 |
1024178 | 1024178 | 2021-02-12 | Ohio | West Virginia | 54069 | 3520 | 66 |
1020933 | 1020933 | 2021-02-11 | Ohio | West Virginia | 54069 | 3507 | 66 |
1017688 | 1017688 | 2021-02-10 | Ohio | West Virginia | 54069 | 3499 | 65 |
1014443 | 1014443 | 2021-02-09 | Ohio | West Virginia | 54069 | 3488 | 65 |
1011198 | 1011198 | 2021-02-08 | Ohio | West Virginia | 54069 | 3478 | 65 |
1007952 | 1007952 | 2021-02-07 | Ohio | West Virginia | 54069 | 3474 | 65 |
1004706 | 1004706 | 2021-02-06 | Ohio | West Virginia | 54069 | 3463 | 65 |
1001460 | 1001460 | 2021-02-05 | Ohio | West Virginia | 54069 | 3438 | 65 |
998214 | 998214 | 2021-02-04 | Ohio | West Virginia | 54069 | 3431 | 63 |
994968 | 994968 | 2021-02-03 | Ohio | West Virginia | 54069 | 3427 | 63 |
991722 | 991722 | 2021-02-02 | Ohio | West Virginia | 54069 | 3415 | 63 |
988476 | 988476 | 2021-02-01 | Ohio | West Virginia | 54069 | 3411 | 63 |
985229 | 985229 | 2021-01-31 | Ohio | West Virginia | 54069 | 3397 | 63 |
981982 | 981982 | 2021-01-30 | Ohio | West Virginia | 54069 | 3385 | 63 |
978736 | 978736 | 2021-01-29 | Ohio | West Virginia | 54069 | 3361 | 63 |
975491 | 975491 | 2021-01-28 | Ohio | West Virginia | 54069 | 3334 | 63 |
972246 | 972246 | 2021-01-27 | Ohio | West Virginia | 54069 | 3315 | 60 |
969001 | 969001 | 2021-01-26 | Ohio | West Virginia | 54069 | 3293 | 59 |
965757 | 965757 | 2021-01-25 | Ohio | West Virginia | 54069 | 3231 | 58 |
962512 | 962512 | 2021-01-24 | Ohio | West Virginia | 54069 | 3224 | 58 |
959267 | 959267 | 2021-01-23 | Ohio | West Virginia | 54069 | 3218 | 57 |
956021 | 956021 | 2021-01-22 | Ohio | West Virginia | 54069 | 3200 | 57 |
952776 | 952776 | 2021-01-21 | Ohio | West Virginia | 54069 | 3180 | 57 |
949531 | 949531 | 2021-01-20 | Ohio | West Virginia | 54069 | 3154 | 57 |
946285 | 946285 | 2021-01-19 | Ohio | West Virginia | 54069 | 3127 | 57 |
943038 | 943038 | 2021-01-18 | Ohio | West Virginia | 54069 | 3076 | 57 |
939793 | 939793 | 2021-01-17 | Ohio | West Virginia | 54069 | 3037 | 57 |
936548 | 936548 | 2021-01-16 | Ohio | West Virginia | 54069 | 3025 | 56 |
933303 | 933303 | 2021-01-15 | Ohio | West Virginia | 54069 | 2991 | 54 |
930058 | 930058 | 2021-01-14 | Ohio | West Virginia | 54069 | 2945 | 52 |
926813 | 926813 | 2021-01-13 | Ohio | West Virginia | 54069 | 2931 | 52 |
923567 | 923567 | 2021-01-12 | Ohio | West Virginia | 54069 | 2906 | 51 |
920322 | 920322 | 2021-01-11 | Ohio | West Virginia | 54069 | 2884 | 51 |
917077 | 917077 | 2021-01-10 | Ohio | West Virginia | 54069 | 2850 | 50 |
913832 | 913832 | 2021-01-09 | Ohio | West Virginia | 54069 | 2820 | 50 |
910587 | 910587 | 2021-01-08 | Ohio | West Virginia | 54069 | 2780 | 47 |
907342 | 907342 | 2021-01-07 | Ohio | West Virginia | 54069 | 2721 | 45 |
904096 | 904096 | 2021-01-06 | Ohio | West Virginia | 54069 | 2687 | 40 |
900851 | 900851 | 2021-01-05 | Ohio | West Virginia | 54069 | 2667 | 40 |
897606 | 897606 | 2021-01-04 | Ohio | West Virginia | 54069 | 2642 | 39 |
894360 | 894360 | 2021-01-03 | Ohio | West Virginia | 54069 | 2627 | 39 |
891114 | 891114 | 2021-01-02 | Ohio | West Virginia | 54069 | 2580 | 39 |
887867 | 887867 | 2021-01-01 | Ohio | West Virginia | 54069 | 2543 | 37 |
884622 | 884622 | 2020-12-31 | Ohio | West Virginia | 54069 | 2484 | 37 |
881377 | 881377 | 2020-12-30 | Ohio | West Virginia | 54069 | 2480 | 36 |
878132 | 878132 | 2020-12-29 | Ohio | West Virginia | 54069 | 2452 | 33 |
874887 | 874887 | 2020-12-28 | Ohio | West Virginia | 54069 | 2417 | 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);