Statistics for table seattle-weather

API
Columns
Name Type Statistics
date TEXT
NULL values False
Unique values 1,461
Lexical minimum '2012/01/01'
Lexical maximum '2015/12/31'
precipitation REAL
NULL values False
Unique values 111
Minimum 0
Mean 3.02943
Median 0
Maximum 55.9
Standard deviation 6.68019
temp_max REAL
NULL values False
Unique values 67
Minimum -1.6
Mean 16.4391
Median 15.6
Maximum 35.6
Standard deviation 7.34976
temp_min REAL
NULL values False
Unique values 55
Minimum -7.1
Mean 8.23477
Median 8.3
Maximum 18.3
Standard deviation 5.023
wind REAL
NULL values False
Unique values 79
Minimum 0.4
Mean 3.24114
Median 3
Maximum 9.5
Standard deviation 1.43783
weather TEXT
NULL values False
Unique values 5 ['drizzle', 'fog', 'sun', 'snow', 'rain']
Lexical minimum 'drizzle'
Lexical maximum 'sun'
1,461 rows
Schema
SciLifeLab Data Centre
DbShare 2.7.10