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
17060000017207L17/dossiers17170600000171591706000001715947PA6081722024-10-29False
17060000017208L17/dossiers17170600000171591706000001715948PA6075532024-10-29False
17060000017209L17/dossiers17170600000171591706000001715949PA8409552024-10-29False
17060000017210L17/dossiers17170600000171591706000001715950PA8413672024-10-29False
17060000017211L17/dossiers17170600000171591706000001715951PA3419812024-10-29False
17060000017212L17/dossiers17170600000171591706000001715952PA8406732024-10-29False
17060000017213L17/dossiers17170600000171591706000001715953PA3421962024-10-29False
17060000017214L17/dossiers17170600000171591706000001715954PA8266352024-10-29False
17060000017215L17/dossiers17170600000171591706000001715955PA8413272024-10-29False
17060000017216L17/dossiers17170600000171591706000001715956PA8417172024-10-29False
17060000017217L17/dossiers17170600000171591706000001715957PA8412432024-10-29False
17060000017218L17/dossiers17170600000171591706000001715958PA7749602024-10-29False
17060000017219L17/dossiers17170600000171591706000001715959PA3403432024-10-29False
17060000017220L17/dossiers17170600000171591706000001715960PA8410912024-10-29False
17060000017221L17/dossiers17170600000171591706000001715961PA8416812024-10-29False
17060000017222L17/dossiers17170600000171591706000001715962PA8418932024-10-29False
17060000017223L17/dossiers17170600000171591706000001715963PA7938162024-10-29False
17060000017224L17/dossiers17170600000171591706000001715964PA7944942024-10-29False
17060000017225L17/dossiers17170600000171591706000001715965PA7209922024-10-29False
17060000017229L17/dossiers1717060000017227170600000172271PA6431432024-10-29False
17060000017230L17/dossiers1717060000017227170600000172272PA8422112024-10-29False
17060000017231L17/dossiers1717060000017227170600000172273PA7957622024-10-29False
17060000017232L17/dossiers1717060000017227170600000172274PA6431572024-10-29False
17060000017233L17/dossiers1717060000017227170600000172275PA7209922024-10-29False
17060000017234L17/dossiers1717060000017227170600000172276PA8406652024-10-29False
17060000017235L17/dossiers1717060000017227170600000172277PA6427642024-10-29False
17060000017236L17/dossiers1717060000017227170600000172278PA8408292024-10-29False
17060000017237L17/dossiers1717060000017227170600000172279PA3424152024-10-29False
17060000017238L17/dossiers17170600000172271706000001722710PA6067932024-10-29False
17060000017239L17/dossiers17170600000172271706000001722711PA8413152024-10-29False
17060000017240L17/dossiers17170600000172271706000001722712PA7940942024-10-29False
17060000017241L17/dossiers17170600000172271706000001722713PA7936242024-10-29False
17060000017242L17/dossiers17170600000172271706000001722714PA6082642024-10-29False
17060000017243L17/dossiers17170600000172271706000001722715PA8409032024-10-29False
17060000017244L17/dossiers17170600000172271706000001722716PA8412952024-10-29False
17060000017245L17/dossiers17170600000172271706000001722717PA10082024-10-29False
17060000017246L17/dossiers17170600000172271706000001722718PA7933942024-10-29False
17060000017247L17/dossiers17170600000172271706000001722719PA7954302024-10-29False
17060000017248L17/dossiers17170600000172271706000001722720PA8419192024-10-29False
17060000017249L17/dossiers17170600000172271706000001722721PA6065732024-10-29False
17060000017250L17/dossiers17170600000172271706000001722722PA8416332024-10-29False
17060000017251L17/dossiers17170600000172271706000001722723PA7948542024-10-29False
17060000017252L17/dossiers17170600000172271706000001722724PA8421952024-10-29False
17060000017253L17/dossiers17170600000172271706000001722725PA6093322024-10-29False
17060000017254L17/dossiers17170600000172271706000001722726PA8416652024-10-29False
17060000017255L17/dossiers17170600000172271706000001722727PA3332852024-10-29False
17060000017256L17/dossiers17170600000172271706000001722728PA8409392024-10-29False
17060000017257L17/dossiers17170600000172271706000001722729PA8415392024-10-29False
17060000017258L17/dossiers17170600000172271706000001722730PA3319732024-10-29False
17060000017259L17/dossiers17170600000172271706000001722731PA8401712024-10-29False