ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Crawford" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176482 | 2176482 | 2022-02-02 | Crawford | Pennsylvania | 42039 | 19036 | 285 |
2173228 | 2173228 | 2022-02-01 | Crawford | Pennsylvania | 42039 | 18989 | 283 |
2169976 | 2169976 | 2022-01-31 | Crawford | Pennsylvania | 42039 | 18931 | 278 |
2166722 | 2166722 | 2022-01-30 | Crawford | Pennsylvania | 42039 | 18894 | 278 |
2163467 | 2163467 | 2022-01-29 | Crawford | Pennsylvania | 42039 | 18779 | 278 |
2160212 | 2160212 | 2022-01-28 | Crawford | Pennsylvania | 42039 | 18707 | 277 |
2156956 | 2156956 | 2022-01-27 | Crawford | Pennsylvania | 42039 | 18608 | 277 |
2153703 | 2153703 | 2022-01-26 | Crawford | Pennsylvania | 42039 | 18485 | 275 |
2150451 | 2150451 | 2022-01-25 | Crawford | Pennsylvania | 42039 | 18393 | 274 |
2147199 | 2147199 | 2022-01-24 | Crawford | Pennsylvania | 42039 | 18314 | 272 |
2143945 | 2143945 | 2022-01-23 | Crawford | Pennsylvania | 42039 | 18292 | 272 |
2140690 | 2140690 | 2022-01-22 | Crawford | Pennsylvania | 42039 | 18185 | 272 |
2137434 | 2137434 | 2022-01-21 | Crawford | Pennsylvania | 42039 | 18063 | 272 |
2134180 | 2134180 | 2022-01-20 | Crawford | Pennsylvania | 42039 | 17788 | 271 |
2130928 | 2130928 | 2022-01-19 | Crawford | Pennsylvania | 42039 | 17709 | 270 |
2127674 | 2127674 | 2022-01-18 | Crawford | Pennsylvania | 42039 | 17626 | 270 |
2124422 | 2124422 | 2022-01-17 | Crawford | Pennsylvania | 42039 | 17559 | 270 |
2121170 | 2121170 | 2022-01-16 | Crawford | Pennsylvania | 42039 | 17425 | 270 |
2117918 | 2117918 | 2022-01-15 | Crawford | Pennsylvania | 42039 | 17160 | 270 |
2114667 | 2114667 | 2022-01-14 | Crawford | Pennsylvania | 42039 | 16991 | 268 |
2111415 | 2111415 | 2022-01-13 | Crawford | Pennsylvania | 42039 | 16809 | 267 |
2108163 | 2108163 | 2022-01-12 | Crawford | Pennsylvania | 42039 | 16723 | 265 |
2104912 | 2104912 | 2022-01-11 | Crawford | Pennsylvania | 42039 | 16539 | 265 |
2101661 | 2101661 | 2022-01-10 | Crawford | Pennsylvania | 42039 | 16377 | 264 |
2098410 | 2098410 | 2022-01-09 | Crawford | Pennsylvania | 42039 | 16304 | 264 |
2095158 | 2095158 | 2022-01-08 | Crawford | Pennsylvania | 42039 | 16182 | 264 |
2091906 | 2091906 | 2022-01-07 | Crawford | Pennsylvania | 42039 | 16027 | 264 |
2088654 | 2088654 | 2022-01-06 | Crawford | Pennsylvania | 42039 | 15852 | 264 |
2085403 | 2085403 | 2022-01-05 | Crawford | Pennsylvania | 42039 | 15731 | 262 |
2082151 | 2082151 | 2022-01-04 | Crawford | Pennsylvania | 42039 | 15542 | 261 |
2078899 | 2078899 | 2022-01-03 | Crawford | Pennsylvania | 42039 | 15466 | 261 |
2075648 | 2075648 | 2022-01-02 | Crawford | Pennsylvania | 42039 | 15413 | 260 |
2072397 | 2072397 | 2022-01-01 | Crawford | Pennsylvania | 42039 | 15298 | 260 |
2069146 | 2069146 | 2021-12-31 | Crawford | Pennsylvania | 42039 | 15155 | 260 |
2065895 | 2065895 | 2021-12-30 | Crawford | Pennsylvania | 42039 | 15075 | 259 |
2062645 | 2062645 | 2021-12-29 | Crawford | Pennsylvania | 42039 | 14960 | 258 |
2059395 | 2059395 | 2021-12-28 | Crawford | Pennsylvania | 42039 | 14908 | 256 |
2056146 | 2056146 | 2021-12-27 | Crawford | Pennsylvania | 42039 | 14882 | 253 |
2052897 | 2052897 | 2021-12-26 | Crawford | Pennsylvania | 42039 | 14870 | 253 |
2049647 | 2049647 | 2021-12-25 | Crawford | Pennsylvania | 42039 | 14836 | 253 |
2046397 | 2046397 | 2021-12-24 | Crawford | Pennsylvania | 42039 | 14778 | 253 |
2043147 | 2043147 | 2021-12-23 | Crawford | Pennsylvania | 42039 | 14715 | 253 |
2039898 | 2039898 | 2021-12-22 | Crawford | Pennsylvania | 42039 | 14656 | 252 |
2036648 | 2036648 | 2021-12-21 | Crawford | Pennsylvania | 42039 | 14609 | 249 |
2033398 | 2033398 | 2021-12-20 | Crawford | Pennsylvania | 42039 | 14577 | 245 |
2030148 | 2030148 | 2021-12-19 | Crawford | Pennsylvania | 42039 | 14558 | 245 |
2026897 | 2026897 | 2021-12-18 | Crawford | Pennsylvania | 42039 | 14527 | 245 |
2023646 | 2023646 | 2021-12-17 | Crawford | Pennsylvania | 42039 | 14462 | 241 |
2020395 | 2020395 | 2021-12-16 | Crawford | Pennsylvania | 42039 | 14417 | 239 |
2017144 | 2017144 | 2021-12-15 | Crawford | Pennsylvania | 42039 | 14369 | 238 |
2013894 | 2013894 | 2021-12-14 | Crawford | Pennsylvania | 42039 | 14326 | 235 |
2010643 | 2010643 | 2021-12-13 | Crawford | Pennsylvania | 42039 | 14285 | 234 |
2007392 | 2007392 | 2021-12-12 | Crawford | Pennsylvania | 42039 | 14263 | 234 |
2004141 | 2004141 | 2021-12-11 | Crawford | Pennsylvania | 42039 | 14215 | 234 |
2000890 | 2000890 | 2021-12-10 | Crawford | Pennsylvania | 42039 | 14127 | 231 |
1997640 | 1997640 | 2021-12-09 | Crawford | Pennsylvania | 42039 | 14050 | 230 |
1994389 | 1994389 | 2021-12-08 | Crawford | Pennsylvania | 42039 | 13976 | 230 |
1991138 | 1991138 | 2021-12-07 | Crawford | Pennsylvania | 42039 | 13908 | 228 |
1987887 | 1987887 | 2021-12-06 | Crawford | Pennsylvania | 42039 | 13840 | 226 |
1984637 | 1984637 | 2021-12-05 | Crawford | Pennsylvania | 42039 | 13776 | 226 |
1981387 | 1981387 | 2021-12-04 | Crawford | Pennsylvania | 42039 | 13730 | 225 |
1978137 | 1978137 | 2021-12-03 | Crawford | Pennsylvania | 42039 | 13601 | 223 |
1974887 | 1974887 | 2021-12-02 | Crawford | Pennsylvania | 42039 | 13466 | 222 |
1971638 | 1971638 | 2021-12-01 | Crawford | Pennsylvania | 42039 | 13354 | 218 |
1968388 | 1968388 | 2021-11-30 | Crawford | Pennsylvania | 42039 | 13313 | 218 |
1965137 | 1965137 | 2021-11-29 | Crawford | Pennsylvania | 42039 | 13264 | 218 |
1961885 | 1961885 | 2021-11-28 | Crawford | Pennsylvania | 42039 | 13184 | 218 |
1958634 | 1958634 | 2021-11-27 | Crawford | Pennsylvania | 42039 | 13170 | 218 |
1955383 | 1955383 | 2021-11-26 | Crawford | Pennsylvania | 42039 | 13108 | 218 |
1952132 | 1952132 | 2021-11-25 | Crawford | Pennsylvania | 42039 | 13046 | 218 |
1948881 | 1948881 | 2021-11-24 | Crawford | Pennsylvania | 42039 | 12949 | 217 |
1945630 | 1945630 | 2021-11-23 | Crawford | Pennsylvania | 42039 | 12855 | 216 |
1942379 | 1942379 | 2021-11-22 | Crawford | Pennsylvania | 42039 | 12816 | 213 |
1939129 | 1939129 | 2021-11-21 | Crawford | Pennsylvania | 42039 | 12705 | 213 |
1935879 | 1935879 | 2021-11-20 | Crawford | Pennsylvania | 42039 | 12625 | 213 |
1932629 | 1932629 | 2021-11-19 | Crawford | Pennsylvania | 42039 | 12510 | 211 |
1929378 | 1929378 | 2021-11-18 | Crawford | Pennsylvania | 42039 | 12260 | 209 |
1926128 | 1926128 | 2021-11-17 | Crawford | Pennsylvania | 42039 | 12199 | 204 |
1922878 | 1922878 | 2021-11-16 | Crawford | Pennsylvania | 42039 | 12128 | 203 |
1919629 | 1919629 | 2021-11-15 | Crawford | Pennsylvania | 42039 | 12088 | 201 |
1916379 | 1916379 | 2021-11-14 | Crawford | Pennsylvania | 42039 | 12053 | 201 |
1913129 | 1913129 | 2021-11-13 | Crawford | Pennsylvania | 42039 | 12006 | 200 |
1909879 | 1909879 | 2021-11-12 | Crawford | Pennsylvania | 42039 | 11757 | 197 |
1906630 | 1906630 | 2021-11-11 | Crawford | Pennsylvania | 42039 | 11681 | 197 |
1903381 | 1903381 | 2021-11-10 | Crawford | Pennsylvania | 42039 | 11589 | 197 |
1900131 | 1900131 | 2021-11-09 | Crawford | Pennsylvania | 42039 | 11509 | 194 |
1896881 | 1896881 | 2021-11-08 | Crawford | Pennsylvania | 42039 | 11457 | 193 |
1893631 | 1893631 | 2021-11-07 | Crawford | Pennsylvania | 42039 | 11414 | 193 |
1890381 | 1890381 | 2021-11-06 | Crawford | Pennsylvania | 42039 | 11365 | 193 |
1887131 | 1887131 | 2021-11-05 | Crawford | Pennsylvania | 42039 | 11310 | 193 |
1883881 | 1883881 | 2021-11-04 | Crawford | Pennsylvania | 42039 | 11241 | 193 |
1880632 | 1880632 | 2021-11-03 | Crawford | Pennsylvania | 42039 | 11187 | 193 |
1877383 | 1877383 | 2021-11-02 | Crawford | Pennsylvania | 42039 | 11118 | 190 |
1874134 | 1874134 | 2021-11-01 | Crawford | Pennsylvania | 42039 | 11055 | 190 |
1870885 | 1870885 | 2021-10-31 | Crawford | Pennsylvania | 42039 | 11055 | 190 |
1867636 | 1867636 | 2021-10-30 | Crawford | Pennsylvania | 42039 | 11015 | 190 |
1864387 | 1864387 | 2021-10-29 | Crawford | Pennsylvania | 42039 | 10969 | 190 |
1861138 | 1861138 | 2021-10-28 | Crawford | Pennsylvania | 42039 | 10921 | 190 |
1857889 | 1857889 | 2021-10-27 | Crawford | Pennsylvania | 42039 | 10880 | 188 |
1854640 | 1854640 | 2021-10-26 | Crawford | Pennsylvania | 42039 | 10830 | 188 |
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);