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 151 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
17060000004050L17/dossiers171706000000390017060000003900149PA7210042021-01-26False
17060000004051L17/dossiers171706000000390017060000003900150PA7214342021-01-26False
17060000004052L17/dossiers171706000000390017060000003900151PA7200222021-01-26False
17060000004053L17/dossiers171706000000390017060000003900152PA7193102021-01-26False
17060000004054L17/dossiers171706000000390017060000003900153PA7218522021-01-26False
17060000004055L17/dossiers171706000000390017060000003900154PA7222282021-01-26False
17060000004056L17/dossiers171706000000390017060000003900155PA7194122021-01-26False
17060000004057L17/dossiers171706000000390017060000003900156PA7194042021-01-26False
17060000004058L17/dossiers171706000000390017060000003900157PA7214662021-01-26False
17060000004059L17/dossiers171706000000390017060000003900158PA7220082021-01-26False
17060000004060L17/dossiers171706000000390017060000003900159PA7223202021-01-26False
17060000004061L17/dossiers171706000000390017060000003900160PA7193882021-01-26False
17060000004062L17/dossiers171706000000390017060000003900161PA7214502021-01-26False
17060000004063L17/dossiers171706000000390017060000003900162PA7203422021-01-26False
17060000004064L17/dossiers171706000000390017060000003900163PA7211342021-01-26False
17060000004065L17/dossiers171706000000390017060000003900164PA7190062021-01-26False
17060000004066L17/dossiers171706000000390017060000003900165PA7198582021-01-26False
17060000004067L17/dossiers171706000000390017060000003900166PA7203782021-01-26False
17060000004068L17/dossiers171706000000390017060000003900167PA7204462021-01-26False
17060000004069L17/dossiers171706000000390017060000003900168PA7189182021-01-26False
17060000004070L17/dossiers171706000000390017060000003900169PA7222442021-01-26False
17060000004071L17/dossiers171706000000390017060000003900170PA7171672021-01-26False
17060000004072L17/dossiers171706000000390017060000003900171PA7173792021-01-26False
17060000004073L17/dossiers171706000000390017060000003900172PA7197182021-01-26False
17060000004074L17/dossiers171706000000390017060000003900173PA7221782021-01-26False
17060000004075L17/dossiers171706000000390017060000003900174PA3341162021-01-26False
17060000004076L17/dossiers171706000000390017060000003900175PA7219462021-01-26False
17060000004077L17/dossiers171706000000390017060000003900176PA7190802021-01-26False
17060000004078L17/dossiers171706000000390017060000003900177PA7191542021-01-26False
17060000004079L17/dossiers171706000000390017060000003900178PA7201462021-01-26False
17060000004080L17/dossiers171706000000390017060000003900179PA7218002021-01-26False
17060000004081L17/dossiers171706000000390017060000003900180PA7217262021-01-26False
17060000004082L17/dossiers171706000000390017060000003900181PA6774832021-01-26False
17060000004083L17/dossiers171706000000390017060000003900182PA7208702021-01-26False
17060000004084L17/dossiers171706000000390017060000003900183PA7193382021-01-26False
17060000004085L17/dossiers171706000000390017060000003900184PA7203702021-01-26False
17060000004086L17/dossiers171706000000390017060000003900185PA7190722021-01-26False
17060000004087L17/dossiers171706000000390017060000003900186PA7198822021-01-26False
17060000004088L17/dossiers171706000000390017060000003900187PA7191302021-01-26False
17060000004089L17/dossiers171706000000390017060000003900188PA7207382021-01-26False
17060000004090L17/dossiers171706000000390017060000003900189PA7199522021-01-26False
17060000004091L17/dossiers171706000000390017060000003900190PA7192422021-01-26False
17060000004092L17/dossiers171706000000390017060000003900191PA7205162021-01-26False
17060000004093L17/dossiers171706000000390017060000003900192PA7198502021-01-26False
17060000004094L17/dossiers171706000000390017060000003900193PA7209082021-01-26False
17060000004095L17/dossiers171706000000390017060000003900194PA7195202021-01-26False
17060000004096L17/dossiers171706000000390017060000003900195PA7193642021-01-26False
17060000004097L17/dossiers171706000000390017060000003900196PA7201082021-01-26False
17060000004098L17/dossiers171706000000390017060000003900197PA7204922021-01-26False
17060000004099L17/dossiers171706000000390017060000003900198PA7204022021-01-26False