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
17060000021978L17/dossiers1717060000021970170600000219707PA3322282025-05-26False
17060000021979L17/dossiers1717060000021970170600000219708PA7944342025-05-26False
17060000021980L17/dossiers1717060000021970170600000219709PA3096432025-05-26False
17060000021981L17/dossiers17170600000219701706000002197010PA8408892025-05-26False
17060000021982L17/dossiers17170600000219701706000002197011PA7199682025-05-26False
17060000021983L17/dossiers17170600000219701706000002197012PA7218162025-05-26False
17060000021984L17/dossiers17170600000219701706000002197013PA3422402025-05-26False
17060000021985L17/dossiers17170600000219701706000002197014PA7935082025-05-26False
17060000021986L17/dossiers17170600000219701706000002197015PA8410232025-04-252025-04-25False
17060000021987L17/dossiers17170600000219701706000002197016PA8408172025-05-26False
17060000021988L17/dossiers17170600000219701706000002197017PA7188382025-05-26False
17060000021989L17/dossiers17170600000219701706000002197018PA7931342025-05-26False
17060000021990L17/dossiers17170600000219701706000002197019PA7191382025-05-26False
17060000021991L17/dossiers17170600000219701706000002197020PA8400752025-05-26False
17060000021992L17/dossiers17170600000219701706000002197021PA8423112025-05-26False
17060000021993L17/dossiers17170600000219701706000002197022PA8414312025-05-26False
17060000021994L17/dossiers17170600000219701706000002197023PA7223902025-05-26False
17060000021995L17/dossiers17170600000219701706000002197024PA8413672025-04-072025-04-07False
17060000021996L17/dossiers17170600000219701706000002197025PA8412952025-05-26False
17060000021997L17/dossiers17170600000219701706000002197026PA9422025-05-26False
17060000021998L17/dossiers17170600000219701706000002197027PA7931222025-05-26False
17060000021999L17/dossiers17170600000219701706000002197028PA7937162025-05-062025-05-26False
17060000022000L17/dossiers17170600000219701706000002197029PA7948702025-04-252025-04-25False
17060000022001L17/dossiers17170600000219701706000002197030PA3309092025-05-26False
17060000022002L17/dossiers17170600000219701706000002197031PA7940422025-05-26False
17060000022003L17/dossiers17170600000219701706000002197032PA7939282025-05-26False
17060000022004L17/dossiers17170600000219701706000002197033PA7120152025-05-26False
17060000022005L17/dossiers17170600000219701706000002197034PA7946582025-05-26False
17060000022006L17/dossiers17170600000219701706000002197035PA2670422025-05-26False
17060000022007L17/dossiers17170600000219701706000002197036PA7940822025-04-252025-04-25False
17060000022008L17/dossiers17170600000219701706000002197037PA2677802025-05-26False
17060000022009L17/dossiers17170600000219701706000002197038PA7946782025-05-26False
17060000022010L17/dossiers17170600000219701706000002197039PA8402352025-05-26False
17060000022011L17/dossiers17170600000219701706000002197040PA8414192025-05-26False
17060000022012L17/dossiers17170600000219701706000002197041PA2667972025-05-26False
17060000022013L17/dossiers17170600000219701706000002197042PA7940582025-05-26False
17060000022014L17/dossiers17170600000219701706000002197043PA16302025-05-26False
17060000022015L17/dossiers17170600000219701706000002197044PA7955162025-04-252025-04-25False
17060000022016L17/dossiers17170600000219701706000002197045PA7945982025-05-26False
17060000022017L17/dossiers17170600000219701706000002197046PA7203542025-05-26False
17060000022018L17/dossiers17170600000219701706000002197047PA7918242025-04-252025-04-25False
17060000022019L17/dossiers17170600000219701706000002197048PA7935322025-04-252025-04-25False
17060000022020L17/dossiers17170600000219701706000002197049PA8421172025-05-26False
17060000022021L17/dossiers17170600000219701706000002197050PA7200382025-05-26False
17060000022022L17/dossiers17170600000219701706000002197051PA3467822025-05-26False
17060000022023L17/dossiers17170600000219701706000002197052PA7192822025-05-26False
17060000022024L17/dossiers17170600000219701706000002197053PA8409792025-05-26False
17060000022025L17/dossiers17170600000219701706000002197054PA6427252025-05-26False
17060000022026L17/dossiers17170600000219701706000002197055PA7959742025-05-26False
17060000022027L17/dossiers17170600000219701706000002197056PA7954222025-04-252025-04-25False