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 151 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
17060000016135L17/dossiers17170600000161231706000001612311PA7932462024-10-29False
17060000016136L17/dossiers17170600000161231706000001612312PA8417372024-10-29False
17060000016137L17/dossiers17170600000161231706000001612313PA7938322024-10-29False
17060000016138L17/dossiers17170600000161231706000001612314PA7935922024-10-29False
17060000016139L17/dossiers17170600000161231706000001612315PA7945982024-10-29False
17060000016140L17/dossiers17170600000161231706000001612316PA7940302024-10-29False
17060000016141L17/dossiers17170600000161231706000001612317PA8410752024-10-29False
17060000016142L17/dossiers17170600000161231706000001612318PA8409672024-10-29False
17060000016143L17/dossiers17170600000161231706000001612319PA7959742024-10-29False
17060000016144L17/dossiers17170600000161231706000001612320PA8411832024-10-29False
17060000016145L17/dossiers17170600000161231706000001612321PA8415632024-10-29False
17060000016146L17/dossiers17170600000161231706000001612322PA7194362024-10-29False
17060000016147L17/dossiers17170600000161231706000001612323PA7938522024-10-29False
17060000016148L17/dossiers17170600000161231706000001612324PA8413952024-10-29False
17060000016149L17/dossiers17170600000161231706000001612325PA7936962024-10-29False
17060000016150L17/dossiers17170600000161231706000001612326PA7952402024-10-29False
17060000016151L17/dossiers17170600000161231706000001612327PA8422272024-10-29False
17060000016152L17/dossiers17170600000161231706000001612328PA7948942024-10-29False
17060000016153L17/dossiers17170600000161231706000001612329PA8415752024-10-29False
17060000016154L17/dossiers17170600000161231706000001612330PA8414792024-10-29False
17060000016158L17/dossiers1717060000016156170600000161561PA7940942024-10-29False
17060000016159L17/dossiers1717060000016156170600000161562PA7936242024-10-29False
17060000016160L17/dossiers1717060000016156170600000161563PA7957622024-10-29False
17060000016161L17/dossiers1717060000016156170600000161564PA6082642024-10-29False
17060000016162L17/dossiers1717060000016156170600000161565PA8409032024-10-29False
17060000016163L17/dossiers1717060000016156170600000161566PA8412952024-10-29False
17060000016164L17/dossiers1717060000016156170600000161567PA7933942024-10-29False
17060000016165L17/dossiers1717060000016156170600000161568PA7954302024-10-29False
17060000016166L17/dossiers1717060000016156170600000161569PA8419192024-10-29False
17060000016167L17/dossiers17170600000161561706000001615610PA6065732024-10-29False
17060000016168L17/dossiers17170600000161561706000001615611PA8416332024-10-29False
17060000016169L17/dossiers17170600000161561706000001615612PA7948542024-10-29False
17060000016170L17/dossiers17170600000161561706000001615613PA8421952024-10-29False
17060000016171L17/dossiers17170600000161561706000001615614PA8416652024-10-29False
17060000016172L17/dossiers17170600000161561706000001615615PA3332852024-10-29False
17060000016173L17/dossiers17170600000161561706000001615616PA8409392024-10-29False
17060000016174L17/dossiers17170600000161561706000001615617PA8415392024-10-29False
17060000016175L17/dossiers17170600000161561706000001615618PA3319732024-10-29False
17060000016176L17/dossiers17170600000161561706000001615619PA8401712024-10-29False
17060000016177L17/dossiers17170600000161561706000001615620PA15672024-10-29False
17060000016178L17/dossiers17170600000161561706000001615621PA8414712024-10-29False
17060000016179L17/dossiers17170600000161561706000001615622PA8422632024-10-29False
17060000016180L17/dossiers17170600000161561706000001615623PA8418132024-10-29False
17060000016181L17/dossiers17170600000161561706000001615624PA8418532024-10-29False
17060000016182L17/dossiers17170600000161561706000001615625PA16542024-10-29False
17060000016183L17/dossiers17170600000161561706000001615626PA3350542024-10-29False
17060000016184L17/dossiers17170600000161561706000001615627PA7951562024-10-29False
17060000016185L17/dossiers17170600000161561706000001615628PA7749582024-10-29False
17060000016186L17/dossiers17170600000161561706000001615629PA8407652024-10-29False
17060000016187L17/dossiers17170600000161561706000001615630PA8414632024-10-29False