ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 42123 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718218 | 1718218 | 2021-09-14 | Warren | Pennsylvania | 42123 | 3035 | 111 |
1714970 | 1714970 | 2021-09-13 | Warren | Pennsylvania | 42123 | 2997 | 110 |
1711724 | 1711724 | 2021-09-12 | Warren | Pennsylvania | 42123 | 2996 | 110 |
1708477 | 1708477 | 2021-09-11 | Warren | Pennsylvania | 42123 | 2989 | 110 |
1705230 | 1705230 | 2021-09-10 | Warren | Pennsylvania | 42123 | 2977 | 110 |
1701980 | 1701980 | 2021-09-09 | Warren | Pennsylvania | 42123 | 2952 | 110 |
1698731 | 1698731 | 2021-09-08 | Warren | Pennsylvania | 42123 | 2931 | 110 |
1695483 | 1695483 | 2021-09-07 | Warren | Pennsylvania | 42123 | 2902 | 110 |
1692235 | 1692235 | 2021-09-06 | Warren | Pennsylvania | 42123 | 2900 | 109 |
1688986 | 1688986 | 2021-09-05 | Warren | Pennsylvania | 42123 | 2898 | 109 |
1685736 | 1685736 | 2021-09-04 | Warren | Pennsylvania | 42123 | 2898 | 108 |
1682485 | 1682485 | 2021-09-03 | Warren | Pennsylvania | 42123 | 2881 | 107 |
1679235 | 1679235 | 2021-09-02 | Warren | Pennsylvania | 42123 | 2852 | 107 |
1675987 | 1675987 | 2021-09-01 | Warren | Pennsylvania | 42123 | 2840 | 107 |
1672740 | 1672740 | 2021-08-31 | Warren | Pennsylvania | 42123 | 2835 | 107 |
1669492 | 1669492 | 2021-08-30 | Warren | Pennsylvania | 42123 | 2808 | 107 |
1666245 | 1666245 | 2021-08-29 | Warren | Pennsylvania | 42123 | 2804 | 107 |
1662997 | 1662997 | 2021-08-28 | Warren | Pennsylvania | 42123 | 2801 | 107 |
1659749 | 1659749 | 2021-08-27 | Warren | Pennsylvania | 42123 | 2794 | 107 |
1656500 | 1656500 | 2021-08-26 | Warren | Pennsylvania | 42123 | 2771 | 107 |
1653253 | 1653253 | 2021-08-25 | Warren | Pennsylvania | 42123 | 2764 | 107 |
1650006 | 1650006 | 2021-08-24 | Warren | Pennsylvania | 42123 | 2747 | 107 |
1646757 | 1646757 | 2021-08-23 | Warren | Pennsylvania | 42123 | 2741 | 107 |
1643508 | 1643508 | 2021-08-22 | Warren | Pennsylvania | 42123 | 2740 | 107 |
1640258 | 1640258 | 2021-08-21 | Warren | Pennsylvania | 42123 | 2740 | 107 |
1637008 | 1637008 | 2021-08-20 | Warren | Pennsylvania | 42123 | 2727 | 107 |
1633758 | 1633758 | 2021-08-19 | Warren | Pennsylvania | 42123 | 2718 | 107 |
1630511 | 1630511 | 2021-08-18 | Warren | Pennsylvania | 42123 | 2709 | 107 |
1627264 | 1627264 | 2021-08-17 | Warren | Pennsylvania | 42123 | 2702 | 107 |
1624017 | 1624017 | 2021-08-16 | Warren | Pennsylvania | 42123 | 2688 | 107 |
1620770 | 1620770 | 2021-08-15 | Warren | Pennsylvania | 42123 | 2686 | 107 |
1617522 | 1617522 | 2021-08-14 | Warren | Pennsylvania | 42123 | 2686 | 107 |
1614274 | 1614274 | 2021-08-13 | Warren | Pennsylvania | 42123 | 2681 | 107 |
1611025 | 1611025 | 2021-08-12 | Warren | Pennsylvania | 42123 | 2677 | 107 |
1607777 | 1607777 | 2021-08-11 | Warren | Pennsylvania | 42123 | 2676 | 107 |
1604528 | 1604528 | 2021-08-10 | Warren | Pennsylvania | 42123 | 2672 | 107 |
1601279 | 1601279 | 2021-08-09 | Warren | Pennsylvania | 42123 | 2669 | 106 |
1598031 | 1598031 | 2021-08-08 | Warren | Pennsylvania | 42123 | 2668 | 106 |
1594782 | 1594782 | 2021-08-07 | Warren | Pennsylvania | 42123 | 2668 | 106 |
1591533 | 1591533 | 2021-08-06 | Warren | Pennsylvania | 42123 | 2668 | 106 |
1588284 | 1588284 | 2021-08-05 | Warren | Pennsylvania | 42123 | 2666 | 106 |
1585034 | 1585034 | 2021-08-04 | Warren | Pennsylvania | 42123 | 2665 | 106 |
1581784 | 1581784 | 2021-08-03 | Warren | Pennsylvania | 42123 | 2664 | 106 |
1578535 | 1578535 | 2021-08-02 | Warren | Pennsylvania | 42123 | 2661 | 106 |
1575287 | 1575287 | 2021-08-01 | Warren | Pennsylvania | 42123 | 2661 | 106 |
1572039 | 1572039 | 2021-07-31 | Warren | Pennsylvania | 42123 | 2660 | 106 |
1568791 | 1568791 | 2021-07-30 | Warren | Pennsylvania | 42123 | 2660 | 106 |
1565543 | 1565543 | 2021-07-29 | Warren | Pennsylvania | 42123 | 2659 | 106 |
1562295 | 1562295 | 2021-07-28 | Warren | Pennsylvania | 42123 | 2658 | 106 |
1559047 | 1559047 | 2021-07-27 | Warren | Pennsylvania | 42123 | 2658 | 106 |
1555800 | 1555800 | 2021-07-26 | Warren | Pennsylvania | 42123 | 2655 | 106 |
1552553 | 1552553 | 2021-07-25 | Warren | Pennsylvania | 42123 | 2654 | 106 |
1549306 | 1549306 | 2021-07-24 | Warren | Pennsylvania | 42123 | 2654 | 106 |
1546059 | 1546059 | 2021-07-23 | Warren | Pennsylvania | 42123 | 2653 | 106 |
1542812 | 1542812 | 2021-07-22 | Warren | Pennsylvania | 42123 | 2652 | 106 |
1539564 | 1539564 | 2021-07-21 | Warren | Pennsylvania | 42123 | 2652 | 106 |
1536317 | 1536317 | 2021-07-20 | Warren | Pennsylvania | 42123 | 2649 | 106 |
1533069 | 1533069 | 2021-07-19 | Warren | Pennsylvania | 42123 | 2647 | 106 |
1529822 | 1529822 | 2021-07-18 | Warren | Pennsylvania | 42123 | 2647 | 106 |
1526575 | 1526575 | 2021-07-17 | Warren | Pennsylvania | 42123 | 2647 | 106 |
1523328 | 1523328 | 2021-07-16 | Warren | Pennsylvania | 42123 | 2647 | 106 |
1520080 | 1520080 | 2021-07-15 | Warren | Pennsylvania | 42123 | 2646 | 106 |
1516832 | 1516832 | 2021-07-14 | Warren | Pennsylvania | 42123 | 2646 | 106 |
1513585 | 1513585 | 2021-07-13 | Warren | Pennsylvania | 42123 | 2646 | 106 |
1510339 | 1510339 | 2021-07-12 | Warren | Pennsylvania | 42123 | 2646 | 105 |
1507092 | 1507092 | 2021-07-11 | Warren | Pennsylvania | 42123 | 2646 | 105 |
1503846 | 1503846 | 2021-07-10 | Warren | Pennsylvania | 42123 | 2646 | 105 |
1500600 | 1500600 | 2021-07-09 | Warren | Pennsylvania | 42123 | 2645 | 105 |
1497354 | 1497354 | 2021-07-08 | Warren | Pennsylvania | 42123 | 2645 | 105 |
1494107 | 1494107 | 2021-07-07 | Warren | Pennsylvania | 42123 | 2643 | 105 |
1490860 | 1490860 | 2021-07-06 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1487613 | 1487613 | 2021-07-05 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1484366 | 1484366 | 2021-07-04 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1481120 | 1481120 | 2021-07-03 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1477873 | 1477873 | 2021-07-02 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1474627 | 1474627 | 2021-07-01 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1471381 | 1471381 | 2021-06-30 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1468136 | 1468136 | 2021-06-29 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1464891 | 1464891 | 2021-06-28 | Warren | Pennsylvania | 42123 | 2643 | 104 |
1461646 | 1461646 | 2021-06-27 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1458401 | 1458401 | 2021-06-26 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1455156 | 1455156 | 2021-06-25 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1451911 | 1451911 | 2021-06-24 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1448665 | 1448665 | 2021-06-23 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1445420 | 1445420 | 2021-06-22 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1442175 | 1442175 | 2021-06-21 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1438930 | 1438930 | 2021-06-20 | Warren | Pennsylvania | 42123 | 2643 | 103 |
1435683 | 1435683 | 2021-06-19 | Warren | Pennsylvania | 42123 | 2642 | 103 |
1432436 | 1432436 | 2021-06-18 | Warren | Pennsylvania | 42123 | 2638 | 103 |
1429190 | 1429190 | 2021-06-17 | Warren | Pennsylvania | 42123 | 2638 | 103 |
1425945 | 1425945 | 2021-06-16 | Warren | Pennsylvania | 42123 | 2637 | 103 |
1422698 | 1422698 | 2021-06-15 | Warren | Pennsylvania | 42123 | 2637 | 103 |
1419452 | 1419452 | 2021-06-14 | Warren | Pennsylvania | 42123 | 2637 | 103 |
1416207 | 1416207 | 2021-06-13 | Warren | Pennsylvania | 42123 | 2636 | 103 |
1412961 | 1412961 | 2021-06-12 | Warren | Pennsylvania | 42123 | 2636 | 103 |
1409716 | 1409716 | 2021-06-11 | Warren | Pennsylvania | 42123 | 2636 | 103 |
1406471 | 1406471 | 2021-06-10 | Warren | Pennsylvania | 42123 | 2635 | 103 |
1403225 | 1403225 | 2021-06-09 | Warren | Pennsylvania | 42123 | 2633 | 103 |
1399980 | 1399980 | 2021-06-08 | Warren | Pennsylvania | 42123 | 2630 | 103 |
1396735 | 1396735 | 2021-06-07 | Warren | Pennsylvania | 42123 | 2630 | 103 |
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);