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
17090000014574L17/questions_ecrites1717090000014565170900000145651JO_QUESTION2026-05-2620260021
17090000014618L17/questions_ecrites1717090000014614170900000146141JO_QUESTION2026-06-3020260026
17090000014666L17/questions_ecrites1717090000014663170900000146631JO_QUESTION2026-05-2620260021
17090000014667L17/questions_ecrites1717090000014663170900000146632JO_QUESTION2026-09-0820260036
17090000014680L17/questions_ecrites1717090000014672170900000146721JO_QUESTION2025-05-2720250021
17090000014721L17/questions_ecrites1717090000014718170900000147181JO_QUESTION2026-07-2120260029
17090000014732L17/questions_ecrites1717090000014722170900000147221JO_QUESTION2025-01-2820250004
17090000014733L17/questions_ecrites1717090000014722170900000147222JO_QUESTION2025-05-0620250018
17090000014734L17/questions_ecrites1717090000014722170900000147223JO_QUESTION2025-09-0220250035
17090000014749L17/questions_ecrites1717090000014746170900000147461JO_QUESTION2026-06-2320260025
17090000014800L17/questions_ecrites1717090000014796170900000147961JO_QUESTION2026-09-2220260038
17090000014869L17/questions_ecrites1717090000014864170900000148641JO_QUESTION2025-02-1120250006
17090000014870L17/questions_ecrites1717090000014864170900000148642JO_QUESTION2025-05-2720250021
17090000014871L17/questions_ecrites1717090000014864170900000148643JO_QUESTION2025-09-0220250035
17090000014921L17/questions_ecrites1717090000014914170900000149141JO_QUESTION2025-02-0420250005
17090000014922L17/questions_ecrites1717090000014914170900000149142JO_QUESTION2025-05-1320250019
17090000014923L17/questions_ecrites1717090000014914170900000149143JO_QUESTION2025-09-0920250036
17090000014924L17/questions_ecrites1717090000014914170900000149144JO_QUESTION2025-12-1620250050
17090000014925L17/questions_ecrites1717090000014914170900000149145JO_QUESTION2026-03-2420260012
17090000014969L17/questions_ecrites1717090000014964170900000149641JO_QUESTION2025-02-1120250006
17090000014970L17/questions_ecrites1717090000014964170900000149642JO_QUESTION2025-05-2720250021
17090000014971L17/questions_ecrites1717090000014964170900000149643JO_QUESTION2025-09-0220250035
17090000015070L17/questions_ecrites1717090000015065170900000150651JO_QUESTION2025-02-1120250006
17090000015089L17/questions_ecrites1717090000015086170900000150861JO_QUESTION2026-05-2620260021
17090000015124L17/questions_ecrites1717090000015121170900000151211JO_QUESTION2026-07-2120260029
17090000015143L17/questions_ecrites1717090000015138170900000151381JO_QUESTION2026-06-0220260022
17090000015234L17/questions_ecrites1717090000015231170900000152311JO_QUESTION2026-06-0220260022
17090000015291L17/questions_ecrites1717090000015286170900000152861JO_QUESTION2025-02-0420250005
17090000015292L17/questions_ecrites1717090000015286170900000152862JO_QUESTION2025-05-2020250020
17090000015337L17/questions_ecrites1717090000015332170900000153321JO_QUESTION2025-05-2020250020
17090000015402L17/questions_ecrites1717090000015399170900000153991JO_QUESTION2026-06-0220260022
17090000015403L17/questions_ecrites1717090000015399170900000153992JO_QUESTION2026-09-0820260036
17090000015445L17/questions_ecrites1717090000015441170900000154411JO_QUESTION2026-06-1620260024
17090000015480L17/questions_ecrites1717090000015473170900000154731JO_QUESTION2025-01-2820250004
17090000015481L17/questions_ecrites1717090000015473170900000154732JO_QUESTION2025-05-0620250018
17090000015482L17/questions_ecrites1717090000015473170900000154733JO_QUESTION2025-09-0220250035
17090000015483L17/questions_ecrites1717090000015473170900000154734JO_QUESTION2025-12-1620250050
17090000015493L17/questions_ecrites1717090000015488170900000154881JO_QUESTION2026-06-0220260022
17090000015499L17/questions_ecrites1717090000015494170900000154941JO_QUESTION2026-06-0220260022
17090000015500L17/questions_ecrites1717090000015494170900000154942JO_QUESTION2026-09-2220260038
17090000015516L17/questions_ecrites1717090000015511170900000155111JO_QUESTION2026-06-1620260024
17090000015543L17/questions_ecrites1717090000015535170900000155351JO_QUESTION2025-07-2920250030
17090000015544L17/questions_ecrites1717090000015535170900000155352JO_QUESTION2025-11-2520250047
17090000015581L17/questions_ecrites1717090000015576170900000155761JO_QUESTION2026-06-0220260022
17090000015703L17/questions_ecrites1717090000015700170900000157001JO_QUESTION2026-09-1520260037
17090000015710L17/questions_ecrites1717090000015707170900000157071JO_QUESTION2026-06-1620260024
17090000015722L17/questions_ecrites1717090000015718170900000157181JO_QUESTION2026-06-0220260022
17090000015763L17/questions_ecrites1717090000015757170900000157571JO_QUESTION2026-06-0920260023
17090000015786L17/questions_ecrites1717090000015781170900000157811JO_QUESTION2025-02-2520250008
17090000015804L17/questions_ecrites1717090000015801170900000158011JO_QUESTION2026-06-0220260022