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
17060000031163L17/dossiers171706000003105317060000031053109PA3356122025-03-21False
17060000031164L17/dossiers171706000003105317060000031053110PA7952582025-03-21False
17060000031165L17/dossiers171706000003105317060000031053111PA7958082025-03-21False
17060000031166L17/dossiers171706000003105317060000031053112PA7955162025-03-21False
17060000031167L17/dossiers171706000003105317060000031053113PA7961062025-03-21False
17060000031168L17/dossiers171706000003105317060000031053114PA7946862025-03-21False
17060000031169L17/dossiers171706000003105317060000031053115PA7931742025-03-21False
17060000031170L17/dossiers171706000003105317060000031053116PA7941062025-03-21False
17060000031171L17/dossiers171706000003105317060000031053117PA7960102025-03-21False
17060000031172L17/dossiers171706000003105317060000031053118PA7941302025-03-21False
17060000031173L17/dossiers171706000003105317060000031053119PA7951082025-03-21False
17060000031174L17/dossiers171706000003105317060000031053120PA7937362025-03-21False
17060000031175L17/dossiers171706000003105317060000031053121PA7935322025-03-21False
17060000031176L17/dossiers171706000003105317060000031053122PA7944782025-03-21False
17060000031177L17/dossiers171706000003105317060000031053123PA7951362025-03-21False
17060000031178L17/dossiers171706000003105317060000031053124PA7954662025-03-21False
17060000031179L17/dossiers171706000003105317060000031053125PA8411912025-03-21False
17060000031180L17/dossiers171706000003105317060000031053126PA7949062025-03-21False
17060000031181L17/dossiers171706000003105317060000031053127PA7949382025-03-21False
17060000031182L17/dossiers171706000003105317060000031053128PA8416572025-03-21False
17060000031183L17/dossiers171706000003105317060000031053129PA7941662025-03-21False
17060000031184L17/dossiers171706000003105317060000031053130PA7955962025-03-21False
17060000031185L17/dossiers171706000003105317060000031053131PA8417292025-03-21False
17060000031186L17/dossiers171706000003105317060000031053132PA7937722025-03-21False
17060000031187L17/dossiers171706000003105317060000031053133PA7947862025-03-21False
17060000031188L17/dossiers171706000003105317060000031053134PA7954222025-03-21False
17060000031189L17/dossiers171706000003105317060000031053135PA7955882025-03-21False
17060000031190L17/dossiers171706000003105317060000031053136PA2667972025-03-21False
17060000031191L17/dossiers171706000003105317060000031053137PA7959202025-03-21False
17060000031192L17/dossiers171706000003105317060000031053138PA7572252025-03-21False
17060000031193L17/dossiers171706000003105317060000031053139PA7950102025-03-21False
17060000031197L17/dossiers1717060000031195170600000311951PA7952002026-01-05False
17060000031198L17/dossiers1717060000031195170600000311952PA7937082026-01-05False
17060000031199L17/dossiers1717060000031195170600000311953PA7952282026-01-05False
17060000031200L17/dossiers1717060000031195170600000311954PA7932622026-01-05False
17060000031201L17/dossiers1717060000031195170600000311955PA7949062026-01-05False
17060000031202L17/dossiers1717060000031195170600000311956PA7941382026-01-05False
17060000031203L17/dossiers1717060000031195170600000311957PA7955882026-01-05False
17060000031204L17/dossiers1717060000031195170600000311958PA7950842026-01-05False
17060000031205L17/dossiers1717060000031195170600000311959PA8421052026-01-05False
17060000031206L17/dossiers17170600000311951706000003119510PA5888842026-01-05False
17060000031207L17/dossiers17170600000311951706000003119511PA7195582026-01-05False
17060000031208L17/dossiers17170600000311951706000003119512PA6431432026-01-05False
17060000031209L17/dossiers17170600000311951706000003119513PA8408292026-01-05False
17060000031210L17/dossiers17170600000311951706000003119514PA2677632026-01-05False
17060000031211L17/dossiers17170600000311951706000003119515PA7204302026-01-05False
17060000031212L17/dossiers17170600000311951706000003119516PA7192182026-01-05False
17060000031213L17/dossiers17170600000311951706000003119517PA7937722026-01-05False
17060000031214L17/dossiers17170600000311951706000003119518PA7956162026-01-05False
17060000031215L17/dossiers17170600000311951706000003119519PA8409972026-01-05False