ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72045 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 |
---|---|---|---|---|---|---|---|
922788 | 922788 | 2021-01-12 | Comerio | Puerto Rico | 72045 | 639 | |
919543 | 919543 | 2021-01-11 | Comerio | Puerto Rico | 72045 | 635 | |
916298 | 916298 | 2021-01-10 | Comerio | Puerto Rico | 72045 | 635 | |
913053 | 913053 | 2021-01-09 | Comerio | Puerto Rico | 72045 | 630 | |
909808 | 909808 | 2021-01-08 | Comerio | Puerto Rico | 72045 | 628 | |
906563 | 906563 | 2021-01-07 | Comerio | Puerto Rico | 72045 | 622 | |
903317 | 903317 | 2021-01-06 | Comerio | Puerto Rico | 72045 | 622 | |
900072 | 900072 | 2021-01-05 | Comerio | Puerto Rico | 72045 | 622 | |
896827 | 896827 | 2021-01-04 | Comerio | Puerto Rico | 72045 | 622 | |
893581 | 893581 | 2021-01-03 | Comerio | Puerto Rico | 72045 | 617 | |
890335 | 890335 | 2021-01-02 | Comerio | Puerto Rico | 72045 | 617 | |
887088 | 887088 | 2021-01-01 | Comerio | Puerto Rico | 72045 | 614 | |
883843 | 883843 | 2020-12-31 | Comerio | Puerto Rico | 72045 | 607 | |
880598 | 880598 | 2020-12-30 | Comerio | Puerto Rico | 72045 | 567 | |
877353 | 877353 | 2020-12-29 | Comerio | Puerto Rico | 72045 | 562 | |
874108 | 874108 | 2020-12-28 | Comerio | Puerto Rico | 72045 | 560 | |
870863 | 870863 | 2020-12-27 | Comerio | Puerto Rico | 72045 | 559 | |
867618 | 867618 | 2020-12-26 | Comerio | Puerto Rico | 72045 | 546 | |
864373 | 864373 | 2020-12-25 | Comerio | Puerto Rico | 72045 | 539 | |
861128 | 861128 | 2020-12-24 | Comerio | Puerto Rico | 72045 | 535 | |
857883 | 857883 | 2020-12-23 | Comerio | Puerto Rico | 72045 | 531 | |
854638 | 854638 | 2020-12-22 | Comerio | Puerto Rico | 72045 | 529 | |
851393 | 851393 | 2020-12-21 | Comerio | Puerto Rico | 72045 | 525 | |
848148 | 848148 | 2020-12-20 | Comerio | Puerto Rico | 72045 | 520 | |
844903 | 844903 | 2020-12-19 | Comerio | Puerto Rico | 72045 | 514 | |
841657 | 841657 | 2020-12-18 | Comerio | Puerto Rico | 72045 | 511 | |
838412 | 838412 | 2020-12-17 | Comerio | Puerto Rico | 72045 | 504 | |
835166 | 835166 | 2020-12-16 | Comerio | Puerto Rico | 72045 | 500 | |
831920 | 831920 | 2020-12-15 | Comerio | Puerto Rico | 72045 | 496 | |
828673 | 828673 | 2020-12-14 | Comerio | Puerto Rico | 72045 | 494 | |
825427 | 825427 | 2020-12-13 | Comerio | Puerto Rico | 72045 | 490 | |
822180 | 822180 | 2020-12-12 | Comerio | Puerto Rico | 72045 | 486 | |
818934 | 818934 | 2020-12-11 | Comerio | Puerto Rico | 72045 | 473 | |
815688 | 815688 | 2020-12-10 | Comerio | Puerto Rico | 72045 | 471 | |
812442 | 812442 | 2020-12-09 | Comerio | Puerto Rico | 72045 | 467 | |
809198 | 809198 | 2020-12-08 | Comerio | Puerto Rico | 72045 | 466 | |
805953 | 805953 | 2020-12-07 | Comerio | Puerto Rico | 72045 | 464 | |
802708 | 802708 | 2020-12-06 | Comerio | Puerto Rico | 72045 | 455 | |
799463 | 799463 | 2020-12-05 | Comerio | Puerto Rico | 72045 | 444 | |
796218 | 796218 | 2020-12-04 | Comerio | Puerto Rico | 72045 | 435 | |
792973 | 792973 | 2020-12-03 | Comerio | Puerto Rico | 72045 | 423 | |
789728 | 789728 | 2020-12-02 | Comerio | Puerto Rico | 72045 | 408 | |
786483 | 786483 | 2020-12-01 | Comerio | Puerto Rico | 72045 | 407 | |
783239 | 783239 | 2020-11-30 | Comerio | Puerto Rico | 72045 | 404 | |
779994 | 779994 | 2020-11-29 | Comerio | Puerto Rico | 72045 | 402 | |
776748 | 776748 | 2020-11-28 | Comerio | Puerto Rico | 72045 | 400 | |
773503 | 773503 | 2020-11-27 | Comerio | Puerto Rico | 72045 | 394 | |
770258 | 770258 | 2020-11-26 | Comerio | Puerto Rico | 72045 | 387 | |
767012 | 767012 | 2020-11-25 | Comerio | Puerto Rico | 72045 | 377 | |
763767 | 763767 | 2020-11-24 | Comerio | Puerto Rico | 72045 | 376 | |
760522 | 760522 | 2020-11-23 | Comerio | Puerto Rico | 72045 | 376 | |
757277 | 757277 | 2020-11-22 | Comerio | Puerto Rico | 72045 | 372 | |
754030 | 754030 | 2020-11-21 | Comerio | Puerto Rico | 72045 | 369 | |
750784 | 750784 | 2020-11-20 | Comerio | Puerto Rico | 72045 | 363 | |
747538 | 747538 | 2020-11-19 | Comerio | Puerto Rico | 72045 | 360 | |
744292 | 744292 | 2020-11-18 | Comerio | Puerto Rico | 72045 | 349 | |
741045 | 741045 | 2020-11-17 | Comerio | Puerto Rico | 72045 | 347 | |
737799 | 737799 | 2020-11-16 | Comerio | Puerto Rico | 72045 | 334 | |
734555 | 734555 | 2020-11-15 | Comerio | Puerto Rico | 72045 | 332 | |
731309 | 731309 | 2020-11-14 | Comerio | Puerto Rico | 72045 | 328 | |
728065 | 728065 | 2020-11-13 | Comerio | Puerto Rico | 72045 | 325 | |
724821 | 724821 | 2020-11-12 | Comerio | Puerto Rico | 72045 | 323 | |
721578 | 721578 | 2020-11-11 | Comerio | Puerto Rico | 72045 | 323 | |
718335 | 718335 | 2020-11-10 | Comerio | Puerto Rico | 72045 | 323 | |
715092 | 715092 | 2020-11-09 | Comerio | Puerto Rico | 72045 | 321 | |
711848 | 711848 | 2020-11-08 | Comerio | Puerto Rico | 72045 | 321 | |
708604 | 708604 | 2020-11-07 | Comerio | Puerto Rico | 72045 | 318 | |
705361 | 705361 | 2020-11-06 | Comerio | Puerto Rico | 72045 | 318 | |
702118 | 702118 | 2020-11-05 | Comerio | Puerto Rico | 72045 | 315 | |
698874 | 698874 | 2020-11-04 | Comerio | Puerto Rico | 72045 | 314 | |
695631 | 695631 | 2020-11-03 | Comerio | Puerto Rico | 72045 | 314 | |
692389 | 692389 | 2020-11-02 | Comerio | Puerto Rico | 72045 | 299 | |
689145 | 689145 | 2020-11-01 | Comerio | Puerto Rico | 72045 | 295 | |
685900 | 685900 | 2020-10-31 | Comerio | Puerto Rico | 72045 | 293 | |
682657 | 682657 | 2020-10-30 | Comerio | Puerto Rico | 72045 | 293 | |
679414 | 679414 | 2020-10-29 | Comerio | Puerto Rico | 72045 | 292 | |
676171 | 676171 | 2020-10-28 | Comerio | Puerto Rico | 72045 | 287 | |
672928 | 672928 | 2020-10-27 | Comerio | Puerto Rico | 72045 | 287 | |
669686 | 669686 | 2020-10-26 | Comerio | Puerto Rico | 72045 | 287 | |
666442 | 666442 | 2020-10-25 | Comerio | Puerto Rico | 72045 | 280 | |
663197 | 663197 | 2020-10-24 | Comerio | Puerto Rico | 72045 | 276 | |
659953 | 659953 | 2020-10-23 | Comerio | Puerto Rico | 72045 | 275 | |
656709 | 656709 | 2020-10-22 | Comerio | Puerto Rico | 72045 | 273 | |
653464 | 653464 | 2020-10-21 | Comerio | Puerto Rico | 72045 | 273 | |
650219 | 650219 | 2020-10-20 | Comerio | Puerto Rico | 72045 | 273 | |
646975 | 646975 | 2020-10-19 | Comerio | Puerto Rico | 72045 | 271 | |
643729 | 643729 | 2020-10-18 | Comerio | Puerto Rico | 72045 | 270 | |
640481 | 640481 | 2020-10-17 | Comerio | Puerto Rico | 72045 | 267 | |
637235 | 637235 | 2020-10-16 | Comerio | Puerto Rico | 72045 | 267 | |
633989 | 633989 | 2020-10-15 | Comerio | Puerto Rico | 72045 | 266 | |
630744 | 630744 | 2020-10-14 | Comerio | Puerto Rico | 72045 | 266 | |
627500 | 627500 | 2020-10-13 | Comerio | Puerto Rico | 72045 | 266 | |
624258 | 624258 | 2020-10-12 | Comerio | Puerto Rico | 72045 | 266 | |
621015 | 621015 | 2020-10-11 | Comerio | Puerto Rico | 72045 | 265 | |
617772 | 617772 | 2020-10-10 | Comerio | Puerto Rico | 72045 | 264 | |
614530 | 614530 | 2020-10-09 | Comerio | Puerto Rico | 72045 | 264 | |
611289 | 611289 | 2020-10-08 | Comerio | Puerto Rico | 72045 | 262 | |
608047 | 608047 | 2020-10-07 | Comerio | Puerto Rico | 72045 | 261 | |
604804 | 604804 | 2020-10-06 | Comerio | Puerto Rico | 72045 | 261 | |
601562 | 601562 | 2020-10-05 | Comerio | Puerto Rico | 72045 | 261 |
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);