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
17060000041566L17/dossiers17170600000414681706000004146897PA7203542025-11-27False
17060000041567L17/dossiers17170600000414681706000004146898PA7197982025-11-27False
17060000041568L17/dossiers17170600000414681706000004146899PA7210042025-11-27False
17060000041569L17/dossiers171706000004146817060000041468100PA7194122025-11-27False
17060000041570L17/dossiers171706000004146817060000041468101PA7194042025-11-27False
17060000041571L17/dossiers171706000004146817060000041468102PA7203422025-11-27False
17060000041572L17/dossiers171706000004146817060000041468103PA7218522025-11-27False
17060000041573L17/dossiers171706000004146817060000041468104PA7211342025-11-27False
17060000041574L17/dossiers171706000004146817060000041468105PA7204462025-11-27False
17060000041575L17/dossiers171706000004146817060000041468106PA7957302025-11-27False
17060000041576L17/dossiers171706000004146817060000041468107PA7190802025-11-27False
17060000041577L17/dossiers171706000004146817060000041468108PA6774832025-11-27False
17060000041578L17/dossiers171706000004146817060000041468109PA7193382025-11-27False
17060000041579L17/dossiers171706000004146817060000041468110PA7203702025-11-27False
17060000041580L17/dossiers171706000004146817060000041468111PA7956642025-11-27False
17060000041581L17/dossiers171706000004146817060000041468112PA7196322025-11-27False
17060000041582L17/dossiers171706000004146817060000041468113PA7219162025-11-27False
17060000041583L17/dossiers171706000004146817060000041468114PA7214262025-11-27False
17060000041584L17/dossiers171706000004146817060000041468115PA7222522025-11-27False
17060000041585L17/dossiers171706000004146817060000041468116PA7958882025-11-27False
17060000041586L17/dossiers171706000004146817060000041468117PA7932702025-11-27False
17060000041587L17/dossiers171706000004146817060000041468118PA7572252025-11-27False
17060000041588L17/dossiers171706000004146817060000041468119PA7948022025-11-27False
17060000041589L17/dossiers171706000004146817060000041468120PA7195502025-11-27False
17060000041590L17/dossiers171706000004146817060000041468121PA7211702025-07-112025-07-11False
17060000041594L17/dossiers1717060000041592170600000415921PA6075532025-07-11False
17060000041598L17/dossiers1717060000041596170600000415961PA2675612025-07-112025-07-11False
17060000041599L17/dossiers1717060000041596170600000415962PA7933742025-07-11False
17060000041600L17/dossiers1717060000041596170600000415963PA7944342025-07-11False
17060000041601L17/dossiers1717060000041596170600000415964PA3096432025-07-11False
17060000041602L17/dossiers1717060000041596170600000415965PA7199682025-07-11False
17060000041603L17/dossiers1717060000041596170600000415966PA7931342025-07-11False
17060000041604L17/dossiers1717060000041596170600000415967PA8400752025-07-11False
17060000041605L17/dossiers1717060000041596170600000415968PA8407012025-07-11False
17060000041606L17/dossiers1717060000041596170600000415969PA7204682025-07-11False
17060000041607L17/dossiers17170600000415961706000004159610PA7940422025-07-11False
17060000041608L17/dossiers17170600000415961706000004159611PA7939282025-07-11False
17060000041609L17/dossiers17170600000415961706000004159612PA8407732025-07-11False
17060000041610L17/dossiers17170600000415961706000004159613PA8401432025-07-11False
17060000041611L17/dossiers17170600000415961706000004159614PA7946782025-07-11False
17060000041612L17/dossiers17170600000415961706000004159615PA7945982025-07-11False
17060000041613L17/dossiers17170600000415961706000004159616PA7943542025-07-11False
17060000041614L17/dossiers17170600000415961706000004159617PA7959122025-07-11False
17060000041615L17/dossiers17170600000415961706000004159618PA8409672025-07-11False
17060000041616L17/dossiers17170600000415961706000004159619PA7945902025-07-11False
17060000041617L17/dossiers17170600000415961706000004159620PA7947702025-07-11False
17060000041618L17/dossiers17170600000415961706000004159621PA8409152025-07-11False
17060000041619L17/dossiers17170600000415961706000004159622PA8419812025-07-11False
17060000041620L17/dossiers17170600000415961706000004159623PA7945702025-07-11False
17060000041621L17/dossiers17170600000415961706000004159624PA8422552025-07-11False