sunrise_sunset

Table actions

7 rows where "day" is on date 2024-07-20

✎ 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,2024-07-20 China beach china-beach 2024-07-20 05:33:53 06:04:30 13:16:21 20:28:31 20:59:09
fiscalini-ranch,2024-07-20 Fiscalini Ranch fiscalini-ranch 2024-07-20 05:35:06 06:04:32 13:10:48 20:17:22 20:46:48
fitzgerald-marine-reserve,2024-07-20 James Fitzgerald Marine Reserve  fitzgerald-marine-reserve 2024-07-20 05:34:50 06:05:18 13:16:26 20:27:53 20:58:21
laguna-point,2024-07-20 Laguna Point  laguna-point 2024-07-20 05:33:36 06:05:15 13:21:36 20:38:18 21:09:56
pillar-point,2024-07-20 Pillar Point pillar-point 2024-07-20 05:34:50 06:05:17 13:16:23 20:27:48 20:58:15
redondo-beach,2024-07-20 Redondo beach redondo-beach 2024-07-20 05:34:48 06:05:14 13:16:10 20:27:26 20:57:51
shark-fin-cove,2024-07-20 Shark Fin Cove shark-fin-cove 2024-07-20 05:35:06 06:05:17 13:15:08 20:25:18 20:55:29

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