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 |
|---|---|---|---|---|---|---|---|
| 15060000142065 | L15/dossiers | 15 | 15060000142064 | 15060000142064 | 1 | PA721932 | PM734586 |
| 15060000142078 | L15/dossiers | 15 | 15060000142077 | 15060000142077 | 1 | PA345619 | PM725692 |
| 15060000142079 | L15/dossiers | 15 | 15060000142077 | 15060000142077 | 2 | PA1872 | PM730104 |
| 15060000142080 | L15/dossiers | 15 | 15060000142077 | 15060000142077 | 3 | PA1872 | PM730104 |
| 15060000142111 | L15/dossiers | 15 | 15060000142110 | 15060000142110 | 1 | PA605518 | PM722518 |
| 15060000142118 | L15/dossiers | 15 | 15060000142117 | 15060000142117 | 1 | PA608416 | PM723540 |
| 15060000142128 | L15/dossiers | 15 | 15060000142127 | 15060000142127 | 1 | PA695100 | PM723198 |
| 15060000142135 | L15/dossiers | 15 | 15060000142134 | 15060000142134 | 1 | PA720892 | PM723106 |
| 15060000142142 | L15/dossiers | 15 | 15060000142141 | 15060000142141 | 1 | PA2377 | PM723550 |
| 15060000142149 | L15/dossiers | 15 | 15060000142148 | 15060000142148 | 1 | PA267306 | PM723054 |
| 15060000142156 | L15/dossiers | 15 | 15060000142155 | 15060000142155 | 1 | PA608416 | PM723540 |
| 15060000142163 | L15/dossiers | 15 | 15060000142162 | 15060000142162 | 1 | PA720630 | PM723020 |
| 15060000142170 | L15/dossiers | 15 | 15060000142169 | 15060000142169 | 1 | PA721968 | PM723436 |
| 15060000142177 | L15/dossiers | 15 | 15060000142176 | 15060000142176 | 1 | PA330008 | PM722416 |
| 15060000142184 | L15/dossiers | 15 | 15060000142183 | 15060000142183 | 1 | PA345619 | PM725692 |
| 15060000142185 | L15/dossiers | 15 | 15060000142183 | 15060000142183 | 2 | PA906 | PM730043 |
| 15060000142195 | L15/dossiers | 15 | 15060000142194 | 15060000142194 | 1 | PA720030 | PM722838 |
| 15060000142196 | L15/dossiers | 15 | 15060000142194 | 15060000142194 | 2 | PA267306 | PM723054 |
| 15060000142222 | L15/dossiers | 15 | 15060000142221 | 15060000142221 | 1 | PA642847 | PM722954 |
| 15060000142229 | L15/dossiers | 15 | 15060000142228 | 15060000142228 | 1 | PA334149 | PM723034 |
| 15060000142236 | L15/dossiers | 15 | 15060000142235 | 15060000142235 | 1 | PA334843 | PM723534 |
| 15060000142243 | L15/dossiers | 15 | 15060000142242 | 15060000142242 | 1 | PA720552 | PM722998 |
| 15060000142250 | L15/dossiers | 15 | 15060000142249 | 15060000142249 | 1 | PA718780 | PM722454 |
| 15060000142257 | L15/dossiers | 15 | 15060000142256 | 15060000142256 | 1 | PA1874 | PM722598 |
| 15060000142264 | L15/dossiers | 15 | 15060000142263 | 15060000142263 | 1 | PA346218 | PM723348 |
| 15060000142271 | L15/dossiers | 15 | 15060000142270 | 15060000142270 | 1 | PA345619 | PM725692 |
| 15060000142301 | L15/dossiers | 15 | 15060000142300 | 15060000142300 | 1 | PA267318 | PM723260 |
| 15060000142322 | L15/dossiers | 15 | 15060000142321 | 15060000142321 | 1 | PA720100 | PM722860 |
| 15060000142342 | L15/dossiers | 15 | 15060000142341 | 15060000142341 | 1 | PA998 | PM723046 |
| 15060000142349 | L15/dossiers | 15 | 15060000142348 | 15060000142348 | 1 | PA998 | PM723046 |
| 15060000142356 | L15/dossiers | 15 | 15060000142355 | 15060000142355 | 1 | PA330240 | PM722492 |
| 15060000142363 | L15/dossiers | 15 | 15060000142362 | 15060000142362 | 1 | PA342935 | PM722856 |
| 15060000142370 | L15/dossiers | 15 | 15060000142369 | 15060000142369 | 1 | PA345619 | PM725692 |
| 15060000142371 | L15/dossiers | 15 | 15060000142369 | 15060000142369 | 2 | PA1872 | PM730104 |
| 15060000142403 | L15/dossiers | 15 | 15060000142402 | 15060000142402 | 1 | PA608016 | PM723024 |
| 15060000142410 | L15/dossiers | 15 | 15060000142409 | 15060000142409 | 1 | PA608016 | PM723024 |
| 15060000142417 | L15/dossiers | 15 | 15060000142416 | 15060000142416 | 1 | PA718838 | PM722474 |
| 15060000142424 | L15/dossiers | 15 | 15060000142423 | 15060000142423 | 1 | PA345619 | PM725692 |
| 15060000142425 | L15/dossiers | 15 | 15060000142423 | 15060000142423 | 2 | PA717153 | PM730062 |
| 15060000142432 | L15/dossiers | 15 | 15060000142431 | 15060000142431 | 1 | PA719616 | PM722712 |
| 15060000142439 | L15/dossiers | 15 | 15060000142438 | 15060000142438 | 1 | PA709315 | PM722526 |
| 15060000142450 | L15/dossiers | 15 | 15060000142449 | 15060000142449 | 1 | PA713448 | PM722452 |
| 15060000142457 | L15/dossiers | 15 | 15060000142456 | 15060000142456 | 1 | PA345619 | PM725692 |
| 15060000142458 | L15/dossiers | 15 | 15060000142456 | 15060000142456 | 2 | PA607846 | PM730066 |
| 15060000142477 | L15/dossiers | 15 | 15060000142476 | 15060000142476 | 1 | PA1206 | PM723354 |
| 15060000142484 | L15/dossiers | 15 | 15060000142483 | 15060000142483 | 1 | PA345619 | PM725692 |
| 15060000142522 | L15/dossiers | 15 | 15060000142521 | 15060000142521 | 1 | PA718850 | PM722478 |
| 15060000142529 | L15/dossiers | 15 | 15060000142528 | 15060000142528 | 1 | PA345619 | PM725692 |
| 15060000142530 | L15/dossiers | 15 | 15060000142528 | 15060000142528 | 2 | PA758792 | PM758794 |
| 15060000142540 | L15/dossiers | 15 | 15060000142539 | 15060000142539 | 1 | PA748954 | PM748958 |