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 |
---|---|---|---|---|---|---|---|
1195411 | 1195411 | 2021-04-06 | Luzerne | Pennsylvania | 42079 | 27701 | 769 |
1192163 | 1192163 | 2021-04-05 | Luzerne | Pennsylvania | 42079 | 27593 | 769 |
1188914 | 1188914 | 2021-04-04 | Luzerne | Pennsylvania | 42079 | 27532 | 769 |
1185667 | 1185667 | 2021-04-03 | Luzerne | Pennsylvania | 42079 | 27434 | 769 |
1182420 | 1182420 | 2021-04-02 | Luzerne | Pennsylvania | 42079 | 27276 | 765 |
1179173 | 1179173 | 2021-04-01 | Luzerne | Pennsylvania | 42079 | 27185 | 764 |
1175926 | 1175926 | 2021-03-31 | Luzerne | Pennsylvania | 42079 | 27080 | 763 |
1172679 | 1172679 | 2021-03-30 | Luzerne | Pennsylvania | 42079 | 26975 | 763 |
1169432 | 1169432 | 2021-03-29 | Luzerne | Pennsylvania | 42079 | 26869 | 762 |
1166184 | 1166184 | 2021-03-28 | Luzerne | Pennsylvania | 42079 | 26788 | 760 |
1162936 | 1162936 | 2021-03-27 | Luzerne | Pennsylvania | 42079 | 26705 | 759 |
1159687 | 1159687 | 2021-03-26 | Luzerne | Pennsylvania | 42079 | 26614 | 758 |
1156440 | 1156440 | 2021-03-25 | Luzerne | Pennsylvania | 42079 | 26479 | 757 |
1153193 | 1153193 | 2021-03-24 | Luzerne | Pennsylvania | 42079 | 26376 | 756 |
1149946 | 1149946 | 2021-03-23 | Luzerne | Pennsylvania | 42079 | 26254 | 756 |
1146699 | 1146699 | 2021-03-22 | Luzerne | Pennsylvania | 42079 | 26204 | 756 |
1143452 | 1143452 | 2021-03-21 | Luzerne | Pennsylvania | 42079 | 26158 | 756 |
1140205 | 1140205 | 2021-03-20 | Luzerne | Pennsylvania | 42079 | 26092 | 756 |
1136959 | 1136959 | 2021-03-19 | Luzerne | Pennsylvania | 42079 | 25972 | 755 |
1133713 | 1133713 | 2021-03-18 | Luzerne | Pennsylvania | 42079 | 25922 | 754 |
1130465 | 1130465 | 2021-03-17 | Luzerne | Pennsylvania | 42079 | 25844 | 751 |
1127218 | 1127218 | 2021-03-16 | Luzerne | Pennsylvania | 42079 | 25766 | 751 |
1123972 | 1123972 | 2021-03-15 | Luzerne | Pennsylvania | 42079 | 25713 | 747 |
1120726 | 1120726 | 2021-03-14 | Luzerne | Pennsylvania | 42079 | 25687 | 746 |
1117479 | 1117479 | 2021-03-13 | Luzerne | Pennsylvania | 42079 | 25614 | 746 |
1114232 | 1114232 | 2021-03-12 | Luzerne | Pennsylvania | 42079 | 25530 | 746 |
1110986 | 1110986 | 2021-03-11 | Luzerne | Pennsylvania | 42079 | 25461 | 746 |
1107740 | 1107740 | 2021-03-10 | Luzerne | Pennsylvania | 42079 | 25390 | 746 |
1104494 | 1104494 | 2021-03-09 | Luzerne | Pennsylvania | 42079 | 25335 | 744 |
1101248 | 1101248 | 2021-03-08 | Luzerne | Pennsylvania | 42079 | 25268 | 744 |
1098002 | 1098002 | 2021-03-07 | Luzerne | Pennsylvania | 42079 | 25248 | 743 |
1094754 | 1094754 | 2021-03-06 | Luzerne | Pennsylvania | 42079 | 25209 | 741 |
1091508 | 1091508 | 2021-03-05 | Luzerne | Pennsylvania | 42079 | 25165 | 741 |
1088262 | 1088262 | 2021-03-04 | Luzerne | Pennsylvania | 42079 | 25097 | 739 |
1085017 | 1085017 | 2021-03-03 | Luzerne | Pennsylvania | 42079 | 25033 | 735 |
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 |
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);