ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Cambria" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176473 | 2176473 | 2022-02-02 | Cambria | Pennsylvania | 42021 | 32915 | 672 |
2173219 | 2173219 | 2022-02-01 | Cambria | Pennsylvania | 42021 | 32786 | 671 |
2169967 | 2169967 | 2022-01-31 | Cambria | Pennsylvania | 42021 | 32639 | 668 |
2166713 | 2166713 | 2022-01-30 | Cambria | Pennsylvania | 42021 | 32593 | 666 |
2163458 | 2163458 | 2022-01-29 | Cambria | Pennsylvania | 42021 | 32505 | 666 |
2160203 | 2160203 | 2022-01-28 | Cambria | Pennsylvania | 42021 | 32336 | 665 |
2156947 | 2156947 | 2022-01-27 | Cambria | Pennsylvania | 42021 | 32047 | 663 |
2153694 | 2153694 | 2022-01-26 | Cambria | Pennsylvania | 42021 | 31713 | 662 |
2150442 | 2150442 | 2022-01-25 | Cambria | Pennsylvania | 42021 | 31505 | 660 |
2147190 | 2147190 | 2022-01-24 | Cambria | Pennsylvania | 42021 | 31220 | 654 |
2143936 | 2143936 | 2022-01-23 | Cambria | Pennsylvania | 42021 | 31134 | 654 |
2140681 | 2140681 | 2022-01-22 | Cambria | Pennsylvania | 42021 | 30985 | 653 |
2137425 | 2137425 | 2022-01-21 | Cambria | Pennsylvania | 42021 | 30753 | 651 |
2134171 | 2134171 | 2022-01-20 | Cambria | Pennsylvania | 42021 | 30431 | 649 |
2130919 | 2130919 | 2022-01-19 | Cambria | Pennsylvania | 42021 | 30240 | 646 |
2127665 | 2127665 | 2022-01-18 | Cambria | Pennsylvania | 42021 | 29924 | 644 |
2124413 | 2124413 | 2022-01-17 | Cambria | Pennsylvania | 42021 | 29696 | 644 |
2121161 | 2121161 | 2022-01-16 | Cambria | Pennsylvania | 42021 | 29579 | 644 |
2117909 | 2117909 | 2022-01-15 | Cambria | Pennsylvania | 42021 | 28936 | 644 |
2114658 | 2114658 | 2022-01-14 | Cambria | Pennsylvania | 42021 | 28640 | 642 |
2111406 | 2111406 | 2022-01-13 | Cambria | Pennsylvania | 42021 | 28286 | 639 |
2108154 | 2108154 | 2022-01-12 | Cambria | Pennsylvania | 42021 | 28075 | 639 |
2104903 | 2104903 | 2022-01-11 | Cambria | Pennsylvania | 42021 | 27731 | 639 |
2101652 | 2101652 | 2022-01-10 | Cambria | Pennsylvania | 42021 | 27511 | 635 |
2098401 | 2098401 | 2022-01-09 | Cambria | Pennsylvania | 42021 | 27218 | 635 |
2095149 | 2095149 | 2022-01-08 | Cambria | Pennsylvania | 42021 | 26978 | 634 |
2091897 | 2091897 | 2022-01-07 | Cambria | Pennsylvania | 42021 | 26750 | 633 |
2088645 | 2088645 | 2022-01-06 | Cambria | Pennsylvania | 42021 | 26447 | 630 |
2085394 | 2085394 | 2022-01-05 | Cambria | Pennsylvania | 42021 | 26302 | 628 |
2082142 | 2082142 | 2022-01-04 | Cambria | Pennsylvania | 42021 | 26045 | 622 |
2078890 | 2078890 | 2022-01-03 | Cambria | Pennsylvania | 42021 | 25781 | 621 |
2075639 | 2075639 | 2022-01-02 | Cambria | Pennsylvania | 42021 | 25674 | 621 |
2072388 | 2072388 | 2022-01-01 | Cambria | Pennsylvania | 42021 | 25591 | 621 |
2069137 | 2069137 | 2021-12-31 | Cambria | Pennsylvania | 42021 | 25426 | 620 |
2065886 | 2065886 | 2021-12-30 | Cambria | Pennsylvania | 42021 | 25269 | 616 |
2062636 | 2062636 | 2021-12-29 | Cambria | Pennsylvania | 42021 | 25139 | 615 |
2059386 | 2059386 | 2021-12-28 | Cambria | Pennsylvania | 42021 | 25025 | 612 |
2056137 | 2056137 | 2021-12-27 | Cambria | Pennsylvania | 42021 | 24931 | 611 |
2052888 | 2052888 | 2021-12-26 | Cambria | Pennsylvania | 42021 | 24896 | 611 |
2049638 | 2049638 | 2021-12-25 | Cambria | Pennsylvania | 42021 | 24858 | 611 |
2046388 | 2046388 | 2021-12-24 | Cambria | Pennsylvania | 42021 | 24805 | 611 |
2043138 | 2043138 | 2021-12-23 | Cambria | Pennsylvania | 42021 | 24689 | 609 |
2039889 | 2039889 | 2021-12-22 | Cambria | Pennsylvania | 42021 | 24612 | 606 |
2036639 | 2036639 | 2021-12-21 | Cambria | Pennsylvania | 42021 | 24552 | 601 |
2033389 | 2033389 | 2021-12-20 | Cambria | Pennsylvania | 42021 | 24440 | 598 |
2030139 | 2030139 | 2021-12-19 | Cambria | Pennsylvania | 42021 | 24406 | 598 |
2026888 | 2026888 | 2021-12-18 | Cambria | Pennsylvania | 42021 | 24347 | 598 |
2023637 | 2023637 | 2021-12-17 | Cambria | Pennsylvania | 42021 | 24280 | 595 |
2020386 | 2020386 | 2021-12-16 | Cambria | Pennsylvania | 42021 | 24201 | 594 |
2017135 | 2017135 | 2021-12-15 | Cambria | Pennsylvania | 42021 | 24125 | 594 |
2013885 | 2013885 | 2021-12-14 | Cambria | Pennsylvania | 42021 | 24046 | 588 |
2010634 | 2010634 | 2021-12-13 | Cambria | Pennsylvania | 42021 | 23898 | 588 |
2007383 | 2007383 | 2021-12-12 | Cambria | Pennsylvania | 42021 | 23856 | 588 |
2004132 | 2004132 | 2021-12-11 | Cambria | Pennsylvania | 42021 | 23793 | 587 |
2000881 | 2000881 | 2021-12-10 | Cambria | Pennsylvania | 42021 | 23675 | 586 |
1997631 | 1997631 | 2021-12-09 | Cambria | Pennsylvania | 42021 | 23534 | 582 |
1994380 | 1994380 | 2021-12-08 | Cambria | Pennsylvania | 42021 | 23461 | 580 |
1991129 | 1991129 | 2021-12-07 | Cambria | Pennsylvania | 42021 | 23365 | 578 |
1987878 | 1987878 | 2021-12-06 | Cambria | Pennsylvania | 42021 | 23225 | 572 |
1984628 | 1984628 | 2021-12-05 | Cambria | Pennsylvania | 42021 | 23193 | 571 |
1981378 | 1981378 | 2021-12-04 | Cambria | Pennsylvania | 42021 | 23112 | 571 |
1978128 | 1978128 | 2021-12-03 | Cambria | Pennsylvania | 42021 | 22994 | 568 |
1974878 | 1974878 | 2021-12-02 | Cambria | Pennsylvania | 42021 | 22874 | 567 |
1971629 | 1971629 | 2021-12-01 | Cambria | Pennsylvania | 42021 | 22742 | 565 |
1968379 | 1968379 | 2021-11-30 | Cambria | Pennsylvania | 42021 | 22627 | 563 |
1965128 | 1965128 | 2021-11-29 | Cambria | Pennsylvania | 42021 | 22500 | 561 |
1961876 | 1961876 | 2021-11-28 | Cambria | Pennsylvania | 42021 | 22437 | 561 |
1958625 | 1958625 | 2021-11-27 | Cambria | Pennsylvania | 42021 | 22398 | 557 |
1955374 | 1955374 | 2021-11-26 | Cambria | Pennsylvania | 42021 | 22287 | 557 |
1952123 | 1952123 | 2021-11-25 | Cambria | Pennsylvania | 42021 | 22209 | 557 |
1948872 | 1948872 | 2021-11-24 | Cambria | Pennsylvania | 42021 | 22134 | 555 |
1945621 | 1945621 | 2021-11-23 | Cambria | Pennsylvania | 42021 | 21957 | 554 |
1942370 | 1942370 | 2021-11-22 | Cambria | Pennsylvania | 42021 | 21886 | 553 |
1939120 | 1939120 | 2021-11-21 | Cambria | Pennsylvania | 42021 | 21799 | 553 |
1935870 | 1935870 | 2021-11-20 | Cambria | Pennsylvania | 42021 | 21726 | 553 |
1932620 | 1932620 | 2021-11-19 | Cambria | Pennsylvania | 42021 | 21627 | 552 |
1929369 | 1929369 | 2021-11-18 | Cambria | Pennsylvania | 42021 | 21512 | 549 |
1926119 | 1926119 | 2021-11-17 | Cambria | Pennsylvania | 42021 | 21407 | 547 |
1922869 | 1922869 | 2021-11-16 | Cambria | Pennsylvania | 42021 | 21311 | 541 |
1919620 | 1919620 | 2021-11-15 | Cambria | Pennsylvania | 42021 | 21171 | 538 |
1916370 | 1916370 | 2021-11-14 | Cambria | Pennsylvania | 42021 | 21126 | 538 |
1913120 | 1913120 | 2021-11-13 | Cambria | Pennsylvania | 42021 | 21066 | 538 |
1909870 | 1909870 | 2021-11-12 | Cambria | Pennsylvania | 42021 | 20635 | 537 |
1906621 | 1906621 | 2021-11-11 | Cambria | Pennsylvania | 42021 | 20518 | 537 |
1903372 | 1903372 | 2021-11-10 | Cambria | Pennsylvania | 42021 | 20420 | 535 |
1900122 | 1900122 | 2021-11-09 | Cambria | Pennsylvania | 42021 | 20319 | 532 |
1896872 | 1896872 | 2021-11-08 | Cambria | Pennsylvania | 42021 | 20212 | 529 |
1893622 | 1893622 | 2021-11-07 | Cambria | Pennsylvania | 42021 | 20152 | 529 |
1890372 | 1890372 | 2021-11-06 | Cambria | Pennsylvania | 42021 | 20084 | 529 |
1887122 | 1887122 | 2021-11-05 | Cambria | Pennsylvania | 42021 | 20008 | 525 |
1883872 | 1883872 | 2021-11-04 | Cambria | Pennsylvania | 42021 | 19870 | 523 |
1880623 | 1880623 | 2021-11-03 | Cambria | Pennsylvania | 42021 | 19796 | 521 |
1877374 | 1877374 | 2021-11-02 | Cambria | Pennsylvania | 42021 | 19750 | 518 |
1874125 | 1874125 | 2021-11-01 | Cambria | Pennsylvania | 42021 | 19633 | 513 |
1870876 | 1870876 | 2021-10-31 | Cambria | Pennsylvania | 42021 | 19633 | 513 |
1867627 | 1867627 | 2021-10-30 | Cambria | Pennsylvania | 42021 | 19575 | 513 |
1864378 | 1864378 | 2021-10-29 | Cambria | Pennsylvania | 42021 | 19463 | 510 |
1861129 | 1861129 | 2021-10-28 | Cambria | Pennsylvania | 42021 | 19389 | 508 |
1857880 | 1857880 | 2021-10-27 | Cambria | Pennsylvania | 42021 | 19257 | 507 |
1854631 | 1854631 | 2021-10-26 | Cambria | Pennsylvania | 42021 | 19193 | 503 |
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);