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
17060000020697L17/dossiers171706000002056417060000020564132PA8413812025-03-27False
17060000020698L17/dossiers171706000002056417060000020564133PA8417132025-03-27False
17060000020699L17/dossiers171706000002056417060000020564134PA6431752025-02-242025-03-27False
17060000020700L17/dossiers171706000002056417060000020564135PA8418932025-03-27False
17060000020701L17/dossiers171706000002056417060000020564136PA7960182025-03-27False
17060000020705L17/dossiers1717060000020703170600000207031PA7223902025-06-11False
17060000020706L17/dossiers1717060000020703170600000207032PA7188382025-06-11False
17060000020707L17/dossiers1717060000020703170600000207033PA7188842025-06-11False
17060000020708L17/dossiers1717060000020703170600000207034PA8421172025-06-11False
17060000020709L17/dossiers1717060000020703170600000207035PA3300082025-06-11False
17060000020710L17/dossiers1717060000020703170600000207036PA7199682025-06-11False
17060000020711L17/dossiers1717060000020703170600000207037PA7214422025-06-11False
17060000020712L17/dossiers1717060000020703170600000207038PA7930942025-06-11False
17060000020713L17/dossiers1717060000020703170600000207039PA6088262025-06-11False
17060000020714L17/dossiers17170600000207031706000002070310PA3309092025-06-11False
17060000020715L17/dossiers17170600000207031706000002070311PA7940582025-06-11False
17060000020716L17/dossiers17170600000207031706000002070312PA7933222025-06-11False
17060000020717L17/dossiers17170600000207031706000002070313PA7944342025-06-11False
17060000020718L17/dossiers17170600000207031706000002070314PA8410672025-06-11False
17060000020719L17/dossiers17170600000207031706000002070315PA8416012025-06-11False
17060000020720L17/dossiers17170600000207031706000002070316PA8420972025-06-11False
17060000020721L17/dossiers17170600000207031706000002070317PA8420852025-06-11False
17060000020722L17/dossiers17170600000207031706000002070318PA8408172025-06-11False
17060000020723L17/dossiers17170600000207031706000002070319PA7931342025-06-11False
17060000020724L17/dossiers17170600000207031706000002070320PA7932182025-06-11False
17060000020725L17/dossiers17170600000207031706000002070321PA7959002025-06-11False
17060000020726L17/dossiers17170600000207031706000002070322PA8413592025-06-11False
17060000020727L17/dossiers17170600000207031706000002070323PA2675612025-06-11False
17060000020728L17/dossiers17170600000207031706000002070324PA6076192025-06-11False
17060000020729L17/dossiers17170600000207031706000002070325PA7219322025-06-11False
17060000020730L17/dossiers17170600000207031706000002070326PA7945702025-06-11False
17060000020731L17/dossiers17170600000207031706000002070327PA8401352025-06-11False
17060000020735L17/dossiers1717060000020733170600000207331PA7223902024-12-12False
17060000020736L17/dossiers1717060000020733170600000207332PA2667932024-12-12False
17060000020737L17/dossiers1717060000020733170600000207333PA7188842024-12-12False
17060000020738L17/dossiers1717060000020733170600000207334PA7933422024-12-12False
17060000020739L17/dossiers1717060000020733170600000207335PA4085782024-12-12False
17060000020740L17/dossiers1717060000020733170600000207336PA8418692024-12-12False
17060000020741L17/dossiers1717060000020733170600000207337PA7218162024-12-12False
17060000020742L17/dossiers1717060000020733170600000207338PA7192722024-12-12False
17060000020743L17/dossiers1717060000020733170600000207339PA8421172024-12-12False
17060000020744L17/dossiers17170600000207331706000002073310PA7214422024-12-12False
17060000020745L17/dossiers17170600000207331706000002073311PA3422402024-12-12False
17060000020746L17/dossiers17170600000207331706000002073312PA3467822024-12-12False
17060000020747L17/dossiers17170600000207331706000002073313PA7214102024-12-12False
17060000020748L17/dossiers17170600000207331706000002073314PA7940382024-12-12False
17060000020752L17/dossiers1717060000020750170600000207501PA6109682025-09-17False
17060000020753L17/dossiers1717060000020750170600000207502PA8409972025-09-17False
17060000020754L17/dossiers1717060000020750170600000207503PA8418852025-09-17False
17060000020755L17/dossiers1717060000020750170600000207504PA7950102025-09-17False