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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- 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
- …
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);