ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 42117 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718215 | 1718215 | 2021-09-14 | Tioga | Pennsylvania | 42117 | 3548 | 115 |
1714967 | 1714967 | 2021-09-13 | Tioga | Pennsylvania | 42117 | 3521 | 115 |
1711721 | 1711721 | 2021-09-12 | Tioga | Pennsylvania | 42117 | 3501 | 115 |
1708474 | 1708474 | 2021-09-11 | Tioga | Pennsylvania | 42117 | 3485 | 115 |
1705227 | 1705227 | 2021-09-10 | Tioga | Pennsylvania | 42117 | 3460 | 115 |
1701977 | 1701977 | 2021-09-09 | Tioga | Pennsylvania | 42117 | 3443 | 114 |
1698728 | 1698728 | 2021-09-08 | Tioga | Pennsylvania | 42117 | 3425 | 114 |
1695480 | 1695480 | 2021-09-07 | Tioga | Pennsylvania | 42117 | 3409 | 114 |
1692232 | 1692232 | 2021-09-06 | Tioga | Pennsylvania | 42117 | 3405 | 114 |
1688983 | 1688983 | 2021-09-05 | Tioga | Pennsylvania | 42117 | 3381 | 114 |
1685733 | 1685733 | 2021-09-04 | Tioga | Pennsylvania | 42117 | 3368 | 114 |
1682482 | 1682482 | 2021-09-03 | Tioga | Pennsylvania | 42117 | 3337 | 114 |
1679232 | 1679232 | 2021-09-02 | Tioga | Pennsylvania | 42117 | 3318 | 114 |
1675984 | 1675984 | 2021-09-01 | Tioga | Pennsylvania | 42117 | 3308 | 113 |
1672737 | 1672737 | 2021-08-31 | Tioga | Pennsylvania | 42117 | 3287 | 113 |
1669489 | 1669489 | 2021-08-30 | Tioga | Pennsylvania | 42117 | 3268 | 113 |
1666242 | 1666242 | 2021-08-29 | Tioga | Pennsylvania | 42117 | 3265 | 113 |
1662994 | 1662994 | 2021-08-28 | Tioga | Pennsylvania | 42117 | 3255 | 113 |
1659746 | 1659746 | 2021-08-27 | Tioga | Pennsylvania | 42117 | 3240 | 113 |
1656497 | 1656497 | 2021-08-26 | Tioga | Pennsylvania | 42117 | 3231 | 113 |
1653250 | 1653250 | 2021-08-25 | Tioga | Pennsylvania | 42117 | 3224 | 113 |
1650003 | 1650003 | 2021-08-24 | Tioga | Pennsylvania | 42117 | 3209 | 113 |
1646754 | 1646754 | 2021-08-23 | Tioga | Pennsylvania | 42117 | 3208 | 113 |
1643505 | 1643505 | 2021-08-22 | Tioga | Pennsylvania | 42117 | 3207 | 113 |
1640255 | 1640255 | 2021-08-21 | Tioga | Pennsylvania | 42117 | 3203 | 113 |
1637005 | 1637005 | 2021-08-20 | Tioga | Pennsylvania | 42117 | 3198 | 113 |
1633755 | 1633755 | 2021-08-19 | Tioga | Pennsylvania | 42117 | 3194 | 113 |
1630508 | 1630508 | 2021-08-18 | Tioga | Pennsylvania | 42117 | 3184 | 113 |
1627261 | 1627261 | 2021-08-17 | Tioga | Pennsylvania | 42117 | 3181 | 113 |
1624014 | 1624014 | 2021-08-16 | Tioga | Pennsylvania | 42117 | 3176 | 113 |
1620767 | 1620767 | 2021-08-15 | Tioga | Pennsylvania | 42117 | 3175 | 113 |
1617519 | 1617519 | 2021-08-14 | Tioga | Pennsylvania | 42117 | 3169 | 113 |
1614271 | 1614271 | 2021-08-13 | Tioga | Pennsylvania | 42117 | 3167 | 113 |
1611022 | 1611022 | 2021-08-12 | Tioga | Pennsylvania | 42117 | 3163 | 113 |
1607774 | 1607774 | 2021-08-11 | Tioga | Pennsylvania | 42117 | 3160 | 113 |
1604525 | 1604525 | 2021-08-10 | Tioga | Pennsylvania | 42117 | 3159 | 113 |
1601276 | 1601276 | 2021-08-09 | Tioga | Pennsylvania | 42117 | 3158 | 113 |
1598028 | 1598028 | 2021-08-08 | Tioga | Pennsylvania | 42117 | 3156 | 113 |
1594779 | 1594779 | 2021-08-07 | Tioga | Pennsylvania | 42117 | 3156 | 113 |
1591530 | 1591530 | 2021-08-06 | Tioga | Pennsylvania | 42117 | 3156 | 113 |
1588281 | 1588281 | 2021-08-05 | Tioga | Pennsylvania | 42117 | 3155 | 113 |
1585031 | 1585031 | 2021-08-04 | Tioga | Pennsylvania | 42117 | 3149 | 113 |
1581781 | 1581781 | 2021-08-03 | Tioga | Pennsylvania | 42117 | 3146 | 113 |
1578532 | 1578532 | 2021-08-02 | Tioga | Pennsylvania | 42117 | 3144 | 113 |
1575284 | 1575284 | 2021-08-01 | Tioga | Pennsylvania | 42117 | 3144 | 113 |
1572036 | 1572036 | 2021-07-31 | Tioga | Pennsylvania | 42117 | 3143 | 112 |
1568788 | 1568788 | 2021-07-30 | Tioga | Pennsylvania | 42117 | 3143 | 112 |
1565540 | 1565540 | 2021-07-29 | Tioga | Pennsylvania | 42117 | 3143 | 112 |
1562292 | 1562292 | 2021-07-28 | Tioga | Pennsylvania | 42117 | 3142 | 112 |
1559044 | 1559044 | 2021-07-27 | Tioga | Pennsylvania | 42117 | 3142 | 112 |
1555797 | 1555797 | 2021-07-26 | Tioga | Pennsylvania | 42117 | 3142 | 112 |
1552550 | 1552550 | 2021-07-25 | Tioga | Pennsylvania | 42117 | 3142 | 112 |
1549303 | 1549303 | 2021-07-24 | Tioga | Pennsylvania | 42117 | 3141 | 112 |
1546056 | 1546056 | 2021-07-23 | Tioga | Pennsylvania | 42117 | 3141 | 112 |
1542809 | 1542809 | 2021-07-22 | Tioga | Pennsylvania | 42117 | 3139 | 112 |
1539561 | 1539561 | 2021-07-21 | Tioga | Pennsylvania | 42117 | 3139 | 112 |
1536314 | 1536314 | 2021-07-20 | Tioga | Pennsylvania | 42117 | 3138 | 112 |
1533066 | 1533066 | 2021-07-19 | Tioga | Pennsylvania | 42117 | 3138 | 112 |
1529819 | 1529819 | 2021-07-18 | Tioga | Pennsylvania | 42117 | 3138 | 112 |
1526572 | 1526572 | 2021-07-17 | Tioga | Pennsylvania | 42117 | 3138 | 112 |
1523325 | 1523325 | 2021-07-16 | Tioga | Pennsylvania | 42117 | 3137 | 112 |
1520077 | 1520077 | 2021-07-15 | Tioga | Pennsylvania | 42117 | 3137 | 112 |
1516829 | 1516829 | 2021-07-14 | Tioga | Pennsylvania | 42117 | 3135 | 112 |
1513582 | 1513582 | 2021-07-13 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1510336 | 1510336 | 2021-07-12 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1507089 | 1507089 | 2021-07-11 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1503843 | 1503843 | 2021-07-10 | Tioga | Pennsylvania | 42117 | 3134 | 112 |
1500597 | 1500597 | 2021-07-09 | Tioga | Pennsylvania | 42117 | 3133 | 112 |
1497351 | 1497351 | 2021-07-08 | Tioga | Pennsylvania | 42117 | 3133 | 112 |
1494104 | 1494104 | 2021-07-07 | Tioga | Pennsylvania | 42117 | 3132 | 112 |
1490857 | 1490857 | 2021-07-06 | Tioga | Pennsylvania | 42117 | 3132 | 112 |
1487610 | 1487610 | 2021-07-05 | Tioga | Pennsylvania | 42117 | 3132 | 112 |
1484363 | 1484363 | 2021-07-04 | Tioga | Pennsylvania | 42117 | 3132 | 112 |
1481117 | 1481117 | 2021-07-03 | Tioga | Pennsylvania | 42117 | 3132 | 112 |
1477870 | 1477870 | 2021-07-02 | Tioga | Pennsylvania | 42117 | 3130 | 112 |
1474624 | 1474624 | 2021-07-01 | Tioga | Pennsylvania | 42117 | 3128 | 112 |
1471378 | 1471378 | 2021-06-30 | Tioga | Pennsylvania | 42117 | 3129 | 112 |
1468133 | 1468133 | 2021-06-29 | Tioga | Pennsylvania | 42117 | 3129 | 112 |
1464888 | 1464888 | 2021-06-28 | Tioga | Pennsylvania | 42117 | 3128 | 112 |
1461643 | 1461643 | 2021-06-27 | Tioga | Pennsylvania | 42117 | 3128 | 112 |
1458398 | 1458398 | 2021-06-26 | Tioga | Pennsylvania | 42117 | 3128 | 112 |
1455153 | 1455153 | 2021-06-25 | Tioga | Pennsylvania | 42117 | 3126 | 112 |
1451908 | 1451908 | 2021-06-24 | Tioga | Pennsylvania | 42117 | 3124 | 112 |
1448662 | 1448662 | 2021-06-23 | Tioga | Pennsylvania | 42117 | 3124 | 112 |
1445417 | 1445417 | 2021-06-22 | Tioga | Pennsylvania | 42117 | 3123 | 112 |
1442172 | 1442172 | 2021-06-21 | Tioga | Pennsylvania | 42117 | 3122 | 110 |
1438927 | 1438927 | 2021-06-20 | Tioga | Pennsylvania | 42117 | 3121 | 110 |
1435680 | 1435680 | 2021-06-19 | Tioga | Pennsylvania | 42117 | 3121 | 110 |
1432433 | 1432433 | 2021-06-18 | Tioga | Pennsylvania | 42117 | 3120 | 110 |
1429187 | 1429187 | 2021-06-17 | Tioga | Pennsylvania | 42117 | 3117 | 110 |
1425942 | 1425942 | 2021-06-16 | Tioga | Pennsylvania | 42117 | 3116 | 110 |
1422695 | 1422695 | 2021-06-15 | Tioga | Pennsylvania | 42117 | 3112 | 110 |
1419449 | 1419449 | 2021-06-14 | Tioga | Pennsylvania | 42117 | 3099 | 110 |
1416204 | 1416204 | 2021-06-13 | Tioga | Pennsylvania | 42117 | 3098 | 110 |
1412958 | 1412958 | 2021-06-12 | Tioga | Pennsylvania | 42117 | 3097 | 110 |
1409713 | 1409713 | 2021-06-11 | Tioga | Pennsylvania | 42117 | 3094 | 110 |
1406468 | 1406468 | 2021-06-10 | Tioga | Pennsylvania | 42117 | 3088 | 110 |
1403222 | 1403222 | 2021-06-09 | Tioga | Pennsylvania | 42117 | 3084 | 110 |
1399977 | 1399977 | 2021-06-08 | Tioga | Pennsylvania | 42117 | 3084 | 109 |
1396732 | 1396732 | 2021-06-07 | Tioga | Pennsylvania | 42117 | 3083 | 109 |
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);