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
17060000051552L17/dossiers17170600000514931706000005149358PA7937562025-12-18False
17060000051553L17/dossiers17170600000514931706000005149359PA7960622025-12-18False
17060000051554L17/dossiers17170600000514931706000005149360PA7195782025-12-18False
17060000051555L17/dossiers17170600000514931706000005149361PA7210622025-12-18False
17060000051556L17/dossiers17170600000514931706000005149362PA8418452025-12-18False
17060000051557L17/dossiers17170600000514931706000005149363PA7959822025-12-18False
17060000051558L17/dossiers17170600000514931706000005149364PA7954662025-12-18False
17060000051559L17/dossiers17170600000514931706000005149365PA7937442025-12-18False
17060000051560L17/dossiers17170600000514931706000005149366PA7209522025-12-18False
17060000051561L17/dossiers17170600000514931706000005149367PA7941062025-12-18False
17060000051562L17/dossiers17170600000514931706000005149368PA7941662025-12-18False
17060000051563L17/dossiers17170600000514931706000005149369PA7951642025-12-18False
17060000051564L17/dossiers17170600000514931706000005149370PA7955962025-12-18False
17060000051565L17/dossiers17170600000514931706000005149371PA8416812025-12-18False
17060000051566L17/dossiers17170600000514931706000005149372PA7212702025-12-18False
17060000051567L17/dossiers17170600000514931706000005149373PA7218962025-12-18False
17060000051571L17/dossiers1717060000051569170600000515691PA8420132025-11-28False
17060000051572L17/dossiers1717060000051569170600000515692PA8418852025-11-28False
17060000051576L17/dossiers1717060000051574170600000515741PA8420132025-12-01False
17060000051577L17/dossiers1717060000051574170600000515742PA8418852025-12-01False
17060000051581L17/dossiers1717060000051579170600000515791PA8410672025-12-05False
17060000051582L17/dossiers1717060000051579170600000515792PA8411832025-12-05False
17060000051583L17/dossiers1717060000051579170600000515793PA8417692025-12-05False
17060000051584L17/dossiers1717060000051579170600000515794PA7933222025-12-05False
17060000051585L17/dossiers1717060000051579170600000515795PA8407212025-12-05False
17060000051586L17/dossiers1717060000051579170600000515796PA8407012025-12-05False
17060000051590L17/dossiers1717060000051588170600000515881PA6056942025-12-08False
17060000051591L17/dossiers1717060000051588170600000515882PA7195122025-12-08False
17060000051592L17/dossiers1717060000051588170600000515883PA2677802025-12-08False
17060000051593L17/dossiers1717060000051588170600000515884PA7221422025-12-08False
17060000051594L17/dossiers1717060000051588170600000515885PA8419312025-12-08False
17060000051595L17/dossiers1717060000051588170600000515886PA8418532025-12-08False
17060000051596L17/dossiers1717060000051588170600000515887PA7946582025-12-08False
17060000051597L17/dossiers1717060000051588170600000515888PA8422632025-12-08False
17060000051598L17/dossiers1717060000051588170600000515889PA7933142025-12-08False
17060000051599L17/dossiers17170600000515881706000005158810PA7947022025-12-08False
17060000051600L17/dossiers17170600000515881706000005158811PA7212962025-12-08False
17060000051601L17/dossiers17170600000515881706000005158812PA8423112025-12-08False
17060000051602L17/dossiers17170600000515881706000005158813PA7749622025-12-08False
17060000051603L17/dossiers17170600000515881706000005158814PA2670422025-12-08False
17060000051604L17/dossiers17170600000515881706000005158815PA7931942025-12-08False
17060000051605L17/dossiers17170600000515881706000005158816PA7949822025-12-08False
17060000051606L17/dossiers17170600000515881706000005158817PA7952402025-12-08False
17060000051607L17/dossiers17170600000515881706000005158818PA6431752025-12-08False
17060000051608L17/dossiers17170600000515881706000005158819PA6065072025-12-08False
17060000051609L17/dossiers17170600000515881706000005158820PA7212342025-12-08False
17060000051610L17/dossiers17170600000515881706000005158821PA7223902025-12-08False
17060000051611L17/dossiers17170600000515881706000005158822PA3457222025-12-08False
17060000051612L17/dossiers17170600000515881706000005158823PA8413592025-12-08False
17060000051613L17/dossiers17170600000515881706000005158824PA8421252025-12-08False