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 |
---|---|---|---|---|---|---|---|
1195449 | 1195449 | 2021-04-06 | Bayamon | Puerto Rico | 72021 | 10719 | |
1192201 | 1192201 | 2021-04-05 | Bayamon | Puerto Rico | 72021 | 10707 | |
1188952 | 1188952 | 2021-04-04 | Bayamon | Puerto Rico | 72021 | 10682 | |
1185705 | 1185705 | 2021-04-03 | Bayamon | Puerto Rico | 72021 | 10626 | |
1182458 | 1182458 | 2021-04-02 | Bayamon | Puerto Rico | 72021 | 10559 | |
1179211 | 1179211 | 2021-04-01 | Bayamon | Puerto Rico | 72021 | 10523 | |
1175964 | 1175964 | 2021-03-31 | Bayamon | Puerto Rico | 72021 | 10502 | |
1172717 | 1172717 | 2021-03-30 | Bayamon | Puerto Rico | 72021 | 10493 | |
1169470 | 1169470 | 2021-03-29 | Bayamon | Puerto Rico | 72021 | 10473 | |
1166222 | 1166222 | 2021-03-28 | Bayamon | Puerto Rico | 72021 | 10454 | |
1162974 | 1162974 | 2021-03-27 | Bayamon | Puerto Rico | 72021 | 10437 | |
1159725 | 1159725 | 2021-03-26 | Bayamon | Puerto Rico | 72021 | 10408 | |
1156478 | 1156478 | 2021-03-25 | Bayamon | Puerto Rico | 72021 | 10392 | |
1153231 | 1153231 | 2021-03-24 | Bayamon | Puerto Rico | 72021 | 10387 | |
1149984 | 1149984 | 2021-03-23 | Bayamon | Puerto Rico | 72021 | 10378 | |
1146737 | 1146737 | 2021-03-22 | Bayamon | Puerto Rico | 72021 | 10365 | |
1143490 | 1143490 | 2021-03-21 | Bayamon | Puerto Rico | 72021 | 10345 | |
1140243 | 1140243 | 2021-03-20 | Bayamon | Puerto Rico | 72021 | 10333 | |
1136997 | 1136997 | 2021-03-19 | Bayamon | Puerto Rico | 72021 | 10313 | |
1133751 | 1133751 | 2021-03-18 | Bayamon | Puerto Rico | 72021 | 10287 | |
1130503 | 1130503 | 2021-03-17 | Bayamon | Puerto Rico | 72021 | 10281 | |
1127256 | 1127256 | 2021-03-16 | Bayamon | Puerto Rico | 72021 | 10277 | |
1124010 | 1124010 | 2021-03-15 | Bayamon | Puerto Rico | 72021 | 10265 | |
1120764 | 1120764 | 2021-03-14 | Bayamon | Puerto Rico | 72021 | 10241 | |
1117517 | 1117517 | 2021-03-13 | Bayamon | Puerto Rico | 72021 | 10231 | |
1114270 | 1114270 | 2021-03-12 | Bayamon | Puerto Rico | 72021 | 10221 | |
1111024 | 1111024 | 2021-03-11 | Bayamon | Puerto Rico | 72021 | 10207 | |
1107778 | 1107778 | 2021-03-10 | Bayamon | Puerto Rico | 72021 | 10202 | |
1104532 | 1104532 | 2021-03-09 | Bayamon | Puerto Rico | 72021 | 10202 | |
1101286 | 1101286 | 2021-03-08 | Bayamon | Puerto Rico | 72021 | 10190 | |
1098040 | 1098040 | 2021-03-07 | Bayamon | Puerto Rico | 72021 | 10176 | |
1094792 | 1094792 | 2021-03-06 | Bayamon | Puerto Rico | 72021 | 10176 | |
1091546 | 1091546 | 2021-03-05 | Bayamon | Puerto Rico | 72021 | 10158 | |
1088300 | 1088300 | 2021-03-04 | Bayamon | Puerto Rico | 72021 | 10147 | |
1085055 | 1085055 | 2021-03-03 | Bayamon | Puerto Rico | 72021 | 10140 | |
1081809 | 1081809 | 2021-03-02 | Bayamon | Puerto Rico | 72021 | 10136 | |
1078563 | 1078563 | 2021-03-01 | Bayamon | Puerto Rico | 72021 | 10131 | |
1075318 | 1075318 | 2021-02-28 | Bayamon | Puerto Rico | 72021 | 10104 | |
1072072 | 1072072 | 2021-02-27 | Bayamon | Puerto Rico | 72021 | 10088 | |
1068826 | 1068826 | 2021-02-26 | Bayamon | Puerto Rico | 72021 | 10079 | |
1065581 | 1065581 | 2021-02-25 | Bayamon | Puerto Rico | 72021 | 10069 | |
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 |
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);