ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72045 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1065593 | 1065593 | 2021-02-25 | Comerio | Puerto Rico | 72045 | 675 | |
1062348 | 1062348 | 2021-02-24 | Comerio | Puerto Rico | 72045 | 675 | |
1059103 | 1059103 | 2021-02-23 | Comerio | Puerto Rico | 72045 | 675 | |
1055857 | 1055857 | 2021-02-22 | Comerio | Puerto Rico | 72045 | 675 | |
1052611 | 1052611 | 2021-02-21 | Comerio | Puerto Rico | 72045 | 675 | |
1049364 | 1049364 | 2021-02-20 | Comerio | Puerto Rico | 72045 | 675 | |
1046117 | 1046117 | 2021-02-19 | Comerio | Puerto Rico | 72045 | 675 | |
1042872 | 1042872 | 2021-02-18 | Comerio | Puerto Rico | 72045 | 675 | |
1039627 | 1039627 | 2021-02-17 | Comerio | Puerto Rico | 72045 | 674 | |
1036382 | 1036382 | 2021-02-16 | Comerio | Puerto Rico | 72045 | 674 | |
1033137 | 1033137 | 2021-02-15 | Comerio | Puerto Rico | 72045 | 674 | |
1029891 | 1029891 | 2021-02-14 | Comerio | Puerto Rico | 72045 | 674 | |
1026644 | 1026644 | 2021-02-13 | Comerio | Puerto Rico | 72045 | 674 | |
1023399 | 1023399 | 2021-02-12 | Comerio | Puerto Rico | 72045 | 674 | |
1020154 | 1020154 | 2021-02-11 | Comerio | Puerto Rico | 72045 | 674 | |
1016909 | 1016909 | 2021-02-10 | Comerio | Puerto Rico | 72045 | 671 | |
1013664 | 1013664 | 2021-02-09 | Comerio | Puerto Rico | 72045 | 671 | |
1010419 | 1010419 | 2021-02-08 | Comerio | Puerto Rico | 72045 | 671 | |
1007173 | 1007173 | 2021-02-07 | Comerio | Puerto Rico | 72045 | 671 | |
1003927 | 1003927 | 2021-02-06 | Comerio | Puerto Rico | 72045 | 671 | |
1000681 | 1000681 | 2021-02-05 | Comerio | Puerto Rico | 72045 | 670 | |
997435 | 997435 | 2021-02-04 | Comerio | Puerto Rico | 72045 | 670 | |
994189 | 994189 | 2021-02-03 | Comerio | Puerto Rico | 72045 | 670 | |
990943 | 990943 | 2021-02-02 | Comerio | Puerto Rico | 72045 | 670 | |
987697 | 987697 | 2021-02-01 | Comerio | Puerto Rico | 72045 | 669 | |
984450 | 984450 | 2021-01-31 | Comerio | Puerto Rico | 72045 | 668 | |
981203 | 981203 | 2021-01-30 | Comerio | Puerto Rico | 72045 | 668 | |
977957 | 977957 | 2021-01-29 | Comerio | Puerto Rico | 72045 | 668 | |
974712 | 974712 | 2021-01-28 | Comerio | Puerto Rico | 72045 | 667 | |
971467 | 971467 | 2021-01-27 | Comerio | Puerto Rico | 72045 | 666 | |
968222 | 968222 | 2021-01-26 | Comerio | Puerto Rico | 72045 | 666 | |
964978 | 964978 | 2021-01-25 | Comerio | Puerto Rico | 72045 | 665 | |
961733 | 961733 | 2021-01-24 | Comerio | Puerto Rico | 72045 | 663 | |
958488 | 958488 | 2021-01-23 | Comerio | Puerto Rico | 72045 | 661 | |
955242 | 955242 | 2021-01-22 | Comerio | Puerto Rico | 72045 | 660 | |
951997 | 951997 | 2021-01-21 | Comerio | Puerto Rico | 72045 | 657 | |
948752 | 948752 | 2021-01-20 | Comerio | Puerto Rico | 72045 | 657 | |
945506 | 945506 | 2021-01-19 | Comerio | Puerto Rico | 72045 | 656 | |
942259 | 942259 | 2021-01-18 | Comerio | Puerto Rico | 72045 | 655 | |
939014 | 939014 | 2021-01-17 | Comerio | Puerto Rico | 72045 | 654 | |
935769 | 935769 | 2021-01-16 | Comerio | Puerto Rico | 72045 | 653 | |
932524 | 932524 | 2021-01-15 | Comerio | Puerto Rico | 72045 | 646 | |
929279 | 929279 | 2021-01-14 | Comerio | Puerto Rico | 72045 | 643 | |
926034 | 926034 | 2021-01-13 | Comerio | Puerto Rico | 72045 | 639 | |
922788 | 922788 | 2021-01-12 | Comerio | Puerto Rico | 72045 | 639 | |
919543 | 919543 | 2021-01-11 | Comerio | Puerto Rico | 72045 | 635 | |
916298 | 916298 | 2021-01-10 | Comerio | Puerto Rico | 72045 | 635 | |
913053 | 913053 | 2021-01-09 | Comerio | Puerto Rico | 72045 | 630 | |
909808 | 909808 | 2021-01-08 | Comerio | Puerto Rico | 72045 | 628 | |
906563 | 906563 | 2021-01-07 | Comerio | Puerto Rico | 72045 | 622 | |
903317 | 903317 | 2021-01-06 | Comerio | Puerto Rico | 72045 | 622 | |
900072 | 900072 | 2021-01-05 | Comerio | Puerto Rico | 72045 | 622 | |
896827 | 896827 | 2021-01-04 | Comerio | Puerto Rico | 72045 | 622 | |
893581 | 893581 | 2021-01-03 | Comerio | Puerto Rico | 72045 | 617 | |
890335 | 890335 | 2021-01-02 | Comerio | Puerto Rico | 72045 | 617 | |
887088 | 887088 | 2021-01-01 | Comerio | Puerto Rico | 72045 | 614 | |
883843 | 883843 | 2020-12-31 | Comerio | Puerto Rico | 72045 | 607 | |
880598 | 880598 | 2020-12-30 | Comerio | Puerto Rico | 72045 | 567 | |
877353 | 877353 | 2020-12-29 | Comerio | Puerto Rico | 72045 | 562 | |
874108 | 874108 | 2020-12-28 | Comerio | Puerto Rico | 72045 | 560 | |
870863 | 870863 | 2020-12-27 | Comerio | Puerto Rico | 72045 | 559 | |
867618 | 867618 | 2020-12-26 | Comerio | Puerto Rico | 72045 | 546 | |
864373 | 864373 | 2020-12-25 | Comerio | Puerto Rico | 72045 | 539 | |
861128 | 861128 | 2020-12-24 | Comerio | Puerto Rico | 72045 | 535 | |
857883 | 857883 | 2020-12-23 | Comerio | Puerto Rico | 72045 | 531 | |
854638 | 854638 | 2020-12-22 | Comerio | Puerto Rico | 72045 | 529 | |
851393 | 851393 | 2020-12-21 | Comerio | Puerto Rico | 72045 | 525 | |
848148 | 848148 | 2020-12-20 | Comerio | Puerto Rico | 72045 | 520 | |
844903 | 844903 | 2020-12-19 | Comerio | Puerto Rico | 72045 | 514 | |
841657 | 841657 | 2020-12-18 | Comerio | Puerto Rico | 72045 | 511 | |
838412 | 838412 | 2020-12-17 | Comerio | Puerto Rico | 72045 | 504 | |
835166 | 835166 | 2020-12-16 | Comerio | Puerto Rico | 72045 | 500 | |
831920 | 831920 | 2020-12-15 | Comerio | Puerto Rico | 72045 | 496 | |
828673 | 828673 | 2020-12-14 | Comerio | Puerto Rico | 72045 | 494 | |
825427 | 825427 | 2020-12-13 | Comerio | Puerto Rico | 72045 | 490 | |
822180 | 822180 | 2020-12-12 | Comerio | Puerto Rico | 72045 | 486 | |
818934 | 818934 | 2020-12-11 | Comerio | Puerto Rico | 72045 | 473 | |
815688 | 815688 | 2020-12-10 | Comerio | Puerto Rico | 72045 | 471 | |
812442 | 812442 | 2020-12-09 | Comerio | Puerto Rico | 72045 | 467 | |
809198 | 809198 | 2020-12-08 | Comerio | Puerto Rico | 72045 | 466 | |
805953 | 805953 | 2020-12-07 | Comerio | Puerto Rico | 72045 | 464 | |
802708 | 802708 | 2020-12-06 | Comerio | Puerto Rico | 72045 | 455 | |
799463 | 799463 | 2020-12-05 | Comerio | Puerto Rico | 72045 | 444 | |
796218 | 796218 | 2020-12-04 | Comerio | Puerto Rico | 72045 | 435 | |
792973 | 792973 | 2020-12-03 | Comerio | Puerto Rico | 72045 | 423 | |
789728 | 789728 | 2020-12-02 | Comerio | Puerto Rico | 72045 | 408 | |
786483 | 786483 | 2020-12-01 | Comerio | Puerto Rico | 72045 | 407 | |
783239 | 783239 | 2020-11-30 | Comerio | Puerto Rico | 72045 | 404 | |
779994 | 779994 | 2020-11-29 | Comerio | Puerto Rico | 72045 | 402 | |
776748 | 776748 | 2020-11-28 | Comerio | Puerto Rico | 72045 | 400 | |
773503 | 773503 | 2020-11-27 | Comerio | Puerto Rico | 72045 | 394 | |
770258 | 770258 | 2020-11-26 | Comerio | Puerto Rico | 72045 | 387 | |
767012 | 767012 | 2020-11-25 | Comerio | Puerto Rico | 72045 | 377 | |
763767 | 763767 | 2020-11-24 | Comerio | Puerto Rico | 72045 | 376 | |
760522 | 760522 | 2020-11-23 | Comerio | Puerto Rico | 72045 | 376 | |
757277 | 757277 | 2020-11-22 | Comerio | Puerto Rico | 72045 | 372 | |
754030 | 754030 | 2020-11-21 | Comerio | Puerto Rico | 72045 | 369 | |
750784 | 750784 | 2020-11-20 | Comerio | Puerto Rico | 72045 | 363 | |
747538 | 747538 | 2020-11-19 | Comerio | Puerto Rico | 72045 | 360 | |
744292 | 744292 | 2020-11-18 | Comerio | Puerto Rico | 72045 | 349 |
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);