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 |
|---|---|---|---|---|---|---|---|
| 14060000130356 | L14/dossiers | 14 | 14060000130355 | 14060000130355 | 1 | PA267801 | PM645153 |
| 14060000130363 | L14/dossiers | 14 | 14060000130362 | 14060000130362 | 1 | PA267801 | PM645153 |
| 14060000130370 | L14/dossiers | 14 | 14060000130369 | 14060000130369 | 1 | PA267306 | PM645210 |
| 14060000130377 | L14/dossiers | 14 | 14060000130376 | 14060000130376 | 1 | PA1857 | PM645505 |
| 14060000130384 | L14/dossiers | 14 | 14060000130383 | 14060000130383 | 1 | PA702053 | PM702060 |
| 14060000130391 | L14/dossiers | 14 | 14060000130390 | 14060000130390 | 1 | PA267419 | PM703658 |
| 14060000130457 | L14/dossiers | 14 | 14060000130456 | 14060000130456 | 1 | PA267801 | PM645153 |
| 14060000130474 | L14/dossiers | 14 | 14060000130473 | 14060000130473 | 1 | PA267680 | PM645427 |
| 14060000130481 | L14/dossiers | 14 | 14060000130480 | 14060000130480 | 1 | PA643211 | PM703707 |
| 14060000130505 | L14/dossiers | 14 | 14060000130504 | 14060000130504 | 1 | PA267622 | PM702957 |
| 14060000130506 | L14/dossiers | 14 | 14060000130504 | 14060000130504 | 2 | PA2679 | PM702976 |
| 14060000130513 | L14/dossiers | 14 | 14060000130512 | 14060000130512 | 1 | PA268019 | PM645116 |
| 14060000130520 | L14/dossiers | 14 | 14060000130519 | 14060000130519 | 1 | PA267622 | PM702957 |
| 14060000130528 | L14/dossiers | 14 | 14060000130527 | 14060000130527 | 1 | PA328 | PM653228 |
| 14060000130582 | L14/dossiers | 14 | 14060000130581 | 14060000130581 | 1 | PA334149 | PM645127 |
| 14060000130589 | L14/dossiers | 14 | 14060000130588 | 14060000130588 | 1 | PA944 | PM415506 |
| 14060000130608 | L14/dossiers | 14 | 14060000130607 | 14060000130607 | 1 | PA1031 | PM645044 |
| 14060000130621 | L14/dossiers | 14 | 14060000130620 | 14060000130620 | 1 | PA2796 | PM645520 |
| 14060000130628 | L14/dossiers | 14 | 14060000130627 | 14060000130627 | 1 | PA2011 | PM645434 |
| 14060000130635 | L14/dossiers | 14 | 14060000130634 | 14060000130634 | 1 | PA340755 | PM645506 |
| 14060000130642 | L14/dossiers | 14 | 14060000130641 | 14060000130641 | 1 | PA267204 | PM645551 |
| 14060000130649 | L14/dossiers | 14 | 14060000130648 | 14060000130648 | 1 | PA328 | PM653228 |
| 14060000130678 | L14/dossiers | 14 | 14060000130677 | 14060000130677 | 1 | PA2796 | PM645520 |
| 14060000130688 | L14/dossiers | 14 | 14060000130687 | 14060000130687 | 1 | PA2603 | PM645552 |
| 14060000130695 | L14/dossiers | 14 | 14060000130694 | 14060000130694 | 1 | PA608416 | PM645586 |
| 14060000130702 | L14/dossiers | 14 | 14060000130701 | 14060000130701 | 1 | PA609365 | PM645191 |
| 14060000130716 | L14/dossiers | 14 | 14060000130715 | 14060000130715 | 1 | PA267622 | PM702957 |
| 14060000130723 | L14/dossiers | 14 | 14060000130722 | 14060000130722 | 1 | PA267492 | PM645465 |
| 14060000130730 | L14/dossiers | 14 | 14060000130729 | 14060000130729 | 1 | PA267246 | PM645340 |
| 14060000130737 | L14/dossiers | 14 | 14060000130736 | 14060000130736 | 1 | PA605991 | PM645081 |
| 14060000130747 | L14/dossiers | 14 | 14060000130746 | 14060000130746 | 1 | PA334768 | PM645582 |
| 14060000130784 | L14/dossiers | 14 | 14060000130783 | 14060000130783 | 1 | PA267492 | PM645465 |
| 14060000130801 | L14/dossiers | 14 | 14060000130800 | 14060000130800 | 1 | PA606212 | PM645330 |
| 14060000130814 | L14/dossiers | 14 | 14060000130813 | 14060000130813 | 1 | PA267622 | PM702957 |
| 14060000130821 | L14/dossiers | 14 | 14060000130820 | 14060000130820 | 1 | PA336316 | PM645298 |
| 14060000130828 | L14/dossiers | 14 | 14060000130827 | 14060000130827 | 1 | PA267457 | PM687216 |
| 14060000130835 | L14/dossiers | 14 | 14060000130834 | 14060000130834 | 1 | PA332228 | PM645546 |
| 14060000130842 | L14/dossiers | 14 | 14060000130841 | 14060000130841 | 1 | PA346886 | PM695110 |
| 14060000130846 | L14/dossiers | 14 | 14060000130845 | 14060000130845 | 1 | PA266788 | PM645294 |
| 14060000130865 | L14/dossiers | 14 | 14060000130864 | 14060000130864 | 1 | PA429869 | PM429926 |
| 14060000130877 | L14/dossiers | 14 | 14060000130876 | 14060000130876 | 1 | PA1886 | PM645099 |
| 14060000130892 | L14/dossiers | 14 | 14060000130891 | 14060000130891 | 1 | PA331582 | PM645198 |
| 14060000130909 | L14/dossiers | 14 | 14060000130908 | 14060000130908 | 1 | PA609726 | PM645311 |
| 14060000130916 | L14/dossiers | 14 | 14060000130915 | 14060000130915 | 1 | PA563 | PM645307 |
| 14060000130923 | L14/dossiers | 14 | 14060000130922 | 14060000130922 | 1 | PA1874 | PM645474 |
| 14060000130930 | L14/dossiers | 14 | 14060000130929 | 14060000130929 | 1 | PA267622 | PM702957 |
| 14060000130934 | L14/dossiers | 14 | 14060000130933 | 14060000130933 | 1 | PA2048 | PM645036 |
| 14060000130941 | L14/dossiers | 14 | 14060000130940 | 14060000130940 | 1 | PA998 | PM645034 |
| 14060000130948 | L14/dossiers | 14 | 14060000130947 | 14060000130947 | 1 | PA2952 | PM645464 |
| 14060000130955 | L14/dossiers | 14 | 14060000130954 | 14060000130954 | 1 | PA2775 | PM645461 |