ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 42007 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637149 | 637149 | 2020-10-16 | Beaver | Pennsylvania | 42007 | 2117 | 136 |
633903 | 633903 | 2020-10-15 | Beaver | Pennsylvania | 42007 | 2102 | 136 |
630658 | 630658 | 2020-10-14 | Beaver | Pennsylvania | 42007 | 2084 | 136 |
627414 | 627414 | 2020-10-13 | Beaver | Pennsylvania | 42007 | 2071 | 135 |
624172 | 624172 | 2020-10-12 | Beaver | Pennsylvania | 42007 | 2049 | 133 |
620929 | 620929 | 2020-10-11 | Beaver | Pennsylvania | 42007 | 2039 | 133 |
617686 | 617686 | 2020-10-10 | Beaver | Pennsylvania | 42007 | 2028 | 133 |
614444 | 614444 | 2020-10-09 | Beaver | Pennsylvania | 42007 | 2022 | 133 |
611203 | 611203 | 2020-10-08 | Beaver | Pennsylvania | 42007 | 2007 | 132 |
607961 | 607961 | 2020-10-07 | Beaver | Pennsylvania | 42007 | 1995 | 132 |
604718 | 604718 | 2020-10-06 | Beaver | Pennsylvania | 42007 | 1993 | 130 |
601476 | 601476 | 2020-10-05 | Beaver | Pennsylvania | 42007 | 1973 | 129 |
598233 | 598233 | 2020-10-04 | Beaver | Pennsylvania | 42007 | 1971 | 128 |
594990 | 594990 | 2020-10-03 | Beaver | Pennsylvania | 42007 | 1953 | 127 |
591749 | 591749 | 2020-10-02 | Beaver | Pennsylvania | 42007 | 1953 | 125 |
588508 | 588508 | 2020-10-01 | Beaver | Pennsylvania | 42007 | 1940 | 123 |
585268 | 585268 | 2020-09-30 | Beaver | Pennsylvania | 42007 | 1924 | 122 |
582028 | 582028 | 2020-09-29 | Beaver | Pennsylvania | 42007 | 1905 | 122 |
578788 | 578788 | 2020-09-28 | Beaver | Pennsylvania | 42007 | 1901 | 122 |
575547 | 575547 | 2020-09-27 | Beaver | Pennsylvania | 42007 | 1886 | 122 |
572303 | 572303 | 2020-09-26 | Beaver | Pennsylvania | 42007 | 1878 | 122 |
569061 | 569061 | 2020-09-25 | Beaver | Pennsylvania | 42007 | 1872 | 122 |
565820 | 565820 | 2020-09-24 | Beaver | Pennsylvania | 42007 | 1856 | 122 |
562579 | 562579 | 2020-09-23 | Beaver | Pennsylvania | 42007 | 1845 | 120 |
559342 | 559342 | 2020-09-22 | Beaver | Pennsylvania | 42007 | 1839 | 118 |
556105 | 556105 | 2020-09-21 | Beaver | Pennsylvania | 42007 | 1838 | 118 |
552868 | 552868 | 2020-09-20 | Beaver | Pennsylvania | 42007 | 1836 | 116 |
549629 | 549629 | 2020-09-19 | Beaver | Pennsylvania | 42007 | 1834 | 116 |
546390 | 546390 | 2020-09-18 | Beaver | Pennsylvania | 42007 | 1820 | 112 |
543153 | 543153 | 2020-09-17 | Beaver | Pennsylvania | 42007 | 1814 | 111 |
539917 | 539917 | 2020-09-16 | Beaver | Pennsylvania | 42007 | 1804 | 110 |
536680 | 536680 | 2020-09-15 | Beaver | Pennsylvania | 42007 | 1796 | 110 |
533444 | 533444 | 2020-09-14 | Beaver | Pennsylvania | 42007 | 1783 | 109 |
530209 | 530209 | 2020-09-13 | Beaver | Pennsylvania | 42007 | 1767 | 106 |
526972 | 526972 | 2020-09-12 | Beaver | Pennsylvania | 42007 | 1767 | 106 |
523736 | 523736 | 2020-09-11 | Beaver | Pennsylvania | 42007 | 1757 | 106 |
520500 | 520500 | 2020-09-10 | Beaver | Pennsylvania | 42007 | 1731 | 106 |
517264 | 517264 | 2020-09-09 | Beaver | Pennsylvania | 42007 | 1722 | 105 |
514029 | 514029 | 2020-09-08 | Beaver | Pennsylvania | 42007 | 1714 | 102 |
510796 | 510796 | 2020-09-07 | Beaver | Pennsylvania | 42007 | 1710 | 102 |
507563 | 507563 | 2020-09-06 | Beaver | Pennsylvania | 42007 | 1706 | 102 |
504331 | 504331 | 2020-09-05 | Beaver | Pennsylvania | 42007 | 1702 | 102 |
501097 | 501097 | 2020-09-04 | Beaver | Pennsylvania | 42007 | 1694 | 99 |
497863 | 497863 | 2020-09-03 | Beaver | Pennsylvania | 42007 | 1653 | 99 |
494630 | 494630 | 2020-09-02 | Beaver | Pennsylvania | 42007 | 1630 | 98 |
491396 | 491396 | 2020-09-01 | Beaver | Pennsylvania | 42007 | 1618 | 96 |
488163 | 488163 | 2020-08-31 | Beaver | Pennsylvania | 42007 | 1611 | 96 |
484930 | 484930 | 2020-08-30 | Beaver | Pennsylvania | 42007 | 1603 | 96 |
481695 | 481695 | 2020-08-29 | Beaver | Pennsylvania | 42007 | 1597 | 96 |
478461 | 478461 | 2020-08-28 | Beaver | Pennsylvania | 42007 | 1573 | 96 |
475228 | 475228 | 2020-08-27 | Beaver | Pennsylvania | 42007 | 1532 | 96 |
471994 | 471994 | 2020-08-26 | Beaver | Pennsylvania | 42007 | 1526 | 96 |
468762 | 468762 | 2020-08-25 | Beaver | Pennsylvania | 42007 | 1515 | 96 |
465534 | 465534 | 2020-08-24 | Beaver | Pennsylvania | 42007 | 1504 | 95 |
462305 | 462305 | 2020-08-23 | Beaver | Pennsylvania | 42007 | 1501 | 95 |
459077 | 459077 | 2020-08-22 | Beaver | Pennsylvania | 42007 | 1496 | 95 |
455849 | 455849 | 2020-08-21 | Beaver | Pennsylvania | 42007 | 1485 | 95 |
452621 | 452621 | 2020-08-20 | Beaver | Pennsylvania | 42007 | 1447 | 95 |
449393 | 449393 | 2020-08-19 | Beaver | Pennsylvania | 42007 | 1437 | 95 |
446165 | 446165 | 2020-08-18 | Beaver | Pennsylvania | 42007 | 1423 | 95 |
442939 | 442939 | 2020-08-17 | Beaver | Pennsylvania | 42007 | 1410 | 94 |
439712 | 439712 | 2020-08-16 | Beaver | Pennsylvania | 42007 | 1407 | 94 |
436487 | 436487 | 2020-08-15 | Beaver | Pennsylvania | 42007 | 1401 | 94 |
433260 | 433260 | 2020-08-14 | Beaver | Pennsylvania | 42007 | 1382 | 93 |
430034 | 430034 | 2020-08-13 | Beaver | Pennsylvania | 42007 | 1374 | 93 |
426809 | 426809 | 2020-08-12 | Beaver | Pennsylvania | 42007 | 1351 | 93 |
423586 | 423586 | 2020-08-11 | Beaver | Pennsylvania | 42007 | 1332 | 92 |
420363 | 420363 | 2020-08-10 | Beaver | Pennsylvania | 42007 | 1326 | 92 |
417143 | 417143 | 2020-08-09 | Beaver | Pennsylvania | 42007 | 1316 | 92 |
413922 | 413922 | 2020-08-08 | Beaver | Pennsylvania | 42007 | 1312 | 92 |
410702 | 410702 | 2020-08-07 | Beaver | Pennsylvania | 42007 | 1294 | 91 |
407482 | 407482 | 2020-08-06 | Beaver | Pennsylvania | 42007 | 1280 | 91 |
404263 | 404263 | 2020-08-05 | Beaver | Pennsylvania | 42007 | 1269 | 89 |
401045 | 401045 | 2020-08-04 | Beaver | Pennsylvania | 42007 | 1261 | 89 |
397830 | 397830 | 2020-08-03 | Beaver | Pennsylvania | 42007 | 1237 | 89 |
394613 | 394613 | 2020-08-02 | Beaver | Pennsylvania | 42007 | 1232 | 89 |
391397 | 391397 | 2020-08-01 | Beaver | Pennsylvania | 42007 | 1219 | 89 |
388180 | 388180 | 2020-07-31 | Beaver | Pennsylvania | 42007 | 1212 | 88 |
384963 | 384963 | 2020-07-30 | Beaver | Pennsylvania | 42007 | 1189 | 88 |
381745 | 381745 | 2020-07-29 | Beaver | Pennsylvania | 42007 | 1176 | 85 |
378528 | 378528 | 2020-07-28 | Beaver | Pennsylvania | 42007 | 1164 | 85 |
375312 | 375312 | 2020-07-27 | Beaver | Pennsylvania | 42007 | 1127 | 82 |
372099 | 372099 | 2020-07-26 | Beaver | Pennsylvania | 42007 | 1116 | 82 |
368887 | 368887 | 2020-07-25 | Beaver | Pennsylvania | 42007 | 1101 | 82 |
365678 | 365678 | 2020-07-24 | Beaver | Pennsylvania | 42007 | 1084 | 82 |
362472 | 362472 | 2020-07-23 | Beaver | Pennsylvania | 42007 | 1053 | 82 |
359266 | 359266 | 2020-07-22 | Beaver | Pennsylvania | 42007 | 1046 | 82 |
356062 | 356062 | 2020-07-21 | Beaver | Pennsylvania | 42007 | 1011 | 81 |
352859 | 352859 | 2020-07-20 | Beaver | Pennsylvania | 42007 | 968 | 81 |
349656 | 349656 | 2020-07-19 | Beaver | Pennsylvania | 42007 | 958 | 81 |
346456 | 346456 | 2020-07-18 | Beaver | Pennsylvania | 42007 | 949 | 81 |
343256 | 343256 | 2020-07-17 | Beaver | Pennsylvania | 42007 | 918 | 81 |
340058 | 340058 | 2020-07-16 | Beaver | Pennsylvania | 42007 | 893 | 80 |
336861 | 336861 | 2020-07-15 | Beaver | Pennsylvania | 42007 | 884 | 79 |
333667 | 333667 | 2020-07-14 | Beaver | Pennsylvania | 42007 | 870 | 79 |
330475 | 330475 | 2020-07-13 | Beaver | Pennsylvania | 42007 | 845 | 79 |
327289 | 327289 | 2020-07-12 | Beaver | Pennsylvania | 42007 | 837 | 79 |
324104 | 324104 | 2020-07-11 | Beaver | Pennsylvania | 42007 | 823 | 79 |
320924 | 320924 | 2020-07-10 | Beaver | Pennsylvania | 42007 | 809 | 79 |
317746 | 317746 | 2020-07-09 | Beaver | Pennsylvania | 42007 | 796 | 79 |
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);