ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Arroyo" 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 |
---|---|---|---|---|---|---|---|
922773 | 922773 | 2021-01-12 | Arroyo | Puerto Rico | 72015 | 321 | |
919528 | 919528 | 2021-01-11 | Arroyo | Puerto Rico | 72015 | 318 | |
916283 | 916283 | 2021-01-10 | Arroyo | Puerto Rico | 72015 | 317 | |
913038 | 913038 | 2021-01-09 | Arroyo | Puerto Rico | 72015 | 316 | |
909793 | 909793 | 2021-01-08 | Arroyo | Puerto Rico | 72015 | 315 | |
906548 | 906548 | 2021-01-07 | Arroyo | Puerto Rico | 72015 | 316 | |
903302 | 903302 | 2021-01-06 | Arroyo | Puerto Rico | 72015 | 316 | |
900057 | 900057 | 2021-01-05 | Arroyo | Puerto Rico | 72015 | 316 | |
896812 | 896812 | 2021-01-04 | Arroyo | Puerto Rico | 72015 | 316 | |
893566 | 893566 | 2021-01-03 | Arroyo | Puerto Rico | 72015 | 315 | |
890320 | 890320 | 2021-01-02 | Arroyo | Puerto Rico | 72015 | 315 | |
887073 | 887073 | 2021-01-01 | Arroyo | Puerto Rico | 72015 | 315 | |
883828 | 883828 | 2020-12-31 | Arroyo | Puerto Rico | 72015 | 309 | |
880583 | 880583 | 2020-12-30 | Arroyo | Puerto Rico | 72015 | 309 | |
877338 | 877338 | 2020-12-29 | Arroyo | Puerto Rico | 72015 | 309 | |
874093 | 874093 | 2020-12-28 | Arroyo | Puerto Rico | 72015 | 309 | |
870848 | 870848 | 2020-12-27 | Arroyo | Puerto Rico | 72015 | 309 | |
867603 | 867603 | 2020-12-26 | Arroyo | Puerto Rico | 72015 | 306 | |
864358 | 864358 | 2020-12-25 | Arroyo | Puerto Rico | 72015 | 303 | |
861113 | 861113 | 2020-12-24 | Arroyo | Puerto Rico | 72015 | 300 | |
857868 | 857868 | 2020-12-23 | Arroyo | Puerto Rico | 72015 | 300 | |
854623 | 854623 | 2020-12-22 | Arroyo | Puerto Rico | 72015 | 300 | |
851378 | 851378 | 2020-12-21 | Arroyo | Puerto Rico | 72015 | 297 | |
848133 | 848133 | 2020-12-20 | Arroyo | Puerto Rico | 72015 | 295 | |
844888 | 844888 | 2020-12-19 | Arroyo | Puerto Rico | 72015 | 290 | |
841642 | 841642 | 2020-12-18 | Arroyo | Puerto Rico | 72015 | 284 | |
838397 | 838397 | 2020-12-17 | Arroyo | Puerto Rico | 72015 | 281 | |
835151 | 835151 | 2020-12-16 | Arroyo | Puerto Rico | 72015 | 275 | |
831905 | 831905 | 2020-12-15 | Arroyo | Puerto Rico | 72015 | 275 | |
828658 | 828658 | 2020-12-14 | Arroyo | Puerto Rico | 72015 | 273 | |
825412 | 825412 | 2020-12-13 | Arroyo | Puerto Rico | 72015 | 270 | |
822165 | 822165 | 2020-12-12 | Arroyo | Puerto Rico | 72015 | 261 | |
818919 | 818919 | 2020-12-11 | Arroyo | Puerto Rico | 72015 | 261 | |
815673 | 815673 | 2020-12-10 | Arroyo | Puerto Rico | 72015 | 259 | |
812427 | 812427 | 2020-12-09 | Arroyo | Puerto Rico | 72015 | 259 | |
809183 | 809183 | 2020-12-08 | Arroyo | Puerto Rico | 72015 | 258 | |
805938 | 805938 | 2020-12-07 | Arroyo | Puerto Rico | 72015 | 258 | |
802693 | 802693 | 2020-12-06 | Arroyo | Puerto Rico | 72015 | 255 | |
799448 | 799448 | 2020-12-05 | Arroyo | Puerto Rico | 72015 | 248 | |
796203 | 796203 | 2020-12-04 | Arroyo | Puerto Rico | 72015 | 247 | |
792958 | 792958 | 2020-12-03 | Arroyo | Puerto Rico | 72015 | 246 | |
789713 | 789713 | 2020-12-02 | Arroyo | Puerto Rico | 72015 | 246 | |
786468 | 786468 | 2020-12-01 | Arroyo | Puerto Rico | 72015 | 246 | |
783224 | 783224 | 2020-11-30 | Arroyo | Puerto Rico | 72015 | 245 | |
779979 | 779979 | 2020-11-29 | Arroyo | Puerto Rico | 72015 | 242 | |
776733 | 776733 | 2020-11-28 | Arroyo | Puerto Rico | 72015 | 242 | |
773488 | 773488 | 2020-11-27 | Arroyo | Puerto Rico | 72015 | 242 | |
770243 | 770243 | 2020-11-26 | Arroyo | Puerto Rico | 72015 | 239 | |
766997 | 766997 | 2020-11-25 | Arroyo | Puerto Rico | 72015 | 239 | |
763752 | 763752 | 2020-11-24 | Arroyo | Puerto Rico | 72015 | 238 | |
760507 | 760507 | 2020-11-23 | Arroyo | Puerto Rico | 72015 | 237 | |
757262 | 757262 | 2020-11-22 | Arroyo | Puerto Rico | 72015 | 233 | |
754015 | 754015 | 2020-11-21 | Arroyo | Puerto Rico | 72015 | 232 | |
750769 | 750769 | 2020-11-20 | Arroyo | Puerto Rico | 72015 | 228 | |
747523 | 747523 | 2020-11-19 | Arroyo | Puerto Rico | 72015 | 227 | |
744277 | 744277 | 2020-11-18 | Arroyo | Puerto Rico | 72015 | 227 | |
741030 | 741030 | 2020-11-17 | Arroyo | Puerto Rico | 72015 | 227 | |
737784 | 737784 | 2020-11-16 | Arroyo | Puerto Rico | 72015 | 223 | |
734540 | 734540 | 2020-11-15 | Arroyo | Puerto Rico | 72015 | 222 | |
731294 | 731294 | 2020-11-14 | Arroyo | Puerto Rico | 72015 | 222 | |
728050 | 728050 | 2020-11-13 | Arroyo | Puerto Rico | 72015 | 222 | |
724806 | 724806 | 2020-11-12 | Arroyo | Puerto Rico | 72015 | 222 | |
721563 | 721563 | 2020-11-11 | Arroyo | Puerto Rico | 72015 | 220 | |
718320 | 718320 | 2020-11-10 | Arroyo | Puerto Rico | 72015 | 218 | |
715077 | 715077 | 2020-11-09 | Arroyo | Puerto Rico | 72015 | 215 | |
711833 | 711833 | 2020-11-08 | Arroyo | Puerto Rico | 72015 | 214 | |
708589 | 708589 | 2020-11-07 | Arroyo | Puerto Rico | 72015 | 213 | |
705346 | 705346 | 2020-11-06 | Arroyo | Puerto Rico | 72015 | 213 | |
702103 | 702103 | 2020-11-05 | Arroyo | Puerto Rico | 72015 | 213 | |
698859 | 698859 | 2020-11-04 | Arroyo | Puerto Rico | 72015 | 213 | |
695616 | 695616 | 2020-11-03 | Arroyo | Puerto Rico | 72015 | 213 | |
692374 | 692374 | 2020-11-02 | Arroyo | Puerto Rico | 72015 | 212 | |
689130 | 689130 | 2020-11-01 | Arroyo | Puerto Rico | 72015 | 205 | |
685885 | 685885 | 2020-10-31 | Arroyo | Puerto Rico | 72015 | 205 | |
682642 | 682642 | 2020-10-30 | Arroyo | Puerto Rico | 72015 | 205 | |
679399 | 679399 | 2020-10-29 | Arroyo | Puerto Rico | 72015 | 202 | |
676156 | 676156 | 2020-10-28 | Arroyo | Puerto Rico | 72015 | 201 | |
672913 | 672913 | 2020-10-27 | Arroyo | Puerto Rico | 72015 | 201 | |
669671 | 669671 | 2020-10-26 | Arroyo | Puerto Rico | 72015 | 201 | |
666427 | 666427 | 2020-10-25 | Arroyo | Puerto Rico | 72015 | 200 | |
663182 | 663182 | 2020-10-24 | Arroyo | Puerto Rico | 72015 | 195 | |
659938 | 659938 | 2020-10-23 | Arroyo | Puerto Rico | 72015 | 195 | |
656694 | 656694 | 2020-10-22 | Arroyo | Puerto Rico | 72015 | 193 | |
653449 | 653449 | 2020-10-21 | Arroyo | Puerto Rico | 72015 | 193 | |
650204 | 650204 | 2020-10-20 | Arroyo | Puerto Rico | 72015 | 193 | |
646960 | 646960 | 2020-10-19 | Arroyo | Puerto Rico | 72015 | 190 | |
643714 | 643714 | 2020-10-18 | Arroyo | Puerto Rico | 72015 | 190 | |
640466 | 640466 | 2020-10-17 | Arroyo | Puerto Rico | 72015 | 188 | |
637220 | 637220 | 2020-10-16 | Arroyo | Puerto Rico | 72015 | 187 | |
633974 | 633974 | 2020-10-15 | Arroyo | Puerto Rico | 72015 | 187 | |
630729 | 630729 | 2020-10-14 | Arroyo | Puerto Rico | 72015 | 186 | |
627485 | 627485 | 2020-10-13 | Arroyo | Puerto Rico | 72015 | 182 | |
624243 | 624243 | 2020-10-12 | Arroyo | Puerto Rico | 72015 | 182 | |
621000 | 621000 | 2020-10-11 | Arroyo | Puerto Rico | 72015 | 182 | |
617757 | 617757 | 2020-10-10 | Arroyo | Puerto Rico | 72015 | 181 | |
614515 | 614515 | 2020-10-09 | Arroyo | Puerto Rico | 72015 | 179 | |
611274 | 611274 | 2020-10-08 | Arroyo | Puerto Rico | 72015 | 178 | |
608032 | 608032 | 2020-10-07 | Arroyo | Puerto Rico | 72015 | 178 | |
604789 | 604789 | 2020-10-06 | Arroyo | Puerto Rico | 72015 | 178 | |
601547 | 601547 | 2020-10-05 | Arroyo | Puerto Rico | 72015 | 178 |
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);