docs/source/tutorials/Infogripe.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "source": [
    "# Working with Infogripe datasets\n",
    "[Infogripe](http://info.gripe.fiocruz.br/) is an online platform that tracks epidemiolgical data about influenza-like diseases in Brazil.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "outputs": [],
   "source": [
    "from pysus.online_data.Infogripe import list_datasets, download\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "source": [
    "Infogripe makes available different datasets. To findout which ones are available before downloading we can ask PySUS to list them:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Alerta de situação',\n",
       " 'Casos por idade, sexo e virus',\n",
       " 'Casos Totais e estimativas',\n",
       " 'Valores esperados por localidades']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list_datasets()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 41.5 ms, sys: 6.24 ms, total: 47.7 ms\n",
      "Wall time: 450 ms\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UF</th>\n",
       "      <th>Unidade da Federação</th>\n",
       "      <th>dado</th>\n",
       "      <th>escala</th>\n",
       "      <th>Ano epidemiológico</th>\n",
       "      <th>Semana epidemiológica</th>\n",
       "      <th>casos estimados</th>\n",
       "      <th>média móvel</th>\n",
       "      <th>nível semanal</th>\n",
       "      <th>nível por média móvel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>0.721764</td>\n",
       "      <td>0.722381</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>Amarelo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>0.614818</td>\n",
       "      <td>NaN</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>Região Norte</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>0.839626</td>\n",
       "      <td>0.876132</td>\n",
       "      <td>valor alto</td>\n",
       "      <td>Vermelho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Região Norte</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>0.698819</td>\n",
       "      <td>NaN</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2</td>\n",
       "      <td>Região Nordeste</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>0.657986</td>\n",
       "      <td>0.650637</td>\n",
       "      <td>valor muito alto</td>\n",
       "      <td>Vermelho</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>1002</td>\n",
       "      <td>Regional Leste</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>0.652379</td>\n",
       "      <td>NaN</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>1003</td>\n",
       "      <td>Regional Centro</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>0.585927</td>\n",
       "      <td>0.623618</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>Amarelo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>1003</td>\n",
       "      <td>Regional Centro</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>0.520824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>1004</td>\n",
       "      <td>Regional Sul</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>0.720427</td>\n",
       "      <td>0.723445</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>Amarelo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>1004</td>\n",
       "      <td>Regional Sul</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>0.595660</td>\n",
       "      <td>NaN</td>\n",
       "      <td>valor epidêmico</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>74 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      UF Unidade da Federação  dado      escala  Ano epidemiológico  \\\n",
       "0      0               Brasil  srag  incidência                2023   \n",
       "1      0               Brasil  srag  incidência                2023   \n",
       "2      1         Região Norte  srag  incidência                2023   \n",
       "3      1         Região Norte  srag  incidência                2023   \n",
       "4      2      Região Nordeste  srag  incidência                2023   \n",
       "..   ...                  ...   ...         ...                 ...   \n",
       "69  1002       Regional Leste  srag  incidência                2023   \n",
       "70  1003      Regional Centro  srag  incidência                2023   \n",
       "71  1003      Regional Centro  srag  incidência                2023   \n",
       "72  1004         Regional Sul  srag  incidência                2023   \n",
       "73  1004         Regional Sul  srag  incidência                2023   \n",
       "\n",
       "    Semana epidemiológica  casos estimados  média móvel     nível semanal  \\\n",
       "0                      35         0.721764     0.722381   valor epidêmico   \n",
       "1                      36         0.614818          NaN   valor epidêmico   \n",
       "2                      35         0.839626     0.876132        valor alto   \n",
       "3                      36         0.698819          NaN   valor epidêmico   \n",
       "4                      35         0.657986     0.650637  valor muito alto   \n",
       "..                    ...              ...          ...               ...   \n",
       "69                     36         0.652379          NaN   valor epidêmico   \n",
       "70                     35         0.585927     0.623618   valor epidêmico   \n",
       "71                     36         0.520824          NaN   valor epidêmico   \n",
       "72                     35         0.720427     0.723445   valor epidêmico   \n",
       "73                     36         0.595660          NaN   valor epidêmico   \n",
       "\n",
       "   nível por média móvel  \n",
       "0                Amarelo  \n",
       "1                    NaN  \n",
       "2               Vermelho  \n",
       "3                    NaN  \n",
       "4               Vermelho  \n",
       "..                   ...  \n",
       "69                   NaN  \n",
       "70               Amarelo  \n",
       "71                   NaN  \n",
       "72               Amarelo  \n",
       "73                   NaN  \n",
       "\n",
       "[74 rows x 10 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%time df_alert = download(\"Alerta de situação\")\n",
    "df_alert"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>data de publicação</th>\n",
       "      <th>UF</th>\n",
       "      <th>Unidade da Federação</th>\n",
       "      <th>Tipo</th>\n",
       "      <th>dado</th>\n",
       "      <th>escala</th>\n",
       "      <th>sexo</th>\n",
       "      <th>Ano epidemiológico</th>\n",
       "      <th>Semana epidemiológica</th>\n",
       "      <th>Ano e semana epidemiológica</th>\n",
       "      <th>...</th>\n",
       "      <th>Vírus sincicial respiratório (VSR)</th>\n",
       "      <th>Parainfluenza 1</th>\n",
       "      <th>Parainfluenza 2</th>\n",
       "      <th>Parainfluenza 3</th>\n",
       "      <th>Parainfluenza 4</th>\n",
       "      <th>Adenovirus</th>\n",
       "      <th>Rinovirus</th>\n",
       "      <th>Bocavirus</th>\n",
       "      <th>Metapneumovirus</th>\n",
       "      <th>Outros virus</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>F</td>\n",
       "      <td>2009</td>\n",
       "      <td>1</td>\n",
       "      <td>2009W01</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>M</td>\n",
       "      <td>2009</td>\n",
       "      <td>1</td>\n",
       "      <td>2009W01</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>Total</td>\n",
       "      <td>2009</td>\n",
       "      <td>1</td>\n",
       "      <td>2009W01</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>F</td>\n",
       "      <td>2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009W02</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>M</td>\n",
       "      <td>2009</td>\n",
       "      <td>2</td>\n",
       "      <td>2009W02</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892768</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>Total</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>2023W35</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892769</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>F</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>2023W36</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892770</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>I</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>2023W36</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892771</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>M</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>2023W36</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892772</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>Total</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>2023W36</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>892773 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       data de publicação  UF Unidade da Federação    Tipo   dado      escala  \\\n",
       "0              2023-09-13  11             Rondônia  Estado   srag  incidência   \n",
       "1              2023-09-13  11             Rondônia  Estado   srag  incidência   \n",
       "2              2023-09-13  11             Rondônia  Estado   srag  incidência   \n",
       "3              2023-09-13  11             Rondônia  Estado   srag  incidência   \n",
       "4              2023-09-13  11             Rondônia  Estado   srag  incidência   \n",
       "...                   ...  ..                  ...     ...    ...         ...   \n",
       "892768         2023-09-13   3       Região Sudeste  Região  obito       casos   \n",
       "892769         2023-09-13   3       Região Sudeste  Região  obito       casos   \n",
       "892770         2023-09-13   3       Região Sudeste  Região  obito       casos   \n",
       "892771         2023-09-13   3       Região Sudeste  Região  obito       casos   \n",
       "892772         2023-09-13   3       Região Sudeste  Região  obito       casos   \n",
       "\n",
       "         sexo  Ano epidemiológico  Semana epidemiológica  \\\n",
       "0           F                2009                      1   \n",
       "1           M                2009                      1   \n",
       "2       Total                2009                      1   \n",
       "3           F                2009                      2   \n",
       "4           M                2009                      2   \n",
       "...       ...                 ...                    ...   \n",
       "892768  Total                2023                     35   \n",
       "892769      F                2023                     36   \n",
       "892770      I                2023                     36   \n",
       "892771      M                2023                     36   \n",
       "892772  Total                2023                     36   \n",
       "\n",
       "       Ano e semana epidemiológica  ... Vírus sincicial respiratório (VSR)  \\\n",
       "0                          2009W01  ...                                0.0   \n",
       "1                          2009W01  ...                                0.0   \n",
       "2                          2009W01  ...                                0.0   \n",
       "3                          2009W02  ...                                0.0   \n",
       "4                          2009W02  ...                                0.0   \n",
       "...                            ...  ...                                ...   \n",
       "892768                     2023W35  ...                                0.0   \n",
       "892769                     2023W36  ...                                0.0   \n",
       "892770                     2023W36  ...                                0.0   \n",
       "892771                     2023W36  ...                                0.0   \n",
       "892772                     2023W36  ...                                0.0   \n",
       "\n",
       "        Parainfluenza 1  Parainfluenza 2  Parainfluenza 3  Parainfluenza 4  \\\n",
       "0                   0.0              0.0              0.0              0.0   \n",
       "1                   0.0              0.0              0.0              0.0   \n",
       "2                   0.0              0.0              0.0              0.0   \n",
       "3                   0.0              0.0              0.0              0.0   \n",
       "4                   0.0              0.0              0.0              0.0   \n",
       "...                 ...              ...              ...              ...   \n",
       "892768              0.0              0.0              0.0              0.0   \n",
       "892769              0.0              0.0              0.0              0.0   \n",
       "892770              0.0              0.0              0.0              0.0   \n",
       "892771              0.0              0.0              0.0              0.0   \n",
       "892772              0.0              0.0              0.0              0.0   \n",
       "\n",
       "        Adenovirus  Rinovirus  Bocavirus  Metapneumovirus  Outros virus  \n",
       "0              0.0        0.0        0.0              0.0           0.0  \n",
       "1              0.0        0.0        0.0              0.0           0.0  \n",
       "2              0.0        0.0        0.0              0.0           0.0  \n",
       "3              0.0        0.0        0.0              0.0           0.0  \n",
       "4              0.0        0.0        0.0              0.0           0.0  \n",
       "...            ...        ...        ...              ...           ...  \n",
       "892768         0.0        0.0        0.0              0.0           0.0  \n",
       "892769         0.0        0.0        0.0              0.0           0.0  \n",
       "892770         0.0        0.0        0.0              0.0           0.0  \n",
       "892771         0.0        0.0        0.0              0.0           0.0  \n",
       "892772         0.0        0.0        0.0              0.0           0.0  \n",
       "\n",
       "[892773 rows x 42 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_age_sex_virus = download(\"Casos por idade, sexo e virus\")\n",
    "df_age_sex_virus\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>data de publicação</th>\n",
       "      <th>UF</th>\n",
       "      <th>Unidade da Federação</th>\n",
       "      <th>Tipo</th>\n",
       "      <th>dado</th>\n",
       "      <th>escala</th>\n",
       "      <th>Ano epidemiológico</th>\n",
       "      <th>Semana epidemiológica</th>\n",
       "      <th>Situação do dado</th>\n",
       "      <th>Casos semanais reportados até a última atualização</th>\n",
       "      <th>...</th>\n",
       "      <th>casos estimados</th>\n",
       "      <th>média móvel</th>\n",
       "      <th>limite superior da estimativa</th>\n",
       "      <th>Percentual em relação ao país</th>\n",
       "      <th>População</th>\n",
       "      <th>limiar pré-epidêmico</th>\n",
       "      <th>intensidade alta</th>\n",
       "      <th>intensidade muito alta</th>\n",
       "      <th>nível semanal</th>\n",
       "      <th>nível por média móvel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>País</td>\n",
       "      <td>srag</td>\n",
       "      <td>casos</td>\n",
       "      <td>2009</td>\n",
       "      <td>1</td>\n",
       "      <td>Dado estável. Sujeito a pequenas alterações.</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>193543969</td>\n",
       "      <td>614.000000</td>\n",
       "      <td>1588.000000</td>\n",
       "      <td>2056.000000</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>País</td>\n",
       "      <td>srag</td>\n",
       "      <td>casos</td>\n",
       "      <td>2009</td>\n",
       "      <td>2</td>\n",
       "      <td>Dado estável. Sujeito a pequenas alterações.</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>193543969</td>\n",
       "      <td>614.000000</td>\n",
       "      <td>1588.000000</td>\n",
       "      <td>2056.000000</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>País</td>\n",
       "      <td>srag</td>\n",
       "      <td>casos</td>\n",
       "      <td>2009</td>\n",
       "      <td>3</td>\n",
       "      <td>Dado estável. Sujeito a pequenas alterações.</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>193543969</td>\n",
       "      <td>614.000000</td>\n",
       "      <td>1588.000000</td>\n",
       "      <td>2056.000000</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>País</td>\n",
       "      <td>srag</td>\n",
       "      <td>casos</td>\n",
       "      <td>2009</td>\n",
       "      <td>4</td>\n",
       "      <td>Dado estável. Sujeito a pequenas alterações.</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>193543969</td>\n",
       "      <td>614.000000</td>\n",
       "      <td>1588.000000</td>\n",
       "      <td>2056.000000</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>0</td>\n",
       "      <td>Brasil</td>\n",
       "      <td>País</td>\n",
       "      <td>srag</td>\n",
       "      <td>casos</td>\n",
       "      <td>2009</td>\n",
       "      <td>5</td>\n",
       "      <td>Dado estável. Sujeito a pequenas alterações.</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>193543969</td>\n",
       "      <td>614.000000</td>\n",
       "      <td>1588.000000</td>\n",
       "      <td>2056.000000</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340099</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>1004</td>\n",
       "      <td>Regional Sul</td>\n",
       "      <td>Regional</td>\n",
       "      <td>obitocovid</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>32</td>\n",
       "      <td>Estimado. Sujeito a alterações.</td>\n",
       "      <td>0.008049</td>\n",
       "      <td>...</td>\n",
       "      <td>0.008049</td>\n",
       "      <td>0.008720</td>\n",
       "      <td>0.011068</td>\n",
       "      <td>53.333333</td>\n",
       "      <td>99385570</td>\n",
       "      <td>0.011189</td>\n",
       "      <td>0.066115</td>\n",
       "      <td>0.095612</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340100</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>1004</td>\n",
       "      <td>Regional Sul</td>\n",
       "      <td>Regional</td>\n",
       "      <td>obitocovid</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>33</td>\n",
       "      <td>Estimado. Sujeito a alterações.</td>\n",
       "      <td>0.010062</td>\n",
       "      <td>...</td>\n",
       "      <td>0.011068</td>\n",
       "      <td>0.007714</td>\n",
       "      <td>0.013080</td>\n",
       "      <td>61.111111</td>\n",
       "      <td>99385570</td>\n",
       "      <td>0.011189</td>\n",
       "      <td>0.066115</td>\n",
       "      <td>0.095612</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340101</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>1004</td>\n",
       "      <td>Regional Sul</td>\n",
       "      <td>Regional</td>\n",
       "      <td>obitocovid</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>34</td>\n",
       "      <td>Estimado. Sujeito a alterações.</td>\n",
       "      <td>0.003019</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004025</td>\n",
       "      <td>0.006708</td>\n",
       "      <td>0.008049</td>\n",
       "      <td>50.000000</td>\n",
       "      <td>99385570</td>\n",
       "      <td>0.011189</td>\n",
       "      <td>0.066115</td>\n",
       "      <td>0.095612</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340102</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>1004</td>\n",
       "      <td>Regional Sul</td>\n",
       "      <td>Regional</td>\n",
       "      <td>obitocovid</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>35</td>\n",
       "      <td>Estimado. Sujeito a alterações.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.005031</td>\n",
       "      <td>0.004360</td>\n",
       "      <td>0.011068</td>\n",
       "      <td>55.555556</td>\n",
       "      <td>99385570</td>\n",
       "      <td>0.011189</td>\n",
       "      <td>0.066115</td>\n",
       "      <td>0.095612</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>Verde</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>340103</th>\n",
       "      <td>2023-09-13</td>\n",
       "      <td>1004</td>\n",
       "      <td>Regional Sul</td>\n",
       "      <td>Regional</td>\n",
       "      <td>obitocovid</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2023</td>\n",
       "      <td>36</td>\n",
       "      <td>Estimado. Sujeito a alterações.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004025</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.012074</td>\n",
       "      <td>57.142857</td>\n",
       "      <td>99385570</td>\n",
       "      <td>0.011189</td>\n",
       "      <td>0.066115</td>\n",
       "      <td>0.095612</td>\n",
       "      <td>valor baixo</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>340104 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       data de publicação    UF Unidade da Federação      Tipo        dado  \\\n",
       "0              2023-09-13     0               Brasil      País        srag   \n",
       "1              2023-09-13     0               Brasil      País        srag   \n",
       "2              2023-09-13     0               Brasil      País        srag   \n",
       "3              2023-09-13     0               Brasil      País        srag   \n",
       "4              2023-09-13     0               Brasil      País        srag   \n",
       "...                   ...   ...                  ...       ...         ...   \n",
       "340099         2023-09-13  1004         Regional Sul  Regional  obitocovid   \n",
       "340100         2023-09-13  1004         Regional Sul  Regional  obitocovid   \n",
       "340101         2023-09-13  1004         Regional Sul  Regional  obitocovid   \n",
       "340102         2023-09-13  1004         Regional Sul  Regional  obitocovid   \n",
       "340103         2023-09-13  1004         Regional Sul  Regional  obitocovid   \n",
       "\n",
       "            escala  Ano epidemiológico  Semana epidemiológica  \\\n",
       "0            casos                2009                      1   \n",
       "1            casos                2009                      2   \n",
       "2            casos                2009                      3   \n",
       "3            casos                2009                      4   \n",
       "4            casos                2009                      5   \n",
       "...            ...                 ...                    ...   \n",
       "340099  incidência                2023                     32   \n",
       "340100  incidência                2023                     33   \n",
       "340101  incidência                2023                     34   \n",
       "340102  incidência                2023                     35   \n",
       "340103  incidência                2023                     36   \n",
       "\n",
       "                                    Situação do dado  \\\n",
       "0       Dado estável. Sujeito a pequenas alterações.   \n",
       "1       Dado estável. Sujeito a pequenas alterações.   \n",
       "2       Dado estável. Sujeito a pequenas alterações.   \n",
       "3       Dado estável. Sujeito a pequenas alterações.   \n",
       "4       Dado estável. Sujeito a pequenas alterações.   \n",
       "...                                              ...   \n",
       "340099               Estimado. Sujeito a alterações.   \n",
       "340100               Estimado. Sujeito a alterações.   \n",
       "340101               Estimado. Sujeito a alterações.   \n",
       "340102               Estimado. Sujeito a alterações.   \n",
       "340103               Estimado. Sujeito a alterações.   \n",
       "\n",
       "        Casos semanais reportados até a última atualização  ...  \\\n",
       "0                                                0.000000   ...   \n",
       "1                                                0.000000   ...   \n",
       "2                                                0.000000   ...   \n",
       "3                                                0.000000   ...   \n",
       "4                                                0.000000   ...   \n",
       "...                                                   ...   ...   \n",
       "340099                                           0.008049   ...   \n",
       "340100                                           0.010062   ...   \n",
       "340101                                           0.003019   ...   \n",
       "340102                                                NaN   ...   \n",
       "340103                                                NaN   ...   \n",
       "\n",
       "        casos estimados  média móvel  limite superior da estimativa  \\\n",
       "0                   NaN          NaN                            NaN   \n",
       "1                   NaN     0.000000                            NaN   \n",
       "2                   NaN     0.000000                            NaN   \n",
       "3                   NaN     0.000000                            NaN   \n",
       "4                   NaN     0.000000                            NaN   \n",
       "...                 ...          ...                            ...   \n",
       "340099         0.008049     0.008720                       0.011068   \n",
       "340100         0.011068     0.007714                       0.013080   \n",
       "340101         0.004025     0.006708                       0.008049   \n",
       "340102         0.005031     0.004360                       0.011068   \n",
       "340103         0.004025          NaN                       0.012074   \n",
       "\n",
       "        Percentual em relação ao país  População  limiar pré-epidêmico  \\\n",
       "0                                 NaN  193543969            614.000000   \n",
       "1                                 NaN  193543969            614.000000   \n",
       "2                                 NaN  193543969            614.000000   \n",
       "3                                 NaN  193543969            614.000000   \n",
       "4                                 NaN  193543969            614.000000   \n",
       "...                               ...        ...                   ...   \n",
       "340099                      53.333333   99385570              0.011189   \n",
       "340100                      61.111111   99385570              0.011189   \n",
       "340101                      50.000000   99385570              0.011189   \n",
       "340102                      55.555556   99385570              0.011189   \n",
       "340103                      57.142857   99385570              0.011189   \n",
       "\n",
       "        intensidade alta  intensidade muito alta  nível semanal  \\\n",
       "0            1588.000000             2056.000000    valor baixo   \n",
       "1            1588.000000             2056.000000    valor baixo   \n",
       "2            1588.000000             2056.000000    valor baixo   \n",
       "3            1588.000000             2056.000000    valor baixo   \n",
       "4            1588.000000             2056.000000    valor baixo   \n",
       "...                  ...                     ...            ...   \n",
       "340099          0.066115                0.095612    valor baixo   \n",
       "340100          0.066115                0.095612    valor baixo   \n",
       "340101          0.066115                0.095612    valor baixo   \n",
       "340102          0.066115                0.095612    valor baixo   \n",
       "340103          0.066115                0.095612    valor baixo   \n",
       "\n",
       "       nível por média móvel  \n",
       "0                        NaN  \n",
       "1                      Verde  \n",
       "2                      Verde  \n",
       "3                      Verde  \n",
       "4                      Verde  \n",
       "...                      ...  \n",
       "340099                 Verde  \n",
       "340100                 Verde  \n",
       "340101                 Verde  \n",
       "340102                 Verde  \n",
       "340103                   NaN  \n",
       "\n",
       "[340104 rows x 21 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_totals = download(\"Casos Totais e estimativas\")\n",
    "df_totals\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UF</th>\n",
       "      <th>Unidade da Federação</th>\n",
       "      <th>Tipo</th>\n",
       "      <th>dado</th>\n",
       "      <th>escala</th>\n",
       "      <th>Semana epidemiológica</th>\n",
       "      <th>corredor baixo</th>\n",
       "      <th>corredor mediano</th>\n",
       "      <th>corredor alto</th>\n",
       "      <th>limiar pré-epidêmico</th>\n",
       "      <th>intensidade alta</th>\n",
       "      <th>intensidade muito alta</th>\n",
       "      <th>temporadas consideradas regulares</th>\n",
       "      <th>População de referência para cálculo de incidência</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.053353</td>\n",
       "      <td>0.160058</td>\n",
       "      <td>0.693586</td>\n",
       "      <td>0.906997</td>\n",
       "      <td>2010, 2013, 2014, 2016, 2018, 2019</td>\n",
       "      <td>1874318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.160058</td>\n",
       "      <td>0.693586</td>\n",
       "      <td>0.906997</td>\n",
       "      <td>2010, 2013, 2014, 2016, 2018, 2019</td>\n",
       "      <td>1874318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.053353</td>\n",
       "      <td>0.160058</td>\n",
       "      <td>0.693586</td>\n",
       "      <td>0.906997</td>\n",
       "      <td>2010, 2013, 2014, 2016, 2018, 2019</td>\n",
       "      <td>1874318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.053353</td>\n",
       "      <td>0.053353</td>\n",
       "      <td>0.160058</td>\n",
       "      <td>0.693586</td>\n",
       "      <td>0.906997</td>\n",
       "      <td>2010, 2013, 2014, 2016, 2018, 2019</td>\n",
       "      <td>1874318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11</td>\n",
       "      <td>Rondônia</td>\n",
       "      <td>Estado</td>\n",
       "      <td>srag</td>\n",
       "      <td>incidência</td>\n",
       "      <td>5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.053353</td>\n",
       "      <td>0.160058</td>\n",
       "      <td>0.693586</td>\n",
       "      <td>0.906997</td>\n",
       "      <td>2010, 2013, 2014, 2016, 2018, 2019</td>\n",
       "      <td>1874318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23083</th>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>48</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>124.000000</td>\n",
       "      <td>2012, 2013, 2014, 2015, 2017, 2018, 2019</td>\n",
       "      <td>89107377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23084</th>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>49</td>\n",
       "      <td>6.0</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>124.000000</td>\n",
       "      <td>2012, 2013, 2014, 2015, 2017, 2018, 2019</td>\n",
       "      <td>89107377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23085</th>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>50</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>124.000000</td>\n",
       "      <td>2012, 2013, 2014, 2015, 2017, 2018, 2019</td>\n",
       "      <td>89107377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23086</th>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>51</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>124.000000</td>\n",
       "      <td>2012, 2013, 2014, 2015, 2017, 2018, 2019</td>\n",
       "      <td>89107377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23087</th>\n",
       "      <td>3</td>\n",
       "      <td>Região Sudeste</td>\n",
       "      <td>Região</td>\n",
       "      <td>obito</td>\n",
       "      <td>casos</td>\n",
       "      <td>52</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>88.000000</td>\n",
       "      <td>124.000000</td>\n",
       "      <td>2012, 2013, 2014, 2015, 2017, 2018, 2019</td>\n",
       "      <td>89107377</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23088 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       UF Unidade da Federação    Tipo   dado      escala  \\\n",
       "0      11             Rondônia  Estado   srag  incidência   \n",
       "1      11             Rondônia  Estado   srag  incidência   \n",
       "2      11             Rondônia  Estado   srag  incidência   \n",
       "3      11             Rondônia  Estado   srag  incidência   \n",
       "4      11             Rondônia  Estado   srag  incidência   \n",
       "...    ..                  ...     ...    ...         ...   \n",
       "23083   3       Região Sudeste  Região  obito       casos   \n",
       "23084   3       Região Sudeste  Região  obito       casos   \n",
       "23085   3       Região Sudeste  Região  obito       casos   \n",
       "23086   3       Região Sudeste  Região  obito       casos   \n",
       "23087   3       Região Sudeste  Região  obito       casos   \n",
       "\n",
       "       Semana epidemiológica  corredor baixo  corredor mediano  corredor alto  \\\n",
       "0                          1             0.0          0.000000       0.053353   \n",
       "1                          2             0.0          0.000000       0.000000   \n",
       "2                          3             0.0          0.000000       0.053353   \n",
       "3                          4             0.0          0.053353       0.053353   \n",
       "4                          5             0.0          0.000000       0.053353   \n",
       "...                      ...             ...               ...            ...   \n",
       "23083                     48             5.0          7.000000      10.000000   \n",
       "23084                     49             6.0          7.000000       9.000000   \n",
       "23085                     50             5.0          7.000000      11.000000   \n",
       "23086                     51             4.0          7.000000      11.000000   \n",
       "23087                     52             4.0          6.000000       8.000000   \n",
       "\n",
       "       limiar pré-epidêmico  intensidade alta  intensidade muito alta  \\\n",
       "0                  0.160058          0.693586                0.906997   \n",
       "1                  0.160058          0.693586                0.906997   \n",
       "2                  0.160058          0.693586                0.906997   \n",
       "3                  0.160058          0.693586                0.906997   \n",
       "4                  0.160058          0.693586                0.906997   \n",
       "...                     ...               ...                     ...   \n",
       "23083             23.000000         88.000000              124.000000   \n",
       "23084             23.000000         88.000000              124.000000   \n",
       "23085             23.000000         88.000000              124.000000   \n",
       "23086             23.000000         88.000000              124.000000   \n",
       "23087             23.000000         88.000000              124.000000   \n",
       "\n",
       "              temporadas consideradas regulares  \\\n",
       "0            2010, 2013, 2014, 2016, 2018, 2019   \n",
       "1            2010, 2013, 2014, 2016, 2018, 2019   \n",
       "2            2010, 2013, 2014, 2016, 2018, 2019   \n",
       "3            2010, 2013, 2014, 2016, 2018, 2019   \n",
       "4            2010, 2013, 2014, 2016, 2018, 2019   \n",
       "...                                         ...   \n",
       "23083  2012, 2013, 2014, 2015, 2017, 2018, 2019   \n",
       "23084  2012, 2013, 2014, 2015, 2017, 2018, 2019   \n",
       "23085  2012, 2013, 2014, 2015, 2017, 2018, 2019   \n",
       "23086  2012, 2013, 2014, 2015, 2017, 2018, 2019   \n",
       "23087  2012, 2013, 2014, 2015, 2017, 2018, 2019   \n",
       "\n",
       "       População de referência para cálculo de incidência  \n",
       "0                                                1874318   \n",
       "1                                                1874318   \n",
       "2                                                1874318   \n",
       "3                                                1874318   \n",
       "4                                                1874318   \n",
       "...                                                  ...   \n",
       "23083                                           89107377   \n",
       "23084                                           89107377   \n",
       "23085                                           89107377   \n",
       "23086                                           89107377   \n",
       "23087                                           89107377   \n",
       "\n",
       "[23088 rows x 14 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_localities = download(\"Valores esperados por localidades\")\n",
    "df_localities\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false,
    "jupyter": {
     "outputs_hidden": false
    }
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "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.11.5"
  },
  "vscode": {
   "interpreter": {
    "hash": "2a96a5ccec8dfcba7d06b2e71f6eef3b5dac5716461bf5d73ea1bb7ee462cdaa"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}