Pasted

SELECT json_data->>'linename' l ,k ,json_data->>k v 
 FROM copperline, lateral json_object_keys( json_data ) k WHERE json_data->>'linename' LIKE '40000100188';
 
SELECT service_name,service_type,crm_customer_id,   crm_contract_id ,  STATUS,k->'key' k,k->'value' v 
 FROM service , lateral json_array_elements( json_data->'attributes' ) k   
WHERE service_type LIKE 'ACCESS%'