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 |
|---|---|---|---|---|---|---|---|
| 14060000097080 | L14/dossiers | 14 | 14060000097079 | 14060000097079 | 1 | PA267605 | PM645189 |
| 14060000097087 | L14/dossiers | 14 | 14060000097086 | 14060000097086 | 1 | PA267622 | PM702957 |
| 14060000097122 | L14/dossiers | 14 | 14060000097121 | 14060000097121 | 1 | PA422119 | PM645183 |
| 14060000097129 | L14/dossiers | 14 | 14060000097128 | 14060000097128 | 1 | PA267576 | PM645073 |
| 14060000097143 | L14/dossiers | 14 | 14060000097142 | 14060000097142 | 1 | PA267622 | PM702957 |
| 14060000097151 | L14/dossiers | 14 | 14060000097150 | 14060000097150 | 1 | PA1874 | PM645474 |
| 14060000097158 | L14/dossiers | 14 | 14060000097157 | 14060000097157 | 1 | PA328 | PM653228 |
| 14060000097159 | L14/dossiers | 14 | 14060000097157 | 14060000097157 | 2 | PA335999 | PM653292 |
| 14060000097222 | L14/dossiers | 14 | 14060000097221 | 14060000097221 | 1 | PA609332 | PM645147 |
| 14060000097229 | L14/dossiers | 14 | 14060000097228 | 14060000097228 | 1 | PA334654 | PM645596 |
| 14060000097236 | L14/dossiers | 14 | 14060000097235 | 14060000097235 | 1 | PA267622 | PM702957 |
| 14060000097237 | L14/dossiers | 14 | 14060000097235 | 14060000097235 | 2 | PA1268 | PM702961 |
| 14060000097267 | L14/dossiers | 14 | 14060000097266 | 14060000097266 | 1 | PA2045 | PM645421 |
| 14060000097274 | L14/dossiers | 14 | 14060000097273 | 14060000097273 | 1 | PA267492 | PM645465 |
| 14060000097281 | L14/dossiers | 14 | 14060000097280 | 14060000097280 | 1 | PA266788 | PM645294 |
| 14060000097288 | L14/dossiers | 14 | 14060000097287 | 14060000097287 | 1 | PA1874 | PM645474 |
| 14060000097295 | L14/dossiers | 14 | 14060000097294 | 14060000097294 | 1 | PA2011 | PM645434 |
| 14060000097302 | L14/dossiers | 14 | 14060000097301 | 14060000097301 | 1 | PA267785 | PM645359 |
| 14060000097352 | L14/dossiers | 14 | 14060000097351 | 14060000097351 | 1 | PA1874 | PM645474 |
| 14060000097362 | L14/dossiers | 14 | 14060000097361 | 14060000097361 | 1 | PA785 | PM715797 |
| 14060000097371 | L14/dossiers | 14 | 14060000097370 | 14060000097370 | 1 | PA2792 | PM645308 |
| 14060000097378 | L14/dossiers | 14 | 14060000097377 | 14060000097377 | 1 | PA609740 | PM645319 |
| 14060000097385 | L14/dossiers | 14 | 14060000097384 | 14060000097384 | 1 | PA2086 | PM645043 |
| 14060000097392 | L14/dossiers | 14 | 14060000097391 | 14060000097391 | 1 | PA1886 | PM645099 |
| 14060000097399 | L14/dossiers | 14 | 14060000097398 | 14060000097398 | 1 | PA330240 | PM645425 |
| 14060000097406 | L14/dossiers | 14 | 14060000097405 | 14060000097405 | 1 | PA609726 | PM645311 |
| 14060000097430 | L14/dossiers | 14 | 14060000097429 | 14060000097429 | 1 | PA346886 | PM695110 |
| 14060000097437 | L14/dossiers | 14 | 14060000097436 | 14060000097436 | 1 | PA1585 | PM645094 |
| 14060000097447 | L14/dossiers | 14 | 14060000097446 | 14060000097446 | 1 | PA785 | PM715797 |
| 14060000097454 | L14/dossiers | 14 | 14060000097453 | 14060000097453 | 1 | PA2971 | PM645392 |
| 14060000097467 | L14/dossiers | 14 | 14060000097466 | 14060000097466 | 1 | PA606212 | PM645330 |
| 14060000097474 | L14/dossiers | 14 | 14060000097473 | 14060000097473 | 1 | PA605625 | PM645398 |
| 14060000097481 | L14/dossiers | 14 | 14060000097480 | 14060000097480 | 1 | PA346886 | PM695110 |
| 14060000097488 | L14/dossiers | 14 | 14060000097487 | 14060000097487 | 1 | PA328 | PM653228 |
| 14060000097489 | L14/dossiers | 14 | 14060000097487 | 14060000097487 | 2 | PA588872 | PM653304 |
| 14060000097628 | L14/dossiers | 14 | 14060000097627 | 14060000097627 | 1 | PA331582 | PM645198 |
| 14060000097635 | L14/dossiers | 14 | 14060000097634 | 14060000097634 | 1 | PA346886 | PM695110 |
| 14060000097639 | L14/dossiers | 14 | 14060000097638 | 14060000097638 | 1 | PA588 | PM645491 |
| 14060000097654 | L14/dossiers | 14 | 14060000097653 | 14060000097653 | 1 | PA1310 | PM645047 |
| 14060000097655 | L14/dossiers | 14 | 14060000097653 | 14060000097653 | 2 | PA1661 | PM645181 |
| 14060000097656 | L14/dossiers | 14 | 14060000097653 | 14060000097653 | 3 | PA696 | PM645428 |
| 14060000097657 | L14/dossiers | 14 | 14060000097653 | 14060000097653 | 4 | PA267895 | PM645199 |
| 14060000097664 | L14/dossiers | 14 | 14060000097663 | 14060000097663 | 1 | PA2011 | PM645434 |
| 14060000097671 | L14/dossiers | 14 | 14060000097670 | 14060000097670 | 1 | PA2713 | PM645148 |
| 14060000097678 | L14/dossiers | 14 | 14060000097677 | 14060000097677 | 1 | PA1699 | PM645390 |
| 14060000097685 | L14/dossiers | 14 | 14060000097684 | 14060000097684 | 1 | PA1874 | PM645474 |
| 14060000097692 | L14/dossiers | 14 | 14060000097691 | 14060000097691 | 1 | PA785 | PM715797 |
| 14060000097699 | L14/dossiers | 14 | 14060000097698 | 14060000097698 | 1 | PA2345 | PM645548 |
| 14060000097706 | L14/dossiers | 14 | 14060000097705 | 14060000097705 | 1 | PA267336 | PM645424 |
| 14060000097713 | L14/dossiers | 14 | 14060000097712 | 14060000097712 | 1 | PA346886 | PM695110 |