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
17060000008553L17/dossiers1717060000008550170600000085502PA7199682024-09-17False
17060000008554L17/dossiers1717060000008550170600000085503PA7940582024-09-17False
17060000008555L17/dossiers1717060000008550170600000085504PA7941782024-09-17False
17060000008556L17/dossiers1717060000008550170600000085505PA7940382024-09-17False
17060000008557L17/dossiers1717060000008550170600000085506PA7930942024-09-17False
17060000008558L17/dossiers1717060000008550170600000085507PA7949942024-09-17False
17060000008559L17/dossiers1717060000008550170600000085508PA2677942024-09-17False
17060000008560L17/dossiers1717060000008550170600000085509PA6070902024-09-17False
17060000008561L17/dossiers17170600000085501706000000855010PA7935082024-09-17False
17060000008562L17/dossiers17170600000085501706000000855011PA16302024-09-17False
17060000008563L17/dossiers17170600000085501706000000855012PA7188842024-09-17False
17060000008564L17/dossiers17170600000085501706000000855013PA3422402024-09-17False
17060000008565L17/dossiers17170600000085501706000000855014PA7218162024-09-17False
17060000008566L17/dossiers17170600000085501706000000855015PA13272024-09-17False
17060000008567L17/dossiers17170600000085501706000000855016PA7214102024-09-17False
17060000008568L17/dossiers17170600000085501706000000855017PA6088262024-09-17False
17060000008569L17/dossiers17170600000085501706000000855018PA7223902024-09-17False
17060000008570L17/dossiers17170600000085501706000000855019PA2667972024-09-17False
17060000008571L17/dossiers17170600000085501706000000855020PA6060982024-09-17False
17060000008575L17/dossiers1717060000008573170600000085731PA2677632025-05-14False
17060000008576L17/dossiers1717060000008573170600000085732PA7952782025-05-14False
17060000008577L17/dossiers1717060000008573170600000085733PA8051662025-05-14False
17060000008578L17/dossiers1717060000008573170600000085734PA7199682025-05-14False
17060000008579L17/dossiers1717060000008573170600000085735PA8413392025-05-14False
17060000008580L17/dossiers1717060000008573170600000085736PA7943302025-05-14False
17060000008581L17/dossiers1717060000008573170600000085737PA8408172025-05-14False
17060000008582L17/dossiers1717060000008573170600000085738PA7945542025-05-14False
17060000008583L17/dossiers1717060000008573170600000085739PA7194722025-05-14False
17060000008584L17/dossiers17170600000085731706000000857310PA8414312025-05-14False
17060000008585L17/dossiers17170600000085731706000000857311PA7192862025-05-14False
17060000008586L17/dossiers17170600000085731706000000857312PA7223902025-05-14False
17060000008587L17/dossiers17170600000085731706000000857313PA7935202025-05-14False
17060000008588L17/dossiers17170600000085731706000000857314PA7931222025-05-14False
17060000008589L17/dossiers17170600000085731706000000857315PA6088262025-05-14False
17060000008590L17/dossiers17170600000085731706000000857316PA7946582025-05-14False
17060000008591L17/dossiers17170600000085731706000000857317PA6056942025-05-14False
17060000008592L17/dossiers17170600000085731706000000857318PA2677802025-05-14False
17060000008593L17/dossiers17170600000085731706000000857319PA13272025-05-14False
17060000008594L17/dossiers17170600000085731706000000857320PA8402352025-05-14False
17060000008595L17/dossiers17170600000085731706000000857321PA7944702025-05-14False
17060000008596L17/dossiers17170600000085731706000000857322PA7942342025-05-14False
17060000008597L17/dossiers17170600000085731706000000857323PA2673182025-05-14False
17060000008598L17/dossiers17170600000085731706000000857324PA15922025-05-14False
17060000008599L17/dossiers17170600000085731706000000857325PA7200382025-05-14False
17060000008600L17/dossiers17170600000085731706000000857326PA7192822025-05-14False
17060000008601L17/dossiers17170600000085731706000000857327PA8416932025-05-14False
17060000008602L17/dossiers17170600000085731706000000857328PA7952442025-05-14False
17060000008603L17/dossiers17170600000085731706000000857329PA7947022025-05-14False
17060000008604L17/dossiers17170600000085731706000000857330PA7942062025-05-14False
17060000008605L17/dossiers17170600000085731706000000857331PA6060982025-05-14False