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
17060000024745L17/dossiers1717060000024740170600000247404PA7201622025-02-06False
17060000024746L17/dossiers1717060000024740170600000247405PA7213362025-02-06False
17060000024747L17/dossiers1717060000024740170600000247406PA7935202025-02-06False
17060000024748L17/dossiers1717060000024740170600000247407PA7937162025-02-06False
17060000024749L17/dossiers1717060000024740170600000247408PA7199142025-02-06False
17060000024750L17/dossiers1717060000024740170600000247409PA7931222025-02-06False
17060000024751L17/dossiers17170600000247401706000002474010PA6056942025-02-06False
17060000024752L17/dossiers17170600000247401706000002474011PA7951202025-02-06False
17060000024753L17/dossiers17170600000247401706000002474012PA7199382025-02-06False
17060000024754L17/dossiers17170600000247401706000002474013PA7222842025-02-06False
17060000024755L17/dossiers17170600000247401706000002474014PA7205602025-02-06False
17060000024756L17/dossiers17170600000247401706000002474015PA2673182025-02-06False
17060000024757L17/dossiers17170600000247401706000002474016PA7952582025-02-06False
17060000024758L17/dossiers17170600000247401706000002474017PA7223742025-02-06False
17060000024759L17/dossiers17170600000247401706000002474018PA7200382025-02-06False
17060000024760L17/dossiers17170600000247401706000002474019PA7219842025-02-06False
17060000024761L17/dossiers17170600000247401706000002474020PA7953742025-02-06False
17060000024762L17/dossiers17170600000247401706000002474021PA7947022025-02-06False
17060000024763L17/dossiers17170600000247401706000002474022PA7941142025-02-06False
17060000024764L17/dossiers17170600000247401706000002474023PA7951002025-02-06False
17060000024765L17/dossiers17170600000247401706000002474024PA7207282025-02-06False
17060000024766L17/dossiers17170600000247401706000002474025PA7196402025-02-06False
17060000024767L17/dossiers17170600000247401706000002474026PA7948102025-02-06False
17060000024768L17/dossiers17170600000247401706000002474027PA7948302025-02-06False
17060000024769L17/dossiers17170600000247401706000002474028PA7203342025-02-06False
17060000024770L17/dossiers17170600000247401706000002474029PA7211822025-02-06False
17060000024771L17/dossiers17170600000247401706000002474030PA7212342025-02-06False
17060000024772L17/dossiers17170600000247401706000002474031PA7207202025-02-06False
17060000024773L17/dossiers17170600000247401706000002474032PA7200922025-02-06False
17060000024774L17/dossiers17170600000247401706000002474033PA7198222025-02-06False
17060000024775L17/dossiers17170600000247401706000002474034PA7221622025-02-06False
17060000024776L17/dossiers17170600000247401706000002474035PA3315822025-02-06False
17060000024777L17/dossiers17170600000247401706000002474036PA7218442025-02-06False
17060000024781L17/dossiers1717060000024779170600000247791PA7195582025-04-10False
17060000024782L17/dossiers1717060000024779170600000247792PA8051662025-04-10False
17060000024783L17/dossiers1717060000024779170600000247793PA7220002025-04-10False
17060000024784L17/dossiers1717060000024779170600000247794PA7949822025-04-10False
17060000024785L17/dossiers1717060000024779170600000247795PA7946582025-04-10False
17060000024786L17/dossiers1717060000024779170600000247796PA6056942025-04-10False
17060000024787L17/dossiers1717060000024779170600000247797PA8402352025-04-10False
17060000024788L17/dossiers1717060000024779170600000247798PA2673182025-04-10False
17060000024789L17/dossiers1717060000024779170600000247799PA8418532025-04-10False
17060000024790L17/dossiers17170600000247791706000002477910PA7953742025-04-10False
17060000024791L17/dossiers17170600000247791706000002477911PA8416012025-04-10False
17060000024792L17/dossiers17170600000247791706000002477912PA7947022025-04-10False
17060000024793L17/dossiers17170600000247791706000002477913PA7951002025-04-10False
17060000024794L17/dossiers17170600000247791706000002477914PA8419312025-04-10False
17060000024795L17/dossiers17170600000247791706000002477915PA7948302025-04-10False
17060000024796L17/dossiers17170600000247791706000002477916PA7211822025-04-10False
17060000024797L17/dossiers17170600000247791706000002477917PA7218442025-04-10False