Aller au contenu
blackout

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

309 756 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 26 %, 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
16060000016554L16/dossiers16160600000165361606000001653617PA7939482023-01-17False
16060000016564L16/dossiers1616060000016562160600000165621PA7952442023-01-17False
16060000016565L16/dossiers1616060000016562160600000165622PA7946262023-01-17False
16060000016566L16/dossiers1616060000016562160600000165623PA2673182023-01-17False
16060000016567L16/dossiers1616060000016562160600000165624PA6056942023-01-17False
16060000016568L16/dossiers1616060000016562160600000165625PA7208382023-01-17False
16060000016569L16/dossiers1616060000016562160600000165626PA2667882023-01-17False
16060000016570L16/dossiers1616060000016562160600000165627PA2677662023-01-17False
16060000016571L16/dossiers1616060000016562160600000165628PA7930942023-01-17False
16060000016572L16/dossiers1616060000016562160600000165629PA6050362023-01-17False
16060000016573L16/dossiers16160600000165621606000001656210PA7214262023-01-17False
16060000016574L16/dossiers16160600000165621606000001656211PA7215222023-01-17False
16060000016575L16/dossiers16160600000165621606000001656212PA3457222023-01-17False
16060000016576L16/dossiers16160600000165621606000001656213PA9422023-01-17False
16060000016577L16/dossiers16160600000165621606000001656214PA7209762023-01-17False
16060000016578L16/dossiers16160600000165621606000001656215PA7214862023-01-17False
16060000016579L16/dossiers16160600000165621606000001656216PA3334212023-01-17False
16060000016580L16/dossiers16160600000165621606000001656217PA7218162023-01-17False
16060000016581L16/dossiers16160600000165621606000001656218PA3300082023-01-17False
16060000016582L16/dossiers16160600000165621606000001656219PA7948302023-01-17False
16060000016583L16/dossiers16160600000165621606000001656220PA2673242023-01-17False
16060000016584L16/dossiers16160600000165621606000001656221PA13272023-01-17False
16060000016585L16/dossiers16160600000165621606000001656222PA7214422023-01-17False
16060000016586L16/dossiers16160600000165621606000001656223PA7200542023-01-17False
16060000016587L16/dossiers16160600000165621606000001656224PA7948382023-01-17False
16060000016588L16/dossiers16160600000165621606000001656225PA7937962023-01-17False
16060000016589L16/dossiers16160600000165621606000001656226PA7944862023-01-17False
16060000016590L16/dossiers16160600000165621606000001656227PA7210462023-01-17False
16060000016594L16/dossiers1616060000016592160600000165921PA7952282023-01-17False
16060000016595L16/dossiers1616060000016592160600000165922PA7937722023-01-17False
16060000016596L16/dossiers1616060000016592160600000165923PA7934442023-01-17False
16060000016597L16/dossiers1616060000016592160600000165924PA7918122023-01-17False
16060000016598L16/dossiers1616060000016592160600000165925PA7951362023-01-17False
16060000016599L16/dossiers1616060000016592160600000165926PA7948702023-01-17False
16060000016600L16/dossiers1616060000016592160600000165927PA7953102023-01-17False
16060000016601L16/dossiers1616060000016592160600000165928PA7951562023-01-17False
16060000016602L16/dossiers1616060000016592160600000165929PA7955162023-01-17False
16060000016603L16/dossiers16160600000165921606000001659210PA7944022023-01-17False
16060000016604L16/dossiers16160600000165921606000001659211PA7936882023-01-17False
16060000016605L16/dossiers16160600000165921606000001659212PA7957942023-01-17False
16060000016606L16/dossiers16160600000165921606000001659213PA7937562023-01-17False
16060000016607L16/dossiers16160600000165921606000001659214PA7960622023-01-17False
16060000016608L16/dossiers16160600000165921606000001659215PA7195782023-01-17False
16060000016609L16/dossiers16160600000165921606000001659216PA7210622023-01-17False
16060000016610L16/dossiers16160600000165921606000001659217PA7938842023-01-17False
16060000016614L16/dossiers1616060000016612160600000166121PA6428472023-01-17False
16060000016615L16/dossiers1616060000016612160600000166122PA7188842023-01-17False
16060000016616L16/dossiers1616060000016612160600000166123PA3422402023-01-17False
16060000016617L16/dossiers1616060000016612160600000166124PA7935082023-01-17False
16060000016618L16/dossiers1616060000016612160600000166125PA7188382023-01-17False