ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Coamo" 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 |
---|---|---|---|---|---|---|---|
922787 | 922787 | 2021-01-12 | Coamo | Puerto Rico | 72043 | 854 | |
919542 | 919542 | 2021-01-11 | Coamo | Puerto Rico | 72043 | 840 | |
916297 | 916297 | 2021-01-10 | Coamo | Puerto Rico | 72043 | 835 | |
913052 | 913052 | 2021-01-09 | Coamo | Puerto Rico | 72043 | 809 | |
909807 | 909807 | 2021-01-08 | Coamo | Puerto Rico | 72043 | 802 | |
906562 | 906562 | 2021-01-07 | Coamo | Puerto Rico | 72043 | 792 | |
903316 | 903316 | 2021-01-06 | Coamo | Puerto Rico | 72043 | 788 | |
900071 | 900071 | 2021-01-05 | Coamo | Puerto Rico | 72043 | 787 | |
896826 | 896826 | 2021-01-04 | Coamo | Puerto Rico | 72043 | 776 | |
893580 | 893580 | 2021-01-03 | Coamo | Puerto Rico | 72043 | 769 | |
890334 | 890334 | 2021-01-02 | Coamo | Puerto Rico | 72043 | 768 | |
887087 | 887087 | 2021-01-01 | Coamo | Puerto Rico | 72043 | 747 | |
883842 | 883842 | 2020-12-31 | Coamo | Puerto Rico | 72043 | 743 | |
880597 | 880597 | 2020-12-30 | Coamo | Puerto Rico | 72043 | 738 | |
877352 | 877352 | 2020-12-29 | Coamo | Puerto Rico | 72043 | 738 | |
874107 | 874107 | 2020-12-28 | Coamo | Puerto Rico | 72043 | 705 | |
870862 | 870862 | 2020-12-27 | Coamo | Puerto Rico | 72043 | 703 | |
867617 | 867617 | 2020-12-26 | Coamo | Puerto Rico | 72043 | 699 | |
864372 | 864372 | 2020-12-25 | Coamo | Puerto Rico | 72043 | 694 | |
861127 | 861127 | 2020-12-24 | Coamo | Puerto Rico | 72043 | 691 | |
857882 | 857882 | 2020-12-23 | Coamo | Puerto Rico | 72043 | 687 | |
854637 | 854637 | 2020-12-22 | Coamo | Puerto Rico | 72043 | 687 | |
851392 | 851392 | 2020-12-21 | Coamo | Puerto Rico | 72043 | 682 | |
848147 | 848147 | 2020-12-20 | Coamo | Puerto Rico | 72043 | 679 | |
844902 | 844902 | 2020-12-19 | Coamo | Puerto Rico | 72043 | 676 | |
841656 | 841656 | 2020-12-18 | Coamo | Puerto Rico | 72043 | 663 | |
838411 | 838411 | 2020-12-17 | Coamo | Puerto Rico | 72043 | 654 | |
835165 | 835165 | 2020-12-16 | Coamo | Puerto Rico | 72043 | 649 | |
831919 | 831919 | 2020-12-15 | Coamo | Puerto Rico | 72043 | 649 | |
828672 | 828672 | 2020-12-14 | Coamo | Puerto Rico | 72043 | 646 | |
825426 | 825426 | 2020-12-13 | Coamo | Puerto Rico | 72043 | 630 | |
822179 | 822179 | 2020-12-12 | Coamo | Puerto Rico | 72043 | 615 | |
818933 | 818933 | 2020-12-11 | Coamo | Puerto Rico | 72043 | 607 | |
815687 | 815687 | 2020-12-10 | Coamo | Puerto Rico | 72043 | 599 | |
812441 | 812441 | 2020-12-09 | Coamo | Puerto Rico | 72043 | 596 | |
809197 | 809197 | 2020-12-08 | Coamo | Puerto Rico | 72043 | 592 | |
805952 | 805952 | 2020-12-07 | Coamo | Puerto Rico | 72043 | 587 | |
802707 | 802707 | 2020-12-06 | Coamo | Puerto Rico | 72043 | 581 | |
799462 | 799462 | 2020-12-05 | Coamo | Puerto Rico | 72043 | 574 | |
796217 | 796217 | 2020-12-04 | Coamo | Puerto Rico | 72043 | 568 | |
792972 | 792972 | 2020-12-03 | Coamo | Puerto Rico | 72043 | 567 | |
789727 | 789727 | 2020-12-02 | Coamo | Puerto Rico | 72043 | 567 | |
786482 | 786482 | 2020-12-01 | Coamo | Puerto Rico | 72043 | 565 | |
783238 | 783238 | 2020-11-30 | Coamo | Puerto Rico | 72043 | 562 | |
779993 | 779993 | 2020-11-29 | Coamo | Puerto Rico | 72043 | 561 | |
776747 | 776747 | 2020-11-28 | Coamo | Puerto Rico | 72043 | 558 | |
773502 | 773502 | 2020-11-27 | Coamo | Puerto Rico | 72043 | 552 | |
770257 | 770257 | 2020-11-26 | Coamo | Puerto Rico | 72043 | 538 | |
767011 | 767011 | 2020-11-25 | Coamo | Puerto Rico | 72043 | 525 | |
763766 | 763766 | 2020-11-24 | Coamo | Puerto Rico | 72043 | 525 | |
760521 | 760521 | 2020-11-23 | Coamo | Puerto Rico | 72043 | 525 | |
757276 | 757276 | 2020-11-22 | Coamo | Puerto Rico | 72043 | 525 | |
754029 | 754029 | 2020-11-21 | Coamo | Puerto Rico | 72043 | 521 | |
750783 | 750783 | 2020-11-20 | Coamo | Puerto Rico | 72043 | 511 | |
747537 | 747537 | 2020-11-19 | Coamo | Puerto Rico | 72043 | 509 | |
744291 | 744291 | 2020-11-18 | Coamo | Puerto Rico | 72043 | 507 | |
741044 | 741044 | 2020-11-17 | Coamo | Puerto Rico | 72043 | 504 | |
737798 | 737798 | 2020-11-16 | Coamo | Puerto Rico | 72043 | 502 | |
734554 | 734554 | 2020-11-15 | Coamo | Puerto Rico | 72043 | 502 | |
731308 | 731308 | 2020-11-14 | Coamo | Puerto Rico | 72043 | 500 | |
728064 | 728064 | 2020-11-13 | Coamo | Puerto Rico | 72043 | 494 | |
724820 | 724820 | 2020-11-12 | Coamo | Puerto Rico | 72043 | 481 | |
721577 | 721577 | 2020-11-11 | Coamo | Puerto Rico | 72043 | 474 | |
718334 | 718334 | 2020-11-10 | Coamo | Puerto Rico | 72043 | 472 | |
715091 | 715091 | 2020-11-09 | Coamo | Puerto Rico | 72043 | 471 | |
711847 | 711847 | 2020-11-08 | Coamo | Puerto Rico | 72043 | 470 | |
708603 | 708603 | 2020-11-07 | Coamo | Puerto Rico | 72043 | 461 | |
705360 | 705360 | 2020-11-06 | Coamo | Puerto Rico | 72043 | 461 | |
702117 | 702117 | 2020-11-05 | Coamo | Puerto Rico | 72043 | 449 | |
698873 | 698873 | 2020-11-04 | Coamo | Puerto Rico | 72043 | 447 | |
695630 | 695630 | 2020-11-03 | Coamo | Puerto Rico | 72043 | 447 | |
692388 | 692388 | 2020-11-02 | Coamo | Puerto Rico | 72043 | 446 | |
689144 | 689144 | 2020-11-01 | Coamo | Puerto Rico | 72043 | 434 | |
685899 | 685899 | 2020-10-31 | Coamo | Puerto Rico | 72043 | 431 | |
682656 | 682656 | 2020-10-30 | Coamo | Puerto Rico | 72043 | 427 | |
679413 | 679413 | 2020-10-29 | Coamo | Puerto Rico | 72043 | 415 | |
676170 | 676170 | 2020-10-28 | Coamo | Puerto Rico | 72043 | 393 | |
672927 | 672927 | 2020-10-27 | Coamo | Puerto Rico | 72043 | 392 | |
669685 | 669685 | 2020-10-26 | Coamo | Puerto Rico | 72043 | 392 | |
666441 | 666441 | 2020-10-25 | Coamo | Puerto Rico | 72043 | 390 | |
663196 | 663196 | 2020-10-24 | Coamo | Puerto Rico | 72043 | 383 | |
659952 | 659952 | 2020-10-23 | Coamo | Puerto Rico | 72043 | 383 | |
656708 | 656708 | 2020-10-22 | Coamo | Puerto Rico | 72043 | 363 | |
653463 | 653463 | 2020-10-21 | Coamo | Puerto Rico | 72043 | 360 | |
650218 | 650218 | 2020-10-20 | Coamo | Puerto Rico | 72043 | 360 | |
646974 | 646974 | 2020-10-19 | Coamo | Puerto Rico | 72043 | 360 | |
643728 | 643728 | 2020-10-18 | Coamo | Puerto Rico | 72043 | 354 | |
640480 | 640480 | 2020-10-17 | Coamo | Puerto Rico | 72043 | 351 | |
637234 | 637234 | 2020-10-16 | Coamo | Puerto Rico | 72043 | 350 | |
633988 | 633988 | 2020-10-15 | Coamo | Puerto Rico | 72043 | 350 | |
630743 | 630743 | 2020-10-14 | Coamo | Puerto Rico | 72043 | 343 | |
627499 | 627499 | 2020-10-13 | Coamo | Puerto Rico | 72043 | 340 | |
624257 | 624257 | 2020-10-12 | Coamo | Puerto Rico | 72043 | 338 | |
621014 | 621014 | 2020-10-11 | Coamo | Puerto Rico | 72043 | 332 | |
617771 | 617771 | 2020-10-10 | Coamo | Puerto Rico | 72043 | 328 | |
614529 | 614529 | 2020-10-09 | Coamo | Puerto Rico | 72043 | 324 | |
611288 | 611288 | 2020-10-08 | Coamo | Puerto Rico | 72043 | 324 | |
608046 | 608046 | 2020-10-07 | Coamo | Puerto Rico | 72043 | 320 | |
604803 | 604803 | 2020-10-06 | Coamo | Puerto Rico | 72043 | 319 | |
601561 | 601561 | 2020-10-05 | Coamo | Puerto Rico | 72043 | 314 |
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);