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 |
|---|---|---|---|---|---|---|---|
| 16060000104928 | L16/dossiers | 16 | 16060000104927 | 16060000104927 | 1 | PA722202 | PM797358 |
| 16060000104935 | L16/dossiers | 16 | 16060000104934 | 16060000104934 | 1 | PA717161 | PM791583 |
| 16060000104936 | L16/dossiers | 16 | 16060000104934 | 16060000104934 | 2 | PA331481 | PM791666 |
| 16060000104937 | L16/dossiers | 16 | 16060000104934 | 16060000104934 | 3 | PA429846 | PM801952 |
| 16060000104948 | L16/dossiers | 16 | 16060000104947 | 16060000104947 | 1 | PA722046 | PM797625 |
| 16060000104966 | L16/dossiers | 16 | 16060000104965 | 16060000104965 | 1 | PA718884 | PM796218 |
| 16060000104973 | L16/dossiers | 16 | 16060000104972 | 16060000104972 | 1 | PA719318 | PM796470 |
| 16060000104980 | L16/dossiers | 16 | 16060000104979 | 16060000104979 | 1 | PA415446 | PM775783 |
| 16060000104981 | L16/dossiers | 16 | 16060000104979 | 16060000104979 | 2 | PA266795 | PM775711 |
| 16060000105000 | L16/dossiers | 16 | 16060000104999 | 16060000104999 | 1 | PA304021 | PM736299 |
| 16060000105011 | L16/dossiers | 16 | 16060000105010 | 16060000105010 | 1 | PA793342 | PM796269 |
| 16060000105018 | L16/dossiers | 16 | 16060000105017 | 16060000105017 | 1 | PA794410 | PM796911 |
| 16060000105025 | L16/dossiers | 16 | 16060000105024 | 16060000105024 | 1 | PA722202 | PM797358 |
| 16060000105032 | L16/dossiers | 16 | 16060000105031 | 16060000105031 | 1 | PA793134 | PM796167 |
| 16060000105039 | L16/dossiers | 16 | 16060000105038 | 16060000105038 | 1 | PA717161 | PM791583 |
| 16060000105040 | L16/dossiers | 16 | 16060000105038 | 16060000105038 | 2 | PA331481 | PM791666 |
| 16060000105041 | L16/dossiers | 16 | 16060000105038 | 16060000105038 | 3 | PA330357 | PM791696 |
| 16060000105042 | L16/dossiers | 16 | 16060000105038 | 16060000105038 | 4 | PA801862 | PM801948 |
| 16060000105043 | L16/dossiers | 16 | 16060000105038 | 16060000105038 | 5 | PA722190 | PM791668 |
| 16060000105147 | L16/dossiers | 16 | 16060000105146 | 16060000105146 | 1 | PA712015 | PM796176 |
| 16060000105154 | L16/dossiers | 16 | 16060000105153 | 16060000105153 | 1 | PA266788 | PM796788 |
| 16060000105161 | L16/dossiers | 16 | 16060000105160 | 16060000105160 | 1 | PA722398 | PM797217 |
| 16060000105168 | L16/dossiers | 16 | 16060000105167 | 16060000105167 | 1 | PA795844 | PM797709 |
| 16060000105175 | L16/dossiers | 16 | 16060000105174 | 16060000105174 | 1 | PA205280 | PM736412 |
| 16060000105182 | L16/dossiers | 16 | 16060000105181 | 16060000105181 | 1 | PA736207 | PM736391 |
| 16060000105189 | L16/dossiers | 16 | 16060000105188 | 16060000105188 | 1 | PA722150 | PM797445 |
| 16060000105234 | L16/dossiers | 16 | 16060000105233 | 16060000105233 | 1 | PA793394 | PM796299 |
| 16060000105291 | L16/dossiers | 16 | 16060000105290 | 16060000105290 | 1 | PA793452 | PM796332 |
| 16060000105298 | L16/dossiers | 16 | 16060000105297 | 16060000105297 | 1 | PA267766 | PM796980 |
| 16060000105305 | L16/dossiers | 16 | 16060000105304 | 16060000105304 | 1 | PA793322 | PM796260 |
| 16060000105312 | L16/dossiers | 16 | 16060000105311 | 16060000105311 | 1 | PA719874 | PM796674 |
| 16060000105319 | L16/dossiers | 16 | 16060000105318 | 16060000105318 | 1 | PA1327 | PM796632 |
| 16060000105335 | L16/dossiers | 16 | 16060000105334 | 16060000105334 | 1 | PA796010 | PM797802 |
| 16060000105342 | L16/dossiers | 16 | 16060000105341 | 16060000105341 | 1 | PA2116 | PM736339 |
| 16060000105353 | L16/dossiers | 16 | 16060000105352 | 16060000105352 | 1 | PA721024 | PM797592 |
| 16060000105361 | L16/dossiers | 16 | 16060000105360 | 16060000105360 | 1 | PA793194 | PM796200 |
| 16060000105368 | L16/dossiers | 16 | 16060000105367 | 16060000105367 | 1 | PA719404 | PM796539 |
| 16060000105414 | L16/dossiers | 16 | 16060000105413 | 16060000105413 | 1 | PA718926 | PM796326 |
| 16060000105421 | L16/dossiers | 16 | 16060000105420 | 16060000105420 | 1 | PA720386 | PM796908 |
| 16060000105428 | L16/dossiers | 16 | 16060000105427 | 16060000105427 | 1 | PA793322 | PM796260 |
| 16060000105435 | L16/dossiers | 16 | 16060000105434 | 16060000105434 | 1 | PA267429 | PM796722 |
| 16060000105442 | L16/dossiers | 16 | 16060000105441 | 16060000105441 | 1 | PA2116 | PM736339 |
| 16060000105449 | L16/dossiers | 16 | 16060000105448 | 16060000105448 | 1 | PA736228 | PM736380 |
| 16060000105456 | L16/dossiers | 16 | 16060000105455 | 16060000105455 | 1 | PA794118 | PM796725 |
| 16060000105463 | L16/dossiers | 16 | 16060000105462 | 16060000105462 | 1 | PA720846 | PM797328 |
| 16060000105470 | L16/dossiers | 16 | 16060000105469 | 16060000105469 | 1 | PA643134 | PM796758 |
| 16060000105478 | L16/dossiers | 16 | 16060000105477 | 16060000105477 | 1 | PA794562 | PM796995 |
| 16060000105485 | L16/dossiers | 16 | 16060000105484 | 16060000105484 | 1 | PA720696 | PM796989 |
| 16060000105499 | L16/dossiers | 16 | 16060000105498 | 16060000105498 | 1 | PA793322 | PM796260 |
| 16060000105506 | L16/dossiers | 16 | 16060000105505 | 16060000105505 | 1 | PA793122 | PM796161 |