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
17060000004829L17/dossiers171706000000468717060000004687141PA7222842023-07-21False
17060000004830L17/dossiers171706000000468717060000004687142PA7932702023-07-21False
17060000004831L17/dossiers171706000000468717060000004687143PA6066392023-07-21False
17060000004832L17/dossiers171706000000468717060000004687144PA7218802023-07-21False
17060000004833L17/dossiers171706000000468717060000004687145PA7944862023-07-21False
17060000004834L17/dossiers171706000000468717060000004687146PA7192662023-07-21False
17060000004835L17/dossiers171706000000468717060000004687147PA7218282023-07-21False
17060000004836L17/dossiers171706000000468717060000004687148PA7193382023-07-21False
17060000004837L17/dossiers171706000000468717060000004687149PA3406432023-07-21False
17060000004838L17/dossiers171706000000468717060000004687150PA7223982023-07-21False
17060000004839L17/dossiers171706000000468717060000004687151PA7194722023-07-31False
17060000004840L17/dossiers171706000000468717060000004687152PA7955962023-07-31False
17060000004841L17/dossiers171706000000468717060000004687153PA7217602023-07-31False
17060000004842L17/dossiers171706000000468717060000004687154PA7205522023-10-04False
17060000004843L17/dossiers171706000000468717060000004687155PA3421962023-10-04False
17060000004860L17/dossiers1717060000004858170600000048581PA7937802023-02-21False
17060000004861L17/dossiers1717060000004858170600000048582PA3359992023-02-21False
17060000004862L17/dossiers1717060000004858170600000048583PA7950582023-02-21False
17060000004863L17/dossiers1717060000004858170600000048584PA7953622023-02-21False
17060000004864L17/dossiers1717060000004858170600000048585PA7940082023-02-21False
17060000004865L17/dossiers1717060000004858170600000048586PA7939802023-02-21False
17060000004866L17/dossiers1717060000004858170600000048587PA7950102023-02-21False
17060000004867L17/dossiers1717060000004858170600000048588PA7940222023-02-21False
17060000004868L17/dossiers1717060000004858170600000048589PA7223442023-02-21False
17060000004869L17/dossiers17170600000048581706000000485810PA7941462023-02-21False
17060000004870L17/dossiers17170600000048581706000000485811PA7956362023-02-21False
17060000004871L17/dossiers17170600000048581706000000485812PA7957942023-02-21False
17060000004872L17/dossiers17170600000048581706000000485813PA7937082023-02-21False
17060000004873L17/dossiers17170600000048581706000000485814PA7936642023-02-21False
17060000004874L17/dossiers17170600000048581706000000485815PA7941542023-02-21False
17060000004875L17/dossiers17170600000048581706000000485816PA7947782023-02-21False
17060000004876L17/dossiers17170600000048581706000000485817PA6100022023-02-21False
17060000004877L17/dossiers17170600000048581706000000485818PA7958082023-02-21False
17060000004878L17/dossiers17170600000048581706000000485819PA7209522023-02-21False
17060000004879L17/dossiers17170600000048581706000000485820PA7362012023-02-21False
17060000004880L17/dossiers17170600000048581706000000485821PA7939482023-02-21False
17060000004905L17/dossiers1717060000004903170600000049031PA7948542023-11-13False
17060000004906L17/dossiers1717060000004903170600000049032PA7957302023-04-28False
17060000004907L17/dossiers1717060000004903170600000049033PA7193722023-04-28False
17060000004908L17/dossiers1717060000004903170600000049034PA7173792023-04-28False
17060000004909L17/dossiers1717060000004903170600000049035PA7199302023-11-13False
17060000004910L17/dossiers1717060000004903170600000049036PA6057822023-04-28False
17060000004911L17/dossiers1717060000004903170600000049037PA6050362023-04-28False
17060000004912L17/dossiers1717060000004903170600000049038PA7198662023-04-28False
17060000004913L17/dossiers1717060000004903170600000049039PA7220382023-04-28False
17060000004914L17/dossiers17170600000049031706000000490310PA6059632023-04-28False
17060000004915L17/dossiers17170600000049031706000000490311PA7959502023-04-28False
17060000004916L17/dossiers17170600000049031706000000490312PA7211582023-04-28False
17060000004917L17/dossiers17170600000049031706000000490313PA7191002023-04-28False
17060000004918L17/dossiers17170600000049031706000000490314PA7951442023-04-28False