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
17060000024927L17/dossiers17170600000248841706000002488442PA7945822025-03-07False
17060000024928L17/dossiers17170600000248841706000002488443PA7959122025-03-07False
17060000024929L17/dossiers17170600000248841706000002488444PA7935922025-03-07False
17060000024930L17/dossiers17170600000248841706000002488445PA7206682025-03-07False
17060000024931L17/dossiers17170600000248841706000002488446PA7933302025-03-07False
17060000024932L17/dossiers17170600000248841706000002488447PA7932302025-03-07False
17060000024933L17/dossiers17170600000248841706000002488448PA7194362025-03-07False
17060000024934L17/dossiers17170600000248841706000002488449PA7949542025-03-07False
17060000024935L17/dossiers17170600000248841706000002488450PA7932902025-03-07False
17060000024936L17/dossiers17170600000248841706000002488451PA8401352025-03-07False
17060000024937L17/dossiers17170600000248841706000002488452PA8415532025-03-07False
17060000024938L17/dossiers17170600000248841706000002488453PA7940302025-03-07False
17060000024939L17/dossiers17170600000248841706000002488454PA8408692025-03-07False
17060000024940L17/dossiers17170600000248841706000002488455PA8406572025-03-07False
17060000024941L17/dossiers17170600000248841706000002488456PA8411312025-03-07False
17060000024942L17/dossiers17170600000248841706000002488457PA8417612025-03-07False
17060000024943L17/dossiers17170600000248841706000002488458PA7945302025-03-07False
17060000024944L17/dossiers17170600000248841706000002488459PA8418252025-03-07False
17060000024948L17/dossiers1717060000024946170600000249461PA7223902025-02-17False
17060000024949L17/dossiers1717060000024946170600000249462PA6428472025-02-17False
17060000024950L17/dossiers1717060000024946170600000249463PA7199682025-02-17False
17060000024951L17/dossiers1717060000024946170600000249464PA3422402025-02-17False
17060000024952L17/dossiers1717060000024946170600000249465PA7188502025-02-17False
17060000024953L17/dossiers1717060000024946170600000249466PA3325232025-02-042025-02-17False
17060000024954L17/dossiers1717060000024946170600000249467PA7940582025-02-17False
17060000024955L17/dossiers1717060000024946170600000249468PA8421172025-02-17False
17060000024956L17/dossiers1717060000024946170600000249469PA7930942025-02-17False
17060000024957L17/dossiers17170600000249461706000002494610PA6070902025-02-17False
17060000024958L17/dossiers17170600000249461706000002494611PA6427252025-02-17False
17060000024959L17/dossiers17170600000249461706000002494612PA6084162025-02-17False
17060000024963L17/dossiers1717060000024961170600000249611PA7959502025-03-25False
17060000024964L17/dossiers1717060000024961170600000249612PA7947982025-03-25False
17060000024965L17/dossiers1717060000024961170600000249613PA7939402025-03-25False
17060000024966L17/dossiers1717060000024961170600000249614PA7194722025-03-25False
17060000024967L17/dossiers1717060000024961170600000249615PA7223822025-03-25False
17060000024968L17/dossiers1717060000024961170600000249616PA7201542025-03-25False
17060000024969L17/dossiers1717060000024961170600000249617PA8402352025-03-25False
17060000024970L17/dossiers1717060000024961170600000249618PA7217642025-03-25False
17060000024971L17/dossiers1717060000024961170600000249619PA6431842025-03-25False
17060000024972L17/dossiers17170600000249611706000002496110PA8416932025-03-25False
17060000024973L17/dossiers17170600000249611706000002496111PA7200222025-03-25False
17060000024974L17/dossiers17170600000249611706000002496112PA3457222025-03-25False
17060000024975L17/dossiers17170600000249611706000002496113PA7953862025-03-25False
17060000024976L17/dossiers17170600000249611706000002496114PA7204462025-03-25False
17060000024977L17/dossiers17170600000249611706000002496115PA7942062025-03-25False
17060000024978L17/dossiers17170600000249611706000002496116PA7201462025-03-25False
17060000024979L17/dossiers17170600000249611706000002496117PA7959622025-03-25False
17060000024980L17/dossiers17170600000249611706000002496118PA7955282025-03-25False
17060000024981L17/dossiers17170600000249611706000002496119PA7948022025-03-25False
17060000024982L17/dossiers17170600000249611706000002496120PA7944862025-03-25False