ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Monroe" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637190 | 637190 | 2020-10-16 | Monroe | Pennsylvania | 42089 | 1904 | 134 |
633944 | 633944 | 2020-10-15 | Monroe | Pennsylvania | 42089 | 1898 | 134 |
630699 | 630699 | 2020-10-14 | Monroe | Pennsylvania | 42089 | 1893 | 134 |
627455 | 627455 | 2020-10-13 | Monroe | Pennsylvania | 42089 | 1884 | 134 |
624213 | 624213 | 2020-10-12 | Monroe | Pennsylvania | 42089 | 1875 | 134 |
620970 | 620970 | 2020-10-11 | Monroe | Pennsylvania | 42089 | 1866 | 134 |
617727 | 617727 | 2020-10-10 | Monroe | Pennsylvania | 42089 | 1858 | 134 |
614485 | 614485 | 2020-10-09 | Monroe | Pennsylvania | 42089 | 1852 | 134 |
611244 | 611244 | 2020-10-08 | Monroe | Pennsylvania | 42089 | 1848 | 134 |
608002 | 608002 | 2020-10-07 | Monroe | Pennsylvania | 42089 | 1846 | 134 |
604759 | 604759 | 2020-10-06 | Monroe | Pennsylvania | 42089 | 1831 | 134 |
601517 | 601517 | 2020-10-05 | Monroe | Pennsylvania | 42089 | 1829 | 134 |
598274 | 598274 | 2020-10-04 | Monroe | Pennsylvania | 42089 | 1826 | 134 |
595031 | 595031 | 2020-10-03 | Monroe | Pennsylvania | 42089 | 1816 | 134 |
591790 | 591790 | 2020-10-02 | Monroe | Pennsylvania | 42089 | 1816 | 134 |
588549 | 588549 | 2020-10-01 | Monroe | Pennsylvania | 42089 | 1809 | 134 |
585309 | 585309 | 2020-09-30 | Monroe | Pennsylvania | 42089 | 1804 | 133 |
582069 | 582069 | 2020-09-29 | Monroe | Pennsylvania | 42089 | 1801 | 133 |
578829 | 578829 | 2020-09-28 | Monroe | Pennsylvania | 42089 | 1797 | 133 |
575588 | 575588 | 2020-09-27 | Monroe | Pennsylvania | 42089 | 1792 | 133 |
572344 | 572344 | 2020-09-26 | Monroe | Pennsylvania | 42089 | 1790 | 133 |
569102 | 569102 | 2020-09-25 | Monroe | Pennsylvania | 42089 | 1787 | 133 |
565861 | 565861 | 2020-09-24 | Monroe | Pennsylvania | 42089 | 1785 | 133 |
562620 | 562620 | 2020-09-23 | Monroe | Pennsylvania | 42089 | 1780 | 132 |
559383 | 559383 | 2020-09-22 | Monroe | Pennsylvania | 42089 | 1779 | 131 |
556146 | 556146 | 2020-09-21 | Monroe | Pennsylvania | 42089 | 1775 | 130 |
552909 | 552909 | 2020-09-20 | Monroe | Pennsylvania | 42089 | 1773 | 129 |
549670 | 549670 | 2020-09-19 | Monroe | Pennsylvania | 42089 | 1772 | 129 |
546431 | 546431 | 2020-09-18 | Monroe | Pennsylvania | 42089 | 1771 | 129 |
543194 | 543194 | 2020-09-17 | Monroe | Pennsylvania | 42089 | 1770 | 129 |
539958 | 539958 | 2020-09-16 | Monroe | Pennsylvania | 42089 | 1767 | 129 |
536721 | 536721 | 2020-09-15 | Monroe | Pennsylvania | 42089 | 1766 | 129 |
533485 | 533485 | 2020-09-14 | Monroe | Pennsylvania | 42089 | 1759 | 129 |
530250 | 530250 | 2020-09-13 | Monroe | Pennsylvania | 42089 | 1753 | 129 |
527013 | 527013 | 2020-09-12 | Monroe | Pennsylvania | 42089 | 1753 | 129 |
523777 | 523777 | 2020-09-11 | Monroe | Pennsylvania | 42089 | 1753 | 129 |
520541 | 520541 | 2020-09-10 | Monroe | Pennsylvania | 42089 | 1750 | 129 |
517305 | 517305 | 2020-09-09 | Monroe | Pennsylvania | 42089 | 1747 | 129 |
514070 | 514070 | 2020-09-08 | Monroe | Pennsylvania | 42089 | 1742 | 129 |
510837 | 510837 | 2020-09-07 | Monroe | Pennsylvania | 42089 | 1739 | 129 |
507604 | 507604 | 2020-09-06 | Monroe | Pennsylvania | 42089 | 1737 | 129 |
504372 | 504372 | 2020-09-05 | Monroe | Pennsylvania | 42089 | 1735 | 129 |
501138 | 501138 | 2020-09-04 | Monroe | Pennsylvania | 42089 | 1731 | 129 |
497904 | 497904 | 2020-09-03 | Monroe | Pennsylvania | 42089 | 1730 | 129 |
494671 | 494671 | 2020-09-02 | Monroe | Pennsylvania | 42089 | 1720 | 129 |
491437 | 491437 | 2020-09-01 | Monroe | Pennsylvania | 42089 | 1716 | 127 |
488204 | 488204 | 2020-08-31 | Monroe | Pennsylvania | 42089 | 1714 | 127 |
484971 | 484971 | 2020-08-30 | Monroe | Pennsylvania | 42089 | 1712 | 127 |
481736 | 481736 | 2020-08-29 | Monroe | Pennsylvania | 42089 | 1713 | 127 |
478502 | 478502 | 2020-08-28 | Monroe | Pennsylvania | 42089 | 1711 | 127 |
475269 | 475269 | 2020-08-27 | Monroe | Pennsylvania | 42089 | 1704 | 127 |
472035 | 472035 | 2020-08-26 | Monroe | Pennsylvania | 42089 | 1700 | 127 |
468803 | 468803 | 2020-08-25 | Monroe | Pennsylvania | 42089 | 1701 | 127 |
465575 | 465575 | 2020-08-24 | Monroe | Pennsylvania | 42089 | 1694 | 127 |
462346 | 462346 | 2020-08-23 | Monroe | Pennsylvania | 42089 | 1690 | 127 |
459118 | 459118 | 2020-08-22 | Monroe | Pennsylvania | 42089 | 1688 | 127 |
455890 | 455890 | 2020-08-21 | Monroe | Pennsylvania | 42089 | 1686 | 127 |
452662 | 452662 | 2020-08-20 | Monroe | Pennsylvania | 42089 | 1679 | 125 |
449434 | 449434 | 2020-08-19 | Monroe | Pennsylvania | 42089 | 1671 | 125 |
446206 | 446206 | 2020-08-18 | Monroe | Pennsylvania | 42089 | 1670 | 125 |
442980 | 442980 | 2020-08-17 | Monroe | Pennsylvania | 42089 | 1669 | 125 |
439753 | 439753 | 2020-08-16 | Monroe | Pennsylvania | 42089 | 1667 | 125 |
436528 | 436528 | 2020-08-15 | Monroe | Pennsylvania | 42089 | 1663 | 125 |
433301 | 433301 | 2020-08-14 | Monroe | Pennsylvania | 42089 | 1657 | 125 |
430075 | 430075 | 2020-08-13 | Monroe | Pennsylvania | 42089 | 1655 | 124 |
426850 | 426850 | 2020-08-12 | Monroe | Pennsylvania | 42089 | 1650 | 124 |
423627 | 423627 | 2020-08-11 | Monroe | Pennsylvania | 42089 | 1642 | 124 |
420404 | 420404 | 2020-08-10 | Monroe | Pennsylvania | 42089 | 1636 | 124 |
417184 | 417184 | 2020-08-09 | Monroe | Pennsylvania | 42089 | 1634 | 124 |
413963 | 413963 | 2020-08-08 | Monroe | Pennsylvania | 42089 | 1624 | 124 |
410743 | 410743 | 2020-08-07 | Monroe | Pennsylvania | 42089 | 1618 | 124 |
407523 | 407523 | 2020-08-06 | Monroe | Pennsylvania | 42089 | 1614 | 124 |
404304 | 404304 | 2020-08-05 | Monroe | Pennsylvania | 42089 | 1611 | 124 |
401086 | 401086 | 2020-08-04 | Monroe | Pennsylvania | 42089 | 1608 | 124 |
397871 | 397871 | 2020-08-03 | Monroe | Pennsylvania | 42089 | 1598 | 123 |
394654 | 394654 | 2020-08-02 | Monroe | Pennsylvania | 42089 | 1591 | 123 |
391438 | 391438 | 2020-08-01 | Monroe | Pennsylvania | 42089 | 1587 | 123 |
388221 | 388221 | 2020-07-31 | Monroe | Pennsylvania | 42089 | 1580 | 123 |
385004 | 385004 | 2020-07-30 | Monroe | Pennsylvania | 42089 | 1573 | 123 |
381786 | 381786 | 2020-07-29 | Monroe | Pennsylvania | 42089 | 1570 | 123 |
378569 | 378569 | 2020-07-28 | Monroe | Pennsylvania | 42089 | 1562 | 122 |
375353 | 375353 | 2020-07-27 | Monroe | Pennsylvania | 42089 | 1557 | 122 |
372140 | 372140 | 2020-07-26 | Monroe | Pennsylvania | 42089 | 1553 | 121 |
368928 | 368928 | 2020-07-25 | Monroe | Pennsylvania | 42089 | 1551 | 120 |
365719 | 365719 | 2020-07-24 | Monroe | Pennsylvania | 42089 | 1539 | 120 |
362513 | 362513 | 2020-07-23 | Monroe | Pennsylvania | 42089 | 1536 | 120 |
359307 | 359307 | 2020-07-22 | Monroe | Pennsylvania | 42089 | 1534 | 120 |
356103 | 356103 | 2020-07-21 | Monroe | Pennsylvania | 42089 | 1530 | 119 |
352900 | 352900 | 2020-07-20 | Monroe | Pennsylvania | 42089 | 1503 | 117 |
349697 | 349697 | 2020-07-19 | Monroe | Pennsylvania | 42089 | 1499 | 117 |
346497 | 346497 | 2020-07-18 | Monroe | Pennsylvania | 42089 | 1494 | 116 |
343297 | 343297 | 2020-07-17 | Monroe | Pennsylvania | 42089 | 1488 | 115 |
340099 | 340099 | 2020-07-16 | Monroe | Pennsylvania | 42089 | 1487 | 114 |
336902 | 336902 | 2020-07-15 | Monroe | Pennsylvania | 42089 | 1482 | 113 |
333708 | 333708 | 2020-07-14 | Monroe | Pennsylvania | 42089 | 1474 | 111 |
330516 | 330516 | 2020-07-13 | Monroe | Pennsylvania | 42089 | 1473 | 111 |
327330 | 327330 | 2020-07-12 | Monroe | Pennsylvania | 42089 | 1471 | 111 |
324145 | 324145 | 2020-07-11 | Monroe | Pennsylvania | 42089 | 1470 | 111 |
320965 | 320965 | 2020-07-10 | Monroe | Pennsylvania | 42089 | 1462 | 111 |
317787 | 317787 | 2020-07-09 | Monroe | Pennsylvania | 42089 | 1456 | 111 |
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);