ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cidra" 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 |
---|---|---|---|---|---|---|---|
922786 | 922786 | 2021-01-12 | Cidra | Puerto Rico | 72041 | 1046 | |
919541 | 919541 | 2021-01-11 | Cidra | Puerto Rico | 72041 | 1030 | |
916296 | 916296 | 2021-01-10 | Cidra | Puerto Rico | 72041 | 1018 | |
913051 | 913051 | 2021-01-09 | Cidra | Puerto Rico | 72041 | 1009 | |
909806 | 909806 | 2021-01-08 | Cidra | Puerto Rico | 72041 | 1006 | |
906561 | 906561 | 2021-01-07 | Cidra | Puerto Rico | 72041 | 994 | |
903315 | 903315 | 2021-01-06 | Cidra | Puerto Rico | 72041 | 989 | |
900070 | 900070 | 2021-01-05 | Cidra | Puerto Rico | 72041 | 987 | |
896825 | 896825 | 2021-01-04 | Cidra | Puerto Rico | 72041 | 983 | |
893579 | 893579 | 2021-01-03 | Cidra | Puerto Rico | 72041 | 977 | |
890333 | 890333 | 2021-01-02 | Cidra | Puerto Rico | 72041 | 972 | |
887086 | 887086 | 2021-01-01 | Cidra | Puerto Rico | 72041 | 966 | |
883841 | 883841 | 2020-12-31 | Cidra | Puerto Rico | 72041 | 957 | |
880596 | 880596 | 2020-12-30 | Cidra | Puerto Rico | 72041 | 936 | |
877351 | 877351 | 2020-12-29 | Cidra | Puerto Rico | 72041 | 935 | |
874106 | 874106 | 2020-12-28 | Cidra | Puerto Rico | 72041 | 912 | |
870861 | 870861 | 2020-12-27 | Cidra | Puerto Rico | 72041 | 908 | |
867616 | 867616 | 2020-12-26 | Cidra | Puerto Rico | 72041 | 895 | |
864371 | 864371 | 2020-12-25 | Cidra | Puerto Rico | 72041 | 885 | |
861126 | 861126 | 2020-12-24 | Cidra | Puerto Rico | 72041 | 877 | |
857881 | 857881 | 2020-12-23 | Cidra | Puerto Rico | 72041 | 866 | |
854636 | 854636 | 2020-12-22 | Cidra | Puerto Rico | 72041 | 857 | |
851391 | 851391 | 2020-12-21 | Cidra | Puerto Rico | 72041 | 845 | |
848146 | 848146 | 2020-12-20 | Cidra | Puerto Rico | 72041 | 840 | |
844901 | 844901 | 2020-12-19 | Cidra | Puerto Rico | 72041 | 823 | |
841655 | 841655 | 2020-12-18 | Cidra | Puerto Rico | 72041 | 809 | |
838410 | 838410 | 2020-12-17 | Cidra | Puerto Rico | 72041 | 784 | |
835164 | 835164 | 2020-12-16 | Cidra | Puerto Rico | 72041 | 769 | |
831918 | 831918 | 2020-12-15 | Cidra | Puerto Rico | 72041 | 766 | |
828671 | 828671 | 2020-12-14 | Cidra | Puerto Rico | 72041 | 766 | |
825425 | 825425 | 2020-12-13 | Cidra | Puerto Rico | 72041 | 758 | |
822178 | 822178 | 2020-12-12 | Cidra | Puerto Rico | 72041 | 757 | |
818932 | 818932 | 2020-12-11 | Cidra | Puerto Rico | 72041 | 743 | |
815686 | 815686 | 2020-12-10 | Cidra | Puerto Rico | 72041 | 719 | |
812440 | 812440 | 2020-12-09 | Cidra | Puerto Rico | 72041 | 713 | |
809196 | 809196 | 2020-12-08 | Cidra | Puerto Rico | 72041 | 707 | |
805951 | 805951 | 2020-12-07 | Cidra | Puerto Rico | 72041 | 703 | |
802706 | 802706 | 2020-12-06 | Cidra | Puerto Rico | 72041 | 685 | |
799461 | 799461 | 2020-12-05 | Cidra | Puerto Rico | 72041 | 645 | |
796216 | 796216 | 2020-12-04 | Cidra | Puerto Rico | 72041 | 637 | |
792971 | 792971 | 2020-12-03 | Cidra | Puerto Rico | 72041 | 628 | |
789726 | 789726 | 2020-12-02 | Cidra | Puerto Rico | 72041 | 627 | |
786481 | 786481 | 2020-12-01 | Cidra | Puerto Rico | 72041 | 623 | |
783237 | 783237 | 2020-11-30 | Cidra | Puerto Rico | 72041 | 617 | |
779992 | 779992 | 2020-11-29 | Cidra | Puerto Rico | 72041 | 611 | |
776746 | 776746 | 2020-11-28 | Cidra | Puerto Rico | 72041 | 609 | |
773501 | 773501 | 2020-11-27 | Cidra | Puerto Rico | 72041 | 598 | |
770256 | 770256 | 2020-11-26 | Cidra | Puerto Rico | 72041 | 588 | |
767010 | 767010 | 2020-11-25 | Cidra | Puerto Rico | 72041 | 585 | |
763765 | 763765 | 2020-11-24 | Cidra | Puerto Rico | 72041 | 584 | |
760520 | 760520 | 2020-11-23 | Cidra | Puerto Rico | 72041 | 580 | |
757275 | 757275 | 2020-11-22 | Cidra | Puerto Rico | 72041 | 577 | |
754028 | 754028 | 2020-11-21 | Cidra | Puerto Rico | 72041 | 569 | |
750782 | 750782 | 2020-11-20 | Cidra | Puerto Rico | 72041 | 560 | |
747536 | 747536 | 2020-11-19 | Cidra | Puerto Rico | 72041 | 551 | |
744290 | 744290 | 2020-11-18 | Cidra | Puerto Rico | 72041 | 543 | |
741043 | 741043 | 2020-11-17 | Cidra | Puerto Rico | 72041 | 542 | |
737797 | 737797 | 2020-11-16 | Cidra | Puerto Rico | 72041 | 531 | |
734553 | 734553 | 2020-11-15 | Cidra | Puerto Rico | 72041 | 524 | |
731307 | 731307 | 2020-11-14 | Cidra | Puerto Rico | 72041 | 520 | |
728063 | 728063 | 2020-11-13 | Cidra | Puerto Rico | 72041 | 515 | |
724819 | 724819 | 2020-11-12 | Cidra | Puerto Rico | 72041 | 512 | |
721576 | 721576 | 2020-11-11 | Cidra | Puerto Rico | 72041 | 506 | |
718333 | 718333 | 2020-11-10 | Cidra | Puerto Rico | 72041 | 505 | |
715090 | 715090 | 2020-11-09 | Cidra | Puerto Rico | 72041 | 505 | |
711846 | 711846 | 2020-11-08 | Cidra | Puerto Rico | 72041 | 505 | |
708602 | 708602 | 2020-11-07 | Cidra | Puerto Rico | 72041 | 493 | |
705359 | 705359 | 2020-11-06 | Cidra | Puerto Rico | 72041 | 493 | |
702116 | 702116 | 2020-11-05 | Cidra | Puerto Rico | 72041 | 468 | |
698872 | 698872 | 2020-11-04 | Cidra | Puerto Rico | 72041 | 464 | |
695629 | 695629 | 2020-11-03 | Cidra | Puerto Rico | 72041 | 464 | |
692387 | 692387 | 2020-11-02 | Cidra | Puerto Rico | 72041 | 457 | |
689143 | 689143 | 2020-11-01 | Cidra | Puerto Rico | 72041 | 451 | |
685898 | 685898 | 2020-10-31 | Cidra | Puerto Rico | 72041 | 450 | |
682655 | 682655 | 2020-10-30 | Cidra | Puerto Rico | 72041 | 448 | |
679412 | 679412 | 2020-10-29 | Cidra | Puerto Rico | 72041 | 438 | |
676169 | 676169 | 2020-10-28 | Cidra | Puerto Rico | 72041 | 425 | |
672926 | 672926 | 2020-10-27 | Cidra | Puerto Rico | 72041 | 424 | |
669684 | 669684 | 2020-10-26 | Cidra | Puerto Rico | 72041 | 420 | |
666440 | 666440 | 2020-10-25 | Cidra | Puerto Rico | 72041 | 417 | |
663195 | 663195 | 2020-10-24 | Cidra | Puerto Rico | 72041 | 407 | |
659951 | 659951 | 2020-10-23 | Cidra | Puerto Rico | 72041 | 405 | |
656707 | 656707 | 2020-10-22 | Cidra | Puerto Rico | 72041 | 393 | |
653462 | 653462 | 2020-10-21 | Cidra | Puerto Rico | 72041 | 389 | |
650217 | 650217 | 2020-10-20 | Cidra | Puerto Rico | 72041 | 388 | |
646973 | 646973 | 2020-10-19 | Cidra | Puerto Rico | 72041 | 386 | |
643727 | 643727 | 2020-10-18 | Cidra | Puerto Rico | 72041 | 383 | |
640479 | 640479 | 2020-10-17 | Cidra | Puerto Rico | 72041 | 381 | |
637233 | 637233 | 2020-10-16 | Cidra | Puerto Rico | 72041 | 381 | |
633987 | 633987 | 2020-10-15 | Cidra | Puerto Rico | 72041 | 379 | |
630742 | 630742 | 2020-10-14 | Cidra | Puerto Rico | 72041 | 375 | |
627498 | 627498 | 2020-10-13 | Cidra | Puerto Rico | 72041 | 372 | |
624256 | 624256 | 2020-10-12 | Cidra | Puerto Rico | 72041 | 370 | |
621013 | 621013 | 2020-10-11 | Cidra | Puerto Rico | 72041 | 367 | |
617770 | 617770 | 2020-10-10 | Cidra | Puerto Rico | 72041 | 366 | |
614528 | 614528 | 2020-10-09 | Cidra | Puerto Rico | 72041 | 365 | |
611287 | 611287 | 2020-10-08 | Cidra | Puerto Rico | 72041 | 364 | |
608045 | 608045 | 2020-10-07 | Cidra | Puerto Rico | 72041 | 361 | |
604802 | 604802 | 2020-10-06 | Cidra | Puerto Rico | 72041 | 361 | |
601560 | 601560 | 2020-10-05 | Cidra | Puerto Rico | 72041 | 361 |
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);