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
17060000019837L17/dossiers17170600000198251706000001982511PA7950842025-05-14False
17060000019838L17/dossiers17170600000198251706000001982512PA8421052025-05-14False
17060000019839L17/dossiers17170600000198251706000001982513PA8416572025-05-14False
17060000019840L17/dossiers17170600000198251706000001982514PA7204302025-05-14False
17060000019841L17/dossiers17170600000198251706000001982515PA7937722025-05-14False
17060000019842L17/dossiers17170600000198251706000001982516PA7956162025-05-14False
17060000019843L17/dossiers17170600000198251706000001982517PA7934442025-05-14False
17060000019844L17/dossiers17170600000198251706000001982518PA7949382025-05-14False
17060000019845L17/dossiers17170600000198251706000001982519PA7953182025-05-14False
17060000019846L17/dossiers17170600000198251706000001982520PA8410232025-05-14False
17060000019847L17/dossiers17170600000198251706000001982521PA7960902025-05-14False
17060000019848L17/dossiers17170600000198251706000001982522PA7939122025-05-14False
17060000019849L17/dossiers17170600000198251706000001982523PA8421872025-05-14False
17060000019850L17/dossiers17170600000198251706000001982524PA8420372025-05-14False
17060000019851L17/dossiers17170600000198251706000001982525PA7918122025-05-14False
17060000019852L17/dossiers17170600000198251706000001982526PA7937362025-05-14False
17060000019853L17/dossiers17170600000198251706000001982527PA7212022025-05-14False
17060000019854L17/dossiers17170600000198251706000001982528PA7951362025-05-14False
17060000019855L17/dossiers17170600000198251706000001982529PA7934642025-05-14False
17060000019856L17/dossiers17170600000198251706000001982530PA7952002025-05-14False
17060000019857L17/dossiers17170600000198251706000001982531PA7958442025-05-14False
17060000019858L17/dossiers17170600000198251706000001982532PA8412512025-05-14False
17060000019859L17/dossiers17170600000198251706000001982533PA7947862025-05-14False
17060000019860L17/dossiers17170600000198251706000001982534PA7948702025-05-14False
17060000019861L17/dossiers17170600000198251706000001982535PA7960702025-05-14False
17060000019862L17/dossiers17170600000198251706000001982536PA7953102025-05-14False
17060000019863L17/dossiers17170600000198251706000001982537PA7944782025-05-14False
17060000019864L17/dossiers17170600000198251706000001982538PA8419472025-05-14False
17060000019865L17/dossiers17170600000198251706000001982539PA7940822025-05-14False
17060000019866L17/dossiers17170600000198251706000001982540PA7208462025-05-14False
17060000019867L17/dossiers17170600000198251706000001982541PA8417292025-05-14False
17060000019868L17/dossiers17170600000198251706000001982542PA7955162025-05-14False
17060000019869L17/dossiers17170600000198251706000001982543PA7956722025-05-14False
17060000019870L17/dossiers17170600000198251706000001982544PA7957462025-05-14False
17060000019871L17/dossiers17170600000198251706000001982545PA7951082025-05-14False
17060000019872L17/dossiers17170600000198251706000001982546PA8415152025-05-14False
17060000019873L17/dossiers17170600000198251706000001982547PA7952982025-05-14False
17060000019874L17/dossiers17170600000198251706000001982548PA7918242025-05-14False
17060000019875L17/dossiers17170600000198251706000001982549PA8420292025-05-14False
17060000019876L17/dossiers17170600000198251706000001982550PA7935322025-05-14False
17060000019877L17/dossiers17170600000198251706000001982551PA3423842025-05-14False
17060000019878L17/dossiers17170600000198251706000001982552PA7954222025-05-14False
17060000019879L17/dossiers17170600000198251706000001982553PA7946862025-05-14False
17060000019880L17/dossiers17170600000198251706000001982554PA8412152025-05-14False
17060000019881L17/dossiers17170600000198251706000001982555PA7954822025-05-14False
17060000019882L17/dossiers17170600000198251706000001982556PA6106542025-05-14False
17060000019883L17/dossiers17170600000198251706000001982557PA8411912025-05-14False
17060000019884L17/dossiers17170600000198251706000001982558PA7938722025-05-14False
17060000019885L17/dossiers17170600000198251706000001982559PA8172112025-05-14False
17060000019886L17/dossiers17170600000198251706000001982560PA7937562025-05-14False