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
17060000051346L17/dossiers1717060000051340170600000513405PA6429352026-01-21False
17060000051347L17/dossiers1717060000051340170600000513406PA7192182026-01-21False
17060000051348L17/dossiers1717060000051340170600000513407PA7171612026-01-21False
17060000051349L17/dossiers1717060000051340170600000513408PA6426952026-01-21False
17060000051350L17/dossiers1717060000051340170600000513409PA6065072026-01-21False
17060000051351L17/dossiers17170600000513401706000005134010PA7943302026-01-21False
17060000051352L17/dossiers17170600000513401706000005134011PA7198902026-01-21False
17060000051353L17/dossiers17170600000513401706000005134012PA7220002026-01-21False
17060000051354L17/dossiers17170600000513401706000005134013PA7947982026-01-21False
17060000051355L17/dossiers17170600000513401706000005134014PA7217502026-01-21False
17060000051356L17/dossiers17170600000513401706000005134015PA7199222026-01-21False
17060000051357L17/dossiers17170600000513401706000005134016PA7939402026-01-21False
17060000051358L17/dossiers17170600000513401706000005134017PA7194722026-01-21False
17060000051359L17/dossiers17170600000513401706000005134018PA7958642026-01-21False
17060000051360L17/dossiers17170600000513401706000005134019PA7959082026-01-21False
17060000051361L17/dossiers17170600000513401706000005134020PA7954022026-01-21False
17060000051362L17/dossiers17170600000513401706000005134021PA7191182026-01-21False
17060000051363L17/dossiers17170600000513401706000005134022PA7949822026-01-21False
17060000051364L17/dossiers17170600000513401706000005134023PA7223822026-01-21False
17060000051365L17/dossiers17170600000513401706000005134024PA7201542026-01-21False
17060000051366L17/dossiers17170600000513401706000005134025PA7958842026-01-21False
17060000051367L17/dossiers17170600000513401706000005134026PA7221342026-01-21False
17060000051368L17/dossiers17170600000513401706000005134027PA8402352026-01-21False
17060000051369L17/dossiers17170600000513401706000005134028PA7223662026-01-21False
17060000051370L17/dossiers17170600000513401706000005134029PA7197362026-01-21False
17060000051371L17/dossiers17170600000513401706000005134030PA7223582026-01-21False
17060000051372L17/dossiers17170600000513401706000005134031PA7210242026-01-21False
17060000051373L17/dossiers17170600000513401706000005134032PA7186742026-01-21False
17060000051374L17/dossiers17170600000513401706000005134033PA7212962026-01-21False
17060000051375L17/dossiers17170600000513401706000005134034PA7217642026-01-21False
17060000051376L17/dossiers17170600000513401706000005134035PA2672002026-01-21False
17060000051377L17/dossiers17170600000513401706000005134036PA7959542026-01-21False
17060000051378L17/dossiers17170600000513401706000005134037PA7203542026-01-21False
17060000051379L17/dossiers17170600000513401706000005134038PA7193722026-01-21False
17060000051380L17/dossiers17170600000513401706000005134039PA6431842026-01-21False
17060000051381L17/dossiers17170600000513401706000005134040PA7197982026-01-21False
17060000051382L17/dossiers17170600000513401706000005134041PA7210042026-01-21False
17060000051383L17/dossiers17170600000513401706000005134042PA7953902026-01-21False
17060000051384L17/dossiers17170600000513401706000005134043PA7953342026-01-21False
17060000051385L17/dossiers17170600000513401706000005134044PA7200222026-01-21False
17060000051386L17/dossiers17170600000513401706000005134045PA7194122026-01-21False
17060000051387L17/dossiers17170600000513401706000005134046PA7194042026-01-21False
17060000051388L17/dossiers17170600000513401706000005134047PA3457222026-01-21False
17060000051389L17/dossiers17170600000513401706000005134048PA7193882026-01-21False
17060000051390L17/dossiers17170600000513401706000005134049PA7197562026-01-21False
17060000051391L17/dossiers17170600000513401706000005134050PA7203422026-01-21False
17060000051392L17/dossiers17170600000513401706000005134051PA7218522026-01-21False
17060000051393L17/dossiers17170600000513401706000005134052PA7120142026-01-21False
17060000051394L17/dossiers17170600000513401706000005134053PA7204462026-01-21False
17060000051395L17/dossiers17170600000513401706000005134054PA7173792026-01-21False