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
17060000036748L17/dossiers171706000003663717060000036637110PA7932622026-03-24False
17060000036749L17/dossiers171706000003663717060000036637111PA8410232026-03-24False
17060000036750L17/dossiers171706000003663717060000036637112PA8412152026-03-24False
17060000036751L17/dossiers171706000003663717060000036637113PA7212702026-03-24False
17060000036755L17/dossiers1717060000036753170600000367531PA7188842025-05-23False
17060000036756L17/dossiers1717060000036753170600000367532PA7199682025-05-23False
17060000036757L17/dossiers1717060000036753170600000367533PA2667932025-05-23False
17060000036758L17/dossiers1717060000036753170600000367534PA7218162025-05-23False
17060000036759L17/dossiers1717060000036753170600000367535PA3422402025-05-23False
17060000036760L17/dossiers1717060000036753170600000367536PA3300082025-05-23False
17060000036761L17/dossiers1717060000036753170600000367537PA7188382025-05-23False
17060000036762L17/dossiers1717060000036753170600000367538PA7188502025-05-23False
17060000036763L17/dossiers1717060000036753170600000367539PA7223902025-05-23False
17060000036764L17/dossiers17170600000367531706000003675310PA3325232025-05-23False
17060000036765L17/dossiers17170600000367531706000003675311PA7940422025-05-23False
17060000036766L17/dossiers17170600000367531706000003675312PA7120152025-05-23False
17060000036767L17/dossiers17170600000367531706000003675313PA13272025-05-23False
17060000036768L17/dossiers17170600000367531706000003675314PA6084162025-05-132025-05-23False
17060000036769L17/dossiers17170600000367531706000003675315PA8409792025-05-23False
17060000036770L17/dossiers17170600000367531706000003675316PA6060982025-05-23False
17060000036771L17/dossiers17170600000367531706000003675317PA7949942025-05-23False
17060000036772L17/dossiers17170600000367531706000003675318PA7930942025-05-23False
17060000036773L17/dossiers17170600000367531706000003675319PA7941782025-05-23False
17060000036777L17/dossiers1717060000036775170600000367751PA8410672025-05-13False
17060000036778L17/dossiers1717060000036775170600000367752PA8412072025-05-13False
17060000036779L17/dossiers1717060000036775170600000367753PA7961182025-05-13False
17060000036780L17/dossiers1717060000036775170600000367754PA7945622025-05-13False
17060000036781L17/dossiers1717060000036775170600000367755PA7932382025-05-13False
17060000036782L17/dossiers1717060000036775170600000367756PA7933742025-05-13False
17060000036783L17/dossiers1717060000036775170600000367757PA7931582025-05-13False
17060000036784L17/dossiers1717060000036775170600000367758PA8416452025-05-13False
17060000036785L17/dossiers1717060000036775170600000367759PA7206682025-05-13False
17060000036786L17/dossiers17170600000367751706000003677510PA7948862025-05-13False
17060000036787L17/dossiers17170600000367751706000003677511PA7960422025-05-13False
17060000036788L17/dossiers17170600000367751706000003677512PA8414872025-05-13False
17060000036789L17/dossiers17170600000367751706000003677513PA8411312025-05-13False
17060000036790L17/dossiers17170600000367751706000003677514PA7931342025-05-13False
17060000036791L17/dossiers17170600000367751706000003677515PA8407012025-05-13False
17060000036792L17/dossiers17170600000367751706000003677516PA8407212025-05-13False
17060000036793L17/dossiers17170600000367751706000003677517PA7204682025-05-13False
17060000036794L17/dossiers17170600000367751706000003677518PA7935482025-05-13False
17060000036795L17/dossiers17170600000367751706000003677519PA7956442025-05-13False
17060000036796L17/dossiers17170600000367751706000003677520PA7947622025-05-13False
17060000036797L17/dossiers17170600000367751706000003677521PA7931462025-05-13False
17060000036798L17/dossiers17170600000367751706000003677522PA8401352025-05-13False
17060000036799L17/dossiers17170600000367751706000003677523PA8420732025-05-13False
17060000036800L17/dossiers17170600000367751706000003677524PA8417612025-05-13False
17060000036801L17/dossiers17170600000367751706000003677525PA7932462025-05-13False
17060000036802L17/dossiers17170600000367751706000003677526PA8407732025-05-13False
17060000036803L17/dossiers17170600000367751706000003677527PA8411392025-05-13False