Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

It is notable that no new permissions were requested by the phone.

Detailed Results

Device A

[{""latitude"":41.3986053,""longitude"":2.159144,""time"":1588416619345},{""latitude"":41.39861143255973,""longitude"":2.1591758894271402,""time"":1588416964271},{""latitude"":41.3986111,""longitude"":2.1591477,""time"":1588417382311},{""latitude"":41.39884529419205,""longitude"":2.1591677377011083,""time"":1588417707904},{""latitude"":41.39824724790695,""longitude"":2.1587165941002344,""time"":1588418190144},{""latitude"":41.398746510869785,""longitude"":2.1590672619422353,""time"":1588418516542}]

UPDATE catalystlocalstorage SET value = "[{""x"":138.1199951171875,""y"":84.77999877929688,""z"":-25.68000030517578,""timestamp"":1588416628368},{""x"":142.0800018310547,""y"":84.18000030517578,""z"":-26.69999885559082,""timestamp"":1588416678417},{""x"":141.4199981689453,""y"":83.93999481201172,""z"":-26.34000015258789,""timestamp"":1588416728419},{""x"":141.83999633789062,""y"":81.47999572753906,""z"":-27.35999870300293,""timestamp"":1588416778419},{""x"":141.4199981689453,""y"":81.9000015258789,""z"":-27.299999237060547,""timestamp"":1588416828618},{""x"":143.63999938964844,""y"":78.18000030517578,""z"":-30.119998931884766,""timestamp"":1588416878621},{""x"":141.3000030517578,""y"":79.5,""z"":-28.739999771118164,""timestamp"":1588416928819},{""x"":141.77999877929688,""y"":79.55999755859375,""z"":-28.439998626708984,""timestamp"":1588416978919},{""x"":147.72000122070312,""y"":114,""z"":-15.839999198913574,""timestamp"":1588417029116},{""x"":147.59999084472656,""y"":113.27999877929688,""z"":-15,""timestamp"":1588417079309},{""x"":152.27999877929688,""y"":99.29999542236328,""z"":-43.31999969482422,""timestamp"":1588417129503},{""x"":152.75999450683594,""y"":100.6199951171875,""z"":-45.05999755859375,""timestamp"":1588417179694},{""x"":188.39999389648438,""y"":111.41999816894531,""z"":-21.84000015258789,""timestamp"":1588417229886},In terms of the results, this requires data science support. See work to prepare the data here: https://github.com/AdamLeonSmith/privkittools/blob/master/Magnetometer.ipynb

Detailed Results

Device A

[{""x"":188138.81999206542971199951171875,""y"":10984.2599945068359477999877929688,""z"":-2125.05999946594238368000030517578,""timestamp"":15884172800831588416628368},{""x"":188142.220001220703120800018310547,""y"":10884.18000030517578,""z"":-1926.6800003051757869999885559082,""timestamp"":15884173302531588416678417},{""x"":189141.779998779296884199981689453,""y"":9783.593999481201172,""z"":-1626.8599987030029334000015258789,""timestamp"":15884173804491588416728419},{""x"":190141.319992065429783999633789062,""y"":9881.6999969482421947999572753906,""z"":-1627.13999938964843835999870300293,""timestamp"":15884174306441588416778419},{""x"":179141.879989624023444199981689453,""y"":9381.959999084472669000015258789,""z"":-427.980000019073486299999237060547,""timestamp"":15884174808421588416828618},{""x"":185143.699996948242263999938964844,""y"":9478.1399993896484418000030517578,""z"":-130.9199999570846558119998931884766,""timestamp"":15884175310371588416878621},{""x"":187141.979995727539063000030517578,""y"":9179.379997253417975,""z"":-428.679999828338623739999771118164,""timestamp"":15884175812271588416928819},{""x"":3141.539999961853027377999877929688,""y"":679.89999961853027355999755859375,""z"":58-28.2599983215332439998626708984,""timestamp"":15884176314221588416978919},{""x"":2147.639999866485595772000122070312,""y"":5.579999923706055114,""z"":56-15.69999694824219839999198913574,""timestamp"":15884176816161588417029116},{""x"":181147.4400024414062559999084472656,""y"":100113.7399978637695327999877929688,""z"":-22.6800003051757815,""timestamp"":15884177316881588417079309},{""x"":175152.080001831054727999877929688,""y"":10599.599998474121129999542236328,""z"":-2243.07999992370605531999969482422,""timestamp"":15884177818851588417129503},{""x"":174152.419998168945375999450683594,""y"":105100.11999511718756199951171875,""z"":-2145.60000038146972705999755859375,""timestamp"":15884178320801588417179694},{""x"":173188.4599914550781239999389648438,""y"":104111.8799972534179741999816894531,""z"":-21.84000015258789,""timestamp"":15884179183981588417229886},{""x"":172188.860000610351568199920654297,""y"":105109.8399963378906225999450683594,""z"":-2021.939998626708984059999465942383,""timestamp"":15884179685881588417280083},{""x"":172188.919998168945322000122070312,""y"":104108.8799972534179718000030517578,""z"":-2219.55999946594238368000030517578,""timestamp"":15884180187861588417330253},{""x"":173189.580001831054777999877929688,""y"":10597.299995422363285,""z"":-2416.71999931335449285999870300293,""timestamp"":15884180689721588417380449},{""x"":175190.259994506835943199920654297,""y"":10498.3999938964843869999694824219,""z"":-2516.559999465942383139999389648438,""timestamp"":15884181191651588417430644},{""x"":173179.5199890136718887998962402344,""y"":10693.4399948120117295999908447266,""z"":-224.739999771118164980000019073486,""timestamp"":15884181691651588417480842},{""x"":173185.940002441406256999969482422,""y"":10594.6599960327148413999938964844,""z"":-221.9200000762939459199999570846558,""timestamp"":15884182193611588417531037},{""x"":172187.080001831054797999572753906,""y"":10691.6800003051757837999725341797,""z"":-224.020000457763672679999828338623,""timestamp"":15884182693641588417581227},{""x"":1723.559997558593755399999618530273,""y"":1066.31999969482422899999618530273,""z"":-2158.1199989318847662599983215332,""timestamp"":15884183193861588417631422},{""x"":1722.7399902343756399998664855957,""y"":1065.86000061035156579999923706055,""z"":-1956.61999893188476669999694824219,""timestamp"":15884183693891588417681616},{""x"":173181.819992065429744000244140625,""y"":106100.4399948120117273999786376953,""z"":-22.1999988555908268000030517578,""timestamp"":15884184194031588417731688},{""x"":172175.91999816894530800018310547,""y"":105.899993896484385999984741211,""z"":-2122.65999984741211079999923706055,""timestamp"":15884184694111588417781885},{""x"":172174.559997558593754199981689453,""y"":106105.919998168945311199951171875,""z"":-21.420000076293945600000381469727,""timestamp"":15884185195941588417832080},{""x"":173.3999938964843845999145507812,""y"":106104.3799972534179787999725341797,""z"":-23.5199985504150421,""timestamp"":15884185697871588417918398},{""x"":174172.23999023437586000061035156,""y"":107105.0400009155273483999633789062,""z"":-2220.260000228881836939998626708984,""timestamp"":15884186199791588417968588},{""x"":172.139999389648449199981689453,""y"":106104.9199981689453187999725341797,""z"":-2022.939998626708984559999465942383,""timestamp"":15884186701681588418018786},{""x"":171173.41999816894535800018310547,""y"":107105.1599960327148429999542236328,""z"":-1824.779998779296875719999313354492,""timestamp"":15884187203611588418068972},{""x"":171175.300003051757825999450683594,""y"":106104.9799957275390639999389648438,""z"":-2025.15999984741211559999465942383,""timestamp"":15884187705501588418119165},{""x"":177173.9599914550781251998901367188,""y"":101106.6999969482421943999481201172,""z"":-2022.8799991607666739999771118164,""timestamp"":15884188207471588418169165},{""x"":178173.199996948242294000244140625,""y"":99105.8399963378906265999603271484,""z"":-2022.760000228881836920000076293945,""timestamp"":15884188709371588418219361},{""x"":178172.80000305175780800018310547,""y"":100106.0799942016601668000030517578,""z"":-22.079999923706055020000457763672,""timestamp"":15884189211291588418269364},{""x"":178172.080001831054755999755859375,""y"":100106.4399948120117231999969482422,""z"":-1921.3799991607666119998931884766,""timestamp"":15884189713271588418319386},{""x"":166172.9199981689453739990234375,""y"":109106.1399993896484486000061035156,""z"":-2119.239999771118164619998931884766,""timestamp"":15884190215241588418369389},{""x"":167173.639999389648448199920654297,""y"":109106.0799942016601643999481201172,""z"":-2022.76000022888183619999885559082,""timestamp"":15884190717191588418419403},{""x"":167172.160003662109389199981689453,""y"":109105.3799972534179789999389648438,""z"":-1921.43999862670898465999984741211,""timestamp"":15884191219111588418469411},{""x"":166172.55999755859375,""y"":108106.1800003051757891999816894531,""z"":-2021.69999885559082420000076293945,""timestamp"":1588419172101}]" WHERE key = "MAGNETOMETER_DATA"

Device B

UPDATE catalystlocalstorage SET value = "[{""latitude"":41.39866657,""longitude"":2.15920166,""time"":15884129230001588418519594},{""x"":173.39999389648438,""y"":106.37999725341797,""z"":-23.51999855041504,""timestamp"":1588418569787},{""latitudex"":41174.39862513239990234375,""longitudey"":2107.1591165404000091552734,""timez"":1588413236000},{-22.260000228881836,""latitudetimestamp"":41.398631241588418619979},{""longitudex"":2172.1593847913999938964844,""timey"":1588413834000}106.91999816894531,{""latitudez"":41-20.39856103939998626708984,""longitudetimestamp"":2.159175081588418670168},{""timex"":1588414431000}171.4199981689453,{""latitudey"":41107.3985610315999603271484,""longitudez"":2-18.15917508779998779296875,""timetimestamp"":15884147310001588418720361},{""latitudex"":41171.398561033000030517578,""longitudey"":2106.1591750897999572753906,""timez"":1588415031000},{-20.15999984741211,""latitudetimestamp"":41.39860231588418770550},{""longitudex"":2177.159128995999145507812,""timey"":1588415371000}101.69999694824219,{""latitudez"":41-20.398610998799991607666,""longitudetimestamp"":2.159375571588418820747},{""timex"":1588415933000}178.1999969482422,{""latitudey"":4199.3984969883999633789062,""longitudez"":2-20.15914064760000228881836,""timetimestamp"":15884163640001588418870937},{""latitudex"":41178.398824698000030517578,""longitudey"":2100.1591768607999420166016,""timez"":1588416665000},{-22.079999923706055,""latitudetimestamp"":41.398799511588418921129},{""longitudex"":2178.159005250800018310547,""timey"":1588416967000}100.43999481201172,{""latitudez"":41-19.398599473799991607666,""longitudetimestamp"":2.159093741588418971327},{""timex"":1588417274000}166.9199981689453,{""latitudey"":41109.3987358813999938964844,""longitudez"":2-21.15917513239999771118164,""timetimestamp"":15884178630001588419021524},{""latitudex"":41167.3986290863999938964844,""longitudey"":2109.1593890307999420166016,""timez"":1588418179000},{-20.760000228881836,""latitudetimestamp"":41.398667851588419071719},{""longitudex"":2167.1591024916000366210938,""timey"":1588418778000}109.37999725341797,{""latitudez"":41-19.39855966439998626708984,""longitudetimestamp"":2.159110521588419121911},{""timex"":1588419089000}166.55999755859375,{""latitudey"":41108.3986054718000030517578,""longitudez"":2-20.1592042769999885559082,""timetimestamp"":15884196870001588419172101}]" WHERE key = "LOCATIONMAGNETOMETER_DATA"

Device B

UPDATE catalystlocalstorage SET value = "[{""x"":40.0589599609375,""y"":-15.680082321166992,""z"":-32.017913818359375,""timestamp"":1588412935548},{""x"":40.0699462890625,""y"":-15.63351058959961,""z"":-31.241363525390625,""timestamp"":1588412985839},{""x"":40.2173957824707,""y"":-14.890460968017578,""z"":-31.447830200195312,""timestamp"":1588413036124},{""x"":40.292964935302734,""y"":-14.936300277709961,""z"":-32.6888427734375,""timestamp"":1588413086409},{""x"":39.4268684387207,""y"":-15.191373825073242,""z"":-31.197006225585938,""timestamp"":1588413136698},{""x"":40.090423583984375,""y"":-15.107881546020508,""z"":-30.815773010253906,""timestamp"":1588413186985},{""x"":39.909942626953125,""y"":-15.434043884277344,""z"":-30.728759765625,""timestamp"":1588413237280},{""x"":39.712791442871094,""y"":-15.513147354125977,""z"":-30.79412841796875,""timestamp"":1588413287587},{""x"":39.52531433105469,""y"":-15.298532485961914,""z"":-30.592002868652344,""timestamp"":1588413337885},{""x"":39.171905517578125,""y"":-15.270963668823242,""z"":-30.921676635742188,""timestamp"":1588413388186},{""x"":39.334922790527344,""y"":-14.99114990234375,""z"":-29.86119842529297,""timestamp"":1588413438490},{""x"":39.59674835205078,""y"":-15.436887741088867,""z"":-30.266990661621094,""timestamp"":1588413488801},{""x"":39.964786529541016,""y"":-15.217239379882812,""z"":-30.97374725341797,""timestamp"":1588413539118},{""x"":39.67028045654297,""y"":-15.35910415649414,""z"":-31.351356506347656,""timestamp"":1588413589792},{""x"":39.382930755615234,""y"":-15.176273345947266,""z"":-30.824935913085938,""timestamp"":1588413640116},{""x"":39.980655670166016,""y"":-15.649593353271484,""z"":-29.908164978027344,""timestamp"":1588413690429},{""x"":39.92919921875,""y"":-15.789295196533203,""z"":-30.950103759765625,""timestamp"":1588413740741},{""x"":31.37622833251953,""y"":-15.684326171875,""z"":-36.744293212890625,""timestamp"":1588413791045},{""x"":31.305578231811523,""y"":-15.669544219970703,""z"":-36.853553771972656,""timestamp"":1588413841343},{""x"":31.410688400268555,""y"":-16.20936393737793,""z"":-36.65717315673828,""timestamp"":1588413891634},{""x"":31.475975036621094,""y"":-15.96141242980957,""z"":-35.90857696533203,""timestamp"":1588413941933},{""x"":31.111242294311523,""y"":-16.04218101501465,""z"":-36.68970489501953,""timestamp"":1588413992238},{""x"":31.280593872070312,""y"":-16.210458755493164,""z"":-35.88287353515625,""timestamp"":1588414042532},{""x"":31.02417755126953,""y"":-16.073787689208984,""z"":-35.96180725097656,""timestamp"":1588414092840},{""x"":30.865154266357422,""y"":-15.843467712402344,""z"":-35.852264404296875,""timestamp"":1588414143155},{""x"":31.34894561767578,""y"":-15.808174133300781,""z"":-36.606468200683594,""timestamp"":1588414193464},{""x"":31.34105682373047,""y"":-16.256397247314453,""z"":-36.844764709472656,""timestamp"":1588414243769},{""x"":30.79733657836914,""y"":-16.153108596801758,""z"":-35.62408447265625,""timestamp"":1588414294076},{""x"":31.090707778930664,""y"":-15.918539047241211,""z"":-35.245361328125,""timestamp"":1588414344395},{""x"":30.96401023864746,""y"":-15.873424530029297,""z"":-35.649749755859375,""timestamp"":1588414394720},{""x"":30.98093605041504,""y"":-15.919719696044922,""z"":-36.30181884765625,""timestamp"":1588414445031},{""x"":31.302135467529297,""y"":-15.669422149658203,""z"":-35.82948303222656,""timestamp"":1588414495341},{""x"":31.16522216796875,""y"":-16.057003021240234,""z"":-35.8358154296875,""timestamp"":1588414545670},{""x"":31.101856231689453,""y"":-15.532207489013672,""z"":-35.752586364746094,""timestamp"":1588414595985},{""x"":31.467771530151367,""y"":-16.45595359802246,""z"":-35.88365936279297,""timestamp"":1588414646289},{""x"":31.22051429748535,""y"":-15.855661392211914,""z"":-36.1585693359375,""timestamp"":1588414696602},{""x"":31.56662940979004,""y"":-16.31602668762207,""z"":-36.29974365234375,""timestamp"":1588414746930},{""x"":31.18305015563965,""y"":-16.257770538330078,""z"":-36.19493865966797,""timestamp"":1588414797238},{""x"":31.38979721069336,""y"":-15.869497299194336,""z"":-35.89295959472656,""timestamp"":1588414847562},{""x"":31.316211700439453,""y"":-15.530294418334961,""z"":-36.30865478515625,""timestamp"":1588414897880},{""x"":30.91192054748535,""y"":-16.352867126464844,""z"":-35.268272399902344,""timestamp"":1588414948198},{""x"":31.375812530517578,""y"":-15.807861328125,""z"":-36.171669006347656,""timestamp"":1588414998509},{""x"":31.962923049926758,""y"":-15.168851852416992,""z"":-36.141456604003906,""timestamp"":1588415048827},{""x"":32.7541618347168,""y"":-15.17684555053711,""z"":-35.48052215576172,""timestamp"":1588415099141},{""x"":32.66035079956055,""y"":-15.579492568969727,""z"":-35.61066436767578,""timestamp"":1588415149458},{""x"":32.085079193115234,""y"":-14.920377731323242,""z"":-35.454254150390625,""timestamp"":1588415199777},{""x"":32.73699188232422,""y"":-14.991544723510742,""z"":-35.26123809814453,""timestamp"":1588415250093},{""x"":32.382442474365234,""y"":-14.917608261108398,""z"":-35.41968536376953,""timestamp"":1588415300402},{""x"":32.6612434387207,""y"":-14.714042663574219,""z"":-34.808753967285156,""timestamp"":1588415350724},{""x"":32.67103576660156,""y"":-15.316694259643555,""z"":-35.529762268066406,""timestamp"":1588415401045},{""x"":32.116477966308594,""y"":-15.012884140014648,""z"":-36.029136657714844,""timestamp"":1588415451359},{""x"":32.47699737548828,""y"":-14.545869827270508,""z"":-35.398529052734375,""timestamp"":1588415501682},{""x"":32.584205627441406,""y"":-14.993099212646484,""z"":-36.16304016113281,""timestamp"":1588415552001},{""x"":32.19566345214844,""y"":-14.81112289428711,""z"":-35.03266143798828,""timestamp"":1588415602322},{""x"":31.734764099121094,""y"":-15.217241287231445,""z"":-35.52405548095703,""timestamp"":1588415652628},{""x"":33.15986633300781,""y"":-15.297021865844727,""z"":-37.7271728515625,""timestamp"":1588415702953},{""x"":29.32909393310547,""y"":14.613388061523438,""z"":-39.471923828125,""timestamp"":1588415753259},{""x"":29.19544219970703,""y"":15.276500701904297,""z"":-40.055084228515625,""timestamp"":1588415803565},{""x"":28.47340965270996,""y"":14.698341369628906,""z"":-38.0999755859375,""timestamp"":1588415853867},{""x"":29.068220138549805,""y"":14.858322143554688,""z"":-38.61859130859375,""timestamp"":1588415904174},{""x"":26.11041259765625,""y"":10.723255157470703,""z"":-20.30066680908203,""timestamp"":1588415954466},{""x"":26.297706604003906,""y"":10.86385726928711,""z"":-21.739830017089844,""timestamp"":1588416015404},{""x"":20.013809204101562,""y"":4.622589111328125,""z"":-34.64476776123047,""timestamp"":1588416101960},{""x"":21.0351505279541,""y"":-4.114194869995117,""z"":-36.97352600097656,""timestamp"":1588416152246},{""x"":21.163021087646484,""y"":-4.097576141357422,""z"":-37.142494201660156,""timestamp"":1588416202538},{""x"":21.29568862915039,""y"":-3.4318580627441406,""z"":-36.88457489013672,""timestamp"":1588416252838},{""x"":21.087635040283203,""y"":-4.113517761230469,""z"":-35.731536865234375,""timestamp"":1588416303140},{""x"":21.403427124023438,""y"":-4.079875946044922,""z"":-37.07737731933594,""timestamp"":1588416353448},{""x"":21.382801055908203,""y"":-3.8635692596435547,""z"":-35.94225311279297,""timestamp"":1588416403749},{""x"":20.29475975036621,""y"":-6.222526550292969,""z"":-36.635498046875,""timestamp"":1588416454069},{""x"":21.097827911376953,""y"":-4.561748504638672,""z"":-37.133399963378906,""timestamp"":1588416504381},{""x"":20.310977935791016,""y"":-2.992830276489258,""z"":-36.34771728515625,""timestamp"":1588416554701},{""x"":26.041868209838867,""y"":-4.221691131591797,""z"":-34.06073760986328,""timestamp"":1588416605018},{""x"":25.343236923217773,""y"":-4.104442596435547,""z"":-33.16755676269531,""timestamp"":1588416655331},{""x"":25.6159725189209,""y"":-4.271944046020508,""z"":-33.616371154785156,""timestamp"":1588416705654},{""x"":25.861473083496094,""y"":-3.744152069091797,""z"":-32.70707702636719,""timestamp"":1588416755975},{""x"":26.230632781982422,""y"":-3.756196975708008,""z"":-32.90460205078125,""timestamp"":1588416806304},{""x"":26.478591918945312,""y"":-4.001310348510742,""z"":-34.1304931640625,""timestamp"":1588416856627},{""x"":26.393444061279297,""y"":-4.171974182128906,""z"":-33.466339111328125,""timestamp"":1588416906940},{""x"":26.432594299316406,""y"":-4.047908782958984,""z"":-32.92127990722656,""timestamp"":1588416957283},{""x"":26.048677444458008,""y"":-4.051418304443359,""z"":-32.49137878417969,""timestamp"":1588417007602},{""x"":26.044937133789062,""y"":-3.618864059448242,""z"":-32.95166015625,""timestamp"":1588417057942},{""x"":26.191165924072266,""y"":-3.880250930786133,""z"":-33.3565673828125,""timestamp"":1588417108274},{""x"":25.827682495117188,""y"":-3.4353466033935547,""z"":-32.207176208496094,""timestamp"":1588417158602},{""x"":25.734182357788086,""y"":-3.714458465576172,""z"":-32.87889862060547,""timestamp"":1588417208935},{""x"":26.13224983215332,""y"":-3.6799278259277344,""z"":-33.41687774658203,""timestamp"":1588417259250},{""x"":26.088836669921875,""y"":-3.664844512939453,""z"":-33.199981689453125,""timestamp"":1588417309582},{""x"":25.916454315185547,""y"":-3.666339874267578,""z"":-32.488243103027344,""timestamp"":1588417359918},{""x"":25.915674209594727,""y"":-3.4964332580566406,""z"":-32.874114990234375,""timestamp"":1588417410256},{""x"":25.94756507873535,""y"":-3.6970653533935547,""z"":-33.20203399658203,""timestamp"":1588417460586},{""x"":25.733097076416016,""y"":-3.621753692626953,""z"":-32.89330291748047,""timestamp"":1588417510911},{""x"":26.02989387512207,""y"":-3.402751922607422,""z"":-33.476776123046875,""timestamp"":1588417561233},{""x"":-4.288597106933594,""y"":2.483673095703125,""z"":-12.550582885742188,""timestamp"":1588417611562},{""x"":-3.8852500915527344,""y"":1.97747802734375,""z"":-12.691646575927734,""timestamp"":1588417661879},{""x"":37.37435531616211,""y"":15.154117584228516,""z"":-24.070877075195312,""timestamp"":1588417712193},{""x"":-10.629215240478516,""y"":11.459671020507812,""z"":-42.85163879394531,""timestamp"":1588417762506},{""x"":-49.01023864746094,""y"":-21.554176330566406,""z"":18.812170028686523,""timestamp"":1588417812818},{""x"":-48.777061462402344,""y"":-21.75306510925293,""z"":17.602174758911133,""timestamp"":1588417863123},{""x"":-49.39384460449219,""y"":-21.310596466064453,""z"":18.25200653076172,""timestamp"":1588417918348},{""x"":-49.01043701171875,""y"":-21.600500106811523,""z"":19.04435920715332,""timestamp"":1588417968636},{""x"":-49.311309814453125,""y"":-21.850250244140625,""z"":20.946359634399414,""timestamp"":1588418018926},{""x"":-50.03755187988281,""y"":-22.567882537841797,""z"":20.448041915893555,""timestamp"":1588418069225},{""x"":-49.47925567626953,""y"":-22.237998962402344,""z"":21.74654197692871,""timestamp"":1588418119527},{""x"":-49.68310546875,""y"":-22.734479904174805,""z"":20.977766036987305,""timestamp"":1588418169831},{""x"":-49.63313293457031,""y"":-22.363067626953125,""z"":21.61907196044922,""timestamp"":1588418220134},{""x"":-50.608009338378906,""y"":-21.383220672607422,""z"":21.4798641204834,""timestamp"":1588418270454},{""x"":-50.951866149902344,""y"":-21.03104019165039,""z"":21.3404483795166,""timestamp"":1588418320763},{""x"":-50.62835693359375,""y"":-19.82268524169922,""z"":21.855510711669922,""timestamp"":1588418371085},{""x"":-50.08917236328125,""y"":-20.00303077697754,""z"":22.263105392456055,""timestamp"":1588418421400},{""x"":-50.95465087890625,""y"":-19.64037322998047,""z"":21.326313018798828,""timestamp"":1588418471718},{""x"":-50.623634338378906,""y"":-20.008174896240234,""z"":21.124011993408203,""timestamp"":1588418522027},{""x"":-50.841827392578125,""y"":-19.87095832824707,""z"":22.31791877746582,""timestamp"":1588418572345},{""x"":-50.13356018066406,""y"":-19.97247314453125,""z"":22.712947845458984,""timestamp"":1588418622662},{""x"":-50.61085510253906,""y"":-20.193321228027344,""z"":22.208093643188477,""timestamp"":1588418672976},{""x"":-50.10009765625,""y"":-19.508447647094727,""z"":23.71207618713379,""timestamp"":1588418723295},{""x"":-50.57221221923828,""y"":-19.853025436401367,""z"":22.11958885192871,""timestamp"":1588418773608},{""x"":-33.258995056152344,""y"":-14.303421020507812,""z"":-6.749748229980469,""timestamp"":1588418823950},{""x"":30.183881759643555,""y"":-2.267108917236328,""z"":-34.282981872558594,""timestamp"":1588418874250},{""x"":29.861522674560547,""y"":-2.779909133911133,""z"":-33.455108642578125,""timestamp"":1588418924580},{""x"":30.53078842163086,""y"":-2.8047218322753906,""z"":-34.3785400390625,""timestamp"":1588418974897},{""x"":29.47096824645996,""y"":-3.1081314086914062,""z"":-34.084381103515625,""timestamp"":1588419025232},{""x"":29.350704193115234,""y"":-3.6809959411621094,""z"":-34.15483856201172,""timestamp"":1588419075566},{""x"":29.508079528808594,""y"":-3.8494796752929688,""z"":-33.99986267089844,""timestamp"":1588419125918},{""x"":29.255992889404297,""y"":-3.063692092895508,""z"":-33.512237548828125,""timestamp"":1588419176253},{""x"":29.490859985351562,""y"":-3.6641769409179688,""z"":-33.765052795410156,""timestamp"":1588419226585},{""x"":29.500991821289062,""y"":-3.3395862579345703,""z"":-33.74546813964844,""timestamp"":1588419276923},{""x"":30.196210861206055,""y"":-3.1787281036376953,""z"":-34.635292053222656,""timestamp"":1588419327252},{""x"":29.87530517578125,""y"":-3.4444751739501953,""z"":-35.13885498046875,""timestamp"":1588419377571},{""x"":29.638338088989258,""y"":-3.8020591735839844,""z"":-34.9908447265625,""timestamp"":1588419427924},{""x"":29.584468841552734,""y"":-3.045307159423828,""z"":-34.361572265625,""timestamp"":1588419478269},{""x"":29.622032165527344,""y"":-2.9829673767089844,""z"":-33.1190185546875,""timestamp"":1588419528614},{""x"":29.630077362060547,""y"":-3.353900909423828,""z"":-34.16307830810547,""timestamp"":1588419578932},{""x"":29.282062530517578,""y"":-3.2023448944091797,""z"":-32.334327697753906,""timestamp"":1588419629291},{""x"":29.633155822753906,""y"":-3.354005813598633,""z"":-35.07854461669922,""timestamp"":1588419679611},{""x"":28.265918731689453,""y"":-1.2493476867675781,""z"":-32.1673583984375,""timestamp"":1588419729948},{""x"":29.103370666503906,""y"":-1.8600082397460938,""z"":-34.632118225097656,""timestamp"":1588419780280},{""x"":28.491762161254883,""y"":-1.9119224548339844,""z"":-33.724456787109375,""timestamp"":1588419830636},{""x"":28.650100708007812,""y"":-2.0649986267089844,""z"":-33.91065216064453,""timestamp"":1588419880977},{""x"":28.62312889099121,""y"":-2.1888561248779297,""z"":-33.865936279296875,""timestamp"":1588419931301}]" WHERE key = "MAGNETOMETER_DATA"

...