sunrise_sunset

Table actions

7 rows where day = "2025-07-07"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dawn, sunrise, day (date)

Link place day dawn sunrise noon sunset dusk
china-beach,2025-07-07 China beach china-beach 2025-07-07 05:23:51 05:55:22 13:14:52 20:34:39 21:06:10
fiscalini-ranch,2025-07-07 Fiscalini Ranch fiscalini-ranch 2025-07-07 05:25:51 05:56:04 13:09:19 20:22:50 20:53:03
fitzgerald-marine-reserve,2025-07-07 James Fitzgerald Marine Reserve  fitzgerald-marine-reserve 2025-07-07 05:24:55 05:56:15 13:14:57 20:33:56 21:05:16
laguna-point,2025-07-07 Laguna Point  laguna-point 2025-07-07 05:22:56 05:55:34 13:20:07 20:44:58 21:17:36
pillar-point,2025-07-07 Pillar Point pillar-point 2025-07-07 05:24:55 05:56:15 13:14:55 20:33:51 21:05:11
redondo-beach,2025-07-07 Redondo beach redondo-beach 2025-07-07 05:24:54 05:56:12 13:14:42 20:33:27 21:04:45
shark-fin-cove,2025-07-07 Shark Fin Cove shark-fin-cove 2025-07-07 05:25:21 05:56:24 13:13:39 20:31:12 21:02:14

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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])
);