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 |
|---|---|---|---|---|---|---|---|
| 16060000099179 | L16/dossiers | 16 | 16060000099178 | 16060000099178 | 1 | PA795794 | PM797688 |
| 16060000099187 | L16/dossiers | 16 | 16060000099186 | 16060000099186 | 1 | PA775192 | PM775478 |
| 16060000099188 | L16/dossiers | 16 | 16060000099186 | 16060000099186 | 2 | PA775220 | PM775526 |
| 16060000099189 | L16/dossiers | 16 | 16060000099186 | 16060000099186 | 3 | PA775174 | PM775472 |
| 16060000099190 | L16/dossiers | 16 | 16060000099186 | 16060000099186 | 4 | PA775276 | PM775566 |
| 16060000099197 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 1 | PA721166 | PM785865 |
| 16060000099198 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 2 | PA736215 | PM736324 |
| 16060000099199 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 3 | PA703506 | PM777126 |
| 16060000099200 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 4 | PA736233 | PM736411 |
| 16060000099201 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 5 | PA736165 | PM736376 |
| 16060000099202 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 6 | PA303995 | PM775745 |
| 16060000099203 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 7 | PA775180 | PM775466 |
| 16060000099204 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 8 | PA801838 | PM801842 |
| 16060000099205 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 9 | PA429845 | PM736278 |
| 16060000099206 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 10 | PA775214 | PM775498 |
| 16060000099207 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 11 | PA775224 | PM775512 |
| 16060000099208 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 12 | PA736177 | PM736318 |
| 16060000099209 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 13 | PA429866 | PM736287 |
| 16060000099210 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 14 | PA775252 | PM775558 |
| 16060000099211 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 15 | PA775262 | PM775548 |
| 16060000099212 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 16 | PA775272 | PM775562 |
| 16060000099213 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 17 | PA775282 | PM775584 |
| 16060000099214 | L16/dossiers | 16 | 16060000099196 | 16060000099196 | 18 | PA785857 | PM785867 |
| 16060000099241 | L16/dossiers | 16 | 16060000099240 | 16060000099240 | 1 | PA794038 | PM796668 |
| 16060000099248 | L16/dossiers | 16 | 16060000099247 | 16060000099247 | 1 | PA794038 | PM796668 |
| 16060000099255 | L16/dossiers | 16 | 16060000099254 | 16060000099254 | 1 | PA703495 | PM775653 |
| 16060000099308 | L16/dossiers | 16 | 16060000099307 | 16060000099307 | 1 | PA719930 | PM796770 |
| 16060000099312 | L16/dossiers | 16 | 16060000099311 | 16060000099311 | 1 | PA267042 | PM796932 |
| 16060000099319 | L16/dossiers | 16 | 16060000099318 | 16060000099318 | 1 | PA2116 | PM736339 |
| 16060000099336 | L16/dossiers | 16 | 16060000099335 | 16060000099335 | 1 | PA793342 | PM796269 |
| 16060000099343 | L16/dossiers | 16 | 16060000099342 | 16060000099342 | 1 | PA266788 | PM796788 |
| 16060000099350 | L16/dossiers | 16 | 16060000099349 | 16060000099349 | 1 | PA774954 | PM796797 |
| 16060000099357 | L16/dossiers | 16 | 16060000099356 | 16060000099356 | 1 | PA266797 | PM796812 |
| 16060000099364 | L16/dossiers | 16 | 16060000099363 | 16060000099363 | 1 | PA721062 | PM797799 |
| 16060000099372 | L16/dossiers | 16 | 16060000099371 | 16060000099371 | 1 | PA794038 | PM796668 |
| 16060000099379 | L16/dossiers | 16 | 16060000099378 | 16060000099378 | 1 | PA703541 | PM775725 |
| 16060000099380 | L16/dossiers | 16 | 16060000099378 | 16060000099378 | 2 | PA758716 | PM775771 |
| 16060000099381 | L16/dossiers | 16 | 16060000099378 | 16060000099378 | 3 | PA758716 | PM775771 |
| 16060000099414 | L16/dossiers | 16 | 16060000099413 | 16060000099413 | 1 | PA227089 | PM736372 |
| 16060000099421 | L16/dossiers | 16 | 16060000099420 | 16060000099420 | 1 | PA794166 | PM796749 |
| 16060000099439 | L16/dossiers | 16 | 16060000099438 | 16060000099438 | 1 | PA720892 | PM797520 |
| 16060000099476 | L16/dossiers | 16 | 16060000099475 | 16060000099475 | 1 | PA695100 | PM797739 |
| 16060000099481 | L16/dossiers | 16 | 16060000099480 | 16060000099480 | 1 | PA794914 | PM797190 |
| 16060000099488 | L16/dossiers | 16 | 16060000099487 | 16060000099487 | 1 | PA736201 | PM797523 |
| 16060000099495 | L16/dossiers | 16 | 16060000099494 | 16060000099494 | 1 | PA718784 | PM796266 |
| 16060000099502 | L16/dossiers | 16 | 16060000099501 | 16060000099501 | 1 | PA720286 | PM796878 |
| 16060000099521 | L16/dossiers | 16 | 16060000099520 | 16060000099520 | 1 | PA795318 | PM797418 |
| 16060000099538 | L16/dossiers | 16 | 16060000099537 | 16060000099537 | 1 | PA795164 | PM797337 |
| 16060000099554 | L16/dossiers | 16 | 16060000099553 | 16060000099553 | 1 | PA794906 | PM797187 |
| 16060000099571 | L16/dossiers | 16 | 16060000099570 | 16060000099570 | 1 | PA795228 | PM797370 |