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 |
|---|---|---|---|---|---|---|---|
| 14060000127257 | L14/dossiers | 14 | 14060000127256 | 14060000127256 | 1 | PA328 | PM653228 |
| 14060000127264 | L14/dossiers | 14 | 14060000127263 | 14060000127263 | 1 | PA267429 | PM645130 |
| 14060000127274 | L14/dossiers | 14 | 14060000127273 | 14060000127273 | 1 | PA331582 | PM645198 |
| 14060000127281 | L14/dossiers | 14 | 14060000127280 | 14060000127280 | 1 | PA267622 | PM702957 |
| 14060000127282 | L14/dossiers | 14 | 14060000127280 | 14060000127280 | 2 | PA785 | PM702979 |
| 14060000127290 | L14/dossiers | 14 | 14060000127289 | 14060000127289 | 1 | PA2664 | PM645139 |
| 14060000127297 | L14/dossiers | 14 | 14060000127296 | 14060000127296 | 1 | PA785 | PM715797 |
| 14060000127310 | L14/dossiers | 14 | 14060000127309 | 14060000127309 | 1 | PA328 | PM653228 |
| 14060000127340 | L14/dossiers | 14 | 14060000127339 | 14060000127339 | 1 | PA267622 | PM702957 |
| 14060000127347 | L14/dossiers | 14 | 14060000127346 | 14060000127346 | 1 | PA267605 | PM645189 |
| 14060000127355 | L14/dossiers | 14 | 14060000127354 | 14060000127354 | 1 | PA606149 | PM645218 |
| 14060000127356 | L14/dossiers | 14 | 14060000127354 | 14060000127354 | 2 | PA267469 | PM645314 |
| 14060000127375 | L14/dossiers | 14 | 14060000127374 | 14060000127374 | 1 | PA1886 | PM645099 |
| 14060000127376 | L14/dossiers | 14 | 14060000127374 | 14060000127374 | 2 | PA607761 | PM645482 |
| 14060000127384 | L14/dossiers | 14 | 14060000127383 | 14060000127383 | 1 | PA1579 | PM645117 |
| 14060000127392 | L14/dossiers | 14 | 14060000127391 | 14060000127391 | 1 | PA785 | PM715797 |
| 14060000127401 | L14/dossiers | 14 | 14060000127400 | 14060000127400 | 1 | PA1203 | PM703571 |
| 14060000127432 | L14/dossiers | 14 | 14060000127431 | 14060000127431 | 1 | PA330684 | PM645497 |
| 14060000127451 | L14/dossiers | 14 | 14060000127450 | 14060000127450 | 1 | PA2098 | PM645351 |
| 14060000127461 | L14/dossiers | 14 | 14060000127460 | 14060000127460 | 1 | PA906 | PM303911 |
| 14060000127485 | L14/dossiers | 14 | 14060000127484 | 14060000127484 | 1 | PA2098 | PM645351 |
| 14060000127492 | L14/dossiers | 14 | 14060000127491 | 14060000127491 | 1 | PA328 | PM653228 |
| 14060000127493 | L14/dossiers | 14 | 14060000127491 | 14060000127491 | 2 | PA1268 | PM653525 |
| 14060000127523 | L14/dossiers | 14 | 14060000127522 | 14060000127522 | 1 | PA330240 | PM645425 |
| 14060000127530 | L14/dossiers | 14 | 14060000127529 | 14060000127529 | 1 | PA267785 | PM645359 |
| 14060000127537 | L14/dossiers | 14 | 14060000127536 | 14060000127536 | 1 | PA605349 | PM645483 |
| 14060000127544 | L14/dossiers | 14 | 14060000127543 | 14060000127543 | 1 | PA267622 | PM702957 |
| 14060000127545 | L14/dossiers | 14 | 14060000127543 | 14060000127543 | 2 | PA335532 | PM702985 |
| 14060000127546 | L14/dossiers | 14 | 14060000127543 | 14060000127543 | 3 | PA610681 | PM711583 |
| 14060000127645 | L14/dossiers | 14 | 14060000127644 | 14060000127644 | 1 | PA267622 | PM702957 |
| 14060000127652 | L14/dossiers | 14 | 14060000127651 | 14060000127651 | 1 | PA267673 | PM645249 |
| 14060000127662 | L14/dossiers | 14 | 14060000127661 | 14060000127661 | 1 | PA267622 | PM702957 |
| 14060000127672 | L14/dossiers | 14 | 14060000127671 | 14060000127671 | 1 | PA609764 | PM645323 |
| 14060000127679 | L14/dossiers | 14 | 14060000127678 | 14060000127678 | 1 | PA266774 | PM645583 |
| 14060000127689 | L14/dossiers | 14 | 14060000127688 | 14060000127688 | 1 | PA1886 | PM645099 |
| 14060000127721 | L14/dossiers | 14 | 14060000127720 | 14060000127720 | 1 | PA309643 | PM645326 |
| 14060000127728 | L14/dossiers | 14 | 14060000127727 | 14060000127727 | 1 | PA1886 | PM645099 |
| 14060000127821 | L14/dossiers | 14 | 14060000127820 | 14060000127820 | 1 | PA346886 | PM695110 |
| 14060000127828 | L14/dossiers | 14 | 14060000127827 | 14060000127827 | 1 | PA610924 | PM645227 |
| 14060000127838 | L14/dossiers | 14 | 14060000127837 | 14060000127837 | 1 | PA610521 | PM645190 |
| 14060000127845 | L14/dossiers | 14 | 14060000127844 | 14060000127844 | 1 | PA415482 | PM415579 |
| 14060000127861 | L14/dossiers | 14 | 14060000127860 | 14060000127860 | 1 | PA2250 | PM645539 |
| 14060000127868 | L14/dossiers | 14 | 14060000127867 | 14060000127867 | 1 | PA328 | PM653228 |
| 14060000127869 | L14/dossiers | 14 | 14060000127867 | 14060000127867 | 2 | PA1268 | PM653525 |
| 14060000127910 | L14/dossiers | 14 | 14060000127909 | 14060000127909 | 1 | PA267622 | PM700712 |
| 14060000127911 | L14/dossiers | 14 | 14060000127909 | 14060000127909 | 2 | PA2679 | PM700726 |
| 14060000127921 | L14/dossiers | 14 | 14060000127920 | 14060000127920 | 1 | PA267358 | PM645602 |
| 14060000127928 | L14/dossiers | 14 | 14060000127927 | 14060000127927 | 1 | PA689 | PM645113 |
| 14060000127935 | L14/dossiers | 14 | 14060000127934 | 14060000127934 | 1 | PA267622 | PM702957 |
| 14060000127936 | L14/dossiers | 14 | 14060000127934 | 14060000127934 | 2 | PA328 | PM711554 |