ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Crawford" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922718 | 922718 | 2021-01-12 | Crawford | Pennsylvania | 42039 | 5397 | 104 |
919473 | 919473 | 2021-01-11 | Crawford | Pennsylvania | 42039 | 5370 | 101 |
916228 | 916228 | 2021-01-10 | Crawford | Pennsylvania | 42039 | 5346 | 101 |
912983 | 912983 | 2021-01-09 | Crawford | Pennsylvania | 42039 | 5287 | 100 |
909738 | 909738 | 2021-01-08 | Crawford | Pennsylvania | 42039 | 5208 | 96 |
906493 | 906493 | 2021-01-07 | Crawford | Pennsylvania | 42039 | 5144 | 92 |
903247 | 903247 | 2021-01-06 | Crawford | Pennsylvania | 42039 | 5118 | 92 |
900002 | 900002 | 2021-01-05 | Crawford | Pennsylvania | 42039 | 5072 | 85 |
896757 | 896757 | 2021-01-04 | Crawford | Pennsylvania | 42039 | 5032 | 85 |
893511 | 893511 | 2021-01-03 | Crawford | Pennsylvania | 42039 | 5021 | 84 |
890265 | 890265 | 2021-01-02 | Crawford | Pennsylvania | 42039 | 4982 | 84 |
887018 | 887018 | 2021-01-01 | Crawford | Pennsylvania | 42039 | 4947 | 84 |
883773 | 883773 | 2020-12-31 | Crawford | Pennsylvania | 42039 | 4859 | 84 |
880528 | 880528 | 2020-12-30 | Crawford | Pennsylvania | 42039 | 4809 | 76 |
877283 | 877283 | 2020-12-29 | Crawford | Pennsylvania | 42039 | 4760 | 74 |
874038 | 874038 | 2020-12-28 | Crawford | Pennsylvania | 42039 | 4702 | 72 |
870793 | 870793 | 2020-12-27 | Crawford | Pennsylvania | 42039 | 4690 | 70 |
867548 | 867548 | 2020-12-26 | Crawford | Pennsylvania | 42039 | 4665 | 70 |
864303 | 864303 | 2020-12-25 | Crawford | Pennsylvania | 42039 | 4599 | 70 |
861058 | 861058 | 2020-12-24 | Crawford | Pennsylvania | 42039 | 4552 | 67 |
857813 | 857813 | 2020-12-23 | Crawford | Pennsylvania | 42039 | 4479 | 66 |
854568 | 854568 | 2020-12-22 | Crawford | Pennsylvania | 42039 | 4415 | 64 |
851323 | 851323 | 2020-12-21 | Crawford | Pennsylvania | 42039 | 4345 | 61 |
848078 | 848078 | 2020-12-20 | Crawford | Pennsylvania | 42039 | 4281 | 61 |
844833 | 844833 | 2020-12-19 | Crawford | Pennsylvania | 42039 | 4226 | 60 |
841587 | 841587 | 2020-12-18 | Crawford | Pennsylvania | 42039 | 4126 | 57 |
838342 | 838342 | 2020-12-17 | Crawford | Pennsylvania | 42039 | 4040 | 54 |
835096 | 835096 | 2020-12-16 | Crawford | Pennsylvania | 42039 | 3986 | 49 |
831850 | 831850 | 2020-12-15 | Crawford | Pennsylvania | 42039 | 3890 | 46 |
828603 | 828603 | 2020-12-14 | Crawford | Pennsylvania | 42039 | 3768 | 46 |
825357 | 825357 | 2020-12-13 | Crawford | Pennsylvania | 42039 | 3677 | 45 |
822110 | 822110 | 2020-12-12 | Crawford | Pennsylvania | 42039 | 3566 | 43 |
818864 | 818864 | 2020-12-11 | Crawford | Pennsylvania | 42039 | 3401 | 41 |
815618 | 815618 | 2020-12-10 | Crawford | Pennsylvania | 42039 | 2803 | 37 |
812372 | 812372 | 2020-12-09 | Crawford | Pennsylvania | 42039 | 2731 | 36 |
809128 | 809128 | 2020-12-08 | Crawford | Pennsylvania | 42039 | 2630 | 33 |
805883 | 805883 | 2020-12-07 | Crawford | Pennsylvania | 42039 | 2523 | 30 |
802638 | 802638 | 2020-12-06 | Crawford | Pennsylvania | 42039 | 2444 | 30 |
799393 | 799393 | 2020-12-05 | Crawford | Pennsylvania | 42039 | 2370 | 30 |
796148 | 796148 | 2020-12-04 | Crawford | Pennsylvania | 42039 | 2284 | 27 |
792903 | 792903 | 2020-12-03 | Crawford | Pennsylvania | 42039 | 2221 | 25 |
789658 | 789658 | 2020-12-02 | Crawford | Pennsylvania | 42039 | 2126 | 24 |
786413 | 786413 | 2020-12-01 | Crawford | Pennsylvania | 42039 | 2007 | 19 |
783169 | 783169 | 2020-11-30 | Crawford | Pennsylvania | 42039 | 1920 | 18 |
779924 | 779924 | 2020-11-29 | Crawford | Pennsylvania | 42039 | 1871 | 18 |
776678 | 776678 | 2020-11-28 | Crawford | Pennsylvania | 42039 | 1807 | 17 |
773433 | 773433 | 2020-11-27 | Crawford | Pennsylvania | 42039 | 1750 | 17 |
770188 | 770188 | 2020-11-26 | Crawford | Pennsylvania | 42039 | 1709 | 16 |
766942 | 766942 | 2020-11-25 | Crawford | Pennsylvania | 42039 | 1635 | 14 |
763697 | 763697 | 2020-11-24 | Crawford | Pennsylvania | 42039 | 1564 | 13 |
760452 | 760452 | 2020-11-23 | Crawford | Pennsylvania | 42039 | 1508 | 12 |
757207 | 757207 | 2020-11-22 | Crawford | Pennsylvania | 42039 | 1470 | 12 |
753960 | 753960 | 2020-11-21 | Crawford | Pennsylvania | 42039 | 1420 | 11 |
750714 | 750714 | 2020-11-20 | Crawford | Pennsylvania | 42039 | 1362 | 10 |
747468 | 747468 | 2020-11-19 | Crawford | Pennsylvania | 42039 | 1310 | 9 |
744222 | 744222 | 2020-11-18 | Crawford | Pennsylvania | 42039 | 1241 | 8 |
740975 | 740975 | 2020-11-17 | Crawford | Pennsylvania | 42039 | 1178 | 6 |
737729 | 737729 | 2020-11-16 | Crawford | Pennsylvania | 42039 | 1097 | 5 |
734485 | 734485 | 2020-11-15 | Crawford | Pennsylvania | 42039 | 1039 | 5 |
731239 | 731239 | 2020-11-14 | Crawford | Pennsylvania | 42039 | 998 | 5 |
727995 | 727995 | 2020-11-13 | Crawford | Pennsylvania | 42039 | 953 | 5 |
724751 | 724751 | 2020-11-12 | Crawford | Pennsylvania | 42039 | 883 | 4 |
721508 | 721508 | 2020-11-11 | Crawford | Pennsylvania | 42039 | 813 | 4 |
718265 | 718265 | 2020-11-10 | Crawford | Pennsylvania | 42039 | 765 | 4 |
715022 | 715022 | 2020-11-09 | Crawford | Pennsylvania | 42039 | 741 | 4 |
711778 | 711778 | 2020-11-08 | Crawford | Pennsylvania | 42039 | 730 | 4 |
708534 | 708534 | 2020-11-07 | Crawford | Pennsylvania | 42039 | 703 | 4 |
705291 | 705291 | 2020-11-06 | Crawford | Pennsylvania | 42039 | 687 | 4 |
702048 | 702048 | 2020-11-05 | Crawford | Pennsylvania | 42039 | 668 | 4 |
698804 | 698804 | 2020-11-04 | Crawford | Pennsylvania | 42039 | 650 | 4 |
695561 | 695561 | 2020-11-03 | Crawford | Pennsylvania | 42039 | 624 | 3 |
692319 | 692319 | 2020-11-02 | Crawford | Pennsylvania | 42039 | 598 | 3 |
689075 | 689075 | 2020-11-01 | Crawford | Pennsylvania | 42039 | 585 | 3 |
685830 | 685830 | 2020-10-31 | Crawford | Pennsylvania | 42039 | 571 | 3 |
682587 | 682587 | 2020-10-30 | Crawford | Pennsylvania | 42039 | 561 | 3 |
679344 | 679344 | 2020-10-29 | Crawford | Pennsylvania | 42039 | 532 | 3 |
676101 | 676101 | 2020-10-28 | Crawford | Pennsylvania | 42039 | 523 | 3 |
672858 | 672858 | 2020-10-27 | Crawford | Pennsylvania | 42039 | 490 | 3 |
669616 | 669616 | 2020-10-26 | Crawford | Pennsylvania | 42039 | 478 | 3 |
666372 | 666372 | 2020-10-25 | Crawford | Pennsylvania | 42039 | 461 | 3 |
663127 | 663127 | 2020-10-24 | Crawford | Pennsylvania | 42039 | 449 | 3 |
659883 | 659883 | 2020-10-23 | Crawford | Pennsylvania | 42039 | 438 | 3 |
656639 | 656639 | 2020-10-22 | Crawford | Pennsylvania | 42039 | 431 | 3 |
653394 | 653394 | 2020-10-21 | Crawford | Pennsylvania | 42039 | 417 | 3 |
650149 | 650149 | 2020-10-20 | Crawford | Pennsylvania | 42039 | 399 | 3 |
646905 | 646905 | 2020-10-19 | Crawford | Pennsylvania | 42039 | 392 | 3 |
643659 | 643659 | 2020-10-18 | Crawford | Pennsylvania | 42039 | 386 | 3 |
640411 | 640411 | 2020-10-17 | Crawford | Pennsylvania | 42039 | 379 | 3 |
637165 | 637165 | 2020-10-16 | Crawford | Pennsylvania | 42039 | 374 | 3 |
633919 | 633919 | 2020-10-15 | Crawford | Pennsylvania | 42039 | 366 | 3 |
630674 | 630674 | 2020-10-14 | Crawford | Pennsylvania | 42039 | 359 | 3 |
627430 | 627430 | 2020-10-13 | Crawford | Pennsylvania | 42039 | 356 | 3 |
624188 | 624188 | 2020-10-12 | Crawford | Pennsylvania | 42039 | 355 | 3 |
620945 | 620945 | 2020-10-11 | Crawford | Pennsylvania | 42039 | 345 | 3 |
617702 | 617702 | 2020-10-10 | Crawford | Pennsylvania | 42039 | 342 | 3 |
614460 | 614460 | 2020-10-09 | Crawford | Pennsylvania | 42039 | 336 | 3 |
611219 | 611219 | 2020-10-08 | Crawford | Pennsylvania | 42039 | 334 | 3 |
607977 | 607977 | 2020-10-07 | Crawford | Pennsylvania | 42039 | 332 | 3 |
604734 | 604734 | 2020-10-06 | Crawford | Pennsylvania | 42039 | 331 | 3 |
601492 | 601492 | 2020-10-05 | Crawford | Pennsylvania | 42039 | 330 | 3 |
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);