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
17060000027888L17/dossiers17170600000278581706000002785829PA7950842025-03-04False
17060000027889L17/dossiers17170600000278581706000002785830PA8421052025-03-04False
17060000027890L17/dossiers17170600000278581706000002785831PA8416572025-03-04False
17060000027891L17/dossiers17170600000278581706000002785832PA7204302025-03-04False
17060000027892L17/dossiers17170600000278581706000002785833PA7937722025-03-04False
17060000027893L17/dossiers17170600000278581706000002785834PA7956162025-03-04False
17060000027894L17/dossiers17170600000278581706000002785835PA7934442025-03-04False
17060000027895L17/dossiers17170600000278581706000002785836PA7949382025-03-04False
17060000027896L17/dossiers17170600000278581706000002785837PA7953182025-03-04False
17060000027897L17/dossiers17170600000278581706000002785838PA8410232025-03-04False
17060000027898L17/dossiers17170600000278581706000002785839PA7960902025-03-04False
17060000027899L17/dossiers17170600000278581706000002785840PA7939122025-03-04False
17060000027900L17/dossiers17170600000278581706000002785841PA8421872025-03-04False
17060000027901L17/dossiers17170600000278581706000002785842PA8420372025-03-04False
17060000027902L17/dossiers17170600000278581706000002785843PA7918122025-03-04False
17060000027903L17/dossiers17170600000278581706000002785844PA7951362025-03-04False
17060000027904L17/dossiers17170600000278581706000002785845PA7934642025-03-04False
17060000027905L17/dossiers17170600000278581706000002785846PA8421552025-03-04False
17060000027906L17/dossiers17170600000278581706000002785847PA7958442025-03-04False
17060000027907L17/dossiers17170600000278581706000002785848PA8412512025-03-04False
17060000027908L17/dossiers17170600000278581706000002785849PA7947862025-03-04False
17060000027909L17/dossiers17170600000278581706000002785850PA7948702025-03-04False
17060000027910L17/dossiers17170600000278581706000002785851PA7960702025-03-04False
17060000027911L17/dossiers17170600000278581706000002785852PA7953102025-03-04False
17060000027912L17/dossiers17170600000278581706000002785853PA7944782025-03-04False
17060000027913L17/dossiers17170600000278581706000002785854PA8419472025-03-04False
17060000027914L17/dossiers17170600000278581706000002785855PA7940822025-03-04False
17060000027915L17/dossiers17170600000278581706000002785856PA7941302025-03-04False
17060000027916L17/dossiers17170600000278581706000002785857PA7208462025-03-04False
17060000027917L17/dossiers17170600000278581706000002785858PA8417292025-03-04False
17060000027918L17/dossiers17170600000278581706000002785859PA7955162025-03-04False
17060000027919L17/dossiers17170600000278581706000002785860PA7956722025-03-04False
17060000027920L17/dossiers17170600000278581706000002785861PA7957462025-03-04False
17060000027921L17/dossiers17170600000278581706000002785862PA7951082025-03-04False
17060000027922L17/dossiers17170600000278581706000002785863PA8415152025-03-04False
17060000027923L17/dossiers17170600000278581706000002785864PA7952982025-03-04False
17060000027924L17/dossiers17170600000278581706000002785865PA7918242025-03-04False
17060000027925L17/dossiers17170600000278581706000002785866PA8420292025-03-04False
17060000027926L17/dossiers17170600000278581706000002785867PA7935322025-03-04False
17060000027927L17/dossiers17170600000278581706000002785868PA3423842025-03-04False
17060000027928L17/dossiers17170600000278581706000002785869PA7954222025-03-04False
17060000027929L17/dossiers17170600000278581706000002785870PA7946862025-03-04False
17060000027930L17/dossiers17170600000278581706000002785871PA8412152025-03-04False
17060000027931L17/dossiers17170600000278581706000002785872PA7954822025-03-04False
17060000027932L17/dossiers17170600000278581706000002785873PA6106542025-03-04False
17060000027933L17/dossiers17170600000278581706000002785874PA8411912025-03-04False
17060000027934L17/dossiers17170600000278581706000002785875PA7219602025-03-04False
17060000027935L17/dossiers17170600000278581706000002785876PA7938722025-03-04False
17060000027936L17/dossiers17170600000278581706000002785877PA8172112025-03-04False
17060000027937L17/dossiers17170600000278581706000002785878PA7937562025-03-04False