Query database weather

Query database weather

Table dehli-weather (100,990 rows)

datetime_utc	TEXT NOT NULL
conds	TEXT
dewptm	INTEGER
fog	INTEGER NOT NULL
hail	INTEGER NOT NULL
heatindexm	REAL
hum	TEXT
precipm	INTEGER
pressurem	REAL
rain	INTEGER NOT NULL
snow	INTEGER NOT NULL
tempm	INTEGER
thunder	INTEGER NOT NULL
tornado	INTEGER NOT NULL
vism	REAL
wdird	INTEGER
wdire	TEXT
wgustm	REAL
windchillm	REAL
wspdm	REAL

Table seattle-weather (1,461 rows)

date	TEXT NOT NULL
precipitation	REAL NOT NULL
temp_max	REAL NOT NULL
temp_min	REAL NOT NULL
wind	REAL NOT NULL
weather	TEXT NOT NULL

Table smhi-bromma-20190408-luftfuktighet (3,137 rows)

datum	TEXT NOT NULL
tid__utc_	TEXT NOT NULL
luftfuktighet	INTEGER NOT NULL
kvalitet	TEXT NOT NULL

Table smhi-bromma-20190408-lufttemperatur (3,131 rows)

datum	TEXT NOT NULL
tid__utc_	TEXT NOT NULL
lufttemperatur	REAL NOT NULL
kvalitet	TEXT NOT NULL

View many (? rows)

fog	INTEGER
hail	INTEGER
hum	TEXT
tempm	INTEGER

View tempfukt (3,131 rows)

lufttemperatur	REAL
luftfuktighet	INTEGER

View tf5 (3,131 rows)

t+	REAL
f?	INTEGER

SciLifeLab Data Centre

DbShare 2.7.10