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
17060000051028L17/dossiers17170600000509781706000005097849PA7190802025-12-15False
17060000051029L17/dossiers17170600000509781706000005097850PA8419312025-12-15False
17060000051030L17/dossiers17170600000509781706000005097851PA7193382025-12-15False
17060000051031L17/dossiers17170600000509781706000005097852PA7203702025-12-15False
17060000051032L17/dossiers17170600000509781706000005097853PA7951762025-12-15False
17060000051033L17/dossiers17170600000509781706000005097854PA7956642025-12-15False
17060000051034L17/dossiers17170600000509781706000005097855PA8172032025-12-15False
17060000051035L17/dossiers17170600000509781706000005097856PA7948102025-12-15False
17060000051036L17/dossiers17170600000509781706000005097857PA7957222025-12-15False
17060000051037L17/dossiers17170600000509781706000005097858PA7212342025-12-15False
17060000051038L17/dossiers17170600000509781706000005097859PA7218442025-12-15False
17060000051039L17/dossiers17170600000509781706000005097860PA7219162025-12-15False
17060000051040L17/dossiers17170600000509781706000005097861PA7214262025-12-15False
17060000051041L17/dossiers17170600000509781706000005097862PA7955282025-12-15False
17060000051042L17/dossiers17170600000509781706000005097863PA7932702025-12-15False
17060000051043L17/dossiers17170600000509781706000005097864PA7201382025-12-15False
17060000051044L17/dossiers17170600000509781706000005097865PA7572252025-12-15False
17060000051045L17/dossiers17170600000509781706000005097866PA7201902025-12-15False
17060000051046L17/dossiers17170600000509781706000005097867PA7944862025-12-15False
17060000051047L17/dossiers17170600000509781706000005097868PA7195502025-12-15False
17060000051048L17/dossiers17170600000509781706000005097869PA7937962025-12-15False
17060000051049L17/dossiers17170600000509781706000005097870PA7221022025-12-15False
17060000051050L17/dossiers17170600000509781706000005097871PA7195122025-12-15False
17060000051051L17/dossiers17170600000509781706000005097872PA7931942025-12-15False
17060000051052L17/dossiers17170600000509781706000005097873PA7953262025-12-15False
17060000051053L17/dossiers17170600000509781706000005097874PA29602025-12-15False
17060000051054L17/dossiers17170600000509781706000005097875PA7950462025-12-15False
17060000051058L17/dossiers1717060000051056170600000510561PA7221902025-12-24False
17060000051059L17/dossiers1717060000051056170600000510562PA7211582025-12-24False
17060000051060L17/dossiers1717060000051056170600000510563PA7951442025-12-24False
17060000051061L17/dossiers1717060000051056170600000510564PA6429352025-12-24False
17060000051062L17/dossiers1717060000051056170600000510565PA7192182025-12-24False
17060000051063L17/dossiers1717060000051056170600000510566PA7171612025-12-24False
17060000051064L17/dossiers1717060000051056170600000510567PA6065072025-12-24False
17060000051065L17/dossiers1717060000051056170600000510568PA7943302025-12-24False
17060000051066L17/dossiers1717060000051056170600000510569PA7198902025-12-24False
17060000051067L17/dossiers17170600000510561706000005105610PA7220002025-12-24False
17060000051068L17/dossiers17170600000510561706000005105611PA7947982025-12-24False
17060000051069L17/dossiers17170600000510561706000005105612PA7217502025-12-24False
17060000051070L17/dossiers17170600000510561706000005105613PA8423112025-12-24False
17060000051071L17/dossiers17170600000510561706000005105614PA7199222025-12-24False
17060000051072L17/dossiers17170600000510561706000005105615PA7939402025-12-24False
17060000051073L17/dossiers17170600000510561706000005105616PA7194722025-12-24False
17060000051074L17/dossiers17170600000510561706000005105617PA7958642025-12-24False
17060000051075L17/dossiers17170600000510561706000005105618PA7959082025-12-24False
17060000051076L17/dossiers17170600000510561706000005105619PA7954022025-12-24False
17060000051077L17/dossiers17170600000510561706000005105620PA7191182025-12-24False
17060000051078L17/dossiers17170600000510561706000005105621PA7949822025-12-24False
17060000051079L17/dossiers17170600000510561706000005105622PA7223822025-12-24False
17060000051080L17/dossiers17170600000510561706000005105623PA7201542025-12-24False