Databases > WideWorldImporters > Views > Website.VehicleTemperatures

WideWorldImporters

Website.VehicleTemperatures

Created: Modified:

Columns

Definition

Sample Data

VehicleTemperatureID
VehicleRegistration
ChillerSensorNumber
RecordedWhen
Temperature
FullSensorData
65684
WWI-321-A
2
3.34
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-114.8127174,40.4787325] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:16:36","temp":3.34}} ]
65686
WWI-321-A
2
3.17
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-117.2113811,59.2916490] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:18:22","temp":3.17}} ]
65687
WWI-321-A
1
4.6
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-110.7841282,41.1279431] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:20:54","temp":4.60}} ]
65689
WWI-321-A
1
3.86
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-119.5104355,64.0071744] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:25:43","temp":3.86}} ]
65690
WWI-321-A
2
4.65
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-104.6624011,46.9517319] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:25:43","temp":4.65}} ]
65691
WWI-321-A
1
3.05
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-107.3326194,51.7611560] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:28:27","temp":3.05}} ]
65692
WWI-321-A
2
3.02
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-113.8483504,53.5594106] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:28:27","temp":3.02}} ]
65693
WWI-321-A
1
4.98
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-109.2456462,57.4176458] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:29:20","temp":4.98}} ]
65694
WWI-321-A
2
3.7
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-105.3264969,53.7108318] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:29:20","temp":3.70}} ]
65695
WWI-321-A
1
3.32
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-112.9956455,63.9919949] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:33:37","temp":3.32}} ]
65696
WWI-321-A
2
4.77
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-117.7538986,46.3395364] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:33:37","temp":4.77}} ]
65697
WWI-321-A
1
5
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-107.9037602,43.1198494] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:34:39","temp":5.00}} ]
65700
WWI-321-A
2
4.95
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-111.5271659,49.4171341] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:34:59","temp":4.95}} ]
65701
WWI-321-A
1
4.53
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-100.1590183,52.2343107] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:35:59","temp":4.53}} ]
65704
WWI-321-A
2
4.55
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-118.8786065,40.7735081] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:40:37","temp":4.55}} ]
65707
WWI-321-A
1
4.91
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-118.8807405,60.3524708] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:43:48","temp":4.91}} ]
65708
WWI-321-A
2
3.58
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-107.4071381,44.8160922] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:43:48","temp":3.58}} ]
65710
WWI-321-A
2
5
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-108.3927541,58.1174136] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:44:35","temp":5.00}} ]
65714
WWI-321-A
2
4.84
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-120.8525688,48.8132593] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:50:50","temp":4.84}} ]
65717
WWI-321-A
1
4.35
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-108.3307825,54.5413903] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T09:55:07","temp":4.35}} ]
65718
WWI-321-A
2
4.77
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-101.5064698,50.9413300] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T09:55:07","temp":4.77}} ]
65722
WWI-321-A
2
3.91
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-107.5451270,49.1210670] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T10:03:21","temp":3.91}} ]
65725
WWI-321-A
1
3.49
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-105.9892213,42.6627048] }, "properties":{"rego":"WWI-321-A","sensor":"1,"when":"2016-05-31T10:08:58","temp":3.49}} ]
65726
WWI-321-A
2
4.93
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-105.2286168,42.8601064] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T10:08:58","temp":4.93}} ]
65728
WWI-321-A
2
3.18
{"Recordings": [{"type":"Feature", "geometry": {"type":"Point", "coordinates":[-103.9252724,55.5916500] }, "properties":{"rego":"WWI-321-A","sensor":"2,"when":"2016-05-31T10:11:04","temp":3.18}} ]