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
17060000037125L17/dossiers1717060000037117170600000371177PA7932382025-07-07False
17060000037126L17/dossiers1717060000037117170600000371178PA7933742025-07-07False
17060000037127L17/dossiers1717060000037117170600000371179PA7931582025-07-07False
17060000037128L17/dossiers17170600000371171706000003711710PA7944342025-07-07False
17060000037129L17/dossiers17170600000371171706000003711711PA8416452025-07-07False
17060000037130L17/dossiers17170600000371171706000003711712PA8420012025-07-07False
17060000037131L17/dossiers17170600000371171706000003711713PA7208222025-07-07False
17060000037132L17/dossiers17170600000371171706000003711714PA7206682025-07-07False
17060000037133L17/dossiers17170600000371171706000003711715PA7948862025-07-07False
17060000037134L17/dossiers17170600000371171706000003711716PA7960422025-07-07False
17060000037135L17/dossiers17170600000371171706000003711717PA7938442025-07-07False
17060000037136L17/dossiers17170600000371171706000003711718PA8414872025-07-07False
17060000037137L17/dossiers17170600000371171706000003711719PA8411312025-07-07False
17060000037138L17/dossiers17170600000371171706000003711720PA7931822025-07-07False
17060000037139L17/dossiers17170600000371171706000003711721PA7931342025-07-07False
17060000037140L17/dossiers17170600000371171706000003711722PA8400752025-07-07False
17060000037141L17/dossiers17170600000371171706000003711723PA8407012025-07-07False
17060000037142L17/dossiers17170600000371171706000003711724PA8407212025-07-07False
17060000037143L17/dossiers17170600000371171706000003711725PA7204682025-07-07False
17060000037144L17/dossiers17170600000371171706000003711726PA7941982025-07-07False
17060000037145L17/dossiers17170600000371171706000003711727PA8401592025-07-07False
17060000037146L17/dossiers17170600000371171706000003711728PA7935482025-07-07False
17060000037147L17/dossiers17170600000371171706000003711729PA7956442025-07-07False
17060000037148L17/dossiers17170600000371171706000003711730PA8401192025-07-07False
17060000037149L17/dossiers17170600000371171706000003711731PA7931662025-07-07False
17060000037150L17/dossiers17170600000371171706000003711732PA7939282025-07-07False
17060000037151L17/dossiers17170600000371171706000003711733PA7947622025-07-07False
17060000037152L17/dossiers17170600000371171706000003711734PA7931462025-07-07False
17060000037153L17/dossiers17170600000371171706000003711735PA8401352025-07-07False
17060000037154L17/dossiers17170600000371171706000003711736PA7947182025-07-07False
17060000037155L17/dossiers17170600000371171706000003711737PA8416212025-07-07False
17060000037156L17/dossiers17170600000371171706000003711738PA7932462025-07-07False
17060000037157L17/dossiers17170600000371171706000003711739PA8416132025-07-07False
17060000037158L17/dossiers17170600000371171706000003711740PA8401432025-07-07False
17060000037159L17/dossiers17170600000371171706000003711741PA8408012025-07-07False
17060000037160L17/dossiers17170600000371171706000003711742PA7946782025-07-07False
17060000037161L17/dossiers17170600000371171706000003711743PA8411392025-07-07False
17060000037162L17/dossiers17170600000371171706000003711744PA7938922025-07-07False
17060000037163L17/dossiers17170600000371171706000003711745PA8417372025-07-07False
17060000037164L17/dossiers17170600000371171706000003711746PA7960342025-07-07False
17060000037165L17/dossiers17170600000371171706000003711747PA7938322025-07-07False
17060000037166L17/dossiers17170600000371171706000003711748PA7931022025-07-07False
17060000037167L17/dossiers17170600000371171706000003711749PA8416052025-07-07False
17060000037168L17/dossiers17170600000371171706000003711750PA7933622025-07-07False
17060000037169L17/dossiers17170600000371171706000003711751PA7944182025-07-07False
17060000037170L17/dossiers17170600000371171706000003711752PA7935922025-07-07False
17060000037171L17/dossiers17170600000371171706000003711753PA7955402025-07-07False
17060000037172L17/dossiers17170600000371171706000003711754PA8407572025-07-07False
17060000037173L17/dossiers17170600000371171706000003711755PA8414512025-07-07False
17060000037174L17/dossiers17170600000371171706000003711756PA7932182025-07-07False