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
17060000027246L17/dossiers17170600000272321706000002723213PA7949942025-02-26False
17060000027247L17/dossiers17170600000272321706000002723214PA7199682025-02-26False
17060000027248L17/dossiers17170600000272321706000002723215PA7223902025-02-26False
17060000027249L17/dossiers17170600000272321706000002723216PA7944862025-02-26False
17060000027250L17/dossiers17170600000272321706000002723217PA8408172025-02-26False
17060000027251L17/dossiers17170600000272321706000002723218PA7937962025-02-26False
17060000027252L17/dossiers17170600000272321706000002723219PA2667972025-02-26False
17060000027253L17/dossiers17170600000272321706000002723220PA7949822025-02-26False
17060000027254L17/dossiers17170600000272321706000002723221PA7953502025-02-26False
17060000027255L17/dossiers17170600000272321706000002723222PA7200382025-02-26False
17060000027256L17/dossiers17170600000272321706000002723223PA7221422025-02-26False
17060000027257L17/dossiers17170600000272321706000002723224PA7209082025-02-26False
17060000027258L17/dossiers17170600000272321706000002723225PA7213142025-02-26False
17060000027259L17/dossiers17170600000272321706000002723226PA7952442025-02-26False
17060000027260L17/dossiers17170600000272321706000002723227PA8402352025-02-26False
17060000027261L17/dossiers17170600000272321706000002723228PA6088262025-02-26False
17060000027262L17/dossiers17170600000272321706000002723229PA7209602025-02-26False
17060000027263L17/dossiers17170600000272321706000002723230PA7192862025-02-26False
17060000027264L17/dossiers17170600000272321706000002723231PA7960782025-02-26False
17060000027265L17/dossiers17170600000272321706000002723232PA7932102025-02-26False
17060000027266L17/dossiers17170600000272321706000002723233PA7200922025-02-26False
17060000027267L17/dossiers17170600000272321706000002723234PA7935722025-02-26False
17060000027268L17/dossiers17170600000272321706000002723235PA7930942025-02-26False
17060000027269L17/dossiers17170600000272321706000002723236PA3422402025-02-26False
17060000027270L17/dossiers17170600000272321706000002723237PA6076192025-02-26False
17060000027271L17/dossiers17170600000272321706000002723238PA8226172025-02-26False
17060000027272L17/dossiers17170600000272321706000002723239PA7120142025-02-26False
17060000027273L17/dossiers17170600000272321706000002723240PA8414312025-02-26False
17060000027274L17/dossiers17170600000272321706000002723241PA7203542025-02-26False
17060000027275L17/dossiers17170600000272321706000002723242PA7191382025-02-26False
17060000027279L17/dossiers1717060000027277170600000272771PA8412072025-02-18False
17060000027280L17/dossiers1717060000027277170600000272772PA2675612025-02-18False
17060000027281L17/dossiers1717060000027277170600000272773PA7933742025-02-18False
17060000027282L17/dossiers1717060000027277170600000272774PA8408892025-02-18False
17060000027283L17/dossiers1717060000027277170600000272775PA7931822025-02-18False
17060000027284L17/dossiers1717060000027277170600000272776PA7931342025-02-18False
17060000027285L17/dossiers1717060000027277170600000272777PA8400752025-02-18False
17060000027286L17/dossiers1717060000027277170600000272778PA8407012025-02-18False
17060000027287L17/dossiers1717060000027277170600000272779PA8407212025-02-18False
17060000027288L17/dossiers17170600000272771706000002727710PA7204682025-02-18False
17060000027289L17/dossiers17170600000272771706000002727711PA7941982025-02-18False
17060000027290L17/dossiers17170600000272771706000002727712PA7931662025-02-18False
17060000027291L17/dossiers17170600000272771706000002727713PA7939282025-02-18False
17060000027292L17/dossiers17170600000272771706000002727714PA7932462025-02-18False
17060000027293L17/dossiers17170600000272771706000002727715PA8407732025-02-18False
17060000027294L17/dossiers17170600000272771706000002727716PA8408012025-02-18False
17060000027295L17/dossiers17170600000272771706000002727717PA7946782025-02-18False
17060000027296L17/dossiers17170600000272771706000002727718PA7938922025-02-18False
17060000027297L17/dossiers17170600000272771706000002727719PA8417372025-02-18False
17060000027298L17/dossiers17170600000272771706000002727720PA8420852025-02-18False