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
17060000043003L17/dossiers17170600000429671706000004296735PA8419472025-07-11False
17060000043004L17/dossiers17170600000429671706000004296736PA7941302025-07-11False
17060000043005L17/dossiers17170600000429671706000004296737PA7208462025-07-11False
17060000043006L17/dossiers17170600000429671706000004296738PA8417292025-07-11False
17060000043007L17/dossiers17170600000429671706000004296739PA7955162025-07-11False
17060000043008L17/dossiers17170600000429671706000004296740PA7956722025-07-11False
17060000043009L17/dossiers17170600000429671706000004296741PA7957462025-07-11False
17060000043010L17/dossiers17170600000429671706000004296742PA7951082025-07-11False
17060000043011L17/dossiers17170600000429671706000004296743PA8415152025-07-11False
17060000043012L17/dossiers17170600000429671706000004296744PA7952982025-07-11False
17060000043013L17/dossiers17170600000429671706000004296745PA7918242025-07-11False
17060000043014L17/dossiers17170600000429671706000004296746PA8420292025-07-11False
17060000043015L17/dossiers17170600000429671706000004296747PA7935322025-07-11False
17060000043016L17/dossiers17170600000429671706000004296748PA3423842025-07-11False
17060000043017L17/dossiers17170600000429671706000004296749PA7954222025-07-11False
17060000043018L17/dossiers17170600000429671706000004296750PA7946862025-07-11False
17060000043019L17/dossiers17170600000429671706000004296751PA8412152025-07-11False
17060000043020L17/dossiers17170600000429671706000004296752PA7954822025-07-11False
17060000043021L17/dossiers17170600000429671706000004296753PA6106542025-07-11False
17060000043022L17/dossiers17170600000429671706000004296754PA8411912025-07-11False
17060000043023L17/dossiers17170600000429671706000004296755PA7219602025-07-11False
17060000043024L17/dossiers17170600000429671706000004296756PA7938722025-07-11False
17060000043025L17/dossiers17170600000429671706000004296757PA8172112025-07-11False
17060000043026L17/dossiers17170600000429671706000004296758PA7937562025-07-11False
17060000043027L17/dossiers17170600000429671706000004296759PA7960622025-07-11False
17060000043028L17/dossiers17170600000429671706000004296760PA7195782025-07-11False
17060000043029L17/dossiers17170600000429671706000004296761PA7210622025-07-11False
17060000043030L17/dossiers17170600000429671706000004296762PA8418452025-07-11False
17060000043031L17/dossiers17170600000429671706000004296763PA7959822025-07-11False
17060000043032L17/dossiers17170600000429671706000004296764PA7954662025-07-11False
17060000043033L17/dossiers17170600000429671706000004296765PA7937442025-07-11False
17060000043034L17/dossiers17170600000429671706000004296766PA7209522025-07-11False
17060000043035L17/dossiers17170600000429671706000004296767PA7941062025-07-11False
17060000043036L17/dossiers17170600000429671706000004296768PA7941662025-07-11False
17060000043037L17/dossiers17170600000429671706000004296769PA7951642025-07-11False
17060000043038L17/dossiers17170600000429671706000004296770PA7955962025-07-11False
17060000043042L17/dossiers1717060000043040170600000430401PA8412152025-07-11False
17060000043043L17/dossiers1717060000043040170600000430402PA7208922025-07-11False
17060000043044L17/dossiers1717060000043040170600000430403PA7952282025-07-11False
17060000043045L17/dossiers1717060000043040170600000430404PA7932622025-07-11False
17060000043046L17/dossiers1717060000043040170600000430405PA7949062025-07-11False
17060000043047L17/dossiers1717060000043040170600000430406PA7941382025-07-11False
17060000043048L17/dossiers1717060000043040170600000430407PA7955882025-07-11False
17060000043049L17/dossiers1717060000043040170600000430408PA7950842025-07-11False
17060000043050L17/dossiers1717060000043040170600000430409PA8421052025-07-11False
17060000043051L17/dossiers17170600000430401706000004304010PA8416572025-07-11False
17060000043052L17/dossiers17170600000430401706000004304011PA7204302025-07-11False
17060000043053L17/dossiers17170600000430401706000004304012PA7937722025-07-11False
17060000043054L17/dossiers17170600000430401706000004304013PA7956162025-07-11False
17060000043055L17/dossiers17170600000430401706000004304014PA7934442025-07-11False