home / sensor

Menu
  • Dashboards

fridge_2

Data license: Private

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: recorded_at, humidity_pct, pressure_hpa, door_status, light_lux, timestamp (date), recorded_at (date)

Link rowid ▼ timestamp recorded_at temperature_c humidity_pct pressure_hpa door_status light_lux
1 1 2026-05-08 12:58:10 2026-05-08 12:58 23.9 33.68 1004.6 OPEN 40.22
2 2 2026-05-08 12:58:20 2026-05-08 12:58 23.74 33.61 1004.6 CLOSED 39.33
3 3 2026-05-08 12:58:30 2026-05-08 12:58 23.54 33.63 1004.61 OPEN 40.22
4 4 2026-05-08 12:58:40 2026-05-08 12:58 23.47 33.48 1004.6 OPEN 40.22
5 5 2026-05-08 12:58:50 2026-05-08 12:58 23.42 33.62 1004.59 CLOSED 40.22
6 6 2026-05-08 12:59:00 2026-05-08 12:59 23.43 33.31 1004.6 CLOSED 40.22
7 7 2026-05-08 12:59:11 2026-05-08 12:59 23.4 33.38 1004.6 CLOSED 41.99
8 8 2026-05-08 12:59:21 2026-05-08 12:59 23.36 33.05 1004.6 CLOSED 41.99
9 9 2026-05-08 12:59:31 2026-05-08 12:59 23.38 33.38 1004.6 CLOSED 41.99
10 10 2026-05-08 12:59:41 2026-05-08 12:59 23.31 35.01 1004.62 OPEN 29.8
11 11 2026-05-08 12:59:51 2026-05-08 12:59 23.32 35.5 1004.59 OPEN 17.95
12 12 2026-05-08 13:00:01 2026-05-08 13:00 23.23 32.86 1004.59 OPEN 0.0
13 13 2026-05-08 13:00:12 2026-05-08 13:00 23.16 31.76 1004.59 OPEN 0.0
14 14 2026-05-08 13:00:22 2026-05-08 13:00 23.11 31.12 1004.6 OPEN 0.0
15 15 2026-05-08 13:00:32 2026-05-08 13:00 23.05 30.48 1004.6 OPEN 0.0
16 16 2026-05-08 13:00:42 2026-05-08 13:00 23.0 29.9 1004.57 OPEN 0.0
17 17 2026-05-08 13:00:52 2026-05-08 13:00 22.96 29.46 1004.58 OPEN 0.0
18 18 2026-05-08 13:01:02 2026-05-08 13:01 22.92 29.07 1004.58 OPEN 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [fridge_2] (
   [timestamp] TEXT,
   [recorded_at] TEXT,
   [temperature_c] FLOAT,
   [humidity_pct] FLOAT,
   [pressure_hpa] FLOAT,
   [door_status] TEXT,
   [light_lux] FLOAT
);
Powered by Datasette · Queries took 19.361ms · Data license: Private