ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jefferson" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946982 | 946982 | 2021-01-20 | Jefferson | Idaho | 16051 | 2212 | 15 |
943735 | 943735 | 2021-01-19 | Jefferson | Idaho | 16051 | 2207 | 15 |
940490 | 940490 | 2021-01-18 | Jefferson | Idaho | 16051 | 2196 | 15 |
937245 | 937245 | 2021-01-17 | Jefferson | Idaho | 16051 | 2196 | 15 |
934000 | 934000 | 2021-01-16 | Jefferson | Idaho | 16051 | 2196 | 15 |
930755 | 930755 | 2021-01-15 | Jefferson | Idaho | 16051 | 2189 | 15 |
927510 | 927510 | 2021-01-14 | Jefferson | Idaho | 16051 | 2185 | 15 |
924264 | 924264 | 2021-01-13 | Jefferson | Idaho | 16051 | 2176 | 15 |
921019 | 921019 | 2021-01-12 | Jefferson | Idaho | 16051 | 2165 | 15 |
917774 | 917774 | 2021-01-11 | Jefferson | Idaho | 16051 | 2157 | 15 |
914529 | 914529 | 2021-01-10 | Jefferson | Idaho | 16051 | 2157 | 15 |
911284 | 911284 | 2021-01-09 | Jefferson | Idaho | 16051 | 2145 | 15 |
908039 | 908039 | 2021-01-08 | Jefferson | Idaho | 16051 | 2137 | 15 |
904793 | 904793 | 2021-01-07 | Jefferson | Idaho | 16051 | 2126 | 15 |
901548 | 901548 | 2021-01-06 | Jefferson | Idaho | 16051 | 2106 | 15 |
898303 | 898303 | 2021-01-05 | Jefferson | Idaho | 16051 | 2101 | 15 |
895058 | 895058 | 2021-01-04 | Jefferson | Idaho | 16051 | 2084 | 15 |
891811 | 891811 | 2021-01-03 | Jefferson | Idaho | 16051 | 2083 | 15 |
888564 | 888564 | 2021-01-02 | Jefferson | Idaho | 16051 | 2076 | 15 |
885319 | 885319 | 2021-01-01 | Jefferson | Idaho | 16051 | 2067 | 15 |
882074 | 882074 | 2020-12-31 | Jefferson | Idaho | 16051 | 2067 | 15 |
878829 | 878829 | 2020-12-30 | Jefferson | Idaho | 16051 | 2054 | 14 |
875584 | 875584 | 2020-12-29 | Jefferson | Idaho | 16051 | 2044 | 14 |
872339 | 872339 | 2020-12-28 | Jefferson | Idaho | 16051 | 2032 | 15 |
869094 | 869094 | 2020-12-27 | Jefferson | Idaho | 16051 | 2024 | 14 |
865849 | 865849 | 2020-12-26 | Jefferson | Idaho | 16051 | 2018 | 14 |
862604 | 862604 | 2020-12-25 | Jefferson | Idaho | 16051 | 2005 | 14 |
859359 | 859359 | 2020-12-24 | Jefferson | Idaho | 16051 | 2005 | 14 |
856114 | 856114 | 2020-12-23 | Jefferson | Idaho | 16051 | 1989 | 14 |
852869 | 852869 | 2020-12-22 | Jefferson | Idaho | 16051 | 1980 | 14 |
849624 | 849624 | 2020-12-21 | Jefferson | Idaho | 16051 | 1971 | 14 |
846379 | 846379 | 2020-12-20 | Jefferson | Idaho | 16051 | 1963 | 14 |
843133 | 843133 | 2020-12-19 | Jefferson | Idaho | 16051 | 1956 | 14 |
839888 | 839888 | 2020-12-18 | Jefferson | Idaho | 16051 | 1917 | 14 |
836643 | 836643 | 2020-12-17 | Jefferson | Idaho | 16051 | 1907 | 13 |
833397 | 833397 | 2020-12-16 | Jefferson | Idaho | 16051 | 1896 | 13 |
830150 | 830150 | 2020-12-15 | Jefferson | Idaho | 16051 | 1884 | 13 |
826904 | 826904 | 2020-12-14 | Jefferson | Idaho | 16051 | 1871 | 11 |
823657 | 823657 | 2020-12-13 | Jefferson | Idaho | 16051 | 1862 | 11 |
820411 | 820411 | 2020-12-12 | Jefferson | Idaho | 16051 | 1844 | 11 |
817165 | 817165 | 2020-12-11 | Jefferson | Idaho | 16051 | 1842 | 11 |
813919 | 813919 | 2020-12-10 | Jefferson | Idaho | 16051 | 1828 | 11 |
810674 | 810674 | 2020-12-09 | Jefferson | Idaho | 16051 | 1810 | 11 |
807429 | 807429 | 2020-12-08 | Jefferson | Idaho | 16051 | 1779 | 11 |
804184 | 804184 | 2020-12-07 | Jefferson | Idaho | 16051 | 1749 | 11 |
800939 | 800939 | 2020-12-06 | Jefferson | Idaho | 16051 | 1702 | 11 |
797694 | 797694 | 2020-12-05 | Jefferson | Idaho | 16051 | 1679 | 11 |
794449 | 794449 | 2020-12-04 | Jefferson | Idaho | 16051 | 1674 | 11 |
791204 | 791204 | 2020-12-03 | Jefferson | Idaho | 16051 | 1633 | 11 |
787959 | 787959 | 2020-12-02 | Jefferson | Idaho | 16051 | 1604 | 11 |
784715 | 784715 | 2020-12-01 | Jefferson | Idaho | 16051 | 1584 | 11 |
781470 | 781470 | 2020-11-30 | Jefferson | Idaho | 16051 | 1550 | 11 |
778224 | 778224 | 2020-11-29 | Jefferson | Idaho | 16051 | 1534 | 11 |
774979 | 774979 | 2020-11-28 | Jefferson | Idaho | 16051 | 1508 | 11 |
771734 | 771734 | 2020-11-27 | Jefferson | Idaho | 16051 | 1484 | 11 |
768489 | 768489 | 2020-11-26 | Jefferson | Idaho | 16051 | 1472 | 11 |
765243 | 765243 | 2020-11-25 | Jefferson | Idaho | 16051 | 1472 | 11 |
761998 | 761998 | 2020-11-24 | Jefferson | Idaho | 16051 | 1455 | 10 |
758753 | 758753 | 2020-11-23 | Jefferson | Idaho | 16051 | 1437 | 10 |
755506 | 755506 | 2020-11-22 | Jefferson | Idaho | 16051 | 1426 | 10 |
752260 | 752260 | 2020-11-21 | Jefferson | Idaho | 16051 | 1416 | 10 |
749014 | 749014 | 2020-11-20 | Jefferson | Idaho | 16051 | 1395 | 10 |
745768 | 745768 | 2020-11-19 | Jefferson | Idaho | 16051 | 1376 | 10 |
742521 | 742521 | 2020-11-18 | Jefferson | Idaho | 16051 | 1355 | 10 |
739274 | 739274 | 2020-11-17 | Jefferson | Idaho | 16051 | 1325 | 6 |
736030 | 736030 | 2020-11-16 | Jefferson | Idaho | 16051 | 1301 | 6 |
732784 | 732784 | 2020-11-15 | Jefferson | Idaho | 16051 | 1279 | 5 |
729539 | 729539 | 2020-11-14 | Jefferson | Idaho | 16051 | 1253 | 5 |
726296 | 726296 | 2020-11-13 | Jefferson | Idaho | 16051 | 1237 | 5 |
723053 | 723053 | 2020-11-12 | Jefferson | Idaho | 16051 | 1226 | 5 |
719810 | 719810 | 2020-11-11 | Jefferson | Idaho | 16051 | 1215 | 5 |
716567 | 716567 | 2020-11-10 | Jefferson | Idaho | 16051 | 1191 | 5 |
713323 | 713323 | 2020-11-09 | Jefferson | Idaho | 16051 | 1175 | 5 |
710079 | 710079 | 2020-11-08 | Jefferson | Idaho | 16051 | 1160 | 5 |
706835 | 706835 | 2020-11-07 | Jefferson | Idaho | 16051 | 1139 | 5 |
703592 | 703592 | 2020-11-06 | Jefferson | Idaho | 16051 | 1125 | 5 |
700349 | 700349 | 2020-11-05 | Jefferson | Idaho | 16051 | 1111 | 5 |
697105 | 697105 | 2020-11-04 | Jefferson | Idaho | 16051 | 1093 | 5 |
693863 | 693863 | 2020-11-03 | Jefferson | Idaho | 16051 | 1081 | 4 |
690620 | 690620 | 2020-11-02 | Jefferson | Idaho | 16051 | 1069 | 4 |
687375 | 687375 | 2020-11-01 | Jefferson | Idaho | 16051 | 1052 | 4 |
684131 | 684131 | 2020-10-31 | Jefferson | Idaho | 16051 | 1042 | 4 |
680888 | 680888 | 2020-10-30 | Jefferson | Idaho | 16051 | 1035 | 4 |
677645 | 677645 | 2020-10-29 | Jefferson | Idaho | 16051 | 1023 | 3 |
674402 | 674402 | 2020-10-28 | Jefferson | Idaho | 16051 | 1013 | 3 |
671160 | 671160 | 2020-10-27 | Jefferson | Idaho | 16051 | 990 | 3 |
667917 | 667917 | 2020-10-26 | Jefferson | Idaho | 16051 | 976 | 3 |
664672 | 664672 | 2020-10-25 | Jefferson | Idaho | 16051 | 958 | 3 |
661428 | 661428 | 2020-10-24 | Jefferson | Idaho | 16051 | 940 | 3 |
658184 | 658184 | 2020-10-23 | Jefferson | Idaho | 16051 | 931 | 3 |
654939 | 654939 | 2020-10-22 | Jefferson | Idaho | 16051 | 916 | 3 |
651694 | 651694 | 2020-10-21 | Jefferson | Idaho | 16051 | 897 | 3 |
648450 | 648450 | 2020-10-20 | Jefferson | Idaho | 16051 | 885 | 3 |
645205 | 645205 | 2020-10-19 | Jefferson | Idaho | 16051 | 869 | 3 |
641957 | 641957 | 2020-10-18 | Jefferson | Idaho | 16051 | 859 | 3 |
638710 | 638710 | 2020-10-17 | Jefferson | Idaho | 16051 | 848 | 3 |
635465 | 635465 | 2020-10-16 | Jefferson | Idaho | 16051 | 828 | 3 |
632219 | 632219 | 2020-10-15 | Jefferson | Idaho | 16051 | 813 | 3 |
628975 | 628975 | 2020-10-14 | Jefferson | Idaho | 16051 | 802 | 3 |
625732 | 625732 | 2020-10-13 | Jefferson | Idaho | 16051 | 790 | 3 |
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);