ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lawrence" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176499 | 2176499 | 2022-02-02 | Lawrence | Pennsylvania | 42073 | 18274 | 380 |
2173245 | 2173245 | 2022-02-01 | Lawrence | Pennsylvania | 42073 | 18232 | 379 |
2169993 | 2169993 | 2022-01-31 | Lawrence | Pennsylvania | 42073 | 18201 | 377 |
2166739 | 2166739 | 2022-01-30 | Lawrence | Pennsylvania | 42073 | 18159 | 377 |
2163484 | 2163484 | 2022-01-29 | Lawrence | Pennsylvania | 42073 | 18119 | 377 |
2160229 | 2160229 | 2022-01-28 | Lawrence | Pennsylvania | 42073 | 18011 | 377 |
2156973 | 2156973 | 2022-01-27 | Lawrence | Pennsylvania | 42073 | 17905 | 374 |
2153720 | 2153720 | 2022-01-26 | Lawrence | Pennsylvania | 42073 | 17783 | 371 |
2150468 | 2150468 | 2022-01-25 | Lawrence | Pennsylvania | 42073 | 17685 | 370 |
2147216 | 2147216 | 2022-01-24 | Lawrence | Pennsylvania | 42073 | 17632 | 369 |
2143962 | 2143962 | 2022-01-23 | Lawrence | Pennsylvania | 42073 | 17538 | 368 |
2140707 | 2140707 | 2022-01-22 | Lawrence | Pennsylvania | 42073 | 17468 | 368 |
2137451 | 2137451 | 2022-01-21 | Lawrence | Pennsylvania | 42073 | 17338 | 365 |
2134197 | 2134197 | 2022-01-20 | Lawrence | Pennsylvania | 42073 | 17205 | 360 |
2130945 | 2130945 | 2022-01-19 | Lawrence | Pennsylvania | 42073 | 17130 | 358 |
2127691 | 2127691 | 2022-01-18 | Lawrence | Pennsylvania | 42073 | 17028 | 357 |
2124439 | 2124439 | 2022-01-17 | Lawrence | Pennsylvania | 42073 | 16940 | 357 |
2121187 | 2121187 | 2022-01-16 | Lawrence | Pennsylvania | 42073 | 16869 | 357 |
2117935 | 2117935 | 2022-01-15 | Lawrence | Pennsylvania | 42073 | 16607 | 357 |
2114684 | 2114684 | 2022-01-14 | Lawrence | Pennsylvania | 42073 | 16398 | 355 |
2111432 | 2111432 | 2022-01-13 | Lawrence | Pennsylvania | 42073 | 16260 | 355 |
2108180 | 2108180 | 2022-01-12 | Lawrence | Pennsylvania | 42073 | 16100 | 352 |
2104929 | 2104929 | 2022-01-11 | Lawrence | Pennsylvania | 42073 | 15937 | 349 |
2101678 | 2101678 | 2022-01-10 | Lawrence | Pennsylvania | 42073 | 15858 | 347 |
2098427 | 2098427 | 2022-01-09 | Lawrence | Pennsylvania | 42073 | 15768 | 347 |
2095175 | 2095175 | 2022-01-08 | Lawrence | Pennsylvania | 42073 | 15637 | 346 |
2091923 | 2091923 | 2022-01-07 | Lawrence | Pennsylvania | 42073 | 15412 | 344 |
2088671 | 2088671 | 2022-01-06 | Lawrence | Pennsylvania | 42073 | 15256 | 344 |
2085420 | 2085420 | 2022-01-05 | Lawrence | Pennsylvania | 42073 | 15116 | 342 |
2082168 | 2082168 | 2022-01-04 | Lawrence | Pennsylvania | 42073 | 14965 | 337 |
2078916 | 2078916 | 2022-01-03 | Lawrence | Pennsylvania | 42073 | 14873 | 335 |
2075665 | 2075665 | 2022-01-02 | Lawrence | Pennsylvania | 42073 | 14807 | 334 |
2072414 | 2072414 | 2022-01-01 | Lawrence | Pennsylvania | 42073 | 14697 | 334 |
2069163 | 2069163 | 2021-12-31 | Lawrence | Pennsylvania | 42073 | 14539 | 334 |
2065912 | 2065912 | 2021-12-30 | Lawrence | Pennsylvania | 42073 | 14431 | 334 |
2062662 | 2062662 | 2021-12-29 | Lawrence | Pennsylvania | 42073 | 14299 | 333 |
2059412 | 2059412 | 2021-12-28 | Lawrence | Pennsylvania | 42073 | 14230 | 328 |
2056163 | 2056163 | 2021-12-27 | Lawrence | Pennsylvania | 42073 | 14180 | 326 |
2052914 | 2052914 | 2021-12-26 | Lawrence | Pennsylvania | 42073 | 14154 | 326 |
2049664 | 2049664 | 2021-12-25 | Lawrence | Pennsylvania | 42073 | 14136 | 326 |
2046414 | 2046414 | 2021-12-24 | Lawrence | Pennsylvania | 42073 | 14082 | 326 |
2043164 | 2043164 | 2021-12-23 | Lawrence | Pennsylvania | 42073 | 14009 | 326 |
2039915 | 2039915 | 2021-12-22 | Lawrence | Pennsylvania | 42073 | 13957 | 326 |
2036665 | 2036665 | 2021-12-21 | Lawrence | Pennsylvania | 42073 | 13918 | 325 |
2033415 | 2033415 | 2021-12-20 | Lawrence | Pennsylvania | 42073 | 13844 | 323 |
2030165 | 2030165 | 2021-12-19 | Lawrence | Pennsylvania | 42073 | 13815 | 323 |
2026914 | 2026914 | 2021-12-18 | Lawrence | Pennsylvania | 42073 | 13779 | 323 |
2023663 | 2023663 | 2021-12-17 | Lawrence | Pennsylvania | 42073 | 13736 | 321 |
2020412 | 2020412 | 2021-12-16 | Lawrence | Pennsylvania | 42073 | 13652 | 320 |
2017161 | 2017161 | 2021-12-15 | Lawrence | Pennsylvania | 42073 | 13622 | 319 |
2013911 | 2013911 | 2021-12-14 | Lawrence | Pennsylvania | 42073 | 13563 | 318 |
2010660 | 2010660 | 2021-12-13 | Lawrence | Pennsylvania | 42073 | 13510 | 318 |
2007409 | 2007409 | 2021-12-12 | Lawrence | Pennsylvania | 42073 | 13486 | 318 |
2004158 | 2004158 | 2021-12-11 | Lawrence | Pennsylvania | 42073 | 13437 | 317 |
2000907 | 2000907 | 2021-12-10 | Lawrence | Pennsylvania | 42073 | 13337 | 313 |
1997657 | 1997657 | 2021-12-09 | Lawrence | Pennsylvania | 42073 | 13276 | 311 |
1994406 | 1994406 | 2021-12-08 | Lawrence | Pennsylvania | 42073 | 13205 | 311 |
1991155 | 1991155 | 2021-12-07 | Lawrence | Pennsylvania | 42073 | 13126 | 309 |
1987904 | 1987904 | 2021-12-06 | Lawrence | Pennsylvania | 42073 | 13041 | 305 |
1984654 | 1984654 | 2021-12-05 | Lawrence | Pennsylvania | 42073 | 13014 | 305 |
1981404 | 1981404 | 2021-12-04 | Lawrence | Pennsylvania | 42073 | 12969 | 304 |
1978154 | 1978154 | 2021-12-03 | Lawrence | Pennsylvania | 42073 | 12910 | 300 |
1974904 | 1974904 | 2021-12-02 | Lawrence | Pennsylvania | 42073 | 12783 | 299 |
1971655 | 1971655 | 2021-12-01 | Lawrence | Pennsylvania | 42073 | 12718 | 297 |
1968405 | 1968405 | 2021-11-30 | Lawrence | Pennsylvania | 42073 | 12658 | 294 |
1965154 | 1965154 | 2021-11-29 | Lawrence | Pennsylvania | 42073 | 12609 | 292 |
1961902 | 1961902 | 2021-11-28 | Lawrence | Pennsylvania | 42073 | 12530 | 292 |
1958651 | 1958651 | 2021-11-27 | Lawrence | Pennsylvania | 42073 | 12495 | 292 |
1955400 | 1955400 | 2021-11-26 | Lawrence | Pennsylvania | 42073 | 12436 | 292 |
1952149 | 1952149 | 2021-11-25 | Lawrence | Pennsylvania | 42073 | 12381 | 292 |
1948898 | 1948898 | 2021-11-24 | Lawrence | Pennsylvania | 42073 | 12344 | 285 |
1945647 | 1945647 | 2021-11-23 | Lawrence | Pennsylvania | 42073 | 12242 | 284 |
1942396 | 1942396 | 2021-11-22 | Lawrence | Pennsylvania | 42073 | 12190 | 284 |
1939146 | 1939146 | 2021-11-21 | Lawrence | Pennsylvania | 42073 | 12126 | 284 |
1935896 | 1935896 | 2021-11-20 | Lawrence | Pennsylvania | 42073 | 12085 | 284 |
1932646 | 1932646 | 2021-11-19 | Lawrence | Pennsylvania | 42073 | 11999 | 282 |
1929395 | 1929395 | 2021-11-18 | Lawrence | Pennsylvania | 42073 | 11910 | 280 |
1926145 | 1926145 | 2021-11-17 | Lawrence | Pennsylvania | 42073 | 11847 | 277 |
1922895 | 1922895 | 2021-11-16 | Lawrence | Pennsylvania | 42073 | 11800 | 277 |
1919646 | 1919646 | 2021-11-15 | Lawrence | Pennsylvania | 42073 | 11713 | 277 |
1916396 | 1916396 | 2021-11-14 | Lawrence | Pennsylvania | 42073 | 11676 | 277 |
1913146 | 1913146 | 2021-11-13 | Lawrence | Pennsylvania | 42073 | 11634 | 277 |
1909896 | 1909896 | 2021-11-12 | Lawrence | Pennsylvania | 42073 | 11452 | 275 |
1906647 | 1906647 | 2021-11-11 | Lawrence | Pennsylvania | 42073 | 11380 | 274 |
1903398 | 1903398 | 2021-11-10 | Lawrence | Pennsylvania | 42073 | 11333 | 274 |
1900148 | 1900148 | 2021-11-09 | Lawrence | Pennsylvania | 42073 | 11286 | 271 |
1896898 | 1896898 | 2021-11-08 | Lawrence | Pennsylvania | 42073 | 11250 | 271 |
1893648 | 1893648 | 2021-11-07 | Lawrence | Pennsylvania | 42073 | 11206 | 271 |
1890398 | 1890398 | 2021-11-06 | Lawrence | Pennsylvania | 42073 | 11150 | 271 |
1887148 | 1887148 | 2021-11-05 | Lawrence | Pennsylvania | 42073 | 11088 | 270 |
1883898 | 1883898 | 2021-11-04 | Lawrence | Pennsylvania | 42073 | 11029 | 268 |
1880649 | 1880649 | 2021-11-03 | Lawrence | Pennsylvania | 42073 | 10988 | 266 |
1877400 | 1877400 | 2021-11-02 | Lawrence | Pennsylvania | 42073 | 10941 | 264 |
1874151 | 1874151 | 2021-11-01 | Lawrence | Pennsylvania | 42073 | 10881 | 262 |
1870902 | 1870902 | 2021-10-31 | Lawrence | Pennsylvania | 42073 | 10881 | 262 |
1867653 | 1867653 | 2021-10-30 | Lawrence | Pennsylvania | 42073 | 10844 | 262 |
1864404 | 1864404 | 2021-10-29 | Lawrence | Pennsylvania | 42073 | 10812 | 262 |
1861155 | 1861155 | 2021-10-28 | Lawrence | Pennsylvania | 42073 | 10772 | 261 |
1857906 | 1857906 | 2021-10-27 | Lawrence | Pennsylvania | 42073 | 10742 | 261 |
1854657 | 1854657 | 2021-10-26 | Lawrence | Pennsylvania | 42073 | 10703 | 261 |
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);