ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Bradford" and fips = 42015 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339080 | 2339080 | 2022-03-24 | Bradford | Pennsylvania | 42015 | 15020 | 200 |
2335826 | 2335826 | 2022-03-23 | Bradford | Pennsylvania | 42015 | 15009 | 199 |
2332572 | 2332572 | 2022-03-22 | Bradford | Pennsylvania | 42015 | 15000 | 199 |
2329319 | 2329319 | 2022-03-21 | Bradford | Pennsylvania | 42015 | 14992 | 199 |
2326067 | 2326067 | 2022-03-20 | Bradford | Pennsylvania | 42015 | 14987 | 199 |
2322814 | 2322814 | 2022-03-19 | Bradford | Pennsylvania | 42015 | 14985 | 199 |
2319560 | 2319560 | 2022-03-18 | Bradford | Pennsylvania | 42015 | 14975 | 199 |
2316306 | 2316306 | 2022-03-17 | Bradford | Pennsylvania | 42015 | 14967 | 199 |
2313053 | 2313053 | 2022-03-16 | Bradford | Pennsylvania | 42015 | 14962 | 199 |
2309800 | 2309800 | 2022-03-15 | Bradford | Pennsylvania | 42015 | 14949 | 197 |
2306547 | 2306547 | 2022-03-14 | Bradford | Pennsylvania | 42015 | 14945 | 196 |
2303296 | 2303296 | 2022-03-13 | Bradford | Pennsylvania | 42015 | 14944 | 196 |
2300044 | 2300044 | 2022-03-12 | Bradford | Pennsylvania | 42015 | 14940 | 196 |
2296792 | 2296792 | 2022-03-11 | Bradford | Pennsylvania | 42015 | 14930 | 195 |
2293540 | 2293540 | 2022-03-10 | Bradford | Pennsylvania | 42015 | 14923 | 195 |
2290288 | 2290288 | 2022-03-09 | Bradford | Pennsylvania | 42015 | 14910 | 195 |
2287036 | 2287036 | 2022-03-08 | Bradford | Pennsylvania | 42015 | 14895 | 195 |
2283784 | 2283784 | 2022-03-07 | Bradford | Pennsylvania | 42015 | 14874 | 194 |
2280532 | 2280532 | 2022-03-06 | Bradford | Pennsylvania | 42015 | 14865 | 194 |
2277279 | 2277279 | 2022-03-05 | Bradford | Pennsylvania | 42015 | 14853 | 193 |
2274026 | 2274026 | 2022-03-04 | Bradford | Pennsylvania | 42015 | 14848 | 193 |
2270773 | 2270773 | 2022-03-03 | Bradford | Pennsylvania | 42015 | 14846 | 193 |
2267521 | 2267521 | 2022-03-02 | Bradford | Pennsylvania | 42015 | 14841 | 192 |
2264268 | 2264268 | 2022-03-01 | Bradford | Pennsylvania | 42015 | 14832 | 192 |
2261018 | 2261018 | 2022-02-28 | Bradford | Pennsylvania | 42015 | 14822 | 192 |
2257767 | 2257767 | 2022-02-27 | Bradford | Pennsylvania | 42015 | 14820 | 192 |
2254516 | 2254516 | 2022-02-26 | Bradford | Pennsylvania | 42015 | 14812 | 192 |
2251265 | 2251265 | 2022-02-25 | Bradford | Pennsylvania | 42015 | 14794 | 192 |
2248014 | 2248014 | 2022-02-24 | Bradford | Pennsylvania | 42015 | 14781 | 192 |
2244763 | 2244763 | 2022-02-23 | Bradford | Pennsylvania | 42015 | 14763 | 192 |
2241512 | 2241512 | 2022-02-22 | Bradford | Pennsylvania | 42015 | 14741 | 191 |
2238261 | 2238261 | 2022-02-21 | Bradford | Pennsylvania | 42015 | 14713 | 191 |
2235010 | 2235010 | 2022-02-20 | Bradford | Pennsylvania | 42015 | 14713 | 191 |
2231759 | 2231759 | 2022-02-19 | Bradford | Pennsylvania | 42015 | 14703 | 190 |
2228508 | 2228508 | 2022-02-18 | Bradford | Pennsylvania | 42015 | 14667 | 190 |
2225257 | 2225257 | 2022-02-17 | Bradford | Pennsylvania | 42015 | 14642 | 190 |
2222006 | 2222006 | 2022-02-16 | Bradford | Pennsylvania | 42015 | 14617 | 190 |
2218755 | 2218755 | 2022-02-15 | Bradford | Pennsylvania | 42015 | 14592 | 190 |
2215504 | 2215504 | 2022-02-14 | Bradford | Pennsylvania | 42015 | 14574 | 190 |
2212253 | 2212253 | 2022-02-13 | Bradford | Pennsylvania | 42015 | 14566 | 190 |
2209000 | 2209000 | 2022-02-12 | Bradford | Pennsylvania | 42015 | 14553 | 190 |
2205747 | 2205747 | 2022-02-11 | Bradford | Pennsylvania | 42015 | 14529 | 190 |
2202494 | 2202494 | 2022-02-10 | Bradford | Pennsylvania | 42015 | 14499 | 189 |
2199240 | 2199240 | 2022-02-09 | Bradford | Pennsylvania | 42015 | 14454 | 189 |
2195986 | 2195986 | 2022-02-08 | Bradford | Pennsylvania | 42015 | 14401 | 189 |
2192732 | 2192732 | 2022-02-07 | Bradford | Pennsylvania | 42015 | 14368 | 188 |
2189478 | 2189478 | 2022-02-06 | Bradford | Pennsylvania | 42015 | 14353 | 188 |
2186225 | 2186225 | 2022-02-05 | Bradford | Pennsylvania | 42015 | 14323 | 188 |
2182973 | 2182973 | 2022-02-04 | Bradford | Pennsylvania | 42015 | 14292 | 188 |
2179721 | 2179721 | 2022-02-03 | Bradford | Pennsylvania | 42015 | 14246 | 188 |
2176470 | 2176470 | 2022-02-02 | Bradford | Pennsylvania | 42015 | 14173 | 187 |
2173216 | 2173216 | 2022-02-01 | Bradford | Pennsylvania | 42015 | 14094 | 185 |
2169964 | 2169964 | 2022-01-31 | Bradford | Pennsylvania | 42015 | 14056 | 185 |
2166710 | 2166710 | 2022-01-30 | Bradford | Pennsylvania | 42015 | 14027 | 185 |
2163455 | 2163455 | 2022-01-29 | Bradford | Pennsylvania | 42015 | 13975 | 185 |
2160200 | 2160200 | 2022-01-28 | Bradford | Pennsylvania | 42015 | 13918 | 184 |
2156944 | 2156944 | 2022-01-27 | Bradford | Pennsylvania | 42015 | 13719 | 183 |
2153691 | 2153691 | 2022-01-26 | Bradford | Pennsylvania | 42015 | 13583 | 182 |
2150439 | 2150439 | 2022-01-25 | Bradford | Pennsylvania | 42015 | 13502 | 180 |
2147187 | 2147187 | 2022-01-24 | Bradford | Pennsylvania | 42015 | 13418 | 180 |
2143933 | 2143933 | 2022-01-23 | Bradford | Pennsylvania | 42015 | 13398 | 179 |
2140678 | 2140678 | 2022-01-22 | Bradford | Pennsylvania | 42015 | 13289 | 179 |
2137422 | 2137422 | 2022-01-21 | Bradford | Pennsylvania | 42015 | 13155 | 178 |
2134168 | 2134168 | 2022-01-20 | Bradford | Pennsylvania | 42015 | 13007 | 177 |
2130916 | 2130916 | 2022-01-19 | Bradford | Pennsylvania | 42015 | 12863 | 176 |
2127662 | 2127662 | 2022-01-18 | Bradford | Pennsylvania | 42015 | 12707 | 176 |
2124410 | 2124410 | 2022-01-17 | Bradford | Pennsylvania | 42015 | 12625 | 176 |
2121158 | 2121158 | 2022-01-16 | Bradford | Pennsylvania | 42015 | 12613 | 176 |
2117906 | 2117906 | 2022-01-15 | Bradford | Pennsylvania | 42015 | 12436 | 176 |
2114655 | 2114655 | 2022-01-14 | Bradford | Pennsylvania | 42015 | 12332 | 175 |
2111403 | 2111403 | 2022-01-13 | Bradford | Pennsylvania | 42015 | 12155 | 172 |
2108151 | 2108151 | 2022-01-12 | Bradford | Pennsylvania | 42015 | 11945 | 171 |
2104900 | 2104900 | 2022-01-11 | Bradford | Pennsylvania | 42015 | 11823 | 169 |
2101649 | 2101649 | 2022-01-10 | Bradford | Pennsylvania | 42015 | 11746 | 165 |
2098398 | 2098398 | 2022-01-09 | Bradford | Pennsylvania | 42015 | 11673 | 165 |
2095146 | 2095146 | 2022-01-08 | Bradford | Pennsylvania | 42015 | 11532 | 165 |
2091894 | 2091894 | 2022-01-07 | Bradford | Pennsylvania | 42015 | 11418 | 165 |
2088642 | 2088642 | 2022-01-06 | Bradford | Pennsylvania | 42015 | 11290 | 160 |
2085391 | 2085391 | 2022-01-05 | Bradford | Pennsylvania | 42015 | 11196 | 157 |
2082139 | 2082139 | 2022-01-04 | Bradford | Pennsylvania | 42015 | 11108 | 154 |
2078887 | 2078887 | 2022-01-03 | Bradford | Pennsylvania | 42015 | 11032 | 154 |
2075636 | 2075636 | 2022-01-02 | Bradford | Pennsylvania | 42015 | 10973 | 154 |
2072385 | 2072385 | 2022-01-01 | Bradford | Pennsylvania | 42015 | 10890 | 154 |
2069134 | 2069134 | 2021-12-31 | Bradford | Pennsylvania | 42015 | 10811 | 154 |
2065883 | 2065883 | 2021-12-30 | Bradford | Pennsylvania | 42015 | 10691 | 154 |
2062633 | 2062633 | 2021-12-29 | Bradford | Pennsylvania | 42015 | 10618 | 153 |
2059383 | 2059383 | 2021-12-28 | Bradford | Pennsylvania | 42015 | 10495 | 152 |
2056134 | 2056134 | 2021-12-27 | Bradford | Pennsylvania | 42015 | 10451 | 150 |
2052885 | 2052885 | 2021-12-26 | Bradford | Pennsylvania | 42015 | 10439 | 150 |
2049635 | 2049635 | 2021-12-25 | Bradford | Pennsylvania | 42015 | 10423 | 150 |
2046385 | 2046385 | 2021-12-24 | Bradford | Pennsylvania | 42015 | 10393 | 150 |
2043135 | 2043135 | 2021-12-23 | Bradford | Pennsylvania | 42015 | 10335 | 150 |
2039886 | 2039886 | 2021-12-22 | Bradford | Pennsylvania | 42015 | 10292 | 149 |
2036636 | 2036636 | 2021-12-21 | Bradford | Pennsylvania | 42015 | 10250 | 149 |
2033386 | 2033386 | 2021-12-20 | Bradford | Pennsylvania | 42015 | 10212 | 147 |
2030136 | 2030136 | 2021-12-19 | Bradford | Pennsylvania | 42015 | 10205 | 147 |
2026885 | 2026885 | 2021-12-18 | Bradford | Pennsylvania | 42015 | 10181 | 147 |
2023634 | 2023634 | 2021-12-17 | Bradford | Pennsylvania | 42015 | 10135 | 147 |
2020383 | 2020383 | 2021-12-16 | Bradford | Pennsylvania | 42015 | 10058 | 146 |
2017132 | 2017132 | 2021-12-15 | Bradford | Pennsylvania | 42015 | 10008 | 146 |
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);