ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 410 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 |
---|---|---|---|---|---|---|---|
1205240 | 1205240 | 2021-04-09 | Patillas | Puerto Rico | 72109 | 410 | |
1137005 | 1137005 | 2021-03-19 | Ceiba | Puerto Rico | 72037 | 410 | |
1133759 | 1133759 | 2021-03-18 | Ceiba | Puerto Rico | 72037 | 410 | |
1130511 | 1130511 | 2021-03-17 | Ceiba | Puerto Rico | 72037 | 410 | |
1127264 | 1127264 | 2021-03-16 | Ceiba | Puerto Rico | 72037 | 410 | |
1124018 | 1124018 | 2021-03-15 | Ceiba | Puerto Rico | 72037 | 410 | |
1120772 | 1120772 | 2021-03-14 | Ceiba | Puerto Rico | 72037 | 410 | |
1117525 | 1117525 | 2021-03-13 | Ceiba | Puerto Rico | 72037 | 410 | |
1114278 | 1114278 | 2021-03-12 | Ceiba | Puerto Rico | 72037 | 410 | |
1036400 | 1036400 | 2021-02-16 | Lajas | Puerto Rico | 72079 | 410 | |
1026659 | 1026659 | 2021-02-13 | Jayuya | Puerto Rico | 72073 | 410 | |
977994 | 977994 | 2021-01-29 | Rincon | Puerto Rico | 72117 | 410 | |
974749 | 974749 | 2021-01-28 | Rincon | Puerto Rico | 72117 | 410 | |
896861 | 896861 | 2021-01-04 | Penuelas | Puerto Rico | 72111 | 410 | |
799486 | 799486 | 2020-12-05 | Luquillo | Puerto Rico | 72089 | 410 | |
702123 | 702123 | 2020-11-05 | Florida | Puerto Rico | 72054 | 410 | |
698879 | 698879 | 2020-11-04 | Florida | Puerto Rico | 72054 | 410 | |
695636 | 695636 | 2020-11-03 | Florida | Puerto Rico | 72054 | 410 | |
621070 | 621070 | 2020-10-11 | Yabucoa | Puerto Rico | 72151 | 410 | |
585371 | 585371 | 2020-09-30 | Juncos | Puerto Rico | 72077 | 410 | |
455938 | 455938 | 2020-08-21 | Dorado | Puerto Rico | 72051 | 410 | |
388312 | 388312 | 2020-07-31 | Toa Alta | Puerto Rico | 72135 | 410 | |
321019 | 321019 | 2020-07-10 | Guaynabo | Puerto Rico | 72061 | 410 |
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);