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
17060000023289L17/dossiers17170600000232311706000002323157PA7958082025-02-11False
17060000023290L17/dossiers17170600000232311706000002323158PA7960182025-02-11False
17060000023291L17/dossiers17170600000232311706000002323159PA7362012025-02-11False
17060000023292L17/dossiers17170600000232311706000002323160PA7937962025-02-11False
17060000023293L17/dossiers17170600000232311706000002323161PA7941662025-02-11False
17060000023294L17/dossiers17170600000232311706000002323162PA8417132025-02-11False
17060000023295L17/dossiers17170600000232311706000002323163PA8418932025-02-11False
17060000023296L17/dossiers17170600000232311706000002323164PA7939482025-02-11False
17060000023297L17/dossiers17170600000232311706000002323165PA7951642025-02-11False
17060000023298L17/dossiers17170600000232311706000002323166PA29402025-02-11False
17060000023302L17/dossiers1717060000023300170600000233001PA6109682025-01-07False
17060000023303L17/dossiers1717060000023300170600000233002PA7937802025-01-07False
17060000023304L17/dossiers1717060000023300170600000233003PA5888842025-01-07False
17060000023305L17/dossiers1717060000023300170600000233004PA8417012025-01-07False
17060000023306L17/dossiers1717060000023300170600000233005PA3359992025-01-07False
17060000023307L17/dossiers1717060000023300170600000233006PA7953622025-01-07False
17060000023308L17/dossiers1717060000023300170600000233007PA7954542025-01-07False
17060000023309L17/dossiers1717060000023300170600000233008PA8409972025-01-07False
17060000023310L17/dossiers1717060000023300170600000233009PA8418852025-01-07False
17060000023311L17/dossiers17170600000233001706000002330010PA8415072025-01-07False
17060000023312L17/dossiers17170600000233001706000002330011PA7940082025-01-07False
17060000023313L17/dossiers17170600000233001706000002330012PA7212102025-01-07False
17060000023314L17/dossiers17170600000233001706000002330013PA7934522025-01-07False
17060000023315L17/dossiers17170600000233001706000002330014PA8413512025-01-07False
17060000023316L17/dossiers17170600000233001706000002330015PA7939802025-01-07False
17060000023317L17/dossiers17170600000233001706000002330016PA7950102025-01-07False
17060000023318L17/dossiers17170600000233001706000002330017PA8414192025-01-07False
17060000023319L17/dossiers17170600000233001706000002330018PA8420132025-01-07False
17060000023320L17/dossiers17170600000233001706000002330019PA8409472025-01-07False
17060000023321L17/dossiers17170600000233001706000002330020PA7940222025-01-07False
17060000023322L17/dossiers17170600000233001706000002330021PA7941462025-01-07False
17060000023323L17/dossiers17170600000233001706000002330022PA8412232025-01-07False
17060000023324L17/dossiers17170600000233001706000002330023PA7956362025-01-07False
17060000023325L17/dossiers17170600000233001706000002330024PA8420452025-01-07False
17060000023326L17/dossiers17170600000233001706000002330025PA7937082025-01-07False
17060000023327L17/dossiers17170600000233001706000002330026PA7936642025-01-07False
17060000023328L17/dossiers17170600000233001706000002330027PA7941542025-01-07False
17060000023329L17/dossiers17170600000233001706000002330028PA7947782025-01-07False
17060000023330L17/dossiers17170600000233001706000002330029PA6065452025-01-07False
17060000023331L17/dossiers17170600000233001706000002330030PA7950762025-01-07False
17060000023332L17/dossiers17170600000233001706000002330031PA7221422025-01-07False
17060000023333L17/dossiers17170600000233001706000002330032PA6100022025-01-07False
17060000023334L17/dossiers17170600000233001706000002330033PA7958082025-01-07False
17060000023335L17/dossiers17170600000233001706000002330034PA7960182025-01-07False
17060000023336L17/dossiers17170600000233001706000002330035PA8417132025-01-07False
17060000023337L17/dossiers17170600000233001706000002330036PA7939482025-01-07False
17060000023338L17/dossiers17170600000233001706000002330037PA29402025-01-07False
17060000023342L17/dossiers1717060000023340170600000233401PA6109682025-01-07False
17060000023343L17/dossiers1717060000023340170600000233402PA7937802025-01-07False
17060000023344L17/dossiers1717060000023340170600000233403PA5888842025-01-07False