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
17060000028277L17/dossiers17170600000282151706000002821561PA8417692025-03-11False
17060000028278L17/dossiers17170600000282151706000002821562PA7931462025-03-11False
17060000028279L17/dossiers17170600000282151706000002821563PA8409672025-03-11False
17060000028280L17/dossiers17170600000282151706000002821564PA7960422025-03-11False
17060000028281L17/dossiers17170600000282151706000002821565PA7938922025-03-11False
17060000028282L17/dossiers17170600000282151706000002821566PA7938522025-03-11False
17060000028283L17/dossiers17170600000282151706000002821567PA8419812025-03-11False
17060000028284L17/dossiers17170600000282151706000002821568PA8400752025-03-11False
17060000028285L17/dossiers17170600000282151706000002821569PA7938322025-03-11False
17060000028286L17/dossiers17170600000282151706000002821570PA7959122025-03-11False
17060000028287L17/dossiers17170600000282151706000002821571PA7943222025-03-11False
17060000028288L17/dossiers17170600000282151706000002821572PA8407812025-03-11False
17060000028289L17/dossiers17170600000282151706000002821573PA7944342025-03-11False
17060000028290L17/dossiers17170600000282151706000002821574PA8417372025-03-11False
17060000028291L17/dossiers17170600000282151706000002821575PA8407572025-03-11False
17060000028292L17/dossiers17170600000282151706000002821576PA8418732025-03-11False
17060000028293L17/dossiers17170600000282151706000002821577PA8415632025-03-11False
17060000028294L17/dossiers17170600000282151706000002821578PA7932382025-03-11False
17060000028295L17/dossiers17170600000282151706000002821579PA7945982025-03-11False
17060000028296L17/dossiers17170600000282151706000002821580PA7949542025-03-11False
17060000028297L17/dossiers17170600000282151706000002821581PA8418372025-03-11False
17060000028298L17/dossiers17170600000282151706000002821582PA6429882025-03-11False
17060000028299L17/dossiers17170600000282151706000002821583PA7947342025-03-11False
17060000028300L17/dossiers17170600000282151706000002821584PA8408012025-03-11False
17060000028301L17/dossiers17170600000282151706000002821585PA7932542025-03-11False
17060000028302L17/dossiers17170600000282151706000002821586PA7944422025-03-11False
17060000028303L17/dossiers17170600000282151706000002821587PA7219322025-03-11False
17060000028304L17/dossiers17170600000282151706000002821588PA8417492025-03-11False
17060000028311L17/dossiers1717060000028309170600000283091PA8410672025-03-11False
17060000028312L17/dossiers1717060000028309170600000283092PA8407012025-03-11False
17060000028313L17/dossiers1717060000028309170600000283093PA8422272025-03-11False
17060000028314L17/dossiers1717060000028309170600000283094PA8417692025-03-11False
17060000028315L17/dossiers1717060000028309170600000283095PA7947342025-03-11False
17060000028316L17/dossiers1717060000028309170600000283096PA8408012025-03-11False
17060000028317L17/dossiers1717060000028309170600000283097PA8407732025-03-11False
17060000028318L17/dossiers1717060000028309170600000283098PA7946782025-03-11False
17060000028319L17/dossiers1717060000028309170600000283099PA7219322025-03-11False
17060000028320L17/dossiers17170600000283091706000002830910PA7933542025-03-11False
17060000028321L17/dossiers17170600000283091706000002830911PA8407212025-03-11False
17060000028322L17/dossiers17170600000283091706000002830912PA8417372025-03-11False
17060000028323L17/dossiers17170600000283091706000002830913PA7945982025-03-11False
17060000028324L17/dossiers17170600000283091706000002830914PA2675612025-03-11False
17060000028325L17/dossiers17170600000283091706000002830915PA8406572025-03-11False
17060000028326L17/dossiers17170600000283091706000002830916PA7932382025-03-11False
17060000028327L17/dossiers17170600000283091706000002830917PA8411992025-03-11False
17060000028337L17/dossiers1717060000028335170600000283351PA7188502025-09-01False
17060000028350L17/dossiers1717060000028348170600000283481PA7952282025-12-19False
17060000028351L17/dossiers1717060000028348170600000283482PA7932622025-12-19False
17060000028352L17/dossiers1717060000028348170600000283483PA7949062025-12-19False
17060000028353L17/dossiers1717060000028348170600000283484PA7941382025-12-19False