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 |
---|---|---|---|---|---|---|---|
1062336 | 1062336 | 2021-02-24 | Bayamon | Puerto Rico | 72021 | 10063 | |
1059091 | 1059091 | 2021-02-23 | Bayamon | Puerto Rico | 72021 | 10057 | |
1055845 | 1055845 | 2021-02-22 | Bayamon | Puerto Rico | 72021 | 10044 | |
1052599 | 1052599 | 2021-02-21 | Bayamon | Puerto Rico | 72021 | 10030 | |
1049352 | 1049352 | 2021-02-20 | Bayamon | Puerto Rico | 72021 | 10020 | |
1046105 | 1046105 | 2021-02-19 | Bayamon | Puerto Rico | 72021 | 10010 | |
1042860 | 1042860 | 2021-02-18 | Bayamon | Puerto Rico | 72021 | 10004 | |
1039615 | 1039615 | 2021-02-17 | Bayamon | Puerto Rico | 72021 | 9996 | |
1036370 | 1036370 | 2021-02-16 | Bayamon | Puerto Rico | 72021 | 9991 | |
1033125 | 1033125 | 2021-02-15 | Bayamon | Puerto Rico | 72021 | 9889 | |
1029879 | 1029879 | 2021-02-14 | Bayamon | Puerto Rico | 72021 | 9869 | |
1026632 | 1026632 | 2021-02-13 | Bayamon | Puerto Rico | 72021 | 9853 | |
1023387 | 1023387 | 2021-02-12 | Bayamon | Puerto Rico | 72021 | 9825 | |
1020142 | 1020142 | 2021-02-11 | Bayamon | Puerto Rico | 72021 | 9807 | |
1016897 | 1016897 | 2021-02-10 | Bayamon | Puerto Rico | 72021 | 9792 | |
1013652 | 1013652 | 2021-02-09 | Bayamon | Puerto Rico | 72021 | 9783 | |
1010407 | 1010407 | 2021-02-08 | Bayamon | Puerto Rico | 72021 | 9771 | |
1007161 | 1007161 | 2021-02-07 | Bayamon | Puerto Rico | 72021 | 9745 | |
1003915 | 1003915 | 2021-02-06 | Bayamon | Puerto Rico | 72021 | 9720 | |
1000669 | 1000669 | 2021-02-05 | Bayamon | Puerto Rico | 72021 | 9704 | |
997423 | 997423 | 2021-02-04 | Bayamon | Puerto Rico | 72021 | 9694 | |
994177 | 994177 | 2021-02-03 | Bayamon | Puerto Rico | 72021 | 9665 | |
990931 | 990931 | 2021-02-02 | Bayamon | Puerto Rico | 72021 | 9659 | |
987685 | 987685 | 2021-02-01 | Bayamon | Puerto Rico | 72021 | 9650 | |
984438 | 984438 | 2021-01-31 | Bayamon | Puerto Rico | 72021 | 9600 | |
981191 | 981191 | 2021-01-30 | Bayamon | Puerto Rico | 72021 | 9585 | |
977945 | 977945 | 2021-01-29 | Bayamon | Puerto Rico | 72021 | 9555 | |
974700 | 974700 | 2021-01-28 | Bayamon | Puerto Rico | 72021 | 9534 | |
971455 | 971455 | 2021-01-27 | Bayamon | Puerto Rico | 72021 | 9515 | |
968210 | 968210 | 2021-01-26 | Bayamon | Puerto Rico | 72021 | 9501 | |
964966 | 964966 | 2021-01-25 | Bayamon | Puerto Rico | 72021 | 9405 | |
961721 | 961721 | 2021-01-24 | Bayamon | Puerto Rico | 72021 | 9364 | |
958476 | 958476 | 2021-01-23 | Bayamon | Puerto Rico | 72021 | 9282 | |
955230 | 955230 | 2021-01-22 | Bayamon | Puerto Rico | 72021 | 9226 | |
951985 | 951985 | 2021-01-21 | Bayamon | Puerto Rico | 72021 | 9119 | |
948740 | 948740 | 2021-01-20 | Bayamon | Puerto Rico | 72021 | 9108 | |
945494 | 945494 | 2021-01-19 | Bayamon | Puerto Rico | 72021 | 9096 | |
942247 | 942247 | 2021-01-18 | Bayamon | Puerto Rico | 72021 | 9064 | |
939002 | 939002 | 2021-01-17 | Bayamon | Puerto Rico | 72021 | 9017 | |
935757 | 935757 | 2021-01-16 | Bayamon | Puerto Rico | 72021 | 8953 | |
932512 | 932512 | 2021-01-15 | Bayamon | Puerto Rico | 72021 | 8907 | |
929267 | 929267 | 2021-01-14 | Bayamon | Puerto Rico | 72021 | 8840 | |
926022 | 926022 | 2021-01-13 | Bayamon | Puerto Rico | 72021 | 8826 | |
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 |
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);