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
17060000022302L17/dossiers17170600000222471706000002224754PA8411912024-12-19False
17060000022303L17/dossiers17170600000222471706000002224755PA7219602024-12-19False
17060000022304L17/dossiers17170600000222471706000002224756PA7938722024-12-19False
17060000022305L17/dossiers17170600000222471706000002224757PA8172112024-12-19False
17060000022306L17/dossiers17170600000222471706000002224758PA7937562024-12-19False
17060000022307L17/dossiers17170600000222471706000002224759PA7960622024-12-19False
17060000022308L17/dossiers17170600000222471706000002224760PA7195782024-12-19False
17060000022309L17/dossiers17170600000222471706000002224761PA7210622024-12-19False
17060000022310L17/dossiers17170600000222471706000002224762PA8418452024-12-19False
17060000022311L17/dossiers17170600000222471706000002224763PA7959822024-12-19False
17060000022312L17/dossiers17170600000222471706000002224764PA7937442024-12-19False
17060000022313L17/dossiers17170600000222471706000002224765PA7209522024-12-19False
17060000022314L17/dossiers17170600000222471706000002224766PA7941062024-12-19False
17060000022315L17/dossiers17170600000222471706000002224767PA7941662024-12-19False
17060000022316L17/dossiers17170600000222471706000002224768PA7951642024-12-19False
17060000022317L17/dossiers17170600000222471706000002224769PA7955962024-12-19False
17060000022324L17/dossiers1717060000022322170600000223221PA8410672025-06-23False
17060000022325L17/dossiers1717060000022322170600000223222PA2677632025-06-23False
17060000022326L17/dossiers1717060000022322170600000223223PA3322282025-06-23False
17060000022327L17/dossiers1717060000022322170600000223224PA3096432025-06-23False
17060000022328L17/dossiers1717060000022322170600000223225PA3422402025-06-23False
17060000022329L17/dossiers1717060000022322170600000223226PA8408172025-06-23False
17060000022330L17/dossiers1717060000022322170600000223227PA6082642025-06-23False
17060000022331L17/dossiers1717060000022322170600000223228PA7945542025-06-23False
17060000022332L17/dossiers1717060000022322170600000223229PA8414312025-06-23False
17060000022333L17/dossiers17170600000223221706000002232210PA7933222025-06-23False
17060000022334L17/dossiers17170600000223221706000002232211PA3309092025-06-23False
17060000022335L17/dossiers17170600000223221706000002232212PA7946582025-06-23False
17060000022336L17/dossiers17170600000223221706000002232213PA6056942025-06-23False
17060000022337L17/dossiers17170600000223221706000002232214PA15672025-06-23False
17060000022338L17/dossiers17170600000223221706000002232215PA7197562025-06-23False
17060000022339L17/dossiers17170600000223221706000002232216PA7202302025-06-23False
17060000022340L17/dossiers17170600000223221706000002232217PA7942062025-06-23False
17060000022341L17/dossiers17170600000223221706000002232218PA7933422025-06-23False
17060000022342L17/dossiers17170600000223221706000002232219PA7209762025-06-23False
17060000022343L17/dossiers17170600000223221706000002232220PA8419312025-06-23False
17060000022344L17/dossiers17170600000223221706000002232221PA7192722025-06-23False
17060000022345L17/dossiers17170600000223221706000002232222PA6076192025-06-23False
17060000022346L17/dossiers17170600000223221706000002232223PA7214862025-06-23False
17060000022347L17/dossiers17170600000223221706000002232224PA7196322025-06-23False
17060000022348L17/dossiers17170600000223221706000002232225PA8413812025-06-23False
17060000022349L17/dossiers17170600000223221706000002232226PA7214422025-06-23False
17060000022350L17/dossiers17170600000223221706000002232227PA6081722025-06-23False
17060000022351L17/dossiers17170600000223221706000002232228PA6075532025-06-23False
17060000022352L17/dossiers17170600000223221706000002232229PA7201002025-06-23False
17060000022353L17/dossiers17170600000223221706000002232230PA7200922025-06-23False
17060000022354L17/dossiers17170600000223221706000002232231PA2668082025-06-23False
17060000022355L17/dossiers17170600000223221706000002232232PA7211102025-06-23False
17060000022356L17/dossiers17170600000223221706000002232233PA7944862025-06-23False
17060000022357L17/dossiers17170600000223221706000002232234PA7953502025-06-23False