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
17060000043801L17/dossiers1717060000043796170600000437964PA7217642025-12-01False
17060000043802L17/dossiers1717060000043796170600000437965PA7939922025-12-01False
17060000043803L17/dossiers1717060000043796170600000437966PA7959502025-11-272025-11-27False
17060000043804L17/dossiers1717060000043796170600000437967PA7951442025-12-01False
17060000043805L17/dossiers1717060000043796170600000437968PA2677632025-12-01False
17060000043806L17/dossiers1717060000043796170600000437969PA7952782025-12-01False
17060000043807L17/dossiers17170600000437961706000004379610PA7192182025-12-01False
17060000043808L17/dossiers17170600000437961706000004379611PA5692025-12-01False
17060000043809L17/dossiers17170600000437961706000004379612PA7218162025-12-01False
17060000043810L17/dossiers17170600000437961706000004379613PA6065072025-12-01False
17060000043811L17/dossiers17170600000437961706000004379614PA7190322025-12-01False
17060000043812L17/dossiers17170600000437961706000004379615PA7943302025-12-01False
17060000043813L17/dossiers17170600000437961706000004379616PA8408172025-12-01False
17060000043814L17/dossiers17170600000437961706000004379617PA8423112025-12-01False
17060000043815L17/dossiers17170600000437961706000004379618PA7199222025-12-01False
17060000043816L17/dossiers17170600000437961706000004379619PA7194722025-12-01False
17060000043817L17/dossiers17170600000437961706000004379620PA6428682025-12-01False
17060000043818L17/dossiers17170600000437961706000004379621PA7940422025-12-01False
17060000043819L17/dossiers17170600000437961706000004379622PA7201542025-12-01False
17060000043820L17/dossiers17170600000437961706000004379623PA6431752025-12-01False
17060000043821L17/dossiers17170600000437961706000004379624PA6056942025-12-01False
17060000043822L17/dossiers17170600000437961706000004379625PA2677802025-12-01False
17060000043823L17/dossiers17170600000437961706000004379626PA7223662025-12-01False
17060000043824L17/dossiers17170600000437961706000004379627PA7944702025-12-01False
17060000043825L17/dossiers17170600000437961706000004379628PA7186742025-12-01False
17060000043826L17/dossiers17170600000437961706000004379629PA7212962025-12-01False
17060000043827L17/dossiers17170600000437961706000004379630PA7220702025-12-01False
17060000043828L17/dossiers17170600000437961706000004379631PA7221502025-12-01False
17060000043829L17/dossiers17170600000437961706000004379632PA2672002025-12-01False
17060000043830L17/dossiers17170600000437961706000004379633PA7203542025-12-01False
17060000043831L17/dossiers17170600000437961706000004379634PA7197982025-12-01False
17060000043832L17/dossiers17170600000437961706000004379635PA7192822025-12-01False
17060000043833L17/dossiers17170600000437961706000004379636PA8421252025-12-01False
17060000043834L17/dossiers17170600000437961706000004379637PA8416932025-12-01False
17060000043835L17/dossiers17170600000437961706000004379638PA7194122025-12-01False
17060000043836L17/dossiers17170600000437961706000004379639PA7944262025-12-01False
17060000043837L17/dossiers17170600000437961706000004379640PA7193882025-12-01False
17060000043838L17/dossiers17170600000437961706000004379641PA7120142025-12-01False
17060000043839L17/dossiers17170600000437961706000004379642PA7948382025-12-01False
17060000043840L17/dossiers17170600000437961706000004379643PA7953862025-11-272025-11-27False
17060000043841L17/dossiers17170600000437961706000004379644PA7947022025-12-01False
17060000043842L17/dossiers17170600000437961706000004379645PA7202302025-12-01False
17060000043843L17/dossiers17170600000437961706000004379646PA7942062025-12-01False
17060000043844L17/dossiers17170600000437961706000004379647PA7201462025-12-01False
17060000043845L17/dossiers17170600000437961706000004379648PA7944662025-12-01False
17060000043846L17/dossiers17170600000437961706000004379649PA7209082025-12-01False
17060000043847L17/dossiers17170600000437961706000004379650PA8413812025-12-01False
17060000043848L17/dossiers17170600000437961706000004379651PA7933982025-12-01False
17060000043849L17/dossiers17170600000437961706000004379652PA7935722025-12-01False
17060000043850L17/dossiers17170600000437961706000004379653PA7952702025-12-01False