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
17060000005019L17/dossiers171706000000490317060000004903115PA8172032023-04-28False
17060000005020L17/dossiers171706000000490317060000004903116PA7948782023-04-28False
17060000005021L17/dossiers171706000000490317060000004903117PA7957222023-04-28False
17060000005022L17/dossiers171706000000490317060000004903118PA7935882023-04-28False
17060000005023L17/dossiers171706000000490317060000004903119PA7196322023-04-28False
17060000005024L17/dossiers171706000000490317060000004903120PA7950502023-04-28False
17060000005025L17/dossiers171706000000490317060000004903121PA7192022023-04-28False
17060000005026L17/dossiers171706000000490317060000004903122PA7204802023-04-28False
17060000005027L17/dossiers171706000000490317060000004903123PA7959262023-04-28False
17060000005028L17/dossiers171706000000490317060000004903124PA7204142023-04-28False
17060000005029L17/dossiers171706000000490317060000004903125PA7189302023-04-28False
17060000005030L17/dossiers171706000000490317060000004903126PA7217102023-04-28False
17060000005031L17/dossiers171706000000490317060000004903127PA7218442023-04-28False
17060000005032L17/dossiers171706000000490317060000004903128PA7189102023-04-28False
17060000005033L17/dossiers171706000000490317060000004903129PA24492023-04-28False
17060000005034L17/dossiers171706000000490317060000004903130PA7196002023-04-28False
17060000005035L17/dossiers171706000000490317060000004903131PA7219162023-04-28False
17060000005036L17/dossiers171706000000490317060000004903132PA7223982023-04-28False
17060000005037L17/dossiers171706000000490317060000004903133PA7216782023-04-28False
17060000005038L17/dossiers171706000000490317060000004903134PA7209002023-04-28False
17060000005039L17/dossiers171706000000490317060000004903135PA7214262023-04-28False
17060000005040L17/dossiers171706000000490317060000004903136PA7200662023-04-28False
17060000005041L17/dossiers171706000000490317060000004903137PA7222522023-04-28False
17060000005042L17/dossiers171706000000490317060000004903138PA7955282023-04-28False
17060000005043L17/dossiers171706000000490317060000004903139PA7214582023-04-28False
17060000005044L17/dossiers171706000000490317060000004903140PA7932702023-04-28False
17060000005045L17/dossiers171706000000490317060000004903141PA3406432023-04-28False
17060000005046L17/dossiers171706000000490317060000004903142PA7222922023-04-28False
17060000005047L17/dossiers171706000000490317060000004903143PA7201382023-04-28False
17060000005048L17/dossiers171706000000490317060000004903144PA7572252023-04-28False
17060000005049L17/dossiers171706000000490317060000004903145PA7934162023-04-28False
17060000005050L17/dossiers171706000000490317060000004903146PA7948022023-04-28False
17060000005051L17/dossiers171706000000490317060000004903147PA7196722023-04-28False
17060000005052L17/dossiers171706000000490317060000004903148PA7201902023-04-28False
17060000005053L17/dossiers171706000000490317060000004903149PA7944862023-04-28False
17060000005054L17/dossiers171706000000490317060000004903150PA7207542023-04-28False
17060000005055L17/dossiers171706000000490317060000004903151PA7195502023-04-28False
17060000005056L17/dossiers171706000000490317060000004903152PA7949302023-04-28False
17060000005057L17/dossiers171706000000490317060000004903153PA7215842023-04-28False
17060000005058L17/dossiers171706000000490317060000004903154PA7200142023-04-28False
17060000005059L17/dossiers171706000000490317060000004903155PA6073952023-04-28False
17060000005060L17/dossiers171706000000490317060000004903156PA7214822023-04-28False
17060000005061L17/dossiers171706000000490317060000004903157PA7221022023-04-28False
17060000005062L17/dossiers171706000000490317060000004903158PA6066392023-04-28False
17060000005063L17/dossiers171706000000490317060000004903159PA7195122023-04-28False
17060000005064L17/dossiers171706000000490317060000004903160PA7211702023-04-28False
17060000005065L17/dossiers171706000000490317060000004903161PA7931942023-04-28False
17060000005066L17/dossiers171706000000490317060000004903162PA7212622023-04-28False
17060000005067L17/dossiers171706000000490317060000004903163PA7953262023-04-28False
17060000005068L17/dossiers171706000000490317060000004903164PA29602023-04-28False