sunrise_sunset
7 rows where "day" is on date 2023-11-21
This data as json, CSV (advanced)
Link | place | day | dawn | sunrise | noon | sunset | dusk |
---|---|---|---|---|---|---|---|
china-beach,2023-11-21 | China beach china-beach | 2023-11-21 | 06:27:46 | 06:56:42 | 11:55:36 | 16:55:08 | 17:24:00 |
fiscalini-ranch,2023-11-21 | Fiscalini Ranch fiscalini-ranch | 2023-11-21 | 06:18:03 | 06:46:02 | 11:50:03 | 16:54:39 | 17:22:34 |
fitzgerald-marine-reserve,2023-11-21 | James Fitzgerald Marine Reserve fitzgerald-marine-reserve | 2023-11-21 | 06:27:19 | 06:56:07 | 11:55:41 | 16:55:52 | 17:24:36 |
laguna-point,2023-11-21 | Laguna Point laguna-point | 2023-11-21 | 06:36:20 | 07:06:03 | 12:00:51 | 16:56:19 | 17:25:59 |
pillar-point,2023-11-21 | Pillar Point pillar-point | 2023-11-21 | 06:27:15 | 06:56:03 | 11:55:38 | 16:55:51 | 17:24:35 |
redondo-beach,2023-11-21 | Redondo beach redondo-beach | 2023-11-21 | 06:26:55 | 06:55:41 | 11:55:25 | 16:55:47 | 17:24:29 |
shark-fin-cove,2023-11-21 | Shark Fin Cove shark-fin-cove | 2023-11-21 | 06:25:04 | 06:53:39 | 11:54:23 | 16:55:44 | 17:24:15 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [sunrise_sunset] ( [place] TEXT REFERENCES [places]([slug]), [day] TEXT, [dawn] TEXT, [sunrise] TEXT, [noon] TEXT, [sunset] TEXT, [dusk] TEXT, PRIMARY KEY ([place], [day]) );