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 151 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
17060000007147L17/dossiers1717060000007141170600000071415PA8410472025-02-17False
17060000007148L17/dossiers1717060000007141170600000071416PA7203862025-02-17False
17060000007149L17/dossiers1717060000007141170600000071417PA3325232024-09-172025-02-17False
17060000007150L17/dossiers1717060000007141170600000071418PA6059912025-02-17False
17060000007151L17/dossiers1717060000007141170600000071419PA2667972025-02-17False
17060000007152L17/dossiers17170600000071411706000000714110PA7940582025-02-17False
17060000007153L17/dossiers17170600000071411706000000714111PA16302025-02-17False
17060000007154L17/dossiers17170600000071411706000000714112PA6080162025-02-17False
17060000007155L17/dossiers17170600000071411706000000714113PA7933422025-02-17False
17060000007156L17/dossiers17170600000071411706000000714114PA7192722025-02-17False
17060000007157L17/dossiers17170600000071411706000000714115PA7940382025-02-17False
17060000007158L17/dossiers17170600000071411706000000714116PA7187842025-02-17False
17060000007159L17/dossiers17170600000071411706000000714117PA7214422025-02-17False
17060000007160L17/dossiers17170600000071411706000000714118PA7930942025-02-17False
17060000007161L17/dossiers17170600000071411706000000714119PA2677942025-02-17False
17060000007162L17/dossiers17170600000071411706000000714120PA7941782025-02-17False
17060000007163L17/dossiers17170600000071411706000000714121PA6070902025-02-17False
17060000007164L17/dossiers17170600000071411706000000714122PA6428472025-02-17False
17060000007165L17/dossiers17170600000071411706000000714123PA6955122025-02-17False
17060000007169L17/dossiers1717060000007167170600000071671PA7952282024-10-09False
17060000007170L17/dossiers1717060000007167170600000071672PA7932622024-10-09False
17060000007171L17/dossiers1717060000007167170600000071673PA8406652024-10-09False
17060000007172L17/dossiers1717060000007167170600000071674PA7949062024-10-09False
17060000007173L17/dossiers1717060000007167170600000071675PA7941382024-10-09False
17060000007174L17/dossiers1717060000007167170600000071676PA6109682024-10-09False
17060000007175L17/dossiers1717060000007167170600000071677PA7955882024-10-09False
17060000007176L17/dossiers1717060000007167170600000071678PA7950842024-10-09False
17060000007177L17/dossiers1717060000007167170600000071679PA8421052024-10-09False
17060000007178L17/dossiers17170600000071671706000000716710PA7937802024-10-09False
17060000007179L17/dossiers17170600000071671706000000716711PA5888842024-10-09False
17060000007180L17/dossiers17170600000071671706000000716712PA6427642024-10-09False
17060000007181L17/dossiers17170600000071671706000000716713PA8417012024-10-09False
17060000007182L17/dossiers17170600000071671706000000716714PA8408292024-10-09False
17060000007183L17/dossiers17170600000071671706000000716715PA2677632024-10-09False
17060000007184L17/dossiers17170600000071671706000000716716PA3359992024-10-09False
17060000007185L17/dossiers17170600000071671706000000716717PA3424152024-10-09False
17060000007186L17/dossiers17170600000071671706000000716718PA6067932024-10-09False
17060000007187L17/dossiers17170600000071671706000000716719PA7952782024-10-09False
17060000007188L17/dossiers17170600000071671706000000716720PA8422112024-10-09False
17060000007189L17/dossiers17170600000071671706000000716721PA7953622024-10-09False
17060000007190L17/dossiers17170600000071671706000000716722PA8416572024-10-09False
17060000007191L17/dossiers17170600000071671706000000716723PA7961062024-10-09False
17060000007192L17/dossiers17170600000071671706000000716724PA8413152024-10-09False
17060000007193L17/dossiers17170600000071671706000000716725PA7954542024-10-09False
17060000007194L17/dossiers17170600000071671706000000716726PA7937722024-10-09False
17060000007195L17/dossiers17170600000071671706000000716727PA7956162024-10-09False
17060000007196L17/dossiers17170600000071671706000000716728PA8409972024-10-09False
17060000007197L17/dossiers17170600000071671706000000716729PA7934442024-10-09False
17060000007198L17/dossiers17170600000071671706000000716730PA8418852024-10-09False
17060000007199L17/dossiers17170600000071671706000000716731PA8415072024-10-09False