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
17090000056786L17/questions_ecrites1717090000056779170900000567791JO_QUESTION2025-01-1420250002
17090000056811L17/questions_ecrites1717090000056804170900000568041JO_QUESTION2025-10-2120250042
17090000056820L17/questions_ecrites1717090000056816170900000568161JO_QUESTION2025-06-1020250023
17090000056838L17/questions_ecrites1717090000056833170900000568331JO_QUESTION2026-01-1320260002
17090000056897L17/questions_ecrites1717090000056892170900000568921JO_QUESTION2025-02-1120250006
17090000056922L17/questions_ecrites1717090000056915170900000569151JO_QUESTION2025-10-2120250042
17090000056974L17/questions_ecrites1717090000056969170900000569691JO_QUESTION2026-04-1420260015
17090000057043L17/questions_ecrites1717090000057036170900000570361JO_QUESTION2026-03-0320260009
17090000057044L17/questions_ecrites1717090000057036170900000570362JO_QUESTION2026-07-2120260029
17090000057061L17/questions_ecrites1717090000057054170900000570541JO_QUESTION2025-09-2320250038
17090000057062L17/questions_ecrites1717090000057054170900000570542JO_QUESTION2026-05-1920260020
17090000057085L17/questions_ecrites1717090000057078170900000570781JO_QUESTION2025-01-2820250004
17090000057086L17/questions_ecrites1717090000057078170900000570782JO_QUESTION2025-05-0620250018
17090000057087L17/questions_ecrites1717090000057078170900000570783JO_QUESTION2025-09-0220250035
17090000057126L17/questions_ecrites1717090000057122170900000571221JO_QUESTION2025-07-0820250027
17090000057133L17/questions_ecrites1717090000057127170900000571271JO_QUESTION2025-06-2420250025
17090000057134L17/questions_ecrites1717090000057127170900000571272JO_QUESTION2025-11-0420250044
17090000057165L17/questions_ecrites1717090000057158170900000571581JO_QUESTION2025-06-1720250024
17090000057166L17/questions_ecrites1717090000057158170900000571582JO_QUESTION2025-09-2320250038
17090000057167L17/questions_ecrites1717090000057158170900000571583JO_QUESTION2026-01-0620260001
17090000057200L17/questions_ecrites1717090000057196170900000571961JO_QUESTION2025-06-1720250024
17090000057223L17/questions_ecrites1717090000057219170900000572191JO_QUESTION2025-06-2420250025
17090000057230L17/questions_ecrites1717090000057224170900000572241JO_QUESTION2025-11-0420250044
17090000057254L17/questions_ecrites1717090000057246170900000572461JO_QUESTION2025-07-2220250029
17090000057268L17/questions_ecrites1717090000057263170900000572631JO_QUESTION2025-07-2220250029
17090000057292L17/questions_ecrites1717090000057283170900000572831JO_QUESTION2025-10-2120250042
17090000057371L17/questions_ecrites1717090000057365170900000573651JO_QUESTION2025-07-0820250027
17090000057416L17/questions_ecrites1717090000057408170900000574081JO_QUESTION2025-07-0820250027
17090000057417L17/questions_ecrites1717090000057408170900000574082JO_QUESTION2025-10-2120250042
17090000057418L17/questions_ecrites1717090000057408170900000574083JO_QUESTION2026-01-2720260004
17090000057419L17/questions_ecrites1717090000057408170900000574084JO_QUESTION2026-05-1220260019
17090000057657L17/questions_ecrites1717090000057652170900000576521JO_QUESTION2025-07-0120250026
17090000057695L17/questions_ecrites1717090000057690170900000576901JO_QUESTION2025-01-0720250001
17090000057787L17/questions_ecrites1717090000057779170900000577791JO_QUESTION2026-03-1020260010
17090000057824L17/questions_ecrites1717090000057819170900000578191JO_QUESTION2025-06-2420250025
17090000057825L17/questions_ecrites1717090000057819170900000578192JO_QUESTION2025-09-3020250039
17090000057826L17/questions_ecrites1717090000057819170900000578193JO_QUESTION2026-01-2720260004
17090000057827L17/questions_ecrites1717090000057819170900000578194JO_QUESTION2026-06-0220260022
17090000057828L17/questions_ecrites1717090000057819170900000578195JO_QUESTION2026-09-0820260036
17090000057920L17/questions_ecrites1717090000057913170900000579131JO_QUESTION2025-11-1120250045
17090000057921L17/questions_ecrites1717090000057913170900000579132JO_QUESTION2026-04-0720260014
17090000057929L17/questions_ecrites1717090000057922170900000579221JO_QUESTION2025-12-1620250050
17090000057953L17/questions_ecrites1717090000057947170900000579471JO_QUESTION2026-06-2320260025
17090000057986L17/questions_ecrites1717090000057979170900000579791JO_QUESTION2026-03-1020260010
17090000057987L17/questions_ecrites1717090000057979170900000579792JO_QUESTION2026-06-1620260024
17090000058022L17/questions_ecrites1717090000058017170900000580171JO_QUESTION2025-06-1720250024
17090000058115L17/questions_ecrites1717090000058109170900000581091JO_QUESTION2025-06-2420250025
17090000058174L17/questions_ecrites1717090000058169170900000581691JO_QUESTION2025-06-2420250025
17090000058256L17/questions_ecrites1717090000058250170900000582501JO_QUESTION2025-01-1420250002
17090000058332L17/questions_ecrites1717090000058323170900000583231JO_QUESTION2026-03-0320260009