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 |
|---|---|---|---|---|---|---|---|---|---|
| 17060000115425 | L17/dossiers | 17 | 17060000115383 | 17060000115424 | 1 | 1 | PA773441 | PM773491 | |
| 17060000115491 | L17/dossiers | 17 | 17060000115448 | 17060000115490 | 1 | 1 | PA773441 | PM773491 | |
| 17060000116487 | L17/dossiers | 17 | 17060000116348 | 17060000116486 | 1 | 1 | PA643210 | PM873637 | |
| 17060000116734 | L17/dossiers | 17 | 17060000116701 | 17060000116733 | 1 | 1 | PA368 | PM847741 | |
| 17060000116745 | L17/dossiers | 17 | 17060000116701 | 17060000116744 | 1 | 1 | PA368 | PM847741 | |
| 17060000117140 | L17/dossiers | 17 | 17060000117060 | 17060000117139 | 1 | 1 | PA717161 | PM791583 | |
| 17060000117354 | L17/dossiers | 17 | 17060000117319 | 17060000117353 | 1 | 1 | PA368 | PM847741 | |
| 17060000117363 | L17/dossiers | 17 | 17060000117319 | 17060000117362 | 1 | 1 | PA368 | PM847741 | |
| 17060000117483 | L17/dossiers | 17 | 17060000117451 | 17060000117482 | 1 | 1 | PA722190 | PM833697 | |
| 17060000118159 | L17/dossiers | 17 | 17060000118127 | 17060000118158 | 1 | 1 | PA410 | PM855580 | |
| 17060000118164 | L17/dossiers | 17 | 17060000118127 | 17060000118163 | 1 | 1 | PA410 | PM855580 | |
| 17060000118284 | L17/dossiers | 17 | 17060000118239 | 17060000118283 | 1 | 1 | PA410 | PM855580 | |
| 17060000118558 | L17/dossiers | 17 | 17060000118524 | 17060000118557 | 1 | 1 | PA410 | PM855580 | |
| 17060000118609 | L17/dossiers | 17 | 17060000118576 | 17060000118608 | 1 | 1 | PA643210 | PM873637 | |
| 17060000118691 | L17/dossiers | 17 | 17060000118654 | 17060000118690 | 1 | 1 | PA722190 | PM833697 | |
| 17060000119146 | L17/dossiers | 17 | 17060000119074 | 17060000119145 | 1 | 1 | PA410 | PM855580 | |
| 17060000119558 | L17/dossiers | 17 | 17060000119499 | 17060000119557 | 1 | 1 | PA410 | PM855580 | |
| 17060000120023 | L17/dossiers | 17 | 17060000119964 | 17060000120022 | 1 | 1 | PA410 | PM855580 | |
| 17060000120505 | L17/dossiers | 17 | 17060000120206 | 17060000120504 | 1 | 1 | PA410 | PM855580 | |
| 17060000122598 | L17/dossiers | 17 | 17060000122531 | 17060000122597 | 1 | 1 | PA368 | PM847741 | |
| 17060000123560 | L17/dossiers | 17 | 17060000123530 | 17060000123559 | 1 | 1 | PA410 | PM855580 | |
| 17060000123664 | L17/dossiers | 17 | 17060000123629 | 17060000123663 | 1 | 1 | PA410 | PM855580 | |
| 17060000123732 | L17/dossiers | 17 | 17060000123696 | 17060000123731 | 1 | 1 | PA410 | PM855580 | |
| 17060000123971 | L17/dossiers | 17 | 17060000123936 | 17060000123970 | 1 | 1 | PA410 | PM855580 | |
| 17060000124103 | L17/dossiers | 17 | 17060000124066 | 17060000124102 | 1 | 1 | PA410 | PM855580 | |
| 17060000125010 | L17/dossiers | 17 | 17060000124955 | 17060000125009 | 1 | 1 | PA410 | PM855580 | |
| 17060000125108 | L17/dossiers | 17 | 17060000125062 | 17060000125107 | 1 | 1 | PA410 | PM855580 | |
| 17060000125206 | L17/dossiers | 17 | 17060000125174 | 17060000125205 | 1 | 1 | PA368 | PM847741 | |
| 17060000125771 | L17/dossiers | 17 | 17060000125738 | 17060000125770 | 1 | 1 | PA410 | PM855580 | |
| 17060000126280 | L17/dossiers | 17 | 17060000126246 | 17060000126279 | 1 | 1 | PA410 | PM855580 | |
| 17060000126678 | L17/dossiers | 17 | 17060000126644 | 17060000126677 | 1 | 1 | PA410 | PM855580 | |
| 17060000126908 | L17/dossiers | 17 | 17060000126855 | 17060000126907 | 1 | 1 | PA410 | PM855580 | |
| 17060000127836 | L17/dossiers | 17 | 17060000127796 | 17060000127835 | 1 | 1 | PA410 | PM855580 | |
| 17060000128679 | L17/dossiers | 17 | 17060000128641 | 17060000128678 | 1 | 1 | PA410 | PM855580 | |
| 17060000128871 | L17/dossiers | 17 | 17060000128840 | 17060000128870 | 1 | 1 | PA410 | PM855580 | |
| 17060000130198 | L17/dossiers | 17 | 17060000130164 | 17060000130197 | 1 | 1 | PA410 | PM855580 | |
| 17060000131550 | L17/dossiers | 17 | 17060000131431 | 17060000131549 | 1 | 1 | PA643210 | PM873637 | |
| 17060000131903 | L17/dossiers | 17 | 17060000131869 | 17060000131902 | 1 | 1 | PA410 | PM855580 | |
| 17060000132293 | L17/dossiers | 17 | 17060000132256 | 17060000132292 | 1 | 1 | PA643210 | PM873637 | |
| 17060000133247 | L17/dossiers | 17 | 17060000133211 | 17060000133246 | 1 | 1 | PA410 | PM855580 | |
| 17060000134129 | L17/dossiers | 17 | 17060000134093 | 17060000134128 | 1 | 1 | PA643210 | PM873637 | |
| 17060000134399 | L17/dossiers | 17 | 17060000134356 | 17060000134398 | 1 | 1 | PA410 | PM855580 | |
| 17060000134481 | L17/dossiers | 17 | 17060000134421 | 17060000134480 | 1 | 1 | PA410 | PM855580 | |
| 17060000134938 | L17/dossiers | 17 | 17060000134900 | 17060000134937 | 1 | 1 | PA410 | PM855580 | |
| 17060000135443 | L17/dossiers | 17 | 17060000135375 | 17060000135442 | 1 | 1 | PA643210 | PM873637 | |
| 17060000136266 | L17/dossiers | 17 | 17060000136204 | 17060000136265 | 1 | 1 | PA643210 | PM873637 | |
| 17060000137800 | L17/dossiers | 17 | 17060000137455 | 17060000137799 | 1 | 1 | PA643210 | PM873637 | |
| 17060000139122 | L17/dossiers | 17 | 17060000139081 | 17060000139121 | 1 | 1 | PA643210 | PM873637 | |
| 17060000139217 | L17/dossiers | 17 | 17060000139179 | 17060000139216 | 1 | 1 | PA643210 | PM873637 | |
| 17060000139823 | L17/dossiers | 17 | 17060000139790 | 17060000139822 | 1 | 1 | PA643210 | PM873637 |