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
17060000020043L17/dossiers17170600000199641706000001996478PA8417772024-12-032025-03-11False
17060000020044L17/dossiers17170600000199641706000001996479PA7933822025-03-11False
17060000020045L17/dossiers17170600000199641706000001996480PA8415532025-03-11False
17060000020046L17/dossiers17170600000199641706000001996481PA7932982025-03-11False
17060000020047L17/dossiers17170600000199641706000001996482PA8407812025-03-11False
17060000020048L17/dossiers17170600000199641706000001996483PA7949462025-03-11False
17060000020049L17/dossiers17170600000199641706000001996484PA8415752025-03-11False
17060000020050L17/dossiers17170600000199641706000001996485PA8414792025-03-11False
17060000020069L17/dossiers1717060000020067170600000200671PA29522026-02-03False
17060000020070L17/dossiers1717060000020067170600000200672PA7212342026-02-03False
17060000020071L17/dossiers1717060000020067170600000200673PA7943542026-02-03False
17060000020072L17/dossiers1717060000020067170600000200674PA7940582026-02-03False
17060000020073L17/dossiers1717060000020067170600000200675PA7933742026-02-03False
17060000020074L17/dossiers1717060000020067170600000200676PA7200382026-02-03False
17060000020075L17/dossiers1717060000020067170600000200677PA7941782026-02-03False
17060000020076L17/dossiers1717060000020067170600000200678PA7188382026-02-03False
17060000020077L17/dossiers1717060000020067170600000200679PA8419312026-02-03False
17060000020078L17/dossiers17170600000200671706000002006710PA7931222026-02-03False
17060000020079L17/dossiers17170600000200671706000002006711PA6429352026-02-03False
17060000020080L17/dossiers17170600000200671706000002006712PA7214862026-02-03False
17060000020081L17/dossiers17170600000200671706000002006713PA3422402026-02-03False
17060000020082L17/dossiers17170600000200671706000002006714PA7936962026-02-03False
17060000020083L17/dossiers17170600000200671706000002006715PA2673182026-02-03False
17060000020084L17/dossiers17170600000200671706000002006716PA7930942026-02-03False
17060000020085L17/dossiers17170600000200671706000002006717PA7932462026-02-03False
17060000020086L17/dossiers17170600000200671706000002006718PA7188502026-02-03False
17060000020087L17/dossiers17170600000200671706000002006719PA7199682026-02-03False
17060000020088L17/dossiers17170600000200671706000002006720PA15922026-02-03False
17060000020089L17/dossiers17170600000200671706000002006721PA7950262026-02-03False
17060000020090L17/dossiers17170600000200671706000002006722PA3309092026-02-03False
17060000020091L17/dossiers17170600000200671706000002006723PA7192722026-02-03False
17060000020092L17/dossiers17170600000200671706000002006724PA7943302026-02-03False
17060000020093L17/dossiers17170600000200671706000002006725PA7937962026-02-03False
17060000020094L17/dossiers17170600000200671706000002006726PA8414192026-02-03False
17060000020095L17/dossiers17170600000200671706000002006727PA6070902026-02-03False
17060000020096L17/dossiers17170600000200671706000002006728PA6088262026-02-03False
17060000020097L17/dossiers17170600000200671706000002006729PA8417452025-04-282025-04-30False
17060000020098L17/dossiers17170600000200671706000002006730PA29602026-02-03False
17060000020099L17/dossiers17170600000200671706000002006731PA7223282025-04-282025-04-30False
17060000020100L17/dossiers17170600000200671706000002006732PA7187842026-02-03False
17060000020101L17/dossiers17170600000200671706000002006733PA3096432026-02-03False
17060000020102L17/dossiers17170600000200671706000002006734PA7188842026-02-03False
17060000020103L17/dossiers17170600000200671706000002006735PA7933222026-02-03False
17060000020104L17/dossiers17170600000200671706000002006736PA7947022026-02-03False
17060000020105L17/dossiers17170600000200671706000002006737PA7949462026-02-03False
17060000020106L17/dossiers17170600000200671706000002006738PA7932302026-02-03False
17060000020107L17/dossiers17170600000200671706000002006739PA7223902026-02-03False
17060000020108L17/dossiers17170600000200671706000002006740PA13272026-02-03False
17060000020109L17/dossiers17170600000200671706000002006741PA7196322026-02-03False
17060000020110L17/dossiers17170600000200671706000002006742PA6076192026-02-03False