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
17060000026237L17/dossiers1717060000026234170600000262342PA7952782025-02-13False
17060000026238L17/dossiers1717060000026234170600000262343PA2677802025-02-13False
17060000026239L17/dossiers1717060000026234170600000262344PA7220702025-02-13False
17060000026240L17/dossiers1717060000026234170600000262345PA7192822025-02-13False
17060000026241L17/dossiers1717060000026234170600000262346PA8421252025-02-13False
17060000026242L17/dossiers1717060000026234170600000262347PA7944662025-02-13False
17060000026243L17/dossiers1717060000026234170600000262348PA7218442025-02-13False
17060000026244L17/dossiers1717060000026234170600000262349PA7950262025-02-13False
17060000026248L17/dossiers1717060000026246170600000262461PA7939922025-02-13False
17060000026249L17/dossiers1717060000026246170600000262462PA7192822025-02-13False
17060000026250L17/dossiers1717060000026246170600000262463PA8421252025-02-13False
17060000026251L17/dossiers1717060000026246170600000262464PA7948382025-02-13False
17060000026252L17/dossiers1717060000026246170600000262465PA7218442025-02-13False
17060000026253L17/dossiers1717060000026246170600000262466PA7950262025-02-13False
17060000026257L17/dossiers1717060000026255170600000262551PA7120152025-02-13False
17060000026261L17/dossiers1717060000026259170600000262591PA7958082025-03-11False
17060000026262L17/dossiers1717060000026259170600000262592PA8420132025-03-11False
17060000026263L17/dossiers1717060000026259170600000262593PA7940082025-03-11False
17060000026264L17/dossiers1717060000026259170600000262594PA6109682025-03-11False
17060000026265L17/dossiers1717060000026259170600000262595PA7937802025-03-11False
17060000026266L17/dossiers1717060000026259170600000262596PA5888842025-03-11False
17060000026267L17/dossiers1717060000026259170600000262597PA8417012025-03-11False
17060000026268L17/dossiers1717060000026259170600000262598PA8409972025-03-11False
17060000026269L17/dossiers1717060000026259170600000262599PA8415072025-03-11False
17060000026270L17/dossiers17170600000262591706000002625910PA7212102025-03-11False
17060000026271L17/dossiers17170600000262591706000002625911PA7934522025-03-11False
17060000026272L17/dossiers17170600000262591706000002625912PA8413512025-03-11False
17060000026273L17/dossiers17170600000262591706000002625913PA7950102025-03-11False
17060000026274L17/dossiers17170600000262591706000002625914PA8409472025-03-11False
17060000026275L17/dossiers17170600000262591706000002625915PA8412232025-03-11False
17060000026276L17/dossiers17170600000262591706000002625916PA7956362025-03-11False
17060000026277L17/dossiers17170600000262591706000002625917PA8420452025-03-11False
17060000026278L17/dossiers17170600000262591706000002625918PA7937082025-03-11False
17060000026279L17/dossiers17170600000262591706000002625919PA7941542025-03-11False
17060000026280L17/dossiers17170600000262591706000002625920PA7947782025-03-11False
17060000026281L17/dossiers17170600000262591706000002625921PA6065452025-03-11False
17060000026282L17/dossiers17170600000262591706000002625922PA7950762025-03-11False
17060000026283L17/dossiers17170600000262591706000002625923PA6100022025-03-11False
17060000026284L17/dossiers17170600000262591706000002625924PA7960182025-03-11False
17060000026285L17/dossiers17170600000262591706000002625925PA7362012025-03-11False
17060000026286L17/dossiers17170600000262591706000002625926PA8417132025-03-11False
17060000026287L17/dossiers17170600000262591706000002625927PA29402025-03-11False
17060000026288L17/dossiers17170600000262591706000002625928PA7952402025-03-11False
17060000026289L17/dossiers17170600000262591706000002625929PA6093322025-03-11False
17060000026290L17/dossiers17170600000262591706000002625930PA8416652025-03-11False
17060000026291L17/dossiers17170600000262591706000002625931PA8418532025-03-11False
17060000026292L17/dossiers17170600000262591706000002625932PA8407652025-03-11False
17060000026293L17/dossiers17170600000262591706000002625933PA7212342025-03-11False
17060000026294L17/dossiers17170600000262591706000002625934PA7937562025-03-11False
17060000026295L17/dossiers17170600000262591706000002625935PA6081722025-03-11False