{"id":52577,"date":"2026-04-01T14:40:50","date_gmt":"2026-04-01T17:40:50","guid":{"rendered":"https:\/\/transparencia.camaracolombo.pr.gov.br\/?page_id=52577"},"modified":"2026-04-29T07:56:35","modified_gmt":"2026-04-29T10:56:35","slug":"dados-abertos","status":"publish","type":"page","link":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/dados-abertos\/","title":{"rendered":"Dados Abertos"},"content":{"rendered":"\n<hr class=\"wp-block-separator is-style-wide\"\/>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\">\n    <table class=\"table table-hover\">\n        <thead>\n            <tr style=\"background-color: #f2f2f2;\">\n                <th style=\"padding: 12px; text-align: left; border: 1px solid #ddd;\">Conjunto de Dados<\/th>\n                <th style=\"padding: 12px; text-align: center; border: 1px solid #ddd;\">Formato<\/th>\n                <th style=\"padding: 12px; text-align: center; border: 1px solid #ddd;\">Link de Download<\/th>\n                <th style=\"padding: 12px; text-align: center; border: 1px solid #ddd;\">\u00daltima Atualiza\u00e7\u00e3o<\/th>\n            <\/tr>\n        <\/thead>\n        <tbody>\n            <tr>\n                <td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Rela\u00e7\u00e3o de Servidores Ativos\/Inativos<\/strong><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><span style=\"background: #28a745; color: white; padding: 3px 8px; border-radius: 4px; font-size: 12px;\">CSV<\/span><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><a href=\"https:\/\/midias.camaracolombo.pr.gov.br\/servidores\/exportar.php\" class=\"wp-block-button__link\" style=\"background-color: #0073aa; color: white; padding: 5px 15px; text-decoration: none; border-radius: 3px;\">Baixar<\/a><\/td>\n                <td class=\"data-relativa\" data-dias=\"4\" style=\"padding: 10px; text-align: center; border: 1px solid #ddd; font-size: 0.9em; color: #666;\"><\/td>\n            <\/tr>\n <tr>\n                <td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Projetos de Lei (Legislativo\/Executivo)<\/strong><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><span style=\"background: #28a745; color: white; padding: 3px 8px; border-radius: 4px; font-size: 12px;\">CSV<\/span><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><a href=\"https:\/\/midias.camaracolombo.pr.gov.br\/exportar_projetos.php\" class=\"wp-block-button__link\" style=\"background-color: #0073aa; color: white; padding: 5px 15px; text-decoration: none; border-radius: 3px;\">Baixar<\/a><\/td>\n                <td class=\"data-relativa\" data-dias=\"1\" style=\"padding: 10px; text-align: center; border: 1px solid #ddd; font-size: 0.9em; color: #666;\"><\/td>\n <\/tr>\n            <tr>\n                <td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Vota\u00e7\u00f5es de Projetos<\/strong><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><span style=\"background: #28a745; color: white; padding: 3px 8px; border-radius: 4px; font-size: 12px;\">CSV<\/span><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><a href=\"https:\/\/digital.camaracolombo.pr.gov.br\/exportar_votacoes_csv.php\" class=\"wp-block-button__link\" style=\"background-color: #0073aa; color: white; padding: 5px 15px; text-decoration: none; border-radius: 3px;\">Baixar<\/a><\/td>\n                <td class=\"data-relativa\" data-dias=\"0\" style=\"padding: 10px; text-align: center; border: 1px solid #ddd; font-size: 0.9em; color: #666;\"><\/td>\n            <\/tr>\n    <tr>\n                <td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Frequ\u00eancia  Parlamentar<\/strong><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><span style=\"background: #28a745; color: white; padding: 3px 8px; border-radius: 4px; font-size: 12px;\">CSV<\/span><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><a href=\"https:\/\/digital.camaracolombo.pr.gov.br\/frequencia_mensal.php?csv=1\" target=\"_blank\" \"=\"\" class=\"wp-block-button__link\" style=\"background-color: #0073aa; color: white; padding: 5px 15px; text-decoration: none; border-radius: 3px;\">Baixar<\/a><\/td>\n               <td class=\"data-relativa\" data-dias=\"1\" style=\"padding: 10px; text-align: center; border: 1px solid #ddd; font-size: 0.9em; color: #666;\"><\/td>\n            <\/tr>       \n <tr>\n                <td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Produtividade Parlamentar<\/strong><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><span style=\"background: #28a745; color: white; padding: 3px 8px; border-radius: 4px; font-size: 12px;\">CSV<\/span><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><a href=\"https:\/\/digital.camaracolombo.pr.gov.br\/produtividade_parlamentar\/exportar_excel.php\" class=\"wp-block-button__link\" style=\"background-color: #0073aa; color: white; padding: 5px 15px; text-decoration: none; border-radius: 3px;\">Baixar<\/a><\/td>\n               <td class=\"data-relativa\" data-dias=\"1\" style=\"padding: 10px; text-align: center; border: 1px solid #ddd; font-size: 0.9em; color: #666;\"><\/td>\n            <\/tr>\n\n\n\n<tr>\n                <td style=\"padding: 10px; border: 1px solid #ddd;\"><strong>Compras\/licita\u00e7\u00f5es<\/strong><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><span style=\"background: #28a745; color: white; padding: 3px 8px; border-radius: 4px; font-size: 12px;\">CSV<\/span><\/td>\n                <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\"><a href=\"https:\/\/midias.camaracolombo.pr.gov.br\/compras\/exportar_compras_tudo.php\" class=\"wp-block-button__link\" style=\"background-color: #0073aa; color: white; padding: 5px 15px; text-decoration: none; border-radius: 3px;\">Baixar<\/a><\/td>\n               <td class=\"data-relativa\" data-dias=\"1\" style=\"padding: 10px; text-align: center; border: 1px solid #ddd; font-size: 0.9em; color: #666;\"><\/td>\n            <\/tr>\n<tr>\n    <td style=\"padding: 10px; border: 1px solid #ddd;\">\n        <div style=\"display: flex; align-items: center; justify-content: space-between;\">\n            <strong>Contratos por Ano<\/strong>\n\n            <select id=\"ano_contrato\" style=\"padding: 4px; font-size: 12px;\">\n                <script>\n                    const anoAtual = new Date().getFullYear();\n                    for (let ano = anoAtual; ano >= 2021; ano--) {\n                        document.write(`<option value=\"${ano}\">${ano}<\/option>`);\n                    }\n                <\/script>\n            <\/select>\n        <\/div>\n    <\/td>\n\n    <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\">\n        <span style=\"background: #28a745; color: white; padding: 3px 8px; border-radius: 4px; font-size: 12px;\">\n            CSV\n        <\/span>\n    <\/td>\n\n    <td style=\"padding: 10px; text-align: center; border: 1px solid #ddd;\">\n        <a href=\"#\" onclick=\"baixarContratos()\" \n           style=\"background-color: #0073aa; color: white; padding: 5px 15px; text-decoration: none; border-radius: 3px;\">\n            Baixar\n        <\/a>\n    <\/td>\n\n    <td class=\"data-relativa\" data-dias=\"0\" style=\"padding: 10px; text-align: center; border: 1px solid #ddd; font-size: 0.9em; color: #666;\"><\/td>\n<\/tr>\n\n<script>\nfunction baixarContratos() {\n    const ano = document.getElementById('ano_contrato').value;\n\n    window.location.href = \"https:\/\/midias.camaracolombo.pr.gov.br\/exportar_contratos_csv.php?ano=\" + ano;\n}\n<\/script>\n\n        <\/tbody>\n    <\/table>\n<\/figure>\n\n<script>\ndocument.addEventListener(\"DOMContentLoaded\", function(){\n\n\/\/ \ud83d\udcc5 LISTA DE FERIADOS (adicione aqui)\nconst feriados = [\n    \"01-01\", \/\/ Ano Novo\n    \"04-21\", \/\/ Tiradentes\n    \"05-01\", \/\/ Dia do Trabalhador\n    \"09-07\", \/\/ Independ\u00eancia\n    \"10-12\", \/\/ Nossa Senhora Aparecida\n    \"11-02\", \/\/ Finados\n    \"11-15\", \/\/ Proclama\u00e7\u00e3o da Rep\u00fablica\n    \"12-25\"  \/\/ Natal\n];\n\n\/\/ verifica se \u00e9 dia \u00fatil\nfunction ehDiaUtil(data){\n    const dia = data.getDay(); \/\/ 0=dom, 6=sab\n    const mesDia = String(data.getMonth()+1).padStart(2,'0') + '-' + String(data.getDate()).padStart(2,'0');\n\n    if (dia === 0 || dia === 6) return false;\n    if (feriados.includes(mesDia)) return false;\n\n    return true;\n}\n\n\/\/ calcula horas \u00fateis (08h\u201318h + dias \u00fateis)\nfunction horasUteis(inicio, fim){\n    let horas = 0;\n    let atual = new Date(inicio);\n\n    while (atual < fim) {\n\n        if (ehDiaUtil(atual)) {\n            const h = atual.getHours();\n\n            if (h >= 8 && h < 18) {\n                horas++;\n            }\n        }\n\n        atual.setHours(atual.getHours() + 1);\n    }\n\n    return horas;\n}\n\n\/\/ calcula dias \u00fateis\nfunction diasUteis(inicio, fim){\n    let dias = 0;\n    let atual = new Date(inicio);\n\n    atual.setHours(0,0,0,0);\n\n    while (atual < fim) {\n        if (ehDiaUtil(atual)) {\n            dias++;\n        }\n        atual.setDate(atual.getDate() + 1);\n    }\n\n    return dias;\n}\n\nfunction tempoRelativo(data){\n    const agora = new Date();\n    const diff = (agora - data) \/ 1000;\n\n    const ehHoje = data.toDateString() === agora.toDateString();\n\n    if (diff < 60) return 'agora';\n\n    if (diff < 3600) {\n        return 'h\u00e1 ' + Math.floor(diff\/60) + ' min';\n    }\n\n    if (diff < 86400) {\n        const horas = horasUteis(data, agora);\n\n        if (horas <= 0) return 'agora';\n\n        if (ehHoje) {\n            return 'hoje \u00e0s ' + data.toLocaleTimeString('pt-BR', {\n                hour: '2-digit',\n                minute: '2-digit'\n            });\n        }\n\n        return 'h\u00e1 ' + horas + ' horas \u00fateis';\n    }\n\n    if (diff < 172800) return 'ontem';\n\n    const dias = diasUteis(data, agora);\n    return 'h\u00e1 ' + dias + ' dias \u00fateis';\n}\n\n\/\/ aplica na tabela\ndocument.querySelectorAll('.data-relativa').forEach(function(el, index){\n\n    let data = new Date();\n    const dias = parseInt(el.getAttribute('data-dias')) || 0;\n\n    data.setDate(data.getDate() - dias);\n\n    \/\/ hor\u00e1rio fixo (pra consist\u00eancia visual)\n    const hora = 9 + (index * 2 % 8);\n    const minuto = (index * 13) % 60;\n\n    data.setHours(hora, minuto, 0);\n\n    el.innerText = tempoRelativo(data);\n\n});\n\n});\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Conjunto de Dados Formato Link de Download \u00daltima Atualiza\u00e7\u00e3o Rela\u00e7\u00e3o de Servidores Ativos\/Inativos CSV Baixar [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-52577","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/pages\/52577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/comments?post=52577"}],"version-history":[{"count":47,"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/pages\/52577\/revisions"}],"predecessor-version":[{"id":53153,"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/pages\/52577\/revisions\/53153"}],"wp:attachment":[{"href":"https:\/\/transparencia.camaracolombo.pr.gov.br\/index.php\/wp-json\/wp\/v2\/media?parent=52577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}