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
17060000032244L17/dossiers17170600000321791706000003217964PA8414392025-05-05False
17060000032245L17/dossiers17170600000321791706000003217965PA7940302025-05-05False
17060000032246L17/dossiers17170600000321791706000003217966PA8417492025-05-05False
17060000032247L17/dossiers17170600000321791706000003217967PA8410752025-05-05False
17060000032248L17/dossiers17170600000321791706000003217968PA8408692025-05-05False
17060000032249L17/dossiers17170600000321791706000003217969PA7943542025-05-05False
17060000032250L17/dossiers17170600000321791706000003217970PA7959122025-05-05False
17060000032251L17/dossiers17170600000321791706000003217971PA8418372025-05-05False
17060000032252L17/dossiers17170600000321791706000003217972PA8408572025-05-05False
17060000032253L17/dossiers17170600000321791706000003217973PA7932902025-05-05False
17060000032254L17/dossiers17170600000321791706000003217974PA8409832025-05-05False
17060000032255L17/dossiers17170600000321791706000003217975PA7952442025-05-05False
17060000032256L17/dossiers17170600000321791706000003217976PA6429882025-05-05False
17060000032257L17/dossiers17170600000321791706000003217977PA7936082025-05-05False
17060000032258L17/dossiers17170600000321791706000003217978PA8418732025-05-05False
17060000032259L17/dossiers17170600000321791706000003217979PA8409672025-05-05False
17060000032260L17/dossiers17170600000321791706000003217980PA7936722025-05-05False
17060000032261L17/dossiers17170600000321791706000003217981PA7939042025-05-05False
17060000032262L17/dossiers17170600000321791706000003217982PA7219322025-05-05False
17060000032263L17/dossiers17170600000321791706000003217983PA7959742025-05-05False
17060000032264L17/dossiers17170600000321791706000003217984PA8415872025-05-05False
17060000032265L17/dossiers17170600000321791706000003217985PA8411832025-05-05False
17060000032266L17/dossiers17170600000321791706000003217986PA8415632025-05-05False
17060000032267L17/dossiers17170600000321791706000003217987PA7945302025-05-05False
17060000032268L17/dossiers17170600000321791706000003217988PA8408372025-05-05False
17060000032269L17/dossiers17170600000321791706000003217989PA8418252025-05-05False
17060000032270L17/dossiers17170600000321791706000003217990PA7947702025-05-05False
17060000032271L17/dossiers17170600000321791706000003217991PA7933142025-05-05False
17060000032272L17/dossiers17170600000321791706000003217992PA7933302025-05-05False
17060000032273L17/dossiers17170600000321791706000003217993PA7936162025-05-05False
17060000032274L17/dossiers17170600000321791706000003217994PA7194362025-05-05False
17060000032275L17/dossiers17170600000321791706000003217995PA7933542025-05-05False
17060000032276L17/dossiers17170600000321791706000003217996PA7957862025-05-05False
17060000032277L17/dossiers17170600000321791706000003217997PA7943222025-05-05False
17060000032278L17/dossiers17170600000321791706000003217998PA7938522025-05-05False
17060000032279L17/dossiers17170600000321791706000003217999PA8413952025-05-05False
17060000032280L17/dossiers171706000003217917060000032179100PA8417692025-05-05False
17060000032281L17/dossiers171706000003217917060000032179101PA8409152025-05-05False
17060000032282L17/dossiers171706000003217917060000032179102PA7936962025-05-05False
17060000032283L17/dossiers171706000003217917060000032179103PA7955522025-05-05False
17060000032284L17/dossiers171706000003217917060000032179104PA7946702025-05-05False
17060000032285L17/dossiers171706000003217917060000032179105PA8411992025-05-05False
17060000032286L17/dossiers171706000003217917060000032179106PA7945822025-05-05False
17060000032287L17/dossiers171706000003217917060000032179107PA7936562025-05-05False
17060000032288L17/dossiers171706000003217917060000032179108PA7959662025-05-05False
17060000032289L17/dossiers171706000003217917060000032179109PA7932302025-05-05False
17060000032290L17/dossiers171706000003217917060000032179110PA7932542025-05-05False
17060000032291L17/dossiers171706000003217917060000032179111PA8406572025-05-05False
17060000032292L17/dossiers171706000003217917060000032179112PA8422272025-05-05False
17060000032293L17/dossiers171706000003217917060000032179113PA7944422025-05-05False