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 151 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
17060000016403L17/dossiers1717060000016399170600000163993PA8406652024-10-29False
17060000016404L17/dossiers1717060000016399170600000163994PA6427642024-10-29False
17060000016405L17/dossiers1717060000016399170600000163995PA6431432024-10-29False
17060000016406L17/dossiers1717060000016399170600000163996PA8408292024-10-29False
17060000016407L17/dossiers1717060000016399170600000163997PA3424152024-10-29False
17060000016408L17/dossiers1717060000016399170600000163998PA6067932024-10-29False
17060000016409L17/dossiers1717060000016399170600000163999PA8422112024-10-29False
17060000016410L17/dossiers17170600000163991706000001639910PA8413152024-10-29False
17060000016411L17/dossiers17170600000163991706000001639911PA7940942024-10-29False
17060000016412L17/dossiers17170600000163991706000001639912PA7936242024-10-29False
17060000016413L17/dossiers17170600000163991706000001639913PA7957622024-10-29False
17060000016414L17/dossiers17170600000163991706000001639914PA6082642024-10-29False
17060000016415L17/dossiers17170600000163991706000001639915PA8409032024-10-29False
17060000016416L17/dossiers17170600000163991706000001639916PA8412952024-10-29False
17060000016417L17/dossiers17170600000163991706000001639917PA10082024-10-29False
17060000016418L17/dossiers17170600000163991706000001639918PA7933942024-10-29False
17060000016419L17/dossiers17170600000163991706000001639919PA7954302024-10-29False
17060000016420L17/dossiers17170600000163991706000001639920PA8419192024-10-29False
17060000016421L17/dossiers17170600000163991706000001639921PA6065732024-10-29False
17060000016422L17/dossiers17170600000163991706000001639922PA8416332024-10-29False
17060000016423L17/dossiers17170600000163991706000001639923PA7948542024-10-29False
17060000016424L17/dossiers17170600000163991706000001639924PA8421952024-10-29False
17060000016425L17/dossiers17170600000163991706000001639925PA6093322024-10-29False
17060000016426L17/dossiers17170600000163991706000001639926PA8416652024-10-29False
17060000016427L17/dossiers17170600000163991706000001639927PA3332852024-10-29False
17060000016428L17/dossiers17170600000163991706000001639928PA8409392024-10-29False
17060000016429L17/dossiers17170600000163991706000001639929PA8415392024-10-29False
17060000016430L17/dossiers17170600000163991706000001639930PA3319732024-10-29False
17060000016431L17/dossiers17170600000163991706000001639931PA8401712024-10-29False
17060000016432L17/dossiers17170600000163991706000001639932PA15672024-10-29False
17060000016433L17/dossiers17170600000163991706000001639933PA8414712024-10-29False
17060000016434L17/dossiers17170600000163991706000001639934PA8422632024-10-29False
17060000016435L17/dossiers17170600000163991706000001639935PA8418532024-10-29False
17060000016436L17/dossiers17170600000163991706000001639936PA16542024-10-29False
17060000016437L17/dossiers17170600000163991706000001639937PA6431922024-10-29False
17060000016438L17/dossiers17170600000163991706000001639938PA3350542024-10-29False
17060000016439L17/dossiers17170600000163991706000001639939PA7951562024-10-29False
17060000016440L17/dossiers17170600000163991706000001639940PA8407652024-10-29False
17060000016441L17/dossiers17170600000163991706000001639941PA8414632024-10-29False
17060000016442L17/dossiers17170600000163991706000001639942PA6431572024-10-29False
17060000016443L17/dossiers17170600000163991706000001639943PA8411072024-10-29False
17060000016444L17/dossiers17170600000163991706000001639944PA8413812024-10-29False
17060000016445L17/dossiers17170600000163991706000001639945PA8407932024-10-29False
17060000016446L17/dossiers17170600000163991706000001639946PA7942702024-10-29False
17060000016447L17/dossiers17170600000163991706000001639947PA6081722024-10-29False
17060000016448L17/dossiers17170600000163991706000001639948PA6075532024-10-29False
17060000016449L17/dossiers17170600000163991706000001639949PA8409552024-10-29False
17060000016450L17/dossiers17170600000163991706000001639950PA8413672024-10-29False
17060000016451L17/dossiers17170600000163991706000001639951PA3419812024-10-29False
17060000016452L17/dossiers17170600000163991706000001639952PA8406732024-10-29False