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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
279863 | 279863 | 2020-06-27 | Lebanon | Pennsylvania | 42075 | 1309 | 43 |
283009 | 283009 | 2020-06-28 | Lebanon | Pennsylvania | 42075 | 1324 | 43 |
286154 | 286154 | 2020-06-29 | Lebanon | Pennsylvania | 42075 | 1331 | 43 |
289305 | 289305 | 2020-06-30 | Lebanon | Pennsylvania | 42075 | 1342 | 43 |
292457 | 292457 | 2020-07-01 | Lebanon | Pennsylvania | 42075 | 1350 | 43 |
295613 | 295613 | 2020-07-02 | Lebanon | Pennsylvania | 42075 | 1361 | 43 |
298772 | 298772 | 2020-07-03 | Lebanon | Pennsylvania | 42075 | 1375 | 43 |
301936 | 301936 | 2020-07-04 | Lebanon | Pennsylvania | 42075 | 1380 | 44 |
305099 | 305099 | 2020-07-05 | Lebanon | Pennsylvania | 42075 | 1383 | 44 |
308266 | 308266 | 2020-07-06 | Lebanon | Pennsylvania | 42075 | 1383 | 44 |
311435 | 311435 | 2020-07-07 | Lebanon | Pennsylvania | 42075 | 1389 | 45 |
314607 | 314607 | 2020-07-08 | Lebanon | Pennsylvania | 42075 | 1399 | 45 |
317780 | 317780 | 2020-07-09 | Lebanon | Pennsylvania | 42075 | 1404 | 47 |
320958 | 320958 | 2020-07-10 | Lebanon | Pennsylvania | 42075 | 1419 | 48 |
324138 | 324138 | 2020-07-11 | Lebanon | Pennsylvania | 42075 | 1429 | 50 |
327323 | 327323 | 2020-07-12 | Lebanon | Pennsylvania | 42075 | 1441 | 50 |
330509 | 330509 | 2020-07-13 | Lebanon | Pennsylvania | 42075 | 1448 | 50 |
333701 | 333701 | 2020-07-14 | Lebanon | Pennsylvania | 42075 | 1474 | 50 |
336895 | 336895 | 2020-07-15 | Lebanon | Pennsylvania | 42075 | 1476 | 51 |
340092 | 340092 | 2020-07-16 | Lebanon | Pennsylvania | 42075 | 1481 | 51 |
343290 | 343290 | 2020-07-17 | Lebanon | Pennsylvania | 42075 | 1484 | 51 |
346490 | 346490 | 2020-07-18 | Lebanon | Pennsylvania | 42075 | 1489 | 51 |
349690 | 349690 | 2020-07-19 | Lebanon | Pennsylvania | 42075 | 1498 | 51 |
352893 | 352893 | 2020-07-20 | Lebanon | Pennsylvania | 42075 | 1500 | 51 |
356096 | 356096 | 2020-07-21 | Lebanon | Pennsylvania | 42075 | 1509 | 52 |
359300 | 359300 | 2020-07-22 | Lebanon | Pennsylvania | 42075 | 1518 | 52 |
362506 | 362506 | 2020-07-23 | Lebanon | Pennsylvania | 42075 | 1529 | 54 |
365712 | 365712 | 2020-07-24 | Lebanon | Pennsylvania | 42075 | 1533 | 54 |
368921 | 368921 | 2020-07-25 | Lebanon | Pennsylvania | 42075 | 1541 | 54 |
372133 | 372133 | 2020-07-26 | Lebanon | Pennsylvania | 42075 | 1544 | 54 |
375346 | 375346 | 2020-07-27 | Lebanon | Pennsylvania | 42075 | 1548 | 54 |
378562 | 378562 | 2020-07-28 | Lebanon | Pennsylvania | 42075 | 1554 | 54 |
381779 | 381779 | 2020-07-29 | Lebanon | Pennsylvania | 42075 | 1559 | 54 |
384997 | 384997 | 2020-07-30 | Lebanon | Pennsylvania | 42075 | 1562 | 54 |
388214 | 388214 | 2020-07-31 | Lebanon | Pennsylvania | 42075 | 1563 | 54 |
391431 | 391431 | 2020-08-01 | Lebanon | Pennsylvania | 42075 | 1565 | 54 |
394647 | 394647 | 2020-08-02 | Lebanon | Pennsylvania | 42075 | 1571 | 54 |
397864 | 397864 | 2020-08-03 | Lebanon | Pennsylvania | 42075 | 1577 | 54 |
401079 | 401079 | 2020-08-04 | Lebanon | Pennsylvania | 42075 | 1581 | 54 |
404297 | 404297 | 2020-08-05 | Lebanon | Pennsylvania | 42075 | 1584 | 54 |
407516 | 407516 | 2020-08-06 | Lebanon | Pennsylvania | 42075 | 1591 | 54 |
410736 | 410736 | 2020-08-07 | Lebanon | Pennsylvania | 42075 | 1594 | 54 |
413956 | 413956 | 2020-08-08 | Lebanon | Pennsylvania | 42075 | 1595 | 54 |
417177 | 417177 | 2020-08-09 | Lebanon | Pennsylvania | 42075 | 1610 | 54 |
420397 | 420397 | 2020-08-10 | Lebanon | Pennsylvania | 42075 | 1617 | 54 |
423620 | 423620 | 2020-08-11 | Lebanon | Pennsylvania | 42075 | 1621 | 55 |
426843 | 426843 | 2020-08-12 | Lebanon | Pennsylvania | 42075 | 1626 | 55 |
430068 | 430068 | 2020-08-13 | Lebanon | Pennsylvania | 42075 | 1632 | 55 |
433294 | 433294 | 2020-08-14 | Lebanon | Pennsylvania | 42075 | 1640 | 55 |
436521 | 436521 | 2020-08-15 | Lebanon | Pennsylvania | 42075 | 1644 | 55 |
439746 | 439746 | 2020-08-16 | Lebanon | Pennsylvania | 42075 | 1650 | 55 |
442973 | 442973 | 2020-08-17 | Lebanon | Pennsylvania | 42075 | 1651 | 55 |
446199 | 446199 | 2020-08-18 | Lebanon | Pennsylvania | 42075 | 1653 | 55 |
449427 | 449427 | 2020-08-19 | Lebanon | Pennsylvania | 42075 | 1655 | 55 |
452655 | 452655 | 2020-08-20 | Lebanon | Pennsylvania | 42075 | 1663 | 55 |
455883 | 455883 | 2020-08-21 | Lebanon | Pennsylvania | 42075 | 1663 | 56 |
459111 | 459111 | 2020-08-22 | Lebanon | Pennsylvania | 42075 | 1665 | 56 |
462339 | 462339 | 2020-08-23 | Lebanon | Pennsylvania | 42075 | 1672 | 56 |
465568 | 465568 | 2020-08-24 | Lebanon | Pennsylvania | 42075 | 1677 | 56 |
468796 | 468796 | 2020-08-25 | Lebanon | Pennsylvania | 42075 | 1681 | 56 |
472028 | 472028 | 2020-08-26 | Lebanon | Pennsylvania | 42075 | 1685 | 57 |
475262 | 475262 | 2020-08-27 | Lebanon | Pennsylvania | 42075 | 1694 | 57 |
478495 | 478495 | 2020-08-28 | Lebanon | Pennsylvania | 42075 | 1705 | 57 |
481729 | 481729 | 2020-08-29 | Lebanon | Pennsylvania | 42075 | 1717 | 57 |
484964 | 484964 | 2020-08-30 | Lebanon | Pennsylvania | 42075 | 1721 | 57 |
488197 | 488197 | 2020-08-31 | Lebanon | Pennsylvania | 42075 | 1728 | 57 |
491430 | 491430 | 2020-09-01 | Lebanon | Pennsylvania | 42075 | 1736 | 57 |
494664 | 494664 | 2020-09-02 | Lebanon | Pennsylvania | 42075 | 1739 | 57 |
497897 | 497897 | 2020-09-03 | Lebanon | Pennsylvania | 42075 | 1742 | 57 |
501131 | 501131 | 2020-09-04 | Lebanon | Pennsylvania | 42075 | 1748 | 57 |
504365 | 504365 | 2020-09-05 | Lebanon | Pennsylvania | 42075 | 1763 | 57 |
507597 | 507597 | 2020-09-06 | Lebanon | Pennsylvania | 42075 | 1768 | 57 |
510830 | 510830 | 2020-09-07 | Lebanon | Pennsylvania | 42075 | 1777 | 57 |
514063 | 514063 | 2020-09-08 | Lebanon | Pennsylvania | 42075 | 1783 | 57 |
517298 | 517298 | 2020-09-09 | Lebanon | Pennsylvania | 42075 | 1788 | 57 |
520534 | 520534 | 2020-09-10 | Lebanon | Pennsylvania | 42075 | 1794 | 57 |
523770 | 523770 | 2020-09-11 | Lebanon | Pennsylvania | 42075 | 1807 | 57 |
527006 | 527006 | 2020-09-12 | Lebanon | Pennsylvania | 42075 | 1814 | 57 |
530243 | 530243 | 2020-09-13 | Lebanon | Pennsylvania | 42075 | 1814 | 57 |
533478 | 533478 | 2020-09-14 | Lebanon | Pennsylvania | 42075 | 1838 | 58 |
536714 | 536714 | 2020-09-15 | Lebanon | Pennsylvania | 42075 | 1857 | 58 |
539951 | 539951 | 2020-09-16 | Lebanon | Pennsylvania | 42075 | 1890 | 58 |
543187 | 543187 | 2020-09-17 | Lebanon | Pennsylvania | 42075 | 1900 | 58 |
546424 | 546424 | 2020-09-18 | Lebanon | Pennsylvania | 42075 | 1909 | 58 |
549663 | 549663 | 2020-09-19 | Lebanon | Pennsylvania | 42075 | 1931 | 59 |
552902 | 552902 | 2020-09-20 | Lebanon | Pennsylvania | 42075 | 1935 | 59 |
556139 | 556139 | 2020-09-21 | Lebanon | Pennsylvania | 42075 | 1945 | 59 |
559376 | 559376 | 2020-09-22 | Lebanon | Pennsylvania | 42075 | 1959 | 59 |
562613 | 562613 | 2020-09-23 | Lebanon | Pennsylvania | 42075 | 1971 | 59 |
565854 | 565854 | 2020-09-24 | Lebanon | Pennsylvania | 42075 | 1983 | 59 |
569095 | 569095 | 2020-09-25 | Lebanon | Pennsylvania | 42075 | 2001 | 59 |
572337 | 572337 | 2020-09-26 | Lebanon | Pennsylvania | 42075 | 2015 | 59 |
575581 | 575581 | 2020-09-27 | Lebanon | Pennsylvania | 42075 | 2037 | 59 |
578822 | 578822 | 2020-09-28 | Lebanon | Pennsylvania | 42075 | 2049 | 59 |
582062 | 582062 | 2020-09-29 | Lebanon | Pennsylvania | 42075 | 2057 | 59 |
585302 | 585302 | 2020-09-30 | Lebanon | Pennsylvania | 42075 | 2078 | 59 |
588542 | 588542 | 2020-10-01 | Lebanon | Pennsylvania | 42075 | 2091 | 60 |
591783 | 591783 | 2020-10-02 | Lebanon | Pennsylvania | 42075 | 2112 | 60 |
595024 | 595024 | 2020-10-03 | Lebanon | Pennsylvania | 42075 | 2112 | 60 |
598267 | 598267 | 2020-10-04 | Lebanon | Pennsylvania | 42075 | 2150 | 62 |
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);