ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Columbia" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111414 | 2111414 | 2022-01-13 | Columbia | Pennsylvania | 42037 | 12237 | 201 |
2108162 | 2108162 | 2022-01-12 | Columbia | Pennsylvania | 42037 | 12112 | 200 |
2104911 | 2104911 | 2022-01-11 | Columbia | Pennsylvania | 42037 | 11998 | 198 |
2101660 | 2101660 | 2022-01-10 | Columbia | Pennsylvania | 42037 | 11935 | 198 |
2098409 | 2098409 | 2022-01-09 | Columbia | Pennsylvania | 42037 | 11834 | 196 |
2095157 | 2095157 | 2022-01-08 | Columbia | Pennsylvania | 42037 | 11695 | 196 |
2091905 | 2091905 | 2022-01-07 | Columbia | Pennsylvania | 42037 | 11586 | 196 |
2088653 | 2088653 | 2022-01-06 | Columbia | Pennsylvania | 42037 | 11451 | 193 |
2085402 | 2085402 | 2022-01-05 | Columbia | Pennsylvania | 42037 | 11388 | 192 |
2082150 | 2082150 | 2022-01-04 | Columbia | Pennsylvania | 42037 | 11265 | 191 |
2078898 | 2078898 | 2022-01-03 | Columbia | Pennsylvania | 42037 | 11178 | 191 |
2075647 | 2075647 | 2022-01-02 | Columbia | Pennsylvania | 42037 | 11115 | 191 |
2072396 | 2072396 | 2022-01-01 | Columbia | Pennsylvania | 42037 | 11061 | 191 |
2069145 | 2069145 | 2021-12-31 | Columbia | Pennsylvania | 42037 | 10988 | 191 |
2065894 | 2065894 | 2021-12-30 | Columbia | Pennsylvania | 42037 | 10895 | 191 |
2062644 | 2062644 | 2021-12-29 | Columbia | Pennsylvania | 42037 | 10834 | 189 |
2059394 | 2059394 | 2021-12-28 | Columbia | Pennsylvania | 42037 | 10746 | 185 |
2056145 | 2056145 | 2021-12-27 | Columbia | Pennsylvania | 42037 | 10707 | 184 |
2052896 | 2052896 | 2021-12-26 | Columbia | Pennsylvania | 42037 | 10688 | 183 |
2049646 | 2049646 | 2021-12-25 | Columbia | Pennsylvania | 42037 | 10662 | 183 |
2046396 | 2046396 | 2021-12-24 | Columbia | Pennsylvania | 42037 | 10612 | 183 |
2043146 | 2043146 | 2021-12-23 | Columbia | Pennsylvania | 42037 | 10547 | 182 |
2039897 | 2039897 | 2021-12-22 | Columbia | Pennsylvania | 42037 | 10499 | 181 |
2036647 | 2036647 | 2021-12-21 | Columbia | Pennsylvania | 42037 | 10458 | 181 |
2033397 | 2033397 | 2021-12-20 | Columbia | Pennsylvania | 42037 | 10417 | 181 |
2030147 | 2030147 | 2021-12-19 | Columbia | Pennsylvania | 42037 | 10396 | 181 |
2026896 | 2026896 | 2021-12-18 | Columbia | Pennsylvania | 42037 | 10347 | 181 |
2023645 | 2023645 | 2021-12-17 | Columbia | Pennsylvania | 42037 | 10294 | 176 |
2020394 | 2020394 | 2021-12-16 | Columbia | Pennsylvania | 42037 | 10240 | 176 |
2017143 | 2017143 | 2021-12-15 | Columbia | Pennsylvania | 42037 | 10174 | 175 |
2013893 | 2013893 | 2021-12-14 | Columbia | Pennsylvania | 42037 | 10074 | 172 |
2010642 | 2010642 | 2021-12-13 | Columbia | Pennsylvania | 42037 | 10041 | 172 |
2007391 | 2007391 | 2021-12-12 | Columbia | Pennsylvania | 42037 | 10001 | 172 |
2004140 | 2004140 | 2021-12-11 | Columbia | Pennsylvania | 42037 | 9934 | 171 |
2000889 | 2000889 | 2021-12-10 | Columbia | Pennsylvania | 42037 | 9857 | 171 |
1997639 | 1997639 | 2021-12-09 | Columbia | Pennsylvania | 42037 | 9778 | 169 |
1994388 | 1994388 | 2021-12-08 | Columbia | Pennsylvania | 42037 | 9721 | 169 |
1991137 | 1991137 | 2021-12-07 | Columbia | Pennsylvania | 42037 | 9662 | 169 |
1987886 | 1987886 | 2021-12-06 | Columbia | Pennsylvania | 42037 | 9605 | 169 |
1984636 | 1984636 | 2021-12-05 | Columbia | Pennsylvania | 42037 | 9576 | 169 |
1981386 | 1981386 | 2021-12-04 | Columbia | Pennsylvania | 42037 | 9519 | 169 |
1978136 | 1978136 | 2021-12-03 | Columbia | Pennsylvania | 42037 | 9438 | 169 |
1974886 | 1974886 | 2021-12-02 | Columbia | Pennsylvania | 42037 | 9349 | 168 |
1971637 | 1971637 | 2021-12-01 | Columbia | Pennsylvania | 42037 | 9256 | 167 |
1968387 | 1968387 | 2021-11-30 | Columbia | Pennsylvania | 42037 | 9185 | 166 |
1965136 | 1965136 | 2021-11-29 | Columbia | Pennsylvania | 42037 | 9142 | 166 |
1961884 | 1961884 | 2021-11-28 | Columbia | Pennsylvania | 42037 | 9116 | 166 |
1958633 | 1958633 | 2021-11-27 | Columbia | Pennsylvania | 42037 | 9070 | 166 |
1955382 | 1955382 | 2021-11-26 | Columbia | Pennsylvania | 42037 | 9037 | 166 |
1952131 | 1952131 | 2021-11-25 | Columbia | Pennsylvania | 42037 | 8990 | 166 |
1948880 | 1948880 | 2021-11-24 | Columbia | Pennsylvania | 42037 | 8958 | 165 |
1945629 | 1945629 | 2021-11-23 | Columbia | Pennsylvania | 42037 | 8902 | 164 |
1942378 | 1942378 | 2021-11-22 | Columbia | Pennsylvania | 42037 | 8870 | 162 |
1939128 | 1939128 | 2021-11-21 | Columbia | Pennsylvania | 42037 | 8841 | 162 |
1935878 | 1935878 | 2021-11-20 | Columbia | Pennsylvania | 42037 | 8801 | 162 |
1932628 | 1932628 | 2021-11-19 | Columbia | Pennsylvania | 42037 | 8764 | 162 |
1929377 | 1929377 | 2021-11-18 | Columbia | Pennsylvania | 42037 | 8715 | 161 |
1926127 | 1926127 | 2021-11-17 | Columbia | Pennsylvania | 42037 | 8677 | 161 |
1922877 | 1922877 | 2021-11-16 | Columbia | Pennsylvania | 42037 | 8624 | 160 |
1919628 | 1919628 | 2021-11-15 | Columbia | Pennsylvania | 42037 | 8582 | 159 |
1916378 | 1916378 | 2021-11-14 | Columbia | Pennsylvania | 42037 | 8567 | 159 |
1913128 | 1913128 | 2021-11-13 | Columbia | Pennsylvania | 42037 | 8535 | 158 |
1909878 | 1909878 | 2021-11-12 | Columbia | Pennsylvania | 42037 | 8385 | 158 |
1906629 | 1906629 | 2021-11-11 | Columbia | Pennsylvania | 42037 | 8352 | 158 |
1903380 | 1903380 | 2021-11-10 | Columbia | Pennsylvania | 42037 | 8304 | 156 |
1900130 | 1900130 | 2021-11-09 | Columbia | Pennsylvania | 42037 | 8261 | 155 |
1896880 | 1896880 | 2021-11-08 | Columbia | Pennsylvania | 42037 | 8230 | 155 |
1893630 | 1893630 | 2021-11-07 | Columbia | Pennsylvania | 42037 | 8211 | 155 |
1890380 | 1890380 | 2021-11-06 | Columbia | Pennsylvania | 42037 | 8175 | 155 |
1887130 | 1887130 | 2021-11-05 | Columbia | Pennsylvania | 42037 | 8144 | 155 |
1883880 | 1883880 | 2021-11-04 | Columbia | Pennsylvania | 42037 | 8093 | 155 |
1880631 | 1880631 | 2021-11-03 | Columbia | Pennsylvania | 42037 | 8064 | 155 |
1877382 | 1877382 | 2021-11-02 | Columbia | Pennsylvania | 42037 | 8048 | 155 |
1874133 | 1874133 | 2021-11-01 | Columbia | Pennsylvania | 42037 | 8004 | 154 |
1870884 | 1870884 | 2021-10-31 | Columbia | Pennsylvania | 42037 | 8004 | 154 |
1867635 | 1867635 | 2021-10-30 | Columbia | Pennsylvania | 42037 | 7963 | 154 |
1864386 | 1864386 | 2021-10-29 | Columbia | Pennsylvania | 42037 | 7945 | 153 |
1861137 | 1861137 | 2021-10-28 | Columbia | Pennsylvania | 42037 | 7911 | 153 |
1857888 | 1857888 | 2021-10-27 | Columbia | Pennsylvania | 42037 | 7882 | 153 |
1854639 | 1854639 | 2021-10-26 | Columbia | Pennsylvania | 42037 | 7847 | 151 |
1851390 | 1851390 | 2021-10-25 | Columbia | Pennsylvania | 42037 | 7813 | 151 |
1848140 | 1848140 | 2021-10-24 | Columbia | Pennsylvania | 42037 | 7776 | 151 |
1844890 | 1844890 | 2021-10-23 | Columbia | Pennsylvania | 42037 | 7733 | 151 |
1841640 | 1841640 | 2021-10-22 | Columbia | Pennsylvania | 42037 | 7689 | 151 |
1838391 | 1838391 | 2021-10-21 | Columbia | Pennsylvania | 42037 | 7653 | 150 |
1835142 | 1835142 | 2021-10-20 | Columbia | Pennsylvania | 42037 | 7613 | 150 |
1831893 | 1831893 | 2021-10-19 | Columbia | Pennsylvania | 42037 | 7580 | 150 |
1828644 | 1828644 | 2021-10-18 | Columbia | Pennsylvania | 42037 | 7557 | 150 |
1825395 | 1825395 | 2021-10-17 | Columbia | Pennsylvania | 42037 | 7541 | 149 |
1822146 | 1822146 | 2021-10-16 | Columbia | Pennsylvania | 42037 | 7506 | 149 |
1818897 | 1818897 | 2021-10-15 | Columbia | Pennsylvania | 42037 | 7479 | 149 |
1815648 | 1815648 | 2021-10-14 | Columbia | Pennsylvania | 42037 | 7425 | 148 |
1812400 | 1812400 | 2021-10-13 | Columbia | Pennsylvania | 42037 | 7377 | 147 |
1809151 | 1809151 | 2021-10-12 | Columbia | Pennsylvania | 42037 | 7339 | 144 |
1805901 | 1805901 | 2021-10-11 | Columbia | Pennsylvania | 42037 | 7316 | 144 |
1802651 | 1802651 | 2021-10-10 | Columbia | Pennsylvania | 42037 | 7301 | 144 |
1799402 | 1799402 | 2021-10-09 | Columbia | Pennsylvania | 42037 | 7282 | 144 |
1796153 | 1796153 | 2021-10-08 | Columbia | Pennsylvania | 42037 | 7235 | 144 |
1792904 | 1792904 | 2021-10-07 | Columbia | Pennsylvania | 42037 | 7206 | 144 |
1789655 | 1789655 | 2021-10-06 | Columbia | Pennsylvania | 42037 | 7172 | 143 |
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);