ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Greenbrier" 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 |
---|---|---|---|---|---|---|---|
1056614 | 1056614 | 2021-02-22 | Greenbrier | West Virginia | 54025 | 2375 | 52 |
1053368 | 1053368 | 2021-02-21 | Greenbrier | West Virginia | 54025 | 2374 | 52 |
1050121 | 1050121 | 2021-02-20 | Greenbrier | West Virginia | 54025 | 2371 | 52 |
1046874 | 1046874 | 2021-02-19 | Greenbrier | West Virginia | 54025 | 2371 | 52 |
1043629 | 1043629 | 2021-02-18 | Greenbrier | West Virginia | 54025 | 2369 | 52 |
1040384 | 1040384 | 2021-02-17 | Greenbrier | West Virginia | 54025 | 2368 | 52 |
1037139 | 1037139 | 2021-02-16 | Greenbrier | West Virginia | 54025 | 2364 | 51 |
1033894 | 1033894 | 2021-02-15 | Greenbrier | West Virginia | 54025 | 2362 | 51 |
1030648 | 1030648 | 2021-02-14 | Greenbrier | West Virginia | 54025 | 2356 | 51 |
1027401 | 1027401 | 2021-02-13 | Greenbrier | West Virginia | 54025 | 2354 | 51 |
1024156 | 1024156 | 2021-02-12 | Greenbrier | West Virginia | 54025 | 2349 | 51 |
1020911 | 1020911 | 2021-02-11 | Greenbrier | West Virginia | 54025 | 2341 | 50 |
1017666 | 1017666 | 2021-02-10 | Greenbrier | West Virginia | 54025 | 2329 | 50 |
1014421 | 1014421 | 2021-02-09 | Greenbrier | West Virginia | 54025 | 2328 | 50 |
1011176 | 1011176 | 2021-02-08 | Greenbrier | West Virginia | 54025 | 2326 | 50 |
1007930 | 1007930 | 2021-02-07 | Greenbrier | West Virginia | 54025 | 2317 | 50 |
1004684 | 1004684 | 2021-02-06 | Greenbrier | West Virginia | 54025 | 2309 | 50 |
1001438 | 1001438 | 2021-02-05 | Greenbrier | West Virginia | 54025 | 2301 | 49 |
998192 | 998192 | 2021-02-04 | Greenbrier | West Virginia | 54025 | 2295 | 49 |
994946 | 994946 | 2021-02-03 | Greenbrier | West Virginia | 54025 | 2286 | 49 |
991700 | 991700 | 2021-02-02 | Greenbrier | West Virginia | 54025 | 2268 | 49 |
988454 | 988454 | 2021-02-01 | Greenbrier | West Virginia | 54025 | 2264 | 49 |
985207 | 985207 | 2021-01-31 | Greenbrier | West Virginia | 54025 | 2253 | 49 |
981960 | 981960 | 2021-01-30 | Greenbrier | West Virginia | 54025 | 2236 | 49 |
978714 | 978714 | 2021-01-29 | Greenbrier | West Virginia | 54025 | 2221 | 49 |
975469 | 975469 | 2021-01-28 | Greenbrier | West Virginia | 54025 | 2205 | 49 |
972224 | 972224 | 2021-01-27 | Greenbrier | West Virginia | 54025 | 2187 | 49 |
968979 | 968979 | 2021-01-26 | Greenbrier | West Virginia | 54025 | 2178 | 49 |
965735 | 965735 | 2021-01-25 | Greenbrier | West Virginia | 54025 | 2155 | 47 |
962490 | 962490 | 2021-01-24 | Greenbrier | West Virginia | 54025 | 2143 | 47 |
959245 | 959245 | 2021-01-23 | Greenbrier | West Virginia | 54025 | 2137 | 47 |
955999 | 955999 | 2021-01-22 | Greenbrier | West Virginia | 54025 | 2126 | 47 |
952754 | 952754 | 2021-01-21 | Greenbrier | West Virginia | 54025 | 2100 | 47 |
949509 | 949509 | 2021-01-20 | Greenbrier | West Virginia | 54025 | 2083 | 47 |
946263 | 946263 | 2021-01-19 | Greenbrier | West Virginia | 54025 | 2067 | 47 |
943016 | 943016 | 2021-01-18 | Greenbrier | West Virginia | 54025 | 2056 | 45 |
939771 | 939771 | 2021-01-17 | Greenbrier | West Virginia | 54025 | 2037 | 45 |
936526 | 936526 | 2021-01-16 | Greenbrier | West Virginia | 54025 | 2024 | 45 |
933281 | 933281 | 2021-01-15 | Greenbrier | West Virginia | 54025 | 1978 | 45 |
930036 | 930036 | 2021-01-14 | Greenbrier | West Virginia | 54025 | 1961 | 43 |
926791 | 926791 | 2021-01-13 | Greenbrier | West Virginia | 54025 | 1936 | 43 |
923545 | 923545 | 2021-01-12 | Greenbrier | West Virginia | 54025 | 1914 | 43 |
920300 | 920300 | 2021-01-11 | Greenbrier | West Virginia | 54025 | 1877 | 43 |
917055 | 917055 | 2021-01-10 | Greenbrier | West Virginia | 54025 | 1823 | 43 |
913810 | 913810 | 2021-01-09 | Greenbrier | West Virginia | 54025 | 1790 | 43 |
910565 | 910565 | 2021-01-08 | Greenbrier | West Virginia | 54025 | 1761 | 43 |
907320 | 907320 | 2021-01-07 | Greenbrier | West Virginia | 54025 | 1711 | 41 |
904074 | 904074 | 2021-01-06 | Greenbrier | West Virginia | 54025 | 1677 | 40 |
900829 | 900829 | 2021-01-05 | Greenbrier | West Virginia | 54025 | 1641 | 40 |
897584 | 897584 | 2021-01-04 | Greenbrier | West Virginia | 54025 | 1619 | 36 |
894338 | 894338 | 2021-01-03 | Greenbrier | West Virginia | 54025 | 1612 | 35 |
891092 | 891092 | 2021-01-02 | Greenbrier | West Virginia | 54025 | 1564 | 35 |
887845 | 887845 | 2021-01-01 | Greenbrier | West Virginia | 54025 | 1521 | 35 |
884600 | 884600 | 2020-12-31 | Greenbrier | West Virginia | 54025 | 1469 | 35 |
881355 | 881355 | 2020-12-30 | Greenbrier | West Virginia | 54025 | 1436 | 32 |
878110 | 878110 | 2020-12-29 | Greenbrier | West Virginia | 54025 | 1391 | 31 |
874865 | 874865 | 2020-12-28 | Greenbrier | West Virginia | 54025 | 1368 | 28 |
871620 | 871620 | 2020-12-27 | Greenbrier | West Virginia | 54025 | 1349 | 27 |
868375 | 868375 | 2020-12-26 | Greenbrier | West Virginia | 54025 | 1335 | 27 |
865130 | 865130 | 2020-12-25 | Greenbrier | West Virginia | 54025 | 1294 | 27 |
861885 | 861885 | 2020-12-24 | Greenbrier | West Virginia | 54025 | 1256 | 26 |
858640 | 858640 | 2020-12-23 | Greenbrier | West Virginia | 54025 | 1221 | 24 |
855395 | 855395 | 2020-12-22 | Greenbrier | West Virginia | 54025 | 1194 | 23 |
852150 | 852150 | 2020-12-21 | Greenbrier | West Virginia | 54025 | 1155 | 22 |
848905 | 848905 | 2020-12-20 | Greenbrier | West Virginia | 54025 | 1131 | 22 |
845660 | 845660 | 2020-12-19 | Greenbrier | West Virginia | 54025 | 1087 | 22 |
842414 | 842414 | 2020-12-18 | Greenbrier | West Virginia | 54025 | 1066 | 20 |
839169 | 839169 | 2020-12-17 | Greenbrier | West Virginia | 54025 | 1025 | 18 |
835924 | 835924 | 2020-12-16 | Greenbrier | West Virginia | 54025 | 963 | 18 |
832678 | 832678 | 2020-12-15 | Greenbrier | West Virginia | 54025 | 945 | 17 |
829431 | 829431 | 2020-12-14 | Greenbrier | West Virginia | 54025 | 924 | 16 |
826185 | 826185 | 2020-12-13 | Greenbrier | West Virginia | 54025 | 872 | 16 |
822938 | 822938 | 2020-12-12 | Greenbrier | West Virginia | 54025 | 836 | 16 |
819692 | 819692 | 2020-12-11 | Greenbrier | West Virginia | 54025 | 792 | 14 |
816446 | 816446 | 2020-12-10 | Greenbrier | West Virginia | 54025 | 772 | 14 |
813200 | 813200 | 2020-12-09 | Greenbrier | West Virginia | 54025 | 721 | 12 |
809956 | 809956 | 2020-12-08 | Greenbrier | West Virginia | 54025 | 707 | 12 |
806711 | 806711 | 2020-12-07 | Greenbrier | West Virginia | 54025 | 681 | 9 |
803466 | 803466 | 2020-12-06 | Greenbrier | West Virginia | 54025 | 659 | 9 |
800221 | 800221 | 2020-12-05 | Greenbrier | West Virginia | 54025 | 625 | 8 |
796976 | 796976 | 2020-12-04 | Greenbrier | West Virginia | 54025 | 592 | 10 |
793731 | 793731 | 2020-12-03 | Greenbrier | West Virginia | 54025 | 571 | 9 |
790486 | 790486 | 2020-12-02 | Greenbrier | West Virginia | 54025 | 552 | 8 |
787241 | 787241 | 2020-12-01 | Greenbrier | West Virginia | 54025 | 534 | 7 |
783997 | 783997 | 2020-11-30 | Greenbrier | West Virginia | 54025 | 516 | 7 |
780752 | 780752 | 2020-11-29 | Greenbrier | West Virginia | 54025 | 499 | 7 |
777506 | 777506 | 2020-11-28 | Greenbrier | West Virginia | 54025 | 475 | 6 |
774261 | 774261 | 2020-11-27 | Greenbrier | West Virginia | 54025 | 462 | 6 |
771016 | 771016 | 2020-11-26 | Greenbrier | West Virginia | 54025 | 432 | 7 |
767770 | 767770 | 2020-11-25 | Greenbrier | West Virginia | 54025 | 414 | 7 |
764525 | 764525 | 2020-11-24 | Greenbrier | West Virginia | 54025 | 412 | 6 |
761280 | 761280 | 2020-11-23 | Greenbrier | West Virginia | 54025 | 396 | 6 |
758035 | 758035 | 2020-11-22 | Greenbrier | West Virginia | 54025 | 381 | 6 |
754788 | 754788 | 2020-11-21 | Greenbrier | West Virginia | 54025 | 373 | 6 |
751542 | 751542 | 2020-11-20 | Greenbrier | West Virginia | 54025 | 361 | 6 |
748296 | 748296 | 2020-11-19 | Greenbrier | West Virginia | 54025 | 344 | 6 |
745050 | 745050 | 2020-11-18 | Greenbrier | West Virginia | 54025 | 336 | 6 |
741803 | 741803 | 2020-11-17 | Greenbrier | West Virginia | 54025 | 330 | 6 |
738556 | 738556 | 2020-11-16 | Greenbrier | West Virginia | 54025 | 319 | 6 |
735312 | 735312 | 2020-11-15 | Greenbrier | West Virginia | 54025 | 308 | 6 |
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);