ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jefferson" and fips = 39081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948501 | 948501 | 2021-01-20 | Jefferson | Ohio | 39081 | 4120 | 67 |
945255 | 945255 | 2021-01-19 | Jefferson | Ohio | 39081 | 4090 | 66 |
942008 | 942008 | 2021-01-18 | Jefferson | Ohio | 39081 | 4045 | 66 |
938763 | 938763 | 2021-01-17 | Jefferson | Ohio | 39081 | 4033 | 66 |
935518 | 935518 | 2021-01-16 | Jefferson | Ohio | 39081 | 4004 | 66 |
932273 | 932273 | 2021-01-15 | Jefferson | Ohio | 39081 | 3948 | 65 |
929028 | 929028 | 2021-01-14 | Jefferson | Ohio | 39081 | 3915 | 65 |
925783 | 925783 | 2021-01-13 | Jefferson | Ohio | 39081 | 3892 | 65 |
922537 | 922537 | 2021-01-12 | Jefferson | Ohio | 39081 | 3846 | 65 |
919292 | 919292 | 2021-01-11 | Jefferson | Ohio | 39081 | 3805 | 64 |
916047 | 916047 | 2021-01-10 | Jefferson | Ohio | 39081 | 3784 | 64 |
912802 | 912802 | 2021-01-09 | Jefferson | Ohio | 39081 | 3742 | 64 |
909557 | 909557 | 2021-01-08 | Jefferson | Ohio | 39081 | 3704 | 60 |
906312 | 906312 | 2021-01-07 | Jefferson | Ohio | 39081 | 3655 | 60 |
903066 | 903066 | 2021-01-06 | Jefferson | Ohio | 39081 | 3604 | 60 |
899821 | 899821 | 2021-01-05 | Jefferson | Ohio | 39081 | 3564 | 59 |
896576 | 896576 | 2021-01-04 | Jefferson | Ohio | 39081 | 3513 | 57 |
893330 | 893330 | 2021-01-03 | Jefferson | Ohio | 39081 | 3493 | 53 |
890084 | 890084 | 2021-01-02 | Jefferson | Ohio | 39081 | 3469 | 53 |
886837 | 886837 | 2021-01-01 | Jefferson | Ohio | 39081 | 3395 | 53 |
883592 | 883592 | 2020-12-31 | Jefferson | Ohio | 39081 | 3395 | 53 |
880347 | 880347 | 2020-12-30 | Jefferson | Ohio | 39081 | 3330 | 53 |
877102 | 877102 | 2020-12-29 | Jefferson | Ohio | 39081 | 3257 | 45 |
873857 | 873857 | 2020-12-28 | Jefferson | Ohio | 39081 | 3228 | 45 |
870612 | 870612 | 2020-12-27 | Jefferson | Ohio | 39081 | 3191 | 44 |
867367 | 867367 | 2020-12-26 | Jefferson | Ohio | 39081 | 3170 | 43 |
864122 | 864122 | 2020-12-25 | Jefferson | Ohio | 39081 | 3132 | 43 |
860877 | 860877 | 2020-12-24 | Jefferson | Ohio | 39081 | 3132 | 43 |
857632 | 857632 | 2020-12-23 | Jefferson | Ohio | 39081 | 3074 | 43 |
854387 | 854387 | 2020-12-22 | Jefferson | Ohio | 39081 | 3001 | 43 |
851142 | 851142 | 2020-12-21 | Jefferson | Ohio | 39081 | 2961 | 42 |
847897 | 847897 | 2020-12-20 | Jefferson | Ohio | 39081 | 2936 | 42 |
844652 | 844652 | 2020-12-19 | Jefferson | Ohio | 39081 | 2886 | 42 |
841406 | 841406 | 2020-12-18 | Jefferson | Ohio | 39081 | 2835 | 41 |
838161 | 838161 | 2020-12-17 | Jefferson | Ohio | 39081 | 2782 | 38 |
834915 | 834915 | 2020-12-16 | Jefferson | Ohio | 39081 | 2712 | 37 |
831669 | 831669 | 2020-12-15 | Jefferson | Ohio | 39081 | 2635 | 34 |
828422 | 828422 | 2020-12-14 | Jefferson | Ohio | 39081 | 2581 | 33 |
825176 | 825176 | 2020-12-13 | Jefferson | Ohio | 39081 | 2503 | 32 |
821929 | 821929 | 2020-12-12 | Jefferson | Ohio | 39081 | 2449 | 32 |
818683 | 818683 | 2020-12-11 | Jefferson | Ohio | 39081 | 2390 | 32 |
815437 | 815437 | 2020-12-10 | Jefferson | Ohio | 39081 | 2301 | 29 |
812191 | 812191 | 2020-12-09 | Jefferson | Ohio | 39081 | 2180 | 26 |
808947 | 808947 | 2020-12-08 | Jefferson | Ohio | 39081 | 2121 | 26 |
805702 | 805702 | 2020-12-07 | Jefferson | Ohio | 39081 | 1958 | 21 |
802457 | 802457 | 2020-12-06 | Jefferson | Ohio | 39081 | 1901 | 16 |
799212 | 799212 | 2020-12-05 | Jefferson | Ohio | 39081 | 1838 | 16 |
795967 | 795967 | 2020-12-04 | Jefferson | Ohio | 39081 | 1770 | 16 |
792722 | 792722 | 2020-12-03 | Jefferson | Ohio | 39081 | 1723 | 16 |
789477 | 789477 | 2020-12-02 | Jefferson | Ohio | 39081 | 1648 | 16 |
786232 | 786232 | 2020-12-01 | Jefferson | Ohio | 39081 | 1585 | 16 |
782988 | 782988 | 2020-11-30 | Jefferson | Ohio | 39081 | 1501 | 15 |
779742 | 779742 | 2020-11-29 | Jefferson | Ohio | 39081 | 1479 | 14 |
776497 | 776497 | 2020-11-28 | Jefferson | Ohio | 39081 | 1439 | 14 |
773252 | 773252 | 2020-11-27 | Jefferson | Ohio | 39081 | 1381 | 13 |
770007 | 770007 | 2020-11-26 | Jefferson | Ohio | 39081 | 1286 | 13 |
766761 | 766761 | 2020-11-25 | Jefferson | Ohio | 39081 | 1286 | 13 |
763516 | 763516 | 2020-11-24 | Jefferson | Ohio | 39081 | 1045 | 12 |
760271 | 760271 | 2020-11-23 | Jefferson | Ohio | 39081 | 1012 | 4 |
757026 | 757026 | 2020-11-22 | Jefferson | Ohio | 39081 | 989 | 4 |
753779 | 753779 | 2020-11-21 | Jefferson | Ohio | 39081 | 973 | 4 |
750533 | 750533 | 2020-11-20 | Jefferson | Ohio | 39081 | 957 | 4 |
747287 | 747287 | 2020-11-19 | Jefferson | Ohio | 39081 | 939 | 4 |
744041 | 744041 | 2020-11-18 | Jefferson | Ohio | 39081 | 903 | 4 |
740794 | 740794 | 2020-11-17 | Jefferson | Ohio | 39081 | 862 | 4 |
737548 | 737548 | 2020-11-16 | Jefferson | Ohio | 39081 | 828 | 4 |
734304 | 734304 | 2020-11-15 | Jefferson | Ohio | 39081 | 805 | 4 |
731058 | 731058 | 2020-11-14 | Jefferson | Ohio | 39081 | 791 | 4 |
727814 | 727814 | 2020-11-13 | Jefferson | Ohio | 39081 | 767 | 4 |
724570 | 724570 | 2020-11-12 | Jefferson | Ohio | 39081 | 745 | 4 |
721327 | 721327 | 2020-11-11 | Jefferson | Ohio | 39081 | 719 | 4 |
718084 | 718084 | 2020-11-10 | Jefferson | Ohio | 39081 | 700 | 4 |
714841 | 714841 | 2020-11-09 | Jefferson | Ohio | 39081 | 672 | 4 |
711597 | 711597 | 2020-11-08 | Jefferson | Ohio | 39081 | 663 | 4 |
708353 | 708353 | 2020-11-07 | Jefferson | Ohio | 39081 | 645 | 4 |
705110 | 705110 | 2020-11-06 | Jefferson | Ohio | 39081 | 630 | 4 |
701867 | 701867 | 2020-11-05 | Jefferson | Ohio | 39081 | 602 | 4 |
698623 | 698623 | 2020-11-04 | Jefferson | Ohio | 39081 | 585 | 4 |
695380 | 695380 | 2020-11-03 | Jefferson | Ohio | 39081 | 573 | 4 |
692138 | 692138 | 2020-11-02 | Jefferson | Ohio | 39081 | 560 | 4 |
688894 | 688894 | 2020-11-01 | Jefferson | Ohio | 39081 | 553 | 4 |
685649 | 685649 | 2020-10-31 | Jefferson | Ohio | 39081 | 543 | 4 |
682406 | 682406 | 2020-10-30 | Jefferson | Ohio | 39081 | 531 | 4 |
679163 | 679163 | 2020-10-29 | Jefferson | Ohio | 39081 | 518 | 4 |
675920 | 675920 | 2020-10-28 | Jefferson | Ohio | 39081 | 509 | 4 |
672677 | 672677 | 2020-10-27 | Jefferson | Ohio | 39081 | 502 | 4 |
669435 | 669435 | 2020-10-26 | Jefferson | Ohio | 39081 | 499 | 4 |
666191 | 666191 | 2020-10-25 | Jefferson | Ohio | 39081 | 494 | 4 |
662946 | 662946 | 2020-10-24 | Jefferson | Ohio | 39081 | 485 | 4 |
659702 | 659702 | 2020-10-23 | Jefferson | Ohio | 39081 | 477 | 4 |
656458 | 656458 | 2020-10-22 | Jefferson | Ohio | 39081 | 469 | 4 |
653213 | 653213 | 2020-10-21 | Jefferson | Ohio | 39081 | 466 | 4 |
649968 | 649968 | 2020-10-20 | Jefferson | Ohio | 39081 | 456 | 4 |
646724 | 646724 | 2020-10-19 | Jefferson | Ohio | 39081 | 447 | 4 |
643478 | 643478 | 2020-10-18 | Jefferson | Ohio | 39081 | 438 | 4 |
640230 | 640230 | 2020-10-17 | Jefferson | Ohio | 39081 | 435 | 4 |
636984 | 636984 | 2020-10-16 | Jefferson | Ohio | 39081 | 432 | 4 |
633738 | 633738 | 2020-10-15 | Jefferson | Ohio | 39081 | 428 | 4 |
630493 | 630493 | 2020-10-14 | Jefferson | Ohio | 39081 | 412 | 4 |
627249 | 627249 | 2020-10-13 | Jefferson | Ohio | 39081 | 406 | 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);