Problems merging two datasets with different dimensions and possible identifiers

[Bruno Hoepers]

Hi all. I am working with precinct-level datasets of the Brazilian general election of 2022.

There are two types of datasets: one with vote share totals at the precinct-level and another one with the voters’ profile at the precinct-level. Brazil has 27 states. So, I have 27 Stata files for the vote share totals and 27 Stata files for the voters’ profile.

The “vote share totals dataset” for each Brazilian state contains information on the vote shares of federal deputy candidates and state deputy candidates in each state organized by municipality (cd_municipio), electoral zone (nr_zona), electoral section (nr_secao), and name of the precinct (nm_local_votacao). It also has information on specific details of each precinct (i.e., whether the precinct is an educational building or a religious building) and whether the each candidate identifies herself as an education professional or a religious person.

The “voters’ profile dataset” for each Brazilian state contains information on the percentage of women, percentage of young people and level of education in percentage per precinct. This dataset also has these identifiers: municipality (cd_municipio), electoral zone (nr_zona), electoral section (nr_secao), and name of the precinct (nm_local_votacao). It also has identifiers for each candidate and the office she ran for (nm_candidato, nr_candidato, cd_cargo, ds_cargo).

The problem: the “vote share totals dataset” only reports each candidates’ votes in precincts where a candidate obtained at least one vote. It is not possible to assign “zero” votes for the precinct where the a candidate did not get any votes.

What I need:

a) to have a dataset merging the information from “vote share totals dataset” with the information at the “voters’ profile dataset”, and
b) to have data on the votes obtained by all candidates in all precincts (nm_local_votacao), including the precincts where a candidate got zero votes.

If I’m correct, the merged dataset should have n precincts (or localities) times n candidates in rows.

I’ve tried several types of merge operations using different types of IDs to merge one dataset to each other, to no avail.

Can someone help me devise a solution for this?

Thank you.

Example of “vote share totals dataset”:

* Example generated by -dataex-. For more info, type help dataex
clear
input float id int cd_municipio str20 nm_municipio byte nr_zona int nr_secao byte cd_cargo str17 ds_cargo int nr_local_votacao str69 nm_local_votacao str60 nm_candidato long nr_candidato float(qt_votos_cand_dep_est perc_votos_cand_dep_est)
  1 3018 "BOA VISTA"            1 241 6 "DEPUTADO FEDERAL" 2291 "DIVA ALVES DE LIMA E.E.PROFª."                                        "GABRIEL MOTA E SILVA" 1000 . .
  2 3018 "BOA VISTA"            1  47 6 "DEPUTADO FEDERAL" 1376 "S.E.A.P.A. SECRETARIA DA AGRICULTURA, PECUÁRIA E ABASTECIMENTO"       "GABRIEL MOTA E SILVA" 1000 . .
  3 3018 "BOA VISTA"            1 687 6 "DEPUTADO FEDERAL" 3590 "CUNHATA CURUMIN E.E."                                                  "GABRIEL MOTA E SILVA" 1000 . .
  4 3034 "CARACARAÍ"           2 137 6 "DEPUTADO FEDERAL" 1082 "PRESIDENTE CASTELO BRANCO E. P. S. G."                                 "GABRIEL MOTA E SILVA" 1000 . .
  5 3050 "ALTO ALEGRE"          3 232 6 "DEPUTADO FEDERAL" 1031 "SADOC PEREIRA E.P."                                                    "GABRIEL MOTA E SILVA" 1000 . .
  6 3018 "BOA VISTA"            1  87 6 "DEPUTADO FEDERAL" 1805 "I.N.S.S. INSTITUTO NACIONAL DE SEGURIDADE SOCIAL"                      "GABRIEL MOTA E SILVA" 1000 . .
  7 3018 "BOA VISTA"            5   9 6 "DEPUTADO FEDERAL" 1040 "MARIA GERTRUDES MOTA DE LIMA E.M."                                     "GABRIEL MOTA E SILVA" 1000 . .
  8 3069 "CANTÁ"               5 524 6 "DEPUTADO FEDERAL" 1201 "PROFESSORA LECI RIBEIRO ALVES E.M"                                     "GABRIEL MOTA E SILVA" 1000 . .
  9 3093 "MUCAJAÍ"             6  37 6 "DEPUTADO FEDERAL" 1066 "MARIA MARISELMA DE OLIVEIRA CRUZ"                                      "GABRIEL MOTA E SILVA" 1000 . .
 10 3034 "CARACARAÍ"           2 156 6 "DEPUTADO FEDERAL" 1236 "IDNÉIA BARBOSA FERREIRA E."                                           "GABRIEL MOTA E SILVA" 1000 . .
 11 3018 "BOA VISTA"            1 777 6 "DEPUTADO FEDERAL" 3719 "JESUS NAZARENO DE SOUZA CRUZ E.P.S.G."                                 "GABRIEL MOTA E SILVA" 1000 . .
 12 3018 "BOA VISTA"            5 141 6 "DEPUTADO FEDERAL" 1520 "ANTONIA COELHO DE LUCENA E.E."                                         "GABRIEL MOTA E SILVA" 1000 . .
 13 3085 "RORAINÓPOLIS"        8  36 6 "DEPUTADO FEDERAL" 1120 "ESCOLA MUNICIPAL JOSELMA LIMA DE SOUSA"                                "GABRIEL MOTA E SILVA" 1000 . .
 14 3018 "BOA VISTA"            1 517 6 "DEPUTADO FEDERAL" 3220 "FACULDADE CATHEDRAL"                                                   "GABRIEL MOTA E SILVA" 1000 . .
 15 3026 "IRACEMA"              6   1 6 "DEPUTADO FEDERAL" 1015 "DOM PEDRO II E.P."                                                     "GABRIEL MOTA E SILVA" 1000 . .
 16 3018 "BOA VISTA"            1 229 6 "DEPUTADO FEDERAL" 3298 "CANTINHO FELIZ E.M."                                                   "GABRIEL MOTA E SILVA" 1000 . .
 17 3018 "BOA VISTA"            5 120 6 "DEPUTADO FEDERAL" 1473 "NOVA CANAA E.M."                                                       "GABRIEL MOTA E SILVA" 1000 . .
 18 3018 "BOA VISTA"            1 665 6 "DEPUTADO FEDERAL" 3549 "ANTONIO CARLOS DA SILVA NATALINO E.E.P.G."                             "GABRIEL MOTA E SILVA" 1000 . .
 19 3018 "BOA VISTA"            1 684 6 "DEPUTADO FEDERAL" 3581 "CENTRO UNIVERSITÁRIO ESTÁCIO DA AMAZONIA (FACULDADE ATUAL)"          "GABRIEL MOTA E SILVA" 1000 . .
 20 3018 "BOA VISTA"            1  73 6 "DEPUTADO FEDERAL" 1627 "CENTRO DE ESTUDOS TECNOLÓGICO MARIA DA GLORIA"                        "GABRIEL MOTA E SILVA" 1000 . .
 21 3085 "RORAINÓPOLIS"        8  55 6 "DEPUTADO FEDERAL" 1120 "ESCOLA MUNICIPAL JOSELMA LIMA DE SOUSA"                                "GABRIEL MOTA E SILVA" 1000 . .
 22 3018 "BOA VISTA"            1 717 6 "DEPUTADO FEDERAL" 3646 "MAJOR ALCIDES RODRIGUES DOS SANTOS E.E.P.G."                           "GABRIEL MOTA E SILVA" 1000 . .
 23 3018 "BOA VISTA"            5 638 6 "DEPUTADO FEDERAL" 2267 "IRMÃ TEREZA PARODI C.M.E."                                            "GABRIEL MOTA E SILVA" 1000 . .
 24 3018 "BOA VISTA"            1 712 6 "DEPUTADO FEDERAL" 3638 "VOVÓ JÚLIA E.E."                                                     "GABRIEL MOTA E SILVA" 1000 . .
 25 3018 "BOA VISTA"            1 691 6 "DEPUTADO FEDERAL" 3590 "CUNHATA CURUMIN E.E."                                                  "GABRIEL MOTA E SILVA" 1000 . .
 26 3018 "BOA VISTA"            1 753 6 "DEPUTADO FEDERAL" 3727 "MARIA TERESA MACIEL DA SILVEIRA MELO E.M."                             "GABRIEL MOTA E SILVA" 1000 . .
 27 3018 "BOA VISTA"            5 401 6 "DEPUTADO FEDERAL" 2097 "PALMIRA DE CASTRO MACHADO E.M."                                        "GABRIEL MOTA E SILVA" 1000 . .
 28 3000 "CAROEBE"              4  16 6 "DEPUTADO FEDERAL" 1031 "E.P.M. SANTA BRUNHARA BARBOSA"                                         "GABRIEL MOTA E SILVA" 1000 . .
 29 3018 "BOA VISTA"            5 236 6 "DEPUTADO FEDERAL" 1228 "PROFESSOR SEVERINO GONÇALO GOMES CAVALCANTE E. E."                    "GABRIEL MOTA E SILVA" 1000 . .
 30 3034 "CARACARAÍ"           2 177 6 "DEPUTADO FEDERAL" 1414 "DEFENSORIA PÚBLICA DE CARACARAÍ"                                     "GABRIEL MOTA E SILVA" 1000 . .
 31 3018 "BOA VISTA"            1 611 6 "DEPUTADO FEDERAL" 3468 "COEMA SOUTO MAIOR NOGUEIRA E.E."                                       "GABRIEL MOTA E SILVA" 1000 . .
 32 3018 "BOA VISTA"            1 476 6 "DEPUTADO FEDERAL" 1210 "CAMILO DIAS E.E.PROF."                                                 "GABRIEL MOTA E SILVA" 1000 . .
 33 3018 "BOA VISTA"            5 322 6 "DEPUTADO FEDERAL" 1228 "PROFESSOR SEVERINO GONÇALO GOMES CAVALCANTE E. E."                    "GABRIEL MOTA E SILVA" 1000 . .
 34 3018 "BOA VISTA"            5 130 6 "DEPUTADO FEDERAL" 1490 "LUIZ RIBEIRO DE LIMA E.E."                                             "GABRIEL MOTA E SILVA" 1000 . .
 35 3050 "ALTO ALEGRE"          3  15 6 "DEPUTADO FEDERAL" 1015 "PROFESSORA EDINEIDE SALES CAMPELO E."                                  "GABRIEL MOTA E SILVA" 1000 . .
 36 3018 "BOA VISTA"            1 589 6 "DEPUTADO FEDERAL" 3425 "COLÉGIO ESTADUAL MILITARIZADO JACEGUAI REIS CUNHA E.E.P.G."           "GABRIEL MOTA E SILVA" 1000 . .
 37 3018 "BOA VISTA"            5 176 6 "DEPUTADO FEDERAL" 1953 "DR. LUIZ RITTLER BRITO DE LUCENA E.E."                                 "GABRIEL MOTA E SILVA" 1000 . .
 38 3018 "BOA VISTA"            5  11 6 "DEPUTADO FEDERAL" 1040 "MARIA GERTRUDES MOTA DE LIMA E.M."                                     "GABRIEL MOTA E SILVA" 1000 . .
 39 3018 "BOA VISTA"            1 638 6 "DEPUTADO FEDERAL" 3506 "DELACIR DE MELO LIMA E.M."                                             "GABRIEL MOTA E SILVA" 1000 . .
 40 3018 "BOA VISTA"            1  76 6 "DEPUTADO FEDERAL" 1996 "S.E.F.A.Z. SECRETARIA DE ESTADO DA FAZENDA"                            "GABRIEL MOTA E SILVA" 1000 . .
 41 3093 "MUCAJAÍ"             6  27 6 "DEPUTADO FEDERAL" 1023 "ANTÔNIO NASCIMENTO FILHO E.P."                                        "GABRIEL MOTA E SILVA" 1000 . .
 42 3018 "BOA VISTA"            1 659 6 "DEPUTADO FEDERAL" 3530 "CEM - COLÉGIO ESTADUAL MILITARIZADO PEDRO ELIAS ALBUQUERQUE PEREIRA"  "GABRIEL MOTA E SILVA" 1000 . .
 43 3018 "BOA VISTA"            1 618 6 "DEPUTADO FEDERAL" 3654 "PROFESSOR CARLOS RAIMUNDO RODRIGUES E.M."                              "GABRIEL MOTA E SILVA" 1000 . .
 44 3077 "BONFIM"               5 538 6 "DEPUTADO FEDERAL" 1015 "ARGENTINA CASTELO BRANCO E.E."                                         "GABRIEL MOTA E SILVA" 1000 . .
 45 3093 "MUCAJAÍ"             6  45 6 "DEPUTADO FEDERAL" 1074 "PADRE JOSÉ MONTICONE"                                                 "GABRIEL MOTA E SILVA" 1000 . .
 46 3042 "AMAJARI"              7  24 6 "DEPUTADO FEDERAL" 1023 "OVIDIO DIAS DE SOUZA E.E.F."                                           "GABRIEL MOTA E SILVA" 1000 . .
 47 3018 "BOA VISTA"            1 785 6 "DEPUTADO FEDERAL" 3514 "PROFESSOR CARLOS CASADIO E.E."                                         "GABRIEL MOTA E SILVA" 1000 . .
 48 3018 "BOA VISTA"            1 709 6 "DEPUTADO FEDERAL" 3620 "GIRASSOL E.E.F."                                                       "GABRIEL MOTA E SILVA" 1000 . .
 49 3069 "CANTÁ"               5 531 6 "DEPUTADO FEDERAL" 1279 "TIA ERCÍLIA E.M."                                                     "GABRIEL MOTA E SILVA" 1000 . .
 50 3018 "BOA VISTA"            5 317 6 "DEPUTADO FEDERAL" 2011 "RUJANE SEVERIANO DOS SANTOS  E.M."                                     "GABRIEL MOTA E SILVA" 1000 . .
 51 3018 "BOA VISTA"            5 248 6 "DEPUTADO FEDERAL" 1570 "REDE CIDADANIA ATENÇÃO ESPECIAL"                                     "GABRIEL MOTA E SILVA" 1000 . .
 52 3018 "BOA VISTA"            5 475 6 "DEPUTADO FEDERAL" 1198 "SENADOR DARCY RIBEIRO E.M."                                            "GABRIEL MOTA E SILVA" 1000 . .
 53 3018 "BOA VISTA"            1 458 6 "DEPUTADO FEDERAL" 3050 "I.F.R.R. INSTITUTO FEDERAL DE EDUC., CIÊNCIA E TECNOLOGIA DE RORAIMA" "GABRIEL MOTA E SILVA" 1000 . .
 54 3034 "CARACARAÍ"           2 170 6 "DEPUTADO FEDERAL" 1236 "IDNÉIA BARBOSA FERREIRA E."                                           "GABRIEL MOTA E SILVA" 1000 . .
 55 3018 "BOA VISTA"            5 650 6 "DEPUTADO FEDERAL" 1619 "DALICIO FARIAS FILHO E.M."                                             "GABRIEL MOTA E SILVA" 1000 . .
 56 3034 "CARACARAÍ"           2  91 6 "DEPUTADO FEDERAL" 1171 "ADONIAS BORGES DO CARMO E."                                            "GABRIEL MOTA E SILVA" 1000 . .
 57 3018 "BOA VISTA"            1 233 6 "DEPUTADO FEDERAL" 2402 "SILVIO LOFEGO BOTELHO C.S."                                            "GABRIEL MOTA E SILVA" 1000 . .
 58 3123 "PACARAIMA"            7   1 6 "DEPUTADO FEDERAL" 1015 "ESCOLA ESTADUAL INDIGENA TUCHAUA SILVESTRE MESSIAS"                    "GABRIEL MOTA E SILVA" 1000 . .
 59 3018 "BOA VISTA"            1 563 6 "DEPUTADO FEDERAL" 2860 "COLÉGIO DE APLICAÇÃO-CAP - UFRR"                                    "GABRIEL MOTA E SILVA" 1000 . .
 60 3018 "BOA VISTA"            1 720 6 "DEPUTADO FEDERAL" 3646 "MAJOR ALCIDES RODRIGUES DOS SANTOS E.E.P.G."                           "GABRIEL MOTA E SILVA" 1000 . .
 61 3018 "BOA VISTA"            1 268 6 "DEPUTADO FEDERAL" 2275 "CARLOS DRUMOND DE ANDRADE E.E."                                        "GABRIEL MOTA E SILVA" 1000 . .
 62 3085 "RORAINÓPOLIS"        8  61 6 "DEPUTADO FEDERAL" 1031 "ESCOLA EST. JOSÉ DE ALENCAR"                                          "GABRIEL MOTA E SILVA" 1000 . .
 63 3042 "AMAJARI"              7  86 6 "DEPUTADO FEDERAL" 1147 "ESCOLA MUNICIPAL MARIA ALZIRA MARINHO DE BRITO"                        "GABRIEL MOTA E SILVA" 1000 . .
 64 3018 "BOA VISTA"            1 552 6 "DEPUTADO FEDERAL" 1511 "SAO VICENTE DE PAULA E.E."                                             "GABRIEL MOTA E SILVA" 1000 . .
 65 3018 "BOA VISTA"            1 177 6 "DEPUTADO FEDERAL" 1112 "ESCOLA MUNICIPAL NEWTON TAVARES"                                       "GABRIEL MOTA E SILVA" 1000 . .
 66 3034 "CARACARAÍ"           2 160 6 "DEPUTADO FEDERAL" 1040 "COUTO DE MAGALHÃES E. M."                                             "GABRIEL MOTA E SILVA" 1000 . .
 67 3131 "SÃO JOÃO DA BALIZA" 4  79 6 "DEPUTADO FEDERAL" 1040 "E.P.E. FRANCISCO RICARDO DE MACEDO"                                    "GABRIEL MOTA E SILVA" 1000 . .
 68 3069 "CANTÁ"               5 534 6 "DEPUTADO FEDERAL" 1279 "TIA ERCÍLIA E.M."                                                     "GABRIEL MOTA E SILVA" 1000 . .
 69 3123 "PACARAIMA"            7   9 6 "DEPUTADO FEDERAL" 1031 "CASIMIRO DE ABREU E.P."                                                "GABRIEL MOTA E SILVA" 1000 . .
 70 3018 "BOA VISTA"            1  46 6 "DEPUTADO FEDERAL" 1376 "S.E.A.P.A. SECRETARIA DA AGRICULTURA, PECUÁRIA E ABASTECIMENTO"       "GABRIEL MOTA E SILVA" 1000 . .
 71 3018 "BOA VISTA"            1 757 6 "DEPUTADO FEDERAL" 3727 "MARIA TERESA MACIEL DA SILVEIRA MELO E.M."                             "GABRIEL MOTA E SILVA" 1000 . .
 72 3085 "RORAINÓPOLIS"        8  63 6 "DEPUTADO FEDERAL" 1120 "ESCOLA MUNICIPAL JOSELMA LIMA DE SOUSA"                                "GABRIEL MOTA E SILVA" 1000 . .
 73 3069 "CANTÁ"               5 486 6 "DEPUTADO FEDERAL" 1031 "JOSE AURELIANO DA COSTA E.E."                                          "GABRIEL MOTA E SILVA" 1000 . .
 74 3018 "BOA VISTA"            5 640 6 "DEPUTADO FEDERAL" 2291 "ZACARIAS ASSUNÇÃO RIBEIRO ARAÚJO E.M."                              "GABRIEL MOTA E SILVA" 1000 . .
 75 3018 "BOA VISTA"            5 366 6 "DEPUTADO FEDERAL" 1481 "DR. ULYSSES GUIMARAES E.E."                                            "GABRIEL MOTA E SILVA" 1000 . .
 76 3018 "BOA VISTA"            1 540 6 "DEPUTADO FEDERAL" 2860 "COLÉGIO DE APLICAÇÃO-CAP - UFRR"                                    "GABRIEL MOTA E SILVA" 1000 . .
 77 3018 "BOA VISTA"            1 317 6 "DEPUTADO FEDERAL" 2305 "VITORIA MOTA CRUZ"                                                     "GABRIEL MOTA E SILVA" 1000 . .
 78 3000 "CAROEBE"              4  53 6 "DEPUTADO FEDERAL" 1015 "PROFESSOR VIDAL DA PENHA E.P."                                         "GABRIEL MOTA E SILVA" 1000 . .
 79 3018 "BOA VISTA"            1 725 6 "DEPUTADO FEDERAL" 3662 "MENINO JESUS DE PRAGA P.E."                                            "GABRIEL MOTA E SILVA" 1000 . .
 80 3034 "CARACARAÍ"           2 171 6 "DEPUTADO FEDERAL" 1295 "SEBASTIÃO BENICIO DA SILVA E."                                        "GABRIEL MOTA E SILVA" 1000 . .
 81 3018 "BOA VISTA"            1 742 6 "DEPUTADO FEDERAL" 3719 "JESUS NAZARENO DE SOUZA CRUZ E.P.S.G."                                 "GABRIEL MOTA E SILVA" 1000 . .
 82 3115 "NORMANDIA"            5 601 6 "DEPUTADO FEDERAL" 1104 "GERALDO CRISPIM E. E. INDÍGENA"                                       "GABRIEL MOTA E SILVA" 1000 . .
 83 3018 "BOA VISTA"            5 364 6 "DEPUTADO FEDERAL" 1910 "PROFESSORA AMAZONA DE OLIVEIRA MONTEIRO E. M."                         "GABRIEL MOTA E SILVA" 1000 . .
 84 3158 "SÃO LUIZ"            4  87 6 "DEPUTADO FEDERAL" 1201 "E.P.E. DARCY RIBEIRO"                                                  "GABRIEL MOTA E SILVA" 1000 . .
 85 3069 "CANTÁ"               5 490 6 "DEPUTADO FEDERAL" 1040 "MARIO HOMEM DE MELO E..E"                                              "GABRIEL MOTA E SILVA" 1000 . .
 86 3050 "ALTO ALEGRE"          3 240 6 "DEPUTADO FEDERAL" 1180 "ESCOLA MUNICIPAL TROPICAL"                                             "GABRIEL MOTA E SILVA" 1000 . .
 87 3018 "BOA VISTA"            1 537 6 "DEPUTADO FEDERAL" 2445 "EDSONINA DE BARROS VILLA E.M.PROFª."                                  "GABRIEL MOTA E SILVA" 1000 . .
 88 3050 "ALTO ALEGRE"          3 207 6 "DEPUTADO FEDERAL" 1066 "MARECHAL RONDON E.P."                                                  "GABRIEL MOTA E SILVA" 1000 . .
 89 3018 "BOA VISTA"            1 629 6 "DEPUTADO FEDERAL" 3492 "PROFESSOR CARLOS RAIMUNDO RODRIGUES E.M."                              "GABRIEL MOTA E SILVA" 1000 . .
 90 3123 "PACARAIMA"            7   2 6 "DEPUTADO FEDERAL" 1015 "ESCOLA ESTADUAL INDIGENA TUCHAUA SILVESTRE MESSIAS"                    "GABRIEL MOTA E SILVA" 1000 . .
 91 3018 "BOA VISTA"            1 560 6 "DEPUTADO FEDERAL" 3344 "ARCO-IRIS E.M."                                                        "GABRIEL MOTA E SILVA" 1000 . .
 92 3018 "BOA VISTA"            1 597 6 "DEPUTADO FEDERAL" 3441 "PROFESSORA CARMEM EUGENIA MACAGI E.E.F."                               "GABRIEL MOTA E SILVA" 1000 . .
 93 3018 "BOA VISTA"            1 716 6 "DEPUTADO FEDERAL" 3646 "MAJOR ALCIDES RODRIGUES DOS SANTOS E.E.P.G."                           "GABRIEL MOTA E SILVA" 1000 . .
 94 3018 "BOA VISTA"            5 431 6 "DEPUTADO FEDERAL" 2216 "CASA MÃE TIA LIDIA"                                                   "GABRIEL MOTA E SILVA" 1000 . .
 95 3085 "RORAINÓPOLIS"        8  57 6 "DEPUTADO FEDERAL" 1040 "ESCOLA EST. PADRE EUGENIO POSSAMAI"                                    "GABRIEL MOTA E SILVA" 1000 . .
 96 3115 "NORMANDIA"            5 592 6 "DEPUTADO FEDERAL" 1058 "ÍNDIO MACUXI E.E.INDÍGENA"                                           "GABRIEL MOTA E SILVA" 1000 . .
 97 3018 "BOA VISTA"            1 656 6 "DEPUTADO FEDERAL" 3530 "CEM - COLÉGIO ESTADUAL MILITARIZADO PEDRO ELIAS ALBUQUERQUE PEREIRA"  "GABRIEL MOTA E SILVA" 1000 . .
 98 3018 "BOA VISTA"            1  41 6 "DEPUTADO FEDERAL" 1279 "ANA LIBORIA E.E."                                                      "GABRIEL MOTA E SILVA" 1000 . .
 99 3018 "BOA VISTA"            5 305 6 "DEPUTADO FEDERAL" 1937 "ALBINO TAVARES E.E."                                                   "GABRIEL MOTA E SILVA" 1000 . .
100 3018 "BOA VISTA"            5 168 6 "DEPUTADO FEDERAL" 1570 "REDE CIDADANIA ATENÇÃO ESPECIAL"                                     "GABRIEL MOTA E SILVA" 1000 . .
101 3018 "BOA VISTA"            5 654 6 "DEPUTADO FEDERAL" 1937 "ALBINO TAVARES E.E."                                                   "GABRIEL MOTA E SILVA" 1000 . .
102 3018 "BOA VISTA"            5 252 6 "DEPUTADO FEDERAL" 1929 "BALDUÍNO WOTTRICH E. M."                                              "GABRIEL MOTA E SILVA" 1000 . .
103 3018 "BOA VISTA"            5 343 6 "DEPUTADO FEDERAL" 1210 "LUIZ CANARA E.M."                                                      "GABRIEL MOTA E SILVA" 1000 . .
104 3131 "SÃO JOÃO DA BALIZA" 4  93 6 "DEPUTADO FEDERAL" 1040 "E.P.E. FRANCISCO RICARDO DE MACEDO"                                    "GABRIEL MOTA E SILVA" 1000 . .
105 3158 "SÃO LUIZ"            4  21 6 "DEPUTADO FEDERAL" 1163 "E.P.E. JOAO RODRIGUES DA SILVA"                                        "GABRIEL MOTA E SILVA" 1000 . .
106 3018 "BOA VISTA"            1 361 6 "DEPUTADO FEDERAL" 1570 "13 DE SETEMBRO E.E."                                                   "GABRIEL MOTA E SILVA" 1000 . .
107 3018 "BOA VISTA"            1 316 6 "DEPUTADO FEDERAL" 2275 "CARLOS DRUMOND DE ANDRADE E.E."                                        "GABRIEL MOTA E SILVA" 1000 . .
108 3018 "BOA VISTA"            1 477 6 "DEPUTADO FEDERAL" 1511 "SAO VICENTE DE PAULA E.E."                                             "GABRIEL MOTA E SILVA" 1000 . .
109 3069 "CANTÁ"               5 499 6 "DEPUTADO FEDERAL" 1082 "PROFESSORA GENIRA BRITO RODRIGUES E.E."                                "GABRIEL MOTA E SILVA" 1000 . .
110 3093 "MUCAJAÍ"             6  32 6 "DEPUTADO FEDERAL" 1058 "JESUS DE NAZARÉ E.P.G."                                               "GABRIEL MOTA E SILVA" 1000 . .
111 3018 "BOA VISTA"            1 340 6 "DEPUTADO FEDERAL" 1481 "GONCALVES DIAS E.E."                                                   "GABRIEL MOTA E SILVA" 1000 . .
112 3018 "BOA VISTA"            1 788 6 "DEPUTADO FEDERAL" 3581 "CENTRO UNIVERSITÁRIO ESTÁCIO DA AMAZONIA (FACULDADE ATUAL)"          "GABRIEL MOTA E SILVA" 1000 . .
113 3050 "ALTO ALEGRE"          3  17 6 "DEPUTADO FEDERAL" 1171 "UERR - UNIVERSIDADE ESTADUAL DE RORAIMA"                               "GABRIEL MOTA E SILVA" 1000 . .
114 3115 "NORMANDIA"            5 583 6 "DEPUTADO FEDERAL" 1031 "MARIANO VIEIRA E.E."                                                   "GABRIEL MOTA E SILVA" 1000 . .
115 3018 "BOA VISTA"            5 146 6 "DEPUTADO FEDERAL" 1538 "PROFESSORA MARIA DE LOURDES NEVES E.E."                                "GABRIEL MOTA E SILVA" 1000 . .
116 3018 "BOA VISTA"            1 774 6 "DEPUTADO FEDERAL" 3751 "MARIA TERESA MACIEL DA SILVEIRA MELO E.M."                             "GABRIEL MOTA E SILVA" 1000 . .
117 3018 "BOA VISTA"            5 460 6 "DEPUTADO FEDERAL" 2143 "JUSLANY DE SOUZA FLORES E.M."                                          "GABRIEL MOTA E SILVA" 1000 . .
118 3018 "BOA VISTA"            1 641 6 "DEPUTADO FEDERAL" 3514 "PROFESSOR CARLOS CASADIO E.E."                                         "GABRIEL MOTA E SILVA" 1000 . .
119 3018 "BOA VISTA"            5 350 6 "DEPUTADO FEDERAL" 1791 "LUIZ CANARA E.M."                                                      "GABRIEL MOTA E SILVA" 1000 . .
120 3018 "BOA VISTA"            1 748 6 "DEPUTADO FEDERAL" 3719 "JESUS NAZARENO DE SOUZA CRUZ E.P.S.G."                                 "GABRIEL MOTA E SILVA" 1000 . .
121 3085 "RORAINÓPOLIS"        8  52 6 "DEPUTADO FEDERAL" 1163 "ESCOLA MUNICIPAL JOSEFA DA SILVA GOMES"                                "GABRIEL MOTA E SILVA" 1000 . .
122 3069 "CANTÁ"               5 516 6 "DEPUTADO FEDERAL" 1163 "OTILIA SOUSA PINTO E.E."                                               "GABRIEL MOTA E SILVA" 1000 . .
123 3034 "CARACARAÍ"           2 112 6 "DEPUTADO FEDERAL" 1112 "PADRE CALLERI E. P. G."                                                "GABRIEL MOTA E SILVA" 1000 . .
124 3018 "BOA VISTA"            5 118 6 "DEPUTADO FEDERAL" 1473 "NOVA CANAA E.M."                                                       "GABRIEL MOTA E SILVA" 1000 . .
125 3026 "IRACEMA"              6   3 6 "DEPUTADO FEDERAL" 1015 "DOM PEDRO II E.P."                                                     "GABRIEL MOTA E SILVA" 1000 . .
126 3085 "RORAINÓPOLIS"        8  17 6 "DEPUTADO FEDERAL" 1040 "ESCOLA EST. PADRE EUGENIO POSSAMAI"                                    "GABRIEL MOTA E SILVA" 1000 . .
127 3018 "BOA VISTA"            1 295 6 "DEPUTADO FEDERAL" 3247 "SESI"                                                                  "GABRIEL MOTA E SILVA" 1000 . .
128 3018 "BOA VISTA"            1 410 6 "DEPUTADO FEDERAL" 1210 "CAMILO DIAS E.E.PROF."                                                 "GABRIEL MOTA E SILVA" 1000 . .
129 3018 "BOA VISTA"            5  34 6 "DEPUTADO FEDERAL" 1210 "LUIZ CANARA E.M."                                                      "GABRIEL MOTA E SILVA" 1000 . .
130 3085 "RORAINÓPOLIS"        8  56 6 "DEPUTADO FEDERAL" 1023 "COLEGIO MILITARIZADO TENENTE JOAO DE AZEVEDO CRUZ"                     "GABRIEL MOTA E SILVA" 1000 . .
131 3018 "BOA VISTA"            1 664 6 "DEPUTADO FEDERAL" 3549 "ANTONIO CARLOS DA SILVA NATALINO E.E.P.G."                             "GABRIEL MOTA E SILVA" 1000 . .
132 3018 "BOA VISTA"            1 705 6 "DEPUTADO FEDERAL" 3620 "GIRASSOL E.E.F."                                                       "GABRIEL MOTA E SILVA" 1000 . .
133 3050 "ALTO ALEGRE"          3  20 6 "DEPUTADO FEDERAL" 1031 "SADOC PEREIRA E.P."                                                    "GABRIEL MOTA E SILVA" 1000 . .
134 3093 "MUCAJAÍ"             6  40 6 "DEPUTADO FEDERAL" 1066 "MARIA MARISELMA DE OLIVEIRA CRUZ"                                      "GABRIEL MOTA E SILVA" 1000 . .
135 3018 "BOA VISTA"            5 641 6 "DEPUTADO FEDERAL" 2283 "PROFESSORA IVANY DOS SANTOS PARENTE E.M."                              "GABRIEL MOTA E SILVA" 1000 . .
136 3077 "BONFIM"               5 570 6 "DEPUTADO FEDERAL" 1147 "ALDEBARO JOSÉ ALCÂNTARA E.E."                                        "GABRIEL MOTA E SILVA" 1000 . .
137 3018 "BOA VISTA"            1 171 6 "DEPUTADO FEDERAL" 1392 "COSTA E SILVA E.E. PRESIDENTE"                                         "GABRIEL MOTA E SILVA" 1000 . .
138 3018 "BOA VISTA"            1  32 6 "DEPUTADO FEDERAL" 2887 "VOVÔ DANDÃE E.M."                                                    "GABRIEL MOTA E SILVA" 1000 . .
139 3000 "CAROEBE"              4  74 6 "DEPUTADO FEDERAL" 1023 "TEREZA TEODORO DE OLIVEIRA E.P."                                       "GABRIEL MOTA E SILVA" 1000 . .
140 3018 "BOA VISTA"            5 103 6 "DEPUTADO FEDERAL" 1430 "PROFESSORA MARIA DOS PRAZERES MOTA E.E."                               "GABRIEL MOTA E SILVA" 1000 . .
141 3018 "BOA VISTA"            1 650 6 "DEPUTADO FEDERAL" 3522 "OLAVO BRASIL FILHO E.E.P.G."                                           "GABRIEL MOTA E SILVA" 1000 . .
142 3034 "CARACARAÍ"           2   2 6 "DEPUTADO FEDERAL" 1040 "COUTO DE MAGALHÃES E. M."                                             "GABRIEL MOTA E SILVA" 1000 . .
143 3018 "BOA VISTA"            5 432 6 "DEPUTADO FEDERAL" 2216 "CASA MÃE TIA LIDIA"                                                   "GABRIEL MOTA E SILVA" 1000 . .
144 3018 "BOA VISTA"            1  37 6 "DEPUTADO FEDERAL" 3123 "SETRABES - SECRETARIA DO TRABALHO E BEM-ESTAR SOCIAL"                  "GABRIEL MOTA E SILVA" 1000 . .
145 3018 "BOA VISTA"            5 271 6 "DEPUTADO FEDERAL" 1945 "RAIMUNDO ELOY GOMES E.M."                                              "GABRIEL MOTA E SILVA" 1000 . .
146 3077 "BONFIM"               5 545 6 "DEPUTADO FEDERAL" 1023 "LAURIANO JOÃO DA SILVA E.M.INDÍGENA"                                 "GABRIEL MOTA E SILVA" 1000 . .
147 3018 "BOA VISTA"            5 225 6 "DEPUTADO FEDERAL" 1791 "LUIZ CANARA E.M."                                                      "GABRIEL MOTA E SILVA" 1000 . .
148 3107 "UIRAMUTÃ"            7  56 6 "DEPUTADO FEDERAL" 1066 "ESCOLA TUCHAUA PEDRO BARBOSA DA SILVA"                                 "GABRIEL MOTA E SILVA" 1000 . .
149 3018 "BOA VISTA"            5 390 6 "DEPUTADO FEDERAL" 1910 "PROFESSORA AMAZONA DE OLIVEIRA MONTEIRO E. M."                         "GABRIEL MOTA E SILVA" 1000 . .
150 3131 "SÃO JOÃO DA BALIZA" 4 122 6 "DEPUTADO FEDERAL" 1015 "E.P.M. DARCY PEDROSO DA SILVA"                                         "GABRIEL MOTA E SILVA" 1000 . .
151 3018 "BOA VISTA"            1 781 6 "DEPUTADO FEDERAL" 1279 "ANA LIBORIA E.E."                                                      "GABRIEL MOTA E SILVA" 1000 . .
152 3018 "BOA VISTA"            5  25 6 "DEPUTADO FEDERAL" 1597 "PROFESSORA WANDA DAVID AGUIAR E.E."                                    "GABRIEL MOTA E SILVA" 1000 . .
153 3018 "BOA VISTA"            5 245 6 "DEPUTADO FEDERAL" 1457 "SENADOR HELIO DA COSTA CAMPOS E.E."                                    "GABRIEL MOTA E SILVA" 1000 . .
154 3018 "BOA VISTA"            1 595 6 "DEPUTADO FEDERAL" 3441 "PROFESSORA CARMEM EUGENIA MACAGI E.E.F."                               "GABRIEL MOTA E SILVA" 1000 . .
155 3018 "BOA VISTA"            5 150 6 "DEPUTADO FEDERAL" 1546 "FAGUNDES VARELLA E.E."                                                 "GABRIEL MOTA E SILVA" 1000 . .
156 3018 "BOA VISTA"            1 786 6 "DEPUTADO FEDERAL" 3557 "PASTOR FERNANDO GRANGEIRO DE MENEZES E.E."                             "GABRIEL MOTA E SILVA" 1000 . .
157 3018 "BOA VISTA"            1 181 6 "DEPUTADO FEDERAL" 2801 "CARLOS DRUMOND DE ANDRADE E.E."                                        "GABRIEL MOTA E SILVA" 1000 . .
158 3018 "BOA VISTA"            5 175 6 "DEPUTADO FEDERAL" 1953 "DR. LUIZ RITTLER BRITO DE LUCENA E.E."                                 "GABRIEL MOTA E SILVA" 1000 . .
159 3018 "BOA VISTA"            1 755 6 "DEPUTADO FEDERAL" 3727 "MARIA TERESA MACIEL DA SILVEIRA MELO E.M."                             "GABRIEL MOTA E SILVA" 1000 . .
160 3131 "SÃO JOÃO DA BALIZA" 4 110 6 "DEPUTADO FEDERAL" 1015 "E.P.M. DARCY PEDROSO DA SILVA"                                         "GABRIEL MOTA E SILVA" 1000 . .
end

[Bruno Hoepers]

Example of “voters’ profile dataset”:

* Example generated by -dataex-. For more info, type help dataex
clear
input str2 sg_uf int cd_municipio str20 nm_municipio byte nr_zona int(nr_secao nr_local_votacao) float(perc_genero_fem perc_faixa_et_16_a_20a perc_faixa_et_70_100a eleitores_analf_perc eleitores_ens_sup_perc)
"RR" 3018 "BOA VISTA"  1   1 1015   .477707  .035031848   .09872612 .0031847134    .1433121
"RR" 3018 "BOA VISTA"  1   2 1015  .5498392  .019292604   .13826367  .003215434   .13504823
"RR" 3018 "BOA VISTA"  1   3 1015  .5366667  .016666668   .08666667 .0033333334   .14333333
"RR" 3018 "BOA VISTA"  1   4 1015 .51644737    .1118421   .08223684           0    .1644737
"RR" 3018 "BOA VISTA"  1   5 1015  .5493421    .1118421    .1118421  .003289474   .10855263
"RR" 3018 "BOA VISTA"  1   6 1015 .55263156   .15789473   .12171052           0   .13157895
"RR" 3018 "BOA VISTA"  1   7 1481 .50729924   .05474453    .1240876   .00729927    .1459854
"RR" 3018 "BOA VISTA"  1  20 1112  .5849057  .004716981    .1509434  .009433962   .06132076
"RR" 3018 "BOA VISTA"  1  22 1163  .5298013  .029801324   .17218544           0    .1192053
"RR" 3018 "BOA VISTA"  1  23 1171 .58702064   .05309734   .12684366  .005899705    .1179941
"RR" 3018 "BOA VISTA"  1  24 2259  .5829384   .01421801   .09478673           0    .1042654
"RR" 3018 "BOA VISTA"  1  25 2259 .53846157  .028846154    .1826923  .014423077   .13942307
"RR" 3018 "BOA VISTA"  1  26 1171  .5988024   .04191617   .14071856  .008982036   .11676647
"RR" 3018 "BOA VISTA"  1  27 2259  .5119617  .009569378    .0861244  .009569378   .14354067
"RR" 3018 "BOA VISTA"  1  28 1210  .6360544   .06122449    .1122449  .010204081   .09183674
"RR" 3018 "BOA VISTA"  1  29 1210  .5665529   .06484642   .08532424  .010238908   .09556314
"RR" 3018 "BOA VISTA"  1  30 1210  .4879725    .0927835    .1065292  .020618556   .09621993
"RR" 3018 "BOA VISTA"  1  31 1210  .5586207  .072413795   .08275862  .013793103   .10344828
"RR" 3018 "BOA VISTA"  1  32 2887 .56084657   .06349207   .11111111           0   .11111111
"RR" 3018 "BOA VISTA"  1  35 3123   .603352           0    .1564246           0   .12849163
"RR" 3018 "BOA VISTA"  1  36 3123        .5           0   .11538462           0   .15934066
"RR" 3018 "BOA VISTA"  1  37 3123  .5604396           0   .13736264   .01098901   .14285715
"RR" 3018 "BOA VISTA"  1  38 2682  .6025237   .05678234   .11356467  .006309148   .10725552
"RR" 3018 "BOA VISTA"  1  39 1279 .54415953   .06267806   .08831909   .01139601   .13390313
"RR" 3018 "BOA VISTA"  1  40 1279  .4929178   .07365439   .11331445  .002832861   .15580736
"RR" 3018 "BOA VISTA"  1  41 1279  .4957265   .04843305   .08262108  .002849003   .14245014
"RR" 3018 "BOA VISTA"  1  42 3247  .5678392  .005025126    .1155779  .005025126   .09547739
"RR" 3018 "BOA VISTA"  1  43 1333  .5522388   .06865671   .07164179 .0029850747   .13432837
"RR" 3018 "BOA VISTA"  1  44 3050  .5825826   .03903904   .07507508  .003003003   .14114115
"RR" 3018 "BOA VISTA"  1  45 3050  .5970588    .0382353   .12058824           0   .13529412
"RR" 3018 "BOA VISTA"  1  46 1376  .4814815   .03292181    .1728395  .004115226   .10699589
"RR" 3018 "BOA VISTA"  1  47 1376  .5247934   .03305785    .1735537  .004132231   .11157025
"RR" 3018 "BOA VISTA"  1  48 1392  .5017301   .05536332   .07612456  .003460208   .15916955
"RR" 3018 "BOA VISTA"  1  49 1392  .5448276   .05172414    .1137931  .003448276   .13793103
"RR" 3018 "BOA VISTA"  1  50 1392 .52097905   .04195804   .15034965  .006993007   .13986014
"RR" 3018 "BOA VISTA"  1  51 3247  .5025126   .05527638     .080402           0   .11055277
"RR" 3018 "BOA VISTA"  1  52 1503 .54635763   .04966887   .12251656           0   .13245033
"RR" 3018 "BOA VISTA"  1  53 1481 .54814816   .04814815  .033333335           0    .1851852
"RR" 3018 "BOA VISTA"  1  54 1503  .5366667   .05666667         .12 .0033333334   .10666667
"RR" 3018 "BOA VISTA"  1  55 1503  .5506757   .05743243   .15202703  .016891891   .09797297
"RR" 3018 "BOA VISTA"  1  56 1619  .5284974           0   .05699482  .005181347   .11917099
"RR" 3018 "BOA VISTA"  1  57 1619 .53107345           0   .07909604   .02824859   .10169491
"RR" 3018 "BOA VISTA"  1  58 1511 .53313255   .04819277   .07831325  .003012048   .08433735
"RR" 3018 "BOA VISTA"  1  59 1511  .5121951  .067073174    .0945122  .006097561   .10365853
"RR" 3018 "BOA VISTA"  1  60 3387  .6103896           0   .14285715  .006493506   .11688311
"RR" 3018 "BOA VISTA"  1  61 3387 .54347825           0    .1630435  .010869565   .06521739
"RR" 3018 "BOA VISTA"  1  62 3387        .5           0   .17045455           0   .11363637
"RR" 3018 "BOA VISTA"  1  63 1619  .5104167           0   .09895834  .005208333   .13541667
"RR" 3018 "BOA VISTA"  1  64 3298       .55    .1617647   .08235294  .005882353    .0882353
"RR" 3018 "BOA VISTA"  1  65 1570  .5966851           0   .18232045   .02209945    .0441989
"RR" 3018 "BOA VISTA"  1  66 1570  .5248619           0     .160221  .011049724   .07734807
"RR" 3018 "BOA VISTA"  1  67 3298  .4911765   .14117648   .09117647  .020588236    .1117647
"RR" 3018 "BOA VISTA"  1  68 1619      .515           0        .125         .01          .1
"RR" 3018 "BOA VISTA"  1  69 1619  .5510204           0    .1122449  .020408163   .12755102
"RR" 3018 "BOA VISTA"  1  70 1627  .6166667           0   .14166667  .008333334   .09166667
"RR" 3018 "BOA VISTA"  1  71 1627  .5685484  .004032258   .12096774           0   .13306452
"RR" 3018 "BOA VISTA"  1  72 1627 .56962025           0    .1814346  .004219409   .10548523
"RR" 3018 "BOA VISTA"  1  73 1627  .5080645           0   .14516129           0   .10080645
"RR" 3018 "BOA VISTA"  1  74 1775   .527027   .05405406    .0945946           0   .13513513
"RR" 3018 "BOA VISTA"  1  75 1759  .4733333   .04666667   .06666667  .006666667   .12666667
"RR" 3018 "BOA VISTA"  1  76 1996  .5606936           0   .21387284           0   .12138728
"RR" 3018 "BOA VISTA"  1  77 1503  .5233333         .04         .06 .0033333334         .15
"RR" 3018 "BOA VISTA"  1  78 3395  .6202531           0   .15822785  .006329114   .16455697
"RR" 3018 "BOA VISTA"  1  79 3395 .58433735           0    .1746988  .006024096   .09036145
"RR" 3018 "BOA VISTA"  1  80 1716   .578199   .07582939    .1421801           0   .08530806
"RR" 3018 "BOA VISTA"  1  81 1732 .51968503  .062992126    .1023622  .003937008   .16535433
"RR" 3018 "BOA VISTA"  1  82 3778 .55792683           0   .17987806           0   .11585366
"RR" 3018 "BOA VISTA"  1  83 1759 .55440414   .01554404   .10362694   .01554404   .16062176
"RR" 3018 "BOA VISTA"  1  84 1775  .5205479    .0958904    .0890411           0   .05479452
"RR" 3018 "BOA VISTA"  1  85 1759 .45695364  .026490066   .10596026           0   .14569536
"RR" 3018 "BOA VISTA"  1  86 1759  .4666667   .04666667   .07333333  .006666667   .11333334
"RR" 3018 "BOA VISTA"  1  87 1805 .51452285   .04979253   .10788382           0   .10788382
"RR" 3018 "BOA VISTA"  1  88 1830  .5113636   .07386363   .10227273  .005681818   .10795455
"RR" 3018 "BOA VISTA"  1  89 1830  .6158192   .05649718    .1299435           0   .11299435
"RR" 3018 "BOA VISTA"  1  90 1848  .4759207    .0509915   .03116147           0    .1756374
"RR" 3018 "BOA VISTA"  1  91 2208 .55479455  .020547945   .08219178  .006849315    .1952055
"RR" 3018 "BOA VISTA"  1  92 1732  .5378486   .05577689   .11553785           0   .10756972
"RR" 3018 "BOA VISTA"  1  93 1732 .55378485   .03984064   .09561753           0   .13147411
"RR" 3018 "BOA VISTA"  1  96 1775 .49324325   .08783784    .0945946           0    .1081081
"RR" 3018 "BOA VISTA"  1  97 1775 .56164384    .1369863    .0958904           0   .13013698
"RR" 3018 "BOA VISTA"  1  98 1759  .5167785  .033557046   .12751678           0    .1610738
"RR" 3018 "BOA VISTA"  1  99 1996 .51086956           0    .1521739           0   .10869565
"RR" 3018 "BOA VISTA"  1 100 1732  .5222672   .04048583    .0242915           0   .12145749
"RR" 3018 "BOA VISTA"  1 101 1732        .5   .07258064    .0766129           0    .1612903
"RR" 3018 "BOA VISTA"  1 102 1759  .4868421   .02631579   .11842106           0    .1118421
"RR" 3018 "BOA VISTA"  1 104 1376 .53112036   .05809129   .08298755           0    .1701245
"RR" 3018 "BOA VISTA"  1 105 1376  .5720165   .04526749    .0781893           0   .19753087
"RR" 3018 "BOA VISTA"  1 106 2208  .5101351   .11824324   .08108108           0   .10472973
"RR" 3018 "BOA VISTA"  1 117 1759 .53061223  .010204081  .030612245  .005102041   .12755102
"RR" 3018 "BOA VISTA"  1 118 2208   .550173  .003460208   .15916955  .003460208   .07612456
"RR" 3018 "BOA VISTA"  1 155 1112     .5625  .014423077   .04807692           0   .13461539
"RR" 3018 "BOA VISTA"  1 156 3247  .5510204   .05102041  .035714287           0   .10204082
"RR" 3018 "BOA VISTA"  1 162 1996  .5647059  .005882353  .064705886  .011764706   .11764706
"RR" 3018 "BOA VISTA"  1 167 1481  .5315985    .0929368   .05576208           0    .1895911
"RR" 3018 "BOA VISTA"  1 169 2259  .5592417  .033175357   .07109005           0   .12796208
"RR" 3018 "BOA VISTA"  1 170 1333 .52395207   .05389221   .04491018           0   .10778443
"RR" 3018 "BOA VISTA"  1 171 1392  .4861111   .03819444   .04861111  .003472222   .12152778
"RR" 3018 "BOA VISTA"  1 176 1112  .5409091  .013636364   .07272727  .013636364   .13181818
"RR" 3018 "BOA VISTA"  1 177 1112 .56164384   .00456621   .02739726   .00456621   .10502283
"RR" 3018 "BOA VISTA"  1 179 1163  .5585284   .04347826   .05685619 .0033444816   .15050167
"RR" 3018 "BOA VISTA"  1 180 1171  .5181818   .03030303   .07272727  .009090909   .12727273
"RR" 3018 "BOA VISTA"  1 181 2801 .57058823 .0029411765  .064705886           0   .17941177
"RR" 3018 "BOA VISTA"  1 182 3123  .5657143  .005714286  .074285716   .01142857   .17714286
"RR" 3018 "BOA VISTA"  1 183 1503 .54966885  .069536425   .04635762  .006622517   .13245033
"RR" 3018 "BOA VISTA"  1 184 1619 .50549453           0   .04945055           0    .0879121
"RR" 3018 "BOA VISTA"  1 185 1570   .519774           0   .10734463   .03954802  .073446326
"RR" 3018 "BOA VISTA"  1 186 1775  .4489796   .05442177  .027210884  .006802721   .12244898
"RR" 3018 "BOA VISTA"  1 187 1732   .502008    .0562249  .036144577  .008032128    .1767068
"RR" 3018 "BOA VISTA"  1 189 1732  .4879032   .05241935   .03629032  .012096774   .10887097
"RR" 3018 "BOA VISTA"  1 190 1775 .50340134    .0952381   .04081633           0   .10884354
"RR" 3018 "BOA VISTA"  1 200 3050 .52537316   .04179104   .05373134           0    .1641791
"RR" 3018 "BOA VISTA"  1 201 1376  .5294118  .033613447   .07563026  .012605042   .14705883
"RR" 3018 "BOA VISTA"  1 202 3301 .52284265   .05076142   .05583756  .010152284   .08121827
"RR" 3018 "BOA VISTA"  1 203 3387  .4713376           0  .070063695           0   .14649682
"RR" 3018 "BOA VISTA"  1 204 1627  .5643154           0   .05809129           0   .09958506
"RR" 3018 "BOA VISTA"  1 205 1716   .552381   .06666667   .02857143  .004761905   .12380952
"RR" 3018 "BOA VISTA"  1 206 2208 .52881354  .023728814   .07118644 .0033898305    .1661017
"RR" 3018 "BOA VISTA"  1 208 1481 .53090906   .04727273  .036363635           0         .16
"RR" 3018 "BOA VISTA"  1 209 1481  .4703704  .074074075  .037037037           0   .16296296
"RR" 3018 "BOA VISTA"  1 210 1481   .540146   .05474453   .01459854           0   .18978103
"RR" 3018 "BOA VISTA"  1 211 1112  .5945946  .009009009  .036036037 .0045045046  .072072074
"RR" 3018 "BOA VISTA"  1 212 2259   .521327  .018957347   .03791469  .004739337   .19905214
"RR" 3018 "BOA VISTA"  1 214 3301  .5252525   .05555556   .05050505  .005050505   .08080808
"RR" 3018 "BOA VISTA"  1 221 2275  .5302491    .0960854   .02846975  .003558719   .13523132
"RR" 3018 "BOA VISTA"  1 222 2291 .57664233   .09489051   .04379562           0   .17153284
"RR" 3018 "BOA VISTA"  1 223 2305  .4798535   .13186814   .05128205  .003663004   .15018316
"RR" 3018 "BOA VISTA"  1 226 2330 .56845236   .07738096   .05059524  .008928572   .11607143
"RR" 3018 "BOA VISTA"  1 229 3298 .53097343   .13864307   .03834808 .0088495575   .05899705
"RR" 3018 "BOA VISTA"  1 231 2410 .50877196   .11578947  .031578947  .010526316    .1122807
"RR" 3018 "BOA VISTA"  1 233 2402  .6012862   .10932476  .019292604           0   .13826367
"RR" 3018 "BOA VISTA"  1 234 2410  .5197133   .13978495   .03942652  .014336918   .12903225
"RR" 3018 "BOA VISTA"  1 237 2445  .5753846   .05538461  .033846155  .012307692         .12
"RR" 3018 "BOA VISTA"  1 239 1210  .4965754   .10958904   .02739726 .0034246575   .10273973
"RR" 3018 "BOA VISTA"  1 240 3247  .5276382   .02512563   .04522613   .01005025    .1557789
"RR" 3018 "BOA VISTA"  1 241 2291  .5418182   .09818182         .04           0    .1490909
"RR" 3018 "BOA VISTA"  1 242 1732 .53386456   .05976096  .035856575           0   .19521913
"RR" 3018 "BOA VISTA"  1 251 2887  .5265958  .015957447   .03723404           0   .12234043
"RR" 3018 "BOA VISTA"  1 252 3123 .46368715           0   .05586592           0   .11173184
"RR" 3018 "BOA VISTA"  1 259 2330  .5118343   .09171598   .03846154   .00887574   .13017751
"RR" 3018 "BOA VISTA"  1 262 3387 .52287585           0   .07843138  .013071896    .1503268
"RR" 3018 "BOA VISTA"  1 263 1570 .51955307           0    .0726257   .02793296   .08938547
"RR" 3018 "BOA VISTA"  1 266 1830 .53977275       .0625   .04545455           0    .1534091
"RR" 3018 "BOA VISTA"  1 268 2275  .5508772    .1122807   .03508772           0    .1614035
"RR" 3018 "BOA VISTA"  1 276 1163  .5714286   .06644518   .04318937           0   .14285715
"RR" 3018 "BOA VISTA"  1 287 1619 .56281406           0     .040201  .005025126    .1155779
"RR" 3018 "BOA VISTA"  1 288 3123  .5833333           0   .03888889  .005555556   .17222223
"RR" 3018 "BOA VISTA"  1 289 2682  .5448718  .035256412    .0224359  .006410256   .13782051
"RR" 3018 "BOA VISTA"  1 290 2275  .5528169   .11619718   .02464789           0    .1584507
"RR" 3018 "BOA VISTA"  1 295 3247  .5472637    .1641791   .02487562           0   .12935324
"RR" 3018 "BOA VISTA"  1 296 1619 .51724136           0   .07471264  .011494253   .12068965
"RR" 3018 "BOA VISTA"  1 307 2887  .5483871   .04301075   .02688172  .010752688   .12903225
"RR" 3018 "BOA VISTA"  1 309 2330 .54599404    .0949555   .04451039  .014836796   .14243324
"RR" 3018 "BOA VISTA"  1 315 2682 .54285717   .03809524   .04126984  .006349206    .1904762
"RR" 3018 "BOA VISTA"  1 316 2275 .53846157   .12937063  .031468533           0   .16433567
"RR" 3018 "BOA VISTA"  1 317 2305 .52962965   .12222222   .05555556           0   .12222222
"RR" 3018 "BOA VISTA"  1 327 2860 .53257793  .036827195  .036827195           0   .20113315
"RR" 3018 "BOA VISTA"  1 328 1805 .58232933   .04819277   .04819277           0   .12851405
"RR" 3018 "BOA VISTA"  1 333 3786 .54789275   .03448276    .0421456  .007662835    .1532567
"RR" 3018 "BOA VISTA"  1 334 2682  .5506329   .05696202   .03797468           0    .1329114
"RR" 3018 "BOA VISTA"  1 340 1481  .4833948    .0701107  .029520296  .007380074   .16605166
"RR" 3018 "BOA VISTA"  1 341 1627  .5720165  .016460905   .05761317  .004115226    .1687243
"RR" 3018 "BOA VISTA"  1 345 2291 .57761735    .0902527    .0433213           0   .15884477
"RR" 3018 "BOA VISTA"  1 355 2860 .54444444  .016666668   .04444445  .002777778   .15277778
"RR" 3018 "BOA VISTA"  1 357 2887  .5425532   .03723404   .05319149           0   .12765957
"RR" 3018 "BOA VISTA"  1 358 1759  .5065789  .032894738  .013157895  .006578947    .2105263
"RR" 3018 "BOA VISTA"  1 361 1570  .4357542           0   .03910615  .033519555   .10614525
"RR" 3018 "BOA VISTA"  1 362 2780  .5339233  .029498525   .04424779 .0029498525    .1917404
"RR" 3018 "BOA VISTA"  1 363 1112 .55607474   .01401869   .05607476   .01869159   .08411215
"RR" 3018 "BOA VISTA"  1 367 2682  .5580645   .06129032   .03870968 .0032258064    .1580645
"RR" 3018 "BOA VISTA"  1 377 2330 .51343286   .09253731  .035820894  .011940299   .12238806
"RR" 3018 "BOA VISTA"  1 378 2410  .5212766   .10638298  .035460994  .007092198   .12411348
"RR" 3018 "BOA VISTA"  1 379 2208 .55517244    .0862069   .05862069  .013793103   .18965517
"RR" 3018 "BOA VISTA"  1 381 2291  .5345455         .08   .05454545  .003636364   .14181818
"RR" 3018 "BOA VISTA"  1 382 2305 .50549453    .1062271  .032967035           0   .15384616
"RR" 3018 "BOA VISTA"  1 383 1775  .4864865   .14864865   .02702703           0   .13513513
"RR" 3018 "BOA VISTA"  1 389 3786  .5801527  .034351144   .08015267  .007633588    .1259542
"RR" 3018 "BOA VISTA"  1 407 1333  .5281899    .0652819   .03560831           0   .13353115
"RR" 3018 "BOA VISTA"  1 409 1279  .4856322   .05172414   .04022989           0    .1551724
"RR" 3018 "BOA VISTA"  1 410 1210        .5   .06506849   .04452055   .01369863   .11643836
"RR" 3018 "BOA VISTA"  1 416 2305 .53505534   .12177122   .04428044  .003690037    .1512915
"RR" 3018 "BOA VISTA"  1 418 1511  .4741641    .0881459   .05471125  .012158055   .13981763
"RR" 3018 "BOA VISTA"  1 421 1015 .51746035   .00952381   .04444445  .003174603   .13015874
"RR" 3018 "BOA VISTA"  1 429 1171 .55421686  .009036144   .06024097  .003012048   .14457831
"RR" 3018 "BOA VISTA"  1 446 1830       .56   .02285714         .04           0   .21142857
"RR" 3018 "BOA VISTA"  1 458 3050  .5490798   .05214724  .030674847           0    .1779141
"RR" 3018 "BOA VISTA"  1 460 2275  .5122807   .11578947  .028070176           0    .1754386
"RR" 3018 "BOA VISTA"  1 466 2445 .54798764    .0990712    .0247678           0   .15479876
"RR" 3018 "BOA VISTA"  1 467 2305  .5345455    .1090909  .036363635  .003636364   .13454546
"RR" 3018 "BOA VISTA"  1 472 3395  .5424837           0   .07189543           0   .26143792
"RR" 3018 "BOA VISTA"  1 475 1392   .479021  .066433564   .04545455  .006993007   .16083916
"RR" 3018 "BOA VISTA"  1 476 1210  .4532872    .0449827   .05536332  .003460208   .12802768
"RR" 3018 "BOA VISTA"  1 477 1511 .51552796   .05900621   .02173913   .00310559   .13043478
"RR" 3018 "BOA VISTA"  1 478 1570  .5082873           0   .07734807  .016574586   .10497238
"RR" 3018 "BOA VISTA"  1 484 1619  .4427481           0   .09923664  .022900764    .1755725
"RR" 3018 "BOA VISTA"  1 486 1627  .4831933  .004201681   .04621849  .008403362    .2394958
"RR" 3018 "BOA VISTA"  1 487 1279  .5043732  .069970846  .034985423  .005830904     .212828
"RR" 3018 "BOA VISTA"  1 489 2330 .51785713    .0922619   .04166667  .005952381   .13988096
"RR" 3018 "BOA VISTA"  1 496 3123 .51704544  .011363637   .05681818  .011363637   .20454545
"RR" 3018 "BOA VISTA"  1 497 3247  .5477387    .0201005   .04522613  .015075377     .160804
"RR" 3018 "BOA VISTA"  1 502 1716  .5285714   .06190476  .033333335           0    .1952381
"RR" 3018 "BOA VISTA"  1 505 1171 .52710843   .03915663   .06024097  .006024096    .1807229
"RR" 3018 "BOA VISTA"  1 512 3050  .4880952  .026785715  .014880952           0    .1934524
"RR" 3018 "BOA VISTA"  1 513 2780   .488024  .026946107   .05688623  .005988024    .1976048
"RR" 3018 "BOA VISTA"  1 514 1015  .4937107  .015723271   .05345912  .003144654   .18238993
"RR" 3018 "BOA VISTA"  1 517 3220   .523416   .03030303   .03305785           0   .14325069
"RR" 3018 "BOA VISTA"  1 518 2887  .5480769  .003205128  .032051284  .006410256   .12179487
"RR" 3018 "BOA VISTA"  1 519 1511 .53636366   .08787879   .03030303  .006060606   .14848486
"RR" 3018 "BOA VISTA"  1 520 1210  .5118644    .4576271  .016949153 .0033898305   .09830508
"RR" 3018 "BOA VISTA"  1 521 1619  .4102564   .11538462   .05128205  .012820513   .05128205
"RR" 3018 "BOA VISTA"  1 522 1333  .5449102   .06287425    .0508982  .005988024   .18263473
"RR" 3018 "BOA VISTA"  1 523 3247 .56281406   .04522613    .0201005           0    .1959799
"RR" 3018 "BOA VISTA"  1 524 3204 .53977275   .02840909      .03125  .002840909    .1534091
"RR" 3018 "BOA VISTA"  1 525 1279  .5272206   .05730659  .022922637 .0028653296    .2034384
"RR" 3018 "BOA VISTA"  1 528 1511  .5153374    .0981595   .03374233  .009202454     .196319
"RR" 3018 "BOA VISTA"  1 529 1570  .4833333           0   .04444445   .01111111   .13333334
"RR" 3018 "BOA VISTA"  1 531 1279   .481268    .0518732  .034582134           0   .15273775
"RR" 3018 "BOA VISTA"  1 532 3050   .488024  .035928145  .020958085  .005988024   .21856287
"RR" 3018 "BOA VISTA"  1 533 3220 .54415953  .025641026   .02849003           0    .1908832
"RR" 3018 "BOA VISTA"  1 534 1627  .5248869           0   .06334842           0    .1809955
"RR" 3018 "BOA VISTA"  1 535 3220   .504298  .034383953   .05157593 .0028653296    .2922636
"RR" 3018 "BOA VISTA"  1 536 3220  .5252809    .0252809  .033707865           0   .21910113
"RR" 3018 "BOA VISTA"  1 537 2445  .5736196   .06748466   .04601227 .0030674846   .13190185
"RR" 3018 "BOA VISTA"  1 538 1996 .52112675  .004694836  .028169014           0   .16431925
"RR" 3018 "BOA VISTA"  1 540 2860 .59365994  .031700287  .017291067  .005763689   .16426513
"RR" 3018 "BOA VISTA"  1 545 1775  .5479452   .07534247    .0890411  .006849315   .11643836
"RR" 3018 "BOA VISTA"  1 546 3220  .4957265   .01994302   .03133903           0   .22792023
"RR" 3018 "BOA VISTA"  1 547 3344 .55927837   .04896907   .04896907 .0025773195    .1597938
"RR" 3018 "BOA VISTA"  1 548 1511 .46296296   .11111111   .02160494   .01234568   .11111111
"RR" 3018 "BOA VISTA"  1 550 1015 .55910546  .015974442   .09904154  .009584664   .14376996
"RR" 3018 "BOA VISTA"  1 551 2780  .5833333  .035714287    .0922619  .008928572   .11904762
"RR" 3018 "BOA VISTA"  1 552 1511 .52279633   .05471125   .08206687  .009118541   .08206687
"RR" 3018 "BOA VISTA"  1 553 1333  .5341246  .068249255   .07715134  .002967359   .08902077
"RR" 3018 "BOA VISTA"  1 554 3220  .5694444  .008333334   .09166667  .005555556   .09722222
"RR" 3018 "BOA VISTA"  1 555 3344 .53045684   .03045685   .03807107           0   .11675127
"RR" 3018 "BOA VISTA"  1 556 3220  .5734072  .022160664   .05263158           0   .10526316
"RR" 3018 "BOA VISTA"  1 557 3204  .5055249   .03867403   .02486188  .008287293    .1519337
"RR" 3018 "BOA VISTA"  1 558 1171  .5765766   .02702703   .02702703  .003003003    .0930931
"RR" 3018 "BOA VISTA"  1 559 3220 .51319647   .02639296   .04105572           0   .19648094
"RR" 3018 "BOA VISTA"  1 560 3344  .4987212   .05370844   .01534527  .002557545    .1534527
"RR" 3018 "BOA VISTA"  1 563 2860  .5102639   .05571847  .014662757           0   .20821114
"RR" 3018 "BOA VISTA"  1 564 3220        .5   .04624277   .01734104           0   .17919075
"RR" 3018 "BOA VISTA"  1 565 3387  .6461539   .06153846  .015384615  .015384615   .16923077
"RR" 3018 "BOA VISTA"  1 566 3395  .4621212   .16666667  .007575758           0   .14393939
"RR" 3018 "BOA VISTA"  1 567 1627 .51598173    .3287671    .0456621           0   .10045662
"RR" 3018 "BOA VISTA"  1 568 3387  .5208333    .3958333   .04166667           0   .10416666
"RR" 3018 "BOA VISTA"  1 569 3395  .4925373    .2835821  .014925373  .007462686   .12686567
"RR" 3018 "BOA VISTA"  1 570 3387       .46         .36         .02           0          .1
"RR" 3018 "BOA VISTA"  1 571 3409 .55151516           0   .05757576  .012121212    .1030303
"RR" 3018 "BOA VISTA"  1 572 3409  .5548589    .1755486   .05956113  .015673982   .10344828
"RR" 3018 "BOA VISTA"  1 573 3409  .5646688   .02208202   .03154574   .01577287   .10094637
"RR" 3018 "BOA VISTA"  1 574 3409 .58513933           0    .0371517  .009287925   .06501548
"RR" 3018 "BOA VISTA"  1 575 3409 .54746836   .21518987  .015822785  .003164557    .0664557
"RR" 3018 "BOA VISTA"  1 576 3417  .4670659   .04191617    .1017964  .008982036    .0988024
"RR" 3018 "BOA VISTA"  1 577 3417  .5671642   .02686567   .09552239   .02089552   .07462686
"RR" 3018 "BOA VISTA"  1 578 3417  .5074184   .03264095   .09198813  .011869436   .09198813
"RR" 3018 "BOA VISTA"  1 579 3417 .53372437   .02639296   .14369501   .02346041    .0909091
"RR" 3018 "BOA VISTA"  1 580 3417  .5617647   .03529412   .04411765   .00882353   .13235295
"RR" 3018 "BOA VISTA"  1 581 3417  .5147929   .03846154   .04733728   .00295858    .1035503
"RR" 3018 "BOA VISTA"  1 582 3417   .505988  .020958085   .04191617  .005988024   .13772455
"RR" 3018 "BOA VISTA"  1 583 3417  .4732143  .011904762  .065476194  .008928572   .14880952
"RR" 3018 "BOA VISTA"  1 584 3417   .539823  .029498525   .04424779  .005899705   .12094396
"RR" 3018 "BOA VISTA"  1 585 3425 .53333336   .06060606   .04545455  .003030303   .13333334
"RR" 3018 "BOA VISTA"  1 586 3425  .4985251   .03539823   .02064897 .0029498525   .09439528
"RR" 3018 "BOA VISTA"  1 587 3425  .5205882    .0764706   .04117647 .0029411765   .10294118
"RR" 3018 "BOA VISTA"  1 588 3425 .47928995   .05029586   .02366864   .00295858    .1331361
"RR" 3018 "BOA VISTA"  1 589 3425  .4567164   .05074627   .04179104  .011940299    .1074627
"RR" 3018 "BOA VISTA"  1 590 3425  .4626866   .07164179   .04477612  .011940299   .10447761
"RR" 3018 "BOA VISTA"  1 591 3433 .51363635   .07272727   .06818182   .02727273   .10454545
"RR" 3018 "BOA VISTA"  1 592 3433  .4657534   .05479452   .07305936   .01369863   .07305936
"RR" 3018 "BOA VISTA"  1 593 3433  .5391705   .05069124  .032258064   .00921659    .0921659
"RR" 3018 "BOA VISTA"  1 594 3433  .5229358   .06880734   .03211009 .0091743115   .13761468
"RR" 3018 "BOA VISTA"  1 595 3441 .55760366   .06451613    .0875576   .00921659    .0967742
"RR" 3018 "BOA VISTA"  1 596 3441  .5860465   .06046512   .12093023  .027906977  .074418604
"RR" 3018 "BOA VISTA"  1 597 3441  .6036866  .032258064    .0875576   .02764977    .0967742
"RR" 3018 "BOA VISTA"  1 598 3441  .5876777   .03791469   .02843602           0   .07582939
"RR" 3018 "BOA VISTA"  1 599 3441   .587963  .037037037   .08333334  .009259259    .0925926
"RR" 3018 "BOA VISTA"  1 600 3441  .6064815   .06018519   .05092593   .01388889   .13425925
"RR" 3018 "BOA VISTA"  1 601 3450  .5130719   .04248366    .0882353   .02287582    .0751634
"RR" 3018 "BOA VISTA"  1 602 3450  .4884489   .02970297    .1980198   .01980198   .06930693
"RR" 3018 "BOA VISTA"  1 603 3450  .5606557   .02295082   .07868852   .01967213   .07213115
"RR" 3018 "BOA VISTA"  1 604 3450 .52922076  .016233766   .08116883  .025974026   .07792208
"RR" 3018 "BOA VISTA"  1 605 3450  .4660194   .05501618   .04854369  .006472492  .067961164
"RR" 3018 "BOA VISTA"  1 606 3450  .4933333         .02   .04666667         .02   .09666666
"RR" 3018 "BOA VISTA"  1 607 3450  .4684385  .029900333   .03322259  .013289036   .08305648
"RR" 3018 "BOA VISTA"  1 608 3450 .55445546    .0330033   .06270627   .02310231   .11221122
"RR" 3018 "BOA VISTA"  1 610 3450 .45945945  .037162162   .04054054  .016891891    .0777027
"RR" 3018 "BOA VISTA"  1 611 3468 .52117264   .04885994  .013029316  .009771987   .13029316
"RR" 3018 "BOA VISTA"  1 612 3468  .5537459   .05211726  .016286645  .013029316    .1009772
"RR" 3018 "BOA VISTA"  1 613 3468 .52063495   .06984127   .08253969  .003174603    .1015873
"RR" 3018 "BOA VISTA"  1 614 3468  .5127388  .035031848   .03821656  .006369427    .0923567
"RR" 3018 "BOA VISTA"  1 615 3468 .45602605   .10749186  .006514658  .009771987   .06514658
"RR" 3018 "BOA VISTA"  1 616 3654  .5205479           0   .04109589   .03082192   .06506849
"RR" 3018 "BOA VISTA"  1 617 3654  .5344828           0   .04482759  .010344828          .1
"RR" 3018 "BOA VISTA"  1 618 3654 .52068967           0   .03103448  .003448276   .09655172
"RR" 3018 "BOA VISTA"  1 619 3654  .5212766           0   .09574468           0   .14893617
"RR" 3018 "BOA VISTA"  1 620 3654  .6028881           0   .09747292  .014440433   .07942238
"RR" 3018 "BOA VISTA"  1 621 3484      .544        .072        .024        .008        .104
"RR" 3018 "BOA VISTA"  1 622 3484  .5612648   .06719368   .03557312 .0039525693   .10671937
"RR" 3018 "BOA VISTA"  1 623 3492  .4981949    .0866426   .05054152  .007220217   .05776173
"RR" 3018 "BOA VISTA"  1 624 3492  .5147059  .073529415  .022058824  .011029412   .09558824
"RR" 3018 "BOA VISTA"  1 625 3492  .5441176   .09191176  .022058824 .0036764706   .11764706
"RR" 3018 "BOA VISTA"  1 626 3492  .5257353   .08088236  .007352941           0   .12132353
"RR" 3018 "BOA VISTA"  1 627 3492  .4925373   .04477612   .04477612  .003731343   .14179105
"RR" 3018 "BOA VISTA"  1 628 3492 .53731346   .09701493  .026119404  .007462686   .10447761
"RR" 3018 "BOA VISTA"  1 629 3492   .501845   .05904059  .029520296  .003690037   .12546125
"RR" 3018 "BOA VISTA"  1 630 3492  .5162455   .07581227  .007220217  .003610108    .1299639
"RR" 3018 "BOA VISTA"  1 631 3506  .5497076   .04093567  .029239766   .00877193   .13450292
"RR" 3018 "BOA VISTA"  1 632 3506  .5603448   .04885057   .08333334  .011494253    .0775862
"RR" 3018 "BOA VISTA"  1 633 3506 .57309943  .011695907   .06725146   .01754386   .11403508
"RR" 3018 "BOA VISTA"  1 634 3506  .5726744   .02906977    .0377907  .005813953   .09011628
"RR" 3018 "BOA VISTA"  1 635 3506  .4969325  .018404908    .0398773  .009202454   .12269939
"RR" 3018 "BOA VISTA"  1 636 3506  .5588235  .011764706   .03529412           0   .10882353
"RR" 3018 "BOA VISTA"  1 637 3506 .54985756   .02849003   .04273504  .008547009   .14245014
"RR" 3018 "BOA VISTA"  1 638 3506  .4505814   .04069768   .04360465  .005813953        .125
"RR" 3018 "BOA VISTA"  1 639 3514  .5427729   .02064897   .01179941  .014749262   .07669616
"RR" 3018 "BOA VISTA"  1 640 3514  .4810496   .02623907  .034985423  .005830904    .1341108
"RR" 3018 "BOA VISTA"  1 641 3514  .4985075  .032835823  .011940299  .014925373   .10149254
"RR" 3018 "BOA VISTA"  1 642 3514  .5276968  .020408163   .02623907  .005830904   .11078718
"RR" 3018 "BOA VISTA"  1 643 3514  .4911243   .03846154   .03846154    .0147929   .16863905
end

[Clyde Schechter]

Saying that you tried many things and none of them worked, but not showing what you tried, nor in what way they "did not work" is not very helpful. There are dozens of things you might have tried, each of which could have failed in many ways.

From inspection of your example data, it seems you can combine these with

use voter_profile_data, clear
merge 1:m m cd_municipio nm_municipio nr_zona nr_secao using vote_shares_data

(In fact, the example data could be merged using -merge 1:1- with the same link variables. But I suspect that is just a result of the particular selection of observations presented.)

I would recommend doing a merge like this in each of the 27 states separately, and save the results in a file named after the state. Then I would -append- all of those state files together.

As for the problem of having no observations for candidates receiving zero votes, it isn't clear whether every candidate is on the ballot in every state, or if a "missing" candidate need only be filled in within a municipality within which he or she ran, or maybe even some smaller area. In any case, you will need to create a variable (-help egen, group()- if not familiar) that indicates the level of aggregation at which each candidate should appear at least once. Then use -fillin- (-help fillin- if not familiar) to expand the data set to create "blank" observations for each "missing" candidate. Then you can use -replace- to change the missing values of vote count to zero in the observations that -fillin- created.

[Bruno Hoepers]

Thank you very much Clyde for your response. You’re absolutely right: I should’ve been more specific concerning the solutions I tried to implement.

Regarding whether every candidate is on the ballot in every state, the answer is this: In Brazil there is a proportional representation system in which each state is the main district. Candidates running for state deputy and federal deputy run in the whole state - they are on the ballot in the whole state - and each state elects a certain number of deputies (in political science parlance this is called "district magnitude"). Voters from the state have one vote for state deputy and one vote for federal deputy. Candidates for both offices have varied voting patterns across precincts: some have their votes concentrated in a few precincts, whereas other candidates have votes spread out across precincts. A candidate can get zero votes in several precincts. This is very common.

For my dataset, each candidate should appear at least once in every precinct / locality (nm_local_votacao), even if he or she gets zero votes in a precinct. Thus, the "missing" candidate can be filled in.


What I tried to do was this:

First, for one Brazilian state (Roraima - RR), I found how many candidates ran in the state in 2022 and the number of precincts’ locations in the state:

egen uniqueid = group(nm_local_votacao) // 317 localities

gen id = 0
bysort nr_candidato : replace id = 1 if _n == 1 // 543 candidates

Second, based on the dataset with the 317 precincts, I created a dataset with all the precincts’ locations for each candidate by using the command “expand 543” (172,131 observations)

Third, I tried to merge the data from the “vote share totals dataset” to the previous dataset obtained through “expand”. I created the following identifiers:

bysort nm_local_votacao : gen cand_id = (_n)
egen id_unique = group(cd_municipio nr_zona nr_secao nr_local_votacao nm_local_votacao cand_id)

I’m not sure I’m on the right track here.


Your suggestion of -fillin- with -replace- seems to offer a simpler solution. I'm not familiar with -fillin-, but I will peruse the documents and posts on it.

I'm sorry for the lengthy reply.

[Clyde Schechter]

It looks like your overall approach, in simple terms, was to first build a data set containing one observation for each combination of precinct and candidate, and then merge all of the data into that. That overall approach should work. I think your implementation was somehow flawed, though I'm entirely sure why. But here's a simpler way to do that that avoids certain pitfalls of the approach you used. You may find this simpler than using -fillin-, or not.

use vote_share_data, clear

preserve
keep nm_local_votacao
duplicates drop
tempfile precincts
save `precincts'

restore
keep nr_candidato
duplicates drop
cross using `precincts'

Note: I'm assuming here that nm_local_votacao indicates precincts.

[Bruno Hoepers]

Thank you very much, Clyde. Yes, I tried to do exactly what you wrote and my implementation was a failure. I will try -fillin- and the code above and check which of the two will make the merging process more straightforward and reliable.