ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Barceloneta" 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 |
---|---|---|---|---|---|---|---|
922774 | 922774 | 2021-01-12 | Barceloneta | Puerto Rico | 72017 | 631 | |
919529 | 919529 | 2021-01-11 | Barceloneta | Puerto Rico | 72017 | 630 | |
916284 | 916284 | 2021-01-10 | Barceloneta | Puerto Rico | 72017 | 630 | |
913039 | 913039 | 2021-01-09 | Barceloneta | Puerto Rico | 72017 | 629 | |
909794 | 909794 | 2021-01-08 | Barceloneta | Puerto Rico | 72017 | 624 | |
906549 | 906549 | 2021-01-07 | Barceloneta | Puerto Rico | 72017 | 622 | |
903303 | 903303 | 2021-01-06 | Barceloneta | Puerto Rico | 72017 | 622 | |
900058 | 900058 | 2021-01-05 | Barceloneta | Puerto Rico | 72017 | 620 | |
896813 | 896813 | 2021-01-04 | Barceloneta | Puerto Rico | 72017 | 616 | |
893567 | 893567 | 2021-01-03 | Barceloneta | Puerto Rico | 72017 | 614 | |
890321 | 890321 | 2021-01-02 | Barceloneta | Puerto Rico | 72017 | 614 | |
887074 | 887074 | 2021-01-01 | Barceloneta | Puerto Rico | 72017 | 612 | |
883829 | 883829 | 2020-12-31 | Barceloneta | Puerto Rico | 72017 | 607 | |
880584 | 880584 | 2020-12-30 | Barceloneta | Puerto Rico | 72017 | 603 | |
877339 | 877339 | 2020-12-29 | Barceloneta | Puerto Rico | 72017 | 603 | |
874094 | 874094 | 2020-12-28 | Barceloneta | Puerto Rico | 72017 | 598 | |
870849 | 870849 | 2020-12-27 | Barceloneta | Puerto Rico | 72017 | 598 | |
867604 | 867604 | 2020-12-26 | Barceloneta | Puerto Rico | 72017 | 597 | |
864359 | 864359 | 2020-12-25 | Barceloneta | Puerto Rico | 72017 | 591 | |
861114 | 861114 | 2020-12-24 | Barceloneta | Puerto Rico | 72017 | 585 | |
857869 | 857869 | 2020-12-23 | Barceloneta | Puerto Rico | 72017 | 584 | |
854624 | 854624 | 2020-12-22 | Barceloneta | Puerto Rico | 72017 | 583 | |
851379 | 851379 | 2020-12-21 | Barceloneta | Puerto Rico | 72017 | 578 | |
848134 | 848134 | 2020-12-20 | Barceloneta | Puerto Rico | 72017 | 578 | |
844889 | 844889 | 2020-12-19 | Barceloneta | Puerto Rico | 72017 | 575 | |
841643 | 841643 | 2020-12-18 | Barceloneta | Puerto Rico | 72017 | 568 | |
838398 | 838398 | 2020-12-17 | Barceloneta | Puerto Rico | 72017 | 552 | |
835152 | 835152 | 2020-12-16 | Barceloneta | Puerto Rico | 72017 | 544 | |
831906 | 831906 | 2020-12-15 | Barceloneta | Puerto Rico | 72017 | 543 | |
828659 | 828659 | 2020-12-14 | Barceloneta | Puerto Rico | 72017 | 537 | |
825413 | 825413 | 2020-12-13 | Barceloneta | Puerto Rico | 72017 | 536 | |
822166 | 822166 | 2020-12-12 | Barceloneta | Puerto Rico | 72017 | 534 | |
818920 | 818920 | 2020-12-11 | Barceloneta | Puerto Rico | 72017 | 528 | |
815674 | 815674 | 2020-12-10 | Barceloneta | Puerto Rico | 72017 | 508 | |
812428 | 812428 | 2020-12-09 | Barceloneta | Puerto Rico | 72017 | 505 | |
809184 | 809184 | 2020-12-08 | Barceloneta | Puerto Rico | 72017 | 500 | |
805939 | 805939 | 2020-12-07 | Barceloneta | Puerto Rico | 72017 | 494 | |
802694 | 802694 | 2020-12-06 | Barceloneta | Puerto Rico | 72017 | 480 | |
799449 | 799449 | 2020-12-05 | Barceloneta | Puerto Rico | 72017 | 471 | |
796204 | 796204 | 2020-12-04 | Barceloneta | Puerto Rico | 72017 | 471 | |
792959 | 792959 | 2020-12-03 | Barceloneta | Puerto Rico | 72017 | 466 | |
789714 | 789714 | 2020-12-02 | Barceloneta | Puerto Rico | 72017 | 464 | |
786469 | 786469 | 2020-12-01 | Barceloneta | Puerto Rico | 72017 | 463 | |
783225 | 783225 | 2020-11-30 | Barceloneta | Puerto Rico | 72017 | 458 | |
779980 | 779980 | 2020-11-29 | Barceloneta | Puerto Rico | 72017 | 455 | |
776734 | 776734 | 2020-11-28 | Barceloneta | Puerto Rico | 72017 | 454 | |
773489 | 773489 | 2020-11-27 | Barceloneta | Puerto Rico | 72017 | 450 | |
770244 | 770244 | 2020-11-26 | Barceloneta | Puerto Rico | 72017 | 441 | |
766998 | 766998 | 2020-11-25 | Barceloneta | Puerto Rico | 72017 | 440 | |
763753 | 763753 | 2020-11-24 | Barceloneta | Puerto Rico | 72017 | 432 | |
760508 | 760508 | 2020-11-23 | Barceloneta | Puerto Rico | 72017 | 427 | |
757263 | 757263 | 2020-11-22 | Barceloneta | Puerto Rico | 72017 | 422 | |
754016 | 754016 | 2020-11-21 | Barceloneta | Puerto Rico | 72017 | 415 | |
750770 | 750770 | 2020-11-20 | Barceloneta | Puerto Rico | 72017 | 408 | |
747524 | 747524 | 2020-11-19 | Barceloneta | Puerto Rico | 72017 | 397 | |
744278 | 744278 | 2020-11-18 | Barceloneta | Puerto Rico | 72017 | 394 | |
741031 | 741031 | 2020-11-17 | Barceloneta | Puerto Rico | 72017 | 393 | |
737785 | 737785 | 2020-11-16 | Barceloneta | Puerto Rico | 72017 | 392 | |
734541 | 734541 | 2020-11-15 | Barceloneta | Puerto Rico | 72017 | 390 | |
731295 | 731295 | 2020-11-14 | Barceloneta | Puerto Rico | 72017 | 384 | |
728051 | 728051 | 2020-11-13 | Barceloneta | Puerto Rico | 72017 | 380 | |
724807 | 724807 | 2020-11-12 | Barceloneta | Puerto Rico | 72017 | 376 | |
721564 | 721564 | 2020-11-11 | Barceloneta | Puerto Rico | 72017 | 366 | |
718321 | 718321 | 2020-11-10 | Barceloneta | Puerto Rico | 72017 | 366 | |
715078 | 715078 | 2020-11-09 | Barceloneta | Puerto Rico | 72017 | 366 | |
711834 | 711834 | 2020-11-08 | Barceloneta | Puerto Rico | 72017 | 364 | |
708590 | 708590 | 2020-11-07 | Barceloneta | Puerto Rico | 72017 | 358 | |
705347 | 705347 | 2020-11-06 | Barceloneta | Puerto Rico | 72017 | 358 | |
702104 | 702104 | 2020-11-05 | Barceloneta | Puerto Rico | 72017 | 344 | |
698860 | 698860 | 2020-11-04 | Barceloneta | Puerto Rico | 72017 | 343 | |
695617 | 695617 | 2020-11-03 | Barceloneta | Puerto Rico | 72017 | 343 | |
692375 | 692375 | 2020-11-02 | Barceloneta | Puerto Rico | 72017 | 334 | |
689131 | 689131 | 2020-11-01 | Barceloneta | Puerto Rico | 72017 | 325 | |
685886 | 685886 | 2020-10-31 | Barceloneta | Puerto Rico | 72017 | 322 | |
682643 | 682643 | 2020-10-30 | Barceloneta | Puerto Rico | 72017 | 322 | |
679400 | 679400 | 2020-10-29 | Barceloneta | Puerto Rico | 72017 | 320 | |
676157 | 676157 | 2020-10-28 | Barceloneta | Puerto Rico | 72017 | 314 | |
672914 | 672914 | 2020-10-27 | Barceloneta | Puerto Rico | 72017 | 314 | |
669672 | 669672 | 2020-10-26 | Barceloneta | Puerto Rico | 72017 | 312 | |
666428 | 666428 | 2020-10-25 | Barceloneta | Puerto Rico | 72017 | 307 | |
663183 | 663183 | 2020-10-24 | Barceloneta | Puerto Rico | 72017 | 306 | |
659939 | 659939 | 2020-10-23 | Barceloneta | Puerto Rico | 72017 | 306 | |
656695 | 656695 | 2020-10-22 | Barceloneta | Puerto Rico | 72017 | 301 | |
653450 | 653450 | 2020-10-21 | Barceloneta | Puerto Rico | 72017 | 301 | |
650205 | 650205 | 2020-10-20 | Barceloneta | Puerto Rico | 72017 | 301 | |
646961 | 646961 | 2020-10-19 | Barceloneta | Puerto Rico | 72017 | 299 | |
643715 | 643715 | 2020-10-18 | Barceloneta | Puerto Rico | 72017 | 297 | |
640467 | 640467 | 2020-10-17 | Barceloneta | Puerto Rico | 72017 | 297 | |
637221 | 637221 | 2020-10-16 | Barceloneta | Puerto Rico | 72017 | 297 | |
633975 | 633975 | 2020-10-15 | Barceloneta | Puerto Rico | 72017 | 292 | |
630730 | 630730 | 2020-10-14 | Barceloneta | Puerto Rico | 72017 | 288 | |
627486 | 627486 | 2020-10-13 | Barceloneta | Puerto Rico | 72017 | 282 | |
624244 | 624244 | 2020-10-12 | Barceloneta | Puerto Rico | 72017 | 280 | |
621001 | 621001 | 2020-10-11 | Barceloneta | Puerto Rico | 72017 | 280 | |
617758 | 617758 | 2020-10-10 | Barceloneta | Puerto Rico | 72017 | 279 | |
614516 | 614516 | 2020-10-09 | Barceloneta | Puerto Rico | 72017 | 279 | |
611275 | 611275 | 2020-10-08 | Barceloneta | Puerto Rico | 72017 | 277 | |
608033 | 608033 | 2020-10-07 | Barceloneta | Puerto Rico | 72017 | 275 | |
604790 | 604790 | 2020-10-06 | Barceloneta | Puerto Rico | 72017 | 275 | |
601548 | 601548 | 2020-10-05 | Barceloneta | Puerto Rico | 72017 | 270 |
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);