ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Bradford" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501854 | 2501854 | 2022-05-13 | Bradford | Pennsylvania | 42015 | 16219 | 207 |
2498596 | 2498596 | 2022-05-12 | Bradford | Pennsylvania | 42015 | 16219 | 207 |
2495338 | 2495338 | 2022-05-11 | Bradford | Pennsylvania | 42015 | 16219 | 207 |
2492080 | 2492080 | 2022-05-10 | Bradford | Pennsylvania | 42015 | 15945 | 206 |
2488822 | 2488822 | 2022-05-09 | Bradford | Pennsylvania | 42015 | 15945 | 206 |
2485565 | 2485565 | 2022-05-08 | Bradford | Pennsylvania | 42015 | 15945 | 206 |
2482307 | 2482307 | 2022-05-07 | Bradford | Pennsylvania | 42015 | 15945 | 206 |
2479049 | 2479049 | 2022-05-06 | Bradford | Pennsylvania | 42015 | 15945 | 206 |
2475791 | 2475791 | 2022-05-05 | Bradford | Pennsylvania | 42015 | 15945 | 206 |
2472534 | 2472534 | 2022-05-04 | Bradford | Pennsylvania | 42015 | 15945 | 206 |
2469278 | 2469278 | 2022-05-03 | Bradford | Pennsylvania | 42015 | 15895 | 206 |
2466022 | 2466022 | 2022-05-02 | Bradford | Pennsylvania | 42015 | 15829 | 206 |
2462767 | 2462767 | 2022-05-01 | Bradford | Pennsylvania | 42015 | 15818 | 206 |
2459511 | 2459511 | 2022-04-30 | Bradford | Pennsylvania | 42015 | 15806 | 206 |
2456255 | 2456255 | 2022-04-29 | Bradford | Pennsylvania | 42015 | 15772 | 206 |
2452999 | 2452999 | 2022-04-28 | Bradford | Pennsylvania | 42015 | 15727 | 205 |
2449743 | 2449743 | 2022-04-27 | Bradford | Pennsylvania | 42015 | 15678 | 205 |
2446486 | 2446486 | 2022-04-26 | Bradford | Pennsylvania | 42015 | 15610 | 205 |
2443231 | 2443231 | 2022-04-25 | Bradford | Pennsylvania | 42015 | 15563 | 205 |
2439975 | 2439975 | 2022-04-24 | Bradford | Pennsylvania | 42015 | 15554 | 205 |
2436719 | 2436719 | 2022-04-23 | Bradford | Pennsylvania | 42015 | 15525 | 205 |
2433463 | 2433463 | 2022-04-22 | Bradford | Pennsylvania | 42015 | 15484 | 204 |
2430207 | 2430207 | 2022-04-21 | Bradford | Pennsylvania | 42015 | 15451 | 203 |
2426951 | 2426951 | 2022-04-20 | Bradford | Pennsylvania | 42015 | 15434 | 202 |
2423695 | 2423695 | 2022-04-19 | Bradford | Pennsylvania | 42015 | 15399 | 202 |
2420439 | 2420439 | 2022-04-18 | Bradford | Pennsylvania | 42015 | 15359 | 201 |
2417183 | 2417183 | 2022-04-17 | Bradford | Pennsylvania | 42015 | 15355 | 201 |
2413927 | 2413927 | 2022-04-16 | Bradford | Pennsylvania | 42015 | 15339 | 201 |
2410671 | 2410671 | 2022-04-15 | Bradford | Pennsylvania | 42015 | 15311 | 200 |
2407415 | 2407415 | 2022-04-14 | Bradford | Pennsylvania | 42015 | 15286 | 200 |
2404159 | 2404159 | 2022-04-13 | Bradford | Pennsylvania | 42015 | 15267 | 200 |
2400904 | 2400904 | 2022-04-12 | Bradford | Pennsylvania | 42015 | 15239 | 200 |
2397649 | 2397649 | 2022-04-11 | Bradford | Pennsylvania | 42015 | 15204 | 200 |
2394394 | 2394394 | 2022-04-10 | Bradford | Pennsylvania | 42015 | 15194 | 200 |
2391138 | 2391138 | 2022-04-09 | Bradford | Pennsylvania | 42015 | 15187 | 200 |
2387882 | 2387882 | 2022-04-08 | Bradford | Pennsylvania | 42015 | 15176 | 200 |
2384627 | 2384627 | 2022-04-07 | Bradford | Pennsylvania | 42015 | 15162 | 200 |
2381372 | 2381372 | 2022-04-06 | Bradford | Pennsylvania | 42015 | 15154 | 200 |
2378117 | 2378117 | 2022-04-05 | Bradford | Pennsylvania | 42015 | 15135 | 200 |
2374863 | 2374863 | 2022-04-04 | Bradford | Pennsylvania | 42015 | 15118 | 200 |
2371611 | 2371611 | 2022-04-03 | Bradford | Pennsylvania | 42015 | 15110 | 200 |
2368358 | 2368358 | 2022-04-02 | Bradford | Pennsylvania | 42015 | 15110 | 200 |
2365105 | 2365105 | 2022-04-01 | Bradford | Pennsylvania | 42015 | 15081 | 200 |
2361852 | 2361852 | 2022-03-31 | Bradford | Pennsylvania | 42015 | 15069 | 200 |
2358598 | 2358598 | 2022-03-30 | Bradford | Pennsylvania | 42015 | 15056 | 200 |
2355344 | 2355344 | 2022-03-29 | Bradford | Pennsylvania | 42015 | 15055 | 200 |
2352091 | 2352091 | 2022-03-28 | Bradford | Pennsylvania | 42015 | 15042 | 200 |
2348839 | 2348839 | 2022-03-27 | Bradford | Pennsylvania | 42015 | 15038 | 200 |
2345586 | 2345586 | 2022-03-26 | Bradford | Pennsylvania | 42015 | 15036 | 200 |
2342333 | 2342333 | 2022-03-25 | Bradford | Pennsylvania | 42015 | 15028 | 200 |
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 |
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);