ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Bayamon" 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 |
---|---|---|---|---|---|---|---|
922776 | 922776 | 2021-01-12 | Bayamon | Puerto Rico | 72021 | 8810 | |
919531 | 919531 | 2021-01-11 | Bayamon | Puerto Rico | 72021 | 8736 | |
916286 | 916286 | 2021-01-10 | Bayamon | Puerto Rico | 72021 | 8696 | |
913041 | 913041 | 2021-01-09 | Bayamon | Puerto Rico | 72021 | 8661 | |
909796 | 909796 | 2021-01-08 | Bayamon | Puerto Rico | 72021 | 8623 | |
906551 | 906551 | 2021-01-07 | Bayamon | Puerto Rico | 72021 | 8297 | |
903305 | 903305 | 2021-01-06 | Bayamon | Puerto Rico | 72021 | 8271 | |
900060 | 900060 | 2021-01-05 | Bayamon | Puerto Rico | 72021 | 8250 | |
896815 | 896815 | 2021-01-04 | Bayamon | Puerto Rico | 72021 | 8223 | |
893569 | 893569 | 2021-01-03 | Bayamon | Puerto Rico | 72021 | 8181 | |
890323 | 890323 | 2021-01-02 | Bayamon | Puerto Rico | 72021 | 8155 | |
887076 | 887076 | 2021-01-01 | Bayamon | Puerto Rico | 72021 | 8098 | |
883831 | 883831 | 2020-12-31 | Bayamon | Puerto Rico | 72021 | 8062 | |
880586 | 880586 | 2020-12-30 | Bayamon | Puerto Rico | 72021 | 8041 | |
877341 | 877341 | 2020-12-29 | Bayamon | Puerto Rico | 72021 | 8035 | |
874096 | 874096 | 2020-12-28 | Bayamon | Puerto Rico | 72021 | 7972 | |
870851 | 870851 | 2020-12-27 | Bayamon | Puerto Rico | 72021 | 7963 | |
867606 | 867606 | 2020-12-26 | Bayamon | Puerto Rico | 72021 | 7925 | |
864361 | 864361 | 2020-12-25 | Bayamon | Puerto Rico | 72021 | 7814 | |
861116 | 861116 | 2020-12-24 | Bayamon | Puerto Rico | 72021 | 7759 | |
857871 | 857871 | 2020-12-23 | Bayamon | Puerto Rico | 72021 | 7731 | |
854626 | 854626 | 2020-12-22 | Bayamon | Puerto Rico | 72021 | 7705 | |
851381 | 851381 | 2020-12-21 | Bayamon | Puerto Rico | 72021 | 7656 | |
848136 | 848136 | 2020-12-20 | Bayamon | Puerto Rico | 72021 | 7634 | |
844891 | 844891 | 2020-12-19 | Bayamon | Puerto Rico | 72021 | 7544 | |
841645 | 841645 | 2020-12-18 | Bayamon | Puerto Rico | 72021 | 7478 | |
838400 | 838400 | 2020-12-17 | Bayamon | Puerto Rico | 72021 | 7368 | |
835154 | 835154 | 2020-12-16 | Bayamon | Puerto Rico | 72021 | 7284 | |
831908 | 831908 | 2020-12-15 | Bayamon | Puerto Rico | 72021 | 7216 | |
828661 | 828661 | 2020-12-14 | Bayamon | Puerto Rico | 72021 | 7164 | |
825415 | 825415 | 2020-12-13 | Bayamon | Puerto Rico | 72021 | 7110 | |
822168 | 822168 | 2020-12-12 | Bayamon | Puerto Rico | 72021 | 7024 | |
818922 | 818922 | 2020-12-11 | Bayamon | Puerto Rico | 72021 | 6938 | |
815676 | 815676 | 2020-12-10 | Bayamon | Puerto Rico | 72021 | 6820 | |
812430 | 812430 | 2020-12-09 | Bayamon | Puerto Rico | 72021 | 6790 | |
809186 | 809186 | 2020-12-08 | Bayamon | Puerto Rico | 72021 | 6741 | |
805941 | 805941 | 2020-12-07 | Bayamon | Puerto Rico | 72021 | 6687 | |
802696 | 802696 | 2020-12-06 | Bayamon | Puerto Rico | 72021 | 6625 | |
799451 | 799451 | 2020-12-05 | Bayamon | Puerto Rico | 72021 | 6564 | |
796206 | 796206 | 2020-12-04 | Bayamon | Puerto Rico | 72021 | 6527 | |
792961 | 792961 | 2020-12-03 | Bayamon | Puerto Rico | 72021 | 6489 | |
789716 | 789716 | 2020-12-02 | Bayamon | Puerto Rico | 72021 | 6470 | |
786471 | 786471 | 2020-12-01 | Bayamon | Puerto Rico | 72021 | 6462 | |
783227 | 783227 | 2020-11-30 | Bayamon | Puerto Rico | 72021 | 6409 | |
779982 | 779982 | 2020-11-29 | Bayamon | Puerto Rico | 72021 | 6368 | |
776736 | 776736 | 2020-11-28 | Bayamon | Puerto Rico | 72021 | 6353 | |
773491 | 773491 | 2020-11-27 | Bayamon | Puerto Rico | 72021 | 6302 | |
770246 | 770246 | 2020-11-26 | Bayamon | Puerto Rico | 72021 | 6207 | |
767000 | 767000 | 2020-11-25 | Bayamon | Puerto Rico | 72021 | 6176 | |
763755 | 763755 | 2020-11-24 | Bayamon | Puerto Rico | 72021 | 6164 | |
760510 | 760510 | 2020-11-23 | Bayamon | Puerto Rico | 72021 | 6143 | |
757265 | 757265 | 2020-11-22 | Bayamon | Puerto Rico | 72021 | 6105 | |
754018 | 754018 | 2020-11-21 | Bayamon | Puerto Rico | 72021 | 6040 | |
750772 | 750772 | 2020-11-20 | Bayamon | Puerto Rico | 72021 | 5970 | |
747526 | 747526 | 2020-11-19 | Bayamon | Puerto Rico | 72021 | 5901 | |
744280 | 744280 | 2020-11-18 | Bayamon | Puerto Rico | 72021 | 5876 | |
741033 | 741033 | 2020-11-17 | Bayamon | Puerto Rico | 72021 | 5859 | |
737787 | 737787 | 2020-11-16 | Bayamon | Puerto Rico | 72021 | 5827 | |
734543 | 734543 | 2020-11-15 | Bayamon | Puerto Rico | 72021 | 5777 | |
731297 | 731297 | 2020-11-14 | Bayamon | Puerto Rico | 72021 | 5733 | |
728053 | 728053 | 2020-11-13 | Bayamon | Puerto Rico | 72021 | 5685 | |
724809 | 724809 | 2020-11-12 | Bayamon | Puerto Rico | 72021 | 5629 | |
721566 | 721566 | 2020-11-11 | Bayamon | Puerto Rico | 72021 | 5531 | |
718323 | 718323 | 2020-11-10 | Bayamon | Puerto Rico | 72021 | 5488 | |
715080 | 715080 | 2020-11-09 | Bayamon | Puerto Rico | 72021 | 5473 | |
711836 | 711836 | 2020-11-08 | Bayamon | Puerto Rico | 72021 | 5446 | |
708592 | 708592 | 2020-11-07 | Bayamon | Puerto Rico | 72021 | 5356 | |
705349 | 705349 | 2020-11-06 | Bayamon | Puerto Rico | 72021 | 5356 | |
702106 | 702106 | 2020-11-05 | Bayamon | Puerto Rico | 72021 | 5300 | |
698862 | 698862 | 2020-11-04 | Bayamon | Puerto Rico | 72021 | 5264 | |
695619 | 695619 | 2020-11-03 | Bayamon | Puerto Rico | 72021 | 5258 | |
692377 | 692377 | 2020-11-02 | Bayamon | Puerto Rico | 72021 | 5161 | |
689133 | 689133 | 2020-11-01 | Bayamon | Puerto Rico | 72021 | 5062 | |
685888 | 685888 | 2020-10-31 | Bayamon | Puerto Rico | 72021 | 5042 | |
682645 | 682645 | 2020-10-30 | Bayamon | Puerto Rico | 72021 | 5015 | |
679402 | 679402 | 2020-10-29 | Bayamon | Puerto Rico | 72021 | 4934 | |
676159 | 676159 | 2020-10-28 | Bayamon | Puerto Rico | 72021 | 4857 | |
672916 | 672916 | 2020-10-27 | Bayamon | Puerto Rico | 72021 | 4853 | |
669674 | 669674 | 2020-10-26 | Bayamon | Puerto Rico | 72021 | 4833 | |
666430 | 666430 | 2020-10-25 | Bayamon | Puerto Rico | 72021 | 4790 | |
663185 | 663185 | 2020-10-24 | Bayamon | Puerto Rico | 72021 | 4707 | |
659941 | 659941 | 2020-10-23 | Bayamon | Puerto Rico | 72021 | 4693 | |
656697 | 656697 | 2020-10-22 | Bayamon | Puerto Rico | 72021 | 4549 | |
653452 | 653452 | 2020-10-21 | Bayamon | Puerto Rico | 72021 | 4538 | |
650207 | 650207 | 2020-10-20 | Bayamon | Puerto Rico | 72021 | 4530 | |
646963 | 646963 | 2020-10-19 | Bayamon | Puerto Rico | 72021 | 4499 | |
643717 | 643717 | 2020-10-18 | Bayamon | Puerto Rico | 72021 | 4456 | |
640469 | 640469 | 2020-10-17 | Bayamon | Puerto Rico | 72021 | 4396 | |
637223 | 637223 | 2020-10-16 | Bayamon | Puerto Rico | 72021 | 4383 | |
633977 | 633977 | 2020-10-15 | Bayamon | Puerto Rico | 72021 | 4353 | |
630732 | 630732 | 2020-10-14 | Bayamon | Puerto Rico | 72021 | 4307 | |
627488 | 627488 | 2020-10-13 | Bayamon | Puerto Rico | 72021 | 4249 | |
624246 | 624246 | 2020-10-12 | Bayamon | Puerto Rico | 72021 | 4228 | |
621003 | 621003 | 2020-10-11 | Bayamon | Puerto Rico | 72021 | 4194 | |
617760 | 617760 | 2020-10-10 | Bayamon | Puerto Rico | 72021 | 4170 | |
614518 | 614518 | 2020-10-09 | Bayamon | Puerto Rico | 72021 | 4138 | |
611277 | 611277 | 2020-10-08 | Bayamon | Puerto Rico | 72021 | 4093 | |
608035 | 608035 | 2020-10-07 | Bayamon | Puerto Rico | 72021 | 4058 | |
604792 | 604792 | 2020-10-06 | Bayamon | Puerto Rico | 72021 | 4052 | |
601550 | 601550 | 2020-10-05 | Bayamon | Puerto Rico | 72021 | 4024 |
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);