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