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 |
|---|---|---|---|---|---|---|---|
| 16060000091625 | L16/dossiers | 16 | 16060000091624 | 16060000091624 | 1 | PA703482 | PM703642 |
| 16060000091654 | L16/dossiers | 16 | 16060000091653 | 16060000091653 | 1 | PA643211 | PM703707 |
| 16060000091678 | L16/dossiers | 16 | 16060000091677 | 16060000091677 | 1 | PA703493 | PM703683 |
| 16060000091707 | L16/dossiers | 16 | 16060000091706 | 16060000091706 | 1 | PA429858 | PM736268 |
| 16060000091737 | L16/dossiers | 16 | 16060000091736 | 16060000091736 | 1 | PA382672 | PM736263 |
| 16060000091761 | L16/dossiers | 16 | 16060000091760 | 16060000091760 | 1 | PA736228 | PM736380 |
| 16060000091785 | L16/dossiers | 16 | 16060000091784 | 16060000091784 | 1 | PA415459 | PM703660 |
| 16060000091809 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 1 | PA429870 | PM736309 |
| 16060000091810 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 2 | PA703482 | PM703642 |
| 16060000091811 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 3 | PA703516 | PM703559 |
| 16060000091812 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 4 | PA703521 | PM703544 |
| 16060000091813 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 5 | PA2237 | PM703705 |
| 16060000091814 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 6 | PA703513 | PM703621 |
| 16060000091815 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 7 | PA343988 | PM736310 |
| 16060000091816 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 8 | PA736239 | PM736317 |
| 16060000091817 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 9 | PA736224 | PM736403 |
| 16060000091818 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 10 | PA703522 | PM703702 |
| 16060000091819 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 11 | PA267112 | PM703608 |
| 16060000091820 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 12 | PA703500 | PM703574 |
| 16060000091821 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 13 | PA267907 | PM703591 |
| 16060000091822 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 14 | PA736218 | PM736257 |
| 16060000091823 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 15 | PA2197 | PM703640 |
| 16060000091824 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 16 | PA715322 | PM715327 |
| 16060000091825 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 17 | PA736207 | PM736391 |
| 16060000091826 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 18 | PA425322 | PM736282 |
| 16060000091827 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 19 | PA267081 | PM703617 |
| 16060000091828 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 20 | PA342665 | PM736382 |
| 16060000091829 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 21 | PA313924 | PM703546 |
| 16060000091830 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 22 | PA2538 | PM703570 |
| 16060000091831 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 23 | PA703520 | PM703665 |
| 16060000091832 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 24 | PA429851 | PM736305 |
| 16060000091833 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 25 | PA736200 | PM736285 |
| 16060000091834 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 26 | PA703507 | PM703567 |
| 16060000091835 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 27 | PA429874 | PM736314 |
| 16060000091836 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 28 | PA715745 | PM736297 |
| 16060000091837 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 29 | PA1183 | PM706347 |
| 16060000091838 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 30 | PA415456 | PM736433 |
| 16060000091839 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 31 | PA736176 | PM736434 |
| 16060000091840 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 32 | PA736160 | PM736359 |
| 16060000091841 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 33 | PA703540 | PM703573 |
| 16060000091842 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 34 | PA709750 | PM736295 |
| 16060000091843 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 35 | PA736227 | PM736308 |
| 16060000091844 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 36 | PA736202 | PM736392 |
| 16060000091845 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 37 | PA394676 | PM703550 |
| 16060000091846 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 38 | PA304086 | PM736348 |
| 16060000091847 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 39 | PA304000 | PM703599 |
| 16060000091848 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 40 | PA2447 | PM703679 |
| 16060000091849 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 41 | PA736163 | PM736253 |
| 16060000091850 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 42 | PA267728 | PM736277 |
| 16060000091851 | L16/dossiers | 16 | 16060000091808 | 16060000091808 | 43 | PA703537 | PM703595 |