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 |
|---|---|---|---|---|---|---|---|
| 14060000115874 | L14/dossiers | 14 | 14060000115873 | 14060000115873 | 1 | PA1459 | PM645518 |
| 14060000115881 | L14/dossiers | 14 | 14060000115880 | 14060000115880 | 1 | PA606212 | PM645330 |
| 14060000115888 | L14/dossiers | 14 | 14060000115887 | 14060000115887 | 1 | PA328 | PM653228 |
| 14060000115889 | L14/dossiers | 14 | 14060000115887 | 14060000115887 | 2 | PA1268 | PM653525 |
| 14060000115890 | L14/dossiers | 14 | 14060000115887 | 14060000115887 | 3 | PA590035 | PM653285 |
| 14060000115963 | L14/dossiers | 14 | 14060000115962 | 14060000115962 | 1 | PA429891 | PM430051 |
| 14060000115976 | L14/dossiers | 14 | 14060000115975 | 14060000115975 | 1 | PA608186 | PM645202 |
| 14060000115991 | L14/dossiers | 14 | 14060000115990 | 14060000115990 | 1 | PA2011 | PM645434 |
| 14060000115998 | L14/dossiers | 14 | 14060000115997 | 14060000115997 | 1 | PA328 | PM653228 |
| 14060000116030 | L14/dossiers | 14 | 14060000116029 | 14060000116029 | 1 | PA267622 | PM702957 |
| 14060000116037 | L14/dossiers | 14 | 14060000116036 | 14060000116036 | 1 | PA606212 | PM645330 |
| 14060000116047 | L14/dossiers | 14 | 14060000116046 | 14060000116046 | 1 | PA216574 | PM645629 |
| 14060000116054 | L14/dossiers | 14 | 14060000116053 | 14060000116053 | 1 | PA609442 | PM645214 |
| 14060000116061 | L14/dossiers | 14 | 14060000116060 | 14060000116060 | 1 | PA998 | PM645034 |
| 14060000116079 | L14/dossiers | 14 | 14060000116078 | 14060000116078 | 1 | PA340755 | PM645506 |
| 14060000116086 | L14/dossiers | 14 | 14060000116085 | 14060000116085 | 1 | PA1886 | PM645099 |
| 14060000116107 | L14/dossiers | 14 | 14060000116106 | 14060000116106 | 1 | PA267689 | PM645295 |
| 14060000116155 | L14/dossiers | 14 | 14060000116154 | 14060000116154 | 1 | PA267499 | PM645572 |
| 14060000116171 | L14/dossiers | 14 | 14060000116170 | 14060000116170 | 1 | PA267622 | PM702957 |
| 14060000116225 | L14/dossiers | 14 | 14060000116224 | 14060000116224 | 1 | PA346886 | PM695110 |
| 14060000116232 | L14/dossiers | 14 | 14060000116231 | 14060000116231 | 1 | PA328 | PM653228 |
| 14060000116233 | L14/dossiers | 14 | 14060000116231 | 14060000116231 | 2 | PA335999 | PM653292 |
| 14060000116240 | L14/dossiers | 14 | 14060000116239 | 14060000116239 | 1 | PA415482 | PM703556 |
| 14060000116267 | L14/dossiers | 14 | 14060000116266 | 14060000116266 | 1 | PA267622 | PM702957 |
| 14060000116268 | L14/dossiers | 14 | 14060000116266 | 14060000116266 | 2 | PA588876 | PM702967 |
| 14060000116372 | L14/dossiers | 14 | 14060000116371 | 14060000116371 | 1 | PA330240 | PM645425 |
| 14060000116385 | L14/dossiers | 14 | 14060000116384 | 14060000116384 | 1 | PA334149 | PM645127 |
| 14060000116392 | L14/dossiers | 14 | 14060000116391 | 14060000116391 | 1 | PA267622 | PM702957 |
| 14060000116393 | L14/dossiers | 14 | 14060000116391 | 14060000116391 | 2 | PA588883 | PM702975 |
| 14060000116401 | L14/dossiers | 14 | 14060000116400 | 14060000116400 | 1 | PA2690 | PM645458 |
| 14060000116408 | L14/dossiers | 14 | 14060000116407 | 14060000116407 | 1 | PA266788 | PM645294 |
| 14060000116418 | L14/dossiers | 14 | 14060000116417 | 14060000116417 | 1 | PA605036 | PM645278 |
| 14060000116425 | L14/dossiers | 14 | 14060000116424 | 14060000116424 | 1 | PA1886 | PM645099 |
| 14060000116434 | L14/dossiers | 14 | 14060000116433 | 14060000116433 | 1 | PA1963 | PM645466 |
| 14060000116461 | L14/dossiers | 14 | 14060000116460 | 14060000116460 | 1 | PA563 | PM645307 |
| 14060000116468 | L14/dossiers | 14 | 14060000116467 | 14060000116467 | 1 | PA267327 | PM645031 |
| 14060000116476 | L14/dossiers | 14 | 14060000116475 | 14060000116475 | 1 | PA266788 | PM645294 |
| 14060000116483 | L14/dossiers | 14 | 14060000116482 | 14060000116482 | 1 | PA328 | PM653228 |
| 14060000116535 | L14/dossiers | 14 | 14060000116534 | 14060000116534 | 1 | PA605922 | PM645493 |
| 14060000116542 | L14/dossiers | 14 | 14060000116541 | 14060000116541 | 1 | PA346886 | PM695110 |
| 14060000116546 | L14/dossiers | 14 | 14060000116545 | 14060000116545 | 1 | PA608662 | PM645592 |
| 14060000116553 | L14/dossiers | 14 | 14060000116552 | 14060000116552 | 1 | PA330684 | PM645497 |
| 14060000116560 | L14/dossiers | 14 | 14060000116559 | 14060000116559 | 1 | PA328 | PM653228 |
| 14060000116561 | L14/dossiers | 14 | 14060000116559 | 14060000116559 | 2 | PA2240 | PM653295 |
| 14060000116633 | L14/dossiers | 14 | 14060000116632 | 14060000116632 | 1 | PA266788 | PM645294 |
| 14060000116640 | L14/dossiers | 14 | 14060000116639 | 14060000116639 | 1 | PA267585 | PM645508 |
| 14060000116647 | L14/dossiers | 14 | 14060000116646 | 14060000116646 | 1 | PA292 | PM429961 |
| 14060000116663 | L14/dossiers | 14 | 14060000116662 | 14060000116662 | 1 | PA2377 | PM645591 |
| 14060000116670 | L14/dossiers | 14 | 14060000116669 | 14060000116669 | 1 | PA267506 | PM645270 |
| 14060000116677 | L14/dossiers | 14 | 14060000116676 | 14060000116676 | 1 | PA267622 | PM702957 |