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
17060000046469L17/dossiers17170600000464231706000004642345PA8418932025-11-24False
17060000046473L17/dossiers1717060000046471170600000464711PA8407012025-10-03False
17060000046474L17/dossiers1717060000046471170600000464712PA8417692025-10-03False
17060000046475L17/dossiers1717060000046471170600000464713PA7956442025-10-03False
17060000046476L17/dossiers1717060000046471170600000464714PA7960342025-10-03False
17060000046477L17/dossiers1717060000046471170600000464715PA7940302025-10-03False
17060000046478L17/dossiers1717060000046471170600000464716PA7931342025-10-03False
17060000046479L17/dossiers1717060000046471170600000464717PA7932902025-10-03False
17060000046480L17/dossiers1717060000046471170600000464718PA8407212025-10-03False
17060000046484L17/dossiers1717060000046482170600000464821PA7223662025-12-10False
17060000046485L17/dossiers1717060000046482170600000464822PA7953902025-12-10False
17060000046486L17/dossiers1717060000046482170600000464823PA7197562025-12-10False
17060000046487L17/dossiers1717060000046482170600000464824PA7947022025-12-10False
17060000046488L17/dossiers1717060000046482170600000464825PA7201462025-12-10False
17060000046489L17/dossiers1717060000046482170600000464826PA7951762025-12-10False
17060000046490L17/dossiers1717060000046482170600000464827PA8172032025-12-10False
17060000046491L17/dossiers1717060000046482170600000464828PA7950502025-12-10False
17060000046492L17/dossiers1717060000046482170600000464829PA7219162025-12-10False
17060000046493L17/dossiers17170600000464821706000004648210PA7955282025-12-10False
17060000046494L17/dossiers17170600000464821706000004648211PA8419272025-12-10False
17060000046495L17/dossiers17170600000464821706000004648212PA7195502025-12-10False
17060000046496L17/dossiers17170600000464821706000004648213PA7221022025-12-10False
17060000046497L17/dossiers17170600000464821706000004648214PA7195122025-12-10False
17060000046498L17/dossiers17170600000464821706000004648215PA7950462025-12-10False
17060000046505L17/dossiers1717060000046503170600000465031PA7223902025-12-11False
17060000046506L17/dossiers1717060000046503170600000465032PA7120152025-12-11False
17060000046507L17/dossiers1717060000046503170600000465033PA7203862025-12-11False
17060000046508L17/dossiers1717060000046503170600000465034PA6427252025-12-11False
17060000046509L17/dossiers1717060000046503170600000465035PA7218162025-12-11False
17060000046510L17/dossiers1717060000046503170600000465036PA7214102025-12-11False
17060000046511L17/dossiers1717060000046503170600000465037PA8421172025-12-11False
17060000046512L17/dossiers1717060000046503170600000465038PA7949942025-12-11False
17060000046513L17/dossiers1717060000046503170600000465039PA7930942025-12-11False
17060000046514L17/dossiers17170600000465031706000004650310PA7941782025-12-11False
17060000046515L17/dossiers17170600000465031706000004650311PA6088262025-12-11False
17060000046516L17/dossiers17170600000465031706000004650312PA8700102025-12-11False
17060000046517L17/dossiers17170600000465031706000004650313PA6084162025-12-11False
17060000046518L17/dossiers17170600000465031706000004650314PA6428472025-12-11False
17060000046519L17/dossiers17170600000465031706000004650315PA2668082025-12-11False
17060000046520L17/dossiers17170600000465031706000004650316PA7940582025-12-11False
17060000046521L17/dossiers17170600000465031706000004650317PA16302025-12-11False
17060000046522L17/dossiers17170600000465031706000004650318PA7187842025-12-11False
17060000046523L17/dossiers17170600000465031706000004650319PA3325232025-12-11False
17060000046524L17/dossiers17170600000465031706000004650320PA8421412025-12-11False
17060000046525L17/dossiers17170600000465031706000004650321PA7188382025-12-11False
17060000046526L17/dossiers17170600000465031706000004650322PA6080162025-12-11False
17060000046530L17/dossiers1717060000046528170600000465281PA7223902025-09-30False
17060000046531L17/dossiers1717060000046528170600000465282PA6070902025-09-30False
17060000046532L17/dossiers1717060000046528170600000465283PA7187842025-09-30False
17060000046533L17/dossiers1717060000046528170600000465284PA7188382025-09-30False