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
17060000026618L17/dossiers17170600000265341706000002653483PA2667972025-04-02False
17060000026619L17/dossiers17170600000265341706000002653484PA7221342025-04-02False
17060000026620L17/dossiers17170600000265341706000002653485PA3424152025-04-012025-04-02False
17060000026621L17/dossiers17170600000265341706000002653486PA8422632025-04-02False
17060000026622L17/dossiers17170600000265341706000002653487PA3421962025-04-02False
17060000026623L17/dossiers17170600000265341706000002653488PA3332852025-04-02False
17060000026624L17/dossiers17170600000265341706000002653489PA7948102025-04-02False
17060000026625L17/dossiers17170600000265341706000002653490PA7209602025-04-02False
17060000026626L17/dossiers17170600000265341706000002653491PA7932102025-04-02False
17060000026627L17/dossiers17170600000265341706000002653492PA8408172025-04-02False
17060000026628L17/dossiers17170600000265341706000002653493PA2677632025-04-02False
17060000026629L17/dossiers17170600000265341706000002653494PA15922025-04-02False
17060000026630L17/dossiers17170600000265341706000002653495PA7214742025-03-112025-03-17False
17060000026631L17/dossiers17170600000265341706000002653496PA8413592025-04-02False
17060000026632L17/dossiers17170600000265341706000002653497PA7214582025-04-02False
17060000026633L17/dossiers17170600000265341706000002653498PA7221502025-03-112025-03-17False
17060000026637L17/dossiers1717060000026635170600000266351PA6109682025-02-13False
17060000026638L17/dossiers1717060000026635170600000266352PA7937802025-02-13False
17060000026639L17/dossiers1717060000026635170600000266353PA5888842025-02-13False
17060000026640L17/dossiers1717060000026635170600000266354PA8417012025-02-13False
17060000026641L17/dossiers1717060000026635170600000266355PA7953622025-02-13False
17060000026642L17/dossiers1717060000026635170600000266356PA7954542025-02-13False
17060000026643L17/dossiers1717060000026635170600000266357PA8409972025-02-13False
17060000026644L17/dossiers1717060000026635170600000266358PA8418852025-02-13False
17060000026645L17/dossiers1717060000026635170600000266359PA8415072025-02-13False
17060000026646L17/dossiers17170600000266351706000002663510PA7940082025-02-13False
17060000026647L17/dossiers17170600000266351706000002663511PA7212102025-02-13False
17060000026648L17/dossiers17170600000266351706000002663512PA7934522025-02-13False
17060000026649L17/dossiers17170600000266351706000002663513PA8413512025-02-13False
17060000026650L17/dossiers17170600000266351706000002663514PA7939802025-02-13False
17060000026651L17/dossiers17170600000266351706000002663515PA7950102025-02-13False
17060000026652L17/dossiers17170600000266351706000002663516PA8414192025-02-13False
17060000026653L17/dossiers17170600000266351706000002663517PA8420132025-02-13False
17060000026654L17/dossiers17170600000266351706000002663518PA8409472025-02-13False
17060000026655L17/dossiers17170600000266351706000002663519PA7940222025-02-13False
17060000026656L17/dossiers17170600000266351706000002663520PA7941462025-02-13False
17060000026657L17/dossiers17170600000266351706000002663521PA8412232025-02-13False
17060000026658L17/dossiers17170600000266351706000002663522PA7956362025-02-13False
17060000026659L17/dossiers17170600000266351706000002663523PA8420452025-02-13False
17060000026660L17/dossiers17170600000266351706000002663524PA7937082025-02-13False
17060000026661L17/dossiers17170600000266351706000002663525PA7936642025-02-13False
17060000026662L17/dossiers17170600000266351706000002663526PA7941542025-02-13False
17060000026663L17/dossiers17170600000266351706000002663527PA7947782025-02-13False
17060000026664L17/dossiers17170600000266351706000002663528PA6065452025-02-13False
17060000026665L17/dossiers17170600000266351706000002663529PA7950762025-02-13False
17060000026666L17/dossiers17170600000266351706000002663530PA7221422025-02-13False
17060000026667L17/dossiers17170600000266351706000002663531PA6100022025-02-13False
17060000026668L17/dossiers17170600000266351706000002663532PA7958082025-02-13False
17060000026669L17/dossiers17170600000266351706000002663533PA7960182025-02-13False
17060000026670L17/dossiers17170600000266351706000002663534PA7362012025-02-13False