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
17060000016665L17/dossiers1717060000016658170600000166586PA7932102024-10-29False
17060000016666L17/dossiers1717060000016658170600000166587PA7952402024-10-29False
17060000016667L17/dossiers1717060000016658170600000166588PA7937442024-10-29False
17060000016671L17/dossiers1717060000016669170600000166691PA7223902024-10-30False
17060000016672L17/dossiers1717060000016669170600000166692PA2667932024-10-30False
17060000016673L17/dossiers1717060000016669170600000166693PA7192722024-10-30False
17060000016674L17/dossiers1717060000016669170600000166694PA7930942024-10-30False
17060000016675L17/dossiers1717060000016669170600000166695PA8417452024-10-30False
17060000016676L17/dossiers1717060000016669170600000166696PA4085782024-10-30False
17060000016677L17/dossiers1717060000016669170600000166697PA7188382024-10-30False
17060000016678L17/dossiers1717060000016669170600000166698PA6088262024-10-30False
17060000016679L17/dossiers1717060000016669170600000166699PA8421172024-10-30False
17060000016680L17/dossiers17170600000166691706000001666910PA3467822024-10-30False
17060000016681L17/dossiers17170600000166691706000001666911PA7223282024-10-30False
17060000016682L17/dossiers17170600000166691706000001666912PA7940382024-10-30False
17060000016683L17/dossiers17170600000166691706000001666913PA6070902024-10-30False
17060000016684L17/dossiers17170600000166691706000001666914PA13272024-10-30False
17060000016688L17/dossiers1717060000016686170600000166861PA7220462025-03-27False
17060000016689L17/dossiers1717060000016686170600000166862PA8417092025-03-27False
17060000016690L17/dossiers1717060000016686170600000166863PA6431842024-10-292025-03-27False
17060000016691L17/dossiers1717060000016686170600000166864PA7947022025-03-27False
17060000016692L17/dossiers1717060000016686170600000166865PA7951762025-03-27False
17060000016693L17/dossiers1717060000016686170600000166866PA7221022025-03-27False
17060000016694L17/dossiers1717060000016686170600000166867PA7950462025-03-27False
17060000016698L17/dossiers1717060000016696170600000166961PA7934322025-03-07False
17060000016699L17/dossiers1717060000016696170600000166962PA7961182025-03-07False
17060000016700L17/dossiers1717060000016696170600000166963PA7945622025-03-07False
17060000016701L17/dossiers1717060000016696170600000166964PA7931582025-03-07False
17060000016702L17/dossiers1717060000016696170600000166965PA7944342025-03-07False
17060000016703L17/dossiers1717060000016696170600000166966PA3096432025-03-07False
17060000016704L17/dossiers1717060000016696170600000166967PA8420012025-03-07False
17060000016705L17/dossiers1717060000016696170600000166968PA7206682025-03-07False
17060000016706L17/dossiers1717060000016696170600000166969PA7948862025-03-07False
17060000016707L17/dossiers17170600000166961706000001669610PA7960422025-03-07False
17060000016708L17/dossiers17170600000166961706000001669611PA8414872025-03-07False
17060000016709L17/dossiers17170600000166961706000001669612PA7931342025-03-07False
17060000016710L17/dossiers17170600000166961706000001669613PA8407212025-03-07False
17060000016711L17/dossiers17170600000166961706000001669614PA7204682025-03-07False
17060000016712L17/dossiers17170600000166961706000001669615PA8401592025-03-07False
17060000016713L17/dossiers17170600000166961706000001669616PA8401192025-03-07False
17060000016714L17/dossiers17170600000166961706000001669617PA7931662025-03-07False
17060000016715L17/dossiers17170600000166961706000001669618PA7947622025-03-07False
17060000016716L17/dossiers17170600000166961706000001669619PA8416212025-03-07False
17060000016717L17/dossiers17170600000166961706000001669620PA7932462025-03-07False
17060000016718L17/dossiers17170600000166961706000001669621PA8416132025-03-07False
17060000016719L17/dossiers17170600000166961706000001669622PA8417372025-03-07False
17060000016720L17/dossiers17170600000166961706000001669623PA7960342025-03-07False
17060000016721L17/dossiers17170600000166961706000001669624PA7938322025-03-07False
17060000016722L17/dossiers17170600000166961706000001669625PA7933622025-03-07False
17060000016723L17/dossiers17170600000166961706000001669626PA7944182025-03-07False