Broadband/Full Fibre Availability

CREATE TABLE table_1 (
  "e00068819_147_144_2018_01_31_0_0_0_0_coordinates_1_1788634035" VARCHAR  -- E00068819;147;144;2018-01-31;0.0;;0.0;;"{""coordinates"": [[[-1.1788634035,
  "n__52_630746046" DOUBLE  -- 52.630746046,
  "n__48_5784339439" VARCHAR  -- 48.5784339439],
  "n__1_1789367114" VARCHAR  -- [-1.1789367114,
  "n__52_6307736059" DOUBLE  -- 52.6307736059,
  "n__48_578547148" VARCHAR  -- 48.578547148],
  "n__1_1792234085" VARCHAR  -- [-1.1792234085,
  "n__52_6307838602" DOUBLE  -- 52.6307838602,
  "n__48_5789078679" VARCHAR  -- 48.5789078679],
  "n__1_1792467817" VARCHAR  -- [-1.1792467817,
  "n__52_630784741" DOUBLE  -- 52.630784741,
  "n__48_5789373126" VARCHAR  -- 48.5789373126],
  "n__1_1793226498" VARCHAR  -- [-1.1793226498,
  "n__52_6306754404" DOUBLE  -- 52.6306754404,
  "n__48_5789385987" VARCHAR  -- 48.5789385987],
  "n__1_1793727265" VARCHAR  -- [-1.1793727265,
  "n__52_6306033487" DOUBLE  -- 52.6306033487,
  "n__48_5789394872" VARCHAR  -- 48.5789394872],
  "n__1_1793834924" VARCHAR  -- [-1.1793834924,
  "n__52_6305878751" DOUBLE  -- 52.6305878751,
  "n__48_5789396996" VARCHAR  -- 48.5789396996],
  "n__1_1794447525" VARCHAR  -- [-1.1794447525,
  "n__52_6304714631" DOUBLE  -- 52.6304714631,
  "n__48_5789170619" VARCHAR  -- 48.5789170619],
  "n__1_1795220503" VARCHAR  -- [-1.1795220503,
  "n__52_6302921604" DOUBLE  -- 52.6302921604,
  "n__48_5788612375" VARCHAR  -- 48.5788612375],
  "n__1_179578614" VARCHAR  -- [-1.179578614,
  "n__52_6300620253" DOUBLE  -- 52.6300620253,
  "n__48_5787371993" VARCHAR  -- 48.5787371993],
  "n__1_1795859996" VARCHAR  -- [-1.1795859996,
  "n__52_6300318787" DOUBLE  -- 52.6300318787,
  "n__48_5787209207" VARCHAR  -- 48.5787209207],
  "n__1_1795943999" VARCHAR  -- [-1.1795943999,
  "n__52_6299735188" DOUBLE  -- 52.6299735188,
  "n__48_5786821637" VARCHAR  -- 48.5786821637],
  "n__1_179602922" VARCHAR  -- [-1.179602922,
  "n__52_6299151597" DOUBLE  -- 52.6299151597,
  "n__48_5786435567" VARCHAR  -- 48.5786435567],
  "n__1_1796042661" VARCHAR  -- [-1.1796042661,
  "n__52_6298432698" DOUBLE  -- 52.6298432698,
  "n__48_5785847576" VARCHAR  -- 48.5785847576],
  "n__1_1796056119" VARCHAR  -- [-1.1796056119,
  "n__52_6297712901" DOUBLE  -- 52.6297712901,
  "n__48_5785258804" VARCHAR  -- 48.5785258804],
  "n__1_1796059479" VARCHAR  -- [-1.1796059479,
  "n__52_6297533176" DOUBLE  -- 52.6297533176,
  "n__48_5785111794" VARCHAR  -- 48.5785111794],
  "n__1_1795823436" VARCHAR  -- [-1.1795823436,
  "n__52_629660584" DOUBLE  -- 52.629660584,
  "n__48_5784042086" VARCHAR  -- 48.5784042086],
  "n__1_179580756" VARCHAR  -- [-1.179580756,
  "n__52_6296542818" DOUBLE  -- 52.6296542818,
  "n__48_5783969574" VARCHAR  -- 48.5783969574],
  "n__1_1795509063" VARCHAR  -- [-1.1795509063,
  "n__52_629537239" DOUBLE  -- 52.629537239,
  "n__48_5782618728" VARCHAR  -- 48.5782618728],
  "n__1_1795407102" VARCHAR  -- [-1.1795407102,
  "n__52_6295092176" DOUBLE  -- 52.6295092176,
  "n__48_5782257849" VARCHAR  -- 48.5782257849],
  "n__1_1795283126" VARCHAR  -- [-1.1795283126,
  "n__52_6294751595" DOUBLE  -- 52.6294751595,
  "n__48_5781819168" VARCHAR  -- 48.5781819168],
  "n__1_1794883393" VARCHAR  -- [-1.1794883393,
  "n__52_6293653263" DOUBLE  -- 52.6293653263,
  "n__48_5780404564" VARCHAR  -- 48.5780404564],
  "n__1_1794823182" VARCHAR  -- [-1.1794823182,
  "n__52_6293485681" DOUBLE  -- 52.6293485681,
  "n__48_5780189661" VARCHAR  -- 48.5780189661],
  "n__1_1794525393" VARCHAR  -- [-1.1794525393,
  "n__52_6292668462" DOUBLE  -- 52.6292668462,
  "n__48_5779136634" VARCHAR  -- 48.5779136634],
  "n__1_1794406592" VARCHAR  -- [-1.1794406592,
  "n__52_6292442056" DOUBLE  -- 52.6292442056,
  "n__48_5778800333" VARCHAR  -- 48.5778800333],
  "n__1_1794239499" VARCHAR  -- [-1.1794239499,
  "n__52_6292127239" DOUBLE  -- 52.6292127239,
  "n__48_5778330322" VARCHAR  -- 48.5778330322],
  "n__1_179408" VARCHAR  -- [-1.179408,
  "n__52_6291797196" DOUBLE  -- 52.6291797196,
  "n__48_5777856857" VARCHAR  -- 48.5777856857],
  "n__1_1793741037" VARCHAR  -- [-1.1793741037,
  "n__52_6291097426" DOUBLE  -- 52.6291097426,
  "n__48_5776852025" VARCHAR  -- 48.5776852025],
  "n__1_1793670629" VARCHAR  -- [-1.1793670629,
  "n__52_6290954039" DOUBLE  -- 52.6290954039,
  "n__48_5776644927" VARCHAR  -- 48.5776644927],
  "n__1_1793283356" VARCHAR  -- [-1.1793283356,
  "n__52_6290427392" DOUBLE  -- 52.6290427392,
  "n__48_5775726372" VARCHAR  -- 48.5775726372],
  "n__1_1793223952" VARCHAR  -- [-1.1793223952,
  "n__52_6290346993" DOUBLE  -- 52.6290346993,
  "n__48_577558578" VARCHAR  -- 48.577558578],
  "n__1_1792805769" VARCHAR  -- [-1.1792805769,
  "n__52_6289779688" DOUBLE  -- 52.6289779688,
  "n__48_5774595048" VARCHAR  -- 48.5774595048],
  "n__1_179193829" VARCHAR  -- [-1.179193829,
  "n__52_628887584" DOUBLE  -- 52.628887584,
  "n__48_5772769377" VARCHAR  -- 48.5772769377],
  "n__1_1791502158" VARCHAR  -- [-1.1791502158
);