ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 42041 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922719 | 922719 | 2021-01-12 | Cumberland | Pennsylvania | 42041 | 12081 | 352 |
919474 | 919474 | 2021-01-11 | Cumberland | Pennsylvania | 42041 | 11998 | 346 |
916229 | 916229 | 2021-01-10 | Cumberland | Pennsylvania | 42041 | 11883 | 344 |
912984 | 912984 | 2021-01-09 | Cumberland | Pennsylvania | 42041 | 11698 | 342 |
909739 | 909739 | 2021-01-08 | Cumberland | Pennsylvania | 42041 | 11511 | 335 |
906494 | 906494 | 2021-01-07 | Cumberland | Pennsylvania | 42041 | 11302 | 329 |
903248 | 903248 | 2021-01-06 | Cumberland | Pennsylvania | 42041 | 11087 | 323 |
900003 | 900003 | 2021-01-05 | Cumberland | Pennsylvania | 42041 | 10918 | 313 |
896758 | 896758 | 2021-01-04 | Cumberland | Pennsylvania | 42041 | 10772 | 309 |
893512 | 893512 | 2021-01-03 | Cumberland | Pennsylvania | 42041 | 10755 | 308 |
890266 | 890266 | 2021-01-02 | Cumberland | Pennsylvania | 42041 | 10652 | 308 |
887019 | 887019 | 2021-01-01 | Cumberland | Pennsylvania | 42041 | 10539 | 306 |
883774 | 883774 | 2020-12-31 | Cumberland | Pennsylvania | 42041 | 10456 | 299 |
880529 | 880529 | 2020-12-30 | Cumberland | Pennsylvania | 42041 | 10305 | 294 |
877284 | 877284 | 2020-12-29 | Cumberland | Pennsylvania | 42041 | 10115 | 285 |
874039 | 874039 | 2020-12-28 | Cumberland | Pennsylvania | 42041 | 10047 | 284 |
870794 | 870794 | 2020-12-27 | Cumberland | Pennsylvania | 42041 | 9973 | 282 |
867549 | 867549 | 2020-12-26 | Cumberland | Pennsylvania | 42041 | 9897 | 279 |
864304 | 864304 | 2020-12-25 | Cumberland | Pennsylvania | 42041 | 9661 | 279 |
861059 | 861059 | 2020-12-24 | Cumberland | Pennsylvania | 42041 | 9572 | 278 |
857814 | 857814 | 2020-12-23 | Cumberland | Pennsylvania | 42041 | 9402 | 268 |
854569 | 854569 | 2020-12-22 | Cumberland | Pennsylvania | 42041 | 9177 | 261 |
851324 | 851324 | 2020-12-21 | Cumberland | Pennsylvania | 42041 | 9114 | 254 |
848079 | 848079 | 2020-12-20 | Cumberland | Pennsylvania | 42041 | 8924 | 252 |
844834 | 844834 | 2020-12-19 | Cumberland | Pennsylvania | 42041 | 8753 | 250 |
841588 | 841588 | 2020-12-18 | Cumberland | Pennsylvania | 42041 | 8555 | 245 |
838343 | 838343 | 2020-12-17 | Cumberland | Pennsylvania | 42041 | 8354 | 240 |
835097 | 835097 | 2020-12-16 | Cumberland | Pennsylvania | 42041 | 8188 | 233 |
831851 | 831851 | 2020-12-15 | Cumberland | Pennsylvania | 42041 | 7993 | 224 |
828604 | 828604 | 2020-12-14 | Cumberland | Pennsylvania | 42041 | 7882 | 217 |
825358 | 825358 | 2020-12-13 | Cumberland | Pennsylvania | 42041 | 7744 | 215 |
822111 | 822111 | 2020-12-12 | Cumberland | Pennsylvania | 42041 | 7383 | 212 |
818865 | 818865 | 2020-12-11 | Cumberland | Pennsylvania | 42041 | 7182 | 207 |
815619 | 815619 | 2020-12-10 | Cumberland | Pennsylvania | 42041 | 7046 | 202 |
812373 | 812373 | 2020-12-09 | Cumberland | Pennsylvania | 42041 | 6784 | 193 |
809129 | 809129 | 2020-12-08 | Cumberland | Pennsylvania | 42041 | 6633 | 183 |
805884 | 805884 | 2020-12-07 | Cumberland | Pennsylvania | 42041 | 6450 | 177 |
802639 | 802639 | 2020-12-06 | Cumberland | Pennsylvania | 42041 | 6352 | 174 |
799394 | 799394 | 2020-12-05 | Cumberland | Pennsylvania | 42041 | 6228 | 168 |
796149 | 796149 | 2020-12-04 | Cumberland | Pennsylvania | 42041 | 5973 | 161 |
792904 | 792904 | 2020-12-03 | Cumberland | Pennsylvania | 42041 | 5725 | 155 |
789659 | 789659 | 2020-12-02 | Cumberland | Pennsylvania | 42041 | 5421 | 145 |
786414 | 786414 | 2020-12-01 | Cumberland | Pennsylvania | 42041 | 5240 | 137 |
783170 | 783170 | 2020-11-30 | Cumberland | Pennsylvania | 42041 | 5172 | 134 |
779925 | 779925 | 2020-11-29 | Cumberland | Pennsylvania | 42041 | 5089 | 134 |
776679 | 776679 | 2020-11-28 | Cumberland | Pennsylvania | 42041 | 4978 | 132 |
773434 | 773434 | 2020-11-27 | Cumberland | Pennsylvania | 42041 | 4831 | 130 |
770189 | 770189 | 2020-11-26 | Cumberland | Pennsylvania | 42041 | 4722 | 130 |
766943 | 766943 | 2020-11-25 | Cumberland | Pennsylvania | 42041 | 4585 | 119 |
763698 | 763698 | 2020-11-24 | Cumberland | Pennsylvania | 42041 | 4496 | 112 |
760453 | 760453 | 2020-11-23 | Cumberland | Pennsylvania | 42041 | 4384 | 110 |
757208 | 757208 | 2020-11-22 | Cumberland | Pennsylvania | 42041 | 4334 | 109 |
753961 | 753961 | 2020-11-21 | Cumberland | Pennsylvania | 42041 | 4133 | 108 |
750715 | 750715 | 2020-11-20 | Cumberland | Pennsylvania | 42041 | 4017 | 102 |
747469 | 747469 | 2020-11-19 | Cumberland | Pennsylvania | 42041 | 3933 | 95 |
744223 | 744223 | 2020-11-18 | Cumberland | Pennsylvania | 42041 | 3821 | 91 |
740976 | 740976 | 2020-11-17 | Cumberland | Pennsylvania | 42041 | 3647 | 87 |
737730 | 737730 | 2020-11-16 | Cumberland | Pennsylvania | 42041 | 3534 | 87 |
734486 | 734486 | 2020-11-15 | Cumberland | Pennsylvania | 42041 | 3479 | 87 |
731240 | 731240 | 2020-11-14 | Cumberland | Pennsylvania | 42041 | 3384 | 87 |
727996 | 727996 | 2020-11-13 | Cumberland | Pennsylvania | 42041 | 3299 | 86 |
724752 | 724752 | 2020-11-12 | Cumberland | Pennsylvania | 42041 | 3186 | 86 |
721509 | 721509 | 2020-11-11 | Cumberland | Pennsylvania | 42041 | 3119 | 85 |
718266 | 718266 | 2020-11-10 | Cumberland | Pennsylvania | 42041 | 3013 | 83 |
715023 | 715023 | 2020-11-09 | Cumberland | Pennsylvania | 42041 | 2935 | 82 |
711779 | 711779 | 2020-11-08 | Cumberland | Pennsylvania | 42041 | 2867 | 82 |
708535 | 708535 | 2020-11-07 | Cumberland | Pennsylvania | 42041 | 2807 | 82 |
705292 | 705292 | 2020-11-06 | Cumberland | Pennsylvania | 42041 | 2745 | 82 |
702049 | 702049 | 2020-11-05 | Cumberland | Pennsylvania | 42041 | 2693 | 82 |
698805 | 698805 | 2020-11-04 | Cumberland | Pennsylvania | 42041 | 2664 | 82 |
695562 | 695562 | 2020-11-03 | Cumberland | Pennsylvania | 42041 | 2627 | 82 |
692320 | 692320 | 2020-11-02 | Cumberland | Pennsylvania | 42041 | 2591 | 81 |
689076 | 689076 | 2020-11-01 | Cumberland | Pennsylvania | 42041 | 2566 | 81 |
685831 | 685831 | 2020-10-31 | Cumberland | Pennsylvania | 42041 | 2554 | 81 |
682588 | 682588 | 2020-10-30 | Cumberland | Pennsylvania | 42041 | 2526 | 81 |
679345 | 679345 | 2020-10-29 | Cumberland | Pennsylvania | 42041 | 2500 | 79 |
676102 | 676102 | 2020-10-28 | Cumberland | Pennsylvania | 42041 | 2467 | 79 |
672859 | 672859 | 2020-10-27 | Cumberland | Pennsylvania | 42041 | 2438 | 79 |
669617 | 669617 | 2020-10-26 | Cumberland | Pennsylvania | 42041 | 2396 | 79 |
666373 | 666373 | 2020-10-25 | Cumberland | Pennsylvania | 42041 | 2376 | 79 |
663128 | 663128 | 2020-10-24 | Cumberland | Pennsylvania | 42041 | 2357 | 79 |
659884 | 659884 | 2020-10-23 | Cumberland | Pennsylvania | 42041 | 2391 | 78 |
656640 | 656640 | 2020-10-22 | Cumberland | Pennsylvania | 42041 | 2385 | 78 |
653395 | 653395 | 2020-10-21 | Cumberland | Pennsylvania | 42041 | 2361 | 78 |
650150 | 650150 | 2020-10-20 | Cumberland | Pennsylvania | 42041 | 2349 | 78 |
646906 | 646906 | 2020-10-19 | Cumberland | Pennsylvania | 42041 | 2254 | 78 |
643660 | 643660 | 2020-10-18 | Cumberland | Pennsylvania | 42041 | 2235 | 78 |
640412 | 640412 | 2020-10-17 | Cumberland | Pennsylvania | 42041 | 2216 | 78 |
637166 | 637166 | 2020-10-16 | Cumberland | Pennsylvania | 42041 | 2195 | 78 |
633920 | 633920 | 2020-10-15 | Cumberland | Pennsylvania | 42041 | 2174 | 77 |
630675 | 630675 | 2020-10-14 | Cumberland | Pennsylvania | 42041 | 2158 | 77 |
627431 | 627431 | 2020-10-13 | Cumberland | Pennsylvania | 42041 | 2119 | 77 |
624189 | 624189 | 2020-10-12 | Cumberland | Pennsylvania | 42041 | 2104 | 77 |
620946 | 620946 | 2020-10-11 | Cumberland | Pennsylvania | 42041 | 2081 | 77 |
617703 | 617703 | 2020-10-10 | Cumberland | Pennsylvania | 42041 | 2070 | 77 |
614461 | 614461 | 2020-10-09 | Cumberland | Pennsylvania | 42041 | 2049 | 77 |
611220 | 611220 | 2020-10-08 | Cumberland | Pennsylvania | 42041 | 2021 | 77 |
607978 | 607978 | 2020-10-07 | Cumberland | Pennsylvania | 42041 | 2004 | 77 |
604735 | 604735 | 2020-10-06 | Cumberland | Pennsylvania | 42041 | 1991 | 77 |
601493 | 601493 | 2020-10-05 | Cumberland | Pennsylvania | 42041 | 1978 | 77 |
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);