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 |
|---|---|---|---|---|---|---|---|
| 15060000164008 | L15/dossiers | 15 | 15060000164007 | 15060000164007 | 1 | PA334149 | PM723034 |
| 15060000164015 | L15/dossiers | 15 | 15060000164014 | 15060000164014 | 1 | PA642847 | PM722954 |
| 15060000164022 | L15/dossiers | 15 | 15060000164021 | 15060000164021 | 1 | PA643089 | PM758076 |
| 15060000164029 | L15/dossiers | 15 | 15060000164028 | 15060000164028 | 1 | PA608416 | PM723540 |
| 15060000164033 | L15/dossiers | 15 | 15060000164032 | 15060000164032 | 1 | PA334149 | PM723034 |
| 15060000164040 | L15/dossiers | 15 | 15060000164039 | 15060000164039 | 1 | PA720386 | PM722948 |
| 15060000164047 | L15/dossiers | 15 | 15060000164046 | 15060000164046 | 1 | PA345619 | PM725692 |
| 15060000164054 | L15/dossiers | 15 | 15060000164053 | 15060000164053 | 1 | PA345619 | PM725692 |
| 15060000164061 | L15/dossiers | 15 | 15060000164060 | 15060000164060 | 1 | PA345619 | PM725692 |
| 15060000164068 | L15/dossiers | 15 | 15060000164067 | 15060000164067 | 1 | PA345619 | PM725692 |
| 15060000164075 | L15/dossiers | 15 | 15060000164074 | 15060000164074 | 1 | PA345619 | PM725692 |
| 15060000164082 | L15/dossiers | 15 | 15060000164081 | 15060000164081 | 1 | PA719946 | PM722808 |
| 15060000164089 | L15/dossiers | 15 | 15060000164088 | 15060000164088 | 1 | PA266788 | PM722914 |
| 15060000164096 | L15/dossiers | 15 | 15060000164095 | 15060000164095 | 1 | PA719946 | PM722808 |
| 15060000164112 | L15/dossiers | 15 | 15060000164111 | 15060000164111 | 1 | PA719272 | PM722612 |
| 15060000164119 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 1 | PA702993 | PM736362 |
| 15060000164120 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 2 | PA429867 | PM736298 |
| 15060000164121 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 3 | PA703505 | PM703626 |
| 15060000164122 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 4 | PA341272 | PM703643 |
| 15060000164123 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 5 | PA733 | PM703709 |
| 15060000164124 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 6 | PA429833 | PM736271 |
| 15060000164125 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 7 | PA736191 | PM736336 |
| 15060000164126 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 8 | PA736181 | PM736416 |
| 15060000164127 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 9 | PA703533 | PM703593 |
| 15060000164128 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 10 | PA268048 | PM736422 |
| 15060000164129 | L15/dossiers | 15 | 15060000164118 | 15060000164118 | 11 | PA736201 | PM736347 |
| 15060000164136 | L15/dossiers | 15 | 15060000164135 | 15060000164135 | 1 | PA719778 | PM722760 |
| 15060000164144 | L15/dossiers | 15 | 15060000164143 | 15060000164143 | 1 | PA719436 | PM770316 |
| 15060000164151 | L15/dossiers | 15 | 15060000164150 | 15060000164150 | 1 | PA266788 | PM722914 |
| 15060000164158 | L15/dossiers | 15 | 15060000164157 | 15060000164157 | 1 | PA719024 | PM722536 |
| 15060000164208 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 1 | PA703508 | PM703601 |
| 15060000164209 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 2 | PA702993 | PM736362 |
| 15060000164210 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 3 | PA703490 | PM703631 |
| 15060000164211 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 4 | PA736219 | PM736387 |
| 15060000164212 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 5 | PA341406 | PM703619 |
| 15060000164213 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 6 | PA736234 | PM736424 |
| 15060000164214 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 7 | PA944 | PM703562 |
| 15060000164215 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 8 | PA415471 | PM703663 |
| 15060000164216 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 9 | PA340419 | PM703553 |
| 15060000164217 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 10 | PA643211 | PM703707 |
| 15060000164218 | L15/dossiers | 15 | 15060000164207 | 15060000164207 | 11 | PA736217 | PM736384 |
| 15060000164225 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 1 | PA736219 | PM736387 |
| 15060000164226 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 2 | PA702993 | PM736362 |
| 15060000164227 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 3 | PA703490 | PM703631 |
| 15060000164228 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 4 | PA341406 | PM703619 |
| 15060000164229 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 5 | PA736234 | PM736424 |
| 15060000164230 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 6 | PA944 | PM703562 |
| 15060000164231 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 7 | PA415471 | PM703663 |
| 15060000164232 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 8 | PA340419 | PM703553 |
| 15060000164233 | L15/dossiers | 15 | 15060000164224 | 15060000164224 | 9 | PA703508 | PM703601 |