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 |
|---|---|---|---|---|---|---|---|
| 15060000156607 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 3 | PA709750 | PM736295 |
| 15060000156608 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 4 | PA736192 | PM736353 |
| 15060000156609 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 5 | PA736160 | PM736359 |
| 15060000156610 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 6 | PA425322 | PM736282 |
| 15060000156611 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 7 | PA703539 | PM703693 |
| 15060000156612 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 8 | PA736169 | PM736293 |
| 15060000156613 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 9 | PA267081 | PM703617 |
| 15060000156614 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 10 | PA304086 | PM736348 |
| 15060000156615 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 11 | PA744079 | PM744082 |
| 15060000156616 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 12 | PA528 | PM736270 |
| 15060000156617 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 13 | PA342665 | PM736382 |
| 15060000156618 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 14 | PA304085 | PM736343 |
| 15060000156619 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 15 | PA1001 | PM736371 |
| 15060000156620 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 16 | PA1037 | PM703690 |
| 15060000156621 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 17 | PA1344 | PM736383 |
| 15060000156622 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 18 | PA267907 | PM703591 |
| 15060000156623 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 19 | PA1562 | PM736340 |
| 15060000156624 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 20 | PA736223 | PM736368 |
| 15060000156625 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 21 | PA415495 | PM703579 |
| 15060000156626 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 22 | PA736238 | PM736352 |
| 15060000156627 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 23 | PA736232 | PM736401 |
| 15060000156628 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 24 | PA1842 | PM703543 |
| 15060000156629 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 25 | PA415447 | PM703616 |
| 15060000156630 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 26 | PA2042 | PM703682 |
| 15060000156631 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 27 | PA415446 | PM703678 |
| 15060000156632 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 28 | PA343988 | PM736310 |
| 15060000156633 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 29 | PA703521 | PM703544 |
| 15060000156634 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 30 | PA415479 | PM703586 |
| 15060000156635 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 31 | PA267872 | PM736409 |
| 15060000156636 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 32 | PA313924 | PM703546 |
| 15060000156637 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 33 | PA2447 | PM703679 |
| 15060000156638 | L15/dossiers | 15 | 15060000156604 | 15060000156604 | 34 | PA227094 | PM736386 |
| 15060000156645 | L15/dossiers | 15 | 15060000156644 | 15060000156644 | 1 | PA415476 | PM703653 |
| 15060000156652 | L15/dossiers | 15 | 15060000156651 | 15060000156651 | 1 | PA415476 | PM703653 |
| 15060000156659 | L15/dossiers | 15 | 15060000156658 | 15060000156658 | 1 | PA736207 | PM736391 |
| 15060000156666 | L15/dossiers | 15 | 15060000156665 | 15060000156665 | 1 | PA415454 | PM703689 |
| 15060000156673 | L15/dossiers | 15 | 15060000156672 | 15060000156672 | 1 | PA703493 | PM703683 |
| 15060000156680 | L15/dossiers | 15 | 15060000156679 | 15060000156679 | 1 | PA267907 | PM703591 |
| 15060000156687 | L15/dossiers | 15 | 15060000156686 | 15060000156686 | 1 | PA703514 | PM703585 |
| 15060000156694 | L15/dossiers | 15 | 15060000156693 | 15060000156693 | 1 | PA736231 | PM736381 |
| 15060000156695 | L15/dossiers | 15 | 15060000156693 | 15060000156693 | 2 | PA736218 | PM736257 |
| 15060000156702 | L15/dossiers | 15 | 15060000156701 | 15060000156701 | 1 | PA2116 | PM736339 |
| 15060000156709 | L15/dossiers | 15 | 15060000156708 | 15060000156708 | 1 | PA703485 | PM703654 |
| 15060000156716 | L15/dossiers | 15 | 15060000156715 | 15060000156715 | 1 | PA702993 | PM736362 |
| 15060000156723 | L15/dossiers | 15 | 15060000156722 | 15060000156722 | 1 | PA415446 | PM703678 |
| 15060000156730 | L15/dossiers | 15 | 15060000156729 | 15060000156729 | 1 | PA267340 | PM703713 |
| 15060000156731 | L15/dossiers | 15 | 15060000156729 | 15060000156729 | 2 | PA703507 | PM703567 |
| 15060000156732 | L15/dossiers | 15 | 15060000156729 | 15060000156729 | 3 | PA703513 | PM703621 |
| 15060000156733 | L15/dossiers | 15 | 15060000156729 | 15060000156729 | 4 | PA716 | PM736261 |
| 15060000156734 | L15/dossiers | 15 | 15060000156729 | 15060000156729 | 5 | PA1001 | PM736371 |