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
17060000020426L17/dossiers171706000002032117060000020321104PA7937962024-12-16False
17060000020427L17/dossiers171706000002032117060000020321105PA7211102024-12-16False
17060000020428L17/dossiers171706000002032117060000020321106PA7214862024-12-16False
17060000020429L17/dossiers171706000002032117060000020321107PA7214742024-12-16False
17060000020430L17/dossiers171706000002032117060000020321108PA2670422024-12-16False
17060000020431L17/dossiers171706000002032117060000020321109PA8408172024-12-16False
17060000020432L17/dossiers171706000002032117060000020321110PA8413592024-12-16False
17060000020433L17/dossiers171706000002032117060000020321111PA7932102024-12-16False
17060000020434L17/dossiers171706000002032117060000020321112PA2677632024-12-16False
17060000020438L17/dossiers1717060000020436170600000204361PA7214102025-02-17False
17060000020439L17/dossiers1717060000020436170600000204362PA3309092025-02-17False
17060000020440L17/dossiers1717060000020436170600000204363PA8421172025-02-17False
17060000020441L17/dossiers1717060000020436170600000204364PA3467822025-02-17False
17060000020442L17/dossiers1717060000020436170600000204365PA7192722025-02-17False
17060000020443L17/dossiers1717060000020436170600000204366PA2668082025-02-17False
17060000020444L17/dossiers1717060000020436170600000204367PA7188842025-02-17False
17060000020445L17/dossiers1717060000020436170600000204368PA8409792025-02-17False
17060000020446L17/dossiers1717060000020436170600000204369PA7935082025-02-17False
17060000020447L17/dossiers17170600000204361706000002043610PA7188382025-02-17False
17060000020448L17/dossiers17170600000204361706000002043611PA6080162025-02-17False
17060000020449L17/dossiers17170600000204361706000002043612PA7930942025-02-17False
17060000020450L17/dossiers17170600000204361706000002043613PA7187842025-02-17False
17060000020451L17/dossiers17170600000204361706000002043614PA7218162025-02-17False
17060000020452L17/dossiers17170600000204361706000002043615PA2667932025-02-17False
17060000020453L17/dossiers17170600000204361706000002043616PA7214422025-02-17False
17060000020454L17/dossiers17170600000204361706000002043617PA7199682025-02-17False
17060000020455L17/dossiers17170600000204361706000002043618PA3325232024-12-032025-02-17False
17060000020456L17/dossiers17170600000204361706000002043619PA7940382025-02-17False
17060000020460L17/dossiers1717060000020458170600000204581PA6109682024-12-03False
17060000020461L17/dossiers1717060000020458170600000204582PA7937802024-12-03False
17060000020462L17/dossiers1717060000020458170600000204583PA5888842024-12-03False
17060000020463L17/dossiers1717060000020458170600000204584PA8417012024-12-03False
17060000020464L17/dossiers1717060000020458170600000204585PA3359992024-12-03False
17060000020465L17/dossiers1717060000020458170600000204586PA7953622024-12-03False
17060000020466L17/dossiers1717060000020458170600000204587PA8409972024-12-03False
17060000020467L17/dossiers1717060000020458170600000204588PA7940082024-12-03False
17060000020468L17/dossiers1717060000020458170600000204589PA7212102024-12-03False
17060000020469L17/dossiers17170600000204581706000002045810PA7934522024-12-03False
17060000020470L17/dossiers17170600000204581706000002045811PA8413512024-12-03False
17060000020471L17/dossiers17170600000204581706000002045812PA7939802024-12-03False
17060000020472L17/dossiers17170600000204581706000002045813PA7950102024-12-03False
17060000020473L17/dossiers17170600000204581706000002045814PA8414192024-12-03False
17060000020474L17/dossiers17170600000204581706000002045815PA8420132024-12-03False
17060000020475L17/dossiers17170600000204581706000002045816PA8409472024-12-03False
17060000020476L17/dossiers17170600000204581706000002045817PA7941462024-12-03False
17060000020477L17/dossiers17170600000204581706000002045818PA8412232024-12-03False
17060000020478L17/dossiers17170600000204581706000002045819PA8420452024-12-03False
17060000020479L17/dossiers17170600000204581706000002045820PA7937082024-12-03False
17060000020480L17/dossiers17170600000204581706000002045821PA7936642024-12-03False
17060000020481L17/dossiers17170600000204581706000002045822PA7941542024-12-03False