ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42011 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919459 | 919459 | 2021-01-11 | Berks | Pennsylvania | 42011 | 26732 | 629 |
916214 | 916214 | 2021-01-10 | Berks | Pennsylvania | 42011 | 26512 | 628 |
912969 | 912969 | 2021-01-09 | Berks | Pennsylvania | 42011 | 26198 | 624 |
909724 | 909724 | 2021-01-08 | Berks | Pennsylvania | 42011 | 25874 | 614 |
906479 | 906479 | 2021-01-07 | Berks | Pennsylvania | 42011 | 25523 | 605 |
903233 | 903233 | 2021-01-06 | Berks | Pennsylvania | 42011 | 25180 | 595 |
899988 | 899988 | 2021-01-05 | Berks | Pennsylvania | 42011 | 24820 | 579 |
896743 | 896743 | 2021-01-04 | Berks | Pennsylvania | 42011 | 24318 | 574 |
893497 | 893497 | 2021-01-03 | Berks | Pennsylvania | 42011 | 24232 | 573 |
890251 | 890251 | 2021-01-02 | Berks | Pennsylvania | 42011 | 24052 | 572 |
887004 | 887004 | 2021-01-01 | Berks | Pennsylvania | 42011 | 23758 | 571 |
883759 | 883759 | 2020-12-31 | Berks | Pennsylvania | 42011 | 23439 | 565 |
880514 | 880514 | 2020-12-30 | Berks | Pennsylvania | 42011 | 23154 | 557 |
877269 | 877269 | 2020-12-29 | Berks | Pennsylvania | 42011 | 22758 | 546 |
874024 | 874024 | 2020-12-28 | Berks | Pennsylvania | 42011 | 22486 | 540 |
870779 | 870779 | 2020-12-27 | Berks | Pennsylvania | 42011 | 22297 | 540 |
867534 | 867534 | 2020-12-26 | Berks | Pennsylvania | 42011 | 22024 | 540 |
864289 | 864289 | 2020-12-25 | Berks | Pennsylvania | 42011 | 21728 | 539 |
861044 | 861044 | 2020-12-24 | Berks | Pennsylvania | 42011 | 21392 | 537 |
857799 | 857799 | 2020-12-23 | Berks | Pennsylvania | 42011 | 21087 | 529 |
854554 | 854554 | 2020-12-22 | Berks | Pennsylvania | 42011 | 20796 | 522 |
851309 | 851309 | 2020-12-21 | Berks | Pennsylvania | 42011 | 20546 | 518 |
848064 | 848064 | 2020-12-20 | Berks | Pennsylvania | 42011 | 20259 | 516 |
844819 | 844819 | 2020-12-19 | Berks | Pennsylvania | 42011 | 19988 | 515 |
841573 | 841573 | 2020-12-18 | Berks | Pennsylvania | 42011 | 19698 | 512 |
838328 | 838328 | 2020-12-17 | Berks | Pennsylvania | 42011 | 19401 | 508 |
835082 | 835082 | 2020-12-16 | Berks | Pennsylvania | 42011 | 19047 | 502 |
831836 | 831836 | 2020-12-15 | Berks | Pennsylvania | 42011 | 18730 | 499 |
828589 | 828589 | 2020-12-14 | Berks | Pennsylvania | 42011 | 18418 | 490 |
825343 | 825343 | 2020-12-13 | Berks | Pennsylvania | 42011 | 18056 | 490 |
822096 | 822096 | 2020-12-12 | Berks | Pennsylvania | 42011 | 17803 | 489 |
818850 | 818850 | 2020-12-11 | Berks | Pennsylvania | 42011 | 17441 | 486 |
815604 | 815604 | 2020-12-10 | Berks | Pennsylvania | 42011 | 17153 | 482 |
812358 | 812358 | 2020-12-09 | Berks | Pennsylvania | 42011 | 16748 | 475 |
809114 | 809114 | 2020-12-08 | Berks | Pennsylvania | 42011 | 16468 | 474 |
805869 | 805869 | 2020-12-07 | Berks | Pennsylvania | 42011 | 16049 | 472 |
802624 | 802624 | 2020-12-06 | Berks | Pennsylvania | 42011 | 15791 | 472 |
799379 | 799379 | 2020-12-05 | Berks | Pennsylvania | 42011 | 15514 | 472 |
796134 | 796134 | 2020-12-04 | Berks | Pennsylvania | 42011 | 15136 | 470 |
792889 | 792889 | 2020-12-03 | Berks | Pennsylvania | 42011 | 14810 | 467 |
789644 | 789644 | 2020-12-02 | Berks | Pennsylvania | 42011 | 14347 | 463 |
786399 | 786399 | 2020-12-01 | Berks | Pennsylvania | 42011 | 14065 | 461 |
783155 | 783155 | 2020-11-30 | Berks | Pennsylvania | 42011 | 13956 | 459 |
779910 | 779910 | 2020-11-29 | Berks | Pennsylvania | 42011 | 13874 | 459 |
776664 | 776664 | 2020-11-28 | Berks | Pennsylvania | 42011 | 13694 | 457 |
773419 | 773419 | 2020-11-27 | Berks | Pennsylvania | 42011 | 13519 | 456 |
770174 | 770174 | 2020-11-26 | Berks | Pennsylvania | 42011 | 13347 | 456 |
766928 | 766928 | 2020-11-25 | Berks | Pennsylvania | 42011 | 13048 | 456 |
763683 | 763683 | 2020-11-24 | Berks | Pennsylvania | 42011 | 12909 | 456 |
760438 | 760438 | 2020-11-23 | Berks | Pennsylvania | 42011 | 12740 | 452 |
757193 | 757193 | 2020-11-22 | Berks | Pennsylvania | 42011 | 12537 | 452 |
753946 | 753946 | 2020-11-21 | Berks | Pennsylvania | 42011 | 12379 | 450 |
750700 | 750700 | 2020-11-20 | Berks | Pennsylvania | 42011 | 12215 | 450 |
747454 | 747454 | 2020-11-19 | Berks | Pennsylvania | 42011 | 12082 | 449 |
744208 | 744208 | 2020-11-18 | Berks | Pennsylvania | 42011 | 11888 | 445 |
740961 | 740961 | 2020-11-17 | Berks | Pennsylvania | 42011 | 11709 | 441 |
737715 | 737715 | 2020-11-16 | Berks | Pennsylvania | 42011 | 11518 | 441 |
734471 | 734471 | 2020-11-15 | Berks | Pennsylvania | 42011 | 11359 | 441 |
731225 | 731225 | 2020-11-14 | Berks | Pennsylvania | 42011 | 11191 | 441 |
727981 | 727981 | 2020-11-13 | Berks | Pennsylvania | 42011 | 11036 | 440 |
724737 | 724737 | 2020-11-12 | Berks | Pennsylvania | 42011 | 10899 | 438 |
721494 | 721494 | 2020-11-11 | Berks | Pennsylvania | 42011 | 10767 | 438 |
718251 | 718251 | 2020-11-10 | Berks | Pennsylvania | 42011 | 10595 | 437 |
715008 | 715008 | 2020-11-09 | Berks | Pennsylvania | 42011 | 10447 | 437 |
711764 | 711764 | 2020-11-08 | Berks | Pennsylvania | 42011 | 10355 | 437 |
708520 | 708520 | 2020-11-07 | Berks | Pennsylvania | 42011 | 10278 | 437 |
705277 | 705277 | 2020-11-06 | Berks | Pennsylvania | 42011 | 10165 | 433 |
702034 | 702034 | 2020-11-05 | Berks | Pennsylvania | 42011 | 10058 | 432 |
698790 | 698790 | 2020-11-04 | Berks | Pennsylvania | 42011 | 9972 | 430 |
695547 | 695547 | 2020-11-03 | Berks | Pennsylvania | 42011 | 9860 | 427 |
692305 | 692305 | 2020-11-02 | Berks | Pennsylvania | 42011 | 9735 | 425 |
689061 | 689061 | 2020-11-01 | Berks | Pennsylvania | 42011 | 9648 | 425 |
685816 | 685816 | 2020-10-31 | Berks | Pennsylvania | 42011 | 9562 | 425 |
682573 | 682573 | 2020-10-30 | Berks | Pennsylvania | 42011 | 9481 | 423 |
679330 | 679330 | 2020-10-29 | Berks | Pennsylvania | 42011 | 9388 | 423 |
676087 | 676087 | 2020-10-28 | Berks | Pennsylvania | 42011 | 9290 | 422 |
672844 | 672844 | 2020-10-27 | Berks | Pennsylvania | 42011 | 9155 | 421 |
669602 | 669602 | 2020-10-26 | Berks | Pennsylvania | 42011 | 9024 | 419 |
666358 | 666358 | 2020-10-25 | Berks | Pennsylvania | 42011 | 8924 | 419 |
663113 | 663113 | 2020-10-24 | Berks | Pennsylvania | 42011 | 8815 | 419 |
659869 | 659869 | 2020-10-23 | Berks | Pennsylvania | 42011 | 8698 | 418 |
656625 | 656625 | 2020-10-22 | Berks | Pennsylvania | 42011 | 8632 | 418 |
653380 | 653380 | 2020-10-21 | Berks | Pennsylvania | 42011 | 8533 | 418 |
650135 | 650135 | 2020-10-20 | Berks | Pennsylvania | 42011 | 8458 | 417 |
646891 | 646891 | 2020-10-19 | Berks | Pennsylvania | 42011 | 8377 | 413 |
643645 | 643645 | 2020-10-18 | Berks | Pennsylvania | 42011 | 8293 | 412 |
640397 | 640397 | 2020-10-17 | Berks | Pennsylvania | 42011 | 8212 | 412 |
637151 | 637151 | 2020-10-16 | Berks | Pennsylvania | 42011 | 8102 | 411 |
633905 | 633905 | 2020-10-15 | Berks | Pennsylvania | 42011 | 8035 | 410 |
630660 | 630660 | 2020-10-14 | Berks | Pennsylvania | 42011 | 7961 | 409 |
627416 | 627416 | 2020-10-13 | Berks | Pennsylvania | 42011 | 7901 | 408 |
624174 | 624174 | 2020-10-12 | Berks | Pennsylvania | 42011 | 7819 | 407 |
620931 | 620931 | 2020-10-11 | Berks | Pennsylvania | 42011 | 7781 | 407 |
617688 | 617688 | 2020-10-10 | Berks | Pennsylvania | 42011 | 7726 | 406 |
614446 | 614446 | 2020-10-09 | Berks | Pennsylvania | 42011 | 7651 | 404 |
611205 | 611205 | 2020-10-08 | Berks | Pennsylvania | 42011 | 7564 | 404 |
607963 | 607963 | 2020-10-07 | Berks | Pennsylvania | 42011 | 7489 | 402 |
604720 | 604720 | 2020-10-06 | Berks | Pennsylvania | 42011 | 7420 | 401 |
601478 | 601478 | 2020-10-05 | Berks | Pennsylvania | 42011 | 7378 | 399 |
598235 | 598235 | 2020-10-04 | Berks | Pennsylvania | 42011 | 7351 | 399 |
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);