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 |
|---|---|---|---|---|---|---|---|
| 14060000134443 | L14/dossiers | 14 | 14060000134442 | 14060000134442 | 1 | PA346886 | PM695110 |
| 14060000134450 | L14/dossiers | 14 | 14060000134449 | 14060000134449 | 1 | PA1886 | PM645099 |
| 14060000134501 | L14/dossiers | 14 | 14060000134500 | 14060000134500 | 1 | PA267622 | PM700712 |
| 14060000134502 | L14/dossiers | 14 | 14060000134500 | 14060000134500 | 2 | PA1268 | PM700715 |
| 14060000134573 | L14/dossiers | 14 | 14060000134572 | 14060000134572 | 1 | PA608851 | PM645559 |
| 14060000134580 | L14/dossiers | 14 | 14060000134579 | 14060000134579 | 1 | PA328 | PM653228 |
| 14060000134655 | L14/dossiers | 14 | 14060000134654 | 14060000134654 | 1 | PA609764 | PM645323 |
| 14060000134662 | L14/dossiers | 14 | 14060000134661 | 14060000134661 | 1 | PA267042 | PM645368 |
| 14060000134670 | L14/dossiers | 14 | 14060000134669 | 14060000134669 | 1 | PA267457 | PM687216 |
| 14060000134677 | L14/dossiers | 14 | 14060000134676 | 14060000134676 | 1 | PA267429 | PM645130 |
| 14060000134684 | L14/dossiers | 14 | 14060000134683 | 14060000134683 | 1 | PA2690 | PM645458 |
| 14060000134694 | L14/dossiers | 14 | 14060000134693 | 14060000134693 | 1 | PA328 | PM653228 |
| 14060000134695 | L14/dossiers | 14 | 14060000134693 | 14060000134693 | 2 | PA588872 | PM653304 |
| 14060000134702 | L14/dossiers | 14 | 14060000134701 | 14060000134701 | 1 | PA687214 | PM687217 |
| 14060000134709 | L14/dossiers | 14 | 14060000134708 | 14060000134708 | 1 | PA267492 | PM645465 |
| 14060000134716 | L14/dossiers | 14 | 14060000134715 | 14060000134715 | 1 | PA266788 | PM645294 |
| 14060000134723 | L14/dossiers | 14 | 14060000134722 | 14060000134722 | 1 | PA2492 | PM645431 |
| 14060000134733 | L14/dossiers | 14 | 14060000134732 | 14060000134732 | 1 | PA785 | PM715797 |
| 14060000134748 | L14/dossiers | 14 | 14060000134747 | 14060000134747 | 1 | PA712015 | PM712024 |
| 14060000134755 | L14/dossiers | 14 | 14060000134754 | 14060000134754 | 1 | PA267355 | PM645581 |
| 14060000134762 | L14/dossiers | 14 | 14060000134761 | 14060000134761 | 1 | PA1695 | PM645157 |
| 14060000134776 | L14/dossiers | 14 | 14060000134775 | 14060000134775 | 1 | PA609764 | PM645323 |
| 14060000134783 | L14/dossiers | 14 | 14060000134782 | 14060000134782 | 1 | PA815 | PM645544 |
| 14060000134790 | L14/dossiers | 14 | 14060000134789 | 14060000134789 | 1 | PA1886 | PM645099 |
| 14060000134845 | L14/dossiers | 14 | 14060000134844 | 14060000134844 | 1 | PA610002 | PM645053 |
| 14060000134852 | L14/dossiers | 14 | 14060000134851 | 14060000134851 | 1 | PA1459 | PM645518 |
| 14060000134859 | L14/dossiers | 14 | 14060000134858 | 14060000134858 | 1 | PA707706 | PM707717 |
| 14060000134890 | L14/dossiers | 14 | 14060000134889 | 14060000134889 | 1 | PA328 | PM653228 |
| 14060000134924 | L14/dossiers | 14 | 14060000134923 | 14060000134923 | 1 | PA227094 | PM429960 |
| 14060000134964 | L14/dossiers | 14 | 14060000134963 | 14060000134963 | 1 | PA267735 | PM645237 |
| 14060000134994 | L14/dossiers | 14 | 14060000134993 | 14060000134993 | 1 | PA267622 | PM702957 |
| 14060000135001 | L14/dossiers | 14 | 14060000135000 | 14060000135000 | 1 | PA2801 | PM645576 |
| 14060000135008 | L14/dossiers | 14 | 14060000135007 | 14060000135007 | 1 | PA267622 | PM702957 |
| 14060000135009 | L14/dossiers | 14 | 14060000135007 | 14060000135007 | 2 | PA711558 | PM711571 |
| 14060000135010 | L14/dossiers | 14 | 14060000135007 | 14060000135007 | 3 | PA702993 | PM709263 |
| 14060000135011 | L14/dossiers | 14 | 14060000135007 | 14060000135007 | 4 | PA610681 | PM711583 |
| 14060000135137 | L14/dossiers | 14 | 14060000135136 | 14060000135136 | 1 | PA330788 | PM645510 |
| 14060000135144 | L14/dossiers | 14 | 14060000135143 | 14060000135143 | 1 | PA607761 | PM645482 |
| 14060000135164 | L14/dossiers | 14 | 14060000135163 | 14060000135163 | 1 | PA346886 | PM695110 |
| 14060000135171 | L14/dossiers | 14 | 14060000135170 | 14060000135170 | 1 | PA328 | PM653228 |
| 14060000135172 | L14/dossiers | 14 | 14060000135170 | 14060000135170 | 2 | PA1893 | PM653343 |
| 14060000135182 | L14/dossiers | 14 | 14060000135181 | 14060000135181 | 1 | PA267622 | PM702957 |
| 14060000135234 | L14/dossiers | 14 | 14060000135233 | 14060000135233 | 1 | PA785 | PM715797 |
| 14060000135241 | L14/dossiers | 14 | 14060000135240 | 14060000135240 | 1 | PA267622 | PM702957 |
| 14060000135248 | L14/dossiers | 14 | 14060000135247 | 14060000135247 | 1 | PA713448 | PM713451 |
| 14060000135255 | L14/dossiers | 14 | 14060000135254 | 14060000135254 | 1 | PA346 | PM645086 |
| 14060000135262 | L14/dossiers | 14 | 14060000135261 | 14060000135261 | 1 | PA328 | PM653228 |
| 14060000135263 | L14/dossiers | 14 | 14060000135261 | 14060000135261 | 2 | PA2240 | PM653295 |
| 14060000135354 | L14/dossiers | 14 | 14060000135353 | 14060000135353 | 1 | PA2083 | PM645105 |
| 14060000135364 | L14/dossiers | 14 | 14060000135363 | 14060000135363 | 1 | PA429843 | PM430013 |