dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 17060000148432 | L17/dossiers | 17 | 17060000148431 | 17060000148431 | 1 | PA828008 | PM828826 |
| 17060000148436 | L17/dossiers | 17 | 17060000148435 | 17060000148435 | 1 | PA267763 | PM843125 |
| 17060000148443 | L17/dossiers | 17 | 17060000148442 | 17060000148442 | 1 | PA267763 | PM843125 |
| 17060000148447 | L17/dossiers | 17 | 17060000148446 | 17060000148446 | 1 | PA718838 | PM842405 |
| 17060000148464 | L17/dossiers | 17 | 17060000148463 | 17060000148463 | 1 | PA643210 | PM873637 |
| 17060000148490 | L17/dossiers | 17 | 17060000148489 | 17060000148489 | 1 | PA841381 | PM842966 |
| 17060000148494 | L17/dossiers | 17 | 17060000148493 | 17060000148493 | 1 | PA2042 | PM775815 |
| 17060000148518 | L17/dossiers | 17 | 17060000148517 | 17060000148517 | 1 | PA793744 | PM842696 |
| 17060000148525 | L17/dossiers | 17 | 17060000148524 | 17060000148524 | 1 | PA793094 | PM842327 |
| 17060000148532 | L17/dossiers | 17 | 17060000148531 | 17060000148531 | 1 | PA793572 | PM842498 |
| 17060000148539 | L17/dossiers | 17 | 17060000148538 | 17060000148538 | 1 | PA722390 | PM843317 |
| 17060000148546 | L17/dossiers | 17 | 17060000148545 | 17060000148545 | 1 | PA266797 | PM843071 |
| 17060000148553 | L17/dossiers | 17 | 17060000148552 | 17060000148552 | 1 | PA720668 | PM840342 |
| 17060000148560 | L17/dossiers | 17 | 17060000148559 | 17060000148559 | 1 | PA330008 | PM842366 |
| 17060000148567 | L17/dossiers | 17 | 17060000148566 | 17060000148566 | 1 | PA719922 | PM842867 |
| 17060000148574 | L17/dossiers | 17 | 17060000148573 | 17060000148573 | 1 | PA266797 | PM843071 |
| 17060000148581 | L17/dossiers | 17 | 17060000148580 | 17060000148580 | 1 | PA608264 | PM843179 |
| 17060000148588 | L17/dossiers | 17 | 17060000148587 | 17060000148587 | 1 | PA721234 | PM843692 |
| 17060000148595 | L17/dossiers | 17 | 17060000148594 | 17060000148594 | 1 | PA796018 | PM843425 |
| 17060000148602 | L17/dossiers | 17 | 17060000148601 | 17060000148601 | 1 | PA842255 | PM843770 |
| 17060000148609 | L17/dossiers | 17 | 17060000148608 | 17060000148608 | 1 | PA718784 | PM842342 |
| 17060000148616 | L17/dossiers | 17 | 17060000148615 | 17060000148615 | 1 | PA793664 | PM842549 |
| 17060000148623 | L17/dossiers | 17 | 17060000148622 | 17060000148622 | 1 | PA841931 | PM843485 |
| 17060000148630 | L17/dossiers | 17 | 17060000148629 | 17060000148629 | 1 | PA840665 | PM842336 |
| 17060000148637 | L17/dossiers | 17 | 17060000148636 | 17060000148636 | 1 | PA720430 | PM843092 |
| 17060000148644 | L17/dossiers | 17 | 17060000148643 | 17060000148643 | 1 | PA793322 | PM840246 |
| 17060000148651 | L17/dossiers | 17 | 17060000148650 | 17060000148650 | 1 | PA722390 | PM843317 |
| 17060000148658 | L17/dossiers | 17 | 17060000148657 | 17060000148657 | 1 | PA610002 | PM840363 |
| 17060000148665 | L17/dossiers | 17 | 17060000148664 | 17060000148664 | 1 | PA2952 | PM842414 |
| 17060000148672 | L17/dossiers | 17 | 17060000148671 | 17060000148671 | 1 | PA840817 | PM842483 |
| 17060000148683 | L17/dossiers | 17 | 17060000148682 | 17060000148682 | 1 | PA793948 | PM842615 |
| 17060000148691 | L17/dossiers | 17 | 17060000148690 | 17060000148690 | 1 | PA942 | PM842987 |
| 17060000148698 | L17/dossiers | 17 | 17060000148697 | 17060000148697 | 1 | PA795746 | PM843584 |
| 17060000148705 | L17/dossiers | 17 | 17060000148704 | 17060000148704 | 1 | PA606507 | PM842834 |
| 17060000148712 | L17/dossiers | 17 | 17060000148711 | 17060000148711 | 1 | PA793816 | PM842657 |
| 17060000148719 | L17/dossiers | 17 | 17060000148718 | 17060000148718 | 1 | PA227089 | PM874597 |
| 17060000148741 | L17/dossiers | 17 | 17060000148740 | 17060000148740 | 1 | PA610002 | PM840363 |
| 17060000148748 | L17/dossiers | 17 | 17060000148747 | 17060000148747 | 1 | PA795244 | PM843749 |
| 17060000148755 | L17/dossiers | 17 | 17060000148754 | 17060000148754 | 1 | PA841885 | PM843446 |
| 17060000148762 | L17/dossiers | 17 | 17060000148761 | 17060000148761 | 1 | PA840997 | PM842612 |
| 17060000148786 | L17/dossiers | 17 | 17060000148785 | 17060000148785 | 1 | PA841359 | PM842939 |
| 17060000148798 | L17/dossiers | 17 | 17060000148797 | 17060000148797 | 1 | PA794710 | PM867916 |
| 17060000148805 | L17/dossiers | 17 | 17060000148804 | 17060000148804 | 1 | PA817203 | PM842978 |
| 17060000148812 | L17/dossiers | 17 | 17060000148811 | 17060000148811 | 1 | PA827954 | PM828704 |
| 17060000148834 | L17/dossiers | 17 | 17060000148833 | 17060000148833 | 1 | PA643210 | PM873637 |
| 17060000148855 | L17/dossiers | 17 | 17060000148854 | 17060000148854 | 1 | PA736169 | PM829791 |
| 17060000148862 | L17/dossiers | 17 | 17060000148861 | 17060000148861 | 1 | PA429869 | PM829749 |
| 17060000148872 | L17/dossiers | 17 | 17060000148871 | 17060000148871 | 1 | PA643210 | PM873637 |
| 17060000148896 | L17/dossiers | 17 | 17060000148895 | 17060000148895 | 1 | PA643210 | PM873637 |
| 17060000148920 | L17/dossiers | 17 | 17060000148919 | 17060000148919 | 1 | PA775178 | PM775460 |