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
17060000019348L17/dossiers1717060000019345170600000193452PA7958682025-03-10False
17060000019349L17/dossiers1717060000019345170600000193453PA2673062025-03-10False
17060000019350L17/dossiers1717060000019345170600000193454PA7218962025-03-10False
17060000019351L17/dossiers1717060000019345170600000193455PA7749622025-03-10False
17060000019352L17/dossiers1717060000019345170600000193456PA7960102025-03-10False
17060000019353L17/dossiers1717060000019345170600000193457PA7931742025-03-10False
17060000019354L17/dossiers1717060000019345170600000193458PA7958202025-03-10False
17060000019355L17/dossiers1717060000019345170600000193459PA7212702025-03-10False
17060000019356L17/dossiers17170600000193451706000001934510PA7952402025-03-10False
17060000019357L17/dossiers17170600000193451706000001934511PA7958762025-03-10False
17060000019358L17/dossiers17170600000193451706000001934512PA8422992025-03-10False
17060000019359L17/dossiers17170600000193451706000001934513PA7932622025-03-10False
17060000019360L17/dossiers17170600000193451706000001934514PA7955882025-03-10False
17060000019361L17/dossiers17170600000193451706000001934515PA7204302025-03-10False
17060000019362L17/dossiers17170600000193451706000001934516PA8410232025-03-10False
17060000019363L17/dossiers17170600000193451706000001934517PA7918122025-03-10False
17060000019364L17/dossiers17170600000193451706000001934518PA9422025-03-10False
17060000019365L17/dossiers17170600000193451706000001934519PA7933942025-03-10False
17060000019366L17/dossiers17170600000193451706000001934520PA7958442025-03-10False
17060000019367L17/dossiers17170600000193451706000001934521PA6071932025-03-10False
17060000019368L17/dossiers17170600000193451706000001934522PA8421952025-03-10False
17060000019369L17/dossiers17170600000193451706000001934523PA7960702025-03-10False
17060000019370L17/dossiers17170600000193451706000001934524PA2673182025-03-10False
17060000019371L17/dossiers17170600000193451706000001934525PA7953102025-03-10False
17060000019372L17/dossiers17170600000193451706000001934526PA7952582025-03-10False
17060000019373L17/dossiers17170600000193451706000001934527PA8418532025-03-10False
17060000019374L17/dossiers17170600000193451706000001934528PA7940822025-03-10False
17060000019375L17/dossiers17170600000193451706000001934529PA7221502025-03-10False
17060000019376L17/dossiers17170600000193451706000001934530PA7940222025-03-10False
17060000019377L17/dossiers17170600000193451706000001934531PA3467822025-03-10False
17060000019378L17/dossiers17170600000193451706000001934532PA8417292025-03-10False
17060000019379L17/dossiers17170600000193451706000001934533PA7955162025-03-10False
17060000019380L17/dossiers17170600000193451706000001934534PA7935322025-03-10False
17060000019381L17/dossiers17170600000193451706000001934535PA7209762025-03-10False
17060000019382L17/dossiers17170600000193451706000001934536PA8412152025-03-10False
17060000019383L17/dossiers17170600000193451706000001934537PA7954822025-03-10False
17060000019384L17/dossiers17170600000193451706000001934538PA6076192025-03-10False
17060000019385L17/dossiers17170600000193451706000001934539PA8411912025-03-10False
17060000019386L17/dossiers17170600000193451706000001934540PA6081722025-03-10False
17060000019387L17/dossiers17170600000193451706000001934541PA3403432025-03-10False
17060000019388L17/dossiers17170600000193451706000001934542PA7958082025-03-10False
17060000019389L17/dossiers17170600000193451706000001934543PA7209922025-03-10False
17060000019390L17/dossiers17170600000193451706000001934544PA7952282025-03-10False
17060000019391L17/dossiers17170600000193451706000001934545PA7949062025-03-10False
17060000019392L17/dossiers17170600000193451706000001934546PA8417012025-03-10False
17060000019393L17/dossiers17170600000193451706000001934547PA8408292025-03-10False
17060000019394L17/dossiers17170600000193451706000001934548PA8422112025-03-10False
17060000019395L17/dossiers17170600000193451706000001934549PA7940942025-03-10False
17060000019396L17/dossiers17170600000193451706000001934550PA6082642025-03-10False
17060000019397L17/dossiers17170600000193451706000001934551PA7947862025-03-10False