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
17060000032515L17/dossiers1717060000032509170600000325095PA7953622025-05-06False
17060000032516L17/dossiers1717060000032509170600000325096PA7954542025-05-06False
17060000032517L17/dossiers1717060000032509170600000325097PA8409972025-05-06False
17060000032518L17/dossiers1717060000032509170600000325098PA8418852025-05-06False
17060000032519L17/dossiers1717060000032509170600000325099PA7940082025-05-06False
17060000032520L17/dossiers17170600000325091706000003250910PA7212102025-05-06False
17060000032521L17/dossiers17170600000325091706000003250911PA8413512025-05-06False
17060000032522L17/dossiers17170600000325091706000003250912PA7939802025-05-06False
17060000032523L17/dossiers17170600000325091706000003250913PA7950102025-05-06False
17060000032524L17/dossiers17170600000325091706000003250914PA8414192025-05-06False
17060000032525L17/dossiers17170600000325091706000003250915PA8420132025-05-06False
17060000032526L17/dossiers17170600000325091706000003250916PA8409472025-05-06False
17060000032527L17/dossiers17170600000325091706000003250917PA7940222025-05-06False
17060000032528L17/dossiers17170600000325091706000003250918PA7941462025-05-06False
17060000032529L17/dossiers17170600000325091706000003250919PA8412232025-05-06False
17060000032530L17/dossiers17170600000325091706000003250920PA7956362025-05-06False
17060000032531L17/dossiers17170600000325091706000003250921PA8420452025-05-06False
17060000032532L17/dossiers17170600000325091706000003250922PA7937082025-05-06False
17060000032533L17/dossiers17170600000325091706000003250923PA7936642025-05-06False
17060000032534L17/dossiers17170600000325091706000003250924PA7941542025-05-06False
17060000032535L17/dossiers17170600000325091706000003250925PA7947782025-05-06False
17060000032536L17/dossiers17170600000325091706000003250926PA6065452025-05-06False
17060000032537L17/dossiers17170600000325091706000003250927PA7950762025-05-06False
17060000032538L17/dossiers17170600000325091706000003250928PA7221422025-05-06False
17060000032539L17/dossiers17170600000325091706000003250929PA6100022025-05-06False
17060000032540L17/dossiers17170600000325091706000003250930PA7958082025-05-06False
17060000032541L17/dossiers17170600000325091706000003250931PA7362012025-05-06False
17060000032542L17/dossiers17170600000325091706000003250932PA8417132025-05-06False
17060000032543L17/dossiers17170600000325091706000003250933PA7939482025-05-06False
17060000032544L17/dossiers17170600000325091706000003250934PA29402025-05-06False
17060000032545L17/dossiers17170600000325091706000003250935PA7946862025-05-06False
17060000032546L17/dossiers17170600000325091706000003250936PA7932622025-05-06False
17060000032547L17/dossiers17170600000325091706000003250937PA7955882025-05-06False
17060000032548L17/dossiers17170600000325091706000003250938PA8416572025-05-06False
17060000032549L17/dossiers17170600000325091706000003250939PA8410232025-05-06False
17060000032550L17/dossiers17170600000325091706000003250940PA7939122025-05-06False
17060000032551L17/dossiers17170600000325091706000003250941PA8421872025-05-06False
17060000032552L17/dossiers17170600000325091706000003250942PA7951362025-05-06False
17060000032553L17/dossiers17170600000325091706000003250943PA8421552025-05-06False
17060000032554L17/dossiers17170600000325091706000003250944PA7952002025-05-06False
17060000032555L17/dossiers17170600000325091706000003250945PA7958442025-05-06False
17060000032556L17/dossiers17170600000325091706000003250946PA7947862025-05-06False
17060000032557L17/dossiers17170600000325091706000003250947PA7960702025-05-06False
17060000032558L17/dossiers17170600000325091706000003250948PA7944782025-05-06False
17060000032559L17/dossiers17170600000325091706000003250949PA7940822025-05-06False
17060000032560L17/dossiers17170600000325091706000003250950PA8417292025-05-06False
17060000032561L17/dossiers17170600000325091706000003250951PA7955162025-05-06False
17060000032562L17/dossiers17170600000325091706000003250952PA8415152025-05-06False
17060000032563L17/dossiers17170600000325091706000003250953PA7951082025-05-06False
17060000032564L17/dossiers17170600000325091706000003250954PA7954222025-05-06False