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 |
|---|---|---|---|---|---|---|---|
| 15060000146077 | L15/dossiers | 15 | 15060000146076 | 15060000146076 | 1 | PA304002 | PM736326 |
| 15060000146133 | L15/dossiers | 15 | 15060000146132 | 15060000146132 | 1 | PA2150 | PM722506 |
| 15060000146150 | L15/dossiers | 15 | 15060000146149 | 15060000146149 | 1 | PA713448 | PM722452 |
| 15060000146157 | L15/dossiers | 15 | 15060000146156 | 15060000146156 | 1 | PA718850 | PM722478 |
| 15060000146164 | L15/dossiers | 15 | 15060000146163 | 15060000146163 | 1 | PA722202 | PM723502 |
| 15060000146176 | L15/dossiers | 15 | 15060000146175 | 15060000146175 | 1 | PA345619 | PM725692 |
| 15060000146177 | L15/dossiers | 15 | 15060000146175 | 15060000146175 | 2 | PA1872 | PM730104 |
| 15060000146207 | L15/dossiers | 15 | 15060000146206 | 15060000146206 | 1 | PA345619 | PM725692 |
| 15060000146208 | L15/dossiers | 15 | 15060000146206 | 15060000146206 | 2 | PA1872 | PM730104 |
| 15060000146239 | L15/dossiers | 15 | 15060000146238 | 15060000146238 | 1 | PA721932 | PM734586 |
| 15060000146243 | L15/dossiers | 15 | 15060000146242 | 15060000146242 | 1 | PA2377 | PM723550 |
| 15060000146250 | L15/dossiers | 15 | 15060000146249 | 15060000146249 | 1 | PA719420 | PM722656 |
| 15060000146257 | L15/dossiers | 15 | 15060000146256 | 15060000146256 | 1 | PA267794 | PM722468 |
| 15060000146264 | L15/dossiers | 15 | 15060000146263 | 15060000146263 | 1 | PA1327 | PM722762 |
| 15060000146271 | L15/dossiers | 15 | 15060000146270 | 15060000146270 | 1 | PA643089 | PM758076 |
| 15060000146278 | L15/dossiers | 15 | 15060000146277 | 15060000146277 | 1 | PA720692 | PM723042 |
| 15060000146285 | L15/dossiers | 15 | 15060000146284 | 15060000146284 | 1 | PA267318 | PM723260 |
| 15060000146292 | L15/dossiers | 15 | 15060000146291 | 15060000146291 | 1 | PA266788 | PM722914 |
| 15060000146299 | L15/dossiers | 15 | 15060000146298 | 15060000146298 | 1 | PA718784 | PM722456 |
| 15060000146306 | L15/dossiers | 15 | 15060000146305 | 15060000146305 | 1 | PA1206 | PM723354 |
| 15060000146313 | L15/dossiers | 15 | 15060000146312 | 15060000146312 | 1 | PA334149 | PM723034 |
| 15060000146317 | L15/dossiers | 15 | 15060000146316 | 15060000146316 | 1 | PA334149 | PM723034 |
| 15060000146321 | L15/dossiers | 15 | 15060000146320 | 15060000146320 | 1 | PA334149 | PM723034 |
| 15060000146328 | L15/dossiers | 15 | 15060000146327 | 15060000146327 | 1 | PA346218 | PM723348 |
| 15060000146335 | L15/dossiers | 15 | 15060000146334 | 15060000146334 | 1 | PA267306 | PM723054 |
| 15060000146345 | L15/dossiers | 15 | 15060000146344 | 15060000146344 | 1 | PA720846 | PM723094 |
| 15060000146352 | L15/dossiers | 15 | 15060000146351 | 15060000146351 | 1 | PA643134 | PM722824 |
| 15060000146359 | L15/dossiers | 15 | 15060000146358 | 15060000146358 | 1 | PA720430 | PM722962 |
| 15060000146366 | L15/dossiers | 15 | 15060000146365 | 15060000146365 | 1 | PA266788 | PM722914 |
| 15060000146373 | L15/dossiers | 15 | 15060000146372 | 15060000146372 | 1 | PA722110 | PM723474 |
| 15060000146380 | L15/dossiers | 15 | 15060000146379 | 15060000146379 | 1 | PA334149 | PM723034 |
| 15060000146387 | L15/dossiers | 15 | 15060000146386 | 15060000146386 | 1 | PA719318 | PM722624 |
| 15060000146394 | L15/dossiers | 15 | 15060000146393 | 15060000146393 | 1 | PA340853 | PM722534 |
| 15060000146401 | L15/dossiers | 15 | 15060000146400 | 15060000146400 | 1 | PA721210 | PM723204 |
| 15060000146408 | L15/dossiers | 15 | 15060000146407 | 15060000146407 | 1 | PA643089 | PM758076 |
| 15060000146415 | L15/dossiers | 15 | 15060000146414 | 15060000146414 | 1 | PA721210 | PM723204 |
| 15060000146426 | L15/dossiers | 15 | 15060000146425 | 15060000146425 | 1 | PA721226 | PM723208 |
| 15060000146436 | L15/dossiers | 15 | 15060000146435 | 15060000146435 | 1 | PA721888 | PM723412 |
| 15060000146443 | L15/dossiers | 15 | 15060000146442 | 15060000146442 | 1 | PA721270 | PM723220 |
| 15060000146462 | L15/dossiers | 15 | 15060000146461 | 15060000146461 | 1 | PA721896 | PM723414 |
| 15060000146485 | L15/dossiers | 15 | 15060000146484 | 15060000146484 | 1 | PA713448 | PM722452 |
| 15060000146492 | L15/dossiers | 15 | 15060000146491 | 15060000146491 | 1 | PA718720 | PM722436 |
| 15060000146508 | L15/dossiers | 15 | 15060000146507 | 15060000146507 | 1 | PA608016 | PM723024 |
| 15060000146515 | L15/dossiers | 15 | 15060000146514 | 15060000146514 | 1 | PA709315 | PM722526 |
| 15060000146522 | L15/dossiers | 15 | 15060000146521 | 15060000146521 | 1 | PA342935 | PM722856 |
| 15060000146559 | L15/dossiers | 15 | 15060000146558 | 15060000146558 | 1 | PA223837 | PM722458 |
| 15060000146566 | L15/dossiers | 15 | 15060000146565 | 15060000146565 | 1 | PA718838 | PM722474 |
| 15060000146573 | L15/dossiers | 15 | 15060000146572 | 15060000146572 | 1 | PA718838 | PM722474 |
| 15060000146584 | L15/dossiers | 15 | 15060000146583 | 15060000146583 | 1 | PA718838 | PM722474 |
| 15060000146591 | L15/dossiers | 15 | 15060000146590 | 15060000146590 | 1 | PA1206 | PM723354 |