ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Centre" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
state 1
- Pennsylvania · 685 ✖
fips 1
- 42027 685
county 1
- Centre · 685 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176476 | 2176476 | 2022-02-02 | Centre | Pennsylvania | 42027 | 33516 | 324 |
2173222 | 2173222 | 2022-02-01 | Centre | Pennsylvania | 42027 | 33409 | 321 |
2169970 | 2169970 | 2022-01-31 | Centre | Pennsylvania | 42027 | 33344 | 321 |
2166716 | 2166716 | 2022-01-30 | Centre | Pennsylvania | 42027 | 33273 | 321 |
2163461 | 2163461 | 2022-01-29 | Centre | Pennsylvania | 42027 | 33162 | 321 |
2160206 | 2160206 | 2022-01-28 | Centre | Pennsylvania | 42027 | 33028 | 320 |
2156950 | 2156950 | 2022-01-27 | Centre | Pennsylvania | 42027 | 32760 | 319 |
2153697 | 2153697 | 2022-01-26 | Centre | Pennsylvania | 42027 | 32541 | 318 |
2150445 | 2150445 | 2022-01-25 | Centre | Pennsylvania | 42027 | 32407 | 317 |
2147193 | 2147193 | 2022-01-24 | Centre | Pennsylvania | 42027 | 32270 | 316 |
2143939 | 2143939 | 2022-01-23 | Centre | Pennsylvania | 42027 | 32166 | 316 |
2140684 | 2140684 | 2022-01-22 | Centre | Pennsylvania | 42027 | 31917 | 315 |
2137428 | 2137428 | 2022-01-21 | Centre | Pennsylvania | 42027 | 31674 | 313 |
2134174 | 2134174 | 2022-01-20 | Centre | Pennsylvania | 42027 | 31283 | 309 |
2130922 | 2130922 | 2022-01-19 | Centre | Pennsylvania | 42027 | 31031 | 306 |
2127668 | 2127668 | 2022-01-18 | Centre | Pennsylvania | 42027 | 30764 | 305 |
2124416 | 2124416 | 2022-01-17 | Centre | Pennsylvania | 42027 | 30624 | 305 |
2121164 | 2121164 | 2022-01-16 | Centre | Pennsylvania | 42027 | 30520 | 305 |
2117912 | 2117912 | 2022-01-15 | Centre | Pennsylvania | 42027 | 30105 | 305 |
2114661 | 2114661 | 2022-01-14 | Centre | Pennsylvania | 42027 | 29909 | 304 |
2111409 | 2111409 | 2022-01-13 | Centre | Pennsylvania | 42027 | 29577 | 301 |
2108157 | 2108157 | 2022-01-12 | Centre | Pennsylvania | 42027 | 29269 | 301 |
2104906 | 2104906 | 2022-01-11 | Centre | Pennsylvania | 42027 | 28916 | 300 |
2101655 | 2101655 | 2022-01-10 | Centre | Pennsylvania | 42027 | 28734 | 298 |
2098404 | 2098404 | 2022-01-09 | Centre | Pennsylvania | 42027 | 28429 | 298 |
2095152 | 2095152 | 2022-01-08 | Centre | Pennsylvania | 42027 | 28106 | 298 |
2091900 | 2091900 | 2022-01-07 | Centre | Pennsylvania | 42027 | 27748 | 295 |
2088648 | 2088648 | 2022-01-06 | Centre | Pennsylvania | 42027 | 27440 | 294 |
2085397 | 2085397 | 2022-01-05 | Centre | Pennsylvania | 42027 | 27230 | 293 |
2082145 | 2082145 | 2022-01-04 | Centre | Pennsylvania | 42027 | 26937 | 292 |
2078893 | 2078893 | 2022-01-03 | Centre | Pennsylvania | 42027 | 26763 | 291 |
2075642 | 2075642 | 2022-01-02 | Centre | Pennsylvania | 42027 | 26658 | 289 |
2072391 | 2072391 | 2022-01-01 | Centre | Pennsylvania | 42027 | 26495 | 289 |
2069140 | 2069140 | 2021-12-31 | Centre | Pennsylvania | 42027 | 26176 | 289 |
2065889 | 2065889 | 2021-12-30 | Centre | Pennsylvania | 42027 | 25892 | 288 |
2062639 | 2062639 | 2021-12-29 | Centre | Pennsylvania | 42027 | 25658 | 287 |
2059389 | 2059389 | 2021-12-28 | Centre | Pennsylvania | 42027 | 25484 | 286 |
2056140 | 2056140 | 2021-12-27 | Centre | Pennsylvania | 42027 | 25384 | 283 |
2052891 | 2052891 | 2021-12-26 | Centre | Pennsylvania | 42027 | 25363 | 283 |
2049641 | 2049641 | 2021-12-25 | Centre | Pennsylvania | 42027 | 25307 | 283 |
2046391 | 2046391 | 2021-12-24 | Centre | Pennsylvania | 42027 | 25172 | 283 |
2043141 | 2043141 | 2021-12-23 | Centre | Pennsylvania | 42027 | 24917 | 281 |
2039892 | 2039892 | 2021-12-22 | Centre | Pennsylvania | 42027 | 24791 | 280 |
2036642 | 2036642 | 2021-12-21 | Centre | Pennsylvania | 42027 | 24692 | 278 |
2033392 | 2033392 | 2021-12-20 | Centre | Pennsylvania | 42027 | 24566 | 276 |
2030142 | 2030142 | 2021-12-19 | Centre | Pennsylvania | 42027 | 24540 | 275 |
2026891 | 2026891 | 2021-12-18 | Centre | Pennsylvania | 42027 | 24416 | 275 |
2023640 | 2023640 | 2021-12-17 | Centre | Pennsylvania | 42027 | 24301 | 273 |
2020389 | 2020389 | 2021-12-16 | Centre | Pennsylvania | 42027 | 24213 | 272 |
2017138 | 2017138 | 2021-12-15 | Centre | Pennsylvania | 42027 | 24115 | 271 |
2013888 | 2013888 | 2021-12-14 | Centre | Pennsylvania | 42027 | 24025 | 270 |
2010637 | 2010637 | 2021-12-13 | Centre | Pennsylvania | 42027 | 23973 | 268 |
2007386 | 2007386 | 2021-12-12 | Centre | Pennsylvania | 42027 | 23919 | 268 |
2004135 | 2004135 | 2021-12-11 | Centre | Pennsylvania | 42027 | 23809 | 267 |
2000884 | 2000884 | 2021-12-10 | Centre | Pennsylvania | 42027 | 23732 | 267 |
1997634 | 1997634 | 2021-12-09 | Centre | Pennsylvania | 42027 | 23634 | 267 |
1994383 | 1994383 | 2021-12-08 | Centre | Pennsylvania | 42027 | 23589 | 265 |
1991132 | 1991132 | 2021-12-07 | Centre | Pennsylvania | 42027 | 23464 | 265 |
1987881 | 1987881 | 2021-12-06 | Centre | Pennsylvania | 42027 | 23392 | 264 |
1984631 | 1984631 | 2021-12-05 | Centre | Pennsylvania | 42027 | 23357 | 264 |
1981381 | 1981381 | 2021-12-04 | Centre | Pennsylvania | 42027 | 23271 | 263 |
1978131 | 1978131 | 2021-12-03 | Centre | Pennsylvania | 42027 | 23138 | 261 |
1974881 | 1974881 | 2021-12-02 | Centre | Pennsylvania | 42027 | 22997 | 260 |
1971632 | 1971632 | 2021-12-01 | Centre | Pennsylvania | 42027 | 22912 | 258 |
1968382 | 1968382 | 2021-11-30 | Centre | Pennsylvania | 42027 | 22800 | 258 |
1965131 | 1965131 | 2021-11-29 | Centre | Pennsylvania | 42027 | 22736 | 258 |
1961879 | 1961879 | 2021-11-28 | Centre | Pennsylvania | 42027 | 22664 | 258 |
1958628 | 1958628 | 2021-11-27 | Centre | Pennsylvania | 42027 | 22582 | 258 |
1955377 | 1955377 | 2021-11-26 | Centre | Pennsylvania | 42027 | 22540 | 258 |
1952126 | 1952126 | 2021-11-25 | Centre | Pennsylvania | 42027 | 22449 | 258 |
1948875 | 1948875 | 2021-11-24 | Centre | Pennsylvania | 42027 | 22396 | 256 |
1945624 | 1945624 | 2021-11-23 | Centre | Pennsylvania | 42027 | 22296 | 255 |
1942373 | 1942373 | 2021-11-22 | Centre | Pennsylvania | 42027 | 22235 | 255 |
1939123 | 1939123 | 2021-11-21 | Centre | Pennsylvania | 42027 | 22188 | 254 |
1935873 | 1935873 | 2021-11-20 | Centre | Pennsylvania | 42027 | 22114 | 254 |
1932623 | 1932623 | 2021-11-19 | Centre | Pennsylvania | 42027 | 22017 | 253 |
1929372 | 1929372 | 2021-11-18 | Centre | Pennsylvania | 42027 | 21928 | 253 |
1926122 | 1926122 | 2021-11-17 | Centre | Pennsylvania | 42027 | 21874 | 251 |
1922872 | 1922872 | 2021-11-16 | Centre | Pennsylvania | 42027 | 21804 | 251 |
1919623 | 1919623 | 2021-11-15 | Centre | Pennsylvania | 42027 | 21780 | 250 |
1916373 | 1916373 | 2021-11-14 | Centre | Pennsylvania | 42027 | 21743 | 250 |
1913123 | 1913123 | 2021-11-13 | Centre | Pennsylvania | 42027 | 21679 | 250 |
1909873 | 1909873 | 2021-11-12 | Centre | Pennsylvania | 42027 | 21189 | 248 |
1906624 | 1906624 | 2021-11-11 | Centre | Pennsylvania | 42027 | 21119 | 248 |
1903375 | 1903375 | 2021-11-10 | Centre | Pennsylvania | 42027 | 21048 | 247 |
1900125 | 1900125 | 2021-11-09 | Centre | Pennsylvania | 42027 | 20997 | 247 |
1896875 | 1896875 | 2021-11-08 | Centre | Pennsylvania | 42027 | 20968 | 246 |
1893625 | 1893625 | 2021-11-07 | Centre | Pennsylvania | 42027 | 20944 | 246 |
1890375 | 1890375 | 2021-11-06 | Centre | Pennsylvania | 42027 | 20907 | 246 |
1887125 | 1887125 | 2021-11-05 | Centre | Pennsylvania | 42027 | 20874 | 246 |
1883875 | 1883875 | 2021-11-04 | Centre | Pennsylvania | 42027 | 20829 | 246 |
1880626 | 1880626 | 2021-11-03 | Centre | Pennsylvania | 42027 | 20796 | 246 |
1877377 | 1877377 | 2021-11-02 | Centre | Pennsylvania | 42027 | 20758 | 244 |
1874128 | 1874128 | 2021-11-01 | Centre | Pennsylvania | 42027 | 20698 | 244 |
1870879 | 1870879 | 2021-10-31 | Centre | Pennsylvania | 42027 | 20698 | 244 |
1867630 | 1867630 | 2021-10-30 | Centre | Pennsylvania | 42027 | 20659 | 244 |
1864381 | 1864381 | 2021-10-29 | Centre | Pennsylvania | 42027 | 20613 | 244 |
1861132 | 1861132 | 2021-10-28 | Centre | Pennsylvania | 42027 | 20567 | 244 |
1857883 | 1857883 | 2021-10-27 | Centre | Pennsylvania | 42027 | 20521 | 244 |
1854634 | 1854634 | 2021-10-26 | Centre | Pennsylvania | 42027 | 20474 | 244 |
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);