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
17060000022090L17/dossiers17170600000220701706000002207019PA7957862025-06-25False
17060000022091L17/dossiers17170600000220701706000002207020PA7943222025-06-25False
17060000022092L17/dossiers17170600000220701706000002207021PA8409152025-06-25False
17060000022093L17/dossiers17170600000220701706000002207022PA7936962025-06-25False
17060000022094L17/dossiers17170600000220701706000002207023PA7945822025-06-25False
17060000022095L17/dossiers17170600000220701706000002207024PA8422272025-06-25False
17060000022096L17/dossiers17170600000220701706000002207025PA7944422025-06-25False
17060000022097L17/dossiers17170600000220701706000002207026PA7949542025-06-25False
17060000022098L17/dossiers17170600000220701706000002207027PA8422552025-06-25False
17060000022102L17/dossiers1717060000022100170600000221001PA7192862025-03-24False
17060000022103L17/dossiers1717060000022100170600000221002PA7191382025-03-24False
17060000022104L17/dossiers1717060000022100170600000221003PA3467822025-03-24False
17060000022105L17/dossiers1717060000022100170600000221004PA6057822025-03-24False
17060000022106L17/dossiers1717060000022100170600000221005PA7201542025-03-24False
17060000022107L17/dossiers1717060000022100170600000221006PA8417452025-03-24False
17060000022108L17/dossiers1717060000022100170600000221007PA6428472025-03-24False
17060000022109L17/dossiers1717060000022100170600000221008PA7218162025-03-24False
17060000022110L17/dossiers1717060000022100170600000221009PA3422402025-03-24False
17060000022111L17/dossiers17170600000221001706000002210010PA7188382025-03-24False
17060000022112L17/dossiers17170600000221001706000002210011PA3325232024-12-232025-02-17False
17060000022113L17/dossiers17170600000221001706000002210012PA6088262025-03-24False
17060000022114L17/dossiers17170600000221001706000002210013PA16302025-03-24False
17060000022115L17/dossiers17170600000221001706000002210014PA8421172025-03-24False
17060000022116L17/dossiers17170600000221001706000002210015PA8409792025-03-24False
17060000022117L17/dossiers17170600000221001706000002210016PA7933422025-03-24False
17060000022118L17/dossiers17170600000221001706000002210017PA7940382025-03-24False
17060000022119L17/dossiers17170600000221001706000002210018PA7206442025-03-24False
17060000022120L17/dossiers17170600000221001706000002210019PA7214422025-03-24False
17060000022121L17/dossiers17170600000221001706000002210020PA7930942025-03-24False
17060000022122L17/dossiers17170600000221001706000002210021PA7935202025-03-24False
17060000022123L17/dossiers17170600000221001706000002210022PA7951242025-03-24False
17060000022124L17/dossiers17170600000221001706000002210023PA7194122025-03-24False
17060000022125L17/dossiers17170600000221001706000002210024PA8414312025-03-24False
17060000022126L17/dossiers17170600000221001706000002210025PA8410672025-03-24False
17060000022127L17/dossiers17170600000221001706000002210026PA8407012025-03-24False
17060000022128L17/dossiers17170600000221001706000002210027PA8408172025-03-24False
17060000022129L17/dossiers17170600000221001706000002210028PA8419312025-03-24False
17060000022130L17/dossiers17170600000221001706000002210029PA7945542025-03-24False
17060000022131L17/dossiers17170600000221001706000002210030PA7934322025-03-24False
17060000022132L17/dossiers17170600000221001706000002210031PA7945022025-03-24False
17060000022133L17/dossiers17170600000221001706000002210032PA8422792025-03-24False
17060000022134L17/dossiers17170600000221001706000002210033PA7938522025-03-24False
17060000022135L17/dossiers17170600000221001706000002210034PA3421962025-03-24False
17060000022136L17/dossiers17170600000221001706000002210035PA8407652025-03-24False
17060000022137L17/dossiers17170600000221001706000002210036PA6081722025-03-24False
17060000022138L17/dossiers17170600000221001706000002210037PA8408292025-03-24False
17060000022139L17/dossiers17170600000221001706000002210038PA8414192025-03-24False
17060000022140L17/dossiers17170600000221001706000002210039PA7952402025-03-24False
17060000022141L17/dossiers17170600000221001706000002210040PA8406732025-03-24False
17060000022142L17/dossiers17170600000221001706000002210041PA7935322025-03-202025-03-24False