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 |
|---|---|---|---|---|---|---|---|
| 14060000098580 | L14/dossiers | 14 | 14060000098579 | 14060000098579 | 1 | PA267622 | PM702957 |
| 14060000098587 | L14/dossiers | 14 | 14060000098586 | 14060000098586 | 1 | PA608186 | PM645202 |
| 14060000098605 | L14/dossiers | 14 | 14060000098604 | 14060000098604 | 1 | PA1152 | PM645561 |
| 14060000098612 | L14/dossiers | 14 | 14060000098611 | 14060000098611 | 1 | PA608826 | PM645556 |
| 14060000098619 | L14/dossiers | 14 | 14060000098618 | 14060000098618 | 1 | PA605745 | PM645435 |
| 14060000098641 | L14/dossiers | 14 | 14060000098640 | 14060000098640 | 1 | PA417099 | PM645346 |
| 14060000098651 | L14/dossiers | 14 | 14060000098650 | 14060000098650 | 1 | PA267306 | PM645210 |
| 14060000098666 | L14/dossiers | 14 | 14060000098665 | 14060000098665 | 1 | PA551 | PM645487 |
| 14060000098674 | L14/dossiers | 14 | 14060000098673 | 14060000098673 | 1 | PA2086 | PM645043 |
| 14060000098681 | L14/dossiers | 14 | 14060000098680 | 14060000098680 | 1 | PA267622 | PM702957 |
| 14060000098682 | L14/dossiers | 14 | 14060000098680 | 14060000098680 | 2 | PA2679 | PM702976 |
| 14060000098683 | L14/dossiers | 14 | 14060000098680 | 14060000098680 | 3 | PA1243 | PM702966 |
| 14060000099453 | L14/dossiers | 14 | 14060000099452 | 14060000099452 | 1 | PA330684 | PM645497 |
| 14060000099466 | L14/dossiers | 14 | 14060000099465 | 14060000099465 | 1 | PA1886 | PM645099 |
| 14060000099473 | L14/dossiers | 14 | 14060000099472 | 14060000099472 | 1 | PA328 | PM653228 |
| 14060000099474 | L14/dossiers | 14 | 14060000099472 | 14060000099472 | 2 | PA588872 | PM653304 |
| 14060000099524 | L14/dossiers | 14 | 14060000099523 | 14060000099523 | 1 | PA2011 | PM645434 |
| 14060000099531 | L14/dossiers | 14 | 14060000099530 | 14060000099530 | 1 | PA608186 | PM645202 |
| 14060000099532 | L14/dossiers | 14 | 14060000099530 | 14060000099530 | 2 | PA608235 | PM645229 |
| 14060000099547 | L14/dossiers | 14 | 14060000099546 | 14060000099546 | 1 | PA608416 | PM645586 |
| 14060000099558 | L14/dossiers | 14 | 14060000099557 | 14060000099557 | 1 | PA609709 | PM645302 |
| 14060000099565 | L14/dossiers | 14 | 14060000099564 | 14060000099564 | 1 | PA785 | PM715797 |
| 14060000099566 | L14/dossiers | 14 | 14060000099564 | 14060000099564 | 2 | PA2825 | PM715812 |
| 14060000099573 | L14/dossiers | 14 | 14060000099572 | 14060000099572 | 1 | PA2011 | PM645434 |
| 14060000099580 | L14/dossiers | 14 | 14060000099579 | 14060000099579 | 1 | PA563 | PM645307 |
| 14060000099587 | L14/dossiers | 14 | 14060000099586 | 14060000099586 | 1 | PA330240 | PM645425 |
| 14060000099594 | L14/dossiers | 14 | 14060000099593 | 14060000099593 | 1 | PA267336 | PM645424 |
| 14060000099607 | L14/dossiers | 14 | 14060000099606 | 14060000099606 | 1 | PA267260 | PM645459 |
| 14060000099614 | L14/dossiers | 14 | 14060000099613 | 14060000099613 | 1 | PA651963 | PM651978 |
| 14060000099636 | L14/dossiers | 14 | 14060000099635 | 14060000099635 | 1 | PA267622 | PM702957 |
| 14060000099637 | L14/dossiers | 14 | 14060000099635 | 14060000099635 | 2 | PA2679 | PM702976 |
| 14060000099644 | L14/dossiers | 14 | 14060000099643 | 14060000099643 | 1 | PA605557 | PM645507 |
| 14060000099651 | L14/dossiers | 14 | 14060000099650 | 14060000099650 | 1 | PA2250 | PM645539 |
| 14060000099658 | L14/dossiers | 14 | 14060000099657 | 14060000099657 | 1 | PA266788 | PM645294 |
| 14060000099665 | L14/dossiers | 14 | 14060000099664 | 14060000099664 | 1 | PA2597 | PM645126 |
| 14060000099672 | L14/dossiers | 14 | 14060000099671 | 14060000099671 | 1 | PA2828 | PM645402 |
| 14060000099718 | L14/dossiers | 14 | 14060000099717 | 14060000099717 | 1 | PA1654 | PM703255 |
| 14060000099740 | L14/dossiers | 14 | 14060000099739 | 14060000099739 | 1 | PA429890 | PM543935 |
| 14060000099764 | L14/dossiers | 14 | 14060000099763 | 14060000099763 | 1 | PA267492 | PM645465 |
| 14060000099768 | L14/dossiers | 14 | 14060000099767 | 14060000099767 | 1 | PA267429 | PM645130 |
| 14060000099775 | L14/dossiers | 14 | 14060000099774 | 14060000099774 | 1 | PA328 | PM653228 |
| 14060000099776 | L14/dossiers | 14 | 14060000099774 | 14060000099774 | 2 | PA2240 | PM653295 |
| 14060000100474 | L14/dossiers | 14 | 14060000100473 | 14060000100473 | 1 | PA1931 | PM645042 |
| 14060000100481 | L14/dossiers | 14 | 14060000100480 | 14060000100480 | 1 | PA606212 | PM645330 |
| 14060000100488 | L14/dossiers | 14 | 14060000100487 | 14060000100487 | 1 | PA785 | PM715797 |
| 14060000100498 | L14/dossiers | 14 | 14060000100497 | 14060000100497 | 1 | PA415452 | PM415530 |
| 14060000100541 | L14/dossiers | 14 | 14060000100540 | 14060000100540 | 1 | PA267042 | PM645368 |
| 14060000100548 | L14/dossiers | 14 | 14060000100547 | 14060000100547 | 1 | PA2377 | PM645591 |
| 14060000100555 | L14/dossiers | 14 | 14060000100554 | 14060000100554 | 1 | PA608920 | PM645060 |
| 14060000100556 | L14/dossiers | 14 | 14060000100554 | 14060000100554 | 2 | PA336576 | PM645364 |