ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 1394 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 |
---|---|---|---|---|---|---|---|
2427029 | 2427029 | 2022-04-20 | Ceiba | Puerto Rico | 72037 | 1394 | |
2423803 | 2423803 | 2022-04-19 | Maunabo | Puerto Rico | 72095 | 1394 | |
2420547 | 2420547 | 2022-04-18 | Maunabo | Puerto Rico | 72095 | 1394 | |
2079006 | 2079006 | 2022-01-03 | Rincon | Puerto Rico | 72117 | 1394 | |
1955460 | 1955460 | 2021-11-26 | Guayama | Puerto Rico | 72057 | 1394 | |
1773499 | 1773499 | 2021-10-01 | Lares | Puerto Rico | 72081 | 1394 | |
1770249 | 1770249 | 2021-09-30 | Lares | Puerto Rico | 72081 | 1394 | |
1767000 | 1767000 | 2021-09-29 | Lares | Puerto Rico | 72081 | 1394 | |
1763751 | 1763751 | 2021-09-28 | Lares | Puerto Rico | 72081 | 1394 | |
1760502 | 1760502 | 2021-09-27 | Lares | Puerto Rico | 72081 | 1394 | |
1702048 | 1702048 | 2021-09-09 | Salinas | Puerto Rico | 72123 | 1394 | |
1520089 | 1520089 | 2021-07-15 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1516841 | 1516841 | 2021-07-14 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1513594 | 1513594 | 2021-07-13 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1510348 | 1510348 | 2021-07-12 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1507101 | 1507101 | 2021-07-11 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1503855 | 1503855 | 2021-07-10 | Aguas Buenas | Puerto Rico | 72007 | 1394 | |
1429234 | 1429234 | 2021-06-17 | Juana Diaz | Puerto Rico | 72075 | 1394 | |
1425989 | 1425989 | 2021-06-16 | Juana Diaz | Puerto Rico | 72075 | 1394 | |
1422742 | 1422742 | 2021-06-15 | Juana Diaz | Puerto Rico | 72075 | 1394 | |
1387081 | 1387081 | 2021-06-04 | Yabucoa | Puerto Rico | 72151 | 1394 | |
1140283 | 1140283 | 2021-03-20 | Moca | Puerto Rico | 72099 | 1394 | |
977937 | 977937 | 2021-01-29 | Aguadilla | Puerto Rico | 72005 | 1394 | |
887105 | 887105 | 2021-01-01 | Juncos | Puerto Rico | 72077 | 1394 | |
595125 | 595125 | 2020-10-03 | Unknown | Puerto Rico | 1394 | 681 | |
549705 | 549705 | 2020-09-19 | Caguas | Puerto Rico | 72025 | 1394 | |
530304 | 530304 | 2020-09-13 | Guaynabo | Puerto Rico | 72061 | 1394 |
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);