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
17060000007821L17/dossiers17170600000077981706000000779822PA7948542024-10-12False
17060000007822L17/dossiers17170600000077981706000000779823PA8421952024-10-12False
17060000007823L17/dossiers17170600000077981706000000779824PA6093322024-10-12False
17060000007824L17/dossiers17170600000077981706000000779825PA8416652024-10-12False
17060000007825L17/dossiers17170600000077981706000000779826PA3332852024-10-12False
17060000007826L17/dossiers17170600000077981706000000779827PA8409392024-10-12False
17060000007827L17/dossiers17170600000077981706000000779828PA8415392024-10-12False
17060000007828L17/dossiers17170600000077981706000000779829PA3319732024-10-12False
17060000007829L17/dossiers17170600000077981706000000779830PA8401712024-10-12False
17060000007830L17/dossiers17170600000077981706000000779831PA15672024-10-12False
17060000007831L17/dossiers17170600000077981706000000779832PA8414712024-10-12False
17060000007832L17/dossiers17170600000077981706000000779833PA8422632024-10-12False
17060000007833L17/dossiers17170600000077981706000000779834PA8418132024-10-12False
17060000007834L17/dossiers17170600000077981706000000779835PA8418532024-10-12False
17060000007835L17/dossiers17170600000077981706000000779836PA16542024-10-12False
17060000007836L17/dossiers17170600000077981706000000779837PA6431922024-10-12False
17060000007837L17/dossiers17170600000077981706000000779838PA3350542024-10-12False
17060000007838L17/dossiers17170600000077981706000000779839PA7951562024-10-12False
17060000007839L17/dossiers17170600000077981706000000779840PA7749582024-10-12False
17060000007840L17/dossiers17170600000077981706000000779841PA8407652024-10-12False
17060000007841L17/dossiers17170600000077981706000000779842PA8414632024-10-12False
17060000007842L17/dossiers17170600000077981706000000779843PA6431572024-10-12False
17060000007843L17/dossiers17170600000077981706000000779844PA8411072024-10-12False
17060000007844L17/dossiers17170600000077981706000000779845PA8413812024-10-12False
17060000007845L17/dossiers17170600000077981706000000779846PA8407932024-10-12False
17060000007846L17/dossiers17170600000077981706000000779847PA7942702024-10-12False
17060000007847L17/dossiers17170600000077981706000000779848PA6075532024-10-12False
17060000007848L17/dossiers17170600000077981706000000779849PA8409552024-10-12False
17060000007849L17/dossiers17170600000077981706000000779850PA8413672024-10-12False
17060000007850L17/dossiers17170600000077981706000000779851PA3419812024-10-12False
17060000007851L17/dossiers17170600000077981706000000779852PA8406732024-10-12False
17060000007852L17/dossiers17170600000077981706000000779853PA3421962024-10-12False
17060000007853L17/dossiers17170600000077981706000000779854PA8266352024-10-12False
17060000007854L17/dossiers17170600000077981706000000779855PA8413272024-10-12False
17060000007855L17/dossiers17170600000077981706000000779856PA8417172024-10-12False
17060000007856L17/dossiers17170600000077981706000000779857PA8412432024-10-12False
17060000007857L17/dossiers17170600000077981706000000779858PA7749602024-10-12False
17060000007858L17/dossiers17170600000077981706000000779859PA3403432024-10-12False
17060000007859L17/dossiers17170600000077981706000000779860PA8410912024-10-12False
17060000007860L17/dossiers17170600000077981706000000779861PA8416812024-10-12False
17060000007861L17/dossiers17170600000077981706000000779862PA8418932024-10-12False
17060000007862L17/dossiers17170600000077981706000000779863PA7938162024-10-12False
17060000007863L17/dossiers17170600000077981706000000779864PA7944942024-10-12False
17060000007864L17/dossiers17170600000077981706000000779865PA7209922024-10-12False
17060000007865L17/dossiers17170600000077981706000000779866PA7937802024-10-12False
17060000007866L17/dossiers17170600000077981706000000779867PA6100022024-10-12False
17060000007867L17/dossiers17170600000077981706000000779868PA7948702024-10-12False
17060000007868L17/dossiers17170600000077981706000000779869PA6431752024-10-12False
17060000007869L17/dossiers17170600000077981706000000779870PA7212702024-10-12False
17060000007873L17/dossiers1717060000007871170600000078711PA6428472024-09-17False