ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,114 rows where deaths = 2 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lewis 164
- Marion 151
- Wood 86
- Lincoln 78
- Roane 62
- Preston 58
- Clay 54
- Mingo 53
- Wirt 48
- Randolph 40
- Pleasants 38
- Tyler 38
- Cabell 18
- Braxton 15
- Pendleton 15
- Calhoun 14
- Pocahontas 14
- Wyoming 14
- Morgan 13
- Boone 12
- Mineral 11
- Barbour 10
- McDowell 10
- Doddridge 8
- Hampshire 8
- Putnam 8
- Webster 8
- Harrison 7
- Ritchie 7
- Tucker 7
- …
state 1
- West Virginia · 1,114 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1764483 | 1764483 | 2021-09-28 | Calhoun | West Virginia | 54013 | 805 | 2 |
1761234 | 1761234 | 2021-09-27 | Calhoun | West Virginia | 54013 | 805 | 2 |
1757986 | 1757986 | 2021-09-26 | Calhoun | West Virginia | 54013 | 803 | 2 |
1754738 | 1754738 | 2021-09-25 | Calhoun | West Virginia | 54013 | 798 | 2 |
1751490 | 1751490 | 2021-09-24 | Calhoun | West Virginia | 54013 | 798 | 2 |
1748241 | 1748241 | 2021-09-23 | Calhoun | West Virginia | 54013 | 790 | 2 |
1744991 | 1744991 | 2021-09-22 | Calhoun | West Virginia | 54013 | 788 | 2 |
1741742 | 1741742 | 2021-09-21 | Calhoun | West Virginia | 54013 | 777 | 2 |
1738493 | 1738493 | 2021-09-20 | Calhoun | West Virginia | 54013 | 773 | 2 |
1735244 | 1735244 | 2021-09-19 | Calhoun | West Virginia | 54013 | 770 | 2 |
1731994 | 1731994 | 2021-09-18 | Calhoun | West Virginia | 54013 | 769 | 2 |
1728744 | 1728744 | 2021-09-17 | Calhoun | West Virginia | 54013 | 753 | 2 |
1725494 | 1725494 | 2021-09-16 | Calhoun | West Virginia | 54013 | 741 | 2 |
1722245 | 1722245 | 2021-09-15 | Calhoun | West Virginia | 54013 | 730 | 2 |
1222195 | 1222195 | 2021-04-14 | Braxton | West Virginia | 54007 | 857 | 2 |
1218947 | 1218947 | 2021-04-13 | Braxton | West Virginia | 54007 | 857 | 2 |
1215699 | 1215699 | 2021-04-12 | Braxton | West Virginia | 54007 | 853 | 2 |
1212452 | 1212452 | 2021-04-11 | Braxton | West Virginia | 54007 | 852 | 2 |
1209203 | 1209203 | 2021-04-10 | Braxton | West Virginia | 54007 | 849 | 2 |
1205955 | 1205955 | 2021-04-09 | Braxton | West Virginia | 54007 | 847 | 2 |
1202707 | 1202707 | 2021-04-08 | Braxton | West Virginia | 54007 | 845 | 2 |
1199459 | 1199459 | 2021-04-07 | Braxton | West Virginia | 54007 | 843 | 2 |
1196210 | 1196210 | 2021-04-06 | Braxton | West Virginia | 54007 | 842 | 2 |
1192962 | 1192962 | 2021-04-05 | Braxton | West Virginia | 54007 | 843 | 2 |
1189712 | 1189712 | 2021-04-04 | Braxton | West Virginia | 54007 | 842 | 2 |
1186465 | 1186465 | 2021-04-03 | Braxton | West Virginia | 54007 | 842 | 2 |
1183218 | 1183218 | 2021-04-02 | Braxton | West Virginia | 54007 | 840 | 2 |
1179971 | 1179971 | 2021-04-01 | Braxton | West Virginia | 54007 | 838 | 2 |
1176724 | 1176724 | 2021-03-31 | Braxton | West Virginia | 54007 | 838 | 2 |
1134560 | 1134560 | 2021-03-18 | Wirt | West Virginia | 54105 | 364 | 2 |
1131312 | 1131312 | 2021-03-17 | Wirt | West Virginia | 54105 | 364 | 2 |
1128065 | 1128065 | 2021-03-16 | Wirt | West Virginia | 54105 | 364 | 2 |
1124819 | 1124819 | 2021-03-15 | Wirt | West Virginia | 54105 | 364 | 2 |
1121573 | 1121573 | 2021-03-14 | Wirt | West Virginia | 54105 | 362 | 2 |
1118326 | 1118326 | 2021-03-13 | Wirt | West Virginia | 54105 | 361 | 2 |
1115079 | 1115079 | 2021-03-12 | Wirt | West Virginia | 54105 | 360 | 2 |
1111833 | 1111833 | 2021-03-11 | Wirt | West Virginia | 54105 | 360 | 2 |
1108587 | 1108587 | 2021-03-10 | Wirt | West Virginia | 54105 | 359 | 2 |
1105341 | 1105341 | 2021-03-09 | Wirt | West Virginia | 54105 | 359 | 2 |
1102095 | 1102095 | 2021-03-08 | Wirt | West Virginia | 54105 | 359 | 2 |
1098849 | 1098849 | 2021-03-07 | Wirt | West Virginia | 54105 | 359 | 2 |
1095601 | 1095601 | 2021-03-06 | Wirt | West Virginia | 54105 | 360 | 2 |
1092355 | 1092355 | 2021-03-05 | Wirt | West Virginia | 54105 | 360 | 2 |
1089109 | 1089109 | 2021-03-04 | Wirt | West Virginia | 54105 | 360 | 2 |
1085864 | 1085864 | 2021-03-03 | Wirt | West Virginia | 54105 | 360 | 2 |
1082618 | 1082618 | 2021-03-02 | Wirt | West Virginia | 54105 | 360 | 2 |
1079372 | 1079372 | 2021-03-01 | Wirt | West Virginia | 54105 | 360 | 2 |
1076127 | 1076127 | 2021-02-28 | Wirt | West Virginia | 54105 | 359 | 2 |
1072881 | 1072881 | 2021-02-27 | Wirt | West Virginia | 54105 | 359 | 2 |
1069635 | 1069635 | 2021-02-26 | Wirt | West Virginia | 54105 | 353 | 2 |
1066388 | 1066388 | 2021-02-25 | Webster | West Virginia | 54101 | 308 | 2 |
1066390 | 1066390 | 2021-02-25 | Wirt | West Virginia | 54105 | 351 | 2 |
1063143 | 1063143 | 2021-02-24 | Webster | West Virginia | 54101 | 305 | 2 |
1063145 | 1063145 | 2021-02-24 | Wirt | West Virginia | 54105 | 349 | 2 |
1059898 | 1059898 | 2021-02-23 | Webster | West Virginia | 54101 | 296 | 2 |
1059900 | 1059900 | 2021-02-23 | Wirt | West Virginia | 54105 | 349 | 2 |
1056652 | 1056652 | 2021-02-22 | Webster | West Virginia | 54101 | 294 | 2 |
1056654 | 1056654 | 2021-02-22 | Wirt | West Virginia | 54105 | 348 | 2 |
1053406 | 1053406 | 2021-02-21 | Webster | West Virginia | 54101 | 292 | 2 |
1053408 | 1053408 | 2021-02-21 | Wirt | West Virginia | 54105 | 344 | 2 |
1050159 | 1050159 | 2021-02-20 | Webster | West Virginia | 54101 | 290 | 2 |
1050161 | 1050161 | 2021-02-20 | Wirt | West Virginia | 54105 | 341 | 2 |
1046912 | 1046912 | 2021-02-19 | Webster | West Virginia | 54101 | 289 | 2 |
1046914 | 1046914 | 2021-02-19 | Wirt | West Virginia | 54105 | 341 | 2 |
1043667 | 1043667 | 2021-02-18 | Webster | West Virginia | 54101 | 285 | 2 |
1043669 | 1043669 | 2021-02-18 | Wirt | West Virginia | 54105 | 341 | 2 |
1040424 | 1040424 | 2021-02-17 | Wirt | West Virginia | 54105 | 341 | 2 |
1037179 | 1037179 | 2021-02-16 | Wirt | West Virginia | 54105 | 340 | 2 |
1033934 | 1033934 | 2021-02-15 | Wirt | West Virginia | 54105 | 340 | 2 |
1030688 | 1030688 | 2021-02-14 | Wirt | West Virginia | 54105 | 340 | 2 |
1027441 | 1027441 | 2021-02-13 | Wirt | West Virginia | 54105 | 340 | 2 |
1024196 | 1024196 | 2021-02-12 | Wirt | West Virginia | 54105 | 339 | 2 |
1020951 | 1020951 | 2021-02-11 | Wirt | West Virginia | 54105 | 338 | 2 |
1017706 | 1017706 | 2021-02-10 | Wirt | West Virginia | 54105 | 336 | 2 |
1014461 | 1014461 | 2021-02-09 | Wirt | West Virginia | 54105 | 333 | 2 |
1011216 | 1011216 | 2021-02-08 | Wirt | West Virginia | 54105 | 332 | 2 |
1007970 | 1007970 | 2021-02-07 | Wirt | West Virginia | 54105 | 331 | 2 |
1004724 | 1004724 | 2021-02-06 | Wirt | West Virginia | 54105 | 331 | 2 |
1001478 | 1001478 | 2021-02-05 | Wirt | West Virginia | 54105 | 331 | 2 |
998232 | 998232 | 2021-02-04 | Wirt | West Virginia | 54105 | 331 | 2 |
994986 | 994986 | 2021-02-03 | Wirt | West Virginia | 54105 | 329 | 2 |
991740 | 991740 | 2021-02-02 | Wirt | West Virginia | 54105 | 329 | 2 |
988494 | 988494 | 2021-02-01 | Wirt | West Virginia | 54105 | 328 | 2 |
985247 | 985247 | 2021-01-31 | Wirt | West Virginia | 54105 | 328 | 2 |
982000 | 982000 | 2021-01-30 | Wirt | West Virginia | 54105 | 327 | 2 |
923568 | 923568 | 2021-01-12 | Pendleton | West Virginia | 54071 | 410 | 2 |
920323 | 920323 | 2021-01-11 | Pendleton | West Virginia | 54071 | 405 | 2 |
920335 | 920335 | 2021-01-11 | Tyler | West Virginia | 54095 | 441 | 2 |
917078 | 917078 | 2021-01-10 | Pendleton | West Virginia | 54071 | 392 | 2 |
917090 | 917090 | 2021-01-10 | Tyler | West Virginia | 54095 | 440 | 2 |
913833 | 913833 | 2021-01-09 | Pendleton | West Virginia | 54071 | 388 | 2 |
913845 | 913845 | 2021-01-09 | Tyler | West Virginia | 54095 | 439 | 2 |
910588 | 910588 | 2021-01-08 | Pendleton | West Virginia | 54071 | 384 | 2 |
910600 | 910600 | 2021-01-08 | Tyler | West Virginia | 54095 | 431 | 2 |
907343 | 907343 | 2021-01-07 | Pendleton | West Virginia | 54071 | 365 | 2 |
907355 | 907355 | 2021-01-07 | Tyler | West Virginia | 54095 | 415 | 2 |
904097 | 904097 | 2021-01-06 | Pendleton | West Virginia | 54071 | 351 | 2 |
904109 | 904109 | 2021-01-06 | Tyler | West Virginia | 54095 | 407 | 2 |
900852 | 900852 | 2021-01-05 | Pendleton | West Virginia | 54071 | 344 | 2 |
900864 | 900864 | 2021-01-05 | Tyler | West Virginia | 54095 | 396 | 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);