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
17060000011763L17/dossiers1717060000011756170600000117566PA7930942024-10-15False
17060000011764L17/dossiers1717060000011756170600000117567PA6070902024-10-15False
17060000011765L17/dossiers1717060000011756170600000117568PA16302024-10-15False
17060000011766L17/dossiers1717060000011756170600000117569PA6088262024-10-15False
17060000011773L17/dossiers1717060000011771170600000117711PA2677632025-05-14False
17060000011774L17/dossiers1717060000011771170600000117712PA7218162025-05-14False
17060000011775L17/dossiers1717060000011771170600000117713PA8408172025-05-14False
17060000011776L17/dossiers1717060000011771170600000117714PA7945542025-05-14False
17060000011777L17/dossiers1717060000011771170600000117715PA6088262025-05-14False
17060000011778L17/dossiers1717060000011771170600000117716PA2670422025-05-14False
17060000011779L17/dossiers1717060000011771170600000117717PA13272025-05-14False
17060000011780L17/dossiers1717060000011771170600000117718PA16302025-05-14False
17060000011781L17/dossiers1717060000011771170600000117719PA7209762025-05-14False
17060000011782L17/dossiers17170600000117711706000001177110PA8419312025-05-14False
17060000011783L17/dossiers17170600000117711706000001177111PA7930942025-05-14False
17060000011784L17/dossiers17170600000117711706000001177112PA7214102025-05-14False
17060000011785L17/dossiers17170600000117711706000001177113PA7191382025-05-14False
17060000011786L17/dossiers17170600000117711706000001177114PA7223902025-05-14False
17060000011787L17/dossiers17170600000117711706000001177115PA2677802025-05-14False
17060000011788L17/dossiers17170600000117711706000001177116PA7202302025-05-14False
17060000011789L17/dossiers17170600000117711706000001177117PA7933422025-05-14False
17060000011790L17/dossiers17170600000117711706000001177118PA7960782025-05-14False
17060000011791L17/dossiers17170600000117711706000001177119PA6076192025-05-14False
17060000011792L17/dossiers17170600000117711706000001177120PA7932102025-05-14False
17060000011793L17/dossiers17170600000117711706000001177121PA7937962025-05-14False
17060000011806L17/dossiers1717060000011804170600000118041PA7188842024-10-15False
17060000011807L17/dossiers1717060000011804170600000118042PA7935082024-10-15False
17060000011808L17/dossiers1717060000011804170600000118043PA7223902024-10-15False
17060000011809L17/dossiers1717060000011804170600000118044PA7203862024-10-15False
17060000011810L17/dossiers1717060000011804170600000118045PA16302024-10-15False
17060000011811L17/dossiers1717060000011804170600000118046PA8409792024-10-15False
17060000011812L17/dossiers1717060000011804170600000118047PA6080162024-10-15False
17060000011813L17/dossiers1717060000011804170600000118048PA7940382024-10-15False
17060000011814L17/dossiers1717060000011804170600000118049PA7214422024-10-15False
17060000011815L17/dossiers17170600000118041706000001180410PA7941782024-10-15False
17060000011816L17/dossiers17170600000118041706000001180411PA6070902024-10-15False
17060000011817L17/dossiers17170600000118041706000001180412PA7749542024-10-15False
17060000011818L17/dossiers17170600000118041706000001180413PA6088262024-10-15False
17060000011819L17/dossiers17170600000118041706000001180414PA6428472024-10-15False
17060000011823L17/dossiers1717060000011821170600000118211PA7942782025-03-11False
17060000011824L17/dossiers1717060000011821170600000118212PA7939922025-03-11False
17060000011825L17/dossiers1717060000011821170600000118213PA7952782025-03-11False
17060000011826L17/dossiers1717060000011821170600000118214PA6872142025-03-11False
17060000011827L17/dossiers1717060000011821170600000118215PA8413392025-03-11False
17060000011828L17/dossiers1717060000011821170600000118216PA2677802025-03-11False
17060000011829L17/dossiers1717060000011821170600000118217PA7220702025-03-11False
17060000011830L17/dossiers1717060000011821170600000118218PA8421252025-03-11False
17060000011831L17/dossiers1717060000011821170600000118219PA3457222025-03-11False
17060000011832L17/dossiers17170600000118211706000001182110PA7944262025-03-11False
17060000011833L17/dossiers17170600000118211706000001182111PA7947022025-03-11False