ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,564 rows where county = "Bradford" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337130 | 2337130 | 2022-03-24 | Bradford | Florida | 12007 | 7457 | 148 |
2339080 | 2339080 | 2022-03-24 | Bradford | Pennsylvania | 42015 | 15020 | 200 |
2333876 | 2333876 | 2022-03-23 | Bradford | Florida | 12007 | 7457 | 143 |
2335826 | 2335826 | 2022-03-23 | Bradford | Pennsylvania | 42015 | 15009 | 199 |
2330622 | 2330622 | 2022-03-22 | Bradford | Florida | 12007 | 7457 | 143 |
2332572 | 2332572 | 2022-03-22 | Bradford | Pennsylvania | 42015 | 15000 | 199 |
2327370 | 2327370 | 2022-03-21 | Bradford | Florida | 12007 | 7457 | 143 |
2329319 | 2329319 | 2022-03-21 | Bradford | Pennsylvania | 42015 | 14992 | 199 |
2324117 | 2324117 | 2022-03-20 | Bradford | Florida | 12007 | 7457 | 143 |
2326067 | 2326067 | 2022-03-20 | Bradford | Pennsylvania | 42015 | 14987 | 199 |
2320863 | 2320863 | 2022-03-19 | Bradford | Florida | 12007 | 7457 | 143 |
2322814 | 2322814 | 2022-03-19 | Bradford | Pennsylvania | 42015 | 14985 | 199 |
2317609 | 2317609 | 2022-03-18 | Bradford | Florida | 12007 | 7457 | 143 |
2319560 | 2319560 | 2022-03-18 | Bradford | Pennsylvania | 42015 | 14975 | 199 |
2314356 | 2314356 | 2022-03-17 | Bradford | Florida | 12007 | 7457 | 143 |
2316306 | 2316306 | 2022-03-17 | Bradford | Pennsylvania | 42015 | 14967 | 199 |
2311103 | 2311103 | 2022-03-16 | Bradford | Florida | 12007 | 7457 | 143 |
2313053 | 2313053 | 2022-03-16 | Bradford | Pennsylvania | 42015 | 14962 | 199 |
2307850 | 2307850 | 2022-03-15 | Bradford | Florida | 12007 | 7457 | 142 |
2309800 | 2309800 | 2022-03-15 | Bradford | Pennsylvania | 42015 | 14949 | 197 |
2304599 | 2304599 | 2022-03-14 | Bradford | Florida | 12007 | 7457 | 142 |
2306547 | 2306547 | 2022-03-14 | Bradford | Pennsylvania | 42015 | 14945 | 196 |
2301347 | 2301347 | 2022-03-13 | Bradford | Florida | 12007 | 7457 | 142 |
2303296 | 2303296 | 2022-03-13 | Bradford | Pennsylvania | 42015 | 14944 | 196 |
2298095 | 2298095 | 2022-03-12 | Bradford | Florida | 12007 | 7457 | 142 |
2300044 | 2300044 | 2022-03-12 | Bradford | Pennsylvania | 42015 | 14940 | 196 |
2294843 | 2294843 | 2022-03-11 | Bradford | Florida | 12007 | 7457 | 142 |
2296792 | 2296792 | 2022-03-11 | Bradford | Pennsylvania | 42015 | 14930 | 195 |
2291591 | 2291591 | 2022-03-10 | Bradford | Florida | 12007 | 7449 | 142 |
2293540 | 2293540 | 2022-03-10 | Bradford | Pennsylvania | 42015 | 14923 | 195 |
2288339 | 2288339 | 2022-03-09 | Bradford | Florida | 12007 | 7449 | 142 |
2290288 | 2290288 | 2022-03-09 | Bradford | Pennsylvania | 42015 | 14910 | 195 |
2285088 | 2285088 | 2022-03-08 | Bradford | Florida | 12007 | 7449 | 140 |
2287036 | 2287036 | 2022-03-08 | Bradford | Pennsylvania | 42015 | 14895 | 195 |
2281836 | 2281836 | 2022-03-07 | Bradford | Florida | 12007 | 7449 | 140 |
2283784 | 2283784 | 2022-03-07 | Bradford | Pennsylvania | 42015 | 14874 | 194 |
2278583 | 2278583 | 2022-03-06 | Bradford | Florida | 12007 | 7449 | 140 |
2280532 | 2280532 | 2022-03-06 | Bradford | Pennsylvania | 42015 | 14865 | 194 |
2275330 | 2275330 | 2022-03-05 | Bradford | Florida | 12007 | 7449 | 140 |
2277279 | 2277279 | 2022-03-05 | Bradford | Pennsylvania | 42015 | 14853 | 193 |
2272077 | 2272077 | 2022-03-04 | Bradford | Florida | 12007 | 7449 | 140 |
2274026 | 2274026 | 2022-03-04 | Bradford | Pennsylvania | 42015 | 14848 | 193 |
2268825 | 2268825 | 2022-03-03 | Bradford | Florida | 12007 | 7436 | 140 |
2270773 | 2270773 | 2022-03-03 | Bradford | Pennsylvania | 42015 | 14846 | 193 |
2265572 | 2265572 | 2022-03-02 | Bradford | Florida | 12007 | 7436 | 140 |
2267521 | 2267521 | 2022-03-02 | Bradford | Pennsylvania | 42015 | 14841 | 192 |
2262321 | 2262321 | 2022-03-01 | Bradford | Florida | 12007 | 7436 | 138 |
2264268 | 2264268 | 2022-03-01 | Bradford | Pennsylvania | 42015 | 14832 | 192 |
2259070 | 2259070 | 2022-02-28 | Bradford | Florida | 12007 | 7436 | 138 |
2261018 | 2261018 | 2022-02-28 | Bradford | Pennsylvania | 42015 | 14822 | 192 |
2255819 | 2255819 | 2022-02-27 | Bradford | Florida | 12007 | 7436 | 138 |
2257767 | 2257767 | 2022-02-27 | Bradford | Pennsylvania | 42015 | 14820 | 192 |
2252568 | 2252568 | 2022-02-26 | Bradford | Florida | 12007 | 7436 | 138 |
2254516 | 2254516 | 2022-02-26 | Bradford | Pennsylvania | 42015 | 14812 | 192 |
2249317 | 2249317 | 2022-02-25 | Bradford | Florida | 12007 | 7436 | 138 |
2251265 | 2251265 | 2022-02-25 | Bradford | Pennsylvania | 42015 | 14794 | 192 |
2246066 | 2246066 | 2022-02-24 | Bradford | Florida | 12007 | 7412 | 138 |
2248014 | 2248014 | 2022-02-24 | Bradford | Pennsylvania | 42015 | 14781 | 192 |
2242815 | 2242815 | 2022-02-23 | Bradford | Florida | 12007 | 7412 | 138 |
2244763 | 2244763 | 2022-02-23 | Bradford | Pennsylvania | 42015 | 14763 | 192 |
2239564 | 2239564 | 2022-02-22 | Bradford | Florida | 12007 | 7412 | 134 |
2241512 | 2241512 | 2022-02-22 | Bradford | Pennsylvania | 42015 | 14741 | 191 |
2236313 | 2236313 | 2022-02-21 | Bradford | Florida | 12007 | 7412 | 134 |
2238261 | 2238261 | 2022-02-21 | Bradford | Pennsylvania | 42015 | 14713 | 191 |
2233062 | 2233062 | 2022-02-20 | Bradford | Florida | 12007 | 7412 | 134 |
2235010 | 2235010 | 2022-02-20 | Bradford | Pennsylvania | 42015 | 14713 | 191 |
2229811 | 2229811 | 2022-02-19 | Bradford | Florida | 12007 | 7412 | 134 |
2231759 | 2231759 | 2022-02-19 | Bradford | Pennsylvania | 42015 | 14703 | 190 |
2226560 | 2226560 | 2022-02-18 | Bradford | Florida | 12007 | 7412 | 134 |
2228508 | 2228508 | 2022-02-18 | Bradford | Pennsylvania | 42015 | 14667 | 190 |
2223309 | 2223309 | 2022-02-17 | Bradford | Florida | 12007 | 7355 | 134 |
2225257 | 2225257 | 2022-02-17 | Bradford | Pennsylvania | 42015 | 14642 | 190 |
2220058 | 2220058 | 2022-02-16 | Bradford | Florida | 12007 | 7355 | 134 |
2222006 | 2222006 | 2022-02-16 | Bradford | Pennsylvania | 42015 | 14617 | 190 |
2216807 | 2216807 | 2022-02-15 | Bradford | Florida | 12007 | 7355 | 130 |
2218755 | 2218755 | 2022-02-15 | Bradford | Pennsylvania | 42015 | 14592 | 190 |
2213556 | 2213556 | 2022-02-14 | Bradford | Florida | 12007 | 7355 | 130 |
2215504 | 2215504 | 2022-02-14 | Bradford | Pennsylvania | 42015 | 14574 | 190 |
2210304 | 2210304 | 2022-02-13 | Bradford | Florida | 12007 | 7355 | 130 |
2212253 | 2212253 | 2022-02-13 | Bradford | Pennsylvania | 42015 | 14566 | 190 |
2207051 | 2207051 | 2022-02-12 | Bradford | Florida | 12007 | 7355 | 130 |
2209000 | 2209000 | 2022-02-12 | Bradford | Pennsylvania | 42015 | 14553 | 190 |
2203798 | 2203798 | 2022-02-11 | Bradford | Florida | 12007 | 7355 | 130 |
2205747 | 2205747 | 2022-02-11 | Bradford | Pennsylvania | 42015 | 14529 | 190 |
2200545 | 2200545 | 2022-02-10 | Bradford | Florida | 12007 | 7142 | 130 |
2202494 | 2202494 | 2022-02-10 | Bradford | Pennsylvania | 42015 | 14499 | 189 |
2197291 | 2197291 | 2022-02-09 | Bradford | Florida | 12007 | 7142 | 130 |
2199240 | 2199240 | 2022-02-09 | Bradford | Pennsylvania | 42015 | 14454 | 189 |
2194037 | 2194037 | 2022-02-08 | Bradford | Florida | 12007 | 7142 | 130 |
2195986 | 2195986 | 2022-02-08 | Bradford | Pennsylvania | 42015 | 14401 | 189 |
2190783 | 2190783 | 2022-02-07 | Bradford | Florida | 12007 | 7142 | 130 |
2192732 | 2192732 | 2022-02-07 | Bradford | Pennsylvania | 42015 | 14368 | 188 |
2187530 | 2187530 | 2022-02-06 | Bradford | Florida | 12007 | 7142 | 130 |
2189478 | 2189478 | 2022-02-06 | Bradford | Pennsylvania | 42015 | 14353 | 188 |
2184277 | 2184277 | 2022-02-05 | Bradford | Florida | 12007 | 7142 | 130 |
2186225 | 2186225 | 2022-02-05 | Bradford | Pennsylvania | 42015 | 14323 | 188 |
2181025 | 2181025 | 2022-02-04 | Bradford | Florida | 12007 | 7142 | 130 |
2182973 | 2182973 | 2022-02-04 | Bradford | Pennsylvania | 42015 | 14292 | 188 |
2177774 | 2177774 | 2022-02-03 | Bradford | Florida | 12007 | 6868 | 130 |
2179721 | 2179721 | 2022-02-03 | Bradford | Pennsylvania | 42015 | 14246 | 188 |
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);