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
17060000028563L17/dossiers1717060000028560170600000285602PA7199302025-03-11False
17060000028564L17/dossiers1717060000028560170600000285603PA8406652025-03-11False
17060000028565L17/dossiers1717060000028560170600000285604PA6427642025-03-11False
17060000028566L17/dossiers1717060000028560170600000285605PA6431432025-03-11False
17060000028567L17/dossiers1717060000028560170600000285606PA8408292025-03-11False
17060000028568L17/dossiers1717060000028560170600000285607PA3424152025-03-11False
17060000028569L17/dossiers1717060000028560170600000285608PA6067932025-03-11False
17060000028570L17/dossiers1717060000028560170600000285609PA8422112025-03-11False
17060000028571L17/dossiers17170600000285601706000002856010PA8413152025-03-11False
17060000028572L17/dossiers17170600000285601706000002856011PA7940942025-03-11False
17060000028573L17/dossiers17170600000285601706000002856012PA7936242025-03-11False
17060000028574L17/dossiers17170600000285601706000002856013PA7957622025-03-11False
17060000028575L17/dossiers17170600000285601706000002856014PA6082642025-03-11False
17060000028576L17/dossiers17170600000285601706000002856015PA8409032025-03-11False
17060000028577L17/dossiers17170600000285601706000002856016PA8412952025-03-11False
17060000028578L17/dossiers17170600000285601706000002856017PA10082025-03-11False
17060000028579L17/dossiers17170600000285601706000002856018PA7933942025-03-11False
17060000028580L17/dossiers17170600000285601706000002856019PA7954302025-03-11False
17060000028581L17/dossiers17170600000285601706000002856020PA8419192025-03-11False
17060000028582L17/dossiers17170600000285601706000002856021PA6065732025-03-11False
17060000028583L17/dossiers17170600000285601706000002856022PA8416332025-03-11False
17060000028584L17/dossiers17170600000285601706000002856023PA7948542025-03-11False
17060000028585L17/dossiers17170600000285601706000002856024PA8421952025-03-11False
17060000028586L17/dossiers17170600000285601706000002856025PA6093322025-03-11False
17060000028587L17/dossiers17170600000285601706000002856026PA8416652025-03-11False
17060000028588L17/dossiers17170600000285601706000002856027PA3332852025-03-11False
17060000028589L17/dossiers17170600000285601706000002856028PA8409392025-03-11False
17060000028590L17/dossiers17170600000285601706000002856029PA8415392025-03-11False
17060000028591L17/dossiers17170600000285601706000002856030PA3319732025-03-11False
17060000028592L17/dossiers17170600000285601706000002856031PA8401712025-03-11False
17060000028593L17/dossiers17170600000285601706000002856032PA15672025-03-11False
17060000028594L17/dossiers17170600000285601706000002856033PA8414712025-03-11False
17060000028595L17/dossiers17170600000285601706000002856034PA8422632025-03-11False
17060000028596L17/dossiers17170600000285601706000002856035PA8418132025-03-11False
17060000028597L17/dossiers17170600000285601706000002856036PA8418532025-03-11False
17060000028598L17/dossiers17170600000285601706000002856037PA16542025-03-11False
17060000028599L17/dossiers17170600000285601706000002856038PA6431922025-03-11False
17060000028600L17/dossiers17170600000285601706000002856039PA3350542025-03-11False
17060000028601L17/dossiers17170600000285601706000002856040PA7951562025-03-11False
17060000028602L17/dossiers17170600000285601706000002856041PA7749582025-03-11False
17060000028603L17/dossiers17170600000285601706000002856042PA8414632025-03-11False
17060000028604L17/dossiers17170600000285601706000002856043PA6431572025-03-11False
17060000028605L17/dossiers17170600000285601706000002856044PA8411072025-03-11False
17060000028606L17/dossiers17170600000285601706000002856045PA8413812025-03-11False
17060000028607L17/dossiers17170600000285601706000002856046PA7942702025-03-11False
17060000028608L17/dossiers17170600000285601706000002856047PA6081722025-03-11False
17060000028609L17/dossiers17170600000285601706000002856048PA6075532025-03-11False
17060000028610L17/dossiers17170600000285601706000002856049PA8409552025-03-11False
17060000028611L17/dossiers17170600000285601706000002856050PA8413672025-03-11False
17060000028612L17/dossiers17170600000285601706000002856051PA3419812025-03-11False