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
17060000052565L17/dossiers17170600000525021706000005250262PA16542026-03-25False
17060000052566L17/dossiers17170600000525021706000005250263PA7221502026-03-25False
17060000052567L17/dossiers17170600000525021706000005250264PA3350542026-03-25False
17060000052568L17/dossiers17170600000525021706000005250265PA7749582026-03-25False
17060000052569L17/dossiers17170600000525021706000005250266PA8407652026-03-25False
17060000052570L17/dossiers17170600000525021706000005250267PA6431572026-03-25False
17060000052571L17/dossiers17170600000525021706000005250268PA7942702026-03-25False
17060000052572L17/dossiers17170600000525021706000005250269PA8409552026-03-25False
17060000052573L17/dossiers17170600000525021706000005250270PA8413672026-03-25False
17060000052574L17/dossiers17170600000525021706000005250271PA3419812026-03-25False
17060000052575L17/dossiers17170600000525021706000005250272PA8406732026-03-25False
17060000052576L17/dossiers17170600000525021706000005250273PA8266352026-03-25False
17060000052577L17/dossiers17170600000525021706000005250274PA8413272026-03-25False
17060000052578L17/dossiers17170600000525021706000005250275PA8412432026-03-25False
17060000052579L17/dossiers17170600000525021706000005250276PA3403432026-03-25False
17060000052580L17/dossiers17170600000525021706000005250277PA7938162026-03-25False
17060000052581L17/dossiers17170600000525021706000005250278PA7199302026-03-25False
17060000052582L17/dossiers17170600000525021706000005250279PA7944942026-03-25False
17060000052583L17/dossiers17170600000525021706000005250280PA7209922026-03-25False
17060000052584L17/dossiers17170600000525021706000005250281PA7941542026-03-25False
17060000052585L17/dossiers17170600000525021706000005250282PA7950262026-03-25False
17060000052586L17/dossiers17170600000525021706000005250283PA7952582026-03-25False
17060000052587L17/dossiers17170600000525021706000005250284PA7205522026-03-25False
17060000052588L17/dossiers17170600000525021706000005250285PA2670422026-03-25False
17060000052589L17/dossiers17170600000525021706000005250286PA7193382026-03-25False
17060000052590L17/dossiers17170600000525021706000005250287PA7958082026-03-25False
17060000052591L17/dossiers17170600000525021706000005250288PA7961062026-03-25False
17060000052592L17/dossiers17170600000525021706000005250289PA7195582026-03-25False
17060000052593L17/dossiers17170600000525021706000005250290PA8418852026-03-25False
17060000052597L17/dossiers1717060000052595170600000525951PA7950102026-01-28False
17060000052598L17/dossiers1717060000052595170600000525952PA7942782026-01-28False
17060000052599L17/dossiers1717060000052595170600000525953PA6109682026-01-28False
17060000052600L17/dossiers1717060000052595170600000525954PA7951442026-01-28False
17060000052601L17/dossiers1717060000052595170600000525955PA8417012026-01-28False
17060000052602L17/dossiers1717060000052595170600000525956PA7195582026-01-28False
17060000052603L17/dossiers1717060000052595170600000525957PA6431432026-01-28False
17060000052604L17/dossiers1717060000052595170600000525958PA8408292026-01-28False
17060000052605L17/dossiers1717060000052595170600000525959PA2677632026-01-28False
17060000052606L17/dossiers17170600000525951706000005259510PA3424152026-01-28False
17060000052607L17/dossiers17170600000525951706000005259511PA7952782026-01-28False
17060000052608L17/dossiers17170600000525951706000005259512PA7953622026-01-28False
17060000052609L17/dossiers17170600000525951706000005259513PA7954542026-01-28False
17060000052610L17/dossiers17170600000525951706000005259514PA3322282026-01-28False
17060000052611L17/dossiers17170600000525951706000005259515PA6872142026-01-28False
17060000052612L17/dossiers17170600000525951706000005259516PA8421832026-01-28False
17060000052613L17/dossiers17170600000525951706000005259517PA8418852026-01-28False
17060000052614L17/dossiers17170600000525951706000005259518PA8415072026-01-28False
17060000052615L17/dossiers17170600000525951706000005259519PA7214102026-01-28False
17060000052616L17/dossiers17170600000525951706000005259520PA6065072026-01-28False
17060000052617L17/dossiers17170600000525951706000005259521PA7208382026-01-28False