ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Warren" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195433 | 1195433 | 2021-04-06 | Warren | Pennsylvania | 42123 | 2321 | 99 |
1192185 | 1192185 | 2021-04-05 | Warren | Pennsylvania | 42123 | 2315 | 99 |
1188936 | 1188936 | 2021-04-04 | Warren | Pennsylvania | 42123 | 2300 | 99 |
1185689 | 1185689 | 2021-04-03 | Warren | Pennsylvania | 42123 | 2296 | 99 |
1182442 | 1182442 | 2021-04-02 | Warren | Pennsylvania | 42123 | 2289 | 99 |
1179195 | 1179195 | 2021-04-01 | Warren | Pennsylvania | 42123 | 2284 | 99 |
1175948 | 1175948 | 2021-03-31 | Warren | Pennsylvania | 42123 | 2280 | 99 |
1172701 | 1172701 | 2021-03-30 | Warren | Pennsylvania | 42123 | 2274 | 99 |
1169454 | 1169454 | 2021-03-29 | Warren | Pennsylvania | 42123 | 2268 | 99 |
1166206 | 1166206 | 2021-03-28 | Warren | Pennsylvania | 42123 | 2267 | 99 |
1162958 | 1162958 | 2021-03-27 | Warren | Pennsylvania | 42123 | 2266 | 99 |
1159709 | 1159709 | 2021-03-26 | Warren | Pennsylvania | 42123 | 2264 | 99 |
1156462 | 1156462 | 2021-03-25 | Warren | Pennsylvania | 42123 | 2258 | 98 |
1153215 | 1153215 | 2021-03-24 | Warren | Pennsylvania | 42123 | 2255 | 98 |
1149968 | 1149968 | 2021-03-23 | Warren | Pennsylvania | 42123 | 2251 | 98 |
1146721 | 1146721 | 2021-03-22 | Warren | Pennsylvania | 42123 | 2247 | 98 |
1143474 | 1143474 | 2021-03-21 | Warren | Pennsylvania | 42123 | 2247 | 98 |
1140227 | 1140227 | 2021-03-20 | Warren | Pennsylvania | 42123 | 2247 | 98 |
1136981 | 1136981 | 2021-03-19 | Warren | Pennsylvania | 42123 | 2244 | 98 |
1133735 | 1133735 | 2021-03-18 | Warren | Pennsylvania | 42123 | 2243 | 98 |
1130487 | 1130487 | 2021-03-17 | Warren | Pennsylvania | 42123 | 2241 | 98 |
1127240 | 1127240 | 2021-03-16 | Warren | Pennsylvania | 42123 | 2237 | 98 |
1123994 | 1123994 | 2021-03-15 | Warren | Pennsylvania | 42123 | 2233 | 98 |
1120748 | 1120748 | 2021-03-14 | Warren | Pennsylvania | 42123 | 2232 | 98 |
1117501 | 1117501 | 2021-03-13 | Warren | Pennsylvania | 42123 | 2232 | 98 |
1114254 | 1114254 | 2021-03-12 | Warren | Pennsylvania | 42123 | 2224 | 98 |
1111008 | 1111008 | 2021-03-11 | Warren | Pennsylvania | 42123 | 2224 | 98 |
1107762 | 1107762 | 2021-03-10 | Warren | Pennsylvania | 42123 | 2216 | 98 |
1104516 | 1104516 | 2021-03-09 | Warren | Pennsylvania | 42123 | 2214 | 98 |
1101270 | 1101270 | 2021-03-08 | Warren | Pennsylvania | 42123 | 2209 | 98 |
1098024 | 1098024 | 2021-03-07 | Warren | Pennsylvania | 42123 | 2203 | 98 |
1094776 | 1094776 | 2021-03-06 | Warren | Pennsylvania | 42123 | 2204 | 98 |
1091530 | 1091530 | 2021-03-05 | Warren | Pennsylvania | 42123 | 2198 | 98 |
1088284 | 1088284 | 2021-03-04 | Warren | Pennsylvania | 42123 | 2195 | 98 |
1085039 | 1085039 | 2021-03-03 | Warren | Pennsylvania | 42123 | 2189 | 98 |
1081793 | 1081793 | 2021-03-02 | Warren | Pennsylvania | 42123 | 2186 | 98 |
1078547 | 1078547 | 2021-03-01 | Warren | Pennsylvania | 42123 | 2166 | 98 |
1075302 | 1075302 | 2021-02-28 | Warren | Pennsylvania | 42123 | 2160 | 98 |
1072056 | 1072056 | 2021-02-27 | Warren | Pennsylvania | 42123 | 2156 | 98 |
1068810 | 1068810 | 2021-02-26 | Warren | Pennsylvania | 42123 | 2153 | 98 |
1065565 | 1065565 | 2021-02-25 | Warren | Pennsylvania | 42123 | 2144 | 98 |
1062320 | 1062320 | 2021-02-24 | Warren | Pennsylvania | 42123 | 2142 | 97 |
1059075 | 1059075 | 2021-02-23 | Warren | Pennsylvania | 42123 | 2140 | 96 |
1055829 | 1055829 | 2021-02-22 | Warren | Pennsylvania | 42123 | 2135 | 96 |
1052583 | 1052583 | 2021-02-21 | Warren | Pennsylvania | 42123 | 2132 | 96 |
1049336 | 1049336 | 2021-02-20 | Warren | Pennsylvania | 42123 | 2132 | 96 |
1046089 | 1046089 | 2021-02-19 | Warren | Pennsylvania | 42123 | 2122 | 96 |
1042844 | 1042844 | 2021-02-18 | Warren | Pennsylvania | 42123 | 2114 | 96 |
1039599 | 1039599 | 2021-02-17 | Warren | Pennsylvania | 42123 | 2112 | 95 |
1036354 | 1036354 | 2021-02-16 | Warren | Pennsylvania | 42123 | 2110 | 95 |
1033109 | 1033109 | 2021-02-15 | Warren | Pennsylvania | 42123 | 2107 | 95 |
1029863 | 1029863 | 2021-02-14 | Warren | Pennsylvania | 42123 | 2105 | 95 |
1026616 | 1026616 | 2021-02-13 | Warren | Pennsylvania | 42123 | 2103 | 95 |
1023371 | 1023371 | 2021-02-12 | Warren | Pennsylvania | 42123 | 2091 | 95 |
1020126 | 1020126 | 2021-02-11 | Warren | Pennsylvania | 42123 | 2089 | 95 |
1016881 | 1016881 | 2021-02-10 | Warren | Pennsylvania | 42123 | 2086 | 95 |
1013636 | 1013636 | 2021-02-09 | Warren | Pennsylvania | 42123 | 2075 | 95 |
1010391 | 1010391 | 2021-02-08 | Warren | Pennsylvania | 42123 | 2072 | 95 |
1007145 | 1007145 | 2021-02-07 | Warren | Pennsylvania | 42123 | 2069 | 95 |
1003899 | 1003899 | 2021-02-06 | Warren | Pennsylvania | 42123 | 2054 | 95 |
1000653 | 1000653 | 2021-02-05 | Warren | Pennsylvania | 42123 | 2048 | 95 |
997407 | 997407 | 2021-02-04 | Warren | Pennsylvania | 42123 | 2045 | 95 |
994161 | 994161 | 2021-02-03 | Warren | Pennsylvania | 42123 | 2040 | 92 |
990915 | 990915 | 2021-02-02 | Warren | Pennsylvania | 42123 | 2035 | 92 |
987669 | 987669 | 2021-02-01 | Warren | Pennsylvania | 42123 | 2027 | 92 |
984422 | 984422 | 2021-01-31 | Warren | Pennsylvania | 42123 | 2021 | 91 |
981175 | 981175 | 2021-01-30 | Warren | Pennsylvania | 42123 | 2019 | 90 |
977929 | 977929 | 2021-01-29 | Warren | Pennsylvania | 42123 | 1981 | 88 |
974684 | 974684 | 2021-01-28 | Warren | Pennsylvania | 42123 | 1976 | 88 |
971439 | 971439 | 2021-01-27 | Warren | Pennsylvania | 42123 | 1970 | 85 |
968194 | 968194 | 2021-01-26 | Warren | Pennsylvania | 42123 | 1959 | 82 |
964950 | 964950 | 2021-01-25 | Warren | Pennsylvania | 42123 | 1952 | 81 |
961705 | 961705 | 2021-01-24 | Warren | Pennsylvania | 42123 | 1942 | 81 |
958460 | 958460 | 2021-01-23 | Warren | Pennsylvania | 42123 | 1933 | 81 |
955214 | 955214 | 2021-01-22 | Warren | Pennsylvania | 42123 | 1921 | 80 |
951969 | 951969 | 2021-01-21 | Warren | Pennsylvania | 42123 | 1906 | 78 |
948724 | 948724 | 2021-01-20 | Warren | Pennsylvania | 42123 | 1889 | 75 |
945478 | 945478 | 2021-01-19 | Warren | Pennsylvania | 42123 | 1872 | 73 |
942231 | 942231 | 2021-01-18 | Warren | Pennsylvania | 42123 | 1869 | 73 |
938986 | 938986 | 2021-01-17 | Warren | Pennsylvania | 42123 | 1849 | 70 |
935741 | 935741 | 2021-01-16 | Warren | Pennsylvania | 42123 | 1845 | 69 |
932496 | 932496 | 2021-01-15 | Warren | Pennsylvania | 42123 | 1839 | 68 |
929251 | 929251 | 2021-01-14 | Warren | Pennsylvania | 42123 | 1828 | 65 |
926006 | 926006 | 2021-01-13 | Warren | Pennsylvania | 42123 | 1813 | 63 |
922760 | 922760 | 2021-01-12 | Warren | Pennsylvania | 42123 | 1787 | 56 |
919515 | 919515 | 2021-01-11 | Warren | Pennsylvania | 42123 | 1773 | 53 |
916270 | 916270 | 2021-01-10 | Warren | Pennsylvania | 42123 | 1755 | 53 |
913025 | 913025 | 2021-01-09 | Warren | Pennsylvania | 42123 | 1751 | 52 |
909780 | 909780 | 2021-01-08 | Warren | Pennsylvania | 42123 | 1707 | 51 |
906535 | 906535 | 2021-01-07 | Warren | Pennsylvania | 42123 | 1677 | 46 |
903289 | 903289 | 2021-01-06 | Warren | Pennsylvania | 42123 | 1661 | 45 |
900044 | 900044 | 2021-01-05 | Warren | Pennsylvania | 42123 | 1636 | 40 |
896799 | 896799 | 2021-01-04 | Warren | Pennsylvania | 42123 | 1586 | 37 |
893553 | 893553 | 2021-01-03 | Warren | Pennsylvania | 42123 | 1577 | 36 |
890307 | 890307 | 2021-01-02 | Warren | Pennsylvania | 42123 | 1560 | 36 |
887060 | 887060 | 2021-01-01 | Warren | Pennsylvania | 42123 | 1531 | 36 |
883815 | 883815 | 2020-12-31 | Warren | Pennsylvania | 42123 | 1474 | 28 |
880570 | 880570 | 2020-12-30 | Warren | Pennsylvania | 42123 | 1460 | 26 |
877325 | 877325 | 2020-12-29 | Warren | Pennsylvania | 42123 | 1425 | 25 |
874080 | 874080 | 2020-12-28 | Warren | Pennsylvania | 42123 | 1372 | 25 |
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);