ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ciales" 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 |
---|---|---|---|---|---|---|---|
922785 | 922785 | 2021-01-12 | Ciales | Puerto Rico | 72039 | 628 | |
919540 | 919540 | 2021-01-11 | Ciales | Puerto Rico | 72039 | 618 | |
916295 | 916295 | 2021-01-10 | Ciales | Puerto Rico | 72039 | 618 | |
913050 | 913050 | 2021-01-09 | Ciales | Puerto Rico | 72039 | 617 | |
909805 | 909805 | 2021-01-08 | Ciales | Puerto Rico | 72039 | 616 | |
906560 | 906560 | 2021-01-07 | Ciales | Puerto Rico | 72039 | 613 | |
903314 | 903314 | 2021-01-06 | Ciales | Puerto Rico | 72039 | 613 | |
900069 | 900069 | 2021-01-05 | Ciales | Puerto Rico | 72039 | 613 | |
896824 | 896824 | 2021-01-04 | Ciales | Puerto Rico | 72039 | 613 | |
893578 | 893578 | 2021-01-03 | Ciales | Puerto Rico | 72039 | 609 | |
890332 | 890332 | 2021-01-02 | Ciales | Puerto Rico | 72039 | 609 | |
887085 | 887085 | 2021-01-01 | Ciales | Puerto Rico | 72039 | 604 | |
883840 | 883840 | 2020-12-31 | Ciales | Puerto Rico | 72039 | 600 | |
880595 | 880595 | 2020-12-30 | Ciales | Puerto Rico | 72039 | 600 | |
877350 | 877350 | 2020-12-29 | Ciales | Puerto Rico | 72039 | 600 | |
874105 | 874105 | 2020-12-28 | Ciales | Puerto Rico | 72039 | 594 | |
870860 | 870860 | 2020-12-27 | Ciales | Puerto Rico | 72039 | 594 | |
867615 | 867615 | 2020-12-26 | Ciales | Puerto Rico | 72039 | 593 | |
864370 | 864370 | 2020-12-25 | Ciales | Puerto Rico | 72039 | 587 | |
861125 | 861125 | 2020-12-24 | Ciales | Puerto Rico | 72039 | 584 | |
857880 | 857880 | 2020-12-23 | Ciales | Puerto Rico | 72039 | 583 | |
854635 | 854635 | 2020-12-22 | Ciales | Puerto Rico | 72039 | 582 | |
851390 | 851390 | 2020-12-21 | Ciales | Puerto Rico | 72039 | 579 | |
848145 | 848145 | 2020-12-20 | Ciales | Puerto Rico | 72039 | 578 | |
844900 | 844900 | 2020-12-19 | Ciales | Puerto Rico | 72039 | 574 | |
841654 | 841654 | 2020-12-18 | Ciales | Puerto Rico | 72039 | 571 | |
838409 | 838409 | 2020-12-17 | Ciales | Puerto Rico | 72039 | 563 | |
835163 | 835163 | 2020-12-16 | Ciales | Puerto Rico | 72039 | 561 | |
831917 | 831917 | 2020-12-15 | Ciales | Puerto Rico | 72039 | 561 | |
828670 | 828670 | 2020-12-14 | Ciales | Puerto Rico | 72039 | 561 | |
825424 | 825424 | 2020-12-13 | Ciales | Puerto Rico | 72039 | 561 | |
822177 | 822177 | 2020-12-12 | Ciales | Puerto Rico | 72039 | 561 | |
818931 | 818931 | 2020-12-11 | Ciales | Puerto Rico | 72039 | 561 | |
815685 | 815685 | 2020-12-10 | Ciales | Puerto Rico | 72039 | 546 | |
812439 | 812439 | 2020-12-09 | Ciales | Puerto Rico | 72039 | 544 | |
809195 | 809195 | 2020-12-08 | Ciales | Puerto Rico | 72039 | 541 | |
805950 | 805950 | 2020-12-07 | Ciales | Puerto Rico | 72039 | 536 | |
802705 | 802705 | 2020-12-06 | Ciales | Puerto Rico | 72039 | 534 | |
799460 | 799460 | 2020-12-05 | Ciales | Puerto Rico | 72039 | 528 | |
796215 | 796215 | 2020-12-04 | Ciales | Puerto Rico | 72039 | 523 | |
792970 | 792970 | 2020-12-03 | Ciales | Puerto Rico | 72039 | 521 | |
789725 | 789725 | 2020-12-02 | Ciales | Puerto Rico | 72039 | 521 | |
786480 | 786480 | 2020-12-01 | Ciales | Puerto Rico | 72039 | 521 | |
783236 | 783236 | 2020-11-30 | Ciales | Puerto Rico | 72039 | 515 | |
779991 | 779991 | 2020-11-29 | Ciales | Puerto Rico | 72039 | 506 | |
776745 | 776745 | 2020-11-28 | Ciales | Puerto Rico | 72039 | 505 | |
773500 | 773500 | 2020-11-27 | Ciales | Puerto Rico | 72039 | 501 | |
770255 | 770255 | 2020-11-26 | Ciales | Puerto Rico | 72039 | 488 | |
767009 | 767009 | 2020-11-25 | Ciales | Puerto Rico | 72039 | 488 | |
763764 | 763764 | 2020-11-24 | Ciales | Puerto Rico | 72039 | 470 | |
760519 | 760519 | 2020-11-23 | Ciales | Puerto Rico | 72039 | 464 | |
757274 | 757274 | 2020-11-22 | Ciales | Puerto Rico | 72039 | 462 | |
754027 | 754027 | 2020-11-21 | Ciales | Puerto Rico | 72039 | 456 | |
750781 | 750781 | 2020-11-20 | Ciales | Puerto Rico | 72039 | 448 | |
747535 | 747535 | 2020-11-19 | Ciales | Puerto Rico | 72039 | 436 | |
744289 | 744289 | 2020-11-18 | Ciales | Puerto Rico | 72039 | 433 | |
741042 | 741042 | 2020-11-17 | Ciales | Puerto Rico | 72039 | 430 | |
737796 | 737796 | 2020-11-16 | Ciales | Puerto Rico | 72039 | 428 | |
734552 | 734552 | 2020-11-15 | Ciales | Puerto Rico | 72039 | 423 | |
731306 | 731306 | 2020-11-14 | Ciales | Puerto Rico | 72039 | 419 | |
728062 | 728062 | 2020-11-13 | Ciales | Puerto Rico | 72039 | 419 | |
724818 | 724818 | 2020-11-12 | Ciales | Puerto Rico | 72039 | 412 | |
721575 | 721575 | 2020-11-11 | Ciales | Puerto Rico | 72039 | 396 | |
718332 | 718332 | 2020-11-10 | Ciales | Puerto Rico | 72039 | 394 | |
715089 | 715089 | 2020-11-09 | Ciales | Puerto Rico | 72039 | 393 | |
711845 | 711845 | 2020-11-08 | Ciales | Puerto Rico | 72039 | 391 | |
708601 | 708601 | 2020-11-07 | Ciales | Puerto Rico | 72039 | 384 | |
705358 | 705358 | 2020-11-06 | Ciales | Puerto Rico | 72039 | 384 | |
702115 | 702115 | 2020-11-05 | Ciales | Puerto Rico | 72039 | 367 | |
698871 | 698871 | 2020-11-04 | Ciales | Puerto Rico | 72039 | 367 | |
695628 | 695628 | 2020-11-03 | Ciales | Puerto Rico | 72039 | 367 | |
692386 | 692386 | 2020-11-02 | Ciales | Puerto Rico | 72039 | 364 | |
689142 | 689142 | 2020-11-01 | Ciales | Puerto Rico | 72039 | 352 | |
685897 | 685897 | 2020-10-31 | Ciales | Puerto Rico | 72039 | 352 | |
682654 | 682654 | 2020-10-30 | Ciales | Puerto Rico | 72039 | 349 | |
679411 | 679411 | 2020-10-29 | Ciales | Puerto Rico | 72039 | 344 | |
676168 | 676168 | 2020-10-28 | Ciales | Puerto Rico | 72039 | 334 | |
672925 | 672925 | 2020-10-27 | Ciales | Puerto Rico | 72039 | 334 | |
669683 | 669683 | 2020-10-26 | Ciales | Puerto Rico | 72039 | 332 | |
666439 | 666439 | 2020-10-25 | Ciales | Puerto Rico | 72039 | 327 | |
663194 | 663194 | 2020-10-24 | Ciales | Puerto Rico | 72039 | 323 | |
659950 | 659950 | 2020-10-23 | Ciales | Puerto Rico | 72039 | 323 | |
656706 | 656706 | 2020-10-22 | Ciales | Puerto Rico | 72039 | 320 | |
653461 | 653461 | 2020-10-21 | Ciales | Puerto Rico | 72039 | 320 | |
650216 | 650216 | 2020-10-20 | Ciales | Puerto Rico | 72039 | 320 | |
646972 | 646972 | 2020-10-19 | Ciales | Puerto Rico | 72039 | 319 | |
643726 | 643726 | 2020-10-18 | Ciales | Puerto Rico | 72039 | 317 | |
640478 | 640478 | 2020-10-17 | Ciales | Puerto Rico | 72039 | 315 | |
637232 | 637232 | 2020-10-16 | Ciales | Puerto Rico | 72039 | 314 | |
633986 | 633986 | 2020-10-15 | Ciales | Puerto Rico | 72039 | 312 | |
630741 | 630741 | 2020-10-14 | Ciales | Puerto Rico | 72039 | 310 | |
627497 | 627497 | 2020-10-13 | Ciales | Puerto Rico | 72039 | 304 | |
624255 | 624255 | 2020-10-12 | Ciales | Puerto Rico | 72039 | 304 | |
621012 | 621012 | 2020-10-11 | Ciales | Puerto Rico | 72039 | 302 | |
617769 | 617769 | 2020-10-10 | Ciales | Puerto Rico | 72039 | 302 | |
614527 | 614527 | 2020-10-09 | Ciales | Puerto Rico | 72039 | 300 | |
611286 | 611286 | 2020-10-08 | Ciales | Puerto Rico | 72039 | 294 | |
608044 | 608044 | 2020-10-07 | Ciales | Puerto Rico | 72039 | 293 | |
604801 | 604801 | 2020-10-06 | Ciales | Puerto Rico | 72039 | 293 | |
601559 | 601559 | 2020-10-05 | Ciales | Puerto Rico | 72039 | 292 |
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);