ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 42063 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 |
---|---|---|---|---|---|---|---|
2501878 | 2501878 | 2022-05-13 | Indiana | Pennsylvania | 42063 | 17690 | 356 |
2498620 | 2498620 | 2022-05-12 | Indiana | Pennsylvania | 42063 | 17690 | 356 |
2495362 | 2495362 | 2022-05-11 | Indiana | Pennsylvania | 42063 | 17690 | 356 |
2492104 | 2492104 | 2022-05-10 | Indiana | Pennsylvania | 42063 | 17563 | 356 |
2488846 | 2488846 | 2022-05-09 | Indiana | Pennsylvania | 42063 | 17563 | 356 |
2485589 | 2485589 | 2022-05-08 | Indiana | Pennsylvania | 42063 | 17563 | 356 |
2482331 | 2482331 | 2022-05-07 | Indiana | Pennsylvania | 42063 | 17563 | 356 |
2479073 | 2479073 | 2022-05-06 | Indiana | Pennsylvania | 42063 | 17563 | 356 |
2475815 | 2475815 | 2022-05-05 | Indiana | Pennsylvania | 42063 | 17563 | 356 |
2472558 | 2472558 | 2022-05-04 | Indiana | Pennsylvania | 42063 | 17563 | 356 |
2469302 | 2469302 | 2022-05-03 | Indiana | Pennsylvania | 42063 | 17550 | 356 |
2466046 | 2466046 | 2022-05-02 | Indiana | Pennsylvania | 42063 | 17542 | 356 |
2462791 | 2462791 | 2022-05-01 | Indiana | Pennsylvania | 42063 | 17535 | 356 |
2459535 | 2459535 | 2022-04-30 | Indiana | Pennsylvania | 42063 | 17529 | 356 |
2456279 | 2456279 | 2022-04-29 | Indiana | Pennsylvania | 42063 | 17522 | 355 |
2453023 | 2453023 | 2022-04-28 | Indiana | Pennsylvania | 42063 | 17515 | 355 |
2449767 | 2449767 | 2022-04-27 | Indiana | Pennsylvania | 42063 | 17501 | 355 |
2446510 | 2446510 | 2022-04-26 | Indiana | Pennsylvania | 42063 | 17496 | 355 |
2443255 | 2443255 | 2022-04-25 | Indiana | Pennsylvania | 42063 | 17490 | 355 |
2439999 | 2439999 | 2022-04-24 | Indiana | Pennsylvania | 42063 | 17487 | 355 |
2436743 | 2436743 | 2022-04-23 | Indiana | Pennsylvania | 42063 | 17482 | 355 |
2433487 | 2433487 | 2022-04-22 | Indiana | Pennsylvania | 42063 | 17468 | 355 |
2430231 | 2430231 | 2022-04-21 | Indiana | Pennsylvania | 42063 | 17466 | 355 |
2426975 | 2426975 | 2022-04-20 | Indiana | Pennsylvania | 42063 | 17455 | 354 |
2423719 | 2423719 | 2022-04-19 | Indiana | Pennsylvania | 42063 | 17444 | 354 |
2420463 | 2420463 | 2022-04-18 | Indiana | Pennsylvania | 42063 | 17440 | 354 |
2417207 | 2417207 | 2022-04-17 | Indiana | Pennsylvania | 42063 | 17438 | 354 |
2413951 | 2413951 | 2022-04-16 | Indiana | Pennsylvania | 42063 | 17434 | 354 |
2410695 | 2410695 | 2022-04-15 | Indiana | Pennsylvania | 42063 | 17429 | 354 |
2407439 | 2407439 | 2022-04-14 | Indiana | Pennsylvania | 42063 | 17424 | 354 |
2404183 | 2404183 | 2022-04-13 | Indiana | Pennsylvania | 42063 | 17424 | 354 |
2400928 | 2400928 | 2022-04-12 | Indiana | Pennsylvania | 42063 | 17415 | 354 |
2397673 | 2397673 | 2022-04-11 | Indiana | Pennsylvania | 42063 | 17410 | 354 |
2394418 | 2394418 | 2022-04-10 | Indiana | Pennsylvania | 42063 | 17409 | 354 |
2391162 | 2391162 | 2022-04-09 | Indiana | Pennsylvania | 42063 | 17405 | 354 |
2387906 | 2387906 | 2022-04-08 | Indiana | Pennsylvania | 42063 | 17403 | 353 |
2384651 | 2384651 | 2022-04-07 | Indiana | Pennsylvania | 42063 | 17401 | 353 |
2381396 | 2381396 | 2022-04-06 | Indiana | Pennsylvania | 42063 | 17390 | 353 |
2378141 | 2378141 | 2022-04-05 | Indiana | Pennsylvania | 42063 | 17389 | 352 |
2374887 | 2374887 | 2022-04-04 | Indiana | Pennsylvania | 42063 | 17389 | 352 |
2371635 | 2371635 | 2022-04-03 | Indiana | Pennsylvania | 42063 | 17388 | 352 |
2368382 | 2368382 | 2022-04-02 | Indiana | Pennsylvania | 42063 | 17388 | 352 |
2365129 | 2365129 | 2022-04-01 | Indiana | Pennsylvania | 42063 | 17384 | 352 |
2361876 | 2361876 | 2022-03-31 | Indiana | Pennsylvania | 42063 | 17384 | 352 |
2358622 | 2358622 | 2022-03-30 | Indiana | Pennsylvania | 42063 | 17380 | 352 |
2355368 | 2355368 | 2022-03-29 | Indiana | Pennsylvania | 42063 | 17377 | 352 |
2352115 | 2352115 | 2022-03-28 | Indiana | Pennsylvania | 42063 | 17372 | 351 |
2348863 | 2348863 | 2022-03-27 | Indiana | Pennsylvania | 42063 | 17372 | 351 |
2345610 | 2345610 | 2022-03-26 | Indiana | Pennsylvania | 42063 | 17369 | 351 |
2342357 | 2342357 | 2022-03-25 | Indiana | Pennsylvania | 42063 | 17368 | 351 |
2339104 | 2339104 | 2022-03-24 | Indiana | Pennsylvania | 42063 | 17367 | 351 |
2335850 | 2335850 | 2022-03-23 | Indiana | Pennsylvania | 42063 | 17361 | 351 |
2332596 | 2332596 | 2022-03-22 | Indiana | Pennsylvania | 42063 | 17360 | 351 |
2329343 | 2329343 | 2022-03-21 | Indiana | Pennsylvania | 42063 | 17357 | 351 |
2326091 | 2326091 | 2022-03-20 | Indiana | Pennsylvania | 42063 | 17356 | 351 |
2322838 | 2322838 | 2022-03-19 | Indiana | Pennsylvania | 42063 | 17352 | 350 |
2319584 | 2319584 | 2022-03-18 | Indiana | Pennsylvania | 42063 | 17349 | 350 |
2316330 | 2316330 | 2022-03-17 | Indiana | Pennsylvania | 42063 | 17343 | 350 |
2313077 | 2313077 | 2022-03-16 | Indiana | Pennsylvania | 42063 | 17337 | 349 |
2309824 | 2309824 | 2022-03-15 | Indiana | Pennsylvania | 42063 | 17330 | 349 |
2306571 | 2306571 | 2022-03-14 | Indiana | Pennsylvania | 42063 | 17322 | 348 |
2303320 | 2303320 | 2022-03-13 | Indiana | Pennsylvania | 42063 | 17322 | 348 |
2300068 | 2300068 | 2022-03-12 | Indiana | Pennsylvania | 42063 | 17317 | 348 |
2296816 | 2296816 | 2022-03-11 | Indiana | Pennsylvania | 42063 | 17303 | 348 |
2293564 | 2293564 | 2022-03-10 | Indiana | Pennsylvania | 42063 | 17295 | 347 |
2290312 | 2290312 | 2022-03-09 | Indiana | Pennsylvania | 42063 | 17284 | 346 |
2287060 | 2287060 | 2022-03-08 | Indiana | Pennsylvania | 42063 | 17269 | 346 |
2283808 | 2283808 | 2022-03-07 | Indiana | Pennsylvania | 42063 | 17259 | 346 |
2280556 | 2280556 | 2022-03-06 | Indiana | Pennsylvania | 42063 | 17250 | 346 |
2277303 | 2277303 | 2022-03-05 | Indiana | Pennsylvania | 42063 | 17245 | 344 |
2274050 | 2274050 | 2022-03-04 | Indiana | Pennsylvania | 42063 | 17239 | 344 |
2270797 | 2270797 | 2022-03-03 | Indiana | Pennsylvania | 42063 | 17225 | 344 |
2267545 | 2267545 | 2022-03-02 | Indiana | Pennsylvania | 42063 | 17205 | 344 |
2264292 | 2264292 | 2022-03-01 | Indiana | Pennsylvania | 42063 | 17195 | 344 |
2261042 | 2261042 | 2022-02-28 | Indiana | Pennsylvania | 42063 | 17183 | 343 |
2257791 | 2257791 | 2022-02-27 | Indiana | Pennsylvania | 42063 | 17169 | 343 |
2254540 | 2254540 | 2022-02-26 | Indiana | Pennsylvania | 42063 | 17161 | 343 |
2251289 | 2251289 | 2022-02-25 | Indiana | Pennsylvania | 42063 | 17137 | 342 |
2248038 | 2248038 | 2022-02-24 | Indiana | Pennsylvania | 42063 | 17127 | 340 |
2244787 | 2244787 | 2022-02-23 | Indiana | Pennsylvania | 42063 | 17112 | 340 |
2241536 | 2241536 | 2022-02-22 | Indiana | Pennsylvania | 42063 | 17075 | 337 |
2238285 | 2238285 | 2022-02-21 | Indiana | Pennsylvania | 42063 | 17046 | 337 |
2235034 | 2235034 | 2022-02-20 | Indiana | Pennsylvania | 42063 | 17046 | 337 |
2231783 | 2231783 | 2022-02-19 | Indiana | Pennsylvania | 42063 | 17027 | 332 |
2228532 | 2228532 | 2022-02-18 | Indiana | Pennsylvania | 42063 | 16989 | 332 |
2225281 | 2225281 | 2022-02-17 | Indiana | Pennsylvania | 42063 | 16965 | 332 |
2222030 | 2222030 | 2022-02-16 | Indiana | Pennsylvania | 42063 | 16933 | 330 |
2218779 | 2218779 | 2022-02-15 | Indiana | Pennsylvania | 42063 | 16888 | 330 |
2215528 | 2215528 | 2022-02-14 | Indiana | Pennsylvania | 42063 | 16866 | 330 |
2212277 | 2212277 | 2022-02-13 | Indiana | Pennsylvania | 42063 | 16844 | 330 |
2209024 | 2209024 | 2022-02-12 | Indiana | Pennsylvania | 42063 | 16824 | 330 |
2205771 | 2205771 | 2022-02-11 | Indiana | Pennsylvania | 42063 | 16776 | 330 |
2202518 | 2202518 | 2022-02-10 | Indiana | Pennsylvania | 42063 | 16743 | 328 |
2199264 | 2199264 | 2022-02-09 | Indiana | Pennsylvania | 42063 | 16685 | 328 |
2196010 | 2196010 | 2022-02-08 | Indiana | Pennsylvania | 42063 | 16627 | 328 |
2192756 | 2192756 | 2022-02-07 | Indiana | Pennsylvania | 42063 | 16638 | 328 |
2189502 | 2189502 | 2022-02-06 | Indiana | Pennsylvania | 42063 | 16590 | 328 |
2186249 | 2186249 | 2022-02-05 | Indiana | Pennsylvania | 42063 | 16542 | 328 |
2182997 | 2182997 | 2022-02-04 | Indiana | Pennsylvania | 42063 | 16480 | 327 |
2179745 | 2179745 | 2022-02-03 | Indiana | Pennsylvania | 42063 | 16409 | 326 |
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);