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
17060000014758L17/dossiers17170600000146871706000001468770PA7951642024-10-31False
17060000014759L17/dossiers17170600000146871706000001468771PA7955962024-10-31False
17060000014763L17/dossiers1717060000014761170600000147611PA7935082024-10-21False
17060000014764L17/dossiers1717060000014761170600000147612PA7188382024-10-21False
17060000014765L17/dossiers1717060000014761170600000147613PA7223902024-10-21False
17060000014766L17/dossiers1717060000014761170600000147614PA8409792024-10-21False
17060000014767L17/dossiers1717060000014761170600000147615PA7187842024-10-21False
17060000014768L17/dossiers1717060000014761170600000147616PA7933422024-10-21False
17060000014769L17/dossiers1717060000014761170600000147617PA7218162024-10-21False
17060000014770L17/dossiers1717060000014761170600000147618PA3422402024-10-21False
17060000014771L17/dossiers1717060000014761170600000147619PA3467822024-10-21False
17060000014772L17/dossiers17170600000147611706000001476110PA16302024-10-21False
17060000014773L17/dossiers17170600000147611706000001476111PA6088262024-10-21False
17060000014774L17/dossiers17170600000147611706000001476112PA2667972024-10-21False
17060000014775L17/dossiers17170600000147611706000001476113PA6080162024-10-21False
17060000014776L17/dossiers17170600000147611706000001476114PA6428472024-10-21False
17060000014777L17/dossiers17170600000147611706000001476115PA7940382024-10-21False
17060000014781L17/dossiers1717060000014779170600000147791PA6428472024-10-17False
17060000014782L17/dossiers1717060000014779170600000147792PA7188842024-10-17False
17060000014783L17/dossiers1717060000014779170600000147793PA7199682024-10-17False
17060000014784L17/dossiers1717060000014779170600000147794PA2667932024-10-17False
17060000014785L17/dossiers1717060000014779170600000147795PA7935082024-10-17False
17060000014786L17/dossiers1717060000014779170600000147796PA7188382024-10-17False
17060000014787L17/dossiers1717060000014779170600000147797PA7188502024-10-17False
17060000014788L17/dossiers1717060000014779170600000147798PA7223902024-10-17False
17060000014789L17/dossiers1717060000014779170600000147799PA7940582024-10-17False
17060000014790L17/dossiers17170600000147791706000001477910PA7933422024-10-17False
17060000014791L17/dossiers17170600000147791706000001477911PA7206442024-10-17False
17060000014792L17/dossiers17170600000147791706000001477912PA7187842024-10-17False
17060000014793L17/dossiers17170600000147791706000001477913PA7941782024-10-17False
17060000014794L17/dossiers17170600000147791706000001477914PA3422402024-10-17False
17060000014795L17/dossiers17170600000147791706000001477915PA7214102024-10-17False
17060000014796L17/dossiers17170600000147791706000001477916PA6080162024-10-17False
17060000014797L17/dossiers17170600000147791706000001477917PA7749542024-10-17False
17060000014798L17/dossiers17170600000147791706000001477918PA7214422024-10-17False
17060000014799L17/dossiers17170600000147791706000001477919PA7930942024-10-17False
17060000014800L17/dossiers17170600000147791706000001477920PA4085782024-10-17False
17060000014801L17/dossiers17170600000147791706000001477921PA16302024-10-17False
17060000014802L17/dossiers17170600000147791706000001477922PA6070902024-10-17False
17060000014803L17/dossiers17170600000147791706000001477923PA7192722024-10-17False
17060000014804L17/dossiers17170600000147791706000001477924PA6088262024-10-17False
17060000014805L17/dossiers17170600000147791706000001477925PA3467822024-10-17False
17060000014809L17/dossiers1717060000014807170600000148071PA7934322025-03-07False
17060000014810L17/dossiers1717060000014807170600000148072PA8414952025-03-07False
17060000014811L17/dossiers1717060000014807170600000148073PA7961182025-03-07False
17060000014812L17/dossiers1717060000014807170600000148074PA7945622025-03-07False
17060000014813L17/dossiers1717060000014807170600000148075PA8422792025-03-07False
17060000014814L17/dossiers1717060000014807170600000148076PA7932382025-03-07False
17060000014815L17/dossiers1717060000014807170600000148077PA7933742025-03-07False
17060000014816L17/dossiers1717060000014807170600000148078PA7931582025-03-07False