ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 42079 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919493 | 919493 | 2021-01-11 | Luzerne | Pennsylvania | 42079 | 19608 | 500 |
916248 | 916248 | 2021-01-10 | Luzerne | Pennsylvania | 42079 | 19428 | 497 |
913003 | 913003 | 2021-01-09 | Luzerne | Pennsylvania | 42079 | 19192 | 497 |
909758 | 909758 | 2021-01-08 | Luzerne | Pennsylvania | 42079 | 18903 | 493 |
906513 | 906513 | 2021-01-07 | Luzerne | Pennsylvania | 42079 | 18654 | 491 |
903267 | 903267 | 2021-01-06 | Luzerne | Pennsylvania | 42079 | 18378 | 484 |
900022 | 900022 | 2021-01-05 | Luzerne | Pennsylvania | 42079 | 18197 | 474 |
896777 | 896777 | 2021-01-04 | Luzerne | Pennsylvania | 42079 | 17973 | 470 |
893531 | 893531 | 2021-01-03 | Luzerne | Pennsylvania | 42079 | 17929 | 468 |
890285 | 890285 | 2021-01-02 | Luzerne | Pennsylvania | 42079 | 17820 | 468 |
887038 | 887038 | 2021-01-01 | Luzerne | Pennsylvania | 42079 | 17598 | 468 |
883793 | 883793 | 2020-12-31 | Luzerne | Pennsylvania | 42079 | 17317 | 463 |
880548 | 880548 | 2020-12-30 | Luzerne | Pennsylvania | 42079 | 16998 | 455 |
877303 | 877303 | 2020-12-29 | Luzerne | Pennsylvania | 42079 | 16614 | 446 |
874058 | 874058 | 2020-12-28 | Luzerne | Pennsylvania | 42079 | 16511 | 439 |
870813 | 870813 | 2020-12-27 | Luzerne | Pennsylvania | 42079 | 16437 | 435 |
867568 | 867568 | 2020-12-26 | Luzerne | Pennsylvania | 42079 | 16285 | 423 |
864323 | 864323 | 2020-12-25 | Luzerne | Pennsylvania | 42079 | 16022 | 423 |
861078 | 861078 | 2020-12-24 | Luzerne | Pennsylvania | 42079 | 15873 | 418 |
857833 | 857833 | 2020-12-23 | Luzerne | Pennsylvania | 42079 | 15752 | 413 |
854588 | 854588 | 2020-12-22 | Luzerne | Pennsylvania | 42079 | 15426 | 409 |
851343 | 851343 | 2020-12-21 | Luzerne | Pennsylvania | 42079 | 15340 | 406 |
848098 | 848098 | 2020-12-20 | Luzerne | Pennsylvania | 42079 | 15135 | 404 |
844853 | 844853 | 2020-12-19 | Luzerne | Pennsylvania | 42079 | 14983 | 400 |
841607 | 841607 | 2020-12-18 | Luzerne | Pennsylvania | 42079 | 14716 | 396 |
838362 | 838362 | 2020-12-17 | Luzerne | Pennsylvania | 42079 | 14417 | 395 |
835116 | 835116 | 2020-12-16 | Luzerne | Pennsylvania | 42079 | 13883 | 389 |
831870 | 831870 | 2020-12-15 | Luzerne | Pennsylvania | 42079 | 13398 | 373 |
828623 | 828623 | 2020-12-14 | Luzerne | Pennsylvania | 42079 | 13259 | 364 |
825377 | 825377 | 2020-12-13 | Luzerne | Pennsylvania | 42079 | 12984 | 362 |
822130 | 822130 | 2020-12-12 | Luzerne | Pennsylvania | 42079 | 12640 | 354 |
818884 | 818884 | 2020-12-11 | Luzerne | Pennsylvania | 42079 | 12478 | 348 |
815638 | 815638 | 2020-12-10 | Luzerne | Pennsylvania | 42079 | 12222 | 343 |
812392 | 812392 | 2020-12-09 | Luzerne | Pennsylvania | 42079 | 11931 | 337 |
809148 | 809148 | 2020-12-08 | Luzerne | Pennsylvania | 42079 | 11747 | 330 |
805903 | 805903 | 2020-12-07 | Luzerne | Pennsylvania | 42079 | 11476 | 323 |
802658 | 802658 | 2020-12-06 | Luzerne | Pennsylvania | 42079 | 11292 | 323 |
799413 | 799413 | 2020-12-05 | Luzerne | Pennsylvania | 42079 | 11071 | 319 |
796168 | 796168 | 2020-12-04 | Luzerne | Pennsylvania | 42079 | 10758 | 309 |
792923 | 792923 | 2020-12-03 | Luzerne | Pennsylvania | 42079 | 10460 | 304 |
789678 | 789678 | 2020-12-02 | Luzerne | Pennsylvania | 42079 | 10098 | 294 |
786433 | 786433 | 2020-12-01 | Luzerne | Pennsylvania | 42079 | 9886 | 285 |
783189 | 783189 | 2020-11-30 | Luzerne | Pennsylvania | 42079 | 9760 | 273 |
779944 | 779944 | 2020-11-29 | Luzerne | Pennsylvania | 42079 | 9656 | 271 |
776698 | 776698 | 2020-11-28 | Luzerne | Pennsylvania | 42079 | 9435 | 267 |
773453 | 773453 | 2020-11-27 | Luzerne | Pennsylvania | 42079 | 9238 | 267 |
770208 | 770208 | 2020-11-26 | Luzerne | Pennsylvania | 42079 | 8988 | 267 |
766962 | 766962 | 2020-11-25 | Luzerne | Pennsylvania | 42079 | 8739 | 263 |
763717 | 763717 | 2020-11-24 | Luzerne | Pennsylvania | 42079 | 8543 | 251 |
760472 | 760472 | 2020-11-23 | Luzerne | Pennsylvania | 42079 | 8396 | 250 |
757227 | 757227 | 2020-11-22 | Luzerne | Pennsylvania | 42079 | 8314 | 248 |
753980 | 753980 | 2020-11-21 | Luzerne | Pennsylvania | 42079 | 8156 | 245 |
750734 | 750734 | 2020-11-20 | Luzerne | Pennsylvania | 42079 | 7966 | 243 |
747488 | 747488 | 2020-11-19 | Luzerne | Pennsylvania | 42079 | 7736 | 238 |
744242 | 744242 | 2020-11-18 | Luzerne | Pennsylvania | 42079 | 7555 | 236 |
740995 | 740995 | 2020-11-17 | Luzerne | Pennsylvania | 42079 | 7327 | 230 |
737749 | 737749 | 2020-11-16 | Luzerne | Pennsylvania | 42079 | 7104 | 230 |
734505 | 734505 | 2020-11-15 | Luzerne | Pennsylvania | 42079 | 7031 | 230 |
731259 | 731259 | 2020-11-14 | Luzerne | Pennsylvania | 42079 | 6933 | 225 |
728015 | 728015 | 2020-11-13 | Luzerne | Pennsylvania | 42079 | 6760 | 222 |
724771 | 724771 | 2020-11-12 | Luzerne | Pennsylvania | 42079 | 6642 | 222 |
721528 | 721528 | 2020-11-11 | Luzerne | Pennsylvania | 42079 | 6450 | 218 |
718285 | 718285 | 2020-11-10 | Luzerne | Pennsylvania | 42079 | 6339 | 216 |
715042 | 715042 | 2020-11-09 | Luzerne | Pennsylvania | 42079 | 6206 | 215 |
711798 | 711798 | 2020-11-08 | Luzerne | Pennsylvania | 42079 | 6125 | 215 |
708554 | 708554 | 2020-11-07 | Luzerne | Pennsylvania | 42079 | 6045 | 214 |
705311 | 705311 | 2020-11-06 | Luzerne | Pennsylvania | 42079 | 5948 | 211 |
702068 | 702068 | 2020-11-05 | Luzerne | Pennsylvania | 42079 | 5861 | 209 |
698824 | 698824 | 2020-11-04 | Luzerne | Pennsylvania | 42079 | 5794 | 209 |
695581 | 695581 | 2020-11-03 | Luzerne | Pennsylvania | 42079 | 5727 | 209 |
692339 | 692339 | 2020-11-02 | Luzerne | Pennsylvania | 42079 | 5674 | 207 |
689095 | 689095 | 2020-11-01 | Luzerne | Pennsylvania | 42079 | 5624 | 206 |
685850 | 685850 | 2020-10-31 | Luzerne | Pennsylvania | 42079 | 5545 | 206 |
682607 | 682607 | 2020-10-30 | Luzerne | Pennsylvania | 42079 | 5467 | 203 |
679364 | 679364 | 2020-10-29 | Luzerne | Pennsylvania | 42079 | 5412 | 199 |
676121 | 676121 | 2020-10-28 | Luzerne | Pennsylvania | 42079 | 5337 | 198 |
672878 | 672878 | 2020-10-27 | Luzerne | Pennsylvania | 42079 | 5273 | 197 |
669636 | 669636 | 2020-10-26 | Luzerne | Pennsylvania | 42079 | 5195 | 197 |
666392 | 666392 | 2020-10-25 | Luzerne | Pennsylvania | 42079 | 5141 | 196 |
663147 | 663147 | 2020-10-24 | Luzerne | Pennsylvania | 42079 | 5052 | 196 |
659903 | 659903 | 2020-10-23 | Luzerne | Pennsylvania | 42079 | 5011 | 193 |
656659 | 656659 | 2020-10-22 | Luzerne | Pennsylvania | 42079 | 4936 | 191 |
653414 | 653414 | 2020-10-21 | Luzerne | Pennsylvania | 42079 | 4824 | 191 |
650169 | 650169 | 2020-10-20 | Luzerne | Pennsylvania | 42079 | 4781 | 190 |
646925 | 646925 | 2020-10-19 | Luzerne | Pennsylvania | 42079 | 4748 | 190 |
643679 | 643679 | 2020-10-18 | Luzerne | Pennsylvania | 42079 | 4703 | 190 |
640431 | 640431 | 2020-10-17 | Luzerne | Pennsylvania | 42079 | 4655 | 190 |
637185 | 637185 | 2020-10-16 | Luzerne | Pennsylvania | 42079 | 4594 | 190 |
633939 | 633939 | 2020-10-15 | Luzerne | Pennsylvania | 42079 | 4550 | 190 |
630694 | 630694 | 2020-10-14 | Luzerne | Pennsylvania | 42079 | 4496 | 190 |
627450 | 627450 | 2020-10-13 | Luzerne | Pennsylvania | 42079 | 4458 | 190 |
624208 | 624208 | 2020-10-12 | Luzerne | Pennsylvania | 42079 | 4426 | 190 |
620965 | 620965 | 2020-10-11 | Luzerne | Pennsylvania | 42079 | 4387 | 190 |
617722 | 617722 | 2020-10-10 | Luzerne | Pennsylvania | 42079 | 4346 | 190 |
614480 | 614480 | 2020-10-09 | Luzerne | Pennsylvania | 42079 | 4305 | 190 |
611239 | 611239 | 2020-10-08 | Luzerne | Pennsylvania | 42079 | 4277 | 190 |
607997 | 607997 | 2020-10-07 | Luzerne | Pennsylvania | 42079 | 4252 | 190 |
604754 | 604754 | 2020-10-06 | Luzerne | Pennsylvania | 42079 | 4222 | 190 |
601512 | 601512 | 2020-10-05 | Luzerne | Pennsylvania | 42079 | 4209 | 190 |
598269 | 598269 | 2020-10-04 | Luzerne | Pennsylvania | 42079 | 4193 | 190 |
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);