ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Fayette" and fips = 54019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056611 | 1056611 | 2021-02-22 | Fayette | West Virginia | 54019 | 2609 | 70 |
1053365 | 1053365 | 2021-02-21 | Fayette | West Virginia | 54019 | 2605 | 70 |
1050118 | 1050118 | 2021-02-20 | Fayette | West Virginia | 54019 | 2596 | 70 |
1046871 | 1046871 | 2021-02-19 | Fayette | West Virginia | 54019 | 2587 | 69 |
1043626 | 1043626 | 2021-02-18 | Fayette | West Virginia | 54019 | 2578 | 68 |
1040381 | 1040381 | 2021-02-17 | Fayette | West Virginia | 54019 | 2576 | 68 |
1037136 | 1037136 | 2021-02-16 | Fayette | West Virginia | 54019 | 2568 | 67 |
1033891 | 1033891 | 2021-02-15 | Fayette | West Virginia | 54019 | 2566 | 67 |
1030645 | 1030645 | 2021-02-14 | Fayette | West Virginia | 54019 | 2556 | 67 |
1027398 | 1027398 | 2021-02-13 | Fayette | West Virginia | 54019 | 2545 | 67 |
1024153 | 1024153 | 2021-02-12 | Fayette | West Virginia | 54019 | 2533 | 67 |
1020908 | 1020908 | 2021-02-11 | Fayette | West Virginia | 54019 | 2526 | 66 |
1017663 | 1017663 | 2021-02-10 | Fayette | West Virginia | 54019 | 2519 | 66 |
1014418 | 1014418 | 2021-02-09 | Fayette | West Virginia | 54019 | 2514 | 66 |
1011173 | 1011173 | 2021-02-08 | Fayette | West Virginia | 54019 | 2507 | 66 |
1007927 | 1007927 | 2021-02-07 | Fayette | West Virginia | 54019 | 2497 | 66 |
1004681 | 1004681 | 2021-02-06 | Fayette | West Virginia | 54019 | 2478 | 66 |
1001435 | 1001435 | 2021-02-05 | Fayette | West Virginia | 54019 | 2468 | 66 |
998189 | 998189 | 2021-02-04 | Fayette | West Virginia | 54019 | 2447 | 66 |
994943 | 994943 | 2021-02-03 | Fayette | West Virginia | 54019 | 2432 | 66 |
991697 | 991697 | 2021-02-02 | Fayette | West Virginia | 54019 | 2417 | 66 |
988451 | 988451 | 2021-02-01 | Fayette | West Virginia | 54019 | 2398 | 66 |
985204 | 985204 | 2021-01-31 | Fayette | West Virginia | 54019 | 2388 | 65 |
981957 | 981957 | 2021-01-30 | Fayette | West Virginia | 54019 | 2376 | 65 |
978711 | 978711 | 2021-01-29 | Fayette | West Virginia | 54019 | 2353 | 65 |
975466 | 975466 | 2021-01-28 | Fayette | West Virginia | 54019 | 2341 | 65 |
972221 | 972221 | 2021-01-27 | Fayette | West Virginia | 54019 | 2334 | 64 |
968976 | 968976 | 2021-01-26 | Fayette | West Virginia | 54019 | 2321 | 64 |
965732 | 965732 | 2021-01-25 | Fayette | West Virginia | 54019 | 2298 | 63 |
962487 | 962487 | 2021-01-24 | Fayette | West Virginia | 54019 | 2293 | 61 |
959242 | 959242 | 2021-01-23 | Fayette | West Virginia | 54019 | 2274 | 61 |
955996 | 955996 | 2021-01-22 | Fayette | West Virginia | 54019 | 2230 | 61 |
952751 | 952751 | 2021-01-21 | Fayette | West Virginia | 54019 | 2218 | 61 |
949506 | 949506 | 2021-01-20 | Fayette | West Virginia | 54019 | 2204 | 61 |
946260 | 946260 | 2021-01-19 | Fayette | West Virginia | 54019 | 2181 | 58 |
943013 | 943013 | 2021-01-18 | Fayette | West Virginia | 54019 | 2167 | 57 |
939768 | 939768 | 2021-01-17 | Fayette | West Virginia | 54019 | 2151 | 57 |
936523 | 936523 | 2021-01-16 | Fayette | West Virginia | 54019 | 2143 | 56 |
933278 | 933278 | 2021-01-15 | Fayette | West Virginia | 54019 | 2116 | 55 |
930033 | 930033 | 2021-01-14 | Fayette | West Virginia | 54019 | 2085 | 55 |
926788 | 926788 | 2021-01-13 | Fayette | West Virginia | 54019 | 2079 | 55 |
923542 | 923542 | 2021-01-12 | Fayette | West Virginia | 54019 | 2063 | 55 |
920297 | 920297 | 2021-01-11 | Fayette | West Virginia | 54019 | 2052 | 55 |
917052 | 917052 | 2021-01-10 | Fayette | West Virginia | 54019 | 2031 | 53 |
913807 | 913807 | 2021-01-09 | Fayette | West Virginia | 54019 | 2008 | 53 |
910562 | 910562 | 2021-01-08 | Fayette | West Virginia | 54019 | 1970 | 53 |
907317 | 907317 | 2021-01-07 | Fayette | West Virginia | 54019 | 1941 | 53 |
904071 | 904071 | 2021-01-06 | Fayette | West Virginia | 54019 | 1913 | 51 |
900826 | 900826 | 2021-01-05 | Fayette | West Virginia | 54019 | 1904 | 50 |
897581 | 897581 | 2021-01-04 | Fayette | West Virginia | 54019 | 1884 | 48 |
894335 | 894335 | 2021-01-03 | Fayette | West Virginia | 54019 | 1865 | 48 |
891089 | 891089 | 2021-01-02 | Fayette | West Virginia | 54019 | 1838 | 48 |
887842 | 887842 | 2021-01-01 | Fayette | West Virginia | 54019 | 1784 | 48 |
884597 | 884597 | 2020-12-31 | Fayette | West Virginia | 54019 | 1711 | 48 |
881352 | 881352 | 2020-12-30 | Fayette | West Virginia | 54019 | 1695 | 48 |
878107 | 878107 | 2020-12-29 | Fayette | West Virginia | 54019 | 1689 | 47 |
874862 | 874862 | 2020-12-28 | Fayette | West Virginia | 54019 | 1673 | 47 |
871617 | 871617 | 2020-12-27 | Fayette | West Virginia | 54019 | 1657 | 47 |
868372 | 868372 | 2020-12-26 | Fayette | West Virginia | 54019 | 1647 | 47 |
865127 | 865127 | 2020-12-25 | Fayette | West Virginia | 54019 | 1629 | 47 |
861882 | 861882 | 2020-12-24 | Fayette | West Virginia | 54019 | 1581 | 47 |
858637 | 858637 | 2020-12-23 | Fayette | West Virginia | 54019 | 1562 | 44 |
855392 | 855392 | 2020-12-22 | Fayette | West Virginia | 54019 | 1536 | 44 |
852147 | 852147 | 2020-12-21 | Fayette | West Virginia | 54019 | 1515 | 42 |
848902 | 848902 | 2020-12-20 | Fayette | West Virginia | 54019 | 1495 | 42 |
845657 | 845657 | 2020-12-19 | Fayette | West Virginia | 54019 | 1477 | 41 |
842411 | 842411 | 2020-12-18 | Fayette | West Virginia | 54019 | 1448 | 40 |
839166 | 839166 | 2020-12-17 | Fayette | West Virginia | 54019 | 1429 | 40 |
835921 | 835921 | 2020-12-16 | Fayette | West Virginia | 54019 | 1407 | 40 |
832675 | 832675 | 2020-12-15 | Fayette | West Virginia | 54019 | 1399 | 40 |
829428 | 829428 | 2020-12-14 | Fayette | West Virginia | 54019 | 1377 | 39 |
826182 | 826182 | 2020-12-13 | Fayette | West Virginia | 54019 | 1366 | 39 |
822935 | 822935 | 2020-12-12 | Fayette | West Virginia | 54019 | 1352 | 39 |
819689 | 819689 | 2020-12-11 | Fayette | West Virginia | 54019 | 1328 | 39 |
816443 | 816443 | 2020-12-10 | Fayette | West Virginia | 54019 | 1303 | 39 |
813197 | 813197 | 2020-12-09 | Fayette | West Virginia | 54019 | 1284 | 39 |
809953 | 809953 | 2020-12-08 | Fayette | West Virginia | 54019 | 1272 | 39 |
806708 | 806708 | 2020-12-07 | Fayette | West Virginia | 54019 | 1268 | 39 |
803463 | 803463 | 2020-12-06 | Fayette | West Virginia | 54019 | 1257 | 39 |
800218 | 800218 | 2020-12-05 | Fayette | West Virginia | 54019 | 1241 | 38 |
796973 | 796973 | 2020-12-04 | Fayette | West Virginia | 54019 | 1226 | 35 |
793728 | 793728 | 2020-12-03 | Fayette | West Virginia | 54019 | 1203 | 35 |
790483 | 790483 | 2020-12-02 | Fayette | West Virginia | 54019 | 1190 | 35 |
787238 | 787238 | 2020-12-01 | Fayette | West Virginia | 54019 | 1177 | 35 |
783994 | 783994 | 2020-11-30 | Fayette | West Virginia | 54019 | 1172 | 34 |
780749 | 780749 | 2020-11-29 | Fayette | West Virginia | 54019 | 1154 | 34 |
777503 | 777503 | 2020-11-28 | Fayette | West Virginia | 54019 | 1131 | 34 |
774258 | 774258 | 2020-11-27 | Fayette | West Virginia | 54019 | 1111 | 34 |
771013 | 771013 | 2020-11-26 | Fayette | West Virginia | 54019 | 1094 | 34 |
767767 | 767767 | 2020-11-25 | Fayette | West Virginia | 54019 | 1076 | 34 |
764522 | 764522 | 2020-11-24 | Fayette | West Virginia | 54019 | 1065 | 34 |
761277 | 761277 | 2020-11-23 | Fayette | West Virginia | 54019 | 1056 | 33 |
758032 | 758032 | 2020-11-22 | Fayette | West Virginia | 54019 | 1049 | 33 |
754785 | 754785 | 2020-11-21 | Fayette | West Virginia | 54019 | 1040 | 33 |
751539 | 751539 | 2020-11-20 | Fayette | West Virginia | 54019 | 1023 | 32 |
748293 | 748293 | 2020-11-19 | Fayette | West Virginia | 54019 | 997 | 31 |
745047 | 745047 | 2020-11-18 | Fayette | West Virginia | 54019 | 987 | 31 |
741800 | 741800 | 2020-11-17 | Fayette | West Virginia | 54019 | 969 | 31 |
738553 | 738553 | 2020-11-16 | Fayette | West Virginia | 54019 | 959 | 30 |
735309 | 735309 | 2020-11-15 | Fayette | West Virginia | 54019 | 950 | 30 |
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);