AN · données ouvertes
Explorateur / dossiers

dossiers.document_co_signataire

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

305 264 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 25 %, 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
17060000042008L17/dossiers17170600000419931706000004199314PA7194122025-07-11False
17060000042009L17/dossiers17170600000419931706000004199315PA3457222025-07-11False
17060000042010L17/dossiers17170600000419931706000004199316PA7197562025-07-11False
17060000042011L17/dossiers17170600000419931706000004199317PA7120142025-07-11False
17060000042012L17/dossiers17170600000419931706000004199318PA8416012025-07-11False
17060000042013L17/dossiers17170600000419931706000004199319PA7204462025-07-11False
17060000042014L17/dossiers17170600000419931706000004199320PA7190802025-07-11False
17060000042015L17/dossiers17170600000419931706000004199321PA7203702025-07-11False
17060000042016L17/dossiers17170600000419931706000004199322PA7956642025-07-11False
17060000042017L17/dossiers17170600000419931706000004199323PA7959622025-07-11False
17060000042018L17/dossiers17170600000419931706000004199324PA7196322025-07-11False
17060000042019L17/dossiers17170600000419931706000004199325PA7219162025-07-11False
17060000042020L17/dossiers17170600000419931706000004199326PA7214262025-07-11False
17060000042021L17/dossiers17170600000419931706000004199327PA7200662025-07-11False
17060000042022L17/dossiers17170600000419931706000004199328PA7955282025-07-11False
17060000042023L17/dossiers17170600000419931706000004199329PA8419272025-07-11False
17060000042024L17/dossiers17170600000419931706000004199330PA7958882025-07-11False
17060000042025L17/dossiers17170600000419931706000004199331PA7932702025-07-11False
17060000042026L17/dossiers17170600000419931706000004199332PA7934162025-07-11False
17060000042027L17/dossiers17170600000419931706000004199333PA7201902025-07-11False
17060000042028L17/dossiers17170600000419931706000004199334PA7944862025-07-11False
17060000042029L17/dossiers17170600000419931706000004199335PA7215842025-07-11False
17060000042030L17/dossiers17170600000419931706000004199336PA7959202025-07-11False
17060000042031L17/dossiers17170600000419931706000004199337PA7221022025-07-11False
17060000042032L17/dossiers17170600000419931706000004199338PA7931942025-07-11False
17060000042033L17/dossiers17170600000419931706000004199339PA29602025-07-11False
17060000042034L17/dossiers17170600000419931706000004199340PA7950462025-07-11False
17060000042038L17/dossiers1717060000042036170600000420361PA7941542025-07-11False
17060000042039L17/dossiers1717060000042036170600000420362PA7195782025-07-11False
17060000042040L17/dossiers1717060000042036170600000420363PA8416332025-07-11False
17060000042041L17/dossiers1717060000042036170600000420364PA7955882025-07-11False
17060000042042L17/dossiers1717060000042036170600000420365PA8408292025-07-11False
17060000042043L17/dossiers1717060000042036170600000420366PA7953622025-07-11False
17060000042044L17/dossiers1717060000042036170600000420367PA7937722025-07-11False
17060000042045L17/dossiers1717060000042036170600000420368PA8415072025-07-11False
17060000042046L17/dossiers1717060000042036170600000420369PA8410232025-07-11False
17060000042047L17/dossiers17170600000420361706000004203610PA7940082025-07-11False
17060000042048L17/dossiers17170600000420361706000004203611PA7212102025-07-11False
17060000042049L17/dossiers17170600000420361706000004203612PA15672025-07-11False
17060000042050L17/dossiers17170600000420361706000004203613PA8409472025-07-11False
17060000042051L17/dossiers17170600000420361706000004203614PA7955162025-07-11False
17060000042052L17/dossiers17170600000420361706000004203615PA7946862025-07-11False
17060000042053L17/dossiers17170600000420361706000004203616PA8420452025-07-11False
17060000042054L17/dossiers17170600000420361706000004203617PA6075532025-07-11False
17060000042055L17/dossiers17170600000420361706000004203618PA7960182025-07-11False
17060000042059L17/dossiers1717060000042057170600000420571PA7199222026-07-09False
17060000042060L17/dossiers1717060000042057170600000420572PA8401712026-07-09False
17060000042061L17/dossiers1717060000042057170600000420573PA7212702026-07-09False
17060000042062L17/dossiers1717060000042057170600000420574PA7951642026-07-09False
17060000042063L17/dossiers1717060000042057170600000420575PA8415072026-07-09False