ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where county = "Franklin" and deaths = 8 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2169390 | 2169390 | 2022-01-31 | Franklin | Nebraska | 31061 | 389 | 8 |
2166135 | 2166135 | 2022-01-30 | Franklin | Nebraska | 31061 | 385 | 8 |
2162880 | 2162880 | 2022-01-29 | Franklin | Nebraska | 31061 | 385 | 8 |
2159625 | 2159625 | 2022-01-28 | Franklin | Nebraska | 31061 | 385 | 8 |
2156371 | 2156371 | 2022-01-27 | Franklin | Nebraska | 31061 | 381 | 8 |
2153118 | 2153118 | 2022-01-26 | Franklin | Nebraska | 31061 | 379 | 8 |
2149866 | 2149866 | 2022-01-25 | Franklin | Nebraska | 31061 | 378 | 8 |
2146614 | 2146614 | 2022-01-24 | Franklin | Nebraska | 31061 | 378 | 8 |
2143359 | 2143359 | 2022-01-23 | Franklin | Nebraska | 31061 | 375 | 8 |
2140104 | 2140104 | 2022-01-22 | Franklin | Nebraska | 31061 | 375 | 8 |
2136848 | 2136848 | 2022-01-21 | Franklin | Nebraska | 31061 | 375 | 8 |
2133596 | 2133596 | 2022-01-20 | Franklin | Nebraska | 31061 | 375 | 8 |
2130343 | 2130343 | 2022-01-19 | Franklin | Nebraska | 31061 | 373 | 8 |
2127089 | 2127089 | 2022-01-18 | Franklin | Nebraska | 31061 | 371 | 8 |
2123837 | 2123837 | 2022-01-17 | Franklin | Nebraska | 31061 | 371 | 8 |
2120585 | 2120585 | 2022-01-16 | Franklin | Nebraska | 31061 | 367 | 8 |
2117333 | 2117333 | 2022-01-15 | Franklin | Nebraska | 31061 | 367 | 8 |
2114082 | 2114082 | 2022-01-14 | Franklin | Nebraska | 31061 | 367 | 8 |
2110830 | 2110830 | 2022-01-13 | Franklin | Nebraska | 31061 | 368 | 8 |
2107579 | 2107579 | 2022-01-12 | Franklin | Nebraska | 31061 | 367 | 8 |
2104328 | 2104328 | 2022-01-11 | Franklin | Nebraska | 31061 | 366 | 8 |
2101077 | 2101077 | 2022-01-10 | Franklin | Nebraska | 31061 | 366 | 8 |
2097826 | 2097826 | 2022-01-09 | Franklin | Nebraska | 31061 | 363 | 8 |
2094574 | 2094574 | 2022-01-08 | Franklin | Nebraska | 31061 | 363 | 8 |
2091322 | 2091322 | 2022-01-07 | Franklin | Nebraska | 31061 | 363 | 8 |
2088071 | 2088071 | 2022-01-06 | Franklin | Nebraska | 31061 | 363 | 8 |
2084819 | 2084819 | 2022-01-05 | Franklin | Nebraska | 31061 | 360 | 8 |
2081567 | 2081567 | 2022-01-04 | Franklin | Nebraska | 31061 | 359 | 8 |
2078315 | 2078315 | 2022-01-03 | Franklin | Nebraska | 31061 | 358 | 8 |
2075064 | 2075064 | 2022-01-02 | Franklin | Nebraska | 31061 | 357 | 8 |
2071813 | 2071813 | 2022-01-01 | Franklin | Nebraska | 31061 | 357 | 8 |
2068562 | 2068562 | 2021-12-31 | Franklin | Nebraska | 31061 | 357 | 8 |
2065311 | 2065311 | 2021-12-30 | Franklin | Nebraska | 31061 | 357 | 8 |
2062061 | 2062061 | 2021-12-29 | Franklin | Nebraska | 31061 | 357 | 8 |
2058812 | 2058812 | 2021-12-28 | Franklin | Nebraska | 31061 | 354 | 8 |
2055563 | 2055563 | 2021-12-27 | Franklin | Nebraska | 31061 | 354 | 8 |
2052313 | 2052313 | 2021-12-26 | Franklin | Nebraska | 31061 | 354 | 8 |
2049063 | 2049063 | 2021-12-25 | Franklin | Nebraska | 31061 | 354 | 8 |
2045813 | 2045813 | 2021-12-24 | Franklin | Nebraska | 31061 | 354 | 8 |
2042563 | 2042563 | 2021-12-23 | Franklin | Nebraska | 31061 | 354 | 8 |
989781 | 989781 | 2021-02-02 | Franklin | Maine | 23007 | 784 | 8 |
986534 | 986534 | 2021-02-01 | Franklin | Maine | 23007 | 775 | 8 |
983287 | 983287 | 2021-01-31 | Franklin | Maine | 23007 | 771 | 8 |
980041 | 980041 | 2021-01-30 | Franklin | Maine | 23007 | 767 | 8 |
976795 | 976795 | 2021-01-29 | Franklin | Maine | 23007 | 753 | 8 |
973550 | 973550 | 2021-01-28 | Franklin | Maine | 23007 | 740 | 8 |
891806 | 891806 | 2021-01-03 | Franklin | Idaho | 16041 | 939 | 8 |
888559 | 888559 | 2021-01-02 | Franklin | Idaho | 16041 | 939 | 8 |
885314 | 885314 | 2021-01-01 | Franklin | Idaho | 16041 | 928 | 8 |
882069 | 882069 | 2020-12-31 | Franklin | Idaho | 16041 | 928 | 8 |
878824 | 878824 | 2020-12-30 | Franklin | Idaho | 16041 | 923 | 8 |
879680 | 879680 | 2020-12-30 | Franklin | Mississippi | 28037 | 578 | 8 |
875579 | 875579 | 2020-12-29 | Franklin | Idaho | 16041 | 918 | 8 |
876435 | 876435 | 2020-12-29 | Franklin | Mississippi | 28037 | 574 | 8 |
872334 | 872334 | 2020-12-28 | Franklin | Idaho | 16041 | 916 | 8 |
869089 | 869089 | 2020-12-27 | Franklin | Idaho | 16041 | 912 | 8 |
865844 | 865844 | 2020-12-26 | Franklin | Idaho | 16041 | 912 | 8 |
862599 | 862599 | 2020-12-25 | Franklin | Idaho | 16041 | 908 | 8 |
859354 | 859354 | 2020-12-24 | Franklin | Idaho | 16041 | 908 | 8 |
856109 | 856109 | 2020-12-23 | Franklin | Idaho | 16041 | 899 | 8 |
852864 | 852864 | 2020-12-22 | Franklin | Idaho | 16041 | 898 | 8 |
849619 | 849619 | 2020-12-21 | Franklin | Idaho | 16041 | 884 | 8 |
846374 | 846374 | 2020-12-20 | Franklin | Idaho | 16041 | 880 | 8 |
843128 | 843128 | 2020-12-19 | Franklin | Idaho | 16041 | 880 | 8 |
839883 | 839883 | 2020-12-18 | Franklin | Idaho | 16041 | 871 | 8 |
836638 | 836638 | 2020-12-17 | Franklin | Idaho | 16041 | 861 | 8 |
833392 | 833392 | 2020-12-16 | Franklin | Idaho | 16041 | 846 | 8 |
830145 | 830145 | 2020-12-15 | Franklin | Idaho | 16041 | 841 | 8 |
826899 | 826899 | 2020-12-14 | Franklin | Idaho | 16041 | 833 | 8 |
802218 | 802218 | 2020-12-06 | Franklin | New York | 36033 | 322 | 8 |
798973 | 798973 | 2020-12-05 | Franklin | New York | 36033 | 305 | 8 |
795728 | 795728 | 2020-12-04 | Franklin | New York | 36033 | 293 | 8 |
783799 | 783799 | 2020-11-30 | Franklin | Vermont | 50011 | 245 | 8 |
751813 | 751813 | 2020-11-21 | Franklin | Arkansas | 5047 | 709 | 8 |
748567 | 748567 | 2020-11-20 | Franklin | Arkansas | 5047 | 698 | 8 |
733126 | 733126 | 2020-11-15 | Franklin | Kansas | 20059 | 824 | 8 |
729881 | 729881 | 2020-11-14 | Franklin | Kansas | 20059 | 824 | 8 |
726638 | 726638 | 2020-11-13 | Franklin | Kansas | 20059 | 824 | 8 |
723395 | 723395 | 2020-11-12 | Franklin | Kansas | 20059 | 790 | 8 |
720152 | 720152 | 2020-11-11 | Franklin | Kansas | 20059 | 790 | 8 |
716909 | 716909 | 2020-11-10 | Franklin | Kansas | 20059 | 761 | 8 |
713665 | 713665 | 2020-11-09 | Franklin | Kansas | 20059 | 761 | 8 |
708954 | 708954 | 2020-11-07 | Franklin | Texas | 48159 | 230 | 8 |
705710 | 705710 | 2020-11-06 | Franklin | Texas | 48159 | 230 | 8 |
702467 | 702467 | 2020-11-05 | Franklin | Texas | 48159 | 229 | 8 |
699224 | 699224 | 2020-11-04 | Franklin | Texas | 48159 | 228 | 8 |
658230 | 658230 | 2020-10-23 | Franklin | Illinois | 17055 | 930 | 8 |
654985 | 654985 | 2020-10-22 | Franklin | Illinois | 17055 | 913 | 8 |
651740 | 651740 | 2020-10-21 | Franklin | Illinois | 17055 | 888 | 8 |
566106 | 566106 | 2020-09-24 | Franklin | Tennessee | 47051 | 951 | 8 |
562865 | 562865 | 2020-09-23 | Franklin | Tennessee | 47051 | 945 | 8 |
402846 | 402846 | 2020-08-05 | Franklin | Iowa | 19069 | 227 | 8 |
206108 | 206108 | 2020-06-04 | Franklin | Alabama | 1059 | 588 | 8 |
203029 | 203029 | 2020-06-03 | Franklin | Alabama | 1059 | 581 | 8 |
199953 | 199953 | 2020-06-02 | Franklin | Alabama | 1059 | 579 | 8 |
196880 | 196880 | 2020-06-01 | Franklin | Alabama | 1059 | 565 | 8 |
163994 | 163994 | 2020-05-21 | Franklin | Indiana | 18047 | 111 | 8 |
160966 | 160966 | 2020-05-20 | Franklin | Indiana | 18047 | 111 | 8 |
157940 | 157940 | 2020-05-19 | Franklin | Indiana | 18047 | 111 | 8 |
154924 | 154924 | 2020-05-18 | Franklin | Indiana | 18047 | 110 | 8 |
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);