Because InputTypes has the value 'false', the value column has the data type VARCHAR.
sn | city | week | attribute | value |
---|---|---|---|---|
1 | Asheville | 1 | temp | 32 |
1 | Asheville | 1 | pressure | 1020.8 |
1 | Asheville | 1 | dewpoint | 27.6F |
2 | Asheville | 2 | temp | 32 |
2 | Asheville | 2 | pressure | 1021.3 |
2 | Asheville | 2 | dewpoint | 27.4F |
3 | Asheville | 3 | temp | 34 |
3 | Asheville | 3 | pressure | 1021.7 |
3 | Asheville | 3 | dewpoint | 28.2F |
4 | Nashville | 1 | temp | 42 |
4 | Nashville | 1 | pressure | 1021.0 |
4 | Nashville | 1 | dewpoint | 29.4F |
5 | Nashville | 2 | temp | 44 |
5 | Nashville | 2 | pressure | 1019.8 |
5 | Nashville | 2 | dewpoint | 29.2F |
6 | Brownsville | 2 | temp | 47 |
6 | Brownsville | 2 | pressure | 1019.0 |
6 | Brownsville | 2 | dewpoint | 28.9F |
7 | Brownsville | 3 | temp | 46 |
7 | Brownsville | 3 | pressure | 1019.2 |
7 | Brownsville | 3 | dewpoint | 28.9F |