ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Raleigh" 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 |
---|---|---|---|---|---|---|---|
1196247 | 1196247 | 2021-04-06 | Raleigh | West Virginia | 54081 | 5746 | 73 |
1192999 | 1192999 | 2021-04-05 | Raleigh | West Virginia | 54081 | 5722 | 72 |
1189749 | 1189749 | 2021-04-04 | Raleigh | West Virginia | 54081 | 5687 | 72 |
1186502 | 1186502 | 2021-04-03 | Raleigh | West Virginia | 54081 | 5665 | 72 |
1183255 | 1183255 | 2021-04-02 | Raleigh | West Virginia | 54081 | 5622 | 72 |
1180008 | 1180008 | 2021-04-01 | Raleigh | West Virginia | 54081 | 5571 | 72 |
1176761 | 1176761 | 2021-03-31 | Raleigh | West Virginia | 54081 | 5533 | 70 |
1173514 | 1173514 | 2021-03-30 | Raleigh | West Virginia | 54081 | 5494 | 70 |
1170267 | 1170267 | 2021-03-29 | Raleigh | West Virginia | 54081 | 5442 | 68 |
1167019 | 1167019 | 2021-03-28 | Raleigh | West Virginia | 54081 | 5411 | 67 |
1163771 | 1163771 | 2021-03-27 | Raleigh | West Virginia | 54081 | 5377 | 67 |
1160523 | 1160523 | 2021-03-26 | Raleigh | West Virginia | 54081 | 5316 | 67 |
1157275 | 1157275 | 2021-03-25 | Raleigh | West Virginia | 54081 | 5262 | 67 |
1154028 | 1154028 | 2021-03-24 | Raleigh | West Virginia | 54081 | 5232 | 67 |
1150781 | 1150781 | 2021-03-23 | Raleigh | West Virginia | 54081 | 5205 | 67 |
1147534 | 1147534 | 2021-03-22 | Raleigh | West Virginia | 54081 | 5175 | 67 |
1144287 | 1144287 | 2021-03-21 | Raleigh | West Virginia | 54081 | 5160 | 67 |
1141040 | 1141040 | 2021-03-20 | Raleigh | West Virginia | 54081 | 5133 | 67 |
1137794 | 1137794 | 2021-03-19 | Raleigh | West Virginia | 54081 | 5100 | 67 |
1134548 | 1134548 | 2021-03-18 | Raleigh | West Virginia | 54081 | 5049 | 66 |
1131300 | 1131300 | 2021-03-17 | Raleigh | West Virginia | 54081 | 5018 | 66 |
1128053 | 1128053 | 2021-03-16 | Raleigh | West Virginia | 54081 | 4996 | 66 |
1124807 | 1124807 | 2021-03-15 | Raleigh | West Virginia | 54081 | 4961 | 66 |
1121561 | 1121561 | 2021-03-14 | Raleigh | West Virginia | 54081 | 4934 | 66 |
1118314 | 1118314 | 2021-03-13 | Raleigh | West Virginia | 54081 | 4908 | 64 |
1115067 | 1115067 | 2021-03-12 | Raleigh | West Virginia | 54081 | 4888 | 64 |
1111821 | 1111821 | 2021-03-11 | Raleigh | West Virginia | 54081 | 4870 | 60 |
1108575 | 1108575 | 2021-03-10 | Raleigh | West Virginia | 54081 | 4856 | 60 |
1105329 | 1105329 | 2021-03-09 | Raleigh | West Virginia | 54081 | 4838 | 60 |
1102083 | 1102083 | 2021-03-08 | Raleigh | West Virginia | 54081 | 4833 | 60 |
1098837 | 1098837 | 2021-03-07 | Raleigh | West Virginia | 54081 | 4821 | 60 |
1095589 | 1095589 | 2021-03-06 | Raleigh | West Virginia | 54081 | 4809 | 60 |
1092343 | 1092343 | 2021-03-05 | Raleigh | West Virginia | 54081 | 4797 | 59 |
1089097 | 1089097 | 2021-03-04 | Raleigh | West Virginia | 54081 | 4776 | 58 |
1085852 | 1085852 | 2021-03-03 | Raleigh | West Virginia | 54081 | 4769 | 58 |
1082606 | 1082606 | 2021-03-02 | Raleigh | West Virginia | 54081 | 4717 | 58 |
1079360 | 1079360 | 2021-03-01 | Raleigh | West Virginia | 54081 | 4704 | 58 |
1076115 | 1076115 | 2021-02-28 | Raleigh | West Virginia | 54081 | 4696 | 58 |
1072869 | 1072869 | 2021-02-27 | Raleigh | West Virginia | 54081 | 4686 | 58 |
1069623 | 1069623 | 2021-02-26 | Raleigh | West Virginia | 54081 | 4663 | 56 |
1066378 | 1066378 | 2021-02-25 | Raleigh | West Virginia | 54081 | 4653 | 56 |
1063133 | 1063133 | 2021-02-24 | Raleigh | West Virginia | 54081 | 4636 | 55 |
1059888 | 1059888 | 2021-02-23 | Raleigh | West Virginia | 54081 | 4605 | 55 |
1056642 | 1056642 | 2021-02-22 | Raleigh | West Virginia | 54081 | 4597 | 55 |
1053396 | 1053396 | 2021-02-21 | Raleigh | West Virginia | 54081 | 4588 | 55 |
1050149 | 1050149 | 2021-02-20 | Raleigh | West Virginia | 54081 | 4579 | 55 |
1046902 | 1046902 | 2021-02-19 | Raleigh | West Virginia | 54081 | 4561 | 54 |
1043657 | 1043657 | 2021-02-18 | Raleigh | West Virginia | 54081 | 4549 | 54 |
1040412 | 1040412 | 2021-02-17 | Raleigh | West Virginia | 54081 | 4530 | 54 |
1037167 | 1037167 | 2021-02-16 | Raleigh | West Virginia | 54081 | 4524 | 54 |
1033922 | 1033922 | 2021-02-15 | Raleigh | West Virginia | 54081 | 4516 | 53 |
1030676 | 1030676 | 2021-02-14 | Raleigh | West Virginia | 54081 | 4503 | 53 |
1027429 | 1027429 | 2021-02-13 | Raleigh | West Virginia | 54081 | 4492 | 53 |
1024184 | 1024184 | 2021-02-12 | Raleigh | West Virginia | 54081 | 4462 | 53 |
1020939 | 1020939 | 2021-02-11 | Raleigh | West Virginia | 54081 | 4429 | 53 |
1017694 | 1017694 | 2021-02-10 | Raleigh | West Virginia | 54081 | 4412 | 53 |
1014449 | 1014449 | 2021-02-09 | Raleigh | West Virginia | 54081 | 4371 | 53 |
1011204 | 1011204 | 2021-02-08 | Raleigh | West Virginia | 54081 | 4355 | 51 |
1007958 | 1007958 | 2021-02-07 | Raleigh | West Virginia | 54081 | 4338 | 51 |
1004712 | 1004712 | 2021-02-06 | Raleigh | West Virginia | 54081 | 4315 | 50 |
1001466 | 1001466 | 2021-02-05 | Raleigh | West Virginia | 54081 | 4283 | 50 |
998220 | 998220 | 2021-02-04 | Raleigh | West Virginia | 54081 | 4254 | 48 |
994974 | 994974 | 2021-02-03 | Raleigh | West Virginia | 54081 | 4237 | 48 |
991728 | 991728 | 2021-02-02 | Raleigh | West Virginia | 54081 | 4216 | 44 |
988482 | 988482 | 2021-02-01 | Raleigh | West Virginia | 54081 | 4199 | 44 |
985235 | 985235 | 2021-01-31 | Raleigh | West Virginia | 54081 | 4186 | 44 |
981988 | 981988 | 2021-01-30 | Raleigh | West Virginia | 54081 | 4146 | 44 |
978742 | 978742 | 2021-01-29 | Raleigh | West Virginia | 54081 | 4107 | 44 |
975497 | 975497 | 2021-01-28 | Raleigh | West Virginia | 54081 | 4038 | 43 |
972252 | 972252 | 2021-01-27 | Raleigh | West Virginia | 54081 | 4022 | 42 |
969007 | 969007 | 2021-01-26 | Raleigh | West Virginia | 54081 | 3994 | 41 |
965763 | 965763 | 2021-01-25 | Raleigh | West Virginia | 54081 | 3950 | 40 |
962518 | 962518 | 2021-01-24 | Raleigh | West Virginia | 54081 | 3912 | 40 |
959273 | 959273 | 2021-01-23 | Raleigh | West Virginia | 54081 | 3883 | 40 |
956027 | 956027 | 2021-01-22 | Raleigh | West Virginia | 54081 | 3855 | 40 |
952782 | 952782 | 2021-01-21 | Raleigh | West Virginia | 54081 | 3797 | 40 |
949537 | 949537 | 2021-01-20 | Raleigh | West Virginia | 54081 | 3769 | 40 |
946291 | 946291 | 2021-01-19 | Raleigh | West Virginia | 54081 | 3724 | 38 |
943044 | 943044 | 2021-01-18 | Raleigh | West Virginia | 54081 | 3673 | 38 |
939799 | 939799 | 2021-01-17 | Raleigh | West Virginia | 54081 | 3611 | 38 |
936554 | 936554 | 2021-01-16 | Raleigh | West Virginia | 54081 | 3594 | 37 |
933309 | 933309 | 2021-01-15 | Raleigh | West Virginia | 54081 | 3505 | 37 |
930064 | 930064 | 2021-01-14 | Raleigh | West Virginia | 54081 | 3426 | 36 |
926819 | 926819 | 2021-01-13 | Raleigh | West Virginia | 54081 | 3400 | 34 |
923573 | 923573 | 2021-01-12 | Raleigh | West Virginia | 54081 | 3356 | 33 |
920328 | 920328 | 2021-01-11 | Raleigh | West Virginia | 54081 | 3323 | 33 |
917083 | 917083 | 2021-01-10 | Raleigh | West Virginia | 54081 | 3261 | 33 |
913838 | 913838 | 2021-01-09 | Raleigh | West Virginia | 54081 | 3209 | 32 |
910593 | 910593 | 2021-01-08 | Raleigh | West Virginia | 54081 | 3153 | 32 |
907348 | 907348 | 2021-01-07 | Raleigh | West Virginia | 54081 | 3048 | 31 |
904102 | 904102 | 2021-01-06 | Raleigh | West Virginia | 54081 | 3003 | 31 |
900857 | 900857 | 2021-01-05 | Raleigh | West Virginia | 54081 | 2958 | 30 |
897612 | 897612 | 2021-01-04 | Raleigh | West Virginia | 54081 | 2914 | 30 |
894366 | 894366 | 2021-01-03 | Raleigh | West Virginia | 54081 | 2891 | 30 |
891120 | 891120 | 2021-01-02 | Raleigh | West Virginia | 54081 | 2833 | 30 |
887873 | 887873 | 2021-01-01 | Raleigh | West Virginia | 54081 | 2761 | 29 |
884628 | 884628 | 2020-12-31 | Raleigh | West Virginia | 54081 | 2670 | 29 |
881383 | 881383 | 2020-12-30 | Raleigh | West Virginia | 54081 | 2655 | 29 |
878138 | 878138 | 2020-12-29 | Raleigh | West Virginia | 54081 | 2609 | 28 |
874893 | 874893 | 2020-12-28 | Raleigh | West Virginia | 54081 | 2562 | 28 |
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);