ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Luzerne" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081771 | 1081771 | 2021-03-02 | Luzerne | Pennsylvania | 42079 | 24973 | 730 |
1078525 | 1078525 | 2021-03-01 | Luzerne | Pennsylvania | 42079 | 24928 | 730 |
1075280 | 1075280 | 2021-02-28 | Luzerne | Pennsylvania | 42079 | 24905 | 729 |
1072034 | 1072034 | 2021-02-27 | Luzerne | Pennsylvania | 42079 | 24849 | 725 |
1068788 | 1068788 | 2021-02-26 | Luzerne | Pennsylvania | 42079 | 24804 | 725 |
1065543 | 1065543 | 2021-02-25 | Luzerne | Pennsylvania | 42079 | 24737 | 724 |
1062298 | 1062298 | 2021-02-24 | Luzerne | Pennsylvania | 42079 | 24666 | 722 |
1059053 | 1059053 | 2021-02-23 | Luzerne | Pennsylvania | 42079 | 24593 | 720 |
1055807 | 1055807 | 2021-02-22 | Luzerne | Pennsylvania | 42079 | 24543 | 714 |
1052561 | 1052561 | 2021-02-21 | Luzerne | Pennsylvania | 42079 | 24505 | 714 |
1049314 | 1049314 | 2021-02-20 | Luzerne | Pennsylvania | 42079 | 24461 | 713 |
1046067 | 1046067 | 2021-02-19 | Luzerne | Pennsylvania | 42079 | 24386 | 710 |
1042822 | 1042822 | 2021-02-18 | Luzerne | Pennsylvania | 42079 | 24317 | 709 |
1039577 | 1039577 | 2021-02-17 | Luzerne | Pennsylvania | 42079 | 24263 | 706 |
1036332 | 1036332 | 2021-02-16 | Luzerne | Pennsylvania | 42079 | 24185 | 698 |
1033087 | 1033087 | 2021-02-15 | Luzerne | Pennsylvania | 42079 | 24114 | 697 |
1029841 | 1029841 | 2021-02-14 | Luzerne | Pennsylvania | 42079 | 24076 | 696 |
1026594 | 1026594 | 2021-02-13 | Luzerne | Pennsylvania | 42079 | 24005 | 693 |
1023349 | 1023349 | 2021-02-12 | Luzerne | Pennsylvania | 42079 | 23882 | 690 |
1020104 | 1020104 | 2021-02-11 | Luzerne | Pennsylvania | 42079 | 23825 | 684 |
1016859 | 1016859 | 2021-02-10 | Luzerne | Pennsylvania | 42079 | 23742 | 679 |
1013614 | 1013614 | 2021-02-09 | Luzerne | Pennsylvania | 42079 | 23662 | 672 |
1010369 | 1010369 | 2021-02-08 | Luzerne | Pennsylvania | 42079 | 23602 | 669 |
1007123 | 1007123 | 2021-02-07 | Luzerne | Pennsylvania | 42079 | 23527 | 669 |
1003877 | 1003877 | 2021-02-06 | Luzerne | Pennsylvania | 42079 | 23419 | 661 |
1000631 | 1000631 | 2021-02-05 | Luzerne | Pennsylvania | 42079 | 23292 | 654 |
997385 | 997385 | 2021-02-04 | Luzerne | Pennsylvania | 42079 | 23180 | 647 |
994139 | 994139 | 2021-02-03 | Luzerne | Pennsylvania | 42079 | 23068 | 645 |
990893 | 990893 | 2021-02-02 | Luzerne | Pennsylvania | 42079 | 23026 | 638 |
987647 | 987647 | 2021-02-01 | Luzerne | Pennsylvania | 42079 | 22951 | 635 |
984400 | 984400 | 2021-01-31 | Luzerne | Pennsylvania | 42079 | 22882 | 631 |
981153 | 981153 | 2021-01-30 | Luzerne | Pennsylvania | 42079 | 22725 | 624 |
977907 | 977907 | 2021-01-29 | Luzerne | Pennsylvania | 42079 | 22542 | 611 |
974662 | 974662 | 2021-01-28 | Luzerne | Pennsylvania | 42079 | 22412 | 601 |
971417 | 971417 | 2021-01-27 | Luzerne | Pennsylvania | 42079 | 22285 | 598 |
968172 | 968172 | 2021-01-26 | Luzerne | Pennsylvania | 42079 | 21817 | 586 |
964928 | 964928 | 2021-01-25 | Luzerne | Pennsylvania | 42079 | 21726 | 578 |
961683 | 961683 | 2021-01-24 | Luzerne | Pennsylvania | 42079 | 21656 | 575 |
958438 | 958438 | 2021-01-23 | Luzerne | Pennsylvania | 42079 | 21533 | 568 |
955192 | 955192 | 2021-01-22 | Luzerne | Pennsylvania | 42079 | 21367 | 564 |
951947 | 951947 | 2021-01-21 | Luzerne | Pennsylvania | 42079 | 21195 | 560 |
948702 | 948702 | 2021-01-20 | Luzerne | Pennsylvania | 42079 | 21042 | 552 |
945456 | 945456 | 2021-01-19 | Luzerne | Pennsylvania | 42079 | 20879 | 547 |
942209 | 942209 | 2021-01-18 | Luzerne | Pennsylvania | 42079 | 20763 | 542 |
938964 | 938964 | 2021-01-17 | Luzerne | Pennsylvania | 42079 | 20696 | 540 |
935719 | 935719 | 2021-01-16 | Luzerne | Pennsylvania | 42079 | 20438 | 535 |
932474 | 932474 | 2021-01-15 | Luzerne | Pennsylvania | 42079 | 20297 | 523 |
929229 | 929229 | 2021-01-14 | Luzerne | Pennsylvania | 42079 | 20151 | 522 |
925984 | 925984 | 2021-01-13 | Luzerne | Pennsylvania | 42079 | 19913 | 513 |
922738 | 922738 | 2021-01-12 | Luzerne | Pennsylvania | 42079 | 19723 | 506 |
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 |
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);