ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 42079 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176502 | 2176502 | 2022-02-02 | Luzerne | Pennsylvania | 42079 | 70458 | 1214 |
2173248 | 2173248 | 2022-02-01 | Luzerne | Pennsylvania | 42079 | 70251 | 1210 |
2169996 | 2169996 | 2022-01-31 | Luzerne | Pennsylvania | 42079 | 70109 | 1197 |
2166742 | 2166742 | 2022-01-30 | Luzerne | Pennsylvania | 42079 | 69965 | 1196 |
2163487 | 2163487 | 2022-01-29 | Luzerne | Pennsylvania | 42079 | 69785 | 1196 |
2160232 | 2160232 | 2022-01-28 | Luzerne | Pennsylvania | 42079 | 69556 | 1192 |
2156976 | 2156976 | 2022-01-27 | Luzerne | Pennsylvania | 42079 | 69118 | 1187 |
2153723 | 2153723 | 2022-01-26 | Luzerne | Pennsylvania | 42079 | 68595 | 1178 |
2150471 | 2150471 | 2022-01-25 | Luzerne | Pennsylvania | 42079 | 68200 | 1171 |
2147219 | 2147219 | 2022-01-24 | Luzerne | Pennsylvania | 42079 | 67858 | 1164 |
2143965 | 2143965 | 2022-01-23 | Luzerne | Pennsylvania | 42079 | 67678 | 1163 |
2140710 | 2140710 | 2022-01-22 | Luzerne | Pennsylvania | 42079 | 67329 | 1163 |
2137454 | 2137454 | 2022-01-21 | Luzerne | Pennsylvania | 42079 | 66916 | 1158 |
2134200 | 2134200 | 2022-01-20 | Luzerne | Pennsylvania | 42079 | 66449 | 1149 |
2130948 | 2130948 | 2022-01-19 | Luzerne | Pennsylvania | 42079 | 65931 | 1142 |
2127694 | 2127694 | 2022-01-18 | Luzerne | Pennsylvania | 42079 | 65500 | 1136 |
2124442 | 2124442 | 2022-01-17 | Luzerne | Pennsylvania | 42079 | 65117 | 1136 |
2121190 | 2121190 | 2022-01-16 | Luzerne | Pennsylvania | 42079 | 64817 | 1136 |
2117938 | 2117938 | 2022-01-15 | Luzerne | Pennsylvania | 42079 | 63796 | 1136 |
2114687 | 2114687 | 2022-01-14 | Luzerne | Pennsylvania | 42079 | 63247 | 1129 |
2111435 | 2111435 | 2022-01-13 | Luzerne | Pennsylvania | 42079 | 62483 | 1125 |
2108183 | 2108183 | 2022-01-12 | Luzerne | Pennsylvania | 42079 | 61650 | 1120 |
2104932 | 2104932 | 2022-01-11 | Luzerne | Pennsylvania | 42079 | 60718 | 1113 |
2101681 | 2101681 | 2022-01-10 | Luzerne | Pennsylvania | 42079 | 60101 | 1106 |
2098430 | 2098430 | 2022-01-09 | Luzerne | Pennsylvania | 42079 | 59397 | 1106 |
2095178 | 2095178 | 2022-01-08 | Luzerne | Pennsylvania | 42079 | 58408 | 1105 |
2091926 | 2091926 | 2022-01-07 | Luzerne | Pennsylvania | 42079 | 57579 | 1096 |
2088674 | 2088674 | 2022-01-06 | Luzerne | Pennsylvania | 42079 | 56701 | 1090 |
2085423 | 2085423 | 2022-01-05 | Luzerne | Pennsylvania | 42079 | 56129 | 1086 |
2082171 | 2082171 | 2022-01-04 | Luzerne | Pennsylvania | 42079 | 55331 | 1081 |
2078919 | 2078919 | 2022-01-03 | Luzerne | Pennsylvania | 42079 | 54826 | 1076 |
2075668 | 2075668 | 2022-01-02 | Luzerne | Pennsylvania | 42079 | 54392 | 1071 |
2072417 | 2072417 | 2022-01-01 | Luzerne | Pennsylvania | 42079 | 53983 | 1071 |
2069166 | 2069166 | 2021-12-31 | Luzerne | Pennsylvania | 42079 | 53501 | 1070 |
2065915 | 2065915 | 2021-12-30 | Luzerne | Pennsylvania | 42079 | 52874 | 1069 |
2062665 | 2062665 | 2021-12-29 | Luzerne | Pennsylvania | 42079 | 52489 | 1064 |
2059415 | 2059415 | 2021-12-28 | Luzerne | Pennsylvania | 42079 | 51953 | 1057 |
2056166 | 2056166 | 2021-12-27 | Luzerne | Pennsylvania | 42079 | 51724 | 1051 |
2052917 | 2052917 | 2021-12-26 | Luzerne | Pennsylvania | 42079 | 51602 | 1051 |
2049667 | 2049667 | 2021-12-25 | Luzerne | Pennsylvania | 42079 | 51422 | 1051 |
2046417 | 2046417 | 2021-12-24 | Luzerne | Pennsylvania | 42079 | 51213 | 1051 |
2043167 | 2043167 | 2021-12-23 | Luzerne | Pennsylvania | 42079 | 50896 | 1049 |
2039918 | 2039918 | 2021-12-22 | Luzerne | Pennsylvania | 42079 | 50717 | 1046 |
2036668 | 2036668 | 2021-12-21 | Luzerne | Pennsylvania | 42079 | 50514 | 1045 |
2033418 | 2033418 | 2021-12-20 | Luzerne | Pennsylvania | 42079 | 50328 | 1038 |
2030168 | 2030168 | 2021-12-19 | Luzerne | Pennsylvania | 42079 | 50240 | 1036 |
2026917 | 2026917 | 2021-12-18 | Luzerne | Pennsylvania | 42079 | 50046 | 1035 |
2023666 | 2023666 | 2021-12-17 | Luzerne | Pennsylvania | 42079 | 49842 | 1031 |
2020415 | 2020415 | 2021-12-16 | Luzerne | Pennsylvania | 42079 | 49602 | 1028 |
2017164 | 2017164 | 2021-12-15 | Luzerne | Pennsylvania | 42079 | 49372 | 1026 |
2013914 | 2013914 | 2021-12-14 | Luzerne | Pennsylvania | 42079 | 49135 | 1018 |
2010663 | 2010663 | 2021-12-13 | Luzerne | Pennsylvania | 42079 | 48920 | 1015 |
2007412 | 2007412 | 2021-12-12 | Luzerne | Pennsylvania | 42079 | 48770 | 1015 |
2004161 | 2004161 | 2021-12-11 | Luzerne | Pennsylvania | 42079 | 48526 | 1014 |
2000910 | 2000910 | 2021-12-10 | Luzerne | Pennsylvania | 42079 | 48230 | 1008 |
1997660 | 1997660 | 2021-12-09 | Luzerne | Pennsylvania | 42079 | 47935 | 1005 |
1994409 | 1994409 | 2021-12-08 | Luzerne | Pennsylvania | 42079 | 47756 | 1005 |
1991158 | 1991158 | 2021-12-07 | Luzerne | Pennsylvania | 42079 | 47523 | 1003 |
1987907 | 1987907 | 2021-12-06 | Luzerne | Pennsylvania | 42079 | 47303 | 998 |
1984657 | 1984657 | 2021-12-05 | Luzerne | Pennsylvania | 42079 | 47191 | 998 |
1981407 | 1981407 | 2021-12-04 | Luzerne | Pennsylvania | 42079 | 46997 | 998 |
1978157 | 1978157 | 2021-12-03 | Luzerne | Pennsylvania | 42079 | 46759 | 993 |
1974907 | 1974907 | 2021-12-02 | Luzerne | Pennsylvania | 42079 | 46454 | 991 |
1971658 | 1971658 | 2021-12-01 | Luzerne | Pennsylvania | 42079 | 46190 | 988 |
1968408 | 1968408 | 2021-11-30 | Luzerne | Pennsylvania | 42079 | 45926 | 985 |
1965157 | 1965157 | 2021-11-29 | Luzerne | Pennsylvania | 42079 | 45766 | 980 |
1961905 | 1961905 | 2021-11-28 | Luzerne | Pennsylvania | 42079 | 45634 | 979 |
1958654 | 1958654 | 2021-11-27 | Luzerne | Pennsylvania | 42079 | 45509 | 979 |
1955403 | 1955403 | 2021-11-26 | Luzerne | Pennsylvania | 42079 | 45389 | 979 |
1952152 | 1952152 | 2021-11-25 | Luzerne | Pennsylvania | 42079 | 45182 | 979 |
1948901 | 1948901 | 2021-11-24 | Luzerne | Pennsylvania | 42079 | 45004 | 974 |
1945650 | 1945650 | 2021-11-23 | Luzerne | Pennsylvania | 42079 | 44769 | 972 |
1942399 | 1942399 | 2021-11-22 | Luzerne | Pennsylvania | 42079 | 44627 | 970 |
1939149 | 1939149 | 2021-11-21 | Luzerne | Pennsylvania | 42079 | 44478 | 970 |
1935899 | 1935899 | 2021-11-20 | Luzerne | Pennsylvania | 42079 | 44283 | 970 |
1932649 | 1932649 | 2021-11-19 | Luzerne | Pennsylvania | 42079 | 44096 | 967 |
1929398 | 1929398 | 2021-11-18 | Luzerne | Pennsylvania | 42079 | 43905 | 966 |
1926148 | 1926148 | 2021-11-17 | Luzerne | Pennsylvania | 42079 | 43737 | 965 |
1922898 | 1922898 | 2021-11-16 | Luzerne | Pennsylvania | 42079 | 43507 | 962 |
1919649 | 1919649 | 2021-11-15 | Luzerne | Pennsylvania | 42079 | 43342 | 961 |
1916399 | 1916399 | 2021-11-14 | Luzerne | Pennsylvania | 42079 | 43262 | 961 |
1913149 | 1913149 | 2021-11-13 | Luzerne | Pennsylvania | 42079 | 43122 | 960 |
1909899 | 1909899 | 2021-11-12 | Luzerne | Pennsylvania | 42079 | 42603 | 959 |
1906650 | 1906650 | 2021-11-11 | Luzerne | Pennsylvania | 42079 | 42464 | 958 |
1903401 | 1903401 | 2021-11-10 | Luzerne | Pennsylvania | 42079 | 42315 | 955 |
1900151 | 1900151 | 2021-11-09 | Luzerne | Pennsylvania | 42079 | 42151 | 950 |
1896901 | 1896901 | 2021-11-08 | Luzerne | Pennsylvania | 42079 | 42055 | 947 |
1893651 | 1893651 | 2021-11-07 | Luzerne | Pennsylvania | 42079 | 41963 | 947 |
1890401 | 1890401 | 2021-11-06 | Luzerne | Pennsylvania | 42079 | 41844 | 947 |
1887151 | 1887151 | 2021-11-05 | Luzerne | Pennsylvania | 42079 | 41718 | 946 |
1883901 | 1883901 | 2021-11-04 | Luzerne | Pennsylvania | 42079 | 41581 | 943 |
1880652 | 1880652 | 2021-11-03 | Luzerne | Pennsylvania | 42079 | 41431 | 943 |
1877403 | 1877403 | 2021-11-02 | Luzerne | Pennsylvania | 42079 | 41322 | 938 |
1874154 | 1874154 | 2021-11-01 | Luzerne | Pennsylvania | 42079 | 41168 | 934 |
1870905 | 1870905 | 2021-10-31 | Luzerne | Pennsylvania | 42079 | 41168 | 934 |
1867656 | 1867656 | 2021-10-30 | Luzerne | Pennsylvania | 42079 | 41071 | 932 |
1864407 | 1864407 | 2021-10-29 | Luzerne | Pennsylvania | 42079 | 40950 | 931 |
1861158 | 1861158 | 2021-10-28 | Luzerne | Pennsylvania | 42079 | 40824 | 928 |
1857909 | 1857909 | 2021-10-27 | Luzerne | Pennsylvania | 42079 | 40687 | 924 |
1854660 | 1854660 | 2021-10-26 | Luzerne | Pennsylvania | 42079 | 40601 | 922 |
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);