ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Jefferson" and fips = 12065 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946754 | 946754 | 2021-01-20 | Jefferson | Florida | 12065 | 1210 | 18 |
943507 | 943507 | 2021-01-19 | Jefferson | Florida | 12065 | 1199 | 18 |
940262 | 940262 | 2021-01-18 | Jefferson | Florida | 12065 | 1193 | 18 |
937017 | 937017 | 2021-01-17 | Jefferson | Florida | 12065 | 1191 | 18 |
933772 | 933772 | 2021-01-16 | Jefferson | Florida | 12065 | 1176 | 18 |
930527 | 930527 | 2021-01-15 | Jefferson | Florida | 12065 | 1170 | 18 |
927282 | 927282 | 2021-01-14 | Jefferson | Florida | 12065 | 1160 | 18 |
924036 | 924036 | 2021-01-13 | Jefferson | Florida | 12065 | 1151 | 18 |
920791 | 920791 | 2021-01-12 | Jefferson | Florida | 12065 | 1141 | 18 |
917546 | 917546 | 2021-01-11 | Jefferson | Florida | 12065 | 1127 | 18 |
914301 | 914301 | 2021-01-10 | Jefferson | Florida | 12065 | 1126 | 18 |
911056 | 911056 | 2021-01-09 | Jefferson | Florida | 12065 | 1111 | 18 |
907811 | 907811 | 2021-01-08 | Jefferson | Florida | 12065 | 1105 | 18 |
904565 | 904565 | 2021-01-07 | Jefferson | Florida | 12065 | 1090 | 18 |
901320 | 901320 | 2021-01-06 | Jefferson | Florida | 12065 | 1077 | 18 |
898075 | 898075 | 2021-01-05 | Jefferson | Florida | 12065 | 1055 | 18 |
894830 | 894830 | 2021-01-04 | Jefferson | Florida | 12065 | 1040 | 17 |
891583 | 891583 | 2021-01-03 | Jefferson | Florida | 12065 | 1036 | 17 |
888336 | 888336 | 2021-01-02 | Jefferson | Florida | 12065 | 1032 | 17 |
885091 | 885091 | 2021-01-01 | Jefferson | Florida | 12065 | 994 | 16 |
881846 | 881846 | 2020-12-31 | Jefferson | Florida | 12065 | 994 | 16 |
878601 | 878601 | 2020-12-30 | Jefferson | Florida | 12065 | 981 | 16 |
875356 | 875356 | 2020-12-29 | Jefferson | Florida | 12065 | 971 | 16 |
872111 | 872111 | 2020-12-28 | Jefferson | Florida | 12065 | 957 | 16 |
868866 | 868866 | 2020-12-27 | Jefferson | Florida | 12065 | 955 | 16 |
865621 | 865621 | 2020-12-26 | Jefferson | Florida | 12065 | 945 | 16 |
862376 | 862376 | 2020-12-25 | Jefferson | Florida | 12065 | 909 | 16 |
859131 | 859131 | 2020-12-24 | Jefferson | Florida | 12065 | 909 | 16 |
855886 | 855886 | 2020-12-23 | Jefferson | Florida | 12065 | 905 | 16 |
852641 | 852641 | 2020-12-22 | Jefferson | Florida | 12065 | 897 | 15 |
849396 | 849396 | 2020-12-21 | Jefferson | Florida | 12065 | 890 | 15 |
846151 | 846151 | 2020-12-20 | Jefferson | Florida | 12065 | 885 | 14 |
842905 | 842905 | 2020-12-19 | Jefferson | Florida | 12065 | 875 | 14 |
839660 | 839660 | 2020-12-18 | Jefferson | Florida | 12065 | 872 | 14 |
836415 | 836415 | 2020-12-17 | Jefferson | Florida | 12065 | 864 | 14 |
833169 | 833169 | 2020-12-16 | Jefferson | Florida | 12065 | 856 | 13 |
829922 | 829922 | 2020-12-15 | Jefferson | Florida | 12065 | 848 | 12 |
826676 | 826676 | 2020-12-14 | Jefferson | Florida | 12065 | 842 | 12 |
823429 | 823429 | 2020-12-13 | Jefferson | Florida | 12065 | 836 | 12 |
820183 | 820183 | 2020-12-12 | Jefferson | Florida | 12065 | 833 | 12 |
816937 | 816937 | 2020-12-11 | Jefferson | Florida | 12065 | 826 | 12 |
813691 | 813691 | 2020-12-10 | Jefferson | Florida | 12065 | 816 | 12 |
810447 | 810447 | 2020-12-09 | Jefferson | Florida | 12065 | 815 | 12 |
807202 | 807202 | 2020-12-08 | Jefferson | Florida | 12065 | 810 | 12 |
803957 | 803957 | 2020-12-07 | Jefferson | Florida | 12065 | 803 | 12 |
800712 | 800712 | 2020-12-06 | Jefferson | Florida | 12065 | 802 | 12 |
797467 | 797467 | 2020-12-05 | Jefferson | Florida | 12065 | 802 | 12 |
794222 | 794222 | 2020-12-04 | Jefferson | Florida | 12065 | 799 | 12 |
790977 | 790977 | 2020-12-03 | Jefferson | Florida | 12065 | 792 | 11 |
787732 | 787732 | 2020-12-02 | Jefferson | Florida | 12065 | 789 | 11 |
784488 | 784488 | 2020-12-01 | Jefferson | Florida | 12065 | 785 | 11 |
781243 | 781243 | 2020-11-30 | Jefferson | Florida | 12065 | 774 | 11 |
777997 | 777997 | 2020-11-29 | Jefferson | Florida | 12065 | 773 | 11 |
774752 | 774752 | 2020-11-28 | Jefferson | Florida | 12065 | 770 | 11 |
771507 | 771507 | 2020-11-27 | Jefferson | Florida | 12065 | 764 | 11 |
768262 | 768262 | 2020-11-26 | Jefferson | Florida | 12065 | 750 | 11 |
765016 | 765016 | 2020-11-25 | Jefferson | Florida | 12065 | 750 | 11 |
761771 | 761771 | 2020-11-24 | Jefferson | Florida | 12065 | 743 | 11 |
758526 | 758526 | 2020-11-23 | Jefferson | Florida | 12065 | 739 | 11 |
755279 | 755279 | 2020-11-22 | Jefferson | Florida | 12065 | 736 | 11 |
752033 | 752033 | 2020-11-21 | Jefferson | Florida | 12065 | 736 | 11 |
748787 | 748787 | 2020-11-20 | Jefferson | Florida | 12065 | 730 | 11 |
745541 | 745541 | 2020-11-19 | Jefferson | Florida | 12065 | 728 | 11 |
742294 | 742294 | 2020-11-18 | Jefferson | Florida | 12065 | 725 | 11 |
739047 | 739047 | 2020-11-17 | Jefferson | Florida | 12065 | 724 | 11 |
735803 | 735803 | 2020-11-16 | Jefferson | Florida | 12065 | 718 | 11 |
732557 | 732557 | 2020-11-15 | Jefferson | Florida | 12065 | 718 | 11 |
729312 | 729312 | 2020-11-14 | Jefferson | Florida | 12065 | 717 | 11 |
726069 | 726069 | 2020-11-13 | Jefferson | Florida | 12065 | 717 | 11 |
722826 | 722826 | 2020-11-12 | Jefferson | Florida | 12065 | 715 | 11 |
719583 | 719583 | 2020-11-11 | Jefferson | Florida | 12065 | 715 | 11 |
716340 | 716340 | 2020-11-10 | Jefferson | Florida | 12065 | 714 | 11 |
713096 | 713096 | 2020-11-09 | Jefferson | Florida | 12065 | 711 | 11 |
709852 | 709852 | 2020-11-08 | Jefferson | Florida | 12065 | 705 | 11 |
706608 | 706608 | 2020-11-07 | Jefferson | Florida | 12065 | 702 | 11 |
703365 | 703365 | 2020-11-06 | Jefferson | Florida | 12065 | 700 | 11 |
700122 | 700122 | 2020-11-05 | Jefferson | Florida | 12065 | 696 | 11 |
696878 | 696878 | 2020-11-04 | Jefferson | Florida | 12065 | 689 | 11 |
693636 | 693636 | 2020-11-03 | Jefferson | Florida | 12065 | 683 | 11 |
690393 | 690393 | 2020-11-02 | Jefferson | Florida | 12065 | 682 | 9 |
687148 | 687148 | 2020-11-01 | Jefferson | Florida | 12065 | 682 | 9 |
683904 | 683904 | 2020-10-31 | Jefferson | Florida | 12065 | 680 | 9 |
680661 | 680661 | 2020-10-30 | Jefferson | Florida | 12065 | 677 | 9 |
677418 | 677418 | 2020-10-29 | Jefferson | Florida | 12065 | 672 | 9 |
674175 | 674175 | 2020-10-28 | Jefferson | Florida | 12065 | 665 | 9 |
670933 | 670933 | 2020-10-27 | Jefferson | Florida | 12065 | 665 | 9 |
667690 | 667690 | 2020-10-26 | Jefferson | Florida | 12065 | 661 | 9 |
664445 | 664445 | 2020-10-25 | Jefferson | Florida | 12065 | 659 | 9 |
661201 | 661201 | 2020-10-24 | Jefferson | Florida | 12065 | 658 | 9 |
657957 | 657957 | 2020-10-23 | Jefferson | Florida | 12065 | 650 | 9 |
654712 | 654712 | 2020-10-22 | Jefferson | Florida | 12065 | 640 | 9 |
651467 | 651467 | 2020-10-21 | Jefferson | Florida | 12065 | 633 | 9 |
648223 | 648223 | 2020-10-20 | Jefferson | Florida | 12065 | 631 | 9 |
644978 | 644978 | 2020-10-19 | Jefferson | Florida | 12065 | 626 | 9 |
641730 | 641730 | 2020-10-18 | Jefferson | Florida | 12065 | 625 | 9 |
638483 | 638483 | 2020-10-17 | Jefferson | Florida | 12065 | 620 | 9 |
635238 | 635238 | 2020-10-16 | Jefferson | Florida | 12065 | 611 | 9 |
631992 | 631992 | 2020-10-15 | Jefferson | Florida | 12065 | 608 | 9 |
628748 | 628748 | 2020-10-14 | Jefferson | Florida | 12065 | 603 | 9 |
625505 | 625505 | 2020-10-13 | Jefferson | Florida | 12065 | 602 | 9 |
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);