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 |
|---|---|---|---|---|---|---|---|
| 14060000119990 | L14/dossiers | 14 | 14060000119988 | 14060000119988 | 2 | PA336175 | PM700757 |
| 14060000119999 | L14/dossiers | 14 | 14060000119998 | 14060000119998 | 1 | PA331481 | PM645136 |
| 14060000120006 | L14/dossiers | 14 | 14060000120005 | 14060000120005 | 1 | PA1828 | PM430036 |
| 14060000120007 | L14/dossiers | 14 | 14060000120005 | 14060000120005 | 2 | PA429858 | PM429958 |
| 14060000120034 | L14/dossiers | 14 | 14060000120033 | 14060000120033 | 1 | PA328 | PM653228 |
| 14060000120035 | L14/dossiers | 14 | 14060000120033 | 14060000120033 | 2 | PA1268 | PM653525 |
| 14060000120069 | L14/dossiers | 14 | 14060000120068 | 14060000120068 | 1 | PA607632 | PM645387 |
| 14060000120076 | L14/dossiers | 14 | 14060000120075 | 14060000120075 | 1 | PA610002 | PM645053 |
| 14060000120091 | L14/dossiers | 14 | 14060000120090 | 14060000120090 | 1 | PA267689 | PM645295 |
| 14060000120098 | L14/dossiers | 14 | 14060000120097 | 14060000120097 | 1 | PA785 | PM715797 |
| 14060000120105 | L14/dossiers | 14 | 14060000120104 | 14060000120104 | 1 | PA2257 | PM645201 |
| 14060000120112 | L14/dossiers | 14 | 14060000120111 | 14060000120111 | 1 | PA344492 | PM645300 |
| 14060000120129 | L14/dossiers | 14 | 14060000120128 | 14060000120128 | 1 | PA266788 | PM645294 |
| 14060000120136 | L14/dossiers | 14 | 14060000120135 | 14060000120135 | 1 | PA267762 | PM645455 |
| 14060000120143 | L14/dossiers | 14 | 14060000120142 | 14060000120142 | 1 | PA267492 | PM645465 |
| 14060000120150 | L14/dossiers | 14 | 14060000120149 | 14060000120149 | 1 | PA1142 | PM429968 |
| 14060000120162 | L14/dossiers | 14 | 14060000120161 | 14060000120161 | 1 | PA328 | PM653228 |
| 14060000120163 | L14/dossiers | 14 | 14060000120161 | 14060000120161 | 2 | PA2791 | PM653325 |
| 14060000120164 | L14/dossiers | 14 | 14060000120161 | 14060000120161 | 3 | PA2240 | PM653295 |
| 14060000120270 | L14/dossiers | 14 | 14060000120269 | 14060000120269 | 1 | PA713448 | PM713451 |
| 14060000120281 | L14/dossiers | 14 | 14060000120280 | 14060000120280 | 1 | PA2011 | PM645434 |
| 14060000120288 | L14/dossiers | 14 | 14060000120287 | 14060000120287 | 1 | PA344492 | PM645300 |
| 14060000120295 | L14/dossiers | 14 | 14060000120294 | 14060000120294 | 1 | PA2011 | PM645434 |
| 14060000120302 | L14/dossiers | 14 | 14060000120301 | 14060000120301 | 1 | PA1886 | PM645099 |
| 14060000120309 | L14/dossiers | 14 | 14060000120308 | 14060000120308 | 1 | PA266788 | PM645294 |
| 14060000120316 | L14/dossiers | 14 | 14060000120315 | 14060000120315 | 1 | PA267622 | PM702957 |
| 14060000120323 | L14/dossiers | 14 | 14060000120322 | 14060000120322 | 1 | PA1203 | PM415597 |
| 14060000120368 | L14/dossiers | 14 | 14060000120367 | 14060000120367 | 1 | PA267743 | PM645058 |
| 14060000120375 | L14/dossiers | 14 | 14060000120374 | 14060000120374 | 1 | PA998 | PM645034 |
| 14060000120382 | L14/dossiers | 14 | 14060000120381 | 14060000120381 | 1 | PA227076 | PM429906 |
| 14060000120383 | L14/dossiers | 14 | 14060000120381 | 14060000120381 | 2 | PA2774 | PM429910 |
| 14060000120425 | L14/dossiers | 14 | 14060000120424 | 14060000120424 | 1 | PA267378 | PM645266 |
| 14060000120432 | L14/dossiers | 14 | 14060000120431 | 14060000120431 | 1 | PA429857 | PM430046 |
| 14060000120445 | L14/dossiers | 14 | 14060000120444 | 14060000120444 | 1 | PA328 | PM653228 |
| 14060000120453 | L14/dossiers | 14 | 14060000120452 | 14060000120452 | 1 | PA1466 | PM645240 |
| 14060000120460 | L14/dossiers | 14 | 14060000120459 | 14060000120459 | 1 | PA1874 | PM645474 |
| 14060000120467 | L14/dossiers | 14 | 14060000120466 | 14060000120466 | 1 | PA2971 | PM645392 |
| 14060000120474 | L14/dossiers | 14 | 14060000120473 | 14060000120473 | 1 | PA333421 | PM645375 |
| 14060000120481 | L14/dossiers | 14 | 14060000120480 | 14060000120480 | 1 | PA2895 | PM645485 |
| 14060000120488 | L14/dossiers | 14 | 14060000120487 | 14060000120487 | 1 | PA2960 | PM645040 |
| 14060000120495 | L14/dossiers | 14 | 14060000120494 | 14060000120494 | 1 | PA608495 | PM645569 |
| 14060000120502 | L14/dossiers | 14 | 14060000120501 | 14060000120501 | 1 | PA608172 | PM645197 |
| 14060000120510 | L14/dossiers | 14 | 14060000120509 | 14060000120509 | 1 | PA328 | PM653228 |
| 14060000120651 | L14/dossiers | 14 | 14060000120650 | 14060000120650 | 1 | PA610654 | PM645267 |
| 14060000120658 | L14/dossiers | 14 | 14060000120657 | 14060000120657 | 1 | PA267622 | PM702957 |
| 14060000120659 | L14/dossiers | 14 | 14060000120657 | 14060000120657 | 2 | PA1268 | PM702961 |
| 14060000120688 | L14/dossiers | 14 | 14060000120687 | 14060000120687 | 1 | PA2876 | PM645355 |
| 14060000120695 | L14/dossiers | 14 | 14060000120694 | 14060000120694 | 1 | PA230 | PM645553 |
| 14060000120702 | L14/dossiers | 14 | 14060000120701 | 14060000120701 | 1 | PA328 | PM653228 |
| 14060000120732 | L14/dossiers | 14 | 14060000120731 | 14060000120731 | 1 | PA1886 | PM645099 |