ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 162 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 |
---|---|---|---|---|---|---|---|
2378201 | 2378201 | 2022-04-05 | Culebra | Puerto Rico | 72049 | 162 | |
2374947 | 2374947 | 2022-04-04 | Culebra | Puerto Rico | 72049 | 162 | |
2371695 | 2371695 | 2022-04-03 | Culebra | Puerto Rico | 72049 | 162 | |
2368442 | 2368442 | 2022-04-02 | Culebra | Puerto Rico | 72049 | 162 | |
2365189 | 2365189 | 2022-04-01 | Culebra | Puerto Rico | 72049 | 162 | |
2361936 | 2361936 | 2022-03-31 | Culebra | Puerto Rico | 72049 | 162 | |
2358682 | 2358682 | 2022-03-30 | Culebra | Puerto Rico | 72049 | 162 | |
2355428 | 2355428 | 2022-03-29 | Culebra | Puerto Rico | 72049 | 162 | |
2352175 | 2352175 | 2022-03-28 | Culebra | Puerto Rico | 72049 | 162 | |
2348923 | 2348923 | 2022-03-27 | Culebra | Puerto Rico | 72049 | 162 | |
2345670 | 2345670 | 2022-03-26 | Culebra | Puerto Rico | 72049 | 162 | |
2342417 | 2342417 | 2022-03-25 | Culebra | Puerto Rico | 72049 | 162 | |
2339164 | 2339164 | 2022-03-24 | Culebra | Puerto Rico | 72049 | 162 | |
2335910 | 2335910 | 2022-03-23 | Culebra | Puerto Rico | 72049 | 162 | |
2332656 | 2332656 | 2022-03-22 | Culebra | Puerto Rico | 72049 | 162 | |
2329403 | 2329403 | 2022-03-21 | Culebra | Puerto Rico | 72049 | 162 | |
2326151 | 2326151 | 2022-03-20 | Culebra | Puerto Rico | 72049 | 162 | |
2322898 | 2322898 | 2022-03-19 | Culebra | Puerto Rico | 72049 | 162 | |
2319644 | 2319644 | 2022-03-18 | Culebra | Puerto Rico | 72049 | 162 | |
2316390 | 2316390 | 2022-03-17 | Culebra | Puerto Rico | 72049 | 162 | |
2313137 | 2313137 | 2022-03-16 | Culebra | Puerto Rico | 72049 | 162 | |
2309884 | 2309884 | 2022-03-15 | Culebra | Puerto Rico | 72049 | 162 | |
2306631 | 2306631 | 2022-03-14 | Culebra | Puerto Rico | 72049 | 162 | |
2303380 | 2303380 | 2022-03-13 | Culebra | Puerto Rico | 72049 | 162 | |
2300128 | 2300128 | 2022-03-12 | Culebra | Puerto Rico | 72049 | 162 | |
2296876 | 2296876 | 2022-03-11 | Culebra | Puerto Rico | 72049 | 162 | |
2293624 | 2293624 | 2022-03-10 | Culebra | Puerto Rico | 72049 | 162 | |
2290372 | 2290372 | 2022-03-09 | Culebra | Puerto Rico | 72049 | 162 | |
2287120 | 2287120 | 2022-03-08 | Culebra | Puerto Rico | 72049 | 162 | |
2283868 | 2283868 | 2022-03-07 | Culebra | Puerto Rico | 72049 | 162 | |
2280616 | 2280616 | 2022-03-06 | Culebra | Puerto Rico | 72049 | 162 | |
2277363 | 2277363 | 2022-03-05 | Culebra | Puerto Rico | 72049 | 162 | |
2274110 | 2274110 | 2022-03-04 | Culebra | Puerto Rico | 72049 | 162 | |
2270857 | 2270857 | 2022-03-03 | Culebra | Puerto Rico | 72049 | 162 | |
1581837 | 1581837 | 2021-08-03 | Maricao | Puerto Rico | 72093 | 162 | |
1578588 | 1578588 | 2021-08-02 | Maricao | Puerto Rico | 72093 | 162 | |
809218 | 809218 | 2020-12-08 | Las Marias | Puerto Rico | 72083 | 162 | |
805973 | 805973 | 2020-12-07 | Las Marias | Puerto Rico | 72083 | 162 | |
802728 | 802728 | 2020-12-06 | Las Marias | Puerto Rico | 72083 | 162 | |
799483 | 799483 | 2020-12-05 | Las Marias | Puerto Rico | 72083 | 162 | |
796238 | 796238 | 2020-12-04 | Las Marias | Puerto Rico | 72083 | 162 | |
617826 | 617826 | 2020-10-10 | Villalba | Puerto Rico | 72149 | 162 | |
608029 | 608029 | 2020-10-07 | Aibonito | Puerto Rico | 72009 | 162 | |
604786 | 604786 | 2020-10-06 | Aibonito | Puerto Rico | 72009 | 162 | |
575651 | 575651 | 2020-09-27 | Lajas | Puerto Rico | 72079 | 162 | |
569132 | 569132 | 2020-09-25 | Arroyo | Puerto Rico | 72015 | 162 | |
565891 | 565891 | 2020-09-24 | Arroyo | Puerto Rico | 72015 | 162 | |
562677 | 562677 | 2020-09-23 | Hormigueros | Puerto Rico | 72067 | 162 | |
559440 | 559440 | 2020-09-22 | Hormigueros | Puerto Rico | 72067 | 162 | |
533560 | 533560 | 2020-09-14 | Naguabo | Puerto Rico | 72103 | 162 | |
530325 | 530325 | 2020-09-13 | Naguabo | Puerto Rico | 72103 | 162 | |
420456 | 420456 | 2020-08-10 | Guayama | Puerto Rico | 72057 | 162 | |
410831 | 410831 | 2020-08-07 | San Lorenzo | Puerto Rico | 72129 | 162 | |
404377 | 404377 | 2020-08-05 | Moca | Puerto Rico | 72099 | 162 | |
394693 | 394693 | 2020-08-02 | Catano | Puerto Rico | 72033 | 162 | |
388298 | 388298 | 2020-07-31 | Orocovis | Puerto Rico | 72107 | 162 | |
372172 | 372172 | 2020-07-26 | Barranquitas | Puerto Rico | 72019 | 162 | |
372189 | 372189 | 2020-07-26 | Fajardo | Puerto Rico | 72053 | 162 | |
333737 | 333737 | 2020-07-14 | Arecibo | Puerto Rico | 72013 | 162 | |
330545 | 330545 | 2020-07-13 | Arecibo | Puerto Rico | 72013 | 162 | |
283088 | 283088 | 2020-06-28 | Mayaguez | Puerto Rico | 72097 | 162 | |
264254 | 264254 | 2020-06-22 | Ponce | Puerto Rico | 72113 | 162 | |
261126 | 261126 | 2020-06-21 | Ponce | Puerto Rico | 72113 | 162 | |
251770 | 251770 | 2020-06-18 | Toa Baja | Puerto Rico | 72137 | 162 | |
165503 | 165503 | 2020-05-21 | Guaynabo | Puerto Rico | 72061 | 162 |
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);