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
16060000016110L16/dossiers161606000001596416060000015964145PA7572252023-01-09False
16060000016111L16/dossiers161606000001596416060000015964146PA7934162023-01-09False
16060000016112L16/dossiers161606000001596416060000015964147PA7948022023-01-09False
16060000016113L16/dossiers161606000001596416060000015964148PA7196722023-01-09False
16060000016114L16/dossiers161606000001596416060000015964149PA7201902023-01-09False
16060000016115L16/dossiers161606000001596416060000015964150PA7944862023-01-09False
16060000016116L16/dossiers161606000001596416060000015964151PA7207542023-01-09False
16060000016117L16/dossiers161606000001596416060000015964152PA7195502023-01-09False
16060000016118L16/dossiers161606000001596416060000015964153PA7949302023-01-09False
16060000016119L16/dossiers161606000001596416060000015964154PA7215842023-01-09False
16060000016120L16/dossiers161606000001596416060000015964155PA7959202023-01-09False
16060000016121L16/dossiers161606000001596416060000015964156PA7200142023-01-09False
16060000016122L16/dossiers161606000001596416060000015964157PA6073952023-01-09False
16060000016123L16/dossiers161606000001596416060000015964158PA7214822023-01-09False
16060000016124L16/dossiers161606000001596416060000015964159PA7221022023-01-09False
16060000016125L16/dossiers161606000001596416060000015964160PA6066392023-01-09False
16060000016126L16/dossiers161606000001596416060000015964161PA7195122023-01-09False
16060000016127L16/dossiers161606000001596416060000015964162PA7211702023-01-09False
16060000016128L16/dossiers161606000001596416060000015964163PA7931942023-01-09False
16060000016129L16/dossiers161606000001596416060000015964164PA7212622023-01-09False
16060000016130L16/dossiers161606000001596416060000015964165PA7953262023-01-09False
16060000016131L16/dossiers161606000001596416060000015964166PA29602023-01-09False
16060000016132L16/dossiers161606000001596416060000015964167PA7950462023-01-09False
16060000016133L16/dossiers161606000001596416060000015964168PA7189622023-01-09False
16060000016138L16/dossiers1616060000016136160600000161361PA2674292023-01-11False
16060000016143L16/dossiers1616060000016140160600000161401PA7220382023-01-13False
16060000016144L16/dossiers1616060000016140160600000161402PA7193182023-01-13False
16060000016145L16/dossiers1616060000016140160600000161403PA7961182023-01-13False
16060000016146L16/dossiers1616060000016140160600000161404PA6431432023-01-13False
16060000016147L16/dossiers1616060000016140160600000161405PA7932382023-01-13False
16060000016148L16/dossiers1616060000016140160600000161406PA7931582023-01-13False
16060000016149L16/dossiers1616060000016140160600000161407PA7944342023-01-13False
16060000016150L16/dossiers1616060000016140160600000161408PA7945222023-01-13False
16060000016151L16/dossiers1616060000016140160600000161409PA3096432023-01-13False
16060000016152L16/dossiers16160600000161401606000001614010PA7208222023-01-13False
16060000016153L16/dossiers16160600000161401606000001614011PA7206682023-01-13False
16060000016154L16/dossiers16160600000161401606000001614012PA7960422023-01-13False
16060000016155L16/dossiers16160600000161401606000001614013PA2667932023-01-13False
16060000016156L16/dossiers16160600000161401606000001614014PA7938442023-01-13False
16060000016157L16/dossiers16160600000161401606000001614015PA3422402023-01-13False
16060000016158L16/dossiers16160600000161401606000001614016PA7931822023-01-13False
16060000016159L16/dossiers16160600000161401606000001614017PA2677662023-01-13False
16060000016160L16/dossiers16160600000161401606000001614018PA7188382023-01-13False
16060000016161L16/dossiers16160600000161401606000001614019PA7931342023-01-13False
16060000016162L16/dossiers16160600000161401606000001614020PA7191382023-01-13False
16060000016163L16/dossiers16160600000161401606000001614021PA7946382023-01-13False
16060000016164L16/dossiers16160600000161401606000001614022PA7204682023-01-13False
16060000016165L16/dossiers16160600000161401606000001614023PA7935482023-01-13False
16060000016166L16/dossiers16160600000161401606000001614024PA7192662023-01-13False
16060000016167L16/dossiers16160600000161401606000001614025PA7933222023-01-13False