ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Erie" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718181 | 1718181 | 2021-09-14 | Erie | Pennsylvania | 42049 | 23753 | 442 |
1714933 | 1714933 | 2021-09-13 | Erie | Pennsylvania | 42049 | 23671 | 440 |
1711687 | 1711687 | 2021-09-12 | Erie | Pennsylvania | 42049 | 23620 | 440 |
1708440 | 1708440 | 2021-09-11 | Erie | Pennsylvania | 42049 | 23504 | 440 |
1705193 | 1705193 | 2021-09-10 | Erie | Pennsylvania | 42049 | 23421 | 439 |
1701943 | 1701943 | 2021-09-09 | Erie | Pennsylvania | 42049 | 23318 | 435 |
1698694 | 1698694 | 2021-09-08 | Erie | Pennsylvania | 42049 | 23246 | 434 |
1695446 | 1695446 | 2021-09-07 | Erie | Pennsylvania | 42049 | 23142 | 434 |
1692198 | 1692198 | 2021-09-06 | Erie | Pennsylvania | 42049 | 23087 | 434 |
1688949 | 1688949 | 2021-09-05 | Erie | Pennsylvania | 42049 | 23018 | 434 |
1685699 | 1685699 | 2021-09-04 | Erie | Pennsylvania | 42049 | 22964 | 434 |
1682448 | 1682448 | 2021-09-03 | Erie | Pennsylvania | 42049 | 22883 | 433 |
1679198 | 1679198 | 2021-09-02 | Erie | Pennsylvania | 42049 | 22790 | 433 |
1675950 | 1675950 | 2021-09-01 | Erie | Pennsylvania | 42049 | 22706 | 429 |
1672703 | 1672703 | 2021-08-31 | Erie | Pennsylvania | 42049 | 22667 | 429 |
1669455 | 1669455 | 2021-08-30 | Erie | Pennsylvania | 42049 | 22592 | 427 |
1666208 | 1666208 | 2021-08-29 | Erie | Pennsylvania | 42049 | 22538 | 427 |
1662960 | 1662960 | 2021-08-28 | Erie | Pennsylvania | 42049 | 22477 | 427 |
1659712 | 1659712 | 2021-08-27 | Erie | Pennsylvania | 42049 | 22413 | 427 |
1656463 | 1656463 | 2021-08-26 | Erie | Pennsylvania | 42049 | 22358 | 426 |
1653216 | 1653216 | 2021-08-25 | Erie | Pennsylvania | 42049 | 22276 | 426 |
1649969 | 1649969 | 2021-08-24 | Erie | Pennsylvania | 42049 | 22190 | 426 |
1646720 | 1646720 | 2021-08-23 | Erie | Pennsylvania | 42049 | 22147 | 426 |
1643471 | 1643471 | 2021-08-22 | Erie | Pennsylvania | 42049 | 22112 | 426 |
1640221 | 1640221 | 2021-08-21 | Erie | Pennsylvania | 42049 | 22075 | 426 |
1636971 | 1636971 | 2021-08-20 | Erie | Pennsylvania | 42049 | 22022 | 425 |
1633721 | 1633721 | 2021-08-19 | Erie | Pennsylvania | 42049 | 21978 | 423 |
1630474 | 1630474 | 2021-08-18 | Erie | Pennsylvania | 42049 | 21920 | 423 |
1627227 | 1627227 | 2021-08-17 | Erie | Pennsylvania | 42049 | 21889 | 422 |
1623980 | 1623980 | 2021-08-16 | Erie | Pennsylvania | 42049 | 21855 | 422 |
1620733 | 1620733 | 2021-08-15 | Erie | Pennsylvania | 42049 | 21821 | 422 |
1617485 | 1617485 | 2021-08-14 | Erie | Pennsylvania | 42049 | 21773 | 422 |
1614237 | 1614237 | 2021-08-13 | Erie | Pennsylvania | 42049 | 21739 | 422 |
1610988 | 1610988 | 2021-08-12 | Erie | Pennsylvania | 42049 | 21709 | 422 |
1607740 | 1607740 | 2021-08-11 | Erie | Pennsylvania | 42049 | 21651 | 421 |
1604491 | 1604491 | 2021-08-10 | Erie | Pennsylvania | 42049 | 21624 | 421 |
1601242 | 1601242 | 2021-08-09 | Erie | Pennsylvania | 42049 | 21596 | 420 |
1597994 | 1597994 | 2021-08-08 | Erie | Pennsylvania | 42049 | 21550 | 420 |
1594745 | 1594745 | 2021-08-07 | Erie | Pennsylvania | 42049 | 21550 | 420 |
1591496 | 1591496 | 2021-08-06 | Erie | Pennsylvania | 42049 | 21531 | 420 |
1588247 | 1588247 | 2021-08-05 | Erie | Pennsylvania | 42049 | 21502 | 420 |
1584997 | 1584997 | 2021-08-04 | Erie | Pennsylvania | 42049 | 21476 | 419 |
1581747 | 1581747 | 2021-08-03 | Erie | Pennsylvania | 42049 | 21451 | 419 |
1578498 | 1578498 | 2021-08-02 | Erie | Pennsylvania | 42049 | 21430 | 419 |
1575250 | 1575250 | 2021-08-01 | Erie | Pennsylvania | 42049 | 21407 | 419 |
1572002 | 1572002 | 2021-07-31 | Erie | Pennsylvania | 42049 | 21370 | 419 |
1568754 | 1568754 | 2021-07-30 | Erie | Pennsylvania | 42049 | 21370 | 419 |
1565506 | 1565506 | 2021-07-29 | Erie | Pennsylvania | 42049 | 21354 | 419 |
1562258 | 1562258 | 2021-07-28 | Erie | Pennsylvania | 42049 | 21342 | 419 |
1559010 | 1559010 | 2021-07-27 | Erie | Pennsylvania | 42049 | 21336 | 419 |
1555763 | 1555763 | 2021-07-26 | Erie | Pennsylvania | 42049 | 21320 | 419 |
1552516 | 1552516 | 2021-07-25 | Erie | Pennsylvania | 42049 | 21313 | 419 |
1549269 | 1549269 | 2021-07-24 | Erie | Pennsylvania | 42049 | 21308 | 419 |
1546022 | 1546022 | 2021-07-23 | Erie | Pennsylvania | 42049 | 21298 | 419 |
1542775 | 1542775 | 2021-07-22 | Erie | Pennsylvania | 42049 | 21292 | 419 |
1539527 | 1539527 | 2021-07-21 | Erie | Pennsylvania | 42049 | 21289 | 419 |
1536280 | 1536280 | 2021-07-20 | Erie | Pennsylvania | 42049 | 21284 | 419 |
1533032 | 1533032 | 2021-07-19 | Erie | Pennsylvania | 42049 | 21279 | 419 |
1529785 | 1529785 | 2021-07-18 | Erie | Pennsylvania | 42049 | 21273 | 419 |
1526538 | 1526538 | 2021-07-17 | Erie | Pennsylvania | 42049 | 21270 | 419 |
1523291 | 1523291 | 2021-07-16 | Erie | Pennsylvania | 42049 | 21267 | 419 |
1520043 | 1520043 | 2021-07-15 | Erie | Pennsylvania | 42049 | 21257 | 419 |
1516795 | 1516795 | 2021-07-14 | Erie | Pennsylvania | 42049 | 21255 | 419 |
1513548 | 1513548 | 2021-07-13 | Erie | Pennsylvania | 42049 | 21253 | 419 |
1510302 | 1510302 | 2021-07-12 | Erie | Pennsylvania | 42049 | 21249 | 419 |
1507055 | 1507055 | 2021-07-11 | Erie | Pennsylvania | 42049 | 21248 | 419 |
1503809 | 1503809 | 2021-07-10 | Erie | Pennsylvania | 42049 | 21248 | 419 |
1500563 | 1500563 | 2021-07-09 | Erie | Pennsylvania | 42049 | 21244 | 418 |
1497317 | 1497317 | 2021-07-08 | Erie | Pennsylvania | 42049 | 21238 | 417 |
1494070 | 1494070 | 2021-07-07 | Erie | Pennsylvania | 42049 | 21235 | 417 |
1490823 | 1490823 | 2021-07-06 | Erie | Pennsylvania | 42049 | 21236 | 417 |
1487576 | 1487576 | 2021-07-05 | Erie | Pennsylvania | 42049 | 21235 | 417 |
1484329 | 1484329 | 2021-07-04 | Erie | Pennsylvania | 42049 | 21233 | 417 |
1481083 | 1481083 | 2021-07-03 | Erie | Pennsylvania | 42049 | 21230 | 417 |
1477836 | 1477836 | 2021-07-02 | Erie | Pennsylvania | 42049 | 21231 | 417 |
1474590 | 1474590 | 2021-07-01 | Erie | Pennsylvania | 42049 | 21226 | 417 |
1471344 | 1471344 | 2021-06-30 | Erie | Pennsylvania | 42049 | 21224 | 417 |
1468099 | 1468099 | 2021-06-29 | Erie | Pennsylvania | 42049 | 21220 | 417 |
1464854 | 1464854 | 2021-06-28 | Erie | Pennsylvania | 42049 | 21220 | 417 |
1461609 | 1461609 | 2021-06-27 | Erie | Pennsylvania | 42049 | 21218 | 417 |
1458364 | 1458364 | 2021-06-26 | Erie | Pennsylvania | 42049 | 21217 | 417 |
1455119 | 1455119 | 2021-06-25 | Erie | Pennsylvania | 42049 | 21215 | 417 |
1451874 | 1451874 | 2021-06-24 | Erie | Pennsylvania | 42049 | 21214 | 417 |
1448628 | 1448628 | 2021-06-23 | Erie | Pennsylvania | 42049 | 21208 | 417 |
1445383 | 1445383 | 2021-06-22 | Erie | Pennsylvania | 42049 | 21203 | 417 |
1442138 | 1442138 | 2021-06-21 | Erie | Pennsylvania | 42049 | 21194 | 417 |
1438893 | 1438893 | 2021-06-20 | Erie | Pennsylvania | 42049 | 21193 | 417 |
1435646 | 1435646 | 2021-06-19 | Erie | Pennsylvania | 42049 | 21192 | 417 |
1432399 | 1432399 | 2021-06-18 | Erie | Pennsylvania | 42049 | 21192 | 417 |
1429153 | 1429153 | 2021-06-17 | Erie | Pennsylvania | 42049 | 21183 | 417 |
1425908 | 1425908 | 2021-06-16 | Erie | Pennsylvania | 42049 | 21179 | 417 |
1422661 | 1422661 | 2021-06-15 | Erie | Pennsylvania | 42049 | 21177 | 416 |
1419415 | 1419415 | 2021-06-14 | Erie | Pennsylvania | 42049 | 21173 | 416 |
1416170 | 1416170 | 2021-06-13 | Erie | Pennsylvania | 42049 | 21171 | 416 |
1412924 | 1412924 | 2021-06-12 | Erie | Pennsylvania | 42049 | 21168 | 416 |
1409679 | 1409679 | 2021-06-11 | Erie | Pennsylvania | 42049 | 21162 | 416 |
1406434 | 1406434 | 2021-06-10 | Erie | Pennsylvania | 42049 | 21159 | 415 |
1403188 | 1403188 | 2021-06-09 | Erie | Pennsylvania | 42049 | 21146 | 415 |
1399943 | 1399943 | 2021-06-08 | Erie | Pennsylvania | 42049 | 21135 | 416 |
1396698 | 1396698 | 2021-06-07 | Erie | Pennsylvania | 42049 | 21121 | 416 |
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);