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
17060000015500L17/dossiers17170600000154271706000001542772PA7959622025-05-02False
17060000015501L17/dossiers17170600000154271706000001542773PA7957222025-05-02False
17060000015502L17/dossiers17170600000154271706000001542774PA7196322025-05-02False
17060000015503L17/dossiers17170600000154271706000001542775PA7219162025-05-02False
17060000015504L17/dossiers17170600000154271706000001542776PA3357582025-05-02False
17060000015505L17/dossiers17170600000154271706000001542777PA7200662025-05-02False
17060000015506L17/dossiers17170600000154271706000001542778PA7222522025-05-02False
17060000015507L17/dossiers17170600000154271706000001542779PA7955282025-05-02False
17060000015508L17/dossiers17170600000154271706000001542780PA7958882025-05-02False
17060000015509L17/dossiers17170600000154271706000001542781PA8419272025-04-302025-05-02False
17060000015510L17/dossiers17170600000154271706000001542782PA7932702025-05-02False
17060000015511L17/dossiers17170600000154271706000001542783PA7572252025-05-02False
17060000015512L17/dossiers17170600000154271706000001542784PA7934162025-05-02False
17060000015513L17/dossiers17170600000154271706000001542785PA7948022025-05-02False
17060000015514L17/dossiers17170600000154271706000001542786PA7201902025-05-02False
17060000015515L17/dossiers17170600000154271706000001542787PA7944862025-05-02False
17060000015516L17/dossiers17170600000154271706000001542788PA7195502025-05-02False
17060000015517L17/dossiers17170600000154271706000001542789PA7215842025-05-02False
17060000015518L17/dossiers17170600000154271706000001542790PA6073952025-05-02False
17060000015519L17/dossiers17170600000154271706000001542791PA7221022025-05-02False
17060000015520L17/dossiers17170600000154271706000001542792PA7195122025-05-02False
17060000015521L17/dossiers17170600000154271706000001542793PA7211702025-05-02False
17060000015522L17/dossiers17170600000154271706000001542794PA29602025-05-02False
17060000015523L17/dossiers17170600000154271706000001542795PA7950462025-05-02False
17060000015527L17/dossiers1717060000015525170600000155251PA7959502025-01-27False
17060000015528L17/dossiers1717060000015525170600000155252PA7211582025-01-27False
17060000015529L17/dossiers1717060000015525170600000155253PA7951442025-01-27False
17060000015530L17/dossiers1717060000015525170600000155254PA7221902025-01-27False
17060000015531L17/dossiers1717060000015525170600000155255PA6429352025-01-27False
17060000015532L17/dossiers1717060000015525170600000155256PA7203622025-01-27False
17060000015533L17/dossiers1717060000015525170600000155257PA7220462025-01-27False
17060000015534L17/dossiers1717060000015525170600000155258PA7192182025-01-27False
17060000015535L17/dossiers1717060000015525170600000155259PA7171612025-01-27False
17060000015536L17/dossiers17170600000155251706000001552510PA6426952025-01-27False
17060000015537L17/dossiers17170600000155251706000001552511PA6065072025-01-27False
17060000015538L17/dossiers17170600000155251706000001552512PA7959902025-01-27False
17060000015539L17/dossiers17170600000155251706000001552513PA7943302025-01-27False
17060000015540L17/dossiers17170600000155251706000001552514PA7198902025-01-27False
17060000015541L17/dossiers17170600000155251706000001552515PA7220002025-01-27False
17060000015542L17/dossiers17170600000155251706000001552516PA7947982025-01-27False
17060000015543L17/dossiers17170600000155251706000001552517PA7217502025-01-27False
17060000015544L17/dossiers17170600000155251706000001552518PA7953302025-01-27False
17060000015545L17/dossiers17170600000155251706000001552519PA8418012025-01-27False
17060000015546L17/dossiers17170600000155251706000001552520PA8423112025-01-27False
17060000015547L17/dossiers17170600000155251706000001552521PA7199222025-01-27False
17060000015548L17/dossiers17170600000155251706000001552522PA7194722025-01-27False
17060000015549L17/dossiers17170600000155251706000001552523PA7958642025-01-27False
17060000015550L17/dossiers17170600000155251706000001552524PA7959082025-01-27False
17060000015551L17/dossiers17170600000155251706000001552525PA7191182025-01-27False
17060000015552L17/dossiers17170600000155251706000001552526PA6078462025-01-27False