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
17060000049263L17/dossiers1717060000049255170600000492557PA8421052025-10-28False
17060000049264L17/dossiers1717060000049255170600000492558PA8416572025-10-28False
17060000049265L17/dossiers1717060000049255170600000492559PA7204302025-10-28False
17060000049266L17/dossiers17170600000492551706000004925510PA7937722025-10-28False
17060000049267L17/dossiers17170600000492551706000004925511PA7956162025-10-28False
17060000049268L17/dossiers17170600000492551706000004925512PA7934442025-10-28False
17060000049269L17/dossiers17170600000492551706000004925513PA7949382025-10-28False
17060000049270L17/dossiers17170600000492551706000004925514PA7953182025-10-28False
17060000049271L17/dossiers17170600000492551706000004925515PA8410232025-10-28False
17060000049272L17/dossiers17170600000492551706000004925516PA7960902025-10-28False
17060000049273L17/dossiers17170600000492551706000004925517PA7939122025-10-28False
17060000049274L17/dossiers17170600000492551706000004925518PA8421872025-10-28False
17060000049275L17/dossiers17170600000492551706000004925519PA8420372025-10-28False
17060000049276L17/dossiers17170600000492551706000004925520PA7918122025-10-28False
17060000049277L17/dossiers17170600000492551706000004925521PA7937362025-10-28False
17060000049278L17/dossiers17170600000492551706000004925522PA7212022025-10-28False
17060000049279L17/dossiers17170600000492551706000004925523PA7951362025-10-28False
17060000049280L17/dossiers17170600000492551706000004925524PA8421552025-10-28False
17060000049281L17/dossiers17170600000492551706000004925525PA7952002025-10-28False
17060000049282L17/dossiers17170600000492551706000004925526PA7958442025-10-28False
17060000049283L17/dossiers17170600000492551706000004925527PA8412512025-10-28False
17060000049284L17/dossiers17170600000492551706000004925528PA7947862025-10-28False
17060000049285L17/dossiers17170600000492551706000004925529PA7948702025-10-28False
17060000049286L17/dossiers17170600000492551706000004925530PA7960702025-10-28False
17060000049287L17/dossiers17170600000492551706000004925531PA7953102025-10-28False
17060000049288L17/dossiers17170600000492551706000004925532PA7944782025-10-28False
17060000049289L17/dossiers17170600000492551706000004925533PA8419472025-10-28False
17060000049290L17/dossiers17170600000492551706000004925534PA7940822025-10-28False
17060000049291L17/dossiers17170600000492551706000004925535PA7941302025-10-28False
17060000049292L17/dossiers17170600000492551706000004925536PA7208462025-10-28False
17060000049293L17/dossiers17170600000492551706000004925537PA8417292025-10-28False
17060000049294L17/dossiers17170600000492551706000004925538PA7955162025-10-28False
17060000049295L17/dossiers17170600000492551706000004925539PA7956722025-10-28False
17060000049296L17/dossiers17170600000492551706000004925540PA7957462025-10-28False
17060000049297L17/dossiers17170600000492551706000004925541PA7951082025-10-28False
17060000049298L17/dossiers17170600000492551706000004925542PA8415152025-10-28False
17060000049299L17/dossiers17170600000492551706000004925543PA7952982025-10-28False
17060000049300L17/dossiers17170600000492551706000004925544PA7918242025-10-28False
17060000049301L17/dossiers17170600000492551706000004925545PA8420292025-10-28False
17060000049302L17/dossiers17170600000492551706000004925546PA7935322025-10-28False
17060000049303L17/dossiers17170600000492551706000004925547PA3423842025-10-28False
17060000049304L17/dossiers17170600000492551706000004925548PA7954222025-10-28False
17060000049305L17/dossiers17170600000492551706000004925549PA7946862025-10-28False
17060000049306L17/dossiers17170600000492551706000004925550PA8412152025-10-28False
17060000049307L17/dossiers17170600000492551706000004925551PA7954822025-10-28False
17060000049308L17/dossiers17170600000492551706000004925552PA6106542025-10-28False
17060000049309L17/dossiers17170600000492551706000004925553PA8411912025-10-28False
17060000049310L17/dossiers17170600000492551706000004925554PA7219602025-10-28False
17060000049311L17/dossiers17170600000492551706000004925555PA7938722025-10-28False
17060000049312L17/dossiers17170600000492551706000004925556PA7208922025-10-28False