ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lebanon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176500 | 2176500 | 2022-02-02 | Lebanon | Pennsylvania | 42075 | 35517 | 472 |
2173246 | 2173246 | 2022-02-01 | Lebanon | Pennsylvania | 42075 | 35457 | 469 |
2169994 | 2169994 | 2022-01-31 | Lebanon | Pennsylvania | 42075 | 35374 | 464 |
2166740 | 2166740 | 2022-01-30 | Lebanon | Pennsylvania | 42075 | 35317 | 461 |
2163485 | 2163485 | 2022-01-29 | Lebanon | Pennsylvania | 42075 | 35206 | 461 |
2160230 | 2160230 | 2022-01-28 | Lebanon | Pennsylvania | 42075 | 35108 | 459 |
2156974 | 2156974 | 2022-01-27 | Lebanon | Pennsylvania | 42075 | 34905 | 456 |
2153721 | 2153721 | 2022-01-26 | Lebanon | Pennsylvania | 42075 | 34691 | 450 |
2150469 | 2150469 | 2022-01-25 | Lebanon | Pennsylvania | 42075 | 34546 | 445 |
2147217 | 2147217 | 2022-01-24 | Lebanon | Pennsylvania | 42075 | 34417 | 445 |
2143963 | 2143963 | 2022-01-23 | Lebanon | Pennsylvania | 42075 | 34285 | 444 |
2140708 | 2140708 | 2022-01-22 | Lebanon | Pennsylvania | 42075 | 34144 | 440 |
2137452 | 2137452 | 2022-01-21 | Lebanon | Pennsylvania | 42075 | 33893 | 438 |
2134198 | 2134198 | 2022-01-20 | Lebanon | Pennsylvania | 42075 | 33638 | 435 |
2130946 | 2130946 | 2022-01-19 | Lebanon | Pennsylvania | 42075 | 33446 | 429 |
2127692 | 2127692 | 2022-01-18 | Lebanon | Pennsylvania | 42075 | 33277 | 429 |
2124440 | 2124440 | 2022-01-17 | Lebanon | Pennsylvania | 42075 | 33009 | 427 |
2121188 | 2121188 | 2022-01-16 | Lebanon | Pennsylvania | 42075 | 32768 | 427 |
2117936 | 2117936 | 2022-01-15 | Lebanon | Pennsylvania | 42075 | 32197 | 426 |
2114685 | 2114685 | 2022-01-14 | Lebanon | Pennsylvania | 42075 | 31837 | 424 |
2111433 | 2111433 | 2022-01-13 | Lebanon | Pennsylvania | 42075 | 31577 | 423 |
2108181 | 2108181 | 2022-01-12 | Lebanon | Pennsylvania | 42075 | 31298 | 423 |
2104930 | 2104930 | 2022-01-11 | Lebanon | Pennsylvania | 42075 | 31009 | 421 |
2101679 | 2101679 | 2022-01-10 | Lebanon | Pennsylvania | 42075 | 30756 | 420 |
2098428 | 2098428 | 2022-01-09 | Lebanon | Pennsylvania | 42075 | 30146 | 414 |
2095176 | 2095176 | 2022-01-08 | Lebanon | Pennsylvania | 42075 | 29768 | 413 |
2091924 | 2091924 | 2022-01-07 | Lebanon | Pennsylvania | 42075 | 29301 | 413 |
2088672 | 2088672 | 2022-01-06 | Lebanon | Pennsylvania | 42075 | 29023 | 409 |
2085421 | 2085421 | 2022-01-05 | Lebanon | Pennsylvania | 42075 | 28765 | 406 |
2082169 | 2082169 | 2022-01-04 | Lebanon | Pennsylvania | 42075 | 28444 | 405 |
2078917 | 2078917 | 2022-01-03 | Lebanon | Pennsylvania | 42075 | 28165 | 400 |
2075666 | 2075666 | 2022-01-02 | Lebanon | Pennsylvania | 42075 | 27856 | 400 |
2072415 | 2072415 | 2022-01-01 | Lebanon | Pennsylvania | 42075 | 27560 | 400 |
2069164 | 2069164 | 2021-12-31 | Lebanon | Pennsylvania | 42075 | 27333 | 400 |
2065913 | 2065913 | 2021-12-30 | Lebanon | Pennsylvania | 42075 | 27038 | 400 |
2062663 | 2062663 | 2021-12-29 | Lebanon | Pennsylvania | 42075 | 26777 | 397 |
2059413 | 2059413 | 2021-12-28 | Lebanon | Pennsylvania | 42075 | 26652 | 393 |
2056164 | 2056164 | 2021-12-27 | Lebanon | Pennsylvania | 42075 | 26520 | 391 |
2052915 | 2052915 | 2021-12-26 | Lebanon | Pennsylvania | 42075 | 26361 | 389 |
2049665 | 2049665 | 2021-12-25 | Lebanon | Pennsylvania | 42075 | 26267 | 389 |
2046415 | 2046415 | 2021-12-24 | Lebanon | Pennsylvania | 42075 | 26058 | 389 |
2043165 | 2043165 | 2021-12-23 | Lebanon | Pennsylvania | 42075 | 25858 | 387 |
2039916 | 2039916 | 2021-12-22 | Lebanon | Pennsylvania | 42075 | 25688 | 382 |
2036666 | 2036666 | 2021-12-21 | Lebanon | Pennsylvania | 42075 | 25423 | 381 |
2033416 | 2033416 | 2021-12-20 | Lebanon | Pennsylvania | 42075 | 25275 | 377 |
2030166 | 2030166 | 2021-12-19 | Lebanon | Pennsylvania | 42075 | 25195 | 377 |
2026915 | 2026915 | 2021-12-18 | Lebanon | Pennsylvania | 42075 | 25080 | 377 |
2023664 | 2023664 | 2021-12-17 | Lebanon | Pennsylvania | 42075 | 24940 | 373 |
2020413 | 2020413 | 2021-12-16 | Lebanon | Pennsylvania | 42075 | 24812 | 372 |
2017162 | 2017162 | 2021-12-15 | Lebanon | Pennsylvania | 42075 | 24696 | 371 |
2013912 | 2013912 | 2021-12-14 | Lebanon | Pennsylvania | 42075 | 24615 | 369 |
2010661 | 2010661 | 2021-12-13 | Lebanon | Pennsylvania | 42075 | 24498 | 367 |
2007410 | 2007410 | 2021-12-12 | Lebanon | Pennsylvania | 42075 | 24394 | 367 |
2004159 | 2004159 | 2021-12-11 | Lebanon | Pennsylvania | 42075 | 24233 | 366 |
2000908 | 2000908 | 2021-12-10 | Lebanon | Pennsylvania | 42075 | 24052 | 366 |
1997658 | 1997658 | 2021-12-09 | Lebanon | Pennsylvania | 42075 | 23930 | 366 |
1994407 | 1994407 | 2021-12-08 | Lebanon | Pennsylvania | 42075 | 23809 | 366 |
1991156 | 1991156 | 2021-12-07 | Lebanon | Pennsylvania | 42075 | 23719 | 366 |
1987905 | 1987905 | 2021-12-06 | Lebanon | Pennsylvania | 42075 | 23568 | 364 |
1984655 | 1984655 | 2021-12-05 | Lebanon | Pennsylvania | 42075 | 23489 | 362 |
1981405 | 1981405 | 2021-12-04 | Lebanon | Pennsylvania | 42075 | 23401 | 361 |
1978155 | 1978155 | 2021-12-03 | Lebanon | Pennsylvania | 42075 | 23238 | 360 |
1974905 | 1974905 | 2021-12-02 | Lebanon | Pennsylvania | 42075 | 23114 | 360 |
1971656 | 1971656 | 2021-12-01 | Lebanon | Pennsylvania | 42075 | 23017 | 360 |
1968406 | 1968406 | 2021-11-30 | Lebanon | Pennsylvania | 42075 | 22951 | 357 |
1965155 | 1965155 | 2021-11-29 | Lebanon | Pennsylvania | 42075 | 22862 | 355 |
1961903 | 1961903 | 2021-11-28 | Lebanon | Pennsylvania | 42075 | 22790 | 355 |
1958652 | 1958652 | 2021-11-27 | Lebanon | Pennsylvania | 42075 | 22750 | 355 |
1955401 | 1955401 | 2021-11-26 | Lebanon | Pennsylvania | 42075 | 22670 | 355 |
1952150 | 1952150 | 2021-11-25 | Lebanon | Pennsylvania | 42075 | 22577 | 355 |
1948899 | 1948899 | 2021-11-24 | Lebanon | Pennsylvania | 42075 | 22489 | 353 |
1945648 | 1945648 | 2021-11-23 | Lebanon | Pennsylvania | 42075 | 22427 | 352 |
1942397 | 1942397 | 2021-11-22 | Lebanon | Pennsylvania | 42075 | 22352 | 352 |
1939147 | 1939147 | 2021-11-21 | Lebanon | Pennsylvania | 42075 | 22259 | 352 |
1935897 | 1935897 | 2021-11-20 | Lebanon | Pennsylvania | 42075 | 22180 | 352 |
1932647 | 1932647 | 2021-11-19 | Lebanon | Pennsylvania | 42075 | 22138 | 351 |
1929396 | 1929396 | 2021-11-18 | Lebanon | Pennsylvania | 42075 | 22046 | 348 |
1926146 | 1926146 | 2021-11-17 | Lebanon | Pennsylvania | 42075 | 21960 | 348 |
1922896 | 1922896 | 2021-11-16 | Lebanon | Pennsylvania | 42075 | 21896 | 347 |
1919647 | 1919647 | 2021-11-15 | Lebanon | Pennsylvania | 42075 | 21818 | 346 |
1916397 | 1916397 | 2021-11-14 | Lebanon | Pennsylvania | 42075 | 21769 | 346 |
1913147 | 1913147 | 2021-11-13 | Lebanon | Pennsylvania | 42075 | 21709 | 344 |
1909897 | 1909897 | 2021-11-12 | Lebanon | Pennsylvania | 42075 | 21373 | 344 |
1906648 | 1906648 | 2021-11-11 | Lebanon | Pennsylvania | 42075 | 21310 | 344 |
1903399 | 1903399 | 2021-11-10 | Lebanon | Pennsylvania | 42075 | 21236 | 344 |
1900149 | 1900149 | 2021-11-09 | Lebanon | Pennsylvania | 42075 | 21169 | 341 |
1896899 | 1896899 | 2021-11-08 | Lebanon | Pennsylvania | 42075 | 21122 | 341 |
1893649 | 1893649 | 2021-11-07 | Lebanon | Pennsylvania | 42075 | 21090 | 340 |
1890399 | 1890399 | 2021-11-06 | Lebanon | Pennsylvania | 42075 | 21022 | 340 |
1887149 | 1887149 | 2021-11-05 | Lebanon | Pennsylvania | 42075 | 20963 | 340 |
1883899 | 1883899 | 2021-11-04 | Lebanon | Pennsylvania | 42075 | 20899 | 339 |
1880650 | 1880650 | 2021-11-03 | Lebanon | Pennsylvania | 42075 | 20828 | 339 |
1877401 | 1877401 | 2021-11-02 | Lebanon | Pennsylvania | 42075 | 20779 | 339 |
1874152 | 1874152 | 2021-11-01 | Lebanon | Pennsylvania | 42075 | 20707 | 339 |
1870903 | 1870903 | 2021-10-31 | Lebanon | Pennsylvania | 42075 | 20707 | 339 |
1867654 | 1867654 | 2021-10-30 | Lebanon | Pennsylvania | 42075 | 20656 | 339 |
1864405 | 1864405 | 2021-10-29 | Lebanon | Pennsylvania | 42075 | 20609 | 339 |
1861156 | 1861156 | 2021-10-28 | Lebanon | Pennsylvania | 42075 | 20553 | 335 |
1857907 | 1857907 | 2021-10-27 | Lebanon | Pennsylvania | 42075 | 20509 | 330 |
1854658 | 1854658 | 2021-10-26 | Lebanon | Pennsylvania | 42075 | 20469 | 327 |
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);