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 |
|---|---|---|---|---|---|---|---|
| 14060000108321 | L14/dossiers | 14 | 14060000108320 | 14060000108320 | 1 | PA2011 | PM645434 |
| 14060000108328 | L14/dossiers | 14 | 14060000108327 | 14060000108327 | 1 | PA1886 | PM645099 |
| 14060000108336 | L14/dossiers | 14 | 14060000108335 | 14060000108335 | 1 | PA2796 | PM645520 |
| 14060000108343 | L14/dossiers | 14 | 14060000108342 | 14060000108342 | 1 | PA267327 | PM645031 |
| 14060000108353 | L14/dossiers | 14 | 14060000108352 | 14060000108352 | 1 | PA331567 | PM645186 |
| 14060000108360 | L14/dossiers | 14 | 14060000108359 | 14060000108359 | 1 | PA267622 | PM702957 |
| 14060000108367 | L14/dossiers | 14 | 14060000108366 | 14060000108366 | 1 | PA2374 | PM645217 |
| 14060000108374 | L14/dossiers | 14 | 14060000108373 | 14060000108373 | 1 | PA330684 | PM645497 |
| 14060000108381 | L14/dossiers | 14 | 14060000108380 | 14060000108380 | 1 | PA381 | PM645125 |
| 14060000108385 | L14/dossiers | 14 | 14060000108384 | 14060000108384 | 1 | PA2073 | PM645207 |
| 14060000108393 | L14/dossiers | 14 | 14060000108392 | 14060000108392 | 1 | PA328 | PM653228 |
| 14060000108394 | L14/dossiers | 14 | 14060000108392 | 14060000108392 | 2 | PA1268 | PM653525 |
| 14060000108426 | L14/dossiers | 14 | 14060000108425 | 14060000108425 | 1 | PA605036 | PM645278 |
| 14060000108444 | L14/dossiers | 14 | 14060000108443 | 14060000108443 | 1 | PA607619 | PM645383 |
| 14060000108460 | L14/dossiers | 14 | 14060000108459 | 14060000108459 | 1 | PA331594 | PM645208 |
| 14060000108484 | L14/dossiers | 14 | 14060000108483 | 14060000108483 | 1 | PA2664 | PM645139 |
| 14060000108491 | L14/dossiers | 14 | 14060000108490 | 14060000108490 | 1 | PA266788 | PM645294 |
| 14060000108498 | L14/dossiers | 14 | 14060000108497 | 14060000108497 | 1 | PA1886 | PM645099 |
| 14060000108505 | L14/dossiers | 14 | 14060000108504 | 14060000108504 | 1 | PA2792 | PM645308 |
| 14060000108512 | L14/dossiers | 14 | 14060000108511 | 14060000108511 | 1 | PA2960 | PM645040 |
| 14060000108519 | L14/dossiers | 14 | 14060000108518 | 14060000108518 | 1 | PA1695 | PM645157 |
| 14060000108534 | L14/dossiers | 14 | 14060000108533 | 14060000108533 | 1 | PA328 | PM653228 |
| 14060000108565 | L14/dossiers | 14 | 14060000108564 | 14060000108564 | 1 | PA330684 | PM645497 |
| 14060000108576 | L14/dossiers | 14 | 14060000108575 | 14060000108575 | 1 | PA328 | PM653228 |
| 14060000108606 | L14/dossiers | 14 | 14060000108605 | 14060000108605 | 1 | PA267622 | PM702957 |
| 14060000108607 | L14/dossiers | 14 | 14060000108605 | 14060000108605 | 2 | PA1268 | PM702961 |
| 14060000108637 | L14/dossiers | 14 | 14060000108636 | 14060000108636 | 1 | PA563 | PM645307 |
| 14060000108647 | L14/dossiers | 14 | 14060000108646 | 14060000108646 | 1 | PA345937 | PM645177 |
| 14060000108654 | L14/dossiers | 14 | 14060000108653 | 14060000108653 | 1 | PA606745 | PM645560 |
| 14060000108664 | L14/dossiers | 14 | 14060000108663 | 14060000108663 | 1 | PA345937 | PM645177 |
| 14060000108671 | L14/dossiers | 14 | 14060000108670 | 14060000108670 | 1 | PA346886 | PM695110 |
| 14060000108678 | L14/dossiers | 14 | 14060000108677 | 14060000108677 | 1 | PA267785 | PM645359 |
| 14060000108685 | L14/dossiers | 14 | 14060000108684 | 14060000108684 | 1 | PA267622 | PM702957 |
| 14060000108686 | L14/dossiers | 14 | 14060000108684 | 14060000108684 | 2 | PA1268 | PM702961 |
| 14060000108698 | L14/dossiers | 14 | 14060000108697 | 14060000108697 | 1 | PA267622 | PM702957 |
| 14060000108705 | L14/dossiers | 14 | 14060000108704 | 14060000108704 | 1 | PA331567 | PM645186 |
| 14060000108712 | L14/dossiers | 14 | 14060000108711 | 14060000108711 | 1 | PA330240 | PM645425 |
| 14060000108719 | L14/dossiers | 14 | 14060000108718 | 14060000108718 | 1 | PA2664 | PM645139 |
| 14060000108729 | L14/dossiers | 14 | 14060000108728 | 14060000108728 | 1 | PA330240 | PM645425 |
| 14060000108736 | L14/dossiers | 14 | 14060000108735 | 14060000108735 | 1 | PA267358 | PM645602 |
| 14060000108743 | L14/dossiers | 14 | 14060000108742 | 14060000108742 | 1 | PA267689 | PM645295 |
| 14060000108754 | L14/dossiers | 14 | 14060000108753 | 14060000108753 | 1 | PA267433 | PM645316 |
| 14060000108764 | L14/dossiers | 14 | 14060000108763 | 14060000108763 | 1 | PA267492 | PM645465 |
| 14060000108774 | L14/dossiers | 14 | 14060000108773 | 14060000108773 | 1 | PA2124 | PM645475 |
| 14060000108781 | L14/dossiers | 14 | 14060000108780 | 14060000108780 | 1 | PA335159 | PM645554 |
| 14060000108788 | L14/dossiers | 14 | 14060000108787 | 14060000108787 | 1 | PA1874 | PM645474 |
| 14060000108795 | L14/dossiers | 14 | 14060000108794 | 14060000108794 | 1 | PA2713 | PM645148 |
| 14060000108802 | L14/dossiers | 14 | 14060000108801 | 14060000108801 | 1 | PA267306 | PM645210 |
| 14060000108809 | L14/dossiers | 14 | 14060000108808 | 14060000108808 | 1 | PA713448 | PM713451 |
| 14060000108816 | L14/dossiers | 14 | 14060000108815 | 14060000108815 | 1 | PA267622 | PM702957 |