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
17060000019575L17/dossiers1717060000019571170600000195713PA7188502024-12-03False
17060000019576L17/dossiers1717060000019571170600000195714PA7941782024-12-03False
17060000019577L17/dossiers1717060000019571170600000195715PA7188382024-12-03False
17060000019578L17/dossiers1717060000019571170600000195716PA7120152024-12-03False
17060000019579L17/dossiers1717060000019571170600000195717PA7188842024-12-03False
17060000019580L17/dossiers1717060000019571170600000195718PA7940582024-12-03False
17060000019581L17/dossiers1717060000019571170600000195719PA7933422024-12-03False
17060000019582L17/dossiers17170600000195711706000001957110PA7187842024-12-03False
17060000019583L17/dossiers17170600000195711706000001957111PA7930942024-12-03False
17060000019584L17/dossiers17170600000195711706000001957112PA8417452024-12-03False
17060000019585L17/dossiers17170600000195711706000001957113PA2667932024-12-03False
17060000019586L17/dossiers17170600000195711706000001957114PA7218162024-12-03False
17060000019587L17/dossiers17170600000195711706000001957115PA3422402024-12-03False
17060000019588L17/dossiers17170600000195711706000001957116PA7214422024-12-03False
17060000019589L17/dossiers17170600000195711706000001957117PA3309092024-12-03False
17060000019590L17/dossiers17170600000195711706000001957118PA7223902024-12-03False
17060000019591L17/dossiers17170600000195711706000001957119PA7214102024-12-03False
17060000019592L17/dossiers17170600000195711706000001957120PA8421172024-12-03False
17060000019593L17/dossiers17170600000195711706000001957121PA6088262024-12-03False
17060000019594L17/dossiers17170600000195711706000001957122PA7935082024-12-03False
17060000019595L17/dossiers17170600000195711706000001957123PA7940382024-12-03False
17060000019596L17/dossiers17170600000195711706000001957124PA3300082024-12-03False
17060000019600L17/dossiers1717060000019598170600000195981PA7952282025-02-21False
17060000019601L17/dossiers1717060000019598170600000195982PA7941382025-02-21False
17060000019602L17/dossiers1717060000019598170600000195983PA7955882025-02-21False
17060000019603L17/dossiers1717060000019598170600000195984PA7950842025-02-21False
17060000019604L17/dossiers1717060000019598170600000195985PA7937802025-02-21False
17060000019605L17/dossiers1717060000019598170600000195986PA5888842025-02-21False
17060000019606L17/dossiers1717060000019598170600000195987PA7953622024-12-102024-12-10False
17060000019607L17/dossiers1717060000019598170600000195988PA8416572025-02-21False
17060000019608L17/dossiers1717060000019598170600000195989PA7204302025-02-21False
17060000019609L17/dossiers17170600000195981706000001959810PA7937722025-02-21False
17060000019610L17/dossiers17170600000195981706000001959811PA7956162025-02-21False
17060000019611L17/dossiers17170600000195981706000001959812PA7934442025-02-21False
17060000019612L17/dossiers17170600000195981706000001959813PA7949382025-02-21False
17060000019613L17/dossiers17170600000195981706000001959814PA7953182025-02-21False
17060000019614L17/dossiers17170600000195981706000001959815PA7960902025-02-21False
17060000019615L17/dossiers17170600000195981706000001959816PA7918122025-02-21False
17060000019616L17/dossiers17170600000195981706000001959817PA7937362025-02-21False
17060000019617L17/dossiers17170600000195981706000001959818PA7212022025-02-21False
17060000019618L17/dossiers17170600000195981706000001959819PA7212102025-02-21False
17060000019619L17/dossiers17170600000195981706000001959820PA7934522025-02-21False
17060000019620L17/dossiers17170600000195981706000001959821PA7951362025-01-062025-02-21False
17060000019621L17/dossiers17170600000195981706000001959822PA7934642025-02-21False
17060000019622L17/dossiers17170600000195981706000001959823PA7952002025-02-21False
17060000019623L17/dossiers17170600000195981706000001959824PA7958442025-02-21False
17060000019624L17/dossiers17170600000195981706000001959825PA7947862025-02-21False
17060000019625L17/dossiers17170600000195981706000001959826PA7939802025-02-21False
17060000019626L17/dossiers17170600000195981706000001959827PA7960702025-02-21False
17060000019627L17/dossiers17170600000195981706000001959828PA7950102025-02-21False