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
17060000052250L17/dossiers171706000005212917060000052129120PA7953262026-07-03False
17060000052251L17/dossiers171706000005212917060000052129121PA7216322026-07-03False
17060000052252L17/dossiers171706000005212917060000052129122PA7210042026-07-03False
17060000052253L17/dossiers171706000005212917060000052129123PA7120142026-07-03False
17060000052254L17/dossiers171706000005212917060000052129124PA7955282026-07-03False
17060000052255L17/dossiers171706000005212917060000052129125PA7217502026-07-03False
17060000052256L17/dossiers171706000005212917060000052129126PA7959202026-07-03False
17060000052257L17/dossiers171706000005212917060000052129127PA7220002026-07-03False
17060000052258L17/dossiers171706000005212917060000052129128PA7219162026-07-03False
17060000052259L17/dossiers171706000005212917060000052129129PA7950462026-06-092026-06-09False
17060000052260L17/dossiers171706000005212917060000052129130PA7201902026-07-03False
17060000052261L17/dossiers171706000005212917060000052129131PA7173792026-07-03False
17060000052262L17/dossiers171706000005212917060000052129132PA7217642026-07-03False
17060000052263L17/dossiers171706000005212917060000052129133PA7191182026-07-03False
17060000052264L17/dossiers171706000005212917060000052129134PA7195122026-07-03False
17060000052265L17/dossiers171706000005212917060000052129135PA6073952026-07-03False
17060000052266L17/dossiers171706000005212917060000052129136PA7952442026-07-03False
17060000052267L17/dossiers171706000005212917060000052129137PA7956642026-07-03False
17060000052268L17/dossiers171706000005212917060000052129138PA6426952026-07-03False
17060000052269L17/dossiers171706000005212917060000052129139PA7192182026-07-03False
17060000052270L17/dossiers171706000005212917060000052129140PA8418012026-07-03False
17060000052271L17/dossiers171706000005212917060000052129141PA7937162026-07-03False
17060000052272L17/dossiers171706000005212917060000052129142PA7211582026-07-03False
17060000052273L17/dossiers171706000005212917060000052129143PA7201462026-07-03False
17060000052274L17/dossiers171706000005212917060000052129144PA7190322026-07-03False
17060000052275L17/dossiers171706000005212917060000052129145PA6431842026-07-03False
17060000052276L17/dossiers171706000005212917060000052129146PA7214742026-07-03False
17060000052277L17/dossiers171706000005212917060000052129147PA8413592026-07-03False
17060000052278L17/dossiers171706000005212917060000052129148PA7218442026-07-03False
17060000052279L17/dossiers171706000005212917060000052129149PA6431752026-07-03False
17060000052280L17/dossiers171706000005212917060000052129150PA7216122026-07-03False
17060000052281L17/dossiers171706000005212917060000052129151PA8402352026-07-03False
17060000052282L17/dossiers171706000005212917060000052129152PA6076192026-07-03False
17060000052283L17/dossiers171706000005212917060000052129153PA7946582026-07-03False
17060000052284L17/dossiers171706000005212917060000052129154PA7958842026-07-03False
17060000052285L17/dossiers171706000005212917060000052129155PA7950502026-07-03False
17060000052286L17/dossiers171706000005212917060000052129156PA7931742026-07-03False
17060000052287L17/dossiers171706000005212917060000052129157PA7943302026-07-03False
17060000052288L17/dossiers171706000005212917060000052129158PA8414192026-07-03False
17060000052289L17/dossiers171706000005212917060000052129159PA7960782026-07-03False
17060000052290L17/dossiers171706000005212917060000052129160PA7204462026-07-03False
17060000052291L17/dossiers171706000005212917060000052129161PA6872142026-07-03False
17060000052292L17/dossiers171706000005212917060000052129162PA7214102026-07-03False
17060000052293L17/dossiers171706000005212917060000052129163PA7203542026-07-03False
17060000052294L17/dossiers171706000005212917060000052129164PA7188202026-07-03False
17060000052295L17/dossiers171706000005212917060000052129165PA7200222026-07-03False
17060000052296L17/dossiers171706000005212917060000052129166PA7202562026-07-03False
17060000052297L17/dossiers171706000005212917060000052129167PA2677632026-07-03False
17060000052298L17/dossiers171706000005212917060000052129168PA7953502026-07-03False
17060000052299L17/dossiers171706000005212917060000052129169PA7194722026-07-03False