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 |
|---|---|---|---|---|---|---|---|
| 16060000110935 | L16/dossiers | 16 | 16060000110934 | 16060000110934 | 1 | PA793736 | PM796503 |
| 16060000110945 | L16/dossiers | 16 | 16060000110944 | 16060000110944 | 1 | PA722344 | PM797244 |
| 16060000110953 | L16/dossiers | 16 | 16060000110952 | 16060000110952 | 1 | PA608016 | PM797100 |
| 16060000110961 | L16/dossiers | 16 | 16060000110960 | 16060000110960 | 1 | PA793964 | PM796626 |
| 16060000110972 | L16/dossiers | 16 | 16060000110971 | 16060000110971 | 1 | PA2116 | PM736339 |
| 16060000110979 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 1 | PA736233 | PM736411 |
| 16060000110980 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 2 | PA303995 | PM775745 |
| 16060000110981 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 3 | PA415499 | PM775655 |
| 16060000110982 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 4 | PA736179 | PM736420 |
| 16060000110983 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 5 | PA703506 | PM777126 |
| 16060000110984 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 6 | PA703506 | PM777126 |
| 16060000110985 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 7 | PA736215 | PM736324 |
| 16060000110986 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 8 | PA775278 | PM775564 |
| 16060000110987 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 9 | PA775266 | PM775568 |
| 16060000110988 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 10 | PA266812 | PM736265 |
| 16060000110989 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 11 | PA719408 | PM775520 |
| 16060000110990 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 12 | PA775234 | PM775536 |
| 16060000110991 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 13 | PA760322 | PM775649 |
| 16060000110992 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 14 | PA736189 | PM736363 |
| 16060000110993 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 15 | PA341381 | PM775747 |
| 16060000110994 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 16 | PA775300 | PM775600 |
| 16060000110995 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 17 | PA267512 | PM775817 |
| 16060000110996 | L16/dossiers | 16 | 16060000110978 | 16060000110978 | 18 | PA736235 | PM775795 |
| 16060000111003 | L16/dossiers | 16 | 16060000111002 | 16060000111002 | 1 | PA793940 | PM796614 |
| 16060000111082 | L16/dossiers | 16 | 16060000111081 | 16060000111081 | 1 | PA717161 | PM791583 |
| 16060000111083 | L16/dossiers | 16 | 16060000111081 | 16060000111081 | 2 | PA331481 | PM791666 |
| 16060000111084 | L16/dossiers | 16 | 16060000111081 | 16060000111081 | 3 | PA801862 | PM801948 |
| 16060000111118 | L16/dossiers | 16 | 16060000111117 | 16060000111117 | 1 | PA717161 | PM791583 |
| 16060000111119 | L16/dossiers | 16 | 16060000111117 | 16060000111117 | 2 | PA331481 | PM791666 |
| 16060000111120 | L16/dossiers | 16 | 16060000111117 | 16060000111117 | 3 | PA330357 | PM791696 |
| 16060000111190 | L16/dossiers | 16 | 16060000111189 | 16060000111189 | 1 | PA775236 | PM775542 |
| 16060000111200 | L16/dossiers | 16 | 16060000111199 | 16060000111199 | 1 | PA608416 | PM797133 |
| 16060000111204 | L16/dossiers | 16 | 16060000111203 | 16060000111203 | 1 | PA720630 | PM797094 |
| 16060000111211 | L16/dossiers | 16 | 16060000111210 | 16060000111210 | 1 | PA796118 | PM797859 |
| 16060000111218 | L16/dossiers | 16 | 16060000111217 | 16060000111217 | 1 | PA722110 | PM797853 |
| 16060000111219 | L16/dossiers | 16 | 16060000111217 | 16060000111217 | 2 | PA267306 | PM797073 |
| 16060000111226 | L16/dossiers | 16 | 16060000111225 | 16060000111225 | 1 | PA267429 | PM796722 |
| 16060000111239 | L16/dossiers | 16 | 16060000111238 | 16060000111238 | 1 | PA606098 | PM796449 |
| 16060000111240 | L16/dossiers | 16 | 16060000111238 | 16060000111238 | 2 | PA330240 | PM796155 |
| 16060000111241 | L16/dossiers | 16 | 16060000111238 | 16060000111238 | 3 | PA605991 | PM796428 |
| 16060000111249 | L16/dossiers | 16 | 16060000111248 | 16060000111248 | 1 | PA2538 | PM775801 |
| 16060000111250 | L16/dossiers | 16 | 16060000111248 | 16060000111248 | 2 | PA303997 | PM775743 |
| 16060000111263 | L16/dossiers | 16 | 16060000111262 | 16060000111262 | 1 | PA736244 | PM736333 |
| 16060000111270 | L16/dossiers | 16 | 16060000111269 | 16060000111269 | 1 | PA267241 | PM778080 |
| 16060000111277 | L16/dossiers | 16 | 16060000111276 | 16060000111276 | 1 | PA2116 | PM736339 |
| 16060000111284 | L16/dossiers | 16 | 16060000111283 | 16060000111283 | 1 | PA303997 | PM775743 |
| 16060000111285 | L16/dossiers | 16 | 16060000111283 | 16060000111283 | 2 | PA266795 | PM775711 |
| 16060000111286 | L16/dossiers | 16 | 16060000111283 | 16060000111283 | 3 | PA267340 | PM775731 |
| 16060000111287 | L16/dossiers | 16 | 16060000111283 | 16060000111283 | 4 | PA736190 | PM736255 |
| 16060000111288 | L16/dossiers | 16 | 16060000111283 | 16060000111283 | 5 | PA2538 | PM775801 |