dossiers.dossier_parlementaire_acte_legislatif_acteur
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 %
460 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 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | acteur_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur.acteurRef · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 % |
| 10 | mandat_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.initiateur.acteurs.acteur.mandatRef · présence : L17 2 %, L16 3 %, L15 3 %, L14 5 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|---|---|
| 15060000131554 | L15/dossiers | 15 | 15060000131501 | 15060000131553 | 1 | 1 | PA345619 | PM725692 | |
| 15060000132094 | L15/dossiers | 15 | 15060000132048 | 15060000132093 | 1 | 1 | PA345619 | PM725692 | |
| 15060000132199 | L15/dossiers | 15 | 15060000132150 | 15060000132198 | 1 | 1 | PA345619 | PM725692 | |
| 15060000132602 | L15/dossiers | 15 | 15060000132533 | 15060000132601 | 1 | 1 | PA345619 | PM725692 | |
| 15060000132848 | L15/dossiers | 15 | 15060000132814 | 15060000132847 | 1 | 1 | PA345619 | PM725692 | |
| 15060000133473 | L15/dossiers | 15 | 15060000133440 | 15060000133472 | 1 | 1 | PA345619 | PM725692 | |
| 15060000133683 | L15/dossiers | 15 | 15060000133649 | 15060000133682 | 1 | 1 | PA345619 | PM725692 | |
| 15060000133856 | L15/dossiers | 15 | 15060000133789 | 15060000133855 | 1 | 1 | PA345619 | PM725692 | |
| 15060000133919 | L15/dossiers | 15 | 15060000133875 | 15060000133918 | 1 | 1 | PA345619 | PM725692 | |
| 15060000134093 | L15/dossiers | 15 | 15060000134038 | 15060000134092 | 1 | 1 | PA345619 | PM725692 | |
| 15060000134219 | L15/dossiers | 15 | 15060000134184 | 15060000134218 | 1 | 1 | PA345619 | PM725692 | |
| 15060000134297 | L15/dossiers | 15 | 15060000134242 | 15060000134296 | 1 | 1 | PA345619 | PM725692 | |
| 15060000134788 | L15/dossiers | 15 | 15060000134740 | 15060000134787 | 1 | 1 | PA345619 | PM725692 | |
| 15060000135157 | L15/dossiers | 15 | 15060000135125 | 15060000135156 | 1 | 1 | PA345619 | PM725692 | |
| 15060000135266 | L15/dossiers | 15 | 15060000135225 | 15060000135265 | 1 | 1 | PA345619 | PM725692 | |
| 15060000136110 | L15/dossiers | 15 | 15060000136023 | 15060000136109 | 1 | 1 | PA345619 | PM725692 | |
| 15060000136464 | L15/dossiers | 15 | 15060000136388 | 15060000136463 | 1 | 1 | PA345619 | PM725692 | |
| 15060000136743 | L15/dossiers | 15 | 15060000136698 | 15060000136742 | 1 | 1 | PA345619 | PM725692 | |
| 15060000137026 | L15/dossiers | 15 | 15060000136945 | 15060000137025 | 1 | 1 | PA345619 | PM725692 | |
| 15060000137221 | L15/dossiers | 15 | 15060000137188 | 15060000137220 | 1 | 1 | PA345619 | PM725692 | |
| 15060000137520 | L15/dossiers | 15 | 15060000137464 | 15060000137519 | 1 | 1 | PA345619 | PM725692 | |
| 15060000137629 | L15/dossiers | 15 | 15060000137592 | 15060000137628 | 1 | 1 | PA345619 | PM725692 | |
| 15060000137868 | L15/dossiers | 15 | 15060000137820 | 15060000137867 | 1 | 1 | PA345619 | PM725692 | |
| 15060000138006 | L15/dossiers | 15 | 15060000137964 | 15060000138005 | 1 | 1 | PA345619 | PM725692 | |
| 15060000138327 | L15/dossiers | 15 | 15060000138294 | 15060000138326 | 1 | 1 | PA345619 | PM725692 | |
| 15060000138400 | L15/dossiers | 15 | 15060000138346 | 15060000138399 | 1 | 1 | PA345619 | PM725692 | |
| 15060000138658 | L15/dossiers | 15 | 15060000138542 | 15060000138657 | 1 | 1 | PA345619 | PM725692 | |
| 15060000139170 | L15/dossiers | 15 | 15060000139082 | 15060000139169 | 1 | 1 | PA345619 | PM725692 | |
| 15060000139481 | L15/dossiers | 15 | 15060000139446 | 15060000139480 | 1 | 1 | PA345619 | PM725692 | |
| 15060000139609 | L15/dossiers | 15 | 15060000139540 | 15060000139608 | 1 | 1 | PA345619 | PM725692 | |
| 15060000139739 | L15/dossiers | 15 | 15060000139670 | 15060000139738 | 1 | 1 | PA345619 | PM725692 | |
| 15060000140814 | L15/dossiers | 15 | 15060000140732 | 15060000140813 | 1 | 1 | PA345619 | PM725692 | |
| 15060000141194 | L15/dossiers | 15 | 15060000140896 | 15060000141193 | 1 | 1 | PA345619 | PM725692 | |
| 15060000142701 | L15/dossiers | 15 | 15060000142644 | 15060000142700 | 1 | 1 | PA345619 | PM725692 | |
| 15060000142889 | L15/dossiers | 15 | 15060000142817 | 15060000142888 | 1 | 1 | PA345619 | PM725692 | |
| 15060000143115 | L15/dossiers | 15 | 15060000143081 | 15060000143114 | 1 | 1 | PA345619 | PM725692 | |
| 15060000143293 | L15/dossiers | 15 | 15060000143240 | 15060000143292 | 1 | 1 | PA345619 | PM725692 | |
| 15060000143671 | L15/dossiers | 15 | 15060000143627 | 15060000143670 | 1 | 1 | PA345619 | PM725692 | |
| 15060000144167 | L15/dossiers | 15 | 15060000144132 | 15060000144166 | 1 | 1 | PA345619 | PM725692 | |
| 15060000144457 | L15/dossiers | 15 | 15060000144408 | 15060000144456 | 1 | 1 | PA345619 | PM725692 | |
| 15060000144527 | L15/dossiers | 15 | 15060000144479 | 15060000144526 | 1 | 1 | PA345619 | PM725692 | |
| 15060000144912 | L15/dossiers | 15 | 15060000144810 | 15060000144911 | 1 | 1 | PA345619 | PM725692 | |
| 15060000145212 | L15/dossiers | 15 | 15060000145154 | 15060000145211 | 1 | 1 | PA345619 | PM725692 | |
| 15060000145393 | L15/dossiers | 15 | 15060000145355 | 15060000145392 | 1 | 1 | PA345619 | PM725692 | |
| 15060000145455 | L15/dossiers | 15 | 15060000145415 | 15060000145454 | 1 | 1 | PA345619 | PM725692 | |
| 15060000146775 | L15/dossiers | 15 | 15060000146740 | 15060000146774 | 1 | 1 | PA345619 | PM725692 | |
| 15060000147150 | L15/dossiers | 15 | 15060000147071 | 15060000147149 | 1 | 1 | PA345619 | PM725692 | |
| 15060000147413 | L15/dossiers | 15 | 15060000147371 | 15060000147412 | 1 | 1 | PA345619 | PM725692 | |
| 15060000147688 | L15/dossiers | 15 | 15060000147643 | 15060000147687 | 1 | 1 | PA345619 | PM725692 | |
| 15060000147916 | L15/dossiers | 15 | 15060000147864 | 15060000147915 | 1 | 1 | PA345619 | PM725692 |