ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 42093 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919500 | 919500 | 2021-01-11 | Montour | Pennsylvania | 42093 | 1422 | 31 |
916255 | 916255 | 2021-01-10 | Montour | Pennsylvania | 42093 | 1289 | 31 |
913010 | 913010 | 2021-01-09 | Montour | Pennsylvania | 42093 | 1256 | 31 |
909765 | 909765 | 2021-01-08 | Montour | Pennsylvania | 42093 | 1220 | 30 |
906520 | 906520 | 2021-01-07 | Montour | Pennsylvania | 42093 | 1202 | 30 |
903274 | 903274 | 2021-01-06 | Montour | Pennsylvania | 42093 | 1212 | 28 |
900029 | 900029 | 2021-01-05 | Montour | Pennsylvania | 42093 | 1165 | 25 |
896784 | 896784 | 2021-01-04 | Montour | Pennsylvania | 42093 | 1153 | 25 |
893538 | 893538 | 2021-01-03 | Montour | Pennsylvania | 42093 | 1229 | 25 |
890292 | 890292 | 2021-01-02 | Montour | Pennsylvania | 42093 | 1218 | 25 |
887045 | 887045 | 2021-01-01 | Montour | Pennsylvania | 42093 | 1166 | 25 |
883800 | 883800 | 2020-12-31 | Montour | Pennsylvania | 42093 | 1173 | 25 |
880555 | 880555 | 2020-12-30 | Montour | Pennsylvania | 42093 | 1083 | 25 |
877310 | 877310 | 2020-12-29 | Montour | Pennsylvania | 42093 | 1021 | 24 |
874065 | 874065 | 2020-12-28 | Montour | Pennsylvania | 42093 | 1064 | 23 |
870820 | 870820 | 2020-12-27 | Montour | Pennsylvania | 42093 | 1033 | 23 |
867575 | 867575 | 2020-12-26 | Montour | Pennsylvania | 42093 | 1122 | 23 |
864330 | 864330 | 2020-12-25 | Montour | Pennsylvania | 42093 | 958 | 23 |
861085 | 861085 | 2020-12-24 | Montour | Pennsylvania | 42093 | 952 | 22 |
857840 | 857840 | 2020-12-23 | Montour | Pennsylvania | 42093 | 1082 | 21 |
854595 | 854595 | 2020-12-22 | Montour | Pennsylvania | 42093 | 895 | 19 |
851350 | 851350 | 2020-12-21 | Montour | Pennsylvania | 42093 | 885 | 19 |
848105 | 848105 | 2020-12-20 | Montour | Pennsylvania | 42093 | 939 | 19 |
844860 | 844860 | 2020-12-19 | Montour | Pennsylvania | 42093 | 919 | 19 |
841614 | 841614 | 2020-12-18 | Montour | Pennsylvania | 42093 | 849 | 19 |
838369 | 838369 | 2020-12-17 | Montour | Pennsylvania | 42093 | 787 | 19 |
835123 | 835123 | 2020-12-16 | Montour | Pennsylvania | 42093 | 739 | 18 |
831877 | 831877 | 2020-12-15 | Montour | Pennsylvania | 42093 | 726 | 17 |
828630 | 828630 | 2020-12-14 | Montour | Pennsylvania | 42093 | 843 | 17 |
825384 | 825384 | 2020-12-13 | Montour | Pennsylvania | 42093 | 793 | 17 |
822137 | 822137 | 2020-12-12 | Montour | Pennsylvania | 42093 | 665 | 17 |
818891 | 818891 | 2020-12-11 | Montour | Pennsylvania | 42093 | 659 | 16 |
815645 | 815645 | 2020-12-10 | Montour | Pennsylvania | 42093 | 1285 | 16 |
812399 | 812399 | 2020-12-09 | Montour | Pennsylvania | 42093 | 1119 | 16 |
809155 | 809155 | 2020-12-08 | Montour | Pennsylvania | 42093 | 1103 | 16 |
805910 | 805910 | 2020-12-07 | Montour | Pennsylvania | 42093 | 1063 | 16 |
802665 | 802665 | 2020-12-06 | Montour | Pennsylvania | 42093 | 1055 | 16 |
799420 | 799420 | 2020-12-05 | Montour | Pennsylvania | 42093 | 982 | 16 |
796175 | 796175 | 2020-12-04 | Montour | Pennsylvania | 42093 | 781 | 16 |
792930 | 792930 | 2020-12-03 | Montour | Pennsylvania | 42093 | 664 | 15 |
789685 | 789685 | 2020-12-02 | Montour | Pennsylvania | 42093 | 525 | 15 |
786440 | 786440 | 2020-12-01 | Montour | Pennsylvania | 42093 | 476 | 15 |
783196 | 783196 | 2020-11-30 | Montour | Pennsylvania | 42093 | 469 | 15 |
779951 | 779951 | 2020-11-29 | Montour | Pennsylvania | 42093 | 463 | 15 |
776705 | 776705 | 2020-11-28 | Montour | Pennsylvania | 42093 | 451 | 15 |
773460 | 773460 | 2020-11-27 | Montour | Pennsylvania | 42093 | 444 | 15 |
770215 | 770215 | 2020-11-26 | Montour | Pennsylvania | 42093 | 440 | 15 |
766969 | 766969 | 2020-11-25 | Montour | Pennsylvania | 42093 | 429 | 15 |
763724 | 763724 | 2020-11-24 | Montour | Pennsylvania | 42093 | 421 | 15 |
760479 | 760479 | 2020-11-23 | Montour | Pennsylvania | 42093 | 413 | 15 |
757234 | 757234 | 2020-11-22 | Montour | Pennsylvania | 42093 | 410 | 15 |
753987 | 753987 | 2020-11-21 | Montour | Pennsylvania | 42093 | 404 | 15 |
750741 | 750741 | 2020-11-20 | Montour | Pennsylvania | 42093 | 399 | 14 |
747495 | 747495 | 2020-11-19 | Montour | Pennsylvania | 42093 | 394 | 14 |
744249 | 744249 | 2020-11-18 | Montour | Pennsylvania | 42093 | 392 | 14 |
741002 | 741002 | 2020-11-17 | Montour | Pennsylvania | 42093 | 378 | 14 |
737756 | 737756 | 2020-11-16 | Montour | Pennsylvania | 42093 | 367 | 14 |
734512 | 734512 | 2020-11-15 | Montour | Pennsylvania | 42093 | 366 | 13 |
731266 | 731266 | 2020-11-14 | Montour | Pennsylvania | 42093 | 366 | 13 |
728022 | 728022 | 2020-11-13 | Montour | Pennsylvania | 42093 | 360 | 13 |
724778 | 724778 | 2020-11-12 | Montour | Pennsylvania | 42093 | 356 | 13 |
721535 | 721535 | 2020-11-11 | Montour | Pennsylvania | 42093 | 352 | 12 |
718292 | 718292 | 2020-11-10 | Montour | Pennsylvania | 42093 | 346 | 12 |
715049 | 715049 | 2020-11-09 | Montour | Pennsylvania | 42093 | 342 | 12 |
711805 | 711805 | 2020-11-08 | Montour | Pennsylvania | 42093 | 335 | 12 |
708561 | 708561 | 2020-11-07 | Montour | Pennsylvania | 42093 | 333 | 12 |
705318 | 705318 | 2020-11-06 | Montour | Pennsylvania | 42093 | 324 | 11 |
702075 | 702075 | 2020-11-05 | Montour | Pennsylvania | 42093 | 316 | 11 |
698831 | 698831 | 2020-11-04 | Montour | Pennsylvania | 42093 | 314 | 11 |
695588 | 695588 | 2020-11-03 | Montour | Pennsylvania | 42093 | 313 | 11 |
692346 | 692346 | 2020-11-02 | Montour | Pennsylvania | 42093 | 312 | 11 |
689102 | 689102 | 2020-11-01 | Montour | Pennsylvania | 42093 | 311 | 11 |
685857 | 685857 | 2020-10-31 | Montour | Pennsylvania | 42093 | 309 | 11 |
682614 | 682614 | 2020-10-30 | Montour | Pennsylvania | 42093 | 306 | 11 |
679371 | 679371 | 2020-10-29 | Montour | Pennsylvania | 42093 | 300 | 11 |
676128 | 676128 | 2020-10-28 | Montour | Pennsylvania | 42093 | 297 | 11 |
672885 | 672885 | 2020-10-27 | Montour | Pennsylvania | 42093 | 296 | 11 |
669643 | 669643 | 2020-10-26 | Montour | Pennsylvania | 42093 | 295 | 10 |
666399 | 666399 | 2020-10-25 | Montour | Pennsylvania | 42093 | 294 | 10 |
663154 | 663154 | 2020-10-24 | Montour | Pennsylvania | 42093 | 292 | 9 |
659910 | 659910 | 2020-10-23 | Montour | Pennsylvania | 42093 | 291 | 9 |
656666 | 656666 | 2020-10-22 | Montour | Pennsylvania | 42093 | 281 | 9 |
653421 | 653421 | 2020-10-21 | Montour | Pennsylvania | 42093 | 280 | 7 |
650176 | 650176 | 2020-10-20 | Montour | Pennsylvania | 42093 | 277 | 7 |
646932 | 646932 | 2020-10-19 | Montour | Pennsylvania | 42093 | 276 | 7 |
643686 | 643686 | 2020-10-18 | Montour | Pennsylvania | 42093 | 274 | 7 |
640438 | 640438 | 2020-10-17 | Montour | Pennsylvania | 42093 | 271 | 7 |
637192 | 637192 | 2020-10-16 | Montour | Pennsylvania | 42093 | 261 | 7 |
633946 | 633946 | 2020-10-15 | Montour | Pennsylvania | 42093 | 254 | 5 |
630701 | 630701 | 2020-10-14 | Montour | Pennsylvania | 42093 | 251 | 5 |
627457 | 627457 | 2020-10-13 | Montour | Pennsylvania | 42093 | 247 | 5 |
624215 | 624215 | 2020-10-12 | Montour | Pennsylvania | 42093 | 245 | 5 |
620972 | 620972 | 2020-10-11 | Montour | Pennsylvania | 42093 | 243 | 5 |
617729 | 617729 | 2020-10-10 | Montour | Pennsylvania | 42093 | 241 | 5 |
614487 | 614487 | 2020-10-09 | Montour | Pennsylvania | 42093 | 233 | 5 |
611246 | 611246 | 2020-10-08 | Montour | Pennsylvania | 42093 | 226 | 5 |
608004 | 608004 | 2020-10-07 | Montour | Pennsylvania | 42093 | 219 | 5 |
604761 | 604761 | 2020-10-06 | Montour | Pennsylvania | 42093 | 218 | 5 |
601519 | 601519 | 2020-10-05 | Montour | Pennsylvania | 42093 | 216 | 5 |
598276 | 598276 | 2020-10-04 | Montour | Pennsylvania | 42093 | 198 | 5 |
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);