ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58,397 rows where state = "Puerto Rico" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 79
- - 792
- 72001 739
- 72003 739
- 72005 739
- 72007 739
- 72009 739
- 72011 739
- 72013 739
- 72015 739
- 72017 739
- 72019 739
- 72021 739
- 72023 739
- 72025 739
- 72027 739
- 72029 739
- 72031 739
- 72033 739
- 72035 739
- 72037 739
- 72039 739
- 72041 739
- 72043 739
- 72045 739
- 72047 739
- 72051 739
- 72053 739
- 72054 739
- 72055 739
- 72057 739
- 72059 739
- 72061 739
- 72063 739
- 72065 739
- 72067 739
- 72069 739
- 72071 739
- 72073 739
- 72075 739
- 72077 739
- 72079 739
- 72081 739
- 72083 739
- 72085 739
- 72087 739
- 72089 739
- 72091 739
- 72095 739
- 72097 739
- 72099 739
- 72101 739
- 72103 739
- 72105 739
- 72107 739
- 72109 739
- 72111 739
- 72113 739
- 72115 739
- 72117 739
- 72119 739
- 72121 739
- 72123 739
- 72125 739
- 72127 739
- 72129 739
- 72131 739
- 72133 739
- 72135 739
- 72137 739
- 72139 739
- 72141 739
- 72143 739
- 72145 739
- 72149 739
- 72151 739
- 72153 739
- 72147 737
- 72093 728
- 72049 715
county 79
- Unknown 792
- Adjuntas 739
- Aguada 739
- Aguadilla 739
- Aguas Buenas 739
- Aibonito 739
- Anasco 739
- Arecibo 739
- Arroyo 739
- Barceloneta 739
- Barranquitas 739
- Bayamon 739
- Cabo Rojo 739
- Caguas 739
- Camuy 739
- Canovanas 739
- Carolina 739
- Catano 739
- Cayey 739
- Ceiba 739
- Ciales 739
- Cidra 739
- Coamo 739
- Comerio 739
- Corozal 739
- Dorado 739
- Fajardo 739
- Florida 739
- Guanica 739
- Guayama 739
- Guayanilla 739
- Guaynabo 739
- Gurabo 739
- Hatillo 739
- Hormigueros 739
- Humacao 739
- Isabela 739
- Jayuya 739
- Juana Diaz 739
- Juncos 739
- Lajas 739
- Lares 739
- Las Marias 739
- Las Piedras 739
- Loiza 739
- Luquillo 739
- Manati 739
- Maunabo 739
- Mayaguez 739
- Moca 739
- Morovis 739
- Naguabo 739
- Naranjito 739
- Orocovis 739
- Patillas 739
- Penuelas 739
- Ponce 739
- Quebradillas 739
- Rincon 739
- Rio Grande 739
- Sabana Grande 739
- Salinas 739
- San German 739
- San Juan 739
- San Lorenzo 739
- San Sebastian 739
- Santa Isabel 739
- Toa Alta 739
- Toa Baja 739
- Trujillo Alto 739
- Utuado 739
- Vega Alta 739
- Vega Baja 739
- Villalba 739
- Yabucoa 739
- Yauco 739
- Vieques 737
- Maricao 728
- Culebra 715
state 1
- Puerto Rico · 58,397 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1859 | 1859 | 2020-03-13 | Unknown | Puerto Rico | 3 | 0 | |
2221 | 2221 | 2020-03-14 | Unknown | Puerto Rico | 4 | 0 | |
2643 | 2643 | 2020-03-15 | Unknown | Puerto Rico | 5 | 0 | |
3108 | 3108 | 2020-03-16 | Unknown | Puerto Rico | 5 | 0 | |
3638 | 3638 | 2020-03-17 | Unknown | Puerto Rico | 5 | 0 | |
4257 | 4257 | 2020-03-18 | Unknown | Puerto Rico | 5 | 0 | |
4999 | 4999 | 2020-03-19 | Unknown | Puerto Rico | 6 | 0 | |
5872 | 5872 | 2020-03-20 | Unknown | Puerto Rico | 14 | 0 | |
6876 | 6876 | 2020-03-21 | Unknown | Puerto Rico | 21 | 1 | |
7996 | 7996 | 2020-03-22 | Unknown | Puerto Rico | 23 | 1 | |
9207 | 9207 | 2020-03-23 | Unknown | Puerto Rico | 31 | 2 | |
10532 | 10532 | 2020-03-24 | Unknown | Puerto Rico | 39 | 2 | |
11998 | 11998 | 2020-03-25 | Unknown | Puerto Rico | 51 | 2 | |
13620 | 13620 | 2020-03-26 | Unknown | Puerto Rico | 64 | 2 | |
15367 | 15367 | 2020-03-27 | Unknown | Puerto Rico | 79 | 3 | |
17221 | 17221 | 2020-03-28 | Unknown | Puerto Rico | 100 | 3 | |
19161 | 19161 | 2020-03-29 | Unknown | Puerto Rico | 127 | 5 | |
21212 | 21212 | 2020-03-30 | Unknown | Puerto Rico | 174 | 6 | |
23349 | 23349 | 2020-03-31 | Unknown | Puerto Rico | 239 | 8 | |
25546 | 25546 | 2020-04-01 | Unknown | Puerto Rico | 286 | 11 | |
27819 | 27819 | 2020-04-02 | Unknown | Puerto Rico | 316 | 12 | |
30154 | 30154 | 2020-04-03 | Unknown | Puerto Rico | 378 | 15 | |
32545 | 32545 | 2020-04-04 | Unknown | Puerto Rico | 452 | 18 | |
34981 | 34981 | 2020-04-05 | Unknown | Puerto Rico | 475 | 20 | |
37456 | 37456 | 2020-04-06 | Unknown | Puerto Rico | 513 | 21 | |
39979 | 39979 | 2020-04-07 | Unknown | Puerto Rico | 573 | 23 | |
42539 | 42539 | 2020-04-08 | Unknown | Puerto Rico | 620 | 24 | |
45125 | 45125 | 2020-04-09 | Unknown | Puerto Rico | 683 | 33 | |
47742 | 47742 | 2020-04-10 | Unknown | Puerto Rico | 725 | 39 | |
50399 | 50399 | 2020-04-11 | Unknown | Puerto Rico | 788 | 42 | |
53072 | 53072 | 2020-04-12 | Unknown | Puerto Rico | 897 | 44 | |
55757 | 55757 | 2020-04-13 | Unknown | Puerto Rico | 903 | 45 | |
58460 | 58460 | 2020-04-14 | Unknown | Puerto Rico | 923 | 45 | |
61175 | 61175 | 2020-04-15 | Unknown | Puerto Rico | 974 | 51 | |
63901 | 63901 | 2020-04-16 | Unknown | Puerto Rico | 1043 | 56 | |
66647 | 66647 | 2020-04-17 | Unknown | Puerto Rico | 1068 | 58 | |
69405 | 69405 | 2020-04-18 | Unknown | Puerto Rico | 1118 | 60 | |
72172 | 72172 | 2020-04-19 | Unknown | Puerto Rico | 1213 | 41 | |
74947 | 74947 | 2020-04-20 | Unknown | Puerto Rico | 1252 | 42 | |
77729 | 77729 | 2020-04-21 | Unknown | Puerto Rico | 915 | 43 | |
80519 | 80519 | 2020-04-22 | Unknown | Puerto Rico | 915 | 46 | |
83318 | 83318 | 2020-04-23 | Unknown | Puerto Rico | 1230 | 69 | |
86122 | 86122 | 2020-04-24 | Unknown | Puerto Rico | 1276 | 77 | |
88936 | 88936 | 2020-04-25 | Unknown | Puerto Rico | 1307 | 83 | |
91752 | 91752 | 2020-04-26 | Unknown | Puerto Rico | 1371 | 84 | |
94579 | 94579 | 2020-04-27 | Unknown | Puerto Rico | 1388 | 84 | |
97418 | 97418 | 2020-04-28 | Unknown | Puerto Rico | 1400 | 86 | |
100267 | 100267 | 2020-04-29 | Unknown | Puerto Rico | 1465 | 86 | |
103120 | 103120 | 2020-04-30 | Unknown | Puerto Rico | 1537 | 92 | |
105983 | 105983 | 2020-05-01 | Unknown | Puerto Rico | 1573 | 94 | |
108850 | 108850 | 2020-05-02 | Unknown | Puerto Rico | 1755 | 95 | |
111724 | 111724 | 2020-05-03 | Unknown | Puerto Rico | 1806 | 97 | |
114606 | 114606 | 2020-05-04 | Unknown | Puerto Rico | 1875 | 97 | |
117487 | 117487 | 2020-05-05 | Adjuntas | Puerto Rico | 72001 | 3 | |
117488 | 117488 | 2020-05-05 | Aguada | Puerto Rico | 72003 | 7 | |
117489 | 117489 | 2020-05-05 | Aguadilla | Puerto Rico | 72005 | 11 | |
117490 | 117490 | 2020-05-05 | Aguas Buenas | Puerto Rico | 72007 | 22 | |
117491 | 117491 | 2020-05-05 | Aibonito | Puerto Rico | 72009 | 13 | |
117492 | 117492 | 2020-05-05 | Anasco | Puerto Rico | 72011 | 5 | |
117493 | 117493 | 2020-05-05 | Arecibo | Puerto Rico | 72013 | 43 | |
117494 | 117494 | 2020-05-05 | Arroyo | Puerto Rico | 72015 | 5 | |
117495 | 117495 | 2020-05-05 | Barceloneta | Puerto Rico | 72017 | 3 | |
117496 | 117496 | 2020-05-05 | Barranquitas | Puerto Rico | 72019 | 15 | |
117497 | 117497 | 2020-05-05 | Bayamon | Puerto Rico | 72021 | 108 | |
117498 | 117498 | 2020-05-05 | Cabo Rojo | Puerto Rico | 72023 | 20 | |
117499 | 117499 | 2020-05-05 | Caguas | Puerto Rico | 72025 | 60 | |
117500 | 117500 | 2020-05-05 | Camuy | Puerto Rico | 72027 | 7 | |
117501 | 117501 | 2020-05-05 | Canovanas | Puerto Rico | 72029 | 32 | |
117502 | 117502 | 2020-05-05 | Carolina | Puerto Rico | 72031 | 87 | |
117503 | 117503 | 2020-05-05 | Catano | Puerto Rico | 72033 | 12 | |
117504 | 117504 | 2020-05-05 | Cayey | Puerto Rico | 72035 | 28 | |
117505 | 117505 | 2020-05-05 | Ceiba | Puerto Rico | 72037 | 8 | |
117506 | 117506 | 2020-05-05 | Ciales | Puerto Rico | 72039 | 7 | |
117507 | 117507 | 2020-05-05 | Cidra | Puerto Rico | 72041 | 26 | |
117508 | 117508 | 2020-05-05 | Coamo | Puerto Rico | 72043 | 4 | |
117509 | 117509 | 2020-05-05 | Comerio | Puerto Rico | 72045 | 9 | |
117510 | 117510 | 2020-05-05 | Corozal | Puerto Rico | 72047 | 18 | |
117511 | 117511 | 2020-05-05 | Dorado | Puerto Rico | 72051 | 35 | |
117512 | 117512 | 2020-05-05 | Fajardo | Puerto Rico | 72053 | 7 | |
117513 | 117513 | 2020-05-05 | Florida | Puerto Rico | 72054 | 4 | |
117514 | 117514 | 2020-05-05 | Guanica | Puerto Rico | 72055 | 16 | |
117515 | 117515 | 2020-05-05 | Guayama | Puerto Rico | 72057 | 10 | |
117516 | 117516 | 2020-05-05 | Guayanilla | Puerto Rico | 72059 | 10 | |
117517 | 117517 | 2020-05-05 | Guaynabo | Puerto Rico | 72061 | 106 | |
117518 | 117518 | 2020-05-05 | Gurabo | Puerto Rico | 72063 | 27 | |
117519 | 117519 | 2020-05-05 | Hatillo | Puerto Rico | 72065 | 8 | |
117520 | 117520 | 2020-05-05 | Hormigueros | Puerto Rico | 72067 | 11 | |
117521 | 117521 | 2020-05-05 | Humacao | Puerto Rico | 72069 | 23 | |
117522 | 117522 | 2020-05-05 | Isabela | Puerto Rico | 72071 | 13 | |
117523 | 117523 | 2020-05-05 | Jayuya | Puerto Rico | 72073 | 2 | |
117524 | 117524 | 2020-05-05 | Juana Diaz | Puerto Rico | 72075 | 30 | |
117525 | 117525 | 2020-05-05 | Juncos | Puerto Rico | 72077 | 13 | |
117526 | 117526 | 2020-05-05 | Lajas | Puerto Rico | 72079 | 8 | |
117527 | 117527 | 2020-05-05 | Lares | Puerto Rico | 72081 | 12 | |
117528 | 117528 | 2020-05-05 | Las Marias | Puerto Rico | 72083 | 5 | |
117529 | 117529 | 2020-05-05 | Las Piedras | Puerto Rico | 72085 | 12 | |
117530 | 117530 | 2020-05-05 | Loiza | Puerto Rico | 72087 | 6 | |
117531 | 117531 | 2020-05-05 | Luquillo | Puerto Rico | 72089 | 6 | |
117532 | 117532 | 2020-05-05 | Manati | Puerto Rico | 72091 | 13 | |
117533 | 117533 | 2020-05-05 | Maunabo | Puerto Rico | 72095 | 4 |
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);