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 |
|---|---|---|---|---|---|---|---|
| 15060000135911 | L15/dossiers | 15 | 15060000135910 | 15060000135910 | 1 | PA605036 | PM722444 |
| 15060000135918 | L15/dossiers | 15 | 15060000135917 | 15060000135917 | 1 | PA719946 | PM722808 |
| 15060000135925 | L15/dossiers | 15 | 15060000135924 | 15060000135924 | 1 | PA719146 | PM722576 |
| 15060000135932 | L15/dossiers | 15 | 15060000135931 | 15060000135931 | 1 | PA718838 | PM722474 |
| 15060000135942 | L15/dossiers | 15 | 15060000135941 | 15060000135941 | 1 | PA345619 | PM725692 |
| 15060000135943 | L15/dossiers | 15 | 15060000135941 | 15060000135941 | 2 | PA1872 | PM730104 |
| 15060000135978 | L15/dossiers | 15 | 15060000135977 | 15060000135977 | 1 | PA345619 | PM725692 |
| 15060000136017 | L15/dossiers | 15 | 15060000136016 | 15060000136016 | 1 | PA267355 | PM723524 |
| 15060000136024 | L15/dossiers | 15 | 15060000136023 | 15060000136023 | 1 | PA345619 | PM725692 |
| 15060000136025 | L15/dossiers | 15 | 15060000136023 | 15060000136023 | 2 | PA607395 | PM730076 |
| 15060000136170 | L15/dossiers | 15 | 15060000136169 | 15060000136169 | 1 | PA609520 | PM723508 |
| 15060000136190 | L15/dossiers | 15 | 15060000136189 | 15060000136189 | 1 | PA605036 | PM722444 |
| 15060000136197 | L15/dossiers | 15 | 15060000136196 | 15060000136196 | 1 | PA721506 | PM723296 |
| 15060000136204 | L15/dossiers | 15 | 15060000136203 | 15060000136203 | 1 | PA345722 | PM723428 |
| 15060000136221 | L15/dossiers | 15 | 15060000136220 | 15060000136220 | 1 | PA721174 | PM723194 |
| 15060000136243 | L15/dossiers | 15 | 15060000136242 | 15060000136242 | 1 | PA642847 | PM722954 |
| 15060000136250 | L15/dossiers | 15 | 15060000136249 | 15060000136249 | 1 | PA605036 | PM722444 |
| 15060000136257 | L15/dossiers | 15 | 15060000136256 | 15060000136256 | 1 | PA608016 | PM723024 |
| 15060000136264 | L15/dossiers | 15 | 15060000136263 | 15060000136263 | 1 | PA266776 | PM723542 |
| 15060000136271 | L15/dossiers | 15 | 15060000136270 | 15060000136270 | 1 | PA609726 | PM723426 |
| 15060000136291 | L15/dossiers | 15 | 15060000136290 | 15060000136290 | 1 | PA1206 | PM723354 |
| 15060000136298 | L15/dossiers | 15 | 15060000136297 | 15060000136297 | 1 | PA1874 | PM722598 |
| 15060000136305 | L15/dossiers | 15 | 15060000136304 | 15060000136304 | 1 | PA429895 | PM736262 |
| 15060000136324 | L15/dossiers | 15 | 15060000136323 | 15060000136323 | 1 | PA415464 | PM703627 |
| 15060000136336 | L15/dossiers | 15 | 15060000136335 | 15060000136335 | 1 | PA605036 | PM722444 |
| 15060000136346 | L15/dossiers | 15 | 15060000136345 | 15060000136345 | 1 | PA718838 | PM722474 |
| 15060000136353 | L15/dossiers | 15 | 15060000136352 | 15060000136352 | 1 | PA720178 | PM722882 |
| 15060000136371 | L15/dossiers | 15 | 15060000136370 | 15060000136370 | 1 | PA721372 | PM723252 |
| 15060000136389 | L15/dossiers | 15 | 15060000136388 | 15060000136388 | 1 | PA345619 | PM725692 |
| 15060000136390 | L15/dossiers | 15 | 15060000136388 | 15060000136388 | 2 | PA205600 | PM730080 |
| 15060000136483 | L15/dossiers | 15 | 15060000136482 | 15060000136482 | 1 | PA721046 | PM723154 |
| 15060000136490 | L15/dossiers | 15 | 15060000136489 | 15060000136489 | 1 | PA266795 | PM703637 |
| 15060000136525 | L15/dossiers | 15 | 15060000136524 | 15060000136524 | 1 | PA608016 | PM723024 |
| 15060000136532 | L15/dossiers | 15 | 15060000136531 | 15060000136531 | 1 | PA703513 | PM703621 |
| 15060000136551 | L15/dossiers | 15 | 15060000136550 | 15060000136550 | 1 | PA346218 | PM723348 |
| 15060000136558 | L15/dossiers | 15 | 15060000136557 | 15060000136557 | 1 | PA718850 | PM722478 |
| 15060000136581 | L15/dossiers | 15 | 15060000136580 | 15060000136580 | 1 | PA720846 | PM723094 |
| 15060000136588 | L15/dossiers | 15 | 15060000136587 | 15060000136587 | 1 | PA720644 | PM723026 |
| 15060000136595 | L15/dossiers | 15 | 15060000136594 | 15060000136594 | 1 | PA720798 | PM723080 |
| 15060000136602 | L15/dossiers | 15 | 15060000136601 | 15060000136601 | 1 | PA268019 | PM723092 |
| 15060000136612 | L15/dossiers | 15 | 15060000136611 | 15060000136611 | 1 | PA345619 | PM725692 |
| 15060000136613 | L15/dossiers | 15 | 15060000136611 | 15060000136611 | 2 | PA331481 | PM730094 |
| 15060000136622 | L15/dossiers | 15 | 15060000136621 | 15060000136621 | 1 | PA608016 | PM723024 |
| 15060000136637 | L15/dossiers | 15 | 15060000136636 | 15060000136636 | 1 | PA267318 | PM723260 |
| 15060000136644 | L15/dossiers | 15 | 15060000136643 | 15060000136643 | 1 | PA267042 | PM722910 |
| 15060000136651 | L15/dossiers | 15 | 15060000136650 | 15060000136650 | 1 | PA608016 | PM723024 |
| 15060000136658 | L15/dossiers | 15 | 15060000136657 | 15060000136657 | 1 | PA608416 | PM723540 |
| 15060000136665 | L15/dossiers | 15 | 15060000136664 | 15060000136664 | 1 | PA712015 | PM722448 |
| 15060000136675 | L15/dossiers | 15 | 15060000136674 | 15060000136674 | 1 | PA267429 | PM722818 |
| 15060000136688 | L15/dossiers | 15 | 15060000136687 | 15060000136687 | 1 | PA331582 | PM722646 |