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
17060000014817L17/dossiers1717060000014807170600000148079PA7944342025-03-07False
17060000014818L17/dossiers17170600000148071706000001480710PA8416452025-03-07False
17060000014819L17/dossiers17170600000148071706000001480711PA8420012025-03-07False
17060000014820L17/dossiers17170600000148071706000001480712PA7208222025-03-07False
17060000014821L17/dossiers17170600000148071706000001480713PA7206682025-03-07False
17060000014822L17/dossiers17170600000148071706000001480714PA7948862025-03-07False
17060000014823L17/dossiers17170600000148071706000001480715PA7960422025-03-07False
17060000014824L17/dossiers17170600000148071706000001480716PA8414872025-03-07False
17060000014825L17/dossiers17170600000148071706000001480717PA7931342025-03-07False
17060000014826L17/dossiers17170600000148071706000001480718PA8400752025-03-07False
17060000014827L17/dossiers17170600000148071706000001480719PA7204682025-03-07False
17060000014828L17/dossiers17170600000148071706000001480720PA7941982025-03-07False
17060000014829L17/dossiers17170600000148071706000001480721PA8401592025-03-07False
17060000014830L17/dossiers17170600000148071706000001480722PA7935482025-03-07False
17060000014831L17/dossiers17170600000148071706000001480723PA7956442025-03-07False
17060000014832L17/dossiers17170600000148071706000001480724PA8401192025-03-07False
17060000014833L17/dossiers17170600000148071706000001480725PA7931662025-03-07False
17060000014834L17/dossiers17170600000148071706000001480726PA7939282025-03-07False
17060000014835L17/dossiers17170600000148071706000001480727PA7947622025-03-07False
17060000014836L17/dossiers17170600000148071706000001480728PA7931462025-03-07False
17060000014837L17/dossiers17170600000148071706000001480729PA8401352025-03-07False
17060000014838L17/dossiers17170600000148071706000001480730PA8420732025-03-07False
17060000014839L17/dossiers17170600000148071706000001480731PA8417612025-03-07False
17060000014840L17/dossiers17170600000148071706000001480732PA7947182025-03-07False
17060000014841L17/dossiers17170600000148071706000001480733PA7932462025-03-07False
17060000014842L17/dossiers17170600000148071706000001480734PA8401432025-03-07False
17060000014843L17/dossiers17170600000148071706000001480735PA7946782025-03-07False
17060000014844L17/dossiers17170600000148071706000001480736PA7938922025-03-07False
17060000014845L17/dossiers17170600000148071706000001480737PA8417372025-03-07False
17060000014846L17/dossiers17170600000148071706000001480738PA7960342025-03-07False
17060000014847L17/dossiers17170600000148071706000001480739PA7938322025-03-07False
17060000014848L17/dossiers17170600000148071706000001480740PA8416052025-03-07False
17060000014849L17/dossiers17170600000148071706000001480741PA7933622025-03-07False
17060000014850L17/dossiers17170600000148071706000001480742PA7944182025-03-07False
17060000014851L17/dossiers17170600000148071706000001480743PA7935922025-03-07False
17060000014852L17/dossiers17170600000148071706000001480744PA8414512025-03-07False
17060000014853L17/dossiers17170600000148071706000001480745PA7932182025-03-07False
17060000014854L17/dossiers17170600000148071706000001480746PA7959002025-03-07False
17060000014855L17/dossiers17170600000148071706000001480747PA7936322025-03-07False
17060000014856L17/dossiers17170600000148071706000001480748PA8420852025-03-07False
17060000014857L17/dossiers17170600000148071706000001480749PA7945982025-03-07False
17060000014858L17/dossiers17170600000148071706000001480750PA8414392025-03-07False
17060000014859L17/dossiers17170600000148071706000001480751PA7940302025-03-07False
17060000014860L17/dossiers17170600000148071706000001480752PA8417492025-03-07False
17060000014861L17/dossiers17170600000148071706000001480753PA8410752025-03-07False
17060000014862L17/dossiers17170600000148071706000001480754PA8408692025-03-07False
17060000014863L17/dossiers17170600000148071706000001480755PA7943542025-03-07False
17060000014864L17/dossiers17170600000148071706000001480756PA7959122025-03-07False
17060000014865L17/dossiers17170600000148071706000001480757PA8418372025-03-07False
17060000014866L17/dossiers17170600000148071706000001480758PA7960262025-03-07False