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 |
|---|---|---|---|---|---|---|---|---|---|
| 15060000184949 | L15/dossiers | 15 | 15060000184918 | 15060000184948 | 1 | 1 | PA773441 | PM773491 | |
| 15060000185026 | L15/dossiers | 15 | 15060000184993 | 15060000185025 | 1 | 1 | PA773441 | PM773491 | |
| 15060000185169 | L15/dossiers | 15 | 15060000185127 | 15060000185168 | 1 | 1 | PA773441 | PM773491 | |
| 14060000090584 | L14/dossiers | 14 | 14060000090542 | 14060000090583 | 1 | 1 | PA267622 | PM702957 | |
| 14060000091096 | L14/dossiers | 14 | 14060000090723 | 14060000091095 | 1 | 1 | PA267622 | PM702957 | |
| 14060000091683 | L14/dossiers | 14 | 14060000091615 | 14060000091682 | 1 | 1 | PA328 | PM653228 | |
| 14060000091802 | L14/dossiers | 14 | 14060000091735 | 14060000091801 | 1 | 1 | PA267622 | PM702957 | |
| 14060000092101 | L14/dossiers | 14 | 14060000092068 | 14060000092100 | 1 | 1 | PA328 | PM653228 | |
| 14060000092270 | L14/dossiers | 14 | 14060000092160 | 14060000092269 | 1 | 1 | PA267622 | PM702957 | |
| 14060000092485 | L14/dossiers | 14 | 14060000092362 | 14060000092484 | 1 | 1 | PA328 | PM653228 | |
| 14060000092808 | L14/dossiers | 14 | 14060000092774 | 14060000092807 | 1 | 1 | PA267622 | PM700712 | |
| 14060000092932 | L14/dossiers | 14 | 14060000092857 | 14060000092931 | 1 | 1 | PA328 | PM653228 | |
| 14060000093765 | L14/dossiers | 14 | 14060000093721 | 14060000093764 | 1 | 1 | PA267622 | PM702957 | |
| 14060000093850 | L14/dossiers | 14 | 14060000093807 | 14060000093849 | 1 | 1 | PA785 | PM715797 | |
| 14060000094350 | L14/dossiers | 14 | 14060000094310 | 14060000094349 | 1 | 1 | PA328 | PM653228 | |
| 14060000094518 | L14/dossiers | 14 | 14060000094485 | 14060000094517 | 1 | 1 | PA328 | PM653228 | |
| 14060000094637 | L14/dossiers | 14 | 14060000094555 | 14060000094636 | 1 | 1 | PA267622 | PM702957 | |
| 14060000094732 | L14/dossiers | 14 | 14060000094689 | 14060000094731 | 1 | 1 | PA785 | PM715797 | |
| 14060000095068 | L14/dossiers | 14 | 14060000095010 | 14060000095067 | 1 | 1 | PA267622 | PM700712 | |
| 14060000095747 | L14/dossiers | 14 | 14060000095706 | 14060000095746 | 1 | 1 | PA267622 | PM702957 | |
| 14060000095926 | L14/dossiers | 14 | 14060000095889 | 14060000095925 | 1 | 1 | PA267622 | PM702957 | |
| 14060000096353 | L14/dossiers | 14 | 14060000096000 | 14060000096352 | 1 | 1 | PA267622 | PM702957 | |
| 14060000097202 | L14/dossiers | 14 | 14060000097157 | 14060000097201 | 1 | 1 | PA328 | PM653228 | |
| 14060000097598 | L14/dossiers | 14 | 14060000097487 | 14060000097597 | 1 | 1 | PA328 | PM653228 | |
| 14060000097759 | L14/dossiers | 14 | 14060000097719 | 14060000097758 | 1 | 1 | PA328 | PM653228 | |
| 14060000098023 | L14/dossiers | 14 | 14060000097969 | 14060000098022 | 1 | 1 | PA328 | PM653228 | |
| 14060000098175 | L14/dossiers | 14 | 14060000098102 | 14060000098174 | 1 | 1 | PA267622 | PM702957 | |
| 14060000099056 | L14/dossiers | 14 | 14060000098680 | 14060000099055 | 1 | 1 | PA267622 | PM702957 | |
| 14060000100071 | L14/dossiers | 14 | 14060000099774 | 14060000100070 | 1 | 1 | PA328 | PM653228 | |
| 14060000101310 | L14/dossiers | 14 | 14060000101267 | 14060000101309 | 1 | 1 | PA785 | PM715797 | |
| 14060000101474 | L14/dossiers | 14 | 14060000101442 | 14060000101473 | 1 | 1 | PA785 | PM715797 | |
| 14060000101552 | L14/dossiers | 14 | 14060000101495 | 14060000101551 | 1 | 1 | PA328 | PM653228 | |
| 14060000101656 | L14/dossiers | 14 | 14060000101624 | 14060000101655 | 1 | 1 | PA267622 | PM702957 | |
| 14060000101952 | L14/dossiers | 14 | 14060000101912 | 14060000101951 | 1 | 1 | PA267622 | PM702957 | |
| 14060000102193 | L14/dossiers | 14 | 14060000102158 | 14060000102192 | 1 | 1 | PA267622 | PM702957 | |
| 14060000102526 | L14/dossiers | 14 | 14060000102491 | 14060000102525 | 1 | 1 | PA267622 | PM702957 | |
| 14060000102626 | L14/dossiers | 14 | 14060000102567 | 14060000102625 | 1 | 1 | PA267622 | PM702957 | |
| 14060000102729 | L14/dossiers | 14 | 14060000102662 | 14060000102728 | 1 | 1 | PA267622 | PM702957 | |
| 14060000102823 | L14/dossiers | 14 | 14060000102786 | 14060000102822 | 1 | 1 | PA267622 | PM702957 | |
| 14060000103085 | L14/dossiers | 14 | 14060000103040 | 14060000103084 | 1 | 1 | PA267622 | PM700712 | |
| 14060000103419 | L14/dossiers | 14 | 14060000103358 | 14060000103418 | 1 | 1 | PA267622 | PM702957 | |
| 14060000103627 | L14/dossiers | 14 | 14060000103463 | 14060000103626 | 1 | 1 | PA267622 | PM702957 | |
| 14060000103926 | L14/dossiers | 14 | 14060000103850 | 14060000103925 | 1 | 1 | PA267622 | PM702957 | |
| 14060000104207 | L14/dossiers | 14 | 14060000104131 | 14060000104206 | 1 | 1 | PA328 | PM653228 | |
| 14060000104537 | L14/dossiers | 14 | 14060000104488 | 14060000104536 | 1 | 1 | PA267622 | PM702957 | |
| 14060000104800 | L14/dossiers | 14 | 14060000104764 | 14060000104799 | 1 | 1 | PA267622 | PM702957 | |
| 14060000104914 | L14/dossiers | 14 | 14060000104881 | 14060000104913 | 1 | 1 | PA345619 | PM725692 | |
| 14060000105018 | L14/dossiers | 14 | 14060000104985 | 14060000105017 | 1 | 1 | PA328 | PM653228 | |
| 14060000105290 | L14/dossiers | 14 | 14060000105217 | 14060000105289 | 1 | 1 | PA267622 | PM702957 | |
| 14060000106157 | L14/dossiers | 14 | 14060000106119 | 14060000106156 | 1 | 1 | PA267622 | PM702957 |