AN · données ouvertes
Explorateur / questions_ecrites

questions_ecrites.question_renouvellement

Chemin question.renouvellements.renouvellement · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %

85 044 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…)
7info_jo_type_joVARCHARquestion.renouvellements.renouvellement.infoJO.typeJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
8info_jo_date_joVARCHARquestion.renouvellements.renouvellement.infoJO.dateJO · présence : L17 11 %, L16 10 %, L15 14 %, L14 23 %
9info_jo_page_joVARCHARquestion.renouvellements.renouvellement.infoJO.pageJO · présence : L17 11 %, L16 10 %
10info_jo_num_joBIGINTquestion.renouvellements.renouvellement.infoJO.numJO · présence : L17 11 %, L16 10 %
11info_jo_url_legifranceVARCHARquestion.renouvellements.renouvellement.infoJO.urlLegifrance · présence : L17 11 %, L16 10 %
12info_jo_reference_norVARCHARquestion.renouvellements.renouvellement.infoJO.referenceNOR · présence : L17 11 %, L16 10 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreinfo_jo_type_joinfo_jo_date_joinfo_jo_page_joinfo_jo_num_joinfo_jo_url_legifranceinfo_jo_reference_nor
17090000050528L17/questions_ecrites1717090000050521170900000505212JO_QUESTION2025-09-0920250036
17090000050529L17/questions_ecrites1717090000050521170900000505213JO_QUESTION2025-12-1620250050
17090000050530L17/questions_ecrites1717090000050521170900000505214JO_QUESTION2026-03-2420260012
17090000050537L17/questions_ecrites1717090000050531170900000505311JO_QUESTION2025-05-1320250019
17090000050538L17/questions_ecrites1717090000050531170900000505312JO_QUESTION2025-09-0220250035
17090000050539L17/questions_ecrites1717090000050531170900000505313JO_QUESTION2025-12-1620250050
17090000050540L17/questions_ecrites1717090000050531170900000505314JO_QUESTION2026-03-2420260012
17090000050547L17/questions_ecrites1717090000050541170900000505411JO_QUESTION2025-11-1820250046
17090000050581L17/questions_ecrites1717090000050574170900000505741JO_QUESTION2025-12-0220250048
17090000050603L17/questions_ecrites1717090000050599170900000505991JO_QUESTION2025-05-2720250021
17090000050626L17/questions_ecrites1717090000050621170900000506211JO_QUESTION2025-05-1320250019
17090000050643L17/questions_ecrites1717090000050638170900000506381JO_QUESTION2025-03-0420250009
17090000050688L17/questions_ecrites1717090000050684170900000506841JO_QUESTION2025-05-1320250019
17090000050746L17/questions_ecrites1717090000050741170900000507411JO_QUESTION2025-05-1320250019
17090000050747L17/questions_ecrites1717090000050741170900000507412JO_QUESTION2025-08-1920250033
17090000050748L17/questions_ecrites1717090000050741170900000507413JO_QUESTION2025-11-2520250047
17090000050749L17/questions_ecrites1717090000050741170900000507414JO_QUESTION2026-03-2420260012
17090000050750L17/questions_ecrites1717090000050741170900000507415JO_QUESTION2026-07-1420260028
17090000050782L17/questions_ecrites1717090000050775170900000507751JO_QUESTION2026-09-0820260036
17090000050929L17/questions_ecrites1717090000050922170900000509221JO_QUESTION2025-01-2120250003
17090000050930L17/questions_ecrites1717090000050922170900000509222JO_QUESTION2025-04-2920250017
17090000050931L17/questions_ecrites1717090000050922170900000509223JO_QUESTION2025-08-0520250031
17090000050936L17/questions_ecrites1717090000050932170900000509321JO_QUESTION2025-05-2020250020
17090000050941L17/questions_ecrites1717090000050937170900000509371JO_QUESTION2025-05-2020250020
17090000050977L17/questions_ecrites1717090000050972170900000509721JO_QUESTION2025-05-2720250021
17090000050978L17/questions_ecrites1717090000050972170900000509722JO_QUESTION2025-09-3020250039
17090000050979L17/questions_ecrites1717090000050972170900000509723JO_QUESTION2026-01-2720260004
17090000050980L17/questions_ecrites1717090000050972170900000509724JO_QUESTION2026-06-0220260022
17090000050981L17/questions_ecrites1717090000050972170900000509725JO_QUESTION2026-09-0820260036
17090000051002L17/questions_ecrites1717090000050997170900000509971JO_QUESTION2025-11-1820250046
17090000051003L17/questions_ecrites1717090000050997170900000509972JO_QUESTION2026-09-0120260035
17090000051014L17/questions_ecrites1717090000051009170900000510091JO_QUESTION2025-05-1320250019
17090000051015L17/questions_ecrites1717090000051009170900000510092JO_QUESTION2025-09-0920250036
17090000051016L17/questions_ecrites1717090000051009170900000510093JO_QUESTION2025-12-1620250050
17090000051017L17/questions_ecrites1717090000051009170900000510094JO_QUESTION2026-03-2420260012
17090000051085L17/questions_ecrites1717090000051079170900000510791JO_QUESTION2026-03-3120260013
17090000051094L17/questions_ecrites1717090000051086170900000510861JO_QUESTION2025-07-0120250026
17090000051103L17/questions_ecrites1717090000051095170900000510951JO_QUESTION2025-12-0220250048
17090000051117L17/questions_ecrites1717090000051112170900000511121JO_QUESTION2025-06-0320250022
17090000051118L17/questions_ecrites1717090000051112170900000511122JO_QUESTION2026-07-2120260029
17090000051238L17/questions_ecrites1717090000051232170900000512321JO_QUESTION2025-01-1420250002
17090000051244L17/questions_ecrites1717090000051239170900000512391JO_QUESTION2025-05-2720250021
17090000051245L17/questions_ecrites1717090000051239170900000512392JO_QUESTION2025-09-2320250038
17090000051246L17/questions_ecrites1717090000051239170900000512393JO_QUESTION2026-05-0520260018
17090000051247L17/questions_ecrites1717090000051239170900000512394JO_QUESTION2026-09-0820260036
17090000051286L17/questions_ecrites1717090000051282170900000512821JO_QUESTION2025-05-1320250019
17090000051301L17/questions_ecrites1717090000051296170900000512961JO_QUESTION2025-02-1120250006
17090000051336L17/questions_ecrites1717090000051330170900000513301JO_QUESTION2025-06-0320250022
17090000051337L17/questions_ecrites1717090000051330170900000513302JO_QUESTION2025-11-0420250044
17090000051438L17/questions_ecrites1717090000051432170900000514321JO_QUESTION2025-06-2420250025