dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000098441 | L16/dossiers | 16 | 16060000098440 | 16060000098440 | 1 | PA711156 | PM736319 |
| 16060000098459 | L16/dossiers | 16 | 16060000098458 | 16060000098458 | 1 | PA722202 | PM797358 |
| 16060000098466 | L16/dossiers | 16 | 16060000098465 | 16060000098465 | 1 | PA718838 | PM796197 |
| 16060000098473 | L16/dossiers | 16 | 16060000098472 | 16060000098472 | 1 | PA721486 | PM797517 |
| 16060000098480 | L16/dossiers | 16 | 16060000098479 | 16060000098479 | 1 | PA717161 | PM791583 |
| 16060000098481 | L16/dossiers | 16 | 16060000098479 | 16060000098479 | 2 | PA719938 | PM791702 |
| 16060000098488 | L16/dossiers | 16 | 16060000098487 | 16060000098487 | 1 | PA721816 | PM797571 |
| 16060000098500 | L16/dossiers | 16 | 16060000098499 | 16060000098499 | 1 | PA721486 | PM797517 |
| 16060000098507 | L16/dossiers | 16 | 16060000098506 | 16060000098506 | 1 | PA643134 | PM796758 |
| 16060000098514 | L16/dossiers | 16 | 16060000098513 | 16060000098513 | 1 | PA796062 | PM797832 |
| 16060000098521 | L16/dossiers | 16 | 16060000098520 | 16060000098520 | 1 | PA643134 | PM796758 |
| 16060000098528 | L16/dossiers | 16 | 16060000098527 | 16060000098527 | 1 | PA720892 | PM797520 |
| 16060000098535 | L16/dossiers | 16 | 16060000098534 | 16060000098534 | 1 | PA642868 | PM796968 |
| 16060000098542 | L16/dossiers | 16 | 16060000098541 | 16060000098541 | 1 | PA721270 | PM797829 |
| 16060000098549 | L16/dossiers | 16 | 16060000098548 | 16060000098548 | 1 | PA795552 | PM797547 |
| 16060000098556 | L16/dossiers | 16 | 16060000098555 | 16060000098555 | 1 | PA267042 | PM796932 |
| 16060000098563 | L16/dossiers | 16 | 16060000098562 | 16060000098562 | 1 | PA794082 | PM796698 |
| 16060000098570 | L16/dossiers | 16 | 16060000098569 | 16060000098569 | 1 | PA643089 | PM797439 |
| 16060000098577 | L16/dossiers | 16 | 16060000098576 | 16060000098576 | 1 | PA793238 | PM796224 |
| 16060000098584 | L16/dossiers | 16 | 16060000098583 | 16060000098583 | 1 | PA330240 | PM796155 |
| 16060000098591 | L16/dossiers | 16 | 16060000098590 | 16060000098590 | 1 | PA736228 | PM736380 |
| 16060000098598 | L16/dossiers | 16 | 16060000098597 | 16060000098597 | 1 | PA382672 | PM736263 |
| 16060000098605 | L16/dossiers | 16 | 16060000098604 | 16060000098604 | 1 | PA721024 | PM797592 |
| 16060000098609 | L16/dossiers | 16 | 16060000098608 | 16060000098608 | 1 | PA429869 | PM736350 |
| 16060000098616 | L16/dossiers | 16 | 16060000098615 | 16060000098615 | 1 | PA793342 | PM796269 |
| 16060000098620 | L16/dossiers | 16 | 16060000098619 | 16060000098619 | 1 | PA793708 | PM796488 |
| 16060000098631 | L16/dossiers | 16 | 16060000098630 | 16060000098630 | 1 | PA721182 | PM797736 |
| 16060000098635 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 1 | PA795228 | PM797370 |
| 16060000098636 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 2 | PA793262 | PM796236 |
| 16060000098637 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 3 | PA794906 | PM797187 |
| 16060000098638 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 4 | PA794138 | PM796734 |
| 16060000098639 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 5 | PA795588 | PM797577 |
| 16060000098640 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 6 | PA795084 | PM797292 |
| 16060000098641 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 7 | PA793780 | PM796527 |
| 16060000098642 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 8 | PA588884 | PM797373 |
| 16060000098643 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 9 | PA642764 | PM796524 |
| 16060000098644 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 10 | PA643143 | PM797646 |
| 16060000098645 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 11 | PA335999 | PM797655 |
| 16060000098646 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 12 | PA342415 | PM796659 |
| 16060000098647 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 13 | PA795058 | PM797277 |
| 16060000098648 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 14 | PA795362 | PM797442 |
| 16060000098649 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 15 | PA795454 | PM797493 |
| 16060000098650 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 16 | PA720430 | PM797025 |
| 16060000098651 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 17 | PA793772 | PM796521 |
| 16060000098652 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 18 | PA795616 | PM797589 |
| 16060000098653 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 19 | PA793444 | PM796329 |
| 16060000098654 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 20 | PA794094 | PM796710 |
| 16060000098655 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 21 | PA794938 | PM797202 |
| 16060000098656 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 22 | PA720838 | PM797865 |
| 16060000098657 | L16/dossiers | 16 | 16060000098634 | 16060000098634 | 23 | PA795318 | PM797418 |