{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\pymysql\\_auth.py:9: CryptographyDeprecationWarning: Python 3.7 is no longer supported by the Python core team and support for it is deprecated in cryptography. A future release of cryptography will remove support for Python 3.7.\n",
      "  from cryptography.hazmat.backends import default_backend\n"
     ]
    }
   ],
   "source": [
    "import pymysql\n",
    "\n",
    "# Função para conectar ao banco de dados MySQL\n",
    "def conectar_banco():\n",
    "    try:\n",
    "        conexao = pymysql.connect(\n",
    "            host=\"localhost\",         # Ex: \"localhost\"\n",
    "            user=\"captura_sites2\",      # Ex: \"root\"\n",
    "            password=\"Cristin@10\",    # Senha do seu banco de dados\n",
    "            database=\"sites_pesquisa\"\n",
    "        )\n",
    "        print(\"Conexão bem-sucedida!\")\n",
    "        return conexao, conexao.cursor()\n",
    "    except pymysql.MySQLError as e:\n",
    "        print(f\"Erro ao conectar ao banco de dados: {e}\")\n",
    "        return None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[nltk_data] Downloading package stopwords to\n",
      "[nltk_data]     C:\\Users\\Cliente\\AppData\\Roaming\\nltk_data...\n",
      "[nltk_data]   Package stopwords is already up-to-date!\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "from sentence_transformers import SentenceTransformer, util\n",
    "import nltk\n",
    "import spacy\n",
    "import re\n",
    "from nltk.corpus import stopwords\n",
    "\n",
    "# Baixar stopwords em português do nltk\n",
    "nltk.download('stopwords')\n",
    "stop_words = set(stopwords.words('portuguese'))\n",
    "\n",
    "# Carregar modelo do spaCy para português\n",
    "nlp = spacy.load(\"pt_core_news_sm\")\n",
    "\n",
    "# Função para coletar links do site\n",
    "def coletar_links(site):\n",
    "    resposta = requests.get(site)\n",
    "    soup = BeautifulSoup(resposta.content, 'html.parser')\n",
    "    links = []\n",
    "    for link in soup.find_all('a', href=True):\n",
    "        url = link['href']\n",
    "        if url.startswith('http'):\n",
    "            links.append(url)\n",
    "    return links\n",
    "\n",
    "# Função para extrair frases da página HTML\n",
    "def extrair_frases(site):\n",
    "    resposta = requests.get(site)\n",
    "    soup = BeautifulSoup(resposta.content, 'html.parser')\n",
    "    texto = soup.get_text()\n",
    "    frases = texto.split('.')\n",
    "    return [frase.strip() for frase in frases if frase.strip()]\n",
    "\n",
    "# Função para remover caracteres especiais, stopwords e fazer lematização de uma frase\n",
    "def limpar_e_lematizar_frase(frase):\n",
    "    # Remover caracteres especiais\n",
    "    frase = re.sub(r'[^\\w\\s]', '', frase)\n",
    "    # Processar a frase com spaCy\n",
    "    doc = nlp(frase)\n",
    "    # Remover stopwords e fazer lematização\n",
    "    frase_limpa = ' '.join([token.lemma_ for token in doc if token.text.lower() not in stop_words])\n",
    "    return frase_limpa\n",
    "\n",
    "# Função para limpar e lematizar uma lista de frases\n",
    "def limpar_e_lematizar_frases(frases):\n",
    "    return [limpar_e_lematizar_frase(frase) for frase in frases]\n",
    "\n",
    "# Função para contar a similaridade de frases\n",
    "def contar_similaridade(frases_html, frases_categoria):\n",
    "    # Carregar modelo pré-treinado\n",
    "    modelo = SentenceTransformer('paraphrase-MiniLM-L6-v2')\n",
    "    # Calcular embeddings das frases\n",
    "    embeddings_html = modelo.encode(frases_html, convert_to_tensor=True)\n",
    "    embeddings_categoria = modelo.encode(frases_categoria, convert_to_tensor=True)\n",
    "    # Calcular similaridade\n",
    "    similaridade = util.pytorch_cos_sim(embeddings_html, embeddings_categoria)\n",
    "    return similaridade\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def executar_comando(cursor, comando, parametros=None):\n",
    "    try:\n",
    "        if parametros:\n",
    "            cursor.execute(comando, parametros)\n",
    "        else:\n",
    "            cursor.execute(comando)\n",
    "    except pymysql.err.InterfaceError:\n",
    "        # Reestabelecer a conexão se necessário\n",
    "        conexao, cursor = conectar_banco()\n",
    "        if parametros:\n",
    "            cursor.execute(comando, parametros)\n",
    "        else:\n",
    "            cursor.execute(comando)\n",
    "    return cursor\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Conexão bem-sucedida!\n",
      "PR - Bituruna\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Some characters could not be decoded, and were replaced with REPLACEMENT CHARACTER.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link https://transparencia.bituruna.pr.gov.br/portal-covid/: HTTPSConnectionPool(host='transparencia.bituruna.pr.gov.br', port=443): Max retries exceeded with url: /portal-covid/ (Caused by SSLError(SSLError(1, '[SSL: SSLV3_ALERT_HANDSHAKE_FAILURE] sslv3 alert handshake failure (_ssl.c:1076)')))\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "PR - Boa Vista da Aparecida\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://portal.boavistadaaparecida.pr.gov.br:8089/WebEloPortalRH/: stack expects a non-empty TensorList\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www.camboavi.pr.gov.br/: stack expects a non-empty TensorList\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www.pr.gov.br/: stack expects a non-empty TensorList\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www.sefa.pr.gov.br/: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www.cidadao.pr.gov.br/modules/conteudo/conteudo.php?conteudo=290: HTTPConnectionPool(host='www.cidadao.pr.gov.br', port=80): Max retries exceeded with url: /modules/conteudo/conteudo.php?conteudo=290 (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E2BC348>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www2.planalto.gov.br/: ('Connection aborted.', ConnectionAbortedError(10053, 'Uma conexão estabelecida foi anulada pelo software no computador host', None, 10053, None))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www.brasil.gov.br/: HTTPConnectionPool(host='www.brasil.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339E88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www.senado.gov.br/: HTTPConnectionPool(host='www.senado.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F537FB3A08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://www2.camara.leg.br/: HTTPConnectionPool(host='www2.camara.leg.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339088>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link https://api.whatsapp.com/send?phone=5541936180695: HTTPSConnectionPool(host='api.whatsapp.com', port=443): Max retries exceeded with url: /send?phone=5541936180695 (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339748>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://portal.boavistadaaparecida.pr.gov.br:8090/portaltransparencia/1/organograma: HTTPConnectionPool(host='portal.boavistadaaparecida.pr.gov.br', port=8090): Max retries exceeded with url: /portaltransparencia/1/organograma (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339408>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://portal.boavistadaaparecida.pr.gov.br:8090/portaltransparencia/1: HTTPConnectionPool(host='portal.boavistadaaparecida.pr.gov.br', port=8090): Max retries exceeded with url: /portaltransparencia/1 (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link https://leismunicipais.com.br/prefeitura/pr/boavistadaaparecida: HTTPSConnectionPool(host='leismunicipais.com.br', port=443): Max retries exceeded with url: /prefeitura/pr/boavistadaaparecida (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Erro ao processar o link http://portal.boavistadaaparecida.pr.gov.br:8090/protocolo/ouvidoria: HTTPConnectionPool(host='portal.boavistadaaparecida.pr.gov.br', port=8090): Max retries exceeded with url: /protocolo/ouvidoria (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339288>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "Conexão bem-sucedida!\n",
      "PR - Borrazópolis\n",
      "Erro ao processar o munícipio Borrazópolis: HTTPSConnectionPool(host='borrazopolis.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339BC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Braganey\n",
      "Erro ao processar o munícipio Braganey: HTTPSConnectionPool(host='www.pmbraganey.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339FC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cafezal do Sul\n",
      "Erro ao processar o munícipio Cafezal do Sul: HTTPConnectionPool(host='www.cafezaldosul.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339448>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cambará\n",
      "Erro ao processar o munícipio Cambará: HTTPSConnectionPool(host='cambara.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3392C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cambira\n",
      "Erro ao processar o munícipio Cambira: HTTPSConnectionPool(host='www.cambira.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339408>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Campo do Tenente\n",
      "Erro ao processar o munícipio Campo do Tenente: HTTPSConnectionPool(host='www.campodotenente.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339308>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Campo Largo\n",
      "Erro ao processar o munícipio Campo Largo: HTTPSConnectionPool(host='campolargo.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3B08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Campo Magro\n",
      "Erro ao processar o munícipio Campo Magro: HTTPSConnectionPool(host='campomagro.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3E48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Campo Mourão\n",
      "Erro ao processar o munícipio Campo Mourão: HTTPSConnectionPool(host='campomourao.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3248>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cândido de Abreu\n",
      "Erro ao processar o munícipio Cândido de Abreu: HTTPSConnectionPool(host='www.candidodeabreu.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3A48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Capitão Leônidas Marques\n",
      "Erro ao processar o munícipio Capitão Leônidas Marques: HTTPSConnectionPool(host='capitaoleonidasmarques.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3F48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Carambeí\n",
      "Erro ao processar o munícipio Carambeí: HTTPSConnectionPool(host='carambei.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3F48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Conexão bem-sucedida!\n",
      "PR - Carlópolis\n",
      "Erro ao processar o munícipio Carlópolis: HTTPSConnectionPool(host='www.carlopolis.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3248>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cascavel\n",
      "Erro ao processar o munícipio Cascavel: HTTPSConnectionPool(host='cascavel.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339D48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Castro\n",
      "Erro ao processar o munícipio Castro: HTTPSConnectionPool(host='castro.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339C88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cianorte\n",
      "Erro ao processar o munícipio Cianorte: HTTPSConnectionPool(host='www.cianorte.pr.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3391C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cidade Gaúcha\n",
      "Erro ao processar o munícipio Cidade Gaúcha: HTTPSConnectionPool(host='www.cidadegaucha.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339B48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Colombo\n",
      "Erro ao processar o munícipio Colombo: HTTPConnectionPool(host='prefeitura.colombo.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339B48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Colorado\n",
      "Erro ao processar o munícipio Colorado: HTTPSConnectionPool(host='colorado.pr.gov.br', port=443): Max retries exceeded with url: /n/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E37C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Corbélia\n",
      "Erro ao processar o munícipio Corbélia: HTTPSConnectionPool(host='corbelia.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3B48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cruz Machado\n",
      "Erro ao processar o munícipio Cruz Machado: HTTPSConnectionPool(host='pmcm.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D2455C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Cruzeiro do Oeste\n",
      "Erro ao processar o munícipio Cruzeiro do Oeste: HTTPConnectionPool(host='www.cruzeirodooeste.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54D2454C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Curitiba\n",
      "Erro ao processar o munícipio Curitiba: HTTPSConnectionPool(host='www.curitiba.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245588>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Diamante do Norte\n",
      "Erro ao processar o munícipio Diamante do Norte: HTTPSConnectionPool(host='cmdiamantedonorte.pr.gov.br', port=443): Max retries exceeded with url: /cidade (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339E48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Dois Vizinhos\n",
      "Erro ao processar o munícipio Dois Vizinhos: HTTPSConnectionPool(host='doisvizinhos.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339408>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Faxinal\n",
      "Erro ao processar o munícipio Faxinal: HTTPSConnectionPool(host='www.faxinal.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3399C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Fazenda Rio Grande\n",
      "Erro ao processar o munícipio Fazenda Rio Grande: HTTPSConnectionPool(host='www.fazendariogrande.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339E48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Fênix\n",
      "Erro ao processar o munícipio Fênix: HTTPConnectionPool(host='www.fenix.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54D2458C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Fernandes Pinheiro\n",
      "Erro ao processar o munícipio Fernandes Pinheiro: HTTPConnectionPool(host='www.fernandespinheiro.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54D245188>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Foz do Iguaçu\n",
      "Erro ao processar o munícipio Foz do Iguaçu: HTTPSConnectionPool(host='www5.pmfi.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BD808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Francisco Beltrão\n",
      "Erro ao processar o munícipio Francisco Beltrão: HTTPSConnectionPool(host='franciscobeltrao.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BD808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - General Carneiro\n",
      "Erro ao processar o munícipio General Carneiro: HTTPSConnectionPool(host='www.generalcarneiro.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BDF48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Goioerê\n",
      "Erro ao processar o munícipio Goioerê: HTTPSConnectionPool(host='goioere.pr.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245E08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Guarapuava\n",
      "Erro ao processar o munícipio Guarapuava: HTTPSConnectionPool(host='guarapuava.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D2458C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Guaratuba\n",
      "Erro ao processar o munícipio Guaratuba: HTTPSConnectionPool(host='portal.guaratuba.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245B88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Iguaraçu\n",
      "Erro ao processar o munícipio Iguaraçu: HTTPSConnectionPool(host='www.iguaracu.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245748>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Irati\n",
      "Erro ao processar o munícipio Irati: HTTPSConnectionPool(host='www.irati.pr.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BD608>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Itaguajé\n",
      "Erro ao processar o munícipio Itaguajé: HTTPSConnectionPool(host='www.itaguaje.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245A48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Itaipulândia\n",
      "Erro ao processar o munícipio Itaipulândia: HTTPSConnectionPool(host='www.itaipulandia.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245A48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Ivaiporã\n",
      "Erro ao processar o munícipio Ivaiporã: HTTPSConnectionPool(host='www.ivaipora.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245A48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Jacarezinho\n",
      "Erro ao processar o munícipio Jacarezinho: HTTPSConnectionPool(host='www.jacarezinho.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245A48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PR - Japurá\n",
      "Erro ao processar o munícipio Japurá: HTTPSConnectionPool(host='www.japura.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D2458C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Jardim Alegre\n",
      "Erro ao processar o munícipio Jardim Alegre: HTTPSConnectionPool(host='www.jardimalegre.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Juranda\n",
      "Erro ao processar o munícipio Juranda: HTTPSConnectionPool(host='juranda.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245148>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Lapa\n",
      "Erro ao processar o munícipio Lapa: HTTPSConnectionPool(host='lapa.atende.net', port=443): Max retries exceeded with url: /cidadao (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339E48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Loanda\n",
      "Erro ao processar o munícipio Loanda: HTTPSConnectionPool(host='loanda.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Londrina\n",
      "Erro ao processar o munícipio Londrina: HTTPSConnectionPool(host='portal.londrina.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339A88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Lunardelli\n",
      "Erro ao processar o munícipio Lunardelli: HTTPSConnectionPool(host='lunardelli.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Mandaguaçu\n",
      "Erro ao processar o munícipio Mandaguaçu: HTTPSConnectionPool(host='www.mandaguacu.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339F88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Mandaguari\n",
      "Erro ao processar o munícipio Mandaguari: HTTPSConnectionPool(host='www.mandaguari.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339048>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Mandirituba\n",
      "Erro ao processar o munícipio Mandirituba: HTTPSConnectionPool(host='mandirituba.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339EC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Manoel Ribas\n",
      "Erro ao processar o munícipio Manoel Ribas: HTTPSConnectionPool(host='www.manoelribas.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3B48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Marechal Cândido Rondon\n",
      "Erro ao processar o munícipio Marechal Cândido Rondon: HTTPSConnectionPool(host='marechalcandidorondon.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339EC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Marilena\n",
      "Erro ao processar o munícipio Marilena: HTTPSConnectionPool(host='marilena.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BDC88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Maringá\n",
      "Erro ao processar o munícipio Maringá: HTTPSConnectionPool(host='www.maringa.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BDA48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Maripá\n",
      "Erro ao processar o munícipio Maripá: HTTPSConnectionPool(host='maripa.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BD388>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Mato Rico\n",
      "Erro ao processar o munícipio Mato Rico: HTTPSConnectionPool(host='matorico.pr.gov.br', port=443): Max retries exceeded with url: /portal/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Medianeira\n",
      "Erro ao processar o munícipio Medianeira: HTTPSConnectionPool(host='www.medianeira.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339148>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Moreira Sales\n",
      "Erro ao processar o munícipio Moreira Sales: HTTPSConnectionPool(host='www.moreirasales.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339408>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Morretes\n",
      "Erro ao processar o munícipio Morretes: HTTPSConnectionPool(host='www.morretes.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339208>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Nova Londrina\n",
      "Erro ao processar o munícipio Nova Londrina: HTTPSConnectionPool(host='www.novalondrina.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245648>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Nova Tebas\n",
      "Erro ao processar o munícipio Nova Tebas: HTTPSConnectionPool(host='www.novatebas.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Ortigueira\n",
      "Erro ao processar o munícipio Ortigueira: HTTPConnectionPool(host='www.ortigueira.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Paiçandu\n",
      "Erro ao processar o munícipio Paiçandu: HTTPConnectionPool(host='www.paicandu.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Palmeira\n",
      "Erro ao processar o munícipio Palmeira: HTTPSConnectionPool(host='palmeira.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Palotina\n",
      "Erro ao processar o munícipio Palotina: HTTPSConnectionPool(host='palotina.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F545D7A908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Paranaguá\n",
      "Erro ao processar o munícipio Paranaguá: HTTPSConnectionPool(host='www.paranagua.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3B48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Paranavaí\n",
      "Erro ao processar o munícipio Paranavaí: HTTPSConnectionPool(host='paranavai.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E3B48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Pato Bragado\n",
      "Erro ao processar o munícipio Pato Bragado: HTTPSConnectionPool(host='patobragado.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2E37C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Paulo Frontin\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Erro ao processar o munícipio Paulo Frontin: HTTPSConnectionPool(host='www.paulofrontin.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5888>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Pinhais\n",
      "Erro ao processar o munícipio Pinhais: HTTPSConnectionPool(host='pinhais.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F57C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Piraí do Sul\n",
      "Erro ao processar o munícipio Piraí do Sul: HTTPSConnectionPool(host='www.piraidosul.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5D88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Piraquara\n",
      "Erro ao processar o munícipio Piraquara: HTTPSConnectionPool(host='www.piraquara.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5C88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Pitanga\n",
      "Erro ao processar o munícipio Pitanga: HTTPSConnectionPool(host='www.pitanga.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F50C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Planaltina do Paraná\n",
      "Erro ao processar o munícipio Planaltina do Paraná: HTTPConnectionPool(host='www.planaltinadoparana.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F546B777C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Ponta Grossa\n",
      "Erro ao processar o munícipio Ponta Grossa: HTTPSConnectionPool(host='www.pontagrossa.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339C88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Pontal do Paraná\n",
      "Erro ao processar o munícipio Pontal do Paraná: HTTPConnectionPool(host='www.pontaldoparana.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339848>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Porto Rico\n",
      "Erro ao processar o munícipio Porto Rico: HTTPConnectionPool(host='www.portorico.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339888>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Prudentópolis\n",
      "Erro ao processar o munícipio Prudentópolis: HTTPSConnectionPool(host='sistemas.prudentopolis.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Quatro Barras\n",
      "Erro ao processar o munícipio Quatro Barras: HTTPSConnectionPool(host='www.quatrobarras.pr.gov.br', port=443): Max retries exceeded with url: /home.php (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5E08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Querência do Norte\n",
      "Erro ao processar o munícipio Querência do Norte: HTTPConnectionPool(host='www.querenciadonorte.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E2F5EC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Quitandinha\n",
      "Erro ao processar o munícipio Quitandinha: HTTPSConnectionPool(host='www.quitandinha.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339EC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Ribeirão Claro\n",
      "Erro ao processar o munícipio Ribeirão Claro: HTTPSConnectionPool(host='www.ribeiraoclaro.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5B08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Rio Bom\n",
      "Erro ao processar o munícipio Rio Bom: HTTPSConnectionPool(host='www.riobom.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Rio Branco do Ivaí\n",
      "Erro ao processar o munícipio Rio Branco do Ivaí: HTTPSConnectionPool(host='riobrancodoivai.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245748>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Rio Branco do Sul\n",
      "Erro ao processar o munícipio Rio Branco do Sul: HTTPSConnectionPool(host='riobrancodosul.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339C88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Rio Negro\n",
      "Erro ao processar o munícipio Rio Negro: HTTPSConnectionPool(host='rionegro.atende.net', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Roncador\n",
      "Erro ao processar o munícipio Roncador: HTTPSConnectionPool(host='www.roncador.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5EC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Rondon\n",
      "Erro ao processar o munícipio Rondon: HTTPSConnectionPool(host='www.rondon.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339EC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Rosário do Ivaí\n",
      "Erro ao processar o munícipio Rosário do Ivaí: HTTPConnectionPool(host='www.rosariodoivai.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339DC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Salto do Lontra\n",
      "Erro ao processar o munícipio Salto do Lontra: HTTPConnectionPool(host='www.saltodolontra.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E339CC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Santa Fé\n",
      "Erro ao processar o munícipio Santa Fé: HTTPSConnectionPool(host='www.santafe.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339CC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Santa Isabel do Ivaí\n",
      "Erro ao processar o munícipio Santa Isabel do Ivaí: HTTPSConnectionPool(host='santaisabeldoivai.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F545837D88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PR - Santa Izabel do Oeste\n",
      "Erro ao processar o munícipio Santa Izabel do Oeste: HTTPSConnectionPool(host='santaizabeldooeste.atende.net', port=443): Max retries exceeded with url: /cidadao (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245FC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Santa Maria do Oeste\n",
      "Erro ao processar o munícipio Santa Maria do Oeste: HTTPSConnectionPool(host='santamariadooeste.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5848>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Santa Terezinha de Itaipu\n",
      "Erro ao processar o munícipio Santa Terezinha de Itaipu: HTTPSConnectionPool(host='stitaipu.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Santo Antônio da Platina\n",
      "Erro ao processar o munícipio Santo Antônio da Platina: HTTPSConnectionPool(host='santoantoniodaplatina.atende.net', port=443): Max retries exceeded with url: /cidadao (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5088>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Santo Antônio do Sudoeste\n",
      "Erro ao processar o munícipio Santo Antônio do Sudoeste: HTTPSConnectionPool(host='pmsas.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339D48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Santo Inácio\n",
      "Erro ao processar o munícipio Santo Inácio: HTTPConnectionPool(host='www.santoinacio.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E2F51C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - São João do Ivaí\n",
      "Erro ao processar o munícipio São João do Ivaí: HTTPSConnectionPool(host='www.saojoaodoivai.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F51C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - São Jorge d'Oeste\n",
      "Erro ao processar o munícipio São Jorge d'Oeste: HTTPSConnectionPool(host='pmsjorge.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339BC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - São José dos Pinhais\n",
      "Erro ao processar o munícipio São José dos Pinhais: HTTPSConnectionPool(host='www.sjp.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339DC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - São Mateus do Sul\n",
      "Erro ao processar o munícipio São Mateus do Sul: HTTPSConnectionPool(host='www.saomateusdosul.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5A88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - São Pedro do Paraná\n",
      "Erro ao processar o munícipio São Pedro do Paraná: HTTPSConnectionPool(host='www.saopedrodoparana.pr.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5E08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Sapopema\n",
      "Erro ao processar o munícipio Sapopema: HTTPSConnectionPool(host='www.sapopema.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245148>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Sengés\n",
      "Erro ao processar o munícipio Sengés: HTTPSConnectionPool(host='www.senges.pr.gov.br', port=443): Max retries exceeded with url: /portal/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245708>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Sertaneja\n",
      "Erro ao processar o munícipio Sertaneja: HTTPSConnectionPool(host='www.sertaneja.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245708>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Siqueira Campos\n",
      "Erro ao processar o munícipio Siqueira Campos: HTTPSConnectionPool(host='www.siqueiracampos.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303308>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Sulina\n",
      "Erro ao processar o munícipio Sulina: HTTPSConnectionPool(host='www.sulina.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Tapejara\n",
      "Erro ao processar o munícipio Tapejara: HTTPConnectionPool(host='www.tapejara.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E303E88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Teixeira Soares\n",
      "Erro ao processar o munícipio Teixeira Soares: HTTPConnectionPool(host='www.teixeirasoares.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E303088>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Terra Boa\n",
      "Erro ao processar o munícipio Terra Boa: HTTPSConnectionPool(host='terraboa.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303A88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Terra Rica\n",
      "Erro ao processar o munícipio Terra Rica: HTTPConnectionPool(host='www.terrarica.pr.gov.br', port=80): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x000001F54E2FFB08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Tibagi\n",
      "Erro ao processar o munícipio Tibagi: HTTPSConnectionPool(host='www.tibagi.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54D245B88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Tijucas do Sul\n",
      "Erro ao processar o munícipio Tijucas do Sul: HTTPSConnectionPool(host='tijucasdosul.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303A88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Toledo\n",
      "Erro ao processar o munícipio Toledo: HTTPSConnectionPool(host='www.toledo.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303FC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Tomazina\n",
      "Erro ao processar o munícipio Tomazina: HTTPSConnectionPool(host='www.tomazina.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3032C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "PR - Três Barras do Paraná\n",
      "Erro ao processar o munícipio Três Barras do Paraná: HTTPSConnectionPool(host='tresbarras.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303208>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - União da Vitória\n",
      "Erro ao processar o munícipio União da Vitória: HTTPSConnectionPool(host='uniaodavitoria.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339CC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Vera Cruz do Oeste\n",
      "Erro ao processar o munícipio Vera Cruz do Oeste: HTTPSConnectionPool(host='www.veracruz.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339CC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "PR - Verê\n",
      "Erro ao processar o munícipio Verê: HTTPSConnectionPool(host='www.vere.pr.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Angra dos Reis\n",
      "Erro ao processar o munícipio Angra dos Reis: HTTPSConnectionPool(host='www.angra.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303B08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Araruama\n",
      "Erro ao processar o munícipio Araruama: HTTPSConnectionPool(host='www.araruama.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5888>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Areal\n",
      "Erro ao processar o munícipio Areal: HTTPSConnectionPool(host='areal.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303648>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Armação dos Búzios\n",
      "Erro ao processar o munícipio Armação dos Búzios: HTTPSConnectionPool(host='buzios.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Arraial do Cabo\n",
      "Erro ao processar o munícipio Arraial do Cabo: HTTPSConnectionPool(host='www.arraial.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303448>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Barra do Piraí\n",
      "Erro ao processar o munícipio Barra do Piraí: HTTPSConnectionPool(host='portalbarradopirai.com.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E303C48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Barra Mansa\n",
      "Erro ao processar o munícipio Barra Mansa: HTTPSConnectionPool(host='barramansa.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Bom Jesus do Itabapoana\n",
      "Erro ao processar o munícipio Bom Jesus do Itabapoana: HTTPSConnectionPool(host='bomjesus.rj.gov.br', port=443): Max retries exceeded with url: /home (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5BC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Cabo Frio\n",
      "Erro ao processar o munícipio Cabo Frio: HTTPSConnectionPool(host='cabofrio.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5688>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Cachoeiras de Macacu\n",
      "Erro ao processar o munícipio Cachoeiras de Macacu: HTTPSConnectionPool(host='www.prefeituracachoeiras.com', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5888>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Cambuci\n",
      "Erro ao processar o munícipio Cambuci: HTTPSConnectionPool(host='portal.prefeituradecambuci.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5BC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Campos dos Goytacazes\n",
      "Erro ao processar o munícipio Campos dos Goytacazes: HTTPSConnectionPool(host='campos.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F388>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Cardoso Moreira\n",
      "Erro ao processar o munícipio Cardoso Moreira: HTTPSConnectionPool(host='www.cardosomoreira.rj.gov.br', port=443): Max retries exceeded with url: /home (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5E08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Carmo\n",
      "Erro ao processar o munícipio Carmo: HTTPSConnectionPool(host='www.carmo.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5148>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Comendador Levy Gasparian\n",
      "Erro ao processar o munícipio Comendador Levy Gasparian: HTTPSConnectionPool(host='www.levygasparian.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5BC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Cordeiro\n",
      "Erro ao processar o munícipio Cordeiro: HTTPSConnectionPool(host='cordeiro.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5888>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Duque de Caxias\n",
      "Erro ao processar o munícipio Duque de Caxias: HTTPSConnectionPool(host='duquedecaxias.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Guapimirim\n",
      "Erro ao processar o munícipio Guapimirim: HTTPSConnectionPool(host='guapimirim.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Iguaba Grande\n",
      "Erro ao processar o munícipio Iguaba Grande: HTTPSConnectionPool(host='iguaba.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Itaguaí\n",
      "Erro ao processar o munícipio Itaguaí: HTTPSConnectionPool(host='novoportal.itaguai.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RJ - Italva\n",
      "Erro ao processar o munícipio Italva: HTTPSConnectionPool(host='italva.rj.gov.br', port=443): Max retries exceeded with url: /home (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5888>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Itaperuna\n",
      "Erro ao processar o munícipio Itaperuna: HTTPSConnectionPool(host='www.itaperuna.rj.gov.br', port=443): Max retries exceeded with url: /pmi/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FB88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Itatiaia\n",
      "Erro ao processar o munícipio Itatiaia: HTTPSConnectionPool(host='itatiaia.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F548>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Japeri\n",
      "Erro ao processar o munícipio Japeri: HTTPSConnectionPool(host='www.japeri.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F288>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Macaé\n",
      "Erro ao processar o munícipio Macaé: HTTPSConnectionPool(host='www.macae.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F888>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Macuco\n",
      "Erro ao processar o munícipio Macuco: HTTPSConnectionPool(host='prefeituramacuco.rj.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F9C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Magé\n",
      "Erro ao processar o munícipio Magé: HTTPSConnectionPool(host='mage.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F848>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Mangaratiba\n",
      "Erro ao processar o munícipio Mangaratiba: HTTPSConnectionPool(host='www.mangaratiba.rj.gov.br', port=443): Max retries exceeded with url: /novoportal/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F6C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Maricá\n",
      "Erro ao processar o munícipio Maricá: HTTPSConnectionPool(host='www.marica.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FE08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Mendes\n",
      "Erro ao processar o munícipio Mendes: HTTPSConnectionPool(host='www.mendes.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Miguel Pereira\n",
      "Erro ao processar o munícipio Miguel Pereira: HTTPSConnectionPool(host='miguelpereira.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F2C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Natividade\n",
      "Erro ao processar o munícipio Natividade: HTTPSConnectionPool(host='natividade.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F9C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Niterói\n",
      "Erro ao processar o munícipio Niterói: HTTPSConnectionPool(host='niteroi.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E2F5B88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Nova Friburgo\n",
      "Erro ao processar o munícipio Nova Friburgo: HTTPSConnectionPool(host='www.novafriburgo.rj.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F0C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Nova Iguaçu\n",
      "Erro ao processar o munícipio Nova Iguaçu: HTTPSConnectionPool(host='www.novaiguacu.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FAC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Paraíba do Sul\n",
      "Erro ao processar o munícipio Paraíba do Sul: HTTPSConnectionPool(host='paraibadosul.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FC08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Paraty\n",
      "Erro ao processar o munícipio Paraty: HTTPSConnectionPool(host='www.paraty.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Paty do Alferes\n",
      "Erro ao processar o munícipio Paty do Alferes: HTTPSConnectionPool(host='patydoalferes.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F788>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Petrópolis\n",
      "Erro ao processar o munícipio Petrópolis: HTTPSConnectionPool(host='www.petropolis.rj.gov.br', port=443): Max retries exceeded with url: /pmp/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FA08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Pinheiral\n",
      "Erro ao processar o munícipio Pinheiral: HTTPSConnectionPool(host='pinheiral.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F748>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Piraí\n",
      "Erro ao processar o munícipio Piraí: HTTPSConnectionPool(host='www.pirai.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F788>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Porto Real\n",
      "Erro ao processar o munícipio Porto Real: HTTPSConnectionPool(host='www.portoreal.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Quissamã\n",
      "Erro ao processar o munícipio Quissamã: HTTPSConnectionPool(host='quissama.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Resende\n",
      "Erro ao processar o munícipio Resende: HTTPSConnectionPool(host='resende.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F848>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Rio Bonito\n",
      "Erro ao processar o munícipio Rio Bonito: HTTPSConnectionPool(host='riobonito.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F8C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Rio Claro\n",
      "Erro ao processar o munícipio Rio Claro: HTTPSConnectionPool(host='rioclaro.rj.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F608>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Rio das Flores\n",
      "Erro ao processar o munícipio Rio das Flores: HTTPSConnectionPool(host='www.riodasflores.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Rio das Ostras\n",
      "Erro ao processar o munícipio Rio das Ostras: HTTPSConnectionPool(host='www.riodasostras.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F788>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Rio de Janeiro\n",
      "Erro ao processar o munícipio Rio de Janeiro: HTTPSConnectionPool(host='prefeitura.rio', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F6C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RJ - Santo Antônio de Pádua\n",
      "Erro ao processar o munícipio Santo Antônio de Pádua: HTTPSConnectionPool(host='www.santoantoniodepadua.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F448>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - São João de Meriti\n",
      "Erro ao processar o munícipio São João de Meriti: HTTPSConnectionPool(host='portal.meriti.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FC48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - São Pedro da Aldeia\n",
      "Erro ao processar o munícipio São Pedro da Aldeia: HTTPSConnectionPool(host='pmspa.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FF88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Sapucaia\n",
      "Erro ao processar o munícipio Sapucaia: HTTPSConnectionPool(host='sapucaia.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FF08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Saquarema\n",
      "Erro ao processar o munícipio Saquarema: HTTPSConnectionPool(host='www.saquarema.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FA48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Silva Jardim\n",
      "Erro ao processar o munícipio Silva Jardim: HTTPSConnectionPool(host='www.silvajardim.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F148>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Tanguá\n",
      "Erro ao processar o munícipio Tanguá: HTTPSConnectionPool(host='tangua.rj.gov.br', port=443): Max retries exceeded with url: /home/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F4C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Teresópolis\n",
      "Erro ao processar o munícipio Teresópolis: HTTPSConnectionPool(host='www.teresopolis.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F288>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Trajano de Moraes\n",
      "Erro ao processar o munícipio Trajano de Moraes: HTTPSConnectionPool(host='trajanodemoraes.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F208>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Três Rios\n",
      "Erro ao processar o munícipio Três Rios: HTTPSConnectionPool(host='tresrios.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F588>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Valença\n",
      "Erro ao processar o munícipio Valença: HTTPSConnectionPool(host='valenca.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FF88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RJ - Vassouras\n",
      "Erro ao processar o munícipio Vassouras: HTTPSConnectionPool(host='www.vassouras.rj.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FB88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Acari\n",
      "Erro ao processar o munícipio Acari: HTTPSConnectionPool(host='www.acari.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F8C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Açu\n",
      "Erro ao processar o munícipio Açu: HTTPSConnectionPool(host='assu.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F5C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Alexandria\n",
      "Erro ao processar o munícipio Alexandria: HTTPSConnectionPool(host='alexandria.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FA88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Alto do Rodrigues\n",
      "Erro ao processar o munícipio Alto do Rodrigues: HTTPSConnectionPool(host='altodorodrigues.rn.gov.br', port=443): Max retries exceeded with url: /pagina-inicial/prefeitura-municipal-de-alto-do-rodrigues (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F6C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Angicos\n",
      "Erro ao processar o munícipio Angicos: HTTPSConnectionPool(host='angicos.rn.gov.br', port=443): Max retries exceeded with url: /pagina-inicial/prefeitura-municipal-de-angicos (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F988>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Apodi\n",
      "Erro ao processar o munícipio Apodi: HTTPSConnectionPool(host='apodi.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E339CC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Areia Branca\n",
      "Erro ao processar o munícipio Areia Branca: HTTPSConnectionPool(host='areiabranca.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FB88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Baía Formosa\n",
      "Erro ao processar o munícipio Baía Formosa: HTTPSConnectionPool(host='baiaformosa.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FB88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Brejinho\n",
      "Erro ao processar o munícipio Brejinho: HTTPSConnectionPool(host='brejinho.rn.gov.br', port=443): Max retries exceeded with url: /pagina-inicial/prefeitura-municipal-de-brejinho (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Caicó\n",
      "Erro ao processar o munícipio Caicó: HTTPSConnectionPool(host='caico.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3385C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Canguaretama\n",
      "Erro ao processar o munícipio Canguaretama: HTTPSConnectionPool(host='canguaretama.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338708>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Caraúbas\n",
      "Erro ao processar o munícipio Caraúbas: HTTPSConnectionPool(host='www.caraubas.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FB48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Carnaúba dos Dantas\n",
      "Erro ao processar o munícipio Carnaúba dos Dantas: HTTPSConnectionPool(host='www.carnaubadosdantas.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F108>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Carnaubais\n",
      "Erro ao processar o munícipio Carnaubais: HTTPSConnectionPool(host='www.carnaubais.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F5C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Ceará-Mirim\n",
      "Erro ao processar o munícipio Ceará-Mirim: HTTPSConnectionPool(host='cearamirim.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F108>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Cerro Corá\n",
      "Erro ao processar o munícipio Cerro Corá: HTTPSConnectionPool(host='www.cerrocora.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F108>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Currais Novos\n",
      "Erro ao processar o munícipio Currais Novos: HTTPSConnectionPool(host='curraisnovos.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FF08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RN - Extremoz\n",
      "Erro ao processar o munícipio Extremoz: HTTPSConnectionPool(host='extremoz.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FF08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Felipe Guerra\n",
      "Erro ao processar o munícipio Felipe Guerra: HTTPSConnectionPool(host='www.felipeguerra.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F608>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Florânia\n",
      "Erro ao processar o munícipio Florânia: HTTPSConnectionPool(host='florania.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Galinhos\n",
      "Erro ao processar o munícipio Galinhos: HTTPSConnectionPool(host='www.galinhos.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F608>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Goianinha\n",
      "Erro ao processar o munícipio Goianinha: HTTPSConnectionPool(host='goianinha.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F7C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Guamaré\n",
      "Erro ao processar o munícipio Guamaré: HTTPSConnectionPool(host='guamare.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338A88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Itajá\n",
      "Erro ao processar o munícipio Itajá: HTTPSConnectionPool(host='itaja.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338108>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Lagoa Nova\n",
      "Erro ao processar o munícipio Lagoa Nova: HTTPSConnectionPool(host='lagoanova.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338848>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Lajes\n",
      "Erro ao processar o munícipio Lajes: HTTPSConnectionPool(host='lajes.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3383C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Lajes Pintadas\n",
      "Erro ao processar o munícipio Lajes Pintadas: HTTPSConnectionPool(host='lajespintadas.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338F88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Lucrécia\n",
      "Erro ao processar o munícipio Lucrécia: HTTPSConnectionPool(host='lucrecia.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338A88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Martins\n",
      "Erro ao processar o munícipio Martins: HTTPSConnectionPool(host='martins.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338648>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Maxaranguape\n",
      "Erro ao processar o munícipio Maxaranguape: HTTPSConnectionPool(host='site.maxaranguape.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338D48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Monte das Gameleiras\n",
      "Erro ao processar o munícipio Monte das Gameleiras: HTTPSConnectionPool(host='montedasgameleiras.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Mossoró\n",
      "Erro ao processar o munícipio Mossoró: HTTPSConnectionPool(host='prefeiturademossoro.com.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FC48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Natal\n",
      "Erro ao processar o munícipio Natal: HTTPSConnectionPool(host='natal.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338448>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Nísia Floresta\n",
      "Erro ao processar o munícipio Nísia Floresta: HTTPSConnectionPool(host='nisiafloresta.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3384C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Olho d'Água do Borges\n",
      "Erro ao processar o munícipio Olho d'Água do Borges: HTTPSConnectionPool(host='olhodaguadoborges.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338748>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Parelhas\n",
      "Erro ao processar o munícipio Parelhas: HTTPSConnectionPool(host='www.parelhas.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Parnamirim\n",
      "Erro ao processar o munícipio Parnamirim: HTTPSConnectionPool(host='www.parnamirim.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338D48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Passa e Fica\n",
      "Erro ao processar o munícipio Passa e Fica: HTTPSConnectionPool(host='passaefica.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338448>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Patu\n",
      "Erro ao processar o munícipio Patu: HTTPSConnectionPool(host='patu.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Pau dos Ferros\n",
      "Erro ao processar o munícipio Pau dos Ferros: HTTPSConnectionPool(host='paudosferros.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338D88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Pedro Avelino\n",
      "Erro ao processar o munícipio Pedro Avelino: HTTPSConnectionPool(host='pedroavelino.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338808>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Pedro Velho\n",
      "Erro ao processar o munícipio Pedro Velho: HTTPSConnectionPool(host='pedrovelho.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338648>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RN - Pendências\n",
      "Erro ao processar o munícipio Pendências: HTTPSConnectionPool(host='pendencias.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338A48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Poço Branco\n",
      "Erro ao processar o munícipio Poço Branco: HTTPSConnectionPool(host='pocobranco.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Portalegre\n",
      "Erro ao processar o munícipio Portalegre: HTTPSConnectionPool(host='www.portalegre.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338AC8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Riacho da Cruz\n",
      "Erro ao processar o munícipio Riacho da Cruz: HTTPSConnectionPool(host='riachodacruz.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338A48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Riachuelo\n",
      "Erro ao processar o munícipio Riachuelo: HTTPSConnectionPool(host='riachuelo.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3389C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Rio do Fogo\n",
      "Erro ao processar o munícipio Rio do Fogo: HTTPSConnectionPool(host='riodofogo.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FF48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Santa Cruz\n",
      "Erro ao processar o munícipio Santa Cruz: HTTPSConnectionPool(host='santacruz.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FB48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Santana do Matos\n",
      "Erro ao processar o munícipio Santana do Matos: HTTPSConnectionPool(host='santanadomatos.rn.gov.br', port=443): Max retries exceeded with url: /pagina-inicial/prefeitura-municipal-de-santana-do-matos (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338208>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Fernando\n",
      "Erro ao processar o munícipio São Fernando: HTTPSConnectionPool(host='www.saofernando.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3388C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Francisco do Oeste\n",
      "Erro ao processar o munícipio São Francisco do Oeste: HTTPSConnectionPool(host='www.saofranciscodooeste.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3385C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Gonçalo do Amarante\n",
      "Erro ao processar o munícipio São Gonçalo do Amarante: HTTPSConnectionPool(host='saogoncalo.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338688>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São João do Sabugi\n",
      "Erro ao processar o munícipio São João do Sabugi: HTTPSConnectionPool(host='www.saojoaodosabugi.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338688>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São José do Campestre\n",
      "Erro ao processar o munícipio São José do Campestre: HTTPSConnectionPool(host='saojosedocampestre.sogo.com.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3382C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Miguel\n",
      "Erro ao processar o munícipio São Miguel: HTTPSConnectionPool(host='www.saomiguel.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E8BD248>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Miguel do Gostoso\n",
      "Erro ao processar o munícipio São Miguel do Gostoso: HTTPSConnectionPool(host='site.saomigueldogostoso.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338588>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Paulo do Potengi\n",
      "Erro ao processar o munícipio São Paulo do Potengi: HTTPSConnectionPool(host='www.saopaulodopotengi.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3387C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Rafael\n",
      "Erro ao processar o munícipio São Rafael: HTTPSConnectionPool(host='saorafael.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FF08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - São Tomé\n",
      "Erro ao processar o munícipio São Tomé: HTTPSConnectionPool(host='saotome.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F088>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Serra de São Bento\n",
      "Erro ao processar o munícipio Serra de São Bento: HTTPSConnectionPool(host='serradesaobento.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3384C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Serra Negra do Norte\n",
      "Erro ao processar o munícipio Serra Negra do Norte: HTTPSConnectionPool(host='serranegra.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338488>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Tangará\n",
      "Erro ao processar o munícipio Tangará: HTTPSConnectionPool(host='tangara.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338C48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Tibau\n",
      "Erro ao processar o munícipio Tibau: HTTPSConnectionPool(host='www.tibau.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FD48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Tibau do Sul\n",
      "Erro ao processar o munícipio Tibau do Sul: HTTPSConnectionPool(host='tibaudosul.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34FD48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "RN - Touros\n",
      "Erro ao processar o munícipio Touros: HTTPSConnectionPool(host='touros.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338D48>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RN - Umarizal\n",
      "Erro ao processar o munícipio Umarizal: HTTPSConnectionPool(host='umarizal.rn.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338D08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Cacoal\n",
      "Erro ao processar o munícipio Cacoal: HTTPSConnectionPool(host='cacoal.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338D08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Campo Novo de Rondônia\n",
      "Erro ao processar o munícipio Campo Novo de Rondônia: HTTPSConnectionPool(host='camponovo.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F188>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Colorado do Oeste\n",
      "Erro ao processar o munícipio Colorado do Oeste: HTTPSConnectionPool(host='coloradodooeste.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F748>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Costa Marques\n",
      "Erro ao processar o munícipio Costa Marques: HTTPSConnectionPool(host='www.costamarques.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E34F4C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Jaru\n",
      "Erro ao processar o munícipio Jaru: HTTPSConnectionPool(host='jaru.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338A08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Ji-Paraná\n",
      "Erro ao processar o munícipio Ji-Paraná: HTTPSConnectionPool(host='ji-parana.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Machadinho D'Oeste\n",
      "Erro ao processar o munícipio Machadinho D'Oeste: HTTPSConnectionPool(host='machadinho.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338908>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Nova Brasilândia D'Oeste\n",
      "Erro ao processar o munícipio Nova Brasilândia D'Oeste: HTTPSConnectionPool(host='novabrasilandia.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338F88>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Nova União\n",
      "Erro ao processar o munícipio Nova União: HTTPSConnectionPool(host='novauniao.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3384C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Ouro Preto do Oeste\n",
      "Erro ao processar o munícipio Ouro Preto do Oeste: HTTPSConnectionPool(host='ouropretodooeste.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E3384C8>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Pimenta Bueno\n",
      "Erro ao processar o munícipio Pimenta Bueno: HTTPSConnectionPool(host='www.pimentabueno.ro.gov.br', port=443): Max retries exceeded with url: /site/ (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338A08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Pimenteiras do Oeste\n",
      "Erro ao processar o munícipio Pimenteiras do Oeste: HTTPSConnectionPool(host='pimenteirasdooeste.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Porto Velho\n",
      "Erro ao processar o munícipio Porto Velho: HTTPSConnectionPool(host='www.portovelho.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338948>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n",
      "RO - Rolim de Moura\n",
      "Erro ao processar o munícipio Rolim de Moura: HTTPSConnectionPool(host='rolimdemoura.ro.gov.br', port=443): Max retries exceeded with url: / (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at 0x000001F54E338A08>: Failed to establish a new connection: [Errno 11001] getaddrinfo failed'))\n",
      "Conexão bem-sucedida!\n"
     ]
    },
    {
     "ename": "Error",
     "evalue": "Already closed",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mError\u001b[0m                                     Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-5-031c40b700a0>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m    177\u001b[0m         \u001b[0mconexao\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    178\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 179\u001b[1;33m \u001b[0mconexao\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    180\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    181\u001b[0m \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Processo concluído'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pymysql\\connections.py\u001b[0m in \u001b[0;36mclose\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    412\u001b[0m         \"\"\"\n\u001b[0;32m    413\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_closed\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 414\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0merr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Already closed\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    415\u001b[0m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_closed\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    416\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_sock\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mError\u001b[0m: Already closed"
     ]
    }
   ],
   "source": [
    "\n",
    "# Conectar ao banco de dados\n",
    "conexao, cursor = conectar_banco()\n",
    "\n",
    "# Executar o SELECT para obter os sites principais com processado = 'N' e município específico\n",
    "cursor = executar_comando(cursor, '''\n",
    " SELECT uf, municipio, site\n",
    " FROM tb_municipio\n",
    " WHERE processado = 'N'\n",
    " AND uf in ('PI','PR','RJ','RN','RO')\n",
    " ORDER BY uf, municipio;\n",
    "''')\n",
    "\n",
    "# Obter todos os resultados\n",
    "resultados = cursor.fetchall()\n",
    "\n",
    "# Alimentar o array sites_principais\n",
    "sites_principais = [(linha[0], linha[1], linha[2]) for linha in resultados]\n",
    "\n",
    "# Executar o SELECT para obter as categorias e subcategorias\n",
    "cursor = executar_comando(cursor, '''\n",
    "SELECT a.cod_categoria cod_categoria, \n",
    "       b.cod_sub_categoria cod_sub_categoria,\n",
    "       a.descricao descricao_cat, \n",
    "       b.descricao descricao_sub,\n",
    "       b.frase frase\n",
    " FROM tb_categoria a, tb_sub_categoria b\n",
    " WHERE a.cod_categoria = b.cod_categoria\n",
    " ORDER by a.cod_categoria, b.cod_sub_categoria;\n",
    "''')\n",
    "\n",
    "# Obter todos os resultados\n",
    "resultados = cursor.fetchall()\n",
    "\n",
    "# Fechar a conexão após executar os dois cursores principais\n",
    "conexao.close()\n",
    "\n",
    "# Organizar os dados no formato desejado\n",
    "categorias_subcategorias = {}\n",
    "for linha in resultados:\n",
    "    cod_categoria = linha[0]\n",
    "    cod_sub_categoria = linha[1]\n",
    "    descricao_cat = linha[2]\n",
    "    descricao_sub = linha[3]\n",
    "    frase = linha[4]\n",
    "    \n",
    "    if descricao_cat not in categorias_subcategorias:\n",
    "        categorias_subcategorias[descricao_cat] = {}\n",
    "    \n",
    "    if descricao_sub not in categorias_subcategorias[descricao_cat]:\n",
    "        categorias_subcategorias[descricao_cat][descricao_sub] = {\n",
    "            'cod_categoria': cod_categoria,\n",
    "            'cod_sub_categoria': cod_sub_categoria,\n",
    "            'frases': []\n",
    "        }\n",
    "    \n",
    "    categorias_subcategorias[descricao_cat][descricao_sub]['frases'].append(frase)\n",
    "\n",
    "# Limpar e lematizar categorias e subcategorias\n",
    "categorias_limpas = {}\n",
    "for categoria, subcategorias in categorias_subcategorias.items():\n",
    "    categorias_limpas[categoria] = {}\n",
    "    for subcategoria, dados in subcategorias.items():\n",
    "        categorias_limpas[categoria][subcategoria] = {\n",
    "            'cod_categoria': dados['cod_categoria'],\n",
    "            'cod_sub_categoria': dados['cod_sub_categoria'],\n",
    "            'frases': limpar_e_lematizar_frases(dados['frases'])\n",
    "        }\n",
    "\n",
    "# Iterar sobre os sites principais\n",
    "for uf, municipio, site_principal in sites_principais:\n",
    "    print(uf + ' - ' + municipio)\n",
    "    # Coletar links do site principal\n",
    "    try:\n",
    "        links = coletar_links(site_principal)\n",
    "        # Iterar sobre links coletados\n",
    "        for link in links:\n",
    "            try:\n",
    "                # Extrair frases da página HTML\n",
    "                frases_html = extrair_frases(link)\n",
    "                # Limpar e lematizar frases da página HTML\n",
    "                frases_html_limpas = limpar_e_lematizar_frases(frases_html)\n",
    "                conexao, cursor = conectar_banco()\n",
    "                # Inicializar contador de frases para cada subcategoria\n",
    "                for categoria, subcategorias in categorias_limpas.items():\n",
    "                    for subcategoria, dados in subcategorias.items():\n",
    "                        contagem = {frase: 0 for frase in dados['frases']}\n",
    "                        similaridade = contar_similaridade(frases_html_limpas, dados['frases'])\n",
    "                        # Contar ocorrências de frases similares\n",
    "                        for i, frase_html in enumerate(frases_html_limpas):\n",
    "                            for j, frase_banco in enumerate(dados['frases']):\n",
    "                                if similaridade[i][j] > 0.7:  # Limiar de similaridade\n",
    "                                    if frase_html not in contagem:\n",
    "                                        contagem[frase_html] = 0\n",
    "                                    contagem[frase_html] += 1\n",
    "                        # Armazenar resultados na tabela do banco de dados\n",
    "                        for frase_html, count in contagem.items():\n",
    "                            if count > 0:  # Verificar se a frase foi encontrada\n",
    "                                try:\n",
    "                                    cursor = executar_comando(cursor, ''' \n",
    "                                        INSERT INTO tb_registros_processados(\n",
    "                                            Cod_Categoria, \n",
    "                                            Cod_Subcategoria, \n",
    "                                            link_url, \n",
    "                                            frase_html, \n",
    "                                            contagem,\n",
    "                                            municipio,\n",
    "                                            uf\n",
    "                                        ) \n",
    "                                        VALUES (%s, %s, %s, %s, %s, %s, %s) ''', \n",
    "                                        (\n",
    "                                            dados['cod_categoria'], \n",
    "                                            dados['cod_sub_categoria'], \n",
    "                                            link, \n",
    "                                            frase_html,  # Inserir a frase HTML\n",
    "                                            count,\n",
    "                                            municipio,  # Inserir o município\n",
    "                                            uf  # Inserir a UF\n",
    "                                        )\n",
    "                                    ) \n",
    "                                    conexao.commit()\n",
    "                                except Exception as e:\n",
    "                                    print(f'Erro ao inserir no banco: {e}')\n",
    "                                    cursor = executar_comando(cursor, ''' \n",
    "                                        INSERT INTO tb_trata_erro(\n",
    "                                            link, \n",
    "                                            cod_erro\n",
    "                                        ) \n",
    "                                        VALUES (%s, %s) ''', \n",
    "                                        (\n",
    "                                            link,  # Salvar o link\n",
    "                                            str(e)  # Salvar o erro como string\n",
    "                                        )\n",
    "                                    ) \n",
    "                                    conexao.commit()\n",
    "                # Fechar a conexão\n",
    "                conexao.close()                   \n",
    "            except Exception as e:\n",
    "                print(f'Erro ao processar o link {link}: {e}')\n",
    "                conexao, cursor = conectar_banco()\n",
    "                cursor = executar_comando(cursor, ''' \n",
    "                    INSERT INTO tb_trata_erro(\n",
    "                        link, \n",
    "                        cod_erro\n",
    "                    ) \n",
    "                    VALUES (%s, %s) ''', \n",
    "                    (\n",
    "                        link,  # Salvar o link\n",
    "                        str(e)  # Salvar o erro como string\n",
    "                    )\n",
    "                ) \n",
    "                conexao.commit()\n",
    "                # Marcar o município como processado após o erro\n",
    "                cursor = executar_comando(cursor, '''\n",
    "                    UPDATE tb_municipio\n",
    "                    SET processado = 'S'\n",
    "                    WHERE uf = %s AND municipio = %s;\n",
    "                ''', (uf, municipio))\n",
    "                conexao.commit()\n",
    "                conexao.close()\n",
    "        # Atualizar a coluna 'processado' para 'S' após processar todos os links do site principal\n",
    "        conexao, cursor = conectar_banco()\n",
    "        cursor = executar_comando(cursor, '''\n",
    "            UPDATE tb_municipio\n",
    "            SET processado = 'S'\n",
    "            WHERE uf = %s AND municipio = %s;\n",
    "        ''', (uf, municipio))\n",
    "        conexao.commit()\n",
    "    except Exception as e:\n",
    "        print(f'Erro ao processar o munícipio {municipio}: {e}')\n",
    "        conexao, cursor = conectar_banco()\n",
    "        cursor = executar_comando(cursor, '''\n",
    "            UPDATE tb_municipio\n",
    "            SET processado = 'S'\n",
    "            WHERE uf = %s AND municipio = %s;\n",
    "        ''', (uf, municipio))\n",
    "        conexao.commit()\n",
    "        conexao.close()\n",
    "    \n",
    "conexao.close()\n",
    "\n",
    "print('Processo concluído')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:base] *",
   "language": "python",
   "name": "conda-base-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.13.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
