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 151 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
17060000004233L17/dossiers17170600000042001706000000420032PA7215302021-10-19False
17060000004234L17/dossiers17170600000042001706000000420033PA7209762021-10-19False
17060000004235L17/dossiers17170600000042001706000000420034PA7207282021-10-19False
17060000004236L17/dossiers17170600000042001706000000420035PA7196402021-10-19False
17060000004237L17/dossiers17170600000042001706000000420036PA7217342021-10-19False
17060000004238L17/dossiers17170600000042001706000000420037PA7214182021-10-19False
17060000004239L17/dossiers17170600000042001706000000420038PA7203342021-10-19False
17060000004240L17/dossiers17170600000042001706000000420039PA7211822021-10-19False
17060000004241L17/dossiers17170600000042001706000000420040PA7212342021-10-19False
17060000004242L17/dossiers17170600000042001706000000420041PA7207202021-10-19False
17060000004243L17/dossiers17170600000042001706000000420042PA4054802021-10-19False
17060000004244L17/dossiers17170600000042001706000000420043PA7200922021-10-19False
17060000004245L17/dossiers17170600000042001706000000420044PA7198222021-10-19False
17060000004246L17/dossiers17170600000042001706000000420045PA7221622021-10-19False
17060000004247L17/dossiers17170600000042001706000000420046PA7219242021-10-19False
17060000004248L17/dossiers17170600000042001706000000420047PA3315822021-10-19False
17060000004249L17/dossiers17170600000042001706000000420048PA7207462021-10-19False
17060000004253L17/dossiers1717060000004251170600000042511PA21502021-11-03False
17060000004254L17/dossiers1717060000004251170600000042512PA7208922021-11-03False
17060000004255L17/dossiers1717060000004251170600000042513PA7212102021-11-03False
17060000004256L17/dossiers1717060000004251170600000042514PA5888842021-11-03False
17060000004257L17/dossiers1717060000004251170600000042515PA7204302021-11-03False
17060000004258L17/dossiers1717060000004251170600000042516PA7212022021-11-03False
17060000004259L17/dossiers1717060000004251170600000042517PA7202862021-11-03False
17060000004260L17/dossiers1717060000004251170600000042518PA7188682021-11-03False
17060000004261L17/dossiers1717060000004251170600000042519PA7219602021-11-03False
17060000004262L17/dossiers17170600000042511706000000425110PA7195782021-11-03False
17060000004263L17/dossiers17170600000042511706000000425111PA7204222021-11-03False
17060000004264L17/dossiers17170600000042511706000000425112PA7210622021-11-03False
17060000004265L17/dossiers17170600000042511706000000425113PA7196762021-11-03False
17060000004266L17/dossiers17170600000042511706000000425114PA7212262021-11-03False
17060000004267L17/dossiers17170600000042511706000000425115PA7221422021-11-03False
17060000004268L17/dossiers17170600000042511706000000425116PA7188602021-11-03False
17060000004269L17/dossiers17170600000042511706000000425117PA7194482021-12-06False
17060000004270L17/dossiers17170600000042511706000000425118PA3356122021-12-06False
17060000004271L17/dossiers17170600000042511706000000425119PA7211182021-12-06False
17060000004272L17/dossiers17170600000042511706000000425120PA6055182021-12-06False
17060000004273L17/dossiers17170600000042511706000000425121PA7200922021-12-06False
17060000004274L17/dossiers17170600000042511706000000425122PA6056942021-12-06False
17060000004275L17/dossiers17170600000042511706000000425123PA6428682021-12-10False
17060000004276L17/dossiers17170600000042511706000000425124PA3403572021-12-10False
17060000004277L17/dossiers17170600000042511706000000425125PA3424152021-12-10False
17060000004278L17/dossiers17170600000042511706000000425126PA3326142021-12-10False
17060000004279L17/dossiers17170600000042511706000000425127PA6087412021-12-10False
17060000004280L17/dossiers17170600000042511706000000425128PA7205462021-12-14False
17060000004281L17/dossiers17170600000042511706000000425129PA7222022021-12-14False
17060000004282L17/dossiers17170600000042511706000000425130PA7194642021-12-14False
17060000004283L17/dossiers17170600000042511706000000425131PA7749602021-12-14False
17060000004284L17/dossiers17170600000042511706000000425132PA3364392021-12-14False
17060000004285L17/dossiers17170600000042511706000000425133PA7187442021-12-14False