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
17060000029473L17/dossiers17170600000294261706000002942646PA3096432025-04-30False
17060000029474L17/dossiers17170600000294261706000002942647PA7947022025-04-30False
17060000029475L17/dossiers17170600000294261706000002942648PA7948102025-04-30False
17060000029476L17/dossiers17170600000294261706000002942649PA7952702025-04-30False
17060000029477L17/dossiers17170600000294261706000002942650PA8414312025-04-30False
17060000029478L17/dossiers17170600000294261706000002942651PA2677802025-04-30False
17060000029479L17/dossiers17170600000294261706000002942652PA7120142025-04-30False
17060000029480L17/dossiers17170600000294261706000002942653PA6081722025-04-30False
17060000029481L17/dossiers17170600000294261706000002942654PA7952402025-04-30False
17060000029482L17/dossiers17170600000294261706000002942655PA7934162025-04-30False
17060000029483L17/dossiers17170600000294261706000002942656PA8416012025-04-30False
17060000029484L17/dossiers17170600000294261706000002942657PA7190802025-04-30False
17060000029485L17/dossiers17170600000294261706000002942658PA7959622025-04-30False
17060000029486L17/dossiers17170600000294261706000002942659PA7937082025-04-30False
17060000029487L17/dossiers17170600000294261706000002942660PA7955282025-04-30False
17060000029488L17/dossiers17170600000294261706000002942661PA7200222025-04-30False
17060000029489L17/dossiers17170600000294261706000002942662PA8172032025-04-30False
17060000029490L17/dossiers17170600000294261706000002942663PA7948542025-04-30False
17060000029494L17/dossiers1717060000029492170600000294921PA8408292025-03-11False
17060000029495L17/dossiers1717060000029492170600000294922PA6067932025-03-11False
17060000029496L17/dossiers1717060000029492170600000294923PA8413152025-03-11False
17060000029497L17/dossiers1717060000029492170600000294924PA7940942025-03-11False
17060000029498L17/dossiers1717060000029492170600000294925PA7936242025-03-11False
17060000029499L17/dossiers1717060000029492170600000294926PA6082642025-03-11False
17060000029500L17/dossiers1717060000029492170600000294927PA8412952025-03-11False
17060000029501L17/dossiers1717060000029492170600000294928PA10082025-03-11False
17060000029502L17/dossiers1717060000029492170600000294929PA7954302025-03-11False
17060000029503L17/dossiers17170600000294921706000002949210PA8419192025-03-11False
17060000029504L17/dossiers17170600000294921706000002949211PA8416332025-03-11False
17060000029505L17/dossiers17170600000294921706000002949212PA7948542025-03-11False
17060000029506L17/dossiers17170600000294921706000002949213PA8421952025-03-11False
17060000029507L17/dossiers17170600000294921706000002949214PA6093322025-03-11False
17060000029508L17/dossiers17170600000294921706000002949215PA8409392025-03-11False
17060000029509L17/dossiers17170600000294921706000002949216PA8415392025-03-11False
17060000029510L17/dossiers17170600000294921706000002949217PA3319732025-03-11False
17060000029511L17/dossiers17170600000294921706000002949218PA8422632025-03-11False
17060000029512L17/dossiers17170600000294921706000002949219PA8418532025-03-11False
17060000029513L17/dossiers17170600000294921706000002949220PA6431922025-03-11False
17060000029514L17/dossiers17170600000294921706000002949221PA7951562025-03-11False
17060000029515L17/dossiers17170600000294921706000002949222PA6431572025-03-11False
17060000029516L17/dossiers17170600000294921706000002949223PA8411072025-03-11False
17060000029517L17/dossiers17170600000294921706000002949224PA8407932025-03-11False
17060000029518L17/dossiers17170600000294921706000002949225PA7942702025-03-11False
17060000029519L17/dossiers17170600000294921706000002949226PA6075532025-03-11False
17060000029520L17/dossiers17170600000294921706000002949227PA8409552025-03-11False
17060000029521L17/dossiers17170600000294921706000002949228PA8406732025-03-11False
17060000029522L17/dossiers17170600000294921706000002949229PA3421962025-03-11False
17060000029523L17/dossiers17170600000294921706000002949230PA7749602025-03-11False
17060000029524L17/dossiers17170600000294921706000002949231PA3403432025-03-11False
17060000029525L17/dossiers17170600000294921706000002949232PA8410912025-03-11False