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
17060000018768L17/dossiers17170600000186711706000001867196PA7199682025-06-04False
17060000018769L17/dossiers17170600000186711706000001867197PA7749542025-02-102025-02-10False
17060000018770L17/dossiers17170600000186711706000001867198PA6065452025-06-04False
17060000018771L17/dossiers17170600000186711706000001867199PA7196322025-06-04False
17060000018778L17/dossiers1717060000018776170600000187761PA7223902024-12-04False
17060000018779L17/dossiers1717060000018776170600000187762PA7199682024-12-04False
17060000018780L17/dossiers1717060000018776170600000187763PA7188502024-12-04False
17060000018781L17/dossiers1717060000018776170600000187764PA8421172024-12-04False
17060000018782L17/dossiers1717060000018776170600000187765PA8409792024-12-04False
17060000018783L17/dossiers1717060000018776170600000187766PA6080162024-12-04False
17060000018784L17/dossiers1717060000018776170600000187767PA7930942024-12-04False
17060000018785L17/dossiers1717060000018776170600000187768PA6070902024-12-04False
17060000018786L17/dossiers1717060000018776170600000187769PA7188842024-12-04False
17060000018787L17/dossiers17170600000187761706000001877610PA7218162024-12-04False
17060000018788L17/dossiers17170600000187761706000001877611PA7188382024-12-04False
17060000018789L17/dossiers17170600000187761706000001877612PA8410472024-12-04False
17060000018790L17/dossiers17170600000187761706000001877613PA7940582024-12-04False
17060000018791L17/dossiers17170600000187761706000001877614PA7941782024-12-04False
17060000018792L17/dossiers17170600000187761706000001877615PA8417452024-12-04False
17060000018793L17/dossiers17170600000187761706000001877616PA3422402024-12-04False
17060000018794L17/dossiers17170600000187761706000001877617PA6427252024-12-04False
17060000018795L17/dossiers17170600000187761706000001877618PA7214422024-12-04False
17060000018796L17/dossiers17170600000187761706000001877619PA2667932024-12-04False
17060000018797L17/dossiers17170600000187761706000001877620PA6955122024-12-04False
17060000018798L17/dossiers17170600000187761706000001877621PA7214102024-12-04False
17060000018799L17/dossiers17170600000187761706000001877622PA3467822024-12-04False
17060000018800L17/dossiers17170600000187761706000001877623PA7187842024-12-04False
17060000018801L17/dossiers17170600000187761706000001877624PA2667972024-12-04False
17060000018802L17/dossiers17170600000187761706000001877625PA7940382024-12-04False
17060000018803L17/dossiers17170600000187761706000001877626PA3309092024-12-04False
17060000018807L17/dossiers1717060000018805170600000188051PA7208922024-12-03False
17060000018808L17/dossiers1717060000018805170600000188052PA7952282024-12-03False
17060000018809L17/dossiers1717060000018805170600000188053PA7932622024-12-03False
17060000018810L17/dossiers1717060000018805170600000188054PA7949062024-12-03False
17060000018811L17/dossiers1717060000018805170600000188055PA7941382024-12-03False
17060000018812L17/dossiers1717060000018805170600000188056PA7955882024-12-03False
17060000018813L17/dossiers1717060000018805170600000188057PA7950842024-12-03False
17060000018814L17/dossiers1717060000018805170600000188058PA8421052024-12-03False
17060000018815L17/dossiers1717060000018805170600000188059PA8416572024-12-03False
17060000018816L17/dossiers17170600000188051706000001880510PA7204302024-12-03False
17060000018817L17/dossiers17170600000188051706000001880511PA7937722024-12-03False
17060000018818L17/dossiers17170600000188051706000001880512PA7956162024-12-03False
17060000018819L17/dossiers17170600000188051706000001880513PA7934442024-12-03False
17060000018820L17/dossiers17170600000188051706000001880514PA7949382024-12-03False
17060000018821L17/dossiers17170600000188051706000001880515PA7953182024-12-03False
17060000018822L17/dossiers17170600000188051706000001880516PA8410232024-12-03False
17060000018823L17/dossiers17170600000188051706000001880517PA7960902024-12-03False
17060000018824L17/dossiers17170600000188051706000001880518PA7939122024-12-03False
17060000018825L17/dossiers17170600000188051706000001880519PA8421872024-12-03False
17060000018826L17/dossiers17170600000188051706000001880520PA8420372024-12-03False