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 |
|---|---|---|---|---|---|---|---|
| 15060000155669 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 11 | PA268048 | PM736422 |
| 15060000155670 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 12 | PA429888 | PM736379 |
| 15060000155671 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 13 | PA703512 | PM703575 |
| 15060000155672 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 14 | PA736209 | PM736400 |
| 15060000155673 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 15 | PA703495 | PM703708 |
| 15060000155674 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 16 | PA736201 | PM736347 |
| 15060000155675 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 17 | PA736217 | PM736384 |
| 15060000155676 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 18 | PA703481 | PM703670 |
| 15060000155677 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 19 | PA703491 | PM703634 |
| 15060000155678 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 20 | PA2870 | PM736316 |
| 15060000155685 | L15/dossiers | 15 | 15060000155684 | 15060000155684 | 1 | PA736179 | PM736420 |
| 15060000155692 | L15/dossiers | 15 | 15060000155691 | 15060000155691 | 1 | PA267018 | PM703564 |
| 15060000155699 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 1 | PA267018 | PM703564 |
| 15060000155700 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 2 | PA736247 | PM736281 |
| 15060000155701 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 3 | PA736198 | PM736406 |
| 15060000155702 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 4 | PA342665 | PM736382 |
| 15060000155703 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 5 | PA736176 | PM736434 |
| 15060000155704 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 6 | PA303997 | PM703603 |
| 15060000155705 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 7 | PA703510 | PM703672 |
| 15060000155706 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 8 | PA429870 | PM736309 |
| 15060000155707 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 9 | PA703513 | PM703621 |
| 15060000155708 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 10 | PA415462 | PM703628 |
| 15060000155709 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 11 | PA720634 | PM736312 |
| 15060000155710 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 12 | PA715745 | PM736297 |
| 15060000155711 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 13 | PA980 | PM736356 |
| 15060000155712 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 14 | PA736192 | PM736353 |
| 15060000155713 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 15 | PA267340 | PM703713 |
| 15060000155714 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 16 | PA1001 | PM736371 |
| 15060000155715 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 17 | PA425322 | PM736282 |
| 15060000155716 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 18 | PA267112 | PM703608 |
| 15060000155717 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 19 | PA703494 | PM703602 |
| 15060000155718 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 20 | PA404656 | PM736328 |
| 15060000155719 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 21 | PA703506 | PM703680 |
| 15060000155720 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 22 | PA703520 | PM703665 |
| 15060000155721 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 23 | PA1344 | PM736383 |
| 15060000155722 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 24 | PA703507 | PM703567 |
| 15060000155723 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 25 | PA267081 | PM703617 |
| 15060000155724 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 26 | PA736238 | PM736352 |
| 15060000155725 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 27 | PA304737 | PM703551 |
| 15060000155726 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 28 | PA703515 | PM703592 |
| 15060000155727 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 29 | PA394676 | PM703550 |
| 15060000155728 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 30 | PA304000 | PM703599 |
| 15060000155729 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 31 | PA736246 | PM736428 |
| 15060000155730 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 32 | PA415451 | PM703594 |
| 15060000155731 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 33 | PA415447 | PM703616 |
| 15060000155732 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 34 | PA736186 | PM736396 |
| 15060000155733 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 35 | PA343775 | PM736367 |
| 15060000155734 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 36 | PA703537 | PM703595 |
| 15060000155735 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 37 | PA736185 | PM736264 |
| 15060000155736 | L15/dossiers | 15 | 15060000155698 | 15060000155698 | 38 | PA703497 | PM703569 |