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
17060000051502L17/dossiers1717060000051493170600000514938PA8421052025-12-18False
17060000051503L17/dossiers1717060000051493170600000514939PA8416572025-12-18False
17060000051504L17/dossiers17170600000514931706000005149310PA7204302025-12-18False
17060000051505L17/dossiers17170600000514931706000005149311PA7937722025-12-18False
17060000051506L17/dossiers17170600000514931706000005149312PA7956162025-12-18False
17060000051507L17/dossiers17170600000514931706000005149313PA7934442025-12-18False
17060000051508L17/dossiers17170600000514931706000005149314PA7949382025-12-18False
17060000051509L17/dossiers17170600000514931706000005149315PA7953182025-12-18False
17060000051510L17/dossiers17170600000514931706000005149316PA8410232025-12-18False
17060000051511L17/dossiers17170600000514931706000005149317PA7960902025-12-18False
17060000051512L17/dossiers17170600000514931706000005149318PA7939122025-12-18False
17060000051513L17/dossiers17170600000514931706000005149319PA8421872025-12-18False
17060000051514L17/dossiers17170600000514931706000005149320PA8420372025-12-18False
17060000051515L17/dossiers17170600000514931706000005149321PA7918122025-12-18False
17060000051516L17/dossiers17170600000514931706000005149322PA7937362025-12-18False
17060000051517L17/dossiers17170600000514931706000005149323PA7212022025-12-18False
17060000051518L17/dossiers17170600000514931706000005149324PA7951362025-12-18False
17060000051519L17/dossiers17170600000514931706000005149325PA7934642025-12-18False
17060000051520L17/dossiers17170600000514931706000005149326PA8421552025-12-18False
17060000051521L17/dossiers17170600000514931706000005149327PA7952002025-12-18False
17060000051522L17/dossiers17170600000514931706000005149328PA7958442025-12-18False
17060000051523L17/dossiers17170600000514931706000005149329PA8412512025-12-18False
17060000051524L17/dossiers17170600000514931706000005149330PA7947862025-12-18False
17060000051525L17/dossiers17170600000514931706000005149331PA7948702025-12-18False
17060000051526L17/dossiers17170600000514931706000005149332PA7960702025-12-18False
17060000051527L17/dossiers17170600000514931706000005149333PA7953102025-12-18False
17060000051528L17/dossiers17170600000514931706000005149334PA7944782025-12-18False
17060000051529L17/dossiers17170600000514931706000005149335PA8419472025-12-18False
17060000051530L17/dossiers17170600000514931706000005149336PA7940822025-12-18False
17060000051531L17/dossiers17170600000514931706000005149337PA7941302025-12-18False
17060000051532L17/dossiers17170600000514931706000005149338PA7208462025-12-18False
17060000051533L17/dossiers17170600000514931706000005149339PA8417292025-12-18False
17060000051534L17/dossiers17170600000514931706000005149340PA7955162025-12-18False
17060000051535L17/dossiers17170600000514931706000005149341PA7956722025-12-18False
17060000051536L17/dossiers17170600000514931706000005149342PA7957462025-12-18False
17060000051537L17/dossiers17170600000514931706000005149343PA7951082025-12-18False
17060000051538L17/dossiers17170600000514931706000005149344PA8415152025-12-18False
17060000051539L17/dossiers17170600000514931706000005149345PA7952982025-12-18False
17060000051540L17/dossiers17170600000514931706000005149346PA7918242025-12-18False
17060000051541L17/dossiers17170600000514931706000005149347PA8420292025-12-18False
17060000051542L17/dossiers17170600000514931706000005149348PA7935322025-12-18False
17060000051543L17/dossiers17170600000514931706000005149349PA3423842025-12-18False
17060000051544L17/dossiers17170600000514931706000005149350PA7954222025-12-18False
17060000051545L17/dossiers17170600000514931706000005149351PA7946862025-12-18False
17060000051546L17/dossiers17170600000514931706000005149352PA8412152025-12-18False
17060000051547L17/dossiers17170600000514931706000005149353PA7954822025-12-18False
17060000051548L17/dossiers17170600000514931706000005149354PA6106542025-12-18False
17060000051549L17/dossiers17170600000514931706000005149355PA8411912025-12-18False
17060000051550L17/dossiers17170600000514931706000005149356PA7938722025-12-18False
17060000051551L17/dossiers17170600000514931706000005149357PA8172112025-12-18False