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
17060000050079L17/dossiers1717060000050075170600000500753PA6065732025-10-28False
17060000050080L17/dossiers1717060000050075170600000500754PA8416332025-10-28False
17060000050081L17/dossiers1717060000050075170600000500755PA8417172025-10-28False
17060000050082L17/dossiers1717060000050075170600000500756PA7944942025-10-28False
17060000050083L17/dossiers1717060000050075170600000500757PA8413152025-10-28False
17060000050084L17/dossiers1717060000050075170600000500758PA7954302025-10-28False
17060000050088L17/dossiers1717060000050086170600000500861PA6427642025-11-03False
17060000050089L17/dossiers1717060000050086170600000500862PA3424152025-11-03False
17060000050090L17/dossiers1717060000050086170600000500863PA6065732025-11-03False
17060000050091L17/dossiers1717060000050086170600000500864PA7948542025-11-03False
17060000050092L17/dossiers1717060000050086170600000500865PA8416652025-11-03False
17060000050093L17/dossiers1717060000050086170600000500866PA8226172025-11-03False
17060000050094L17/dossiers1717060000050086170600000500867PA8409392025-11-03False
17060000050095L17/dossiers1717060000050086170600000500868PA8401712025-11-03False
17060000050096L17/dossiers1717060000050086170600000500869PA8422632025-11-03False
17060000050097L17/dossiers17170600000500861706000005008610PA8407652025-11-03False
17060000050098L17/dossiers17170600000500861706000005008611PA8407932025-11-03False
17060000050099L17/dossiers17170600000500861706000005008612PA6081722025-11-03False
17060000050100L17/dossiers17170600000500861706000005008613PA8406732025-11-03False
17060000050101L17/dossiers17170600000500861706000005008614PA8416812025-11-03False
17060000050111L17/dossiers1717060000050109170600000501091PA7958682025-11-25False
17060000050112L17/dossiers1717060000050109170600000501092PA7958202025-11-25False
17060000050113L17/dossiers1717060000050109170600000501093PA7952402025-11-25False
17060000050114L17/dossiers1717060000050109170600000501094PA7210622025-11-25False
17060000050115L17/dossiers1717060000050109170600000501095PA6056942025-11-25False
17060000050116L17/dossiers1717060000050109170600000501096PA7223902025-11-25False
17060000050117L17/dossiers1717060000050109170600000501097PA7951362025-11-25False
17060000050118L17/dossiers1717060000050109170600000501098PA7950102025-11-25False
17060000050119L17/dossiers1717060000050109170600000501099PA7918122025-11-25False
17060000050120L17/dossiers17170600000501091706000005010910PA7209602025-11-25False
17060000050121L17/dossiers17170600000501091706000005010911PA6081722025-11-25False
17060000050122L17/dossiers17170600000501091706000005010912PA8419312025-11-25False
17060000050123L17/dossiers17170600000501091706000005010913PA7952582025-11-25False
17060000050124L17/dossiers17170600000501091706000005010914PA7212702025-11-25False
17060000050125L17/dossiers17170600000501091706000005010915PA3356122025-11-25False
17060000050126L17/dossiers17170600000501091706000005010916PA7192182025-11-25False
17060000050127L17/dossiers17170600000501091706000005010917PA7941382025-11-25False
17060000050140L17/dossiers1717060000050138170600000501381PA6109682026-01-26False
17060000050141L17/dossiers1717060000050138170600000501382PA8417012026-01-26False
17060000050142L17/dossiers1717060000050138170600000501383PA7953622026-01-26False
17060000050143L17/dossiers1717060000050138170600000501384PA8415072026-01-26False
17060000050144L17/dossiers1717060000050138170600000501385PA7212102026-01-26False
17060000050145L17/dossiers1717060000050138170600000501386PA7939802026-01-26False
17060000050146L17/dossiers1717060000050138170600000501387PA7950102026-01-26False
17060000050147L17/dossiers1717060000050138170600000501388PA8414192026-01-26False
17060000050148L17/dossiers1717060000050138170600000501389PA8420452026-01-26False
17060000050149L17/dossiers17170600000501381706000005013810PA7937082026-01-26False
17060000050150L17/dossiers17170600000501381706000005013811PA7941542026-01-26False
17060000050151L17/dossiers17170600000501381706000005013812PA7947782026-01-26False
17060000050152L17/dossiers17170600000501381706000005013813PA6065452026-01-26False