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 151 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
17060000014546L17/dossiers17170600000145181706000001451827PA7195782025-02-10False
17060000014547L17/dossiers17170600000145181706000001451828PA7205522025-02-10False
17060000014548L17/dossiers17170600000145181706000001451829PA7214582025-02-10False
17060000014549L17/dossiers17170600000145181706000001451830PA8266352025-02-10False
17060000014550L17/dossiers17170600000145181706000001451831PA7932702025-02-10False
17060000014551L17/dossiers17170600000145181706000001451832PA7944862025-02-10False
17060000014552L17/dossiers17170600000145181706000001451833PA7223362025-02-10False
17060000014553L17/dossiers17170600000145181706000001451834PA6073952025-02-10False
17060000014554L17/dossiers17170600000145181706000001451835PA7953502025-02-10False
17060000014555L17/dossiers17170600000145181706000001451836PA7221022025-02-10False
17060000014556L17/dossiers17170600000145181706000001451837PA7214742025-02-10False
17060000014557L17/dossiers17170600000145181706000001451838PA7950462025-02-10False
17060000014561L17/dossiers1717060000014559170600000145591PA7935722024-10-16False
17060000014562L17/dossiers1717060000014559170600000145592PA7933982024-10-16False
17060000014563L17/dossiers1717060000014559170600000145593PA7214582024-10-16False
17060000014564L17/dossiers1717060000014559170600000145594PA7202302024-10-16False
17060000014565L17/dossiers1717060000014559170600000145595PA7190522024-10-16False
17060000014566L17/dossiers1717060000014559170600000145596PA7944262024-10-16False
17060000014567L17/dossiers1717060000014559170600000145597PA7223362024-10-16False
17060000014568L17/dossiers1717060000014559170600000145598PA7952782024-10-16False
17060000014569L17/dossiers1717060000014559170600000145599PA7944702024-10-16False
17060000014570L17/dossiers17170600000145591706000001455910PA7205522024-10-16False
17060000014571L17/dossiers17170600000145591706000001455911PA7218442024-10-16False
17060000014572L17/dossiers17170600000145591706000001455912PA7220702024-10-16False
17060000014573L17/dossiers17170600000145591706000001455913PA7197782024-10-16False
17060000014574L17/dossiers17170600000145591706000001455914PA7950262024-10-16False
17060000014575L17/dossiers17170600000145591706000001455915PA7201382024-10-16False
17060000014576L17/dossiers17170600000145591706000001455916PA7953502024-10-16False
17060000014577L17/dossiers17170600000145591706000001455917PA2677802024-10-16False
17060000014578L17/dossiers17170600000145591706000001455918PA7948382024-10-16False
17060000014579L17/dossiers17170600000145591706000001455919PA8414312024-10-16False
17060000014583L17/dossiers1717060000014581170600000145811PA7203862024-10-28False
17060000014584L17/dossiers1717060000014581170600000145812PA7214422024-10-28False
17060000014585L17/dossiers1717060000014581170600000145813PA7930942024-10-28False
17060000014586L17/dossiers1717060000014581170600000145814PA7188842024-10-28False
17060000014587L17/dossiers1717060000014581170600000145815PA7199682024-10-28False
17060000014588L17/dossiers1717060000014581170600000145816PA7218162024-10-28False
17060000014589L17/dossiers1717060000014581170600000145817PA6088262024-10-28False
17060000014590L17/dossiers1717060000014581170600000145818PA16302024-10-28False
17060000014591L17/dossiers1717060000014581170600000145819PA3467822024-10-28False
17060000014592L17/dossiers17170600000145811706000001458110PA6060982024-10-28False
17060000014593L17/dossiers17170600000145811706000001458111PA2668082024-10-28False
17060000014594L17/dossiers17170600000145811706000001458112PA6428472024-10-28False
17060000014595L17/dossiers17170600000145811706000001458113PA3422402024-10-28False
17060000014596L17/dossiers17170600000145811706000001458114PA7188382024-10-28False
17060000014597L17/dossiers17170600000145811706000001458115PA13272024-10-28False
17060000014598L17/dossiers17170600000145811706000001458116PA8409792024-10-28False
17060000014599L17/dossiers17170600000145811706000001458117PA6080162024-10-28False
17060000014600L17/dossiers17170600000145811706000001458118PA7192722024-10-28False
17060000014601L17/dossiers17170600000145811706000001458119PA2677942024-10-28False