BRÉF - Base Révisée des Élu·es de France

<p>The BR&Eacute;F (<em>Base R&eacute;vis&eacute;e des &Eacute;lu&middot;es de France</em> / Revised database of representatives elected in France) is a database aiming at describing the mandates of all public representatives elected in France during the Fifth Republic (1958--present). It is based on the combination of data coming from of 4 sources:</p> <ul> <li>Primary source: <strong>RNE </strong>(<em>Registre National des Elus</em> / National register of elected representatives), a database maintained by the French Ministry of Interior when monitoring elections.</li> <li>Secondary sources: <ul> <li><strong>National Assembly: </strong>open database provided by the French National Assembly regarding the mandates of Members of the Parliament.</li> <li><strong>Senate: </strong>open database provided by the French Senate, regarding senatorial mandates.</li> <li><strong>European Parliament: </strong>official website of the European Parliament, which lists the mandates of Members of the European Parliament.</li> </ul> </li> </ul> <p>The original data contain many errors and issues, which are documented in our technical report (in French), as well as the operations that we conducted to correct or alleviate them, as described in technical report [1]. The database was used during the PhD of No&eacute;mie F&eacute;vrat [2].</p> <ol> <li>V. Labatut, N. F&eacute;vrat &amp; G. Marrel,&nbsp;<em>BR&Eacute;F &ndash; Base de donn&eacute;es R&eacute;vis&eacute;e des &Eacute;lu&middot;es de France</em>, Technical Report, Avignon Universit&eacute;, 2020.&nbsp;<a href="https://hal.archives-ouvertes.fr/hal-02886580" rel="nofollow">⟨hal-02886580⟩</a></li> <li>F&eacute;vrat, N. Le mandat de trop ? La r&eacute;&eacute;lection des parlementaires et des maires en France et les conditions de sa remise en cause, PhD Thesis, <em>Avignon Universit&eacute;, </em>2024.&nbsp;<a href="https://hal.archives-ouvertes.fr/tel-04550896">⟨tel-04550896⟩</a></li> </ol> <p><strong>Source code. </strong>The source code that implements these operations is freely available on GitHub, as a collection of&nbsp;<code>R</code> scripts gathered in the <code><a href="https://github.com/CompNet/BrefInit">BrefInit</a></code> repository. The first version of the database takes the form of a single, large CSV table. The second version of the BR&Eacute;F is a proper relational database obtained with the scripts available in the <code><a href="https://github.com/BrefAvignon/BrefConversion">BrefConversion</a></code> repository. Its tables and fields are described in the&nbsp;<code>readme.txt</code> file.</p> <p><strong>Database. </strong>The database is available under three forms:</p> <ul> <li>PostgreSQL binary dump: file <code>bref_20250115_v2.2.1.backup</code></li> <li>SQL plain dump: file <code>bref_20250115_v2.2.1_sql.zip</code></li> <li>Individual CSV files (one by table): <code>bref_20250115_v2.2.1_sql.zip</code></li> </ul> <p><strong>Citation.</strong> If you use these data or the related source code, please cite reference [1]:</p> <p><code>@TechReport{Labatut2020,</code><br><code>&nbsp; author &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = {Labatut, Vincent and F&eacute;vrat, No&eacute;mie and Marrel, Guillaume},</code><br><code>&nbsp; title &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= {{BR&Eacute;F} -- {B}ase de donn&eacute;es {R}&eacute;vis&eacute;e des {&Eacute;}lu&middot;es de {F}rance (BR&Eacute;F -- Revised Database of the Representatives Elected in {F}rance)},</code><br><code>&nbsp; institution &nbsp; &nbsp; &nbsp;= {Avignon Universit&eacute;},</code><br><code>&nbsp; year &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = {2020},</code><br><code>&nbsp; type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = {Technical Report},</code><br><code>&nbsp; address &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;= {Avignon, FR},</code><br><code>}</code></p> <p><strong>Funding.&nbsp;</strong>This work was supported by the research federation Agorantic (FR 3621), through the funding of No&eacute;mie Fevrat&rsquo;s PhD. and of interdisciplinary research project BR&Eacute;F2.</p> <p>&nbsp;</p>