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
17060000011227L17/dossiers17170600000111631706000001116363PA7949542024-10-15False
17060000011228L17/dossiers17170600000111631706000001116364PA8422552024-10-15False
17060000011229L17/dossiers17170600000111631706000001116365PA7949462024-10-15False
17060000011233L17/dossiers1717060000011231170600000112311PA7948862025-03-07False
17060000011234L17/dossiers1717060000011231170600000112312PA8417772024-10-152025-03-07False
17060000011235L17/dossiers1717060000011231170600000112313PA7945982025-03-07False
17060000011236L17/dossiers1717060000011231170600000112314PA8417492025-03-07False
17060000011237L17/dossiers1717060000011231170600000112315PA8411392025-03-07False
17060000011238L17/dossiers1717060000011231170600000112316PA7945022025-03-07False
17060000011239L17/dossiers1717060000011231170600000112317PA8419812025-03-07False
17060000011240L17/dossiers1717060000011231170600000112318PA7959742025-03-07False
17060000011241L17/dossiers1717060000011231170600000112319PA7959122025-03-07False
17060000011242L17/dossiers17170600000112311706000001123110PA7960422025-03-07False
17060000011243L17/dossiers17170600000112311706000001123111PA7933142025-03-07False
17060000011244L17/dossiers17170600000112311706000001123112PA7933302025-03-07False
17060000011245L17/dossiers17170600000112311706000001123113PA7956442025-03-07False
17060000011246L17/dossiers17170600000112311706000001123114PA7944182025-03-07False
17060000011247L17/dossiers17170600000112311706000001123115PA7936082025-03-07False
17060000011248L17/dossiers17170600000112311706000001123116PA7194362025-03-07False
17060000011249L17/dossiers17170600000112311706000001123117PA8414392025-03-07False
17060000011250L17/dossiers17170600000112311706000001123118PA7931582025-03-07False
17060000011251L17/dossiers17170600000112311706000001123119PA7204682025-03-07False
17060000011252L17/dossiers17170600000112311706000001123120PA7931462025-03-07False
17060000011253L17/dossiers17170600000112311706000001123121PA8408572025-03-07False
17060000011254L17/dossiers17170600000112311706000001123122PA7219322025-03-07False
17060000011255L17/dossiers17170600000112311706000001123123PA7957862025-03-07False
17060000011256L17/dossiers17170600000112311706000001123124PA7945622025-03-07False
17060000011257L17/dossiers17170600000112311706000001123125PA7947182025-03-07False
17060000011258L17/dossiers17170600000112311706000001123126PA8420852025-03-07False
17060000011259L17/dossiers17170600000112311706000001123127PA8420732025-03-07False
17060000011260L17/dossiers17170600000112311706000001123128PA7932462025-03-07False
17060000011261L17/dossiers17170600000112311706000001123129PA7960342025-03-07False
17060000011262L17/dossiers17170600000112311706000001123130PA7949542025-03-07False
17060000011263L17/dossiers17170600000112311706000001123131PA7938922025-03-07False
17060000011264L17/dossiers17170600000112311706000001123132PA8407812025-03-07False
17060000011265L17/dossiers17170600000112311706000001123133PA8418732025-03-07False
17060000011266L17/dossiers17170600000112311706000001123134PA7949462025-03-07False
17060000011267L17/dossiers17170600000112311706000001123135PA7959002025-03-07False
17060000011268L17/dossiers17170600000112311706000001123136PA8420972025-03-07False
17060000011269L17/dossiers17170600000112311706000001123137PA8414512025-03-07False
17060000011270L17/dossiers17170600000112311706000001123138PA7934322025-03-07False
17060000011271L17/dossiers17170600000112311706000001123139PA8408692025-03-07False
17060000011272L17/dossiers17170600000112311706000001123140PA7947342025-03-07False
17060000011273L17/dossiers17170600000112311706000001123141PA8415632025-03-07False
17060000011274L17/dossiers17170600000112311706000001123142PA7947702025-03-07False
17060000011275L17/dossiers17170600000112311706000001123143PA8407212025-03-07False
17060000011276L17/dossiers17170600000112311706000001123144PA7959662025-03-07False
17060000011277L17/dossiers17170600000112311706000001123145PA7936562025-03-07False
17060000011278L17/dossiers17170600000112311706000001123146PA7943542025-03-07False
17060000011279L17/dossiers17170600000112311706000001123147PA8420012025-03-07False