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
17060000046257L17/dossiers17170600000462011706000004620155PA7947782025-10-10False
17060000046258L17/dossiers17170600000462011706000004620156PA8406732025-10-10False
17060000046259L17/dossiers17170600000462011706000004620157PA3421962025-10-10False
17060000046260L17/dossiers17170600000462011706000004620158PA8266352025-10-10False
17060000046261L17/dossiers17170600000462011706000004620159PA8413272025-10-10False
17060000046262L17/dossiers17170600000462011706000004620160PA8412432025-10-10False
17060000046263L17/dossiers17170600000462011706000004620161PA7749602025-10-10False
17060000046264L17/dossiers17170600000462011706000004620162PA3403432025-10-10False
17060000046265L17/dossiers17170600000462011706000004620163PA8410912025-10-10False
17060000046266L17/dossiers17170600000462011706000004620164PA8416812025-10-10False
17060000046267L17/dossiers17170600000462011706000004620165PA8417132025-10-10False
17060000046268L17/dossiers17170600000462011706000004620166PA8418932025-10-10False
17060000046269L17/dossiers17170600000462011706000004620167PA7938162025-10-10False
17060000046270L17/dossiers17170600000462011706000004620168PA7199302025-10-10False
17060000046271L17/dossiers17170600000462011706000004620169PA7944942025-10-10False
17060000046272L17/dossiers17170600000462011706000004620170PA7209922025-10-10False
17060000046276L17/dossiers1717060000046274170600000462741PA8407012025-09-23False
17060000046277L17/dossiers1717060000046274170600000462742PA8417692025-09-23False
17060000046278L17/dossiers1717060000046274170600000462743PA7956442025-09-23False
17060000046279L17/dossiers1717060000046274170600000462744PA7960342025-09-23False
17060000046280L17/dossiers1717060000046274170600000462745PA8414952025-09-23False
17060000046281L17/dossiers1717060000046274170600000462746PA7940302025-09-23False
17060000046282L17/dossiers1717060000046274170600000462747PA7931342025-09-23False
17060000046283L17/dossiers1717060000046274170600000462748PA7933742025-09-23False
17060000046284L17/dossiers1717060000046274170600000462749PA7932902025-09-23False
17060000046288L17/dossiers1717060000046286170600000462861PA8407012025-09-23False
17060000046289L17/dossiers1717060000046286170600000462862PA8417692025-09-23False
17060000046290L17/dossiers1717060000046286170600000462863PA7956442025-09-23False
17060000046291L17/dossiers1717060000046286170600000462864PA7960342025-09-23False
17060000046292L17/dossiers1717060000046286170600000462865PA8409832025-09-23False
17060000046293L17/dossiers1717060000046286170600000462866PA7940302025-09-23False
17060000046294L17/dossiers1717060000046286170600000462867PA7931342025-09-23False
17060000046295L17/dossiers1717060000046286170600000462868PA7933742025-09-23False
17060000046296L17/dossiers1717060000046286170600000462869PA7932902025-09-23False
17060000046300L17/dossiers1717060000046298170600000462981PA7934322025-09-17False
17060000046301L17/dossiers1717060000046298170600000462982PA8414952025-09-17False
17060000046302L17/dossiers1717060000046298170600000462983PA7961182025-09-17False
17060000046303L17/dossiers1717060000046298170600000462984PA7945622025-09-17False
17060000046304L17/dossiers1717060000046298170600000462985PA8422792025-09-17False
17060000046305L17/dossiers1717060000046298170600000462986PA7932382025-09-17False
17060000046306L17/dossiers1717060000046298170600000462987PA7933742025-09-17False
17060000046307L17/dossiers1717060000046298170600000462988PA7931582025-09-17False
17060000046308L17/dossiers1717060000046298170600000462989PA7944342025-09-17False
17060000046309L17/dossiers17170600000462981706000004629810PA8416452025-09-17False
17060000046310L17/dossiers17170600000462981706000004629811PA8420012025-09-17False
17060000046311L17/dossiers17170600000462981706000004629812PA7208222025-09-17False
17060000046312L17/dossiers17170600000462981706000004629813PA7206682025-09-17False
17060000046313L17/dossiers17170600000462981706000004629814PA7948862025-09-17False
17060000046314L17/dossiers17170600000462981706000004629815PA7960422025-09-17False
17060000046315L17/dossiers17170600000462981706000004629816PA7938442025-09-17False