ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Jefferson" and fips = 42065 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1072027 | 1072027 | 2021-02-27 | Jefferson | Pennsylvania | 42065 | 2780 | 89 |
1068781 | 1068781 | 2021-02-26 | Jefferson | Pennsylvania | 42065 | 2778 | 89 |
1065536 | 1065536 | 2021-02-25 | Jefferson | Pennsylvania | 42065 | 2774 | 89 |
1062291 | 1062291 | 2021-02-24 | Jefferson | Pennsylvania | 42065 | 2774 | 87 |
1059046 | 1059046 | 2021-02-23 | Jefferson | Pennsylvania | 42065 | 2768 | 86 |
1055800 | 1055800 | 2021-02-22 | Jefferson | Pennsylvania | 42065 | 2757 | 86 |
1052554 | 1052554 | 2021-02-21 | Jefferson | Pennsylvania | 42065 | 2755 | 86 |
1049307 | 1049307 | 2021-02-20 | Jefferson | Pennsylvania | 42065 | 2745 | 86 |
1046060 | 1046060 | 2021-02-19 | Jefferson | Pennsylvania | 42065 | 2740 | 85 |
1042815 | 1042815 | 2021-02-18 | Jefferson | Pennsylvania | 42065 | 2724 | 85 |
1039570 | 1039570 | 2021-02-17 | Jefferson | Pennsylvania | 42065 | 2721 | 84 |
1036325 | 1036325 | 2021-02-16 | Jefferson | Pennsylvania | 42065 | 2711 | 83 |
1033080 | 1033080 | 2021-02-15 | Jefferson | Pennsylvania | 42065 | 2704 | 83 |
1029834 | 1029834 | 2021-02-14 | Jefferson | Pennsylvania | 42065 | 2700 | 83 |
1026587 | 1026587 | 2021-02-13 | Jefferson | Pennsylvania | 42065 | 2692 | 83 |
1023342 | 1023342 | 2021-02-12 | Jefferson | Pennsylvania | 42065 | 2684 | 83 |
1020097 | 1020097 | 2021-02-11 | Jefferson | Pennsylvania | 42065 | 2677 | 82 |
1016852 | 1016852 | 2021-02-10 | Jefferson | Pennsylvania | 42065 | 2665 | 82 |
1013607 | 1013607 | 2021-02-09 | Jefferson | Pennsylvania | 42065 | 2654 | 82 |
1010362 | 1010362 | 2021-02-08 | Jefferson | Pennsylvania | 42065 | 2645 | 81 |
1007116 | 1007116 | 2021-02-07 | Jefferson | Pennsylvania | 42065 | 2640 | 80 |
1003870 | 1003870 | 2021-02-06 | Jefferson | Pennsylvania | 42065 | 2632 | 79 |
1000624 | 1000624 | 2021-02-05 | Jefferson | Pennsylvania | 42065 | 2621 | 78 |
997378 | 997378 | 2021-02-04 | Jefferson | Pennsylvania | 42065 | 2581 | 77 |
994132 | 994132 | 2021-02-03 | Jefferson | Pennsylvania | 42065 | 2564 | 77 |
990886 | 990886 | 2021-02-02 | Jefferson | Pennsylvania | 42065 | 2555 | 75 |
987640 | 987640 | 2021-02-01 | Jefferson | Pennsylvania | 42065 | 2539 | 75 |
984393 | 984393 | 2021-01-31 | Jefferson | Pennsylvania | 42065 | 2530 | 75 |
981146 | 981146 | 2021-01-30 | Jefferson | Pennsylvania | 42065 | 2520 | 75 |
977900 | 977900 | 2021-01-29 | Jefferson | Pennsylvania | 42065 | 2493 | 74 |
974655 | 974655 | 2021-01-28 | Jefferson | Pennsylvania | 42065 | 2479 | 73 |
971410 | 971410 | 2021-01-27 | Jefferson | Pennsylvania | 42065 | 2465 | 72 |
968165 | 968165 | 2021-01-26 | Jefferson | Pennsylvania | 42065 | 2444 | 71 |
964921 | 964921 | 2021-01-25 | Jefferson | Pennsylvania | 42065 | 2427 | 70 |
961676 | 961676 | 2021-01-24 | Jefferson | Pennsylvania | 42065 | 2415 | 69 |
958431 | 958431 | 2021-01-23 | Jefferson | Pennsylvania | 42065 | 2398 | 69 |
955185 | 955185 | 2021-01-22 | Jefferson | Pennsylvania | 42065 | 2377 | 69 |
951940 | 951940 | 2021-01-21 | Jefferson | Pennsylvania | 42065 | 2359 | 66 |
948695 | 948695 | 2021-01-20 | Jefferson | Pennsylvania | 42065 | 2331 | 65 |
945449 | 945449 | 2021-01-19 | Jefferson | Pennsylvania | 42065 | 2312 | 63 |
942202 | 942202 | 2021-01-18 | Jefferson | Pennsylvania | 42065 | 2294 | 62 |
938957 | 938957 | 2021-01-17 | Jefferson | Pennsylvania | 42065 | 2272 | 61 |
935712 | 935712 | 2021-01-16 | Jefferson | Pennsylvania | 42065 | 2261 | 60 |
932467 | 932467 | 2021-01-15 | Jefferson | Pennsylvania | 42065 | 2228 | 58 |
929222 | 929222 | 2021-01-14 | Jefferson | Pennsylvania | 42065 | 2206 | 57 |
925977 | 925977 | 2021-01-13 | Jefferson | Pennsylvania | 42065 | 2188 | 56 |
922731 | 922731 | 2021-01-12 | Jefferson | Pennsylvania | 42065 | 2171 | 55 |
919486 | 919486 | 2021-01-11 | Jefferson | Pennsylvania | 42065 | 2156 | 55 |
916241 | 916241 | 2021-01-10 | Jefferson | Pennsylvania | 42065 | 2145 | 54 |
912996 | 912996 | 2021-01-09 | Jefferson | Pennsylvania | 42065 | 2124 | 54 |
909751 | 909751 | 2021-01-08 | Jefferson | Pennsylvania | 42065 | 2097 | 50 |
906506 | 906506 | 2021-01-07 | Jefferson | Pennsylvania | 42065 | 2062 | 50 |
903260 | 903260 | 2021-01-06 | Jefferson | Pennsylvania | 42065 | 2031 | 50 |
900015 | 900015 | 2021-01-05 | Jefferson | Pennsylvania | 42065 | 1990 | 47 |
896770 | 896770 | 2021-01-04 | Jefferson | Pennsylvania | 42065 | 1968 | 46 |
893524 | 893524 | 2021-01-03 | Jefferson | Pennsylvania | 42065 | 1951 | 46 |
890278 | 890278 | 2021-01-02 | Jefferson | Pennsylvania | 42065 | 1934 | 45 |
887031 | 887031 | 2021-01-01 | Jefferson | Pennsylvania | 42065 | 1905 | 45 |
883786 | 883786 | 2020-12-31 | Jefferson | Pennsylvania | 42065 | 1888 | 43 |
880541 | 880541 | 2020-12-30 | Jefferson | Pennsylvania | 42065 | 1872 | 42 |
877296 | 877296 | 2020-12-29 | Jefferson | Pennsylvania | 42065 | 1832 | 40 |
874051 | 874051 | 2020-12-28 | Jefferson | Pennsylvania | 42065 | 1812 | 36 |
870806 | 870806 | 2020-12-27 | Jefferson | Pennsylvania | 42065 | 1801 | 35 |
867561 | 867561 | 2020-12-26 | Jefferson | Pennsylvania | 42065 | 1794 | 35 |
864316 | 864316 | 2020-12-25 | Jefferson | Pennsylvania | 42065 | 1773 | 35 |
861071 | 861071 | 2020-12-24 | Jefferson | Pennsylvania | 42065 | 1760 | 32 |
857826 | 857826 | 2020-12-23 | Jefferson | Pennsylvania | 42065 | 1711 | 31 |
854581 | 854581 | 2020-12-22 | Jefferson | Pennsylvania | 42065 | 1686 | 27 |
851336 | 851336 | 2020-12-21 | Jefferson | Pennsylvania | 42065 | 1649 | 26 |
848091 | 848091 | 2020-12-20 | Jefferson | Pennsylvania | 42065 | 1618 | 26 |
844846 | 844846 | 2020-12-19 | Jefferson | Pennsylvania | 42065 | 1593 | 26 |
841600 | 841600 | 2020-12-18 | Jefferson | Pennsylvania | 42065 | 1560 | 25 |
838355 | 838355 | 2020-12-17 | Jefferson | Pennsylvania | 42065 | 1534 | 24 |
835109 | 835109 | 2020-12-16 | Jefferson | Pennsylvania | 42065 | 1508 | 20 |
831863 | 831863 | 2020-12-15 | Jefferson | Pennsylvania | 42065 | 1472 | 18 |
828616 | 828616 | 2020-12-14 | Jefferson | Pennsylvania | 42065 | 1438 | 18 |
825370 | 825370 | 2020-12-13 | Jefferson | Pennsylvania | 42065 | 1404 | 18 |
822123 | 822123 | 2020-12-12 | Jefferson | Pennsylvania | 42065 | 1385 | 15 |
818877 | 818877 | 2020-12-11 | Jefferson | Pennsylvania | 42065 | 1331 | 11 |
815631 | 815631 | 2020-12-10 | Jefferson | Pennsylvania | 42065 | 1278 | 9 |
812385 | 812385 | 2020-12-09 | Jefferson | Pennsylvania | 42065 | 1243 | 9 |
809141 | 809141 | 2020-12-08 | Jefferson | Pennsylvania | 42065 | 1188 | 9 |
805896 | 805896 | 2020-12-07 | Jefferson | Pennsylvania | 42065 | 1111 | 9 |
802651 | 802651 | 2020-12-06 | Jefferson | Pennsylvania | 42065 | 1071 | 9 |
799406 | 799406 | 2020-12-05 | Jefferson | Pennsylvania | 42065 | 1039 | 7 |
796161 | 796161 | 2020-12-04 | Jefferson | Pennsylvania | 42065 | 984 | 7 |
792916 | 792916 | 2020-12-03 | Jefferson | Pennsylvania | 42065 | 938 | 7 |
789671 | 789671 | 2020-12-02 | Jefferson | Pennsylvania | 42065 | 885 | 7 |
786426 | 786426 | 2020-12-01 | Jefferson | Pennsylvania | 42065 | 849 | 6 |
783182 | 783182 | 2020-11-30 | Jefferson | Pennsylvania | 42065 | 791 | 6 |
779937 | 779937 | 2020-11-29 | Jefferson | Pennsylvania | 42065 | 754 | 6 |
776691 | 776691 | 2020-11-28 | Jefferson | Pennsylvania | 42065 | 728 | 6 |
773446 | 773446 | 2020-11-27 | Jefferson | Pennsylvania | 42065 | 694 | 6 |
770201 | 770201 | 2020-11-26 | Jefferson | Pennsylvania | 42065 | 669 | 6 |
766955 | 766955 | 2020-11-25 | Jefferson | Pennsylvania | 42065 | 644 | 6 |
763710 | 763710 | 2020-11-24 | Jefferson | Pennsylvania | 42065 | 609 | 6 |
760465 | 760465 | 2020-11-23 | Jefferson | Pennsylvania | 42065 | 589 | 5 |
757220 | 757220 | 2020-11-22 | Jefferson | Pennsylvania | 42065 | 561 | 5 |
753973 | 753973 | 2020-11-21 | Jefferson | Pennsylvania | 42065 | 538 | 5 |
750727 | 750727 | 2020-11-20 | Jefferson | Pennsylvania | 42065 | 521 | 4 |
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);