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
17060000017528L17/dossiers17170600000174711706000001747156PA8414712025-03-12False
17060000017529L17/dossiers17170600000174711706000001747157PA8419472025-03-12False
17060000017530L17/dossiers17170600000174711706000001747158PA7941462025-03-12False
17060000017531L17/dossiers17170600000174711706000001747159PA8417292025-03-12False
17060000017532L17/dossiers17170600000174711706000001747160PA7956722025-03-12False
17060000017533L17/dossiers17170600000174711706000001747161PA8415152025-03-12False
17060000017534L17/dossiers17170600000174711706000001747162PA8407652025-03-12False
17060000017535L17/dossiers17170600000174711706000001747163PA7956362025-03-12False
17060000017536L17/dossiers17170600000174711706000001747164PA7954222025-03-12False
17060000017537L17/dossiers17170600000174711706000001747165PA8412152025-03-12False
17060000017538L17/dossiers17170600000174711706000001747166PA8172112025-03-12False
17060000017539L17/dossiers17170600000174711706000001747167PA7210622025-03-12False
17060000017540L17/dossiers17170600000174711706000001747168PA7941542025-03-12False
17060000017541L17/dossiers17170600000174711706000001747169PA3419812025-03-12False
17060000017542L17/dossiers17170600000174711706000001747170PA3421962025-03-12False
17060000017543L17/dossiers17170600000174711706000001747171PA6065452025-03-12False
17060000017544L17/dossiers17170600000174711706000001747172PA8406732025-03-12False
17060000017545L17/dossiers17170600000174711706000001747173PA7221422025-03-12False
17060000017546L17/dossiers17170600000174711706000001747174PA3403432025-03-12False
17060000017547L17/dossiers17170600000174711706000001747175PA8410912025-03-12False
17060000017548L17/dossiers17170600000174711706000001747176PA7937442025-03-12False
17060000017549L17/dossiers17170600000174711706000001747177PA7941662025-03-12False
17060000017550L17/dossiers17170600000174711706000001747178PA8417132025-03-12False
17060000017557L17/dossiers1717060000017555170600000175551PA8413672025-03-07False
17060000017558L17/dossiers1717060000017555170600000175552PA8406652025-03-07False
17060000017559L17/dossiers1717060000017555170600000175553PA6427642025-03-07False
17060000017560L17/dossiers1717060000017555170600000175554PA6431432025-03-07False
17060000017561L17/dossiers1717060000017555170600000175555PA8408292025-03-07False
17060000017562L17/dossiers1717060000017555170600000175556PA3424152025-03-07False
17060000017563L17/dossiers1717060000017555170600000175557PA6067932025-03-07False
17060000017564L17/dossiers1717060000017555170600000175558PA8422112025-03-07False
17060000017565L17/dossiers1717060000017555170600000175559PA8413152025-03-07False
17060000017566L17/dossiers17170600000175551706000001755510PA7940942025-03-07False
17060000017567L17/dossiers17170600000175551706000001755511PA7936242025-03-07False
17060000017568L17/dossiers17170600000175551706000001755512PA7957622025-03-07False
17060000017569L17/dossiers17170600000175551706000001755513PA6082642025-03-07False
17060000017570L17/dossiers17170600000175551706000001755514PA8409032025-03-07False
17060000017571L17/dossiers17170600000175551706000001755515PA8412952025-03-07False
17060000017572L17/dossiers17170600000175551706000001755516PA10082025-03-07False
17060000017573L17/dossiers17170600000175551706000001755517PA7933942025-03-07False
17060000017574L17/dossiers17170600000175551706000001755518PA7954302025-03-07False
17060000017575L17/dossiers17170600000175551706000001755519PA8419192025-03-07False
17060000017576L17/dossiers17170600000175551706000001755520PA6065732025-03-07False
17060000017577L17/dossiers17170600000175551706000001755521PA8416332025-03-07False
17060000017578L17/dossiers17170600000175551706000001755522PA7948542025-03-07False
17060000017579L17/dossiers17170600000175551706000001755523PA8421952025-03-07False
17060000017580L17/dossiers17170600000175551706000001755524PA6093322025-03-07False
17060000017581L17/dossiers17170600000175551706000001755525PA8416652025-03-07False
17060000017582L17/dossiers17170600000175551706000001755526PA3332852025-03-07False
17060000017583L17/dossiers17170600000175551706000001755527PA8409392025-03-07False