Statistics for table dehli-weather

API
Columns
Name Type Statistics
datetime_utc TEXT
NULL values False
Unique values 100,990
Lexical minimum '19961101-11:00'
Lexical maximum '20170424-18:00'
conds TEXT
NULL values 72
Non-NULL values 100,918
Unique values 39
Lexical minimum 'Blowing Sand'
Lexical maximum 'Widespread Dust'
dewptm INTEGER
NULL values 621
Non-NULL values 100,369
Unique values 51
Minimum -24
Mean 15.7412
Median 15
Maximum 75
Standard deviation 7.05859
fog INTEGER
NULL values False
Unique values 2 [0, 1]
Minimum 0
Mean 0.0696901
Median 0
Maximum 1
Standard deviation 0.254625
hail INTEGER
NULL values False
Unique values 2 [0, 1]
Minimum 0
Mean 0.000128726
Median 0
Maximum 1
Standard deviation 0.0113451
heatindexm REAL
NULL values 71,835
Non-NULL values 29,155
Unique values 193
Minimum 26.8
Mean 35.6517
Median 35.1
Maximum 73.6
Standard deviation 5.01538
hum TEXT
NULL values 143
Non-NULL values 100,847
Unique values 101
Lexical minimum '10'
Lexical maximum 'N/A'
precipm INTEGER
NULL values 100,990
Non-NULL values 0
Unique values 0 []
pressurem REAL
NULL values 232
Non-NULL values 100,758
Unique values 139
Minimum -9999
Mean 1932.33
Median 1008
Maximum 1.01061e+08
Standard deviation 318379
rain INTEGER
NULL values False
Unique values 2 [0, 1]
Minimum 0
Mean 0.02626
Median 0
Maximum 1
Standard deviation 0.159908
snow INTEGER
NULL values False
Unique values 2 [0, 1]
Minimum 0
Mean 9.90197e-06
Median 0
Maximum 1
Standard deviation 0.00314674
tempm INTEGER
NULL values 673
Non-NULL values 100,317
Unique values 50
Minimum 1
Mean 25.4513
Median 27
Maximum 90
Standard deviation 8.48286
thunder INTEGER
NULL values False
Unique values 2 [0, 1]
Minimum 0
Mean 0.00942668
Median 0
Maximum 1
Standard deviation 0.0966328
tornado INTEGER
NULL values False
Unique values 2 [0, 1]
Minimum 0
Mean 1.98039e-05
Median 0
Maximum 1
Standard deviation 0.00445014
vism REAL
NULL values 4,428
Non-NULL values 96,562
Unique values 48
Minimum 0
Mean 2.40277
Median 2
Maximum 6436
Standard deviation 20.746
wdird INTEGER
NULL values 14,755
Non-NULL values 86,235
Unique values 63
Minimum 0
Mean 163.55
Median 160
Maximum 960
Standard deviation 120.002
wdire TEXT
NULL values 14,755
Non-NULL values 86,235
Unique values 17
Lexical minimum 'ENE'
Lexical maximum 'West'
wgustm REAL
NULL values 99,918
Non-NULL values 1,072
Unique values 22
Minimum 25.9
Mean 37.6712
Median 37
Maximum 92.6
Standard deviation 6.84867
windchillm REAL
NULL values 100,411
Non-NULL values 579
Unique values 20
Minimum 2.1
Mean 5.71382
Median 6.1
Maximum 7.3
Standard deviation 1.20329
wspdm REAL
NULL values 2,358
Non-NULL values 98,632
Unique values 90
Minimum 0
Mean 7.67846
Median 7.4
Maximum 1514.9
Standard deviation 11.9322
100,990 rows
Schema
SciLifeLab Data Centre
DbShare 2.7.10