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 |
|---|---|---|---|---|---|---|---|
| 14060000100570 | L14/dossiers | 14 | 14060000100569 | 14060000100569 | 1 | PA346886 | PM695110 |
| 14060000100580 | L14/dossiers | 14 | 14060000100579 | 14060000100579 | 1 | PA2796 | PM645520 |
| 14060000100587 | L14/dossiers | 14 | 14060000100586 | 14060000100586 | 1 | PA267622 | PM702957 |
| 14060000100588 | L14/dossiers | 14 | 14060000100586 | 14060000100586 | 2 | PA328 | PM711554 |
| 14060000100589 | L14/dossiers | 14 | 14060000100586 | 14060000100586 | 3 | PA2650 | PM711559 |
| 14060000100632 | L14/dossiers | 14 | 14060000100631 | 14060000100631 | 1 | PA2345 | PM645548 |
| 14060000100639 | L14/dossiers | 14 | 14060000100638 | 14060000100638 | 1 | PA609726 | PM645311 |
| 14060000100646 | L14/dossiers | 14 | 14060000100645 | 14060000100645 | 1 | PA1874 | PM645474 |
| 14060000100653 | L14/dossiers | 14 | 14060000100652 | 14060000100652 | 1 | PA346886 | PM695110 |
| 14060000100657 | L14/dossiers | 14 | 14060000100656 | 14060000100656 | 1 | PA1695 | PM645157 |
| 14060000100665 | L14/dossiers | 14 | 14060000100664 | 14060000100664 | 1 | PA563 | PM645307 |
| 14060000100672 | L14/dossiers | 14 | 14060000100671 | 14060000100671 | 1 | PA346886 | PM695110 |
| 14060000100679 | L14/dossiers | 14 | 14060000100678 | 14060000100678 | 1 | PA610521 | PM645190 |
| 14060000100689 | L14/dossiers | 14 | 14060000100688 | 14060000100688 | 1 | PA267492 | PM645465 |
| 14060000100696 | L14/dossiers | 14 | 14060000100695 | 14060000100695 | 1 | PA1585 | PM645094 |
| 14060000100706 | L14/dossiers | 14 | 14060000100705 | 14060000100705 | 1 | PA267605 | PM645189 |
| 14060000100713 | L14/dossiers | 14 | 14060000100712 | 14060000100712 | 1 | PA334906 | PM645577 |
| 14060000100730 | L14/dossiers | 14 | 14060000100729 | 14060000100729 | 1 | PA1263 | PM645432 |
| 14060000100737 | L14/dossiers | 14 | 14060000100736 | 14060000100736 | 1 | PA267622 | PM702957 |
| 14060000100766 | L14/dossiers | 14 | 14060000100765 | 14060000100765 | 1 | PA267622 | PM700712 |
| 14060000100767 | L14/dossiers | 14 | 14060000100765 | 14060000100765 | 2 | PA1268 | PM700715 |
| 14060000100798 | L14/dossiers | 14 | 14060000100797 | 14060000100797 | 1 | PA2073 | PM645207 |
| 14060000100818 | L14/dossiers | 14 | 14060000100817 | 14060000100817 | 1 | PA328 | PM653228 |
| 14060000100819 | L14/dossiers | 14 | 14060000100817 | 14060000100817 | 2 | PA1268 | PM653525 |
| 14060000100862 | L14/dossiers | 14 | 14060000100861 | 14060000100861 | 1 | PA267246 | PM645340 |
| 14060000100869 | L14/dossiers | 14 | 14060000100868 | 14060000100868 | 1 | PA267622 | PM702957 |
| 14060000100876 | L14/dossiers | 14 | 14060000100875 | 14060000100875 | 1 | PA606495 | PM645463 |
| 14060000100891 | L14/dossiers | 14 | 14060000100890 | 14060000100890 | 1 | PA642910 | PM701220 |
| 14060000100906 | L14/dossiers | 14 | 14060000100905 | 14060000100905 | 1 | PA608662 | PM645592 |
| 14060000100913 | L14/dossiers | 14 | 14060000100912 | 14060000100912 | 1 | PA785 | PM715797 |
| 14060000100921 | L14/dossiers | 14 | 14060000100920 | 14060000100920 | 1 | PA332228 | PM645546 |
| 14060000100929 | L14/dossiers | 14 | 14060000100928 | 14060000100928 | 1 | PA1206 | PM645054 |
| 14060000100936 | L14/dossiers | 14 | 14060000100935 | 14060000100935 | 1 | PA608920 | PM645060 |
| 14060000100937 | L14/dossiers | 14 | 14060000100935 | 14060000100935 | 2 | PA336576 | PM645364 |
| 14060000100952 | L14/dossiers | 14 | 14060000100951 | 14060000100951 | 1 | PA344492 | PM645300 |
| 14060000100959 | L14/dossiers | 14 | 14060000100958 | 14060000100958 | 1 | PA1886 | PM645099 |
| 14060000101006 | L14/dossiers | 14 | 14060000101005 | 14060000101005 | 1 | PA608380 | PM645578 |
| 14060000101013 | L14/dossiers | 14 | 14060000101012 | 14060000101012 | 1 | PA266788 | PM645294 |
| 14060000101020 | L14/dossiers | 14 | 14060000101019 | 14060000101019 | 1 | PA328 | PM653228 |
| 14060000101051 | L14/dossiers | 14 | 14060000101050 | 14060000101050 | 1 | PA2775 | PM645461 |
| 14060000101058 | L14/dossiers | 14 | 14060000101057 | 14060000101057 | 1 | PA328 | PM653228 |
| 14060000101059 | L14/dossiers | 14 | 14060000101057 | 14060000101057 | 2 | PA2240 | PM653295 |
| 14060000101066 | L14/dossiers | 14 | 14060000101065 | 14060000101065 | 1 | PA2011 | PM645434 |
| 14060000101073 | L14/dossiers | 14 | 14060000101072 | 14060000101072 | 1 | PA335054 | PM645614 |
| 14060000101093 | L14/dossiers | 14 | 14060000101092 | 14060000101092 | 1 | PA333134 | PM645341 |
| 14060000101100 | L14/dossiers | 14 | 14060000101099 | 14060000101099 | 1 | PA267306 | PM645210 |
| 14060000101117 | L14/dossiers | 14 | 14060000101116 | 14060000101116 | 1 | PA336316 | PM645298 |
| 14060000101124 | L14/dossiers | 14 | 14060000101123 | 14060000101123 | 1 | PA267355 | PM645581 |
| 14060000101131 | L14/dossiers | 14 | 14060000101130 | 14060000101130 | 1 | PA267622 | PM702957 |
| 14060000101132 | L14/dossiers | 14 | 14060000101130 | 14060000101130 | 2 | PA331594 | PM711625 |