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
17060000023999L17/dossiers1717060000023997170600000239971PA7939282025-03-13False
17060000024000L17/dossiers1717060000023997170600000239972PA7947702025-03-13False
17060000024001L17/dossiers1717060000023997170600000239973PA7959742025-03-13False
17060000024002L17/dossiers1717060000023997170600000239974PA7931822025-03-13False
17060000024003L17/dossiers1717060000023997170600000239975PA7933542025-03-13False
17060000024004L17/dossiers1717060000023997170600000239976PA7936162025-03-13False
17060000024005L17/dossiers1717060000023997170600000239977PA7956442025-03-13False
17060000024006L17/dossiers1717060000023997170600000239978PA7945622025-03-13False
17060000024007L17/dossiers1717060000023997170600000239979PA7959002025-03-13False
17060000024008L17/dossiers17170600000239971706000002399710PA7949542025-03-13False
17060000024009L17/dossiers17170600000239971706000002399711PA6429882025-03-13False
17060000024010L17/dossiers17170600000239971706000002399712PA8419812025-03-13False
17060000024011L17/dossiers17170600000239971706000002399713PA8409672025-03-13False
17060000024012L17/dossiers17170600000239971706000002399714PA7931662025-03-13False
17060000024013L17/dossiers17170600000239971706000002399715PA7946782025-03-13False
17060000024014L17/dossiers17170600000239971706000002399716PA7941982025-03-13False
17060000024015L17/dossiers17170600000239971706000002399717PA8410752025-03-13False
17060000024016L17/dossiers17170600000239971706000002399718PA7933302025-03-13False
17060000024017L17/dossiers17170600000239971706000002399719PA8408372025-03-13False
17060000024018L17/dossiers17170600000239971706000002399720PA7948862025-03-13False
17060000024019L17/dossiers17170600000239971706000002399721PA7944422025-03-13False
17060000024020L17/dossiers17170600000239971706000002399722PA8414792025-03-13False
17060000024021L17/dossiers17170600000239971706000002399723PA7931582025-03-13False
17060000024022L17/dossiers17170600000239971706000002399724PA7960262025-03-13False
17060000024023L17/dossiers17170600000239971706000002399725PA7957862025-03-13False
17060000024024L17/dossiers17170600000239971706000002399726PA7194362025-03-13False
17060000024025L17/dossiers17170600000239971706000002399727PA7932902025-03-13False
17060000024026L17/dossiers17170600000239971706000002399728PA8420732025-03-13False
17060000024027L17/dossiers17170600000239971706000002399729PA7943542025-03-13False
17060000024028L17/dossiers17170600000239971706000002399730PA7935482025-03-13False
17060000024029L17/dossiers17170600000239971706000002399731PA7935922025-03-13False
17060000024030L17/dossiers17170600000239971706000002399732PA8414512025-03-13False
17060000024031L17/dossiers17170600000239971706000002399733PA8416052025-03-13False
17060000024032L17/dossiers17170600000239971706000002399734PA8418252025-03-13False
17060000024033L17/dossiers17170600000239971706000002399735PA7938322025-03-13False
17060000024034L17/dossiers17170600000239971706000002399736PA8411992025-03-13False
17060000024035L17/dossiers17170600000239971706000002399737PA7208222025-03-13False
17060000024036L17/dossiers17170600000239971706000002399738PA8418372025-03-13False
17060000024037L17/dossiers17170600000239971706000002399739PA8401352025-03-13False
17060000024038L17/dossiers17170600000239971706000002399740PA8420972025-03-13False
17060000024039L17/dossiers17170600000239971706000002399741PA7934322025-03-13False
17060000024040L17/dossiers17170600000239971706000002399742PA7945022025-03-13False
17060000024041L17/dossiers17170600000239971706000002399743PA8408692025-03-13False
17060000024042L17/dossiers17170600000239971706000002399744PA7938922025-03-13False
17060000024043L17/dossiers17170600000239971706000002399745PA8414392025-03-13False
17060000024044L17/dossiers17170600000239971706000002399746PA8419552025-03-13False
17060000024045L17/dossiers17170600000239971706000002399747PA7933742025-03-13False
17060000024046L17/dossiers17170600000239971706000002399748PA7936082025-03-13False
17060000024047L17/dossiers17170600000239971706000002399749PA8417372025-03-13False
17060000024048L17/dossiers17170600000239971706000002399750PA8416212025-03-13False