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
17060000037225L17/dossiers171706000003711717060000037117107PA7945702025-07-07False
17060000037226L17/dossiers171706000003711717060000037117108PA7949542025-07-07False
17060000037227L17/dossiers171706000003711717060000037117109PA7960502025-07-07False
17060000037228L17/dossiers171706000003711717060000037117110PA8422552025-07-07False
17060000037229L17/dossiers171706000003711717060000037117111PA7933822025-07-07False
17060000037230L17/dossiers171706000003711717060000037117112PA7945022025-07-07False
17060000037231L17/dossiers171706000003711717060000037117113PA8415532025-07-07False
17060000037232L17/dossiers171706000003711717060000037117114PA7932982025-07-07False
17060000037233L17/dossiers171706000003711717060000037117115PA8407812025-07-07False
17060000037234L17/dossiers171706000003711717060000037117116PA7949462025-07-07False
17060000037235L17/dossiers171706000003711717060000037117117PA8415752025-07-07False
17060000037236L17/dossiers171706000003711717060000037117118PA8414792025-07-07False
17060000037240L17/dossiers1717060000037238170600000372381PA7936962025-05-13False
17060000037241L17/dossiers1717060000037238170600000372382PA8420852025-05-13False
17060000037242L17/dossiers1717060000037238170600000372383PA8409832025-05-13False
17060000037243L17/dossiers1717060000037238170600000372384PA7947622025-05-13False
17060000037244L17/dossiers1717060000037238170600000372385PA8410672025-05-13False
17060000037245L17/dossiers1717060000037238170600000372386PA7194362025-05-13False
17060000037246L17/dossiers1717060000037238170600000372387PA8422272025-05-13False
17060000037247L17/dossiers1717060000037238170600000372388PA7960262025-05-13False
17060000037248L17/dossiers1717060000037238170600000372389PA7943542025-05-13False
17060000037249L17/dossiers17170600000372381706000003723810PA7940302025-05-13False
17060000037250L17/dossiers17170600000372381706000003723811PA7947702025-05-13False
17060000037251L17/dossiers17170600000372381706000003723812PA7956442025-05-13False
17060000037252L17/dossiers17170600000372381706000003723813PA7939282025-05-13False
17060000037253L17/dossiers17170600000372381706000003723814PA7931342025-05-13False
17060000037254L17/dossiers17170600000372381706000003723815PA7941982025-05-13False
17060000037255L17/dossiers17170600000372381706000003723816PA7933742025-05-13False
17060000037256L17/dossiers17170600000372381706000003723817PA7938522025-05-13False
17060000037260L17/dossiers1717060000037258170600000372581PA6428472025-08-25False
17060000037261L17/dossiers1717060000037258170600000372582PA8051662025-08-25False
17060000037262L17/dossiers1717060000037258170600000372583PA5692025-08-25False
17060000037263L17/dossiers1717060000037258170600000372584PA7198902025-08-25False
17060000037264L17/dossiers1717060000037258170600000372585PA8408172025-08-25False
17060000037265L17/dossiers1717060000037258170600000372586PA7199222025-08-25False
17060000037266L17/dossiers1717060000037258170600000372587PA6428682025-08-25False
17060000037267L17/dossiers1717060000037258170600000372588PA8414312025-08-25False
17060000037268L17/dossiers1717060000037258170600000372589PA7223902025-08-25False
17060000037269L17/dossiers17170600000372581706000003725810PA9422025-08-25False
17060000037270L17/dossiers17170600000372581706000003725811PA7937162025-08-25False
17060000037271L17/dossiers17170600000372581706000003725812PA7931222025-08-25False
17060000037272L17/dossiers17170600000372581706000003725813PA6088262025-08-25False
17060000037273L17/dossiers17170600000372581706000003725814PA7946582025-08-25False
17060000037274L17/dossiers17170600000372581706000003725815PA7951202025-08-25False
17060000037275L17/dossiers17170600000372581706000003725816PA2677802025-08-25False
17060000037276L17/dossiers17170600000372581706000003725817PA13272025-08-25False
17060000037277L17/dossiers17170600000372581706000003725818PA2673182025-08-25False
17060000037278L17/dossiers17170600000372581706000003725819PA7940582025-08-25False
17060000037279L17/dossiers17170600000372581706000003725820PA2672002025-08-25False
17060000037280L17/dossiers17170600000372581706000003725821PA3467822025-08-25False