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
17060000004969L17/dossiers17170600000049031706000000490365PA7212962023-04-28False
17060000004970L17/dossiers17170600000049031706000000490366PA2673182023-04-28False
17060000004971L17/dossiers17170600000049031706000000490367PA7218802023-04-28False
17060000004972L17/dossiers17170600000049031706000000490368PA7959342023-04-28False
17060000004973L17/dossiers17170600000049031706000000490369PA7201742023-04-28False
17060000004974L17/dossiers17170600000049031706000000490370PA7959582023-04-28False
17060000004975L17/dossiers17170600000049031706000000490371PA7220542023-04-28False
17060000004976L17/dossiers17170600000049031706000000490372PA7200542023-04-28False
17060000004977L17/dossiers17170600000049031706000000490373PA7220702023-04-28False
17060000004978L17/dossiers17170600000049031706000000490374PA7931902023-04-28False
17060000004979L17/dossiers17170600000049031706000000490375PA7211502023-04-28False
17060000004980L17/dossiers17170600000049031706000000490376PA7221502023-04-28False
17060000004981L17/dossiers17170600000049031706000000490377PA7940042023-04-28False
17060000004982L17/dossiers17170600000049031706000000490378PA3318352023-04-28False
17060000004983L17/dossiers17170600000049031706000000490379PA7956522023-04-28False
17060000004984L17/dossiers17170600000049031706000000490380PA7203542023-04-28False
17060000004985L17/dossiers17170600000049031706000000490381PA7200742023-04-28False
17060000004986L17/dossiers17170600000049031706000000490382PA6431842023-04-28False
17060000004987L17/dossiers17170600000049031706000000490383PA7197982023-04-28False
17060000004988L17/dossiers17170600000049031706000000490384PA7944502023-04-28False
17060000004989L17/dossiers17170600000049031706000000490385PA7210042023-04-28False
17060000004990L17/dossiers17170600000049031706000000490386PA7200222023-04-28False
17060000004991L17/dossiers17170600000049031706000000490387PA7196642023-04-28False
17060000004992L17/dossiers17170600000049031706000000490388PA7194122023-04-28False
17060000004993L17/dossiers17170600000049031706000000490389PA7194042023-04-28False
17060000004994L17/dossiers17170600000049031706000000490390PA7214662023-04-28False
17060000004995L17/dossiers17170600000049031706000000490391PA3457222023-04-28False
17060000004996L17/dossiers17170600000049031706000000490392PA7193882023-04-28False
17060000004997L17/dossiers17170600000049031706000000490393PA7197562023-04-28False
17060000004998L17/dossiers17170600000049031706000000490394PA7203422023-04-28False
17060000004999L17/dossiers17170600000049031706000000490395PA7190062023-04-28False
17060000005000L17/dossiers17170600000049031706000000490396PA7218522023-04-28False
17060000005001L17/dossiers17170600000049031706000000490397PA7120142023-04-28False
17060000005002L17/dossiers17170600000049031706000000490398PA7953862023-04-28False
17060000005003L17/dossiers17170600000049031706000000490399PA7216322023-04-28False
17060000005004L17/dossiers171706000000490317060000004903100PA7204462023-04-28False
17060000005005L17/dossiers171706000000490317060000004903101PA7952162023-04-28False
17060000005006L17/dossiers171706000000490317060000004903102PA7197182023-04-28False
17060000005007L17/dossiers171706000000490317060000004903103PA3341162023-04-28False
17060000005008L17/dossiers171706000000490317060000004903104PA7949742023-04-28False
17060000005009L17/dossiers171706000000490317060000004903105PA7942062023-04-28False
17060000005010L17/dossiers171706000000490317060000004903106PA7191542023-04-28False
17060000005011L17/dossiers171706000000490317060000004903107PA7201462023-04-28False
17060000005012L17/dossiers171706000000490317060000004903108PA6774832023-04-28False
17060000005013L17/dossiers171706000000490317060000004903109PA7193382023-04-28False
17060000005014L17/dossiers171706000000490317060000004903110PA7203702023-04-28False
17060000005015L17/dossiers171706000000490317060000004903111PA7943862023-04-28False
17060000005016L17/dossiers171706000000490317060000004903112PA7951762023-04-28False
17060000005017L17/dossiers171706000000490317060000004903113PA7198822023-04-28False
17060000005018L17/dossiers171706000000490317060000004903114PA7956642023-04-28False