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
17060000028878L17/dossiers17170600000288021706000002880275PA8407572026-02-05False
17060000028879L17/dossiers17170600000288021706000002880276PA7933542026-02-05False
17060000028880L17/dossiers17170600000288021706000002880277PA7957862026-02-05False
17060000028881L17/dossiers17170600000288021706000002880278PA8419552026-02-05False
17060000028882L17/dossiers17170600000288021706000002880279PA8407812026-02-05False
17060000028883L17/dossiers17170600000288021706000002880280PA8420012026-02-05False
17060000028884L17/dossiers17170600000288021706000002880281PA7935482026-02-05False
17060000028885L17/dossiers17170600000288021706000002880282PA8416052026-02-05False
17060000028886L17/dossiers17170600000288021706000002880283PA8422552026-02-05False
17060000028887L17/dossiers17170600000288021706000002880284PA7932302026-02-05False
17060000028888L17/dossiers17170600000288021706000002880285PA7931822026-02-05False
17060000028889L17/dossiers17170600000288021706000002880286PA8420852026-02-05False
17060000028890L17/dossiers17170600000288021706000002880287PA7959122026-02-05False
17060000028891L17/dossiers17170600000288021706000002880288PA7945902026-02-05False
17060000028892L17/dossiers17170600000288021706000002880289PA8408372026-02-05False
17060000028893L17/dossiers17170600000288021706000002880290PA8411992026-02-05False
17060000028894L17/dossiers17170600000288021706000002880291PA8406572026-02-05False
17060000028895L17/dossiers17170600000288021706000002880292PA7945022026-02-05False
17060000028896L17/dossiers17170600000288021706000002880293PA7934322026-02-05False
17060000028897L17/dossiers17170600000288021706000002880294PA7961182026-02-05False
17060000028898L17/dossiers17170600000288021706000002880295PA8401592026-02-05False
17060000028899L17/dossiers17170600000288021706000002880296PA7939282026-02-05False
17060000028900L17/dossiers17170600000288021706000002880297PA8417612026-02-05False
17060000028901L17/dossiers17170600000288021706000002880298PA8407732026-02-05False
17060000028902L17/dossiers17170600000288021706000002880299PA7932902026-02-05False
17060000028903L17/dossiers171706000002880217060000028802100PA8415872026-02-05False
17060000028904L17/dossiers171706000002880217060000028802101PA7938522026-02-05False
17060000028905L17/dossiers171706000002880217060000028802102PA7936962026-02-05False
17060000028906L17/dossiers171706000002880217060000028802103PA7949542026-02-05False
17060000028907L17/dossiers171706000002880217060000028802104PA7957782026-02-05False
17060000028908L17/dossiers171706000002880217060000028802105PA8418252026-02-05False
17060000028909L17/dossiers171706000002880217060000028802106PA7938322026-02-05False
17060000028910L17/dossiers171706000002880217060000028802107PA7933822026-02-05False
17060000028911L17/dossiers171706000002880217060000028802108PA7931662026-02-05False
17060000028918L17/dossiers1717060000028916170600000289161PA8417132025-03-11False
17060000028919L17/dossiers1717060000028916170600000289162PA7950102025-03-11False
17060000028920L17/dossiers1717060000028916170600000289163PA8416572025-03-11False
17060000028921L17/dossiers1717060000028916170600000289164PA3403432025-03-11False
17060000028922L17/dossiers1717060000028916170600000289165PA8409032025-03-11False
17060000028923L17/dossiers1717060000028916170600000289166PA8418532025-03-11False
17060000028924L17/dossiers1717060000028916170600000289167PA8401712025-03-11False
17060000028925L17/dossiers1717060000028916170600000289168PA7954302025-03-11False
17060000028932L17/dossiers1717060000028930170600000289301PA7204682025-04-25False
17060000028933L17/dossiers1717060000028930170600000289302PA8417692025-04-25False
17060000028934L17/dossiers1717060000028930170600000289303PA8407012025-04-25False
17060000028935L17/dossiers1717060000028930170600000289304PA7931342025-04-25False
17060000028936L17/dossiers1717060000028930170600000289305PA7960262025-04-25False
17060000028937L17/dossiers1717060000028930170600000289306PA8420852025-04-25False
17060000028938L17/dossiers1717060000028930170600000289307PA7959002025-04-25False
17060000028939L17/dossiers1717060000028930170600000289308PA7933142025-04-25False