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
17060000051396L17/dossiers17170600000513401706000005134055PA7957302026-01-21False
17060000051397L17/dossiers17170600000513401706000005134056PA7942062026-01-21False
17060000051398L17/dossiers17170600000513401706000005134057PA7190802026-01-21False
17060000051399L17/dossiers17170600000513401706000005134058PA7201462026-01-21False
17060000051400L17/dossiers17170600000513401706000005134059PA6774832026-01-21False
17060000051401L17/dossiers17170600000513401706000005134060PA7193382026-01-21False
17060000051402L17/dossiers17170600000513401706000005134061PA7203702026-01-21False
17060000051403L17/dossiers17170600000513401706000005134062PA7951762026-01-21False
17060000051404L17/dossiers17170600000513401706000005134063PA7956642026-01-21False
17060000051405L17/dossiers17170600000513401706000005134064PA8172032026-01-21False
17060000051406L17/dossiers17170600000513401706000005134065PA7959622026-01-21False
17060000051407L17/dossiers17170600000513401706000005134066PA8421472026-01-21False
17060000051408L17/dossiers17170600000513401706000005134067PA7957222026-01-21False
17060000051409L17/dossiers17170600000513401706000005134068PA7598322026-01-21False
17060000051410L17/dossiers17170600000513401706000005134069PA7196322026-01-21False
17060000051411L17/dossiers17170600000513401706000005134070PA7950502026-01-21False
17060000051412L17/dossiers17170600000513401706000005134071PA7219162026-01-21False
17060000051413L17/dossiers17170600000513401706000005134072PA3357582026-01-21False
17060000051414L17/dossiers17170600000513401706000005134073PA7214262026-01-21False
17060000051415L17/dossiers17170600000513401706000005134074PA7222522026-01-21False
17060000051416L17/dossiers17170600000513401706000005134075PA7955282026-01-21False
17060000051417L17/dossiers17170600000513401706000005134076PA8419272026-01-21False
17060000051418L17/dossiers17170600000513401706000005134077PA7932702026-01-21False
17060000051419L17/dossiers17170600000513401706000005134078PA7572252026-01-21False
17060000051420L17/dossiers17170600000513401706000005134079PA7948022026-01-21False
17060000051421L17/dossiers17170600000513401706000005134080PA7201902026-01-21False
17060000051422L17/dossiers17170600000513401706000005134081PA7944862026-01-21False
17060000051423L17/dossiers17170600000513401706000005134082PA7195502026-01-21False
17060000051424L17/dossiers17170600000513401706000005134083PA7215842026-01-21False
17060000051425L17/dossiers17170600000513401706000005134084PA7959202026-01-21False
17060000051426L17/dossiers17170600000513401706000005134085PA6073952026-01-21False
17060000051427L17/dossiers17170600000513401706000005134086PA7221022026-01-21False
17060000051428L17/dossiers17170600000513401706000005134087PA7195122026-01-21False
17060000051429L17/dossiers17170600000513401706000005134088PA7953262026-01-21False
17060000051430L17/dossiers17170600000513401706000005134089PA29602026-01-21False
17060000051431L17/dossiers17170600000513401706000005134090PA7950462026-01-21False
17060000051435L17/dossiers1717060000051433170600000514331PA8412952026-09-22False
17060000051436L17/dossiers1717060000051433170600000514332PA7195122026-09-22False
17060000051437L17/dossiers1717060000051433170600000514333PA6056942026-09-22False
17060000051438L17/dossiers1717060000051433170600000514334PA7950762026-09-22False
17060000051439L17/dossiers1717060000051433170600000514335PA7949062026-09-22False
17060000051440L17/dossiers1717060000051433170600000514336PA7218162026-09-22False
17060000051441L17/dossiers1717060000051433170600000514337PA7191382026-09-22False
17060000051442L17/dossiers1717060000051433170600000514338PA7935202026-09-22False
17060000051443L17/dossiers1717060000051433170600000514339PA7933942026-09-22False
17060000051444L17/dossiers17170600000514331706000005143310PA7950102026-09-22False
17060000051445L17/dossiers17170600000514331706000005143311PA8401712026-09-22False
17060000051446L17/dossiers17170600000514331706000005143312PA7223742026-09-22False
17060000051447L17/dossiers17170600000514331706000005143313PA6431922026-09-22False
17060000051448L17/dossiers17170600000514331706000005143314PA7196402026-09-22False