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
17060000027661L17/dossiers171706000002756017060000027560100PA7944942025-03-20False
17060000027662L17/dossiers171706000002756017060000027560101PA7209922025-03-20False
17060000027666L17/dossiers1717060000027664170600000276641PA6060982025-03-05False
17060000027667L17/dossiers1717060000027664170600000276642PA6088262025-03-05False
17060000027668L17/dossiers1717060000027664170600000276643PA7930942025-03-05False
17060000027669L17/dossiers1717060000027664170600000276644PA7947502025-03-05False
17060000027670L17/dossiers1717060000027664170600000276645PA6084162025-03-05False
17060000027671L17/dossiers1717060000027664170600000276646PA7949942025-03-05False
17060000027672L17/dossiers1717060000027664170600000276647PA6428472025-03-05False
17060000027673L17/dossiers1717060000027664170600000276648PA3422402025-03-05False
17060000027674L17/dossiers1717060000027664170600000276649PA7941782025-03-05False
17060000027675L17/dossiers17170600000276641706000002766410PA8421172025-03-05False
17060000027676L17/dossiers17170600000276641706000002766411PA8409792025-03-05False
17060000027677L17/dossiers17170600000276641706000002766412PA7188382025-03-05False
17060000027681L17/dossiers1717060000027679170600000276791PA8401352025-02-18False
17060000027682L17/dossiers1717060000027679170600000276792PA7947342025-02-18False
17060000027683L17/dossiers1717060000027679170600000276793PA8415632025-02-18False
17060000027684L17/dossiers1717060000027679170600000276794PA7933142025-02-18False
17060000027685L17/dossiers1717060000027679170600000276795PA6429882025-02-18False
17060000027686L17/dossiers1717060000027679170600000276796PA8409152025-02-18False
17060000027687L17/dossiers1717060000027679170600000276797PA7945822025-02-18False
17060000027688L17/dossiers1717060000027679170600000276798PA7204682025-02-18False
17060000027689L17/dossiers1717060000027679170600000276799PA8408372025-02-18False
17060000027690L17/dossiers17170600000276791706000002767910PA7936162025-02-18False
17060000027691L17/dossiers17170600000276791706000002767911PA7940302025-02-18False
17060000027692L17/dossiers17170600000276791706000002767912PA7932902025-02-18False
17060000027693L17/dossiers17170600000276791706000002767913PA8419812025-02-18False
17060000027694L17/dossiers17170600000276791706000002767914PA8414512025-02-18False
17060000027695L17/dossiers17170600000276791706000002767915PA8410752025-02-18False
17060000027696L17/dossiers17170600000276791706000002767916PA7936082025-02-18False
17060000027697L17/dossiers17170600000276791706000002767917PA7938922025-02-18False
17060000027698L17/dossiers17170600000276791706000002767918PA7939042025-02-18False
17060000027699L17/dossiers17170600000276791706000002767919PA7959742025-02-18False
17060000027700L17/dossiers17170600000276791706000002767920PA7931342025-02-18False
17060000027701L17/dossiers17170600000276791706000002767921PA8420732025-02-18False
17060000027702L17/dossiers17170600000276791706000002767922PA8414792025-02-18False
17060000027703L17/dossiers17170600000276791706000002767923PA7932462025-02-18False
17060000027704L17/dossiers17170600000276791706000002767924PA7960262025-02-18False
17060000027705L17/dossiers17170600000276791706000002767925PA7932182025-02-18False
17060000027706L17/dossiers17170600000276791706000002767926PA7956442025-02-18False
17060000027707L17/dossiers17170600000276791706000002767927PA7960342025-02-18False
17060000027708L17/dossiers17170600000276791706000002767928PA7947702025-02-18False
17060000027709L17/dossiers17170600000276791706000002767929PA8417372025-02-18False
17060000027710L17/dossiers17170600000276791706000002767930PA7194362025-02-18False
17060000027711L17/dossiers17170600000276791706000002767931PA8422272025-02-18False
17060000027712L17/dossiers17170600000276791706000002767932PA7931582025-02-18False
17060000027713L17/dossiers17170600000276791706000002767933PA7944182025-02-18False
17060000027714L17/dossiers17170600000276791706000002767934PA7959662025-02-18False
17060000027715L17/dossiers17170600000276791706000002767935PA7961182025-02-18False
17060000027716L17/dossiers17170600000276791706000002767936PA7206682025-02-18False