ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 42081 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 |
---|---|---|---|---|---|---|---|
2501887 | 2501887 | 2022-05-13 | Lycoming | Pennsylvania | 42081 | 28894 | 522 |
2498629 | 2498629 | 2022-05-12 | Lycoming | Pennsylvania | 42081 | 28894 | 522 |
2495371 | 2495371 | 2022-05-11 | Lycoming | Pennsylvania | 42081 | 28894 | 522 |
2492113 | 2492113 | 2022-05-10 | Lycoming | Pennsylvania | 42081 | 28695 | 520 |
2488855 | 2488855 | 2022-05-09 | Lycoming | Pennsylvania | 42081 | 28695 | 520 |
2485598 | 2485598 | 2022-05-08 | Lycoming | Pennsylvania | 42081 | 28695 | 520 |
2482340 | 2482340 | 2022-05-07 | Lycoming | Pennsylvania | 42081 | 28695 | 520 |
2479082 | 2479082 | 2022-05-06 | Lycoming | Pennsylvania | 42081 | 28695 | 520 |
2475824 | 2475824 | 2022-05-05 | Lycoming | Pennsylvania | 42081 | 28695 | 520 |
2472567 | 2472567 | 2022-05-04 | Lycoming | Pennsylvania | 42081 | 28695 | 520 |
2469311 | 2469311 | 2022-05-03 | Lycoming | Pennsylvania | 42081 | 28676 | 517 |
2466055 | 2466055 | 2022-05-02 | Lycoming | Pennsylvania | 42081 | 28661 | 517 |
2462800 | 2462800 | 2022-05-01 | Lycoming | Pennsylvania | 42081 | 28653 | 517 |
2459544 | 2459544 | 2022-04-30 | Lycoming | Pennsylvania | 42081 | 28638 | 517 |
2456288 | 2456288 | 2022-04-29 | Lycoming | Pennsylvania | 42081 | 28628 | 517 |
2453032 | 2453032 | 2022-04-28 | Lycoming | Pennsylvania | 42081 | 28614 | 516 |
2449776 | 2449776 | 2022-04-27 | Lycoming | Pennsylvania | 42081 | 28596 | 516 |
2446519 | 2446519 | 2022-04-26 | Lycoming | Pennsylvania | 42081 | 28582 | 515 |
2443264 | 2443264 | 2022-04-25 | Lycoming | Pennsylvania | 42081 | 28565 | 515 |
2440008 | 2440008 | 2022-04-24 | Lycoming | Pennsylvania | 42081 | 28558 | 515 |
2436752 | 2436752 | 2022-04-23 | Lycoming | Pennsylvania | 42081 | 28555 | 515 |
2433496 | 2433496 | 2022-04-22 | Lycoming | Pennsylvania | 42081 | 28550 | 515 |
2430240 | 2430240 | 2022-04-21 | Lycoming | Pennsylvania | 42081 | 28537 | 515 |
2426984 | 2426984 | 2022-04-20 | Lycoming | Pennsylvania | 42081 | 28522 | 514 |
2423728 | 2423728 | 2022-04-19 | Lycoming | Pennsylvania | 42081 | 28506 | 514 |
2420472 | 2420472 | 2022-04-18 | Lycoming | Pennsylvania | 42081 | 28485 | 513 |
2417216 | 2417216 | 2022-04-17 | Lycoming | Pennsylvania | 42081 | 28484 | 513 |
2413960 | 2413960 | 2022-04-16 | Lycoming | Pennsylvania | 42081 | 28484 | 513 |
2410704 | 2410704 | 2022-04-15 | Lycoming | Pennsylvania | 42081 | 28479 | 513 |
2407448 | 2407448 | 2022-04-14 | Lycoming | Pennsylvania | 42081 | 28460 | 512 |
2404192 | 2404192 | 2022-04-13 | Lycoming | Pennsylvania | 42081 | 28451 | 512 |
2400937 | 2400937 | 2022-04-12 | Lycoming | Pennsylvania | 42081 | 28446 | 513 |
2397682 | 2397682 | 2022-04-11 | Lycoming | Pennsylvania | 42081 | 28427 | 514 |
2394427 | 2394427 | 2022-04-10 | Lycoming | Pennsylvania | 42081 | 28427 | 514 |
2391171 | 2391171 | 2022-04-09 | Lycoming | Pennsylvania | 42081 | 28418 | 514 |
2387915 | 2387915 | 2022-04-08 | Lycoming | Pennsylvania | 42081 | 28406 | 514 |
2384660 | 2384660 | 2022-04-07 | Lycoming | Pennsylvania | 42081 | 28400 | 513 |
2381405 | 2381405 | 2022-04-06 | Lycoming | Pennsylvania | 42081 | 28391 | 512 |
2378150 | 2378150 | 2022-04-05 | Lycoming | Pennsylvania | 42081 | 28384 | 511 |
2374896 | 2374896 | 2022-04-04 | Lycoming | Pennsylvania | 42081 | 28380 | 511 |
2371644 | 2371644 | 2022-04-03 | Lycoming | Pennsylvania | 42081 | 28380 | 511 |
2368391 | 2368391 | 2022-04-02 | Lycoming | Pennsylvania | 42081 | 28380 | 511 |
2365138 | 2365138 | 2022-04-01 | Lycoming | Pennsylvania | 42081 | 28378 | 511 |
2361885 | 2361885 | 2022-03-31 | Lycoming | Pennsylvania | 42081 | 28377 | 510 |
2358631 | 2358631 | 2022-03-30 | Lycoming | Pennsylvania | 42081 | 28374 | 510 |
2355377 | 2355377 | 2022-03-29 | Lycoming | Pennsylvania | 42081 | 28373 | 510 |
2352124 | 2352124 | 2022-03-28 | Lycoming | Pennsylvania | 42081 | 28372 | 510 |
2348872 | 2348872 | 2022-03-27 | Lycoming | Pennsylvania | 42081 | 28370 | 510 |
2345619 | 2345619 | 2022-03-26 | Lycoming | Pennsylvania | 42081 | 28369 | 510 |
2342366 | 2342366 | 2022-03-25 | Lycoming | Pennsylvania | 42081 | 28367 | 509 |
2339113 | 2339113 | 2022-03-24 | Lycoming | Pennsylvania | 42081 | 28364 | 509 |
2335859 | 2335859 | 2022-03-23 | Lycoming | Pennsylvania | 42081 | 28361 | 508 |
2332605 | 2332605 | 2022-03-22 | Lycoming | Pennsylvania | 42081 | 28360 | 508 |
2329352 | 2329352 | 2022-03-21 | Lycoming | Pennsylvania | 42081 | 28358 | 508 |
2326100 | 2326100 | 2022-03-20 | Lycoming | Pennsylvania | 42081 | 28353 | 508 |
2322847 | 2322847 | 2022-03-19 | Lycoming | Pennsylvania | 42081 | 28349 | 508 |
2319593 | 2319593 | 2022-03-18 | Lycoming | Pennsylvania | 42081 | 28339 | 508 |
2316339 | 2316339 | 2022-03-17 | Lycoming | Pennsylvania | 42081 | 28332 | 507 |
2313086 | 2313086 | 2022-03-16 | Lycoming | Pennsylvania | 42081 | 28329 | 507 |
2309833 | 2309833 | 2022-03-15 | Lycoming | Pennsylvania | 42081 | 28320 | 507 |
2306580 | 2306580 | 2022-03-14 | Lycoming | Pennsylvania | 42081 | 28317 | 507 |
2303329 | 2303329 | 2022-03-13 | Lycoming | Pennsylvania | 42081 | 28314 | 507 |
2300077 | 2300077 | 2022-03-12 | Lycoming | Pennsylvania | 42081 | 28308 | 507 |
2296825 | 2296825 | 2022-03-11 | Lycoming | Pennsylvania | 42081 | 28299 | 507 |
2293573 | 2293573 | 2022-03-10 | Lycoming | Pennsylvania | 42081 | 28291 | 507 |
2290321 | 2290321 | 2022-03-09 | Lycoming | Pennsylvania | 42081 | 28284 | 507 |
2287069 | 2287069 | 2022-03-08 | Lycoming | Pennsylvania | 42081 | 28280 | 507 |
2283817 | 2283817 | 2022-03-07 | Lycoming | Pennsylvania | 42081 | 28264 | 506 |
2280565 | 2280565 | 2022-03-06 | Lycoming | Pennsylvania | 42081 | 28263 | 506 |
2277312 | 2277312 | 2022-03-05 | Lycoming | Pennsylvania | 42081 | 28258 | 506 |
2274059 | 2274059 | 2022-03-04 | Lycoming | Pennsylvania | 42081 | 28244 | 506 |
2270806 | 2270806 | 2022-03-03 | Lycoming | Pennsylvania | 42081 | 28240 | 505 |
2267554 | 2267554 | 2022-03-02 | Lycoming | Pennsylvania | 42081 | 28230 | 504 |
2264301 | 2264301 | 2022-03-01 | Lycoming | Pennsylvania | 42081 | 28219 | 503 |
2261051 | 2261051 | 2022-02-28 | Lycoming | Pennsylvania | 42081 | 28212 | 500 |
2257800 | 2257800 | 2022-02-27 | Lycoming | Pennsylvania | 42081 | 28199 | 500 |
2254549 | 2254549 | 2022-02-26 | Lycoming | Pennsylvania | 42081 | 28193 | 500 |
2251298 | 2251298 | 2022-02-25 | Lycoming | Pennsylvania | 42081 | 28182 | 500 |
2248047 | 2248047 | 2022-02-24 | Lycoming | Pennsylvania | 42081 | 28160 | 500 |
2244796 | 2244796 | 2022-02-23 | Lycoming | Pennsylvania | 42081 | 28146 | 500 |
2241545 | 2241545 | 2022-02-22 | Lycoming | Pennsylvania | 42081 | 28126 | 499 |
2238294 | 2238294 | 2022-02-21 | Lycoming | Pennsylvania | 42081 | 28099 | 499 |
2235043 | 2235043 | 2022-02-20 | Lycoming | Pennsylvania | 42081 | 28099 | 499 |
2231792 | 2231792 | 2022-02-19 | Lycoming | Pennsylvania | 42081 | 28084 | 497 |
2228541 | 2228541 | 2022-02-18 | Lycoming | Pennsylvania | 42081 | 28030 | 497 |
2225290 | 2225290 | 2022-02-17 | Lycoming | Pennsylvania | 42081 | 28008 | 497 |
2222039 | 2222039 | 2022-02-16 | Lycoming | Pennsylvania | 42081 | 27992 | 496 |
2218788 | 2218788 | 2022-02-15 | Lycoming | Pennsylvania | 42081 | 27963 | 496 |
2215537 | 2215537 | 2022-02-14 | Lycoming | Pennsylvania | 42081 | 27923 | 493 |
2212286 | 2212286 | 2022-02-13 | Lycoming | Pennsylvania | 42081 | 27888 | 493 |
2209033 | 2209033 | 2022-02-12 | Lycoming | Pennsylvania | 42081 | 27859 | 493 |
2205780 | 2205780 | 2022-02-11 | Lycoming | Pennsylvania | 42081 | 27803 | 492 |
2202527 | 2202527 | 2022-02-10 | Lycoming | Pennsylvania | 42081 | 27736 | 490 |
2199273 | 2199273 | 2022-02-09 | Lycoming | Pennsylvania | 42081 | 27655 | 489 |
2196019 | 2196019 | 2022-02-08 | Lycoming | Pennsylvania | 42081 | 27597 | 486 |
2192765 | 2192765 | 2022-02-07 | Lycoming | Pennsylvania | 42081 | 27642 | 486 |
2189511 | 2189511 | 2022-02-06 | Lycoming | Pennsylvania | 42081 | 27537 | 485 |
2186258 | 2186258 | 2022-02-05 | Lycoming | Pennsylvania | 42081 | 27500 | 485 |
2183006 | 2183006 | 2022-02-04 | Lycoming | Pennsylvania | 42081 | 27374 | 484 |
2179754 | 2179754 | 2022-02-03 | Lycoming | Pennsylvania | 42081 | 27215 | 484 |
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);