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
17060000026000L17/dossiers17170600000259771706000002597722PA7933982025-02-04False
17060000026001L17/dossiers17170600000259771706000002597723PA7218442025-02-04False
17060000026002L17/dossiers17170600000259771706000002597724PA7935722025-02-04False
17060000026003L17/dossiers17170600000259771706000002597725PA7195282025-02-04False
17060000026004L17/dossiers17170600000259771706000002597726PA7952702025-02-04False
17060000026005L17/dossiers17170600000259771706000002597727PA7205522025-02-04False
17060000026006L17/dossiers17170600000259771706000002597728PA7214582025-02-04False
17060000026007L17/dossiers17170600000259771706000002597729PA7201382025-02-04False
17060000026008L17/dossiers17170600000259771706000002597730PA7223362025-02-04False
17060000026009L17/dossiers17170600000259771706000002597731PA7953502025-02-04False
17060000026010L17/dossiers17170600000259771706000002597732PA7950262025-02-04False
17060000026021L17/dossiers1717060000026018170600000260181PA6065072025-02-06False
17060000026028L17/dossiers1717060000026026170600000260261PA7961062025-02-07False
17060000026029L17/dossiers1717060000026026170600000260262PA7208382025-02-07False
17060000026030L17/dossiers1717060000026026170600000260263PA7958682025-02-07False
17060000026031L17/dossiers1717060000026026170600000260264PA2673062025-02-07False
17060000026032L17/dossiers1717060000026026170600000260265PA7218962025-02-07False
17060000026033L17/dossiers1717060000026026170600000260266PA7959982025-02-07False
17060000026034L17/dossiers1717060000026026170600000260267PA7749622025-02-07False
17060000026035L17/dossiers1717060000026026170600000260268PA3356122025-02-07False
17060000026036L17/dossiers1717060000026026170600000260269PA7960102025-02-07False
17060000026037L17/dossiers17170600000260261706000002602610PA7931742025-02-07False
17060000026038L17/dossiers17170600000260261706000002602611PA7958202025-02-07False
17060000026039L17/dossiers17170600000260261706000002602612PA7952402025-02-07False
17060000026040L17/dossiers17170600000260261706000002602613PA7958762025-02-07False
17060000026041L17/dossiers17170600000260261706000002602614PA6057452025-02-07False
17060000026042L17/dossiers17170600000260261706000002602615PA8422992025-02-07False
17060000026046L17/dossiers1717060000026044170600000260441PA7932542025-02-13False
17060000026050L17/dossiers1717060000026048170600000260481PA7930942025-02-26False
17060000026051L17/dossiers1717060000026048170600000260482PA7212342025-02-26False
17060000026052L17/dossiers1717060000026048170600000260483PA8421172025-02-26False
17060000026053L17/dossiers1717060000026048170600000260484PA7935722025-02-26False
17060000026054L17/dossiers1717060000026048170600000260485PA7223902025-02-26False
17060000026055L17/dossiers1717060000026048170600000260486PA7946582025-02-26False
17060000026056L17/dossiers1717060000026048170600000260487PA7941782025-02-26False
17060000026057L17/dossiers1717060000026048170600000260488PA7205602025-02-26False
17060000026058L17/dossiers1717060000026048170600000260489PA8413592025-02-26False
17060000026059L17/dossiers17170600000260481706000002604810PA7940422025-02-26False
17060000026060L17/dossiers17170600000260481706000002604811PA2677632025-02-26False
17060000026061L17/dossiers17170600000260481706000002604812PA8408172025-02-26False
17060000026062L17/dossiers17170600000260481706000002604813PA7221022025-02-26False
17060000026063L17/dossiers17170600000260481706000002604814PA7931222025-02-26False
17060000026064L17/dossiers17170600000260481706000002604815PA3096432025-02-26False
17060000026065L17/dossiers17170600000260481706000002604816PA6088262025-02-26False
17060000026066L17/dossiers17170600000260481706000002604817PA7192722025-02-26False
17060000026067L17/dossiers17170600000260481706000002604818PA7952402025-02-26False
17060000026068L17/dossiers17170600000260481706000002604819PA3422402025-02-26False
17060000026069L17/dossiers17170600000260481706000002604820PA8419312025-02-26False
17060000026070L17/dossiers17170600000260481706000002604821PA7203542025-02-26False
17060000026071L17/dossiers17170600000260481706000002604822PA7949822025-02-26False