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
17060000017260L17/dossiers17170600000172271706000001722732PA15672024-10-29False
17060000017261L17/dossiers17170600000172271706000001722733PA8414712024-10-29False
17060000017262L17/dossiers17170600000172271706000001722734PA8422632024-10-29False
17060000017263L17/dossiers17170600000172271706000001722735PA8418132024-10-29False
17060000017264L17/dossiers17170600000172271706000001722736PA8418532024-10-29False
17060000017265L17/dossiers17170600000172271706000001722737PA16542024-10-29False
17060000017266L17/dossiers17170600000172271706000001722738PA6431922024-10-29False
17060000017267L17/dossiers17170600000172271706000001722739PA3350542024-10-29False
17060000017268L17/dossiers17170600000172271706000001722740PA7951562024-10-29False
17060000017269L17/dossiers17170600000172271706000001722741PA7749582024-10-29False
17060000017270L17/dossiers17170600000172271706000001722742PA8407652024-10-29False
17060000017271L17/dossiers17170600000172271706000001722743PA8414632024-10-29False
17060000017272L17/dossiers17170600000172271706000001722744PA8411072024-10-29False
17060000017273L17/dossiers17170600000172271706000001722745PA8413812024-10-29False
17060000017274L17/dossiers17170600000172271706000001722746PA8407932024-10-29False
17060000017275L17/dossiers17170600000172271706000001722747PA7942702024-10-29False
17060000017276L17/dossiers17170600000172271706000001722748PA6081722024-10-29False
17060000017277L17/dossiers17170600000172271706000001722749PA6075532024-10-29False
17060000017278L17/dossiers17170600000172271706000001722750PA8409552024-10-29False
17060000017279L17/dossiers17170600000172271706000001722751PA8413672024-10-29False
17060000017280L17/dossiers17170600000172271706000001722752PA3419812024-10-29False
17060000017281L17/dossiers17170600000172271706000001722753PA8406732024-10-29False
17060000017282L17/dossiers17170600000172271706000001722754PA3421962024-10-29False
17060000017283L17/dossiers17170600000172271706000001722755PA8266352024-10-29False
17060000017284L17/dossiers17170600000172271706000001722756PA8413272024-10-29False
17060000017285L17/dossiers17170600000172271706000001722757PA8417172024-10-29False
17060000017286L17/dossiers17170600000172271706000001722758PA8412432024-10-29False
17060000017287L17/dossiers17170600000172271706000001722759PA7749602024-10-29False
17060000017288L17/dossiers17170600000172271706000001722760PA3403432024-10-29False
17060000017289L17/dossiers17170600000172271706000001722761PA8410912024-10-29False
17060000017290L17/dossiers17170600000172271706000001722762PA8416812024-10-29False
17060000017291L17/dossiers17170600000172271706000001722763PA8418932024-10-29False
17060000017292L17/dossiers17170600000172271706000001722764PA7938162024-10-29False
17060000017293L17/dossiers17170600000172271706000001722765PA7944942024-10-29False
17060000017303L17/dossiers1717060000017301170600000173011PA7941782024-11-05False
17060000017304L17/dossiers1717060000017301170600000173012PA7188502024-11-05False
17060000017311L17/dossiers1717060000017309170600000173091PA7948542024-11-07False
17060000017312L17/dossiers1717060000017309170600000173092PA7199302024-11-07False
17060000017313L17/dossiers1717060000017309170600000173093PA7223662024-11-07False
17060000017314L17/dossiers1717060000017309170600000173094PA7959502024-11-07False
17060000017315L17/dossiers1717060000017309170600000173095PA7211582024-11-07False
17060000017316L17/dossiers1717060000017309170600000173096PA7221902024-11-07False
17060000017317L17/dossiers1717060000017309170600000173097PA6429352024-11-07False
17060000017318L17/dossiers1717060000017309170600000173098PA7203622024-11-07False
17060000017319L17/dossiers1717060000017309170600000173099PA7220462024-11-07False
17060000017320L17/dossiers17170600000173091706000001730910PA7192182024-11-07False
17060000017321L17/dossiers17170600000173091706000001730911PA7171612024-11-07False
17060000017322L17/dossiers17170600000173091706000001730912PA6426952024-11-07False
17060000017323L17/dossiers17170600000173091706000001730913PA6065072024-11-07False
17060000017324L17/dossiers17170600000173091706000001730914PA7219082024-11-07False