ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 42083 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501888 | 2501888 | 2022-05-13 | McKean | Pennsylvania | 42083 | 8298 | 141 |
2498630 | 2498630 | 2022-05-12 | McKean | Pennsylvania | 42083 | 8298 | 141 |
2495372 | 2495372 | 2022-05-11 | McKean | Pennsylvania | 42083 | 8298 | 141 |
2492114 | 2492114 | 2022-05-10 | McKean | Pennsylvania | 42083 | 8245 | 141 |
2488856 | 2488856 | 2022-05-09 | McKean | Pennsylvania | 42083 | 8245 | 141 |
2485599 | 2485599 | 2022-05-08 | McKean | Pennsylvania | 42083 | 8245 | 141 |
2482341 | 2482341 | 2022-05-07 | McKean | Pennsylvania | 42083 | 8245 | 141 |
2479083 | 2479083 | 2022-05-06 | McKean | Pennsylvania | 42083 | 8245 | 141 |
2475825 | 2475825 | 2022-05-05 | McKean | Pennsylvania | 42083 | 8245 | 141 |
2472568 | 2472568 | 2022-05-04 | McKean | Pennsylvania | 42083 | 8245 | 141 |
2469312 | 2469312 | 2022-05-03 | McKean | Pennsylvania | 42083 | 8242 | 140 |
2466056 | 2466056 | 2022-05-02 | McKean | Pennsylvania | 42083 | 8238 | 140 |
2462801 | 2462801 | 2022-05-01 | McKean | Pennsylvania | 42083 | 8237 | 140 |
2459545 | 2459545 | 2022-04-30 | McKean | Pennsylvania | 42083 | 8235 | 140 |
2456289 | 2456289 | 2022-04-29 | McKean | Pennsylvania | 42083 | 8228 | 140 |
2453033 | 2453033 | 2022-04-28 | McKean | Pennsylvania | 42083 | 8223 | 140 |
2449777 | 2449777 | 2022-04-27 | McKean | Pennsylvania | 42083 | 8221 | 140 |
2446520 | 2446520 | 2022-04-26 | McKean | Pennsylvania | 42083 | 8219 | 140 |
2443265 | 2443265 | 2022-04-25 | McKean | Pennsylvania | 42083 | 8217 | 140 |
2440009 | 2440009 | 2022-04-24 | McKean | Pennsylvania | 42083 | 8212 | 140 |
2436753 | 2436753 | 2022-04-23 | McKean | Pennsylvania | 42083 | 8212 | 140 |
2433497 | 2433497 | 2022-04-22 | McKean | Pennsylvania | 42083 | 8212 | 140 |
2430241 | 2430241 | 2022-04-21 | McKean | Pennsylvania | 42083 | 8212 | 139 |
2426985 | 2426985 | 2022-04-20 | McKean | Pennsylvania | 42083 | 8211 | 139 |
2423729 | 2423729 | 2022-04-19 | McKean | Pennsylvania | 42083 | 8210 | 139 |
2420473 | 2420473 | 2022-04-18 | McKean | Pennsylvania | 42083 | 8205 | 138 |
2417217 | 2417217 | 2022-04-17 | McKean | Pennsylvania | 42083 | 8204 | 138 |
2413961 | 2413961 | 2022-04-16 | McKean | Pennsylvania | 42083 | 8203 | 138 |
2410705 | 2410705 | 2022-04-15 | McKean | Pennsylvania | 42083 | 8203 | 138 |
2407449 | 2407449 | 2022-04-14 | McKean | Pennsylvania | 42083 | 8202 | 138 |
2404193 | 2404193 | 2022-04-13 | McKean | Pennsylvania | 42083 | 8197 | 138 |
2400938 | 2400938 | 2022-04-12 | McKean | Pennsylvania | 42083 | 8196 | 138 |
2397683 | 2397683 | 2022-04-11 | McKean | Pennsylvania | 42083 | 8194 | 138 |
2394428 | 2394428 | 2022-04-10 | McKean | Pennsylvania | 42083 | 8194 | 138 |
2391172 | 2391172 | 2022-04-09 | McKean | Pennsylvania | 42083 | 8194 | 138 |
2387916 | 2387916 | 2022-04-08 | McKean | Pennsylvania | 42083 | 8193 | 138 |
2384661 | 2384661 | 2022-04-07 | McKean | Pennsylvania | 42083 | 8191 | 138 |
2381406 | 2381406 | 2022-04-06 | McKean | Pennsylvania | 42083 | 8185 | 138 |
2378151 | 2378151 | 2022-04-05 | McKean | Pennsylvania | 42083 | 8180 | 138 |
2374897 | 2374897 | 2022-04-04 | McKean | Pennsylvania | 42083 | 8176 | 138 |
2371645 | 2371645 | 2022-04-03 | McKean | Pennsylvania | 42083 | 8176 | 138 |
2368392 | 2368392 | 2022-04-02 | McKean | Pennsylvania | 42083 | 8176 | 138 |
2365139 | 2365139 | 2022-04-01 | McKean | Pennsylvania | 42083 | 8170 | 138 |
2361886 | 2361886 | 2022-03-31 | McKean | Pennsylvania | 42083 | 8167 | 138 |
2358632 | 2358632 | 2022-03-30 | McKean | Pennsylvania | 42083 | 8165 | 138 |
2355378 | 2355378 | 2022-03-29 | McKean | Pennsylvania | 42083 | 8164 | 138 |
2352125 | 2352125 | 2022-03-28 | McKean | Pennsylvania | 42083 | 8162 | 138 |
2348873 | 2348873 | 2022-03-27 | McKean | Pennsylvania | 42083 | 8162 | 138 |
2345620 | 2345620 | 2022-03-26 | McKean | Pennsylvania | 42083 | 8162 | 138 |
2342367 | 2342367 | 2022-03-25 | McKean | Pennsylvania | 42083 | 8161 | 138 |
2339114 | 2339114 | 2022-03-24 | McKean | Pennsylvania | 42083 | 8155 | 138 |
2335860 | 2335860 | 2022-03-23 | McKean | Pennsylvania | 42083 | 8154 | 138 |
2332606 | 2332606 | 2022-03-22 | McKean | Pennsylvania | 42083 | 8148 | 138 |
2329353 | 2329353 | 2022-03-21 | McKean | Pennsylvania | 42083 | 8146 | 138 |
2326101 | 2326101 | 2022-03-20 | McKean | Pennsylvania | 42083 | 8146 | 138 |
2322848 | 2322848 | 2022-03-19 | McKean | Pennsylvania | 42083 | 8146 | 138 |
2319594 | 2319594 | 2022-03-18 | McKean | Pennsylvania | 42083 | 8143 | 138 |
2316340 | 2316340 | 2022-03-17 | McKean | Pennsylvania | 42083 | 8137 | 138 |
2313087 | 2313087 | 2022-03-16 | McKean | Pennsylvania | 42083 | 8137 | 138 |
2309834 | 2309834 | 2022-03-15 | McKean | Pennsylvania | 42083 | 8133 | 138 |
2306581 | 2306581 | 2022-03-14 | McKean | Pennsylvania | 42083 | 8129 | 138 |
2303330 | 2303330 | 2022-03-13 | McKean | Pennsylvania | 42083 | 8129 | 138 |
2300078 | 2300078 | 2022-03-12 | McKean | Pennsylvania | 42083 | 8128 | 138 |
2296826 | 2296826 | 2022-03-11 | McKean | Pennsylvania | 42083 | 8125 | 138 |
2293574 | 2293574 | 2022-03-10 | McKean | Pennsylvania | 42083 | 8123 | 138 |
2290322 | 2290322 | 2022-03-09 | McKean | Pennsylvania | 42083 | 8113 | 138 |
2287070 | 2287070 | 2022-03-08 | McKean | Pennsylvania | 42083 | 8104 | 138 |
2283818 | 2283818 | 2022-03-07 | McKean | Pennsylvania | 42083 | 8095 | 137 |
2280566 | 2280566 | 2022-03-06 | McKean | Pennsylvania | 42083 | 8093 | 137 |
2277313 | 2277313 | 2022-03-05 | McKean | Pennsylvania | 42083 | 8093 | 137 |
2274060 | 2274060 | 2022-03-04 | McKean | Pennsylvania | 42083 | 8089 | 137 |
2270807 | 2270807 | 2022-03-03 | McKean | Pennsylvania | 42083 | 8086 | 137 |
2267555 | 2267555 | 2022-03-02 | McKean | Pennsylvania | 42083 | 8082 | 137 |
2264302 | 2264302 | 2022-03-01 | McKean | Pennsylvania | 42083 | 8074 | 137 |
2261052 | 2261052 | 2022-02-28 | McKean | Pennsylvania | 42083 | 8064 | 134 |
2257801 | 2257801 | 2022-02-27 | McKean | Pennsylvania | 42083 | 8062 | 134 |
2254550 | 2254550 | 2022-02-26 | McKean | Pennsylvania | 42083 | 8062 | 134 |
2251299 | 2251299 | 2022-02-25 | McKean | Pennsylvania | 42083 | 8051 | 133 |
2248048 | 2248048 | 2022-02-24 | McKean | Pennsylvania | 42083 | 8050 | 132 |
2244797 | 2244797 | 2022-02-23 | McKean | Pennsylvania | 42083 | 8041 | 132 |
2241546 | 2241546 | 2022-02-22 | McKean | Pennsylvania | 42083 | 8033 | 132 |
2238295 | 2238295 | 2022-02-21 | McKean | Pennsylvania | 42083 | 8029 | 132 |
2235044 | 2235044 | 2022-02-20 | McKean | Pennsylvania | 42083 | 8029 | 132 |
2231793 | 2231793 | 2022-02-19 | McKean | Pennsylvania | 42083 | 8018 | 132 |
2228542 | 2228542 | 2022-02-18 | McKean | Pennsylvania | 42083 | 8000 | 132 |
2225291 | 2225291 | 2022-02-17 | McKean | Pennsylvania | 42083 | 7973 | 132 |
2222040 | 2222040 | 2022-02-16 | McKean | Pennsylvania | 42083 | 7949 | 132 |
2218789 | 2218789 | 2022-02-15 | McKean | Pennsylvania | 42083 | 7943 | 131 |
2215538 | 2215538 | 2022-02-14 | McKean | Pennsylvania | 42083 | 7932 | 131 |
2212287 | 2212287 | 2022-02-13 | McKean | Pennsylvania | 42083 | 7925 | 131 |
2209034 | 2209034 | 2022-02-12 | McKean | Pennsylvania | 42083 | 7921 | 131 |
2205781 | 2205781 | 2022-02-11 | McKean | Pennsylvania | 42083 | 7906 | 131 |
2202528 | 2202528 | 2022-02-10 | McKean | Pennsylvania | 42083 | 7878 | 131 |
2199274 | 2199274 | 2022-02-09 | McKean | Pennsylvania | 42083 | 7860 | 131 |
2196020 | 2196020 | 2022-02-08 | McKean | Pennsylvania | 42083 | 7837 | 130 |
2192766 | 2192766 | 2022-02-07 | McKean | Pennsylvania | 42083 | 7830 | 129 |
2189512 | 2189512 | 2022-02-06 | McKean | Pennsylvania | 42083 | 7808 | 129 |
2186259 | 2186259 | 2022-02-05 | McKean | Pennsylvania | 42083 | 7791 | 128 |
2183007 | 2183007 | 2022-02-04 | McKean | Pennsylvania | 42083 | 7763 | 128 |
2179755 | 2179755 | 2022-02-03 | McKean | Pennsylvania | 42083 | 7744 | 127 |
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);