Aller au contenu
blackout

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

309 130 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7acteur_acteur_refVARCHARdocument.coSignataires.coSignataire.acteur.acteurRef · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
8date_cosignatureDATEdocument.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
9date_retrait_cosignatureDATEdocument.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
10editeBOOLEANdocument.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
11organe_organe_refVARCHARdocument.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %
12organe_et_apparentesBOOLEANdocument.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refdate_cosignaturedate_retrait_cosignatureediteorgane_organe_reforgane_et_apparentes
17060000089129L17/dossiers1717060000089119170600000891199PA8409832024-10-11False
17060000089130L17/dossiers17170600000891191706000008911910PA8411832024-10-11False
17060000089131L17/dossiers17170600000891191706000008911911PA8413952024-10-11False
17060000089132L17/dossiers17170600000891191706000008911912PA8417692024-10-11False
17060000089133L17/dossiers17170600000891191706000008911913PA8406852024-10-11False
17060000089134L17/dossiers17170600000891191706000008911914PA8406572024-10-11False
17060000089135L17/dossiers17170600000891191706000008911915PA8408092024-10-11False
17060000089141L17/dossiers1717060000089139170600000891391PA7960782025-01-30False
17060000089142L17/dossiers1717060000089139170600000891392PA6431842025-01-30False
17060000089143L17/dossiers1717060000089139170600000891393PA7210042025-01-30False
17060000089144L17/dossiers1717060000089139170600000891394PA7949822025-01-30False
17060000089145L17/dossiers1717060000089139170600000891395PA6073952025-01-30False
17060000089146L17/dossiers1717060000089139170600000891396PA6078462025-01-30False
17060000089147L17/dossiers1717060000089139170600000891397PA7211702025-01-30False
17060000089148L17/dossiers1717060000089139170600000891398PA7221502025-01-30False
17060000089149L17/dossiers1717060000089139170600000891399PA7943302025-01-30False
17060000089150L17/dossiers17170600000891391706000008913910PA6431752025-01-30False
17060000089151L17/dossiers17170600000891391706000008913911PA7935202025-01-30False
17060000089152L17/dossiers17170600000891391706000008913912PA7212342025-01-30False
17060000089153L17/dossiers17170600000891391706000008913913PA7219162025-01-30False
17060000089154L17/dossiers17170600000891391706000008913914PA7221022025-01-30False
17060000089155L17/dossiers17170600000891391706000008913915PA3457222025-01-30False
17060000089156L17/dossiers17170600000891391706000008913916PA7200222025-01-30False
17060000089157L17/dossiers17170600000891391706000008913917PA7190322025-01-30False
17060000089158L17/dossiers17170600000891391706000008913918PA8408172025-01-30False
17060000089159L17/dossiers17170600000891391706000008913919PA16302025-01-30False
17060000089160L17/dossiers17170600000891391706000008913920PA2677942025-01-30False
17060000089161L17/dossiers17170600000891391706000008913921PA7958082025-01-30False
17060000089162L17/dossiers17170600000891391706000008913922PA29402025-01-30False
17060000089163L17/dossiers17170600000891391706000008913923PA7195502025-01-30False
17060000089164L17/dossiers17170600000891391706000008913924PA7201462025-01-30False
17060000089165L17/dossiers17170600000891391706000008913925PA8419312025-01-30False
17060000089166L17/dossiers17170600000891391706000008913926PA5692025-01-30False
17060000089167L17/dossiers17170600000891391706000008913927PA7199182025-01-30False
17060000089168L17/dossiers17170600000891391706000008913928PA7959502025-01-30False
17060000089169L17/dossiers17170600000891391706000008913929PA7211582025-01-30False
17060000089170L17/dossiers17170600000891391706000008913930PA7192182025-01-30False
17060000089171L17/dossiers17170600000891391706000008913931PA6426952025-01-30False
17060000089172L17/dossiers17170600000891391706000008913932PA7217502025-01-30False
17060000089173L17/dossiers17170600000891391706000008913933PA8423112025-01-30False
17060000089174L17/dossiers17170600000891391706000008913934PA7194722025-01-30False
17060000089175L17/dossiers17170600000891391706000008913935PA7191182025-01-30False
17060000089176L17/dossiers17170600000891391706000008913936PA7212962025-01-30False
17060000089177L17/dossiers17170600000891391706000008913937PA7173792025-01-30False
17060000089178L17/dossiers17170600000891391706000008913938PA7200662025-01-30False
17060000089179L17/dossiers17170600000891391706000008913939PA7958882025-01-30False
17060000089180L17/dossiers17170600000891391706000008913940PA29602025-01-30False
17060000089181L17/dossiers17170600000891391706000008913941PA7950462025-01-30False
17060000089182L17/dossiers17170600000891391706000008913942PA7217642025-01-30False
17060000089183L17/dossiers17170600000891391706000008913943PA7190802025-01-30False