sunrise_sunset
7 rows where "day" is on date 2023-12-08
This data as json, CSV (advanced)
Link | place | day | dawn | sunrise | noon | sunset | dusk |
---|---|---|---|---|---|---|---|
china-beach,2023-12-08 | China beach china-beach | 2023-12-08 | 06:43:17 | 07:13:03 | 12:01:31 | 16:50:31 | 17:20:15 |
fiscalini-ranch,2023-12-08 | Fiscalini Ranch fiscalini-ranch | 2023-12-08 | 06:32:46 | 07:01:31 | 11:55:58 | 16:50:55 | 17:19:38 |
fitzgerald-marine-reserve,2023-12-08 | James Fitzgerald Marine Reserve fitzgerald-marine-reserve | 2023-12-08 | 06:42:44 | 07:12:22 | 12:01:36 | 16:51:22 | 17:20:58 |
laguna-point,2023-12-08 | Laguna Point laguna-point | 2023-12-08 | 06:52:29 | 07:23:07 | 12:06:46 | 16:50:58 | 17:21:34 |
pillar-point,2023-12-08 | Pillar Point pillar-point | 2023-12-08 | 06:42:39 | 07:12:17 | 12:01:33 | 16:51:21 | 17:20:57 |
redondo-beach,2023-12-08 | Redondo beach redondo-beach | 2023-12-08 | 06:42:18 | 07:11:54 | 12:01:20 | 16:51:18 | 17:20:52 |
shark-fin-cove,2023-12-08 | Shark Fin Cove shark-fin-cove | 2023-12-08 | 06:40:18 | 07:09:41 | 12:00:18 | 16:51:26 | 17:20:48 |
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]) );