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
17060000015786L17/dossiers1717060000015783170600000157832PA7199302024-10-16False
17060000015787L17/dossiers1717060000015783170600000157833PA8406652024-10-16False
17060000015788L17/dossiers1717060000015783170600000157834PA6427642024-10-16False
17060000015789L17/dossiers1717060000015783170600000157835PA6431432024-10-16False
17060000015790L17/dossiers1717060000015783170600000157836PA8408292024-10-16False
17060000015791L17/dossiers1717060000015783170600000157837PA3424152024-10-16False
17060000015792L17/dossiers1717060000015783170600000157838PA6067932024-10-16False
17060000015793L17/dossiers1717060000015783170600000157839PA8422112024-10-16False
17060000015794L17/dossiers17170600000157831706000001578310PA8413152024-10-16False
17060000015795L17/dossiers17170600000157831706000001578311PA7940942024-10-16False
17060000015796L17/dossiers17170600000157831706000001578312PA7936242024-10-16False
17060000015797L17/dossiers17170600000157831706000001578313PA7957622024-10-16False
17060000015798L17/dossiers17170600000157831706000001578314PA6082642024-10-16False
17060000015799L17/dossiers17170600000157831706000001578315PA8409032024-10-16False
17060000015800L17/dossiers17170600000157831706000001578316PA8412952024-10-16False
17060000015801L17/dossiers17170600000157831706000001578317PA10082024-10-16False
17060000015802L17/dossiers17170600000157831706000001578318PA7933942024-10-16False
17060000015803L17/dossiers17170600000157831706000001578319PA7954302024-10-16False
17060000015804L17/dossiers17170600000157831706000001578320PA8419192024-10-16False
17060000015805L17/dossiers17170600000157831706000001578321PA6065732024-10-16False
17060000015806L17/dossiers17170600000157831706000001578322PA8416332024-10-16False
17060000015807L17/dossiers17170600000157831706000001578323PA7948542024-10-16False
17060000015808L17/dossiers17170600000157831706000001578324PA8421952024-10-16False
17060000015809L17/dossiers17170600000157831706000001578325PA6093322024-10-16False
17060000015810L17/dossiers17170600000157831706000001578326PA8416652024-10-16False
17060000015811L17/dossiers17170600000157831706000001578327PA3332852024-10-16False
17060000015812L17/dossiers17170600000157831706000001578328PA8409392024-10-16False
17060000015813L17/dossiers17170600000157831706000001578329PA8415392024-10-16False
17060000015814L17/dossiers17170600000157831706000001578330PA3319732024-10-16False
17060000015815L17/dossiers17170600000157831706000001578331PA8401712024-10-16False
17060000015816L17/dossiers17170600000157831706000001578332PA15672024-10-16False
17060000015817L17/dossiers17170600000157831706000001578333PA8414712024-10-16False
17060000015818L17/dossiers17170600000157831706000001578334PA8422632024-10-16False
17060000015819L17/dossiers17170600000157831706000001578335PA8418532024-10-16False
17060000015820L17/dossiers17170600000157831706000001578336PA16542024-10-16False
17060000015821L17/dossiers17170600000157831706000001578337PA6431922024-10-16False
17060000015822L17/dossiers17170600000157831706000001578338PA3350542024-10-16False
17060000015823L17/dossiers17170600000157831706000001578339PA7951562024-10-16False
17060000015824L17/dossiers17170600000157831706000001578340PA8407652024-10-16False
17060000015825L17/dossiers17170600000157831706000001578341PA8414632024-10-16False
17060000015826L17/dossiers17170600000157831706000001578342PA6431572024-10-16False
17060000015827L17/dossiers17170600000157831706000001578343PA8411072024-10-16False
17060000015828L17/dossiers17170600000157831706000001578344PA8413812024-10-16False
17060000015829L17/dossiers17170600000157831706000001578345PA8407932024-10-16False
17060000015830L17/dossiers17170600000157831706000001578346PA7942702024-10-16False
17060000015831L17/dossiers17170600000157831706000001578347PA6081722024-10-16False
17060000015832L17/dossiers17170600000157831706000001578348PA6075532024-10-16False
17060000015833L17/dossiers17170600000157831706000001578349PA8409552024-10-16False
17060000015834L17/dossiers17170600000157831706000001578350PA8413672024-10-16False
17060000015835L17/dossiers17170600000157831706000001578351PA3419812024-10-16False