sunrise_sunset
7 rows where "day" is on date 2023-11-24
This data as json, CSV (advanced)
Link | place | day | dawn | sunrise | noon | sunset | dusk |
---|---|---|---|---|---|---|---|
china-beach,2023-11-24 | China beach china-beach | 2023-11-24 | 06:30:43 | 06:59:49 | 11:56:24 | 16:53:37 | 17:22:39 |
fiscalini-ranch,2023-11-24 | Fiscalini Ranch fiscalini-ranch | 2023-11-24 | 06:20:49 | 06:48:57 | 11:50:51 | 16:53:19 | 17:21:24 |
fitzgerald-marine-reserve,2023-11-24 | James Fitzgerald Marine Reserve fitzgerald-marine-reserve | 2023-11-24 | 06:30:14 | 06:59:13 | 11:56:29 | 16:54:22 | 17:23:17 |
laguna-point,2023-11-24 | Laguna Point laguna-point | 2023-11-24 | 06:39:25 | 07:09:20 | 12:01:39 | 16:54:38 | 17:24:29 |
pillar-point,2023-11-24 | Pillar Point pillar-point | 2023-11-24 | 06:30:10 | 06:59:08 | 11:56:26 | 16:54:21 | 17:23:16 |
redondo-beach,2023-11-24 | Redondo beach redondo-beach | 2023-11-24 | 06:29:50 | 06:58:47 | 11:56:13 | 16:54:17 | 17:23:10 |
shark-fin-cove,2023-11-24 | Shark Fin Cove shark-fin-cove | 2023-11-24 | 06:27:57 | 06:56:42 | 11:55:11 | 16:54:16 | 17:22:58 |
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]) );