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
17060000031926L17/dossiers1717060000031919170600000319196PA7937962025-04-24False
17060000031927L17/dossiers1717060000031919170600000319197PA6431752025-04-24False
17060000031928L17/dossiers1717060000031919170600000319198PA7201002025-04-24False
17060000031929L17/dossiers1717060000031919170600000319199PA8419312025-04-24False
17060000031930L17/dossiers17170600000319191706000003191910PA7214742025-04-24False
17060000031931L17/dossiers17170600000319191706000003191911PA7940222025-04-24False
17060000031932L17/dossiers17170600000319191706000003191912PA8416812025-04-24False
17060000031939L17/dossiers1717060000031937170600000319371PA7937562025-04-04False
17060000031940L17/dossiers1717060000031937170600000319372PA7208922025-04-04False
17060000031941L17/dossiers1717060000031937170600000319373PA7952282025-04-04False
17060000031942L17/dossiers1717060000031937170600000319374PA7932622025-04-04False
17060000031943L17/dossiers1717060000031937170600000319375PA7949062025-04-04False
17060000031944L17/dossiers1717060000031937170600000319376PA7941382025-04-04False
17060000031945L17/dossiers1717060000031937170600000319377PA7955882025-04-04False
17060000031946L17/dossiers1717060000031937170600000319378PA7950842025-04-04False
17060000031947L17/dossiers1717060000031937170600000319379PA8421052025-04-04False
17060000031948L17/dossiers17170600000319371706000003193710PA8416572025-04-04False
17060000031949L17/dossiers17170600000319371706000003193711PA7204302025-04-04False
17060000031950L17/dossiers17170600000319371706000003193712PA7937722025-04-04False
17060000031951L17/dossiers17170600000319371706000003193713PA7956162025-04-04False
17060000031952L17/dossiers17170600000319371706000003193714PA7934442025-04-04False
17060000031953L17/dossiers17170600000319371706000003193715PA7949382025-04-04False
17060000031954L17/dossiers17170600000319371706000003193716PA7953182025-04-04False
17060000031955L17/dossiers17170600000319371706000003193717PA8410232025-04-04False
17060000031956L17/dossiers17170600000319371706000003193718PA7960902025-04-04False
17060000031957L17/dossiers17170600000319371706000003193719PA7939122025-04-04False
17060000031958L17/dossiers17170600000319371706000003193720PA8421872025-04-04False
17060000031959L17/dossiers17170600000319371706000003193721PA8420372025-04-04False
17060000031960L17/dossiers17170600000319371706000003193722PA7918122025-04-04False
17060000031961L17/dossiers17170600000319371706000003193723PA7937362025-04-04False
17060000031962L17/dossiers17170600000319371706000003193724PA7212022025-04-04False
17060000031963L17/dossiers17170600000319371706000003193725PA7951362025-04-04False
17060000031964L17/dossiers17170600000319371706000003193726PA7934642025-04-04False
17060000031965L17/dossiers17170600000319371706000003193727PA8421552025-04-04False
17060000031966L17/dossiers17170600000319371706000003193728PA7952002025-04-04False
17060000031967L17/dossiers17170600000319371706000003193729PA7958442025-04-04False
17060000031968L17/dossiers17170600000319371706000003193730PA8412512025-04-04False
17060000031969L17/dossiers17170600000319371706000003193731PA7947862025-04-04False
17060000031970L17/dossiers17170600000319371706000003193732PA7948702025-04-04False
17060000031971L17/dossiers17170600000319371706000003193733PA7960702025-04-04False
17060000031972L17/dossiers17170600000319371706000003193734PA7953102025-04-04False
17060000031973L17/dossiers17170600000319371706000003193735PA7944782025-04-04False
17060000031974L17/dossiers17170600000319371706000003193736PA8419472025-04-04False
17060000031975L17/dossiers17170600000319371706000003193737PA7940822025-04-04False
17060000031976L17/dossiers17170600000319371706000003193738PA7941302025-04-04False
17060000031977L17/dossiers17170600000319371706000003193739PA7208462025-04-04False
17060000031978L17/dossiers17170600000319371706000003193740PA8417292025-04-04False
17060000031979L17/dossiers17170600000319371706000003193741PA7955162025-04-04False
17060000031980L17/dossiers17170600000319371706000003193742PA7956722025-04-04False
17060000031981L17/dossiers17170600000319371706000003193743PA7957462025-04-04False