ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,022 rows where state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
state 1
- Puerto Rico · 1,022 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
57225 | 57225 | 2022-12-29 | Puerto Rico | 72 | 1084004 | 5530 |
57169 | 57169 | 2022-12-28 | Puerto Rico | 72 | 1082619 | 5519 |
57113 | 57113 | 2022-12-27 | Puerto Rico | 72 | 1081824 | 5509 |
57057 | 57057 | 2022-12-26 | Puerto Rico | 72 | 1079676 | 5506 |
57001 | 57001 | 2022-12-25 | Puerto Rico | 72 | 1079676 | 5506 |
56945 | 56945 | 2022-12-24 | Puerto Rico | 72 | 1079676 | 5506 |
56889 | 56889 | 2022-12-23 | Puerto Rico | 72 | 1078239 | 5502 |
56833 | 56833 | 2022-12-22 | Puerto Rico | 72 | 1076489 | 5499 |
56777 | 56777 | 2022-12-21 | Puerto Rico | 72 | 1073967 | 5490 |
56721 | 56721 | 2022-12-20 | Puerto Rico | 72 | 1072947 | 5485 |
56665 | 56665 | 2022-12-19 | Puerto Rico | 72 | 1072521 | 5473 |
56609 | 56609 | 2022-12-18 | Puerto Rico | 72 | 1071656 | 5473 |
56553 | 56553 | 2022-12-17 | Puerto Rico | 72 | 1069640 | 5473 |
56497 | 56497 | 2022-12-16 | Puerto Rico | 72 | 1068275 | 5466 |
56441 | 56441 | 2022-12-15 | Puerto Rico | 72 | 1066412 | 5463 |
56385 | 56385 | 2022-12-14 | Puerto Rico | 72 | 1064137 | 5455 |
56329 | 56329 | 2022-12-13 | Puerto Rico | 72 | 1062541 | 5449 |
56273 | 56273 | 2022-12-12 | Puerto Rico | 72 | 1062311 | 5442 |
56217 | 56217 | 2022-12-11 | Puerto Rico | 72 | 1061375 | 5442 |
56161 | 56161 | 2022-12-10 | Puerto Rico | 72 | 1059878 | 5442 |
56105 | 56105 | 2022-12-09 | Puerto Rico | 72 | 1058197 | 5433 |
56049 | 56049 | 2022-12-08 | Puerto Rico | 72 | 1056381 | 5423 |
55993 | 55993 | 2022-12-07 | Puerto Rico | 72 | 1054328 | 5413 |
55937 | 55937 | 2022-12-06 | Puerto Rico | 72 | 1053084 | 5407 |
55881 | 55881 | 2022-12-05 | Puerto Rico | 72 | 1052674 | 5391 |
55825 | 55825 | 2022-12-04 | Puerto Rico | 72 | 1051812 | 5391 |
55769 | 55769 | 2022-12-03 | Puerto Rico | 72 | 1050134 | 5391 |
55713 | 55713 | 2022-12-02 | Puerto Rico | 72 | 1048678 | 5383 |
55657 | 55657 | 2022-12-01 | Puerto Rico | 72 | 1044308 | 5376 |
55601 | 55601 | 2022-11-30 | Puerto Rico | 72 | 1044308 | 5367 |
55545 | 55545 | 2022-11-29 | Puerto Rico | 72 | 1041979 | 5361 |
55489 | 55489 | 2022-11-28 | Puerto Rico | 72 | 1041285 | 5352 |
55433 | 55433 | 2022-11-27 | Puerto Rico | 72 | 1041285 | 5351 |
55377 | 55377 | 2022-11-26 | Puerto Rico | 72 | 1039249 | 5351 |
55321 | 55321 | 2022-11-25 | Puerto Rico | 72 | 1039249 | 5350 |
55265 | 55265 | 2022-11-24 | Puerto Rico | 72 | 1039249 | 5350 |
55209 | 55209 | 2022-11-23 | Puerto Rico | 72 | 1037854 | 5337 |
55153 | 55153 | 2022-11-22 | Puerto Rico | 72 | 1036848 | 5330 |
55097 | 55097 | 2022-11-21 | Puerto Rico | 72 | 1035696 | 5322 |
55041 | 55041 | 2022-11-20 | Puerto Rico | 72 | 1035696 | 5320 |
54985 | 54985 | 2022-11-19 | Puerto Rico | 72 | 1034576 | 5320 |
54929 | 54929 | 2022-11-18 | Puerto Rico | 72 | 1033260 | 5312 |
54873 | 54873 | 2022-11-17 | Puerto Rico | 72 | 1030064 | 5309 |
54817 | 54817 | 2022-11-16 | Puerto Rico | 72 | 1030064 | 5305 |
54761 | 54761 | 2022-11-15 | Puerto Rico | 72 | 1028205 | 5301 |
54705 | 54705 | 2022-11-14 | Puerto Rico | 72 | 1028205 | 5297 |
54649 | 54649 | 2022-11-13 | Puerto Rico | 72 | 1027178 | 5297 |
54593 | 54593 | 2022-11-12 | Puerto Rico | 72 | 1027178 | 5296 |
54537 | 54537 | 2022-11-11 | Puerto Rico | 72 | 1026370 | 5294 |
54481 | 54481 | 2022-11-10 | Puerto Rico | 72 | 1025083 | 5291 |
54425 | 54425 | 2022-11-09 | Puerto Rico | 72 | 1023547 | 5285 |
54369 | 54369 | 2022-11-08 | Puerto Rico | 72 | 1022644 | 5280 |
54313 | 54313 | 2022-11-07 | Puerto Rico | 72 | 1022241 | 5279 |
54257 | 54257 | 2022-11-06 | Puerto Rico | 72 | 1021642 | 5279 |
54201 | 54201 | 2022-11-05 | Puerto Rico | 72 | 1020681 | 5276 |
54145 | 54145 | 2022-11-04 | Puerto Rico | 72 | 1019369 | 5273 |
54089 | 54089 | 2022-11-03 | Puerto Rico | 72 | 1018156 | 5268 |
54033 | 54033 | 2022-11-02 | Puerto Rico | 72 | 1016756 | 5265 |
53977 | 53977 | 2022-11-01 | Puerto Rico | 72 | 1015553 | 5262 |
53921 | 53921 | 2022-10-31 | Puerto Rico | 72 | 1015553 | 5260 |
53865 | 53865 | 2022-10-30 | Puerto Rico | 72 | 1014746 | 5259 |
53809 | 53809 | 2022-10-29 | Puerto Rico | 72 | 1013857 | 5257 |
53753 | 53753 | 2022-10-28 | Puerto Rico | 72 | 1012950 | 5252 |
53697 | 53697 | 2022-10-27 | Puerto Rico | 72 | 1011753 | 5248 |
53641 | 53641 | 2022-10-26 | Puerto Rico | 72 | 1010338 | 5243 |
53585 | 53585 | 2022-10-25 | Puerto Rico | 72 | 1009359 | 5241 |
53529 | 53529 | 2022-10-24 | Puerto Rico | 72 | 1008950 | 5234 |
53473 | 53473 | 2022-10-23 | Puerto Rico | 72 | 1008321 | 5233 |
53417 | 53417 | 2022-10-22 | Puerto Rico | 72 | 1003619 | 5232 |
53361 | 53361 | 2022-10-21 | Puerto Rico | 72 | 1003619 | 5232 |
53305 | 53305 | 2022-10-20 | Puerto Rico | 72 | 1003619 | 5229 |
53249 | 53249 | 2022-10-19 | Puerto Rico | 72 | 1003619 | 5220 |
53193 | 53193 | 2022-10-18 | Puerto Rico | 72 | 1002681 | 5217 |
53137 | 53137 | 2022-10-17 | Puerto Rico | 72 | 1002522 | 5212 |
53081 | 53081 | 2022-10-16 | Puerto Rico | 72 | 1002048 | 5212 |
53025 | 53025 | 2022-10-15 | Puerto Rico | 72 | 1000112 | 5211 |
52969 | 52969 | 2022-10-14 | Puerto Rico | 72 | 1000112 | 5206 |
52913 | 52913 | 2022-10-13 | Puerto Rico | 72 | 999011 | 5206 |
52857 | 52857 | 2022-10-12 | Puerto Rico | 72 | 998050 | 5193 |
52801 | 52801 | 2022-10-11 | Puerto Rico | 72 | 997431 | 5189 |
52745 | 52745 | 2022-10-10 | Puerto Rico | 72 | 997185 | 5183 |
52689 | 52689 | 2022-10-09 | Puerto Rico | 72 | 996707 | 5183 |
52633 | 52633 | 2022-10-08 | Puerto Rico | 72 | 995948 | 5181 |
52577 | 52577 | 2022-10-07 | Puerto Rico | 72 | 995128 | 5175 |
52521 | 52521 | 2022-10-06 | Puerto Rico | 72 | 994339 | 5174 |
52465 | 52465 | 2022-10-05 | Puerto Rico | 72 | 993360 | 5167 |
52409 | 52409 | 2022-10-04 | Puerto Rico | 72 | 992662 | 5157 |
52353 | 52353 | 2022-10-03 | Puerto Rico | 72 | 992391 | 5155 |
52297 | 52297 | 2022-10-02 | Puerto Rico | 72 | 991953 | 5154 |
52241 | 52241 | 2022-10-01 | Puerto Rico | 72 | 991269 | 5154 |
52185 | 52185 | 2022-09-30 | Puerto Rico | 72 | 990505 | 5152 |
52129 | 52129 | 2022-09-29 | Puerto Rico | 72 | 989508 | 5133 |
52073 | 52073 | 2022-09-28 | Puerto Rico | 72 | 985993 | 5129 |
52017 | 52017 | 2022-09-27 | Puerto Rico | 72 | 985369 | 5125 |
51961 | 51961 | 2022-09-26 | Puerto Rico | 72 | 985305 | 5118 |
51905 | 51905 | 2022-09-25 | Puerto Rico | 72 | 984792 | 5118 |
51849 | 51849 | 2022-09-24 | Puerto Rico | 72 | 983686 | 5112 |
51793 | 51793 | 2022-09-23 | Puerto Rico | 72 | 981930 | 5104 |
51737 | 51737 | 2022-09-22 | Puerto Rico | 72 | 981667 | 5095 |
51681 | 51681 | 2022-09-21 | Puerto Rico | 72 | 981287 | 5085 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );