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
17060000029317L17/dossiers1717060000029310170600000293106PA8419312025-12-18False
17060000029318L17/dossiers1717060000029310170600000293107PA7188502025-12-18False
17060000029319L17/dossiers1717060000029310170600000293108PA7199682025-12-18False
17060000029320L17/dossiers1717060000029310170600000293109PA7214422025-12-18False
17060000029321L17/dossiers17170600000293101706000002931010PA6427252025-12-18False
17060000029322L17/dossiers17170600000293101706000002931011PA16302025-12-18False
17060000029323L17/dossiers17170600000293101706000002931012PA7218162025-12-18False
17060000029324L17/dossiers17170600000293101706000002931013PA7203862025-12-18False
17060000029325L17/dossiers17170600000293101706000002931014PA8414312025-12-18False
17060000029326L17/dossiers17170600000293101706000002931015PA6060982025-12-18False
17060000029327L17/dossiers17170600000293101706000002931016PA8413592025-12-18False
17060000029328L17/dossiers17170600000293101706000002931017PA7203542025-12-18False
17060000029329L17/dossiers17170600000293101706000002931018PA7956642025-12-18False
17060000029330L17/dossiers17170600000293101706000002931019PA7935082025-12-18False
17060000029331L17/dossiers17170600000293101706000002931020PA7940422025-12-18False
17060000029332L17/dossiers17170600000293101706000002931021PA9422025-12-18False
17060000029333L17/dossiers17170600000293101706000002931022PA8402352025-12-18False
17060000029334L17/dossiers17170600000293101706000002931023PA2673182025-12-18False
17060000029335L17/dossiers17170600000293101706000002931024PA8421172025-12-18False
17060000029336L17/dossiers17170600000293101706000002931025PA7221342025-12-18False
17060000029337L17/dossiers17170600000293101706000002931026PA7945542025-12-18False
17060000029338L17/dossiers17170600000293101706000002931027PA7205602025-12-18False
17060000029339L17/dossiers17170600000293101706000002931028PA7949942025-12-18False
17060000029340L17/dossiers17170600000293101706000002931029PA8408172025-12-18False
17060000029341L17/dossiers17170600000293101706000002931030PA8410472025-12-18False
17060000029342L17/dossiers17170600000293101706000002931031PA7188382025-12-18False
17060000029343L17/dossiers17170600000293101706000002931032PA7944862025-12-18False
17060000029344L17/dossiers17170600000293101706000002931033PA7212342025-12-18False
17060000029345L17/dossiers17170600000293101706000002931034PA7200382025-12-18False
17060000029346L17/dossiers17170600000293101706000002931035PA7221022025-12-18False
17060000029347L17/dossiers17170600000293101706000002931036PA7950262025-12-18False
17060000029348L17/dossiers17170600000293101706000002931037PA7931222025-12-18False
17060000029349L17/dossiers17170600000293101706000002931038PA7188842025-12-18False
17060000029350L17/dossiers17170600000293101706000002931039PA7933982025-12-18False
17060000029351L17/dossiers17170600000293101706000002931040PA4085782025-12-18False
17060000029352L17/dossiers17170600000293101706000002931041PA2667972025-12-18False
17060000029353L17/dossiers17170600000293101706000002931042PA7948302025-12-18False
17060000029354L17/dossiers17170600000293101706000002931043PA7949822025-12-18False
17060000029355L17/dossiers17170600000293101706000002931044PA8700102025-12-18False
17060000029356L17/dossiers17170600000293101706000002931045PA6429352025-12-18False
17060000029357L17/dossiers17170600000293101706000002931046PA7211702025-12-18False
17060000029358L17/dossiers17170600000293101706000002931047PA7953302025-12-18False
17060000029359L17/dossiers17170600000293101706000002931048PA6082642025-12-18False
17060000029360L17/dossiers17170600000293101706000002931049PA7946582025-12-18False
17060000029361L17/dossiers17170600000293101706000002931050PA7941182025-12-18False
17060000029362L17/dossiers17170600000293101706000002931051PA7120152025-12-18False
17060000029363L17/dossiers17170600000293101706000002931052PA3309092025-12-18False
17060000029364L17/dossiers17170600000293101706000002931053PA8418132025-12-18False
17060000029365L17/dossiers17170600000293101706000002931054PA7187842025-12-18False
17060000029366L17/dossiers17170600000293101706000002931055PA7955282025-12-18False