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
17060000029888L17/dossiers171706000002978517060000029785102PA8410912025-06-19False
17060000029889L17/dossiers171706000002978517060000029785103PA7954662025-06-19False
17060000029890L17/dossiers171706000002978517060000029785104PA7937442025-06-19False
17060000029891L17/dossiers171706000002978517060000029785105PA7209522025-06-19False
17060000029892L17/dossiers171706000002978517060000029785106PA7937962025-06-19False
17060000029893L17/dossiers171706000002978517060000029785107PA7941062025-06-19False
17060000029894L17/dossiers171706000002978517060000029785108PA7941662025-06-19False
17060000029895L17/dossiers171706000002978517060000029785109PA8417132025-06-19False
17060000029896L17/dossiers171706000002978517060000029785110PA8418932025-06-19False
17060000029897L17/dossiers171706000002978517060000029785111PA7951642025-06-19False
17060000029898L17/dossiers171706000002978517060000029785112PA7955962025-06-19False
17060000029902L17/dossiers1717060000029900170600000299001PA7214862025-04-08False
17060000029903L17/dossiers1717060000029900170600000299002PA8408172025-04-08False
17060000029904L17/dossiers1717060000029900170600000299003PA7960782025-04-08False
17060000029905L17/dossiers1717060000029900170600000299004PA7214742025-04-08False
17060000029906L17/dossiers1717060000029900170600000299005PA2677632025-04-08False
17060000029907L17/dossiers1717060000029900170600000299006PA7945542025-04-08False
17060000029908L17/dossiers1717060000029900170600000299007PA7931942025-04-08False
17060000029909L17/dossiers1717060000029900170600000299008PA3096432025-04-08False
17060000029910L17/dossiers1717060000029900170600000299009PA4085782025-04-08False
17060000029911L17/dossiers17170600000299001706000002990010PA7930942025-04-08False
17060000029912L17/dossiers17170600000299001706000002990011PA7949942025-04-08False
17060000029913L17/dossiers17170600000299001706000002990012PA7223902025-04-08False
17060000029914L17/dossiers17170600000299001706000002990013PA7944702025-04-08False
17060000029915L17/dossiers17170600000299001706000002990014PA6872142025-04-08False
17060000029916L17/dossiers17170600000299001706000002990015PA8419272025-04-08False
17060000029917L17/dossiers17170600000299001706000002990016PA7931222025-04-08False
17060000029918L17/dossiers17170600000299001706000002990017PA16302025-04-08False
17060000029919L17/dossiers17170600000299001706000002990018PA7940422025-04-08False
17060000029920L17/dossiers17170600000299001706000002990019PA7218442025-04-08False
17060000029924L17/dossiers1717060000029922170600000299221PA8408172025-04-08False
17060000029925L17/dossiers1717060000029922170600000299222PA7214862025-04-08False
17060000029926L17/dossiers1717060000029922170600000299223PA7960782025-04-08False
17060000029927L17/dossiers1717060000029922170600000299224PA7214742025-04-08False
17060000029928L17/dossiers1717060000029922170600000299225PA2677632025-04-08False
17060000029929L17/dossiers1717060000029922170600000299226PA7945542025-04-08False
17060000029930L17/dossiers1717060000029922170600000299227PA3096432025-04-08False
17060000029931L17/dossiers1717060000029922170600000299228PA4085782025-04-08False
17060000029932L17/dossiers1717060000029922170600000299229PA7930942025-04-08False
17060000029933L17/dossiers17170600000299221706000002992210PA7949942025-04-08False
17060000029934L17/dossiers17170600000299221706000002992211PA7223902025-04-08False
17060000029935L17/dossiers17170600000299221706000002992212PA7944702025-04-08False
17060000029936L17/dossiers17170600000299221706000002992213PA6872142025-04-08False
17060000029937L17/dossiers17170600000299221706000002992214PA8419272025-04-08False
17060000029938L17/dossiers17170600000299221706000002992215PA7931222025-04-08False
17060000029939L17/dossiers17170600000299221706000002992216PA16302025-04-08False
17060000029940L17/dossiers17170600000299221706000002992217PA7940422025-04-08False
17060000029941L17/dossiers17170600000299221706000002992218PA7218442025-04-08False
17060000029945L17/dossiers1717060000029943170600000299431PA7208922025-04-08False
17060000029946L17/dossiers1717060000029943170600000299432PA7952282025-04-08False