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 |
|---|---|---|---|---|---|---|---|
| 14060000091606 | L14/dossiers | 14 | 14060000091605 | 14060000091605 | 1 | PA2277 | PM645135 |
| 14060000091616 | L14/dossiers | 14 | 14060000091615 | 14060000091615 | 1 | PA328 | PM653228 |
| 14060000091617 | L14/dossiers | 14 | 14060000091615 | 14060000091615 | 2 | PA2240 | PM653295 |
| 14060000091618 | L14/dossiers | 14 | 14060000091615 | 14060000091615 | 3 | PA2825 | PM653254 |
| 14060000091736 | L14/dossiers | 14 | 14060000091735 | 14060000091735 | 1 | PA267622 | PM702957 |
| 14060000091737 | L14/dossiers | 14 | 14060000091735 | 14060000091735 | 2 | PA331594 | PM711625 |
| 14060000091738 | L14/dossiers | 14 | 14060000091735 | 14060000091735 | 3 | PA785 | PM702979 |
| 14060000091739 | L14/dossiers | 14 | 14060000091735 | 14060000091735 | 4 | PA2679 | PM702976 |
| 14060000091825 | L14/dossiers | 14 | 14060000091824 | 14060000091824 | 1 | PA610291 | PM645119 |
| 14060000091826 | L14/dossiers | 14 | 14060000091824 | 14060000091824 | 2 | PA345897 | PM645209 |
| 14060000091836 | L14/dossiers | 14 | 14060000091835 | 14060000091835 | 1 | PA267622 | PM702957 |
| 14060000091843 | L14/dossiers | 14 | 14060000091842 | 14060000091842 | 1 | PA330240 | PM645425 |
| 14060000091853 | L14/dossiers | 14 | 14060000091852 | 14060000091852 | 1 | PA328 | PM653228 |
| 14060000091854 | L14/dossiers | 14 | 14060000091852 | 14060000091852 | 2 | PA1268 | PM653525 |
| 14060000091885 | L14/dossiers | 14 | 14060000091884 | 14060000091884 | 1 | PA1379 | PM645433 |
| 14060000091901 | L14/dossiers | 14 | 14060000091900 | 14060000091900 | 1 | PA309643 | PM645326 |
| 14060000091918 | L14/dossiers | 14 | 14060000091917 | 14060000091917 | 1 | PA331481 | PM645136 |
| 14060000091925 | L14/dossiers | 14 | 14060000091924 | 14060000091924 | 1 | PA266797 | PM645338 |
| 14060000091936 | L14/dossiers | 14 | 14060000091935 | 14060000091935 | 1 | PA607090 | PM645143 |
| 14060000091943 | L14/dossiers | 14 | 14060000091942 | 14060000091942 | 1 | PA346886 | PM695110 |
| 14060000091950 | L14/dossiers | 14 | 14060000091949 | 14060000091949 | 1 | PA429860 | PM429990 |
| 14060000091962 | L14/dossiers | 14 | 14060000091961 | 14060000091961 | 1 | PA1496 | PM645273 |
| 14060000091971 | L14/dossiers | 14 | 14060000091970 | 14060000091970 | 1 | PA608120 | PM645159 |
| 14060000091978 | L14/dossiers | 14 | 14060000091977 | 14060000091977 | 1 | PA267622 | PM702957 |
| 14060000092012 | L14/dossiers | 14 | 14060000092011 | 14060000092011 | 1 | PA267492 | PM645465 |
| 14060000092019 | L14/dossiers | 14 | 14060000092018 | 14060000092018 | 1 | PA2277 | PM645135 |
| 14060000092026 | L14/dossiers | 14 | 14060000092025 | 14060000092025 | 1 | PA785 | PM715797 |
| 14060000092033 | L14/dossiers | 14 | 14060000092032 | 14060000092032 | 1 | PA267785 | PM645359 |
| 14060000092040 | L14/dossiers | 14 | 14060000092039 | 14060000092039 | 1 | PA334843 | PM645589 |
| 14060000092047 | L14/dossiers | 14 | 14060000092046 | 14060000092046 | 1 | PA1886 | PM645099 |
| 14060000092054 | L14/dossiers | 14 | 14060000092053 | 14060000092053 | 1 | PA230 | PM645553 |
| 14060000092062 | L14/dossiers | 14 | 14060000092061 | 14060000092061 | 1 | PA2713 | PM645148 |
| 14060000092069 | L14/dossiers | 14 | 14060000092068 | 14060000092068 | 1 | PA328 | PM653228 |
| 14060000092120 | L14/dossiers | 14 | 14060000092119 | 14060000092119 | 1 | PA335054 | PM645614 |
| 14060000092135 | L14/dossiers | 14 | 14060000092134 | 14060000092134 | 1 | PA607761 | PM645482 |
| 14060000092149 | L14/dossiers | 14 | 14060000092148 | 14060000092148 | 1 | PA2700 | PM645196 |
| 14060000092153 | L14/dossiers | 14 | 14060000092152 | 14060000092152 | 1 | PA609016 | PM645074 |
| 14060000092161 | L14/dossiers | 14 | 14060000092160 | 14060000092160 | 1 | PA267622 | PM700712 |
| 14060000092162 | L14/dossiers | 14 | 14060000092160 | 14060000092160 | 2 | PA2650 | PM700718 |
| 14060000092341 | L14/dossiers | 14 | 14060000092340 | 14060000092340 | 1 | PA266788 | PM645294 |
| 14060000092348 | L14/dossiers | 14 | 14060000092347 | 14060000092347 | 1 | PA1931 | PM645042 |
| 14060000092356 | L14/dossiers | 14 | 14060000092355 | 14060000092355 | 1 | PA609764 | PM645323 |
| 14060000092363 | L14/dossiers | 14 | 14060000092362 | 14060000092362 | 1 | PA328 | PM653228 |
| 14060000092507 | L14/dossiers | 14 | 14060000092506 | 14060000092506 | 1 | PA332747 | PM645155 |
| 14060000092522 | L14/dossiers | 14 | 14060000092521 | 14060000092521 | 1 | PA267622 | PM702957 |
| 14060000092529 | L14/dossiers | 14 | 14060000092528 | 14060000092528 | 1 | PA267042 | PM645368 |
| 14060000092536 | L14/dossiers | 14 | 14060000092535 | 14060000092535 | 1 | PA267551 | PM645372 |
| 14060000092543 | L14/dossiers | 14 | 14060000092542 | 14060000092542 | 1 | PA2971 | PM645392 |
| 14060000092553 | L14/dossiers | 14 | 14060000092552 | 14060000092552 | 1 | PA266788 | PM645294 |
| 14060000092564 | L14/dossiers | 14 | 14060000092563 | 14060000092563 | 1 | PA608186 | PM645202 |