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
17060000043056L17/dossiers17170600000430401706000004304015PA7949382025-07-11False
17060000043057L17/dossiers17170600000430401706000004304016PA7953182025-07-11False
17060000043058L17/dossiers17170600000430401706000004304017PA8410232025-07-11False
17060000043059L17/dossiers17170600000430401706000004304018PA7960902025-07-11False
17060000043060L17/dossiers17170600000430401706000004304019PA7939122025-07-11False
17060000043061L17/dossiers17170600000430401706000004304020PA8421872025-07-11False
17060000043062L17/dossiers17170600000430401706000004304021PA8420372025-07-11False
17060000043063L17/dossiers17170600000430401706000004304022PA7918122025-07-11False
17060000043064L17/dossiers17170600000430401706000004304023PA7937362025-07-11False
17060000043065L17/dossiers17170600000430401706000004304024PA7212022025-07-11False
17060000043066L17/dossiers17170600000430401706000004304025PA7951362025-07-11False
17060000043067L17/dossiers17170600000430401706000004304026PA7934642025-07-11False
17060000043068L17/dossiers17170600000430401706000004304027PA8421552025-07-11False
17060000043069L17/dossiers17170600000430401706000004304028PA7952002025-07-11False
17060000043070L17/dossiers17170600000430401706000004304029PA7958442025-07-11False
17060000043071L17/dossiers17170600000430401706000004304030PA8412512025-07-11False
17060000043072L17/dossiers17170600000430401706000004304031PA7947862025-07-11False
17060000043073L17/dossiers17170600000430401706000004304032PA7948702025-07-11False
17060000043074L17/dossiers17170600000430401706000004304033PA7960702025-07-11False
17060000043075L17/dossiers17170600000430401706000004304034PA7953102025-07-11False
17060000043076L17/dossiers17170600000430401706000004304035PA7944782025-07-11False
17060000043077L17/dossiers17170600000430401706000004304036PA8419472025-07-11False
17060000043078L17/dossiers17170600000430401706000004304037PA7940822025-07-11False
17060000043079L17/dossiers17170600000430401706000004304038PA7941302025-07-11False
17060000043080L17/dossiers17170600000430401706000004304039PA7208462025-07-11False
17060000043081L17/dossiers17170600000430401706000004304040PA8417292025-07-11False
17060000043082L17/dossiers17170600000430401706000004304041PA7955162025-07-11False
17060000043083L17/dossiers17170600000430401706000004304042PA7956722025-07-11False
17060000043084L17/dossiers17170600000430401706000004304043PA7957462025-07-11False
17060000043085L17/dossiers17170600000430401706000004304044PA7951082025-07-11False
17060000043086L17/dossiers17170600000430401706000004304045PA8415152025-07-11False
17060000043087L17/dossiers17170600000430401706000004304046PA7952982025-07-11False
17060000043088L17/dossiers17170600000430401706000004304047PA7918242025-07-11False
17060000043089L17/dossiers17170600000430401706000004304048PA8420292025-07-11False
17060000043090L17/dossiers17170600000430401706000004304049PA7935322025-07-11False
17060000043091L17/dossiers17170600000430401706000004304050PA3423842025-07-11False
17060000043092L17/dossiers17170600000430401706000004304051PA7954222025-07-11False
17060000043093L17/dossiers17170600000430401706000004304052PA7946862025-07-11False
17060000043094L17/dossiers17170600000430401706000004304053PA7954822025-07-11False
17060000043095L17/dossiers17170600000430401706000004304054PA6106542025-07-11False
17060000043096L17/dossiers17170600000430401706000004304055PA8411912025-07-11False
17060000043097L17/dossiers17170600000430401706000004304056PA7219602025-07-11False
17060000043098L17/dossiers17170600000430401706000004304057PA7938722025-07-11False
17060000043099L17/dossiers17170600000430401706000004304058PA8172112025-07-11False
17060000043100L17/dossiers17170600000430401706000004304059PA7937562025-07-11False
17060000043101L17/dossiers17170600000430401706000004304060PA7960622025-07-11False
17060000043102L17/dossiers17170600000430401706000004304061PA7195782025-07-11False
17060000043103L17/dossiers17170600000430401706000004304062PA7210622025-07-11False
17060000043104L17/dossiers17170600000430401706000004304063PA7959822025-07-11False
17060000043105L17/dossiers17170600000430401706000004304064PA7954662025-07-11False