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
17090000055534L17/questions_ecrites1717090000055528170900000555281JO_QUESTION2025-06-0320250022
17090000055535L17/questions_ecrites1717090000055528170900000555282JO_QUESTION2025-10-2120250042
17090000055549L17/questions_ecrites1717090000055544170900000555441JO_QUESTION2025-03-0420250009
17090000055556L17/questions_ecrites1717090000055550170900000555501JO_QUESTION2025-12-0220250048
17090000055557L17/questions_ecrites1717090000055550170900000555502JO_QUESTION2026-05-1220260019
17090000055593L17/questions_ecrites1717090000055587170900000555871JO_QUESTION2025-06-0320250022
17090000055739L17/questions_ecrites1717090000055733170900000557331JO_QUESTION2025-12-2320250051
17090000055746L17/questions_ecrites1717090000055740170900000557401JO_QUESTION2025-01-0720250001
17090000055747L17/questions_ecrites1717090000055740170900000557402JO_QUESTION2025-06-1720250024
17090000055748L17/questions_ecrites1717090000055740170900000557403JO_QUESTION2025-10-2120250042
17090000055749L17/questions_ecrites1717090000055740170900000557404JO_QUESTION2026-02-1720260007
17090000055807L17/questions_ecrites1717090000055802170900000558021JO_QUESTION2025-01-2820250004
17090000055808L17/questions_ecrites1717090000055802170900000558022JO_QUESTION2025-05-0620250018
17090000055864L17/questions_ecrites1717090000055860170900000558601JO_QUESTION2025-06-0320250022
17090000055879L17/questions_ecrites1717090000055873170900000558731JO_QUESTION2025-06-0320250022
17090000055880L17/questions_ecrites1717090000055873170900000558732JO_QUESTION2025-10-2820250043
17090000055934L17/questions_ecrites1717090000055929170900000559291JO_QUESTION2025-06-0320250022
17090000055935L17/questions_ecrites1717090000055929170900000559292JO_QUESTION2025-09-0920250036
17090000055936L17/questions_ecrites1717090000055929170900000559293JO_QUESTION2025-12-1620250050
17090000055937L17/questions_ecrites1717090000055929170900000559294JO_QUESTION2026-03-2420260012
17090000055938L17/questions_ecrites1717090000055929170900000559295JO_QUESTION2026-06-3020260026
17090000055951L17/questions_ecrites1717090000055947170900000559471JO_QUESTION2025-06-0320250022
17090000055964L17/questions_ecrites1717090000055958170900000559581JO_QUESTION2025-06-1020250023
17090000055987L17/questions_ecrites1717090000055982170900000559821JO_QUESTION2025-10-2120250042
17090000056028L17/questions_ecrites1717090000056022170900000560221JO_QUESTION2025-01-2820250004
17090000056097L17/questions_ecrites1717090000056092170900000560921JO_QUESTION2025-11-1820250046
17090000056098L17/questions_ecrites1717090000056092170900000560922JO_QUESTION2026-09-0120260035
17090000056106L17/questions_ecrites1717090000056099170900000560991JO_QUESTION2026-06-1620260024
17090000056118L17/questions_ecrites1717090000056114170900000561141JO_QUESTION2025-07-2920250030
17090000056126L17/questions_ecrites1717090000056119170900000561191JO_QUESTION2025-07-0820250027
17090000056198L17/questions_ecrites1717090000056194170900000561941JO_QUESTION2025-06-1020250023
17090000056236L17/questions_ecrites1717090000056230170900000562301JO_QUESTION2025-10-2120250042
17090000056245L17/questions_ecrites1717090000056241170900000562411JO_QUESTION2025-06-1020250023
17090000056251L17/questions_ecrites1717090000056246170900000562461JO_QUESTION2025-10-2120250042
17090000056256L17/questions_ecrites1717090000056252170900000562521JO_QUESTION2025-06-1020250023
17090000056262L17/questions_ecrites1717090000056257170900000562571JO_QUESTION2025-06-1020250023
17090000056298L17/questions_ecrites1717090000056292170900000562921JO_QUESTION2025-06-1020250023
17090000056403L17/questions_ecrites1717090000056398170900000563981JO_QUESTION2025-06-1020250023
17090000056423L17/questions_ecrites1717090000056417170900000564171JO_QUESTION2025-10-2120250042
17090000056434L17/questions_ecrites1717090000056428170900000564281JO_QUESTION2025-01-2820250004
17090000056495L17/questions_ecrites1717090000056489170900000564891JO_QUESTION2025-10-2120250042
17090000056545L17/questions_ecrites1717090000056537170900000565371JO_QUESTION2025-12-0220250048
17090000056546L17/questions_ecrites1717090000056537170900000565372JO_QUESTION2026-05-1220260019
17090000056630L17/questions_ecrites1717090000056625170900000566251JO_QUESTION2025-06-1720250024
17090000056647L17/questions_ecrites1717090000056641170900000566411JO_QUESTION2025-10-2120250042
17090000056669L17/questions_ecrites1717090000056663170900000566631JO_QUESTION2025-10-2120250042
17090000056683L17/questions_ecrites1717090000056676170900000566761JO_QUESTION2025-10-2120250042
17090000056715L17/questions_ecrites1717090000056709170900000567091JO_QUESTION2025-01-2820250004
17090000056721L17/questions_ecrites1717090000056716170900000567161JO_QUESTION2025-10-2120250042
17090000056752L17/questions_ecrites1717090000056746170900000567461JO_QUESTION2025-10-2120250042