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
17060000016079L17/dossiers17170600000160251706000001602553PA8409672025-03-07False
17060000016080L17/dossiers17170600000160251706000001602554PA7939042025-03-07False
17060000016081L17/dossiers17170600000160251706000001602555PA7959742025-03-07False
17060000016082L17/dossiers17170600000160251706000001602556PA7945902025-03-07False
17060000016083L17/dossiers17170600000160251706000001602557PA8411832025-03-07False
17060000016084L17/dossiers17170600000160251706000001602558PA8415632025-03-07False
17060000016085L17/dossiers17170600000160251706000001602559PA8408372025-03-07False
17060000016086L17/dossiers17170600000160251706000001602560PA8418252025-03-07False
17060000016087L17/dossiers17170600000160251706000001602561PA7947702025-03-07False
17060000016088L17/dossiers17170600000160251706000001602562PA7933142025-03-07False
17060000016089L17/dossiers17170600000160251706000001602563PA7936162025-03-07False
17060000016090L17/dossiers17170600000160251706000001602564PA7194362025-03-07False
17060000016091L17/dossiers17170600000160251706000001602565PA7933542025-03-07False
17060000016092L17/dossiers17170600000160251706000001602566PA7957862025-03-07False
17060000016093L17/dossiers17170600000160251706000001602567PA7943222025-03-07False
17060000016094L17/dossiers17170600000160251706000001602568PA7938522025-03-07False
17060000016095L17/dossiers17170600000160251706000001602569PA8409152025-03-07False
17060000016096L17/dossiers17170600000160251706000001602570PA7936962025-03-07False
17060000016097L17/dossiers17170600000160251706000001602571PA7955522025-03-07False
17060000016098L17/dossiers17170600000160251706000001602572PA7946702025-03-07False
17060000016099L17/dossiers17170600000160251706000001602573PA8411992025-03-07False
17060000016100L17/dossiers17170600000160251706000001602574PA7945822025-03-07False
17060000016101L17/dossiers17170600000160251706000001602575PA7932302025-03-07False
17060000016102L17/dossiers17170600000160251706000001602576PA8419552025-03-07False
17060000016103L17/dossiers17170600000160251706000001602577PA8419812025-03-07False
17060000016104L17/dossiers17170600000160251706000001602578PA8422272025-03-07False
17060000016105L17/dossiers17170600000160251706000001602579PA7944422025-03-07False
17060000016106L17/dossiers17170600000160251706000001602580PA8420972025-03-07False
17060000016107L17/dossiers17170600000160251706000001602581PA7948942025-03-07False
17060000016108L17/dossiers17170600000160251706000001602582PA7945702025-03-07False
17060000016109L17/dossiers17170600000160251706000001602583PA7949542025-03-07False
17060000016110L17/dossiers17170600000160251706000001602584PA7960502025-03-07False
17060000016111L17/dossiers17170600000160251706000001602585PA8417772024-10-292025-03-07False
17060000016112L17/dossiers17170600000160251706000001602586PA8422552025-03-07False
17060000016113L17/dossiers17170600000160251706000001602587PA7933822025-03-07False
17060000016114L17/dossiers17170600000160251706000001602588PA7945022025-03-07False
17060000016115L17/dossiers17170600000160251706000001602589PA7932982025-03-07False
17060000016116L17/dossiers17170600000160251706000001602590PA7949462025-03-07False
17060000016117L17/dossiers17170600000160251706000001602591PA8414792025-03-07False
17060000016121L17/dossiers1717060000016119170600000161191PA7947022025-03-31False
17060000016125L17/dossiers1717060000016123170600000161231PA7931582024-10-29False
17060000016126L17/dossiers1717060000016123170600000161232PA3096432024-10-29False
17060000016127L17/dossiers1717060000016123170600000161233PA7931342024-10-29False
17060000016128L17/dossiers1717060000016123170600000161234PA8407212024-10-29False
17060000016129L17/dossiers1717060000016123170600000161235PA7204682024-10-29False
17060000016130L17/dossiers1717060000016123170600000161236PA3302402024-10-29False
17060000016131L17/dossiers1717060000016123170600000161237PA8401592024-10-29False
17060000016132L17/dossiers1717060000016123170600000161238PA7933222024-10-29False
17060000016133L17/dossiers1717060000016123170600000161239PA7931662024-10-29False
17060000016134L17/dossiers17170600000161231706000001612310PA7931462024-10-29False