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
17060000040019L17/dossiers17170600000400061706000004000612PA7749622025-09-24False
17060000040020L17/dossiers17170600000400061706000004000613PA3356122025-09-24False
17060000040021L17/dossiers17170600000400061706000004000614PA7960102025-09-24False
17060000040022L17/dossiers17170600000400061706000004000615PA8413592025-09-24False
17060000040023L17/dossiers17170600000400061706000004000616PA7936642025-09-24False
17060000040024L17/dossiers17170600000400061706000004000617PA7947782025-09-24False
17060000040025L17/dossiers17170600000400061706000004000618PA7952402025-09-24False
17060000040026L17/dossiers17170600000400061706000004000619PA6065452025-09-24False
17060000040027L17/dossiers17170600000400061706000004000620PA7950762025-09-24False
17060000040028L17/dossiers17170600000400061706000004000621PA6100022025-09-24False
17060000040029L17/dossiers17170600000400061706000004000622PA8417132025-09-24False
17060000040030L17/dossiers17170600000400061706000004000623PA29402025-09-24False
17060000040037L17/dossiers1717060000040035170600000400351PA7960422025-06-24False
17060000040038L17/dossiers1717060000040035170600000400352PA8401192025-06-24False
17060000040039L17/dossiers1717060000040035170600000400353PA7959002025-06-24False
17060000040040L17/dossiers1717060000040035170600000400354PA8417492025-06-24False
17060000040041L17/dossiers1717060000040035170600000400355PA7932302025-06-24False
17060000040042L17/dossiers1717060000040035170600000400356PA8419812025-06-24False
17060000040043L17/dossiers1717060000040035170600000400357PA7954102025-06-24False
17060000040047L17/dossiers1717060000040045170600000400451PA8410672025-06-24False
17060000040048L17/dossiers1717060000040045170600000400452PA8412072025-06-24False
17060000040049L17/dossiers1717060000040045170600000400453PA2675612025-06-24False
17060000040050L17/dossiers1717060000040045170600000400454PA8408892025-06-24False
17060000040051L17/dossiers1717060000040045170600000400455PA8407012025-06-24False
17060000040052L17/dossiers1717060000040045170600000400456PA8407212025-06-24False
17060000040053L17/dossiers1717060000040045170600000400457PA7933222025-06-24False
17060000040054L17/dossiers1717060000040045170600000400458PA8407732025-06-24False
17060000040055L17/dossiers1717060000040045170600000400459PA8409832025-06-24False
17060000040056L17/dossiers17170600000400451706000004004510PA8413952025-06-24False
17060000040057L17/dossiers17170600000400451706000004004511PA8417692025-06-24False
17060000040058L17/dossiers17170600000400451706000004004512PA8406852025-06-24False
17060000040062L17/dossiers1717060000040060170600000400601PA8408292025-06-24False
17060000040063L17/dossiers1717060000040060170600000400602PA8422112025-06-24False
17060000040064L17/dossiers1717060000040060170600000400603PA7940942025-06-24False
17060000040065L17/dossiers1717060000040060170600000400604PA8412952025-06-24False
17060000040066L17/dossiers1717060000040060170600000400605PA10082025-06-24False
17060000040067L17/dossiers1717060000040060170600000400606PA6065732025-06-24False
17060000040068L17/dossiers1717060000040060170600000400607PA6056942025-06-24False
17060000040069L17/dossiers1717060000040060170600000400608PA8416652025-06-24False
17060000040070L17/dossiers1717060000040060170600000400609PA3319732025-06-24False
17060000040071L17/dossiers17170600000400601706000004006010PA8401712025-06-24False
17060000040072L17/dossiers17170600000400601706000004006011PA7221502025-06-24False
17060000040073L17/dossiers17170600000400601706000004006012PA8407652025-06-24False
17060000040074L17/dossiers17170600000400601706000004006013PA8414632025-06-24False
17060000040075L17/dossiers17170600000400601706000004006014PA8411072025-06-24False
17060000040076L17/dossiers17170600000400601706000004006015PA8413592025-06-24False
17060000040077L17/dossiers17170600000400601706000004006016PA6081722025-06-24False
17060000040078L17/dossiers17170600000400601706000004006017PA3421962025-06-24False
17060000040079L17/dossiers17170600000400601706000004006018PA8416812025-06-24False
17060000040083L17/dossiers1717060000040081170600000400811PA6428682025-06-24False