ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 42087 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 |
---|---|---|---|---|---|---|---|
2501890 | 2501890 | 2022-05-13 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
2498632 | 2498632 | 2022-05-12 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
2495374 | 2495374 | 2022-05-11 | Mifflin | Pennsylvania | 42087 | 12348 | 276 |
2492116 | 2492116 | 2022-05-10 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2488858 | 2488858 | 2022-05-09 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2485601 | 2485601 | 2022-05-08 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2482343 | 2482343 | 2022-05-07 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2479085 | 2479085 | 2022-05-06 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2475827 | 2475827 | 2022-05-05 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2472570 | 2472570 | 2022-05-04 | Mifflin | Pennsylvania | 42087 | 12328 | 276 |
2469314 | 2469314 | 2022-05-03 | Mifflin | Pennsylvania | 42087 | 12326 | 276 |
2466058 | 2466058 | 2022-05-02 | Mifflin | Pennsylvania | 42087 | 12326 | 276 |
2462803 | 2462803 | 2022-05-01 | Mifflin | Pennsylvania | 42087 | 12326 | 276 |
2459547 | 2459547 | 2022-04-30 | Mifflin | Pennsylvania | 42087 | 12322 | 276 |
2456291 | 2456291 | 2022-04-29 | Mifflin | Pennsylvania | 42087 | 12321 | 276 |
2453035 | 2453035 | 2022-04-28 | Mifflin | Pennsylvania | 42087 | 12317 | 276 |
2449779 | 2449779 | 2022-04-27 | Mifflin | Pennsylvania | 42087 | 12313 | 276 |
2446522 | 2446522 | 2022-04-26 | Mifflin | Pennsylvania | 42087 | 12311 | 276 |
2443267 | 2443267 | 2022-04-25 | Mifflin | Pennsylvania | 42087 | 12308 | 276 |
2440011 | 2440011 | 2022-04-24 | Mifflin | Pennsylvania | 42087 | 12307 | 276 |
2436755 | 2436755 | 2022-04-23 | Mifflin | Pennsylvania | 42087 | 12303 | 276 |
2433499 | 2433499 | 2022-04-22 | Mifflin | Pennsylvania | 42087 | 12302 | 276 |
2430243 | 2430243 | 2022-04-21 | Mifflin | Pennsylvania | 42087 | 12299 | 276 |
2426987 | 2426987 | 2022-04-20 | Mifflin | Pennsylvania | 42087 | 12296 | 276 |
2423731 | 2423731 | 2022-04-19 | Mifflin | Pennsylvania | 42087 | 12296 | 276 |
2420475 | 2420475 | 2022-04-18 | Mifflin | Pennsylvania | 42087 | 12292 | 276 |
2417219 | 2417219 | 2022-04-17 | Mifflin | Pennsylvania | 42087 | 12292 | 276 |
2413963 | 2413963 | 2022-04-16 | Mifflin | Pennsylvania | 42087 | 12288 | 276 |
2410707 | 2410707 | 2022-04-15 | Mifflin | Pennsylvania | 42087 | 12286 | 276 |
2407451 | 2407451 | 2022-04-14 | Mifflin | Pennsylvania | 42087 | 12283 | 276 |
2404195 | 2404195 | 2022-04-13 | Mifflin | Pennsylvania | 42087 | 12281 | 276 |
2400940 | 2400940 | 2022-04-12 | Mifflin | Pennsylvania | 42087 | 12279 | 276 |
2397685 | 2397685 | 2022-04-11 | Mifflin | Pennsylvania | 42087 | 12278 | 276 |
2394430 | 2394430 | 2022-04-10 | Mifflin | Pennsylvania | 42087 | 12274 | 276 |
2391174 | 2391174 | 2022-04-09 | Mifflin | Pennsylvania | 42087 | 12273 | 276 |
2387918 | 2387918 | 2022-04-08 | Mifflin | Pennsylvania | 42087 | 12269 | 276 |
2384663 | 2384663 | 2022-04-07 | Mifflin | Pennsylvania | 42087 | 12266 | 276 |
2381408 | 2381408 | 2022-04-06 | Mifflin | Pennsylvania | 42087 | 12266 | 276 |
2378153 | 2378153 | 2022-04-05 | Mifflin | Pennsylvania | 42087 | 12262 | 276 |
2374899 | 2374899 | 2022-04-04 | Mifflin | Pennsylvania | 42087 | 12261 | 276 |
2371647 | 2371647 | 2022-04-03 | Mifflin | Pennsylvania | 42087 | 12258 | 276 |
2368394 | 2368394 | 2022-04-02 | Mifflin | Pennsylvania | 42087 | 12258 | 276 |
2365141 | 2365141 | 2022-04-01 | Mifflin | Pennsylvania | 42087 | 12257 | 276 |
2361888 | 2361888 | 2022-03-31 | Mifflin | Pennsylvania | 42087 | 12254 | 276 |
2358634 | 2358634 | 2022-03-30 | Mifflin | Pennsylvania | 42087 | 12253 | 276 |
2355380 | 2355380 | 2022-03-29 | Mifflin | Pennsylvania | 42087 | 12252 | 276 |
2352127 | 2352127 | 2022-03-28 | Mifflin | Pennsylvania | 42087 | 12252 | 276 |
2348875 | 2348875 | 2022-03-27 | Mifflin | Pennsylvania | 42087 | 12252 | 276 |
2345622 | 2345622 | 2022-03-26 | Mifflin | Pennsylvania | 42087 | 12251 | 276 |
2342369 | 2342369 | 2022-03-25 | Mifflin | Pennsylvania | 42087 | 12247 | 276 |
2339116 | 2339116 | 2022-03-24 | Mifflin | Pennsylvania | 42087 | 12247 | 276 |
2335862 | 2335862 | 2022-03-23 | Mifflin | Pennsylvania | 42087 | 12246 | 276 |
2332608 | 2332608 | 2022-03-22 | Mifflin | Pennsylvania | 42087 | 12244 | 276 |
2329355 | 2329355 | 2022-03-21 | Mifflin | Pennsylvania | 42087 | 12242 | 276 |
2326103 | 2326103 | 2022-03-20 | Mifflin | Pennsylvania | 42087 | 12242 | 276 |
2322850 | 2322850 | 2022-03-19 | Mifflin | Pennsylvania | 42087 | 12242 | 276 |
2319596 | 2319596 | 2022-03-18 | Mifflin | Pennsylvania | 42087 | 12240 | 276 |
2316342 | 2316342 | 2022-03-17 | Mifflin | Pennsylvania | 42087 | 12239 | 276 |
2313089 | 2313089 | 2022-03-16 | Mifflin | Pennsylvania | 42087 | 12238 | 276 |
2309836 | 2309836 | 2022-03-15 | Mifflin | Pennsylvania | 42087 | 12239 | 274 |
2306583 | 2306583 | 2022-03-14 | Mifflin | Pennsylvania | 42087 | 12235 | 274 |
2303332 | 2303332 | 2022-03-13 | Mifflin | Pennsylvania | 42087 | 12235 | 274 |
2300080 | 2300080 | 2022-03-12 | Mifflin | Pennsylvania | 42087 | 12234 | 274 |
2296828 | 2296828 | 2022-03-11 | Mifflin | Pennsylvania | 42087 | 12233 | 274 |
2293576 | 2293576 | 2022-03-10 | Mifflin | Pennsylvania | 42087 | 12229 | 274 |
2290324 | 2290324 | 2022-03-09 | Mifflin | Pennsylvania | 42087 | 12224 | 274 |
2287072 | 2287072 | 2022-03-08 | Mifflin | Pennsylvania | 42087 | 12221 | 274 |
2283820 | 2283820 | 2022-03-07 | Mifflin | Pennsylvania | 42087 | 12218 | 274 |
2280568 | 2280568 | 2022-03-06 | Mifflin | Pennsylvania | 42087 | 12214 | 274 |
2277315 | 2277315 | 2022-03-05 | Mifflin | Pennsylvania | 42087 | 12208 | 274 |
2274062 | 2274062 | 2022-03-04 | Mifflin | Pennsylvania | 42087 | 12203 | 274 |
2270809 | 2270809 | 2022-03-03 | Mifflin | Pennsylvania | 42087 | 12200 | 274 |
2267557 | 2267557 | 2022-03-02 | Mifflin | Pennsylvania | 42087 | 12190 | 272 |
2264304 | 2264304 | 2022-03-01 | Mifflin | Pennsylvania | 42087 | 12181 | 271 |
2261054 | 2261054 | 2022-02-28 | Mifflin | Pennsylvania | 42087 | 12176 | 270 |
2257803 | 2257803 | 2022-02-27 | Mifflin | Pennsylvania | 42087 | 12174 | 269 |
2254552 | 2254552 | 2022-02-26 | Mifflin | Pennsylvania | 42087 | 12171 | 269 |
2251301 | 2251301 | 2022-02-25 | Mifflin | Pennsylvania | 42087 | 12165 | 268 |
2248050 | 2248050 | 2022-02-24 | Mifflin | Pennsylvania | 42087 | 12156 | 268 |
2244799 | 2244799 | 2022-02-23 | Mifflin | Pennsylvania | 42087 | 12146 | 267 |
2241548 | 2241548 | 2022-02-22 | Mifflin | Pennsylvania | 42087 | 12133 | 266 |
2238297 | 2238297 | 2022-02-21 | Mifflin | Pennsylvania | 42087 | 12117 | 266 |
2235046 | 2235046 | 2022-02-20 | Mifflin | Pennsylvania | 42087 | 12117 | 266 |
2231795 | 2231795 | 2022-02-19 | Mifflin | Pennsylvania | 42087 | 12106 | 266 |
2228544 | 2228544 | 2022-02-18 | Mifflin | Pennsylvania | 42087 | 12096 | 266 |
2225293 | 2225293 | 2022-02-17 | Mifflin | Pennsylvania | 42087 | 12085 | 266 |
2222042 | 2222042 | 2022-02-16 | Mifflin | Pennsylvania | 42087 | 12062 | 266 |
2218791 | 2218791 | 2022-02-15 | Mifflin | Pennsylvania | 42087 | 12038 | 263 |
2215540 | 2215540 | 2022-02-14 | Mifflin | Pennsylvania | 42087 | 12020 | 263 |
2212289 | 2212289 | 2022-02-13 | Mifflin | Pennsylvania | 42087 | 12009 | 262 |
2209036 | 2209036 | 2022-02-12 | Mifflin | Pennsylvania | 42087 | 11981 | 262 |
2205783 | 2205783 | 2022-02-11 | Mifflin | Pennsylvania | 42087 | 11951 | 262 |
2202530 | 2202530 | 2022-02-10 | Mifflin | Pennsylvania | 42087 | 11917 | 262 |
2199276 | 2199276 | 2022-02-09 | Mifflin | Pennsylvania | 42087 | 11888 | 261 |
2196022 | 2196022 | 2022-02-08 | Mifflin | Pennsylvania | 42087 | 11834 | 261 |
2192768 | 2192768 | 2022-02-07 | Mifflin | Pennsylvania | 42087 | 11823 | 261 |
2189514 | 2189514 | 2022-02-06 | Mifflin | Pennsylvania | 42087 | 11796 | 261 |
2186261 | 2186261 | 2022-02-05 | Mifflin | Pennsylvania | 42087 | 11779 | 261 |
2183009 | 2183009 | 2022-02-04 | Mifflin | Pennsylvania | 42087 | 11713 | 261 |
2179757 | 2179757 | 2022-02-03 | Mifflin | Pennsylvania | 42087 | 11655 | 261 |
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);