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