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 |
|---|---|---|---|---|---|---|---|
| 14060000093801 | L14/dossiers | 14 | 14060000093800 | 14060000093800 | 1 | PA2713 | PM645148 |
| 14060000093808 | L14/dossiers | 14 | 14060000093807 | 14060000093807 | 1 | PA785 | PM715797 |
| 14060000093890 | L14/dossiers | 14 | 14060000093889 | 14060000093889 | 1 | PA2048 | PM693013 |
| 14060000093897 | L14/dossiers | 14 | 14060000093896 | 14060000093896 | 1 | PA606478 | PM645457 |
| 14060000093904 | L14/dossiers | 14 | 14060000093903 | 14060000093903 | 1 | PA606212 | PM645330 |
| 14060000093911 | L14/dossiers | 14 | 14060000093910 | 14060000093910 | 1 | PA268019 | PM645116 |
| 14060000093928 | L14/dossiers | 14 | 14060000093927 | 14060000093927 | 1 | PA267622 | PM700712 |
| 14060000093964 | L14/dossiers | 14 | 14060000093963 | 14060000093963 | 1 | PA785 | PM715797 |
| 14060000093971 | L14/dossiers | 14 | 14060000093970 | 14060000093970 | 1 | PA785 | PM715797 |
| 14060000093978 | L14/dossiers | 14 | 14060000093977 | 14060000093977 | 1 | PA335054 | PM645614 |
| 14060000093979 | L14/dossiers | 14 | 14060000093977 | 14060000093977 | 2 | PA1012 | PM645168 |
| 14060000093989 | L14/dossiers | 14 | 14060000093988 | 14060000093988 | 1 | PA230 | PM645553 |
| 14060000093996 | L14/dossiers | 14 | 14060000093995 | 14060000093995 | 1 | PA335054 | PM645614 |
| 14060000093997 | L14/dossiers | 14 | 14060000093995 | 14060000093995 | 2 | PA1012 | PM645168 |
| 14060000094007 | L14/dossiers | 14 | 14060000094006 | 14060000094006 | 1 | PA2086 | PM645043 |
| 14060000094014 | L14/dossiers | 14 | 14060000094013 | 14060000094013 | 1 | PA2377 | PM645591 |
| 14060000094021 | L14/dossiers | 14 | 14060000094020 | 14060000094020 | 1 | PA689 | PM645113 |
| 14060000094028 | L14/dossiers | 14 | 14060000094027 | 14060000094027 | 1 | PA267492 | PM645465 |
| 14060000094038 | L14/dossiers | 14 | 14060000094037 | 14060000094037 | 1 | PA328 | PM653228 |
| 14060000094039 | L14/dossiers | 14 | 14060000094037 | 14060000094037 | 2 | PA588872 | PM653304 |
| 14060000094080 | L14/dossiers | 14 | 14060000094079 | 14060000094079 | 1 | PA267492 | PM645465 |
| 14060000094087 | L14/dossiers | 14 | 14060000094086 | 14060000094086 | 1 | PA330684 | PM645497 |
| 14060000094094 | L14/dossiers | 14 | 14060000094093 | 14060000094093 | 1 | PA267407 | PM645320 |
| 14060000094102 | L14/dossiers | 14 | 14060000094101 | 14060000094101 | 1 | PA267622 | PM702957 |
| 14060000094103 | L14/dossiers | 14 | 14060000094101 | 14060000094101 | 2 | PA1268 | PM702961 |
| 14060000094135 | L14/dossiers | 14 | 14060000094134 | 14060000094134 | 1 | PA606212 | PM645330 |
| 14060000094136 | L14/dossiers | 14 | 14060000094134 | 14060000094134 | 2 | PA609709 | PM645302 |
| 14060000094143 | L14/dossiers | 14 | 14060000094142 | 14060000094142 | 1 | PA1206 | PM645054 |
| 14060000094153 | L14/dossiers | 14 | 14060000094152 | 14060000094152 | 1 | PA785 | PM715797 |
| 14060000094191 | L14/dossiers | 14 | 14060000094190 | 14060000094190 | 1 | PA267260 | PM645459 |
| 14060000094201 | L14/dossiers | 14 | 14060000094200 | 14060000094200 | 1 | PA267457 | PM687216 |
| 14060000094208 | L14/dossiers | 14 | 14060000094207 | 14060000094207 | 1 | PA267622 | PM702957 |
| 14060000094215 | L14/dossiers | 14 | 14060000094214 | 14060000094214 | 1 | PA2796 | PM645520 |
| 14060000094222 | L14/dossiers | 14 | 14060000094221 | 14060000094221 | 1 | PA2971 | PM645392 |
| 14060000094229 | L14/dossiers | 14 | 14060000094228 | 14060000094228 | 1 | PA267492 | PM645465 |
| 14060000094233 | L14/dossiers | 14 | 14060000094232 | 14060000094232 | 1 | PA267622 | PM702957 |
| 14060000094234 | L14/dossiers | 14 | 14060000094232 | 14060000094232 | 2 | PA702992 | PM702994 |
| 14060000094242 | L14/dossiers | 14 | 14060000094241 | 14060000094241 | 1 | PA608826 | PM645556 |
| 14060000094249 | L14/dossiers | 14 | 14060000094248 | 14060000094248 | 1 | PA606212 | PM645330 |
| 14060000094256 | L14/dossiers | 14 | 14060000094255 | 14060000094255 | 1 | PA328 | PM653228 |
| 14060000094293 | L14/dossiers | 14 | 14060000094292 | 14060000094292 | 1 | PA1206 | PM645054 |
| 14060000094300 | L14/dossiers | 14 | 14060000094299 | 14060000094299 | 1 | PA2343 | PM645498 |
| 14060000094304 | L14/dossiers | 14 | 14060000094303 | 14060000094303 | 1 | PA610481 | PM645131 |
| 14060000094311 | L14/dossiers | 14 | 14060000094310 | 14060000094310 | 1 | PA328 | PM653228 |
| 14060000094312 | L14/dossiers | 14 | 14060000094310 | 14060000094310 | 2 | PA2791 | PM653325 |
| 14060000094370 | L14/dossiers | 14 | 14060000094369 | 14060000094369 | 1 | PA328 | PM653228 |
| 14060000094371 | L14/dossiers | 14 | 14060000094369 | 14060000094369 | 2 | PA1268 | PM653525 |
| 14060000094382 | L14/dossiers | 14 | 14060000094381 | 14060000094381 | 1 | PA230 | PM645553 |
| 14060000094403 | L14/dossiers | 14 | 14060000094402 | 14060000094402 | 1 | PA330240 | PM645425 |
| 14060000094410 | L14/dossiers | 14 | 14060000094409 | 14060000094409 | 1 | PA607489 | PM645366 |