sunrise_sunset

Table actions

7 rows where day = "2024-03-30" and "day" is on date 2024-03-30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sunrise, day (date)

Link place day dawn sunrise noon sunset dusk
china-beach,2024-03-30 China beach china-beach 2024-03-30 06:30:34 06:57:27 13:14:23 19:30:32 19:57:27
fiscalini-ranch,2024-03-30 Fiscalini Ranch fiscalini-ranch 2024-03-30 06:26:56 06:53:01 13:08:50 19:23:54 19:50:01
fitzgerald-marine-reserve,2024-03-30 James Fitzgerald Marine Reserve  fitzgerald-marine-reserve 2024-03-30 06:30:54 06:57:40 13:14:28 19:30:29 19:57:17
laguna-point,2024-03-30 Laguna Point  laguna-point 2024-03-30 06:34:15 07:01:48 13:19:38 19:36:39 20:04:14
pillar-point,2024-03-30 Pillar Point pillar-point 2024-03-30 06:30:52 06:57:38 13:14:25 19:30:26 19:57:14
redondo-beach,2024-03-30 Redondo beach redondo-beach 2024-03-30 06:30:42 06:57:27 13:14:12 19:30:11 19:56:58
shark-fin-cove,2024-03-30 Shark Fin Cove shark-fin-cove 2024-03-30 06:30:02 06:56:38 13:13:10 19:28:56 19:55:34

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