ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Union" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055827 | 1055827 | 2021-02-22 | Union | Pennsylvania | 42119 | 5093 | 80 |
1052581 | 1052581 | 2021-02-21 | Union | Pennsylvania | 42119 | 5091 | 80 |
1049334 | 1049334 | 2021-02-20 | Union | Pennsylvania | 42119 | 5082 | 80 |
1046087 | 1046087 | 2021-02-19 | Union | Pennsylvania | 42119 | 5068 | 80 |
1042842 | 1042842 | 2021-02-18 | Union | Pennsylvania | 42119 | 5066 | 80 |
1039597 | 1039597 | 2021-02-17 | Union | Pennsylvania | 42119 | 5070 | 80 |
1036352 | 1036352 | 2021-02-16 | Union | Pennsylvania | 42119 | 5059 | 80 |
1033107 | 1033107 | 2021-02-15 | Union | Pennsylvania | 42119 | 5054 | 79 |
1029861 | 1029861 | 2021-02-14 | Union | Pennsylvania | 42119 | 5021 | 79 |
1026614 | 1026614 | 2021-02-13 | Union | Pennsylvania | 42119 | 4991 | 79 |
1023369 | 1023369 | 2021-02-12 | Union | Pennsylvania | 42119 | 4976 | 79 |
1020124 | 1020124 | 2021-02-11 | Union | Pennsylvania | 42119 | 4950 | 78 |
1016879 | 1016879 | 2021-02-10 | Union | Pennsylvania | 42119 | 4913 | 78 |
1013634 | 1013634 | 2021-02-09 | Union | Pennsylvania | 42119 | 4913 | 77 |
1010389 | 1010389 | 2021-02-08 | Union | Pennsylvania | 42119 | 4893 | 77 |
1007143 | 1007143 | 2021-02-07 | Union | Pennsylvania | 42119 | 4876 | 77 |
1003897 | 1003897 | 2021-02-06 | Union | Pennsylvania | 42119 | 4856 | 77 |
1000651 | 1000651 | 2021-02-05 | Union | Pennsylvania | 42119 | 4854 | 77 |
997405 | 997405 | 2021-02-04 | Union | Pennsylvania | 42119 | 4116 | 74 |
994159 | 994159 | 2021-02-03 | Union | Pennsylvania | 42119 | 4089 | 74 |
990913 | 990913 | 2021-02-02 | Union | Pennsylvania | 42119 | 4080 | 74 |
987667 | 987667 | 2021-02-01 | Union | Pennsylvania | 42119 | 4071 | 74 |
984420 | 984420 | 2021-01-31 | Union | Pennsylvania | 42119 | 4056 | 74 |
981173 | 981173 | 2021-01-30 | Union | Pennsylvania | 42119 | 4039 | 72 |
977927 | 977927 | 2021-01-29 | Union | Pennsylvania | 42119 | 4011 | 72 |
974682 | 974682 | 2021-01-28 | Union | Pennsylvania | 42119 | 3972 | 71 |
971437 | 971437 | 2021-01-27 | Union | Pennsylvania | 42119 | 3946 | 70 |
968192 | 968192 | 2021-01-26 | Union | Pennsylvania | 42119 | 3915 | 69 |
964948 | 964948 | 2021-01-25 | Union | Pennsylvania | 42119 | 3892 | 69 |
961703 | 961703 | 2021-01-24 | Union | Pennsylvania | 42119 | 3866 | 68 |
958458 | 958458 | 2021-01-23 | Union | Pennsylvania | 42119 | 3849 | 68 |
955212 | 955212 | 2021-01-22 | Union | Pennsylvania | 42119 | 3812 | 68 |
951967 | 951967 | 2021-01-21 | Union | Pennsylvania | 42119 | 3777 | 67 |
948722 | 948722 | 2021-01-20 | Union | Pennsylvania | 42119 | 3747 | 66 |
945476 | 945476 | 2021-01-19 | Union | Pennsylvania | 42119 | 3688 | 62 |
942229 | 942229 | 2021-01-18 | Union | Pennsylvania | 42119 | 3673 | 61 |
938984 | 938984 | 2021-01-17 | Union | Pennsylvania | 42119 | 3667 | 61 |
935739 | 935739 | 2021-01-16 | Union | Pennsylvania | 42119 | 3647 | 60 |
932494 | 932494 | 2021-01-15 | Union | Pennsylvania | 42119 | 3613 | 59 |
929249 | 929249 | 2021-01-14 | Union | Pennsylvania | 42119 | 3589 | 55 |
926004 | 926004 | 2021-01-13 | Union | Pennsylvania | 42119 | 3560 | 54 |
922758 | 922758 | 2021-01-12 | Union | Pennsylvania | 42119 | 3452 | 53 |
919513 | 919513 | 2021-01-11 | Union | Pennsylvania | 42119 | 3416 | 52 |
916268 | 916268 | 2021-01-10 | Union | Pennsylvania | 42119 | 3381 | 52 |
913023 | 913023 | 2021-01-09 | Union | Pennsylvania | 42119 | 3340 | 52 |
909778 | 909778 | 2021-01-08 | Union | Pennsylvania | 42119 | 3235 | 49 |
906533 | 906533 | 2021-01-07 | Union | Pennsylvania | 42119 | 3157 | 49 |
903287 | 903287 | 2021-01-06 | Union | Pennsylvania | 42119 | 3102 | 47 |
900042 | 900042 | 2021-01-05 | Union | Pennsylvania | 42119 | 3049 | 44 |
896797 | 896797 | 2021-01-04 | Union | Pennsylvania | 42119 | 3001 | 44 |
893551 | 893551 | 2021-01-03 | Union | Pennsylvania | 42119 | 2983 | 43 |
890305 | 890305 | 2021-01-02 | Union | Pennsylvania | 42119 | 2953 | 43 |
887058 | 887058 | 2021-01-01 | Union | Pennsylvania | 42119 | 2940 | 43 |
883813 | 883813 | 2020-12-31 | Union | Pennsylvania | 42119 | 2891 | 42 |
880568 | 880568 | 2020-12-30 | Union | Pennsylvania | 42119 | 2850 | 39 |
877323 | 877323 | 2020-12-29 | Union | Pennsylvania | 42119 | 2816 | 39 |
874078 | 874078 | 2020-12-28 | Union | Pennsylvania | 42119 | 2789 | 34 |
870833 | 870833 | 2020-12-27 | Union | Pennsylvania | 42119 | 2773 | 34 |
867588 | 867588 | 2020-12-26 | Union | Pennsylvania | 42119 | 2755 | 33 |
864343 | 864343 | 2020-12-25 | Union | Pennsylvania | 42119 | 2719 | 33 |
861098 | 861098 | 2020-12-24 | Union | Pennsylvania | 42119 | 2648 | 31 |
857853 | 857853 | 2020-12-23 | Union | Pennsylvania | 42119 | 2622 | 29 |
854608 | 854608 | 2020-12-22 | Union | Pennsylvania | 42119 | 2567 | 29 |
851363 | 851363 | 2020-12-21 | Union | Pennsylvania | 42119 | 2505 | 27 |
848118 | 848118 | 2020-12-20 | Union | Pennsylvania | 42119 | 2453 | 26 |
844873 | 844873 | 2020-12-19 | Union | Pennsylvania | 42119 | 2423 | 26 |
841627 | 841627 | 2020-12-18 | Union | Pennsylvania | 42119 | 2354 | 24 |
838382 | 838382 | 2020-12-17 | Union | Pennsylvania | 42119 | 2323 | 24 |
835136 | 835136 | 2020-12-16 | Union | Pennsylvania | 42119 | 2279 | 24 |
831890 | 831890 | 2020-12-15 | Union | Pennsylvania | 42119 | 2235 | 22 |
828643 | 828643 | 2020-12-14 | Union | Pennsylvania | 42119 | 2219 | 19 |
825397 | 825397 | 2020-12-13 | Union | Pennsylvania | 42119 | 2180 | 19 |
822150 | 822150 | 2020-12-12 | Union | Pennsylvania | 42119 | 2132 | 19 |
818904 | 818904 | 2020-12-11 | Union | Pennsylvania | 42119 | 2100 | 19 |
815658 | 815658 | 2020-12-10 | Union | Pennsylvania | 42119 | 2039 | 19 |
812412 | 812412 | 2020-12-09 | Union | Pennsylvania | 42119 | 1984 | 19 |
809168 | 809168 | 2020-12-08 | Union | Pennsylvania | 42119 | 1954 | 19 |
805923 | 805923 | 2020-12-07 | Union | Pennsylvania | 42119 | 1919 | 19 |
802678 | 802678 | 2020-12-06 | Union | Pennsylvania | 42119 | 1887 | 19 |
799433 | 799433 | 2020-12-05 | Union | Pennsylvania | 42119 | 1870 | 19 |
796188 | 796188 | 2020-12-04 | Union | Pennsylvania | 42119 | 1829 | 19 |
792943 | 792943 | 2020-12-03 | Union | Pennsylvania | 42119 | 1781 | 17 |
789698 | 789698 | 2020-12-02 | Union | Pennsylvania | 42119 | 1739 | 17 |
786453 | 786453 | 2020-12-01 | Union | Pennsylvania | 42119 | 1709 | 17 |
783209 | 783209 | 2020-11-30 | Union | Pennsylvania | 42119 | 1679 | 16 |
779964 | 779964 | 2020-11-29 | Union | Pennsylvania | 42119 | 1663 | 16 |
776718 | 776718 | 2020-11-28 | Union | Pennsylvania | 42119 | 1643 | 16 |
773473 | 773473 | 2020-11-27 | Union | Pennsylvania | 42119 | 1620 | 16 |
770228 | 770228 | 2020-11-26 | Union | Pennsylvania | 42119 | 1553 | 16 |
766982 | 766982 | 2020-11-25 | Union | Pennsylvania | 42119 | 1456 | 16 |
763737 | 763737 | 2020-11-24 | Union | Pennsylvania | 42119 | 1378 | 15 |
760492 | 760492 | 2020-11-23 | Union | Pennsylvania | 42119 | 1335 | 15 |
757247 | 757247 | 2020-11-22 | Union | Pennsylvania | 42119 | 1308 | 15 |
754000 | 754000 | 2020-11-21 | Union | Pennsylvania | 42119 | 1234 | 15 |
750754 | 750754 | 2020-11-20 | Union | Pennsylvania | 42119 | 1187 | 15 |
747508 | 747508 | 2020-11-19 | Union | Pennsylvania | 42119 | 1084 | 14 |
744262 | 744262 | 2020-11-18 | Union | Pennsylvania | 42119 | 1041 | 13 |
741015 | 741015 | 2020-11-17 | Union | Pennsylvania | 42119 | 1031 | 13 |
737769 | 737769 | 2020-11-16 | Union | Pennsylvania | 42119 | 1016 | 12 |
734525 | 734525 | 2020-11-15 | Union | Pennsylvania | 42119 | 1003 | 12 |
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);