ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Monroe" and fips = 42089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922743 | 922743 | 2021-01-12 | Monroe | Pennsylvania | 42089 | 7244 | 218 |
919498 | 919498 | 2021-01-11 | Monroe | Pennsylvania | 42089 | 7163 | 217 |
916253 | 916253 | 2021-01-10 | Monroe | Pennsylvania | 42089 | 7110 | 216 |
913008 | 913008 | 2021-01-09 | Monroe | Pennsylvania | 42089 | 6983 | 214 |
909763 | 909763 | 2021-01-08 | Monroe | Pennsylvania | 42089 | 6846 | 213 |
906518 | 906518 | 2021-01-07 | Monroe | Pennsylvania | 42089 | 6736 | 212 |
903272 | 903272 | 2021-01-06 | Monroe | Pennsylvania | 42089 | 6605 | 209 |
900027 | 900027 | 2021-01-05 | Monroe | Pennsylvania | 42089 | 6513 | 206 |
896782 | 896782 | 2021-01-04 | Monroe | Pennsylvania | 42089 | 6414 | 205 |
893536 | 893536 | 2021-01-03 | Monroe | Pennsylvania | 42089 | 6379 | 205 |
890290 | 890290 | 2021-01-02 | Monroe | Pennsylvania | 42089 | 6344 | 205 |
887043 | 887043 | 2021-01-01 | Monroe | Pennsylvania | 42089 | 6183 | 204 |
883798 | 883798 | 2020-12-31 | Monroe | Pennsylvania | 42089 | 6103 | 200 |
880553 | 880553 | 2020-12-30 | Monroe | Pennsylvania | 42089 | 5993 | 198 |
877308 | 877308 | 2020-12-29 | Monroe | Pennsylvania | 42089 | 5900 | 195 |
874063 | 874063 | 2020-12-28 | Monroe | Pennsylvania | 42089 | 5797 | 193 |
870818 | 870818 | 2020-12-27 | Monroe | Pennsylvania | 42089 | 5747 | 193 |
867573 | 867573 | 2020-12-26 | Monroe | Pennsylvania | 42089 | 5687 | 190 |
864328 | 864328 | 2020-12-25 | Monroe | Pennsylvania | 42089 | 5611 | 190 |
861083 | 861083 | 2020-12-24 | Monroe | Pennsylvania | 42089 | 5552 | 189 |
857838 | 857838 | 2020-12-23 | Monroe | Pennsylvania | 42089 | 5444 | 189 |
854593 | 854593 | 2020-12-22 | Monroe | Pennsylvania | 42089 | 5366 | 188 |
851348 | 851348 | 2020-12-21 | Monroe | Pennsylvania | 42089 | 5293 | 186 |
848103 | 848103 | 2020-12-20 | Monroe | Pennsylvania | 42089 | 5206 | 186 |
844858 | 844858 | 2020-12-19 | Monroe | Pennsylvania | 42089 | 5125 | 185 |
841612 | 841612 | 2020-12-18 | Monroe | Pennsylvania | 42089 | 5068 | 183 |
838367 | 838367 | 2020-12-17 | Monroe | Pennsylvania | 42089 | 4983 | 181 |
835121 | 835121 | 2020-12-16 | Monroe | Pennsylvania | 42089 | 4871 | 179 |
831875 | 831875 | 2020-12-15 | Monroe | Pennsylvania | 42089 | 4796 | 177 |
828628 | 828628 | 2020-12-14 | Monroe | Pennsylvania | 42089 | 4737 | 174 |
825382 | 825382 | 2020-12-13 | Monroe | Pennsylvania | 42089 | 4646 | 174 |
822135 | 822135 | 2020-12-12 | Monroe | Pennsylvania | 42089 | 4563 | 172 |
818889 | 818889 | 2020-12-11 | Monroe | Pennsylvania | 42089 | 4475 | 170 |
815643 | 815643 | 2020-12-10 | Monroe | Pennsylvania | 42089 | 4399 | 168 |
812397 | 812397 | 2020-12-09 | Monroe | Pennsylvania | 42089 | 4264 | 161 |
809153 | 809153 | 2020-12-08 | Monroe | Pennsylvania | 42089 | 4203 | 160 |
805908 | 805908 | 2020-12-07 | Monroe | Pennsylvania | 42089 | 4072 | 159 |
802663 | 802663 | 2020-12-06 | Monroe | Pennsylvania | 42089 | 4010 | 159 |
799418 | 799418 | 2020-12-05 | Monroe | Pennsylvania | 42089 | 3918 | 159 |
796173 | 796173 | 2020-12-04 | Monroe | Pennsylvania | 42089 | 3802 | 158 |
792928 | 792928 | 2020-12-03 | Monroe | Pennsylvania | 42089 | 3663 | 155 |
789683 | 789683 | 2020-12-02 | Monroe | Pennsylvania | 42089 | 3557 | 153 |
786438 | 786438 | 2020-12-01 | Monroe | Pennsylvania | 42089 | 3449 | 148 |
783194 | 783194 | 2020-11-30 | Monroe | Pennsylvania | 42089 | 3413 | 143 |
779949 | 779949 | 2020-11-29 | Monroe | Pennsylvania | 42089 | 3386 | 143 |
776703 | 776703 | 2020-11-28 | Monroe | Pennsylvania | 42089 | 3343 | 143 |
773458 | 773458 | 2020-11-27 | Monroe | Pennsylvania | 42089 | 3180 | 141 |
770213 | 770213 | 2020-11-26 | Monroe | Pennsylvania | 42089 | 3109 | 141 |
766967 | 766967 | 2020-11-25 | Monroe | Pennsylvania | 42089 | 3040 | 141 |
763722 | 763722 | 2020-11-24 | Monroe | Pennsylvania | 42089 | 2967 | 138 |
760477 | 760477 | 2020-11-23 | Monroe | Pennsylvania | 42089 | 2931 | 138 |
757232 | 757232 | 2020-11-22 | Monroe | Pennsylvania | 42089 | 2892 | 138 |
753985 | 753985 | 2020-11-21 | Monroe | Pennsylvania | 42089 | 2844 | 138 |
750739 | 750739 | 2020-11-20 | Monroe | Pennsylvania | 42089 | 2782 | 138 |
747493 | 747493 | 2020-11-19 | Monroe | Pennsylvania | 42089 | 2728 | 137 |
744247 | 744247 | 2020-11-18 | Monroe | Pennsylvania | 42089 | 2659 | 137 |
741000 | 741000 | 2020-11-17 | Monroe | Pennsylvania | 42089 | 2631 | 135 |
737754 | 737754 | 2020-11-16 | Monroe | Pennsylvania | 42089 | 2598 | 135 |
734510 | 734510 | 2020-11-15 | Monroe | Pennsylvania | 42089 | 2572 | 135 |
731264 | 731264 | 2020-11-14 | Monroe | Pennsylvania | 42089 | 2525 | 135 |
728020 | 728020 | 2020-11-13 | Monroe | Pennsylvania | 42089 | 2479 | 135 |
724776 | 724776 | 2020-11-12 | Monroe | Pennsylvania | 42089 | 2413 | 135 |
721533 | 721533 | 2020-11-11 | Monroe | Pennsylvania | 42089 | 2367 | 135 |
718290 | 718290 | 2020-11-10 | Monroe | Pennsylvania | 42089 | 2318 | 135 |
715047 | 715047 | 2020-11-09 | Monroe | Pennsylvania | 42089 | 2287 | 135 |
711803 | 711803 | 2020-11-08 | Monroe | Pennsylvania | 42089 | 2259 | 135 |
708559 | 708559 | 2020-11-07 | Monroe | Pennsylvania | 42089 | 2242 | 135 |
705316 | 705316 | 2020-11-06 | Monroe | Pennsylvania | 42089 | 2211 | 135 |
702073 | 702073 | 2020-11-05 | Monroe | Pennsylvania | 42089 | 2182 | 135 |
698829 | 698829 | 2020-11-04 | Monroe | Pennsylvania | 42089 | 2157 | 135 |
695586 | 695586 | 2020-11-03 | Monroe | Pennsylvania | 42089 | 2131 | 135 |
692344 | 692344 | 2020-11-02 | Monroe | Pennsylvania | 42089 | 2092 | 135 |
689100 | 689100 | 2020-11-01 | Monroe | Pennsylvania | 42089 | 2081 | 135 |
685855 | 685855 | 2020-10-31 | Monroe | Pennsylvania | 42089 | 2069 | 135 |
682612 | 682612 | 2020-10-30 | Monroe | Pennsylvania | 42089 | 2042 | 135 |
679369 | 679369 | 2020-10-29 | Monroe | Pennsylvania | 42089 | 2029 | 135 |
676126 | 676126 | 2020-10-28 | Monroe | Pennsylvania | 42089 | 2020 | 135 |
672883 | 672883 | 2020-10-27 | Monroe | Pennsylvania | 42089 | 2013 | 135 |
669641 | 669641 | 2020-10-26 | Monroe | Pennsylvania | 42089 | 2001 | 135 |
666397 | 666397 | 2020-10-25 | Monroe | Pennsylvania | 42089 | 1992 | 135 |
663152 | 663152 | 2020-10-24 | Monroe | Pennsylvania | 42089 | 1983 | 135 |
659908 | 659908 | 2020-10-23 | Monroe | Pennsylvania | 42089 | 1968 | 135 |
656664 | 656664 | 2020-10-22 | Monroe | Pennsylvania | 42089 | 1961 | 134 |
653419 | 653419 | 2020-10-21 | Monroe | Pennsylvania | 42089 | 1944 | 134 |
650174 | 650174 | 2020-10-20 | Monroe | Pennsylvania | 42089 | 1940 | 134 |
646930 | 646930 | 2020-10-19 | Monroe | Pennsylvania | 42089 | 1938 | 134 |
643684 | 643684 | 2020-10-18 | Monroe | Pennsylvania | 42089 | 1923 | 134 |
640436 | 640436 | 2020-10-17 | Monroe | Pennsylvania | 42089 | 1913 | 134 |
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 |
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);