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
17060000030698L17/dossiers17170600000306761706000003067621PA7218442025-04-24False
17060000030699L17/dossiers17170600000306761706000003067622PA7952702025-04-24False
17060000030700L17/dossiers17170600000306761706000003067623PA7190522025-04-24False
17060000030701L17/dossiers17170600000306761706000003067624PA7950262025-04-24False
17060000030702L17/dossiers17170600000306761706000003067625PA7193382025-04-24False
17060000030703L17/dossiers17170600000306761706000003067626PA7955282025-04-24False
17060000030704L17/dossiers17170600000306761706000003067627PA2672002025-04-24False
17060000030705L17/dossiers17170600000306761706000003067628PA3457222025-04-24False
17060000030706L17/dossiers17170600000306761706000003067629PA8172032025-04-24False
17060000030707L17/dossiers17170600000306761706000003067630PA6429352025-04-24False
17060000030708L17/dossiers17170600000306761706000003067631PA7950462025-04-24False
17060000030709L17/dossiers17170600000306761706000003067632PA7173792025-04-24False
17060000030710L17/dossiers17170600000306761706000003067633PA8417092025-04-24False
17060000030711L17/dossiers17170600000306761706000003067634PA6431842025-04-24False
17060000030712L17/dossiers17170600000306761706000003067635PA8416932025-04-24False
17060000030713L17/dossiers17170600000306761706000003067636PA7195122025-04-24False
17060000030714L17/dossiers17170600000306761706000003067637PA7215842025-04-24False
17060000030715L17/dossiers17170600000306761706000003067638PA7217642025-04-24False
17060000030716L17/dossiers17170600000306761706000003067639PA7197562025-04-24False
17060000030717L17/dossiers17170600000306761706000003067640PA29602025-04-24False
17060000030718L17/dossiers17170600000306761706000003067641PA7199382025-04-24False
17060000030719L17/dossiers17170600000306761706000003067642PA7951002025-04-24False
17060000030720L17/dossiers17170600000306761706000003067643PA7947022025-04-24False
17060000030721L17/dossiers17170600000306761706000003067644PA7945542025-04-24False
17060000030722L17/dossiers17170600000306761706000003067645PA7960782025-04-24False
17060000030723L17/dossiers17170600000306761706000003067646PA15922025-04-24False
17060000030724L17/dossiers17170600000306761706000003067647PA2677632025-04-24False
17060000030725L17/dossiers17170600000306761706000003067648PA7931942025-04-24False
17060000030726L17/dossiers17170600000306761706000003067649PA7120142025-04-24False
17060000030727L17/dossiers17170600000306761706000003067650PA6428472025-04-24False
17060000030728L17/dossiers17170600000306761706000003067651PA8419312025-04-24False
17060000030729L17/dossiers17170600000306761706000003067652PA7203542025-04-24False
17060000030730L17/dossiers17170600000306761706000003067653PA7949942025-04-24False
17060000030731L17/dossiers17170600000306761706000003067654PA7930942025-04-24False
17060000030732L17/dossiers17170600000306761706000003067655PA8419272025-04-24False
17060000030733L17/dossiers17170600000306761706000003067656PA7934162025-04-24False
17060000030734L17/dossiers17170600000306761706000003067657PA7943302025-04-24False
17060000030735L17/dossiers17170600000306761706000003067658PA7201462025-04-24False
17060000030736L17/dossiers17170600000306761706000003067659PA8413592025-04-24False
17060000030737L17/dossiers17170600000306761706000003067660PA7944862025-04-24False
17060000030738L17/dossiers17170600000306761706000003067661PA7937162025-04-24False
17060000030739L17/dossiers17170600000306761706000003067662PA7949822025-04-24False
17060000030740L17/dossiers17170600000306761706000003067663PA7209602025-04-24False
17060000030741L17/dossiers17170600000306761706000003067664PA2670422025-04-24False
17060000030742L17/dossiers17170600000306761706000003067665PA7200382025-04-24False
17060000030743L17/dossiers17170600000306761706000003067666PA7197782025-04-24False
17060000030744L17/dossiers17170600000306761706000003067667PA7194722025-04-24False
17060000030745L17/dossiers17170600000306761706000003067668PA7940422025-04-24False
17060000030746L17/dossiers17170600000306761706000003067669PA8408172025-04-24False
17060000030747L17/dossiers17170600000306761706000003067670PA8051662025-04-24False