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
17060000006036L17/dossiers1717060000006029170600000060296PA7940082024-02-20False
17060000006037L17/dossiers1717060000006029170600000060297PA7939802024-02-20False
17060000006038L17/dossiers1717060000006029170600000060298PA7950102024-02-20False
17060000006039L17/dossiers1717060000006029170600000060299PA7940222024-02-20False
17060000006040L17/dossiers17170600000060291706000000602910PA7941462024-02-20False
17060000006041L17/dossiers17170600000060291706000000602911PA7956362024-02-20False
17060000006042L17/dossiers17170600000060291706000000602912PA7957942024-02-20False
17060000006043L17/dossiers17170600000060291706000000602913PA7937082024-02-20False
17060000006044L17/dossiers17170600000060291706000000602914PA7936642024-02-20False
17060000006045L17/dossiers17170600000060291706000000602915PA7941542024-02-20False
17060000006046L17/dossiers17170600000060291706000000602916PA7947782024-02-20False
17060000006047L17/dossiers17170600000060291706000000602917PA7950762024-02-20False
17060000006048L17/dossiers17170600000060291706000000602918PA6100022024-02-20False
17060000006049L17/dossiers17170600000060291706000000602919PA7958082024-02-20False
17060000006050L17/dossiers17170600000060291706000000602920PA7209522024-02-20False
17060000006051L17/dossiers17170600000060291706000000602921PA7362012024-02-20False
17060000006091L17/dossiers1717060000006089170600000060891PA7931742024-04-16False
17060000006092L17/dossiers1717060000006089170600000060892PA7961062024-04-16False
17060000006093L17/dossiers1717060000006089170600000060893PA7208382024-04-16False
17060000006094L17/dossiers1717060000006089170600000060894PA7958682024-04-16False
17060000006095L17/dossiers1717060000006089170600000060895PA7951922024-04-16False
17060000006096L17/dossiers1717060000006089170600000060896PA2673062024-04-16False
17060000006097L17/dossiers1717060000006089170600000060897PA7189262024-04-16False
17060000006098L17/dossiers1717060000006089170600000060898PA7218962024-04-16False
17060000006099L17/dossiers1717060000006089170600000060899PA7222022024-04-16False
17060000006100L17/dossiers17170600000060891706000000608910PA7959982024-04-16False
17060000006101L17/dossiers17170600000060891706000000608911PA7951842024-04-16False
17060000006102L17/dossiers17170600000060891706000000608912PA7749622024-04-16False
17060000006103L17/dossiers17170600000060891706000000608913PA3356122024-04-16False
17060000006104L17/dossiers17170600000060891706000000608914PA7960102024-04-16False
17060000006105L17/dossiers17170600000060891706000000608915PA7958202024-04-16False
17060000006106L17/dossiers17170600000060891706000000608916PA7212702024-04-16False
17060000006107L17/dossiers17170600000060891706000000608917PA7952402024-04-16False
17060000006108L17/dossiers17170600000060891706000000608918PA7958762024-04-16False
17060000006109L17/dossiers17170600000060891706000000608919PA6057452024-04-16False
17060000006110L17/dossiers17170600000060891706000000608920PA7946502024-04-16False
17060000006111L17/dossiers17170600000060891706000000608921PA7209922024-04-16False
17060000006839L17/dossiers1717060000006837170600000068371PA6428472025-02-17False
17060000006840L17/dossiers1717060000006837170600000068372PA8410472025-02-17False
17060000006841L17/dossiers1717060000006837170600000068373PA3309092025-02-17False
17060000006842L17/dossiers1717060000006837170600000068374PA3325232024-09-092025-02-17False
17060000006843L17/dossiers1717060000006837170600000068375PA7203862025-02-17False
17060000006844L17/dossiers1717060000006837170600000068376PA6088262025-02-17False
17060000006845L17/dossiers1717060000006837170600000068377PA13272025-02-17False
17060000006846L17/dossiers1717060000006837170600000068378PA6084162025-02-17False
17060000006847L17/dossiers1717060000006837170600000068379PA3467822025-02-17False
17060000006848L17/dossiers17170600000068371706000000683710PA7940382025-02-17False
17060000006849L17/dossiers17170600000068371706000000683711PA7949942025-02-17False
17060000006850L17/dossiers17170600000068371706000000683712PA7930942025-02-17False
17060000006851L17/dossiers17170600000068371706000000683713PA2677942025-02-17False