ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Cambria" 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 |
---|---|---|---|---|---|---|---|
2501857 | 2501857 | 2022-05-13 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2498599 | 2498599 | 2022-05-12 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2495341 | 2495341 | 2022-05-11 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2492083 | 2492083 | 2022-05-10 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2488825 | 2488825 | 2022-05-09 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2485568 | 2485568 | 2022-05-08 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2482310 | 2482310 | 2022-05-07 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2479052 | 2479052 | 2022-05-06 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2475794 | 2475794 | 2022-05-05 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2472537 | 2472537 | 2022-05-04 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2469281 | 2469281 | 2022-05-03 | Cambria | Pennsylvania | 42021 | 34782 | 732 |
2466025 | 2466025 | 2022-05-02 | Cambria | Pennsylvania | 42021 | 34761 | 732 |
2462770 | 2462770 | 2022-05-01 | Cambria | Pennsylvania | 42021 | 34756 | 732 |
2459514 | 2459514 | 2022-04-30 | Cambria | Pennsylvania | 42021 | 34750 | 732 |
2456258 | 2456258 | 2022-04-29 | Cambria | Pennsylvania | 42021 | 34725 | 732 |
2453002 | 2453002 | 2022-04-28 | Cambria | Pennsylvania | 42021 | 34711 | 731 |
2449746 | 2449746 | 2022-04-27 | Cambria | Pennsylvania | 42021 | 34700 | 730 |
2446489 | 2446489 | 2022-04-26 | Cambria | Pennsylvania | 42021 | 34685 | 729 |
2443234 | 2443234 | 2022-04-25 | Cambria | Pennsylvania | 42021 | 34668 | 729 |
2439978 | 2439978 | 2022-04-24 | Cambria | Pennsylvania | 42021 | 34660 | 729 |
2436722 | 2436722 | 2022-04-23 | Cambria | Pennsylvania | 42021 | 34656 | 729 |
2433466 | 2433466 | 2022-04-22 | Cambria | Pennsylvania | 42021 | 34650 | 729 |
2430210 | 2430210 | 2022-04-21 | Cambria | Pennsylvania | 42021 | 34643 | 727 |
2426954 | 2426954 | 2022-04-20 | Cambria | Pennsylvania | 42021 | 34636 | 726 |
2423698 | 2423698 | 2022-04-19 | Cambria | Pennsylvania | 42021 | 34627 | 726 |
2420442 | 2420442 | 2022-04-18 | Cambria | Pennsylvania | 42021 | 34614 | 725 |
2417186 | 2417186 | 2022-04-17 | Cambria | Pennsylvania | 42021 | 34610 | 725 |
2413930 | 2413930 | 2022-04-16 | Cambria | Pennsylvania | 42021 | 34608 | 725 |
2410674 | 2410674 | 2022-04-15 | Cambria | Pennsylvania | 42021 | 34599 | 725 |
2407418 | 2407418 | 2022-04-14 | Cambria | Pennsylvania | 42021 | 34590 | 725 |
2404162 | 2404162 | 2022-04-13 | Cambria | Pennsylvania | 42021 | 34583 | 724 |
2400907 | 2400907 | 2022-04-12 | Cambria | Pennsylvania | 42021 | 34574 | 723 |
2397652 | 2397652 | 2022-04-11 | Cambria | Pennsylvania | 42021 | 34568 | 723 |
2394397 | 2394397 | 2022-04-10 | Cambria | Pennsylvania | 42021 | 34568 | 723 |
2391141 | 2391141 | 2022-04-09 | Cambria | Pennsylvania | 42021 | 34567 | 723 |
2387885 | 2387885 | 2022-04-08 | Cambria | Pennsylvania | 42021 | 34561 | 723 |
2384630 | 2384630 | 2022-04-07 | Cambria | Pennsylvania | 42021 | 34557 | 722 |
2381375 | 2381375 | 2022-04-06 | Cambria | Pennsylvania | 42021 | 34547 | 722 |
2378120 | 2378120 | 2022-04-05 | Cambria | Pennsylvania | 42021 | 34545 | 722 |
2374866 | 2374866 | 2022-04-04 | Cambria | Pennsylvania | 42021 | 34539 | 722 |
2371614 | 2371614 | 2022-04-03 | Cambria | Pennsylvania | 42021 | 34538 | 722 |
2368361 | 2368361 | 2022-04-02 | Cambria | Pennsylvania | 42021 | 34538 | 722 |
2365108 | 2365108 | 2022-04-01 | Cambria | Pennsylvania | 42021 | 34534 | 722 |
2361855 | 2361855 | 2022-03-31 | Cambria | Pennsylvania | 42021 | 34529 | 722 |
2358601 | 2358601 | 2022-03-30 | Cambria | Pennsylvania | 42021 | 34525 | 722 |
2355347 | 2355347 | 2022-03-29 | Cambria | Pennsylvania | 42021 | 34515 | 722 |
2352094 | 2352094 | 2022-03-28 | Cambria | Pennsylvania | 42021 | 34509 | 721 |
2348842 | 2348842 | 2022-03-27 | Cambria | Pennsylvania | 42021 | 34505 | 719 |
2345589 | 2345589 | 2022-03-26 | Cambria | Pennsylvania | 42021 | 34502 | 719 |
2342336 | 2342336 | 2022-03-25 | Cambria | Pennsylvania | 42021 | 34497 | 718 |
2339083 | 2339083 | 2022-03-24 | Cambria | Pennsylvania | 42021 | 34489 | 718 |
2335829 | 2335829 | 2022-03-23 | Cambria | Pennsylvania | 42021 | 34486 | 717 |
2332575 | 2332575 | 2022-03-22 | Cambria | Pennsylvania | 42021 | 34480 | 717 |
2329322 | 2329322 | 2022-03-21 | Cambria | Pennsylvania | 42021 | 34470 | 717 |
2326070 | 2326070 | 2022-03-20 | Cambria | Pennsylvania | 42021 | 34466 | 717 |
2322817 | 2322817 | 2022-03-19 | Cambria | Pennsylvania | 42021 | 34463 | 715 |
2319563 | 2319563 | 2022-03-18 | Cambria | Pennsylvania | 42021 | 34456 | 715 |
2316309 | 2316309 | 2022-03-17 | Cambria | Pennsylvania | 42021 | 34445 | 715 |
2313056 | 2313056 | 2022-03-16 | Cambria | Pennsylvania | 42021 | 34434 | 715 |
2309803 | 2309803 | 2022-03-15 | Cambria | Pennsylvania | 42021 | 34429 | 714 |
2306550 | 2306550 | 2022-03-14 | Cambria | Pennsylvania | 42021 | 34419 | 712 |
2303299 | 2303299 | 2022-03-13 | Cambria | Pennsylvania | 42021 | 34416 | 712 |
2300047 | 2300047 | 2022-03-12 | Cambria | Pennsylvania | 42021 | 34410 | 712 |
2296795 | 2296795 | 2022-03-11 | Cambria | Pennsylvania | 42021 | 34402 | 711 |
2293543 | 2293543 | 2022-03-10 | Cambria | Pennsylvania | 42021 | 34392 | 710 |
2290291 | 2290291 | 2022-03-09 | Cambria | Pennsylvania | 42021 | 34371 | 710 |
2287039 | 2287039 | 2022-03-08 | Cambria | Pennsylvania | 42021 | 34360 | 710 |
2283787 | 2283787 | 2022-03-07 | Cambria | Pennsylvania | 42021 | 34351 | 705 |
2280535 | 2280535 | 2022-03-06 | Cambria | Pennsylvania | 42021 | 34345 | 705 |
2277282 | 2277282 | 2022-03-05 | Cambria | Pennsylvania | 42021 | 34341 | 704 |
2274029 | 2274029 | 2022-03-04 | Cambria | Pennsylvania | 42021 | 34325 | 704 |
2270776 | 2270776 | 2022-03-03 | Cambria | Pennsylvania | 42021 | 34314 | 704 |
2267524 | 2267524 | 2022-03-02 | Cambria | Pennsylvania | 42021 | 34293 | 704 |
2264271 | 2264271 | 2022-03-01 | Cambria | Pennsylvania | 42021 | 34280 | 704 |
2261021 | 2261021 | 2022-02-28 | Cambria | Pennsylvania | 42021 | 34258 | 704 |
2257770 | 2257770 | 2022-02-27 | Cambria | Pennsylvania | 42021 | 34252 | 704 |
2254519 | 2254519 | 2022-02-26 | Cambria | Pennsylvania | 42021 | 34248 | 704 |
2251268 | 2251268 | 2022-02-25 | Cambria | Pennsylvania | 42021 | 34228 | 703 |
2248017 | 2248017 | 2022-02-24 | Cambria | Pennsylvania | 42021 | 34196 | 701 |
2244766 | 2244766 | 2022-02-23 | Cambria | Pennsylvania | 42021 | 34176 | 700 |
2241515 | 2241515 | 2022-02-22 | Cambria | Pennsylvania | 42021 | 34141 | 698 |
2238264 | 2238264 | 2022-02-21 | Cambria | Pennsylvania | 42021 | 34080 | 698 |
2235013 | 2235013 | 2022-02-20 | Cambria | Pennsylvania | 42021 | 34080 | 698 |
2231762 | 2231762 | 2022-02-19 | Cambria | Pennsylvania | 42021 | 34059 | 697 |
2228511 | 2228511 | 2022-02-18 | Cambria | Pennsylvania | 42021 | 33989 | 697 |
2225260 | 2225260 | 2022-02-17 | Cambria | Pennsylvania | 42021 | 33952 | 695 |
2222009 | 2222009 | 2022-02-16 | Cambria | Pennsylvania | 42021 | 33893 | 695 |
2218758 | 2218758 | 2022-02-15 | Cambria | Pennsylvania | 42021 | 33869 | 692 |
2215507 | 2215507 | 2022-02-14 | Cambria | Pennsylvania | 42021 | 33818 | 690 |
2212256 | 2212256 | 2022-02-13 | Cambria | Pennsylvania | 42021 | 33789 | 689 |
2209003 | 2209003 | 2022-02-12 | Cambria | Pennsylvania | 42021 | 33757 | 689 |
2205750 | 2205750 | 2022-02-11 | Cambria | Pennsylvania | 42021 | 33649 | 687 |
2202497 | 2202497 | 2022-02-10 | Cambria | Pennsylvania | 42021 | 33586 | 685 |
2199243 | 2199243 | 2022-02-09 | Cambria | Pennsylvania | 42021 | 33506 | 683 |
2195989 | 2195989 | 2022-02-08 | Cambria | Pennsylvania | 42021 | 33438 | 681 |
2192735 | 2192735 | 2022-02-07 | Cambria | Pennsylvania | 42021 | 33459 | 679 |
2189481 | 2189481 | 2022-02-06 | Cambria | Pennsylvania | 42021 | 33361 | 679 |
2186228 | 2186228 | 2022-02-05 | Cambria | Pennsylvania | 42021 | 33324 | 679 |
2182976 | 2182976 | 2022-02-04 | Cambria | Pennsylvania | 42021 | 33141 | 677 |
2179724 | 2179724 | 2022-02-03 | Cambria | Pennsylvania | 42021 | 33038 | 674 |
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);