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
17060000025033L17/dossiers17170600000249611706000002496171PA7203702025-03-25False
17060000025034L17/dossiers17170600000249611706000002496172PA7951762025-03-25False
17060000025035L17/dossiers17170600000249611706000002496173PA7956642025-03-25False
17060000025036L17/dossiers17170600000249611706000002496174PA8172032025-03-25False
17060000025037L17/dossiers17170600000249611706000002496175PA7957222025-03-25False
17060000025038L17/dossiers17170600000249611706000002496176PA7196322025-03-25False
17060000025039L17/dossiers17170600000249611706000002496177PA7219162025-03-25False
17060000025040L17/dossiers17170600000249611706000002496178PA3357582025-03-25False
17060000025041L17/dossiers17170600000249611706000002496179PA7214262025-03-25False
17060000025042L17/dossiers17170600000249611706000002496180PA7200662025-03-25False
17060000025043L17/dossiers17170600000249611706000002496181PA7222522025-03-25False
17060000025044L17/dossiers17170600000249611706000002496182PA7958882025-03-25False
17060000025045L17/dossiers17170600000249611706000002496183PA7932702025-03-25False
17060000025046L17/dossiers17170600000249611706000002496184PA7572252025-03-25False
17060000025047L17/dossiers17170600000249611706000002496185PA7201902025-03-25False
17060000025048L17/dossiers17170600000249611706000002496186PA7195502025-03-25False
17060000025049L17/dossiers17170600000249611706000002496187PA7215842025-03-25False
17060000025050L17/dossiers17170600000249611706000002496188PA7959202025-03-25False
17060000025051L17/dossiers17170600000249611706000002496189PA6073952025-03-25False
17060000025052L17/dossiers17170600000249611706000002496190PA7221022025-03-25False
17060000025053L17/dossiers17170600000249611706000002496191PA7211702025-03-25False
17060000025054L17/dossiers17170600000249611706000002496192PA7950462025-03-25False
17060000025058L17/dossiers1717060000025056170600000250561PA8410672025-05-21False
17060000025059L17/dossiers1717060000025056170600000250562PA8414952025-05-21False
17060000025060L17/dossiers1717060000025056170600000250563PA7961182025-05-21False
17060000025061L17/dossiers1717060000025056170600000250564PA7932382025-05-21False
17060000025062L17/dossiers1717060000025056170600000250565PA7933742025-05-21False
17060000025063L17/dossiers1717060000025056170600000250566PA7931582025-05-21False
17060000025064L17/dossiers1717060000025056170600000250567PA7944342025-05-21False
17060000025065L17/dossiers1717060000025056170600000250568PA8416452025-05-21False
17060000025066L17/dossiers1717060000025056170600000250569PA7206682025-05-21False
17060000025067L17/dossiers17170600000250561706000002505610PA7948862025-05-21False
17060000025068L17/dossiers17170600000250561706000002505611PA7960422025-05-21False
17060000025069L17/dossiers17170600000250561706000002505612PA8414872025-05-21False
17060000025070L17/dossiers17170600000250561706000002505613PA8411312025-05-21False
17060000025071L17/dossiers17170600000250561706000002505614PA7931342025-05-21False
17060000025072L17/dossiers17170600000250561706000002505615PA8400752025-05-21False
17060000025073L17/dossiers17170600000250561706000002505616PA8407012025-05-21False
17060000025074L17/dossiers17170600000250561706000002505617PA7204682025-05-21False
17060000025075L17/dossiers17170600000250561706000002505618PA7941982025-05-21False
17060000025076L17/dossiers17170600000250561706000002505619PA8401592025-05-21False
17060000025077L17/dossiers17170600000250561706000002505620PA7935482025-05-21False
17060000025078L17/dossiers17170600000250561706000002505621PA7931662025-05-21False
17060000025079L17/dossiers17170600000250561706000002505622PA7939282025-05-21False
17060000025080L17/dossiers17170600000250561706000002505623PA8401352025-05-21False
17060000025081L17/dossiers17170600000250561706000002505624PA8420732025-05-21False
17060000025082L17/dossiers17170600000250561706000002505625PA7932462025-05-21False
17060000025083L17/dossiers17170600000250561706000002505626PA8408012025-05-21False
17060000025084L17/dossiers17170600000250561706000002505627PA7946782025-05-21False
17060000025085L17/dossiers17170600000250561706000002505628PA7938922025-05-21False