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
17060000038033L17/dossiers17170600000380091706000003800923PA15672025-06-16False
17060000038034L17/dossiers17170600000380091706000003800924PA8414712025-06-16False
17060000038035L17/dossiers17170600000380091706000003800925PA8422632025-06-16False
17060000038036L17/dossiers17170600000380091706000003800926PA8418132025-06-16False
17060000038037L17/dossiers17170600000380091706000003800927PA6431922025-06-16False
17060000038038L17/dossiers17170600000380091706000003800928PA3350542025-06-16False
17060000038039L17/dossiers17170600000380091706000003800929PA7951562025-06-16False
17060000038040L17/dossiers17170600000380091706000003800930PA7749582025-06-16False
17060000038041L17/dossiers17170600000380091706000003800931PA8407652025-06-16False
17060000038042L17/dossiers17170600000380091706000003800932PA8414632025-06-16False
17060000038043L17/dossiers17170600000380091706000003800933PA8411072025-06-16False
17060000038044L17/dossiers17170600000380091706000003800934PA8407932025-06-16False
17060000038045L17/dossiers17170600000380091706000003800935PA7942702025-06-16False
17060000038046L17/dossiers17170600000380091706000003800936PA6081722025-06-16False
17060000038047L17/dossiers17170600000380091706000003800937PA6075532025-06-16False
17060000038048L17/dossiers17170600000380091706000003800938PA8409552025-06-16False
17060000038049L17/dossiers17170600000380091706000003800939PA8413672025-06-16False
17060000038050L17/dossiers17170600000380091706000003800940PA3419812025-06-16False
17060000038051L17/dossiers17170600000380091706000003800941PA3421962025-06-16False
17060000038052L17/dossiers17170600000380091706000003800942PA8266352025-06-16False
17060000038053L17/dossiers17170600000380091706000003800943PA8413272025-06-16False
17060000038054L17/dossiers17170600000380091706000003800944PA8417172025-06-16False
17060000038055L17/dossiers17170600000380091706000003800945PA8412432025-06-16False
17060000038056L17/dossiers17170600000380091706000003800946PA7749602025-06-16False
17060000038057L17/dossiers17170600000380091706000003800947PA3403432025-06-16False
17060000038058L17/dossiers17170600000380091706000003800948PA8410912025-06-16False
17060000038059L17/dossiers17170600000380091706000003800949PA8416812025-06-16False
17060000038060L17/dossiers17170600000380091706000003800950PA8418932025-06-16False
17060000038061L17/dossiers17170600000380091706000003800951PA7938162025-06-16False
17060000038062L17/dossiers17170600000380091706000003800952PA7944942025-06-16False
17060000038066L17/dossiers1717060000038064170600000380641PA7947342025-09-04False
17060000038067L17/dossiers1717060000038064170600000380642PA7931342025-09-04False
17060000038068L17/dossiers1717060000038064170600000380643PA7932182025-09-04False
17060000038069L17/dossiers1717060000038064170600000380644PA8416132025-09-04False
17060000038070L17/dossiers1717060000038064170600000380645PA3096432025-09-04False
17060000038071L17/dossiers1717060000038064170600000380646PA8414872025-09-04False
17060000038072L17/dossiers1717060000038064170600000380647PA7932902025-09-04False
17060000038073L17/dossiers1717060000038064170600000380648PA8407812025-09-04False
17060000038074L17/dossiers1717060000038064170600000380649PA7219322025-09-04False
17060000038075L17/dossiers17170600000380641706000003806410PA8418252025-09-04False
17060000038076L17/dossiers17170600000380641706000003806411PA7194362025-09-04False
17060000038077L17/dossiers17170600000380641706000003806412PA7957862025-09-04False
17060000038078L17/dossiers17170600000380641706000003806413PA7936962025-09-04False
17060000038079L17/dossiers17170600000380641706000003806414PA7955522025-09-04False
17060000038080L17/dossiers17170600000380641706000003806415PA8420972025-09-04False
17060000038081L17/dossiers17170600000380641706000003806416PA8407012025-09-04False
17060000038082L17/dossiers17170600000380641706000003806417PA7935922025-09-04False
17060000038083L17/dossiers17170600000380641706000003806418PA8418732025-09-04False
17060000038084L17/dossiers17170600000380641706000003806419PA7204682025-09-04False
17060000038085L17/dossiers17170600000380641706000003806420PA7960342025-09-04False