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
17060000030324L17/dossiers17170600000302721706000003027251PA8412152025-03-18False
17060000030325L17/dossiers17170600000302721706000003027252PA7954822025-03-18False
17060000030326L17/dossiers17170600000302721706000003027253PA6106542025-03-18False
17060000030327L17/dossiers17170600000302721706000003027254PA8411912025-03-18False
17060000030328L17/dossiers17170600000302721706000003027255PA7219602025-03-18False
17060000030329L17/dossiers17170600000302721706000003027256PA7938722025-03-18False
17060000030330L17/dossiers17170600000302721706000003027257PA7208922025-03-18False
17060000030331L17/dossiers17170600000302721706000003027258PA7937562025-03-18False
17060000030332L17/dossiers17170600000302721706000003027259PA7960622025-03-18False
17060000030333L17/dossiers17170600000302721706000003027260PA7195782025-03-18False
17060000030334L17/dossiers17170600000302721706000003027261PA7210622025-03-18False
17060000030335L17/dossiers17170600000302721706000003027262PA8418452025-03-18False
17060000030336L17/dossiers17170600000302721706000003027263PA7959822025-03-18False
17060000030337L17/dossiers17170600000302721706000003027264PA7954662025-03-18False
17060000030338L17/dossiers17170600000302721706000003027265PA7937442025-03-18False
17060000030339L17/dossiers17170600000302721706000003027266PA7209522025-03-18False
17060000030340L17/dossiers17170600000302721706000003027267PA7941062025-03-18False
17060000030341L17/dossiers17170600000302721706000003027268PA7941662025-03-18False
17060000030342L17/dossiers17170600000302721706000003027269PA7951642025-03-18False
17060000030343L17/dossiers17170600000302721706000003027270PA7955962025-03-18False
17060000030347L17/dossiers1717060000030345170600000303451PA6427642025-03-18False
17060000030348L17/dossiers1717060000030345170600000303452PA8422112025-03-18False
17060000030349L17/dossiers1717060000030345170600000303453PA6067932025-03-18False
17060000030350L17/dossiers1717060000030345170600000303454PA8408292025-03-18False
17060000030351L17/dossiers1717060000030345170600000303455PA7940942025-03-18False
17060000030352L17/dossiers1717060000030345170600000303456PA6082642025-03-18False
17060000030353L17/dossiers1717060000030345170600000303457PA8412952025-03-18False
17060000030354L17/dossiers1717060000030345170600000303458PA10082025-03-18False
17060000030355L17/dossiers1717060000030345170600000303459PA7948542025-03-18False
17060000030356L17/dossiers17170600000303451706000003034510PA8421952025-03-18False
17060000030357L17/dossiers17170600000303451706000003034511PA8416652025-03-18False
17060000030358L17/dossiers17170600000303451706000003034512PA3332852025-03-18False
17060000030359L17/dossiers17170600000303451706000003034513PA8415392025-03-18False
17060000030360L17/dossiers17170600000303451706000003034514PA3319732025-03-18False
17060000030361L17/dossiers17170600000303451706000003034515PA8401712025-03-18False
17060000030362L17/dossiers17170600000303451706000003034516PA15672025-03-18False
17060000030363L17/dossiers17170600000303451706000003034517PA8418532025-03-18False
17060000030364L17/dossiers17170600000303451706000003034518PA6431922025-03-18False
17060000030365L17/dossiers17170600000303451706000003034519PA8407652025-03-18False
17060000030366L17/dossiers17170600000303451706000003034520PA8414632025-03-18False
17060000030367L17/dossiers17170600000303451706000003034521PA6431572025-03-18False
17060000030368L17/dossiers17170600000303451706000003034522PA8413812025-03-18False
17060000030369L17/dossiers17170600000303451706000003034523PA8407932025-03-18False
17060000030370L17/dossiers17170600000303451706000003034524PA7942702025-03-18False
17060000030371L17/dossiers17170600000303451706000003034525PA6081722025-03-18False
17060000030372L17/dossiers17170600000303451706000003034526PA6075532025-03-18False
17060000030373L17/dossiers17170600000303451706000003034527PA8409552025-03-18False
17060000030374L17/dossiers17170600000303451706000003034528PA8413672025-03-18False
17060000030375L17/dossiers17170600000303451706000003034529PA3421962025-03-18False
17060000030376L17/dossiers17170600000303451706000003034530PA8417172025-03-18False