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
17060000016350L17/dossiers17170600000163211706000001632128PA8416332025-01-07False
17060000016351L17/dossiers17170600000163211706000001632129PA7952002025-01-07False
17060000016352L17/dossiers17170600000163211706000001632130PA8413512025-01-07False
17060000016353L17/dossiers17170600000163211706000001632131PA7958442025-01-07False
17060000016354L17/dossiers17170600000163211706000001632132PA7939802025-01-07False
17060000016355L17/dossiers17170600000163211706000001632133PA7960702025-01-07False
17060000016356L17/dossiers17170600000163211706000001632134PA7950102025-01-07False
17060000016357L17/dossiers17170600000163211706000001632135PA8414192025-01-07False
17060000016358L17/dossiers17170600000163211706000001632136PA7953102025-01-07False
17060000016359L17/dossiers17170600000163211706000001632137PA8420132025-01-07False
17060000016360L17/dossiers17170600000163211706000001632138PA8409472025-01-07False
17060000016361L17/dossiers17170600000163211706000001632139PA7940822025-01-07False
17060000016362L17/dossiers17170600000163211706000001632140PA7940222025-01-07False
17060000016363L17/dossiers17170600000163211706000001632141PA7200382025-01-07False
17060000016364L17/dossiers17170600000163211706000001632142PA6431922025-01-07False
17060000016365L17/dossiers17170600000163211706000001632143PA7941462025-01-07False
17060000016366L17/dossiers17170600000163211706000001632144PA8412232025-01-07False
17060000016367L17/dossiers17170600000163211706000001632145PA7955162025-01-07False
17060000016368L17/dossiers17170600000163211706000001632146PA8415152025-01-07False
17060000016369L17/dossiers17170600000163211706000001632147PA7935322025-01-07False
17060000016370L17/dossiers17170600000163211706000001632148PA7956362025-01-07False
17060000016371L17/dossiers17170600000163211706000001632149PA8412152025-01-07False
17060000016372L17/dossiers17170600000163211706000001632150PA8411912025-01-07False
17060000016373L17/dossiers17170600000163211706000001632151PA8420452025-01-07False
17060000016374L17/dossiers17170600000163211706000001632152PA7208922025-01-07False
17060000016375L17/dossiers17170600000163211706000001632153PA7937082025-01-07False
17060000016376L17/dossiers17170600000163211706000001632154PA8172112025-01-07False
17060000016377L17/dossiers17170600000163211706000001632155PA6081722025-01-07False
17060000016378L17/dossiers17170600000163211706000001632156PA7936642025-01-07False
17060000016379L17/dossiers17170600000163211706000001632157PA7195782025-01-07False
17060000016380L17/dossiers17170600000163211706000001632158PA7947782025-01-07False
17060000016381L17/dossiers17170600000163211706000001632159PA7952402025-01-07False
17060000016382L17/dossiers17170600000163211706000001632160PA3421962025-01-07False
17060000016383L17/dossiers17170600000163211706000001632161PA6065452025-01-07False
17060000016384L17/dossiers17170600000163211706000001632162PA7950762025-01-07False
17060000016385L17/dossiers17170600000163211706000001632163PA8413272025-01-07False
17060000016386L17/dossiers17170600000163211706000001632164PA7221422025-01-07False
17060000016387L17/dossiers17170600000163211706000001632165PA8418452025-01-07False
17060000016388L17/dossiers17170600000163211706000001632166PA6100022025-01-07False
17060000016389L17/dossiers17170600000163211706000001632167PA7958082025-01-07False
17060000016390L17/dossiers17170600000163211706000001632168PA8410912025-01-07False
17060000016391L17/dossiers17170600000163211706000001632169PA7960182025-01-07False
17060000016392L17/dossiers17170600000163211706000001632170PA7362012025-01-07False
17060000016393L17/dossiers17170600000163211706000001632171PA7941662025-01-07False
17060000016394L17/dossiers17170600000163211706000001632172PA8417132025-01-07False
17060000016395L17/dossiers17170600000163211706000001632173PA7939482025-01-07False
17060000016396L17/dossiers17170600000163211706000001632174PA7951642025-01-07False
17060000016397L17/dossiers17170600000163211706000001632175PA29402025-01-07False
17060000016401L17/dossiers1717060000016399170600000163991PA8418132024-10-29False
17060000016402L17/dossiers1717060000016399170600000163992PA7199302024-10-29False