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
17060000029420L17/dossiers17170600000293981706000002939821PA7936642025-03-11False
17060000029421L17/dossiers17170600000293981706000002939822PA7950762025-03-11False
17060000029422L17/dossiers17170600000293981706000002939823PA7221422025-03-11False
17060000029423L17/dossiers17170600000293981706000002939824PA6100022025-03-11False
17060000029424L17/dossiers17170600000293981706000002939825PA7362012025-03-11False
17060000029428L17/dossiers1717060000029426170600000294261PA7932102025-04-30False
17060000029429L17/dossiers1717060000029426170600000294262PA7214862025-04-30False
17060000029430L17/dossiers1717060000029426170600000294263PA7209762025-04-30False
17060000029431L17/dossiers1717060000029426170600000294264PA7191382025-04-30False
17060000029432L17/dossiers1717060000029426170600000294265PA6076192025-04-30False
17060000029433L17/dossiers1717060000029426170600000294266PA8413592025-04-30False
17060000029434L17/dossiers1717060000029426170600000294267PA2677632025-04-30False
17060000029435L17/dossiers1717060000029426170600000294268PA7192862025-04-30False
17060000029436L17/dossiers1717060000029426170600000294269PA7952442025-04-30False
17060000029437L17/dossiers17170600000294261706000002942610PA7945542025-04-30False
17060000029438L17/dossiers17170600000294261706000002942611PA7214742025-04-30False
17060000029439L17/dossiers17170600000294261706000002942612PA8408172025-04-30False
17060000029440L17/dossiers17170600000294261706000002942613PA7211102025-04-30False
17060000029441L17/dossiers17170600000294261706000002942614PA7209602025-04-30False
17060000029442L17/dossiers17170600000294261706000002942615PA29522025-04-30False
17060000029443L17/dossiers17170600000294261706000002942616PA8410172025-04-30False
17060000029444L17/dossiers17170600000294261706000002942617PA8226172025-04-30False
17060000029445L17/dossiers17170600000294261706000002942618PA9422025-04-30False
17060000029446L17/dossiers17170600000294261706000002942619PA7937962025-04-30False
17060000029447L17/dossiers17170600000294261706000002942620PA7960782025-04-30False
17060000029448L17/dossiers17170600000294261706000002942621PA2670422025-04-30False
17060000029449L17/dossiers17170600000294261706000002942622PA15922025-04-30False
17060000029450L17/dossiers17170600000294261706000002942623PA7935722025-04-30False
17060000029451L17/dossiers17170600000294261706000002942624PA7218442025-04-30False
17060000029452L17/dossiers17170600000294261706000002942625PA7948022025-04-30False
17060000029453L17/dossiers17170600000294261706000002942626PA6056942025-04-30False
17060000029454L17/dossiers17170600000294261706000002942627PA7931942025-04-30False
17060000029455L17/dossiers17170600000294261706000002942628PA5692025-04-30False
17060000029456L17/dossiers17170600000294261706000002942629PA7202302025-04-30False
17060000029457L17/dossiers17170600000294261706000002942630PA7947982025-04-30False
17060000029458L17/dossiers17170600000294261706000002942631PA7946582025-04-30False
17060000029459L17/dossiers17170600000294261706000002942632PA7933422025-04-30False
17060000029460L17/dossiers17170600000294261706000002942633PA7949942025-04-30False
17060000029461L17/dossiers17170600000294261706000002942634PA7940422025-04-30False
17060000029462L17/dossiers17170600000294261706000002942635PA8410472025-04-30False
17060000029463L17/dossiers17170600000294261706000002942636PA8419272025-04-30False
17060000029464L17/dossiers17170600000294261706000002942637PA7195122025-04-30False
17060000029465L17/dossiers17170600000294261706000002942638PA6088262025-04-30False
17060000029466L17/dossiers17170600000294261706000002942639PA7223902025-04-30False
17060000029467L17/dossiers17170600000294261706000002942640PA7192182025-04-30False
17060000029468L17/dossiers17170600000294261706000002942641PA7944862025-04-30False
17060000029469L17/dossiers17170600000294261706000002942642PA8402352025-04-30False
17060000029470L17/dossiers17170600000294261706000002942643PA2673182025-04-30False
17060000029471L17/dossiers17170600000294261706000002942644PA7930942025-04-30False
17060000029472L17/dossiers17170600000294261706000002942645PA8414192025-04-30False