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
17060000024049L17/dossiers17170600000239971706000002399751PA7931022025-03-13False
17060000024050L17/dossiers17170600000239971706000002399752PA8420852025-03-13False
17060000024051L17/dossiers17170600000239971706000002399753PA7944182025-03-13False
17060000024052L17/dossiers17170600000239971706000002399754PA7945822025-03-13False
17060000024053L17/dossiers17170600000239971706000002399755PA8415872025-03-13False
17060000024054L17/dossiers17170600000239971706000002399756PA8417772025-01-212025-03-13False
17060000024055L17/dossiers17170600000239971706000002399757PA8414872025-03-13False
17060000024056L17/dossiers17170600000239971706000002399758PA8401592025-03-13False
17060000024057L17/dossiers17170600000239971706000002399759PA8415532025-03-13False
17060000024058L17/dossiers17170600000239971706000002399760PA7945982025-03-13False
17060000024059L17/dossiers17170600000239971706000002399761PA7954102025-03-13False
17060000024060L17/dossiers17170600000239971706000002399762PA8417692025-03-13False
17060000024061L17/dossiers17170600000239971706000002399763PA8412072025-03-13False
17060000024062L17/dossiers17170600000239971706000002399764PA8407732025-03-13False
17060000024063L17/dossiers17170600000239971706000002399765PA8407012025-03-13False
17060000024064L17/dossiers17170600000239971706000002399766PA8410672025-03-13False
17060000024065L17/dossiers17170600000239971706000002399767PA8406572025-03-13False
17060000024066L17/dossiers17170600000239971706000002399768PA8407212025-03-13False
17060000024067L17/dossiers17170600000239971706000002399769PA8411312025-03-13False
17060000024068L17/dossiers17170600000239971706000002399770PA7939042025-03-13False
17060000024072L17/dossiers1717060000024070170600000240701PA7952282025-01-21False
17060000024073L17/dossiers1717060000024070170600000240702PA7932622025-01-21False
17060000024074L17/dossiers1717060000024070170600000240703PA7949062025-01-21False
17060000024075L17/dossiers1717060000024070170600000240704PA7941382025-01-21False
17060000024076L17/dossiers1717060000024070170600000240705PA7955882025-01-21False
17060000024077L17/dossiers1717060000024070170600000240706PA7950842025-01-21False
17060000024078L17/dossiers1717060000024070170600000240707PA8421052025-01-21False
17060000024079L17/dossiers1717060000024070170600000240708PA8416572025-01-21False
17060000024080L17/dossiers1717060000024070170600000240709PA7204302025-01-21False
17060000024081L17/dossiers17170600000240701706000002407010PA7937722025-01-21False
17060000024082L17/dossiers17170600000240701706000002407011PA7956162025-01-21False
17060000024083L17/dossiers17170600000240701706000002407012PA7934442025-01-21False
17060000024084L17/dossiers17170600000240701706000002407013PA7949382025-01-21False
17060000024085L17/dossiers17170600000240701706000002407014PA7953182025-01-21False
17060000024086L17/dossiers17170600000240701706000002407015PA8410232025-01-21False
17060000024087L17/dossiers17170600000240701706000002407016PA7960902025-01-21False
17060000024088L17/dossiers17170600000240701706000002407017PA7939122025-01-21False
17060000024089L17/dossiers17170600000240701706000002407018PA8421872025-01-21False
17060000024090L17/dossiers17170600000240701706000002407019PA8420372025-01-21False
17060000024091L17/dossiers17170600000240701706000002407020PA7918122025-01-21False
17060000024092L17/dossiers17170600000240701706000002407021PA7212022025-01-21False
17060000024093L17/dossiers17170600000240701706000002407022PA7951362025-01-21False
17060000024094L17/dossiers17170600000240701706000002407023PA7934642025-01-21False
17060000024095L17/dossiers17170600000240701706000002407024PA8421552025-01-21False
17060000024096L17/dossiers17170600000240701706000002407025PA7952002025-01-21False
17060000024097L17/dossiers17170600000240701706000002407026PA7958442025-01-21False
17060000024098L17/dossiers17170600000240701706000002407027PA8412512025-01-21False
17060000024099L17/dossiers17170600000240701706000002407028PA7947862025-01-21False
17060000024100L17/dossiers17170600000240701706000002407029PA7948702025-01-21False
17060000024101L17/dossiers17170600000240701706000002407030PA7960702025-01-21False