apuracao_eleicoes_2022.sql

-- git@github.com:pramsey/pgsql-http.git
CREATE EXTENSION http;
WITH dados AS (
    SELECT
        content::jsonb AS obj, 1::integer AS turno  
    FROM
        http_get('https://resultados.tse.jus.br/oficial/ele2022/544/dados-simplificados/br/br-c0001-e000544-r.json')
    UNION
    SELECT
        content::jsonb AS obj, 2::integer AS turno  
    FROM
        http_get('https://resultados.tse.jus.br/oficial/ele2022/545/dados-simplificados/br/br-c0001-e000545-r.json')
),
cand AS (
    SELECT jsonb_array_elements(obj->'cand') AS obj, turno FROM dados
)
SELECT obj->>'nm' AS "Candidato", (obj->>'vap')::int AS "Votos", (replace(obj->>'pvap', ',', '.'))::numeric AS "%"
FROM cand
WHERE turno = 2;