ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Greene" and fips = 42059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195401 | 1195401 | 2021-04-06 | Greene | Pennsylvania | 42059 | 2942 | 37 |
1192153 | 1192153 | 2021-04-05 | Greene | Pennsylvania | 42059 | 2913 | 37 |
1188904 | 1188904 | 2021-04-04 | Greene | Pennsylvania | 42059 | 2908 | 37 |
1185657 | 1185657 | 2021-04-03 | Greene | Pennsylvania | 42059 | 2907 | 37 |
1182410 | 1182410 | 2021-04-02 | Greene | Pennsylvania | 42059 | 2893 | 37 |
1179163 | 1179163 | 2021-04-01 | Greene | Pennsylvania | 42059 | 2876 | 37 |
1175916 | 1175916 | 2021-03-31 | Greene | Pennsylvania | 42059 | 2865 | 37 |
1172669 | 1172669 | 2021-03-30 | Greene | Pennsylvania | 42059 | 2854 | 37 |
1169422 | 1169422 | 2021-03-29 | Greene | Pennsylvania | 42059 | 2832 | 37 |
1166174 | 1166174 | 2021-03-28 | Greene | Pennsylvania | 42059 | 2820 | 37 |
1162926 | 1162926 | 2021-03-27 | Greene | Pennsylvania | 42059 | 2816 | 37 |
1159677 | 1159677 | 2021-03-26 | Greene | Pennsylvania | 42059 | 2806 | 37 |
1156430 | 1156430 | 2021-03-25 | Greene | Pennsylvania | 42059 | 2796 | 36 |
1153183 | 1153183 | 2021-03-24 | Greene | Pennsylvania | 42059 | 2791 | 36 |
1149936 | 1149936 | 2021-03-23 | Greene | Pennsylvania | 42059 | 2782 | 36 |
1146689 | 1146689 | 2021-03-22 | Greene | Pennsylvania | 42059 | 2775 | 35 |
1143442 | 1143442 | 2021-03-21 | Greene | Pennsylvania | 42059 | 2775 | 35 |
1140195 | 1140195 | 2021-03-20 | Greene | Pennsylvania | 42059 | 2770 | 35 |
1136949 | 1136949 | 2021-03-19 | Greene | Pennsylvania | 42059 | 2765 | 35 |
1133703 | 1133703 | 2021-03-18 | Greene | Pennsylvania | 42059 | 2755 | 35 |
1130455 | 1130455 | 2021-03-17 | Greene | Pennsylvania | 42059 | 2752 | 35 |
1127208 | 1127208 | 2021-03-16 | Greene | Pennsylvania | 42059 | 2747 | 35 |
1123962 | 1123962 | 2021-03-15 | Greene | Pennsylvania | 42059 | 2739 | 35 |
1120716 | 1120716 | 2021-03-14 | Greene | Pennsylvania | 42059 | 2735 | 34 |
1117469 | 1117469 | 2021-03-13 | Greene | Pennsylvania | 42059 | 2733 | 34 |
1114222 | 1114222 | 2021-03-12 | Greene | Pennsylvania | 42059 | 2727 | 34 |
1110976 | 1110976 | 2021-03-11 | Greene | Pennsylvania | 42059 | 2725 | 34 |
1107730 | 1107730 | 2021-03-10 | Greene | Pennsylvania | 42059 | 2720 | 33 |
1104484 | 1104484 | 2021-03-09 | Greene | Pennsylvania | 42059 | 2717 | 33 |
1101238 | 1101238 | 2021-03-08 | Greene | Pennsylvania | 42059 | 2713 | 33 |
1097992 | 1097992 | 2021-03-07 | Greene | Pennsylvania | 42059 | 2713 | 33 |
1094744 | 1094744 | 2021-03-06 | Greene | Pennsylvania | 42059 | 2705 | 33 |
1091498 | 1091498 | 2021-03-05 | Greene | Pennsylvania | 42059 | 2699 | 33 |
1088252 | 1088252 | 2021-03-04 | Greene | Pennsylvania | 42059 | 2693 | 33 |
1085007 | 1085007 | 2021-03-03 | Greene | Pennsylvania | 42059 | 2684 | 33 |
1081761 | 1081761 | 2021-03-02 | Greene | Pennsylvania | 42059 | 2680 | 33 |
1078515 | 1078515 | 2021-03-01 | Greene | Pennsylvania | 42059 | 2674 | 33 |
1075270 | 1075270 | 2021-02-28 | Greene | Pennsylvania | 42059 | 2671 | 33 |
1072024 | 1072024 | 2021-02-27 | Greene | Pennsylvania | 42059 | 2669 | 33 |
1068778 | 1068778 | 2021-02-26 | Greene | Pennsylvania | 42059 | 2666 | 33 |
1065533 | 1065533 | 2021-02-25 | Greene | Pennsylvania | 42059 | 2657 | 33 |
1062288 | 1062288 | 2021-02-24 | Greene | Pennsylvania | 42059 | 2648 | 32 |
1059043 | 1059043 | 2021-02-23 | Greene | Pennsylvania | 42059 | 2638 | 32 |
1055797 | 1055797 | 2021-02-22 | Greene | Pennsylvania | 42059 | 2622 | 32 |
1052551 | 1052551 | 2021-02-21 | Greene | Pennsylvania | 42059 | 2620 | 32 |
1049304 | 1049304 | 2021-02-20 | Greene | Pennsylvania | 42059 | 2614 | 32 |
1046057 | 1046057 | 2021-02-19 | Greene | Pennsylvania | 42059 | 2608 | 30 |
1042812 | 1042812 | 2021-02-18 | Greene | Pennsylvania | 42059 | 2597 | 30 |
1039567 | 1039567 | 2021-02-17 | Greene | Pennsylvania | 42059 | 2587 | 30 |
1036322 | 1036322 | 2021-02-16 | Greene | Pennsylvania | 42059 | 2579 | 30 |
1033077 | 1033077 | 2021-02-15 | Greene | Pennsylvania | 42059 | 2564 | 30 |
1029831 | 1029831 | 2021-02-14 | Greene | Pennsylvania | 42059 | 2556 | 30 |
1026584 | 1026584 | 2021-02-13 | Greene | Pennsylvania | 42059 | 2551 | 30 |
1023339 | 1023339 | 2021-02-12 | Greene | Pennsylvania | 42059 | 2532 | 30 |
1020094 | 1020094 | 2021-02-11 | Greene | Pennsylvania | 42059 | 2530 | 30 |
1016849 | 1016849 | 2021-02-10 | Greene | Pennsylvania | 42059 | 2515 | 30 |
1013604 | 1013604 | 2021-02-09 | Greene | Pennsylvania | 42059 | 2506 | 30 |
1010359 | 1010359 | 2021-02-08 | Greene | Pennsylvania | 42059 | 2483 | 30 |
1007113 | 1007113 | 2021-02-07 | Greene | Pennsylvania | 42059 | 2478 | 30 |
1003867 | 1003867 | 2021-02-06 | Greene | Pennsylvania | 42059 | 2474 | 30 |
1000621 | 1000621 | 2021-02-05 | Greene | Pennsylvania | 42059 | 2464 | 30 |
997375 | 997375 | 2021-02-04 | Greene | Pennsylvania | 42059 | 2456 | 30 |
994129 | 994129 | 2021-02-03 | Greene | Pennsylvania | 42059 | 2445 | 30 |
990883 | 990883 | 2021-02-02 | Greene | Pennsylvania | 42059 | 2434 | 30 |
987637 | 987637 | 2021-02-01 | Greene | Pennsylvania | 42059 | 2420 | 30 |
984390 | 984390 | 2021-01-31 | Greene | Pennsylvania | 42059 | 2413 | 30 |
981143 | 981143 | 2021-01-30 | Greene | Pennsylvania | 42059 | 2401 | 30 |
977897 | 977897 | 2021-01-29 | Greene | Pennsylvania | 42059 | 2385 | 30 |
974652 | 974652 | 2021-01-28 | Greene | Pennsylvania | 42059 | 2364 | 30 |
971407 | 971407 | 2021-01-27 | Greene | Pennsylvania | 42059 | 2351 | 30 |
968162 | 968162 | 2021-01-26 | Greene | Pennsylvania | 42059 | 2333 | 29 |
964918 | 964918 | 2021-01-25 | Greene | Pennsylvania | 42059 | 2319 | 29 |
961673 | 961673 | 2021-01-24 | Greene | Pennsylvania | 42059 | 2307 | 29 |
958428 | 958428 | 2021-01-23 | Greene | Pennsylvania | 42059 | 2295 | 28 |
955182 | 955182 | 2021-01-22 | Greene | Pennsylvania | 42059 | 2279 | 28 |
951937 | 951937 | 2021-01-21 | Greene | Pennsylvania | 42059 | 2267 | 27 |
948692 | 948692 | 2021-01-20 | Greene | Pennsylvania | 42059 | 2247 | 26 |
945446 | 945446 | 2021-01-19 | Greene | Pennsylvania | 42059 | 2223 | 26 |
942199 | 942199 | 2021-01-18 | Greene | Pennsylvania | 42059 | 2193 | 26 |
938954 | 938954 | 2021-01-17 | Greene | Pennsylvania | 42059 | 2178 | 26 |
935709 | 935709 | 2021-01-16 | Greene | Pennsylvania | 42059 | 2162 | 26 |
932464 | 932464 | 2021-01-15 | Greene | Pennsylvania | 42059 | 2135 | 25 |
929219 | 929219 | 2021-01-14 | Greene | Pennsylvania | 42059 | 2076 | 25 |
925974 | 925974 | 2021-01-13 | Greene | Pennsylvania | 42059 | 2081 | 23 |
922728 | 922728 | 2021-01-12 | Greene | Pennsylvania | 42059 | 2050 | 23 |
919483 | 919483 | 2021-01-11 | Greene | Pennsylvania | 42059 | 2022 | 22 |
916238 | 916238 | 2021-01-10 | Greene | Pennsylvania | 42059 | 2004 | 22 |
912993 | 912993 | 2021-01-09 | Greene | Pennsylvania | 42059 | 1965 | 21 |
909748 | 909748 | 2021-01-08 | Greene | Pennsylvania | 42059 | 1933 | 20 |
906503 | 906503 | 2021-01-07 | Greene | Pennsylvania | 42059 | 1889 | 19 |
903257 | 903257 | 2021-01-06 | Greene | Pennsylvania | 42059 | 1858 | 19 |
900012 | 900012 | 2021-01-05 | Greene | Pennsylvania | 42059 | 1820 | 17 |
896767 | 896767 | 2021-01-04 | Greene | Pennsylvania | 42059 | 1800 | 16 |
893521 | 893521 | 2021-01-03 | Greene | Pennsylvania | 42059 | 1774 | 15 |
890275 | 890275 | 2021-01-02 | Greene | Pennsylvania | 42059 | 1748 | 15 |
887028 | 887028 | 2021-01-01 | Greene | Pennsylvania | 42059 | 1717 | 15 |
883783 | 883783 | 2020-12-31 | Greene | Pennsylvania | 42059 | 1690 | 15 |
880538 | 880538 | 2020-12-30 | Greene | Pennsylvania | 42059 | 1659 | 14 |
877293 | 877293 | 2020-12-29 | Greene | Pennsylvania | 42059 | 1622 | 13 |
874048 | 874048 | 2020-12-28 | Greene | Pennsylvania | 42059 | 1574 | 13 |
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);