dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | acteur_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
| 8 | mandat_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|
| 16060000118706 | L16/dossiers | 16 | 16060000118705 | 16060000118705 | 1 | PA342384 | PM796656 |
| 16060000118724 | L16/dossiers | 16 | 16060000118723 | 16060000118723 | 1 | PA721960 | PM797811 |
| 16060000118731 | L16/dossiers | 16 | 16060000118730 | 16060000118730 | 1 | PA267241 | PM778080 |
| 16060000118738 | L16/dossiers | 16 | 16060000118737 | 16060000118737 | 1 | PA702992 | PM717139 |
| 16060000118739 | L16/dossiers | 16 | 16060000118737 | 16060000118737 | 2 | PA773443 | PM791682 |
| 16060000118779 | L16/dossiers | 16 | 16060000118778 | 16060000118778 | 1 | PA717161 | PM791583 |
| 16060000118780 | L16/dossiers | 16 | 16060000118778 | 16060000118778 | 2 | PA793788 | PM806329 |
| 16060000118781 | L16/dossiers | 16 | 16060000118778 | 16060000118778 | 3 | PA774109 | PM801956 |
| 16060000118841 | L16/dossiers | 16 | 16060000118840 | 16060000118840 | 1 | PA721474 | PM797511 |
| 16060000118848 | L16/dossiers | 16 | 16060000118847 | 16060000118847 | 1 | PA303997 | PM775743 |
| 16060000118875 | L16/dossiers | 16 | 16060000118874 | 16060000118874 | 1 | PA605991 | PM796428 |
| 16060000118883 | L16/dossiers | 16 | 16060000118882 | 16060000118882 | 1 | PA717161 | PM791583 |
| 16060000118891 | L16/dossiers | 16 | 16060000118890 | 16060000118890 | 1 | PA703540 | PM775723 |
| 16060000118913 | L16/dossiers | 16 | 16060000118912 | 16060000118912 | 1 | PA793122 | PM796161 |
| 16060000118948 | L16/dossiers | 16 | 16060000118947 | 16060000118947 | 1 | PA720614 | PM797055 |
| 16060000118955 | L16/dossiers | 16 | 16060000118954 | 16060000118954 | 1 | PA775276 | PM775566 |
| 16060000118974 | L16/dossiers | 16 | 16060000118973 | 16060000118973 | 1 | PA721442 | PM797253 |
| 16060000118978 | L16/dossiers | 16 | 16060000118977 | 16060000118977 | 1 | PA793342 | PM796269 |
| 16060000118982 | L16/dossiers | 16 | 16060000118981 | 16060000118981 | 1 | PA717161 | PM791583 |
| 16060000118989 | L16/dossiers | 16 | 16060000118988 | 16060000118988 | 1 | PA795808 | PM797694 |
| 16060000118993 | L16/dossiers | 16 | 16060000118992 | 16060000118992 | 1 | PA717161 | PM791583 |
| 16060000119003 | L16/dossiers | 16 | 16060000119002 | 16060000119002 | 1 | PA795636 | PM797601 |
| 16060000119010 | L16/dossiers | 16 | 16060000119009 | 16060000119009 | 1 | PA721474 | PM797511 |
| 16060000119017 | L16/dossiers | 16 | 16060000119016 | 16060000119016 | 1 | PA775192 | PM775478 |
| 16060000119024 | L16/dossiers | 16 | 16060000119023 | 16060000119023 | 1 | PA717161 | PM791583 |
| 16060000119087 | L16/dossiers | 16 | 16060000119086 | 16060000119086 | 1 | PA717161 | PM791583 |
| 16060000119171 | L16/dossiers | 16 | 16060000119170 | 16060000119170 | 1 | PA791812 | PM797280 |
| 16060000119178 | L16/dossiers | 16 | 16060000119177 | 16060000119177 | 1 | PA794106 | PM796716 |
| 16060000119185 | L16/dossiers | 16 | 16060000119184 | 16060000119184 | 1 | PA794008 | PM796653 |
| 16060000119193 | L16/dossiers | 16 | 16060000119192 | 16060000119192 | 1 | PA795596 | PM797580 |
| 16060000119200 | L16/dossiers | 16 | 16060000119199 | 16060000119199 | 1 | PA795136 | PM797319 |
| 16060000119207 | L16/dossiers | 16 | 16060000119206 | 16060000119206 | 1 | PA793736 | PM796503 |
| 16060000119214 | L16/dossiers | 16 | 16060000119213 | 16060000119213 | 1 | PA719968 | PM832556 |
| 16060000119221 | L16/dossiers | 16 | 16060000119220 | 16060000119220 | 1 | PA605991 | PM796428 |
| 16060000119228 | L16/dossiers | 16 | 16060000119227 | 16060000119227 | 1 | PA718884 | PM796218 |
| 16060000119235 | L16/dossiers | 16 | 16060000119234 | 16060000119234 | 1 | PA721474 | PM797511 |
| 16060000119242 | L16/dossiers | 16 | 16060000119241 | 16060000119241 | 1 | PA721474 | PM797511 |
| 16060000119249 | L16/dossiers | 16 | 16060000119248 | 16060000119248 | 1 | PA721584 | PM797712 |
| 16060000119274 | L16/dossiers | 16 | 16060000119273 | 16060000119273 | 1 | PA793290 | PM796248 |
| 16060000119281 | L16/dossiers | 16 | 16060000119280 | 16060000119280 | 1 | PA794198 | PM796776 |
| 16060000119288 | L16/dossiers | 16 | 16060000119287 | 16060000119287 | 1 | PA793342 | PM796269 |
| 16060000119295 | L16/dossiers | 16 | 16060000119294 | 16060000119294 | 1 | PA793756 | PM796512 |
| 16060000119302 | L16/dossiers | 16 | 16060000119301 | 16060000119301 | 1 | PA335999 | PM797655 |
| 16060000119309 | L16/dossiers | 16 | 16060000119308 | 16060000119308 | 1 | PA643089 | PM797439 |
| 16060000119316 | L16/dossiers | 16 | 16060000119315 | 16060000119315 | 1 | PA642988 | PM797862 |
| 16060000119323 | L16/dossiers | 16 | 16060000119322 | 16060000119322 | 1 | PA340643 | PM796335 |
| 16060000119330 | L16/dossiers | 16 | 16060000119329 | 16060000119329 | 1 | PA736200 | PM829845 |
| 16060000119337 | L16/dossiers | 16 | 16060000119336 | 16060000119336 | 1 | PA736174 | PM829797 |
| 16060000119344 | L16/dossiers | 16 | 16060000119343 | 16060000119343 | 1 | PA793948 | PM796617 |
| 16060000119351 | L16/dossiers | 16 | 16060000119350 | 16060000119350 | 1 | PA795820 | PM797700 |