ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guaynabo" 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 |
---|---|---|---|---|---|---|---|
1065602 | 1065602 | 2021-02-25 | Guaynabo | Puerto Rico | 72061 | 4365 | |
1062357 | 1062357 | 2021-02-24 | Guaynabo | Puerto Rico | 72061 | 4364 | |
1059112 | 1059112 | 2021-02-23 | Guaynabo | Puerto Rico | 72061 | 4361 | |
1055866 | 1055866 | 2021-02-22 | Guaynabo | Puerto Rico | 72061 | 4356 | |
1052620 | 1052620 | 2021-02-21 | Guaynabo | Puerto Rico | 72061 | 4353 | |
1049373 | 1049373 | 2021-02-20 | Guaynabo | Puerto Rico | 72061 | 4351 | |
1046126 | 1046126 | 2021-02-19 | Guaynabo | Puerto Rico | 72061 | 4344 | |
1042881 | 1042881 | 2021-02-18 | Guaynabo | Puerto Rico | 72061 | 4342 | |
1039636 | 1039636 | 2021-02-17 | Guaynabo | Puerto Rico | 72061 | 4341 | |
1036391 | 1036391 | 2021-02-16 | Guaynabo | Puerto Rico | 72061 | 4340 | |
1033146 | 1033146 | 2021-02-15 | Guaynabo | Puerto Rico | 72061 | 4321 | |
1029900 | 1029900 | 2021-02-14 | Guaynabo | Puerto Rico | 72061 | 4314 | |
1026653 | 1026653 | 2021-02-13 | Guaynabo | Puerto Rico | 72061 | 4303 | |
1023408 | 1023408 | 2021-02-12 | Guaynabo | Puerto Rico | 72061 | 4297 | |
1020163 | 1020163 | 2021-02-11 | Guaynabo | Puerto Rico | 72061 | 4288 | |
1016918 | 1016918 | 2021-02-10 | Guaynabo | Puerto Rico | 72061 | 4284 | |
1013673 | 1013673 | 2021-02-09 | Guaynabo | Puerto Rico | 72061 | 4282 | |
1010428 | 1010428 | 2021-02-08 | Guaynabo | Puerto Rico | 72061 | 4279 | |
1007182 | 1007182 | 2021-02-07 | Guaynabo | Puerto Rico | 72061 | 4273 | |
1003936 | 1003936 | 2021-02-06 | Guaynabo | Puerto Rico | 72061 | 4262 | |
1000690 | 1000690 | 2021-02-05 | Guaynabo | Puerto Rico | 72061 | 4255 | |
997444 | 997444 | 2021-02-04 | Guaynabo | Puerto Rico | 72061 | 4254 | |
994198 | 994198 | 2021-02-03 | Guaynabo | Puerto Rico | 72061 | 4240 | |
990952 | 990952 | 2021-02-02 | Guaynabo | Puerto Rico | 72061 | 4229 | |
987706 | 987706 | 2021-02-01 | Guaynabo | Puerto Rico | 72061 | 4212 | |
984459 | 984459 | 2021-01-31 | Guaynabo | Puerto Rico | 72061 | 4195 | |
981212 | 981212 | 2021-01-30 | Guaynabo | Puerto Rico | 72061 | 4191 | |
977966 | 977966 | 2021-01-29 | Guaynabo | Puerto Rico | 72061 | 4181 | |
974721 | 974721 | 2021-01-28 | Guaynabo | Puerto Rico | 72061 | 4164 | |
971476 | 971476 | 2021-01-27 | Guaynabo | Puerto Rico | 72061 | 4159 | |
968231 | 968231 | 2021-01-26 | Guaynabo | Puerto Rico | 72061 | 4147 | |
964987 | 964987 | 2021-01-25 | Guaynabo | Puerto Rico | 72061 | 4101 | |
961742 | 961742 | 2021-01-24 | Guaynabo | Puerto Rico | 72061 | 4089 | |
958497 | 958497 | 2021-01-23 | Guaynabo | Puerto Rico | 72061 | 4056 | |
955251 | 955251 | 2021-01-22 | Guaynabo | Puerto Rico | 72061 | 4033 | |
952006 | 952006 | 2021-01-21 | Guaynabo | Puerto Rico | 72061 | 4022 | |
948761 | 948761 | 2021-01-20 | Guaynabo | Puerto Rico | 72061 | 4011 | |
945515 | 945515 | 2021-01-19 | Guaynabo | Puerto Rico | 72061 | 4006 | |
942268 | 942268 | 2021-01-18 | Guaynabo | Puerto Rico | 72061 | 3987 | |
939023 | 939023 | 2021-01-17 | Guaynabo | Puerto Rico | 72061 | 3960 | |
935778 | 935778 | 2021-01-16 | Guaynabo | Puerto Rico | 72061 | 3929 | |
932533 | 932533 | 2021-01-15 | Guaynabo | Puerto Rico | 72061 | 3907 | |
929288 | 929288 | 2021-01-14 | Guaynabo | Puerto Rico | 72061 | 3860 | |
926043 | 926043 | 2021-01-13 | Guaynabo | Puerto Rico | 72061 | 3851 | |
922797 | 922797 | 2021-01-12 | Guaynabo | Puerto Rico | 72061 | 3849 | |
919552 | 919552 | 2021-01-11 | Guaynabo | Puerto Rico | 72061 | 3824 | |
916307 | 916307 | 2021-01-10 | Guaynabo | Puerto Rico | 72061 | 3812 | |
913062 | 913062 | 2021-01-09 | Guaynabo | Puerto Rico | 72061 | 3805 | |
909817 | 909817 | 2021-01-08 | Guaynabo | Puerto Rico | 72061 | 3789 | |
906572 | 906572 | 2021-01-07 | Guaynabo | Puerto Rico | 72061 | 3704 | |
903326 | 903326 | 2021-01-06 | Guaynabo | Puerto Rico | 72061 | 3692 | |
900081 | 900081 | 2021-01-05 | Guaynabo | Puerto Rico | 72061 | 3677 | |
896836 | 896836 | 2021-01-04 | Guaynabo | Puerto Rico | 72061 | 3664 | |
893590 | 893590 | 2021-01-03 | Guaynabo | Puerto Rico | 72061 | 3639 | |
890344 | 890344 | 2021-01-02 | Guaynabo | Puerto Rico | 72061 | 3636 | |
887097 | 887097 | 2021-01-01 | Guaynabo | Puerto Rico | 72061 | 3611 | |
883852 | 883852 | 2020-12-31 | Guaynabo | Puerto Rico | 72061 | 3589 | |
880607 | 880607 | 2020-12-30 | Guaynabo | Puerto Rico | 72061 | 3586 | |
877362 | 877362 | 2020-12-29 | Guaynabo | Puerto Rico | 72061 | 3585 | |
874117 | 874117 | 2020-12-28 | Guaynabo | Puerto Rico | 72061 | 3544 | |
870872 | 870872 | 2020-12-27 | Guaynabo | Puerto Rico | 72061 | 3540 | |
867627 | 867627 | 2020-12-26 | Guaynabo | Puerto Rico | 72061 | 3518 | |
864382 | 864382 | 2020-12-25 | Guaynabo | Puerto Rico | 72061 | 3472 | |
861137 | 861137 | 2020-12-24 | Guaynabo | Puerto Rico | 72061 | 3462 | |
857892 | 857892 | 2020-12-23 | Guaynabo | Puerto Rico | 72061 | 3453 | |
854647 | 854647 | 2020-12-22 | Guaynabo | Puerto Rico | 72061 | 3440 | |
851402 | 851402 | 2020-12-21 | Guaynabo | Puerto Rico | 72061 | 3409 | |
848157 | 848157 | 2020-12-20 | Guaynabo | Puerto Rico | 72061 | 3400 | |
844912 | 844912 | 2020-12-19 | Guaynabo | Puerto Rico | 72061 | 3373 | |
841666 | 841666 | 2020-12-18 | Guaynabo | Puerto Rico | 72061 | 3338 | |
838421 | 838421 | 2020-12-17 | Guaynabo | Puerto Rico | 72061 | 3303 | |
835175 | 835175 | 2020-12-16 | Guaynabo | Puerto Rico | 72061 | 3275 | |
831929 | 831929 | 2020-12-15 | Guaynabo | Puerto Rico | 72061 | 3267 | |
828682 | 828682 | 2020-12-14 | Guaynabo | Puerto Rico | 72061 | 3257 | |
825436 | 825436 | 2020-12-13 | Guaynabo | Puerto Rico | 72061 | 3242 | |
822189 | 822189 | 2020-12-12 | Guaynabo | Puerto Rico | 72061 | 3228 | |
818943 | 818943 | 2020-12-11 | Guaynabo | Puerto Rico | 72061 | 3210 | |
815697 | 815697 | 2020-12-10 | Guaynabo | Puerto Rico | 72061 | 3178 | |
812451 | 812451 | 2020-12-09 | Guaynabo | Puerto Rico | 72061 | 3167 | |
809207 | 809207 | 2020-12-08 | Guaynabo | Puerto Rico | 72061 | 3151 | |
805962 | 805962 | 2020-12-07 | Guaynabo | Puerto Rico | 72061 | 3142 | |
802717 | 802717 | 2020-12-06 | Guaynabo | Puerto Rico | 72061 | 3102 | |
799472 | 799472 | 2020-12-05 | Guaynabo | Puerto Rico | 72061 | 3070 | |
796227 | 796227 | 2020-12-04 | Guaynabo | Puerto Rico | 72061 | 3041 | |
792982 | 792982 | 2020-12-03 | Guaynabo | Puerto Rico | 72061 | 3030 | |
789737 | 789737 | 2020-12-02 | Guaynabo | Puerto Rico | 72061 | 3020 | |
786492 | 786492 | 2020-12-01 | Guaynabo | Puerto Rico | 72061 | 3010 | |
783248 | 783248 | 2020-11-30 | Guaynabo | Puerto Rico | 72061 | 2975 | |
780003 | 780003 | 2020-11-29 | Guaynabo | Puerto Rico | 72061 | 2941 | |
776757 | 776757 | 2020-11-28 | Guaynabo | Puerto Rico | 72061 | 2937 | |
773512 | 773512 | 2020-11-27 | Guaynabo | Puerto Rico | 72061 | 2909 | |
770267 | 770267 | 2020-11-26 | Guaynabo | Puerto Rico | 72061 | 2852 | |
767021 | 767021 | 2020-11-25 | Guaynabo | Puerto Rico | 72061 | 2845 | |
763776 | 763776 | 2020-11-24 | Guaynabo | Puerto Rico | 72061 | 2843 | |
760531 | 760531 | 2020-11-23 | Guaynabo | Puerto Rico | 72061 | 2838 | |
757286 | 757286 | 2020-11-22 | Guaynabo | Puerto Rico | 72061 | 2801 | |
754039 | 754039 | 2020-11-21 | Guaynabo | Puerto Rico | 72061 | 2786 | |
750793 | 750793 | 2020-11-20 | Guaynabo | Puerto Rico | 72061 | 2745 | |
747547 | 747547 | 2020-11-19 | Guaynabo | Puerto Rico | 72061 | 2722 | |
744301 | 744301 | 2020-11-18 | Guaynabo | Puerto Rico | 72061 | 2708 |
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);